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.

N2353JWings Of History Air Museum · San Martin, CABuilt 1963 · S/N M-311N2354QWallace Willie B III · Donalsonville, GABuilt 1963 · S/N M-422N2355QKreek Karl · Glasgow, KYBuilt 1963 · S/N M-423N2356JN2356j LLC · Winchester, VABuilt 1963 · S/N M-314N2356ZOlson David C · Emmetsburg, IAS/N M-69N2357LLords Assets LLC · Columbus, OHBuilt 1963 · S/N M-195N2358LSimpson Timothy A · Niles, MIBuilt 1963 · S/N M-196N2358QBertrand Jason A · Seattle, WAS/N M-427N2358WBeyer Kaleb A · Danville, ARBuilt 1966 · S/N M-955N2358ZBrinegar Matthew D · North Tustin, CABuilt 1962 · S/N M-70N2359QBean Glen A · Damascus, ORS/N M-428N2361LUnderwood Richard R · Armuchee, GABuilt 1963 · S/N M-190N2361WGaffney Richard J · Richmond Hill, GABuilt 1966 · S/N M-958N2361ZPitts Randy A · Waynesboro, MSBuilt 1962 · S/N M-73N2362LWatkins William V · Porter, OKBuilt 1963 · S/N M-176N2362QStiers Randell E · Bunker Hill, INBuilt 1963 · S/N M-435N2362ZFlowers Jesse S · Moscow, IDBuilt 1962 · S/N M-76N2363ZBlack Thomas L · Springtown, TXBuilt 1962 · S/N M-77N2364JSwenson Roger A · Pahrump, NVBuilt 1963 · S/N M-322N2365LPrue Paul E · Golden, COBuilt 1963 · S/N M-201N2365QGonzalez Lazaro · Springfield, NJS/N M-439N2366JPhillips Michael L · Mays Landing, NJS/N M-324N2366ZAerotyne International LLC · Prattville, ALBuilt 1962 · S/N M-87N2368QWagner Steve · Prescott, AZBuilt 1963 · S/N M-448N2368ZJpk Aviation LLC · Bowling Green, KYBuilt 1962 · S/N M-89N2369JSchemenauer Phillip · Bristol, INBuilt 1963 · S/N M-327N236AWFischer Michael N · Manito, ILS/N M-946N2370QBrandt James R · Caro, MIBuilt 1963 · S/N M-443N2371WSpaich Brad G · Mcpherson, KSBuilt 1966 · S/N MB-9N2372JSea Serpent Tours Inc · Saint Augustine, FLS/N M-336N2372QBlack Stephen L · Winterset, IABuilt 1963 · S/N M-445N2372WHulme Aviation LLC · Gilbert, AZBuilt 1966 · S/N MB-10N2372ZMills Zachary J M · Belfair, WABuilt 1962 · S/N M-75N2373WFayettenam Aero LLC · Laurinburg, NCBuilt 1966 · S/N MA-3N2374ZSale Reported · Fort Worth, TXSale reported, canceledBuilt 1962 · S/N M-98N2375LEdgren Alan J · Punta Gorda, FLBuilt 1963 · S/N M-223N2375QTaxes Suck LLC · Orlando, FLBuilt 1963 · S/N M-449N2375ZMorrissett Jay Dean · Bumpass, VABuilt 1962 · S/N M-99N2376JWinstead Jonathan M · Griffin, GABuilt 1963 · S/N M-339N2376LRbg Aviation LLC · Middleburg, FLBuilt 1963 · S/N M-212N2376QEisenmann James R · Fort Worth, TXBuilt 1963 · S/N M-450N2377LBarnes Matthew · Cost, TXS/N M-217N2378ZMugleston Tim H · Waldport, ORBuilt 1962 · S/N M-102N23824American Lighthouse Transportation Inc · Dry Ridge, KYBuilt 1977 · S/N M-1999N2382LRadloff Nicholas R · Fort Atkinson, IABuilt 1963 · S/N M-222N23830Klosterman Jack L · Cincinnati, OHBuilt 1978 · S/N M-2002N2383WMcclure Miles · Vancouver, WAS/N MB-18N2384JEdwards Isaac J · Glen Ellyn, ILBuilt 1963 · S/N M-342N2384QTailwind Ventures LLC · Three Rivers, MIS/N M-464N23851Giordano Kim O · Foxboro, MABuilt 1978 · S/N M-2006
Back to AD 73-20-07 R2