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.

N81221Hamilton Steven T · Carson City, NVBuilt 1946 · S/N R-46122N81226Felda Flyers LLC · Felda, FLBuilt 1946 · S/N R46127N81228Hagerstown Aviation Museum Inc · Hagerstown, MDBuilt 1946 · S/N R46-129N81230Wyman Corwyn W · Columbia Falls, MTBuilt 1946 · S/N W46131N81234Haggerty John J Jr · Skaneateles, NYBuilt 1946 · S/N R46-135N81241Clemens Russell E · El Cajon, CABuilt 1946 · S/N R-46142N81242Davis Susan J · Castroville, CABuilt 1946 · S/N R46143N81243Martin Jonathan W · West Grove, PABuilt 1946 · S/N R46144N81255Egmond Aircraft LLC · Lewes, DEBuilt 1946 · S/N R46155N81270Modlin Clarence T Jr · Dickinson, TXBuilt 1946 · S/N R46170N81276Dowdy John H · Union, WVBuilt 1946 · S/N R46176N81284Registered aircraftS/N R-46184N81285Richard D James · Groveland, FLBuilt 1946 · S/N R46185N81292Rice James L · Mckinney, TXBuilt 1946 · S/N R46192N81295American Aviation II LLC · Peyton, COBuilt 1946 · S/N R46195N81306Sale Reported · Seneca, SCSale reportedS/N R46206N81311Eddie Adams · Senath, MOBuilt 1946 · S/N R46211N81313Walk Michael · Englewood, FLBuilt 1946 · S/N R46-213N81316Branam James G · Middletown, OHBuilt 1946 · S/N R46-216N81325Weeks Monte L · Somerset, WIBuilt 1946 · S/N R46225N81326Camp Ted A · Williamson, GABuilt 1946 · S/N R46226N81329Jenkins James L · Lake Stevens, WABuilt 1946 · S/N R46-229N81330Shank Paul L · Gaithersburg, MDBuilt 1946 · S/N R-46230N81331Linn Ronald D · Stanfield, ORBuilt 1946 · S/N R46231N81334Handly William A · Arcola, MSBuilt 1946 · S/N R46234N81338Ferguson Carrie L · Palo Alto, CABuilt 1946 · S/N R46238N81348American Airpower Heritage Flying Museum · Dallas, TXBuilt 1946 · S/N R46-248N81349Dyson Keith A · Port Townsend, WABuilt 1946 · S/N R46249N81358Ferguson Cris · Livermore, CABuilt 1946 · S/N R46258N81362Jones Kenneth M · Auburn, CABuilt 1946 · S/N R46262N81363Alexander Larry A · Kosciusko, MSBuilt 1946 · S/N R46263N81373Webb David B · Wapakoneta, OHBuilt 1946 · S/N R46-273N92EPetersen Danny S · Caddo, OKBuilt 1939 · S/N W-106N9384Cournoyer John J · Ellsinore, MOBuilt 1933 · S/N 2514N9397Currie Richard W · Woodland, CABuilt 1933 · S/N 2522N9402HSchulert Philip J · Lebanon, TNFirst renewal noticeBuilt 1940 · S/N W40132N957VRegistration Pending · Oklahoma City, OKRegistration pendingBuilt 1934 · S/N 2525N987Carlsbad Raceway Corp · Hemet, CABuilt 1947 · S/N R46-389
Back to AD 46-40-01