Below is a summary of Airport Express / Airport Extreme / Time Capsule compatibility and PeakHour:

DeviceCompatible

Detectable via SNMP Scan

Airport Extreme / Time Capsule 
Airport Extreme / Time Capsule 1st-5th Generation (2007-2012)YesYes
Airport Extreme / Time Capsule 6th Generation (2012+)NoNo
Airport Express 
Airport Express 1st Generation (2004-2008)NoNo
Airport Express 2nd Generation (2008-2012)YesYes
Airport Express 3rd Generation (2012+)YesYes

A note about the Apple AirPort Extreme / Time Capsule 2013+

As of the this writing, Apple have removed all support for SNMP in their latest hardware, making them impossible to monitor (with any software). There is further discussion about the issue on Apple's support forum: Apple Support Discussion - SNMP and 2013 Airport/Time Capsule.

If you have one of these routers, you can still use PeakHour to monitor this Mac, other Macs PCs, servers and other SNMP-compatible devices on your network. PeakHour 4 now supports Connection Quality monitoring, which lets you monitor the responsiveness of your connection. See this page for more information.