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.

N350PHPamplemousse Corp · Wilmington, DEBuilt 2015 · S/N 20571N350PRMmr West LLC · Salem, ORBuilt 2018 · S/N 20779N350RMBeyond Ventures LLC · Ellicott City, MDBuilt 2015 · S/N 20605N350RXRamsey Craig · Santa Rosa, CABuilt 2015 · S/N 20582N350TTN350tt LLC · Dover, DEBuilt 2026 · S/N 21120N350VJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2015 · S/N 20569N350XADodson International Parts Inc · Rantoul, KSBuilt 2018 · S/N 20749N350XJRegistered aircraftBuilt 2017 · S/N 20677N350XKRegistered aircraftBuilt 2019 · S/N 20816N350XXPete Mitchell Aviation LLC · Plantation, FLBuilt 2004 · S/N 20019N351ECE C Aviation Services Inc · Zeeland, MIBuilt 2016 · S/N 20625N351JLLink Snacks Inc · Hayward, WIBuilt 2018 · S/N 20775N351SDDynamic Aviation LLC · Fort Wayne, INBuilt 2024 · S/N 21020N351TSCmfg Life Insurance Co · Madison, WIBuilt 2018 · S/N 20735N351VJBank Of Utah Trustee · Salt Lake City, UTBuilt 2015 · S/N 20573N352ECE C Aviation Services Inc · Zeeland, MIBuilt 2025 · S/N 21072N353PCQuantum Aviation LLC · Tampa, FLBuilt 2005 · S/N 20053N353SFSmithfield Packaged Meats Corp · Smithfield, VABuilt 2017 · S/N 55000053N354ASSoave Aviation LLC · Plymouth, MIBuilt 2022 · S/N 20914N354WGAutomatic Press LLC · Horseshoe Bay, TXBuilt 2012 · S/N 20354N355ZBZimmer Biomet Leasing LLC · Warsaw, INBuilt 2025 · S/N 21083N356MLAviation Travel Ventures LLC · Melbourne, FLBuilt 2005 · S/N 20075N356VJBank Of Utah Trustee · Salt Lake City, UTBuilt 2015 · S/N 20546N357CZCz Equipment LLC · Hollywood, FLBuilt 2015 · S/N 20597N357EEDeployment Logistics LLC · Fort Lauderdale, FLBuilt 2023 · S/N 55020181N357KGN357kg LLC · Bluffton, SCBuilt 2003 · S/N 20012N357TWLazer Aviation LLC · Orange Park, FLBuilt 2011 · S/N 20314N357VJBank Of Utah Trustee · Salt Lake City, UTBuilt 2015 · S/N 20550N358MHIci Aviation Leasing LLC · Daytona Beach, FLBuilt 2017 · S/N 20680N358VJBank Of Utah Trustee · Salt Lake City, UTBuilt 2021 · S/N 20890N359GSUS Bank Na Trustee · Hartford, CTBuilt 2017 · S/N 2135N359VJBank Of Utah Trustee · Salt Lake City, UTBuilt 2022 · S/N 20904N35FEFederal Express Leasing Corp · Memphis, TNBuilt 2013 · S/N 20408N360LRegistered aircraftBuilt 2016 · S/N 20635N360VJBank Of Utah Trustee · Salt Lake City, UTBuilt 2022 · S/N 20907N361JLLink Snacks Inc · Hayward, WIBuilt 2023 · S/N 20944N362JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2008 · S/N 20249N362LRegistered aircraftBuilt 2010 · S/N 20291N365AVN365av LLC · Chandler, AZBuilt 2017 · S/N 20669N365LRegistered aircraftBuilt 2009 · S/N 20271N365MGTvpx Trust Co LLC Trustee · North Salt Lake, UTBuilt 2018 · S/N 20771N365SCBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 2182N3688Umb Bank Na Trustee · Salt Lake City, UTBuilt 2023 · S/N 2262N369LLStrategic Leasing LLC · Seattle, WABuilt 2019 · S/N 20824N370DPaccar Inc · Seatac, WABuilt 2025 · S/N 2320N370DBCitation X Parts LLC · Liberty, NCBuilt 2005 · S/N 20056N370ELLge Management Partners LLC · Phoenix, AZBuilt 2013 · S/N 20399N371DBCitation X Parts LLC · Liberty, NCBuilt 2005 · S/N 20064N371JGNih-Aviation LLC · Charlotte, NCBuilt 2012 · S/N 20371N371JLLink Snacks Inc · Minong, WIBuilt 2024 · S/N 21037
Back to AD 2018-04-13