FEDERAL AVIATION ADMINISTRATION

ASAS SAFETY DATA SYSTEM

ACCIDENT/INCIDENT DATA SYSTEM
TABLES

TABLE ID DESCRIPTION

ACL AIRCRAFT CLASS

ACT AIRCRAFT CATEGORY
AWC AIRWORTHINESS CLASS
BRK BRAKING ACTION
CF CAUSE FACTORS
CNC CONTRIBUTING CAUSE
DAM DAMAGE
DO DISTRICT OFFICE
ELT ELEC. LOCATION TRANSMITTER
ETYP ENGINE TYPE
EVT EVENT TYPE
EXI EXTENT OF INVESTIGATION
FCP FLYING CONDITIONS-PRIMARY
FCS FLYING CONDITIONS-SECONDARY
GCC GENERAL CAUSE CATEGORY
INV INVESTIGATING AGENCY
LC LIGHT CONDITIONS
LDS LATEST DATA SOURCE
LGCD LANDING GEAR TYPE
MID MIDAIR
NOT NOTIFICATION METHOD
NUMEG NUMBER OF ENGINES
OCC OPERATIONAL CAUSE CATEGORY
OPR OTHER RATINGS
OPS OPERATORS (SUFFIX)
OTH OTHER FACTORS
PC PILOT CERTIFICATION
PHS PHASE OF FLIGHT
PIN PERSONS INVOLVED
PLN FLIGHT PLAN
PLTPR PILOT PROFESSION
PQ PILOT QUALIFICATIONS
PR PILOT RATINGS AIRPLANE
PWRCL AIRCRAFT POWER CLASS
 RAT REMEDIAL ACTION TAKEN
REG REGION TABLE
RMA REMEDIAL ACTION AREA
RPT RELATED REPORTS
RWY RUNWAY CONDITION
SKY SKY CONDITION
ST STATE TABLE
STD STUDENT INDICATOR
SUP SUPPORTING FACTORS
TAP TYPE APPROACH
TES TYPE ENGINE SUFFIX
TFP TYPE FLYING - PRIMARY
TFS TYPE FLYING - SECONDARY
TYP TYPE OF ACCIDENT/INCIDENT
VIS VISIBILITY
VRS VISIBILITY RESTRICTIONS
WGT AIRCRAFT WEIGHT CLASS
WING AIRCRAFT WING CODE

=============================================================================================================================
==

FEDERAL AVIATION ADMINISTRATION

ASAS SAFETY DATA SYSTEM
ACCIDENT/INCIDENT DATA SYSTEM
CODES

TABLE ID : ACL DESCRIPTION : AIRCRAFT CLASS

CODE LONG DESCRIPTION SHORT DESCRIPTION

_________ ______________________________ ____________________

AMEL AIRPLANE - MULTI-ENGINE LAND AMEL

AMES AIRPLANE - MULTI-ENGINE SEA AMES
ASEL AIRPLANE - SINGLE ENGINE LAND ASEL
ASES AIRPLANE - SINGLE ENGINE SEA ASES
99999 AIRCRAFT CLASS INVALID ERROR MESSAGE
 TABLE ID : ACT DESCRIPTION : AIRCRAFT CATEGORY

CODE LONG DESCRIPTION SHORT DESCRIPTION

__________ ______________________________ ____________________

AIR AIRPLANE AIR

GLI GLIDER GLI
LTA LIGHTER THAN AIR LTA
ROT ROTORCRAFT ROT
99999 AIRCRAFT CATEGORY INVALID ERROR MESSAGE

TABLE ID : AWC DESCRIPTION : AIRWORTHINESS CLASS

CODE LONG DESCRIPTION SHORT DESCRIPTION

__________ ______________________________ ____________________

1 STANDARD STRD
2 LIMITED LIMT
3 RESTRICTED REST
4 EXPERIMENTAL EXPT
5 PROVISIONAL PROV
6 MULTIPLE MULT
8 SPECIAL FLIGHT PERMIT FERY
99999 AIRWORTHINESS CLASS ERROR MESSAGE

TABLE ID : BRK DESCRIPTION : BRAKING ACTION

CODE LONG DESCRIPTION SHORT DESCRIPTION

__________ ______________________________ ____________________

GD GOOD GD
PR POOR PR
99999 BRAKE ACTION INVALID ERROR MESSAGE

TABLE ID : CF DESCRIPTION : CAUSE FACTORS

CODE LONG DESCRIPTION SHORT DESCRIPTION

__________ ______________________________ ___________________

AA FAIL ADVISE UNSAFE APT COND APT/COND

AF IMPROPER MAINTENANCE APT FAC APT/FAC
AI INADEQUATELY MAINTAIN AWY FAC AWY/FAC
AL DIDN'T FLY ASG ALT IFR CLRNS ASG/ALT
AP INADEQUATELY MAINTAIN APCH FAC APCH/FAC
AS FAIL TO MAINTAIN ADEQ FLY SPD FLY/SPD
AT FAILED TO ADV OF OTHER TRAFFIC TFC/ADV
AU ATTEMPT OPERATION WITH DEF EQP EQP/DEF
AW FAIL TO ADV OF UNSAFE WX COND WX/COND
BS STRUCK BIRDS IN FLIGHT PATH STRUCK/BIRD
BW BLOWN OVER BY STRONG WIND BLOWN OVER
CE DIDN'T CLEAR ENGINE IN GLIDE ENG/GL
CH MISUSE CARBHT/DEIC PROC TB ENG CARBHT/DEIC
CI ISSUED IMPR CONFLICTING INSTS IMPR/INST
CP STUD PILOT CARRIED PASSENGERS STUD/PAX
CS IMPROP OPER COOL SYS OIL ENG C COOL/OIL
DC FAILED TO CORRECT FOR DRIFT DRIFT
DE DEFIC, CO MAINTAIN EQUIP/SERV EQUIP/SERV
DP FAIL COMPLY DISPATCH PROC REGS DISPATCH
DR DRANK ALCOHOLIC BEVERAGE ALCOHOL
DW DOWNWIND TAKEOFF OR LANDING TAKEOFF/DW
EL ATTEMPTED OPS BEYOND EXP LEVEL EXPER LEVEL
EQ IMPROPER OPERATION EMEG/EQUIP EMEG/EQUIP
ES STARTED ENG W/OUT ASSIST/EQUIP ENG/START
FA COLLIDED WITH OBJ ON FINAL APP COLLIDE/APP
FC CLEARED FLIGHT INADED FAC/DEST DEST/FAC
FE FAILED TO USE ENGINE FIRE/EXT FIRE/EXT
FN UNSAFE/COND & FAIL TO MARK OBS UNSAFE/COND
FO MISCELLANEOUS MISUSE FUEL SYS FUEL/SYS
FP FAIL FOLLOW APPROVED PROC/INST PROC/INST
FR FAILED TO RELINQUISH CONTROL RELINQ/CNTL
FT IMPROPER MGT/FUEL TANK SELECTO MGT/FUEL
FW FUEL UNPORT,FUEL NOT AT OUTLET FUELUNPORT
FX FULL FUEL TO FUEL LOW/EXHAUST FUEL/LOW
GA DELAYED IN INIT/GOAROUND INIT/GOAR
GC IMPROPER OPER BRAKE/FLT CLTGRD BRAKE/GRDCTL
GE FAIL TO USE/MISUSE EMERG GEAR EMERG/GEAR
GF OP GEAR CONTROL, FAIL OK POS GEAR/POSCK
GI INADVERTANT RETR LANDING GEAR RET/GEAR
GL EXTENDED GEAR TOO LATE GEAR/LATE
GN FORGOT TO EXTEND LANDING GEAR GEAR/NONE
GP RETRACT GEAR EARLY ON TAKEOFF GEAR/EARLY
 TABLE ID : CF DESCRIPTION : CAUSE FACTORS

CODE LONG DESCRIPTION SHORT DESCRIPTION

__________ ______________________________ ____________________

HA FAIL AVOID AC NONE AB/ONLY 1AB AVOID/AC

HG FAIL AVD COLLISION GRDN OR WTR GRND/WTR
HO FAIL AVD OBJS OR OBSTRUCTIONS OBJECT/AVOID
HT FAIL TO AVD TV OR RADIO TOWER TOWER/AVOID
IA AC IMPROPERLY ALIGN WITH RWY RWY/ALIGN
IC HAZD/MATER ON BOARD AIRCRAFT HAZD/MATER
IE AC IMPROPERLY EQUIP FOR FLIGHT AC/EQUIP
IF IMPROPER INSP OF FAC FAC/INSP
IG IMPROPER USE OF IGNIT SYSTEM IGNIT/USE
II INADEQUATE INSP OF AC PREFLT PREFLT/INSP
IO IMPROPER OPER FLT CNTL IN AIR FLTCNTL/AIR
IP IMPROPER INST PROC T/O LDG INST/PROC
IS INADEQ SPACE AC/WKE TURBULENCE AC/SPACE
IT INADEQ FLT/GRD TRAINING-PROCS TRAIN/PROC
LA AEROBATICS BELOW SAFE ALTITUDE ACRO/LOW
LC LOST CONTROL IN ADVERSE WX CNTL/WX
LO IMPROPER LEVEL OFF LVL/OFF
LR LOST GROUND REF AT NT VFR CNTL/NTVFR
MA FAIL AVOID AC/BOTH AIRBORNE ACAVOID/AIR
MC OP GAVE INCORRECT INFO TO CREW CREW/INST
ME FAIL/INCORRECT USE MISC EQUIP USE/EQUIP
MI MISUNDERSTAND ORD,INSTRUCT,ETC INSTRUCT
MM MISUSED MIXTURE CONTROL MIX/CNTL
MO PILOT/CREW MISMANAGED AC SYS EQUIP/MGT
MT MISUSE OF TRIM MISTRIM
NO FAILED TO ISSUE NOTAM ISSUE/NOTAM
OB ADVANCED THROT RAPIDLY/BOOST THROT/BOOST
OC LOST ON/OFF COURSE VFR LOST/VFR
OF IMPROPER OPERATION OF FAC OPER/FAC
OM OTHER, MISCELLANEOUS OTHER/MISC
OP IMPROPER OPERATION OF PROPELER OP/PROP
OS LAND FAR DOWN LAND AREA/OVSHOT OV/SHOOT
OT FAIL TO ATTAIN PROPER OP TEMP OP/TEMP
PA TAXI/PARK WITHOUT PROP ASSIST TAXI/PARK
PB POOR PREFLIGHT PLAN/WT AND BAL PLAN/WTBAL
PC PILOT INCAP EXCLUDES ALCOHOL INCAP
PD FAIL PROV ADEQ DIR,MANUALS,ETC PLAN/MANUAL
PF POOR PREFLIGHT PLAN FUEL QT PLAN/FUELQT
PI CNTL INTFR BY PASSENGER/CREW CNTL/INTFR
PL EARLY LIFTOFF/INT/TERRAIN EARLY/LIFTOF
PO INADEQ/IMP PF PREP/PLANNING PLAN/OTHER
PP POOR PREFLIGHT PLAN/AC PERF PLAN/ACPERF

