{"current_page":1,"data":[{"id":11824283,"change_date":"2026-05-05 21:39:00","inspection_id":"87758961","dot_number":"376802","report_state":"MA","report_number":"DY00001631","insp_date":"2026-05-04 00:00:00","insp_start_time":"2300","insp_end_time":"2300","registration_date":null,"region":"ES","ci_status_code":"C","location":"322H","location_desc":"MA","county_code_state":"MA","county_code":"027","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SELF\/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":"U","drug_intrdctn_search":"U","drug_intrdctn_arrests":"0","size_weight_enf":"U","traffic_enf":"U","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-05-05 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3262195","transaction_code":"A","transaction_date":"2026-05-05 00:00:00","upload_date":"2026-05-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00376802","upload_search_indicator":null,"census_search_date":"2026-05-05 21:39:00","snet_input_date":"2026-05-05 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-05-05 21:39:00","insp_carrier_name":"MCPHEE ELECTRIC LTD","insp_carrier_street":"505 MAIN STREET","insp_carrier_city":"FARMINGTON","insp_carrier_state":"CT","insp_carrier_zip_code":"06032-2912","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-08T09:40:25.000000Z","updated_at":"2026-05-15T12:18:16.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20565355,"change_date":"2026-05-05 21:39:00","inspection_id":"87758961","insp_unit_id":"213381326","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"K91494","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FVACWDT5EHFK8829","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-08T09:18:12.000000Z","updated_at":"2026-05-15T11:57:23.000000Z"}]},{"id":10537377,"change_date":"2025-12-30 21:36:00","inspection_id":"86673649","dot_number":"376802","report_state":"CT","report_number":"0102000064","insp_date":"2025-12-30 00:00:00","insp_start_time":"1100","insp_end_time":"1125","registration_date":null,"region":"ET","ci_status_code":"C","location":"083S","location_desc":"MIDDLETOWN SCALE","county_code_state":"CT","county_code":"007","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-12-30 21:36:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"761945","transaction_code":"A","transaction_date":"2025-12-30 00:00:00","upload_date":"2025-12-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00376802","upload_search_indicator":null,"census_search_date":"2025-12-30 21:36:00","snet_input_date":"2025-12-30 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-12-30 21:36:00","insp_carrier_name":"MCPHEE ELECTRIC LTD","insp_carrier_street":"505 MAIN STREET","insp_carrier_city":"FARMINGTON","insp_carrier_state":"CT","insp_carrier_zip_code":"06032","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-02T10:35:44.000000Z","updated_at":"2026-01-10T10:30:11.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17651112,"change_date":"2025-12-30 21:36:00","inspection_id":"86673649","insp_unit_id":"210845309","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"23218","insp_unit_license":"AB16781","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3ALACWFC3PDNY7218","insp_unit_decal":"Y","insp_unit_decal_number":"35803603","created_at":"2026-01-02T10:06:18.000000Z","updated_at":"2026-01-10T10:00:12.000000Z"}]},{"id":10393499,"change_date":"2025-12-10 21:37:00","inspection_id":"86523352","dot_number":"376802","report_state":"CT","report_number":"3132005973","insp_date":"2025-12-10 00:00:00","insp_start_time":"0744","insp_end_time":"0753","registration_date":null,"region":"ET","ci_status_code":"C","location":"052","location_desc":"FARMINGTON","county_code_state":"CT","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-12-10 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"760234","transaction_code":"A","transaction_date":"2025-12-10 00:00:00","upload_date":"2025-12-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00376802","upload_search_indicator":null,"census_search_date":"2025-12-10 21:37:00","snet_input_date":"2025-12-10 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-12-10 21:37:00","insp_carrier_name":"MCPHEE ELECTRIC LTD","insp_carrier_street":"505 MAIN STREET","insp_carrier_city":"FARMINGTON","insp_carrier_state":"CT","insp_carrier_zip_code":"06032","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-13T10:31:20.000000Z","updated_at":"2025-12-14T10:30:05.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17376117,"change_date":"2025-12-10 21:37:00","inspection_id":"86523352","insp_unit_id":"210514424","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"AB16781","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3ALACWFC3PDNY7218","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-13T10:01:41.000000Z","updated_at":"2025-12-14T10:00:06.000000Z"}]},{"id":10328109,"change_date":"2025-12-04 21:37:00","inspection_id":"86455001","dot_number":"376802","report_state":"CT","report_number":"3132005961","insp_date":"2025-12-02 00:00:00","insp_start_time":"0830","insp_end_time":"0840","registration_date":"2025-12-04 00:00:00","region":"ET","ci_status_code":"C","location":"052","location_desc":"FARMINGTON","county_code_state":"CT","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-12-02 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"759369","transaction_code":"C","transaction_date":"2025-12-02 00:00:00","upload_date":"2025-12-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00376802","upload_search_indicator":null,"census_search_date":"2025-12-02 21:38:00","snet_input_date":"2025-12-02 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-12-02 21:38:00","insp_carrier_name":"MCPHEE ELECTRIC LTD","insp_carrier_street":"505 MAIN STREET","insp_carrier_city":"FARMINGTON","insp_carrier_state":"CT","insp_carrier_zip_code":"06032","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-05T10:32:23.000000Z","updated_at":"2025-12-08T10:30:07.000000Z","inspection_violations":[{"id":17313305,"change_date":"2025-12-04 21:37:00","inspection_id":"86455001","insp_violation_id":"270443991","seq_no":"1","part_no":"392","part_no_section":"2-SLL","insp_viol_unit":"1","insp_unit_id":"210398073","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-07T10:31:54.000000Z","updated_at":"2025-12-08T10:30:14.000000Z","normalized_code":"3922SLL"}],"inspection_per_units":[{"id":17283876,"change_date":"2025-12-04 21:37:00","inspection_id":"86455001","insp_unit_id":"210398073","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"AP31521","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FVACWFC3LHLF3709","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-07T10:01:19.000000Z","updated_at":"2025-12-08T10:00:10.000000Z"}]},{"id":10212232,"change_date":"2025-11-17 21:38:00","inspection_id":"86333583","dot_number":"376802","report_state":"CT","report_number":"1229002071","insp_date":"2025-11-17 00:00:00","insp_start_time":"1346","insp_end_time":"1356","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"UNION SCALE","county_code_state":"CT","county_code":"013","insp_level_id":"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-11-17 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"757955","transaction_code":"A","transaction_date":"2025-11-17 00:00:00","upload_date":"2025-11-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00376802","upload_search_indicator":null,"census_search_date":"2025-11-17 21:38:00","snet_input_date":"2025-11-17 00:00:00","source_office":"1CTS001","mcmis_add_date":"2025-11-17 21:38:00","insp_carrier_name":"MCPHEE ELECTRIC LTD","insp_carrier_street":"505 MAIN STREET","insp_carrier_city":"FARMINGTON","insp_carrier_state":"CT","insp_carrier_zip_code":"06032","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-20T10:30:20.000000Z","updated_at":"2025-11-21T10:30:05.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17011538,"change_date":"2025-11-17 21:38:00","inspection_id":"86333583","insp_unit_id":"210053826","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"23218","insp_unit_license":"AB16781","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3ALACWFC3PDNY7218","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-20T10:00:25.000000Z","updated_at":"2025-11-21T10:00:07.000000Z"}]},{"id":9677043,"change_date":"2025-09-14 21:33:00","inspection_id":"85770443","dot_number":"376802","report_state":"RI","report_number":"0089000142","insp_date":"2025-09-08 00:00:00","insp_start_time":"1052","insp_end_time":"1120","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"WARWICK RI","county_code_state":"RI","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-09-14 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2274226","transaction_code":"A","transaction_date":"2025-09-13 00:00:00","upload_date":"2025-09-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00376802","upload_search_indicator":null,"census_search_date":"2025-09-14 21:33:00","snet_input_date":"2025-09-08 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-09-14 21:33:00","insp_carrier_name":"MCPHEE ELECTRIC LTD","insp_carrier_street":"505 MAIN STREET","insp_carrier_city":"FARMINGTON","insp_carrier_state":"CT","insp_carrier_zip_code":"06032-2912","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-17T10:40:59.000000Z","updated_at":"2025-09-18T10:00:08.000000Z","inspection_violations":[{"id":15863921,"change_date":"2025-09-14 21:33:00","inspection_id":"85770443","insp_violation_id":"268680431","seq_no":"1","part_no":"392","part_no_section":"2-SLLLR","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-18T10:20:23.000000Z","updated_at":"2025-09-18T10:20:23.000000Z","normalized_code":"3922SLLLR"}],"inspection_per_units":[{"id":16014251,"change_date":"2025-09-14 21:33:00","inspection_id":"85770443","insp_unit_id":"208942241","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"BA83654","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FDUF5HT1MDA03740","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-18T09:45:19.000000Z","updated_at":"2025-09-18T09:45:19.000000Z"}]},{"id":7753644,"change_date":"2025-01-31 21:40:00","inspection_id":"83745012","dot_number":"376802","report_state":"NY","report_number":"SPT3020685","insp_date":"2025-01-24 00:00:00","insp_start_time":"1252","insp_end_time":"1308","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"SLOATSBURG NY","county_code_state":"NY","county_code":"087","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-01-31 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1306432","transaction_code":"A","transaction_date":"2025-01-31 00:00:00","upload_date":"2025-01-31 00:00:00","upload_first_byte":"0","upload_dot_number":"00376802","upload_search_indicator":null,"census_search_date":"2025-01-31 21:40:00","snet_input_date":"2025-01-24 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-01-31 21:40:00","insp_carrier_name":"MCPHEE ELECTRIC LTD","insp_carrier_street":"505 MAIN STREET","insp_carrier_city":"FARMINGTON","insp_carrier_state":"CT","insp_carrier_zip_code":"06032-2912","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:59:10.000000Z","updated_at":"2025-03-17T20:59:10.000000Z","inspection_violations":[{"id":12115342,"change_date":"2025-01-31 21:40:00","inspection_id":"83745012","insp_violation_id":"264269063","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-17T22:05:05.000000Z","updated_at":"2025-03-17T22:05:05.000000Z","normalized_code":"3922SLLTCD"}],"inspection_per_units":[{"id":12512610,"change_date":"2025-01-31 21:40:00","inspection_id":"83745012","insp_unit_id":"205093172","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"14829","insp_unit_license":"K91494","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FVACWDT5EHFK8829","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:53:07.000000Z","updated_at":"2025-03-17T23:53:07.000000Z"}]},{"id":7666979,"change_date":"2025-01-21 21:39:00","inspection_id":"83654172","dot_number":"376802","report_state":"NY","report_number":"SPC3010365","insp_date":"2025-01-14 00:00:00","insp_start_time":"1145","insp_end_time":"1211","registration_date":null,"region":"ES","ci_status_code":"C","location":"90777E","location_desc":"UNADILLA NY","county_code_state":"NY","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":"U","pen_cen_match":"I","final_status_date":"2025-01-21 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"84899","viol_total":"3","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":"1271377","transaction_code":"A","transaction_date":"2025-01-21 00:00:00","upload_date":"2025-01-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00376802","upload_search_indicator":null,"census_search_date":"2025-01-21 21:39:00","snet_input_date":"2025-01-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-01-21 21:39:00","insp_carrier_name":"MCPHEE ELECTRIC LTD","insp_carrier_street":"505 MAIN STREET","insp_carrier_city":"FARMINGTON","insp_carrier_state":"CT","insp_carrier_zip_code":"06032-2912","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:57:26.000000Z","updated_at":"2025-03-17T20:57:26.000000Z","inspection_violations":[{"id":11979711,"change_date":"2025-01-21 21:39:00","inspection_id":"83654172","insp_violation_id":"264091064","seq_no":"1","part_no":"390","part_no_section":"21TB2-DOT","insp_viol_unit":"1","insp_unit_id":"204925251","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:20.000000Z","updated_at":"2025-03-17T22:04:20.000000Z","normalized_code":"39021TB2DOT"},{"id":11979712,"change_date":"2025-01-21 21:39:00","inspection_id":"83654172","insp_violation_id":"264091065","seq_no":"2","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"204925251","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:20.000000Z","updated_at":"2025-03-17T22:04:20.000000Z","normalized_code":"39617CPI"},{"id":11979713,"change_date":"2025-01-21 21:39:00","inspection_id":"83654172","insp_violation_id":"264091066","seq_no":"3","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"204925252","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:20.000000Z","updated_at":"2025-03-17T22:04:20.000000Z","normalized_code":"39617CPI"}],"inspection_per_units":[{"id":12371703,"change_date":"2025-01-21 21:39:00","inspection_id":"83654172","insp_unit_id":"204925251","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEVROLET","insp_unit_company":"24246","insp_unit_license":"C380792","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1GCRDAED0RZ375246","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:51:32.000000Z","updated_at":"2025-03-17T23:51:32.000000Z"},{"id":12371704,"change_date":"2025-01-21 21:39:00","inspection_id":"83654172","insp_unit_id":"204925252","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":null,"insp_unit_license":"AJ74042","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"4P5CE2020K3035933","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:51:32.000000Z","updated_at":"2025-03-17T23:51:32.000000Z"}]},{"id":7612573,"change_date":"2025-01-14 21:54:00","inspection_id":"83597046","dot_number":"376802","report_state":"NY","report_number":"SPC3030333","insp_date":"2025-01-07 00:00:00","insp_start_time":"0852","insp_end_time":"0907","registration_date":null,"region":"ES","ci_status_code":"C","location":"30690M","location_desc":"PREBLE NY","county_code_state":"NY","county_code":"023","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"MCPHEE ELECTRIC","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":"2025-01-14 21:54:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1245186","transaction_code":"A","transaction_date":"2025-01-14 00:00:00","upload_date":"2025-01-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00376802","upload_search_indicator":null,"census_search_date":"2025-01-14 21:54:00","snet_input_date":"2025-01-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-01-14 21:54:00","insp_carrier_name":"MCPHEE ELECTRIC LTD","insp_carrier_street":"505 MAIN STREET","insp_carrier_city":"FARMINGTON","insp_carrier_state":"CT","insp_carrier_zip_code":"06032-2912","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:56:09.000000Z","updated_at":"2025-03-17T20:56:09.000000Z","inspection_violations":[{"id":11900229,"change_date":"2025-01-14 21:54:00","inspection_id":"83597046","insp_violation_id":"263971890","seq_no":"1","part_no":"391","part_no_section":"41A","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:04:00.000000Z","updated_at":"2025-03-17T22:04:00.000000Z","normalized_code":"39141A"}],"inspection_per_units":[{"id":12283329,"change_date":"2025-01-14 21:54:00","inspection_id":"83597046","insp_unit_id":"204813297","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":null,"insp_unit_license":"3823499","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"3ALACWFC1LDLN5985","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:50:33.000000Z","updated_at":"2025-03-17T23:50:33.000000Z"}]},{"id":7448203,"change_date":"2025-01-09 21:40:00","inspection_id":"83424357","dot_number":"376802","report_state":"RI","report_number":"00DP004427","insp_date":"2024-12-13 00:00:00","insp_start_time":"1012","insp_end_time":"1041","registration_date":"2025-01-09 00:00:00","region":"ET","ci_status_code":"C","location":"69","location_desc":"RT 95S @ EXIT 28A (RT 113)","county_code_state":"RI","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-12-31 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"16500","viol_total":"4","oos_total":"0","driver_viol_total":"4","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"86421","transaction_code":"C","transaction_date":"2024-12-31 00:00:00","upload_date":"2025-01-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00376802","upload_search_indicator":"M","census_search_date":"2024-12-31 21:37:00","snet_input_date":"2024-12-13 00:00:00","source_office":"1RIS001","mcmis_add_date":"2024-12-18 21:41:00","insp_carrier_name":"MCPHEE ELECTRIC LTD","insp_carrier_street":"505 MAIN STREET","insp_carrier_city":"FARMINGTON","insp_carrier_state":"CT","insp_carrier_zip_code":"06032-2912","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:51:32.000000Z","updated_at":"2025-03-17T20:51:32.000000Z","inspection_violations":[{"id":11639153,"change_date":"2025-01-09 21:40:00","inspection_id":"83424357","insp_violation_id":"263837710","seq_no":"1","part_no":"392","part_no_section":"2-SLLLR","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:39.000000Z","updated_at":"2025-03-17T22:02:39.000000Z","normalized_code":"3922SLLLR"},{"id":11639154,"change_date":"2025-01-09 21:40:00","inspection_id":"83424357","insp_violation_id":"263837711","seq_no":"2","part_no":"392","part_no_section":"2-SLLDL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:39.000000Z","updated_at":"2025-03-17T22:02:39.000000Z","normalized_code":"3922SLLDL"},{"id":11639155,"change_date":"2025-01-09 21:40:00","inspection_id":"83424357","insp_violation_id":"263837712","seq_no":"3","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:39.000000Z","updated_at":"2025-03-17T22:02:39.000000Z","normalized_code":"39141AMCPC"},{"id":11639156,"change_date":"2025-01-09 21:40:00","inspection_id":"83424357","insp_violation_id":"263837713","seq_no":"4","part_no":"376","part_no_section":"11D1","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:39.000000Z","updated_at":"2025-03-17T22:02:39.000000Z","normalized_code":"37611D1"}],"inspection_per_units":[{"id":12015530,"change_date":"2025-01-09 21:40:00","inspection_id":"83424357","insp_unit_id":"204725245","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"1MZ305","insp_unit_license_state":"RI","insp_unit_vehicle_id_number":"1FDUF4HT5NDA28166","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:47:40.000000Z","updated_at":"2025-03-17T23:47:40.000000Z"}]},{"id":6867989,"change_date":"2024-10-02 21:40:00","inspection_id":"82810442","dot_number":"376802","report_state":"CT","report_number":"3063006765","insp_date":"2024-10-02 00:00:00","insp_start_time":"0657","insp_end_time":"0740","registration_date":null,"region":"ET","ci_status_code":"C","location":"052","location_desc":"FARMINGTON","county_code_state":"CT","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"NONC","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-02 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"719694","transaction_code":"A","transaction_date":"2024-10-02 00:00:00","upload_date":"2024-10-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00376802","upload_search_indicator":null,"census_search_date":"2024-10-02 21:40:00","snet_input_date":"2024-10-02 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-10-02 21:40:00","insp_carrier_name":"MCPHEE ELECTRIC LTD","insp_carrier_street":"505 MAIN STREET","insp_carrier_city":"FARMINGTON","insp_carrier_state":"CT","insp_carrier_zip_code":"06032","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:39:24.000000Z","updated_at":"2025-03-17T20:39:24.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11076001,"change_date":"2024-10-02 21:40:00","inspection_id":"82810442","insp_unit_id":"203225463","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"42","insp_unit_license":"67047A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"3HAMMMMN2KL595972","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:37:43.000000Z","updated_at":"2025-03-17T23:37:43.000000Z"}]},{"id":6677113,"change_date":"2024-09-09 21:40:00","inspection_id":"82607322","dot_number":"376802","report_state":"MA","report_number":"DD00001797","insp_date":"2024-09-09 00:00:00","insp_start_time":"0909","insp_end_time":"0921","registration_date":null,"region":"ET","ci_status_code":"C","location":"322H","location_desc":"H-STURBRIDGE","county_code_state":"MA","county_code":"027","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SELF\/SAME","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-09 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"499137","transaction_code":"A","transaction_date":"2024-09-09 00:00:00","upload_date":"2024-09-09 00:00:00","upload_first_byte":"0","upload_dot_number":"00376802","upload_search_indicator":"M","census_search_date":"2024-09-09 21:40:00","snet_input_date":"2024-09-09 00:00:00","source_office":"1MAS001","mcmis_add_date":"2024-09-09 21:40:00","insp_carrier_name":"MCPHEE ELECTRIC LTD","insp_carrier_street":"505 MAIN STREET","insp_carrier_city":"FARMINGTON","insp_carrier_state":"CT","insp_carrier_zip_code":"06032-2912","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:35:16.000000Z","updated_at":"2025-03-17T20:35:16.000000Z","inspection_violations":[{"id":10392208,"change_date":"2024-09-09 21:40:00","inspection_id":"82607322","insp_violation_id":"261683712","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2025-03-17T21:56:19.000000Z","updated_at":"2025-03-17T21:56:19.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10765933,"change_date":"2024-09-09 21:40:00","inspection_id":"82607322","insp_unit_id":"202820469","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"20709","insp_unit_license":"AP31521","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FVACWFC3LHLF3709","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:34:29.000000Z","updated_at":"2025-03-17T23:34:29.000000Z"}]},{"id":5385077,"change_date":"2024-03-28 21:40:00","inspection_id":"81213175","dot_number":"376802","report_state":"CT","report_number":"3070005834","insp_date":"2024-03-27 00:00:00","insp_start_time":"1452","insp_end_time":"1505","registration_date":null,"region":"ET","ci_status_code":"C","location":"131","location_desc":"SOUTHINGTON","county_code_state":"CT","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"0","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-03-28 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"703542","transaction_code":"A","transaction_date":"2024-03-28 00:00:00","upload_date":"2024-03-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00376802","upload_search_indicator":null,"census_search_date":"2024-03-28 21:40:00","snet_input_date":"2024-03-27 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-03-28 21:40:00","insp_carrier_name":"MCPHEE ELECTRIC LTD","insp_carrier_street":"505 MAIN STREET","insp_carrier_city":"FARMINGTON","insp_carrier_state":"CT","insp_carrier_zip_code":"06032","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:09:26.000000Z","updated_at":"2025-03-17T20:09:26.000000Z","inspection_violations":[{"id":8311332,"change_date":"2024-03-28 21:40:00","inspection_id":"81213175","insp_violation_id":"258625345","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":"V126983-5","created_at":"2025-03-17T21:46:13.000000Z","updated_at":"2025-03-17T21:46:13.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8672737,"change_date":"2024-03-28 21:40:00","inspection_id":"81213175","insp_unit_id":"200125709","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"53564A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1HTMMAAN49H051816","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:13:40.000000Z","updated_at":"2025-03-17T23:13:40.000000Z"}]},{"id":4595118,"change_date":"2023-12-12 21:41:00","inspection_id":"80350487","dot_number":"376802","report_state":"CT","report_number":"3129004533","insp_date":"2023-12-11 00:00:00","insp_start_time":"1400","insp_end_time":"1418","registration_date":"2023-12-11 00:00:00","region":"ET","ci_status_code":"C","location":"119","location_desc":"ROCKY HILL","county_code_state":"CT","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-12-11 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"694157","transaction_code":"C","transaction_date":"2023-12-11 00:00:00","upload_date":"2023-12-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00376802","upload_search_indicator":null,"census_search_date":"2023-12-11 21:40:00","snet_input_date":"2023-12-11 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-12-11 21:40:00","insp_carrier_name":"MCPHEE ELECTRIC LTD","insp_carrier_street":"505 MAIN STREET","insp_carrier_city":"FARMINGTON","insp_carrier_state":"CT","insp_carrier_zip_code":"06032","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:53:49.000000Z","updated_at":"2025-03-17T19:53:49.000000Z","inspection_violations":[{"id":7107017,"change_date":"2023-12-12 21:41:00","inspection_id":"80350487","insp_violation_id":"256830924","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"198457022","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:20.000000Z","updated_at":"2025-03-17T21:40:20.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7390815,"change_date":"2023-12-12 21:41:00","inspection_id":"80350487","insp_unit_id":"198457022","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"K91494","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FVACWDT5EHFK8829","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:02:08.000000Z","updated_at":"2025-03-17T23:02:08.000000Z"}]},{"id":1270517,"change_date":"2022-10-06 21:39:00","inspection_id":"76591987","dot_number":"376802","report_state":"MA","report_number":"CR00002432","insp_date":"2022-09-12 00:00:00","insp_start_time":"1557","insp_end_time":"1606","registration_date":"2022-10-06 00:00:00","region":"ET","ci_status_code":"C","location":"064H","location_desc":"H-CHARLTON","county_code_state":"MA","county_code":"027","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-09-13 21:40: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":"451877","transaction_code":"C","transaction_date":"2022-09-13 00:00:00","upload_date":"2022-10-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00376802","upload_search_indicator":"M","census_search_date":"2022-09-13 21:40:00","snet_input_date":"2022-09-12 00:00:00","source_office":"1MAS001","mcmis_add_date":"2022-09-13 21:40:00","insp_carrier_name":"MCPHEE ELECTRIC LTD","insp_carrier_street":"505 MAIN STREET","insp_carrier_city":"FARMINGTON","insp_carrier_state":"CT","insp_carrier_zip_code":"06032-2912","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:50:07.000000Z","updated_at":"2025-03-17T18:50:07.000000Z","inspection_violations":[{"id":2011851,"change_date":"2022-10-06 21:39:00","inspection_id":"76591987","insp_violation_id":"248864308","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:16:14.000000Z","updated_at":"2025-03-17T21:16:14.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2044651,"change_date":"2022-10-06 21:39:00","inspection_id":"76591987","insp_unit_id":"191298094","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"AU42019","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FDUF5HT5LEC52762","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:02.000000Z","updated_at":"2025-03-17T22:21:02.000000Z"}]},{"id":1254703,"change_date":"2022-09-12 21:42:00","inspection_id":"76573720","dot_number":"376802","report_state":"CT","report_number":"3070003826","insp_date":"2022-09-09 00:00:00","insp_start_time":"0751","insp_end_time":"0815","registration_date":null,"region":"ET","ci_status_code":"C","location":"110","location_desc":"PLAINVILLE","county_code_state":"CT","county_code":"003","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"0","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-09-12 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"653881","transaction_code":"A","transaction_date":"2022-09-09 00:00:00","upload_date":"2022-09-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00376802","upload_search_indicator":null,"census_search_date":"2022-09-12 21:42:00","snet_input_date":"2022-09-09 00:00:00","source_office":"1CTS001","mcmis_add_date":"2022-09-12 21:42:00","insp_carrier_name":"MCPHEE ELECTRIC LTD","insp_carrier_street":"505 MAIN STREET","insp_carrier_city":"FARMINGTON","insp_carrier_state":"CT","insp_carrier_zip_code":"06032","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:49:45.000000Z","updated_at":"2025-03-17T18:49:45.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2019562,"change_date":"2022-09-12 21:42:00","inspection_id":"76573720","insp_unit_id":"190824724","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"K78114","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FVACWDT7BDBA6494","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:52.000000Z","updated_at":"2025-03-17T22:20:52.000000Z"}]},{"id":1071790,"change_date":"2022-08-18 21:39:00","inspection_id":"76361196","dot_number":"376802","report_state":"CT","report_number":"3019003851","insp_date":"2022-08-18 00:00:00","insp_start_time":"1438","insp_end_time":"1455","registration_date":null,"region":"ET","ci_status_code":"C","location":"151","location_desc":"WATERBURY","county_code_state":"CT","county_code":"009","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"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-08-18 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"2","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"652021","transaction_code":"A","transaction_date":"2022-08-18 00:00:00","upload_date":"2022-08-18 00:00:00","upload_first_byte":"0","upload_dot_number":"00376802","upload_search_indicator":null,"census_search_date":"2022-08-18 21:39:00","snet_input_date":"2022-08-18 00:00:00","source_office":"1CTS001","mcmis_add_date":"2022-08-18 21:39:00","insp_carrier_name":"MCPHEE ELECTRIC LTD","insp_carrier_street":"505 MAIN STREET","insp_carrier_city":"FARMINGTON","insp_carrier_state":"CT","insp_carrier_zip_code":"06032","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:46:32.000000Z","updated_at":"2025-03-17T18:46:32.000000Z","inspection_violations":[{"id":1689572,"change_date":"2022-08-18 21:39:00","inspection_id":"76361196","insp_violation_id":"247809553","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":"Y990643-1","created_at":"2025-03-17T21:14:53.000000Z","updated_at":"2025-03-17T21:14:53.000000Z","normalized_code":"39216A"},{"id":1689573,"change_date":"2022-08-18 21:39:00","inspection_id":"76361196","insp_violation_id":"247809554","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:53.000000Z","updated_at":"2025-03-17T21:14:53.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1724517,"change_date":"2022-08-18 21:39:00","inspection_id":"76361196","insp_unit_id":"190390524","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"K91494","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FVACWDT5EHFK8829","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:18:52.000000Z","updated_at":"2025-03-17T22:18:52.000000Z"}]},{"id":852150,"change_date":"2022-07-20 21:41:00","inspection_id":"76104499","dot_number":"376802","report_state":"CT","report_number":"3070003570","insp_date":"2022-07-20 00:00:00","insp_start_time":"1250","insp_end_time":"1300","registration_date":null,"region":"ET","ci_status_code":"C","location":"131","location_desc":"SOUTHINGTON","county_code_state":"CT","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-07-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"649285","transaction_code":"A","transaction_date":"2022-07-20 00:00:00","upload_date":"2022-07-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00376802","upload_search_indicator":null,"census_search_date":"2022-07-20 21:41:00","snet_input_date":"2022-07-20 00:00:00","source_office":"1CTS001","mcmis_add_date":"2022-07-20 21:41:00","insp_carrier_name":"MCPHEE ELECTRIC LTD","insp_carrier_street":"505 MAIN STREET","insp_carrier_city":"FARMINGTON","insp_carrier_state":"CT","insp_carrier_zip_code":"06032","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:42:41.000000Z","updated_at":"2025-03-17T18:42:41.000000Z","inspection_violations":[{"id":1343214,"change_date":"2022-07-20 21:41:00","inspection_id":"76104499","insp_violation_id":"247195635","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:13:21.000000Z","updated_at":"2025-03-17T21:13:21.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":1371842,"change_date":"2022-07-20 21:41:00","inspection_id":"76104499","insp_unit_id":"189865460","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"59865A","insp_unit_license_state":"CT","insp_unit_vehicle_id_number":"1FVACYDC65HV16875","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:16:37.000000Z","updated_at":"2025-03-17T22:16:37.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/376802\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/376802\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/376802\/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\/376802\/inspections","per_page":100,"prev_page_url":null,"to":18,"total":18}