OpenAirDocs.org
AD 46-40-01

Registered aircraft · 188

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-40-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-40-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.

N1010WLawlor Stephen M · Saint Joseph, MOBuilt 1946 · S/N R46-253N12120Bertrand Stephen L · Union, KYBuilt 1937 · S/N 3229N1276NGreek Housing Services Corp · Port Matilda, PAS/N W-41A-371N14397Hoag Andrew J · Naples, FLBuilt 1934 · S/N 2638N14725Thompson Richard E · Orlando, FLBuilt 1934 · S/N 2647N14727Haley Robert J · Livermore, CABuilt 1934 · S/N 2649N14749Air Heritage Inc · Beaver Falls, PABuilt 1934 · S/N 2655N14794Lloyd Howard R Jr · Fredericksburg, PAS/N 2666N14799Dakota Territory Air Museum · Minot, NDBuilt 1935 · S/N 2671N147ABEngel Leland E · Avoca, MIBuilt 1943 · S/N W41A-511N14988Penney John C Trustee · Evergreen, COBuilt 1943 · S/N 952N15038Boyer James A · Lancaster, OHBuilt 1935 · S/N 2675N15086Registered aircraftBuilt 1935 · S/N 2683N15345Spurgeon James R · Pisgah Forest, NCBuilt 1935 · S/N 2688N15387Nelson Ranley R · Butler, PABuilt 1935 · S/N 3010N15602Womack Jeff · Jackson, LABuilt 1935 · S/N 2704N15604Esch David D · Carson, WABuilt 1935 · S/N 2706N15606Colton Frank D · Canby, ORBuilt 1935 · S/N 2708N15921Little Air Dream LLC · Mooresville, NCS/N 2724N1595Omeara Jeffrey Ryan · Bainbridge Island, WABuilt 1939 · S/N R9-427N16358Wallace Terry E · Bedford, TXBuilt 1936 · S/N 2819N16682Planes Of Fame Air Museum · Chino, CABuilt 1936 · S/N 3107N16684Gecowets Jerry L · Urbana, OHBuilt 1936 · S/N 3109N16801Brown Charles M · Sandpoint, IDBuilt 1936 · S/N 2821N16811Schmidt Aaron B · Auburn, ALBuilt 1936 · S/N 3112N16812Moericke Eric A · Waupaca, WIS/N 3113N16818Jett Edward C Jr · Bloomfield, KYBuilt 1936 · S/N 3119N16820Jenkins James L · Lake Stevens, WABuilt 1936 · S/N 2830N16823Esch Joseph W · Carson, WABuilt 1936 · S/N 2833N16846Plane Fun Inc Tr Trustee · Snellville, GABuilt 1937 · S/N 2845N16848Foster Kent R · Manhattan, KSBuilt 1937 · S/N 2847N16858Schneider Gregory M · Bridger, MTBuilt 1937 · S/N 3138N16872White Theodore F · Willow, AKBuilt 1937 · S/N 3201N16897Gifford Gary W · Lighthouse Point, FLS/N 2966N16900Bischoff Ray H III · Flower Mound, TXS/N 2969N16901Bishop Harold W · Bonners Ferry, IDBuilt 1937 · S/N 3210N16902Bouslog Todd Charles · Noblesville, INS/N 3211N16904Jackson John Douglas · Hollister, CABuilt 1937 · S/N 3213N18635Registered aircraftS/N 2608N18652Butler County Warbirds Inc · Middletown, OHBuilt 1952 · S/N R9-422N18681Waldron Robert J · Webster, MNBuilt 1939 · S/N 3324N18682Collins John P · El Cajon, CABuilt 1939 · S/N R9-424N18684Walk Michael · Englewood, FLBuilt 1939 · S/N 201N18688Pfou Michael G · Princeton, MNBuilt 1939 · S/N W-101N18695Champaign Aviation Museum · Urbana, OHBuilt 1939 · S/N W213N19100Pearlman Aircraft Co · Orlando, FLBuilt 1937 · S/N 2910N19105Hawley Richard J · Moultonborough, NHBuilt 1937 · S/N 2970N19107Smith Richard D · Williamstown, OHBuilt 1954 · S/N 2972N19123Shannon Air Museum LLC · Fredericksburg, VAS/N 2983N19126Seifert Richard E · Troy, MOBuilt 1937 · S/N 3221
Back to AD 46-40-01