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.
N458BTBtr Aviation LLC · Somerset, PAN458CAircraft Guaranty Corp Trustee · Oklahoma City, OKN458CPEagle Aviation LLC · Hawarden, IAN458CTAratow Michael · Mountain View, CAN458DGIron Street Aviation LLC · North Kansas City, MON458DJSurvey America Inc · Rancho Cordova, CAN458EMEchomike Aviation LLC · Las Vegas, NVN458JHVliegtuig Holdings LLC · Kalispell, MTN458RHHamil Robert D · Houston, TXN458TTTurner George T · Alpharetta, GAN458TWFirst Aviation Co · Prospect Heights, ILN4592SMays Robert · Centerville, TNN4594CSt Johns Aviation LLC · Saint Johns, MIN4599FCcs Flight Services LLC · Benton Harbor, MIN459CDUrsine Teleportation LLC · Redmond, WAN459CPCal Poly Corp · San Luis Obispo, CAN459JAThundercock Industries Worldwide LLC · Las Vegas, NVN45BKTwo Six Ventures LLC · Fort Lauderdale, FLN45BVGrinberg Dmitry · Austin, TXN45CXRobin Aviation LLC · Plymouth, MIN45DMRaolji Mahendra · Florida City, FLN45FDFox Trot Delta LLC · Indianapolis, INN45GLOptimal Aircraft Management Nc LLC · Sanford, MIN45JNSpotts Marcus P · Nora Springs, IAN45KLOrloff Kenneth L Trustee · Groveland, CAN45KPColvin Clu D DBA · Big Cabin, OKN45KSRentals Deltona 2 LLC · Orlando, FLN45MEHarman Aviation LLC · Rockingham, VAN45MSBeech Flyers Inc · Champaign, ILN45PWEralet Inc · Middletown, DEN45PZPaxton Aviation Inc · Cambridge, MAN45TFWave Transportation LLC · Middletown, DEN45TRAltivian Holdings LLC · Camden, DEN45WTMccarthy Brothers Aviation LLC · Albany, KYN45XDSubstation Air LLC · Midvale, UTN45ZTCourter Industries Inc · Tampa, FLN4600UDlw Aviation LLC · Missoula, MTN4601WMike Papa LLC · Newton, KSN4604NS O W Aviation LLC · Crystal River, FLN4604QBas Part Sales LLC · Greeley, CON4607QSerrano Lynn A · Casa Grande, AZN4609UJerden Corp · Overland Park, KSN460CABravogolf Aviation LLC · San Jose, CAN460JPNewman Charles · Petaluma, CAN460SRBuchman Barry Joseph · Atlanta, GAN460WWMalibu Ww LLC · Fayetteville, GAN4610KAvag Inc · Richvale, CAN4612KChitiea Andrew D · Centennial, CON4617WSavoldelli Steven · Los Angeles, CAN4618MBedrock Siteworks LLC · Coatesville, PA
Back to AD 2012-10-13