AD 2012-02-03

Registered aircraft · 1,019

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-02-03')
    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-02-03')
  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.

N207NVAllegiant Air LLC · Las Vegas, NVBuilt 2013 · S/N 5638N207WNSouthwest Airlines Co · Dallas, TXBuilt 2005 · S/N 34012N208NVAllegiant Air LLC · Las Vegas, NVBuilt 2013 · S/N 5640N208WNSouthwest Airlines Co · Dallas, TXBuilt 2005 · S/N 29856N209NVAllegiant Air LLC · Las Vegas, NVBuilt 2013 · S/N 5901N209WNSouthwest Airlines Co · Dallas, TXBuilt 2005 · S/N 32484N210NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2013 · S/N 5540N210WNSouthwest Airlines Co · Dallas, TXBuilt 2005 · S/N 34162N211NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2013 · S/N 5442N211WNSouthwest Airlines Co · Dallas, TXBuilt 2005 · S/N 34163N212NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2013 · S/N 5498N212WNSouthwest Airlines Co · Dallas, TXBuilt 2005 · S/N 32485N213WNSouthwest Airlines Co · Dallas, TXBuilt 2005 · S/N 34217N214WNSouthwest Airlines Co · Dallas, TXBuilt 2005 · S/N 32486N215WNSouthwest Airlines Co · Dallas, TXBuilt 2005 · S/N 32487N216WRSouthwest Airlines Co · Dallas, TXBuilt 2005 · S/N 32488N21723United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28790N217JCSouthwest Airlines Co · Dallas, TXBuilt 2005 · S/N 34232N218WNSouthwest Airlines Co · Dallas, TXBuilt 2005 · S/N 32489N219WNSouthwest Airlines Co · Dallas, TXBuilt 2005 · S/N 32490N220WNSouthwest Airlines Co · Dallas, TXBuilt 2005 · S/N 32491N224WNSouthwest Airlines Co · Dallas, TXBuilt 2005 · S/N 32493N225WNSouthwest Airlines Co · Dallas, TXBuilt 2005 · S/N 34333N226WNSouthwest Airlines Co · Dallas, TXBuilt 2005 · S/N 32494N227WNSouthwest Airlines Co · Dallas, TXBuilt 2005 · S/N 34450N228WNSouthwest Airlines Co · Dallas, TXBuilt 2005 · S/N 32496N229WNSouthwest Airlines Co · Dallas, TXBuilt 2006 · S/N 32498N230ACBank Of Utah Trustee · Salt Lake City, UTBuilt 2008 · S/N 3667N230FRUmb Bank Na Trustee · Salt Lake City, UTBuilt 2015 · S/N 6773N231WNSouthwest Airlines Co · Dallas, TXBuilt 2006 · S/N 32499N232FRUmb Bank Na Trustee · Salt Lake City, UTBuilt 2015 · S/N 6838N232WNSouthwest Airlines Co · Dallas, TXBuilt 2006 · S/N 32500N233FRUmb Bank Na Trustee · Salt Lake City, UTBuilt 2016 · S/N 7095N234WNSouthwest Airlines Co · Dallas, TXBuilt 2006 · S/N 32502N235FRUmb Bank Na Trustee · Salt Lake City, UTBuilt 2016 · S/N 7272N236FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2016 · S/N 7389N236WNSouthwest Airlines Co · Dallas, TXBuilt 2006 · S/N 34631N23707United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28768N23708United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28769N23721United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28940N238FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2016 · S/N 7458N24202United Airlines Inc · Chicago, ILBuilt 2000 · S/N 30429N24211United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28771N24212United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28772N24224United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28933N246NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2017 · S/N 7664N24706United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28767N24715United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28786N24729United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28945N24736United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28803
Back to AD 2012-02-03