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.

N3100HGregory Vernon L · Swansea, SCBuilt 1946 · S/N 3725N3101ACosta Felipe R · Charlotte, NCBuilt 1953 · S/N 25745N3101JRobinson David N · Colleyville, TXBuilt 1966 · S/N 15065801N3101XBlalock Bernnie R · Washington, OKBuilt 1966 · S/N 15064501N31026Renfro John R · Wendell, NCS/N 5264N31028R H K Of Kansas Inc · Overland Park, KSBuilt 1940 · S/N 5266N3102NParker Steve E · Wasilla, AKBuilt 1947 · S/N 13360N3102XJoshua Aircraft LLC · Georgetown, DEBuilt 1966 · S/N 15064502N3103JChiles Jimmy W · Rowlett, TXBuilt 1966 · S/N 15065803N3103VN3103v LLC · Wheeling, ILBuilt 1974 · S/N 15076382N31049Detwiler John D · Chaumont, NYBuilt 1940 · S/N 5280N3104NWard David C · Mcpherson, KSS/N 13362N31063Qualitair LLC Trustee · MichelstadtBuilt 1973 · S/N 0567N31067Marinangel Kathleen E Executrix · Mchenry, ILS/N 5293N3106BRegistered aircraftBuilt 1952 · S/N 25348N3106EMiddleline Aviation Inc · Ballston Spa, NYBuilt 1946 · S/N 7AC-6705N3107ATindall Michael E · Wahpeton, IABuilt 1953 · S/N 25751N3107EJones Donald T Jr · Yona, GUS/N 7AC-6698N3107XPage Trenton Vaughn · Warner Robins, GABuilt 1966 · S/N 15064507N3108AMccutcheon Jeffery T · Clinton, LABuilt 1946 · S/N 7AC-6699N3108FSuntech LLC · St George, UTS/N 17248297N3108JBetzoldt Linda · Tecumseh, MIBuilt 1966 · S/N 15065808N31092Covell Tim N · Healy, AKBuilt 1940 · S/N 5319N3109EDexter Fred H · Live Oak, FLBuilt 1946 · S/N 7AC-6706N3109JShue Robert R Jr · Easley, SCBuilt 1966 · S/N 15065809N31117Benfer Scott · Monroeville, OHBuilt 1940 · S/N 5399N3111ELochner Richard A · Eagle River, AKBuilt 1948 · S/N 7AC-6708N3111NGavagan Harold R · Chandler, AZBuilt 1947 · S/N 13369N31120Bensyl William · Park City, UTBuilt 1980 · S/N 126N31125I Fly Enterprise · Lexington, NCBuilt 1940 · S/N 5315N31126Krug Gene G · Medford, WIBuilt 1940 · S/N 5346N3112BParslow Wayne · Puyallup, WABuilt 1952 · S/N 25354N3112HTietze Thomas N · Olathe, KSBuilt 1946 · S/N 3737N3112NMoore Jarrel D · Waelder, TXBuilt 1947 · S/N 13370N3113XAfp Aerospace LLC · West Palm Beach, FLBuilt 1966 · S/N 15064513N31140Brown Doyle E · Jonesboro, ARBuilt 1946 · S/N 3143N3114JHibner Joseph W · Coldwater, OHBuilt 1966 · S/N 15065814N3114NClassic Aviation Inc · Pella, IABuilt 1947 · S/N 13372N3115BKegley Gary L · Perrin, TXBuilt 1952 · S/N 25357N3115EBushman Kyle P · Pleasant Hill, ORBuilt 1946 · S/N 7AC-6712N3115NYork Ersell Shane · Ramseur, NCS/N 13373N3115VBarkman D Barry · Naples, FLBuilt 1974 · S/N 15076388N3115XReeve Howard E · Minot, NDS/N 15064515N31160Caliber Air LLC · Wasilla, AKBuilt 1940 · S/N 5377N31165Hackenburg Jess P · Montoursville, PAS/N 5322N31169Mcdevitt Charles P · Bridgeport, WVBuilt 1977 · S/N 1N3116ASchanche Carsten H · Marstons Mills, MABuilt 1953 · S/N 25760N3116XRegistered aircraftBuilt 1966 · S/N 15064516N3118VKemper Joseph C · Coxs Mills, WVBuilt 1974 · S/N 15076390N3118XMoody Dalton T · Evansville, INBuilt 1966 · S/N 15064518
Back to AD 94-05-05 R1