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.

N5115RMichael D Woods LLC · Harleton, TXBuilt 1977 · S/N M-1974N5116RSajdak Brian Christopher · Hernando, MSBuilt 1979 · S/N M-2164N5125MSampson Alan T · Indianapolis, INBuilt 1978 · S/N M-2030N5137MFuture Pilots Of America Flight Academy LLC · Baxley, GABuilt 1978 · S/N MB-890N5154MTx Waste Ventures LLC · Caddo Mills, TXBuilt 1978 · S/N M-2037N5155MGreenbirds LLC · Apopka, FLBuilt 1978 · S/N M-2038N5158MLenox Jeffrey D · Livingston, TXBuilt 1978 · S/N M-2042N5159MThunder Wings LLC · Wilmington, DEBuilt 1978 · S/N M-2041N5161MSamora Bobby · Corona, CABuilt 1978 · S/N M-2039N5162MCorcoran Thomas A · Braintree, MABuilt 1978 · S/N M-2040N5167MTuggle Casey · Chattanooga, TNS/N M-2043N5170MWheeler David A · York, PABuilt 1978 · S/N M-2050N518APWilliams Brian K · Mattituck, NYS/N M-1869N5204MZenteno Nelson Jr · Winter Haven, FLBuilt 1978 · S/N MB-878N5214MS & M LLC · Nauvoo, ALBuilt 1978 · S/N M-2013N5216MChu Philip · Surprise, AZBuilt 1978 · S/N M-2010N5226MTrader Robert D · Madison, INBuilt 1978 · S/N M-2014N5255MFlesher William Robert Jr · Gainesville, GABuilt 1978 · S/N M-2019N5289MHardy Caitlin M · Woodinville, WABuilt 1978 · S/N M-2021N5294Brown Kevin Lee · Broseley, MOBuilt 1971 · S/N MC-94N52AAWebster Patrick Edward · Elk Grove, CABuilt 1975 · S/N MB-760N52LVAltair Aircraft LLC · Gainesville, FLBuilt 1971 · S/N MC-22N52RARennenkampf Erik J · Columbia, MDBuilt 1974 · S/N M-1626N5300PMrozinski Robyn K · Hugo, MNS/N M-1628N53EMChecker Aircraft LLC · Wilmington, DEBuilt 1976 · S/N MC-395N5409MJackson David B · Mansfield, TXBuilt 1978 · S/N M-2025N5417MGreenhill Daniel J Jr · San Tan Valley, AZBuilt 1978 · S/N M-2022N5425MWong Alex · Hillsborough, CABuilt 1978 · S/N M-2026N546DKMcghee Billy H · Deland, FLS/N MB-616N555CCDavis Donel · Hollis, NYBuilt 1974 · S/N M-1589N555RSR&M Aviation LLC · Austell, GABuilt 1963 · S/N M-412N5650SOliver Jonathan · Maryville, TNBuilt 1966 · S/N MA-68N5653SSellers Alton H · Savannah, GABuilt 1966 · S/N MA-79N5654SWilcox Ryan · Brookland, ARBuilt 1966 · S/N MA-80N5660SRussek Ron · Cleburne, TXBuilt 1966 · S/N MB-101N5667SParsons John C · Wichita, KSBuilt 1966 · S/N MB-106N5671SMusketeer Aviation Inc · Potterville, MIBuilt 1966 · S/N MB-110N5672SHogan Jacob A · Canon City, COBuilt 1966 · S/N MA-82N5679SWinters Kevin L · Nine Mile Falls, WABuilt 1966 · S/N MB-122N5681SHillcrest Aviation LLC · Midland, TXBuilt 1966 · S/N MA-91N5685SGreen Taylor · Olympia, WABuilt 1966 · S/N MB-125N5687SRobbins Warren N · Chandler, AZBuilt 1966 · S/N MB-127N5688STanneberg Larry · Coulee City, WABuilt 1966 · S/N MB-128N5693SChupp David · Abbeville, SCBuilt 1966 · S/N MA-94N5698SNewell Gary A · Colmar, PABuilt 1966 · S/N MA-102N5754VWeiser Steven Clark · Hutto, TXBuilt 1966 · S/N MA-20N5755VArnold Alan Dale · Glenwood Springs, COBuilt 1966 · S/N MA-16N5758VNelson Mike R · Philip, SDS/N MB-41N5766VBruce James W · Searcy, ARBuilt 1966 · S/N MB-50N5768VSkyzure LLC · Chelsea, MIBuilt 1966 · S/N MA-21
Back to AD 73-20-07 R2