OpenAirDocs.org
AD 46-40-02

Registered aircraft · 75

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-02')
    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-02')
  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.

N11653Bailey Orin A · Homedale, IDBuilt 1931 · S/N 1003N12120Bertrand Stephen L · Union, KYBuilt 1937 · S/N 3229N12454Western Antique Aeroplane & Automobile Museum · Hood River, ORS/N 1503N12611Hodgdon Theodore E III · Danbury, CTBuilt 1931 · S/N 1013N12670Baden James D · Mechanicsville, MDBuilt 1932 · S/N 1500N12674Petro Jerry R · Williamsburg, VABuilt 1932 · S/N 1033N13166Hamann James D · Erie, COS/N 1505N13167Port Townsend Aero Museum · Port Townsend, WABuilt 1933 · S/N 1506N13168Hoffman Steven L Trustee · Nokomis, ILBuilt 1932 · S/N 1504N13284Kowalik Wendy Trustee · San Antonio, TXBuilt 1934 · S/N 1702N14302Freeman Heritage Collection LLC · Kingsbury, TXBuilt 1934 · S/N 915N14339Grangruth Rory Allen · Wadena, MNBuilt 1934 · S/N 916N14768Hagerstown Aviation Museum Inc · Hagerstown, MDBuilt 1933 · S/N 922N15387Nelson Ranley R · Butler, PABuilt 1935 · S/N 3010N16358Wallace 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 3213N18681Waldron Robert J · Webster, MNBuilt 1939 · S/N 3324N19100Pearlman 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 3221N19128Golden Age Air Museum · Bethel, PAS/N 3223N19129Rhinebeck Aerodrome Museum · Rhinebeck, NYBuilt 1937 · S/N 3224N19139Mid Atlantic Air Museum · Reading, PABuilt 1937 · S/N 2987N19140Smith Happy · Rogersville, TNBuilt 1937 · S/N 2988N19146Eastern Stearman Inc Trustee · Leesburg, VABuilt 1937 · S/N 2994N19149Euroaviation Inc Trustee · KematenBuilt 1937 · S/N 2991N19164Malene John E · Cuyahoga Falls, OHS/N 2997N19173American Aviation II LLC · Peyton, COBuilt 1937 · S/N 2958N19177Lancaster Mark S · Ottumwa, IABuilt 1938 · S/N 3501N19178Stuckle Eugene A · Davenport, WABuilt 1937 · S/N 3502N19180Doyle Mary · Hampton, IABuilt 1938 · S/N 3503N19182Gonzales Donald M · Columbia Station, OHBuilt 1938 · S/N 3505
Back to AD 46-40-02