Aircraft Current and Future Base Values by MSN
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_current_future_base_values_by_msn.csv | Sample data for commercial aviation |
| Column | Data Type | Data description | Package required | 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) | Aircraft Current and Future Base Values by MSN | Primary/Foreign | Aircraft | Aircraft ID |
| CN | varchar(16) | Construction/Line Number | Aircraft Current and Future Base Values by MSN | |||
| MSN | varchar(16) | Manufacturer Serial Number | Aircraft Current and Future Base Values by MSN | |||
| Aircraft_Variant | varchar(255) | Aircraft Variant designation (i.e. A321-200N) | Aircraft Current and Future Base Values by MSN | Foreign | Aircraft Variants | variant_text |
| Build_Year | int(4) | Aircraft build year | Aircraft Current and Future Base Values by MSN | |||
| Value_Year | int(4) | Aircraft value year applicable to the then current/future base value | Aircraft Current and Future Base Values by MSN | Primary | ||
| Base_Value | decimal(5,2) | Base value in million USD (provided by Collateral Verifications), value assumptions defined here (available to logged in users): https://www.ch-aviation.com/request-desktop-appraisal | Aircraft Current and Future Base Values by MSN |