AD 46-17-01

Registered aircraft · 107

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:46-17-01')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:46-17-01')
  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.

N57418Rushing Christopher P · Van Nuys, CABuilt 1942 · S/N 84-7748N57493Alpha Air LLC · Sparks, NVBuilt 1941 · S/N 774201N5WSShelton Greg N Trustee · Collinsville, OKBuilt 1942 · S/N 41-32815N601JFAt-6c LLC · Wilmington, DEBuilt 1943 · S/N 88-12151N60380Buffalo Aviation LLC · Monette, ARBuilt 1943 · S/N 88-12018N604RTelling Frederick W · Port Orange, FLBuilt 1940 · S/N 54135N61MHJasmine Inc · Lewes, DEFirst renewal noticeS/N 49-3269N620AJFancy Sparks Aviation LLC · Bear, DEBuilt 1944 · S/N 8814161N623DCHenshaw Richard L Jr · N Prince George, VABuilt 1943 · S/N 881516N648DBW&W Aircraft Leasing LLC · Claremore, OKS/N 77-4215N6558DWestern Warbirds LLC · Prescott, AZBuilt 1943 · S/N 2878N6617XBurns Charles R · Huntsville, ALBuilt 1944 · S/N 7718-59N6637CBlack Pearl Snj LLC · Springville, NYS/N 91072N684RCCremante LLC · Carson City, NVBuilt 1943 · S/N 8813660N696REAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1943 · S/N 8813651N697DST-6 LLC · Manassas, VABuilt 1942 · S/N 8811599N7033CClifford Michael P · Paris, TXS/N 88-94276N7054RBrown Aviation LLC · Warrenton, VAS/N 88-112429N7055HMiddleton Kim I · Long Beach, CAS/N 88-12150N7055KNelson Richard · Tucson, AZS/N 50-709EN7061CDo Whut Inc · Wilmington, DEBuilt 1956 · S/N 88-12622N7078CHawks Zero Q 3 LLC · Sonoma, CABuilt 1956 · S/N 55-53150N7177Kubecka Jill A · Edna, TXS/N 889692N7292Kubecka Jill A · Edna, TXS/N 8810643N7293YMoore Murray H · Twain Harte, CAS/N 43942N7413CPierucci Crown Lori D · San Luis Obispo, CABuilt 1960 · S/N 88-10278N7421CBritton Scott M · Fairview, TXS/N 42-85599N7462C5gus Inc · Tallulah, LAS/N 12163211N7471SLonestar 6 LLC · Warwick, RIBuilt 1943 · S/N 8814167N7638CLindemann Flying Service LLC · Valley City, NDS/N 774300N7639Kubecka Jill A · Edna, TXBuilt 1941 · S/N 786164N7649SSimmons Mark A DBA · Pawcatuck, CTBuilt 1941 · S/N 786199N7653AKubecka Jill A · Edna, TXBuilt 1943 · S/N 774699N7678ZSimply Living LLC · Fort Myers, FLBuilt 1942 · S/N 889156N7693ZAngelici Arnold Anthony Jr Trustee · Peachtree City, GABuilt 1942 · S/N 8811637N77TXAir Cover Academy LLC · Frankford, MOS/N 78-6698N78RNDawson Jamie Stewart · Celina, TXBuilt 1942 · S/N 77-4601N7991CFernalld Richard C · Yelm, WABuilt 1958 · S/N 78-7018N8021RN8021r LLC · Scottsdale, AZBuilt 1940 · S/N 54136N817NPWar Relics LLC · Jackson, MSS/N 88-16210N832AJHochhaus Andrew · Norfolk, VABuilt 1961 · S/N AJ832N867DLLinville Douglas A II · Suwanee, GAS/N 787390N88RTAnderson Mike DBA · Muskogee, OKS/N 2780N8BPKempf Douglas A · Crawford, COBuilt 1942 · S/N 66-2517N90629Kelley Richard E · Spring Branch, TXS/N 78-7375N9235ZJohnson John J · Wasilla, AKS/N 41-32402-1N92375Fisher Air LLC · Cardington, OHS/N AC41-33062JLN94444American Heritage Aviation Inc · Peachtree City, GAFirst renewal noticeS/N 77-3962N9523CFarber Paul S · Albertson, NYBuilt 1956 · S/N 27293N9525CCondor Squadron Officers & Airmens Assoc Inc · Van Nuys, CAS/N 88-12407
Back to AD 46-17-01