sdr-enthusiasts / plane-alert-db

A list of interesting aircraft - Governments, Dictators, Military, Historic and just plain odd.

plane-alert-db

This project consists of lists of 'interesting' aircraft, formatted as CSV files. The list is designed to work with the excellent https://github.com/sdr-enthusiasts/docker-planefence.

Warning Please only suggest/make any changes to the plane-alert-db.csv, plane-alert-pia.csv, plane-alert-ukraine.csv and plane_images.csv files on GitHub - all other files (except PIA) are generated from this file, and if you do not make your changes there, they will be overwritten and lost. Additionally, it is not recommended to edit the CSV files in Microsoft Excel, as Excel will attempt to "fix" some ICAO hexes and other fields. It's better to use a code editor such as VS Studio Code—you can access the web version of Code by pressing the period key . when viewing the file you wish to edit.

TOC

• Current Content
• Description of Categories
• Planefence
• Contributing
• Disclaimer, excuses and dodges
• Data Sources

Current Content

There currently are about 14320 unique aircraft in 51 categories found in this repository. This Dashboard contains details of the main list and the most recent additions. These aircraft are divided into four main databases:

• plane-alert-db.csv - A list of interesting aircraft with tags, categories and links. (14287)
• plane-alert-pia.csv: A list that contains PIA planes. (68)
• plane-alert-ukraine.csv: A list with Ukrainian planes. (33)
• plane_images.csv: A accompanying list that contains aircraft images. (11318)

Based on these main databases, several derivative databases are created using a GitHub action:

• plane-alert-civ.csv - Civilian Registered Aircraft, includes Historic and Distinctive. (3871)
• plane-alert-mil.csv - Military Only. (7858)
• plane-alert-pol.csv - Police Forces. (913)
• plane-alert-gov.csv - Governments, Gov Agencies and Dictators. (1645)

A second version of each of the above lists contains up to 4 image links per aircraft. These lists are created in GitHub action using the plane_images.csv database. Please consider this experimental, do not come to rely on any of the image links

• plane-alert-db-images.csv
• plane-alert-ukraine-images.csv
• plane-alert-civ-images.csv
• plane-alert-mil-images.csv
• plane-alert-pol-images.csv
• plane-alert-gov-images.csv

Note, we used to create a seperate list, plane-alert-twitter-blocked.csv, for use with Planefence's Twitter posting functionality. This list would prevent certain aircraft from being posted to Twitter in an attempt to keep the posting bot account from being banned. Since Twitter has now made it all but impossible for users to make bots for free, we've stopped creating this list.

This Dashboard contains details of the main and Ukraine lists.

Description of Categories

Think of categories like groups, with similar or related aircraft listed together. This allows you to easily select a subset of the list for your own use. The category names (and tags) come from my rather idiosyncratic sense of humour. If you have better suggestions I'm all ears.

Category	Description	Count
Aerial Firefighter	Firefighting Aircraft	327
Aerobatic Teams	Red Arrows, Blue Angels, etc.	78
Army Air Corps	UK Army Air Corps, mainly Helicopters	94
As Seen on TV	Companies and Brands	417
Big Hello	Large Helicopters (sic)	104
Bizjets	Fancy pants planes for fancy pants people	43
CAP	Civil Air Patrol.	7
Climate Crisis	Oil Companies, Large Business Jets - BBJs and ACJs	192
Coastguard	Coastguard, Customs and Border Patrols	440
Da Comrade	Russian or Soviet Aircraft	91
Dictator Alert	People of potentially questionable morals and values	324
Distinctive	Unique and/or special aircraft e.g. The AN-225 Myria, NASA aircraft, Testbeds	187
Dogs with Jobs	Aircraft with specific roles and/or modifications	175
Don't you know who I am?	Famous People. I was going to say notable, but I'll go with Famous	65
Flying Doctors	Air Ambulance and Medical Flights	804
Football	Actual, Aussie Rules or American. We don't discriminate.	9
GAF	Aircraft of the German Air Force	407
Gas Bags	Would you like to ride in my beautiful balloon?	14
Governments	Aircraft registered to Governments	253
Gunship	Brrrrrrrrrrrrrrrrrrrt	261
Hired Gun	Why do the dirty work when someone else can do it for you?	253
Historic	It's older than I am and most likely has a prop.	419
Jesus he Knows me	Aircraft owned and operated by religious organisations	21
Joe Cool	Cool Planes. Or at least I think they are cool.	210
Jump Johnny Jump	de Havilland Chipmunks. Air Cadets of a certain age will understand.	388
Nuclear	Nuclear Emergency Support Team etc.	16
Oligarch	I made this money all by myself.	41
Other Air Forces	Air Force aircraft that are not GAF, RAF, or USAF	2004
Other Navies	Navy Aircraft that are not Royal Navy Fleet Air Arm or United States Navy	199
Oxcart	Intelligence gathering aircraft	656
Perfectly Serviceable Aircraft	Why do you keep jumping out of a Perfectly Serviceable Aircraft aka Skydiving planes	44
PIA	Privacy ICAO Address....you can run, but you cannot hide.	15
Police Forces	Your friendly neighbourhood flying (insert local colloquialism here).	899
Ptolemy would be proud	Mapping and Aerial Survey aircraft.	146
Quango	NATO, United Nations, World Bank etc.	32
Radiohead	Very Very special aircraft. Think VC25.	5
RAF	Aircraft of the Royal Air Force	240
Royal Aircraft	Aircraft used or owned by the UK Royal Family	8
Royal Navy Fleet Air Arm	Aircraft of the Royal Navy Fleet Air Arm	97
Special Forces	The best of the best of the best. Sir.	180
Toy Soldiers	Armies from around the world.	804
UAV	It's not natural, I tell 'ya!	33
UK National Police Air Service	Your friendly neighbourhood flying bobby.	24
United States Marine Corps	Aircraft of the United States Marine Corps, Oorah!	219
United States Navy	United States Naval avaitors. Some say they are the best of the best.	392
USAF	Aircraft of the United States Air Force	2269
Vanity Plate	Distinctive registrations	74
Watch Me Fly	Flying and Training Schools	75
You came here in that thing?	Microlights, tiny planes and helis..think Yakima Super Breezy.	99
Zoomies	Fast jets, fighters. Anything that moves fast.	135

Planefence

The list takes the form:

$ICAO	$Registration	$Operator	$Type	$ICAO Type	#CMPG	$Tag 1	$#Tag 2	$#Tag 3	Category	$#Link
502C5C	YL-KSH	Baltic Bees display team	Aero L-39C Albatross	L39	Civ	Do A Barrel Roll	Display Team	Aerobatics	Aerobatic Teams	https://en.wikipedia.org/wiki/Baltic_Bees_Jet_Team

To use this list with Planefence, configure your planefence.config setup to include the following line:

PF_ALERTLIST=https://raw.githubusercontent.com/sdr-enthusiasts/plane-alert-db/main/plane-alert-db.csv

If you want to add the list in addition to your local plane-alert-db.csv list, you can do the following:

PF_ALERTLIST=plane-alert-db.csv,https://raw.githubusercontent.com/sdr-enthusiasts/plane-alert-db/main/plane-alert-gov.csv,https://raw.githubusercontent.com/sdr-enthusiasts/plane-alert-db/main/plane-alert-pol.csv

Note The priority of use is first-to-last, so if you want your local list to be interpreted first, move it to the front of the list.

Add these characters to the column headers to control the behaviour of PlaneAlert

• $ - Tweet this column as #hashtag.
• # - Don't show on the website (it will ignore this for the ICAO field, which is always shown).
• $# - Don't show on the website; tweet as a #hashtag.

Contributing

Feel free to open an issue if you have ideas on improving this repository or want to report a bug! All contributions are welcome 🚀. Please consult the contribution guidelines for more information. You can also check out the TODOS page if you want to contribute to this repository but need some ideas.

Warning As also explained above, this repository contains four main databases to which people can contribute. The other databases are created automatically using GitHub action. As a result, please only suggest/make any changes to these main databases. Changes made to all other CSV files will be overwritten and lost. Additionally, it is not recommended to edit the CSV files in Microsoft Excel, as Excel will attempt to "fix" some ICAO hexes and other fields. It's better to use a code editor such as VS Studio Code—you can access the web version of Code by pressing the period key . when viewing the file you wish to edit.

