Flights

flightIDoriginAirportdestinationAirportdepartureTimearrivalTimeaircraftTypepassengerCount
1JFKLAX2023-03-01 07:00:002023-03-01 16:00:00Boing 787300
2ORDSEA2023-03-01 09:00:002023-03-01 18:00:00Airbus A320250
3DFWIAD2023-03-01 11:00:002023-03-01 20:00:00Boeing 737275
4YVRMCO2023-03-01 13:00:002023-03-01 22:00:00Embraer E190220
5PEKLHR2023-03-01 05:00:002023-03-01 13:00:00Air China A330310

Passengers

passengerIDfirstNamelastNamedateOfBirthgenderemailphoneNumber
1JohnDoe1990-01-01Mjohn.doe@example.com+1 555-123-4567
2JaneSmith1985-02-01Fjane.smith@example.com+1 555-987-6543
3AliceJohnson1992-03-01Falice.johnson@example.com+1 555-654-3219
4BobWilliams1988-04-01Mbob.williams@example.com+1 555-456-7890
5CharlieBrown1993-05-01Mcharlie.brown@example.com+1 555-123-4567

Unaccompanied_Minors

minorIDpassengerIDunaccompaniedBycontactInfoassistant
(→ Passengers.None)
11NoneNoneClare Allen
22David Johnson+1 555-000-0000Sam Smith
33Emily Davis+1 555-111-2222Nancy Jones
44Jack Miller+1 555-333-4444Paul Thompson
55Lucy Garcia+1 555-555-6666Rachel Brown

Special_Needs_Passengers

needsIDpassengerIDspecialNeedDescriptionadditionalInstructionsassistant
(→ Passengers.None)
11Wheelchair assistance required.Please assist with boarding.Clare Allen
22Hearing impairment.Use sign language when communicating.Carol White
33Visual impairment.Offer verbal guidance during boarding and deplaning.Tom Harris
44Diabetes.Ensure snacks and insulin are available onboard.Michael Green
55Allergic to peanuts.No peanuts should be served on this flight.Laura King

Staff

staffIDfirstNamelastNamerolehireDate
1JamesSmithPilot2020-06-01
2AnnaMartinCabin Crew2019-08-01
3SteveGarnerMaintenance Engineer2021-09-01
4HelenPriceCustomer Service Representative2022-10-01
5MarkTaylorSecurity Officer2023-01-01