{"current_page":1,"data":[{"id":10108296,"change_date":"2025-11-03 21:39:00","inspection_id":"86224234","dot_number":"2483919","report_state":"TX","report_number":"7A0B9DAZH2","insp_date":"2025-10-28 00:00:00","insp_start_time":"1050","insp_end_time":"1215","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":"MARTIN HARDWARE","shipping_paper_number":"2510-579488","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-11-03 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"132300","viol_total":"14","oos_total":"2","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"13","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9744250","transaction_code":"A","transaction_date":"2025-11-03 00:00:00","upload_date":"2025-11-03 00:00:00","upload_first_byte":"0","upload_dot_number":"02483919","upload_search_indicator":"M","census_search_date":"2025-11-03 21:39:00","snet_input_date":"2025-10-28 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-11-03 21:39:00","insp_carrier_name":"EFRAIN FRANCO","insp_carrier_street":"6220 JENSEN DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77026","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0852705","created_at":"2025-11-06T10:30:44.000000Z","updated_at":"2025-11-07T10:30:54.000000Z","inspection_violations":[{"id":16751882,"change_date":"2025-11-03 21:39:00","inspection_id":"86224234","insp_violation_id":"269696462","seq_no":"1","part_no":"393","part_no_section":"95A","insp_viol_unit":"1","insp_unit_id":"209809322","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-07T10:31:02.000000Z","updated_at":"2025-11-07T10:31:02.000000Z","normalized_code":"39395A"},{"id":16751883,"change_date":"2025-11-03 21:39:00","inspection_id":"86224234","insp_violation_id":"269696463","seq_no":"2","part_no":"393","part_no_section":"110B","insp_viol_unit":"2","insp_unit_id":"209809323","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-11-07T10:31:02.000000Z","updated_at":"2025-11-07T10:31:02.000000Z","normalized_code":"393110B"},{"id":16751884,"change_date":"2025-11-03 21:39:00","inspection_id":"86224234","insp_violation_id":"269696464","seq_no":"3","part_no":"390","part_no_section":"21(a)","insp_viol_unit":"1","insp_unit_id":"209809322","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-07T10:31:02.000000Z","updated_at":"2025-11-07T10:31:02.000000Z","normalized_code":"39021A"},{"id":16751885,"change_date":"2025-11-03 21:39:00","inspection_id":"86224234","insp_violation_id":"269696465","seq_no":"4","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-11-07T10:31:02.000000Z","updated_at":"2025-11-07T10:31:02.000000Z","normalized_code":"38323A2"},{"id":16751886,"change_date":"2025-11-03 21:39:00","inspection_id":"86224234","insp_violation_id":"269696466","seq_no":"5","part_no":"393","part_no_section":"11TU","insp_viol_unit":"1","insp_unit_id":"209809322","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-07T10:31:02.000000Z","updated_at":"2025-11-07T10:31:02.000000Z","normalized_code":"39311TU"},{"id":16751887,"change_date":"2025-11-03 21:39:00","inspection_id":"86224234","insp_violation_id":"269696467","seq_no":"6","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"209809322","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-07T10:31:02.000000Z","updated_at":"2025-11-07T10:31:02.000000Z","normalized_code":"39617C"},{"id":16751888,"change_date":"2025-11-03 21:39:00","inspection_id":"86224234","insp_violation_id":"269696468","seq_no":"7","part_no":"396","part_no_section":"17C","insp_viol_unit":"2","insp_unit_id":"209809323","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-07T10:31:02.000000Z","updated_at":"2025-11-07T10:31:02.000000Z","normalized_code":"39617C"},{"id":16751889,"change_date":"2025-11-03 21:39:00","inspection_id":"86224234","insp_violation_id":"269696469","seq_no":"8","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"209809322","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-07T10:31:02.000000Z","updated_at":"2025-11-07T10:31:02.000000Z","normalized_code":"39378"},{"id":16751890,"change_date":"2025-11-03 21:39:00","inspection_id":"86224234","insp_violation_id":"269696470","seq_no":"9","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"209809323","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-07T10:31:02.000000Z","updated_at":"2025-11-07T10:31:02.000000Z","normalized_code":"3939"},{"id":16751891,"change_date":"2025-11-03 21:39:00","inspection_id":"86224234","insp_violation_id":"269696471","seq_no":"10","part_no":"393","part_no_section":"205C","insp_viol_unit":"2","insp_unit_id":"209809323","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-07T10:31:02.000000Z","updated_at":"2025-11-07T10:31:02.000000Z","normalized_code":"393205C"},{"id":16751892,"change_date":"2025-11-03 21:39:00","inspection_id":"86224234","insp_violation_id":"269696472","seq_no":"11","part_no":"392","part_no_section":"2RG","insp_viol_unit":"2","insp_unit_id":"209809323","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-07T10:31:02.000000Z","updated_at":"2025-11-07T10:31:02.000000Z","normalized_code":"3922RG"},{"id":16751893,"change_date":"2025-11-03 21:39:00","inspection_id":"86224234","insp_violation_id":"269696473","seq_no":"12","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"209809322","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-07T10:31:02.000000Z","updated_at":"2025-11-07T10:31:02.000000Z","normalized_code":"3922RG"},{"id":16751894,"change_date":"2025-11-03 21:39:00","inspection_id":"86224234","insp_violation_id":"269696474","seq_no":"13","part_no":"393","part_no_section":"55E","insp_viol_unit":"2","insp_unit_id":"209809323","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-07T10:31:02.000000Z","updated_at":"2025-11-07T10:31:02.000000Z","normalized_code":"39355E"},{"id":16751895,"change_date":"2025-11-03 21:39:00","inspection_id":"86224234","insp_violation_id":"269696475","seq_no":"14","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"209809322","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-07T10:31:02.000000Z","updated_at":"2025-11-07T10:31:02.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":16810309,"change_date":"2025-11-03 21:39:00","inspection_id":"86224234","insp_unit_id":"209809322","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"1M10289","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3AKJGBDV5HSHR2657","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-06T10:00:39.000000Z","updated_at":"2025-11-07T10:01:10.000000Z"},{"id":16810310,"change_date":"2025-11-03 21:39:00","inspection_id":"86224234","insp_unit_id":"209809323","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRAO","insp_unit_company":null,"insp_unit_license":"206C554","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1TTF4520712007322","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-06T10:00:39.000000Z","updated_at":"2025-11-07T10:01:10.000000Z"}]},{"id":9441180,"change_date":"2025-08-18 21:39:00","inspection_id":"85522971","dot_number":"2483919","report_state":"TX","report_number":"V251968262","insp_date":"2025-08-14 00:00:00","insp_start_time":"1347","insp_end_time":"1421","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SJOLANDER RD SB AT I","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"MARTIN'S HARDWARE & LUMBER","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-18 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"4","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9668463","transaction_code":"A","transaction_date":"2025-08-18 00:00:00","upload_date":"2025-08-18 00:00:00","upload_first_byte":"0","upload_dot_number":"02483919","upload_search_indicator":"M","census_search_date":"2025-08-18 21:39:00","snet_input_date":"2025-08-14 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-08-18 21:39:00","insp_carrier_name":"EFRAIN FRANCO","insp_carrier_street":"6220 JENSEN DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77026","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0852705","created_at":"2025-08-23T10:46:02.000000Z","updated_at":"2025-08-23T10:46:02.000000Z","inspection_violations":[{"id":15370566,"change_date":"2025-08-18 21:39:00","inspection_id":"85522971","insp_violation_id":"268097647","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-21T10:42:38.000000Z","updated_at":"2025-08-22T10:44:16.000000Z","normalized_code":"38323A2"},{"id":15370567,"change_date":"2025-08-18 21:39:00","inspection_id":"85522971","insp_violation_id":"268097648","seq_no":"2","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"208454284","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-21T10:42:38.000000Z","updated_at":"2025-08-22T10:44:16.000000Z","normalized_code":"39378"},{"id":15370568,"change_date":"2025-08-18 21:39:00","inspection_id":"85522971","insp_violation_id":"268097649","seq_no":"3","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"208454284","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-21T10:42:38.000000Z","updated_at":"2025-08-22T10:44:16.000000Z","normalized_code":"3922RG"},{"id":15370569,"change_date":"2025-08-18 21:39:00","inspection_id":"85522971","insp_violation_id":"268097650","seq_no":"4","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"208454284","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-21T10:42:38.000000Z","updated_at":"2025-08-22T10:44:16.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":15566300,"change_date":"2025-08-18 21:39:00","inspection_id":"85522971","insp_unit_id":"208454284","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"2","insp_unit_license":"RMY4421","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3ALHCYBS8DDFG0405","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-21T09:45:47.000000Z","updated_at":"2025-08-22T09:46:12.000000Z"}]},{"id":8770894,"change_date":"2025-05-29 21:42:00","inspection_id":"84815872","dot_number":"2483919","report_state":"TX","report_number":"75JA9DGBPB","insp_date":"2025-05-20 00:00:00","insp_start_time":"1036","insp_end_time":"1058","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0045 IN GALVESTON CO. (0-23","county_code_state":"TX","county_code":"167","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-05-29 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"3","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9593423","transaction_code":"A","transaction_date":"2025-05-29 00:00:00","upload_date":"2025-05-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02483919","upload_search_indicator":"M","census_search_date":"2025-05-29 21:42:00","snet_input_date":"2025-05-20 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-05-29 21:42:00","insp_carrier_name":"EFRAIN FRANCO","insp_carrier_street":"6220 JENSEN DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77026","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0852705","created_at":"2025-06-01T10:01:25.000000Z","updated_at":"2025-06-04T10:00:48.000000Z","inspection_violations":[{"id":14015769,"change_date":"2025-05-29 21:42:00","inspection_id":"84815872","insp_violation_id":"266556420","seq_no":"1","part_no":"393","part_no_section":"24A","insp_viol_unit":"1","insp_unit_id":"207134786","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-01T10:17:45.000000Z","updated_at":"2025-06-02T10:18:00.000000Z","normalized_code":"39324A"},{"id":14015770,"change_date":"2025-05-29 21:42:00","inspection_id":"84815872","insp_violation_id":"266556421","seq_no":"2","part_no":"393","part_no_section":"23","insp_viol_unit":"1","insp_unit_id":"207134786","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-06-01T10:17:45.000000Z","updated_at":"2025-06-02T10:18:00.000000Z","normalized_code":"39323"},{"id":14015771,"change_date":"2025-05-29 21:42:00","inspection_id":"84815872","insp_violation_id":"266556422","seq_no":"3","part_no":"393","part_no_section":"209D","insp_viol_unit":"1","insp_unit_id":"207134786","insp_violation_category_id":"21","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-06-01T10:17:45.000000Z","updated_at":"2025-06-02T10:18:00.000000Z","normalized_code":"393209D"}],"inspection_per_units":[{"id":14348823,"change_date":"2025-05-29 21:42:00","inspection_id":"84815872","insp_unit_id":"207134786","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"V-6024","insp_unit_license":"1M37478","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1HTSCAAN4YH266024","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-01T09:46:47.000000Z","updated_at":"2025-06-02T09:46:03.000000Z"}]},{"id":8228773,"change_date":"2025-03-27 21:42:00","inspection_id":"84244514","dot_number":"2483919","report_state":"TX","report_number":"73ZA9DGPKY","insp_date":"2025-03-25 00:00:00","insp_start_time":"1016","insp_end_time":"1045","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"3400  PENN","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"MARTINS HARDWARE","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-03-27 21:42: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":"9533763","transaction_code":"A","transaction_date":"2025-03-27 00:00:00","upload_date":"2025-03-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02483919","upload_search_indicator":"M","census_search_date":"2025-03-27 21:42:00","snet_input_date":"2025-03-25 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-03-27 21:42:00","insp_carrier_name":"EFRAIN FRANCO","insp_carrier_street":"6220 JENSEN DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77026","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0852705","created_at":"2025-03-30T10:38:45.000000Z","updated_at":"2025-03-31T10:30:56.000000Z","inspection_violations":[{"id":12912688,"change_date":"2025-03-27 21:42:00","inspection_id":"84244514","insp_violation_id":"265293552","seq_no":"1","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"206028291","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-29T10:53:04.000000Z","updated_at":"2025-03-31T10:54:50.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":13311556,"change_date":"2025-03-27 21:42:00","inspection_id":"84244514","insp_unit_id":"206028291","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"1M37478","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1HTSCAAN4YH266024","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-30T10:27:13.000000Z","updated_at":"2025-03-31T10:07:42.000000Z"}]},{"id":7574480,"change_date":"2025-01-08 21:39:00","inspection_id":"83557026","dot_number":"2483919","report_state":"TX","report_number":"71Q89DCAUU","insp_date":"2025-01-03 00:00:00","insp_start_time":"0813","insp_end_time":"0845","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"13500  EAST FWY SER","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"MARTINS HARDWARE","shipping_paper_number":"2501975050","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-08 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"26001","viol_total":"4","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9468646","transaction_code":"A","transaction_date":"2025-01-08 00:00:00","upload_date":"2025-01-08 00:00:00","upload_first_byte":"0","upload_dot_number":"02483919","upload_search_indicator":"M","census_search_date":"2025-01-08 21:39:00","snet_input_date":"2025-01-03 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-01-08 21:39:00","insp_carrier_name":"EFRAIN FRANCO","insp_carrier_street":"6219 JENSEN DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77026","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0852705","created_at":"2025-03-17T20:55:18.000000Z","updated_at":"2025-03-17T20:55:18.000000Z","inspection_violations":[{"id":11841111,"change_date":"2025-01-08 21:39:00","inspection_id":"83557026","insp_violation_id":"263818515","seq_no":"1","part_no":"393","part_no_section":"75C","insp_viol_unit":"1","insp_unit_id":"204708466","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:43.000000Z","updated_at":"2025-03-17T22:03:43.000000Z","normalized_code":"39375C"},{"id":11841112,"change_date":"2025-01-08 21:39:00","inspection_id":"83557026","insp_violation_id":"263818516","seq_no":"2","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"204708466","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:43.000000Z","updated_at":"2025-03-17T22:03:43.000000Z","normalized_code":"3922RG"},{"id":11841113,"change_date":"2025-01-08 21:39:00","inspection_id":"83557026","insp_violation_id":"263818517","seq_no":"3","part_no":"393","part_no_section":"104B","insp_viol_unit":"1","insp_unit_id":"204708466","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:43.000000Z","updated_at":"2025-03-17T22:03:43.000000Z","normalized_code":"393104B"},{"id":11841114,"change_date":"2025-01-08 21:39:00","inspection_id":"83557026","insp_violation_id":"263818518","seq_no":"4","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"204708466","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:43.000000Z","updated_at":"2025-03-17T22:03:43.000000Z","normalized_code":"39378"}],"inspection_per_units":[{"id":12221323,"change_date":"2025-01-08 21:39:00","inspection_id":"83557026","insp_unit_id":"204708466","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"ITNL","insp_unit_company":"3","insp_unit_license":"1M37478","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1HTSCAAN4YH266024","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:49:55.000000Z","updated_at":"2025-03-17T23:49:55.000000Z"}]},{"id":7429872,"change_date":"2024-12-17 21:39:00","inspection_id":"83405163","dot_number":"2483919","report_state":"TX","report_number":"713G9DGXII","insp_date":"2024-12-11 00:00:00","insp_start_time":"1636","insp_end_time":"1649","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"200  PRESTON N\/B","county_code_state":"TX","county_code":"201","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"2404 SPENCER HWY","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-16 21:40: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":"9450564","transaction_code":"C","transaction_date":"2024-12-17 00:00:00","upload_date":"2024-12-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02483919","upload_search_indicator":"M","census_search_date":"2024-12-16 21:40:00","snet_input_date":"2024-12-11 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-12-16 21:40:00","insp_carrier_name":"EFRAIN FRANCO","insp_carrier_street":"6219 JENSEN DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77026","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0852705","created_at":"2025-03-17T20:51:08.000000Z","updated_at":"2025-03-17T20:51:08.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11986503,"change_date":"2024-12-17 21:39:00","inspection_id":"83405163","insp_unit_id":"204433404","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"3","insp_unit_license":"1M37478","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1HTSCAAN4YH266024","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:47:21.000000Z","updated_at":"2025-03-17T23:47:21.000000Z"}]},{"id":6336901,"change_date":"2024-07-29 21:42:00","inspection_id":"82244332","dot_number":"2483919","report_state":"TX","report_number":"6X799DCQSQ","insp_date":"2024-07-24 00:00:00","insp_start_time":"0930","insp_end_time":"1000","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"500  REID 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":"2024-07-29 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"6","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9335894","transaction_code":"A","transaction_date":"2024-07-29 00:00:00","upload_date":"2024-07-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02483919","upload_search_indicator":"M","census_search_date":"2024-07-29 21:42:00","snet_input_date":"2024-07-24 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-07-29 21:42:00","insp_carrier_name":"EFRAIN FRANCO","insp_carrier_street":"6219 JENSEN DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77026","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0852705","created_at":"2025-03-17T20:28:18.000000Z","updated_at":"2025-03-17T20:28:18.000000Z","inspection_violations":[{"id":9838598,"change_date":"2024-07-29 21:42:00","inspection_id":"82244332","insp_violation_id":"260899005","seq_no":"1","part_no":"393","part_no_section":"55(d)(1)","insp_viol_unit":"1","insp_unit_id":"202126857","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:33.000000Z","updated_at":"2025-03-17T21:53:33.000000Z","normalized_code":"39355D1"},{"id":9838599,"change_date":"2024-07-29 21:42:00","inspection_id":"82244332","insp_violation_id":"260899006","seq_no":"2","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"202126857","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:33.000000Z","updated_at":"2025-03-17T21:53:33.000000Z","normalized_code":"39311"},{"id":9838600,"change_date":"2024-07-29 21:42:00","inspection_id":"82244332","insp_violation_id":"260899007","seq_no":"3","part_no":"393","part_no_section":"75(b)","insp_viol_unit":"1","insp_unit_id":"202126857","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:33.000000Z","updated_at":"2025-03-17T21:53:33.000000Z","normalized_code":"39375B"},{"id":9838601,"change_date":"2024-07-29 21:42:00","inspection_id":"82244332","insp_violation_id":"260899008","seq_no":"4","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"202126857","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:53:33.000000Z","updated_at":"2025-03-17T21:53:33.000000Z","normalized_code":"39375A3"},{"id":9838602,"change_date":"2024-07-29 21:42:00","inspection_id":"82244332","insp_violation_id":"260899009","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202126857","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:33.000000Z","updated_at":"2025-03-17T21:53:33.000000Z","normalized_code":"3939A"},{"id":9838603,"change_date":"2024-07-29 21:42:00","inspection_id":"82244332","insp_violation_id":"260899010","seq_no":"6","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"202126857","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:33.000000Z","updated_at":"2025-03-17T21:53:33.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":10211273,"change_date":"2024-07-29 21:42:00","inspection_id":"82244332","insp_unit_id":"202126857","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"3","insp_unit_license":"1M37478","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1HTSCAAN4YH266024","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:28:46.000000Z","updated_at":"2025-03-17T23:28:46.000000Z"}]},{"id":5665229,"change_date":"2024-05-03 21:39:00","inspection_id":"81519091","dot_number":"2483919","report_state":"TX","report_number":"6UPG9DJN3C","insp_date":"2024-04-25 00:00:00","insp_start_time":"1612","insp_end_time":"1632","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"3800  CAVALCADE ST","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":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-05-03 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9264052","transaction_code":"A","transaction_date":"2024-05-03 00:00:00","upload_date":"2024-05-03 00:00:00","upload_first_byte":"0","upload_dot_number":"02483919","upload_search_indicator":"M","census_search_date":"2024-05-03 21:39:00","snet_input_date":"2024-04-25 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-05-03 21:39:00","insp_carrier_name":"EFRAIN FRANCO","insp_carrier_street":"6219 JENSEN DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77026","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0852705","created_at":"2025-03-17T20:15:04.000000Z","updated_at":"2025-03-17T20:15:04.000000Z","inspection_violations":[{"id":8763686,"change_date":"2024-05-03 21:39:00","inspection_id":"81519091","insp_violation_id":"259308654","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"200719951","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:24.000000Z","updated_at":"2025-03-17T21:48:24.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":9124567,"change_date":"2024-05-03 21:39:00","inspection_id":"81519091","insp_unit_id":"200719951","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"3","insp_unit_license":"1M37478","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1HTSCAAN4YH266024","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:53.000000Z","updated_at":"2025-03-17T23:17:53.000000Z"}]},{"id":5091726,"change_date":"2024-02-20 21:42:00","inspection_id":"80893694","dot_number":"2483919","report_state":"TX","report_number":"6SR99DCPDE","insp_date":"2024-02-15 00:00:00","insp_start_time":"0945","insp_end_time":"1010","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"13500  EAST FWY SOUT","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-02-20 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"9200030","transaction_code":"A","transaction_date":"2024-02-20 00:00:00","upload_date":"2024-02-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02483919","upload_search_indicator":"M","census_search_date":"2024-02-20 21:42:00","snet_input_date":"2024-02-15 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-02-20 21:42:00","insp_carrier_name":"EFRAIN FRANCO","insp_carrier_street":"6219 JENSEN DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77026","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0852705","created_at":"2025-03-17T20:03:29.000000Z","updated_at":"2025-03-17T20:03:29.000000Z","inspection_violations":[{"id":7849731,"change_date":"2024-02-20 21:42:00","inspection_id":"80893694","insp_violation_id":"257931987","seq_no":"1","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"199507591","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:57.000000Z","updated_at":"2025-03-17T21:43:57.000000Z","normalized_code":"39360C"},{"id":7849732,"change_date":"2024-02-20 21:42:00","inspection_id":"80893694","insp_violation_id":"257931988","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"199507591","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:57.000000Z","updated_at":"2025-03-17T21:43:57.000000Z","normalized_code":"3939A"},{"id":7849733,"change_date":"2024-02-20 21:42:00","inspection_id":"80893694","insp_violation_id":"257931989","seq_no":"3","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"199507591","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:57.000000Z","updated_at":"2025-03-17T21:43:57.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":8197470,"change_date":"2024-02-20 21:42:00","inspection_id":"80893694","insp_unit_id":"199507591","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"RMY4421","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3ALHCYBS8DDFG0405","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:09:17.000000Z","updated_at":"2025-03-17T23:09:17.000000Z"}]},{"id":4137075,"change_date":"2023-10-05 21:40:00","inspection_id":"79845159","dot_number":"2483919","report_state":"TX","report_number":"6OX99DJNRB","insp_date":"2023-09-30 00:00:00","insp_start_time":"0915","insp_end_time":"0938","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"10800  NORTH FREEWAY","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"MARTINS HARDWARE","shipping_paper_number":"2309-704597","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-10-05 21:40: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":"9092836","transaction_code":"A","transaction_date":"2023-10-05 00:00:00","upload_date":"2023-10-05 00:00:00","upload_first_byte":"0","upload_dot_number":"02483919","upload_search_indicator":"M","census_search_date":"2023-10-05 21:40:00","snet_input_date":"2023-09-30 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-10-05 21:40:00","insp_carrier_name":"EFRAIN FRANCO","insp_carrier_street":"6219 JENSEN DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77026","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0852705","created_at":"2025-03-17T19:44:29.000000Z","updated_at":"2025-03-17T19:44:29.000000Z","inspection_violations":[{"id":6404370,"change_date":"2023-10-05 21:40:00","inspection_id":"79845159","insp_violation_id":"255687113","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"197423068","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:54.000000Z","updated_at":"2025-03-17T21:36:54.000000Z","normalized_code":"39311"}],"inspection_per_units":[{"id":6652337,"change_date":"2023-10-05 21:40:00","inspection_id":"79845159","insp_unit_id":"197423068","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"3","insp_unit_license":"1M37478","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1HTSCAAN4YH266024","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:55:48.000000Z","updated_at":"2025-03-17T22:55:48.000000Z"}]},{"id":3994823,"change_date":"2023-09-20 21:40:00","inspection_id":"79687121","dot_number":"2483919","report_state":"TX","report_number":"6OHF9DCE8K","insp_date":"2023-09-14 00:00:00","insp_start_time":"1525","insp_end_time":"1605","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"400 E LOOP N","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"MARTIN","shipping_paper_number":"2309369159","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-09-18 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":"9077229","transaction_code":"C","transaction_date":"2023-09-20 00:00:00","upload_date":"2023-09-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02483919","upload_search_indicator":"M","census_search_date":"2023-09-18 21:39:00","snet_input_date":"2023-09-14 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-09-18 21:39:00","insp_carrier_name":"EFRAIN FRANCO","insp_carrier_street":"6219 JENSEN DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77026","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0852705","created_at":"2025-03-17T19:41:39.000000Z","updated_at":"2025-03-17T19:41:39.000000Z","inspection_violations":[],"inspection_per_units":[{"id":6423870,"change_date":"2023-09-20 21:40:00","inspection_id":"79687121","insp_unit_id":"197150139","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"3","insp_unit_license":"1M37478","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1HTSCAAN4YH266024","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:53:56.000000Z","updated_at":"2025-03-17T22:53:56.000000Z"}]},{"id":3644925,"change_date":"2023-08-01 21:42:00","inspection_id":"79296699","dot_number":"2483919","report_state":"TX","report_number":"6N6A9DJMHU","insp_date":"2023-07-29 00:00:00","insp_start_time":"1048","insp_end_time":"1108","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"300  E LOOP N","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"MARTIN HARDWARE","shipping_paper_number":"2307-659555","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-08-01 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":"9042074","transaction_code":"A","transaction_date":"2023-08-01 00:00:00","upload_date":"2023-08-01 00:00:00","upload_first_byte":"0","upload_dot_number":"02483919","upload_search_indicator":"M","census_search_date":"2023-08-01 21:42:00","snet_input_date":"2023-07-29 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-08-01 21:42:00","insp_carrier_name":"EFRAIN FRANCO","insp_carrier_street":"6219 JENSEN DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77026","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0852705","created_at":"2025-03-17T19:34:54.000000Z","updated_at":"2025-03-17T19:34:54.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5860789,"change_date":"2023-08-01 21:42:00","inspection_id":"79296699","insp_unit_id":"196307157","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"RMY4421","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3ALHCYBS8DDFG0405","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:17.000000Z","updated_at":"2025-03-17T22:49:17.000000Z"}]},{"id":2667996,"change_date":"2023-03-27 21:40:00","inspection_id":"78193610","dot_number":"2483919","report_state":"TX","report_number":"6JNA9DCRG5","insp_date":"2023-03-24 00:00:00","insp_start_time":"1030","insp_end_time":"1100","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"2900 N DURHAM DR","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"MARTIN'S HARDWARE","shipping_paper_number":"2303-551789","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-03-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"4","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8938474","transaction_code":"A","transaction_date":"2023-03-27 00:00:00","upload_date":"2023-03-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02483919","upload_search_indicator":"M","census_search_date":"2023-03-27 21:40:00","snet_input_date":"2023-03-24 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-03-27 21:40:00","insp_carrier_name":"EFRAIN FRANCO","insp_carrier_street":"6219 JENSEN DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77026","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0852705","created_at":"2025-03-17T19:15:51.000000Z","updated_at":"2025-03-17T19:15:51.000000Z","inspection_violations":[{"id":4101028,"change_date":"2023-03-27 21:40:00","inspection_id":"78193610","insp_violation_id":"251886789","seq_no":"1","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"1","insp_unit_id":"194081250","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:14.000000Z","updated_at":"2025-03-17T21:26:14.000000Z","normalized_code":"39348A"},{"id":4101029,"change_date":"2023-03-27 21:40:00","inspection_id":"78193610","insp_violation_id":"251886790","seq_no":"2","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"194081250","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:14.000000Z","updated_at":"2025-03-17T21:26:14.000000Z","normalized_code":"39395A"},{"id":4101030,"change_date":"2023-03-27 21:40:00","inspection_id":"78193610","insp_violation_id":"251886791","seq_no":"3","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"194081250","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:14.000000Z","updated_at":"2025-03-17T21:26:14.000000Z","normalized_code":"39353B"},{"id":4101031,"change_date":"2023-03-27 21:40:00","inspection_id":"78193610","insp_violation_id":"251886792","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"194081250","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:14.000000Z","updated_at":"2025-03-17T21:26:14.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":4296133,"change_date":"2023-03-27 21:40:00","inspection_id":"78193610","insp_unit_id":"194081250","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"1","insp_unit_license":"PKM6020","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FVHBXBS21HH88682","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:51.000000Z","updated_at":"2025-03-17T22:36:51.000000Z"}]},{"id":2504116,"change_date":"2023-03-03 21:41:00","inspection_id":"78007546","dot_number":"2483919","report_state":"TX","report_number":"6J189DBASI","insp_date":"2023-03-02 00:00:00","insp_start_time":"0855","insp_end_time":"0955","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0045 IN HARRIS CO. (24-72)","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"MARTINS HARDWARE AND LUMBER","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-03-03 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"7","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8920478","transaction_code":"A","transaction_date":"2023-03-03 00:00:00","upload_date":"2023-03-03 00:00:00","upload_first_byte":"0","upload_dot_number":"02483919","upload_search_indicator":"M","census_search_date":"2023-03-03 21:41:00","snet_input_date":"2023-03-02 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-03-03 21:41:00","insp_carrier_name":"EFRAIN FRANCO","insp_carrier_street":"6219 JENSEN DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77026","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0852705","created_at":"2025-03-17T19:12:54.000000Z","updated_at":"2025-03-17T19:12:54.000000Z","inspection_violations":[{"id":3852326,"change_date":"2023-03-03 21:41:00","inspection_id":"78007546","insp_violation_id":"251476309","seq_no":"1","part_no":"390","part_no_section":"21(a)","insp_viol_unit":"1","insp_unit_id":"193704420","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:04.000000Z","updated_at":"2025-03-17T21:25:04.000000Z","normalized_code":"39021A"},{"id":3852327,"change_date":"2023-03-03 21:41:00","inspection_id":"78007546","insp_violation_id":"251476310","seq_no":"2","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"193704420","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:04.000000Z","updated_at":"2025-03-17T21:25:04.000000Z","normalized_code":"39395A"},{"id":3852328,"change_date":"2023-03-03 21:41:00","inspection_id":"78007546","insp_violation_id":"251476311","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"193704420","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:04.000000Z","updated_at":"2025-03-17T21:25:04.000000Z","normalized_code":"3939A"},{"id":3852329,"change_date":"2023-03-03 21:41:00","inspection_id":"78007546","insp_violation_id":"251476312","seq_no":"4","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"193704420","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:04.000000Z","updated_at":"2025-03-17T21:25:04.000000Z","normalized_code":"39347E"},{"id":3852330,"change_date":"2023-03-03 21:41:00","inspection_id":"78007546","insp_violation_id":"251476313","seq_no":"5","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"193704420","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:04.000000Z","updated_at":"2025-03-17T21:25:04.000000Z","normalized_code":"39353B"},{"id":3852331,"change_date":"2023-03-03 21:41:00","inspection_id":"78007546","insp_violation_id":"251476314","seq_no":"6","part_no":"393","part_no_section":"55(d)(1)","insp_viol_unit":"1","insp_unit_id":"193704420","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:04.000000Z","updated_at":"2025-03-17T21:25:04.000000Z","normalized_code":"39355D1"},{"id":3852332,"change_date":"2023-03-03 21:41:00","inspection_id":"78007546","insp_violation_id":"251476315","seq_no":"7","part_no":"393","part_no_section":"50(d)","insp_viol_unit":"1","insp_unit_id":"193704420","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:04.000000Z","updated_at":"2025-03-17T21:25:04.000000Z","normalized_code":"39350D"}],"inspection_per_units":[{"id":4029762,"change_date":"2023-03-03 21:41:00","inspection_id":"78007546","insp_unit_id":"193704420","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"PKM6020","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FVHBXBS21HH88682","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:52.000000Z","updated_at":"2025-03-17T22:34:52.000000Z"}]},{"id":1800727,"change_date":"2022-11-22 21:41:00","inspection_id":"77204130","dot_number":"2483919","report_state":"TX","report_number":"6G2E9DBAPP","insp_date":"2022-11-15 00:00:00","insp_start_time":"1410","insp_end_time":"1440","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0069 IN HARRIS CO. (115-151","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"MARTINS HARDWARE AND LUMBER","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-11-22 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":"8833391","transaction_code":"A","transaction_date":"2022-11-22 00:00:00","upload_date":"2022-11-22 00:00:00","upload_first_byte":"0","upload_dot_number":"02483919","upload_search_indicator":"M","census_search_date":"2022-11-22 21:41:00","snet_input_date":"2022-11-15 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-11-22 21:41:00","insp_carrier_name":"EFRAIN FRANCO","insp_carrier_street":"6219 JENSEN DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77026","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0852705","created_at":"2025-03-17T18:59:56.000000Z","updated_at":"2025-03-17T18:59:56.000000Z","inspection_violations":[{"id":2816584,"change_date":"2022-11-22 21:41:00","inspection_id":"77204130","insp_violation_id":"249753785","seq_no":"1","part_no":"393","part_no_section":"55(d)(1)","insp_viol_unit":"1","insp_unit_id":"192096855","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:16.000000Z","updated_at":"2025-03-17T21:20:16.000000Z","normalized_code":"39355D1"}],"inspection_per_units":[{"id":2896744,"change_date":"2022-11-22 21:41:00","inspection_id":"77204130","insp_unit_id":"192096855","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"8","insp_unit_license":"1M37478","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1HTSCAAN4YH266024","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:26:50.000000Z","updated_at":"2025-03-17T22:26:50.000000Z"}]},{"id":1649925,"change_date":"2022-11-01 21:41:00","inspection_id":"77031168","dot_number":"2483919","report_state":"TX","report_number":"6FE89DCNT3","insp_date":"2022-10-22 00:00:00","insp_start_time":"0823","insp_end_time":"0840","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0610 IN HARRIS CO. (0-37)","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"MARTINEZ HARDWARE","shipping_paper_number":"2210943848","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-11-01 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8815650","transaction_code":"A","transaction_date":"2022-11-01 00:00:00","upload_date":"2022-11-01 00:00:00","upload_first_byte":"0","upload_dot_number":"02483919","upload_search_indicator":"M","census_search_date":"2022-11-01 21:41:00","snet_input_date":"2022-10-22 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-11-01 21:41:00","insp_carrier_name":"EFRAIN FRANCO","insp_carrier_street":"6219 JENSEN DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77026","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0852705","created_at":"2025-03-17T18:57:03.000000Z","updated_at":"2025-03-17T18:57:03.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2655030,"change_date":"2022-11-01 21:41:00","inspection_id":"77031168","insp_unit_id":"191755689","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"RMY4421","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3ALHCYBS8DDFG0405","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:25:13.000000Z","updated_at":"2025-03-17T22:25:13.000000Z"}]},{"id":1584446,"change_date":"2022-10-25 21:41:00","inspection_id":"76955956","dot_number":"2483919","report_state":"TX","report_number":"6FAA9DBT8U","insp_date":"2022-10-18 00:00:00","insp_start_time":"1029","insp_end_time":"1103","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"13500  EAST FWY S SR","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"MARTIN S HARDWARE","shipping_paper_number":"22109400389","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-24 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":"8807971","transaction_code":"C","transaction_date":"2022-10-25 00:00:00","upload_date":"2022-10-25 00:00:00","upload_first_byte":"0","upload_dot_number":"02483919","upload_search_indicator":null,"census_search_date":"2022-10-24 21:41:00","snet_input_date":"2022-10-18 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-10-24 21:41:00","insp_carrier_name":"EFRAIN FRANCO","insp_carrier_street":"6219 JENSEN DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77026","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0852705","created_at":"2025-03-17T18:55:54.000000Z","updated_at":"2025-03-17T18:55:54.000000Z","inspection_violations":[{"id":2490444,"change_date":"2022-10-25 21:41:00","inspection_id":"76955956","insp_violation_id":"249240306","seq_no":"1","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"191631450","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:41.000000Z","updated_at":"2025-03-17T21:18:41.000000Z","normalized_code":"39395A"},{"id":2490445,"change_date":"2022-10-25 21:41:00","inspection_id":"76955956","insp_violation_id":"249240307","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"191631450","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:41.000000Z","updated_at":"2025-03-17T21:18:41.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":2550123,"change_date":"2022-10-25 21:41:00","inspection_id":"76955956","insp_unit_id":"191631450","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"1M37478","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1HTSCAAN4YH266024","insp_unit_decal":"Y","insp_unit_decal_number":"31925770","created_at":"2025-03-17T22:24:30.000000Z","updated_at":"2025-03-17T22:24:30.000000Z"}]},{"id":1584700,"change_date":"2022-10-24 21:41:00","inspection_id":"76956241","dot_number":"2483919","report_state":"TX","report_number":"6F6H9DCK44","insp_date":"2022-10-14 00:00:00","insp_start_time":"1705","insp_end_time":"1720","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"6700  RANKIN 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-10-24 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":"8807772","transaction_code":"A","transaction_date":"2022-10-24 00:00:00","upload_date":"2022-10-24 00:00:00","upload_first_byte":"0","upload_dot_number":"02483919","upload_search_indicator":"M","census_search_date":"2022-10-24 21:41:00","snet_input_date":"2022-10-14 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-10-24 21:41:00","insp_carrier_name":"EFRAIN FRANCO","insp_carrier_street":"6219 JENSEN DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77026","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0852705","created_at":"2025-03-17T18:55:55.000000Z","updated_at":"2025-03-17T18:55:55.000000Z","inspection_violations":[{"id":2491227,"change_date":"2022-10-24 21:41:00","inspection_id":"76956241","insp_violation_id":"249211663","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"191605751","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:18:41.000000Z","updated_at":"2025-03-17T21:18:41.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":2550544,"change_date":"2022-10-24 21:41:00","inspection_id":"76956241","insp_unit_id":"191605751","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"RMY4421","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3ALHCYBS8DDFG0405","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:24:30.000000Z","updated_at":"2025-03-17T22:24:30.000000Z"}]},{"id":1127094,"change_date":"2022-08-24 21:39:00","inspection_id":"76425971","dot_number":"2483919","report_state":"TX","report_number":"6DNC9DBV4Z","insp_date":"2022-08-20 00:00:00","insp_start_time":"1220","insp_end_time":"1245","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0069 IN HARRIS CO. (115-151","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"MARTINS HARDWARE","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2022-08-24 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8753191","transaction_code":"A","transaction_date":"2022-08-24 00:00:00","upload_date":"2022-08-24 00:00:00","upload_first_byte":"0","upload_dot_number":"02483919","upload_search_indicator":"M","census_search_date":"2022-08-24 21:39:00","snet_input_date":"2022-08-20 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-08-24 21:39:00","insp_carrier_name":"EFRAIN FRANCO","insp_carrier_street":"6219 JENSEN DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77026","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0852705","created_at":"2025-03-17T18:47:33.000000Z","updated_at":"2025-03-17T18:47:33.000000Z","inspection_violations":[{"id":1780689,"change_date":"2022-08-24 21:39:00","inspection_id":"76425971","insp_violation_id":"247970131","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"190523064","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:18.000000Z","updated_at":"2025-03-17T21:15:18.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":1813008,"change_date":"2022-08-24 21:39:00","inspection_id":"76425971","insp_unit_id":"190523064","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"2","insp_unit_license":"RMY4421","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3ALHCYBS8DDFG0405","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:30.000000Z","updated_at":"2025-03-17T22:19:30.000000Z"}]},{"id":630974,"change_date":"2022-06-16 21:43:00","inspection_id":"75845202","dot_number":"2483919","report_state":"TX","report_number":"6BGD9DAXAY","insp_date":"2022-06-02 00:00:00","insp_start_time":"1335","insp_end_time":"1420","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0249 IN HARRIS CO. (450-470","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"MARTIN'S HARDWARE","shipping_paper_number":"3463372891","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-16 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"0","viol_total":"15","oos_total":"3","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"13","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8682534","transaction_code":"A","transaction_date":"2022-06-16 00:00:00","upload_date":"2022-06-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02483919","upload_search_indicator":"M","census_search_date":"2022-06-16 21:43:00","snet_input_date":"2022-06-02 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-06-16 21:43:00","insp_carrier_name":"EFRAIN FRANCO","insp_carrier_street":"6219 JENSEN DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77026","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0852705","created_at":"2025-03-17T18:38:49.000000Z","updated_at":"2025-03-17T18:38:49.000000Z","inspection_violations":[{"id":989901,"change_date":"2022-06-16 21:43:00","inspection_id":"75845202","insp_violation_id":"246528879","seq_no":"1","part_no":"390","part_no_section":"21(a)","insp_viol_unit":"1","insp_unit_id":"189304640","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:38.000000Z","updated_at":"2025-03-17T21:11:38.000000Z","normalized_code":"39021A"},{"id":989902,"change_date":"2022-06-16 21:43:00","inspection_id":"75845202","insp_violation_id":"246528880","seq_no":"2","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"189304640","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:38.000000Z","updated_at":"2025-03-17T21:11:38.000000Z","normalized_code":"39395A"},{"id":989903,"change_date":"2022-06-16 21:43:00","inspection_id":"75845202","insp_violation_id":"246528881","seq_no":"3","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"189304640","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:38.000000Z","updated_at":"2025-03-17T21:11:38.000000Z","normalized_code":"39395F"},{"id":989904,"change_date":"2022-06-16 21:43:00","inspection_id":"75845202","insp_violation_id":"246528882","seq_no":"4","part_no":"392","part_no_section":"8","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:11:38.000000Z","updated_at":"2025-03-17T21:11:38.000000Z","normalized_code":"3928"},{"id":989905,"change_date":"2022-06-16 21:43:00","inspection_id":"75845202","insp_violation_id":"246528883","seq_no":"5","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"189304640","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:38.000000Z","updated_at":"2025-03-17T21:11:38.000000Z","normalized_code":"39345B2"},{"id":989906,"change_date":"2022-06-16 21:43:00","inspection_id":"75845202","insp_violation_id":"246528884","seq_no":"6","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"189304640","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:11:38.000000Z","updated_at":"2025-03-17T21:11:38.000000Z","normalized_code":"39345B2"},{"id":989907,"change_date":"2022-06-16 21:43:00","inspection_id":"75845202","insp_violation_id":"246528885","seq_no":"7","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"189304640","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:38.000000Z","updated_at":"2025-03-17T21:11:38.000000Z","normalized_code":"3939A"},{"id":989908,"change_date":"2022-06-16 21:43:00","inspection_id":"75845202","insp_violation_id":"246528886","seq_no":"8","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"189304640","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:38.000000Z","updated_at":"2025-03-17T21:11:38.000000Z","normalized_code":"39311"},{"id":989909,"change_date":"2022-06-16 21:43:00","inspection_id":"75845202","insp_violation_id":"246528887","seq_no":"9","part_no":"393","part_no_section":"104(f)(3)","insp_viol_unit":"1","insp_unit_id":"189304640","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:38.000000Z","updated_at":"2025-03-17T21:11:38.000000Z","normalized_code":"393104F3"},{"id":989910,"change_date":"2022-06-16 21:43:00","inspection_id":"75845202","insp_violation_id":"246528888","seq_no":"10","part_no":"393","part_no_section":"110(b)","insp_viol_unit":"1","insp_unit_id":"189304640","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:11:38.000000Z","updated_at":"2025-03-17T21:11:38.000000Z","normalized_code":"393110B"},{"id":989911,"change_date":"2022-06-16 21:43:00","inspection_id":"75845202","insp_violation_id":"246528889","seq_no":"11","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"189304640","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:38.000000Z","updated_at":"2025-03-17T21:11:38.000000Z","normalized_code":"39311"},{"id":989912,"change_date":"2022-06-16 21:43:00","inspection_id":"75845202","insp_violation_id":"246528890","seq_no":"12","part_no":"393","part_no_section":"55(d)(1)","insp_viol_unit":"1","insp_unit_id":"189304640","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:38.000000Z","updated_at":"2025-03-17T21:11:38.000000Z","normalized_code":"39355D1"},{"id":989913,"change_date":"2022-06-16 21:43:00","inspection_id":"75845202","insp_violation_id":"246528891","seq_no":"13","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"189304640","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:38.000000Z","updated_at":"2025-03-17T21:11:38.000000Z","normalized_code":"39617C"},{"id":989914,"change_date":"2022-06-16 21:43:00","inspection_id":"75845202","insp_violation_id":"246528892","seq_no":"14","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"189304640","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:38.000000Z","updated_at":"2025-03-17T21:11:38.000000Z","normalized_code":"3965B"},{"id":989915,"change_date":"2022-06-16 21:43:00","inspection_id":"75845202","insp_violation_id":"246528893","seq_no":"15","part_no":"391","part_no_section":"11(b)(4)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:38.000000Z","updated_at":"2025-03-17T21:11:38.000000Z","normalized_code":"39111B4"}],"inspection_per_units":[{"id":1014357,"change_date":"2022-06-16 21:43:00","inspection_id":"75845202","insp_unit_id":"189304640","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"1","insp_unit_license":"PKM6019","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1HTWGAAR55J199771","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:25.000000Z","updated_at":"2025-03-17T22:14:25.000000Z"}]},{"id":361465,"change_date":"2022-05-10 21:40:00","inspection_id":"75524009","dot_number":"2483919","report_state":"TX","report_number":"6AMD9DFM0A","insp_date":"2022-05-03 00:00:00","insp_start_time":"1300","insp_end_time":"1322","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"200 E SAM HOUSTON TO","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"MARTINS HARDWARE","shipping_paper_number":"2205-808447","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-05-10 21:40: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":"8650451","transaction_code":"A","transaction_date":"2022-05-10 00:00:00","upload_date":"2022-05-10 00:00:00","upload_first_byte":"0","upload_dot_number":"02483919","upload_search_indicator":"M","census_search_date":"2022-05-10 21:40:00","snet_input_date":"2022-05-03 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-05-10 21:40:00","insp_carrier_name":"EFRAIN FRANCO","insp_carrier_street":"6219 JENSEN DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77026","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0852705","created_at":"2025-03-17T18:33:57.000000Z","updated_at":"2025-03-17T18:33:57.000000Z","inspection_violations":[],"inspection_per_units":[{"id":584691,"change_date":"2022-05-10 21:40:00","inspection_id":"75524009","insp_unit_id":"188614399","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"RMY4421","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3ALHCYBS8DDFG0405","insp_unit_decal":"Y","insp_unit_decal_number":"31250167","created_at":"2025-03-17T22:11:46.000000Z","updated_at":"2025-03-17T22:11:46.000000Z"}]},{"id":46241,"change_date":"2022-03-25 21:32:00","inspection_id":"75144413","dot_number":"2483919","report_state":"TX","report_number":"69HE9DCO5V","insp_date":"2022-03-23 00:00:00","insp_start_time":"1433","insp_end_time":"1507","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"6500  GREENS 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-03-25 21:32: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":"8601805","transaction_code":"A","transaction_date":"2022-03-25 00:00:00","upload_date":"2022-03-25 00:00:00","upload_first_byte":"0","upload_dot_number":"02483919","upload_search_indicator":"M","census_search_date":"2022-03-25 21:32:00","snet_input_date":"2022-03-23 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-03-25 21:32:00","insp_carrier_name":"EFRAIN FRANCO","insp_carrier_street":"6219 JENSEN DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77026","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0852705","created_at":"2025-03-17T18:28:25.000000Z","updated_at":"2025-03-17T18:28:25.000000Z","inspection_violations":[{"id":66309,"change_date":"2022-03-25 21:32:00","inspection_id":"75144413","insp_violation_id":"244791035","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"187831535","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:25.000000Z","updated_at":"2025-03-17T21:07:25.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":74718,"change_date":"2022-03-25 21:32:00","inspection_id":"75144413","insp_unit_id":"187831535","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"PKM6019","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1HTWGAAR55J199771","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:42.000000Z","updated_at":"2025-03-17T22:08:42.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/2483919\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/2483919\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/2483919\/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\/2483919\/inspections","per_page":100,"prev_page_url":null,"to":22,"total":22}