Moderators: jsumali2, richierich, ua900, PanAm_DC10, hOMSaR

 
User avatar
YVRbud
Topic Author
Posts: 8
Joined: Fri Mar 09, 2018 7:38 am

U.S. DOT Air Traffic Dashboard - Customizable for your own airport!

Sun Apr 26, 2020 5:09 am

Given the recent increase in my free time, I have put together an interactive visualization of the latest U.S. DOT T-100 data. This dataset contains capacity and traffic information from every airline that operates to, from or within the United States. Hopefully this will help provide some easily accessible background data for many of the discussions on the site.

There are two dashboards:
- Domestic traffic within the U.S.: https://public.tableau.com/shared/T4HP6NNWT?:display_count=n&:origin=viz_share_link (latest data Jan 2020)
- International traffic to/from the U.S.: https://public.tableau.com/views/T-100InternationalSegmentDashboard/SegmentView?:display_count=y&:origin=viz_share_link (latest data Oct 2019)

I suggest viewing the dashboards in full screen. To filter the data, simply select the month, airline and origin airport from the scroll-down options at the top.

A few comments:
- If you see flights that are unusual and have minimal capacity, they are likely diversions or charter-related.
- You also might see some data appearing under operating carriers instead of marketing carriers. This is due to how the DOT shares the data, and should cause minimal disruption.

Let me know if this is useful and I can keep updating it periodically as new data becomes available! This should also be helpful when DOT starts sharing data that covers COVID-related declines in traffic!
733 734 736 737 738 739 744 752 753 763 772 77E 77L 77W 788 789 E75 E90 CR2 CR7 319 320 321 332 333 343 346 388
 
User avatar
BA744PHX
Posts: 380
Joined: Mon Sep 24, 2007 3:42 am

Re: U.S. DOT Air Traffic Dashboard - Customizable for your own airport!

Sun Apr 26, 2020 2:12 pm

Thanks for the link and putting together, may I make a suggestion? When selecting origin airport (JFK) but no destination, its showing a summary of every airline data for the month. Are you able to show all routes data instead of airline?

I tried filtering JFK, by AA and only shows a summary rather then each route for the month
 
User avatar
YVRbud
Topic Author
Posts: 8
Joined: Fri Mar 09, 2018 7:38 am

Re: U.S. DOT Air Traffic Dashboard - Customizable for your own airport!

Sun Apr 26, 2020 3:15 pm

BA744PHX wrote:
Thanks for the link and putting together, may I make a suggestion? When selecting origin airport (JFK) but no destination, its showing a summary of every airline data for the month. Are you able to show all routes data instead of airline?

I tried filtering JFK, by AA and only shows a summary rather then each route for the month


Good idea! I'll see if I can add that for the next round of updates.
733 734 736 737 738 739 744 752 753 763 772 77E 77L 77W 788 789 E75 E90 CR2 CR7 319 320 321 332 333 343 346 388
 
MIflyer12
Posts: 8265
Joined: Mon Feb 18, 2013 11:58 pm

Re: U.S. DOT Air Traffic Dashboard - Customizable for your own airport!

Sun Apr 26, 2020 6:17 pm

Thanks for your work. This is a great presentation of the data.

If you would, please, take a moment to explain the City search feature. Looking at Origin Airport PHX and Destination City Chicago I get ... nothing. I was hoping to be able to use the City capability to look at WAS/NYC/CHI, or maybe even to aggregate the SoCal area airports BUR/LAX/SNA/ONT/LGB. Possible?
 
KD5MDK
Posts: 832
Joined: Wed Mar 13, 2013 4:05 am

Re: U.S. DOT Air Traffic Dashboard - Customizable for your own airport!

Sun Apr 26, 2020 8:32 pm

This is excellent. Tableau is an amazing tool and it's so cool to see people using it in ways like this.
 
User avatar
YVRbud
Topic Author
Posts: 8
Joined: Fri Mar 09, 2018 7:38 am

Re: U.S. DOT Air Traffic Dashboard - Customizable for your own airport!

Sun Apr 26, 2020 8:46 pm

MIflyer12 wrote:
Thanks for your work. This is a great presentation of the data.

