It's not exactly the busiest holiday travel period, but there are some Saint Patrick's day-themed airfare specials / travel packages on offer. From green beer to being Irish for the day, some of the different Irish-loving destinations.
Cheapflights has several suggested itineraries including Ireland and Toronto, Canada. It is obvious and important to start with where St. Patrick's Day began, and Cheapflights looks at Dublin as a destination for St. Patrick's Day. The flights from Houston to Dublin from $636 between March 17 - 23.
North America's tallest tower at 553 meters (605 yards) is the CN Tower and will have a green glow for St. Patrick's Day. Toronto also hosts one of the biggest St. Patrick's Day parades in the world. Cheapflights quotes flights from Los Angeles to Toronto available from $409 for March 17 - 21.
CheapOair also has several travel suggestions for St. Patrick's Day including Boston, known for its deep Irish roots. CheapOair cites Boston flights from March 15 to March 22, 2010 starting at $132 roundtrip - enjoy the parade, walk the Irish Heritage Trail, and visit some of Boston's many Irish pubs.

Thanks for the tips. I found a great deal on airfare and took my wife to New Orleans for St Patrick’s Day.