{"current_page":1,"data":[{"id":12312971,"change_date":"2026-07-02 21:41:00","inspection_id":"88270585","dot_number":"1843087","report_state":"KS","report_number":"HP00940584","insp_date":"2026-06-29 00:00:00","insp_start_time":"0856","insp_end_time":"0935","registration_date":"2026-07-02 00:00:00","region":"CD","ci_status_code":"C","location":"SG","location_desc":"KS","county_code_state":"KS","county_code":"173","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"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":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-06-29 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"3646256","transaction_code":"C","transaction_date":"2026-07-02 00:00:00","upload_date":"2026-07-02 00:00:00","upload_first_byte":"0","upload_dot_number":"01843087","upload_search_indicator":null,"census_search_date":"2026-06-29 21:42:00","snet_input_date":"2026-06-29 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-29 21:42:00","insp_carrier_name":"BERAN EXCAVATING LLC","insp_carrier_street":"8401 E OAK KNOLL ST","insp_carrier_city":"WICHITA","insp_carrier_state":"KS","insp_carrier_zip_code":"67207","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-07-02T09:40:35.000000Z","updated_at":"2026-07-14T09:30:10.000000Z","inspection_violations":[{"id":21428122,"change_date":"2026-07-02 21:41:00","inspection_id":"88270585","insp_violation_id":"275276959","seq_no":"1","part_no":"393","part_no_section":"95A4-EEUS","insp_viol_unit":"1","insp_unit_id":"214421776","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-02T10:00:47.000000Z","updated_at":"2026-07-14T09:43:01.000000Z","normalized_code":"39395A4EEUS"}],"inspection_per_units":[{"id":21385702,"change_date":"2026-07-02 21:41:00","inspection_id":"88270585","insp_unit_id":"214421776","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"200","insp_unit_license":"9651AFL","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"1NPCLP0X1LD686744","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-02T09:17:33.000000Z","updated_at":"2026-07-14T09:01:10.000000Z"}]},{"id":12096978,"change_date":"2026-06-04 21:45:00","inspection_id":"88041198","dot_number":"1843087","report_state":"KS","report_number":"HP03580164","insp_date":"2026-06-03 00:00:00","insp_start_time":"1522","insp_end_time":"1543","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"KS","county_code_state":"KS","county_code":"173","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"GREEN MEADOWS","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-04 21:45:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"3461209","transaction_code":"A","transaction_date":"2026-06-04 00:00:00","upload_date":"2026-06-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01843087","upload_search_indicator":null,"census_search_date":"2026-06-04 21:45:00","snet_input_date":"2026-06-03 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-06-04 21:45:00","insp_carrier_name":"BERAN EXCAVATING LLC","insp_carrier_street":"8401 E OAK KNOLL ST","insp_carrier_city":"WICHITA","insp_carrier_state":"KS","insp_carrier_zip_code":"67207","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-07T09:40:52.000000Z","updated_at":"2026-06-16T09:31:29.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21019570,"change_date":"2026-06-04 21:45:00","inspection_id":"88041198","insp_unit_id":"213912310","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"200","insp_unit_license":"9651AFL","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"1NPCLP0X1LD686744","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-07T09:18:00.000000Z","updated_at":"2026-06-16T09:03:25.000000Z"}]},{"id":11718905,"change_date":"2026-04-24 21:41:00","inspection_id":"87646305","dot_number":"1843087","report_state":"KS","report_number":"HP03840642","insp_date":"2026-04-22 00:00:00","insp_start_time":"0750","insp_end_time":"0815","registration_date":null,"region":"CT","ci_status_code":"C","location":"KM","location_desc":"KINGMAN COUNTY - 095","county_code_state":"KS","county_code":"095","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CENTRAL SAND","shipping_paper_number":"307302","cargo_tank":null,"hazmat_placard_req":"N","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2026-04-24 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"130000","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":"1393367","transaction_code":"C","transaction_date":"2026-04-24 00:00:00","upload_date":"2026-04-24 00:00:00","upload_first_byte":"0","upload_dot_number":"01843087","upload_search_indicator":"M","census_search_date":"2026-04-24 21:41:00","snet_input_date":"2026-04-22 00:00:00","source_office":"3KSS001","mcmis_add_date":"2026-04-22 21:39:00","insp_carrier_name":"BERAN EXCAVATING LLC","insp_carrier_street":"8401 E OAK KNOLL ST","insp_carrier_city":"WICHITA","insp_carrier_state":"KS","insp_carrier_zip_code":"67207","insp_colonia":null,"docket_number":"667773","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-04-27T09:42:10.000000Z","updated_at":"2026-05-05T09:30:16.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20392488,"change_date":"2026-04-24 21:41:00","inspection_id":"87646305","insp_unit_id":"213208371","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"155","insp_unit_license":"543128","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"3WKDDU9XX7F209711","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:20:57.000000Z","updated_at":"2026-05-05T09:02:19.000000Z"},{"id":20392489,"change_date":"2026-04-24 21:41:00","inspection_id":"87646305","insp_unit_id":"213208372","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"KRUZ","insp_unit_company":"44","insp_unit_license":"181354","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"1K9SD28279K226768","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:20:57.000000Z","updated_at":"2026-05-05T09:02:19.000000Z"}]},{"id":11498238,"change_date":"2026-04-02 21:39:00","inspection_id":"87418216","dot_number":"1843087","report_state":"KS","report_number":"HP04740255","insp_date":"2026-03-27 00:00:00","insp_start_time":"1557","insp_end_time":"1630","registration_date":null,"region":"CT","ci_status_code":"C","location":"BU","location_desc":"BUTLER COUNTY - 015","county_code_state":"KS","county_code":"015","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"HARSHMAN CONST","shipping_paper_number":"49858","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2026-04-02 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"130000","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":"1392490","transaction_code":"C","transaction_date":"2026-04-02 00:00:00","upload_date":"2026-04-02 00:00:00","upload_first_byte":"0","upload_dot_number":"01843087","upload_search_indicator":"M","census_search_date":"2026-04-02 21:39:00","snet_input_date":"2026-03-27 00:00:00","source_office":"3KSS001","mcmis_add_date":"2026-03-27 21:39:00","insp_carrier_name":"BERAN EXCAVATING LLC","insp_carrier_street":"8401 E OAK KNOLL ST","insp_carrier_city":"WICHITA","insp_carrier_state":"KS","insp_carrier_zip_code":"67207","insp_colonia":null,"docket_number":"667773","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-30T09:51:37.000000Z","updated_at":"2026-04-13T09:31:01.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19797946,"change_date":"2026-04-02 21:39:00","inspection_id":"87418216","insp_unit_id":"212505567","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"155","insp_unit_license":"543128","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"3WKDDU9XX7F209711","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-05T09:52:16.000000Z","updated_at":"2026-04-13T09:03:59.000000Z"},{"id":19797947,"change_date":"2026-04-02 21:39:00","inspection_id":"87418216","insp_unit_id":"212505568","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":"44","insp_unit_license":"181354","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"1K9SD28279K226768","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-05T09:52:16.000000Z","updated_at":"2026-04-13T09:03:59.000000Z"}]},{"id":10549171,"change_date":"2025-12-31 21:37:00","inspection_id":"86685952","dot_number":"1843087","report_state":"KS","report_number":"HP02380429","insp_date":"2025-12-30 00:00:00","insp_start_time":"1440","insp_end_time":"1455","registration_date":null,"region":"CT","ci_status_code":"C","location":"SG","location_desc":"SEDGWICK COUNTY - 173","county_code_state":"KS","county_code":"173","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"BERAN EXC","shipping_paper_number":"465-E26071","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-31 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"72000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1385276","transaction_code":"A","transaction_date":"2025-12-31 00:00:00","upload_date":"2025-12-31 00:00:00","upload_first_byte":"0","upload_dot_number":"01843087","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-12-30 00:00:00","source_office":"3KSS001","mcmis_add_date":"2025-12-31 21:37:00","insp_carrier_name":"BERAN EXCAVATING LLC","insp_carrier_street":"8401 E OAK KNOLL ST","insp_carrier_city":"WICHITA","insp_carrier_state":"KS","insp_carrier_zip_code":"67207","insp_colonia":null,"docket_number":"667773","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-03T10:35:11.000000Z","updated_at":"2026-01-11T10:30:33.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17672195,"change_date":"2025-12-31 21:37:00","inspection_id":"86685952","insp_unit_id":"210870598","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"156","insp_unit_license":"7371AFL","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"1NPCLPEX4FD283094","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-03T10:05:58.000000Z","updated_at":"2026-01-11T10:00:37.000000Z"}]},{"id":10514714,"change_date":"2025-12-24 21:35:00","inspection_id":"86650097","dot_number":"1843087","report_state":"KS","report_number":"HP03580141","insp_date":"2025-12-23 00:00:00","insp_start_time":"0848","insp_end_time":"0905","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"EB K096 RAMP FROM HOOVER RD","county_code_state":"KS","county_code":"173","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CONCO","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-24 21:35:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","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":"1384768","transaction_code":"A","transaction_date":"2025-12-23 00:00:00","upload_date":"2025-12-24 00:00:00","upload_first_byte":"0","upload_dot_number":"01843087","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-12-23 00:00:00","source_office":"3KSS001","mcmis_add_date":"2025-12-24 21:35:00","insp_carrier_name":"BERAN EXCAVATING LLC","insp_carrier_street":"8401 E OAK KNOLL ST","insp_carrier_city":"WICHITA","insp_carrier_state":"KS","insp_carrier_zip_code":"67207","insp_colonia":null,"docket_number":"667773","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-27T10:38:32.000000Z","updated_at":"2026-01-04T10:30:24.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17608988,"change_date":"2025-12-24 21:35:00","inspection_id":"86650097","insp_unit_id":"210796033","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"167","insp_unit_license":"671281","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"1XPFDB9X67N681173","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-27T10:09:27.000000Z","updated_at":"2026-01-04T10:00:26.000000Z"},{"id":17608989,"change_date":"2025-12-24 21:35:00","inspection_id":"86650097","insp_unit_id":"210796034","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MNTR","insp_unit_company":"41","insp_unit_license":"554309","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"5MC5153205P004948","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-27T10:09:27.000000Z","updated_at":"2026-01-04T10:00:26.000000Z"}]},{"id":10460243,"change_date":"2025-12-17 21:39:00","inspection_id":"86593163","dot_number":"1843087","report_state":"KS","report_number":"HP02710094","insp_date":"2025-12-15 00:00:00","insp_start_time":"1105","insp_end_time":"1121","registration_date":null,"region":"CT","ci_status_code":"C","location":"HWY","location_desc":"WB EXIT TO RIDGE RD","county_code_state":"KS","county_code":"173","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-12-17 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"1383771","transaction_code":"A","transaction_date":"2025-12-15 00:00:00","upload_date":"2025-12-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01843087","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-12-15 00:00:00","source_office":"3KSS001","mcmis_add_date":"2025-12-17 21:39:00","insp_carrier_name":"BERAN EXCAVATING LLC","insp_carrier_street":"8401 E OAK KNOLL ST","insp_carrier_city":"WICHITA","insp_carrier_state":"KS","insp_carrier_zip_code":"67207","insp_colonia":null,"docket_number":"667773","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-20T10:31:45.000000Z","updated_at":"2025-12-28T10:30:54.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17505675,"change_date":"2025-12-17 21:39:00","inspection_id":"86593163","insp_unit_id":"210667047","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"200","insp_unit_license":"9651AFL","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"1NPCLP0X1LD686744","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-20T10:01:49.000000Z","updated_at":"2025-12-28T10:00:57.000000Z"}]},{"id":10389145,"change_date":"2025-12-09 21:39:00","inspection_id":"86518843","dot_number":"1843087","report_state":"KS","report_number":"HP03532797","insp_date":"2025-12-03 00:00:00","insp_start_time":"1230","insp_end_time":"1320","registration_date":"2025-12-08 00:00:00","region":"CT","ci_status_code":"C","location":"MG","location_desc":"MONTGOMERY COUNTY - 125","county_code_state":"KS","county_code":"125","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"NORTHRIDGE SAND","shipping_paper_number":"101745","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-09 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","viol_total":"4","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1382829","transaction_code":"A","transaction_date":"2025-12-08 00:00:00","upload_date":"2025-12-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01843087","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-12-03 00:00:00","source_office":"3KSS001","mcmis_add_date":"2025-12-09 21:39:00","insp_carrier_name":"BERAN EXCAVATING LLC","insp_carrier_street":"8401 E OAK KNOLL ST","insp_carrier_city":"WICHITA","insp_carrier_state":"KS","insp_carrier_zip_code":"67207","insp_colonia":null,"docket_number":"667773","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-12T10:31:40.000000Z","updated_at":"2025-12-13T10:30:53.000000Z","inspection_violations":[{"id":17400953,"change_date":"2025-12-09 21:39:00","inspection_id":"86518843","insp_violation_id":"270563436","seq_no":"1","part_no":"392","part_no_section":"2-SLLEWA1","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-12T10:32:42.000000Z","updated_at":"2025-12-13T10:31:18.000000Z","normalized_code":"3922SLLEWA1"},{"id":17400954,"change_date":"2025-12-09 21:39:00","inspection_id":"86518843","insp_violation_id":"270563437","seq_no":"2","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"2","insp_unit_id":"210505907","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-12T10:32:42.000000Z","updated_at":"2025-12-13T10:31:18.000000Z","normalized_code":"39345B2BAIR"},{"id":17400955,"change_date":"2025-12-09 21:39:00","inspection_id":"86518843","insp_violation_id":"270563438","seq_no":"3","part_no":"393","part_no_section":"45B2-B-AIR","insp_viol_unit":"2","insp_unit_id":"210505907","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-12T10:32:42.000000Z","updated_at":"2025-12-13T10:31:18.000000Z","normalized_code":"39345B2BAIR"},{"id":17400956,"change_date":"2025-12-09 21:39:00","inspection_id":"86518843","insp_violation_id":"270563439","seq_no":"4","part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"2","insp_unit_id":"210505907","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-12T10:32:42.000000Z","updated_at":"2025-12-13T10:31:18.000000Z","normalized_code":"3939ALLPL"}],"inspection_per_units":[{"id":17368737,"change_date":"2025-12-09 21:39:00","inspection_id":"86518843","insp_unit_id":"210505906","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"167","insp_unit_license":"671281","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"1XPFDB9X67N681173","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-12T10:01:30.000000Z","updated_at":"2025-12-13T10:01:07.000000Z"},{"id":17368738,"change_date":"2025-12-09 21:39:00","inspection_id":"86518843","insp_unit_id":"210505907","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MNTR","insp_unit_company":"41","insp_unit_license":"554309","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"5MC5153205P004948","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-12T10:01:30.000000Z","updated_at":"2025-12-13T10:01:07.000000Z"}]},{"id":10164761,"change_date":"2025-11-10 21:39:00","inspection_id":"86283739","dot_number":"1843087","report_state":"KS","report_number":"HP00940556","insp_date":"2025-11-07 00:00:00","insp_start_time":"1057","insp_end_time":"1133","registration_date":null,"region":"CT","ci_status_code":"C","location":"SG","location_desc":"SEDGWICK COUNTY - 173","county_code_state":"KS","county_code":"173","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"690804","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-10 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"72000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1380739","transaction_code":"A","transaction_date":"2025-11-10 00:00:00","upload_date":"2025-11-10 00:00:00","upload_first_byte":"0","upload_dot_number":"01843087","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-11-07 00:00:00","source_office":"3KSS001","mcmis_add_date":"2025-11-10 21:39:00","insp_carrier_name":"BERAN EXCAVATING LLC","insp_carrier_street":"8401 E OAK KNOLL ST","insp_carrier_city":"WICHITA","insp_carrier_state":"KS","insp_carrier_zip_code":"67207","insp_colonia":null,"docket_number":"667773","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-11-13T10:30:43.000000Z","updated_at":"2025-11-14T10:30:50.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16925322,"change_date":"2025-11-10 21:39:00","inspection_id":"86283739","insp_unit_id":"209946992","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"156","insp_unit_license":"7371AFL","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"1NPCLPEX4FD283094","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-13T10:00:42.000000Z","updated_at":"2025-11-14T10:01:03.000000Z"}]},{"id":9883590,"change_date":"2025-10-08 21:40:00","inspection_id":"85987182","dot_number":"1843087","report_state":"KS","report_number":"0119000011","insp_date":"2025-10-06 00:00:00","insp_start_time":"1158","insp_end_time":"1218","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"WICHITA KS","county_code_state":"KS","county_code":"173","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"N\/A","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":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-10-08 21:40:00","post_acc_ind":"Y","gross_comb_veh_wt":"66000","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":"2380389","transaction_code":"A","transaction_date":"2025-10-07 00:00:00","upload_date":"2025-10-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01843087","upload_search_indicator":null,"census_search_date":"2025-10-08 21:40:00","snet_input_date":"2025-10-06 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-10-08 21:40:00","insp_carrier_name":"BERAN EXCAVATING LLC","insp_carrier_street":"8401 E OAK KNOLL ST","insp_carrier_city":"WICHITA","insp_carrier_state":"KS","insp_carrier_zip_code":"67207","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-11T10:01:41.000000Z","updated_at":"2025-10-12T10:00:31.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16398793,"change_date":"2025-10-08 21:40:00","inspection_id":"85987182","insp_unit_id":"209355490","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PETERBILT","insp_unit_company":"200","insp_unit_license":"9651AFL","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"1NPCLP0X1LD686744","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-11T09:47:05.000000Z","updated_at":"2025-10-12T09:45:37.000000Z"}]},{"id":9758842,"change_date":"2025-09-23 21:43:00","inspection_id":"85856187","dot_number":"1843087","report_state":"KS","report_number":"HP02710077","insp_date":"2025-09-22 00:00:00","insp_start_time":"1045","insp_end_time":"1103","registration_date":null,"region":"CT","ci_status_code":"C","location":"HWY","location_desc":"EXIT TO HOOVER","county_code_state":"KS","county_code":"173","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-09-23 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"72000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1375799","transaction_code":"A","transaction_date":"2025-09-22 00:00:00","upload_date":"2025-09-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01843087","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-09-22 00:00:00","source_office":"3KSS001","mcmis_add_date":"2025-09-23 21:43:00","insp_carrier_name":"BERAN EXCAVATING LLC","insp_carrier_street":"8401 E OAK KNOLL ST","insp_carrier_city":"WICHITA","insp_carrier_state":"KS","insp_carrier_zip_code":"67207","insp_colonia":null,"docket_number":"667773","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-25T10:00:50.000000Z","updated_at":"2025-09-26T10:00:51.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16165511,"change_date":"2025-09-23 21:43:00","inspection_id":"85856187","insp_unit_id":"209104612","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"156","insp_unit_license":"7371AFL","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"1NPCLPEX4FD283094","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-26T09:46:10.000000Z","updated_at":"2025-09-27T09:46:01.000000Z"}]},{"id":9743687,"change_date":"2025-09-22 21:39:00","inspection_id":"85840489","dot_number":"1843087","report_state":"KS","report_number":"HP03163239","insp_date":"2025-09-19 00:00:00","insp_start_time":"1215","insp_end_time":"1240","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"K-254 AND GREENWICH","county_code_state":"KS","county_code":"173","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"BERAN EXCAVATING","shipping_paper_number":"178639","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-22 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"72000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1375690","transaction_code":"A","transaction_date":"2025-09-20 00:00:00","upload_date":"2025-09-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01843087","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-09-19 00:00:00","source_office":"3KSS001","mcmis_add_date":"2025-09-22 21:39:00","insp_carrier_name":"BERAN EXCAVATING LLC","insp_carrier_street":"8401 E OAK KNOLL ST","insp_carrier_city":"WICHITA","insp_carrier_state":"KS","insp_carrier_zip_code":"67207","insp_colonia":null,"docket_number":"667773","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-25T10:00:25.000000Z","updated_at":"2025-09-25T10:00:25.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16137711,"change_date":"2025-09-22 21:39:00","inspection_id":"85840489","insp_unit_id":"209075077","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"156","insp_unit_license":"7371AFL","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"1NPCLPEX4FD283094","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-25T09:45:26.000000Z","updated_at":"2025-09-26T09:45:37.000000Z"}]},{"id":9743680,"change_date":"2025-09-22 21:39:00","inspection_id":"85840482","dot_number":"1843087","report_state":"KS","report_number":"HP03163236","insp_date":"2025-09-18 00:00:00","insp_start_time":"1420","insp_end_time":"1445","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"W K-254 MP 8","county_code_state":"KS","county_code":"173","insp_level_id":"2","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-22 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"1375682","transaction_code":"A","transaction_date":"2025-09-19 00:00:00","upload_date":"2025-09-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01843087","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-09-18 00:00:00","source_office":"3KSS001","mcmis_add_date":"2025-09-22 21:39:00","insp_carrier_name":"BERAN EXCAVATING LLC","insp_carrier_street":"8401 E OAK KNOLL ST","insp_carrier_city":"WICHITA","insp_carrier_state":"KS","insp_carrier_zip_code":"67207","insp_colonia":null,"docket_number":"667773","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-25T10:00:25.000000Z","updated_at":"2025-09-25T10:00:25.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16137701,"change_date":"2025-09-22 21:39:00","inspection_id":"85840482","insp_unit_id":"209075067","insp_unit_type_id":"9","insp_unit_number":"1","insp_unit_make":"PBTI","insp_unit_company":"200","insp_unit_license":"9651AFL","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"1NPCLP0X1LD686744","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-25T09:45:26.000000Z","updated_at":"2025-09-26T09:45:37.000000Z"}]},{"id":9450575,"change_date":"2025-08-19 21:40:00","inspection_id":"85532744","dot_number":"1843087","report_state":"KS","report_number":"HP00940538","insp_date":"2025-08-15 00:00:00","insp_start_time":"1139","insp_end_time":"1210","registration_date":null,"region":"CT","ci_status_code":"C","location":"SG","location_desc":"SEDGWICK COUNTY - 173","county_code_state":"KS","county_code":"173","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-08-19 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"72000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1371584","transaction_code":"A","transaction_date":"2025-08-15 00:00:00","upload_date":"2025-08-19 00:00:00","upload_first_byte":"0","upload_dot_number":"01843087","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-08-15 00:00:00","source_office":"3KSS001","mcmis_add_date":"2025-08-19 21:40:00","insp_carrier_name":"BERAN EXCAVATING LLC","insp_carrier_street":"8401 E OAK KNOLL ST","insp_carrier_city":"WICHITA","insp_carrier_state":"KS","insp_carrier_zip_code":"67207","insp_colonia":null,"docket_number":"667773","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-23T10:46:30.000000Z","updated_at":"2025-08-23T10:46:30.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15583503,"change_date":"2025-08-19 21:40:00","inspection_id":"85532744","insp_unit_id":"208472268","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"156","insp_unit_license":"7371AFL","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"1NPCLPEX4FD283094","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-22T09:46:42.000000Z","updated_at":"2025-08-23T09:46:06.000000Z"}]},{"id":8982087,"change_date":"2025-06-30 21:39:00","inspection_id":"85039949","dot_number":"1843087","report_state":"KS","report_number":"HP02750538","insp_date":"2025-06-24 00:00:00","insp_start_time":"1230","insp_end_time":"1300","registration_date":"2025-06-30 00:00:00","region":"CT","ci_status_code":"C","location":"SG","location_desc":"SEDGWICK COUNTY - 173","county_code_state":"KS","county_code":"173","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"EMPTY","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":"2025-06-25 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"72000","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":"1365851","transaction_code":"C","transaction_date":"2025-06-30 00:00:00","upload_date":"2025-06-30 00:00:00","upload_first_byte":"0","upload_dot_number":"01843087","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-06-24 00:00:00","source_office":"3KSS001","mcmis_add_date":"2025-06-25 21:40:00","insp_carrier_name":"BERAN EXCAVATING LLC","insp_carrier_street":"8401 E OAK KNOLL ST","insp_carrier_city":"WICHITA","insp_carrier_state":"KS","insp_carrier_zip_code":"67207","insp_colonia":null,"docket_number":"667773","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-28T10:01:08.000000Z","updated_at":"2025-07-04T10:00:20.000000Z","inspection_violations":[{"id":14513707,"change_date":"2025-06-30 21:39:00","inspection_id":"85039949","insp_violation_id":"267130372","seq_no":"1","part_no":"393","part_no_section":"205C-WRAWFLMIB","insp_viol_unit":"1","insp_unit_id":"207640555","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-03T10:15:42.000000Z","updated_at":"2025-07-04T10:17:07.000000Z","normalized_code":"393205CWRAWFLMIB"}],"inspection_per_units":[{"id":14806117,"change_date":"2025-06-30 21:39:00","inspection_id":"85039949","insp_unit_id":"207640555","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"156","insp_unit_license":"7371AFL","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"1NPCLPEX4FD283094","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-03T09:45:33.000000Z","updated_at":"2025-07-04T09:45:25.000000Z"}]},{"id":8580783,"change_date":"2025-06-26 21:41:00","inspection_id":"84615292","dot_number":"1843087","report_state":"KS","report_number":"HP04472919","insp_date":"2025-05-07 00:00:00","insp_start_time":"1400","insp_end_time":"1505","registration_date":"2025-06-26 00:00:00","region":"CT","ci_status_code":"C","location":"SG","location_desc":"SEDGWICK COUNTY - 173","county_code_state":"KS","county_code":"173","insp_level_id":"2","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-05-08 21:41:00","post_acc_ind":"Y","gross_comb_veh_wt":"56000","viol_total":"3","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":"1360983","transaction_code":"C","transaction_date":"2025-06-26 00:00:00","upload_date":"2025-06-26 00:00:00","upload_first_byte":"0","upload_dot_number":"01843087","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-05-07 00:00:00","source_office":"3KSS001","mcmis_add_date":"2025-05-08 21:41:00","insp_carrier_name":"BERAN EXCAVATING LLC","insp_carrier_street":"8401 E OAK KNOLL ST","insp_carrier_city":"WICHITA","insp_carrier_state":"KS","insp_carrier_zip_code":"67207","insp_colonia":null,"docket_number":"667773","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-11T10:21:31.000000Z","updated_at":"2025-06-30T10:00:55.000000Z","inspection_violations":[{"id":14455730,"change_date":"2025-06-26 21:41:00","inspection_id":"84615292","insp_violation_id":"267058880","seq_no":"1","part_no":"393","part_no_section":"9A-LHLI","insp_viol_unit":"1","insp_unit_id":"207566333","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-29T10:16:37.000000Z","updated_at":"2025-06-30T10:17:28.000000Z","normalized_code":"3939ALHLI"},{"id":14455731,"change_date":"2025-06-26 21:41:00","inspection_id":"84615292","insp_violation_id":"267058881","seq_no":"2","part_no":"393","part_no_section":"9A-LFTSI","insp_viol_unit":"1","insp_unit_id":"207566333","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-29T10:16:37.000000Z","updated_at":"2025-06-30T10:17:29.000000Z","normalized_code":"3939ALFTSI"},{"id":14455732,"change_date":"2025-06-26 21:41:00","inspection_id":"84615292","insp_violation_id":"267058882","seq_no":"3","part_no":"393","part_no_section":"209B-STWLOOS","insp_viol_unit":"1","insp_unit_id":"207566333","insp_violation_category_id":"21","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-06-29T10:16:37.000000Z","updated_at":"2025-06-30T10:17:29.000000Z","normalized_code":"393209BSTWLOOS"}],"inspection_per_units":[{"id":14743597,"change_date":"2025-06-26 21:41:00","inspection_id":"84615292","insp_unit_id":"207566333","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"205","insp_unit_license":"698385","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"1FVACWDT1EHFU4557","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-29T09:46:14.000000Z","updated_at":"2025-07-01T09:47:18.000000Z"},{"id":14743598,"change_date":"2025-06-26 21:41:00","inspection_id":"84615292","insp_unit_id":"207566334","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LAMAR","insp_unit_company":"89","insp_unit_license":"181446","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"5RVFG3220PP120135","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-29T09:46:14.000000Z","updated_at":"2025-07-01T09:47:18.000000Z"}]},{"id":8558755,"change_date":"2025-05-06 21:40:00","inspection_id":"84592202","dot_number":"1843087","report_state":"KS","report_number":"HP02380398","insp_date":"2025-05-05 00:00:00","insp_start_time":"1032","insp_end_time":"1045","registration_date":null,"region":"CT","ci_status_code":"C","location":"SG","location_desc":"SEDGWICK COUNTY - 173","county_code_state":"KS","county_code":"173","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"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-05-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"82000","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":"1360737","transaction_code":"A","transaction_date":"2025-05-05 00:00:00","upload_date":"2025-05-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01843087","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-05-05 00:00:00","source_office":"3KSS001","mcmis_add_date":"2025-05-06 21:40:00","insp_carrier_name":"BERAN EXCAVATING LLC","insp_carrier_street":"8401 E OAK KNOLL ST","insp_carrier_city":"WICHITA","insp_carrier_state":"KS","insp_carrier_zip_code":"67207","insp_colonia":null,"docket_number":"667773","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-09T10:26:05.000000Z","updated_at":"2025-05-10T10:51:48.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13921120,"change_date":"2025-05-06 21:40:00","inspection_id":"84592202","insp_unit_id":"206664738","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"169","insp_unit_license":"548149","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"1NKZXPTX4HJ148421","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-09T10:13:57.000000Z","updated_at":"2025-05-10T10:01:44.000000Z"}]},{"id":8450969,"change_date":"2025-04-23 21:41:00","inspection_id":"84478639","dot_number":"1843087","report_state":"KS","report_number":"HP04472899","insp_date":"2025-04-23 00:00:00","insp_start_time":"0659","insp_end_time":"0715","registration_date":null,"region":"CT","ci_status_code":"C","location":"SG","location_desc":"SEDGWICK COUNTY - 173","county_code_state":"KS","county_code":"173","insp_level_id":"3","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-04-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"82000","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":"1359575","transaction_code":"A","transaction_date":"2025-04-23 00:00:00","upload_date":"2025-04-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01843087","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-04-23 00:00:00","source_office":"3KSS001","mcmis_add_date":"2025-04-23 21:41:00","insp_carrier_name":"BERAN EXCAVATING LLC","insp_carrier_street":"8401 E OAK KNOLL ST","insp_carrier_city":"WICHITA","insp_carrier_state":"KS","insp_carrier_zip_code":"67207","insp_colonia":null,"docket_number":"667773","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-26T10:28:33.000000Z","updated_at":"2025-04-27T10:31:42.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13726677,"change_date":"2025-04-23 21:41:00","inspection_id":"84478639","insp_unit_id":"206456123","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"169","insp_unit_license":"548149","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"1NKZXPTX4HJ148421","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-26T10:14:32.000000Z","updated_at":"2025-04-27T10:04:09.000000Z"}]},{"id":8415604,"change_date":"2025-04-30 21:52:00","inspection_id":"84441287","dot_number":"1843087","report_state":"KS","report_number":"HP03532556","insp_date":"2025-04-17 00:00:00","insp_start_time":"1315","insp_end_time":"1345","registration_date":"2025-04-29 00:00:00","region":"CT","ci_status_code":"C","location":"MG","location_desc":"MONTGOMERY COUNTY - 125","county_code_state":"KS","county_code":"125","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"NORTHRIDGE SAND","shipping_paper_number":"85381","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-04-18 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"1359178","transaction_code":"C","transaction_date":"2025-04-29 00:00:00","upload_date":"2025-04-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01843087","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-04-17 00:00:00","source_office":"3KSS001","mcmis_add_date":"2025-04-18 21:40:00","insp_carrier_name":"BERAN EXCAVATING LLC","insp_carrier_street":"8401 E OAK KNOLL ST","insp_carrier_city":"WICHITA","insp_carrier_state":"KS","insp_carrier_zip_code":"67207","insp_colonia":null,"docket_number":"667773","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-21T10:26:12.000000Z","updated_at":"2025-05-04T10:37:15.000000Z","inspection_violations":[{"id":13463540,"change_date":"2025-04-30 21:52:00","inspection_id":"84441287","insp_violation_id":"265928541","seq_no":"1","part_no":"393","part_no_section":"11A1-CSURR","insp_viol_unit":"1","insp_unit_id":"206575233","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-02T11:19:50.000000Z","updated_at":"2025-05-03T11:05:47.000000Z","normalized_code":"39311A1CSURR"}],"inspection_per_units":[{"id":13827916,"change_date":"2025-04-30 21:52:00","inspection_id":"84441287","insp_unit_id":"206575233","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"167","insp_unit_license":"671281","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"1XPFDB9X67N681173","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-03T10:19:25.000000Z","updated_at":"2025-05-04T10:03:12.000000Z"},{"id":13827917,"change_date":"2025-04-30 21:52:00","inspection_id":"84441287","insp_unit_id":"206575234","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"VANTA","insp_unit_company":"108","insp_unit_license":"696718","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"4E7AA392XCASA3776","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-03T10:19:25.000000Z","updated_at":"2025-05-04T10:03:12.000000Z"}]},{"id":8194016,"change_date":"2025-03-31 21:40:00","inspection_id":"84208007","dot_number":"1843087","report_state":"OK","report_number":"V800173158","insp_date":"2025-03-21 00:00:00","insp_start_time":"1540","insp_end_time":"1650","registration_date":"2025-03-31 00:00:00","region":"CT","ci_status_code":"C","location":"57060","location_desc":"28805 US HWY 60","county_code_state":"OK","county_code":"113","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"MC","shipping_paper_number":"660130308","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-03-24 21:40:00","post_acc_ind":"Y","gross_comb_veh_wt":"132000","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":"779456","transaction_code":"C","transaction_date":"2025-03-24 00:00:00","upload_date":"2025-03-31 00:00:00","upload_first_byte":"0","upload_dot_number":"01843087","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-03-21 00:00:00","source_office":"2OKS001","mcmis_add_date":"2025-03-24 21:40:00","insp_carrier_name":"BERAN EXCAVATING LLC","insp_carrier_street":"8401 E OAK KNOLL ST","insp_carrier_city":"WICHITA","insp_carrier_state":"KS","insp_carrier_zip_code":"67207","insp_colonia":null,"docket_number":"667773","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-27T10:01:29.000000Z","updated_at":"2025-04-04T10:16:43.000000Z","inspection_violations":[{"id":12957354,"change_date":"2025-03-31 21:40:00","inspection_id":"84208007","insp_violation_id":"265354202","seq_no":"1","part_no":"393","part_no_section":"207A-SAPPAS","insp_viol_unit":"1","insp_unit_id":"206081040","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-04-03T10:19:51.000000Z","updated_at":"2025-04-04T10:29:48.000000Z","normalized_code":"393207ASAPPAS"},{"id":12957355,"change_date":"2025-03-31 21:40:00","inspection_id":"84208007","insp_violation_id":"265354203","seq_no":"2","part_no":"396","part_no_section":"3A1-BACL","insp_viol_unit":"1","insp_unit_id":"206081040","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-04-03T10:19:51.000000Z","updated_at":"2025-04-04T10:29:48.000000Z","normalized_code":"3963A1BACL"}],"inspection_per_units":[{"id":13351234,"change_date":"2025-03-31 21:40:00","inspection_id":"84208007","insp_unit_id":"206081040","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"173","insp_unit_license":"718524","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"1XPWD49X4ED222285","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-03T09:50:01.000000Z","updated_at":"2025-04-04T09:51:06.000000Z"},{"id":13351235,"change_date":"2025-03-31 21:40:00","inspection_id":"84208007","insp_unit_id":"206081041","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"KRUZ","insp_unit_company":"44","insp_unit_license":"718524","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"1K9SD28279K226768","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-03T09:50:01.000000Z","updated_at":"2025-04-04T09:51:06.000000Z"}]},{"id":8146086,"change_date":"2025-03-18 21:40:00","inspection_id":"84157478","dot_number":"1843087","report_state":"KS","report_number":"HP02710054","insp_date":"2025-03-17 00:00:00","insp_start_time":"0806","insp_end_time":"0821","registration_date":null,"region":"CT","ci_status_code":"C","location":"HWY","location_desc":"EXIT TO HOOVER","county_code_state":"KS","county_code":"173","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-03-18 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"72000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1355321","transaction_code":"A","transaction_date":"2025-03-17 00:00:00","upload_date":"2025-03-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01843087","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-03-17 00:00:00","source_office":"3KSS001","mcmis_add_date":"2025-03-18 21:40:00","insp_carrier_name":"BERAN EXCAVATING LLC","insp_carrier_street":"8401 E OAK KNOLL ST","insp_carrier_city":"WICHITA","insp_carrier_state":"KS","insp_carrier_zip_code":"67207","insp_colonia":null,"docket_number":"667773","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-21T10:34:13.000000Z","updated_at":"2025-03-22T10:35:57.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13157834,"change_date":"2025-03-18 21:40:00","inspection_id":"84157478","insp_unit_id":"205860814","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"156","insp_unit_license":"646035","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"1NPCLPEX4FD283094","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-21T10:06:32.000000Z","updated_at":"2025-03-22T09:59:31.000000Z"}]},{"id":8110571,"change_date":"2025-03-13 21:44:00","inspection_id":"84120095","dot_number":"1843087","report_state":"KS","report_number":"HP04472819","insp_date":"2025-03-12 00:00:00","insp_start_time":"0730","insp_end_time":"0748","registration_date":null,"region":"CT","ci_status_code":"C","location":"SG","location_desc":"SEDGWICK COUNTY - 173","county_code_state":"KS","county_code":"173","insp_level_id":"3","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-03-13 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"134000","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":"1354700","transaction_code":"A","transaction_date":"2025-03-12 00:00:00","upload_date":"2025-03-13 00:00:00","upload_first_byte":"0","upload_dot_number":"01843087","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2025-03-12 00:00:00","source_office":"3KSS001","mcmis_add_date":"2025-03-13 21:44:00","insp_carrier_name":"BERAN EXCAVATING LLC","insp_carrier_street":"8401 E OAK KNOLL ST","insp_carrier_city":"WICHITA","insp_carrier_state":"KS","insp_carrier_zip_code":"67207","insp_colonia":null,"docket_number":"667773","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:06:52.000000Z","updated_at":"2025-03-17T21:06:52.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13095303,"change_date":"2025-03-13 21:44:00","inspection_id":"84120095","insp_unit_id":"205790208","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"100","insp_unit_license":"671235","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"1XP5DB9X66D863147","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:59:47.000000Z","updated_at":"2025-03-17T23:59:47.000000Z"},{"id":13095304,"change_date":"2025-03-13 21:44:00","inspection_id":"84120095","insp_unit_id":"205790209","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"KAU","insp_unit_company":"42","insp_unit_license":"557046","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"5VGFR362XFL005998","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:59:47.000000Z","updated_at":"2025-03-17T23:59:47.000000Z"}]},{"id":7639790,"change_date":"2025-01-16 21:41:00","inspection_id":"83625519","dot_number":"1843087","report_state":"KS","report_number":"HP04472693","insp_date":"2025-01-15 00:00:00","insp_start_time":"0708","insp_end_time":"0723","registration_date":null,"region":"CT","ci_status_code":"C","location":"BU","location_desc":"BUTLER COUNTY - 015","county_code_state":"KS","county_code":"015","insp_level_id":"3","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-01-16 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"1350179","transaction_code":"A","transaction_date":"2025-01-16 00:00:00","upload_date":"2025-01-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01843087","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-01-15 00:00:00","source_office":"3KSS001","mcmis_add_date":"2025-01-16 21:41:00","insp_carrier_name":"BERAN EXCAVATING LLC","insp_carrier_street":"8401 E OAK KNOLL ST","insp_carrier_city":"WICHITA","insp_carrier_state":"KS","insp_carrier_zip_code":"67207","insp_colonia":null,"docket_number":"667773","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:56:35.000000Z","updated_at":"2025-03-17T20:56:35.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12327530,"change_date":"2025-01-16 21:41:00","inspection_id":"83625519","insp_unit_id":"204873553","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"234","insp_unit_license":"721261","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"1XP5DU9X46D653299","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:51:03.000000Z","updated_at":"2025-03-17T23:51:03.000000Z"},{"id":12327531,"change_date":"2025-01-16 21:41:00","inspection_id":"83625519","insp_unit_id":"204873554","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"RANC","insp_unit_company":null,"insp_unit_license":"680910","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"5TU24282XNS000154","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:51:03.000000Z","updated_at":"2025-03-17T23:51:03.000000Z"}]},{"id":7450322,"change_date":"2024-12-18 21:41:00","inspection_id":"83426579","dot_number":"1843087","report_state":"KS","report_number":"HP01272041","insp_date":"2024-12-17 00:00:00","insp_start_time":"0935","insp_end_time":"0947","registration_date":null,"region":"CT","ci_status_code":"C","location":"SG","location_desc":"SEDGWICK COUNTY - 173","county_code_state":"KS","county_code":"173","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-12-18 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"82000","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":"1347823","transaction_code":"A","transaction_date":"2024-12-17 00:00:00","upload_date":"2024-12-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01843087","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-12-17 00:00:00","source_office":"3KSS001","mcmis_add_date":"2024-12-18 21:41:00","insp_carrier_name":"BERAN EXCAVATING LLC","insp_carrier_street":"8401 E OAK KNOLL ST","insp_carrier_city":"WICHITA","insp_carrier_state":"KS","insp_carrier_zip_code":"67207","insp_colonia":null,"docket_number":"667773","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:51:33.000000Z","updated_at":"2025-03-17T20:51:33.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12019140,"change_date":"2024-12-18 21:41:00","inspection_id":"83426579","insp_unit_id":"204456294","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"169","insp_unit_license":"548149","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"1NKZXPTX4HJ148421","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:47:40.000000Z","updated_at":"2025-03-17T23:47:40.000000Z"}]},{"id":7381980,"change_date":"2024-12-10 21:41:00","inspection_id":"83354850","dot_number":"1843087","report_state":"KS","report_number":"HP04730506","insp_date":"2024-12-09 00:00:00","insp_start_time":"1308","insp_end_time":"1326","registration_date":null,"region":"CT","ci_status_code":"C","location":"SG","location_desc":"SEDGWICK COUNTY - 173","county_code_state":"KS","county_code":"173","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-12-10 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"58000","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":"1346657","transaction_code":"A","transaction_date":"2024-12-09 00:00:00","upload_date":"2024-12-10 00:00:00","upload_first_byte":"0","upload_dot_number":"01843087","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-12-09 00:00:00","source_office":"3KSS001","mcmis_add_date":"2024-12-10 21:41:00","insp_carrier_name":"BERAN EXCAVATING LLC","insp_carrier_street":"8401 E OAK KNOLL ST","insp_carrier_city":"WICHITA","insp_carrier_state":"KS","insp_carrier_zip_code":"67207","insp_colonia":null,"docket_number":"667773","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:50:15.000000Z","updated_at":"2025-03-17T20:50:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11908232,"change_date":"2024-12-10 21:41:00","inspection_id":"83354850","insp_unit_id":"204297518","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"151","insp_unit_license":"547131","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"1HTWXAHT36J238568","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:46:29.000000Z","updated_at":"2025-03-17T23:46:29.000000Z"}]},{"id":7328809,"change_date":"2024-12-03 21:40:00","inspection_id":"83298854","dot_number":"1843087","report_state":"KS","report_number":"HP02750511","insp_date":"2024-12-02 00:00:00","insp_start_time":"1419","insp_end_time":"1445","registration_date":null,"region":"CT","ci_status_code":"C","location":"SG","location_desc":"SEDGWICK COUNTY - 173","county_code_state":"KS","county_code":"173","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"NONE","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":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-12-03 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"58000","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":"1345913","transaction_code":"A","transaction_date":"2024-12-02 00:00:00","upload_date":"2024-12-03 00:00:00","upload_first_byte":"0","upload_dot_number":"01843087","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-12-02 00:00:00","source_office":"3KSS001","mcmis_add_date":"2024-12-03 21:40:00","insp_carrier_name":"BERAN EXCAVATING LLC","insp_carrier_street":"8401 E OAK KNOLL ST","insp_carrier_city":"WICHITA","insp_carrier_state":"KS","insp_carrier_zip_code":"67207","insp_colonia":null,"docket_number":"667773","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:48:59.000000Z","updated_at":"2025-03-17T20:48:59.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11822642,"change_date":"2024-12-03 21:40:00","inspection_id":"83298854","insp_unit_id":"204153294","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"151","insp_unit_license":"547131","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"1HTWXAHT36J238568","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:45:33.000000Z","updated_at":"2025-03-17T23:45:33.000000Z"}]},{"id":7220549,"change_date":"2024-11-18 21:41:00","inspection_id":"83184659","dot_number":"1843087","report_state":"KS","report_number":"HP00940504","insp_date":"2024-11-15 00:00:00","insp_start_time":"1004","insp_end_time":"1041","registration_date":null,"region":"CT","ci_status_code":"C","location":"SG","location_desc":"SEDGWICK COUNTY - 173","county_code_state":"KS","county_code":"173","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-11-18 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"72000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1344564","transaction_code":"A","transaction_date":"2024-11-15 00:00:00","upload_date":"2024-11-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01843087","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-11-15 00:00:00","source_office":"3KSS001","mcmis_add_date":"2024-11-18 21:41:00","insp_carrier_name":"BERAN EXCAVATING LLC","insp_carrier_street":"8401 E OAK KNOLL ST","insp_carrier_city":"WICHITA","insp_carrier_state":"KS","insp_carrier_zip_code":"67207","insp_colonia":null,"docket_number":"667773","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:46:47.000000Z","updated_at":"2025-03-17T20:46:47.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11646763,"change_date":"2024-11-18 21:41:00","inspection_id":"83184659","insp_unit_id":"203935019","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"156","insp_unit_license":"646035","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"1NPCLPEX4FD283094","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:43:42.000000Z","updated_at":"2025-03-17T23:43:42.000000Z"}]},{"id":6863815,"change_date":"2024-10-04 21:40:00","inspection_id":"82806096","dot_number":"1843087","report_state":"KS","report_number":"HP02350499","insp_date":"2024-09-30 00:00:00","insp_start_time":"1315","insp_end_time":"1331","registration_date":null,"region":"CT","ci_status_code":"C","location":"SG","location_desc":"WICHITA","county_code_state":"KS","county_code":"173","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":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-10-01 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"72000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1340243","transaction_code":"C","transaction_date":"2024-09-30 00:00:00","upload_date":"2024-10-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01843087","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-09-30 00:00:00","source_office":"3KSS001","mcmis_add_date":"2024-10-01 21:42:00","insp_carrier_name":"BERAN EXCAVATING LLC","insp_carrier_street":"8401 E OAK KNOLL ST","insp_carrier_city":"WICHITA","insp_carrier_state":"KS","insp_carrier_zip_code":"67207","insp_colonia":null,"docket_number":"667773","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:39:23.000000Z","updated_at":"2025-03-17T20:39:23.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11068941,"change_date":"2024-10-04 21:40:00","inspection_id":"82806096","insp_unit_id":"203274733","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"156","insp_unit_license":"646035","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"1NPCLPEX4FD283094","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:37:37.000000Z","updated_at":"2025-03-17T23:37:37.000000Z"}]},{"id":6721695,"change_date":"2024-09-13 21:42:00","inspection_id":"82654668","dot_number":"1843087","report_state":"KS","report_number":"HP03580078","insp_date":"2024-09-12 00:00:00","insp_start_time":"1040","insp_end_time":"1128","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"NB I235 MP 14","county_code_state":"KS","county_code":"173","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"649305","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-13 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"72000","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":"1337463","transaction_code":"A","transaction_date":"2024-09-12 00:00:00","upload_date":"2024-09-13 00:00:00","upload_first_byte":"0","upload_dot_number":"01843087","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-09-12 00:00:00","source_office":"3KSS001","mcmis_add_date":"2024-09-13 21:42:00","insp_carrier_name":"BERAN EXCAVATING LLC","insp_carrier_street":"8401 E OAK KNOLL ST","insp_carrier_city":"WICHITA","insp_carrier_state":"KS","insp_carrier_zip_code":"67207","insp_colonia":null,"docket_number":"667773","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:36:28.000000Z","updated_at":"2025-03-17T20:36:28.000000Z","inspection_violations":[{"id":10463939,"change_date":"2024-09-13 21:42:00","inspection_id":"82654668","insp_violation_id":"261790754","seq_no":"1","part_no":"393","part_no_section":"205(c)","insp_viol_unit":"1","insp_unit_id":"202914552","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:56:42.000000Z","updated_at":"2025-03-17T21:56:42.000000Z","normalized_code":"393205C"}],"inspection_per_units":[{"id":10838402,"change_date":"2024-09-13 21:42:00","inspection_id":"82654668","insp_unit_id":"202914552","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"156","insp_unit_license":"646035","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"1NPCLPEX4FD283094","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:35:13.000000Z","updated_at":"2025-03-17T23:35:13.000000Z"}]},{"id":6680063,"change_date":"2024-09-09 21:40:00","inspection_id":"82610527","dot_number":"1843087","report_state":"KS","report_number":"HP01480314","insp_date":"2024-09-06 00:00:00","insp_start_time":"1036","insp_end_time":"1050","registration_date":null,"region":"CT","ci_status_code":"C","location":"FWY","location_desc":"WICHITA","county_code_state":"KS","county_code":"173","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-09 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"82000","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":"1336681","transaction_code":"A","transaction_date":"2024-09-06 00:00:00","upload_date":"2024-09-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01843087","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-09-06 00:00:00","source_office":"3KSS001","mcmis_add_date":"2024-09-09 21:40:00","insp_carrier_name":"BERAN EXCAVATING LLC","insp_carrier_street":"8401 E OAK KNOLL ST","insp_carrier_city":"WICHITA","insp_carrier_state":"KS","insp_carrier_zip_code":"67207","insp_colonia":null,"docket_number":"667773","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:35:36.000000Z","updated_at":"2025-03-17T20:35:36.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10770502,"change_date":"2024-09-09 21:40:00","inspection_id":"82610527","insp_unit_id":"202826730","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"169","insp_unit_license":"548149","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"1NKZXPTX4HJ148421","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:34:32.000000Z","updated_at":"2025-03-17T23:34:32.000000Z"}]},{"id":6680067,"change_date":"2024-09-09 21:40:00","inspection_id":"82610531","dot_number":"1843087","report_state":"KS","report_number":"HP03920712","insp_date":"2024-09-06 00:00:00","insp_start_time":"1400","insp_end_time":"1410","registration_date":null,"region":"CT","ci_status_code":"C","location":"SG","location_desc":"SEDGWICK COUNTY - 173","county_code_state":"KS","county_code":"173","insp_level_id":"3","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-09 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"58000","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":"1336876","transaction_code":"A","transaction_date":"2024-09-06 00:00:00","upload_date":"2024-09-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01843087","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-09-06 00:00:00","source_office":"3KSS001","mcmis_add_date":"2024-09-09 21:40:00","insp_carrier_name":"BERAN EXCAVATING LLC","insp_carrier_street":"8401 E OAK KNOLL ST","insp_carrier_city":"WICHITA","insp_carrier_state":"KS","insp_carrier_zip_code":"67207","insp_colonia":null,"docket_number":"667773","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:35:36.000000Z","updated_at":"2025-03-17T20:35:36.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10770509,"change_date":"2024-09-09 21:40:00","inspection_id":"82610531","insp_unit_id":"202826737","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"151","insp_unit_license":"547131","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"1HTWXAHT36J238568","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:34:32.000000Z","updated_at":"2025-03-17T23:34:32.000000Z"}]},{"id":6666996,"change_date":"2024-09-24 21:41:00","inspection_id":"82596561","dot_number":"1843087","report_state":"OK","report_number":"M700000190","insp_date":"2024-09-05 00:00:00","insp_start_time":"1714","insp_end_time":"1740","registration_date":"2024-09-24 00:00:00","region":"CT","ci_status_code":"C","location":"027081","location_desc":"US81\/JEFFERSON","county_code_state":"OK","county_code":"053","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"M\/C","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-09-06 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"56000","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":"760420","transaction_code":"C","transaction_date":"2024-09-06 00:00:00","upload_date":"2024-09-24 00:00:00","upload_first_byte":"0","upload_dot_number":"01843087","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-09-05 00:00:00","source_office":"2OKS001","mcmis_add_date":"2024-09-06 21:41:00","insp_carrier_name":"BERAN EXCAVATING LLC","insp_carrier_street":"8401 E OAK KNOLL ST","insp_carrier_city":"WICHITA","insp_carrier_state":"KS","insp_carrier_zip_code":"67207","insp_colonia":null,"docket_number":"667773","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:35:13.000000Z","updated_at":"2025-03-17T20:35:13.000000Z","inspection_violations":[{"id":10374951,"change_date":"2024-09-24 21:41:00","inspection_id":"82596561","insp_violation_id":"262005877","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":null,"created_at":"2025-03-17T21:56:14.000000Z","updated_at":"2025-03-17T21:56:14.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10749189,"change_date":"2024-09-24 21:41:00","inspection_id":"82596561","insp_unit_id":"203105342","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"205","insp_unit_license":"698385","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"1FVACWDT1EHFU4557","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:34:17.000000Z","updated_at":"2025-03-17T23:34:17.000000Z"},{"id":10749190,"change_date":"2024-09-24 21:41:00","inspection_id":"82596561","insp_unit_id":"203105343","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LMR","insp_unit_company":"89","insp_unit_license":"181446","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"5RVFG3220PP120135","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:34:17.000000Z","updated_at":"2025-03-17T23:34:17.000000Z"}]},{"id":6423571,"change_date":"2024-08-08 21:42:00","inspection_id":"82337089","dot_number":"1843087","report_state":"KS","report_number":"HP02750494","insp_date":"2024-08-07 00:00:00","insp_start_time":"1055","insp_end_time":"1130","registration_date":null,"region":"CT","ci_status_code":"C","location":"SG","location_desc":"SEDGWICK COUNTY - 173","county_code_state":"KS","county_code":"173","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CENTRAL SAND","shipping_paper_number":"645478","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":"2024-08-08 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"58000","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":"1333687","transaction_code":"A","transaction_date":"2024-08-07 00:00:00","upload_date":"2024-08-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01843087","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-08-07 00:00:00","source_office":"3KSS001","mcmis_add_date":"2024-08-08 21:42:00","insp_carrier_name":"BERAN EXCAVATING LLC","insp_carrier_street":"8401 E OAK KNOLL ST","insp_carrier_city":"WICHITA","insp_carrier_state":"KS","insp_carrier_zip_code":"67207","insp_colonia":null,"docket_number":"667773","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:30:16.000000Z","updated_at":"2025-03-17T20:30:16.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10352554,"change_date":"2024-08-08 21:42:00","inspection_id":"82337089","insp_unit_id":"202302640","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"151","insp_unit_license":"547131","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"1HTWXAHT36J238568","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:30:18.000000Z","updated_at":"2025-03-17T23:30:18.000000Z"}]},{"id":6242535,"change_date":"2024-07-17 21:41:00","inspection_id":"82143358","dot_number":"1843087","report_state":"KS","report_number":"HP03920655","insp_date":"2024-07-16 00:00:00","insp_start_time":"0806","insp_end_time":"0818","registration_date":null,"region":"CT","ci_status_code":"C","location":"SG","location_desc":"SEDGWICK COUNTY - 173","county_code_state":"KS","county_code":"173","insp_level_id":"3","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-07-17 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"1331712","transaction_code":"A","transaction_date":"2024-07-16 00:00:00","upload_date":"2024-07-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01843087","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-07-16 00:00:00","source_office":"3KSS001","mcmis_add_date":"2024-07-17 21:41:00","insp_carrier_name":"BERAN EXCAVATING LLC","insp_carrier_street":"8401 E OAK KNOLL ST","insp_carrier_city":"WICHITA","insp_carrier_state":"KS","insp_carrier_zip_code":"67207","insp_colonia":null,"docket_number":"667773","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:26:35.000000Z","updated_at":"2025-03-17T20:26:35.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10058094,"change_date":"2024-07-17 21:41:00","inspection_id":"82143358","insp_unit_id":"201933910","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"200","insp_unit_license":"682034","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"1NPCLP0X1LD686744","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:27:12.000000Z","updated_at":"2025-03-17T23:27:12.000000Z"}]},{"id":6038900,"change_date":"2024-06-20 21:43:00","inspection_id":"81924452","dot_number":"1843087","report_state":"KS","report_number":"HP00940481","insp_date":"2024-06-18 00:00:00","insp_start_time":"1044","insp_end_time":"1116","registration_date":null,"region":"CT","ci_status_code":"C","location":"SG","location_desc":"SEDGWICK COUNTY - 173","county_code_state":"KS","county_code":"173","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-06-20 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"82000","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":"1328544","transaction_code":"A","transaction_date":"2024-06-18 00:00:00","upload_date":"2024-06-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01843087","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-06-18 00:00:00","source_office":"3KSS001","mcmis_add_date":"2024-06-20 21:43:00","insp_carrier_name":"BERAN EXCAVATING LLC","insp_carrier_street":"8401 E OAK KNOLL ST","insp_carrier_city":"WICHITA","insp_carrier_state":"KS","insp_carrier_zip_code":"67207","insp_colonia":null,"docket_number":"667773","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:22:18.000000Z","updated_at":"2025-03-17T20:22:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9726417,"change_date":"2024-06-20 21:43:00","inspection_id":"81924452","insp_unit_id":"201510368","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"169","insp_unit_license":"548149","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"1NKZXPTX4HJ148421","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:23:47.000000Z","updated_at":"2025-03-17T23:23:47.000000Z"}]},{"id":6018327,"change_date":"2024-06-18 21:42:00","inspection_id":"81902212","dot_number":"1843087","report_state":"KS","report_number":"HP02710024","insp_date":"2024-06-17 00:00:00","insp_start_time":"1059","insp_end_time":"1122","registration_date":null,"region":"CT","ci_status_code":"C","location":"FWY","location_desc":"NB","county_code_state":"KS","county_code":"173","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-06-18 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"82000","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":"1328209","transaction_code":"A","transaction_date":"2024-06-17 00:00:00","upload_date":"2024-06-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01843087","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-06-17 00:00:00","source_office":"3KSS001","mcmis_add_date":"2024-06-18 21:42:00","insp_carrier_name":"BERAN EXCAVATING LLC","insp_carrier_street":"8401 E OAK KNOLL ST","insp_carrier_city":"WICHITA","insp_carrier_state":"KS","insp_carrier_zip_code":"67207","insp_colonia":null,"docket_number":"667773","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:21:55.000000Z","updated_at":"2025-03-17T20:21:55.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9693325,"change_date":"2024-06-18 21:42:00","inspection_id":"81902212","insp_unit_id":"201468500","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"169","insp_unit_license":"548149","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"1NKZXPTX4HJ148421","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:23:27.000000Z","updated_at":"2025-03-17T23:23:27.000000Z"}]},{"id":5755629,"change_date":"2024-05-15 21:43:00","inspection_id":"81617218","dot_number":"1843087","report_state":"KS","report_number":"HP01480304","insp_date":"2024-05-14 00:00:00","insp_start_time":"1231","insp_end_time":"1245","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"WICHITA","county_code_state":"KS","county_code":"173","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-05-15 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"82000","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":"1324851","transaction_code":"A","transaction_date":"2024-05-14 00:00:00","upload_date":"2024-05-15 00:00:00","upload_first_byte":"0","upload_dot_number":"01843087","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-05-14 00:00:00","source_office":"3KSS001","mcmis_add_date":"2024-05-15 21:43:00","insp_carrier_name":"BERAN EXCAVATING LLC","insp_carrier_street":"8401 E OAK KNOLL ST","insp_carrier_city":"WICHITA","insp_carrier_state":"KS","insp_carrier_zip_code":"67207","insp_colonia":null,"docket_number":"667773","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:16:43.000000Z","updated_at":"2025-03-17T20:16:43.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9270401,"change_date":"2024-05-15 21:43:00","inspection_id":"81617218","insp_unit_id":"200906467","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"169","insp_unit_license":"548149","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"1NKZXPTX4HJ148421","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:19:18.000000Z","updated_at":"2025-03-17T23:19:18.000000Z"}]},{"id":5360322,"change_date":"2024-03-25 21:41:00","inspection_id":"81186459","dot_number":"1843087","report_state":"KS","report_number":"HP01480298","insp_date":"2024-03-22 00:00:00","insp_start_time":"1412","insp_end_time":"1425","registration_date":null,"region":"CT","ci_status_code":"C","location":"FWY","location_desc":"WICHITA","county_code_state":"KS","county_code":"173","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"629754","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-03-25 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"82000","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":"1319728","transaction_code":"A","transaction_date":"2024-03-22 00:00:00","upload_date":"2024-03-25 00:00:00","upload_first_byte":"0","upload_dot_number":"01843087","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-03-22 00:00:00","source_office":"3KSS001","mcmis_add_date":"2024-03-25 21:41:00","insp_carrier_name":"BERAN EXCAVATING LLC","insp_carrier_street":"8401 E OAK KNOLL ST","insp_carrier_city":"WICHITA","insp_carrier_state":"KS","insp_carrier_zip_code":"67207","insp_colonia":null,"docket_number":"667773","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:09:00.000000Z","updated_at":"2025-03-17T20:09:00.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8632532,"change_date":"2024-03-25 21:41:00","inspection_id":"81186459","insp_unit_id":"200070305","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"169","insp_unit_license":"548149","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"1NKZXPTX4HJ148421","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:13:17.000000Z","updated_at":"2025-03-17T23:13:17.000000Z"}]},{"id":5338921,"change_date":"2024-03-21 21:41:00","inspection_id":"81163193","dot_number":"1843087","report_state":"KS","report_number":"HP00940466","insp_date":"2024-03-20 00:00:00","insp_start_time":"1141","insp_end_time":"1213","registration_date":null,"region":"CT","ci_status_code":"C","location":"SG","location_desc":"SEDGWICK COUNTY - 173","county_code_state":"KS","county_code":"173","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-03-21 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"58000","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":"1319209","transaction_code":"A","transaction_date":"2024-03-20 00:00:00","upload_date":"2024-03-21 00:00:00","upload_first_byte":"0","upload_dot_number":"01843087","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-03-20 00:00:00","source_office":"3KSS001","mcmis_add_date":"2024-03-21 21:41:00","insp_carrier_name":"BERAN EXCAVATING LLC","insp_carrier_street":"8401 E OAK KNOLL ST","insp_carrier_city":"WICHITA","insp_carrier_state":"KS","insp_carrier_zip_code":"67207","insp_colonia":null,"docket_number":"667773","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:08:20.000000Z","updated_at":"2025-03-17T20:08:20.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8598123,"change_date":"2024-03-21 21:41:00","inspection_id":"81163193","insp_unit_id":"200026099","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"151","insp_unit_license":"547131","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"1HTWXAHT36J238568","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:12:58.000000Z","updated_at":"2025-03-17T23:12:58.000000Z"}]},{"id":5234364,"change_date":"2024-03-07 21:39:00","inspection_id":"81049180","dot_number":"1843087","report_state":"KS","report_number":"HP03580052","insp_date":"2024-03-06 00:00:00","insp_start_time":"1524","insp_end_time":"1545","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"WB K096 MP 285","county_code_state":"KS","county_code":"173","insp_level_id":"2","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":"2024-03-07 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"1317841","transaction_code":"A","transaction_date":"2024-03-06 00:00:00","upload_date":"2024-03-07 00:00:00","upload_first_byte":"0","upload_dot_number":"01843087","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-03-06 00:00:00","source_office":"3KSS001","mcmis_add_date":"2024-03-07 21:39:00","insp_carrier_name":"BERAN EXCAVATING LLC","insp_carrier_street":"8401 E OAK KNOLL ST","insp_carrier_city":"WICHITA","insp_carrier_state":"KS","insp_carrier_zip_code":"67207","insp_colonia":null,"docket_number":"667773","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:06:14.000000Z","updated_at":"2025-03-17T20:06:14.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8428674,"change_date":"2024-03-07 21:39:00","inspection_id":"81049180","insp_unit_id":"199804666","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"200","insp_unit_license":"682034","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"1NPCLP0X1LD686744","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:22.000000Z","updated_at":"2025-03-17T23:11:22.000000Z"}]},{"id":5234365,"change_date":"2024-03-07 21:39:00","inspection_id":"81049181","dot_number":"1843087","report_state":"KS","report_number":"HP03580053","insp_date":"2024-03-06 00:00:00","insp_start_time":"1606","insp_end_time":"1632","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"WB K096 MP 284","county_code_state":"KS","county_code":"173","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-03-07 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","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":"1317842","transaction_code":"A","transaction_date":"2024-03-06 00:00:00","upload_date":"2024-03-07 00:00:00","upload_first_byte":"0","upload_dot_number":"01843087","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-03-06 00:00:00","source_office":"3KSS001","mcmis_add_date":"2024-03-07 21:39:00","insp_carrier_name":"BERAN EXCAVATING LLC","insp_carrier_street":"8401 E OAK KNOLL ST","insp_carrier_city":"WICHITA","insp_carrier_state":"KS","insp_carrier_zip_code":"67207","insp_colonia":null,"docket_number":"667773","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:06:14.000000Z","updated_at":"2025-03-17T20:06:14.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8428675,"change_date":"2024-03-07 21:39:00","inspection_id":"81049181","insp_unit_id":"199804667","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"167","insp_unit_license":"671281","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"1XPFDB9X67N681173","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:22.000000Z","updated_at":"2025-03-17T23:11:22.000000Z"},{"id":8428676,"change_date":"2024-03-07 21:39:00","inspection_id":"81049181","insp_unit_id":"199804668","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MNTR","insp_unit_company":"41","insp_unit_license":"554309","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"5MC5153205P004948","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:22.000000Z","updated_at":"2025-03-17T23:11:22.000000Z"}]},{"id":5136936,"change_date":"2024-02-26 21:42:00","inspection_id":"80943023","dot_number":"1843087","report_state":"KS","report_number":"HP04740161","insp_date":"2024-02-23 00:00:00","insp_start_time":"1359","insp_end_time":"1423","registration_date":null,"region":"CT","ci_status_code":"C","location":"BU","location_desc":"BUTLER COUNTY - 015","county_code_state":"KS","county_code":"015","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-02-26 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","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":"1316620","transaction_code":"A","transaction_date":"2024-02-23 00:00:00","upload_date":"2024-02-26 00:00:00","upload_first_byte":"0","upload_dot_number":"01843087","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2024-02-23 00:00:00","source_office":"3KSS001","mcmis_add_date":"2024-02-26 21:42:00","insp_carrier_name":"BERAN EXCAVATING LLC","insp_carrier_street":"8401 E OAK KNOLL ST","insp_carrier_city":"WICHITA","insp_carrier_state":"KS","insp_carrier_zip_code":"67207","insp_colonia":null,"docket_number":"667773","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:04:15.000000Z","updated_at":"2025-03-17T20:04:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8270694,"change_date":"2024-02-26 21:42:00","inspection_id":"80943023","insp_unit_id":"199602482","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"175","insp_unit_license":"723201","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"1XPCDP9X3HD440100","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:09:58.000000Z","updated_at":"2025-03-17T23:09:58.000000Z"},{"id":8270695,"change_date":"2024-02-26 21:42:00","inspection_id":"80943023","insp_unit_id":"199602483","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRVS","insp_unit_company":"43","insp_unit_license":"557045","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"48X2E2823A1006977","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:09:58.000000Z","updated_at":"2025-03-17T23:09:58.000000Z"}]},{"id":5041431,"change_date":"2024-08-20 21:42:00","inspection_id":"80838669","dot_number":"1843087","report_state":"KS","report_number":"HP02750453","insp_date":"2024-02-12 00:00:00","insp_start_time":"1022","insp_end_time":"1110","registration_date":"2024-02-20 00:00:00","region":"CT","ci_status_code":"C","location":"SG","location_desc":"SEDGWICK COUNTY - 173","county_code_state":"KS","county_code":"173","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"EMPTY","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":"2024-02-13 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1315473","transaction_code":"C","transaction_date":"2024-08-20 00:00:00","upload_date":"2024-08-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01843087","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-02-12 00:00:00","source_office":"3KSS001","mcmis_add_date":"2024-02-13 21:42:00","insp_carrier_name":"BERAN EXCAVATING LLC","insp_carrier_street":"8401 E OAK KNOLL ST","insp_carrier_city":"WICHITA","insp_carrier_state":"KS","insp_carrier_zip_code":"67207","insp_colonia":null,"docket_number":"667773","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:02:42.000000Z","updated_at":"2025-03-17T20:02:42.000000Z","inspection_violations":[{"id":7768741,"change_date":"2024-08-20 21:42:00","inspection_id":"80838669","insp_violation_id":"261296095","seq_no":"1","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"202488955","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:33.000000Z","updated_at":"2025-03-17T21:43:33.000000Z","normalized_code":"39395F"},{"id":7768742,"change_date":"2024-08-20 21:42:00","inspection_id":"80838669","insp_violation_id":"261296096","seq_no":"2","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-03-17T21:43:33.000000Z","updated_at":"2025-03-17T21:43:33.000000Z","normalized_code":"3928"}],"inspection_per_units":[{"id":8115279,"change_date":"2024-08-20 21:42:00","inspection_id":"80838669","insp_unit_id":"202488955","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"234","insp_unit_license":"721261","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"1XP5DU9X46D653299","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:08:33.000000Z","updated_at":"2025-03-17T23:08:33.000000Z"},{"id":8115280,"change_date":"2024-08-20 21:42:00","inspection_id":"80838669","insp_unit_id":"202488956","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OT","insp_unit_company":"82","insp_unit_license":"680","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"5TU24282XNS000154","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:08:33.000000Z","updated_at":"2025-03-17T23:08:33.000000Z"}]},{"id":4997772,"change_date":"2024-02-12 21:41:00","inspection_id":"80790903","dot_number":"1843087","report_state":"KS","report_number":"HP92191841","insp_date":"2024-02-06 00:00:00","insp_start_time":"0745","insp_end_time":"0810","registration_date":"2024-02-12 00:00:00","region":"CT","ci_status_code":"C","location":"SG","location_desc":"SEDGWICK COUNTY - 173","county_code_state":"KS","county_code":"173","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"N\/A","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-02-07 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"2","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1314932","transaction_code":"C","transaction_date":"2024-02-12 00:00:00","upload_date":"2024-02-12 00:00:00","upload_first_byte":"0","upload_dot_number":"01843087","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-02-06 00:00:00","source_office":"3KSS001","mcmis_add_date":"2024-02-07 21:41:00","insp_carrier_name":"BERAN EXCAVATING LLC","insp_carrier_street":"8401 E OAK KNOLL ST","insp_carrier_city":"WICHITA","insp_carrier_state":"KS","insp_carrier_zip_code":"67207","insp_colonia":null,"docket_number":"667773","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:01:40.000000Z","updated_at":"2025-03-17T20:01:40.000000Z","inspection_violations":[{"id":7697983,"change_date":"2024-02-12 21:41:00","inspection_id":"80790903","insp_violation_id":"257787758","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":null,"created_at":"2025-03-17T21:43:09.000000Z","updated_at":"2025-03-17T21:43:09.000000Z","normalized_code":"3922"},{"id":7697984,"change_date":"2024-02-12 21:41:00","inspection_id":"80790903","insp_violation_id":"257787759","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"42","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"NA01901701","created_at":"2025-03-17T21:43:09.000000Z","updated_at":"2025-03-17T21:43:09.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8044121,"change_date":"2024-02-12 21:41:00","inspection_id":"80790903","insp_unit_id":"199379638","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"200","insp_unit_license":"682034","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"1NPCLP0X1LD686744","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:07:53.000000Z","updated_at":"2025-03-17T23:07:53.000000Z"}]},{"id":4527860,"change_date":"2023-12-01 21:42:00","inspection_id":"80276571","dot_number":"1843087","report_state":"KS","report_number":"HP03580035","insp_date":"2023-11-29 00:00:00","insp_start_time":"1121","insp_end_time":"1145","registration_date":"2023-12-01 00:00:00","region":"CT","ci_status_code":"C","location":null,"location_desc":"WB K096 MP 284","county_code_state":"KS","county_code":"173","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-11-30 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"58000","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":"1309512","transaction_code":"C","transaction_date":"2023-11-29 00:00:00","upload_date":"2023-12-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01843087","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-11-29 00:00:00","source_office":"3KSS001","mcmis_add_date":"2023-11-30 21:38:00","insp_carrier_name":"BERAN EXCAVATING LLC","insp_carrier_street":"8401 E OAK KNOLL ST","insp_carrier_city":"WICHITA","insp_carrier_state":"KS","insp_carrier_zip_code":"67207","insp_colonia":null,"docket_number":"667773","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:52:34.000000Z","updated_at":"2025-03-17T19:52:34.000000Z","inspection_violations":[{"id":7005771,"change_date":"2023-12-01 21:42:00","inspection_id":"80276571","insp_violation_id":"256667322","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"198308588","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:48.000000Z","updated_at":"2025-03-17T21:39:48.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":7282108,"change_date":"2023-12-01 21:42:00","inspection_id":"80276571","insp_unit_id":"198308588","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"151","insp_unit_license":"547131","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"1HTWXAHT36J238568","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:10.000000Z","updated_at":"2025-03-17T23:01:10.000000Z"}]},{"id":4383556,"change_date":"2023-11-08 21:41:00","inspection_id":"80117777","dot_number":"1843087","report_state":"KS","report_number":"HP02380322","insp_date":"2023-11-06 00:00:00","insp_start_time":"0946","insp_end_time":"0958","registration_date":null,"region":"CT","ci_status_code":"C","location":"SG","location_desc":"SEDGWICK COUNTY - 173","county_code_state":"KS","county_code":"173","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"BERAN EXCAVATING","shipping_paper_number":"616615","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-11-08 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"82000","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":"1307206","transaction_code":"A","transaction_date":"2023-11-06 00:00:00","upload_date":"2023-11-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01843087","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-11-06 00:00:00","source_office":"3KSS001","mcmis_add_date":"2023-11-08 21:41:00","insp_carrier_name":"BERAN EXCAVATING LLC","insp_carrier_street":"8401 E OAK KNOLL ST","insp_carrier_city":"WICHITA","insp_carrier_state":"KS","insp_carrier_zip_code":"67207","insp_colonia":null,"docket_number":"667773","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:49:50.000000Z","updated_at":"2025-03-17T19:49:50.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7049786,"change_date":"2023-11-08 21:41:00","inspection_id":"80117777","insp_unit_id":"197969930","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"169","insp_unit_license":"548149","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"1NKZXPTX4HJ148421","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:59:10.000000Z","updated_at":"2025-03-17T22:59:10.000000Z"}]},{"id":4361987,"change_date":"2023-11-06 21:42:00","inspection_id":"80093582","dot_number":"1843087","report_state":"KS","report_number":"HP03920491","insp_date":"2023-11-01 00:00:00","insp_start_time":"1328","insp_end_time":"1345","registration_date":null,"region":"CT","ci_status_code":"C","location":"SG","location_desc":"SEDGWICK COUNTY - 173","county_code_state":"KS","county_code":"173","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-11-06 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"1306683","transaction_code":"A","transaction_date":"2023-11-01 00:00:00","upload_date":"2023-11-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01843087","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-11-01 00:00:00","source_office":"3KSS001","mcmis_add_date":"2023-11-06 21:42:00","insp_carrier_name":"BERAN EXCAVATING LLC","insp_carrier_street":"8401 E OAK KNOLL ST","insp_carrier_city":"WICHITA","insp_carrier_state":"KS","insp_carrier_zip_code":"67207","insp_colonia":null,"docket_number":"667773","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:49:29.000000Z","updated_at":"2025-03-17T19:49:29.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7015294,"change_date":"2023-11-06 21:42:00","inspection_id":"80093582","insp_unit_id":"197922516","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"200","insp_unit_license":"682034","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"1NPCLP0X1LD686744","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:54.000000Z","updated_at":"2025-03-17T22:58:54.000000Z"}]},{"id":4205424,"change_date":"2023-10-16 21:43:00","inspection_id":"79920656","dot_number":"1843087","report_state":"KS","report_number":"HP01762510","insp_date":"2023-10-13 00:00:00","insp_start_time":"1346","insp_end_time":"1402","registration_date":null,"region":"CT","ci_status_code":"C","location":"WL","location_desc":"WILSON COUNTY - 205","county_code_state":"KS","county_code":"205","insp_level_id":"3","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-10-16 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"1305286","transaction_code":"A","transaction_date":"2023-10-13 00:00:00","upload_date":"2023-10-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01843087","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-10-13 00:00:00","source_office":"3KSS001","mcmis_add_date":"2023-10-16 21:43:00","insp_carrier_name":"BERAN EXCAVATING LLC","insp_carrier_street":"8401 E OAK KNOLL ST","insp_carrier_city":"WICHITA","insp_carrier_state":"KS","insp_carrier_zip_code":"67207","insp_colonia":null,"docket_number":"667773","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:46:13.000000Z","updated_at":"2025-03-17T19:46:13.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6762877,"change_date":"2023-10-16 21:43:00","inspection_id":"79920656","insp_unit_id":"197574384","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"174","insp_unit_license":"718525","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"1XPWD49X1FD237862","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:41.000000Z","updated_at":"2025-03-17T22:56:41.000000Z"},{"id":6762878,"change_date":"2023-10-16 21:43:00","inspection_id":"79920656","insp_unit_id":"197574385","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRVS","insp_unit_company":null,"insp_unit_license":"181355","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"48X1F2829A1006877","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:41.000000Z","updated_at":"2025-03-17T22:56:41.000000Z"}]},{"id":3983950,"change_date":"2023-09-15 21:40:00","inspection_id":"79674951","dot_number":"1843087","report_state":"KS","report_number":"HP03920460","insp_date":"2023-09-15 00:00:00","insp_start_time":"1354","insp_end_time":"1405","registration_date":null,"region":"CT","ci_status_code":"C","location":"SG","location_desc":"SEDGWICK COUNTY - 173","county_code_state":"KS","county_code":"173","insp_level_id":"3","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-09-15 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"1301683","transaction_code":"A","transaction_date":"2023-09-15 00:00:00","upload_date":"2023-09-15 00:00:00","upload_first_byte":"0","upload_dot_number":"01843087","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-09-15 00:00:00","source_office":"3KSS001","mcmis_add_date":"2023-09-15 21:40:00","insp_carrier_name":"BERAN EXCAVATING LLC","insp_carrier_street":"8401 E OAK KNOLL ST","insp_carrier_city":"WICHITA","insp_carrier_state":"KS","insp_carrier_zip_code":"67207","insp_colonia":null,"docket_number":"667773","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:41:36.000000Z","updated_at":"2025-03-17T19:41:36.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6406036,"change_date":"2023-09-15 21:40:00","inspection_id":"79674951","insp_unit_id":"197080647","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"200","insp_unit_license":"682034","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"1NPCLP0X1LD686744","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:48.000000Z","updated_at":"2025-03-17T22:53:48.000000Z"}]},{"id":3955136,"change_date":"2023-09-18 21:38:00","inspection_id":"79642996","dot_number":"1843087","report_state":"KS","report_number":"HP01762449","insp_date":"2023-09-11 00:00:00","insp_start_time":"1322","insp_end_time":"1415","registration_date":"2023-09-18 00:00:00","region":"CT","ci_status_code":"C","location":"WL","location_desc":"WILSON COUNTY - 205","county_code_state":"KS","county_code":"205","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-09-12 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"128000","viol_total":"8","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"8","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1301067","transaction_code":"C","transaction_date":"2023-09-18 00:00:00","upload_date":"2023-09-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01843087","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-09-11 00:00:00","source_office":"3KSS001","mcmis_add_date":"2023-09-12 21:40:00","insp_carrier_name":"BERAN EXCAVATING LLC","insp_carrier_street":"8401 E OAK KNOLL ST","insp_carrier_city":"WICHITA","insp_carrier_state":"KS","insp_carrier_zip_code":"67207","insp_colonia":null,"docket_number":"667773","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:40:51.000000Z","updated_at":"2025-03-17T19:40:51.000000Z","inspection_violations":[{"id":6115159,"change_date":"2023-09-18 21:38:00","inspection_id":"79642996","insp_violation_id":"255318950","seq_no":"1","part_no":"393","part_no_section":"60(d)","insp_viol_unit":"1","insp_unit_id":"197098278","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:32.000000Z","updated_at":"2025-03-17T21:35:32.000000Z","normalized_code":"39360D"},{"id":6115160,"change_date":"2023-09-18 21:38:00","inspection_id":"79642996","insp_violation_id":"255318951","seq_no":"2","part_no":"396","part_no_section":"9(d)(2)","insp_viol_unit":"1","insp_unit_id":"197098278","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:32.000000Z","updated_at":"2025-03-17T21:35:32.000000Z","normalized_code":"3969D2"},{"id":6115161,"change_date":"2023-09-18 21:38:00","inspection_id":"79642996","insp_violation_id":"255318952","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"197098278","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:32.000000Z","updated_at":"2025-03-17T21:35:32.000000Z","normalized_code":"3922"},{"id":6115162,"change_date":"2023-09-18 21:38:00","inspection_id":"79642996","insp_violation_id":"255318953","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"197098278","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:32.000000Z","updated_at":"2025-03-17T21:35:32.000000Z","normalized_code":"3939A"},{"id":6115163,"change_date":"2023-09-18 21:38:00","inspection_id":"79642996","insp_violation_id":"255318954","seq_no":"5","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"2","insp_unit_id":"197098279","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:32.000000Z","updated_at":"2025-03-17T21:35:32.000000Z","normalized_code":"39345B2"},{"id":6115164,"change_date":"2023-09-18 21:38:00","inspection_id":"79642996","insp_violation_id":"255318955","seq_no":"6","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"2","insp_unit_id":"197098279","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:32.000000Z","updated_at":"2025-03-17T21:35:32.000000Z","normalized_code":"39345B2"},{"id":6115165,"change_date":"2023-09-18 21:38:00","inspection_id":"79642996","insp_violation_id":"255318956","seq_no":"7","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"2","insp_unit_id":"197098279","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:32.000000Z","updated_at":"2025-03-17T21:35:32.000000Z","normalized_code":"39345B2"},{"id":6115166,"change_date":"2023-09-18 21:38:00","inspection_id":"79642996","insp_violation_id":"255318957","seq_no":"8","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"2","insp_unit_id":"197098279","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:32.000000Z","updated_at":"2025-03-17T21:35:32.000000Z","normalized_code":"39345B2"}],"inspection_per_units":[{"id":6359547,"change_date":"2023-09-18 21:38:00","inspection_id":"79642996","insp_unit_id":"197098278","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"100","insp_unit_license":"544330","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"1XP5DB9X66D863147","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:24.000000Z","updated_at":"2025-03-17T22:53:24.000000Z"},{"id":6359548,"change_date":"2023-09-18 21:38:00","inspection_id":"79642996","insp_unit_id":"197098279","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EADU","insp_unit_company":null,"insp_unit_license":"554314","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"1E1D1M2857RC41749","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:24.000000Z","updated_at":"2025-03-17T22:53:24.000000Z"}]},{"id":3901570,"change_date":"2023-09-05 21:41:00","inspection_id":"79583475","dot_number":"1843087","report_state":"KS","report_number":"HP00940440","insp_date":"2023-09-01 00:00:00","insp_start_time":"0924","insp_end_time":"0959","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"WICHITA","county_code_state":"KS","county_code":"173","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-09-05 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"1300314","transaction_code":"A","transaction_date":"2023-09-01 00:00:00","upload_date":"2023-09-05 00:00:00","upload_first_byte":"0","upload_dot_number":"01843087","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-09-01 00:00:00","source_office":"3KSS001","mcmis_add_date":"2023-09-05 21:41:00","insp_carrier_name":"BERAN EXCAVATING LLC","insp_carrier_street":"8401 E OAK KNOLL ST","insp_carrier_city":"WICHITA","insp_carrier_state":"KS","insp_carrier_zip_code":"67207","insp_colonia":null,"docket_number":"667773","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:40:03.000000Z","updated_at":"2025-03-17T19:40:03.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6273070,"change_date":"2023-09-05 21:41:00","inspection_id":"79583475","insp_unit_id":"196894086","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"200","insp_unit_license":"682034","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"1NPCLP0X1LD686744","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:52:42.000000Z","updated_at":"2025-03-17T22:52:42.000000Z"}]},{"id":3621185,"change_date":"2023-07-28 21:41:00","inspection_id":"79270093","dot_number":"1843087","report_state":"KS","report_number":"HP01480258","insp_date":"2023-07-27 00:00:00","insp_start_time":"1052","insp_end_time":"1106","registration_date":null,"region":"CT","ci_status_code":"C","location":"HWY","location_desc":"WICHITA","county_code_state":"KS","county_code":"173","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-07-28 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"72000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1296962","transaction_code":"A","transaction_date":"2023-07-27 00:00:00","upload_date":"2023-07-28 00:00:00","upload_first_byte":"0","upload_dot_number":"01843087","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-07-27 00:00:00","source_office":"3KSS001","mcmis_add_date":"2023-07-28 21:41:00","insp_carrier_name":"BERAN EXCAVATING LLC","insp_carrier_street":"8401 E OAK KNOLL ST","insp_carrier_city":"WICHITA","insp_carrier_state":"KS","insp_carrier_zip_code":"67207","insp_colonia":null,"docket_number":"667773","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:34:31.000000Z","updated_at":"2025-03-17T19:34:31.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5822123,"change_date":"2023-07-28 21:41:00","inspection_id":"79270093","insp_unit_id":"196254408","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"156","insp_unit_license":"646035","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"1NPCLPEX4FD283094","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:58.000000Z","updated_at":"2025-03-17T22:48:58.000000Z"}]},{"id":3478824,"change_date":"2023-07-11 21:41:00","inspection_id":"79110492","dot_number":"1843087","report_state":"KS","report_number":"HP01762346","insp_date":"2023-07-10 00:00:00","insp_start_time":"1349","insp_end_time":"1420","registration_date":null,"region":"CT","ci_status_code":"C","location":"WL","location_desc":"WILSON COUNTY - 205","county_code_state":"KS","county_code":"205","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-07-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"128000","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":"1295450","transaction_code":"A","transaction_date":"2023-07-10 00:00:00","upload_date":"2023-07-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01843087","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-07-10 00:00:00","source_office":"3KSS001","mcmis_add_date":"2023-07-11 21:41:00","insp_carrier_name":"BERAN EXCAVATING LLC","insp_carrier_street":"8401 E OAK KNOLL ST","insp_carrier_city":"WICHITA","insp_carrier_state":"KS","insp_carrier_zip_code":"67207","insp_colonia":null,"docket_number":"667773","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:31:44.000000Z","updated_at":"2025-03-17T19:31:44.000000Z","inspection_violations":[{"id":5363245,"change_date":"2023-07-11 21:41:00","inspection_id":"79110492","insp_violation_id":"253986281","seq_no":"1","part_no":"393","part_no_section":"60(d)","insp_viol_unit":"1","insp_unit_id":"195933725","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:55.000000Z","updated_at":"2025-03-17T21:31:55.000000Z","normalized_code":"39360D"}],"inspection_per_units":[{"id":5593941,"change_date":"2023-07-11 21:41:00","inspection_id":"79110492","insp_unit_id":"195933725","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"100","insp_unit_license":"544330","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"1XP5DB9X66D863147","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:09.000000Z","updated_at":"2025-03-17T22:47:09.000000Z"},{"id":5593942,"change_date":"2023-07-11 21:41:00","inspection_id":"79110492","insp_unit_id":"195933726","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EADU","insp_unit_company":null,"insp_unit_license":"554314","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"1E1D1M2857RC41749","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:47:09.000000Z","updated_at":"2025-03-17T22:47:09.000000Z"}]},{"id":3334050,"change_date":"2023-06-21 21:42:00","inspection_id":"78947688","dot_number":"1843087","report_state":"KS","report_number":"HP01762324","insp_date":"2023-06-20 00:00:00","insp_start_time":"1438","insp_end_time":"1500","registration_date":null,"region":"CT","ci_status_code":"C","location":"WL","location_desc":"WILSON COUNTY - 205","county_code_state":"KS","county_code":"205","insp_level_id":"3","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-06-21 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"1292954","transaction_code":"A","transaction_date":"2023-06-20 00:00:00","upload_date":"2023-06-21 00:00:00","upload_first_byte":"0","upload_dot_number":"01843087","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-06-20 00:00:00","source_office":"3KSS001","mcmis_add_date":"2023-06-21 21:42:00","insp_carrier_name":"BERAN EXCAVATING LLC","insp_carrier_street":"8401 E OAK KNOLL ST","insp_carrier_city":"WICHITA","insp_carrier_state":"KS","insp_carrier_zip_code":"67207","insp_colonia":null,"docket_number":"667773","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:28:56.000000Z","updated_at":"2025-03-17T19:28:56.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5360205,"change_date":"2023-06-21 21:42:00","inspection_id":"78947688","insp_unit_id":"195606211","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"174","insp_unit_license":"718525","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"1XPWD49X1FD237862","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:45:18.000000Z","updated_at":"2025-03-17T22:45:18.000000Z"},{"id":5360206,"change_date":"2023-06-21 21:42:00","inspection_id":"78947688","insp_unit_id":"195606212","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRVS","insp_unit_company":null,"insp_unit_license":"181355","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"48X1F2829A1006877","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:45:18.000000Z","updated_at":"2025-03-17T22:45:18.000000Z"}]},{"id":3323053,"change_date":"2023-06-20 21:41:00","inspection_id":"78935396","dot_number":"1843087","report_state":"KS","report_number":"HP03580022","insp_date":"2023-06-19 00:00:00","insp_start_time":"1154","insp_end_time":"1211","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SB I235 MP 14","county_code_state":"KS","county_code":"173","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-06-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"1292744","transaction_code":"A","transaction_date":"2023-06-19 00:00:00","upload_date":"2023-06-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01843087","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-06-19 00:00:00","source_office":"3KSS001","mcmis_add_date":"2023-06-20 21:41:00","insp_carrier_name":"BERAN EXCAVATING LLC","insp_carrier_street":"8401 E OAK KNOLL ST","insp_carrier_city":"WICHITA","insp_carrier_state":"KS","insp_carrier_zip_code":"67207","insp_colonia":null,"docket_number":"667773","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:28:53.000000Z","updated_at":"2025-03-17T19:28:53.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5341897,"change_date":"2023-06-20 21:41:00","inspection_id":"78935396","insp_unit_id":"195582020","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"200","insp_unit_license":"2020","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"1NPCLP0X1LD686744","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:45:08.000000Z","updated_at":"2025-03-17T22:45:08.000000Z"}]},{"id":3166167,"change_date":"2023-05-30 21:42:00","inspection_id":"78758093","dot_number":"1843087","report_state":"KS","report_number":"HP00940422","insp_date":"2023-05-26 00:00:00","insp_start_time":"1007","insp_end_time":"1045","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"WICHITA","county_code_state":"KS","county_code":"173","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-05-30 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"72000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1290335","transaction_code":"A","transaction_date":"2023-05-26 00:00:00","upload_date":"2023-05-30 00:00:00","upload_first_byte":"0","upload_dot_number":"01843087","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-05-26 00:00:00","source_office":"3KSS001","mcmis_add_date":"2023-05-30 21:42:00","insp_carrier_name":"BERAN EXCAVATING LLC","insp_carrier_street":"8401 E OAK KNOLL ST","insp_carrier_city":"WICHITA","insp_carrier_state":"KS","insp_carrier_zip_code":"67207","insp_colonia":null,"docket_number":"667773","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:25:43.000000Z","updated_at":"2025-03-17T19:25:43.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5092554,"change_date":"2023-05-30 21:42:00","inspection_id":"78758093","insp_unit_id":"195198831","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"156","insp_unit_license":"646035","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"1NPCLPEX4FD283094","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:43:08.000000Z","updated_at":"2025-03-17T22:43:08.000000Z"}]},{"id":3043312,"change_date":"2023-05-15 21:42:00","inspection_id":"78619638","dot_number":"1843087","report_state":"KS","report_number":"HP03550414","insp_date":"2023-05-12 00:00:00","insp_start_time":"0825","insp_end_time":"0840","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"WICHITA","county_code_state":"KS","county_code":"173","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-05-15 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"1288568","transaction_code":"A","transaction_date":"2023-05-12 00:00:00","upload_date":"2023-05-15 00:00:00","upload_first_byte":"0","upload_dot_number":"01843087","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-05-12 00:00:00","source_office":"3KSS001","mcmis_add_date":"2023-05-15 21:42:00","insp_carrier_name":"BERAN EXCAVATING LLC","insp_carrier_street":"8401 E OAK KNOLL ST","insp_carrier_city":"WICHITA","insp_carrier_state":"KS","insp_carrier_zip_code":"67207","insp_colonia":null,"docket_number":"667773","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:23:21.000000Z","updated_at":"2025-03-17T19:23:21.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4895811,"change_date":"2023-05-15 21:42:00","inspection_id":"78619638","insp_unit_id":"194927617","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"200","insp_unit_license":"682034","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"1NPCLP0X1LD686744","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:41:36.000000Z","updated_at":"2025-03-17T22:41:36.000000Z"}]},{"id":3013510,"change_date":"2023-05-10 21:42:00","inspection_id":"78585857","dot_number":"1843087","report_state":"KS","report_number":"HP04472160","insp_date":"2023-05-08 00:00:00","insp_start_time":"1220","insp_end_time":"1235","registration_date":null,"region":"CT","ci_status_code":"C","location":"SG","location_desc":"SEDGWICK COUNTY - 173","county_code_state":"KS","county_code":"173","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":"2023-05-10 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"58000","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":"1288053","transaction_code":"A","transaction_date":"2023-05-08 00:00:00","upload_date":"2023-05-10 00:00:00","upload_first_byte":"0","upload_dot_number":"01843087","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-05-08 00:00:00","source_office":"3KSS001","mcmis_add_date":"2023-05-10 21:42:00","insp_carrier_name":"BERAN EXCAVATING LLC","insp_carrier_street":"8401 E OAK KNOLL ST","insp_carrier_city":"WICHITA","insp_carrier_state":"KS","insp_carrier_zip_code":"67207","insp_colonia":null,"docket_number":"667773","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:22:39.000000Z","updated_at":"2025-03-17T19:22:39.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4848417,"change_date":"2023-05-10 21:42:00","inspection_id":"78585857","insp_unit_id":"194858405","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"151","insp_unit_license":"547131","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"1HTWXAHT36J238568","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:41:12.000000Z","updated_at":"2025-03-17T22:41:12.000000Z"}]},{"id":2634843,"change_date":"2023-03-22 21:42:00","inspection_id":"78156079","dot_number":"1843087","report_state":"KS","report_number":"HP01480233","insp_date":"2023-03-22 00:00:00","insp_start_time":"0722","insp_end_time":"0736","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"WICHITA","county_code_state":"KS","county_code":"173","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-03-22 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"72000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1281900","transaction_code":"A","transaction_date":"2023-03-22 00:00:00","upload_date":"2023-03-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01843087","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-03-22 00:00:00","source_office":"3KSS001","mcmis_add_date":"2023-03-22 21:42:00","insp_carrier_name":"BERAN EXCAVATING LLC","insp_carrier_street":"8401 E OAK KNOLL ST","insp_carrier_city":"WICHITA","insp_carrier_state":"KS","insp_carrier_zip_code":"67207","insp_colonia":null,"docket_number":"667773","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:15:12.000000Z","updated_at":"2025-03-17T19:15:12.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4241572,"change_date":"2023-03-22 21:42:00","inspection_id":"78156079","insp_unit_id":"194004719","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"156","insp_unit_license":"646035","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"1NPCLPEX4FD283094","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:26.000000Z","updated_at":"2025-03-17T22:36:26.000000Z"}]},{"id":2543528,"change_date":"2023-03-09 21:42:00","inspection_id":"78052204","dot_number":"1843087","report_state":"KS","report_number":"HP00940412","insp_date":"2023-03-08 00:00:00","insp_start_time":"1250","insp_end_time":"1327","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"WICHITA","county_code_state":"KS","county_code":"173","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-03-09 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"1280765","transaction_code":"A","transaction_date":"2023-03-08 00:00:00","upload_date":"2023-03-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01843087","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2023-03-08 00:00:00","source_office":"3KSS001","mcmis_add_date":"2023-03-09 21:42:00","insp_carrier_name":"BERAN EXCAVATING LLC","insp_carrier_street":"8401 E OAK KNOLL ST","insp_carrier_city":"WICHITA","insp_carrier_state":"KS","insp_carrier_zip_code":"67207","insp_colonia":null,"docket_number":"667773","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:13:40.000000Z","updated_at":"2025-03-17T19:13:40.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4093903,"change_date":"2023-03-09 21:42:00","inspection_id":"78052204","insp_unit_id":"193792379","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"200","insp_unit_license":"682034","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"1NPCLP0X1LD686744","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:20.000000Z","updated_at":"2025-03-17T22:35:20.000000Z"}]},{"id":2166618,"change_date":"2023-01-25 21:42:00","inspection_id":"77623148","dot_number":"1843087","report_state":"KS","report_number":"HP02750438","insp_date":"2023-01-16 00:00:00","insp_start_time":"1430","insp_end_time":"1500","registration_date":"2023-01-25 00:00:00","region":"CT","ci_status_code":"C","location":null,"location_desc":"WICHITA","county_code_state":"KS","county_code":"173","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"EMPTY","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-01-18 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"58000","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":"1277458","transaction_code":"C","transaction_date":"2023-01-23 00:00:00","upload_date":"2023-01-25 00:00:00","upload_first_byte":"0","upload_dot_number":"01843087","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-01-16 00:00:00","source_office":"3KSS001","mcmis_add_date":"2023-01-18 21:40:00","insp_carrier_name":"BERAN EXCAVATING LLC","insp_carrier_street":"8401 E OAK KNOLL ST","insp_carrier_city":"WICHITA","insp_carrier_state":"KS","insp_carrier_zip_code":"67207","insp_colonia":null,"docket_number":"667773","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:06:36.000000Z","updated_at":"2025-03-17T19:06:36.000000Z","inspection_violations":[{"id":3350530,"change_date":"2023-01-25 21:42:00","inspection_id":"77623148","insp_violation_id":"250775137","seq_no":"1","part_no":"390","part_no_section":"21T(c)","insp_viol_unit":"1","insp_unit_id":"193063284","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:50.000000Z","updated_at":"2025-03-17T21:22:50.000000Z","normalized_code":"39021TC"}],"inspection_per_units":[{"id":3487055,"change_date":"2023-01-25 21:42:00","inspection_id":"77623148","insp_unit_id":"193063284","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"151","insp_unit_license":"547131","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"1HTWXAHT36J238568","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:31:00.000000Z","updated_at":"2025-03-17T22:31:00.000000Z"}]},{"id":2038152,"change_date":"2022-12-29 21:40:00","inspection_id":"77475490","dot_number":"1843087","report_state":"KS","report_number":"HP01480225","insp_date":"2022-12-28 00:00:00","insp_start_time":"1126","insp_end_time":"1136","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"WICHITA","county_code_state":"KS","county_code":"173","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-12-29 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"1275816","transaction_code":"A","transaction_date":"2022-12-28 00:00:00","upload_date":"2022-12-29 00:00:00","upload_first_byte":"0","upload_dot_number":"01843087","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-12-28 00:00:00","source_office":"3KSS001","mcmis_add_date":"2022-12-29 21:40:00","insp_carrier_name":"BERAN EXCAVATING LLC","insp_carrier_street":"8401 E OAK KNOLL ST","insp_carrier_city":"WICHITA","insp_carrier_state":"KS","insp_carrier_zip_code":"67207","insp_colonia":null,"docket_number":"667773","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:04:03.000000Z","updated_at":"2025-03-17T19:04:03.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3278675,"change_date":"2022-12-29 21:40:00","inspection_id":"77475490","insp_unit_id":"192632362","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"200","insp_unit_license":"682034","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"1NPCLP0X1LD686744","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:29:28.000000Z","updated_at":"2025-03-17T22:29:28.000000Z"}]},{"id":1947466,"change_date":"2022-12-20 21:41:00","inspection_id":"77372123","dot_number":"1843087","report_state":"KS","report_number":"HP03531586","insp_date":"2022-12-13 00:00:00","insp_start_time":"1230","insp_end_time":"1300","registration_date":"2022-12-20 00:00:00","region":"CT","ci_status_code":"C","location":"MG","location_desc":"MONTGOMERY COUNTY - 125","county_code_state":"KS","county_code":"125","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"NORTHRIDGE SAND","shipping_paper_number":"36527","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-12-14 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1274606","transaction_code":"C","transaction_date":"2022-12-15 00:00:00","upload_date":"2022-12-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01843087","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-12-13 00:00:00","source_office":"3KSS001","mcmis_add_date":"2022-12-14 21:39:00","insp_carrier_name":"BERAN EXCAVATING LLC","insp_carrier_street":"8401 E OAK KNOLL ST","insp_carrier_city":"WICHITA","insp_carrier_state":"KS","insp_carrier_zip_code":"67207","insp_colonia":null,"docket_number":"667773","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:02:33.000000Z","updated_at":"2025-03-17T19:02:33.000000Z","inspection_violations":[{"id":3024427,"change_date":"2022-12-20 21:41:00","inspection_id":"77372123","insp_violation_id":"250193247","seq_no":"1","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"192514104","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:24.000000Z","updated_at":"2025-03-17T21:21:24.000000Z","normalized_code":"39345B2"},{"id":3024428,"change_date":"2022-12-20 21:41:00","inspection_id":"77372123","insp_violation_id":"250193248","seq_no":"2","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"192514104","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:24.000000Z","updated_at":"2025-03-17T21:21:24.000000Z","normalized_code":"39311"}],"inspection_per_units":[{"id":3133389,"change_date":"2022-12-20 21:41:00","inspection_id":"77372123","insp_unit_id":"192514104","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"175","insp_unit_license":"548159","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"1XPCDP9X3HD440100","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:27.000000Z","updated_at":"2025-03-17T22:28:27.000000Z"},{"id":3133390,"change_date":"2022-12-20 21:41:00","inspection_id":"77372123","insp_unit_id":"192514105","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRVS","insp_unit_company":"43","insp_unit_license":"557045","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"48X2E2823A1006977","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:27.000000Z","updated_at":"2025-03-17T22:28:27.000000Z"}]},{"id":1902760,"change_date":"2022-12-08 21:41:00","inspection_id":"77320580","dot_number":"1843087","report_state":"KS","report_number":"HP03550390","insp_date":"2022-12-07 00:00:00","insp_start_time":"1315","insp_end_time":"1330","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"WICHITA","county_code_state":"KS","county_code":"173","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-12-08 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"82000","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":"1273861","transaction_code":"A","transaction_date":"2022-12-07 00:00:00","upload_date":"2022-12-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01843087","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-12-07 00:00:00","source_office":"3KSS001","mcmis_add_date":"2022-12-08 21:41:00","insp_carrier_name":"BERAN EXCAVATING LLC","insp_carrier_street":"8401 E OAK KNOLL ST","insp_carrier_city":"WICHITA","insp_carrier_state":"KS","insp_carrier_zip_code":"67207","insp_colonia":null,"docket_number":"667773","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:01:49.000000Z","updated_at":"2025-03-17T19:01:49.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3062048,"change_date":"2022-12-08 21:41:00","inspection_id":"77320580","insp_unit_id":"192329758","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"169","insp_unit_license":"548149","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"1NKZXPTX4HJ148421","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:58.000000Z","updated_at":"2025-03-17T22:27:58.000000Z"}]},{"id":1764288,"change_date":"2022-11-17 21:40:00","inspection_id":"77162183","dot_number":"1843087","report_state":"KS","report_number":"HP01480222","insp_date":"2022-11-16 00:00:00","insp_start_time":"1112","insp_end_time":"1119","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"WICHITA","county_code_state":"KS","county_code":"173","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-11-17 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"1271219","transaction_code":"A","transaction_date":"2022-11-16 00:00:00","upload_date":"2022-11-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01843087","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-11-16 00:00:00","source_office":"3KSS001","mcmis_add_date":"2022-11-17 21:40:00","insp_carrier_name":"BERAN EXCAVATING LLC","insp_carrier_street":"8401 E OAK KNOLL ST","insp_carrier_city":"WICHITA","insp_carrier_state":"KS","insp_carrier_zip_code":"67207","insp_colonia":null,"docket_number":"667773","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:59:16.000000Z","updated_at":"2025-03-17T18:59:16.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2838300,"change_date":"2022-11-17 21:40:00","inspection_id":"77162183","insp_unit_id":"192011517","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"200","insp_unit_license":"682034","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"1NPCLP0X1LD686744","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:24.000000Z","updated_at":"2025-03-17T22:26:24.000000Z"}]},{"id":1742829,"change_date":"2022-12-05 21:40:00","inspection_id":"77137547","dot_number":"1843087","report_state":"KS","report_number":"HP02350382","insp_date":"2022-11-11 00:00:00","insp_start_time":"0713","insp_end_time":"0745","registration_date":"2022-12-05 00:00:00","region":"CT","ci_status_code":"C","location":null,"location_desc":"WICHITA","county_code_state":"KS","county_code":"173","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":"2022-11-15 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"142000","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":"1270710","transaction_code":"C","transaction_date":"2022-11-28 00:00:00","upload_date":"2022-12-05 00:00:00","upload_first_byte":"0","upload_dot_number":"01843087","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-11-11 00:00:00","source_office":"3KSS001","mcmis_add_date":"2022-11-15 21:40:00","insp_carrier_name":"BERAN EXCAVATING LLC","insp_carrier_street":"8401 E OAK KNOLL ST","insp_carrier_city":"WICHITA","insp_carrier_state":"KS","insp_carrier_zip_code":"67207","insp_colonia":null,"docket_number":"667773","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:58:54.000000Z","updated_at":"2025-03-17T18:58:54.000000Z","inspection_violations":[{"id":2728294,"change_date":"2022-12-05 21:40:00","inspection_id":"77137547","insp_violation_id":"249913469","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"11","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"E00311098","created_at":"2025-03-17T21:19:51.000000Z","updated_at":"2025-03-17T21:19:51.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":2804293,"change_date":"2022-12-05 21:40:00","inspection_id":"77137547","insp_unit_id":"192255419","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"164","insp_unit_license":"549249","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"1XPFD49XX6D657698","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:11.000000Z","updated_at":"2025-03-17T22:26:11.000000Z"},{"id":2804294,"change_date":"2022-12-05 21:40:00","inspection_id":"77137547","insp_unit_id":"192255420","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"KAUF","insp_unit_company":null,"insp_unit_license":"557046","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"5VGFR362XFL005998","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:11.000000Z","updated_at":"2025-03-17T22:26:11.000000Z"}]},{"id":1668516,"change_date":"2022-12-01 21:42:00","inspection_id":"77052377","dot_number":"1843087","report_state":"KS","report_number":"HP02350379","insp_date":"2022-11-03 00:00:00","insp_start_time":"0546","insp_end_time":"0616","registration_date":"2022-12-01 00:00:00","region":"CT","ci_status_code":"C","location":null,"location_desc":"WICHITA","county_code_state":"KS","county_code":"173","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":"2022-11-03 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"128000","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1269766","transaction_code":"C","transaction_date":"2022-11-03 00:00:00","upload_date":"2022-12-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01843087","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-11-03 00:00:00","source_office":"3KSS001","mcmis_add_date":"2022-11-03 21:42:00","insp_carrier_name":"BERAN EXCAVATING LLC","insp_carrier_street":"8401 E OAK KNOLL ST","insp_carrier_city":"WICHITA","insp_carrier_state":"KS","insp_carrier_zip_code":"67207","insp_colonia":null,"docket_number":"667773","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:57:25.000000Z","updated_at":"2025-03-17T18:57:25.000000Z","inspection_violations":[{"id":2616729,"change_date":"2022-12-01 21:42:00","inspection_id":"77052377","insp_violation_id":"249871483","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"192214143","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:18.000000Z","updated_at":"2025-03-17T21:19:18.000000Z","normalized_code":"3939A"},{"id":2616730,"change_date":"2022-12-01 21:42:00","inspection_id":"77052377","insp_violation_id":"249871484","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:18.000000Z","updated_at":"2025-03-17T21:19:18.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2684002,"change_date":"2022-12-01 21:42:00","inspection_id":"77052377","insp_unit_id":"192214143","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"100","insp_unit_license":"544330","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"1XP5DB9X66D863147","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:23.000000Z","updated_at":"2025-03-17T22:25:23.000000Z"},{"id":2684003,"change_date":"2022-12-01 21:42:00","inspection_id":"77052377","insp_unit_id":"192214144","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EADU","insp_unit_company":"30","insp_unit_license":"554314","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"1E1D1M2857RC41749","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:23.000000Z","updated_at":"2025-03-17T22:25:23.000000Z"}]},{"id":1658737,"change_date":"2022-11-02 21:40:00","inspection_id":"77041143","dot_number":"1843087","report_state":"KS","report_number":"HP02440449","insp_date":"2022-11-01 00:00:00","insp_start_time":"1359","insp_end_time":"1411","registration_date":null,"region":"CT","ci_status_code":"C","location":"SG","location_desc":"SEDGWICK COUNTY - 173","county_code_state":"KS","county_code":"173","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SELF","shipping_paper_number":"563780","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-11-02 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"72000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1269709","transaction_code":"A","transaction_date":"2022-11-01 00:00:00","upload_date":"2022-11-02 00:00:00","upload_first_byte":"0","upload_dot_number":"01843087","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-11-01 00:00:00","source_office":"3KSS001","mcmis_add_date":"2022-11-02 21:40:00","insp_carrier_name":"BERAN EXCAVATING LLC","insp_carrier_street":"8401 E OAK KNOLL ST","insp_carrier_city":"WICHITA","insp_carrier_state":"KS","insp_carrier_zip_code":"67207","insp_colonia":null,"docket_number":"667773","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:57:06.000000Z","updated_at":"2025-03-17T18:57:06.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2668710,"change_date":"2022-11-02 21:40:00","inspection_id":"77041143","insp_unit_id":"191774088","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"156","insp_unit_license":"646035","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"1NPCLPEX4FD283094","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:17.000000Z","updated_at":"2025-03-17T22:25:17.000000Z"}]},{"id":1377440,"change_date":"2022-09-27 21:40:00","inspection_id":"76716419","dot_number":"1843087","report_state":"KS","report_number":"HP03550380","insp_date":"2022-09-26 00:00:00","insp_start_time":"0730","insp_end_time":"0745","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"WICHITA","county_code_state":"KS","county_code":"173","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-09-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"58000","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":"1264809","transaction_code":"A","transaction_date":"2022-09-26 00:00:00","upload_date":"2022-09-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01843087","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-09-26 00:00:00","source_office":"3KSS001","mcmis_add_date":"2022-09-27 21:40:00","insp_carrier_name":"BERAN EXCAVATING LLC","insp_carrier_street":"8401 E OAK KNOLL ST","insp_carrier_city":"WICHITA","insp_carrier_state":"KS","insp_carrier_zip_code":"67207","insp_colonia":null,"docket_number":"667773","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:52:01.000000Z","updated_at":"2025-03-17T18:52:01.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2218031,"change_date":"2022-09-27 21:40:00","inspection_id":"76716419","insp_unit_id":"191121683","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"151","insp_unit_license":"547131","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"1HTWXAHT36J238568","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:22:11.000000Z","updated_at":"2025-03-17T22:22:11.000000Z"}]},{"id":1377439,"change_date":"2022-09-27 21:40:00","inspection_id":"76716418","dot_number":"1843087","report_state":"KS","report_number":"HP03531498","insp_date":"2022-09-23 00:00:00","insp_start_time":"0900","insp_end_time":"0930","registration_date":null,"region":"CT","ci_status_code":"C","location":"MG","location_desc":"MONTGOMERY COUNTY - 125","county_code_state":"KS","county_code":"125","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"NORTHRIDGE SAND","shipping_paper_number":"32890","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-09-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","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":"1264823","transaction_code":"A","transaction_date":"2022-09-26 00:00:00","upload_date":"2022-09-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01843087","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-09-23 00:00:00","source_office":"3KSS001","mcmis_add_date":"2022-09-27 21:40:00","insp_carrier_name":"BERAN EXCAVATING LLC","insp_carrier_street":"8401 E OAK KNOLL ST","insp_carrier_city":"WICHITA","insp_carrier_state":"KS","insp_carrier_zip_code":"67207","insp_colonia":null,"docket_number":"667773","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:52:01.000000Z","updated_at":"2025-03-17T18:52:01.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2218029,"change_date":"2022-09-27 21:40:00","inspection_id":"76716418","insp_unit_id":"191121681","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"175","insp_unit_license":"548159","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"1XPCDP9X3HD440100","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:22:11.000000Z","updated_at":"2025-03-17T22:22:11.000000Z"},{"id":2218030,"change_date":"2022-09-27 21:40:00","inspection_id":"76716418","insp_unit_id":"191121682","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRAVI","insp_unit_company":"43","insp_unit_license":"557045","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"48X2E2823A1006977","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:22:11.000000Z","updated_at":"2025-03-17T22:22:11.000000Z"}]},{"id":1304001,"change_date":"2022-09-16 21:40:00","inspection_id":"76631343","dot_number":"1843087","report_state":"KS","report_number":"HP04011462","insp_date":"2022-09-15 00:00:00","insp_start_time":"0955","insp_end_time":"1015","registration_date":null,"region":"CT","ci_status_code":"C","location":"SG","location_desc":"SEDGWICK COUNTY - 173","county_code_state":"KS","county_code":"173","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CENTRAL SAND","shipping_paper_number":"557404","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-09-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"1263600","transaction_code":"A","transaction_date":"2022-09-15 00:00:00","upload_date":"2022-09-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01843087","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-09-15 00:00:00","source_office":"3KSS001","mcmis_add_date":"2022-09-16 21:40:00","insp_carrier_name":"BERAN EXCAVATING LLC","insp_carrier_street":"8401 E OAK KNOLL ST","insp_carrier_city":"WICHITA","insp_carrier_state":"KS","insp_carrier_zip_code":"67207","insp_colonia":null,"docket_number":"667773","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:50:49.000000Z","updated_at":"2025-03-17T18:50:49.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2098761,"change_date":"2022-09-16 21:40:00","inspection_id":"76631343","insp_unit_id":"190945363","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"200","insp_unit_license":"682034","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"1NPCLP0X1LD686744","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:23.000000Z","updated_at":"2025-03-17T22:21:23.000000Z"}]},{"id":1170136,"change_date":"2022-08-30 21:40:00","inspection_id":"76476037","dot_number":"1843087","report_state":"KS","report_number":"HP04540186","insp_date":"2022-08-29 00:00:00","insp_start_time":"1555","insp_end_time":"1613","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"6000 N GREENWICH","county_code_state":"KS","county_code":"173","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-08-30 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"72000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1261610","transaction_code":"A","transaction_date":"2022-08-30 00:00:00","upload_date":"2022-08-30 00:00:00","upload_first_byte":"0","upload_dot_number":"01843087","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-08-29 00:00:00","source_office":"3KSS001","mcmis_add_date":"2022-08-30 21:40:00","insp_carrier_name":"BERAN EXCAVATING LLC","insp_carrier_street":"8401 E OAK KNOLL ST","insp_carrier_city":"WICHITA","insp_carrier_state":"KS","insp_carrier_zip_code":"67207","insp_colonia":null,"docket_number":"667773","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:48:18.000000Z","updated_at":"2025-03-17T18:48:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1881718,"change_date":"2022-08-30 21:40:00","inspection_id":"76476037","insp_unit_id":"190622661","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"156","insp_unit_license":"646035","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"1NPCLPEX4FD283094","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:57.000000Z","updated_at":"2025-03-17T22:19:57.000000Z"}]},{"id":697038,"change_date":"2022-06-27 21:40:00","inspection_id":"75923115","dot_number":"1843087","report_state":"KS","report_number":"HP02440425","insp_date":"2022-06-24 00:00:00","insp_start_time":"1405","insp_end_time":"1421","registration_date":null,"region":"CT","ci_status_code":"C","location":"SG","location_desc":"SEDGWICK COUNTY - 173","county_code_state":"KS","county_code":"173","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"SELF","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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-06-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"1254757","transaction_code":"A","transaction_date":"2022-06-24 00:00:00","upload_date":"2022-06-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01843087","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-06-24 00:00:00","source_office":"3KSS001","mcmis_add_date":"2022-06-27 21:40:00","insp_carrier_name":"BERAN EXCAVATING LLC","insp_carrier_street":"8401 E OAK KNOLL ST","insp_carrier_city":"WICHITA","insp_carrier_state":"KS","insp_carrier_zip_code":"67207","insp_colonia":null,"docket_number":"667773","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:39:52.000000Z","updated_at":"2025-03-17T18:39:52.000000Z","inspection_violations":[{"id":1093796,"change_date":"2022-06-27 21:40:00","inspection_id":"75923115","insp_violation_id":"246726086","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"189470491","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:07.000000Z","updated_at":"2025-03-17T21:12:07.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":1119721,"change_date":"2022-06-27 21:40:00","inspection_id":"75923115","insp_unit_id":"189470491","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"138","insp_unit_license":"705129","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"1HTXRAPT3AJ240457","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:04.000000Z","updated_at":"2025-03-17T22:15:04.000000Z"}]},{"id":680574,"change_date":"2022-06-23 21:40:00","inspection_id":"75903491","dot_number":"1843087","report_state":"KS","report_number":"HP02750398","insp_date":"2022-06-22 00:00:00","insp_start_time":"1420","insp_end_time":"1455","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"WICHITA","county_code_state":"KS","county_code":"173","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CENTRAL SAND","shipping_paper_number":"543092","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-06-23 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"1254293","transaction_code":"A","transaction_date":"2022-06-22 00:00:00","upload_date":"2022-06-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01843087","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-06-22 00:00:00","source_office":"3KSS001","mcmis_add_date":"2022-06-23 21:40:00","insp_carrier_name":"BERAN EXCAVATING LLC","insp_carrier_street":"8401 E OAK KNOLL ST","insp_carrier_city":"WICHITA","insp_carrier_state":"KS","insp_carrier_zip_code":"67207","insp_colonia":null,"docket_number":"667773","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:39:47.000000Z","updated_at":"2025-03-17T18:39:47.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1093566,"change_date":"2022-06-23 21:40:00","inspection_id":"75903491","insp_unit_id":"189428499","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"200","insp_unit_license":"682034","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"1NPCLP0X1LD686744","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:55.000000Z","updated_at":"2025-03-17T22:14:55.000000Z"}]},{"id":278267,"change_date":"2022-04-28 21:39:00","inspection_id":"75425044","dot_number":"1843087","report_state":"KS","report_number":"HP05200537","insp_date":"2022-04-27 00:00:00","insp_start_time":"1516","insp_end_time":"1545","registration_date":null,"region":"CT","ci_status_code":"C","location":"SG","location_desc":"SEDGWICK COUNTY - 173","county_code_state":"KS","county_code":"173","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CARRIER","shipping_paper_number":"535279","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-04-28 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"2","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1248309","transaction_code":"A","transaction_date":"2022-04-27 00:00:00","upload_date":"2022-04-28 00:00:00","upload_first_byte":"0","upload_dot_number":"01843087","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-04-27 00:00:00","source_office":"3KSS001","mcmis_add_date":"2022-04-28 21:39:00","insp_carrier_name":"BERAN EXCAVATING LLC","insp_carrier_street":"8401 E OAK KNOLL ST","insp_carrier_city":"WICHITA","insp_carrier_state":"KS","insp_carrier_zip_code":"67207","insp_colonia":null,"docket_number":"667773","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:32:17.000000Z","updated_at":"2025-03-17T18:32:17.000000Z","inspection_violations":[{"id":431084,"change_date":"2022-04-28 21:39:00","inspection_id":"75425044","insp_violation_id":"245445913","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:09:05.000000Z","updated_at":"2025-03-17T21:09:05.000000Z","normalized_code":"3922"},{"id":431085,"change_date":"2022-04-28 21:39:00","inspection_id":"75425044","insp_violation_id":"245445914","seq_no":"2","part_no":"393","part_no_section":"100(b)","insp_viol_unit":"2","insp_unit_id":"188400298","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:09:05.000000Z","updated_at":"2025-03-17T21:09:05.000000Z","normalized_code":"393100B"}],"inspection_per_units":[{"id":450580,"change_date":"2022-04-28 21:39:00","inspection_id":"75425044","insp_unit_id":"188400297","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"167","insp_unit_license":"548148","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"1XPFDB9X67N681173","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:59.000000Z","updated_at":"2025-03-17T22:10:59.000000Z"},{"id":450581,"change_date":"2022-04-28 21:39:00","inspection_id":"75425044","insp_unit_id":"188400298","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CONST","insp_unit_company":"82","insp_unit_license":"680910","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"5TU24282XNS000154","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:59.000000Z","updated_at":"2025-03-17T22:10:59.000000Z"}]},{"id":213593,"change_date":"2022-04-20 21:42:00","inspection_id":"75347821","dot_number":"1843087","report_state":"KS","report_number":"HP01480198","insp_date":"2022-04-19 00:00:00","insp_start_time":"1006","insp_end_time":"1017","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"WICHITA","county_code_state":"KS","county_code":"173","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-04-20 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"1247419","transaction_code":"A","transaction_date":"2022-04-19 00:00:00","upload_date":"2022-04-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01843087","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-04-19 00:00:00","source_office":"3KSS001","mcmis_add_date":"2022-04-20 21:42:00","insp_carrier_name":"BERAN EXCAVATING LLC","insp_carrier_street":"8401 E OAK KNOLL ST","insp_carrier_city":"WICHITA","insp_carrier_state":"KS","insp_carrier_zip_code":"67207","insp_colonia":null,"docket_number":"667773","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:31:15.000000Z","updated_at":"2025-03-17T18:31:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":346534,"change_date":"2022-04-20 21:42:00","inspection_id":"75347821","insp_unit_id":"188247305","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"200","insp_unit_license":"682034","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"1NPCLP0X1LD686744","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:10:16.000000Z","updated_at":"2025-03-17T22:10:16.000000Z"}]},{"id":88275,"change_date":"2022-04-01 21:39:00","inspection_id":"75196140","dot_number":"1843087","report_state":"KS","report_number":"HP00940368","insp_date":"2022-03-31 00:00:00","insp_start_time":"1023","insp_end_time":"1058","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"WICHITA","county_code_state":"KS","county_code":"173","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-04-01 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"1245718","transaction_code":"A","transaction_date":"2022-03-31 00:00:00","upload_date":"2022-04-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01843087","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-03-31 00:00:00","source_office":"3KSS001","mcmis_add_date":"2022-04-01 21:39:00","insp_carrier_name":"BERAN EXCAVATING LLC","insp_carrier_street":"8401 E OAK KNOLL ST","insp_carrier_city":"WICHITA","insp_carrier_state":"KS","insp_carrier_zip_code":"67207","insp_colonia":null,"docket_number":"667773","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:29:08.000000Z","updated_at":"2025-03-17T18:29:08.000000Z","inspection_violations":[],"inspection_per_units":[{"id":143294,"change_date":"2022-04-01 21:39:00","inspection_id":"75196140","insp_unit_id":"187938872","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"138","insp_unit_license":"705129","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"1HTXRAPT3AJ240457","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:05.000000Z","updated_at":"2025-03-17T22:09:05.000000Z"}]},{"id":35913,"change_date":"2022-03-24 21:31:00","inspection_id":"75131361","dot_number":"1843087","report_state":"KS","report_number":"HP01480195","insp_date":"2022-03-23 00:00:00","insp_start_time":"1356","insp_end_time":"1410","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"WICHITA","county_code_state":"KS","county_code":"173","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"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":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-03-24 21:31:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"1244202","transaction_code":"A","transaction_date":"2022-03-23 00:00:00","upload_date":"2022-03-24 00:00:00","upload_first_byte":"0","upload_dot_number":"01843087","upload_search_indicator":null,"census_search_date":null,"snet_input_date":"2022-03-23 00:00:00","source_office":"3KSS001","mcmis_add_date":"2022-03-24 21:31:00","insp_carrier_name":"BERAN EXCAVATING LLC","insp_carrier_street":"8401 E OAK KNOLL ST","insp_carrier_city":"WICHITA","insp_carrier_state":"KS","insp_carrier_zip_code":"67207","insp_colonia":null,"docket_number":"667773","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:28:08.000000Z","updated_at":"2025-03-17T18:28:08.000000Z","inspection_violations":[],"inspection_per_units":[{"id":57900,"change_date":"2022-03-24 21:31:00","inspection_id":"75131361","insp_unit_id":"187804955","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"200","insp_unit_license":"682034","insp_unit_license_state":"KS","insp_unit_vehicle_id_number":"1NPCLP0X1LD686744","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:37.000000Z","updated_at":"2025-03-17T22:08:37.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/1843087\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/1843087\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1843087\/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\/1843087\/inspections","per_page":100,"prev_page_url":null,"to":78,"total":78}