{"current_page":1,"data":[{"id":10874855,"change_date":"2026-01-28 21:37:00","inspection_id":"86905056","dot_number":"3301984","report_state":"MA","report_number":"DC00003162","insp_date":"2026-01-28 00:00:00","insp_start_time":"0940","insp_end_time":"1010","registration_date":null,"region":"ET","ci_status_code":"C","location":"085H","location_desc":"H-DEDHAM","county_code_state":"MA","county_code":"021","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-01-28 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"129000","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"539186","transaction_code":"A","transaction_date":"2026-01-28 00:00:00","upload_date":"2026-01-28 00:00:00","upload_first_byte":"0","upload_dot_number":"03301984","upload_search_indicator":"M","census_search_date":"2026-01-28 21:37:00","snet_input_date":"2026-01-28 00:00:00","source_office":"1MAS001","mcmis_add_date":"2026-01-28 21:37:00","insp_carrier_name":"MCGUE EXCAVATING LLC","insp_carrier_street":"159 BROOK RD","insp_carrier_city":"QUINCY","insp_carrier_state":"MA","insp_carrier_zip_code":"02169-6525","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-01-31T10:36:26.000000Z","updated_at":"2026-02-08T10:31:17.000000Z","inspection_violations":[{"id":18202259,"change_date":"2026-01-28 21:37:00","inspection_id":"86905056","insp_violation_id":"271467518","seq_no":"1","part_no":"393","part_no_section":"78A-WS","insp_viol_unit":"1","insp_unit_id":"211322832","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-31T10:49:22.000000Z","updated_at":"2026-02-08T10:38:26.000000Z","normalized_code":"39378AWS"},{"id":18202260,"change_date":"2026-01-28 21:37:00","inspection_id":"86905056","insp_violation_id":"271467519","seq_no":"2","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"2","insp_unit_id":"211322831","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-31T10:49:22.000000Z","updated_at":"2026-02-08T10:38:26.000000Z","normalized_code":"3939ALIL"},{"id":18202261,"change_date":"2026-01-28 21:37:00","inspection_id":"86905056","insp_violation_id":"271467520","seq_no":"3","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"211322831","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-31T10:49:22.000000Z","updated_at":"2026-02-08T10:38:26.000000Z","normalized_code":"39617CPI"}],"inspection_per_units":[{"id":18276939,"change_date":"2026-01-28 21:37:00","inspection_id":"86905056","insp_unit_id":"211322831","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CSMM","insp_unit_company":null,"insp_unit_license":"TZ23627D","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"5JPBU312XEP034420","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-31T10:11:00.000000Z","updated_at":"2026-02-08T10:04:35.000000Z"},{"id":18276940,"change_date":"2026-01-28 21:37:00","inspection_id":"86905056","insp_unit_id":"211322832","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"V38592","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1NPXX4EX4LD639639","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-31T10:11:00.000000Z","updated_at":"2026-02-08T10:04:35.000000Z"}]},{"id":9958694,"change_date":"2025-10-16 21:40:00","inspection_id":"86066667","dot_number":"3301984","report_state":"MA","report_number":"DF00002747","insp_date":"2025-10-16 00:00:00","insp_start_time":"0004","insp_end_time":"0018","registration_date":null,"region":"ET","ci_status_code":"C","location":"044H","location_desc":"H-BRAINTREE","county_code_state":"MA","county_code":"021","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-10-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"531566","transaction_code":"A","transaction_date":"2025-10-16 00:00:00","upload_date":"2025-10-16 00:00:00","upload_first_byte":"0","upload_dot_number":"03301984","upload_search_indicator":"M","census_search_date":"2025-10-16 21:40:00","snet_input_date":"2025-10-16 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-10-16 21:40:00","insp_carrier_name":"MCGUE EXCAVATING LLC","insp_carrier_street":"159 BROOK RD","insp_carrier_city":"QUINCY","insp_carrier_state":"MA","insp_carrier_zip_code":"02169-6525","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-10-19T10:01:40.000000Z","updated_at":"2025-10-20T10:00:46.000000Z","inspection_violations":[{"id":16447822,"change_date":"2025-10-16 21:40:00","inspection_id":"86066667","insp_violation_id":"269338765","seq_no":"1","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"209502961","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-19T10:17:40.000000Z","updated_at":"2025-10-20T10:16:24.000000Z","normalized_code":"39617CPI"},{"id":16447823,"change_date":"2025-10-16 21:40:00","inspection_id":"86066667","insp_violation_id":"269338766","seq_no":"2","part_no":"390","part_no_section":"19B2-BIENNIAL","insp_viol_unit":"1","insp_unit_id":"209502961","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-19T10:17:40.000000Z","updated_at":"2025-10-20T10:16:24.000000Z","normalized_code":"39019B2BIENNIAL"},{"id":16447824,"change_date":"2025-10-16 21:40:00","inspection_id":"86066667","insp_violation_id":"269338767","seq_no":"3","part_no":"396","part_no_section":"9D2-FTF","insp_viol_unit":"1","insp_unit_id":"209502961","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-19T10:17:40.000000Z","updated_at":"2025-10-20T10:16:24.000000Z","normalized_code":"3969D2FTF"}],"inspection_per_units":[{"id":16534853,"change_date":"2025-10-16 21:40:00","inspection_id":"86066667","insp_unit_id":"209502961","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"X81137","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"3FRNF65C28V686039","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-19T09:46:55.000000Z","updated_at":"2025-10-20T09:46:00.000000Z"}]},{"id":8778093,"change_date":"2025-05-30 21:40:00","inspection_id":"84823555","dot_number":"3301984","report_state":"MA","report_number":"DX00000351","insp_date":"2025-05-30 00:00:00","insp_start_time":"1221","insp_end_time":"1230","registration_date":null,"region":"ET","ci_status_code":"C","location":"049H","location_desc":"H-BROCKTON","county_code_state":"MA","county_code":"023","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-05-30 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":"519274","transaction_code":"A","transaction_date":"2025-05-30 00:00:00","upload_date":"2025-05-30 00:00:00","upload_first_byte":"0","upload_dot_number":"03301984","upload_search_indicator":"M","census_search_date":"2025-05-30 21:40:00","snet_input_date":"2025-05-30 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-05-30 21:40:00","insp_carrier_name":"MCGUE EXCAVATING LLC","insp_carrier_street":"159 BROOK RD","insp_carrier_city":"QUINCY","insp_carrier_state":"MA","insp_carrier_zip_code":"02169-6525","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-06-04T10:01:06.000000Z","updated_at":"2025-06-04T10:01:06.000000Z","inspection_violations":[{"id":14031511,"change_date":"2025-05-30 21:40:00","inspection_id":"84823555","insp_violation_id":"266573709","seq_no":"1","part_no":"390","part_no_section":"19B2-BIENNIAL","insp_viol_unit":"1","insp_unit_id":"207148479","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-02T10:17:11.000000Z","updated_at":"2025-06-03T10:17:23.000000Z","normalized_code":"39019B2BIENNIAL"}],"inspection_per_units":[{"id":14361878,"change_date":"2025-05-30 21:40:00","inspection_id":"84823555","insp_unit_id":"207148479","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"13","insp_unit_license":"X81137","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"3FRNF65C28V686039","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-02T09:46:21.000000Z","updated_at":"2025-06-03T09:45:39.000000Z"}]},{"id":8449135,"change_date":"2025-04-23 21:41:00","inspection_id":"84476672","dot_number":"3301984","report_state":"MA","report_number":"DA00003319","insp_date":"2025-04-22 00:00:00","insp_start_time":"1638","insp_end_time":"1652","registration_date":null,"region":"ET","ci_status_code":"C","location":"038H","location_desc":"H-BOSTON","county_code_state":"MA","county_code":"025","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-04-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"4","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"515488","transaction_code":"A","transaction_date":"2025-04-23 00:00:00","upload_date":"2025-04-23 00:00:00","upload_first_byte":"0","upload_dot_number":"03301984","upload_search_indicator":"M","census_search_date":"2025-04-23 21:41:00","snet_input_date":"2025-04-22 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-04-23 21:41:00","insp_carrier_name":"MCGUE EXCAVATING LLC","insp_carrier_street":"159 BROOK RD","insp_carrier_city":"QUINCY","insp_carrier_state":"MA","insp_carrier_zip_code":"02169-6525","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-04-26T10:28:25.000000Z","updated_at":"2025-04-27T10:30:49.000000Z","inspection_violations":[{"id":13349445,"change_date":"2025-04-23 21:41:00","inspection_id":"84476672","insp_violation_id":"265785959","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":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-25T11:06:48.000000Z","updated_at":"2025-04-26T10:48:01.000000Z","normalized_code":"39141AMCPC"},{"id":13349446,"change_date":"2025-04-23 21:41:00","inspection_id":"84476672","insp_violation_id":"265785960","seq_no":"2","part_no":"391","part_no_section":"11A-QMC","insp_viol_unit":"1","insp_unit_id":"206452488","insp_violation_category_id":"54","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-25T11:06:48.000000Z","updated_at":"2025-04-26T10:48:01.000000Z","normalized_code":"39111AQMC"},{"id":13349447,"change_date":"2025-04-23 21:41:00","inspection_id":"84476672","insp_violation_id":"265785961","seq_no":"3","part_no":"390","part_no_section":"19B2-BIENNIAL","insp_viol_unit":"1","insp_unit_id":"206452488","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-25T11:06:48.000000Z","updated_at":"2025-04-26T10:48:01.000000Z","normalized_code":"39019B2BIENNIAL"},{"id":13349448,"change_date":"2025-04-23 21:41:00","inspection_id":"84476672","insp_violation_id":"265785962","seq_no":"4","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"206452488","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-25T11:06:48.000000Z","updated_at":"2025-04-26T10:48:01.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":13723740,"change_date":"2025-04-23 21:41:00","inspection_id":"84476672","insp_unit_id":"206452488","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"W54771","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"54DK6S164LSG70129","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-26T10:12:34.000000Z","updated_at":"2025-04-27T10:00:05.000000Z"}]},{"id":7781847,"change_date":"2025-02-04 21:39:00","inspection_id":"83774899","dot_number":"3301984","report_state":"MA","report_number":"DA00003032","insp_date":"2025-02-03 00:00:00","insp_start_time":"1647","insp_end_time":"1700","registration_date":null,"region":"ET","ci_status_code":"C","location":"208H","location_desc":"H-MILTON","county_code_state":"MA","county_code":"021","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-02-04 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"508711","transaction_code":"A","transaction_date":"2025-02-04 00:00:00","upload_date":"2025-02-04 00:00:00","upload_first_byte":"0","upload_dot_number":"03301984","upload_search_indicator":"M","census_search_date":"2025-02-04 21:39:00","snet_input_date":"2025-02-03 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-02-04 21:39:00","insp_carrier_name":"MCGUE EXCAVATING LLC","insp_carrier_street":"159 BROOK RD","insp_carrier_city":"QUINCY","insp_carrier_state":"MA","insp_carrier_zip_code":"02169-6525","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:59:53.000000Z","updated_at":"2025-03-17T20:59:53.000000Z","inspection_violations":[{"id":12160585,"change_date":"2025-02-04 21:39:00","inspection_id":"83774899","insp_violation_id":"264327841","seq_no":"1","part_no":"390","part_no_section":"21TB1-MC","insp_viol_unit":"1","insp_unit_id":"205148160","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:21.000000Z","updated_at":"2025-03-17T22:05:21.000000Z","normalized_code":"39021TB1MC"},{"id":12160586,"change_date":"2025-02-04 21:39:00","inspection_id":"83774899","insp_violation_id":"264327842","seq_no":"2","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"205148161","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:21.000000Z","updated_at":"2025-03-17T22:05:21.000000Z","normalized_code":"39617CPI"}],"inspection_per_units":[{"id":12558873,"change_date":"2025-02-04 21:39:00","inspection_id":"83774899","insp_unit_id":"205148160","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"F48031","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"112H8V328YL056285","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:53:41.000000Z","updated_at":"2025-03-17T23:53:41.000000Z"},{"id":12558874,"change_date":"2025-02-04 21:39:00","inspection_id":"83774899","insp_unit_id":"205148161","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAGB","insp_unit_company":null,"insp_unit_license":"Y33462","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"3FRXW75T08V643558","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:53:41.000000Z","updated_at":"2025-03-17T23:53:41.000000Z"}]},{"id":7237828,"change_date":"2024-11-20 21:40:00","inspection_id":"83202800","dot_number":"3301984","report_state":"MA","report_number":"CH00005590","insp_date":"2024-11-20 00:00:00","insp_start_time":"1452","insp_end_time":"1508","registration_date":null,"region":"ET","ci_status_code":"C","location":"380H","location_desc":"H-WILMINGTON","county_code_state":"MA","county_code":"017","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-11-20 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":"503922","transaction_code":"A","transaction_date":"2024-11-20 00:00:00","upload_date":"2024-11-20 00:00:00","upload_first_byte":"0","upload_dot_number":"03301984","upload_search_indicator":"M","census_search_date":"2024-11-20 21:40:00","snet_input_date":"2024-11-20 00:00:00","source_office":"1MAS001","mcmis_add_date":"2024-11-20 21:40:00","insp_carrier_name":"MCGUE EXCAVATING LLC","insp_carrier_street":"159 BROOK RD","insp_carrier_city":"QUINCY","insp_carrier_state":"MA","insp_carrier_zip_code":"02169-6525","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:46:52.000000Z","updated_at":"2025-03-17T20:46:52.000000Z","inspection_violations":[{"id":11314522,"change_date":"2024-11-20 21:40:00","inspection_id":"83202800","insp_violation_id":"262994822","seq_no":"1","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"203968573","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:56.000000Z","updated_at":"2025-03-17T22:00:56.000000Z","normalized_code":"39617CPI"}],"inspection_per_units":[{"id":11674561,"change_date":"2024-11-20 21:40:00","inspection_id":"83202800","insp_unit_id":"203968573","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"12","insp_unit_license":"X53605","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"3FRWF75D18V070724","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:43:58.000000Z","updated_at":"2025-03-17T23:43:58.000000Z"}]},{"id":3206567,"change_date":"2023-06-05 21:41:00","inspection_id":"78803723","dot_number":"3301984","report_state":"MA","report_number":"DC00000668","insp_date":"2023-06-02 00:00:00","insp_start_time":"1330","insp_end_time":"1352","registration_date":null,"region":"ET","ci_status_code":"C","location":"038H","location_desc":"H-BOSTON","county_code_state":"MA","county_code":"025","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-06-05 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"86000","viol_total":"4","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"467290","transaction_code":"A","transaction_date":"2023-06-05 00:00:00","upload_date":"2023-06-05 00:00:00","upload_first_byte":"0","upload_dot_number":"03301984","upload_search_indicator":"M","census_search_date":"2023-06-05 21:41:00","snet_input_date":"2023-06-02 00:00:00","source_office":"1MAS001","mcmis_add_date":"2023-06-05 21:41:00","insp_carrier_name":"MCGUE EXCAVATING LLC","insp_carrier_street":"159 BROOK RD","insp_carrier_city":"QUINCY","insp_carrier_state":"MA","insp_carrier_zip_code":"02169-6525","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:26:28.000000Z","updated_at":"2025-03-17T19:26:28.000000Z","inspection_violations":[{"id":4940752,"change_date":"2023-06-05 21:41:00","inspection_id":"78803723","insp_violation_id":"253267195","seq_no":"1","part_no":"392","part_no_section":"82(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:01.000000Z","updated_at":"2025-03-17T21:30:01.000000Z","normalized_code":"39282A1"},{"id":4940753,"change_date":"2023-06-05 21:41:00","inspection_id":"78803723","insp_violation_id":"253267196","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"195302817","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:01.000000Z","updated_at":"2025-03-17T21:30:01.000000Z","normalized_code":"3939A"},{"id":4940754,"change_date":"2023-06-05 21:41:00","inspection_id":"78803723","insp_violation_id":"253267197","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"195302817","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:01.000000Z","updated_at":"2025-03-17T21:30:01.000000Z","normalized_code":"3939A"},{"id":4940755,"change_date":"2023-06-05 21:41:00","inspection_id":"78803723","insp_violation_id":"253267198","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"195302817","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:01.000000Z","updated_at":"2025-03-17T21:30:01.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":5157306,"change_date":"2023-06-05 21:41:00","inspection_id":"78803723","insp_unit_id":"195302817","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"V59208","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1NPCXPEX7LD663109","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:43:38.000000Z","updated_at":"2025-03-17T22:43:38.000000Z"}]},{"id":2804841,"change_date":"2023-04-14 21:40:00","inspection_id":"78349673","dot_number":"3301984","report_state":"MA","report_number":"DA00000777","insp_date":"2023-04-14 00:00:00","insp_start_time":"1207","insp_end_time":"1240","registration_date":null,"region":"ET","ci_status_code":"C","location":"044H","location_desc":"H-BRAINTREE","county_code_state":"MA","county_code":"021","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","shipping_paper_number":"137","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-04-14 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"77000","viol_total":"6","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"463966","transaction_code":"A","transaction_date":"2023-04-14 00:00:00","upload_date":"2023-04-14 00:00:00","upload_first_byte":"0","upload_dot_number":"03301984","upload_search_indicator":"M","census_search_date":"2023-04-14 21:40:00","snet_input_date":"2023-04-14 00:00:00","source_office":"1MAS001","mcmis_add_date":"2023-04-14 21:40:00","insp_carrier_name":"MCGUE EXCAVATING LLC","insp_carrier_street":"159 BROOK RD","insp_carrier_city":"QUINCY","insp_carrier_state":"MA","insp_carrier_zip_code":"02169-6525","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:18:29.000000Z","updated_at":"2025-03-17T19:18:29.000000Z","inspection_violations":[{"id":4305572,"change_date":"2023-04-14 21:40:00","inspection_id":"78349673","insp_violation_id":"252224497","seq_no":"1","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"194386690","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:09.000000Z","updated_at":"2025-03-17T21:27:09.000000Z","normalized_code":"39021TB"},{"id":4305573,"change_date":"2023-04-14 21:40:00","inspection_id":"78349673","insp_violation_id":"252224498","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"194386690","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:09.000000Z","updated_at":"2025-03-17T21:27:09.000000Z","normalized_code":"3939A"},{"id":4305574,"change_date":"2023-04-14 21:40:00","inspection_id":"78349673","insp_violation_id":"252224499","seq_no":"3","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"194386690","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:09.000000Z","updated_at":"2025-03-17T21:27:09.000000Z","normalized_code":"39360C"},{"id":4305575,"change_date":"2023-04-14 21:40:00","inspection_id":"78349673","insp_violation_id":"252224500","seq_no":"4","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"194386690","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:27:09.000000Z","updated_at":"2025-03-17T21:27:09.000000Z","normalized_code":"3963A1"},{"id":4305576,"change_date":"2023-04-14 21:40:00","inspection_id":"78349673","insp_violation_id":"252224501","seq_no":"5","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"194386690","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:27:09.000000Z","updated_at":"2025-03-17T21:27:09.000000Z","normalized_code":"39345D"},{"id":4305577,"change_date":"2023-04-14 21:40:00","inspection_id":"78349673","insp_violation_id":"252224502","seq_no":"6","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"194386690","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:09.000000Z","updated_at":"2025-03-17T21:27:09.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4514158,"change_date":"2023-04-14 21:40:00","inspection_id":"78349673","insp_unit_id":"194386690","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"V59208","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1NPCXPEX7LD663109","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:34.000000Z","updated_at":"2025-03-17T22:38:34.000000Z"}]},{"id":928331,"change_date":"2022-08-01 21:38:00","inspection_id":"76193857","dot_number":"3301984","report_state":"MA","report_number":"CB00007283","insp_date":"2022-08-01 00:00:00","insp_start_time":"0627","insp_end_time":"0644","registration_date":null,"region":"ET","ci_status_code":"C","location":"304H","location_desc":"H-SOUTH BOSTON","county_code_state":"MA","county_code":"025","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-08-01 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"8","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"449654","transaction_code":"A","transaction_date":"2022-08-01 00:00:00","upload_date":"2022-08-01 00:00:00","upload_first_byte":"0","upload_dot_number":"03301984","upload_search_indicator":"M","census_search_date":"2022-08-01 21:38:00","snet_input_date":"2022-08-01 00:00:00","source_office":"1MAS001","mcmis_add_date":"2022-08-01 21:38:00","insp_carrier_name":"MCGUE EXCAVATING LLC","insp_carrier_street":"159 BROOK RD","insp_carrier_city":"QUINCY","insp_carrier_state":"MA","insp_carrier_zip_code":"02169-6525","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:44:03.000000Z","updated_at":"2025-03-17T18:44:03.000000Z","inspection_violations":[{"id":1465460,"change_date":"2022-08-01 21:38:00","inspection_id":"76193857","insp_violation_id":"247416760","seq_no":"8","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"190050918","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:57.000000Z","updated_at":"2025-03-17T21:13:57.000000Z","normalized_code":"3939A"},{"id":1465461,"change_date":"2022-08-01 21:38:00","inspection_id":"76193857","insp_violation_id":"247416761","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:13:57.000000Z","updated_at":"2025-03-17T21:13:57.000000Z","normalized_code":"3922"},{"id":1465462,"change_date":"2022-08-01 21:38:00","inspection_id":"76193857","insp_violation_id":"247416762","seq_no":"2","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:57.000000Z","updated_at":"2025-03-17T21:13:57.000000Z","normalized_code":"39141A"},{"id":1465463,"change_date":"2022-08-01 21:38:00","inspection_id":"76193857","insp_violation_id":"247416763","seq_no":"3","part_no":"393","part_no_section":"30","insp_viol_unit":"1","insp_unit_id":"190050918","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:57.000000Z","updated_at":"2025-03-17T21:13:57.000000Z","normalized_code":"39330"},{"id":1465464,"change_date":"2022-08-01 21:38:00","inspection_id":"76193857","insp_violation_id":"247416764","seq_no":"4","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"190050918","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:57.000000Z","updated_at":"2025-03-17T21:13:57.000000Z","normalized_code":"39021TB"},{"id":1465465,"change_date":"2022-08-01 21:38:00","inspection_id":"76193857","insp_violation_id":"247416765","seq_no":"5","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"190050918","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:57.000000Z","updated_at":"2025-03-17T21:13:57.000000Z","normalized_code":"3922"},{"id":1465466,"change_date":"2022-08-01 21:38:00","inspection_id":"76193857","insp_violation_id":"247416766","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"190050918","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:57.000000Z","updated_at":"2025-03-17T21:13:57.000000Z","normalized_code":"3939A"},{"id":1465467,"change_date":"2022-08-01 21:38:00","inspection_id":"76193857","insp_violation_id":"247416767","seq_no":"7","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"190050918","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:57.000000Z","updated_at":"2025-03-17T21:13:57.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":1494692,"change_date":"2022-08-01 21:38:00","inspection_id":"76193857","insp_unit_id":"190050918","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"V47200","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"3FRNF65F25V128942","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:23.000000Z","updated_at":"2025-03-17T22:17:23.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/3301984\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/3301984\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/3301984\/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\/3301984\/inspections","per_page":100,"prev_page_url":null,"to":9,"total":9}