Why not match up / clean up using https://simplemaps.com/data/us-zips or similar? You could even transform point delivery (PO Boxes only Post offices, mostly in rural/vacation area villages) zips into delivery-area zips using the parent_zcta field.