TABLE ID : CF DESCRIPTION : CAUSE FACTORS

CODE LONG DESCRIPTION SHORT DESCRIPTION

__________ ______________________________ ____________________

PS INADEQUATE FLT/SUPERV (PILOT) FLT/SUPERV

PW POOR PREFLIGHT PLANNING-WX PLAN/WX
RC CLEAR AC WRWY FOR CONDITION CLEAR/WRWY
RI UNABLE UTIL NAVIG FAC PROP IFR USE/FACIFR
RS FAIL MAINTAIN ADEQ ROTOR RPM ROTOR/RPM
RV UNABLE UTIL NAVIG FAC PROP VFR USE/FACVFR
SA IMPROPERLY SERVICED AC AC/SERVICE
SC INADEQ SUP-VISION TRAIN RAMP C TRAIN/RAMP
SD STRUCK ANIMAL HITANML
SN UNSUITABLE TERRAIN SN/IC AREA TERRAIN/SNIC
SO MISC UNSAFE ACTS START ENGINE START/ENG
SP WALK INTO PROPELLER OR ROTOR WALK/PROP
SR IMP/INADEQ SNICE/REMOVE FROMAC REMOVE/SNICE
ST CONT FLT AREA SEVERE TURB FLT/TURB
TC INSUFFICIENT TERRAIN CLR IN RT ENRT/TERRAIN
TO DELAY ACTION IN ABORTED TKOF TKOF/DELAY
TP IMPROPER PROC IN TFC TFC/PROC
TX TKOF ADVRSE WX CRASH IMMED VIC TKOF/WX
UA UNAUTHORIZED ACTION UNAUTH/ACT
UD UNDETERMINED UNDETER
UN MISC/PILOT UNSAFE ACTS MISC/PILACT
UO UNSAFE ACTS BY THIRD PARTY MISC/THDPTY
US LANDED SHORT LAND/UNDER
UT SELECTED UNSUITABLE TERRAIN. TERRAIN/UNSU
VM OPERATION BELOW VMC BELOW VMC
WF INCORRECT WEATHER FORECAST WX/FORECAST
WO WHITEOUT CONDITIONS WHITE OUT
WR INCOMPLETE WEATHER REPORT WX/REPORT
WS WINDSHEAR WINDSHEAR
WX CONT VFR FLIGHT INTO ADV WX WX/VFR
XL EXCEED LOAD DSGN AC SPEED CONT DSGN/LOAD
99999 CAUSE FACTOR INVALID ERROR MESSAGE
 TABLE ID : CNC DESCRIPTION : CONTRIBUTING CAUSE

CODE LONG DESCRIPTION SHORT DESCRIPTION

__________ ______________________________ ____________________

A WET RUNWAY WETRWY

B ICE/SLUSH RUNWAY ICESLS
C SOFT SHOULDERS SOFTSH
D DITCHING DITCH
E EMERGENCY LANDING EMLAND
F FIRE AFTER CRASH FIRE
G GLASSY WATER GLASSY
H HIDDEN HAZARDOUS OBJECTS HAZOBS
I ICING ON AIRCRAFT ICING
J SHIFTING FUEL CARGO SHIFT
K HIGH VEGETATION HIGHVG
L SABOTAGE SABOTG
M DECOMPRESSION, HYPOXIA DECOMP
N PAX DISTURBANCE PAXDST
O PRECAUTIONARY LANDING PRECLD
P ROUGH WATER ROUGHW
Q SNOW BANK SNOBNK
R UNDERTERMINED UNDET
S INADEQUATE RWY, TAXIWAY LGTS ACEVAC
T DOWNDRAFT DWNDRF
U BLADE STALL BLADST
V OTHER/MISCELLANEOUS MISCL
W STOLEN AIRCRAFT STOLAC
X BIRD STRIKE BIRDS
Y DENSITY ALTITUDE DENALT
Z WEATHER WX
1 VISION OBSCURED BY SUN VISOBS
2 WINDSHIELD-OIL,FOG,ICE, RAIN FOGICE
3 PILOT FATIGUE OR LACK OF REST PLTFAT
4 ROUGH OR RUTTED SOD RUFF
5 GUSTY WINDS WIND
6 STRUCK ANIMAL ANMLS
7 SETTLING W/POWER SETTL W/PWR
8 LOSS OF TAIL ROTOR EFFECT LT EFFECT
99999 CONTRIBUTING CAUSE INVALID ERROR MESSAGE

TABLE ID : DAM DESCRIPTION : DAMAGE

CODE LONG DESCRIPTION SHORT DESCRIPTION
__________ ______________________________ ____________________

D DEMOLISHED DMOL
M MINOR MINR
N NONE NONE
S SUBSTANTIAL SUBS
U UNKNOWN UNKN
99999 DAMAGE CODE INVALID ERROR MESSAGE

TABLE ID : DO DESCRIPTION: DISTRICT OFFICE

CODE LONG DESCRIPTION SHORT DESCRIPTION

ACRC AERONAUTICAL CENTER COUNSEL OK ACRC

