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.

N817PSSutton Aircraft Salvage LLC · Palmer, AKBuilt 1965 · S/N 17252705N817RLPalouse Ag Leasing LLC · Moscow, IDBuilt 2007 · S/N CC11-00046N818High Alpha Airshows LLC · Santa Rosa Valley, CABuilt 1968 · S/N 15069651N81803Champ 81803 LLC · Clinton, MOBuilt 1945 · S/N 7AC-426N8180ANipp Michael P · Nampa, IDBuilt 1952 · S/N 25032N8180BNiehaus James O · Erie, COBuilt 1957 · S/N 29980N8180LManser Andrew R · Neenah, WIBuilt 1967 · S/N 17256380N81810Vintage Combat Aircraft LLC · Wilmington, DEBuilt 1945 · S/N 7AC-433N8181BManning Richard F Jr · Midway, GABuilt 1957 · S/N 29981N8181SCopeland Kevin D · Vidalia, GABuilt 1965 · S/N 15061781N8181THetge Kenneth R · Viola, ARBuilt 1961 · S/N 17556881N8181UMillman Chris · Auburn, WABuilt 1964 · S/N 17252081N81823Mcgill Melissa M · Joliet, MTBuilt 1946 · S/N 7AC-446N8182UMorristown Flying Service Inc · Talbott, TNBuilt 1964 · S/N 17252082N81834Kurtz Garold D · Mound City, MOS/N 7AC457N8183ARegistered aircraftBuilt 1952 · S/N 25035N8183FArvizu Jason Arthur Scott · Bakersfield, CABuilt 1966 · S/N 15064283N8183THysell Donovan · Atwater, OHBuilt 1960 · S/N 17556883N8183UMacauley Richard D · Shingle Springs, CABuilt 1964 · S/N 17252083N8184BPalouse Aviation Holdings LLC · Moscow, IDBuilt 1957 · S/N 29984N8184LVanderlaan Dirk C · Reno, NVBuilt 1967 · S/N 17256384N8184TGraham Steven K · Mc Grath, AKBuilt 1960 · S/N 17556884N8185SJanssen Christopher M · Manchester, IABuilt 1965 · S/N 15061785N8185VCryan Mark · Port Orange, FLBuilt 1974 · S/N A1500557N81868Henderson William Gary · Lake Worth, TXBuilt 1946 · S/N 5695068N8186BMid-Atlantic Aircraft Leasing LLC · Wilmington, DEBuilt 1957 · S/N 29986N8186LBolsover Douglas J Sr · Cameron Park, CAS/N 17256386N8186TBouton Vern H · Fairbanks, AKBuilt 1961 · S/N 17556886N8186ULake Area Technical College · Watertown, SDBuilt 1964 · S/N 17252086N81875Suits Thomas L · Tulsa, OKS/N 7AC-498N8187BWithers Hurchel W · Stone Mountain, GABuilt 1957 · S/N 29987N8187FCoady Michael J · Taylorville, ILBuilt 1966 · S/N 15064287N8187SCounter Kevin · Windsor, CAS/N 15061787N8187VNelson Brett R · Shoreview, MNBuilt 1974 · S/N A1500559N8189AEight Niner Alpha LLC · Eagle, IDBuilt 1952 · S/N 25041N8189FArchuleta Michelle L · Las Cruces, NMBuilt 1973 · S/N A1500455N8189XQuire Gregory L Sr · Shepherdsville, KYBuilt 1961 · S/N 17248689N818BCKingsbury Gwendolyn · Indianola, IAS/N AL-1096N818MLTurning Point Northwest LLC · Stanwood, WABuilt 1966 · S/N 15064017N818SWAbbott Don W · Sanibel, FLBuilt 1968 · S/N B-279N8190LOlsen Curtis O · Lindon, UTS/N 17256390N81910Leaders Bob · Clear Lake, MNS/N 7AC-533N8191FMoore Clayton P · Cayce, SCBuilt 1966 · S/N 15064291N8191SStang Daniel Jr · Lindale, TXBuilt 1965 · S/N 15061791N8191TDavis Jonathan L · Pleasanton, CAFirst renewal noticeBuilt 1960 · S/N 17556891N8191UAnderson Amy J · Manistique, MIBuilt 1964 · S/N 17252091N81920Crooke Michael J · Charlotte, NCS/N 7AC-545N81927Elliott Joel C · Pacoima, CABuilt 1946 · S/N 7AC-552N8192BAll Sports Aviation LLC · Sandpoint, IDBuilt 1957 · S/N 29992N8192LSteinmetz William · Lakeville, INBuilt 1967 · S/N 17256392
Back to AD 94-05-05 R1