AD 2012-19-01
Registered aircraft · 51,501
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-19-01')
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-19-01')
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-19-01') 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-19-01') 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.
N10853St Johns Marine DBA · San Mateo, FLN1085G3foxtrot LLC · Tucson, AZN1085JFloyd Shea · Brownfield, TXN1085KSummermatter Richard C · Orchard Park, NYN1085SConnell Curtis C · Driggs, IDN1085WBas Part Sales LLC · Greeley, CON1085ZBeehive Communications Inc · Providence, RIN1086BState Of Alaska · Anchorage, AKN1086JRidgway Stephen · Avon, CON1086SDevito David E · Maple Valley, WAN1086TDutcher Pierpont E · Bend, ORN1087CPhoenix East Aviation LLC · Daytona Beach, FLN1087GBulzan Gary · Chardon, OHN1087JKalivretakis Anthony · Southington, CTN1087QFairway Auto Clinic LLC · Carlsbad, NMN1088FRegistered aircraftN1088JDreiling Richard J · Ft Collins, CON1088MVaeth George W · Dallas, TXN1088TSteenbergen Dale G · Cheyenne, WYN10897Edb Air Inc · Wilsonville, ORN1089BDakota Territory Air Museum Inc · Minot, NDN1089DHeavy Metal Air LLC · Farmingdale, NYN1089GMooney Technical Services LLC · Norfolk, VAN1089JBradford Johnny E · Sacramento, CAN1089XCoastal Aviation Partners LLC · Hubert, NCN108ACKaplan Steven M · Key Largo, FLN108AFRideout Melvin B Jr · Jarratt, VAN108AMTekton Aviation LLC · Austin, TXN108ATKirschner John R · Crystal Lake, ILN108BDMorgan Edward Tull Jr · Gaithersburg, MDN108CFCentral Flying Service LLC · Little Rock, ARN108CTDepartment Of Homeland Security · Washington, DCN108EAArellano Erick C · Brownsville, TXN108ED95 Msg/Svra Aero Club · Edwards Afb, CAN108EHPolar Star Corp · Kalispell, MTN108FBPlane Fun Inc Tr Trustee · Snellville, GAN108GGGraeser George W · Thousand Oaks, CAN108HCLemont Equipment LLC · Helena, MTN108HFHeritage Asset Leasing LLC · Ronkonkoma, NYN108HWYale Companies LLC DBA · Fishers, INN108JKustatan Leasing LLC · Nikiski, AKN108JGStilts Steven · Houma, LAN108JLStar Marianas Aviation School Inc · Saipan, MPN108LLLesher Lee A · Peyton, CON108LZNcb Realty LLC · Little Rock, ARN108MQArapahoe Flight Club LLC · Colorado Springs, CON108NSLyon Andrew L · Fairbanks, AKN108PFKeith Wilcox & Sons Inc · Rexburg, IDN108PTHenrie Aviation LLC · Fairfield, NJN108SGVahsholtz Matthew James · Conroe, TX
Back to AD 2012-19-01