OpenAirDocs.org
AD 78-20-11

Registered aircraft · 1,095

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:78-20-11')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:78-20-11')
  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.

N1023DGregg John I Jr · Glendale, AZS/N 10520N10JLSmith Loren D · Great Falls, MTBuilt 1946 · S/N 6681N1182KUllrich Sandy J · Haskell, OKS/N 8309N121BXEnglish Dexter · Syracuse, KSS/N 8960N128ZKammer Frank B · Ringgold, GAS/N 7149N13HSGregg Brian L · Guthrie, OKS/N F-039N144ELubeck Thomas L · Anchorage, AKBuilt 1974 · S/N F-013N175JBWhitcher Garrick L · Woodburn, ORS/N 1607N18ECJenkins Norman G · North Pole, AKBuilt 1977 · S/N F-083N19461Bouchard Jason A · Carmel Valley, CAS/N 9820N194KJCollins Richard F · Lake Wales, FLBuilt 1948 · S/N 12010N1951JDelaney John D · Mineral Point, WIBuilt 1946 · S/N 9902N19JLPodeweltz Dana A · Merrill, WIBuilt 1946 · S/N 6719N19TEBolton Adam W · Anchorage, AKS/N F-104N20004Kania Chester J Jr · Alton, NHBuilt 1978 · S/N F-129N2000UHanscom Rodney L · Holden, MEBuilt 1978 · S/N F-124N2000VHobson George A · Fairbanks, AKBuilt 1978 · S/N F-125N2001AMiller Brian T · Wasilla, AKBuilt 1978 · S/N F-130N2001JKrause Daniel J · Akron, COBuilt 1978 · S/N F-133N2001KJacko Josh E · Anchorage, AKBuilt 1978 · S/N F-134N2001TNystrom John H Trustee · Palmer, AKBuilt 1978 · S/N F-135N2002ALedford Stacey L · Saint Joseph, MOBuilt 1979 · S/N F-137N2002CStratus Air Services LLC · Punxsutawney, PABuilt 1979 · S/N F-138N2002VDay William S · Anchorage, AKBuilt 1979 · S/N F-142N2003CEggert Thomas F · Woodbury, MNBuilt 1979 · S/N F-147N2003KTobin Garvee Irene · Anchorage, AKS/N F-150N2003LOllmann Paul W · Poplar Grove, ILS/N F-151N2003XYelton Darrell A · Pleasant Hill, MOS/N F-152N2004ASwistunowicz Zygmunt S · Newtown Square, PABuilt 1979 · S/N F-153N208APNelson Kyle P · Union, WABuilt 1977 · S/N F-105N20VHale Leland Wayne Jr · Van Alstyne, TXBuilt 1946 · S/N 7891N23880Hustak Michael G Jr · Granbury, TXBuilt 1946 · S/N 7682N24443Dopfel Bruce E · Belle Plaine, KSBuilt 1940 · S/N 1780N244MLLevonowich Michael J · Pleasant Prairie, WIS/N 6815N246DSAbbett Farms LLC · La Crosse, INBuilt 1945 · S/N 6576N24TMoore David R · Apple Valley, CABuilt 1946 · S/N 7890N25694Weston Scott Erb Trustee · Wasilla, AKBuilt 1976 · S/N F-078N27500Stoos Robert A · Lakeland, FLS/N 2142N27510Rustad Scott · Minot, NDS/N 6563N2754XAngell Lane C · Blackfoot, IDS/N 9232N27599Cushway Michael J · Trout Creek, MIBuilt 1940 · S/N 2240N29694Poage James A · Fairbanks, AKBuilt 1941 · S/N 2538N29753Balow Bregory S · Durand, WIBuilt 1946 · S/N 10288N313EFFaith Jeffrey · Louisville, KYBuilt 1946 · S/N 8771N321LDFitzgerald Fred Lee · Shelton, WABuilt 1947 · S/N 10544N3377DWalden Joncy T · Millsap, TXBuilt 1946 · S/N 7432N33942Dale Isaac F · Soldotna, AKBuilt 1941 · S/N 2792N33989Gorreck August A · Lisbon, CTBuilt 1941 · S/N 2841N34236Worcester Phillip · Tabor, IABuilt 1946 · S/N 7699N34237Egdorf H W · White Rock, NMBuilt 1946 · S/N 7700
Back to AD 78-20-11