OpenAirDocs.org
AD 46-14-01

Registered aircraft · 35

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

N1129ZTexas Air Museum · Slaton, TXBuilt 1965 · S/N 6N1131ZTexas Air Museum · Slaton, TXBuilt 1965 · S/N 9N130PTMount Glenn W · Modesto, CABuilt 1942 · S/N 325H0N228PTCousineau Paul J · San Clemente, CAS/N 230SLN23PTMulsand Lou A · Knoxville, TNS/N 211N37425Casa Acquisitions LLC · Winter Haven, FLS/N 4043AEN3925MMid Atlantic Air Museum · Reading, PAS/N HO-155N51296Reigle Aviation South LLC · Orlando, FLBuilt 1943 · S/N 190-H0N52224Kuhn Kathleen A · Williamson, NYBuilt 1943 · S/N 292H0N5427NMid Atlantic Air Museum · Reading, PAS/N 2873AEN54375Schmidt Philip E · Weatherford, OKBuilt 1944 · S/N 9974AEN55076Sheffield Vana Riggs Executrix · Amarillo, TXS/N 10434AEN55198Van Kirk Malcolm R · Frederick, MDBuilt 1945 · S/N T43-5482N58741Grismer Jeffery Trustee · Hemet, CABuilt 1943 · S/N 2703AEN60332Gertsen Ronald H · Glenwood, NJBuilt 1946 · S/N 225SLN60629Aerial Operations LLC · Belgrade Lakes, MEBuilt 1943 · S/N 16N60727American Airpower Heritage Flying Museum · Dallas, TXBuilt 1943 · S/N 352-HON62476American Air Power Heritage Flying Museum · Dallas, TXBuilt 1942 · S/N T42-6001N63115Hagan David · Overgaard, AZS/N 222-SLN63739Polhemus Christopher · Carmichaels, PABuilt 1943 · S/N 1223-AEN63818Matesick Michael D · Green Springs, OHBuilt 1943 · S/N 211-H0N63828Yanks Air Museum · Baldwin Park, CAS/N 307SLN63896Bailey Raymond · Mansfield, TXBuilt 1942 · S/N 383HON63902Linear Farming Inc · Pleasant Grove, CABuilt 1943 · S/N 421-HON64097Yellowstone Aviation Inc · Jackson, WYBuilt 1943 · S/N 129N64138Fuller Gary M · Bakersfield, CABuilt 1942 · S/N 3473AEN64172Frasca Thomas W · Champaign, ILBuilt 1943 · S/N 260-HON64176American Airpower Heritage Flying Museum · Dallas, TXBuilt 1943 · S/N 256H0N64202Ribbens William B · Ann Arbor, MIBuilt 1943 · S/N 318-H0N64225Casa Acquisitions LLC · Winter Haven, FLBuilt 1943 · S/N 2403-AEN64230Kaylor James P · Worden, ILBuilt 1943 · S/N 4513-AEN68359Hawkins Donald M · Borrego Springs, CABuilt 1943 · S/N T42-4329N7145YDebonair Consulting Inc · Wilmington, DES/N 1523AEN73609Smith Robert D · Grapevine, TXS/N FT-809N73HAAvezzie Harland C · Westfield, MABuilt 1943 · S/N 331H0
Back to AD 46-14-01