AC70 "REGIONAL SEC PROG, OKC OK" AC70
AC74 REGIONAL SEC PROG OKC OK LEAU AC74
AC75 REGIONAL SEC PROG OKC OK DWI AC75
AC78 REGIONAL SEC DISU PROG OKC OK AC78
AC90 AERONAUTICAL CENTER - MEDICAL AC90
AGC1 OFFICE OF THE CHIEF COUNSEL AGC1
ALRC ALASKAN REG COUNSEL ANC AL ALRC
AL00 REGIONAL FLT STDS OFC ANC AL AL00
AL01 FAIRBANKS AK FSDO AL01
AL03 ANCHORAGE AK FSDO AL03
AL05 JUNEAU AK FSDO AL05
AL70 REGIONAL SECURITY PROG ANC AL AL70
AL72 ANCHORAGE INTL AK CASFO AL72
AL78 ANCHORAGE AK AAL-710 AL78
AL79 ANCHORAGE AK AAL-710 AL79
AL80 REGIONAL AIRPORT PROG ANC AL AL80
AL90 REGIONAL FLIGHT SURGEON ANC AL AL90
AL91 DRUG ABATEMENT AAL-305 AL91
AUS AUSTRALIA
CA CANADA
CERC CENTRAL REG COUNSEL KC MO CERC
CE00 REGIONAL FLT STDS OFC KC MO CE00
CE01 DES MOINES IA FSD0 CE01
CE03 ST LOUIS MO FSDO CE03
CE05 KANSAS CITY MO FSDO CE05
CE07 WICHITA KS FSDO CE05
CE09 LINCOLN NE FSDO CE09
CE40 KAN CITY MO ACE-108 CE40
CE42 ATLANTA GA MIDO CE42
CE43 WICHITA KS MIDO CE43
CE44 MIAMI FL MIDO CE44
CE45 KANSAS CITY MO MIDO CE45
CE46 MINNEAPOLIS MN MIDO CE46
CE47 CLEVELAND OH MIDO CE47
CE48 VANDALIA OH MIDO CE48
CE49 LAKELAND FL MISO CE49
CE50 NASHVILLE TN MISO CE50
CE51 MOBILE AL MISO CE51
CE52 SAVANNAH GA MISO CE52
CE53 DETROIT MI MISO CE53
CE54 INDIANAPOLIS IN MISO CE54
CE55 CHICAGO IL MISO CE55
CE56 ATLANTA ACO ACE-115A CE56
CE57 CHICAGO ACO ACE-115C CE57
CE58 ANCHORAGE ACO ACE-115N CE58
CE59 WICHITA ACO ACE-115W CE59
CE70 REGIONAL SECURITY PROG KC MO CE70
CE71 KANSAS CITY INTL MO CASFO CE71
CE72 LAMBERT-ST LOUIS INTL MO CASFO CE72
CE73 REGIONAL FIELD STAFF KC MO CE73
CE78 KAN CITY MO ACE-710 CE78
CE79 KAN CITY MO ACE-710 CE79
CE80 REGIONAL AIRPORT PROG KC MO CE80
CE90 REGIONAL FLIGHT SURGEON KC MO CE90
CE91 DRUG ABATEMENT ACE-303 CE91
EARC EASTERN REG COUNSEL NY NY EARC
EA00 REGIONAL FLT STDS OFFICE NY NY EA00
EA01 ALBANY NY FSDO EA01
EA03 ALLEGHENY PITTSBURGH PA FSDO EA03
EA05 ALLENTOWN PA FSDO EA05
EA07 BALTIMORE MD FSDO EA07
EA09 CHARLESTON WV FSDO EA09
EA11 FARMINGDALE NY FSDO EA11
EA13 HARRISBURG PA FSDO EA13
EA15 NEW YORK NY-AIR CARRIER FSDO EA15
EA16 NEW YORK CERT MGT OFC FSDO EA16
EA17 PHILADELPHIA PA FSDO EA17
EA19 PITTSBURGH PA-AIR CARRIER FSDO EA19
EA21 RICHMOND VA FSDO EA21
EA23 ROCHESTER NY FSDO EA23
EA25 TETERBORO NJ FSD0 EA25
EA27 WASHINGTON DC FSDO EA27
EA29 NY INTL FIELD OFFICE FSDO EA29
EA31 BRUSSELS IFO EA31
EA33 FRANKFURT GE FSDO EA33
EA35 LONDON/GATEWICK ENGLAND EA35
EA70 REGIONAL SECURITY PROG NY NY EA70
EA71 JFK INTL NY CASFO EA71
EA72 DULLES ARPT-CHANTILLY VA CASFO EA72
EA73 PHILADELPHIA INTL PA CASFU EA73
EA74 PITTSBURGH INTL PA CASFU EA74
EA78 NEW YORK NY AEA-710 EA78
EA79 NEW YORK NY AEA-710 EA79
EA80 REGIONAL AIRPORT PROG NY NY EA80
EA90 AEA-300 REG FLIGHT SURGEON NY EA90
EA91 DRUG ABATEMENT AEA-301 EA91
EU00 REGIONAL FLT STDS OFC BRUSSELS EU00
EU01 FRANKFURT GE FSDO EU01
EU02 FRANKFURT GEOGRAPHIC UNIT IFO EU02
EU03 LONDON/GATEWICK ENGLAND EU03
EU70 REGIONAL SEC OFC BRUSSELS BE EU70
EU72 BRUSSELS - OPERATION BRANCH EU72
EU73 BAHRAIN CASIFO EU73
EU74 BRUSSELS CASIFO EU74
EU76 ROME CASIFO EU76
FS01 GENERIC-AFS-643 RESPONSIBLE AFS-643
GLRC GREAT LAKES REG COUNSEL CHICAG O GLRC
GL00 REGIONAL FLT STDS OFC CHICAGO GL00
GL01 MINNEAPOLIS MN CMO GL01
GL03 WEST CHICAGO IL FSDO GL03
GL05 CINCINNATI OH FSDO GL05
GL07 COLUMBUS OH FSDO GL07
GL09 GRAND RAPIDS MI FSDO GL09
GL10 INDIANAPOLIS IN FSDO GL10
GL11 INDIANAPOLIS IN FSDO GL11
GL13 MILWAUKEE WI FSDO GL13
GL15 MINNEAPOLIS MN FSDO GL15
GL17 SOUTH BEND IN FSDO GL17
GL19 SPRINGFIELD IL FSDO GL19
GL21 FARGO ND FSDO GL21
GL23 BELLEVILLE (DETROIT) MI FSDO GL23
GL25 CLEVELAND OH FSDO GL25
GL27 RAPID CITY SD FSDO GL27
GL31 SCHILLER PK (CHICAGO) IL FSDO GL31
GL70 REGIONAL SECURITY OFC CHICAGO GL70
GL71 REGIONAL FIELD STAFF CASFO GL71
GL72 DETROIT METRO MI CASFU GL72
GL73 MINN-ST PAUL MN INTL CASFO GL73
GL74 CHICAGO O'HARE INTL IL CASFO GL74
GL75 CLEVELAND CASFU GL75
GL76 INDIANAPOLIS/COLUMBUS GL76
GL78 CHICAGO IL AGL-710 GL78
GL79 CHICAGO IL AGL-710 GL79
GL80 REGIONAL ARPT PROG CHICAGO IL GL80
GL90 REGIONAL FLT SURGEON CHICAGO GL90
GL91 DRUG ABATEMENT AGL-306 GL91
NERC NEW ENGLAND REG COUNSEL BOSTON NERC
NE00 REGIONAL FLT STDS OFC BOSTON NE00
NE01 BEDFORD MA FSDO NE01
NE02 BOSTON-LOGAN MA FSDO NE02
NE03 WINDSOR LOCKS CT FSDO NE03
NE05 PORTLAND ME FSDO NE05
NE40 BOSTON MA MIDO NE40
NE41 WINDSOR LOCKS CT MIDO NE41
NE42 "BURLINGTON, MA MISO" NE42
NE43 NOT USED-NOW NE46 FARMINGDALE NE43
NE44 NEW CUMBERLAND PA MIDO NE44
NE45 TETERBORO NJ MIDO NE45
NE46 FARMINGDALE NY MIDO NE46
NE47 NOT USED-NOW NE-56 NE47
NE48 ENG & PROP STDS STAFF ANE-110 NE48
NE49 TECH & ADMIN SUP STAFF ANE-103 NE49
NE56 ENGINE CERTIFATION OFFICE ANE-140 NE56
NE57 BOSTON ACO ANE-150 NE57
NE58 NEW YORK ACO ANE-170 NE58
NE70 REGIONAL SECURITY PROG BOSTON NE70
NE71 BOSTON LOGAN INTL MA CASFO NE71
NE78 BOSTON MA ANE-710 NE78
NE79 BOSTON MA ANE-710 NE79
NE80 REGIONAL ARPT PROG BOSTON MA NE80
NE90 REGNL FLT SURGEON BOSTON MA NE90
NE91 DRUG ABATEMENT ANE-302 NE91
NMRC NM MOUNTAIN REG CNSL SEATTLE NMRC
NM00 REGIONAL FLT STDS OFC SEATTLE NM00
NM01 SEATTLE WA FSDO NM01
NM02 SPOKANE WA FSDO NM02
NM03 DENVER CO FSDO NM03
NM04 CASPER WY FSDO NM04
NM05 HELENA MT FSDO NM05
NM06 BILLINGS MT FSDO NM06
NM07 SALT LAKE CITY UT FSDO NM07
NM08 BOISE ID NOW NM11 NM08
NM09 PORTLAND OR FSDO NM09
NM10 EUGENE OR FSDO NM10
NM11 BOISE ID FSDO NM11
NM13 SPOKANE WA FSDO NM13
NM40 NM CERT DIRECTRATE SEATTLE WA NM40
NM41 EVERETT WA MIDO NM41
NM42 RENTON WA MIDO NM42
NM43 AUBURN WA MISO NM43
NM46 LOS ANGELES CA MIDO NM46
NM47 LONG BEACH CA MIDO NM47
NM48 VAN NUYS CA MIDO NM48
NM50 PHOENIZ AZ MIDO NM50
NM51 SEATTLE WA - MIDO NM51
NM56 SEATTLE ACO ANM100S NM56
NM57 DENVER ACO ANM-100D NM57
NM58 LOS ANGELES ACO ANM-100L NM58
NM70 REGIONAL SEC PROG SEATTLE WA NM70
NM71 SEATTLE-TACOMA INTL WA CASFO NM71
NM72 DENVER CO CASFO NM72
NM73 DENVER DISU NM73
NM78 SEATTLE WA ANM-710 NM78
NM79 SEATTLE WA ANM-710 CASFO NM79
NM80 REGIONAL APRT OFC SEATTLE WA NM80
NM81 DENVER CO AIRPORT DIST OFFICE NM81
NM82 HELENA MT AIRPORT DIST OFFICE NM82
NM83 SEATTLE WA AIRPORT DIST OFFICE NM83
NM90 REGIONAL FLT SURGEON SEATTLE NM90
NM91 DRUG ABATEMENT ANM-304 NM91
SD00 SELF DISCLOSURE FLT STANDARD SD FLT STND
SORC SOUTHERN REGION COUNSEL ATLANTA SORC
SO00 REGIONAL FLT STDS OFC ATLANTA SO00
SO01 LOUISVILLE KY FSDO SO01
SO03 NASHVILLE TN FSDO SO03
SO05 WINSTON-SALEM NC FSDO SO05
SO06 RALEIGH NC FSDO SO06
SO07 JACKSON MS FSDO SO07
SO08 CHARLOTTE NC FSDO SO08
SO09 BIRMINGHAM AL FSDO SO09
SO11 ATLANTA GA FSDO SO11
SO13 COLUMBIA SC FSDO SO13
SO14 ST PETERSBURG FL FSDO SO14
SO15 ORLANDO FL FSDO SO15
SO16 JACKSONVILLE FL FSDO SO16
SO17 FT LAUDERDALE FL FSDO SO17
SO19 MIAMI FL FSDO SO19
SO21 SAN JUAN PR FSDO SO21
SO23 MIAMI INTL FIELD OFC IFO SO23
SO25 MEMPHIS TN FSDO SO25
SO27 ATLANTA GA - DELTA CMO SO27
SO31 FS EVALUATION SVC OFC-ATLANTA FSESO - ATLANTA GA
SO33 CHARLOTTE NC - FSDO SO33
SO64 ORLANDO FL SO64
SO70 REGINAL SECURITY PROG ATLANTA SO70
SO71 REGION SEC STAFF ATL GA CASFO SO71
SO72 SECURITY FLD OFC STAFF ATL GA SO72
SO73 ATLANTA GA INTL ARPT CASFO SO73
SO74 MIAMI INTL FL CASFO SO74
SO75 SAN JUAN PR INTL CASFO SO75
SO76 TAMPA INTL FL CASFU SO76
SO77 INTERNATIONAL SECT MIAMI FL INTL SECT MIAMI FL
SO78 ATLANTA GA ASO-710 SO78
SO79 ATLANTA GA ASO-710 SO79
SO80 REGIONAL ARPT PROG ATLANTA GA SO80
SO90 REGIONAL FLT SURGEON ATLANTA SO90
SO91 ATLANTA ARTCC MEDICAL OFFICE SO91
SO92 MEMPHIS ARTCC MEDICAL OFFICE SO92
SO93 JACKSONVILLE ARTCC MED OFFICE SO93
SO94 MIAMI ARTCC MEDICAL OFFICE SO94
SO95 DRUG ABATEMENT ASO-305 SO95
SWRC SOUTHWEST REGION COUNSEL FT WORTH SWRC
SW00 REGIONAL FLT STDS OFC FT WORTH SW00
SW01 ALBUQUERQUE NM FSDO SW01
SW02 DALLAS TX SW02
SW03 BATON ROUGE LA FSDO SW03
SW05 DALLAS TX GEN AVN FSDO SW05
SW07 DFW AIRPORT TX A/C FSDO SW07
SW09 HOUSTON TX FSDO SW09
SW11 LITTLE ROCK AR FSDO SW11
SW13 LUBBOCK TX FSDO SW13
SW15 OKLA CITY OK FSDO SW15
SW17 SAN ANTONIO TX FSDO SW17
SW19 FT WORTH TX FSDO SW19
SW21 DFW AIRPORT TX CMO SW21
SW40 SW CERT DIRECTORATE FT WORTH SW40
SW41 BETHANY OK MIDO SW41
SW42 FT WORTH TX MIDO SW42
SW43 SAN ANTONIO TX MIDO SW43
SW56 AIRPLANE CERT OFC ASW-150 SW56
SW57 ROTORCRAFT CERT OFC ASW-170 SW57
SW70 ASW-700 SECURITY PROG AREA SW70
SW71 DFW INTL ARPT TX CASFO SW71
SW72 HOUSTON TX INTERCONT CASFO SW72
SW73 ST ROSE (NEW ORLEANS) LA CASFU SW73
SW78 FT WORTH TX ASW-710 SW78
SW79 FT WORTH TX ASW-710 SW79
SW80 REGIONAL ARPT PROG FT WORTH TX SW80
SW84 FT WORTH TX ARPT OFFICE SW84
SW90 REGIONAL FLT SURGEON FT WORTH SW90
SW91 DRUG ABATEMENT ASW-305 SW91
SW99 "FOR SDR FILLER CODE, ALL REG" SW99
WA45 ACCIDENT INVESTIGATION AAI-100 WA45
WA70 CIVIL AVN SECURITY ACS-1 DC WA70
WA71 CIVIL AVN SEC DIV ACS-100 DC WA71
WA72 SPECIAL PROG DIV ACS-200 DC WA72
WA73 INVEST & SEC DIV ACS-300 DC WA73
WA91 DRUG ABATEMENT AAM-820 DC WA91
WPRC WESTERN PACIFIC REG CNSL LA CA WPRC
WP00 REGIONAL FLT STDS OFC LA CA WP00
WP01 VAN NUYS CA FSDO WP01
WP02 SAN JOSE FSDO WP02
WP03 SAN FRANCISCO CA FSDO WP03
WP05 LONG BEACH CA FSDO WP05
WP06 LAS VEGAS NV FSDO WP06
WP07 SCOTTSDALE AZ FSDO WP07
WP09 SAN DIEGO CA FSDO WP09
WP11 RENO NV FSDO WP11
WP13 HONOLULU HI FSDO WP13
WP15 SAN JOSE CA FSDO WP15
WP17 FRESNO CA FSDO WP17
WP19 LAS VEGAS NV FSDO WP19
WP21 RIVERSIDE CA FSDO WP21
WP23 LOS ANGELES CA FSDO WP23
WP25 SACRAMENTO CA FSDO WP25
WP27 OAKLAND CA FSDO WP27
WP28 PHOENIX AZ CMO WP28
WP29 SAN FRANCISCO CA CMO-AW WP29
WP30 DENVER CO CMO WP30
WP31 LOS ANGELES INTL FS OFC FSDO WP31
WP33 SINGAPORE IFO WP33
WP70 REGIONAL SECURITY PROG LA CA WP70
WP71 LOS ANGELES INTL CA CASFO WP71
WP72 LAS VEGAS NV CASFU WP72
WP73 PHOENIX INTL AZ CASFO WP73
WP74 SINGAPORE/SIN CASIFO WP74
WP75 SAN FRANCISCO INTL CA CASFO WP75
WP76 HONOLULU INTL HI CASFO WP76
WP77 ASIAN AREA SECURITY STAFF WP77
WP78 LOS ANGELES CA AWP-710 WP78
WP79 LOS ANGELES CA AWP-710 WP79
WP80 REGIONAL AIRPORT PROG LA CA WP80
WP81 SOUTHERN ARPT FLD OFC LA CA WP81
WP82 NORTHERN ARPT FLD OFC SF CA WP82
WP83 HONOLULU HI ARPT DISTRICT OFC WP83
WP90 REGIONAL FLT SURGEON LA CA WP90
WP91 DRUG ABATEMENT AWP-320 WP91
99999 FIELD OFFICE INVALID ERROR MESSAGE

