This look like a continuous transform usecase to me. If I understand correctly you have a constant stream of new data coming in and want to get the last state by vehicle. A similar question came up today: Latest full document in transform
To get an idea I suggest to watch this webinar. It goes much beyond your original case. But even if you "only" want a table like shown, you might want to calculate trends (e.g. value based on the last 5 data points).
Alternatively you could directly search and aggregate instead of transforming 1st.