Last I saw, the Intel cards – even if they did work -- do not work in hostap mode, so they could not be used to setup a pfSense access point. They could only be used for wireless WAN.
It looks like the iwn driver would support the 4965AGN, and if that isn't already in pfSense 2.0 it could probably be included in the kernel config (it may not have been updated to include that driver). However, as I said in the previous paragraph, the iwn(4) man page for the driver indicates that it doesn't support hostap mode, only station, adhoc, and monitor modes.
The challenge isn't just finding an N card that works with FreeBSD, but also an N card which has a driver that supports hostap mode with N.