AIRCRAFT REGISTRATION MASTER FILE (AKA: FAAREG table) "Contains the records of all U.S. Civil Aircraft maintained by the FAA, Civil Aviation Registry, Aircraft Registration Branch, AFS-750 " Fieldname Type Description N_NUMBER text Identification number assigned to aircraft. SER_NUM text The complete aircraft serial number assigned to the aircraft by the manufacturer. MFR_MDL text "A code assigned to the aircraft manufacturer, model and series. " First two digits - Manufacturer Code Middle two digits - Model Code Positions Last two digits #NAME? ENG_MDL text A code assigned to the engine manufacturer and model. First two digits - Manufacturer Code Last two digits - Model Code YEAR_MFG text Year manufactured. TYP_REG text 1 - Individual 2 - Partnership 3 - Corporation 4 - Co-Owned 5 - Government 8 - Non Citizen Corporation 9 - Non Citizen Co-Owned REG_NAME text The first registrant�s name which appears on the Application for "Registration, AC Form 8050-1. " STREET1 text "The street address which appears on the Application for Registration, AC Form " 8050-1 or the latest street address reported. STREET2 text "The 2nd street address which appears on the Application for Registration, " "AC,Form 8050-1, or the latest street address reported." CITY text "The city name which appears on the Application for Registration, AC Form " 8050-1. STATE text "The state name which appears on the Application for Registration, AC Form " 8050-1. ZIP_CODE text "The zip code that which appears on the Application for Registration, AC Form " 8050-1. REGION text 1 - Eastern 2 - Southwestern 3 - Central 4 - Western-Pacific 5 - Alaskan 7 - Southern 8 - European C- Great Lakes E - New England S - Northwest Mountain COUNTY text "A code representing county on registration application - see ""counties"" look " up table. COUNTRY text "A code representing country on registration application - see ""country"" look " up table. DT_LACH text "Last activity date, character field in YYYY/MM/DD order." NICAR_DT_LAST date "NICAR-created field, converting Last Activity field to date format." DT_CERCH text "Last certification issue date,character field in YYYY/MM/DD order." NICAR_DT_CERT date "NICAR-created field, converting certifcation issue field to date format." "Note: Airworth A and B work together to detail the information about the certification requested and uses. For example, if AIRWORTH (A) begins with 1, then go to the ""standard"" section of AIRWORTH (B) to find more information about the certification." AIRWORTH text "Certification requested and uses: The first character is Airworth A, the rest are Airworth B" First character: A - Airworthiness Classification Code "The airworthiness certificate class which is reported on the Application for Airworthiness, FAA Form 8130-6. " 1 - Standard 2 - Limited 3 - Restricted 4 - Experimental 5 - Provisional 6 � Multiple 7 - Primary 8 - Special Flight Permit 9 � Light Sport Rest of the characters: B - Approved Operation Codes "The approved operations (up to a maximum of six) which are reported on the Application for Airworthiness, FAA Form 8130-6. (see ARData.pdf)" AIR_TYPE text 1 - Glider 2 - Balloon 3 - Blimp/Dirigible 4 - Fixed wing single engine 5 - Fixed wing multi engine 6 - Rotorcraft 7 - Weight-shift-control 8 - Powered Parachute 9 - Gyroplane ENG_Type text 0 - None 1 - Reciprocating 2 - Turbo-prop 3 - Turbo-shaft 4 - Turbo-jet 5 - Turbo-fan 6 - Ramjet 7 - 2 Cycle 8 - 4 Cycle 9 - Unknown 10 - Electric 11 - Rotary StatusCD text A - The Triennial Aircraft Registration form was mailed and has not been returned by the Post Office D - Expired Dealer E - The Certificate of Aircraft Registration was revoked by enforcement action M - Aircraft registered to the manufacturer under their Dealer Certificate N - Non-citizen Corporations which have not returned their flight hour reports R - Registration pending S - Second Triennial Aircraft Registration Form has been mailed and has not been returned by the Post Office T - Valid Registration from a Trainee V - Valid Registration X - Enforcement Letter Z - Permanent Reserved 1 - Triennial Aircraft Registration form was returned by the Post Office as undeliverable 2 - N-Number Assigned � but has not been Registered 3 - N-Number assigned as a Non Type Certificated aircraft - but has not yet been registered 4 - N-Number assigned as import - but not yet registered 5 - Reserved N-Number 6 - Administratively canceled 7 - Sale reported 8 - A second attempt has been made at mailing a Triennial Aircraft Registration form to the owner with no response 9 - Certificate of Registration has been revoked "10 - N-Number assigned, has not been registered and is pending cancellation " 11 - N-Number assigned as a Non Type Certificated (Amateur) but has not been registered that is pending cancellation 12 - N-Number assigned as import but has not been registered that is pending cancellation 13 - Registration Expired 14 - First Notice for Re- Registration/Renewal 15 - Second Notice for Re- Registration/Renewal 16 - Registration Expired - Pending Cancellation 17 - Sale Reported - Pending Cancellation 18 - Sale Reported - Canceled 19 - Registration Pending - Pending Cancellation 20 - Registration Pending - Canceled 21 - Revoked - Pending Cancellation 22 - Revoked - Canceled 23 - Expired Dealer (PendingCancellation) 24 - Third Notice for Re- Registration/Renewal 25 - First Notice for RegistrationRenewal 26 - Second Notice for RegistrationRenewal 27 - Registration Expired 28 - Third Notice for RegistrationRenewal 29 - Registration Expired - PendingCancellation MODESCD text Aircraft Transponder Code FRACTIONAL text Y - Registration has fractional ownership BLANK - Registration is not fractional owned DT_AWRTHCH text Date of Airworthiness in YYYY/MM/DD format. NICAR_DT_AIRWRTH date NICAR-added field converting airwoth to date field. OTHER1 text 1st co-owner or partnership name OTHER2 text 2nd co-owner or partnership name OTHER3 text 3rd co-owner or partnership name OTHER4 text 4th co-owner or partnership name OTHER5 text 5th co-owner or partnership name DT_EXPIR text Date of expiration UNIQUE_ID text Unique Identification Number KIT_MFR text Kit Manufacturer Name KIT_MODEL text Kit Model MODE_S_CODEHEX text Mode S Code Hex Expired Dealer not been returned by the Post Office The Certificate of Aircraft Registration was revoked by Aircraft registered to the manufacturer under their Dealer enforcement action Non-citizen Corporations which have not returned their flight Certificate Registration pending hour reports Second Triennial Aircraft Registration Form has been mailed N-Number Assigned and Registered and has not been returned by the Post Office Enforcement Letter Permanent Reserved Triennial Aircraft Registration form was returned by the Post N-Number Assigned � but has not been Registered Office as undeliverable N-Number assigned as amateur built - but not yet registered N-Number assigned as import - but not yet registered Reserved N-Number Administratively canceled Sale reported A second attempt has been made at mailing a Triennial Certificate of Registration has been revoked Aircraft Registration form to the owner with no response