Aircraft Histories
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.
| Sample File Name | Sample Description |
|---|---|
| aircraft_histories_bizjets.csv | Subset for business jets |
| aircraft_histories_comav.csv | Subset for commercial aviation |
| aircraft_histories.csv | Sample data for commercial aviation and business jets |
| Column | Data Type | Data description | Package required | Key | Data Set | Join On |
|---|---|---|---|---|---|---|
| Natural ID | varchar(30) | Natural aircraft ID (combination of the ch-aviation production line code and either the line/construction or manufacturer serial number, changes for aircraft not yet delivered where l/n, c/n or msn are not yet known (assigned by ch-aviation) | History | Foreign | Aircraft | Natural ID |
| Aircraft ID | int(11) | Unique ch-aviation created aircraft ID, remains stable throughout an aircraft’s life (assigned by ch-aviation) | History | Primary/Foreign | Aircraft | Aircraft ID |
| C/N | varchar(16) | Construction/Line Number | History | |||
| MSN | varchar(16) | Manufacturer Serial Number | History | |||
| Hexcode | char(6) | ICAO 24-bit address/Mode-S hexcode | ||||
| Production Line | varchar(255) | Production Line designation (i.e. A320) | History | |||
| Aircraft Family | varchar(255) | Aircraft Family designation (i.e. A320N) | History | |||
| Aircraft | varchar(16) | Aircraft designation (i.e. A321) | History | |||
| Aircraft Type | varchar(16) | Aircraft Type designation (i.e. A321-200) | History | |||
| Aircraft Variant | varchar(255) | Aircraft Variant designation (i.e. A321-200N) | History | Foreign | Aircraft Variants | variant_text |
| Operator | varchar(255) | Operator name (if Operator is "Multiple Operators", aircraft's multiple operators for a given period can be found in Aircraft Histories Multiple Operators table by matching on Aircraft ID and Date From Full) | History | |||
| Operator ch-a Code | varchar(5) | Operator ch-aviation code (assigned by ch-aviation). Operator ch-aviation codes can be 2, 3, or 5 characters (if Operator ch-a Code is MLT, aircraft's multiple operators for a given period can be found in Aircraft Histories Multiple Operators table by matching on Aircraft ID and Date From Full) | History | Foreign | Operators | Operator ch-a Code |
| Registration | varchar(16) | Aircraft Registration, blank if unknown or no longer registered | History | |||
| Date From | Varchar(10) | From date with current operator, registration and variant (YYYY-MM-DD, YYYY-MM or YYYY) | History | |||
| Date To | varchar(10) | To date with current operator, registration and variant (YYYY-MM-DD, YYYY-MM or YYYY) | History | |||
| Date In | varchar(10) | Date the aircraft was delivered to the operator (regardless of other changes such as registration, variant etc.) (YYYY-MM-DD, YYYY-MM or YYYY) | History | |||
| Date Out | varchar(10) | Date the aircraft left the operator (regardless of other changes such as registration, variant etc.) (YYYY-MM-DD, YYYY-MM or YYYY) | History | |||
| Roll-Out | varchar(10) | Date the aircraft was rolled out (YYYY-MM-DD, YYYY-MM or YYYY) | History | |||
| Registration Date | varchar(10) | Date the aircraft was first registered (YYYY-MM-DD, YYYY-MM or YYYY) | History | |||
| First Flight | varchar(10) | Date the aircraft has first flown (YYYY-MM-DD, YYYY-MM or YYYY) | History | |||
| Delivery Date | varchar(10) | Actual Delivery Date (YYYY-MM-DD, YYYY-MM or YYYY) | History | |||
| First Sighting | varchar(10) | Date the aircraft was first seen (if other dates are unknown) (YYYY-MM-DD, YYYY-MM or YYYY) | History | |||
| End of Life | varchar(10) | Date the aircraft was written off or scrapped (YYYY-MM-DD, YYYY-MM or YYYY) | History | |||
| Engine Manufacturer | varchar(255) | Engine manufacturer name | History | |||
| Engine Manufacturer ch-a Code | varchar(4) | Engine manufacturer ch-aviation code (assigned by ch-aviation) | History | Foreign | Entities | Entity ch-a Code |
| Engine Family | varchar(16) | Engine family (i.e. JT9D) | History | |||
| Engine Master Series | varchar(32) | Engine master series designation (i.e. JT9D-7R4) | History | |||
| Engine Type | varchar(16) | Engine type designation (i.e. PW JT9D) | History | |||
| Engine Subtype | varchar(32) | Engine subtype designation (i.e. PW JT9D-7R4H1) | History | |||
| Number of Engines | int(11) | Number of engines installed on the aircraft | History | |||
| Date From Full | date | From date with current operator, registration and variant, in full date format (YYYY-MM-DD) | History | Primary |