| Field | Type | Description | Example |
|---|---|---|---|
| ORG | VARCHAR(200) | Origin airport code, name, and metropolitan area | KVNY/VNY: VAN NUYS,CA (Los Angeles) |
| ORG_ICAO | VARCHAR(10) | Origin airport 4-character ICAO code, if any | KVNY |
| ORG_IATA | VARCHAR(10) | Origin airport 3-character IATA code, if any | VNY |
| O_CITY | VARCHAR(50) | Origin city | Van Nuys |
| O_TIMEZONE | VARCHAR(50) | Origin time zone | America/Los_Angeles |
| O_STATE | VARCHAR(50) | Origin state code, if any | CA |
| O_COUNTRY | VARCHAR(50) | Origin country code | US |
| DST | VARCHAR(10) | Destination airport code (ICAO code, if any) | KTEB/TEB: TETERBORO,NJ (New York) |
| DST_ICAO | VARCHAR(10) | Destination airport 4-character ICAO code, if any | KTEB |
| DST_IATA | VARCHAR(10) | Destination airport 3-character IATA code, if any | TEB |
| D_CITY | VARCHAR(50) | Destination city | Teterboro |
| D_TIMEZONE | VARCHAR(50) | Destination time zone | America/New_York |
| D_STATE | VARCHAR(50) | Destination state code, if any | NJ |
| D_COUNTRY | VARCHAR(50) | Destination country code | US |
| OPERATOR | VARCHAR(4) | Operator code (XXX for private flights) | LXJ |
| OPERATOR_NAME | VARCHAR(5000) | Operator name | Flexjet LLC |
| OWNER | VARCHAR(1500) | Owner or registrant name | Flexjet LLC |
| FOR_HIRE | BOOLEAN | True for Part 135 (for-hire) and false for Part 91 (private) | True |
| BUSINESS | BOOLEAN | True for business aviation | True |
| CALLSIGN | VARCHAR(20) | Call sign of the aircraft | LXJ414 |
| AIRCRAFT_ID | VARCHAR(20) | Aircraft ID, which could be call sign or tail number of the aircraft | LXJ414 |
| REGISTRATION | VARCHAR(20) | Registration/tail number of the aircraft | N414FX |
| FLIGHT_NO | VARCHAR | Flight number, if any | 414 |
| AIRCRAFT_TYPE | VARCHAR(10) | ICAO aircraft type code | E545 |
| ICAO_CATEGORY | VARCHAR(26) | ICAO aircraft category | Jet_M |
| AIRCRAFT_CATEGORY | VARCHAR(50) | Business aviation aircraft category | Super Midsize Jet |
| SEATS | NUMBER | Number of seats | 11 |
| DEPARTURE_UTC | TIMESTAMP | Departure time in UTC time | 2021-01-01 17:02:00 |
| ARRIVAL_UTC | TIMESTAMP | Arrival time in UTC time | 2021-01-01 21:47:06 |
| LOCAL_DATE | DATE | Departure date in local time | 2021-01-01 |
| DOW | VARCHAR(3) | Day of week in local time | Fri |
| GATE_DEPARTURE | TIMESTAMP | Departure time from the gate, if any | |
| DEPARTURE | TIMESTAMP | Departure time in local time | 2021-01-01 09:02:00 |
| ARRIVAL | TIMESTAMP | Arrival time in local time | 2021-01-01 16:47:06 |
| SCHEDULED_ORG | VARCHAR(10) | Scheduled origin airport code, if different from the actual origin airport | |
| SCHEDULED_DST | VARCHAR(10) | Scheduled destination airport code, if different from the actual destination airport | |
| FLIGHT_MINUTES | NUMBER | Minutes of flight time | 285 |
| BLOCK_MINUTES | NUMBER | Minutes of block time, which equals taxi-out time + flight time + taxi-in time | 300 |
| TAXI_IN | NUMBER | Minutes from run-way wheels down to the gate | 5 |
| TAXI_OUT | NUMBER | Minutes from the gate to run-way wheels up | 10 |
| MILES | DOUBLE | Miles between the origin airport and the destination airport | 2450 |
| SOURCE | VARCHAR(11) | Specific data channel from FAA | TFMS |
Flight BI
Flight Business Intelligence