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.
N61CPFlying Df'S LLC · Dover, DEN61CZWinfort Aviation LLC · Chino Hills, CAN61FABulldog Aviation LLC · Dover, DEN61GEReal Estate Affiliates Of Telluride LLC · Telluride, CON61GTFogle Dennis · Pella, IAN61JSAltitude & Perspective LLC · Galivants Ferry, SCN61KRUnderground Racing LLC · Helena, MTN61LBBober Ronald J · La Porte, INN61SASierra Alpha Holdings LLC · Albany, NYN61TZDrakkon Aviation LLC · Las Vegas, NVN61WEWesco Logistics LLC · Dover, DEN61WPBv Aviation LLC · Milwaukee, WIN61WWKingsboro David · Menifee, CAN61ZPAircraft Guaranty Corp Trustee · Oklahoma City, OKN6202BGamache Daniel S · Pleasanton, CAN6209C8 Waters LLC · Goodyear, AZN6209PFly Fast Live Slow LLC · Chiefland, FLN620AAKinser Todd · Custer, SDN620ABViridian Aviation LLC · Centennial, CON620ATAdco Aviation LLC · North Hollywood, CAN620DFCirrus Consequences LLC · Jacksonville, FLN620ECRed Fifes LLC · Coos Bay, ORN620HAMerrion Aircorp Inc Trustee · Wilmington, DEN620MVLegends Air Center LLC · Bentonville, ARN620RJLim Flt Inc · San Francisco, CAN620TDAct Five LLC · Moultonborough, NHN6211BFleming Patrick J Trustee · Palm Desert, CAN6212CJensen Consulting Service LLC · Valparaiso, INN6218YLucky Star Auto Sales Inc · Grangeville, IDN6219CAbbott Todd Christopher · Houston, TXN621AKelsey John · Casa Grande, AZN621ARLt Dream LLC · Boerne, TXN621CFArkwell Kathy A · Peoria, ILN621CMRhude Steven A · Niceville, FLN621DEDesert Excavating Inc · Yuma, AZN621DGQ Continuum LLC · Austin, TXN621EREdair LLC · Fort Lauderdale, FLN621FWFrancis Wayne Ltd · Springfield, OHN621GBCirrus Design Corp · Knoxville, TNN621GGDalsheim John S Trustee · New York, NYN621JCEri Air LLC · Fresno, CAN621JPMaster Aviation LLC · Intl Falls, MNN621KAcg Aviation LLC · Longview, TXN621LWMwatts Holdings LLC · Readyville, TNN621RHSchiffer Herbert · West Chester, PAN621RJWheels Up LLC · Ada, OKN621RTLegacy Specialties Inc · Minden, NVN621SLFarm Boys Investments LLC · Los Altos, CAN621SMSierra Mike LLC · Crystal, MIN621WYShowalter Richard L · Beckley, WV
Back to AD 2012-10-13