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.
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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N28648Lombardi Andrew J · Santa Paula, CAN28685Dienst Lon C · Poplar Grove, ILN28690Fortin Russell J · Linden, MIN28691Whelan Thomas M · Bethlehem, CTN2890Hagerstown Aviation Museum Inc · Hagerstown, MDN29009Mclean Diane A · Weirsdale, FLN29010Gonzales Donald M · Columbia Station, OHN295YWegmueller Daniel E · Monroe, WIN306WAllen Cheryl L · Hilltop Lakes, TXN336ESamuilov Vladimir A · Sound Beach, NYN37161Museum Of Flight Foundation · Seattle, WAN404Bertrand Jeff J · Willow, AKN46499Flying L Aircraft Inc · Fort Denaud, FLN47054Elrod Brent W · Cashion, OKN47590Nurge Richard J · Gilroy, CAN48320Schmidt Aaron B · Auburn, ALN48411Western Antique Aeroplane & Automobile Museum · Hood River, ORN49547Rice James L · Mc Kinney, TXN52427Hagerstown Aviation Museum Inc · Hagerstown, MDN52960Colvin Buster · Big Cabin, OKN57924Penrose Michael M · Ketchum, IDN58180Easy Air LLC · Wilmington, DEN607Forman Ronald M · Puyallup, WAN66143Rozzell Scott E · Houston, TXN690FAParsons Donald L · Saint Peters, MON77603Eastern Stearman Inc Trustee · Leesburg, VAN77611Denzler Theodore A · Friendswood, TXN77645Korta Stephen E · Poplar Grove, ILN77654Hettenbach Paul A · Carrollton, TXFirst renewal noticeN77657Kahl William E · Syracuse, NYN77658American Aviation Heritage Foundation Inc · Blaine, MNN77660Plane Fun Inc Tr Trustee · Snellville, GAN77661L & P Of Winona Inc · Winona, MNN77665Dougherty James W Jr · Arlington, TXN77671Ramos Richard E · Benicia, CAN77672Demmel Ross · Tumwater, WAN77686Harper Jack D · Jacksonville, FLN77688Short David J · Warrensburg, MON77691Hamilton Steven T · Carson City, NVN77695Kipnis Inc · Wadsworth, ILN77696American Airpower Heritage Flying Museum · Dallas, TXN77697Milne Sales And Services LLC · Lake Geneva, WIN77698Perez Philip G · Fort Worth, TXN81204Stone Craig J · Renton, WAN81207Higham James E · Atkins, IAN81208Latimer Mark A · Roanoke, TXN81210Fairchild Argus LLC · Evergreen, CON81212Bartholomew Russell J · Albuquerque, NMN81213Yanks Air Museum · Baldwin Park, CAN81214Letourneau Jaffe B · Olympia, WA
Back to AD 46-40-01