It works out to be the following:
Aggressors – CS1 Mighty Mach One, CS2 Delta Tau Deuce, CS3 Dogs of War, CS4 Fighting Fourth, CS5 Wolfpack
Barbarians – CS6 Raging Bull Six, CS7 Shadow Seven, CS8 Eagle Eight, CS9 Viking Nine, CS10 Tiger Ten
Cobras – CS11 Reb Eleven, CS12 Dirty Dozen, CS13 Bulldawgs, CS14 Cobras, CS15 War Eagles
Demons – CS16 Proud Chicken Hawks, CS17 Stalag 17, CS18 Nightriders, CS19 Wolverines, CS20 Trolls
Executioners – CS21 Blackjacks, CS22 Raptors, CS23 Barnstormers, CS24 Phantoms, CS25 Rock Hard Redeye
Flying Tigers – CS26 Barons, CS27 Thunderbirds, CS28 Blackbirds, CS29 Black Panthers, CS30 Knights
Guts – CS31 Grim Reapers, CS32 Roadrunners, CS33 Ratz, CS34 Loose Hawgs, CS35 Huge Wild Weasels
The way I understand it they will find out what flight they're are in when they inprocess. So if you child is in Cobras Bravo Flight their academic squad will be Dirty Dozen.