OpenAirDocs.org
AD 80-25-07 R1

Registered aircraft · 25,370

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-25-07-R1')
    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-07-R1')
  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.

N20121Fly Maui LLC · Puunene, HIBuilt 1972 · S/N 17261025N20123Irungu Gitau · Charlotte, NCBuilt 1972 · S/N 17261027N20124Cerven Bohuslav Bo · Claremont, CABuilt 1977 · S/N 17702631N20127Lewallen David H · Alexander, ARBuilt 1977 · S/N 17702633N2012EAirgo Inc · Centralia, ILBuilt 1978 · S/N 17271117N2012QOwens Joseph L · Fort Mohave, AZBuilt 1973 · S/N 177RG0412N20132J & L Aviation LLC · Malta, NYBuilt 1972 · S/N 17261035N20133Creative Strategies Inc · Proctorville, OHBuilt 1972 · S/N 17261036N20136Crate Inc · Humboldt, NEBuilt 1972 · S/N 17261038N20141Bbrrjd Inc · Wilmington, DEBuilt 1972 · S/N 17261042N20142Johnson Lindley N · Kingstowne, VAS/N 17702635N20143Loomis Aviation LLC · Gahanna, OHBuilt 1972 · S/N 17261044N20145Avco Patrol LLC · Lyndon, KSS/N 17702636N2014EWanda Collins Professional Pilot Services LLC · Madisonville, TXBuilt 1978 · S/N 17271118N2014QRegistration Pending · Glennville, GARegistration pendingBuilt 1973 · S/N 177RG0414N2014UMlc Air LLC · Clarkston, MIS/N 24-1590N20151Binder Andrew S · Santa Barbara, CAS/N 17702637N20154Jones 170a LLC · Bridgman, MIBuilt 1972 · S/N 17261051N20155Wild Wingdom LLC · Greenville, SCBuilt 1972 · S/N 17261052N20157Kelley Aircraft LLC · Weyers Cave, VABuilt 1972 · S/N 17261053N20158Vbp Services LLC · Wainscott, NYBuilt 1972 · S/N 17261054N20159Western Edge Aviation LLC · Dickinson, NDBuilt 1972 · S/N 17261055N2015QMeyer Gregory L · Lebanon, PABuilt 1973 · S/N 177RG0415N20169R D T Aviation Inc · Williston, VTBuilt 1972 · S/N 17261062N20170Cardinal Group · Linden, MIS/N 17702639N20172Queen City Aero Club Inc · Chelmsford, MABuilt 1972 · S/N 17261065N20174Feighny James P · Rockville, MDS/N 17702640N20175Jet 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 17261071N2017EPlane Fun Flying Club · Vancouver, WABuilt 1982 · S/N 18268183N2017QGraves William D · Rock Hill, SCBuilt 1973 · S/N 177RG0417N20181Mile 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 17261081N20190Parks William T · Jasper, TNBuilt 1973 · S/N 17261082N20192Registered 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 17271120N201AHicks Paul W Jr · Flower Mound, TXBuilt 1979 · S/N 24-0767N201ADWeyrick Zebedee · Lakeville, MNS/N 24-0359N201AGAnjory Aviation LLC · Wausau, WIBuilt 1977 · S/N 24-0405
Back to AD 80-25-07 R1