OpenAirDocs.org
AD 2023-12-21

Registered aircraft · 17

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

N780AVWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2014 · S/N 37502N781AVUmb Bank Na Trustee · Salt Lake City, UTBuilt 2014 · S/N 37503N782AVBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 37504N783AVBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 37505N784AVWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2015 · S/N 37506N785AVUmb Bank Na Trustee · Salt Lake City, UTBuilt 2015 · S/N 37507N786AVUmb Bank Na Trustee · Salt Lake City, UTBuilt 2015 · S/N 37508N7874Boeing Co · Renton, WABuilt 2010 · S/N 40693N787BXBoeing Co · Renton, WABuilt 2010 · S/N 40692N791AVBank Of Utah Trustee · Salt Lake City, UTBuilt 2016 · S/N 37509N792AVWells Fargo Trust Co Na Trustee · Columbiae City, MDBuilt 2016 · S/N 37510N793AVUmb Bank Na Trustee · Salt Lake City, UTBuilt 2016 · S/N 37511N794AVWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2017 · S/N 39406N795AVUmb Bank Na Trustee · Salt Lake City, UTBuilt 2017 · S/N 39407N798AVUmb Bank Na Trustee · Salt Lake City, UTBuilt 2013 · S/N 34795N799AVUmb Bank Na Trustee · Salt Lake City, UTBuilt 2014 · S/N 34796N800AVUmb Bank Na Trustee · Salt Lake City, UTBuilt 2015 · S/N 36526
Back to AD 2023-12-21