Yes but there are plenty of cases where police departments aren't even bothering to get the service address from the ISP. Look at the case of the farm in Kansas or the house in Atlanta, The police don't have some independent source testifying that that IP address was in use by a customer at that service address, they're literally just using a geolocation service and raiding wherever the marker lands on the map.
This is the one thing that irks me the most, I don't expect law enforcement to understand the technical side of things but this is just a complete failure to do good old fashioned police work. If a judge was asked to sign a search warrant predicated around the results of a homemade drug test tutorial on Wikihow there's no chance that they would ever consider granting it yet when the same thing is asked in regards to an IP address somehow that passes muster.
At a minimum, police should be required to contact the IANA to figure out which AS an IP belongs to and then contact the AS to figure out what the service address is for the customer. Academia is built around citing any kind of source information, why is that too much to ask for from law enforcement?
Ideally, law enforcement would contact IANA to get the AS, look and verify that that AS was the only one advertising that IP block at the time in question, get the serial number of the modem in question from the AS if the subscriber is using a DOCSIS modem, go to the service address and confirm that the modem is actually present at the service address by doing a disconnect at the road, and then execute the warrant. I get that most of this is pie in the sky wishful thinking, but omitting any of those steps could result in raiding an innocent person needlessly and a lot of those steps could be executed concurrently. Heck, you could also throw in looking for signs that the IP address in question is being used as a Tor node or any other simple proxy and sniffing wireless traffic and trying to correlate the timing of wireless frames to the traffic from the modem in question. You could even do the wireless sniffing at the same time you go out to verify where a modem is on the node.
Even though this would be extra work for law enforcement, wouldn't it be worth it many times over if it just saves a small proportion of innocent citizens from a dangerous police raid?