{"current_page":1,"data":[{"id":6982348,"change_date":"2024-10-17 21:42:00","inspection_id":"82932069","dot_number":"2540652","report_state":"TX","report_number":"6ZCF9DCESO","insp_date":"2024-10-09 00:00:00","insp_start_time":"1521","insp_end_time":"1700","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"2800  N LOOP E","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-10-17 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"127000","viol_total":"26","oos_total":"9","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"26","vehicle_oos_total":"9","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9404434","transaction_code":"A","transaction_date":"2024-10-17 00:00:00","upload_date":"2024-10-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02540652","upload_search_indicator":"M","census_search_date":"2024-10-17 21:42:00","snet_input_date":"2024-10-09 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-10-17 21:42:00","insp_carrier_name":"ALFREDO ALVA","insp_carrier_street":"9817 COSSEY RD APT#301","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77070","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0883802","created_at":"2025-03-17T20:41:45.000000Z","updated_at":"2025-03-17T20:41:45.000000Z","inspection_violations":[{"id":10891821,"change_date":"2024-10-17 21:42:00","inspection_id":"82932069","insp_violation_id":"262410268","seq_no":"18","part_no":"396","part_no_section":"3A1BOS","insp_viol_unit":"2","insp_unit_id":"203459435","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:58:48.000000Z","updated_at":"2025-03-17T21:58:48.000000Z","normalized_code":"3963A1BOS"},{"id":10891822,"change_date":"2024-10-17 21:42:00","inspection_id":"82932069","insp_violation_id":"262410269","seq_no":"19","part_no":"393","part_no_section":"47E","insp_viol_unit":"2","insp_unit_id":"203459435","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:48.000000Z","updated_at":"2025-03-17T21:58:48.000000Z","normalized_code":"39347E"},{"id":10891823,"change_date":"2024-10-17 21:42:00","inspection_id":"82932069","insp_violation_id":"262410270","seq_no":"20","part_no":"393","part_no_section":"47E","insp_viol_unit":"2","insp_unit_id":"203459435","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:48.000000Z","updated_at":"2025-03-17T21:58:48.000000Z","normalized_code":"39347E"},{"id":10891824,"change_date":"2024-10-17 21:42:00","inspection_id":"82932069","insp_violation_id":"262410271","seq_no":"21","part_no":"393","part_no_section":"47E","insp_viol_unit":"2","insp_unit_id":"203459435","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:48.000000Z","updated_at":"2025-03-17T21:58:48.000000Z","normalized_code":"39347E"},{"id":10891825,"change_date":"2024-10-17 21:42:00","inspection_id":"82932069","insp_violation_id":"262410272","seq_no":"22","part_no":"393","part_no_section":"47E","insp_viol_unit":"2","insp_unit_id":"203459435","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:48.000000Z","updated_at":"2025-03-17T21:58:48.000000Z","normalized_code":"39347E"},{"id":10891826,"change_date":"2024-10-17 21:42:00","inspection_id":"82932069","insp_violation_id":"262410273","seq_no":"23","part_no":"393","part_no_section":"9BRKLAMP","insp_viol_unit":"2","insp_unit_id":"203459435","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:58:48.000000Z","updated_at":"2025-03-17T21:58:48.000000Z","normalized_code":"3939BRKLAMP"},{"id":10891827,"change_date":"2024-10-17 21:42:00","inspection_id":"82932069","insp_violation_id":"262410274","seq_no":"24","part_no":"392","part_no_section":"2RG","insp_viol_unit":"2","insp_unit_id":"203459435","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:48.000000Z","updated_at":"2025-03-17T21:58:48.000000Z","normalized_code":"3922RG"},{"id":10891828,"change_date":"2024-10-17 21:42:00","inspection_id":"82932069","insp_violation_id":"262410275","seq_no":"26","part_no":"393","part_no_section":"53B","insp_viol_unit":"2","insp_unit_id":"203459435","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:48.000000Z","updated_at":"2025-03-17T21:58:48.000000Z","normalized_code":"39353B"},{"id":10891829,"change_date":"2024-10-17 21:42:00","inspection_id":"82932069","insp_violation_id":"262410276","seq_no":"27","part_no":"393","part_no_section":"207A","insp_viol_unit":"1","insp_unit_id":"203459434","insp_violation_category_id":"22","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:48.000000Z","updated_at":"2025-03-17T21:58:48.000000Z","normalized_code":"393207A"},{"id":10891830,"change_date":"2024-10-17 21:42:00","inspection_id":"82932069","insp_violation_id":"262410277","seq_no":"1","part_no":"393","part_no_section":"83G","insp_viol_unit":"1","insp_unit_id":"203459434","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:48.000000Z","updated_at":"2025-03-17T21:58:48.000000Z","normalized_code":"39383G"},{"id":10891831,"change_date":"2024-10-17 21:42:00","inspection_id":"82932069","insp_violation_id":"262410278","seq_no":"2","part_no":"396","part_no_section":"5B","insp_viol_unit":"1","insp_unit_id":"203459434","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:48.000000Z","updated_at":"2025-03-17T21:58:48.000000Z","normalized_code":"3965B"},{"id":10891832,"change_date":"2024-10-17 21:42:00","inspection_id":"82932069","insp_violation_id":"262410279","seq_no":"3","part_no":"393","part_no_section":"81","insp_viol_unit":"1","insp_unit_id":"203459434","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:48.000000Z","updated_at":"2025-03-17T21:58:48.000000Z","normalized_code":"39381"},{"id":10891833,"change_date":"2024-10-17 21:42:00","inspection_id":"82932069","insp_violation_id":"262410280","seq_no":"4","part_no":"393","part_no_section":"51","insp_viol_unit":"1","insp_unit_id":"203459434","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:58:48.000000Z","updated_at":"2025-03-17T21:58:48.000000Z","normalized_code":"39351"},{"id":10891834,"change_date":"2024-10-17 21:42:00","inspection_id":"82932069","insp_violation_id":"262410281","seq_no":"5","part_no":"393","part_no_section":"11UR","insp_viol_unit":"1","insp_unit_id":"203459434","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:48.000000Z","updated_at":"2025-03-17T21:58:48.000000Z","normalized_code":"39311UR"},{"id":10891835,"change_date":"2024-10-17 21:42:00","inspection_id":"82932069","insp_violation_id":"262410282","seq_no":"6","part_no":"393","part_no_section":"11LR","insp_viol_unit":"1","insp_unit_id":"203459434","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:48.000000Z","updated_at":"2025-03-17T21:58:48.000000Z","normalized_code":"39311LR"},{"id":10891836,"change_date":"2024-10-17 21:42:00","inspection_id":"82932069","insp_violation_id":"262410283","seq_no":"7","part_no":"396","part_no_section":"3A1","insp_viol_unit":"1","insp_unit_id":"203459434","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:48.000000Z","updated_at":"2025-03-17T21:58:48.000000Z","normalized_code":"3963A1"},{"id":10891837,"change_date":"2024-10-17 21:42:00","inspection_id":"82932069","insp_violation_id":"262410284","seq_no":"8","part_no":"396","part_no_section":"3A1-AR","insp_viol_unit":"1","insp_unit_id":"203459434","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:58:48.000000Z","updated_at":"2025-03-17T21:58:48.000000Z","normalized_code":"3963A1AR"},{"id":10891838,"change_date":"2024-10-17 21:42:00","inspection_id":"82932069","insp_violation_id":"262410285","seq_no":"9","part_no":"393","part_no_section":"48A","insp_viol_unit":"1","insp_unit_id":"203459434","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:58:48.000000Z","updated_at":"2025-03-17T21:58:48.000000Z","normalized_code":"39348A"},{"id":10891839,"change_date":"2024-10-17 21:42:00","inspection_id":"82932069","insp_violation_id":"262410286","seq_no":"10","part_no":"393","part_no_section":"48A","insp_viol_unit":"1","insp_unit_id":"203459434","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:48.000000Z","updated_at":"2025-03-17T21:58:48.000000Z","normalized_code":"39348A"},{"id":10891840,"change_date":"2024-10-17 21:42:00","inspection_id":"82932069","insp_violation_id":"262410287","seq_no":"11","part_no":"393","part_no_section":"53B","insp_viol_unit":"1","insp_unit_id":"203459434","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:48.000000Z","updated_at":"2025-03-17T21:58:48.000000Z","normalized_code":"39353B"},{"id":10891841,"change_date":"2024-10-17 21:42:00","inspection_id":"82932069","insp_violation_id":"262410288","seq_no":"12","part_no":"393","part_no_section":"45B2PC","insp_viol_unit":"1","insp_unit_id":"203459434","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:48.000000Z","updated_at":"2025-03-17T21:58:48.000000Z","normalized_code":"39345B2PC"},{"id":10891842,"change_date":"2024-10-17 21:42:00","inspection_id":"82932069","insp_violation_id":"262410289","seq_no":"13","part_no":"393","part_no_section":"45B2PC","insp_viol_unit":"1","insp_unit_id":"203459434","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:48.000000Z","updated_at":"2025-03-17T21:58:48.000000Z","normalized_code":"39345B2PC"},{"id":10891843,"change_date":"2024-10-17 21:42:00","inspection_id":"82932069","insp_violation_id":"262410290","seq_no":"14","part_no":"393","part_no_section":"45DLUV","insp_viol_unit":"1","insp_unit_id":"203459434","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:58:48.000000Z","updated_at":"2025-03-17T21:58:48.000000Z","normalized_code":"39345DLUV"},{"id":10891844,"change_date":"2024-10-17 21:42:00","inspection_id":"82932069","insp_violation_id":"262410291","seq_no":"15","part_no":"396","part_no_section":"3A1DSCB","insp_viol_unit":"1","insp_unit_id":"203459434","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:58:48.000000Z","updated_at":"2025-03-17T21:58:48.000000Z","normalized_code":"3963A1DSCB"},{"id":10891845,"change_date":"2024-10-17 21:42:00","inspection_id":"82932069","insp_violation_id":"262410292","seq_no":"16","part_no":"396","part_no_section":"3A1DSUJ","insp_viol_unit":"1","insp_unit_id":"203459434","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:58:48.000000Z","updated_at":"2025-03-17T21:58:48.000000Z","normalized_code":"3963A1DSUJ"},{"id":10891846,"change_date":"2024-10-17 21:42:00","inspection_id":"82932069","insp_violation_id":"262410293","seq_no":"17","part_no":"393","part_no_section":"207A","insp_viol_unit":"1","insp_unit_id":"203459434","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:58:48.000000Z","updated_at":"2025-03-17T21:58:48.000000Z","normalized_code":"393207A"}],"inspection_per_units":[{"id":11261869,"change_date":"2024-10-17 21:42:00","inspection_id":"82932069","insp_unit_id":"203459434","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"07","insp_unit_license":"1N51703","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2HSFHAER6VC020812","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:39:34.000000Z","updated_at":"2025-03-17T23:39:34.000000Z"},{"id":11261870,"change_date":"2024-10-17 21:42:00","inspection_id":"82932069","insp_unit_id":"203459435","insp_unit_type_id":"10","insp_unit_number":"2","insp_unit_make":"BRAZ","insp_unit_company":null,"insp_unit_license":"AB5665","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"4B9BKDG22HH054436","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:39:34.000000Z","updated_at":"2025-03-17T23:39:34.000000Z"}]},{"id":6177838,"change_date":"2024-07-09 21:43:00","inspection_id":"82073988","dot_number":"2540652","report_state":"TX","report_number":"6WLF9DJN6Q","insp_date":"2024-07-02 00:00:00","insp_start_time":"1554","insp_end_time":"1621","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"6200  BINGE 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":"2024-07-09 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"127000","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":"9320996","transaction_code":"A","transaction_date":"2024-07-09 00:00:00","upload_date":"2024-07-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02540652","upload_search_indicator":"M","census_search_date":"2024-07-09 21:43:00","snet_input_date":"2024-07-02 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-07-09 21:43:00","insp_carrier_name":"ALFREDO ALVA","insp_carrier_street":"9817 COSSEY RD APT#301","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77070","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0883802","created_at":"2025-03-17T20:25:03.000000Z","updated_at":"2025-03-17T20:25:03.000000Z","inspection_violations":[{"id":9593614,"change_date":"2024-07-09 21:43:00","inspection_id":"82073988","insp_violation_id":"260547209","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"201801286","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:52:24.000000Z","updated_at":"2025-03-17T21:52:24.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":9952241,"change_date":"2024-07-09 21:43:00","inspection_id":"82073988","insp_unit_id":"201801285","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"07","insp_unit_license":"1N51703","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2HSFHAER6VC020812","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:26:08.000000Z","updated_at":"2025-03-17T23:26:08.000000Z"},{"id":9952242,"change_date":"2024-07-09 21:43:00","inspection_id":"82073988","insp_unit_id":"201801286","insp_unit_type_id":"10","insp_unit_number":"2","insp_unit_make":"BRAZ","insp_unit_company":null,"insp_unit_license":"AB5665","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"4B9BKDG22HH054436","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:26:08.000000Z","updated_at":"2025-03-17T23:26:08.000000Z"}]},{"id":5217302,"change_date":"2024-03-06 21:40:00","inspection_id":"81030250","dot_number":"2540652","report_state":"TX","report_number":"6T3D9DCO42","insp_date":"2024-02-27 00:00:00","insp_start_time":"1332","insp_end_time":"1349","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"2800 W GULF BANK 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":"2024-03-05 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"127000","viol_total":"4","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9214143","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":"02540652","upload_search_indicator":"M","census_search_date":"2024-03-05 21:41:00","snet_input_date":"2024-02-27 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-03-05 21:41:00","insp_carrier_name":"ALFREDO ALVA","insp_carrier_street":"9817 COSSEY RD APT#301","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77070","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0883802","created_at":"2025-03-17T20:05:48.000000Z","updated_at":"2025-03-17T20:05:48.000000Z","inspection_violations":[{"id":8040503,"change_date":"2024-03-06 21:40:00","inspection_id":"81030250","insp_violation_id":"258241512","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"199788267","insp_violation_category_id":"29","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":"39617C"},{"id":8040504,"change_date":"2024-03-06 21:40:00","inspection_id":"81030250","insp_violation_id":"258241513","seq_no":"2","part_no":"393","part_no_section":"83(g)","insp_viol_unit":"1","insp_unit_id":"199788267","insp_violation_category_id":"27","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":"39383G"},{"id":8040505,"change_date":"2024-03-06 21:40:00","inspection_id":"81030250","insp_violation_id":"258241514","seq_no":"3","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"199788267","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:44:53.000000Z","updated_at":"2025-03-17T21:44:53.000000Z","normalized_code":"39375A3"},{"id":8040506,"change_date":"2024-03-06 21:40:00","inspection_id":"81030250","insp_violation_id":"258241515","seq_no":"4","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"199788268","insp_violation_category_id":"20","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":"39311"}],"inspection_per_units":[{"id":8401289,"change_date":"2024-03-06 21:40:00","inspection_id":"81030250","insp_unit_id":"199788267","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"07","insp_unit_license":"1N51703","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2HSFHAER6VC020812","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":8401290,"change_date":"2024-03-06 21:40:00","inspection_id":"81030250","insp_unit_id":"199788268","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BRAZ","insp_unit_company":null,"insp_unit_license":"AB5665","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"4B9BKDG22HH054436","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":5054478,"change_date":"2024-02-14 21:42:00","inspection_id":"80852956","dot_number":"2540652","report_state":"TX","report_number":"6SJE9DJNYP","insp_date":"2024-02-07 00:00:00","insp_start_time":"1447","insp_end_time":"1540","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"7900  STREAMSIDE DR","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-02-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"127000","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":"9196251","transaction_code":"A","transaction_date":"2024-02-14 00:00:00","upload_date":"2024-02-14 00:00:00","upload_first_byte":"0","upload_dot_number":"02540652","upload_search_indicator":"M","census_search_date":"2024-02-14 21:42:00","snet_input_date":"2024-02-07 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-02-14 21:42:00","insp_carrier_name":"ALFREDO ALVA","insp_carrier_street":"9817 COSSEY RD APT#301","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77070","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0883802","created_at":"2025-03-17T20:02:46.000000Z","updated_at":"2025-03-17T20:02:46.000000Z","inspection_violations":[{"id":7790661,"change_date":"2024-02-14 21:42:00","inspection_id":"80852956","insp_violation_id":"257846693","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"199429952","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:40.000000Z","updated_at":"2025-03-17T21:43:40.000000Z","normalized_code":"3922"},{"id":7790662,"change_date":"2024-02-14 21:42:00","inspection_id":"80852956","insp_violation_id":"257846694","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"199429952","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:40.000000Z","updated_at":"2025-03-17T21:43:40.000000Z","normalized_code":"3922"},{"id":7790663,"change_date":"2024-02-14 21:42:00","inspection_id":"80852956","insp_violation_id":"257846695","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"199429952","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:40.000000Z","updated_at":"2025-03-17T21:43:40.000000Z","normalized_code":"3922"},{"id":7790664,"change_date":"2024-02-14 21:42:00","inspection_id":"80852956","insp_violation_id":"257846696","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"199429952","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:40.000000Z","updated_at":"2025-03-17T21:43:40.000000Z","normalized_code":"3939A"},{"id":7790665,"change_date":"2024-02-14 21:42:00","inspection_id":"80852956","insp_violation_id":"257846697","seq_no":"5","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"199429952","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:40.000000Z","updated_at":"2025-03-17T21:43:40.000000Z","normalized_code":"3963A1"},{"id":7790666,"change_date":"2024-02-14 21:42:00","inspection_id":"80852956","insp_violation_id":"257846698","seq_no":"6","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"2","insp_unit_id":"199429953","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:43:40.000000Z","updated_at":"2025-03-17T21:43:40.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":8136163,"change_date":"2024-02-14 21:42:00","inspection_id":"80852956","insp_unit_id":"199429952","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"07","insp_unit_license":"1L44242","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3WKDDW9X63F386441","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:08:44.000000Z","updated_at":"2025-03-17T23:08:44.000000Z"},{"id":8136164,"change_date":"2024-02-14 21:42:00","inspection_id":"80852956","insp_unit_id":"199429953","insp_unit_type_id":"10","insp_unit_number":"2","insp_unit_make":"BRAZ","insp_unit_company":null,"insp_unit_license":"AB5665","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"4B9BKDG22HH054436","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:08:44.000000Z","updated_at":"2025-03-17T23:08:44.000000Z"}]},{"id":5053947,"change_date":"2024-02-14 21:42:00","inspection_id":"80852387","dot_number":"2540652","report_state":"TX","report_number":"6SI59DGQX4","insp_date":"2024-02-06 00:00:00","insp_start_time":"0520","insp_end_time":"0542","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"18400  TOMBALL PKWY","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-02-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"5","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9196107","transaction_code":"A","transaction_date":"2024-02-14 00:00:00","upload_date":"2024-02-14 00:00:00","upload_first_byte":"0","upload_dot_number":"02540652","upload_search_indicator":"M","census_search_date":"2024-02-14 21:42:00","snet_input_date":"2024-02-06 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-02-14 21:42:00","insp_carrier_name":"ALFREDO ALVA","insp_carrier_street":"9817 COSSEY RD APT#301","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77070","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0883802","created_at":"2025-03-17T20:02:46.000000Z","updated_at":"2025-03-17T20:02:46.000000Z","inspection_violations":[{"id":7788865,"change_date":"2024-02-14 21:42:00","inspection_id":"80852387","insp_violation_id":"257844194","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"199428827","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:40.000000Z","updated_at":"2025-03-17T21:43:40.000000Z","normalized_code":"3922"},{"id":7788866,"change_date":"2024-02-14 21:42:00","inspection_id":"80852387","insp_violation_id":"257844195","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"199428827","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:40.000000Z","updated_at":"2025-03-17T21:43:40.000000Z","normalized_code":"3922"},{"id":7788867,"change_date":"2024-02-14 21:42:00","inspection_id":"80852387","insp_violation_id":"257844196","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"199428827","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:40.000000Z","updated_at":"2025-03-17T21:43:40.000000Z","normalized_code":"3922"},{"id":7788868,"change_date":"2024-02-14 21:42:00","inspection_id":"80852387","insp_violation_id":"257844197","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"199428827","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:40.000000Z","updated_at":"2025-03-17T21:43:40.000000Z","normalized_code":"3939A"},{"id":7788869,"change_date":"2024-02-14 21:42:00","inspection_id":"80852387","insp_violation_id":"257844198","seq_no":"5","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"199428828","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:40.000000Z","updated_at":"2025-03-17T21:43:40.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8135277,"change_date":"2024-02-14 21:42:00","inspection_id":"80852387","insp_unit_id":"199428827","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"07","insp_unit_license":"1L44242","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2HSFHAER6VC020812","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:08:44.000000Z","updated_at":"2025-03-17T23:08:44.000000Z"},{"id":8135278,"change_date":"2024-02-14 21:42:00","inspection_id":"80852387","insp_unit_id":"199428828","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BRAZ","insp_unit_company":null,"insp_unit_license":"AB5665","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1GCEK14WX1Z318547","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:08:44.000000Z","updated_at":"2025-03-17T23:08:44.000000Z"}]},{"id":2400282,"change_date":"2023-02-17 21:40:00","inspection_id":"77889351","dot_number":"2540652","report_state":"TX","report_number":"6IL49DGQGW","insp_date":"2023-02-14 00:00:00","insp_start_time":"0424","insp_end_time":"0448","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"17900  TOMBALL PKWY","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-02-17 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"8907331","transaction_code":"A","transaction_date":"2023-02-17 00:00:00","upload_date":"2023-02-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02540652","upload_search_indicator":"M","census_search_date":"2023-02-17 21:40:00","snet_input_date":"2023-02-14 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-02-17 21:40:00","insp_carrier_name":"ALFREDO ALVA","insp_carrier_street":"9817 COSSEY RD APT#301","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77070","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0883802","created_at":"2025-03-17T19:11:01.000000Z","updated_at":"2025-03-17T19:11:01.000000Z","inspection_violations":[{"id":3696626,"change_date":"2023-02-17 21:40:00","inspection_id":"77889351","insp_violation_id":"251215070","seq_no":"1","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"1","insp_unit_id":"193468497","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:24.000000Z","updated_at":"2025-03-17T21:24:24.000000Z","normalized_code":"39375C"},{"id":3696627,"change_date":"2023-02-17 21:40:00","inspection_id":"77889351","insp_violation_id":"251215071","seq_no":"2","part_no":"393","part_no_section":"75(a)(1)","insp_viol_unit":"2","insp_unit_id":"193468498","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:24.000000Z","updated_at":"2025-03-17T21:24:24.000000Z","normalized_code":"39375A1"}],"inspection_per_units":[{"id":3862786,"change_date":"2023-02-17 21:40:00","inspection_id":"77889351","insp_unit_id":"193468497","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"09","insp_unit_license":"1L44242","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3WKDDW9X63F386441","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:40.000000Z","updated_at":"2025-03-17T22:33:40.000000Z"},{"id":3862787,"change_date":"2023-02-17 21:40:00","inspection_id":"77889351","insp_unit_id":"193468498","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BRAZ","insp_unit_company":null,"insp_unit_license":"AB5665","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1GCEK14WX1Z318547","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:40.000000Z","updated_at":"2025-03-17T22:33:40.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/2540652\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/2540652\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/2540652\/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\/2540652\/inspections","per_page":100,"prev_page_url":null,"to":6,"total":6}