{"current_page":1,"data":[{"id":12041420,"change_date":"2026-05-28 21:42:00","inspection_id":"87982001","dot_number":"400495","report_state":"MA","report_number":"CQ00004939","insp_date":"2026-05-28 00:00:00","insp_start_time":"1644","insp_end_time":"1705","registration_date":null,"region":"ES","ci_status_code":"C","location":"327H","location_desc":"MA","county_code_state":"MA","county_code":"005","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-28 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"113000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3422041","transaction_code":"A","transaction_date":"2026-05-28 00:00:00","upload_date":"2026-05-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00400495","upload_search_indicator":null,"census_search_date":"2026-05-28 21:42:00","snet_input_date":"2026-05-28 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-28 21:42:00","insp_carrier_name":"FRANZ ANDREWS","insp_carrier_street":"35 INDUSTRIAL DRIVE","insp_carrier_city":"EAST BRIDGEWATER","insp_carrier_state":"MA","insp_carrier_zip_code":"02337","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-01T09:40:00.000000Z","updated_at":"2026-06-08T09:31:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20928946,"change_date":"2026-05-28 21:42:00","inspection_id":"87982001","insp_unit_id":"213799502","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"19","insp_unit_license":"1AK51A","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1XKWDB9X0YR848045","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-01T09:17:14.000000Z","updated_at":"2026-06-08T09:03:37.000000Z"},{"id":20928947,"change_date":"2026-05-28 21:42:00","inspection_id":"87982001","insp_unit_id":"213799503","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":null,"insp_unit_license":"TWE42E","insp_unit_license_state":"NJ","insp_unit_vehicle_id_number":"1GRAA06294D406261","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-01T09:17:14.000000Z","updated_at":"2026-06-08T09:03:37.000000Z"}]},{"id":1031360,"change_date":"2022-08-29 21:41:00","inspection_id":"76314021","dot_number":"400495","report_state":"CT","report_number":"3120003208","insp_date":"2022-08-11 00:00:00","insp_start_time":"0614","insp_end_time":"1019","registration_date":"2022-08-29 00:00:00","region":"ET","ci_status_code":"C","location":"109","location_desc":"PLAINFIELD","county_code_state":"CT","county_code":"015","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"COCA-COLA NORTH AMERICA","shipping_paper_number":"308124135","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-08-15 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"118349","viol_total":"17","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"17","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"651274","transaction_code":"C","transaction_date":"2022-08-11 00:00:00","upload_date":"2022-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00400495","upload_search_indicator":null,"census_search_date":"2022-08-15 21:37:00","snet_input_date":"2022-08-11 00:00:00","source_office":"1CTS001","mcmis_add_date":"2022-08-15 21:37:00","insp_carrier_name":"FRANZ ANDREWS","insp_carrier_street":"2003 BROADWAY REAR","insp_carrier_city":"RAYNHAM","insp_carrier_state":"MA","insp_carrier_zip_code":"02767","insp_colonia":null,"docket_number":"933332","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:45:49.000000Z","updated_at":"2025-03-17T18:45:49.000000Z","inspection_violations":[{"id":1625256,"change_date":"2022-08-29 21:41:00","inspection_id":"76314021","insp_violation_id":"248049586","seq_no":"1","part_no":"393","part_no_section":"203(a)","insp_viol_unit":"1","insp_unit_id":"190582951","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:38.000000Z","updated_at":"2025-03-17T21:14:38.000000Z","normalized_code":"393203A"},{"id":1625257,"change_date":"2022-08-29 21:41:00","inspection_id":"76314021","insp_violation_id":"248049587","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"190582951","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:38.000000Z","updated_at":"2025-03-17T21:14:38.000000Z","normalized_code":"39617C"},{"id":1625258,"change_date":"2022-08-29 21:41:00","inspection_id":"76314021","insp_violation_id":"248049588","seq_no":"4","part_no":"393","part_no_section":"47(a)","insp_viol_unit":"1","insp_unit_id":"190582951","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:14:38.000000Z","updated_at":"2025-03-17T21:14:38.000000Z","normalized_code":"39347A"},{"id":1625259,"change_date":"2022-08-29 21:41:00","inspection_id":"76314021","insp_violation_id":"248049589","seq_no":"5","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"190582951","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:38.000000Z","updated_at":"2025-03-17T21:14:38.000000Z","normalized_code":"39345B2"},{"id":1625260,"change_date":"2022-08-29 21:41:00","inspection_id":"76314021","insp_violation_id":"248049590","seq_no":"6","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"190582951","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:38.000000Z","updated_at":"2025-03-17T21:14:38.000000Z","normalized_code":"39345B2"},{"id":1625261,"change_date":"2022-08-29 21:41:00","inspection_id":"76314021","insp_violation_id":"248049591","seq_no":"7","part_no":"393","part_no_section":"205(c)","insp_viol_unit":"1","insp_unit_id":"190582951","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:38.000000Z","updated_at":"2025-03-17T21:14:38.000000Z","normalized_code":"393205C"},{"id":1625262,"change_date":"2022-08-29 21:41:00","inspection_id":"76314021","insp_violation_id":"248049592","seq_no":"3","part_no":"393","part_no_section":"80","insp_viol_unit":"1","insp_unit_id":"190582951","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:38.000000Z","updated_at":"2025-03-17T21:14:38.000000Z","normalized_code":"39380"},{"id":1625263,"change_date":"2022-08-29 21:41:00","inspection_id":"76314021","insp_violation_id":"248049593","seq_no":"8","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"190582951","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:38.000000Z","updated_at":"2025-03-17T21:14:38.000000Z","normalized_code":"3939A"},{"id":1625264,"change_date":"2022-08-29 21:41:00","inspection_id":"76314021","insp_violation_id":"248049594","seq_no":"9","part_no":"393","part_no_section":"207(f)","insp_viol_unit":"1","insp_unit_id":"190582951","insp_violation_category_id":"22","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:38.000000Z","updated_at":"2025-03-17T21:14:38.000000Z","normalized_code":"393207F"},{"id":1625265,"change_date":"2022-08-29 21:41:00","inspection_id":"76314021","insp_violation_id":"248049595","seq_no":"10","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"190582951","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:38.000000Z","updated_at":"2025-03-17T21:14:38.000000Z","normalized_code":"3963A1"},{"id":1625266,"change_date":"2022-08-29 21:41:00","inspection_id":"76314021","insp_violation_id":"248049596","seq_no":"11","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"190582951","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:14:38.000000Z","updated_at":"2025-03-17T21:14:38.000000Z","normalized_code":"3963A1"},{"id":1625267,"change_date":"2022-08-29 21:41:00","inspection_id":"76314021","insp_violation_id":"248049597","seq_no":"12","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"190582951","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:38.000000Z","updated_at":"2025-03-17T21:14:38.000000Z","normalized_code":"39347E"},{"id":1625268,"change_date":"2022-08-29 21:41:00","inspection_id":"76314021","insp_violation_id":"248049598","seq_no":"13","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"190582951","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:38.000000Z","updated_at":"2025-03-17T21:14:38.000000Z","normalized_code":"39347E"},{"id":1625269,"change_date":"2022-08-29 21:41:00","inspection_id":"76314021","insp_violation_id":"248049599","seq_no":"14","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"190582951","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:38.000000Z","updated_at":"2025-03-17T21:14:38.000000Z","normalized_code":"39353B"},{"id":1625270,"change_date":"2022-08-29 21:41:00","inspection_id":"76314021","insp_violation_id":"248049600","seq_no":"15","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"190582951","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:14:38.000000Z","updated_at":"2025-03-17T21:14:38.000000Z","normalized_code":"3963A1"},{"id":1625271,"change_date":"2022-08-29 21:41:00","inspection_id":"76314021","insp_violation_id":"248049601","seq_no":"16","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"190582951","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:38.000000Z","updated_at":"2025-03-17T21:14:38.000000Z","normalized_code":"39345B2"},{"id":1625272,"change_date":"2022-08-29 21:41:00","inspection_id":"76314021","insp_violation_id":"248049602","seq_no":"17","part_no":"393","part_no_section":"75(a)(1)","insp_viol_unit":"2","insp_unit_id":"190582952","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:38.000000Z","updated_at":"2025-03-17T21:14:38.000000Z","normalized_code":"39375A1"}],"inspection_per_units":[{"id":1659902,"change_date":"2022-08-29 21:41:00","inspection_id":"76314021","insp_unit_id":"190582951","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"25","insp_unit_license":"73622","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"4VG7DBRJ7XN772395","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:27.000000Z","updated_at":"2025-03-17T22:18:27.000000Z"},{"id":1659903,"change_date":"2022-08-29 21:41:00","inspection_id":"76314021","insp_unit_id":"190582952","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GDAN","insp_unit_company":"NEM45375","insp_unit_license":"TWE47E","insp_unit_license_state":"NJ","insp_unit_vehicle_id_number":"1GRAA06264D406282","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:27.000000Z","updated_at":"2025-03-17T22:18:27.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/400495\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/400495\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/400495\/inspections?page=1","label":"1","page":1,"active":true},{"url":null,"label":"Next »","page":null,"active":false}],"next_page_url":null,"path":"https:\/\/searchcarriers.com\/company\/400495\/inspections","per_page":100,"prev_page_url":null,"to":2,"total":2}