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.

N910LBBristow LLC · Lake Charles, LABuilt 2006 · S/N 11682N913JANaval Air Systems Command · Patuxent River, MDBuilt 2024 · S/N 15881N915JANaval Air Systems Command · Patuxent River, MDBuilt 2024 · S/N 15882N915STNaval Air Systems Command · Patuxent River, MDBuilt 2023 · S/N 15839N918JANaval Air Systems Command · Patuxent River, MDBuilt 2024 · S/N 15883N919STNaval Air Systems Command · Patuxent River, MDBuilt 2023 · S/N 15876N91LFInternational Defense & Aerospace Group LLC · Glen Mills, PABuilt 2002 · S/N 11509N91SVSaint Vincent Mercy Medical Center · Toledo, OHS/N 11627N920JANaval Air Systems Command · Patuxent River, MDBuilt 2024 · S/N 15884N920JDBristow LLC · Lake Charles, LABuilt 2009 · S/N 14745N921LFLife Flight Network LLC · Aurora, ORBuilt 2002 · S/N 11142N922JANaval Air Systems Command · Patuxent River, MDBuilt 2024 · S/N 15885N922LFEurotec Vertical Flight Solutions LLC · Eudora, KSS/N 11149N923LFEurotec Vertical Flight Solutions LLC · Eudora, KSBuilt 2003 · S/N 11220N924STNaval Air Systems Command · Patuxent River, MDBuilt 2023 · S/N 15869N925STNaval Air Systems Command · Patuxent River, MDBuilt 2023 · S/N 15872N926STNaval Air Systems Command · Patuxent River, MDBuilt 2023 · S/N 15870N92LFEurotec Vertical Flight Solutions LLC · Eudora, KSBuilt 2004 · S/N 11604N930JANaval Air Systems Command · Patuxent River, MDS/N 15887N932JANaval Air Systems Command · Patuxent River, MDBuilt 2024 · S/N 15888N933JANaval Air Systems Command · Patuxent River, MDBuilt 2024 · S/N 15889N934JANaval Air Systems Command · Patuxent River, MDBuilt 2024 · S/N 15890N934STNaval Air Systems Command · Patuxent River, MDBuilt 2023 · S/N 15849N935JANaval Air Systems Command · Patuxent River, MDBuilt 2024 · S/N 15891N935STNaval Air Systems Command · Patuxent River, MDBuilt 2023 · S/N 15873N936JANaval Air Systems Command · Patuxent River, MDBuilt 2024 · S/N 15892N936STNaval Air Systems Command · Patuxent River, MDBuilt 2023 · S/N 15875N937JANaval Air Systems Command · Patuxent River, MDBuilt 2024 · S/N 15893N939JANaval Air Systems Command · Patuxent River, MDBuilt 2024 · S/N 15894N940JANaval Air Systems Command · Patuxent River, MDBuilt 2024 · S/N 15895N941STNaval Air Systems Command · Patuxent River, MDBuilt 2021 · S/N 15801N942JANaval Air Systems Command · Patuxent River, MDBuilt 2024 · S/N 15896N943JANaval Air System Command · Patuxent River, MDBuilt 2024 · S/N 15897N944JANaval Air Systems Command · Patuxent River, MDBuilt 2024 · S/N 15898N944STNaval Air Systems Command · Patuxent River, MDBuilt 2021 · S/N 15802N945STNaval Air Systems Command · Patuxent River, MDBuilt 2021 · S/N 15803N946JANaval Air Systems Command · Patuxent River, MDBuilt 2024 · S/N 15899N946STNaval Air Systems Command · Patuxent River, MDBuilt 2021 · S/N 15804N947JANaval Air Systems Command · Patuxent River, MDBuilt 2024 · S/N 15900N947STNaval Air Systems Command · Patuxent River, MDBuilt 2022 · S/N 15805N948STNaval Air Systems Command · Patuxent River, MDBuilt 2022 · S/N 15806N949STNaval Air Systems Commnad · Patuxent River, MDBuilt 2022 · S/N 15807N94AHEurotec Vertical Flight Solutions LLC · Eudora, KSBuilt 2000 · S/N 11081N952STNaval Air Systems Command · Patuxent River, MDBuilt 2022 · S/N 15808N953JANaval Air Systems Command · Pat, MDBuilt 2024 · S/N 15901N955STNaval Air Systems Command · Patuxent River, MDBuilt 2025 · S/N 15809N956JANaval Air Systems Command · Patuxent River, MDBuilt 2024 · S/N 15902N956STNaval Air Systems Command · Patuxent River, MDBuilt 2025 · S/N 15810N958JANaval Air Systems Command · Patuxent River, MDBuilt 2024 · S/N 15903N959STNaval Air Systems Command · Patuxent River, MDBuilt 2025 · S/N 15811
Back to AD 2020-21-21