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.

N616FXBaratz Alan · Cleveland, OHBuilt 2025 · S/N 55020251N617FXFlexjet LLC · Cleveland, OHBuilt 2025 · S/N 55020244N618FXCf Five LLC · Cleveland, OHBuilt 2025 · S/N 55020247N618HLDoradopraetor LLC · Dorado Beach, PRBuilt 2023 · S/N 55020191N619FXFried Aviation LLC · Cleveland, OHBuilt 2026 · S/N 55020268N61MNRegistered aircraftBuilt 2020 · S/N 55020116N620FJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2021 · S/N 2224N621PPPpc Excursions Inc · Lancaster, PABuilt 2025 · S/N 21090N621WKBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 2179N622DJZero Six Air LLC · Indianapolis, INBuilt 2012 · S/N 2012N622LMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2025 · S/N 55020224N622NNicholas Services LLC · Oxford, MSBuilt 2010 · S/N 20286N623LJlo Aviation LLC · Wallingford, CTBuilt 2014 · S/N 2059N623NNicholas Services LLC · Oxford, MSBuilt 2019 · S/N 20833N627EEBluestone 214 LLC · Richmond, VABuilt 2006 · S/N 20119N628GGeneral Dynamics Mission Systems Inc · Fairfax, VABuilt 2016 · S/N 2097N629ERegistered aircraftBuilt 2016 · S/N 55010010N629PTBbr Air LLC · Franklin, TNBuilt 2016 · S/N 55010007N62AEAir Eagle LLC · Detroit, MIBuilt 2014 · S/N 2041N62KPOag Aviation LLC · Texarkana, TXBuilt 2022 · S/N 55010090N630ABBerlin Aviation LLC · Glencoe, ILBuilt 2017 · S/N 20684N631RPJsv Aviation Ventures 631 LLC · Dallas, TXBuilt 2019 · S/N 20784N631SFTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2018 · S/N 2161N632BALebeouf Bros Towing LLC · Bourg, LABuilt 2006 · S/N 20113N632BLPacific Legacy LLC · Newark, DEBuilt 2018 · S/N 55000079N633MGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2024 · S/N 55020226N633NNicholas Services LLC · Oxford, MSBuilt 2020 · S/N 20860N633SFTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2018 · S/N 2152N633TXMarquis Asset Leasing LLC · Dallas, TXBuilt 2018 · S/N 20763N635SFTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2017 · S/N 2132N636RHGuarantee Management Services LLC · Glenview, ILBuilt 2016 · S/N 20613N63WRFour S'S LLC · Greenville, NCBuilt 2017 · S/N 20718N642DMMiller Challenger LLC · Dallas, TXBuilt 2008 · S/N 20199N644KMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2024 · S/N 55020199N649SPStandard Process Inc · Palmyra, WIBuilt 2021 · S/N 55010076N650MPGis Air LLC · Galliano, LABuilt 2014 · S/N 2060N653JCRegistered aircraftBuilt 2025 · S/N 2314N655MCWes Aviation LLC · Texarkana, TXBuilt 2016 · S/N 55000050N657PTRegistered aircraftBuilt 2017 · S/N 2114N658TCRegistered aircraftBuilt 2023 · S/N 55020194N659MMi-Transport Emb249 P600 LLC · Brownsville, WIBuilt 2025 · S/N 55020249N660CTAntelope Leasing LLC · Phoenix, AZBuilt 2023 · S/N 55020187N664PWilmington Trust Co Trustee · Wilmington, DEBuilt 2025 · S/N 55020252N665APSanderson Aviation LLC · Laurel, MSBuilt 2024 · S/N 2278N665KBMastercorp Aviation LLC · Crossville, TNBuilt 2025 · S/N 55020232N666WXMkair Holdings LLC · Fort Lauderdale, FLBuilt 2022 · S/N 2236N669PVService Department LLC · Warren, MIBuilt 2024 · S/N 2295N670CPSalep Corp · Miami, FLBuilt 2011 · S/N 20313N672DEAir Persistence LLC · Boston, MABuilt 2017 · S/N 20672N672PPRegistered aircraftBuilt 2024 · S/N 20993
Back to AD 2018-04-13