Taryn Rose

FAA AIRCRAFT DATABASE IN EASY TO READ / SEARCHABLE FORMAT

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

FAA AIRCRAFT DATABASE IN EASY TO READ / SEARCHABLE FORMAT

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

Recommended

5 Pack 1/16oz Weedless Bass Fishing Tube Jig Head With 3/0 Mustad 32746 Bln Hook
5 Pack 1/16oz Weedless Bass Fishing Tube Jig Head With 3/0 Mustad 32746 Bln Hook

$5.50

View Details
DETROIT LIONS EMBROIDERED IRON ON PATCH 2.5” X 2.5” FREE SHIPPING
DETROIT LIONS EMBROIDERED IRON ON PATCH 2.5” X 2.5” FREE SHIPPING

$4.79

View Details
Fender 60's Jaguar Waterslide Guitar Headstock Decals (Set of 3)
Fender 60's Jaguar Waterslide Guitar Headstock Decals (Set of 3)

$9.70

View Details
Monopoly 1-3 Stars Stickers (Fast Delivery)
Monopoly 1-3 Stars Stickers (Fast Delivery)

$0.99

View Details
INTIMACY DECK OF CARDS!!!
INTIMACY DECK OF CARDS!!!

$14.99

View Details
Pittsburgh Steelers NFL Football Sticker Decal S31
Pittsburgh Steelers NFL Football Sticker Decal S31

$2.70

View Details
Magnetic Golf Cart Cigar Clip
Magnetic Golf Cart Cigar Clip

$12.99

View Details
Jigheads 50 Round No Collar Unpainted Jig Heads Choose Size
Jigheads 50 Round No Collar Unpainted Jig Heads Choose Size

$13.95

View Details
Rope Scrape, Scrape Rope, Mock Scrape, Hemp Rope, Licking Branch (3/4” X 4’)
Rope Scrape, Scrape Rope, Mock Scrape, Hemp Rope, Licking Branch (3/4” X 4’)

$16.99

View Details
Green Mint Beads Dispenser Refills (4 Packs)
Green Mint Beads Dispenser Refills (4 Packs)

$13.00

View Details