If you're creating a pull request with additions, please add them to the end of the file. We may sort the list periodically to group like planes together.

Disclaimer, excuses and dodges

This is not intended to be a definitive list, especially when it comes to aircraft models. Where the same model of aircraft is made by several manufacturers I won't always have the correct one. If you thought it was a Beechcraft King Air 200 and actually it was a Textron Super King Air B200GT, I won't be losing any sleep. There are other data sources (see below) if you want absolute accuracy.

Data Sources

This data has been gathered from far too many sources to mention, but some sites have been really useful:

• https://github.com/iatacodes/whatisflying-db
• https://github.com/The-CFR-Project/whatisflying-db
• https://www.flightdb.net/index.php
• http://www.rotorspot.nl/
• http://www.dtvmovements.co.uk/
• http://www.ads-b.nl/
• https://www.live-military-mode-s.eu/
• https://dictatoralert.org/
• http://www.j-hangarspace.jp/
• https://scramble.nl/
• https://www.foxtrotcharlie.ovh/
• https://www.planelogger.com/
• https://www.jetphotos.com/

LICENSE

Copyright (C) 2022-2024 by SDR-Enthusiasts, Ramon F. Kolb (kx1t), and contributors. A list of contributors can be found at https://github.com/sdr-enthusiasts/plane-alert-db/graphs/contributors

This Database is made available under the Open Database License: http://opendatacommons.org/licenses/odbl/1.0/ Any rights in individual contents of the database are licensed under the Database Contents License: http://opendatacommons.org/licenses/dbcl/1.0/

plane-alert-db's Issues

Correction

Hi. Please can you change G-CIOS 406B1E from Cornwall Air Ambulance to Specialist Aviation Services. It is no longer op for Cornwall Air Ambulance. Ta. R

Make automatic PR suggestions based on the OpenSky database

Is your feature request related to a problem? Please describe.

Like #130, people manually go through the https://opensky-network.org/datasets/metadata/ database and make suggestions to https://github.com/sdr-enthusiasts/plane-alert-db based on planes that are missing.

Describe the solution you'd like

We could automate this process and create a GitHub action that periodically checks the data in https://opensky-network.org/datasets/metadata/ and makes PRs based on the differences between the https://github.com/sdr-enthusiasts/plane-alert-db/blob/main/plane-alert-db.csv db and the data on OpenSky.

Describe alternatives you've considered

No response

Additional context

No response

A current diff between Radar Atlas and the plane-alert-db

Is your feature request related to a problem? Please describe.

Well this is a current list I believe of all of the ICAO which are in RadarAtlas but not in this database. It's semi-automatically done as it's a libreoffice (in this column but not that one) but I checked a few and they don't appear to be in this database. Of course they could be old or outdated. But since it's here, here goes:

diff.csv

Describe the solution you'd like

Well, we NEED more Gasbags so I think those Goodyear blimps should be added :). Anyway this can be closed whenever of course; it's just a handy way to hand over the file.

Describe alternatives you've considered

No response

Additional context

No response

Remove unused files

Is your feature request related to a problem? Please describe.

The repository currently contains the following unused files:

• https://github.com/sdr-enthusiasts/plane-alert-db/blob/main/planepix.txt: Kept because of sdr-enthusiasts/docker-planefence#171.
• https://github.com/sdr-enthusiasts/plane-alert-db/blob/main/scripts/check_james_planes.py: Can be removed if #24 is fixed.
• https://github.com/sdr-enthusiasts/plane-alert-db/blob/main/scripts/create_images_reference.py: Used for creating the new actions but can be removed if we are certain that the actions are correct and desirable.
• https://github.com/sdr-enthusiasts/plane-alert-db/blob/main/scripts/get_unique_bangers_best_items.py: Used for creating the new actions but can be removed if we are certain that the actions are correct and desirable.
• https://github.com/sdr-enthusiasts/plane-alert-db/blob/main/scripts/get_unique_bangers_best_items.py
• https://github.com/sdr-enthusiasts/plane-alert-db/blob/main/scripts/james_planes.py: Can be removed if #24 is fixed.

Describe the solution you'd like

This action serves as a reminder that these files can be removed in the future.

Describe alternatives you've considered

No response

Additional context

No response

Make automatic PR suggestions based on the TAT database

Is your feature request related to a problem? Please describe.

People currently manually go through the TheAirTraffic database google sheet and make suggestions to https://github.com/sdr-enthusiasts/plane-alert-db based on planes that are missing (see #24).

Describe the solution you'd like

We could automate this process and create a GitHub action that periodically checks the data in the extension and makes PRs based on the differences between the https://github.com/sdr-enthusiasts/plane-alert-db/blob/main/plane-alert-db.csv DB and the data in the TheAirTraffic database.

Describe alternatives you've considered

No response

Additional context

No response

Improve derivative database alert action

Is your feature request related to a problem? Please describe.

Currently, https://github.com/sdr-enthusiasts/plane-alert-db/actions/workflows/post_derivative_warning.yml only posts a warning. It makes more sense also to have the check fail when a user changes a derivative database.

Describe the solution you'd like

We can have one action job/step that fails when the derivative databases are changed and have another action job/step that succeeds when the derivative databases are no longer changed.

Describe alternatives you've considered

No response

Additional context

No response

Change plane_images extension to CSV

Is your feature request related to a problem? Please describe.

Currently, the file https://github.com/sdr-enthusiasts/plane-alert-db/blob/main/plane_images.txt file is not shown in GitHub's table viewer (see https://github.blog/2013-08-22-see-your-csvs/).

Describe the solution you'd like

We can fix this by changing the file extension to CSV. @kx1t do you maybe know the reason why the original planepix.txt file was in the TXT extension while the rest of the databases were CSV?

Describe alternatives you've considered

No response

Additional context

We have to fix sdr-enthusiasts/docker-planefence#171 on the upstream before we can do this.

The plane_images database contains duplicate ICAOs

Describe the bug

The plane_images database contains the following duplicate ICAOs.

duplicate_icao.csv

Expected behaviour

There should not be duplicate ICAOs.

Screenshots / Live demo link

No response

Additional context

No response

Make automatic PR suggestions based on the RadarAtlas database

Is your feature request related to a problem? Please describe.

People currently manually go through the Radar Atlas extension source code and make suggestions to https://github.com/sdr-enthusiasts/plane-alert-db based on planes that are missing (see #24).

Describe the solution you'd like

We could automate this process and create a GitHub action that periodically checks the data in the extension and makes PRs based on the differences between the https://github.com/sdr-enthusiasts/plane-alert-db/blob/main/plane-alert-db.csv db and the data in the Radar Atlas extension.We could automate this process and create a GitHub action that periodically checks the data in the extension and makes PRs based on the differences between the https://github.com/sdr-enthusiasts/plane-alert-db/blob/main/plane-alert-db.csv db and the data in the Radar Atlas extension.

Describe alternatives you've considered

No response

Additional context

No response

Add LICENSE

Is your feature request related to a problem? Please describe.

Is it an idea to add an open-source/data license to this repository?

Describe the solution you'd like

Maybe something like https://creativecommons.org/choose?

Describe alternatives you've considered

No response

Additional context

No response

Change derivative check such that it does not fail if the derivative files are correct

Is your feature request related to a problem? Please describe.

Currently, the https://github.com/sdr-enthusiasts/plane-alert-db/blob/main/.github/workflows/create_db_derivatives.yaml fails when any of the derivative files are changed.

Describe the solution you'd like

It might be nice to warn if the derivative files are correct because they were generated using https://github.com/sdr-enthusiasts/plane-alert-db/blob/main/scripts/create_db_derivatives.py.

Describe alternatives you've considered

No response

Additional context

Maybe also add a guide on how people can let the https://github.com/sdr-enthusiasts/plane-alert-db/blob/main/.github/workflows/create_db_derivatives.yaml run on their forks. This has to explain how they can give the action write permissions (see https://docs.github.com/en/actions/security-guides/automatic-token-authentication#permissions-for-the-github_token).

Add simple web application

Is your feature request related to a problem? Please describe.

It would be amazing to have a simple web application that people can use to search planes.

Describe the solution you'd like

