I don't know the burst pressure of a typical brand new passenger vehicle tire, which I think, they test using water (for safety reasons), but I would think it's unattainable by "normal" air compressors (at home anyway, and perhaps at gas stations too).
Is it? o Dunno.
Looking it up... first hit... o Is it possible to burst a tire from too much air pressure?
They go on to say under inflation is the real risk of burst tires, but let's look for corroboration on the 200 psi ballpark figure... o What Causes Tire Blowout?
Give the tire pressure is usually around 40PSI for a passenger vehicle, and that the maximum is usually something like 60PSI, it seems that the "burst pressure" of a new tire is 200PSI, which is basically unattainable at a "standard" air compressor pump (at least the ones that I use).
Of course, I'm well aware that heat will destroy a tire in no time, e.g., running underinflated, or flat, and that age and wear and damage change the dynamic, so all this is for a brand new tire, and not for a worn or overloaded tire.