{"current_page":1,"data":[{"id":11815856,"change_date":"2026-05-05 21:38:00","inspection_id":"87750066","dot_number":"587195","report_state":"CT","report_number":"3010005041","insp_date":"2026-05-04 00:00:00","insp_start_time":"0658","insp_end_time":"0826","registration_date":null,"region":"ET","ci_status_code":"C","location":"047","location_desc":"EAST WINDSOR","county_code_state":"CT","county_code":"003","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"MARION EXCAVATING CO 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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-05-04 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"26500","viol_total":"14","oos_total":"5","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"13","vehicle_oos_total":"4","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"771901","transaction_code":"C","transaction_date":"2026-05-05 00:00:00","upload_date":"2026-05-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00587195","upload_search_indicator":null,"census_search_date":"2026-05-04 21:38:00","snet_input_date":"2026-05-04 00:00:00","source_office":"1CTS001","mcmis_add_date":"2026-05-04 21:38:00","insp_carrier_name":"MARION EXCAVATING CO INC","insp_carrier_street":"749 NEW LUDLOW ROAD","insp_carrier_city":"SOUTH HADLEY","insp_carrier_state":"MA","insp_carrier_zip_code":"01075","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-07T09:38:54.000000Z","updated_at":"2026-05-15T12:18:02.000000Z","inspection_violations":[{"id":20547823,"change_date":"2026-05-05 21:38:00","inspection_id":"87750066","insp_violation_id":"274038422","seq_no":"13","part_no":"393","part_no_section":"43DBMA","insp_viol_unit":"2","insp_unit_id":"213377071","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-05-07T09:57:13.000000Z","updated_at":"2026-05-15T12:41:43.000000Z","normalized_code":"39343DBMA"},{"id":20547824,"change_date":"2026-05-05 21:38:00","inspection_id":"87750066","insp_violation_id":"274038423","seq_no":"14","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"213377071","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-07T09:57:13.000000Z","updated_at":"2026-05-15T12:41:43.000000Z","normalized_code":"39617CPI"},{"id":20547811,"change_date":"2026-05-05 21:38:00","inspection_id":"87750066","insp_violation_id":"274038410","seq_no":"1","part_no":"383","part_no_section":"23A2-LCDLN","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"53","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-07T09:57:13.000000Z","updated_at":"2026-05-15T12:41:43.000000Z","normalized_code":"38323A2LCDLN"},{"id":20547812,"change_date":"2026-05-05 21:38:00","inspection_id":"87750066","insp_violation_id":"274038411","seq_no":"2","part_no":"390","part_no_section":"21TB1-MC","insp_viol_unit":"1","insp_unit_id":"213377070","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-07T09:57:13.000000Z","updated_at":"2026-05-15T12:41:43.000000Z","normalized_code":"39021TB1MC"},{"id":20547813,"change_date":"2026-05-05 21:38:00","inspection_id":"87750066","insp_violation_id":"274038412","seq_no":"3","part_no":"390","part_no_section":"21TB2-DOT","insp_viol_unit":"1","insp_unit_id":"213377070","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-07T09:57:13.000000Z","updated_at":"2026-05-15T12:41:43.000000Z","normalized_code":"39021TB2DOT"},{"id":20547814,"change_date":"2026-05-05 21:38:00","inspection_id":"87750066","insp_violation_id":"274038413","seq_no":"4","part_no":"392","part_no_section":"2-SLLIFTA","insp_viol_unit":"1","insp_unit_id":"213377070","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-07T09:57:13.000000Z","updated_at":"2026-05-15T12:41:43.000000Z","normalized_code":"3922SLLIFTA"},{"id":20547815,"change_date":"2026-05-05 21:38:00","inspection_id":"87750066","insp_violation_id":"274038414","seq_no":"5","part_no":"392","part_no_section":"2-SLLIRP","insp_viol_unit":"1","insp_unit_id":"213377070","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-07T09:57:13.000000Z","updated_at":"2026-05-15T12:41:43.000000Z","normalized_code":"3922SLLIRP"},{"id":20547816,"change_date":"2026-05-05 21:38:00","inspection_id":"87750066","insp_violation_id":"274038415","seq_no":"6","part_no":"392","part_no_section":"2-SLLEWG3","insp_viol_unit":"1","insp_unit_id":"213377070","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"V138559-3","created_at":"2026-05-07T09:57:13.000000Z","updated_at":"2026-05-15T12:41:43.000000Z","normalized_code":"3922SLLEWG3"},{"id":20547817,"change_date":"2026-05-05 21:38:00","inspection_id":"87750066","insp_violation_id":"274038416","seq_no":"7","part_no":"393","part_no_section":"95A1","insp_viol_unit":"1","insp_unit_id":"213377070","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-07T09:57:13.000000Z","updated_at":"2026-05-15T12:41:43.000000Z","normalized_code":"39395A1"},{"id":20547818,"change_date":"2026-05-05 21:38:00","inspection_id":"87750066","insp_violation_id":"274038417","seq_no":"8","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"213377070","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-07T09:57:13.000000Z","updated_at":"2026-05-15T12:41:43.000000Z","normalized_code":"39395F"},{"id":20547819,"change_date":"2026-05-05 21:38:00","inspection_id":"87750066","insp_violation_id":"274038418","seq_no":"9","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"213377070","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-07T09:57:13.000000Z","updated_at":"2026-05-15T12:41:43.000000Z","normalized_code":"39617CPI"},{"id":20547820,"change_date":"2026-05-05 21:38:00","inspection_id":"87750066","insp_violation_id":"274038419","seq_no":"10","part_no":"393","part_no_section":"9A-LSLIWR","insp_viol_unit":"2","insp_unit_id":"213377071","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-05-07T09:57:13.000000Z","updated_at":"2026-05-15T12:41:43.000000Z","normalized_code":"3939ALSLIWR"},{"id":20547821,"change_date":"2026-05-05 21:38:00","inspection_id":"87750066","insp_violation_id":"274038420","seq_no":"11","part_no":"393","part_no_section":"9A-LTSI","insp_viol_unit":"2","insp_unit_id":"213377071","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-05-07T09:57:13.000000Z","updated_at":"2026-05-15T12:41:43.000000Z","normalized_code":"3939ALTSI"},{"id":20547822,"change_date":"2026-05-05 21:38:00","inspection_id":"87750066","insp_violation_id":"274038421","seq_no":"12","part_no":"393","part_no_section":"9A-LTSI","insp_viol_unit":"2","insp_unit_id":"213377071","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-05-07T09:57:13.000000Z","updated_at":"2026-05-15T12:41:43.000000Z","normalized_code":"3939ALTSI"}],"inspection_per_units":[{"id":20551814,"change_date":"2026-05-05 21:38:00","inspection_id":"87750066","insp_unit_id":"213377070","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"2PYC84","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FT8W3BT5KEE79497","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-07T09:17:28.000000Z","updated_at":"2026-05-15T11:56:59.000000Z"},{"id":20551815,"change_date":"2026-05-05 21:38:00","inspection_id":"87750066","insp_unit_id":"213377071","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"KAUFM","insp_unit_company":null,"insp_unit_license":"509459","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"5VGFD2025HL003578","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-07T09:17:28.000000Z","updated_at":"2026-05-15T11:56:59.000000Z"}]},{"id":11481257,"change_date":"2026-05-27 21:39:00","inspection_id":"87400372","dot_number":"587195","report_state":"CT","report_number":"3010004973","insp_date":"2026-03-26 00:00:00","insp_start_time":"0732","insp_end_time":"0855","registration_date":"2026-04-06 00:00:00","region":"ET","ci_status_code":"C","location":"047","location_desc":"EAST WINDSOR","county_code_state":"CT","county_code":"003","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"MARION EXCAVATING CO 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":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-03-26 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"64000","viol_total":"7","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"768730","transaction_code":"C","transaction_date":"2026-05-27 00:00:00","upload_date":"2026-05-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00587195","upload_search_indicator":null,"census_search_date":"2026-03-26 21:39:00","snet_input_date":"2026-03-26 00:00:00","source_office":"1CTS001","mcmis_add_date":"2026-03-26 21:39:00","insp_carrier_name":"MARION EXCAVATING CO INC","insp_carrier_street":"749 NEW LUDLOW ROAD","insp_carrier_city":"SOUTH HADLEY","insp_carrier_state":"MA","insp_carrier_zip_code":"01075","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-29T09:53:53.000000Z","updated_at":"2026-06-07T09:30:03.000000Z","inspection_violations":[{"id":19562637,"change_date":"2026-05-27 21:39:00","inspection_id":"87400372","insp_violation_id":"274514625","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA1","insp_viol_unit":"1","insp_unit_id":"213762448","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"V138169-5","created_at":"2026-04-08T10:13:10.000000Z","updated_at":"2026-06-07T09:41:05.000000Z","normalized_code":"3922SLLEWA1"},{"id":19562642,"change_date":"2026-05-27 21:39:00","inspection_id":"87400372","insp_violation_id":"274514630","seq_no":"6","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"1","insp_unit_id":"213762448","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-08T10:13:10.000000Z","updated_at":"2026-06-07T09:41:05.000000Z","normalized_code":"39345B2BAIR"},{"id":19562638,"change_date":"2026-05-27 21:39:00","inspection_id":"87400372","insp_violation_id":"274514626","seq_no":"2","part_no":"392","part_no_section":"2-SLLEWA1","insp_viol_unit":"1","insp_unit_id":"213762448","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"V138169-5","created_at":"2026-04-08T10:13:10.000000Z","updated_at":"2026-06-07T09:41:05.000000Z","normalized_code":"3922SLLEWA1"},{"id":19562639,"change_date":"2026-05-27 21:39:00","inspection_id":"87400372","insp_violation_id":"274514627","seq_no":"3","part_no":"392","part_no_section":"2-SLLEWG3","insp_viol_unit":"1","insp_unit_id":"213762448","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"V138169-5","created_at":"2026-04-08T10:13:10.000000Z","updated_at":"2026-06-07T09:41:05.000000Z","normalized_code":"3922SLLEWG3"},{"id":19562640,"change_date":"2026-05-27 21:39:00","inspection_id":"87400372","insp_violation_id":"274514628","seq_no":"4","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"1","insp_unit_id":"213762448","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-08T10:13:10.000000Z","updated_at":"2026-06-07T09:41:05.000000Z","normalized_code":"39345B2BAIR"},{"id":19562641,"change_date":"2026-05-27 21:39:00","inspection_id":"87400372","insp_violation_id":"274514629","seq_no":"5","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"1","insp_unit_id":"213762448","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-08T10:13:10.000000Z","updated_at":"2026-06-07T09:41:05.000000Z","normalized_code":"39345B2BAIR"},{"id":19562643,"change_date":"2026-05-27 21:39:00","inspection_id":"87400372","insp_violation_id":"274514631","seq_no":"7","part_no":"393","part_no_section":"78A-WS","insp_viol_unit":"1","insp_unit_id":"213762448","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-08T10:13:10.000000Z","updated_at":"2026-06-07T09:41:05.000000Z","normalized_code":"39378AWS"}],"inspection_per_units":[{"id":19833238,"change_date":"2026-05-27 21:39:00","inspection_id":"87400372","insp_unit_id":"213762448","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"202","insp_unit_license":"89017","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1M2AL02C46M002074","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-09T09:42:49.000000Z","updated_at":"2026-06-07T09:01:01.000000Z"}]},{"id":11332716,"change_date":"2026-03-10 21:38:00","inspection_id":"87249910","dot_number":"587195","report_state":"MA","report_number":"EN00000122","insp_date":"2026-03-09 00:00:00","insp_start_time":"1300","insp_end_time":"1308","registration_date":null,"region":"ET","ci_status_code":"C","location":"176H","location_desc":"H-LONGMEADOW","county_code_state":"MA","county_code":"013","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","shipping_paper_number":"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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-03-10 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"77000","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":"541566","transaction_code":"A","transaction_date":"2026-03-10 00:00:00","upload_date":"2026-03-10 00:00:00","upload_first_byte":"0","upload_dot_number":"00587195","upload_search_indicator":"M","census_search_date":"2026-03-10 21:38:00","snet_input_date":"2026-03-09 00:00:00","source_office":"1MAS001","mcmis_add_date":"2026-03-10 21:38:00","insp_carrier_name":"MARION EXCAVATING CO INC","insp_carrier_street":"749 NEW LUDLOW ROAD","insp_carrier_city":"SOUTH HADLEY","insp_carrier_state":"MA","insp_carrier_zip_code":"01075","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-13T09:43:44.000000Z","updated_at":"2026-03-21T09:31:00.000000Z","inspection_violations":[{"id":19077988,"change_date":"2026-03-10 21:38:00","inspection_id":"87249910","insp_violation_id":"272307839","seq_no":"1","part_no":"392","part_no_section":"2-SLLTL","insp_viol_unit":"1","insp_unit_id":"212060667","insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-13T10:04:53.000000Z","updated_at":"2026-03-21T09:48:43.000000Z","normalized_code":"3922SLLTL"}],"inspection_per_units":[{"id":19392056,"change_date":"2026-03-10 21:38:00","inspection_id":"87249910","insp_unit_id":"212060667","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"76824","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1NKDX4EX97J205605","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-13T09:23:22.000000Z","updated_at":"2026-03-21T09:10:51.000000Z"}]},{"id":8472064,"change_date":"2025-04-28 21:35:00","inspection_id":"84500711","dot_number":"587195","report_state":"MA","report_number":"DU00000057","insp_date":"2025-04-28 00:00:00","insp_start_time":"0956","insp_end_time":"1015","registration_date":null,"region":"ET","ci_status_code":"C","location":"205H","location_desc":"H-MILLBURY","county_code_state":"MA","county_code":"027","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"N\/A","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":"2025-04-28 21:35:00","post_acc_ind":"N","gross_comb_veh_wt":"189000","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":"515926","transaction_code":"A","transaction_date":"2025-04-28 00:00:00","upload_date":"2025-04-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00587195","upload_search_indicator":"M","census_search_date":"2025-04-28 21:35:00","snet_input_date":"2025-04-28 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-04-28 21:35:00","insp_carrier_name":"MARION EXCAVATING CO INC","insp_carrier_street":"749 NEW LUDLOW ROAD","insp_carrier_city":"SOUTH HADLEY","insp_carrier_state":"MA","insp_carrier_zip_code":"01075","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-01T10:00:41.000000Z","updated_at":"2025-05-02T10:22:11.000000Z","inspection_violations":[{"id":13395400,"change_date":"2025-04-28 21:35:00","inspection_id":"84500711","insp_violation_id":"265837245","seq_no":"1","part_no":"392","part_no_section":"2-SLLS3","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"380140AD","created_at":"2025-05-01T10:16:11.000000Z","updated_at":"2025-05-02T10:40:48.000000Z","normalized_code":"3922SLLS3"}],"inspection_per_units":[{"id":13766139,"change_date":"2025-04-28 21:35:00","inspection_id":"84500711","insp_unit_id":"206496564","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"212","insp_unit_license":"1AA54W","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1XPFDB0X46N888625","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-01T09:46:03.000000Z","updated_at":"2025-05-02T09:50:13.000000Z"},{"id":13766140,"change_date":"2025-04-28 21:35:00","inspection_id":"84500711","insp_unit_id":"206496565","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MAC","insp_unit_company":"711","insp_unit_license":"5433042","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"5MATA4223EA022729","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-01T09:46:03.000000Z","updated_at":"2025-05-02T09:50:13.000000Z"}]},{"id":8380256,"change_date":"2025-04-15 21:41:00","inspection_id":"84404100","dot_number":"587195","report_state":"MA","report_number":"CW00003707","insp_date":"2025-04-15 00:00:00","insp_start_time":"0545","insp_end_time":"0601","registration_date":null,"region":"ET","ci_status_code":"C","location":"151H","location_desc":"H-HOLYOKE","county_code_state":"MA","county_code":"013","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","shipping_paper_number":"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":"2025-04-15 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"20000","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":"514798","transaction_code":"A","transaction_date":"2025-04-15 00:00:00","upload_date":"2025-04-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00587195","upload_search_indicator":"M","census_search_date":"2025-04-15 21:41:00","snet_input_date":"2025-04-15 00:00:00","source_office":"1MAS001","mcmis_add_date":"2025-04-15 21:41:00","insp_carrier_name":"MARION EXCAVATING CO INC","insp_carrier_street":"749 NEW LUDLOW ROAD","insp_carrier_city":"SOUTH HADLEY","insp_carrier_state":"MA","insp_carrier_zip_code":"01075","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-18T10:26:26.000000Z","updated_at":"2025-04-19T10:16:11.000000Z","inspection_violations":[{"id":13212318,"change_date":"2025-04-15 21:41:00","inspection_id":"84404100","insp_violation_id":"265630556","seq_no":"1","part_no":"392","part_no_section":"2-SLLTL","insp_viol_unit":"1","insp_unit_id":"206320689","insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-18T10:58:01.000000Z","updated_at":"2025-04-18T11:04:46.000000Z","normalized_code":"3922SLLTL"}],"inspection_per_units":[{"id":13602342,"change_date":"2025-04-15 21:41:00","inspection_id":"84404100","insp_unit_id":"206320689","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"R93537","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1FDUF5HT1FEB72346","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-18T10:12:03.000000Z","updated_at":"2025-04-19T09:57:04.000000Z"}]},{"id":7216486,"change_date":"2024-12-05 21:37:00","inspection_id":"83180311","dot_number":"587195","report_state":"MA","report_number":"CL00003998","insp_date":"2024-11-15 00:00:00","insp_start_time":"1307","insp_end_time":"1357","registration_date":"2024-12-05 00:00:00","region":"ET","ci_status_code":"C","location":"348H","location_desc":"H-WARREN","county_code_state":"MA","county_code":"027","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER OWNED","shipping_paper_number":"24N035411","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-11-18 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"194335","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":"503655","transaction_code":"C","transaction_date":"2024-11-18 00:00:00","upload_date":"2024-12-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00587195","upload_search_indicator":"M","census_search_date":"2024-11-18 21:40:00","snet_input_date":"2024-11-15 00:00:00","source_office":"1MAS001","mcmis_add_date":"2024-11-18 21:40:00","insp_carrier_name":"MARION EXCAVATING CO INC","insp_carrier_street":"749 NEW LUDLOW ROAD","insp_carrier_city":"SOUTH HADLEY","insp_carrier_state":"MA","insp_carrier_zip_code":"01075","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:46:29.000000Z","updated_at":"2025-03-17T20:46:29.000000Z","inspection_violations":[{"id":11279507,"change_date":"2024-12-05 21:37:00","inspection_id":"83180311","insp_violation_id":"263249649","seq_no":"1","part_no":"396","part_no_section":"5B-L","insp_viol_unit":"1","insp_unit_id":"204197818","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"008351AD","created_at":"2025-03-17T22:00:44.000000Z","updated_at":"2025-03-17T22:00:44.000000Z","normalized_code":"3965BL"},{"id":11279508,"change_date":"2024-12-05 21:37:00","inspection_id":"83180311","insp_violation_id":"263249650","seq_no":"2","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"204197819","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"008351AD","created_at":"2025-03-17T22:00:44.000000Z","updated_at":"2025-03-17T22:00:44.000000Z","normalized_code":"39617CPI"}],"inspection_per_units":[{"id":11640285,"change_date":"2024-12-05 21:37:00","inspection_id":"83180311","insp_unit_id":"204197818","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"26","insp_unit_license":"71523","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1XKWDB0X97J166257","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:43:39.000000Z","updated_at":"2025-03-17T23:43:39.000000Z"},{"id":11640286,"change_date":"2024-12-05 21:37:00","inspection_id":"83180311","insp_unit_id":"204197819","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"XL","insp_unit_company":null,"insp_unit_license":"5128950","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"4U3J05331NL020941","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:43:39.000000Z","updated_at":"2025-03-17T23:43:39.000000Z"}]},{"id":7165869,"change_date":"2024-11-14 21:40:00","inspection_id":"83126672","dot_number":"587195","report_state":"CT","report_number":"3017001727","insp_date":"2024-11-11 00:00:00","insp_start_time":"0840","insp_end_time":"0911","registration_date":"2024-11-14 00:00:00","region":"ET","ci_status_code":"C","location":"064","location_desc":"HARTFORD","county_code_state":"CT","county_code":"003","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SELF","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-11-12 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"64000","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":"723122","transaction_code":"C","transaction_date":"2024-11-11 00:00:00","upload_date":"2024-11-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00587195","upload_search_indicator":null,"census_search_date":"2024-11-12 21:40:00","snet_input_date":"2024-11-11 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-11-12 21:40:00","insp_carrier_name":"MARION EXCAVATING CO INC","insp_carrier_street":"749 NEW LUDLOW ROAD","insp_carrier_city":"SOUTH HADLEY","insp_carrier_state":"MA","insp_carrier_zip_code":"01075","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:45:33.000000Z","updated_at":"2025-03-17T20:45:33.000000Z","inspection_violations":[{"id":11195813,"change_date":"2024-11-14 21:40:00","inspection_id":"83126672","insp_violation_id":"262882594","seq_no":"1","part_no":"392","part_no_section":"2-SLLS4","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"V130805-5","created_at":"2025-03-17T22:00:18.000000Z","updated_at":"2025-03-17T22:00:18.000000Z","normalized_code":"3922SLLS4"}],"inspection_per_units":[{"id":11558300,"change_date":"2024-11-14 21:40:00","inspection_id":"83126672","insp_unit_id":"203868609","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"202","insp_unit_license":"89017","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1M2AL02C46M002074","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:42:46.000000Z","updated_at":"2025-03-17T23:42:46.000000Z"}]},{"id":6535237,"change_date":"2024-08-22 21:42:00","inspection_id":"82456103","dot_number":"587195","report_state":"MA","report_number":"DR00001036","insp_date":"2024-08-21 00:00:00","insp_start_time":"1556","insp_end_time":"1605","registration_date":null,"region":"ET","ci_status_code":"C","location":"311H","location_desc":"H-SPRINGFIELD","county_code_state":"MA","county_code":"013","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"NA","shipping_paper_number":"NA","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-08-22 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"14000","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":"498043","transaction_code":"A","transaction_date":"2024-08-22 00:00:00","upload_date":"2024-08-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00587195","upload_search_indicator":"M","census_search_date":"2024-08-22 21:42:00","snet_input_date":"2024-08-21 00:00:00","source_office":"1MAS001","mcmis_add_date":"2024-08-22 21:42:00","insp_carrier_name":"MARION EXCAVATING CO INC","insp_carrier_street":"749 NEW LUDLOW ROAD","insp_carrier_city":"SOUTH HADLEY","insp_carrier_state":"MA","insp_carrier_zip_code":"01075","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:32:23.000000Z","updated_at":"2025-03-17T20:32:23.000000Z","inspection_violations":[{"id":10153485,"change_date":"2024-08-22 21:42:00","inspection_id":"82456103","insp_violation_id":"261343041","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:07.000000Z","updated_at":"2025-03-17T21:55:07.000000Z","normalized_code":"3922"},{"id":10153486,"change_date":"2024-08-22 21:42:00","inspection_id":"82456103","insp_violation_id":"261343042","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:55:07.000000Z","updated_at":"2025-03-17T21:55:07.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10535383,"change_date":"2024-08-22 21:42:00","inspection_id":"82456103","insp_unit_id":"202527855","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":null,"insp_unit_license":"T85274","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1GD322C84DF208756","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:32:08.000000Z","updated_at":"2025-03-17T23:32:08.000000Z"}]},{"id":5475729,"change_date":"2024-04-15 21:40:00","inspection_id":"81312416","dot_number":"587195","report_state":"CT","report_number":"3010003385","insp_date":"2024-04-10 00:00:00","insp_start_time":"0728","insp_end_time":"0803","registration_date":"2024-04-15 00:00:00","region":"ET","ci_status_code":"C","location":"164","location_desc":"WINDSOR","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":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-04-10 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"194335","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":"704583","transaction_code":"C","transaction_date":"2024-04-10 00:00:00","upload_date":"2024-04-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00587195","upload_search_indicator":null,"census_search_date":"2024-04-10 21:41:00","snet_input_date":"2024-04-10 00:00:00","source_office":"1CTS001","mcmis_add_date":"2024-04-10 21:41:00","insp_carrier_name":"MARION EXCAVATING CO INC","insp_carrier_street":"749 NEW LUDLOW ROAD","insp_carrier_city":"SOUTH HADLEY","insp_carrier_state":"MA","insp_carrier_zip_code":"01075","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:11:12.000000Z","updated_at":"2025-03-17T20:11:12.000000Z","inspection_violations":[{"id":8455452,"change_date":"2024-04-15 21:40:00","inspection_id":"81312416","insp_violation_id":"258917450","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"200385007","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"V127191-3","created_at":"2025-03-17T21:46:56.000000Z","updated_at":"2025-03-17T21:46:56.000000Z","normalized_code":"3922"},{"id":8455453,"change_date":"2024-04-15 21:40:00","inspection_id":"81312416","insp_violation_id":"258917451","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"200385008","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:56.000000Z","updated_at":"2025-03-17T21:46:56.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":8820324,"change_date":"2024-04-15 21:40:00","inspection_id":"81312416","insp_unit_id":"200385007","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"26","insp_unit_license":"71523","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1XKWDB0X97J166257","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:15:03.000000Z","updated_at":"2025-03-17T23:15:03.000000Z"},{"id":8820325,"change_date":"2024-04-15 21:40:00","inspection_id":"81312416","insp_unit_id":"200385008","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"XL","insp_unit_company":null,"insp_unit_license":"5128950","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"4U3J05331NL020941","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:15:03.000000Z","updated_at":"2025-03-17T23:15:03.000000Z"}]},{"id":4368586,"change_date":"2023-11-13 21:40:00","inspection_id":"80100783","dot_number":"587195","report_state":"CT","report_number":"3098002314","insp_date":"2023-11-07 00:00:00","insp_start_time":"0923","insp_end_time":"1000","registration_date":"2023-11-10 00:00:00","region":"ET","ci_status_code":"C","location":"011","location_desc":"BLOOMFIELD","county_code_state":"CT","county_code":"003","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"MARION EXCAVATING","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-11-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"22480","viol_total":"6","oos_total":"2","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"690923","transaction_code":"C","transaction_date":"2023-11-07 00:00:00","upload_date":"2023-11-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00587195","upload_search_indicator":null,"census_search_date":"2023-11-07 21:40:00","snet_input_date":"2023-11-07 00:00:00","source_office":"1CTS001","mcmis_add_date":"2023-11-07 21:40:00","insp_carrier_name":"MARION EXCAVATING CO INC","insp_carrier_street":"749 NEW LUDLOW ROAD","insp_carrier_city":"SOUTH HADLEY","insp_carrier_state":"MA","insp_carrier_zip_code":"01075","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:49:31.000000Z","updated_at":"2025-03-17T19:49:31.000000Z","inspection_violations":[{"id":6758771,"change_date":"2023-11-13 21:40:00","inspection_id":"80100783","insp_violation_id":"256335955","seq_no":"1","part_no":"392","part_no_section":"8","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:38:30.000000Z","updated_at":"2025-03-17T21:38:30.000000Z","normalized_code":"3928"},{"id":6758772,"change_date":"2023-11-13 21:40:00","inspection_id":"80100783","insp_violation_id":"256335956","seq_no":"2","part_no":"393","part_no_section":"43","insp_viol_unit":"2","insp_unit_id":"198006533","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"Y999790-6","created_at":"2025-03-17T21:38:30.000000Z","updated_at":"2025-03-17T21:38:30.000000Z","normalized_code":"39343"},{"id":6758773,"change_date":"2023-11-13 21:40:00","inspection_id":"80100783","insp_violation_id":"256335957","seq_no":"3","part_no":"393","part_no_section":"110(b)","insp_viol_unit":"2","insp_unit_id":"198006533","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:38:30.000000Z","updated_at":"2025-03-17T21:38:30.000000Z","normalized_code":"393110B"},{"id":6758774,"change_date":"2023-11-13 21:40:00","inspection_id":"80100783","insp_violation_id":"256335958","seq_no":"4","part_no":"393","part_no_section":"104(b)","insp_viol_unit":"2","insp_unit_id":"198006533","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:30.000000Z","updated_at":"2025-03-17T21:38:30.000000Z","normalized_code":"393104B"},{"id":6758775,"change_date":"2023-11-13 21:40:00","inspection_id":"80100783","insp_violation_id":"256335959","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"198006533","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:30.000000Z","updated_at":"2025-03-17T21:38:30.000000Z","normalized_code":"3939A"},{"id":6758776,"change_date":"2023-11-13 21:40:00","inspection_id":"80100783","insp_violation_id":"256335960","seq_no":"6","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"198006533","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:30.000000Z","updated_at":"2025-03-17T21:38:30.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7026055,"change_date":"2023-11-13 21:40:00","inspection_id":"80100783","insp_unit_id":"198006532","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"121","insp_unit_license":"S92581","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1GC0KYEG9GZ234853","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:59.000000Z","updated_at":"2025-03-17T22:58:59.000000Z"},{"id":7026056,"change_date":"2023-11-13 21:40:00","inspection_id":"80100783","insp_unit_id":"198006533","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"ST","insp_unit_company":"78","insp_unit_license":"2371039","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1TKU0162XVM018403","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:59.000000Z","updated_at":"2025-03-17T22:58:59.000000Z"}]},{"id":3474750,"change_date":"2023-07-11 21:41:00","inspection_id":"79105870","dot_number":"587195","report_state":"MA","report_number":"CE00006412","insp_date":"2023-07-11 00:00:00","insp_start_time":"0536","insp_end_time":"0552","registration_date":null,"region":"ET","ci_status_code":"C","location":"064S","location_desc":"S-CHARLTON","county_code_state":"MA","county_code":"027","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-07-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"99000","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":"469748","transaction_code":"A","transaction_date":"2023-07-11 00:00:00","upload_date":"2023-07-11 00:00:00","upload_first_byte":"0","upload_dot_number":"00587195","upload_search_indicator":"M","census_search_date":"2023-07-11 21:41:00","snet_input_date":"2023-07-11 00:00:00","source_office":"1MAS001","mcmis_add_date":"2023-07-11 21:41:00","insp_carrier_name":"MARION EXCAVATING CO INC","insp_carrier_street":"749 NEW LUDLOW ROAD","insp_carrier_city":"SOUTH HADLEY","insp_carrier_state":"MA","insp_carrier_zip_code":"01075","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:31:43.000000Z","updated_at":"2025-03-17T19:31:43.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5587421,"change_date":"2023-07-11 21:41:00","inspection_id":"79105870","insp_unit_id":"195923587","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"1AA54W","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1XPFDB0X46N888625","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:06.000000Z","updated_at":"2025-03-17T22:47:06.000000Z"},{"id":5587422,"change_date":"2023-07-11 21:41:00","inspection_id":"79105870","insp_unit_id":"195923588","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCKT","insp_unit_company":null,"insp_unit_license":"5155414","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"5MADS2626HC040506","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:06.000000Z","updated_at":"2025-03-17T22:47:06.000000Z"}]},{"id":3090710,"change_date":"2023-05-19 21:42:00","inspection_id":"78672910","dot_number":"587195","report_state":"MA","report_number":"CW00001694","insp_date":"2023-05-18 00:00:00","insp_start_time":"1600","insp_end_time":"1630","registration_date":null,"region":"ET","ci_status_code":"C","location":"086H","location_desc":"H-DEERFIELD","county_code_state":"MA","county_code":"011","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"Y","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-05-19 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"14000","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":"466155","transaction_code":"A","transaction_date":"2023-05-19 00:00:00","upload_date":"2023-05-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00587195","upload_search_indicator":"M","census_search_date":"2023-05-19 21:42:00","snet_input_date":"2023-05-18 00:00:00","source_office":"1MAS001","mcmis_add_date":"2023-05-19 21:42:00","insp_carrier_name":"MARION EXCAVATING CO INC","insp_carrier_street":"749 NEW LUDLOW ROAD","insp_carrier_city":"SOUTH HADLEY","insp_carrier_state":"MA","insp_carrier_zip_code":"01075","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:24:11.000000Z","updated_at":"2025-03-17T19:24:11.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4971578,"change_date":"2023-05-19 21:42:00","inspection_id":"78672910","insp_unit_id":"195031007","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":null,"insp_unit_license":"T85274","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"1GD322C84DF208756","insp_unit_decal":"Y","insp_unit_decal_number":"32774652","created_at":"2025-03-17T22:42:12.000000Z","updated_at":"2025-03-17T22:42:12.000000Z"}]},{"id":1091582,"change_date":"2022-08-22 21:41:00","inspection_id":"76384634","dot_number":"587195","report_state":"CT","report_number":"3019003873","insp_date":"2022-08-22 00:00:00","insp_start_time":"0653","insp_end_time":"0707","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":"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-22 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"652240","transaction_code":"A","transaction_date":"2022-08-22 00:00:00","upload_date":"2022-08-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00587195","upload_search_indicator":null,"census_search_date":"2022-08-22 21:41:00","snet_input_date":"2022-08-22 00:00:00","source_office":"1CTS001","mcmis_add_date":"2022-08-22 21:41:00","insp_carrier_name":"MARION EXCAVATING CO INC","insp_carrier_street":"749 NEW LUDLOW ROAD","insp_carrier_city":"SOUTH HADLEY","insp_carrier_state":"MA","insp_carrier_zip_code":"01075","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:46:55.000000Z","updated_at":"2025-03-17T18:46:55.000000Z","inspection_violations":[{"id":1719193,"change_date":"2022-08-22 21:41:00","inspection_id":"76384634","insp_violation_id":"247864904","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:14:59.000000Z","updated_at":"2025-03-17T21:14:59.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":1755834,"change_date":"2022-08-22 21:41:00","inspection_id":"76384634","insp_unit_id":"190438699","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"WSTR","insp_unit_company":null,"insp_unit_license":"92769","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"5KKHAVDVXFLGH8309","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:05.000000Z","updated_at":"2025-03-17T22:19:05.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/587195\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/587195\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/587195\/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\/587195\/inspections","per_page":100,"prev_page_url":null,"to":13,"total":13}