Something similar to https://opensky-network.org/aircraft-database would do. We can also add ➕ and ✏️ symbols which would redirect to the respective lines in the GitHub CSVs. This would give more visibility to the list and make it easier for people to contribute. This is a long shot, but just putting this idea out here 👍🏻.

Describe alternatives you've considered

No response

Additional context

No response

Interesting Planes

404

Describe the bug

404 from clicking twitter list in readme...

Expected behaviour

No response

Screenshots / Live demo link

https://github.com/sdr-enthusiasts/plane-alert-db/blob/main/plane-alert-twitter-blocked.txt

Additional context

No response

Create a database statistics readme update action

Is your feature request related to a problem? Please describe.

Currently, the numbers and categories in https://github.com/sdr-enthusiasts/plane-alert-db#current-content and https://github.com/sdr-enthusiasts/plane-alert-db#description-of-categories are hard coded.

Describe the solution you'd like

We could update these values based on the databases using a GitHub action.

Describe alternatives you've considered

No response

Additional context

No response

planes with freakin' lazer beams

N300WQ, a Beechcraft 300
N406SD, a Reims F406

bathymetric (ocean) lidar scanners using a visible green laser, operated by Woolpert.

https://www.thedrive.com/the-war-zone/42754/scanned-by-a-green-beam-of-light-from-the-sky-in-california-recently-heres-what-did-it

uses this lidar: https://www.teledyneoptech.com/en/applications/defense-and-security/bathymetry-object-detection/

Update Github Action to Add lines to plane_images.txt when new planes added to plane-alert-db.csv

Is your feature request related to a problem? Please describe.

It would be helpful if the existing Github Action would add lines to plane_images.txt when new planes are added to plane-alert-db.csv. It would be beneficial to keep the two files in sync. If the user does not update the plane_images.txt file in the pull request that adds a new hex to plane-alert-db.csv, a line with the hex followed by 4 commas would be ideal.

Describe the solution you'd like

No response

Describe alternatives you've considered

No response

Additional context

No response

Celebrity Private Jets

Is there any interest in adding more celebrity jets?

I can go through this site and add any missing (most seem to be missing) if there's any interest.

https://celebrityprivatejettracker.com/celebrity-aircraft-models/

Add CONTRIBUTING

Is your feature request related to a problem? Please describe.

