The 1995 Aurora came with a 3.8L V6 engine, which was not a Northstar engine.
The Northstar V8 engine was introduced in 1993 and was first used in the 1994 Cadillac Seville. It then became available in the 1996 Cadillac Aurora.
So, while the Aurora was a Cadillac model and the Northstar engine was used in other Cadillac models, the 1995 Aurora did not have the Northstar engine.