AD 2017-23-06

Registered aircraft · 1,090

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

N296PQDelta Air Lines Inc · Atlanta, GABuilt 2013 · S/N 15296N297PQDelta Air Lines Inc · Atlanta, GABuilt 2013 · S/N 15297N298PQDelta Air Lines Inc · Atlanta, GABuilt 2013 · S/N 15298N299PQDelta Air Lines Inc · Atlanta, GABuilt 2013 · S/N 15299N29CUImagicomm Enterprises LLC · Charlotte, NCBuilt 1996 · S/N 5316N300PQDelta Air Lines Inc · Atlanta, GABuilt 2013 · S/N 15300N301PQDelta Air Lines Inc · Atlanta, GABuilt 2013 · S/N 15301N302PQBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 15302N303PQDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 15303N304PQDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 15304N305PQDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 15305N306PQDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 15306N307PQDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 15307N308PQDelta Air Lines Inc · Atlanta, GAFirst renewal noticeBuilt 2014 · S/N 15308N309PQDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 15309N309WBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1998 · S/N 5394N310PQDelta Air Lines Inc · Atlanta, GAFirst renewal noticeBuilt 2014 · S/N 15310N311PQDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 15311N313PQDelta Air Lines Inc · Atlanta, GAFirst renewal noticeBuilt 2014 · S/N 15313N314PQDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 15314N315PQDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 15315N316PQDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 15316N317CADelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 10055N318JGJuliet Golf LLC · Bloomfield Hills, MIBuilt 1993 · S/N 5137N319PQDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 15319N320PQDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 15320N320SGRegistered aircraftAssigned (import), pending cancellationS/N 5118N322LVBig Rapids Products Aviation LLC · Big Rapids, MIBuilt 2004 · S/N 5587N324PQDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 15324N325PQDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 15325N326MSSkywest Airlines Inc · St George, UTBuilt 2007 · S/N 15124N326PQDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 15326N327TWEmily Aviation LLC · Madison, NJBuilt 1999 · S/N 5421N329MDUjm I LLC · Naples, FLS/N 5098N329MSSkywest Airlines Inc · St George, UTBuilt 2007 · S/N 15126N329PQBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 15329N330PQDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 15330N331CADelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 10061N331PQBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 15331N335PQDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 15335N336PQDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 15336N337PQBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 15337N340AK2fast Aviation LLC · Wilmington, DEBuilt 1999 · S/N 5405N340CADelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 10062N341PQBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 15341N348PQBank Of Utah Trustee · Salt Lake City, UTBuilt 2015 · S/N 15348N349PQBank Of Utah Trustee · Salt Lake City, UTBuilt 2015 · S/N 15349N354CADelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 10064N355CADelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 10067N359VValmont Industries Inc · Omaha, NEBuilt 1997 · S/N 5349
Back to AD 2017-23-06