NATO AWACS flightpath analyse with Python

Johan Louwers
6 min readApr 15, 2024

Disclaimer; this blogpost has been written based upon public available information only.

We’ve recently noticed increased interest from NATO partners in the ‘Gulf of Finland’ region. Multiple AWACS and SIGINT airframes have been observed simultaneously in this area, sparking various questions and discussions within the OSINT community. One such discussion revolves around whether St. Petersburg is within the scope of this interest. Essentially, the concern is whether the flight paths being conducted bring St. Petersburg within range of radar and SIGINT equipment.

NATO06 flight path on April the 11th 2024

Thanks to FlightRadar24, it’s relatively simple to track flights and download flight data. We’ve obtained the flight data from the NATO06 flight for analysis.

Interpret the base flight data

All .CSV files downloaded from FR24 that are present in a directory will be read by the below script. The script will combine all the files into a single .CSV file and make sure some required changes to the data structure are needed to be able to load this into .

import pandas as pd
import glob

# Find all CSV files in the current…



Johan Louwers

Johan Louwers is a technology enthousiasts with a long background in supporting enterprises and startups alike as CTO, Chief Enterprise Architect and developer.