OpenAirDocs.org
AD 46-38-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-38-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-38-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.

N1019NYonge Lawrence W Jr Trustee · Ocklawaha, FLBuilt 1946 · S/N B-30N121SRStick And Rudder Aviation Inc · Middletown, DEBuilt 1940 · S/N 1084N159FFreshwater Adventures Inc · Dillingham, AKBuilt 1944 · S/N B55N21AD B Aero Inc · Wilmington, DEBuilt 1946 · S/N B129N22932Runyon Aviation LLC · Fort Worth, TXBuilt 1946 · S/N B-139N270DBBrown Daniel A · Gettysburg, PABuilt 1944 · S/N B117N291VWBowe Walter C Trustee · Sonoma, CABuilt 1942 · S/N 1188N327Damico Samuel P · Pittsford, NYBuilt 1958 · S/N 1051N329Nichols Charles F Trustee · Baldwin Park, CABuilt 1945 · S/N B-140N345GG3g Classic Aviation Inc · Wilmington, DES/N B101N39FGDiesel Acquisitions LLC · Milpitas, CABuilt 1939 · S/N 1059N401SJMayes Brett R · Williams, CABuilt 1943 · S/N 1168N42GLValadez Goose LLC · Helena, MTS/N B-52N4575CInternational Air Services Inc Trustee · Carson City, NVS/N B-120N48550Uss Alabama Battleship Foundation Inc · Mobile, ALBuilt 1939 · S/N 1061N5548AStage One Associates LLC · Oxford, CTBuilt 1959 · S/N 75-7661N600ZEMike Rinker Aircraft LLC · Union City, TNBuilt 1943 · S/N B-100N68157Registration Pending · Mount Pleasant, TXRegistration pendingBuilt 1947 · S/N 1138N69263Wilhite Randy J · Jackson, MIBuilt 1944 · S/N 1132N6DFMabee Roy W · Meridian, IDBuilt 1945 · S/N B-128N703B-81 LLC · Anchorage, AKBuilt 1946 · S/N B-81N7211Stage One Associates LLC · Oxford, CTBuilt 1944 · S/N B24N741Damico Samuel P · Pittsford, NYBuilt 1946 · S/N B-97N74588Southern Cross Aviation LLC · Roanoke, TXBuilt 1962 · S/N 1165N778L-13 LLC · Blaine, MNBuilt 1943 · S/N B-56N7811Evergreen Aviation & Space Museum · Mcninnville, ORBuilt 1942 · S/N B-122N7821Yanks Air Museum · Baldwin Park, CAS/N B-47N789Alaska Aviation Museum · Anchorage, AKBuilt 1943 · S/N B-102N88821Tongass Historical Society Inc · Ketchikan, AKBuilt 1942 · S/N 1157N9074NSanders Dennis · Ione, CAS/N B142N9074UWilhite Randy J · Jackson, MIS/N 1129N95467Pemberton Addison J · Spokane, WABuilt 1942 · S/N 1161N9750ZAukes Brian E · Huxley, IAS/N B-32N985RCollings Foundation Inc DBA · Hudson, MABuilt 1951 · S/N B-86N9KLOzark Management Inc · Jefferson City, MOBuilt 1956 · S/N B-8
Back to AD 46-38-01