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.
N327SRBisous Dange LLC · Virginia Beach, VAN327TALeblanc Joseph E Jr · Houston, TXN327WKAvion Sr22 LLC · Inverness, ILN3288MClute Kenneth N · Las Vegas, NVN328CPX Aviation LLC · Brooksville, FLN328CWBulldog Aviation LLC · Charleston, SCN328DATfo Aircraft LLC · West Chester, PAN328DJAltru Diagnostics · Houston, TXN328DKHigh Flight Adventures LLC · Ogden, UTN328EMConcierge Diamonds Inc · Los Angeles, CAN328JWL & R Cirrus Inc · Portage, PAN328LJYouderian Construction Inc · Stanford, MTN328MN328m LLC · Marion, INN328MBN328mb LLC · Old Bridge, NJN328MCHelix Aviation LLC · Bar Harbor, MEN328PStrother J Barron · Santa Rosa Beach, FLN328PMMayworm Patrick · Mclean, VAN328RHEchemendia Joel · Kissimmee, FLN328SRStarr Robert J · Burlington, VTN328TJTasker Jerome · Midland, GAN328WHLegends Air Center LLC · Bentonville, ARN3292MHyannis Air Service Inc · Hyannis, MAN3296PMadlener Michael J · Pahrump, NVN329JTAms Leasing LLC · New Oxford, PAN329RMNova Aviators LLC · Great Falls, VAN329SFChampion Air LLC · Louisville, KYN329SRHorn Russell · Woodbridge, CAN329WB329 Whiskey Bravo LLC · Provo, UTN329WTMach 10 Aviation LLC · Portland, ORN32AJFreedom Plane LLC · Freedom, NHN32ATSavrey LLC · Austin, TXN32AZChristian Brothers Aviation LLC · Dalton, GAN32BLHeiser And Associates Inc · Novato, CAN32DFMillford Aviation LLC · Waukesha, WIN32EPCaravelle Aviation LLC · Farmingdale, NYN32ETFront Side LLC · Heber City, UTN32GRAngella Tony · Fort Lauderdale, FLN32HCDrake Sr22 LLC · Franklin, NCN32HWStrader John Kelly · Brenham, TXN32JGBlackbird Florida LLC · Deerfield Beach, FLN32MCCook Tracy L · Prosper, TXN32MFHistick Logistics LLC · Camden, DEN32MZRegistered aircraftN32TBBoyland Todd · Solon, OHN32VSpeer Aviation LLC · Evansville, INN32VSCraftline LLC · Delray Beach, FLN32WBFly Away LLC · Aguanga, CAN32ZGSky 4 Holdings LLC · Kaysville, UTN330ATTower Capital Aircraft Holdings LLC · San Antonio, TXN330CDDec Enterprises LLC · Naples, FL
Back to AD 2012-10-13