AD 2012-03-52
Registered aircraft · 522
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-03-52')
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-03-52')
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-03-52') 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-03-52') 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.
N197BLAm Aviation LLC · Boerne, TXN197DTSzczerba Francis C · Cranberry Township, PAN197RMHjh Aviation LLC · Gordo, ALN199MDSurgair Inc · Absarokee, MTN2009FBowman And Dehn Enterprises Inc · Georgetown, DEN200VPDrp Aviation LLC · Southlake, TXN2011TEfferson Randal K · Lapine, ALN201QPDesert Outdoor Advertising Inc · Bend, ORN2021MKunkel David L · Boulder, CON204GXAircraft Guaranty Corp Trustee · Oklahoma City, OKN205BFWells David L · Neosho, MON205BZEmbedded Advantage LLC · Chelsea, MIN207ARKanfei Harauch Air LLC · Cleburne, TXN209HWWep Ent LLC · Graford, TXN211MJKeefer Squared LLC · Rockmart, GAN211TSMartin Rolf Michael · Wellsburg, NYN2120XGolberg Companies Inc · Garfield, MNN2121SGreat Bay Aviation LLC · Spring Hill, FLN2126SGarnet Ridge LLC · Brooksville, FLN212DMiller William K · Flat Rock, NCN212TAJensen Paul · Exeter, NEN2138ZPyle Richard B · El Paso, TXN21434Ad-A-Note LLC · Tarentum, PAN2144PVanderhoof Brian L · Purcellville, VAN2145XMitchell Derrick · Winter Park, FLN214DAFlight International Inc Trustee · Dover, DEN214JSChavez Frederick J · Temecula, CAN2153KCaf Design LLC · Wilmington, DEN2155ECavu Aviation LLC · Sugar Grove, ILN2155KCurrent Obsession LLC · Gaylord, MIN2157LAviation Medical Solutions Pllc · Mesa, AZN2158N2th Aviation LLC · Johnson City, TNN2159ER & S Investment Partners LLC · Kennesaw, GAN2161SRegistration Pending · Montezuma, NMRegistration pendingN21625Simpson Aaron J · Fort Smith, ARN2164KSamojen Tony J · Camarillo, CAN216RAK&E Equipment LLC · Hammond, LAN21786Affinity Insurance Partners Inc DBA · Clearwater, FLN2182HSpangler & Pion LLC · Davis, CAN2183ALee Christopher M · Port Jervis, NYN21843Robertson James D Trutee · Mountain View, CAN2192JMcguire Robert · Hawthorne, FLN2197HGprr Inc · Downers Grove, ILN21KUAero Eagle One LLC · Kerrville, TXN21MSVan Hanna Flying Circus LLC · Castle Rock, CON2204LMccann Richard H · Shuqualak, MSN2209MGarner Aviation LLC · Tampa, FLFirst renewal noticeN2210YN2210y LLC · San Antonio, TXN22166Reading Jared T · Uvalde, TXN22184Rosene Richard W · Newport, RI
Back to AD 2012-03-52