{"current_page":1,"data":[{"id":12223768,"change_date":"2026-06-18 21:42:00","inspection_id":"88181665","dot_number":"423047","report_state":"MA","report_number":"BU00004314","insp_date":"2026-06-18 00:00:00","insp_start_time":"0950","insp_end_time":"1025","registration_date":null,"region":"ES","ci_status_code":"C","location":"281H","location_desc":"MA","county_code_state":"MA","county_code":"009","insp_level_id":"1","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-06-18 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"3572705","transaction_code":"A","transaction_date":"2026-06-18 00:00:00","upload_date":"2026-06-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00423047","upload_search_indicator":null,"census_search_date":"2026-06-18 21:42:00","snet_input_date":"2026-06-18 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-18 21:42:00","insp_carrier_name":"SPS NEW ENGLAND INC","insp_carrier_street":"98 ELM ST","insp_carrier_city":"SALISBURY","insp_carrier_state":"MA","insp_carrier_zip_code":"01952-1804","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-21T09:43:40.000000Z","updated_at":"2026-06-29T09:31:04.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21228919,"change_date":"2026-06-18 21:42:00","inspection_id":"88181665","insp_unit_id":"214174985","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"Y42968","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"3ALACWFC1KDKU3086","insp_unit_decal":"Y","insp_unit_decal_number":"36445807","created_at":"2026-06-21T09:19:30.000000Z","updated_at":"2026-06-29T09:02:05.000000Z"}]},{"id":12204662,"change_date":"2026-06-16 21:40:00","inspection_id":"88161595","dot_number":"423047","report_state":"MS","report_number":"6620003595","insp_date":"2026-06-15 00:00:00","insp_start_time":"1122","insp_end_time":"1145","registration_date":null,"region":"CT","ci_status_code":"C","location":"55","location_desc":"POPLARVILLE","county_code_state":"MS","county_code":"109","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"SPS","shipping_paper_number":"05152026","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-06-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":null,"viol_total":"2","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1153579","transaction_code":"A","transaction_date":"2026-06-15 00:00:00","upload_date":"2026-06-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00423047","upload_search_indicator":null,"census_search_date":"2026-06-16 21:40:00","snet_input_date":"2026-06-16 00:00:00","source_office":"2MSS002","mcmis_add_date":"2026-06-16 21:40:00","insp_carrier_name":"SPS NEW ENGLAND INC","insp_carrier_street":"98 ELM ST","insp_carrier_city":"SALISBURY","insp_carrier_state":"MA","insp_carrier_zip_code":"01952-1804","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-19T09:42:46.000000Z","updated_at":"2026-06-27T09:31:15.000000Z","inspection_violations":[{"id":21240173,"change_date":"2026-06-16 21:40:00","inspection_id":"88161595","insp_violation_id":"274949192","seq_no":"1","part_no":"392","part_no_section":"2-SLLS2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-19T10:04:57.000000Z","updated_at":"2026-06-27T09:43:05.000000Z","normalized_code":"3922SLLS2"},{"id":21240174,"change_date":"2026-06-16 21:40:00","inspection_id":"88161595","insp_violation_id":"274949193","seq_no":"2","part_no":"395","part_no_section":"24D-ELDPT","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-19T10:04:57.000000Z","updated_at":"2026-06-27T09:43:05.000000Z","normalized_code":"39524DELDPT"}],"inspection_per_units":[{"id":21197346,"change_date":"2026-06-16 21:40:00","inspection_id":"88161595","insp_unit_id":"214137144","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"1038","insp_unit_license":"1AA294","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1M1AN074XCM009283","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-19T09:20:27.000000Z","updated_at":"2026-06-27T09:02:35.000000Z"},{"id":21197347,"change_date":"2026-06-16 21:40:00","inspection_id":"88161595","insp_unit_id":"214137145","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAGB","insp_unit_company":"05150","insp_unit_license":"93675","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"112H8V346EL079027","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-19T09:20:27.000000Z","updated_at":"2026-06-27T09:02:35.000000Z"}]},{"id":11332787,"change_date":"2026-03-10 21:38:00","inspection_id":"87249982","dot_number":"423047","report_state":"MA","report_number":"DT00000773","insp_date":"2026-03-09 00:00:00","insp_start_time":"1534","insp_end_time":"1548","registration_date":null,"region":"ET","ci_status_code":"C","location":"178H","location_desc":"H-LUDLOW","county_code_state":"MA","county_code":"013","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":"N","pen_cen_match":null,"final_status_date":"2026-03-10 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"36000","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":"541540","transaction_code":"A","transaction_date":"2026-03-10 00:00:00","upload_date":"2026-03-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00423047","upload_search_indicator":"M","census_search_date":"2026-03-10 21:38:00","snet_input_date":"2026-03-09 00:00:00","source_office":"1MAS001","mcmis_add_date":"2026-03-10 21:38:00","insp_carrier_name":"SPS NEW ENGLAND INC","insp_carrier_street":"98 ELM ST","insp_carrier_city":"SALISBURY","insp_carrier_state":"MA","insp_carrier_zip_code":"01952-1804","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-13T09:43:44.000000Z","updated_at":"2026-03-21T09:31:01.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19392150,"change_date":"2026-03-10 21:38:00","inspection_id":"87249982","insp_unit_id":"212060766","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"2994B","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FDWF7DC3JDF05865","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-13T09:23:22.000000Z","updated_at":"2026-03-21T09:10:52.000000Z"}]},{"id":11074812,"change_date":"2026-02-08 21:33:00","inspection_id":"86985631","dot_number":"423047","report_state":"RI","report_number":"0232000072","insp_date":"2026-02-02 00:00:00","insp_start_time":"1536","insp_end_time":"1606","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"JOHNSTON RI","county_code_state":"RI","county_code":"007","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-02-08 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"2858169","transaction_code":"A","transaction_date":"2026-02-07 00:00:00","upload_date":"2026-02-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00423047","upload_search_indicator":null,"census_search_date":"2026-02-08 21:33:00","snet_input_date":"2026-02-02 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-02-08 21:33:00","insp_carrier_name":"SPS NEW ENGLAND INC","insp_carrier_street":"98 ELM ST","insp_carrier_city":"SALISBURY","insp_carrier_state":"MA","insp_carrier_zip_code":"01952-1804","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-11T10:36:50.000000Z","updated_at":"2026-02-19T10:30:03.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18883539,"change_date":"2026-02-08 21:33:00","inspection_id":"86985631","insp_unit_id":"211499841","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"TKU-20639","insp_unit_license":"X83105","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"2NP2HM6X0GM362266","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-11T10:13:35.000000Z","updated_at":"2026-02-19T10:02:31.000000Z"}]},{"id":10505166,"change_date":"2026-01-21 21:38:00","inspection_id":"86640154","dot_number":"423047","report_state":"MA","report_number":"DS00002448","insp_date":"2025-12-23 00:00:00","insp_start_time":"1138","insp_end_time":"1148","registration_date":"2026-01-21 00:00:00","region":"ET","ci_status_code":"C","location":"291H","location_desc":"H-SAUGUS","county_code_state":"MA","county_code":"009","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-12-23 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"20000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"536891","transaction_code":"C","transaction_date":"2025-12-23 00:00:00","upload_date":"2026-01-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00423047","upload_search_indicator":"M","census_search_date":"2025-12-23 21:38:00","snet_input_date":"2025-12-23 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-12-23 21:38:00","insp_carrier_name":"SPS NEW ENGLAND INC","insp_carrier_street":"98 ELM ST","insp_carrier_city":"SALISBURY","insp_carrier_state":"MA","insp_carrier_zip_code":"01952-1804","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-26T10:38:34.000000Z","updated_at":"2026-02-01T10:30:28.000000Z","inspection_violations":[{"id":18096496,"change_date":"2026-01-21 21:38:00","inspection_id":"86640154","insp_violation_id":"271336443","seq_no":"1","part_no":"392","part_no_section":"2-SLL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-24T10:43:02.000000Z","updated_at":"2026-02-01T10:36:51.000000Z","normalized_code":"3922SLL"}],"inspection_per_units":[{"id":18180461,"change_date":"2026-01-21 21:38:00","inspection_id":"86640154","insp_unit_id":"211208431","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"X14229","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FDUF5HT9NDA12154","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-24T10:08:36.000000Z","updated_at":"2026-02-01T10:02:55.000000Z"}]},{"id":10238446,"change_date":"2025-11-24 21:39:00","inspection_id":"86361074","dot_number":"423047","report_state":"MA","report_number":"DZ00001191","insp_date":"2025-11-18 00:00:00","insp_start_time":"2030","insp_end_time":"2045","registration_date":"2025-11-24 00:00:00","region":"ET","ci_status_code":"C","location":"372H","location_desc":"H-WESTWOOD","county_code_state":"MA","county_code":"021","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-11-19 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"32000","viol_total":"2","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"534268","transaction_code":"C","transaction_date":"2025-11-19 00:00:00","upload_date":"2025-11-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00423047","upload_search_indicator":"M","census_search_date":"2025-11-19 21:39:00","snet_input_date":"2025-11-18 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-11-19 21:39:00","insp_carrier_name":"SPS NEW ENGLAND INC","insp_carrier_street":"98 ELM ST","insp_carrier_city":"SALISBURY","insp_carrier_state":"MA","insp_carrier_zip_code":"01952-1804","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-23T10:31:41.000000Z","updated_at":"2025-11-28T10:30:42.000000Z","inspection_violations":[{"id":17178157,"change_date":"2025-11-24 21:39:00","inspection_id":"86361074","insp_violation_id":"270255280","seq_no":"1","part_no":"392","part_no_section":"2-SLLS3","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-27T10:30:56.000000Z","updated_at":"2025-11-28T10:31:15.000000Z","normalized_code":"3922SLLS3"},{"id":17178158,"change_date":"2025-11-24 21:39:00","inspection_id":"86361074","insp_violation_id":"270255281","seq_no":"2","part_no":"392","part_no_section":"2-SLLTCD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-27T10:30:56.000000Z","updated_at":"2025-11-28T10:31:15.000000Z","normalized_code":"3922SLLTCD"}],"inspection_per_units":[{"id":17152880,"change_date":"2025-11-24 21:39:00","inspection_id":"86361074","insp_unit_id":"210229604","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"W63239","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1M2MDBAA5NS001841","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-27T10:00:37.000000Z","updated_at":"2025-11-28T10:00:41.000000Z"},{"id":17152881,"change_date":"2025-11-24 21:39:00","inspection_id":"86361074","insp_unit_id":"210229605","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"DOOS","insp_unit_company":null,"insp_unit_license":"TZ54247","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"4FVCBBDA7DU449392","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-27T10:00:37.000000Z","updated_at":"2025-11-28T10:00:41.000000Z"}]},{"id":10162401,"change_date":"2025-11-24 21:39:00","inspection_id":"86281258","dot_number":"423047","report_state":"MA","report_number":"BV00008062","insp_date":"2025-11-07 00:00:00","insp_start_time":"0432","insp_end_time":"0449","registration_date":"2025-11-24 00:00:00","region":"ET","ci_status_code":"C","location":"281H","location_desc":"H-ROWLEY","county_code_state":"MA","county_code":"009","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-11-10 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"16000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"533246","transaction_code":"C","transaction_date":"2025-11-07 00:00:00","upload_date":"2025-11-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00423047","upload_search_indicator":null,"census_search_date":"2025-11-10 21:39:00","snet_input_date":"2025-11-07 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-11-10 21:39:00","insp_carrier_name":"SPS NEW ENGLAND INC","insp_carrier_street":"98 ELM ST","insp_carrier_city":"SALISBURY","insp_carrier_state":"MA","insp_carrier_zip_code":"01952","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-13T10:30:41.000000Z","updated_at":"2025-11-28T10:30:41.000000Z","inspection_violations":[{"id":17177467,"change_date":"2025-11-24 21:39:00","inspection_id":"86281258","insp_violation_id":"270255116","seq_no":"1","part_no":"392","part_no_section":"2-SLLLR","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-27T10:30:55.000000Z","updated_at":"2025-11-28T10:31:09.000000Z","normalized_code":"3922SLLLR"}],"inspection_per_units":[{"id":17152454,"change_date":"2025-11-24 21:39:00","inspection_id":"86281258","insp_unit_id":"210229470","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"Y26101","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FDTF4GTXRDA03573","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-27T10:00:37.000000Z","updated_at":"2025-11-28T10:00:39.000000Z"}]},{"id":10116723,"change_date":"2025-11-04 21:40:00","inspection_id":"86233083","dot_number":"423047","report_state":"MA","report_number":"CY00004028","insp_date":"2025-11-03 00:00:00","insp_start_time":"2309","insp_end_time":"2322","registration_date":null,"region":"ET","ci_status_code":"C","location":"380H","location_desc":"H-WILMINGTON","county_code_state":"MA","county_code":"017","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-11-04 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25995","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"532898","transaction_code":"A","transaction_date":"2025-11-04 00:00:00","upload_date":"2025-11-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00423047","upload_search_indicator":"M","census_search_date":"2025-11-04 21:40:00","snet_input_date":"2025-11-03 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-11-04 21:40:00","insp_carrier_name":"SPS NEW ENGLAND INC","insp_carrier_street":"98 ELM ST","insp_carrier_city":"SALISBURY","insp_carrier_state":"MA","insp_carrier_zip_code":"01952-1804","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-07T10:31:43.000000Z","updated_at":"2025-11-08T10:31:05.000000Z","inspection_violations":[{"id":16773091,"change_date":"2025-11-04 21:40:00","inspection_id":"86233083","insp_violation_id":"269719008","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"209826084","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-07T10:31:38.000000Z","updated_at":"2025-11-08T10:31:33.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":16833515,"change_date":"2025-11-04 21:40:00","inspection_id":"86233083","insp_unit_id":"209826084","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"TKD04235","insp_unit_license":"W44345","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1M2MDBAA0NS002654","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-07T10:01:36.000000Z","updated_at":"2025-11-08T10:01:24.000000Z"}]},{"id":9835466,"change_date":"2025-10-14 21:42:00","inspection_id":"85936576","dot_number":"423047","report_state":"MA","report_number":"BV00007959","insp_date":"2025-10-02 00:00:00","insp_start_time":"0404","insp_end_time":"0421","registration_date":"2025-10-09 00:00:00","region":"ET","ci_status_code":"C","location":"281H","location_desc":"H-ROWLEY","county_code_state":"MA","county_code":"009","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-10-02 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"530243","transaction_code":"C","transaction_date":"2025-10-02 00:00:00","upload_date":"2025-10-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00423047","upload_search_indicator":"M","census_search_date":"2025-10-02 21:42:00","snet_input_date":"2025-10-02 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-10-02 21:42:00","insp_carrier_name":"SPS NEW ENGLAND INC","insp_carrier_street":"98 ELM ST","insp_carrier_city":"SALISBURY","insp_carrier_state":"MA","insp_carrier_zip_code":"01952-1804","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-05T10:01:51.000000Z","updated_at":"2025-10-18T10:00:56.000000Z","inspection_violations":[{"id":16401911,"change_date":"2025-10-14 21:42:00","inspection_id":"85936576","insp_violation_id":"269290493","seq_no":"1","part_no":"392","part_no_section":"2-SLLLR","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-17T10:17:21.000000Z","updated_at":"2025-10-18T10:16:22.000000Z","normalized_code":"3922SLLLR"}],"inspection_per_units":[{"id":16495257,"change_date":"2025-10-14 21:42:00","inspection_id":"85936576","insp_unit_id":"209463052","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"W63239","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1M2MDBAA5NS001841","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-17T09:46:51.000000Z","updated_at":"2025-10-18T09:46:11.000000Z"}]},{"id":9667418,"change_date":"2025-09-23 21:42:00","inspection_id":"85760302","dot_number":"423047","report_state":"MA","report_number":"BV00007900","insp_date":"2025-09-12 00:00:00","insp_start_time":"0319","insp_end_time":"0336","registration_date":"2025-09-23 00:00:00","region":"ET","ci_status_code":"C","location":"281H","location_desc":"H-ROWLEY","county_code_state":"MA","county_code":"009","insp_level_id":"2","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-09-12 21:49:00","post_acc_ind":"N","gross_comb_veh_wt":"43000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"528623","transaction_code":"C","transaction_date":"2025-09-12 00:00:00","upload_date":"2025-09-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00423047","upload_search_indicator":"M","census_search_date":"2025-09-12 21:49:00","snet_input_date":"2025-09-12 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-09-12 21:49:00","insp_carrier_name":"SPS NEW ENGLAND INC","insp_carrier_street":"98 ELM ST","insp_carrier_city":"SALISBURY","insp_carrier_state":"MA","insp_carrier_zip_code":"01952-1804","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-16T10:48:13.000000Z","updated_at":"2025-09-26T10:00:14.000000Z","inspection_violations":[{"id":16020082,"change_date":"2025-09-23 21:42:00","inspection_id":"85760302","insp_violation_id":"268867253","seq_no":"1","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"209095689","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-26T10:16:35.000000Z","updated_at":"2025-09-27T10:15:28.000000Z","normalized_code":"3939ALIL"}],"inspection_per_units":[{"id":16149365,"change_date":"2025-09-23 21:42:00","inspection_id":"85760302","insp_unit_id":"209095689","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"4410B","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1M2GR6AB3LM001319","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-26T09:46:00.000000Z","updated_at":"2025-09-27T09:45:14.000000Z"}]},{"id":9480836,"change_date":"2025-08-22 21:38:00","inspection_id":"85564577","dot_number":"423047","report_state":"MA","report_number":"BV00007829","insp_date":"2025-08-22 00:00:00","insp_start_time":"0342","insp_end_time":"0404","registration_date":null,"region":"ET","ci_status_code":"C","location":"281H","location_desc":"H-ROWLEY","county_code_state":"MA","county_code":"009","insp_level_id":"2","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-08-22 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"526490","transaction_code":"A","transaction_date":"2025-08-22 00:00:00","upload_date":"2025-08-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00423047","upload_search_indicator":"M","census_search_date":"2025-08-22 21:38:00","snet_input_date":"2025-08-22 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-08-22 21:38:00","insp_carrier_name":"SPS NEW ENGLAND INC","insp_carrier_street":"98 ELM ST","insp_carrier_city":"SALISBURY","insp_carrier_state":"MA","insp_carrier_zip_code":"01952-1804","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-25T10:43:13.000000Z","updated_at":"2025-08-26T10:45:33.000000Z","inspection_violations":[{"id":15453495,"change_date":"2025-08-22 21:38:00","inspection_id":"85564577","insp_violation_id":"268191034","seq_no":"1","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"208531916","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-25T10:45:37.000000Z","updated_at":"2025-08-26T10:47:04.000000Z","normalized_code":"3939ALIL"},{"id":15453496,"change_date":"2025-08-22 21:38:00","inspection_id":"85564577","insp_violation_id":"268191035","seq_no":"2","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"208531916","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-25T10:45:37.000000Z","updated_at":"2025-08-26T10:47:04.000000Z","normalized_code":"39395F"}],"inspection_per_units":[{"id":15639096,"change_date":"2025-08-22 21:38:00","inspection_id":"85564577","insp_unit_id":"208531916","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"W63239","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1M2MDBAA5NS001841","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-25T09:46:39.000000Z","updated_at":"2025-08-26T09:45:42.000000Z"}]},{"id":9320964,"change_date":"2025-08-12 21:39:00","inspection_id":"85396450","dot_number":"423047","report_state":"MA","report_number":"BV00007765","insp_date":"2025-08-04 00:00:00","insp_start_time":"0448","insp_end_time":"0506","registration_date":"2025-08-12 00:00:00","region":"ET","ci_status_code":"C","location":"281H","location_desc":"H-ROWLEY","county_code_state":"MA","county_code":"009","insp_level_id":"2","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-08-04 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"28000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"524737","transaction_code":"C","transaction_date":"2025-08-04 00:00:00","upload_date":"2025-08-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00423047","upload_search_indicator":"M","census_search_date":"2025-08-04 21:38:00","snet_input_date":"2025-08-04 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-08-04 21:38:00","insp_carrier_name":"SPS NEW ENGLAND INC","insp_carrier_street":"98 ELM ST","insp_carrier_city":"SALISBURY","insp_carrier_state":"MA","insp_carrier_zip_code":"01952-1804","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-07T10:44:48.000000Z","updated_at":"2025-08-16T10:00:07.000000Z","inspection_violations":[{"id":15252556,"change_date":"2025-08-12 21:39:00","inspection_id":"85396450","insp_violation_id":"267972962","seq_no":"1","part_no":"393","part_no_section":"9A-LRLI","insp_viol_unit":"2","insp_unit_id":"208351137","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-15T10:45:27.000000Z","updated_at":"2025-08-16T10:42:53.000000Z","normalized_code":"3939ALRLI"}],"inspection_per_units":[{"id":15463120,"change_date":"2025-08-12 21:39:00","inspection_id":"85396450","insp_unit_id":"208351136","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"V55817","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"5PVNJ8JT9L5S59846","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-15T09:46:15.000000Z","updated_at":"2025-08-16T09:45:08.000000Z"},{"id":15463121,"change_date":"2025-08-12 21:39:00","inspection_id":"85396450","insp_unit_id":"208351137","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"VERN","insp_unit_company":null,"insp_unit_license":"D14587","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"2S9US1111FS132711","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-15T09:46:15.000000Z","updated_at":"2025-08-16T09:45:08.000000Z"}]},{"id":9296978,"change_date":"2025-08-12 21:39:00","inspection_id":"85371412","dot_number":"423047","report_state":"MA","report_number":"ED00000288","insp_date":"2025-07-30 00:00:00","insp_start_time":"1946","insp_end_time":"1956","registration_date":"2025-08-12 00:00:00","region":"ET","ci_status_code":"C","location":"359H","location_desc":"H-WEST BRIDGEWATER","county_code_state":"MA","county_code":"023","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-07-31 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"524481","transaction_code":"C","transaction_date":"2025-07-31 00:00:00","upload_date":"2025-08-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00423047","upload_search_indicator":"M","census_search_date":"2025-07-31 21:40:00","snet_input_date":"2025-07-30 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-07-31 21:40:00","insp_carrier_name":"SPS NEW ENGLAND INC","insp_carrier_street":"98 ELM ST","insp_carrier_city":"SALISBURY","insp_carrier_state":"MA","insp_carrier_zip_code":"01952-1804","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-04T10:01:28.000000Z","updated_at":"2025-08-16T10:00:06.000000Z","inspection_violations":[{"id":15252241,"change_date":"2025-08-12 21:39:00","inspection_id":"85371412","insp_violation_id":"267974278","seq_no":"1","part_no":"392","part_no_section":"2-SLLTL","insp_viol_unit":"1","insp_unit_id":"208351818","insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-15T10:45:27.000000Z","updated_at":"2025-08-16T10:42:52.000000Z","normalized_code":"3922SLLTL"}],"inspection_per_units":[{"id":15462921,"change_date":"2025-08-12 21:39:00","inspection_id":"85371412","insp_unit_id":"208351818","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"Y33632","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FVACWFCXSHVZ7618","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-15T09:46:15.000000Z","updated_at":"2025-08-16T09:45:08.000000Z"}]},{"id":9138718,"change_date":"2025-07-14 21:40:00","inspection_id":"85204935","dot_number":"423047","report_state":"MA","report_number":"BV00007717","insp_date":"2025-07-14 00:00:00","insp_start_time":"0317","insp_end_time":"0336","registration_date":null,"region":"ET","ci_status_code":"C","location":"281H","location_desc":"H-ROWLEY","county_code_state":"MA","county_code":"009","insp_level_id":"2","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-07-14 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"126000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"522944","transaction_code":"A","transaction_date":"2025-07-14 00:00:00","upload_date":"2025-07-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00423047","upload_search_indicator":"M","census_search_date":"2025-07-14 21:40:00","snet_input_date":"2025-07-14 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-07-14 21:40:00","insp_carrier_name":"SPS NEW ENGLAND INC","insp_carrier_street":"98 ELM ST","insp_carrier_city":"SALISBURY","insp_carrier_state":"MA","insp_carrier_zip_code":"01952-1804","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-18T10:45:43.000000Z","updated_at":"2025-07-18T10:45:43.000000Z","inspection_violations":[{"id":14741886,"change_date":"2025-07-14 21:40:00","inspection_id":"85204935","insp_violation_id":"267384338","seq_no":"1","part_no":"393","part_no_section":"23-LEU","insp_viol_unit":"2","insp_unit_id":"207850887","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-07-17T10:47:05.000000Z","updated_at":"2025-07-18T10:47:01.000000Z","normalized_code":"39323LEU"}],"inspection_per_units":[{"id":15006834,"change_date":"2025-07-14 21:40:00","inspection_id":"85204935","insp_unit_id":"207850886","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"T48426","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1M2AX04C9DM016373","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-17T09:45:29.000000Z","updated_at":"2025-07-18T09:45:36.000000Z"},{"id":15006835,"change_date":"2025-07-14 21:40:00","inspection_id":"85204935","insp_unit_id":"207850887","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAGB","insp_unit_company":null,"insp_unit_license":"F10313","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"112H8V395LL084499","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-17T09:45:29.000000Z","updated_at":"2025-07-18T09:45:36.000000Z"}]},{"id":9138719,"change_date":"2025-07-14 21:40:00","inspection_id":"85204936","dot_number":"423047","report_state":"MA","report_number":"BV00007718","insp_date":"2025-07-14 00:00:00","insp_start_time":"0402","insp_end_time":"0419","registration_date":null,"region":"ET","ci_status_code":"C","location":"281H","location_desc":"H-ROWLEY","county_code_state":"MA","county_code":"009","insp_level_id":"2","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-07-14 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"522912","transaction_code":"A","transaction_date":"2025-07-14 00:00:00","upload_date":"2025-07-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00423047","upload_search_indicator":"M","census_search_date":"2025-07-14 21:40:00","snet_input_date":"2025-07-14 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-07-14 21:40:00","insp_carrier_name":"SPS NEW ENGLAND INC","insp_carrier_street":"98 ELM ST","insp_carrier_city":"SALISBURY","insp_carrier_state":"MA","insp_carrier_zip_code":"01952-1804","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-18T10:45:43.000000Z","updated_at":"2025-07-18T10:45:43.000000Z","inspection_violations":[{"id":14741887,"change_date":"2025-07-14 21:40:00","inspection_id":"85204936","insp_violation_id":"267384339","seq_no":"1","part_no":"393","part_no_section":"11A1-LIL","insp_viol_unit":"1","insp_unit_id":"207850888","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-17T10:47:05.000000Z","updated_at":"2025-07-18T10:47:01.000000Z","normalized_code":"39311A1LIL"},{"id":14741888,"change_date":"2025-07-14 21:40:00","inspection_id":"85204936","insp_violation_id":"267384340","seq_no":"2","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"207850888","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-17T10:47:05.000000Z","updated_at":"2025-07-18T10:47:01.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":15006836,"change_date":"2025-07-14 21:40:00","inspection_id":"85204936","insp_unit_id":"207850888","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"S24806","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1HTMMAAP06H264176","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-17T09:45:29.000000Z","updated_at":"2025-07-18T09:45:36.000000Z"}]},{"id":8871193,"change_date":"2025-06-17 21:41:00","inspection_id":"84922107","dot_number":"423047","report_state":"MA","report_number":"DT00000269","insp_date":"2025-06-10 00:00:00","insp_start_time":"1013","insp_end_time":"1055","registration_date":"2025-06-17 00:00:00","region":"ET","ci_status_code":"C","location":"027H","location_desc":"H-BECKET","county_code_state":"MA","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-11 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"520189","transaction_code":"C","transaction_date":"2025-06-11 00:00:00","upload_date":"2025-06-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00423047","upload_search_indicator":"M","census_search_date":"2025-06-11 21:42:00","snet_input_date":"2025-06-10 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-06-11 21:42:00","insp_carrier_name":"SPS NEW ENGLAND INC","insp_carrier_street":"98 ELM ST","insp_carrier_city":"SALISBURY","insp_carrier_state":"MA","insp_carrier_zip_code":"01952-1804","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-14T10:00:59.000000Z","updated_at":"2025-06-22T10:00:16.000000Z","inspection_violations":[{"id":14300689,"change_date":"2025-06-17 21:41:00","inspection_id":"84922107","insp_violation_id":"266890954","seq_no":"1","part_no":"392","part_no_section":"2-SLLTL","insp_viol_unit":"1","insp_unit_id":"207427116","insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-20T10:16:26.000000Z","updated_at":"2025-06-21T10:17:02.000000Z","normalized_code":"3922SLLTL"}],"inspection_per_units":[{"id":14610337,"change_date":"2025-06-17 21:41:00","inspection_id":"84922107","insp_unit_id":"207427116","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"TKD03535","insp_unit_license":"2994B","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FDWF7DC3JDF05865","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-20T09:46:01.000000Z","updated_at":"2025-06-22T09:45:22.000000Z"}]},{"id":8813913,"change_date":"2025-06-17 21:41:00","inspection_id":"84861468","dot_number":"423047","report_state":"MA","report_number":"BV00007604","insp_date":"2025-06-04 00:00:00","insp_start_time":"0315","insp_end_time":"0336","registration_date":"2025-06-17 00:00:00","region":"ET","ci_status_code":"C","location":"281H","location_desc":"H-ROWLEY","county_code_state":"MA","county_code":"009","insp_level_id":"2","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-06-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"27500","viol_total":"4","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"519595","transaction_code":"C","transaction_date":"2025-06-04 00:00:00","upload_date":"2025-06-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00423047","upload_search_indicator":"M","census_search_date":"2025-06-04 21:41:00","snet_input_date":"2025-06-04 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-06-04 21:41:00","insp_carrier_name":"SPS NEW ENGLAND INC","insp_carrier_street":"98 ELM ST","insp_carrier_city":"SALISBURY","insp_carrier_state":"MA","insp_carrier_zip_code":"01952-1804","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-07T10:01:04.000000Z","updated_at":"2025-06-22T10:00:15.000000Z","inspection_violations":[{"id":14300221,"change_date":"2025-06-17 21:41:00","inspection_id":"84861468","insp_violation_id":"266890787","seq_no":"1","part_no":"392","part_no_section":"2-SLLDL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-20T10:16:25.000000Z","updated_at":"2025-06-21T10:17:00.000000Z","normalized_code":"3922SLLDL"},{"id":14300222,"change_date":"2025-06-17 21:41:00","inspection_id":"84861468","insp_violation_id":"266890788","seq_no":"2","part_no":"391","part_no_section":"41A-MCPC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-20T10:16:25.000000Z","updated_at":"2025-06-21T10:17:00.000000Z","normalized_code":"39141AMCPC"},{"id":14300223,"change_date":"2025-06-17 21:41:00","inspection_id":"84861468","insp_violation_id":"266890789","seq_no":"3","part_no":"393","part_no_section":"9A-LHLI","insp_viol_unit":"1","insp_unit_id":"207427032","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-20T10:16:25.000000Z","updated_at":"2025-06-21T10:17:00.000000Z","normalized_code":"3939ALHLI"},{"id":14300224,"change_date":"2025-06-17 21:41:00","inspection_id":"84861468","insp_violation_id":"266890790","seq_no":"4","part_no":"393","part_no_section":"95A4-EEUS","insp_viol_unit":"1","insp_unit_id":"207427032","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-20T10:16:25.000000Z","updated_at":"2025-06-21T10:17:00.000000Z","normalized_code":"39395A4EEUS"}],"inspection_per_units":[{"id":14610026,"change_date":"2025-06-17 21:41:00","inspection_id":"84861468","insp_unit_id":"207427032","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"X81454","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1HTEUMML2RS167583","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-20T09:46:01.000000Z","updated_at":"2025-06-22T09:45:21.000000Z"},{"id":14610027,"change_date":"2025-06-17 21:41:00","inspection_id":"84861468","insp_unit_id":"207427033","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"VMAC","insp_unit_company":null,"insp_unit_license":"E49456","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"2S9US1113JS132525","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-20T09:46:01.000000Z","updated_at":"2025-06-22T09:45:21.000000Z"}]},{"id":8459314,"change_date":"2025-04-24 21:38:00","inspection_id":"84487445","dot_number":"423047","report_state":"MA","report_number":"CD00008435","insp_date":"2025-04-23 00:00:00","insp_start_time":"1811","insp_end_time":"1823","registration_date":null,"region":"ET","ci_status_code":"C","location":"120H","location_desc":"H-GEORGETOWN","county_code_state":"MA","county_code":"009","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-04-24 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"43000","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":"515605","transaction_code":"A","transaction_date":"2025-04-24 00:00:00","upload_date":"2025-04-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00423047","upload_search_indicator":"M","census_search_date":"2025-04-24 21:38:00","snet_input_date":"2025-04-23 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-04-24 21:38:00","insp_carrier_name":"SPS NEW ENGLAND INC","insp_carrier_street":"98 ELM ST","insp_carrier_city":"SALISBURY","insp_carrier_state":"MA","insp_carrier_zip_code":"01952-1804","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-27T10:28:23.000000Z","updated_at":"2025-04-28T10:11:05.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13743097,"change_date":"2025-04-24 21:38:00","inspection_id":"84487445","insp_unit_id":"206471629","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"TKU-154","insp_unit_license":"1AH39A","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1NKZHK7X1RJ263361","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-27T10:14:20.000000Z","updated_at":"2025-04-28T09:55:29.000000Z"}]},{"id":8351963,"change_date":"2025-05-12 21:40:00","inspection_id":"84374246","dot_number":"423047","report_state":"MA","report_number":"BV00007443","insp_date":"2025-04-11 00:00:00","insp_start_time":"0515","insp_end_time":"0533","registration_date":null,"region":"ET","ci_status_code":"C","location":"281H","location_desc":"H-ROWLEY","county_code_state":"MA","county_code":"009","insp_level_id":"2","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-04-11 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"514571","transaction_code":"C","transaction_date":"2025-05-12 00:00:00","upload_date":"2025-05-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00423047","upload_search_indicator":"M","census_search_date":"2025-04-11 21:40:00","snet_input_date":"2025-04-11 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-04-11 21:40:00","insp_carrier_name":"SPS NEW ENGLAND INC","insp_carrier_street":"98 ELM ST","insp_carrier_city":"SALISBURY","insp_carrier_state":"MA","insp_carrier_zip_code":"01952-1804","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-14T10:29:34.000000Z","updated_at":"2025-05-17T10:03:27.000000Z","inspection_violations":[{"id":13393692,"change_date":"2025-04-28 21:35:00","inspection_id":"84374246","insp_violation_id":"265836903","seq_no":"3","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"206496338","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-01T10:15:41.000000Z","updated_at":"2025-05-02T10:39:28.000000Z","normalized_code":"3922SLLSR"},{"id":13662852,"change_date":"2025-05-12 21:40:00","inspection_id":"84374246","insp_violation_id":"266158884","seq_no":"1","part_no":"392","part_no_section":"2-SLL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-15T10:16:49.000000Z","updated_at":"2025-05-16T10:19:09.000000Z","normalized_code":"3922SLL"},{"id":13662853,"change_date":"2025-05-12 21:40:00","inspection_id":"84374246","insp_violation_id":"266158885","seq_no":"2","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"206803259","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-15T10:16:49.000000Z","updated_at":"2025-05-16T10:19:09.000000Z","normalized_code":"39617CPI"}],"inspection_per_units":[{"id":14037984,"change_date":"2025-05-12 21:40:00","inspection_id":"84374246","insp_unit_id":"206803259","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"W44345","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1M2MDBAA0NS002654","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-15T09:45:49.000000Z","updated_at":"2025-05-16T09:48:27.000000Z"}]},{"id":8378678,"change_date":"2025-04-15 21:40:00","inspection_id":"84402434","dot_number":"423047","report_state":"VA","report_number":"4346000338","insp_date":"2025-04-10 00:00:00","insp_start_time":"1435","insp_end_time":"1556","registration_date":null,"region":"ED","ci_status_code":"C","location":"CARSCN","location_desc":"PETERSBURG VA","county_code_state":"VA","county_code":"149","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SPS NEW ENGLAND","shipping_paper_number":"NONE","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":"U","pen_cen_match":"I","final_status_date":"2025-04-15 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"147220","viol_total":"5","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":"1597411","transaction_code":"A","transaction_date":"2025-04-15 00:00:00","upload_date":"2025-04-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00423047","upload_search_indicator":null,"census_search_date":"2025-04-15 21:40:00","snet_input_date":"2025-04-10 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-04-15 21:40:00","insp_carrier_name":"SPS NEW ENGLAND INC","insp_carrier_street":"98 ELM ST","insp_carrier_city":"SALISBURY","insp_carrier_state":"MA","insp_carrier_zip_code":"01952-1804","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-18T10:25:47.000000Z","updated_at":"2025-04-19T10:15:11.000000Z","inspection_violations":[{"id":13206030,"change_date":"2025-04-15 21:40:00","inspection_id":"84402434","insp_violation_id":"265625882","seq_no":"1","part_no":"393","part_no_section":"9A-HLLH","insp_viol_unit":"1","insp_unit_id":"206317244","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-18T10:53:51.000000Z","updated_at":"2025-04-18T10:58:41.000000Z","normalized_code":"3939AHLLH"},{"id":13206031,"change_date":"2025-04-15 21:40:00","inspection_id":"84402434","insp_violation_id":"265625883","seq_no":"2","part_no":"393","part_no_section":"70B1I-CDFWFMI-LT20","insp_viol_unit":"1","insp_unit_id":"206317244","insp_violation_category_id":"17","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-18T10:53:51.000000Z","updated_at":"2025-04-18T10:58:41.000000Z","normalized_code":"39370B1ICDFWFMILT20"},{"id":13206032,"change_date":"2025-04-15 21:40:00","inspection_id":"84402434","insp_violation_id":"265625884","seq_no":"3","part_no":"393","part_no_section":"70B1I-CDFWFMI-LT20","insp_viol_unit":"1","insp_unit_id":"206317244","insp_violation_category_id":"17","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-18T10:53:51.000000Z","updated_at":"2025-04-18T10:58:41.000000Z","normalized_code":"39370B1ICDFWFMILT20"},{"id":13206033,"change_date":"2025-04-15 21:40:00","inspection_id":"84402434","insp_violation_id":"265625885","seq_no":"4","part_no":"393","part_no_section":"55C2-B","insp_viol_unit":"1","insp_unit_id":"206317244","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-18T10:53:51.000000Z","updated_at":"2025-04-18T10:58:41.000000Z","normalized_code":"39355C2B"},{"id":13206034,"change_date":"2025-04-15 21:40:00","inspection_id":"84402434","insp_violation_id":"265625886","seq_no":"5","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"1","insp_unit_id":"206317244","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-18T10:53:51.000000Z","updated_at":"2025-04-18T10:58:41.000000Z","normalized_code":"39345B2BAIR"}],"inspection_per_units":[{"id":13597995,"change_date":"2025-04-15 21:40:00","inspection_id":"84402434","insp_unit_id":"206317244","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"TKT-01038","insp_unit_license":"1AA29Y","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1M1AN07Y6CM009283","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-18T10:08:55.000000Z","updated_at":"2025-04-19T09:53:05.000000Z"},{"id":13597996,"change_date":"2025-04-15 21:40:00","inspection_id":"84402434","insp_unit_id":"206317245","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"REITNOUER","insp_unit_company":"TRL117","insp_unit_license":"2214B","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1RND48A20GR037735","insp_unit_decal":"Y","insp_unit_decal_number":"35178021","created_at":"2025-04-18T10:08:55.000000Z","updated_at":"2025-04-19T09:53:05.000000Z"}]},{"id":8328664,"change_date":"2025-04-28 21:35:00","inspection_id":"84349646","dot_number":"423047","report_state":"MA","report_number":"BV00007432","insp_date":"2025-04-09 00:00:00","insp_start_time":"0319","insp_end_time":"0336","registration_date":"2025-04-28 00:00:00","region":"ET","ci_status_code":"C","location":"281H","location_desc":"H-ROWLEY","county_code_state":"MA","county_code":"009","insp_level_id":"2","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-04-09 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"514368","transaction_code":"C","transaction_date":"2025-04-09 00:00:00","upload_date":"2025-04-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00423047","upload_search_indicator":"M","census_search_date":"2025-04-09 21:40:00","snet_input_date":"2025-04-09 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-04-09 21:40:00","insp_carrier_name":"SPS NEW ENGLAND INC","insp_carrier_street":"98 ELM ST","insp_carrier_city":"SALISBURY","insp_carrier_state":"MA","insp_carrier_zip_code":"01952-1804","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-12T10:24:14.000000Z","updated_at":"2025-05-02T10:21:54.000000Z","inspection_violations":[{"id":13393624,"change_date":"2025-04-28 21:35:00","inspection_id":"84349646","insp_violation_id":"265836900","seq_no":"1","part_no":"393","part_no_section":"9A-LHLI","insp_viol_unit":"1","insp_unit_id":"206496337","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-01T10:15:41.000000Z","updated_at":"2025-05-02T10:39:26.000000Z","normalized_code":"3939ALHLI"}],"inspection_per_units":[{"id":13764977,"change_date":"2025-04-28 21:35:00","inspection_id":"84349646","insp_unit_id":"206496337","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"X81453","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1HTEUMML5RS167612","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-01T09:45:36.000000Z","updated_at":"2025-05-02T09:48:57.000000Z"}]},{"id":8202637,"change_date":"2025-03-25 21:36:00","inspection_id":"84217090","dot_number":"423047","report_state":"MA","report_number":"BV00007379","insp_date":"2025-03-25 00:00:00","insp_start_time":"0427","insp_end_time":"0445","registration_date":null,"region":"ET","ci_status_code":"C","location":"281H","location_desc":"H-ROWLEY","county_code_state":"MA","county_code":"009","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":"N","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-03-25 21:36:00","post_acc_ind":"N","gross_comb_veh_wt":"43000","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":"513041","transaction_code":"A","transaction_date":"2025-03-25 00:00:00","upload_date":"2025-03-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00423047","upload_search_indicator":"M","census_search_date":"2025-03-25 21:36:00","snet_input_date":"2025-03-25 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-03-25 21:36:00","insp_carrier_name":"SPS NEW ENGLAND INC","insp_carrier_street":"98 ELM ST","insp_carrier_city":"SALISBURY","insp_carrier_state":"MA","insp_carrier_zip_code":"01952-1804","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-28T10:14:58.000000Z","updated_at":"2025-03-29T10:20:07.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13262429,"change_date":"2025-03-25 21:36:00","inspection_id":"84217090","insp_unit_id":"205974325","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"4410B","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1M2GR6AB3LM001319","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-28T10:07:10.000000Z","updated_at":"2025-03-29T10:00:42.000000Z"}]},{"id":7813131,"change_date":"2025-02-25 21:40:00","inspection_id":"83807735","dot_number":"423047","report_state":"MA","report_number":"BV00007213","insp_date":"2025-02-07 00:00:00","insp_start_time":"0404","insp_end_time":"0420","registration_date":"2025-02-25 00:00:00","region":"ET","ci_status_code":"C","location":"281H","location_desc":"H-ROWLEY","county_code_state":"MA","county_code":"009","insp_level_id":"2","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-02-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"3","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"509075","transaction_code":"C","transaction_date":"2025-02-07 00:00:00","upload_date":"2025-02-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00423047","upload_search_indicator":"M","census_search_date":"2025-02-07 21:40:00","snet_input_date":"2025-02-07 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-02-07 21:40:00","insp_carrier_name":"SPS NEW ENGLAND INC","insp_carrier_street":"98 ELM ST","insp_carrier_city":"SALISBURY","insp_carrier_state":"MA","insp_carrier_zip_code":"01952-1804","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:00:21.000000Z","updated_at":"2025-03-17T21:00:21.000000Z","inspection_violations":[{"id":12210645,"change_date":"2025-02-25 21:40:00","inspection_id":"83807735","insp_violation_id":"264683854","seq_no":"1","part_no":"392","part_no_section":"2-SLLDL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:34.000000Z","updated_at":"2025-03-17T22:05:34.000000Z","normalized_code":"3922SLLDL"},{"id":12210646,"change_date":"2025-02-25 21:40:00","inspection_id":"83807735","insp_violation_id":"264683855","seq_no":"2","part_no":"391","part_no_section":"41A-MCPC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:34.000000Z","updated_at":"2025-03-17T22:05:34.000000Z","normalized_code":"39141AMCPC"},{"id":12210647,"change_date":"2025-02-25 21:40:00","inspection_id":"83807735","insp_violation_id":"264683856","seq_no":"3","part_no":"393","part_no_section":"22B-LPL","insp_viol_unit":"1","insp_unit_id":"205484599","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:34.000000Z","updated_at":"2025-03-17T22:05:34.000000Z","normalized_code":"39322BLPL"}],"inspection_per_units":[{"id":12609188,"change_date":"2025-02-25 21:40:00","inspection_id":"83807735","insp_unit_id":"205484599","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"S95320","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1HTMKAAN05H688962","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:54:16.000000Z","updated_at":"2025-03-17T23:54:16.000000Z"}]},{"id":7542593,"change_date":"2025-01-23 21:38:00","inspection_id":"83523449","dot_number":"423047","report_state":"MA","report_number":"CY00002980","insp_date":"2025-01-02 00:00:00","insp_start_time":"2103","insp_end_time":"2115","registration_date":"2025-01-23 00:00:00","region":"ET","ci_status_code":"C","location":"173H","location_desc":"H-LEXINGTON","county_code_state":"MA","county_code":"017","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-01-03 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"136363","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"506314","transaction_code":"C","transaction_date":"2025-01-03 00:00:00","upload_date":"2025-01-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00423047","upload_search_indicator":"M","census_search_date":"2025-01-03 21:38:00","snet_input_date":"2025-01-02 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-01-03 21:38:00","insp_carrier_name":"SPS NEW ENGLAND INC","insp_carrier_street":"98 ELM ST","insp_carrier_city":"SALISBURY","insp_carrier_state":"MA","insp_carrier_zip_code":"01952-1804","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:54:51.000000Z","updated_at":"2025-03-17T20:54:51.000000Z","inspection_violations":[{"id":11789660,"change_date":"2025-01-23 21:38:00","inspection_id":"83523449","insp_violation_id":"264140947","seq_no":"1","part_no":"392","part_no_section":"2-SLL","insp_viol_unit":"2","insp_unit_id":"204972835","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:27.000000Z","updated_at":"2025-03-17T22:03:27.000000Z","normalized_code":"3922SLL"}],"inspection_per_units":[{"id":12169182,"change_date":"2025-01-23 21:38:00","inspection_id":"83523449","insp_unit_id":"204972834","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"TKD-04035","insp_unit_license":"1AD52T","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1M2GR4NC4MM002116","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:49:20.000000Z","updated_at":"2025-03-17T23:49:20.000000Z"},{"id":12169183,"change_date":"2025-01-23 21:38:00","inspection_id":"83523449","insp_unit_id":"204972835","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAGB","insp_unit_company":null,"insp_unit_license":"F10313","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"112H8V395LL084499","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:49:20.000000Z","updated_at":"2025-03-17T23:49:20.000000Z"}]},{"id":7380062,"change_date":"2024-12-19 21:40:00","inspection_id":"83352849","dot_number":"423047","report_state":"MA","report_number":"BV00007049","insp_date":"2024-12-10 00:00:00","insp_start_time":"0309","insp_end_time":"0332","registration_date":null,"region":"ET","ci_status_code":"C","location":"142H","location_desc":"H-HAVERHILL","county_code_state":"MA","county_code":"009","insp_level_id":"2","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-12-10 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"29000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"504990","transaction_code":"C","transaction_date":"2024-12-19 00:00:00","upload_date":"2024-12-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00423047","upload_search_indicator":"M","census_search_date":"2024-12-10 21:41:00","snet_input_date":"2024-12-10 00:00:00","source_office":"1MAS001","mcmis_add_date":"2024-12-10 21:41:00","insp_carrier_name":"SPS NEW ENGLAND INC","insp_carrier_street":"98 ELM ST","insp_carrier_city":"SALISBURY","insp_carrier_state":"MA","insp_carrier_zip_code":"01952-1804","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:50:15.000000Z","updated_at":"2025-03-17T20:50:15.000000Z","inspection_violations":[{"id":11530007,"change_date":"2024-12-19 21:40:00","inspection_id":"83352849","insp_violation_id":"263570190","seq_no":"1","part_no":"393","part_no_section":"23-LEU","insp_viol_unit":"2","insp_unit_id":"204476139","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:02:06.000000Z","updated_at":"2025-03-17T22:02:06.000000Z","normalized_code":"39323LEU"}],"inspection_per_units":[{"id":11905250,"change_date":"2024-12-19 21:40:00","inspection_id":"83352849","insp_unit_id":"204476138","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"X72068","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1M2MDBAA0RS010713","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:46:28.000000Z","updated_at":"2025-03-17T23:46:28.000000Z"},{"id":11905251,"change_date":"2024-12-19 21:40:00","inspection_id":"83352849","insp_unit_id":"204476139","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WNCO","insp_unit_company":null,"insp_unit_license":"C37868","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"5F13D1417G1009596","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:46:28.000000Z","updated_at":"2025-03-17T23:46:28.000000Z"}]},{"id":7237905,"change_date":"2024-11-20 21:40:00","inspection_id":"83202879","dot_number":"423047","report_state":"MA","report_number":"CD00007913","insp_date":"2024-11-19 00:00:00","insp_start_time":"1607","insp_end_time":"1626","registration_date":null,"region":"ET","ci_status_code":"C","location":"041H","location_desc":"H-BOXFORD","county_code_state":"MA","county_code":"009","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-11-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"3","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"503845","transaction_code":"A","transaction_date":"2024-11-20 00:00:00","upload_date":"2024-11-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00423047","upload_search_indicator":"M","census_search_date":"2024-11-20 21:40:00","snet_input_date":"2024-11-19 00:00:00","source_office":"1MAS001","mcmis_add_date":"2024-11-20 21:40:00","insp_carrier_name":"SPS NEW ENGLAND INC","insp_carrier_street":"98 ELM ST","insp_carrier_city":"SALISBURY","insp_carrier_state":"MA","insp_carrier_zip_code":"01952-1804","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:46:52.000000Z","updated_at":"2025-03-17T20:46:52.000000Z","inspection_violations":[{"id":11314701,"change_date":"2024-11-20 21:40:00","inspection_id":"83202879","insp_violation_id":"262995043","seq_no":"1","part_no":"392","part_no_section":"2-SLLLR","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:56.000000Z","updated_at":"2025-03-17T22:00:56.000000Z","normalized_code":"3922SLLLR"},{"id":11314702,"change_date":"2024-11-20 21:40:00","inspection_id":"83202879","insp_violation_id":"262995044","seq_no":"2","part_no":"392","part_no_section":"2-SLLDL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:56.000000Z","updated_at":"2025-03-17T22:00:56.000000Z","normalized_code":"3922SLLDL"},{"id":11314703,"change_date":"2024-11-20 21:40:00","inspection_id":"83202879","insp_violation_id":"262995045","seq_no":"3","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"203968683","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:56.000000Z","updated_at":"2025-03-17T22:00:56.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":11674655,"change_date":"2024-11-20 21:40:00","inspection_id":"83202879","insp_unit_id":"203968683","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"TKV-14239","insp_unit_license":"W46743","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1M2MDBAA5NS00311","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:43:58.000000Z","updated_at":"2025-03-17T23:43:58.000000Z"}]},{"id":7139629,"change_date":"2024-11-12 21:40:00","inspection_id":"83098813","dot_number":"423047","report_state":"CT","report_number":"3091005671","insp_date":"2024-11-06 00:00:00","insp_start_time":"0557","insp_end_time":"0630","registration_date":"2024-11-08 00:00:00","region":"ET","ci_status_code":"C","location":"146","location_desc":"VERNON","county_code_state":"CT","county_code":"013","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SPS NEW ENGLAND INC","shipping_paper_number":"NONE","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-11-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"54780","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"722710","transaction_code":"C","transaction_date":"2024-11-06 00:00:00","upload_date":"2024-11-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00423047","upload_search_indicator":null,"census_search_date":"2024-11-07 21:40:00","snet_input_date":"2024-11-06 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-11-07 21:40:00","insp_carrier_name":"SPS NEW ENGLAND INC","insp_carrier_street":"98 ELM ST","insp_carrier_city":"SALISBURY","insp_carrier_state":"MA","insp_carrier_zip_code":"01952","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:44:43.000000Z","updated_at":"2025-03-17T20:44:43.000000Z","inspection_violations":[{"id":11152337,"change_date":"2024-11-12 21:40:00","inspection_id":"83098813","insp_violation_id":"262830785","seq_no":"1","part_no":"392","part_no_section":"2-SLLS3","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"V130733-3","created_at":"2025-03-17T22:00:06.000000Z","updated_at":"2025-03-17T22:00:06.000000Z","normalized_code":"3922SLLS3"}],"inspection_per_units":[{"id":11515136,"change_date":"2024-11-12 21:40:00","inspection_id":"83098813","insp_unit_id":"203824809","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":"TKU-14539","insp_unit_license":"1AE14F","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"5KKHBPDV2PLUG9069","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:42:20.000000Z","updated_at":"2025-03-17T23:42:20.000000Z"}]},{"id":6709353,"change_date":"2024-10-04 21:39:00","inspection_id":"82641553","dot_number":"423047","report_state":"MA","report_number":"CE00007287","insp_date":"2024-09-10 00:00:00","insp_start_time":"0553","insp_end_time":"0604","registration_date":"2024-10-04 00:00:00","region":"ET","ci_status_code":"C","location":"284H","location_desc":"H-RUSSELL","county_code_state":"MA","county_code":"013","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"499262","transaction_code":"C","transaction_date":"2024-09-12 00:00:00","upload_date":"2024-10-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00423047","upload_search_indicator":"M","census_search_date":"2024-09-12 21:41:00","snet_input_date":"2024-09-10 00:00:00","source_office":"1MAS001","mcmis_add_date":"2024-09-12 21:41:00","insp_carrier_name":"SPS NEW ENGLAND INC","insp_carrier_street":"98 ELM ST","insp_carrier_city":"SALISBURY","insp_carrier_state":"MA","insp_carrier_zip_code":"01952-1804","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:36:06.000000Z","updated_at":"2025-03-17T20:36:06.000000Z","inspection_violations":[{"id":10444987,"change_date":"2024-10-04 21:39:00","inspection_id":"82641553","insp_violation_id":"262190063","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2025-03-17T21:56:36.000000Z","updated_at":"2025-03-17T21:56:36.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10818690,"change_date":"2024-10-04 21:39:00","inspection_id":"82641553","insp_unit_id":"203271012","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"W46746","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1M2MDBAA1NS003120","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:34:59.000000Z","updated_at":"2025-03-17T23:34:59.000000Z"}]},{"id":6259751,"change_date":"2024-07-29 21:41:00","inspection_id":"82161687","dot_number":"423047","report_state":"MA","report_number":"CK00003499","insp_date":"2024-07-19 00:00:00","insp_start_time":"1120","insp_end_time":"1132","registration_date":"2024-07-29 00:00:00","region":"ET","ci_status_code":"C","location":"038S","location_desc":"S-BOSTON","county_code_state":"MA","county_code":"025","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-07-19 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"25995","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"496192","transaction_code":"C","transaction_date":"2024-07-19 00:00:00","upload_date":"2024-07-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00423047","upload_search_indicator":"M","census_search_date":"2024-07-19 21:37:00","snet_input_date":"2024-07-19 00:00:00","source_office":"1MAS001","mcmis_add_date":"2024-07-19 21:37:00","insp_carrier_name":"SPS NEW ENGLAND INC","insp_carrier_street":"98 ELM ST","insp_carrier_city":"SALISBURY","insp_carrier_state":"MA","insp_carrier_zip_code":"01952-1804","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:26:40.000000Z","updated_at":"2025-03-17T20:26:40.000000Z","inspection_violations":[{"id":9723439,"change_date":"2024-07-29 21:41:00","inspection_id":"82161687","insp_violation_id":"260888171","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:04.000000Z","updated_at":"2025-03-17T21:53:04.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10085612,"change_date":"2024-07-29 21:41:00","inspection_id":"82161687","insp_unit_id":"202116434","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"W44345","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1M2MDBAA0NS002654","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:27:32.000000Z","updated_at":"2025-03-17T23:27:32.000000Z"}]},{"id":6127739,"change_date":"2024-07-02 21:41:00","inspection_id":"82019882","dot_number":"423047","report_state":"MA","report_number":"CY00002268","insp_date":"2024-07-01 00:00:00","insp_start_time":"1955","insp_end_time":"2151","registration_date":null,"region":"ET","ci_status_code":"C","location":"173H","location_desc":"H-LEXINGTON","county_code_state":"MA","county_code":"017","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-07-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"30500","viol_total":"2","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"495146","transaction_code":"A","transaction_date":"2024-07-02 00:00:00","upload_date":"2024-07-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00423047","upload_search_indicator":"M","census_search_date":"2024-07-02 21:41:00","snet_input_date":"2024-07-01 00:00:00","source_office":"1MAS001","mcmis_add_date":"2024-07-02 21:41:00","insp_carrier_name":"SPS NEW ENGLAND INC","insp_carrier_street":"98 ELM ST","insp_carrier_city":"SALISBURY","insp_carrier_state":"MA","insp_carrier_zip_code":"01952-1804","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:24:11.000000Z","updated_at":"2025-03-17T20:24:11.000000Z","inspection_violations":[{"id":9514723,"change_date":"2024-07-02 21:41:00","inspection_id":"82019882","insp_violation_id":"260431249","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:01.000000Z","updated_at":"2025-03-17T21:52:01.000000Z","normalized_code":"3922"},{"id":9514724,"change_date":"2024-07-02 21:41:00","inspection_id":"82019882","insp_violation_id":"260431250","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:01.000000Z","updated_at":"2025-03-17T21:52:01.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9870368,"change_date":"2024-07-02 21:41:00","inspection_id":"82019882","insp_unit_id":"201696569","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"TKB-01534","insp_unit_license":"T48447","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1HTMMAAL1CH104719","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:25:17.000000Z","updated_at":"2025-03-17T23:25:17.000000Z"},{"id":9870369,"change_date":"2024-07-02 21:41:00","inspection_id":"82019882","insp_unit_id":"201696570","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"ATCO","insp_unit_company":null,"insp_unit_license":"F16300","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"4500B1419MR078982","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:25:17.000000Z","updated_at":"2025-03-17T23:25:17.000000Z"}]},{"id":6015975,"change_date":"2024-07-11 21:41:00","inspection_id":"81899691","dot_number":"423047","report_state":"MA","report_number":"DL00000287","insp_date":"2024-06-18 00:00:00","insp_start_time":"0910","insp_end_time":"0955","registration_date":"2024-07-11 00:00:00","region":"ET","ci_status_code":"C","location":"281H","location_desc":"H-ROWLEY","county_code_state":"MA","county_code":"009","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-06-18 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"25995","viol_total":"2","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"494164","transaction_code":"C","transaction_date":"2024-06-18 00:00:00","upload_date":"2024-07-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00423047","upload_search_indicator":"M","census_search_date":"2024-06-18 21:42:00","snet_input_date":"2024-06-18 00:00:00","source_office":"1MAS001","mcmis_add_date":"2024-06-18 21:42:00","insp_carrier_name":"SPS NEW ENGLAND INC","insp_carrier_street":"98 ELM ST","insp_carrier_city":"SALISBURY","insp_carrier_state":"MA","insp_carrier_zip_code":"01952-1804","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:21:54.000000Z","updated_at":"2025-03-17T20:21:54.000000Z","inspection_violations":[{"id":9334027,"change_date":"2024-07-11 21:41:00","inspection_id":"81899691","insp_violation_id":"260584868","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"717139AC","created_at":"2025-03-17T21:51:08.000000Z","updated_at":"2025-03-17T21:51:08.000000Z","normalized_code":"3922"},{"id":9334028,"change_date":"2024-07-11 21:41:00","inspection_id":"81899691","insp_violation_id":"260584869","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:08.000000Z","updated_at":"2025-03-17T21:51:08.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9689671,"change_date":"2024-07-11 21:41:00","inspection_id":"81899691","insp_unit_id":"201834526","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"TKD-04135","insp_unit_license":"W44346","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1M2MDBAA8NS002658","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:23:24.000000Z","updated_at":"2025-03-17T23:23:24.000000Z"}]},{"id":5972279,"change_date":"2024-07-11 21:41:00","inspection_id":"81852356","dot_number":"423047","report_state":"MA","report_number":"CE00007119","insp_date":"2024-06-12 00:00:00","insp_start_time":"0330","insp_end_time":"0513","registration_date":"2024-07-11 00:00:00","region":"ET","ci_status_code":"C","location":"364H","location_desc":"H-WEST STOCKBRIDGE","county_code_state":"MA","county_code":"003","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-06-12 21:42:00","post_acc_ind":"Y","gross_comb_veh_wt":"26000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"493723","transaction_code":"C","transaction_date":"2024-06-12 00:00:00","upload_date":"2024-07-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00423047","upload_search_indicator":"M","census_search_date":"2024-06-12 21:42:00","snet_input_date":"2024-06-12 00:00:00","source_office":"1MAS001","mcmis_add_date":"2024-06-12 21:42:00","insp_carrier_name":"SPS NEW ENGLAND INC","insp_carrier_street":"98 ELM ST","insp_carrier_city":"SALISBURY","insp_carrier_state":"MA","insp_carrier_zip_code":"01952-1804","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:21:05.000000Z","updated_at":"2025-03-17T20:21:05.000000Z","inspection_violations":[{"id":9264934,"change_date":"2024-07-11 21:41:00","inspection_id":"81852356","insp_violation_id":"260584919","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:51.000000Z","updated_at":"2025-03-17T21:50:51.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9619927,"change_date":"2024-07-11 21:41:00","inspection_id":"81852356","insp_unit_id":"201834552","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"W47257","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"3ALACWFC2NDNH3092","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:22:43.000000Z","updated_at":"2025-03-17T23:22:43.000000Z"}]},{"id":5917263,"change_date":"2024-06-05 21:41:00","inspection_id":"81792593","dot_number":"423047","report_state":"MA","report_number":"CD00007462","insp_date":"2024-06-05 00:00:00","insp_start_time":"0509","insp_end_time":"0619","registration_date":null,"region":"ET","ci_status_code":"C","location":"041H","location_desc":"H-BOXFORD","county_code_state":"MA","county_code":"009","insp_level_id":"1","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-06-05 21:41:00","post_acc_ind":"Y","gross_comb_veh_wt":"79200","viol_total":"5","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"493165","transaction_code":"A","transaction_date":"2024-06-05 00:00:00","upload_date":"2024-06-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00423047","upload_search_indicator":"M","census_search_date":"2024-06-05 21:41:00","snet_input_date":"2024-06-05 00:00:00","source_office":"1MAS001","mcmis_add_date":"2024-06-05 21:41:00","insp_carrier_name":"SPS NEW ENGLAND INC","insp_carrier_street":"98 ELM ST","insp_carrier_city":"SALISBURY","insp_carrier_state":"MA","insp_carrier_zip_code":"01952-1804","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:19:53.000000Z","updated_at":"2025-03-17T20:19:53.000000Z","inspection_violations":[{"id":9176214,"change_date":"2024-06-05 21:41:00","inspection_id":"81792593","insp_violation_id":"259914796","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:20.000000Z","updated_at":"2025-03-17T21:50:20.000000Z","normalized_code":"3922"},{"id":9176215,"change_date":"2024-06-05 21:41:00","inspection_id":"81792593","insp_violation_id":"259914797","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"201242659","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:50:20.000000Z","updated_at":"2025-03-17T21:50:20.000000Z","normalized_code":"3939A"},{"id":9176216,"change_date":"2024-06-05 21:41:00","inspection_id":"81792593","insp_violation_id":"259914798","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"201242659","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:50:20.000000Z","updated_at":"2025-03-17T21:50:20.000000Z","normalized_code":"3939A"},{"id":9176217,"change_date":"2024-06-05 21:41:00","inspection_id":"81792593","insp_violation_id":"259914799","seq_no":"4","part_no":"393","part_no_section":"203","insp_viol_unit":"1","insp_unit_id":"201242659","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:20.000000Z","updated_at":"2025-03-17T21:50:20.000000Z","normalized_code":"393203"},{"id":9176218,"change_date":"2024-06-05 21:41:00","inspection_id":"81792593","insp_violation_id":"259914800","seq_no":"5","part_no":"393","part_no_section":"75(a)","insp_viol_unit":"1","insp_unit_id":"201242659","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:50:20.000000Z","updated_at":"2025-03-17T21:50:20.000000Z","normalized_code":"39375A"}],"inspection_per_units":[{"id":9530811,"change_date":"2024-06-05 21:41:00","inspection_id":"81792593","insp_unit_id":"201242659","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"11539","insp_unit_license":"3547B","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1M2GR2GC4LM012676","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:21:52.000000Z","updated_at":"2025-03-17T23:21:52.000000Z"}]},{"id":5927165,"change_date":"2024-06-06 21:41:00","inspection_id":"81803357","dot_number":"423047","report_state":"MA","report_number":"DL00000247","insp_date":"2024-06-05 00:00:00","insp_start_time":"1839","insp_end_time":"1858","registration_date":"2024-06-06 00:00:00","region":"ET","ci_status_code":"C","location":"120H","location_desc":"H-GEORGETOWN","county_code_state":"MA","county_code":"009","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-06-06 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"493248","transaction_code":"A","transaction_date":"2024-06-06 00:00:00","upload_date":"2024-06-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00423047","upload_search_indicator":"M","census_search_date":"2024-06-06 21:41:00","snet_input_date":"2024-06-05 00:00:00","source_office":"1MAS001","mcmis_add_date":"2024-06-06 21:41:00","insp_carrier_name":"SPS NEW ENGLAND INC","insp_carrier_street":"98 ELM ST","insp_carrier_city":"SALISBURY","insp_carrier_state":"MA","insp_carrier_zip_code":"01952-1804","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:20:15.000000Z","updated_at":"2025-03-17T20:20:15.000000Z","inspection_violations":[{"id":9191439,"change_date":"2024-06-06 21:41:00","inspection_id":"81803357","insp_violation_id":"259936438","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:50:26.000000Z","updated_at":"2025-03-17T21:50:26.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":9546778,"change_date":"2024-06-06 21:41:00","inspection_id":"81803357","insp_unit_id":"201262682","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"TKD03835","insp_unit_license":"W63239","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1M2MDBAA5NS001841","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:22:01.000000Z","updated_at":"2025-03-17T23:22:01.000000Z"}]},{"id":5187677,"change_date":"2024-03-19 21:44:00","inspection_id":"80997880","dot_number":"423047","report_state":"MA","report_number":"CD00007171","insp_date":"2024-02-29 00:00:00","insp_start_time":"1610","insp_end_time":"1629","registration_date":"2024-03-19 00:00:00","region":"ET","ci_status_code":"C","location":"227H","location_desc":"H-NEWBURY","county_code_state":"MA","county_code":"009","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-03-01 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"26950","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"486409","transaction_code":"C","transaction_date":"2024-03-01 00:00:00","upload_date":"2024-03-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00423047","upload_search_indicator":"M","census_search_date":"2024-03-01 21:39:00","snet_input_date":"2024-02-29 00:00:00","source_office":"1MAS001","mcmis_add_date":"2024-03-01 21:39:00","insp_carrier_name":"SPS NEW ENGLAND INC","insp_carrier_street":"98 ELM ST","insp_carrier_city":"SALISBURY","insp_carrier_state":"MA","insp_carrier_zip_code":"01952-1804","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:05:21.000000Z","updated_at":"2025-03-17T20:05:21.000000Z","inspection_violations":[{"id":7995144,"change_date":"2024-03-19 21:44:00","inspection_id":"80997880","insp_violation_id":"258456892","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:37.000000Z","updated_at":"2025-03-17T21:44:37.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8352925,"change_date":"2024-03-19 21:44:00","inspection_id":"80997880","insp_unit_id":"199976843","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"TKV-10839","insp_unit_license":"V68384","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"5PVNV8JV6K4S58924","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:10:40.000000Z","updated_at":"2025-03-17T23:10:40.000000Z"},{"id":8352926,"change_date":"2024-03-19 21:44:00","inspection_id":"80997880","insp_unit_id":"199976844","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"VERM","insp_unit_company":null,"insp_unit_license":"D46436","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"2S9US1113GS13241","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:10:40.000000Z","updated_at":"2025-03-17T23:10:40.000000Z"}]},{"id":4524939,"change_date":"2023-11-30 21:38:00","inspection_id":"80273274","dot_number":"423047","report_state":"MA","report_number":"DS00000230","insp_date":"2023-11-29 00:00:00","insp_start_time":"1647","insp_end_time":"1703","registration_date":null,"region":"ET","ci_status_code":"C","location":"253H","location_desc":"H-PEABODY","county_code_state":"MA","county_code":"009","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-11-30 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"35989","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":"479843","transaction_code":"A","transaction_date":"2023-11-30 00:00:00","upload_date":"2023-11-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00423047","upload_search_indicator":"M","census_search_date":"2023-11-30 21:38:00","snet_input_date":"2023-11-29 00:00:00","source_office":"1MAS001","mcmis_add_date":"2023-11-30 21:38:00","insp_carrier_name":"SPS NEW ENGLAND INC","insp_carrier_street":"98 ELM ST","insp_carrier_city":"SALISBURY","insp_carrier_state":"MA","insp_carrier_zip_code":"01952-1804","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:52:33.000000Z","updated_at":"2025-03-17T19:52:33.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7277319,"change_date":"2023-11-30 21:38:00","inspection_id":"80273274","insp_unit_id":"198277901","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"3573B","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FDXF7DC2KDF06592","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:08.000000Z","updated_at":"2025-03-17T23:01:08.000000Z"},{"id":7277320,"change_date":"2023-11-30 21:38:00","inspection_id":"80273274","insp_unit_id":"198277902","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"PJTM","insp_unit_company":null,"insp_unit_license":"D37716","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"4P5F82223F3011715","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:08.000000Z","updated_at":"2025-03-17T23:01:08.000000Z"}]},{"id":4370481,"change_date":"2023-11-07 21:40:00","inspection_id":"80102853","dot_number":"423047","report_state":"NH","report_number":"0945003681","insp_date":"2023-11-06 00:00:00","insp_start_time":"1030","insp_end_time":"1115","registration_date":null,"region":"ET","ci_status_code":"C","location":"237","location_desc":"WINDHAM SCALES NORTHBOUND","county_code_state":"NH","county_code":"015","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SPS NEW ENGLAND INC","shipping_paper_number":"NONE","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":"N","pen_cen_match":null,"final_status_date":"2023-11-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"54600","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":"270697","transaction_code":"A","transaction_date":"2023-11-06 00:00:00","upload_date":"2023-11-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00423047","upload_search_indicator":null,"census_search_date":"2023-11-07 21:40:00","snet_input_date":"2023-11-06 00:00:00","source_office":"1NHS001","mcmis_add_date":"2023-11-07 21:40:00","insp_carrier_name":"SPS NEW ENGLAND INC","insp_carrier_street":"98 ELM ST","insp_carrier_city":"SALISBURY","insp_carrier_state":"MA","insp_carrier_zip_code":"01952","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:49:32.000000Z","updated_at":"2025-03-17T19:49:32.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7029021,"change_date":"2023-11-07 21:40:00","inspection_id":"80102853","insp_unit_id":"197939984","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"1AD56D","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1M2GR6GCXKM001283","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:59.000000Z","updated_at":"2025-03-17T22:58:59.000000Z"}]},{"id":4339716,"change_date":"2023-11-02 21:41:00","inspection_id":"80068994","dot_number":"423047","report_state":"NH","report_number":"0945003659","insp_date":"2023-11-01 00:00:00","insp_start_time":"1103","insp_end_time":"1200","registration_date":null,"region":"ET","ci_status_code":"C","location":"237","location_desc":"WINDHAM SCALES NORTHBOUND","county_code_state":"NH","county_code":"015","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SPS NEW ENGLAND INC","shipping_paper_number":"NONE","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":"N","pen_cen_match":null,"final_status_date":"2023-11-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25995","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":"270538","transaction_code":"A","transaction_date":"2023-11-01 00:00:00","upload_date":"2023-11-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00423047","upload_search_indicator":null,"census_search_date":"2023-11-02 21:41:00","snet_input_date":"2023-11-01 00:00:00","source_office":"1NHS001","mcmis_add_date":"2023-11-02 21:41:00","insp_carrier_name":"SPS NEW ENGLAND INC","insp_carrier_street":"98 ELM ST","insp_carrier_city":"SALISBURY","insp_carrier_state":"MA","insp_carrier_zip_code":"01952","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:48:47.000000Z","updated_at":"2025-03-17T19:48:47.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6979406,"change_date":"2023-11-02 21:41:00","inspection_id":"80068994","insp_unit_id":"197872256","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"W63239","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1M2MDBAA5NS001841","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:34.000000Z","updated_at":"2025-03-17T22:58:34.000000Z"}]},{"id":3090597,"change_date":"2023-06-08 21:41:00","inspection_id":"78672785","dot_number":"423047","report_state":"MA","report_number":"CD00006303","insp_date":"2023-05-18 00:00:00","insp_start_time":"1919","insp_end_time":"1937","registration_date":"2023-06-08 00:00:00","region":"ET","ci_status_code":"C","location":"281H","location_desc":"H-ROWLEY","county_code_state":"MA","county_code":"009","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-05-19 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"26950","viol_total":"2","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"466248","transaction_code":"C","transaction_date":"2023-05-19 00:00:00","upload_date":"2023-06-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00423047","upload_search_indicator":"M","census_search_date":"2023-05-19 21:42:00","snet_input_date":"2023-05-18 00:00:00","source_office":"1MAS001","mcmis_add_date":"2023-05-19 21:42:00","insp_carrier_name":"SPS NEW ENGLAND INC","insp_carrier_street":"98 ELM ST","insp_carrier_city":"SALISBURY","insp_carrier_state":"MA","insp_carrier_zip_code":"01952-1804","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:24:11.000000Z","updated_at":"2025-03-17T19:24:11.000000Z","inspection_violations":[{"id":4752362,"change_date":"2023-06-08 21:41:00","inspection_id":"78672785","insp_violation_id":"253377877","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:08.000000Z","updated_at":"2025-03-17T21:29:08.000000Z","normalized_code":"3922"},{"id":4752363,"change_date":"2023-06-08 21:41:00","inspection_id":"78672785","insp_violation_id":"253377878","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:08.000000Z","updated_at":"2025-03-17T21:29:08.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4971430,"change_date":"2023-06-08 21:41:00","inspection_id":"78672785","insp_unit_id":"195389258","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"523","insp_unit_license":"V66130","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"5PVNV8JV8K4S58925","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:12.000000Z","updated_at":"2025-03-17T22:42:12.000000Z"},{"id":4971431,"change_date":"2023-06-08 21:41:00","inspection_id":"78672785","insp_unit_id":"195389259","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"VERME","insp_unit_company":null,"insp_unit_license":"D14587","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"2S9US1111FS132711","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:12.000000Z","updated_at":"2025-03-17T22:42:12.000000Z"}]},{"id":3090642,"change_date":"2023-06-08 21:41:00","inspection_id":"78672833","dot_number":"423047","report_state":"MA","report_number":"CH00004744","insp_date":"2023-05-18 00:00:00","insp_start_time":"1845","insp_end_time":"1900","registration_date":"2023-06-08 00:00:00","region":"ET","ci_status_code":"C","location":"281H","location_desc":"H-ROWLEY","county_code_state":"MA","county_code":"009","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-05-19 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"69000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"466307","transaction_code":"C","transaction_date":"2023-05-19 00:00:00","upload_date":"2023-06-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00423047","upload_search_indicator":"M","census_search_date":"2023-05-19 21:42:00","snet_input_date":"2023-05-18 00:00:00","source_office":"1MAS001","mcmis_add_date":"2023-05-19 21:42:00","insp_carrier_name":"SPS NEW ENGLAND INC","insp_carrier_street":"98 ELM ST","insp_carrier_city":"SALISBURY","insp_carrier_state":"MA","insp_carrier_zip_code":"01952-1804","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:24:11.000000Z","updated_at":"2025-03-17T19:24:11.000000Z","inspection_violations":[{"id":4752417,"change_date":"2023-06-08 21:41:00","inspection_id":"78672833","insp_violation_id":"253377957","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:08.000000Z","updated_at":"2025-03-17T21:29:08.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4971492,"change_date":"2023-06-08 21:41:00","inspection_id":"78672833","insp_unit_id":"195389299","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"N94965","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"3020043811M2P199C","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:12.000000Z","updated_at":"2025-03-17T22:42:12.000000Z"},{"id":4971493,"change_date":"2023-06-08 21:41:00","inspection_id":"78672833","insp_unit_id":"195389300","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"STON","insp_unit_company":null,"insp_unit_license":"E61844","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"302004381","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:12.000000Z","updated_at":"2025-03-17T22:42:12.000000Z"}]},{"id":2452045,"change_date":"2023-03-06 21:40:00","inspection_id":"77948237","dot_number":"423047","report_state":"MA","report_number":"CD00006027","insp_date":"2023-02-27 00:00:00","insp_start_time":"0527","insp_end_time":"0548","registration_date":"2023-03-06 00:00:00","region":"ET","ci_status_code":"C","location":"253H","location_desc":"H-PEABODY","county_code_state":"MA","county_code":"009","insp_level_id":"2","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":"N","pen_cen_match":null,"final_status_date":"2023-02-27 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"130000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"461186","transaction_code":"C","transaction_date":"2023-02-27 00:00:00","upload_date":"2023-03-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00423047","upload_search_indicator":"M","census_search_date":"2023-02-27 21:41:00","snet_input_date":"2023-02-27 00:00:00","source_office":"1MAS001","mcmis_add_date":"2023-02-27 21:41:00","insp_carrier_name":"SPS NEW ENGLAND INC","insp_carrier_street":"98 ELM ST","insp_carrier_city":"SALISBURY","insp_carrier_state":"MA","insp_carrier_zip_code":"01952-1804","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:11:48.000000Z","updated_at":"2025-03-17T19:11:48.000000Z","inspection_violations":[{"id":3775198,"change_date":"2023-03-06 21:40:00","inspection_id":"77948237","insp_violation_id":"251483787","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"193713120","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:24:45.000000Z","updated_at":"2025-03-17T21:24:45.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":3945911,"change_date":"2023-03-06 21:40:00","inspection_id":"77948237","insp_unit_id":"193713119","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"TKT-00738","insp_unit_license":"5564B","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1M1AN07Y2GM022912","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:16.000000Z","updated_at":"2025-03-17T22:34:16.000000Z"},{"id":3945912,"change_date":"2023-03-06 21:40:00","inspection_id":"77948237","insp_unit_id":"193713120","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LNDR","insp_unit_company":null,"insp_unit_license":"F26820","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1LH855WJ7F1C22458","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:16.000000Z","updated_at":"2025-03-17T22:34:16.000000Z"}]},{"id":2330888,"change_date":"2023-02-09 21:39:00","inspection_id":"77809641","dot_number":"423047","report_state":"NH","report_number":"0945003555","insp_date":"2023-02-07 00:00:00","insp_start_time":"1000","insp_end_time":"1045","registration_date":null,"region":"ET","ci_status_code":"C","location":"237","location_desc":"WINDHAM SCALES NORTHBOUND","county_code_state":"NH","county_code":"015","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SPS NEW ENGLAND INC","shipping_paper_number":"N\/A","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":"N","pen_cen_match":null,"final_status_date":"2023-02-09 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"264159","transaction_code":"A","transaction_date":"2023-02-07 00:00:00","upload_date":"2023-02-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00423047","upload_search_indicator":null,"census_search_date":"2023-02-09 21:39:00","snet_input_date":"2023-02-07 00:00:00","source_office":"1NHS001","mcmis_add_date":"2023-02-09 21:39:00","insp_carrier_name":"SPS NEW ENGLAND INC","insp_carrier_street":"98 ELM ST","insp_carrier_city":"SALISBURY","insp_carrier_state":"MA","insp_carrier_zip_code":"01952","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:09:38.000000Z","updated_at":"2025-03-17T19:09:38.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3751069,"change_date":"2023-02-09 21:39:00","inspection_id":"77809641","insp_unit_id":"193306258","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"X14107","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FDNF6ANXPDF02580","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:52.000000Z","updated_at":"2025-03-17T22:32:52.000000Z"}]},{"id":2071305,"change_date":"2023-02-16 21:41:00","inspection_id":"77513243","dot_number":"423047","report_state":"MA","report_number":"CD00005835","insp_date":"2023-01-04 00:00:00","insp_start_time":"1424","insp_end_time":"1451","registration_date":"2023-02-16 00:00:00","region":"ET","ci_status_code":"C","location":"281H","location_desc":"H-ROWLEY","county_code_state":"MA","county_code":"009","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":"N","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":"N","pen_cen_match":null,"final_status_date":"2023-01-05 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"16000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"458111","transaction_code":"C","transaction_date":"2023-01-05 00:00:00","upload_date":"2023-02-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00423047","upload_search_indicator":"M","census_search_date":"2023-01-05 21:39:00","snet_input_date":"2023-01-04 00:00:00","source_office":"1MAS001","mcmis_add_date":"2023-01-05 21:39:00","insp_carrier_name":"SPS NEW ENGLAND INC","insp_carrier_street":"98 ELM ST","insp_carrier_city":"SALISBURY","insp_carrier_state":"MA","insp_carrier_zip_code":"01952-1804","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:04:46.000000Z","updated_at":"2025-03-17T19:04:46.000000Z","inspection_violations":[{"id":3207114,"change_date":"2023-02-16 21:41:00","inspection_id":"77513243","insp_violation_id":"251167557","seq_no":"1","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"193427068","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:12.000000Z","updated_at":"2025-03-17T21:22:12.000000Z","normalized_code":"39395F"},{"id":3207115,"change_date":"2023-02-16 21:41:00","inspection_id":"77513243","insp_violation_id":"251167558","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193427068","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:12.000000Z","updated_at":"2025-03-17T21:22:12.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3332419,"change_date":"2023-02-16 21:41:00","inspection_id":"77513243","insp_unit_id":"193427068","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"V79201","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1HTKSSWH6LH083194","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:29:51.000000Z","updated_at":"2025-03-17T22:29:51.000000Z"}]},{"id":1897754,"change_date":"2023-02-16 21:41:00","inspection_id":"77314785","dot_number":"423047","report_state":"MA","report_number":"CD00005767","insp_date":"2022-12-08 00:00:00","insp_start_time":"0504","insp_end_time":"0525","registration_date":"2023-02-16 00:00:00","region":"ET","ci_status_code":"C","location":"281H","location_desc":"H-ROWLEY","county_code_state":"MA","county_code":"009","insp_level_id":"2","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":"N","pen_cen_match":null,"final_status_date":"2022-12-08 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"18000","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"456746","transaction_code":"C","transaction_date":"2022-12-08 00:00:00","upload_date":"2023-02-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00423047","upload_search_indicator":"M","census_search_date":"2022-12-08 21:40:00","snet_input_date":"2022-12-08 00:00:00","source_office":"1MAS001","mcmis_add_date":"2022-12-08 21:40:00","insp_carrier_name":"SPS NEW ENGLAND INC","insp_carrier_street":"98 ELM ST","insp_carrier_city":"SALISBURY","insp_carrier_state":"MA","insp_carrier_zip_code":"01952-1804","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:01:32.000000Z","updated_at":"2025-03-17T19:01:32.000000Z","inspection_violations":[{"id":2953056,"change_date":"2023-02-16 21:41:00","inspection_id":"77314785","insp_violation_id":"251167192","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:03.000000Z","updated_at":"2025-03-17T21:21:03.000000Z","normalized_code":"3922"},{"id":2953057,"change_date":"2023-02-16 21:41:00","inspection_id":"77314785","insp_violation_id":"251167193","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"193426879","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:03.000000Z","updated_at":"2025-03-17T21:21:03.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":3054134,"change_date":"2023-02-16 21:41:00","inspection_id":"77314785","insp_unit_id":"193426879","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"W50027","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FD0X5HN6MED94374","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:54.000000Z","updated_at":"2025-03-17T22:27:54.000000Z"}]},{"id":1693891,"change_date":"2023-02-16 21:41:00","inspection_id":"77081369","dot_number":"423047","report_state":"MA","report_number":"BV00005956","insp_date":"2022-11-08 00:00:00","insp_start_time":"0517","insp_end_time":"0533","registration_date":"2023-02-16 00:00:00","region":"ET","ci_status_code":"C","location":"291H","location_desc":"H-SAUGUS","county_code_state":"MA","county_code":"009","insp_level_id":"2","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-11-08 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"28000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"454939","transaction_code":"C","transaction_date":"2022-11-08 00:00:00","upload_date":"2023-02-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00423047","upload_search_indicator":"M","census_search_date":"2022-11-08 21:38:00","snet_input_date":"2022-11-08 00:00:00","source_office":"1MAS001","mcmis_add_date":"2022-11-08 21:38:00","insp_carrier_name":"SPS NEW ENGLAND INC","insp_carrier_street":"98 ELM ST","insp_carrier_city":"SALISBURY","insp_carrier_state":"MA","insp_carrier_zip_code":"01952-1804","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:57:47.000000Z","updated_at":"2025-03-17T18:57:47.000000Z","inspection_violations":[{"id":2655760,"change_date":"2023-02-16 21:41:00","inspection_id":"77081369","insp_violation_id":"251166576","seq_no":"1","part_no":"393","part_no_section":"23","insp_viol_unit":"2","insp_unit_id":"193426612","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:19:29.000000Z","updated_at":"2025-03-17T21:19:29.000000Z","normalized_code":"39323"}],"inspection_per_units":[{"id":2725077,"change_date":"2023-02-16 21:41:00","inspection_id":"77081369","insp_unit_id":"193426611","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"V92287","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"3ALACWFC6MDMK3232","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:40.000000Z","updated_at":"2025-03-17T22:25:40.000000Z"},{"id":2725078,"change_date":"2023-02-16 21:41:00","inspection_id":"77081369","insp_unit_id":"193426612","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"AIRMA","insp_unit_company":null,"insp_unit_license":"852493","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"536A12212","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:40.000000Z","updated_at":"2025-03-17T22:25:40.000000Z"}]},{"id":1568406,"change_date":"2022-10-21 21:39:00","inspection_id":"76937486","dot_number":"423047","report_state":"NH","report_number":"0945003240","insp_date":"2022-10-20 00:00:00","insp_start_time":"0800","insp_end_time":"0830","registration_date":null,"region":"ET","ci_status_code":"C","location":"088","location_desc":"DURHAM","county_code_state":"NH","county_code":"017","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SPS NEW ENGLAND INC","shipping_paper_number":"NONE","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":"N","pen_cen_match":null,"final_status_date":"2022-10-21 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"43000","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":"261552","transaction_code":"A","transaction_date":"2022-10-20 00:00:00","upload_date":"2022-10-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00423047","upload_search_indicator":null,"census_search_date":"2022-10-21 21:39:00","snet_input_date":"2022-10-20 00:00:00","source_office":"1NHS001","mcmis_add_date":"2022-10-21 21:39:00","insp_carrier_name":"SPS NEW ENGLAND INC","insp_carrier_street":"98 ELM ST","insp_carrier_city":"SALISBURY","insp_carrier_state":"MA","insp_carrier_zip_code":"01952","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:55:35.000000Z","updated_at":"2025-03-17T18:55:35.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2524153,"change_date":"2022-10-21 21:39:00","inspection_id":"76937486","insp_unit_id":"191566585","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"4104A","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1HTMMAANX3H589363","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:17.000000Z","updated_at":"2025-03-17T22:24:17.000000Z"}]},{"id":1568044,"change_date":"2023-02-16 21:41:00","inspection_id":"76937071","dot_number":"423047","report_state":"MA","report_number":"CV00001570","insp_date":"2022-10-20 00:00:00","insp_start_time":"1508","insp_end_time":"1521","registration_date":"2023-02-16 00:00:00","region":"ET","ci_status_code":"C","location":"366H","location_desc":"H-WESTFIELD","county_code_state":"MA","county_code":"013","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","shipping_paper_number":"NONE","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-10-21 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"126363","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"453940","transaction_code":"C","transaction_date":"2022-10-21 00:00:00","upload_date":"2023-02-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00423047","upload_search_indicator":"M","census_search_date":"2022-10-21 21:38:00","snet_input_date":"2022-10-20 00:00:00","source_office":"1MAS001","mcmis_add_date":"2022-10-21 21:38:00","insp_carrier_name":"SPS NEW ENGLAND INC","insp_carrier_street":"98 ELM ST","insp_carrier_city":"SALISBURY","insp_carrier_state":"MA","insp_carrier_zip_code":"01952-1804","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:55:35.000000Z","updated_at":"2025-03-17T18:55:35.000000Z","inspection_violations":[{"id":2465878,"change_date":"2023-02-16 21:41:00","inspection_id":"76937071","insp_violation_id":"251169065","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"193427772","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"641942AB","created_at":"2025-03-17T21:18:34.000000Z","updated_at":"2025-03-17T21:18:34.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":2523673,"change_date":"2023-02-16 21:41:00","inspection_id":"76937071","insp_unit_id":"193427771","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"TKD03435","insp_unit_license":"T48426","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1M2AX04C9DM016373","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:17.000000Z","updated_at":"2025-03-17T22:24:17.000000Z"},{"id":2523674,"change_date":"2023-02-16 21:41:00","inspection_id":"76937071","insp_unit_id":"193427772","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAGB","insp_unit_company":null,"insp_unit_license":"F10313","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"112H8V395LL084499","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:17.000000Z","updated_at":"2025-03-17T22:24:17.000000Z"}]},{"id":1383358,"change_date":"2022-10-11 21:40:00","inspection_id":"76723248","dot_number":"423047","report_state":"MA","report_number":"CB00007479","insp_date":"2022-09-28 00:00:00","insp_start_time":"0803","insp_end_time":"0818","registration_date":"2022-10-11 00:00:00","region":"ET","ci_status_code":"C","location":"304H","location_desc":"H-SOUTH BOSTON","county_code_state":"MA","county_code":"025","insp_level_id":"2","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-09-28 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"452698","transaction_code":"C","transaction_date":"2022-09-28 00:00:00","upload_date":"2022-10-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00423047","upload_search_indicator":"M","census_search_date":"2022-09-28 21:40:00","snet_input_date":"2022-09-28 00:00:00","source_office":"1MAS001","mcmis_add_date":"2022-09-28 21:40:00","insp_carrier_name":"SPS NEW ENGLAND INC","insp_carrier_street":"98 ELM ST","insp_carrier_city":"SALISBURY","insp_carrier_state":"MA","insp_carrier_zip_code":"01952-1804","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:52:18.000000Z","updated_at":"2025-03-17T18:52:18.000000Z","inspection_violations":[{"id":2186554,"change_date":"2022-10-11 21:40:00","inspection_id":"76723248","insp_violation_id":"248928564","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:01.000000Z","updated_at":"2025-03-17T21:17:01.000000Z","normalized_code":"3922"},{"id":2186555,"change_date":"2022-10-11 21:40:00","inspection_id":"76723248","insp_violation_id":"248928565","seq_no":"2","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"191355331","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:01.000000Z","updated_at":"2025-03-17T21:17:01.000000Z","normalized_code":"39395A"}],"inspection_per_units":[{"id":2227702,"change_date":"2022-10-11 21:40:00","inspection_id":"76723248","insp_unit_id":"191355331","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"W44346","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1M2MDBAA8NS002658","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:22:15.000000Z","updated_at":"2025-03-17T22:22:15.000000Z"}]},{"id":1166467,"change_date":"2022-10-11 21:40:00","inspection_id":"76471657","dot_number":"423047","report_state":"MA","report_number":"BV00005794","insp_date":"2022-08-30 00:00:00","insp_start_time":"0524","insp_end_time":"0542","registration_date":"2022-10-11 00:00:00","region":"ET","ci_status_code":"C","location":"291H","location_desc":"H-SAUGUS","county_code_state":"MA","county_code":"009","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-08-30 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"18000","viol_total":"2","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"451137","transaction_code":"C","transaction_date":"2022-08-30 00:00:00","upload_date":"2022-10-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00423047","upload_search_indicator":"M","census_search_date":"2022-08-30 21:40:00","snet_input_date":"2022-08-30 00:00:00","source_office":"1MAS001","mcmis_add_date":"2022-08-30 21:40:00","insp_carrier_name":"SPS NEW ENGLAND INC","insp_carrier_street":"98 ELM ST","insp_carrier_city":"SALISBURY","insp_carrier_state":"MA","insp_carrier_zip_code":"01952-1804","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:48:17.000000Z","updated_at":"2025-03-17T18:48:17.000000Z","inspection_violations":[{"id":1849678,"change_date":"2022-10-11 21:40:00","inspection_id":"76471657","insp_violation_id":"248928789","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:33.000000Z","updated_at":"2025-03-17T21:15:33.000000Z","normalized_code":"3922"},{"id":1849679,"change_date":"2022-10-11 21:40:00","inspection_id":"76471657","insp_violation_id":"248928790","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:33.000000Z","updated_at":"2025-03-17T21:15:33.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1875804,"change_date":"2022-10-11 21:40:00","inspection_id":"76471657","insp_unit_id":"191355438","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"W50027","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FD0X5HN6MED94374","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:55.000000Z","updated_at":"2025-03-17T22:19:55.000000Z"}]},{"id":1153385,"change_date":"2022-10-11 21:40:00","inspection_id":"76456555","dot_number":"423047","report_state":"MA","report_number":"BV00005789","insp_date":"2022-08-28 00:00:00","insp_start_time":"1902","insp_end_time":"1919","registration_date":"2022-10-11 00:00:00","region":"ET","ci_status_code":"C","location":"281H","location_desc":"H-ROWLEY","county_code_state":"MA","county_code":"009","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-08-29 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"2","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"450811","transaction_code":"C","transaction_date":"2022-08-29 00:00:00","upload_date":"2022-10-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00423047","upload_search_indicator":"M","census_search_date":"2022-08-29 21:41:00","snet_input_date":"2022-08-28 00:00:00","source_office":"1MAS001","mcmis_add_date":"2022-08-29 21:41:00","insp_carrier_name":"SPS NEW ENGLAND INC","insp_carrier_street":"98 ELM ST","insp_carrier_city":"SALISBURY","insp_carrier_state":"MA","insp_carrier_zip_code":"01952-1804","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:47:56.000000Z","updated_at":"2025-03-17T18:47:56.000000Z","inspection_violations":[{"id":1828564,"change_date":"2022-10-11 21:40:00","inspection_id":"76456555","insp_violation_id":"248928783","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"11","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:29.000000Z","updated_at":"2025-03-17T21:15:29.000000Z","normalized_code":"39216A"},{"id":1828565,"change_date":"2022-10-11 21:40:00","inspection_id":"76456555","insp_violation_id":"248928784","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:29.000000Z","updated_at":"2025-03-17T21:15:29.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1854344,"change_date":"2022-10-11 21:40:00","inspection_id":"76456555","insp_unit_id":"191355435","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"V87724","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"3ALACWFC4MDMK3231","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:45.000000Z","updated_at":"2025-03-17T22:19:45.000000Z"}]},{"id":1041610,"change_date":"2022-10-11 21:40:00","inspection_id":"76325669","dot_number":"423047","report_state":"MA","report_number":"CD00005405","insp_date":"2022-08-16 00:00:00","insp_start_time":"0521","insp_end_time":"0539","registration_date":"2022-10-11 00:00:00","region":"ET","ci_status_code":"C","location":"083H","location_desc":"H-DANVERS","county_code_state":"MA","county_code":"009","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":"N","pen_cen_match":null,"final_status_date":"2022-08-16 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"13000","viol_total":"3","oos_total":"0","driver_viol_total":"3","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"450387","transaction_code":"C","transaction_date":"2022-08-16 00:00:00","upload_date":"2022-10-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00423047","upload_search_indicator":"M","census_search_date":"2022-08-16 21:38:00","snet_input_date":"2022-08-16 00:00:00","source_office":"1MAS001","mcmis_add_date":"2022-08-16 21:38:00","insp_carrier_name":"SPS NEW ENGLAND INC","insp_carrier_street":"98 ELM ST","insp_carrier_city":"SALISBURY","insp_carrier_state":"MA","insp_carrier_zip_code":"01952-1804","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:46:08.000000Z","updated_at":"2025-03-17T18:46:08.000000Z","inspection_violations":[{"id":1641008,"change_date":"2022-10-11 21:40:00","inspection_id":"76325669","insp_violation_id":"248930182","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:43.000000Z","updated_at":"2025-03-17T21:14:43.000000Z","normalized_code":"3922"},{"id":1641009,"change_date":"2022-10-11 21:40:00","inspection_id":"76325669","insp_violation_id":"248930183","seq_no":"2","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:43.000000Z","updated_at":"2025-03-17T21:14:43.000000Z","normalized_code":"39141A"},{"id":1641010,"change_date":"2022-10-11 21:40:00","inspection_id":"76325669","insp_violation_id":"248930184","seq_no":"3","part_no":"396","part_no_section":"1","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:43.000000Z","updated_at":"2025-03-17T21:14:43.000000Z","normalized_code":"3961"}],"inspection_per_units":[{"id":1676449,"change_date":"2022-10-11 21:40:00","inspection_id":"76325669","insp_unit_id":"191356097","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"TKU-07439","insp_unit_license":"T29595","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FDWF3G59AEB09861","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:34.000000Z","updated_at":"2025-03-17T22:18:34.000000Z"}]},{"id":667036,"change_date":"2022-06-22 21:40:00","inspection_id":"75887620","dot_number":"423047","report_state":"NH","report_number":"0990003914","insp_date":"2022-06-21 00:00:00","insp_start_time":"1140","insp_end_time":"1214","registration_date":null,"region":"ET","ci_status_code":"C","location":"237","location_desc":"WINDHAM SCALES SOUTHBOUND","county_code_state":"NH","county_code":"015","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","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":"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-06-22 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"257838","transaction_code":"A","transaction_date":"2022-06-21 00:00:00","upload_date":"2022-06-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00423047","upload_search_indicator":null,"census_search_date":"2022-06-22 21:40:00","snet_input_date":"2022-06-21 00:00:00","source_office":"1NHS001","mcmis_add_date":"2022-06-22 21:40:00","insp_carrier_name":"SPS NEW ENGLAND INC","insp_carrier_street":"98 ELM ST","insp_carrier_city":"SALISBURY","insp_carrier_state":"MA","insp_carrier_zip_code":"01952","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:39:30.000000Z","updated_at":"2025-03-17T18:39:30.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1072059,"change_date":"2022-06-22 21:40:00","inspection_id":"75887620","insp_unit_id":"189394838","insp_unit_type_id":"6","insp_unit_number":"1","insp_unit_make":"KWMH","insp_unit_company":"TKU-11639","insp_unit_license":"1337B","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1NKZL40X7LJ350354","insp_unit_decal":"Y","insp_unit_decal_number":"31401588","created_at":"2025-03-17T22:14:47.000000Z","updated_at":"2025-03-17T22:14:47.000000Z"}]},{"id":536724,"change_date":"2022-06-03 21:40:00","inspection_id":"75733027","dot_number":"423047","report_state":"NH","report_number":"0953005514","insp_date":"2022-06-02 00:00:00","insp_start_time":"1100","insp_end_time":"1241","registration_date":null,"region":"ET","ci_status_code":"C","location":"237","location_desc":"WINDHAM SCALES NORTHBOUND","county_code_state":"NH","county_code":"015","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","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":"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-06-03 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25995","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":"257632","transaction_code":"A","transaction_date":"2022-06-02 00:00:00","upload_date":"2022-06-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00423047","upload_search_indicator":null,"census_search_date":"2022-06-03 21:40:00","snet_input_date":"2022-06-02 00:00:00","source_office":"1NHS001","mcmis_add_date":"2022-06-03 21:40:00","insp_carrier_name":"SPS NEW ENGLAND INC","insp_carrier_street":"98 ELM ST","insp_carrier_city":"SALISBURY","insp_carrier_state":"MA","insp_carrier_zip_code":"01952","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:37:05.000000Z","updated_at":"2025-03-17T18:37:05.000000Z","inspection_violations":[],"inspection_per_units":[{"id":863692,"change_date":"2022-06-03 21:40:00","inspection_id":"75733027","insp_unit_id":"189050432","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"W23416","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1M2MDBAA7NS001842","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:31.000000Z","updated_at":"2025-03-17T22:13:31.000000Z"}]},{"id":509681,"change_date":"2022-06-10 21:39:00","inspection_id":"75700720","dot_number":"423047","report_state":"MA","report_number":"BV00005648","insp_date":"2022-05-31 00:00:00","insp_start_time":"0524","insp_end_time":"0543","registration_date":"2022-06-10 00:00:00","region":"ET","ci_status_code":"C","location":"291H","location_desc":"H-SAUGUS","county_code_state":"MA","county_code":"009","insp_level_id":"2","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-05-31 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"127000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"446919","transaction_code":"C","transaction_date":"2022-05-31 00:00:00","upload_date":"2022-06-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00423047","upload_search_indicator":"M","census_search_date":"2022-05-31 21:41:00","snet_input_date":"2022-05-31 00:00:00","source_office":"1MAS001","mcmis_add_date":"2022-05-31 21:41:00","insp_carrier_name":"SPS NEW ENGLAND INC","insp_carrier_street":"98 ELM ST","insp_carrier_city":"SALISBURY","insp_carrier_state":"MA","insp_carrier_zip_code":"01952-1804","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:36:41.000000Z","updated_at":"2025-03-17T18:36:41.000000Z","inspection_violations":[{"id":810675,"change_date":"2022-06-10 21:39:00","inspection_id":"75700720","insp_violation_id":"246353989","seq_no":"1","part_no":"393","part_no_section":"23","insp_viol_unit":"2","insp_unit_id":"189162583","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:10:51.000000Z","updated_at":"2025-03-17T21:10:51.000000Z","normalized_code":"39323"}],"inspection_per_units":[{"id":819820,"change_date":"2022-06-10 21:39:00","inspection_id":"75700720","insp_unit_id":"189162583","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"INTT","insp_unit_company":null,"insp_unit_license":"E24688","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1JKDLA406CM011772","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:15.000000Z","updated_at":"2025-03-17T22:13:15.000000Z"},{"id":819821,"change_date":"2022-06-10 21:39:00","inspection_id":"75700720","insp_unit_id":"189162584","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"T48426","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1M2AX04C9DM016373","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:15.000000Z","updated_at":"2025-03-17T22:13:15.000000Z"}]},{"id":341660,"change_date":"2022-07-07 21:41:00","inspection_id":"75500469","dot_number":"423047","report_state":"MA","report_number":"CX00000076","insp_date":"2022-05-06 00:00:00","insp_start_time":"1440","insp_end_time":"1513","registration_date":"2022-07-07 00:00:00","region":"ET","ci_status_code":"C","location":"1","location_desc":"CHICOPEE","county_code_state":"MA","county_code":"013","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-05-09 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"35995","viol_total":"10","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"10","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"445665","transaction_code":"C","transaction_date":"2022-05-24 00:00:00","upload_date":"2022-07-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00423047","upload_search_indicator":"M","census_search_date":"2022-05-09 21:40:00","snet_input_date":"2022-05-06 00:00:00","source_office":"1MAS001","mcmis_add_date":"2022-05-09 21:40:00","insp_carrier_name":"SPS NEW ENGLAND INC","insp_carrier_street":"98 ELM ST","insp_carrier_city":"SALISBURY","insp_carrier_state":"MA","insp_carrier_zip_code":"01952-1804","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:33:37.000000Z","updated_at":"2025-03-17T18:33:37.000000Z","inspection_violations":[{"id":536401,"change_date":"2022-07-07 21:41:00","inspection_id":"75500469","insp_violation_id":"246938004","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"189644312","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:32.000000Z","updated_at":"2025-03-17T21:09:32.000000Z","normalized_code":"3922"},{"id":536402,"change_date":"2022-07-07 21:41:00","inspection_id":"75500469","insp_violation_id":"246938005","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"189644312","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"415792AB","created_at":"2025-03-17T21:09:32.000000Z","updated_at":"2025-03-17T21:09:32.000000Z","normalized_code":"39617C"},{"id":536403,"change_date":"2022-07-07 21:41:00","inspection_id":"75500469","insp_violation_id":"246938006","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"189644312","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:32.000000Z","updated_at":"2025-03-17T21:09:32.000000Z","normalized_code":"3939A"},{"id":536404,"change_date":"2022-07-07 21:41:00","inspection_id":"75500469","insp_violation_id":"246938007","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"189644312","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:32.000000Z","updated_at":"2025-03-17T21:09:32.000000Z","normalized_code":"3939A"},{"id":536405,"change_date":"2022-07-07 21:41:00","inspection_id":"75500469","insp_violation_id":"246938008","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"189644312","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:32.000000Z","updated_at":"2025-03-17T21:09:32.000000Z","normalized_code":"3939A"},{"id":536406,"change_date":"2022-07-07 21:41:00","inspection_id":"75500469","insp_violation_id":"246938009","seq_no":"6","part_no":"393","part_no_section":"43","insp_viol_unit":"2","insp_unit_id":"189644312","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:09:32.000000Z","updated_at":"2025-03-17T21:09:32.000000Z","normalized_code":"39343"},{"id":536407,"change_date":"2022-07-07 21:41:00","inspection_id":"75500469","insp_violation_id":"246938010","seq_no":"7","part_no":"392","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"189644312","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:09:32.000000Z","updated_at":"2025-03-17T21:09:32.000000Z","normalized_code":"3929A"},{"id":536408,"change_date":"2022-07-07 21:41:00","inspection_id":"75500469","insp_violation_id":"246938011","seq_no":"8","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"189644312","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:32.000000Z","updated_at":"2025-03-17T21:09:32.000000Z","normalized_code":"3922"},{"id":536409,"change_date":"2022-07-07 21:41:00","inspection_id":"75500469","insp_violation_id":"246938012","seq_no":"9","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"189644312","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"415792AB","created_at":"2025-03-17T21:09:32.000000Z","updated_at":"2025-03-17T21:09:32.000000Z","normalized_code":"39348A"},{"id":536410,"change_date":"2022-07-07 21:41:00","inspection_id":"75500469","insp_violation_id":"246938013","seq_no":"10","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"189644312","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"415792AB","created_at":"2025-03-17T21:09:32.000000Z","updated_at":"2025-03-17T21:09:32.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":552812,"change_date":"2022-07-07 21:41:00","inspection_id":"75500469","insp_unit_id":"189644311","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"TKD-04135","insp_unit_license":"W44346","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1M2MDBAA8NS002658","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:36.000000Z","updated_at":"2025-03-17T22:11:36.000000Z"},{"id":552813,"change_date":"2022-07-07 21:41:00","inspection_id":"75500469","insp_unit_id":"189644312","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"PJ","insp_unit_company":"0550","insp_unit_license":"D29890","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"4P5T6222071097460","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:36.000000Z","updated_at":"2025-03-17T22:11:36.000000Z"}]},{"id":248803,"change_date":"2022-06-03 21:39:00","inspection_id":"75389759","dot_number":"423047","report_state":"MA","report_number":"BV00005578","insp_date":"2022-04-26 00:00:00","insp_start_time":"0548","insp_end_time":"0625","registration_date":"2022-06-03 00:00:00","region":"ET","ci_status_code":"C","location":"291H","location_desc":"H-SAUGUS","county_code_state":"MA","county_code":"009","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":"N","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-04-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"13000","viol_total":"3","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"445059","transaction_code":"C","transaction_date":"2022-04-26 00:00:00","upload_date":"2022-06-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00423047","upload_search_indicator":"M","census_search_date":"2022-04-26 21:40:00","snet_input_date":"2022-04-26 00:00:00","source_office":"1MAS001","mcmis_add_date":"2022-04-26 21:40:00","insp_carrier_name":"SPS NEW ENGLAND INC","insp_carrier_street":"98 ELM ST","insp_carrier_city":"SALISBURY","insp_carrier_state":"MA","insp_carrier_zip_code":"01952-1804","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:31:53.000000Z","updated_at":"2025-03-17T18:31:53.000000Z","inspection_violations":[{"id":381104,"change_date":"2022-06-03 21:39:00","inspection_id":"75389759","insp_violation_id":"246231941","seq_no":"1","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:53.000000Z","updated_at":"2025-03-17T21:08:53.000000Z","normalized_code":"39141A"},{"id":381105,"change_date":"2022-06-03 21:39:00","inspection_id":"75389759","insp_violation_id":"246231942","seq_no":"2","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"11","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:53.000000Z","updated_at":"2025-03-17T21:08:53.000000Z","normalized_code":"39216A"},{"id":381106,"change_date":"2022-06-03 21:39:00","inspection_id":"75389759","insp_violation_id":"246231943","seq_no":"3","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"189049297","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:53.000000Z","updated_at":"2025-03-17T21:08:53.000000Z","normalized_code":"39021TB"}],"inspection_per_units":[{"id":403341,"change_date":"2022-06-03 21:39:00","inspection_id":"75389759","insp_unit_id":"189049297","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"T29595","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FDWF3G59AEB09861","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:40.000000Z","updated_at":"2025-03-17T22:10:40.000000Z"}]},{"id":170890,"change_date":"2022-04-14 21:41:00","inspection_id":"75296722","dot_number":"423047","report_state":"NH","report_number":"0990003887","insp_date":"2022-04-13 00:00:00","insp_start_time":"1100","insp_end_time":"1222","registration_date":null,"region":"ET","ci_status_code":"C","location":"237","location_desc":"WINDHAM SCALES SOUTHBOUND","county_code_state":"NH","county_code":"015","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","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":"N","pen_cen_match":null,"final_status_date":"2022-04-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"54600","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":"256584","transaction_code":"A","transaction_date":"2022-04-13 00:00:00","upload_date":"2022-04-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00423047","upload_search_indicator":null,"census_search_date":"2022-04-14 21:41:00","snet_input_date":"2022-04-13 00:00:00","source_office":"1NHS001","mcmis_add_date":"2022-04-14 21:41:00","insp_carrier_name":"SPS NEW ENGLAND INC","insp_carrier_street":"98 ELM ST","insp_carrier_city":"SALISBURY","insp_carrier_state":"MA","insp_carrier_zip_code":"01952","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:30:30.000000Z","updated_at":"2025-03-17T18:30:30.000000Z","inspection_violations":[],"inspection_per_units":[{"id":277002,"change_date":"2022-04-14 21:41:00","inspection_id":"75296722","insp_unit_id":"188142563","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"TRK-02637","insp_unit_license":"1AD56D","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1M2GR6GCXKM001283","insp_unit_decal":"Y","insp_unit_decal_number":"31401586","created_at":"2025-03-17T22:09:52.000000Z","updated_at":"2025-03-17T22:09:52.000000Z"}]},{"id":67779,"change_date":"2022-03-30 21:39:00","inspection_id":"75171039","dot_number":"423047","report_state":"MA","report_number":"BV00005541","insp_date":"2022-03-30 00:00:00","insp_start_time":"0952","insp_end_time":"1023","registration_date":null,"region":"ET","ci_status_code":"C","location":"227H","location_desc":"H-NEWBURY","county_code_state":"MA","county_code":"009","insp_level_id":"2","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-03-30 21:39:00","post_acc_ind":"Y","gross_comb_veh_wt":"230000","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"443922","transaction_code":"A","transaction_date":"2022-03-30 00:00:00","upload_date":"2022-03-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00423047","upload_search_indicator":"M","census_search_date":"2022-03-30 21:39:00","snet_input_date":"2022-03-30 00:00:00","source_office":"1MAS001","mcmis_add_date":"2022-03-30 21:39:00","insp_carrier_name":"SPS NEW ENGLAND INC","insp_carrier_street":"98 ELM ST","insp_carrier_city":"SALISBURY","insp_carrier_state":"MA","insp_carrier_zip_code":"01952-1804","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:28:47.000000Z","updated_at":"2025-03-17T18:28:47.000000Z","inspection_violations":[{"id":99487,"change_date":"2022-03-30 21:39:00","inspection_id":"75171039","insp_violation_id":"244850538","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:32.000000Z","updated_at":"2025-03-17T21:07:32.000000Z","normalized_code":"3922"},{"id":99488,"change_date":"2022-03-30 21:39:00","inspection_id":"75171039","insp_violation_id":"244850539","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"187886543","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:32.000000Z","updated_at":"2025-03-17T21:07:32.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":110189,"change_date":"2022-03-30 21:39:00","inspection_id":"75171039","insp_unit_id":"187886542","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"5434B","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1XPBD40X0LD677031","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:54.000000Z","updated_at":"2025-03-17T22:08:54.000000Z"},{"id":110190,"change_date":"2022-03-30 21:39:00","inspection_id":"75171039","insp_unit_id":"187886543","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LANL","insp_unit_company":null,"insp_unit_license":"F26820","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1LH855WJ7F1C22458","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:54.000000Z","updated_at":"2025-03-17T22:08:54.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/423047\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/423047\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/423047\/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\/423047\/inspections","per_page":100,"prev_page_url":null,"to":58,"total":58}