AD 50-32-01
Registered aircraft · 1,118
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:50-32-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:50-32-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:50-32-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:50-32-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.
N10133Fisher Charles R Jr · San Antonio, TXN10145Hensarling Matthew L · Elizabeth, CON105ERSokoloski James J · Lampasas, TXN1069Byrne Sofia V · Merrimack, NHN109DSBell Bradley L · Bothell, WAN109FRoos Patrick R · Purcellville, VAN10GGMartinelli Alexander Joseph · Waco, TXN1101WObrien A Scott · Camarillo, CAN116FTaylor John · Mammoth Spring, ARN117DPMccollum Michael T · Camarillo, CAN119DDColeman Russell L · St Charles, ILN11AXLoukopoulos George Matthew · Tucson, AZN11ESale Reported · Wayne, NESale reported, canceledN11FCCooper Matthew A · Seattle, WAN11FZHolguin Steven · Hayward, CAN1208UPulliam Anthony L · Lancaster, CAN1220Technical Education Services Inc T/A · Virginia Beach, VAN124RSHenley Charles D · New London, NCN133MGolden Age Flight Museum · Bakersfield, CAN135YSpruill William F · Wyoming, DEN137MFHuston Lee E · Graham, WAN138TOnderko George C · Fairmont, WVN13EGo Leasing Co · Phillipsburg, KSN14147Pugsley Len · East Wenatchee, WAN142RNNelson Robert J · Carbondale, ILN14661Badenhope John R · Greeneville, TNN146DSale Reported · San Diego, CASale reportedN149DSBuffaloe Thomas N · Mancos, CON149EDR&R Unlimited Inc · Alma, ARN1516ZTulin Gary N · Sedona, AZN151VTMitchell Matthew J · Penn Yan, NYN157MDDunbar Kevin R · Belmont, NCN1599VQuigley Ryan P · Chemung, NYN15JFHumanitarian Airlift International · Owasso, OKN1604BCromley Mark C · Lewisburg, PAN1614BRogers Raylon R DBA · Wellston, OKN1615BCox Kenneth L · Fremont, NEN1625BPrice Ronald W · Sonoma, CAN1627BDinnis Wesley J · La Center, WAN1629BSorenson Fred C · Las Vegas, NVN1631BConservative Three LLC · Taft, CAN1632BGirouard Richard J Jr · Anchorage, AKN1634BPruitt Kerry Pat · Nacogdoches, TXN1641BVance Kenneth W · Dolores, CON1642BWestern Antique Aeroplane & Automobile Museum · Hood River, ORN1659BPhilbrick Rodney C · Bishop, CAN1661BCromley Mark C · Lewisburg, PAN1666BRamin R Fred · Tomball, TXN1680BPearce Rick Alan · Parsons, KSN1684BGreissing John P · Aguila, AZ
Back to AD 50-32-01