Airlines use up to four digits for flight numbers. That means they can have up to 9,999 flights (since there’s no flight zero), and no one comes close. American Airlines operates around 6,700 daily flights including its American Eagle regional services. So they should have plenty of room to grow! Except they don’t. American Airlines, Delta, and United are running out of flight numbers, and nobody knows what to do about it.
Can’t they just make flight numbers a 5 digit number? Lol
You mean change a 60 year old database schema? Absurd!
How many tables could they need to update anyways? Like 5? Psh