Skip to content

Registered aircraft · 40,471

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-04-03-R2') 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-04-03-R2') 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-04-03-R2')
    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-04-03-R2')
  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-04-03-R2')
  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-04-03-R2')
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.

N8ZWMccarthy Edward D · New Milford, CTBuilt 1965 · S/N 28-2474 N8ZXKansas Farm And Ranch Inc · Seneca, KSBuilt 1995 · S/N 1210-95 N9000LHuff Ryan P · Oak Harbor, WABuilt 1968 · S/N 680005 N9001DMiller Nancy Lee · Mathews, VABuilt 1958 · S/N 22-6136 N9001JZuckerman Kenneth · Grass Valley, CABuilt 1966 · S/N 28-3026 N9002EWisconsin Aviation Inc · Watertown, WIBuilt 1979 · S/N 17272214 N9002FPray Aviation Inc · Augusta, KSS/N 28-7715297 N9002HAngel Aviation Inc · Peoria, AZBuilt 1975 · S/N 17265892 N9002QNewman Lance H · Maple Valley, WABuilt 2004 · S/N 23891 N9003EBermuda Dunes Flight Training LLC · Palm Desert, CABuilt 1979 · S/N 17272215 N9003FStack Steven E · Santa Clarita, CABuilt 1976 · S/N 28-7790273 N9003JBlack David · Lakeville, MNBuilt 1966 · S/N 28-3028 N9004DStevens Matthew W · Elsie, MIBuilt 1958 · S/N 22-6139 N9004LThoman Mark C · Jacksonville, NCBuilt 1970 · S/N 240-70 N9005HBuffalo Aviation LLC · Royal, NEBuilt 1975 · S/N 17265894 N9005JSmolen Timothy R · Mckinney, TXBuilt 1966 · S/N 28-3030 N9005LColorado Twin Bonanza LLC · Broomfield, COBuilt 1970 · S/N 212-70 N9007DSatina David J · Norton, OHBuilt 1958 · S/N 22-6142 N9008DMullally Timothy · Callicoon, NYBuilt 1958 · S/N 22-6143 N9008ZHawley Luther S · St Matthews, SCBuilt 1979 · S/N 810 N9009DHarper Benjamin J · Talkeetna, AKBuilt 1958 · S/N 22-6144 N9009HConnell Flying Service Inc · Decorah, IABuilt 1975 · S/N 17265897 N9009JJohnson Kent Paul · St George, UTBuilt 1966 · S/N 28-3035 N900BPelczar Kenneth J · San Antonio, TXS/N 22-3452 N900DKMcgilvray Andrea · Bandera, TXBuilt 1970 · S/N 8815 N900FYBain Jeffrey R · Roseville, CAS/N 28-7525252 N900JKDurand Paul C Trustee · Star Prairie, WIBuilt 1971 · S/N 18-8976 N900TXWilliams Harry · Summerland Key, FLS/N 938-76 N900WDPotter Sherrie L · Temple, TXBuilt 1976 · S/N 28-7615282 N900WMMiddlebrook William · Penn Yan, NYBuilt 1956 · S/N 18-5079 N9010DGriffin Roger P · Port Clinton, OHBuilt 1958 · S/N 22-6145 N9010JNix Terry W · Golden, MSBuilt 1966 · S/N 28-3036 N9012HLeading Edge Flight Academy LLC · Bend, ORBuilt 1975 · S/N 17265899 N9012WPolybrown LLC · Massapequa, NYBuilt 1965 · S/N 28-10594 N9013DDemmler Brian D · Ocean City, MDBuilt 1958 · S/N 22-6148 N9013LBarbee Lisa · Dallas, TXS/N 244-70 N9014HFlex Air Holdings Inc · Manhattan, KSBuilt 1975 · S/N 17265900 N9015LMalone Aaron E · Wasilla, AKS/N 247-70 N9015NPerry David · Campbell, CAS/N 28-4711 N9015VAarow Aircraft Leasing LLC · Mcminnville, ORBuilt 1979 · S/N 0011 N9016YStevenson William E · Sutton, AKBuilt 1970 · S/N 18-8904 N9017DGamertsfelder Joe · Midland, TXBuilt 1958 · S/N 22-6152 N9017HMeece Harvey T · Somerset, KYBuilt 1975 · S/N 17265901 N9017JHarlan Tom L · Bakersfield, CABuilt 1966 · S/N 28-3045 N9018DPhillips Melvin · Clarksburg, MDBuilt 2004 · S/N 24877 N9018LJones Dwight D · Anchorage, AKBuilt 1970 · S/N 249-70 N9019DSale Reported · Cave Creek, AZSale reported, pending cancellationBuilt 1958 · S/N 22-6154 N9019QSyrasoft Aviation LLC · Baldwinsville, NYBuilt 1975 · S/N 28-7615002 N901CCKrizanich Richard K · Anacortes, WABuilt 1999 · S/N 9901CC N901CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1999 · S/N 172S8326

Back to AD 80-04-03 R2