AD 2015-02-13

Registered aircraft · 383

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

N667GBAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 145784N668HHAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 145785N669MBAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 145788N670AEAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 145790N671AEAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 145793N672AEAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 145794N673AEAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 145797N675AEAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 14500806N676AEAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 14500807N677AEAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 14500810N678AEAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 14500813N679AEAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 14500814N67VAAdvanced Air LLC · Statesville, NCBuilt 2000 · S/N 145354N680AEAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 14500820N681AEAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 14500824N682AEAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 14500826N683AEAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 14500833N684JWAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 14500835N685AEAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 14500836N686AEAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 14500843N687JSAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 14500846N688AEAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 14500849N689ECAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 14500853N690AEAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 14500858N691AEAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 14500860N692AEAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 14500866N693AEAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 14500868N694AEAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 14500869N695AEAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 14500870N696AEAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 14500874N697ABAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 14500875N697EEEmbraer Executive Aircraft Inc · Melbourne, FLS/N 145-1197N698CBAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 14500877N699AEAmerican Airlines Inc · Fort Worth, TXBuilt 2005 · S/N 14500883N704PGBank Of Utah Trustee · Salt Lake City, UTBuilt 1999 · S/N 145174N70VAAdvanced Air LLC · Statesville, NCBuilt 2001 · S/N 145397N712AEAero Aircraft Holdings LLC · Van Nuys, CAS/N 145247N804CECummins Inc · Columbus, INBuilt 2012 · S/N 14501153N806AECorporate Flight Management Inc DBA · Smyrna, TNBuilt 2001 · S/N 145503N809AECorporate Flight Management Inc DBA · Smyrna, TNBuilt 2001 · S/N 145521N810AEBank Of Utah Trustee · Salt Lake City, UTBuilt 2001 · S/N 145525N815AEBank Of Utah Trustee · Salt Lake City, UTBuilt 2002 · S/N 145545N819AEAvi Sales & Leasing Services LLC · Muskegon, MIS/N 145566N81EXExodus Aircraft LLC · Wilmington, DEBuilt 1998 · S/N 145053N821AEBank Of Utah Trustee · Salt Lake City, UTBuilt 2002 · S/N 145577N822AEBank Of Utah Trustee · Salt Lake City, UTBuilt 2002 · S/N 145581N825AEBank Of Utah Trustee · Salt Lake City, UTBuilt 2002 · S/N 145589N825HKBank Of Utah Trustee · Salt Lake City, UTS/N 145510N826AEBank Of Utah Trustee · Salt Lake City, UTBuilt 2002 · S/N 145592N830AEBank Of Utah Trustee · Salt Lake City, UTBuilt 2002 · S/N 145615
Back to AD 2015-02-13