Runway

IDNameLengthWidthConstruction_DateSurfaceType
1Runway A3000.075.02015-06-01Asphalt
2Runway B3500.080.02021-09-01Concrete
3Runway C2500.070.02010-08-15Grass
4Runway D2800.065.02005-01-10Asphalt
5Runway E2700.060.02008-05-01Concrete

Taxiway

IDNameLengthWidthConstruction_DateConnectingTo
(→ Runway.ID)
1Taxiway X2000.030.02015-06-011
2Taxiway Y2500.040.02021-09-012
3Taxiway Z1500.020.02010-08-153
4Taxiway AA1800.035.02005-01-104
5Taxiway BB1700.030.02008-05-015

Airplane

RegistrationNumberModelCapacityManufactureYearLastMaintenanceDate
N123ABBoeing 73720020052021-07-15
N456CDAirbus A38040020102021-08-15
N789EFEmbraer E19010020152021-09-15
N234GHBombardier CRJ-7006020072021-10-15
N567IJCanadair Regional Jet7020092021-11-15

Flight

FlightIdOriginAirportNameDestinationAirportNameDepartureTimeArrivalTimeAircraft
(→ Airplane.RegistrationNumber)
1New York JFKLos Angeles LAX10:00:0015:00:00N123AB
2Dallas DFWChicago ORD11:00:0016:00:00N456CD
3Miami MIAAtlanta ATL12:00:0017:00:00N789EF
4Philadelphia PHLDetroit DTW13:00:0018:00:00N234GH
5Seattle SEAPhoenix PHX14:00:0019:00:00N567IJ