AD 2019-23-13

Registered aircraft · 119

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

N367FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2020 · S/N 9484N368FRWilmington Trust Co Trustee · Wilmington, DEBuilt 2020 · S/N 9549N369FRWilmington Trust Co Trustee · Wilmington, DEBuilt 2020 · S/N 10031N370FRUmb Bank Na Trustee · Salt Lake City, UTBuilt 2020 · S/N 10038N371FRWilmington Trust Co Trustee · Wilmington, DEBuilt 2020 · S/N 10089N372FRWilmington Trust Co Trustee · Wilmington, DEBuilt 2020 · S/N 10119N373FRWilmington Trust Co Trustee · Wilmington, DEBuilt 2021 · S/N 10451N374FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2021 · S/N 10452N375FRWilmington Trust Co Trustee · Wilmington, DEBuilt 2020 · S/N 10298N376FRWilmington Trust Co Trustee · Wilmington, DEBuilt 2020 · S/N 10327N377FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2021 · S/N 10384N378FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2021 · S/N 10386N379FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2021 · S/N 10510N380FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2021 · S/N 10512N381FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2021 · S/N 10544N382FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2021 · S/N 10565N383FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2021 · S/N 10584N384FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2021 · S/N 10596N385FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2021 · S/N 10622N386FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2021 · S/N 10642N387FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2021 · S/N 10708N388FRWilmington Trust Co Trustee · Wilmington, DEBuilt 2022 · S/N 10768N389FRWilmington Trust Co Trustee · Wilmington, DEBuilt 2022 · S/N 10743N390FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2022 · S/N 10790N391FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2022 · S/N 10838N392FRWilmington Trust Co Trustee · Wilmington, DES/N 10833N393FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2022 · S/N 10919N394FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2022 · S/N 10981N395FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2022 · S/N 11077N396FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2022 · S/N 11155N7409AUnical Aviation Inc · Glendale, AZS/N 7409N762AVWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2019 · S/N 8889N764AVWilmington Trust Co Trustee · Wilmington, DEBuilt 2017 · S/N 7887N765AVWilmington Trust Co Trustee · Wilmington, DEBuilt 2017 · S/N 7928N766AVWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2018 · S/N 8096N769AVWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2018 · S/N 8170N775AVWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2018 · S/N 8240N776AVWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2018 · S/N 8280N779AVBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 8300N788AVWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2019 · S/N 8938N818AVWells Fargo Trust Co Na Trustee · Salt Lake City, UTBuilt 2019 · S/N 9041N901AVBank Of Utah Trustee · Salt Lake City, UTBuilt 2024 · S/N 11912N902AVUmb Bank Na Trustee · Salt Lake City, UTBuilt 2024 · S/N 12169N903AVBank Of Utah Trustee · Salt Lake City, UTS/N 12173N904AVUmb Bank Na Trustee · Salt Lake City, UTBuilt 2024 · S/N 12289N905AVUmb Bank Na Trustee · Salt Lake City, UTBuilt 2024 · S/N 12100N906AVUmb Bank Na Owner Trustee · Salt Lake City, UTBuilt 2025 · S/N 12840N913AVUmb Bank Na Trustee · Salt Lake City, UTBuilt 2026 · S/N 13193N917AVUmb Bank Na Trustee · Salt Lake City, UTBuilt 2026 · S/N 13296N919AVBank Of Utah Trustee · Salt Lake City, UTBuilt 2023 · S/N 11584
Back to AD 2019-23-13