OpenAirDocs.org
AD 80-04-03 R2

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

N20159Western Edge Aviation LLC · Dickinson, NDBuilt 1972 · S/N 17261055N20169R D T Aviation Inc · Williston, VTBuilt 1972 · S/N 17261062N2016PVladimir Ravich · Fort Montgomery, NYS/N 23-588N20172Queen City Aero Club Inc · Chelmsford, MABuilt 1972 · S/N 17261065N20175Jet Air Solutions Inc · Fort Myers, FLS/N 17261068N20176Greenwood David L · Garrettsville, OHBuilt 1972 · S/N 17261069N20177Nashville Flight School LLC · Nashville, TNBuilt 1972 · S/N 17261070N20178Christopher Sandra A · Mabel, MNBuilt 1972 · S/N 17261071N2017LLarson Lawrence Stephen · Park Rapids, MNS/N 350N20181Mile High Aviation · Saint Peter, MNBuilt 1972 · S/N 17261074N20182Gillies David K · Raymond, MEBuilt 1972 · S/N 17261075N20183Registered aircraftBuilt 1972 · S/N 17261076N20185Woodhams Jonathon R · South Haven, MIBuilt 1972 · S/N 17261078N20187Dewitt Troy C · Lake Elmo, MNS/N 17261080N20189Detroit Public Schools Community District · Detroit, MIS/N 17261081N2018PHauer Clifford Joseph Jr · Woodstock, GABuilt 1956 · S/N 23-590N20190Parks William T · Jasper, TNBuilt 1973 · S/N 17261082N20191Warbington Michael L · Enid, OKBuilt 1983 · S/N 15-578N20192Registered aircraftBuilt 1977 · S/N 17702643N20193Gibbs Wyatt Richmond · Lodi, CAS/N 17261085N20195Vertol Systems Company Inc · Destin, FLBuilt 1972 · S/N 17261087N20196Bergfalk Craig Steven · Anacortes, WAS/N 17261088N201975 Degrees North Inc · East Stroudsburg, PABuilt 1972 · S/N 17261089N20199Worms Jeffrey J · Bonita Springs, FLBuilt 1972 · S/N 17261090N2019ECox Garry G · Coleman, TXS/N 17271120N201HWRichards Troy L · Saint Jo, TXBuilt 2005 · S/N 2803N201MNWeidner Jamie A · Perrysburg, OHBuilt 1966 · S/N 1242N201SFOmara Michael N · Seymour, CTBuilt 1965 · S/N 28-2630N201TMerten James F · Oshkosh, WIBuilt 1970 · S/N 186N201ZBBrowne Michael T · Ada, OKBuilt 1978 · S/N 24-0415N20201Castillo Frank E · San Jose, CABuilt 1972 · S/N 17261091N20202Lolani Leasing LLC · Los Angeles, CABuilt 1972 · S/N 17261092N20203Wannenburg Thomas · Atlantic Beach, FLBuilt 1972 · S/N 17261093N20207Disheroon Donald · Houston, TXS/N 17261095N20208American Patrols Inc · Midland, TXBuilt 1972 · S/N 17261096N20211Lee Cas LLC · Macomb, ILBuilt 1972 · S/N 17261098N20213Valiair Limited Company Trustee · Casper, WYBuilt 1972 · S/N 17261099N20214Bingairman LLC · Newville, PABuilt 1977 · S/N 17702645N20215Northeastern Financial LLC · New Gloucester, MEBuilt 1972 · S/N 17261101N20216Manke Derek E · Canton, GABuilt 1972 · S/N 17261102N20218Emporia Flying Club Inc · Emporia, KSBuilt 1972 · S/N 17261104N20219Koenitzer Judson B · Chetek, WIS/N 17261105N2021CPray Aviation Inc · Augusta, KSBuilt 1959 · S/N TD-212N2021LNiehaus James O · Erie, COBuilt 1967 · S/N 354N2021RYergers Garage LLC · Leesport, PABuilt 1969 · S/N 28-5429N20223Roberts Stephen Wade · Friendswood, TXBuilt 1977 · S/N 17702648N20225N20225 LLC · Pottsboro, TXBuilt 1972 · S/N 17261110N20226Morris Aero Club · Towaco, NJBuilt 1972 · S/N 17261111N2022CCarriere James M · Navarre, FLBuilt 1959 · S/N TD-189N20230Cessna 20230 LLC · Windsor, CABuilt 1972 · S/N 17261115
Back to AD 80-04-03 R2