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.
N321MDBrown Melvin W Jr Trustee · Shady Shores, TXN322PMMsr Aviation LLC · San Diego, CAN322RWKraemer Jeremy A · Melrose, MNN323DMWard Frank J · N Richland Hills, TXN326TJBarnett John M · Fredericksburg, TXN330CFFox Claire S · Los Angeles, CAN332LCockerell William C Trustee · Zephyr Cove, NVN333LPCoberly Steven C · Wilmette, ILN333YCSky West Aviation Inc Trustee · Albuquerque, NMN334FLChampionx LLC · Sugar Land, TXN33GXSiman-Tov Yariv · Redmond, WAN341JSTibbs Jeffrey M · Lakewood Ranch, FLN341PSWestern States Air LLC · Phoenix, AZN345DTPlane Fun Inc Tr Trustee · Snellville, GAN345PAInternational Air Services Inc Trustee · Carson City, NVN345TFWilkinson Mark A · Lincoln, MAN345USAvion Solutions Group LLC · Apex, NCN348CBJmj Aviation LLC · Kalispell, MTN349BPLundeen Matthew L · Tigard, ORN34DBRegistered aircraftN34MESwift Ascent LLC · Dover, DEN3535RMannion Paul R · Mentor, OHN357AFour Leaf Air LLC · Cedar, MIN359PCCory A Birnberg Pc · San Francisco, CAN359PSMoondancer LLC · Vacaville, CAN35FCTransonic Inc · Auburn, CAN35MDGarbalosa Ryan · Myrtle Beach, SCN368CMKraemer Jeffrey J · Cold Spring, MNN37MGWood Ronald G · Weatherford, TXN380MMFolk Daniel H · Urbana, ILN381LMorgan Fred M · Onancock, VAN3833TN413zm LLC · Terre Haute, INN393PSVein C Jason · Riviera Beach, FLN393SRColbyco Jet Management LLC · Keller, TXN395MRParamount Risk Mgmt And Insurance Scvs LLC · San Luis Obispo, CAN39HWApple & Vine Aviation Services LLC · Reidsville, GAN401PSLesmeister Dean · Kindred, NDN404WMArmbruster LLC · Amherst, OHN409PCSmith Lowry Carl Trustee · Leedey, OKN40AUBkf Aviation Ltd · Brookline, MAN40CFG&M Flyers LLC · Wilmington, DEN410AGRg Rentals LLC · Las Vegas, NVN410MBHall Donny K · Cookeville, TNN410RRGarrison Concrete Systems LLC · Scottsdale, AZN411JLCrowell Robert J · Rockwall, TXN411TXGilbert Ivory M · Bonita Springs, FLN413EM413em LLC · Columbia, ILN416USClepper Francis D Jr · Bennington, NEN41HTJacobs Gregory R · Pinole, CAN422SSInternational Air Services Inc Trustee · Carson City, NV
Back to AD 2012-03-52