rikgale / vrsdata

VRSData

VRSData

VRSData

Data used in updates for https://github.com/sdr-enthusiasts/docker-virtualradarserver

.

vrsdata's Issues

A P-8

Man, been so long I forgot the format.

AE681F / Tactical / Boeing / P8 / Boeing P-8A Poseidon / United States Navy / CNV-P8A

This time it was 169567 as confirmed by a spotter when it landed—this aircraft has also used AE5F50 in the past, which is already in the database. So let's add AE681F as a tactical code.

A65946 / Louisiana State Police

03E35F / ???? / Northrop / Northrop F-5N Tiger II / United States Navy / CNV-F5

But wait, there's more!

#2023-04-03

ADFE6D / RCH-C130
AE6408 / RCH-T38

More Updates. Sorry to do this to you.

evil laughter

# 2023-02-24 cont.
AE4EB6 / CNV-P8A
AE06E4 / CNV-UC12
AE6272 / T-45C Goshawk / CNV-HAWK    # That's all I got on this guy
AE1146 / CNV-TEX2
AE1153 / CNV-TEX2
AE4A1C / CNV-TEX2
AE1E78 / CNV-TEX2
AE4EA5 / CNV-TEX2
AE4E94 / CNV-TEX2
AE61E2 / 761583 / Northrop / Northrop F-5N Tiger II / serial L1058 / United States Navy / CNV-F5
AE2BEF / CNV-H60
AE03E8 / CNV-C130T
AE5774 / serial BL-164 / built 2010
AE53FC / serial FL-388 / built 2003
AE53FB / serial FL-416 / built 2004
AE06DA / serial BU-06 
AE06D9 / serial BU-09
AE64C5 / USMC-V22
AE040B / USMC-KC130BOOM

AE07BC / built 1963 / RCH-KC135BOOM
ADFE39 / RCH-C130
AE11E9 / RCH-E3TF
AE0111 / RCH-WC130J
AE0116 / RCH-WC130J
AE68B4 / RCH-C146
AE68B3 / RCH-C146
A790EC / United States Air Force / RCH-C21A  # owner has a typo
ADFCB7 / serial TT-88 / built 1994 / RCH-T1
ADFC61 / RCH-T1
ADFC65 / RCH-T1
ADFC79 / RCH-T1
ADFC7B / RCH-T1
ADFC89 / RCH-T1
ADFC8E / RCH-T1
ADFC8F / RCH-T1
ADFC90 / RCH-T1
ADFC9A / RCH-T1
ADFC9D / RCH-T1
ADFCA4 / RCH-T1
ADFCB1 / RCH-T1
ADFCC0 / RCH-T1
ADFCD2 / RCH-T1
ADFCD7 / RCH-T1
ADFCE0 / RCH-T1
ADFCE2 / RCH-T1
ADFD0E / RCH-T1
ADFE68 / RCH-C130
ADFE88 / RCH-C130
ADFDB9 / RCH-C130
ADFDBA / RCH-C130
ADFDC0 / RCH-C130
ADFDC8 / RCH-C130
ADFEA0 / RCH-C130
ADFDDE / RCH-C130
ADFDE0 / RCH-C130
ADFEA9 / RCH-C130
ADFF95 / RCH-T38
ADFFC9 / RCH-T38
ADFFDA / RCH-T38
AE0090 / RCH-T38
AE003D / RCH-T38
AE00A0 / RCH-T38
AE0033 / RCH-T38
AE0035 / RCH-T38
ADFF60 / RCH-T38
ADFF5F / RCH-T38
AE0366 / RCH-KC135BOOM
AE04BE / RCH-KC135BOOM
AE04CD / RCH-KC135BOOM
AE07BC / RCH-KC135BOOM
AE54D8 / RCH-MC130J 
AE54D8 / RCH-MC130J 
AE04A1 / RCH-C30J
AE0246 / RCH-C30J
AE29DB / RCH-C30J
AE1443 / RCH-C30J
AE1BEE / RCH-C30J
AE0258 / RCH-WC130J
AE0259 / RCH-WC130J
AE0563 / RCH-C5M
AE5F0B / RCH-C30J  # typo opcode
AE1441 / RCH-C30J  # typo opcode
AE1536 / RCH-C30J  # typo opcode
AE11D8 / RCH-E3TF  # typo opcode
AE07F5 / RCH-C17
AE29D8 / RCH-HC130J
AE4BE1 / RCH-HC130J
AE5B75 / RCH-U28
AE5B89 / RCH-U28
AE2F6B / RCH-MC12
AE2F73 / RCH-MC12
AE01F7 / RCH-TEX2
AE01FF / RCH-TEX2
AE0203 / RCH-TEX2
AE13B1 / RCH-TEX2
AE13C7 / RCH-TEX2
AE08A3 / RCH-TEX2
AE08A8 / RCH-TEX2
AE08AD / RCH-TEX2
AE08AE / RCH-TEX2
AE1118 / RCH-TEX2
AE13BA / RCH-TEX2
AE13BB / RCH-TEX2
AE112D / RCH-TEX2
AE112E / RCH-TEX2
AE1121 / RCH-TEX2
AE1117 / RCH-TEX2
AE08A1 / RCH-TEX2
AE08A9 / RCH-TEX2
AE08B2 / RCH-TEX2
AE10F6 / RCH-TEX2
AE10F9 / RCH-TEX2
AE10FA / RCH-TEX2
AE10FD / RCH-TEX2
AE110C / RCH-TEX2
AE1136 / RCH-TEX2
AE11AB / RCH-TEX2
AE0891 / RCH-TEX2
AE0890 / RCH-TEX2
AE0885 / RCH-TEX2
AE0882 / RCH-TEX2
AE0897 / RCH-TEX2
AE0883 / RCH-TEX2
AE088C / RCH-TEX2
AE140A / RCH-TEX2
AE11AC / RCH-TEX2
AE11AE / RCH-TEX2
AE11CC / RCH-TEX2
AE11CD / RCH-TEX2
AE13CB / RCH-TEX2
AE13FE / RCH-TEX2
AE141C / RCH-TEX2
AE174E / RCH-TEX2
AE11B4 / RCH-TEX2
AE1724 / RCH-TEX2
AE1726 / RCH-TEX2
AE172B / RCH-TEX2
AE173A / RCH-TEX2
AE173B / RCH-TEX2
AE173D / RCH-TEX2
AE1747 / RCH-TEX2
AE1E47 / RCH-TEX2
AE1E48 / RCH-TEX2
AE1E8C / RCH-TEX2
AE13CC / RCH-TEX2
AE13FF / RCH-TEX2
AE1402 / RCH-TEX2
AE1725 / RCH-TEX2
AE1E69 / RCH-TEX2
AE1EA1 / RCH-TEX2
AE1EA8 / RCH-TEX2
AE1EA9 / RCH-TEX2
AE1EAA / RCH-TEX2


