{"current_page":1,"data":[{"id":12634207,"change_date":"2026-08-04 21:40:00","inspection_id":"88605498","dot_number":"1266465","report_state":"TX","report_number":"7HOE9DFP86","insp_date":"2026-07-31 00:00:00","insp_start_time":"1426","insp_end_time":"1533","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"2300  STATE HIGHWAY","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"HOUSTON RAGS INC","shipping_paper_number":"MRSU9288804","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-08-04 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"98001","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":"10056523","transaction_code":"A","transaction_date":"2026-08-04 00:00:00","upload_date":"2026-08-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01266465","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2026-07-31 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-08-04 21:40:00","insp_carrier_name":"MAYOR TRANSPORTATION","insp_carrier_street":"5114 BERRY CREEK DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"495143","insp_interstate":"Y","insp_carrier_state_id":"0222114","created_at":"2026-08-07T09:39:55.000000Z","updated_at":"2026-08-12T09:34:10.000000Z","inspection_violations":[{"id":21995393,"change_date":"2026-08-04 21:40:00","inspection_id":"88605498","insp_violation_id":"275925123","seq_no":"1","part_no":"393","part_no_section":"45B2UV","insp_viol_unit":"1","insp_unit_id":"214981454","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-07T09:57:54.000000Z","updated_at":"2026-08-12T09:47:16.000000Z","normalized_code":"39345B2UV"},{"id":21995394,"change_date":"2026-08-04 21:40:00","inspection_id":"88605498","insp_violation_id":"275925124","seq_no":"2","part_no":"393","part_no_section":"45B2UV","insp_viol_unit":"2","insp_unit_id":"214981455","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-07T09:57:54.000000Z","updated_at":"2026-08-12T09:47:16.000000Z","normalized_code":"39345B2UV"},{"id":21995395,"change_date":"2026-08-04 21:40:00","inspection_id":"88605498","insp_violation_id":"275925125","seq_no":"3","part_no":"392","part_no_section":"2W","insp_viol_unit":"1","insp_unit_id":"214981454","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-08-07T09:57:54.000000Z","updated_at":"2026-08-12T09:47:16.000000Z","normalized_code":"3922W"},{"id":21995396,"change_date":"2026-08-04 21:40:00","inspection_id":"88605498","insp_violation_id":"275925126","seq_no":"4","part_no":"393","part_no_section":"75G-LOAD","insp_viol_unit":"1","insp_unit_id":"214981454","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-08-07T09:57:54.000000Z","updated_at":"2026-08-12T09:47:16.000000Z","normalized_code":"39375GLOAD"}],"inspection_per_units":[{"id":21931777,"change_date":"2026-08-04 21:40:00","inspection_id":"88605498","insp_unit_id":"214981454","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"06","insp_unit_license":"1M05385","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FVJBBCG84LM06409","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-08-07T09:18:50.000000Z","updated_at":"2026-08-12T09:07:59.000000Z"},{"id":21931778,"change_date":"2026-08-04 21:40:00","inspection_id":"88605498","insp_unit_id":"214981455","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"CIMC","insp_unit_company":"AAAZ 999999","insp_unit_license":"2821311","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"LJRC41253H1004834","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-08-07T09:18:50.000000Z","updated_at":"2026-08-12T09:07:59.000000Z"}]},{"id":12560913,"change_date":"2026-07-27 21:39:00","inspection_id":"88528487","dot_number":"1266465","report_state":"TX","report_number":"7HHC9DAP5A","insp_date":"2026-07-24 00:00:00","insp_start_time":"1218","insp_end_time":"1325","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"2400 E SH 255 PASADE","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"ACID CHEMICAL","shipping_paper_number":"126801","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-07-27 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"10045276","transaction_code":"A","transaction_date":"2026-07-27 00:00:00","upload_date":"2026-07-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01266465","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2026-07-24 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-07-27 21:39:00","insp_carrier_name":"MAYOR TRANSPORTATION","insp_carrier_street":"5114 BERRY CREEK DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"495143","insp_interstate":"Y","insp_carrier_state_id":"0222114","created_at":"2026-07-30T09:40:08.000000Z","updated_at":"2026-08-07T09:31:01.000000Z","inspection_violations":[{"id":21868510,"change_date":"2026-07-27 21:39:00","inspection_id":"88528487","insp_violation_id":"275759284","seq_no":"1","part_no":"392","part_no_section":"2W","insp_viol_unit":"1","insp_unit_id":"214840361","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-30T09:58:58.000000Z","updated_at":"2026-08-07T09:41:50.000000Z","normalized_code":"3922W"},{"id":21868511,"change_date":"2026-07-27 21:39:00","inspection_id":"88528487","insp_violation_id":"275759285","seq_no":"2","part_no":"392","part_no_section":"2W","insp_viol_unit":"1","insp_unit_id":"214840361","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-30T09:58:58.000000Z","updated_at":"2026-08-07T09:41:50.000000Z","normalized_code":"3922W"},{"id":21868512,"change_date":"2026-07-27 21:39:00","inspection_id":"88528487","insp_violation_id":"275759286","seq_no":"3","part_no":"396","part_no_section":"5B-HLOW","insp_viol_unit":"1","insp_unit_id":"214840361","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-30T09:58:58.000000Z","updated_at":"2026-08-07T09:41:50.000000Z","normalized_code":"3965BHLOW"},{"id":21868513,"change_date":"2026-07-27 21:39:00","inspection_id":"88528487","insp_violation_id":"275759287","seq_no":"4","part_no":"393","part_no_section":"75A1-TBSP","insp_viol_unit":"2","insp_unit_id":"214840362","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2026-07-30T09:58:58.000000Z","updated_at":"2026-08-07T09:41:50.000000Z","normalized_code":"39375A1TBSP"}],"inspection_per_units":[{"id":21810481,"change_date":"2026-07-27 21:39:00","inspection_id":"88528487","insp_unit_id":"214840361","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"1M05385","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FVJBBCG84LM06409","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-30T09:17:38.000000Z","updated_at":"2026-08-07T09:02:36.000000Z"},{"id":21810482,"change_date":"2026-07-27 21:39:00","inspection_id":"88528487","insp_unit_id":"214840362","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"CIMC","insp_unit_company":"AAAZ 999999","insp_unit_license":"2819717","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"LJRC41258G1034233","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-30T09:17:38.000000Z","updated_at":"2026-08-07T09:02:36.000000Z"}]},{"id":12503786,"change_date":"2026-07-20 21:40:00","inspection_id":"88467690","dot_number":"1266465","report_state":"TX","report_number":"7H9F9DNGAI","insp_date":"2026-07-16 00:00:00","insp_start_time":"1457","insp_end_time":"1535","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0146 IN HARRIS CO. (482-500","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-07-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"10038073","transaction_code":"A","transaction_date":"2026-07-20 00:00:00","upload_date":"2026-07-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01266465","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2026-07-16 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-07-20 21:40:00","insp_carrier_name":"MAYOR TRANSPORTATION","insp_carrier_street":"5114 BERRY CREEK DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"495143","insp_interstate":"Y","insp_carrier_state_id":"0222114","created_at":"2026-07-23T09:41:24.000000Z","updated_at":"2026-07-31T09:31:36.000000Z","inspection_violations":[{"id":21768589,"change_date":"2026-07-20 21:40:00","inspection_id":"88467690","insp_violation_id":"275628416","seq_no":"1","part_no":"393","part_no_section":"55E","insp_viol_unit":"2","insp_unit_id":"214726363","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-23T10:02:06.000000Z","updated_at":"2026-07-31T09:44:46.000000Z","normalized_code":"39355E"},{"id":21768590,"change_date":"2026-07-20 21:40:00","inspection_id":"88467690","insp_violation_id":"275628417","seq_no":"2","part_no":"393","part_no_section":"55D1","insp_viol_unit":"1","insp_unit_id":"214726362","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-07-23T10:02:06.000000Z","updated_at":"2026-07-31T09:44:46.000000Z","normalized_code":"39355D1"}],"inspection_per_units":[{"id":21715720,"change_date":"2026-07-20 21:40:00","inspection_id":"88467690","insp_unit_id":"214726362","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"08","insp_unit_license":"1M19731","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJGECK4BSAW0053","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-23T09:18:16.000000Z","updated_at":"2026-07-31T09:03:15.000000Z"},{"id":21715721,"change_date":"2026-07-20 21:40:00","inspection_id":"88467690","insp_unit_id":"214726363","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"CIMC","insp_unit_company":"AAAZ 999999","insp_unit_license":"2819717","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"LJRC41258G1034233","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-07-23T09:18:16.000000Z","updated_at":"2026-07-31T09:03:15.000000Z"}]},{"id":11357059,"change_date":"2026-03-12 21:40:00","inspection_id":"87275540","dot_number":"1266465","report_state":"TX","report_number":"7CYC9DUI9T","insp_date":"2026-02-11 00:00:00","insp_start_time":"1240","insp_end_time":"1312","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0146 IN HARRIS CO. (482-500","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":"MSDU4619251","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-12 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"9882019","transaction_code":"A","transaction_date":"2026-03-12 00:00:00","upload_date":"2026-03-12 00:00:00","upload_first_byte":"0","upload_dot_number":"01266465","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2026-02-11 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-03-12 21:40:00","insp_carrier_name":"MAYOR TRANSPORTATION","insp_carrier_street":"5114 BERRY CREEK DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"495143","insp_interstate":"Y","insp_carrier_state_id":"0222114","created_at":"2026-03-15T09:40:01.000000Z","updated_at":"2026-03-23T09:32:29.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19436965,"change_date":"2026-03-12 21:40:00","inspection_id":"87275540","insp_unit_id":"212109042","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"10","insp_unit_license":"1L41396","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJBBCK39LZ92985","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-15T09:19:43.000000Z","updated_at":"2026-03-23T09:10:58.000000Z"},{"id":19436966,"change_date":"2026-03-12 21:40:00","inspection_id":"87275540","insp_unit_id":"212109043","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"CIMC","insp_unit_company":"AAAZ 999999","insp_unit_license":"2920388","insp_unit_license_state":"MA","insp_unit_vehicle_id_number":"LJRC41254H1008097","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-15T09:19:43.000000Z","updated_at":"2026-03-23T09:10:58.000000Z"}]},{"id":10057734,"change_date":"2025-10-28 21:40:00","inspection_id":"86170940","dot_number":"1266465","report_state":"TX","report_number":"79WB9DGX1Y","insp_date":"2025-10-24 00:00:00","insp_start_time":"1126","insp_end_time":"1214","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"10000  RED BLUFF S\/B","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"HOUSTON RAGS INC","shipping_paper_number":"MSBU5297316","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-10-28 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"7","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9739371","transaction_code":"A","transaction_date":"2025-10-28 00:00:00","upload_date":"2025-10-28 00:00:00","upload_first_byte":"0","upload_dot_number":"01266465","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-10-24 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-10-28 21:40:00","insp_carrier_name":"MAYOR TRANSPORTATION","insp_carrier_street":"5114 BERRY CREEK DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"495143","insp_interstate":"Y","insp_carrier_state_id":"0222114","created_at":"2025-11-01T10:02:05.000000Z","updated_at":"2025-11-01T10:02:05.000000Z","inspection_violations":[{"id":16650731,"change_date":"2025-10-28 21:40:00","inspection_id":"86170940","insp_violation_id":"269571938","seq_no":"1","part_no":"393","part_no_section":"55D2","insp_viol_unit":"2","insp_unit_id":"209700615","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-31T10:18:11.000000Z","updated_at":"2025-11-01T10:17:04.000000Z","normalized_code":"39355D2"},{"id":16650732,"change_date":"2025-10-28 21:40:00","inspection_id":"86170940","insp_violation_id":"269571939","seq_no":"2","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"209700615","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-31T10:18:11.000000Z","updated_at":"2025-11-01T10:17:04.000000Z","normalized_code":"3939"},{"id":16650733,"change_date":"2025-10-28 21:40:00","inspection_id":"86170940","insp_violation_id":"269571940","seq_no":"3","part_no":"393","part_no_section":"9TS","insp_viol_unit":"2","insp_unit_id":"209700615","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-10-31T10:18:11.000000Z","updated_at":"2025-11-01T10:17:04.000000Z","normalized_code":"3939TS"},{"id":16650734,"change_date":"2025-10-28 21:40:00","inspection_id":"86170940","insp_violation_id":"269571941","seq_no":"4","part_no":"393","part_no_section":"45B2UV","insp_viol_unit":"1","insp_unit_id":"209700616","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-31T10:18:11.000000Z","updated_at":"2025-11-01T10:17:04.000000Z","normalized_code":"39345B2UV"},{"id":16650735,"change_date":"2025-10-28 21:40:00","inspection_id":"86170940","insp_violation_id":"269571942","seq_no":"5","part_no":"393","part_no_section":"45DLUV","insp_viol_unit":"1","insp_unit_id":"209700616","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-31T10:18:11.000000Z","updated_at":"2025-11-01T10:17:04.000000Z","normalized_code":"39345DLUV"},{"id":16650736,"change_date":"2025-10-28 21:40:00","inspection_id":"86170940","insp_violation_id":"269571943","seq_no":"6","part_no":"396","part_no_section":"3A1","insp_viol_unit":"1","insp_unit_id":"209700616","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-31T10:18:11.000000Z","updated_at":"2025-11-01T10:17:04.000000Z","normalized_code":"3963A1"},{"id":16650737,"change_date":"2025-10-28 21:40:00","inspection_id":"86170940","insp_violation_id":"269571944","seq_no":"7","part_no":"392","part_no_section":"2W","insp_viol_unit":"1","insp_unit_id":"209700616","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-31T10:18:11.000000Z","updated_at":"2025-11-01T10:17:04.000000Z","normalized_code":"3922W"}],"inspection_per_units":[{"id":16715493,"change_date":"2025-10-28 21:40:00","inspection_id":"86170940","insp_unit_id":"209700615","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"CIMC","insp_unit_company":"AAAZ 999999","insp_unit_license":"2819967","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"LJRC41257G1034207","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-31T09:47:13.000000Z","updated_at":"2025-11-01T09:46:33.000000Z"},{"id":16715494,"change_date":"2025-10-28 21:40:00","inspection_id":"86170940","insp_unit_id":"209700616","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"10","insp_unit_license":"1L41396","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJBBCK39LZ92985","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-31T09:47:13.000000Z","updated_at":"2025-11-01T09:46:33.000000Z"}]},{"id":9987412,"change_date":"2025-10-20 21:39:00","inspection_id":"86097007","dot_number":"1266465","report_state":"TX","report_number":"79M99DAP0U","insp_date":"2025-10-14 00:00:00","insp_start_time":"0946","insp_end_time":"1001","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"200 E SAM HOUSTON PK","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"ASIA CHEMICAL","shipping_paper_number":"RICFHM055500","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-10-20 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"9730337","transaction_code":"A","transaction_date":"2025-10-20 00:00:00","upload_date":"2025-10-20 00:00:00","upload_first_byte":"0","upload_dot_number":"01266465","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-10-14 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-10-20 21:39:00","insp_carrier_name":"MAYOR TRANSPORTATION","insp_carrier_street":"5114 BERRY CREEK DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"495143","insp_interstate":"Y","insp_carrier_state_id":"0222114","created_at":"2025-10-23T10:00:43.000000Z","updated_at":"2025-10-24T10:01:04.000000Z","inspection_violations":[{"id":16501996,"change_date":"2025-10-20 21:39:00","inspection_id":"86097007","insp_violation_id":"269404118","seq_no":"1","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"209559407","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-23T10:16:01.000000Z","updated_at":"2025-10-24T10:16:45.000000Z","normalized_code":"3939"}],"inspection_per_units":[{"id":16584766,"change_date":"2025-10-20 21:39:00","inspection_id":"86097007","insp_unit_id":"209559407","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"06","insp_unit_license":"1M05385","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FVJBBCG84LM06409","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-23T09:45:46.000000Z","updated_at":"2025-10-24T09:46:19.000000Z"},{"id":16584767,"change_date":"2025-10-20 21:39:00","inspection_id":"86097007","insp_unit_id":"209559408","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"CIMC","insp_unit_company":"AAAZ 999999","insp_unit_license":"2821311","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"LJRC41253H1004834","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-23T09:45:46.000000Z","updated_at":"2025-10-24T09:46:19.000000Z"}]},{"id":9584401,"change_date":"2025-09-03 21:40:00","inspection_id":"85673244","dot_number":"1266465","report_state":"TX","report_number":"789E9DTK9F","insp_date":"2025-08-26 00:00:00","insp_start_time":"1453","insp_end_time":"1507","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"200 E SAM HOUSTON PK","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"GLOBAL RESIN RESOURCES INC","shipping_paper_number":"123136","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-03 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"9684956","transaction_code":"A","transaction_date":"2025-09-03 00:00:00","upload_date":"2025-09-03 00:00:00","upload_first_byte":"0","upload_dot_number":"01266465","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-08-26 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-09-03 21:40:00","insp_carrier_name":"MAYOR TRANSPORTATION","insp_carrier_street":"5114 BERRY CREEK DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"495143","insp_interstate":"Y","insp_carrier_state_id":"0222114","created_at":"2025-09-06T10:43:31.000000Z","updated_at":"2025-09-10T10:44:58.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15822677,"change_date":"2025-09-03 21:40:00","inspection_id":"85673244","insp_unit_id":"208731708","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"10","insp_unit_license":"1L41396","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJBBCK39LZ92985","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-09T09:47:37.000000Z","updated_at":"2025-09-09T09:47:37.000000Z"},{"id":15822678,"change_date":"2025-09-03 21:40:00","inspection_id":"85673244","insp_unit_id":"208731709","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"CIMC","insp_unit_company":"AAAZ 999999","insp_unit_license":"2820097","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"LJRC41252G1034213","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-09T09:47:37.000000Z","updated_at":"2025-09-09T09:47:37.000000Z"}]},{"id":9584528,"change_date":"2025-09-03 21:40:00","inspection_id":"85673377","dot_number":"1266465","report_state":"TX","report_number":"788F9DCR4P","insp_date":"2025-08-25 00:00:00","insp_start_time":"1500","insp_end_time":"1511","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"7900  CLINTON","county_code_state":"TX","county_code":"201","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-09-03 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9684848","transaction_code":"A","transaction_date":"2025-09-03 00:00:00","upload_date":"2025-09-03 00:00:00","upload_first_byte":"0","upload_dot_number":"01266465","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-08-25 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-09-03 21:40:00","insp_carrier_name":"MAYOR TRANSPORTATION","insp_carrier_street":"5114 BERRY CREEK DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"495143","insp_interstate":"Y","insp_carrier_state_id":"0222114","created_at":"2025-09-06T10:43:31.000000Z","updated_at":"2025-09-10T10:44:59.000000Z","inspection_violations":[{"id":15657322,"change_date":"2025-09-03 21:40:00","inspection_id":"85673377","insp_violation_id":"268438909","seq_no":"1","part_no":"392","part_no_section":"2C","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-06T10:48:13.000000Z","updated_at":"2025-09-06T10:48:13.000000Z","normalized_code":"3922C"}],"inspection_per_units":[{"id":15822884,"change_date":"2025-09-03 21:40:00","inspection_id":"85673377","insp_unit_id":"208731933","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"1L41396","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJBBCK39LZ92985","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-09T09:47:37.000000Z","updated_at":"2025-09-09T09:47:37.000000Z"},{"id":15822885,"change_date":"2025-09-03 21:40:00","inspection_id":"85673377","insp_unit_id":"208731934","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CIMC","insp_unit_company":"34205","insp_unit_license":"2820095","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"LJRC41253G1034205","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-09T09:47:37.000000Z","updated_at":"2025-09-09T09:47:37.000000Z"}]},{"id":9512094,"change_date":"2025-08-26 21:40:00","inspection_id":"85597397","dot_number":"1266465","report_state":"TX","report_number":"78279DCT4L","insp_date":"2025-08-19 00:00:00","insp_start_time":"0708","insp_end_time":"0745","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"1600 W A ST.","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-08-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"9676387","transaction_code":"A","transaction_date":"2025-08-26 00:00:00","upload_date":"2025-08-26 00:00:00","upload_first_byte":"0","upload_dot_number":"01266465","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-08-19 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-08-26 21:40:00","insp_carrier_name":"MAYOR TRANSPORTATION","insp_carrier_street":"5114 BERRY CREEK DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"495143","insp_interstate":"Y","insp_carrier_state_id":"0222114","created_at":"2025-08-29T10:43:07.000000Z","updated_at":"2025-09-05T10:46:47.000000Z","inspection_violations":[{"id":15516966,"change_date":"2025-08-26 21:40:00","inspection_id":"85597397","insp_violation_id":"268262430","seq_no":"1","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"208594071","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-05T10:49:53.000000Z","updated_at":"2025-09-05T10:49:53.000000Z","normalized_code":"39617C"},{"id":15516967,"change_date":"2025-08-26 21:40:00","inspection_id":"85597397","insp_violation_id":"268262431","seq_no":"2","part_no":"393","part_no_section":"95B","insp_viol_unit":"1","insp_unit_id":"208594071","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-05T10:49:53.000000Z","updated_at":"2025-09-05T10:49:53.000000Z","normalized_code":"39395B"}],"inspection_per_units":[{"id":15696380,"change_date":"2025-08-26 21:40:00","inspection_id":"85597397","insp_unit_id":"208594071","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"05","insp_unit_license":"1L62700","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJGECK6BSAV9941","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-29T09:46:43.000000Z","updated_at":"2025-09-05T09:46:11.000000Z"},{"id":15696381,"change_date":"2025-08-26 21:40:00","inspection_id":"85597397","insp_unit_id":"208594072","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"CIMC","insp_unit_company":"AAAZ 999999","insp_unit_license":"2821313","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"LJRC41257H1004786","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-29T09:46:43.000000Z","updated_at":"2025-09-05T09:46:11.000000Z"}]},{"id":9403518,"change_date":"2025-08-13 21:39:00","inspection_id":"85483122","dot_number":"1266465","report_state":"TX","report_number":"77NE9DCV1Z","insp_date":"2025-08-04 00:00:00","insp_start_time":"1411","insp_end_time":"1437","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0146 IN HARRIS CO. (482-500","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-08-13 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":"9664410","transaction_code":"A","transaction_date":"2025-08-13 00:00:00","upload_date":"2025-08-13 00:00:00","upload_first_byte":"0","upload_dot_number":"01266465","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-08-04 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-08-13 21:39:00","insp_carrier_name":"MAYOR TRANSPORTATION","insp_carrier_street":"5114 BERRY CREEK DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"495143","insp_interstate":"Y","insp_carrier_state_id":"0222114","created_at":"2025-08-16T10:01:25.000000Z","updated_at":"2025-08-17T10:00:48.000000Z","inspection_violations":[{"id":15292595,"change_date":"2025-08-13 21:39:00","inspection_id":"85483122","insp_violation_id":"268008796","seq_no":"1","part_no":"393","part_no_section":"55D1","insp_viol_unit":"1","insp_unit_id":"208380754","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-16T10:45:11.000000Z","updated_at":"2025-08-17T10:44:34.000000Z","normalized_code":"39355D1"}],"inspection_per_units":[{"id":15498230,"change_date":"2025-08-13 21:39:00","inspection_id":"85483122","insp_unit_id":"208380754","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"08","insp_unit_license":"1M19731","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJGECK4BSAW0053","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-16T09:46:39.000000Z","updated_at":"2025-08-17T09:45:58.000000Z"}]},{"id":9451300,"change_date":"2025-08-19 21:40:00","inspection_id":"85533537","dot_number":"1266465","report_state":"TX","report_number":"77A89DUI23","insp_date":"2025-07-22 00:00:00","insp_start_time":"0750","insp_end_time":"0823","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0146 IN HARRIS CO. (482-500","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-08-19 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"9669431","transaction_code":"A","transaction_date":"2025-08-19 00:00:00","upload_date":"2025-08-19 00:00:00","upload_first_byte":"0","upload_dot_number":"01266465","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-07-22 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-08-19 21:40:00","insp_carrier_name":"MAYOR TRANSPORTATION","insp_carrier_street":"5114 BERRY CREEK DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"495143","insp_interstate":"Y","insp_carrier_state_id":"0222114","created_at":"2025-08-23T10:46:31.000000Z","updated_at":"2025-08-23T10:46:31.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15584752,"change_date":"2025-08-19 21:40:00","inspection_id":"85533537","insp_unit_id":"208473879","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"14","insp_unit_license":"1M16892","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJBBCG46LU71345","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-22T09:46:42.000000Z","updated_at":"2025-08-23T09:46:11.000000Z"},{"id":15584753,"change_date":"2025-08-19 21:40:00","inspection_id":"85533537","insp_unit_id":"208473880","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"CIMC","insp_unit_company":"AAAZ 999999","insp_unit_license":"2821313","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"LJRC41257H1004786","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-22T09:46:42.000000Z","updated_at":"2025-08-23T09:46:11.000000Z"}]},{"id":9206253,"change_date":"2025-07-21 21:41:00","inspection_id":"85275733","dot_number":"1266465","report_state":"TX","report_number":"775D9DNI1Z","insp_date":"2025-07-17 00:00:00","insp_start_time":"1243","insp_end_time":"1320","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0146 IN HARRIS CO. (482-500","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-07-21 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"9643965","transaction_code":"A","transaction_date":"2025-07-21 00:00:00","upload_date":"2025-07-21 00:00:00","upload_first_byte":"0","upload_dot_number":"01266465","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-07-17 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-07-21 21:41:00","insp_carrier_name":"MAYOR TRANSPORTATION","insp_carrier_street":"5114 BERRY CREEK DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"495143","insp_interstate":"Y","insp_carrier_state_id":"0222114","created_at":"2025-07-25T10:45:32.000000Z","updated_at":"2025-07-25T10:45:32.000000Z","inspection_violations":[{"id":14880552,"change_date":"2025-07-21 21:41:00","inspection_id":"85275733","insp_violation_id":"267543002","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"207989009","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-25T10:46:59.000000Z","updated_at":"2025-07-25T10:46:59.000000Z","normalized_code":"39378"},{"id":14880553,"change_date":"2025-07-21 21:41:00","inspection_id":"85275733","insp_violation_id":"267543003","seq_no":"2","part_no":"393","part_no_section":"11UR","insp_viol_unit":"1","insp_unit_id":"207989009","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-25T10:46:59.000000Z","updated_at":"2025-07-25T10:46:59.000000Z","normalized_code":"39311UR"},{"id":14880554,"change_date":"2025-07-21 21:41:00","inspection_id":"85275733","insp_violation_id":"267543004","seq_no":"3","part_no":"393","part_no_section":"207E","insp_viol_unit":"2","insp_unit_id":"207989010","insp_violation_category_id":"22","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-25T10:46:59.000000Z","updated_at":"2025-07-25T10:46:59.000000Z","normalized_code":"393207E"},{"id":14880555,"change_date":"2025-07-21 21:41:00","inspection_id":"85275733","insp_violation_id":"267543005","seq_no":"4","part_no":"393","part_no_section":"207E","insp_viol_unit":"2","insp_unit_id":"207989010","insp_violation_category_id":"22","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-25T10:46:59.000000Z","updated_at":"2025-07-25T10:46:59.000000Z","normalized_code":"393207E"}],"inspection_per_units":[{"id":15134903,"change_date":"2025-07-21 21:41:00","inspection_id":"85275733","insp_unit_id":"207989009","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"08","insp_unit_license":"1M19731","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJGECK4BSAW0053","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-24T09:45:37.000000Z","updated_at":"2025-07-25T09:46:10.000000Z"},{"id":15134904,"change_date":"2025-07-21 21:41:00","inspection_id":"85275733","insp_unit_id":"207989010","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"CIMC","insp_unit_company":"AAAZ 999999","insp_unit_license":"2820094","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"LJRC41259G1034192","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-24T09:45:38.000000Z","updated_at":"2025-07-25T09:46:10.000000Z"}]},{"id":9217493,"change_date":"2025-07-22 21:42:00","inspection_id":"85287470","dot_number":"1266465","report_state":"TX","report_number":"77399DAPTD","insp_date":"2025-07-15 00:00:00","insp_start_time":"0928","insp_end_time":"1006","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"200 E SAM HOUSTON PK","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"ASIA CHEMICAL CORP","shipping_paper_number":"122646","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-07-22 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"6","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9644703","transaction_code":"A","transaction_date":"2025-07-22 00:00:00","upload_date":"2025-07-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01266465","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-07-15 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-07-22 21:42:00","insp_carrier_name":"MAYOR TRANSPORTATION","insp_carrier_street":"5114 BERRY CREEK DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"495143","insp_interstate":"Y","insp_carrier_state_id":"0222114","created_at":"2025-07-25T10:46:01.000000Z","updated_at":"2025-07-27T10:41:05.000000Z","inspection_violations":[{"id":14909022,"change_date":"2025-07-22 21:42:00","inspection_id":"85287470","insp_violation_id":"267575893","seq_no":"1","part_no":"393","part_no_section":"55D1","insp_viol_unit":"1","insp_unit_id":"208015249","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-25T10:47:42.000000Z","updated_at":"2025-07-26T10:42:55.000000Z","normalized_code":"39355D1"},{"id":14909023,"change_date":"2025-07-22 21:42:00","inspection_id":"85287470","insp_violation_id":"267575894","seq_no":"2","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"208015249","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-25T10:47:42.000000Z","updated_at":"2025-07-26T10:42:55.000000Z","normalized_code":"39360C"},{"id":14909024,"change_date":"2025-07-22 21:42:00","inspection_id":"85287470","insp_violation_id":"267575895","seq_no":"3","part_no":"393","part_no_section":"9TS","insp_viol_unit":"2","insp_unit_id":"208015250","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-07-25T10:47:42.000000Z","updated_at":"2025-07-26T10:42:55.000000Z","normalized_code":"3939TS"},{"id":14909025,"change_date":"2025-07-22 21:42:00","inspection_id":"85287470","insp_violation_id":"267575896","seq_no":"4","part_no":"393","part_no_section":"19","insp_viol_unit":"2","insp_unit_id":"208015250","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-25T10:47:42.000000Z","updated_at":"2025-07-26T10:42:55.000000Z","normalized_code":"39319"},{"id":14909026,"change_date":"2025-07-22 21:42:00","inspection_id":"85287470","insp_violation_id":"267575897","seq_no":"5","part_no":"396","part_no_section":"3A1","insp_viol_unit":"2","insp_unit_id":"208015250","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-25T10:47:42.000000Z","updated_at":"2025-07-26T10:42:55.000000Z","normalized_code":"3963A1"},{"id":14909027,"change_date":"2025-07-22 21:42:00","inspection_id":"85287470","insp_violation_id":"267575898","seq_no":"6","part_no":"396","part_no_section":"3A1B","insp_viol_unit":"1","insp_unit_id":"208015249","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-07-25T10:47:42.000000Z","updated_at":"2025-07-26T10:42:55.000000Z","normalized_code":"3963A1B"}],"inspection_per_units":[{"id":15159034,"change_date":"2025-07-22 21:42:00","inspection_id":"85287470","insp_unit_id":"208015249","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"14","insp_unit_license":"1M16892","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJBBCG46LU71345","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-25T09:46:43.000000Z","updated_at":"2025-07-26T09:46:10.000000Z"},{"id":15159035,"change_date":"2025-07-22 21:42:00","inspection_id":"85287470","insp_unit_id":"208015250","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"CIMC","insp_unit_company":"AAAZ 999999","insp_unit_license":"2819714","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"LJRC41251G1034218","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-25T09:46:43.000000Z","updated_at":"2025-07-26T09:46:10.000000Z"}]},{"id":8973631,"change_date":"2025-06-24 21:41:00","inspection_id":"85031067","dot_number":"1266465","report_state":"TX","report_number":"76499DNI09","insp_date":"2025-06-10 00:00:00","insp_start_time":"0852","insp_end_time":"0926","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0146 IN HARRIS CO. (482-500","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-06-24 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"7","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9614953","transaction_code":"A","transaction_date":"2025-06-24 00:00:00","upload_date":"2025-06-24 00:00:00","upload_first_byte":"0","upload_dot_number":"01266465","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-06-10 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-06-24 21:41:00","insp_carrier_name":"MAYOR TRANSPORTATION","insp_carrier_street":"5114 BERRY CREEK DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"495143","insp_interstate":"Y","insp_carrier_state_id":"0222114","created_at":"2025-06-28T10:00:54.000000Z","updated_at":"2025-06-28T10:00:54.000000Z","inspection_violations":[{"id":14419993,"change_date":"2025-06-24 21:41:00","inspection_id":"85031067","insp_violation_id":"267017172","seq_no":"1","part_no":"393","part_no_section":"95A","insp_viol_unit":"1","insp_unit_id":"207531878","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-27T10:17:26.000000Z","updated_at":"2025-06-28T10:17:49.000000Z","normalized_code":"39395A"},{"id":14419994,"change_date":"2025-06-24 21:41:00","inspection_id":"85031067","insp_violation_id":"267017173","seq_no":"2","part_no":"393","part_no_section":"55D2","insp_viol_unit":"1","insp_unit_id":"207531878","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-27T10:17:26.000000Z","updated_at":"2025-06-28T10:17:49.000000Z","normalized_code":"39355D2"},{"id":14419995,"change_date":"2025-06-24 21:41:00","inspection_id":"85031067","insp_violation_id":"267017174","seq_no":"3","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"207531878","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-27T10:17:26.000000Z","updated_at":"2025-06-28T10:17:49.000000Z","normalized_code":"3939"},{"id":14419996,"change_date":"2025-06-24 21:41:00","inspection_id":"85031067","insp_violation_id":"267017175","seq_no":"4","part_no":"393","part_no_section":"9TS","insp_viol_unit":"2","insp_unit_id":"207531879","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-06-27T10:17:26.000000Z","updated_at":"2025-06-28T10:17:49.000000Z","normalized_code":"3939TS"},{"id":14419997,"change_date":"2025-06-24 21:41:00","inspection_id":"85031067","insp_violation_id":"267017176","seq_no":"5","part_no":"393","part_no_section":"9TS","insp_viol_unit":"2","insp_unit_id":"207531879","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-27T10:17:26.000000Z","updated_at":"2025-06-28T10:17:49.000000Z","normalized_code":"3939TS"},{"id":14419998,"change_date":"2025-06-24 21:41:00","inspection_id":"85031067","insp_violation_id":"267017177","seq_no":"6","part_no":"393","part_no_section":"19","insp_viol_unit":"2","insp_unit_id":"207531879","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-27T10:17:26.000000Z","updated_at":"2025-06-28T10:17:49.000000Z","normalized_code":"39319"},{"id":14419999,"change_date":"2025-06-24 21:41:00","inspection_id":"85031067","insp_violation_id":"267017178","seq_no":"7","part_no":"393","part_no_section":"19","insp_viol_unit":"2","insp_unit_id":"207531879","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-27T10:17:26.000000Z","updated_at":"2025-06-28T10:17:49.000000Z","normalized_code":"39319"}],"inspection_per_units":[{"id":14712549,"change_date":"2025-06-24 21:41:00","inspection_id":"85031067","insp_unit_id":"207531878","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"N\/A","insp_unit_license":"1M16892","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJBBCG46LU71345","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-27T09:46:39.000000Z","updated_at":"2025-06-28T09:45:56.000000Z"},{"id":14712550,"change_date":"2025-06-24 21:41:00","inspection_id":"85031067","insp_unit_id":"207531879","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"CIMC","insp_unit_company":"AAAZ 999999","insp_unit_license":"2820097","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"LJRC41252G1034213","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-27T09:46:39.000000Z","updated_at":"2025-06-28T09:45:56.000000Z"}]},{"id":8703817,"change_date":"2025-05-21 21:42:00","inspection_id":"84744868","dot_number":"1266465","report_state":"TX","report_number":"75689DNN20","insp_date":"2025-05-07 00:00:00","insp_start_time":"0846","insp_end_time":"0911","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0225 IN HARRIS CO. (686-700","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":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-21 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"9585251","transaction_code":"A","transaction_date":"2025-05-21 00:00:00","upload_date":"2025-05-21 00:00:00","upload_first_byte":"0","upload_dot_number":"01266465","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-05-07 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-05-21 21:42:00","insp_carrier_name":"MAYOR TRANSPORTATION","insp_carrier_street":"5114 BERRY CREEK DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"495143","insp_interstate":"Y","insp_carrier_state_id":"0222114","created_at":"2025-05-24T10:04:30.000000Z","updated_at":"2025-05-25T10:06:54.000000Z","inspection_violations":[{"id":13873153,"change_date":"2025-05-21 21:42:00","inspection_id":"84744868","insp_violation_id":"266385181","seq_no":"2","part_no":"393","part_no_section":"55D1","insp_viol_unit":"1","insp_unit_id":"206995511","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-24T10:28:16.000000Z","updated_at":"2025-05-25T10:26:04.000000Z","normalized_code":"39355D1"},{"id":13873152,"change_date":"2025-05-21 21:42:00","inspection_id":"84744868","insp_violation_id":"266385180","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"206995511","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-24T10:28:16.000000Z","updated_at":"2025-05-25T10:26:04.000000Z","normalized_code":"39378"}],"inspection_per_units":[{"id":14223156,"change_date":"2025-05-21 21:42:00","inspection_id":"84744868","insp_unit_id":"206995511","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"08","insp_unit_license":"1M19731","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJGECK4BSAW0053","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-24T09:49:53.000000Z","updated_at":"2025-05-25T09:52:39.000000Z"},{"id":14223157,"change_date":"2025-05-21 21:42:00","inspection_id":"84744868","insp_unit_id":"206995512","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"CIMC","insp_unit_company":"04834","insp_unit_license":"2821311","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"LJRC41253H1004834","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-24T09:49:53.000000Z","updated_at":"2025-05-25T09:52:39.000000Z"}]},{"id":8514304,"change_date":"2025-04-30 21:52:00","inspection_id":"84545437","dot_number":"1266465","report_state":"TX","report_number":"74XD9DAPQ0","insp_date":"2025-04-28 00:00:00","insp_start_time":"1304","insp_end_time":"1328","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"200 E SAM HOUSTON PK","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"ASIA CHEMICAL","shipping_paper_number":"121511","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-04-30 21:52:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9564678","transaction_code":"A","transaction_date":"2025-04-30 00:00:00","upload_date":"2025-04-30 00:00:00","upload_first_byte":"0","upload_dot_number":"01266465","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-04-28 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-04-30 21:52:00","insp_carrier_name":"MAYOR TRANSPORTATION","insp_carrier_street":"5114 BERRY CREEK DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"495143","insp_interstate":"Y","insp_carrier_state_id":"0222114","created_at":"2025-05-02T13:51:13.000000Z","updated_at":"2025-05-04T10:40:47.000000Z","inspection_violations":[{"id":13477986,"change_date":"2025-04-30 21:52:00","inspection_id":"84545437","insp_violation_id":"265932868","seq_no":"1","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"206578545","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-02T14:15:51.000000Z","updated_at":"2025-05-03T11:19:47.000000Z","normalized_code":"39617C"},{"id":13477987,"change_date":"2025-04-30 21:52:00","inspection_id":"84545437","insp_violation_id":"265932869","seq_no":"2","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"206578545","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-02T14:15:51.000000Z","updated_at":"2025-05-03T11:19:47.000000Z","normalized_code":"39311"},{"id":13477988,"change_date":"2025-04-30 21:52:00","inspection_id":"84545437","insp_violation_id":"265932870","seq_no":"3","part_no":"393","part_no_section":"9BRKLAMP","insp_viol_unit":"2","insp_unit_id":"206578546","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-05-02T14:15:51.000000Z","updated_at":"2025-05-03T11:19:47.000000Z","normalized_code":"3939BRKLAMP"}],"inspection_per_units":[{"id":13841028,"change_date":"2025-04-30 21:52:00","inspection_id":"84545437","insp_unit_id":"206578545","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"05","insp_unit_license":"1L62700","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJGECK6BSAV9941","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-03T10:26:16.000000Z","updated_at":"2025-05-04T10:14:23.000000Z"},{"id":13841029,"change_date":"2025-04-30 21:52:00","inspection_id":"84545437","insp_unit_id":"206578546","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"CIMC","insp_unit_company":"AAAZ 999999","insp_unit_license":"2819712","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"LJRC41254G1034200","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-03T10:26:16.000000Z","updated_at":"2025-05-04T10:14:23.000000Z"}]},{"id":8298212,"change_date":"2025-04-04 21:41:00","inspection_id":"84317633","dot_number":"1266465","report_state":"TX","report_number":"747C9DBV1O","insp_date":"2025-04-02 00:00:00","insp_start_time":"1156","insp_end_time":"1212","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"4500  DACOMA","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-04-04 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":"9541344","transaction_code":"A","transaction_date":"2025-04-04 00:00:00","upload_date":"2025-04-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01266465","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2025-04-02 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-04-04 21:41:00","insp_carrier_name":"MAYOR TRANSPORTATION","insp_carrier_street":"5114 BERRY CREEK DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"495143","insp_interstate":"Y","insp_carrier_state_id":"0222114","created_at":"2025-04-07T10:22:18.000000Z","updated_at":"2025-04-08T10:09:49.000000Z","inspection_violations":[{"id":13048584,"change_date":"2025-04-04 21:41:00","inspection_id":"84317633","insp_violation_id":"265448068","seq_no":"1","part_no":"393","part_no_section":"11TL","insp_viol_unit":"1","insp_unit_id":"206162060","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-07T10:51:44.000000Z","updated_at":"2025-04-07T10:59:45.000000Z","normalized_code":"39311TL"},{"id":13048585,"change_date":"2025-04-04 21:41:00","inspection_id":"84317633","insp_violation_id":"265448069","seq_no":"2","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"206162060","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-07T10:51:44.000000Z","updated_at":"2025-04-07T10:59:45.000000Z","normalized_code":"39311"}],"inspection_per_units":[{"id":13454664,"change_date":"2025-04-04 21:41:00","inspection_id":"84317633","insp_unit_id":"206162060","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"09","insp_unit_license":"1L41394","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJA6CK57LX43160","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-07T10:12:47.000000Z","updated_at":"2025-04-08T10:00:58.000000Z"}]},{"id":7104600,"change_date":"2024-11-04 21:40:00","inspection_id":"83061812","dot_number":"1266465","report_state":"TX","report_number":"6ZXD9DME39","insp_date":"2024-10-30 00:00:00","insp_start_time":"1322","insp_end_time":"1347","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0146 IN HARRIS CO. (482-500","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-11-01 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"9416788","transaction_code":"C","transaction_date":"2024-11-01 00:00:00","upload_date":"2024-11-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01266465","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-10-30 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-11-01 21:40:00","insp_carrier_name":"MAYOR TRANSPORTATION","insp_carrier_street":"5114 BERRY CREEK DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"495143","insp_interstate":"Y","insp_carrier_state_id":"0222114","created_at":"2025-03-17T20:44:15.000000Z","updated_at":"2025-03-17T20:44:15.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11458434,"change_date":"2024-11-04 21:40:00","inspection_id":"83061812","insp_unit_id":"203725718","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"10","insp_unit_license":"1L41396","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJBBCK39LZ92985","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:41:39.000000Z","updated_at":"2025-03-17T23:41:39.000000Z"},{"id":11458435,"change_date":"2024-11-04 21:40:00","inspection_id":"83061812","insp_unit_id":"203725719","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"STRI","insp_unit_company":"AAAZ 999999","insp_unit_license":"075B411","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1S13SC334RB692063","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:41:39.000000Z","updated_at":"2025-03-17T23:41:39.000000Z"}]},{"id":6613968,"change_date":"2024-08-30 21:41:00","inspection_id":"82540149","dot_number":"1266465","report_state":"TX","report_number":"6Y589DCIXI","insp_date":"2024-08-27 00:00:00","insp_start_time":"0900","insp_end_time":"0935","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"400  MERCURY DR","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-08-30 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":"9365069","transaction_code":"A","transaction_date":"2024-08-30 00:00:00","upload_date":"2024-08-30 00:00:00","upload_first_byte":"0","upload_dot_number":"01266465","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-08-27 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-08-30 21:41:00","insp_carrier_name":"MAYOR TRANSPORTATION","insp_carrier_street":"5114 BERRY CREEK DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"495143","insp_interstate":"Y","insp_carrier_state_id":"0222114","created_at":"2025-03-17T20:34:05.000000Z","updated_at":"2025-03-17T20:34:05.000000Z","inspection_violations":[{"id":10284685,"change_date":"2024-08-30 21:41:00","inspection_id":"82540149","insp_violation_id":"261532311","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"202691191","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:49.000000Z","updated_at":"2025-03-17T21:55:49.000000Z","normalized_code":"39311"},{"id":10284686,"change_date":"2024-08-30 21:41:00","inspection_id":"82540149","insp_violation_id":"261532312","seq_no":"2","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"202691191","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:49.000000Z","updated_at":"2025-03-17T21:55:49.000000Z","normalized_code":"39345D"}],"inspection_per_units":[{"id":10663549,"change_date":"2024-08-30 21:41:00","inspection_id":"82540149","insp_unit_id":"202691191","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"1L62700","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJGECK6BSAV9941","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:33:25.000000Z","updated_at":"2025-03-17T23:33:25.000000Z"}]},{"id":6350044,"change_date":"2024-07-30 21:44:00","inspection_id":"82258381","dot_number":"1266465","report_state":"TX","report_number":"6X5B9DNNPC","insp_date":"2024-07-22 00:00:00","insp_start_time":"1105","insp_end_time":"1134","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0225 IN HARRIS CO. (686-700","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"ASIA CHEMICAL","shipping_paper_number":"118342","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-30 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"7","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9337332","transaction_code":"A","transaction_date":"2024-07-30 00:00:00","upload_date":"2024-07-30 00:00:00","upload_first_byte":"0","upload_dot_number":"01266465","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2024-07-22 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-07-30 21:44:00","insp_carrier_name":"MAYOR TRANSPORTATION","insp_carrier_street":"5114 BERRY CREEK DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"495143","insp_interstate":"Y","insp_carrier_state_id":"0222114","created_at":"2025-03-17T20:28:41.000000Z","updated_at":"2025-03-17T20:28:41.000000Z","inspection_violations":[{"id":9858220,"change_date":"2024-07-30 21:44:00","inspection_id":"82258381","insp_violation_id":"260926411","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202153518","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:40.000000Z","updated_at":"2025-03-17T21:53:40.000000Z","normalized_code":"3939A"},{"id":9858221,"change_date":"2024-07-30 21:44:00","inspection_id":"82258381","insp_violation_id":"260926412","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202153518","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:40.000000Z","updated_at":"2025-03-17T21:53:40.000000Z","normalized_code":"3939A"},{"id":9858222,"change_date":"2024-07-30 21:44:00","inspection_id":"82258381","insp_violation_id":"260926413","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202153518","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:40.000000Z","updated_at":"2025-03-17T21:53:40.000000Z","normalized_code":"3939A"},{"id":9858223,"change_date":"2024-07-30 21:44:00","inspection_id":"82258381","insp_violation_id":"260926414","seq_no":"4","part_no":"393","part_no_section":"207(a)","insp_viol_unit":"2","insp_unit_id":"202153519","insp_violation_category_id":"22","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:40.000000Z","updated_at":"2025-03-17T21:53:40.000000Z","normalized_code":"393207A"},{"id":9858224,"change_date":"2024-07-30 21:44:00","inspection_id":"82258381","insp_violation_id":"260926415","seq_no":"5","part_no":"393","part_no_section":"207(a)","insp_viol_unit":"2","insp_unit_id":"202153519","insp_violation_category_id":"22","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:40.000000Z","updated_at":"2025-03-17T21:53:40.000000Z","normalized_code":"393207A"},{"id":9858225,"change_date":"2024-07-30 21:44:00","inspection_id":"82258381","insp_violation_id":"260926416","seq_no":"6","part_no":"393","part_no_section":"55(e)","insp_viol_unit":"2","insp_unit_id":"202153519","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:40.000000Z","updated_at":"2025-03-17T21:53:40.000000Z","normalized_code":"39355E"},{"id":9858226,"change_date":"2024-07-30 21:44:00","inspection_id":"82258381","insp_violation_id":"260926417","seq_no":"7","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"2","insp_unit_id":"202153519","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:53:40.000000Z","updated_at":"2025-03-17T21:53:40.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":10232972,"change_date":"2024-07-30 21:44:00","inspection_id":"82258381","insp_unit_id":"202153518","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"07","insp_unit_license":"1L41395","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJA6CK37LW95478","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:29:00.000000Z","updated_at":"2025-03-17T23:29:00.000000Z"},{"id":10232973,"change_date":"2024-07-30 21:44:00","inspection_id":"82258381","insp_unit_id":"202153519","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"CIMC","insp_unit_company":"34245","insp_unit_license":"2819969","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"LJRC41254G1034245","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:29:00.000000Z","updated_at":"2025-03-17T23:29:00.000000Z"}]},{"id":4219621,"change_date":"2023-10-17 21:42:00","inspection_id":"79936275","dot_number":"1266465","report_state":"TX","report_number":"6P8A9DAP4O","insp_date":"2023-10-11 00:00:00","insp_start_time":"1013","insp_end_time":"1029","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"200 E SAM HOUSTON PK","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"HOUSTON RAGS","shipping_paper_number":"EBKG06852965","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-17 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"9102757","transaction_code":"A","transaction_date":"2023-10-17 00:00:00","upload_date":"2023-10-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01266465","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-10-11 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-10-17 21:42:00","insp_carrier_name":"MAYOR TRANSPORTATION","insp_carrier_street":"5114 BERRY CREEK DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"495143","insp_interstate":"Y","insp_carrier_state_id":"0222114","created_at":"2025-03-17T19:46:18.000000Z","updated_at":"2025-03-17T19:46:18.000000Z","inspection_violations":[{"id":6532813,"change_date":"2023-10-17 21:42:00","inspection_id":"79936275","insp_violation_id":"255891985","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"197606065","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:29.000000Z","updated_at":"2025-03-17T21:37:29.000000Z","normalized_code":"3939A"},{"id":6532814,"change_date":"2023-10-17 21:42:00","inspection_id":"79936275","insp_violation_id":"255891986","seq_no":"2","part_no":"393","part_no_section":"83(g)","insp_viol_unit":"1","insp_unit_id":"197606065","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:29.000000Z","updated_at":"2025-03-17T21:37:29.000000Z","normalized_code":"39383G"},{"id":6532815,"change_date":"2023-10-17 21:42:00","inspection_id":"79936275","insp_violation_id":"255891987","seq_no":"3","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"2","insp_unit_id":"197606066","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:29.000000Z","updated_at":"2025-03-17T21:37:29.000000Z","normalized_code":"39345B2"},{"id":6532816,"change_date":"2023-10-17 21:42:00","inspection_id":"79936275","insp_violation_id":"255891988","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"197606065","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:29.000000Z","updated_at":"2025-03-17T21:37:29.000000Z","normalized_code":"3922"},{"id":6532817,"change_date":"2023-10-17 21:42:00","inspection_id":"79936275","insp_violation_id":"255891989","seq_no":"5","part_no":"393","part_no_section":"95(b)","insp_viol_unit":"1","insp_unit_id":"197606065","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:29.000000Z","updated_at":"2025-03-17T21:37:29.000000Z","normalized_code":"39395B"}],"inspection_per_units":[{"id":6786047,"change_date":"2023-10-17 21:42:00","inspection_id":"79936275","insp_unit_id":"197606065","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"01","insp_unit_license":"1L41330","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJA6CG37PY13582","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:53.000000Z","updated_at":"2025-03-17T22:56:53.000000Z"},{"id":6786048,"change_date":"2023-10-17 21:42:00","inspection_id":"79936275","insp_unit_id":"197606066","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"CIMC","insp_unit_company":"AAAZ 999999","insp_unit_license":"2819965","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"LJRC41252G1034194","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:53.000000Z","updated_at":"2025-03-17T22:56:53.000000Z"}]},{"id":3994685,"change_date":"2023-09-18 21:39:00","inspection_id":"79686966","dot_number":"1266465","report_state":"TX","report_number":"6OEC9DNN9Z","insp_date":"2023-09-11 00:00:00","insp_start_time":"1233","insp_end_time":"1300","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0225 IN HARRIS CO. (686-700","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"GLOBAL RESIN RESOURCES","shipping_paper_number":"114199","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":"117000","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":"9076920","transaction_code":"A","transaction_date":"2023-09-18 00:00:00","upload_date":"2023-09-18 00:00:00","upload_first_byte":"0","upload_dot_number":"01266465","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-09-11 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-09-18 21:39:00","insp_carrier_name":"MAYOR TRANSPORTATION","insp_carrier_street":"5114 BERRY CREEK DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"495143","insp_interstate":"Y","insp_carrier_state_id":"0222114","created_at":"2025-03-17T19:41:39.000000Z","updated_at":"2025-03-17T19:41:39.000000Z","inspection_violations":[{"id":6179954,"change_date":"2023-09-18 21:39:00","inspection_id":"79686966","insp_violation_id":"255328187","seq_no":"1","part_no":"393","part_no_section":"55(d)(1)","insp_viol_unit":"1","insp_unit_id":"197105178","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:49.000000Z","updated_at":"2025-03-17T21:35:49.000000Z","normalized_code":"39355D1"}],"inspection_per_units":[{"id":6423641,"change_date":"2023-09-18 21:39:00","inspection_id":"79686966","insp_unit_id":"197105178","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"08","insp_unit_license":"1M19731","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJGECK4BSAW0053","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":6423642,"change_date":"2023-09-18 21:39:00","inspection_id":"79686966","insp_unit_id":"197105179","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"CIMC","insp_unit_company":"08094","insp_unit_license":"2920387","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"LJRC41259H1008094","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":3698625,"change_date":"2023-08-08 21:42:00","inspection_id":"79356957","dot_number":"1266465","report_state":"TX","report_number":"6N9C9DNJR5","insp_date":"2023-08-01 00:00:00","insp_start_time":"1205","insp_end_time":"1305","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0146 IN HARRIS CO. (482-500","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-08-08 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"9047284","transaction_code":"A","transaction_date":"2023-08-08 00:00:00","upload_date":"2023-08-08 00:00:00","upload_first_byte":"0","upload_dot_number":"01266465","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-08-01 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-08-08 21:42:00","insp_carrier_name":"MAYOR TRANSPORTATION","insp_carrier_street":"5114 BERRY CREEK DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"495143","insp_interstate":"Y","insp_carrier_state_id":"0222114","created_at":"2025-03-17T19:35:44.000000Z","updated_at":"2025-03-17T19:35:44.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5946891,"change_date":"2023-08-08 21:42:00","inspection_id":"79356957","insp_unit_id":"196430306","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"07","insp_unit_license":"1L41395","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJA6CK37LW95478","insp_unit_decal":"Y","insp_unit_decal_number":"32983396","created_at":"2025-03-17T22:49:59.000000Z","updated_at":"2025-03-17T22:49:59.000000Z"},{"id":5946892,"change_date":"2023-08-08 21:42:00","inspection_id":"79356957","insp_unit_id":"196430307","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"CIMC","insp_unit_company":"AAAZ 999999","insp_unit_license":"2819717","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"LJRC41258G1034233","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:59.000000Z","updated_at":"2025-03-17T22:49:59.000000Z"}]},{"id":3134407,"change_date":"2023-05-25 21:42:00","inspection_id":"78722175","dot_number":"1266465","report_state":"TX","report_number":"6L599DCIEP","insp_date":"2023-05-17 00:00:00","insp_start_time":"0920","insp_end_time":"0955","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":"ASIA CHEMICAL CORP","shipping_paper_number":"112639","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-05-24 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"8987455","transaction_code":"C","transaction_date":"2023-05-25 00:00:00","upload_date":"2023-05-25 00:00:00","upload_first_byte":"0","upload_dot_number":"01266465","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-05-17 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-05-24 21:41:00","insp_carrier_name":"MAYOR TRANSPORTATION","insp_carrier_street":"5114 BERRY CREEK DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"495143","insp_interstate":"Y","insp_carrier_state_id":"0222114","created_at":"2025-03-17T19:24:59.000000Z","updated_at":"2025-03-17T19:24:59.000000Z","inspection_violations":[{"id":4825416,"change_date":"2023-05-25 21:42:00","inspection_id":"78722175","insp_violation_id":"253091608","seq_no":"1","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"2","insp_unit_id":"195152645","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:28.000000Z","updated_at":"2025-03-17T21:29:28.000000Z","normalized_code":"39345D"},{"id":4825417,"change_date":"2023-05-25 21:42:00","inspection_id":"78722175","insp_violation_id":"253091609","seq_no":"2","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"195152644","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:28.000000Z","updated_at":"2025-03-17T21:29:28.000000Z","normalized_code":"39311"},{"id":4825418,"change_date":"2023-05-25 21:42:00","inspection_id":"78722175","insp_violation_id":"253091610","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"195152644","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:28.000000Z","updated_at":"2025-03-17T21:29:28.000000Z","normalized_code":"3939A"},{"id":4825419,"change_date":"2023-05-25 21:42:00","inspection_id":"78722175","insp_violation_id":"253091611","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"195152645","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:28.000000Z","updated_at":"2025-03-17T21:29:28.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":5041474,"change_date":"2023-05-25 21:42:00","inspection_id":"78722175","insp_unit_id":"195152644","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"08","insp_unit_license":"1M19731","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJGECK4BSAW0053","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:45.000000Z","updated_at":"2025-03-17T22:42:45.000000Z"},{"id":5041475,"change_date":"2023-05-25 21:42:00","inspection_id":"78722175","insp_unit_id":"195152645","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"CIMC","insp_unit_company":"CFSH 034245","insp_unit_license":"2819969","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"LJRC41254G1034245","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:45.000000Z","updated_at":"2025-03-17T22:42:45.000000Z"}]},{"id":2555398,"change_date":"2023-03-10 21:41:00","inspection_id":"78065679","dot_number":"1266465","report_state":"TX","report_number":"6J5C9DMF49","insp_date":"2023-03-06 00:00:00","insp_start_time":"1220","insp_end_time":"1305","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0225 IN HARRIS CO. (686-700","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"BMOU 549701-5","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-10 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"8925927","transaction_code":"A","transaction_date":"2023-03-10 00:00:00","upload_date":"2023-03-10 00:00:00","upload_first_byte":"0","upload_dot_number":"01266465","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-03-06 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-03-10 21:41:00","insp_carrier_name":"MAYOR TRANSPORTATION","insp_carrier_street":"5114 BERRY CREEK DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"495143","insp_interstate":"Y","insp_carrier_state_id":"0222114","created_at":"2025-03-17T19:13:44.000000Z","updated_at":"2025-03-17T19:13:44.000000Z","inspection_violations":[{"id":3930785,"change_date":"2023-03-10 21:41:00","inspection_id":"78065679","insp_violation_id":"251603471","seq_no":"1","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"2","insp_unit_id":"193820167","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"2","citation_number":null,"created_at":"2025-03-17T21:25:26.000000Z","updated_at":"2025-03-17T21:25:26.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":4113211,"change_date":"2023-03-10 21:41:00","inspection_id":"78065679","insp_unit_id":"193820166","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"09","insp_unit_license":"1L41394","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJA6CK57LX43160","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:29.000000Z","updated_at":"2025-03-17T22:35:29.000000Z"},{"id":4113212,"change_date":"2023-03-10 21:41:00","inspection_id":"78065679","insp_unit_id":"193820167","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"CIMC","insp_unit_company":"AAAZ 999999","insp_unit_license":"2821313","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"LJRC41257H1004786","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:29.000000Z","updated_at":"2025-03-17T22:35:29.000000Z"}]},{"id":2460575,"change_date":"2023-02-27 21:42:00","inspection_id":"77958045","dot_number":"1266465","report_state":"TX","report_number":"6IV79DNHTI","insp_date":"2023-02-24 00:00:00","insp_start_time":"0705","insp_end_time":"0745","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"500 W BARBOURS CUT B","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-27 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"8915671","transaction_code":"A","transaction_date":"2023-02-27 00:00:00","upload_date":"2023-02-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01266465","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-02-24 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-02-27 21:42:00","insp_carrier_name":"MAYOR TRANSPORTATION","insp_carrier_street":"5114 BERRY CREEK DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"495143","insp_interstate":"Y","insp_carrier_state_id":"0222114","created_at":"2025-03-17T19:12:05.000000Z","updated_at":"2025-03-17T19:12:05.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3960111,"change_date":"2023-02-27 21:42:00","inspection_id":"77958045","insp_unit_id":"193604098","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"09","insp_unit_license":"1L41394","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJA6CK57LX43160","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:23.000000Z","updated_at":"2025-03-17T22:34:23.000000Z"},{"id":3960112,"change_date":"2023-02-27 21:42:00","inspection_id":"77958045","insp_unit_id":"193604099","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"CIMC","insp_unit_company":"AAAZ 999999","insp_unit_license":"2819717","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"LJRC41258G1034233","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:23.000000Z","updated_at":"2025-03-17T22:34:23.000000Z"}]},{"id":2339722,"change_date":"2023-02-09 21:40:00","inspection_id":"77820047","dot_number":"1266465","report_state":"TX","report_number":"6I789DNOTU","insp_date":"2023-01-31 00:00:00","insp_start_time":"0819","insp_end_time":"0848","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0225 IN HARRIS CO. (686-700","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"BAYPORT TERMINAL","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-09 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"8899816","transaction_code":"A","transaction_date":"2023-02-09 00:00:00","upload_date":"2023-02-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01266465","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2023-01-31 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-02-09 21:40:00","insp_carrier_name":"MAYOR TRANSPORTATION","insp_carrier_street":"5114 BERRY CREEK DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"495143","insp_interstate":"Y","insp_carrier_state_id":"0222114","created_at":"2025-03-17T19:09:41.000000Z","updated_at":"2025-03-17T19:09:41.000000Z","inspection_violations":[{"id":3604076,"change_date":"2023-02-09 21:40:00","inspection_id":"77820047","insp_violation_id":"251055331","seq_no":"1","part_no":"393","part_no_section":"55(d)(1)","insp_viol_unit":"1","insp_unit_id":"193326188","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:00.000000Z","updated_at":"2025-03-17T21:24:00.000000Z","normalized_code":"39355D1"},{"id":3604077,"change_date":"2023-02-09 21:40:00","inspection_id":"77820047","insp_violation_id":"251055332","seq_no":"2","part_no":"393","part_no_section":"95(b)","insp_viol_unit":"1","insp_unit_id":"193326188","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:00.000000Z","updated_at":"2025-03-17T21:24:00.000000Z","normalized_code":"39395B"},{"id":3604078,"change_date":"2023-02-09 21:40:00","inspection_id":"77820047","insp_violation_id":"251055333","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"193326189","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:00.000000Z","updated_at":"2025-03-17T21:24:00.000000Z","normalized_code":"3939A"},{"id":3604079,"change_date":"2023-02-09 21:40:00","inspection_id":"77820047","insp_violation_id":"251055334","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"193326189","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:00.000000Z","updated_at":"2025-03-17T21:24:00.000000Z","normalized_code":"3939A"},{"id":3604080,"change_date":"2023-02-09 21:40:00","inspection_id":"77820047","insp_violation_id":"251055335","seq_no":"5","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"193326188","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:00.000000Z","updated_at":"2025-03-17T21:24:00.000000Z","normalized_code":"3965B"}],"inspection_per_units":[{"id":3765006,"change_date":"2023-02-09 21:40:00","inspection_id":"77820047","insp_unit_id":"193326188","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"01","insp_unit_license":"1L41330","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJA6CG37PY13582","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:59.000000Z","updated_at":"2025-03-17T22:32:59.000000Z"},{"id":3765007,"change_date":"2023-02-09 21:40:00","inspection_id":"77820047","insp_unit_id":"193326189","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"CIMC","insp_unit_company":"CFSZ 034192","insp_unit_license":"2820094","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"LJRC41259G1034192","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:59.000000Z","updated_at":"2025-03-17T22:32:59.000000Z"}]},{"id":1931714,"change_date":"2022-12-12 21:44:00","inspection_id":"77354113","dot_number":"1266465","report_state":"TX","report_number":"6GO99DCQAM","insp_date":"2022-12-07 00:00:00","insp_start_time":"1050","insp_end_time":"1115","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"4400  W 18TH","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-12-12 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","viol_total":"3","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8848600","transaction_code":"A","transaction_date":"2022-12-12 00:00:00","upload_date":"2022-12-12 00:00:00","upload_first_byte":"0","upload_dot_number":"01266465","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-12-07 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-12-12 21:44:00","insp_carrier_name":"MAYOR TRANSPORTATION","insp_carrier_street":"5114 BERRY CREEK DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"495143","insp_interstate":"Y","insp_carrier_state_id":"0222114","created_at":"2025-03-17T19:02:14.000000Z","updated_at":"2025-03-17T19:02:14.000000Z","inspection_violations":[{"id":3004040,"change_date":"2022-12-12 21:44:00","inspection_id":"77354113","insp_violation_id":"250066846","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"11","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:18.000000Z","updated_at":"2025-03-17T21:21:18.000000Z","normalized_code":"39216A"},{"id":3004041,"change_date":"2022-12-12 21:44:00","inspection_id":"77354113","insp_violation_id":"250066847","seq_no":"2","part_no":"383","part_no_section":"23(a)(2)","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:21:18.000000Z","updated_at":"2025-03-17T21:21:18.000000Z","normalized_code":"38323A2"},{"id":3004042,"change_date":"2022-12-12 21:44:00","inspection_id":"77354113","insp_violation_id":"250066848","seq_no":"3","part_no":"393","part_no_section":"55(d)(1)","insp_viol_unit":"1","insp_unit_id":"192393904","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:18.000000Z","updated_at":"2025-03-17T21:21:18.000000Z","normalized_code":"39355D1"}],"inspection_per_units":[{"id":3108756,"change_date":"2022-12-12 21:44:00","inspection_id":"77354113","insp_unit_id":"192393904","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"01","insp_unit_license":"1L41330","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJA6CG37PY13582","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:17.000000Z","updated_at":"2025-03-17T22:28:17.000000Z"}]},{"id":1535018,"change_date":"2022-10-17 21:42:00","inspection_id":"76898980","dot_number":"1266465","report_state":"TX","report_number":"6F6C9DNJDZ","insp_date":"2022-10-14 00:00:00","insp_start_time":"1211","insp_end_time":"1229","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0146 IN HARRIS CO. (482-500","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-17 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"8802606","transaction_code":"A","transaction_date":"2022-10-17 00:00:00","upload_date":"2022-10-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01266465","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-10-14 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-10-17 21:42:00","insp_carrier_name":"MAYOR TRANSPORTATION","insp_carrier_street":"5114 BERRY CREEK DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"495143","insp_interstate":"Y","insp_carrier_state_id":"0222114","created_at":"2025-03-17T18:54:52.000000Z","updated_at":"2025-03-17T18:54:52.000000Z","inspection_violations":[{"id":2418677,"change_date":"2022-10-17 21:42:00","inspection_id":"76898980","insp_violation_id":"249084152","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"191486455","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:18:10.000000Z","updated_at":"2025-03-17T21:18:10.000000Z","normalized_code":"39311"}],"inspection_per_units":[{"id":2470648,"change_date":"2022-10-17 21:42:00","inspection_id":"76898980","insp_unit_id":"191486454","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"14","insp_unit_license":"1M16892","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJBBCG46LU71345","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:56.000000Z","updated_at":"2025-03-17T22:23:56.000000Z"},{"id":2470649,"change_date":"2022-10-17 21:42:00","inspection_id":"76898980","insp_unit_id":"191486455","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"CIMC","insp_unit_company":"AAAZ 999999","insp_unit_license":"2819965","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"LJRC41252G1034194","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:56.000000Z","updated_at":"2025-03-17T22:23:56.000000Z"}]},{"id":1439722,"change_date":"2022-10-04 21:41:00","inspection_id":"76788632","dot_number":"1266465","report_state":"TX","report_number":"6EPC9DME0B","insp_date":"2022-09-27 00:00:00","insp_start_time":"1226","insp_end_time":"1253","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0146 IN HARRIS CO. (482-500","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-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"8788714","transaction_code":"A","transaction_date":"2022-10-04 00:00:00","upload_date":"2022-10-04 00:00:00","upload_first_byte":"0","upload_dot_number":"01266465","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-09-27 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-10-04 21:41:00","insp_carrier_name":"MAYOR TRANSPORTATION","insp_carrier_street":"5114 BERRY CREEK DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"495143","insp_interstate":"Y","insp_carrier_state_id":"0222114","created_at":"2025-03-17T18:53:07.000000Z","updated_at":"2025-03-17T18:53:07.000000Z","inspection_violations":[{"id":2266995,"change_date":"2022-10-04 21:41:00","inspection_id":"76788632","insp_violation_id":"248828292","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"191266601","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:24.000000Z","updated_at":"2025-03-17T21:17:24.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":2317774,"change_date":"2022-10-04 21:41:00","inspection_id":"76788632","insp_unit_id":"191266601","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"02","insp_unit_license":"1L41329","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJBBCK69LZ92950","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:22:52.000000Z","updated_at":"2025-03-17T22:22:52.000000Z"},{"id":2317775,"change_date":"2022-10-04 21:41:00","inspection_id":"76788632","insp_unit_id":"191266602","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"CIMC","insp_unit_company":"AAAZ 999999","insp_unit_license":"2820095","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"LJRC41253G1034205","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:22:52.000000Z","updated_at":"2025-03-17T22:22:52.000000Z"}]},{"id":1319222,"change_date":"2022-09-19 21:40:00","inspection_id":"76648944","dot_number":"1266465","report_state":"TX","report_number":"6EC89DMEGT","insp_date":"2022-09-14 00:00:00","insp_start_time":"0830","insp_end_time":"0852","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0146 IN HARRIS CO. (482-500","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-09-19 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"8776044","transaction_code":"A","transaction_date":"2022-09-19 00:00:00","upload_date":"2022-09-19 00:00:00","upload_first_byte":"0","upload_dot_number":"01266465","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-09-14 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-09-19 21:40:00","insp_carrier_name":"MAYOR TRANSPORTATION","insp_carrier_street":"5114 BERRY CREEK DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"495143","insp_interstate":"Y","insp_carrier_state_id":"0222114","created_at":"2025-03-17T18:50:53.000000Z","updated_at":"2025-03-17T18:50:53.000000Z","inspection_violations":[],"inspection_per_units":[{"id":2124160,"change_date":"2022-09-19 21:40:00","inspection_id":"76648944","insp_unit_id":"190982862","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"09","insp_unit_license":"1L41394","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJA6CK57LX43160","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:33.000000Z","updated_at":"2025-03-17T22:21:33.000000Z"},{"id":2124161,"change_date":"2022-09-19 21:40:00","inspection_id":"76648944","insp_unit_id":"190982863","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"CIMC","insp_unit_company":"AAAZ 999999","insp_unit_license":"2920384","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"1NNC053221M338339","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:21:33.000000Z","updated_at":"2025-03-17T22:21:33.000000Z"}]},{"id":1207653,"change_date":"2022-09-02 21:39:00","inspection_id":"76519499","dot_number":"1266465","report_state":"TX","report_number":"6DWB9DNNIA","insp_date":"2022-08-29 00:00:00","insp_start_time":"1115","insp_end_time":"1138","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0225 IN HARRIS CO. (686-700","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"POLY UNITED INC","shipping_paper_number":"EBKG03536960","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2022-09-02 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8762036","transaction_code":"A","transaction_date":"2022-09-02 00:00:00","upload_date":"2022-09-02 00:00:00","upload_first_byte":"0","upload_dot_number":"01266465","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-08-29 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-09-02 21:39:00","insp_carrier_name":"MAYOR TRANSPORTATION","insp_carrier_street":"5114 BERRY CREEK DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"495143","insp_interstate":"Y","insp_carrier_state_id":"0222114","created_at":"2025-03-17T18:48:58.000000Z","updated_at":"2025-03-17T18:48:58.000000Z","inspection_violations":[{"id":1915246,"change_date":"2022-09-02 21:39:00","inspection_id":"76519499","insp_violation_id":"248202908","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"190713377","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:50.000000Z","updated_at":"2025-03-17T21:15:50.000000Z","normalized_code":"3939A"},{"id":1915247,"change_date":"2022-09-02 21:39:00","inspection_id":"76519499","insp_violation_id":"248202909","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"190713378","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:15:50.000000Z","updated_at":"2025-03-17T21:15:50.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":1942260,"change_date":"2022-09-02 21:39:00","inspection_id":"76519499","insp_unit_id":"190713377","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"1L38681","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJBBCG46LU71071","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:21.000000Z","updated_at":"2025-03-17T22:20:21.000000Z"},{"id":1942261,"change_date":"2022-09-02 21:39:00","inspection_id":"76519499","insp_unit_id":"190713378","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"CIMC","insp_unit_company":"34210","insp_unit_license":"2819968","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"LJRC41257G1034210","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:21.000000Z","updated_at":"2025-03-17T22:20:21.000000Z"}]},{"id":1118999,"change_date":"2022-08-23 21:42:00","inspection_id":"76416528","dot_number":"1266465","report_state":"TX","report_number":"6DIE9DNJ9Q","insp_date":"2022-08-15 00:00:00","insp_start_time":"1410","insp_end_time":"1435","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0146 IN HARRIS CO. (482-500","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-08-23 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"130000","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":"8750558","transaction_code":"A","transaction_date":"2022-08-23 00:00:00","upload_date":"2022-08-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01266465","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-08-15 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-08-23 21:42:00","insp_carrier_name":"MAYOR TRANSPORTATION","insp_carrier_street":"5114 BERRY CREEK DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"495143","insp_interstate":"Y","insp_carrier_state_id":"0222114","created_at":"2025-03-17T18:47:17.000000Z","updated_at":"2025-03-17T18:47:17.000000Z","inspection_violations":[{"id":1767821,"change_date":"2022-08-23 21:42:00","inspection_id":"76416528","insp_violation_id":"247946666","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"190503986","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:14.000000Z","updated_at":"2025-03-17T21:15:14.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":1800041,"change_date":"2022-08-23 21:42:00","inspection_id":"76416528","insp_unit_id":"190503986","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"09","insp_unit_license":"1L41394","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJA6CK57LX43160","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:25.000000Z","updated_at":"2025-03-17T22:19:25.000000Z"},{"id":1800042,"change_date":"2022-08-23 21:42:00","inspection_id":"76416528","insp_unit_id":"190503987","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"CHTH","insp_unit_company":"AAAZ 999999","insp_unit_license":"B999963","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"5EF3SC3306B769129","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:25.000000Z","updated_at":"2025-03-17T22:19:25.000000Z"}]},{"id":740707,"change_date":"2022-07-01 21:38:00","inspection_id":"75974493","dot_number":"1266465","report_state":"TX","report_number":"6C6C9DNOLJ","insp_date":"2022-06-28 00:00:00","insp_start_time":"1253","insp_end_time":"1316","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0225 IN HARRIS CO. (686-700","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"HOUSTON RAGS","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-07-01 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"117000","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":"8701218","transaction_code":"A","transaction_date":"2022-07-01 00:00:00","upload_date":"2022-07-01 00:00:00","upload_first_byte":"0","upload_dot_number":"01266465","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-06-28 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-07-01 21:38:00","insp_carrier_name":"MAYOR TRANSPORTATION","insp_carrier_street":"5114 BERRY CREEK DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"495143","insp_interstate":"Y","insp_carrier_state_id":"0222114","created_at":"2025-03-17T18:40:51.000000Z","updated_at":"2025-03-17T18:40:51.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1190323,"change_date":"2022-07-01 21:38:00","inspection_id":"75974493","insp_unit_id":"189579632","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"09","insp_unit_license":"1L41394","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJA6CK57LX43160","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:30.000000Z","updated_at":"2025-03-17T22:15:30.000000Z"},{"id":1190324,"change_date":"2022-07-01 21:38:00","inspection_id":"75974493","insp_unit_id":"189579633","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"CIMC","insp_unit_company":"AAAZ 999999","insp_unit_license":"2820096","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"LJRC41259G1034211","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:30.000000Z","updated_at":"2025-03-17T22:15:30.000000Z"}]},{"id":810700,"change_date":"2022-07-13 21:40:00","inspection_id":"76055951","dot_number":"1266465","report_state":"TX","report_number":"6BSA9DNGH0","insp_date":"2022-06-14 00:00:00","insp_start_time":"1012","insp_end_time":"1031","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0146 IN HARRIS CO. (482-500","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-07-13 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"8712329","transaction_code":"A","transaction_date":"2022-07-13 00:00:00","upload_date":"2022-07-13 00:00:00","upload_first_byte":"0","upload_dot_number":"01266465","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-06-14 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-07-13 21:40:00","insp_carrier_name":"MAYOR TRANSPORTATION","insp_carrier_street":"5114 BERRY CREEK DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"495143","insp_interstate":"Y","insp_carrier_state_id":"0222114","created_at":"2025-03-17T18:41:57.000000Z","updated_at":"2025-03-17T18:41:57.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1304792,"change_date":"2022-07-13 21:40:00","inspection_id":"76055951","insp_unit_id":"189758069","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"1","insp_unit_license":"1L38681","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJBBCG46LU71071","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:16:11.000000Z","updated_at":"2025-03-17T22:16:11.000000Z"},{"id":1304793,"change_date":"2022-07-13 21:40:00","inspection_id":"76055951","insp_unit_id":"189758070","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"CIMC","insp_unit_company":"AAAZ 999999","insp_unit_license":"2819717","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"LJRC41258G1034233","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:16:11.000000Z","updated_at":"2025-03-17T22:16:11.000000Z"}]},{"id":103294,"change_date":"2022-04-11 21:41:00","inspection_id":"75214440","dot_number":"1266465","report_state":"TX","report_number":"69GD9DNOG5","insp_date":"2022-03-22 00:00:00","insp_start_time":"1312","insp_end_time":"1340","registration_date":"2022-04-11 00:00:00","region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0225 IN HARRIS CO. (686-700","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2022-04-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"126500","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":"8608694","transaction_code":"C","transaction_date":"2022-04-04 00:00:00","upload_date":"2022-04-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01266465","upload_search_indicator":"M","census_search_date":null,"snet_input_date":"2022-03-22 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-04-04 21:41:00","insp_carrier_name":"MAYOR TRANSPORTATION","insp_carrier_street":"5114 BERRY CREEK DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77017","insp_colonia":null,"docket_number":"495143","insp_interstate":"Y","insp_carrier_state_id":"0222114","created_at":"2025-03-17T18:29:26.000000Z","updated_at":"2025-03-17T18:29:26.000000Z","inspection_violations":[{"id":152351,"change_date":"2022-04-11 21:41:00","inspection_id":"75214440","insp_violation_id":"245080881","seq_no":"1","part_no":"393","part_no_section":"55(d)(2)","insp_viol_unit":"1","insp_unit_id":"188089641","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:46.000000Z","updated_at":"2025-03-17T21:07:46.000000Z","normalized_code":"39355D2"},{"id":152352,"change_date":"2022-04-11 21:41:00","inspection_id":"75214440","insp_violation_id":"245080882","seq_no":"2","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"188089641","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:46.000000Z","updated_at":"2025-03-17T21:07:46.000000Z","normalized_code":"39345B2"}],"inspection_per_units":[{"id":167502,"change_date":"2022-04-11 21:41:00","inspection_id":"75214440","insp_unit_id":"188089641","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"08","insp_unit_license":"1L62720","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUJGECK4BSAW0053","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:14.000000Z","updated_at":"2025-03-17T22:09:14.000000Z"},{"id":167503,"change_date":"2022-04-11 21:41:00","inspection_id":"75214440","insp_unit_id":"188089642","insp_unit_type_id":"14","insp_unit_number":"2","insp_unit_make":"CIMC","insp_unit_company":"CFSH 007458","insp_unit_license":"282130","insp_unit_license_state":"ME","insp_unit_vehicle_id_number":"LJRC46268H1007458","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:14.000000Z","updated_at":"2025-03-17T22:09:14.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/1266465\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/1266465\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1266465\/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\/1266465\/inspections","per_page":100,"prev_page_url":null,"to":36,"total":36}