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.
N455KGMiguel Paul A · Canyon, TXN455MVGrand Sierra Investments LLC · Kingfisher, OKN455PN455p LLC · Fulshear, TXN455PCPch Inc · Roseville, CAN455RMRomeoav8 LLC · Houston, TXN455SDJ&L Aviation LLC · Malta, NYN455SPSrb Aviation LLC · Pewaukee, WIN455SRScottie Dog Air LLC · Wilmington, DEN455TBSmith Loren D · Great Falls, MTN455TCTompkins Landing Lc · Wayne, NEN4560KRegistered aircraftN4566MPalacios Luis A · El Paso, TXN4567ZMae Enterprises LLC · La Porte, INN4568NBergren Scott W Trustee · Walnut Creek, CAN456ACHotel Quebec I LLC · Mount Pleasant, SCN456ADStafford Arthur · Oak Bluffs, MAN456ATBonanza Aircraft Lc · Steamboat Springs, CON456BRPressurized LLC · Sequim, WAFirst renewal noticeN456BWCustom Wholesale Supply Co Inc · Odessa, TXN456DCCatalpa Holdings LLC · Las Vegas, NVN456DRSky West Aviation Inc Trustee · Albuquerque, NMN456GGCoward Lawrence Jayson · Paris, TXN456HWestwind Inc · Marina, CAN456HTDumbo II LLC · Omaha, NEN456JMLandmark Aviation Services LLC · Sarasota, FLN456KGDesk Aviation Inc · Las Vegas, NVN456KMKilo Mike Aviation LLC · Chandler, AZN456LEAerospace Trust Management LLC Trustee · Wilmington, DEN456LL2fly-Safety LLC Trustee · Azle, TXN456MGJones Daniel S Trustee · Hendersonville, NCN456MPAhgl LLC · San Diego, CAN456PSGaston Trevino Jr · Brownsville, TXN456PWMilnar Greg · New Richmond, WIN456RTMassive Solutions LLC Trustee · Denton, TXN456STMcbride Ken · San Martin, CAN456WPMatagorda Production Co · Westhoff, TXN4570KHead East Aviation LLC · Geneseo, ILN4576KPope James Dean · Lewiston, IDN4577LLucas John · Norco, CAN4578NAviation International LLC · El Paso, TXN4579NSeven Eight Juliet LLC · Edmond, OKN457BBRlm Investment Holdings LLC · Wilmington, NCN457CBPreferred Aviation Technologies LLC · Mooresville, NCN457DKMiller Gordon J Jr · Monaca, PAN457DMMajor Development LLC · Cedaredge, CON457DTMathew Reggie T · Satellite Beach, FLN457FDCirrus Design Corp · Duluth, MNN4580KHarrah Daniel R · Juneau, AKN4589NGeneric Implant Solutions LLC · Pratt, KSN458BBLeonard Aviation LLC · Ponte Vedra Beach, FL
Back to AD 2012-10-13