I was able to locate it. it's actually coming from the front right passenger, between the roof window and the body of the car.
Imgur
I'm not able to reproduce it when poking around the trims. Hence, it must be something behind the trim rattling. Could even be the window touching the body...