AE291E / PAT-MC12
AE5622 / PAT-MC12
AE5775 / PAT-C12U
AE1F9D / PAT-UH72
AE1F9F / PAT-UH72
AE4DFF / USCG-H60
AE223C / USCG-CN35
AE223D / USCG-CN35
AE2237 / USCG-CN35
AE2666 / USCG-AS65
AE268F / USCG-AS65

0D088C / FAM-GLF5

AB7E6E / USDHS-B350  # yeah, department of homeland security flag doesn't exist yet 😉
A67C51 / USDHS-B350  # as above
A022E9 / USDHS-B350  # as above
AB1838 / USDHS-B350  # as above
AB2055 / USDHS-B350  # as above
AB7E6E / USDHS-B350  # as above

ABA4FE / FLC-CL60

AD337B / NASA-GLF5   # typo opcode
ACD5A1 / PreviousID 63-13503 / built 1963   # I thought the WB-57s were interesting enough to include their former military reg numbers under PreviousID
ACD958 / PreviousID 63-13295 / built 1964 / NASA-WB57
ACDD0F / PreviousID 63-13298 / built 1964 / NASA-WB57
AD120C / NASA  # No custom flag for the Super Guppy?
ACC30E / serial 66-8387 / built 1969 / NASA-T38
AD7754 / serial 65-10353 / built 1969 / NASA-T38
ACCA7C / serial 66-8355 / built 1966 / NASA-T38
AC77C7 / NASA-T38
AC7F35 / NASA-T38
AC8A5A / NASA-T38
AC91C8 / NASA-T38
ACAA6B / NASA-T38
ACB1D9 / NASA-T38
ACB590 / NASA-T38
ACCE33 / NASA-T38
AD4867 / NASA-T38
AD5743 / NASA-T38
AD5D53 / NASA-T38
AD610A / NASA-T38
AD739D / NASA-T38

Marten Day additions

# 2023-03-10
ADFED4 / PAT-C12U
AE4EAF / CNV-TEX2
AE14C5 / CNV-T44
AE6ABA / USMC-H53S
AE68AB / Boeing / Boeing P-8 Poseidon / United States Navy / P8 / CNV-P8A   # P-8 tactical
AE4EAF / CNV-TEX2
AE4E8D / CNV-TEX2
AE4E9D / CNV-TEX2
AE08B7 / 165962 / Raytheon Aircraft Company / Raytheon Aircraft Company T-6B Texan II / serial PT-105 / TEX2 / CNV-TEX2   # had this as a goshawk, oops
AE5B74 / PAT-U28  # typo'd as PAT-UC28 

---

# 2023-03-11
AE63D4 / RCH-T38
AE14A2 / RCH-T44
AE003C / RCH-T38
AE0046 / RCH-T38
AE56D9 / United States Army / PAT-H60

