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.

N3587TManning Michael W · Chanhassen, MNBuilt 1976 · S/N F-058N3589TChristensen Rande L · Cambridge, MNS/N F-060N3591TRussell William E · Remus, MIBuilt 1976 · S/N F-061N3592TMcnaney David L · Hysham, MTBuilt 1976 · S/N F-063N3612THamill Theo W · Durango, COBuilt 1976 · S/N F-066N3616THam Russell W · Dike, TXBuilt 1976 · S/N F-070N3617TRegistration Pending · Fairbanks, AKRegistration pendingBuilt 1976 · S/N F-071N3666TOlson Ronnie E · Palmer, AKBuilt 1976 · S/N F-073N3668TSchachle Jeremiah K · Houston, AKBuilt 1976 · S/N F-069N3669TGrey Brian S · Walker, MNBuilt 1976 · S/N F-076N3673TDunn Carrie B · Emporia, KSBuilt 1976 · S/N F-081N3678TVeech Shawn M · Big Lake, AKBuilt 1977 · S/N F-086N3679TGks 1 LLC · Dalton, PABuilt 1977 · S/N F-079N3682TMortenson Allan C · Healy, AKS/N F-089N3684TBrosseau Stephen C · Sonoma, CAS/N F-091N3685THarvath John A Jr · Anchorage, AKBuilt 1977 · S/N F-092N3689TVon Brock David C · Gulf Breeze, FLS/N F-096N3690TDunlap Gary P · Seattle, WABuilt 1977 · S/N F-097N3692TPitts Lynn L · Webb City, MOBuilt 1977 · S/N F-099N3694TSchock Niklas A · Palmer, AKBuilt 1977 · S/N F-101N3696TRegistered aircraftBuilt 1977 · S/N F-103N3697TShannon Christopher Ray · Nome, AKFirst renewal noticeBuilt 1978 · S/N F-106N3698TMccormick Ken C · Indian, AKBuilt 1977 · S/N F-107N3728TSomd Seaplanes LLC · Lexington Park, MDS/N F-111N3756TVan Koevering Douglas · Jenison, MIBuilt 1978 · S/N F-112N3774TMcconnell Andrew D · Palmer, AKBuilt 1978 · S/N F-115N3787TPrewett Jared · Houston, AKBuilt 1978 · S/N F-116N3794TFournier Mark R · Carabaset Vly, MEBuilt 1978 · S/N F-117N37YDSteele Elizabeth · Kalispell, MTS/N F-108N3861TQuast Felix J · Delano, MNBuilt 1978 · S/N F-118N3995TCorlett Thomas I · Clinton, WABuilt 1978 · S/N F-123N62472Ollmann Matthew P · Poplar Grove, ILBuilt 1975 · S/N F-035N69GGMosher Dustin T · Tehachapi, CABuilt 1976 · S/N F-067N8216ELevinson Taylor · Anchorage, AKS/N F-056N9587TWeymouth James · Jackson, MIBuilt 1976 · S/N F-075
Back to AD 75-18-05