Does anyone know please where I can get one of these as in the photo - I need the bottom bracket that screws into the door - it was glued when I bought it and keeps popping up (I’ll clean the glue off first)

 

Try here:

https://www.courtesyparts.com/v-2006...and-components

 

good shout but discontinued … I may have to try someone who is breaking a 350z ?

 

Hmm, OK, not sure where you are (non USA?) but you can check these guys. They ship, s'far as I know but maybe not internationally. They're on Recycle Road (along with all the other marque dismantlers) in Rancho Cordova, CA.

https://ranchonissan.com/

https://www.saccityautoparts.com/

You might have to see if there's local to you places. Good luck.

 

Disadvantages of an older car

 

If it's the molding on the outside of the door glass, try Z1a little pricey but oem part. BTW that's where I got mine for my 07.
Hope this helps.