Do I need a modem with the airport extreme?

Yes you do. The modem connects with the incoming signal from your provider and the router (AP Extreme) routes the signal wirelessly to your devices. The router is the connector between the modem and your devices.