AD 2018-07-17

Registered aircraft · 120

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-07-17')
    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-07-17')
  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.

N534MECenter For Emergency Medicine Of Western Pa · West Mifflin, PABuilt 2020 · S/N 2134N536MECenter For Emergency Medicine Of Western Pa · West Mifflin, PABuilt 2017 · S/N 2036N537MECenter For Emergency Medicine Of Western Pennsylva · West Mifflin, PABuilt 2020 · S/N 2136N544MECenter For Emergency Medicine Of Western Pa · West Mifflin, PABuilt 2023 · S/N 2244N549AMAir Methods LLC · Greenwood Village, COBuilt 2025 · S/N 2336N552TJAir Methods LLC · Greenwood Village, COBuilt 2007 · S/N 0552N576MECenter For Emergency Medicine Of Western Pennsylva · West Mifflin, PABuilt 2024 · S/N 2276N579AMAir Methods LLC · Greenwood Village, COBuilt 2007 · S/N 0578N579MECenter For Emergency Medicine Of Western Penn · West Mifflin, PABuilt 2024 · S/N 2279N589MECenter For Emerg Med Of W Penn Stat Medevac Prog · West Mifflin, PABuilt 2022 · S/N 2189N590MECenter For Emergency Medicine Of Western Pa · West Mifflin, PABuilt 2022 · S/N 2190N60ZXTonik Air LLC · Las Vegas, NVBuilt 1998 · S/N 0039N620MECenter For Emergency Medicine Of Western Pa · West Mifflin, PABuilt 2025 · S/N 2320N635WVanderbilt University Medical Center · Nashville, TNBuilt 2007 · S/N 0635N641MECtr For Emergency Medicine Of Western Pennsylvania · West Mifflin, PABuilt 2023 · S/N 2241N691CMG200 LLC · San Juan, PRBuilt 2022 · S/N 2200N735VTRegistered aircraftBuilt 2016 · S/N 1219N740MHMetro Aviation Inc · Shreveport, LABuilt 2008 · S/N 0740N775TCUS Department Of Homeland Security · Washington, DCBuilt 2002 · S/N 3622N802MHWorld Trade Enterprises LLC · Lucas, TXBuilt 2003 · S/N 3707N811MECenter For Emergency Medicine Of Western Pa · West Mifflin, PABuilt 2015 · S/N 1201N81LNAir Methods LLC · Greenwood Village, COBuilt 2025 · S/N 2335N822PPMassachusetts State Police · Plymouth, MABuilt 2021 · S/N 2150N823JMMassachusetts State Police · Plymouth, MABuilt 2014 · S/N 1166N824AHMassachusetts State Police · Plymouth, MABuilt 2011 · S/N 1020N825MMMassachusetts State Police · Plymouth, MABuilt 2013 · S/N 1109N831MEAir Methods LLC · Greenwood Village, COBuilt 2006 · S/N 0493N845BPUS Department Of Homeland Security · Washington, DCBuilt 2001 · S/N 3464N845MECenter For Emergency Medicine Of Western Pa · West Mifflin, PABuilt 2009 · S/N 0845N846BPUS Department Of Homeland Security · Washington, DCBuilt 2002 · S/N 3542N855MECenter For Emergency Medicine Of Western Pa · West Mifflin, PABuilt 2015 · S/N 1205N856BPUS Department Of Homeland Security · Washington, DCBuilt 2002 · S/N 3617N863NCAir Methods LLC · Greenwood Village, COBuilt 2007 · S/N 0564N864NCAir Methods LLC · Greenwood Village, COBuilt 2007 · S/N 0567N865CHAir Methods LLC · Greenwood Village, COBuilt 2025 · S/N 2330N877CRAir Methods LLC · Greenwood Village, COBuilt 2007 · S/N 0625N884MELta Group Holdings LLC · Amarillo, TXBuilt 2010 · S/N 0884N891TTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1998 · S/N 0051N892TTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1998 · S/N 0052N89EMIntegra Aviation LLC · Amarillo, TXBuilt 1998 · S/N 0049N905VUVanderbilt University Medical Center · Nashville, TNBuilt 2011 · S/N 0994N906VUVanderbilt University Medical Center · Nashville, TNBuilt 2009 · S/N 0788N908ACAir Methods LLC · Greenwood Village, COBuilt 2005 · S/N 0412N908VUVanderbilt University Medical Center · Nashville, TNBuilt 2019 · S/N 2090N911AXGuardian Flight Holdings Inc · Fairbanks, AKBuilt 1997 · S/N 0021N911CBCollier County Emergency Medical Service · Naples, FLBuilt 2019 · S/N 2105N911RZAir Med Services LLC · Lafayette, LABuilt 2009 · S/N 0834N911UGAir Methods LLC · Greenwood Village, COBuilt 2005 · S/N 0416N911XAAir Med Services LLC · Lafayette, LABuilt 2000 · S/N 0132N911XBAir Med Services LLC · Lafayette, LABuilt 2000 · S/N 0154
Back to AD 2018-07-17