If you would, please, take a moment to explain the City search feature. Looking at Origin Airport PHX and Destination City Chicago I get ... nothing. I was hoping to be able to use the City capability to look at WAS/NYC/CHI, or maybe even to aggregate the SoCal area airports BUR/LAX/SNA/ONT/LGB. Possible?


Good catch! The source I was using has unique cities listed for each airport - not very useful for what we're trying to do.

I have fixed some of the larger U.S. examples. If you come across any more, you can always use the filter at the top to look at them one by one.
733 734 736 737 738 739 744 752 753 763 772 77E 77L 77W 788 789 E75 E90 CR2 CR7 319 320 321 332 333 343 346 388
 
MIflyer12
Posts: 8265
Joined: Mon Feb 18, 2013 11:58 pm

Re: U.S. DOT Air Traffic Dashboard - Customizable for your own airport!

Sun Apr 26, 2020 11:17 pm

Thanks for the quick response and quick fix. I tested PHX-CHI/WAS/NYC and found all working. Really, outstanding work. I know some of the data geeks (respect!) have been willing to manipulate T-100s in worksheets but this is so much easier.
 
bnatraveler
Posts: 389
Joined: Tue Dec 02, 2003 10:10 am

Re: U.S. DOT Air Traffic Dashboard - Customizable for your own airport!

Sun Apr 26, 2020 11:55 pm

Any chance you might be able to identify non-stop versus connection traffic?
 
User avatar
YVRbud
Topic Author
Posts: 8
Joined: Fri Mar 09, 2018 7:38 am

Re: U.S. DOT Air Traffic Dashboard - Customizable for your own airport!

Mon Apr 27, 2020 1:29 am

bnatraveler wrote:
Any chance you might be able to identify non-stop versus connection traffic?


All of the traffic included is on a segment basis. DOT does share market data as well, which would show O&D markets (non-stop, connecting) as you're looking for.
A future project perhaps!
733 734 736 737 738 739 744 752 753 763 772 77E 77L 77W 788 789 E75 E90 CR2 CR7 319 320 321 332 333 343 346 388
 
miegapele
Posts: 52
Joined: Wed Sep 09, 2015 12:24 pm

Re: U.S. DOT Air Traffic Dashboard - Customizable for your own airport!

Mon Apr 27, 2020 6:10 am

Thank you, Very interesting data. Also there seems to be quite a few airports included in selection but they have no data, for example TLL, TFS, TFN, LPA
 
User avatar
YVRbud
Topic Author
Posts: 8
Joined: Fri Mar 09, 2018 7:38 am

Re: U.S. DOT Air Traffic Dashboard - Customizable for your own airport!

Mon Apr 27, 2020 3:37 pm

miegapele wrote:
Thank you, Very interesting data. Also there seems to be quite a few airports included in selection but they have no data, for example TLL, TFS, TFN, LPA


You would have to check if these airports have non-stop service to the US. Some of them might have had cargo/GA activity which was also removed.
733 734 736 737 738 739 744 752 753 763 772 77E 77L 77W 788 789 E75 E90 CR2 CR7 319 320 321 332 333 343 346 388

Popular Searches On Airliners.net

Top Photos of Last:   24 Hours  •  48 Hours  •  7 Days  •  30 Days  •  180 Days  •  365 Days  •  All Time

Military Aircraft Every type from fighters to helicopters from air forces around the globe

Classic Airliners Props and jets from the good old days

Flight Decks Views from inside the cockpit

Aircraft Cabins Passenger cabin shots showing seat arrangements as well as cargo aircraft interior

Cargo Aircraft Pictures of great freighter aircraft

Government Aircraft Aircraft flying government officials

Helicopters Our large helicopter section. Both military and civil versions

Blimps / Airships Everything from the Goodyear blimp to the Zeppelin

Night Photos Beautiful shots taken while the sun is below the horizon

Accidents Accident, incident and crash related photos

Air to Air Photos taken by airborne photographers of airborne aircraft

Special Paint Schemes Aircraft painted in beautiful and original liveries

Airport Overviews Airport overviews from the air or ground

Tails and Winglets Tail and Winglet closeups with beautiful airline logos