Show HN: I'm an airline pilot – I built interactive graphs/globes of my flights

159 jamesharding 28 6/27/2025, 1:06:54 PM jameshard.ing ↗
Hey HN!

Pilots everywhere are required to keep a logbook of all their flying hours, aircraft, airports, and so on. Since I track everything digitally (some people still just use paper logbooks!), I put together some data visualizations and a few 3D globes to show my flying history.

This globe is probably my favourite so far: https://jameshard.ing/pilot/globes/all

If you’ve got ideas for other graphs or ways to show this kind of data, I’d love to hear them!

Comments (28)

ok_computer · 24m ago
Cool visualization for your personal logbook. How is the raw or display data stored?

The globe map reminds me of this hexagonal grid article from my bookmarks I’d found on here or reddit.

https://www.redblobgames.com/grids/hexagons/

As an airline pilot, I am curious, have you watched the season 2 of Nathan Fielder’s Rehearsal on HBO, that comically addresses the topic of pilot-copilot communication?

If so what are your thoughts on his portrayal of the existence of copilot communication friction. And without intending to dig into your personal business, do you think there is a tendency and survivor (retention) bias for the profession to remain high functioning ______, without recognizing a need for help. Or is this portrayal of stunted coworker dialog an edge case that is amplified from his perspective.

collinvandyck76 · 2m ago
This is inspiring me to collect more of my own data -- great job!
jasonthorsness · 11m ago
I love the sequential globe especially!

For an idea - anything you could do with altitude? Your average height above sea level per day? I dunno :p

alabhyajindal · 46m ago
Very cool! I didn't know pilots are required to maintain a logbook. What's the official recommendation for this - using a paper logbook?
jamesharding · 42m ago
Each country has slightly different requirements! For the US, here is the FAA rule for it: https://www.ecfr.gov/current/title-14/chapter-I/subchapter-D...

A lot of people still use paper (and fill it in after landing each flight), but there are quite a few digital options on the market now. I use one called LogTen, which stores everything in a SQLite file behind the scenes which is what I used to make this.

sokoloff · 30m ago
You are only required to log time required for 61.51.a.1 or .a.2, but are not required to log “all [your] flying hours” by the FAA. (Your airline might require it and it’s a good idea to log all your flights, but it’s not a law.)
butlike · 12m ago
Those few days that show back-to-back 14hr days must have been an experience :)

What's your favorite thing to see up in the sky and in the clouds?

andreygrehov · 27m ago
This is great work! I have a somewhat off-topic question. How are your ears? Do pilots have any tricks to save their ears from getting clogged due to the constant pressure changes?

Second question. Would it be possible to predict flight delays based on the number of inbound and outbound flights?

jamesharding · 15m ago
Thank you :) I haven't had issue with my ears (other than the occasional lingering cold), but usually a good yawn or chewing gum will clear it. On a normal day, I am fortunate to have wide eustacian tubes I guess!
Chico75 · 23m ago
I'm curious to know what is the small concentrated cluster of flights Northwest of Dulles airport, where the flight durations seem way too high compared to the effective distance between the points.
jamesharding · 10m ago
Those are all of my flights in light aircraft around my hometown in Canada! They fly a little bit slower than the A350 :) There is a similar cluster around the south of Spain where I completed my Commercial/ATPL training.
arccy · 41m ago
I wonder if you can spread out the airport labels a bit when they're clustered together, like the cluster around CYOO in the US.
jamesharding · 34m ago
Good idea! Not sure exactly how to do this with globe.gl but I will look into it.
nelblu · 25m ago
Love it :-). Do you also need to log the gps co-ordinates as you are flying? I would love to see how you avoid the airspace in the war hit areas.
AJRF · 24m ago
Hell yeah. This is very cool, happy flying!
jonlucc · 44m ago
This is great data visualization of interesting data! I'm curious about the last graph; there seems to be something making some of the longest flights take more time/nm. Is that real or an artifact, and is there an explanation for the tail?
jamesharding · 37m ago
Great question! It is not an anomaly, it is very geographically specific.

Due the the Ukraine war (and my home base being in the UK), we have to fly the long way around to get to far-east destinations like Tokyo and Hong Kong. Flying outbound from London we have to fly down over Turkey (which adds about two hours of flight time).

Flying home from Tokyo with the ongoing airspace closure, if the the weather is suitable at the ETOPS airports enroute, it is actually quicker to fly home eastbound again, flying up over Alaska. A proper around-the-world in 4 days!

iamspoilt · 33m ago
Having a computer engineering background, what motivated you to become a pilot and switch careers?
jamesharding · 27m ago
I had always been interested in aviation, and I was fortunate that I was in the right place at the right time after graduation to join an airline on a sponsored "cadet scheme".

I still (hopefully evidently) very much love software/engineering, but I guess I chose the path of "professional pilot, hobbyist engineer" over the alternative of "professional engineer, hobbyist pilot".

joshvm · 10m ago
I'm surprised how wide the acceptance age range is for BA's program (18-55). Is it common for people to transfer from unrelated careers? Nice to know that door isn't technically shut for a while!
iamspoilt · 30m ago
Looking at your projects, seems like you still have the hacker going in you! Saw Home Assistant one! Kudos!
imp0cat · 36m ago
The logbook is nice, but the split-flap display is downright awesome. ;)

https://jameshard.ing/projects/split-flap

uptownJimmy · 27m ago
Maaaaan, this is so cool. I'm geekin'.
mkoubaa · 21m ago
Are you allowed to code while sitting in the cockpit but not actively flying?
jamesharding · 5m ago
On the long flights where we carry more than two pilots, we have allocated break time away from the cockpit. During those breaks, you can do whatever you like (sleep, watch a film, read a book, etc). I tend to try to sleep on the plane, but I always bring my laptop on trips to work on projects while downroute. Especially on west-coast trips with the 8 hours timezone change, I am usually awake at 2am which is great for being productive!
jcsnv · 17m ago
this is so cool!
baroquetaxers0s · 21m ago
this is cool