Hand 1
1.1 AA - 6 hand combinations (28.6%)
1.2 KK - 1 hand combination (4.8%)
1.3 QQ - 6 hand combinations (28.6%)
1.4 AKs - 2 hand combinations (9.5%)
1.5 AKo - 6 hand combinations (28.6%)
Total of 21 hand combinations

Hand 2
How often does he have
2.1 two pair - 9 hand combinations (42.9%)
2.2 a higher set - 6 hand combinations (28.6%)
2.3 a gutshot - 6 hand combinations (28.6%)
Total of 21 hand combinations

Hand 3
3.1 How many hands are in his range?
70 hand combinations
Sets: 33, 99 (6 hand combinations)
Paired kings: KQs (2 hand combinations)
Paired nines: T9s (3 hand combinations - of which one is a diamond flush draw)
Pocket pairs: 22, 44-88, TT (7 * 6 = 42 hand combinations)
Suited aces: ATs-AQs (3 * 3 = 9 hand combinations - no flush draws as we have the ace of diamonds)
Other suited cards: QJs, JTs (2 * 4 = 8 hand combinations - two diamond flush draws)
3.2 What % of his range are we ahead on flop?
Behind sets (6 hand combinations 8.6% - 5.4% equity)
Ahead of pairs (46 hand combinations excluding the one that is also a flush draw with 90.8% equity)
Ahead of unpaired, suited cards (15 hand combinations excluding the ones that are flush draws with 90.5% equity)
Ahead of flush draws (3 hand combinations with 56.8% equity)
Total ahead of 64 hand combinations (91.4%) with 89.1% equity.
3.3 Villain raises the flop to 20bbs, what should we do if we know he would only raise FD's and sets?
Fold - there are 6 hand combinations against which we have 5.4% equity and 3 hand combinations against which we have 56.8% equity. Against this total range our equity is 28.1%
Interestingly the ATs-AQs part of the range could have given him 3 more flush draws in his range if we didn't have the ace of diamonds - with the ace of spades he has 3 more hand combinations as draws with a total equity of the range at 33%. Funnily, this is not enough of a change really - flush draws have really solid equity against our hand on the flop and doubling up the flush draws in his range is still unprofitable for us to continue - we still fold.
This is especially exacerbated by us being out of position in the hand - we can either get eaten by a better hand (a set) or by reverse implied odds.