OpenAirDocs.org
AD 73-20-07 R2

Registered aircraft · 1,349

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.

N1000JEagle Mountain Aviation Inc · Owasso, OKBuilt 1966 · S/N M-1000N100RFN100rf Ghost LLC · Burleson, TXS/N MB580N1013PSentinel Services Group LLC · Brooksville, FLS/N MC-428N101CMKuhns Robert M · Wichita, KSBuilt 1973 · S/N MC-146N101FDLakala Aviation Inc · Vicksburg, MIS/N MB-417N103RGTupelo Aeronautics Inc · Tupelo, MSBuilt 1975 · S/N MC358N104DBPryce Gerald · Independence, ORBuilt 1974 · S/N MC-309N104GDFiebiger Mark D · Leesburg, FLBuilt 1970 · S/N MC-49N10NRRobbins Warren N · Chandler, AZBuilt 1968 · S/N M-1165N113FCDistributed Motion LLC · Sandpoint, IDBuilt 1969 · S/N M-1229N113JRGrant Jose A · Jefferson, GABuilt 1975 · S/N M-1615N1150ZLundin Ronny · Brewton, ALS/N MB-582N1167MN1167m LLC · Saint Peters, MOBuilt 1967 · S/N M-1082N117DMApplied Professional Solutions Llp · Jacksonville, FLBuilt 1968 · S/N MB-381N1223TBeech Club LLC · Meadville, PABuilt 1980 · S/N M-2272N128PTaddeo Brent J · Cumming, GABuilt 1979 · S/N M-2220N132PA2 Supersonic LLC · Ann Arbor, MIS/N M-2194N1402LRaskin Michael · Henderson, NVBuilt 1965 · S/N M-791N1406LBrainerd Philip S · Lake Placid, FLBuilt 1965 · S/N M-795N1409LMusketeer Flying Club LLC · Plano, TXBuilt 1965 · S/N M-798N1414LBrown Joseph T · Saginaw, MIBuilt 1965 · S/N M-806N1417LBright David P · Wachapreague, VABuilt 1965 · S/N M-809N1423LMedi Carriers Of Wisconsin Inc · Greenville, WIBuilt 1965 · S/N M-817N1426LMartin Michael D · Decatur, TXBuilt 1965 · S/N M-820N1431LJke Family Fun Entertainment Inc · Searcy, ARBuilt 1965 · S/N M-827N1432LStrydom Cornelis F · Liberal, KSBuilt 1965 · S/N M-826N1434LPost Greg G · Mapleton, KSBuilt 1965 · S/N M-829N1436LDelis Costa Z · Heyburn, IDS/N M-831N1441LSayre Jeremy Q · Livonia, MOBuilt 1965 · S/N M-835N1444LClifton Gary R · Fowler, INBuilt 1965 · S/N M-838N1450LByrd Aviation LLC · Marshfield, MOBuilt 1965 · S/N M-845N1462LSchneider Matthew B · Laughlin Afb, TXS/N M-857N1463LSpears Martin J · Havelock, NCBuilt 1965 · S/N M-858N1465LLoehr Fred A III · Rio Rancho, NMBuilt 1965 · S/N M-862N1466LSteel Randy W · Madras, ORS/N M-880N1468LCh Repairs LLC · Statesboro, GAS/N M-864N1470LAl-Rubaiie Haider A · Fort Worth, TXBuilt 1965 · S/N M-866N1471LLee Michael Jason · Berryville, VABuilt 1965 · S/N M-867N1475L2328 Charlie Victor LLC · Richmond, KYBuilt 1965 · S/N M-871N1477LCooper Jonathan Thomas · Tempe, AZBuilt 1965 · S/N M-874N1478LBaline Lonny R · Harleysville, PABuilt 1965 · S/N M-873N1481LOsceola Aviation Services Inc · Lake City, FLBuilt 1965 · S/N M-879N1487LSheets Mark W · Chugiak, AKBuilt 1965 · S/N M-887N1492LSalzer Mychael D · Coulterville, ILS/N M-892N1498LWheaton Blake L · Atlanta, GABuilt 1966 · S/N M-898N1499LHicks Philip R Jr · Knoxville, TNBuilt 1966 · S/N M-899N149PAelick Joel D · Charlotte, NCBuilt 1979 · S/N M-2237N156ASWallwork Robert R III · Wauna, WABuilt 1976 · S/N MB-805N1570RHall Clarence W Jr · Fayetteville, ARS/N M-1368N163GCBartholomew Terry L · Pavilion, NYBuilt 1973 · S/N M-1469
Back to AD 73-20-07 R2