Maybe it is an idea to add a CONTRIBUTING.md file to the repository? We can add some information for contributors when working on this repository. By doing this, we could clean up the README a bit by moving the todos in there (i.e. https://github.com/sdr-enthusiasts/plane-alert-db#to-do--ideas).

Describe the solution you'd like

Maybe something like https://github.com/rickstaa/github-emoji-picker/blob/main/CONTRIBUTING.md?

Describe alternatives you've considered

No response

Additional context

No response

Main database contains one invalid ICAO number

Describe the bug

As pointed out by @dziban303, the current https://github.com/sdr-enthusiasts/plane-alert-db/blob/main/plane-alert-db.csv database contains one $ICAO that is not a valid hexadecimal:

https://github.com/sdr-enthusiasts/plane-alert-db/blob/c9f0aae3b6e8935de56de33b6cfdd38700651c1e/plane-alert-db.csv#L2006

8.40E+11,JA012G,Japan Civil Aviation Bureau,Cessna Citation CJ4,C25C,Civ,Flight Inspection,Fight Calibration,Trundle Wheel,Dogs with Jobs,https://tinyurl.com/ythr9kku

Expected behaviour

The correct ICAO value should replace this.

Screenshots / Live demo link

No response

Additional context

We can uncomment the following line if this is fixed:

plane-alert-db/scripts/check_main_databases.py

Lines 150 to 152 in 8449559

	# contains_valid_hexes(
	# main_df
	# ) # NOTE: This is commented out because there are invalid values in the database.

fyi, tag scoreboard

Not an actionable ticket, not presented in a pretty way, but I wanted to see how many unique tags/types/etc there were.

I need to exclude headers, but it's an interesting way to generate the tags for the readme, standardizing them, etc. It'd be nice to map the tags to the definitions of them.

CPMG

  "cmpg": {
    "Mil": 970,
    "Gov": 534,
    "#CMPG": 1,
    "Pol": 29,
    "Civ": 212,
    "CMPG": 2
  },

Type

  "type": {
    "Fairey Swordfish II": 1,
    "Antonov An-12 TB": 1,
    "Dassault Falcon 50": 10,
    "Cessna UC-35A Citation": 1,
    "BAe 125-800A": 2,
    "Canadair CL-600-2A12 Challenger 601": 1,
    "Airbus Voyager KC.2": 4,
    "Embraer Phenom 100": 4,
    "BN-2A Islander-2A": 1,
    "Panavia Tornado": 11,
    "Ilyushin IL-76TD-90VD": 2,
    "ACJ319 133X": 2,
    "Beechcraft King AIr B200": 6,
    "Slingsby T.61 F Falke Venture T.3": 1,
    "Tornado ECR": 48,
    "Boeing E-3D Sentry AEW1": 4,
    "Boeing 747-412F": 2,
    "Fokker F100": 1,
    "Supermarine Spitfire PRXIX": 2,
    "Airbus A321-231": 2,
    "Gloster Meteor T7": 1,
    "Boeing 737-NG8AJBBJ2": 2,
    "Boeing 747-430": 2,
    "Boeing 747-SP-68": 4,
    "DHC2 Beaver AL1": 1,
    "Diamond Aircraft DA42M-NG": 2,
    "Eurocopter Twin Squirrel AS.355 NP": 1,
    "Boeing 737-NG8EXBBJ2": 2,
    "Panavia Tornado ECR": 9,
    "Dassault Falcon 20DC": 2,
    "Aerospatiale Puma SA.330 HC.2": 1,
    "Bell/Boeing CV-22B Osprey": 8,
    "North American P-51D Mustang": 1,
    "Airbus A340-213X": 2,
    "Cessna 560": 1,
    "Boeing WC-135C": 1,
    "Beech B200 Super King Air": 2,
    "Tupolev Tu-214PU": 4,
    "Tornado IDS(T)": 29,
    "Eurofighter Typhoon (T)": 8,
    "Boeing 737-NG7EJWBBJ": 2,
    "Socata TBM 700 A": 1,
    "Shadow R1": 3,
    "Bombardier BD-700-1A10 Global Express": 2,
    "Panavia Tornado IDS": 7,
    "A300 B4-608ST Beluga": 4,
    "Boeing 747-4P8": 2,
    "Boeing C-32B": 2,
    "Gates Learjet 35 A": 1,
    "AgustaWestland Apache AH.1": 5,
    "Airbus A340-212": 2,
    "Boeing 747-SP27": 2,
    "BAC Jet Provost T.5A": 1,
    "Boeing 767-4FSER": 2,
    "Bell 407": 7,
    "Gulfstream G550": 12,
    "Tekever AR5": 1,
    "B350C Shadow R1": 3,
    "Douglas C47A Dakota": 1,
    "Fairey Swordfish IV": 1,
    "FIESELER F156A-1 Storch": 1,
    "Boeing 737-NG8E0BBJ2": 2,
    "UC-35A Citation": 1,
    "Supermarine Spitfire Iia": 1,
    "Ilyushin IL-96300PU": 6,
    "Boeing 757-23A": 2,
    "Reims-Cessna F406 Caravan II": 3,
    "Boeing E4b Nightwatch": 1,
    "Piper PA-28": 1,
    "Airbus ACJ320-214X": 2,
    "Eurofighter Typhoon ": 1,
    "Boeing 727-1H2": 2,
    "Bombardier E-11A": 1,
    "VFW Transall C-160D": 1,
    "General Dynamics WB-57F Canberra": 3,
    "Antonov An-12 B": 1,
    "Cessna 206H Stationair": 2,
    "Supermarine Spitfire T.IX": 1,
    "Stinson Reliant V-77": 1,
    "Yakovlev Yak-18T": 1,
    "Cessna UC-35A Citation Ultra": 2,
    "Vulcanair P.68R": 4,
    "Bombardier Global 7500": 1,
    "Aerospatiale SA-365N3 Dauphin 2": 1,
    "Airbus Helicopters Squirrel AS.350 B3e": 1,
    "Boeing 747-8ZV (BBJ)": 2,
    "Boeing 727-95": 2,
    "Boeing 767-306(ER)": 2,
    "Gulfstream III": 2,
    "Boeing 737-NG75UWBBJ": 2,
    "Fokker F28 1000": 2,
    "Boeing 747-SP-21": 2,
    "Beechcraft Corp King Air B350": 1,
    "Piper PA-31 Navajo C": 4,
    "Bell 206L-4 LongRanger": 1,
    "Bell Griffin HT.1": 4,
    "BN2T Islander CC2": 1,
    "Bombardier Learjet 45": 11,
    "Antonov An-225 Mriya": 1,
    "McDonnell Douglas NF-15B Eagle": 1,
    "Dassault Falcon 2000LX": 1,
    "Gulfstream GVII-G500": 3,
    "Boeing KC-135R": 2,
    "BAe 146-100 CC.2 (VIP)": 2,
    "Lockheed L100-30 Hercules": 1,
    "Beech E90 King Air": 1,
    "Boeing 737NG 7EI/W BBJ": 1,
    "Bombardier Global 6000": 1,
    "ATR 42-300": 2,
    "BN2T Defender AL2": 2,
    "Hawker Hurricane Iic": 2,
    "Dornier D228": 2,
    "Sikorsky CH-53GA Stallion": 28,
    "Boeing E6B Mercury": 1,
    "Boeing 737-NG BBJ": 2,
    "Boeing 777-3FXER": 2,
    "Cessna 404 Titan": 1,
    "Eurocopter EC135 T2": 7,
    "Raytheon Aircraft Company King Air B350": 1,
    "BN2T Islander AL1": 4,
    "CH-53GA Stallion": 6,
    "Gulfstream GIVSP": 11,
    "Cessna 210": 1,
    "Aerospatiale SA-365N2 Dauphin 2": 1,
    "Aerostar Yak-52": 1,
    "Airbus A340-211": 4,
    "Eurocopter EC135-T3": 1,
    "Eurofighter Typhoon T": 1,
    "Tupolev Tu-214SUS": 4,
    "Reims/Cessna F406 Caravan II": 2,
    "Boeing 747-3G1": 2,
    "Lockheed ER2": 2,
    "Avro 146 RJ70": 1,
    "C-130J Super Hercules": 1,
    "AgustaWestland EH 101 Merlin HM2": 23,
    "Gulfstream G650": 26,
    "Leonardo AW.169": 1,
    "Pilatus PC-24": 2,
    "A400M-180": 2,
    "Gates Learjet 25G": 1,
    "Boeing 737-300 VIP": 2,
    "Boeing RC135W Airseeker": 3,
    "Beechcraft C-12U-3 Huron": 4,
    "CL-600-2A12 Challenger 601": 1,
    "Airbus A340-213": 2,
    "Airbus ACJ320-232XSL": 2,
    "Boeing 737-NG 73T/W BBJ": 1,
    "Fieseler F156A-1 Storch": 1,
    "Airbus A330-743L": 1,
    "Airbus ACJ319-115": 5,
    "Bombardier BD-100-1A10": 1,
    "EH.101 Merlin HC.4": 1,
    "UH-1D Iroquois": 1,
    "Bombardier Learjet 45XR": 2,
    "Gulfstream C-37B": 2,
    "BAe Hawk T1": 1,
    "Boeing 737-200": 2,
    "Israel Aircraft Industries 1125 Astra SP": 1,
    "Antonov An-12 BP": 1,
    "McDonnell Douglas DC9-87": 2,
    "Boeing 737-NG 7JV BBJ/W": 1,
    "Boeing 747-468": 2,
    "Boeing 777-2ANER": 2,
    "Swearingen C-26D Metro": 1,
    "BAe 125-750": 1,
    "Yakovlev Yak-40": 4,
    "Westland WAH-64D Apache AH1": 1,
    "Eurofighter Typhoon": 18,
    "AgustaWestland Wildcat HMA2": 10,
    "Eurocopter EC135-P2": 1,
    "Tornado Ecr": 1,
    "Antonov An-74TK-300": 2,
    "AgustaWestland AW.189": 2,
    "Honda Jet": 1,
    "Bombardier Global Express XRS": 2,
    "Boeing 777-2FBLR": 2,
    "Gulfstream IV": 7,
    "Typhoon T": 8,
    "Partenavia P.68 Observer 2": 1,
    "Airbus ACJ320-232SL": 2,
    "Beech1900D": 4,
    "Raytheon Aircraft Company 400 XP": 1,
    "Boeing 377-SGT-201": 1,
    "Bell MD-900 Explorer": 1,
    "Airbus Helicopters Squirrel AS.350 B3": 3,
    "Global 5000": 4,
    "Antonov An-148100EA": 4,
    "Dassault Falcon 20ECM": 1,
    "Beechcraft Corp King Air C90GTX": 1,
    "Beechcraft 350 Super King Air": 1,
    "Boeing 737-4YO": 1,
    "Boeing E-3A Sentry": 15,
    "Supermarine Spitfire LFIXe": 2,
    "Pilatus PC-XII Spectre": 1,
    "Breguet Atlantique ATL 2": 8,
    "Britten-Norman Defender T.3": 1,
    "Boeing 777-35RER": 2,
    "Sukhoi Superjet 100-95LR": 2,
    "Lockheed C-5M Galaxy": 1,
    "Sikorsky S76C++": 2,
    "AgustaWestland AW101 AEW2 'Crowsnest'": 1,
    "F35 Lightning II": 1,
    "Boeing 757-200": 2,
    "Ilyushin IL-62 MGR": 1,
    "Boeing-Vertol Chinook HC.4": 2,
    "Airbus A320-212": 4,
    "Embraer ERJ-135": 2,
    "CASA CN-235 100MPA": 2,
    "Textron Aviation Citation XLS+": 1,
    "Boeing Poseiden P8": 1,
    "Canadair CL-600-2B16 Challenger 601-3A": 2,
    "Airbus Phenix 243-MRTT": 1,
    "Transall C-160D": 107,
    "Dassault Falcon 900LX": 1,
    "Tupolev Tu-154M": 2,
    "A400M": 12,
    "Boeing 777-22KLR": 2,
    "Ilyushin IL-62M": 2,
    "Supermarine Spitfire LFVb": 1,
    "Gates Learjet 35": 1,
    "Lockheed C-130J Super Hercules": 3,
    "Britten-Norman Defender 4000 BN-2T-4R": 1,
    "Boeing 747": 1,
    "Gulfstream G300": 6,
    "Amateur Built Pitts Special P-12": 1,
    "Airbus ACJ320-232X": 2,
    "Bombardier Dash 8-Q402": 2,
    "Boeing RC-135V Joint Rivet": 1,
    "F35B Lightning II": 2,
    "Airbus ACJ319-133LR": 2,
    "Panavia Tornado IDS(T)": 1,
    "Bombardier Challenger 650": 2,
    "Lockheed KC-130J Hercules": 2,
    "Airbus A319-133X": 2,
    "Boeing-Vertol Chinook HC.6A": 5,
    "Airbus A330-243": 10,
    "Boeing 787-8BBJ": 4,
    "SAAB 340 F": 1,
    "Boeing KC-707 3P1C": 1,
    "Eurocopter Squirrel AS.350 HT2": 2,
    "Cessna 560 Citation Ultra": 1,
    "Avro 146-RJ85": 8,
    "Embraer 121 Xingu AN": 2,
    "BAe Hawk T1a": 23,
    "Airbus Voyager KC.3": 6,
    "Boeing 737-NG7FGWBBJ": 2,
    "Textron Aviation King Air 200GT": 1,
    "Douglas DC-8-60/70": 1,
    "Boeing 737-NG86JW": 2,
    "Britten-Norman Islander R.1": 2,
    "Gulfstream G4SP": 2,
    "Eurocopter EC135 P2": 3,
    "Boeing 747-89L": 2,
    "Gulfstream G650 ER": 5,
    "Boeing 76732KER": 2,
    "Extra EA-300": 5,
    "Bombardier Challenger 605": 1,
    "Boeing VC25A": 2,
    "Lockheed C-130T Hercules": 1,
    "Hawker Hunter T.72": 1,
    "Boeing 777-268": 2,
    "Antonov An-12 BK": 1,
    "Boeing 737-400C": 1,
    "Grob G-115 E Tutor": 1,
    "Antonov An-124 100": 4,
    "Lockheed U2-S": 5,
    "Antonov An-74TK-200": 2,
    "Bell 412HP": 1,
    "Eurofighter Typhoon FGR4": 22,
    "Boeing 737-NG7GLW": 2,
    "Sikorsky S-92A": 3,
    "A321-231(CJ)": 1,
    "Cessna F406 Caravan II": 1,
    "Sukhoi Superjet 100-95B": 4,
    "Britten-Norman Defender R.2": 3,
    "Bombardier DHC-8-Q-402": 1,
    "Embraer Phenom 300 E": 1,
    "Augusta-Westland Wildcat AH.1": 1,
    "Airbus A330-202": 4,
    "Dornier D228NG": 2,
    "Boeing C-17A Globemaster III": 13,
    "Bell 429 Global Ranger": 1,
    "Gulfstream C-37A": 4,
    "Tecnam P.2006T": 1,
    "Bombardier CC-144D": 1,
    "Gulfstream G450": 5,
    "Gulfstream G-V": 12,
    "Beechcraft B200GT King Air": 2,
    "Airbus ACJ319-115 (Elite)": 2,
    "Gulfstream G280": 1,
    "Boeing 747-8H0BBJ": 2,
    "Beech 1900D": 2,
    "Bombardier BD-700 Global 5000": 4,
    "Airbus A340-541": 6,
    "McDonnell Douglas MD11": 1,
    "Boeing 737-NG9FGW": 2,
    "Eurocopter EC135": 2,
    "Beechcraft C-12F Huron": 1,
    "Boeing 767-2N0(ER)": 4,
    "Cessna 182T Skylane": 49,
    "Robinson R44 Raven II": 1,
    "Boeing RC-135W": 2,
    "Type": 3,
    "Schempp-Hirth Arcus T": 1,
    "Lockheed C-130H Hercules": 3,
    "Dassault Falcon 900EX": 11,
    "Xtremeair Sbach XA-41": 1,
    "Airbus A350-941": 1,
    "Bell UH-1D Iroquois": 1,
    "Pilatus PC-XII 47": 1,
    "Lockheed C-130J-30 Hercules": 10,
    "Boeing 737-NG8EVWBBJ2": 2,
    "Airbus Military A400M Atlas C.1": 19,
    "Boeing C-135FR": 1,
    "A340 313X": 2,
    "Panavia Tornado ???": 2,
    "Boeing 737-NG8ECBBJ2": 2,
    "CH-53GE Stallion": 4,
    "Eurocopter EC145-C-2": 1,
    "Dassault Falcon 20C": 3,
    "Boeing-Vertol Chinook HC.5": 3,
    "Piaggio P-180 Avanti": 1,
    "Piaggio P-180 Avanti II": 4,
    "Antonov An-124 100M-150": 1,
    "Tupolev Tu-214VPU": 2,
    "T-6C Texan T.1": 1,
    "Sikorsky CH-53G Stallion": 36,
    "Boeing 747-422": 4,
    "Boeing 737-NG7AJWBBJ": 2,
    "Antonov An-72100D": 2,
    "CH-53GS Stallion": 18,
    "Beechcraft King Air B200": 5,
    "Diamond Aircraft DA42": 4,
    "Beechcraft Corp King Air 350C": 3,
    "Short Skyvan 3-100": 2,
    "Airbus A340-313X": 4,
    "Diamond Aircraft DA42MPP": 6,
    "MD Helicopters MD 900 Explorer": 2,
    "Boeing 757-2M6": 2,
    "Bombardier CRJ-700": 1,
    "Avro Lancaster B1": 1,
    "Boeing C-40A": 6,
    "Embraer 121 Xingu AA": 1,
    "Boeing 737-286(A)": 2,
    "Eurocopter EC135 P2+": 6,
    "Airbus ACJ319-133X": 6,
    "Dassault Falcon 7X": 13,
    "Airbus A400M-180": 4,
    "BAe 146-200 C3": 2,
    "Bell 206B": 1,
    "Airbus Helicopters H145": 12,
    "Diamond Aircraft DA62": 1,
    "A310 304": 4,
    "Avro 146-RJ100": 2,
    "Airbus ACJ319-115X": 6,
    "Boeing 747 Supertanker": 1,
    "Pilatus PC-9M": 1,
    "Airbus A330-223": 1,
    "Airbus ACJ319-132": 2,
    "Pananvia Tornado": 1,
    "Boeing 727-30": 2,
    "Bombardier Challenger 870": 2,
    "AgustaWestland EH 101 Merlin HC4": 4,
    "Boeing 707 3L6C": 1,
    "Boeing P-8A Poseidon MRA Mk.1": 3,
    "AgustaWestland EH 101 Merlin HC3i": 3,
    "Eurocopter EC135 P1": 5,
    "Pilatus PC-21": 2,
    "Boeing 747-4F6": 2,
    "Dassault Falcon 20E": 3,
    "Ilyushin IL-96300": 6,
    "Boeing 727 2S2F": 2,
    "Antonov An-26 B": 2,
    "Boeing KC-767A": 3,
    "Boeing 787-8": 2,
    "Agusta Westland A109S": 1,
    "Boeing 777-236": 2,
    "DHC1 Chipmunk T10": 2,
    "Dassault Falcon 20F": 1,
    "Britten-Norman BN-2T Islander CC2B": 1,
    "Boeing 737-NG7E0BBJ": 2,
    "Embraer EMB-190STD": 2,
    "Pitts Special S-2SE": 1,
    "Lockheed MC-130J": 1,
    "Supermarine Spitfire PR.XI": 1,
    "Boeing 747-SP21": 1,
    "Bombardier CC-144C": 1,
    "Cessna 750": 2,
    "Airbus A310-308": 2,
    "Airbus A319-115CJ": 1,
    "Lockheed MC-130": 1,
    "Eurocopter AS365": 2,
    "Airbus A310-304": 5,
    "Falcon 2000EX": 2,
    "Boeing 737-600BBJ": 1,
    "Sea Fury FB11": 1,
    "Bell 429": 1,
    "Boeing 737-NG9BQBBJ3": 2,
    "Boeing C-40B": 1,
    "CH-53G Stallion": 36,
    "Boeing 747-8Z5": 2,
    "Boeing 747-8JKBBJ": 2,
    "Ilyushin IL-96VVIP": 2,
    "Dassault Falcon 900B": 6,
    "Boeing 747-8KBBBJ": 4,
    "Diamond Aircraft DA42M-NG Guardian": 1,
    "Eurocopter EC135 T2+": 4,
    "Airbus ACJ321-231": 1,
    "Gates Learjet C-21A": 1,
    "Beechcraft Corp King Air Avenger T.1": 4,
    "Boeing 757-223": 2,
    "Grob G-120 TP-A": 1,
    "Boeing 737-in NG7FBBBJW": 2,
    "Boeing 707-138B": 2,
    "Tupolev Tu-134A-3": 4,
    "Dassault Falcon 20D": 4,
    "Avionsde Transport Regional ATR72600": 4,
    "Beech 300 Super King Air 350": 3,
    "Dassault Mystere Falcon 900": 2,
    "Dassault Falcon 8X": 3,
    "BAe Hawk T2": 19,
    "Diamond Aircraft DA62MPP": 5,
    "Boeing 737-NG8KNWBBJ2": 2,
    "Airbus A400M": 16,
    "AgustaWestland Wildcat AH.1": 6,
    "A310 304F": 1,
    "Douglas DC-10 KDC-10": 1,
    "Global 6000": 3,
    "Boeing-Vertol Chinook HC.6": 2,
    "Airbus A310-304F": 1,
    "Airbus ACJA340-642X": 2,
    "Typhoon": 14,
    "Boeing 747-433SCD": 2,
    "Cessna 208 B": 7,
    "Leonardo AW169": 1,
    "Boeing 747-48E(M)": 2,
    "Boeing 747-4J6": 2,
    "Dassault Falcon 900": 1,
    "Airbus KC-30M": 1,
    "Cessna T206H Turbo Stationair": 15,
    "Airbus A340-313": 2,
    "Bombardier BD-700 Global 6000": 3,
    "Unknown": 1,
    "Beechcraft Corp MC-12S Liberty": 1,
    "Boeing 76732LER": 2,
    "Bombardier Learjet 45 XR": 1,
    "Airbus A320-232": 10,
    "EuroHawk RQ-4B": 2,
    "Tornado IDS": 105,
    "Bo.105 M": 2,
    "Agusta Westland AW109SP": 1
  },

operator

  "operator": {
    "Polizei Rheinland-Pfalz": 1,
    "DEA": 12,
    "Air Affairs Australia": 1,
    "14 Squadron ISR (RAF)": 3,
    "Samaritans Purse": 1,
    "Government of Gambia": 4,
    "Guinea Ecuatorial Airlines": 2,
    "US Military": 5,
    "Government of Qatar": 2,
    "Otv Leasing (DOJ)": 5,
    "Libyan Air Force": 2,
    "Draken Europe": 15,
    "Shell Aviation Ltd": 1,
    "HRH Prince Awaleed Bin Talal": 2,
    "Bundespolizei": 2,
    "32 The Royal Squadron RAF": 1,
    "National Grid Electricity Transmission": 1,
    "The Red Arrows (RAF)": 14,
    "Government of Egypt": 1,
    "Devon Air Ambulance": 1,
    "Department Of Justice (DOJ)": 1,
    "Northrop Grumman Systems": 1,
    "Propshop": 1,
    "Catreus": 2,
    "651 Squadron (Joint Special Forces Aviation Wing)": 6,
    "Horizon Flight Training": 1,
    "Ebony Shine International (Equatorial Guinea)": 2,
    "Government of Kazakhstan": 6,
    "Yorkshire Air Ambulance": 1,
    "Lynden Air Cargo": 1,
    "Pixair Survey SAS": 1,
    "Las Vegas Sands Corp": 1,
    "Royal Air Force": 124,
    "Nbr Aviation (DOJ)": 3,
    "Comcast Corp": 1,
    "MChS Rossii": 4,
    "Volga-Dnepr Airlines": 3,
    "Leicester City Football Club": 1,
    "Airbus Transport International": 5,
    "Operator": 3,
    "The Children's Air Ambulance Service": 1,
    "Saudi Ministry of Finance": 18,
    "NATO": 15,
    "Air China": 4,
    "Government of Niger": 2,
    "Worldwide Aircraft Leasing (DOJ)": 4,
    "Government of Togo": 4,
    "Specialist Aviation Services Ltd": 1,
    "656 Squadron (Joint Special Forces Aviation Wing)": 1,
    "Aircraft Guaranty Corp Trustee": 1,
    "The SA Red Cross Mercy Service": 1,
    "659 Squadron (Joint Special Forces Aviation Wing)": 1,
    "Saudi Arabian Airlines": 2,
    "HM Coastguard (Reconnaissance Ventures Ltd)": 1,
    "Gaseosas Posada Tobon SA Postobon SA": 1,
    "Vulkan Air": 1,
    "Calspan Corporation": 1,
    "Great Western Air Ambulance": 1,
    "Kqm Aviation (DOJ)": 6,
    "Historic Aircraft Flight Trust": 1,
    "US Department of Energy": 7,
    "Iceland Frozen Foods": 1,
    "Timpson Ltd": 1,
    "Welsh Air Ambulance": 2,
    "DRF Luftrettung": 3,
    "Transferred to MOD": 1,
    "Bahrain Defence Force": 8,
    "Red Bull Matadors": 1,
    "2 Excel Aviation (Broadsword)": 8,
    "Private Owner": 2,
    "Government of Jordan": 4,
    "Psl Surveys (DOJ)": 4,
    "Government of Slovakia": 1,
    "Honeywell International Inc": 1,
    "Cobham Flight Inspection": 1,
    "Pans UK Holdings Ltd": 1,
    "Dorset and Somerset Air Ambulance": 1,
    "Polaris Aviation Solutions": 1,
    "Fvx Research (DOJ)": 4,
    "Ortac AOC Ltd": 1,
    "Volantair LP Inc": 1,
    "Antonov Airlines": 3,
    "Russian FSB": 2,
    "Private": 9,
    "Conviasa/ Venezuelan Government": 2,
    "Osni Sawiris": 1,
    "AirTanker": 4,
    "Polizei Hessen": 2,
    "Government of Democratic Republic of Congo": 6,
    "NOR Leasing (Police)": 2,
    "QinetiQ": 1,
    "Aerographics (DOJ)": 1,
    "Britten-Norman Aircraft Ltd": 1,
    "Rada Airlines": 1,
    "ALTO Aerospace Ltd": 1,
    "Gen Haftar (Libya)": 2,
    "Hungarian Air Force": 2,
    "Wiltshire Air Ambulance": 1,
    "Ruby Star Airways": 1,
    "Government of Fujairah": 2,
    "Kuwait Air Force": 2,
    "Acrobat Ltd": 1,
    "Ceiba Intercontinental": 2,
    "Mint Juleps Investments (Azerbajan)": 2,
    "Royal Canadian Air Force": 2,
    "657 Squadron (Joint Special Forces Aviation Wing)": 1,
    "Total Helicopters Unlimited (DOJ)": 1,
    "Private (Gambia)": 2,
    "The Flying Bulls": 1,
    "Ng Research (DOJ)": 4,
    "Kingdom Holding( King Abdullah)": 2,
    "736 Naval Air Squadron": 4,
    "Government of Libya": 4,
    "655 Squadron (Joint Special Forces Aviation Wing)": 1,
    "Battle of Britiain Memorial Flight": 12,
    "Abu Dhabi Amiri Flight": 16,
    "Luxembourg Air Ambulance": 1,
    "Belgian Air Component": 1,
    "Sbs Prgm Ofc (DOJ)": 1,
    "RVL Aviation Ltd": 5,
    "Hellenic Air Force": 2,
    "Jeal Air (DOJ)": 1,
    "Government of Equatorial Guinea": 4,
    "Multinational MRTT Fleet": 1,
    "Worldwide Aircraft Holding (Turkey)": 2,
    "Belgian Air Force": 1,
    "Volkswagen Air Service GmbH": 10,
    "Meridian": 1,
    "Israeli Air Force": 4,
    "Sharjah Rulers Flight": 4,
    "Western Power Distribution": 5,
    "652 Squadron (Joint Special Forces Aviation Wing)": 1,
    "National Aircraft Leasing (DOJ)": 18,
    "Cavok Air": 2,
    "Oman Royal Flight": 14,
    "Scottish Air Ambulance Service": 1,
    "Army Air Corps": 13,
    "Nby Productions (DOJ)": 5,
    "United States Air Force": 40,
    "Royal Navy Fleet Air Arm": 6,
    "Rich Goodwin": 1,
    "Gulfstream Aerospace Corp": 1,
    "Hillwood Airways": 1,
    "Boultbee Aviation": 1,
    "Airgo Flugservice": 2,
    "Rkt Productions (DOJ)": 4,
    "United States Army": 4,
    "DJT Operations": 2,
    "Gov of NL Royal Fam Jet": 1,
    "Skydive UK": 1,
    "Government of Belarus": 6,
    "French Navy": 11,
    "Gulfstream Aerospace LP": 1,
    "Saudi Private FLITE Charters": 2,
    "Czech Air Force": 2,
    "ADAC Luftrettung": 1,
    "LS Aircraft Limited": 1,
    "Goverment of Qatar": 2,
    "Fly Navy Heritage Trust": 3,
    "Kazakhstan Border Guards": 2,
    "Petroleos De Venezuela SA": 2,
    "Sudanese Police Air Wing": 2,
    "National Aircraft Leasing Corporation (DOJ)": 2,
    "German Air Force": 578,
    "Pxw Services (DOJ)": 5,
    "Government of Turkmenistan": 6,
    "Areus Trilogy LLC": 1,
    "Thales UK Ltd": 1,
    "Guinea Ecuatorial Aire Lines SA": 2,
    "Elstree Ink": 1,
    "United Parcel Service (UPS)": 2,
    "Aero Lease UK (Police)": 1,
    "RAF Centre of Aviation Medicine / Qinetiq": 1,
    "Hawker Hunter Aviation": 1,
    "DFS Furniture Company": 1,
    "Oyonnair": 1,
    "Defense Helicopter Flying School": 8,
    "Lcb Leasing (DOJ)": 3,
    "Government of Algeria": 16,
    "The Blades": 5,
    "Russian Air Force": 2,
    "Servicio Autonomo de Coordinacion de Transporte Aereo": 2,
    "SW Business Aviation (Azerbajan)": 8,
    "London Air Ambulance": 1,
    "Royal Netherlands Air Force": 3,
    "Venezuelan Air Force": 4,
    "Government of Chad": 4,
    "Saudi Armed Forces Medical Services": 4,
    "Nassef Sawiris": 1,
    "Air Koryo": 2,
    "Thales UK": 3,
    "Venezuela Air Force": 4,
    "Emirates Airline": 2,
    "HM Coastguard": 7,
    "Syrianair": 2,
    "JC Bamford Excavators": 1,
    "2 Excel Aviation": 6,
    "Gama Aviation (UK) Ltd": 4,
    "Summit Air": 2,
    "35 The Royal Squadron RAF": 1,
    "36 The Royal Squadron RAF": 1,
    "Eleron": 1,
    "National Police Air Service": 24,
    "654 Squadron (Joint Special Forces Aviation Wing)": 1,
    "JMI Aviation Management Ltd": 1,
    "CEIBA Cargo": 2,
    "Italian Air Force": 8,
    "Qatar Executive": 4,
    "Swiss Air Ambulance AG": 1,
    "US National Nuclear Security Administration": 5,
    "Royal Navy": 44,
    "Skyborne Aviation": 1,
    "Empire Test Pilots School": 7,
    "Babcock MCS Onshore": 1,
    "Johnson & Johnson": 2,
    "Northwest Aircraft Leasing (DOJ)": 1,
    "Bahrain Amiri Flight": 12,
    "Government of Iran": 2,
    "AgustaWestland AW101 AEW2 'Crowsnest'": 1,
    "Conviasa": 4,
    "UK Border Force": 1,
    "Flight Calibration Services": 2,
    "Dubai Air Wing": 26,
    "Martin Baker Aircraft": 1,
    "Douane (French Customs)": 1,
    "Cornwall Air Ambulance": 1,
    "Irish Air Corps": 4,
    "NASA": 8,
    "The Queens Helicopter flight ": 3,
    "Government of Kuwait": 26,
    "US Govt Air Force 1": 2,
    "Northern Ireland Air Ambulance": 1,
    "Us Dept Of Justice (DOJ)": 1,
    "653 Squadron (Joint Special Forces Aviation Wing)": 1,
    "Brown Helicopter (DOJ)": 1,
    "Government of Azerbaijan": 6,
    "Meraj Airlines": 6,
    "French Air Force": 18,
    "33 The Royal Squadron RAF": 1,
    "DT Endeavour": 2,
    "Obr Leasing (DOJ)": 7,
    "BMW": 1,
    "US Army": 6,
    "Qatar Amiri Flight": 28,
    "Ecuadorean Air Force": 1,
    "United States Navy": 6,
    "Petroleos de Venezuela SA": 28,
    "Government of Gabon": 10,
    "Air Zimbabwe": 4,
    "BN2T Islander CC2": 1,
    "34 The Royal Squadron RAF": 1,
    "Government of Angola": 4,
    "Russia State Transport Company": 34,
    "Essar Shipping and Logistics Ltd": 1,
    "Latitude Air Ambulance": 1,
    "660 Squadron (Joint Special Forces Aviation Wing)": 1,
    "Global Supertanker Service": 1,
    "United States Department Of Justice (DOJ)": 4,
    "Government of Cameroon": 2,
    "Government of Saudi Arabia": 12
  },

tag2

    "Bizjet": 14,
    "You Aint Seen Me Right": 36,
    "#$Tag2": 1,
    "I am old": 2,
    "mmm Neutrons": 5,
    "Wocka Wocka": 13,
    "One Ping Only Vasily": 3,
    "Adama Barrow": 6,
    "Sovereignty Council": 2,
    "Fighter": 1,
    "Ooh Get You": 9,
    "Absolute Unit": 3,
    "Sheikh Nawaf al-Ahmad al-Sabah": 26,
    "Where Is The Engine": 1,
    "Private Airline": 4,
    "Not so VIP": 4,
    "Abdelmadjid Tebboune": 16,
    "Flying Brick": 3,
    "Speak Up Sonny": 20,
    "Abdullah II bin Al-Hussein": 4,
    "Not A Bus": 4,
    "You Lost Mate": 1,
    "Hamad bin Isa Al Khalifa": 20,
    "Boris": 1,
    "Xi Jinping": 4,
    "Alexander Lukashenko": 6,
    "#$Tag 2": 2,
    "Bashar al-Assad": 2,
    "Tamim bin Hamad Al Thani": 32,
    "Brrrrrrrrrrrrrrr": 13,
    "Not a bus": 21,
    "Government": 2,
    "Choppa": 5,
    "Culture Beat": 1,
    "Rashid Al Maktoum": 26,
    "Pass The Sick Bag": 31,
    "Kim Jong-un": 2,
    "Ali Bongo Ondimba": 10,
    "Vladimir Putin": 42,
    "Eye in the sky": 2,
    "Not A Car": 1,
    "Old": 8,
    "Jump Johnny Jump": 2,
    "Whoosh": 1,
    "Loooong Raaaaaange": 2,
    "Chonky Boy": 20,
    "Measuring Stick": 2,
    "Gurbanguly Berdimuhamedow": 6,
    "Shiny": 4,
    "Must Be Nice": 12,
    "Heavy Duty": 41,
    "F\u00e9lix Tshisekedi": 6,
    "I Feel The Need....": 22,
    "Kung Fu Grip": 2,
    "Idriss D\u00e9by": 4,
    "Danger Zone": 266,
    "Office In The Sky": 1,
    "Agostinho Neto": 4,
    "Open Skies": 15,
    "State Dept": 2,
    "Jesus He Knows Me": 2,
    "Eye In The Sky": 125,
    "Whirly Bird": 19,
    "Recep Tayyip Erdo\u011fan": 2,
    "Original Nuttah": 4,
    "Chopper": 143,
    "Id Get That Seen Too": 30,
    "You Came Here In That Thing": 2,
    "Digger": 1,
    "Target Practice": 15,
    "Mahamadou Issoufou": 2,
    "Big Bird": 5,
    "Nicol\u00e1s Maduro": 46,
    "Sale Must End Soon": 1,
    "Covert": 1,
    "Is This My Good Side": 2,
    "Vanity Plate": 1,
    "Wrong Turn At Albuquerque": 2,
    "Old Stuff": 108,
    "Mohammed Al Sharqi": 2,
    "Billy Murphy": 4,
    "Fill Her Up": 6,
    "Dictator Alert": 4,
    "Foutje Bedankt": 5,
    "Ooh La La": 18,
    "Air Ambo": 17,
    "Police Squad": 25,
    "Kassym-Jomart Tokayev": 8,
    "Flying Rust Bucket": 3,
    "Hot Hot Hot Hot": 1,
    "VIP": 26,
    "Vashe Zdorovye": 11,
    "Ilham Aliyev": 16,
    "Teodoro Obiang Nguema Mbasogo": 14,
    "Cargo": 16,
    "Specialist": 5,
    "General Hafar": 2,
    "Turn and Burn": 14,
    "Ali Khamenei": 8,
    "Khalifa Al Nahyan": 16,
    "Paul Biya": 2,
    "Faure Gnassingb\u00e9": 4,
    "Its The End Of The World And I Know It": 2,
    "U Wot m8": 12,
    "How Does It Fly": 13,
    "Red Carpet": 8,
    "Ou Sont Les Bagages": 9,
    "Mohammed bin Salman": 38,
    "Mae West": 7,
    "Cool": 1,
    "Dieselgate": 10,
    "Mohammed bin Rashid Al Maktoum": 6,
    "I Thought You Was A Pilot Not An Astronaut": 7,
    "Tiger Tokens": 15,
    "Do A Barrel Roll": 29,
    "Emmerson Mnangagwa": 4,
    "All About That Wingspan": 7,
    "Odd": 1,
    "Abdul Hamid Dbeibeh": 6,
    "Haitham bin Tarik": 14
  },

