AD 2020-21-21

Registered aircraft · 308

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:2020-21-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:2020-21-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.

N959TGNaval Air Systems Command · Patuxent River, MDBuilt 2024 · S/N 15904N95RZSt Vincent Mercy Medical Center · Toledo, OHBuilt 2002 · S/N 11147N960TGNaval Air Systems Command · Patuxent River, MDBuilt 2024 · S/N 15905N961STNaval Air Systems Command · Patuxent River, MDBuilt 2024 · S/N 15812N961TGNaval Air Systems Command · Patuxent River, MDBuilt 2024 · S/N 15906N962JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 22047N962STNaval Air Systems Command · Patuxent River, MDBuilt 2024 · S/N 15813N962TGNaval Air Systems Command · Patuxent River, MDBuilt 2024 · S/N 15907N963JERegistered aircraftAssigned (import), pending cancellationS/N 22016N963KPKinetica Energy Express LLC · Patterson, LABuilt 2017 · S/N 14949N963STNaval Air Systems Command · Patuxent River, MDBuilt 2024 · S/N 15814N963TGNaval Air Systems Command · Patuxent River, MDBuilt 2024 · S/N 15908N964STNaval Air Systems Commando · Patuxent River, MDBuilt 2022 · S/N 15815N964TGNaval Air Systems Command · Patuxent River, MDBuilt 2024 · S/N 15909N965KPKinetica Energy Express LLC · Patterson, LABuilt 2017 · S/N 14947N965TGNaval Air Systems Command · Patuxent River, MDBuilt 2024 · S/N 15910N966KPKinetica Deepwater Express LLC · Patterson, LABuilt 2010 · S/N 14761N966TGNaval Air Systems Command · Patuxent River, MDBuilt 2024 · S/N 15911N967STNaval Air Systems Command · Patuxent River, MDBuilt 2022 · S/N 15816N968STNaval Air Systems Command · Patuxent River, MDBuilt 2022 · S/N 15817N968TGNaval Air Systems Command · Patuxent River, MDBuilt 2024 · S/N 15912N969STNaval Air Systems Command · Patuxent River, MDBuilt 2022 · S/N 15818N970TGNaval Air Systems Command · Patuxent River, MDBuilt 2024 · S/N 15913N972STNaval Air Systems Command · Patuxent River, MDBuilt 2022 · S/N 15819N972TGNaval Air Systems Command · Patuxent River, MDBuilt 2024 · S/N 15914N973RABlue Horizon Aviation Charter LLC · Las Vegas, NVBuilt 2017 · S/N 14930N973STNaval Air Systems Command · Patuxent River, MDBuilt 2022 · S/N 15820N973TGNaval Air Systems Command · Patuxent, MDBuilt 2025 · S/N 15915N974STNaval Air Systems Command · Patuxent River, MDBuilt 2022 · S/N 15821N974TGNaval Air Systems Command · Patuxent River, MDBuilt 2025 · S/N 15916N975STNaval Air Systems Command · Patuxent River, MDBuilt 2023 · S/N 15822N975TGNaval Air Command · Patuxent Rd, MDBuilt 2025 · S/N 15917N976STNaval Air Systems Command · Patuxent River, MDBuilt 2024 · S/N 15823N976TGNaval Air Systems Command · Patuxent River, MDBuilt 2025 · S/N 15918N977TGNaval Air Systems Command · Patuxent River, MDBuilt 2025 · S/N 15919N978STNaval Air Systems Command · Patuxent River, MDBuilt 2022 · S/N 15824N978TGNaval Air Systems Command · Patuxent River, MDBuilt 2025 · S/N 15920N979STNaval Air Systems Command · Patuxent River, MDBuilt 2022 · S/N 15825N979TGNaval Air Systems Command · Patuxent River, MDBuilt 2025 · S/N 15921N980TGNaval Air Systems Command · Patuxent River, MDBuilt 2025 · S/N 15922N981STNaval Air Systems Command · Patuxent River, MDBuilt 2024 · S/N 15826N981TGNaval Air Systems Command · Patuxent River, MDBuilt 2025 · S/N 15923N982TGNaval Air Systems Command · Patuxent River, MDBuilt 2025 · S/N 15924N983STNaval Air Systems Command · Patuxent River, MDBuilt 2022 · S/N 15827N983TGNaval Air Systems Command · Patuxent River, MDBuilt 2025 · S/N 15925N984STNaval Air Systems Command · Patuxent River, MDBuilt 2022 · S/N 15828N984TGNaval Air Systems Command · Patuxent River, MDBuilt 2025 · S/N 15926N985STNaval Air Systems Command · Patuxent River, MDBuilt 2022 · S/N 15829N986TGNaval Air Systems Command · Patuxent River, MDBuilt 2025 · S/N 15927N987CUTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2015 · S/N 14917
Back to AD 2020-21-21