{"current_page":1,"data":[{"id":11490004,"change_date":"2026-03-26 21:40:00","inspection_id":"87409673","dot_number":"4451281","report_state":"TX","report_number":"V262280309","insp_date":"2026-03-24 00:00:00","insp_start_time":"1611","insp_end_time":"1638","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"3231  CEDAR","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"MT","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-03-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"48000","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":"9897475","transaction_code":"A","transaction_date":"2026-03-26 00:00:00","upload_date":"2026-03-26 00:00:00","upload_first_byte":"0","upload_dot_number":"04451281","upload_search_indicator":"M","census_search_date":"2026-03-26 21:40:00","snet_input_date":"2026-03-24 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-03-26 21:40:00","insp_carrier_name":"ALFREDO PALMA GRANDE","insp_carrier_street":"5151 S WILLOW DR APT 147","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77035-4829","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1099607","created_at":"2026-03-29T09:54:19.000000Z","updated_at":"2026-04-06T09:33:48.000000Z","inspection_violations":[{"id":19399133,"change_date":"2026-03-26 21:40:00","inspection_id":"87409673","insp_violation_id":"272667022","seq_no":"1","part_no":"393","part_no_section":"70B1I","insp_viol_unit":"1","insp_unit_id":"212361486","insp_violation_category_id":"17","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-29T10:23:33.000000Z","updated_at":"2026-04-06T09:55:04.000000Z","normalized_code":"39370B1I"},{"id":19399134,"change_date":"2026-03-26 21:40:00","inspection_id":"87409673","insp_violation_id":"272667023","seq_no":"2","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"212361486","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-29T10:23:33.000000Z","updated_at":"2026-04-06T09:55:04.000000Z","normalized_code":"39378"},{"id":19399135,"change_date":"2026-03-26 21:40:00","inspection_id":"87409673","insp_violation_id":"272667024","seq_no":"3","part_no":"393","part_no_section":"79","insp_viol_unit":"1","insp_unit_id":"212361486","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-29T10:23:33.000000Z","updated_at":"2026-04-06T09:55:04.000000Z","normalized_code":"39379"},{"id":19399136,"change_date":"2026-03-26 21:40:00","inspection_id":"87409673","insp_violation_id":"272667025","seq_no":"4","part_no":"396","part_no_section":"5B","insp_viol_unit":"1","insp_unit_id":"212361486","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-29T10:23:33.000000Z","updated_at":"2026-04-06T09:55:04.000000Z","normalized_code":"3965B"}],"inspection_per_units":[{"id":19682851,"change_date":"2026-03-26 21:40:00","inspection_id":"87409673","insp_unit_id":"212361486","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"NA","insp_unit_license":"62N645N","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AA14Y3PW019779","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-29T09:51:03.000000Z","updated_at":"2026-04-06T09:12:59.000000Z"}]},{"id":11399406,"change_date":"2026-03-17 21:39:00","inspection_id":"87314365","dot_number":"4451281","report_state":"TX","report_number":"7DFB9DBTEG","insp_date":"2026-02-28 00:00:00","insp_start_time":"1110","insp_end_time":"1127","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"4200 S SAM HOUSTON E","county_code_state":"TX","county_code":"201","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"70221841","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-03-17 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9886445","transaction_code":"A","transaction_date":"2026-03-17 00:00:00","upload_date":"2026-03-17 00:00:00","upload_first_byte":"0","upload_dot_number":"04451281","upload_search_indicator":"M","census_search_date":"2026-03-17 21:39:00","snet_input_date":"2026-02-28 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-03-17 21:39:00","insp_carrier_name":"ALFREDO PALMA GRANDE","insp_carrier_street":"5151 S WILLOW DR APT 147","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77035-4829","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1099607","created_at":"2026-03-20T09:42:39.000000Z","updated_at":"2026-03-28T09:31:28.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19522809,"change_date":"2026-03-17 21:39:00","inspection_id":"87314365","insp_unit_id":"212184553","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"2422","insp_unit_license":"53P600N","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AA14Y3PW019779","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-20T09:19:29.000000Z","updated_at":"2026-03-28T09:05:49.000000Z"}]},{"id":10600371,"change_date":"2026-01-08 21:40:00","inspection_id":"86739708","dot_number":"4451281","report_state":"TX","report_number":"7BZA9DGPAJ","insp_date":"2026-01-07 00:00:00","insp_start_time":"1001","insp_end_time":"1030","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"2200  MACGREGOR DR","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-01-08 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"5","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9810092","transaction_code":"A","transaction_date":"2026-01-08 00:00:00","upload_date":"2026-01-08 00:00:00","upload_first_byte":"0","upload_dot_number":"04451281","upload_search_indicator":"M","census_search_date":"2026-01-08 21:40:00","snet_input_date":"2026-01-07 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-01-08 21:40:00","insp_carrier_name":"ALFREDO PALMA GRANDE","insp_carrier_street":"5151 S WILLOW DR APT 147","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77035-4829","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1099607","created_at":"2026-01-11T10:34:45.000000Z","updated_at":"2026-01-19T10:30:50.000000Z","inspection_violations":[{"id":17820531,"change_date":"2026-01-08 21:40:00","inspection_id":"86739708","insp_violation_id":"271089885","seq_no":"4","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"210980243","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-01-11T10:39:23.000000Z","updated_at":"2026-01-19T10:31:32.000000Z","normalized_code":"3939"},{"id":17820532,"change_date":"2026-01-08 21:40:00","inspection_id":"86739708","insp_violation_id":"271089886","seq_no":"5","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"210980243","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-11T10:39:23.000000Z","updated_at":"2026-01-19T10:31:32.000000Z","normalized_code":"3922RG"},{"id":17820528,"change_date":"2026-01-08 21:40:00","inspection_id":"86739708","insp_violation_id":"271089882","seq_no":"1","part_no":"396","part_no_section":"5B-HWSLIW","insp_viol_unit":"1","insp_unit_id":"210980243","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-01-11T10:39:23.000000Z","updated_at":"2026-01-19T10:31:32.000000Z","normalized_code":"3965BHWSLIW"},{"id":17820529,"change_date":"2026-01-08 21:40:00","inspection_id":"86739708","insp_violation_id":"271089883","seq_no":"2","part_no":"393","part_no_section":"51","insp_viol_unit":"1","insp_unit_id":"210980243","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-01-11T10:39:23.000000Z","updated_at":"2026-01-19T10:31:32.000000Z","normalized_code":"39351"},{"id":17820530,"change_date":"2026-01-08 21:40:00","inspection_id":"86739708","insp_violation_id":"271089884","seq_no":"3","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"210980243","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-11T10:39:23.000000Z","updated_at":"2026-01-19T10:31:32.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":17771402,"change_date":"2026-01-08 21:40:00","inspection_id":"86739708","insp_unit_id":"210980243","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"2422","insp_unit_license":"BRW1586","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AA14Y3PW019779","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-11T10:06:14.000000Z","updated_at":"2026-01-19T10:00:59.000000Z"}]},{"id":10558300,"change_date":"2026-01-02 21:35:00","inspection_id":"86695522","dot_number":"4451281","report_state":"TX","report_number":"V252152423","insp_date":"2025-12-30 00:00:00","insp_start_time":"1102","insp_end_time":"1139","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"14812  FM521","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"MT","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-01-02 21:35:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"9","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"9","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9803981","transaction_code":"A","transaction_date":"2026-01-02 00:00:00","upload_date":"2026-01-02 00:00:00","upload_first_byte":"0","upload_dot_number":"04451281","upload_search_indicator":"M","census_search_date":"2026-01-02 21:35:00","snet_input_date":"2025-12-30 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-01-02 21:35:00","insp_carrier_name":"ALFREDO PALMA GRANDE","insp_carrier_street":"5151 S WILLOW DR APT 147","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77035-4829","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1099607","created_at":"2026-01-05T10:33:38.000000Z","updated_at":"2026-01-13T10:30:31.000000Z","inspection_violations":[{"id":17733909,"change_date":"2026-01-02 21:35:00","inspection_id":"86695522","insp_violation_id":"270990738","seq_no":"3","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"210889871","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-05T10:37:11.000000Z","updated_at":"2026-01-13T10:31:11.000000Z","normalized_code":"39378"},{"id":17733910,"change_date":"2026-01-02 21:35:00","inspection_id":"86695522","insp_violation_id":"270990739","seq_no":"4","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"210889871","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-05T10:37:11.000000Z","updated_at":"2026-01-13T10:31:11.000000Z","normalized_code":"3939"},{"id":17733911,"change_date":"2026-01-02 21:35:00","inspection_id":"86695522","insp_violation_id":"270990740","seq_no":"1","part_no":"393","part_no_section":"209D","insp_viol_unit":"1","insp_unit_id":"210889871","insp_violation_category_id":"21","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2026-01-05T10:37:11.000000Z","updated_at":"2026-01-13T10:31:11.000000Z","normalized_code":"393209D"},{"id":17733912,"change_date":"2026-01-02 21:35:00","inspection_id":"86695522","insp_violation_id":"270990741","seq_no":"2","part_no":"393","part_no_section":"51","insp_viol_unit":"1","insp_unit_id":"210889871","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2026-01-05T10:37:11.000000Z","updated_at":"2026-01-13T10:31:11.000000Z","normalized_code":"39351"},{"id":17733913,"change_date":"2026-01-02 21:35:00","inspection_id":"86695522","insp_violation_id":"270990742","seq_no":"5","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"210889871","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-05T10:37:11.000000Z","updated_at":"2026-01-13T10:31:11.000000Z","normalized_code":"3939"},{"id":17733914,"change_date":"2026-01-02 21:35:00","inspection_id":"86695522","insp_violation_id":"270990743","seq_no":"6","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"210889871","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-05T10:37:11.000000Z","updated_at":"2026-01-13T10:31:11.000000Z","normalized_code":"3939"},{"id":17733915,"change_date":"2026-01-02 21:35:00","inspection_id":"86695522","insp_violation_id":"270990744","seq_no":"7","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"210889871","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2026-01-05T10:37:11.000000Z","updated_at":"2026-01-13T10:31:11.000000Z","normalized_code":"3939"},{"id":17733916,"change_date":"2026-01-02 21:35:00","inspection_id":"86695522","insp_violation_id":"270990745","seq_no":"8","part_no":"396","part_no_section":"5B","insp_viol_unit":"1","insp_unit_id":"210889871","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-05T10:37:11.000000Z","updated_at":"2026-01-13T10:31:11.000000Z","normalized_code":"3965B"},{"id":17733917,"change_date":"2026-01-02 21:35:00","inspection_id":"86695522","insp_violation_id":"270990746","seq_no":"9","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"210889871","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-05T10:37:11.000000Z","updated_at":"2026-01-13T10:31:11.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":17689014,"change_date":"2026-01-02 21:35:00","inspection_id":"86695522","insp_unit_id":"210889871","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"2422","insp_unit_license":"77U529N","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AA14Y3PW019779","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-05T10:05:08.000000Z","updated_at":"2026-01-13T10:00:42.000000Z"}]},{"id":10422772,"change_date":"2025-12-12 21:41:00","inspection_id":"86554088","dot_number":"4451281","report_state":"TX","report_number":"7B699DJYFH","insp_date":"2025-12-09 00:00:00","insp_start_time":"0910","insp_end_time":"0955","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"11000  ALMEDA RD","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"SPRINT SAND & CLAY","shipping_paper_number":"70209942","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-12-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"8","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"8","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9783918","transaction_code":"A","transaction_date":"2025-12-12 00:00:00","upload_date":"2025-12-12 00:00:00","upload_first_byte":"0","upload_dot_number":"04451281","upload_search_indicator":"M","census_search_date":"2025-12-12 21:41:00","snet_input_date":"2025-12-09 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-12-12 21:41:00","insp_carrier_name":"ALFREDO PALMA GRANDE","insp_carrier_street":"5151 S WILLOW DR APT 147","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77035-4829","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1099607","created_at":"2025-12-15T10:32:12.000000Z","updated_at":"2025-12-23T10:31:03.000000Z","inspection_violations":[{"id":17475611,"change_date":"2025-12-12 21:41:00","inspection_id":"86554088","insp_violation_id":"270657945","seq_no":"1","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"210582960","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-15T10:33:53.000000Z","updated_at":"2025-12-23T10:31:48.000000Z","normalized_code":"39347E"},{"id":17475612,"change_date":"2025-12-12 21:41:00","inspection_id":"86554088","insp_violation_id":"270657946","seq_no":"2","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"210582960","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-15T10:33:53.000000Z","updated_at":"2025-12-23T10:31:48.000000Z","normalized_code":"3922RG"},{"id":17475613,"change_date":"2025-12-12 21:41:00","inspection_id":"86554088","insp_violation_id":"270657947","seq_no":"3","part_no":"393","part_no_section":"75C","insp_viol_unit":"1","insp_unit_id":"210582960","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-15T10:33:53.000000Z","updated_at":"2025-12-23T10:31:48.000000Z","normalized_code":"39375C"},{"id":17475614,"change_date":"2025-12-12 21:41:00","inspection_id":"86554088","insp_violation_id":"270657948","seq_no":"4","part_no":"393","part_no_section":"75C","insp_viol_unit":"1","insp_unit_id":"210582960","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-15T10:33:53.000000Z","updated_at":"2025-12-23T10:31:48.000000Z","normalized_code":"39375C"},{"id":17475615,"change_date":"2025-12-12 21:41:00","inspection_id":"86554088","insp_violation_id":"270657949","seq_no":"5","part_no":"396","part_no_section":"3A1DSYE","insp_viol_unit":"1","insp_unit_id":"210582960","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-12-15T10:33:53.000000Z","updated_at":"2025-12-23T10:31:48.000000Z","normalized_code":"3963A1DSYE"},{"id":17475616,"change_date":"2025-12-12 21:41:00","inspection_id":"86554088","insp_violation_id":"270657950","seq_no":"6","part_no":"393","part_no_section":"47A","insp_viol_unit":"1","insp_unit_id":"210582960","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-15T10:33:53.000000Z","updated_at":"2025-12-23T10:31:48.000000Z","normalized_code":"39347A"},{"id":17475617,"change_date":"2025-12-12 21:41:00","inspection_id":"86554088","insp_violation_id":"270657951","seq_no":"7","part_no":"393","part_no_section":"209D","insp_viol_unit":"1","insp_unit_id":"210582960","insp_violation_category_id":"21","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-12-15T10:33:53.000000Z","updated_at":"2025-12-23T10:31:48.000000Z","normalized_code":"393209D"},{"id":17475618,"change_date":"2025-12-12 21:41:00","inspection_id":"86554088","insp_violation_id":"270657952","seq_no":"8","part_no":"393","part_no_section":"207A","insp_viol_unit":"1","insp_unit_id":"210582960","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-12-15T10:33:53.000000Z","updated_at":"2025-12-23T10:31:48.000000Z","normalized_code":"393207A"}],"inspection_per_units":[{"id":17433405,"change_date":"2025-12-12 21:41:00","inspection_id":"86554088","insp_unit_id":"210582960","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"88S486N","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AA14Y3PW019779","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-15T10:02:46.000000Z","updated_at":"2025-12-23T10:01:11.000000Z"}]},{"id":10148009,"change_date":"2025-11-07 21:40:00","inspection_id":"86266087","dot_number":"4451281","report_state":"TX","report_number":"V252048116","insp_date":"2025-11-06 00:00:00","insp_start_time":"0845","insp_end_time":"0937","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"5505 AVE N \/ FM 2218","county_code_state":"TX","county_code":"157","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"SPRINT SAND & CLAY","shipping_paper_number":"20428545","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-11-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"13","oos_total":"3","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"12","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9751950","transaction_code":"A","transaction_date":"2025-11-07 00:00:00","upload_date":"2025-11-07 00:00:00","upload_first_byte":"0","upload_dot_number":"04451281","upload_search_indicator":"M","census_search_date":"2025-11-07 21:40:00","snet_input_date":"2025-11-06 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-11-07 21:40:00","insp_carrier_name":"ALFREDO PALMA GRANDE","insp_carrier_street":"5151 S WILLOW DR APT 147","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77035-4829","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1099607","created_at":"2025-11-10T10:31:44.000000Z","updated_at":"2025-11-11T10:31:01.000000Z","inspection_violations":[{"id":16843033,"change_date":"2025-11-07 21:40:00","inspection_id":"86266087","insp_violation_id":"269815268","seq_no":"1","part_no":"391","part_no_section":"11B4","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"54","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-10T10:32:51.000000Z","updated_at":"2025-11-11T10:32:04.000000Z","normalized_code":"39111B4"},{"id":16843034,"change_date":"2025-11-07 21:40:00","inspection_id":"86266087","insp_violation_id":"269815269","seq_no":"2","part_no":"392","part_no_section":"9A2-C","insp_viol_unit":"1","insp_unit_id":"209909310","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-11-10T10:32:54.000000Z","updated_at":"2025-11-11T10:32:04.000000Z","normalized_code":"3929A2C"},{"id":16843035,"change_date":"2025-11-07 21:40:00","inspection_id":"86266087","insp_violation_id":"269815270","seq_no":"3","part_no":"393","part_no_section":"205C","insp_viol_unit":"1","insp_unit_id":"209909310","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-10T10:32:54.000000Z","updated_at":"2025-11-11T10:32:04.000000Z","normalized_code":"393205C"},{"id":16843036,"change_date":"2025-11-07 21:40:00","inspection_id":"86266087","insp_violation_id":"269815271","seq_no":"4","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"209909310","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-10T10:32:54.000000Z","updated_at":"2025-11-11T10:32:04.000000Z","normalized_code":"39347E"},{"id":16843037,"change_date":"2025-11-07 21:40:00","inspection_id":"86266087","insp_violation_id":"269815272","seq_no":"5","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"209909310","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-10T10:32:54.000000Z","updated_at":"2025-11-11T10:32:04.000000Z","normalized_code":"39347E"},{"id":16843038,"change_date":"2025-11-07 21:40:00","inspection_id":"86266087","insp_violation_id":"269815273","seq_no":"6","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"209909310","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-10T10:32:54.000000Z","updated_at":"2025-11-11T10:32:04.000000Z","normalized_code":"39347E"},{"id":16843039,"change_date":"2025-11-07 21:40:00","inspection_id":"86266087","insp_violation_id":"269815274","seq_no":"7","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"209909310","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-10T10:32:54.000000Z","updated_at":"2025-11-11T10:32:04.000000Z","normalized_code":"39347E"},{"id":16843040,"change_date":"2025-11-07 21:40:00","inspection_id":"86266087","insp_violation_id":"269815275","seq_no":"8","part_no":"393","part_no_section":"53B","insp_viol_unit":"1","insp_unit_id":"209909310","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-10T10:32:54.000000Z","updated_at":"2025-11-11T10:32:04.000000Z","normalized_code":"39353B"},{"id":16843041,"change_date":"2025-11-07 21:40:00","inspection_id":"86266087","insp_violation_id":"269815276","seq_no":"9","part_no":"393","part_no_section":"67C7","insp_viol_unit":"1","insp_unit_id":"209909310","insp_violation_category_id":"18","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-10T10:32:54.000000Z","updated_at":"2025-11-11T10:32:04.000000Z","normalized_code":"39367C7"},{"id":16843042,"change_date":"2025-11-07 21:40:00","inspection_id":"86266087","insp_violation_id":"269815277","seq_no":"10","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"209909310","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-10T10:32:54.000000Z","updated_at":"2025-11-11T10:32:04.000000Z","normalized_code":"39378"},{"id":16843043,"change_date":"2025-11-07 21:40:00","inspection_id":"86266087","insp_violation_id":"269815278","seq_no":"11","part_no":"393","part_no_section":"79","insp_viol_unit":"1","insp_unit_id":"209909310","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-10T10:32:54.000000Z","updated_at":"2025-11-11T10:32:04.000000Z","normalized_code":"39379"},{"id":16843044,"change_date":"2025-11-07 21:40:00","inspection_id":"86266087","insp_violation_id":"269815279","seq_no":"12","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"209909310","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-10T10:32:54.000000Z","updated_at":"2025-11-11T10:32:04.000000Z","normalized_code":"39617C"},{"id":16843045,"change_date":"2025-11-07 21:40:00","inspection_id":"86266087","insp_violation_id":"269815280","seq_no":"13","part_no":"396","part_no_section":"3A1BOS","insp_viol_unit":"1","insp_unit_id":"209909310","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-11-10T10:32:54.000000Z","updated_at":"2025-11-11T10:32:04.000000Z","normalized_code":"3963A1BOS"}],"inspection_per_units":[{"id":16894603,"change_date":"2025-11-07 21:40:00","inspection_id":"86266087","insp_unit_id":"209909310","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"2422","insp_unit_license":"15M443N","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AA14Y3PW019779","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-11-10T10:02:16.000000Z","updated_at":"2025-11-11T10:01:13.000000Z"}]},{"id":9623781,"change_date":"2025-09-11 21:42:00","inspection_id":"85714538","dot_number":"4451281","report_state":"TX","report_number":"V252012880","insp_date":"2025-09-05 00:00:00","insp_start_time":"1034","insp_end_time":"1107","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"14271 INDUSTRY ST","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"MT","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-09-08 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"48000","viol_total":"9","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"9","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9690168","transaction_code":"C","transaction_date":"2025-09-11 00:00:00","upload_date":"2025-09-11 00:00:00","upload_first_byte":"0","upload_dot_number":"04451281","upload_search_indicator":"M","census_search_date":"2025-09-08 21:38:00","snet_input_date":"2025-09-05 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-09-08 21:38:00","insp_carrier_name":"ALFREDO PALMA GRANDE","insp_carrier_street":"5151 S WILLOW DR APT 147","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77035-4829","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"1099607","created_at":"2025-09-10T10:46:14.000000Z","updated_at":"2025-09-16T10:47:08.000000Z","inspection_violations":[{"id":15814897,"change_date":"2025-09-11 21:42:00","inspection_id":"85714538","insp_violation_id":"268618174","seq_no":"1","part_no":"393","part_no_section":"104C","insp_viol_unit":"1","insp_unit_id":"208879384","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-14T11:57:04.000000Z","updated_at":"2025-09-14T11:57:04.000000Z","normalized_code":"393104C"},{"id":15814898,"change_date":"2025-09-11 21:42:00","inspection_id":"85714538","insp_violation_id":"268618175","seq_no":"2","part_no":"393","part_no_section":"104C","insp_viol_unit":"1","insp_unit_id":"208879384","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-14T11:57:04.000000Z","updated_at":"2025-09-14T11:57:04.000000Z","normalized_code":"393104C"},{"id":15814899,"change_date":"2025-09-11 21:42:00","inspection_id":"85714538","insp_violation_id":"268618176","seq_no":"3","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"208879384","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-14T11:57:04.000000Z","updated_at":"2025-09-14T11:57:04.000000Z","normalized_code":"39347E"},{"id":15814900,"change_date":"2025-09-11 21:42:00","inspection_id":"85714538","insp_violation_id":"268618177","seq_no":"4","part_no":"393","part_no_section":"53B","insp_viol_unit":"1","insp_unit_id":"208879384","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-14T11:57:04.000000Z","updated_at":"2025-09-14T11:57:04.000000Z","normalized_code":"39353B"},{"id":15814901,"change_date":"2025-09-11 21:42:00","inspection_id":"85714538","insp_violation_id":"268618178","seq_no":"5","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"208879384","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-14T11:57:04.000000Z","updated_at":"2025-09-14T11:57:04.000000Z","normalized_code":"39378"},{"id":15814902,"change_date":"2025-09-11 21:42:00","inspection_id":"85714538","insp_violation_id":"268618179","seq_no":"6","part_no":"393","part_no_section":"83G","insp_viol_unit":"1","insp_unit_id":"208879384","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-14T11:57:04.000000Z","updated_at":"2025-09-14T11:57:04.000000Z","normalized_code":"39383G"},{"id":15814903,"change_date":"2025-09-11 21:42:00","inspection_id":"85714538","insp_violation_id":"268618180","seq_no":"7","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"208879384","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-14T11:57:04.000000Z","updated_at":"2025-09-14T11:57:04.000000Z","normalized_code":"3939"},{"id":15814904,"change_date":"2025-09-11 21:42:00","inspection_id":"85714538","insp_violation_id":"268618181","seq_no":"8","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"208879384","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-14T11:57:04.000000Z","updated_at":"2025-09-14T11:57:04.000000Z","normalized_code":"3939"},{"id":15814905,"change_date":"2025-09-11 21:42:00","inspection_id":"85714538","insp_violation_id":"268618182","seq_no":"9","part_no":"396","part_no_section":"5B","insp_viol_unit":"1","insp_unit_id":"208879384","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-14T11:57:04.000000Z","updated_at":"2025-09-14T11:57:04.000000Z","normalized_code":"3965B"}],"inspection_per_units":[{"id":15956668,"change_date":"2025-09-11 21:42:00","inspection_id":"85714538","insp_unit_id":"208879384","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"2422","insp_unit_license":"GBT1363","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AE06Y34N019685","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-13T10:00:40.000000Z","updated_at":"2025-09-15T09:53:35.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/4451281\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/4451281\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/4451281\/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\/4451281\/inspections","per_page":100,"prev_page_url":null,"to":7,"total":7}