Airports

idNameIATA_CodeICAA_CodeLatitudeLongitudeElevationTimezoneDirection_IndicatorSurface_AreaMovement_AreaRunway_LengthCityStatePhone_NumberWebsiteEmailYear_Established
1John F Kennedy International AirportJFKN7988-73.6954-40.645213-5R1627.41627.43147.0New YorkQueens+1-800-222-1222https://www.jfkairport.com/info@jfkairport.com1943
2Los Angeles International AirportLAXLACI-118.405333.9435279-8W2560.02560.09899.0Los AngelesLos Angeles County+1-855-463-5252https://www.flylax.com/information@flylax.com1937

Flights

Flight_IDOrigin_AirportDestination_AirportDeparture_TimeArrival_TimeCarrier_AirlinesAircraft_TypeNumber_of_PassengersFlight_StatusGate_Number
1JFKLAX2023-01-01 08:00:002023-01-01 11:00:00American AirlinesBoeing 787 Dreamliner250On Time10
2Dallas/Fort Worth International AirportHeathrow Airport2023-01-02 14:00:002023-01-02 19:00:00British AirwaysBoeing 747 Jumbo Jet300On Time15

Pilots

Pilot_IdFirstNameLastNameLicense_NumberDate_Of_BirthTotal_Flight_HoursRatingCurrent_AssignmentHire_Date
1JohnSmithABCD12341985-06-155000ATPCaptain2015-01-01
2JaneDoeEFGH56781990-09-204000ATPCo-pilot2018-01-01

Passengers

Passenger_IdFirstNameLastNameDate_Of_BirthNationalityPassport_NumberContact_Phone_NumberSeat_PreferenceSpecial_Assistance
1AliceJohnson1985-07-25USAUS123456789+1-555-123-4567Window0
2BobWilliams1990-03-10UKGB987654321+44-777-123-4567Aisle1

Baggage

Bag_IdFlight_IdOwner_FirstNameOwner_LastNameSize_InchesWeight_KgsDescriptionStatus
(→ Flights.Flight_Id)
11JohnSmith22x15x1010.0Business suit and laptopChecked
22JaneDoe21x14x98.0Personal items and toiletriesCarry on

Aircrafts

Aircraft_IdModel_NameManufacturerRegistration_MarkTypeCapacityRange_MilesMaximum_SpeedCruise_SpeedService_CeilingOperator_Id
(→ Airlines.Airline_Id)
1Boeing 787-8BoeingN123BAPassenger26570000.850.8410001
2Airbus A320neoAirbusF-HSEZPassenger18031000.850.8430002