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.

N42JCStevens David L · Richmond, INBuilt 1982 · S/N JRC-1N42KHo Christopher Y · Anchorage, AKBuilt 1947 · S/N 12223N42RPCallahan Jr Ted F · Magnolia, TXBuilt 2002 · S/N 001N42SJN42sj LLC · Ann Arbor, MIBuilt 2002 · S/N JB001-02N42XPNewbold Edward F · Galloway, OHBuilt 1980 · S/N 82N43006Spencer Daniel P · Cocolalla, IDBuilt 1945 · S/N 6665N4300CBerke Steven M · Black Hawk, SDBuilt 1955 · S/N 7EC-300N4300NNotaras George John · Manhattan Beach, CABuilt 1947 · S/N 13771N43015Dayton Kenneth J · Great Mills, MDBuilt 2005 · S/N 001N4301BCff LLC · Kalispell, MTBuilt 1955 · S/N 26645N4301HDrane Stephen T · Kerrville, TXBuilt 1948 · S/N 15-83N43021Hensel Brian D · Wasilla, AKBuilt 1946 · S/N 6680N4302LSenn Steve E · Burwell, NEBuilt 1966 · S/N 17254371N4302ULarson Gary L · Elgin, TXBuilt 1964 · S/N 15060302N4303BWetherbee Michael · Howell, MIBuilt 1955 · S/N 26647N4303CWhite David W · South Fulton, TNBuilt 1955 · S/N 7EC-303N4303LArtic'S Air Academy LLC · Palmer, AKBuilt 1966 · S/N 17254372N4303USherbak Michael J II · St Helena Is, SCBuilt 1963 · S/N 15060303N4303YLopez Richard · Hialeah, FLBuilt 1954 · S/N 235N4304UStoller Aircraft Rentals LLC · Sharpsburg, GAS/N 15060304N4305EKlos Jeff · Plevna, MTBuilt 1947 · S/N 7BCM-369N4305LLavin Renaye K · Wasilla, AKS/N 17254374N4306CHarsh David L · Daniels, WVBuilt 1955 · S/N 7EC306N4306LGrandinetti Robert L · Fayetteville, NYS/N 17254375N4307HEmerson Tiffany A · Roseville, CABuilt 1948 · S/N 15-90N4308BLyons Milo J · Sequim, WABuilt 1955 · S/N 26652N4308CBrooks Clifton B · Harrah, OKBuilt 1955 · S/N 7EC-308N4308HLeaders Bob O · Clear Lake, MNBuilt 1948 · S/N 15-91N4308LKim Jingu · Mount Prospect, ILBuilt 1966 · S/N 17254377N4308UWildcat Aviation LLC · Schoolcraft, MIBuilt 1964 · S/N 15060308N43096Kornfield Edward A · Anchorage, AKBuilt 1946 · S/N 6755N4309LWallace Leroy C · Wshngtn Ct Hs, OHBuilt 1966 · S/N 17254378N4310BMaly Burr J · Anchorage, AKBuilt 1955 · S/N 26654N4310CTadic Michael · Skagway, AKBuilt 1955 · S/N 7EC-310N4310EDittlinger Bret W · Anchorage, AKBuilt 1948 · S/N 11CC-176N4310LMckenzie Donovan G · East Northport, NYBuilt 1966 · S/N 17254379N4310USport Wings Enterprises LLC · Pasadena, TXBuilt 1964 · S/N 15060310N4311BPohl Jeffrey A · Milaca, MNBuilt 1955 · S/N 26655N4311CPage Aerial Service Inc · Rochelle, ILBuilt 1955 · S/N 7EC-311N4311EHeavirland Robert A · North Branch, MNBuilt 1948 · S/N 11CC-177N4311LRockin Robin Aviation LLC · Natchez, MSS/N 17254380N4313CJohnson Charles M · Malta, MTBuilt 1955 · S/N 7EC-314N43143Andrews Jon L Jr · Seward, AKS/N 6802N4315Kimbrel Martin E · Oakville, WAFirst renewal noticeBuilt 1968 · S/N SS-2N4315BMckamey Dave S · Sonora, CABuilt 1955 · S/N 26659N4315LBeedle Jeremiah J H · Juneau, AKS/N 17254384N4315UYoung Margaret J · Peck, IDBuilt 1964 · S/N 15060315N4316BAnderson Gregory P · Meadow Vista, CABuilt 1955 · S/N 26660N4316CNorman Shawn T · Rothsay, MNBuilt 1955 · S/N 7EC-317N4317CSasinowski Joseph Vance · Anchorage, AKBuilt 1955 · S/N 7EC-318
Back to AD 94-05-05 R1