AD 85-02-05 R1

Registered aircraft · 8,921

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:85-02-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:85-02-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.

N3361ANimmick Robert A · Three Forks, MTFirst renewal noticeS/N 20-1067N3361BSmith Marcus H · Roxboro, NCS/N 22-2166N3363A7ac Club Inc · Clearwater, FLBuilt 1953 · S/N 22-1665N3363PDubois Aviation Inc · Chino, CABuilt 1958 · S/N 23-1320N3365BSmith James A · Lyle, WABuilt 1954 · S/N 22-2170N3366Sutton Aircraft Salvage LLC · Palmer, AKS/N 23-1919N3367PJackson Lee Roy Jr · Needville, TXBuilt 1958 · S/N 23-1324N3368ZWatts Paul D · Weatherford, TXBuilt 1960 · S/N 22-7283N3369ADoster Michael L · Nampa, IDBuilt 1953 · S/N 22-1667N336PAWingsleasing LLC · Wichita, KSBuilt 2002 · S/N 4496140N3370AHospodar Robert P · Georgetown, PAS/N 22-1627N3374ASinosky Kendall Ansley · Anchorage, AKS/N 22-1631N3375ATatalovich George · Rome, OHS/N 22-1628N3377ABuller Wilbur D · Redding, CABuilt 1953 · S/N 22-1632N3377PFlying High LLC · Gore, VABuilt 1958 · S/N 23-1337N3378AThompson William A · Wenatchee, WAS/N 22-1635N3379AKurronen Eric D · Anchorage, AKBuilt 1953 · S/N 22-1634N337ABPlane And Simple Leasing LLC · Delano, MNBuilt 1960 · S/N 25-459N337EPAtp Aircraft 4 LLC · Wilmington, DEBuilt 1978 · S/N 44-7995064N3380AStephan Pamela K · Anchorage, AKS/N 22-1637N3383ABishop John Patrick · Annapolis, MDBuilt 1953 · S/N 22-1646N3383BEvans Johnny D II · Billings, MTBuilt 1954 · S/N 22-2182N3385BSlipshod Aviation LLC · Hurricane, UTBuilt 1954 · S/N 22-2184N3388BMccracken Scott O · Maysville, OKBuilt 1954 · S/N 22-2187N3388PMorrison Maria · Port Townsend, WABuilt 1958 · S/N 23-1351N3389PLapeyrouse Charles L · Raceland, LABuilt 1958 · S/N 23-1352N338SSSieli Paul III · Griffin, GAS/N 27-224N3390AEngen John E · Soldotna, AKBuilt 1954 · S/N 22-1661N3391AMummey Gary E · Stockport, OHBuilt 1953 · S/N 22-1650N3392AEverts Air Service Inc · Sarasota, FLS/N 22-1652N3399PThornton Curtis J · Ebro, FLBuilt 1954 · S/N 22-2380N339CTPatel Niral G · Atlanta, GABuilt 1974 · S/N 27-7405350N33DNRegistered aircraftBuilt 1969 · S/N 24-4896N33JFKimsey Thomas Wayne · Warner Robins, GABuilt 1965 · S/N 30-820N33PHPine Creek Adventures Inc · Benton, PABuilt 1959 · S/N 24-1451N33RWSpencer Joseph C · Asheboro, NCBuilt 1960 · S/N 23-1948N33SAMcwherter Holdings Inc · Asheboro, NCS/N 27-3370N33SSRegistration Pending · Palmdale, CARegistration pendingBuilt 1966 · S/N 30-1104N33VUVincennes University · Vincennes, INBuilt 2018 · S/N 4496431N33ZMUrban Timothy J · Laytonsville, MDBuilt 1966 · S/N 30-1044N3400AAirsmith Aviation LLC · Oshkosh, WIBuilt 1953 · S/N 22-1668N3400ZHojnacki Frank · Hobart, INBuilt 1960 · S/N 22-7311N3403PCarper Ryan W · Marietta, OHBuilt 1958 · S/N 23-1367N3403ZCharpie Mark E · Ottawa Lake, MIBuilt 1960 · S/N 22-7314N3404ALibby Stephen R Trustee · Anchorage, AKBuilt 1953 · S/N 20-1069N3404ZDevils Lake Aero Repair Inc · Devils Lake, NDBuilt 1960 · S/N 22-7315N3405ZHeinrich Steven A · Corvallis, ORBuilt 1960 · S/N 22-7317N3407ZBug Smashers LLC · Winfield, KSS/N 22-7319N3409ARhoades Charles E · Blessing, TXBuilt 1953 · S/N 22-1675N340AUAuburn University · Auburn, ALBuilt 2020 · S/N 4496510
Back to AD 85-02-05 R1