tag

    "Bizjet": 40,
    "You Aint Seen Me Right": 5,
    "L-Plate": 24,
    "We Make Your Planes Better": 3,
    "mmm Neutrons": 2,
    "One Ping Only Vasily": 24,
    "Fighter": 46,
    "Ooh Get You": 8,
    "Training Wheels": 2,
    "Magic Roundabout": 1,
    "How Much": 3,
    "Absolute Unit": 25,
    "Vive La France": 24,
    "War Bird": 3,
    "Zoomies": 133,
    "$Tag": 1,
    "US Dept Of Justice": 86,
    "M*A*S*H": 24,
    "Nasa": 8,
    "Ciao": 8,
    "Government": 14,
    "Choppa": 17,
    "Culture Beat": 1,
    "Pass The Sick Bag": 1,
    "Wheelbarrow": 1,
    "#$Tag 1": 2,
    "USAF": 6,
    "Hungarian Air Force": 2,
    "Old": 9,
    "Luck Of The Irish": 1,
    "Whoosh": 1,
    "Chonky Boy": 1,
    "Measuring Stick": 1,
    "Skydive": 3,
    "Hellenic Air Force": 2,
    "Shiny": 1,
    "Tomahawk": 12,
    "Must Be Nice": 2,
    "History": 13,
    "Fire": 2,
    "Freeze": 2,
    "Jesus He Knows Me": 1,
    "Orange Danger": 4,
    "Eye In The Sky": 76,
    "Czech Air Force": 2,
    "Original Nuttah": 1,
    "Chopper": 23,
    "Got It Where It Counts": 2,
    "You Came Here In That Thing": 12,
    "UAV": 1,
    "Waffles": 1,
    "Big Bird": 1,
    "Quarterback": 1,
    "Covert": 24,
    "Wrong Turn At Albuquerque": 1,
    "Luftwaffe": 441,
    "Fill Her Up": 15,
    "Dictator Alert": 406,
    "Tag1": 1,
    "Hiiiiiigh In The Sky": 6,
    "Foutje Bedankt": 1,
    "Air Ambo": 1,
    "Police Squad": 2,
    "N.A.T.O": 15,
    "Vashe Zdorovye": 2,
    "Jumpers For Goalposts": 1,
    "Top..ish Gun": 4,
    "Cargo": 33,
    "Specialist": 29,
    "Ere Me Now": 4,
    "Yes Maam": 8,
    "UFO": 1,
    "Wrong Turn at Albuquerque": 2,
    "U Wot m8": 14,
    "Luck of the Irish": 3,
    "How Does It Fly": 7,
    "Ou Sont Les Bagages": 4,
    "CIA": 2,
    "Yorkshire": 1,
    "Wichita Lineman": 6,
    "Cool": 1,
    "Do A Barrel Roll": 21,
    "All About That Wingspan": 1,
    "Odd": 2
  }
}

