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.

N410UCarey Calvin W · Evansville, WYS/N 977N410WEBruno Christopher B · Eagle River, AKBuilt 2015 · S/N 1839N4110LNeu Aviation LLC · Benton, LABuilt 1966 · S/N 17254179N4110UKrul Donald · Center Line, MIBuilt 1963 · S/N 15060110N41116Sommer John J · Seattle, WABuilt 1941 · S/N 7764N4111EHeller Kurt L · Skwentna, AKBuilt 1947 · S/N 11CC-21N4111FRoss Karen F · Marion, TXBuilt 1958 · S/N 46011N4111NMcgrath Connor W · Norfolk, VAS/N 13569N4111UKenner Matthew T · Big Canoe, GABuilt 1963 · S/N 15060111N4111VJohnston Daniel T · Cambridge, OHBuilt 1948 · S/N 18443N41122Minor James F · Lake Dallas, TXBuilt 1941 · S/N 7769N4112FWard Leigh C · Garden Valley, IDBuilt 1958 · S/N 46012N4112NLittfin Todd D · Eleva, WIBuilt 1947 · S/N 14025N4112VButterfield Colin · Wellesley, MABuilt 1948 · S/N 18444N4113VHare Charles W · Leaf River, ILS/N 18445N41147Papp Jacob R · Fort Edward, NYBuilt 1946 · S/N G174N4114LLarson Lynn R · Casselton, NDBuilt 1966 · S/N 17254183N4114NFoster James W · Rapid River, MIBuilt 1947 · S/N 13572N4114UPelan Lynn · Oakland, NEBuilt 1963 · S/N 15060114N4115FHogan Darrel R · Ash Grove, MOBuilt 1972 · S/N 15074003N4115LPierce Michael W · Leitchfield, KYBuilt 1966 · S/N 17254184N4115UMoore David A · Winchester, TNBuilt 1963 · S/N 15060115N4116DLofstrom Caleb J · Wasilla, AKS/N 11-1580N4116LHubbard Matt · Phoenix, AZBuilt 1966 · S/N 17254185N4116NUnruh Adrian R · Bellevue, WAS/N 13574N41175Myers Randall · Parshall, NDBuilt 1941 · S/N 7813N4117LPatrick Milan Jr · Shinnston, WVBuilt 1966 · S/N 17254186N4118FMountain Air Spray Co Inc · Craig, COS/N 46018N4118LUan Venture Partners LLC · Odessa, FLBuilt 1966 · S/N 17254187N4118UZaner Don D · Osceola, MOBuilt 1963 · S/N 15060118N4119FPlymate Claude L · Tehachapi, CABuilt 1958 · S/N 46019N4119LSugar Aircraft LLC · Oak Harbor, WAS/N 17254188N4119UWeeks Nathaniel J · Sartell, MNBuilt 1963 · S/N 15060119N411DEdwards Anthony C · Weaverville, CABuilt 1939 · S/N 947N411FClement Robert D · Arizona City, AZBuilt 1946 · S/N 3673N411RFFoothill Aircraft Sales & Service Inc · Upland, CAS/N 17252216N4120EWilliams Barrett G · Homer, AKS/N 11CC29N4121FHarrold Bruce E · Greybull, WYBuilt 1958 · S/N 46021N4121U150d LLC · Attica, NYS/N 15060121N4122NSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1947 · S/N 13580N4123HEngler Eric M DBA · Cass City, MIS/N 15-6N4124FNelson David R Co-Trustee · New Richmond, WIBuilt 1958 · S/N 46024N4125ESmith John R · Greensboro, GABuilt 1947 · S/N 11CC-34N4125FSale Reported · Addison, TXSale reportedBuilt 1958 · S/N 46025N4125LEvans Samuel F · Selma, ALS/N 17254194N4125UOxborrow Andrew Charles · Lake Barrington, ILBuilt 1963 · S/N 15060125N4126FRider Terry · Corinth, MSBuilt 1958 · S/N 46026N4126LBritton Jeff J · Forest Falls, CABuilt 1966 · S/N 17254195N41273Pa-18 LLC · Hood River, ORBuilt 1942 · S/N 8199N4127FDavolt John E · Independence, KSFirst renewal noticeBuilt 1958 · S/N 46027
Back to AD 94-05-05 R1