{"current_page":1,"data":[{"id":11765573,"change_date":"2026-04-28 21:38:00","inspection_id":"87696073","dot_number":"378821","report_state":"NY","report_number":"SPD3021774","insp_date":"2026-04-21 00:00:00","insp_start_time":"0954","insp_end_time":"1000","registration_date":null,"region":"ED","ci_status_code":"C","location":"30445N","location_desc":"TULLY NY","county_code_state":"NY","county_code":"067","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"BEAM MACK SALES & SERVICE INC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-04-28 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"32995","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":"3222537","transaction_code":"A","transaction_date":"2026-04-27 00:00:00","upload_date":"2026-04-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00378821","upload_search_indicator":null,"census_search_date":"2026-04-28 21:38:00","snet_input_date":"2026-04-21 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-04-28 21:38:00","insp_carrier_name":"BEAM MACK SALES & SERVICE INC","insp_carrier_street":"2674 W HENRIETTA RD","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-01T09:40:20.000000Z","updated_at":"2026-05-09T09:30:24.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20469374,"change_date":"2026-04-28 21:38:00","inspection_id":"87696073","insp_unit_id":"213258536","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"5392","insp_unit_license":"94629NA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1M2MDBAB4MS070107","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-01T09:20:12.000000Z","updated_at":"2026-05-09T09:02:33.000000Z"}]},{"id":11513610,"change_date":"2026-03-30 21:38:00","inspection_id":"87434335","dot_number":"378821","report_state":"NY","report_number":"5L50000155","insp_date":"2026-03-26 00:00:00","insp_start_time":"1030","insp_end_time":"1205","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"MOUNT MORRIS NY","county_code_state":"NY","county_code":"051","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-03-30 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"32995","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3087580","transaction_code":"A","transaction_date":"2026-03-30 00:00:00","upload_date":"2026-03-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00378821","upload_search_indicator":null,"census_search_date":"2026-03-30 21:38:00","snet_input_date":"2026-03-26 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-03-30 21:38:00","insp_carrier_name":"BEAM MACK SALES & SERVICE INC","insp_carrier_street":"2674 W HENRIETTA RD","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623-2328","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-02T09:46:42.000000Z","updated_at":"2026-04-10T09:30:17.000000Z","inspection_violations":[{"id":19445155,"change_date":"2026-03-30 21:38:00","inspection_id":"87434335","insp_violation_id":"272728038","seq_no":"1","part_no":"392","part_no_section":"9BA-INACTIVE","insp_viol_unit":"1","insp_unit_id":"212416430","insp_violation_category_id":"51","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-04-02T10:09:58.000000Z","updated_at":"2026-04-09T09:49:47.000000Z","normalized_code":"3929BAINACTIVE"}],"inspection_per_units":[{"id":19724498,"change_date":"2026-03-30 21:38:00","inspection_id":"87434335","insp_unit_id":"212416430","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"5392","insp_unit_license":"94629NA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1M2MDBAB4MS070107","insp_unit_decal":"Y","insp_unit_decal_number":"NONE","created_at":"2026-04-02T09:29:35.000000Z","updated_at":"2026-04-10T09:04:30.000000Z"}]},{"id":11637479,"change_date":"2026-04-14 21:38:00","inspection_id":"87337660","dot_number":"378821","report_state":"NY","report_number":"SPE3110051","insp_date":"2026-03-13 00:00:00","insp_start_time":"1103","insp_end_time":"1140","registration_date":"2026-04-13 00:00:00","region":"ED","ci_status_code":"C","location":null,"location_desc":"HORSEHEADS NY","county_code_state":"NY","county_code":"015","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-03-20 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"16000","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":"3027690","transaction_code":"C","transaction_date":"2026-03-19 00:00:00","upload_date":"2026-04-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00378821","upload_search_indicator":null,"census_search_date":"2026-03-20 21:38:00","snet_input_date":"2026-03-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-03-20 21:38:00","insp_carrier_name":"BEAM MACK SALES & SERVICE INC","insp_carrier_street":"2674 W HENRIETTA RD","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623-2328","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-25T09:30:26.000000Z","updated_at":"2026-04-25T09:30:26.000000Z","inspection_violations":[{"id":20207955,"change_date":"2026-04-14 21:38:00","inspection_id":"87337660","insp_violation_id":"273579275","seq_no":"1","part_no":"392","part_no_section":"9BA-INACTIVEINTRA","insp_viol_unit":"1","insp_unit_id":"212997368","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-25T09:40:34.000000Z","updated_at":"2026-04-25T09:40:34.000000Z","normalized_code":"3929BAINACTIVEINTRA"},{"id":20207956,"change_date":"2026-04-14 21:38:00","inspection_id":"87337660","insp_violation_id":"273579276","seq_no":"2","part_no":"392","part_no_section":"2-SLLUCR","insp_viol_unit":"1","insp_unit_id":"212997368","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-25T09:40:34.000000Z","updated_at":"2026-04-25T09:40:34.000000Z","normalized_code":"3922SLLUCR"},{"id":20207957,"change_date":"2026-04-14 21:38:00","inspection_id":"87337660","insp_violation_id":"273579277","seq_no":"3","part_no":"392","part_no_section":"2-SLLEQP","insp_viol_unit":"1","insp_unit_id":"212997368","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-25T09:40:34.000000Z","updated_at":"2026-04-25T09:40:34.000000Z","normalized_code":"3922SLLEQP"}],"inspection_per_units":[{"id":20241993,"change_date":"2026-04-14 21:38:00","inspection_id":"87337660","insp_unit_id":"212997368","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISUZU","insp_unit_company":"7508","insp_unit_license":"71926NC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"JALC4W162H7K00175","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-25T09:02:50.000000Z","updated_at":"2026-04-25T09:02:50.000000Z"}]},{"id":11188013,"change_date":"2026-02-20 21:38:00","inspection_id":"87098177","dot_number":"378821","report_state":"NY","report_number":"SPE3110022","insp_date":"2026-02-19 00:00:00","insp_start_time":"0935","insp_end_time":"0950","registration_date":null,"region":"ES","ci_status_code":"C","location":"60056M","location_desc":"BATH NY","county_code_state":"NY","county_code":"101","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"CONWAY BEAM TRUCK GROUP","shipping_paper_number":"38538H","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-02-20 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"32995","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":"2912021","transaction_code":"A","transaction_date":"2026-02-20 00:00:00","upload_date":"2026-02-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00378821","upload_search_indicator":null,"census_search_date":"2026-02-20 21:38:00","snet_input_date":"2026-02-19 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-02-20 21:38:00","insp_carrier_name":"BEAM MACK SALES & SERVICE INC","insp_carrier_street":"2674 W HENRIETTA RD","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623-2328","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-23T10:37:51.000000Z","updated_at":"2026-03-03T10:30:40.000000Z","inspection_violations":[{"id":18756231,"change_date":"2026-02-20 21:38:00","inspection_id":"87098177","insp_violation_id":"271918930","seq_no":"1","part_no":"392","part_no_section":"2-SLLUCR","insp_viol_unit":"1","insp_unit_id":"211730992","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-23T10:53:15.000000Z","updated_at":"2026-03-03T10:40:33.000000Z","normalized_code":"3922SLLUCR"}],"inspection_per_units":[{"id":19103935,"change_date":"2026-02-20 21:38:00","inspection_id":"87098177","insp_unit_id":"211730992","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"5932","insp_unit_license":"94629NA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1M2MDBAB4MS070107","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-23T10:13:26.000000Z","updated_at":"2026-03-03T10:03:05.000000Z"}]},{"id":10073748,"change_date":"2025-10-30 21:41:00","inspection_id":"86187637","dot_number":"378821","report_state":"NY","report_number":"SPE4080083","insp_date":"2025-10-23 00:00:00","insp_start_time":"1101","insp_end_time":"1118","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"BATH NY","county_code_state":"NY","county_code":"101","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CONWAY TRUCK GROUP","shipping_paper_number":"116169","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-10-30 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"2","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":"2476462","transaction_code":"A","transaction_date":"2025-10-29 00:00:00","upload_date":"2025-10-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00378821","upload_search_indicator":null,"census_search_date":"2025-10-30 21:41:00","snet_input_date":"2025-10-23 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-10-30 21:41:00","insp_carrier_name":"BEAM MACK SALES & SERVICE INC","insp_carrier_street":"2674 W HENRIETTA RD","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623-2328","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-02T11:01:52.000000Z","updated_at":"2025-11-03T11:00:12.000000Z","inspection_violations":[{"id":16682635,"change_date":"2025-10-30 21:41:00","inspection_id":"86187637","insp_violation_id":"269608973","seq_no":"2","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":"NY2501049643","created_at":"2025-11-02T11:17:41.000000Z","updated_at":"2025-11-03T11:15:20.000000Z","normalized_code":"3922SLLTCD"},{"id":16682636,"change_date":"2025-10-30 21:41:00","inspection_id":"86187637","insp_violation_id":"269608974","seq_no":"1","part_no":"392","part_no_section":"2-SLLIFTA","insp_viol_unit":"1","insp_unit_id":"209732032","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"NY2501049643","created_at":"2025-11-02T11:17:41.000000Z","updated_at":"2025-11-03T11:15:20.000000Z","normalized_code":"3922SLLIFTA"}],"inspection_per_units":[{"id":16744321,"change_date":"2025-10-30 21:41:00","inspection_id":"86187637","insp_unit_id":"209732032","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"94663NA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FDUF5HT4FED10526","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-02T10:47:18.000000Z","updated_at":"2025-11-03T10:45:18.000000Z"}]},{"id":9992622,"change_date":"2025-10-21 21:38:00","inspection_id":"86102353","dot_number":"378821","report_state":"NY","report_number":"SPC3040638","insp_date":"2025-10-14 00:00:00","insp_start_time":"1204","insp_end_time":"1219","registration_date":null,"region":"ED","ci_status_code":"C","location":"70877N","location_desc":"WATERTOWN NY","county_code_state":"NY","county_code":"045","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"CONWAY BEAM MACK","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-10-21 21:38: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":"2436526","transaction_code":"A","transaction_date":"2025-10-20 00:00:00","upload_date":"2025-10-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00378821","upload_search_indicator":null,"census_search_date":"2025-10-21 21:38:00","snet_input_date":"2025-10-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-10-21 21:38:00","insp_carrier_name":"BEAM MACK SALES & SERVICE INC","insp_carrier_street":"2674 W HENRIETTA RD","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623-2328","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-24T10:01:40.000000Z","updated_at":"2025-10-25T10:00:06.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16593753,"change_date":"2025-10-21 21:38:00","inspection_id":"86102353","insp_unit_id":"209568972","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"5392","insp_unit_license":"94629NA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1M2MDBAB4MS070107","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-24T09:46:59.000000Z","updated_at":"2025-10-25T09:45:07.000000Z"}]},{"id":9944730,"change_date":"2025-10-16 21:39:00","inspection_id":"86051981","dot_number":"378821","report_state":"NY","report_number":"SPD3011272","insp_date":"2025-10-08 00:00:00","insp_start_time":"1128","insp_end_time":"1143","registration_date":"2025-10-14 00:00:00","region":"ED","ci_status_code":"C","location":"30445S","location_desc":"TULLY NY","county_code_state":"NY","county_code":"067","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"BEAM MACK SALES & SERVICE INC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-10-15 21:38: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":"2412877","transaction_code":"C","transaction_date":"2025-10-14 00:00:00","upload_date":"2025-10-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00378821","upload_search_indicator":null,"census_search_date":"2025-10-15 21:38:00","snet_input_date":"2025-10-08 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-10-15 21:38:00","insp_carrier_name":"BEAM MACK SALES & SERVICE INC","insp_carrier_street":"2674 W HENRIETTA RD","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623-2328","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-18T10:01:39.000000Z","updated_at":"2025-10-20T10:00:06.000000Z","inspection_violations":[{"id":16436827,"change_date":"2025-10-16 21:39:00","inspection_id":"86051981","insp_violation_id":"269328391","seq_no":"1","part_no":"392","part_no_section":"2-SLLIFTA","insp_viol_unit":"1","insp_unit_id":"209494185","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-19T10:17:22.000000Z","updated_at":"2025-10-20T10:15:13.000000Z","normalized_code":"3922SLLIFTA"}],"inspection_per_units":[{"id":16525429,"change_date":"2025-10-16 21:39:00","inspection_id":"86051981","insp_unit_id":"209494185","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"67644NF","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"JHHSDM2H2KK008676","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-19T09:46:41.000000Z","updated_at":"2025-10-20T09:45:10.000000Z"}]},{"id":9803269,"change_date":"2025-09-29 21:38:00","inspection_id":"85902827","dot_number":"378821","report_state":"NY","report_number":"D305400929","insp_date":"2025-09-23 00:00:00","insp_start_time":"1230","insp_end_time":"1245","registration_date":null,"region":"ED","ci_status_code":"C","location":"70877S","location_desc":"WATERTOWN NY","county_code_state":"NY","county_code":"045","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-09-29 21:38: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":"2340586","transaction_code":"A","transaction_date":"2025-09-29 00:00:00","upload_date":"2025-09-29 00:00:00","upload_first_byte":"0","upload_dot_number":"00378821","upload_search_indicator":null,"census_search_date":"2025-09-29 21:38:00","snet_input_date":"2025-09-23 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-09-29 21:38:00","insp_carrier_name":"BEAM MACK SALES & SERVICE INC","insp_carrier_street":"2674 W HENRIETTA RD","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623-2328","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-02T10:00:15.000000Z","updated_at":"2025-10-03T10:00:21.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16246922,"change_date":"2025-09-29 21:38:00","inspection_id":"85902827","insp_unit_id":"209193095","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"5392","insp_unit_license":"94629NA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1M2MDBAB4MS070107","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-02T09:45:17.000000Z","updated_at":"2025-10-03T09:45:27.000000Z"}]},{"id":9313669,"change_date":"2025-08-02 21:33:00","inspection_id":"85388712","dot_number":"378821","report_state":"NY","report_number":"D507005847","insp_date":"2025-07-31 00:00:00","insp_start_time":"0944","insp_end_time":"1000","registration_date":null,"region":"ED","ci_status_code":"C","location":"40354N","location_desc":"GROVELAND NY","county_code_state":"NY","county_code":"051","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-08-02 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"32995","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":"2076746","transaction_code":"A","transaction_date":"2025-08-02 00:00:00","upload_date":"2025-08-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00378821","upload_search_indicator":null,"census_search_date":"2025-08-02 21:33:00","snet_input_date":"2025-07-31 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-08-02 21:33:00","insp_carrier_name":"BEAM MACK SALES & SERVICE INC","insp_carrier_street":"2674 W HENRIETTA RD","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623-2328","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-06T10:43:39.000000Z","updated_at":"2025-08-06T10:43:39.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15337213,"change_date":"2025-08-02 21:33:00","inspection_id":"85388712","insp_unit_id":"208207933","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"5392","insp_unit_license":"94629NA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1M2MDBAB4MS070107","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-05T09:46:11.000000Z","updated_at":"2025-08-06T09:45:17.000000Z"}]},{"id":9213034,"change_date":"2025-11-03 21:38:00","inspection_id":"85282816","dot_number":"378821","report_state":"NY","report_number":"SPC3050772","insp_date":"2025-07-15 00:00:00","insp_start_time":"1020","insp_end_time":"1040","registration_date":"2025-10-31 00:00:00","region":"ED","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":"CONWAY BEAM TRUCK GROUP","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-07-22 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"32995","viol_total":"2","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":"2023117","transaction_code":"C","transaction_date":"2025-07-21 00:00:00","upload_date":"2025-11-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00378821","upload_search_indicator":null,"census_search_date":"2025-07-22 21:41:00","snet_input_date":"2025-07-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-07-22 21:41:00","insp_carrier_name":"BEAM MACK SALES & SERVICE INC","insp_carrier_street":"2674 W HENRIETTA RD","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623-2328","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-25T10:45:47.000000Z","updated_at":"2025-11-07T10:30:03.000000Z","inspection_violations":[{"id":16734483,"change_date":"2025-11-03 21:38:00","inspection_id":"85282816","insp_violation_id":"269681114","seq_no":"1","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"209796323","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-07T10:30:33.000000Z","updated_at":"2025-11-07T10:30:33.000000Z","normalized_code":"3939ALIL"},{"id":16734484,"change_date":"2025-11-03 21:38:00","inspection_id":"85282816","insp_violation_id":"269681115","seq_no":"2","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"209796323","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-07T10:30:33.000000Z","updated_at":"2025-11-07T10:30:33.000000Z","normalized_code":"3939ALIL"}],"inspection_per_units":[{"id":16795177,"change_date":"2025-11-03 21:38:00","inspection_id":"85282816","insp_unit_id":"209796323","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"5392","insp_unit_license":"94629NA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1M2MDBAB4MS070107","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-06T10:00:27.000000Z","updated_at":"2025-11-07T10:00:06.000000Z"}]},{"id":8824325,"change_date":"2025-06-05 21:41:00","inspection_id":"84872466","dot_number":"378821","report_state":"NY","report_number":"D507005749","insp_date":"2025-06-04 00:00:00","insp_start_time":"1013","insp_end_time":"1030","registration_date":null,"region":"ED","ci_status_code":"C","location":"40354N","location_desc":"GROVELAND NY","county_code_state":"NY","county_code":"051","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-06-05 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"32995","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":"1825936","transaction_code":"A","transaction_date":"2025-06-05 00:00:00","upload_date":"2025-06-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00378821","upload_search_indicator":null,"census_search_date":"2025-06-05 21:41:00","snet_input_date":"2025-06-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-06-05 21:41:00","insp_carrier_name":"BEAM MACK SALES & SERVICE INC","insp_carrier_street":"2674 W HENRIETTA RD","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623-2328","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-09T10:01:03.000000Z","updated_at":"2025-06-09T10:01:03.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14447187,"change_date":"2025-06-05 21:41:00","inspection_id":"84872466","insp_unit_id":"207240230","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"5392","insp_unit_license":"94629NA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1M2MDBAB4MS070107","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-08T09:46:24.000000Z","updated_at":"2025-06-09T09:45:34.000000Z"}]},{"id":8402059,"change_date":"2025-04-17 21:41:00","inspection_id":"84427038","dot_number":"378821","report_state":"NY","report_number":"D507101478","insp_date":"2025-04-17 00:00:00","insp_start_time":"0929","insp_end_time":"0956","registration_date":null,"region":"ED","ci_status_code":"C","location":"40354N","location_desc":"GROVELAND NY","county_code_state":"NY","county_code":"051","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-04-17 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"32995","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":"1609497","transaction_code":"A","transaction_date":"2025-04-17 00:00:00","upload_date":"2025-04-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00378821","upload_search_indicator":null,"census_search_date":"2025-04-17 21:41:00","snet_input_date":"2025-04-17 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-04-17 21:41:00","insp_carrier_name":"BEAM MACK SALES & SERVICE INC","insp_carrier_street":"2674 W HENRIETTA RD","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623-2328","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-20T10:27:57.000000Z","updated_at":"2025-04-21T10:22:24.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13639371,"change_date":"2025-04-17 21:41:00","inspection_id":"84427038","insp_unit_id":"206361964","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"5392","insp_unit_license":"94629NA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1M2MDBAB4MS070107","insp_unit_decal":"Y","insp_unit_decal_number":"35218273","created_at":"2025-04-20T10:11:37.000000Z","updated_at":"2025-04-21T09:57:05.000000Z"}]},{"id":8309013,"change_date":"2025-04-07 21:40:00","inspection_id":"84329057","dot_number":"378821","report_state":"NY","report_number":"D507801376","insp_date":"2025-04-03 00:00:00","insp_start_time":"0935","insp_end_time":"1004","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"MOUNT MORRIS NY","county_code_state":"NY","county_code":"051","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-04-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"32995","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":"1564295","transaction_code":"A","transaction_date":"2025-04-07 00:00:00","upload_date":"2025-04-07 00:00:00","upload_first_byte":"0","upload_dot_number":"00378821","upload_search_indicator":null,"census_search_date":"2025-04-07 21:40:00","snet_input_date":"2025-04-03 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-04-07 21:40:00","insp_carrier_name":"BEAM MACK SALES & SERVICE INC","insp_carrier_street":"2674 W HENRIETTA RD","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623-2328","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-11T10:11:09.000000Z","updated_at":"2025-04-11T10:11:09.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13474623,"change_date":"2025-04-07 21:40:00","inspection_id":"84329057","insp_unit_id":"206182248","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"5392","insp_unit_license":"94629NA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1M2MDBAB4MS070107","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-10T09:53:08.000000Z","updated_at":"2025-04-11T09:55:33.000000Z"}]},{"id":8191815,"change_date":"2025-03-24 21:40:00","inspection_id":"84205678","dot_number":"378821","report_state":"NY","report_number":"D306001142","insp_date":"2025-03-20 00:00:00","insp_start_time":"0847","insp_end_time":"0919","registration_date":null,"region":"ED","ci_status_code":"C","location":"60056M","location_desc":"BATH NY","county_code_state":"NY","county_code":"101","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"CONWAY BEAM TRUCK GROUP","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-03-24 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25995","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":"1508733","transaction_code":"A","transaction_date":"2025-03-24 00:00:00","upload_date":"2025-03-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00378821","upload_search_indicator":null,"census_search_date":"2025-03-24 21:40:00","snet_input_date":"2025-03-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-03-24 21:40:00","insp_carrier_name":"BEAM MACK SALES & SERVICE INC","insp_carrier_street":"2674 W HENRIETTA RD","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623-2328","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-27T10:01:24.000000Z","updated_at":"2025-03-28T10:13:26.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13244139,"change_date":"2025-03-24 21:40:00","inspection_id":"84205678","insp_unit_id":"205952609","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"4631","insp_unit_license":"96039NB","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1M2MDBAA9NS001891","insp_unit_decal":"Y","insp_unit_decal_number":"34944262","created_at":"2025-03-28T09:54:18.000000Z","updated_at":"2025-03-28T10:00:57.000000Z"}]},{"id":7552378,"change_date":"2025-01-06 21:38:00","inspection_id":"83533747","dot_number":"378821","report_state":"NY","report_number":"SPD3070279","insp_date":"2024-12-30 00:00:00","insp_start_time":"1328","insp_end_time":"1344","registration_date":null,"region":"ES","ci_status_code":"C","location":"30382S","location_desc":"HASTINGS NY","county_code_state":"NY","county_code":"075","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"BEAM MACK SALES & SERVICE INC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-01-06 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"32995","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":"1219112","transaction_code":"A","transaction_date":"2025-01-06 00:00:00","upload_date":"2025-01-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00378821","upload_search_indicator":null,"census_search_date":"2025-01-06 21:38:00","snet_input_date":"2024-12-30 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-01-06 21:38:00","insp_carrier_name":"BEAM MACK SALES & SERVICE INC","insp_carrier_street":"2674 W HENRIETTA RD","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623-2328","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:54:55.000000Z","updated_at":"2025-03-17T20:54:55.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12185638,"change_date":"2025-01-06 21:38:00","inspection_id":"83533747","insp_unit_id":"204659522","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"5392","insp_unit_license":"94629NA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1M2MDBAB4MS070107","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:49:32.000000Z","updated_at":"2025-03-17T23:49:32.000000Z"}]},{"id":7043142,"change_date":"2024-10-25 21:40:00","inspection_id":"82996587","dot_number":"378821","report_state":"NY","report_number":"M601400109","insp_date":"2024-10-24 00:00:00","insp_start_time":"0940","insp_end_time":"1009","registration_date":null,"region":"ED","ci_status_code":"C","location":"40354N","location_desc":"GROVELAND NY","county_code_state":"NY","county_code":"051","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-10-25 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"32995","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":"982273","transaction_code":"A","transaction_date":"2024-10-25 00:00:00","upload_date":"2024-10-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00378821","upload_search_indicator":null,"census_search_date":"2024-10-25 21:40:00","snet_input_date":"2024-10-24 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-10-25 21:40:00","insp_carrier_name":"BEAM MACK SALES & SERVICE INC","insp_carrier_street":"2674 W HENRIETTA RD","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623-2328","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:42:59.000000Z","updated_at":"2025-03-17T20:42:59.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11358985,"change_date":"2024-10-25 21:40:00","inspection_id":"82996587","insp_unit_id":"203581913","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"5392","insp_unit_license":"9462N9A","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1M2MDBAB4MS070107","insp_unit_decal":"Y","insp_unit_decal_number":"34639336","created_at":"2025-03-17T23:40:36.000000Z","updated_at":"2025-03-17T23:40:36.000000Z"}]},{"id":7087857,"change_date":"2024-10-31 21:41:00","inspection_id":"83043973","dot_number":"378821","report_state":"NY","report_number":"SPT3110117","insp_date":"2024-10-24 00:00:00","insp_start_time":"0855","insp_end_time":"0905","registration_date":null,"region":"ED","ci_status_code":"C","location":"60056R","location_desc":"BATH NY","county_code_state":"NY","county_code":"101","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-10-31 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"32995","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":"1003562","transaction_code":"A","transaction_date":"2024-10-31 00:00:00","upload_date":"2024-10-31 00:00:00","upload_first_byte":"0","upload_dot_number":"00378821","upload_search_indicator":null,"census_search_date":"2024-10-31 21:41:00","snet_input_date":"2024-10-24 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-10-31 21:41:00","insp_carrier_name":"BEAM MACK SALES & SERVICE INC","insp_carrier_street":"2674 W HENRIETTA RD","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623-2328","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:43:51.000000Z","updated_at":"2025-03-17T20:43:51.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11431190,"change_date":"2024-10-31 21:41:00","inspection_id":"83043973","insp_unit_id":"203669802","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"94629NA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1M2MDBAB4MS070107","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:41:23.000000Z","updated_at":"2025-03-17T23:41:23.000000Z"}]},{"id":6655602,"change_date":"2024-09-05 21:43:00","inspection_id":"82584389","dot_number":"378821","report_state":"NY","report_number":"SPWE140154","insp_date":"2024-09-05 00:00:00","insp_start_time":"0857","insp_end_time":"0912","registration_date":null,"region":"ET","ci_status_code":"C","location":"60056B","location_desc":"BATH (WB)","county_code_state":"NY","county_code":"101","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CONWAY BEAM","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-05 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"32995","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":"2949191","transaction_code":"A","transaction_date":"2024-09-05 00:00:00","upload_date":"2024-09-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00378821","upload_search_indicator":"M","census_search_date":"2024-09-05 21:43:00","snet_input_date":"2024-09-05 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-09-05 21:43:00","insp_carrier_name":"BEAM MACK SALES & SERVICE INC","insp_carrier_street":"2674 W HENRIETTA RD","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623-2328","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:34:53.000000Z","updated_at":"2025-03-17T20:34:53.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10730578,"change_date":"2024-09-05 21:43:00","inspection_id":"82584389","insp_unit_id":"202775313","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"94629NA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1M2MDBAB4MS070107","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:34:08.000000Z","updated_at":"2025-03-17T23:34:08.000000Z"}]},{"id":6343647,"change_date":"2024-07-30 21:43:00","inspection_id":"82251431","dot_number":"378821","report_state":"NY","report_number":"D306100293","insp_date":"2024-07-26 00:00:00","insp_start_time":"0920","insp_end_time":"0953","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"HORSEHEADS NY","county_code_state":"NY","county_code":"015","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-07-30 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"16000","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":"699903","transaction_code":"A","transaction_date":"2024-07-30 00:00:00","upload_date":"2024-07-30 00:00:00","upload_first_byte":"0","upload_dot_number":"00378821","upload_search_indicator":null,"census_search_date":"2024-07-30 21:43:00","snet_input_date":"2024-07-26 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-07-30 21:43:00","insp_carrier_name":"BEAM MACK SALES & SERVICE INC","insp_carrier_street":"2674 W HENRIETTA RD","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623-2328","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:28:39.000000Z","updated_at":"2025-03-17T20:28:39.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10222333,"change_date":"2024-07-30 21:43:00","inspection_id":"82251431","insp_unit_id":"202139391","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISUZU","insp_unit_company":"41","insp_unit_license":"71926NC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"JALC4W162H7K00175","insp_unit_decal":"Y","insp_unit_decal_number":"34335888","created_at":"2025-03-17T23:28:54.000000Z","updated_at":"2025-03-17T23:28:54.000000Z"}]},{"id":6260310,"change_date":"2024-07-25 21:43:00","inspection_id":"82162284","dot_number":"378821","report_state":"NY","report_number":"SPD0216465","insp_date":"2024-07-16 00:00:00","insp_start_time":"1402","insp_end_time":"1417","registration_date":null,"region":"ET","ci_status_code":"C","location":"00634D","location_desc":"HASTINGS (SB)","county_code_state":"NY","county_code":"075","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-07-19 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"32995","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":"2938055","transaction_code":"C","transaction_date":"2024-07-19 00:00:00","upload_date":"2024-07-19 00:00:00","upload_first_byte":"0","upload_dot_number":"00378821","upload_search_indicator":"M","census_search_date":"2024-07-19 21:37:00","snet_input_date":"2024-07-19 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-07-19 21:37:00","insp_carrier_name":"CONWAY BEAM TRUCK GROUP","insp_carrier_street":"2674 W HENRIETTA RD","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623-2328","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:26:57.000000Z","updated_at":"2025-03-17T20:26:57.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10086410,"change_date":"2024-07-25 21:43:00","inspection_id":"82162284","insp_unit_id":"202067018","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"5392","insp_unit_license":"94629NA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1M2MDBAB4MS070107","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:27:32.000000Z","updated_at":"2025-03-17T23:27:32.000000Z"}]},{"id":6100874,"change_date":"2024-07-09 21:43:00","inspection_id":"81991100","dot_number":"378821","report_state":"NY","report_number":"SPD0216381","insp_date":"2024-06-25 00:00:00","insp_start_time":"0740","insp_end_time":"0755","registration_date":null,"region":"ET","ci_status_code":"C","location":"70877C","location_desc":"WATERTOWN (SB)","county_code_state":"NY","county_code":"045","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-06-28 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"25995","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":"2933670","transaction_code":"C","transaction_date":"2024-06-28 00:00:00","upload_date":"2024-06-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00378821","upload_search_indicator":"M","census_search_date":"2024-06-28 21:39:00","snet_input_date":"2024-06-28 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-06-28 21:39:00","insp_carrier_name":"BEAM MACK SALES & SERVICE INC","insp_carrier_street":"2674 W HENRIETTA RD","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623-2328","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:23:43.000000Z","updated_at":"2025-03-17T20:23:43.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9826413,"change_date":"2024-07-09 21:43:00","inspection_id":"81991100","insp_unit_id":"201792040","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"99873ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1M2MDBAA3PS005566","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:24:48.000000Z","updated_at":"2025-03-17T23:24:48.000000Z"}]},{"id":6092035,"change_date":"2024-06-27 21:40:00","inspection_id":"81981666","dot_number":"378821","report_state":"NY","report_number":"SPC0226812","insp_date":"2024-06-19 00:00:00","insp_start_time":"0929","insp_end_time":"0947","registration_date":null,"region":"ET","ci_status_code":"C","location":"30690","location_desc":"PREBLE (NB)","county_code_state":"NY","county_code":"023","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"BEAM MACK SALES AND SERVICE INC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-06-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"16000","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":"2933372","transaction_code":"A","transaction_date":"2024-06-27 00:00:00","upload_date":"2024-06-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00378821","upload_search_indicator":"M","census_search_date":"2024-06-27 21:40:00","snet_input_date":"2024-06-27 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-06-27 21:40:00","insp_carrier_name":"BEAM MACK SALES & SERVICE INC","insp_carrier_street":"2674 W HENRIETTA RD","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623-2328","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:23:23.000000Z","updated_at":"2025-03-17T20:23:23.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9812133,"change_date":"2024-06-27 21:40:00","inspection_id":"81981666","insp_unit_id":"201622705","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":null,"insp_unit_license":"71926NC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"JALC4W162H7K00175","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:24:39.000000Z","updated_at":"2025-03-17T23:24:39.000000Z"}]},{"id":5849957,"change_date":"2024-05-28 21:42:00","inspection_id":"81719462","dot_number":"378821","report_state":"NY","report_number":"SPA0360423","insp_date":"2024-05-23 00:00:00","insp_start_time":"0857","insp_end_time":"0921","registration_date":null,"region":"ET","ci_status_code":"C","location":"60056B","location_desc":"BATH (WB)","county_code_state":"NY","county_code":"101","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CONWAY BEAM TRUCK GROUP","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-28 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"32995","viol_total":"1","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2926842","transaction_code":"A","transaction_date":"2024-05-28 00:00:00","upload_date":"2024-05-28 00:00:00","upload_first_byte":"0","upload_dot_number":"00378821","upload_search_indicator":"M","census_search_date":"2024-05-28 21:42:00","snet_input_date":"2024-05-28 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-05-28 21:42:00","insp_carrier_name":"BEAM MACK SALES & SERVICE INC","insp_carrier_street":"2674 W HENRIETTA RD","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623-2328","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:18:40.000000Z","updated_at":"2025-03-17T20:18:40.000000Z","inspection_violations":[{"id":9068140,"change_date":"2024-05-28 21:42:00","inspection_id":"81719462","insp_violation_id":"259748605","seq_no":"1","part_no":"391","part_no_section":"11(b)(4)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"54","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:49:50.000000Z","updated_at":"2025-03-17T21:49:50.000000Z","normalized_code":"39111B4"}],"inspection_per_units":[{"id":9421577,"change_date":"2024-05-28 21:42:00","inspection_id":"81719462","insp_unit_id":"201100060","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"5392","insp_unit_license":"94629NA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1M2MDBAB4MS070107","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:20:47.000000Z","updated_at":"2025-03-17T23:20:47.000000Z"}]},{"id":5817360,"change_date":"2024-05-22 21:40:00","inspection_id":"81684222","dot_number":"378821","report_state":"NY","report_number":"SPE0340762","insp_date":"2024-05-21 00:00:00","insp_start_time":"1226","insp_end_time":"1250","registration_date":null,"region":"ET","ci_status_code":"C","location":"60056","location_desc":"BATH","county_code_state":"NY","county_code":"101","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"LAFORGE DISPOSAL INC","shipping_paper_number":"376771E","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-22 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"16000","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2925490","transaction_code":"A","transaction_date":"2024-05-22 00:00:00","upload_date":"2024-05-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00378821","upload_search_indicator":"M","census_search_date":"2024-05-22 21:40:00","snet_input_date":"2024-05-22 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-05-22 21:40:00","insp_carrier_name":"BEAM MACK SALES & SERVICE INC","insp_carrier_street":"2674 W HENRIETTA RD","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623-2328","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:17:55.000000Z","updated_at":"2025-03-17T20:17:55.000000Z","inspection_violations":[{"id":9012399,"change_date":"2024-05-22 21:40:00","inspection_id":"81684222","insp_violation_id":"259668220","seq_no":"1","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:33.000000Z","updated_at":"2025-03-17T21:49:33.000000Z","normalized_code":"39141A"},{"id":9012400,"change_date":"2024-05-22 21:40:00","inspection_id":"81684222","insp_violation_id":"259668221","seq_no":"2","part_no":"390","part_no_section":"21(b)","insp_viol_unit":"1","insp_unit_id":"201032767","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:33.000000Z","updated_at":"2025-03-17T21:49:33.000000Z","normalized_code":"39021B"}],"inspection_per_units":[{"id":9368980,"change_date":"2024-05-22 21:40:00","inspection_id":"81684222","insp_unit_id":"201032767","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ISU","insp_unit_company":"7508","insp_unit_license":"71926NC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"JALC4W162H7K00175","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:20:16.000000Z","updated_at":"2025-03-17T23:20:16.000000Z"}]},{"id":5200882,"change_date":"2024-03-04 21:41:00","inspection_id":"81012336","dot_number":"378821","report_state":"NY","report_number":"SPC0217281","insp_date":"2024-02-15 00:00:00","insp_start_time":"0935","insp_end_time":"0951","registration_date":null,"region":"ET","ci_status_code":"C","location":"70877C","location_desc":"WATERTOWN (SB)","county_code_state":"NY","county_code":"045","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CONWAY BEAM","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-03-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"0","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":"2910218","transaction_code":"A","transaction_date":"2024-02-15 00:00:00","upload_date":"2024-03-04 00:00:00","upload_first_byte":"0","upload_dot_number":"00378821","upload_search_indicator":null,"census_search_date":"2024-03-04 21:41:00","snet_input_date":"2024-03-04 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-03-04 21:41:00","insp_carrier_name":"BEAM MACK SALES AND SERVICE INC","insp_carrier_street":"2674 W HENRIETTA RD","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:05:43.000000Z","updated_at":"2025-03-17T20:05:43.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8374195,"change_date":"2024-03-04 21:41:00","inspection_id":"81012336","insp_unit_id":"199733370","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"99873ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1M2MDBAA3PS005566","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:10:51.000000Z","updated_at":"2025-03-17T23:10:51.000000Z"}]},{"id":5086090,"change_date":"2024-02-20 21:41:00","inspection_id":"80887433","dot_number":"378821","report_state":"NY","report_number":"SPD0216070","insp_date":"2024-02-13 00:00:00","insp_start_time":"1320","insp_end_time":"1347","registration_date":null,"region":"ET","ci_status_code":"C","location":"70877C","location_desc":"WATERTOWN (SB)","county_code_state":"NY","county_code":"045","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-02-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"32995","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":"2907839","transaction_code":"A","transaction_date":"2024-02-13 00:00:00","upload_date":"2024-02-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00378821","upload_search_indicator":null,"census_search_date":"2024-02-20 21:41:00","snet_input_date":"2024-02-20 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-02-20 21:41:00","insp_carrier_name":"BEAM MACK SALES AND SERVICE INC","insp_carrier_street":"2674 W HENRIETTA RD","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:03:27.000000Z","updated_at":"2025-03-17T20:03:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8187879,"change_date":"2024-02-20 21:41:00","inspection_id":"80887433","insp_unit_id":"199495245","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"5392","insp_unit_license":"94629NA","insp_unit_license_state":"OA","insp_unit_vehicle_id_number":"1M2MDBAB4MS070107","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:09:12.000000Z","updated_at":"2025-03-17T23:09:12.000000Z"}]},{"id":5006093,"change_date":"2024-02-08 21:42:00","inspection_id":"80800038","dot_number":"378821","report_state":"NY","report_number":"SPT0442087","insp_date":"2024-02-02 00:00:00","insp_start_time":"1119","insp_end_time":"1139","registration_date":null,"region":"ET","ci_status_code":"C","location":"40388A","location_desc":"HENRIETTA (EXIT 46)","county_code_state":"NY","county_code":"055","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":"2024-02-08 21:42: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":"2905054","transaction_code":"A","transaction_date":"2024-02-08 00:00:00","upload_date":"2024-02-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00378821","upload_search_indicator":"M","census_search_date":"2024-02-08 21:42:00","snet_input_date":"2024-02-08 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-02-08 21:42:00","insp_carrier_name":"BEAM MACK SALES & SERVICE INC","insp_carrier_street":"2674 W HENRIETTA RD","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623-2328","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:02:00.000000Z","updated_at":"2025-03-17T20:02:00.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8057199,"change_date":"2024-02-08 21:42:00","inspection_id":"80800038","insp_unit_id":"199328145","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"5392","insp_unit_license":"94629NA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1M2MDBAB4MS070107","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:08:01.000000Z","updated_at":"2025-03-17T23:08:01.000000Z"}]},{"id":4883253,"change_date":"2024-01-23 21:44:00","inspection_id":"80665455","dot_number":"378821","report_state":"NY","report_number":"SPD0291767","insp_date":"2024-01-19 00:00:00","insp_start_time":"1259","insp_end_time":"1314","registration_date":null,"region":"ET","ci_status_code":"C","location":"30445B","location_desc":"LAFAYETTE (SB)","county_code_state":"NY","county_code":"067","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CONWAYBEAM TRUCKING GROUP","shipping_paper_number":"503001S","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-01-23 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"19000","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":"2901512","transaction_code":"A","transaction_date":"2024-01-23 00:00:00","upload_date":"2024-01-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00378821","upload_search_indicator":"M","census_search_date":"2024-01-23 21:44:00","snet_input_date":"2024-01-23 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-01-23 21:44:00","insp_carrier_name":"BEAM MACK SALES & SERVICE INC","insp_carrier_street":"2674 W HENRIETTA RD","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623-2328","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:59:35.000000Z","updated_at":"2025-03-17T19:59:35.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7857072,"change_date":"2024-01-23 21:44:00","inspection_id":"80665455","insp_unit_id":"199067279","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"96125NB","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"JHHSDM2H9FK002458","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:06:13.000000Z","updated_at":"2025-03-17T23:06:13.000000Z"}]},{"id":4430801,"change_date":"2023-11-15 21:41:00","inspection_id":"80169774","dot_number":"378821","report_state":"NY","report_number":"SPD0281168","insp_date":"2023-11-14 00:00:00","insp_start_time":"1010","insp_end_time":"1025","registration_date":null,"region":"ET","ci_status_code":"C","location":"30445A","location_desc":"LAFAYETTE (NB)","county_code_state":"NY","county_code":"067","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CONWAY BEAM TRUCK GROUP","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-15 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"32995","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":"2887273","transaction_code":"A","transaction_date":"2023-11-14 00:00:00","upload_date":"2023-11-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00378821","upload_search_indicator":null,"census_search_date":"2023-11-15 21:41:00","snet_input_date":"2023-11-15 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-11-15 21:41:00","insp_carrier_name":"BEAM MACK SALES AND SERVICE INC","insp_carrier_street":"2674 W HENRIETTA RD","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:50:43.000000Z","updated_at":"2025-03-17T19:50:43.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7125289,"change_date":"2023-11-15 21:41:00","inspection_id":"80169774","insp_unit_id":"198072139","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"5392","insp_unit_license":"94629NA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1M2MDBAB4MS070107","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:59:50.000000Z","updated_at":"2025-03-17T22:59:50.000000Z"}]},{"id":4545827,"change_date":"2023-12-08 21:40:00","inspection_id":"80296344","dot_number":"378821","report_state":"NY","report_number":"SPC0217041","insp_date":"2023-11-14 00:00:00","insp_start_time":"0924","insp_end_time":"0941","registration_date":null,"region":"ET","ci_status_code":"C","location":"70877C","location_desc":"WATERTOWN (SB)","county_code_state":"NY","county_code":"045","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CONWAY BEAM","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-04 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"0","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2890998","transaction_code":"C","transaction_date":"2023-11-14 00:00:00","upload_date":"2023-12-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00378821","upload_search_indicator":null,"census_search_date":"2023-12-04 21:40:00","snet_input_date":"2023-12-04 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-12-04 21:40:00","insp_carrier_name":"BEAM MACK SALES AND SERVICE INC","insp_carrier_street":"2674 W HENRIETTA RD","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:52:58.000000Z","updated_at":"2025-03-17T19:52:58.000000Z","inspection_violations":[{"id":7033458,"change_date":"2023-12-08 21:40:00","inspection_id":"80296344","insp_violation_id":"256787012","seq_no":"1","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:54.000000Z","updated_at":"2025-03-17T21:39:54.000000Z","normalized_code":"39141A"},{"id":7033459,"change_date":"2023-12-08 21:40:00","inspection_id":"80296344","insp_violation_id":"256787013","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"198413857","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:54.000000Z","updated_at":"2025-03-17T21:39:54.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7310927,"change_date":"2023-12-08 21:40:00","inspection_id":"80296344","insp_unit_id":"198413857","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"99873ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1M2MDBAA3PS005566","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:26.000000Z","updated_at":"2025-03-17T23:01:26.000000Z"}]},{"id":4191388,"change_date":"2023-10-13 21:40:00","inspection_id":"79905065","dot_number":"378821","report_state":"NY","report_number":"MC86000538","insp_date":"2023-10-12 00:00:00","insp_start_time":"1000","insp_end_time":"1028","registration_date":null,"region":"ET","ci_status_code":"C","location":"40354M","location_desc":"GROVELAND REST AREA (NB)","county_code_state":"NY","county_code":"051","insp_level_id":"1","service_center":"EA","census_source_id":"4","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":"I","final_status_date":"2023-10-13 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"32995","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":"2878286","transaction_code":"A","transaction_date":"2023-10-12 00:00:00","upload_date":"2023-10-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00378821","upload_search_indicator":null,"census_search_date":"2023-10-13 21:40:00","snet_input_date":"2023-10-13 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-10-13 21:40:00","insp_carrier_name":"BEAM MACK SALES & SERVICE INC","insp_carrier_street":"2674 W HENRIETTA RD","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623-2328","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:45:52.000000Z","updated_at":"2025-03-17T19:45:52.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6740212,"change_date":"2023-10-13 21:40:00","inspection_id":"79905065","insp_unit_id":"197541717","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"5392","insp_unit_license":"94629NA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1M2MDBAB4MS070107","insp_unit_decal":"Y","insp_unit_decal_number":"33399409","created_at":"2025-03-17T22:56:31.000000Z","updated_at":"2025-03-17T22:56:31.000000Z"}]},{"id":4191394,"change_date":"2023-10-13 21:40:00","inspection_id":"79905073","dot_number":"378821","report_state":"NY","report_number":"SPB0256823","insp_date":"2023-10-12 00:00:00","insp_start_time":"1520","insp_end_time":"1547","registration_date":null,"region":"ET","ci_status_code":"C","location":"70623","location_desc":"OSWEGATCHIE REST AREA","county_code_state":"NY","county_code":"089","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"BEAN MACK SALES AND SERVICE","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-10-13 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25995","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":"2878372","transaction_code":"A","transaction_date":"2023-10-12 00:00:00","upload_date":"2023-10-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00378821","upload_search_indicator":null,"census_search_date":"2023-10-13 21:40:00","snet_input_date":"2023-10-13 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-10-13 21:40:00","insp_carrier_name":"CONWAY BEAM TRUCK GROUP","insp_carrier_street":"2674 W HENRIETTA RD","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:45:52.000000Z","updated_at":"2025-03-17T19:45:52.000000Z","inspection_violations":[{"id":6489671,"change_date":"2023-10-13 21:40:00","inspection_id":"79905073","insp_violation_id":"255820433","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"197541730","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:18.000000Z","updated_at":"2025-03-17T21:37:18.000000Z","normalized_code":"3922"},{"id":6489672,"change_date":"2023-10-13 21:40:00","inspection_id":"79905073","insp_violation_id":"255820434","seq_no":"1","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"197541730","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:18.000000Z","updated_at":"2025-03-17T21:37:18.000000Z","normalized_code":"39395F"}],"inspection_per_units":[{"id":6740220,"change_date":"2023-10-13 21:40:00","inspection_id":"79905073","insp_unit_id":"197541730","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"99873ND","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1M2MDBAA3PS005566","insp_unit_decal":"Y","insp_unit_decal_number":"33401065","created_at":"2025-03-17T22:56:31.000000Z","updated_at":"2025-03-17T22:56:31.000000Z"}]},{"id":4110794,"change_date":"2023-10-03 21:40:00","inspection_id":"79816008","dot_number":"378821","report_state":"NY","report_number":"SPE0311260","insp_date":"2023-09-29 00:00:00","insp_start_time":"1224","insp_end_time":"1240","registration_date":null,"region":"ET","ci_status_code":"C","location":"30100","location_desc":"BRUTUS (EXIT 40)","county_code_state":"NY","county_code":"011","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CONWAY BEAM","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-10-03 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2874683","transaction_code":"A","transaction_date":"2023-10-02 00:00:00","upload_date":"2023-10-02 00:00:00","upload_first_byte":"0","upload_dot_number":"00378821","upload_search_indicator":"M","census_search_date":"2023-10-03 21:40:00","snet_input_date":"2023-10-02 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-10-03 21:40:00","insp_carrier_name":"BEAM MACK SALES & SERVICE INC","insp_carrier_street":"2674 W HENRIETTA RD","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623-2328","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:44:03.000000Z","updated_at":"2025-03-17T19:44:03.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6609429,"change_date":"2023-10-03 21:40:00","inspection_id":"79816008","insp_unit_id":"197362810","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"44015MN","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"JHHSDM2H2KK008676","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:55:26.000000Z","updated_at":"2025-03-17T22:55:26.000000Z"}]},{"id":3638411,"change_date":"2023-08-01 21:41:00","inspection_id":"79289331","dot_number":"378821","report_state":"NY","report_number":"0326001335","insp_date":"2023-07-31 00:00:00","insp_start_time":"1130","insp_end_time":"1201","registration_date":null,"region":"ET","ci_status_code":"C","location":"30100M","location_desc":"BRUTUS EXIT 40 TANDEM LOT","county_code_state":"NY","county_code":"011","insp_level_id":"1","service_center":"EA","census_source_id":"4","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":"2023-08-01 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"13660","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":"2853819","transaction_code":"A","transaction_date":"2023-08-01 00:00:00","upload_date":"2023-08-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00378821","upload_search_indicator":"M","census_search_date":"2023-08-01 21:41:00","snet_input_date":"2023-08-01 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-08-01 21:41:00","insp_carrier_name":"BEAM MACK SALES & SERVICE INC","insp_carrier_street":"2674 W HENRIETTA RD","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623-2328","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:34:37.000000Z","updated_at":"2025-03-17T19:34:37.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5849980,"change_date":"2023-08-01 21:41:00","inspection_id":"79289331","insp_unit_id":"196291969","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"5363","insp_unit_license":"44015MN","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"JHHSDM2H2KK008676","insp_unit_decal":"Y","insp_unit_decal_number":"33073289","created_at":"2025-03-17T22:49:10.000000Z","updated_at":"2025-03-17T22:49:10.000000Z"}]},{"id":3605948,"change_date":"2023-07-27 21:40:00","inspection_id":"79252914","dot_number":"378821","report_state":"NY","report_number":"SPD0291158","insp_date":"2023-07-26 00:00:00","insp_start_time":"1310","insp_end_time":"1326","registration_date":null,"region":"ET","ci_status_code":"C","location":"30445A","location_desc":"LAFAYETTE (NB)","county_code_state":"NY","county_code":"067","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CONWAY BEAM TRUCK GROUP","shipping_paper_number":"494856S","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-07-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2852440","transaction_code":"A","transaction_date":"2023-07-27 00:00:00","upload_date":"2023-07-27 00:00:00","upload_first_byte":"0","upload_dot_number":"00378821","upload_search_indicator":"M","census_search_date":"2023-07-27 21:40:00","snet_input_date":"2023-07-27 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-07-27 21:40:00","insp_carrier_name":"BEAM MACK SALES & SERVICE INC","insp_carrier_street":"2674 W HENRIETTA RD","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623-2328","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:34:12.000000Z","updated_at":"2025-03-17T19:34:12.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5797638,"change_date":"2023-07-27 21:40:00","inspection_id":"79252914","insp_unit_id":"196219926","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"5363","insp_unit_license":"44015MN","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"JHHSDM2H2KK008676","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:46.000000Z","updated_at":"2025-03-17T22:48:46.000000Z"}]},{"id":3420008,"change_date":"2023-07-03 21:38:00","inspection_id":"79044159","dot_number":"378821","report_state":"NY","report_number":"0510024553","insp_date":"2023-06-29 00:00:00","insp_start_time":"1432","insp_end_time":"1457","registration_date":null,"region":"ET","ci_status_code":"C","location":"40354M","location_desc":"GROVELAND REST AREA (SB)","county_code_state":"NY","county_code":"051","insp_level_id":"1","service_center":"EA","census_source_id":"4","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":"I","final_status_date":"2023-07-03 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"32995","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":"2843286","transaction_code":"A","transaction_date":"2023-06-29 00:00:00","upload_date":"2023-07-03 00:00:00","upload_first_byte":"0","upload_dot_number":"00378821","upload_search_indicator":null,"census_search_date":"2023-07-03 21:38:00","snet_input_date":"2023-07-03 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-07-03 21:38:00","insp_carrier_name":"BEAM MACK SALES & SERVICE INC","insp_carrier_street":"2674 W HENRIETTA RD","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623-2328","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:30:53.000000Z","updated_at":"2025-03-17T19:30:53.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5498301,"change_date":"2023-07-03 21:38:00","inspection_id":"79044159","insp_unit_id":"195797311","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"5392","insp_unit_license":"94629NA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1M2MDBAB4MS070107","insp_unit_decal":"Y","insp_unit_decal_number":"NODECALS","created_at":"2025-03-17T22:46:23.000000Z","updated_at":"2025-03-17T22:46:23.000000Z"}]},{"id":3361362,"change_date":"2023-06-26 21:40:00","inspection_id":"78978286","dot_number":"378821","report_state":"NY","report_number":"SPD0271232","insp_date":"2023-06-23 00:00:00","insp_start_time":"1214","insp_end_time":"1229","registration_date":null,"region":"ET","ci_status_code":"C","location":"30445B","location_desc":"LAFAYETTE (SB)","county_code_state":"NY","county_code":"067","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CONWAY BEAM TRUCK GROUP","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-06-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2841325","transaction_code":"A","transaction_date":"2023-06-23 00:00:00","upload_date":"2023-06-26 00:00:00","upload_first_byte":"0","upload_dot_number":"00378821","upload_search_indicator":null,"census_search_date":"2023-06-26 21:40:00","snet_input_date":"2023-06-26 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-06-26 21:40:00","insp_carrier_name":"BEAM MACK SALES AND SERVICE INC","insp_carrier_street":"2674 W HENRIETTA RD","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"146232328","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:29:43.000000Z","updated_at":"2025-03-17T19:29:43.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5403309,"change_date":"2023-06-26 21:40:00","inspection_id":"78978286","insp_unit_id":"195666337","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"96125NB","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"JHHSDM2H9FK002458","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:45:37.000000Z","updated_at":"2025-03-17T22:45:37.000000Z"}]},{"id":3112517,"change_date":"2023-05-23 21:41:00","inspection_id":"78697418","dot_number":"378821","report_state":"NY","report_number":"SPD0215167","insp_date":"2023-05-16 00:00:00","insp_start_time":"1250","insp_end_time":"1307","registration_date":null,"region":"ET","ci_status_code":"C","location":"70877C","location_desc":"WATERTOWN (SB)","county_code_state":"NY","county_code":"045","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-05-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"32995","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":"2828391","transaction_code":"A","transaction_date":"2023-05-23 00:00:00","upload_date":"2023-05-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00378821","upload_search_indicator":"M","census_search_date":"2023-05-23 21:41:00","snet_input_date":"2023-05-23 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-05-23 21:41:00","insp_carrier_name":"BEAM MACK SALES & SERVICE INC","insp_carrier_street":"2674 W HENRIETTA RD","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623-2328","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:24:36.000000Z","updated_at":"2025-03-17T19:24:36.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5006491,"change_date":"2023-05-23 21:41:00","inspection_id":"78697418","insp_unit_id":"195079085","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"5392","insp_unit_license":"94629NA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1M2MDBAB4MS070107","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:28.000000Z","updated_at":"2025-03-17T22:42:28.000000Z"}]},{"id":2385013,"change_date":"2023-02-16 21:41:00","inspection_id":"77871931","dot_number":"378821","report_state":"NY","report_number":"0326000839","insp_date":"2023-02-14 00:00:00","insp_start_time":"1000","insp_end_time":"1018","registration_date":null,"region":"ET","ci_status_code":"C","location":"32021","location_desc":"ITHACA CEMETARY","county_code_state":"NY","county_code":"109","insp_level_id":"2","service_center":"EA","census_source_id":"4","insp_facility":"R","shipper_name":"CONWAY BEAM TRUCK GROUP","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-02-16 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"32995","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":"2799591","transaction_code":"A","transaction_date":"2023-02-15 00:00:00","upload_date":"2023-02-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00378821","upload_search_indicator":"M","census_search_date":"2023-02-16 21:41:00","snet_input_date":"2023-02-15 00:00:00","source_office":"1NYS001","mcmis_add_date":"2023-02-16 21:41:00","insp_carrier_name":"BEAM MACK SALES & SERVICE INC","insp_carrier_street":"2674 W HENRIETTA RD","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623-2328","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:10:42.000000Z","updated_at":"2025-03-17T19:10:42.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3837543,"change_date":"2023-02-16 21:41:00","inspection_id":"77871931","insp_unit_id":"193430832","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"5392","insp_unit_license":"94629NA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1M2MDBAB4MS070107","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:29.000000Z","updated_at":"2025-03-17T22:33:29.000000Z"}]},{"id":2009446,"change_date":"2022-12-23 21:33:00","inspection_id":"77442820","dot_number":"378821","report_state":"NY","report_number":"5L42000021","insp_date":"2022-12-22 00:00:00","insp_start_time":"0954","insp_end_time":"1018","registration_date":null,"region":"ET","ci_status_code":"C","location":"40354M","location_desc":"GROVELAND REST AREA (NB)","county_code_state":"NY","county_code":"051","insp_level_id":"1","service_center":"EA","census_source_id":"4","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":"Y","pen_cen_match":"I","final_status_date":"2022-12-23 21:33: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":"2783082","transaction_code":"A","transaction_date":"2022-12-23 00:00:00","upload_date":"2022-12-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00378821","upload_search_indicator":"M","census_search_date":"2022-12-23 21:33:00","snet_input_date":"2022-12-23 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-12-23 21:33:00","insp_carrier_name":"BEAM MACK SALES & SERVICE INC","insp_carrier_street":"2674 W HENRIETTA RD","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623-2328","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:03:40.000000Z","updated_at":"2025-03-17T19:03:40.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3232578,"change_date":"2022-12-23 21:33:00","inspection_id":"77442820","insp_unit_id":"192567847","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"5392","insp_unit_license":"94629NA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1M2MDBAB4MS070107","insp_unit_decal":"Y","insp_unit_decal_number":"XXXXXXX","created_at":"2025-03-17T22:29:08.000000Z","updated_at":"2025-03-17T22:29:08.000000Z"}]},{"id":1738654,"change_date":"2022-11-15 21:39:00","inspection_id":"77132730","dot_number":"378821","report_state":"NY","report_number":"0509015587","insp_date":"2022-11-10 00:00:00","insp_start_time":"0958","insp_end_time":"1008","registration_date":null,"region":"ET","ci_status_code":"C","location":"40354M","location_desc":"GROVELAND REST AREA (NB)","county_code_state":"NY","county_code":"051","insp_level_id":"1","service_center":"EA","census_source_id":"4","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":"I","final_status_date":"2022-11-15 21:39: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":"2768067","transaction_code":"A","transaction_date":"2022-11-15 00:00:00","upload_date":"2022-11-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00378821","upload_search_indicator":"M","census_search_date":"2022-11-15 21:39:00","snet_input_date":"2022-11-15 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-11-15 21:39:00","insp_carrier_name":"BEAM MACK SALES & SERVICE INC","insp_carrier_street":"2674 W HENRIETTA RD","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623-2328","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:58:36.000000Z","updated_at":"2025-03-17T18:58:36.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2797271,"change_date":"2022-11-15 21:39:00","inspection_id":"77132730","insp_unit_id":"191952140","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"5392","insp_unit_license":"94629NA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1M2MDBAB4MS070107","insp_unit_decal":"Y","insp_unit_decal_number":"32006633","created_at":"2025-03-17T22:26:09.000000Z","updated_at":"2025-03-17T22:26:09.000000Z"}]},{"id":1759510,"change_date":"2022-11-17 21:39:00","inspection_id":"77156640","dot_number":"378821","report_state":"NY","report_number":"SPE0310359","insp_date":"2022-11-03 00:00:00","insp_start_time":"0942","insp_end_time":"1000","registration_date":null,"region":"ET","ci_status_code":"C","location":"40354A","location_desc":"GROVELAND (NB)","county_code_state":"NY","county_code":"051","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CONWAY BEAM","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-11-17 21:39: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":"2770790","transaction_code":"A","transaction_date":"2022-11-17 00:00:00","upload_date":"2022-11-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00378821","upload_search_indicator":"M","census_search_date":"2022-11-17 21:39:00","snet_input_date":"2022-11-17 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-11-17 21:39:00","insp_carrier_name":"BEAM MACK SALES & SERVICE INC","insp_carrier_street":"2674 W HENRIETTA RD","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623-2328","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:58:59.000000Z","updated_at":"2025-03-17T18:58:59.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2830640,"change_date":"2022-11-17 21:39:00","inspection_id":"77156640","insp_unit_id":"192001012","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"94629NA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1M2MDBAB4MS070107","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:22.000000Z","updated_at":"2025-03-17T22:26:22.000000Z"}]},{"id":1760853,"change_date":"2022-11-17 21:40:00","inspection_id":"77158133","dot_number":"378821","report_state":"NY","report_number":"SPWD041499","insp_date":"2022-11-03 00:00:00","insp_start_time":"0903","insp_end_time":"0921","registration_date":null,"region":"ET","ci_status_code":"C","location":"30170","location_desc":"CLAY","county_code_state":"NY","county_code":"067","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":"N","pen_cen_match":null,"final_status_date":"2022-11-17 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2770877","transaction_code":"A","transaction_date":"2022-11-17 00:00:00","upload_date":"2022-11-17 00:00:00","upload_first_byte":"0","upload_dot_number":"00378821","upload_search_indicator":"M","census_search_date":"2022-11-17 21:40:00","snet_input_date":"2022-11-17 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-11-17 21:40:00","insp_carrier_name":"BEAM MACK SALES & SERVICE INC","insp_carrier_street":"2674 W HENRIETTA RD","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623-2328","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:59:15.000000Z","updated_at":"2025-03-17T18:59:15.000000Z","inspection_violations":[{"id":2758347,"change_date":"2022-11-17 21:40:00","inspection_id":"77158133","insp_violation_id":"249654414","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"192003262","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"4G2B0XM","created_at":"2025-03-17T21:19:57.000000Z","updated_at":"2025-03-17T21:19:57.000000Z","normalized_code":"3922"},{"id":2758348,"change_date":"2022-11-17 21:40:00","inspection_id":"77158133","insp_violation_id":"249654415","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"192003262","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:57.000000Z","updated_at":"2025-03-17T21:19:57.000000Z","normalized_code":"3922"},{"id":2758349,"change_date":"2022-11-17 21:40:00","inspection_id":"77158133","insp_violation_id":"249654416","seq_no":"3","part_no":"390","part_no_section":"21(b)","insp_viol_unit":"1","insp_unit_id":"192003262","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:57.000000Z","updated_at":"2025-03-17T21:19:57.000000Z","normalized_code":"39021B"}],"inspection_per_units":[{"id":2832556,"change_date":"2022-11-17 21:40:00","inspection_id":"77158133","insp_unit_id":"192003262","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"96125NB","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"JHHSDM2H9FK002458","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:22.000000Z","updated_at":"2025-03-17T22:26:22.000000Z"}]},{"id":1300020,"change_date":"2022-09-16 21:40:00","inspection_id":"76626604","dot_number":"378821","report_state":"NY","report_number":"SPE0292985","insp_date":"2022-09-15 00:00:00","insp_start_time":"0920","insp_end_time":"0940","registration_date":null,"region":"ET","ci_status_code":"C","location":"40354A","location_desc":"GROVELAND (NB)","county_code_state":"NY","county_code":"051","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CONWAY BEAM","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-09-16 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":"2749526","transaction_code":"A","transaction_date":"2022-09-16 00:00:00","upload_date":"2022-09-16 00:00:00","upload_first_byte":"0","upload_dot_number":"00378821","upload_search_indicator":"M","census_search_date":"2022-09-16 21:40:00","snet_input_date":"2022-09-16 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-09-16 21:40:00","insp_carrier_name":"BEAM MACK SALES & SERVICE INC","insp_carrier_street":"2674 W HENRIETTA RD","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623-2328","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:50:47.000000Z","updated_at":"2025-03-17T18:50:47.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2092503,"change_date":"2022-09-16 21:40:00","inspection_id":"76626604","insp_unit_id":"190935364","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"5392","insp_unit_license":"94629NA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1M2MDBAB4MS070107","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:21.000000Z","updated_at":"2025-03-17T22:21:21.000000Z"}]},{"id":1271187,"change_date":"2022-09-13 21:40:00","inspection_id":"76592746","dot_number":"378821","report_state":"NY","report_number":"SPD0214465","insp_date":"2022-09-07 00:00:00","insp_start_time":"1535","insp_end_time":"1602","registration_date":null,"region":"ET","ci_status_code":"C","location":"30445A","location_desc":"LAFAYETTE (NB)","county_code_state":"NY","county_code":"067","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-09-13 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2748285","transaction_code":"A","transaction_date":"2022-09-13 00:00:00","upload_date":"2022-09-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00378821","upload_search_indicator":"M","census_search_date":"2022-09-13 21:40:00","snet_input_date":"2022-09-13 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-09-13 21:40:00","insp_carrier_name":"CONWAY BEAM TRUCK GROUP","insp_carrier_street":"2674 W HENRIETTA RD","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623-2328","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":2012795,"change_date":"2022-09-13 21:40:00","inspection_id":"76592746","insp_violation_id":"248372556","seq_no":"1","part_no":"390","part_no_section":"21(b)","insp_viol_unit":"1","insp_unit_id":"190862247","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"1FV8HM8","created_at":"2025-03-17T21:16:14.000000Z","updated_at":"2025-03-17T21:16:14.000000Z","normalized_code":"39021B"},{"id":2012796,"change_date":"2022-09-13 21:40:00","inspection_id":"76592746","insp_violation_id":"248372557","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"190862247","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"},{"id":2012797,"change_date":"2022-09-13 21:40:00","inspection_id":"76592746","insp_violation_id":"248372558","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"190862247","insp_violation_category_id":"20","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":"3939A"}],"inspection_per_units":[{"id":2045551,"change_date":"2022-09-13 21:40:00","inspection_id":"76592746","insp_unit_id":"190862247","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"96125NB","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"JHHSDM2H9FK002458","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:03.000000Z","updated_at":"2025-03-17T22:21:03.000000Z"}]},{"id":1271315,"change_date":"2022-09-13 21:40:00","inspection_id":"76592890","dot_number":"378821","report_state":"NY","report_number":"0509015485","insp_date":"2022-09-01 00:00:00","insp_start_time":"0947","insp_end_time":"1008","registration_date":null,"region":"ET","ci_status_code":"C","location":"40354M","location_desc":"GROVELAND REST AREA (NB)","county_code_state":"NY","county_code":"051","insp_level_id":"1","service_center":"EA","census_source_id":"4","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":"I","final_status_date":"2022-09-13 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"32999","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":"2748175","transaction_code":"A","transaction_date":"2022-09-13 00:00:00","upload_date":"2022-09-13 00:00:00","upload_first_byte":"0","upload_dot_number":"00378821","upload_search_indicator":"M","census_search_date":"2022-09-13 21:40:00","snet_input_date":"2022-09-13 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-09-13 21:40:00","insp_carrier_name":"BEAM MACK SALES & SERVICE INC","insp_carrier_street":"2674 W HENRIETTA RD","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623-2328","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":[],"inspection_per_units":[{"id":2045736,"change_date":"2022-09-13 21:40:00","inspection_id":"76592890","insp_unit_id":"190862462","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"5392","insp_unit_license":"94629NA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1M2MDBAB4MS070107","insp_unit_decal":"Y","insp_unit_decal_number":"31688798","created_at":"2025-03-17T22:21:03.000000Z","updated_at":"2025-03-17T22:21:03.000000Z"}]},{"id":776127,"change_date":"2022-07-08 21:40:00","inspection_id":"76015680","dot_number":"378821","report_state":"NY","report_number":"5L30000809","insp_date":"2022-07-07 00:00:00","insp_start_time":"0954","insp_end_time":"1022","registration_date":null,"region":"ET","ci_status_code":"C","location":"40354M","location_desc":"GROVELAND REST AREA (NB)","county_code_state":"NY","county_code":"051","insp_level_id":"1","service_center":"EA","census_source_id":"4","insp_facility":"F","shipper_name":"CONWAY BEAM","shipping_paper_number":"INTERNAL TRANSF","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":"Y","pen_cen_match":"I","final_status_date":"2022-07-08 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":"2725173","transaction_code":"A","transaction_date":"2022-07-08 00:00:00","upload_date":"2022-07-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00378821","upload_search_indicator":"M","census_search_date":"2022-07-08 21:40:00","snet_input_date":"2022-07-08 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-07-08 21:40:00","insp_carrier_name":"BEAM MACK SALES & SERVICE INC","insp_carrier_street":"2674 W HENRIETTA RD","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623-2328","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:41:16.000000Z","updated_at":"2025-03-17T18:41:16.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1248763,"change_date":"2022-07-08 21:40:00","inspection_id":"76015680","insp_unit_id":"189667168","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"5392","insp_unit_license":"94629NA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1M2MDBAB4MS070107","insp_unit_decal":"Y","insp_unit_decal_number":"XXXXXXXX","created_at":"2025-03-17T22:15:51.000000Z","updated_at":"2025-03-17T22:15:51.000000Z"}]},{"id":744412,"change_date":"2022-07-05 21:41:00","inspection_id":"75978804","dot_number":"378821","report_state":"NY","report_number":"SPWA080786","insp_date":"2022-06-28 00:00:00","insp_start_time":"1125","insp_end_time":"1203","registration_date":null,"region":"ET","ci_status_code":"C","location":"50268","location_desc":"ELMA","county_code_state":"NY","county_code":"029","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":"N","pen_cen_match":null,"final_status_date":"2022-07-05 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"2","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2724174","transaction_code":"A","transaction_date":"2022-07-05 00:00:00","upload_date":"2022-07-05 00:00:00","upload_first_byte":"0","upload_dot_number":"00378821","upload_search_indicator":"M","census_search_date":"2022-07-05 21:41:00","snet_input_date":"2022-07-05 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-07-05 21:41:00","insp_carrier_name":"BEAM MACK SALES & SERVICE INC","insp_carrier_street":"2674 W HENRIETTA RD","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623-2328","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:40:52.000000Z","updated_at":"2025-03-17T18:40:52.000000Z","inspection_violations":[{"id":1172967,"change_date":"2022-07-05 21:41:00","inspection_id":"75978804","insp_violation_id":"246874049","seq_no":"1","part_no":"999","part_no_section":null,"insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:12:28.000000Z","updated_at":"2025-03-17T21:12:28.000000Z","normalized_code":"999"},{"id":1172968,"change_date":"2022-07-05 21:41:00","inspection_id":"75978804","insp_violation_id":"246874050","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:12:28.000000Z","updated_at":"2025-03-17T21:12:28.000000Z","normalized_code":"39141A"}],"inspection_per_units":[{"id":1196409,"change_date":"2022-07-05 21:41:00","inspection_id":"75978804","insp_unit_id":"189588917","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"28052PC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"5PVNV8JT2D4S52569","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:32.000000Z","updated_at":"2025-03-17T22:15:32.000000Z"}]},{"id":520855,"change_date":"2022-06-01 21:49:00","inspection_id":"75713979","dot_number":"378821","report_state":"NY","report_number":"SPE0292583","insp_date":"2022-05-31 00:00:00","insp_start_time":"0820","insp_end_time":"0840","registration_date":null,"region":"ET","ci_status_code":"C","location":"60405","location_desc":"T\/HORSEHEADS","county_code_state":"NY","county_code":"015","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-06-01 21:49: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":"2712749","transaction_code":"A","transaction_date":"2022-06-01 00:00:00","upload_date":"2022-06-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00378821","upload_search_indicator":"M","census_search_date":"2022-06-01 21:49:00","snet_input_date":"2022-06-01 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-06-01 21:49:00","insp_carrier_name":"BEAM MACK SALES & SERVICE INC","insp_carrier_street":"2674 W HENRIETTA RD","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623-2328","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:37:00.000000Z","updated_at":"2025-03-17T18:37:00.000000Z","inspection_violations":[],"inspection_per_units":[{"id":838068,"change_date":"2022-06-01 21:49:00","inspection_id":"75713979","insp_unit_id":"189006827","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"5392","insp_unit_license":"94629NA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1M2MDBAB4MS070107","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:22.000000Z","updated_at":"2025-03-17T22:13:22.000000Z"}]},{"id":440188,"change_date":"2022-05-20 21:40:00","inspection_id":"75617786","dot_number":"378821","report_state":"NY","report_number":"0519000184","insp_date":"2022-05-19 00:00:00","insp_start_time":"1600","insp_end_time":"1616","registration_date":null,"region":"ET","ci_status_code":"C","location":"60117M","location_desc":"CAMPBELL REST AREA (EB)","county_code_state":"NY","county_code":"101","insp_level_id":"1","service_center":"EA","census_source_id":"4","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":"I","final_status_date":"2022-05-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"32995","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":"2709054","transaction_code":"A","transaction_date":"2022-05-20 00:00:00","upload_date":"2022-05-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00378821","upload_search_indicator":"M","census_search_date":"2022-05-20 21:40:00","snet_input_date":"2022-05-20 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-05-20 21:40:00","insp_carrier_name":"BEAM MACK SALES & SERVICE INC","insp_carrier_street":"2674 W HENRIETTA RD","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623-2328","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:35:35.000000Z","updated_at":"2025-03-17T18:35:35.000000Z","inspection_violations":[],"inspection_per_units":[{"id":709622,"change_date":"2022-05-20 21:40:00","inspection_id":"75617786","insp_unit_id":"188807153","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"94629NA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1M2MDBAB4MS070107","insp_unit_decal":"Y","insp_unit_decal_number":"NODECALS","created_at":"2025-03-17T22:12:33.000000Z","updated_at":"2025-03-17T22:12:33.000000Z"}]},{"id":134263,"change_date":"2022-04-08 21:39:00","inspection_id":"75252928","dot_number":"378821","report_state":"NY","report_number":"SPC0158066","insp_date":"2022-04-05 00:00:00","insp_start_time":"1300","insp_end_time":"1315","registration_date":null,"region":"ET","ci_status_code":"C","location":"70877C","location_desc":"WATERTOWN (SB)","county_code_state":"NY","county_code":"045","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"CONWAY BEAM TRUCK GROUP","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-04-08 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"32995","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":"2693496","transaction_code":"A","transaction_date":"2022-04-08 00:00:00","upload_date":"2022-04-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00378821","upload_search_indicator":"M","census_search_date":"2022-04-08 21:39:00","snet_input_date":"2022-04-08 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-04-08 21:39:00","insp_carrier_name":"BEAM MACK SALES & SERVICE INC","insp_carrier_street":"2674 W HENRIETTA RD","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623-2328","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:29:51.000000Z","updated_at":"2025-03-17T18:29:51.000000Z","inspection_violations":[],"inspection_per_units":[{"id":217267,"change_date":"2022-04-08 21:39:00","inspection_id":"75252928","insp_unit_id":"188053723","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"5392","insp_unit_license":"94629NA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1M2MDBAB4MS070107","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:31.000000Z","updated_at":"2025-03-17T22:09:31.000000Z"}]},{"id":40592,"change_date":"2022-03-25 21:31:00","inspection_id":"75137043","dot_number":"378821","report_state":"NY","report_number":"SPF0184501","insp_date":"2022-03-23 00:00:00","insp_start_time":"1330","insp_end_time":"1345","registration_date":null,"region":"ET","ci_status_code":"C","location":"30690","location_desc":"PREBLE (NB)","county_code_state":"NY","county_code":"023","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-03-25 21:31:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2688908","transaction_code":"A","transaction_date":"2022-03-25 00:00:00","upload_date":"2022-03-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00378821","upload_search_indicator":"M","census_search_date":"2022-03-25 21:31:00","snet_input_date":"2022-03-25 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-03-25 21:31:00","insp_carrier_name":"BEAM MACK SALES & SERVICE INC","insp_carrier_street":"2674 W HENRIETTA RD","insp_carrier_city":"ROCHESTER","insp_carrier_state":"NY","insp_carrier_zip_code":"14623-2328","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:28:23.000000Z","updated_at":"2025-03-17T18:28:23.000000Z","inspection_violations":[],"inspection_per_units":[{"id":65339,"change_date":"2022-03-25 21:31:00","inspection_id":"75137043","insp_unit_id":"187816385","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"5363","insp_unit_license":"44015MN","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"JHHSDM2H2KK008676","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:40.000000Z","updated_at":"2025-03-17T22:08:40.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/378821\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/378821\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/378821\/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\/378821\/inspections","per_page":100,"prev_page_url":null,"to":52,"total":52}