additions

AE14A7 / CNV-T44

doesn't look like this was added
AE7457 / 170041 / Boing / Boeing C-40A Clipper / United States Marine Corps / serial 30184 / year 2001 / USMC-C40

AE14BF / CNV-T44

AE2938 / ???? / Bell / Bell TH-1H Iroquois / United States Air Force / RCH-UH1
AE2939 / Bell / Bell TH-1H Iroquois / United States Air Force / serial 13635 / RCH-UH1
AE20BD / Bell / Bell TH-1H Iroquois / United States Air Force / RCH-UH1
AE20BF / 72-21484 / Bell / Bell TH-1H Iroquois / United States Air Force / serial 13183 / RCH-UH1

AE1849 / RCH-UH1
AE4BE9 / RCH-UH1
AE4BEA / Bell TH-1H Iroquois / United States Air Force / RCH-UH1
AE4BEB / Bell TH-1H Iroquois / United States Air Force / RCH-UH1
AE4BEC / Bell TH-1H Iroquois / United States Air Force / RCH-UH1

2023-05-19

2023-05-19
AE1E83 / CNV-TEX2
AE5A9F / reg ???? / Bell/Boeing / V22 / Bell/Boeing MV-22 Osprey / United States Marine Corps / USMC-V22   # not 100% on this, but say 99%. Based on speed and altitude, callsign used (STORM11, associated with VMX-1 and other Ospreys in the past), and SammySkycrafts who says it was previously reported as an MV-22
ADFC7E / RCH-T1
AE27A6 / RCH-E9A
AE5ECB / CNV-B06

2023-05-20
AE60EC / USMC-T34T

2023-05-21
AE5EC9 / CNV-B06
AE27A6 / RCH-E9A

ADFCBB / RCH-T1

AE0C6E / United States Army / PAT-H60
0AC8BD / FAC-E314    # super tucano, needs a side

Week 34 additions

ADFCBD / RCH-T1	
AE0EF9 / United States Army / PAT-H60
AE0C67 / United States Army / PAT-H60
AE4B33 / 161263 / Sikorsky / H53S / Sikorsky CH-53E Sea Stallion / 65435 / United States Marine Corps / USMC-H53S
AE1488 / RCH-E8C
Ae26a9 / USCG-AS65
AE5DFF / RCH-AC30J
AE27F6 / USCG-H60

2023-04-17

New F-5

AE61D0 / 761554 / Northrop / Northrop F-5N Tiger II / serial L1029 / United States Navy / CNV-F5
E8065E / serial 680-0045
AE4E90 / CNV-TEX2

C03177 / TOPACES
C08605 / TOPACES

2023-04-20 🚬

2023-04-20
AE5697 / United States Army / PAT-H60
ADFDBB / RCH-C130
A979B3 / FLC-BD30
A00001 / FLC
A5BEC0 / FLC
A029D9 / FLC
ADFCBF / RCH-T1
AE57C0 / CNV-P8

bad to the bOne

2023-05-26

AE6C01 / 86-0127 / Rockwell / B1 / Rockwell B-1B Lancer / United States Air Force / RCH-B1

2023-05-24

AE109A / reg 02   # reg should just be '02' rather than CG102
AE5F07 #  aircraft retired, became A8672F/N640W, replaced with AE109A above
AE61D7 / 761568 / Northrop / Northrop F-5N Tiger II / serial L1043 / United States Navy / CNV-F5
AE5EC6 / CNV-B06

2023-03-22/23

# 2023-03-22
AE112F / RCH-TEX2
AE113D / CNV-TEX2
AE4E9C / CNV-TEX2

# 2023-03-23
AE6836 / Tactical / Boeing / P8 / Boeing P-8 Poseidon / United States Navy / CNV-P8A

Week 35

ADFED3 / PAT-C12U
E8066C / FACH-C130
AE29CE / RCH-MC130J

I put in a request for a Chilean C-130 side on the radarspotting forum. I guess it'd be FACH-C130?

2023-04-16

2023-04-14
AE5C93 / RCH-C30J
AE6177 / United States Marine Corps # typo, says 'Corp', actually a lot of this typo in the db
AE4A1F / CNV-TEX2

---

😬

8 sept

AE58B7 / PAT-MC12
AE4864 / United States Army / PAT-H60
AE6911 / RCH-MC130J
AE5F14 / RCH-AC30J
AE0256 / RCH-C30J
AE73E7 / 170188 / AgustaWestland / A119 / AgustaWestland TH-73A Thrasher / United States Navy / CNV-A119
AE73ED / AgustaWestland / United States Marine Corps
AE73EE / 170195 / AgustaWestland / A119 / AgustaWestland TH-73A Thrasher / United States Marine Corps / CNV-A119
AE5EC0 / CNV-B06
AE093A / PAT-C560
AE14B8 / CNV-T44
AE1388 / RCH-C30J
AE5F14 / RCH-C30J
0D07D5 / ANX

