Can be used both literally and figuratively.
Mi vecina es una petarda que siempre llama la atención con su risa estruendosa.
My neighbor is a loud person who always draws attention with her booming laughter.
Aquella mujer era una auténtica petarda, siempre hablando a voces.
That woman was a true loud person, always talking loudly.