Table description for MASTER in subject area AIRCRAFT
| Home | Free Reports and Queries Fee Based Services Database Description Database Access |
| COLUMN NAME | DATA TYPE | LENGTH | PRECISION | NULLABLE | COMMENT |
|---|---|---|---|---|---|
| N_NUMBER | varchar | 5 | 0 | NO | |
| SERIAL_NUMBER | varchar | 30 | 0 | YES | |
| AIRCRAFT_MFR_MODEL | varchar | 7 | 0 | YES | |
| ENGINE_MFR_MODEL | varchar | 5 | 0 | YES | |
| YEAR_MFR | date | 4 | 0 | YES | |
| TYPE_REGISTRANT | varchar | 1 | 0 | YES | |
| REGISTRANT_NAME | varchar | 50 | 0 | YES | |
| STREET1 | varchar | 33 | 0 | YES | |
| STREET2 | varchar | 33 | 0 | YES | |
| REGISTRANT_CITY | varchar | 18 | 0 | YES | |
| REGISTRANT_STATE | varchar | 2 | 0 | YES | |
| REGISTRANT_ZIP_CODE | varchar | 10 | 0 | YES | |
| REGISTRANT_REGION | varchar | 1 | 0 | YES | |
| COUNTY_MAIL | varchar | 3 | 0 | YES | |
| COUNTRY | varchar | 2 | 0 | YES | |
| LAST_ACTION_DATE | date | 4 | 0 | YES | |
| CERTIFICATE_ISSUE_DATE | date | 4 | 0 | YES | |
| AIRWORTHINESS_CLASSIFICATION | varchar | 1 | 0 | YES | |
| APPROVED_OPERATION_CODES | varchar | 9 | 0 | YES | |
| TYPE_AIRCRAFT | varchar | 1 | 0 | YES | |
| TYPE_ENGINE | varchar | 1 | 0 | YES | |
| STATUS | varchar | 1 | 0 | YES | |
| MODE_S_CODE | varchar | 8 | 0 | YES | |
| ADDED_TIMESTAMP | timestamp | 8 | 0 | NO | |
| FRACT_OWNER | bpchar | 1 | 0 | YES | |
| MODIFIED_TIMESTAMP | timestamp | 8 | 0 | YES |
| Legal | Copyright 2001 - 2004 AviationDB.com Corp. All Rights Reserved | Contact Us |