AD 2012-10-52
Registered aircraft · 2,750
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-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-10-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-10-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-10-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.
N264ME618 Aviation LLC · Kosse, TXN26509Bell Air LLC · Belleville, KSN2650VSampson Merle A · Inver Grove Height, MNN2656SPierini William C · Chico, CAN266BBJk Air LLC · Duncan, OKN2673SWilliams Randall S · Chico, CAN267ABConcrete Experts LLC · Colorado Springs, CON267JMMathews Development Co · Santa Rosa Beach, FLN268HPFlorida Highway Patrol · Tampa, FLN26NZBank Of Utah Trustee · Salt Lake City, UTN26PMHill Capital Leasing LLC · Scottsdale, AZN26VRReed Edward · Marcellus, MIN2704WSpillman David T · Flagstaff, AZN270MEMm Aviation LLC · Casa Grande, AZN270MRFurtado William J III DBA · Fremont, CAN270SPSan Pedro Aviation LLC · San Antonio, TXN271JLSouthwest Aviation Enterprises · Haslet, TXN271LDVan Well Trucking LLC · Dallas, ORN273METopel Holdings LLC · Scottsdale, AZN2743JColman Scott · Tampa, FLN274CPCivil Air Patrol · Maxwell Afb, ALN274HAPacific Rain Inc · Arroyo Grande, CAN278JHRaytheon Co · Tucson, AZN278TMBuena Vista Aviation LLC · Fresno, CAN27BSl Leasing Group LLC · Barnesville, GAN27DVDodson International Parts Inc · Rantoul, KSN27GPFlying Colors Airparts Inc · Leesburg, FLN27VANorton Mark H Trustee · Stateline, NVN2814QGill Robert L · Dixon, CAN281WSWight David · Alvin, TXN28206Huey David G · Sumas, WAN2829JSunrise Aviation LLC · Las Vegas, NVN283RDBengtson Douglas Richard · Woodinville, WAN283TBNance Joseph W · Fort Collins, CON2856QFoster Aaron J · Missoula, MTN285DVJohnson Jeffrey L · Fargo, NDN285JLLink Air Service LLC · Minong, WIN286TCJb Aviation LLC · Waxahachie, TXN2874EMoutafian Adom · Los Gatos, CAN288JYNational Aircraft Leasing Corp · Greenville, DEN28LZLindemann Thomas · Gustine, CAN28RSElohim Airparts Sales LLC · Naples, FLN29003R J Kielty Plumbing Heating And Cooling Inc · New Port Richey, FLN29084D E C Holdings · Hansen, IDN29113Figueroa Angel Lara · Winfield, ALN29138Allen Brent H · Mammoth Lakes, CAN29151Inland Aerial Surveys Inc · Riverside, CAN29164Iturriria John · Kuna, IDN29176Tgr Helicopters · Fresno, CAN29188Rugger Investment Group LLC · Tustin, CA
Back to AD 2012-10-52