{"current_page":1,"data":[{"id":11955101,"change_date":"2026-05-18 21:40:00","inspection_id":"87890965","dot_number":"4159272","report_state":"TX","report_number":"7FIA9DBI5Q","insp_date":"2026-05-14 00:00:00","insp_start_time":"0936","insp_end_time":"1046","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"7400 N MAIN ST","county_code_state":"TX","county_code":"201","insp_level_id":"3","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":"2026-05-18 21:40:00","post_acc_ind":"Y","gross_comb_veh_wt":"52000","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":"9957782","transaction_code":"A","transaction_date":"2026-05-18 00:00:00","upload_date":"2026-05-18 00:00:00","upload_first_byte":"0","upload_dot_number":"04159272","upload_search_indicator":"M","census_search_date":"2026-05-18 21:40:00","snet_input_date":"2026-05-14 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-05-18 21:40:00","insp_carrier_name":"BIG RED TRUCKING LLC","insp_carrier_street":"7116 HARLEM ST","insp_carrier_city":"BAYTOWN","insp_carrier_state":"TX","insp_carrier_zip_code":"77521-1222","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1068871","created_at":"2026-05-21T09:41:13.000000Z","updated_at":"2026-05-29T09:31:29.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20787425,"change_date":"2026-05-18 21:40:00","inspection_id":"87890965","insp_unit_id":"213629434","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"VMB9839","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NPAL59X51D566876","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-21T09:20:46.000000Z","updated_at":"2026-05-29T09:03:47.000000Z"}]},{"id":11989679,"change_date":"2026-05-22 08:08:00","inspection_id":"87927425","dot_number":"4159272","report_state":"TX","report_number":"7EY59DBU2L","insp_date":"2026-04-24 00:00:00","insp_start_time":"0516","insp_end_time":"0538","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"10400  KATY FWY SERV","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"PICK UP SITE","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":"2026-05-22 08:08:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","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":"9963825","transaction_code":"A","transaction_date":"2026-05-21 00:00:00","upload_date":"2026-05-21 00:00:00","upload_first_byte":"0","upload_dot_number":"04159272","upload_search_indicator":"M","census_search_date":"2026-05-22 08:08:00","snet_input_date":"2026-04-24 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-05-22 08:08:00","insp_carrier_name":"BIG RED TRUCKING LLC","insp_carrier_street":"7116 HARLEM ST","insp_carrier_city":"BAYTOWN","insp_carrier_state":"TX","insp_carrier_zip_code":"77521-1222","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1068871","created_at":"2026-05-25T09:41:07.000000Z","updated_at":"2026-06-02T09:31:41.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20843550,"change_date":"2026-05-22 08:08:00","inspection_id":"87927425","insp_unit_id":"213697051","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"TPS1076","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NPAX00X51N554368","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-25T09:19:00.000000Z","updated_at":"2026-06-02T09:04:21.000000Z"}]},{"id":11544463,"change_date":"2026-04-01 21:40:00","inspection_id":"87467015","dot_number":"4159272","report_state":"TX","report_number":"7E6A9DGRMZ","insp_date":"2026-03-27 00:00:00","insp_start_time":"1007","insp_end_time":"1021","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"13500  EAST FWY S SR","county_code_state":"TX","county_code":"201","insp_level_id":"2","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":"2026-04-01 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"70000","viol_total":"4","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9902507","transaction_code":"A","transaction_date":"2026-03-31 00:00:00","upload_date":"2026-03-31 00:00:00","upload_first_byte":"0","upload_dot_number":"04159272","upload_search_indicator":"M","census_search_date":"2026-04-01 21:40:00","snet_input_date":"2026-03-27 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-04-01 21:40:00","insp_carrier_name":"BIG RED TRUCKING LLC","insp_carrier_street":"7116 HARLEM ST","insp_carrier_city":"BAYTOWN","insp_carrier_state":"TX","insp_carrier_zip_code":"77521-1222","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1068871","created_at":"2026-04-04T09:43:33.000000Z","updated_at":"2026-04-12T09:32:39.000000Z","inspection_violations":[{"id":19504343,"change_date":"2026-04-01 21:40:00","inspection_id":"87467015","insp_violation_id":"272800937","seq_no":"1","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"212484093","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-03T10:13:28.000000Z","updated_at":"2026-04-11T09:48:46.000000Z","normalized_code":"39617C"},{"id":19504344,"change_date":"2026-04-01 21:40:00","inspection_id":"87467015","insp_violation_id":"272800938","seq_no":"2","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"212484093","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-03T10:13:28.000000Z","updated_at":"2026-04-11T09:48:46.000000Z","normalized_code":"39311"},{"id":19504345,"change_date":"2026-04-01 21:40:00","inspection_id":"87467015","insp_violation_id":"272800939","seq_no":"3","part_no":"393","part_no_section":"13C1","insp_viol_unit":"1","insp_unit_id":"212484093","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-03T10:13:28.000000Z","updated_at":"2026-04-11T09:48:46.000000Z","normalized_code":"39313C1"},{"id":19504346,"change_date":"2026-04-01 21:40:00","inspection_id":"87467015","insp_violation_id":"272800940","seq_no":"4","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"212484093","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-03T10:13:28.000000Z","updated_at":"2026-04-11T09:48:46.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":19781658,"change_date":"2026-04-01 21:40:00","inspection_id":"87467015","insp_unit_id":"212484093","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"XJZ4411","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NKWL00X4YR859709","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-04T09:21:48.000000Z","updated_at":"2026-04-12T09:11:35.000000Z"}]},{"id":11428150,"change_date":"2026-03-20 21:39:00","inspection_id":"87344307","dot_number":"4159272","report_state":"TX","report_number":"7DX69DBI4Z","insp_date":"2026-03-18 00:00:00","insp_start_time":"0624","insp_end_time":"0650","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0146 IN HARRIS CO. (482-500","county_code_state":"TX","county_code":"201","insp_level_id":"2","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":"2026-03-20 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9890144","transaction_code":"A","transaction_date":"2026-03-20 00:00:00","upload_date":"2026-03-20 00:00:00","upload_first_byte":"0","upload_dot_number":"04159272","upload_search_indicator":"M","census_search_date":"2026-03-20 21:39:00","snet_input_date":"2026-03-18 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-03-20 21:39:00","insp_carrier_name":"BIG RED TRUCKING LLC","insp_carrier_street":"7116 HARLEM ST","insp_carrier_city":"BAYTOWN","insp_carrier_state":"TX","insp_carrier_zip_code":"77521-1222","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1068871","created_at":"2026-03-23T09:46:36.000000Z","updated_at":"2026-03-31T09:31:17.000000Z","inspection_violations":[{"id":19278278,"change_date":"2026-03-20 21:39:00","inspection_id":"87344307","insp_violation_id":"272526706","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"212243300","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-23T10:13:42.000000Z","updated_at":"2026-03-31T09:49:55.000000Z","normalized_code":"39378"}],"inspection_per_units":[{"id":19576698,"change_date":"2026-03-20 21:39:00","inspection_id":"87344307","insp_unit_id":"212243300","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"TPS1076","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NPAX00X51N554368","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-23T09:30:03.000000Z","updated_at":"2026-03-31T09:11:02.000000Z"}]},{"id":11357118,"change_date":"2026-03-12 21:40:00","inspection_id":"87275602","dot_number":"4159272","report_state":"TX","report_number":"7DL99DUIAJ","insp_date":"2026-03-06 00:00:00","insp_start_time":"0850","insp_end_time":"0918","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"100 W BARBOURS CUT","county_code_state":"TX","county_code":"201","insp_level_id":"2","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":"2026-03-12 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"62000","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":"9882095","transaction_code":"A","transaction_date":"2026-03-12 00:00:00","upload_date":"2026-03-12 00:00:00","upload_first_byte":"0","upload_dot_number":"04159272","upload_search_indicator":"M","census_search_date":"2026-03-12 21:40:00","snet_input_date":"2026-03-06 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-03-12 21:40:00","insp_carrier_name":"BIG RED TRUCKING LLC","insp_carrier_street":"7116 HARLEM ST","insp_carrier_city":"BAYTOWN","insp_carrier_state":"TX","insp_carrier_zip_code":"77521-1222","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1068871","created_at":"2026-03-15T09:40:01.000000Z","updated_at":"2026-03-23T09:32:29.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19437047,"change_date":"2026-03-12 21:40:00","inspection_id":"87275602","insp_unit_id":"212109159","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"3","insp_unit_license":"TSS9665","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NKDLT0X66R147305","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-15T09:19:43.000000Z","updated_at":"2026-03-23T09:10:59.000000Z"}]},{"id":11174281,"change_date":"2026-02-19 21:40:00","inspection_id":"87090225","dot_number":"4159272","report_state":"TX","report_number":"7CX79DDAH6","insp_date":"2026-02-10 00:00:00","insp_start_time":"0738","insp_end_time":"0805","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"3300  NASA PKWY","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"QUIKRETE","shipping_paper_number":"95001518","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-19 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"9855969","transaction_code":"A","transaction_date":"2026-02-19 00:00:00","upload_date":"2026-02-19 00:00:00","upload_first_byte":"0","upload_dot_number":"04159272","upload_search_indicator":"M","census_search_date":"2026-02-19 21:40:00","snet_input_date":"2026-02-10 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-02-19 21:40:00","insp_carrier_name":"BIG RED TRUCKING LLC","insp_carrier_street":"7116 HARLEM ST","insp_carrier_city":"BAYTOWN","insp_carrier_state":"TX","insp_carrier_zip_code":"77521-1222","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1068871","created_at":"2026-02-22T10:38:06.000000Z","updated_at":"2026-03-02T10:31:08.000000Z","inspection_violations":[{"id":18732912,"change_date":"2026-02-19 21:40:00","inspection_id":"87090225","insp_violation_id":"271901832","seq_no":"2","part_no":"393","part_no_section":"75C","insp_viol_unit":"1","insp_unit_id":"211716512","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-22T10:53:31.000000Z","updated_at":"2026-03-02T10:41:47.000000Z","normalized_code":"39375C"},{"id":18732913,"change_date":"2026-02-19 21:40:00","inspection_id":"87090225","insp_violation_id":"271901833","seq_no":"3","part_no":"392","part_no_section":"2W","insp_viol_unit":"1","insp_unit_id":"211716512","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-22T10:53:31.000000Z","updated_at":"2026-03-02T10:41:47.000000Z","normalized_code":"3922W"},{"id":18732911,"change_date":"2026-02-19 21:40:00","inspection_id":"87090225","insp_violation_id":"271901831","seq_no":"1","part_no":"396","part_no_section":"5B","insp_viol_unit":"1","insp_unit_id":"211716512","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-22T10:53:31.000000Z","updated_at":"2026-03-02T10:41:47.000000Z","normalized_code":"3965B"}],"inspection_per_units":[{"id":19069368,"change_date":"2026-02-19 21:40:00","inspection_id":"87090225","insp_unit_id":"211716512","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"BR 04","insp_unit_license":"VMB9839","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NPAL59X51D566876","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-22T10:13:29.000000Z","updated_at":"2026-03-02T10:04:05.000000Z"}]},{"id":10571442,"change_date":"2026-01-06 21:39:00","inspection_id":"86709371","dot_number":"4159272","report_state":"TX","report_number":"V252167031","insp_date":"2025-12-29 00:00:00","insp_start_time":"0845","insp_end_time":"0916","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH10 EB @ NORMANDY S","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","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":"2026-01-05 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"75400","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":"9806123","transaction_code":"C","transaction_date":"2026-01-06 00:00:00","upload_date":"2026-01-06 00:00:00","upload_first_byte":"0","upload_dot_number":"04159272","upload_search_indicator":"M","census_search_date":"2026-01-05 21:37:00","snet_input_date":"2025-12-29 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-01-05 21:37:00","insp_carrier_name":"BIG RED TRUCKING LLC","insp_carrier_street":"7116 HARLEM ST","insp_carrier_city":"BAYTOWN","insp_carrier_state":"TX","insp_carrier_zip_code":"77521-1222","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1068871","created_at":"2026-01-08T10:34:21.000000Z","updated_at":"2026-01-17T10:30:36.000000Z","inspection_violations":[{"id":17773510,"change_date":"2026-01-06 21:39:00","inspection_id":"86709371","insp_violation_id":"271040308","seq_no":"1","part_no":"396","part_no_section":"5B","insp_viol_unit":"1","insp_unit_id":"210933345","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-09T10:38:37.000000Z","updated_at":"2026-01-17T10:31:13.000000Z","normalized_code":"3965B"}],"inspection_per_units":[{"id":17725832,"change_date":"2026-01-06 21:39:00","inspection_id":"86709371","insp_unit_id":"210933345","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"BR05","insp_unit_license":"VMB9840","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NKWL50X3PS597914","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-09T10:05:54.000000Z","updated_at":"2026-01-17T10:00:50.000000Z"}]},{"id":10571084,"change_date":"2026-01-06 21:39:00","inspection_id":"86708978","dot_number":"4159272","report_state":"TX","report_number":"7BFD9DCJ7M","insp_date":"2025-12-18 00:00:00","insp_start_time":"1253","insp_end_time":"1337","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"400 E LOOP N","county_code_state":"TX","county_code":"201","insp_level_id":"1","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":"2026-01-05 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9805676","transaction_code":"C","transaction_date":"2026-01-06 00:00:00","upload_date":"2026-01-06 00:00:00","upload_first_byte":"0","upload_dot_number":"04159272","upload_search_indicator":"M","census_search_date":"2026-01-05 21:37:00","snet_input_date":"2025-12-18 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-01-05 21:37:00","insp_carrier_name":"BIG RED TRUCKING LLC","insp_carrier_street":"7116 HARLEM ST","insp_carrier_city":"BAYTOWN","insp_carrier_state":"TX","insp_carrier_zip_code":"77521-1222","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1068871","created_at":"2026-01-08T10:34:21.000000Z","updated_at":"2026-01-17T10:30:35.000000Z","inspection_violations":[{"id":17772681,"change_date":"2026-01-06 21:39:00","inspection_id":"86708978","insp_violation_id":"271035447","seq_no":"1","part_no":"393","part_no_section":"45DLUV","insp_viol_unit":"1","insp_unit_id":"210931083","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-09T10:38:35.000000Z","updated_at":"2026-01-17T10:31:09.000000Z","normalized_code":"39345DLUV"}],"inspection_per_units":[{"id":17725389,"change_date":"2026-01-06 21:39:00","inspection_id":"86708978","insp_unit_id":"210931083","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"BR05","insp_unit_license":"VMB9840","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NKWL50X3PS597914","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-09T10:05:53.000000Z","updated_at":"2026-01-17T10:00:49.000000Z"}]},{"id":10288922,"change_date":"2025-11-25 21:39:00","inspection_id":"86414059","dot_number":"4159272","report_state":"TX","report_number":"7AE89DAWY8","insp_date":"2025-11-11 00:00:00","insp_start_time":"0806","insp_end_time":"0852","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"300 S FRIENDSWOOD DR","county_code_state":"TX","county_code":"167","insp_level_id":"2","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-11-25 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"7","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9768058","transaction_code":"A","transaction_date":"2025-11-25 00:00:00","upload_date":"2025-11-25 00:00:00","upload_first_byte":"0","upload_dot_number":"04159272","upload_search_indicator":"M","census_search_date":"2025-11-25 21:39:00","snet_input_date":"2025-11-11 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-11-25 21:39:00","insp_carrier_name":"BIG RED TRUCKING LLC","insp_carrier_street":"7116 HARLEM ST","insp_carrier_city":"BAYTOWN","insp_carrier_state":"TX","insp_carrier_zip_code":"77521-1222","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1068871","created_at":"2025-11-28T10:31:58.000000Z","updated_at":"2025-11-29T10:31:10.000000Z","inspection_violations":[{"id":17205739,"change_date":"2025-11-25 21:39:00","inspection_id":"86414059","insp_violation_id":"270294722","seq_no":"1","part_no":"393","part_no_section":"95A","insp_viol_unit":"1","insp_unit_id":"210265279","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-28T10:32:57.000000Z","updated_at":"2025-11-29T10:31:50.000000Z","normalized_code":"39395A"},{"id":17205740,"change_date":"2025-11-25 21:39:00","inspection_id":"86414059","insp_violation_id":"270294723","seq_no":"2","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"210265279","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-28T10:32:57.000000Z","updated_at":"2025-11-29T10:31:50.000000Z","normalized_code":"3939"},{"id":17205741,"change_date":"2025-11-25 21:39:00","inspection_id":"86414059","insp_violation_id":"270294724","seq_no":"3","part_no":"396","part_no_section":"5B","insp_viol_unit":"1","insp_unit_id":"210265279","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-28T10:32:57.000000Z","updated_at":"2025-11-29T10:31:50.000000Z","normalized_code":"3965B"},{"id":17205742,"change_date":"2025-11-25 21:39:00","inspection_id":"86414059","insp_violation_id":"270294725","seq_no":"5","part_no":"393","part_no_section":"75G-LOAD","insp_viol_unit":"1","insp_unit_id":"210265279","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-11-28T10:32:57.000000Z","updated_at":"2025-11-29T10:31:50.000000Z","normalized_code":"39375GLOAD"},{"id":17205743,"change_date":"2025-11-25 21:39:00","inspection_id":"86414059","insp_violation_id":"270294726","seq_no":"6","part_no":"393","part_no_section":"75G-LOAD","insp_viol_unit":"1","insp_unit_id":"210265279","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-28T10:32:57.000000Z","updated_at":"2025-11-29T10:31:50.000000Z","normalized_code":"39375GLOAD"},{"id":17205744,"change_date":"2025-11-25 21:39:00","inspection_id":"86414059","insp_violation_id":"270294727","seq_no":"7","part_no":"393","part_no_section":"75G-LOAD","insp_viol_unit":"1","insp_unit_id":"210265279","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-28T10:32:57.000000Z","updated_at":"2025-11-29T10:31:50.000000Z","normalized_code":"39375GLOAD"},{"id":17205745,"change_date":"2025-11-25 21:39:00","inspection_id":"86414059","insp_violation_id":"270294728","seq_no":"8","part_no":"393","part_no_section":"75G-LOAD","insp_viol_unit":"1","insp_unit_id":"210265279","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-28T10:32:57.000000Z","updated_at":"2025-11-29T10:31:50.000000Z","normalized_code":"39375GLOAD"}],"inspection_per_units":[{"id":17179537,"change_date":"2025-11-25 21:39:00","inspection_id":"86414059","insp_unit_id":"210265279","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"VMB9840","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NKWL50X3PS597914","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-28T10:01:43.000000Z","updated_at":"2025-11-29T10:01:19.000000Z"}]},{"id":9940896,"change_date":"2025-10-14 21:42:00","inspection_id":"86047986","dot_number":"4159272","report_state":"TX","report_number":"79089DJV03","insp_date":"2025-09-22 00:00:00","insp_start_time":"0756","insp_end_time":"0845","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0010 IN HARRIS CO. (742-797","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"BIG RED TRUCKING LLC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-10-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"43600","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":"9724802","transaction_code":"A","transaction_date":"2025-10-14 00:00:00","upload_date":"2025-10-14 00:00:00","upload_first_byte":"0","upload_dot_number":"04159272","upload_search_indicator":"M","census_search_date":"2025-10-14 21:42:00","snet_input_date":"2025-09-22 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-10-14 21:42:00","insp_carrier_name":"BIG RED TRUCKING LLC","insp_carrier_street":"7116 HARLEM ST","insp_carrier_city":"BAYTOWN","insp_carrier_state":"TX","insp_carrier_zip_code":"77521-1222","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1068871","created_at":"2025-10-17T10:01:51.000000Z","updated_at":"2025-10-18T10:01:18.000000Z","inspection_violations":[{"id":16408753,"change_date":"2025-10-14 21:42:00","inspection_id":"86047986","insp_violation_id":"269296453","seq_no":"1","part_no":"396","part_no_section":"5B","insp_viol_unit":"1","insp_unit_id":"209468127","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-17T10:17:33.000000Z","updated_at":"2025-10-18T10:17:04.000000Z","normalized_code":"3965B"},{"id":16408754,"change_date":"2025-10-14 21:42:00","inspection_id":"86047986","insp_violation_id":"269296454","seq_no":"2","part_no":"393","part_no_section":"45B2UV","insp_viol_unit":"1","insp_unit_id":"209468127","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-17T10:17:33.000000Z","updated_at":"2025-10-18T10:17:04.000000Z","normalized_code":"39345B2UV"}],"inspection_per_units":[{"id":16501114,"change_date":"2025-10-14 21:42:00","inspection_id":"86047986","insp_unit_id":"209468127","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"VMB9840","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NKWL50X3PS597914","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-17T09:46:56.000000Z","updated_at":"2025-10-18T09:46:35.000000Z"}]},{"id":9393211,"change_date":"2025-08-12 21:40:00","inspection_id":"85472305","dot_number":"4159272","report_state":"TX","report_number":"77RD9DNO9T","insp_date":"2025-08-08 00:00:00","insp_start_time":"1334","insp_end_time":"1353","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0225 IN HARRIS CO. (686-700","county_code_state":"TX","county_code":"201","insp_level_id":"2","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-08-12 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"9662939","transaction_code":"A","transaction_date":"2025-08-12 00:00:00","upload_date":"2025-08-12 00:00:00","upload_first_byte":"0","upload_dot_number":"04159272","upload_search_indicator":"M","census_search_date":"2025-08-12 21:40:00","snet_input_date":"2025-08-08 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-08-12 21:40:00","insp_carrier_name":"BIG RED TRUCKING LLC","insp_carrier_street":"7116 HARLEM ST","insp_carrier_city":"BAYTOWN","insp_carrier_state":"TX","insp_carrier_zip_code":"77521-1222","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1068871","created_at":"2025-08-15T10:43:52.000000Z","updated_at":"2025-08-16T10:00:58.000000Z","inspection_violations":[{"id":15271720,"change_date":"2025-08-12 21:40:00","inspection_id":"85472305","insp_violation_id":"267985379","seq_no":"1","part_no":"393","part_no_section":"203A","insp_viol_unit":"1","insp_unit_id":"208360971","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-15T10:45:57.000000Z","updated_at":"2025-08-16T10:44:20.000000Z","normalized_code":"393203A"},{"id":15271721,"change_date":"2025-08-12 21:40:00","inspection_id":"85472305","insp_violation_id":"267985380","seq_no":"2","part_no":"393","part_no_section":"201D","insp_viol_unit":"1","insp_unit_id":"208360971","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-15T10:45:57.000000Z","updated_at":"2025-08-16T10:44:20.000000Z","normalized_code":"393201D"}],"inspection_per_units":[{"id":15479763,"change_date":"2025-08-12 21:40:00","inspection_id":"85472305","insp_unit_id":"208360971","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"03","insp_unit_license":"TSS9665","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NKDLT0X66R147305","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-15T09:46:25.000000Z","updated_at":"2025-08-16T09:46:14.000000Z"}]},{"id":9206365,"change_date":"2025-07-21 21:41:00","inspection_id":"85275863","dot_number":"4159272","report_state":"TX","report_number":"77499DGXZM","insp_date":"2025-07-16 00:00:00","insp_start_time":"0920","insp_end_time":"0955","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"10600  RED BLUFF N\/B","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"BIG RED","shipping_paper_number":"843799","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-07-21 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"8","oos_total":"4","driver_viol_total":"2","driver_oos_total":"2","vehicle_viol_total":"6","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9643875","transaction_code":"A","transaction_date":"2025-07-21 00:00:00","upload_date":"2025-07-21 00:00:00","upload_first_byte":"0","upload_dot_number":"04159272","upload_search_indicator":"M","census_search_date":"2025-07-21 21:41:00","snet_input_date":"2025-07-16 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-07-21 21:41:00","insp_carrier_name":"BIG RED TRUCKING LLC","insp_carrier_street":"7116 HARLEM ST","insp_carrier_city":"BAYTOWN","insp_carrier_state":"TX","insp_carrier_zip_code":"77521-1222","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1068871","created_at":"2025-07-25T10:45:32.000000Z","updated_at":"2025-07-25T10:45:32.000000Z","inspection_violations":[{"id":14880973,"change_date":"2025-07-21 21:41:00","inspection_id":"85275863","insp_violation_id":"267543554","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":"2025-07-25T10:47:00.000000Z","updated_at":"2025-07-25T10:47:00.000000Z","normalized_code":"38323A2"},{"id":14880974,"change_date":"2025-07-21 21:41:00","inspection_id":"85275863","insp_violation_id":"267543555","seq_no":"2","part_no":"391","part_no_section":"41APC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-25T10:47:00.000000Z","updated_at":"2025-07-25T10:47:00.000000Z","normalized_code":"39141APC"},{"id":14880975,"change_date":"2025-07-21 21:41:00","inspection_id":"85275863","insp_violation_id":"267543556","seq_no":"3","part_no":"392","part_no_section":"2W","insp_viol_unit":"1","insp_unit_id":"207989229","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-25T10:47:00.000000Z","updated_at":"2025-07-25T10:47:00.000000Z","normalized_code":"3922W"},{"id":14880976,"change_date":"2025-07-21 21:41:00","inspection_id":"85275863","insp_violation_id":"267543557","seq_no":"4","part_no":"396","part_no_section":"3A1","insp_viol_unit":"1","insp_unit_id":"207989229","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-25T10:47:00.000000Z","updated_at":"2025-07-25T10:47:00.000000Z","normalized_code":"3963A1"},{"id":14880977,"change_date":"2025-07-21 21:41:00","inspection_id":"85275863","insp_violation_id":"267543558","seq_no":"5","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"207989229","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-25T10:47:00.000000Z","updated_at":"2025-07-25T10:47:00.000000Z","normalized_code":"3922RG"},{"id":14880978,"change_date":"2025-07-21 21:41:00","inspection_id":"85275863","insp_violation_id":"267543559","seq_no":"6","part_no":"393","part_no_section":"75G-LOAD","insp_viol_unit":"1","insp_unit_id":"207989229","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-07-25T10:47:00.000000Z","updated_at":"2025-07-25T10:47:00.000000Z","normalized_code":"39375GLOAD"},{"id":14880979,"change_date":"2025-07-21 21:41:00","inspection_id":"85275863","insp_violation_id":"267543560","seq_no":"7","part_no":"393","part_no_section":"207A","insp_viol_unit":"1","insp_unit_id":"207989229","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-07-25T10:47:00.000000Z","updated_at":"2025-07-25T10:47:00.000000Z","normalized_code":"393207A"},{"id":14880980,"change_date":"2025-07-21 21:41:00","inspection_id":"85275863","insp_violation_id":"267543561","seq_no":"8","part_no":"393","part_no_section":"201D","insp_viol_unit":"1","insp_unit_id":"207989229","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-25T10:47:00.000000Z","updated_at":"2025-07-25T10:47:00.000000Z","normalized_code":"393201D"}],"inspection_per_units":[{"id":15135095,"change_date":"2025-07-21 21:41:00","inspection_id":"85275863","insp_unit_id":"207989229","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"02","insp_unit_license":"TJF7851","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NKWL00X4YR859709","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-24T09:45:38.000000Z","updated_at":"2025-07-25T09:46:11.000000Z"}]},{"id":8911602,"change_date":"2025-06-16 21:39:00","inspection_id":"84965219","dot_number":"4159272","report_state":"TX","report_number":"75XC9DHPFI","insp_date":"2025-06-03 00:00:00","insp_start_time":"1208","insp_end_time":"1247","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0045 IN GALVESTON CO. (0-23","county_code_state":"TX","county_code":"167","insp_level_id":"2","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-06-16 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"6","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9607485","transaction_code":"A","transaction_date":"2025-06-16 00:00:00","upload_date":"2025-06-16 00:00:00","upload_first_byte":"0","upload_dot_number":"04159272","upload_search_indicator":"M","census_search_date":"2025-06-16 21:39:00","snet_input_date":"2025-06-03 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-06-16 21:39:00","insp_carrier_name":"BIG RED TRUCKING LLC","insp_carrier_street":"7116 HARLEM ST","insp_carrier_city":"BAYTOWN","insp_carrier_state":"TX","insp_carrier_zip_code":"77521-1222","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1068871","created_at":"2025-06-19T10:00:24.000000Z","updated_at":"2025-06-20T10:00:32.000000Z","inspection_violations":[{"id":14290185,"change_date":"2025-06-16 21:39:00","inspection_id":"84965219","insp_violation_id":"266870198","seq_no":"1","part_no":"392","part_no_section":"2W","insp_viol_unit":"1","insp_unit_id":"207410379","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-19T10:15:36.000000Z","updated_at":"2025-06-20T10:15:59.000000Z","normalized_code":"3922W"},{"id":14290186,"change_date":"2025-06-16 21:39:00","inspection_id":"84965219","insp_violation_id":"266870199","seq_no":"2","part_no":"392","part_no_section":"2W","insp_viol_unit":"1","insp_unit_id":"207410379","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-19T10:15:36.000000Z","updated_at":"2025-06-20T10:15:59.000000Z","normalized_code":"3922W"},{"id":14290187,"change_date":"2025-06-16 21:39:00","inspection_id":"84965219","insp_violation_id":"266870200","seq_no":"3","part_no":"393","part_no_section":"75G-LOAD","insp_viol_unit":"1","insp_unit_id":"207410379","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-06-19T10:15:36.000000Z","updated_at":"2025-06-20T10:15:59.000000Z","normalized_code":"39375GLOAD"},{"id":14290188,"change_date":"2025-06-16 21:39:00","inspection_id":"84965219","insp_violation_id":"266870201","seq_no":"4","part_no":"393","part_no_section":"75G-LOAD","insp_viol_unit":"1","insp_unit_id":"207410379","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-19T10:15:36.000000Z","updated_at":"2025-06-20T10:15:59.000000Z","normalized_code":"39375GLOAD"},{"id":14290189,"change_date":"2025-06-16 21:39:00","inspection_id":"84965219","insp_violation_id":"266870202","seq_no":"5","part_no":"393","part_no_section":"75G-LOAD","insp_viol_unit":"1","insp_unit_id":"207410379","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-19T10:15:36.000000Z","updated_at":"2025-06-20T10:15:59.000000Z","normalized_code":"39375GLOAD"},{"id":14290190,"change_date":"2025-06-16 21:39:00","inspection_id":"84965219","insp_violation_id":"266870203","seq_no":"6","part_no":"393","part_no_section":"75G-LOAD","insp_viol_unit":"1","insp_unit_id":"207410379","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-19T10:15:36.000000Z","updated_at":"2025-06-20T10:15:59.000000Z","normalized_code":"39375GLOAD"}],"inspection_per_units":[{"id":14601207,"change_date":"2025-06-16 21:39:00","inspection_id":"84965219","insp_unit_id":"207410379","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"TJF7851","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NKWL00X4YR859709","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-19T09:45:23.000000Z","updated_at":"2025-06-20T09:45:43.000000Z"}]},{"id":8679209,"change_date":"2025-05-19 21:40:00","inspection_id":"84718919","dot_number":"4159272","report_state":"TX","report_number":"75CB9DCGS2","insp_date":"2025-05-13 00:00:00","insp_start_time":"1035","insp_end_time":"1120","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0610 IN HARRIS CO. (0-37)","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"TEXAN CONCRETE","shipping_paper_number":"119129","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-05-19 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"12","oos_total":"4","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"11","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9581286","transaction_code":"A","transaction_date":"2025-05-19 00:00:00","upload_date":"2025-05-19 00:00:00","upload_first_byte":"0","upload_dot_number":"04159272","upload_search_indicator":"M","census_search_date":"2025-05-19 21:40:00","snet_input_date":"2025-05-13 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-05-19 21:40:00","insp_carrier_name":"BIG RED TRUCKING LLC","insp_carrier_street":"7116 HARLEM ST","insp_carrier_city":"BAYTOWN","insp_carrier_state":"TX","insp_carrier_zip_code":"77521-1222","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1068871","created_at":"2025-05-22T10:01:41.000000Z","updated_at":"2025-05-23T10:05:52.000000Z","inspection_violations":[{"id":13822270,"change_date":"2025-05-19 21:40:00","inspection_id":"84718919","insp_violation_id":"266328337","seq_no":"5","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"206948108","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-22T10:23:04.000000Z","updated_at":"2025-05-23T10:28:56.000000Z","normalized_code":"39347E"},{"id":13822271,"change_date":"2025-05-19 21:40:00","inspection_id":"84718919","insp_violation_id":"266328338","seq_no":"6","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"206948108","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-22T10:23:04.000000Z","updated_at":"2025-05-23T10:28:56.000000Z","normalized_code":"39347E"},{"id":13822272,"change_date":"2025-05-19 21:40:00","inspection_id":"84718919","insp_violation_id":"266328339","seq_no":"7","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"206948108","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-22T10:23:04.000000Z","updated_at":"2025-05-23T10:28:56.000000Z","normalized_code":"39347E"},{"id":13822273,"change_date":"2025-05-19 21:40:00","inspection_id":"84718919","insp_violation_id":"266328340","seq_no":"8","part_no":"393","part_no_section":"53B","insp_viol_unit":"1","insp_unit_id":"206948108","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-22T10:23:04.000000Z","updated_at":"2025-05-23T10:28:56.000000Z","normalized_code":"39353B"},{"id":13822274,"change_date":"2025-05-19 21:40:00","inspection_id":"84718919","insp_violation_id":"266328341","seq_no":"9","part_no":"396","part_no_section":"3A1BOS","insp_viol_unit":"1","insp_unit_id":"206948108","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-05-22T10:23:04.000000Z","updated_at":"2025-05-23T10:28:57.000000Z","normalized_code":"3963A1BOS"},{"id":13822275,"change_date":"2025-05-19 21:40:00","inspection_id":"84718919","insp_violation_id":"266328342","seq_no":"10","part_no":"393","part_no_section":"47A","insp_viol_unit":"1","insp_unit_id":"206948108","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-22T10:23:04.000000Z","updated_at":"2025-05-23T10:28:57.000000Z","normalized_code":"39347A"},{"id":13822276,"change_date":"2025-05-19 21:40:00","inspection_id":"84718919","insp_violation_id":"266328343","seq_no":"11","part_no":"393","part_no_section":"47A","insp_viol_unit":"1","insp_unit_id":"206948108","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-22T10:23:04.000000Z","updated_at":"2025-05-23T10:28:57.000000Z","normalized_code":"39347A"},{"id":13822277,"change_date":"2025-05-19 21:40:00","inspection_id":"84718919","insp_violation_id":"266328344","seq_no":"12","part_no":"393","part_no_section":"209E","insp_viol_unit":"1","insp_unit_id":"206948108","insp_violation_category_id":"21","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-22T10:23:04.000000Z","updated_at":"2025-05-23T10:28:57.000000Z","normalized_code":"393209E"},{"id":13822278,"change_date":"2025-05-19 21:40:00","inspection_id":"84718919","insp_violation_id":"266328345","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":"2025-05-22T10:23:04.000000Z","updated_at":"2025-05-23T10:28:57.000000Z","normalized_code":"38323A2"},{"id":13822279,"change_date":"2025-05-19 21:40:00","inspection_id":"84718919","insp_violation_id":"266328346","seq_no":"2","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"206948108","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-22T10:23:04.000000Z","updated_at":"2025-05-23T10:28:57.000000Z","normalized_code":"3939"},{"id":13822280,"change_date":"2025-05-19 21:40:00","inspection_id":"84718919","insp_violation_id":"266328347","seq_no":"3","part_no":"396","part_no_section":"3A1-TRDL","insp_viol_unit":"1","insp_unit_id":"206948108","insp_violation_category_id":"21","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-05-22T10:23:04.000000Z","updated_at":"2025-05-23T10:28:57.000000Z","normalized_code":"3963A1TRDL"},{"id":13822281,"change_date":"2025-05-19 21:40:00","inspection_id":"84718919","insp_violation_id":"266328348","seq_no":"4","part_no":"393","part_no_section":"47B","insp_viol_unit":"1","insp_unit_id":"206948108","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-05-22T10:23:04.000000Z","updated_at":"2025-05-23T10:28:57.000000Z","normalized_code":"39347B"}],"inspection_per_units":[{"id":14178843,"change_date":"2025-05-19 21:40:00","inspection_id":"84718919","insp_unit_id":"206948108","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"VMB9839","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NPAL59X51D566876","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-22T09:46:23.000000Z","updated_at":"2025-05-23T09:51:10.000000Z"}]},{"id":8493293,"change_date":"2025-04-29 21:49:00","inspection_id":"84523074","dot_number":"4159272","report_state":"TX","report_number":"74T89DCA10","insp_date":"2025-04-24 00:00:00","insp_start_time":"0830","insp_end_time":"0855","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"13500  EAST FWY SOUT","county_code_state":"TX","county_code":"201","insp_level_id":"1","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-29 21:49:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9563302","transaction_code":"A","transaction_date":"2025-04-29 00:00:00","upload_date":"2025-04-29 00:00:00","upload_first_byte":"0","upload_dot_number":"04159272","upload_search_indicator":"M","census_search_date":"2025-04-29 21:49:00","snet_input_date":"2025-04-24 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-04-29 21:49:00","insp_carrier_name":"BIG RED TRUCKING LLC","insp_carrier_street":"7116 HARLEM ST","insp_carrier_city":"BAYTOWN","insp_carrier_state":"TX","insp_carrier_zip_code":"77521-1222","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1068871","created_at":"2025-05-02T10:27:01.000000Z","updated_at":"2025-05-02T13:50:48.000000Z","inspection_violations":[{"id":13435643,"change_date":"2025-04-29 21:49:00","inspection_id":"84523074","insp_violation_id":"265885249","seq_no":"1","part_no":"393","part_no_section":"45B2UV","insp_viol_unit":"1","insp_unit_id":"206538596","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-02T11:00:15.000000Z","updated_at":"2025-05-02T11:21:24.000000Z","normalized_code":"39345B2UV"}],"inspection_per_units":[{"id":13804003,"change_date":"2025-04-29 21:49:00","inspection_id":"84523074","insp_unit_id":"206538596","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"TSS9665","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NKDLT0X66R147305","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-02T10:17:44.000000Z","updated_at":"2025-05-03T10:08:12.000000Z"}]},{"id":8493402,"change_date":"2025-04-29 21:49:00","inspection_id":"84523185","dot_number":"4159272","report_state":"TX","report_number":"74TA9DJV7K","insp_date":"2025-04-24 00:00:00","insp_start_time":"1022","insp_end_time":"1056","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0010 IN HARRIS CO. (742-797","county_code_state":"TX","county_code":"201","insp_level_id":"2","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-29 21:49: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":"9563297","transaction_code":"A","transaction_date":"2025-04-29 00:00:00","upload_date":"2025-04-29 00:00:00","upload_first_byte":"0","upload_dot_number":"04159272","upload_search_indicator":"M","census_search_date":"2025-04-29 21:49:00","snet_input_date":"2025-04-24 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-04-29 21:49:00","insp_carrier_name":"BIG RED TRUCKING LLC","insp_carrier_street":"7116 HARLEM ST","insp_carrier_city":"BAYTOWN","insp_carrier_state":"TX","insp_carrier_zip_code":"77521-1222","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1068871","created_at":"2025-05-02T10:27:01.000000Z","updated_at":"2025-05-02T13:50:50.000000Z","inspection_violations":[{"id":13436090,"change_date":"2025-04-29 21:49:00","inspection_id":"84523185","insp_violation_id":"265885810","seq_no":"1","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"206538796","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-02T11:00:41.000000Z","updated_at":"2025-05-02T11:21:52.000000Z","normalized_code":"3939"}],"inspection_per_units":[{"id":13804178,"change_date":"2025-04-29 21:49:00","inspection_id":"84523185","insp_unit_id":"206538796","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"05","insp_unit_license":"VMB9840","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NKWL50X3PS597914","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-02T10:17:44.000000Z","updated_at":"2025-05-03T10:08:15.000000Z"}]},{"id":7971010,"change_date":"2025-02-27 21:41:00","inspection_id":"83973312","dot_number":"4159272","report_state":"TX","report_number":"737B9DJV23","insp_date":"2025-02-25 00:00:00","insp_start_time":"1100","insp_end_time":"1132","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0010 IN HARRIS CO. (742-797","county_code_state":"TX","county_code":"201","insp_level_id":"2","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-02-26 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","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":"9507800","transaction_code":"C","transaction_date":"2025-02-27 00:00:00","upload_date":"2025-02-27 00:00:00","upload_first_byte":"0","upload_dot_number":"04159272","upload_search_indicator":"M","census_search_date":"2025-02-26 21:42:00","snet_input_date":"2025-02-25 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-02-26 21:42:00","insp_carrier_name":"BIG RED TRUCKING LLC","insp_carrier_street":"7116 HARLEM ST","insp_carrier_city":"BAYTOWN","insp_carrier_state":"TX","insp_carrier_zip_code":"77521-1222","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1068871","created_at":"2025-03-17T21:03:39.000000Z","updated_at":"2025-03-17T21:03:39.000000Z","inspection_violations":[{"id":12454612,"change_date":"2025-02-27 21:41:00","inspection_id":"83973312","insp_violation_id":"264746017","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"205544762","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:50.000000Z","updated_at":"2025-03-17T22:06:50.000000Z","normalized_code":"39378"},{"id":12454613,"change_date":"2025-02-27 21:41:00","inspection_id":"83973312","insp_violation_id":"264746018","seq_no":"2","part_no":"390","part_no_section":"21(a)","insp_viol_unit":"1","insp_unit_id":"205544762","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:50.000000Z","updated_at":"2025-03-17T22:06:50.000000Z","normalized_code":"39021A"}],"inspection_per_units":[{"id":12868103,"change_date":"2025-02-27 21:41:00","inspection_id":"83973312","insp_unit_id":"205544762","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":null,"insp_unit_license":"TPS1076","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NPAX00X51N554368","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:57:08.000000Z","updated_at":"2025-03-17T23:57:08.000000Z"}]},{"id":7673447,"change_date":"2025-01-21 21:40:00","inspection_id":"83660973","dot_number":"4159272","report_state":"TX","report_number":"724A9DGBM7","insp_date":"2025-01-17 00:00:00","insp_start_time":"0933","insp_end_time":"1042","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0045 IN GALVESTON CO. (0-23","county_code_state":"TX","county_code":"167","insp_level_id":"2","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-01-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"7","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9477574","transaction_code":"A","transaction_date":"2025-01-21 00:00:00","upload_date":"2025-01-21 00:00:00","upload_first_byte":"0","upload_dot_number":"04159272","upload_search_indicator":"M","census_search_date":"2025-01-21 21:40:00","snet_input_date":"2025-01-17 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-01-21 21:40:00","insp_carrier_name":"BIG RED TRUCKING LLC","insp_carrier_street":"7116 HARLEM ST","insp_carrier_city":"BAYTOWN","insp_carrier_state":"TX","insp_carrier_zip_code":"77521-1222","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1068871","created_at":"2025-03-17T20:57:28.000000Z","updated_at":"2025-03-17T20:57:28.000000Z","inspection_violations":[{"id":11989205,"change_date":"2025-01-21 21:40:00","inspection_id":"83660973","insp_violation_id":"264103683","seq_no":"1","part_no":"393","part_no_section":"60D","insp_viol_unit":"1","insp_unit_id":"204937892","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:25.000000Z","updated_at":"2025-03-17T22:04:25.000000Z","normalized_code":"39360D"},{"id":11989206,"change_date":"2025-01-21 21:40:00","inspection_id":"83660973","insp_violation_id":"264103684","seq_no":"2","part_no":"393","part_no_section":"75G-LOAD","insp_viol_unit":"1","insp_unit_id":"204937892","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:04:25.000000Z","updated_at":"2025-03-17T22:04:25.000000Z","normalized_code":"39375GLOAD"},{"id":11989207,"change_date":"2025-01-21 21:40:00","inspection_id":"83660973","insp_violation_id":"264103685","seq_no":"3","part_no":"393","part_no_section":"75G-LOAD","insp_viol_unit":"1","insp_unit_id":"204937892","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:25.000000Z","updated_at":"2025-03-17T22:04:25.000000Z","normalized_code":"39375GLOAD"},{"id":11989208,"change_date":"2025-01-21 21:40:00","inspection_id":"83660973","insp_violation_id":"264103686","seq_no":"4","part_no":"393","part_no_section":"75G-LOAD","insp_viol_unit":"1","insp_unit_id":"204937892","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:25.000000Z","updated_at":"2025-03-17T22:04:25.000000Z","normalized_code":"39375GLOAD"},{"id":11989209,"change_date":"2025-01-21 21:40:00","inspection_id":"83660973","insp_violation_id":"264103687","seq_no":"5","part_no":"393","part_no_section":"75G-LOAD","insp_viol_unit":"1","insp_unit_id":"204937892","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:25.000000Z","updated_at":"2025-03-17T22:04:25.000000Z","normalized_code":"39375GLOAD"},{"id":11989210,"change_date":"2025-01-21 21:40:00","inspection_id":"83660973","insp_violation_id":"264103688","seq_no":"6","part_no":"392","part_no_section":"2W","insp_viol_unit":"1","insp_unit_id":"204937892","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:25.000000Z","updated_at":"2025-03-17T22:04:25.000000Z","normalized_code":"3922W"},{"id":11989211,"change_date":"2025-01-21 21:40:00","inspection_id":"83660973","insp_violation_id":"264103689","seq_no":"7","part_no":"392","part_no_section":"2W","insp_viol_unit":"1","insp_unit_id":"204937892","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:25.000000Z","updated_at":"2025-03-17T22:04:25.000000Z","normalized_code":"3922W"}],"inspection_per_units":[{"id":12382076,"change_date":"2025-01-21 21:40:00","inspection_id":"83660973","insp_unit_id":"204937892","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"V-7914","insp_unit_license":"VMB9840","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NKWL50X3PS597914","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:51:39.000000Z","updated_at":"2025-03-17T23:51:39.000000Z"}]},{"id":7566670,"change_date":"2025-01-08 21:39:00","inspection_id":"83548812","dot_number":"4159272","report_state":"TX","report_number":"71BC9DCPQB","insp_date":"2024-12-19 00:00:00","insp_start_time":"1200","insp_end_time":"1220","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"3000  JEWEL","county_code_state":"TX","county_code":"201","insp_level_id":"2","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-01-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"9467144","transaction_code":"C","transaction_date":"2025-01-08 00:00:00","upload_date":"2025-01-08 00:00:00","upload_first_byte":"0","upload_dot_number":"04159272","upload_search_indicator":"M","census_search_date":"2025-01-07 21:40:00","snet_input_date":"2024-12-19 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-01-07 21:40:00","insp_carrier_name":"BIG RED TRUCKING LLC","insp_carrier_street":"7116 HARLEM ST","insp_carrier_city":"BAYTOWN","insp_carrier_state":"TX","insp_carrier_zip_code":"77521-1222","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1068871","created_at":"2025-03-17T20:55:16.000000Z","updated_at":"2025-03-17T20:55:16.000000Z","inspection_violations":[{"id":11828246,"change_date":"2025-01-08 21:39:00","inspection_id":"83548812","insp_violation_id":"263818244","seq_no":"1","part_no":"393","part_no_section":"24A","insp_viol_unit":"1","insp_unit_id":"204708366","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:38.000000Z","updated_at":"2025-03-17T22:03:38.000000Z","normalized_code":"39324A"},{"id":11828247,"change_date":"2025-01-08 21:39:00","inspection_id":"83548812","insp_violation_id":"263818245","seq_no":"2","part_no":"393","part_no_section":"95A","insp_viol_unit":"1","insp_unit_id":"204708366","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:38.000000Z","updated_at":"2025-03-17T22:03:38.000000Z","normalized_code":"39395A"},{"id":11828248,"change_date":"2025-01-08 21:39:00","inspection_id":"83548812","insp_violation_id":"263818246","seq_no":"3","part_no":"393","part_no_section":"203C","insp_viol_unit":"1","insp_unit_id":"204708366","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:38.000000Z","updated_at":"2025-03-17T22:03:38.000000Z","normalized_code":"393203C"}],"inspection_per_units":[{"id":12208680,"change_date":"2025-01-08 21:39:00","inspection_id":"83548812","insp_unit_id":"204708366","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"VMB9840","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NKWL50X3PS597914","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:49:46.000000Z","updated_at":"2025-03-17T23:49:46.000000Z"}]},{"id":7520156,"change_date":"2024-12-30 21:39:00","inspection_id":"83499919","dot_number":"4159272","report_state":"TX","report_number":"718A9DGXIM","insp_date":"2024-12-16 00:00:00","insp_start_time":"1021","insp_end_time":"1107","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"200 E SAM HOUSTON PK","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"ALLIED CONCRETE","shipping_paper_number":"86101554","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-30 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","viol_total":"17","oos_total":"4","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"15","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9460554","transaction_code":"A","transaction_date":"2024-12-30 00:00:00","upload_date":"2024-12-30 00:00:00","upload_first_byte":"0","upload_dot_number":"04159272","upload_search_indicator":"M","census_search_date":"2024-12-30 21:39:00","snet_input_date":"2024-12-16 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-12-30 21:39:00","insp_carrier_name":"BIG RED TRUCKING LLC","insp_carrier_street":"7116 HARLEM ST","insp_carrier_city":"BAYTOWN","insp_carrier_state":"TX","insp_carrier_zip_code":"77521-1222","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1068871","created_at":"2025-03-17T20:53:08.000000Z","updated_at":"2025-03-17T20:53:08.000000Z","inspection_violations":[{"id":11753348,"change_date":"2024-12-30 21:39:00","inspection_id":"83499919","insp_violation_id":"263697161","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":"2025-03-17T22:03:16.000000Z","updated_at":"2025-03-17T22:03:16.000000Z","normalized_code":"38323A2"},{"id":11753349,"change_date":"2024-12-30 21:39:00","inspection_id":"83499919","insp_violation_id":"263697162","seq_no":"2","part_no":"391","part_no_section":"41A","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:16.000000Z","updated_at":"2025-03-17T22:03:16.000000Z","normalized_code":"39141A"},{"id":11753350,"change_date":"2024-12-30 21:39:00","inspection_id":"83499919","insp_violation_id":"263697163","seq_no":"3","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"204595129","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:16.000000Z","updated_at":"2025-03-17T22:03:16.000000Z","normalized_code":"39347E"},{"id":11753351,"change_date":"2024-12-30 21:39:00","inspection_id":"83499919","insp_violation_id":"263697164","seq_no":"4","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"204595129","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:16.000000Z","updated_at":"2025-03-17T22:03:16.000000Z","normalized_code":"39347E"},{"id":11753352,"change_date":"2024-12-30 21:39:00","inspection_id":"83499919","insp_violation_id":"263697165","seq_no":"5","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"204595129","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:16.000000Z","updated_at":"2025-03-17T22:03:16.000000Z","normalized_code":"39347E"},{"id":11753353,"change_date":"2024-12-30 21:39:00","inspection_id":"83499919","insp_violation_id":"263697166","seq_no":"6","part_no":"393","part_no_section":"53B","insp_viol_unit":"1","insp_unit_id":"204595129","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:16.000000Z","updated_at":"2025-03-17T22:03:16.000000Z","normalized_code":"39353B"},{"id":11753354,"change_date":"2024-12-30 21:39:00","inspection_id":"83499919","insp_violation_id":"263697167","seq_no":"7","part_no":"396","part_no_section":"3A1BOS","insp_viol_unit":"1","insp_unit_id":"204595129","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T22:03:16.000000Z","updated_at":"2025-03-17T22:03:16.000000Z","normalized_code":"3963A1BOS"},{"id":11753355,"change_date":"2024-12-30 21:39:00","inspection_id":"83499919","insp_violation_id":"263697168","seq_no":"8","part_no":"393","part_no_section":"47B","insp_viol_unit":"1","insp_unit_id":"204595129","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T22:03:16.000000Z","updated_at":"2025-03-17T22:03:16.000000Z","normalized_code":"39347B"},{"id":11753356,"change_date":"2024-12-30 21:39:00","inspection_id":"83499919","insp_violation_id":"263697169","seq_no":"9","part_no":"393","part_no_section":"83G","insp_viol_unit":"1","insp_unit_id":"204595129","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:16.000000Z","updated_at":"2025-03-17T22:03:16.000000Z","normalized_code":"39383G"},{"id":11753357,"change_date":"2024-12-30 21:39:00","inspection_id":"83499919","insp_violation_id":"263697170","seq_no":"10","part_no":"393","part_no_section":"45B2UV","insp_viol_unit":"1","insp_unit_id":"204595129","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:16.000000Z","updated_at":"2025-03-17T22:03:16.000000Z","normalized_code":"39345B2UV"},{"id":11753358,"change_date":"2024-12-30 21:39:00","inspection_id":"83499919","insp_violation_id":"263697171","seq_no":"11","part_no":"393","part_no_section":"75G-LOAD","insp_viol_unit":"1","insp_unit_id":"204595129","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T22:03:16.000000Z","updated_at":"2025-03-17T22:03:16.000000Z","normalized_code":"39375GLOAD"},{"id":11753359,"change_date":"2024-12-30 21:39:00","inspection_id":"83499919","insp_violation_id":"263697172","seq_no":"12","part_no":"393","part_no_section":"75G-LOAD","insp_viol_unit":"1","insp_unit_id":"204595129","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:16.000000Z","updated_at":"2025-03-17T22:03:16.000000Z","normalized_code":"39375GLOAD"},{"id":11753360,"change_date":"2024-12-30 21:39:00","inspection_id":"83499919","insp_violation_id":"263697173","seq_no":"13","part_no":"393","part_no_section":"75G-LOAD","insp_viol_unit":"1","insp_unit_id":"204595129","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:16.000000Z","updated_at":"2025-03-17T22:03:16.000000Z","normalized_code":"39375GLOAD"},{"id":11753361,"change_date":"2024-12-30 21:39:00","inspection_id":"83499919","insp_violation_id":"263697174","seq_no":"14","part_no":"393","part_no_section":"75G-LOAD","insp_viol_unit":"1","insp_unit_id":"204595129","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:16.000000Z","updated_at":"2025-03-17T22:03:16.000000Z","normalized_code":"39375GLOAD"},{"id":11753362,"change_date":"2024-12-30 21:39:00","inspection_id":"83499919","insp_violation_id":"263697175","seq_no":"15","part_no":"392","part_no_section":"2W","insp_viol_unit":"1","insp_unit_id":"204595129","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:16.000000Z","updated_at":"2025-03-17T22:03:16.000000Z","normalized_code":"3922W"},{"id":11753363,"change_date":"2024-12-30 21:39:00","inspection_id":"83499919","insp_violation_id":"263697176","seq_no":"16","part_no":"392","part_no_section":"2W","insp_viol_unit":"1","insp_unit_id":"204595129","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:16.000000Z","updated_at":"2025-03-17T22:03:16.000000Z","normalized_code":"3922W"},{"id":11753364,"change_date":"2024-12-30 21:39:00","inspection_id":"83499919","insp_violation_id":"263697177","seq_no":"17","part_no":"396","part_no_section":"5B","insp_viol_unit":"1","insp_unit_id":"204595129","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:16.000000Z","updated_at":"2025-03-17T22:03:16.000000Z","normalized_code":"3965B"}],"inspection_per_units":[{"id":12132309,"change_date":"2024-12-30 21:39:00","inspection_id":"83499919","insp_unit_id":"204595129","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"04","insp_unit_license":"VMB9839","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NPAL59X51D566876","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:48:57.000000Z","updated_at":"2025-03-17T23:48:57.000000Z"}]},{"id":7383077,"change_date":"2024-12-12 21:42:00","inspection_id":"83355997","dot_number":"4159272","report_state":"TX","report_number":"70U99DKY9O","insp_date":"2024-12-02 00:00:00","insp_start_time":"0932","insp_end_time":"1000","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"3000  AVE R","county_code_state":"TX","county_code":"167","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"OPEN","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":"2024-12-10 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"9442846","transaction_code":"C","transaction_date":"2024-12-12 00:00:00","upload_date":"2024-12-12 00:00:00","upload_first_byte":"0","upload_dot_number":"04159272","upload_search_indicator":"M","census_search_date":"2024-12-10 21:41:00","snet_input_date":"2024-12-02 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-12-10 21:41:00","insp_carrier_name":"BIG RED TRUCKING LLC","insp_carrier_street":"7116 HARLEM ST","insp_carrier_city":"BAYTOWN","insp_carrier_state":"TX","insp_carrier_zip_code":"77521-1222","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1068871","created_at":"2025-03-17T20:50:16.000000Z","updated_at":"2025-03-17T20:50:16.000000Z","inspection_violations":[{"id":11534397,"change_date":"2024-12-12 21:42:00","inspection_id":"83355997","insp_violation_id":"263425831","seq_no":"3","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"204352096","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:07.000000Z","updated_at":"2025-03-17T22:02:07.000000Z","normalized_code":"3922RG"},{"id":11534398,"change_date":"2024-12-12 21:42:00","inspection_id":"83355997","insp_violation_id":"263425832","seq_no":"4","part_no":"393","part_no_section":"207A","insp_viol_unit":"1","insp_unit_id":"204352096","insp_violation_category_id":"22","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:02:07.000000Z","updated_at":"2025-03-17T22:02:07.000000Z","normalized_code":"393207A"}],"inspection_per_units":[{"id":11909992,"change_date":"2024-12-12 21:42:00","inspection_id":"83355997","insp_unit_id":"204352096","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"3","insp_unit_license":"TJF7851","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NKWL00X4YR859709","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":6828902,"change_date":"2024-09-26 21:40:00","inspection_id":"82768998","dot_number":"4159272","report_state":"TX","report_number":"6YY89DCRY5","insp_date":"2024-09-25 00:00:00","insp_start_time":"0857","insp_end_time":"0935","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0010 IN HARRIS CO. (742-797","county_code_state":"TX","county_code":"201","insp_level_id":"2","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":"2024-09-26 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":"9387239","transaction_code":"A","transaction_date":"2024-09-26 00:00:00","upload_date":"2024-09-26 00:00:00","upload_first_byte":"0","upload_dot_number":"04159272","upload_search_indicator":"M","census_search_date":"2024-09-26 21:40:00","snet_input_date":"2024-09-25 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-09-26 21:40:00","insp_carrier_name":"BIG RED TRUCKING LLC","insp_carrier_street":"7116 HARLEM ST","insp_carrier_city":"BAYTOWN","insp_carrier_state":"TX","insp_carrier_zip_code":"77521-1222","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1068871","created_at":"2025-03-17T20:38:36.000000Z","updated_at":"2025-03-17T20:38:36.000000Z","inspection_violations":[{"id":10635394,"change_date":"2024-09-26 21:40:00","inspection_id":"82768998","insp_violation_id":"262054873","seq_no":"1","part_no":"393","part_no_section":"201(a)","insp_viol_unit":"1","insp_unit_id":"203149344","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:29.000000Z","updated_at":"2025-03-17T21:57:29.000000Z","normalized_code":"393201A"}],"inspection_per_units":[{"id":11012580,"change_date":"2024-09-26 21:40:00","inspection_id":"82768998","insp_unit_id":"203149344","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"BR02","insp_unit_license":"TJF7851","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NKWL00X4YR859709","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:37:03.000000Z","updated_at":"2025-03-17T23:37:03.000000Z"}]},{"id":6691988,"change_date":"2024-09-11 21:41:00","inspection_id":"82623130","dot_number":"4159272","report_state":"TX","report_number":"6YF79DAY3C","insp_date":"2024-09-06 00:00:00","insp_start_time":"0711","insp_end_time":"0756","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"18700  KICKAPOO RD","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CAMPBELL","shipping_paper_number":"1037301","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-09-10 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"0","viol_total":"6","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9373531","transaction_code":"C","transaction_date":"2024-09-11 00:00:00","upload_date":"2024-09-11 00:00:00","upload_first_byte":"0","upload_dot_number":"04159272","upload_search_indicator":"M","census_search_date":"2024-09-10 21:40:00","snet_input_date":"2024-09-06 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-09-10 21:40:00","insp_carrier_name":"BIG RED TRUCKING LLC","insp_carrier_street":"7116 HARLEM ST","insp_carrier_city":"BAYTOWN","insp_carrier_state":"TX","insp_carrier_zip_code":"77521-1222","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1068871","created_at":"2025-03-17T20:35:40.000000Z","updated_at":"2025-03-17T20:35:40.000000Z","inspection_violations":[{"id":10416076,"change_date":"2024-09-11 21:41:00","inspection_id":"82623130","insp_violation_id":"261747449","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"202876112","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:25.000000Z","updated_at":"2025-03-17T21:56:25.000000Z","normalized_code":"39311"},{"id":10416077,"change_date":"2024-09-11 21:41:00","inspection_id":"82623130","insp_violation_id":"261747450","seq_no":"2","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"202876112","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:25.000000Z","updated_at":"2025-03-17T21:56:25.000000Z","normalized_code":"39378"},{"id":10416078,"change_date":"2024-09-11 21:41:00","inspection_id":"82623130","insp_violation_id":"261747451","seq_no":"4","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"202876112","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"2","citation_number":null,"created_at":"2025-03-17T21:56:25.000000Z","updated_at":"2025-03-17T21:56:25.000000Z","normalized_code":"3963A1"},{"id":10416079,"change_date":"2024-09-11 21:41:00","inspection_id":"82623130","insp_violation_id":"261747452","seq_no":"5","part_no":"393","part_no_section":"83(g)","insp_viol_unit":"1","insp_unit_id":"202876112","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:25.000000Z","updated_at":"2025-03-17T21:56:25.000000Z","normalized_code":"39383G"},{"id":10416080,"change_date":"2024-09-11 21:41:00","inspection_id":"82623130","insp_violation_id":"261747453","seq_no":"6","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"202876112","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:25.000000Z","updated_at":"2025-03-17T21:56:25.000000Z","normalized_code":"39345B2"},{"id":10416081,"change_date":"2024-09-11 21:41:00","inspection_id":"82623130","insp_violation_id":"261747454","seq_no":"7","part_no":"393","part_no_section":"45","insp_viol_unit":"1","insp_unit_id":"202876112","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"2","citation_number":null,"created_at":"2025-03-17T21:56:25.000000Z","updated_at":"2025-03-17T21:56:25.000000Z","normalized_code":"39345"}],"inspection_per_units":[{"id":10790176,"change_date":"2024-09-11 21:41:00","inspection_id":"82623130","insp_unit_id":"202876112","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"03","insp_unit_license":"TSS9665","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NKDLT0X66R147305","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:34:44.000000Z","updated_at":"2025-03-17T23:34:44.000000Z"}]},{"id":6713572,"change_date":"2024-09-12 21:42:00","inspection_id":"82646071","dot_number":"4159272","report_state":"TX","report_number":"6YEA9DGPBL","insp_date":"2024-09-05 00:00:00","insp_start_time":"1001","insp_end_time":"1045","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"13500  EAST FWY","county_code_state":"TX","county_code":"201","insp_level_id":"1","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":"2024-09-12 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","viol_total":"9","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"8","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9375784","transaction_code":"A","transaction_date":"2024-09-12 00:00:00","upload_date":"2024-09-12 00:00:00","upload_first_byte":"0","upload_dot_number":"04159272","upload_search_indicator":"M","census_search_date":"2024-09-12 21:42:00","snet_input_date":"2024-09-05 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-09-12 21:42:00","insp_carrier_name":"BIG RED TRUCKING LLC","insp_carrier_street":"7116 HARLEM ST","insp_carrier_city":"BAYTOWN","insp_carrier_state":"TX","insp_carrier_zip_code":"77521-1222","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1068871","created_at":"2025-03-17T20:36:07.000000Z","updated_at":"2025-03-17T20:36:07.000000Z","inspection_violations":[{"id":10450927,"change_date":"2024-09-12 21:42:00","inspection_id":"82646071","insp_violation_id":"261771270","seq_no":"1","part_no":"391","part_no_section":"11(b)(5)","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":"2025-03-17T21:56:37.000000Z","updated_at":"2025-03-17T21:56:37.000000Z","normalized_code":"39111B5"},{"id":10450928,"change_date":"2024-09-12 21:42:00","inspection_id":"82646071","insp_violation_id":"261771271","seq_no":"2","part_no":"390","part_no_section":"21(a)","insp_viol_unit":"1","insp_unit_id":"202897339","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:37.000000Z","updated_at":"2025-03-17T21:56:37.000000Z","normalized_code":"39021A"},{"id":10450929,"change_date":"2024-09-12 21:42:00","inspection_id":"82646071","insp_violation_id":"261771272","seq_no":"3","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"202897339","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:37.000000Z","updated_at":"2025-03-17T21:56:37.000000Z","normalized_code":"39378"},{"id":10450930,"change_date":"2024-09-12 21:42:00","inspection_id":"82646071","insp_violation_id":"261771273","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202897339","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:37.000000Z","updated_at":"2025-03-17T21:56:37.000000Z","normalized_code":"3939A"},{"id":10450931,"change_date":"2024-09-12 21:42:00","inspection_id":"82646071","insp_violation_id":"261771274","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202897339","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:37.000000Z","updated_at":"2025-03-17T21:56:37.000000Z","normalized_code":"3939A"},{"id":10450932,"change_date":"2024-09-12 21:42:00","inspection_id":"82646071","insp_violation_id":"261771275","seq_no":"6","part_no":"999","part_no_section":null,"insp_viol_unit":"1","insp_unit_id":"202897339","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:37.000000Z","updated_at":"2025-03-17T21:56:37.000000Z","normalized_code":"999"},{"id":10450933,"change_date":"2024-09-12 21:42:00","inspection_id":"82646071","insp_violation_id":"261771276","seq_no":"7","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202897339","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:37.000000Z","updated_at":"2025-03-17T21:56:37.000000Z","normalized_code":"3939A"},{"id":10450934,"change_date":"2024-09-12 21:42:00","inspection_id":"82646071","insp_violation_id":"261771277","seq_no":"8","part_no":"393","part_no_section":"45","insp_viol_unit":"1","insp_unit_id":"202897339","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:37.000000Z","updated_at":"2025-03-17T21:56:37.000000Z","normalized_code":"39345"},{"id":10450935,"change_date":"2024-09-12 21:42:00","inspection_id":"82646071","insp_violation_id":"261771278","seq_no":"9","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202897339","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:37.000000Z","updated_at":"2025-03-17T21:56:37.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":10825472,"change_date":"2024-09-12 21:42:00","inspection_id":"82646071","insp_unit_id":"202897339","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"105","insp_unit_license":"TPS1076","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NPAX00X51N554368","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:35:07.000000Z","updated_at":"2025-03-17T23:35:07.000000Z"}]},{"id":6550028,"change_date":"2024-08-23 21:41:00","inspection_id":"82471897","dot_number":"4159272","report_state":"TX","report_number":"6XS79DJMRP","insp_date":"2024-08-14 00:00:00","insp_start_time":"0755","insp_end_time":"0820","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"14300  S WAYSIDE","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"D AND D READY MIX","shipping_paper_number":"42797","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-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"66000","viol_total":"5","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9358804","transaction_code":"A","transaction_date":"2024-08-23 00:00:00","upload_date":"2024-08-23 00:00:00","upload_first_byte":"0","upload_dot_number":"04159272","upload_search_indicator":"M","census_search_date":"2024-08-23 21:41:00","snet_input_date":"2024-08-14 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-08-23 21:41:00","insp_carrier_name":"BIG RED TRUCKING LLC","insp_carrier_street":"7116 HARLEM ST","insp_carrier_city":"BAYTOWN","insp_carrier_state":"TX","insp_carrier_zip_code":"77521-1222","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1068871","created_at":"2025-03-17T20:32:47.000000Z","updated_at":"2025-03-17T20:32:47.000000Z","inspection_violations":[{"id":10177357,"change_date":"2024-08-23 21:41:00","inspection_id":"82471897","insp_violation_id":"261379834","seq_no":"1","part_no":"390","part_no_section":"21(a)","insp_viol_unit":"1","insp_unit_id":"202559410","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:13.000000Z","updated_at":"2025-03-17T21:55:13.000000Z","normalized_code":"39021A"},{"id":10177358,"change_date":"2024-08-23 21:41:00","inspection_id":"82471897","insp_violation_id":"261379835","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202559410","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:13.000000Z","updated_at":"2025-03-17T21:55:13.000000Z","normalized_code":"3939A"},{"id":10177359,"change_date":"2024-08-23 21:41:00","inspection_id":"82471897","insp_violation_id":"261379836","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202559410","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:13.000000Z","updated_at":"2025-03-17T21:55:13.000000Z","normalized_code":"3939A"},{"id":10177360,"change_date":"2024-08-23 21:41:00","inspection_id":"82471897","insp_violation_id":"261379837","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202559410","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:13.000000Z","updated_at":"2025-03-17T21:55:13.000000Z","normalized_code":"3939A"},{"id":10177361,"change_date":"2024-08-23 21:41:00","inspection_id":"82471897","insp_violation_id":"261379838","seq_no":"5","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"202559410","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:13.000000Z","updated_at":"2025-03-17T21:55:13.000000Z","normalized_code":"39345B2"}],"inspection_per_units":[{"id":10559236,"change_date":"2024-08-23 21:41:00","inspection_id":"82471897","insp_unit_id":"202559410","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"1","insp_unit_license":"TPS1076","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NPAX00X51N554368","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:32:22.000000Z","updated_at":"2025-03-17T23:32:22.000000Z"}]},{"id":5260569,"change_date":"2024-03-13 21:42:00","inspection_id":"81077729","dot_number":"4159272","report_state":"TX","report_number":"6TC99DCPF2","insp_date":"2024-03-07 00:00:00","insp_start_time":"0930","insp_end_time":"1000","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"13500  EAST FWY SOUT","county_code_state":"TX","county_code":"201","insp_level_id":"1","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":"2024-03-11 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"70000","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":"9219429","transaction_code":"C","transaction_date":"2024-03-12 00:00:00","upload_date":"2024-03-13 00:00:00","upload_first_byte":"0","upload_dot_number":"04159272","upload_search_indicator":"M","census_search_date":"2024-03-11 21:44:00","snet_input_date":"2024-03-07 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-03-11 21:44:00","insp_carrier_name":"BIG RED TRUCKING LLC","insp_carrier_street":"7116 HARLEM ST","insp_carrier_city":"BAYTOWN","insp_carrier_state":"TX","insp_carrier_zip_code":"77521-1222","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1068871","created_at":"2025-03-17T20:07:02.000000Z","updated_at":"2025-03-17T20:07:02.000000Z","inspection_violations":[{"id":8112295,"change_date":"2024-03-13 21:42:00","inspection_id":"81077729","insp_violation_id":"258366359","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"199898091","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:12.000000Z","updated_at":"2025-03-17T21:45:12.000000Z","normalized_code":"3939A"},{"id":8112296,"change_date":"2024-03-13 21:42:00","inspection_id":"81077729","insp_violation_id":"258366360","seq_no":"2","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"199898091","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:12.000000Z","updated_at":"2025-03-17T21:45:12.000000Z","normalized_code":"39345B2"},{"id":8112297,"change_date":"2024-03-13 21:42:00","inspection_id":"81077729","insp_violation_id":"258366361","seq_no":"3","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"199898091","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:12.000000Z","updated_at":"2025-03-17T21:45:12.000000Z","normalized_code":"39345D"}],"inspection_per_units":[{"id":8471141,"change_date":"2024-03-13 21:42:00","inspection_id":"81077729","insp_unit_id":"199898091","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"TJF7851","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NKWL00X4YR859709","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:47.000000Z","updated_at":"2025-03-17T23:11:47.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/4159272\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/4159272\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/4159272\/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\/4159272\/inspections","per_page":100,"prev_page_url":null,"to":26,"total":26}