These beech variants are such a mess.

ae73ed appears to be a USMC bird rather than Navy, dunno if you think it's worth making a side for these (probably not). Pretty limited imagery of this type that I can find.

2023-03-20

military

AE1EA6 / RCH-TEX2 
AE1E87 / RCH-TEX2
ADFCA5 / RCH-T1

AE2EE7 / CNV-TEX2 
AE2EE2 / CNV-TEX2
AE14B4 / CNV-T44

miscodes

AA9CAA / miscode for AA9CCA

other

AC9AD6 / Air Med Services # currently operator is set to Metro Aviation

2023-03-18

I think I had this one in the list a few days ago—13th is when I first saw him. Maybe it got lost in the clutter.

AE08BD / CNV-TEX2

2023-03-16

There will come a day when there are no new Texans to add. But it is not this day.

#2023-03-16
AE1E7E / CNV-TEX2
AE61BF / Northrop / F5 / Northrop F-5N Tiger II / United States Navy / CNV-F5
ADFEA4 / RCH-C130
AE4E91 / CNV-TEX2
AE1EC8 / CNV-TEX2
AE114B / CNV-TEX2
AAEA6E / USDHS

mid-august

AE0C7F / PAT-H60 / United States Army
AE4E90 / CNV-TEX2

AE0019 / 65-10473 / Northrop / T38 / Northrop T-38C Talon / serial N5892 / United States Air Force / RCH-T38

additions

# 2023-03-06
AE5B74 / RCH-U28 # mentioned in discord, already done

# 2023-03-07
AE5887 / 60-0041 / Boeing / Boeing B-52H Stratofortress / serial 464406 / United States Air Force / year 1960 / RCH-B52
AE5884 / 60-0034 / Boeing / B52 / Boeing B-52H Stratofortress / 464399 / United States Air Force / 1960 / RCH-B52 
AE58A7 / Boeing / 464445  # mfg and serial were missing

ADFED0 / Beech / serial BP-53 / United States Army / PAT-C12U
ADFED9 / Beech / serial BP-63 / United States Army / PAT-C12U

AE4BDE / RCH-C30J
AE223F / USCG-CN35
ADFC94 / RCH-T1
AE1E72 / CNV-TEX2
AE1E77 / CNV-TEX2
AE2EEB / CNV-TEX2

# 2023-03-08
ADFED6 / PAT-C12U
ADFD06 / RCH-T1
AE5F09 / RCH-C30J
AE1EB6 / CNV-TEX2
AE54F7 / serial PN-220 / United States Navy / CNV-TEX2
2E1719 / 166011 / Raytheon Aircraft Company / Raytheon Aircraft Company T-6B Texan II / serial PN-2 / ??? / CNV-TEX2  # visually confirmed, and in usual navy colors. weird hex. adsb.nl, jetphotos. needs to go in LocalAircraft.txt to set as mil
A58257 / # this is a miscode. This is N454QS, NetJets, EJA454, hex code should be A58267. 
AD2F75 / N949JX / Embraer / E145 / Embraer ERJ-145 LR / serial 145639 / JetSuiteX / JSX-E145
AE08B7 / CNV-HAWK
A29E5F / GEN-P180
AD588F / Boeing / United States Air Force / RCH-B52

---

# Removing the commas from various fields isn't necessary for VRS, but may be helpful in the future when scripting

# Type code comma cleanup
ACB512 / Bombardier Challenger 350 BD-100-1A10 # delete extraneous comma at end of type field
4856B0 / De Waal F450 # rearrange type name to remove comma
C0A446 / Kitfox Model 2 # remove comma from type name
484409 / Behlen Vampir II 14.2 # replace comma with period
484DE7 / Behlen Vampir II 14.2 # replace comma with period

# RegisterdOwners comma cleanup
AB0B09 / Meadow Lane Air Partners LLC # remove ', NY' from RegisteredOwners
403D79 / Spitfires.com - The Spitfire Academy
A954FD / Air Twinlite Inc
4911F5 / Luxaviation E.A S.A.
406F65 / Kent Surrey and Sussex Air Ambulance
3D3622 / Luftsportvereins Günther Groenhoff # remove ', Stade'
3D1BAF / Luftsportvereins Günther Groenhoff # remove ', Stade'
3D2A29 / Luftsportvereins Günther Groenhoff # remove ', Stade'
3E6DD0 / Luftsportvereins Günther Groenhoff # remove ', Stade'

2023-03-12 - 2023-03-13

