I'd be aware of the flight patterns and traffic, but unless you are within the runway path by a couple miles, planes are largely not an issue. There are certainly places I wouldn't live though as the panes are almost literally overhead and LOUD.
This might help -
RDU GIS Flight Path Help
- I would say anything outside the yellow area pretty much equals "you'd never know there were any planes".
- The lightest yellow would = the occasional plane you'd notice. OP, you won't have to worry about plane noise imo.
- The next darkest yellow and further in - you'll notice planes regularly.
All this said - I think the area of N Raleigh you are looking at is great - wooded and low density yet close to everything.