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.
N330DPAdvanced Commercial Group LLC · Helena, MTN330FFFarrington Aviation LLC · Houston, TXN330HCTf Op LLC · Houston, TXN330MRJett Aviation LLC · Clovis, NMN330RMCastle Rock Services LLC · Helena, MTN330STBon Air LLC · Chickasha, OKN3313HTriple H Capital Holdings LLC · Newark, DEN33167Twincat Aero LLC · San Diego, CAN33189Schrage Rodney L · Steamboat Springs, CON331APSugar Creek Partners LLC · Rogers, ARN331CBN331cb LLC · Great Falls, MTN331EDDaniel Dunagan Inc · Rome, GAN331KKK&K Aviation LLC · Anthem, AZN331SMApex Aviation LLC · Farmingdale, NYN331STFoothill Fire Protection Inc · Loomis, CAN331TFCapital Holdings 244 LLC · Dover, DEN331WGRegistration Pending · York, PARegistration pendingN331WPFms Management System LLC · Dover, DEN331WVDeaver John · Waco, TXN3321MMaxray Aviation LLC · Ashland, OHN3322XAllgood Michael K · Saint Augustine, FLN332CBFlying Pigs Aviation LLC · Los Altos, CAN332CDDuggar Aviation LLC · Springdale, ARN332DAHanford Equipment LLC · Eagle, IDN332EFalconeer LLC · Gainesville, FLN332GTArminair LLC · Dover, DEN332LMLumbra Ronnie E · Rye, NYN332MBLee Aviation Services Co LLC · Pensacola, FLN332MMRan Health Services Inc · Modesto, CAN332PKCirrus Design Corp · Duluth, MNN332RMCbc Media LLC · Nantucket, MAN332TTAlta Vista Enterprises LLC · Sheridan, WYN3332BAirkrapf LLC · Clearwater, FLN3333MFun Tickets LLC · Manchester, MEN3337Chay James M · Kent, WAN333AMLally Glen Joseph · Pleasanton, CAN333ANNahale Properties LLC · Littleton, CON333AQAqe LLC · San Diego, CAN333ARLe Bon Air Inc Trustee · Wilmington, DEN333BCMcfadden John L · Cresson, TXN333CFTimewarp Aviation LLC · Trout Valley, ILN333DAFavor Michael D · Chico, CAN333GKCenturion210 LLC · Amherst, NHN333HRWilson Alan E Trustee · Erie, CON333JRLeonard Reid J · Hilton Head Island, SCN333JTHaidar Aviation LLC · Dallas, TXN333KQQuarles Transportation LLC · Bolivar, MON333LB333lb LLC · Fort Worth, TXN333LLNutex Concepts Of North Carolina Corp · Lenoir, NCN333LZSkylane Partners LLC · Memphis, TN
Back to AD 2012-10-13