Aircraft Owner Contacts
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_owner_contacts.csv | Sample data for commercial aviation |
| Column | Data Type | Data description | Package required | Key | Data Set | Join On |
|---|---|---|---|---|---|---|
| Contact ID | int(11) | Unique ch-aviation created contact ID | Aircraft Owner Contacts | Primary | ||
| Entity Name | varchar(255) | Entity name | Aircraft Owner Contacts | |||
| Entity ch-a Code | varchar(4) | Entity ch-aviation code (assigned by ch-aviation) | Aircraft Owner Contacts | Foreign | Entities | Entity ch-a Code |
| Legal Name | varchar(255) | Entity legal name | Aircraft Owner Contacts | |||
| Entity Type | int(11) | Entity type | Aircraft Owner Contacts | |||
| Entity Type Code | char(1) | Entity type code (E: Engine Manufacturer, I: IT Provider, L: Lessor, X: Cargo Customer/Forwarder) | Aircraft Owner Contacts | |||
| Location | varchar(255) | Location airport name (closest airport if not based at airport itself) | Aircraft Owner Contacts | |||
| Location ID | int(11) | Location ID (assigned by ch-aviation) | Aircraft Owner Contacts | Foreign | Airports | Airport ID |
| Country | varchar(255) | Country name | Aircraft Owner Contacts | |||
| Country ISO | char(2) | ISO 3166-1 Alpha-2 country code | Aircraft Owner Contacts | Foreign | Countries | Country ISO |
| EU Country | char(1) | European Union country: Yes / No / (NULL) | Aircraft Owner Contacts | |||
| Title | char(2) | Mr / Ms | Aircraft Owner Contacts | |||
| Firstname | varchar(48) | First name | Aircraft Owner Contacts | |||
| Lastname | varchar(48) | Last name | Aircraft Owner Contacts | |||
| Job Group | varchar(48) | Job Group description (for filtering purposes) | Aircraft Owner Contacts | |||
| Job Title | varchar(127) | Job title | Aircraft Owner Contacts | |||
| varchar(255) | E-Mail address (masked in sample data) | Aircraft Owner Contacts | ||||
| Social Media | varchar(255) | Social media URL | Aircraft Owner Contacts |