OpenAirDocs.org
AD 2012-26-15 R1

Registered aircraft · 5,537

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-26-15-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:2012-26-15-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.

N616NKUmb Bank Na Trustee · Salt Lake City, UTBuilt 2012 · S/N 5370N616RKBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 5361N617AZAmazon.Com Services LLC · Seattle, WABuilt 2001 · S/N 30575N617BGLife Flight Network LLC · Aurora, ORBuilt 2010 · S/N 1253N617CBCarroll Aviation Holdings LLC · Boston, MABuilt 2000 · S/N 560-5099N617EXPi Sn1576 LLC · Fort Lauderdale, FLBuilt 2015 · S/N 1576N617MWChoe Aviation Holdings LLC · Boston, MABuilt 2003 · S/N 560-5318N617NKBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 5387N618JBJetblue Airways Corp · Long Island City, NYBuilt 2005 · S/N 2489N618NKUmb Bank Na Trustee · Salt Lake City, UTBuilt 2013 · S/N 5458N618PJForty Er LLC · Bethany, OKBuilt 2007 · S/N 2076N619AZAmazon.Com Services LLC · Seattle, WABuilt 2000 · S/N 30594N619FBSteelman Aviation Inc · Las Vegas, NVBuilt 2019 · S/N 1901N619FKFks Aviation LLC · Richardson, TXBuilt 2008 · S/N 560-5777N619NKWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2013 · S/N 5517N619RXNine Romeo X-Ray LLC · Southlake, TXBuilt 2010 · S/N 405N61FPJet There LLC · Cedar Rapids, IABuilt 2012 · S/N 1332N61FTAfa Southwest LLC · San Antonio, TXBuilt 2008 · S/N 560-5770N61JEJce Leasing LLC · Little Rock, ARBuilt 1999 · S/N 72N61NGThrottle N Flow LLC · Carson City, NVBuilt 2009 · S/N 1161N61RJFlying Fish Aviation LLC · San Francisco, CABuilt 2023 · S/N 2278N620BDTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2008 · S/N 560-5794N620FBCity Of Phoenix · Phoenix, AZBuilt 2008 · S/N 1070N620JHBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 5595N620NGDirect Jet Charter LLC · Greensboro, NCBuilt 2016 · S/N 1620N620NKBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 5624N620SJFaulconer Energy LLC · Tyler, TXBuilt 2006 · S/N 560-5620N620SRJauer Brad W · San Antonio, TXBuilt 2023 · S/N 2247N620TXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2002 · S/N 560-5299N621JBJetblue Airways · Long Island City, NYBuilt 2005 · S/N 2491N621NKWilmington Trust Co Trustee · Wilmington, DEBuilt 2013 · S/N 5672N621VSVsa LLC · Clear Lake, IAFirst renewal noticeBuilt 1998 · S/N 032N622AFRigi Inc · Portsmouth, NHBuilt 2016 · S/N 1622N622GKAircraft Holding Solutions LLC Trustee · Newark, DEBuilt 2009 · S/N 4164N622NKWilmington Trust Co Trustee · Wilmington, DEBuilt 2013 · S/N 5804N623FCMundi Energy LLC · Chula Vista, CABuilt 2006 · S/N 2047N623HDK & M Aviation Holdings I LLC · Hartville, OHBuilt 1996 · S/N 35N623JBJetblue Airways Corp · Long Island City, NYBuilt 2005 · S/N 2504N623NKWilmington Trust Co Trustee · Wilmington, DEBuilt 2013 · S/N 5861N623TAL3 Harris Technologies Inc · Waco, TXBuilt 2012 · S/N 5374N624JBJetblue Airways Corp · Long Island City, NYBuilt 2005 · S/N 2520N624NKWilmington Trust Co Trustee · Wilmington, DEBuilt 2013 · S/N 5880N624WP624wp Holdings LLC · Indianapolis, INBuilt 2001 · S/N 560-5174N625ATTechnology Value Investors Aviation LLC · Little Rock, ARBuilt 2001 · S/N 560-5175N625HRTryst 767 LLC · San Juan, PRBuilt 1992 · S/N 25287N625JBJetblue Airways Corporation · Long Island City, NYBuilt 2005 · S/N 2535N625MCPool Plane LLC · Seattle, WABuilt 2008 · S/N 1047N625NKUmb Bank Na Trustee · Salt Lake City, UTS/N 5954N625XLW T B Financial Corp · Spokane, WABuilt 2012 · S/N 560-6125N626JCSeascape Air LLC · Irvine, CABuilt 2001 · S/N 140
Back to AD 2012-26-15 R1