AD 2017-26-06

Registered aircraft · 665

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:2017-26-06')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2017-26-06')
  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.

N12167United Airlines Inc · Chicago, ILBuilt 2004 · S/N 14500834N12172United Airlines Inc · Chicago, ILBuilt 2004 · S/N 14500864N12175United Airlines Inc · Chicago, ILBuilt 2004 · S/N 14500878N12195United Airlines Inc · Chicago, ILBuilt 2005 · S/N 14500943N121ATJea Media Luna Surface Lp · Bearden, ARBuilt 1998 · S/N 750-0057N12201United Airlines Inc · Chicago, ILBuilt 2006 · S/N 14500959N12540Dulux Public Charter LLC · Dallas, TXBuilt 2001 · S/N 145537N12552Corporate Flight Management Inc · Smyrna, TNBuilt 2002 · S/N 145583N125DZCitation X Parts LLC · Liberty, NCBuilt 1999 · S/N 750-0079N125RHAir Siete LLC · Wilmington, DEBuilt 2002 · S/N 750-0194N125THCitation X Parts LLC · Liberty, NCBuilt 2002 · S/N 750-0177N12BA3hba LLC · Dallas, TXBuilt 2004 · S/N 7500222N12GGLima Golf Investments LLC · Bigfork, MTBuilt 2001 · S/N 750-0140N13123Delux Public Charter LLC · Dallas, TXBuilt 2003 · S/N 145688N13124United Airlines Inc · Chicago, ILBuilt 2003 · S/N 145689N13132United Airlines Inc · Chicago, ILBuilt 2003 · S/N 145708N13133United Airlines Inc · Chicago, ILBuilt 2003 · S/N 145712N13161United Airlines Inc · Chicago, ILBuilt 2004 · S/N 14500805N13202United Airlines Inc · Chicago, ILBuilt 2006 · S/N 14500962N135SCBallator Equipment Leasing LLC · Beech Mountain, NCBuilt 2006 · S/N 14500972N135SGValiair Lc Trustee · Casper, WYBuilt 2003 · S/N 145706N135SKZed Aerocapital LLC · Dover, DEBuilt 2007 · S/N 14500989N135SLZed Aerocapital LLC · Dover, DEBuilt 2003 · S/N 145711N135SXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2003 · S/N 145728N138DEChampion Air LLC · Mooresville, NCS/N 145129N138SPFixed Gear 2 LLC · Seattle, WABuilt 2000 · S/N 750-0138N13975Delux Public Charter LLC · Dallas, TXBuilt 1999 · S/N 145163N13978Delux Public Charter LLC · Dallas, TXBuilt 1999 · S/N 145180N13979Delux Public Charter LLC · Dallas, TXBuilt 1999 · S/N 145181N13988Delux Public Charter LLC · Dallas, TXBuilt 2000 · S/N 145265N13989Delux Public Charter LLC · Dallas, TXBuilt 2000 · S/N 145271N13992Delux Public Charter LLC · Dallas, TXBuilt 2000 · S/N 145284N13SYSy Air LLC · Tampa, FLBuilt 2001 · S/N 750-0143N14105Delux Public Charter LLC · Dallas, TXBuilt 2002 · S/N 145649N14116United Airlines Inc · Chicago, ILBuilt 2002 · S/N 145672N14125United Airlines Inc · Chicago, ILBuilt 2003 · S/N 145690N14143United Airlines Inc · Chicago, ILBuilt 2003 · S/N 145739N14148United Airlines Inc · Chicago, ILBuilt 2003 · S/N 145751N14153United Airlines Inc · Chicago, ILBuilt 2003 · S/N 145761N14158United Airlines Inc · Chicago, ILBuilt 2004 · S/N 145791N14162United Airlines Inc · Chicago, ILBuilt 2004 · S/N 14500808N14168United Airlines Inc · Chicago, ILBuilt 2004 · S/N 14500840N14173United Airlines Inc · Chicago, ILBuilt 2004 · S/N 14500872N14174United Airlines Inc · Chicago, ILBuilt 2004 · S/N 14500876N14177United Airlines Inc · Chicago, ILBuilt 2005 · S/N 14500888N14179United Airlines Inc · Chicago, ILBuilt 2005 · S/N 14500896N14180United Airlines Inc · Chicago, ILBuilt 2005 · S/N 14500900N14186United Airlines Inc · Chicago, ILBuilt 2005 · S/N 14500924N14188United Airlines Inc · Chicago, ILBuilt 2005 · S/N 14500929N14198United Airlines Inc · Chicago, ILBuilt 2006 · S/N 14500951
Back to AD 2017-26-06