Preliminary notes
First of all it makes no sense to install versions of Ubuntu that are no longer supported with updates. That is for the reasons at the bottom of this answer.
This answer will concentrate on currently supported versions of Ubuntu and its official derivates.
If your hardware nerver connects to the internet and if you will never use software newer than is included on the respective install media, only then it might be prudent to use outdated versions.
You don't have to install Ubuntu to see if it works on your hardware. It is always a good idea to boot from LiveDVD/USB and see if the system runs okay on the given hardware.
Even if it seems not to work, you might be just one boot option away from a working system. See My computer boots to a black screen, what options do I have to fix it? For example the nomodset option might help.
Currently supported versions and their minimal requirements
The community wiki usually offers an up to date list of currently supported versions. Minimal system requirements for Ubuntu can be found there in the tech sepcs. Information on the derivates is scarce but their requirements are less than what is listed here. Generally 32 Bit versions take up less memory and tend to be faster on older systems, than their 64 Bit counterparts. The Lists of Ubuntu certified hardware might also be of use to you.
Supported versions of Ubuntu
10.04 Server (Lucid Lynx)
The minimum memory requirement for Ubuntu 10.04 LTS is 256 MB of memory.
via Ubuntu Wiki
12.04 Server and Desktop LTS (Precise Pangolin)
700 MHz processor (Intel Celeron or better) - 300 Mhz for Server
384 MB - 128 for Server. Note that some of your system's memory may be unavailable due to being used by the graphics card.
5 GB of hard-drive space (1 GB for Server)
VGA capable of 1024x768 screen resolution for Desktop version
12.10 Server and Desktop (Quantal Quetzal)
768 MB of memory and 5 GB of disk space for Ubuntu Desktop [...]. I If your computer has only the minimum amount of memory, the installation process will take longer than normal or even appear frozen for some time.
13.04 Server and Desktop (Raring Ringtail)
Supported versions of Lubuntu
11.10 (Oneiric Ocelot)
12.10 (Quantal Quetzal)
A Pentium II or Celeron system with 128 MB of RAM is probably a bottom-line configuration that may yield slow yet usable system with a standard lubuntu desktop.
12.10 32 bit ISO require your CPU to have Physical Address Extensions, or PAE. "PAE is provided by Intel Pentium Pro and above CPUs, including all later Pentium-series processors (except most 400 MHz-bus versions of the Pentium M)."
For PowerPC, it is known to run on a G4 running at 867MHz with 640MB RAM.
For Intel based Macs, Lubuntu should run on all models.
via Ubuntu Wiki
13.04 (Raring Ringtail)
A Pentium II or Celeron system with 128 MB of RAM is probably a bottom-line configuration that may yield slow yet usable system with a standard lubuntu desktop.
13.04 32 bit ISO require your CPU to have Physical Address Extensions, or PAE. "PAE is provided by Intel Pentium Pro and above CPUs, including all later Pentium-series processors (except several versions of the Pentium M, see here)." - If you have a NON-PAE CPU you can use 12.04 instead.
For PowerPC, it is known to run on a G4 running at 867MHz with 640MB RAM.
For Intel based Macs, lubuntu should run on all models.
via Ubuntu Wiki
Supported versions of Xubuntu
See Xubuntu help page.
10.04 LTS (Lucid Lynx)
12.04
Minimum system requirements for Xubuntu fall roughly between Ubuntu Server and Desktop: 512 MiB of system memory (RAM), 5 GB of disk space, Graphics card and monitor capable of 800x600 resolution
via Ubuntu Wiki
12.10
13.04
Why you shouldn't use versions when their support has ended
- Security risks: Eventually there will be an exploit that compromises security or system integrity of old Ubuntu versions
- Software incompatibilies: Versions that are no longer supported will have increasing problems with this. Due to the lack of updates one will no longer be able to open the most recent LibreOffice documents or compile programs that need more recent libraries. Hardware drivers of recent devices will not be included in older kernels.
- Decreasing availability of repositories: It might become very difficult to download software that does not allready ship with the outdated version. Hosting repositories for very old versions cease to be economically viable at one point.