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.
N817AMDiversified Air Services LLC · Edmond, OKN817BGBcac Air Ventures LLC · Weatherford, TXN817BJMax Flight LLC · Amherst Junction, WIN817BKChase Aviation Co LLC · Jamestown, NYN817CVAltier Aviation LLC · Throop, PAN817DGAuto Mark Inc · Bismarck, NDN817DLAltidudes LLC · Atlantic Beach, FLN817GCMountain View Aeromotive Inc · Del Norte, CON817GFHarvey Michael · Coppell, TXN817HHS&M Partners LLC · Carmel, INN817JPOdom Johnny C · Fredericksburg, TXN817LAUnger William · Missouri City, TXN817NMWest Bound Hound LLC · Sheridan, WYN817PHPhh Family Equipment Holdings LLC · Fort Worth, TXN817RMOmega Metals Inc · Douglasville, GAN817SEChh Aviation Inc · Tyler, TXN817SRMarsh Aviation LLC · Old Lyme, CTN817TAAspen Aviation Inc · Crown Point, INN817TMHorn Associates LLC · Brookline, MAN817WTN817wt LLC · Omaha, NEN8181VPebble Alternative LLC · Harahan, LAN8183EGuardado Rodolfo · Sun Valley, CAN8183MHaman Peter A · Douglas, WYN8184NB & S Holdings LLC · Augusta, GAN8188QI Will Rise LLC · Chattanooga, TNN8188RRepka Michael Jeffrey · Glenbrook, NVN8189Doan Aviation LLC · New Hope, PAN818AB818ab LLC · Gainesville, FLN818ANBank Of Utah Trustee · Salt Lake City, UTN818CSSands Christopher W · Chandler, AZN818DLTt1 Marine LLC · Key Largo, FLN818ELN22tq LLC · Lehi, UTN818GMDodson International Parts Inc · Rantoul, KSN818HWHannah Mary Aviation LLC · Camden, DEN818JECbft LLC · Mobile, ALN818JPN818jp LLC · Los Angeles, CAN818LARegistered aircraftN818LMTop Flight Holdings LLC · Bluffdale, UTN818LTAirworthy LLC · Scottsdale, AZN818PDesmet Paul F · Mercersburg, PAN818PCWindigo Transportation Inc · Waterloo, IAN818PKAdamant Hangars LLC · Erie, CON818PRMalus Flyers LLC · Henderson, NVN818TBSmith Av LLC · Kalispell, MTN818WKTennessee Wk LLC · Wappingers Falls, NYN8190GSchubert Jackie E Jr · Jamestown, TNN8191KSummerfields Animal Hospital Pllc · Fort Worth, TXN8195QD&M Enterprise LLC · Wilmington, DEN8198MGokul LLC · Landrum, SCN819BWCirrus Design Corp · Duluth, MN
Back to AD 2012-10-13