#2023-03-12 - 2023-03-13
AE56D7 / United States Army / PAT-H60
AE03F2 / PAT-C12U
AE08B5 / Raytheon Aircraft Company / Raytheon Aircraft Company T-6A Texan II / serial PT-86 / TEX2 / CNV-TEX2
AE54E8 / United States Navy / CNV-TEX2
AE2EE9 / CNV-TEX2
AE1EB8 / CNV-TEX2
AE171D / United States Navy / CNV-TEX2

Week Whatever

AE14AD / CNV-T44
AE625B / 169307

harriers

#2023-04-11
AE6140 / McDonnell Douglas / HAR / McDonnell Douglas AV-8B Harrier II / United States Marine Corps / USMC-HAR
AE616D / McDonnell Douglas / HAR / McDonnell Douglas AV-8B Harrier II / United States Marine Corps / USMC-HAR
AE6154 / McDonnell Douglas / HAR / McDonnell Douglas AV-8B Harrier II / United States Marine Corps / USMC-HAR

44F687 / Belgian Air Component # seems to be a typo in Component

#2023-04-12
ACD9BE / CVR-S92
A48B10 / CVR-S92
A86041 / CVR
A86134 / CVR
ACC282 / CVR-S92

Just one today

AE11E3 / RCH-E3TF

Okay, I lied

AE1E75 / CNV-TEX2
AE1721 / RCH-TEX2

2023-03-24

Doing this a bit earlier than usual today.

ADFCAF / RCH-T1
AE4EA9 / CNV-TEX2
AE4A1E / CNV-TEX2
AE4EA6 / CNV-TEX2
AE2EEE / CNV-TEX2

Additional additions

AC964C / Louisiana Department of Wildlife and Fisheries 
AE2708 / USCG-CN35
AE683D / Tactical / Boeing / P8 / Boeing P-8A Poseidon / United States Navy / CNV-P8A
AE059E / RCH-KC135BOOM
A77AE7 / RCH-U28

a few more

---

2023-03-04

A47CF9 / CAP-C172
N26XP / serial HA-0152
AD206D / serial 45-109
A0B580 / GEN-EC45
A341CD / GEN-SF50

2023-03-05

AE29DD / RCH-C30J
AE54F4 / Raytheon Aircraft Company T-6B Texan II / serial PN-217 / United States Navy / CNV-TEX2

2023-03-19

#2023-03-19 
AE14B4 / RCH-T44
AE61CE / 761551 / Northrop / F5 / Northrop F-5N Tiger II / United States Navy / CNV-F5
AE61CC / 761549 / Northrop / F5 / Northrop F-5N Tiger II / United States Navy / CNV-F5
AE61CF / 761552 # delete dash
AE61C1 / 761532 # delete dash

---
# Non-military
A2F5D0 / N290DL / Gulfstream Aerospace / GLF6 / Gulfstream Aerospace G650 ER / 6519 / Gulfstream Aerospace Corp / 2022 / GLF-GLF6 # rereg, formerly known as N619GA/A810C4
A1178C / N17HJ / Honda Aircraft Company / HDJT / Honda Aircraft Company Honda Jet HA-420 / 42000128 / Banyan Aircraft Sales LLC / 2018 / GEN-HDJT    # rereg, formerly XA-ECR/0D0B4E

2023-03-03

2023-03-03

ADFCD7 / serial TT-120
AE569B / serial 70-4260
AE6804 / Boeing P-8 Poseidon / United States Navy / CNV-P8A   # apparently a shared hex but always P-8 as far as I can tell
AE074E / USMC-UC12  # conflict, RB/adsb.nl says reg 163836 serial BV-1 vs. this db, which has 163840 serial BV-5
AE56D6 / United States Army / PAT-H60
AE54E7 / serial PN-204
AE06DA / serial BU-6
AE1135 / United States Air Force / reg 02-3665 / serial PT-208 / RCH-TEX2   # this is coded as a Navy bird, but it flew in formation as wingman for a USAF Texan; I think Radarbox's data is probably correct
AE11B8 / RCH-TEX2 
AE11CF / United States Air Force / serial PT-255 / RCH-TEX2
AE1EB5 / CNV-TEX2
AE2EE8 / CNV-TEX2
AE2EDA / CNV-TEX2
AE1EC3 / CNV-TEX2
AE4A21 / CNV-TEX2
AE093C / serial 560-0577
A15C88 / serial FL-679 / USDHS-B350
AB2055 / serial FM-67
A67C51 / serial FM-65

AE61C1 / Northrop F-5N Tiger II  # Typo'd as Tiger I

DHS P-3s

Current active DHS/CBP P-3s. Data from www.p3orion.nl, checked jetphotos too to verify.

A4B960 and A5EA33 lack the 'LRT' in the Type field that the other slicks have, while A5085E is still coded as a P-3AM in the latest Aircraft.csv. A0D900 is in the csv as well as a CBP bird, but it's been dereg'd and turned into soda cans by now.

