{"current_page":1,"data":[{"id":12634117,"change_date":"2026-08-04 21:40:00","inspection_id":"88605400","dot_number":"1973608","report_state":"TX","report_number":"7HA99DGRQH","insp_date":"2026-07-17 00:00:00","insp_start_time":"0906","insp_end_time":"0928","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"5200  NAVIGATION BLV","county_code_state":"TX","county_code":"201","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-08-04 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"76600","viol_total":"4","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"10056101","transaction_code":"A","transaction_date":"2026-08-04 00:00:00","upload_date":"2026-08-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01973608","upload_search_indicator":"M","census_search_date":"2026-08-04 21:40:00","snet_input_date":"2026-07-17 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-08-04 21:40:00","insp_carrier_name":"CARLOS OFILIO CARRANZA","insp_carrier_street":"7335 WALKER","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77011","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0766585","created_at":"2026-08-07T09:39:55.000000Z","updated_at":"2026-08-15T09:31:32.000000Z","inspection_violations":[{"id":21995005,"change_date":"2026-08-04 21:40:00","inspection_id":"88605400","insp_violation_id":"275924512","seq_no":"1","part_no":"392","part_no_section":"2C","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":"2026-08-07T09:57:53.000000Z","updated_at":"2026-08-15T09:43:54.000000Z","normalized_code":"3922C"},{"id":21995006,"change_date":"2026-08-04 21:40:00","inspection_id":"88605400","insp_violation_id":"275924513","seq_no":"2","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"214981263","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-07T09:57:53.000000Z","updated_at":"2026-08-15T09:43:54.000000Z","normalized_code":"3922RG"},{"id":21995007,"change_date":"2026-08-04 21:40:00","inspection_id":"88605400","insp_violation_id":"275924514","seq_no":"3","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"214981263","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-07T09:57:53.000000Z","updated_at":"2026-08-15T09:43:54.000000Z","normalized_code":"3922RG"},{"id":21995008,"change_date":"2026-08-04 21:40:00","inspection_id":"88605400","insp_violation_id":"275924515","seq_no":"4","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"214981263","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-07T09:57:53.000000Z","updated_at":"2026-08-15T09:43:54.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":21931631,"change_date":"2026-08-04 21:40:00","inspection_id":"88605400","insp_unit_id":"214981263","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"1L39794","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NKDX4EX89J256337","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-08-07T09:18:50.000000Z","updated_at":"2026-08-15T09:02:59.000000Z"}]},{"id":9461988,"change_date":"2025-08-20 21:40:00","inspection_id":"85544704","dot_number":"1973608","report_state":"TX","report_number":"77XD9DCQ4F","insp_date":"2025-08-14 00:00:00","insp_start_time":"1248","insp_end_time":"1420","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0010 IN HARRIS CO. (742-797","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"TEXAS MATERIAL","shipping_paper_number":"429491718","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-08-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"76600","viol_total":"8","oos_total":"4","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"8","vehicle_oos_total":"4","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9671160","transaction_code":"A","transaction_date":"2025-08-20 00:00:00","upload_date":"2025-08-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01973608","upload_search_indicator":"M","census_search_date":"2025-08-20 21:40:00","snet_input_date":"2025-08-14 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-08-20 21:40:00","insp_carrier_name":"CARLOS OFILIO CARRANZA","insp_carrier_street":"7335 WALKER","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77011","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0766585","created_at":"2025-08-23T10:46:53.000000Z","updated_at":"2025-08-25T10:42:16.000000Z","inspection_violations":[{"id":15413165,"change_date":"2025-08-20 21:40:00","inspection_id":"85544704","insp_violation_id":"268144922","seq_no":"1","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"208494656","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-23T10:49:17.000000Z","updated_at":"2025-08-24T10:47:51.000000Z","normalized_code":"3922RG"},{"id":15413166,"change_date":"2025-08-20 21:40:00","inspection_id":"85544704","insp_violation_id":"268144923","seq_no":"2","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"208494656","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-23T10:49:17.000000Z","updated_at":"2025-08-24T10:47:51.000000Z","normalized_code":"3922RG"},{"id":15413167,"change_date":"2025-08-20 21:40:00","inspection_id":"85544704","insp_violation_id":"268144924","seq_no":"3","part_no":"390","part_no_section":"21(a)","insp_viol_unit":"1","insp_unit_id":"208494656","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-23T10:49:17.000000Z","updated_at":"2025-08-24T10:47:51.000000Z","normalized_code":"39021A"},{"id":15413168,"change_date":"2025-08-20 21:40:00","inspection_id":"85544704","insp_violation_id":"268144925","seq_no":"4","part_no":"393","part_no_section":"75A4","insp_viol_unit":"1","insp_unit_id":"208494656","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-08-23T10:49:17.000000Z","updated_at":"2025-08-24T10:47:51.000000Z","normalized_code":"39375A4"},{"id":15413169,"change_date":"2025-08-20 21:40:00","inspection_id":"85544704","insp_violation_id":"268144926","seq_no":"5","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"1","insp_unit_id":"208494656","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-08-23T10:49:17.000000Z","updated_at":"2025-08-24T10:47:51.000000Z","normalized_code":"39375A3TAOL"},{"id":15413170,"change_date":"2025-08-20 21:40:00","inspection_id":"85544704","insp_violation_id":"268144927","seq_no":"6","part_no":"393","part_no_section":"207A","insp_viol_unit":"1","insp_unit_id":"208494656","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-08-23T10:49:17.000000Z","updated_at":"2025-08-24T10:47:51.000000Z","normalized_code":"393207A"},{"id":15413171,"change_date":"2025-08-20 21:40:00","inspection_id":"85544704","insp_violation_id":"268144928","seq_no":"7","part_no":"393","part_no_section":"201A","insp_viol_unit":"1","insp_unit_id":"208494656","insp_violation_category_id":"19","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-08-23T10:49:17.000000Z","updated_at":"2025-08-24T10:47:51.000000Z","normalized_code":"393201A"},{"id":15413172,"change_date":"2025-08-20 21:40:00","inspection_id":"85544704","insp_violation_id":"268144929","seq_no":"8","part_no":"393","part_no_section":"83G","insp_viol_unit":"1","insp_unit_id":"208494656","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-23T10:49:17.000000Z","updated_at":"2025-08-24T10:47:51.000000Z","normalized_code":"39383G"}],"inspection_per_units":[{"id":15604108,"change_date":"2025-08-20 21:40:00","inspection_id":"85544704","insp_unit_id":"208494656","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"830","insp_unit_license":"1L39794","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NKDX4EX89J256337","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-23T09:46:44.000000Z","updated_at":"2025-08-24T09:46:03.000000Z"}]},{"id":8534934,"change_date":"2025-05-02 21:41:00","inspection_id":"84567121","dot_number":"1973608","report_state":"TX","report_number":"74UH9DBT25","insp_date":"2025-04-25 00:00:00","insp_start_time":"1701","insp_end_time":"1729","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"81 N DELANO 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-05-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"76600","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":"9566920","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":"01973608","upload_search_indicator":"M","census_search_date":"2025-05-02 21:41:00","snet_input_date":"2025-04-25 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-05-02 21:41:00","insp_carrier_name":"CARLOS OFILIO CARRANZA","insp_carrier_street":"7335 WALKER","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77011","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0766585","created_at":"2025-05-05T10:16:09.000000Z","updated_at":"2025-05-06T10:06:28.000000Z","inspection_violations":[{"id":13517662,"change_date":"2025-05-02 21:41:00","inspection_id":"84567121","insp_violation_id":"265978570","seq_no":"1","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"206618767","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-04T10:54:29.000000Z","updated_at":"2025-05-06T10:33:11.000000Z","normalized_code":"3922RG"},{"id":13517663,"change_date":"2025-05-02 21:41:00","inspection_id":"84567121","insp_violation_id":"265978571","seq_no":"2","part_no":"393","part_no_section":"75A4","insp_viol_unit":"1","insp_unit_id":"206618767","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-05-04T10:54:29.000000Z","updated_at":"2025-05-06T10:33:11.000000Z","normalized_code":"39375A4"},{"id":13517664,"change_date":"2025-05-02 21:41:00","inspection_id":"84567121","insp_violation_id":"265978572","seq_no":"3","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"206618767","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-04T10:54:29.000000Z","updated_at":"2025-05-06T10:33:11.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":13877965,"change_date":"2025-05-02 21:41:00","inspection_id":"84567121","insp_unit_id":"206618767","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"830","insp_unit_license":"1L39794","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NKDX4EX89J256337","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-05T10:06:06.000000Z","updated_at":"2025-05-07T10:04:24.000000Z"}]},{"id":7845244,"change_date":"2025-02-11 21:40:00","inspection_id":"83841504","dot_number":"1973608","report_state":"TX","report_number":"72LD9DJNI1","insp_date":"2025-02-03 00:00:00","insp_start_time":"1350","insp_end_time":"1407","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"5200  EAST FREEWAY S","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-02-11 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"76600","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":"9494551","transaction_code":"A","transaction_date":"2025-02-11 00:00:00","upload_date":"2025-02-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01973608","upload_search_indicator":"M","census_search_date":"2025-02-11 21:40:00","snet_input_date":"2025-02-03 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-02-11 21:40:00","insp_carrier_name":"CARLOS OFILIO CARRANZA","insp_carrier_street":"7335 WALKER","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77011","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0766585","created_at":"2025-03-17T21:01:10.000000Z","updated_at":"2025-03-17T21:01:10.000000Z","inspection_violations":[{"id":12259197,"change_date":"2025-02-11 21:40:00","inspection_id":"83841504","insp_violation_id":"264465849","seq_no":"1","part_no":"393","part_no_section":"75A1","insp_viol_unit":"1","insp_unit_id":"205276140","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:47.000000Z","updated_at":"2025-03-17T22:05:47.000000Z","normalized_code":"39375A1"},{"id":12259198,"change_date":"2025-02-11 21:40:00","inspection_id":"83841504","insp_violation_id":"264465850","seq_no":"2","part_no":"390","part_no_section":"21(a)","insp_viol_unit":"1","insp_unit_id":"205276140","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:47.000000Z","updated_at":"2025-03-17T22:05:47.000000Z","normalized_code":"39021A"},{"id":12259199,"change_date":"2025-02-11 21:40:00","inspection_id":"83841504","insp_violation_id":"264465851","seq_no":"3","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"205276140","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:47.000000Z","updated_at":"2025-03-17T22:05:47.000000Z","normalized_code":"3922RG"},{"id":12259200,"change_date":"2025-02-11 21:40:00","inspection_id":"83841504","insp_violation_id":"264465852","seq_no":"4","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"205276140","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:47.000000Z","updated_at":"2025-03-17T22:05:47.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":12661594,"change_date":"2025-02-11 21:40:00","inspection_id":"83841504","insp_unit_id":"205276140","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"1L39794","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NKDX4EX89J256337","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:54:52.000000Z","updated_at":"2025-03-17T23:54:52.000000Z"}]},{"id":7278801,"change_date":"2024-11-25 21:44:00","inspection_id":"83246077","dot_number":"1973608","report_state":"TX","report_number":"70JD9DCRYW","insp_date":"2024-11-21 00:00:00","insp_start_time":"1259","insp_end_time":"1345","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"4800  RUSK ST","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"TEXAS MATERIALS","shipping_paper_number":"429454207","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-11-25 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"76600","viol_total":"12","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"12","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9435381","transaction_code":"A","transaction_date":"2024-11-25 00:00:00","upload_date":"2024-11-25 00:00:00","upload_first_byte":"0","upload_dot_number":"01973608","upload_search_indicator":"M","census_search_date":"2024-11-25 21:44:00","snet_input_date":"2024-11-21 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-11-25 21:44:00","insp_carrier_name":"CARLOS OFILIO CARRANZA","insp_carrier_street":"7335 WALKER","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77011","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0766585","created_at":"2025-03-17T20:47:46.000000Z","updated_at":"2025-03-17T20:47:46.000000Z","inspection_violations":[{"id":11377314,"change_date":"2024-11-25 21:44:00","inspection_id":"83246077","insp_violation_id":"263084303","seq_no":"1","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"204052262","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:14.000000Z","updated_at":"2025-03-17T22:01:14.000000Z","normalized_code":"3922RG"},{"id":11377315,"change_date":"2024-11-25 21:44:00","inspection_id":"83246077","insp_violation_id":"263084304","seq_no":"2","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"204052262","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:14.000000Z","updated_at":"2025-03-17T22:01:14.000000Z","normalized_code":"3922RG"},{"id":11377316,"change_date":"2024-11-25 21:44:00","inspection_id":"83246077","insp_violation_id":"263084305","seq_no":"3","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"204052262","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:14.000000Z","updated_at":"2025-03-17T22:01:14.000000Z","normalized_code":"39617C"},{"id":11377317,"change_date":"2024-11-25 21:44:00","inspection_id":"83246077","insp_violation_id":"263084306","seq_no":"4","part_no":"393","part_no_section":"9BRKLAMP","insp_viol_unit":"1","insp_unit_id":"204052262","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:14.000000Z","updated_at":"2025-03-17T22:01:14.000000Z","normalized_code":"3939BRKLAMP"},{"id":11377318,"change_date":"2024-11-25 21:44:00","inspection_id":"83246077","insp_violation_id":"263084307","seq_no":"5","part_no":"393","part_no_section":"9T","insp_viol_unit":"1","insp_unit_id":"204052262","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:14.000000Z","updated_at":"2025-03-17T22:01:14.000000Z","normalized_code":"3939T"},{"id":11377319,"change_date":"2024-11-25 21:44:00","inspection_id":"83246077","insp_violation_id":"263084308","seq_no":"6","part_no":"393","part_no_section":"9TS","insp_viol_unit":"1","insp_unit_id":"204052262","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T22:01:14.000000Z","updated_at":"2025-03-17T22:01:14.000000Z","normalized_code":"3939TS"},{"id":11377320,"change_date":"2024-11-25 21:44:00","inspection_id":"83246077","insp_violation_id":"263084309","seq_no":"7","part_no":"999","part_no_section":null,"insp_viol_unit":"1","insp_unit_id":"204052262","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:14.000000Z","updated_at":"2025-03-17T22:01:14.000000Z","normalized_code":"999"},{"id":11377321,"change_date":"2024-11-25 21:44:00","inspection_id":"83246077","insp_violation_id":"263084310","seq_no":"8","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"204052262","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:14.000000Z","updated_at":"2025-03-17T22:01:14.000000Z","normalized_code":"3939"},{"id":11377322,"change_date":"2024-11-25 21:44:00","inspection_id":"83246077","insp_violation_id":"263084311","seq_no":"9","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"204052262","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:14.000000Z","updated_at":"2025-03-17T22:01:14.000000Z","normalized_code":"3939"},{"id":11377323,"change_date":"2024-11-25 21:44:00","inspection_id":"83246077","insp_violation_id":"263084312","seq_no":"10","part_no":"393","part_no_section":"75A1","insp_viol_unit":"1","insp_unit_id":"204052262","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:01:14.000000Z","updated_at":"2025-03-17T22:01:14.000000Z","normalized_code":"39375A1"},{"id":11377324,"change_date":"2024-11-25 21:44:00","inspection_id":"83246077","insp_violation_id":"263084313","seq_no":"11","part_no":"393","part_no_section":"75A1","insp_viol_unit":"1","insp_unit_id":"204052262","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:14.000000Z","updated_at":"2025-03-17T22:01:14.000000Z","normalized_code":"39375A1"},{"id":11377325,"change_date":"2024-11-25 21:44:00","inspection_id":"83246077","insp_violation_id":"263084314","seq_no":"12","part_no":"393","part_no_section":"75A1","insp_viol_unit":"1","insp_unit_id":"204052262","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:01:14.000000Z","updated_at":"2025-03-17T22:01:14.000000Z","normalized_code":"39375A1"}],"inspection_per_units":[{"id":11740780,"change_date":"2024-11-25 21:44:00","inspection_id":"83246077","insp_unit_id":"204052262","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"AJ230","insp_unit_license":"1L39794","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NKDX4EX89J256337","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:44:42.000000Z","updated_at":"2025-03-17T23:44:42.000000Z"}]},{"id":6563677,"change_date":"2024-08-26 21:42:00","inspection_id":"82486499","dot_number":"1973608","report_state":"TX","report_number":"6XYB9DNNQP","insp_date":"2024-08-20 00:00:00","insp_start_time":"1128","insp_end_time":"1150","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0225 IN HARRIS CO. (686-700","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"TEXAS MATERIALS","shipping_paper_number":"429437979","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-08-26 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"76600","viol_total":"7","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9359661","transaction_code":"A","transaction_date":"2024-08-26 00:00:00","upload_date":"2024-08-26 00:00:00","upload_first_byte":"0","upload_dot_number":"01973608","upload_search_indicator":"M","census_search_date":"2024-08-26 21:42:00","snet_input_date":"2024-08-20 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-08-26 21:42:00","insp_carrier_name":"CARLOS OFILIO CARRANZA","insp_carrier_street":"7335 WALKER","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77011","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0766585","created_at":"2025-03-17T20:33:09.000000Z","updated_at":"2025-03-17T20:33:09.000000Z","inspection_violations":[{"id":10199575,"change_date":"2024-08-26 21:42:00","inspection_id":"82486499","insp_violation_id":"261410228","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"202586709","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:20.000000Z","updated_at":"2025-03-17T21:55:20.000000Z","normalized_code":"3922"},{"id":10199576,"change_date":"2024-08-26 21:42:00","inspection_id":"82486499","insp_violation_id":"261410229","seq_no":"7","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202586709","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:20.000000Z","updated_at":"2025-03-17T21:55:20.000000Z","normalized_code":"3939A"},{"id":10199577,"change_date":"2024-08-26 21:42:00","inspection_id":"82486499","insp_violation_id":"261410230","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"202586709","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:20.000000Z","updated_at":"2025-03-17T21:55:20.000000Z","normalized_code":"3922"},{"id":10199578,"change_date":"2024-08-26 21:42:00","inspection_id":"82486499","insp_violation_id":"261410231","seq_no":"3","part_no":"390","part_no_section":"21(a)","insp_viol_unit":"1","insp_unit_id":"202586709","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:20.000000Z","updated_at":"2025-03-17T21:55:20.000000Z","normalized_code":"39021A"},{"id":10199579,"change_date":"2024-08-26 21:42:00","inspection_id":"82486499","insp_violation_id":"261410232","seq_no":"4","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"202586709","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:20.000000Z","updated_at":"2025-03-17T21:55:20.000000Z","normalized_code":"39617C"},{"id":10199580,"change_date":"2024-08-26 21:42:00","inspection_id":"82486499","insp_violation_id":"261410233","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202586709","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:20.000000Z","updated_at":"2025-03-17T21:55:20.000000Z","normalized_code":"3939A"},{"id":10199581,"change_date":"2024-08-26 21:42:00","inspection_id":"82486499","insp_violation_id":"261410234","seq_no":"6","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202586709","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:20.000000Z","updated_at":"2025-03-17T21:55:20.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":10581766,"change_date":"2024-08-26 21:42:00","inspection_id":"82486499","insp_unit_id":"202586709","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"AJ230","insp_unit_license":"1L39794","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NKDX4EX89J256337","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:32:37.000000Z","updated_at":"2025-03-17T23:32:37.000000Z"}]},{"id":5412444,"change_date":"2024-04-01 21:41:00","inspection_id":"81243131","dot_number":"1973608","report_state":"TX","report_number":"V241376238","insp_date":"2024-03-27 00:00:00","insp_start_time":"1315","insp_end_time":"1355","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH45 SB @ FM 518","county_code_state":"TX","county_code":"167","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"TEXAS MATERIALS","shipping_paper_number":"429418240","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":"2024-04-01 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"76600","viol_total":"4","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9236374","transaction_code":"A","transaction_date":"2024-04-01 00:00:00","upload_date":"2024-04-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01973608","upload_search_indicator":"M","census_search_date":"2024-04-01 21:41:00","snet_input_date":"2024-03-27 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-04-01 21:41:00","insp_carrier_name":"CARLOS OFILIO CARRANZA","insp_carrier_street":"7335 WALKER","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77011","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0766585","created_at":"2025-03-17T20:09:53.000000Z","updated_at":"2025-03-17T20:09:53.000000Z","inspection_violations":[{"id":8354904,"change_date":"2024-04-01 21:41:00","inspection_id":"81243131","insp_violation_id":"258691287","seq_no":"1","part_no":"393","part_no_section":"75(a)(1)","insp_viol_unit":"1","insp_unit_id":"200186265","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:25.000000Z","updated_at":"2025-03-17T21:46:25.000000Z","normalized_code":"39375A1"},{"id":8354905,"change_date":"2024-04-01 21:41:00","inspection_id":"81243131","insp_violation_id":"258691288","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"200186265","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:25.000000Z","updated_at":"2025-03-17T21:46:25.000000Z","normalized_code":"3922"},{"id":8354906,"change_date":"2024-04-01 21:41:00","inspection_id":"81243131","insp_violation_id":"258691289","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:25.000000Z","updated_at":"2025-03-17T21:46:25.000000Z","normalized_code":"3922"},{"id":8354907,"change_date":"2024-04-01 21:41:00","inspection_id":"81243131","insp_violation_id":"258691290","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:25.000000Z","updated_at":"2025-03-17T21:46:25.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8717502,"change_date":"2024-04-01 21:41:00","inspection_id":"81243131","insp_unit_id":"200186265","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"830","insp_unit_license":"1L39794","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NKDX4EX89J256337","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:14:05.000000Z","updated_at":"2025-03-17T23:14:05.000000Z"}]},{"id":3232549,"change_date":"2023-06-07 21:42:00","inspection_id":"78833117","dot_number":"1973608","report_state":"TX","report_number":"6LCE9DJNKT","insp_date":"2023-05-24 00:00:00","insp_start_time":"1444","insp_end_time":"1538","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":"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":"2023-06-07 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"10","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"10","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8996561","transaction_code":"A","transaction_date":"2023-06-07 00:00:00","upload_date":"2023-06-07 00:00:00","upload_first_byte":"0","upload_dot_number":"01973608","upload_search_indicator":"M","census_search_date":"2023-06-07 21:42:00","snet_input_date":"2023-05-24 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-06-07 21:42:00","insp_carrier_name":"CARLOS OFILIO CARRANZA","insp_carrier_street":"7335 WALKER","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77011","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0766585","created_at":"2025-03-17T19:26:55.000000Z","updated_at":"2025-03-17T19:26:55.000000Z","inspection_violations":[{"id":4982465,"change_date":"2023-06-07 21:42:00","inspection_id":"78833117","insp_violation_id":"253363359","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"195378922","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:12.000000Z","updated_at":"2025-03-17T21:30:12.000000Z","normalized_code":"3939A"},{"id":4982466,"change_date":"2023-06-07 21:42:00","inspection_id":"78833117","insp_violation_id":"253363360","seq_no":"2","part_no":"999","part_no_section":null,"insp_viol_unit":"1","insp_unit_id":"195378922","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:12.000000Z","updated_at":"2025-03-17T21:30:12.000000Z","normalized_code":"999"},{"id":4982467,"change_date":"2023-06-07 21:42:00","inspection_id":"78833117","insp_violation_id":"253363361","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"195378922","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:12.000000Z","updated_at":"2025-03-17T21:30:12.000000Z","normalized_code":"3939A"},{"id":4982468,"change_date":"2023-06-07 21:42:00","inspection_id":"78833117","insp_violation_id":"253363362","seq_no":"4","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"195378922","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:12.000000Z","updated_at":"2025-03-17T21:30:12.000000Z","normalized_code":"39347E"},{"id":4982469,"change_date":"2023-06-07 21:42:00","inspection_id":"78833117","insp_violation_id":"253363363","seq_no":"5","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"195378922","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:12.000000Z","updated_at":"2025-03-17T21:30:12.000000Z","normalized_code":"39347E"},{"id":4982470,"change_date":"2023-06-07 21:42:00","inspection_id":"78833117","insp_violation_id":"253363364","seq_no":"6","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"195378922","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:12.000000Z","updated_at":"2025-03-17T21:30:12.000000Z","normalized_code":"39347E"},{"id":4982471,"change_date":"2023-06-07 21:42:00","inspection_id":"78833117","insp_violation_id":"253363365","seq_no":"7","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"195378922","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:12.000000Z","updated_at":"2025-03-17T21:30:12.000000Z","normalized_code":"39347E"},{"id":4982472,"change_date":"2023-06-07 21:42:00","inspection_id":"78833117","insp_violation_id":"253363366","seq_no":"8","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"195378922","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:12.000000Z","updated_at":"2025-03-17T21:30:12.000000Z","normalized_code":"39353B"},{"id":4982473,"change_date":"2023-06-07 21:42:00","inspection_id":"78833117","insp_violation_id":"253363367","seq_no":"9","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"195378922","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:30:12.000000Z","updated_at":"2025-03-17T21:30:12.000000Z","normalized_code":"3963A1"},{"id":4982474,"change_date":"2023-06-07 21:42:00","inspection_id":"78833117","insp_violation_id":"253363368","seq_no":"10","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"195378922","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:12.000000Z","updated_at":"2025-03-17T21:30:12.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5198911,"change_date":"2023-06-07 21:42:00","inspection_id":"78833117","insp_unit_id":"195378922","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"830","insp_unit_license":"80T126M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1NKDX4EX89J256337","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:43:58.000000Z","updated_at":"2025-03-17T22:43:58.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/1973608\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/1973608\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1973608\/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\/1973608\/inspections","per_page":100,"prev_page_url":null,"to":8,"total":8}