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.

N821CMCargo Aircraft Management Inc · Wilmington, OHS/N 1146N821CNNoble Legacy Leasing LLC · Newark, DEBuilt 2007 · S/N 4085N821JBJetblue Airways Corp · Long Island City, NYBuilt 2012 · S/N 5417N821NWDelta Air Lines Inc · Atlanta, GABuilt 2007 · S/N 0865N821UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 0944N8228NAnnero LLC · Los Angeles, CABuilt 2004 · S/N 5057N822AWU S Bank Na Trustee · Boston, MABuilt 2000 · S/N 1410N822AZArizona Department Of Public Safety · Phoenix, AZS/N 57439N822BDKoba LLC · Paradise Valley, AZBuilt 2005 · S/N 5064N822KWAlta 777 LLC · Salt Lake City, UTS/N 28532N822NGFrilad Sky Ventures LLC · Wilmington, DEBuilt 2018 · S/N 1822N822NPProductivity Strategies LLC · Olathe, KSBuilt 1993 · S/N 001N822NWDelta Air Lines Inc · Atlanta, GABuilt 2015 · S/N 1627N822SFGap Inc · San Francisco, CABuilt 2019 · S/N 5597N822UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 0948N823CAExtraordinaire Aviation II LLC · Fairfield, OHS/N 221N823HLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 2037N823HMCyprus Center Services LLC · Gilbert, AZBuilt 2008 · S/N 371N823JSAero Harbor Nc Ll · Charlotte, NCBuilt 2002 · S/N 560-5265N823MBShakedown Street LLC · Camden, DEBuilt 2012 · S/N 1361N823NWDelta Air Lines Inc · Atlanta, GABuilt 2015 · S/N 1628N823UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 0952N824AWU S Bank Na Trustee · Boston, MABuilt 2001 · S/N 1490N824FMN824fm LLC · New York, NYBuilt 2011 · S/N 4222N824JSFe 5536 LLC · Kinston, NCBuilt 2005 · S/N 5605536N824NWDelta Air Lines Inc · Atlanta, GABuilt 2015 · S/N 1637N824SMeregrass Inc · Dublin, TXBuilt 1987 · S/N 23N824UAUnited Airlines Inc · Chicago, ILBuilt 1999 · S/N 0965N825AWU S Bank Na Trustee · Boston, MABuilt 2001 · S/N 1527N825CATwn Capital LLC · Newark, DES/N 220N825KWEal Asset Holdings LLC · Kansas City, MOBuilt 2003 · S/N 32318N825LPBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 1455N825MHDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 29703N825NWDelta Air Lines Inc · Atlanta, GABuilt 2015 · S/N 1679N825NXN825nx LLC · Wilmington, DEBuilt 2018 · S/N 1825N825PRR And B Equipment Leasing LLC · Arroyo Grande, CABuilt 2023 · S/N 2265N825UAUnited Airlines Inc · Chicago, ILBuilt 1999 · S/N 0980N826AWU S Bank Na Trustee · Boston, MAS/N 1534N826CALear Management LLC · Tulsa, OKBuilt 2002 · S/N 222N826KWAlta 777 LLC · Salt Lake City, UTS/N 28521N826MHDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 29713N826NWDelta Air Lines Inc · Atlanta, GABuilt 2016 · S/N 1701N826PA3826-Ks Aviation LLC · Columbia, MOBuilt 2013 · S/N 1385N826UAUnited Airlines Inc · Chicago, ILBuilt 1999 · S/N 0989N827AVAersale Inc · Coral Gables, FLS/N 4287N827AWUS Bank Na Trustee · Boston, MABuilt 2001 · S/N 1547N827CRCamar Express LLC · Tallahassee, FLBuilt 2007 · S/N 560-5693N827DPN827dp LLC · Boyertown, PABuilt 2016 · S/N 560-6210N827JBJetblue Airways Corp · Long Island City, NYBuilt 2013 · S/N 5677N827KWAlta 777 LLC · Salt Lake City, UTS/N 28525
Back to AD 2012-26-15 R1