A4B960 / N403SK / Lockheed P-3BLRT Orion / built 1968 / USDHS-P3
A5085E / N423SK / Lockheed P-3BLRT Orion / built 1967 / USDHS-P3
A5286F / N431SK / built 1967 / USDHS-P3
AA6491 / N769SK / built 1966 / USDHS-P3
A9F7DB / N741SK / built 1966 / USDHS-P3
A5EA33 / N480SK / Lockheed P-3BLRT Orion / built 1968 / USDHS-P3

A0AA61 / N142CS / built 1967 / USDHS-P3RDR
A0AE18 / N143CS / built 1967 / USDHS-P3RDR
A0B1CF / N144CS / built 1967 / USDHS-P3RDR
A0B586 / N145CS / built 1968 / USDHS-P3RDR
A0B93D / N146CS / built 1968 / USDHS-P3RDR
A0BCF4 / N147CS / built 1966 / USDHS-P3RDR
A0C0AB / N148CS / built 1967 / USDHS-P3RDR
A0C462 / N149CS / built 1968 / USDHS-P3RDR

A0D900 / N15390 / deregistered, scrapped, fuselage auctioned april 2013

And because it wouldn't be a database update without a Texan or two,

AE4EA0 / CNV-TEX2

Lastly, spotted this guy who had an N-number/hex change. It used to be A81525 / N62NW, but it's now changed to A38CDB / N328JL, same F900, same owner.

Cheers

mid-june

ADFCBA / RCH-T1 (think you already did this guy)
ADFCAD / RCH-T1 (another_one.gif)

AE71DF / RCH-E3TF (Typo'd as ECH-E3TF)

ADFC77 / RCH-T1
AE5ECA / CNV-B06
AE5F0E / RCH-AC30J
ADFD0D / RCH-T1
AE14B9 / CNV-T44

update rate slowing

#2023-03-27
AE63B7 / RCH-KC46BOOM
AE1E6F / CNV-TEX2

#2023-03-28
AE08BC / CNV-TEX2

#2023-03-30
AE4A1A / CNV-TEX2
AE1148 / CNV-TEX2
AE11EF / RCH-E3TF

AE61BF / reg 761528 / serial L1003

Also, A4D979 should be a CL30 I think:

A4D979 / CL30 / Bombardier Challenger 300

I've submitted correction on the VRS SDM page so this will probably propagate down eventually, may not be worth changing it. Only mentioned because I submitted a request for a side (this is the Saints owner's plane), and want to avoid trouble of an incorrect filename if you choose to make it!

cheers

harrier updates

Some are new, some now have regs and serials

AE613C / reg 165574 / serial 324
AE6142 / McDonnell Douglas / HAR / McDonnell Douglas AV-8B Harrier II / United States Marine Corps / USMC-HAR
AE6154 / reg 164559 / serial 244
AE6156 / reg 165575 / McDonnell Douglas / HAR / McDonnell Douglas AV-8B Harrier II / serial 312 / United States Marine Corps / USMC-HAR
AE6171 / reg 165569 / serial 306
AE6173 / reg 163879 / McDonnell Douglas / HAR / McDonnell Douglas AV-8B Harrier II / serial 187 / United States Marine Corps / USMC-HAR

some more spots

#2023-03-31
AE4E8E / CNV-TEX2
A4231F / DOJ-AT45

#2023-04-01
AE184B / Bell / UH1 / Bell TH-1H Iroquis / United States Air Force / RCH-UH1

MQ-4C corrections; some have wrong serial, no mfg, wrong model, wrong service, etc. These are all USN Tritons.

AE5C71 / reg 168457
AE5C72 / Northrop Grumman / United States Navy / CNV-Q4
AE5C73 / Northrop Grumman / Northrop Grumman MQ-4C Triton
AE5C74 / Northrop Grumman / United States Navy / CNV-Q4
AE5C76 / Northrop Grumman / Northrop Grumman MQ-4C Triton / United States Navy / CNV-Q4
AE6257 / Northrop Grumman MQ-4C Triton / United States Navy / CNV-Q4

another few navy Q4s which aren't Triton model. ae17ec and ae17ed had the same reg number; photos and radarbox tracks seem to show ae17ed is the real Slim Shady.

AE17EC / 166508? / CNV-Q4 # wrong reg. not sure about 'RQ-4N' model
AE17ED / 166509 / Northrop Grumman / RQ-4A Global Hawk / serial N-2 / United States Navy / CNV-Q4

weekend update

---

2023-06-01
AE6C0D / RCH-C30J
ADFCCC / RCH-BE40
E8065E / FACH # chilean army c560

ADFCA9 / RCH-T1
ADFC70 / RCH-T1
AE54FA / CNV-TEX2

ADFCCC / RCH-T1

2023-03-21

