## Airports

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

## Airlines

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

## Pilots

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

## Planes

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

## Maintenance_Records

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