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.

N6985RWard Chad E · Paducah, KYBuilt 1975 · S/N MC-326N6986QBennett Donald M · Burley, WABuilt 1968 · S/N MA-317N6987QSmith Casey W · Houlka, MSBuilt 1968 · S/N MB-336N6989QHumphrey Bobby E · Dandridge, TNBuilt 1968 · S/N M-1096N6989RMoran Dennis E · Waverly, PABuilt 1975 · S/N MC-331N6992RBanana River Aviation LLC · Merritt Island, FLBuilt 1975 · S/N MC-328N6994QGronewold Dale A · Gothenburg, NEBuilt 1968 · S/N M-1101N6995RFeher Tara A · Chesapeake, VABuilt 1975 · S/N M-1623N6997RTimmons Tracy · Jacksonville, ILBuilt 1975 · S/N M-1745N6999QBas Part Sales LLC · Greeley, COBuilt 1968 · S/N M-1106N707GDw Forensics LLC · Dallas, TXS/N M-2248N7117EDowell Cameron C · Solomons, MDBuilt 1974 · S/N MC-278N720NWNunez Frank · Orlando, FLBuilt 1978 · S/N M-2079N721RTAbbott R Barry · Sterling, AKBuilt 1968 · S/N M-1170N722FCostello Robert N · Ignacio, COBuilt 1966 · S/N M-981N723SSmaltz David I · Newmanstown, PAS/N M-1384N727WMMd Air Ops LLC · High Springs, FLS/N MB-799N731RTWarndahl John · Kyle, TXBuilt 1968 · S/N M-1172N7340TThunderbird Flyers LLC · Steamboat Rock, IABuilt 1965 · S/N M-860N739JGrace Mollie B · Batesville, ARBuilt 1978 · S/N M-2091N73MDReed Henry J · Jacksonville, NCS/N MB-226N7419WBaker Terry · Mesa, AZBuilt 1977 · S/N M-1973N757APMcnamara William T · Memphis, TNBuilt 1972 · S/N MC-122N75JGWhisenant Roy H II · Poway, CABuilt 1975 · S/N M-1716N7607RScott Mark G Jr · Manvel, TXBuilt 1969 · S/N M-1234N7611BCason Thaddeus D · Polk City, FLS/N M-1399N7612RSamper Aviation LLC · Easton, PABuilt 1969 · S/N M-1235N7614RKull Phillip G · Monroe, MIBuilt 1969 · S/N M-1237N7616RMalcom Brett W · Warner Robins, GABuilt 1969 · S/N M-1239N7623RAdamiak Jeffrey · Mount Laurel, NJS/N M-1246N7626RBasinger Weston P · Alexandria, VABuilt 1969 · S/N MA-348N7627RReising Douglas C · Caseyville, ILBuilt 1969 · S/N M-1248N7628RWilson Rodney C · Flagstaff, AZBuilt 1969 · S/N M-1249N7641RDossey Kevin L · Oroville, CABuilt 1969 · S/N MB-432N7648RJohnson Jerome L · Victorville, CABuilt 1969 · S/N MB-457N7653RBeech Aviators Of Houston LLC · Kingsland, TXBuilt 1969 · S/N MA-353N7654RBeech C23 LLC · Galesburg, KSBuilt 1969 · S/N M-1285N7656RRobinson Lewis S · Irmo, SCBuilt 1969 · S/N M-1260N7659RThomas Chris C · Mansfield, OHS/N M-1263N7660RWare Joshua A · Inwood, WVBuilt 1969 · S/N M-1282N7669RSpence Lisa A · Houston, TXBuilt 1969 · S/N M-1265N766RCos LLC · Monument, COBuilt 1971 · S/N M-1298N7670RMescher John A · Coldwater, OHBuilt 1970 · S/N MC-58N7671RBeloiu Matei A · Fort Jones, CABuilt 1969 · S/N M-1268N7673RGiles Dwight L · Greeley, COBuilt 1969 · S/N M-1270N7675RKline John C · Wolcottville, INBuilt 1970 · S/N M-1297N7677RAlpha Bravo Charlie 1 Corp · Houston, TXS/N M-1288N7679RSmith Melissa R · Atlanta, ILS/N MA-359N7680RPotter Steven R · Grapevine, TXS/N MB-502N7682RTrull Stephen G · Golden Valley, MNBuilt 1969 · S/N MB-452
Back to AD 73-20-07 R2