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