The main database contains duplicate registration numbers

Describe the bug

The main database contains the following duplicate registration numbers:

duplicate_regs.csv

Expected behaviour

I would suspect that the registration numbers are unique.

Screenshots / Live demo link

No response

Additional context

We can uncomment the following line if it is fixed:

plane-alert-db/scripts/check_main_databases.py

Lines 153 to 155 in 8449559

	# contains_duplicate_regs(
	# main_df
	# ) # NOTE: This is commented out because there are duplicates.

Owner not correct - how to update?

I'm not sure if this is the right way but I couldn't find any information what the procedure is for updating the files.

I've noticed the owner details for N455DG is out of date - listed as Walmart however the following sites lists TVPX Aircraft Solutions Inc trustee:

https://registry.faa.gov/aircraftinquiry/Search/NNumberResult?NNumberTxt=455DG
https://www.aviationdb.com/Aviation/Aircraft/4/N455DG.shtm
https://aircraftforsale.com/registration/N455DG

Create database modify check action

Is your feature request related to a problem? Please describe.

Currently when people add derivative databases maintainers only see this by looking at the files that are changed.

Describe the solution you'd like

We could make a small GitHub action that checks the changes and fails if users change derivative files and then comments on the pull request.

Describe alternatives you've considered

No response

Additional context

