Not an apex domain
The domain c-174-54-166-129.hsd1.pa.comcast.net is not the root of its zone.
Instead, try zone transfer on hsd1.pa.comcast.net .
Instead, try zone transfer on hsd1.pa.comcast.net .