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.
N955SRHigh Standards Aviation LLC · Laguna Beach, CAN955WGReich Stephen B · Kentfield, CAN955WTOne Bravo Papa LLC · Fairfield, CTN956CL & S Aviation Inc · Manassas, VAN956EALopez Fabio · Denver, NCN956PVTelcom Rentals Inc · Lake Charles, LAN956WPInfinity Aviation LLC · Comstock, WIN9577PAccelero Aircraft Leasing LLC · Hendersonville, TNN9577YShort Notice Inc · Pensacola, FLN957PJN957pj LLC · Parker, CON958CCSolomon Mark Trustee · Wilmington, DEN958CDSkybound Air LLC · Seminole, TXN958HCHydroair LLC · Auburn, ALN958PDrew Jensen Inc · Lincoln, NEN958PBMo Elite Air LLC · Rolla, MON958PGMckaviation LLC · Mooresville, NCN958PTPayne Jeffrey Dwayne · Lubbock, TXN958SScepter Aero LLC · Waverly, TNN958WDBrush Art Corp · Downs, KSN959CDCrescent Beach Aviation LLC · Myrtle Beach, SCN959DCKpp Air LLC · Navasota, TXN959DRTorgerson Co LLC · Turtle Lake, WIN959GKFarmview LLC · Saint Louis, MON959RHRd Holdings LLC · Las Vegas, NVN959TXAhern John · Prosper, TXN959WTAgave I LLC · Seattle, WAN95ATSellers Paul Matthew · Cresson, TXN95BHSale Reported · Lacombe, LASale reported, canceledN95CMStambaugh Scot D · Gig Harbor, WAN95EERjt&E LLC · Spring, TXN95GTInternational Air Services Inc Trustee · Carson City, NVN95HMJ C Boyd Custom Builders LLC · Gainesville, TXN95JRKaiser Dennis · Portland, MEN95PPeddinghaus Corp · Bradley, ILN95SEEwm LLC · Kansas City, MON95TFSage Mgmt LLC · Carefree, AZN95VPVarsity Produce Sales Inc · Bakersfield, CAN95WHPage William R · Bermuda Dunes, CAN95ZGGulfshore Leasing And Services Inc · North Aurora, ILN96007Air Tango Delta LLC · Mountain Brk, ALN9604GRoberts Development Company Inc · Tucson, AZN9607YIsn Aviation LLC · Loup City, NEN960ALAircraft Trustee Serrvices Inc Trustee · Dover, DEN960BGGokce Baran · Plantation, FLN960BPCavu Enterprises LLC · Atlanta, GAN960CM960 Charlie Mike LLC · Santa Rosa, CAN960DFAir Services International Leasing LLC · Fort Lauderdale, FLN960JAN215mt LLC · Port Orange, FLN960PDodson International Parts Inc · Rantoul, KSN960TMCirrus Design Corp · Duluth, MN
Back to AD 2012-10-13