Here's a list off the top off my head. I'm only addressing USDM Nissan nameplates, excluding the Infiniti badged cars, and Nissans outside the US, as they have variations of these motors US Nissan enthusiasts have never even heard of (like the VQ32DETT). I will also leave out the trucks and vans, even though the VG, VQ and KA series have been used in them. I'll also keep it within the 90's and above.
Nissan guys, correct me where I'm wrong.
GA Series
GA16DE: 1991-1994 Sentra GXE/XE/E (110HP), 1995-1998 Sentra base/GLE/GXE/XE (115HP), 1995-1998 200SX (115HP)
KA Series
KA24E: 1989-1990 240SX All models (140HP)
KA24DE: 1991-1998 240SX All models (155HP), 1992-2000 Altima (150HP)
QG Series
QG18DE: 1999+ Sentra XE/GXE (126HP)
SR Series (my favorite
)
SR20DE: 1991-1994 Sentra SE-R (140HP), 1995-1998 200SX SE-R (140HP), 1998-1999 Sentra SE (140HP), 2000-2001 Sentra SE (145HP)
VE Series
VE30DE: 1992-1994 Maxima SE (190HP)
VG Series
VG30DETT: 300ZXTT (320HP)
VG30DE: 300ZX (225HP)
VG30E: 1992-1994 Maxima GXE (160HP)
VQ Series
VQ25DE: 2002+ Sentra SE-R (165HP), 2002+ Sentra SE-R SpecV (175HP), 2003+ Sentra LE (165HP), 2001+ Altima 2.5
VQ30DE: 1995-1999 Maxima All models (190HP)
VQ30DE-K: 2000-2001 Maxima All models (222HP)
VQ35DE: 350Z All models (287HP), 2002 Maxima All models (255HP), 2003+ Maxima All models (265HP), 2001-2002 Altima 3.5 (240HP), 2003+ Altima 3.5 (245HP)