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.

N1987WWood Wilbur L · Alachua, FLBuilt 1974 · S/N MB-663N1988LPortal Planes LLC · Knoxville, TNS/N M-1842N1989LTriple D LLC · Scotland, PAS/N M-1847N1990WObsidian Defense LLC · Tampa, FLBuilt 1974 · S/N MB-668N1991LHarvatine Francis J · Sykesville, MDBuilt 1976 · S/N MC-431N1991WGmm Records Inc · Big Pine Key, FLBuilt 1974 · S/N MB-673N1992WMcdonald Gregory S · Mena, ARS/N MB-657N1996WMelton Joshua D · Mitchell, INBuilt 1974 · S/N MB-677N1998LAyala Gerardo · San Antonio, TXBuilt 1976 · S/N M-1854N19NHLaquadra Gregory John · North Liberty, IABuilt 1975 · S/N MB-740N19NTHall Karl A · Colorado Springs, COBuilt 1974 · S/N MB-710N2008TDean John W · Greentown, INBuilt 1978 · S/N M-2061N2009DSundowner 2009d LLC · La Place, LABuilt 1978 · S/N M-2053N200AGDively Daniel R · Friedens, PABuilt 1967 · S/N MA-285N200RFRushin William J · Greenwood, INBuilt 1973 · S/N M-1457N2010AMaine Instrument Flight · Augusta, MEBuilt 1978 · S/N M-2066N2010LTec Consulting LLC · Farmingdale, MEBuilt 1978 · S/N M-2058N20120Bennett Robert J Jr · Minneapolis, MNBuilt 1978 · S/N M-2071N2012KMaine Instrument Flight · Augusta, MEBuilt 1978 · S/N MB-901N2012NAirhawks Flying Clup · Eastsound, WABuilt 1978 · S/N M-2068N2013AMusketeer LLC · Fayette, ALBuilt 1978 · S/N MB-902N2013NSimply Living LLC · Fort Myers, FLBuilt 1978 · S/N M-2070N2041LSlik Air LLC · Topeka, KSBuilt 1976 · S/N M-1849N2043LBrown Dennis · Moncks Corner, SCBuilt 1976 · S/N M-1856N2044LLeitner Jay T · Hurst, TXBuilt 1976 · S/N MC-440N2046LHemby Clint L · Bonham, TXBuilt 1976 · S/N MC-433N2047ABig Bend Community College · Moses Lake, WABuilt 1978 · S/N MB-899N2048ABig Bend Community College · Moses Lake, WABuilt 1978 · S/N MB-904N2048LDp Network LLC · Coconut Creek, FLBuilt 1976 · S/N M-1857N204PWFreeman Adam J · Long Beach, CABuilt 1976 · S/N M-1844N2050LMolak Marc E · Austin, TXBuilt 1976 · S/N M-1859N2051LParker Joyce A · Topeka, KSBuilt 1976 · S/N MC-436N2053LMaine Instrument Flight · Augusta, MEBuilt 1976 · S/N MB-812N2054LDillon Roby · Rockport, INBuilt 1976 · S/N M-1860N2056LHodges Fred Lloyd Jr · Ellabell, GABuilt 1976 · S/N MC-435N2057LWilson Michael Joseph · Los Banos, CABuilt 1976 · S/N M-1861N2059LBig Bend Community College · Moses Lake, WABuilt 1976 · S/N MB-808N2062LJohnson Robert A · Crawfordville, FLBuilt 1976 · S/N M-1863N2063LPeterson Eric T · Port Townsend, WABuilt 1976 · S/N MB-809N2063XKimbrough Paul E Jr · Saint Cloud, FLS/N M781N2067LShort Final Aviation LLC · Siloam Springs, ARBuilt 1976 · S/N M-1866N206TVHpfm Inc · Vermillion, SDBuilt 1974 · S/N MB-660N2071BTrulson Gary S · Edgerton, WIBuilt 1978 · S/N M-2099N20748Registration Pending · Bethesda, MDRegistration pendingBuilt 1978 · S/N M-2077N2075LThompson Talley · Burgaw, NCS/N M-2081N2076AThomas George P Jr · Woodstock, VTBuilt 1978 · S/N M-2054N2077AN2077a LLC · Lewes, DEBuilt 1978 · S/N M-2082N2077CBudarf James Philip · Graham, TXBuilt 1978 · S/N M-2074N2101WUtset Anthony · Okeechobee, FLBuilt 1973 · S/N M-1471N2103WGoold Michael D · Fort Worth, TXBuilt 1973 · S/N M-1450
Back to AD 73-20-07 R2