{"current_page":1,"data":[{"id":12253342,"change_date":"2026-06-22 21:40:00","inspection_id":"88211852","dot_number":"2174037","report_state":"TX","report_number":"V262433214","insp_date":"2026-06-19 00:00:00","insp_start_time":"1544","insp_end_time":"1604","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH 10 @ EXIT 718","county_code_state":"TX","county_code":"015","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"X","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-06-22 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"46000","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"10002413","transaction_code":"A","transaction_date":"2026-06-22 00:00:00","upload_date":"2026-06-22 00:00:00","upload_first_byte":"0","upload_dot_number":"02174037","upload_search_indicator":"M","census_search_date":"2026-06-22 21:40:00","snet_input_date":"2026-06-19 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-06-22 21:40:00","insp_carrier_name":"ALFREDO MARTINEZ","insp_carrier_street":"4011 ROLAND RD","insp_carrier_city":"KATY","insp_carrier_state":"TX","insp_carrier_zip_code":"77493-9701","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0193829","created_at":"2026-06-25T09:39:03.000000Z","updated_at":"2026-07-03T09:31:23.000000Z","inspection_violations":[{"id":21328670,"change_date":"2026-06-22 21:40:00","inspection_id":"88211852","insp_violation_id":"275063735","seq_no":"2","part_no":"393","part_no_section":"9H","insp_viol_unit":"1","insp_unit_id":"214230154","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-25T09:56:40.000000Z","updated_at":"2026-07-03T09:44:15.000000Z","normalized_code":"3939H"},{"id":21328669,"change_date":"2026-06-22 21:40:00","inspection_id":"88211852","insp_violation_id":"275063734","seq_no":"1","part_no":"393","part_no_section":"75A3","insp_viol_unit":"1","insp_unit_id":"214230154","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2026-06-25T09:56:40.000000Z","updated_at":"2026-07-03T09:44:15.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":21278350,"change_date":"2026-06-22 21:40:00","inspection_id":"88211852","insp_unit_id":"214230154","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"11","insp_unit_license":"GWL1250","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDDU8X29J254948","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-25T09:16:35.000000Z","updated_at":"2026-07-05T09:02:38.000000Z"}]},{"id":11912879,"change_date":"2026-05-14 21:43:00","inspection_id":"87852250","dot_number":"2174037","report_state":"TX","report_number":"V262330107","insp_date":"2026-05-12 00:00:00","insp_start_time":"1944","insp_end_time":"2029","registration_date":null,"region":"CT","ci_status_code":"C","location":"2A601","location_desc":"US59 SB DIBOLL SCALE","county_code_state":"TX","county_code":"005","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"MARTINEZ EXCAVATION","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-05-14 21:43: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":"9953968","transaction_code":"A","transaction_date":"2026-05-14 00:00:00","upload_date":"2026-05-14 00:00:00","upload_first_byte":"0","upload_dot_number":"02174037","upload_search_indicator":"M","census_search_date":"2026-05-14 21:43:00","snet_input_date":"2026-05-12 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-05-14 21:43:00","insp_carrier_name":"ALFREDO MARTINEZ","insp_carrier_street":"4011 ROLAND RD","insp_carrier_city":"KATY","insp_carrier_state":"TX","insp_carrier_zip_code":"77493-9701","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0193829","created_at":"2026-05-16T13:32:59.000000Z","updated_at":"2026-05-25T09:31:57.000000Z","inspection_violations":[{"id":20721361,"change_date":"2026-05-14 21:43:00","inspection_id":"87852250","insp_violation_id":"274264911","seq_no":"1","part_no":"393","part_no_section":"207A","insp_viol_unit":"1","insp_unit_id":"213559921","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-05-16T13:13:22.000000Z","updated_at":"2026-05-25T09:44:20.000000Z","normalized_code":"393207A"}],"inspection_per_units":[{"id":20709654,"change_date":"2026-05-14 21:43:00","inspection_id":"87852250","insp_unit_id":"213559921","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"8","insp_unit_license":"MPR7697","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDD49X99J246876","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-16T12:44:58.000000Z","updated_at":"2026-05-25T09:04:36.000000Z"}]},{"id":10508752,"change_date":"2025-12-23 21:39:00","inspection_id":"86643878","dot_number":"2174037","report_state":"TX","report_number":"V252127146","insp_date":"2025-12-20 00:00:00","insp_start_time":"1222","insp_end_time":"1239","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"FM 1488 MP 660","county_code_state":"TX","county_code":"339","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"UNKNOWN","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-12-23 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"53200","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":"9795497","transaction_code":"A","transaction_date":"2025-12-23 00:00:00","upload_date":"2025-12-23 00:00:00","upload_first_byte":"0","upload_dot_number":"02174037","upload_search_indicator":"M","census_search_date":"2025-12-23 21:39:00","snet_input_date":"2025-12-20 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-12-23 21:39:00","insp_carrier_name":"ALFREDO MARTINEZ","insp_carrier_street":"4011 ROLAND RD","insp_carrier_city":"KATY","insp_carrier_state":"TX","insp_carrier_zip_code":"77493-9701","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0193829","created_at":"2025-12-26T10:38:39.000000Z","updated_at":"2026-01-03T10:30:51.000000Z","inspection_violations":[{"id":17642170,"change_date":"2025-12-23 21:39:00","inspection_id":"86643878","insp_violation_id":"270877622","seq_no":"1","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"210784766","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-26T10:44:36.000000Z","updated_at":"2026-01-03T10:31:37.000000Z","normalized_code":"39360C"},{"id":17642171,"change_date":"2025-12-23 21:39:00","inspection_id":"86643878","insp_violation_id":"270877623","seq_no":"2","part_no":"396","part_no_section":"3A1B","insp_viol_unit":"1","insp_unit_id":"210784766","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-26T10:44:36.000000Z","updated_at":"2026-01-03T10:31:37.000000Z","normalized_code":"3963A1B"}],"inspection_per_units":[{"id":17598618,"change_date":"2025-12-23 21:39:00","inspection_id":"86643878","insp_unit_id":"210784766","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"4","insp_unit_license":"XKC8030","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDD49X3FJ445238","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-26T10:09:33.000000Z","updated_at":"2026-01-03T10:01:00.000000Z"}]},{"id":10219489,"change_date":"2025-11-17 21:40:00","inspection_id":"86341225","dot_number":"2174037","report_state":"TX","report_number":"7A779DBCBS","insp_date":"2025-11-04 00:00:00","insp_start_time":"0702","insp_end_time":"0716","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"23013  CLAY RD","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"MARTINEZ EXCAVATION","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-11-17 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"0","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":"9758441","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":"02174037","upload_search_indicator":"M","census_search_date":"2025-11-17 21:40:00","snet_input_date":"2025-11-04 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-11-17 21:40:00","insp_carrier_name":"ALFREDO MARTINEZ","insp_carrier_street":"4011 ROLAND RD","insp_carrier_city":"KATY","insp_carrier_state":"TX","insp_carrier_zip_code":"77493-9701","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0193829","created_at":"2025-11-20T10:30:37.000000Z","updated_at":"2025-11-21T10:31:02.000000Z","inspection_violations":[{"id":16984815,"change_date":"2025-11-17 21:40:00","inspection_id":"86341225","insp_violation_id":"270009902","seq_no":"1","part_no":"393","part_no_section":"95A","insp_viol_unit":"1","insp_unit_id":"210074950","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-20T10:31:03.000000Z","updated_at":"2025-11-21T10:31:44.000000Z","normalized_code":"39395A"},{"id":16984816,"change_date":"2025-11-17 21:40:00","inspection_id":"86341225","insp_violation_id":"270009903","seq_no":"2","part_no":"396","part_no_section":"17C","insp_viol_unit":"2","insp_unit_id":"210074951","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-20T10:31:03.000000Z","updated_at":"2025-11-21T10:31:44.000000Z","normalized_code":"39617C"},{"id":16984817,"change_date":"2025-11-17 21:40:00","inspection_id":"86341225","insp_violation_id":"270009904","seq_no":"3","part_no":"393","part_no_section":"209D","insp_viol_unit":"1","insp_unit_id":"210074950","insp_violation_category_id":"21","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-11-20T10:31:03.000000Z","updated_at":"2025-11-21T10:31:44.000000Z","normalized_code":"393209D"}],"inspection_per_units":[{"id":17025887,"change_date":"2025-11-17 21:40:00","inspection_id":"86341225","insp_unit_id":"210074950","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"7","insp_unit_license":"WMW1611","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDD49X6FJ445282","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-20T10:00:38.000000Z","updated_at":"2025-11-21T10:01:13.000000Z"},{"id":17025888,"change_date":"2025-11-17 21:40:00","inspection_id":"86341225","insp_unit_id":"210074951","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TEXS","insp_unit_company":"16","insp_unit_license":"118349M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"17XFW2529M1107920","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-20T10:00:38.000000Z","updated_at":"2025-11-21T10:01:13.000000Z"}]},{"id":9999576,"change_date":"2025-10-21 21:39:00","inspection_id":"86109702","dot_number":"2174037","report_state":"TX","report_number":"V252048461","insp_date":"2025-10-14 00:00:00","insp_start_time":"0810","insp_end_time":"0853","registration_date":null,"region":"CT","ci_status_code":"C","location":"2A701","location_desc":"IH45 NB NEW WAVERLY SCALE","county_code_state":"TX","county_code":"471","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"MARTINEZ","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-10-21 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"50000","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":"9732792","transaction_code":"A","transaction_date":"2025-10-21 00:00:00","upload_date":"2025-10-21 00:00:00","upload_first_byte":"0","upload_dot_number":"02174037","upload_search_indicator":"M","census_search_date":"2025-10-21 21:39:00","snet_input_date":"2025-10-14 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-10-21 21:39:00","insp_carrier_name":"ALFREDO MARTINEZ","insp_carrier_street":"4011 ROLAND RD","insp_carrier_city":"KATY","insp_carrier_state":"TX","insp_carrier_zip_code":"77493-9701","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0193829","created_at":"2025-10-24T10:01:58.000000Z","updated_at":"2025-10-25T10:01:03.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16606811,"change_date":"2025-10-21 21:39:00","inspection_id":"86109702","insp_unit_id":"209583010","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"137","insp_unit_license":"DKK9836","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDD29X7VR710215","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-24T09:47:09.000000Z","updated_at":"2025-10-25T09:46:14.000000Z"}]},{"id":9889577,"change_date":"2025-10-08 21:41:00","inspection_id":"85993497","dot_number":"2174037","report_state":"TX","report_number":"799C9DJW3G","insp_date":"2025-10-01 00:00:00","insp_start_time":"1241","insp_end_time":"1310","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"100  GLENBOUROUGH ST","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"RENNOVATED HOME","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-10-08 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":"9718556","transaction_code":"A","transaction_date":"2025-10-08 00:00:00","upload_date":"2025-10-08 00:00:00","upload_first_byte":"0","upload_dot_number":"02174037","upload_search_indicator":"M","census_search_date":"2025-10-08 21:41:00","snet_input_date":"2025-10-01 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-10-08 21:41:00","insp_carrier_name":"ALFREDO MARTINEZ","insp_carrier_street":"4011 ROLAND RD","insp_carrier_city":"KATY","insp_carrier_state":"TX","insp_carrier_zip_code":"77493-9701","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0193829","created_at":"2025-10-11T10:01:50.000000Z","updated_at":"2025-10-12T10:01:14.000000Z","inspection_violations":[{"id":16307485,"change_date":"2025-10-08 21:41:00","inspection_id":"85993497","insp_violation_id":"269181648","seq_no":"1","part_no":"393","part_no_section":"201D","insp_viol_unit":"1","insp_unit_id":"209367527","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-11T10:18:11.000000Z","updated_at":"2025-10-12T10:16:33.000000Z","normalized_code":"393201D"}],"inspection_per_units":[{"id":16408628,"change_date":"2025-10-08 21:41:00","inspection_id":"85993497","insp_unit_id":"209367527","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"HZT6481","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDD49X06J136231","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-11T09:47:15.000000Z","updated_at":"2025-10-12T09:46:34.000000Z"}]},{"id":9686882,"change_date":"2025-09-15 21:41:00","inspection_id":"85780937","dot_number":"2174037","report_state":"TX","report_number":"78PA9DBE3U","insp_date":"2025-09-11 00:00:00","insp_start_time":"1005","insp_end_time":"1050","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US-0290 IN HARRIS CO. (706-738","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"MARTINEZ EXCAVATION","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-15 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"0","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":"9695472","transaction_code":"A","transaction_date":"2025-09-15 00:00:00","upload_date":"2025-09-15 00:00:00","upload_first_byte":"0","upload_dot_number":"02174037","upload_search_indicator":"M","census_search_date":"2025-09-15 21:41:00","snet_input_date":"2025-09-11 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-09-15 21:41:00","insp_carrier_name":"ALFREDO MARTINEZ","insp_carrier_street":"4011 ROLAND RD","insp_carrier_city":"KATY","insp_carrier_state":"TX","insp_carrier_zip_code":"77493-9701","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0193829","created_at":"2025-09-18T10:00:40.000000Z","updated_at":"2025-09-18T10:00:40.000000Z","inspection_violations":[{"id":15886425,"change_date":"2025-09-15 21:41:00","inspection_id":"85780937","insp_violation_id":"268706429","seq_no":"2","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"208962852","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-18T10:21:01.000000Z","updated_at":"2025-09-18T10:21:01.000000Z","normalized_code":"39378"},{"id":15886426,"change_date":"2025-09-15 21:41:00","inspection_id":"85780937","insp_violation_id":"268706430","seq_no":"3","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"208962852","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-18T10:21:01.000000Z","updated_at":"2025-09-18T10:21:01.000000Z","normalized_code":"39378"}],"inspection_per_units":[{"id":16033219,"change_date":"2025-09-15 21:41:00","inspection_id":"85780937","insp_unit_id":"208962852","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"9","insp_unit_license":"GFF3635","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AK06Y26N010150","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-18T09:45:33.000000Z","updated_at":"2025-09-18T09:45:33.000000Z"}]},{"id":9605553,"change_date":"2025-09-05 21:39:00","inspection_id":"85695632","dot_number":"2174037","report_state":"TX","report_number":"78HF9DBZ1K","insp_date":"2025-09-03 00:00:00","insp_start_time":"1515","insp_end_time":"1556","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0010 IN HARRIS CO. (742-797","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":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-05 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"53200","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9687804","transaction_code":"A","transaction_date":"2025-09-05 00:00:00","upload_date":"2025-09-05 00:00:00","upload_first_byte":"0","upload_dot_number":"02174037","upload_search_indicator":"M","census_search_date":"2025-09-05 21:39:00","snet_input_date":"2025-09-03 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-09-05 21:39:00","insp_carrier_name":"ALFREDO MARTINEZ","insp_carrier_street":"4011 ROLAND RD","insp_carrier_city":"KATY","insp_carrier_state":"TX","insp_carrier_zip_code":"77493-9701","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0193829","created_at":"2025-09-10T10:45:49.000000Z","updated_at":"2025-09-10T10:45:49.000000Z","inspection_violations":[{"id":15703799,"change_date":"2025-09-05 21:39:00","inspection_id":"85695632","insp_violation_id":"268492506","seq_no":"1","part_no":"393","part_no_section":"83G","insp_viol_unit":"1","insp_unit_id":"208773647","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-10T10:48:42.000000Z","updated_at":"2025-09-10T10:48:42.000000Z","normalized_code":"39383G"},{"id":15703800,"change_date":"2025-09-05 21:39:00","inspection_id":"85695632","insp_violation_id":"268492507","seq_no":"2","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"208773647","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-10T10:48:42.000000Z","updated_at":"2025-09-10T10:48:42.000000Z","normalized_code":"39347E"},{"id":15703801,"change_date":"2025-09-05 21:39:00","inspection_id":"85695632","insp_violation_id":"268492508","seq_no":"3","part_no":"393","part_no_section":"53B","insp_viol_unit":"1","insp_unit_id":"208773647","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-10T10:48:42.000000Z","updated_at":"2025-09-10T10:48:42.000000Z","normalized_code":"39353B"}],"inspection_per_units":[{"id":15861253,"change_date":"2025-09-05 21:39:00","inspection_id":"85695632","insp_unit_id":"208773647","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"2","insp_unit_license":"JXX2199","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDD49XXFJ445284","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-10T09:46:30.000000Z","updated_at":"2025-09-10T09:46:30.000000Z"}]},{"id":9696874,"change_date":"2025-09-16 21:40:00","inspection_id":"85791257","dot_number":"2174037","report_state":"TX","report_number":"78HA9DATCK","insp_date":"2025-09-03 00:00:00","insp_start_time":"1046","insp_end_time":"1057","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"9300  SH 6","county_code_state":"TX","county_code":"157","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-09-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"54900","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":"9696854","transaction_code":"A","transaction_date":"2025-09-16 00:00:00","upload_date":"2025-09-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02174037","upload_search_indicator":"M","census_search_date":"2025-09-16 21:40:00","snet_input_date":"2025-09-03 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-09-16 21:40:00","insp_carrier_name":"ALFREDO MARTINEZ","insp_carrier_street":"4011 ROLAND RD","insp_carrier_city":"KATY","insp_carrier_state":"TX","insp_carrier_zip_code":"77493-9701","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0193829","created_at":"2025-09-18T10:01:02.000000Z","updated_at":"2025-09-23T10:01:10.000000Z","inspection_violations":[{"id":15909813,"change_date":"2025-09-16 21:40:00","inspection_id":"85791257","insp_violation_id":"268732991","seq_no":"1","part_no":"393","part_no_section":"83G","insp_viol_unit":"1","insp_unit_id":"208983022","insp_violation_category_id":"27","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-09-18T10:21:37.000000Z","updated_at":"2025-09-20T10:15:55.000000Z","normalized_code":"39383G"}],"inspection_per_units":[{"id":16051906,"change_date":"2025-09-16 21:40:00","inspection_id":"85791257","insp_unit_id":"208983022","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"HZT6481","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDD49X06J136231","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-18T09:45:43.000000Z","updated_at":"2025-09-20T09:45:33.000000Z"}]},{"id":9426204,"change_date":"2025-08-15 21:39:00","inspection_id":"85507039","dot_number":"2174037","report_state":"TX","report_number":"V251962397","insp_date":"2025-08-14 00:00:00","insp_start_time":"0710","insp_end_time":"0732","registration_date":null,"region":"CT","ci_status_code":"C","location":"2A201","location_desc":"IH10 WB SEALY SCALE","county_code_state":"TX","county_code":"015","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"NONE","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-08-15 21:39: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":"9666950","transaction_code":"A","transaction_date":"2025-08-15 00:00:00","upload_date":"2025-08-15 00:00:00","upload_first_byte":"0","upload_dot_number":"02174037","upload_search_indicator":"M","census_search_date":"2025-08-15 21:39:00","snet_input_date":"2025-08-14 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-08-15 21:39:00","insp_carrier_name":"ALFREDO MARTINEZ","insp_carrier_street":"4011 ROLAND RD","insp_carrier_city":"KATY","insp_carrier_state":"TX","insp_carrier_zip_code":"77493-9701","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0193829","created_at":"2025-08-20T10:44:41.000000Z","updated_at":"2025-08-20T10:44:41.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15539063,"change_date":"2025-08-15 21:39:00","inspection_id":"85507039","insp_unit_id":"208424985","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"5","insp_unit_license":"DKK9836","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDD29X7VR710215","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-18T09:46:33.000000Z","updated_at":"2025-08-19T09:46:02.000000Z"}]},{"id":9250872,"change_date":"2025-07-25 21:40:00","inspection_id":"85322669","dot_number":"2174037","report_state":"TX","report_number":"V251950727","insp_date":"2025-07-22 00:00:00","insp_start_time":"1300","insp_end_time":"1353","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"18456 TX6 SB SVC RD","county_code_state":"TX","county_code":"041","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"NONE","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-07-25 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9648376","transaction_code":"A","transaction_date":"2025-07-25 00:00:00","upload_date":"2025-07-25 00:00:00","upload_first_byte":"0","upload_dot_number":"02174037","upload_search_indicator":"M","census_search_date":"2025-07-25 21:40:00","snet_input_date":"2025-07-22 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-07-25 21:40:00","insp_carrier_name":"ALFREDO MARTINEZ","insp_carrier_street":"4011 ROLAND RD","insp_carrier_city":"KATY","insp_carrier_state":"TX","insp_carrier_zip_code":"77493-9701","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0193829","created_at":"2025-07-30T10:01:23.000000Z","updated_at":"2025-07-30T10:01:23.000000Z","inspection_violations":[{"id":14982105,"change_date":"2025-07-25 21:40:00","inspection_id":"85322669","insp_violation_id":"267659976","seq_no":"1","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"208085907","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-28T10:49:49.000000Z","updated_at":"2025-07-29T10:43:42.000000Z","normalized_code":"39347E"},{"id":14982106,"change_date":"2025-07-25 21:40:00","inspection_id":"85322669","insp_violation_id":"267659977","seq_no":"2","part_no":"393","part_no_section":"53B","insp_viol_unit":"1","insp_unit_id":"208085907","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-28T10:49:49.000000Z","updated_at":"2025-07-29T10:43:42.000000Z","normalized_code":"39353B"},{"id":14982107,"change_date":"2025-07-25 21:40:00","inspection_id":"85322669","insp_violation_id":"267659978","seq_no":"3","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"208085907","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-28T10:49:49.000000Z","updated_at":"2025-07-29T10:43:42.000000Z","normalized_code":"39378"}],"inspection_per_units":[{"id":15224498,"change_date":"2025-07-25 21:40:00","inspection_id":"85322669","insp_unit_id":"208085907","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"9","insp_unit_license":"GFF3635","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AK06Y26N010150","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-28T09:46:36.000000Z","updated_at":"2025-07-29T09:46:04.000000Z"}]},{"id":8964313,"change_date":"2025-06-23 21:41:00","inspection_id":"85021232","dot_number":"2174037","report_state":"TX","report_number":"76B69DBC39","insp_date":"2025-06-17 00:00:00","insp_start_time":"0657","insp_end_time":"0749","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0099 IN HARRIS CO. (698-750","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"MARTINEZ EXCAVATION (YARD)","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-06-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"0","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":"9613213","transaction_code":"A","transaction_date":"2025-06-23 00:00:00","upload_date":"2025-06-23 00:00:00","upload_first_byte":"0","upload_dot_number":"02174037","upload_search_indicator":"M","census_search_date":"2025-06-23 21:41:00","snet_input_date":"2025-06-17 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-06-23 21:41:00","insp_carrier_name":"ALFREDO MARTINEZ","insp_carrier_street":"4011 ROLAND RD","insp_carrier_city":"KATY","insp_carrier_state":"TX","insp_carrier_zip_code":"77493-9701","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0193829","created_at":"2025-06-28T10:00:38.000000Z","updated_at":"2025-06-28T10:00:38.000000Z","inspection_violations":[{"id":14398738,"change_date":"2025-06-23 21:41:00","inspection_id":"85021232","insp_violation_id":"266993050","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"207513126","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-26T10:16:03.000000Z","updated_at":"2025-06-27T10:18:08.000000Z","normalized_code":"39378"},{"id":14398739,"change_date":"2025-06-23 21:41:00","inspection_id":"85021232","insp_violation_id":"266993051","seq_no":"2","part_no":"393","part_no_section":"9TS","insp_viol_unit":"1","insp_unit_id":"207513126","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-26T10:16:03.000000Z","updated_at":"2025-06-27T10:18:08.000000Z","normalized_code":"3939TS"},{"id":14398740,"change_date":"2025-06-23 21:41:00","inspection_id":"85021232","insp_violation_id":"266993052","seq_no":"3","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"207513126","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-26T10:16:03.000000Z","updated_at":"2025-06-27T10:18:08.000000Z","normalized_code":"39311"},{"id":14398741,"change_date":"2025-06-23 21:41:00","inspection_id":"85021232","insp_violation_id":"266993053","seq_no":"4","part_no":"393","part_no_section":"55D1","insp_viol_unit":"1","insp_unit_id":"207513126","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-26T10:16:03.000000Z","updated_at":"2025-06-27T10:18:08.000000Z","normalized_code":"39355D1"},{"id":14398742,"change_date":"2025-06-23 21:41:00","inspection_id":"85021232","insp_violation_id":"266993054","seq_no":"5","part_no":"393","part_no_section":"9TS","insp_viol_unit":"1","insp_unit_id":"207513126","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-06-26T10:16:03.000000Z","updated_at":"2025-06-27T10:18:08.000000Z","normalized_code":"3939TS"},{"id":14398743,"change_date":"2025-06-23 21:41:00","inspection_id":"85021232","insp_violation_id":"266993055","seq_no":"6","part_no":"392","part_no_section":"2WC","insp_viol_unit":"1","insp_unit_id":"207513126","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-26T10:16:03.000000Z","updated_at":"2025-06-27T10:18:08.000000Z","normalized_code":"3922WC"},{"id":14398744,"change_date":"2025-06-23 21:41:00","inspection_id":"85021232","insp_violation_id":"266993056","seq_no":"7","part_no":"393","part_no_section":"203","insp_viol_unit":"1","insp_unit_id":"207513126","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-26T10:16:03.000000Z","updated_at":"2025-06-27T10:18:08.000000Z","normalized_code":"393203"}],"inspection_per_units":[{"id":14695219,"change_date":"2025-06-23 21:41:00","inspection_id":"85021232","insp_unit_id":"207513126","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"9","insp_unit_license":"GFF3635","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AK06Y26N010150","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-26T09:45:40.000000Z","updated_at":"2025-06-27T09:46:18.000000Z"}]},{"id":8923232,"change_date":"2025-06-17 21:42:00","inspection_id":"84977459","dot_number":"2174037","report_state":"TX","report_number":"V251913117","insp_date":"2025-06-16 00:00:00","insp_start_time":"0745","insp_end_time":"0813","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US 290 AT KICKAPOO R","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"MARTINEZ EXCAVATION","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-06-17 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"50000","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9609202","transaction_code":"A","transaction_date":"2025-06-17 00:00:00","upload_date":"2025-06-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02174037","upload_search_indicator":"M","census_search_date":"2025-06-17 21:42:00","snet_input_date":"2025-06-16 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-06-17 21:42:00","insp_carrier_name":"ALFREDO MARTINEZ","insp_carrier_street":"4011 ROLAND RD","insp_carrier_city":"KATY","insp_carrier_state":"TX","insp_carrier_zip_code":"77493-9701","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0193829","created_at":"2025-06-20T10:00:59.000000Z","updated_at":"2025-06-22T10:00:49.000000Z","inspection_violations":[{"id":14316069,"change_date":"2025-06-17 21:42:00","inspection_id":"84977459","insp_violation_id":"266899594","seq_no":"1","part_no":"393","part_no_section":"75A1","insp_viol_unit":"1","insp_unit_id":"207433630","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-20T10:16:47.000000Z","updated_at":"2025-06-21T10:18:05.000000Z","normalized_code":"39375A1"},{"id":14316070,"change_date":"2025-06-17 21:42:00","inspection_id":"84977459","insp_violation_id":"266899595","seq_no":"2","part_no":"393","part_no_section":"75A1","insp_viol_unit":"1","insp_unit_id":"207433630","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-20T10:16:47.000000Z","updated_at":"2025-06-21T10:18:05.000000Z","normalized_code":"39375A1"},{"id":14316071,"change_date":"2025-06-17 21:42:00","inspection_id":"84977459","insp_violation_id":"266899596","seq_no":"3","part_no":"393","part_no_section":"95B","insp_viol_unit":"1","insp_unit_id":"207433630","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-20T10:16:47.000000Z","updated_at":"2025-06-21T10:18:05.000000Z","normalized_code":"39395B"}],"inspection_per_units":[{"id":14622613,"change_date":"2025-06-17 21:42:00","inspection_id":"84977459","insp_unit_id":"207433630","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"137","insp_unit_license":"DKK9836","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDD29X7VR710215","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-20T09:46:08.000000Z","updated_at":"2025-06-22T09:46:08.000000Z"}]},{"id":8691006,"change_date":"2025-05-20 21:41:00","inspection_id":"84731312","dot_number":"2174037","report_state":"TX","report_number":"V251850552","insp_date":"2025-05-14 00:00:00","insp_start_time":"0804","insp_end_time":"0828","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"602M TX6 NB SVC RD","county_code_state":"TX","county_code":"041","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"XX","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-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"78700","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":"9584353","transaction_code":"A","transaction_date":"2025-05-20 00:00:00","upload_date":"2025-05-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02174037","upload_search_indicator":"M","census_search_date":"2025-05-20 21:41:00","snet_input_date":"2025-05-14 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-05-20 21:41:00","insp_carrier_name":"ALFREDO MARTINEZ","insp_carrier_street":"4011 ROLAND RD","insp_carrier_city":"KATY","insp_carrier_state":"TX","insp_carrier_zip_code":"77493-9701","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0193829","created_at":"2025-05-23T10:04:24.000000Z","updated_at":"2025-05-24T10:06:03.000000Z","inspection_violations":[{"id":13848662,"change_date":"2025-05-20 21:41:00","inspection_id":"84731312","insp_violation_id":"266357934","seq_no":"1","part_no":"393","part_no_section":"45B2UV","insp_viol_unit":"1","insp_unit_id":"206971087","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-05-23T10:37:21.000000Z","updated_at":"2025-05-24T10:26:55.000000Z","normalized_code":"39345B2UV"}],"inspection_per_units":[{"id":14200305,"change_date":"2025-05-20 21:41:00","inspection_id":"84731312","insp_unit_id":"206971087","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"4","insp_unit_license":"JXX2023","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDD49X3FJ445238","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-23T09:49:17.000000Z","updated_at":"2025-05-24T09:51:34.000000Z"},{"id":14200306,"change_date":"2025-05-20 21:41:00","inspection_id":"84731312","insp_unit_id":"206971088","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"ECON","insp_unit_company":null,"insp_unit_license":"670339K","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"42EDPKK21F1000557","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-23T09:49:17.000000Z","updated_at":"2025-05-24T09:51:34.000000Z"}]},{"id":7686100,"change_date":"2025-01-22 21:39:00","inspection_id":"83674154","dot_number":"2174037","report_state":"TX","report_number":"721C9DBVYG","insp_date":"2025-01-14 00:00:00","insp_start_time":"1220","insp_end_time":"1245","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"2100  REED RD","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-01-22 21:39: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":"9480525","transaction_code":"A","transaction_date":"2025-01-22 00:00:00","upload_date":"2025-01-22 00:00:00","upload_first_byte":"0","upload_dot_number":"02174037","upload_search_indicator":"M","census_search_date":"2025-01-22 21:39:00","snet_input_date":"2025-01-14 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-01-22 21:39:00","insp_carrier_name":"ALFREDO MARTINEZ","insp_carrier_street":"4011 ROLAND RD","insp_carrier_city":"KATY","insp_carrier_state":"TX","insp_carrier_zip_code":"77493-9701","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0193829","created_at":"2025-03-17T20:57:53.000000Z","updated_at":"2025-03-17T20:57:53.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12402619,"change_date":"2025-01-22 21:39:00","inspection_id":"83674154","insp_unit_id":"204961677","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"8","insp_unit_license":"MPR7697","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDD49X99J246876","insp_unit_decal":"Y","insp_unit_decal_number":"34868458","created_at":"2025-03-17T23:51:52.000000Z","updated_at":"2025-03-17T23:51:52.000000Z"}]},{"id":7630148,"change_date":"2025-01-15 21:42:00","inspection_id":"83615396","dot_number":"2174037","report_state":"TX","report_number":"V251749226","insp_date":"2025-01-08 00:00:00","insp_start_time":"1046","insp_end_time":"1056","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"MCCALEB\/ FM 2854","county_code_state":"TX","county_code":"339","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"MARTINEZ EXCAVATION","shipping_paper_number":"NULL","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-01-15 21:42: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":"9474197","transaction_code":"A","transaction_date":"2025-01-15 00:00:00","upload_date":"2025-01-15 00:00:00","upload_first_byte":"0","upload_dot_number":"02174037","upload_search_indicator":"M","census_search_date":"2025-01-15 21:42:00","snet_input_date":"2025-01-08 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-01-15 21:42:00","insp_carrier_name":"ALFREDO MARTINEZ","insp_carrier_street":"4011 ROLAND RD","insp_carrier_city":"KATY","insp_carrier_state":"TX","insp_carrier_zip_code":"77493-9701","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0193829","created_at":"2025-03-17T20:56:32.000000Z","updated_at":"2025-03-17T20:56:32.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12311772,"change_date":"2025-01-15 21:42:00","inspection_id":"83615396","insp_unit_id":"204855368","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"0","insp_unit_license":"MPR7697","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDD49X99J246876","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:50:53.000000Z","updated_at":"2025-03-17T23:50:53.000000Z"}]},{"id":7392771,"change_date":"2024-12-13 21:41:00","inspection_id":"83366131","dot_number":"2174037","report_state":"TX","report_number":"70NB9DCGJ2","insp_date":"2024-11-25 00:00:00","insp_start_time":"1056","insp_end_time":"1135","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"2000  REED RD","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-12-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"48000","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":"9444174","transaction_code":"C","transaction_date":"2024-12-13 00:00:00","upload_date":"2024-12-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02174037","upload_search_indicator":"M","census_search_date":"2024-12-11 21:41:00","snet_input_date":"2024-11-25 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-12-11 21:41:00","insp_carrier_name":"ALFREDO MARTINEZ","insp_carrier_street":"4011 ROLAND RD","insp_carrier_city":"KATY","insp_carrier_state":"TX","insp_carrier_zip_code":"77493-9701","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0193829","created_at":"2025-03-17T20:50:19.000000Z","updated_at":"2025-03-17T20:50:19.000000Z","inspection_violations":[{"id":11549089,"change_date":"2024-12-13 21:41:00","inspection_id":"83366131","insp_violation_id":"263452067","seq_no":"2","part_no":"393","part_no_section":"45UV","insp_viol_unit":"1","insp_unit_id":"204375233","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:02:13.000000Z","updated_at":"2025-03-17T22:02:13.000000Z","normalized_code":"39345UV"}],"inspection_per_units":[{"id":11925792,"change_date":"2024-12-13 21:41:00","inspection_id":"83366131","insp_unit_id":"204375233","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"PXJ7296","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDDR9X8XJ795849","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:46:41.000000Z","updated_at":"2025-03-17T23:46:41.000000Z"}]},{"id":7231294,"change_date":"2024-11-19 21:41:00","inspection_id":"83195974","dot_number":"2174037","report_state":"TX","report_number":"6ZRE9DAX59","insp_date":"2024-10-24 00:00:00","insp_start_time":"1405","insp_end_time":"1500","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"800 W MAIN ST","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"MARTINEZ EXCAVATION","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-11-19 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"0","viol_total":"14","oos_total":"5","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"14","vehicle_oos_total":"5","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9431106","transaction_code":"A","transaction_date":"2024-11-19 00:00:00","upload_date":"2024-11-19 00:00:00","upload_first_byte":"0","upload_dot_number":"02174037","upload_search_indicator":"M","census_search_date":"2024-11-19 21:41:00","snet_input_date":"2024-10-24 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-11-19 21:41:00","insp_carrier_name":"ALFREDO MARTINEZ","insp_carrier_street":"4011 ROLAND RD","insp_carrier_city":"KATY","insp_carrier_state":"TX","insp_carrier_zip_code":"77493-9701","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0193829","created_at":"2025-03-17T20:46:50.000000Z","updated_at":"2025-03-17T20:46:50.000000Z","inspection_violations":[{"id":11304097,"change_date":"2024-11-19 21:41:00","inspection_id":"83195974","insp_violation_id":"262982036","seq_no":"1","part_no":"390","part_no_section":"21(a)","insp_viol_unit":"1","insp_unit_id":"203956648","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:55.000000Z","updated_at":"2025-03-17T22:00:55.000000Z","normalized_code":"39021A"},{"id":11304098,"change_date":"2024-11-19 21:41:00","inspection_id":"83195974","insp_violation_id":"262982037","seq_no":"2","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"203956648","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:55.000000Z","updated_at":"2025-03-17T22:00:55.000000Z","normalized_code":"3939"},{"id":11304099,"change_date":"2024-11-19 21:41:00","inspection_id":"83195974","insp_violation_id":"262982038","seq_no":"4","part_no":"393","part_no_section":"110B","insp_viol_unit":"2","insp_unit_id":"203956649","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:00:55.000000Z","updated_at":"2025-03-17T22:00:55.000000Z","normalized_code":"393110B"},{"id":11304100,"change_date":"2024-11-19 21:41:00","inspection_id":"83195974","insp_violation_id":"262982039","seq_no":"5","part_no":"393","part_no_section":"104F3","insp_viol_unit":"2","insp_unit_id":"203956649","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:55.000000Z","updated_at":"2025-03-17T22:00:55.000000Z","normalized_code":"393104F3"},{"id":11304101,"change_date":"2024-11-19 21:41:00","inspection_id":"83195974","insp_violation_id":"262982040","seq_no":"6","part_no":"393","part_no_section":"130","insp_viol_unit":"2","insp_unit_id":"203956649","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:00:55.000000Z","updated_at":"2025-03-17T22:00:55.000000Z","normalized_code":"393130"},{"id":11304102,"change_date":"2024-11-19 21:41:00","inspection_id":"83195974","insp_violation_id":"262982041","seq_no":"7","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"203956649","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:55.000000Z","updated_at":"2025-03-17T22:00:55.000000Z","normalized_code":"3939"},{"id":11304103,"change_date":"2024-11-19 21:41:00","inspection_id":"83195974","insp_violation_id":"262982042","seq_no":"13","part_no":"396","part_no_section":"3A1BOS","insp_viol_unit":"1","insp_unit_id":"203956648","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:00:55.000000Z","updated_at":"2025-03-17T22:00:55.000000Z","normalized_code":"3963A1BOS"},{"id":11304104,"change_date":"2024-11-19 21:41:00","inspection_id":"83195974","insp_violation_id":"262982043","seq_no":"14","part_no":"392","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"203956649","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T22:00:55.000000Z","updated_at":"2025-03-17T22:00:55.000000Z","normalized_code":"3929"},{"id":11304105,"change_date":"2024-11-19 21:41:00","inspection_id":"83195974","insp_violation_id":"262982044","seq_no":"15","part_no":"396","part_no_section":"17C","insp_viol_unit":"2","insp_unit_id":"203956649","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:55.000000Z","updated_at":"2025-03-17T22:00:55.000000Z","normalized_code":"39617C"},{"id":11304106,"change_date":"2024-11-19 21:41:00","inspection_id":"83195974","insp_violation_id":"262982045","seq_no":"8","part_no":"393","part_no_section":"43D","insp_viol_unit":"2","insp_unit_id":"203956649","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:00:55.000000Z","updated_at":"2025-03-17T22:00:55.000000Z","normalized_code":"39343D"},{"id":11304107,"change_date":"2024-11-19 21:41:00","inspection_id":"83195974","insp_violation_id":"262982046","seq_no":"9","part_no":"393","part_no_section":"48A","insp_viol_unit":"2","insp_unit_id":"203956649","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:55.000000Z","updated_at":"2025-03-17T22:00:55.000000Z","normalized_code":"39348A"},{"id":11304108,"change_date":"2024-11-19 21:41:00","inspection_id":"83195974","insp_violation_id":"262982047","seq_no":"10","part_no":"393","part_no_section":"48A","insp_viol_unit":"2","insp_unit_id":"203956649","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:55.000000Z","updated_at":"2025-03-17T22:00:55.000000Z","normalized_code":"39348A"},{"id":11304109,"change_date":"2024-11-19 21:41:00","inspection_id":"83195974","insp_violation_id":"262982048","seq_no":"11","part_no":"393","part_no_section":"48A","insp_viol_unit":"2","insp_unit_id":"203956649","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:55.000000Z","updated_at":"2025-03-17T22:00:55.000000Z","normalized_code":"39348A"},{"id":11304110,"change_date":"2024-11-19 21:41:00","inspection_id":"83195974","insp_violation_id":"262982049","seq_no":"12","part_no":"393","part_no_section":"48A","insp_viol_unit":"2","insp_unit_id":"203956649","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:00:55.000000Z","updated_at":"2025-03-17T22:00:55.000000Z","normalized_code":"39348A"}],"inspection_per_units":[{"id":11663974,"change_date":"2024-11-19 21:41:00","inspection_id":"83195974","insp_unit_id":"203956648","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"1","insp_unit_license":"RMY3790","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDD79X0DJ362705","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:43:52.000000Z","updated_at":"2025-03-17T23:43:52.000000Z"},{"id":11663975,"change_date":"2024-11-19 21:41:00","inspection_id":"83195974","insp_unit_id":"203956649","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIGT","insp_unit_company":"4","insp_unit_license":"955869H","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"16VHX2022E2623258","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:43:52.000000Z","updated_at":"2025-03-17T23:43:52.000000Z"}]},{"id":6781947,"change_date":"2024-09-20 21:43:00","inspection_id":"82719203","dot_number":"2174037","report_state":"TX","report_number":"6YJA9DAWGI","insp_date":"2024-09-10 00:00:00","insp_start_time":"1001","insp_end_time":"1017","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"2600 W PARKWOOD AVE","county_code_state":"TX","county_code":"167","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-09-20 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"48000","viol_total":"6","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9382452","transaction_code":"A","transaction_date":"2024-09-20 00:00:00","upload_date":"2024-09-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02174037","upload_search_indicator":"M","census_search_date":"2024-09-20 21:43:00","snet_input_date":"2024-09-10 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-09-20 21:43:00","insp_carrier_name":"ALFREDO MARTINEZ","insp_carrier_street":"4011 ROLAND RD","insp_carrier_city":"KATY","insp_carrier_state":"TX","insp_carrier_zip_code":"77493-9701","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0193829","created_at":"2025-03-17T20:37:42.000000Z","updated_at":"2025-03-17T20:37:42.000000Z","inspection_violations":[{"id":10561676,"change_date":"2024-09-20 21:43:00","inspection_id":"82719203","insp_violation_id":"261954115","seq_no":"1","part_no":"393","part_no_section":"203(c)","insp_viol_unit":"1","insp_unit_id":"203056330","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:10.000000Z","updated_at":"2025-03-17T21:57:10.000000Z","normalized_code":"393203C"},{"id":10561677,"change_date":"2024-09-20 21:43:00","inspection_id":"82719203","insp_violation_id":"261954116","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"203056330","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:10.000000Z","updated_at":"2025-03-17T21:57:10.000000Z","normalized_code":"3939A"},{"id":10561678,"change_date":"2024-09-20 21:43:00","inspection_id":"82719203","insp_violation_id":"261954117","seq_no":"3","part_no":"393","part_no_section":"47(a)","insp_viol_unit":"1","insp_unit_id":"203056330","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:57:10.000000Z","updated_at":"2025-03-17T21:57:10.000000Z","normalized_code":"39347A"},{"id":10561679,"change_date":"2024-09-20 21:43:00","inspection_id":"82719203","insp_violation_id":"261954118","seq_no":"4","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"203056330","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:10.000000Z","updated_at":"2025-03-17T21:57:10.000000Z","normalized_code":"3965B"},{"id":10561680,"change_date":"2024-09-20 21:43:00","inspection_id":"82719203","insp_violation_id":"261954119","seq_no":"5","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"203056330","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:10.000000Z","updated_at":"2025-03-17T21:57:10.000000Z","normalized_code":"39617C"},{"id":10561681,"change_date":"2024-09-20 21:43:00","inspection_id":"82719203","insp_violation_id":"261954120","seq_no":"6","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"203056330","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:10.000000Z","updated_at":"2025-03-17T21:57:10.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10936464,"change_date":"2024-09-20 21:43:00","inspection_id":"82719203","insp_unit_id":"203056330","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"PXJ7296","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDDR9X8XJ795849","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:18.000000Z","updated_at":"2025-03-17T23:36:18.000000Z"}]},{"id":6405757,"change_date":"2024-08-06 21:44:00","inspection_id":"82318083","dot_number":"2174037","report_state":"TX","report_number":"V241455885","insp_date":"2024-07-31 00:00:00","insp_start_time":"0830","insp_end_time":"0912","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"28718  TX6 NB","county_code_state":"TX","county_code":"473","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"PRIVATE RESIDENCE","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-08-06 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"78700","viol_total":"7","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9343100","transaction_code":"A","transaction_date":"2024-08-06 00:00:00","upload_date":"2024-08-06 00:00:00","upload_first_byte":"0","upload_dot_number":"02174037","upload_search_indicator":"M","census_search_date":"2024-08-06 21:44:00","snet_input_date":"2024-07-31 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-08-06 21:44:00","insp_carrier_name":"ALFREDO MARTINEZ","insp_carrier_street":"4011 ROLAND RD","insp_carrier_city":"KATY","insp_carrier_state":"TX","insp_carrier_zip_code":"77493-9701","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0193829","created_at":"2025-03-17T20:29:52.000000Z","updated_at":"2025-03-17T20:29:52.000000Z","inspection_violations":[{"id":9944645,"change_date":"2024-08-06 21:44:00","inspection_id":"82318083","insp_violation_id":"261050132","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"202266554","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:07.000000Z","updated_at":"2025-03-17T21:54:07.000000Z","normalized_code":"3939A"},{"id":9944646,"change_date":"2024-08-06 21:44:00","inspection_id":"82318083","insp_violation_id":"261050133","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"202266554","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:07.000000Z","updated_at":"2025-03-17T21:54:07.000000Z","normalized_code":"3939A"},{"id":9944647,"change_date":"2024-08-06 21:44:00","inspection_id":"82318083","insp_violation_id":"261050134","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"202266554","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:54:07.000000Z","updated_at":"2025-03-17T21:54:07.000000Z","normalized_code":"3939A"},{"id":9944648,"change_date":"2024-08-06 21:44:00","inspection_id":"82318083","insp_violation_id":"261050135","seq_no":"4","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"202266553","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:07.000000Z","updated_at":"2025-03-17T21:54:07.000000Z","normalized_code":"3963A1"},{"id":9944649,"change_date":"2024-08-06 21:44:00","inspection_id":"82318083","insp_violation_id":"261050136","seq_no":"5","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"202266553","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:07.000000Z","updated_at":"2025-03-17T21:54:07.000000Z","normalized_code":"3963A1"},{"id":9944650,"change_date":"2024-08-06 21:44:00","inspection_id":"82318083","insp_violation_id":"261050137","seq_no":"6","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"202266553","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:54:07.000000Z","updated_at":"2025-03-17T21:54:07.000000Z","normalized_code":"3963A1"},{"id":9944651,"change_date":"2024-08-06 21:44:00","inspection_id":"82318083","insp_violation_id":"261050138","seq_no":"7","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"202266553","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:54:07.000000Z","updated_at":"2025-03-17T21:54:07.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":10323541,"change_date":"2024-08-06 21:44:00","inspection_id":"82318083","insp_unit_id":"202266553","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"3","insp_unit_license":"JXX2357","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDD49X8FJ445249","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:29:59.000000Z","updated_at":"2025-03-17T23:29:59.000000Z"},{"id":10323542,"change_date":"2024-08-06 21:44:00","inspection_id":"82318083","insp_unit_id":"202266554","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"ECON","insp_unit_company":"12","insp_unit_license":"670339K","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"42EDPKK21F1000557","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:29:59.000000Z","updated_at":"2025-03-17T23:29:59.000000Z"}]},{"id":5589195,"change_date":"2025-08-08 21:40:00","inspection_id":"81436215","dot_number":"2174037","report_state":"TX","report_number":"V241402436","insp_date":"2024-04-23 00:00:00","insp_start_time":"1131","insp_end_time":"1157","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"TX36 NB","county_code_state":"TX","county_code":"015","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"HALLETTE MATERIALS","shipping_paper_number":"1037720","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-04-24 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"4","oos_total":"3","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"3","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9256794","transaction_code":"C","transaction_date":"2025-08-08 00:00:00","upload_date":"2025-08-08 00:00:00","upload_first_byte":"0","upload_dot_number":"02174037","upload_search_indicator":"M","census_search_date":"2024-04-24 21:42:00","snet_input_date":"2024-04-23 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-04-24 21:42:00","insp_carrier_name":"ALFREDO MARTINEZ","insp_carrier_street":"4011 ROLAND RD","insp_carrier_city":"KATY","insp_carrier_state":"TX","insp_carrier_zip_code":"77493-9701","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0193829","created_at":"2025-03-17T20:13:30.000000Z","updated_at":"2025-08-12T10:44:15.000000Z","inspection_violations":[{"id":15213546,"change_date":"2025-08-08 21:40:00","inspection_id":"81436215","insp_violation_id":"267922685","seq_no":"1","part_no":"383","part_no_section":"23A2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-11T10:45:31.000000Z","updated_at":"2025-08-12T10:45:35.000000Z","normalized_code":"38323A2"},{"id":15213547,"change_date":"2025-08-08 21:40:00","inspection_id":"81436215","insp_violation_id":"267922686","seq_no":"2","part_no":"393","part_no_section":"45DLUV","insp_viol_unit":"1","insp_unit_id":"208308536","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-11T10:45:31.000000Z","updated_at":"2025-08-12T10:45:35.000000Z","normalized_code":"39345DLUV"},{"id":15213548,"change_date":"2025-08-08 21:40:00","inspection_id":"81436215","insp_violation_id":"267922687","seq_no":"3","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"208308536","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-08-11T10:45:31.000000Z","updated_at":"2025-08-12T10:45:35.000000Z","normalized_code":"3939"},{"id":15213549,"change_date":"2025-08-08 21:40:00","inspection_id":"81436215","insp_violation_id":"267922688","seq_no":"4","part_no":"396","part_no_section":"3A1BL","insp_viol_unit":"1","insp_unit_id":"208308536","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-08-11T10:45:31.000000Z","updated_at":"2025-08-12T10:45:35.000000Z","normalized_code":"3963A1BL"}],"inspection_per_units":[{"id":15429655,"change_date":"2025-08-08 21:40:00","inspection_id":"81436215","insp_unit_id":"208308536","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"9","insp_unit_license":"GFF3635","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AK06Y26N010150","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-11T09:46:27.000000Z","updated_at":"2025-08-12T09:46:03.000000Z"}]},{"id":5400668,"change_date":"2024-03-29 21:38:00","inspection_id":"81230206","dot_number":"2174037","report_state":"TX","report_number":"6TRA9DNA1O","insp_date":"2024-03-22 00:00:00","insp_start_time":"0915","insp_end_time":"1000","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"5000  E. THIRD ST","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"MARTIN MARIETTA","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-03-29 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"0","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":"9234827","transaction_code":"A","transaction_date":"2024-03-29 00:00:00","upload_date":"2024-03-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02174037","upload_search_indicator":"M","census_search_date":"2024-03-29 21:38:00","snet_input_date":"2024-03-22 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-03-29 21:38:00","insp_carrier_name":"ALFREDO MARTINEZ","insp_carrier_street":"4011 ROLAND RD","insp_carrier_city":"KATY","insp_carrier_state":"TX","insp_carrier_zip_code":"77493-9701","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0193829","created_at":"2025-03-17T20:09:49.000000Z","updated_at":"2025-03-17T20:09:49.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8698208,"change_date":"2024-03-29 21:38:00","inspection_id":"81230206","insp_unit_id":"200159001","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"13105","insp_unit_license":"RMY3790","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDD79X0DJ362705","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:13:54.000000Z","updated_at":"2025-03-17T23:13:54.000000Z"}]},{"id":5320437,"change_date":"2024-03-19 21:45:00","inspection_id":"81143137","dot_number":"2174037","report_state":"TX","report_number":"V241348965","insp_date":"2024-03-12 00:00:00","insp_start_time":"0823","insp_end_time":"0853","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"LAT:30   31' 28.86N","county_code_state":"TX","county_code":"471","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"MARTINEZ","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-03-19 21:45: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":"9226798","transaction_code":"A","transaction_date":"2024-03-19 00:00:00","upload_date":"2024-03-19 00:00:00","upload_first_byte":"0","upload_dot_number":"02174037","upload_search_indicator":"M","census_search_date":"2024-03-19 21:45:00","snet_input_date":"2024-03-12 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-03-19 21:45:00","insp_carrier_name":"ALFREDO MARTINEZ","insp_carrier_street":"4011 ROLAND RD","insp_carrier_city":"KATY","insp_carrier_state":"TX","insp_carrier_zip_code":"77493-9701","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0193829","created_at":"2025-03-17T20:08:14.000000Z","updated_at":"2025-03-17T20:08:14.000000Z","inspection_violations":[{"id":8209943,"change_date":"2024-03-19 21:45:00","inspection_id":"81143137","insp_violation_id":"258470334","seq_no":"1","part_no":"393","part_no_section":"209(d)","insp_viol_unit":"1","insp_unit_id":"199987374","insp_violation_category_id":"21","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:45:42.000000Z","updated_at":"2025-03-17T21:45:42.000000Z","normalized_code":"393209D"}],"inspection_per_units":[{"id":8568692,"change_date":"2024-03-19 21:45:00","inspection_id":"81143137","insp_unit_id":"199987374","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"8","insp_unit_license":"MPR7697","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDD49X99J246876","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:12:39.000000Z","updated_at":"2025-03-17T23:12:39.000000Z"}]},{"id":5217312,"change_date":"2024-03-06 21:40:00","inspection_id":"81030260","dot_number":"2174037","report_state":"TX","report_number":"6T5G9DCEL2","insp_date":"2024-02-29 00:00:00","insp_start_time":"1641","insp_end_time":"1655","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"2700 W LOOP 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":"2024-03-05 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9214266","transaction_code":"C","transaction_date":"2024-03-06 00:00:00","upload_date":"2024-03-06 00:00:00","upload_first_byte":"0","upload_dot_number":"02174037","upload_search_indicator":"M","census_search_date":"2024-03-05 21:41:00","snet_input_date":"2024-02-29 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-03-05 21:41:00","insp_carrier_name":"ALFREDO MARTINEZ","insp_carrier_street":"4011 ROLAND RD","insp_carrier_city":"KATY","insp_carrier_state":"TX","insp_carrier_zip_code":"77493-9701","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0193829","created_at":"2025-03-17T20:05:48.000000Z","updated_at":"2025-03-17T20:05:48.000000Z","inspection_violations":[{"id":8040555,"change_date":"2024-03-06 21:40:00","inspection_id":"81030260","insp_violation_id":"258241561","seq_no":"1","part_no":"393","part_no_section":"55(d)(1)","insp_viol_unit":"1","insp_unit_id":"199788292","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:53.000000Z","updated_at":"2025-03-17T21:44:53.000000Z","normalized_code":"39355D1"},{"id":8040556,"change_date":"2024-03-06 21:40:00","inspection_id":"81030260","insp_violation_id":"258241562","seq_no":"2","part_no":"393","part_no_section":"203(c)","insp_viol_unit":"1","insp_unit_id":"199788292","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:53.000000Z","updated_at":"2025-03-17T21:44:53.000000Z","normalized_code":"393203C"}],"inspection_per_units":[{"id":8401304,"change_date":"2024-03-06 21:40:00","inspection_id":"81030260","insp_unit_id":"199788292","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"1","insp_unit_license":"RMY3790","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDD79X0DJ362705","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:08.000000Z","updated_at":"2025-03-17T23:11:08.000000Z"}]},{"id":4522427,"change_date":"2023-11-29 21:43:00","inspection_id":"80270589","dot_number":"2174037","report_state":"TX","report_number":"6QEE9DCKRQ","insp_date":"2023-11-22 00:00:00","insp_start_time":"1412","insp_end_time":"1431","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"3000  CENTER 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":"2023-11-29 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"53200","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":"9135261","transaction_code":"A","transaction_date":"2023-11-29 00:00:00","upload_date":"2023-11-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02174037","upload_search_indicator":"M","census_search_date":"2023-11-29 21:43:00","snet_input_date":"2023-11-22 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-11-29 21:43:00","insp_carrier_name":"ALFREDO MARTINEZ","insp_carrier_street":"4011 ROLAND RD","insp_carrier_city":"KATY","insp_carrier_state":"TX","insp_carrier_zip_code":"77493-9701","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0193829","created_at":"2025-03-17T19:52:32.000000Z","updated_at":"2025-03-17T19:52:32.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7273428,"change_date":"2023-11-29 21:43:00","inspection_id":"80270589","insp_unit_id":"198273058","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"JXX2023","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDD49X3FJ445238","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:05.000000Z","updated_at":"2025-03-17T23:01:05.000000Z"}]},{"id":4354328,"change_date":"2023-11-03 21:41:00","inspection_id":"80085144","dot_number":"2174037","report_state":"TX","report_number":"6PTC9DGH4H","insp_date":"2023-11-01 00:00:00","insp_start_time":"1238","insp_end_time":"1310","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"8500  SIENNA SPRINGS","county_code_state":"TX","county_code":"157","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-11-03 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"54900","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":"9117153","transaction_code":"A","transaction_date":"2023-11-03 00:00:00","upload_date":"2023-11-03 00:00:00","upload_first_byte":"0","upload_dot_number":"02174037","upload_search_indicator":"M","census_search_date":"2023-11-03 21:41:00","snet_input_date":"2023-11-01 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-11-03 21:41:00","insp_carrier_name":"ALFREDO MARTINEZ","insp_carrier_street":"4011 ROLAND RD","insp_carrier_city":"KATY","insp_carrier_state":"TX","insp_carrier_zip_code":"77493-9701","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0193829","created_at":"2025-03-17T19:49:09.000000Z","updated_at":"2025-03-17T19:49:09.000000Z","inspection_violations":[{"id":6735978,"change_date":"2023-11-03 21:41:00","inspection_id":"80085144","insp_violation_id":"256218665","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"197906014","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:23.000000Z","updated_at":"2025-03-17T21:38:23.000000Z","normalized_code":"3963A1"},{"id":6735979,"change_date":"2023-11-03 21:41:00","inspection_id":"80085144","insp_violation_id":"256218666","seq_no":"2","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"197906014","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:23.000000Z","updated_at":"2025-03-17T21:38:23.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":7002941,"change_date":"2023-11-03 21:41:00","inspection_id":"80085144","insp_unit_id":"197906014","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"10","insp_unit_license":"GTG5593","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AK07Y75N006012","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:47.000000Z","updated_at":"2025-03-17T22:58:47.000000Z"}]},{"id":3593124,"change_date":"2023-07-25 21:42:00","inspection_id":"79238647","dot_number":"2174037","report_state":"TX","report_number":"6N179DCP2R","insp_date":"2023-07-24 00:00:00","insp_start_time":"0720","insp_end_time":"0745","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"8000  EAST FWY NORTH","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-07-25 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"54900","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9036097","transaction_code":"A","transaction_date":"2023-07-25 00:00:00","upload_date":"2023-07-25 00:00:00","upload_first_byte":"0","upload_dot_number":"02174037","upload_search_indicator":"M","census_search_date":"2023-07-25 21:42:00","snet_input_date":"2023-07-24 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-07-25 21:42:00","insp_carrier_name":"ALFREDO MARTINEZ","insp_carrier_street":"4011 ROLAND RD","insp_carrier_city":"KATY","insp_carrier_state":"TX","insp_carrier_zip_code":"77493-9701","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0193829","created_at":"2025-03-17T19:33:54.000000Z","updated_at":"2025-03-17T19:33:54.000000Z","inspection_violations":[{"id":5539910,"change_date":"2023-07-25 21:42:00","inspection_id":"79238647","insp_violation_id":"254275483","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"196192026","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:39.000000Z","updated_at":"2025-03-17T21:32:39.000000Z","normalized_code":"39347E"},{"id":5539911,"change_date":"2023-07-25 21:42:00","inspection_id":"79238647","insp_violation_id":"254275484","seq_no":"2","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"196192026","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:39.000000Z","updated_at":"2025-03-17T21:32:39.000000Z","normalized_code":"39353B"},{"id":5539912,"change_date":"2023-07-25 21:42:00","inspection_id":"79238647","insp_violation_id":"254275485","seq_no":"3","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"196192026","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:39.000000Z","updated_at":"2025-03-17T21:32:39.000000Z","normalized_code":"39345B2"}],"inspection_per_units":[{"id":5777463,"change_date":"2023-07-25 21:42:00","inspection_id":"79238647","insp_unit_id":"196192026","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"HZT6481","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDD49X06J136231","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:36.000000Z","updated_at":"2025-03-17T22:48:36.000000Z"}]},{"id":3560126,"change_date":"2023-07-20 21:41:00","inspection_id":"79201578","dot_number":"2174037","report_state":"TX","report_number":"6MUG9DCDC4","insp_date":"2023-07-17 00:00:00","insp_start_time":"1626","insp_end_time":"1649","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0010 IN HARRIS CO. (742-797","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-07-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"54900","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":"9033396","transaction_code":"A","transaction_date":"2023-07-20 00:00:00","upload_date":"2023-07-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02174037","upload_search_indicator":"M","census_search_date":"2023-07-20 21:41:00","snet_input_date":"2023-07-17 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-07-20 21:41:00","insp_carrier_name":"ALFREDO MARTINEZ","insp_carrier_street":"4011 ROLAND RD","insp_carrier_city":"KATY","insp_carrier_state":"TX","insp_carrier_zip_code":"77493-9701","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0193829","created_at":"2025-03-17T19:33:29.000000Z","updated_at":"2025-03-17T19:33:29.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5724905,"change_date":"2023-07-20 21:41:00","inspection_id":"79201578","insp_unit_id":"196115515","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"GFF3635","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AK06Y26N010150","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:10.000000Z","updated_at":"2025-03-17T22:48:10.000000Z"}]},{"id":3559897,"change_date":"2023-07-20 21:41:00","inspection_id":"79201335","dot_number":"2174037","report_state":"TX","report_number":"6MI89DAT8P","insp_date":"2023-07-05 00:00:00","insp_start_time":"0804","insp_end_time":"0816","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"7400  SH 6","county_code_state":"TX","county_code":"157","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-07-20 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":"9032530","transaction_code":"A","transaction_date":"2023-07-20 00:00:00","upload_date":"2023-07-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02174037","upload_search_indicator":"M","census_search_date":"2023-07-20 21:41:00","snet_input_date":"2023-07-05 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-07-20 21:41:00","insp_carrier_name":"ALFREDO MARTINEZ","insp_carrier_street":"4011 ROLAND RD","insp_carrier_city":"KATY","insp_carrier_state":"TX","insp_carrier_zip_code":"77493-9701","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0193829","created_at":"2025-03-17T19:33:13.000000Z","updated_at":"2025-03-17T19:33:13.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5724536,"change_date":"2023-07-20 21:41:00","inspection_id":"79201335","insp_unit_id":"196115033","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"JXX2357","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDD49X8FJ445249","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:10.000000Z","updated_at":"2025-03-17T22:48:10.000000Z"}]},{"id":2887973,"change_date":"2023-04-25 21:40:00","inspection_id":"78443990","dot_number":"2174037","report_state":"TX","report_number":"6KBD9DAWX5","insp_date":"2023-04-17 00:00:00","insp_start_time":"1308","insp_end_time":"1326","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"2800 W PARKWOOD AVE","county_code_state":"TX","county_code":"167","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-04-25 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"53200","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8962379","transaction_code":"A","transaction_date":"2023-04-25 00:00:00","upload_date":"2023-04-25 00:00:00","upload_first_byte":"0","upload_dot_number":"02174037","upload_search_indicator":"M","census_search_date":"2023-04-25 21:40:00","snet_input_date":"2023-04-17 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-04-25 21:40:00","insp_carrier_name":"ALFREDO MARTINEZ","insp_carrier_street":"4011 ROLAND RD","insp_carrier_city":"KATY","insp_carrier_state":"TX","insp_carrier_zip_code":"77493-9701","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0193829","created_at":"2025-03-17T19:20:04.000000Z","updated_at":"2025-03-17T19:20:04.000000Z","inspection_violations":[{"id":4431480,"change_date":"2023-04-25 21:40:00","inspection_id":"78443990","insp_violation_id":"252429572","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"194576688","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:40.000000Z","updated_at":"2025-03-17T21:27:40.000000Z","normalized_code":"39378"},{"id":4431481,"change_date":"2023-04-25 21:40:00","inspection_id":"78443990","insp_violation_id":"252429573","seq_no":"2","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"194576688","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:27:40.000000Z","updated_at":"2025-03-17T21:27:40.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":4646776,"change_date":"2023-04-25 21:40:00","inspection_id":"78443990","insp_unit_id":"194576688","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"2","insp_unit_license":"JXX2199","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDD49XXFJ445284","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:39:39.000000Z","updated_at":"2025-03-17T22:39:39.000000Z"}]},{"id":2569108,"change_date":"2023-03-13 21:43:00","inspection_id":"78081686","dot_number":"2174037","report_state":"TX","report_number":"6J7E0AGTFC","insp_date":"2023-03-08 00:00:00","insp_start_time":"1412","insp_end_time":"1425","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"FISH CREEK THOROUGHF","county_code_state":"TX","county_code":"339","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"MARTINEZ","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-03-13 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"0","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":"8927450","transaction_code":"A","transaction_date":"2023-03-13 00:00:00","upload_date":"2023-03-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02174037","upload_search_indicator":"M","census_search_date":"2023-03-13 21:43:00","snet_input_date":"2023-03-08 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-03-13 21:43:00","insp_carrier_name":"ALFREDO MARTINEZ","insp_carrier_street":"4011 ROLAND RD","insp_carrier_city":"KATY","insp_carrier_state":"TX","insp_carrier_zip_code":"77493-9701","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0193829","created_at":"2025-03-17T19:14:05.000000Z","updated_at":"2025-03-17T19:14:05.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4135057,"change_date":"2023-03-13 21:43:00","inspection_id":"78081686","insp_unit_id":"193850469","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"HZT6481","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDD49X06J136231","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:39.000000Z","updated_at":"2025-03-17T22:35:39.000000Z"}]},{"id":2425244,"change_date":"2023-02-22 21:40:00","inspection_id":"77918031","dot_number":"2174037","report_state":"TX","report_number":"6IGC9DNAR1","insp_date":"2023-02-09 00:00:00","insp_start_time":"1245","insp_end_time":"1330","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"6500  FRANZ RD","county_code_state":"TX","county_code":"473","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"XX","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-02-22 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"0","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":"8910280","transaction_code":"A","transaction_date":"2023-02-22 00:00:00","upload_date":"2023-02-22 00:00:00","upload_first_byte":"0","upload_dot_number":"02174037","upload_search_indicator":"M","census_search_date":"2023-02-22 21:40:00","snet_input_date":"2023-02-09 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-02-22 21:40:00","insp_carrier_name":"ALFREDO MARTINEZ","insp_carrier_street":"4011 ROLAND RD","insp_carrier_city":"KATY","insp_carrier_state":"TX","insp_carrier_zip_code":"77493-9701","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0193829","created_at":"2025-03-17T19:11:24.000000Z","updated_at":"2025-03-17T19:11:24.000000Z","inspection_violations":[{"id":3734979,"change_date":"2023-02-22 21:40:00","inspection_id":"77918031","insp_violation_id":"251277032","seq_no":"1","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"193525332","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:35.000000Z","updated_at":"2025-03-17T21:24:35.000000Z","normalized_code":"39395F"},{"id":3734980,"change_date":"2023-02-22 21:40:00","inspection_id":"77918031","insp_violation_id":"251277033","seq_no":"2","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"193525332","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:35.000000Z","updated_at":"2025-03-17T21:24:35.000000Z","normalized_code":"39311"}],"inspection_per_units":[{"id":3903585,"change_date":"2023-02-22 21:40:00","inspection_id":"77918031","insp_unit_id":"193525332","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MCKT","insp_unit_company":"9","insp_unit_license":"GFF3635","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AK06Y26N010150","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:57.000000Z","updated_at":"2025-03-17T22:33:57.000000Z"}]},{"id":1640618,"change_date":"2022-10-31 21:41:00","inspection_id":"77020411","dot_number":"2174037","report_state":"TX","report_number":"6FH79DAZXG","insp_date":"2022-10-25 00:00:00","insp_start_time":"0725","insp_end_time":"0800","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0099 IN HARRIS CO. (698-750","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"YARD","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-10-31 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8814253","transaction_code":"A","transaction_date":"2022-10-31 00:00:00","upload_date":"2022-10-31 00:00:00","upload_first_byte":"0","upload_dot_number":"02174037","upload_search_indicator":"M","census_search_date":"2022-10-31 21:41:00","snet_input_date":"2022-10-25 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-10-31 21:41:00","insp_carrier_name":"ALFREDO MARTINEZ","insp_carrier_street":"4011 ROLAND RD","insp_carrier_city":"KATY","insp_carrier_state":"TX","insp_carrier_zip_code":"77493-9701","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0193829","created_at":"2025-03-17T18:57:00.000000Z","updated_at":"2025-03-17T18:57:00.000000Z","inspection_violations":[{"id":2574566,"change_date":"2022-10-31 21:41:00","inspection_id":"77020411","insp_violation_id":"249351909","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"191733092","insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:07.000000Z","updated_at":"2025-03-17T21:19:07.000000Z","normalized_code":"3922"},{"id":2574567,"change_date":"2022-10-31 21:41:00","inspection_id":"77020411","insp_violation_id":"249351910","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"191733092","insp_violation_category_id":"41","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:07.000000Z","updated_at":"2025-03-17T21:19:07.000000Z","normalized_code":"3922"},{"id":2574568,"change_date":"2022-10-31 21:41:00","inspection_id":"77020411","insp_violation_id":"249351911","seq_no":"3","part_no":"393","part_no_section":"55(c)(2)","insp_viol_unit":"1","insp_unit_id":"191733092","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:19:07.000000Z","updated_at":"2025-03-17T21:19:07.000000Z","normalized_code":"39355C2"}],"inspection_per_units":[{"id":2639524,"change_date":"2022-10-31 21:41:00","inspection_id":"77020411","insp_unit_id":"191733092","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"10","insp_unit_license":"GTG5593","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AK07Y75N006012","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:05.000000Z","updated_at":"2025-03-17T22:25:05.000000Z"}]},{"id":1606673,"change_date":"2022-10-26 21:39:00","inspection_id":"76981442","dot_number":"2174037","report_state":"TX","report_number":"6FB90ZGT6M","insp_date":"2022-10-19 00:00:00","insp_start_time":"0925","insp_end_time":"0940","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"FM-0723 IN FORT BEND CO. (474-","county_code_state":"TX","county_code":"157","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":"N","pen_cen_match":null,"final_status_date":"2022-10-26 21:39: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":"8811353","transaction_code":"A","transaction_date":"2022-10-26 00:00:00","upload_date":"2022-10-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02174037","upload_search_indicator":"M","census_search_date":"2022-10-26 21:39:00","snet_input_date":"2022-10-19 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-10-26 21:39:00","insp_carrier_name":"ALFREDO MARTINEZ","insp_carrier_street":"4011 ROLAND RD","insp_carrier_city":"KATY","insp_carrier_state":"TX","insp_carrier_zip_code":"77493-9701","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0193829","created_at":"2025-03-17T18:56:17.000000Z","updated_at":"2025-03-17T18:56:17.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2585510,"change_date":"2022-10-26 21:39:00","inspection_id":"76981442","insp_unit_id":"191656610","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"GWL1250","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDDU8X29J254948","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:44.000000Z","updated_at":"2025-03-17T22:24:44.000000Z"}]},{"id":1267592,"change_date":"2022-09-12 21:43:00","inspection_id":"76588733","dot_number":"2174037","report_state":"TX","report_number":"6E589DNAMJ","insp_date":"2022-09-07 00:00:00","insp_start_time":"0745","insp_end_time":"0830","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US-0090 IN WALLER CO. (794-804","county_code_state":"TX","county_code":"473","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"MARTIN MARIETTA","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2022-09-12 21:43: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":"8769786","transaction_code":"A","transaction_date":"2022-09-12 00:00:00","upload_date":"2022-09-12 00:00:00","upload_first_byte":"0","upload_dot_number":"02174037","upload_search_indicator":"M","census_search_date":"2022-09-12 21:43:00","snet_input_date":"2022-09-07 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-09-12 21:43:00","insp_carrier_name":"ALFREDO MARTINEZ","insp_carrier_street":"4011 ROLAND RD","insp_carrier_city":"KATY","insp_carrier_state":"TX","insp_carrier_zip_code":"77493-9701","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0193829","created_at":"2025-03-17T18:50:06.000000Z","updated_at":"2025-03-17T18:50:06.000000Z","inspection_violations":[{"id":2007847,"change_date":"2022-09-12 21:43:00","inspection_id":"76588733","insp_violation_id":"248365610","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"190855394","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:16:14.000000Z","updated_at":"2025-03-17T21:16:14.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":2040003,"change_date":"2022-09-12 21:43:00","inspection_id":"76588733","insp_unit_id":"190855394","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"8","insp_unit_license":"MPR7697","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDD49X99J246876","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:01.000000Z","updated_at":"2025-03-17T22:21:01.000000Z"}]},{"id":690646,"change_date":"2022-06-24 21:39:00","inspection_id":"75915459","dot_number":"2174037","report_state":"TX","report_number":"6C1B9DAWNV","insp_date":"2022-06-23 00:00:00","insp_start_time":"1148","insp_end_time":"1207","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"1800  SAN JOAQUIN PK","county_code_state":"TX","county_code":"167","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2022-06-24 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"48000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8694947","transaction_code":"A","transaction_date":"2022-06-24 00:00:00","upload_date":"2022-06-24 00:00:00","upload_first_byte":"0","upload_dot_number":"02174037","upload_search_indicator":"M","census_search_date":"2022-06-24 21:39:00","snet_input_date":"2022-06-23 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-06-24 21:39:00","insp_carrier_name":"ALFREDO MARTINEZ","insp_carrier_street":"4011 ROLAND RD","insp_carrier_city":"KATY","insp_carrier_state":"TX","insp_carrier_zip_code":"77493-9701","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0193829","created_at":"2025-03-17T18:39:50.000000Z","updated_at":"2025-03-17T18:39:50.000000Z","inspection_violations":[{"id":1087156,"change_date":"2022-06-24 21:39:00","inspection_id":"75915459","insp_violation_id":"246714508","seq_no":"1","part_no":"392","part_no_section":"82(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:07.000000Z","updated_at":"2025-03-17T21:12:07.000000Z","normalized_code":"39282A1"}],"inspection_per_units":[{"id":1109620,"change_date":"2022-06-24 21:39:00","inspection_id":"75915459","insp_unit_id":"189456163","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"10","insp_unit_license":"GTG5593","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AK07Y75N006012","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:01.000000Z","updated_at":"2025-03-17T22:15:01.000000Z"}]},{"id":149860,"change_date":"2022-05-04 21:41:00","inspection_id":"75271735","dot_number":"2174037","report_state":"TX","report_number":"69WC9DCC2V","insp_date":"2022-04-07 00:00:00","insp_start_time":"1205","insp_end_time":"1236","registration_date":"2022-05-04 00:00:00","region":"CT","ci_status_code":"C","location":null,"location_desc":"1000 N MASON 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":"2022-04-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8617039","transaction_code":"C","transaction_date":"2022-04-11 00:00:00","upload_date":"2022-05-04 00:00:00","upload_first_byte":"0","upload_dot_number":"02174037","upload_search_indicator":"M","census_search_date":"2022-04-11 21:41:00","snet_input_date":"2022-04-07 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-04-11 21:41:00","insp_carrier_name":"ALFREDO MARTINEZ","insp_carrier_street":"4011 ROLAND RD","insp_carrier_city":"KATY","insp_carrier_state":"TX","insp_carrier_zip_code":"77493-9701","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0193829","created_at":"2025-03-17T18:30:09.000000Z","updated_at":"2025-03-17T18:30:09.000000Z","inspection_violations":[{"id":223494,"change_date":"2022-05-04 21:41:00","inspection_id":"75271735","insp_violation_id":"245580815","seq_no":"1","part_no":"393","part_no_section":"75(b)","insp_viol_unit":"1","insp_unit_id":"188510645","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:06.000000Z","updated_at":"2025-03-17T21:08:06.000000Z","normalized_code":"39375B"},{"id":223495,"change_date":"2022-05-04 21:41:00","inspection_id":"75271735","insp_violation_id":"245580816","seq_no":"2","part_no":"393","part_no_section":"75(b)","insp_viol_unit":"1","insp_unit_id":"188510645","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:06.000000Z","updated_at":"2025-03-17T21:08:06.000000Z","normalized_code":"39375B"},{"id":223496,"change_date":"2022-05-04 21:41:00","inspection_id":"75271735","insp_violation_id":"245580817","seq_no":"3","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"188510645","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:06.000000Z","updated_at":"2025-03-17T21:08:06.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":243050,"change_date":"2022-05-04 21:41:00","inspection_id":"75271735","insp_unit_id":"188510645","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"8","insp_unit_license":"MPR7697","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDD49X99J246876","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:40.000000Z","updated_at":"2025-03-17T22:09:40.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/2174037\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/2174037\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/2174037\/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\/2174037\/inspections","per_page":100,"prev_page_url":null,"to":37,"total":37}