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.
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, so the cruising traffic at high altitude is blue.
The morning looks like any Friday. The network fills in from the East Coast westwards, and by 13:00–14:00 ET almost 15,000 aircraft are in the air over the frame in any given hour. At around 15:40 ET the number of positions starts to fall, and it keeps falling for the rest of the afternoon. The high-altitude streaks thin out first, and the airports go dark one after another. By 20:00 ET, only scattered low-altitude flights and a few overflights at the edges of the frame are left.
Hourly numbers for the frame (unique aircraft by ICAO address, and those seen above 18,000 ft):
At 20:00 ET, the number of aircraft at cruising altitude is less than a tenth of the early-afternoon level. For comparison, the quietest hour of the previous night (03:00 ET) still had 818. After 21:00 ET the high-altitude traffic starts to come back.
Here is a still image of two 10-minute windows, 14:00 ET (top) and 20:00 ET (bottom). It was rendered by a single query on the public adsb.exposed server (see below):
You can explore the same days interactively: adsb.exposed, Nov 11–16.
adsb.exposed stores every position report from adsb.lol, airplanes.live and ADSB Exchange in a ClickHouse table, planes_mercator. It has 380 billion rows, and each one has the time, the coordinates, the altitude, the speed and the aircraft. The coordinates are also stored in the Web Mercator projection, precomputed as two UInt32 columns:
The whole world is a 2³² × 2³² square. The table is sorted by mortonEncode(mercator_x, mercator_y), a Z-order curve. A map tile, or any rectangle on the map, is a range of mercator_x and mercator_y, and the primary key makes such a range cheap to read. Turning a coordinate into a pixel takes one bit shift: mercator_x >> 19 divides the world into 2¹³ = 8192 pixels, which is zoom level 5 on the website. At that scale, the rectangle from 128°W to 64°W and from 22°N to 51°N is 1456 × 840 pixels.
For every frame and every pixel, the server counts the positions and averages the altitude and the speed (pixels.sql):
The day is the Eastern-time day: midnight ET is 05:00 UTC. The query reads 42.5 million positions and returns 9 million rows, one for each pixel that saw at least one aircraft in one of the 288 frames. That is about 31,000 lit pixels per frame on average, out of 1.2 million.
The public endpoint of adsb.exposed limits a result to about a million rows. So the query takes the hour as a parameter, {h:UInt32}, and runs 24 times. clickhouse-local does this in one statement: the url table function expands {0..23} in a URL into 24 URLs, and here the glob is placed in the query parameter itself:
Mind the default_format=RowBinary. The url function tells the client what format to parse, but not the server what format to send. The website user defaults to TSV, and parsing TSV as RowBinary fails with a confusing "Cannot read all data" error.
The result is a 160 MB file of pre-aggregated pixels, and every later step runs locally.
ClickHouse has an output format that renders the result of a query as an image. The color mode comes from the column names: r, g, b for RGB, r, g, b, a for RGBA, or v for grayscale. If there are integer x and y columns, they place each row on the canvas. Otherwise the rows fill the pixels in scanline order. And if there is a t column, the result becomes an animated PNG with one frame per value of t. A frame lasts until the next value of t, and the settings output_format_image_time_multiplier_seconds and output_format_image_time_divisor_seconds set the unit of t. Here it is 2/25 of a second, so each 5-minute frame plays for 80 ms and the whole day takes 23 seconds.
When two rows land on the same pixel, the last one wins (the painter's algorithm). So the picture is built in layers, sorted with ORDER BY layer:
- The ghost. The whole day's traffic, summed per pixel on a log scale and drawn in dark gray in every frame. It keeps the outline of the country visible when the sky empties. These are 405,000 pixels, copied into 288 frames with ARRAY JOIN range(frames).
- The aircraft. The aircraft of the current frame, colored by altitude and speed.
- The timeline. The number of positions in every frame as a bar chart under the map, with the current frame highlighted and the past in a lighter gray than the future.
- The text. Every string is split into characters, every character into the 15 bits of its glyph, and every lit bit into a scale × scale square of pixels. Four ARRAY JOINs, one after another, produce the cross product. The clock is plain formatDateTime in the America/New_York and UTC time zones.
The complete query (render.sql):
The query produces about 130 million pixel rows: 117 million for the ghost, 9 million for the aircraft, and the rest for the timeline and the text. It writes all 288 frames in 31 seconds on a single machine.
A few things to note:
- Pixel values are clamped, and floats are scaled. An integer channel is clamped to [0, 255], and a Float channel is clamped to [0, 1] and then multiplied by 255. The color math here produces floats in [0, 255], so the outer SELECT converts them with toUInt8(round(...)). Otherwise, every lit pixel would come out pure white.
- Frames are independent. Each frame starts from a black canvas, which is why the ghost has to be repeated in every frame and is not drawn just once. In return, t can arrive in any order. The rows of one frame only need to be ordered among themselves, by layer.
- Memory versus streaming. By default, the format keeps every frame in memory until the end of the query: 288 × 1456 × 930 × 3 bytes, about 1.2 GB here. With output_format_image_streaming_animation = 1, it writes each frame as soon as t advances and keeps only one frame in memory. This requires ORDER BY t, layer. Also, the frame count in the header is then only an upper bound: browsers play such a file, but some decoders complain.
FORMAT PNG writes truecolor frames, and the 288 frames come to 150 MB. The picture is mostly black, so a single 256-color palette, built from a few sample frames, loses very little. Converting to that palette brings the APNG down to 25 MB. The GIF and the MP4 come from the same file with ffmpeg:
The MP4 uses H.264 High profile in yuv420p, so it plays in QuickTime, the Windows players, VLC, browsers and messengers. It is the largest of the three, because thousands of thin, one-pixel streaks are hard for video compression.
The public website user of adsb.exposed is read-only, so it cannot change the image size. But the default canvas is 1024 × 1024, and for a still image that is enough. This query fits two panels, one above the other, keeping the aspect ratio of the map. It runs on the server and returns the PNG in the HTTP response (before-after.sql):
It takes 10 seconds, and no code runs outside of ClickHouse.
Everything is in this directory: make.sh runs the three steps. You need clickhouse (any recent version with FORMAT PNG; this was made with 26.10), ffmpeg, and Python with Pillow for the final palette conversion.
The data is © adsb.lol (ODbL v1.0), © airplanes.live, © adsbexchange.com.











