OpenAirDocs.org
AD 79-10-03 R2

Registered aircraft · 40,395

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:79-10-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:79-10-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.

N200YRSloan Cooper · Seattle, WAS/N 28-7615279N20102Wings Over Texas Holdings LLC · Denton, TXBuilt 1972 · S/N 17261010N20106Atlanta Air Academy LLC · Kennessaw, GABuilt 1972 · S/N 17261014N2010AMaine Instrument Flight · Augusta, MEBuilt 1978 · S/N M-2066N2010CLegner Leasing LLC · Las Vegas, NVBuilt 1958 · S/N TD-177N2010LTec Consulting LLC · Farmingdale, MEBuilt 1978 · S/N M-2058N2010TGustafson Keith W · Waleska, GABuilt 1970 · S/N 10N2010ZSanchez Michael G · Hesperia, CABuilt 1967 · S/N 28-22409N20115Alpha Zulu Aviation LLC · San Diego, CABuilt 1972 · S/N 17261021N20116Paxton Roger D · Norman, NCFirst renewal noticeS/N 17702630N2011CTuorila Leo Eric · Anderson, SCBuilt 1958 · S/N TD-178N20120Bennett Robert J Jr · Minneapolis, MNBuilt 1978 · S/N M-2071N20121Fly Maui LLC · Puunene, HIBuilt 1972 · S/N 17261025N20123Irungu Gitau · Charlotte, NCBuilt 1972 · S/N 17261027N20124Cerven Bohuslav Bo · Claremont, CABuilt 1977 · S/N 17702631N20125New Horizon Aviation Inc · Warwick, RIBuilt 1978 · S/N ME-94N2012EAirgo Inc · Centralia, ILBuilt 1978 · S/N 17271117N2012KMaine Instrument Flight · Augusta, MEBuilt 1978 · S/N MB-901N2012LRegistration Pending · Dallas, TXRegistration pendingBuilt 1966 · S/N 345N2012NAirhawks Flying Clup · Eastsound, WABuilt 1978 · S/N M-2068N20132J & L Aviation LLC · Malta, NYBuilt 1972 · S/N 17261035N20133Creative Strategies Inc · Proctorville, OHBuilt 1972 · S/N 17261036N20136Crate Inc · Humboldt, NEBuilt 1972 · S/N 17261038N2013AMusketeer LLC · Fayette, ALBuilt 1978 · S/N MB-902N2013NSimply Living LLC · Fort Myers, FLBuilt 1978 · S/N M-2070N20141Bbrrjd Inc · Wilmington, DEBuilt 1972 · S/N 17261042N20143Loomis Aviation LLC · Gahanna, OHBuilt 1972 · S/N 17261044N2014COharra Robert J · Buckley, WABuilt 2003 · S/N 001N2014EWanda Collins Professional Pilot Services LLC · Madisonville, TXBuilt 1978 · S/N 17271118N2014LGreenwood Daniel · Golconda, ILBuilt 1966 · S/N 347N2014PAerial Sign North · Lakewood, NJBuilt 1956 · S/N 18-4602N20154Jones 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 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 17261081
Back to AD 79-10-03 R2