{"current_page":1,"data":[{"id":12708071,"change_date":"2026-08-12 21:43:00","inspection_id":"88682960","dot_number":"4257239","report_state":"TX","report_number":"V262523903","insp_date":"2026-08-10 00:00:00","insp_start_time":"1044","insp_end_time":"1107","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH 35 NB MM 59","county_code_state":"TX","county_code":"283","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CHEMTREC","shipping_paper_number":"209338","cargo_tank":"407","hazmat_placard_req":"Y","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-08-12 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"10067788","transaction_code":"A","transaction_date":"2026-08-12 00:00:00","upload_date":"2026-08-12 00:00:00","upload_first_byte":"0","upload_dot_number":"04257239","upload_search_indicator":"M","census_search_date":"2026-08-12 21:43:00","snet_input_date":"2026-08-10 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-08-12 21:43:00","insp_carrier_name":"DELROS 4WHEEL LLC","insp_carrier_street":"2 HERMANN PARK CT","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77021","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1081694","created_at":"2026-08-15T09:41:41.000000Z","updated_at":"2026-08-23T09:31:29.000000Z","inspection_violations":[],"inspection_per_units":[{"id":22054435,"change_date":"2026-08-12 21:43:00","inspection_id":"88682960","insp_unit_id":"215123497","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"114","insp_unit_license":"R849863","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPBDP9X6RD605442","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-08-15T09:18:34.000000Z","updated_at":"2026-08-23T09:03:08.000000Z"},{"id":22054436,"change_date":"2026-08-12 21:43:00","inspection_id":"88682960","insp_unit_id":"215123498","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"DRAG","insp_unit_company":"591","insp_unit_license":"246B205","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UNST4426FS140343","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-08-15T09:18:34.000000Z","updated_at":"2026-08-23T09:03:08.000000Z"}]},{"id":12253548,"change_date":"2026-06-22 21:40:00","inspection_id":"88212064","dot_number":"4257239","report_state":"TX","report_number":"V262435596","insp_date":"2026-06-20 00:00:00","insp_start_time":"1356","insp_end_time":"1426","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"INTERSTATE 35 MILE M","county_code_state":"TX","county_code":"283","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CRESENT 2","shipping_paper_number":"207438","cargo_tank":"407","hazmat_placard_req":"Y","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-06-22 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","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":"10002577","transaction_code":"A","transaction_date":"2026-06-22 00:00:00","upload_date":"2026-06-22 00:00:00","upload_first_byte":"0","upload_dot_number":"04257239","upload_search_indicator":"M","census_search_date":"2026-06-22 21:40:00","snet_input_date":"2026-06-20 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-06-22 21:40:00","insp_carrier_name":"DELROS 4WHEEL LLC","insp_carrier_street":"2 HERMANN PARK CT","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77021","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1081694","created_at":"2026-06-25T09:39:03.000000Z","updated_at":"2026-07-03T09:31:23.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21278725,"change_date":"2026-06-22 21:40:00","inspection_id":"88212064","insp_unit_id":"214230544","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"DRAG","insp_unit_company":"625","insp_unit_license":"246B204","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UNST4425FS140365","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-25T09:16:35.000000Z","updated_at":"2026-07-05T09:02:42.000000Z"},{"id":21278724,"change_date":"2026-06-22 21:40:00","inspection_id":"88212064","insp_unit_id":"214230543","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"110","insp_unit_license":"R851773","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3AKJHPDV9KSJY3764","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-25T09:16:35.000000Z","updated_at":"2026-07-05T09:02:42.000000Z"}]},{"id":11519973,"change_date":"2026-03-30 21:39:00","inspection_id":"87441132","dot_number":"4257239","report_state":"TX","report_number":"V262279494","insp_date":"2026-03-24 00:00:00","insp_start_time":"1900","insp_end_time":"1937","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH 10 MP 404","county_code_state":"TX","county_code":"435","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"PILOT","shipping_paper_number":"263164767","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":"2026-03-30 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","viol_total":"5","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9899901","transaction_code":"A","transaction_date":"2026-03-30 00:00:00","upload_date":"2026-03-30 00:00:00","upload_first_byte":"0","upload_dot_number":"04257239","upload_search_indicator":"M","census_search_date":"2026-03-30 21:39:00","snet_input_date":"2026-03-24 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-03-30 21:39:00","insp_carrier_name":"DELROS 4WHEEL LLC","insp_carrier_street":"2 HERMANN PARK CT","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77021","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1081694","created_at":"2026-04-02T09:46:58.000000Z","updated_at":"2026-04-10T09:31:32.000000Z","inspection_violations":[{"id":19458711,"change_date":"2026-03-30 21:39:00","inspection_id":"87441132","insp_violation_id":"272744892","seq_no":"1","part_no":"393","part_no_section":"45B2UV","insp_viol_unit":"1","insp_unit_id":"212431925","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-02T10:10:29.000000Z","updated_at":"2026-04-09T09:52:49.000000Z","normalized_code":"39345B2UV"},{"id":19458712,"change_date":"2026-03-30 21:39:00","inspection_id":"87441132","insp_violation_id":"272744893","seq_no":"2","part_no":"393","part_no_section":"45B2UV","insp_viol_unit":"1","insp_unit_id":"212431925","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-02T10:10:29.000000Z","updated_at":"2026-04-09T09:52:49.000000Z","normalized_code":"39345B2UV"},{"id":19458713,"change_date":"2026-03-30 21:39:00","inspection_id":"87441132","insp_violation_id":"272744894","seq_no":"3","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"212431926","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-02T10:10:29.000000Z","updated_at":"2026-04-09T09:52:49.000000Z","normalized_code":"3939"},{"id":19458714,"change_date":"2026-03-30 21:39:00","inspection_id":"87441132","insp_violation_id":"272744895","seq_no":"4","part_no":"392","part_no_section":"2W","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-02T10:10:29.000000Z","updated_at":"2026-04-09T09:52:49.000000Z","normalized_code":"3922W"},{"id":19458715,"change_date":"2026-03-30 21:39:00","inspection_id":"87441132","insp_violation_id":"272744896","seq_no":"5","part_no":"392","part_no_section":"2W","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-02T10:10:29.000000Z","updated_at":"2026-04-09T09:52:49.000000Z","normalized_code":"3922W"}],"inspection_per_units":[{"id":19736794,"change_date":"2026-03-30 21:39:00","inspection_id":"87441132","insp_unit_id":"212431925","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"105","insp_unit_license":"1N28296","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3HSDZAPR1KN639216","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-02T09:29:44.000000Z","updated_at":"2026-04-10T09:06:24.000000Z"},{"id":19736795,"change_date":"2026-03-30 21:39:00","inspection_id":"87441132","insp_unit_id":"212431926","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"DESP","insp_unit_company":"591","insp_unit_license":"246B205","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UNST4426FS140343","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-02T09:29:44.000000Z","updated_at":"2026-04-10T09:06:24.000000Z"}]},{"id":11503802,"change_date":"2026-04-09 22:21:00","inspection_id":"87424020","dot_number":"4257239","report_state":"TX","report_number":"V262282874","insp_date":"2026-03-23 00:00:00","insp_start_time":"1445","insp_end_time":"1510","registration_date":null,"region":"CT","ci_status_code":"C","location":"3A501","location_desc":"INDIOS POE","county_code_state":"TX","county_code":"061","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"UNKNOWN","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-03-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52500","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9898021","transaction_code":"C","transaction_date":"2026-03-27 00:00:00","upload_date":"2026-04-09 00:00:00","upload_first_byte":"0","upload_dot_number":"04257239","upload_search_indicator":"M","census_search_date":"2026-03-27 21:40:00","snet_input_date":"2026-03-23 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-03-27 21:40:00","insp_carrier_name":"DELROS 4WHEEL LLC","insp_carrier_street":"2 HERMANN PARK CT","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77021","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1081694","created_at":"2026-03-30T09:51:48.000000Z","updated_at":"2026-04-20T10:13:00.000000Z","inspection_violations":[{"id":20138131,"change_date":"2026-04-09 22:21:00","inspection_id":"87424020","insp_violation_id":"273500689","seq_no":"1","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"212934728","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-11T10:24:05.000000Z","updated_at":"2026-04-19T14:06:48.000000Z","normalized_code":"3939"},{"id":20138132,"change_date":"2026-04-09 22:21:00","inspection_id":"87424020","insp_violation_id":"273500690","seq_no":"2","part_no":"393","part_no_section":"9TS","insp_viol_unit":"1","insp_unit_id":"212934728","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"2","citation_number":null,"created_at":"2026-04-11T10:24:05.000000Z","updated_at":"2026-04-19T14:06:48.000000Z","normalized_code":"3939TS"},{"id":20138133,"change_date":"2026-04-09 22:21:00","inspection_id":"87424020","insp_violation_id":"273500691","seq_no":"3","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"212934728","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-11T10:24:05.000000Z","updated_at":"2026-04-19T14:06:48.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":20190494,"change_date":"2026-04-09 22:21:00","inspection_id":"87424020","insp_unit_id":"212934728","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"111","insp_unit_license":"R822944","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPBD49X7ND801754","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-12T09:29:46.000000Z","updated_at":"2026-04-19T10:36:44.000000Z"}]},{"id":11253405,"change_date":"2026-04-09 22:20:00","inspection_id":"87166775","dot_number":"4257239","report_state":"TX","report_number":"V262248845","insp_date":"2026-02-24 00:00:00","insp_start_time":"1355","insp_end_time":"1431","registration_date":null,"region":"CT","ci_status_code":"C","location":"3A501","location_desc":"INDIOS POE","county_code_state":"TX","county_code":"061","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"INVESTMENT LLC","shipping_paper_number":"41008","cargo_tank":"407","hazmat_placard_req":"Y","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":"2026-02-27 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"9867317","transaction_code":"C","transaction_date":"2026-02-27 00:00:00","upload_date":"2026-04-09 00:00:00","upload_first_byte":"0","upload_dot_number":"04257239","upload_search_indicator":"M","census_search_date":"2026-02-27 21:42:00","snet_input_date":"2026-02-24 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-02-27 21:42:00","insp_carrier_name":"DELROS 4WHEEL LLC","insp_carrier_street":"2 HERMANN PARK CT","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77021","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1081694","created_at":"2026-03-02T10:39:52.000000Z","updated_at":"2026-04-20T10:11:00.000000Z","inspection_violations":[{"id":20132934,"change_date":"2026-04-09 22:20:00","inspection_id":"87166775","insp_violation_id":"273473445","seq_no":"1","part_no":"393","part_no_section":"45UV","insp_viol_unit":"2","insp_unit_id":"212921771","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-11T10:23:52.000000Z","updated_at":"2026-04-19T14:00:08.000000Z","normalized_code":"39345UV"},{"id":20132936,"change_date":"2026-04-09 22:20:00","inspection_id":"87166775","insp_violation_id":"273473447","seq_no":"3","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"212921771","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-11T10:23:52.000000Z","updated_at":"2026-04-19T14:00:08.000000Z","normalized_code":"3939"},{"id":20132935,"change_date":"2026-04-09 22:20:00","inspection_id":"87166775","insp_violation_id":"273473446","seq_no":"2","part_no":"393","part_no_section":"55E","insp_viol_unit":"2","insp_unit_id":"212921771","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-11T10:23:52.000000Z","updated_at":"2026-04-19T14:00:08.000000Z","normalized_code":"39355E"}],"inspection_per_units":[{"id":20189216,"change_date":"2026-04-09 22:20:00","inspection_id":"87166775","insp_unit_id":"212921770","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"109","insp_unit_license":"1N79854","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKYDP9X3HJ119302","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-12T09:29:45.000000Z","updated_at":"2026-04-19T10:35:22.000000Z"},{"id":20189217,"change_date":"2026-04-09 22:20:00","inspection_id":"87166775","insp_unit_id":"212921771","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"POLA","insp_unit_company":"PT-23","insp_unit_license":"181B483","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1PMA34320X5001867","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-12T09:29:45.000000Z","updated_at":"2026-04-19T10:35:22.000000Z"}]},{"id":10781203,"change_date":"2026-01-15 21:41:00","inspection_id":"86806916","dot_number":"4257239","report_state":"TX","report_number":"7C499DAZKT","insp_date":"2026-01-12 00:00:00","insp_start_time":"0914","insp_end_time":"0930","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":"4","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-01-15 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9818927","transaction_code":"A","transaction_date":"2026-01-15 00:00:00","upload_date":"2026-01-15 00:00:00","upload_first_byte":"0","upload_dot_number":"04257239","upload_search_indicator":"M","census_search_date":"2026-01-15 21:41:00","snet_input_date":"2026-01-12 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-01-15 21:41:00","insp_carrier_name":"DELROS 4WHEEL LLC","insp_carrier_street":"2 HERMANN PARK CT","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77021","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1081694","created_at":"2026-01-18T10:45:09.000000Z","updated_at":"2026-01-26T10:31:06.000000Z","inspection_violations":[{"id":18014214,"change_date":"2026-01-15 21:41:00","inspection_id":"86806916","insp_violation_id":"271235823","seq_no":"1","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"211115989","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-18T11:01:42.000000Z","updated_at":"2026-01-26T10:31:49.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":18100064,"change_date":"2026-01-15 21:41:00","inspection_id":"86806916","insp_unit_id":"211115989","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"112","insp_unit_license":"BYR72679","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3AKJGHDV3JDJU7824","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-18T10:17:41.000000Z","updated_at":"2026-01-26T10:01:17.000000Z"},{"id":18100065,"change_date":"2026-01-15 21:41:00","inspection_id":"86806916","insp_unit_id":"211115990","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BREN","insp_unit_company":"84133","insp_unit_license":"251B010","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"10BFA8230CF0C6432","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-18T10:17:41.000000Z","updated_at":"2026-01-26T10:01:17.000000Z"}]},{"id":10558167,"change_date":"2026-01-02 21:35:00","inspection_id":"86695385","dot_number":"4257239","report_state":"TX","report_number":"V252160417","insp_date":"2025-12-31 00:00:00","insp_start_time":"1411","insp_end_time":"1426","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"FM1223 SB AT US87 NB","county_code_state":"TX","county_code":"451","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"PILOT","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-02 21:35:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","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":"9805178","transaction_code":"A","transaction_date":"2026-01-02 00:00:00","upload_date":"2026-01-02 00:00:00","upload_first_byte":"0","upload_dot_number":"04257239","upload_search_indicator":"M","census_search_date":"2026-01-02 21:35:00","snet_input_date":"2025-12-31 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-01-02 21:35:00","insp_carrier_name":"DELROS 4WHEEL LLC","insp_carrier_street":"2 HERMANN PARK CT","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77021","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1081694","created_at":"2026-01-05T10:33:38.000000Z","updated_at":"2026-01-13T10:30:30.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17688783,"change_date":"2026-01-02 21:35:00","inspection_id":"86695385","insp_unit_id":"210889607","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"109","insp_unit_license":"1N79854","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKYDP9X3HJ119302","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-05T10:05:08.000000Z","updated_at":"2026-01-13T10:00:42.000000Z"},{"id":17688784,"change_date":"2026-01-02 21:35:00","inspection_id":"86695385","insp_unit_id":"210889608","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"DESP","insp_unit_company":"628","insp_unit_license":"BD1024","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1UNST4422FS140369","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-05T10:05:08.000000Z","updated_at":"2026-01-13T10:00:42.000000Z"}]},{"id":10315167,"change_date":"2025-12-01 21:38:00","inspection_id":"86441698","dot_number":"4257239","report_state":"NM","report_number":"6333P95M7J","insp_date":"2025-11-25 00:00:00","insp_start_time":"1719","insp_end_time":"1754","registration_date":null,"region":"MT","ci_status_code":"C","location":null,"location_desc":"ON US HWY 285 3894 FT S OF I40","county_code_state":"NM","county_code":"057","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"DELROS 4WHEEL LLC","shipping_paper_number":"262311740","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-12-01 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"108350","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2236116","transaction_code":"A","transaction_date":"2025-11-26 00:00:00","upload_date":"2025-12-01 00:00:00","upload_first_byte":"0","upload_dot_number":"04257239","upload_search_indicator":null,"census_search_date":"2025-12-01 21:38:00","snet_input_date":"2025-11-29 00:00:00","source_office":"2NMS001","mcmis_add_date":"2025-12-01 21:38:00","insp_carrier_name":"DELROS 4WHEEL LLC","insp_carrier_street":"2368A  RICE BLVD  POBOX404","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77005","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-04T10:30:30.000000Z","updated_at":"2025-12-05T10:30:44.000000Z","inspection_violations":[{"id":17253995,"change_date":"2025-12-01 21:38:00","inspection_id":"86441698","insp_violation_id":"270363896","seq_no":"1","part_no":"392","part_no_section":"2-SLLS2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-04T10:30:47.000000Z","updated_at":"2025-12-05T10:31:01.000000Z","normalized_code":"3922SLLS2"}],"inspection_per_units":[{"id":17225807,"change_date":"2025-12-01 21:38:00","inspection_id":"86441698","insp_unit_id":"210325719","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"UNIT 110","insp_unit_license":"K216579","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3AKJHPDV9KSJY3764","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-04T10:00:32.000000Z","updated_at":"2025-12-05T10:00:53.000000Z"},{"id":17225808,"change_date":"2025-12-01 21:38:00","inspection_id":"86441698","insp_unit_id":"210325720","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STRI","insp_unit_company":"UNIT 110","insp_unit_license":"246B204","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UNST4425FS140365","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-04T10:00:32.000000Z","updated_at":"2025-12-05T10:00:53.000000Z"}]},{"id":10219499,"change_date":"2025-11-17 21:40:00","inspection_id":"86341235","dot_number":"4257239","report_state":"TX","report_number":"V251987806","insp_date":"2025-11-14 00:00:00","insp_start_time":"1223","insp_end_time":"1238","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US87 SB US87 SB","county_code_state":"TX","county_code":"451","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"PILOT","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":"2025-11-17 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"122500","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":"9760615","transaction_code":"A","transaction_date":"2025-11-17 00:00:00","upload_date":"2025-11-17 00:00:00","upload_first_byte":"0","upload_dot_number":"04257239","upload_search_indicator":"M","census_search_date":"2025-11-17 21:40:00","snet_input_date":"2025-11-14 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-11-17 21:40:00","insp_carrier_name":"DELROS 4WHEEL LLC","insp_carrier_street":"2 HERMANN PARK CT","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77021","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1081694","created_at":"2025-11-20T10:30:37.000000Z","updated_at":"2025-11-21T10:31:02.000000Z","inspection_violations":[{"id":16984846,"change_date":"2025-11-17 21:40:00","inspection_id":"86341235","insp_violation_id":"270009934","seq_no":"1","part_no":"393","part_no_section":"55E","insp_viol_unit":"2","insp_unit_id":"210074967","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-20T10:31:03.000000Z","updated_at":"2025-11-21T10:31:44.000000Z","normalized_code":"39355E"}],"inspection_per_units":[{"id":17025902,"change_date":"2025-11-17 21:40:00","inspection_id":"86341235","insp_unit_id":"210074966","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"111","insp_unit_license":"1N78595","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPBD49X7ND801754","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-20T10:00:38.000000Z","updated_at":"2025-11-21T10:01:13.000000Z"},{"id":17025903,"change_date":"2025-11-17 21:40:00","inspection_id":"86341235","insp_unit_id":"210074967","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"DRAG","insp_unit_company":"627","insp_unit_license":"246B179","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UNST4420FS140368","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-20T10:00:38.000000Z","updated_at":"2025-11-21T10:01:13.000000Z"}]},{"id":10201450,"change_date":"2025-11-24 21:40:00","inspection_id":"86322342","dot_number":"4257239","report_state":"TX","report_number":"V252115986","insp_date":"2025-11-12 00:00:00","insp_start_time":"1725","insp_end_time":"1755","registration_date":null,"region":"CT","ci_status_code":"C","location":"3C201","location_desc":"US77 RIVIERA SCALE","county_code_state":"TX","county_code":"273","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"ABC GULF TERMINAL","shipping_paper_number":"10922","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-11-24 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"53200","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":"9757892","transaction_code":"C","transaction_date":"2025-11-24 00:00:00","upload_date":"2025-11-24 00:00:00","upload_first_byte":"0","upload_dot_number":"04257239","upload_search_indicator":"M","census_search_date":"2025-11-24 21:40:00","snet_input_date":"2025-11-12 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-11-14 21:40:00","insp_carrier_name":"DELROS 4WHEEL LLC","insp_carrier_street":"1201 FANNIN ST   STE 262","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77002","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1081694","created_at":"2025-11-17T10:31:29.000000Z","updated_at":"2025-11-28T10:31:17.000000Z","inspection_violations":[{"id":17185535,"change_date":"2025-11-24 21:40:00","inspection_id":"86322342","insp_violation_id":"270273914","seq_no":"1","part_no":"393","part_no_section":"11TL","insp_viol_unit":"1","insp_unit_id":"210245964","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-27T10:31:08.000000Z","updated_at":"2025-11-28T10:32:02.000000Z","normalized_code":"39311TL"}],"inspection_per_units":[{"id":17160924,"change_date":"2025-11-24 21:40:00","inspection_id":"86322342","insp_unit_id":"210245964","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"105","insp_unit_license":"1N28296","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3HSDZAPR1KN639216","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-27T10:00:43.000000Z","updated_at":"2025-11-28T10:01:17.000000Z"}]},{"id":10108642,"change_date":"2025-11-03 21:39:00","inspection_id":"86224597","dot_number":"4257239","report_state":"TX","report_number":"V252057796","insp_date":"2025-10-31 00:00:00","insp_start_time":"0759","insp_end_time":"0842","registration_date":null,"region":"CT","ci_status_code":"C","location":"6A101","location_desc":"IH10 EB KINGSBURY SCALE","county_code_state":"TX","county_code":"187","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"FLINT HILLS","shipping_paper_number":"1760554","cargo_tank":"407","hazmat_placard_req":"Y","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-11-03 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"122500","viol_total":"4","oos_total":"0","driver_viol_total":"3","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9745663","transaction_code":"A","transaction_date":"2025-11-03 00:00:00","upload_date":"2025-11-03 00:00:00","upload_first_byte":"0","upload_dot_number":"04257239","upload_search_indicator":"M","census_search_date":"2025-11-03 21:39:00","snet_input_date":"2025-10-31 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-11-03 21:39:00","insp_carrier_name":"DELROS 4WHEEL LLC","insp_carrier_street":"2 HERMANN PARK CT","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77021","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1081694","created_at":"2025-11-06T10:30:44.000000Z","updated_at":"2025-11-07T10:30:56.000000Z","inspection_violations":[{"id":16752985,"change_date":"2025-11-03 21:39:00","inspection_id":"86224597","insp_violation_id":"269697834","seq_no":"1","part_no":"393","part_no_section":"55E","insp_viol_unit":"2","insp_unit_id":"209809975","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-07T10:31:04.000000Z","updated_at":"2025-11-07T10:31:04.000000Z","normalized_code":"39355E"},{"id":16752986,"change_date":"2025-11-03 21:39:00","inspection_id":"86224597","insp_violation_id":"269697835","seq_no":"2","part_no":"392","part_no_section":"2W","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-07T10:31:04.000000Z","updated_at":"2025-11-07T10:31:04.000000Z","normalized_code":"3922W"},{"id":16752987,"change_date":"2025-11-03 21:39:00","inspection_id":"86224597","insp_violation_id":"269697836","seq_no":"3","part_no":"392","part_no_section":"2W","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-07T10:31:04.000000Z","updated_at":"2025-11-07T10:31:04.000000Z","normalized_code":"3922W"},{"id":16752988,"change_date":"2025-11-03 21:39:00","inspection_id":"86224597","insp_violation_id":"269697837","seq_no":"4","part_no":"392","part_no_section":"2W","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-07T10:31:04.000000Z","updated_at":"2025-11-07T10:31:04.000000Z","normalized_code":"3922W"}],"inspection_per_units":[{"id":16810874,"change_date":"2025-11-03 21:39:00","inspection_id":"86224597","insp_unit_id":"209809974","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"111","insp_unit_license":"1N78595","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPBD49X7ND801754","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-06T10:00:39.000000Z","updated_at":"2025-11-07T10:01:12.000000Z"},{"id":16810875,"change_date":"2025-11-03 21:39:00","inspection_id":"86224597","insp_unit_id":"209809975","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"DRAG","insp_unit_company":"627","insp_unit_license":"246B179","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UNST4420FS140368","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-06T10:00:39.000000Z","updated_at":"2025-11-07T10:01:12.000000Z"}]},{"id":10109552,"change_date":"2025-11-03 21:39:00","inspection_id":"86225540","dot_number":"4257239","report_state":"TX","report_number":"V252090454","insp_date":"2025-10-23 00:00:00","insp_start_time":"1344","insp_end_time":"1425","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US287 NB 504 MM","county_code_state":"TX","county_code":"139","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"PILOT THOMAS LOGISTICS","shipping_paper_number":"262071635","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-11-03 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"122500","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":"9744864","transaction_code":"A","transaction_date":"2025-11-03 00:00:00","upload_date":"2025-11-03 00:00:00","upload_first_byte":"0","upload_dot_number":"04257239","upload_search_indicator":"M","census_search_date":"2025-11-03 21:39:00","snet_input_date":"2025-10-23 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-11-03 21:39:00","insp_carrier_name":"DELROS 4WHEEL LLC","insp_carrier_street":"2 HERMANN PARK CT","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77021","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1081694","created_at":"2025-11-06T10:30:45.000000Z","updated_at":"2025-11-07T10:31:01.000000Z","inspection_violations":[{"id":16755452,"change_date":"2025-11-03 21:39:00","inspection_id":"86225540","insp_violation_id":"269701131","seq_no":"1","part_no":"393","part_no_section":"55E","insp_viol_unit":"2","insp_unit_id":"209811868","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-07T10:31:08.000000Z","updated_at":"2025-11-07T10:31:08.000000Z","normalized_code":"39355E"}],"inspection_per_units":[{"id":16812482,"change_date":"2025-11-03 21:39:00","inspection_id":"86225540","insp_unit_id":"209811867","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"PTRB","insp_unit_company":"111","insp_unit_license":"1N78595","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XPBD49X7ND801754","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-06T10:00:40.000000Z","updated_at":"2025-11-07T10:01:19.000000Z"},{"id":16812483,"change_date":"2025-11-03 21:39:00","inspection_id":"86225540","insp_unit_id":"209811868","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"DESP","insp_unit_company":"627","insp_unit_license":"246B179","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UNST4420FS140368","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-06T10:00:40.000000Z","updated_at":"2025-11-07T10:01:19.000000Z"}]},{"id":9569577,"change_date":"2025-09-02 21:40:00","inspection_id":"85658168","dot_number":"4257239","report_state":"TX","report_number":"V251991471","insp_date":"2025-08-29 00:00:00","insp_start_time":"1319","insp_end_time":"1346","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US 87 AND EAST STATE","county_code_state":"TX","county_code":"451","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"DELROS 4WHEEL LLC","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":"2025-09-02 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"118200","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":"9683881","transaction_code":"A","transaction_date":"2025-09-02 00:00:00","upload_date":"2025-09-02 00:00:00","upload_first_byte":"0","upload_dot_number":"04257239","upload_search_indicator":"M","census_search_date":"2025-09-02 21:40:00","snet_input_date":"2025-08-29 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-09-02 21:40:00","insp_carrier_name":"DELROS 4WHEEL LLC","insp_carrier_street":"2 HERMANN PARK CT","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77021","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1081694","created_at":"2025-09-06T10:43:06.000000Z","updated_at":"2025-09-06T10:43:06.000000Z","inspection_violations":[{"id":15630573,"change_date":"2025-09-02 21:40:00","inspection_id":"85658168","insp_violation_id":"268405347","seq_no":"1","part_no":"393","part_no_section":"205C","insp_viol_unit":"2","insp_unit_id":"208703719","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-06T10:47:32.000000Z","updated_at":"2025-09-06T10:47:32.000000Z","normalized_code":"393205C"},{"id":15630574,"change_date":"2025-09-02 21:40:00","inspection_id":"85658168","insp_violation_id":"268405348","seq_no":"2","part_no":"392","part_no_section":"2RG","insp_viol_unit":"2","insp_unit_id":"208703719","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-06T10:47:32.000000Z","updated_at":"2025-09-06T10:47:32.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":15796358,"change_date":"2025-09-02 21:40:00","inspection_id":"85658168","insp_unit_id":"208703718","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"109","insp_unit_license":"1N79854","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKYDP9X3HJ119302","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-09T09:47:18.000000Z","updated_at":"2025-09-09T09:47:18.000000Z"},{"id":15796359,"change_date":"2025-09-02 21:40:00","inspection_id":"85658168","insp_unit_id":"208703719","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BREN","insp_unit_company":"84133","insp_unit_license":"251B010","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"10BFA8230CF0C6432","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-09T09:47:18.000000Z","updated_at":"2025-09-09T09:47:18.000000Z"}]},{"id":9142855,"change_date":"2025-07-14 21:41:00","inspection_id":"85209321","dot_number":"4257239","report_state":"TX","report_number":"V251938843","insp_date":"2025-07-03 00:00:00","insp_start_time":"1020","insp_end_time":"1058","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"17M IH69E SB","county_code_state":"TX","county_code":"061","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"NONE","shipping_paper_number":"NONE","cargo_tank":"406","hazmat_placard_req":"Y","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-14 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"9636148","transaction_code":"A","transaction_date":"2025-07-14 00:00:00","upload_date":"2025-07-14 00:00:00","upload_first_byte":"0","upload_dot_number":"04257239","upload_search_indicator":"M","census_search_date":"2025-07-14 21:41:00","snet_input_date":"2025-07-03 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-07-14 21:41:00","insp_carrier_name":"DELROS 4WHEEL LLC","insp_carrier_street":"2 HERMANN PARK CT","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77021","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1081694","created_at":"2025-07-18T10:45:48.000000Z","updated_at":"2025-07-18T10:45:48.000000Z","inspection_violations":[{"id":14750280,"change_date":"2025-07-14 21:41:00","inspection_id":"85209321","insp_violation_id":"267395504","seq_no":"1","part_no":"393","part_no_section":"209E","insp_viol_unit":"1","insp_unit_id":"207859378","insp_violation_category_id":"21","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-17T10:47:16.000000Z","updated_at":"2025-07-18T10:47:35.000000Z","normalized_code":"393209E"},{"id":14750281,"change_date":"2025-07-14 21:41:00","inspection_id":"85209321","insp_violation_id":"267395505","seq_no":"2","part_no":"393","part_no_section":"55C2","insp_viol_unit":"2","insp_unit_id":"207859377","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-17T10:47:16.000000Z","updated_at":"2025-07-18T10:47:35.000000Z","normalized_code":"39355C2"},{"id":14750282,"change_date":"2025-07-14 21:41:00","inspection_id":"85209321","insp_violation_id":"267395506","seq_no":"3","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"207859377","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-17T10:47:16.000000Z","updated_at":"2025-07-18T10:47:35.000000Z","normalized_code":"3939"}],"inspection_per_units":[{"id":15014072,"change_date":"2025-07-14 21:41:00","inspection_id":"85209321","insp_unit_id":"207859377","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":"1052","insp_unit_license":"08UL4T","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"3DG1A4589NG001146","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-17T09:45:33.000000Z","updated_at":"2025-07-18T09:46:00.000000Z"},{"id":15014073,"change_date":"2025-07-14 21:41:00","inspection_id":"85209321","insp_unit_id":"207859378","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"107","insp_unit_license":"1N73169","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3HSDZAPR9KN611888","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-17T09:45:33.000000Z","updated_at":"2025-07-18T09:46:00.000000Z"}]},{"id":8570996,"change_date":"2025-05-07 21:47:00","inspection_id":"84605061","dot_number":"4257239","report_state":"TX","report_number":"V251860734","insp_date":"2025-05-06 00:00:00","insp_start_time":"1455","insp_end_time":"1539","registration_date":null,"region":"CT","ci_status_code":"C","location":"3C302","location_desc":"US281 SB FALFURRIAS SCALE","county_code_state":"TX","county_code":"047","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"SUNOCO","shipping_paper_number":"54805","cargo_tank":"407","hazmat_placard_req":"Y","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-07 21:47:00","post_acc_ind":"N","gross_comb_veh_wt":"120350","viol_total":"9","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"9","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9571769","transaction_code":"A","transaction_date":"2025-05-07 00:00:00","upload_date":"2025-05-07 00:00:00","upload_first_byte":"0","upload_dot_number":"04257239","upload_search_indicator":"M","census_search_date":"2025-05-07 21:47:00","snet_input_date":"2025-05-06 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-05-07 21:47:00","insp_carrier_name":"DELROS 4WHEEL LLC","insp_carrier_street":"2 HERMANN PARK CT","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77021","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1081694","created_at":"2025-05-10T11:03:18.000000Z","updated_at":"2025-05-11T10:21:31.000000Z","inspection_violations":[{"id":13611523,"change_date":"2025-05-07 21:47:00","inspection_id":"84605061","insp_violation_id":"266091358","seq_no":"1","part_no":"393","part_no_section":"19","insp_viol_unit":"1","insp_unit_id":"206742209","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-09T11:41:56.000000Z","updated_at":"2025-05-10T11:50:47.000000Z","normalized_code":"39319"},{"id":13611524,"change_date":"2025-05-07 21:47:00","inspection_id":"84605061","insp_violation_id":"266091359","seq_no":"2","part_no":"393","part_no_section":"55E","insp_viol_unit":"2","insp_unit_id":"206742210","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-09T11:41:56.000000Z","updated_at":"2025-05-10T11:50:47.000000Z","normalized_code":"39355E"},{"id":13611525,"change_date":"2025-05-07 21:47:00","inspection_id":"84605061","insp_violation_id":"266091360","seq_no":"3","part_no":"393","part_no_section":"9H","insp_viol_unit":"1","insp_unit_id":"206742209","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-09T11:41:56.000000Z","updated_at":"2025-05-10T11:50:47.000000Z","normalized_code":"3939H"},{"id":13611526,"change_date":"2025-05-07 21:47:00","inspection_id":"84605061","insp_violation_id":"266091361","seq_no":"4","part_no":"393","part_no_section":"9H","insp_viol_unit":"1","insp_unit_id":"206742209","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-09T11:41:56.000000Z","updated_at":"2025-05-10T11:50:47.000000Z","normalized_code":"3939H"},{"id":13611527,"change_date":"2025-05-07 21:47:00","inspection_id":"84605061","insp_violation_id":"266091362","seq_no":"5","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"206742209","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-09T11:41:56.000000Z","updated_at":"2025-05-10T11:50:47.000000Z","normalized_code":"3939"},{"id":13611528,"change_date":"2025-05-07 21:47:00","inspection_id":"84605061","insp_violation_id":"266091363","seq_no":"6","part_no":"393","part_no_section":"9TS","insp_viol_unit":"1","insp_unit_id":"206742209","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-09T11:41:56.000000Z","updated_at":"2025-05-10T11:50:47.000000Z","normalized_code":"3939TS"},{"id":13611529,"change_date":"2025-05-07 21:47:00","inspection_id":"84605061","insp_violation_id":"266091364","seq_no":"7","part_no":"396","part_no_section":"17C","insp_viol_unit":"2","insp_unit_id":"206742210","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-09T11:41:56.000000Z","updated_at":"2025-05-10T11:50:47.000000Z","normalized_code":"39617C"},{"id":13611530,"change_date":"2025-05-07 21:47:00","inspection_id":"84605061","insp_violation_id":"266091365","seq_no":"8","part_no":"396","part_no_section":"3A1","insp_viol_unit":"1","insp_unit_id":"206742209","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-09T11:41:56.000000Z","updated_at":"2025-05-10T11:50:47.000000Z","normalized_code":"3963A1"},{"id":13611531,"change_date":"2025-05-07 21:47:00","inspection_id":"84605061","insp_violation_id":"266091366","seq_no":"9","part_no":"392","part_no_section":"2RG","insp_viol_unit":"2","insp_unit_id":"206742210","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-09T11:41:56.000000Z","updated_at":"2025-05-10T11:50:47.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":13988333,"change_date":"2025-05-07 21:47:00","inspection_id":"84605061","insp_unit_id":"206742209","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"107","insp_unit_license":"1N73169","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3HSDZAPR9KN611888","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-11T03:46:31.000000Z","updated_at":"2025-05-11T03:58:44.000000Z"},{"id":13988334,"change_date":"2025-05-07 21:47:00","inspection_id":"84605061","insp_unit_id":"206742210","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"STEP","insp_unit_company":"490","insp_unit_license":"246B173","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1S9AB15B4BH474236","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-11T03:46:31.000000Z","updated_at":"2025-05-11T03:58:44.000000Z"}]},{"id":7520935,"change_date":"2024-12-30 21:39:00","inspection_id":"83500736","dot_number":"4257239","report_state":"TX","report_number":"V241667727","insp_date":"2024-12-20 00:00:00","insp_start_time":"0930","insp_end_time":"1003","registration_date":null,"region":"CT","ci_status_code":"C","location":"3C201","location_desc":"US77 RIVIERA SCALE","county_code_state":"TX","county_code":"273","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"SUNOCO","shipping_paper_number":"45199","cargo_tank":"407","hazmat_placard_req":"Y","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":"133200","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":"9461203","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":"04257239","upload_search_indicator":"M","census_search_date":"2024-12-30 21:39:00","snet_input_date":"2024-12-20 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-12-30 21:39:00","insp_carrier_name":"DELROS 4WHEEL LLC","insp_carrier_street":"2 HERMANN PARK CT","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77021","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1081694","created_at":"2025-03-17T20:53:08.000000Z","updated_at":"2025-03-17T20:53:08.000000Z","inspection_violations":[{"id":11756023,"change_date":"2024-12-30 21:39:00","inspection_id":"83500736","insp_violation_id":"263700567","seq_no":"1","part_no":"393","part_no_section":"203A","insp_viol_unit":"1","insp_unit_id":"204596707","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":"393203A"}],"inspection_per_units":[{"id":12133615,"change_date":"2024-12-30 21:39:00","inspection_id":"83500736","insp_unit_id":"204596707","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"105","insp_unit_license":"1N28296","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3HSDZAPR1KN639216","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":12133616,"change_date":"2024-12-30 21:39:00","inspection_id":"83500736","insp_unit_id":"204596708","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":"TQ019A","insp_unit_license":"62UT2D","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"3A9TA39P9PC249670","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":7137540,"change_date":"2026-04-09 22:08:00","inspection_id":"83096681","dot_number":"4257239","report_state":"TX","report_number":"V241671624","insp_date":"2024-11-04 00:00:00","insp_start_time":"1120","insp_end_time":"1217","registration_date":null,"region":"CT","ci_status_code":"C","location":"3A501","location_desc":"INDIOS POE","county_code_state":"TX","county_code":"061","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"OLG PETROLEUM LLC","shipping_paper_number":"1175230","cargo_tank":"407","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-11-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","viol_total":"12","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"12","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9421423","transaction_code":"C","transaction_date":"2024-11-07 00:00:00","upload_date":"2026-04-09 00:00:00","upload_first_byte":"0","upload_dot_number":"04257239","upload_search_indicator":"M","census_search_date":"2024-11-06 21:40:00","snet_input_date":"2024-11-04 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-11-06 21:40:00","insp_carrier_name":"DELROS 4WHEEL LLC","insp_carrier_street":"2 HERMANN PARK CT","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77021-2271","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1081694","created_at":"2025-03-17T20:44:43.000000Z","updated_at":"2026-04-20T09:52:24.000000Z","inspection_violations":[{"id":19850998,"change_date":"2026-04-09 22:08:00","inspection_id":"83096681","insp_violation_id":"273197346","seq_no":"1","part_no":"392","part_no_section":"9AA1","insp_viol_unit":"1","insp_unit_id":"212776862","insp_violation_category_id":"51","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2026-04-11T10:12:34.000000Z","updated_at":"2026-04-19T12:19:16.000000Z","normalized_code":"3929AA1"},{"id":19850999,"change_date":"2026-04-09 22:08:00","inspection_id":"83096681","insp_violation_id":"273197347","seq_no":"2","part_no":"393","part_no_section":"19","insp_viol_unit":"1","insp_unit_id":"212776862","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-11T10:12:34.000000Z","updated_at":"2026-04-19T12:19:16.000000Z","normalized_code":"39319"},{"id":19851000,"change_date":"2026-04-09 22:08:00","inspection_id":"83096681","insp_violation_id":"273197348","seq_no":"3","part_no":"393","part_no_section":"45DLUV","insp_viol_unit":"1","insp_unit_id":"212776862","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-11T10:12:34.000000Z","updated_at":"2026-04-19T12:19:16.000000Z","normalized_code":"39345DLUV"},{"id":19851001,"change_date":"2026-04-09 22:08:00","inspection_id":"83096681","insp_violation_id":"273197349","seq_no":"4","part_no":"393","part_no_section":"45DLUV","insp_viol_unit":"2","insp_unit_id":"212776863","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-11T10:12:34.000000Z","updated_at":"2026-04-19T12:19:16.000000Z","normalized_code":"39345DLUV"},{"id":19851002,"change_date":"2026-04-09 22:08:00","inspection_id":"83096681","insp_violation_id":"273197350","seq_no":"5","part_no":"393","part_no_section":"50C","insp_viol_unit":"2","insp_unit_id":"212776863","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-11T10:12:34.000000Z","updated_at":"2026-04-19T12:19:16.000000Z","normalized_code":"39350C"},{"id":19851003,"change_date":"2026-04-09 22:08:00","inspection_id":"83096681","insp_violation_id":"273197351","seq_no":"6","part_no":"393","part_no_section":"55E","insp_viol_unit":"2","insp_unit_id":"212776863","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-11T10:12:34.000000Z","updated_at":"2026-04-19T12:19:16.000000Z","normalized_code":"39355E"},{"id":19851004,"change_date":"2026-04-09 22:08:00","inspection_id":"83096681","insp_violation_id":"273197352","seq_no":"7","part_no":"393","part_no_section":"75C","insp_viol_unit":"2","insp_unit_id":"212776863","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-11T10:12:34.000000Z","updated_at":"2026-04-19T12:19:16.000000Z","normalized_code":"39375C"},{"id":19851005,"change_date":"2026-04-09 22:08:00","inspection_id":"83096681","insp_violation_id":"273197353","seq_no":"9","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"212776863","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-11T10:12:34.000000Z","updated_at":"2026-04-19T12:19:16.000000Z","normalized_code":"3939"},{"id":19851006,"change_date":"2026-04-09 22:08:00","inspection_id":"83096681","insp_violation_id":"273197354","seq_no":"10","part_no":"393","part_no_section":"9TS","insp_viol_unit":"1","insp_unit_id":"212776862","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-11T10:12:34.000000Z","updated_at":"2026-04-19T12:19:16.000000Z","normalized_code":"3939TS"},{"id":19851007,"change_date":"2026-04-09 22:08:00","inspection_id":"83096681","insp_violation_id":"273197355","seq_no":"11","part_no":"393","part_no_section":"95A1I","insp_viol_unit":"1","insp_unit_id":"212776862","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-11T10:12:34.000000Z","updated_at":"2026-04-19T12:19:16.000000Z","normalized_code":"39395A1I"},{"id":19851008,"change_date":"2026-04-09 22:08:00","inspection_id":"83096681","insp_violation_id":"273197356","seq_no":"12","part_no":"392","part_no_section":"2UCR","insp_viol_unit":"1","insp_unit_id":"212776862","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-11T10:12:34.000000Z","updated_at":"2026-04-19T12:19:16.000000Z","normalized_code":"3922UCR"},{"id":19851009,"change_date":"2026-04-09 22:08:00","inspection_id":"83096681","insp_violation_id":"273197357","seq_no":"8","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"212776863","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-11T10:12:34.000000Z","updated_at":"2026-04-19T12:19:16.000000Z","normalized_code":"3939"}],"inspection_per_units":[{"id":20038123,"change_date":"2026-04-09 22:08:00","inspection_id":"83096681","insp_unit_id":"212776862","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"104","insp_unit_license":"1N28295","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3HSDZAPR7KN211456","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-12T09:27:35.000000Z","updated_at":"2026-04-19T10:02:30.000000Z"},{"id":20038124,"change_date":"2026-04-09 22:08:00","inspection_id":"83096681","insp_unit_id":"212776863","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"DRAG","insp_unit_company":"627","insp_unit_license":"246B179","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1UNST4420FS140368","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-12T09:27:35.000000Z","updated_at":"2026-04-19T10:02:30.000000Z"}]},{"id":7117413,"change_date":"2026-04-09 22:08:00","inspection_id":"83075463","dot_number":"4257239","report_state":"TX","report_number":"V241671499","insp_date":"2024-10-30 00:00:00","insp_start_time":"1450","insp_end_time":"1532","registration_date":null,"region":"CT","ci_status_code":"C","location":"3A501","location_desc":"INDIOS POE","county_code_state":"TX","county_code":"061","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"PURORGANICO","shipping_paper_number":"1175230","cargo_tank":"407","hazmat_placard_req":"Y","snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-11-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"121200","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"1","hazmat_oos_total":"0","snet_sequence_id":"9418315","transaction_code":"C","transaction_date":"2024-11-05 00:00:00","upload_date":"2026-04-09 00:00:00","upload_first_byte":"0","upload_dot_number":"04257239","upload_search_indicator":"M","census_search_date":"2024-11-04 21:41:00","snet_input_date":"2024-10-30 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-11-04 21:41:00","insp_carrier_name":"DELROS 4WHEEL LLC","insp_carrier_street":"2 HERMANN PARK CT","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77021-2271","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1081694","created_at":"2025-03-17T20:44:19.000000Z","updated_at":"2026-04-20T09:52:19.000000Z","inspection_violations":[{"id":19849638,"change_date":"2026-04-09 22:08:00","inspection_id":"83075463","insp_violation_id":"273197632","seq_no":"1","part_no":"172","part_no_section":"328D","insp_viol_unit":"2","insp_unit_id":"212777022","insp_violation_category_id":"39","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-11T10:12:31.000000Z","updated_at":"2026-04-19T12:18:48.000000Z","normalized_code":"172328D"},{"id":19849639,"change_date":"2026-04-09 22:08:00","inspection_id":"83075463","insp_violation_id":"273197633","seq_no":"2","part_no":"392","part_no_section":"9AA1","insp_viol_unit":"1","insp_unit_id":"212777021","insp_violation_category_id":"51","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2026-04-11T10:12:31.000000Z","updated_at":"2026-04-19T12:18:48.000000Z","normalized_code":"3929AA1"},{"id":19849640,"change_date":"2026-04-09 22:08:00","inspection_id":"83075463","insp_violation_id":"273197634","seq_no":"3","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"212777021","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-11T10:12:31.000000Z","updated_at":"2026-04-19T12:18:48.000000Z","normalized_code":"3939"}],"inspection_per_units":[{"id":20037410,"change_date":"2026-04-09 22:08:00","inspection_id":"83075463","insp_unit_id":"212777021","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTI","insp_unit_company":"103","insp_unit_license":"1M29924","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3HSDZAPR3KN639217","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-12T09:27:35.000000Z","updated_at":"2026-04-19T10:02:18.000000Z"},{"id":20037411,"change_date":"2026-04-09 22:08:00","inspection_id":"83075463","insp_unit_id":"212777022","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"STPH","insp_unit_company":"645","insp_unit_license":"246B217","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1S9AB15B6EH474441","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-12T09:27:35.000000Z","updated_at":"2026-04-19T10:02:18.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/4257239\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/4257239\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/4257239\/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\/4257239\/inspections","per_page":100,"prev_page_url":null,"to":18,"total":18}