FAA_ENFORCEMENT DATABASE
MAIN TABLE LAYOUT
Updated Oct. 2008
See code tables in separate file.

FIELD		DESCRIPTION			TYPE	LENGTH		CODE TABLE							
IID		Report number assigned by the 
ID		Report number assigned by the 
		originating office. Use this 
		field to link to other tables.	CHAR	14		None

RELREP		Related Report Number		CHAR	14		None
	
STATUS		Status of Report (Open, Closed,
		ending, Reopen)			CHAR	8		None	

SM_BUS_IND	Effective date 3/1/2005, case 	CHAR	5		None
		must have indicator which can 
		be a value 1,2,3 or 4.

YR		Calendar Year in which Report
		was Started			CHAR	6		None	

FISCAL_YR  	The Fiscal Year in which
		Report Number was Issued	CHAR	6		None	

RGN		Region Designation		CHAR	5		REG
		(note: in older data, some of 
		these regions aren't in the 
		lookup table)	

FIELD_OFF	Field office			CHAR	6		DO
		(note: in older data, some 
		regions have changed. See 
		lookup)

VIOL_NAME	Name of Alleged Violator	CHAR	52		None
		(see notes in ReadMe regarding
	 	expunged identities)			

DBA_NAME	Doing Business As Name 		CHAR	52		None	

DESIG		Air Operator Designator	
		(FAA designated ID)		CHAR	7		DESIG
		Codes for this field are in 
		the "designator" .pdf file	

SEX		Alleged Violator's Sex (unfortunately, this has been redacted)		CHAR	5		None	

CERT_NUM	Certificate number of Violator	CHAR	13		None 
		Airman or Organization			

CERT_REG	Certificating Region of the
		Air Operator			CHAR	5		REG

CERT_CODE	Code Identifying the Type
		Certificate Held by violator	CHAR	5		CRT

CERT_DESC	Text for certificate 
		type of violator		CHAR	22		CRT

AV_EMPLY	Violator Employer if Applicable,	
		or Responsible Air Operator	CHAR	52		None

EQU_TYPE	Type of equipment involved	CHAR	6		None	
		(examples: aircraft, engine, 
		propeller, component)

EQU_MAKE	Code Identifying Manufacturer 	CHAR	8		None
		of Aircraft, Engine or 
		Propeller			

EQU_MODEL	Type Certificate Model Number	CHAR	14		None
		of Aircraft, Engine, Propeller 
		or Appliance			

EQU_GRP		Identification Used to Group
		Model, Series or Categories	CHAR	8		None

EQU_NUM		Number Identifying the 		CHAR	11		None
		Equipment Involved 				
		(If Aircraft - N-number)	

EQU_SNUM	Serial Number of Equipment	CHAR	17		None	

OWNER_NAME	Name of Owner of Equipment	CHAR	52		None	

VIOL_DATE	Date of Alleged Violation					
		in character format		CHAR	18		None

TIME_VIOL 	Time of violation 		CHAR	6

CITY		City where Alleged Violation 
		Occurred			CHAR	17		None	

ST		State where Alleged Violation 
		Occurred			CHAR	6		ST	

FAA_DATE	Date violation first known
		to FAA in character format	CHAR	20		None	

OP_CODE		Code identifying type of the 
		operation at time of violation	CHAR	6		TYPOP
		(i.e. air carrier, airport, 
		manufacturer, repair station, 
		passenger, shipper)
		
OP_DESCR	Type Operation--Text		CHAR	22		TYPOP

OP_SUBCO	Code Identifying the Sub-Type 	CHAR	6		SUBOP
		Operation at time of Violation		
		(i.e. scheduled passenger, 
		business, foreign airman, 
		flight crew, airman)

OP_SUBD		Sub-Type Operation- Text	CHAR	22		SUBOP

CAT_CODE	Code Identifying Category of 
		Violation			CHAR	6		CAE
		(i.e. flight operations, 
		training, hazardous materials, 
		security, drug testing)

CAT_DESCR	Category of Violation Text	CHAR	22		CAE

SRC_CODE	Code Identifying violation 
		source				CHAR	6		SRC
		(i.e. incident investigation, 
		surveillance, facility 
		inspection, medical examiner)


SRC_DESCR	Source of Violation Text	CHAR	22		SRC


AXA_CODE	Code Identifying Accident 	CHAR	6		AAS
		involved in the violation	
		(associated, not associated, 
		no accident)

AXA_DESCR	Accident Involved with 
		Violation Text			CHAR	22		AAS

RO_DISC		Region where alleged Violation 
		was discovered			CHAR	6		REG

IN_OFF		Field Office Conducting 
		Investigation			CHAR	6		DO

FINA_DATE	Date of Final Action in		CHAR	18		None	
		Character Format

DT_BASE		Master Case of a Consolidated 
		Group				CHAR	14		None


GRP_DATE	Date Report Consolidated with	
		Master Case in Character Format	CHAR	6		None

CFIVESQ		Sequence Number of the Report 	CHAR	6		None

ORIGRECO	Original Record Owner		CHAR	6		DO
		(refers to district office)