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.

N833UAUnited Airlines Inc · Chicago, ILBuilt 2000 · S/N 1401N834AWAmerican Airlines Inc · Fort Worth, TXS/N 2302N834JBJetblue Airways Corp · Long Island City, NYBuilt 2013 · S/N 5782N834KWAlta 777 LLC · Salt Lake City, UTS/N 32317N834MHDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 29707N834NGToddco Interests LLC · Houston, TXBuilt 2018 · S/N 1834N834UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 1420N835AFTarga Resources Finance Corp · Portsmouth, NHBuilt 2018 · S/N 1835N835AWWilmington Trust Co Trustee · Wilmington, DES/N 2458N835FDBoeing Co · Renton, WAS/N 70865N835JSCt Equipment Leasing LLC · Kinston, NCBuilt 2008 · S/N 560-5813N835MHDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 29708N835UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 1426N836AWAwas 2570 Trust · New York, NYBuilt 2005 · S/N 2570N836FDBoeing Co · Renton, WAS/N 70864N836JSFe 5186 LLC · Kinston, NCBuilt 2001 · S/N 560-5186N836MHDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 29709N836UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 1460N837AWAwas 2595 Trust · New York, NYBuilt 2005 · S/N 2595N837FDFederal Express Corp · Memphis, TNBuilt 2026 · S/N 70863N837JSFe 5164 LLC · Kinston, NCBuilt 2001 · S/N 560-5164N837MHDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 29710N837UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 1474N837VABank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 4558N837ZPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2012 · S/N 5393N838AWUmb Bank Na Trustee · Salt Lake City, UTBuilt 2005 · S/N 2615N838CBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 560-6164N838JSFe Encore Plus III LLC · Kinston, NCBuilt 2002 · S/N 560-5237N838KEDtc LLC · Newburgh, NYBuilt 2012 · S/N 5398N838MHDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 29711N838UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 1477N838WC838wc LLC · Provo, UTBuilt 2021 · S/N 2089N839AWAmerican Airlines Inc · Fort Worth, TXBuilt 2006 · S/N 2669N839JSRenflight LLC · Raleigh, NCBuilt 2004 · S/N 560-5356N839MHDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 29712N839UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 1507N83AJBeach Aviation Inc · Naples, FLBuilt 2013 · S/N 1415N83GBExcel 5 LLC · Columbus, GABuilt 2008 · S/N 560-5756N83LXLx Aviation LLC · Little Rock, ARBuilt 2024 · S/N 560-6354N83ML3harris Technologies Flight Capital LLC · Greenville, TXBuilt 2014 · S/N 5470N83MLHampton Airways Inc · Sellersburg, INBuilt 2013 · S/N 41356N83SPKelbel Aviation LLC · Longview, TXBuilt 2001 · S/N 560-5202N83WADell Air LLC · Portland, ORBuilt 2018 · S/N 1803N840ACTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2004 · S/N 2013N840AWAmerican Airlines Inc · Fort Worth, TXBuilt 2006 · S/N 2690N840JMGwzi LLC · Dover, DES/N 289N840JSFe 5282 LLC · Kinston, NCBuilt 2002 · S/N 560-5282N840KWAlta 777 LLC · Salt Lake City, UTS/N 32890N840MHDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 29718N840UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 1522
Back to AD 2012-26-15 R1