Description: FAA database of all active transport aircrart in MS access, Excel and PDF formats (all 3 included). FAA database data downloaded from FAA website in August 2024. This data is in the public domain but I have combined the data from multiple files and converted many cryptic codes into descriptions so the results are very easy for the average person to discern. Plus the data is provided in 4 formats, several of which are searchable. The formats are (1) MS Access database, (2) Excel spreadsheet, (3) PDF file and (4) text file. Additionally, a PDF file is provided which explains each piece of data (field or column) as described in FAA documentation. Also, the original FAA documentation is included (public domain PDF downloadable from FAA website). The data provided includes all 21,000+ active Transport aircraft registered with the FAA as of August 2024. A full database including non-transport aircraft is also available. Request full database layout which can be sent to you by email in advance or download the specs from here for free. This will be shipped to you on DVD or SD card (your choice). Here are the list of columns provided:---------------------------------------------------------------------------- FAA AIRCRAFT DATABASE ACCESS TABLE AND SPREADSHEET COLUMNS WITH DESCRIPTIONS. The FAA database contains the records of all U.S. Civil Aircraft maintained by the FAA, Civil Aviation Registry, Aircraft Registration Branch, AFS-750. This document copywrited by Computer Systems Solutions Inc 2024. Table and Spreadsheet Column Name FAA SPECS NAME DESCRIPTION ----------- ---------------------- --------------------------------------- recno n/a Record # in the entire aircraft database (including non-transport aircraft) numbx n/a Same as 'N-xxxxxx' without the 'N'. n_numb N-Number Identification number assigned to aircraft by FAA. serial_no Serial Number The complete aircraft serial number assigned to the aircraft by the manufacturer. mfr_mdl_code Aircraft Mfr Model A code assigned to the aircraft Code manufacturer, model and series. Positions (38-40) - Manufacturer Code Positions (41-42) - Model Code Positions (43-44) - Series Code manuf_name Name of aircraft manufacturer model_name Model name of aircraft ac_type_code Type Aircraft A single digit code. 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 H - Hybrid Lift O - Other aircraft_type Type Aircraft repeat of above but just the description 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 H - Hybrid Lift O - Other year_mfr Year Mfr Year manufactured. no_seats Number of Seats Maximum number of seats in the aircraft reg_type_code Registrant Type Code One position numeric field. As follows: registrant_type Registrant Type Desc 1 Individual 2 Partnership 3 Corporation 4 Co-Owned 5 Government 7 LLC 8 Non Citizen Corporation 9 Non Citizen Co-Owned registrant_name Registrant's Name The first registrant name which appears on the Application for Registration, AC Form 8050-1. street1 Street1 The street address which appears on the Application for Registration, AC Form 8050-1 or the latest street address reported. street2 Street2 The 2nd street address which appears on the Application for Registration, AC, Form 8050-1, or the latest street address reported. city Registrant's City The city name which appears on the Application for Registration, AC Form 8050-1 or the latest address reported. state Registrant's State The state name which appears on the Application for Registration, AC Form 8050-1 or the latest address reported. zip_code Registrant's Zip Code The postal Zip Code which appears on the Application for Registration, AC Form 8050-1 or the latest address reported. region Registrant's Region A single-character code identifying the registrant region. region_desc Description of registrant region: 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 County Mail A code representing the county which appears on the Application for Registration. country Country Mail A code representing the country which appears on the Application for Registration. last_act_date Last Activity Date Format YYYY-MM-DD last_act_date2 same as above MM/DD/YYYY (may be used for selection criteria) cert_date Certificate Issue Date Format YYYY-MM-DD cert_date2 same as above MM/DD/YYYY (may be used for selection criteria) ac_weight TO BE REMOVED. Same as next column. CLASS 1 - Up to 12,499 CLASS 2 - 12,500 - 19,999 CLASS 3 - 20,000 and over. takeoff_wgt Takeoff Weight Aircraft maximum gross take off weight in pounds. speed Speed Aircraft average cruising speed in miles per hour. This data element is not present on all records. no_eng No. of engines Number of engines eng_mfr_mdl Engine Mfr Mode Code A code assigned to the engine manufacturer and model. Positions (46-48) - Manufacturer Code Positions (49-50) - Model Code eng_mfr_name Engine manufacturer name eng_model Engine model eng_type_code Engine Type Code Code indicates engine type as below. eng_type_desc Engine Type Descr. 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 eng_lbs_thrust Engine thrust in pounds. will be zero or N/A if horsepower shown eng_horse_power Engine horse power. will be zero if thrust shown aw_code1 Code for airworthiness class aw_code2 Code for approved operations aw_code3 not used aw_class Airworthiness Classification approved_op Approved Operations (note: always T for Transport in this table; other types excluded from this table) status_code Status Code Status code status_desc Status description transponder_code Mode S Code Aircraft Transponder Code fract_owner Fractional Ownership Y - Registration has fractional ownership blank - Registration is not fractional owned airworth_date Airworthiness Date Date of Airworthiness YYYY-MM-DD airworth_date2 same as above but format mm/dd/yy and may be used for selection criteria other_name1 Other Name 1 1st co-owner or partnership name other_name2 Other Name 2 2nd co-owner or partnership name other_name3 Other Name 3 3rd co-owner or partnership name other_name4 Other Name 4 4th co-owner or partnership name other_name5 Other Name 5 5th co-owner or partnership name expire_date Expiration Date Format YYYY-MM-DD expire_date2 same as above but format mm/dd/yy and may be used for selection criteria unique_id Unique ID Unique Identification Number kit_mfr Kit Mfr Kit Manufacturer Name kit_model Kit Model Kit Model Name transp_hex Mode S Code Hex Mode S Code in Hexidecimal Format
Price: 50 USD
Location: Oak Harbor, Washington
End Time: 2024-11-19T22:35:30.000Z
Shipping Cost: 5 USD
Product Images
Item Specifics
Restocking Fee: No
Return shipping will be paid by: Buyer
All returns accepted: Returns Accepted
Item must be returned within: 14 Days
Refund will be given as: Money Back
Brand: Unbranded
Type: DATABASE
Format: USB
License Category: Government
For Operating Systems: Windows 7,8,9,10,11
Number of Devices: Unlimited