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.

N28648Lombardi Andrew J · Santa Paula, CAS/N W40-148N28685Dienst Lon C · Poplar Grove, ILS/N W-40-168N28690Fortin Russell J · Linden, MIS/N W41A-111N28691Whelan Thomas M · Bethlehem, CTBuilt 1941 · S/N W41A-201N2890Hagerstown Aviation Museum Inc · Hagerstown, MDBuilt 1933 · S/N 2509N29009Mclean Diane A · Weirsdale, FLBuilt 1941 · S/N W41110N29010Gonzales Donald M · Columbia Station, OHBuilt 1940 · S/N W40-174N295YWegmueller Daniel E · Monroe, WIBuilt 1940 · S/N W40-102N306WAllen Cheryl L · Hilltop Lakes, TXBuilt 1939 · S/N R9-407N336ESamuilov Vladimir A · Sound Beach, NYS/N 2934N37161Museum Of Flight Foundation · Seattle, WABuilt 1941 · S/N W41A-206N404Bertrand Jeff J · Willow, AKBuilt 1940 · S/N 172N46499Flying L Aircraft Inc · Fort Denaud, FLBuilt 1943 · S/N W41A-577N47054Elrod Brent W · Cashion, OKBuilt 1940 · S/N R40-402N47590Nurge Richard J · Gilroy, CAS/N W41A509N48320Schmidt Aaron B · Auburn, ALS/N W41A-510N48411Western Antique Aeroplane & Automobile Museum · Hood River, ORBuilt 1940 · S/N 405N49547Rice James L · Mc Kinney, TXBuilt 1943 · S/N 578N52427Hagerstown Aviation Museum Inc · Hagerstown, MDS/N W41A-652N52960Colvin Buster · Big Cabin, OKBuilt 1939 · S/N 115N57924Penrose Michael M · Ketchum, IDBuilt 1945 · S/N W41A798N58180Easy Air LLC · Wilmington, DEBuilt 1944 · S/N W41A-800N607Forman Ronald M · Puyallup, WABuilt 1939 · S/N W109N66143Rozzell Scott E · Houston, TXBuilt 1941 · S/N W41A240N690FAParsons Donald L · Saint Peters, MOBuilt 1946 · S/N R46104N77603Eastern Stearman Inc Trustee · Leesburg, VABuilt 1946 · S/N R46-303N77611Denzler Theodore A · Friendswood, TXBuilt 1946 · S/N R46311N77645Korta Stephen E · Poplar Grove, ILBuilt 1947 · S/N R-46345N77654Hettenbach Paul A · Carrollton, TXFirst renewal noticeBuilt 1947 · S/N R46333N77657Kahl William E · Syracuse, NYBuilt 1947 · S/N R46316N77658American Aviation Heritage Foundation Inc · Blaine, MNS/N W46358N77660Plane Fun Inc Tr Trustee · Snellville, GABuilt 1946 · S/N R46-360N77661L & P Of Winona Inc · Winona, MNBuilt 1947 · S/N R46361N77665Dougherty James W Jr · Arlington, TXBuilt 1947 · S/N R46365N77671Ramos Richard E · Benicia, CABuilt 1946 · S/N R-46371N77672Demmel Ross · Tumwater, WAS/N R-46372N77686Harper Jack D · Jacksonville, FLS/N R46386N77688Short David J · Warrensburg, MOBuilt 1947 · S/N R46388N77691Hamilton Steven T · Carson City, NVBuilt 1947 · S/N R46391N77695Kipnis Inc · Wadsworth, ILS/N R46336N77696American Airpower Heritage Flying Museum · Dallas, TXBuilt 1947 · S/N R46337N77697Milne Sales And Services LLC · Lake Geneva, WIBuilt 1947 · S/N R46339N77698Perez Philip G · Fort Worth, TXBuilt 1947 · S/N R46398N81204Stone Craig J · Renton, WABuilt 1946 · S/N R46-105N81207Higham James E · Atkins, IABuilt 1946 · S/N R46-108N81208Latimer Mark A · Roanoke, TXBuilt 1946 · S/N R46-109N81210Fairchild Argus LLC · Evergreen, COBuilt 1946 · S/N R46-111N81212Bartholomew Russell J · Albuquerque, NMBuilt 1946 · S/N R46113N81213Yanks Air Museum · Baldwin Park, CABuilt 1946 · S/N R46114N81214Letourneau Jaffe B · Olympia, WABuilt 1946 · S/N R46-115
Back to AD 46-40-01