Airlines

AirlineIDNameHeadquartersFoundedWebsite
1American AirlinesFort Worth, Texas1930-04-15https://www.aa.com
2United AirlinesChicago, Illinois1926-07-01https://www.united.com
3Delta Air LinesAtlanta, Georgia1928-04-17https://www.delta.com
4Southwest AirlinesDallas, Texas1967-03-15https://www.southwest.com
5JetBlue AirwaysNew York City, New York2000-02-11https://www.jetblue.com

FlightRoutes

RouteIDOriginAirportDestinationAirportDepartureTimeArrivalTimeAircraftTypeSeatsAvailable
1DFWLAX2023-03-01 07:00:002023-03-01 11:00:00Boeing 737150
2ATLORD2023-03-01 08:00:002023-03-01 12:00:00Airbus A320200
3SEASFO2023-03-01 09:00:002023-03-01 13:00:00Boeing 787250
4EWRMIA2023-03-01 10:00:002023-03-01 14:00:00Airbus A321225
5IAHLAX2023-03-01 11:00:002023-03-01 15:00:00Boeing 777300

Passengers

PassengerIDFirstNameLastNameDateOfBirthEmail
1JohnDoe1990-01-01john.doe@example.com
2JaneSmith1992-02-15jane.smith@example.com
3AliceJohnson1988-03-20alice.johnson@example.com
4BobWilliams1991-04-05bob.williams@example.com
5EmmaMartinez1993-05-10emma.martinez@example.com

BaggageLimits

LimitIDBagWeightLimitBagPieceLimitAirlinesCheckInDeadline
1302All2023-03-01 02:00:00
2403Delta2023-03-01 03:00:00
3352Southwest2023-03-01 04:00:00
4251JetBlue2023-03-01 05:00:00
5201Other2023-03-01 06:00:00

AirportFacilities

FacilityIDAirportNameTerminalCountRestaurantCountShoppingMallCountParkingCapacityWiFiAvailability
1DFW International Airport510020100001
2Los Angeles International Airport915030120001
3Hartsfield–Jackson Atlanta International Airport612040150001
4Seattle–Tacoma International Airport48025100001
5Newark Liberty International Airport36015120001

SecurityCheckpoints

CheckpointIDAirportNameLocationOpeningHoursStaffCountWaitTimes
1DFW International AirportTerminal A04:00 - 22:0010030
2Los Angeles International AirportTom Bradley International Terminal04:00 - 22:0012045
3Hartsfield–Jackson Atlanta International AirportDomestic Terminal North04:00 - 22:0015040
4Seattle–Tacoma International AirportNorth Satellite04:00 - 22:008035
5Newark Liberty International AirportTerminal A04:00 - 22:0011050