Skip to content

Registered aircraft · 40,472

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.

N3887XAdams Kenneth Lee Jr · Jasper, GABuilt 1967 · S/N 192 N3888FBank Of Utah Trustee · Salt Lake City, UTBuilt 1976 · S/N 28-7690454 N3889PSipes Austin L · North Pole, AKBuilt 1956 · S/N 18-4722 N3889QRegistration Pending · White, GARegistration pendingBuilt 1971 · S/N 17259989 N388CCDr Holding LLC · Saint Marys, PABuilt 2002 · S/N 9942CC N388DSDelta State University · Cleveland, MSBuilt 2011 · S/N 42.AC139 N388JFAspire Aviation LLC · Farmingdale, NYS/N 17276182 N388METrinity Aviation Group LLC · Hudson Oaks, TXBuilt 1955 · S/N 23-322 N388MJSundance Aero LLC · Mertzon, TXBuilt 2001 · S/N 3224 N388PGAviator Air Flight School LLC · Grand Prairie, TXBuilt 1972 · S/N 17260525 N38900Thompson Henry S · Plantsville, CTBuilt 1977 · S/N 28-7790604 N38901Weintraub Beverly · New York, NYBuilt 1977 · S/N 28-7790606 N3890ZIngman Joshua P · Dickinson, NDBuilt 1961 · S/N 18-7706 N38914Acadian Aviation Pilot Training Centre Inc · Lafayette, LABuilt 1977 · S/N 28-7716291 N3891QRiley George L III · Washington, INBuilt 1971 · S/N 17259991 N3891ZLaudon Sydney L · Anchorage, AKS/N 18-7707 N3892KRowley Rodney N · Duchesne, UTS/N 28-23763 N3892QKcn Aero Club Inc · Overland Park, KSS/N 17259992 N3892ZWinston Christopher C · Vancouver, WABuilt 1961 · S/N 18-7708 N3893QSisung Ty J · Roxie, MSBuilt 1971 · S/N 17259993 N3894FNorth Shore Aero Club · Beverly, MABuilt 1976 · S/N 28-7690459 N38952Ponto Phillip R · Vista, CABuilt 1977 · S/N 28-7716297 N38954Faulkner Wade DBA · Sterrett, ALBuilt 1977 · S/N 28-7716299 N38968Vagabond Flying Association · Winfield, ILBuilt 1977 · S/N 28-7716300 N38969Vandervelden Harmen J · Ware, MABuilt 1977 · S/N 28-7716301 N3896QNishna Valley Flying Club · Red Oak, IABuilt 1971 · S/N 17259996 N3896ZDriggs Daniel H · Anchorage, AKBuilt 1961 · S/N 18-7674 N38970Triple R Aviation LLC · Cleburne, TXBuilt 1977 · S/N 28-7716302 N38972August Aero LLC · Kalispell, MTS/N 28-7716304 N3897XRegistration Pending · Greenwood, INRegistration pendingBuilt 1967 · S/N 134 N3897ZWard Joseph Delon · Wasilla, AKS/N 18-7788 N38986Ascend Aviation LLC · Bountiful, UTBuilt 1977 · S/N 28-7716306 N38987Ocean City Flying Club LLC · Middletown, RIBuilt 1977 · S/N 28-7716308 N38988Bms Aircraft LLC · Tinley Park, ILBuilt 1977 · S/N 28-7716309 N38989M5 LLC · Kit Carson, COBuilt 1977 · S/N 28-7716310 N3898QJaynes Grayson V Sr · Burnet, TXBuilt 1971 · S/N 17259998 N3898XWood Noah S · New Manchester, WVBuilt 1967 · S/N 138 N3898ZTtyf LLC · Hood River, ORBuilt 1960 · S/N 18-7343 N38990Augusta Aviation Inc · Hilton Head Island, SCBuilt 1977 · S/N 28-7890002 N3899JEz Bird LLC · Danbury, CTBuilt 1975 · S/N AA5B-0124 N3899PJaffa Bruce E · Moose Pass, AKBuilt 1956 · S/N 18-4732 N3899QFlight Inc · Gastonia, NCBuilt 1971 · S/N 17259999 N389CCAerial Timber Applicators Inc · Cooperstown, NDBuilt 2002 · S/N 9943CC N389CLCanaan Land Church Inc · Autaugaville, ALBuilt 1972 · S/N 17260700 N38AGBaxter Kyle W · Tumwater, WABuilt 1959 · S/N 24-1259 N38ARThomas John R · Lake Lotawana, MOBuilt 1983 · S/N 114 N38BSJack Browns Seaplane Base Inc · Winter Haven, FLS/N 18-8505 N38CKHartsfield Amy G · Pace, FLS/N 17263959 N38CTAerialcam Media LLC · Goliad, TXBuilt 1977 · S/N 28-7890025 N38FJAty Aviation Inc · Watertown, SDBuilt 1989 · S/N 4495009

Back to AD 80-04-03 R2