| 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 |