AD 2016-08-16

Registered aircraft · 128

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-08-16')
    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-08-16')
  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.

N719GFWarfield Aviation II LLC · San Francisco, CABuilt 2021 · S/N 21035N730TCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2025 · S/N 21431N745VTRegistered aircraftBuilt 2022 · S/N 21117N7727FAirbus Helicopters Inc · Grand Prairie, TXBuilt 2026 · S/N 21473N783MHBay Life Services Corp · Columbia, MDBuilt 2026 · S/N 21458N784LFWest Penn Allegheny Foundation LLC · Pittsburgh, PABuilt 2022 · S/N 21096N7WWRegistered aircraftBuilt 2021 · S/N 21004N800DAAirbus Helicopters Inc · Grand Prairie, TXBuilt 2026 · S/N 21422N804PAPathfinder Leasing LLC · Anchorage, AKBuilt 2004 · S/N 3782N843LFLife Flight Network LLC · Aurora, ORBuilt 2018 · S/N 20219N844LFLife Flight Network LLC · Aurora, ORBuilt 2023 · S/N 21229N85LFLf Transportation LLC · New York, NYBuilt 2026 · S/N 21498N8EURegistered aircraftBuilt 2025 · S/N 21339N8KTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2020 · S/N 20353N90DKDekalb County Police · Tucker, GABuilt 2004 · S/N 3807N919SFAir Er LLC · Corinth, TXBuilt 1991 · S/N 760370N919SHAirbus Helicopters Inc · Grand Prairie, TXBuilt 2024 · S/N 21294N945DCJs Leasing LLC · Frisco, TXBuilt 2015 · S/N 20059N954KHWilmington Trust Co Trustee · Wilmington, DEBuilt 2019 · S/N 20287N970AEPhi Health LLC · Tempe, AZBuilt 1999 · S/N 3235N971CCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2023 · S/N 21207N972ACVertical Aviation No 1 LLC · Miami, FLBuilt 2022 · S/N 21122N972CCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2021 · S/N 21047N979CCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2017 · S/N 20161N98CKAirbus Helicopters Inc · Grand Prairie, TXBuilt 2026 · S/N 21478N99523Ns Air Leasing LLC · Wilmington, DEBuilt 2001 · S/N 3461N995RCCounty Of Riverside California · Hemet, CABuilt 2019 · S/N 20280N9SPState Of New York · Latham, NYBuilt 2025 · S/N 21301
Back to AD 2016-08-16