Home	Free Reports and Queries   Fee Based Services   Database Description   Database Access

Tables

An ERD (Entity Relationship Diagram), which is a pictorial representation of the tables and their relationships is available here.

All the tables are listed below, grouped by subject area. Click on the table name for column information. Note that the row count an estimation. Unless otherwise indicated, the documents supplied by the data source should be used for more information.

SUBJECT AREA	TABLE NAME	ROW COUNT	COMMENTS
Accident	AIRCRAFT	53,559	Also contain the columns of the source DT_AIRCRAFT table which has been deleted from the schema
Accident	CABIN_CREW	417
Accident	CT_IAIDS	905	Code table supplied with the source data
Accident	ENGINES	53,079
Accident	EVENTS	53,623	Also contain the columns of the source DT_EVENTS table which has been deleted from the schema
Accident	FLIGHT_CREW	55,192	Also contain the columns of the source DT_FLIGHT_CREW table which has been deleted from the schema
Accident	FLIGHT_TIME	726,548
Accident	GROUP_CODES	5	Code table extracted from the manual
Accident	INJURY	298,884
Accident	KEYWORDS	91,626	A lookup table of words extracted from the NARRATIVE table
Accident	MODIFIER_CODES	487	Code table extracted from the manual
Accident	NARRATIVE_KEYWORDS	7,306,052	A junction table of words extracted from the NARRATIVE table
Accident	NARRATIVES	101,149	One narrative row per narrative type rather than all narratives in one table
Accident	OCCURRENCE_CODES	55	Code table extracted from the manual
Accident	OCCURRENCES	112,896
Accident	PERSON_CODES	124	Code table extracted from the manual
Accident	PHASE_OF_FLIGHT_CODES	56	Code table extracted from the manual
Accident	SEQ_OF_EVENTS	220,794
Accident	SUBJECT_CODES	1,842	Code table extracted from the manual
Accident	THEDATADICTIONARY	711	Some codes from the original source data
Accident	TRANSLATIONTABLE	267
Aircraft	ACFTREF	55,148	Aircraft Reference
Aircraft	AIRCRAFT_CATEGORY_CODES	3	Code table supplied with the source data
Aircraft	AIRCRAFT_CODES	6	Code table supplied with the source data
Aircraft	AIRWORTHINESS_CODES	8	Code table supplied with the source data
Aircraft	DEALER	2,922
Aircraft	DOCINDEX	33,750
Aircraft	ENGINE_CODES	8	Code table supplied with the source data
Aircraft	ENGINE	733	Engine Reference
Aircraft	MASTER_REGION_CODES	11	Code table supplied with the source data
Aircraft	MASTER	353,781	Defines specific aricraft
Aircraft	MASTER_STATUS_CODES	13	Code table supplied with the source data
Aircraft	REGISTRANT_CODES	7	Code table supplied with the source data
Aircraft	RESERVED	35,524
Airmen	AIRMAN_RATING	2,120,155	The columns for this table come from the original AIRMAN table. Note that RATING_LEVEL is only included in the primary key as there are a very few foreign pilots that have multiple RATING_LEVELs for a Certificate/Rating
Airmen	AIRMAN	1,001,094	Includes pilots, ground and flight instructors, flight engineers, navigators, dispatchers, mechanics, riggers, and control tower operators registered with the FAA including both domestic and foreign airman. Some of the columns of the source table have been normalized to the AIRMAN_RATING TABLE
Airmen	CERTIFICATE_RATINGS	52	Code table extracted from the manual
Airmen	CERTIFICATE_TYPES	24	Code table extracted from the manual
Airport	AIRPORT_FACILITY_DATA	18,760	Airport infomation
Airport	FACILITY_RUNWAY_DATA	22,604	Runway information
Airport	GPS_DATA	7,341
Airport	WEATHER_SERVICE_DATA	2,213
Incident	AID_ACCIDENT_INCIDENT_CODES	90	Code table supplied with the documentation
Incident	AID_AIRCRAFT_POWER_CODES	8	Code table supplied with the documentation
Incident	AID_AIRCRAFT_WEIGHT_CODES	6	Code table supplied with the documentation
Incident	AID_AIRCRAFT_WING_CODES	15	Code table supplied with the documentation
Incident	AID_AIRWORTHINESS_CLASS_CODES	7	Code table supplied with the documentation
Incident	AID_APPROACH_CODES	14	Code table supplied with the documentation
Incident	AID_CAUSE_FACTOR_CODES	179	Code table supplied with the documentation
Incident	AID_CONTRIBUTING_CAUSE_CODES	34	Code table supplied with the documentation
Incident	AID_DAMAGE_CODES	10	Code table supplied with the documentation
Incident	AID_DATA_SOURCE_CODES	6	Code table supplied with the documentation
Incident	AID_DISTRICT_OFFICE_CODES	487	Code table supplied with the documentation
Incident	AID_ELT_CODES	7	Code table supplied with the documentation
Incident	AID_ENGINE_POWER_CODES	3	Code table supplied with the documentation
Incident	AID_ENGINE_TYPE_CODES	14	Code table supplied with the documentation
Incident	AID_EVENT_TYPE_CODES	4	Code table supplied with the documentation
Incident	AID_FLIGHT_PHASE_CODES	83	Code table supplied with the documentation
Incident	AID_FLIGHT_PLAN_CODES	10	Code table supplied with the documentation
Incident	AID_GENERAL_CAUSE_CAT_CODES	11	Code table supplied with the documentation
Incident	AID_INCIDENT	200,646	FAA Accident/Incident
Incident	AID_INCIDENT_TEXT	163,351	FAA Accident/Incident narrative text
Incident	AID_INVESTIGATION_EXTENT_CODES	4	Code table supplied with the documentation
Incident	AID_LANDING_GEAR_CODES	17	Code table supplied with the documentation
Incident	AID_LIGHT_CONDITION_CODES	6	Code table supplied with the documentation
Incident	AID_MIDAIR_CODES	5	Code table supplied with the documentation
Incident	AID_NOTIFICATION_METHOD_CODES	9	Code table supplied with the documentation
Incident	AID_OPERATION_CAUSE_CODES	25	Code table supplied with the documentation
Incident	AID_OPERATOR_CODES	17	Code table supplied with the documentation
Incident	AID_OTHER_FACTOR_CODES	33	Code table supplied with the documentation
Incident	AID_OTHER_RATING_CODES	18	Code table supplied with the documentation
Incident	AID_PERSON_INVOLVED_CODES	20	Code table supplied with the documentation
Incident	AID_PILOT_CERT_CODES	11	Code table supplied with the documentation
Incident	AID_PILOT_PROFESSION_CODES	16	Code table supplied with the documentation
Incident	AID_PILOT_QUALIFICATION_CODES	14	Code table supplied with the documentation
Incident	AID_PILOT_RATING_CODES	75	Code table supplied with the documentation
Incident	AID_PRIMARY_FLYING_CODES	18	Code table supplied with the documentation
Incident	AID_PRIMARY_FLYING_COND_CODES	3	Code table supplied with the documentation
Incident	AID_REGION_CODES	45	Code table supplied with the documentation
Incident	AID_RELATED_REPORT_CODES	4	Code table supplied with the documentation
Incident	AID_REMEDIAL_ACTION_AREA_CODES	26	Code table supplied with the documentation
Incident	AID_REMEDIAL_ACTION_CODES	22	Code table supplied with the documentation
Incident	AID_RUNWAY_CONDITION_CODES	7	Code table supplied with the documentation
Incident	AID_SECONDARY_FLYING_CND_CODES	27	Code table supplied with the documentation
Incident	AID_SECONDARY_FLYING_CODES	29	Code table supplied with the documentation
Incident	AID_SKY_CONDITION_CODES	5	Code table supplied with the documentation
Incident	AID_STATE_CODES	342	Code table supplied with the documentation
Incident	AID_SUPPORTING_FACTOR_CODES	26	Code table supplied with the documentation
Incident	AID_VISIBILITY_CODES	8	Code table supplied with the documentation
Medical	MEDICAL_EXAMINERS	4,516
Operator	OPR_AGENCY_141_AG_OPS	5	External Load/Agricultural Operations for which the 141 Pilot Schools provide training.
Operator	OPR_AGENCY_141_CURRICULA	91	Aircraft Type Ratings, Special Curricula and other Approved Training course Outlines
Operator	OPR_AGENCY_141_INFO	474	FAA Certificated Pilot Schools - 141 specific information
Operator	OPR_AGENCY_141_INSTRUCTOR	1,815	141_instructor(s) working for the FAR 141 Pilot Schools
Operator	OPR_AGENCY_142_CONTRACT	3,240	Operator(s) with whom the FAR 142 Training Centers have contracted and/or FAR 141 Agencies with whom the FAR 142 Training Centers have agreements
Operator	OPR_AGENCY_142_CURRICULA	2,528	Authorized curricula for the FAR 142 Training Centers
Operator	OPR_AGENCY_142_INFO	80	Certificated Training Centers - FAR 142 specific information
Operator	OPR_AGENCY_142_MANAGER	39	FAR 142 Partial Program Manager(s) and the make/model(s) or make/model/series to which they are assigned.
Operator	OPR_AGENCY_142_SIMULATOR	737	Simulators and Flight Training Devices approved for use by the FAR 142 Training Centers
Operator	OPR_AGENCY_145_FOREIGN	231	Information on U.S. Certificated Air Carriers for whom the foreign repair stations are authorized to perform repairs
Operator	OPR_AGENCY_145_INFO	5,162	Certificated Repair Stations - FAR 145 specific information
Operator	OPR_AGENCY_145_LIMIT	50,235	Explanation of the limitations listed in the FAR 145 specific information
Operator	OPR_AGENCY_145_STATION	252	Joint Airworthiness Regulations 145 Listed domestic line station.
Operator	OPR_AGENCY_147_INFO	175	FAA Certificated Aviation Maintenance Technician Schools - FAR 147 specific information
Operator	OPR_AGENCY_AIRCRAFT	4,562	agency aircraft information
Operator	OPR_AGENCY_DBA	996	Agency doing business as name(s)
Operator	OPR_AGENCY_DISTRICT_OFFICE	43	Agency Geographic Office performing surveillance in lieu of the certificate holding office
Operator	OPR_AGENCY_EXEMPTION	89	Agency exemptions held
Operator	OPR_AGENCY	5,898	Agency common information
Operator	OPR_AIR_OPERATOR	7,164	Air Operator Information
Operator	OPR_OPERATOR_AIRCRAFT	15,326	Air Operator Aircraft
Operator	OPR_OPERATOR_CEO	7,164	Air Operator CEO Name, Title, and Address
Operator	OPR_OPERATOR_CONTRACTOR	1,670	Contractors for Air Operators
Operator	OPR_OPERATOR_DBA	2,321	Doing Business As Name of Air Operator
Operator	OPR_OPERATOR_NAME_ADDRESS	28,364	Air Operator Address Information
Operator	OPR_OPERATOR_WAIVER	174	Waivers Maintained by Air Operator
SDR	ALERT_CODES	4	Code table supplied with the source data
SDR	CONDITION_CODES	29	Code table supplied with the source data
SDR	DISTRICT_OFFICE_CODES	493	Code table supplied with the source data
SDR	JASC_CODES	615
SDR	PROCEDURE_CODES	28	Code table supplied with the source data
SDR	REGION_CODES	20	Code table supplied with the source data
SDR	REPORT_STATUS_CODES	4	Code table supplied with the source data
SDR	SDR_CONDITIONS	1,004,632	Service Difficulty Report nature of conditions
SDR	SDR_PROCEDURES	973,328	Service Difficulty Report PRECAUTIONARY PROCEDURES
SDR	SDR_REMARKS	930,157	Service Difficulty Report remarks
SDR	SDR	931,721	Service Difficulty Report
SDR	SEGMENT_CODES	4	Code table supplied with the source data
SDR	SEVERITY_CODES	6	Code table supplied with the source data
SDR	STAGE_CODES	18	Code table supplied with the source data
SDR	SUBMITTER_CODES	13	Code table supplied with the source data
SDR	WEIGHT_CODES	3	Code table supplied with the source data
SDR	WING_CODES	11	Code table supplied with the source data

---

Legal

Copyright 2001 - 2004 AviationDB.com Corp. All Rights Reserved

Contact Us