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.

N799ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 30258N799GERegistered aircraftBuilt 2025 · S/N 2458N799GXPf Pc12 LLC · Grand Rapids, MIBuilt 2016 · S/N 1615N799LATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2016 · S/N 1675N799SPPnc Bank National Association · Boise, IDBuilt 2017 · S/N 5568N799UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 26926N799WWVarsity Equipment LLC · Beachwood, OHBuilt 2007 · S/N 2085N79NGBca Aviation LLC · Marksville, LABuilt 2013 · S/N 1379N7BD757bd LLC · Albuquerque, NMBuilt 1987 · S/N 31N7NJState Of New Jersey · Trenton, NJBuilt 2011 · S/N 41264N7RXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 4017N7SESteven Brothers Aviation LLC · Wichita, KSBuilt 2005 · S/N 5088N7SNSevenson Environmental Services Inc · Niagara Falls, NYS/N 591N7TMAeonian Air LLC · West Chester, PABuilt 2009 · S/N 560-6028N8001NAmerican Airlines Inc · Fort Worth, TXBuilt 2013 · S/N 5678N8009TAmerican Airlines Inc · Fort Worth, TXBuilt 2013 · S/N 5788N800ABCheck Clearing House Aviation LLC · Glenwood Springs, COBuilt 2001 · S/N 137N800AMReading And Northern Aviation Inc · Port Clinton, PABuilt 2001 · S/N 560-5195N800BJBrighton Jones LLC · Seattle, WABuilt 2017 · S/N 1678N800DWJfm Air II LLC · Wilton Manors, FLS/N 79N800GHLeading Edge LLC · Minneapolis, MNBuilt 1999 · S/N 89N800JHJ&J Aviation LLC · Crested Butte, COBuilt 2005 · S/N 5073N800KMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1993 · S/N 120N800KVOnin Ascend LLC · Birmingham, ALBuilt 2012 · S/N 560-6104N800WYKoinonia Aviation LLC · Casper, WYBuilt 2021 · S/N 2068N801ASRegistered aircraftBuilt 2005 · S/N 5097N801AWU S Bank Na Trustee · Boston, MABuilt 1998 · S/N 0889N801JSCitation 1 Juliet Sierra LLC · Uvalde, TXBuilt 2000 · S/N 560-5075N801MMLiechty Aviation LLC · Lagrange, GABuilt 2013 · S/N 457N801NWDelta Air Lines Inc · Atlanta, GABuilt 2003 · S/N 0524N801PBCwc Investments LLC · Jefferson City, MOBuilt 2008 · S/N 1006N801QASaint Christopher Aviation LLC · Fort Collins, COBuilt 2011 · S/N 1317N801TKRidge Line Aviation LLC · Evansville, WYBuilt 2022 · S/N 2195N801UAUnited Airlines Inc · Chicago, ILBuilt 1997 · S/N 686N8020EAf Holdings LLC · Argyle, TXBuilt 2022 · S/N 2158N8027DAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6437N802AKRa Aviation Holdings LLC · Prosper, TXBuilt 2010 · S/N 2128N802AWU S Bank Na Trustee · Boston, MABuilt 1998 · S/N 0924N802NWDelta Air Lines Inc · Atlanta, GABuilt 2003 · S/N 0533N802TDAlliance Aviation Group LLC · Wilmington, DEBuilt 2001 · S/N 560-5153N802UAUnited Airlines Inc · Chicago, ILBuilt 1997 · S/N 690N8030FAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6552N8031MAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6595N803AGTextile Aviation LLC · Dalton, GABuilt 2010 · S/N 4194N803AWU S Bank Na Trustee · Boston, MABuilt 1998 · S/N 0931N803JSFe 5272 LLC · Kinston, NCS/N 560-5272N803MGRegistered aircraftBuilt 2011 · S/N 1300N803NWDelta Air Lines Inc · Atlanta, GABuilt 2003 · S/N 0542N803TMTai Leasing Inc · Mckinney, TXBuilt 2008 · S/N 5226N803UAUnited Airlines Inc · Chicago, ILBuilt 1997 · S/N 0748
Back to AD 2012-26-15 R1