AD 2017-01-06

Registered aircraft · 1,069

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-01-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-01-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.

N284AVAircol 16 · Wilmington, DEBuilt 2010 · S/N 4284N284NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2012 · S/N 5045N285NVAllegiant Air LLC · Las Vegas, NVBuilt 2012 · S/N 5067N286NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2010 · S/N 4447N287NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2010 · S/N 4508N288NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2010 · S/N 4537N289GXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 3016N289NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2011 · S/N 4574N290NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2004 · S/N 2191N291GXGlobal Crossing Airlines Inc · Miami, FLBuilt 2007 · S/N 3349N291NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2004 · S/N 2206N292NVBank Of Utah Trustee · Salt Lake City, UTS/N 4891N293NVBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 4913N294NVBank Of Utah Trustee · Salt Lake City, UTS/N 4941N295NVBank Of Utah Trustee · Salt Lake City, UTS/N 4942N296NVBank Of Utah Trustee · Salt Lake City, UTBuilt 2006 · S/N 2674N297NVBank Of Utah Trustee · Salt Lake City, UTBuilt 2006 · S/N 2778N298NVBank Of Utah Trustee · Salt Lake City, UTBuilt 2006 · S/N 2800N299NVAllegiant Air LLC · Las Vegas, NVBuilt 2011 · S/N 4870N3014RAmerican Airlines Inc · Fort Worth, TXBuilt 2013 · S/N 5842N301DVDelta Air Lines Inc · Atlanta, GABuilt 2016 · S/N 6923N302DNDelta Air Lines Inc · Atlanta, GABuilt 2016 · S/N 7031N303DNDelta Air Lines Inc · Atlanta, GABuilt 2016 · S/N 7061N304DNDelta Air Lines Inc · Atlanta, GABuilt 2016 · S/N 7112N305DNDelta Air Lines Inc · Atlanta, GABuilt 2016 · S/N 7149N306DNDelta Air Lines Inc · Atlanta, GABuilt 2016 · S/N 7165N307DXDelta Air Lines Inc · Atlanta, GABuilt 2016 · S/N 7214N308DNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2016 · S/N 7233N309DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2016 · S/N 7268N310DNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2016 · S/N 7293N311DNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2016 · S/N 7304N312DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2016 · S/N 7364N313DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2016 · S/N 7381N314DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2016 · S/N 7281N315DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2016 · S/N 7436N316DNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2017 · S/N 7327N317DNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2017 · S/N 7373N318DXDelta Air Lines Inc · Atlanta, GABuilt 2017 · S/N 7441N319DNDelta Air Lines Inc · Atlanta, GAFirst renewal noticeBuilt 2017 · S/N 7479N320DNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2017 · S/N 7546N321AVCsds Asset Management LLC · Marana, AZS/N 2234N321DHUmb Bank Na Trustee · Salt Lake City, UTBuilt 2017 · S/N 7592N3221CBank Of Utah Trustee · Salt Lake City, UTS/N 852N322DNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2017 · S/N 7707N323DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 7672N324DXUmb Bank Na Trustee · Salt Lake City, UTBuilt 2017 · S/N 7765N325DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 7709N326DNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2017 · S/N 7845N327DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 7777N328DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 7840
Back to AD 2017-01-06