{"current_page":1,"data":[{"id":12774146,"change_date":"2026-08-20 21:48:00","inspection_id":"88746807","dot_number":"2117252","report_state":"KY","report_number":"CV44961058","insp_date":"2026-08-20 00:00:00","insp_start_time":"0717","insp_end_time":"0804","registration_date":null,"region":"ES","ci_status_code":"C","location":"9809","location_desc":"GEORGETOWN KY","county_code_state":"KY","county_code":"209","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"UNIVERSAL PIPING","shipping_paper_number":"25890","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-08-20 21:48:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"2","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"4035046","transaction_code":"A","transaction_date":"2026-08-20 00:00:00","upload_date":"2026-08-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02117252","upload_search_indicator":null,"census_search_date":"2026-08-20 21:48:00","snet_input_date":"2026-08-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-08-20 21:48:00","insp_carrier_name":"UNIVERSAL PIPING INDUSTRIES LLC","insp_carrier_street":"5555 NEW KING DR","insp_carrier_city":"TROY","insp_carrier_state":"MI","insp_carrier_zip_code":"48098","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-08-23T09:39:14.000000Z","updated_at":"2026-08-28T09:34:11.000000Z","inspection_violations":[{"id":22237170,"change_date":"2026-08-20 21:48:00","inspection_id":"88746807","insp_violation_id":"276231268","seq_no":"2","part_no":"393","part_no_section":"43DBMA","insp_viol_unit":"2","insp_unit_id":"215244116","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-08-23T09:54:52.000000Z","updated_at":"2026-08-28T09:45:53.000000Z","normalized_code":"39343DBMA"},{"id":22237169,"change_date":"2026-08-20 21:48:00","inspection_id":"88746807","insp_violation_id":"276231267","seq_no":"1","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"2","insp_unit_id":"215244116","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-08-23T09:54:52.000000Z","updated_at":"2026-08-28T09:45:53.000000Z","normalized_code":"39375A3TAOL"}],"inspection_per_units":[{"id":22172039,"change_date":"2026-08-20 21:48:00","inspection_id":"88746807","insp_unit_id":"215244115","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"CHEVROLET","insp_unit_company":"182","insp_unit_license":"P7C906","insp_unit_license_state":"KY","insp_unit_vehicle_id_number":"1GB4KSEY8TF210812","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-08-23T09:15:16.000000Z","updated_at":"2026-08-28T09:08:02.000000Z"},{"id":22172040,"change_date":"2026-08-20 21:48:00","inspection_id":"88746807","insp_unit_id":"215244116","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIG TEX","insp_unit_company":"1","insp_unit_license":"E4W327","insp_unit_license_state":"KY","insp_unit_vehicle_id_number":"16V3F4824P6276542","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-08-23T09:15:16.000000Z","updated_at":"2026-08-28T09:08:02.000000Z"}]},{"id":10398414,"change_date":"2025-12-10 21:38:00","inspection_id":"86528553","dot_number":"2117252","report_state":"NC","report_number":"0006827577","insp_date":"2025-12-09 00:00:00","insp_start_time":"1056","insp_end_time":"1121","registration_date":null,"region":"ET","ci_status_code":"C","location":"MT. AI","location_desc":"MT. AIRY WEIGH STATION S","county_code_state":"NC","county_code":"171","insp_level_id":"1","service_center":"SH","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":"N","pen_cen_match":null,"final_status_date":"2025-12-10 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"2358285","transaction_code":"A","transaction_date":"2025-12-10 00:00:00","upload_date":"2025-12-10 00:00:00","upload_first_byte":"0","upload_dot_number":"02117252","upload_search_indicator":"M","census_search_date":"2025-12-10 21:38:00","snet_input_date":"2025-12-10 00:00:00","source_office":"2NCS001","mcmis_add_date":"2025-12-10 21:38:00","insp_carrier_name":"UNIVERSAL PIPING INDUSTRIES LLC","insp_carrier_street":"5555 NEW KING DR","insp_carrier_city":"TROY","insp_carrier_state":"MI","insp_carrier_zip_code":"48098","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-13T10:31:37.000000Z","updated_at":"2025-12-14T10:30:47.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17386167,"change_date":"2025-12-10 21:38:00","inspection_id":"86528553","insp_unit_id":"210524195","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"BD76011","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDNF6AN8RDF07831","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-13T10:01:49.000000Z","updated_at":"2025-12-14T10:01:05.000000Z"}]},{"id":10329545,"change_date":"2025-12-02 21:38:00","inspection_id":"86456517","dot_number":"2117252","report_state":"VA","report_number":"5985003600","insp_date":"2025-12-01 00:00:00","insp_start_time":"0926","insp_end_time":"0958","registration_date":null,"region":"ES","ci_status_code":"C","location":"BLASCS","location_desc":"BLAND VA","county_code_state":"VA","county_code":"021","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"SAME AS CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-12-02 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"37900","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":"2606005","transaction_code":"A","transaction_date":"2025-12-02 00:00:00","upload_date":"2025-12-02 00:00:00","upload_first_byte":"0","upload_dot_number":"02117252","upload_search_indicator":null,"census_search_date":"2025-12-02 21:38:00","snet_input_date":"2025-12-01 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-12-02 21:38:00","insp_carrier_name":"UNIVERSAL PIPING INDUSTRIES LLC","insp_carrier_street":"5555 NEW KING DR","insp_carrier_city":"TROY","insp_carrier_state":"MI","insp_carrier_zip_code":"48098","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-05T10:32:25.000000Z","updated_at":"2025-12-06T10:30:21.000000Z","inspection_violations":[{"id":17279176,"change_date":"2025-12-02 21:38:00","inspection_id":"86456517","insp_violation_id":"270388524","seq_no":"1","part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"2","insp_unit_id":"210351459","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-05T10:33:12.000000Z","updated_at":"2025-12-06T10:30:39.000000Z","normalized_code":"3939ALLPL"}],"inspection_per_units":[{"id":17251634,"change_date":"2025-12-02 21:38:00","inspection_id":"86456517","insp_unit_id":"210351458","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"CHEVROLET","insp_unit_company":"26DTDC","insp_unit_license":"BD23205","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GC4YSEY5NF313845","insp_unit_decal":"Y","insp_unit_decal_number":"35722854","created_at":"2025-12-05T10:02:49.000000Z","updated_at":"2025-12-06T10:00:22.000000Z"},{"id":17251635,"change_date":"2025-12-02 21:38:00","inspection_id":"86456517","insp_unit_id":"210351459","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIG TEX","insp_unit_company":"1","insp_unit_license":"E4W327","insp_unit_license_state":"KY","insp_unit_vehicle_id_number":"16V3F4824P6276542","insp_unit_decal":"Y","insp_unit_decal_number":"35722855","created_at":"2025-12-05T10:02:49.000000Z","updated_at":"2025-12-06T10:00:22.000000Z"}]},{"id":10277571,"change_date":"2025-12-02 21:38:00","inspection_id":"86402150","dot_number":"2117252","report_state":"KY","report_number":"CV41295768","insp_date":"2025-11-24 00:00:00","insp_start_time":"1213","insp_end_time":"1248","registration_date":"2025-12-02 00:00:00","region":"ET","ci_status_code":"C","location":"9801","location_desc":"SHELBYVILLE","county_code_state":"KY","county_code":"211","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"UNIVERSAL PIPING INDUSTRIES LLC","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":"2025-11-24 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"37200","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2318643","transaction_code":"C","transaction_date":"2025-11-24 00:00:00","upload_date":"2025-12-02 00:00:00","upload_first_byte":"0","upload_dot_number":"02117252","upload_search_indicator":"M","census_search_date":"2025-11-24 21:39:00","snet_input_date":"2025-11-24 00:00:00","source_office":"2KYS001","mcmis_add_date":"2025-11-24 21:39:00","insp_carrier_name":"UNIVERSAL PIPING INDUSTRIES LLC","insp_carrier_street":"5555 NEW KING DR","insp_carrier_city":"TROY","insp_carrier_state":"MI","insp_carrier_zip_code":"48098","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-27T10:30:46.000000Z","updated_at":"2025-12-06T10:30:08.000000Z","inspection_violations":[{"id":17276123,"change_date":"2025-12-02 21:38:00","inspection_id":"86402150","insp_violation_id":"270402389","seq_no":"1","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"2","insp_unit_id":"210361391","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-12-05T10:33:07.000000Z","updated_at":"2025-12-06T10:30:20.000000Z","normalized_code":"39375A3TAOL"}],"inspection_per_units":[{"id":17248873,"change_date":"2025-12-02 21:38:00","inspection_id":"86402150","insp_unit_id":"210361390","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"26DTDC","insp_unit_license":"BD23205","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GC4YSEY5NF313845","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-05T10:02:47.000000Z","updated_at":"2025-12-06T10:00:11.000000Z"},{"id":17248874,"change_date":"2025-12-02 21:38:00","inspection_id":"86402150","insp_unit_id":"210361391","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIGT","insp_unit_company":"2","insp_unit_license":"F7K104","insp_unit_license_state":"KY","insp_unit_vehicle_id_number":"16V3F4828P6282778","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-05T10:02:47.000000Z","updated_at":"2025-12-06T10:00:11.000000Z"}]},{"id":9770259,"change_date":"2025-09-24 21:42:00","inspection_id":"85868147","dot_number":"2117252","report_state":"MI","report_number":"CORBJ00285","insp_date":"2025-09-19 00:00:00","insp_start_time":"0950","insp_end_time":"1010","registration_date":null,"region":"ET","ci_status_code":"C","location":"ROAD","location_desc":"I-275SB @ ANN ARBOR RD","county_code_state":"MI","county_code":"163","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"N\/A","shipping_paper_number":"N\/A","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"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":"2025-09-24 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","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":"1242688","transaction_code":"A","transaction_date":"2025-09-19 00:00:00","upload_date":"2025-09-24 00:00:00","upload_first_byte":"0","upload_dot_number":"02117252","upload_search_indicator":null,"census_search_date":"2025-09-24 21:42:00","snet_input_date":"2025-09-19 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-09-24 21:42:00","insp_carrier_name":"UNIVERSAL PIPING INDUSTRIES LLC","insp_carrier_street":"5555 NEW KING DR","insp_carrier_city":"TROY","insp_carrier_state":"MI","insp_carrier_zip_code":"48098","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-26T10:01:16.000000Z","updated_at":"2025-09-28T10:00:41.000000Z","inspection_violations":[{"id":16058789,"change_date":"2025-09-24 21:42:00","inspection_id":"85868147","insp_violation_id":"268900107","seq_no":"1","part_no":"392","part_no_section":"2-SLLLR","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-09-27T10:17:06.000000Z","updated_at":"2025-09-28T10:16:07.000000Z","normalized_code":"3922SLLLR"}],"inspection_per_units":[{"id":16186176,"change_date":"2025-09-24 21:42:00","inspection_id":"85868147","insp_unit_id":"209126842","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"127","insp_unit_license":"H5K468","insp_unit_license_state":"KY","insp_unit_vehicle_id_number":"3ALACWFB2KDKR0697","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-27T09:46:24.000000Z","updated_at":"2025-09-29T09:46:10.000000Z"}]},{"id":9534207,"change_date":"2025-08-28 21:41:00","inspection_id":"85620754","dot_number":"2117252","report_state":"NC","report_number":"0006791366","insp_date":"2025-08-27 00:00:00","insp_start_time":"0840","insp_end_time":"0910","registration_date":null,"region":"ET","ci_status_code":"C","location":"ASHEVI","location_desc":"ASHEVILLE WEIGH STATION, I-40,","county_code_state":"NC","county_code":"021","insp_level_id":"1","service_center":"SH","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":"N","pen_cen_match":null,"final_status_date":"2025-08-28 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"37900","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":"2322857","transaction_code":"A","transaction_date":"2025-08-27 00:00:00","upload_date":"2025-08-28 00:00:00","upload_first_byte":"0","upload_dot_number":"02117252","upload_search_indicator":null,"census_search_date":"2025-08-28 21:41:00","snet_input_date":"2025-08-28 00:00:00","source_office":"2NCS001","mcmis_add_date":"2025-08-28 21:41:00","insp_carrier_name":"UNIVERSAL PIPING INDUSTRIES LLC","insp_carrier_street":"5555 NEW KING DR","insp_carrier_city":"TROY","insp_carrier_state":"MI","insp_carrier_zip_code":"48098","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-09-06T10:42:16.000000Z","updated_at":"2025-09-06T10:42:16.000000Z","inspection_violations":[{"id":18467778,"change_date":null,"inspection_id":"85620754","insp_violation_id":null,"seq_no":null,"part_no":"395","part_no_section":"8(k)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"99","out_of_service_indicator":"Y","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3958K2"}],"inspection_per_units":[{"id":15736408,"change_date":"2025-08-28 21:41:00","inspection_id":"85620754","insp_unit_id":"208636733","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"BD23205","insp_unit_license_state":"KY","insp_unit_vehicle_id_number":"1GC4YSEY5NF313845","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-09T09:46:38.000000Z","updated_at":"2025-09-09T09:46:38.000000Z"},{"id":15736409,"change_date":"2025-08-28 21:41:00","inspection_id":"85620754","insp_unit_id":"208636734","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIGT","insp_unit_company":null,"insp_unit_license":"F7K104","insp_unit_license_state":"KY","insp_unit_vehicle_id_number":"16V3F4828P6282778","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-09T09:46:38.000000Z","updated_at":"2025-09-09T09:46:38.000000Z"}]},{"id":9533347,"change_date":"2025-08-28 21:41:00","inspection_id":"85619808","dot_number":"2117252","report_state":"KY","report_number":"CV44720218","insp_date":"2025-08-27 00:00:00","insp_start_time":"1440","insp_end_time":"1530","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"NORTH CORBIN","county_code_state":"KY","county_code":"125","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"UNIVERSAL PIPING IND.","shipping_paper_number":"6486930","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":"2025-08-28 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"37900","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":"2299725","transaction_code":"A","transaction_date":"2025-08-28 00:00:00","upload_date":"2025-08-28 00:00:00","upload_first_byte":"0","upload_dot_number":"02117252","upload_search_indicator":"M","census_search_date":"2025-08-28 21:41:00","snet_input_date":"2025-08-28 00:00:00","source_office":"2KYS001","mcmis_add_date":"2025-08-28 21:41:00","insp_carrier_name":"UNIVERSAL PIPING INDUSTRIES LLC","insp_carrier_street":"5555 NEW KING DR","insp_carrier_city":"TROY","insp_carrier_state":"MI","insp_carrier_zip_code":"48098","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-06T10:42:15.000000Z","updated_at":"2025-09-06T10:42:15.000000Z","inspection_violations":[{"id":18467711,"change_date":null,"inspection_id":"85619808","insp_violation_id":null,"seq_no":null,"part_no":"392","part_no_section":"9B3-DFRCLS","insp_viol_unit":"2","insp_unit_id":"2","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:18:45.000000Z","updated_at":"2026-02-08T05:18:45.000000Z","normalized_code":"3929B3DFRCLS"}],"inspection_per_units":[{"id":15735005,"change_date":"2025-08-28 21:41:00","inspection_id":"85619808","insp_unit_id":"208634969","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"26DTDC","insp_unit_license":"BD23205","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GC4YSEY5NF313845","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-09T09:46:37.000000Z","updated_at":"2025-09-09T09:46:37.000000Z"},{"id":15735006,"change_date":"2025-08-28 21:41:00","inspection_id":"85619808","insp_unit_id":"208634970","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIGT","insp_unit_company":"2","insp_unit_license":"F7K104","insp_unit_license_state":"KY","insp_unit_vehicle_id_number":"16V3F4828P6282778","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-09T09:46:37.000000Z","updated_at":"2025-09-09T09:46:37.000000Z"}]},{"id":9389779,"change_date":"2025-08-14 21:40:00","inspection_id":"85468698","dot_number":"2117252","report_state":"KY","report_number":"CV44664874","insp_date":"2025-08-12 00:00:00","insp_start_time":"0839","insp_end_time":"0909","registration_date":"2025-08-14 00:00:00","region":"ET","ci_status_code":"C","location":"9811","location_desc":"LONDON","county_code_state":"KY","county_code":"125","insp_level_id":"1","service_center":"SH","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":"N","pen_cen_match":null,"final_status_date":"2025-08-12 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2296850","transaction_code":"C","transaction_date":"2025-08-12 00:00:00","upload_date":"2025-08-14 00:00:00","upload_first_byte":"0","upload_dot_number":"02117252","upload_search_indicator":"M","census_search_date":"2025-08-12 21:40:00","snet_input_date":"2025-08-12 00:00:00","source_office":"2KYS001","mcmis_add_date":"2025-08-12 21:40:00","insp_carrier_name":"UNIVERSAL PIPING INDUSTRIES LLC","insp_carrier_street":"5555 NEW KING DR","insp_carrier_city":"TROY","insp_carrier_state":"MI","insp_carrier_zip_code":"48098","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-15T10:43:48.000000Z","updated_at":"2025-08-20T10:43:45.000000Z","inspection_violations":[{"id":15306471,"change_date":"2025-08-14 21:40:00","inspection_id":"85468698","insp_violation_id":"268030622","seq_no":"1","part_no":"393","part_no_section":"47A","insp_viol_unit":"1","insp_unit_id":"208399295","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-08-17T10:45:12.000000Z","updated_at":"2025-08-18T10:43:38.000000Z","normalized_code":"39347A"}],"inspection_per_units":[{"id":15510573,"change_date":"2025-08-14 21:40:00","inspection_id":"85468698","insp_unit_id":"208399295","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"BD76011","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDNF6AN8RDF07831","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-17T09:46:23.000000Z","updated_at":"2025-08-18T09:45:33.000000Z"}]},{"id":8522395,"change_date":"2025-05-01 21:41:00","inspection_id":"84553907","dot_number":"2117252","report_state":"KY","report_number":"CV44791876","insp_date":"2025-05-01 00:00:00","insp_start_time":"0830","insp_end_time":"0906","registration_date":null,"region":"ET","ci_status_code":"C","location":"9811","location_desc":"LONDON","county_code_state":"KY","county_code":"125","insp_level_id":"1","service_center":"SH","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":"N","pen_cen_match":null,"final_status_date":"2025-05-01 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","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":"2281458","transaction_code":"A","transaction_date":"2025-05-01 00:00:00","upload_date":"2025-05-01 00:00:00","upload_first_byte":"0","upload_dot_number":"02117252","upload_search_indicator":"M","census_search_date":"2025-05-01 21:41:00","snet_input_date":"2025-05-01 00:00:00","source_office":"2KYS001","mcmis_add_date":"2025-05-01 21:41:00","insp_carrier_name":"UNIVERSAL PIPING INDUSTRIES LLC","insp_carrier_street":"5555 NEW KING DR","insp_carrier_city":"TROY","insp_carrier_state":"MI","insp_carrier_zip_code":"48098","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-04T10:34:58.000000Z","updated_at":"2025-05-05T10:12:57.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13856341,"change_date":"2025-05-01 21:41:00","inspection_id":"84553907","insp_unit_id":"206594245","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"BD76011","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDNF6AN8RDF07831","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-04T10:21:18.000000Z","updated_at":"2025-05-05T09:56:39.000000Z"}]},{"id":8055392,"change_date":"2025-03-07 21:39:00","inspection_id":"84061886","dot_number":"2117252","report_state":"KY","report_number":"CV42723022","insp_date":"2025-03-07 00:00:00","insp_start_time":"0945","insp_end_time":"1016","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"LONDON","county_code_state":"KY","county_code":"125","insp_level_id":"3","service_center":"SH","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":"2025-03-07 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"2272190","transaction_code":"A","transaction_date":"2025-03-07 00:00:00","upload_date":"2025-03-07 00:00:00","upload_first_byte":"0","upload_dot_number":"02117252","upload_search_indicator":null,"census_search_date":"2025-03-07 21:39:00","snet_input_date":"2025-03-07 00:00:00","source_office":"2KYS001","mcmis_add_date":"2025-03-07 21:39:00","insp_carrier_name":"UNIVERSAL PIPING INDUSTRIES LLC","insp_carrier_street":"5555 NEW KING DR","insp_carrier_city":"TROY","insp_carrier_state":"MI","insp_carrier_zip_code":"48098","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:05:26.000000Z","updated_at":"2025-03-17T21:05:26.000000Z","inspection_violations":[{"id":12590148,"change_date":"2025-03-07 21:39:00","inspection_id":"84061886","insp_violation_id":"264892896","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":"EX81763","created_at":"2025-03-17T22:07:37.000000Z","updated_at":"2025-03-17T22:07:37.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":13005397,"change_date":"2025-03-07 21:39:00","inspection_id":"84061886","insp_unit_id":"205681465","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"BD76011","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1FDNF6AN8RDF07831","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:58:42.000000Z","updated_at":"2025-03-17T23:58:42.000000Z"}]},{"id":7857004,"change_date":"2025-02-13 21:39:00","inspection_id":"83853804","dot_number":"2117252","report_state":"IN","report_number":"9761002967","insp_date":"2025-02-12 00:00:00","insp_start_time":"1212","insp_end_time":"1248","registration_date":null,"region":"ES","ci_status_code":"C","location":"2269S","location_desc":"WARREN IN","county_code_state":"IN","county_code":"069","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":"2025-02-13 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"37900","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":"1354801","transaction_code":"A","transaction_date":"2025-02-13 00:00:00","upload_date":"2025-02-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02117252","upload_search_indicator":null,"census_search_date":"2025-02-13 21:39:00","snet_input_date":"2025-02-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-02-13 21:39:00","insp_carrier_name":"UNIVERSAL PIPING INDUSTRIES LLC","insp_carrier_street":"5555 NEW KING DR","insp_carrier_city":"TROY","insp_carrier_state":"MI","insp_carrier_zip_code":"48098","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:01:14.000000Z","updated_at":"2025-03-17T21:01:14.000000Z","inspection_violations":[{"id":12280087,"change_date":"2025-02-13 21:39:00","inspection_id":"83853804","insp_violation_id":"264493562","seq_no":"1","part_no":"392","part_no_section":"2-SLLIRP","insp_viol_unit":"1","insp_unit_id":"205299003","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"204220903","created_at":"2025-03-17T22:05:58.000000Z","updated_at":"2025-03-17T22:05:58.000000Z","normalized_code":"3922SLLIRP"}],"inspection_per_units":[{"id":12680983,"change_date":"2025-02-13 21:39:00","inspection_id":"83853804","insp_unit_id":"205299003","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEVROLET","insp_unit_company":"147","insp_unit_license":"BD23205","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GC4YSEY5NF313845","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:55:05.000000Z","updated_at":"2025-03-17T23:55:05.000000Z"},{"id":12680984,"change_date":"2025-02-13 21:39:00","inspection_id":"83853804","insp_unit_id":"205299004","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIG TEX","insp_unit_company":"02","insp_unit_license":"F7K104","insp_unit_license_state":"KY","insp_unit_vehicle_id_number":"16V3F4828P6282778","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:55:05.000000Z","updated_at":"2025-03-17T23:55:05.000000Z"}]},{"id":6554786,"change_date":"2024-09-05 21:42:00","inspection_id":"82476950","dot_number":"2117252","report_state":"IN","report_number":"9761002481","insp_date":"2024-08-20 00:00:00","insp_start_time":"1029","insp_end_time":"1120","registration_date":null,"region":"ED","ci_status_code":"C","location":"2269S","location_desc":"WARREN IN","county_code_state":"IN","county_code":"069","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":"2024-08-25 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"37900","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"780288","transaction_code":"C","transaction_date":"2024-08-25 00:00:00","upload_date":"2024-09-05 00:00:00","upload_first_byte":"0","upload_dot_number":"02117252","upload_search_indicator":null,"census_search_date":"2024-08-25 21:33:00","snet_input_date":"2024-08-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-08-25 21:33:00","insp_carrier_name":"UNIVERSAL PIPING INDUSTRIES LLC","insp_carrier_street":"769 CHICAGO RD","insp_carrier_city":"TROY","insp_carrier_state":"MI","insp_carrier_zip_code":"48083","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:32:49.000000Z","updated_at":"2025-03-17T20:32:49.000000Z","inspection_violations":[{"id":10184938,"change_date":"2024-09-05 21:42:00","inspection_id":"82476950","insp_violation_id":"261625688","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"202769316","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"197253026","created_at":"2025-03-17T21:55:19.000000Z","updated_at":"2025-03-17T21:55:19.000000Z","normalized_code":"3922"},{"id":10184939,"change_date":"2024-09-05 21:42:00","inspection_id":"82476950","insp_violation_id":"261625689","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"202769316","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:19.000000Z","updated_at":"2025-03-17T21:55:19.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10566915,"change_date":"2024-09-05 21:42:00","inspection_id":"82476950","insp_unit_id":"202769316","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEVROLET","insp_unit_company":"147","insp_unit_license":"BD23205","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GC4YSEY5NF313845","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:32:28.000000Z","updated_at":"2025-03-17T23:32:28.000000Z"},{"id":10566916,"change_date":"2024-09-05 21:42:00","inspection_id":"82476950","insp_unit_id":"202769317","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIG TEX","insp_unit_company":"1","insp_unit_license":"E4W327","insp_unit_license_state":"KY","insp_unit_vehicle_id_number":"16V3F4824P6276542","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:32:28.000000Z","updated_at":"2025-03-17T23:32:28.000000Z"}]},{"id":6516328,"change_date":"2024-09-17 21:45:00","inspection_id":"82436055","dot_number":"2117252","report_state":"MI","report_number":"DETGT04855","insp_date":"2024-08-19 00:00:00","insp_start_time":"1215","insp_end_time":"1238","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":"3","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-08-20 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"1190719","transaction_code":"C","transaction_date":"2024-08-19 00:00:00","upload_date":"2024-09-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02117252","upload_search_indicator":null,"census_search_date":"2024-08-20 21:42:00","snet_input_date":"2024-08-19 00:00:00","source_office":"3MIS001","mcmis_add_date":"2024-08-20 21:42:00","insp_carrier_name":"UNIVERSAL PIPING INDUSTRIES LLC","insp_carrier_street":"769 CHICAGO RD","insp_carrier_city":"TROY","insp_carrier_state":"MI","insp_carrier_zip_code":"48083","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:32:00.000000Z","updated_at":"2025-03-17T20:32:00.000000Z","inspection_violations":[{"id":10120809,"change_date":"2024-09-17 21:45:00","inspection_id":"82436055","insp_violation_id":"261860993","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"X4421072","created_at":"2025-03-17T21:55:00.000000Z","updated_at":"2025-03-17T21:55:00.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10504675,"change_date":"2024-09-17 21:45:00","inspection_id":"82436055","insp_unit_id":"202977086","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"127","insp_unit_license":"H5K468","insp_unit_license_state":"KY","insp_unit_vehicle_id_number":"3ALACWFB2KDKR0697","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:31:48.000000Z","updated_at":"2025-03-17T23:31:48.000000Z"}]},{"id":4255105,"change_date":"2023-10-24 21:40:00","inspection_id":"79975362","dot_number":"2117252","report_state":"KY","report_number":"B915000135","insp_date":"2023-10-23 00:00:00","insp_start_time":"0400","insp_end_time":"0450","registration_date":"2023-10-24 00:00:00","region":"ET","ci_status_code":"C","location":null,"location_desc":"WALTON","county_code_state":"KY","county_code":"015","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"UNIVERSAL PIPING INDUSTRIES LLC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-10-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"2192107","transaction_code":"C","transaction_date":"2023-10-23 00:00:00","upload_date":"2023-10-24 00:00:00","upload_first_byte":"0","upload_dot_number":"02117252","upload_search_indicator":"M","census_search_date":"2023-10-23 21:41:00","snet_input_date":"2023-10-23 00:00:00","source_office":"2KYS001","mcmis_add_date":"2023-10-23 21:41:00","insp_carrier_name":"UNIVERSAL PIPING INDUSTRIES LLC","insp_carrier_street":"769 CHICAGO RD","insp_carrier_city":"TROY","insp_carrier_state":"MI","insp_carrier_zip_code":"48083","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:47:05.000000Z","updated_at":"2025-03-17T19:47:05.000000Z","inspection_violations":[{"id":6588578,"change_date":"2023-10-24 21:40:00","inspection_id":"79975362","insp_violation_id":"256009655","seq_no":"1","part_no":"395","part_no_section":"8(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:37:45.000000Z","updated_at":"2025-03-17T21:37:45.000000Z","normalized_code":"3958A1"}],"inspection_per_units":[{"id":6842811,"change_date":"2023-10-24 21:40:00","inspection_id":"79975362","insp_unit_id":"197716335","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"B2B005","insp_unit_license_state":"KY","insp_unit_vehicle_id_number":"3ALACWFB2KDKR0697","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:57:21.000000Z","updated_at":"2025-03-17T22:57:21.000000Z"}]},{"id":4192441,"change_date":"2023-10-16 21:42:00","inspection_id":"79906236","dot_number":"2117252","report_state":"KY","report_number":"CV44125419","insp_date":"2023-10-13 00:00:00","insp_start_time":"0857","insp_end_time":"0942","registration_date":"2023-10-13 00:00:00","region":"ET","ci_status_code":"C","location":"9810","location_desc":"PINER","county_code_state":"KY","county_code":"117","insp_level_id":"1","service_center":"SH","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":"N","pen_cen_match":null,"final_status_date":"2023-10-13 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"37900","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2191050","transaction_code":"C","transaction_date":"2023-10-13 00:00:00","upload_date":"2023-10-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02117252","upload_search_indicator":"M","census_search_date":"2023-10-13 21:40:00","snet_input_date":"2023-10-13 00:00:00","source_office":"2KYS001","mcmis_add_date":"2023-10-13 21:40:00","insp_carrier_name":"UNIVERSAL PIPING INDUSTRIES LLC","insp_carrier_street":"769 CHICAGO RD","insp_carrier_city":"TROY","insp_carrier_state":"MI","insp_carrier_zip_code":"48083","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:45:52.000000Z","updated_at":"2025-03-17T19:45:52.000000Z","inspection_violations":[{"id":6491250,"change_date":"2023-10-16 21:42:00","inspection_id":"79906236","insp_violation_id":"255854211","seq_no":"1","part_no":"393","part_no_section":"43","insp_viol_unit":"2","insp_unit_id":"197569568","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:37:18.000000Z","updated_at":"2025-03-17T21:37:18.000000Z","normalized_code":"39343"}],"inspection_per_units":[{"id":6741911,"change_date":"2023-10-16 21:42:00","inspection_id":"79906236","insp_unit_id":"197569567","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"147","insp_unit_license":"BD23205","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GC4YSEY5NF313845","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:32.000000Z","updated_at":"2025-03-17T22:56:32.000000Z"},{"id":6741912,"change_date":"2023-10-16 21:42:00","inspection_id":"79906236","insp_unit_id":"197569568","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIGT","insp_unit_company":null,"insp_unit_license":"F7K104","insp_unit_license_state":"KY","insp_unit_vehicle_id_number":"16V3F4828P6282778","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:32.000000Z","updated_at":"2025-03-17T22:56:32.000000Z"}]},{"id":3654600,"change_date":"2023-08-02 21:41:00","inspection_id":"79307493","dot_number":"2117252","report_state":"OH","report_number":"3271013297","insp_date":"2023-08-01 00:00:00","insp_start_time":"1331","insp_end_time":"1451","registration_date":null,"region":"ET","ci_status_code":"C","location":"06375","location_desc":"FINDLAY SCALES","county_code_state":"OH","county_code":"063","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"F","shipper_name":"UNIVERSAL PIPING INDUSTRIES","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":"I","final_status_date":"2023-08-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"30500","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":"1670683","transaction_code":"A","transaction_date":"2023-08-01 00:00:00","upload_date":"2023-08-02 00:00:00","upload_first_byte":"0","upload_dot_number":"02117252","upload_search_indicator":null,"census_search_date":"2023-08-02 21:41:00","snet_input_date":"2023-08-02 00:00:00","source_office":"3OHS001","mcmis_add_date":"2023-08-02 21:41:00","insp_carrier_name":"UNIVERSAL PIPING INDUSTRIES LLC","insp_carrier_street":"769 CHICAGO RD","insp_carrier_city":"TROY","insp_carrier_state":"MI","insp_carrier_zip_code":"48083","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:34:57.000000Z","updated_at":"2025-03-17T19:34:57.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5876400,"change_date":"2023-08-02 21:41:00","inspection_id":"79307493","insp_unit_id":"196328359","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":null,"insp_unit_license":"BD23205","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1GC4YSEY5NF313845","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:25.000000Z","updated_at":"2025-03-17T22:49:25.000000Z"},{"id":5876401,"change_date":"2023-08-02 21:41:00","inspection_id":"79307493","insp_unit_id":"196328360","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIGT","insp_unit_company":null,"insp_unit_license":"E4W327","insp_unit_license_state":"KY","insp_unit_vehicle_id_number":"16V3F4824P6276542","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:25.000000Z","updated_at":"2025-03-17T22:49:25.000000Z"}]},{"id":895283,"change_date":"2022-07-26 21:42:00","inspection_id":"76154945","dot_number":"2117252","report_state":"MI","report_number":"PRESR01966","insp_date":"2022-07-22 00:00:00","insp_start_time":"0835","insp_end_time":"0844","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"I-75 N\/B WELCOME CENTER","county_code_state":"MI","county_code":"115","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-07-26 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"1085538","transaction_code":"A","transaction_date":"2022-07-22 00:00:00","upload_date":"2022-07-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02117252","upload_search_indicator":null,"census_search_date":"2022-07-26 21:42:00","snet_input_date":"2022-07-22 00:00:00","source_office":"3MIS001","mcmis_add_date":"2022-07-26 21:42:00","insp_carrier_name":"UNIVERSAL PIPING INDUSTRIES LLC","insp_carrier_street":"769 CHICAGO RD","insp_carrier_city":"TROY","insp_carrier_state":"MI","insp_carrier_zip_code":"48083","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:43:25.000000Z","updated_at":"2025-03-17T18:43:25.000000Z","inspection_violations":[{"id":1410463,"change_date":"2022-07-26 21:42:00","inspection_id":"76154945","insp_violation_id":"247319477","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":"X4090085","created_at":"2025-03-17T21:13:39.000000Z","updated_at":"2025-03-17T21:13:39.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1441041,"change_date":"2022-07-26 21:42:00","inspection_id":"76154945","insp_unit_id":"189970524","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"1","insp_unit_license":"B2B005","insp_unit_license_state":"KY","insp_unit_vehicle_id_number":"3ALACWFB2KDKR0697","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:03.000000Z","updated_at":"2025-03-17T22:17:03.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/2117252\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/2117252\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/2117252\/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\/2117252\/inspections","per_page":100,"prev_page_url":null,"to":17,"total":17}