About - Aviation Database

About This Project

A hobbyist aviation tracking site — what it is, how it works, and a walkthrough of everything it can do.

What Is This? How It Works Full Access Home Page Active & Kiosk Mode FIR Map Search Sightings Aircraft & Manufacturers Countries Country Detail Profile Tech Specs
What is this site?

A hobbyist project built around a simple idea: let anyone see what aircraft are flying near them, and build up a personal log of every flight that's passed overhead. There's no hardware involved — the site pulls from public APIs and community-run virtual radar feeds to populate its database, so all you need is a location and an account.

The database stores aircraft registrations, callsigns, route data, and operator details gathered passively over time. The more flights pass through, the richer it gets. Guests can browse freely, but registered users get a personal layer — their own sightings history, local stats, and live tracking tied to their specific location.

For developers, the same data is also accessible via API, so you can pull aircraft information directly into your own applications if you want to build something on top of it.

How It Works

There's no physical hardware involved. A set of Python scripts run continuously in the background on the VPS, each with a specific role — pulling data from public sources and writing it into the database in real time:

  • Per-user location tracking: When an active account has a location set, a dedicated Python script queries live API streams for flights within that area. Any aircraft passing within range is automatically logged to that user's account, building up their personal sighting history over time.
  • Aircraft & route indexing: Separate background scripts continuously pull from a network of community-operated virtual radar feeders to enrich the database with new aircraft registrations, callsigns, route data, and operator information. On average, around 1,000 new aircraft and 500 routes are indexed every day.
  • Storage: All collected data lands in a MySQL/MariaDB database hosted on a VPS. The PHP backend queries this to serve every page, API response, and per-user dataset across the site.

Global Tracking vs. Regional Indexing

Our system uses two different data streams. Live flight positions and basic telemetry are sourced from flight tracking APIs with global coverage. However, the rich aircraft data (operator, specific type, and callsign route data) is populated by indexing APIs sourced from community-run virtual radar feeders.

Currently, these indexing feeders actively monitor:

  • Europe — General: Pan-Europe and general multi-region feeds
  • Europe — United Kingdom: Scotland, the Midlands, and Edgeley
  • Europe — Germany: Eastern, Western, and Southern regions
  • Europe — Switzerland: General coverage
  • Europe — Italy: Northern region
  • North America — Canada: Atlantic region
  • North America — USA: South Dakota
  • Oceania: ANZ & SE Asia
  • Global: Asia, Middle East, and Africa (partial)

The Database Advantage: Because our tracking and indexing are separate, an aircraft only needs to pass through one of these feeder regions once to have its rich data permanently stored in our database. If that aircraft later flies over your area—even if there is zero active indexing coverage near you—our global flight tracking API will spot it, and the system will automatically pull its full historical profile from the database.

Understanding Coverage Limits
Because live tracking is global, an aircraft's position, registration, and basic telemetry will almost always be accurate no matter where you are. Richer details (aircraft type, operator, historical routes) depend on that aircraft having been indexed by a community feeder at least once in its lifetime. While active feeder coverage has geographical gaps, our database remembers every indexed aircraft indefinitely—meaning you will often see full flight details even in completely uncovered airspace.
What You Get With Full Access

Most of the site is open to everyone — browsing aircraft, searching the database, and exploring the live map are all available without an account. Creating an account and getting it activated adds a personal layer tied to your specific location.

Once active, any flight that passes within a 5-mile radius of your set location is automatically logged to your account. Over time this builds into a personal record: every aircraft you've spotted, how many times, the routes they were flying, and timestamps for each sighting. You also get access to kiosk mode, personal stats, and API keys to query your own data programmatically.

Screenshot placeholder What an active member sees — e.g. the Sightings dashboard or a tracked aircraft's route map

A Tour of the Site

Here's a walkthrough of every page, what it shows, and whether you need to be logged in and active to get the full picture.

Home Page Guest

The homepage is the live front door of the site — everything currently overhead, plus a snapshot of recent local activity.

Active Flights Overhead

A live list of every aircraft currently within range of the antenna, each entry showing its registration, an aircraft photo or silhouette, callsign, and live telemetry such as altitude, speed, and heading.

Screenshot placeholder Active flights overhead

Local Sighting Stats

At-a-glance numbers for the receiver: total sightings logged in the last 30 days, and how many aircraft are active right now.