TABLE ID : ELT DESCRIPTION : ELEC. LOCATION TRANSMITTER

CODE LONG DESCRIPTION SHORT DESCRIPTION

__________ ______________________________ ____________________

1 YES Y
2 NO N
3 UNKNOWN U
4 ELT NOT ACTIVATE TIME OF ACCI P
99999 ELT CODE INVALID ERROR MESSAGE

TABLE ID : EPWCL DESCRIPTION : ENGINE POWER CLASS

CODE LONG DESCRIPTION SHORT DESCRIPTION

__________ ______________________________ ____________________

3 UNDER 751 HP UNDER 751 HP

4 OVER 750 HP OVER 750 HP
99999 INVALID ENGINE POWER CLASS ERROR MESSAGE

TABLE ID : ETYP DESCRIPTION : ENGINE TYPE

CODE LONG DESCRIPTION SHORT DESCRIPTION LAST CHANGE DATE/OPR

__________ ______________________________ ____________________ ____________________

F TURBOFAN/TURBOJET BYPASS TURBOFAN/TURBOJET

I PISTON - INLINE PISTON - INLINE
J TURBOJET TURBOJET
O PISTON - OPPOSED PISTON - OPPOSED
R PISTON - RADIAL PISTON - RADIAL
T TURBOPROP TURBOPROP
U TURBOSHAFT TURBOSHAFT
V VEE VEE
W ROTARY ROTARY
X OTHER OTHER
Y ROCKET ROCKET
Z PURE JET - PULSE/RAM PURE JET - PULSE/RAM
99999 INVALID ENGINE TYPE

TABLE ID : EVT DESCRIPTION : EVENT TYPE

CODE LONG DESCRIPTION SHORT DESCRIPTION

_________ ______________________________ ____________________

A GENERAL AVIATION ACCIDENT A

B AIR CARRIER ACCIDENT B
C INCIDENT - AIR CARRIER C
G INCIDENT - GENERAL AVIATION G
99999 EVENT TYPE INVALID ERROR MESSAGE

TABLE ID : EXI DESCRIPTION : EXTENT OF INVESTIGATION

CODE LONG DESCRIPTION SHORT DESCRIPTION

_________ ______________________________ ____________________

D DESK INVESTIGATION D
F FIELD INVESTIGATION F
O OFFICE O
S SCENE S
99999 EXT OF INVEST CODE INVALID ERROR MESSAGE

TABLE ID : FCP DESCRIPTION : FLYING CONDITIONS-PRIMARY

CODE LONG DESCRIPTION SHORT DESCRIPTION

__________ ______________________________ ____________________

A IFR IFR
B VFR VFR
C UNKNOWN UNK
99999 FLY COND-PRI CODE INVALID ERROR MESSAGE

TABLE ID : FCS DESCRIPTION : FLYING CONDITIONS-SECONDARY

CODE LONG DESCRIPTION SHORT DESCRIPTION

_________ ______________________________ ____________________

A TORNADO TORN
B HURRICANE HURR
C MOUNTAIN WAVE WAVE
D FRONTAL ACTIVITY FRTA
E LINE SQUALL SQAL
F FOG FOG
G WIND WIND
H LIGHT RAIN LTRN
I LIGHT FREEZING RAIN LFZR
J HEAVY RAIN HVRN
K HEAVY FREEZING RAIN HFZR
L LOW CEILING CEIL
M HEAVY SNOW HSNO
N LIGHT SNOW LSNO
O FREEZING TEMPERATURE FZTP
P FRONTAL PASSAGE FRTP
Q WHIRLWIND WHIR
R FROST FRST
S WEATHER NOT A FACTOR NOWX
T THUNDERSTORM TDST
U TURBULENCE TURB
V OTHER OTHR
W UNKNOWN UNKN
99999 FLY COND-SEC CODE INVALID ERROR MESSAGE

TABLE ID : GCC DESCRIPTION : GENERAL CAUSE CATEGORY

CODE LONG DESCRIPTION SHORT DESCRIPTION

__________ ______________________________ ____________________

A PILOT AND GROUND CREW PILTG

1 IMPROPER MAINTENANCE IMPRM
2 MANUFACTURER/BUILDER MANUF
3 DESIGN OF AIRCRAFT DESGN
4 OPDEF, OTHER THAN PILOT OPDEF
5 PILOT INDUCED PILOT
6 UNDETERMINED UNDET
7 MISCELLANEOUS, OTHER, NONE MISCL
8 PILOT AND MAINTENANCE PILTM
9 INADEQUATE MAINTENANCE INADM
99999 GENERAL CAUSE CAT INVALID ERROR MESSAGE

TABLE ID : INV DESCRIPTION : INVESTIGATING AGENCY

CODE LONG DESCRIPTION SHORT DESCRIPTION

__________ ______________________________ ____________________

F FAA F
N NTSB N
99999 INVEST AGENCY INVALID ERROR MESSAGE

TABLE ID : LC DESCRIPTION : LIGHT CONDITIONS

CODE LONG DESCRIPTION SHORT DESCRIPTION

__________ ______________________________ ____________________

1 DAY DAY
2 NIGHT NIT
3 DAWN DWN
4 DUSK DSK
5 UNKNOWN UNK
99999 LIGHT COND INVALID ERROR MESSAGE

TABLE ID : LDS DESCRIPTION : LATEST DATA SOURCE

CODE LONG DESCRIPTION SHORT DESCRIPTION
_________ ______________________________ ____________________

.19 NTSB ACCIDENT FORM 6120.19 .19

.4 NTSB ACCIDENT FORM 6120.4 .4
-5 FAA INCIDENT FORM 8020-5 -5
-23 FAA ACCIDENT/INCIDENT REPORT 8020-23 -23
OS OTHER SOURCE OTHER DATA SOURCE
TTY FAA ACCIDENT FORM 8020-9 TTY
99999 LATEST DATA SRC INVALID ERROR MESSAGE

TABLE ID : LGCD DESCRIPTION : LANDING GEAR TYPE

CODE LONG DESCRIPTION SHORT DESCRIPTION

__________ ______________________________ ____________________

NC NONRETRACT CONVENTIONAL NONRTRCT CONVNTIONAL

NT NONRETRACT TRICYCLE NONRETRACT TRICYCLE
RC RETRACT CONVENTIONAL RETRACT CONVENTIONAL
RT RETRACT TRICYCLE RETRACT TRICYCLE
99999 INVALID LANDING GEAR TYPE

TABLE ID : MID DESCRIPTION : MIDAIR

CODE LONG DESCRIPTION SHORT DESCRIPTION

_________ ______________________________ ____________________

1 FIRST AIRPLANE INVOLVED 1

2 SECOND AIRPLANE INVOLVED 2
3 THIRD AIRPLANE INVOLVED 3
9 NOT A MIDAIR 9
99999 MIDAIR CODE INVALID ERROR MESSAGE

TABLE ID : NOT DESCRIPTION : NOTIFICATION METHOD

CODE LONG DESCRIPTION SHORT DESCRIPTION

_________ ______________________________ ____________________

AFS WITHIN FLIGHT STANDARD SERVICE AFS

ATS AIR TRAFFIC SERVICE ATS
DOD U.S. MILITARY SERVICE DOD
FAA OTHER FAA ORGANIZATIONAL UNIT FAA
LSG LOCAL/STATE GOVERNMENT LSG
NTS NTSB NTS
OPP OPERATOR OR PILOT INVOLVED OPP
OTH OTHER OR UNKNOWN OTH
USG OTHER U.S. GOVERNMENT AGENCY USG
99999 NOTIFY METHOD INVALID ERROR MESSAGE

TABLE ID : NUMEG DESCRIPTION : NUMBER OF ENGINES

CODE LONG DESCRIPTION SHORT DESCRIPTION

_________ ______________________________ ____________________

01 ONE ENGINE 01
02 TWO ENGINES 02
03 THREE ENGINES 03
04 FOUR ENGINES 04
05 FIVE ENGINES 05
99999 INVALID NUMBER OF ENGINES

TABLE ID : OCC DESCRIPTION : OPERATIONAL CAUSE CATEGORY

CODE LONG DESCRIPTION SHORT DESCRIPTION

_________ ______________________________ ____________________

A MISJUDGMENT MISJG
B MISTAKE MISTK
C CALCULATED RISK CALCR
D LACK OF SUPERVISION LASUP
E INATTENTION INATT
F CARELESS CARLS
G RECKLESS RCKLS
H UNSKILLED IN AIRCRAFT UNSKL
I UNSKILLED IN TYPE OF OPERATION UNOPS
J UNFORSEEN SITUATION UNSIT
K STOLEN AIRCRAFT STOLN
L PILOT INCAPACITATION-MEDICAL INMED
M PILOT INCAPACITATION-ALCOHOL INACL
N PILOT INCAPACITATION-OTHER INOTH
O BIRD STRIKE BIRDS
P DENSITY ALTITUDE DENAL
Q LACK OF RECENT EXPERIENCE LREXP
R WEATHER-PILOT RCVD WX BRIEFING WXBRF
S OTHER OTHER
T SUPPLEMENT FORTHCOMING SUPFC
U UNKNOWN UNK
V WEATHER-BRIEFING NOT REPORTED WXBRU
W WEATHER-PILOT NOT WX BRIEFED WXNBR
Y PILOT REPORTED DEPRESSED PLRPTDEP
99999 OPER CAUSE CAT INVALID ERROR MESSAGE

TABLE ID : OPR DESCRIPTION : OTHER RATINGS

CODE LONG DESCRIPTION SHORT DESCRIPTION

_________ ______________________________ ____________________

0 RATINGS SHOWN BY 1ST 2 DIGITS NONE

