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.

N7998LMarkham Gerald W · Kodiak, AKBuilt 1966 · S/N MA-161N8015RSchier Ronald W Jr · Mount Pleasant, SCBuilt 1970 · S/N MC-54N8016RPomeroy Sue K · Kemp, TXS/N MC-6N8017RReynolds Carl T · San Marcos, TXBuilt 1970 · S/N MC-15N8022RBlackwing Aviation LLC · Flower Mound, TXBuilt 1970 · S/N MC-14N8025RGaboury Michael J · Two Harbors, MNBuilt 1970 · S/N MC-17N8028RBorgers Thomas R · Palmyra, NJBuilt 1970 · S/N MC-24N8032RAllen Steven M · Hackett, ARBuilt 1970 · S/N MC-21N8036RBetty'S Township LLC · Gretna, LABuilt 1970 · S/N MC-53N8038RSale Reported · Oklahoma City, OKSale reportedBuilt 1970 · S/N MC-33N8043RPat Brown Aviation LLC · Dodge Center, MNBuilt 1970 · S/N MC-37N8044RCobb Gerald E · Jacksonville, FLBuilt 1970 · S/N MC-38N8052RNwa Air LLC · Tontitown, ARBuilt 1970 · S/N MC-47N8062RMills River Publishing Co · Rushville, INBuilt 1970 · S/N M-1300N8064RN8064r LLC · Kalispell, MTBuilt 1970 · S/N MB-492N819BABig Bend Community College · Moses Lake, WABuilt 1977 · S/N MB-866N81SHSharff Steven T · Georgetown, DEBuilt 1978 · S/N M-2095N823PPPsm Aviation LLC · Lewes, DEBuilt 1975 · S/N M-1650N824PJDowney Joseph E · University City, MOBuilt 1976 · S/N M-1867N825ALN825al LLC · Freeport, NYBuilt 1969 · S/N M-1187N830ADb-Gbr LLC · Sarasota, FLBuilt 1962 · S/N M-36N8311FGregoire Brandon James Ernst · Orlando, FLBuilt 1969 · S/N M1280N831KTPilot Network Flyers LLC · Bastrop, TXBuilt 1974 · S/N M-1548N833DMitchell Darrin · Tabor, IABuilt 1970 · S/N MC-12N834KTChambers Garland M · Roanoke, VABuilt 1974 · S/N M-1512N836KTAirhawks Flying Club · Eastsound, WABuilt 1978 · S/N M-2047N837KTBeechsun LLC · South Jordan, UTS/N M-2076N839KTMiller Aviation Group LLC · Coon Rapids, MNBuilt 1982 · S/N M-2352N83VCDoke Ken L · Winton, CABuilt 1971 · S/N MC-97N842KZPowell Michael Brandon · Murfreesboro, TNBuilt 1983 · S/N M-2367N8462NBoskind Richard · Indialantic, FLBuilt 1968 · S/N MA-321N852TStudarus John E · Sacramento, CABuilt 1974 · S/N M-1528N862KMSiebold Daniel L · Rhinebeck, NYBuilt 1979 · S/N M-2175N86ZZSchermer Jacob D · Denver, COBuilt 1966 · S/N MA-85N8704MDodson International Parts Inc · Rantoul, KSBuilt 1963 · S/N M-488N8708MLetch Clinton J · Wyoming, MNBuilt 1963 · S/N M-492N87140Cgl Media LLC · Jupiter, FLBuilt 1975 · S/N MC-335N8714MCole Leonard O III · Sunrise Beach, MOS/N M-498N8716MWilliams Excavating Inc · Partlow, VABuilt 1963 · S/N M-500N8718MGilson David R · New Port Richey, FLBuilt 1963 · S/N M-502N8720MHulme Aviation LLC · Gilbert, AZBuilt 1964 · S/N M-509N8724MKleiber Timothy D · Independence, KSS/N M-513N8725MFix Janice M · Crete, NEBuilt 1963 · S/N M-514N8732MMusketeer Mike LLC · Yukon, OKBuilt 1963 · S/N M-522N8741MDodson International Parts Inc · Rantoul, KSBuilt 1963 · S/N M-529N8743MRoberts Randy · Clayton, NMBuilt 1963 · S/N M-530N8747MSmith Peter · Liberty Lake, WABuilt 1963 · S/N M-535N8748MTorres Michael Anthony · Brownsboro, TXBuilt 1964 · S/N M-536N8755MTraver Ronald D · Lantry, SDS/N M-543N8756MMutschler George R · Paradise Valley, AZS/N M-544
Back to AD 73-20-07 R2