OpenAirDocs.org
AD 75-18-05

Registered aircraft · 85

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

N13HSGregg Brian L · Guthrie, OKS/N F-039N144ELubeck Thomas L · Anchorage, AKBuilt 1974 · S/N F-013N18ECJenkins Norman G · North Pole, AKBuilt 1977 · S/N F-083N19TEBolton 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-105N25694Weston Scott Erb Trustee · Wasilla, AKBuilt 1976 · S/N F-078N3535BLohrstorfer Matthew K · Anchorage, AKBuilt 1976 · S/N F-054N3541TWolcott Kent E · Colorado Springs, COBuilt 1972 · S/N F-001N3543TSmithwick Robert A · Palmer, AKS/N F003N3544TSnyder Thomas E · Anchorage, AKBuilt 1973 · S/N F004N3545TSantamaria Joseph J · Hebron, NHS/N F005N3548TAlsworth Glen R Jr · Port Alsworth, AKBuilt 1973 · S/N F-007N3549TBosse Lilou A · Anchorage, AKS/N F-008N3551TPlummer Deborah L · Houston, AKBuilt 1974 · S/N F-010N3555TGoodwin Peter · Spring Hill, TNBuilt 1974 · S/N F-014N3556TJulicher Mark R · Bulverde, TXBuilt 1974 · S/N F-015N3557TRoberts Calvin D · Bluebell, UTBuilt 1974 · S/N F-016N3561TBasye Matthew P · Delta Junction, AKBuilt 1974 · S/N F-020N3563TBiornstad John A · Big Lake, AKBuilt 1974 · S/N F-023N3564TMoore David · Anchorage, AKBuilt 1974 · S/N F-024N3565TBamford Bert W · Wasilla, AKBuilt 1975 · S/N F-025N3566TLee Ryan D · Anchorage, AKS/N F-026N3568TSemmig Jeffrey C · Oceanside, CABuilt 1975 · S/N F-029N3569TGlines Levi G · Smithwick, SDS/N F-030N3571TRegistration Pending · Palmer, AKRegistration pendingBuilt 1975 · S/N F-032N3572THaase Israel A · Wasilla, AKBuilt 1975 · S/N F-033N3574TCalifornia Airways LLC · Hayward, CABuilt 1975 · S/N F-040N3576TSplonskowski Steven J · Oregon City, ORBuilt 1975 · S/N F-042N3577TChaplin Lyndon Yeager · Anchorage, AKBuilt 1975 · S/N F-043N3578TMeachen Jeffry · Chippewa Falls, WIBuilt 1975 · S/N F-044N3579TWilke Daniel D · Fairmount, NDBuilt 1975 · S/N F-045N3580TYliniemi Glenn C · Frazee, MNBuilt 1975 · S/N F-046N3582TSmith Frank · Tulsa, OKBuilt 1975 · S/N F-050N3583TTurner David R · Anchorage, AKS/N F-051N3586TEdwards James W · Del Norte, COBuilt 1976 · S/N F-057
Back to AD 75-18-05