Airports

Airport_CodeAirport_NameCountryCityElevationTimezoneIATA_CodeLatitudeLongitude
JFKJohn F. Kennedy International AirportUSANew York3-05:00JFK40.6418-73.7789
LAXLos Angeles International AirportUSALos Angeles239-08:00LAX33.9451-118.4052
YYZToronto Pearson International AirportCanadaToronto253-05:00YYZ55.6815-79.4536
DUBDublin AirportIrelandDublin75GMT+00:00DUB53.3749-6.1432
NRTTokyo Haneda AirportJapanTokyo13JST+09:00NRT35.6051139.7691

Airlines

Airline_CodeAirline_NameHeadquarters_CityWebsite
AAAmerican AirlinesFort Worthhttps://www.aa.com
DLDelta Air LinesAtlantahttps://www.delta.com
UAUnited AirlinesChicagohttps://www.united.com
BABritish AirwaysLondonhttps://www.britishairways.com
LULuftansaFrankfurthttps://www.luftansa.com

Pilots

Pilot_IDFirst_NameLast_NameDate_Of_BirthLicense_NumberLicense_Issue_DateRatingAirline_Code
(→ Airlines.Airline_Code)
1JohnSmith1990-01-01123ABCD2015-01-01ATPAA
2JaneDoe1992-02-02XYZWEE2016-02-02ATPUA
3MichaelJackson1991-03-03ABCDEF2017-03-03ATPDL
4EmmaSwift1993-04-04GIHJKL2018-04-04ATPBA
5PaulMcCartney1942-06-06LMNOPQ1964-06-06ATPLU

Planes

Plane_IDRegistration_NumberModel_NameManufacturer_NameYear_ManufacturedCapacityPilot_ID
(→ Pilots.Pilot_ID)
1N12345Boeing 737-800Boeing20102001
2EI-DVBAirbus A320neoAirbus20151802
3VY-BCREmbraer E190Embraer20081003
4SE-RMLBombardier CRJ900Bombardier2006884
5EC-IXQAirbus A380-800Airbus20125005

Maintenance_Records

Record_IDPlane_IDWork_Order_DescriptionStart_DateTimeEnd_DateTimeTotal_Hours_WorkedCost
(→ Planes.Plane_ID)
11Engine overhaul2021-01-01 08:00:002021-01-02 18:00:0012.015000.0
22Landing gear repair2021-02-01 08:00:002021-02-02 18:00:0010.010000.0
33Interior cleaning and refurbishment2021-03-01 08:00:002021-03-05 18:00:0040.08000.0
44Avionics upgrade2021-04-01 08:00:002021-04-03 18:00:0024.020000.0
55Wing inspection2021-05-01 08:00:002021-05-02 18:00:008.05000.0