{"current_page":1,"data":[{"id":12708163,"change_date":"2026-08-12 21:43:00","inspection_id":"88683053","dot_number":"1941962","report_state":"TX","report_number":"7HVE9DCNH9","insp_date":"2026-08-07 00:00:00","insp_start_time":"1414","insp_end_time":"1434","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"2200  CANAL ST","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"UNK","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-08-12 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"48000","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":"10066810","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":"01941962","upload_search_indicator":"M","census_search_date":"2026-08-12 21:43:00","snet_input_date":"2026-08-07 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-08-12 21:43:00","insp_carrier_name":"CARLOS ESQUIVEL","insp_carrier_street":"8014 TUFFLY ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77029","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0155754","created_at":"2026-08-15T09:41:41.000000Z","updated_at":"2026-08-19T09:35:24.000000Z","inspection_violations":[],"inspection_per_units":[{"id":22054596,"change_date":"2026-08-12 21:43:00","inspection_id":"88683053","insp_unit_id":"215123681","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"GJR9363","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AA09Y1XW018164","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-08-15T09:18:34.000000Z","updated_at":"2026-08-19T09:09:16.000000Z"}]},{"id":11335263,"change_date":"2026-03-10 21:39:00","inspection_id":"87252599","dot_number":"1941962","report_state":"TX","report_number":"7DJ89DIAHA","insp_date":"2026-03-04 00:00:00","insp_start_time":"0736","insp_end_time":"0820","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"9900  SOUTH FWY","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"HOPPER BROTHERS","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-10 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"50000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9876865","transaction_code":"A","transaction_date":"2026-03-09 00:00:00","upload_date":"2026-03-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01941962","upload_search_indicator":"M","census_search_date":"2026-03-10 21:39:00","snet_input_date":"2026-03-04 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-03-10 21:39:00","insp_carrier_name":"CARLOS ESQUIVEL","insp_carrier_street":"8014 TUFFLY ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77029","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0155754","created_at":"2026-03-13T09:43:55.000000Z","updated_at":"2026-03-21T09:31:34.000000Z","inspection_violations":[{"id":19084468,"change_date":"2026-03-10 21:39:00","inspection_id":"87252599","insp_violation_id":"272313281","seq_no":"1","part_no":"393","part_no_section":"100(a)","insp_viol_unit":"1","insp_unit_id":"212065757","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-03-13T10:05:08.000000Z","updated_at":"2026-03-21T09:49:35.000000Z","normalized_code":"393100A"}],"inspection_per_units":[{"id":19397474,"change_date":"2026-03-10 21:39:00","inspection_id":"87252599","insp_unit_id":"212065757","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"007","insp_unit_license":"GJR9363","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AA09Y1XW018164","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-13T09:23:26.000000Z","updated_at":"2026-03-21T09:11:39.000000Z"}]},{"id":11151565,"change_date":"2026-02-17 21:39:00","inspection_id":"87066217","dot_number":"1941962","report_state":"TX","report_number":"7CX79DCRDJ","insp_date":"2026-02-10 00:00:00","insp_start_time":"0717","insp_end_time":"0801","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0288 IN HARRIS CO. (472-484","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-02-17 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"51400","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":"9850997","transaction_code":"A","transaction_date":"2026-02-17 00:00:00","upload_date":"2026-02-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01941962","upload_search_indicator":"M","census_search_date":"2026-02-17 21:39:00","snet_input_date":"2026-02-10 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-02-17 21:39:00","insp_carrier_name":"CARLOS ESQUIVEL","insp_carrier_street":"8014 TUFFLY ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77029","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0155754","created_at":"2026-02-20T10:37:51.000000Z","updated_at":"2026-02-28T10:30:58.000000Z","inspection_violations":[{"id":18686770,"change_date":"2026-02-17 21:39:00","inspection_id":"87066217","insp_violation_id":"271848095","seq_no":"6","part_no":"392","part_no_section":"2W","insp_viol_unit":"1","insp_unit_id":"211667159","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-20T10:52:51.000000Z","updated_at":"2026-02-28T10:41:31.000000Z","normalized_code":"3922W"},{"id":18686767,"change_date":"2026-02-17 21:39:00","inspection_id":"87066217","insp_violation_id":"271848092","seq_no":"3","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"211667159","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-20T10:52:51.000000Z","updated_at":"2026-02-28T10:41:31.000000Z","normalized_code":"39347E"},{"id":18686765,"change_date":"2026-02-17 21:39:00","inspection_id":"87066217","insp_violation_id":"271848090","seq_no":"1","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"211667159","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-20T10:52:51.000000Z","updated_at":"2026-02-28T10:41:31.000000Z","normalized_code":"39347E"},{"id":18686766,"change_date":"2026-02-17 21:39:00","inspection_id":"87066217","insp_violation_id":"271848091","seq_no":"2","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"211667159","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-20T10:52:51.000000Z","updated_at":"2026-02-28T10:41:31.000000Z","normalized_code":"39347E"},{"id":18686768,"change_date":"2026-02-17 21:39:00","inspection_id":"87066217","insp_violation_id":"271848093","seq_no":"4","part_no":"393","part_no_section":"53B","insp_viol_unit":"1","insp_unit_id":"211667159","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-20T10:52:51.000000Z","updated_at":"2026-02-28T10:41:31.000000Z","normalized_code":"39353B"},{"id":18686769,"change_date":"2026-02-17 21:39:00","inspection_id":"87066217","insp_violation_id":"271848094","seq_no":"5","part_no":"396","part_no_section":"3A1BOS","insp_viol_unit":"1","insp_unit_id":"211667159","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-02-20T10:52:51.000000Z","updated_at":"2026-02-28T10:41:31.000000Z","normalized_code":"3963A1BOS"},{"id":18686771,"change_date":"2026-02-17 21:39:00","inspection_id":"87066217","insp_violation_id":"271848096","seq_no":"7","part_no":"392","part_no_section":"2W","insp_viol_unit":"1","insp_unit_id":"211667159","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-20T10:52:51.000000Z","updated_at":"2026-02-28T10:41:31.000000Z","normalized_code":"3922W"}],"inspection_per_units":[{"id":19024822,"change_date":"2026-02-17 21:39:00","inspection_id":"87066217","insp_unit_id":"211667159","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"GJR9363","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AA09Y1XW018164","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-20T10:14:32.000000Z","updated_at":"2026-02-28T10:03:58.000000Z"}]},{"id":11251626,"change_date":"2026-02-27 21:42:00","inspection_id":"87164912","dot_number":"1941962","report_state":"TX","report_number":"7CRD9DCJ9W","insp_date":"2026-02-04 00:00:00","insp_start_time":"1312","insp_end_time":"1325","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"1700  RUIZ","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-02-27 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"33001","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":"9865282","transaction_code":"A","transaction_date":"2026-02-27 00:00:00","upload_date":"2026-02-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01941962","upload_search_indicator":"M","census_search_date":"2026-02-27 21:42:00","snet_input_date":"2026-02-04 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-02-27 21:42:00","insp_carrier_name":"CARLOS ESQUIVEL","insp_carrier_street":"8014 TUFFLY ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77029","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0155754","created_at":"2026-03-02T10:39:50.000000Z","updated_at":"2026-03-10T09:31:29.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19238435,"change_date":"2026-02-27 21:42:00","inspection_id":"87164912","insp_unit_id":"211887472","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"007","insp_unit_license":"GJR9363","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AA09Y1XW018164","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-02T10:16:28.000000Z","updated_at":"2026-03-10T09:06:11.000000Z"}]},{"id":10412884,"change_date":"2025-12-11 21:45:00","inspection_id":"86543700","dot_number":"1941962","report_state":"TX","report_number":"7B589DCADE","insp_date":"2025-12-08 00:00:00","insp_start_time":"0810","insp_end_time":"0825","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"7400  LYONS","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-12-11 21:45: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":"9782735","transaction_code":"A","transaction_date":"2025-12-11 00:00:00","upload_date":"2025-12-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01941962","upload_search_indicator":"M","census_search_date":"2025-12-11 21:45:00","snet_input_date":"2025-12-08 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-12-11 21:45:00","insp_carrier_name":"CARLOS ESQUIVEL","insp_carrier_street":"8014 TUFFLY ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77029","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0155754","created_at":"2025-12-14T10:31:55.000000Z","updated_at":"2025-12-15T10:31:34.000000Z","inspection_violations":[{"id":17455043,"change_date":"2025-12-11 21:45:00","inspection_id":"86543700","insp_violation_id":"270633588","seq_no":"1","part_no":"396","part_no_section":"5B","insp_viol_unit":"1","insp_unit_id":"210562501","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-14T10:32:48.000000Z","updated_at":"2025-12-15T10:33:02.000000Z","normalized_code":"3965B"}],"inspection_per_units":[{"id":17415156,"change_date":"2025-12-11 21:45:00","inspection_id":"86543700","insp_unit_id":"210562501","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"GJR9363","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AA09Y1XW018164","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-14T10:02:05.000000Z","updated_at":"2025-12-15T10:02:04.000000Z"}]},{"id":10219320,"change_date":"2025-11-17 21:40:00","inspection_id":"86341045","dot_number":"1941962","report_state":"TX","report_number":"7AGE9DJW5S","insp_date":"2025-11-13 00:00:00","insp_start_time":"1417","insp_end_time":"1445","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"300  MERCURY DR","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-11-17 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"48000","viol_total":"3","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9759413","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":"01941962","upload_search_indicator":"M","census_search_date":"2025-11-17 21:40:00","snet_input_date":"2025-11-13 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-11-17 21:40:00","insp_carrier_name":"CARLOS ESQUIVEL","insp_carrier_street":"8014 TUFFLY ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77029","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0155754","created_at":"2025-11-20T10:30:37.000000Z","updated_at":"2025-11-21T10:31:01.000000Z","inspection_violations":[{"id":16983988,"change_date":"2025-11-17 21:40:00","inspection_id":"86341045","insp_violation_id":"270008873","seq_no":"1","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"210074613","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-20T10:31:01.000000Z","updated_at":"2025-11-21T10:31:39.000000Z","normalized_code":"3939"},{"id":16983989,"change_date":"2025-11-17 21:40:00","inspection_id":"86341045","insp_violation_id":"270008874","seq_no":"2","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"1","insp_unit_id":"210074613","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-11-20T10:31:01.000000Z","updated_at":"2025-11-21T10:31:39.000000Z","normalized_code":"39375A3TAOL"},{"id":16983990,"change_date":"2025-11-17 21:40:00","inspection_id":"86341045","insp_violation_id":"270008875","seq_no":"3","part_no":"393","part_no_section":"205A","insp_viol_unit":"1","insp_unit_id":"210074613","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-11-20T10:31:02.000000Z","updated_at":"2025-11-21T10:31:39.000000Z","normalized_code":"393205A"}],"inspection_per_units":[{"id":17025610,"change_date":"2025-11-17 21:40:00","inspection_id":"86341045","insp_unit_id":"210074613","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"007","insp_unit_license":"GJR9363","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AA09Y1XW018164","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-20T10:00:38.000000Z","updated_at":"2025-11-21T10:01:12.000000Z"}]},{"id":10201644,"change_date":"2025-11-14 21:40:00","inspection_id":"86322552","dot_number":"1941962","report_state":"TX","report_number":"7AA69DIABJ","insp_date":"2025-11-07 00:00:00","insp_start_time":"0609","insp_end_time":"0640","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"8000  EAST FWY","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-11-14 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"48000","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":"9756942","transaction_code":"A","transaction_date":"2025-11-14 00:00:00","upload_date":"2025-11-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01941962","upload_search_indicator":"M","census_search_date":"2025-11-14 21:40:00","snet_input_date":"2025-11-07 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-11-14 21:40:00","insp_carrier_name":"CARLOS ESQUIVEL","insp_carrier_street":"8014 TUFFLY ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77029","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0155754","created_at":"2025-11-17T10:31:29.000000Z","updated_at":"2025-11-18T10:30:55.000000Z","inspection_violations":[{"id":16949605,"change_date":"2025-11-14 21:40:00","inspection_id":"86322552","insp_violation_id":"269962229","seq_no":"1","part_no":"393","part_no_section":"51","insp_viol_unit":"1","insp_unit_id":"210034991","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-17T10:32:06.000000Z","updated_at":"2025-11-18T10:31:55.000000Z","normalized_code":"39351"}],"inspection_per_units":[{"id":16994036,"change_date":"2025-11-14 21:40:00","inspection_id":"86322552","insp_unit_id":"210034991","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"007","insp_unit_license":"GJR9363","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AA09Y1XW018164","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-17T10:01:24.000000Z","updated_at":"2025-11-18T10:01:22.000000Z"}]},{"id":10148204,"change_date":"2025-11-07 21:40:00","inspection_id":"86266290","dot_number":"1941962","report_state":"TX","report_number":"7A7D9DCN6Q","insp_date":"2025-11-04 00:00:00","insp_start_time":"1356","insp_end_time":"1411","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"200 S JENSEN DR","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"UNK","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-11-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"48000","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":"9750609","transaction_code":"A","transaction_date":"2025-11-07 00:00:00","upload_date":"2025-11-07 00:00:00","upload_first_byte":"0","upload_dot_number":"01941962","upload_search_indicator":"M","census_search_date":"2025-11-07 21:40:00","snet_input_date":"2025-11-04 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-11-07 21:40:00","insp_carrier_name":"CARLOS ESQUIVEL","insp_carrier_street":"8014 TUFFLY ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77029","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0155754","created_at":"2025-11-10T10:31:44.000000Z","updated_at":"2025-11-11T10:31:02.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16894937,"change_date":"2025-11-07 21:40:00","inspection_id":"86266290","insp_unit_id":"209909686","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"GJR9363","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AA09Y1XW018164","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-10T10:02:16.000000Z","updated_at":"2025-11-11T10:01:15.000000Z"}]},{"id":9868579,"change_date":"2025-10-06 21:41:00","inspection_id":"85971476","dot_number":"1941962","report_state":"TX","report_number":"79379DGREP","insp_date":"2025-09-25 00:00:00","insp_start_time":"0726","insp_end_time":"0747","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"2800  CAVALCADE ST","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"HARPER BROS","shipping_paper_number":"120528","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-06 21:41:00","post_acc_ind":"N","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":"9715405","transaction_code":"A","transaction_date":"2025-10-06 00:00:00","upload_date":"2025-10-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01941962","upload_search_indicator":"M","census_search_date":"2025-10-06 21:41:00","snet_input_date":"2025-09-25 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-10-06 21:41:00","insp_carrier_name":"CARLOS ESQUIVEL","insp_carrier_street":"8014 TUFFLY ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77029","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0155754","created_at":"2025-10-09T10:00:57.000000Z","updated_at":"2025-10-10T10:01:33.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16369281,"change_date":"2025-10-06 21:41:00","inspection_id":"85971476","insp_unit_id":"209325298","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"GJR9363","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AA09Y1XW018164","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-09T09:45:52.000000Z","updated_at":"2025-10-10T09:47:02.000000Z"}]},{"id":9622685,"change_date":"2025-09-09 21:41:00","inspection_id":"85713402","dot_number":"1941962","report_state":"TX","report_number":"78JA9DGRDN","insp_date":"2025-09-05 00:00:00","insp_start_time":"1049","insp_end_time":"1115","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"4300  ORANGE ST","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-09-08 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"9689131","transaction_code":"C","transaction_date":"2025-09-09 00:00:00","upload_date":"2025-09-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01941962","upload_search_indicator":"M","census_search_date":"2025-09-08 21:38:00","snet_input_date":"2025-09-05 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-09-08 21:38:00","insp_carrier_name":"CARLOS ESQUIVEL","insp_carrier_street":"8014 TUFFLY ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77029","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0155754","created_at":"2025-09-10T10:46:13.000000Z","updated_at":"2025-09-13T10:47:04.000000Z","inspection_violations":[{"id":15760271,"change_date":"2025-09-09 21:41:00","inspection_id":"85713402","insp_violation_id":"268558507","seq_no":"1","part_no":"393","part_no_section":"24A","insp_viol_unit":"1","insp_unit_id":"208833270","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-12T10:51:28.000000Z","updated_at":"2025-09-13T10:49:32.000000Z","normalized_code":"39324A"},{"id":15760272,"change_date":"2025-09-09 21:41:00","inspection_id":"85713402","insp_violation_id":"268558508","seq_no":"2","part_no":"393","part_no_section":"201A","insp_viol_unit":"1","insp_unit_id":"208833270","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-12T10:51:28.000000Z","updated_at":"2025-09-13T10:49:32.000000Z","normalized_code":"393201A"},{"id":15760273,"change_date":"2025-09-09 21:41:00","inspection_id":"85713402","insp_violation_id":"268558509","seq_no":"3","part_no":"393","part_no_section":"95A","insp_viol_unit":"1","insp_unit_id":"208833270","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-12T10:51:28.000000Z","updated_at":"2025-09-13T10:49:32.000000Z","normalized_code":"39395A"},{"id":15760274,"change_date":"2025-09-09 21:41:00","inspection_id":"85713402","insp_violation_id":"268558510","seq_no":"4","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"208833270","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-12T10:51:28.000000Z","updated_at":"2025-09-13T10:49:32.000000Z","normalized_code":"3939"}],"inspection_per_units":[{"id":15914427,"change_date":"2025-09-09 21:41:00","inspection_id":"85713402","insp_unit_id":"208833270","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"GJR9363","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AA09Y1XW018164","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-12T10:47:48.000000Z","updated_at":"2025-09-13T09:59:48.000000Z"}]},{"id":8514334,"change_date":"2025-04-30 21:52:00","inspection_id":"84545468","dot_number":"1941962","report_state":"TX","report_number":"74SA9DGR6G","insp_date":"2025-04-23 00:00:00","insp_start_time":"1056","insp_end_time":"1111","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"300  MERCURY DR","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-30 21:52: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":"9564588","transaction_code":"A","transaction_date":"2025-04-30 00:00:00","upload_date":"2025-04-30 00:00:00","upload_first_byte":"0","upload_dot_number":"01941962","upload_search_indicator":"M","census_search_date":"2025-04-30 21:52:00","snet_input_date":"2025-04-23 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-04-30 21:52:00","insp_carrier_name":"CARLOS ESQUIVEL","insp_carrier_street":"8014 TUFFLY ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77029","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0155754","created_at":"2025-05-02T13:51:13.000000Z","updated_at":"2025-05-04T10:40:48.000000Z","inspection_violations":[{"id":13478052,"change_date":"2025-04-30 21:52:00","inspection_id":"84545468","insp_violation_id":"265932960","seq_no":"1","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"206578615","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-02T14:15:51.000000Z","updated_at":"2025-05-03T11:19:48.000000Z","normalized_code":"3939"}],"inspection_per_units":[{"id":13841085,"change_date":"2025-04-30 21:52:00","inspection_id":"84545468","insp_unit_id":"206578615","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"GJR9363","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AA09Y1XW018164","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-03T10:26:16.000000Z","updated_at":"2025-05-04T10:14:24.000000Z"}]},{"id":8534876,"change_date":"2025-05-02 21:41:00","inspection_id":"84567057","dot_number":"1941962","report_state":"TX","report_number":"74EH9DBV1Y","insp_date":"2025-04-09 00:00:00","insp_start_time":"1730","insp_end_time":"1743","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"300  MERCURY","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-05-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"48000","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":"9566854","transaction_code":"A","transaction_date":"2025-05-02 00:00:00","upload_date":"2025-05-02 00:00:00","upload_first_byte":"0","upload_dot_number":"01941962","upload_search_indicator":"M","census_search_date":"2025-05-02 21:41:00","snet_input_date":"2025-04-09 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-05-02 21:41:00","insp_carrier_name":"CARLOS ESQUIVEL","insp_carrier_street":"8014 TUFFLY ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77029","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0155754","created_at":"2025-05-05T10:16:09.000000Z","updated_at":"2025-05-06T10:06:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13877878,"change_date":"2025-05-02 21:41:00","inspection_id":"84567057","insp_unit_id":"206618641","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"007","insp_unit_license":"GJR9363","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AA09Y1XW018164","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-05T10:06:06.000000Z","updated_at":"2025-05-07T10:04:22.000000Z"}]},{"id":3416331,"change_date":"2023-07-05 21:42:00","inspection_id":"79040122","dot_number":"1941962","report_state":"TX","report_number":"6MAG9DCP16","insp_date":"2023-06-27 00:00:00","insp_start_time":"1605","insp_end_time":"1620","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"3600  GAGER","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":"2023-06-30 21:41: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":"9017501","transaction_code":"C","transaction_date":"2023-07-05 00:00:00","upload_date":"2023-07-05 00:00:00","upload_first_byte":"0","upload_dot_number":"01941962","upload_search_indicator":"M","census_search_date":"2023-06-30 21:41:00","snet_input_date":"2023-06-27 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-06-30 21:41:00","insp_carrier_name":"CARLOS ESQUIVEL","insp_carrier_street":"8014 TUFFLY ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77029","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0155754","created_at":"2025-03-17T19:30:37.000000Z","updated_at":"2025-03-17T19:30:37.000000Z","inspection_violations":[{"id":5266565,"change_date":"2023-07-05 21:42:00","inspection_id":"79040122","insp_violation_id":"253878616","seq_no":"1","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"1","insp_unit_id":"195837755","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:27.000000Z","updated_at":"2025-03-17T21:31:27.000000Z","normalized_code":"39375C"}],"inspection_per_units":[{"id":5492796,"change_date":"2023-07-05 21:42:00","inspection_id":"79040122","insp_unit_id":"195837755","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"GJR9363","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AA09Y1XW018164","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:20.000000Z","updated_at":"2025-03-17T22:46:20.000000Z"}]},{"id":2534953,"change_date":"2023-03-08 21:41:00","inspection_id":"78042473","dot_number":"1941962","report_state":"TX","report_number":"6IY79DCPSR","insp_date":"2023-02-27 00:00:00","insp_start_time":"0750","insp_end_time":"0810","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"1700  NANCE","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":"2023-03-08 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8922489","transaction_code":"A","transaction_date":"2023-03-08 00:00:00","upload_date":"2023-03-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01941962","upload_search_indicator":"M","census_search_date":"2023-03-08 21:41:00","snet_input_date":"2023-02-27 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-03-08 21:41:00","insp_carrier_name":"CARLOS ESQUIVEL","insp_carrier_street":"8014 TUFFLY ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77029","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0155754","created_at":"2025-03-17T19:13:22.000000Z","updated_at":"2025-03-17T19:13:22.000000Z","inspection_violations":[{"id":3897760,"change_date":"2023-03-08 21:41:00","inspection_id":"78042473","insp_violation_id":"251549794","seq_no":"1","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"193773898","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:25:16.000000Z","updated_at":"2025-03-17T21:25:16.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":4080402,"change_date":"2023-03-08 21:41:00","inspection_id":"78042473","insp_unit_id":"193773898","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"GJR9363","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AA09Y1XW018164","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:15.000000Z","updated_at":"2025-03-17T22:35:15.000000Z"}]},{"id":2350757,"change_date":"2023-02-10 21:40:00","inspection_id":"77832706","dot_number":"1941962","report_state":"TX","report_number":"6I9H9DJNE4","insp_date":"2023-02-02 00:00:00","insp_start_time":"1659","insp_end_time":"1733","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"5900  HIRSCH RD","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":"2023-02-10 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"48000","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":"8900606","transaction_code":"A","transaction_date":"2023-02-10 00:00:00","upload_date":"2023-02-10 00:00:00","upload_first_byte":"0","upload_dot_number":"01941962","upload_search_indicator":"M","census_search_date":"2023-02-10 21:40:00","snet_input_date":"2023-02-02 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-02-10 21:40:00","insp_carrier_name":"CARLOS ESQUIVEL","insp_carrier_street":"8014 TUFFLY ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77029","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0155754","created_at":"2025-03-17T19:09:58.000000Z","updated_at":"2025-03-17T19:09:58.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3783273,"change_date":"2023-02-10 21:40:00","inspection_id":"77832706","insp_unit_id":"193351558","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"007","insp_unit_license":"GJR9363","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AA09Y1XW018164","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:05.000000Z","updated_at":"2025-03-17T22:33:05.000000Z"}]},{"id":2048331,"change_date":"2023-01-02 21:31:00","inspection_id":"77487103","dot_number":"1941962","report_state":"TX","report_number":"6GRC9DBZBM","insp_date":"2022-12-10 00:00:00","insp_start_time":"1252","insp_end_time":"1309","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"7500  KOPMAN RD","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":"2023-01-02 21:31:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8864274","transaction_code":"A","transaction_date":"2023-01-02 00:00:00","upload_date":"2023-01-02 00:00:00","upload_first_byte":"0","upload_dot_number":"01941962","upload_search_indicator":"M","census_search_date":"2023-01-02 21:31:00","snet_input_date":"2022-12-10 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-01-02 21:31:00","insp_carrier_name":"CARLOS ESQUIVEL","insp_carrier_street":"8014 TUFFLY ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77029","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0155754","created_at":"2025-03-17T19:04:22.000000Z","updated_at":"2025-03-17T19:04:22.000000Z","inspection_violations":[{"id":3171239,"change_date":"2023-01-02 21:31:00","inspection_id":"77487103","insp_violation_id":"250339491","seq_no":"1","part_no":"393","part_no_section":"75(a)","insp_viol_unit":"1","insp_unit_id":"192655846","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:22:01.000000Z","updated_at":"2025-03-17T21:22:01.000000Z","normalized_code":"39375A"}],"inspection_per_units":[{"id":3294905,"change_date":"2023-01-02 21:31:00","inspection_id":"77487103","insp_unit_id":"192655846","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"GJR9363","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AA09Y1XW018164","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:29:34.000000Z","updated_at":"2025-03-17T22:29:34.000000Z"}]},{"id":1906226,"change_date":"2022-12-08 21:41:00","inspection_id":"77324509","dot_number":"1941962","report_state":"TX","report_number":"6GKF9DBVBH","insp_date":"2022-12-03 00:00:00","insp_start_time":"1545","insp_end_time":"1605","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0069 IN HARRIS CO. (115-151","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"C ESQUIVEL TRUCKING","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":"2022-12-08 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"8846290","transaction_code":"A","transaction_date":"2022-12-08 00:00:00","upload_date":"2022-12-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01941962","upload_search_indicator":"M","census_search_date":"2022-12-08 21:41:00","snet_input_date":"2022-12-03 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-12-08 21:41:00","insp_carrier_name":"CARLOS ESQUIVEL","insp_carrier_street":"8014 TUFFLY ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77029","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0155754","created_at":"2025-03-17T19:01:50.000000Z","updated_at":"2025-03-17T19:01:50.000000Z","inspection_violations":[{"id":2965467,"change_date":"2022-12-08 21:41:00","inspection_id":"77324509","insp_violation_id":"250003948","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"192337632","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:07.000000Z","updated_at":"2025-03-17T21:21:07.000000Z","normalized_code":"3922"},{"id":2965468,"change_date":"2022-12-08 21:41:00","inspection_id":"77324509","insp_violation_id":"250003949","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"192337632","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:07.000000Z","updated_at":"2025-03-17T21:21:07.000000Z","normalized_code":"3939A"},{"id":2965469,"change_date":"2022-12-08 21:41:00","inspection_id":"77324509","insp_violation_id":"250003950","seq_no":"3","part_no":"393","part_no_section":"19","insp_viol_unit":"1","insp_unit_id":"192337632","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:07.000000Z","updated_at":"2025-03-17T21:21:07.000000Z","normalized_code":"39319"},{"id":2965470,"change_date":"2022-12-08 21:41:00","inspection_id":"77324509","insp_violation_id":"250003951","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"192337632","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:07.000000Z","updated_at":"2025-03-17T21:21:07.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":3068077,"change_date":"2022-12-08 21:41:00","inspection_id":"77324509","insp_unit_id":"192337632","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"007","insp_unit_license":"GJR9363","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AA09Y1XW018164","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:00.000000Z","updated_at":"2025-03-17T22:28:00.000000Z"}]},{"id":2258518,"change_date":"2023-01-30 21:44:00","inspection_id":"77727848","dot_number":"1941962","report_state":"TX","report_number":"6EOH9DCO6X","insp_date":"2022-09-26 00:00:00","insp_start_time":"1706","insp_end_time":"1730","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0069 IN HARRIS CO. (115-151","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":"2023-01-30 21:44: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":"8891121","transaction_code":"A","transaction_date":"2023-01-30 00:00:00","upload_date":"2023-01-30 00:00:00","upload_first_byte":"0","upload_dot_number":"01941962","upload_search_indicator":"M","census_search_date":"2023-01-30 21:44:00","snet_input_date":"2022-09-26 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-01-30 21:44:00","insp_carrier_name":"CARLOS ESQUIVEL","insp_carrier_street":"8014 TUFFLY ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77029","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0155754","created_at":"2025-03-17T19:08:10.000000Z","updated_at":"2025-03-17T19:08:10.000000Z","inspection_violations":[{"id":3486786,"change_date":"2023-01-30 21:44:00","inspection_id":"77727848","insp_violation_id":"250855038","seq_no":"1","part_no":"393","part_no_section":"83(g)","insp_viol_unit":"1","insp_unit_id":"193137299","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:29.000000Z","updated_at":"2025-03-17T21:23:29.000000Z","normalized_code":"39383G"},{"id":3486787,"change_date":"2023-01-30 21:44:00","inspection_id":"77727848","insp_violation_id":"250855039","seq_no":"2","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"193137299","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:29.000000Z","updated_at":"2025-03-17T21:23:29.000000Z","normalized_code":"39395F"}],"inspection_per_units":[{"id":3635687,"change_date":"2023-01-30 21:44:00","inspection_id":"77727848","insp_unit_id":"193137299","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"007","insp_unit_license":"GJR9363","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AA09Y1XW018164","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:04.000000Z","updated_at":"2025-03-17T22:32:04.000000Z"}]},{"id":1127572,"change_date":"2022-08-24 21:40:00","inspection_id":"76426506","dot_number":"1941962","report_state":"TX","report_number":"6DKG9DBV4M","insp_date":"2022-08-17 00:00:00","insp_start_time":"1730","insp_end_time":"1802","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0069 IN HARRIS CO. (115-151","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"C ESQUIVEL TRUCKING","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":"2022-08-24 21:40: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":"8752903","transaction_code":"A","transaction_date":"2022-08-24 00:00:00","upload_date":"2022-08-24 00:00:00","upload_first_byte":"0","upload_dot_number":"01941962","upload_search_indicator":"M","census_search_date":"2022-08-24 21:40:00","snet_input_date":"2022-08-17 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-08-24 21:40:00","insp_carrier_name":"CARLOS ESQUIVEL","insp_carrier_street":"8014 TUFFLY ST","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77029","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0155754","created_at":"2025-03-17T18:47:33.000000Z","updated_at":"2025-03-17T18:47:33.000000Z","inspection_violations":[{"id":1782068,"change_date":"2022-08-24 21:40:00","inspection_id":"76426506","insp_violation_id":"247973311","seq_no":"1","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"190524690","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:18.000000Z","updated_at":"2025-03-17T21:15:18.000000Z","normalized_code":"39395A"},{"id":1782069,"change_date":"2022-08-24 21:40:00","inspection_id":"76426506","insp_violation_id":"247973312","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"190524690","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:18.000000Z","updated_at":"2025-03-17T21:15:18.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":1813830,"change_date":"2022-08-24 21:40:00","inspection_id":"76426506","insp_unit_id":"190524690","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"007","insp_unit_license":"GJR9363","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AA09Y1XW018164","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:30.000000Z","updated_at":"2025-03-17T22:19:30.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/1941962\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/1941962\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1941962\/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\/1941962\/inspections","per_page":100,"prev_page_url":null,"to":19,"total":19}