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.

N18LYRegistered aircraftBuilt 1978 · S/N M-2020N1914LDeakins Glenn F · Ringgold, GAS/N MB-803N1917LEpiphany Airmotive LLC · Frisco, TXBuilt 1976 · S/N M-1817N1918LBurt Christopher James · Leesport, PABuilt 1976 · S/N M-1813N1919BGoldman Lawrence W · Apex, NCBuilt 1976 · S/N MB-794N1920LAverill William B · Lacombe, LABuilt 1976 · S/N MB-792N1920WWilfert Frederick · Springfield, VABuilt 1973 · S/N MB-579N1922LGassi Vito · Levittown, NYBuilt 1976 · S/N M-1819N1926WSengstock Frank W · Traverse City, MIBuilt 1973 · S/N MB-587N1927LCarrillo Isaias D · Wasilla, AKBuilt 1976 · S/N MB-796N1927WAltitude Aviation Services LLC · Mountain Home, IDBuilt 1973 · S/N MB-609N1929LIngstad Eric Charles · Lakewood, CABuilt 1976 · S/N MC-416N1930LMaclean Milton A III · Rossmoor, CAS/N M-1828N1931WDelgado Alan J · Auburn, GABuilt 1973 · S/N MB-589N1933LN1933l Ltd · Streetsboro, OHBuilt 1976 · S/N MC-417N1933WHanson Garrick D · Clayton, NCS/N MB-597N1935LBlais Aviation Services LLC · Frisco, TXBuilt 1976 · S/N MB-797N1936LAnderson Brian E · Edmond, OKBuilt 1976 · S/N M-1846N1936WDelgatto Robert G · Bellingham, WAS/N MB-599N1937LLuks George J · Crescent City, CABuilt 1976 · S/N MC-419N1937WMcculloch Jordan · Enfield, CTBuilt 1973 · S/N MB-600N1938LTexas Environmental Training & Compliance LLC · Frost, TXBuilt 1976 · S/N MC-414N1939LCook Kenneth T · Danielson, CTBuilt 1976 · S/N MC-418N1940LClark Sean William · Shelby, NCBuilt 1976 · S/N M-1808N1942LN1942l LLC · Wichita, KSBuilt 1976 · S/N MC-415N1943LBeech Shuttle LLC · Dawson, GABuilt 1976 · S/N M-1830N1945LN1945l LLC · Cincinnati, OHBuilt 1976 · S/N M-1821N1945WHunhoff Mark B · Yankton, SDBuilt 1973 · S/N MB-603N1948LJohnson Charles D · Ligonier, PABuilt 1976 · S/N M-1833N1950LRodenbaugh Alan G · Tulsa, OKBuilt 1976 · S/N M-1832N1950WLight Sport And Beyond LLC · Carville, LABuilt 1973 · S/N MB-612N1951WHoover Ryan B · Le Claire, IABuilt 1973 · S/N MB-615N1953LWyatt Shawn D · Fort Worth, TXBuilt 1976 · S/N MC-421N1955WLakeview Farm Foundation Corp · Yukon, OKBuilt 1973 · S/N MB-619N1956LMeisinger Darrell G · Claremore, OKBuilt 1976 · S/N M-1816N1956WGasaway Chad D · Middleton, IDS/N MB-620N1957LSmith Joseph M · Ames, IABuilt 1976 · S/N MC-423N1958LTalamini Paul J · Franklin, MABuilt 1976 · S/N M-1840N1960LButler David · Palos Park, ILBuilt 1976 · S/N MC-422N1961WMeier Monte M · Grove, OKS/N MB-624N1962LDelacantera Eduardo · New Castle, DEBuilt 1976 · S/N M-1838N1963FSarna David E · Manawa, WIBuilt 1963 · S/N M-541N1963WHuertas Andrew C · Tujunga, CABuilt 1973 · S/N MB-627N1966WSale Reported · Southaven, MSSale reportedS/N MB-630N1967WNovotny Andrew T · Los Angeles, CABuilt 1974 · S/N MB-656N1974WObannon Michael Verlin · Apple Valley, CAS/N MB-633N1979WLeedom David · Center Point, IAS/N MB-658N1983LJeffries Susan M · Clover, SCBuilt 1976 · S/N M-1841N1986LPhillips Alan K · Junction City, ORBuilt 1976 · S/N M-1843N1987LBig Bend Community College · Moses Lake, WABuilt 1976 · S/N MB-806
Back to AD 73-20-07 R2