1 STUDENT AIRPLANE OR HELICOPTER STAH
2 STUD GLIDER/LIGHTER THAN AIR STGL
3 INSTRUMENT INST
4 LIGHTER THAN AIR LTA
5 LIGHTER THAN AIR & INSTRUMENT LTAI
6 NOT USED
7 NOT USED
8 FOREIGN FORN
9 UNKNOWN UNKN
99999 OTHER RATE INVALID ERROR MESSAGE

TABLE ID : OPS DESCRIPTION : OPERATORS (SUFFIX)

CODE LONG DESCRIPTION SHORT DESCRIPTION

_________ ______________________________ ____________________

A SCHEDULED PASS, DOMESTIC TRUNK A

B SCHEDULED PASS, LOCAL SERVICE B
C SCHEDULED PASS, ALASKA/HAWAII C
D SCHED PASS, INTERNATIONAL/TERR D
E SCHED PASS, HELICOPTER OPER E
F SCHEDULED AIR CARGO F
G SUPPLEMENTAL AIR CARRIER G
H COMMUTER OPERATOR H
I A/TAXI OPER-CAB EXEMPTION I
J AIR TAXI J
K AIR TRAVEL CLUB K
L ALL CARGO L
99999 OPERATORS SFX INVALID ERROR MESSAGE
 TABLE ID : OTH DESCRIPTION : OTHER FACTORS

CODE LONG DESCRIPTION SHORT DESCRIPTION

_________ ______________________________ ____________________

ZA UNSCHEDULED LANDING LAND/UNSCHED

ZB LANDED ON WRONG AIRPORT LAND/WRGAPT
ZC LANDED ON WRONG RUNWAY LAND/WRGRWY
ZD OFF SIDE OF RUNWAY OFF/RWY
ZE REJECTED TAKEOFF REJECT/TO
ZF MERCY LANDING LAND/MERCY
ZG DECLARED EMERGENCY EMEG/DECL
ZH DESCENT EMERGENCY EMEG/DESC
ZI COLLISION AVOIDANCE MANEUVER AVOID/COLL
ZJ EVACUATION EVAC
ZK FIRE AND RESCUE - ALERT FIRERES/ALRT
ZL FIRE AND RESCUE - ACTION FIRERES/ACTN
ZM NEAR MIDAIR NEAR/MID
ZN RUNWAY BLOCKED BLOCK/RWY
ZO HIJACK HIJACK
ZP NON-ROUTINE PAX OFF-LOADING PAX/OFFLOAD
ZQ PAX OX MASKS EXTENDED OX/MASKS
ZR INFLIGHT/GROUND FIRE FIRE
ZS NARCOTICS INVOLVEMENT NARCOTICS
ZT SMOKE/FUMES IN COCKPIT/CABIN CABIN/SMOKE
ZU PUBLIC PROTECTION PUB/PROT
ZV PUBLIC COMPLAINT PUB/COMPLT
ZW UNABLE/UNSAFE TO TAXI TAXI/UNSAFE
ZX PARACHUTE INCIDENT PARACHUTE
ZY ABANDONED AIRCRAFT ABANDONED
ZZ FUEL DUMP FUEL DUMP
Z1 AUTOMOTIVE FUEL AUTO FUEL
Z2 OVER WATER/INTO WATER OVER/INTOWAT
Z3 BOMB THREAT BOMBTHREAT
Z4 DECOMPRESSION DECOMPRESS
Z5 DRUGS, TEST OR AUTOPSY DRUGS
Z6 PREEXISTING DISEASE DISEASE
Z7 BALLISTIC PARACHUTE BALLISTIC/PC
99999 INVALID OTHER FACTORS
 TABLE ID : PC DESCRIPTION : PILOT CERTIFICATION

CODE LONG DESCRIPTION SHORT DESCRIPTION

_________ ______________________________ ____________________

F1 PRIVATE PILOT FLT INSTRUCTOR PPF

F3 COMM PILOT FLIGHT INSTRUCTOR CPF
F9 A/LINE TRANSPORT PLT FLT INSTR ATF
TT PILOT NOT CERTIFICATED NON
XX STUDENT STU
00 SPECIAL PURPOSE SPC
01 PRIVATE PILOT PVT
02 RECREATIONAL PILOT REC
03 COMMERCIAL PILOT COM
09 AIRLINE TRANSPORT ATP
99 UNKNOWN/FOREIGN UNK

TABLE ID : PHS DESCRIPTION : PHASE OF FLIGHT

CODE LONG DESCRIPTION SHORT DESCRIPTION

__________ ______________________________ ____________________

AA STARTING ENGINES STATIC-STARTUP

