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.

N399HAHawaiian Airlines Inc · Honolulu, HIBuilt 2014 · S/N 1496N399LATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2019 · S/N 1884N399MTBank Of Utah Trustee · Salt Lake City, UTS/N 29741N399NG399ng LLC · Moorefield, WVBuilt 2013 · S/N 1399N399PGHansen Air LLC · Mesa, AZBuilt 2020 · S/N 2050N39EQAstra Beta Aw139 LLC · Newburgh, NYBuilt 2025 · S/N 41622N39FMTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2013 · S/N 5412N39PLN39pl LLC · Saint Johns, MIBuilt 2017 · S/N 1703N39RCRich Plane LLC · Gilberton, PABuilt 1999 · S/N 5605041N39WERegistered aircraftBuilt 2019 · S/N 41555N3BZZelta LLC · Wilmington, DEBuilt 2021 · S/N 560-6313N3JMSkybank LLC · Elkhorn, NEBuilt 2015 · S/N 560-6184N3LFCoppergate LLC · Carmel, INBuilt 2010 · S/N 1176N3LLTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 5080N3NJState Of New Jersey · Trenton, NJS/N 41293N3SAAlpha Sierra Pilatus LLC · Lafayette, LABuilt 2008 · S/N 1015N3STSouthern Tire Aviation LLC · Columbia, MSBuilt 2014 · S/N 487N3WTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2009 · S/N 41211N3WUWas-Up LLC · Boise, IDBuilt 2025 · S/N 2448N4000KTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N 560-5081N4005XAmerican Airlines Inc · Fort Worth, TXBuilt 2013 · S/N 5753N400CPCp Aviation LLC · Tulsa, OKBuilt 2007 · S/N 560-5716N400CRComstock Resources Inc · Frisco, TXBuilt 2008 · S/N 5213N400PCIn The Clear II LLC · Ocala, FLBuilt 2008 · S/N 1062N401AVAircol 8 · Wilmington, DEBuilt 2009 · S/N 4001N401JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2013 · S/N 4286N401LJDavis Air LLC · Vero Beach, FLBuilt 2002 · S/N 2001N401LXAplux LLC · Saint Louis, MOBuilt 2010 · S/N 1254N401NCNorth Carolina State Highway Patrol · Cary, NCBuilt 2022 · S/N 57457N401NGRomanair LLC · Blanding, UTBuilt 2013 · S/N 1401N401SEFlyusa Acquisitions LLC · Clearwater, FLBuilt 2008 · S/N 1064N401SFLear 401 LLC · Fayetteville, ARS/N 247N401SRGulfstream Leasing LLC · Savannah, GAFirst renewal noticeBuilt 2003 · S/N 4001N401UAUnited Airlines Inc · Chicago, ILBuilt 1993 · S/N 435N402JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2012 · S/N 4266N402UAUnited Airlines Inc · Chicago, ILBuilt 1993 · S/N 439N4032TAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6644N403LSRa Aviation Holdings LLC · Prosper, TXBuilt 2009 · S/N 2124N404SCNcpa Logistics Two LLC · Charlotte, NCBuilt 2022 · S/N 2183N404TCStar Peak Air LLC · San Francisco, CABuilt 2017 · S/N 1743N404UAUnited Airlines Inc · Chicago, ILBuilt 1993 · S/N 450N404WCCheckmark II LLC · Burnet, TXBuilt 1999 · S/N 83N405CBNevada Global Jet LLC · Henderson, NVBuilt 2007 · S/N 5156N405LABank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 5574N406CJSchreiber Charles J Jr Trustee · Newport Beach, CABuilt 2008 · S/N 560-5815N406NLL&N Transit LLC · Salem, ORBuilt 1998 · S/N 67N406UAUnited Airlines Inc · Chicago, ILBuilt 1994 · S/N 454N407DWP A T Productions Aviation LLC · Severna Park, MDBuilt 2006 · S/N 4050N407GKBank Of Utah Trustee · Salt Lake City, UTBuilt 2005 · S/N 5068N408DAIrby Construction Co · Richland, MSBuilt 2016 · S/N 1631
Back to AD 2012-26-15 R1