Airports

idnamecitycountry
1JFK InternationalNew York CityUSA
2Los Angeles InternationalLos AngelesUSA
3Dubai InternationalDubaiUAE
4Heathrow AirportLondonUK
5Charles de Gaulle AirportParisFrance

Runways

idlengthwidthsurfaceTypeairportId
(→ Airports.id)
19876.5150.0Asphalt1
210000.0200.0Concrete2
38500.0180.0Grass3
47500.0160.0Concrete4
59999.0210.0Asphalt5

Taxiways

idlengthwidthsurfaceTypeairportId
(→ Airports.id)
12000.0150.0Asphalt1
22200.0160.0Concrete2
31800.0140.0Grass3
42500.0170.0Concrete4
52100.0180.0Asphalt5

Infrastructures

idtypeconstructionDatedescriptionairportId
(→ Airports.id)
1Runway2015-01-01This runway was built on January 1st, 2015.1
2Terminal Building2010-03-01This terminal building was constructed on March 1st, 2010.2
3Runway2018-06-01This runway opened on June 1st, 2018.3
4Taxiway2015-01-01This taxiway has been in operation since its opening date of January 1st, 2015.4
5Control Tower2013-02-01The control tower started operations on February 1st, 2013.5