MacBook's serial number lookup database
You can find a few websites which provide serial number decoding: some are free, some are not.
I wanted to get a list of the serial numbers and build a correspondence table where you could easily identify model and family (it looks like it is coded into last 4 digits).
I will use this data to help my customers identify their macs on my website, and I am willing to share it with anyone on request.
My current method is this:
I receive about 50 macs for repair monthly and store all serials in the table (currently it's a few hundred long). Then I look them up on one of the available databases and search for the similarities.
I came up with a few correspondences already: any serial which ends with DRVC is a mid-12 MacBook Air 13".
I am looking for any relevant input on the matter (serial number arrays or any ready-made solutions are mostly welcome :) )
Is this a good question?