Last Aircraft Location
To access the full sample data set on Amazon Web Services manually or programmatically, the S3 bucket URLs are provided here.
To get user name and password for manual access or access key and secret key for programmatic access, contact sales@ch-aviation.com.
| Column | Data Type | Data description | Key | Data Set | Join On |
|---|---|---|---|---|---|
| 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 (Passenger - Ambulance), Quick Change (Passenger - Cargo), 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 |