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.

N36267Ashcraft Keirsten · Longview, TXS/N 269-73 N3626XJameson John M · Enid, OKBuilt 1969 · S/N 354 N36276Gronning Skyler · Westby, WIBuilt 1978 · S/N 28-7816624 N3627EJmch Flight LLC · Henderson, NVBuilt 1978 · S/N 17271610 N3627XMonagas Jose · Lehigh Acres, FLBuilt 1969 · S/N 355 N3627ZHousel Thomas J · Pebble Beach, CABuilt 1960 · S/N 22-7519 N36281Hedgehog Management LLC · Salem, OHBuilt 1978 · S/N 28-7890503 N36288Monke David W · Fontanelle, NEBuilt 1973 · S/N 563-73 N36299Wiebe James R · Valley Center, KSBuilt 2016 · S/N 20863 N3629HHolley Victor R · Seneca, SCBuilt 1978 · S/N 20-1254 N3629RJohns Brian A · Efland, NCBuilt 1970 · S/N 28-5725 N362BLLabelle Brendan · Huntington, NYBuilt 1978 · S/N 17270478 N362CAChoice Aviation LLC · Hamilton, MTBuilt 1970 · S/N 17258976 N362HZSpencer Rimmel Lee · Haskell, OKBuilt 2022 · S/N 362 N362MBAcme Aircraft Flying Club LLC · Kalispell, MTBuilt 2009 · S/N 70577 N36304Capital Aviation II LLC · Bethesda, MDBuilt 1978 · S/N 28-7890504 N3630NSalvesen William · Clermont, NJBuilt 1967 · S/N 680018 N3630RLachance John A · Thompson, CTBuilt 1971 · S/N 28-7125375 N3631EMudcat Construction Inc · Beattyville, KYBuilt 1978 · S/N 17271611 N3631PRoss Donald M · Fallbrook, CABuilt 1956 · S/N 22-3726 N3631XLee Brent · Cumming, GABuilt 1969 · S/N 359 N3632EHigh Exposure Inc · Wilmington, DEFirst renewal noticeBuilt 1978 · S/N 17271612 N36335Simmons Darren · Diamondhead, MSBuilt 1973 · S/N 271-73 N3633NPerotti Camille C · Carolina Beach, NCBuilt 1967 · S/N 680019 N3633RGrammar Adrian Gates · Geneva, NYBuilt 1970 · S/N 28-5728 N3634RRatkovich Stephen · Prospect Heights, ILBuilt 1971 · S/N 28-7125140 N36350Hennager Eric D · Langdon, NDBuilt 1973 · S/N 272-73 N36351Mueller Michael A · Seguin, TXBuilt 1973 · S/N 567-73 N36355Nationwide Aviation LLC · Hudson Oaks, TXBuilt 1978 · S/N 28-7816630 N36358Hans Aviation Inc · Davie, FLBuilt 1978 · S/N 28-7816631 N3635QFantini Real Estate LLC · Louisville, KYBuilt 1967 · S/N MB-246 N3635XInternational Air Charter Inc · Intl Falls, MNS/N 5084 N3635ZRiggi Dean A · Scotia, NYBuilt 1960 · S/N 22-7530 N3636KCronin John M · Bremerton, WABuilt 1967 · S/N 28-23662 N3637PBlazek Troy L · Cottage Grove, MNBuilt 1955 · S/N 22-3374 N3637RGelinger Gary · Cape Carteret, NCBuilt 1970 · S/N 28-5732 N3637ZFord Kristy M · Marianna, FLBuilt 1960 · S/N 22-7532 N3638HQuantie Harold G · Locust Grove, OKS/N 20-1256 N3638PSorrell Byron D · Warren, MIBuilt 1955 · S/N 22-3389 N3638QWinder Keven S · Castle Rock, COBuilt 1967 · S/N MB-251 N3638RDukeman James C · Apex, NCBuilt 1970 · S/N 28-5735 N36393Meriden Aviation Center LLC · Meriden, CTS/N 28-7816633 N36395Brittle Aviation LLC · Chapel Hill, NCBuilt 1978 · S/N 28-7816634 N3639HBeatty Earl IV · Gambrills, MDBuilt 1978 · S/N 20-1257 N3639PJoseph Patrick S · Saint Charles, MOBuilt 1955 · S/N 22-3390 N3639ZStahl Calvin D · Auburn, WABuilt 1960 · S/N 22-7534 N363GCPorter David R · Dayton, OHBuilt 1993 · S/N 363 N363RVRoberts David · Albuquerque, NMBuilt 2010 · S/N 60388 N36400Vlietstra Steven J · Hatley, WIBuilt 1978 · S/N 28-7890511 N36409Wire Wonder Inc · New York, NYNon-citizen corporation, flight hours not reportedBuilt 1978 · S/N 28-7816636

Back to AD 80-04-03 R2