Standard height for DDR4 DIMMs is
31.25mm (DDR3 is a bit lower at 30.35mm)
My Kingston HyperX DDR4 modules come with a small heatsink and measure 34.6mm in height.
After being mounted, Noctua D14 still has ~15mm of clearance over the HyperX modules in a LGA 1151 (Skylake) motherboard.
Conclusion?
The NH D14 is compatible with the majority of memory modules available on the market, with the sole exception of those using very big heatsinks that take their height over 45mm and close to 50mm. This means you can easily use something like Crucial Ballistix Elite (~40mm) or Kingston HyperX Predator (42.2mm) but you cannot use Corsair Dominator at 55mm in height.