AD 94-05-05 R1

Registered aircraft · 26,231

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.

N4145EMacgregor Wayne R · East Northport, NYBuilt 1947 · S/N 11CC-53N4145USt Peter John P · Hicksville, OHBuilt 1963 · S/N 15060145N4146FGompert Andrew B · Burwell, NEBuilt 1958 · S/N 46046N4146NPitman Marvin L · Harrah, OKBuilt 1947 · S/N 13609N4146UKobza Leslie J · White Bear Lake, MNBuilt 1963 · S/N 15060146N4147FSwan Steve · Jackson, WYBuilt 1958 · S/N 46047N4147UEast Tennessee Pilots Club Inc · Knoxville, TNBuilt 1963 · S/N 15060147N4148FBorders Jimmie L · Tompkinsville, KYBuilt 1958 · S/N 46048N4149FCarruth Peter J · Benson, MNS/N 46049N4149LRegistration Pending · Bryan, OHRegistration pendingS/N 17254218N4149NJones Eugene E · Saint Johns, MIBuilt 1947 · S/N 13612N4149UMinard Nicholas R · Chandler, AZS/N 15060149N4149VBush Brett C · Cody, WYBuilt 1948 · S/N 18481N414BJPrestridge Robert L · Ripley, TNBuilt 2010 · S/N 94016N415Cole David J · Springfield, ORBuilt 1977 · S/N 6814K130BN4150EAnderson Kyle E · Palmer, AKS/N 11CC-57N4150FRegistration Pending · Clinton Township, MIRegistration pendingS/N 46050N4150ULong Sarah Louise · Fort Wayne, INS/N 15060150N4150VDorsey Christopher · Round Rock, TXBuilt 1948 · S/N 18482N4151Stapleton Halley S · Brownsville, TXS/N 3003N4151EClark William · Easton, MOBuilt 1947 · S/N 11CC-58N4151LPardun Phillip R · Mason City, IABuilt 1966 · S/N 17254220N4151NRegistered aircraftBuilt 1947 · S/N 13873N4151UHuskey Ryan J · Edmond, OKS/N 15060151N4151VRisner Rick · Vernon, TXS/N 18483N4152FGaertner Kim L · Oconto, WIBuilt 1958 · S/N 46052N4152LLambert Robert · Paoli, INBuilt 1966 · S/N 17254221N4152VBrewer Samuel T · Wasilla, AKS/N 18484N4153FChaffee Craig O · Le Raysville, PABuilt 1958 · S/N 46053N4153NAljanabi Mohammed Khalid · Herndon, VABuilt 1947 · S/N 13875N4153VBenoit Bob W · Hot Springs, ARBuilt 1963 · S/N 18485N4154DBriggs John M · Vancouver, WABuilt 1951 · S/N 20037N4154NEnglehart Joseph Michael-John · Walla Walla, WABuilt 1949 · S/N 13617N4154VWindsock Capital LLC · Bertram, TXS/N 18486N4155NMacvey Troy R · Milan, INBuilt 1947 · S/N 13626N4155VBeavert Curt E · Murfreesboro, ARBuilt 1948 · S/N 18487N4156FPintar Robert · Spokane, WAS/N 46056N4156LZimmer Marc R · Moses Lake, WABuilt 1966 · S/N 17254225N41578Aero Leasing LLC · Snohomish, WABuilt 1942 · S/N 8183N4157NLumley William J · Delray Beach, FLBuilt 1947 · S/N 13628N4157VMoran Charles L Jr · Fresno, CABuilt 1948 · S/N 18489N4158FKraft Dean B · Mapleton, NDBuilt 1958 · S/N 46058N4158NPerkins Howard D Jr · Sapulpa, OKS/N 13629N4159CPerkins Kenneth D II · Eagle River, AKBuilt 1962 · S/N 9N4159LGrassetti Raymond J · Monson, MABuilt 1966 · S/N 17254228N4159NBergwall Douglas H · San Mateo, CAFirst renewal noticeBuilt 1947 · S/N 13630N4159UTodhunter John S · Hemet, CABuilt 1963 · S/N 15060159N415BZDaley Lige W · Carlinville, ILBuilt 1946 · S/N 693N415CDRoehm David L · Leesburg, OHBuilt 1947 · S/N 4523N415DRHughes Keith A · Ormond Beach, FLBuilt 1946 · S/N 784
Back to AD 94-05-05 R1