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.

N811STNaval Air Systems Command · Patuxent River, MDBuilt 2022 · S/N 15837N814WFRed Hawk Management LLC · Ocilla, GABuilt 2011 · S/N 22237N81NMNorth Memorial Health Care · Brooklyn Center, MNBuilt 2008 · S/N 22086N820FTBristow LLC · Lake Charles, LABuilt 2007 · S/N 11701N822MMBristow LLC · Lake Charles, LABuilt 2005 · S/N 14055N823STNaval Air Systems Command · Patuxent River, MDBuilt 2022 · S/N 15838N824STLeonardo Helicopters US Corp · Philadelphia, PAS/N 15939N826STNaval Air Systems Command · Patuxent River, MDBuilt 2022 · S/N 15840N827KUEurotec Vertical Flight Solutions LLC · Eudora, KSS/N 11609N828STNaval Air Systems Command · Patuxent River, MDBuilt 2022 · S/N 15841N829STNaval Air Systems Command · Patuxent River, MDBuilt 2023 · S/N 15842N830STNaval Air Systems Command · Patuxent River, MDBuilt 2023 · S/N 15843N831STNaval Air Systems Command · Patuxent River, MDBuilt 2023 · S/N 15844N832STNaval Air Systems Command · Patuxent River, MDBuilt 2023 · S/N 15845N835STNaval Air Systems Command · Patuxent River, MDBuilt 2023 · S/N 15846N836STNaval Air Systems Command · Patuxent River, MDBuilt 2023 · S/N 15847N837STNaval Air Systems Command · Patuxent River, MDBuilt 2023 · S/N 15848N839STNaval Air Systems Command · Patuxent River, MDS/N 15850N843STNaval Air Systems Command · Patuxent River, MDBuilt 2023 · S/N 15851N845STNaval Air Systems Command · Patuxent River, MDBuilt 2023 · S/N 15852N846STNaval Air Systems Command · Patuxent River, MDBuilt 2023 · S/N 15853N847STNaval Air Systems Command · Patuxent River, MDBuilt 2023 · S/N 15854N848STNaval Air Systems Command · Patuxent River, MDBuilt 2023 · S/N 15855N849STNaval Air Systems Command · Patuxent River, MDBuilt 2023 · S/N 15856N852STNaval Air Systems Command · Patuxent River, MDBuilt 2023 · S/N 15857N853STNaval Air Systems Command · Patuxent River, MDBuilt 2023 · S/N 15859N854STNaval Air Systems Command · Patuxent River, MDBuilt 2023 · S/N 15860N859STNaval Air Systems Command · Patuxent River, MDBuilt 2023 · S/N 15862N85KVKhosla Ventures LLC · San Jose, CABuilt 2002 · S/N 11145N860STNaval Air Systems Command · Patuxent River, MDBuilt 2023 · S/N 15863N861STNaval Air Systems Command · Patuxent River, MDBuilt 2023 · S/N 15864N863STNaval Air Systems Command · Patuxent River, MDBuilt 2023 · S/N 15865N869STNaval Air Systems Command · Patuxent River, MDBuilt 2023 · S/N 15866N882STNaval Air Systems Command · Patuxent River, MDBuilt 2023 · S/N 15867N883STNaval Air Systems Command · Patuxent River, MDBuilt 2023 · S/N 15868N890PAAgustawestland Philadelphia Corp · Philadelphia, PANon-citizen corporation, flight hours not reportedS/N 22422N901CMLifeflight Of Maine LLC · Bangor, MEBuilt 2004 · S/N 11611N901EMLifeflight Of Maine LLC · Bangor, MEBuilt 2004 · S/N 11614N901LFLifeflight Of Maine LLC · Bangor, MEBuilt 2019 · S/N 22400N901WMLifeflight Of Maine · Bangor, MEBuilt 2021 · S/N 22429N901XMLifeflight Of Maine LLC · Bangor, MEBuilt 2020 · S/N 22422N901YMLifeflight Of Maine LLC · Bangor, MEBuilt 2018 · S/N 22375N902JANaval Air Systems Command · Patuxent River, MDBuilt 2023 · S/N 15878N903JANaval Air Systems Command · Patuxent River, MDS/N 15879N903STNaval Air Systems Command · Patuxent River, MDBuilt 2023 · S/N 15858N906JANaval Air Systems Command · Patuxent River, MDBuilt 2024 · S/N 15880N908STNaval Air Systems Command · Patuxent River, MDBuilt 2023 · S/N 15871N909JANaval Air Systems Command · Patuxent River, MDBuilt 2024 · S/N 15886N909STNaval Air Systems Command · Patuxent River, MDBuilt 2023 · S/N 15874N90NMNorth Memorial Health Care · Minneapolis, MNBuilt 2007 · S/N 22044
Back to AD 2020-21-21