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.

N23859Fu Jinlin · Olympia, WABuilt 1976 · S/N MB-811N2386ZHoffman Kurt T · Savannah, GABuilt 1962 · S/N M-109N2388ZKoehler Brian L · Washington, IAS/N M-94N2389WCherney Cody L · Belleville, KSBuilt 1966 · S/N MB-24N2390LTsiouklas Anthony P · Dunedin, FLBuilt 1963 · S/N M-235N2390QLatia Douglas C · Lafayette, INS/N M-471N2390WNgk Aviation LLC · West Point, NEBuilt 1966 · S/N MB-28N2390ZTicen Jeffrey L · Chalmers, INBuilt 1962 · S/N M-113N2391WShanahan Jolene D · Upper Lake, CAS/N MB-29N2392LLindell Tom R · Cashmere, WABuilt 1963 · S/N M-237N2392ZVancleave Nate M · Yazoo City, MSBuilt 1962 · S/N M-115N2393JHunter John C · Saint George, UTS/N M-360N2393LPolitte Brian · Festus, MOS/N M-238N2394ZBlue Max Aero Club Ltd · Onalaska, WIBuilt 1962 · S/N M-117N2395WRegistration Pending · Leavittsburg, OHRegistration pendingS/N MB-26N23963Flanegan Charles E Jr · Jonesboro, GABuilt 1977 · S/N MB-827N23966Misbe Darrell James · Pierz, MNBuilt 1977 · S/N M-1996N2396QPhantom Works Flying Club Inc · Saint Peters, MOBuilt 1963 · S/N M-475N2396ZSouthard Toby J · Beaver Dam, KYS/N M-119N23976Brazdys Luke V · Kingman, AZBuilt 1977 · S/N M-1900N23979Grounds Cameron · Sachse, TXBuilt 1977 · S/N M-1908N2397EMaine Instrument Flight · Augusta, MEBuilt 1977 · S/N M-1949N2397LOliver Michael · Palmer, AKS/N M-242N2397WMigliorini William E · Granville, ILBuilt 1966 · S/N MB-27N23982Maine Instrument Flight · Augusta, MES/N MB-831N23986Mcintyre Joel · Greensboro, NCBuilt 1977 · S/N M-1910N2398QLee Kitchell · Shelburne Falls, MABuilt 1963 · S/N M-477N2399LMsd Aviation Of Seymour LLC · Seymour, INBuilt 1963 · S/N M-244N2399WHudson Shayne · Victorville, CABuilt 1966 · S/N MA-13N23FDBas Part Sales LLC · Greeley, COS/N M-1663N23HKMaine Instrument Flight · Augusta, MEBuilt 1977 · S/N M-1911N23PDHigh Sierra Flying LLC · Incline Village, NVBuilt 1976 · S/N MC-408N23SZHaynes Kevin · Pompano Beach, FLBuilt 1966 · S/N M-990N23TDPetrie Claire Trustee · Sparks, NVS/N M-1785N24005Tigerdawg Aviation LLC · Dawson, GABuilt 1977 · S/N M-1920N24006Keiper Mark D · Spring, TXBuilt 1977 · S/N MB-835N24018Schulte David L · State College, PABuilt 1977 · S/N M-1926N24019Orr Stevan J · West Bloomfield, MIBuilt 1977 · S/N M-1924N24020Maine Instrument Flight · Augusta, MEBuilt 1977 · S/N MB-838N24025Birx Ethan S · Piedmont, SCBuilt 1977 · S/N MB-839N24026Albion-Edgerton Flyers Inc · Fort Atkinson, WIBuilt 1977 · S/N M-1922N24027Wilson Dwayne L · Arlington, TXBuilt 1977 · S/N M-1929N24029Bindas Ronald · Georgetown, TXBuilt 1977 · S/N MB-840N24057Macaluso Raymond A · Sweetwater, TNBuilt 1977 · S/N M-1937N2422MGuyll Jay D · Denville, NJBuilt 1963 · S/N M-256N24566Carney Travis · Running Springs, CABuilt 1972 · S/N MC-120N24575Strehlow Eugene E · Hettinger, NDBuilt 1972 · S/N MC-123N24581Air Force LLC · Mount Pleasant, SCBuilt 1972 · S/N MC-130N24588Fischer Paul O · Great Falls, MTS/N MC-157N24589J & N Costa Aircraft LLC · Indian Rocks Beach, FLBuilt 1972 · S/N M-1405
Back to AD 73-20-07 R2