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.

N2219LVasiliou Adamos C · Burtonsville, MDBuilt 1976 · S/N M-1880N2220LLegitimate Business LLC · Las Vegas, NVS/N MC-445N2224LMeckel Raymond T · Rockport, TXBuilt 1976 · S/N M-1875N222BBMatz Jeremy L · Toston, MTS/N M-250N222WGWalker Scott Aviation LLC · Woodward, OKBuilt 1978 · S/N M-2092N2232LDodson Jack Yii · Douglasville, GABuilt 1976 · S/N MB-819N2235LCarter Dale · Riga, MIBuilt 1976 · S/N M-1905N2237LDeatherage Christina M · Goshen, OHBuilt 1976 · S/N M1885N2239LGoss Andrew M · Clio, MIBuilt 1976 · S/N MB-821N2242LDeyoung Jeffrey Scott · Johnstown, COBuilt 1976 · S/N M-1891N2243LMaine Instrument Flight · Augusta, MEBuilt 1977 · S/N M-1890N2245LShirley Joseph P · Branson West, MOS/N MB-823N2247LLonergan Michael F · Venice, FLBuilt 1977 · S/N M-1894N2248LBeck Stephan · Elko, NVBuilt 1977 · S/N M-1895N2252LEaton David B Jr · Leicester, MABuilt 1977 · S/N M-1897N2259LVelte Jerrid · Grand Haven, MIBuilt 1976 · S/N M-1898N22711Big Bend Community College · Moses Lake, WABuilt 1977 · S/N MB-865N228WTHowland James · Grantsville, UTBuilt 1971 · S/N MC-90N229FCOregon Mustang LLC · Brandon, ORBuilt 1972 · S/N M1369N22PALubo Aviation LLC · Gastonia, NCBuilt 1974 · S/N MC-223N2300JRadosevich Michael K · Albuquerque, NMBuilt 1963 · S/N M-246N2300LAv8n Idaho LLC · Greenleaf, IDBuilt 1962 · S/N M-112N2301LMuskrat Flying Club LLC · Orlando, FLBuilt 1963 · S/N M-122N2301ZRegistration Pending · Maumee, OHRegistration pendingBuilt 1962 · S/N M-4N2302ZJohnson Melvin L · Toney, ALBuilt 1962 · S/N M-5N2303QVan Hoosen Ronald L · Goldsby, OKBuilt 1963 · S/N M-369N2303ZBeech Aero Club · Ashburn, VABuilt 1962 · S/N M-6N2304LJohnson Diversified LLC · East Lansing, MIBuilt 1963 · S/N M-125N2304QAviation Business Corp · Saint Louis, MOBuilt 1963 · S/N M-356N2305WRobison Charles R · Big Spring, TXBuilt 1965 · S/N M-907N2306QVanderwielen Joseph M · Neenah, WIBuilt 1963 · S/N M-358N2306WFreeman Darrell · Tacoma, WABuilt 1965 · S/N M-908N2307LZamel Andre · Sunrise, FLBuilt 1962 · S/N M-128N2307QWinters Jeffrey · Olathe, KSBuilt 1963 · S/N M-367N2307WMitchell Kenneth M · Saint Jacob, ILS/N M-909N2308JMcgary Blaine J · Pasco, WABuilt 1963 · S/N M-259N2308WLach John J · Austin, TXBuilt 1965 · S/N M-910N2309QBorja Nicholas F · Freeburg, ILBuilt 1963 · S/N M-373N2310JRegistration Pending · Aberdeen, SDRegistration pendingBuilt 1963 · S/N M-261N2310QPeterson Kevin · Roseville, CABuilt 1963 · S/N M-374N2311QHagy Thomas Lee · Abingdon, VABuilt 1963 · S/N M-375N2312LSumerau Robert L IV · Lexington, SCBuilt 1963 · S/N M-138N2312QMiller Kevin · Dover, DES/N M-376N2312ZDfr LLC · Giltner, NEBuilt 1962 · S/N M-35N2314JAce Aviation Seminars LLC · Armuchee, GABuilt 1963 · S/N M-377N2314LSale Reported · Brunswick, OHSale reported, canceledBuilt 1963 · S/N M-140N2314WHansen Robert J · Bainbridge, INBuilt 1965 · S/N M-915N2316LCarrigan Sean P · Slidell, LABuilt 1963 · S/N M-142N2317LAdamiak Jeffrey · Mount Laurel, NJBuilt 1963 · S/N M-143N2318ZCrosson Ronda L · Corinth, MEBuilt 1962 · S/N M-45
Back to AD 73-20-07 R2