{"current_page":1,"data":[{"id":12262372,"change_date":"2026-06-24 21:32:00","inspection_id":"88221251","dot_number":"3129254","report_state":"MI","report_number":"CTPRW00271","insp_date":"2026-06-23 00:00:00","insp_start_time":"0840","insp_end_time":"0917","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"MI","county_code_state":"MI","county_code":"099","insp_level_id":"1","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":"U","pen_cen_match":"I","final_status_date":"2026-06-24 21:32:00","post_acc_ind":"N","gross_comb_veh_wt":"33500","viol_total":"6","oos_total":"1","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"3600910","transaction_code":"A","transaction_date":"2026-06-24 00:00:00","upload_date":"2026-06-24 00:00:00","upload_first_byte":"0","upload_dot_number":"03129254","upload_search_indicator":null,"census_search_date":"2026-06-24 21:32:00","snet_input_date":"2026-06-23 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-24 21:32:00","insp_carrier_name":"LONE STAR UNDERGROUND INC","insp_carrier_street":"9059 DAISY DRIVE UNIT 107","insp_carrier_city":"WEST DES MOINES","insp_carrier_state":"IA","insp_carrier_zip_code":"50266","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-27T09:40:39.000000Z","updated_at":"2026-07-04T09:31:28.000000Z","inspection_violations":[{"id":21344985,"change_date":"2026-06-24 21:32:00","inspection_id":"88221251","insp_violation_id":"275087359","seq_no":"4","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"214248979","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-27T10:00:58.000000Z","updated_at":"2026-07-04T09:44:26.000000Z","normalized_code":"39617CPI"},{"id":21344986,"change_date":"2026-06-24 21:32:00","inspection_id":"88221251","insp_violation_id":"275087360","seq_no":"5","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"214248980","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-27T10:00:58.000000Z","updated_at":"2026-07-04T09:44:26.000000Z","normalized_code":"39617CPI"},{"id":21344987,"change_date":"2026-06-24 21:32:00","inspection_id":"88221251","insp_violation_id":"275087361","seq_no":"6","part_no":"393","part_no_section":"43DBMA","insp_viol_unit":"2","insp_unit_id":"214248980","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-06-27T10:00:58.000000Z","updated_at":"2026-07-04T09:44:26.000000Z","normalized_code":"39343DBMA"},{"id":21344988,"change_date":"2026-06-24 21:32:00","inspection_id":"88221251","insp_violation_id":"275087362","seq_no":"1","part_no":"392","part_no_section":"2-SLLDL","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-06-27T10:00:58.000000Z","updated_at":"2026-07-04T09:44:26.000000Z","normalized_code":"3922SLLDL"},{"id":21344989,"change_date":"2026-06-24 21:32:00","inspection_id":"88221251","insp_violation_id":"275087363","seq_no":"2","part_no":"391","part_no_section":"41APC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-27T10:00:58.000000Z","updated_at":"2026-07-04T09:44:26.000000Z","normalized_code":"39141APC"},{"id":21344990,"change_date":"2026-06-24 21:32:00","inspection_id":"88221251","insp_violation_id":"275087364","seq_no":"3","part_no":"390","part_no_section":"21TB2-DOT","insp_viol_unit":"1","insp_unit_id":"214248979","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-27T10:00:58.000000Z","updated_at":"2026-07-04T09:44:26.000000Z","normalized_code":"39021TB2DOT"}],"inspection_per_units":[{"id":21293828,"change_date":"2026-06-24 21:32:00","inspection_id":"88221251","insp_unit_id":"214248979","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"CHEV","insp_unit_company":"1","insp_unit_license":"H353139","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"1HTKJPVK4NH456135","insp_unit_decal":"Y","insp_unit_decal_number":"NA","created_at":"2026-06-27T09:16:36.000000Z","updated_at":"2026-07-05T09:05:28.000000Z"},{"id":21293829,"change_date":"2026-06-24 21:32:00","inspection_id":"88221251","insp_unit_id":"214248980","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"PJ","insp_unit_company":"1","insp_unit_license":"NONE","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"5P51C2937T3074366","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-27T09:16:36.000000Z","updated_at":"2026-07-05T09:05:28.000000Z"}]},{"id":9364820,"change_date":"2025-08-08 21:39:00","inspection_id":"85442576","dot_number":"3129254","report_state":"MI","report_number":"ETPJN02066","insp_date":"2025-08-06 00:00:00","insp_start_time":"1323","insp_end_time":"1407","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"TA","county_code_state":"MI","county_code":"025","insp_level_id":"1","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":"2025-08-08 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"35300","viol_total":"11","oos_total":"6","driver_viol_total":"3","driver_oos_total":"3","vehicle_viol_total":"8","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1234887","transaction_code":"A","transaction_date":"2025-08-06 00:00:00","upload_date":"2025-08-08 00:00:00","upload_first_byte":"0","upload_dot_number":"03129254","upload_search_indicator":null,"census_search_date":"2025-08-08 21:39:00","snet_input_date":"2025-08-06 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-08-08 21:39:00","insp_carrier_name":"LONE STAR UNDERGROUND INC","insp_carrier_street":"9059 DAISY DRIVE UNIT 107","insp_carrier_city":"WEST DES MOINES","insp_carrier_state":"IA","insp_carrier_zip_code":"50266","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-12T10:44:14.000000Z","updated_at":"2025-08-12T10:44:14.000000Z","inspection_violations":[{"id":15212636,"change_date":"2025-08-08 21:39:00","inspection_id":"85442576","insp_violation_id":"267919256","seq_no":"1","part_no":"383","part_no_section":"23A2-LCDLN","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"53","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"6383","created_at":"2025-08-11T10:45:30.000000Z","updated_at":"2025-08-12T10:45:31.000000Z","normalized_code":"38323A2LCDLN"},{"id":15212637,"change_date":"2025-08-08 21:39:00","inspection_id":"85442576","insp_violation_id":"267919257","seq_no":"2","part_no":"391","part_no_section":"41APC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"6383","created_at":"2025-08-11T10:45:30.000000Z","updated_at":"2025-08-12T10:45:31.000000Z","normalized_code":"39141APC"},{"id":15212638,"change_date":"2025-08-08 21:39:00","inspection_id":"85442576","insp_violation_id":"267919258","seq_no":"3","part_no":"395","part_no_section":"8A1-HOSP","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-11T10:45:30.000000Z","updated_at":"2025-08-12T10:45:31.000000Z","normalized_code":"3958A1HOSP"},{"id":15212639,"change_date":"2025-08-08 21:39:00","inspection_id":"85442576","insp_violation_id":"267919259","seq_no":"4","part_no":"390","part_no_section":"21TB1-MC","insp_viol_unit":"1","insp_unit_id":"208306484","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"6383","created_at":"2025-08-11T10:45:30.000000Z","updated_at":"2025-08-12T10:45:31.000000Z","normalized_code":"39021TB1MC"},{"id":15212640,"change_date":"2025-08-08 21:39:00","inspection_id":"85442576","insp_violation_id":"267919260","seq_no":"5","part_no":"390","part_no_section":"21TB2-DOT","insp_viol_unit":"1","insp_unit_id":"208306484","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-11T10:45:30.000000Z","updated_at":"2025-08-12T10:45:31.000000Z","normalized_code":"39021TB2DOT"},{"id":15212641,"change_date":"2025-08-08 21:39:00","inspection_id":"85442576","insp_violation_id":"267919261","seq_no":"6","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"208306484","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-11T10:45:30.000000Z","updated_at":"2025-08-12T10:45:31.000000Z","normalized_code":"39617CPI"},{"id":15212642,"change_date":"2025-08-08 21:39:00","inspection_id":"85442576","insp_violation_id":"267919262","seq_no":"7","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"208306485","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-11T10:45:30.000000Z","updated_at":"2025-08-12T10:45:31.000000Z","normalized_code":"39617CPI"},{"id":15212643,"change_date":"2025-08-08 21:39:00","inspection_id":"85442576","insp_violation_id":"267919263","seq_no":"8","part_no":"393","part_no_section":"43DBMA","insp_viol_unit":"2","insp_unit_id":"208306485","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-08-11T10:45:30.000000Z","updated_at":"2025-08-12T10:45:31.000000Z","normalized_code":"39343DBMA"},{"id":15212644,"change_date":"2025-08-08 21:39:00","inspection_id":"85442576","insp_violation_id":"267919264","seq_no":"9","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"2","insp_unit_id":"208306485","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-11T10:45:30.000000Z","updated_at":"2025-08-12T10:45:31.000000Z","normalized_code":"3922SLLSR"},{"id":15212645,"change_date":"2025-08-08 21:39:00","inspection_id":"85442576","insp_violation_id":"267919265","seq_no":"10","part_no":"393","part_no_section":"43D-B","insp_viol_unit":"2","insp_unit_id":"208306485","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-08-11T10:45:30.000000Z","updated_at":"2025-08-12T10:45:31.000000Z","normalized_code":"39343DB"},{"id":15212646,"change_date":"2025-08-08 21:39:00","inspection_id":"85442576","insp_violation_id":"267919266","seq_no":"11","part_no":"396","part_no_section":"3A1-BOS","insp_viol_unit":"2","insp_unit_id":"208306485","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-08-11T10:45:30.000000Z","updated_at":"2025-08-12T10:45:31.000000Z","normalized_code":"3963A1BOS"}],"inspection_per_units":[{"id":15428942,"change_date":"2025-08-08 21:39:00","inspection_id":"85442576","insp_unit_id":"208306484","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":null,"insp_unit_license":"BMH4535","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"3C63R3HL4KG690165","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-11T09:46:26.000000Z","updated_at":"2025-08-12T09:46:00.000000Z"},{"id":15428943,"change_date":"2025-08-08 21:39:00","inspection_id":"85442576","insp_unit_id":"208306485","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FELIN","insp_unit_company":null,"insp_unit_license":"565824T","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"5FTCE292XL2000827","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-11T09:46:26.000000Z","updated_at":"2025-08-12T09:46:00.000000Z"}]},{"id":9249881,"change_date":"2025-07-25 21:40:00","inspection_id":"85321632","dot_number":"3129254","report_state":"MI","report_number":"SAMOK01384","insp_date":"2025-07-24 00:00:00","insp_start_time":"2015","insp_end_time":"2120","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"TA TRUCK STOP","county_code_state":"MI","county_code":"025","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","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-07-25 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"38700","viol_total":"10","oos_total":"5","driver_viol_total":"3","driver_oos_total":"3","vehicle_viol_total":"7","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1232512","transaction_code":"A","transaction_date":"2025-07-24 00:00:00","upload_date":"2025-07-25 00:00:00","upload_first_byte":"0","upload_dot_number":"03129254","upload_search_indicator":null,"census_search_date":"2025-07-25 21:40:00","snet_input_date":"2025-07-24 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-07-25 21:40:00","insp_carrier_name":"LONE STAR UNDERGROUND INC","insp_carrier_street":"9059 DAISY DRIVE UNIT 107","insp_carrier_city":"WEST DES MOINES","insp_carrier_state":"IA","insp_carrier_zip_code":"50266","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-30T10:01:22.000000Z","updated_at":"2025-07-30T10:01:22.000000Z","inspection_violations":[{"id":14979464,"change_date":"2025-07-25 21:40:00","inspection_id":"85321632","insp_violation_id":"267656328","seq_no":"1","part_no":"383","part_no_section":"23A2-LCDLN","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"53","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"X4568265","created_at":"2025-07-28T10:49:45.000000Z","updated_at":"2025-07-29T10:43:31.000000Z","normalized_code":"38323A2LCDLN"},{"id":14979465,"change_date":"2025-07-25 21:40:00","inspection_id":"85321632","insp_violation_id":"267656329","seq_no":"2","part_no":"383","part_no_section":"51A-SOUT","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"8","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-28T10:49:45.000000Z","updated_at":"2025-07-29T10:43:31.000000Z","normalized_code":"38351ASOUT"},{"id":14979466,"change_date":"2025-07-25 21:40:00","inspection_id":"85321632","insp_violation_id":"267656330","seq_no":"3","part_no":"391","part_no_section":"41A-MCPVI","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"X4568265","created_at":"2025-07-28T10:49:45.000000Z","updated_at":"2025-07-29T10:43:31.000000Z","normalized_code":"39141AMCPVI"},{"id":14979467,"change_date":"2025-07-25 21:40:00","inspection_id":"85321632","insp_violation_id":"267656331","seq_no":"4","part_no":"392","part_no_section":"2-SLLIRP","insp_viol_unit":"1","insp_unit_id":"208083827","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-28T10:49:45.000000Z","updated_at":"2025-07-29T10:43:31.000000Z","normalized_code":"3922SLLIRP"},{"id":14979468,"change_date":"2025-07-25 21:40:00","inspection_id":"85321632","insp_violation_id":"267656332","seq_no":"5","part_no":"392","part_no_section":"2-SLLIFTA","insp_viol_unit":"1","insp_unit_id":"208083827","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-28T10:49:45.000000Z","updated_at":"2025-07-29T10:43:31.000000Z","normalized_code":"3922SLLIFTA"},{"id":14979469,"change_date":"2025-07-25 21:40:00","inspection_id":"85321632","insp_violation_id":"267656333","seq_no":"6","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"208083827","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-28T10:49:45.000000Z","updated_at":"2025-07-29T10:43:31.000000Z","normalized_code":"39617CPI"},{"id":14979470,"change_date":"2025-07-25 21:40:00","inspection_id":"85321632","insp_violation_id":"267656334","seq_no":"7","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"208083828","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-28T10:49:45.000000Z","updated_at":"2025-07-29T10:43:31.000000Z","normalized_code":"39617CPI"},{"id":14979471,"change_date":"2025-07-25 21:40:00","inspection_id":"85321632","insp_violation_id":"267656335","seq_no":"8","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"2","insp_unit_id":"208083828","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-28T10:49:45.000000Z","updated_at":"2025-07-29T10:43:31.000000Z","normalized_code":"3922SLLSR"},{"id":14979472,"change_date":"2025-07-25 21:40:00","inspection_id":"85321632","insp_violation_id":"267656336","seq_no":"9","part_no":"393","part_no_section":"43DBMA","insp_viol_unit":"2","insp_unit_id":"208083828","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-07-28T10:49:45.000000Z","updated_at":"2025-07-29T10:43:31.000000Z","normalized_code":"39343DBMA"},{"id":14979473,"change_date":"2025-07-25 21:40:00","inspection_id":"85321632","insp_violation_id":"267656337","seq_no":"10","part_no":"393","part_no_section":"43D-B","insp_viol_unit":"2","insp_unit_id":"208083828","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-07-28T10:49:45.000000Z","updated_at":"2025-07-29T10:43:31.000000Z","normalized_code":"39343DB"}],"inspection_per_units":[{"id":15222859,"change_date":"2025-07-25 21:40:00","inspection_id":"85321632","insp_unit_id":"208083827","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":null,"insp_unit_license":"H480974","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"3C7WRNFL3GG238593","insp_unit_decal":"Y","insp_unit_decal_number":"35455680","created_at":"2025-07-28T09:46:36.000000Z","updated_at":"2025-07-29T09:45:58.000000Z"},{"id":15222860,"change_date":"2025-07-25 21:40:00","inspection_id":"85321632","insp_unit_id":"208083828","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CUAS","insp_unit_company":null,"insp_unit_license":"505258T","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"7JEPU1624LG000471","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-28T09:46:36.000000Z","updated_at":"2025-07-29T09:45:58.000000Z"}]},{"id":8702480,"change_date":"2025-05-21 21:42:00","inspection_id":"84743456","dot_number":"3129254","report_state":"MI","report_number":"BARTT04917","insp_date":"2025-05-20 00:00:00","insp_start_time":"1340","insp_end_time":"1417","registration_date":null,"region":"ET","ci_status_code":"C","location":null,"location_desc":"W\/BI69@GOLF","county_code_state":"MI","county_code":"087","insp_level_id":"2","service_center":"MW","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-05-21 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"19500","viol_total":"7","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1222412","transaction_code":"A","transaction_date":"2025-05-20 00:00:00","upload_date":"2025-05-21 00:00:00","upload_first_byte":"0","upload_dot_number":"03129254","upload_search_indicator":null,"census_search_date":"2025-05-21 21:42:00","snet_input_date":"2025-05-20 00:00:00","source_office":"3MIS001","mcmis_add_date":"2025-05-21 21:42:00","insp_carrier_name":"LONE STAR UNDERGROUND INC","insp_carrier_street":"9059 DAISY DRIVE UNIT 107","insp_carrier_city":"WEST DES MOINES","insp_carrier_state":"IA","insp_carrier_zip_code":"50266","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-24T10:04:24.000000Z","updated_at":"2025-05-25T10:06:35.000000Z","inspection_violations":[{"id":13870778,"change_date":"2025-05-21 21:42:00","inspection_id":"84743456","insp_violation_id":"266381672","seq_no":"1","part_no":"392","part_no_section":"2-SLLDL","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-05-24T10:27:57.000000Z","updated_at":"2025-05-25T10:25:03.000000Z","normalized_code":"3922SLLDL"},{"id":13870779,"change_date":"2025-05-21 21:42:00","inspection_id":"84743456","insp_violation_id":"266381673","seq_no":"2","part_no":"391","part_no_section":"41APC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-24T10:27:57.000000Z","updated_at":"2025-05-25T10:25:03.000000Z","normalized_code":"39141APC"},{"id":13870781,"change_date":"2025-05-21 21:42:00","inspection_id":"84743456","insp_violation_id":"266381675","seq_no":"4","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"206992738","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-24T10:27:57.000000Z","updated_at":"2025-05-25T10:25:03.000000Z","normalized_code":"3922SLLSR"},{"id":13870782,"change_date":"2025-05-21 21:42:00","inspection_id":"84743456","insp_violation_id":"266381676","seq_no":"5","part_no":"392","part_no_section":"2-SLLMF","insp_viol_unit":"1","insp_unit_id":"206992738","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-24T10:27:57.000000Z","updated_at":"2025-05-25T10:25:03.000000Z","normalized_code":"3922SLLMF"},{"id":13870783,"change_date":"2025-05-21 21:42:00","inspection_id":"84743456","insp_violation_id":"266381677","seq_no":"6","part_no":"390","part_no_section":"21TB1-MC","insp_viol_unit":"1","insp_unit_id":"206992738","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-24T10:27:57.000000Z","updated_at":"2025-05-25T10:25:03.000000Z","normalized_code":"39021TB1MC"},{"id":13870784,"change_date":"2025-05-21 21:42:00","inspection_id":"84743456","insp_violation_id":"266381678","seq_no":"7","part_no":"390","part_no_section":"21TB2-DOT","insp_viol_unit":"1","insp_unit_id":"206992738","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-24T10:27:57.000000Z","updated_at":"2025-05-25T10:25:03.000000Z","normalized_code":"39021TB2DOT"},{"id":13870780,"change_date":"2025-05-21 21:42:00","inspection_id":"84743456","insp_violation_id":"266381674","seq_no":"3","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"206992738","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-24T10:27:57.000000Z","updated_at":"2025-05-25T10:25:03.000000Z","normalized_code":"39617CPI"}],"inspection_per_units":[{"id":14221002,"change_date":"2025-05-21 21:42:00","inspection_id":"84743456","insp_unit_id":"206992738","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":"NONE","insp_unit_license":"H348679","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"3C7WRNEL3LG259794","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-24T09:49:50.000000Z","updated_at":"2025-05-25T09:52:14.000000Z"}]},{"id":10957291,"change_date":null,"inspection_id":"sms-757933956","dot_number":"3129254","report_state":"IA","report_number":"000P16DL7X","insp_date":"2025-03-24 00:00:00","insp_start_time":null,"insp_end_time":null,"registration_date":null,"region":null,"ci_status_code":null,"location":null,"location_desc":null,"county_code_state":"IA","county_code":null,"insp_level_id":"2","service_center":null,"census_source_id":null,"insp_facility":null,"shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":"N","snet_version_number":null,"snet_search_date":null,"alcohol_control_sub":null,"drug_intrdctn_search":null,"drug_intrdctn_arrests":null,"size_weight_enf":null,"traffic_enf":null,"local_enf_jurisdiction":null,"pen_cen_match":null,"final_status_date":null,"post_acc_ind":null,"gross_comb_veh_wt":null,"viol_total":"13","oos_total":"5","driver_viol_total":null,"driver_oos_total":"1","vehicle_viol_total":null,"vehicle_oos_total":"4","hazmat_viol_total":null,"hazmat_oos_total":"0","snet_sequence_id":null,"transaction_code":null,"transaction_date":null,"upload_date":null,"upload_first_byte":null,"upload_dot_number":null,"upload_search_indicator":null,"census_search_date":null,"snet_input_date":null,"source_office":null,"mcmis_add_date":null,"insp_carrier_name":null,"insp_carrier_street":null,"insp_carrier_city":null,"insp_carrier_state":null,"insp_carrier_zip_code":null,"insp_colonia":null,"docket_number":null,"insp_interstate":null,"insp_carrier_state_id":null,"created_at":"2026-02-08T05:14:29.000000Z","updated_at":"2026-02-08T05:14:29.000000Z","inspection_violations":[{"id":18331347,"change_date":null,"inspection_id":"sms-757933956","insp_violation_id":null,"seq_no":null,"part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:17:10.000000Z","updated_at":"2026-02-08T05:17:10.000000Z","normalized_code":"38323A2"},{"id":18331348,"change_date":null,"inspection_id":"sms-757933956","insp_violation_id":null,"seq_no":null,"part_no":"391","part_no_section":"41A1-NPH","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:17:10.000000Z","updated_at":"2026-02-08T05:17:10.000000Z","normalized_code":"39141A1NPH"},{"id":18331349,"change_date":null,"inspection_id":"sms-757933956","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:17:10.000000Z","updated_at":"2026-02-08T05:17:10.000000Z","normalized_code":"39311"},{"id":18331350,"change_date":null,"inspection_id":"sms-757933956","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"43(d)","insp_viol_unit":"2","insp_unit_id":"2","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:17:10.000000Z","updated_at":"2026-02-08T05:17:10.000000Z","normalized_code":"39343D"},{"id":18331351,"change_date":null,"inspection_id":"sms-757933956","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"48(a)","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:17:10.000000Z","updated_at":"2026-02-08T05:17:10.000000Z","normalized_code":"39348A"},{"id":18331352,"change_date":null,"inspection_id":"sms-757933956","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:17:10.000000Z","updated_at":"2026-02-08T05:17:10.000000Z","normalized_code":"3939"},{"id":18331353,"change_date":null,"inspection_id":"sms-757933956","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:17:10.000000Z","updated_at":"2026-02-08T05:17:10.000000Z","normalized_code":"39395A"},{"id":18331354,"change_date":null,"inspection_id":"sms-757933956","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:17:10.000000Z","updated_at":"2026-02-08T05:17:10.000000Z","normalized_code":"39395F"},{"id":18331355,"change_date":null,"inspection_id":"sms-757933956","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"9A-LSLI","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:17:10.000000Z","updated_at":"2026-02-08T05:17:10.000000Z","normalized_code":"3939ALSLI"},{"id":18331356,"change_date":null,"inspection_id":"sms-757933956","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"9T","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:17:10.000000Z","updated_at":"2026-02-08T05:17:10.000000Z","normalized_code":"3939T"},{"id":18331357,"change_date":null,"inspection_id":"sms-757933956","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"9TS","insp_viol_unit":"2","insp_unit_id":"2","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:17:10.000000Z","updated_at":"2026-02-08T05:17:10.000000Z","normalized_code":"3939TS"},{"id":18331358,"change_date":null,"inspection_id":"sms-757933956","insp_violation_id":null,"seq_no":null,"part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:17:10.000000Z","updated_at":"2026-02-08T05:17:10.000000Z","normalized_code":"39617C"},{"id":18331359,"change_date":null,"inspection_id":"sms-757933956","insp_violation_id":null,"seq_no":null,"part_no":"396","part_no_section":"3A1BOS","insp_viol_unit":"2","insp_unit_id":"2","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:17:10.000000Z","updated_at":"2026-02-08T05:17:10.000000Z","normalized_code":"3963A1BOS"}],"inspection_per_units":[{"id":18418688,"change_date":null,"inspection_id":"sms-757933956","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"1CP6393","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"1FDRF3G61HEC99770","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:14:55.000000Z","updated_at":"2026-02-08T05:14:55.000000Z"},{"id":18532724,"change_date":null,"inspection_id":"sms-757933956","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"DITCHWITCH","insp_unit_company":null,"insp_unit_license":"2754TE8","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"1DSB202S7E1700760","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:14:55.000000Z","updated_at":"2026-02-08T05:14:55.000000Z"}]},{"id":11018276,"change_date":null,"inspection_id":"sms-757330992","dot_number":"3129254","report_state":"MI","report_number":"WALKB03388","insp_date":"2025-03-15 00:00:00","insp_start_time":null,"insp_end_time":null,"registration_date":null,"region":null,"ci_status_code":null,"location":null,"location_desc":null,"county_code_state":"MI","county_code":null,"insp_level_id":"3","service_center":null,"census_source_id":null,"insp_facility":null,"shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":"N","snet_version_number":null,"snet_search_date":null,"alcohol_control_sub":null,"drug_intrdctn_search":null,"drug_intrdctn_arrests":null,"size_weight_enf":null,"traffic_enf":null,"local_enf_jurisdiction":null,"pen_cen_match":null,"final_status_date":null,"post_acc_ind":null,"gross_comb_veh_wt":null,"viol_total":"3","oos_total":"1","driver_viol_total":null,"driver_oos_total":"1","vehicle_viol_total":null,"vehicle_oos_total":"0","hazmat_viol_total":null,"hazmat_oos_total":"0","snet_sequence_id":null,"transaction_code":null,"transaction_date":null,"upload_date":null,"upload_first_byte":null,"upload_dot_number":null,"upload_search_indicator":null,"census_search_date":null,"snet_input_date":null,"source_office":null,"mcmis_add_date":null,"insp_carrier_name":null,"insp_carrier_street":null,"insp_carrier_city":null,"insp_carrier_state":null,"insp_carrier_zip_code":null,"insp_colonia":null,"docket_number":null,"insp_interstate":null,"insp_carrier_state_id":null,"created_at":"2026-02-08T05:14:29.000000Z","updated_at":"2026-02-08T05:14:29.000000Z","inspection_violations":[{"id":18366715,"change_date":null,"inspection_id":"sms-757330992","insp_violation_id":null,"seq_no":null,"part_no":"383","part_no_section":"23A2-LCDLN","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:17:10.000000Z","updated_at":"2026-02-08T05:17:10.000000Z","normalized_code":"38323A2LCDLN"},{"id":18366716,"change_date":null,"inspection_id":"sms-757330992","insp_violation_id":null,"seq_no":null,"part_no":"391","part_no_section":"41A-MCPC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:17:10.000000Z","updated_at":"2026-02-08T05:17:10.000000Z","normalized_code":"39141AMCPC"},{"id":18366717,"change_date":null,"inspection_id":"sms-757330992","insp_violation_id":null,"seq_no":null,"part_no":"395","part_no_section":"8F1-HOSM","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"99","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:17:10.000000Z","updated_at":"2026-02-08T05:17:10.000000Z","normalized_code":"3958F1HOSM"}],"inspection_per_units":[{"id":18479655,"change_date":null,"inspection_id":"sms-757330992","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":null,"insp_unit_license":"J8A9YN","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"3C7WRNFL2LG136454","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:14:55.000000Z","updated_at":"2026-02-08T05:14:55.000000Z"},{"id":18579422,"change_date":null,"inspection_id":"sms-757330992","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"BBTM","insp_unit_company":null,"insp_unit_license":"NONE","insp_unit_license_state":"MI","insp_unit_vehicle_id_number":"4L5SC2525LF051382","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:14:55.000000Z","updated_at":"2026-02-08T05:14:55.000000Z"}]},{"id":10955559,"change_date":null,"inspection_id":"sms-756364401","dot_number":"3129254","report_state":"MI","report_number":"BARTT04798","insp_date":"2025-03-04 00:00:00","insp_start_time":null,"insp_end_time":null,"registration_date":null,"region":null,"ci_status_code":null,"location":null,"location_desc":null,"county_code_state":"MI","county_code":null,"insp_level_id":"2","service_center":null,"census_source_id":null,"insp_facility":null,"shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":"N","snet_version_number":null,"snet_search_date":null,"alcohol_control_sub":null,"drug_intrdctn_search":null,"drug_intrdctn_arrests":null,"size_weight_enf":null,"traffic_enf":null,"local_enf_jurisdiction":null,"pen_cen_match":null,"final_status_date":null,"post_acc_ind":null,"gross_comb_veh_wt":null,"viol_total":"5","oos_total":"2","driver_viol_total":null,"driver_oos_total":"0","vehicle_viol_total":null,"vehicle_oos_total":"2","hazmat_viol_total":null,"hazmat_oos_total":"0","snet_sequence_id":null,"transaction_code":null,"transaction_date":null,"upload_date":null,"upload_first_byte":null,"upload_dot_number":null,"upload_search_indicator":null,"census_search_date":null,"snet_input_date":null,"source_office":null,"mcmis_add_date":null,"insp_carrier_name":null,"insp_carrier_street":null,"insp_carrier_city":null,"insp_carrier_state":null,"insp_carrier_zip_code":null,"insp_colonia":null,"docket_number":null,"insp_interstate":null,"insp_carrier_state_id":null,"created_at":"2026-02-08T05:14:29.000000Z","updated_at":"2026-02-08T05:14:29.000000Z","inspection_violations":[{"id":18330317,"change_date":null,"inspection_id":"sms-756364401","insp_violation_id":null,"seq_no":null,"part_no":"391","part_no_section":"11A-QMC","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:17:10.000000Z","updated_at":"2026-02-08T05:17:10.000000Z","normalized_code":"39111AQMC"},{"id":18330318,"change_date":null,"inspection_id":"sms-756364401","insp_violation_id":null,"seq_no":null,"part_no":"391","part_no_section":"11B5-LNCDLNVL","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:17:10.000000Z","updated_at":"2026-02-08T05:17:10.000000Z","normalized_code":"39111B5LNCDLNVL"},{"id":18330319,"change_date":null,"inspection_id":"sms-756364401","insp_violation_id":null,"seq_no":null,"part_no":"391","part_no_section":"41A-MCPC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:17:10.000000Z","updated_at":"2026-02-08T05:17:10.000000Z","normalized_code":"39141AMCPC"},{"id":18330320,"change_date":null,"inspection_id":"sms-756364401","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"95A1","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:17:10.000000Z","updated_at":"2026-02-08T05:17:10.000000Z","normalized_code":"39395A1"},{"id":18330321,"change_date":null,"inspection_id":"sms-756364401","insp_violation_id":null,"seq_no":null,"part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:17:10.000000Z","updated_at":"2026-02-08T05:17:10.000000Z","normalized_code":"39617CPI"}],"inspection_per_units":[{"id":18416956,"change_date":null,"inspection_id":"sms-756364401","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":null,"insp_unit_license":"J8A9YN","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"3C7WRNFL2LG136454","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:14:55.000000Z","updated_at":"2026-02-08T05:14:55.000000Z"}]},{"id":9150043,"change_date":"2025-07-15 21:40:00","inspection_id":"83465604","dot_number":"3129254","report_state":"IA","report_number":"000P12Q7PB","insp_date":"2024-12-13 00:00:00","insp_start_time":"1050","insp_end_time":"1125","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 63 AND WY 175 VOORHIES","county_code_state":"IA","county_code":"013","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"LONE STAR UNDERGROUND","shipping_paper_number":"EMPTY","cargo_tank":null,"hazmat_placard_req":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-12-23 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"35900","viol_total":"15","oos_total":"1","driver_viol_total":"3","driver_oos_total":"0","vehicle_viol_total":"12","vehicle_oos_total":"1","hazmat_viol_total":"1","hazmat_oos_total":"1","snet_sequence_id":"1341931","transaction_code":"C","transaction_date":"2025-07-14 00:00:00","upload_date":"2025-07-15 00:00:00","upload_first_byte":"0","upload_dot_number":"03129254","upload_search_indicator":"M","census_search_date":"2024-12-23 21:39:00","snet_input_date":"2024-12-13 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-12-23 21:39:00","insp_carrier_name":"LONE STAR UNDERGROUND INC","insp_carrier_street":"9059 DAISY DRIVE UNIT 107","insp_carrier_city":"WEST DES MOINES","insp_carrier_state":"IA","insp_carrier_zip_code":"50266","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-18T10:45:57.000000Z","updated_at":"2025-07-19T10:41:41.000000Z","inspection_violations":[{"id":14761693,"change_date":"2025-07-15 21:40:00","inspection_id":"83465604","insp_violation_id":"267419210","seq_no":"1","part_no":"390","part_no_section":"21TB","insp_viol_unit":"1","insp_unit_id":"207883234","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"2DRI24121310505","created_at":"2025-07-18T10:48:06.000000Z","updated_at":"2025-07-18T10:48:06.000000Z","normalized_code":"39021TB"},{"id":14761694,"change_date":"2025-07-15 21:40:00","inspection_id":"83465604","insp_violation_id":"267419211","seq_no":"2","part_no":"393","part_no_section":"43D","insp_viol_unit":"2","insp_unit_id":"207883235","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"2DRI24121310510","created_at":"2025-07-18T10:48:06.000000Z","updated_at":"2025-07-18T10:48:06.000000Z","normalized_code":"39343D"},{"id":14761695,"change_date":"2025-07-15 21:40:00","inspection_id":"83465604","insp_violation_id":"267419212","seq_no":"3","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"207883234","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-18T10:48:06.000000Z","updated_at":"2025-07-18T10:48:06.000000Z","normalized_code":"3922RG"},{"id":14761696,"change_date":"2025-07-15 21:40:00","inspection_id":"83465604","insp_violation_id":"267419213","seq_no":"4","part_no":"392","part_no_section":"2RG","insp_viol_unit":"2","insp_unit_id":"207883235","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-18T10:48:06.000000Z","updated_at":"2025-07-18T10:48:06.000000Z","normalized_code":"3922RG"},{"id":14761697,"change_date":"2025-07-15 21:40:00","inspection_id":"83465604","insp_violation_id":"267419214","seq_no":"5","part_no":"392","part_no_section":"2RG","insp_viol_unit":"2","insp_unit_id":"207883235","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"2DRI24121311060","created_at":"2025-07-18T10:48:06.000000Z","updated_at":"2025-07-18T10:48:06.000000Z","normalized_code":"3922RG"},{"id":14761698,"change_date":"2025-07-15 21:40:00","inspection_id":"83465604","insp_violation_id":"267419215","seq_no":"6","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"207883235","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-18T10:48:06.000000Z","updated_at":"2025-07-18T10:48:06.000000Z","normalized_code":"3939"},{"id":14761699,"change_date":"2025-07-15 21:40:00","inspection_id":"83465604","insp_violation_id":"267419216","seq_no":"7","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"207883235","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-18T10:48:06.000000Z","updated_at":"2025-07-18T10:48:06.000000Z","normalized_code":"3939"},{"id":14761700,"change_date":"2025-07-15 21:40:00","inspection_id":"83465604","insp_violation_id":"267419217","seq_no":"8","part_no":"393","part_no_section":"95A","insp_viol_unit":"1","insp_unit_id":"207883234","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-18T10:48:06.000000Z","updated_at":"2025-07-18T10:48:06.000000Z","normalized_code":"39395A"},{"id":14761701,"change_date":"2025-07-15 21:40:00","inspection_id":"83465604","insp_violation_id":"267419218","seq_no":"9","part_no":"392","part_no_section":"8","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-18T10:48:06.000000Z","updated_at":"2025-07-18T10:48:06.000000Z","normalized_code":"3928"},{"id":14761702,"change_date":"2025-07-15 21:40:00","inspection_id":"83465604","insp_violation_id":"267419219","seq_no":"10","part_no":"177","part_no_section":"834A-HMC","insp_viol_unit":"1","insp_unit_id":"207883234","insp_violation_category_id":"34","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-07-18T10:48:06.000000Z","updated_at":"2025-07-18T10:48:06.000000Z","normalized_code":"177834AHMC"},{"id":14761703,"change_date":"2025-07-15 21:40:00","inspection_id":"83465604","insp_violation_id":"267419220","seq_no":"11","part_no":"383","part_no_section":"23A2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"2DRI24121311095","created_at":"2025-07-18T10:48:06.000000Z","updated_at":"2025-07-18T10:48:06.000000Z","normalized_code":"38323A2"},{"id":14761704,"change_date":"2025-07-15 21:40:00","inspection_id":"83465604","insp_violation_id":"267419221","seq_no":"12","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"207883234","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-18T10:48:06.000000Z","updated_at":"2025-07-18T10:48:06.000000Z","normalized_code":"39617C"},{"id":14761705,"change_date":"2025-07-15 21:40:00","inspection_id":"83465604","insp_violation_id":"267419222","seq_no":"13","part_no":"396","part_no_section":"17C","insp_viol_unit":"2","insp_unit_id":"207883235","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-18T10:48:06.000000Z","updated_at":"2025-07-18T10:48:06.000000Z","normalized_code":"39617C"},{"id":14761706,"change_date":"2025-07-15 21:40:00","inspection_id":"83465604","insp_violation_id":"267419223","seq_no":"14","part_no":"391","part_no_section":"41A","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"2DRI24121311103","created_at":"2025-07-18T10:48:06.000000Z","updated_at":"2025-07-18T10:48:06.000000Z","normalized_code":"39141A"},{"id":14761707,"change_date":"2025-07-15 21:40:00","inspection_id":"83465604","insp_violation_id":"267419224","seq_no":"15","part_no":"392","part_no_section":"9BA-INACTIVE","insp_viol_unit":"1","insp_unit_id":"207883234","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-18T10:48:06.000000Z","updated_at":"2025-07-18T10:48:06.000000Z","normalized_code":"3929BAINACTIVE"}],"inspection_per_units":[{"id":15027195,"change_date":"2025-07-15 21:40:00","inspection_id":"83465604","insp_unit_id":"207883234","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"F250","insp_unit_license":"1CP6397","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"1FT7X2B6XKED95978","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-18T09:46:34.000000Z","updated_at":"2025-07-19T09:45:20.000000Z"},{"id":15027196,"change_date":"2025-07-15 21:40:00","inspection_id":"83465604","insp_unit_id":"207883235","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAGERBEAVE","insp_unit_company":"1","insp_unit_license":"505256T","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"112HGN322BL074971","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-18T09:46:34.000000Z","updated_at":"2025-07-19T09:45:20.000000Z"}]},{"id":11002372,"change_date":null,"inspection_id":"sms-743100804","dot_number":"3129254","report_state":"AZ","report_number":"1060500032","insp_date":"2024-08-28 00:00:00","insp_start_time":null,"insp_end_time":null,"registration_date":null,"region":null,"ci_status_code":null,"location":null,"location_desc":null,"county_code_state":"AZ","county_code":null,"insp_level_id":"1","service_center":null,"census_source_id":null,"insp_facility":null,"shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":"N","snet_version_number":null,"snet_search_date":null,"alcohol_control_sub":null,"drug_intrdctn_search":null,"drug_intrdctn_arrests":null,"size_weight_enf":null,"traffic_enf":null,"local_enf_jurisdiction":null,"pen_cen_match":null,"final_status_date":null,"post_acc_ind":null,"gross_comb_veh_wt":null,"viol_total":"12","oos_total":"5","driver_viol_total":null,"driver_oos_total":"1","vehicle_viol_total":null,"vehicle_oos_total":"4","hazmat_viol_total":null,"hazmat_oos_total":"0","snet_sequence_id":null,"transaction_code":null,"transaction_date":null,"upload_date":null,"upload_first_byte":null,"upload_dot_number":null,"upload_search_indicator":null,"census_search_date":null,"snet_input_date":null,"source_office":null,"mcmis_add_date":null,"insp_carrier_name":null,"insp_carrier_street":null,"insp_carrier_city":null,"insp_carrier_state":null,"insp_carrier_zip_code":null,"insp_colonia":null,"docket_number":null,"insp_interstate":null,"insp_carrier_state_id":null,"created_at":"2026-02-08T05:14:29.000000Z","updated_at":"2026-02-08T05:14:29.000000Z","inspection_violations":[{"id":18357934,"change_date":null,"inspection_id":"sms-743100804","insp_violation_id":null,"seq_no":null,"part_no":"383","part_no_section":"23A2-LCDLN","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:17:10.000000Z","updated_at":"2026-02-08T05:17:10.000000Z","normalized_code":"38323A2LCDLN"},{"id":18357935,"change_date":null,"inspection_id":"sms-743100804","insp_violation_id":null,"seq_no":null,"part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:17:10.000000Z","updated_at":"2026-02-08T05:17:10.000000Z","normalized_code":"39141A"},{"id":18357936,"change_date":null,"inspection_id":"sms-743100804","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"43DBMA","insp_viol_unit":"2","insp_unit_id":"2","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:17:10.000000Z","updated_at":"2026-02-08T05:17:10.000000Z","normalized_code":"39343DBMA"},{"id":18357937,"change_date":null,"inspection_id":"sms-743100804","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"48A-BI-TSA","insp_viol_unit":"2","insp_unit_id":"2","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:17:10.000000Z","updated_at":"2026-02-08T05:17:10.000000Z","normalized_code":"39348ABITSA"},{"id":18357938,"change_date":null,"inspection_id":"sms-743100804","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"60(d)","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:17:10.000000Z","updated_at":"2026-02-08T05:17:10.000000Z","normalized_code":"39360D"},{"id":18357939,"change_date":null,"inspection_id":"sms-743100804","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"78A-WS","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:17:10.000000Z","updated_at":"2026-02-08T05:17:10.000000Z","normalized_code":"39378AWS"},{"id":18357940,"change_date":null,"inspection_id":"sms-743100804","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"81-H","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:17:10.000000Z","updated_at":"2026-02-08T05:17:10.000000Z","normalized_code":"39381H"},{"id":18357941,"change_date":null,"inspection_id":"sms-743100804","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"95A1","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:17:10.000000Z","updated_at":"2026-02-08T05:17:10.000000Z","normalized_code":"39395A1"},{"id":18357942,"change_date":null,"inspection_id":"sms-743100804","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:17:10.000000Z","updated_at":"2026-02-08T05:17:10.000000Z","normalized_code":"39395F"},{"id":18357943,"change_date":null,"inspection_id":"sms-743100804","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"9A-LBL","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:17:10.000000Z","updated_at":"2026-02-08T05:17:10.000000Z","normalized_code":"3939ALBL"},{"id":18357944,"change_date":null,"inspection_id":"sms-743100804","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"9A-LTSI","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:17:10.000000Z","updated_at":"2026-02-08T05:17:10.000000Z","normalized_code":"3939ALTSI"},{"id":18357945,"change_date":null,"inspection_id":"sms-743100804","insp_violation_id":null,"seq_no":null,"part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:17:10.000000Z","updated_at":"2026-02-08T05:17:10.000000Z","normalized_code":"39617CPI"}],"inspection_per_units":[{"id":18463754,"change_date":null,"inspection_id":"sms-743100804","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"ABA6LS","insp_unit_license_state":"AZ","insp_unit_vehicle_id_number":"1FD0W5HT6HEF12995","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:14:55.000000Z","updated_at":"2026-02-08T05:14:55.000000Z"},{"id":18567246,"change_date":null,"inspection_id":"sms-743100804","insp_unit_id":"2","insp_unit_type_id":"13","insp_unit_number":"2","insp_unit_make":"VERMEER MF","insp_unit_company":null,"insp_unit_license":"3006JL","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1M9FE1220BS284346","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:14:55.000000Z","updated_at":"2026-02-08T05:14:55.000000Z"}]},{"id":10994213,"change_date":null,"inspection_id":"sms-735820389","dot_number":"3129254","report_state":"IA","report_number":"000P12DZ5M","insp_date":"2024-05-29 00:00:00","insp_start_time":null,"insp_end_time":null,"registration_date":null,"region":null,"ci_status_code":null,"location":null,"location_desc":null,"county_code_state":"IA","county_code":null,"insp_level_id":"1","service_center":null,"census_source_id":null,"insp_facility":null,"shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":"N","snet_version_number":null,"snet_search_date":null,"alcohol_control_sub":null,"drug_intrdctn_search":null,"drug_intrdctn_arrests":null,"size_weight_enf":null,"traffic_enf":null,"local_enf_jurisdiction":null,"pen_cen_match":null,"final_status_date":null,"post_acc_ind":null,"gross_comb_veh_wt":null,"viol_total":"7","oos_total":"3","driver_viol_total":null,"driver_oos_total":"1","vehicle_viol_total":null,"vehicle_oos_total":"2","hazmat_viol_total":null,"hazmat_oos_total":"0","snet_sequence_id":null,"transaction_code":null,"transaction_date":null,"upload_date":null,"upload_first_byte":null,"upload_dot_number":null,"upload_search_indicator":null,"census_search_date":null,"snet_input_date":null,"source_office":null,"mcmis_add_date":null,"insp_carrier_name":null,"insp_carrier_street":null,"insp_carrier_city":null,"insp_carrier_state":null,"insp_carrier_zip_code":null,"insp_colonia":null,"docket_number":null,"insp_interstate":null,"insp_carrier_state_id":null,"created_at":"2026-02-08T05:14:29.000000Z","updated_at":"2026-02-08T05:14:29.000000Z","inspection_violations":[{"id":18353263,"change_date":null,"inspection_id":"sms-735820389","insp_violation_id":null,"seq_no":null,"part_no":"391","part_no_section":"11B5-DNL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:17:10.000000Z","updated_at":"2026-02-08T05:17:10.000000Z","normalized_code":"39111B5DNL"},{"id":18353264,"change_date":null,"inspection_id":"sms-735820389","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:17:10.000000Z","updated_at":"2026-02-08T05:17:10.000000Z","normalized_code":"39311"},{"id":18353265,"change_date":null,"inspection_id":"sms-735820389","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"205(c)","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:17:10.000000Z","updated_at":"2026-02-08T05:17:10.000000Z","normalized_code":"393205C"},{"id":18353266,"change_date":null,"inspection_id":"sms-735820389","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:17:10.000000Z","updated_at":"2026-02-08T05:17:10.000000Z","normalized_code":"39375A3"},{"id":18353267,"change_date":null,"inspection_id":"sms-735820389","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:17:10.000000Z","updated_at":"2026-02-08T05:17:10.000000Z","normalized_code":"3939"},{"id":18353268,"change_date":null,"inspection_id":"sms-735820389","insp_violation_id":null,"seq_no":null,"part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:17:10.000000Z","updated_at":"2026-02-08T05:17:10.000000Z","normalized_code":"39395A"},{"id":18353269,"change_date":null,"inspection_id":"sms-735820389","insp_violation_id":null,"seq_no":null,"part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"1","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":null,"citation_number":null,"created_at":"2026-02-08T05:17:10.000000Z","updated_at":"2026-02-08T05:17:10.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":18455599,"change_date":null,"inspection_id":"sms-735820389","insp_unit_id":"1","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":null,"insp_unit_license":"NONE","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3C7WRNBL4JG185514","insp_unit_decal":null,"insp_unit_decal_number":"","created_at":"2026-02-08T05:14:55.000000Z","updated_at":"2026-02-08T05:14:55.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/3129254\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/3129254\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/3129254\/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\/3129254\/inspections","per_page":100,"prev_page_url":null,"to":10,"total":10}