{"current_page":1,"data":[{"id":10821276,"change_date":"2026-01-21 21:37:00","inspection_id":"86848788","dot_number":"1145370","report_state":"NY","report_number":"D304300947","insp_date":"2026-01-14 00:00:00","insp_start_time":"1030","insp_end_time":"1122","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"SYRACUSE NY","county_code_state":"NY","county_code":"067","insp_level_id":"5","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-01-21 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"22500","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":"2792838","transaction_code":"A","transaction_date":"2026-01-20 00:00:00","upload_date":"2026-01-21 00:00:00","upload_first_byte":"0","upload_dot_number":"01145370","upload_search_indicator":null,"census_search_date":"2026-01-21 21:37:00","snet_input_date":"2026-01-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-01-21 21:37:00","insp_carrier_name":"MICHAEL MCCONNELL CONCRETE INC","insp_carrier_street":"3600 WALTERS ROAD","insp_carrier_city":"SYRACUSE","insp_carrier_state":"NY","insp_carrier_zip_code":"13209","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-01-24T10:36:43.000000Z","updated_at":"2026-02-01T10:30:08.000000Z","inspection_violations":[],"inspection_per_units":[{"id":18173329,"change_date":"2026-01-21 21:37:00","inspection_id":"86848788","insp_unit_id":"211201183","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"GREEN DUMP","insp_unit_license":"24177NG","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTKTSWM4MH497621","insp_unit_decal":"Y","insp_unit_decal_number":"36049113","created_at":"2026-01-24T10:08:32.000000Z","updated_at":"2026-02-01T10:02:25.000000Z"}]},{"id":10821568,"change_date":"2026-06-02 21:41:00","inspection_id":"86849104","dot_number":"1145370","report_state":"NY","report_number":"D304300946","insp_date":"2026-01-14 00:00:00","insp_start_time":"0950","insp_end_time":"1041","registration_date":"2026-06-01 00:00:00","region":"ES","ci_status_code":"C","location":null,"location_desc":"SYRACUSE NY","county_code_state":"NY","county_code":"067","insp_level_id":"5","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-01-21 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","viol_total":"6","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2793505","transaction_code":"C","transaction_date":"2026-01-20 00:00:00","upload_date":"2026-06-02 00:00:00","upload_first_byte":"0","upload_dot_number":"01145370","upload_search_indicator":null,"census_search_date":"2026-01-21 21:37:00","snet_input_date":"2026-01-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-01-21 21:37:00","insp_carrier_name":"MICHAEL MCCONNELL CONCRETE INC","insp_carrier_street":"3600 WALTERS ROAD","insp_carrier_city":"SYRACUSE","insp_carrier_state":"NY","insp_carrier_zip_code":"13209","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-01-24T10:36:44.000000Z","updated_at":"2026-06-13T09:30:12.000000Z","inspection_violations":[{"id":18090770,"change_date":"2026-06-02 21:41:00","inspection_id":"86849104","insp_violation_id":"274640335","seq_no":"5","part_no":"393","part_no_section":"9A-LSLI","insp_viol_unit":"1","insp_unit_id":"213868860","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-24T10:42:51.000000Z","updated_at":"2026-06-13T09:43:02.000000Z","normalized_code":"3939ALSLI"},{"id":18090766,"change_date":"2026-06-02 21:41:00","inspection_id":"86849104","insp_violation_id":"274640331","seq_no":"1","part_no":"393","part_no_section":"207A-SUBL","insp_viol_unit":"1","insp_unit_id":"213868860","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-01-24T10:42:51.000000Z","updated_at":"2026-06-13T09:43:02.000000Z","normalized_code":"393207ASUBL"},{"id":18090767,"change_date":"2026-06-02 21:41:00","inspection_id":"86849104","insp_violation_id":"274640332","seq_no":"2","part_no":"393","part_no_section":"9A-LSML","insp_viol_unit":"1","insp_unit_id":"213868860","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-24T10:42:51.000000Z","updated_at":"2026-06-13T09:43:02.000000Z","normalized_code":"3939ALSML"},{"id":18090768,"change_date":"2026-06-02 21:41:00","inspection_id":"86849104","insp_violation_id":"274640333","seq_no":"3","part_no":"393","part_no_section":"9A-LCL","insp_viol_unit":"1","insp_unit_id":"213868860","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-24T10:42:51.000000Z","updated_at":"2026-06-13T09:43:02.000000Z","normalized_code":"3939ALCL"},{"id":18090769,"change_date":"2026-06-02 21:41:00","inspection_id":"86849104","insp_violation_id":"274640334","seq_no":"4","part_no":"393","part_no_section":"9A-LHWS","insp_viol_unit":"1","insp_unit_id":"213868860","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-24T10:42:51.000000Z","updated_at":"2026-06-13T09:43:02.000000Z","normalized_code":"3939ALHWS"},{"id":18090771,"change_date":"2026-06-02 21:41:00","inspection_id":"86849104","insp_violation_id":"274640336","seq_no":"6","part_no":"392","part_no_section":"2-SLLMF","insp_viol_unit":"1","insp_unit_id":"213868860","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-24T10:42:51.000000Z","updated_at":"2026-06-13T09:43:02.000000Z","normalized_code":"3922SLLMF"}],"inspection_per_units":[{"id":18173813,"change_date":"2026-06-02 21:41:00","inspection_id":"86849104","insp_unit_id":"213868860","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEVROLET","insp_unit_company":"RED DUMP","insp_unit_license":"51154MK","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1GBJ7C1317F412207","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-24T10:08:32.000000Z","updated_at":"2026-06-13T09:01:02.000000Z"}]},{"id":9893704,"change_date":"2025-10-09 21:40:00","inspection_id":"85997760","dot_number":"1145370","report_state":"NY","report_number":"SPT3100986","insp_date":"2025-10-02 00:00:00","insp_start_time":"0958","insp_end_time":"1013","registration_date":null,"region":"ED","ci_status_code":"C","location":"20854M","location_desc":"VERONA NY","county_code_state":"NY","county_code":"065","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-10-09 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"19996","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2384291","transaction_code":"A","transaction_date":"2025-10-08 00:00:00","upload_date":"2025-10-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01145370","upload_search_indicator":null,"census_search_date":"2025-10-09 21:40:00","snet_input_date":"2025-10-02 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-10-09 21:40:00","insp_carrier_name":"MICHAEL MCCONNELL CONCRETE INC","insp_carrier_street":"3600 WALTERS ROAD","insp_carrier_city":"SYRACUSE","insp_carrier_state":"NY","insp_carrier_zip_code":"13209","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-10-12T10:01:48.000000Z","updated_at":"2025-10-13T10:00:26.000000Z","inspection_violations":[{"id":16319068,"change_date":"2025-10-09 21:40:00","inspection_id":"85997760","insp_violation_id":"269192159","seq_no":"1","part_no":"391","part_no_section":"41APC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-12T10:17:17.000000Z","updated_at":"2025-10-13T10:15:41.000000Z","normalized_code":"39141APC"},{"id":16319069,"change_date":"2025-10-09 21:40:00","inspection_id":"85997760","insp_violation_id":"269192160","seq_no":"2","part_no":"392","part_no_section":"2-SLLIFTA","insp_viol_unit":"1","insp_unit_id":"209375188","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-12T10:17:17.000000Z","updated_at":"2025-10-13T10:15:41.000000Z","normalized_code":"3922SLLIFTA"}],"inspection_per_units":[{"id":16416972,"change_date":"2025-10-09 21:40:00","inspection_id":"85997760","insp_unit_id":"209375188","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"71104NE","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1FT7W2BTXDEA24475","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-12T09:47:07.000000Z","updated_at":"2025-10-13T09:45:23.000000Z"},{"id":16416973,"change_date":"2025-10-09 21:40:00","inspection_id":"85997760","insp_unit_id":"209375189","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CROSS COUN","insp_unit_company":null,"insp_unit_license":"BG65678","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"431FS1629B1000106","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-12T09:47:07.000000Z","updated_at":"2025-10-13T09:45:24.000000Z"}]},{"id":9198914,"change_date":"2026-06-02 21:41:00","inspection_id":"85267942","dot_number":"1145370","report_state":"NY","report_number":"SPD3031159","insp_date":"2025-07-14 00:00:00","insp_start_time":"1605","insp_end_time":"1623","registration_date":"2026-06-01 00:00:00","region":"ED","ci_status_code":"C","location":null,"location_desc":"FULTON NY","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":"U","pen_cen_match":"I","final_status_date":"2025-07-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"18000","viol_total":"6","oos_total":"3","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"5","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2018381","transaction_code":"C","transaction_date":"2025-07-20 00:00:00","upload_date":"2026-06-02 00:00:00","upload_first_byte":"0","upload_dot_number":"01145370","upload_search_indicator":null,"census_search_date":"2025-07-21 21:40:00","snet_input_date":"2025-07-14 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-07-21 21:40:00","insp_carrier_name":"MICHAEL MCCONNELL CONCRETE INC","insp_carrier_street":"3600 WALTERS ROAD","insp_carrier_city":"SYRACUSE","insp_carrier_state":"NY","insp_carrier_zip_code":"13209","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-07-25T10:45:14.000000Z","updated_at":"2026-06-13T09:30:12.000000Z","inspection_violations":[{"id":14863607,"change_date":"2026-06-02 21:41:00","inspection_id":"85267942","insp_violation_id":"274640713","seq_no":"6","part_no":"391","part_no_section":"41APC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-25T10:46:34.000000Z","updated_at":"2026-06-13T09:43:02.000000Z","normalized_code":"39141APC"},{"id":14863602,"change_date":"2026-06-02 21:41:00","inspection_id":"85267942","insp_violation_id":"274640708","seq_no":"1","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"213869000","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-25T10:46:34.000000Z","updated_at":"2026-06-13T09:43:02.000000Z","normalized_code":"39617CPI"},{"id":14863603,"change_date":"2026-06-02 21:41:00","inspection_id":"85267942","insp_violation_id":"274640709","seq_no":"2","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"213868999","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-25T10:46:34.000000Z","updated_at":"2026-06-13T09:43:02.000000Z","normalized_code":"3922SLLSR"},{"id":14863604,"change_date":"2026-06-02 21:41:00","inspection_id":"85267942","insp_violation_id":"274640710","seq_no":"3","part_no":"393","part_no_section":"41-BNPB","insp_viol_unit":"1","insp_unit_id":"213868999","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-07-25T10:46:34.000000Z","updated_at":"2026-06-13T09:43:02.000000Z","normalized_code":"39341BNPB"},{"id":14863605,"change_date":"2026-06-02 21:41:00","inspection_id":"85267942","insp_violation_id":"274640711","seq_no":"4","part_no":"393","part_no_section":"42A-BM","insp_viol_unit":"2","insp_unit_id":"213869000","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-25T10:46:34.000000Z","updated_at":"2026-06-13T09:43:02.000000Z","normalized_code":"39342ABM"},{"id":14863606,"change_date":"2026-06-02 21:41:00","inspection_id":"85267942","insp_violation_id":"274640712","seq_no":"5","part_no":"396","part_no_section":"3A1-BOS","insp_viol_unit":"2","insp_unit_id":"213869000","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-07-25T10:46:34.000000Z","updated_at":"2026-06-13T09:43:02.000000Z","normalized_code":"3963A1BOS"}],"inspection_per_units":[{"id":15120138,"change_date":"2026-06-02 21:41:00","inspection_id":"85267942","insp_unit_id":"213868999","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODGE","insp_unit_company":null,"insp_unit_license":"74846MJ","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3D7KR28AX7G839379","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-24T09:45:24.000000Z","updated_at":"2026-06-13T09:01:02.000000Z"},{"id":15120139,"change_date":"2026-06-02 21:41:00","inspection_id":"85267942","insp_unit_id":"213869000","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"ELIMI","insp_unit_company":null,"insp_unit_license":"BU48088","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1U91117252S047946","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-24T09:45:24.000000Z","updated_at":"2026-06-13T09:01:02.000000Z"}]},{"id":8198241,"change_date":"2026-06-02 21:41:00","inspection_id":"84212406","dot_number":"1145370","report_state":"NY","report_number":"D305501490","insp_date":"2025-03-21 00:00:00","insp_start_time":"0808","insp_end_time":"0853","registration_date":"2026-06-01 00:00:00","region":"ED","ci_status_code":"C","location":null,"location_desc":"SYRACUSE NY","county_code_state":"NY","county_code":"067","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"MICHAEL MCCONNELL CONCRETE INC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":"N","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-25 12:44:00","post_acc_ind":"N","gross_comb_veh_wt":"19995","viol_total":"10","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"10","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1509361","transaction_code":"C","transaction_date":"2025-03-25 00:00:00","upload_date":"2026-06-02 00:00:00","upload_first_byte":"0","upload_dot_number":"01145370","upload_search_indicator":null,"census_search_date":"2025-03-25 12:44:00","snet_input_date":"2025-03-21 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-03-25 12:44:00","insp_carrier_name":"MICHAEL MCCONNELL CONCRETE INC","insp_carrier_street":"3600 WALTERS ROAD","insp_carrier_city":"SYRACUSE","insp_carrier_state":"NY","insp_carrier_zip_code":"13209","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-28T10:14:39.000000Z","updated_at":"2026-06-13T09:30:12.000000Z","inspection_violations":[{"id":12854913,"change_date":"2026-06-02 21:41:00","inspection_id":"84212406","insp_violation_id":"274639789","seq_no":"8","part_no":"393","part_no_section":"95A1","insp_viol_unit":"1","insp_unit_id":"213868546","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-28T10:29:20.000000Z","updated_at":"2026-06-13T09:42:57.000000Z","normalized_code":"39395A1"},{"id":12854914,"change_date":"2026-06-02 21:41:00","inspection_id":"84212406","insp_violation_id":"274639790","seq_no":"9","part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"2","insp_unit_id":"213868547","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-28T10:29:20.000000Z","updated_at":"2026-06-13T09:42:57.000000Z","normalized_code":"3939ALLPL"},{"id":12854911,"change_date":"2026-06-02 21:41:00","inspection_id":"84212406","insp_violation_id":"274639782","seq_no":"1","part_no":"393","part_no_section":"48A-BIHE","insp_viol_unit":"2","insp_unit_id":"213868547","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-28T10:29:20.000000Z","updated_at":"2026-06-13T09:42:57.000000Z","normalized_code":"39348ABIHE"},{"id":12854910,"change_date":"2026-06-02 21:41:00","inspection_id":"84212406","insp_violation_id":"274639787","seq_no":"6","part_no":"390","part_no_section":"21TB2-DOT","insp_viol_unit":"1","insp_unit_id":"213868546","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-28T10:29:20.000000Z","updated_at":"2026-06-13T09:42:57.000000Z","normalized_code":"39021TB2DOT"},{"id":12854912,"change_date":"2026-06-02 21:41:00","inspection_id":"84212406","insp_violation_id":"274639788","seq_no":"7","part_no":"393","part_no_section":"11A1-LIL","insp_viol_unit":"2","insp_unit_id":"213868547","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-28T10:29:20.000000Z","updated_at":"2026-06-13T09:42:57.000000Z","normalized_code":"39311A1LIL"},{"id":12854915,"change_date":"2026-06-02 21:41:00","inspection_id":"84212406","insp_violation_id":"274639783","seq_no":"2","part_no":"393","part_no_section":"43D-B","insp_viol_unit":"2","insp_unit_id":"213868547","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-28T10:29:20.000000Z","updated_at":"2026-06-13T09:42:57.000000Z","normalized_code":"39343DB"},{"id":12854916,"change_date":"2026-06-02 21:41:00","inspection_id":"84212406","insp_violation_id":"274639784","seq_no":"3","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"213868546","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-28T10:29:20.000000Z","updated_at":"2026-06-13T09:42:57.000000Z","normalized_code":"39395F"},{"id":12854917,"change_date":"2026-06-02 21:41:00","inspection_id":"84212406","insp_violation_id":"274639785","seq_no":"4","part_no":"393","part_no_section":"9A-LSML","insp_viol_unit":"2","insp_unit_id":"213868547","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-28T10:29:20.000000Z","updated_at":"2026-06-13T09:42:57.000000Z","normalized_code":"3939ALSML"},{"id":12854918,"change_date":"2026-06-02 21:41:00","inspection_id":"84212406","insp_violation_id":"274639786","seq_no":"5","part_no":"390","part_no_section":"21TB1-MC","insp_viol_unit":"1","insp_unit_id":"213868546","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-28T10:29:20.000000Z","updated_at":"2026-06-13T09:42:57.000000Z","normalized_code":"39021TB1MC"},{"id":12854919,"change_date":"2026-06-02 21:41:00","inspection_id":"84212406","insp_violation_id":"274639791","seq_no":"10","part_no":"396","part_no_section":"3A1-BOS","insp_viol_unit":"2","insp_unit_id":"213868547","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-28T10:29:20.000000Z","updated_at":"2026-06-13T09:42:57.000000Z","normalized_code":"3963A1BOS"}],"inspection_per_units":[{"id":13254360,"change_date":"2026-06-02 21:41:00","inspection_id":"84212406","insp_unit_id":"213868547","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":null,"insp_unit_license":"BG65678","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"431FS1629B1000106","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-28T10:01:36.000000Z","updated_at":"2026-06-13T09:01:02.000000Z"},{"id":13254359,"change_date":"2026-06-02 21:41:00","inspection_id":"84212406","insp_unit_id":"213868546","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODGE","insp_unit_company":null,"insp_unit_license":"89181ML","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3C6UR5CL5JG327265","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-28T10:01:36.000000Z","updated_at":"2026-06-13T09:01:02.000000Z"}]},{"id":7258170,"change_date":"2024-11-22 21:40:00","inspection_id":"83224280","dot_number":"1145370","report_state":"NY","report_number":"D305400522","insp_date":"2024-11-20 00:00:00","insp_start_time":"1105","insp_end_time":"1121","registration_date":null,"region":"ES","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":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-11-22 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1082962","transaction_code":"A","transaction_date":"2024-11-22 00:00:00","upload_date":"2024-11-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01145370","upload_search_indicator":null,"census_search_date":"2024-11-22 21:40:00","snet_input_date":"2024-11-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-11-22 21:40:00","insp_carrier_name":"MICHAEL MCCONNELL CONCRETE INC","insp_carrier_street":"3600 WALTERS ROAD","insp_carrier_city":"SYRACUSE","insp_carrier_state":"NY","insp_carrier_zip_code":"13209","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:47:19.000000Z","updated_at":"2025-03-17T20:47:19.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11707414,"change_date":"2024-11-22 21:40:00","inspection_id":"83224280","insp_unit_id":"204008451","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":null,"insp_unit_license":"66607NA","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1HTMKAZR4CH564455","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:44:20.000000Z","updated_at":"2025-03-17T23:44:20.000000Z"}]},{"id":7163474,"change_date":"2024-11-11 21:33:00","inspection_id":"83124119","dot_number":"1145370","report_state":"NY","report_number":"SPD4050030","insp_date":"2024-11-04 00:00:00","insp_start_time":"1314","insp_end_time":"1337","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"GEDDES NY","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":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-11-11 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"14000","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":"1040340","transaction_code":"A","transaction_date":"2024-11-11 00:00:00","upload_date":"2024-11-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01145370","upload_search_indicator":null,"census_search_date":"2024-11-11 21:33:00","snet_input_date":"2024-11-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-11-11 21:33:00","insp_carrier_name":"MICHAEL MCCONNELL CONCRETE INC","insp_carrier_street":"3600 WALTERS ROAD","insp_carrier_city":"SYRACUSE","insp_carrier_state":"NY","insp_carrier_zip_code":"13209","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:45:32.000000Z","updated_at":"2025-03-17T20:45:32.000000Z","inspection_violations":[{"id":11191078,"change_date":"2024-11-11 21:33:00","inspection_id":"83124119","insp_violation_id":"262825049","seq_no":"1","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"203820153","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:18.000000Z","updated_at":"2025-03-17T22:00:18.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":11554222,"change_date":"2024-11-11 21:33:00","inspection_id":"83124119","insp_unit_id":"203820153","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEVROLET","insp_unit_company":null,"insp_unit_license":"10658JC","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1GBJC34U27E152146","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:42:43.000000Z","updated_at":"2025-03-17T23:42:43.000000Z"}]},{"id":6642738,"change_date":"2024-09-04 21:41:00","inspection_id":"82570725","dot_number":"1145370","report_state":"NY","report_number":"SPT0442624","insp_date":"2024-09-03 00:00:00","insp_start_time":"0740","insp_end_time":"0848","registration_date":null,"region":"ET","ci_status_code":"C","location":"40504A","location_desc":"MANCHESTER","county_code_state":"NY","county_code":"069","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-09-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"20536","viol_total":"10","oos_total":"5","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"8","vehicle_oos_total":"4","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2948563","transaction_code":"A","transaction_date":"2024-09-04 00:00:00","upload_date":"2024-09-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01145370","upload_search_indicator":"M","census_search_date":"2024-09-04 21:41:00","snet_input_date":"2024-09-04 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-09-04 21:41:00","insp_carrier_name":"MICHAEL MCCONNELL CONCRETE INC","insp_carrier_street":"3600 WALTERS ROAD","insp_carrier_city":"SYRACUSE","insp_carrier_state":"NY","insp_carrier_zip_code":"13209","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:34:49.000000Z","updated_at":"2025-03-17T20:34:49.000000Z","inspection_violations":[{"id":10335657,"change_date":"2024-09-04 21:41:00","inspection_id":"82570725","insp_violation_id":"261600396","seq_no":"1","part_no":"391","part_no_section":"11(b)(5)","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:56:02.000000Z","updated_at":"2025-03-17T21:56:02.000000Z","normalized_code":"39111B5"},{"id":10335658,"change_date":"2024-09-04 21:41:00","inspection_id":"82570725","insp_violation_id":"261600397","seq_no":"2","part_no":"391","part_no_section":"41(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:02.000000Z","updated_at":"2025-03-17T21:56:02.000000Z","normalized_code":"39141A1"},{"id":10335659,"change_date":"2024-09-04 21:41:00","inspection_id":"82570725","insp_violation_id":"261600398","seq_no":"3","part_no":"390","part_no_section":"21(b)","insp_viol_unit":"1","insp_unit_id":"202747890","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:02.000000Z","updated_at":"2025-03-17T21:56:02.000000Z","normalized_code":"39021B"},{"id":10335660,"change_date":"2024-09-04 21:41:00","inspection_id":"82570725","insp_violation_id":"261600399","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"202747890","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:02.000000Z","updated_at":"2025-03-17T21:56:02.000000Z","normalized_code":"3922"},{"id":10335661,"change_date":"2024-09-04 21:41:00","inspection_id":"82570725","insp_violation_id":"261600400","seq_no":"5","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"202747890","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"0JFRX6C","created_at":"2025-03-17T21:56:02.000000Z","updated_at":"2025-03-17T21:56:02.000000Z","normalized_code":"39395A"},{"id":10335662,"change_date":"2024-09-04 21:41:00","inspection_id":"82570725","insp_violation_id":"261600401","seq_no":"6","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"202747890","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:02.000000Z","updated_at":"2025-03-17T21:56:02.000000Z","normalized_code":"39395F"},{"id":10335663,"change_date":"2024-09-04 21:41:00","inspection_id":"82570725","insp_violation_id":"261600402","seq_no":"7","part_no":"393","part_no_section":"128","insp_viol_unit":"2","insp_unit_id":"202747891","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:56:02.000000Z","updated_at":"2025-03-17T21:56:02.000000Z","normalized_code":"393128"},{"id":10335664,"change_date":"2024-09-04 21:41:00","inspection_id":"82570725","insp_violation_id":"261600403","seq_no":"8","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"202747891","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"0JFRXFX","created_at":"2025-03-17T21:56:02.000000Z","updated_at":"2025-03-17T21:56:02.000000Z","normalized_code":"39311"},{"id":10335665,"change_date":"2024-09-04 21:41:00","inspection_id":"82570725","insp_violation_id":"261600404","seq_no":"9","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"202747891","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:56:02.000000Z","updated_at":"2025-03-17T21:56:02.000000Z","normalized_code":"3939A"},{"id":10335666,"change_date":"2024-09-04 21:41:00","inspection_id":"82570725","insp_violation_id":"261600405","seq_no":"10","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"202747891","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:56:02.000000Z","updated_at":"2025-03-17T21:56:02.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":10709683,"change_date":"2024-09-04 21:41:00","inspection_id":"82570725","insp_unit_id":"202747890","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"91920MH","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1GB3CZCL5BF180613","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:33:53.000000Z","updated_at":"2025-03-17T23:33:53.000000Z"},{"id":10709684,"change_date":"2024-09-04 21:41:00","inspection_id":"82570725","insp_unit_id":"202747891","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"BG65678","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"431FS1629B1000106","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:33:53.000000Z","updated_at":"2025-03-17T23:33:53.000000Z"}]},{"id":1759488,"change_date":"2022-11-17 21:39:00","inspection_id":"77156617","dot_number":"1145370","report_state":"NY","report_number":"SPB0361305","insp_date":"2022-11-01 00:00:00","insp_start_time":"1440","insp_end_time":"1531","registration_date":null,"region":"ET","ci_status_code":"C","location":"30382A","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":"2022-11-17 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"19996","viol_total":"13","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"13","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2770302","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":"01145370","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":"MICHAEL MCCONNELL CONCRETE INC","insp_carrier_street":"3600 WALTERS ROAD","insp_carrier_city":"SYRACUSE","insp_carrier_state":"NY","insp_carrier_zip_code":"13209","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:58:59.000000Z","updated_at":"2025-03-17T18:58:59.000000Z","inspection_violations":[{"id":2755552,"change_date":"2022-11-17 21:39:00","inspection_id":"77156617","insp_violation_id":"249650874","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"192000974","insp_violation_category_id":"29","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":"39617C"},{"id":2755553,"change_date":"2022-11-17 21:39:00","inspection_id":"77156617","insp_violation_id":"249650875","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"192000974","insp_violation_category_id":"14","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":2755554,"change_date":"2022-11-17 21:39:00","inspection_id":"77156617","insp_violation_id":"249650876","seq_no":"3","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"192000974","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"3G2FS3","created_at":"2025-03-17T21:19:57.000000Z","updated_at":"2025-03-17T21:19:57.000000Z","normalized_code":"39395A"},{"id":2755555,"change_date":"2022-11-17 21:39:00","inspection_id":"77156617","insp_violation_id":"249650877","seq_no":"4","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"192000974","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"3G24FXW","created_at":"2025-03-17T21:19:57.000000Z","updated_at":"2025-03-17T21:19:57.000000Z","normalized_code":"39395F"},{"id":2755556,"change_date":"2022-11-17 21:39:00","inspection_id":"77156617","insp_violation_id":"249650878","seq_no":"5","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"192000975","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:19:57.000000Z","updated_at":"2025-03-17T21:19:57.000000Z","normalized_code":"39348A"},{"id":2755557,"change_date":"2022-11-17 21:39:00","inspection_id":"77156617","insp_violation_id":"249650879","seq_no":"6","part_no":"392","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"192000975","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:19:57.000000Z","updated_at":"2025-03-17T21:19:57.000000Z","normalized_code":"3929A"},{"id":2755558,"change_date":"2022-11-17 21:39:00","inspection_id":"77156617","insp_violation_id":"249650880","seq_no":"7","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"2","insp_unit_id":"192000975","insp_violation_category_id":"23","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":"39375C"},{"id":2755559,"change_date":"2022-11-17 21:39:00","inspection_id":"77156617","insp_violation_id":"249650881","seq_no":"8","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"192000975","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:19:57.000000Z","updated_at":"2025-03-17T21:19:57.000000Z","normalized_code":"3939A"},{"id":2755560,"change_date":"2022-11-17 21:39:00","inspection_id":"77156617","insp_violation_id":"249650882","seq_no":"9","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"192000975","insp_violation_category_id":"20","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":"3939A"},{"id":2755561,"change_date":"2022-11-17 21:39:00","inspection_id":"77156617","insp_violation_id":"249650883","seq_no":"10","part_no":"393","part_no_section":"19","insp_viol_unit":"2","insp_unit_id":"192000975","insp_violation_category_id":"20","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":"39319"},{"id":2755562,"change_date":"2022-11-17 21:39:00","inspection_id":"77156617","insp_violation_id":"249650884","seq_no":"11","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"192000975","insp_violation_category_id":"20","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":"3939A"},{"id":2755563,"change_date":"2022-11-17 21:39:00","inspection_id":"77156617","insp_violation_id":"249650885","seq_no":"12","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"192000975","insp_violation_category_id":"20","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":"3939A"},{"id":2755564,"change_date":"2022-11-17 21:39:00","inspection_id":"77156617","insp_violation_id":"249650886","seq_no":"13","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"192000975","insp_violation_category_id":"20","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":"3939A"}],"inspection_per_units":[{"id":2830607,"change_date":"2022-11-17 21:39:00","inspection_id":"77156617","insp_unit_id":"192000974","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":null,"insp_unit_license":"95650MM","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"3C6UR5DL3GG367769","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":2830608,"change_date":"2022-11-17 21:39:00","inspection_id":"77156617","insp_unit_id":"192000975","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":null,"insp_unit_company":null,"insp_unit_license":"BG65678","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"431FS1629B1000106","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":1280563,"change_date":"2022-09-14 21:39:00","inspection_id":"76603540","dot_number":"1145370","report_state":"NY","report_number":"SPWD041469","insp_date":"2022-09-13 00:00:00","insp_start_time":"1013","insp_end_time":"1057","registration_date":null,"region":"ET","ci_status_code":"C","location":"30317","location_desc":"GEDDES","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-09-14 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"23996","viol_total":"9","oos_total":"4","driver_viol_total":"2","driver_oos_total":"2","vehicle_viol_total":"7","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2748372","transaction_code":"A","transaction_date":"2022-09-14 00:00:00","upload_date":"2022-09-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01145370","upload_search_indicator":"M","census_search_date":"2022-09-14 21:39:00","snet_input_date":"2022-09-14 00:00:00","source_office":"1NYS001","mcmis_add_date":"2022-09-14 21:39:00","insp_carrier_name":"MICHAEL MCCONNELL CONCRETE INC","insp_carrier_street":"3600 WALTERS ROAD","insp_carrier_city":"SYRACUSE","insp_carrier_state":"NY","insp_carrier_zip_code":"13209","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:50:25.000000Z","updated_at":"2025-03-17T18:50:25.000000Z","inspection_violations":[{"id":2026676,"change_date":"2022-09-14 21:39:00","inspection_id":"76603540","insp_violation_id":"248398311","seq_no":"1","part_no":"391","part_no_section":"15(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"8","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"4FVW0R5","created_at":"2025-03-17T21:16:19.000000Z","updated_at":"2025-03-17T21:16:19.000000Z","normalized_code":"39115A"},{"id":2026677,"change_date":"2022-09-14 21:39:00","inspection_id":"76603540","insp_violation_id":"248398312","seq_no":"2","part_no":"391","part_no_section":"11(b)(4)","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:16:19.000000Z","updated_at":"2025-03-17T21:16:19.000000Z","normalized_code":"39111B4"},{"id":2026678,"change_date":"2022-09-14 21:39:00","inspection_id":"76603540","insp_violation_id":"248398313","seq_no":"3","part_no":"390","part_no_section":"21(b)","insp_viol_unit":"1","insp_unit_id":"190885816","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:19.000000Z","updated_at":"2025-03-17T21:16:19.000000Z","normalized_code":"39021B"},{"id":2026679,"change_date":"2022-09-14 21:39:00","inspection_id":"76603540","insp_violation_id":"248398314","seq_no":"4","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"1","insp_unit_id":"190885816","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:16:19.000000Z","updated_at":"2025-03-17T21:16:19.000000Z","normalized_code":"39375C"},{"id":2026680,"change_date":"2022-09-14 21:39:00","inspection_id":"76603540","insp_violation_id":"248398315","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"190885816","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:19.000000Z","updated_at":"2025-03-17T21:16:19.000000Z","normalized_code":"3939A"},{"id":2026681,"change_date":"2022-09-14 21:39:00","inspection_id":"76603540","insp_violation_id":"248398316","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"190885816","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:19.000000Z","updated_at":"2025-03-17T21:16:19.000000Z","normalized_code":"3939A"},{"id":2026682,"change_date":"2022-09-14 21:39:00","inspection_id":"76603540","insp_violation_id":"248398317","seq_no":"7","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"190885816","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:19.000000Z","updated_at":"2025-03-17T21:16:19.000000Z","normalized_code":"39395A"},{"id":2026683,"change_date":"2022-09-14 21:39:00","inspection_id":"76603540","insp_violation_id":"248398318","seq_no":"8","part_no":"393","part_no_section":"100(a)","insp_viol_unit":"2","insp_unit_id":"190885817","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:16:19.000000Z","updated_at":"2025-03-17T21:16:19.000000Z","normalized_code":"393100A"},{"id":2026684,"change_date":"2022-09-14 21:39:00","inspection_id":"76603540","insp_violation_id":"248398319","seq_no":"9","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"190885817","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"4FVW1M9","created_at":"2025-03-17T21:16:19.000000Z","updated_at":"2025-03-17T21:16:19.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":2060857,"change_date":"2022-09-14 21:39:00","inspection_id":"76603540","insp_unit_id":"190885817","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"BE21124","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"431FS1624D1000176","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:09.000000Z","updated_at":"2025-03-17T22:21:09.000000Z"},{"id":2060856,"change_date":"2022-09-14 21:39:00","inspection_id":"76603540","insp_unit_id":"190885816","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"78061MD","insp_unit_license_state":"NY","insp_unit_vehicle_id_number":"1GCJC39284E265856","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:09.000000Z","updated_at":"2025-03-17T22:21:09.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/1145370\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/1145370\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1145370\/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\/1145370\/inspections","per_page":100,"prev_page_url":null,"to":10,"total":10}