AE112F / RCH-TEX2
AE11E4 / RCH-E3TF
AE4ECB / RCH-V22
AE6359 / 22-72481 / Eurocopter / EC45 / Eurocopter UH-72B Lakota / United States Army / PAT-UH72B
AE08BD / CNV-TEX2

# errors
AE14B4 / United States Navy / CNV-T44  # from the other day, was already in the db as USAF; USAF doesn't fly T-44s, definitely Navy

2023-03-09

# 2023-03-09
ADFED8 / serial BP-62 / United States Army / PAT-C12U
AE2238 / serial 168 / United States Coast Guard / USCG-CN35
AE4E9B / CNV-TEX2
AE5F03 / United States Navy
AE54DD / United States Navy
AE54DE / United States Navy / CNV-TEX2
AE08B7 / CNV-HAWK

---
Errata:

38D55B / F-WZMI / Airbus SE / AIB-A21N  # these appear to be test articles flying out of Airbus's Mobile, AL factory
38D5BB / F-WZML / Airbus SE / AIB-A21N  # these appear to be test articles flying out of Airbus's Mobile, AL factory

385CBB / F-WNUB / ATR / ATR 42-600? ATR 72-600?  # apparently an Airbus test article, not seen in 8 months. It is typo'd in the database with the same info as 395CBB.
395CBB / Airbus SE  # typo in RegisteredOwners

Pi Day update

#2023-03-14
AE58F7 / CNV-TEX2
AE4EAC / CNV-TEX2
AE5675 / reg 12-20522 / Sikorsky / H60 / Sikorsky UH-60M Blackhawk / United States Army / PAT-H60
AE112E / RCH-TEX2  # has 'AE11' in year field and no flagcode
AE0A8B / PAT-H60
A1246B / USDHS-B350
AB0DC2 / USDHS-B350

# FAA test planes for ILS approaches or whatever they do
AA3F2E / FLC
AB5600 / FLC
# Other
A75A10 / FedEx Express  # change owner name to bring in line with the other Fedex planes

Database entries

So I'll just add aircraft with the missing/erroneous fields in the order in which they appear in aircraft.csv. I think it should be clear which items need adding/correction.

2023-02-23

AE58EB / CNV-TEX2
AE27FE / USCG-H60
AE6A18 / 20-21102 / United States Army / PAT-H60

2023-02-24

AE11D8 / RCH-E3TF # typo in op.code
AE14CE / CNV-T44
AE61C8 / CNV-F5
AE61C1 / 76-1532 / Northrop / Northrop F-5N Tiger II / serial L1007 / United States Navy / CNV-F5

DB updates

2022-03-02

AAF94A / USDHS   # USDHS-DH8C if the side is available
AE5C68 / CNV-P8A
AC8E11 / NASA-T38
AE54DD / United States Navy / serial PN-194 / CNV-TEX2
ADFCE6 / serial TT-135
AE06D9 / serial BU-9
AE4DFF / serial 701804
AE08BB / serial PT-109
AE53FA / serial FL-449

# currently set as Bell 206B JetRanger, which, technically, yes? but it's a former USArmy Kiowa, worth distinguishing IMO:
A0D6E8 / Bell OH-58C Kiowa / Jackson County Sheriff / serial 70-15550 / GEN-B06 

# type code set as BE95; former army T-42 Cochise:
A71383 / Beech / Beech Baron 95-55B / icao type BE55 / serial TC-2009 / built 1976 / GEN-BE55 

Military aircraft updates since Feb 25

I will start with these and then once a week/month/when I remember I will query My updates of military chagnes in my db. not sure how you want this formatted but here is the list I have in csv. my aircraft ID may be different from your database(you may know that already just wanted to be sure)
military updates.csv

2023-03-15

#2023-03-15
AE63FC / RCH-T38
AE6402 / RCH-T38
AE08BD / CNV-TEX2
AE20F9 / 168275 / Grumman / E2 / Grumman E-2D Hawkeye / United States Navy / CNV-E2
AE5E55 / 165823 / Grumman / E2 / Grumman E-2D Hawkeye / United States Navy / CNV-E2
AE5E48 / ? / Grumman / E2 / Grumman E-2D Hawkeye / United States Navy / CNV-E2
AE5BAB / ? / Grumman / E2 / Grumman E-2D Hawkeye / United States Navy / CNV-E2
AE1ED4 / CNV-TEX2
AE1156 / CNV-TEX2

2023-04-05

# 2023-04-04
AE54FA / CNV-TEX2
AE4EAB / CNV-TEX2
AE4A29 / CNV-TEX2 
AE4E90 / CNV-TEX2

# 2023-04-05
C07B75 / TOPACES
C03177 / TOPACES
C026E7 / TOPACES

# Miscellany 
A0B55B / Commemorative Air Force  # in there as 'commutative air force'

2023-04-30

ADFCEB / RCH-T1
AE1E81 / CNV-TEX2
ADFC76 / RCH-T1

