WeatherConditions

idDateTimeTemperatureWindSpeedFlightStatus
12023-01-012023-01-01 12:00:00-5.020.0Cancelled
22023-01-012023-01-01 18:00:0025.010.0On Schedule

MechanicalIssues

idAircraftIDIssueDateIssueTimeDescriptionFlightStatus
112023-01-012023-01-01 16:00:00Engine malfunctionCancelled
222023-01-012023-01-01 19:00:00Fuel leakageOn Schedule

Airports

idNameLocationIATACharICAOChar
1New York John F. Kennedy International AirportQueens, New York City, NYJFKKJFK
2Los Angeles International AirportLos Angeles County, CaliforniaLAXKLAX

Flights

idDepartureAirportIdArrivalAirportIdScheduledDepartureActualDepartureScheduledArrivalActualArrivalFlightNumber
1122023-01-01 07:00:002023-01-01 07:10:002023-01-01 10:00:002023-01-01 10:10:00101
2212023-01-01 12:00:002023-01-01 12:10:002023-01-01 15:00:002023-01-01 15:10:00202

Pilots

idFirstNameLastNameLicenseNumberRating
1JohnDoeP0123456ATPL
2JaneSmithP7890123ATPL

Passengers

idFullNameAgeTicketNumber
1Alice Johnson30301
2Bob Smith45302