AD 2016-14-07

Registered aircraft · 917

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

N449AWAir Wisconsin Airlines LLC · Appleton, WIBuilt 2003 · S/N 7818N449SWSkywest Airlines Inc · St George, UTBuilt 2002 · S/N 7699N450AWAir Wisconsin Airlines LLC · Appleton, WIBuilt 2003 · S/N 7823N451AWAir Wisconsin Airlines LLC · Appleton, WIBuilt 2003 · S/N 7832N452AWSpire Aviation II LLC · Mooresville, NCBuilt 2003 · S/N 7835N452SWSkywest Airlines Inc · St George, UTBuilt 2002 · S/N 7716N453AWAir Wisconsin Airlines LLC · Appleton, WIBuilt 2003 · S/N 7838N453SWSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7743N454AWAir Wisconsin Airlines LLC · Appleton, WIBuilt 2003 · S/N 7842N454SWSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7749N455AWCsi Aviation Inc · Killeen, TXBuilt 2003 · S/N 7848N455CALogos Aviation Inc · Fort Lauderdale, FLBuilt 2002 · S/N 7592N455SWSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7760N456ZWRi Voyager LLC · Beverly, MABuilt 2003 · S/N 7849N457AWUmb Bank Na Trustee · Salt Lake City, UTBuilt 2003 · S/N 7854N457SWSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7773N458AWUmb Bank Na Trustee · Salt Lake City, UTBuilt 2003 · S/N 7861N459AWUmb Bank Na Trustee · Salt Lake City, UTBuilt 2003 · S/N 7863N459SWSkywest Airlines Inc · Saint George, UTBuilt 2003 · S/N 7782N460AWCsi Aviation Inc · Killeen, TXBuilt 2003 · S/N 7867N460SWSkywest Airlines Inc · Saint George, UTBuilt 2003 · S/N 7803N461SWSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7811N462AWAir Wisconsin Airlines LLC · Appleton, WIBuilt 2003 · S/N 7875N463AWUmb Bank Na Trustee · Salt Lake City, UTBuilt 2003 · S/N 7878N463SWSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7820N464AWCsi Aviation Inc · Killeen, TXS/N 7890N464SWSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7827N465AWUmb Bank Na Trustee · Salt Lake City, UTBuilt 2004 · S/N 7893N465SWSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7845N466AWAir Wisconsin Airlines LLC · Appleton, WIS/N 7899N466SWSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7856N467AWM&D Aviation LLC · Sachse, TXS/N 7900N468AWAir Wisconsin Airlines LLC · Appleton, WIS/N 7916N468CASkywest Airlines Inc · St George, UTS/N 7649N469AWUmb Bank Na Trustee · Salt Lake City, UTBuilt 2004 · S/N 7917N470ZWCsi Aviation Inc · Killeen, TXBuilt 2004 · S/N 7927N471CASkywest Airlines Inc · St George, UTBuilt 2002 · S/N 7655N471ZWCsi Aviation Inc · Killeen, TXBuilt 2000 · S/N 7457N472CACorporate Flight Management Inc · Smyrna, TNBuilt 2002 · S/N 7667N477CASkywest Airlines Inc · Saint George, UTBuilt 2002 · S/N 7670N478PXBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 15478N479CASkywest Airlines Inc · St George, UTBuilt 2002 · S/N 7675N479PXBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 15479N480PXBank Of Utah Trustee · Salt Lake City, UTBuilt 2020 · S/N 15480N482PXBank Of Utah Trustee · Salt Lake City, UTBuilt 2020 · S/N 15482N485PXDelta Air Lines Inc · Atlanta, GABuilt 2020 · S/N 15485N487CASkywest Airlines Inc · St George, UTBuilt 2002 · S/N 7729N490PXDelta Air Lines Inc · Atlanta, GABuilt 2020 · S/N 15490N491PXDelta Air Lines Inc · Atlanta, GABuilt 2020 · S/N 15491N494CASkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7765
Back to AD 2016-14-07