OpenAirDocs.org
AD 73-20-07 R2

Registered aircraft · 1,348

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:73-20-07-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:73-20-07-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.

N7687RTaylor Edward P Jr · Spanishburg, WVBuilt 1970 · S/N M-1308N7688RTrudeau Lemaster Productions · Woodland Hills, CABuilt 1969 · S/N MC-2N7689RDelehant Edward J III · Keller, TXBuilt 1970 · S/N M-1289N7691RWestfall Brent J · Three Lakes, WIBuilt 1970 · S/N MB-487N7693RErickson Kenneth W · Mill Creek, WABuilt 1970 · S/N M-1293N7694RC23 LLC · Pendleton, ORS/N M-1294N7696RRice John · Dothan, ALS/N M-1296N76NCDonald K Ashley · Bradenton, FLBuilt 1976 · S/N M-1787N76PTMcmurtrey Michael · Farmington, MNBuilt 1974 · S/N MC228N76SBAdams Simmie A · Bealeton, VABuilt 1975 · S/N M-1776N76VAHartzell Propeller Emp Flg Club · Piqua, OHBuilt 1976 · S/N M-1786N771MBMathis Alan L · Moultrie, GAS/N M-1851N771YJenney Robert M · Wakefield, MABuilt 1977 · S/N MB-862N778MWBaty Mark S · Napa, CABuilt 1975 · S/N M-1679N781JBKilgus Christopher R · Felton, CABuilt 1968 · S/N MB-405N782YBeitler Richard J · Pittsburgh, PABuilt 1978 · S/N M-2004N785DKFoxes Asset Group LLC · Caddo Mills, TXBuilt 1980 · S/N M-2250N7901LMeinders Larry · Biloxi, MSBuilt 1966 · S/N M-976N7907LParker Daniel J · Ewing, NES/N MA-99N7908LUSA Aircraft Leasing LLC · Dover, DEBuilt 1966 · S/N MB-119N790YNostra Aeris LLC · Midway, ARBuilt 1978 · S/N M-2097N7911LAlthouse Randy A · Postville, IAS/N MB-123N7912LMiller Cameron · Loomis, CAS/N MB-129N7914LHumble Aviation LLC · Russellville, ARS/N MB-131N7920LOstrom Richard A · Sterling Hts, MIBuilt 1966 · S/N MA-103N7923LTolliver Richard R · Amery, WIBuilt 1966 · S/N MB-137N7925LAdams August G · Southport, NCS/N MA-112N7928LCox Robert Etan · Flippin, ARBuilt 1966 · S/N MA-115N7930LChavez Andrew · Pagosa Springs, COBuilt 1966 · S/N MA-117N7931LZundel Dana John · Watkins, COS/N MA-118N7937LCombs Jonathan R · Anchorage, AKS/N M-989N793YPark City Flight Training LLC · Merrill, WIBuilt 1979 · S/N M-2184N7940LCoggeshall Jerry · Beavercreek, OHBuilt 1966 · S/N M-992N7942LSpitzer Jimmy J · Waxahachie, TXBuilt 1966 · S/N MA-119N7945LBertsch David L · Caldwell, IDBuilt 1966 · S/N MB-144N7958LLongleaf Aviators LLC · Enterprise, ALBuilt 1966 · S/N MA-139N7962LMeisser Loren M · Marina, CABuilt 1966 · S/N M-998N7963LDanelski Darin L · Oconomowoc, WIBuilt 1966 · S/N M-999N7964LNordby Frederick · Felton, CABuilt 1966 · S/N MA-140N7976LFarrell Michael · Rockwall, TXBuilt 1966 · S/N MB-157N7981LLund Larry D · Manti, UTBuilt 1966 · S/N MA-143N7986LRegistered aircraftBuilt 1966 · S/N MB-164N7987LWhitten Michael Neil · Wimberley, TXBuilt 1966 · S/N MA-148N7988LMorris Aaron B · Louisville, GABuilt 1966 · S/N MA-159N7989LPringle Nathan · Discovery Bay, CABuilt 1966 · S/N MA-150N7990LAshment Joseph E · Shepherd, MTBuilt 1966 · S/N MA-163N7993LFranklin Tonda Leah · Chatfield, TXBuilt 1966 · S/N MA-155N7994LConsummate Inc · Cedar City, UTBuilt 1966 · S/N MA-156N7995LSheehy Gerald L · Wichita, KSS/N M-1005N7996LLester Mark Anthony · Simon, WVS/N M1006
Back to AD 73-20-07 R2