2006 Honda Pilot Check Engine Light

We have a 2009 Honda Pilot and same thing. The check engine light stays off for about a week and a half. All maintenance has been done, and the dealership apologetically tells us they can’t fix it. Who has time to take a car in for maintenance once a month? Extremely frustrated with this lemon.