AD 46-06-01
Registered aircraft · 117
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-06-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-06-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-06-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-06-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.
N48777Casa Acquisitions LLC · Winter Haven, FLN48931Eads Anthony C · Claude, TXN48996Weselmann Randall C · Bainbridge, INN49674Johnson Ronald D · Rockford, ILN49685Herron Kathleen H · Warren, PAN50644Airpower Museum Inc · Ottumwa, IAN50880Interior & Arctic Alaska Aeronautical Foundation · Fairbanks, AKN50884Ozarks Auto Show · Hollister, MON51122Durkee Michael S · Amelia, OHN51724Kromer Jeffrey B · Mount Carroll, ILN522MGeorge Mike · Springfield, ILN52508Debacker Michael A · Scotts Valley, CAN53003Coutches Robert H DBA · Livermore, CAN53004American Airpower Heritage Flying Museum Inc · Dallas, TXN53071Sale Reported · ChonburiSale reportedN53072Williams John D · Geneva, OHN53146Austin Bill DBA · Sparta, TNN53149Lestingi Thomas J · El Dorado Hills, CAN53190Acv Group LLC · Mckinleyville, CAN53271Nehus Christopher J · Camarillo, CAN53430Fletcher Flying Service 419 LLC · Labelle, FLN53431Zaathof Aero LLC · Foristell, MON54046Itm Aircraft LLC · Charleston, SCN54428Eeds Rex A · Claude, TXN54480Sale Reported · Groveland, CASale reportedN54876Regier Tom · Dinuba, CAN54907Dunn Emet C · Coolidge, AZN56017Don Warren D · Chandler, AZN56026Manzo Timothy S · Gainesville, GAN56030Tope Charles Norbert · Pebble Beach, CAN56034Edling Tyrell R · The Dalles, ORN56046Anderson Michael J · Carmichael, CAN56047Nordt John · Miami, FLN56048Brewer George F II · Colorado Springs, CON56076Hogan William J · Libby, MTN56081Bavarian Barnstormers 2 Inc · Fort Myers, FLN56535Willson Sheila T · Hollidaysburg, PAN56565Prop & Jet Air Museum Inc · Romoland, CAN56567Planes Of Fame Air Museum · Chino, CAN56711Gardner Air LLC · Paragon, INN57015August Aero LLC · Kalispell, MTN57026Western Antique Aeroplane & Automobile Museum · Hood River, ORN57081Freedman Michael T · Camarillo, CAN57085Dodge Inc · Wilmington, DEN57184N57184 LLC · Granite Falls, MNN57185Clear Blue Marketing Inc · Reno, NVN57264Strow Joan Helen · Tulsa, OKN57911Simply Living LLC · Fort Myers, FLN58614Uecker Tim M · Port Townsend, WAN58651International Air Services Inc Trustee · Carson City, NV
Back to AD 46-06-01