Earth 2 - Pre-Crisis: Kal-L's rocket was indestructible as were all things Kryptonian. Even Kryptonian cloth could not be destroyed by Earth-based technology or weapons. Rocket was buried underneath the barn at the Kent farm in Smallville.
Earth 1 - Pre-Crisis: Kal-El's rocket was indestructible as were all things Kryptonian. Originally held at the Kent Farm, he later moved it to the Fortress of Solitude and put on display there.
Earth - Post Crisis: Kryptonian technology was durable but not indestructible, rocket damaged during explosion of Krypton and upon re-entry. Rocket held at Kent farm, hidden from sight, likely in the same barn as in the earlier continuities.
Wikipedia reference for Superman:
While the pre-Crisis Superman's costume was invulnerable (as a result of being made from the blankets in the rocket that brought him to Earth), the post-Crisis Superman's costume was made of ordinary material. But while the cape often became ripped and torn (or even completely destroyed on occasion) for dramatic effect, the rest of the costume was usually left untouched. It was later explained that the post-Crisis Superman's body generated an invisible "aura" that surrounded him and contributed to his invulnerability. Objects held close to him, such as his costume, were protected from harm; his cape, meanwhile, could easily sustain damage in battle.
New Earth - DCnU: Though he was still found by the Kents, they are already dead by the time he reaches adulthood. It is unknown where they put the rocket he was found in, while he was growing up. Likely the same barn as in the previous continuities. It is hinted in one of the most recent Superman appearances with the Legion of Superheroes, that he keeps his rocket in one of his Fortresses of Solitude (in space). There are other hints that the ship in his Fortress may be missing its engine which was powered by Kryptonite and being used to grow new colored Kryptonite crystals/isotopes.