AD 2017-04-01

Registered aircraft · 377

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:2017-04-01')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2017-04-01')
  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.

N2000STvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2015 · S/N 6133N200AExxon Mobil Corp · Houston, TXBuilt 2023 · S/N 6548N201ACWilmington Trust Co Trustee · Providence, RIBuilt 2023 · S/N 6551N201CETvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2014 · S/N 6074N2030PRegistered aircraftBuilt 2021 · S/N 6476N20CPRegistered aircraftBuilt 2018 · S/N 6347N20RCBristol Air LLC · Missoula, MTBuilt 2017 · S/N 6300N212DDTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2020 · S/N 6438N221DGDavid Geffen Co · Los Angeles, CABuilt 2013 · S/N 6061N228ZDTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2015 · S/N 6126N22TRegistered aircraftBuilt 2015 · S/N 6151N232GBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 6365N232KN232k LLC · Midland, TXBuilt 2021 · S/N 6478N235BHHamilton Aviation Inc · Portland, ORBuilt 2016 · S/N 6222N236MJMj Air LLC · Washington, DCBuilt 2024 · S/N 6579N23DCRegistered aircraftBuilt 2017 · S/N 6287N241CETvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2018 · S/N 6310N2425JTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2023 · S/N 6524N244DSDs Aviation LLC · Indianapolis, INBuilt 2021 · S/N 6458N2461KSix Fifty Holdings LLC · Uniondale, NYBuilt 2014 · S/N 6102N265ECFam LLC · Bell, CABuilt 2021 · S/N 6456N267BWNamaya Inc · Latrobe, PABuilt 2015 · S/N 6156N2702Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2019 · S/N 6412N270LEDtaa LLC · Dallas, TXBuilt 2015 · S/N 6164N282SFTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2022 · S/N 6495N28UDBank Of Utah Trustee · Salt Lake City, UTBuilt 2023 · S/N 6542N298ALBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 6342N298WFrc Holding Inc V · Dover, DES/N 6410N2CTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2021 · S/N 6485N2LFTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2019 · S/N 6420N2NBank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 6298N2PGProcter & Gamble Leasing LLC · Cincinnati, OHBuilt 2017 · S/N 6264N302TRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2017 · S/N 6259N303HMOdyssey Adventures LLC · Centennial, COBuilt 2018 · S/N 6345N305KNRegistered aircraftBuilt 2015 · S/N 6142N309TTT-Bird Aviation LLC · West Chicago, ILBuilt 2012 · S/N 6012N311WMRegistered aircraftBuilt 2024 · S/N 6586N312ATBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 6010N312DSDs V Aviation LLC · Beaverton, ORBuilt 2020 · S/N 6449N313AGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2019 · S/N 6375N313RGRenair 650 LLC · New York, NYBuilt 2017 · S/N 6262N317LLJrk Property Holdings Inc · Los Angeles, CABuilt 2023 · S/N 6537N318JSBank Of Utah Trustee · Salt Lake City, UTBuilt 2022 · S/N 6525N318LSRegistered aircraftBuilt 2016 · S/N 6204N319PEPlus3 Aviation LLC · West Hollywood, CABuilt 2016 · S/N 6219N3251KTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2016 · S/N 6192N325APTalaria Logistics LLC · Denver, COBuilt 2017 · S/N 6276N329SXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2016 · S/N 6224N331ABAircraft Trust & Financing Corp Trustee · Wilmington, DEBuilt 2022 · S/N 6487N333GWBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 6099
Back to AD 2017-04-01