Skip to content

Registered aircraft · 6,349

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-02-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-25-02-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-25-02-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-25-02-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-25-02-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-25-02-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.

N5600HGreen James H · Bladenboro, NCS/N 16-207 N5601HPierce Stephan L · Graham, TXBuilt 1949 · S/N 16-208 N5601LManheimer Robert M · Marysville, WABuilt 1968 · S/N AA1-0003 N5603ZAngerman Ronald A · Gilbert, SCBuilt 1962 · S/N 22-9413 N5605ZMossman Aaron P · West Plains, MOS/N 22-9408 N5606LJones Andrew S · Greensboro, GABuilt 1968 · S/N AA1-0008 N5607ZCorcoran Francis A · Rochelle, ILBuilt 1962 · S/N 22-9418 N5608ZSale Reported · Casper, WYSale reportedBuilt 1962 · S/N 22-9420 N5609ZRowland Gary W · Edmond, OKBuilt 1962 · S/N 22-9421 N560PCHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1978 · S/N 15281915 N5610HReese Christopher R · Hanover, MNBuilt 1949 · S/N 16-217 N5610ZMcvey James W · Mentor, OHBuilt 1962 · S/N 22-9422 N5612LHolden Jason K · Conroe, TXBuilt 1968 · S/N AA1-0014 N5613ZAndersen Zachary J · Seward, AKBuilt 1962 · S/N 22-9424 N5614LFiler Jacob Adam · Clarksville, TNBuilt 1968 · S/N AA1-0016 N5615LAnthonson Ronald G · Cortland, NYBuilt 1968 · S/N AA1-0017 N5615ZKuebler Terry T · Gahanna, OHBuilt 1962 · S/N 22-9427 N5618ZNull Clifford M · Punxsutawney, PABuilt 1962 · S/N 22-9430 N5619HFranklin Vernon L · Aguila, AZBuilt 1949 · S/N 16-230 N5619LEncarnacion Ramon A · Miramar, FLS/N AA1-0021 N5620LRichardson Carl · Jonesboro, GABuilt 1968 · S/N AA1-0022 N5622HHallum Randal · Wewoka, OKBuilt 1949 · S/N 16-233 N5623ZQuinlan John H · Claxton, GABuilt 1962 · S/N 22-9435 N5624HCameron Thomas W · Lennon, MIS/N 16-235 N5625ZBellamy John Mark · Freeville, NYBuilt 1962 · S/N 22-9437 N5626HWhitmore Martha J · Terlingua, TXBuilt 1949 · S/N 16-237 N5627LFrattarelli Marco · Carrollton, TXBuilt 1968 · S/N AA1-0027 N5628HGade Dale Alan · Antioch, ILS/N 16-239 N5631HBoyd Cecil E · Chocowinity, NCBuilt 1949 · S/N 16-242 N5631LKing Michael Wayne · Centreville, MDS/N AA1-0031 N5631ZMooney Timothy · Hedgesville, WVBuilt 1962 · S/N 22-9443 N5632LLas Vegas Aerial Services LLC · Las Vegas, NVS/N AA1-0032 N5632ZEakin Andrew C · Franklin, PABuilt 1962 · S/N 22-9444 N5634LOlson Mitch A · Silver Springs, NVBuilt 1968 · S/N AA1-0034 N5635LCentury Air Inc · Fairfield, NJBuilt 1968 · S/N AA1-0035 N5636LCrosby Thomas G · Saint Charles, MOS/N AA1-0036 N5636ZYoung Harold E · Jamestown, NYS/N 22-9448 N5637ZKutcher Dennie L · Galeton, COBuilt 1962 · S/N 22-9449 N5638HHoudek Dennis E · Roseburg, ORBuilt 1949 · S/N 16-249 N5639HKruse Bryan J · Bethel, AKBuilt 1949 · S/N 16-250 N5640HMitchell Zachary · Franklin, NHBuilt 1949 · S/N 16-251 N5641ZScout Aviation LLC · Arnaudville, LAS/N 22-9460 N5642HSlaughter Don W · Farmville, NCFirst renewal noticeBuilt 1949 · S/N 16-253 N5643LChaney Timothy W · Peoria, AZBuilt 1968 · S/N AA1-0043 N5644HPoliti Terris P · Lake Placid, NYBuilt 1949 · S/N 16-255 N5644LMartinez Pedro M · BreeNon-citizen corporation, flight hours not reportedBuilt 1968 · S/N AA1-0044 N5644ZVon Drashek Bruce P · Prior Lake, MNBuilt 1962 · S/N 22-9461 N5645LT2tc LLC · Enka, NCBuilt 1968 · S/N AA1-0045 N5646LHutcheson Bruce D · Anthem, AZBuilt 1968 · S/N AA1-0046 N5649ZDyson Keith A · Port Townsend, WABuilt 1962 · S/N 22-9472

Back to AD 80-25-02 R2