a civvie, why not

AD9B25 / N976NK / Airbus / A320 / Airbus A320-271N / 11276 / Spirit Airlines / 2023 / NKS-A320

#2023-05-01
AE4A2C / CNV-TEX2
AE26F4 / V-22 of some sort

#2023-05-03
AE0021 / RCH-T38
AE001F / RCH-T38
AE0030 / RCH-T38
AE002B / RCH-T38
AE0489 / RCH-KC135BOOM

C06DC3 / Airbus / AIB-BCS3
A0B57D / METROAVEC45    # the file is actually spelled as MERTO 

AE54FA / CNV-TEX2
AE4E90 / CNV-TEX2

2023-04-21

2023-04-21
AE2EF3 / CNV-TEX2

Military plane db updates 👏

2023-02-25 - 2023-02-27

through 19:45 UTC

# USN
# brand new entries! 🎉 these also need the mode-s country set to United States
AE1E00 / ModeSCountry United States / reg 166034 / Raytheon Aircraft Company / Raytheon Aircraft Company T-6B Texan II / serial PN-25 / United States Navy / CNV-TEX2
AE61CF / ModeSCountry United States / reg 761552 / Northrop / Northrop F-5N Tiger II / serial L1027 / United States Navy / CNV-F5

AE61C8 / ModeSCountry United States
AE61C1 / ModeSCountry United States

# the plague of texans continues
AE1152 / CNV-TEX2
AE1142 / CNV-TEX2
AE1EC9 / CNV-TEX2
AE1EC5 / CNV-TEX2

AE06E4 / serial BV-1 
AE14CE / serial LL-59
AE14C3 / serial LL-47 / CNV-T44 

# Not sure if the TH-57C (bell jetranger) flag got made or not, I think we talked about it a while back. Also helis.com lists the serial without leading 0, but RB has it. Not sure which route to take or if it's worth worrying about
AE5F03 / serial 03848 / United States Navy / CNV-TH57

# USMC
AE06DB / serial BU-7

# USCG
AE4DFF / serial 70-1804 / previousID 164615 # former navy mh-60

# USArmy
AE1191 / serial 560-0649 / PAT-C560

# USAF
ADFCD3 / serial TT-116

# DHS/CBP
A5085E / Lockheed P-3BLRT Orion / opcode USDHS # Miscoded as Lockheed P-3AM Orion which is the brazilian version

2023-04-09

2023-04-05
AE061E / RCH-C130

2023-04-08
AE5EFD / CNV-B06
AE5EEB / CNV-B06
AE5EF3 / CNV-B06

2023-05-11

AE4EA3 / CNV-TEX2
AE1ED6 / CNV-TEX2
AE71DF / miscode of E-3, AE11DF 

AE2EFC / CNV-TEX2
ADFC97 / RCH-T1

924924  # frequent miscode
AE29D0 / RCH-C30J

924924 is currently set as a Navy C-130, but this 924924 code is used for a variety of US military aircraft (it's 44444444 in octal). In this case I think it was a T-45C from VT-86. Maybe set this one to 'unknown military' like that V-22 from a few weeks ago.

Some db updates

2023-02-28

AE0940 / USMC-UC35     # miscoded as PAT-C560

ADFF0B / 95-3009 / Raytheon Aircraft Company / Raytheon Aircraft Company T-6B Texan II / serial PT-013 / United States Air Force / RCH-TEX2
AE1155 / CNV-TEX2   # this one may already be in there, sorry
AE115A / CNV-TEX2

2023-03-01

AE0E55 / United States Army / serial 70-993 / PAT-H60   # This one is a bit of a mystery.
AE04AD / PAT-C560
ADFF84 / RCH-T38
AE61DF / 761578 / Northrop / Northrop F-5N Tiger II / serial L1053 / United States Navy / CNV-F5

B-52s

As noted in the Discord, the ground truth of the registrations and serials are gonna be impossible to unwind without physically seeing the aircraft landing while broadcasting ADSB. Some sources agree, others disagree; none of them are especially trustworthy IMO. Instead, better to at least add the sides. Here are the hexes in the database which lack an operator code, which in all cases should be RCH-B52:

AE56ED
AE586D
AE5871
AE5872
AE5873

AE5874
AE5875
AE5876
AE5877
AE5878

AE5879
AE587A
AE587B
AE587D
AE587E

AE5881
AE5882
AE5883
AE5885
AE588A

AE588C
AE588E
AE588F
AE5890
AE5892

AE5893
AE5894
AE5895
AE5896
AE5897

AE5898
AE5899
AE589B
AE589C
AE589D

AE589F
AE58A0
AE58A3
AE58A5
AE58A6

AE58A8
AE58A9
AE58AA
AE58AC
AE58AE

AE58B0
AE58B3
AE5970