Airport_Code | Airport_Name | Country | City | Elevation | Timezone | IATA_Code | Latitude | Longitude |
---|---|---|---|---|---|---|---|---|
JFK | John F. Kennedy International Airport | USA | New York | 3 | -05:00 | JFK | 40.6418 | -73.7789 |
LAX | Los Angeles International Airport | USA | Los Angeles | 239 | -08:00 | LAX | 33.9451 | -118.4052 |
YYZ | Toronto Pearson International Airport | Canada | Toronto | 253 | -05:00 | YYZ | 55.6815 | -79.4536 |
DUB | Dublin Airport | Ireland | Dublin | 75 | GMT+00:00 | DUB | 53.3749 | -6.1432 |
NRT | Tokyo Haneda Airport | Japan | Tokyo | 13 | JST+09:00 | NRT | 35.6051 | 139.7691 |
Airline_Code | Airline_Name | Headquarters_City | Website |
---|---|---|---|
AA | American Airlines | Fort Worth | https://www.aa.com |
DL | Delta Air Lines | Atlanta | https://www.delta.com |
UA | United Airlines | Chicago | https://www.united.com |
BA | British Airways | London | https://www.britishairways.com |
LU | Luftansa | Frankfurt | https://www.luftansa.com |
Pilot_ID | First_Name | Last_Name | Date_Of_Birth | License_Number | License_Issue_Date | Rating | Airline_Code |
---|---|---|---|---|---|---|---|
(→ Airlines.Airline_Code) | |||||||
1 | John | Smith | 1990-01-01 | 123ABCD | 2015-01-01 | ATP | AA |
2 | Jane | Doe | 1992-02-02 | XYZWEE | 2016-02-02 | ATP | UA |
3 | Michael | Jackson | 1991-03-03 | ABCDEF | 2017-03-03 | ATP | DL |
4 | Emma | Swift | 1993-04-04 | GIHJKL | 2018-04-04 | ATP | BA |
5 | Paul | McCartney | 1942-06-06 | LMNOPQ | 1964-06-06 | ATP | LU |
Plane_ID | Registration_Number | Model_Name | Manufacturer_Name | Year_Manufactured | Capacity | Pilot_ID |
---|---|---|---|---|---|---|
(→ Pilots.Pilot_ID) | ||||||
1 | N12345 | Boeing 737-800 | Boeing | 2010 | 200 | 1 |
2 | EI-DVB | Airbus A320neo | Airbus | 2015 | 180 | 2 |
3 | VY-BCR | Embraer E190 | Embraer | 2008 | 100 | 3 |
4 | SE-RML | Bombardier CRJ900 | Bombardier | 2006 | 88 | 4 |
5 | EC-IXQ | Airbus A380-800 | Airbus | 2012 | 500 | 5 |
Record_ID | Plane_ID | Work_Order_Description | Start_DateTime | End_DateTime | Total_Hours_Worked | Cost |
---|---|---|---|---|---|---|
(→ Planes.Plane_ID) | ||||||
1 | 1 | Engine overhaul | 2021-01-01 08:00:00 | 2021-01-02 18:00:00 | 12.0 | 15000.0 |
2 | 2 | Landing gear repair | 2021-02-01 08:00:00 | 2021-02-02 18:00:00 | 10.0 | 10000.0 |
3 | 3 | Interior cleaning and refurbishment | 2021-03-01 08:00:00 | 2021-03-05 18:00:00 | 40.0 | 8000.0 |
4 | 4 | Avionics upgrade | 2021-04-01 08:00:00 | 2021-04-03 18:00:00 | 24.0 | 20000.0 |
5 | 5 | Wing inspection | 2021-05-01 08:00:00 | 2021-05-02 18:00:00 | 8.0 | 5000.0 |