Technology1 min read

The day the sky emptied: rendering the FAA outage with ClickHouse FORMAT PNG

By · Published by Everything Blog

In short

Normal air travel operations peaked near 15,000 aircraft per hour early in the afternoon before flight positions dropped precipitously after 15:40 ET. At the event's nadir around 20:00 ET, high-altitude aircraft above 18,000 feet fell to just 559, a volume even lower than normal overnight minimums. The severe disruption and subsequent gradual recovery were rendered directly out of ClickHouse using SQL queries and ADS-B tracking records.

Key points

  • The outage severely disrupted domestic aviation, cutting peak high-altitude airspace volu…: The outage severely disrupted domestic aviation, cutting peak high-altitude airspace volume to less than one-tenth of normal afternoon operations.
  • Air traffic began a measurable rebound after 21:00 ET, climbing past 1,900 high-altitude…: Air traffic began a measurable rebound after 21:00 ET, climbing past 1,900 high-altitude aircraft before midnight.
  • Data analysts successfully generated comprehensive map animations natively in ClickHouse…: Data analysts successfully generated comprehensive map animations natively in ClickHouse using SQL and its built-in PNG format.

Sources checked by our analysis pipeline: 1

On Friday, November 13, 2026, an FAA outage grounded air traffic across the United States. This post shows the whole day over the lower 48 states, one frame per five minutes, from the ADS-B data on adsb.exposed.

The animation is rendered by ClickHouse itself. There is no plotting library and no image-processing script. A SQL query returns one row per pixel, and the built-in PNG

output format turns those rows into an animated PNG. The map, the title, the clock and the timeline at the bottom are all rows of the same result set. Even the letters are SQL: a 3×5 bitmap font stored in a map

literal.

The same animation is also available as an animated PNG, a GIF and an MP4.

What the data shows

In the animation, each aircraft appears as a short streak: the distance it covered in five minutes. The colors follow the default palette of adsb.exposed:

- Red fades with altitude.

- Green grows over the first 5,000 feet, so climbs and descents around airports look yellow and orange.

- Blue shows ground speed,…

Technology