{"current_page":1,"data":[{"id":12174280,"change_date":"2026-06-12 21:41:00","inspection_id":"88129067","dot_number":"1670762","report_state":"MI","report_number":"MYERD01769","insp_date":"2026-06-12 00:00:00","insp_start_time":"1200","insp_end_time":"1227","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"MI","county_code_state":"MI","county_code":"093","insp_level_id":"2","service_center":"MW","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":"2026-06-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"224220","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":"3531249","transaction_code":"A","transaction_date":"2026-06-12 00:00:00","upload_date":"2026-06-12 00:00:00","upload_first_byte":"0","upload_dot_number":"01670762","upload_search_indicator":null,"census_search_date":"2026-06-12 21:41:00","snet_input_date":"2026-06-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-12 21:41:00","insp_carrier_name":"LW CONNELLY AND SON INC","insp_carrier_street":"12635 MARION ST","insp_carrier_city":"REDFORD","insp_carrier_state":"MI","insp_carrier_zip_code":"48239-2652","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-06-16T09:43:37.000000Z","updated_at":"2026-06-23T09:31:11.000000Z","inspection_violations":[{"id":21187023,"change_date":"2026-06-12 21:41:00","inspection_id":"88129067","insp_violation_id":"274878257","seq_no":"1","part_no":"392","part_no_section":"9A-DFSL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"55","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-16T10:06:17.000000Z","updated_at":"2026-06-23T09:42:43.000000Z","normalized_code":"3929ADFSL"}],"inspection_per_units":[{"id":21146504,"change_date":"2026-06-12 21:41:00","inspection_id":"88129067","insp_unit_id":"214074772","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"31","insp_unit_license":"BD68262","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPCP4EX7SD739947","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-16T09:20:44.000000Z","updated_at":"2026-06-23T09:02:59.000000Z"},{"id":21146505,"change_date":"2026-06-12 21:41:00","inspection_id":"88129067","insp_unit_id":"214074773","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TALB","insp_unit_company":null,"insp_unit_license":"F435865","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"40FS05741T1045152","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-16T09:20:44.000000Z","updated_at":"2026-06-23T09:02:59.000000Z"}]},{"id":11793959,"change_date":"2026-04-30 21:41:00","inspection_id":"87726775","dot_number":"1670762","report_state":"MI","report_number":"JURKV03368","insp_date":"2026-04-29 00:00:00","insp_start_time":"0825","insp_end_time":"0855","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"ROAD","county_code_state":"MI","county_code":"145","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"226151715802","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-04-30 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"62000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1268359","transaction_code":"A","transaction_date":"2026-04-29 00:00:00","upload_date":"2026-04-30 00:00:00","upload_first_byte":"0","upload_dot_number":"01670762","upload_search_indicator":null,"census_search_date":"2026-04-30 21:41:00","snet_input_date":"2026-04-29 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-04-30 21:41:00","insp_carrier_name":"LW CONNELLY AND SON INC","insp_carrier_street":"12635 MARION ST","insp_carrier_city":"REDFORD","insp_carrier_state":"MI","insp_carrier_zip_code":"48239","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-05-03T09:40:58.000000Z","updated_at":"2026-05-11T09:31:25.000000Z","inspection_violations":[{"id":20508083,"change_date":"2026-04-30 21:41:00","inspection_id":"87726775","insp_violation_id":"273965233","seq_no":"1","part_no":"392","part_no_section":"2-SLL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-03T10:01:56.000000Z","updated_at":"2026-05-11T09:42:25.000000Z","normalized_code":"3922SLL"}],"inspection_per_units":[{"id":20516069,"change_date":"2026-04-30 21:41:00","inspection_id":"87726775","insp_unit_id":"213317629","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GROVE","insp_unit_company":"160","insp_unit_license":"(NONE)","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"224764","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-03T09:17:57.000000Z","updated_at":"2026-05-11T09:03:57.000000Z"}]},{"id":10557064,"change_date":"2026-01-02 21:35:00","inspection_id":"86694228","dot_number":"1670762","report_state":"MI","report_number":"DELMT02425","insp_date":"2025-12-30 00:00:00","insp_start_time":"1450","insp_end_time":"1510","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"E\/B I94 NEAR HAWKINS RD.","county_code_state":"MI","county_code":"075","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAC","shipping_paper_number":"125150432202","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":"2026-01-02 21:35:00","post_acc_ind":"N","gross_comb_veh_wt":"172000","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":"1254962","transaction_code":"A","transaction_date":"2025-12-30 00:00:00","upload_date":"2026-01-02 00:00:00","upload_first_byte":"0","upload_dot_number":"01670762","upload_search_indicator":null,"census_search_date":"2026-01-02 21:35:00","snet_input_date":"2025-12-30 00:00:00","source_office":"3MIS001","mcmis_add_date":"2026-01-02 21:35:00","insp_carrier_name":"LW CONNELLY AND SON INC","insp_carrier_street":"12635 MARION ST","insp_carrier_city":"REDFORD","insp_carrier_state":"MI","insp_carrier_zip_code":"48239","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2026-01-05T10:33:37.000000Z","updated_at":"2026-01-13T10:30:26.000000Z","inspection_violations":[{"id":17731086,"change_date":"2026-01-02 21:35:00","inspection_id":"86694228","insp_violation_id":"270986205","seq_no":"1","part_no":"393","part_no_section":"45D-B","insp_viol_unit":"1","insp_unit_id":"210886872","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-05T10:37:06.000000Z","updated_at":"2026-01-13T10:30:52.000000Z","normalized_code":"39345DB"},{"id":17731087,"change_date":"2026-01-02 21:35:00","inspection_id":"86694228","insp_violation_id":"270986206","seq_no":"2","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"2","insp_unit_id":"210886873","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-05T10:37:06.000000Z","updated_at":"2026-01-13T10:30:52.000000Z","normalized_code":"3922SLLSR"}],"inspection_per_units":[{"id":17686984,"change_date":"2026-01-02 21:35:00","inspection_id":"86694228","insp_unit_id":"210886872","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"BD68262","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPCP4EX7SD739947","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-05T10:05:07.000000Z","updated_at":"2026-01-13T10:00:35.000000Z"},{"id":17686985,"change_date":"2026-01-02 21:35:00","inspection_id":"86694228","insp_unit_id":"210886873","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TALB","insp_unit_company":null,"insp_unit_license":"E105575","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"40FAK0509E1033438","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-05T10:05:07.000000Z","updated_at":"2026-01-13T10:00:35.000000Z"}]},{"id":9792901,"change_date":"2025-09-26 21:40:00","inspection_id":"85891905","dot_number":"1670762","report_state":"MI","report_number":"SHEPZ05347","insp_date":"2025-09-25 00:00:00","insp_start_time":"1135","insp_end_time":"1155","registration_date":null,"region":"ET","ci_status_code":"C","location":"131","location_desc":"GRASS LAKE SCALE E\/B","county_code_state":"MI","county_code":"075","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SAC","shipping_paper_number":"NONE","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":"2025-09-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"79500","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":"1243236","transaction_code":"A","transaction_date":"2025-09-25 00:00:00","upload_date":"2025-09-26 00:00:00","upload_first_byte":"0","upload_dot_number":"01670762","upload_search_indicator":null,"census_search_date":"2025-09-26 21:40:00","snet_input_date":"2025-09-25 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-09-26 21:40:00","insp_carrier_name":"LW CONNELLY AND SON INC","insp_carrier_street":"12635 MARION ST","insp_carrier_city":"REDFORD","insp_carrier_state":"MI","insp_carrier_zip_code":"48239","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-09-30T10:01:10.000000Z","updated_at":"2025-09-30T10:01:10.000000Z","inspection_violations":[{"id":16104843,"change_date":"2025-09-26 21:40:00","inspection_id":"85891905","insp_violation_id":"268952341","seq_no":"1","part_no":"393","part_no_section":"9A-LHLI","insp_viol_unit":"1","insp_unit_id":"209174076","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-30T10:16:52.000000Z","updated_at":"2025-09-30T10:16:52.000000Z","normalized_code":"3939ALHLI"}],"inspection_per_units":[{"id":16229540,"change_date":"2025-09-26 21:40:00","inspection_id":"85891905","insp_unit_id":"209174076","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"201","insp_unit_license":"BB92856","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NPSX7EX8KD613989","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-29T09:47:51.000000Z","updated_at":"2025-09-30T09:45:52.000000Z"}]},{"id":9177346,"change_date":"2025-07-17 21:42:00","inspection_id":"85245293","dot_number":"1670762","report_state":"MI","report_number":"DUBOL00115","insp_date":"2025-07-16 00:00:00","insp_start_time":"1750","insp_end_time":"1820","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"EB I-96 @ NOVI RD","county_code_state":"MI","county_code":"125","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S\/C","shipping_paper_number":"NONE","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":"2025-07-17 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"1230911","transaction_code":"A","transaction_date":"2025-07-16 00:00:00","upload_date":"2025-07-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01670762","upload_search_indicator":null,"census_search_date":"2025-07-17 21:42:00","snet_input_date":"2025-07-16 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-07-17 21:42:00","insp_carrier_name":"LW CONNELLY AND SON INC","insp_carrier_street":"12635 MARION ST","insp_carrier_city":"REDFORD","insp_carrier_state":"MI","insp_carrier_zip_code":"48239","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-07-21T10:43:18.000000Z","updated_at":"2025-07-21T10:43:18.000000Z","inspection_violations":[{"id":14820595,"change_date":"2025-07-17 21:42:00","inspection_id":"85245293","insp_violation_id":"267474035","seq_no":"1","part_no":"393","part_no_section":"11B-CSLRR","insp_viol_unit":"1","insp_unit_id":"207930590","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-21T10:45:43.000000Z","updated_at":"2025-07-21T10:45:43.000000Z","normalized_code":"39311BCSLRR"}],"inspection_per_units":[{"id":15081041,"change_date":"2025-07-17 21:42:00","inspection_id":"85245293","insp_unit_id":"207930590","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"30","insp_unit_license":"BC62749","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPAD40X96N634740","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-20T09:46:31.000000Z","updated_at":"2025-07-21T09:46:05.000000Z"}]},{"id":9014635,"change_date":"2025-06-27 21:39:00","inspection_id":"85073983","dot_number":"1670762","report_state":"MI","report_number":"POWEL03930","insp_date":"2025-06-27 00:00:00","insp_start_time":"0840","insp_end_time":"0905","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"WB I-96 @ D-19","county_code_state":"MI","county_code":"093","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SAME","shipping_paper_number":"1","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":"2025-06-27 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1227770","transaction_code":"A","transaction_date":"2025-06-27 00:00:00","upload_date":"2025-06-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01670762","upload_search_indicator":null,"census_search_date":"2025-06-27 21:39:00","snet_input_date":"2025-06-27 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-06-27 21:39:00","insp_carrier_name":"LW CONNELLY AND SON INC","insp_carrier_street":"12635 MARION ST","insp_carrier_city":"REDFORD","insp_carrier_state":"MI","insp_carrier_zip_code":"48239","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-06-30T10:01:24.000000Z","updated_at":"2025-07-03T10:00:47.000000Z","inspection_violations":[{"id":14489741,"change_date":"2025-06-27 21:39:00","inspection_id":"85073983","insp_violation_id":"267095704","seq_no":"1","part_no":"392","part_no_section":"2-SLLSWZ","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-30T10:17:46.000000Z","updated_at":"2025-07-02T10:16:01.000000Z","normalized_code":"3922SLLSWZ"}],"inspection_per_units":[{"id":14784685,"change_date":"2025-06-27 21:39:00","inspection_id":"85073983","insp_unit_id":"207609334","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"30","insp_unit_license":"BC62749","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XPAD40X96N634740","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-01T09:47:39.000000Z","updated_at":"2025-07-01T09:49:51.000000Z"},{"id":14784686,"change_date":"2025-06-27 21:39:00","inspection_id":"85073983","insp_unit_id":"207609335","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MNTR","insp_unit_company":null,"insp_unit_license":"E034346","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2M51314691107905","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-01T09:47:39.000000Z","updated_at":"2025-07-01T09:49:51.000000Z"}]},{"id":7895160,"change_date":"2025-02-18 21:39:00","inspection_id":"83893854","dot_number":"1670762","report_state":"MI","report_number":"JURKV02901","insp_date":"2025-02-17 00:00:00","insp_start_time":"1035","insp_end_time":"1054","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"SAFE ENFORCEMENT SITE","county_code_state":"MI","county_code":"145","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"125141880602","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-02-18 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"131000","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":"1210272","transaction_code":"A","transaction_date":"2025-02-17 00:00:00","upload_date":"2025-02-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01670762","upload_search_indicator":null,"census_search_date":"2025-02-18 21:39:00","snet_input_date":"2025-02-17 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-02-18 21:39:00","insp_carrier_name":"LW CONNELLY AND SON INC","insp_carrier_street":"12635 MARION ST","insp_carrier_city":"REDFORD","insp_carrier_state":"MI","insp_carrier_zip_code":"48239","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T21:02:01.000000Z","updated_at":"2025-03-17T21:02:01.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12743924,"change_date":"2025-02-18 21:39:00","inspection_id":"83893854","insp_unit_id":"205373001","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"GROVE","insp_unit_company":"167","insp_unit_license":"(NONE)","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5130-2166","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:55:47.000000Z","updated_at":"2025-03-17T23:55:47.000000Z"}]},{"id":6632043,"change_date":"2024-09-17 21:45:00","inspection_id":"82559449","dot_number":"1670762","report_state":"MI","report_number":"JURKV02745","insp_date":"2024-08-28 00:00:00","insp_start_time":"0950","insp_end_time":"1056","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"BAY CITY REST AREA","county_code_state":"MI","county_code":"017","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"124137365502","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-03 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"144000","viol_total":"7","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1192833","transaction_code":"C","transaction_date":"2024-08-28 00:00:00","upload_date":"2024-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01670762","upload_search_indicator":null,"census_search_date":"2024-09-03 21:42:00","snet_input_date":"2024-08-28 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-09-03 21:42:00","insp_carrier_name":"LW CONNELLY AND SON INC","insp_carrier_street":"12635 MARION ST","insp_carrier_city":"REDFORD","insp_carrier_state":"MI","insp_carrier_zip_code":"48239","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:34:28.000000Z","updated_at":"2025-03-17T20:34:28.000000Z","inspection_violations":[{"id":10315607,"change_date":"2024-09-17 21:45:00","inspection_id":"82559449","insp_violation_id":"261865345","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"202980086","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:57.000000Z","updated_at":"2025-03-17T21:55:57.000000Z","normalized_code":"3922"},{"id":10315608,"change_date":"2024-09-17 21:45:00","inspection_id":"82559449","insp_violation_id":"261865346","seq_no":"2","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"202980086","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:57.000000Z","updated_at":"2025-03-17T21:55:57.000000Z","normalized_code":"39347E"},{"id":10315609,"change_date":"2024-09-17 21:45:00","inspection_id":"82559449","insp_violation_id":"261865347","seq_no":"3","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"202980086","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:57.000000Z","updated_at":"2025-03-17T21:55:57.000000Z","normalized_code":"39353B"},{"id":10315610,"change_date":"2024-09-17 21:45:00","inspection_id":"82559449","insp_violation_id":"261865348","seq_no":"4","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"202980086","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:57.000000Z","updated_at":"2025-03-17T21:55:57.000000Z","normalized_code":"39347E"},{"id":10315611,"change_date":"2024-09-17 21:45:00","inspection_id":"82559449","insp_violation_id":"261865349","seq_no":"5","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"202980086","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:57.000000Z","updated_at":"2025-03-17T21:55:57.000000Z","normalized_code":"39347E"},{"id":10315612,"change_date":"2024-09-17 21:45:00","inspection_id":"82559449","insp_violation_id":"261865350","seq_no":"6","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"202980086","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:57.000000Z","updated_at":"2025-03-17T21:55:57.000000Z","normalized_code":"39345D"},{"id":10315613,"change_date":"2024-09-17 21:45:00","inspection_id":"82559449","insp_violation_id":"261865351","seq_no":"7","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"202980086","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"X4421094","created_at":"2025-03-17T21:55:57.000000Z","updated_at":"2025-03-17T21:55:57.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":10692449,"change_date":"2024-09-17 21:45:00","inspection_id":"82559449","insp_unit_id":"202980086","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"TM1","insp_unit_license":"BD38049","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2XKDDB0X4TM941445","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:33:44.000000Z","updated_at":"2025-03-17T23:33:44.000000Z"},{"id":10692450,"change_date":"2024-09-17 21:45:00","inspection_id":"82559449","insp_unit_id":"202980087","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"DORS","insp_unit_company":null,"insp_unit_license":"F050820","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"7KYD5321MED30258","insp_unit_decal":"Y","insp_unit_decal_number":"34301395","created_at":"2025-03-17T23:33:44.000000Z","updated_at":"2025-03-17T23:33:44.000000Z"}]},{"id":5511674,"change_date":"2024-04-15 21:41:00","inspection_id":"81351746","dot_number":"1670762","report_state":"MI","report_number":"DETGT04682","insp_date":"2024-04-12 00:00:00","insp_start_time":"1455","insp_end_time":"1522","registration_date":null,"region":"ET","ci_status_code":"C","location":"131","location_desc":"GRASS LAKE SCALE E\/B","county_code_state":"MI","county_code":"075","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"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-04-15 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"86000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1173552","transaction_code":"A","transaction_date":"2024-04-12 00:00:00","upload_date":"2024-04-15 00:00:00","upload_first_byte":"0","upload_dot_number":"01670762","upload_search_indicator":null,"census_search_date":"2024-04-15 21:41:00","snet_input_date":"2024-04-12 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-04-15 21:41:00","insp_carrier_name":"LW CONNELLY AND SON INC","insp_carrier_street":"12635 MARION ST","insp_carrier_city":"REDFORD","insp_carrier_state":"MI","insp_carrier_zip_code":"48239","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T20:11:57.000000Z","updated_at":"2025-03-17T20:11:57.000000Z","inspection_violations":[{"id":8514537,"change_date":"2024-04-15 21:41:00","inspection_id":"81351746","insp_violation_id":"258931508","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:14.000000Z","updated_at":"2025-03-17T21:47:14.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8878248,"change_date":"2024-04-15 21:41:00","inspection_id":"81351746","insp_unit_id":"200397732","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"25","insp_unit_license":"BD40400","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKDDB0X86R139445","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:15:35.000000Z","updated_at":"2025-03-17T23:15:35.000000Z"},{"id":8878249,"change_date":"2024-04-15 21:41:00","inspection_id":"81351746","insp_unit_id":"200397733","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TALB","insp_unit_company":"TM1","insp_unit_license":"E105575","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"40FAK0509E1033438","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:15:35.000000Z","updated_at":"2025-03-17T23:15:35.000000Z"}]},{"id":4284225,"change_date":"2023-10-25 21:42:00","inspection_id":"80007776","dot_number":"1670762","report_state":"MI","report_number":"POWEL03358","insp_date":"2023-10-24 00:00:00","insp_start_time":"0750","insp_end_time":"0823","registration_date":null,"region":"ET","ci_status_code":"C","location":"122","location_desc":"FOWLERVILLE SCALE W\/B","county_code_state":"MI","county_code":"093","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SAME","shipping_paper_number":"223123234202","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-10-25 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"72000","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":"1150847","transaction_code":"A","transaction_date":"2023-10-24 00:00:00","upload_date":"2023-10-25 00:00:00","upload_first_byte":"0","upload_dot_number":"01670762","upload_search_indicator":null,"census_search_date":"2023-10-25 21:42:00","snet_input_date":"2023-10-24 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-10-25 21:42:00","insp_carrier_name":"LW CONNELLY AND SON INC","insp_carrier_street":"12635 MARION ST","insp_carrier_city":"REDFORD","insp_carrier_state":"MI","insp_carrier_zip_code":"48239","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:47:50.000000Z","updated_at":"2025-03-17T19:47:50.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6890146,"change_date":"2023-10-25 21:42:00","inspection_id":"80007776","insp_unit_id":"197745780","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"201","insp_unit_license":"BB92856","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1NPSX7EX8KD613989","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:57:47.000000Z","updated_at":"2025-03-17T22:57:47.000000Z"}]},{"id":3365303,"change_date":"2023-06-26 21:41:00","inspection_id":"78982757","dot_number":"1670762","report_state":"MI","report_number":"POWEL03209","insp_date":"2023-06-24 00:00:00","insp_start_time":"0730","insp_end_time":"0800","registration_date":null,"region":"ET","ci_status_code":"C","location":"122","location_desc":"FOWLERVILLE SCALE W\/B","county_code_state":"MI","county_code":"093","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SAME","shipping_paper_number":"1","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-06-26 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"118200","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1132104","transaction_code":"A","transaction_date":"2023-06-24 00:00:00","upload_date":"2023-06-26 00:00:00","upload_first_byte":"0","upload_dot_number":"01670762","upload_search_indicator":null,"census_search_date":"2023-06-26 21:41:00","snet_input_date":"2023-06-24 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-06-26 21:41:00","insp_carrier_name":"LW CONNELLY AND SON INC","insp_carrier_street":"12635 MARION ST","insp_carrier_city":"REDFORD","insp_carrier_state":"MI","insp_carrier_zip_code":"48239","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:29:44.000000Z","updated_at":"2025-03-17T19:29:44.000000Z","inspection_violations":[{"id":5188797,"change_date":"2023-06-26 21:41:00","inspection_id":"78982757","insp_violation_id":"253699591","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:05.000000Z","updated_at":"2025-03-17T21:31:05.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5409727,"change_date":"2023-06-26 21:41:00","inspection_id":"78982757","insp_unit_id":"195674461","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"52","insp_unit_license":"BD02528","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKDDB0X3TJ725738","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:45:40.000000Z","updated_at":"2025-03-17T22:45:40.000000Z"},{"id":5409728,"change_date":"2023-06-26 21:41:00","inspection_id":"78982757","insp_unit_id":"195674462","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MNTR","insp_unit_company":"S2","insp_unit_license":"E034346","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2M513146911079057","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:45:40.000000Z","updated_at":"2025-03-17T22:45:40.000000Z"}]},{"id":3248631,"change_date":"2023-06-09 21:40:00","inspection_id":"78851134","dot_number":"1670762","report_state":"MI","report_number":"POWEL03184","insp_date":"2023-06-08 00:00:00","insp_start_time":"1320","insp_end_time":"1340","registration_date":null,"region":"ET","ci_status_code":"C","location":"122","location_desc":"FOWLERVILLE SCALE W\/B","county_code_state":"MI","county_code":"093","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SAME","shipping_paper_number":"223123234702","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-06-09 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"133200","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":"1129933","transaction_code":"A","transaction_date":"2023-06-08 00:00:00","upload_date":"2023-06-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01670762","upload_search_indicator":null,"census_search_date":"2023-06-09 21:40:00","snet_input_date":"2023-06-08 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-06-09 21:40:00","insp_carrier_name":"LW CONNELLY AND SON INC","insp_carrier_street":"12635 MARION ST","insp_carrier_city":"REDFORD","insp_carrier_state":"MI","insp_carrier_zip_code":"48239","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:27:20.000000Z","updated_at":"2025-03-17T19:27:20.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5224850,"change_date":"2023-06-09 21:40:00","inspection_id":"78851134","insp_unit_id":"195416625","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"25","insp_unit_license":"BD40400","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKDDB0X86R139445","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:10.000000Z","updated_at":"2025-03-17T22:44:10.000000Z"},{"id":5224851,"change_date":"2023-06-09 21:40:00","inspection_id":"78851134","insp_unit_id":"195416626","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TALB","insp_unit_company":"QTT","insp_unit_license":"E105575","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"40FAK0509E1033438","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:44:10.000000Z","updated_at":"2025-03-17T22:44:10.000000Z"}]},{"id":3166655,"change_date":"2023-06-01 21:42:00","inspection_id":"78758627","dot_number":"1670762","report_state":"MI","report_number":"DELMT00547","insp_date":"2023-05-25 00:00:00","insp_start_time":"1705","insp_end_time":"1835","registration_date":null,"region":"ET","ci_status_code":"C","location":"131","location_desc":"GRASS LAKE SCALE E\/B","county_code_state":"MI","county_code":"075","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SAC","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-05-30 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"8","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1128182","transaction_code":"C","transaction_date":"2023-05-31 00:00:00","upload_date":"2023-06-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01670762","upload_search_indicator":null,"census_search_date":"2023-05-30 21:42:00","snet_input_date":"2023-05-25 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-05-30 21:42:00","insp_carrier_name":"LW CONNELLY AND SON INC","insp_carrier_street":"12635 MARION ST","insp_carrier_city":"REDFORD","insp_carrier_state":"MI","insp_carrier_zip_code":"48239","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:25:43.000000Z","updated_at":"2025-03-17T19:25:43.000000Z","inspection_violations":[{"id":4877165,"change_date":"2023-06-01 21:42:00","inspection_id":"78758627","insp_violation_id":"253214252","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:40.000000Z","updated_at":"2025-03-17T21:29:40.000000Z","normalized_code":"3922"},{"id":4877166,"change_date":"2023-06-01 21:42:00","inspection_id":"78758627","insp_violation_id":"253214253","seq_no":"2","part_no":"393","part_no_section":"207(f)","insp_viol_unit":"2","insp_unit_id":"195260734","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"X4211997","created_at":"2025-03-17T21:29:40.000000Z","updated_at":"2025-03-17T21:29:40.000000Z","normalized_code":"393207F"},{"id":4877167,"change_date":"2023-06-01 21:42:00","inspection_id":"78758627","insp_violation_id":"253214254","seq_no":"3","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"195260733","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:40.000000Z","updated_at":"2025-03-17T21:29:40.000000Z","normalized_code":"39347E"},{"id":4877168,"change_date":"2023-06-01 21:42:00","inspection_id":"78758627","insp_violation_id":"253214255","seq_no":"4","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"195260733","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:40.000000Z","updated_at":"2025-03-17T21:29:40.000000Z","normalized_code":"39345B2"},{"id":4877169,"change_date":"2023-06-01 21:42:00","inspection_id":"78758627","insp_violation_id":"253214256","seq_no":"5","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"1","insp_unit_id":"195260733","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:40.000000Z","updated_at":"2025-03-17T21:29:40.000000Z","normalized_code":"39348A"},{"id":4877170,"change_date":"2023-06-01 21:42:00","inspection_id":"78758627","insp_violation_id":"253214257","seq_no":"6","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"195260733","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:40.000000Z","updated_at":"2025-03-17T21:29:40.000000Z","normalized_code":"39353B"},{"id":4877171,"change_date":"2023-06-01 21:42:00","inspection_id":"78758627","insp_violation_id":"253214258","seq_no":"7","part_no":"393","part_no_section":"201(a)","insp_viol_unit":"1","insp_unit_id":"195260733","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:40.000000Z","updated_at":"2025-03-17T21:29:40.000000Z","normalized_code":"393201A"},{"id":4877172,"change_date":"2023-06-01 21:42:00","inspection_id":"78758627","insp_violation_id":"253214259","seq_no":"8","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"195260733","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:40.000000Z","updated_at":"2025-03-17T21:29:40.000000Z","normalized_code":"39311"}],"inspection_per_units":[{"id":5093382,"change_date":"2023-06-01 21:42:00","inspection_id":"78758627","insp_unit_id":"195260733","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"19","insp_unit_license":"BD02527","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKDD60X9XJ799484","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:43:08.000000Z","updated_at":"2025-03-17T22:43:08.000000Z"},{"id":5093383,"change_date":"2023-06-01 21:42:00","inspection_id":"78758627","insp_unit_id":"195260734","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MNTR","insp_unit_company":"2","insp_unit_license":"E034346","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"2M513146911079057","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:43:08.000000Z","updated_at":"2025-03-17T22:43:08.000000Z"}]},{"id":3107298,"change_date":"2023-05-22 21:41:00","inspection_id":"78691533","dot_number":"1670762","report_state":"MI","report_number":"STOCC04148","insp_date":"2023-05-22 00:00:00","insp_start_time":"0850","insp_end_time":"0945","registration_date":null,"region":"ET","ci_status_code":"C","location":"132","location_desc":"GRASS LAKE SCALE W\/B","county_code_state":"MI","county_code":"075","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"LW CONNELLY AND SON INC","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-05-22 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"159000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1127269","transaction_code":"A","transaction_date":"2023-05-22 00:00:00","upload_date":"2023-05-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01670762","upload_search_indicator":null,"census_search_date":"2023-05-22 21:41:00","snet_input_date":"2023-05-22 00:00:00","source_office":"3MIS001","mcmis_add_date":"2023-05-22 21:41:00","insp_carrier_name":"LW CONNELLY AND SON INC","insp_carrier_street":"12635 MARION ST","insp_carrier_city":"REDFORD","insp_carrier_state":"MI","insp_carrier_zip_code":"48239","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T19:24:34.000000Z","updated_at":"2025-03-17T19:24:34.000000Z","inspection_violations":[{"id":4779607,"change_date":"2023-05-22 21:41:00","inspection_id":"78691533","insp_violation_id":"252988946","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:13.000000Z","updated_at":"2025-03-17T21:29:13.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4997912,"change_date":"2023-05-22 21:41:00","inspection_id":"78691533","insp_unit_id":"195067469","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"12","insp_unit_license":"BD02525","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKDDB0X7XR815336","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:24.000000Z","updated_at":"2025-03-17T22:42:24.000000Z"},{"id":4997913,"change_date":"2023-05-22 21:41:00","inspection_id":"78691533","insp_unit_id":"195067470","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MNTR","insp_unit_company":null,"insp_unit_license":"D457621","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5MC185014H3165126","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:24.000000Z","updated_at":"2025-03-17T22:42:24.000000Z"}]},{"id":1807199,"change_date":"2022-11-23 21:40:00","inspection_id":"77211589","dot_number":"1670762","report_state":"MI","report_number":"FRIZS02621","insp_date":"2022-11-22 00:00:00","insp_start_time":"1126","insp_end_time":"1307","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-75 S\/B @ CLIO REST AREA","county_code_state":"MI","county_code":"049","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"S \/ C","shipping_paper_number":"NONE","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-23 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"154000","viol_total":"5","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1102881","transaction_code":"A","transaction_date":"2022-11-22 00:00:00","upload_date":"2022-11-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01670762","upload_search_indicator":null,"census_search_date":"2022-11-23 21:40:00","snet_input_date":"2022-11-22 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-11-23 21:40:00","insp_carrier_name":"LW CONNELLY AND SON INC","insp_carrier_street":"12635 MARION ST","insp_carrier_city":"REDFORD","insp_carrier_state":"MI","insp_carrier_zip_code":"48239","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:59:58.000000Z","updated_at":"2025-03-17T18:59:58.000000Z","inspection_violations":[{"id":2825898,"change_date":"2022-11-23 21:40:00","inspection_id":"77211589","insp_violation_id":"249768911","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:25.000000Z","updated_at":"2025-03-17T21:20:25.000000Z","normalized_code":"3922"},{"id":2825899,"change_date":"2022-11-23 21:40:00","inspection_id":"77211589","insp_violation_id":"249768912","seq_no":"2","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"2","insp_unit_id":"192111096","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:25.000000Z","updated_at":"2025-03-17T21:20:25.000000Z","normalized_code":"39395F"},{"id":2825900,"change_date":"2022-11-23 21:40:00","inspection_id":"77211589","insp_violation_id":"249768913","seq_no":"3","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"2","insp_unit_id":"192111096","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:25.000000Z","updated_at":"2025-03-17T21:20:25.000000Z","normalized_code":"3965B"},{"id":2825901,"change_date":"2022-11-23 21:40:00","inspection_id":"77211589","insp_violation_id":"249768914","seq_no":"4","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"2","insp_unit_id":"192111096","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:25.000000Z","updated_at":"2025-03-17T21:20:25.000000Z","normalized_code":"39345D"},{"id":2825902,"change_date":"2022-11-23 21:40:00","inspection_id":"77211589","insp_violation_id":"249768915","seq_no":"5","part_no":"393","part_no_section":"130(b)","insp_viol_unit":"2","insp_unit_id":"192111096","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"X4145355","created_at":"2025-03-17T21:20:25.000000Z","updated_at":"2025-03-17T21:20:25.000000Z","normalized_code":"393130B"}],"inspection_per_units":[{"id":2907043,"change_date":"2022-11-23 21:40:00","inspection_id":"77211589","insp_unit_id":"192111095","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"25","insp_unit_license":"AC75366","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1XKDDB0X86R139445","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:54.000000Z","updated_at":"2025-03-17T22:26:54.000000Z"},{"id":2907044,"change_date":"2022-11-23 21:40:00","inspection_id":"77211589","insp_unit_id":"192111096","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TALB","insp_unit_company":null,"insp_unit_license":"E105575","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"40FAK0509E1033438","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:54.000000Z","updated_at":"2025-03-17T22:26:54.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/1670762\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/1670762\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1670762\/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\/1670762\/inspections","per_page":100,"prev_page_url":null,"to":15,"total":15}