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.

N6046WFamily & Friends Flying LLC · Livonia, MIS/N M-2172N6047JKimplex Co LLC · Port Charlotte, FLBuilt 1979 · S/N M-2174N60501Big Bend Community College · Moses Lake, WABuilt 1979 · S/N M-2138N60503Big Bend Community College · Moses Lake, WABuilt 1979 · S/N M-2170N6052NRegistration Pending · Las Vegas, NVRegistration pendingBuilt 1968 · S/N M-1159N6053NErickson Robert · Otis Orchards, WABuilt 1968 · S/N M-1160N6054NPees Philip G · Concord, NCBuilt 1968 · S/N M-1161N6066NPacific Union College · Angwin, CABuilt 1968 · S/N MB-398N6067NGustavson Allan R Jr · Tonopah, AZBuilt 1968 · S/N MB-391N6068NVan Steenburgh Owen Christopher · Manitowoc, WIBuilt 1968 · S/N MB-392N606ERHansen Justin L · St George, UTS/N MB-397N6070NKnott Donnie W · Milan, TNBuilt 1968 · S/N M-1164N6072NDilecce Joseph · Sarasota, FLBuilt 1969 · S/N M-1209N6073NRozinka Jay C · River Falls, WIBuilt 1968 · S/N M-1166N6074NParlog Roy H · Irwin, PABuilt 1968 · S/N M-1167N6077NKrig Marie · Seattle, WABuilt 1969 · S/N M-1202N6080NHuberty Gregory N · Circle Pines, MNBuilt 1969 · S/N M-1204N6081NTamim Shekaib · Tracy, CABuilt 1968 · S/N M-1174N6082NNewberg G Edward · Haines City, FLBuilt 1969 · S/N M-1175N6084NHilpertshauser David J · Sheboygan, WIBuilt 1969 · S/N M-1184N6085NShuffield Brian D · Oregon House, CAS/N M-1177N6094NAmerican Aviator LLC · Arlington, TXBuilt 1968 · S/N MA-336N6094RBoston Executive Helicopters LLC · Norwood, MABuilt 1979 · S/N M-2209N6098NRegistered aircraftBuilt 1968 · S/N MB-395N6107NMaclean Rex G · Covington, WABuilt 1969 · S/N M-1192N6110XVitale Matthew W · Lithia Springs, GAS/N M-2347N6113NKrabill Ronald D · Halsey, ORBuilt 1969 · S/N M-1199N6114NSabourin David R · Draper, UTBuilt 1969 · S/N M-1200N6123NPfisters Flying Wahine · Waialua, HIBuilt 1969 · S/N MB-409N6124NPacific Coast Air Museum · Santa Rosa, CABuilt 1968 · S/N MB-410N6133NSiesta Key LLC · Wilmington, DES/N M-1216N6134NChris Bellinger Dvm LLC · Newalla, OKS/N MA-345N613AWMoreno Carlos · Ocala, FLBuilt 1966 · S/N M-939N6143NTorikawa Domingojason K · Ewa Beach, HIBuilt 1969 · S/N MB-414N6144NRegistration Pending · Benton, ARRegistration pendingS/N MB-415N6148NAll-In-Aviation LLC · Paragould, ARBuilt 1969 · S/N M-1225N6149NZappa Tyler M · Hudson, FLBuilt 1969 · S/N M-1226N614PWAlpha Victor 8 LLC · Broken Arrow, OKBuilt 1982 · S/N M-2364N61526Mata Joseph F · E Setauket, NYBuilt 1982 · S/N M-2348N616KCRegistration Pending · Conway, ARRegistration pendingBuilt 1975 · S/N M-1726N6183XCanipe Kendall L · Shelby, NCBuilt 1981 · S/N M-2350N6283GBoehler Michael J · Sharon Springs, NYBuilt 1982 · S/N M-2353N62874Arneson David Rolf · Montevideo, MNBuilt 1982 · S/N M2354N62954Big Bend Community College · Moses Lake, WABuilt 1982 · S/N M-2355N6334UManson Don H · Saint Augustine, FLS/N M-2356N6349CAmmons Gearey L · Marion, ARBuilt 1982 · S/N M-2371N63503Criscenzo Philip A · Port Orange, FLBuilt 1982 · S/N M-2359N6362USundowner Holdings LLC · Mayflower, ARBuilt 1982 · S/N M-2373N6363UTf Skies LLC · Mount Pleasant, TXBuilt 1983 · S/N M-2372N63687Vsun LLC · Gilbertsville, KYBuilt 1983 · S/N M-2375
Back to AD 73-20-07 R2