We demonstrate a photon-counting optical time-domain reflectometry with 42.19 dB dynamic range using an ultra-low noise up-conversion single photon detector. By employing the long-wave pump technique and a volume Bragg grating, we achieve a noise equivalent power of -139.7 dBm/√Hz for our detector. We perform the OTDR experiments using a fiber of length approximate 217 km, and show that our system can identify defects along the entire fiber length in a measurement time of 13 minutes.