OpenAirDocs.org
AD 46-21-01

Registered aircraft · 54

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

N12120Bertrand Stephen L · Union, KYBuilt 1937 · S/N 3229N15387Nelson 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 3505N19184Gonzales Donald M · Columbia Station, OHBuilt 1938 · S/N 3507N19189Pavoni Justin F · Flemingsburg, KYS/N 3304N20615Kretsinger Steven H Trustee · Eugene, ORBuilt 1938 · S/N 3407N20624Fulton Gordon D · Mackay, IDBuilt 1938 · S/N 3514N20629Reid Michael J · Fort Towson, OKBuilt 1938 · S/N 3311N20631Levine James David · Mentor, OHBuilt 1938 · S/N 3358N20641Gonzales Donald M · Columbia Station, OHBuilt 1938 · S/N 3318N2088Mesmer Robert F · Grand Island, NYBuilt 1937 · S/N 2918N23EWestern Antique Aeroplane & Automobile Museum · Hood River, ORBuilt 1938 · S/N 2926N244GAChristman Timothy A · Dayton, OHS/N 3218N2639Neuman Allen D · Sanger, TXBuilt 1938 · S/N 3315N2890Hagerstown Aviation Museum Inc · Hagerstown, MDBuilt 1933 · S/N 2509
Back to AD 46-21-01