Being in love with both fireworks and flying this is a question that I wondered about for quite some time.
Especially when watching videos like this (which is from 2009 showing a stunt plane flying stunts during night with sparklers on the wings and some single shots) or this (a glider with essentially the same effects like the stunt plane from 2015) I wonder what safety regulations apply.
Most certainly I am not allowed to duct tape some rockets to my wing and light them off remotely mid flight but I haven't heard about a firework rating or something similar either.
What requirements do I have to accomplish to be allowed to fly with pyrotechnics (mainly fireworks) on my plane? This would include anything additional directly in my PPL, permission by local authorities, special safety measures on the plane, etc.
This question is mainly regarding the european room (namely Germany) but I am also looking forward towards answers about regulations from other regions.