AD 2012-10-13
Registered aircraft · 13,306
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:2012-10-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-10-13')
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:2012-10-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-10-13') 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.
N446HKHotel Kilo LLC · Forest, VAN446MMInternational Air Services Inc Trustee · Carson City, NVN446MTValiair Lc Trustee · Casper, WYN446PMorris Danny J · Upland, CAN446PCStatius-Muller Robert C Trustee · Stamford, CTN446VBN4466vb LLC · Kalispell, MTN4471EWolfe John · Marathon, FLN4474MN4474m Inc · Camarillo, CAN4477HEisele Fly LLC · Fort Myers, FLN447BRCordogan Clark & Associates Inc · Aurora, ILN447CDCirrus Design Corp · Duluth, MNN447ESummers Mark A · Alpine, WYN447JSSchwertner Farms Inc · Schwertner, TXN4482WWheels In The Well LLC · Jonesboro, ARN4486WReynolds Eric Eugene · Weatherford, TXN448AMHetpath Aero LLC · Bismarck, NDN448BBHawkflight LLC · Sugar Land, TXN448DDillingham John E · Enid, OKN448JDavenport James A · San Antonio, TXN448LMKinzler William · Tierra Verde, FLN448SRAquatic Resources Management LLC · Lexington, KYN448TTScher Steven A · Sonoma, CAN448VAGr5 Aviation LLC · Branchburg, NJN448WBLda Aerial Services LLC · Alcoa, TNN449LLPlane Fun Inc Tr Trustee · Snellville, GAN449MRockys Aviation LLC · Portland, MEN449SRCline Aviation LLC · Travelers Rest, SCN449WMWissman Enterprises LLC · Lincoln, NEN44CCoyne Greg · Hondo, TXN44CBClint Bowyer Racing Inc · Clemmons, NCN44CTCadeco · Rochelle, TXN44DGTime Flies LLC · Fort Worth, TXN44ECN44ec LLC · Caddo Mills, TXN44EDFerrous Wheel Aviation LLC · Belleair Beach, FLN44EEEchemann Thomas A · Sidney, OHN44EMBk Holdings LLC · Marlton, NJN44GAFly Qts LLC · Oconomowoc, WIN44GZOpdahl Kirk J · Lees Summit, MON44HALaps LLC · Elkhorn, WIN44HRCardinal Aviation Services LLC · Castle Rock, CON44HSAmor Fati Aviation LLC · Chehalis, WAN44JHCirrusly Faster J2911 LLC · Duson, LAN44KCSpitfire Ix Inc · Wilmington, DENon-citizen corporation, flight hours not reportedN44KFEbert Construction Co Inc · Wamego, KSN44KRMcilhenny Edward A · Clayton, GAN44MVMrk Aviation LLC · Athens, GAN44NTTucker Nicholas B · La Canada, CAN44PZRegistered aircraftN44QGCirrus Design Corp · Duluth, MNN44SAGniks LLC · Nevada, MO
Back to AD 2012-10-13