{"current_page":1,"data":[{"id":11553759,"change_date":"2026-04-02 21:39:00","inspection_id":"87476789","dot_number":"1225240","report_state":"ME","report_number":"3684013841","insp_date":"2026-04-01 00:00:00","insp_start_time":"1041","insp_end_time":"1130","registration_date":null,"region":"ET","ci_status_code":"C","location":"000402","location_desc":"PITTSFIELD - SCALES NB","county_code_state":"ME","county_code":"025","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"-","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":"2026-04-02 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"11000","viol_total":"4","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"409681","transaction_code":"A","transaction_date":"2026-04-01 00:00:00","upload_date":"2026-04-02 00:00:00","upload_first_byte":"0","upload_dot_number":"01225240","upload_search_indicator":null,"census_search_date":"2026-04-02 21:39:00","snet_input_date":"2026-04-01 00:00:00","source_office":"1MES001","mcmis_add_date":"2026-04-02 21:39:00","insp_carrier_name":"T C HAFFORD WATERPROOFING INC","insp_carrier_street":"356 NORTH BERWICK RD #7","insp_carrier_city":"WELLS","insp_carrier_state":"ME","insp_carrier_zip_code":"04090","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-05T09:56:59.000000Z","updated_at":"2026-04-13T09:31:12.000000Z","inspection_violations":[{"id":19526351,"change_date":"2026-04-02 21:39:00","inspection_id":"87476789","insp_violation_id":"272824294","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":"2026-04-05T10:26:43.000000Z","updated_at":"2026-04-12T10:17:58.000000Z","normalized_code":"3922SLLDL"},{"id":19526352,"change_date":"2026-04-02 21:39:00","inspection_id":"87476789","insp_violation_id":"272824295","seq_no":"2","part_no":"393","part_no_section":"41-BNPB","insp_viol_unit":"1","insp_unit_id":"212501886","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-04-05T10:26:43.000000Z","updated_at":"2026-04-12T10:17:58.000000Z","normalized_code":"39341BNPB"},{"id":19526353,"change_date":"2026-04-02 21:39:00","inspection_id":"87476789","insp_violation_id":"272824296","seq_no":"3","part_no":"392","part_no_section":"2-SLLTL","insp_viol_unit":"2","insp_unit_id":"212501887","insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-05T10:26:43.000000Z","updated_at":"2026-04-12T10:17:58.000000Z","normalized_code":"3922SLLTL"},{"id":19526354,"change_date":"2026-04-02 21:39:00","inspection_id":"87476789","insp_violation_id":"272824297","seq_no":"4","part_no":"390","part_no_section":"21TB2-DOT","insp_viol_unit":"1","insp_unit_id":"212501886","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-05T10:26:43.000000Z","updated_at":"2026-04-12T10:17:58.000000Z","normalized_code":"39021TB2DOT"}],"inspection_per_units":[{"id":19800014,"change_date":"2026-04-02 21:39:00","inspection_id":"87476789","insp_unit_id":"212501886","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":"10","insp_unit_license":"922CQR","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1GT42VCG9GF114846","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-05T09:52:18.000000Z","updated_at":"2026-04-13T09:04:15.000000Z"},{"id":19800015,"change_date":"2026-04-02 21:39:00","inspection_id":"87476789","insp_unit_id":"212501887","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"ALCO","insp_unit_company":"-","insp_unit_license":"70477","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"5WFBE1428LW088025","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-05T09:52:18.000000Z","updated_at":"2026-04-13T09:04:15.000000Z"}]},{"id":11171252,"change_date":"2026-02-19 21:39:00","inspection_id":"87087055","dot_number":"1225240","report_state":"ME","report_number":"3995005402","insp_date":"2026-02-18 00:00:00","insp_start_time":"1048","insp_end_time":"1116","registration_date":null,"region":"ET","ci_status_code":"C","location":"000402","location_desc":"PITTSFIELD - SCALES NB","county_code_state":"ME","county_code":"025","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":"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-02-19 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"12300","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":"408180","transaction_code":"A","transaction_date":"2026-02-18 00:00:00","upload_date":"2026-02-19 00:00:00","upload_first_byte":"0","upload_dot_number":"01225240","upload_search_indicator":null,"census_search_date":"2026-02-19 21:39:00","snet_input_date":"2026-02-18 00:00:00","source_office":"1MES001","mcmis_add_date":"2026-02-19 21:39:00","insp_carrier_name":"T C HAFFORD WATERPROOFING INC","insp_carrier_street":"356 NORTH BERWICK RD #7","insp_carrier_city":"WELLS","insp_carrier_state":"ME","insp_carrier_zip_code":"04090","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-22T10:37:47.000000Z","updated_at":"2026-03-02T10:30:36.000000Z","inspection_violations":[{"id":18728006,"change_date":"2026-02-19 21:39:00","inspection_id":"87087055","insp_violation_id":"271894555","seq_no":"1","part_no":"393","part_no_section":"9A-LHLI","insp_viol_unit":"1","insp_unit_id":"211706406","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-22T10:53:21.000000Z","updated_at":"2026-03-02T10:41:13.000000Z","normalized_code":"3939ALHLI"},{"id":18728007,"change_date":"2026-02-19 21:39:00","inspection_id":"87087055","insp_violation_id":"271894556","seq_no":"2","part_no":"393","part_no_section":"79","insp_viol_unit":"1","insp_unit_id":"211706406","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-22T10:53:21.000000Z","updated_at":"2026-03-02T10:41:13.000000Z","normalized_code":"39379"}],"inspection_per_units":[{"id":19061153,"change_date":"2026-02-19 21:39:00","inspection_id":"87087055","insp_unit_id":"211706406","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":null,"insp_unit_license":"9062YL","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"7GZ37SF75MN002041","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-22T10:13:23.000000Z","updated_at":"2026-03-02T10:03:16.000000Z"}]},{"id":11065691,"change_date":"2026-02-06 21:38:00","inspection_id":"86976100","dot_number":"1225240","report_state":"ME","report_number":"9094000326","insp_date":"2026-02-05 00:00:00","insp_start_time":"1112","insp_end_time":"1149","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":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"-","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":"2026-02-06 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"17950","viol_total":"3","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"407693","transaction_code":"A","transaction_date":"2026-02-05 00:00:00","upload_date":"2026-02-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01225240","upload_search_indicator":null,"census_search_date":"2026-02-06 21:38:00","snet_input_date":"2026-02-05 00:00:00","source_office":"1MES001","mcmis_add_date":"2026-02-06 21:38:00","insp_carrier_name":"T C HAFFORD WATERPROOFING INC","insp_carrier_street":"356 NORTH BERWICK RD #7","insp_carrier_city":"WELLS","insp_carrier_state":"ME","insp_carrier_zip_code":"04090","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-10T10:37:18.000000Z","updated_at":"2026-02-17T10:30:34.000000Z","inspection_violations":[{"id":18522575,"change_date":"2026-02-06 21:38:00","inspection_id":"86976100","insp_violation_id":"271640738","seq_no":"3","part_no":"392","part_no_section":"7A-D","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-02-10T10:50:50.000000Z","updated_at":"2026-02-17T10:39:01.000000Z","normalized_code":"3927AD"},{"id":18522573,"change_date":"2026-02-06 21:38:00","inspection_id":"86976100","insp_violation_id":"271640736","seq_no":"1","part_no":"393","part_no_section":"41-BNPB","insp_viol_unit":"1","insp_unit_id":"211480835","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-02-10T10:50:50.000000Z","updated_at":"2026-02-17T10:39:01.000000Z","normalized_code":"39341BNPB"},{"id":18522574,"change_date":"2026-02-06 21:38:00","inspection_id":"86976100","insp_violation_id":"271640737","seq_no":"2","part_no":"393","part_no_section":"11A1-LFTSM","insp_viol_unit":"1","insp_unit_id":"211480835","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-10T10:50:50.000000Z","updated_at":"2026-02-17T10:39:01.000000Z","normalized_code":"39311A1LFTSM"}],"inspection_per_units":[{"id":18868003,"change_date":"2026-02-06 21:38:00","inspection_id":"86976100","insp_unit_id":"211480835","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"365CRK","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"JALE5W16XH7900337","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-09T10:11:29.000000Z","updated_at":"2026-02-17T10:03:40.000000Z"}]},{"id":10788812,"change_date":"2026-01-16 21:39:00","inspection_id":"86814841","dot_number":"1225240","report_state":"US","report_number":"1707000310","insp_date":"2026-01-14 00:00:00","insp_start_time":"1230","insp_end_time":"1249","registration_date":null,"region":"ES","ci_status_code":"C","location":"PITSFN","location_desc":"PITTSFIELD ME","county_code_state":"ME","county_code":"025","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":"U","pen_cen_match":"I","final_status_date":"2026-01-16 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"2777038","transaction_code":"A","transaction_date":"2026-01-16 00:00:00","upload_date":"2026-01-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01225240","upload_search_indicator":null,"census_search_date":"2026-01-16 21:39:00","snet_input_date":"2026-01-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-01-16 21:39:00","insp_carrier_name":"T C HAFFORD WATERPROOFING INC","insp_carrier_street":"356 NORTH BERWICK RD #7","insp_carrier_city":"WELLS","insp_carrier_state":"ME","insp_carrier_zip_code":"04090","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-19T10:36:54.000000Z","updated_at":"2026-01-27T10:30:33.000000Z","inspection_violations":[{"id":18028856,"change_date":"2026-01-16 21:39:00","inspection_id":"86814841","insp_violation_id":"271252193","seq_no":"1","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"1","insp_unit_id":"211130488","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-01-19T10:43:27.000000Z","updated_at":"2026-01-27T10:31:01.000000Z","normalized_code":"39375A3TAOL"}],"inspection_per_units":[{"id":18113544,"change_date":"2026-01-16 21:39:00","inspection_id":"86814841","insp_unit_id":"211130488","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISUZU","insp_unit_company":"57","insp_unit_license":"8C6993","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"54DE5J1L2NSR01402","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-19T10:09:24.000000Z","updated_at":"2026-01-27T10:00:35.000000Z"}]},{"id":10313453,"change_date":"2026-02-18 21:38:00","inspection_id":"86439907","dot_number":"1225240","report_state":"ME","report_number":"9438000868","insp_date":"2025-11-26 00:00:00","insp_start_time":"0915","insp_end_time":"0930","registration_date":"2026-02-17 00:00:00","region":"ET","ci_status_code":"C","location":"000001","location_desc":"AUBURN","county_code_state":"ME","county_code":"001","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"TC HAFFORD","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-12-01 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"12300","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":"405206","transaction_code":"C","transaction_date":"2025-11-26 00:00:00","upload_date":"2026-02-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01225240","upload_search_indicator":null,"census_search_date":"2025-12-01 21:38:00","snet_input_date":"2025-11-26 00:00:00","source_office":"1MES001","mcmis_add_date":"2025-12-01 21:38:00","insp_carrier_name":"T C HAFFORD WATERPROOFING INC","insp_carrier_street":"356 NORTH BERWICK RD #7","insp_carrier_city":"WELLS","insp_carrier_state":"ME","insp_carrier_zip_code":"04090","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-04T10:30:27.000000Z","updated_at":"2026-03-01T10:30:53.000000Z","inspection_violations":[{"id":18701930,"change_date":"2026-02-18 21:38:00","inspection_id":"86439907","insp_violation_id":"271872221","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":"2026-02-21T10:53:27.000000Z","updated_at":"2026-03-01T10:41:10.000000Z","normalized_code":"3922SLLTL"},{"id":18701931,"change_date":"2026-02-18 21:38:00","inspection_id":"86439907","insp_violation_id":"271872222","seq_no":"2","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"211686036","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-21T10:53:27.000000Z","updated_at":"2026-03-01T10:41:10.000000Z","normalized_code":"3939ALIL"}],"inspection_per_units":[{"id":19049885,"change_date":"2026-02-18 21:38:00","inspection_id":"86439907","insp_unit_id":"211686036","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"8","insp_unit_license":"5C1265","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1GB3GSCG8J1338551","insp_unit_decal":"Y","insp_unit_decal_number":"35815549","created_at":"2026-02-21T10:14:05.000000Z","updated_at":"2026-03-01T10:03:55.000000Z"}]},{"id":9653338,"change_date":"2025-09-11 21:41:00","inspection_id":"85747099","dot_number":"1225240","report_state":"ME","report_number":"4468009458","insp_date":"2025-09-10 00:00:00","insp_start_time":"0933","insp_end_time":"0943","registration_date":null,"region":"ET","ci_status_code":"C","location":"000018","location_desc":"OLD TOWN - SCALES SB","county_code_state":"ME","county_code":"019","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":"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":"2025-09-11 21:41: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":"402298","transaction_code":"A","transaction_date":"2025-09-10 00:00:00","upload_date":"2025-09-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01225240","upload_search_indicator":null,"census_search_date":"2025-09-11 21:41:00","snet_input_date":"2025-09-10 00:00:00","source_office":"1MES001","mcmis_add_date":"2025-09-11 21:41:00","insp_carrier_name":"T C HAFFORD WATERPROOFING INC","insp_carrier_street":"356 NORTH BERWICK RD #7","insp_carrier_city":"WELLS","insp_carrier_state":"ME","insp_carrier_zip_code":"04090","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-13T10:47:57.000000Z","updated_at":"2025-09-16T10:46:54.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15952231,"change_date":"2025-09-11 21:41:00","inspection_id":"85747099","insp_unit_id":"208873291","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"92","insp_unit_license":"861CQR","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"JALE5W16XP7308063","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-13T10:00:37.000000Z","updated_at":"2025-09-15T09:53:18.000000Z"}]},{"id":8908528,"change_date":"2025-06-16 21:39:00","inspection_id":"84961967","dot_number":"1225240","report_state":"ME","report_number":"3995005111","insp_date":"2025-06-16 00:00:00","insp_start_time":"0756","insp_end_time":"0818","registration_date":null,"region":"ET","ci_status_code":"C","location":"000402","location_desc":"PITTSFIELD - SCALES NB","county_code_state":"ME","county_code":"025","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":"2025-06-16 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"12300","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":"398674","transaction_code":"A","transaction_date":"2025-06-16 00:00:00","upload_date":"2025-06-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01225240","upload_search_indicator":null,"census_search_date":"2025-06-16 21:39:00","snet_input_date":"2025-06-16 00:00:00","source_office":"1MES001","mcmis_add_date":"2025-06-16 21:39:00","insp_carrier_name":"T C HAFFORD WATERPROOFING INC","insp_carrier_street":"356 NORTH BERWICK RD #7","insp_carrier_city":"WELLS","insp_carrier_state":"ME","insp_carrier_zip_code":"04090","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-19T10:00:21.000000Z","updated_at":"2025-06-20T10:00:19.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14596208,"change_date":"2025-06-16 21:39:00","inspection_id":"84961967","insp_unit_id":"207403692","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"8","insp_unit_license":"5C1265","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1GB3GSCG8J1338551","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-19T09:45:20.000000Z","updated_at":"2025-06-20T09:45:25.000000Z"}]},{"id":8870924,"change_date":"2025-08-04 21:38:00","inspection_id":"84911545","dot_number":"1225240","report_state":"ME","report_number":"0221008173","insp_date":"2025-06-10 00:00:00","insp_start_time":"1142","insp_end_time":"1225","registration_date":"2025-08-01 00:00:00","region":"ET","ci_status_code":"C","location":"000440","location_desc":"SIDNEY - SCALES","county_code_state":"ME","county_code":"011","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SELF","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":"2025-06-10 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"2","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"398459","transaction_code":"C","transaction_date":"2025-06-11 00:00:00","upload_date":"2025-08-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01225240","upload_search_indicator":null,"census_search_date":"2025-06-10 21:40:00","snet_input_date":"2025-06-10 00:00:00","source_office":"1MES001","mcmis_add_date":"2025-06-10 21:40:00","insp_carrier_name":"T C HAFFORD WATERPROOFING INC","insp_carrier_street":"356 NORTH BERWICK RD #7","insp_carrier_city":"WELLS","insp_carrier_state":"ME","insp_carrier_zip_code":"04090","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-08-08T10:00:07.000000Z","inspection_violations":[{"id":15114624,"change_date":"2025-08-04 21:38:00","inspection_id":"84911545","insp_violation_id":"267820166","seq_no":"1","part_no":"392","part_no_section":"4A-DOSP","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"9","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-07T10:45:18.000000Z","updated_at":"2025-08-08T10:42:54.000000Z","normalized_code":"3924ADOSP"},{"id":15114625,"change_date":"2025-08-04 21:38:00","inspection_id":"84911545","insp_violation_id":"267820167","seq_no":"2","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"208221187","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-07T10:45:18.000000Z","updated_at":"2025-08-08T10:42:54.000000Z","normalized_code":"39617CPI"}],"inspection_per_units":[{"id":15342038,"change_date":"2025-08-04 21:38:00","inspection_id":"84911545","insp_unit_id":"208221187","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"8C6998","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"54DE5W1L8NSR00574","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-07T09:45:22.000000Z","updated_at":"2025-08-08T09:45:08.000000Z"}]},{"id":8813938,"change_date":"2025-06-04 21:41:00","inspection_id":"84861493","dot_number":"1225240","report_state":"ME","report_number":"3552004206","insp_date":"2025-06-04 00:00:00","insp_start_time":"0904","insp_end_time":"0923","registration_date":null,"region":"ET","ci_status_code":"C","location":"000509","location_desc":"WEST GARDINER","county_code_state":"ME","county_code":"011","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":"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":"2025-06-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"12300","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":"398158","transaction_code":"A","transaction_date":"2025-06-04 00:00:00","upload_date":"2025-06-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01225240","upload_search_indicator":null,"census_search_date":"2025-06-04 21:41:00","snet_input_date":"2025-06-04 00:00:00","source_office":"1MES001","mcmis_add_date":"2025-06-04 21:41:00","insp_carrier_name":"T C HAFFORD WATERPROOFING INC","insp_carrier_street":"356 NORTH BERWICK RD #7","insp_carrier_city":"WELLS","insp_carrier_state":"ME","insp_carrier_zip_code":"04090","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-09T10:00:28.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14428561,"change_date":"2025-06-04 21:41:00","inspection_id":"84861493","insp_unit_id":"207219921","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"-","insp_unit_license":"2D2737","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1GB3GSCG8J1321779","insp_unit_decal":"Y","insp_unit_decal_number":"35272781","created_at":"2025-06-07T09:46:14.000000Z","updated_at":"2025-06-08T09:45:39.000000Z"}]},{"id":7979227,"change_date":"2025-03-21 21:40:00","inspection_id":"83981949","dot_number":"1225240","report_state":"NH","report_number":"1094004792","insp_date":"2025-02-26 00:00:00","insp_start_time":"1330","insp_end_time":"1412","registration_date":"2025-03-21 00:00:00","region":"ET","ci_status_code":"C","location":"034","location_desc":"NORTH CONWAY","county_code_state":"NH","county_code":"003","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"MARK LAHOOD","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":"N","pen_cen_match":null,"final_status_date":"2025-02-27 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"14500","viol_total":"4","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"282795","transaction_code":"C","transaction_date":"2025-02-26 00:00:00","upload_date":"2025-03-21 00:00:00","upload_first_byte":"0","upload_dot_number":"01225240","upload_search_indicator":null,"census_search_date":"2025-02-27 21:41:00","snet_input_date":"2025-02-26 00:00:00","source_office":"1NHS001","mcmis_add_date":"2025-02-27 21:41:00","insp_carrier_name":"T C HAFFORD WATERPROOFING INC","insp_carrier_street":"356 NORTH BERWICK RD #7","insp_carrier_city":"WELLS","insp_carrier_state":"ME","insp_carrier_zip_code":"04090","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:03:42.000000Z","updated_at":"2025-03-25T10:10:15.000000Z","inspection_violations":[{"id":12812640,"change_date":"2025-03-21 21:40:00","inspection_id":"83981949","insp_violation_id":"265183220","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-23T11:34:41.000000Z","updated_at":"2025-03-25T10:25:04.000000Z","normalized_code":"3922SLLDL"},{"id":12812641,"change_date":"2025-03-21 21:40:00","inspection_id":"83981949","insp_violation_id":"265183221","seq_no":"2","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-03-23T11:34:41.000000Z","updated_at":"2025-03-25T10:25:04.000000Z","normalized_code":"3922SLL"},{"id":12812642,"change_date":"2025-03-21 21:40:00","inspection_id":"83981949","insp_violation_id":"265183222","seq_no":"3","part_no":"393","part_no_section":"81-H","insp_viol_unit":"1","insp_unit_id":"205926133","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-23T11:34:41.000000Z","updated_at":"2025-03-25T10:25:04.000000Z","normalized_code":"39381H"},{"id":12812643,"change_date":"2025-03-21 21:40:00","inspection_id":"83981949","insp_violation_id":"265183223","seq_no":"4","part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"1","insp_unit_id":"205926133","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-23T11:34:41.000000Z","updated_at":"2025-03-25T10:25:04.000000Z","normalized_code":"3939ALLPL"}],"inspection_per_units":[{"id":13215158,"change_date":"2025-03-21 21:40:00","inspection_id":"83981949","insp_unit_id":"205926133","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"99","insp_unit_license":"2D2732","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"54DC4J1D9LS207211","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-24T10:12:20.000000Z","updated_at":"2025-03-25T09:53:17.000000Z"}]},{"id":7605124,"change_date":"2025-01-13 21:46:00","inspection_id":"83589261","dot_number":"1225240","report_state":"ME","report_number":"8984000044","insp_date":"2025-01-09 00:00:00","insp_start_time":"0945","insp_end_time":"1003","registration_date":null,"region":"ET","ci_status_code":"C","location":"000395","location_desc":"PEMBROKE","county_code_state":"ME","county_code":"029","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":"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":"2025-01-13 21:46:00","post_acc_ind":"N","gross_comb_veh_wt":"12300","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":"391199","transaction_code":"A","transaction_date":"2025-01-09 00:00:00","upload_date":"2025-01-10 00:00:00","upload_first_byte":"0","upload_dot_number":"01225240","upload_search_indicator":null,"census_search_date":"2025-01-13 21:46:00","snet_input_date":"2025-01-09 00:00:00","source_office":"1MES001","mcmis_add_date":"2025-01-13 21:46:00","insp_carrier_name":"T C HAFFORD WATERPROOFING INC","insp_carrier_street":"356 NORTH BERWICK RD #7","insp_carrier_city":"WELLS","insp_carrier_state":"ME","insp_carrier_zip_code":"04090","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:56:06.000000Z","updated_at":"2025-03-17T20:56:06.000000Z","inspection_violations":[{"id":11888944,"change_date":"2025-01-13 21:46:00","inspection_id":"83589261","insp_violation_id":"263907804","seq_no":"1","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"204779497","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:56.000000Z","updated_at":"2025-03-17T22:03:56.000000Z","normalized_code":"3939ALIL"},{"id":11888945,"change_date":"2025-01-13 21:46:00","inspection_id":"83589261","insp_violation_id":"263907805","seq_no":"2","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"204779497","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:56.000000Z","updated_at":"2025-03-17T22:03:56.000000Z","normalized_code":"39360C"}],"inspection_per_units":[{"id":12271328,"change_date":"2025-01-13 21:46:00","inspection_id":"83589261","insp_unit_id":"204779497","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"SPARE","insp_unit_license":"7C3305","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1GB3G3CG5D1127303","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:50:27.000000Z","updated_at":"2025-03-17T23:50:27.000000Z"}]},{"id":7460311,"change_date":"2024-12-19 21:41:00","inspection_id":"83437060","dot_number":"1225240","report_state":"ME","report_number":"1121010084","insp_date":"2024-12-18 00:00:00","insp_start_time":"1435","insp_end_time":"1500","registration_date":null,"region":"ET","ci_status_code":"C","location":"000531","location_desc":"YORK","county_code_state":"ME","county_code":"031","insp_level_id":"1","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-12-19 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"14200","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":"390241","transaction_code":"A","transaction_date":"2024-12-18 00:00:00","upload_date":"2024-12-19 00:00:00","upload_first_byte":"0","upload_dot_number":"01225240","upload_search_indicator":null,"census_search_date":"2024-12-19 21:41:00","snet_input_date":"2024-12-18 00:00:00","source_office":"1MES001","mcmis_add_date":"2024-12-19 21:41:00","insp_carrier_name":"T C HAFFORD WATERPROOFING INC","insp_carrier_street":"356 NORTH BERWICK RD #7","insp_carrier_city":"WELLS","insp_carrier_state":"ME","insp_carrier_zip_code":"04090","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:51:54.000000Z","updated_at":"2025-03-17T20:51:54.000000Z","inspection_violations":[{"id":11659130,"change_date":"2024-12-19 21:41:00","inspection_id":"83437060","insp_violation_id":"263571239","seq_no":"1","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:02:44.000000Z","updated_at":"2025-03-17T22:02:44.000000Z","normalized_code":"39141AMCPC"}],"inspection_per_units":[{"id":12035388,"change_date":"2024-12-19 21:41:00","inspection_id":"83437060","insp_unit_id":"204477192","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"6","insp_unit_license":"2B5176","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1GB6GUCG6G1128404","insp_unit_decal":"Y","insp_unit_decal_number":"34696265","created_at":"2025-03-17T23:47:56.000000Z","updated_at":"2025-03-17T23:47:56.000000Z"}]},{"id":7069833,"change_date":"2024-10-29 21:41:00","inspection_id":"83024912","dot_number":"1225240","report_state":"ME","report_number":"3031004446","insp_date":"2024-10-28 00:00:00","insp_start_time":"1515","insp_end_time":"1530","registration_date":null,"region":"ET","ci_status_code":"C","location":"000402","location_desc":"PITTSFIELD - SCALES NB","county_code_state":"ME","county_code":"025","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-10-29 21:41: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":"387753","transaction_code":"A","transaction_date":"2024-10-28 00:00:00","upload_date":"2024-10-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01225240","upload_search_indicator":null,"census_search_date":"2024-10-29 21:41:00","snet_input_date":"2024-10-28 00:00:00","source_office":"1MES001","mcmis_add_date":"2024-10-29 21:41:00","insp_carrier_name":"T C HAFFORD WATERPROOFING INC","insp_carrier_street":"356 NORTH BERWICK RD #7","insp_carrier_city":"WELLS","insp_carrier_state":"ME","insp_carrier_zip_code":"04090","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:43:26.000000Z","updated_at":"2025-03-17T20:43:26.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11401992,"change_date":"2024-10-29 21:41:00","inspection_id":"83024912","insp_unit_id":"203633905","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"8C6993","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"54DE5J1L2NSR01402","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:41:04.000000Z","updated_at":"2025-03-17T23:41:04.000000Z"}]},{"id":7024338,"change_date":"2024-11-19 21:40:00","inspection_id":"82976734","dot_number":"1225240","report_state":"ME","report_number":"3995004743","insp_date":"2024-10-21 00:00:00","insp_start_time":"1035","insp_end_time":"1055","registration_date":"2024-11-18 00:00:00","region":"ET","ci_status_code":"C","location":"000402","location_desc":"PITTSFIELD - SCALES NB","county_code_state":"ME","county_code":"025","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":"Y","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-10-23 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"20200","viol_total":"2","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"387367","transaction_code":"C","transaction_date":"2024-10-21 00:00:00","upload_date":"2024-11-19 00:00:00","upload_first_byte":"0","upload_dot_number":"01225240","upload_search_indicator":null,"census_search_date":"2024-10-23 21:42:00","snet_input_date":"2024-10-21 00:00:00","source_office":"1MES001","mcmis_add_date":"2024-10-23 21:42:00","insp_carrier_name":"T C HAFFORD WATERPROOFING INC","insp_carrier_street":"356 NORTH BERWICK RD #7","insp_carrier_city":"WELLS","insp_carrier_state":"ME","insp_carrier_zip_code":"04090","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:42:37.000000Z","updated_at":"2025-03-17T20:42:37.000000Z","inspection_violations":[{"id":10963075,"change_date":"2024-11-19 21:40:00","inspection_id":"82976734","insp_violation_id":"262974725","seq_no":"1","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-03-17T21:59:11.000000Z","updated_at":"2025-03-17T21:59:11.000000Z","normalized_code":"3922SLLTCD"},{"id":10963076,"change_date":"2024-11-19 21:40:00","inspection_id":"82976734","insp_violation_id":"262974726","seq_no":"2","part_no":"392","part_no_section":"4A-DOSP","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"9","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:11.000000Z","updated_at":"2025-03-17T21:59:11.000000Z","normalized_code":"3924ADOSP"}],"inspection_per_units":[{"id":11328734,"change_date":"2024-11-19 21:40:00","inspection_id":"82976734","insp_unit_id":"203950661","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"1D1257","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1GB3CZCG0DF111527","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:40:18.000000Z","updated_at":"2025-03-17T23:40:18.000000Z"},{"id":11328735,"change_date":"2024-11-19 21:40:00","inspection_id":"82976734","insp_unit_id":"203950662","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":null,"insp_unit_license":"5407377","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"5JWCF1429R1539621","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:40:18.000000Z","updated_at":"2025-03-17T23:40:18.000000Z"}]},{"id":7024339,"change_date":"2024-11-19 21:40:00","inspection_id":"82976735","dot_number":"1225240","report_state":"ME","report_number":"3995004744","insp_date":"2024-10-21 00:00:00","insp_start_time":"1035","insp_end_time":"1103","registration_date":"2024-11-18 00:00:00","region":"ET","ci_status_code":"C","location":"000402","location_desc":"PITTSFIELD - SCALES NB","county_code_state":"ME","county_code":"025","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-10-23 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"2","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"387398","transaction_code":"C","transaction_date":"2024-10-21 00:00:00","upload_date":"2024-11-19 00:00:00","upload_first_byte":"0","upload_dot_number":"01225240","upload_search_indicator":null,"census_search_date":"2024-10-23 21:42:00","snet_input_date":"2024-10-21 00:00:00","source_office":"1MES001","mcmis_add_date":"2024-10-23 21:42:00","insp_carrier_name":"T C HAFFORD WATERPROOFING INC","insp_carrier_street":"356 NORTH BERWICK RD #7","insp_carrier_city":"WELLS","insp_carrier_state":"ME","insp_carrier_zip_code":"04090","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:42:37.000000Z","updated_at":"2025-03-17T20:42:37.000000Z","inspection_violations":[{"id":10963077,"change_date":"2024-11-19 21:40:00","inspection_id":"82976735","insp_violation_id":"262974727","seq_no":"1","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-03-17T21:59:11.000000Z","updated_at":"2025-03-17T21:59:11.000000Z","normalized_code":"3922SLLTCD"},{"id":10963078,"change_date":"2024-11-19 21:40:00","inspection_id":"82976735","insp_violation_id":"262974728","seq_no":"2","part_no":"392","part_no_section":"4A-DOSP","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"9","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:11.000000Z","updated_at":"2025-03-17T21:59:11.000000Z","normalized_code":"3924ADOSP"}],"inspection_per_units":[{"id":11328736,"change_date":"2024-11-19 21:40:00","inspection_id":"82976735","insp_unit_id":"203950663","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"2D7130","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"JALE5W16XP7308063","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:40:18.000000Z","updated_at":"2025-03-17T23:40:18.000000Z"}]},{"id":6890389,"change_date":"2024-11-08 21:40:00","inspection_id":"82834186","dot_number":"1225240","report_state":"ME","report_number":"3995004729","insp_date":"2024-10-03 00:00:00","insp_start_time":"1056","insp_end_time":"1126","registration_date":"2024-11-07 00:00:00","region":"ET","ci_status_code":"C","location":"000402","location_desc":"PITTSFIELD - SCALES NB","county_code_state":"ME","county_code":"025","insp_level_id":"2","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-10-04 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"14200","viol_total":"2","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"386881","transaction_code":"C","transaction_date":"2024-10-03 00:00:00","upload_date":"2024-11-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01225240","upload_search_indicator":null,"census_search_date":"2024-10-04 21:39:00","snet_input_date":"2024-10-03 00:00:00","source_office":"1MES001","mcmis_add_date":"2024-10-04 21:39:00","insp_carrier_name":"T C HAFFORD WATERPROOFING INC","insp_carrier_street":"356 NORTH BERWICK RD #7","insp_carrier_city":"WELLS","insp_carrier_state":"ME","insp_carrier_zip_code":"04090","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:39:49.000000Z","updated_at":"2025-03-17T20:39:49.000000Z","inspection_violations":[{"id":10734766,"change_date":"2024-11-08 21:40:00","inspection_id":"82834186","insp_violation_id":"262803940","seq_no":"1","part_no":"393","part_no_section":"41-BNPB","insp_viol_unit":"1","insp_unit_id":"203800119","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:57:58.000000Z","updated_at":"2025-03-17T21:57:58.000000Z","normalized_code":"39341BNPB"},{"id":10734767,"change_date":"2024-11-08 21:40:00","inspection_id":"82834186","insp_violation_id":"262803941","seq_no":"2","part_no":"393","part_no_section":"100B-C","insp_viol_unit":"1","insp_unit_id":"203800119","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:57:58.000000Z","updated_at":"2025-03-17T21:57:58.000000Z","normalized_code":"393100BC"}],"inspection_per_units":[{"id":11112446,"change_date":"2024-11-08 21:40:00","inspection_id":"82834186","insp_unit_id":"203800119","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"6","insp_unit_license":"2B5176","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1GB6GUCG6G1128404","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:38:04.000000Z","updated_at":"2025-03-17T23:38:04.000000Z"}]},{"id":6464127,"change_date":"2024-08-14 21:38:00","inspection_id":"82380353","dot_number":"1225240","report_state":"ME","report_number":"3995004621","insp_date":"2024-08-14 00:00:00","insp_start_time":"0903","insp_end_time":"0938","registration_date":null,"region":"ET","ci_status_code":"C","location":"000402","location_desc":"PITTSFIELD - SCALES NB","county_code_state":"ME","county_code":"025","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-08-14 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"23190","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":"384376","transaction_code":"A","transaction_date":"2024-08-14 00:00:00","upload_date":"2024-08-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01225240","upload_search_indicator":null,"census_search_date":"2024-08-14 21:38:00","snet_input_date":"2024-08-14 00:00:00","source_office":"1MES001","mcmis_add_date":"2024-08-14 21:38:00","insp_carrier_name":"T C HAFFORD WATERPROOFING INC","insp_carrier_street":"356 NORTH BERWICK RD #7","insp_carrier_city":"WELLS","insp_carrier_state":"ME","insp_carrier_zip_code":"04090","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:31:05.000000Z","updated_at":"2025-03-17T20:31:05.000000Z","inspection_violations":[{"id":10040071,"change_date":"2024-08-14 21:38:00","inspection_id":"82380353","insp_violation_id":"261185483","seq_no":"1","part_no":"393","part_no_section":"41","insp_viol_unit":"1","insp_unit_id":"202384793","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:54:37.000000Z","updated_at":"2025-03-17T21:54:37.000000Z","normalized_code":"39341"}],"inspection_per_units":[{"id":10419030,"change_date":"2024-08-14 21:38:00","inspection_id":"82380353","insp_unit_id":"202384793","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"3","insp_unit_license":"1D1257","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1GB3CZCG0DF111527","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:30:57.000000Z","updated_at":"2025-03-17T23:30:57.000000Z"},{"id":10419031,"change_date":"2024-08-14 21:38:00","inspection_id":"82380353","insp_unit_id":"202384794","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":null,"insp_unit_license":"3031060","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1Z9Z1ED21L1445211","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:30:57.000000Z","updated_at":"2025-03-17T23:30:57.000000Z"}]},{"id":5775578,"change_date":"2024-06-11 21:42:00","inspection_id":"81638739","dot_number":"1225240","report_state":"ME","report_number":"1767005313","insp_date":"2024-05-16 00:00:00","insp_start_time":"1514","insp_end_time":"1545","registration_date":"2024-06-10 00:00:00","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","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":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-17 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"20000","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":"380302","transaction_code":"C","transaction_date":"2024-05-17 00:00:00","upload_date":"2024-06-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01225240","upload_search_indicator":"M","census_search_date":"2024-05-17 21:40:00","snet_input_date":"2024-05-16 00:00:00","source_office":"1MES001","mcmis_add_date":"2024-05-17 21:40:00","insp_carrier_name":"T C HAFFORD WATERPROOFING INC","insp_carrier_street":"356 NORTH BERWICK RD #7","insp_carrier_city":"WELLS","insp_carrier_state":"ME","insp_carrier_zip_code":"04090","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:17:08.000000Z","updated_at":"2025-03-17T20:17:08.000000Z","inspection_violations":[{"id":8942281,"change_date":"2024-06-11 21:42:00","inspection_id":"81638739","insp_violation_id":"260016558","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"201331661","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:16.000000Z","updated_at":"2025-03-17T21:49:16.000000Z","normalized_code":"3939A"},{"id":8942282,"change_date":"2024-06-11 21:42:00","inspection_id":"81638739","insp_violation_id":"260016559","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"201331661","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:16.000000Z","updated_at":"2025-03-17T21:49:16.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9302511,"change_date":"2024-06-11 21:42:00","inspection_id":"81638739","insp_unit_id":"201331661","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"66","insp_unit_license":"1D7827","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"54DE5J1L2NSR02937","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:19:36.000000Z","updated_at":"2025-03-17T23:19:36.000000Z"}]},{"id":5752194,"change_date":"2024-05-15 21:43:00","inspection_id":"81613488","dot_number":"1225240","report_state":"ME","report_number":"3684012837","insp_date":"2024-05-14 00:00:00","insp_start_time":"1642","insp_end_time":"1709","registration_date":null,"region":"ET","ci_status_code":"C","location":"000402","location_desc":"PITTSFIELD - SCALES NB","county_code_state":"ME","county_code":"025","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"-","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-15 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"12300","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":"379879","transaction_code":"A","transaction_date":"2024-05-14 00:00:00","upload_date":"2024-05-15 00:00:00","upload_first_byte":"0","upload_dot_number":"01225240","upload_search_indicator":null,"census_search_date":"2024-05-15 21:43:00","snet_input_date":"2024-05-14 00:00:00","source_office":"1MES001","mcmis_add_date":"2024-05-15 21:43:00","insp_carrier_name":"T C HAFFORD WATERPROOFING INC","insp_carrier_street":"356 NORTH BERWICK RD #7","insp_carrier_city":"WELLS","insp_carrier_state":"ME","insp_carrier_zip_code":"04090","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:16:42.000000Z","updated_at":"2025-03-17T20:16:42.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9264824,"change_date":"2024-05-15 21:43:00","inspection_id":"81613488","insp_unit_id":"200899488","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"-","insp_unit_license":"2D2737","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1GB3GSCG8J1321779","insp_unit_decal":"Y","insp_unit_decal_number":"34068977","created_at":"2025-03-17T23:19:12.000000Z","updated_at":"2025-03-17T23:19:12.000000Z"}]},{"id":4800911,"change_date":"2024-01-30 21:41:00","inspection_id":"80575451","dot_number":"1225240","report_state":"ME","report_number":"9270002215","insp_date":"2024-01-08 00:00:00","insp_start_time":"1518","insp_end_time":"1601","registration_date":"2024-01-16 00:00:00","region":"ET","ci_status_code":"C","location":"000531","location_desc":"YORK - SCALES","county_code_state":"ME","county_code":"031","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"T C HAFFORD WATERPROOFING INC","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":"2024-01-10 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"1","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"374064","transaction_code":"C","transaction_date":"2024-01-30 00:00:00","upload_date":"2024-01-30 00:00:00","upload_first_byte":"0","upload_dot_number":"01225240","upload_search_indicator":"M","census_search_date":"2024-01-10 21:43:00","snet_input_date":"2024-01-08 00:00:00","source_office":"1MES001","mcmis_add_date":"2024-01-10 21:43:00","insp_carrier_name":"T C HAFFORD WATERPROOFING INC","insp_carrier_street":"356 NORTH BERWICK RD #7","insp_carrier_city":"WELLS","insp_carrier_state":"ME","insp_carrier_zip_code":"04090","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:57:59.000000Z","updated_at":"2025-03-17T19:57:59.000000Z","inspection_violations":[{"id":7406060,"change_date":"2024-01-30 21:41:00","inspection_id":"80575451","insp_violation_id":"257554551","seq_no":"1","part_no":"392","part_no_section":"4(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"9","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:45.000000Z","updated_at":"2025-03-17T21:41:45.000000Z","normalized_code":"3924A"}],"inspection_per_units":[{"id":7724113,"change_date":"2024-01-30 21:41:00","inspection_id":"80575451","insp_unit_id":"199166467","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"1D7827","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"54DE5J1L2NSR02937","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:01.000000Z","updated_at":"2025-03-17T23:05:01.000000Z"}]},{"id":4269056,"change_date":"2023-10-24 21:39:00","inspection_id":"79990872","dot_number":"1225240","report_state":"ME","report_number":"3684012446","insp_date":"2023-10-24 00:00:00","insp_start_time":"1317","insp_end_time":"1326","registration_date":null,"region":"ET","ci_status_code":"C","location":"000441","location_desc":"SKOWHEGAN","county_code_state":"ME","county_code":"025","insp_level_id":"3","service_center":"EA","census_source_id":"4","insp_facility":"R","shipper_name":"-","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":"I","final_status_date":"2023-10-24 21:39: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":"371426","transaction_code":"A","transaction_date":"2023-10-24 00:00:00","upload_date":"2023-10-24 00:00:00","upload_first_byte":"0","upload_dot_number":"01225240","upload_search_indicator":null,"census_search_date":"2023-10-24 21:39:00","snet_input_date":"2023-10-24 00:00:00","source_office":"1MES001","mcmis_add_date":"2023-10-24 21:39:00","insp_carrier_name":"T C HAFFORD WATERPROOFING INC","insp_carrier_street":"12 HOMESEAD DRIVE","insp_carrier_city":"WELLS","insp_carrier_state":"ME","insp_carrier_zip_code":"04090","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:47:27.000000Z","updated_at":"2025-03-17T19:47:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6865598,"change_date":"2023-10-24 21:39:00","inspection_id":"79990872","insp_unit_id":"197712865","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"57","insp_unit_license":"8C6993","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"54DE5J1L2NSR01402","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:57:34.000000Z","updated_at":"2025-03-17T22:57:34.000000Z"}]},{"id":4223554,"change_date":"2024-01-29 21:39:00","inspection_id":"79940480","dot_number":"1225240","report_state":"ME","report_number":"3995004152","insp_date":"2023-10-18 00:00:00","insp_start_time":"0919","insp_end_time":"0941","registration_date":"2023-11-14 00:00:00","region":"ET","ci_status_code":"C","location":"000213","location_desc":"DRESDEN","county_code_state":"ME","county_code":"015","insp_level_id":"3","service_center":"EA","census_source_id":"4","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":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-10-18 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"371207","transaction_code":"C","transaction_date":"2024-01-29 00:00:00","upload_date":"2024-01-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01225240","upload_search_indicator":"M","census_search_date":"2023-10-18 21:41:00","snet_input_date":"2023-10-18 00:00:00","source_office":"1MES001","mcmis_add_date":"2023-10-18 21:41:00","insp_carrier_name":"T C HAFFORD WATERPROOFING INC","insp_carrier_street":"12 HOMESEAD DRIVE","insp_carrier_city":"WELLS","insp_carrier_state":"ME","insp_carrier_zip_code":"04090","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:46:35.000000Z","updated_at":"2025-03-17T19:46:35.000000Z","inspection_violations":[{"id":6539220,"change_date":"2024-01-29 21:39:00","inspection_id":"79940480","insp_violation_id":"257530884","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:29.000000Z","updated_at":"2025-03-17T21:37:29.000000Z","normalized_code":"39216A"},{"id":6539221,"change_date":"2024-01-29 21:39:00","inspection_id":"79940480","insp_violation_id":"257530885","seq_no":"2","part_no":"392","part_no_section":"16(b)","insp_viol_unit":"C","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:29.000000Z","updated_at":"2025-03-17T21:37:29.000000Z","normalized_code":"39216B"},{"id":6539222,"change_date":"2024-01-29 21:39:00","inspection_id":"79940480","insp_violation_id":"257530886","seq_no":"3","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:37:29.000000Z","updated_at":"2025-03-17T21:37:29.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6792237,"change_date":"2024-01-29 21:39:00","inspection_id":"79940480","insp_unit_id":"199141685","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"57","insp_unit_license":"8C6993","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"54DE5J1L2NSR01402","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:56.000000Z","updated_at":"2025-03-17T22:56:56.000000Z"}]},{"id":4158298,"change_date":"2023-10-10 21:41:00","inspection_id":"79868539","dot_number":"1225240","report_state":"ME","report_number":"8970000053","insp_date":"2023-10-10 00:00:00","insp_start_time":"0824","insp_end_time":"0844","registration_date":null,"region":"ET","ci_status_code":"C","location":"000195","location_desc":"CRAWFORD","county_code_state":"ME","county_code":"029","insp_level_id":"1","service_center":"EA","census_source_id":"4","insp_facility":"R","shipper_name":"TC HAFFORD","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":"I","final_status_date":"2023-10-10 21:41: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":"370970","transaction_code":"A","transaction_date":"2023-10-10 00:00:00","upload_date":"2023-10-10 00:00:00","upload_first_byte":"0","upload_dot_number":"01225240","upload_search_indicator":null,"census_search_date":"2023-10-10 21:41:00","snet_input_date":"2023-10-10 00:00:00","source_office":"1MES001","mcmis_add_date":"2023-10-10 21:41:00","insp_carrier_name":"T C HAFFORD WATERPROOFING INC","insp_carrier_street":"12 HOMESEAD DRIVE","insp_carrier_city":"WELLS","insp_carrier_state":"ME","insp_carrier_zip_code":"04090","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:44:59.000000Z","updated_at":"2025-03-17T19:44:59.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6686115,"change_date":"2023-10-10 21:41:00","inspection_id":"79868539","insp_unit_id":"197467444","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"57","insp_unit_license":"8C6993","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"54DE5J1L2NSR01402","insp_unit_decal":"Y","insp_unit_decal_number":"33455978","created_at":"2025-03-17T22:56:04.000000Z","updated_at":"2025-03-17T22:56:04.000000Z"}]},{"id":4140551,"change_date":"2023-10-06 21:40:00","inspection_id":"79848922","dot_number":"1225240","report_state":"ME","report_number":"1121009234","insp_date":"2023-10-05 00:00:00","insp_start_time":"1620","insp_end_time":"1645","registration_date":null,"region":"ET","ci_status_code":"C","location":"000531","location_desc":"YORK","county_code_state":"ME","county_code":"031","insp_level_id":"1","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-10-06 21:40: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":"370885","transaction_code":"A","transaction_date":"2023-10-06 00:00:00","upload_date":"2023-10-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01225240","upload_search_indicator":"M","census_search_date":"2023-10-06 21:40:00","snet_input_date":"2023-10-05 00:00:00","source_office":"1MES001","mcmis_add_date":"2023-10-06 21:40:00","insp_carrier_name":"T C HAFFORD WATERPROOFING INC","insp_carrier_street":"356 NORTH BERWICK RD #7","insp_carrier_city":"WELLS","insp_carrier_state":"ME","insp_carrier_zip_code":"04090","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:44:53.000000Z","updated_at":"2025-03-17T19:44:53.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6657777,"change_date":"2023-10-06 21:40:00","inspection_id":"79848922","insp_unit_id":"197429711","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"14","insp_unit_license":"3C3345","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"JHHWDM2H6JK007692","insp_unit_decal":"Y","insp_unit_decal_number":"33456468","created_at":"2025-03-17T22:55:50.000000Z","updated_at":"2025-03-17T22:55:50.000000Z"}]},{"id":3840072,"change_date":"2023-09-15 21:40:00","inspection_id":"79514786","dot_number":"1225240","report_state":"ME","report_number":"3684012390","insp_date":"2023-08-28 00:00:00","insp_start_time":"0917","insp_end_time":"0937","registration_date":"2023-09-13 00:00:00","region":"ET","ci_status_code":"C","location":"000402","location_desc":"PITTSFIELD - SCALES NB","county_code_state":"ME","county_code":"025","insp_level_id":"1","service_center":"EA","census_source_id":"4","insp_facility":"F","shipper_name":"-","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":"I","final_status_date":"2023-08-28 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"369340","transaction_code":"C","transaction_date":"2023-08-28 00:00:00","upload_date":"2023-09-15 00:00:00","upload_first_byte":"0","upload_dot_number":"01225240","upload_search_indicator":"M","census_search_date":"2023-08-28 21:41:00","snet_input_date":"2023-08-28 00:00:00","source_office":"1MES001","mcmis_add_date":"2023-08-28 21:41:00","insp_carrier_name":"T C HAFFORD WATERPROOFING INC","insp_carrier_street":"12 HOMESEAD DRIVE","insp_carrier_city":"WELLS","insp_carrier_state":"ME","insp_carrier_zip_code":"04090","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:38:53.000000Z","updated_at":"2025-03-17T19:38:53.000000Z","inspection_violations":[{"id":5931790,"change_date":"2023-09-15 21:40:00","inspection_id":"79514786","insp_violation_id":"255288486","seq_no":"1","part_no":"393","part_no_section":"41","insp_viol_unit":"1","insp_unit_id":"197072588","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:34:40.000000Z","updated_at":"2025-03-17T21:34:40.000000Z","normalized_code":"39341"}],"inspection_per_units":[{"id":6173999,"change_date":"2023-09-15 21:40:00","inspection_id":"79514786","insp_unit_id":"197072588","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"8C6998","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"54DE5W1L8NSR00574","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:51.000000Z","updated_at":"2025-03-17T22:51:51.000000Z"}]},{"id":3752590,"change_date":"2023-08-16 21:38:00","inspection_id":"79416802","dot_number":"1225240","report_state":"ME","report_number":"2659000894","insp_date":"2023-08-15 00:00:00","insp_start_time":"1618","insp_end_time":"1710","registration_date":null,"region":"ET","ci_status_code":"C","location":"000019","location_desc":"PORTLAND","county_code_state":"ME","county_code":"005","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SELF","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-08-16 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"23990","viol_total":"3","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"368340","transaction_code":"A","transaction_date":"2023-08-16 00:00:00","upload_date":"2023-08-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01225240","upload_search_indicator":"M","census_search_date":"2023-08-16 21:38:00","snet_input_date":"2023-08-15 00:00:00","source_office":"1MES001","mcmis_add_date":"2023-08-16 21:38:00","insp_carrier_name":"T C HAFFORD WATERPROOFING INC","insp_carrier_street":"356 NORTH BERWICK RD #7","insp_carrier_city":"WELLS","insp_carrier_state":"ME","insp_carrier_zip_code":"04090","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:36:55.000000Z","updated_at":"2025-03-17T19:36:55.000000Z","inspection_violations":[{"id":5787732,"change_date":"2023-08-16 21:38:00","inspection_id":"79416802","insp_violation_id":"254679283","seq_no":"1","part_no":"393","part_no_section":"42","insp_viol_unit":"2","insp_unit_id":"196553107","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:33:49.000000Z","updated_at":"2025-03-17T21:33:49.000000Z","normalized_code":"39342"},{"id":5787733,"change_date":"2023-08-16 21:38:00","inspection_id":"79416802","insp_violation_id":"254679284","seq_no":"2","part_no":"392","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"196553107","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:33:49.000000Z","updated_at":"2025-03-17T21:33:49.000000Z","normalized_code":"3929"},{"id":5787734,"change_date":"2023-08-16 21:38:00","inspection_id":"79416802","insp_violation_id":"254679285","seq_no":"3","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"196553107","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:49.000000Z","updated_at":"2025-03-17T21:33:49.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":6033855,"change_date":"2023-08-16 21:38:00","inspection_id":"79416802","insp_unit_id":"196553106","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":null,"insp_unit_license":"2A1274","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1GDJC74K89F168958","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:42.000000Z","updated_at":"2025-03-17T22:50:42.000000Z"},{"id":6033856,"change_date":"2023-08-16 21:38:00","inspection_id":"79416802","insp_unit_id":"196553107","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HDSN","insp_unit_company":null,"insp_unit_license":"B37791","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"10HHD140571000075","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:42.000000Z","updated_at":"2025-03-17T22:50:42.000000Z"}]},{"id":3268555,"change_date":"2023-06-27 21:40:00","inspection_id":"78873481","dot_number":"1225240","report_state":"ME","report_number":"1494005866","insp_date":"2023-06-12 00:00:00","insp_start_time":"1017","insp_end_time":"1029","registration_date":"2023-06-27 00:00:00","region":"ET","ci_status_code":"C","location":"000531","location_desc":"YORK","county_code_state":"ME","county_code":"031","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":"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-06-13 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"365758","transaction_code":"C","transaction_date":"2023-06-13 00:00:00","upload_date":"2023-06-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01225240","upload_search_indicator":"M","census_search_date":"2023-06-13 21:41:00","snet_input_date":"2023-06-12 00:00:00","source_office":"1MES001","mcmis_add_date":"2023-06-13 21:41:00","insp_carrier_name":"T C HAFFORD WATERPROOFING INC","insp_carrier_street":"356 NORTH BERWICK RD #7","insp_carrier_city":"WELLS","insp_carrier_state":"ME","insp_carrier_zip_code":"04090","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:27:43.000000Z","updated_at":"2025-03-17T19:27:43.000000Z","inspection_violations":[{"id":5040416,"change_date":"2023-06-27 21:40:00","inspection_id":"78873481","insp_violation_id":"253716187","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:30:28.000000Z","updated_at":"2025-03-17T21:30:28.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5255963,"change_date":"2023-06-27 21:40:00","inspection_id":"78873481","insp_unit_id":"195688226","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"8C6998","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"54DE5W1L8NSR00574","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:26.000000Z","updated_at":"2025-03-17T22:44:26.000000Z"}]},{"id":3076254,"change_date":"2023-05-25 21:41:00","inspection_id":"78656598","dot_number":"1225240","report_state":"ME","report_number":"0242001970","insp_date":"2023-05-18 00:00:00","insp_start_time":"1244","insp_end_time":"1303","registration_date":"2023-05-25 00:00:00","region":"ET","ci_status_code":"C","location":"000531","location_desc":"YORK","county_code_state":"ME","county_code":"031","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"T C HAFFORD WATERPROOFING 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":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-05-18 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"12300","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":"364980","transaction_code":"C","transaction_date":"2023-05-19 00:00:00","upload_date":"2023-05-25 00:00:00","upload_first_byte":"0","upload_dot_number":"01225240","upload_search_indicator":"M","census_search_date":"2023-05-18 21:42:00","snet_input_date":"2023-05-18 00:00:00","source_office":"1MES001","mcmis_add_date":"2023-05-18 21:42:00","insp_carrier_name":"T C HAFFORD WATERPROOFING INC","insp_carrier_street":"356 NORTH BERWICK RD #7","insp_carrier_city":"WELLS","insp_carrier_state":"ME","insp_carrier_zip_code":"04090","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:23:48.000000Z","updated_at":"2025-03-17T19:23:48.000000Z","inspection_violations":[{"id":4727988,"change_date":"2023-05-25 21:41:00","inspection_id":"78656598","insp_violation_id":"253070325","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:02.000000Z","updated_at":"2025-03-17T21:29:02.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4948439,"change_date":"2023-05-25 21:41:00","inspection_id":"78656598","insp_unit_id":"195134441","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"5C1265","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1GB3GSCG8J1338551","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:01.000000Z","updated_at":"2025-03-17T22:42:01.000000Z"}]},{"id":2858651,"change_date":"2023-05-01 21:39:00","inspection_id":"78410561","dot_number":"1225240","report_state":"ME","report_number":"1121008916","insp_date":"2023-04-20 00:00:00","insp_start_time":"1700","insp_end_time":"1725","registration_date":"2023-04-27 00:00:00","region":"ET","ci_status_code":"C","location":"000531","location_desc":"YORK","county_code_state":"ME","county_code":"031","insp_level_id":"1","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-04-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"12500","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":"363139","transaction_code":"C","transaction_date":"2023-04-25 00:00:00","upload_date":"2023-05-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01225240","upload_search_indicator":"M","census_search_date":"2023-04-21 21:40:00","snet_input_date":"2023-04-20 00:00:00","source_office":"1MES001","mcmis_add_date":"2023-04-21 21:40:00","insp_carrier_name":"T C HAFFORD WATERPROOFING INC","insp_carrier_street":"356 NORTH BERWICK RD #7","insp_carrier_city":"WELLS","insp_carrier_state":"ME","insp_carrier_zip_code":"04090","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:19:20.000000Z","updated_at":"2025-03-17T19:19:20.000000Z","inspection_violations":[{"id":4387060,"change_date":"2023-05-01 21:39:00","inspection_id":"78410561","insp_violation_id":"252531005","seq_no":"1","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"194665318","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:30.000000Z","updated_at":"2025-03-17T21:27:30.000000Z","normalized_code":"39021TB"}],"inspection_per_units":[{"id":4599608,"change_date":"2023-05-01 21:39:00","inspection_id":"78410561","insp_unit_id":"194665318","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":null,"insp_unit_license":"3C5240","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"7GZ37TCG3JN003677","insp_unit_decal":"Y","insp_unit_decal_number":"32762144","created_at":"2025-03-17T22:39:15.000000Z","updated_at":"2025-03-17T22:39:15.000000Z"}]},{"id":2662157,"change_date":"2023-03-30 21:40:00","inspection_id":"78186895","dot_number":"1225240","report_state":"ME","report_number":"1121008881","insp_date":"2023-03-24 00:00:00","insp_start_time":"1405","insp_end_time":"1430","registration_date":"2023-03-30 00:00:00","region":"ET","ci_status_code":"C","location":"000531","location_desc":"YORK","county_code_state":"ME","county_code":"031","insp_level_id":"1","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-03-27 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"14200","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":"362284","transaction_code":"C","transaction_date":"2023-03-29 00:00:00","upload_date":"2023-03-30 00:00:00","upload_first_byte":"0","upload_dot_number":"01225240","upload_search_indicator":"M","census_search_date":"2023-03-27 21:39:00","snet_input_date":"2023-03-24 00:00:00","source_office":"1MES001","mcmis_add_date":"2023-03-27 21:39:00","insp_carrier_name":"T C HAFFORD WATERPROOFING INC","insp_carrier_street":"356 NORTH BERWICK RD #7","insp_carrier_city":"WELLS","insp_carrier_state":"ME","insp_carrier_zip_code":"04090","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:15:50.000000Z","updated_at":"2025-03-17T19:15:50.000000Z","inspection_violations":[{"id":4092262,"change_date":"2023-03-30 21:40:00","inspection_id":"78186895","insp_violation_id":"251946093","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:26:09.000000Z","updated_at":"2025-03-17T21:26:09.000000Z","normalized_code":"39141A"},{"id":4092263,"change_date":"2023-03-30 21:40:00","inspection_id":"78186895","insp_violation_id":"251946094","seq_no":"2","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"194135325","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:09.000000Z","updated_at":"2025-03-17T21:26:09.000000Z","normalized_code":"39021TB"}],"inspection_per_units":[{"id":4286128,"change_date":"2023-03-30 21:40:00","inspection_id":"78186895","insp_unit_id":"194135325","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"6","insp_unit_license":"2B5176","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1GB6GUCG6G1128404","insp_unit_decal":"Y","insp_unit_decal_number":"32395176","created_at":"2025-03-17T22:36:46.000000Z","updated_at":"2025-03-17T22:36:46.000000Z"}]},{"id":2610523,"change_date":"2023-03-20 21:40:00","inspection_id":"78128647","dot_number":"1225240","report_state":"ME","report_number":"4456001987","insp_date":"2023-03-17 00:00:00","insp_start_time":"1236","insp_end_time":"1249","registration_date":null,"region":"ET","ci_status_code":"C","location":"000005","location_desc":"BELFAST","county_code_state":"ME","county_code":"027","insp_level_id":"2","service_center":"EA","census_source_id":"4","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":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-03-20 21:40: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":"361958","transaction_code":"A","transaction_date":"2023-03-17 00:00:00","upload_date":"2023-03-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01225240","upload_search_indicator":null,"census_search_date":"2023-03-20 21:40:00","snet_input_date":"2023-03-20 00:00:00","source_office":"1MES001","mcmis_add_date":"2023-03-20 21:40:00","insp_carrier_name":"T C HAFFORD WATERPROOFING INC","insp_carrier_street":"12 HOMESEAD DRIVE","insp_carrier_city":"WELLS","insp_carrier_state":"ME","insp_carrier_zip_code":"04090","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:14:51.000000Z","updated_at":"2025-03-17T19:14:51.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4202220,"change_date":"2023-03-20 21:40:00","inspection_id":"78128647","insp_unit_id":"193948926","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"57","insp_unit_license":"8C6993","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"54DE5J1L2NSR01402","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:08.000000Z","updated_at":"2025-03-17T22:36:08.000000Z"}]},{"id":2376673,"change_date":"2023-02-15 21:38:00","inspection_id":"77862430","dot_number":"1225240","report_state":"ME","report_number":"2659000665","insp_date":"2023-02-15 00:00:00","insp_start_time":"1208","insp_end_time":"1229","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":"SELF","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-15 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"12300","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":"360766","transaction_code":"A","transaction_date":"2023-02-15 00:00:00","upload_date":"2023-02-15 00:00:00","upload_first_byte":"0","upload_dot_number":"01225240","upload_search_indicator":"M","census_search_date":"2023-02-15 21:38:00","snet_input_date":"2023-02-15 00:00:00","source_office":"1MES001","mcmis_add_date":"2023-02-15 21:38:00","insp_carrier_name":"T C HAFFORD WATERPROOFING INC","insp_carrier_street":"356 NORTH BERWICK RD #7","insp_carrier_city":"WELLS","insp_carrier_state":"ME","insp_carrier_zip_code":"04090","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:10:23.000000Z","updated_at":"2025-03-17T19:10:23.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3824330,"change_date":"2023-02-15 21:38:00","inspection_id":"77862430","insp_unit_id":"193409787","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"4C2533","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1GB3GSCG4H1167386","insp_unit_decal":"Y","insp_unit_decal_number":"32395423","created_at":"2025-03-17T22:33:23.000000Z","updated_at":"2025-03-17T22:33:23.000000Z"}]},{"id":1373875,"change_date":"2023-06-15 21:42:00","inspection_id":"76712258","dot_number":"1225240","report_state":"ME","report_number":"3684011840","insp_date":"2022-09-26 00:00:00","insp_start_time":"0956","insp_end_time":"1012","registration_date":"2023-06-15 00:00:00","region":"ET","ci_status_code":"C","location":"000402","location_desc":"PITTSFIELD - SCALES NB","county_code_state":"ME","county_code":"025","insp_level_id":"1","service_center":"EA","census_source_id":"4","insp_facility":"F","shipper_name":"-","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":"I","final_status_date":"2022-09-27 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"12300","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":"353936","transaction_code":"C","transaction_date":"2022-09-29 00:00:00","upload_date":"2023-06-15 00:00:00","upload_first_byte":"0","upload_dot_number":"01225240","upload_search_indicator":"M","census_search_date":"2022-09-27 21:39:00","snet_input_date":"2022-09-26 00:00:00","source_office":"1MES001","mcmis_add_date":"2022-09-27 21:39:00","insp_carrier_name":"T C HAFFORD WATERPROOFING INC","insp_carrier_street":"356 NORTH BERWICK RD #7","insp_carrier_city":"WELLS","insp_carrier_state":"ME","insp_carrier_zip_code":"04090","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:52:00.000000Z","updated_at":"2025-03-17T18:52:00.000000Z","inspection_violations":[{"id":2172215,"change_date":"2023-06-15 21:42:00","inspection_id":"76712258","insp_violation_id":"253518100","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"195509330","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:56.000000Z","updated_at":"2025-03-17T21:16:56.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":2212206,"change_date":"2023-06-15 21:42:00","inspection_id":"76712258","insp_unit_id":"195509330","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"-","insp_unit_license":"7C3305","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1GB3G3CG5D1127303","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:22:09.000000Z","updated_at":"2025-03-17T22:22:09.000000Z"}]},{"id":1129726,"change_date":"2022-09-23 21:37:00","inspection_id":"76428931","dot_number":"1225240","report_state":"ME","report_number":"3432001258","insp_date":"2022-08-25 00:00:00","insp_start_time":"0653","insp_end_time":"0718","registration_date":"2022-09-23 00:00:00","region":"ET","ci_status_code":"C","location":"000440","location_desc":"SIDNEY - SCALES","county_code_state":"ME","county_code":"011","insp_level_id":"1","service_center":"EA","census_source_id":"4","insp_facility":"F","shipper_name":"TC HAFFORD BASEMENT SYSTEMS","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":"I","final_status_date":"2022-08-25 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"17800","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":"352155","transaction_code":"C","transaction_date":"2022-08-25 00:00:00","upload_date":"2022-09-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01225240","upload_search_indicator":"M","census_search_date":"2022-08-25 21:42:00","snet_input_date":"2022-08-25 00:00:00","source_office":"1MES001","mcmis_add_date":"2022-08-25 21:42:00","insp_carrier_name":"T C HAFFORD WATERPROOFING INC","insp_carrier_street":"356 NORTH BERWICK RD #7","insp_carrier_city":"WELLS","insp_carrier_state":"ME","insp_carrier_zip_code":"04090","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:47:34.000000Z","updated_at":"2025-03-17T18:47:34.000000Z","inspection_violations":[{"id":1785014,"change_date":"2022-09-23 21:37:00","inspection_id":"76428931","insp_violation_id":"248604326","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"191060257","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:15:19.000000Z","updated_at":"2025-03-17T21:15:19.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":1817088,"change_date":"2022-09-23 21:37:00","inspection_id":"76428931","insp_unit_id":"191060256","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":null,"insp_unit_license":"8C1251","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"3C63R3FL2MG597473","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:32.000000Z","updated_at":"2025-03-17T22:19:32.000000Z"},{"id":1817089,"change_date":"2022-09-23 21:37:00","inspection_id":"76428931","insp_unit_id":"191060257","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"ALCO","insp_unit_company":null,"insp_unit_license":"B490102","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"5WFBE222XEW037056","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:32.000000Z","updated_at":"2025-03-17T22:19:32.000000Z"}]},{"id":692243,"change_date":"2022-06-27 21:40:00","inspection_id":"75917249","dot_number":"1225240","report_state":"ME","report_number":"1121008339","insp_date":"2022-06-27 00:00:00","insp_start_time":"1445","insp_end_time":"1510","registration_date":null,"region":"ET","ci_status_code":"C","location":"000531","location_desc":"YORK","county_code_state":"ME","county_code":"031","insp_level_id":"1","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-06-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"14200","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":"349127","transaction_code":"A","transaction_date":"2022-06-27 00:00:00","upload_date":"2022-06-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01225240","upload_search_indicator":null,"census_search_date":"2022-06-27 21:40:00","snet_input_date":"2022-06-27 00:00:00","source_office":"1MES001","mcmis_add_date":"2022-06-27 21:40:00","insp_carrier_name":"T C HAFFORD WATERPROOFING INC","insp_carrier_street":"356 NORTH BERWICK RD #7","insp_carrier_city":"WELLS","insp_carrier_state":"ME","insp_carrier_zip_code":"04090","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:39:51.000000Z","updated_at":"2025-03-17T18:39:51.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1111820,"change_date":"2022-06-27 21:40:00","inspection_id":"75917249","insp_unit_id":"189459062","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"49","insp_unit_license":"7C5853","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1HA6GVCG9JN005564","insp_unit_decal":"Y","insp_unit_decal_number":"31390483","created_at":"2025-03-17T22:15:02.000000Z","updated_at":"2025-03-17T22:15:02.000000Z"}]},{"id":315777,"change_date":"2022-05-04 21:40:00","inspection_id":"75469713","dot_number":"1225240","report_state":"ME","report_number":"2211012380","insp_date":"2022-05-03 00:00:00","insp_start_time":"1345","insp_end_time":"1407","registration_date":null,"region":"ET","ci_status_code":"C","location":"000402","location_desc":"PITTSFIELD - SCALES NB","county_code_state":"ME","county_code":"025","insp_level_id":"1","service_center":"EA","census_source_id":"4","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":"I","final_status_date":"2022-05-04 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"12300","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":"345491","transaction_code":"A","transaction_date":"2022-05-04 00:00:00","upload_date":"2022-05-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01225240","upload_search_indicator":"M","census_search_date":"2022-05-04 21:40:00","snet_input_date":"2022-05-04 00:00:00","source_office":"1MES001","mcmis_add_date":"2022-05-04 21:40:00","insp_carrier_name":"T C HAFFORD WATERPROOFING INC","insp_carrier_street":"356 NORTH BERWICK RD #7","insp_carrier_city":"WELLS","insp_carrier_state":"ME","insp_carrier_zip_code":"04090","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:32:59.000000Z","updated_at":"2025-03-17T18:32:59.000000Z","inspection_violations":[],"inspection_per_units":[{"id":510630,"change_date":"2022-05-04 21:40:00","inspection_id":"75469713","insp_unit_id":"188492928","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"-","insp_unit_license":"4C2546","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1GB3GSCG8J1321779","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:11:20.000000Z","updated_at":"2025-03-17T22:11:20.000000Z"}]},{"id":315899,"change_date":"2022-05-27 21:40:00","inspection_id":"75469857","dot_number":"1225240","report_state":"ME","report_number":"8980003509","insp_date":"2022-05-03 00:00:00","insp_start_time":"1527","insp_end_time":"1547","registration_date":"2022-05-26 00:00:00","region":"ET","ci_status_code":"C","location":"000402","location_desc":"PITTSFIELD - SCALES NB","county_code_state":"ME","county_code":"025","insp_level_id":"1","service_center":"EA","census_source_id":"4","insp_facility":"F","shipper_name":"TC HAFFORD WATERPROOFING 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":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-05-04 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","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":"345405","transaction_code":"C","transaction_date":"2022-05-04 00:00:00","upload_date":"2022-05-26 00:00:00","upload_first_byte":"0","upload_dot_number":"01225240","upload_search_indicator":"M","census_search_date":"2022-05-04 21:40:00","snet_input_date":"2022-05-04 00:00:00","source_office":"1MES001","mcmis_add_date":"2022-05-04 21:40:00","insp_carrier_name":"T C HAFFORD WATERPROOFING INC","insp_carrier_street":"356 NORTH BERWICK RD #7","insp_carrier_city":"WELLS","insp_carrier_state":"ME","insp_carrier_zip_code":"04090","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:32:59.000000Z","updated_at":"2025-03-17T18:32:59.000000Z","inspection_violations":[{"id":492533,"change_date":"2022-05-27 21:40:00","inspection_id":"75469857","insp_violation_id":"246122256","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:09:22.000000Z","updated_at":"2025-03-17T21:09:22.000000Z","normalized_code":"3922"},{"id":492534,"change_date":"2022-05-27 21:40:00","inspection_id":"75469857","insp_violation_id":"246122257","seq_no":"2","part_no":"391","part_no_section":"41(a)(1)","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:09:22.000000Z","updated_at":"2025-03-17T21:09:22.000000Z","normalized_code":"39141A1"}],"inspection_per_units":[{"id":510812,"change_date":"2022-05-27 21:40:00","inspection_id":"75469857","insp_unit_id":"188952021","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"57","insp_unit_license":"8C6993","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"54DE5J1L2NSR01402","insp_unit_decal":"Y","insp_unit_decal_number":"31390277","created_at":"2025-03-17T22:11:20.000000Z","updated_at":"2025-03-17T22:11:20.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/1225240\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/1225240\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1225240\/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\/1225240\/inspections","per_page":100,"prev_page_url":null,"to":37,"total":37}