There was a thread here recently about putting the air springs on over the coils. It's probably right down on the first page or so if you scroll down.

The pano roof you can try initializing it just by holding the button, and use the manual crank, but the tracks are probably all dirty and jammed up with leaves etc. So you'll probably break some of the plastic parts in the track if you force it to move. You're probably going to have to drop it out and buy the repair kits. It's not as bad as you'd think.

__________________
'05 E53 3.0 6mt
'17 F30 340ix 6mt
'96 E36 328is, in progress