| aircraft id | int(11) | Unique ch-aviation created aircraft ID, remains stable throughout an aircraft's life (assigned by ch-aviation) | Foreign | Aircraft | Aircraft ID |
| operator | varchar(255) | Operator name | | | |
| opr. ch-a code | varchar(5) | Operator ch-aviation code (assigned by ch-aviation). Operator ch-aviation codes can be 2, 3, or 5 characters. | Foreign | Operators | Operator ch-a Code |
| registration | varchar(16) | Aircraft registration | | | |
| aircraft variant | varchar(255) | Aircraft Variant designation (i.e. A321-200N) | Foreign | Aircraft Variants | variant_text |
| aircraft role | varchar(32) | Aircraft's primary role (Passenger, Passenger-Freighter, Cargo, Combi, Quick Change, Ambulance, Hospital, Maritime Patrol, Military, Oil Spill Response, Parachuting, Police, Tanker, Testbed, Water Bomber, VIP) | | | |
| last flight date | date | The date when the aircraft arrived at current location. In UTC | | | |
| location | varchar(255) | Airport Display Name (combination of City Name and Airport Name) | | | |
| location ch-a code | varchar(6) | Origin primary airport code (in order of availability: 1) IATA, 2) ICAO, 3) FAA, 4) Alternative code (if aircraft is inactive) | Foreign | Airports | Airport ch-a Code |
| location country iso code | char(2) | ISO 3166-1 Alpha-2 country code | Foreign | Countries | Country ISO |
| location country | varchar(255) | Country name | | | |
