Here is the fragment again:
One day Andrew aspires to eat asparagus.

You correctly identified the word group as a main clause. You have a subject, Andrew, and a verb, aspires. Because a complete thought is expressed, you do not have a fragment!

Enjoy the king's company!

Go to the next fragment.