AB IDLING ENGINES STATIC-IDLE ENG
AC ENGINE RUN-UP STATIC-RUN UP
AD IDLING ROTORS STATIC-IDLE ROTOR
BA POWER ON DESCENT (ROTORCRAFT) APPR-ROTOR RWR DSC
BB AUTOROT DESCENT (ROTORCRAFT) APPR-AUTOROT DES
BC IN TRAFFIC PATTERN-CIRCLING APPR-VFR PTRN CIRC
BD FINAL APPROACH APPR-FINAL
BE INITIAL APPROACH-IFR APPR-INITIAL
BF FINAL APPROACH-IFR APPR-FINAL
BG GO ROUND (ABORTED VFR) APPR-GO ARND VFR
BH MISSED APPROACH IFR APPR-MISSED IFR
BI FORCED LANDING APPR-FORCE LAND
CX CLIMB TO CRUISE CLIMB-TO CRUISE
DA NORMAL CRUISE CRUISE-NORMAL
DB HOLDING IFR CRUISE-HOLD IFR
DC ACROBATICS-BUZZING CRUISE-ACRO/BUZZ
DD FCD/PREC LDG FROM CRUISE CRUISE-FCD/PREC LD
DE LOW LEVEL OPERATIONS CRUISE-LO LVL OF
DF UNAUTH LOW LEVEL OPNS UNAUTH LOW LEVEL
DG PRACTICE TRAINING MANUEVERS PRACTICE MANUEVER
DH FORMATION FLYING FORMATION
EX DESCENT DESCENT
FA OPS ON GRND TO TKOF/RTRCRFT GRND ROTOR/GR-TO
FB OPS ON GRND FROM LDG/RTRCRFT GRND FRM LAND
FC AERIAL TAXI TO TKOF/RTRCRFT GRND ROTOR/AIR-TO
FD AERIAL TAXI FROM LDG/RTRCRFT GRND ROTOR/AIR-LND
FE GROUND TAXI, OTHER AIRPLANE GRND GRD TAXI
FF AERIAL TAXI, OTHER HELICOPTER GRND AER TAXI
FG OTHER GROUND OPS GRND OTHER
GX HOVERING HOVERING
HA LEVEL OFF TOUCHDOWN LAND-LVL OFF TOUCH
HB ROLL-OUT (FIXED WING) LAND-ROLL FW
HC ROLL-OUT (ROTORCRAFT) LAND-ROLL HELIO
HD PWR ON VERTICAL LDNG/RTRCRFT LAND-PWR ON VERT
HE PWR OFF VERT LAND/AUTOROTATE LAND-PWR OFF VERT
HF PRW ON RUN LANDING (ROTORCRAFT LAND-PWR ON RUN
HG PWR OFF RUN LAND (AUTOROTATION LAND-PWR OFF RUN
HH TOUCH AND GO LANDING TOUCH AND GO
HK SLOPE LANDING SLOPE
HM SETTLE WITH POWER (ROTORCRAFT) SETTLEWPWR
IA TAKEOFF GROUND ROLL TKOF-GRND ROLL
IB TO INIT CLIMB(1ST PWR REDUCT) TKOF-INIT CLIMB
IC TO VERTICAL (HELICOPTER ONLY) TKOF-VERTICAL
ID TO RUNNING(HELICOPTER/VTOL AC) TKOF-RUNNING
IE TO ABORTED (FIXED WING) TKOF-ABORTED
IF TKOF-ABORT-COPTER VERTICAL TKOF-ABORT-VERT
IG TO ABORTED (COPTER/RUN TAKOFF) TKOF-ABORT RUNNING
IH FORCED/PRECAUTIONARY LANDING TKOF-FORCE LAND
JX UNKNOWN UNKNOWN
KA SIMULATED FORCED LANDING/TKOF SFL-TKOF RUN
KB SFL TAKEOFF CLIMB SFL-TKOF CLIMB
KC SFL CRUISE SFL-CRUISE
KD SFL FINAL APPROACH SFL-FNL APP
KE SFL TRAFFIC PATTERN SFL-TFC PTRN
KF SFL GO AROUND SFL-GO-ARND
KG SFL AUTOROTATION SFL-AUTO ROT
PJ PARACHUTE JUMPING PARA JUMP
PL PINNACLE LANDING PINNACLE
SR SCUD RUNNING SCUD
99999 PHASE OF FLIGHT INVALID ERROR MESSAGE

TABLE ID : PIN DESCRIPTION : PERSONS INVOLVED

CODE LONG DESCRIPTION SHORT DESCRIPTION
__________ ______________________________ ____________________

A PILOT-IN-COMMAND PIC
B CO-PILOT 1CP
C TRAINEE TRAINEE
D FLIGHT NAVIGATOR FLN
E FLIGHT ENGINEER FLE
F RADIO OPERATOR RAD
G CHECK PILOT CKP
H MAINT SUPERVISORY PERSONNEL MTS
I AIRPORT SUPERVISORY PERSONNEL APT
J OPER SUPERVISORY PERSONNEL OPS
K WEATHER PERSONNEL WX
L CONTROLLER/ATC ATC
M MAINTENANCE AND/OR GRND CREW MTC
N NON-CERTIFICATED PILOT NCP
O AIRWAYS FACILITIES PERSONNEL AWF
P OTHER/PASS/CABIN CREW OTH
Q UNKNOWN UNK
R GROUND CREW GRD
99999 PERSONS INVOLVED INVALID ERROR MESSAGE

TABLE ID : PLN DESCRIPTION : FLIGHT PLAN

CODE LONG DESCRIPTION SHORT DESCRIPTION

_________ ______________________________ ____________________

0 UNKNOWN UNK
1 VISUAL FLIGHT RULES VFR
2 VISUAL-FLIGHT FOLLOWING VFF
3 INSTRUMENT FLIGHT RULES IFR
4 DEFENSE VISUAL FLIGHT RULES DFR
5 MILITARY CONTROL GCI
6 VFR ON TOP VTP
7 SPECIAL VFR CVF
8 NONE NON
9 AIR TAXI FLIGHT FOLLOWING CFP
99999 FLIGHT PLAN INVALID ERROR MESSAGE
 TABLE ID : PLTPR DESCRIPTION : PILOT PROFESSION

CODE LONG DESCRIPTION SHORT DESCRIPTION

__________ ______________________________ ____________________

A ACCOUNTANT ACCT
B STUDENT STUD
C SALESMAN SALE
D PHYSICIAN DCTR
E COMPANY EXECUTIVE EXEC
F FARMER, RANCHER, CATTLEMAN FARM
G GOVERNMENT EMPLOYEE GOVT
H HOUSEWIFE WIFE
J TEACHER TEAC
K PROFESSIONAL PILOT PILT
L LAWYER LAWR
M MINISTER MNST
N OTHER OTHR
O UNKNOWN UNKN
P ENGINEER ENGR
Q CONTRACTOR CONT
99999 PILOT PROFESSION INVALID ERROR MESSAGE

TABLE ID : PQ DESCRIPTION : PILOT QUALIFICATIONS

CODE LONG DESCRIPTION SHORT DESCRIPTION
__________ ______________________________ ____________________

E FLT INST QUALIFIED IN OPER FIQ

F FLT INST NOT QUALIFIED IN OPER FINQ
G QUAL IN OPER NOT FLIGHT INST QUIO
H NQAL IN OPER-NOT A FLIGHT INST NQAL
M UNKNOWN, FOREIGN PILOT UNFR
N NO MEDICAL CERTIFICATE/EXPIRED NMED
P NO BIENNIAL FLIGHT REVIEW NBIF
R NOT PROPERLY RATED NRAT
S QUALIFIED QUAL
T NOT QUALIFIED NTQL
U NO MEDICAL OR BIENNIAL NMNB
V NO MEDICAL/NOT RATED NMNR
W NO BIENNIAL NOT RATED NBNR
X CERT SUSPENDED/REVOKED SUSP
99999 PILOT QUAL INVALID ERROR MESSAGE

TABLE ID : PR DESCRIPTION : PILOT RATINGS AIRPLANE

CODE LONG DESCRIPTION SHORT DESCRIPTION

__________ ______________________________ ____________________

00 NO RATING (OR STUDENT ONLY) NO RATING

01 ASEL ASEL
02 AMEL AMEL
03 ASES ASES
04 AMES AMES
05 ASMEL ASMEL
06 ASEL ASES ASEL ASES
07 ASEL AMES ASEL AMES
08 ASEL ASMES ASEL ASMES
09 ASMEL ASMES ASMEL ASMES
10 ASMEL ASES ASMEL ASES
11 ASMEL AMES ASMEL AMES
12 AMEL ASES AMEL ASES
13 AMEL AMES AMEL AMES
14 AMEL ASMES AMEL ASMES
20 RH RH
21 RH ASEL RH ASEL
22 RH AMEL RH AMEL
23 RH ASES RH ASES
24 RH AMES RH AMES
25 RH ASMEL RH ASMEL
26 RH ASEL ASES RH ASEL ASES
27 RH ASEL AMES RH ASEL AMES
28 RH ASEL ASMES RH ASEL ASMES
29 RH ASMEL ASMES RH ASMEL ASMES
30 RH ASMEL ASES RH ASMEL ASES
31 RH ASMEL AMES RH ASMEL AMES
32 RH AMEL ASES RH AMEL ASES
33 RH AMEL AMES RH AMEL AMES
34 RH AMEL ASMES RH AMEL ASMES
40 GLIDER GLIDER
41 G ASEL G ASEL
42 G AMEL G AMEL
43 G ASES G ASES
44 G AMES G AMES
45 G ASMEL G ASMEL
46 G ASEL ASES G ASEL ASES
47 G ASEL AMES G ASEL AMES
48 G ASEL ASMES G ASEL ASMES
49 G ASMEL ASMES G ASMEL ASMES
50 G ASMEL ASES G ASMEL ASES
51 G ASMEL AMES G ASMEL AMES
52 G AMEL ASES G AMEL ASES
53 G AMEL AMES G AMEL AMES
54 G AMEL ASMES G AMEL ASMES
60 GLIDER RH GLIDER RH
61 G RH ASEL G RH ASEL
62 G RH AMEL G RH AMEL
63 G RH ASES G RH ASES
64 G RH AMES G RH AMES
65 G RH ASMEL G RH ASMEL
66 G RH ASEL ASES G RH ASEL ASES
67 G RH ASEL AMES G RH ASEL AMES
68 G RH ASEL ASMES G RH ASEL ASMES
69 G RH ASMEL ASMES G RH ASMEL ASMES
70 G RH ASMEL ASES G RH ASMEL ASES
71 G RH ASMEL AMES G RH ASMEL AMES
72 G RH AMEL ASES G RH AMEL ASES
73 G RH AMEL AMES G RH AMEL AMES
74 G RH AMEL ASMES G RH AMEL ASMES
99999 AIRPLANE RATE INVALID ERROR MESSAGE

TABLE ID : PWRCL DESCRIPTION : AIRCRAFT POWER CLASS

CODE LONG DESCRIPTION SHORT DESCRIPTION

__________ ______________________________ ____________________

0 NONPOWERED NONPOWERED
7 POWERED POWERED
8 OPTIONAL OPTIONAL
99999 INVALID POWER CLASS

TABLE ID : RAT DESCRIPTION : REMEDIAL ACTION TAKEN

CODE LONG DESCRIPTION SHORT DESCRIPTION

__________ ______________________________ ____________________
A DISCUSSION DIS
B LETTER LTR
C ADDITIONAL TRAINING TRN
D RE-EXAMINATION/RE-INSPECTION REX
E VIOLATION VIO
F EMERGENCY SUSPENSION SUS
G VOL SURRENDER OF CERTIFICATE SUR
H RECOMMEND GEN CHANGE IN PROC PRO
I RECOMMEND GEN CHANGE STAND/POL STP
J OTHER OTH
K NON-COMP AIRWORTHINESS DIRECT ADC
R A/DATA CODED FROM NTSA/6120.19 NTS
X NONE NON
Y NOT REPORTED NRP
99999 REMED ACT TAKEN INVALID ERROR MESSAGE

TABLE ID : REG DESCRIPTION : REGION TABLE

CODE LONG DESCRIPTION SHORT DESCRIPTION

__________ ______________________________ ____________________

AC AERONAUTICAL CENTER AC
AG OFFICE OF THE CHIEF COUNSEL AG
AL ALASKAN AL
CE CENTRAL CE
EA EASTERN EA
EU EUROPEAN EU
FS GENERIC>AFS-643 RESPONSIBLE AFS-643
GL GREAT LAKES GL
NE NEW ENGLAND NE
NM NORTHWEST MOUNTAIN NM
SD SELF DISCLOSURE SD
SO SOUTHERN SO
SW SOUTHWEST SW
WA WASHINGTON HEADQUARTERS OFC WA
WP WESTERN PACIFIC WP
99999 REGION INVALID ERROR MESSAGE

TABLE ID : RMA DESCRIPTION : REMEDIAL ACTION AREA

CODE LONG DESCRIPTION SHORT DESCRIPTION

__________ ______________________________ ____________________

A NONE NONE
B FLIGHT PERSONNEL FLTP
C FLIGHT & MAINTENANCE PERSONNEL FLMT
D FLT MAINT FAA ST POLICIES/PROC FMST
E FLIGHT INSTRUCTOR FLTI
F FLT OPER FAA STANDARDS POL/PRO FOSS
G FLIGHT, MAINTENANCE & OPERATOR FLMO
H FLT, FAA STANDARDS POL/ PROCS FLPP
I MAINTENANCE PERSONNEL MAIN
J MAINTENANCE AND OPERATOR MTOP
K MT FAA ST POLICIES/PROCEDURES MTST
L MAINT, OPER FAA ST POL OR PROC MOST
M MANUFACTURER MANU
N MANUFACTURER AND OPERATOR MAOP
O MA & FAA ST POLICIES, OR PROCS MAST
P OPER FLT SCH, A/TAXI, AGR/ETC. OPER
Q OP & FAA ST POLICIES, OR PROCS OPST
R FAA PERSONNEL FAAP
S FAA PERSONNEL & FACILITIES FAPF
T FAA PERS & FAA ST POL/PROCS FPST
U FAA FACILITIES FAAF
V FAA FAC/ST POLICIES/PROCEDURES FFST
W REPAIR STATION RPST
X R S & FAA ST, POLICIES OR PROC RSST
Y FAA STS, POLICIES OR PROCEDURE FAST
Z OTHER OTHR
99999 REMED ACT AREA INVALID ERROR

TABLE ID : RPT DESCRIPTION : RELATED REPORTS

CODE LONG DESCRIPTION SHORT DESCRIPTION

__________ ______________________________ ____________________

E ENFORCEMENT/INVESTIGATIVE REPT E
S SERVICE DIFFICULTY REPORT S
W WARNING LETTER W
99999 RELATED REPORT INVALID ERROR MESSAGE
 TABLE ID : RWY DESCRIPTION : RUNWAY CONDITION

CODE LONG DESCRIPTION SHORT DESCRIPTION

__________ ______________________________ ____________________

DRY DRY DRY

ICE ICE ICE
ICP ICE PATCH ICP
SNP SNOW-PLOWED SNP
SNU SNOW - UNPLOWED SNU
WET WET WET
WTR STANDING WATER WTR
99999 RUNWAY COND INVALID ERROR MESSAGE

TABLE ID : SKY DESCRIPTION : SKY CONDITION

CODE LONG DESCRIPTION SHORT DESCRIPTION

__________ ______________________________ ____________________

BRKN BROKEN CLOUDS BRKN

CLER CLEAR CLER
OBSC SKY OBSCURED OBSC
OCST OVERCAST OCST
SCAT SCATTERED CLOUDS SCAT
99999 SKY COND INVALID ERROR MESSAGE

TABLE ID : ST DESCRIPTION : STATE TABLE

CODE LONG DESCRIPTION SHORT DESCRIPTION

AA ARUBA ARUBA
AB ALBANIA AB
AC ANTIGUA AND BARBUDA AC
AF AFGANISTAN AF
AG ARGENTINA AG
AI ALGERIA AI
AJ AZERBAIJAN AJ
AK ALASKA AK
AL ALABAMA AL
AM ARMENIA AM
AN ANDORRA AN
AO ANGOLA AO
AQ AMERICAN SAMOA AQ
AR ARKANSAS AR
AS AUSTRALIA AS
AT ASHMORE & CARTIER ISL AT AT
AU AUSTRIA AU
AV ANGUILLA AV
AY ANTARCTICA AY
AZ ARIZONA AZ
BA BAHRAIN BA
BB BARBADOS BB
BC BOTSWANA BC
BD BERMUDA BD
BE BELGIUM BE
BF THE BAHAMAS BF
BG BANGLADESH BG
BH BELIZE BH
BK BOSNIA AND HERZEGOVINA BK
BL BOLIVIA BL
BM BURMA BM
BN BENIN BN
BO BYELARUS BO
BP SOLOMON ISLANDS BP
BQ NAVASSA ISLAND BQ
BR BRAZIL BR
BS BASSAS DA INDIA BS
BT BHUTAN BT
BU BULGARIA BU
BV BOUVET ISLAND BV
BX BRUNEI BX
BY BURUNDI BY
CA CALIFORNIA CA
CB CAMBODIA CB
CC COMORO ISLANDS CC
CD CHAD CD
CE SRI LANKA CE
CF CONGO CF
CG ZAIRE CG
CH "CHINA, PEOPLES REPUBLIC OF" CH
CI CHILE CI
CJ CAYMAN ISLANDS CJ
CK COCDS KEELING ISLANDS CK
CL CENTRAL AFRICAN REP CL
CM CAMEROON CM
CN CANADA CN
CO COLORADO CO
CP COLOMBIA CP
CQ NORTHERN MARIANA ISLANDS CQ
CR CORAL SEA ISLANDS TERR CR
CS COSTA RICA CS
CT CONNECTICUT CT
CU CUBA CU
CV CAPE VERDE CV
CW COOK ISLANDS CW
CY CYPRUS CY
CZ CODE NOT VALID USE EZ OR LO CZ
DA DENMARK DA
DC DISTRICT OF COLUMBIA DC
DE DELAWARE DE
DJ DJIBOUTI DJ
DM DAHOMEY DM
DO DOMINICA DO
DQ JARVIS ISLAND DQ
DR DOMINICAN REPUBLIC DR
EC ECUADOR EC
EG EGYPT EG
EI IRELAND EI
EK EQUATORIAL GUINEA EK
EN ESTONIA EN
EQ CODE NO LONGER VALID USE KR EQ
ER ERITREA ER
ES EL SALVADOR ES
ET ETHIOPIA ET
EU EUROPA ISLAND EU
EZ CZECH REPUBLIC EZ
FA SOUTH GEORGIA & S SANDWICH ISS FA
FG FRENCH GUIANA FG
FI FINLAND FI
FJ FIJI FJ
FK FALKLAND ISS (ISLAS MALVINAS) FK
FL FLORIDA FL
FM MICRONESIA FM
FO FAROE ISLANDS FO
FP FRENCH POLYNESIA FP
FQ BAKER ISLAND FQ
FR FRANCE FR
FS FR SOUTHERN & ANTARTIC FS
FT FR TERR OF AFARS ISSAS FT
GA GEORGIA GA
GB GABON GB
GC CODE NO LONGER VALID (NOW GE) GC
GE GERMANY GE
GG GEORGIA GG
GH GHANA GH
GI GIBRALTAR GI
GJ GRENADA GJ
GK GUERNSEY GK
GL GREENLAND GL
GM GAMBIA GM
GN CODE NO LONGER VALID USE KR GN
GO GLORIOSO ISLANDS GO
GP GUADELOUPE GP
GQ GUAM GQ
GR GREECE GR
GT GUATEMALA GT
GV GUINEA GV
GY GUYANA GY
GZ GAZA STRIP GZ
HA HAITI HA
HI HAWAII HI
HK HONG KONG HK
HM HEARD IS & MCDONALD ISLS HM
HO HONDURAS HO
HQ HOWLAND ISLAND HQ
HR CROATIA HR
HU HUNGARY HU
IA IOWA IA
IC ICELAND IC
ID IDAHO ID
IE INDONESIA IE
II INDIA II
IL ILLINOIS IL
IM MAN ISLE OF IM
IN INDIANA IN
IO BR INDIAN OCEAN TERR IO
IP CLIPPERTON ISLAND IP
IR IRAN IR
IS ISRAEL IS
IT ITALY IT
IV COTE D'IVOIRE IV
IZ IRAQ IZ
JA JAPAN JA
JE JERSEY JE
JM JAMAICA JM
JN JAN MAYEN JN
JO JORDAN JO
JQ JOHNSTON ATOLL JQ
JU JUAN DE NOVA ISLAND JU
KE KENYA KE
KG KYRGYZSTAN KG
KN "KOREA, NORTH" KN
KO "KOREA, REPUBIC OF" KO
KQ KINGMAN REEF KQ
KR KIRIBATI KR
KS KANSAS KS
KT CHRISTMAS ISLAND KT
KU KUWAIT KU
KY KENTUCKY KY
KZ KAZAKHSTAN KZ
LA LOUISIANA LA
LE LEBANON LE
LG LATVIA LG
LH LITHUANIA LH
LI LIBERIA LI
LO LAOS LO
LQ PALMYRA ATOLL LQ
LS LIECHTENSTEIN LS
LT LESOTHO LT
LU LUXEMBOURG LU
LY LIBYA LY
L0 SLOVAKIA LO
MA MASSACHUSETTS MA
MB MARTINIQUE MB
MC MACAU MC
MD MARYLAND MD
ME MAINE ME
MF MALTA MF
MG MONGOLIA MG
MH MONTSERRAT MH
MI MICHIGAN MI
MJ MADAGASCAR MJ
MK MAURITANIA MK
ML MALI ML
MM MONACO MM
MN MINNESOTA MN
MO MISSOURI MO
MP MAURITIUS MP
MQ MIDWAY ISLANDS MQ
MR MOROCCO MR
MS MISSISSIPPI MS
MT MONTANA MT
MU OMAN MU
MV MALDIVES MV
MW MALAWI MW
MX MEXICO MX
MY MALAYSIA MY
MZ MOZAMBIQUE MZ
M1 MOLDOVA M1
M2 MAYOTTE MAYOTTE
M3 MACEDONIA M3
M4 MONTENEGRO M4
NA CODE NO LONGER VALID (NOW NT) NA
NB VANUATU NB
NC NORTH CAROLINA NC
ND NORTH DAKOTA ND
NE NEBRASKA NE
NF NORFOLK ISLAND NF
NG NIGER NG
NH NEW HAMPSHIRE NH
NI NIGERIA NI
NJ NEW JERSEY NJ
NL NETHERLANDS NL
NM NEW MEXICO NM
NO NORWAY NO
NP NIUE NP
NR NAURU NR
NS SURINAM NS
NT NETHERLANDS ANTILLES NT
NU NICARAGUA NU
NV NEVADA NV
NW NEW CALEDONIA NW
NX NEPAL NEPAL
NY NEW YORK NY
NZ NEW ZEALAND NZ
OH OHIO OH
OK OKLAHOMA OK
OR OREGON OR
PA PENNSYLVANIA PA
PC PITCAIRN ISLAND PC
PE PERU PE
PF PARACEL ISLANDS PF
PG SPRATLY ISLANDS PG
PK PAKISTAN PK
PL POLAND PL
PN PANAMA PN
PO PORTUGAL PO
PP PAPUA NEW GUINEA PP
PQ CODE NO LONGER VALID USE PN PQ
PR PARAGUAY PR
PS TRUST TERR OF PACIFIC ISLANDS PS
PT CODE NO LONGER VALID USE IE PT
PU GUINEA-BISSAU PU
QA QATAR QA
RE REUNION RE
RH SOUTHERN RHODESIA RH
RI RHODE ISLAND RI
RM MARSHALL ISLANDS RM
RO ROMANIA RO
RP PHILIPINES RP
RQ PUERTO RICO RQ
RS RUSSIA RS
RW RWANDA RW
SA SAUDI ARABIA SA
SB ST PIERRE & MIQUELON SB
SC SOUTH CAROLINA SC
SD SOUTH DAKOTA SD
SE SEYCHELLES SE
SF SOUTH AFRICA SF
SG SENEGAL SG
SH ST HELENA SH
SI SPANISH NORTH AFRICA SI
SK CODE NO LONGER VALID USE UK SK
SL SIERRA LEONE SL
SM SAN MARINO SM
SN SINGAPORE SN
SO SOMALIA SO
SP SPAIN SP
SR SOUTH-WEST AFRICA SR
SS WESTERN SAHARA SS
ST ST LUCIA ST
SU SUDAN SU
SV SVALBARD SV
SW SWEDEN SW
SX ST KITTS AND NEVIS SX
SY SYRIA SY
SZ SWITZERLAND SZ
S1 SERBIA S1
S2 SLOVENIA S2
TC UNITED ARAB EMIRATES TC
TD TRINIDAD AND TOBAGO TD
TE TROMELIN ISLAND TE
TG TOGO TG
TH THAILAND TH
TI TAJIKISTAN TI
TK TURKS AND CAICOS ISL TK
TL TOKELAU ISLANDS TL
TM TURKMENISTAN TM
TN TENNESSEE TN
TO TONGA TO
TP SAO TOME AND PRINCIPE TP
TS TUNISIA TS
TU TURKEY TU
TV TUVALU TV
TW TAIWAN TW
TX TEXAS TX
TZ TANZANIA TZ
UG UGANDA UG
UK UNITED KINGDOM UK
UP UKRAINE UP
UR CODE NO LONGER VAID UR
US UNITED STATES OF AMERICA
UT UTAH UT
UV BURKINA UV
UY URUGUAY UY
UZ UZBEKISTAN UZ
VA VIRGINIA VA
VC ST VINCENT VC
VE VENEZUELA VE
VI BRITISH VIRGIN IS VI
VM "VIETNAM, REPUBLIC OF" VM
VQ VIRGIN ISLANDS VQ
VT VERMONT VT
WA WASHINGTON WA
WF WALLIS AND FUTUNA WF
WI WISCONSIN WI
WN WEST INDIES WN
WQ WAKE ISLAND WQ
WS WESTERN SAMOA WS
WV WEST VIRGINIA WV
WY WYOMING WY
WZ SWAZILAND WZ
XX U.S. PILOT LIVING FOREIGN CTRY XX
YE CODE NO LONGER VALID (NOW YM) YE
YM YEMEN YM
YO CODE NO LONGER VALID YO
YS CODE NO LONGER VALID (NOW YM) YS
ZA ZAMBIA ZA
ZI ZIMBABWE ZI
0 FOREIGN PILOT LIVING FOREIGN 0
99999 STATE ABBREV INVALID ERROR MESSAGE
 TABLE ID : STD DESCRIPTION : STUDENT INDICATOR

CODE LONG DESCRIPTION SHORT DESCRIPTION

__________ ______________________________ ____________________

N NO NO
Y YES YES
99999 ENTER Y OR N ONLY ERROR MESSAGE

TABLE ID : SUP DESCRIPTION : SUPPORTING FACTORS

CODE LONG DESCRIPTION SHORT DESCRIPTION

__________ ______________________________ ____________________

A CORROSION CORSN
B METAL FATIGUE FATGE
C SURFACE STRESS (RUNWAY) STRES
D OVERSTRESSED OVSTR
E RUPTURED OR BURST BURST
F CRACKED, SPLIT, OR BROKEN CRACK
G FAULTY DESIGN DESGN
H FAULTY PART (MANUFACTURE) MANUF
I IMPROPER INSTAL - NON STD PART INSTL
J IMPROPERLY SECURED SECUR
K JAMMED OR MALFUNCTION JAMML
L BOGUS BOGUS
M FUEL CONTAMINATION FUELC
N OIL CONTAMINATION OILCN
O LACK OF LUBRICATION LUBRI
P FOREIGN OBJECT DAMAGE FOROB
Q ACCUMULATED MOSITURE/ICE MOICE
R CARBURETOR ICING CRICE
S PLT INDUCED FAILURE/DEFIC FLT PILOT
T OTHER OTHER
U UNDETERMINED UNDET
V SUPPLEMENTAL RPT FORTHCOMMING SUPPL
W FOULED FOULD
X WORN OUT-EXCEEDED TIME LIMITS TIRED
Y IMPROPER GRADE OF FUEL IGRFU
Z LEAKING LEAKS
99999 SUPPORT FACTOR INVALID ERROR MESSAGE

TABLE ID : TAP DESCRIPTION : TYPE APPROACH

CODE LONG DESCRIPTION SHORT DESCRIPTION

_________ ______________________________ ____________________

ADF ADF ADF

ASR ASR ASR
IBK ILS BACK IBK
IFT ILS FRONT IFT
LOC LOC LOC
LOR LORAN LOR
MLS MICROWAVE LANDING SYSTEM MLS
OTH OTHER OTH
PAR PAR PAR
RVN AREA NAVIGATION APPROACH RVN
SDF SIMPLIFIED DIRECTIONAL FAC SDF
VIS VISUAL VIS
VOD VOR/DME VOD
VOR VOR VOR
99999 TYPE APPROACH INVALID ERROR MESSAGE

TABLE ID : TES DESCRIPTION : TYPE ENGINE SUFFIX

CODE LONG DESCRIPTION SHORT DESCRIPTION

__________ ______________________________ ____________________

I PISTON - IN LINE I
J TURBOJET J
O PISTON - HORIZONTAL/OPPOSED O
R PISTON - RADIAL R
T TURBOPROP T
U TURBOSHAFT U
V PISTON -V ENGINE V
W ROTARY W
X OTHER X
Y ROCKET Y
Z JET Z
99999 TYPE ENGINE SFX INVALID ERROR MESSAGE

TABLE ID : TFP DESCRIPTION : TYPE FLYING - PRIMARY

CODE LONG DESCRIPTION SHORT DESCRIPTION

__________ ______________________________ ____________________

A AIR TAXI (SCHED-NOT COMMUTER) OTCO

B A/T COM (SCHED 5/MORE TPS/WEEK ACOM
C SCHEDULED AIR CARRIER SCAC
D SUPPLEMENTAL OR COMMERCIAL OPR SUPP
E TRAVEL CLUBS TRVL
F AIR TAXI OPER-LARGE AIRCRAFT 1352
G SCHEDULED AIR CARRIER HELICOPT SCRH
H ALL CARGO CARRIERS CRGO
J ILLEGAL DRUG,STOLEN ACFT,ETC ILGL
1 PERSONAL PERS
2 BUSINESS BSNS
3 EXECUTIVE EXEC
4 INSTRUCTION INST
5 AIR TAXI (NON-SCHEDULED) ATCO
6 AERIAL APPLICATOR AGRI
7 INDUSTRIAL/SPECIAL INDU
8 OTHER OTHR
9 FOR HIRE HIRE
99999 TYPE FLY-PRI INVALID ERROR MESSAGE

TABLE ID : TFS DESCRIPTION : TYPE FLYING - SECONDARY

CODE LONG DESCRIPTION SHORT DESCRIPTION

__________ ______________________________ ____________________

A AGRICULTURE AGRI
B PLEASURE PLEA
C CIVIL CLUB CCLB
D FAA OPERATIONS FAA
E EXPERIMENTAL TEST FLIGHT EXPR
F FERRY FERY
G TEST FLIGHT TEST
H HELICOPTER EXTERNAL LOAD HELI
I INDUSTRIAL INDU
J FOREST FIRE FIRE
K SKY DIVING FREE FALL SKYD
L PARACHUTE STATIC PARA
M MILITARY CLUB MCLB
N NONE OR OTHER OTHR
O EMERGENCY PARACHUTE EPAR
P AIR SHOW SHOW
Q FAA FLIGHT CHECK CHCK
R AIR MAIL MAIL
S PASSENGERS APAX
T CARGO ACAR
U PASSENGERS AND CARGO PXCG
V GLIDER GLID
W UNKNOWN UNKN
X TRAINING TRNG
Y AIR AMBULANCE AMBL
1 BALLISTIC PARACHUTE BPAR
2 BANNER TOW BTOW
3 HOT AIR BALLOON BALN
99999 TYPE FLY-SEC INVALID ERROR MESSAGE

TABLE ID : TYP DESCRIPTION : TYPE OF ACCIDENT/INCIDENT

CODE LONG DESCRIPTION SHORT DESCRIPTION

__________ ______________________________ ____________________

AA LOSS OF DIR CTL-GRND LOOP DIR CNTL LOOP

AB LOSS OF DIR CTL-DRAG WINGTIP DIR CNTL DRAG
AC LOSS OF DIRECTIONAL CONTROL DIR CNTL
BX HARD LANDING HARD LAND
CA WHEELS-UP LANDING WHEELS UP
CB WHEELS-DOWN LANDING IN WATER WHLS DWN WTR
CC GEAR COLLAPSE GEAR COLL
CD GEAR RETR DURING GRD OPERATION GEAR RETR GRD
DC DECOMPRESSION DECOMP
DR DYNAMIC ROLLOVER DYN ROLL OVR
DX UNDERSHOOT LANDING UNDERSHOOT
EX OVERSHOOT LANDING OVERSHOOT
FX NOSE UP OR OVER NOSE-UP-OVR
GR HELICOPTER-GRND RESONANCE HEL-GRND-RESNCE
GX MIDAIR COLLISIONS BOTH IN FLT MIDAIR
HA A/C COLLISIONS-ONE AIRBORNE COLL-ONE UP
HB A/C COLLISIONS-ON GROUND GRND AC COLL
IA CONTROL COLL WITH GROUND CNTLD COLL GRD
IB UNCONTROLL COLL WITH GROUND UNCNTLD COLL GRD
IC CONTROL COLL WITH WATER CNTLD COLL WA
ID UNCONTROL COLL WITH WATER UNCNTLD COLL WA
JA COLLISION WITH WIRES-POLES COLL-WIRES POLES
JB COLLISION WITH TREES COLL-TREES
JC COLLISION WITH RESIDENCES COLL-RESID
JD COLLISION WITH OTHER BUILDINGS COLL-BLDGS
JE COLLISION WITH FENCES, & POSTS COLL-FENCE
JF COLL WITH ELECTRONIC TOWERS COLL-TOWER
JG COLL WITH RWY/APP LIGHTS COLL-RWY/APP LTS
JH COLL WITH AIRPORT HAZARD COLL-APT HAZ
JI COLLISION WITH BIRDS COLL-BIRDS
JJ COLLISION WITH OTHER COLL-OTHER
JK COLLISION WITH ANIMAL COLL-ANML
KX STALL STALL
LX SPIN SPIN
MA FIRE OR EXPLOSION-IN FLIGHT FIRE/EXP-IN FLT
MB FIRE OR EXPLOSION-ON GROUND FIRE/EXP-ON GRD
NA AIRFRAME FAILURE-IN FLIGHT AIRFRAME-IN FLT
NB AIRFRAME FAILURE-ON GROUND AIRFRAME-ON GRD
OA ENGINE TEAR AWAY ENGINE TEAR AWY
OB ENGINE MALFUNCTION ENGINE MALF
OC FORCED LANDING FORCED LANDING
PA PROPELLER BLADE PROP BLADE
PB HELICOPTER BLADE HELIO BLADE
PC JET BLADE JET BLADE
PD JET ROTOR BLADE JET ROTOR BLADE
PE PROP BLAST PROP BLAST
PF JET BLAST JET BLAST
PG ROTOR BLAST ROTOR BLAST
PH WAKE TURB-VORTEX WAKE TURB
PM PROP MALFUNCTION OR FAILURE PROP MALF/FAIL
QA PROP/ROTOR ACCIDENT TO PERSON PROP/RTR-PERS
QB JET INTAKE/EXH ACC TO PERSONS JET IN/EX-PERS
RA TURBULENCE IN FLIGHT PERS INJ TURB-PERS INJURY
RB TURB IN FLT. ACFT DAMAGE TURB A/C STRUCTURE
RC TURB IN FLT. ACFT & PERSON TURB STRUCTURE/PERS
RD HAIL DAMAGE TO AIRCRAFT HAIL DMG
RE LIGHTNING STRIKE LIGHTNING
RF BLOWN OVER (WIND ONLY) BLOWN OVER
SA EVASIVE MANEUVER PERS INJURY EVASIVE-PERS INJURY
SB EVASIVE MANEUVER STRUCTURE DMG EVASIVE-STRUCTURE
SC EVASIVE MANEUVER STRUC & PERS EVASIVE-PER/STR
SD MISSING AIRCRAFT MISSING A/C
SE OTHER-MISCELLANEOUS OTHER
SF UNDETERMINED UNDETERMINED
SY SYSTEM MALFUNCTION OR FAILURE SYSTEM MALF/FAIL
TS TAIL STRIKE TAIL STRIKE
YY EMERGENCY PARACHUTE EMER CHUTE
99999 TYPE A/I INVALID ERROR MESSAGE

TABLE ID : VIS DESCRIPTION : VISIBILITY

CODE LONG DESCRIPTION SHORT DESCRIPTION
__________ ______________________________ ____________________
G10 GREATER THAN 10 MILES 10+
LS1 LESS THAN 1 MILE LS1
1 1 MILE 1
10 10 MILES 10
2 2 MILES 2
3 3 MILES 3
4 4 MILES 4
5 5 MILES 5
6 6 MILES 6
7 7 MILES 7
8 8 MILES 8
9 9 MILES 9
99999 VISIBILITY CODE INVALID ERRROR MESSAGE

TABLE ID : VRS DESCRIPTION : VISIBILITY RESTRICTIONS

CODE LONG DESCRIPTION SHORT DESCRIPTION

__________ ______________________________ ____________________

BLS BLOWING SNOW BLS

DRZ DRIZZLE DRZ
DST DUST DST
FOG FOG FOG
HAZ HAZE/SMOKE HAZ
RAI RAIN RAI
SMK SMOKE SMK
SNO SNOW SNO
99999 VISIBILITY REST INVALID ERROR MESSAGE
 TABLE ID : WGT DESCRIPTION : AIRCRAFT WEIGHT CLASS

CODE LONG DESCRIPTION SHORT DESCRIPTION

__________ ______________________________ ____________________

1 UNDER 12501 LBS UNDER 12501 LBS

2 OVER 12500 LBS OVER 12500 LBS
99999 INVALID WEIGHT CLASS

TABLE ID : WING DESCRIPTION : AIRCRAFT WING CODE

CODE LONG DESCRIPTION SHORT DESCRIPTION

__________ ______________________________ ____________________

B LIGHTER THAN AIR LIGHTER THAN AIR

D DELTA WING/SWING WING DELTA/SWING WING
G ROTARY WING ROTARY WING
H MONPLANE-HIGH/PARASOL WING MONPLANE-HIGH/PARASO
K KITE/SAILWING KITE/SAILWING
L MONPLANE-LOW WING MONPLANE-LOW WING
M MONPLANE-MID WING MONPLANE-MID WING
Q MULTI WING ULTI WING
S STOL/VTOL/TILT/WING STOL/VTOL/TILT/WING
99999 INVALID WING CODE