Previous studies investigated on friction reduction at the solid–liquid interface due to the presence of metal nanoparticles and fine bubbles such as microbubbles. This paper experimentally investigated how nanobubbles (ultrafine bubbles) change the tribological nature of water flow at the solid–liquid interface. We flowed air nanobubbles-containing water into a cylindrical cell filled with soda-lime glass, alumina, and high-carbon chromium-bearing steel beads. We then estimated the changes in the ratio of Darcy's friction factor of nanobubbles-containing water flow (fnb) to that of water flow before injecting nanobubbles (fref) with the time of injecting nanobubbles. We found that nanobubbles are capable of reducing the friction in water flow running through the soda glass beads, accounting for up to 6.1% reduction in terms of Darcy's friction factor ratio (fnb/fref) in our experiment. The magnitude of friction reduction by nanobubbles can be greater with a larger total surface area where surface nanobubbles are present. In contrast, nanobubbles encouraged enhancement of the friction of water flow within the high-carbon chromium-bearing steel beads, showing 3.8% enhancement in the friction factor ratio (fnb/fref). The results indicate that nanobubbles play a role in the friction reduction of water flow when the surface of the bead material is rougher than the size of nanobubbles, while nanobubbles enhance the friction of water flow when the bead surface is smooth enough. Therefore, nanobubbles can be a green nanoscopic additive for modifying the friction and lubrication performance of water flow depending on the surface roughness of the flow material.