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.

N909CKDodson International Parts Inc · Rantoul, KSBuilt 1999 · S/N 42N909JMRegistered aircraftBuilt 2000 · S/N 304N909MMNalpak Consulting LLC · Santa Monica, CABuilt 2004 · S/N 38N909NFTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2023 · S/N 410N90BBBank Of Utah Trustee · Salt Lake City, UTBuilt 2015 · S/N 269N90FJWorldwide Aircraft Services Inc DBA · Tampa, FLBuilt 1998 · S/N 75N90GPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1987 · S/N 29N90HCFalcon Aviation LLC · Jupiter, FLS/N 208N90MCAirex 3 LLC · Romulus, MIBuilt 2015 · S/N 322N90THJ & J Capital Ventures LLC · Wilmington, DEBuilt 1999 · S/N 180N90YCAmerican Cruise Lines Inc · Guilford, CTBuilt 2010 · S/N 250N910NMTriangle Real Estate LLC · Saint Peters, MOS/N 95N910SCSunchasing LLC · Newark, DEBuilt 1994 · S/N 144N910TX900 Consulting LLC · Austin, TXBuilt 1998 · S/N 172N912BDBank Of Utah Trustee · Salt Lake City, UTBuilt 2005 · S/N 162N9147HLenox Aviation II LLC · Lawrenceville, NJBuilt 2013 · S/N 709N914LDSdl Management Company LLC · Santa Ana, CABuilt 2003 · S/N 25N914MCMountaire Corp · Little Rock, ARBuilt 2015 · S/N 310N914SSMeregrass Inc · Dublin, TXBuilt 2001 · S/N 188N914TV1365 Swan Ridge Road LLC · New York, NYBuilt 1987 · S/N 14N915FGFgf Sovereign LLC · Dallas, TXBuilt 2006 · S/N 107N915LGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2002 · S/N 182N915TPGlobe Resources Group LLC · Wichita, KSBuilt 1992 · S/N 122N916KPKp Aviation Management LLC · Mather, CABuilt 2000 · S/N 301N917BCFlyaway Inc · Fort Worth, TXS/N 193N917JFAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 1999 · S/N 179N918JM999 Aviation LLC · Northbrook, ILBuilt 2008 · S/N 199N918MJRegistered aircraftBuilt 2013 · S/N 270N918MVGuardian Aviation Services LLC · Short Hills, NJBuilt 1996 · S/N 156N919CHLeipold Aircraft LLC · Racine, WIS/N 205N919SACsc Delaware Trust Co Trustee · Wilmington, DES/N 124N919WTAir Waukegan LLC · Waukegan, ILBuilt 2001 · S/N 313N91MSLabbe LLC · Huntington Valley, PABuilt 1987 · S/N 10N920CERmhco LLC · Denver, COBuilt 2023 · S/N 399N920MDN920md LLC · Oklahoma City, OKBuilt 2000 · S/N 120N921MLDodson International Parts Inc · Rantoul, KSS/N 99N921TBBluemaxx Air LLC · Friendswood, TXS/N 85N923GGYia Falcon LLC · Coconut Grove, FLBuilt 2009 · S/N 201N923JEUnder Par LLC · Overland Park, KSBuilt 1999 · S/N 094N926JCJcd Leasing LLC · Orlando, FLBuilt 2000 · S/N 106N926JTVanderpenn LLC · Big Sky, MTBuilt 2014 · S/N 283N9273N2973 LLC · Wayzata, MNBuilt 2015 · S/N 317N927AACapital Holdings 238 LLC · Waco, TXBuilt 1999 · S/N 046N927BRFur Management & Consulting LLC · Junction, TXBuilt 2002 · S/N 196N928PWOld Harbour Aviation LLC · North Palm Beach, FLBuilt 2003 · S/N 13N928WKRegistered aircraftBuilt 2010 · S/N 183N92CJSkyview LLC · Wilmington, DEBuilt 1982 · S/N 092N935SFLujo Equipo LLC · Odessa, TXBuilt 2014 · S/N 290N940CLDfn26pa LLC · Plymouth, MABuilt 1998 · S/N 031N942SSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2008 · S/N 622
Back to AD 2010-26-05 R1