The general equation of a parabola with its focus at \( (h, k) \) is given by:
\[
(y - k)^2 = 4p(x - h)
\]
However, the equation of the parabola with focii at \( (-3, 1) \) and \( (3, 1) \) indicates that the vertex of the parabola is at the midpoint of the foci. The midpoint of the foci is \( (0, 1) \).
The equation of the parabola can thus be written as:
\[
y^2 = 4(x + 3)(x - 3)
\]
This equation satisfies the given conditions. Therefore, the correct equation of the parabola is (D).