Is it possible to add warranty check form on the webpage, so customer can check their warranty by inputting the serial number?
May i bump it?
Yes you can. Make a portal page for that. Attach python file with your logic to fetch data from database and display it to your portal page.
Check this doc, Portal Pages