Skip to content

Registered aircraft · 25,369

Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.

Query with SQL

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:80-25-07-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-25-07-R1') ORDER BY n_number

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:80-25-07-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-25-07-R1')
  ORDER BY n_number"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:80-25-07-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-25-07-R1')
ORDER BY n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N1480USchaad Michael · Yorba Linda, CABuilt 1976 · S/N 17267147 N1481VTalbert Barbara E · Wesley Chapel, FLBuilt 1974 · S/N 17263615 N1482VGriffin Samuel · Doniphan, MOBuilt 1974 · S/N 17263616 N1483UJohnson William Scott · New Market, TNBuilt 1976 · S/N 17267150 N1484UCrescent City Aviation Club LLC · New Orleans, LABuilt 1976 · S/N 17267151 N1485UClass A Aviators Inc · Parsons, KSBuilt 1976 · S/N 17267152 N1486UMoss Motor Company Inc · South Pittsburg, TNBuilt 1976 · S/N 17267153 N1487UNew Richard A · Deming, WABuilt 1976 · S/N 17267154 N1487VFirst Flight Corporation · San Diego, CABuilt 1974 · S/N 17263621 N1488UShine Donald J · Waterford, WIBuilt 1976 · S/N 17267155 N1488VPerks Brian G · Otis Orchards, WAS/N 17263622 N1489EWings Over Water Inc · Minneapolis, MNBuilt 1978 · S/N 17271019 N1489UAustin Aeroflight Inc · Austin, MNBuilt 1976 · S/N 17267156 N148ACMach 1 Aircraft LLC · Malibu, CABuilt 1993 · S/N 717-93 N148AKMurphy Patrick · Englewood, COBuilt 2014 · S/N 1140-2014 N148BCWalker Dean M · Fort Collins, COBuilt 2008 · S/N 507-2008 N148PCSuperd LLC · Everett, WABuilt 2005 · S/N 996-2005 N1490EFoothill Aircraft Sales & Service Inc · Upland, CABuilt 1978 · S/N 17271020 N1491UGardner Christopher · Farmers Branch, TXBuilt 1976 · S/N 17267158 N1493ESherman Aviation LLC · Fairfield, NJBuilt 1978 · S/N 17271022 N1493VMy Flight LLC · Cypress, TXBuilt 1974 · S/N 17263623 N1494CFour C'S Equipment Leasing LLC · Fresno, CABuilt 1978 · S/N 21063065 N1494VWings Over Texas Holdings LLC · Denton, TXBuilt 1974 · S/N 17263624 N1495CGulf Coast Helicopters Inc · Pearland, TXBuilt 1977 · S/N 17702737 N1495UFairflight LLC · San Diego, CABuilt 1976 · S/N 17267162 N1498CBrutger Wayne A · Saddlebrooke, AZBuilt 1978 · S/N 17702739 N1498VMoore James E · East Falmouth, MABuilt 1974 · S/N 17263628 N1499CGalbrecht Daniel S · Arbor Vitae, WIBuilt 1978 · S/N 17702740 N149BCKurtz Garold · Mound City, MOBuilt 2004 · S/N 4532004 N149JCCorrea Javier Rafael · Caguas, PRS/N 17276119 N149SAVan Bergen Matthew D · Arlington Heights, ILBuilt 2008 · S/N 10672008 N149SGWaterwings Seaplanes LLC · Hoover, ALBuilt 2006 · S/N 1021-2006 N14AZD & L Aircraft Leasing LLC · Ormond Beach, FLBuilt 1975 · S/N 17263495 N14BLEagle Equity Inc · Valparaiso, INBuilt 1968 · S/N 17257735 N14EJPrecision Air LLC · Trent, SDBuilt 1993 · S/N 709-93 N14JRAerial Reconnaissance Inc · Trent Woods, NCS/N 479-73 N14JVFullen Ronnie E · Seguin, TXBuilt 1977 · S/N 0749 N14KDBobcat Ag LLC · Wooster, ARBuilt 2020 · S/N 604-2020 N14KFParker Jerry · Houston, TXS/N 656-91 N14MTSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1979 · S/N R18201227 N14NFStiles Terry D · King Salmon, AKBuilt 1968 · S/N 17256844 N14SASidney Aviation LLC · Sidney, NEBuilt 2014 · S/N 1146-2014 N14SKHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1979 · S/N 15283422 N14TWAllbid Inc · Opelousas, LAS/N 670148 N14WFSamberg Scott S · Gillette, WYBuilt 1976 · S/N 233-76 N14XDAero Leasing Inc · Wilmington, DEBuilt 2014 · S/N 1152-2014 N15000Central District Aviation LLC · Seattle, WABuilt 1969 · S/N 17258075 N1504VCulman William A · Scotts Valley, CABuilt 1974 · S/N 17263633 N1506VDeshon Loren · Friday Harbor, WABuilt 1974 · S/N 17263634 N1507EGonzalez Moya Camilo Rafael · Fort Worth, TXBuilt 1978 · S/N 17271028

Back to AD 80-25-07 R1