What was the disposition of the DUI? That can make a difference.
It is clear you were arrested for a DUI, as you have to be if pulled over for suspected DUI. It is not clear what the disposition of your case is.
Were you maybe given a Deferred Judgement since it's your 1st offense? In Massachusetts you could get a CWOF (Continued Without a Finding) for example if it's your first offense ever. Or in Georgia you may get FIRST-OFFENDER, which means the same as CWOF.
Those all mean there is no conviction or finding of guilt upon you by the court, but they are not going to ever allow you to expunge it from your record. They do not allow you to expunge in these findings since if it happens again you will get a real harsh sentence. So it's kind of like a get out of jail free card, even though by the time you add up all the legal costs of your attorney it's definitely not exactly getting out of jail free. But it keeps you from ever having to say you been convicted of a DUI or what ever charge you been arrested for.
Of course, all this is up to the prosecutor if you should have this option. I have some friends who were offered these options, and others who were not for DUI's and other crimes where they ended up being arrested for one reason or another. It all seems to depend on all the circumstances, if the prosecutor is having a good day, if the judge approves, and if your attorney is able to make this all happen for you in order to keep you from being convicted of a crime/ DUI.
Oh, of course with these dispositions, the arrest will still show up on an FBI background check. So while you get to write you never been convicted of a crime, you'll still have some explaining to do when your record comes back and they see you been arrested for a DUI but the case was disposed off without a conviction. Not nearly as bad as being convicted, yet still not as good as it never happening to begin with.
Now if you ended up being convicted of the DUI, I still would not allow it to stop you from pursuing your dreams. Just know that it is going to raise questions and that it may limit you on working for some places. But if you learned from the mistake and have an overall history of good judgement, I would not worry too much about it since you can still have an aviation career and be a success in the future.