AD 2018-04-13

Registered aircraft · 1,373

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:2018-04-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:2018-04-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.

N4752WNobska LLC · New Castle, DEBuilt 2025 · S/N 55020250N475PJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 55010053N476FXPrc Partners LLC · Cleveland, OHBuilt 2022 · S/N 55010103N477RTRtr Express LLC · Marshfield, WIBuilt 2024 · S/N 21039N477SCRegistered aircraftBuilt 2019 · S/N 20823N479PFGenmark Ventures LLC · Boca Raton, FLBuilt 2009 · S/N 20255N480CBComerica Leasing Corp · Dallas, TXBuilt 2019 · S/N 20811N482RSPraetor Ssi LLC · Lighthouse Point, FLBuilt 2021 · S/N 55020139N484EMRegistered aircraftBuilt 2018 · S/N 2156N487JAJ & Ak Aviation LLC · Kansas City, MOBuilt 2014 · S/N 20439N488VCOaklr LLC · New York, NYBuilt 2022 · S/N 20932N495ECEdwards Challenger 300 LLC · Columbus, OHBuilt 2006 · S/N 20131N4BZPalmetto Construction Group III LLC · Sumter, SCBuilt 2019 · S/N 20814N4MXB&G Air Inc · Morgan City, LABuilt 2008 · S/N 20223N500CGAmalgamated Consolidated LLC · Pittsburgh, PABuilt 2024 · S/N 21032N500FXFlexjet LLC · Cleveland, OHBuilt 2022 · S/N 20924N500MLBarkley Services LLC · Beaverton, ORBuilt 2019 · S/N 55010058N500NBRegistered aircraftBuilt 2021 · S/N 55010079N500RRegistered aircraftBuilt 2016 · S/N 2093N500RPPts As LLC · New Castle, DEBuilt 2023 · S/N 2272N500VCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2012 · S/N 55000016N501FXFlexjet LLC · Cleveland, OHBuilt 2022 · S/N 20925N501KAAllen Aircraft Equipment LLC · Valparaiso, INBuilt 2024 · S/N 21002N502FX95 Management LLC · Cleveland, OHBuilt 2022 · S/N 20929N502RPOmicron Transportation Inc · New Castle, DEBuilt 2018 · S/N 2142N503FXFlexjet LLC · Cleveland, OHBuilt 2022 · S/N 20930N503KJCrawford Leasing Company LLC · Wichita, KSBuilt 2007 · S/N 20188N504FXFlexjet LLC · Cleveland, OHBuilt 2022 · S/N 20933N504RPPts As LLC · Reading, PABuilt 2017 · S/N 2136N505FXFlexjet LLC · Cleveland, OHBuilt 2022 · S/N 20934N506FXFlexjet LLC · Cleveland, OHBuilt 2023 · S/N 20941N506RPPts As LLC · Reading, PABuilt 2018 · S/N 2162N507FXSempra Energy · Cleveland, OHBuilt 2023 · S/N 20947N507RPPts As LLC · New Castle, DEBuilt 2024 · S/N 2288N508FXFlexjet LLC · Cleveland, OHBuilt 2023 · S/N 20952N508XJBank Of Utah Trustee · Salt Lake City, UTBuilt 2003 · S/N 20008N509EEBank Of Utah Trustee · Salt Lake City, UTBuilt 2024 · S/N 55010109N509FXFlexjet LLC · Cleveland, OHBuilt 2023 · S/N 20953N509SBSbco Cj3 LLC · Denver, COBuilt 2015 · S/N 20580N50LFLeprino Foods Co · Denver, COBuilt 2014 · S/N 20511N510FXFlexjet LLC · Cleveland, OHBuilt 2023 · S/N 20963N510SEStar Chaser LLC · Owensboro, KYBuilt 2016 · S/N 55000040N511FCMaryland Group LLC · Saint Louis, MOBuilt 2006 · S/N 20141N511FXFlexjet LLC · Cleveland, OHBuilt 2023 · S/N 20964N512FXFlexjet LLC · Cleveland, OHBuilt 2023 · S/N 20978N513CSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2026 · S/N 55010200N513FXMotorola Solutions Inc · Cleveland, OHBuilt 2024 · S/N 20995N513MGMgpg Management LLC · San Diego, CABuilt 2017 · S/N 2126N514FXBanks Lee C Trustee · Cleveland, OHBuilt 2024 · S/N 20998N514TXIe Aviation LLC · Price, UTBuilt 2016 · S/N 55010015
Back to AD 2018-04-13