No response

nuclear sniffing helicopters

Yeah, nice subject line eh? I don't want to set everything up to add these to the DB, but N411DE and N412DE are handy helos to put on a list.

https://www.thedrive.com/the-war-zone/33817/nuke-sniffing-helicopter-flies-around-washington-amid-protests
https://arstechnica.com/science/2021/10/nuclear-security-helicopter-scours-boston-marathon-route-for-radiation/

https://twitter.com/ripcitybitch1/status/1323507479599222785
https://twitter.com/1crazyarchitect/status/1323325216798420994
https://twitter.com/markwclancy/status/1446489893593616386
https://twitter.com/jason_paladino/status/1323383020297048064
https://twitter.com/InTheSkyDC/status/1389658747757338624
https://twitter.com/SkyCirclesDC/status/1365419734276001792

Add lookerstudio visualization for all main databases

Is your feature request related to a problem? Please describe.

Currently, https://lookerstudio.google.com/u/0/reporting/eb19ab53-b622-4946-b34a-9667232c136d/page/4taCC contains a visualization dashboard for the plane-alert-db.csv database. Looks like the dashboard was added in a0c3dd8 by @Sportsbadger.

Describe the solution you'd like

I think it would be nice also to include such a dashboard for the:

• https://github.com/sdr-enthusiasts/plane-alert-db/blob/main/plane-alert-twitter-blocked-images.csv
• https://github.com/sdr-enthusiasts/plane-alert-db/blob/main/plane-alert-ukraine-images.csv

