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.
N2708SQuiroga Herman R · Phoenix, AZN2708TCae Aviation LLC · Peshtigo, WIN2708YWings Aircraft LLC · New Richmond, WIN2709BA&R Investments Inc · Sylvania, OHN2709RSchultz Daniel A · Tipp City, OHN270ADRay Dani · Fall River, MAN270ARDuffy Kevin · Manchester Center, VTN270MRFurtado William J III DBA · Fremont, CAN270MWM9 Aviation Ventures LLC · Philadelphia, PAN270RCEagle 1-N270rc LLC · San Juan, PRN270WL270wl Aviation LLC · Owensboro, KYN2710JPeople Incorporated Of Virginia · Abingdon, VAN2711NMountain Air Aviation LLC · Fruit Heights, UTN2712FDodson International Parts Inc · Rantoul, KSN2714CLipcon James P · Stow, MAN2715TDelaware Aircraft Trust LLC Trustee · New Castle, DEN2718YRichland Aviation Inc · Sidney, MTN271CPCharlie Hotel Mike LLC · Lincoln, NEN271EOuray Ventures LLC · San Diego, CAN271NPJust Plane Stuff Inc · Jackson, MSN271PBClark Mayer Aviation LLC · Cross Roads, TXN271SRGriffin James R · Pinedale, WYN271WMFarm Dog Holdings LLC · Reedley, CAN2720ABaron N2720a LLC · Faulkton, SDN2727LAircraft Trustee Services Inc Trustee · Dover, DEN2729LVip Wellness LLC · Victoria, TXN272CDSegers Ernst E · Pensacola, FLN272CSTres Vientos LLC · Santa Fe, NMN272CTInncal Inc · Stockton, CAN272DDelta Delta Aviation LLC · Pickerington, OHN272EVSanderlin Aviation LLC · Seattle, WAN272HMBas Part Sales LLC · Greeley, CON272RHLewis Coleman · Dallas, TXN272TMRam Precision Industries Inc · Dayton, OHN2730MSua LLC · Artesia, NMN2730PRegistration Pending · Palm Harbor, FLRegistration pendingN2732TJellor Realty Inc · Los Angeles, CAN2734BStella Air Inc · Wyoming, PAN2734GSplit Rock Aerospace LLC · Southport, CTN2735JAlpha 414a LLC · New Smyrna Beach, FLN273DTN273dt LLC · Abilene, TXN273DVD&K LLC · Sioux Falls, SDN273ESTailwinds Aviation LLC · Windham, NHN273MMValiair Lc Trustee · Casper, WYN273NFTrk Management LLC · Punta Gorda, FLN273RVMev Aviation LLC · Fort Lauderdale, FLN2740TKraybill Paul D · Portola Valley, CAN2742HWilbert John W III · Plaquemine, LAN2743JColman Scott · Tampa, FLN2744PTouchdown LLC · Pls Vrds Est, CA
Back to AD 2012-10-13