{"current_page":1,"data":[{"id":11999583,"change_date":"2026-05-22 21:38:00","inspection_id":"87937971","dot_number":"878032","report_state":"TX","report_number":"V262352844","insp_date":"2026-05-20 00:00:00","insp_start_time":"1311","insp_end_time":"1334","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US79 AT EAST BOONE P","county_code_state":"TX","county_code":"395","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"NONE","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-05-22 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"119200","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9966537","transaction_code":"A","transaction_date":"2026-05-22 00:00:00","upload_date":"2026-05-22 00:00:00","upload_first_byte":"0","upload_dot_number":"00878032","upload_search_indicator":"M","census_search_date":"2026-05-22 21:38:00","snet_input_date":"2026-05-20 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-05-22 21:38:00","insp_carrier_name":"BEST SAND & TRUCKING COMPANY","insp_carrier_street":"19754 FM 39","insp_carrier_city":"IOLA","insp_carrier_state":"TX","insp_carrier_zip_code":"77861","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0003649","created_at":"2026-05-25T09:41:20.000000Z","updated_at":"2026-06-02T09:32:54.000000Z","inspection_violations":[{"id":20876614,"change_date":"2026-05-22 21:38:00","inspection_id":"87937971","insp_violation_id":"274457013","seq_no":"3","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"213716329","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-25T10:03:14.000000Z","updated_at":"2026-06-02T09:45:27.000000Z","normalized_code":"3922RG"},{"id":20876612,"change_date":"2026-05-22 21:38:00","inspection_id":"87937971","insp_violation_id":"274457011","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"213716329","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-25T10:03:14.000000Z","updated_at":"2026-06-02T09:45:27.000000Z","normalized_code":"39378"},{"id":20876613,"change_date":"2026-05-22 21:38:00","inspection_id":"87937971","insp_violation_id":"274457012","seq_no":"2","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"213716329","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-25T10:03:14.000000Z","updated_at":"2026-06-02T09:45:27.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":20859748,"change_date":"2026-05-22 21:38:00","inspection_id":"87937971","insp_unit_id":"213716329","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"B64","insp_unit_license":"TONLY33","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPCDP9X5ND815741","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-25T09:19:35.000000Z","updated_at":"2026-06-02T09:06:25.000000Z"},{"id":20859749,"change_date":"2026-05-22 21:38:00","inspection_id":"87937971","insp_unit_id":"213716330","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"VANT","insp_unit_company":"D38","insp_unit_license":"175C512","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4E7AA3628EATA3737","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-25T09:19:35.000000Z","updated_at":"2026-06-02T09:06:25.000000Z"}]},{"id":11699177,"change_date":"2026-04-20 21:39:00","inspection_id":"87625625","dot_number":"878032","report_state":"TX","report_number":"V262316048","insp_date":"2026-04-16 00:00:00","insp_start_time":"0702","insp_end_time":"0742","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"1417  US79","county_code_state":"TX","county_code":"395","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"NONE","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-04-20 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"119200","viol_total":"4","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9924151","transaction_code":"A","transaction_date":"2026-04-20 00:00:00","upload_date":"2026-04-20 00:00:00","upload_first_byte":"0","upload_dot_number":"00878032","upload_search_indicator":"M","census_search_date":"2026-04-20 21:39:00","snet_input_date":"2026-04-16 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-04-20 21:39:00","insp_carrier_name":"BEST SAND & TRUCKING COMPANY","insp_carrier_street":"19754 FM 39","insp_carrier_city":"IOLA","insp_carrier_state":"TX","insp_carrier_zip_code":"77861","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0003649","created_at":"2026-04-27T09:36:18.000000Z","updated_at":"2026-05-01T09:31:14.000000Z","inspection_violations":[{"id":20331205,"change_date":"2026-04-20 21:39:00","inspection_id":"87625625","insp_violation_id":"273728444","seq_no":"1","part_no":"393","part_no_section":"75A1","insp_viol_unit":"2","insp_unit_id":"213119124","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-04-27T09:52:41.000000Z","updated_at":"2026-05-01T09:43:12.000000Z","normalized_code":"39375A1"},{"id":20331206,"change_date":"2026-04-20 21:39:00","inspection_id":"87625625","insp_violation_id":"273728445","seq_no":"2","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"213119123","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:52:41.000000Z","updated_at":"2026-05-01T09:43:12.000000Z","normalized_code":"39378"},{"id":20331207,"change_date":"2026-04-20 21:39:00","inspection_id":"87625625","insp_violation_id":"273728446","seq_no":"3","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"213119123","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:52:41.000000Z","updated_at":"2026-05-01T09:43:12.000000Z","normalized_code":"3922RG"},{"id":20331208,"change_date":"2026-04-20 21:39:00","inspection_id":"87625625","insp_violation_id":"273728447","seq_no":"4","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"213119123","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-27T09:52:41.000000Z","updated_at":"2026-05-01T09:43:12.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":20360291,"change_date":"2026-04-20 21:39:00","inspection_id":"87625625","insp_unit_id":"213119123","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"B64","insp_unit_license":"TONLY33","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPCDP9X5ND815741","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:11:53.000000Z","updated_at":"2026-05-01T09:04:24.000000Z"},{"id":20360292,"change_date":"2026-04-20 21:39:00","inspection_id":"87625625","insp_unit_id":"213119124","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"VANT","insp_unit_company":"D38","insp_unit_license":"175C512","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4E7AA3628EATA3737","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-27T09:11:53.000000Z","updated_at":"2026-05-01T09:04:24.000000Z"}]},{"id":11455825,"change_date":"2026-03-23 21:51:00","inspection_id":"87373587","dot_number":"878032","report_state":"TX","report_number":"V262251464","insp_date":"2026-03-16 00:00:00","insp_start_time":"1351","insp_end_time":"1420","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"5416 FM39","county_code_state":"TX","county_code":"289","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"BEST SAND","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":"2026-03-23 21:51:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","viol_total":"6","oos_total":"2","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"5","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9891729","transaction_code":"A","transaction_date":"2026-03-23 00:00:00","upload_date":"2026-03-23 00:00:00","upload_first_byte":"0","upload_dot_number":"00878032","upload_search_indicator":"M","census_search_date":"2026-03-23 21:51:00","snet_input_date":"2026-03-16 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-03-23 21:51:00","insp_carrier_name":"BEST SAND & TRUCKING COMPANY","insp_carrier_street":"19754 FM 39","insp_carrier_city":"IOLA","insp_carrier_state":"TX","insp_carrier_zip_code":"77861","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0003649","created_at":"2026-03-26T09:41:43.000000Z","updated_at":"2026-04-03T09:33:28.000000Z","inspection_violations":[{"id":19330710,"change_date":"2026-03-23 21:51:00","inspection_id":"87373587","insp_violation_id":"272586727","seq_no":"4","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"212290891","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2026-03-26T10:02:21.000000Z","updated_at":"2026-04-03T09:51:56.000000Z","normalized_code":"3939"},{"id":19330711,"change_date":"2026-03-23 21:51:00","inspection_id":"87373587","insp_violation_id":"272586728","seq_no":"5","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"212290890","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-26T10:02:21.000000Z","updated_at":"2026-04-03T09:51:56.000000Z","normalized_code":"3922RG"},{"id":19330712,"change_date":"2026-03-23 21:51:00","inspection_id":"87373587","insp_violation_id":"272586729","seq_no":"6","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"212290890","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-26T10:02:21.000000Z","updated_at":"2026-04-03T09:51:56.000000Z","normalized_code":"3922RG"},{"id":19330707,"change_date":"2026-03-23 21:51:00","inspection_id":"87373587","insp_violation_id":"272586724","seq_no":"1","part_no":"383","part_no_section":"23A2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-26T10:02:21.000000Z","updated_at":"2026-04-03T09:51:56.000000Z","normalized_code":"38323A2"},{"id":19330708,"change_date":"2026-03-23 21:51:00","inspection_id":"87373587","insp_violation_id":"272586725","seq_no":"2","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"212290890","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-26T10:02:21.000000Z","updated_at":"2026-04-03T09:51:56.000000Z","normalized_code":"39378"},{"id":19330709,"change_date":"2026-03-23 21:51:00","inspection_id":"87373587","insp_violation_id":"272586726","seq_no":"3","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"212290891","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-26T10:02:21.000000Z","updated_at":"2026-04-03T09:51:56.000000Z","normalized_code":"3939"}],"inspection_per_units":[{"id":19620403,"change_date":"2026-03-23 21:51:00","inspection_id":"87373587","insp_unit_id":"212290890","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"B64","insp_unit_license":"NONE","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPCDP9X5ND815741","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-26T09:18:52.000000Z","updated_at":"2026-04-03T09:07:14.000000Z"},{"id":19620404,"change_date":"2026-03-23 21:51:00","inspection_id":"87373587","insp_unit_id":"212290891","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"VANT","insp_unit_company":"D38","insp_unit_license":"175C512","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4E7AA3628EATA3737","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-26T09:18:52.000000Z","updated_at":"2026-04-03T09:07:14.000000Z"}]},{"id":11048040,"change_date":"2026-02-12 21:41:00","inspection_id":"86958024","dot_number":"878032","report_state":"TX","report_number":"V262206938","insp_date":"2026-02-02 00:00:00","insp_start_time":"0830","insp_end_time":"1137","registration_date":null,"region":"CT","ci_status_code":"C","location":"3C201","location_desc":"US77 RIVIERA SCALE","county_code_state":"TX","county_code":"273","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","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":"Y","pen_cen_match":null,"final_status_date":"2026-02-04 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"133200","viol_total":"27","oos_total":"4","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"27","vehicle_oos_total":"4","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9838180","transaction_code":"C","transaction_date":"2026-02-12 00:00:00","upload_date":"2026-02-12 00:00:00","upload_first_byte":"0","upload_dot_number":"00878032","upload_search_indicator":"M","census_search_date":"2026-02-04 21:39:00","snet_input_date":"2026-02-02 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-02-04 21:39:00","insp_carrier_name":"BEST SAND & TRUCKING COMPANY","insp_carrier_street":"19754 FM 39","insp_carrier_city":"IOLA","insp_carrier_state":"TX","insp_carrier_zip_code":"77861","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0003649","created_at":"2026-02-08T10:37:01.000000Z","updated_at":"2026-02-23T10:30:59.000000Z","inspection_violations":[{"id":18621711,"change_date":"2026-02-12 21:41:00","inspection_id":"86958024","insp_violation_id":"271767936","seq_no":"1","part_no":"390","part_no_section":"21(a)","insp_viol_unit":"1","insp_unit_id":"211597027","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-15T10:55:20.000000Z","updated_at":"2026-02-23T10:39:42.000000Z","normalized_code":"39021A"},{"id":18621712,"change_date":"2026-02-12 21:41:00","inspection_id":"86958024","insp_violation_id":"271767937","seq_no":"2","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"211597028","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-15T10:55:20.000000Z","updated_at":"2026-02-23T10:39:42.000000Z","normalized_code":"39311"},{"id":18621713,"change_date":"2026-02-12 21:41:00","inspection_id":"86958024","insp_violation_id":"271767938","seq_no":"3","part_no":"393","part_no_section":"11TL","insp_viol_unit":"1","insp_unit_id":"211597027","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-15T10:55:20.000000Z","updated_at":"2026-02-23T10:39:42.000000Z","normalized_code":"39311TL"},{"id":18621714,"change_date":"2026-02-12 21:41:00","inspection_id":"86958024","insp_violation_id":"271767939","seq_no":"4","part_no":"393","part_no_section":"209E","insp_viol_unit":"1","insp_unit_id":"211597027","insp_violation_category_id":"21","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-15T10:55:20.000000Z","updated_at":"2026-02-23T10:39:42.000000Z","normalized_code":"393209E"},{"id":18621715,"change_date":"2026-02-12 21:41:00","inspection_id":"86958024","insp_violation_id":"271767940","seq_no":"5","part_no":"393","part_no_section":"45UV","insp_viol_unit":"2","insp_unit_id":"211597028","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-02-15T10:55:20.000000Z","updated_at":"2026-02-23T10:39:42.000000Z","normalized_code":"39345UV"},{"id":18621716,"change_date":"2026-02-12 21:41:00","inspection_id":"86958024","insp_violation_id":"271767941","seq_no":"6","part_no":"393","part_no_section":"45A-HJS","insp_viol_unit":"1","insp_unit_id":"211597027","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-02-15T10:55:20.000000Z","updated_at":"2026-02-23T10:39:42.000000Z","normalized_code":"39345AHJS"},{"id":18621717,"change_date":"2026-02-12 21:41:00","inspection_id":"86958024","insp_violation_id":"271767942","seq_no":"7","part_no":"393","part_no_section":"45A-HJS","insp_viol_unit":"1","insp_unit_id":"211597027","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-15T10:55:20.000000Z","updated_at":"2026-02-23T10:39:42.000000Z","normalized_code":"39345AHJS"},{"id":18621718,"change_date":"2026-02-12 21:41:00","inspection_id":"86958024","insp_violation_id":"271767943","seq_no":"8","part_no":"393","part_no_section":"45B2UV","insp_viol_unit":"2","insp_unit_id":"211597028","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-15T10:55:20.000000Z","updated_at":"2026-02-23T10:39:42.000000Z","normalized_code":"39345B2UV"},{"id":18621719,"change_date":"2026-02-12 21:41:00","inspection_id":"86958024","insp_violation_id":"271767944","seq_no":"9","part_no":"393","part_no_section":"45DLUV","insp_viol_unit":"2","insp_unit_id":"211597028","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-15T10:55:20.000000Z","updated_at":"2026-02-23T10:39:42.000000Z","normalized_code":"39345DLUV"},{"id":18621720,"change_date":"2026-02-12 21:41:00","inspection_id":"86958024","insp_violation_id":"271767945","seq_no":"10","part_no":"393","part_no_section":"48A","insp_viol_unit":"1","insp_unit_id":"211597027","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-15T10:55:20.000000Z","updated_at":"2026-02-23T10:39:42.000000Z","normalized_code":"39348A"},{"id":18621721,"change_date":"2026-02-12 21:41:00","inspection_id":"86958024","insp_violation_id":"271767946","seq_no":"11","part_no":"393","part_no_section":"48A","insp_viol_unit":"2","insp_unit_id":"211597028","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-15T10:55:20.000000Z","updated_at":"2026-02-23T10:39:42.000000Z","normalized_code":"39348A"},{"id":18621722,"change_date":"2026-02-12 21:41:00","inspection_id":"86958024","insp_violation_id":"271767947","seq_no":"12","part_no":"393","part_no_section":"48A","insp_viol_unit":"2","insp_unit_id":"211597028","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-15T10:55:20.000000Z","updated_at":"2026-02-23T10:39:42.000000Z","normalized_code":"39348A"},{"id":18621723,"change_date":"2026-02-12 21:41:00","inspection_id":"86958024","insp_violation_id":"271767948","seq_no":"13","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"211597027","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-15T10:55:20.000000Z","updated_at":"2026-02-23T10:39:42.000000Z","normalized_code":"39378"},{"id":18621724,"change_date":"2026-02-12 21:41:00","inspection_id":"86958024","insp_violation_id":"271767949","seq_no":"14","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"211597028","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-15T10:55:20.000000Z","updated_at":"2026-02-23T10:39:42.000000Z","normalized_code":"3939"},{"id":18621725,"change_date":"2026-02-12 21:41:00","inspection_id":"86958024","insp_violation_id":"271767950","seq_no":"15","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"211597027","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-15T10:55:20.000000Z","updated_at":"2026-02-23T10:39:42.000000Z","normalized_code":"3939"},{"id":18621726,"change_date":"2026-02-12 21:41:00","inspection_id":"86958024","insp_violation_id":"271767951","seq_no":"16","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"211597028","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-15T10:55:20.000000Z","updated_at":"2026-02-23T10:39:42.000000Z","normalized_code":"3939"},{"id":18621727,"change_date":"2026-02-12 21:41:00","inspection_id":"86958024","insp_violation_id":"271767952","seq_no":"17","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"211597028","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-15T10:55:20.000000Z","updated_at":"2026-02-23T10:39:42.000000Z","normalized_code":"3939"},{"id":18621728,"change_date":"2026-02-12 21:41:00","inspection_id":"86958024","insp_violation_id":"271767953","seq_no":"18","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"211597027","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-15T10:55:20.000000Z","updated_at":"2026-02-23T10:39:42.000000Z","normalized_code":"3939"},{"id":18621730,"change_date":"2026-02-12 21:41:00","inspection_id":"86958024","insp_violation_id":"271767955","seq_no":"19","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"211597028","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-15T10:55:20.000000Z","updated_at":"2026-02-23T10:39:42.000000Z","normalized_code":"3939"},{"id":18621731,"change_date":"2026-02-12 21:41:00","inspection_id":"86958024","insp_violation_id":"271767956","seq_no":"20","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"211597028","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-15T10:55:20.000000Z","updated_at":"2026-02-23T10:39:42.000000Z","normalized_code":"3939"},{"id":18621732,"change_date":"2026-02-12 21:41:00","inspection_id":"86958024","insp_violation_id":"271767957","seq_no":"21","part_no":"393","part_no_section":"9TS","insp_viol_unit":"1","insp_unit_id":"211597027","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-15T10:55:20.000000Z","updated_at":"2026-02-23T10:39:42.000000Z","normalized_code":"3939TS"},{"id":18621733,"change_date":"2026-02-12 21:41:00","inspection_id":"86958024","insp_violation_id":"271767958","seq_no":"23","part_no":"393","part_no_section":"9TS","insp_viol_unit":"2","insp_unit_id":"211597028","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-15T10:55:20.000000Z","updated_at":"2026-02-23T10:39:42.000000Z","normalized_code":"3939TS"},{"id":18621734,"change_date":"2026-02-12 21:41:00","inspection_id":"86958024","insp_violation_id":"271767959","seq_no":"24","part_no":"393","part_no_section":"95A","insp_viol_unit":"1","insp_unit_id":"211597027","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-15T10:55:20.000000Z","updated_at":"2026-02-23T10:39:42.000000Z","normalized_code":"39395A"},{"id":18621735,"change_date":"2026-02-12 21:41:00","inspection_id":"86958024","insp_violation_id":"271767960","seq_no":"25","part_no":"396","part_no_section":"3A1BOS","insp_viol_unit":"2","insp_unit_id":"211597028","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-02-15T10:55:20.000000Z","updated_at":"2026-02-23T10:39:42.000000Z","normalized_code":"3963A1BOS"},{"id":18621736,"change_date":"2026-02-12 21:41:00","inspection_id":"86958024","insp_violation_id":"271767961","seq_no":"26","part_no":"392","part_no_section":"2RG","insp_viol_unit":"2","insp_unit_id":"211597028","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-15T10:55:20.000000Z","updated_at":"2026-02-23T10:39:42.000000Z","normalized_code":"3922RG"},{"id":18621737,"change_date":"2026-02-12 21:41:00","inspection_id":"86958024","insp_violation_id":"271767962","seq_no":"27","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"211597027","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-15T10:55:20.000000Z","updated_at":"2026-02-23T10:39:42.000000Z","normalized_code":"3922RG"},{"id":18621729,"change_date":"2026-02-12 21:41:00","inspection_id":"86958024","insp_violation_id":"271767954","seq_no":"22","part_no":"393","part_no_section":"9TS","insp_viol_unit":"2","insp_unit_id":"211597028","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-02-15T10:55:20.000000Z","updated_at":"2026-02-23T10:39:42.000000Z","normalized_code":"3939TS"}],"inspection_per_units":[{"id":18964789,"change_date":"2026-02-12 21:41:00","inspection_id":"86958024","insp_unit_id":"211597028","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRAI","insp_unit_company":"31728","insp_unit_license":"Y00668","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1TKJ053333M112286","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-15T10:20:09.000000Z","updated_at":"2026-02-23T10:03:27.000000Z"},{"id":18964788,"change_date":"2026-02-12 21:41:00","inspection_id":"86958024","insp_unit_id":"211597027","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"01","insp_unit_license":"1M73564","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPSD79X3CD160679","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-15T10:20:09.000000Z","updated_at":"2026-02-23T10:03:27.000000Z"}]},{"id":8462160,"change_date":"2025-04-24 21:38:00","inspection_id":"84490467","dot_number":"878032","report_state":"TX","report_number":"V251824801","insp_date":"2025-04-18 00:00:00","insp_start_time":"1725","insp_end_time":"1816","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"TX21 EB MM 560","county_code_state":"TX","county_code":"021","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"TEXAS LEHIGH CEMENT COMP","shipping_paper_number":"1192214","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-04-24 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"7","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9560273","transaction_code":"A","transaction_date":"2025-04-24 00:00:00","upload_date":"2025-04-24 00:00:00","upload_first_byte":"0","upload_dot_number":"00878032","upload_search_indicator":"M","census_search_date":"2025-04-24 21:38:00","snet_input_date":"2025-04-18 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-04-24 21:38:00","insp_carrier_name":"BEST SAND & TRUCKING COMPANY","insp_carrier_street":"19754 FM 39","insp_carrier_city":"IOLA","insp_carrier_state":"TX","insp_carrier_zip_code":"77861","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0003649","created_at":"2025-04-27T10:28:33.000000Z","updated_at":"2025-04-28T10:12:18.000000Z","inspection_violations":[{"id":13376238,"change_date":"2025-04-24 21:38:00","inspection_id":"84490467","insp_violation_id":"265817481","seq_no":"1","part_no":"393","part_no_section":"45DLUV","insp_viol_unit":"1","insp_unit_id":"206477744","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-26T11:06:17.000000Z","updated_at":"2025-04-28T10:30:57.000000Z","normalized_code":"39345DLUV"},{"id":13376239,"change_date":"2025-04-24 21:38:00","inspection_id":"84490467","insp_violation_id":"265817482","seq_no":"2","part_no":"393","part_no_section":"55E","insp_viol_unit":"2","insp_unit_id":"206477745","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-26T11:06:17.000000Z","updated_at":"2025-04-28T10:30:57.000000Z","normalized_code":"39355E"},{"id":13376240,"change_date":"2025-04-24 21:38:00","inspection_id":"84490467","insp_violation_id":"265817483","seq_no":"3","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"206477744","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-26T11:06:17.000000Z","updated_at":"2025-04-28T10:30:57.000000Z","normalized_code":"39378"},{"id":13376241,"change_date":"2025-04-24 21:38:00","inspection_id":"84490467","insp_violation_id":"265817484","seq_no":"4","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"206477744","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-26T11:06:17.000000Z","updated_at":"2025-04-28T10:30:57.000000Z","normalized_code":"3939"},{"id":13376242,"change_date":"2025-04-24 21:38:00","inspection_id":"84490467","insp_violation_id":"265817485","seq_no":"5","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"206477745","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-26T11:06:17.000000Z","updated_at":"2025-04-28T10:30:57.000000Z","normalized_code":"3939"},{"id":13376243,"change_date":"2025-04-24 21:38:00","inspection_id":"84490467","insp_violation_id":"265817486","seq_no":"6","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"206477744","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-26T11:06:17.000000Z","updated_at":"2025-04-28T10:30:57.000000Z","normalized_code":"3939"},{"id":13376244,"change_date":"2025-04-24 21:38:00","inspection_id":"84490467","insp_violation_id":"265817487","seq_no":"7","part_no":"396","part_no_section":"5B","insp_viol_unit":"1","insp_unit_id":"206477744","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-26T11:06:17.000000Z","updated_at":"2025-04-28T10:30:57.000000Z","normalized_code":"3965B"}],"inspection_per_units":[{"id":13747621,"change_date":"2025-04-24 21:38:00","inspection_id":"84490467","insp_unit_id":"206477744","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"1725","insp_unit_license":"1N00063","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2XP5DB9X93M591313","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-27T10:17:42.000000Z","updated_at":"2025-04-28T09:59:42.000000Z"},{"id":13747622,"change_date":"2025-04-24 21:38:00","inspection_id":"84490467","insp_unit_id":"206477745","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"VANT","insp_unit_company":"22","insp_unit_license":"175C513","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4E7PA4220CABA3473","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-27T10:17:42.000000Z","updated_at":"2025-04-28T09:59:42.000000Z"}]},{"id":8384169,"change_date":"2025-04-15 21:41:00","inspection_id":"84408184","dot_number":"878032","report_state":"TX","report_number":"74G49DAZ3K","insp_date":"2025-04-11 00:00:00","insp_start_time":"0429","insp_end_time":"0455","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US-0290 IN HARRIS CO. (706-738","county_code_state":"TX","county_code":"201","insp_level_id":"4","service_center":"WE","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":"2025-04-15 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":"9550524","transaction_code":"A","transaction_date":"2025-04-15 00:00:00","upload_date":"2025-04-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00878032","upload_search_indicator":"M","census_search_date":"2025-04-15 21:41:00","snet_input_date":"2025-04-11 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-04-15 21:41:00","insp_carrier_name":"BEST SAND & TRUCKING COMPANY","insp_carrier_street":"19754 FM 39","insp_carrier_city":"IOLA","insp_carrier_state":"TX","insp_carrier_zip_code":"77861","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0003649","created_at":"2025-04-18T10:26:42.000000Z","updated_at":"2025-04-19T10:17:36.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13608631,"change_date":"2025-04-15 21:41:00","inspection_id":"84408184","insp_unit_id":"206328676","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"210","insp_unit_license":"1N00063","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2XP5DB9X93M591313","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-18T10:16:34.000000Z","updated_at":"2025-04-19T10:03:27.000000Z"},{"id":13608632,"change_date":"2025-04-15 21:41:00","inspection_id":"84408184","insp_unit_id":"206328677","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"VNTG","insp_unit_company":null,"insp_unit_license":"175C513","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4E7PA4220CABA3473","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-18T10:16:34.000000Z","updated_at":"2025-04-19T10:03:27.000000Z"}]},{"id":7278830,"change_date":"2024-11-25 21:44:00","inspection_id":"83246107","dot_number":"878032","report_state":"TX","report_number":"V241556945","insp_date":"2024-11-21 00:00:00","insp_start_time":"1948","insp_end_time":"2036","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH21 @ FM812","county_code_state":"TX","county_code":"021","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"NONE","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-11-25 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"10","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"10","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9436752","transaction_code":"A","transaction_date":"2024-11-25 00:00:00","upload_date":"2024-11-25 00:00:00","upload_first_byte":"0","upload_dot_number":"00878032","upload_search_indicator":"M","census_search_date":"2024-11-25 21:44:00","snet_input_date":"2024-11-21 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-11-25 21:44:00","insp_carrier_name":"BEST SAND & TRUCKING COMPANY","insp_carrier_street":"19754 FM 39","insp_carrier_city":"IOLA","insp_carrier_state":"TX","insp_carrier_zip_code":"77861","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0003649","created_at":"2025-03-17T20:47:46.000000Z","updated_at":"2025-03-17T20:47:46.000000Z","inspection_violations":[{"id":11377463,"change_date":"2024-11-25 21:44:00","inspection_id":"83246107","insp_violation_id":"263084468","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"204052340","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:14.000000Z","updated_at":"2025-03-17T22:01:14.000000Z","normalized_code":"39311"},{"id":11377464,"change_date":"2024-11-25 21:44:00","inspection_id":"83246107","insp_violation_id":"263084469","seq_no":"2","part_no":"393","part_no_section":"11TL","insp_viol_unit":"1","insp_unit_id":"204052340","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:14.000000Z","updated_at":"2025-03-17T22:01:14.000000Z","normalized_code":"39311TL"},{"id":11377465,"change_date":"2024-11-25 21:44:00","inspection_id":"83246107","insp_violation_id":"263084470","seq_no":"3","part_no":"393","part_no_section":"13C1","insp_viol_unit":"1","insp_unit_id":"204052340","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:14.000000Z","updated_at":"2025-03-17T22:01:14.000000Z","normalized_code":"39313C1"},{"id":11377466,"change_date":"2024-11-25 21:44:00","inspection_id":"83246107","insp_violation_id":"263084471","seq_no":"4","part_no":"393","part_no_section":"209E","insp_viol_unit":"1","insp_unit_id":"204052340","insp_violation_category_id":"21","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:14.000000Z","updated_at":"2025-03-17T22:01:14.000000Z","normalized_code":"393209E"},{"id":11377467,"change_date":"2024-11-25 21:44:00","inspection_id":"83246107","insp_violation_id":"263084472","seq_no":"5","part_no":"393","part_no_section":"55E","insp_viol_unit":"2","insp_unit_id":"204052341","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:14.000000Z","updated_at":"2025-03-17T22:01:14.000000Z","normalized_code":"39355E"},{"id":11377468,"change_date":"2024-11-25 21:44:00","inspection_id":"83246107","insp_violation_id":"263084473","seq_no":"6","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"204052340","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:14.000000Z","updated_at":"2025-03-17T22:01:14.000000Z","normalized_code":"39378"},{"id":11377469,"change_date":"2024-11-25 21:44:00","inspection_id":"83246107","insp_violation_id":"263084474","seq_no":"7","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"204052340","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:14.000000Z","updated_at":"2025-03-17T22:01:14.000000Z","normalized_code":"3939"},{"id":11377470,"change_date":"2024-11-25 21:44:00","inspection_id":"83246107","insp_violation_id":"263084475","seq_no":"8","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"204052341","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:14.000000Z","updated_at":"2025-03-17T22:01:14.000000Z","normalized_code":"3939"},{"id":11377471,"change_date":"2024-11-25 21:44:00","inspection_id":"83246107","insp_violation_id":"263084476","seq_no":"9","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"204052340","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:14.000000Z","updated_at":"2025-03-17T22:01:14.000000Z","normalized_code":"3939"},{"id":11377472,"change_date":"2024-11-25 21:44:00","inspection_id":"83246107","insp_violation_id":"263084477","seq_no":"10","part_no":"396","part_no_section":"5B","insp_viol_unit":"1","insp_unit_id":"204052340","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:14.000000Z","updated_at":"2025-03-17T22:01:14.000000Z","normalized_code":"3965B"}],"inspection_per_units":[{"id":11740827,"change_date":"2024-11-25 21:44:00","inspection_id":"83246107","insp_unit_id":"204052340","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"210","insp_unit_license":"1N00063","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2XP5DB9X93M591313","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:44:42.000000Z","updated_at":"2025-03-17T23:44:42.000000Z"},{"id":11740828,"change_date":"2024-11-25 21:44:00","inspection_id":"83246107","insp_unit_id":"204052341","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"VANT","insp_unit_company":"C22","insp_unit_license":"175C513","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4E7PA4220CABA3473","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:44:42.000000Z","updated_at":"2025-03-17T23:44:42.000000Z"}]},{"id":7253235,"change_date":"2024-11-21 21:41:00","inspection_id":"83219065","dot_number":"878032","report_state":"TX","report_number":"V241587984","insp_date":"2024-11-15 00:00:00","insp_start_time":"1015","insp_end_time":"1025","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US 79","county_code_state":"TX","county_code":"289","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"BEST SAND & TRUCKING","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":"Y","pen_cen_match":null,"final_status_date":"2024-11-21 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9433259","transaction_code":"A","transaction_date":"2024-11-21 00:00:00","upload_date":"2024-11-21 00:00:00","upload_first_byte":"0","upload_dot_number":"00878032","upload_search_indicator":"M","census_search_date":"2024-11-21 21:41:00","snet_input_date":"2024-11-15 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-11-21 21:41:00","insp_carrier_name":"BEST SAND & TRUCKING COMPANY","insp_carrier_street":"19754 FM 39","insp_carrier_city":"IOLA","insp_carrier_state":"TX","insp_carrier_zip_code":"77861","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0003649","created_at":"2025-03-17T20:47:17.000000Z","updated_at":"2025-03-17T20:47:17.000000Z","inspection_violations":[{"id":11339413,"change_date":"2024-11-21 21:41:00","inspection_id":"83219065","insp_violation_id":"263029531","seq_no":"1","part_no":"390","part_no_section":"21(a)","insp_viol_unit":"1","insp_unit_id":"203999257","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:02.000000Z","updated_at":"2025-03-17T22:01:02.000000Z","normalized_code":"39021A"},{"id":11339414,"change_date":"2024-11-21 21:41:00","inspection_id":"83219065","insp_violation_id":"263029532","seq_no":"2","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"203999257","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:02.000000Z","updated_at":"2025-03-17T22:01:02.000000Z","normalized_code":"39311"},{"id":11339415,"change_date":"2024-11-21 21:41:00","inspection_id":"83219065","insp_violation_id":"263029533","seq_no":"3","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"203999257","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:02.000000Z","updated_at":"2025-03-17T22:01:02.000000Z","normalized_code":"39311"}],"inspection_per_units":[{"id":11699317,"change_date":"2024-11-21 21:41:00","inspection_id":"83219065","insp_unit_id":"203999257","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"10","insp_unit_license":"TBT4307","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AX13C4JM040437","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:44:14.000000Z","updated_at":"2025-03-17T23:44:14.000000Z"}]},{"id":5191105,"change_date":"2024-03-01 21:40:00","inspection_id":"81001645","dot_number":"878032","report_state":"TX","report_number":"V241333822","insp_date":"2024-02-27 00:00:00","insp_start_time":"1759","insp_end_time":"1824","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"FM 39 MP 416","county_code_state":"TX","county_code":"185","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"UNKNOWN","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-03-01 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"4","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9213030","transaction_code":"A","transaction_date":"2024-03-01 00:00:00","upload_date":"2024-03-01 00:00:00","upload_first_byte":"0","upload_dot_number":"00878032","upload_search_indicator":"M","census_search_date":"2024-03-01 21:40:00","snet_input_date":"2024-02-27 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-03-01 21:40:00","insp_carrier_name":"BEST SAND & TRUCKING COMPANY","insp_carrier_street":"19754 FM 39","insp_carrier_city":"IOLA","insp_carrier_state":"TX","insp_carrier_zip_code":"77861","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0003649","created_at":"2025-03-17T20:05:22.000000Z","updated_at":"2025-03-17T20:05:22.000000Z","inspection_violations":[{"id":8001149,"change_date":"2024-03-01 21:40:00","inspection_id":"81001645","insp_violation_id":"258159525","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"199714564","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:42.000000Z","updated_at":"2025-03-17T21:44:42.000000Z","normalized_code":"3939A"},{"id":8001150,"change_date":"2024-03-01 21:40:00","inspection_id":"81001645","insp_violation_id":"258159526","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"199714564","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:44:42.000000Z","updated_at":"2025-03-17T21:44:42.000000Z","normalized_code":"3939A"},{"id":8001151,"change_date":"2024-03-01 21:40:00","inspection_id":"81001645","insp_violation_id":"258159527","seq_no":"3","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"199714564","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:42.000000Z","updated_at":"2025-03-17T21:44:42.000000Z","normalized_code":"39395A"},{"id":8001152,"change_date":"2024-03-01 21:40:00","inspection_id":"81001645","insp_violation_id":"258159528","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"199714564","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:42.000000Z","updated_at":"2025-03-17T21:44:42.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8358484,"change_date":"2024-03-01 21:40:00","inspection_id":"81001645","insp_unit_id":"199714564","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"10","insp_unit_license":"TBT4307","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AX13C4JM040437","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:10:43.000000Z","updated_at":"2025-03-17T23:10:43.000000Z"}]},{"id":4592129,"change_date":"2023-12-08 21:41:00","inspection_id":"80347264","dot_number":"878032","report_state":"TX","report_number":"V231117580","insp_date":"2023-08-14 00:00:00","insp_start_time":"1215","insp_end_time":"1245","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"CR822 CR822","county_code_state":"TX","county_code":"293","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"NA","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-12-08 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9144268","transaction_code":"A","transaction_date":"2023-12-08 00:00:00","upload_date":"2023-12-08 00:00:00","upload_first_byte":"0","upload_dot_number":"00878032","upload_search_indicator":"M","census_search_date":"2023-12-08 21:41:00","snet_input_date":"2023-08-14 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-12-08 21:41:00","insp_carrier_name":"BEST SAND & TRUCKING","insp_carrier_street":"19754 FM39","insp_carrier_city":"IOLA","insp_carrier_state":"TX","insp_carrier_zip_code":"77861","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0003649","created_at":"2025-03-17T19:53:48.000000Z","updated_at":"2025-03-17T19:53:48.000000Z","inspection_violations":[{"id":7102397,"change_date":"2023-12-08 21:41:00","inspection_id":"80347264","insp_violation_id":"256798832","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"198425758","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:20.000000Z","updated_at":"2025-03-17T21:40:20.000000Z","normalized_code":"39617C"},{"id":7102398,"change_date":"2023-12-08 21:41:00","inspection_id":"80347264","insp_violation_id":"256798833","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"198425758","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:20.000000Z","updated_at":"2025-03-17T21:40:20.000000Z","normalized_code":"3922"},{"id":7102399,"change_date":"2023-12-08 21:41:00","inspection_id":"80347264","insp_violation_id":"256798834","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"198425758","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:20.000000Z","updated_at":"2025-03-17T21:40:20.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7385934,"change_date":"2023-12-08 21:41:00","inspection_id":"80347264","insp_unit_id":"198425758","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"5","insp_unit_license":"NWJ7494","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AG11CX5M035204","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:02:05.000000Z","updated_at":"2025-03-17T23:02:05.000000Z"}]},{"id":2722212,"change_date":"2023-04-06 21:40:00","inspection_id":"78256426","dot_number":"878032","report_state":"TX","report_number":"6JTE9DBCF0","insp_date":"2023-03-30 00:00:00","insp_start_time":"1440","insp_end_time":"1453","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US-0290 IN HARRIS CO. (706-738","county_code_state":"TX","county_code":"201","insp_level_id":"4","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"TEXAS-LEHIGH","shipping_paper_number":"7020199","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":"Y","pen_cen_match":null,"final_status_date":"2023-04-03 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"0","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":"8944893","transaction_code":"C","transaction_date":"2023-04-06 00:00:00","upload_date":"2023-04-06 00:00:00","upload_first_byte":"0","upload_dot_number":"00878032","upload_search_indicator":"M","census_search_date":"2023-04-03 21:40:00","snet_input_date":"2023-03-30 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-04-03 21:40:00","insp_carrier_name":"BEST SAND & TRUCKING","insp_carrier_street":"19754 FM39","insp_carrier_city":"IOLA","insp_carrier_state":"TX","insp_carrier_zip_code":"77861","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0003649","created_at":"2025-03-17T19:16:56.000000Z","updated_at":"2025-03-17T19:16:56.000000Z","inspection_violations":[{"id":4182948,"change_date":"2023-04-06 21:40:00","inspection_id":"78256426","insp_violation_id":"252092197","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"40","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:36.000000Z","updated_at":"2025-03-17T21:26:36.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":4382006,"change_date":"2023-04-06 21:40:00","inspection_id":"78256426","insp_unit_id":"194268708","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"210","insp_unit_license":"1N00063","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2XP5DB9X93M591313","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:30.000000Z","updated_at":"2025-03-17T22:37:30.000000Z"},{"id":4382007,"change_date":"2023-04-06 21:40:00","inspection_id":"78256426","insp_unit_id":"194268709","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"VNTG","insp_unit_company":null,"insp_unit_license":"175C509","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4E7PA4228CABA3477","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:30.000000Z","updated_at":"2025-03-17T22:37:30.000000Z"}]},{"id":2267891,"change_date":"2023-01-31 21:43:00","inspection_id":"77738357","dot_number":"878032","report_state":"TX","report_number":"6I190VJY19","insp_date":"2023-01-25 00:00:00","insp_start_time":"0930","insp_end_time":"1013","registration_date":null,"region":"CT","ci_status_code":"C","location":"2A701","location_desc":"IH 45 NORTHBOUND NEW WAVERLY","county_code_state":"TX","county_code":"471","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"BEST","shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-01-31 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"7","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8893231","transaction_code":"A","transaction_date":"2023-01-31 00:00:00","upload_date":"2023-01-31 00:00:00","upload_first_byte":"0","upload_dot_number":"00878032","upload_search_indicator":"M","census_search_date":"2023-01-31 21:43:00","snet_input_date":"2023-01-25 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-01-31 21:43:00","insp_carrier_name":"BEST SAND & TRUCKING","insp_carrier_street":"19754 FM39","insp_carrier_city":"IOLA","insp_carrier_state":"TX","insp_carrier_zip_code":"77861","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0003649","created_at":"2025-03-17T19:08:29.000000Z","updated_at":"2025-03-17T19:08:29.000000Z","inspection_violations":[{"id":3499241,"change_date":"2023-01-31 21:43:00","inspection_id":"77738357","insp_violation_id":"250876568","seq_no":"1","part_no":"393","part_no_section":"209(d)","insp_viol_unit":"1","insp_unit_id":"193160198","insp_violation_category_id":"21","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:23:30.000000Z","updated_at":"2025-03-17T21:23:30.000000Z","normalized_code":"393209D"},{"id":3499242,"change_date":"2023-01-31 21:43:00","inspection_id":"77738357","insp_violation_id":"250876569","seq_no":"2","part_no":"393","part_no_section":"45","insp_viol_unit":"1","insp_unit_id":"193160198","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:23:30.000000Z","updated_at":"2025-03-17T21:23:30.000000Z","normalized_code":"39345"},{"id":3499243,"change_date":"2023-01-31 21:43:00","inspection_id":"77738357","insp_violation_id":"250876570","seq_no":"3","part_no":"393","part_no_section":"45","insp_viol_unit":"1","insp_unit_id":"193160198","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:30.000000Z","updated_at":"2025-03-17T21:23:30.000000Z","normalized_code":"39345"},{"id":3499244,"change_date":"2023-01-31 21:43:00","inspection_id":"77738357","insp_violation_id":"250876571","seq_no":"4","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"193160198","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:30.000000Z","updated_at":"2025-03-17T21:23:30.000000Z","normalized_code":"39617C"},{"id":3499245,"change_date":"2023-01-31 21:43:00","inspection_id":"77738357","insp_violation_id":"250876572","seq_no":"5","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193160198","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:30.000000Z","updated_at":"2025-03-17T21:23:30.000000Z","normalized_code":"3922"},{"id":3499246,"change_date":"2023-01-31 21:43:00","inspection_id":"77738357","insp_violation_id":"250876573","seq_no":"6","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"1","insp_unit_id":"193160198","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:30.000000Z","updated_at":"2025-03-17T21:23:30.000000Z","normalized_code":"39375C"},{"id":3499247,"change_date":"2023-01-31 21:43:00","inspection_id":"77738357","insp_violation_id":"250876574","seq_no":"7","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"1","insp_unit_id":"193160198","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:30.000000Z","updated_at":"2025-03-17T21:23:30.000000Z","normalized_code":"39375C"}],"inspection_per_units":[{"id":3650820,"change_date":"2023-01-31 21:43:00","inspection_id":"77738357","insp_unit_id":"193160198","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"88","insp_unit_license":"1N00066","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XP5DB9X46D651573","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:10.000000Z","updated_at":"2025-03-17T22:32:10.000000Z"}]},{"id":1746152,"change_date":"2022-11-15 21:40:00","inspection_id":"77141369","dot_number":"878032","report_state":"TX","report_number":"6FW80XLK48","insp_date":"2022-11-09 00:00:00","insp_start_time":"0845","insp_end_time":"0917","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SS-0515 IN GRIMES CO. (636-636","county_code_state":"TX","county_code":"185","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"GLENN FUQUA","shipping_paper_number":"31609","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-15 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"8827152","transaction_code":"A","transaction_date":"2022-11-15 00:00:00","upload_date":"2022-11-15 00:00:00","upload_first_byte":"0","upload_dot_number":"00878032","upload_search_indicator":"M","census_search_date":"2022-11-15 21:40:00","snet_input_date":"2022-11-09 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-11-15 21:40:00","insp_carrier_name":"BEST SAND & TRUCKING","insp_carrier_street":"19754 FM 39","insp_carrier_city":"IOLA","insp_carrier_state":"TX","insp_carrier_zip_code":"77861","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0003649","created_at":"2025-03-17T18:58:55.000000Z","updated_at":"2025-03-17T18:58:55.000000Z","inspection_violations":[{"id":2735099,"change_date":"2022-11-15 21:40:00","inspection_id":"77141369","insp_violation_id":"249616454","seq_no":"1","part_no":"393","part_no_section":"209(e)","insp_viol_unit":"1","insp_unit_id":"191970564","insp_violation_category_id":"21","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:52.000000Z","updated_at":"2025-03-17T21:19:52.000000Z","normalized_code":"393209E"},{"id":2735100,"change_date":"2022-11-15 21:40:00","inspection_id":"77141369","insp_violation_id":"249616455","seq_no":"2","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"191970564","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:52.000000Z","updated_at":"2025-03-17T21:19:52.000000Z","normalized_code":"39360C"},{"id":2735101,"change_date":"2022-11-15 21:40:00","inspection_id":"77141369","insp_violation_id":"249616456","seq_no":"3","part_no":"393","part_no_section":"47(a)","insp_viol_unit":"1","insp_unit_id":"191970564","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:52.000000Z","updated_at":"2025-03-17T21:19:52.000000Z","normalized_code":"39347A"},{"id":2735102,"change_date":"2022-11-15 21:40:00","inspection_id":"77141369","insp_violation_id":"249616457","seq_no":"4","part_no":"390","part_no_section":"21(a)","insp_viol_unit":"1","insp_unit_id":"191970564","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:52.000000Z","updated_at":"2025-03-17T21:19:52.000000Z","normalized_code":"39021A"},{"id":2735103,"change_date":"2022-11-15 21:40:00","inspection_id":"77141369","insp_violation_id":"249616458","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"191970564","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:52.000000Z","updated_at":"2025-03-17T21:19:52.000000Z","normalized_code":"3939A"},{"id":2735104,"change_date":"2022-11-15 21:40:00","inspection_id":"77141369","insp_violation_id":"249616459","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"191970564","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:52.000000Z","updated_at":"2025-03-17T21:19:52.000000Z","normalized_code":"3939A"},{"id":2735105,"change_date":"2022-11-15 21:40:00","inspection_id":"77141369","insp_violation_id":"249616460","seq_no":"7","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"191970564","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:52.000000Z","updated_at":"2025-03-17T21:19:52.000000Z","normalized_code":"3939A"},{"id":2735106,"change_date":"2022-11-15 21:40:00","inspection_id":"77141369","insp_violation_id":"249616461","seq_no":"8","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"191970564","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:52.000000Z","updated_at":"2025-03-17T21:19:52.000000Z","normalized_code":"39311"}],"inspection_per_units":[{"id":2809903,"change_date":"2022-11-15 21:40:00","inspection_id":"77141369","insp_unit_id":"191970564","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"007","insp_unit_license":"1NO0064","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XP5DB9X23D598366","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:13.000000Z","updated_at":"2025-03-17T22:26:13.000000Z"},{"id":2809904,"change_date":"2022-11-15 21:40:00","inspection_id":"77141369","insp_unit_id":"191970565","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"VNTG","insp_unit_company":"D39","insp_unit_license":"175C510","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4E7AA3626EATA3896","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:13.000000Z","updated_at":"2025-03-17T22:26:13.000000Z"}]},{"id":1519904,"change_date":"2022-10-14 21:39:00","inspection_id":"76881695","dot_number":"878032","report_state":"TX","report_number":"6EX70XMXJT","insp_date":"2022-10-05 00:00:00","insp_start_time":"0600","insp_end_time":"0735","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"FM-0039 IN MADISON CO. (398-41","county_code_state":"TX","county_code":"313","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"BEST MATERIALS","shipping_paper_number":"38952","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-10-14 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"8","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8800509","transaction_code":"A","transaction_date":"2022-10-14 00:00:00","upload_date":"2022-10-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00878032","upload_search_indicator":"M","census_search_date":"2022-10-14 21:39:00","snet_input_date":"2022-10-05 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-10-14 21:39:00","insp_carrier_name":"BEST SAND & TRUCKING","insp_carrier_street":"19754 FM 39","insp_carrier_city":"IOLA","insp_carrier_state":"TX","insp_carrier_zip_code":"77861","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0003649","created_at":"2025-03-17T18:54:33.000000Z","updated_at":"2025-03-17T18:54:33.000000Z","inspection_violations":[{"id":2394201,"change_date":"2022-10-14 21:39:00","inspection_id":"76881695","insp_violation_id":"249045169","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:18:02.000000Z","updated_at":"2025-03-17T21:18:02.000000Z","normalized_code":"3922"},{"id":2394202,"change_date":"2022-10-14 21:39:00","inspection_id":"76881695","insp_violation_id":"249045170","seq_no":"2","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:18:02.000000Z","updated_at":"2025-03-17T21:18:02.000000Z","normalized_code":"3922"},{"id":2394203,"change_date":"2022-10-14 21:39:00","inspection_id":"76881695","insp_violation_id":"249045171","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"191453176","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:02.000000Z","updated_at":"2025-03-17T21:18:02.000000Z","normalized_code":"3922"},{"id":2394204,"change_date":"2022-10-14 21:39:00","inspection_id":"76881695","insp_violation_id":"249045172","seq_no":"4","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"191453176","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:02.000000Z","updated_at":"2025-03-17T21:18:02.000000Z","normalized_code":"39617C"},{"id":2394205,"change_date":"2022-10-14 21:39:00","inspection_id":"76881695","insp_violation_id":"249045173","seq_no":"5","part_no":"393","part_no_section":"55(d)(1)","insp_viol_unit":"1","insp_unit_id":"191453176","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:02.000000Z","updated_at":"2025-03-17T21:18:02.000000Z","normalized_code":"39355D1"},{"id":2394206,"change_date":"2022-10-14 21:39:00","inspection_id":"76881695","insp_violation_id":"249045174","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"191453176","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:02.000000Z","updated_at":"2025-03-17T21:18:02.000000Z","normalized_code":"3939A"},{"id":2394207,"change_date":"2022-10-14 21:39:00","inspection_id":"76881695","insp_violation_id":"249045175","seq_no":"7","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"191453176","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:02.000000Z","updated_at":"2025-03-17T21:18:02.000000Z","normalized_code":"3939A"},{"id":2394208,"change_date":"2022-10-14 21:39:00","inspection_id":"76881695","insp_violation_id":"249045176","seq_no":"8","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"191453176","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:02.000000Z","updated_at":"2025-03-17T21:18:02.000000Z","normalized_code":"39378"}],"inspection_per_units":[{"id":2446115,"change_date":"2022-10-14 21:39:00","inspection_id":"76881695","insp_unit_id":"191453176","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"9","insp_unit_license":"CCY2495","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NPALT0X87D699710","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:46.000000Z","updated_at":"2025-03-17T22:23:46.000000Z"}]},{"id":1519910,"change_date":"2022-10-14 21:39:00","inspection_id":"76881701","dot_number":"878032","report_state":"TX","report_number":"6EX80KKL05","insp_date":"2022-10-05 00:00:00","insp_start_time":"0719","insp_end_time":"0840","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"FM-0039 IN MADISON CO. (398-41","county_code_state":"TX","county_code":"313","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"ARCOSA AGGREGATES","shipping_paper_number":"55034191","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-10-14 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"11","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"11","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8800531","transaction_code":"A","transaction_date":"2022-10-14 00:00:00","upload_date":"2022-10-14 00:00:00","upload_first_byte":"0","upload_dot_number":"00878032","upload_search_indicator":"M","census_search_date":"2022-10-14 21:39:00","snet_input_date":"2022-10-05 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-10-14 21:39:00","insp_carrier_name":"BEST SAND & TRUCKING","insp_carrier_street":"19754 FM 39","insp_carrier_city":"IOLA","insp_carrier_state":"TX","insp_carrier_zip_code":"77861","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0003649","created_at":"2025-03-17T18:54:33.000000Z","updated_at":"2025-03-17T18:54:33.000000Z","inspection_violations":[{"id":2394241,"change_date":"2022-10-14 21:39:00","inspection_id":"76881701","insp_violation_id":"249045209","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"191453185","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:02.000000Z","updated_at":"2025-03-17T21:18:02.000000Z","normalized_code":"3922"},{"id":2394242,"change_date":"2022-10-14 21:39:00","inspection_id":"76881701","insp_violation_id":"249045210","seq_no":"2","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"191453185","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:02.000000Z","updated_at":"2025-03-17T21:18:02.000000Z","normalized_code":"39347E"},{"id":2394243,"change_date":"2022-10-14 21:39:00","inspection_id":"76881701","insp_violation_id":"249045211","seq_no":"3","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"191453185","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:02.000000Z","updated_at":"2025-03-17T21:18:02.000000Z","normalized_code":"39347E"},{"id":2394244,"change_date":"2022-10-14 21:39:00","inspection_id":"76881701","insp_violation_id":"249045212","seq_no":"4","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"191453185","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:02.000000Z","updated_at":"2025-03-17T21:18:02.000000Z","normalized_code":"39347E"},{"id":2394245,"change_date":"2022-10-14 21:39:00","inspection_id":"76881701","insp_violation_id":"249045213","seq_no":"5","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"191453186","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:02.000000Z","updated_at":"2025-03-17T21:18:02.000000Z","normalized_code":"39347E"},{"id":2394246,"change_date":"2022-10-14 21:39:00","inspection_id":"76881701","insp_violation_id":"249045214","seq_no":"6","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"191453185","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:18:02.000000Z","updated_at":"2025-03-17T21:18:02.000000Z","normalized_code":"3963A1"},{"id":2394247,"change_date":"2022-10-14 21:39:00","inspection_id":"76881701","insp_violation_id":"249045215","seq_no":"7","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"191453185","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:02.000000Z","updated_at":"2025-03-17T21:18:02.000000Z","normalized_code":"39353B"},{"id":2394248,"change_date":"2022-10-14 21:39:00","inspection_id":"76881701","insp_violation_id":"249045216","seq_no":"8","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"2","insp_unit_id":"191453186","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:02.000000Z","updated_at":"2025-03-17T21:18:02.000000Z","normalized_code":"39353B"},{"id":2394249,"change_date":"2022-10-14 21:39:00","inspection_id":"76881701","insp_violation_id":"249045217","seq_no":"9","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"191453185","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:02.000000Z","updated_at":"2025-03-17T21:18:02.000000Z","normalized_code":"39311"},{"id":2394250,"change_date":"2022-10-14 21:39:00","inspection_id":"76881701","insp_violation_id":"249045218","seq_no":"10","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"191453185","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:02.000000Z","updated_at":"2025-03-17T21:18:02.000000Z","normalized_code":"3939A"},{"id":2394251,"change_date":"2022-10-14 21:39:00","inspection_id":"76881701","insp_violation_id":"249045219","seq_no":"11","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"191453185","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:02.000000Z","updated_at":"2025-03-17T21:18:02.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":2446124,"change_date":"2022-10-14 21:39:00","inspection_id":"76881701","insp_unit_id":"191453185","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"007","insp_unit_license":"1N00064","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XP5DB9X23D598366","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:46.000000Z","updated_at":"2025-03-17T22:23:46.000000Z"},{"id":2446125,"change_date":"2022-10-14 21:39:00","inspection_id":"76881701","insp_unit_id":"191453186","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"VNTG","insp_unit_company":"D39","insp_unit_license":"175C510","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4E7AA3626EATA3896","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:46.000000Z","updated_at":"2025-03-17T22:23:46.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/878032\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/878032\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/878032\/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\/878032\/inspections","per_page":100,"prev_page_url":null,"to":15,"total":15}