Flash - Specification / Application of SpiStack Flash

I have a NPI project wants to build SpiStack Flash with 512Mb Flash to execute booting and application code individually?

How can I identify the application/purpose by part numbers?

What part numbers are suitable for automotive usage?