Table description for AIRCRAFT in subject area ACCIDENT
| Home | Free Reports and Queries Fee Based Services Database Description Database Access |
| COLUMN NAME | DATA TYPE | LENGTH | PRECISION | NULLABLE | COMMENT |
|---|---|---|---|---|---|
| EV_ID | varchar | 14 | 0 | NO | |
| AIRCRAFT_KEY | numeric | 10 | 0 | NO | |
| REGIS_NO | varchar | 11 | 0 | YES | |
| NTSB_NO | varchar | 11 | 0 | YES | |
| ACFT_MISSING | varchar | 1 | 0 | YES | |
| NTSB_19A_DATE | date | 4 | 0 | YES | |
| NTSB_4_DATE | date | 4 | 0 | YES | |
| FAA_FORM_DATE | date | 4 | 0 | YES | |
| FAR_PART | varchar | 4 | 0 | YES | |
| FLT_PLAN_FILED | varchar | 4 | 0 | YES | |
| FLIGHT_PLAN_ACTIVATED | varchar | 1 | 0 | YES | |
| DAMAGE | varchar | 4 | 0 | YES | |
| ACFT_FIRE | varchar | 4 | 0 | YES | |
| ACFT_EXPL | varchar | 4 | 0 | YES | |
| TC_SHEET | varchar | 8 | 0 | YES | |
| CERT_REGION | varchar | 2 | 0 | YES | |
| DT_CUR_CERT | date | 4 | 0 | YES | |
| FAA_CERT_REGION | varchar | 4 | 0 | YES | |
| OPER_CERT_FSDO | varchar | 4 | 0 | YES | |
| AIC_ACFT_ID | varchar | 30 | 0 | YES | |
| ACFT_MAKE | varchar | 30 | 0 | YES | |
| ACFT_MODEL | varchar | 20 | 0 | YES | |
| ACFT_SERIES | varchar | 10 | 0 | YES | |
| ACFT_SERIAL_NO | varchar | 20 | 0 | YES | |
| YEAR_MFG | numeric | 5 | 0 | YES | |
| CERT_MAX_GR_WT | numeric | 10 | 0 | YES | |
| ACFT_CATEGORY | varchar | 4 | 0 | YES | |
| ACFT_CLASS | varchar | 4 | 0 | YES | |
| ACFT_REG_CLS | varchar | 4 | 0 | YES | |
| HOMEBUILT | varchar | 3 | 0 | YES | |
| TOTAL_SEATS | numeric | 5 | 0 | YES | |
| NUM_ENG | numeric | 3 | 0 | YES | |
| FIXED_RETRACTABLE | varchar | 4 | 0 | YES | |
| TYPE_LAST_INSP | varchar | 4 | 0 | YES | |
| DATE_LAST_INSP | date | 4 | 0 | YES | |
| AFM_HRS_LAST_INSP | numeric | 7 | 0 | YES | |
| AFM_HRS | numeric | 7 | 0 | YES | |
| AFM_CYCLES | numeric | 10 | 0 | YES | |
| ELT_INSTALL | varchar | 1 | 0 | YES | |
| ELT_OPER | varchar | 1 | 0 | YES | |
| ELT_AIDED_LOC_EV | varchar | 1 | 0 | YES | |
| FLIGHT_NUMBER | varchar | 4 | 0 | YES | |
| OWNER_ACFT | varchar | 50 | 0 | YES | |
| OWNER_STREET | varchar | 50 | 0 | YES | |
| OWNER_CITY | varchar | 50 | 0 | YES | |
| OWNER_STATE | varchar | 2 | 0 | YES | |
| OWNER_COUNTRY | varchar | 4 | 0 | YES | |
| OWNER_ZIP | varchar | 9 | 0 | YES | |
| OPERATED_BY | varchar | 30 | 0 | YES | |
| OPER_INDIVIDUAL_NAME | varchar | 1 | 0 | YES | |
| OPER_NAME | varchar | 50 | 0 | YES | |
| OPER_SAME | varchar | 1 | 0 | YES | |
| OPER_DBA | varchar | 50 | 0 | YES | |
| OPER_ADDR_SAME | varchar | 1 | 0 | YES | |
| OPER_STREET | varchar | 50 | 0 | YES | |
| OPER_CITY | varchar | 50 | 0 | YES | |
| OPER_STATE | varchar | 2 | 0 | YES | |
| OPER_COUNTRY | varchar | 4 | 0 | YES | |
| OPER_ZIP | varchar | 9 | 0 | YES | |
| OPER_CODE | varchar | 4 | 0 | YES | |
| CERTS_HELD | varchar | 1 | 0 | YES | |
| OPRTNG_CERT | varchar | 3 | 0 | YES | |
| OPER_CERT | varchar | 4 | 0 | YES | |
| OPER_CERT_NUM | varchar | 11 | 0 | YES | |
| OPER_SCHED | varchar | 4 | 0 | YES | |
| OPER_DOM_INT | varchar | 3 | 0 | YES | |
| OPER_PAX_CARGO | varchar | 4 | 0 | YES | |
| TYPE_FLY | varchar | 4 | 0 | YES | |
| SECOND_PILOT | varchar | 1 | 0 | YES | |
| DPRT_PT_SAME_EV | varchar | 1 | 0 | YES | |
| DPRT_APT_ID | varchar | 4 | 0 | YES | |
| DPRT_CITY | varchar | 15 | 0 | YES | |
| DPRT_STATE | varchar | 2 | 0 | YES | |
| DPRT_COUNTRY | varchar | 3 | 0 | YES | |
| DPRT_TIME | numeric | 5 | 0 | YES | |
| DPRT_TIMEZN | varchar | 3 | 0 | YES | |
| DEST_SAME_LOCAL | varchar | 4 | 0 | YES | |
| DEST_APT_ID | varchar | 4 | 0 | YES | |
| DEST_CITY | varchar | 15 | 0 | YES | |
| DEST_STATE | varchar | 2 | 0 | YES | |
| DEST_COUNTRY | varchar | 3 | 0 | YES | |
| INJ_IDX | varchar | 4 | 0 | YES | |
| INJFCREW_FATAL | numeric | 5 | 0 | YES | |
| INJFCREW_INJ | numeric | 5 | 0 | YES | |
| INJFCREW_ONBD | numeric | 5 | 0 | YES | |
| INJCCREW_FATAL | numeric | 5 | 0 | YES | |
| INJCCREW_INJ | numeric | 5 | 0 | YES | |
| INJCCREW_ONBD | numeric | 5 | 0 | YES | |
| INJPAX_FATAL | numeric | 10 | 0 | YES | |
| INJPAX_INJ | numeric | 10 | 0 | YES | |
| INJPAX_ONBD | numeric | 10 | 0 | YES | |
| INJGCREW_FATAL | numeric | 5 | 0 | YES | |
| INJGCREW_INJ | numeric | 5 | 0 | YES | |
| INJPUB_FATAL | numeric | 5 | 0 | YES | |
| INJPUB_INJ | numeric | 5 | 0 | YES | |
| PHASE_FLT_SPEC | numeric | 10 | 0 | YES | |
| REPORT_TO_ICAO | varchar | 1 | 0 | YES | |
| EVACUATION | varchar | 1 | 0 | YES | |
| EVAC_INJURIES | varchar | 1 | 0 | YES | |
| FAA_COMMENTS | varchar | 255 | 0 | YES | |
| C5 | varchar | 13 | 0 | YES | |
| DELETE_FLAG | varchar | 1 | 0 | YES | |
| NTSB_DTCHG | date | 4 | 0 | YES | |
| LCHG_DATE | date | 4 | 0 | YES | |
| LCHG_USERID | varchar | 18 | 0 | YES | |
| AFM_HRS_SINCE | varchar | 4 | 0 | YES | |
| RWY_NUM | varchar | 4 | 0 | YES | |
| RWY_LEN | numeric | 10 | 0 | YES | |
| RWY_WIDTH | numeric | 10 | 0 | YES | |
| SITE_SEEING | varchar | 1 | 0 | YES | |
| AIR_MEDICAL | varchar | 1 | 0 | YES | |
| MED_TYPE_FLIGHT | varchar | 15 | 0 | YES | |
| ADDED_TIMESTAMP | timestamp | 8 | 0 | NO | |
| ACFT_AWY_CERT | varchar | 4 | 0 | YES | |
| AIRCAR_CERT | varchar | 4 | 0 | YES | |
| AIRSPC_TYPE | varchar | 4 | 0 | YES | |
| INSTM_APPR | varchar | 4 | 0 | YES | |
| LANDING_GEAR | varchar | 4 | 0 | YES | |
| LANDING_SURF | varchar | 4 | 0 | YES | |
| LOAD_DESC | varchar | 4 | 0 | YES | |
| RWY_COND | varchar | 4 | 0 | YES | |
| TYPE_CLEAR | varchar | 4 | 0 | YES | |
| VFR_APPR | varchar | 4 | 0 | YES | |
| MODIFIED_TIMESTAMP | timestamp | 8 | 0 | YES |
| Legal | Copyright 2001 - 2004 AviationDB.com Corp. All Rights Reserved | Contact Us |