It could be possible if the Catapult or Airplane themselves weren't the weapons. You could mod them to be carriers. Then make a new unit to be the nuclear ammunition, load them into the 'carrier', and deploy them to the target.
Of course, I suppose normal airplanes in CivIII wouldn't work, because of how limited their movement is. You'd have to create them as ground units, which complicates things.