Aircraft Events
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.
To access the full sample data set on Snowflake, visit the ch-aviation profile on Snowflake Marketplace here.
| Sample File Name | Sample Description |
|---|---|
| aircraft_events.csv | Sample data for commercial aviation and business jets |
| aircraft_events_comav.csv | Subset for commercial aviation |
| aircraft_events_bizjets.csv | Subset for business jets |
| Column | Data Type | Data description | Package required | Key | Data Set | Join On |
|---|---|---|---|---|---|---|
| event_id | varchar(32) | Unique identifier for each event, generated as an MD5 hash of the aircraft_id, event type, and date_of_event_full. Stable as long as the combination of underlying data does not change (it changes as aircraft data is adjusted or improved by ch-aviation). | Aircraft Events | Primary | ||
| aircraft_id | int(11) | Unique ch-aviation created aircraft ID, remains stable throughout an aircraft's life (assigned by ch-aviation) | Aircraft Events | Foreign | Aircraft | Aircraft ID |
| cn | varchar(16) | Construction/Line Number | Aircraft Events | |||
| msn | varchar(16) | Manufacturer Serial Number | Aircraft Events | |||
| previous_variant | varchar(255) | Aircraft Variant designation (i.e. A321-200N) before the event | Aircraft Events | Foreign | Aircraft Variants | variant_text |
| new_variant | varchar(255) | Aircraft Variant designation (i.e. A321-200N) after the event | Aircraft Events | Foreign | Aircraft Variants | variant_text |
| previous_registration | varchar(16) | Aircraft Registration before the event, blank if unknown or no longer registered | Aircraft Events | |||
| new_registration | varchar(16) | Aircraft Registration after the event, blank if unknown or no longer registered | Aircraft Events | |||
| previous_operator_ch_code | varchar(5) | Previous 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, the aircraft's multiple operators can be found in the Aircraft Multiple Operators table) | Aircraft Events | Foreign | Operators | Operator ch-a Code |
| previous_operator | varchar(255) | Previous Operator name (if Operator is "Multiple Operators", the aircraft's multiple operators can be found in the Aircraft Multiple Operators table) | Aircraft Events | |||
| new_operator_ch_code | varchar(5) | New 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, the aircraft's multiple operators can be found in the Aircraft Multiple Operators table) | Aircraft Events | Foreign | Operators | Operator ch-a Code |
| new_operator | varchar(255) | New Operator name (if Operator is "Multiple Operators", the aircraft's multiple operators can be found in the Aircraft Multiple Operators table) | Aircraft Events | |||
| intra_group_transaction | varchar(10) | Indicates whether the operators involved in the transaction belong to the same group. Populated for Re-delivery and Operator Retirement event types only; blank for all others. Values: YES / NO. | Aircraft Events | |||
| date_of_event | varchar(10) | Date of event (YYYY-MM-DD, YYYY-MM or YYYY) | Aircraft Events | |||
| date_of_event_full | date | Date of event in full date format (YYYY-MM-DD) | Aircraft Events | |||
| aircraft_age | decimal(4,1) | Aircraft age at the time of the event (based on the lowest of roll-out, registration, first flight, delivery or first sighting date) | Aircraft Events | |||
| event_type | varchar(16) | Event type (Re-delivery, Operator Retirement, Registration Change, Delivery, Conversion, Scrapped, Retirement) | Aircraft Events |