RECORD LAYOUT AND CODESHEET SERVICE DIFFICULTY REPORTING SYSTEM fieldname FAA columnname columntype length description --------- -------------- ---------- ------ ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- CTRLNUM c5 Char 13 A unique number assigned to each malfunction or defect report or service difficulty report. Number consists of ctrldate and seqnum; date and sequence number. CTRLDATE c10 VarChar 8 Date the report was received by the FAA. SEQNUM c12 Char 5 Unique sequential number assigned on CTRLDATE. CONTREG c14 Char 4 Region Code: 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 YR c15 Char 4 Year MO c16 Char 2 Month DAY c17 Char 2 Day OCNUM c18 Char 13 Operator Control Number SEGMCD c20 Char 1 Segment Code. This is a classification code designed to group ATA systems/components by the highest level of manufacture or certification. TABLE ID : SEG DESCRIPTION : SEGMENT TABLE CODE LONG DESCRIPTION SHORT DESCRIPTION 1 AIRFRAME AIRFRAME 2 ENGINE ENGINE 3 PROPELLER PROPELLER 4 COMPONENT COMPONENT 99999 INVALID SEGMENT CODE OCCRDT c25 VarChar 8 Date of occurrence SDRTYPE c35 Char 1 A = Air Carrier G = General Aviation ATASYS c40 Char 4 Air Transport Association (ATA) code. Designed to classify components in accordance with their utilization (system) on the aircraft. PARTNUM c90 Char 16 Manufacture's part number. Is not to contain special characters or embedded blanks; can contain a period. Total blank field is acceptable. Manufacture's number assigned to the part. PARTNAME c100 Char 16 Descriptive name assigned to the part. Aircraft manufacturer's name. CMPTMKE c110 Char 12 Component manufacturer's name abbreviated to characters. CMPTMDL c120 Char 12 Model assigned by the component manufacture. AMKE c130 Char 6 Aircraft manufacture's name abbreviated to six positions. Assigned from the SDR master reference tables. AGRP c140 Char 6 Assigned from the SDR Master Reference Tables. Locally (FAA) assigned code designed to retain the initial model classification without regard to modification designation. AMDL c150 Char 12 Aircraft manufacturer's model number. This field must be the SDR Master Reference Tables or be all blank. Model number assigned by the aircraft. ASEQ c152 Char 7 Aircraft make and model sequence number AREG c160 Char 4 Two digit alpha code responsible for type certificate or aircraft. 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 EMK c170 Char 6 Assigned from the SDR Master Reference Tables. Engine Manufacturer's name abbreviated to six positions. EGRP c180 Char 6 Assigned from the SDR Master Reference Tables. Locally (FAA) assigned code designed to retain the initial model classification without regard to modification designation. EMDL c190 Char 12 SDR Master Reference TAbles assigned by engine manufacturer. In the SDR Master File, the field is maintained in model breakdown format. EMDLSEQ c192 Char 5 Engine make and model sequence number. Code list missing. Assume engine model sequence. EREG c200 Char 4 FAA region responsible for type certificate of engine. 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 PMKE c210 Char 6 Assigned from SDR Master Reference Tables. Propeller manufacture's name abbreviated to six positions. PGRP c220 Char 6 Assigned from SDR Master Reference Tables. Locally (FAA) assigned code designed to retain the initial model classification without regard to modification designation. PMDL c230 Char 12 Propeller manufacturer's model number. The field must match the SDR Master Reference Tables or be all blank. PREG c240 Char 4 FAA region responsible for type certificate of propeller 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 PARTLOC c250 Char 16 Reflects the locatin on the aircraft of the defective or malfunctioned part. Contains any combination ALPHA/NUMERIC data. PARTCOND c260 Char 16 Text reflecting the condition on the aircraft of the failed part. Will always contain data in the five high-order positions. SUBCD c270 Char 1 Submitter code: TABLE ID : SUB DESCRIPTION : SUBMITTER CODE LONG DESCRIPTION SHORT DESCRIPTION A CARRIER CARRIER B REP STA REP STA C OPER OPER D MECH MECH E AIR TAXI AIR TAXI F MFG MFG G FAA FAA H OTHER OTHER I COMMUTER COMMUTER W FORIEGN FORIEGN 99999 INVALID SUBMITTER CODE PSL c280 Char 1 Report submitted: TABLE ID : PSL DESCRIPTION : SUPPORTING INFORMATION CODE LONG DESCRIPTION SHORT DESCRIPTION P PART/PICTURE PART/PICTURE S SKETCH SKETCH L LENGTHY COMMENT 99999 INVALID PSL CODE ALERTCD c290 Char 1 Alert code: TABLE ID : ALR DESCRIPTION : TYPE OF ALERT CODE LONG DESCRIPTION BLANK NO ALERT A ALERT T TELEPHONE ALERT B ALERT/TELEPHONE ALERT 99999 INVALID ALERT CODE AIROPCD c300 Char 4 Air carrier operator code; four-position data element containing either a three or four character maintenance designator officially assigned to an air carrier by the FAA. PRECCD1 c310a Char 1 1st occurrence - Precautionary Procedures Code (For use in report printout) PRECCD2 c310b Char 1 2nd occurrence - Precautionary Procedures Code (For use in report printout) PRECCD3 c310c Char 1 3rd occurrence - Precautionary Procedures Code (For use in report printout) PRECCD4 c310d Char 1 4th occurrence - Precautionary Procedures Code (For use in report printout) TABLE ID : PREPR DESCRIPTION : PRECAUTIONARY PROCEDURE CODE LONG DESCRIPTION SHORT DESCRIPTION A UNSCHED LANDING UNSCHED LANDING B EMER. DESCENT EMER. DESCENT C ABORTED TAKEOFF ABORTED TAKEOFF D RETURN TO BLOCK RETURN TO BLOCK E ENGINE SHUTDOWN ENGINE SHUTDOWN F ACTIVATE FIRE EXT. ACTIVATE FIRE EXT. G MANUAL O2 MASK MANUAL O2 MASK H DEACTIVATE SYST/CIRCUITS DEACTIVATE SYST/CIRC I INTENTIONAL DEPRESSURE INTENTIONAL DEPRESSU J DUMP FUEL DUMP FUEL K NONE NONE L ABORTED APPROACH ABORTED APPROACH O OTHER OTHER R AUTOROTATION AUTOROTATION 99999 INVALID PRECAUTION CODE PRETX1 c314a Char 24 1st occurrence - Precautionary Procedures Text (For use in report printout) PRETX2 c314b Char 24 2nd occurrence - Precautionary Procedures Text (For use in report printout) PRETX3 c314c Char 24 3rd occurrence - Precautionary Procedures Text (For use in report printout) PRETX4 c314d Char 24 4th occurrence - Precautionary Procedures Text (For use in report printout) Naturcd1 c320a Char 1 1st occurrence - Nature of condition code (For use in report printout) Naturcd2 c320b Char 1 2nd occurrence - Nature of condition code (For use in report printout) Naturcd3 c320c Char 1 3rd occurrence - Nature of condition code (For use in report printout) TABLE ID : NAT DESCRIPTION : NATURE OF CONDITION CODE LONG DESCRIPTION SHORT DESCRIPTION A FLAME FLAME B SMOKE SMOKE C F.O.D. F.O.D. D INFLIGHT SEPARATION INFLIGHT SEPARATION E VIBRATION/BUFFET VIBRATION/BUFFET F FLT CONT AFFECTED FLT CONT AFFECTED G MULTIPLE FAILURE MULTIPLE FAILURE H ELECT. POWER LOSS-50 PC ELECT. POWER LOSS-50 I FLT. ATTITUDE INST. FLT. ATTITUDE INST. J WARNING INDICATION WARNING INDICATION K FLUID LOSS FLUID LOSS L NO TEST NO TEST M OVER TEMP OVER TEMP N FALSE WARNING FALSE WARNING O OTHER OTHER P NO WARNING INDICATION NO WARNING INDICATIO R ENGINE FLAMEOUT ENGINE FLAMEOUT Y ENGINE STOPPAGE ENGINE STOPPAGE Z SIGNIFICANT FAILURE REPORT SIGNIFICANT FAILURE 99999 INVALID NATURE CODE Naturtx1 c324a Char 26 1st occurrence - Nature of condition text (For use in report printout) Naturtx2 c324b Char 26 2nd occurence - Nature of condition text (For use in report printout) Naturtx3 c324c Char 26 3rd occurrence - Nature of condition text (For use in report printout) Stagop c330 Char 2 Stage of operation code TABLE ID : STG DESCRIPTION : STAGE CODE LONG DESCRIPTION SHORT DESCRIPTION AA AIR AMBULANCE AIR AMBULANCE AB AEROBATIC AEROBATIC AG AGRICULTURE AGRICULTURE AP APPROACH APPROACH CL CLIMB CLIMB CR CRUISE CRUISE DE DESCENT DESCENT ET ETOPS ETOPS EX EXTERNAL LOAD EXTERNAL LOAD FF FIRE FIGHTING FIRE FIGHTING HO HOVERING HOVERING IN INSP/MAINT INSP/MAINT LD LANDING LANDING MS MAPPING/SURVEY MAPPING/SURVEY NR NOT REPORTED NOT REPORTED TO TAKEOFF TAKEOFF TX TAXI/GRND HDL TAXI/GRND HDL UK UNKNOWN UNKNOWN 99999 INVALID STAGE CODE Stagoptx c332 Char 15 Stage of operation text Status c340 Char 1 Report status: TABLE ID : RPSTA DESCRIPTION : REPORT STATUS CODE LONG DESCRIPTION SHORT DESCRIPTION C ORIG CLSD CLOSED O ORIG OPN OPEN S SUPP CLSD SUPP-C T SUPP OPN SUPP-O 99999 INVALID STATUS Mfroll c350 Char 2 Microfilm roll number of original SDR report Mfframe c360 Char 4 Microfilm frame number of original SDR report Recro c370 Char 2 Region receiving SDR report 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 Recdo c380 Char 2 District office receiving report 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 Nnum c390 Char 5 Aircraft registration or tail number assigned by the FAA Ttime c400 VarChar 5 Total time accumulated on part regardless of overhaul. Right adjusted; zero filled. Ttimeso c410 VarChar 5 Total time accumulated on part since the last overhaul date. Right adjusted; zero filled. Severity c420 Char 1 Factor indicates the degree that the malfunction or defect affects safety of flight. The higher the number, the greater the impact on continued flight safety. TABLE ID : SEV DESCRIPTION : SEVERITY CODE CODE LONG DESCRIPTION SHORT DESCRIPTION W OVER 24 MO OVER 24 MO 1 NEVER NEVER 2 UNCOMMON UNCOMMON 3 OCCASIONAL OCCASIONAL 4 COMMON COMMON 5 FREQUENT FREQUENT 99999 INVALID SEVERITY CODE Sncmpt c430 Char 12 Manufacturer's serial number of component reported. Snacft c440 Char 12 Manufacturer's serial number of aircraft reported. Sneng c450 Char 12 Manufacturer's serial number of engine reported. Snprop c460 Char 12 Manufacturer's serial number of propeller reported. Atacd c490 Char 4 1st Code - Up to 2 three digit ATA codes. May be left blank Rmks1 c510a VarChar 120 1st line of remarks (For use in report printout) Rmks2 c510b VarChar 120 2nd line of remarks (For use in report printout) Rmks3 c510c VarChar 120 3rd line of remarks (For use in report printout) Rmks4 c510d VarChar 120 4th line of remarks (For use in report printout) Rmks5 c510e VarChar 120 5th line of remarks (For use in report printout) Rmks6 c510f VarChar 120 6th line of remarks (For use in report printout) Acftwtcl c602 Char 1 Aircraft weight class code: 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 Acftwing c604 Char 1 Aircraft wing type code: TABLE ID : WING DESCRIPTION : AIRCRAFT WING TYPE 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 MULTI WING S STOL/VTOL/TILT/WING STOL/VTOL/TILT/WING 99999 INVALID WING CODE Acftpwcl c606 Char 1 Aircraft power class code TABLE ID : POWER DESCRIPTION : AIRCRAFT POWER CLASS CODE LONG DESCRIPTION 7 POWERED (SHOW NUMBER OF ENGINES) 8 OPTIONAL (SHOW NUMBER OF ENGINES) 0 NON POWERED ENGINE 2 2 ENGINES 3 3 ENGINES 4 4 ENGINES 5 5 ENGINES 6 6 ENGINES 7 7 ENGINES 8 8 ENGINES 9 9 ENGINES J 10 ENGINES K 11 ENGINES L 12 ENGINES M 13 ENGINES N 14 ENGINES O 15 ENGINES P 16 ENGINES Q 17 ENGINES R 18 ENGINES S 19 ENGINES T 20 ENGINES Numeng c608 VarChar 2 Number of engines Typeng c610 Char 2 Design characteristic code for typical engine or aircraft model Engpwl c612 Char 1 Engine power class code: TABLE ID : ENGPWL DESCRIPTION : AENGINE POWER CLASS CODE LONG DESCRIPTION 3 UNDER 750 HP (SHP) (ESHP) 4 750 HOP (SHP) (ESHP) & OVER Engtypcd c614 Char 1 Engine type code: TABLE ID : ENGTYCD DESCRIPTION : ENGINE TYPE CODE LONG DESCRIPTION O PISTON - OPPOSED R PISTON - RADIAL V PISTON - VEE I PISTON - INLINE J TURBOJET F TURBOFAN/TURBOJET BYPASS T TURBOPROP U TURBOSHAFT Z PURE JET (PULSE/RAM) W ROTARY Y ROCKET X OTHER Landcd c616 Char 2 Landing gear code Acnum c620 Char 8 FAA type certificate control number for aircraft Engnum c640 Char 8 FAA tyoe certificate control number for engine Proppw c652 Char 1 Propeller power code: TABLE ID : PROPPW DESCRIPTION : PROPELLER POWER CODE CODE LONG DESCRIPTION 5 UNDER 750 HP (SHP) ABSORPTION 6 750 HP (SHP) & OVER ABSORPTION Propty c654 Char 1 Propeller type code: TABLE ID : WGT DESCRIPTION : PROPELLER TYPE CODE CODE LONG DESCRIPTION C CONTROLLABLE PITCH N NONCONTROLLABLE (FIXED/GROUND A) Propnum c660 Char 8 FAA type certificate control number for propeller Null eof VarChar 1 NULL