OpenAirDocs.org
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.

N1980DJet Specialty Inc · Boerne, TXBuilt 2021 · S/N 2220N1980ZRegistered aircraftBuilt 2005 · S/N 20049N198HFHormel Foods Corporate Services LLC · Austin, MNBuilt 2019 · S/N 2176N1998CClyde Companies Inc · Orem, UTBuilt 2024 · S/N 20996N199HFHormel Foods Corporate Services LLC · Austin, MNBuilt 2014 · S/N 2051N19DMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2025 · S/N 55020237N1FCTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2015 · S/N 2079N1FGAdj 55 LLC · Woodcliff Lake, NJBuilt 2019 · S/N 2172N1HPHelmerich & Payne Inc · Tulsa, OKBuilt 2012 · S/N 20362N1JCN1jc Holdings LLC · West Long Branch, NJBuilt 2019 · S/N 2196N1MUMurphy Oil USA Inc · El Dorado, ARBuilt 2022 · S/N 20901N1RBBac Transportation Inc · Stockton, CABuilt 2005 · S/N 20073N1RCRegistered aircraftBuilt 2022 · S/N 20937N1SGAir Sansone LLC · Wilmington, DEBuilt 2004 · S/N 20025N1WNOren Air Services LLC · Orlando, FLBuilt 2024 · S/N 55020202N1YRandolph Aviation LLC · Naples, FLBuilt 2016 · S/N 55000060N200JBWilmington Trust Co Trustee · Wilmington, DEBuilt 2020 · S/N 20843N200JCClo Equipment LLC · Chicago, ILBuilt 2019 · S/N 20791N2025RRts Administrative Service Inc · Overland Park, KSBuilt 2025 · S/N 2303N202GAElectric Boat Corp · Groton, CTBuilt 2020 · S/N 2202N203CKMacs Aviation LLC · Columbus, INBuilt 2025 · S/N 21089N205DBCitation X Parts LLC · Liberty, NCBuilt 2005 · S/N 20074N206FPSeguin Holdings LLC · Chicago, ILBuilt 2008 · S/N 20220N206FSCommerce Bank · Saint Louis, MOBuilt 2019 · S/N 2198N209FBTail Aviation LLC · Woburn, MABuilt 2013 · S/N 2018N210SFBnsf Equipment Acquisition Company LLC · Fort Worth, TXBuilt 2024 · S/N 2287N211JBPiker LLC · Wheeling, ILBuilt 2012 · S/N 20353N21381Hardwicke Properties LLC · Houston, TXBuilt 2018 · S/N 20774N214RWMidwest Nas Inc · Onalaska, WIBuilt 2024 · S/N 21009N214SGSnj Partners Eb5 Fund LLC · Mesquite, TXBuilt 2002 · S/N 20004N215BVTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2017 · S/N 55000021N215DAStravinski Development Group LLC · Madera, CABuilt 2010 · S/N 20304N217SGGiddy Air LLC · Fredonia, NYBuilt 2025 · S/N 21093N218KFKw Flight LLC · Bozeman, MTBuilt 2013 · S/N 20438N21FEFedex Freight Inc · Memphis, TNBuilt 2012 · S/N 20352N21FRFlying Fox LLC · Phoenix, AZBuilt 2018 · S/N 20747N220FXJsa Investments LLC · Cleveland, OHBuilt 2025 · S/N 21075N2218HRegistered aircraftBuilt 2025 · S/N 21081N221FXExeter Aviation LLC · Cleveland, OHBuilt 2025 · S/N 21080N221SVHigh Hills LLC · Clinton, NCBuilt 2012 · S/N 20380N222FXDkl-Flex LLC · Cleveland, OHBuilt 2025 · S/N 21101N222XCAlliance Air Parts Acquisitions Corp · Oklahoma City, OKBuilt 2004 · S/N 20044N223FXFlexjet LLC · Cleveland, OHBuilt 2025 · S/N 21102N223RRegistered aircraftBuilt 2016 · S/N 55010005N223TVNueve Capital Corp · New York, NYBuilt 2007 · S/N 20151N225DDD&D 2000 Air LLC · Wilmington, DEBuilt 2017 · S/N 20182N225FWFlying W LLC · Greenwich, CTBuilt 2018 · S/N 20725N225JRCbls Charters LLC · Wilmington, DEBuilt 2019 · S/N 20785N22805Liqwd Inc · Santa Barbara, CABuilt 2019 · S/N 2184N228BARegistered aircraftBuilt 2016 · S/N 2103
Back to AD 2018-04-13