AD 94-05-05 R1

Registered aircraft · 26,232

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

N77345Taylor Mark S · Goshen, OHS/N 11786N7734ERegistration Pending · Cheyenne, WYRegistration pendingBuilt 1959 · S/N 17534N7734FJackson Kimberly F · Wichita Falls, TXBuilt 1966 · S/N 15063834N7734XNelson Daniel J · Ladd, ILBuilt 1961 · S/N 17248234N77351Nelson Stephen A · Milaca, MNBuilt 1946 · S/N 11792N77352Heyrman Larry L · New Franken, WIBuilt 1946 · S/N 11793N77356Ogletree William H · Saint Helena, CABuilt 1946 · S/N 11797N77357Registration Pending · Benton, KSRegistration pendingBuilt 1946 · S/N 11798N7735GShaver John M · Shelby, NCBuilt 1973 · S/N 15074722N77363Jazz Air LLC · Melbourne, FLBuilt 1946 · S/N 11804N77368Goehringer Zachary · Cameron, TXBuilt 1946 · S/N 11809N7736UWatson Marshall · Sublette, KSS/N 17251736N7736XSutton Aircraft Salvage LLC · Palmer, AKBuilt 1960 · S/N 17248236N77370Fitzgerald Paul · Grapevine, TXBuilt 1946 · S/N 11811N77376Thayer Stephen · Bloomington, MNS/N 11817N7737FChapman John · San Antonio, TXBuilt 1966 · S/N 15063837N7737UMast Elroy T · Crawford, MSBuilt 1964 · S/N 17251737N77382Leavitt Jack A · Cathlamet, WAS/N 11823N77388International Air Services Inc Trustee · Carson City, NVS/N 11829N77389Acker Richard L · Coleman, MIBuilt 1946 · S/N 11830N7738EKrueger Arthur G · Cottonwood, CABuilt 1959 · S/N 17538N7738UGibson Nathaniel A · Cross Lanes, WVBuilt 1964 · S/N 17251738N7738XSutter William R · Hobart, WAS/N 17248238N77391Sawyer Andrew · Pleasanton, TXS/N 11832N773JTFritsch William W · Culbertson, NES/N 001N773SBQuinn Vita Lyn · Palatka, FLBuilt 1969 · S/N 15070665N773SHLochman Marty R · Newalla, OKBuilt 1946 · S/N 11512N773WSPerez Valentino · Sinajana, GUBuilt 1969 · S/N A1500058N77401Stout Philip L · Ephrata, WABuilt 1946 · S/N 11842N77402Severns Robert L · Eugene, ORBuilt 1946 · S/N 11843N77403Roland Kenneth R · Tell City, INBuilt 1946 · S/N 11844N77405Roach Daniel J · Centerville, OHBuilt 1946 · S/N 11846N7740XAnderson Vance K · Eugene, ORBuilt 1960 · S/N 17248240N77412Baluch Matthew J · Medina, OHBuilt 1946 · S/N 11853N77415Swartz Jerome D · Olympia, WABuilt 1946 · S/N 11856N77419Darr James S · Boron, CABuilt 1946 · S/N 11860N7741FHatch Donna L · Ballston Spa, NYBuilt 1966 · S/N 15063841N77420Drever Richard J · Canton, PABuilt 1946 · S/N 11861N77424Delta Ridge Farms LLC · Oak Grove, LAS/N 11865N77428Schoff Wardell R · Hamilton, MOS/N 11869N7742ERegistered aircraftBuilt 1959 · S/N 17542N7742FKovac Kenneth K · Mer Rouge, LABuilt 1966 · S/N 15063842N7742THelmuth Allen · Powell Butte, ORBuilt 1960 · S/N 47342N7742XMoore John W · Blue Earth, MNS/N 17248242N77439Timbs Gary O · Ontario, CABuilt 1947 · S/N 11881N77441Dale James H · La Vernia, TXBuilt 1946 · S/N 11883N77442Registered aircraftBuilt 1946 · S/N 11884N77443Aznarez Adrian B · Miami, FLFirst renewal noticeS/N 11886N77444Holderby Jeff F · Davenport, WABuilt 1947 · S/N 11887N77446Grady Keith L · Phoenix, AZBuilt 1946 · S/N 11889
Back to AD 94-05-05 R1