During a chat in the ADSB Exchange (ADSBx) Discord, the topic of being able to filter and save lists of certain aircraft came up. Additionally, a separate topic about how to use the filtering options to see exactly what you want. It spurred the idea of creating a Github to reuse some of those links, and a space to store them all as the list grows!
If you want to add your own links, click this link to get to our "How To" section
- Type code filters (modifications of what's found on the Map Help page.)
- More cool links (with your help!)
- FAQ
- Continual maintenance to make sure lists are accurate and updated.
| Country | State | Description | Link |
|---|---|---|---|
| Russia, China, Japan, NATO Nations | Worldwide | Intelligence Aircraft | Link |
| USA | Worldwide | Flights typically associated with embassies | Link |
| USA | Various | Ladies and Gentlement, the B-52s. | Link |
| USA | Federal | Nuclear-powered aircraft. Just kidding, aircraft with nuclear energy support missions (Department Of Energy, NNSA, etc.) | Link |
| USA | CA | California Forestry (CalFire) | Link |
| USA | GA | Georgia Department of Public Safety Georgia State Patrol Georgia Capitol Police |
Link |
| USA | Federal | NASA | Link |
| USA & Canada | Various | REAL METROLINER HOURS | Link |
| USA, Mexico, Canada | Multi | Law Enforcement Aircraft | Link |
| World | Various | Air Ambulances / Life Flights | Link |
| World | United Nations | Flights associated with the United Nations | Link |
Easy! You can add them yourself, or, join the Discord and someone will probably make it for you if you ask nicely. Maybe.
This will require some Excel knowledge, some may call it witchcraft. I will include some links about the formulas needed below. If you don't have Excel, or aren't using an OS that supports Excel, you'll need some spreadsheet software that supports some version of TEXTJOINor CONCATENATE/CONCAT.
If you're using a newer version of Excel, you may have access to CONCAT, which you should use if you don't care about backwards compatibility. You can also use TEXTJOIN because that will allow you to add the delimiters as needed. I'm using TEXTJOIN for this example.
This will include all available data the FAA can provide for US-registered aircraft. It will not include military aircraft or LADD-tagged registrations. Feel free to contribute your own aircraft links -- LADD-tagged, outside of the US, military aircraft, etc. are all welcome. Note: You can also use @sdr-enthusiasts's lists if you follow the Open Data Commons Open Database License (the same license as this repo)
Step 1: Download the FAA's Aircraft Registration information from their website. This information is updated nightly so it may be helpful to always download a fresh copy.
Step 2: Extract all of the files, and then edit the MASTER.txt file extension to MASTER.csv. Here's a link on how to do that for Windows 10/11 and macOS. You may not need to rename it, you may be able to open it directly in Excel. Mine was being a little wonky, so I put both in here.
Step 3: Fire up Excel, and filter/sort how you want the information. For this example, let's say we want to see all of the aircraft owned by the Georgia Department of Public Safety (GDPS). Note: You may get a popup where Excel asks you about whether or not you want to perform the typical stuff Excel does when you open a .CSV (remove trailing zeros, scientific notation, convert date strings to dates, etc.) Don't do this. Leave the file as is.
Step 4: This part is where you get to have a little "fun", if there's something wrong with you (like me). You determine how to filter the data. For our current example in the previous step, I'm going to:
- Filter by state
Column KakaSTATE - Filter by the text string "Public Safety" in
Column GakaNAME
Step 5: The data you're looking for is in Column AH or the column title MODE S CODE HEX
Step 6:
For All Formulas:
Use TRIM to clear out any leading/trailing spaces. More about TRIM here.
Using TEXTJOIN (easiest):
- Create a new tab (you don't have to do this, but it's my personal preference).
- In
A1on the new tab, enter=TEXTJOIN(",",CELL1,CELL2,CELL3,CELL4). Note:CELL1,CELL2,etc..are going to be the individual cells of theTRIMfunction column on theMastertab. You can select them by clicking and holdingCTRLon your keyboard. If you use theSHIFTkey the formula won't work.
Formula Example - you'll see I ran the TRIM function in a new column, AI
=TEXTJOIN(",",TRUE,MASTER!AI51669,MASTER!AI113794,MASTER!AI131955,MASTER!AI266486,MASTER!AI266751,MASTER!AI267358,MASTER!AI273801,MASTER!AI273151,MASTER!AI274129,MASTER!AI274802,MASTER!AI276002,MASTER!AI293305)
Using CONCATENATE/ CONCAT (more time-intensive):
- Create a new tab (you don't have to do this, but it's my personal preference).
- In
A1on the new tab, enter a single comma, - In
B2, enter=CONCAT(A1,CELL1,A1,CELL2,A1,CELL3)Note:CELL1,CELL2,etc..are going to be the individual cells of theTRIMfunction column on theMastertab. You can select them by clicking and holdingCTRLon your keyboard. If you use theSHIFTkey the formula won't work.
Formula Example - note the need to add A1 after every variable.
=CONCAT(MASTER!AI$51669,A4,MASTER!AI$113794,A4,MASTER!AI$131955,A4,MASTER!AI$266486,A4,MASTER!AI$266751,A4,MASTER!AI$267358,A4,MASTER!AI$273801,A4,MASTER!AI$273151,A4,MASTER!AI$274129,A4,MASTER!AI$274802,A4,MASTER!AI$276002,A4,MASTER!AI$293305)
Note: You can use this data for any site that supports this structure, but since I hang out with ADSBx geeks, I'm using ADSBx links. All you'd need to change is your base URL.
Using the output of this formulas, simply append them to the ADSBx base URL: https://globe.adsbexchange.com/?icao=
Example:
https://globe.adsbexchange.com/?icao=A208D5,A4DB92,A5B045,AC835D,AC8714,AC8E82,ACCEA4,ACC736,ACD25B,ACD9C9,ACE747,ADD775
Shoutout to the Folks at @sdr-enthusiasts for letting me play with their Planefence DB to get cool data out.