Database Reference
In-Depth Information
Table 5.1
(continued)
OriginCityName Origin city
OriginCountry Origin airport, country
OriginCountryName Origin airport, country name
OriginWAC
Origin airport, world area code
Destination
DestAirportID
Destination airport, Airport ID. An identification num-
ber assigned by US DOT to identify a unique airport. Use
this field for airport analysis across a range of years be-
cause an airport can change its airport code and airport
codes can be reused
DestAirportSeqID
Destination airport, Airport Sequence ID. An identifica-
tion number assigned by US DOT to identify a unique
airport at a given point of time. Airport attributes, such
as airport name or coordinates, may change over time
DestCityMarketID
Destination airport, City Market ID. City Market ID is
an identification number assigned by US DOT to iden-
tify a city market. Use this field to consolidate airports
serving the same city market
Dest
Destination airport
DestCityName
Destination city
DestCountry
Destination airport, country
DestCountryName
Destination airport, country name
DestWAC
Destination airport, world area code
Aircraft
AircraftGroup
Aircraft group
AircraftType
Aircraft type
AircraftConfig
Aircraft configuration
Time Period
Year
Year
Quarter
Quarter
Month
Month
Other
DistanceGroup
Distance intervals, every 500 Miles, for flight segment
Class
Service Class
Search WWH ::
Custom Search