{"current_page":1,"data":[{"id":11824023,"change_date":"2026-05-14 21:42:00","inspection_id":"87758683","dot_number":"18022","report_state":"MA","report_number":"DL00001728","insp_date":"2026-05-04 00:00:00","insp_start_time":"2300","insp_end_time":"2300","registration_date":"2026-05-14 00:00:00","region":"ES","ci_status_code":"C","location":"227H","location_desc":"MA","county_code_state":"MA","county_code":"009","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"METROPLITAN PIPE","shipping_paper_number":"S4155104","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"U","drug_intrdctn_search":"U","drug_intrdctn_arrests":"0","size_weight_enf":"U","traffic_enf":"U","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-05 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"3262018","transaction_code":"C","transaction_date":"2026-05-14 00:00:00","upload_date":"2026-05-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00018022","upload_search_indicator":null,"census_search_date":"2026-05-05 21:39:00","snet_input_date":"2026-05-05 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-05 21:39:00","insp_carrier_name":"METROPOLITAN PIPE & SUPPLY COMPANY","insp_carrier_street":"30 INNER BELT RD","insp_carrier_city":"SOMERVILLE","insp_carrier_state":"MA","insp_carrier_zip_code":"02143","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-08T09:40:24.000000Z","updated_at":"2026-05-25T09:30:04.000000Z","inspection_violations":[{"id":20561442,"change_date":"2026-05-14 21:42:00","inspection_id":"87758683","insp_violation_id":"274254369","seq_no":"2","part_no":"393","part_no_section":"9A-LFTSI","insp_viol_unit":"1","insp_unit_id":"213549054","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-08T10:00:50.000000Z","updated_at":"2026-05-25T09:43:08.000000Z","normalized_code":"3939ALFTSI"},{"id":20561441,"change_date":"2026-05-14 21:42:00","inspection_id":"87758683","insp_violation_id":"274254368","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":"2026-05-08T10:00:50.000000Z","updated_at":"2026-05-25T09:43:08.000000Z","normalized_code":"3922SLLLR"}],"inspection_per_units":[{"id":20564951,"change_date":"2026-05-14 21:42:00","inspection_id":"87758683","insp_unit_id":"213549054","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"AH3192","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"3ALACXFC9PDUD4814","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-08T09:18:12.000000Z","updated_at":"2026-05-25T09:02:06.000000Z"}]},{"id":11824211,"change_date":"2026-05-14 21:43:00","inspection_id":"87758884","dot_number":"18022","report_state":"MA","report_number":"DQ00003280","insp_date":"2026-05-04 00:00:00","insp_start_time":"2300","insp_end_time":"2300","registration_date":"2026-05-14 00:00:00","region":"ES","ci_status_code":"C","location":"020H","location_desc":"MA","county_code_state":"MA","county_code":"005","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SAME","shipping_paper_number":"S4153701","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"U","drug_intrdctn_search":"U","drug_intrdctn_arrests":"0","size_weight_enf":"U","traffic_enf":"U","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-05 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3262047","transaction_code":"C","transaction_date":"2026-05-14 00:00:00","upload_date":"2026-05-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00018022","upload_search_indicator":null,"census_search_date":"2026-05-05 21:39:00","snet_input_date":"2026-05-05 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-05 21:39:00","insp_carrier_name":"METROPOLITAN PIPE & SUPPLY COMPANY","insp_carrier_street":"30 INNER BELT RD","insp_carrier_city":"SOMERVILLE","insp_carrier_state":"MA","insp_carrier_zip_code":"02143","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-08T09:40:25.000000Z","updated_at":"2026-05-25T09:30:04.000000Z","inspection_violations":[{"id":20561791,"change_date":"2026-05-14 21:43:00","inspection_id":"87758884","insp_violation_id":"274262233","seq_no":"1","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"213555775","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-08T10:00:50.000000Z","updated_at":"2026-05-25T09:44:03.000000Z","normalized_code":"39360C"},{"id":20561792,"change_date":"2026-05-14 21:43:00","inspection_id":"87758884","insp_violation_id":"274262234","seq_no":"2","part_no":"393","part_no_section":"78A-WS","insp_viol_unit":"1","insp_unit_id":"213555775","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-08T10:00:50.000000Z","updated_at":"2026-05-25T09:44:03.000000Z","normalized_code":"39378AWS"},{"id":20561793,"change_date":"2026-05-14 21:43:00","inspection_id":"87758884","insp_violation_id":"274262235","seq_no":"3","part_no":"393","part_no_section":"106B-C","insp_viol_unit":"1","insp_unit_id":"213555775","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-08T10:00:50.000000Z","updated_at":"2026-05-25T09:44:03.000000Z","normalized_code":"393106BC"}],"inspection_per_units":[{"id":20565246,"change_date":"2026-05-14 21:43:00","inspection_id":"87758884","insp_unit_id":"213555775","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"W29861","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"JALE5W166N730322","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-08T09:18:12.000000Z","updated_at":"2026-05-25T09:02:06.000000Z"}]},{"id":11613576,"change_date":"2026-04-06 21:37:00","inspection_id":"87500580","dot_number":"18022","report_state":"ME","report_number":"4456003674","insp_date":"2026-04-03 00:00:00","insp_start_time":"1241","insp_end_time":"1308","registration_date":null,"region":"ET","ci_status_code":"C","location":"000440","location_desc":"SIDNEY - SCALES","county_code_state":"ME","county_code":"011","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","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":"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":"2026-04-06 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"409790","transaction_code":"A","transaction_date":"2026-04-03 00:00:00","upload_date":"2026-04-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00018022","upload_search_indicator":null,"census_search_date":"2026-04-06 21:37:00","snet_input_date":"2026-04-03 00:00:00","source_office":"1MES001","mcmis_add_date":"2026-04-06 21:37:00","insp_carrier_name":"METROPOLITAN PIPE & SUPPLY COMPANY","insp_carrier_street":"30 INNER BELT RD","insp_carrier_city":"SOMERVILLE","insp_carrier_state":"MA","insp_carrier_zip_code":"02143","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-13T09:34:48.000000Z","updated_at":"2026-04-17T09:39:05.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20198138,"change_date":"2026-04-06 21:37:00","inspection_id":"87500580","insp_unit_id":"212564575","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"406626","insp_unit_license":"AH3192","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"3ALACXFC9PDUD4814","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-13T09:09:45.000000Z","updated_at":"2026-04-18T09:23:21.000000Z"}]},{"id":11414289,"change_date":"2026-03-19 21:38:00","inspection_id":"87329861","dot_number":"18022","report_state":"RI","report_number":"0239000738","insp_date":"2026-03-14 00:00:00","insp_start_time":"0804","insp_end_time":"0830","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"CRANSTON RI","county_code_state":"RI","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":"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":"2026-03-19 21:38: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":"3024261","transaction_code":"A","transaction_date":"2026-03-19 00:00:00","upload_date":"2026-03-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00018022","upload_search_indicator":null,"census_search_date":"2026-03-19 21:38:00","snet_input_date":"2026-03-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-03-19 21:38:00","insp_carrier_name":"METROPOLITAN PIPE & SUPPLY COMPANY","insp_carrier_street":"30 INNER BELT RD","insp_carrier_city":"SOMERVILLE","insp_carrier_state":"MA","insp_carrier_zip_code":"02143","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-22T09:50:43.000000Z","updated_at":"2026-03-30T09:31:04.000000Z","inspection_violations":[{"id":19250873,"change_date":"2026-03-19 21:38:00","inspection_id":"87329861","insp_violation_id":"272493533","seq_no":"1","part_no":"392","part_no_section":"2-SLLUCR","insp_viol_unit":"1","insp_unit_id":"212214445","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-22T10:16:43.000000Z","updated_at":"2026-03-30T09:53:02.000000Z","normalized_code":"3922SLLUCR"}],"inspection_per_units":[{"id":19551877,"change_date":"2026-03-19 21:38:00","inspection_id":"87329861","insp_unit_id":"212214445","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"357285","insp_unit_license":"Y45179","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"3ALACWD21SDVU7285","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-22T09:32:25.000000Z","updated_at":"2026-03-30T09:05:30.000000Z"}]},{"id":9776373,"change_date":"2025-09-25 21:40:00","inspection_id":"85874497","dot_number":"18022","report_state":"RI","report_number":"0070001253","insp_date":"2025-09-19 00:00:00","insp_start_time":"0925","insp_end_time":"0945","registration_date":null,"region":"ED","ci_status_code":"C","location":"C0095C","location_desc":"WARWICK RI","county_code_state":"RI","county_code":"003","insp_level_id":"3","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":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-09-25 21:40: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":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2324414","transaction_code":"A","transaction_date":"2025-09-24 00:00:00","upload_date":"2025-09-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00018022","upload_search_indicator":null,"census_search_date":"2025-09-25 21:40:00","snet_input_date":"2025-09-19 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-09-25 21:40:00","insp_carrier_name":"METROPOLITAN PIPE & SUPPLY COMPANY","insp_carrier_street":"30 INNER BELT RD","insp_carrier_city":"SOMERVILLE","insp_carrier_state":"MA","insp_carrier_zip_code":"02143","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-28T10:01:00.000000Z","updated_at":"2025-09-30T10:00:11.000000Z","inspection_violations":[{"id":16069965,"change_date":"2025-09-25 21:40:00","inspection_id":"85874497","insp_violation_id":"268913781","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-09-28T10:16:39.000000Z","updated_at":"2025-09-30T10:15:15.000000Z","normalized_code":"3922SLLLR"}],"inspection_per_units":[{"id":16196236,"change_date":"2025-09-25 21:40:00","inspection_id":"85874497","insp_unit_id":"209138155","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"Y45179","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"3ALACWD21SDVU7285","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-29T09:46:33.000000Z","updated_at":"2025-09-29T09:46:33.000000Z"}]},{"id":9603140,"change_date":"2025-09-05 21:39:00","inspection_id":"85693070","dot_number":"18022","report_state":"MA","report_number":"ED00000394","insp_date":"2025-09-05 00:00:00","insp_start_time":"1114","insp_end_time":"1128","registration_date":null,"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-09-05 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":"527907","transaction_code":"A","transaction_date":"2025-09-05 00:00:00","upload_date":"2025-09-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00018022","upload_search_indicator":"M","census_search_date":"2025-09-05 21:39:00","snet_input_date":"2025-09-05 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-09-05 21:39:00","insp_carrier_name":"METROPOLITAN PIPE & SUPPLY COMPANY","insp_carrier_street":"30 INNER BELT RD","insp_carrier_city":"SOMERVILLE","insp_carrier_state":"MA","insp_carrier_zip_code":"02143","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-10T10:45:46.000000Z","updated_at":"2025-09-10T10:45:46.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15857305,"change_date":"2025-09-05 21:39:00","inspection_id":"85693070","insp_unit_id":"208768877","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"Y45179","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"3ALACWD21SDVU7285","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-10T09:46:27.000000Z","updated_at":"2025-09-10T09:46:27.000000Z"}]},{"id":10077783,"change_date":"2025-10-30 21:42:00","inspection_id":"86191973","dot_number":"18022","report_state":"NH","report_number":"1059004690","insp_date":"2025-08-07 00:00:00","insp_start_time":"1029","insp_end_time":"1107","registration_date":null,"region":"ED","ci_status_code":"C","location":"004","location_desc":"NH","county_code_state":"NH","county_code":"013","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":"N","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":"2025-10-30 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"2480111","transaction_code":"A","transaction_date":"2025-10-30 00:00:00","upload_date":"2025-10-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00018022","upload_search_indicator":null,"census_search_date":"2025-10-30 21:42:00","snet_input_date":"2025-08-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-10-30 21:42:00","insp_carrier_name":"METROPOLITAN PIPE & SUPPLY COMPANY","insp_carrier_street":"30 INNER BELT RD","insp_carrier_city":"SOMERVILLE","insp_carrier_state":"MA","insp_carrier_zip_code":"02143","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-02T11:02:11.000000Z","updated_at":"2025-11-03T11:00:53.000000Z","inspection_violations":[{"id":16691410,"change_date":"2025-10-30 21:42:00","inspection_id":"86191973","insp_violation_id":"269617987","seq_no":"1","part_no":"393","part_no_section":"9A-LFTSI","insp_viol_unit":"1","insp_unit_id":"209739466","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-02T11:17:56.000000Z","updated_at":"2025-11-03T11:16:08.000000Z","normalized_code":"3939ALFTSI"}],"inspection_per_units":[{"id":16752965,"change_date":"2025-10-30 21:42:00","inspection_id":"86191973","insp_unit_id":"209739466","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"AH3192","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"3ALACXFC9PDUD4814","insp_unit_decal":"Y","insp_unit_decal_number":"35557696","created_at":"2025-11-02T10:47:30.000000Z","updated_at":"2025-11-03T10:46:02.000000Z"}]},{"id":8567367,"change_date":"2025-05-07 21:43:00","inspection_id":"84601293","dot_number":"18022","report_state":"NH","report_number":"1325000951","insp_date":"2025-05-06 00:00:00","insp_start_time":"1304","insp_end_time":"1315","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"NEWINGTON","county_code_state":"NH","county_code":"015","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-05-07 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"284737","transaction_code":"A","transaction_date":"2025-05-06 00:00:00","upload_date":"2025-05-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00018022","upload_search_indicator":null,"census_search_date":"2025-05-07 21:43:00","snet_input_date":"2025-05-06 00:00:00","source_office":"1NHS001","mcmis_add_date":"2025-05-07 21:43:00","insp_carrier_name":"METROPOLITAN PIPE & SUPPLY COMPANY","insp_carrier_street":"30 INNER BELT RD","insp_carrier_city":"SOMERVILLE","insp_carrier_state":"MA","insp_carrier_zip_code":"02143","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-10T10:52:26.000000Z","updated_at":"2025-05-11T10:12:05.000000Z","inspection_violations":[{"id":13586812,"change_date":"2025-05-07 21:43:00","inspection_id":"84601293","insp_violation_id":"266054652","seq_no":"1","part_no":"392","part_no_section":"2-SLLTL","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-05-09T11:13:17.000000Z","updated_at":"2025-05-10T11:25:20.000000Z","normalized_code":"3922SLLTL"}],"inspection_per_units":[{"id":13940014,"change_date":"2025-05-07 21:43:00","inspection_id":"84601293","insp_unit_id":"206681837","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"AH3192","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"3ALACXFC9PDUD4814","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-10T10:16:57.000000Z","updated_at":"2025-05-11T02:54:41.000000Z"}]},{"id":8603995,"change_date":"2025-05-12 21:40:00","inspection_id":"84639814","dot_number":"18022","report_state":"MA","report_number":"DZ00000374","insp_date":"2025-05-06 00:00:00","insp_start_time":"0903","insp_end_time":"0916","registration_date":null,"region":"ET","ci_status_code":"C","location":"268S","location_desc":"S-QUINCY","county_code_state":"MA","county_code":"021","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-05-12 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"20000","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":"517144","transaction_code":"A","transaction_date":"2025-05-12 00:00:00","upload_date":"2025-05-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00018022","upload_search_indicator":"M","census_search_date":"2025-05-12 21:40:00","snet_input_date":"2025-05-06 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-05-12 21:40:00","insp_carrier_name":"METROPOLITAN PIPE & SUPPLY COMPANY","insp_carrier_street":"30 INNER BELT RD","insp_carrier_city":"SOMERVILLE","insp_carrier_state":"MA","insp_carrier_zip_code":"02143","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-15T10:01:08.000000Z","updated_at":"2025-05-17T10:04:54.000000Z","inspection_violations":[{"id":13673028,"change_date":"2025-05-12 21:40:00","inspection_id":"84639814","insp_violation_id":"266160464","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:19:46.000000Z","updated_at":"2025-05-16T10:25:25.000000Z","normalized_code":"3922SLL"},{"id":13673029,"change_date":"2025-05-12 21:40:00","inspection_id":"84639814","insp_violation_id":"266160465","seq_no":"2","part_no":"391","part_no_section":"41APC","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-05-15T10:19:46.000000Z","updated_at":"2025-05-16T10:25:25.000000Z","normalized_code":"39141APC"}],"inspection_per_units":[{"id":14045844,"change_date":"2025-05-12 21:40:00","inspection_id":"84639814","insp_unit_id":"206804105","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"X98623","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"3ALACWFC9SDVS0163","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-15T09:46:13.000000Z","updated_at":"2025-05-16T09:50:11.000000Z"}]},{"id":8284989,"change_date":"2025-04-07 21:40:00","inspection_id":"84303757","dot_number":"18022","report_state":"MA","report_number":"DV00000074","insp_date":"2025-04-02 00:00:00","insp_start_time":"1500","insp_end_time":"1510","registration_date":"2025-04-07 00:00:00","region":"ET","ci_status_code":"C","location":"270H","location_desc":"H-RAYNHAM","county_code_state":"MA","county_code":"005","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-04-03 21:41: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":"513936","transaction_code":"C","transaction_date":"2025-04-03 00:00:00","upload_date":"2025-04-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00018022","upload_search_indicator":"M","census_search_date":"2025-04-03 21:41:00","snet_input_date":"2025-04-02 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-04-03 21:41:00","insp_carrier_name":"METROPOLITAN PIPE & SUPPLY COMPANY","insp_carrier_street":"30 INNER BELT RD","insp_carrier_city":"SOMERVILLE","insp_carrier_state":"MA","insp_carrier_zip_code":"02143","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-06T10:24:53.000000Z","updated_at":"2025-04-11T10:11:05.000000Z","inspection_violations":[{"id":13070911,"change_date":"2025-04-07 21:40:00","inspection_id":"84303757","insp_violation_id":"265473661","seq_no":"2","part_no":"390","part_no_section":"21TB1-MC","insp_viol_unit":"1","insp_unit_id":"206183702","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-10T10:23:47.000000Z","updated_at":"2025-04-11T10:27:46.000000Z","normalized_code":"39021TB1MC"},{"id":13070912,"change_date":"2025-04-07 21:40:00","inspection_id":"84303757","insp_violation_id":"265473662","seq_no":"1","part_no":"390","part_no_section":"21TB2-DOT","insp_viol_unit":"1","insp_unit_id":"206183702","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-10T10:23:47.000000Z","updated_at":"2025-04-11T10:27:46.000000Z","normalized_code":"39021TB2DOT"}],"inspection_per_units":[{"id":13473661,"change_date":"2025-04-07 21:40:00","inspection_id":"84303757","insp_unit_id":"206183702","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"444432","insp_unit_license":"X98711","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"3ALACWFC2SDVS0165","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-10T09:52:37.000000Z","updated_at":"2025-04-11T09:54:29.000000Z"}]},{"id":7918165,"change_date":"2025-02-20 21:40:00","inspection_id":"83917920","dot_number":"18022","report_state":"MA","report_number":"DC00002413","insp_date":"2025-02-20 00:00:00","insp_start_time":"0747","insp_end_time":"0805","registration_date":null,"region":"ET","ci_status_code":"C","location":"020H","location_desc":"H-ATTLEBORO","county_code_state":"MA","county_code":"005","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"METROPOLITAN PIPE & SUPPLY COMPANY","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-20 21:40: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":"510157","transaction_code":"A","transaction_date":"2025-02-20 00:00:00","upload_date":"2025-02-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00018022","upload_search_indicator":"M","census_search_date":"2025-02-20 21:40:00","snet_input_date":"2025-02-20 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-02-20 21:40:00","insp_carrier_name":"METROPOLITAN PIPE & SUPPLY COMPANY","insp_carrier_street":"30 INNER BELT RD","insp_carrier_city":"SOMERVILLE","insp_carrier_state":"MA","insp_carrier_zip_code":"02143","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:02:25.000000Z","updated_at":"2025-03-17T21:02:25.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12781597,"change_date":"2025-02-20 21:40:00","inspection_id":"83917920","insp_unit_id":"205417156","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"W72181","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"3ALACWFC4PDNT2857","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:56:12.000000Z","updated_at":"2025-03-17T23:56:12.000000Z"}]},{"id":7615204,"change_date":"2025-01-17 21:40:00","inspection_id":"83599809","dot_number":"18022","report_state":"NH","report_number":"0850001713","insp_date":"2025-01-13 00:00:00","insp_start_time":"1138","insp_end_time":"1149","registration_date":"2025-01-17 00:00:00","region":"ET","ci_status_code":"C","location":"237","location_desc":"WINDHAM SCALES NORTHBOUND","county_code_state":"NH","county_code":"015","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"METROPOLITAN PIPE & SUPPLY COMPANY","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":"2025-01-14 21:55:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"281624","transaction_code":"C","transaction_date":"2025-01-13 00:00:00","upload_date":"2025-01-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00018022","upload_search_indicator":null,"census_search_date":"2025-01-14 21:55:00","snet_input_date":"2025-01-13 00:00:00","source_office":"1NHS001","mcmis_add_date":"2025-01-14 21:55:00","insp_carrier_name":"METROPOLITAN PIPE & SUPPLY COMPANY","insp_carrier_street":"30 INNER BELT RD","insp_carrier_city":"SOMERVILLE","insp_carrier_state":"MA","insp_carrier_zip_code":"02143","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:56:09.000000Z","updated_at":"2025-03-17T20:56:09.000000Z","inspection_violations":[{"id":11904061,"change_date":"2025-01-17 21:40:00","inspection_id":"83599809","insp_violation_id":"264056906","seq_no":"1","part_no":"393","part_no_section":"9A-LTSIR","insp_viol_unit":"1","insp_unit_id":"204892836","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:01.000000Z","updated_at":"2025-03-17T22:04:01.000000Z","normalized_code":"3939ALTSIR"}],"inspection_per_units":[{"id":12287425,"change_date":"2025-01-17 21:40:00","inspection_id":"83599809","insp_unit_id":"204892836","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"406626","insp_unit_license":"AH3192","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"3ALACXFC9PDUD4814","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:50:37.000000Z","updated_at":"2025-03-17T23:50:37.000000Z"}]},{"id":7217191,"change_date":"2024-11-18 21:40:00","inspection_id":"83181061","dot_number":"18022","report_state":"NH","report_number":"1292002261","insp_date":"2024-11-13 00:00:00","insp_start_time":"1112","insp_end_time":"1127","registration_date":null,"region":"ET","ci_status_code":"C","location":"088","location_desc":"DURHAM WEIGH STATION","county_code_state":"NH","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-11-18 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"280230","transaction_code":"A","transaction_date":"2024-11-13 00:00:00","upload_date":"2024-11-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00018022","upload_search_indicator":null,"census_search_date":"2024-11-18 21:40:00","snet_input_date":"2024-11-13 00:00:00","source_office":"1NHS001","mcmis_add_date":"2024-11-18 21:40:00","insp_carrier_name":"METROPOLITAN PIPE & SUPPLY COMPANY","insp_carrier_street":"30 INNER BELT RD","insp_carrier_city":"SOMERVILLE","insp_carrier_state":"MA","insp_carrier_zip_code":"02143","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:46:29.000000Z","updated_at":"2025-03-17T20:46:29.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11641224,"change_date":"2024-11-18 21:40:00","inspection_id":"83181061","insp_unit_id":"203927759","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"AH3192","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"3ALACXFC9PDUD4814","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:43:39.000000Z","updated_at":"2025-03-17T23:43:39.000000Z"}]},{"id":6805164,"change_date":"2024-09-24 21:41:00","inspection_id":"82743847","dot_number":"18022","report_state":"NH","report_number":"0965000352","insp_date":"2024-09-23 00:00:00","insp_start_time":"1105","insp_end_time":"1116","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":"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":"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":"2024-09-24 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"20000","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":"278966","transaction_code":"A","transaction_date":"2024-09-24 00:00:00","upload_date":"2024-09-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00018022","upload_search_indicator":null,"census_search_date":"2024-09-24 21:41:00","snet_input_date":"2024-09-23 00:00:00","source_office":"1NHS001","mcmis_add_date":"2024-09-24 21:41:00","insp_carrier_name":"METROPOLITAN PIPE & SUPPLY COMPANY","insp_carrier_street":"30 INNER BELT RD","insp_carrier_city":"SOMERVILLE","insp_carrier_state":"MA","insp_carrier_zip_code":"02143","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:38:11.000000Z","updated_at":"2025-03-17T20:38:11.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10973836,"change_date":"2024-09-24 21:41:00","inspection_id":"82743847","insp_unit_id":"203100588","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"T73570","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"JHHSDM2H0KK009051","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:39.000000Z","updated_at":"2025-03-17T23:36:39.000000Z"}]},{"id":6849525,"change_date":"2024-10-04 21:39:00","inspection_id":"82790838","dot_number":"18022","report_state":"MA","report_number":"DD00001827","insp_date":"2024-09-23 00:00:00","insp_start_time":"1533","insp_end_time":"1543","registration_date":"2024-10-04 00:00:00","region":"ET","ci_status_code":"C","location":"322H","location_desc":"H-STURBRIDGE","county_code_state":"MA","county_code":"027","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"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":"2024-09-30 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"500544","transaction_code":"C","transaction_date":"2024-09-30 00:00:00","upload_date":"2024-10-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00018022","upload_search_indicator":"M","census_search_date":"2024-09-30 21:40:00","snet_input_date":"2024-09-23 00:00:00","source_office":"1MAS001","mcmis_add_date":"2024-09-30 21:40:00","insp_carrier_name":"METROPOLITAN PIPE & SUPPLY COMPANY","insp_carrier_street":"30 INNER BELT RD","insp_carrier_city":"SOMERVILLE","insp_carrier_state":"MA","insp_carrier_zip_code":"02143","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:39:00.000000Z","updated_at":"2025-03-17T20:39:00.000000Z","inspection_violations":[{"id":10669421,"change_date":"2024-10-04 21:39:00","inspection_id":"82790838","insp_violation_id":"262190734","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":"912484AC","created_at":"2025-03-17T21:57:40.000000Z","updated_at":"2025-03-17T21:57:40.000000Z","normalized_code":"3922"},{"id":10669422,"change_date":"2024-10-04 21:39:00","inspection_id":"82790838","insp_violation_id":"262190735","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"203271350","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:40.000000Z","updated_at":"2025-03-17T21:57:40.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":11046090,"change_date":"2024-10-04 21:39:00","inspection_id":"82790838","insp_unit_id":"203271350","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"255731","insp_unit_license":"7404A","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"3ALACXFC7KDLE1766","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:37:24.000000Z","updated_at":"2025-03-17T23:37:24.000000Z"}]},{"id":5674676,"change_date":"2024-05-06 21:43:00","inspection_id":"81529346","dot_number":"18022","report_state":"ME","report_number":"3031003983","insp_date":"2024-05-06 00:00:00","insp_start_time":"0824","insp_end_time":"0853","registration_date":null,"region":"ET","ci_status_code":"C","location":"000531","location_desc":"YORK - SCALES","county_code_state":"ME","county_code":"031","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SAME AS CARRIER","shipping_paper_number":"-","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":"2024-05-06 21:43: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":"378868","transaction_code":"A","transaction_date":"2024-05-06 00:00:00","upload_date":"2024-05-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00018022","upload_search_indicator":null,"census_search_date":"2024-05-06 21:43:00","snet_input_date":"2024-05-06 00:00:00","source_office":"1MES001","mcmis_add_date":"2024-05-06 21:43:00","insp_carrier_name":"METROPOLITAN PIPE & SUPPLY COMPANY","insp_carrier_street":"30 INNER BELT RD","insp_carrier_city":"SOMERVILLE","insp_carrier_state":"MA","insp_carrier_zip_code":"02143","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:15:07.000000Z","updated_at":"2025-03-17T20:15:07.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9140011,"change_date":"2024-05-06 21:43:00","inspection_id":"81529346","insp_unit_id":"200737868","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"405199","insp_unit_license":"5231317","insp_unit_license_state":"NH","insp_unit_vehicle_id_number":"3ALACWFC2PDUD2719","insp_unit_decal":"Y","insp_unit_decal_number":"34069013","created_at":"2025-03-17T23:18:04.000000Z","updated_at":"2025-03-17T23:18:04.000000Z"}]},{"id":5583714,"change_date":"2024-04-30 21:41:00","inspection_id":"81430224","dot_number":"18022","report_state":"MA","report_number":"DF00000987","insp_date":"2024-04-24 00:00:00","insp_start_time":"0955","insp_end_time":"1008","registration_date":"2024-04-30 00:00:00","region":"ET","ci_status_code":"C","location":"038H","location_desc":"H-BOSTON","county_code_state":"MA","county_code":"025","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-04-24 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"490558","transaction_code":"C","transaction_date":"2024-04-24 00:00:00","upload_date":"2024-04-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00018022","upload_search_indicator":"M","census_search_date":"2024-04-24 21:41:00","snet_input_date":"2024-04-24 00:00:00","source_office":"1MAS001","mcmis_add_date":"2024-04-24 21:41:00","insp_carrier_name":"METROPOLITAN PIPE & SUPPLY COMPANY","insp_carrier_street":"30 INNER BELT RD","insp_carrier_city":"SOMERVILLE","insp_carrier_state":"MA","insp_carrier_zip_code":"02143","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:13:28.000000Z","updated_at":"2025-03-17T20:13:28.000000Z","inspection_violations":[{"id":8632042,"change_date":"2024-04-30 21:41:00","inspection_id":"81430224","insp_violation_id":"259219063","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:47:48.000000Z","updated_at":"2025-03-17T21:47:48.000000Z","normalized_code":"3922"},{"id":8632043,"change_date":"2024-04-30 21:41:00","inspection_id":"81430224","insp_violation_id":"259219064","seq_no":"2","part_no":"376","part_no_section":"11(d)(1)","insp_viol_unit":"1","insp_unit_id":"200645475","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:48.000000Z","updated_at":"2025-03-17T21:47:48.000000Z","normalized_code":"37611D1"}],"inspection_per_units":[{"id":8994329,"change_date":"2024-04-30 21:41:00","inspection_id":"81430224","insp_unit_id":"200645475","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"W72144","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"JALE5W168N7305496","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:16:40.000000Z","updated_at":"2025-03-17T23:16:40.000000Z"}]},{"id":5397073,"change_date":"2024-03-29 21:37:00","inspection_id":"81226253","dot_number":"18022","report_state":"NH","report_number":"0945004101","insp_date":"2024-03-28 00:00:00","insp_start_time":"0808","insp_end_time":"0840","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":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"METROPOLITAN PIPE & SUPPLY COMPANY","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":"2024-03-29 21:37: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":"273951","transaction_code":"A","transaction_date":"2024-03-28 00:00:00","upload_date":"2024-03-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00018022","upload_search_indicator":null,"census_search_date":"2024-03-29 21:37:00","snet_input_date":"2024-03-28 00:00:00","source_office":"1NHS001","mcmis_add_date":"2024-03-29 21:37:00","insp_carrier_name":"METROPOLITAN PIPE & SUPPLY COMPANY","insp_carrier_street":"30 INNER BELT RD","insp_carrier_city":"SOMERVILLE","insp_carrier_state":"MA","insp_carrier_zip_code":"02143","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:09:30.000000Z","updated_at":"2025-03-17T20:09:30.000000Z","inspection_violations":[{"id":8329867,"change_date":"2024-03-29 21:37:00","inspection_id":"81226253","insp_violation_id":"258653018","seq_no":"1","part_no":"391","part_no_section":"45(b)","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:46:19.000000Z","updated_at":"2025-03-17T21:46:19.000000Z","normalized_code":"39145B"}],"inspection_per_units":[{"id":8692327,"change_date":"2024-03-29 21:37:00","inspection_id":"81226253","insp_unit_id":"200151269","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"T73570","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"JHHSDM2H0KK009051","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:13:51.000000Z","updated_at":"2025-03-17T23:13:51.000000Z"}]},{"id":4853183,"change_date":"2024-01-18 21:44:00","inspection_id":"80632597","dot_number":"18022","report_state":"CT","report_number":"1229000879","insp_date":"2024-01-18 00:00:00","insp_start_time":"0925","insp_end_time":"0949","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"UNION SCALE","county_code_state":"CT","county_code":"013","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"NOTCH WELDING & MECHANICAL CONSTRUCTION","shipping_paper_number":"S3907757.001","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":"2024-01-18 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"697166","transaction_code":"A","transaction_date":"2024-01-18 00:00:00","upload_date":"2024-01-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00018022","upload_search_indicator":null,"census_search_date":"2024-01-18 21:44:00","snet_input_date":"2024-01-18 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-01-18 21:44:00","insp_carrier_name":"METROPOLITAN PIPE & SUPPLY COMPANY","insp_carrier_street":"30 INNER BELT RD","insp_carrier_city":"SOMERVILLE","insp_carrier_state":"MA","insp_carrier_zip_code":"02143","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:58:51.000000Z","updated_at":"2025-03-17T19:58:51.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7808516,"change_date":"2024-01-18 21:44:00","inspection_id":"80632597","insp_unit_id":"199003986","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"413906","insp_unit_license":"W29861","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"JALE5W166N7303228","insp_unit_decal":"Y","insp_unit_decal_number":"33728542","created_at":"2025-03-17T23:05:47.000000Z","updated_at":"2025-03-17T23:05:47.000000Z"}]},{"id":4812100,"change_date":"2024-01-23 21:44:00","inspection_id":"80587794","dot_number":"18022","report_state":"NH","report_number":"1292001719","insp_date":"2024-01-10 00:00:00","insp_start_time":"1120","insp_end_time":"1135","registration_date":"2024-01-22 00:00:00","region":"ET","ci_status_code":"C","location":null,"location_desc":"ROCHESTER","county_code_state":"NH","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-01-11 21:46:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"272257","transaction_code":"C","transaction_date":"2024-01-10 00:00:00","upload_date":"2024-01-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00018022","upload_search_indicator":null,"census_search_date":"2024-01-11 21:46:00","snet_input_date":"2024-01-10 00:00:00","source_office":"1NHS001","mcmis_add_date":"2024-01-11 21:46:00","insp_carrier_name":"METROPOLITAN PIPE & SUPPLY COMPANY","insp_carrier_street":"30 INNER BELT RD","insp_carrier_city":"SOMERVILLE","insp_carrier_state":"MA","insp_carrier_zip_code":"02143","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:58:03.000000Z","updated_at":"2025-03-17T19:58:03.000000Z","inspection_violations":[{"id":7422688,"change_date":"2024-01-23 21:44:00","inspection_id":"80587794","insp_violation_id":"257450955","seq_no":"1","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"199066941","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:51.000000Z","updated_at":"2025-03-17T21:41:51.000000Z","normalized_code":"39021TB"}],"inspection_per_units":[{"id":7742207,"change_date":"2024-01-23 21:44:00","inspection_id":"80587794","insp_unit_id":"199066941","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"T73570","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"JHHSDM2H0KK009051","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:12.000000Z","updated_at":"2025-03-17T23:05:12.000000Z"}]},{"id":4707565,"change_date":"2023-12-27 21:41:00","inspection_id":"80473752","dot_number":"18022","report_state":"NH","report_number":"0945003873","insp_date":"2023-12-27 00:00:00","insp_start_time":"0815","insp_end_time":"0845","registration_date":null,"region":"ET","ci_status_code":"C","location":"033","location_desc":"NASHUA","county_code_state":"NH","county_code":"011","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"METROPOLITAN PIPE & SUPPLY COMPANY","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-12-27 21:41: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":"271975","transaction_code":"A","transaction_date":"2023-12-27 00:00:00","upload_date":"2023-12-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00018022","upload_search_indicator":null,"census_search_date":"2023-12-27 21:41:00","snet_input_date":"2023-12-27 00:00:00","source_office":"1NHS001","mcmis_add_date":"2023-12-27 21:41:00","insp_carrier_name":"METROPOLITAN PIPE & SUPPLY COMPANY","insp_carrier_street":"30 INNER BELT RD","insp_carrier_city":"SOMERVILLE","insp_carrier_state":"MA","insp_carrier_zip_code":"02143","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:56:10.000000Z","updated_at":"2025-03-17T19:56:10.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7571848,"change_date":"2023-12-27 21:41:00","inspection_id":"80473752","insp_unit_id":"198674851","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"T52037","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"3ALACWFCXJDKA7939","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:03:41.000000Z","updated_at":"2025-03-17T23:03:41.000000Z"}]},{"id":4190671,"change_date":"2023-10-19 21:40:00","inspection_id":"79904247","dot_number":"18022","report_state":"MA","report_number":"DC00001067","insp_date":"2023-10-13 00:00:00","insp_start_time":"0952","insp_end_time":"1006","registration_date":"2023-10-19 00:00:00","region":"ET","ci_status_code":"C","location":"344H","location_desc":"H-WALPOLE","county_code_state":"MA","county_code":"021","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"METROPOLITAN PIPE & SUPPLY COMPANY","shipping_paper_number":"S3878322.001","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-10-13 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"20000","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":"476278","transaction_code":"C","transaction_date":"2023-10-13 00:00:00","upload_date":"2023-10-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00018022","upload_search_indicator":"M","census_search_date":"2023-10-13 21:40:00","snet_input_date":"2023-10-13 00:00:00","source_office":"1MAS001","mcmis_add_date":"2023-10-13 21:40:00","insp_carrier_name":"METROPOLITAN PIPE & SUPPLY COMPANY","insp_carrier_street":"30 INNER BELT RD","insp_carrier_city":"SOMERVILLE","insp_carrier_state":"MA","insp_carrier_zip_code":"02143","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:45:52.000000Z","updated_at":"2025-03-17T19:45:52.000000Z","inspection_violations":[{"id":6488558,"change_date":"2023-10-19 21:40:00","inspection_id":"79904247","insp_violation_id":"255925586","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:37:18.000000Z","updated_at":"2025-03-17T21:37:18.000000Z","normalized_code":"39216A"},{"id":6488559,"change_date":"2023-10-19 21:40:00","inspection_id":"79904247","insp_violation_id":"255925587","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:37:18.000000Z","updated_at":"2025-03-17T21:37:18.000000Z","normalized_code":"39141A"}],"inspection_per_units":[{"id":6739311,"change_date":"2023-10-19 21:40:00","inspection_id":"79904247","insp_unit_id":"197635204","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"W29861","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"JALE5W166N7303228","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:29.000000Z","updated_at":"2025-03-17T22:56:29.000000Z"}]},{"id":4169828,"change_date":"2023-10-11 21:40:00","inspection_id":"79881274","dot_number":"18022","report_state":"NH","report_number":"1222000240","insp_date":"2023-10-11 00:00:00","insp_start_time":"0733","insp_end_time":"0740","registration_date":null,"region":"ET","ci_status_code":"C","location":"017","location_desc":"HAMPTON TOLLS NB","county_code_state":"NH","county_code":"015","insp_level_id":"3","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-10-11 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"20000","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":"269970","transaction_code":"A","transaction_date":"2023-10-11 00:00:00","upload_date":"2023-10-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00018022","upload_search_indicator":null,"census_search_date":"2023-10-11 21:40:00","snet_input_date":"2023-10-11 00:00:00","source_office":"1NHS001","mcmis_add_date":"2023-10-11 21:40:00","insp_carrier_name":"METROPOLITAN PIPE & SUPPLY COMPANY","insp_carrier_street":"30 INNER BELT RD","insp_carrier_city":"SOMERVILLE","insp_carrier_state":"MA","insp_carrier_zip_code":"02143","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:45:28.000000Z","updated_at":"2025-03-17T19:45:28.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6705195,"change_date":"2023-10-11 21:40:00","inspection_id":"79881274","insp_unit_id":"197492893","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"W29861","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"JALE5W166N7303228","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:14.000000Z","updated_at":"2025-03-17T22:56:14.000000Z"}]},{"id":3638325,"change_date":"2023-08-01 21:41:00","inspection_id":"79289233","dot_number":"18022","report_state":"NH","report_number":"0850000681","insp_date":"2023-07-31 00:00:00","insp_start_time":"1016","insp_end_time":"1040","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":"METROPOLITAN PIPE & SUPPLY COMPANY","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-08-01 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"20000","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":"268026","transaction_code":"A","transaction_date":"2023-07-31 00:00:00","upload_date":"2023-08-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00018022","upload_search_indicator":null,"census_search_date":"2023-08-01 21:41:00","snet_input_date":"2023-07-31 00:00:00","source_office":"1NHS001","mcmis_add_date":"2023-08-01 21:41:00","insp_carrier_name":"METROPOLITAN PIPE & SUPPLY COMPANY","insp_carrier_street":"30 INNER BELT RD","insp_carrier_city":"SOMERVILLE","insp_carrier_state":"MA","insp_carrier_zip_code":"02143","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:34:37.000000Z","updated_at":"2025-03-17T19:34:37.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5849879,"change_date":"2023-08-01 21:41:00","inspection_id":"79289233","insp_unit_id":"196291833","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"213425","insp_unit_license":"T73570","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"JHHSDM2H0KK009051","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:10.000000Z","updated_at":"2025-03-17T22:49:10.000000Z"}]},{"id":2892041,"change_date":"2023-06-07 21:41:00","inspection_id":"78448477","dot_number":"18022","report_state":"MA","report_number":"CU00002120","insp_date":"2023-04-25 00:00:00","insp_start_time":"1050","insp_end_time":"1115","registration_date":"2023-06-07 00:00:00","region":"ET","ci_status_code":"C","location":"008H","location_desc":"H-ALLSTON","county_code_state":"MA","county_code":"025","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":"2023-04-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","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":"464432","transaction_code":"C","transaction_date":"2023-04-26 00:00:00","upload_date":"2023-06-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00018022","upload_search_indicator":"M","census_search_date":"2023-04-26 21:40:00","snet_input_date":"2023-04-25 00:00:00","source_office":"1MAS001","mcmis_add_date":"2023-04-26 21:40:00","insp_carrier_name":"METROPOLITAN PIPE & SUPPLY COMPANY","insp_carrier_street":"30 INNER BELT RD","insp_carrier_city":"SOMERVILLE","insp_carrier_state":"MA","insp_carrier_zip_code":"02143","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:20:05.000000Z","updated_at":"2025-03-17T19:20:05.000000Z","inspection_violations":[{"id":4439054,"change_date":"2023-06-07 21:41:00","inspection_id":"78448477","insp_violation_id":"253345032","seq_no":"1","part_no":"393","part_no_section":"60(b)","insp_viol_unit":"1","insp_unit_id":"195362445","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:40.000000Z","updated_at":"2025-03-17T21:27:40.000000Z","normalized_code":"39360B"}],"inspection_per_units":[{"id":4653186,"change_date":"2023-06-07 21:41:00","inspection_id":"78448477","insp_unit_id":"195362445","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"255731","insp_unit_license":"7404A","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"3ALACXFC7KDLE1766","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:39:42.000000Z","updated_at":"2025-03-17T22:39:42.000000Z"}]},{"id":2590748,"change_date":"2023-03-28 21:40:00","inspection_id":"78106146","dot_number":"18022","report_state":"MA","report_number":"BV00006137","insp_date":"2023-03-16 00:00:00","insp_start_time":"0639","insp_end_time":"0657","registration_date":"2023-03-28 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":"2023-03-16 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"20000","viol_total":"5","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"462274","transaction_code":"C","transaction_date":"2023-03-16 00:00:00","upload_date":"2023-03-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00018022","upload_search_indicator":"M","census_search_date":"2023-03-16 21:42:00","snet_input_date":"2023-03-16 00:00:00","source_office":"1MAS001","mcmis_add_date":"2023-03-16 21:42:00","insp_carrier_name":"METROPOLITAN PIPE & SUPPLY COMPANY","insp_carrier_street":"30 INNER BELT RD","insp_carrier_city":"SOMERVILLE","insp_carrier_state":"MA","insp_carrier_zip_code":"02143","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:14:29.000000Z","updated_at":"2025-03-17T19:14:29.000000Z","inspection_violations":[{"id":3985132,"change_date":"2023-03-28 21:40:00","inspection_id":"78106146","insp_violation_id":"251892727","seq_no":"1","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:25:42.000000Z","updated_at":"2025-03-17T21:25:42.000000Z","normalized_code":"3922"},{"id":3985133,"change_date":"2023-03-28 21:40:00","inspection_id":"78106146","insp_violation_id":"251892728","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"194087345","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:42.000000Z","updated_at":"2025-03-17T21:25:42.000000Z","normalized_code":"3939A"},{"id":3985134,"change_date":"2023-03-28 21:40:00","inspection_id":"78106146","insp_violation_id":"251892729","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"194087345","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:42.000000Z","updated_at":"2025-03-17T21:25:42.000000Z","normalized_code":"3939A"},{"id":3985135,"change_date":"2023-03-28 21:40:00","inspection_id":"78106146","insp_violation_id":"251892730","seq_no":"4","part_no":"392","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"194087345","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:25:42.000000Z","updated_at":"2025-03-17T21:25:42.000000Z","normalized_code":"3929A"},{"id":3985136,"change_date":"2023-03-28 21:40:00","inspection_id":"78106146","insp_violation_id":"251892731","seq_no":"5","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"194087345","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:42.000000Z","updated_at":"2025-03-17T21:25:42.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4170038,"change_date":"2023-03-28 21:40:00","inspection_id":"78106146","insp_unit_id":"194087345","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"T73570","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"JHHSDM2H0KK009051","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:54.000000Z","updated_at":"2025-03-17T22:35:54.000000Z"}]},{"id":2404351,"change_date":"2023-03-06 21:40:00","inspection_id":"77893941","dot_number":"18022","report_state":"MA","report_number":"CU00001943","insp_date":"2023-02-21 00:00:00","insp_start_time":"1010","insp_end_time":"1035","registration_date":"2023-03-06 00:00:00","region":"ET","ci_status_code":"C","location":"008H","location_desc":"H-ALLSTON","county_code_state":"MA","county_code":"025","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":"2023-02-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"460950","transaction_code":"C","transaction_date":"2023-02-21 00:00:00","upload_date":"2023-03-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00018022","upload_search_indicator":"M","census_search_date":"2023-02-21 21:40:00","snet_input_date":"2023-02-21 00:00:00","source_office":"1MAS001","mcmis_add_date":"2023-02-21 21:40:00","insp_carrier_name":"METROPOLITAN PIPE & SUPPLY COMPANY","insp_carrier_street":"30 INNER BELT RD","insp_carrier_city":"SOMERVILLE","insp_carrier_state":"MA","insp_carrier_zip_code":"02143","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:11:02.000000Z","updated_at":"2025-03-17T19:11:02.000000Z","inspection_violations":[{"id":3701633,"change_date":"2023-03-06 21:40:00","inspection_id":"77893941","insp_violation_id":"251483933","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"193713211","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:28.000000Z","updated_at":"2025-03-17T21:24:28.000000Z","normalized_code":"3939A"},{"id":3701634,"change_date":"2023-03-06 21:40:00","inspection_id":"77893941","insp_violation_id":"251483934","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"193713211","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:28.000000Z","updated_at":"2025-03-17T21:24:28.000000Z","normalized_code":"3939A"},{"id":3701635,"change_date":"2023-03-06 21:40:00","inspection_id":"77893941","insp_violation_id":"251483935","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"193713211","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:28.000000Z","updated_at":"2025-03-17T21:24:28.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":3869413,"change_date":"2023-03-06 21:40:00","inspection_id":"77893941","insp_unit_id":"193713211","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"431708","insp_unit_license":"W72144","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"JALE5W168N7305496","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:42.000000Z","updated_at":"2025-03-17T22:33:42.000000Z"}]},{"id":2162437,"change_date":"2023-01-18 21:39:00","inspection_id":"77618267","dot_number":"18022","report_state":"NH","report_number":"0945003502","insp_date":"2023-01-17 00:00:00","insp_start_time":"1228","insp_end_time":"1300","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":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"METROPOLITAN PIPE & SUPPLY COMPANY","shipping_paper_number":"S3796858.001","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-01-18 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":"263616","transaction_code":"A","transaction_date":"2023-01-17 00:00:00","upload_date":"2023-01-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00018022","upload_search_indicator":null,"census_search_date":"2023-01-18 21:39:00","snet_input_date":"2023-01-17 00:00:00","source_office":"1NHS001","mcmis_add_date":"2023-01-18 21:39:00","insp_carrier_name":"METROPOLITAN PIPE & SUPPLY COMPANY","insp_carrier_street":"30 INNER BELT RD","insp_carrier_city":"SOMERVILLE","insp_carrier_state":"MA","insp_carrier_zip_code":"02143","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:06:34.000000Z","updated_at":"2025-03-17T19:06:34.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3480193,"change_date":"2023-01-18 21:39:00","inspection_id":"77618267","insp_unit_id":"192915287","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"T52037","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"3ALACWFCXJDKA7939","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:30:58.000000Z","updated_at":"2025-03-17T22:30:58.000000Z"}]},{"id":1190856,"change_date":"2022-09-01 21:40:00","inspection_id":"76499791","dot_number":"18022","report_state":"MA","report_number":"CD00005464","insp_date":"2022-08-31 00:00:00","insp_start_time":"0947","insp_end_time":"1007","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":"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-09-01 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"20000","viol_total":"4","oos_total":"0","driver_viol_total":"4","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"451330","transaction_code":"A","transaction_date":"2022-09-01 00:00:00","upload_date":"2022-09-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00018022","upload_search_indicator":"M","census_search_date":"2022-09-01 21:40:00","snet_input_date":"2022-08-31 00:00:00","source_office":"1MAS001","mcmis_add_date":"2022-09-01 21:40:00","insp_carrier_name":"METROPOLITAN PIPE & SUPPLY COMPANY","insp_carrier_street":"30 INNER BELT RD","insp_carrier_city":"SOMERVILLE","insp_carrier_state":"MA","insp_carrier_zip_code":"02143","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:48:38.000000Z","updated_at":"2025-03-17T18:48:38.000000Z","inspection_violations":[{"id":1887375,"change_date":"2022-09-01 21:40:00","inspection_id":"76499791","insp_violation_id":"248150117","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:43.000000Z","updated_at":"2025-03-17T21:15:43.000000Z","normalized_code":"3922"},{"id":1887376,"change_date":"2022-09-01 21:40:00","inspection_id":"76499791","insp_violation_id":"248150118","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:15:43.000000Z","updated_at":"2025-03-17T21:15:43.000000Z","normalized_code":"3922"},{"id":1887377,"change_date":"2022-09-01 21:40:00","inspection_id":"76499791","insp_violation_id":"248150119","seq_no":"3","part_no":"392","part_no_section":"82(a)(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:15:43.000000Z","updated_at":"2025-03-17T21:15:43.000000Z","normalized_code":"39282A1"},{"id":1887378,"change_date":"2022-09-01 21:40:00","inspection_id":"76499791","insp_violation_id":"248150120","seq_no":"4","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:15:43.000000Z","updated_at":"2025-03-17T21:15:43.000000Z","normalized_code":"3961"}],"inspection_per_units":[{"id":1915349,"change_date":"2022-09-01 21:40:00","inspection_id":"76499791","insp_unit_id":"190670883","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"T73570","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"JHHSDM2H0KK009051","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:11.000000Z","updated_at":"2025-03-17T22:20:11.000000Z"}]},{"id":601696,"change_date":"2022-06-14 21:42:00","inspection_id":"75810357","dot_number":"18022","report_state":"NH","report_number":"0953005524","insp_date":"2022-06-13 00:00:00","insp_start_time":"0830","insp_end_time":"0850","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"MERRIMACK","county_code_state":"NH","county_code":"011","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":"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-14 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":"257737","transaction_code":"A","transaction_date":"2022-06-13 00:00:00","upload_date":"2022-06-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00018022","upload_search_indicator":null,"census_search_date":"2022-06-14 21:42:00","snet_input_date":"2022-06-13 00:00:00","source_office":"1NHS001","mcmis_add_date":"2022-06-14 21:42:00","insp_carrier_name":"METROPOLITAN PIPE & SUPPLY COMPANY","insp_carrier_street":"30 INNER BELT RD","insp_carrier_city":"SOMERVILLE","insp_carrier_state":"MA","insp_carrier_zip_code":"02143","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:38:24.000000Z","updated_at":"2025-03-17T18:38:24.000000Z","inspection_violations":[],"inspection_per_units":[{"id":967090,"change_date":"2022-06-14 21:42:00","inspection_id":"75810357","insp_unit_id":"189227114","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"T52037","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"3ALACWFCXJDKA7939","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:09.000000Z","updated_at":"2025-03-17T22:14:09.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/18022\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/18022\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/18022\/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\/18022\/inspections","per_page":100,"prev_page_url":null,"to":30,"total":30}