I am currently an Air Force Pilot I have been in for 9 years. In 2002 pleaded guilty to a DWI in a civil court. As far as the Air Force goes I was never charged under the UCMJ, Article 15 ect. Since then I have not had a single infraction, not even a speeding ticket.

Does the length of time matter since I haven't had any other tickets ect.?
How much of an impact does this have for air carriers in the civilian industry?