AD 2024-05-13

Registered aircraft · 335

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:2024-05-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:2024-05-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.

N335FXFlexjet LLC · Cleveland, OHBuilt 2023 · S/N 55010119N336FXFlexjet LLC · Cleveland, OHBuilt 2023 · S/N 55010118N337FXGabbert John · Cleveland, OHBuilt 2023 · S/N 55010116N338FXFlexjet LLC · Cleveland, OHBuilt 2023 · S/N 55010114N339FXTj Point LLC · Cleveland, OHBuilt 2023 · S/N 55010112N340FXFlexjet LLC · Cleveland, OHBuilt 2023 · S/N 55010111N342FXMansefeldt Investment Corp · Cleveland, OHBuilt 2023 · S/N 55010110N343FXFlexjet LLC · Cleveland, OHBuilt 2023 · S/N 55010107N345FXFlexjet LLC · Cleveland, OHBuilt 2023 · S/N 55010105N350LMBank Of Utah Trustee · Salt Lake City, UTBuilt 2015 · S/N 55000031N353SFSmithfield Packaged Meats Corp · Smithfield, VABuilt 2017 · S/N 55000053N357EEDeployment Logistics LLC · Fort Lauderdale, FLBuilt 2023 · S/N 55020181N375KRNelson Family Holdings LLC · Wisconsin Dells, WIBuilt 2015 · S/N 55000018N379LGBank Of Utah Trustee · Salt Lake City, UTBuilt 2015 · S/N 55000033N383PATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2025 · S/N 55010173N386CWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2024 · S/N 55020215N393BWMi-Transport L450 Legacy LLC · Brownsville, WIBuilt 2017 · S/N 55010024N3CACarlock Air LLC · Nashville, TNBuilt 2024 · S/N 55010135N400RJOs Companies Inc · Denver, COBuilt 2022 · S/N 55020168N403FXGlobal Foundries US Inc · Cleveland, OHBuilt 2022 · S/N 55010099N405FXFlexjet LLC · Cleveland, OHBuilt 2016 · S/N 55010009N406ADSagaponack Aircraft LLC · Sagaponack, NYBuilt 2020 · S/N 55020125N406FXFlexjet LLC · Cleveland, OHBuilt 2016 · S/N 55010011N406SCNcpa Logistics LLC · Pittsburgh, PABuilt 2021 · S/N 55020143N407FXFlexjet LLC · Cleveland, OHBuilt 2016 · S/N 55010017N408FXFlexjet LLC · Cleveland, OHBuilt 2016 · S/N 55010018N409FXFlexjet LLC · Cleveland, OHBuilt 2016 · S/N 55010021N410FXFlexjet LLC · Cleveland, OHBuilt 2017 · S/N 55010025N411FXBank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 55010028N413FXBank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 55010030N414FXFlexjet LLC · Cleveland, OHBuilt 2017 · S/N 55010031N415FXFlexjet LLC · Cleveland, OHBuilt 2017 · S/N 55010032N416FXFlexjet LLC · Cleveland, OHBuilt 2017 · S/N 55010033N417FXFlexjet LLC · Cleveland, OHBuilt 2018 · S/N 55010036N418FXFlexjet LLC · Cleveland, OHBuilt 2018 · S/N 55010037N419FXFlexjet LLC · Cleveland, OHBuilt 2018 · S/N 55010038N420FXFlexjet LLC · Cleveland, OHS/N 55010040N421FXFlexjet LLC · Cleveland, OHBuilt 2018 · S/N 55010041N422FXFlexjet LLC · Cleveland, OHBuilt 2018 · S/N 55010045N423FXFlexjet LLC · Cleveland, OHBuilt 2019 · S/N 55010055N424FXFlexjet LLC · Cleveland, OHBuilt 2019 · S/N 55010061N426FXFlexjet LLC · Cleveland, OHBuilt 2019 · S/N 55010064N427FXFlexjet LLC · Cleveland, OHBuilt 2019 · S/N 55010065N428FXFlexjet LLC · Cleveland, OHBuilt 2022 · S/N 55010101N428PCsc Delaware Trust Co Trustee · Wilmington, DES/N 55020266N429FXFlexjet LLC · Cleveland, OHBuilt 2019 · S/N 55010066N430FXFlexjet LLC · Cleveland, OHBuilt 2019 · S/N 55010067N431FXFlexjet LLC · Cleveland, OHBuilt 2020 · S/N 55010070N432FXFlexjet LLC · Cleveland, OHBuilt 2020 · S/N 55010071N433FXFlexjet LLC · Cleveland, OHBuilt 2020 · S/N 55010072
Back to AD 2024-05-13