The 303, or the duster may solve the symptom , but not the cause. I had a Honda Pilot for three years, didn't have this issue

 

For the people who solved their problem with finding the maple tree leaves. Was the sound coming from the dash or the pillar on the windshield? My noise like some others on the post stated that the sound comes from the pillar. It first I thought it was the trim on the outside loose, but not. Still looking for a solution. I really like my 2007 but it is getting older with little issues. I do appreciate everyone's ideas. Thank you