OpenAirDocs.org
AD 2010-26-05 R1

Registered aircraft · 1,068

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:2010-26-05-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2010-26-05-R1')
  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.

N622WMCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2005 · S/N 147N623HDK & M Aviation Holdings I LLC · Hartville, OHBuilt 1996 · S/N 35N623RMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2004 · S/N 53N626AWHfl Aviation LLC · Dallas, TXBuilt 2006 · S/N 168N627CRArrowhead Aviation Inc · Batesville, ARBuilt 1999 · S/N 048N627LGLive Mas Enterprises LLC · Greenwood Village, COBuilt 1995 · S/N 14N62LXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2008 · S/N 162N62NWE7 Alpha LLC · Austin, TXBuilt 2009 · S/N 233N630BANix Patterson Llp · Austin, TXBuilt 2013 · S/N 712N630VCAnanim LLC · Lincolnwood, ILBuilt 1998 · S/N 071N632PBModern Transportation Company Inc · Owensboro, KYBuilt 1995 · S/N 17N636SJHrm Aviation LLC · Chesterfield, MOS/N 104N639MWilmington Trust Co Trustee · Wilmington, DEBuilt 2015 · S/N 733N63FSIron Senergy Legacy LLC · Louisville, KYBuilt 2000 · S/N 132N63JPZap Magic LLC · New Castle, DEBuilt 2010 · S/N 249N640MSArtis 1 LLC · Miami, FLBuilt 2004 · S/N 31N644RVFrankcrum Corporate Inc · Clearwater, FLBuilt 1996 · S/N 22N649TTTownes Aircraft Sales LLC · Paris, TXBuilt 2005 · S/N 342N653FJDwts LLC · Powder Springs, GAS/N 110N655PEDunbar Aviation LLC · West Kingston, RIBuilt 1982 · S/N 199N655TCTlc Aircraft Leasing LLC · Vero Beach, FLBuilt 2002 · S/N 195N659FMThayer Acquisitions LLC · Mclean, VABuilt 2004 · S/N 045N661MSLone Star Avalanche LLC · Marble Falls, TXBuilt 1987 · S/N 011N666TRDrt Falcon LLC · New York, NYBuilt 2014 · S/N 283N667HFBd Plane Inc · Chicago, ILBuilt 1987 · S/N 25N66EWTechnical Support Services Inc · Toledo, OHS/N 492N66FJAlpha Mike Aviation LLC · Murfreesboro, TNBuilt 2000 · S/N 66N66MDWorthida Co LLC · Palm Beach, FLBuilt 2007 · S/N 113N670JDAmber Services Inc · Chicago, ILBuilt 1988 · S/N 45N671HSEvans Aviation Holdings LLC · College Grove, TNBuilt 2002 · S/N 194N672WVWrbc Transportation Inc · Greenwich, CTBuilt 2014 · S/N 280N673HBSigma Equity LLC · San Francisco, CABuilt 2005 · S/N 153N675AZJetco LLC · Kalamazoo, MIBuilt 2012 · S/N 268N67AFAir4 Aviation LLC · Houston, TXBuilt 1997 · S/N 48N67ELWard Ohara Companies LLC · Kansas City, MOBuilt 1995 · S/N 153N67MTWindway Capital Corp · Sheboygan Falls, WIBuilt 1996 · S/N 254N67RTRegistered aircraftBuilt 2021 · S/N 381N680JSBank Of Utah Trustee · Salt Lake City, UTBuilt 2006 · S/N 349N680SFEh Air LLC · Canton, OHBuilt 1998 · S/N 68N681ZLZulu Lima LLC · Marshfield, MABuilt 2009 · S/N 210N684KFJcg Aviation LLC · Park Ridge, ILBuilt 2003 · S/N 213N685KFJcg Aviation LLC · Park Ridge, ILBuilt 2006 · S/N 230N687HA687 Holdings LLC · Newark, DEBuilt 2010 · S/N 232N688CPAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2011 · S/N 241N68HCHca Squared LLC · Nashville, TNBuilt 2019 · S/N 355N68UPRoyal Air Freight Inc · Waterford, MIBuilt 1971 · S/N 258N68YBCzzc Aviation LLC · Tucson, AZBuilt 1999 · S/N 290N690SPRegistered aircraftBuilt 2016 · S/N 334N695PPilot 1958 LLC · Knoxville, TNBuilt 2014 · S/N 722N696JMFalcon Aviation Services LLC · Dallas, TXBuilt 1987 · S/N 28
Back to AD 2010-26-05 R1