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.

N2319WWinstead Walley K · Leavenworth, KSBuilt 1965 · S/N MB-1N2320WThompson Robert J · Irwin, PABuilt 1966 · S/N MB-2N2321LHill Tim C · Savannah, GABuilt 1963 · S/N M-147N2321QHarkness James D · Locust Grove, VABuilt 1963 · S/N M-385N2321WBarre Fly Aviation LLC · Bryan, TXBuilt 1965 · S/N M-920N2324L2324l LLC · Sharpsburg, GABuilt 1963 · S/N M-150N2324WTolhurst Bruce Clinton · Silver City, NMBuilt 1965 · S/N MA-1N2325QPoitras Don T · Cary, NCBuilt 1963 · S/N M-389N2328ZEagle Richard R · Catawba, NCBuilt 1962 · S/N M-31N2329LJessup Gordon J R · White Plains, NYBuilt 1963 · S/N M-160N2329WSwonke Adam J · Spring, TXBuilt 1966 · S/N MB-20N2330WLarsen Bo · Portland, ORBuilt 1965 · S/N M-927N2331JTechnical Education Services Inc · Virginia Beach, VABuilt 1963 · S/N M-284N2331WEmpire Contractors · Shelby, MIBuilt 1965 · S/N M-928N2331ZDovetail Aviation LLC · Saint George, UTBuilt 1962 · S/N M-41N2333QLawarch LLC · Hollywood, FLBuilt 1963 · S/N M-399N2333WVillage Of Choudrant · Choudrant, LABuilt 1965 · S/N M-932N2334LDupuy Christopher R · Pass Christian, MSBuilt 1963 · S/N M-165N2334QBledsoe Timothy Ronald Jr · Woodstock, GABuilt 1963 · S/N M-396N2335JDank Noah S · Jacksonville, FLS/N M-291N2335WWhite Traver O · Inkom, IDBuilt 1965 · S/N M-931N2336LBerry Kenneth W · Amarillo, TXBuilt 1963 · S/N M-167N2336QRodenbaugh Alan G · Tulsa, OKS/N M-401N2336WFrankenfield Francis R · Quakertown, PABuilt 1966 · S/N M-933N2337LAbitia Alberto · Phoenix, AZBuilt 1963 · S/N M-168N2337QFleener Michael C · Livingston, TXS/N M-402N2338QWinkels Jeffrey P · Candy, MNBuilt 1963 · S/N M-403N2340LRegistration Pending · San Antonio, TXRegistration pendingBuilt 1962 · S/N M-171N2340QRegistration Pending · Lewisville, TXRegistration pendingBuilt 1963 · S/N M-411N2341WSteele Benjamin A · Eugene, ORS/N M-940N2342LWilliams James W · Brush Prairie, WABuilt 1963 · S/N M-173N2343LBailey Paul W II · Hilton Head, SCBuilt 1963 · S/N M-174N2343WRogers Allen F · Gilbert, WVBuilt 1965 · S/N M-942N2344LSpargo Lyle R · Tonopah, AZBuilt 1963 · S/N M-175N2345LD&S Development LLC · Spring, TXS/N M-177N2345QPrunier Phillip M · Kokomo, INBuilt 1963 · S/N M-416N2346QBurt Marcus D · Pendleton, ORS/N M-425N2346WRaynor Jason M · Elizabeth City, NCS/N M-944N2346ZSoutheast Equipment LLC · Sheridan, WYS/N M-65N2347QBefumo Joesph M · Manchester, CTS/N M-451N2347ZZaitsev Saba A · Brooklyn, NYBuilt 1962 · S/N M-59N2348JArensmeyer Daniel D · Weybridge, VTBuilt 1963 · S/N M-303N2348ZHerrick Herbert D · Flint, MIBuilt 1962 · S/N M-60N2349QLedford Russell R III · Swansea, SCBuilt 1963 · S/N M-417N2349WPax Theodore Llewellyn · Fall Creek, WIBuilt 1966 · S/N M-947N2349ZUnderwood Richard R · Armuchee, GABuilt 1962 · S/N M-61N2351LVlazny Stephen F · Divide, COBuilt 1963 · S/N M-188N2351WWebb Brian C · Owasso, OKBuilt 1966 · S/N M-949N2352LHaag Harvey E · Clearfield, PABuilt 1963 · S/N M-189N2352WAlligator Air Transport LLC · Fort Lauderdale, FLS/N M-950
Back to AD 73-20-07 R2