You are here

On-Flight Market Records

The On-Flight Market Records are data on where passengers, freight and mail commenced and ended their flight. A change in Flight number begins a new on-flight record.

Name Description Type
year Data Year char(4)
month Data Month char(2)
origin OriginAirport Code (code is either OAG or OAI assigned) char(3)
origin_ id Origin Numeric Id (OAI assigned) char(5)
origin_wac Origin World Area Code (Alaska = "001") char(3)
origin_city_name Origin Airport/City Name char(35)
dest Destination Airport Code (code is either OAG or OAI assigned) char(3)
dest_id Destination Numeric Id char(5)
dest_wac Destination World Area Code (Alaska = "001") char(3)
dest_city_name Destination Airport/City Name char(35)
carrier_code Carrier Code (code is either IATA or OAI assigned) char(3)
entity_code OAI assigned - unique code char(5)
group Group Code classifies the US air carriers by the amount of total operating revenue for the previous year.
  • Regional Carriers - 1 (Includes Large, Medium, Commuter, Small Certificated)
  • National Carriers - 2
  • Major Carriers - 3
char(1)
dist The great circle distance in statute miles between the Origin & Destination airports int
svc_class The Service Class Code refers to the class of service used:
  • F-Scheduled Passenger/Cargo Service
  • G-Scheduled All Cargo Service
char(1)
passengers Number of Passengers originating (enplaning) the flight at the origin airport and terminating (deplaning) the flight at the destination airport. int
pax_first * Ignore this field. First, Middle and Coach Passenger data are not identified for US air carriers operating in domestic markets. int
pax_middle * Ignore this field. int
pax_coach * Ignore this field. int
freight Revenue Freight in pounds originating (enplaning) the flight at the origin airport and terminating (deplaning) the flight at the destination airport. int
mail Revenue Mail in pounds originating (enplaning) the flight at the origin airport and terminating (deplaning) the flight at the destination airport. int
type The Type identifies that the points involved are DD=Domestic<>Domestic char(2)