Screenshot placeholder Local sighting stats

Recent Sightings

A rolling log of the most recently tracked flights, with each row showing the callsign, registration, route, and timestamp it was seen.

Screenshot placeholder Recent sightings section
Active Page & Kiosk Mode Active Members

A dedicated page for active members that lists every aircraft currently being tracked within your set location, with full detail on each one rather than the condensed homepage view. Registration, callsign, aircraft type, operator, altitude, speed, heading, and route are all visible at a glance.

Toggle Kiosk Mode and the page switches to focus on a single aircraft at a time — whichever is currently closest to your location — automatically cycling to the next as it passes. Built to run untouched on a screen or TV, it works like a live overhead feed showing one flight at a time, in full detail.

Screenshot placeholder Full list view
Screenshot placeholder Kiosk mode
FIR Map Guest

An interactive world map of Flight Information Regions (FIRs), showing each region's boundaries along with the airports inside it.

  • Airport runways are drawn to scale directly on the map.
  • Clicking an airport surfaces details like which FIR it belongs to, its elevation, and its coordinates.
Screenshot placeholder FIR map with airports and runways
Sightings Active Members

Your personal sightings dashboard — a complete record of every aircraft and callsign that has passed within range of your set location, automatically logged over time without any manual input.

  • Aircraft & callsign frequency: A ranked list of every registration and callsign you've tracked, showing how many times each has appeared overhead.
  • Route maps: For every aircraft you've spotted, a map showing the routes it was flying each time it passed.
  • Raw sightings feed: A timestamped log of individual sighting events — callsign, registration, route, operator, and the exact time it was recorded for each one.
Screenshot placeholder Personal sightings dashboard
Aircraft & Manufacturers Guest

A browsable catalogue of every aircraft manufacturer and model in the database, built up over time as aircraft are indexed from the feeder network. This page isn't tied to any individual account — the data is the same for everyone, giving a broad picture of what's been recorded across all tracked airspace.

Screenshot placeholder Aircraft manufacturers & models page
Countries GuestActive enhancement

An alphabetical breakdown of every country represented in the database, showing how many airlines are registered there and the total size of their combined aircraft fleet. It's a useful way to get a sense of which nations have the heaviest footprint in the tracked data.

Active members see an additional personal sightings column alongside each country — showing how many aircraft registered there have passed over your location, making it easy to see which countries' fleets you encounter most.

Screenshot placeholder Countries list
Country Detail GuestActive enhancement

Drilling into a single country lists every airline registered there, along with each airline's fleet size.

If you're logged in and active, you'll also see your personal sighting count and last-seen date for each airline, plus a Recent Sightings table with the raw callsign, registration, aircraft type, operator, route, and timestamp for flights from that country.

Screenshot placeholder Country detail page
Profile Active Members

Your account hub — where your tracking location is configured and your API access is managed. Everything here is personal to your account and determines how the site behaves for you.

  • Location setup: Pin your location on a map. Any aircraft passing within a 5-mile radius of that point will be automatically logged to your sightings. This is what drives all the personal tracking features across the site.
  • API keys: Generate and manage API keys to query your own data programmatically. Usage is shown alongside each key so you can monitor consumption.
  • Account details: Update your name, email, and password.
Screenshot placeholder Profile & account settings
Technical Specifications

No hardware, no self-hosted receiver — just a VPS running a PHP/MySQL web stack, kept alive by a set of Python scripts handling all data ingestion in the background:

  • Hardware: None. All data is sourced from public API streams and community-operated virtual radar feeds. There's no physical antenna, SDR, or local radio receiver involved.
  • Data pipeline: Python scripts run continuously on the VPS. One handles per-user location queries against live API streams; others run as background processes to index new aircraft registrations, callsigns, and route data from the feeder network — averaging around 1,000 aircraft and 500 routes per day.
  • Interface: Built with HTML, PHP, CSS3, and vanilla JavaScript. Interactive maps are rendered using Leaflet.js.
  • Backend: PHP handles all database queries, API requests, and user authentication server-side.
  • Database: MySQL / MariaDB, hosted on a VPS, storing aircraft registrations, callsigns, routes, operators, and per-user sighting records.
  • Data sources: Live flight positions and registrations from public API streams; aircraft and route enrichment from a network of community-operated VirtualRadar feeds spanning Europe, North America, Oceania, Asia, the Middle East, and Africa.