Repository files navigation

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 theMap Help page.)
• More cool links (with your help!)
• FAQ
• Continual maintenance to make sure lists are accurate and updated.

Easy! You can add them yourself, or, join the Discord and someone willprobably 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 ofTEXTJOINorCONCATENATE/CONCAT.

• More aboutTEXTJOINhere
• More aboutCONCATENATE/CONCAThere

If you're using a newer version of Excel, you may have access toCONCAT, which you should use if you don't care about backwards compatibility. You can also useTEXTJOIN because that will allow you to add the delimiters as needed. I'm usingTEXTJOIN 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 theirwebsite. 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 theMASTER.txt file extension toMASTER.csv. Here's a link on how to do that forWindows 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, andfilter/sort how you want the information. For this example, let's say we want to see all of the aircraft owned by theGeorgia 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 stateColumn K akaSTATE
• Filter by the text string "Public Safety" inColumn G akaNAME

Step 5: The data you're looking for is inColumn AH or the column titleMODE S CODE HEX

Step 6:For All Formulas:UseTRIM to clear out any leading/trailing spaces. More aboutTRIMhere.

UsingTEXTJOIN (easiest):

1. Create a new tab (you don't have to do this, but it's my personal preference).
2. InA1 on the new tab, enter=TEXTJOIN(",",CELL1,CELL2,CELL3,CELL4).Note:CELL1,CELL2,etc.. are going to be the individual cells of theTRIM function column on theMaster tab. You can select them by clicking and holdingCTRL on your keyboard. If you use theSHIFT key the formula won't work.

Formula Example - you'll see I ran theTRIM 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)

UsingCONCATENATE/CONCAT (more time-intensive):

1. Create a new tab (you don't have to do this, but it's my personal preference).
2. InA1 on the new tab, enter a single comma,
3. InB2, enter=CONCAT(A1,CELL1,A1,CELL2,A1,CELL3)Note:CELL1,CELL2,etc.. are going to be the individual cells of theTRIM function column on theMaster tab. You can select them by clicking and holdingCTRL on your keyboard. If you use theSHIFT key the formula won't work.

Formula Example - note the need to addA1 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 forany 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.