or include these results in the already existing dashboard by generating a plane-alert-db-extended.csv file.

Additions

Is your feature request related to a problem? Please describe.

Would like to see the below added. Types should be self-explanatory given the owner name

#ICAO,tail,owner,plane type
C006E1,C-FCPS,Calgary Police Service,Eurocopter AS 350B3 Ecureuil
C01751,C-FIVO,Calgary Police Service,Eurocopter AS 350B3 Ecureuil

#ICAO,tail,owner,plane type
C06047,C-GKLY,STARS - Shock Trauma Air Rescue Service,Airbus MBB-BK117 D-2
C01D49,C-FLCI,STARS - Shock Trauma Air Rescue Service,Airbus MBB-BK117 D-3
C062E5,C-GLLS,STARS - Shock Trauma Air Rescue Service,Airbus MBB-BK117 D-2
C0539D,C-GFRG,STARS - Shock Trauma Air Rescue Service,Airbus MBB-BK117 D-2
C0807D,C-GWRC,STARS - Shock Trauma Air Rescue Service,Airbus MBB-BK117 D-3
C009B6,C-FDRP,STARS - Shock Trauma Air Rescue Service,Airbus MBB-BK117 D-3
C023EE,C-FNPT,STARS - Shock Trauma Air Rescue Service,Airbus MBB-BK117 D-3
C015B2,C-FIFP,STARS - Shock Trauma Air Rescue Service,Airbus MBB-BK117 D-3
C01E69,C-FLNK,STARS - Shock Trauma Air Rescue Service,Airbus MBB-BK117 D-3

Images:

#ICAO,tail,image url
C006E1,C-FCPS,https://cdn.jetphotos.com/full/6/429883_1700272846.jpg
C01751,C-FIVO,https://cdn.jetphotos.com/full/6/93437_1616379982.jpg
C06047,C-GKLY,https://cdn.jetphotos.com/full/6/38921_1620314873.jpg
C01D49,C-FLCI,https://cdn.jetphotos.com/full/5/32029_1555460597.jpg
C062E5,C-GLLS,https://cdn.jetphotos.com/full/6/45460_1573527206.jpg
C0807D,C-GWRC,https://cdn.jetphotos.com/full/6/46074_1632019861.jpg
C009B6,C-FDRP,https://cdn.jetphotos.com/full/5/55843_1657812325.jpg
C01E69,C-FLNK,https://cdn.jetphotos.com/full/5/624947_1717618483.jpg

Couldn't find usable images for 3 of the STARS aircraft.

Describe the solution you'd like

No response

Describe alternatives you've considered

No response

Additional context

No response

Pull images automatically from Planespotters

Is your feature request related to a problem? Please describe.

Currently, we rely on volunteers to add the plane images.

Describe the solution you'd like

As pointed out by @dziban303 this can be automated to be pulled from planespotters instead (see https://github.com/ggoodloff/AnyFlightTracker).

Describe alternatives you've considered

No response

Additional context

No response