{"current_page":1,"data":[{"id":11913636,"change_date":"2026-05-14 21:43:00","inspection_id":"87853041","dot_number":"1539265","report_state":"TX","report_number":"7FFC9DCALN","insp_date":"2026-05-11 00:00:00","insp_start_time":"1215","insp_end_time":"1240","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"2200  S WAYSIDE","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-05-14 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"47601","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9953788","transaction_code":"A","transaction_date":"2026-05-14 00:00:00","upload_date":"2026-05-14 00:00:00","upload_first_byte":"0","upload_dot_number":"01539265","upload_search_indicator":"M","census_search_date":"2026-05-14 21:43:00","snet_input_date":"2026-05-11 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-05-14 21:43:00","insp_carrier_name":"BIG R TRUCKING LLC","insp_carrier_street":"7416 JOHN RALSTON RD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77044","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0264980","created_at":"2026-05-16T13:33:01.000000Z","updated_at":"2026-05-25T09:32:01.000000Z","inspection_violations":[{"id":20723656,"change_date":"2026-05-14 21:43:00","inspection_id":"87853041","insp_violation_id":"274268142","seq_no":"1","part_no":"393","part_no_section":"75C","insp_viol_unit":"2","insp_unit_id":"213561576","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-16T13:13:29.000000Z","updated_at":"2026-05-25T09:44:41.000000Z","normalized_code":"39375C"},{"id":20723657,"change_date":"2026-05-14 21:43:00","inspection_id":"87853041","insp_violation_id":"274268143","seq_no":"2","part_no":"393","part_no_section":"75C","insp_viol_unit":"1","insp_unit_id":"213561575","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-16T13:13:29.000000Z","updated_at":"2026-05-25T09:44:41.000000Z","normalized_code":"39375C"},{"id":20723658,"change_date":"2026-05-14 21:43:00","inspection_id":"87853041","insp_violation_id":"274268144","seq_no":"3","part_no":"393","part_no_section":"83G","insp_viol_unit":"1","insp_unit_id":"213561575","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-16T13:13:29.000000Z","updated_at":"2026-05-25T09:44:41.000000Z","normalized_code":"39383G"}],"inspection_per_units":[{"id":20710950,"change_date":"2026-05-14 21:43:00","inspection_id":"87853041","insp_unit_id":"213561575","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"1M20852","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDDU9X82J898006","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-16T12:45:00.000000Z","updated_at":"2026-05-25T09:04:46.000000Z"},{"id":20710951,"change_date":"2026-05-14 21:43:00","inspection_id":"87853041","insp_unit_id":"213561576","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CPS","insp_unit_company":null,"insp_unit_license":"W35449","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5MC5154216P006000","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-16T12:45:00.000000Z","updated_at":"2026-05-25T09:04:46.000000Z"}]},{"id":11771620,"change_date":"2026-04-28 21:39:00","inspection_id":"87702446","dot_number":"1539265","report_state":"TX","report_number":"7EXG9DGPGF","insp_date":"2026-04-23 00:00:00","insp_start_time":"1658","insp_end_time":"1710","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"10700  MESA DR","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":"2026-04-28 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"9934297","transaction_code":"A","transaction_date":"2026-04-28 00:00:00","upload_date":"2026-04-28 00:00:00","upload_first_byte":"0","upload_dot_number":"01539265","upload_search_indicator":"M","census_search_date":"2026-04-28 21:39:00","snet_input_date":"2026-04-23 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-04-28 21:39:00","insp_carrier_name":"BIG R TRUCKING LLC","insp_carrier_street":"7416 JOHN RALSTON RD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77044","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0264980","created_at":"2026-05-01T09:40:31.000000Z","updated_at":"2026-05-09T09:31:11.000000Z","inspection_violations":[{"id":20468156,"change_date":"2026-04-28 21:39:00","inspection_id":"87702446","insp_violation_id":"273910039","seq_no":"1","part_no":"392","part_no_section":"2-SLLS2","insp_viol_unit":"1","insp_unit_id":"213271862","insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-01T10:02:16.000000Z","updated_at":"2026-05-09T09:42:31.000000Z","normalized_code":"3922SLLS2"}],"inspection_per_units":[{"id":20479311,"change_date":"2026-04-28 21:39:00","inspection_id":"87702446","insp_unit_id":"213271863","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CLEM","insp_unit_company":null,"insp_unit_license":"124B344","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5C2BB32B04M004245","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-01T09:20:51.000000Z","updated_at":"2026-05-09T09:03:47.000000Z"},{"id":20479310,"change_date":"2026-04-28 21:39:00","inspection_id":"87702446","insp_unit_id":"213271862","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"R15","insp_unit_license":"1N51004","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDDU9X04J062922","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-01T09:20:51.000000Z","updated_at":"2026-05-09T09:03:47.000000Z"}]},{"id":11555850,"change_date":"2026-04-02 21:39:00","inspection_id":"87478987","dot_number":"1539265","report_state":"TX","report_number":"7EAA9DCAJD","insp_date":"2026-03-31 00:00:00","insp_start_time":"1010","insp_end_time":"1030","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"3400  PERSIMMON","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-04-02 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"101001","viol_total":"3","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9905174","transaction_code":"A","transaction_date":"2026-04-02 00:00:00","upload_date":"2026-04-02 00:00:00","upload_first_byte":"0","upload_dot_number":"01539265","upload_search_indicator":"M","census_search_date":"2026-04-02 21:39:00","snet_input_date":"2026-03-31 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-04-02 21:39:00","insp_carrier_name":"BIG R TRUCKING LLC","insp_carrier_street":"7416 JOHN RALSTON RD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77044","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0264980","created_at":"2026-04-05T09:57:01.000000Z","updated_at":"2026-04-13T09:31:29.000000Z","inspection_violations":[{"id":19530140,"change_date":"2026-04-02 21:39:00","inspection_id":"87478987","insp_violation_id":"272838528","seq_no":"1","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"212516420","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-05T10:26:51.000000Z","updated_at":"2026-04-12T10:18:25.000000Z","normalized_code":"39360C"},{"id":19530141,"change_date":"2026-04-02 21:39:00","inspection_id":"87478987","insp_violation_id":"272838529","seq_no":"2","part_no":"393","part_no_section":"83G","insp_viol_unit":"1","insp_unit_id":"212516420","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-05T10:26:51.000000Z","updated_at":"2026-04-12T10:18:25.000000Z","normalized_code":"39383G"},{"id":19530142,"change_date":"2026-04-02 21:39:00","inspection_id":"87478987","insp_violation_id":"272838530","seq_no":"3","part_no":"393","part_no_section":"47A","insp_viol_unit":"1","insp_unit_id":"212516420","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-05T10:26:51.000000Z","updated_at":"2026-04-12T10:18:25.000000Z","normalized_code":"39347A"}],"inspection_per_units":[{"id":19803615,"change_date":"2026-04-02 21:39:00","inspection_id":"87478987","insp_unit_id":"212516420","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"1M74343","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDDB9X07J173771","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-05T09:52:21.000000Z","updated_at":"2026-04-13T09:04:45.000000Z"},{"id":19803616,"change_date":"2026-04-02 21:39:00","inspection_id":"87478987","insp_unit_id":"212516421","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CPS","insp_unit_company":null,"insp_unit_license":"020C318","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5MC51542X7P008376","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-05T09:52:21.000000Z","updated_at":"2026-04-13T09:04:45.000000Z"}]},{"id":10057346,"change_date":"2025-10-28 21:40:00","inspection_id":"86170521","dot_number":"1539265","report_state":"TX","report_number":"79TF9DFP2N","insp_date":"2025-10-21 00:00:00","insp_start_time":"1510","insp_end_time":"1615","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"6500  LEESA LN","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"ARCOSA STABILIZED MATERIALS","shipping_paper_number":"1934022640","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":"124000","viol_total":"13","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"13","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9739083","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":"01539265","upload_search_indicator":"M","census_search_date":"2025-10-28 21:40:00","snet_input_date":"2025-10-21 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-10-28 21:40:00","insp_carrier_name":"BIG R TRUCKING LLC","insp_carrier_street":"7416 JOHN RALSTON RD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77044","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0264980","created_at":"2025-11-01T10:02:05.000000Z","updated_at":"2025-11-01T10:02:05.000000Z","inspection_violations":[{"id":16649108,"change_date":"2025-10-28 21:40:00","inspection_id":"86170521","insp_violation_id":"269569997","seq_no":"1","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"209699877","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-31T10:18:08.000000Z","updated_at":"2025-11-01T10:16:54.000000Z","normalized_code":"39347E"},{"id":16649109,"change_date":"2025-10-28 21:40:00","inspection_id":"86170521","insp_violation_id":"269569998","seq_no":"2","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"209699877","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-31T10:18:08.000000Z","updated_at":"2025-11-01T10:16:54.000000Z","normalized_code":"39347E"},{"id":16649110,"change_date":"2025-10-28 21:40:00","inspection_id":"86170521","insp_violation_id":"269569999","seq_no":"3","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"209699877","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-31T10:18:08.000000Z","updated_at":"2025-11-01T10:16:54.000000Z","normalized_code":"39347E"},{"id":16649111,"change_date":"2025-10-28 21:40:00","inspection_id":"86170521","insp_violation_id":"269570000","seq_no":"4","part_no":"393","part_no_section":"47A","insp_viol_unit":"2","insp_unit_id":"209699878","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-31T10:18:08.000000Z","updated_at":"2025-11-01T10:16:54.000000Z","normalized_code":"39347A"},{"id":16649112,"change_date":"2025-10-28 21:40:00","inspection_id":"86170521","insp_violation_id":"269570001","seq_no":"5","part_no":"393","part_no_section":"47A","insp_viol_unit":"2","insp_unit_id":"209699878","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-31T10:18:08.000000Z","updated_at":"2025-11-01T10:16:54.000000Z","normalized_code":"39347A"},{"id":16649113,"change_date":"2025-10-28 21:40:00","inspection_id":"86170521","insp_violation_id":"269570002","seq_no":"6","part_no":"393","part_no_section":"53B","insp_viol_unit":"1","insp_unit_id":"209699877","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-31T10:18:08.000000Z","updated_at":"2025-11-01T10:16:54.000000Z","normalized_code":"39353B"},{"id":16649114,"change_date":"2025-10-28 21:40:00","inspection_id":"86170521","insp_violation_id":"269570003","seq_no":"7","part_no":"396","part_no_section":"3A1BOS","insp_viol_unit":"1","insp_unit_id":"209699877","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-10-31T10:18:08.000000Z","updated_at":"2025-11-01T10:16:54.000000Z","normalized_code":"3963A1BOS"},{"id":16649115,"change_date":"2025-10-28 21:40:00","inspection_id":"86170521","insp_violation_id":"269570004","seq_no":"8","part_no":"393","part_no_section":"83G","insp_viol_unit":"1","insp_unit_id":"209699877","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-31T10:18:08.000000Z","updated_at":"2025-11-01T10:16:54.000000Z","normalized_code":"39383G"},{"id":16649116,"change_date":"2025-10-28 21:40:00","inspection_id":"86170521","insp_violation_id":"269570005","seq_no":"9","part_no":"393","part_no_section":"47A","insp_viol_unit":"1","insp_unit_id":"209699877","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-31T10:18:08.000000Z","updated_at":"2025-11-01T10:16:54.000000Z","normalized_code":"39347A"},{"id":16649117,"change_date":"2025-10-28 21:40:00","inspection_id":"86170521","insp_violation_id":"269570006","seq_no":"10","part_no":"393","part_no_section":"45B2UV","insp_viol_unit":"1","insp_unit_id":"209699877","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-31T10:18:08.000000Z","updated_at":"2025-11-01T10:16:54.000000Z","normalized_code":"39345B2UV"},{"id":16649118,"change_date":"2025-10-28 21:40:00","inspection_id":"86170521","insp_violation_id":"269570007","seq_no":"11","part_no":"392","part_no_section":"2W","insp_viol_unit":"2","insp_unit_id":"209699878","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-31T10:18:08.000000Z","updated_at":"2025-11-01T10:16:54.000000Z","normalized_code":"3922W"},{"id":16649119,"change_date":"2025-10-28 21:40:00","inspection_id":"86170521","insp_violation_id":"269570008","seq_no":"12","part_no":"392","part_no_section":"2W","insp_viol_unit":"1","insp_unit_id":"209699877","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-31T10:18:08.000000Z","updated_at":"2025-11-01T10:16:54.000000Z","normalized_code":"3922W"},{"id":16649120,"change_date":"2025-10-28 21:40:00","inspection_id":"86170521","insp_violation_id":"269570009","seq_no":"13","part_no":"392","part_no_section":"2W","insp_viol_unit":"1","insp_unit_id":"209699877","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-31T10:18:08.000000Z","updated_at":"2025-11-01T10:16:54.000000Z","normalized_code":"3922W"}],"inspection_per_units":[{"id":16714848,"change_date":"2025-10-28 21:40:00","inspection_id":"86170521","insp_unit_id":"209699877","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"R15","insp_unit_license":"1N51004","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDDU9X04J062922","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-31T09:47:13.000000Z","updated_at":"2025-11-01T09:46:30.000000Z"},{"id":16714849,"change_date":"2025-10-28 21:40:00","inspection_id":"86170521","insp_unit_id":"209699878","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CLEM","insp_unit_company":"TR02","insp_unit_license":"124B344","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5C2BB32B04M004245","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-31T09:47:13.000000Z","updated_at":"2025-11-01T09:46:30.000000Z"}]},{"id":9868711,"change_date":"2025-10-06 21:41:00","inspection_id":"85971615","dot_number":"1539265","report_state":"TX","report_number":"79489DGRET","insp_date":"2025-09-26 00:00:00","insp_start_time":"0837","insp_end_time":"0859","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"2800  CAVALCADE ST","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-10-06 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"9715420","transaction_code":"A","transaction_date":"2025-10-06 00:00:00","upload_date":"2025-10-06 00:00:00","upload_first_byte":"0","upload_dot_number":"01539265","upload_search_indicator":"M","census_search_date":"2025-10-06 21:41:00","snet_input_date":"2025-09-26 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-10-06 21:41:00","insp_carrier_name":"BIG R TRUCKING LLC","insp_carrier_street":"7416 JOHN RALSTON RD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77044","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0264980","created_at":"2025-10-09T10:00:57.000000Z","updated_at":"2025-10-10T10:01:34.000000Z","inspection_violations":[{"id":16260567,"change_date":"2025-10-06 21:41:00","inspection_id":"85971615","insp_violation_id":"269129078","seq_no":"1","part_no":"393","part_no_section":"60E-WS","insp_viol_unit":"1","insp_unit_id":"209325545","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-09T10:16:24.000000Z","updated_at":"2025-10-10T10:17:26.000000Z","normalized_code":"39360EWS"},{"id":16260568,"change_date":"2025-10-06 21:41:00","inspection_id":"85971615","insp_violation_id":"269129079","seq_no":"2","part_no":"393","part_no_section":"201D","insp_viol_unit":"1","insp_unit_id":"209325545","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-09T10:16:24.000000Z","updated_at":"2025-10-10T10:17:26.000000Z","normalized_code":"393201D"},{"id":16260569,"change_date":"2025-10-06 21:41:00","inspection_id":"85971615","insp_violation_id":"269129080","seq_no":"3","part_no":"393","part_no_section":"201D","insp_viol_unit":"2","insp_unit_id":"209325546","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-09T10:16:24.000000Z","updated_at":"2025-10-10T10:17:26.000000Z","normalized_code":"393201D"},{"id":16260570,"change_date":"2025-10-06 21:41:00","inspection_id":"85971615","insp_violation_id":"269129081","seq_no":"4","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"209325545","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-09T10:16:24.000000Z","updated_at":"2025-10-10T10:17:26.000000Z","normalized_code":"3939"}],"inspection_per_units":[{"id":16369488,"change_date":"2025-10-06 21:41:00","inspection_id":"85971615","insp_unit_id":"209325545","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"1M74343","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDDB9X07J173771","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-09T09:45:52.000000Z","updated_at":"2025-10-10T09:47:03.000000Z"},{"id":16369489,"change_date":"2025-10-06 21:41:00","inspection_id":"85971615","insp_unit_id":"209325546","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CTSI","insp_unit_company":null,"insp_unit_license":"020C318","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5MC51542X7P008376","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-09T09:45:52.000000Z","updated_at":"2025-10-10T09:47:03.000000Z"}]},{"id":9697557,"change_date":"2025-09-16 21:40:00","inspection_id":"85791974","dot_number":"1539265","report_state":"TX","report_number":"V252001641","insp_date":"2025-09-10 00:00:00","insp_start_time":"0853","insp_end_time":"0938","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"EAST SAM HOUSTON PKW","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"JOSLIN CONSTRUCTION","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-09-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"118000","viol_total":"4","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9697886","transaction_code":"A","transaction_date":"2025-09-16 00:00:00","upload_date":"2025-09-16 00:00:00","upload_first_byte":"0","upload_dot_number":"01539265","upload_search_indicator":"M","census_search_date":"2025-09-16 21:40:00","snet_input_date":"2025-09-10 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-09-16 21:40:00","insp_carrier_name":"BIG R TRUCKING LLC","insp_carrier_street":"7416 JOHN RALSTON RD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77044","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0264980","created_at":"2025-09-18T10:01:02.000000Z","updated_at":"2025-09-23T10:01:14.000000Z","inspection_violations":[{"id":15912153,"change_date":"2025-09-16 21:40:00","inspection_id":"85791974","insp_violation_id":"268736175","seq_no":"1","part_no":"393","part_no_section":"209E","insp_viol_unit":"1","insp_unit_id":"208984435","insp_violation_category_id":"21","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-18T10:21:40.000000Z","updated_at":"2025-09-20T10:16:00.000000Z","normalized_code":"393209E"},{"id":15912154,"change_date":"2025-09-16 21:40:00","inspection_id":"85791974","insp_violation_id":"268736176","seq_no":"2","part_no":"393","part_no_section":"47B","insp_viol_unit":"1","insp_unit_id":"208984435","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-09-18T10:21:40.000000Z","updated_at":"2025-09-20T10:16:00.000000Z","normalized_code":"39347B"},{"id":15912155,"change_date":"2025-09-16 21:40:00","inspection_id":"85791974","insp_violation_id":"268736177","seq_no":"3","part_no":"393","part_no_section":"75A3","insp_viol_unit":"2","insp_unit_id":"208984436","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-09-18T10:21:40.000000Z","updated_at":"2025-09-20T10:16:00.000000Z","normalized_code":"39375A3"},{"id":15912156,"change_date":"2025-09-16 21:40:00","inspection_id":"85791974","insp_violation_id":"268736178","seq_no":"4","part_no":"393","part_no_section":"9TS","insp_viol_unit":"2","insp_unit_id":"208984436","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-09-18T10:21:40.000000Z","updated_at":"2025-09-20T10:16:00.000000Z","normalized_code":"3939TS"}],"inspection_per_units":[{"id":16053075,"change_date":"2025-09-16 21:40:00","inspection_id":"85791974","insp_unit_id":"208984435","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"R-44","insp_unit_license":"1M74343","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDDB9X07J173771","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-18T09:45:44.000000Z","updated_at":"2025-09-20T09:45:35.000000Z"},{"id":16053076,"change_date":"2025-09-16 21:40:00","inspection_id":"85791974","insp_unit_id":"208984436","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CPS","insp_unit_company":"R-44T","insp_unit_license":"020C318","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5MC51542X7P008376","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-18T09:45:44.000000Z","updated_at":"2025-09-20T09:45:35.000000Z"}]},{"id":9116422,"change_date":"2025-07-10 21:39:00","inspection_id":"85181430","dot_number":"1539265","report_state":"TX","report_number":"76X79DJM6U","insp_date":"2025-07-09 00:00:00","insp_start_time":"0731","insp_end_time":"0840","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0288 IN HARRIS CO. (472-484","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-07-10 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","viol_total":"19","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"19","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9632412","transaction_code":"A","transaction_date":"2025-07-10 00:00:00","upload_date":"2025-07-10 00:00:00","upload_first_byte":"0","upload_dot_number":"01539265","upload_search_indicator":"M","census_search_date":"2025-07-10 21:39:00","snet_input_date":"2025-07-09 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-07-10 21:39:00","insp_carrier_name":"BIG R TRUCKING LLC","insp_carrier_street":"7416 JOHN RALSTON RD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77044","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0264980","created_at":"2025-07-14T10:46:52.000000Z","updated_at":"2025-07-14T10:46:52.000000Z","inspection_violations":[{"id":14694829,"change_date":"2025-07-10 21:39:00","inspection_id":"85181430","insp_violation_id":"267332562","seq_no":"1","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"207808037","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-13T10:49:47.000000Z","updated_at":"2025-07-14T10:48:24.000000Z","normalized_code":"39347E"},{"id":14694830,"change_date":"2025-07-10 21:39:00","inspection_id":"85181430","insp_violation_id":"267332563","seq_no":"2","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"207808037","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-13T10:49:47.000000Z","updated_at":"2025-07-14T10:48:24.000000Z","normalized_code":"39347E"},{"id":14694831,"change_date":"2025-07-10 21:39:00","inspection_id":"85181430","insp_violation_id":"267332564","seq_no":"3","part_no":"393","part_no_section":"47E","insp_viol_unit":"2","insp_unit_id":"207808038","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-13T10:49:47.000000Z","updated_at":"2025-07-14T10:48:24.000000Z","normalized_code":"39347E"},{"id":14694832,"change_date":"2025-07-10 21:39:00","inspection_id":"85181430","insp_violation_id":"267332565","seq_no":"4","part_no":"393","part_no_section":"53B","insp_viol_unit":"1","insp_unit_id":"207808037","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-13T10:49:47.000000Z","updated_at":"2025-07-14T10:48:24.000000Z","normalized_code":"39353B"},{"id":14694833,"change_date":"2025-07-10 21:39:00","inspection_id":"85181430","insp_violation_id":"267332566","seq_no":"5","part_no":"393","part_no_section":"53B","insp_viol_unit":"2","insp_unit_id":"207808038","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-13T10:49:47.000000Z","updated_at":"2025-07-14T10:48:24.000000Z","normalized_code":"39353B"},{"id":14694834,"change_date":"2025-07-10 21:39:00","inspection_id":"85181430","insp_violation_id":"267332567","seq_no":"6","part_no":"396","part_no_section":"3A1BOS","insp_viol_unit":"1","insp_unit_id":"207808037","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-07-13T10:49:47.000000Z","updated_at":"2025-07-14T10:48:24.000000Z","normalized_code":"3963A1BOS"},{"id":14694835,"change_date":"2025-07-10 21:39:00","inspection_id":"85181430","insp_violation_id":"267332568","seq_no":"7","part_no":"393","part_no_section":"45B2UV","insp_viol_unit":"2","insp_unit_id":"207808038","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-13T10:49:47.000000Z","updated_at":"2025-07-14T10:48:24.000000Z","normalized_code":"39345B2UV"},{"id":14694836,"change_date":"2025-07-10 21:39:00","inspection_id":"85181430","insp_violation_id":"267332569","seq_no":"8","part_no":"393","part_no_section":"79","insp_viol_unit":"1","insp_unit_id":"207808037","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-13T10:49:47.000000Z","updated_at":"2025-07-14T10:48:24.000000Z","normalized_code":"39379"},{"id":14694837,"change_date":"2025-07-10 21:39:00","inspection_id":"85181430","insp_violation_id":"267332570","seq_no":"9","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"207808037","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-13T10:49:47.000000Z","updated_at":"2025-07-14T10:48:24.000000Z","normalized_code":"3939"},{"id":14694838,"change_date":"2025-07-10 21:39:00","inspection_id":"85181430","insp_violation_id":"267332571","seq_no":"10","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"207808038","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-13T10:49:47.000000Z","updated_at":"2025-07-14T10:48:24.000000Z","normalized_code":"3939"},{"id":14694839,"change_date":"2025-07-10 21:39:00","inspection_id":"85181430","insp_violation_id":"267332572","seq_no":"11","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"207808038","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-13T10:49:47.000000Z","updated_at":"2025-07-14T10:48:24.000000Z","normalized_code":"3939"},{"id":14694840,"change_date":"2025-07-10 21:39:00","inspection_id":"85181430","insp_violation_id":"267332573","seq_no":"12","part_no":"393","part_no_section":"9BRKLAMP","insp_viol_unit":"2","insp_unit_id":"207808038","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-13T10:49:47.000000Z","updated_at":"2025-07-14T10:48:24.000000Z","normalized_code":"3939BRKLAMP"},{"id":14694841,"change_date":"2025-07-10 21:39:00","inspection_id":"85181430","insp_violation_id":"267332574","seq_no":"13","part_no":"393","part_no_section":"11TU","insp_viol_unit":"1","insp_unit_id":"207808037","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-13T10:49:47.000000Z","updated_at":"2025-07-14T10:48:24.000000Z","normalized_code":"39311TU"},{"id":14694842,"change_date":"2025-07-10 21:39:00","inspection_id":"85181430","insp_violation_id":"267332575","seq_no":"14","part_no":"393","part_no_section":"75A1","insp_viol_unit":"1","insp_unit_id":"207808037","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-13T10:49:47.000000Z","updated_at":"2025-07-14T10:48:24.000000Z","normalized_code":"39375A1"},{"id":14694843,"change_date":"2025-07-10 21:39:00","inspection_id":"85181430","insp_violation_id":"267332576","seq_no":"15","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"207808037","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-13T10:49:47.000000Z","updated_at":"2025-07-14T10:48:24.000000Z","normalized_code":"3939"},{"id":14694844,"change_date":"2025-07-10 21:39:00","inspection_id":"85181430","insp_violation_id":"267332577","seq_no":"16","part_no":"393","part_no_section":"75C","insp_viol_unit":"1","insp_unit_id":"207808037","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-13T10:49:47.000000Z","updated_at":"2025-07-14T10:48:24.000000Z","normalized_code":"39375C"},{"id":14694845,"change_date":"2025-07-10 21:39:00","inspection_id":"85181430","insp_violation_id":"267332578","seq_no":"17","part_no":"393","part_no_section":"75C","insp_viol_unit":"1","insp_unit_id":"207808037","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-13T10:49:47.000000Z","updated_at":"2025-07-14T10:48:24.000000Z","normalized_code":"39375C"},{"id":14694846,"change_date":"2025-07-10 21:39:00","inspection_id":"85181430","insp_violation_id":"267332579","seq_no":"18","part_no":"393","part_no_section":"75A","insp_viol_unit":"1","insp_unit_id":"207808037","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-07-13T10:49:47.000000Z","updated_at":"2025-07-14T10:48:24.000000Z","normalized_code":"39375A"},{"id":14694847,"change_date":"2025-07-10 21:39:00","inspection_id":"85181430","insp_violation_id":"267332580","seq_no":"19","part_no":"393","part_no_section":"55D3","insp_viol_unit":"2","insp_unit_id":"207808038","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-13T10:49:47.000000Z","updated_at":"2025-07-14T10:48:24.000000Z","normalized_code":"39355D3"}],"inspection_per_units":[{"id":14966523,"change_date":"2025-07-10 21:39:00","inspection_id":"85181430","insp_unit_id":"207808037","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"R-50","insp_unit_license":"1M20852","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDDU9X82J898006","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-13T09:46:59.000000Z","updated_at":"2025-07-14T09:45:54.000000Z"},{"id":14966524,"change_date":"2025-07-10 21:39:00","inspection_id":"85181430","insp_unit_id":"207808038","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CPS","insp_unit_company":null,"insp_unit_license":"W35449","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5MC5154216P006000","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-13T09:46:59.000000Z","updated_at":"2025-07-14T09:45:54.000000Z"}]},{"id":7686179,"change_date":"2025-01-23 21:39:00","inspection_id":"83674239","dot_number":"1539265","report_state":"TX","report_number":"71WD9DBVY7","insp_date":"2025-01-09 00:00:00","insp_start_time":"1346","insp_end_time":"1405","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"400 E LOOP N","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-01-22 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"118000","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":"9480431","transaction_code":"C","transaction_date":"2025-01-23 00:00:00","upload_date":"2025-01-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01539265","upload_search_indicator":"M","census_search_date":"2025-01-22 21:39:00","snet_input_date":"2025-01-09 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-01-22 21:39:00","insp_carrier_name":"BIG R TRUCKING LLC","insp_carrier_street":"7416 JOHN RALSTON RD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77044","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0264980","created_at":"2025-03-17T20:57:53.000000Z","updated_at":"2025-03-17T20:57:53.000000Z","inspection_violations":[{"id":12009466,"change_date":"2025-01-23 21:39:00","inspection_id":"83674239","insp_violation_id":"264145370","seq_no":"1","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"204978349","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:31.000000Z","updated_at":"2025-03-17T22:04:31.000000Z","normalized_code":"3939"}],"inspection_per_units":[{"id":12402742,"change_date":"2025-01-23 21:39:00","inspection_id":"83674239","insp_unit_id":"204978348","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"R44","insp_unit_license":"1M74343","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDDB9X07J173771","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:51:52.000000Z","updated_at":"2025-03-17T23:51:52.000000Z"},{"id":12402743,"change_date":"2025-01-23 21:39:00","inspection_id":"83674239","insp_unit_id":"204978349","insp_unit_type_id":"10","insp_unit_number":"2","insp_unit_make":"MANA","insp_unit_company":null,"insp_unit_license":"020C318","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5MC51542X7P008376","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:51:52.000000Z","updated_at":"2025-03-17T23:51:52.000000Z"}]},{"id":7594277,"change_date":"2025-01-10 21:40:00","inspection_id":"83577761","dot_number":"1539265","report_state":"TX","report_number":"71UD9DCOHW","insp_date":"2025-01-07 00:00:00","insp_start_time":"1335","insp_end_time":"1352","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"2100  REED RD","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-01-10 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"118000","viol_total":"12","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"12","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9471044","transaction_code":"A","transaction_date":"2025-01-10 00:00:00","upload_date":"2025-01-10 00:00:00","upload_first_byte":"0","upload_dot_number":"01539265","upload_search_indicator":"M","census_search_date":"2025-01-10 21:40:00","snet_input_date":"2025-01-07 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-01-10 21:40:00","insp_carrier_name":"BIG R TRUCKING LLC","insp_carrier_street":"7416 JOHN RALSTON RD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77044","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0264980","created_at":"2025-03-17T20:55:43.000000Z","updated_at":"2025-03-17T20:55:43.000000Z","inspection_violations":[{"id":11871701,"change_date":"2025-01-10 21:40:00","inspection_id":"83577761","insp_violation_id":"263865465","seq_no":"1","part_no":"393","part_no_section":"9H","insp_viol_unit":"1","insp_unit_id":"204750668","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:50.000000Z","updated_at":"2025-03-17T22:03:50.000000Z","normalized_code":"3939H"},{"id":11871702,"change_date":"2025-01-10 21:40:00","inspection_id":"83577761","insp_violation_id":"263865466","seq_no":"2","part_no":"393","part_no_section":"9TS","insp_viol_unit":"1","insp_unit_id":"204750668","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:50.000000Z","updated_at":"2025-03-17T22:03:50.000000Z","normalized_code":"3939TS"},{"id":11871703,"change_date":"2025-01-10 21:40:00","inspection_id":"83577761","insp_violation_id":"263865467","seq_no":"3","part_no":"393","part_no_section":"9BRKLAMP","insp_viol_unit":"1","insp_unit_id":"204750668","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:50.000000Z","updated_at":"2025-03-17T22:03:50.000000Z","normalized_code":"3939BRKLAMP"},{"id":11871704,"change_date":"2025-01-10 21:40:00","inspection_id":"83577761","insp_violation_id":"263865468","seq_no":"4","part_no":"393","part_no_section":"19","insp_viol_unit":"1","insp_unit_id":"204750668","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:50.000000Z","updated_at":"2025-03-17T22:03:50.000000Z","normalized_code":"39319"},{"id":11871705,"change_date":"2025-01-10 21:40:00","inspection_id":"83577761","insp_violation_id":"263865469","seq_no":"5","part_no":"393","part_no_section":"83G","insp_viol_unit":"1","insp_unit_id":"204750668","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:50.000000Z","updated_at":"2025-03-17T22:03:50.000000Z","normalized_code":"39383G"},{"id":11871706,"change_date":"2025-01-10 21:40:00","inspection_id":"83577761","insp_violation_id":"263865470","seq_no":"6","part_no":"393","part_no_section":"43A","insp_viol_unit":"1","insp_unit_id":"204750668","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:03:50.000000Z","updated_at":"2025-03-17T22:03:50.000000Z","normalized_code":"39343A"},{"id":11871707,"change_date":"2025-01-10 21:40:00","inspection_id":"83577761","insp_violation_id":"263865471","seq_no":"7","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"204750668","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:50.000000Z","updated_at":"2025-03-17T22:03:50.000000Z","normalized_code":"39347E"},{"id":11871708,"change_date":"2025-01-10 21:40:00","inspection_id":"83577761","insp_violation_id":"263865472","seq_no":"8","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"204750668","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:50.000000Z","updated_at":"2025-03-17T22:03:50.000000Z","normalized_code":"39347E"},{"id":11871709,"change_date":"2025-01-10 21:40:00","inspection_id":"83577761","insp_violation_id":"263865473","seq_no":"9","part_no":"393","part_no_section":"53B","insp_viol_unit":"1","insp_unit_id":"204750668","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:50.000000Z","updated_at":"2025-03-17T22:03:50.000000Z","normalized_code":"39353B"},{"id":11871710,"change_date":"2025-01-10 21:40:00","inspection_id":"83577761","insp_violation_id":"263865474","seq_no":"10","part_no":"396","part_no_section":"3A1BOS","insp_viol_unit":"1","insp_unit_id":"204750668","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:03:50.000000Z","updated_at":"2025-03-17T22:03:50.000000Z","normalized_code":"3963A1BOS"},{"id":11871711,"change_date":"2025-01-10 21:40:00","inspection_id":"83577761","insp_violation_id":"263865475","seq_no":"11","part_no":"393","part_no_section":"45B2UV","insp_viol_unit":"2","insp_unit_id":"204750669","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:50.000000Z","updated_at":"2025-03-17T22:03:50.000000Z","normalized_code":"39345B2UV"},{"id":11871712,"change_date":"2025-01-10 21:40:00","inspection_id":"83577761","insp_violation_id":"263865476","seq_no":"12","part_no":"393","part_no_section":"47A","insp_viol_unit":"2","insp_unit_id":"204750669","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:50.000000Z","updated_at":"2025-03-17T22:03:50.000000Z","normalized_code":"39347A"}],"inspection_per_units":[{"id":12253589,"change_date":"2025-01-10 21:40:00","inspection_id":"83577761","insp_unit_id":"204750668","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"R-44","insp_unit_license":"1M74343","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDDB9X07J173771","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:50:14.000000Z","updated_at":"2025-03-17T23:50:14.000000Z"},{"id":12253590,"change_date":"2025-01-10 21:40:00","inspection_id":"83577761","insp_unit_id":"204750669","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MANA","insp_unit_company":null,"insp_unit_license":"020C318","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5MC51542X7P008376","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:50:14.000000Z","updated_at":"2025-03-17T23:50:14.000000Z"}]},{"id":6289896,"change_date":"2024-07-23 21:42:00","inspection_id":"82194067","dot_number":"1539265","report_state":"TX","report_number":"6X199DJVK2","insp_date":"2024-07-18 00:00:00","insp_start_time":"0934","insp_end_time":"1004","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"300  MERCURY","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-07-23 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"9332756","transaction_code":"A","transaction_date":"2024-07-23 00:00:00","upload_date":"2024-07-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01539265","upload_search_indicator":"M","census_search_date":"2024-07-23 21:42:00","snet_input_date":"2024-07-18 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-07-23 21:42:00","insp_carrier_name":"BIG R TRUCKING LLC","insp_carrier_street":"7416 JOHN RALSTON RD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77044","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0264980","created_at":"2025-03-17T20:27:23.000000Z","updated_at":"2025-03-17T20:27:23.000000Z","inspection_violations":[{"id":9769647,"change_date":"2024-07-23 21:42:00","inspection_id":"82194067","insp_violation_id":"260801750","seq_no":"1","part_no":"393","part_no_section":"55(c)(1)","insp_viol_unit":"1","insp_unit_id":"202031051","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:16.000000Z","updated_at":"2025-03-17T21:53:16.000000Z","normalized_code":"39355C1"},{"id":9769648,"change_date":"2024-07-23 21:42:00","inspection_id":"82194067","insp_violation_id":"260801751","seq_no":"2","part_no":"393","part_no_section":"55(e)","insp_viol_unit":"2","insp_unit_id":"202031052","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:16.000000Z","updated_at":"2025-03-17T21:53:16.000000Z","normalized_code":"39355E"},{"id":9769649,"change_date":"2024-07-23 21:42:00","inspection_id":"82194067","insp_violation_id":"260801752","seq_no":"3","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"2","insp_unit_id":"202031052","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:53:16.000000Z","updated_at":"2025-03-17T21:53:16.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":10134952,"change_date":"2024-07-23 21:42:00","inspection_id":"82194067","insp_unit_id":"202031051","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"R44","insp_unit_license":"1M74343","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDDB9X07J173771","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:27:58.000000Z","updated_at":"2025-03-17T23:27:58.000000Z"},{"id":10134953,"change_date":"2024-07-23 21:42:00","inspection_id":"82194067","insp_unit_id":"202031052","insp_unit_type_id":"10","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":null,"insp_unit_license":"020C318","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5MC51542X7P008376","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:27:58.000000Z","updated_at":"2025-03-17T23:27:58.000000Z"}]},{"id":6199372,"change_date":"2024-07-11 21:41:00","inspection_id":"82096971","dot_number":"1539265","report_state":"TX","report_number":"V241385720","insp_date":"2024-06-27 00:00:00","insp_start_time":"1213","insp_end_time":"1345","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"LAT:29  37'37.02\"N L","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"ARCOSA CONSTRUCTION SERVICES","shipping_paper_number":"113169","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-07-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","viol_total":"5","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9324003","transaction_code":"A","transaction_date":"2024-07-11 00:00:00","upload_date":"2024-07-11 00:00:00","upload_first_byte":"0","upload_dot_number":"01539265","upload_search_indicator":"M","census_search_date":"2024-07-11 21:41:00","snet_input_date":"2024-06-27 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-07-11 21:41:00","insp_carrier_name":"BIG R TRUCKING LLC","insp_carrier_street":"7416 JOHN RALSTON RD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77044","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0264980","created_at":"2025-03-17T20:25:26.000000Z","updated_at":"2025-03-17T20:25:26.000000Z","inspection_violations":[{"id":9628592,"change_date":"2024-07-11 21:41:00","inspection_id":"82096971","insp_violation_id":"260597815","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"201845405","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:36.000000Z","updated_at":"2025-03-17T21:52:36.000000Z","normalized_code":"39311"},{"id":9628593,"change_date":"2024-07-11 21:41:00","inspection_id":"82096971","insp_violation_id":"260597816","seq_no":"2","part_no":"393","part_no_section":"55(d)(3)","insp_viol_unit":"2","insp_unit_id":"201845406","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:36.000000Z","updated_at":"2025-03-17T21:52:36.000000Z","normalized_code":"39355D3"},{"id":9628594,"change_date":"2024-07-11 21:41:00","inspection_id":"82096971","insp_violation_id":"260597817","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"201845406","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:52:36.000000Z","updated_at":"2025-03-17T21:52:36.000000Z","normalized_code":"3939A"},{"id":9628595,"change_date":"2024-07-11 21:41:00","inspection_id":"82096971","insp_violation_id":"260597818","seq_no":"4","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"201845405","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:36.000000Z","updated_at":"2025-03-17T21:52:36.000000Z","normalized_code":"3965B"},{"id":9628596,"change_date":"2024-07-11 21:41:00","inspection_id":"82096971","insp_violation_id":"260597819","seq_no":"5","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"201845405","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:36.000000Z","updated_at":"2025-03-17T21:52:36.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9987146,"change_date":"2024-07-11 21:41:00","inspection_id":"82096971","insp_unit_id":"201845405","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"R-15","insp_unit_license":"1M20853","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDDU9X04J062922","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:26:31.000000Z","updated_at":"2025-03-17T23:26:31.000000Z"},{"id":9987147,"change_date":"2024-07-11 21:41:00","inspection_id":"82096971","insp_unit_id":"201845406","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CPS","insp_unit_company":null,"insp_unit_license":"039C530","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4Z45154282P003895","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:26:31.000000Z","updated_at":"2025-03-17T23:26:31.000000Z"}]},{"id":6096082,"change_date":"2024-06-27 21:41:00","inspection_id":"81986042","dot_number":"1539265","report_state":"TX","report_number":"6WEA9DCAK8","insp_date":"2024-06-25 00:00:00","insp_start_time":"1026","insp_end_time":"1138","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"2000  REED RD","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-06-27 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","viol_total":"12","oos_total":"4","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"12","vehicle_oos_total":"4","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9311022","transaction_code":"A","transaction_date":"2024-06-27 00:00:00","upload_date":"2024-06-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01539265","upload_search_indicator":"M","census_search_date":"2024-06-27 21:41:00","snet_input_date":"2024-06-25 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-06-27 21:41:00","insp_carrier_name":"BIG R TRUCKING LLC","insp_carrier_street":"7416 JOHN RALSTON RD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77044","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0264980","created_at":"2025-03-17T20:23:25.000000Z","updated_at":"2025-03-17T20:23:25.000000Z","inspection_violations":[{"id":9462402,"change_date":"2024-06-27 21:41:00","inspection_id":"81986042","insp_violation_id":"260359054","seq_no":"1","part_no":"390","part_no_section":"21(a)","insp_viol_unit":"1","insp_unit_id":"201631631","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:49.000000Z","updated_at":"2025-03-17T21:51:49.000000Z","normalized_code":"39021A"},{"id":9462403,"change_date":"2024-06-27 21:41:00","inspection_id":"81986042","insp_violation_id":"260359055","seq_no":"2","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"201631631","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:49.000000Z","updated_at":"2025-03-17T21:51:49.000000Z","normalized_code":"39360C"},{"id":9462404,"change_date":"2024-06-27 21:41:00","inspection_id":"81986042","insp_violation_id":"260359056","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"201631631","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:49.000000Z","updated_at":"2025-03-17T21:51:49.000000Z","normalized_code":"3939A"},{"id":9462405,"change_date":"2024-06-27 21:41:00","inspection_id":"81986042","insp_violation_id":"260359057","seq_no":"4","part_no":"393","part_no_section":"75(a)(1)","insp_viol_unit":"2","insp_unit_id":"201631632","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:49.000000Z","updated_at":"2025-03-17T21:51:49.000000Z","normalized_code":"39375A1"},{"id":9462406,"change_date":"2024-06-27 21:41:00","inspection_id":"81986042","insp_violation_id":"260359058","seq_no":"5","part_no":"393","part_no_section":"207(g)","insp_viol_unit":"1","insp_unit_id":"201631631","insp_violation_category_id":"22","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:49.000000Z","updated_at":"2025-03-17T21:51:49.000000Z","normalized_code":"393207G"},{"id":9462407,"change_date":"2024-06-27 21:41:00","inspection_id":"81986042","insp_violation_id":"260359059","seq_no":"6","part_no":"393","part_no_section":"83(g)","insp_viol_unit":"1","insp_unit_id":"201631631","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:49.000000Z","updated_at":"2025-03-17T21:51:49.000000Z","normalized_code":"39383G"},{"id":9462408,"change_date":"2024-06-27 21:41:00","inspection_id":"81986042","insp_violation_id":"260359060","seq_no":"7","part_no":"393","part_no_section":"47(a)","insp_viol_unit":"1","insp_unit_id":"201631631","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:49.000000Z","updated_at":"2025-03-17T21:51:49.000000Z","normalized_code":"39347A"},{"id":9462409,"change_date":"2024-06-27 21:41:00","inspection_id":"81986042","insp_violation_id":"260359061","seq_no":"8","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"201631631","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:51:49.000000Z","updated_at":"2025-03-17T21:51:49.000000Z","normalized_code":"3963A1"},{"id":9462410,"change_date":"2024-06-27 21:41:00","inspection_id":"81986042","insp_violation_id":"260359062","seq_no":"9","part_no":"393","part_no_section":"47(a)","insp_viol_unit":"1","insp_unit_id":"201631631","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:49.000000Z","updated_at":"2025-03-17T21:51:49.000000Z","normalized_code":"39347A"},{"id":9462411,"change_date":"2024-06-27 21:41:00","inspection_id":"81986042","insp_violation_id":"260359063","seq_no":"10","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"201631631","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:51:49.000000Z","updated_at":"2025-03-17T21:51:49.000000Z","normalized_code":"3965B"},{"id":9462412,"change_date":"2024-06-27 21:41:00","inspection_id":"81986042","insp_violation_id":"260359064","seq_no":"11","part_no":"393","part_no_section":"47(d)","insp_viol_unit":"1","insp_unit_id":"201631631","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:51:49.000000Z","updated_at":"2025-03-17T21:51:49.000000Z","normalized_code":"39347D"},{"id":9462413,"change_date":"2024-06-27 21:41:00","inspection_id":"81986042","insp_violation_id":"260359065","seq_no":"12","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"201631631","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:51:49.000000Z","updated_at":"2025-03-17T21:51:49.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":9818843,"change_date":"2024-06-27 21:41:00","inspection_id":"81986042","insp_unit_id":"201631631","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"1M20852","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDDU9X82J898006","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:24:42.000000Z","updated_at":"2025-03-17T23:24:42.000000Z"},{"id":9818844,"change_date":"2024-06-27 21:41:00","inspection_id":"81986042","insp_unit_id":"201631632","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CPS","insp_unit_company":null,"insp_unit_license":"W35449","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5MC5154216P006000","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:24:42.000000Z","updated_at":"2025-03-17T23:24:42.000000Z"}]},{"id":5566217,"change_date":"2024-04-22 21:41:00","inspection_id":"81411336","dot_number":"1539265","report_state":"TX","report_number":"6UH89DNNKV","insp_date":"2024-04-17 00:00:00","insp_start_time":"0852","insp_end_time":"0918","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":"2024-04-22 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"124000","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":"9253087","transaction_code":"A","transaction_date":"2024-04-22 00:00:00","upload_date":"2024-04-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01539265","upload_search_indicator":"M","census_search_date":"2024-04-22 21:41:00","snet_input_date":"2024-04-17 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-04-22 21:41:00","insp_carrier_name":"BIG R TRUCKING LLC","insp_carrier_street":"7416 JOHN RALSTON RD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77044","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0264980","created_at":"2025-03-17T20:13:07.000000Z","updated_at":"2025-03-17T20:13:07.000000Z","inspection_violations":[{"id":8602461,"change_date":"2024-04-22 21:41:00","inspection_id":"81411336","insp_violation_id":"259060965","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"200511236","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:42.000000Z","updated_at":"2025-03-17T21:47:42.000000Z","normalized_code":"3922"},{"id":8602462,"change_date":"2024-04-22 21:41:00","inspection_id":"81411336","insp_violation_id":"259060966","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"200511237","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:42.000000Z","updated_at":"2025-03-17T21:47:42.000000Z","normalized_code":"3922"},{"id":8602463,"change_date":"2024-04-22 21:41:00","inspection_id":"81411336","insp_violation_id":"259060967","seq_no":"3","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"200511236","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:42.000000Z","updated_at":"2025-03-17T21:47:42.000000Z","normalized_code":"39395A"},{"id":8602464,"change_date":"2024-04-22 21:41:00","inspection_id":"81411336","insp_violation_id":"259060968","seq_no":"4","part_no":"393","part_no_section":"55(e)","insp_viol_unit":"2","insp_unit_id":"200511237","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:42.000000Z","updated_at":"2025-03-17T21:47:42.000000Z","normalized_code":"39355E"},{"id":8602465,"change_date":"2024-04-22 21:41:00","inspection_id":"81411336","insp_violation_id":"259060969","seq_no":"5","part_no":"393","part_no_section":"201(d)","insp_viol_unit":"2","insp_unit_id":"200511237","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:42.000000Z","updated_at":"2025-03-17T21:47:42.000000Z","normalized_code":"393201D"}],"inspection_per_units":[{"id":8966223,"change_date":"2024-04-22 21:41:00","inspection_id":"81411336","insp_unit_id":"200511236","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"R15","insp_unit_license":"1M20853","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDDU9X04J062922","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:16:26.000000Z","updated_at":"2025-03-17T23:16:26.000000Z"},{"id":8966224,"change_date":"2024-04-22 21:41:00","inspection_id":"81411336","insp_unit_id":"200511237","insp_unit_type_id":"10","insp_unit_number":"2","insp_unit_make":"CLEM","insp_unit_company":null,"insp_unit_license":"124B344","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5C2BB32B04M004245","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:16:26.000000Z","updated_at":"2025-03-17T23:16:26.000000Z"}]},{"id":4562429,"change_date":"2023-12-05 21:43:00","inspection_id":"80314715","dot_number":"1539265","report_state":"TX","report_number":"6QD99DBFWV","insp_date":"2023-11-21 00:00:00","insp_start_time":"0853","insp_end_time":"0932","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"15900  PENINSULA BLV","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-12-05 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"5","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9139397","transaction_code":"A","transaction_date":"2023-12-05 00:00:00","upload_date":"2023-12-05 00:00:00","upload_first_byte":"0","upload_dot_number":"01539265","upload_search_indicator":"M","census_search_date":"2023-12-05 21:43:00","snet_input_date":"2023-11-21 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-12-05 21:43:00","insp_carrier_name":"BIG R TRUCKING LLC","insp_carrier_street":"7416 JOHN RALSTON RD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77044","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0264980","created_at":"2025-03-17T19:53:22.000000Z","updated_at":"2025-03-17T19:53:22.000000Z","inspection_violations":[{"id":7056244,"change_date":"2023-12-05 21:43:00","inspection_id":"80314715","insp_violation_id":"256724781","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"198360298","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:02.000000Z","updated_at":"2025-03-17T21:40:02.000000Z","normalized_code":"39311"},{"id":7056245,"change_date":"2023-12-05 21:43:00","inspection_id":"80314715","insp_violation_id":"256724782","seq_no":"2","part_no":"393","part_no_section":"55(e)","insp_viol_unit":"2","insp_unit_id":"198360299","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:02.000000Z","updated_at":"2025-03-17T21:40:02.000000Z","normalized_code":"39355E"},{"id":7056246,"change_date":"2023-12-05 21:43:00","inspection_id":"80314715","insp_violation_id":"256724783","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"198360299","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:02.000000Z","updated_at":"2025-03-17T21:40:02.000000Z","normalized_code":"3939A"},{"id":7056247,"change_date":"2023-12-05 21:43:00","inspection_id":"80314715","insp_violation_id":"256724784","seq_no":"4","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"198360298","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:02.000000Z","updated_at":"2025-03-17T21:40:02.000000Z","normalized_code":"3965B"},{"id":7056248,"change_date":"2023-12-05 21:43:00","inspection_id":"80314715","insp_violation_id":"256724785","seq_no":"5","part_no":"393","part_no_section":"47(a)","insp_viol_unit":"1","insp_unit_id":"198360298","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:40:02.000000Z","updated_at":"2025-03-17T21:40:02.000000Z","normalized_code":"39347A"}],"inspection_per_units":[{"id":7338007,"change_date":"2023-12-05 21:43:00","inspection_id":"80314715","insp_unit_id":"198360298","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KNNW","insp_unit_company":"2","insp_unit_license":"1M20853","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDDU9X04J062922","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:39.000000Z","updated_at":"2025-03-17T23:01:39.000000Z"},{"id":7338008,"change_date":"2023-12-05 21:43:00","inspection_id":"80314715","insp_unit_id":"198360299","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CLEM","insp_unit_company":"TR-05","insp_unit_license":"124B344","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5C2BB32B04M004245","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:39.000000Z","updated_at":"2025-03-17T23:01:39.000000Z"}]},{"id":4476134,"change_date":"2023-11-21 21:40:00","inspection_id":"80219714","dot_number":"1539265","report_state":"TX","report_number":"V231163727","insp_date":"2023-11-15 00:00:00","insp_start_time":"0842","insp_end_time":"0912","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"15915 PENINSULA ST","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"BWC TERMINALS","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-11-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"118000","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":"9130195","transaction_code":"A","transaction_date":"2023-11-21 00:00:00","upload_date":"2023-11-21 00:00:00","upload_first_byte":"0","upload_dot_number":"01539265","upload_search_indicator":"M","census_search_date":"2023-11-21 21:40:00","snet_input_date":"2023-11-15 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-11-21 21:40:00","insp_carrier_name":"BIG R TRUCKING LLC","insp_carrier_street":"7416 JOHN RALSTON RD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77044","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0264980","created_at":"2025-03-17T19:51:27.000000Z","updated_at":"2025-03-17T19:51:27.000000Z","inspection_violations":[{"id":6929811,"change_date":"2023-11-21 21:40:00","inspection_id":"80219714","insp_violation_id":"256521983","seq_no":"1","part_no":"393","part_no_section":"55(d)(3)","insp_viol_unit":"2","insp_unit_id":"198172963","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:25.000000Z","updated_at":"2025-03-17T21:39:25.000000Z","normalized_code":"39355D3"},{"id":6929812,"change_date":"2023-11-21 21:40:00","inspection_id":"80219714","insp_violation_id":"256521984","seq_no":"2","part_no":"393","part_no_section":"55(d)(3)","insp_viol_unit":"2","insp_unit_id":"198172963","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:25.000000Z","updated_at":"2025-03-17T21:39:25.000000Z","normalized_code":"39355D3"},{"id":6929813,"change_date":"2023-11-21 21:40:00","inspection_id":"80219714","insp_violation_id":"256521985","seq_no":"3","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"198172962","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:25.000000Z","updated_at":"2025-03-17T21:39:25.000000Z","normalized_code":"39360C"},{"id":6929814,"change_date":"2023-11-21 21:40:00","inspection_id":"80219714","insp_violation_id":"256521986","seq_no":"4","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"2","insp_unit_id":"198172963","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:39:25.000000Z","updated_at":"2025-03-17T21:39:25.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":7198920,"change_date":"2023-11-21 21:40:00","inspection_id":"80219714","insp_unit_id":"198172962","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"R-44","insp_unit_license":"1M74343","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDDB9X07J173771","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:00:27.000000Z","updated_at":"2025-03-17T23:00:27.000000Z"},{"id":7198921,"change_date":"2023-11-21 21:40:00","inspection_id":"80219714","insp_unit_id":"198172963","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CPS","insp_unit_company":"R-44","insp_unit_license":"020C318","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5MC51542X7P008376","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:00:27.000000Z","updated_at":"2025-03-17T23:00:27.000000Z"}]},{"id":3771417,"change_date":"2023-08-17 21:44:00","inspection_id":"79437967","dot_number":"1539265","report_state":"TX","report_number":"6NMC9DGT5C","insp_date":"2023-08-14 00:00:00","insp_start_time":"1220","insp_end_time":"1305","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"200  MERCURY DR","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"TOTAL SITE","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-17 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","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":"9054811","transaction_code":"A","transaction_date":"2023-08-17 00:00:00","upload_date":"2023-08-17 00:00:00","upload_first_byte":"0","upload_dot_number":"01539265","upload_search_indicator":"M","census_search_date":"2023-08-17 21:44:00","snet_input_date":"2023-08-14 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-08-17 21:44:00","insp_carrier_name":"BIG R TRUCKING LLC","insp_carrier_street":"7416 JOHN RALSTON RD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77044","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0264980","created_at":"2025-03-17T19:37:18.000000Z","updated_at":"2025-03-17T19:37:18.000000Z","inspection_violations":[{"id":5817135,"change_date":"2023-08-17 21:44:00","inspection_id":"79437967","insp_violation_id":"254727986","seq_no":"1","part_no":"393","part_no_section":"209(d)","insp_viol_unit":"1","insp_unit_id":"196596522","insp_violation_category_id":"21","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:33:56.000000Z","updated_at":"2025-03-17T21:33:56.000000Z","normalized_code":"393209D"}],"inspection_per_units":[{"id":6063789,"change_date":"2023-08-17 21:44:00","inspection_id":"79437967","insp_unit_id":"196596522","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"R50","insp_unit_license":"1M20852","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDDU9X82J898006","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:57.000000Z","updated_at":"2025-03-17T22:50:57.000000Z"},{"id":6063790,"change_date":"2023-08-17 21:44:00","inspection_id":"79437967","insp_unit_id":"196596523","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CPS","insp_unit_company":null,"insp_unit_license":"W35449","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5MC5154216P006000","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:50:57.000000Z","updated_at":"2025-03-17T22:50:57.000000Z"}]},{"id":3569732,"change_date":"2023-07-21 21:41:00","inspection_id":"79212398","dot_number":"1539265","report_state":"TX","report_number":"6MWC9DBAXB","insp_date":"2023-07-19 00:00:00","insp_start_time":"1205","insp_end_time":"1240","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"13322  HOMESTEAD ROA","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"BIG R TRUCKING LLC","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-07-21 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","viol_total":"4","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9033884","transaction_code":"A","transaction_date":"2023-07-21 00:00:00","upload_date":"2023-07-21 00:00:00","upload_first_byte":"0","upload_dot_number":"01539265","upload_search_indicator":"M","census_search_date":"2023-07-21 21:41:00","snet_input_date":"2023-07-19 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-07-21 21:41:00","insp_carrier_name":"BIG R TRUCKING LLC","insp_carrier_street":"7416 JOHN RALSTON RD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77044","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0264980","created_at":"2025-03-17T19:33:32.000000Z","updated_at":"2025-03-17T19:33:32.000000Z","inspection_violations":[{"id":5504827,"change_date":"2023-07-21 21:41:00","inspection_id":"79212398","insp_violation_id":"254215109","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"40","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:33.000000Z","updated_at":"2025-03-17T21:32:33.000000Z","normalized_code":"3922"},{"id":5504828,"change_date":"2023-07-21 21:41:00","inspection_id":"79212398","insp_violation_id":"254215110","seq_no":"2","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"196137083","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:33.000000Z","updated_at":"2025-03-17T21:32:33.000000Z","normalized_code":"39311"},{"id":5504829,"change_date":"2023-07-21 21:41:00","inspection_id":"79212398","insp_violation_id":"254215111","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"196137083","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:33.000000Z","updated_at":"2025-03-17T21:32:33.000000Z","normalized_code":"3939A"},{"id":5504830,"change_date":"2023-07-21 21:41:00","inspection_id":"79212398","insp_violation_id":"254215112","seq_no":"4","part_no":"393","part_no_section":"55(d)(1)","insp_viol_unit":"1","insp_unit_id":"196137082","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:33.000000Z","updated_at":"2025-03-17T21:32:33.000000Z","normalized_code":"39355D1"}],"inspection_per_units":[{"id":5739817,"change_date":"2023-07-21 21:41:00","inspection_id":"79212398","insp_unit_id":"196137082","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"R50","insp_unit_license":"1M20852","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDDU9X82J898006","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:17.000000Z","updated_at":"2025-03-17T22:48:17.000000Z"},{"id":5739818,"change_date":"2023-07-21 21:41:00","inspection_id":"79212398","insp_unit_id":"196137083","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CPS","insp_unit_company":null,"insp_unit_license":"W35449","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5MC5154216P006000","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:17.000000Z","updated_at":"2025-03-17T22:48:17.000000Z"}]},{"id":3184260,"change_date":"2023-05-31 21:43:00","inspection_id":"78778712","dot_number":"1539265","report_state":"TX","report_number":"6LDA9DCGQP","insp_date":"2023-05-25 00:00:00","insp_start_time":"1042","insp_end_time":"1105","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"2200  WAYSIDE","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-05-31 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"3","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8993312","transaction_code":"A","transaction_date":"2023-05-31 00:00:00","upload_date":"2023-05-31 00:00:00","upload_first_byte":"0","upload_dot_number":"01539265","upload_search_indicator":"M","census_search_date":"2023-05-31 21:43:00","snet_input_date":"2023-05-25 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-05-31 21:43:00","insp_carrier_name":"BIG R TRUCKING LLC","insp_carrier_street":"7416 JOHN RALSTON RD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77044","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0264980","created_at":"2025-03-17T19:26:04.000000Z","updated_at":"2025-03-17T19:26:04.000000Z","inspection_violations":[{"id":4907437,"change_date":"2023-05-31 21:43:00","inspection_id":"78778712","insp_violation_id":"253195657","seq_no":"1","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"195241106","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:29:51.000000Z","updated_at":"2025-03-17T21:29:51.000000Z","normalized_code":"39375A3"},{"id":4907438,"change_date":"2023-05-31 21:43:00","inspection_id":"78778712","insp_violation_id":"253195658","seq_no":"2","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"2","insp_unit_id":"195241107","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:29:51.000000Z","updated_at":"2025-03-17T21:29:51.000000Z","normalized_code":"39375A3"},{"id":4907439,"change_date":"2023-05-31 21:43:00","inspection_id":"78778712","insp_violation_id":"253195659","seq_no":"3","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"2","insp_unit_id":"195241107","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:51.000000Z","updated_at":"2025-03-17T21:29:51.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":5122219,"change_date":"2023-05-31 21:43:00","inspection_id":"78778712","insp_unit_id":"195241106","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"1M74343","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDDB9X07J173771","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:43:22.000000Z","updated_at":"2025-03-17T22:43:22.000000Z"},{"id":5122220,"change_date":"2023-05-31 21:43:00","inspection_id":"78778712","insp_unit_id":"195241107","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CLEM","insp_unit_company":null,"insp_unit_license":"176C921","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5C2BB37B69M007179","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:43:22.000000Z","updated_at":"2025-03-17T22:43:22.000000Z"}]},{"id":3145426,"change_date":"2023-05-25 21:42:00","inspection_id":"78734552","dot_number":"1539265","report_state":"TX","report_number":"6L3F9DCN5K","insp_date":"2023-05-15 00:00:00","insp_start_time":"1551","insp_end_time":"1616","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"4700  NORTH SERVICE","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"WM","shipping_paper_number":"456603","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-25 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"4","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8988425","transaction_code":"A","transaction_date":"2023-05-25 00:00:00","upload_date":"2023-05-25 00:00:00","upload_first_byte":"0","upload_dot_number":"01539265","upload_search_indicator":"M","census_search_date":"2023-05-25 21:42:00","snet_input_date":"2023-05-15 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-05-25 21:42:00","insp_carrier_name":"BIG R TRUCKING LLC","insp_carrier_street":"7416 JOHN RALSTON RD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77044","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0264980","created_at":"2025-03-17T19:25:20.000000Z","updated_at":"2025-03-17T19:25:20.000000Z","inspection_violations":[{"id":4843732,"change_date":"2023-05-25 21:42:00","inspection_id":"78734552","insp_violation_id":"253091858","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"195152758","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:29:33.000000Z","updated_at":"2025-03-17T21:29:33.000000Z","normalized_code":"3963A1"},{"id":4843733,"change_date":"2023-05-25 21:42:00","inspection_id":"78734552","insp_violation_id":"253091859","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"195152758","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:33.000000Z","updated_at":"2025-03-17T21:29:33.000000Z","normalized_code":"3939A"},{"id":4843734,"change_date":"2023-05-25 21:42:00","inspection_id":"78734552","insp_violation_id":"253091860","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"195152759","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:33.000000Z","updated_at":"2025-03-17T21:29:33.000000Z","normalized_code":"3939A"},{"id":4843735,"change_date":"2023-05-25 21:42:00","inspection_id":"78734552","insp_violation_id":"253091861","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"195152759","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:29:33.000000Z","updated_at":"2025-03-17T21:29:33.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":5059127,"change_date":"2023-05-25 21:42:00","inspection_id":"78734552","insp_unit_id":"195152758","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"1M74343","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDDB9X07J173771","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:52.000000Z","updated_at":"2025-03-17T22:42:52.000000Z"},{"id":5059128,"change_date":"2023-05-25 21:42:00","inspection_id":"78734552","insp_unit_id":"195152759","insp_unit_type_id":"10","insp_unit_number":"2","insp_unit_make":"CLEM","insp_unit_company":null,"insp_unit_license":"176C921","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5C2BB37B69M007179","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:52.000000Z","updated_at":"2025-03-17T22:42:52.000000Z"}]},{"id":2668105,"change_date":"2023-03-27 21:40:00","inspection_id":"78193723","dot_number":"1539265","report_state":"TX","report_number":"6JM80VHE8X","insp_date":"2023-03-23 00:00:00","insp_start_time":"0800","insp_end_time":"0825","registration_date":"2023-03-27 00:00:00","region":"CT","ci_status_code":"C","location":null,"location_desc":"FAIRBANKS N HOUSTON","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":"N","pen_cen_match":null,"final_status_date":"2023-03-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"5","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8938061","transaction_code":"A","transaction_date":"2023-03-27 00:00:00","upload_date":"2023-03-27 00:00:00","upload_first_byte":"0","upload_dot_number":"01539265","upload_search_indicator":"M","census_search_date":"2023-03-27 21:40:00","snet_input_date":"2023-03-23 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-03-27 21:40:00","insp_carrier_name":"BIG R TRUCKING LLC","insp_carrier_street":"7416 JOHN RALSTON RD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77044","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0264980","created_at":"2025-03-17T19:15:52.000000Z","updated_at":"2025-03-17T19:15:52.000000Z","inspection_violations":[{"id":4101361,"change_date":"2023-03-27 21:40:00","inspection_id":"78193723","insp_violation_id":"251887150","seq_no":"1","part_no":"393","part_no_section":"60(d)","insp_viol_unit":"1","insp_unit_id":"194081454","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:14.000000Z","updated_at":"2025-03-17T21:26:14.000000Z","normalized_code":"39360D"},{"id":4101362,"change_date":"2023-03-27 21:40:00","inspection_id":"78193723","insp_violation_id":"251887151","seq_no":"2","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"194081454","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:14.000000Z","updated_at":"2025-03-17T21:26:14.000000Z","normalized_code":"39378"},{"id":4101363,"change_date":"2023-03-27 21:40:00","inspection_id":"78193723","insp_violation_id":"251887152","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"194081455","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:14.000000Z","updated_at":"2025-03-17T21:26:14.000000Z","normalized_code":"3939A"},{"id":4101364,"change_date":"2023-03-27 21:40:00","inspection_id":"78193723","insp_violation_id":"251887153","seq_no":"4","part_no":"393","part_no_section":"83(g)","insp_viol_unit":"1","insp_unit_id":"194081454","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:14.000000Z","updated_at":"2025-03-17T21:26:14.000000Z","normalized_code":"39383G"},{"id":4101365,"change_date":"2023-03-27 21:40:00","inspection_id":"78193723","insp_violation_id":"251887154","seq_no":"5","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"194081454","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:14.000000Z","updated_at":"2025-03-17T21:26:14.000000Z","normalized_code":"39311"}],"inspection_per_units":[{"id":4296317,"change_date":"2023-03-27 21:40:00","inspection_id":"78193723","insp_unit_id":"194081454","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"1M74343","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDDB9X07J173771","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:51.000000Z","updated_at":"2025-03-17T22:36:51.000000Z"},{"id":4296318,"change_date":"2023-03-27 21:40:00","inspection_id":"78193723","insp_unit_id":"194081455","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CPS","insp_unit_company":null,"insp_unit_license":"020C318","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5MC51542X7P008376","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:51.000000Z","updated_at":"2025-03-17T22:36:51.000000Z"}]},{"id":2504118,"change_date":"2023-03-09 21:43:00","inspection_id":"78007548","dot_number":"1539265","report_state":"TX","report_number":"6J189DCQD6","insp_date":"2023-03-02 00:00:00","insp_start_time":"0800","insp_end_time":"0830","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"1500  KANE","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"JOB SITE","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-03-03 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","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":"8920495","transaction_code":"C","transaction_date":"2023-03-09 00:00:00","upload_date":"2023-03-09 00:00:00","upload_first_byte":"0","upload_dot_number":"01539265","upload_search_indicator":"M","census_search_date":"2023-03-03 21:41:00","snet_input_date":"2023-03-02 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-03-03 21:41:00","insp_carrier_name":"BIG R TRUCKING LLC","insp_carrier_street":"7416 JOHN RALSTON RD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77044","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0264980","created_at":"2025-03-17T19:12:54.000000Z","updated_at":"2025-03-17T19:12:54.000000Z","inspection_violations":[{"id":3852342,"change_date":"2023-03-09 21:43:00","inspection_id":"78007548","insp_violation_id":"251579329","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"193799447","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:04.000000Z","updated_at":"2025-03-17T21:25:04.000000Z","normalized_code":"3939A"},{"id":3852343,"change_date":"2023-03-09 21:43:00","inspection_id":"78007548","insp_violation_id":"251579330","seq_no":"3","part_no":"393","part_no_section":"55(e)","insp_viol_unit":"2","insp_unit_id":"193799447","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:04.000000Z","updated_at":"2025-03-17T21:25:04.000000Z","normalized_code":"39355E"}],"inspection_per_units":[{"id":4029765,"change_date":"2023-03-09 21:43:00","inspection_id":"78007548","insp_unit_id":"193799446","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"R50","insp_unit_license":"1M20852","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDDU9X82J898006","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:52.000000Z","updated_at":"2025-03-17T22:34:52.000000Z"},{"id":4029766,"change_date":"2023-03-09 21:43:00","inspection_id":"78007548","insp_unit_id":"193799447","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":null,"insp_unit_license":"W35449","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5MC5154216P006000","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:52.000000Z","updated_at":"2025-03-17T22:34:52.000000Z"}]},{"id":2258452,"change_date":"2023-01-30 21:44:00","inspection_id":"77727778","dot_number":"1539265","report_state":"TX","report_number":"6GME9DCOB8","insp_date":"2022-12-05 00:00:00","insp_start_time":"1444","insp_end_time":"1515","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"6800  RANKIN RD","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CHERRY DEMOLITION","shipping_paper_number":"00746405","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-01-30 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"124000","viol_total":"15","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"15","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8891149","transaction_code":"A","transaction_date":"2023-01-30 00:00:00","upload_date":"2023-01-30 00:00:00","upload_first_byte":"0","upload_dot_number":"01539265","upload_search_indicator":"M","census_search_date":"2023-01-30 21:44:00","snet_input_date":"2022-12-05 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-01-30 21:44:00","insp_carrier_name":"BIG R TRUCKING LLC","insp_carrier_street":"7416 JOHN RALSTON RD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77044","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0264980","created_at":"2025-03-17T19:08:10.000000Z","updated_at":"2025-03-17T19:08:10.000000Z","inspection_violations":[{"id":3486516,"change_date":"2023-01-30 21:44:00","inspection_id":"77727778","insp_violation_id":"250854687","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"193137135","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:29.000000Z","updated_at":"2025-03-17T21:23:29.000000Z","normalized_code":"39311"},{"id":3486517,"change_date":"2023-01-30 21:44:00","inspection_id":"77727778","insp_violation_id":"250854688","seq_no":"2","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"193137135","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:29.000000Z","updated_at":"2025-03-17T21:23:29.000000Z","normalized_code":"39311"},{"id":3486518,"change_date":"2023-01-30 21:44:00","inspection_id":"77727778","insp_violation_id":"250854689","seq_no":"3","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"193137135","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:23:29.000000Z","updated_at":"2025-03-17T21:23:29.000000Z","normalized_code":"3963A1"},{"id":3486519,"change_date":"2023-01-30 21:44:00","inspection_id":"77727778","insp_violation_id":"250854690","seq_no":"4","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"193137135","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:29.000000Z","updated_at":"2025-03-17T21:23:29.000000Z","normalized_code":"39345B2"},{"id":3486520,"change_date":"2023-01-30 21:44:00","inspection_id":"77727778","insp_violation_id":"250854691","seq_no":"5","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"193137135","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:29.000000Z","updated_at":"2025-03-17T21:23:29.000000Z","normalized_code":"39345B2"},{"id":3486521,"change_date":"2023-01-30 21:44:00","inspection_id":"77727778","insp_violation_id":"250854692","seq_no":"10","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"193137135","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:29.000000Z","updated_at":"2025-03-17T21:23:29.000000Z","normalized_code":"39347E"},{"id":3486522,"change_date":"2023-01-30 21:44:00","inspection_id":"77727778","insp_violation_id":"250854693","seq_no":"11","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"193137135","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:29.000000Z","updated_at":"2025-03-17T21:23:29.000000Z","normalized_code":"39353B"},{"id":3486523,"change_date":"2023-01-30 21:44:00","inspection_id":"77727778","insp_violation_id":"250854694","seq_no":"12","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"2","insp_unit_id":"193137136","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:29.000000Z","updated_at":"2025-03-17T21:23:29.000000Z","normalized_code":"39347E"},{"id":3486524,"change_date":"2023-01-30 21:44:00","inspection_id":"77727778","insp_violation_id":"250854695","seq_no":"13","part_no":"393","part_no_section":"55(e)","insp_viol_unit":"2","insp_unit_id":"193137136","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:29.000000Z","updated_at":"2025-03-17T21:23:29.000000Z","normalized_code":"39355E"},{"id":3486525,"change_date":"2023-01-30 21:44:00","inspection_id":"77727778","insp_violation_id":"250854696","seq_no":"14","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"2","insp_unit_id":"193137136","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:23:29.000000Z","updated_at":"2025-03-17T21:23:29.000000Z","normalized_code":"39375A3"},{"id":3486526,"change_date":"2023-01-30 21:44:00","inspection_id":"77727778","insp_violation_id":"250854697","seq_no":"15","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"193137135","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:23:29.000000Z","updated_at":"2025-03-17T21:23:29.000000Z","normalized_code":"3963A1"},{"id":3486527,"change_date":"2023-01-30 21:44:00","inspection_id":"77727778","insp_violation_id":"250854698","seq_no":"6","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"193137135","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:29.000000Z","updated_at":"2025-03-17T21:23:29.000000Z","normalized_code":"39345B2"},{"id":3486528,"change_date":"2023-01-30 21:44:00","inspection_id":"77727778","insp_violation_id":"250854699","seq_no":"7","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"193137135","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:29.000000Z","updated_at":"2025-03-17T21:23:29.000000Z","normalized_code":"3965B"},{"id":3486529,"change_date":"2023-01-30 21:44:00","inspection_id":"77727778","insp_violation_id":"250854700","seq_no":"8","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"193137135","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:29.000000Z","updated_at":"2025-03-17T21:23:29.000000Z","normalized_code":"39347E"},{"id":3486530,"change_date":"2023-01-30 21:44:00","inspection_id":"77727778","insp_violation_id":"250854701","seq_no":"9","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"193137135","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:29.000000Z","updated_at":"2025-03-17T21:23:29.000000Z","normalized_code":"39347E"}],"inspection_per_units":[{"id":3635575,"change_date":"2023-01-30 21:44:00","inspection_id":"77727778","insp_unit_id":"193137135","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"R15","insp_unit_license":"1M20853","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDDU9X04J062922","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:04.000000Z","updated_at":"2025-03-17T22:32:04.000000Z"},{"id":3635576,"change_date":"2023-01-30 21:44:00","inspection_id":"77727778","insp_unit_id":"193137136","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CLEM","insp_unit_company":"TR02","insp_unit_license":"124B344","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5C2BB32B04M004245","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:04.000000Z","updated_at":"2025-03-17T22:32:04.000000Z"}]},{"id":830335,"change_date":"2022-07-22 21:40:00","inspection_id":"76079067","dot_number":"1539265","report_state":"TX","report_number":"6CJE9DJV71","insp_date":"2022-07-11 00:00:00","insp_start_time":"1401","insp_end_time":"1429","registration_date":"2022-07-22 00:00:00","region":"CT","ci_status_code":"C","location":null,"location_desc":"6500  GREENS RD","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2022-07-15 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","viol_total":"5","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8714541","transaction_code":"C","transaction_date":"2022-07-15 00:00:00","upload_date":"2022-07-22 00:00:00","upload_first_byte":"0","upload_dot_number":"01539265","upload_search_indicator":"M","census_search_date":"2022-07-15 21:40:00","snet_input_date":"2022-07-11 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-07-15 21:40:00","insp_carrier_name":"BIG R TRUCKING LLC","insp_carrier_street":"7416 JOHN RALSTON RD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77044","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0264980","created_at":"2025-03-17T18:42:18.000000Z","updated_at":"2025-03-17T18:42:18.000000Z","inspection_violations":[{"id":1308838,"change_date":"2022-07-22 21:40:00","inspection_id":"76079067","insp_violation_id":"247264700","seq_no":"1","part_no":"393","part_no_section":"55(c)(1)","insp_viol_unit":"1","insp_unit_id":"189924467","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:11.000000Z","updated_at":"2025-03-17T21:13:11.000000Z","normalized_code":"39355C1"},{"id":1308839,"change_date":"2022-07-22 21:40:00","inspection_id":"76079067","insp_violation_id":"247264701","seq_no":"2","part_no":"393","part_no_section":"55(e)","insp_viol_unit":"2","insp_unit_id":"189924468","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:11.000000Z","updated_at":"2025-03-17T21:13:11.000000Z","normalized_code":"39355E"},{"id":1308840,"change_date":"2022-07-22 21:40:00","inspection_id":"76079067","insp_violation_id":"247264702","seq_no":"3","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"189924467","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:11.000000Z","updated_at":"2025-03-17T21:13:11.000000Z","normalized_code":"39378"},{"id":1308841,"change_date":"2022-07-22 21:40:00","inspection_id":"76079067","insp_violation_id":"247264703","seq_no":"4","part_no":"393","part_no_section":"70(b)","insp_viol_unit":"1","insp_unit_id":"189924467","insp_violation_category_id":"17","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:13:11.000000Z","updated_at":"2025-03-17T21:13:11.000000Z","normalized_code":"39370B"},{"id":1308842,"change_date":"2022-07-22 21:40:00","inspection_id":"76079067","insp_violation_id":"247264704","seq_no":"5","part_no":"393","part_no_section":"70(b)","insp_viol_unit":"1","insp_unit_id":"189924467","insp_violation_category_id":"17","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:11.000000Z","updated_at":"2025-03-17T21:13:11.000000Z","normalized_code":"39370B"}],"inspection_per_units":[{"id":1335819,"change_date":"2022-07-22 21:40:00","inspection_id":"76079067","insp_unit_id":"189924467","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"1M74343","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5MC51542X7P008376","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:16:24.000000Z","updated_at":"2025-03-17T22:16:24.000000Z"},{"id":1335820,"change_date":"2022-07-22 21:40:00","inspection_id":"76079067","insp_unit_id":"189924468","insp_unit_type_id":"10","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":null,"insp_unit_license":"176C921","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5C2BB37B69M007179","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:16:24.000000Z","updated_at":"2025-03-17T22:16:24.000000Z"}]},{"id":30630,"change_date":"2022-03-23 21:32:00","inspection_id":"75123995","dot_number":"1539265","report_state":"TX","report_number":"69B89DCO54","insp_date":"2022-03-17 00:00:00","insp_start_time":"0800","insp_end_time":"0828","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0010 IN HARRIS CO. (742-797","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2022-03-23 21:32:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"8600080","transaction_code":"A","transaction_date":"2022-03-23 00:00:00","upload_date":"2022-03-23 00:00:00","upload_first_byte":"0","upload_dot_number":"01539265","upload_search_indicator":"M","census_search_date":"2022-03-23 21:32:00","snet_input_date":"2022-03-17 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-03-23 21:32:00","insp_carrier_name":"BIG R TRUCKING LLC","insp_carrier_street":"7416 JOHN RALSTON RD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77044","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0264980","created_at":"2025-03-17T18:28:06.000000Z","updated_at":"2025-03-17T18:28:06.000000Z","inspection_violations":[{"id":44186,"change_date":"2022-03-23 21:32:00","inspection_id":"75123995","insp_violation_id":"244745244","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"187789904","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:20.000000Z","updated_at":"2025-03-17T21:07:20.000000Z","normalized_code":"39311"}],"inspection_per_units":[{"id":49413,"change_date":"2022-03-23 21:32:00","inspection_id":"75123995","insp_unit_id":"187789904","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"1M20852","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDDU9X82J898006","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:33.000000Z","updated_at":"2025-03-17T22:08:33.000000Z"},{"id":49414,"change_date":"2022-03-23 21:32:00","inspection_id":"75123995","insp_unit_id":"187789905","insp_unit_type_id":"10","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":null,"insp_unit_license":"W35449","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5MC5154216P006000","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:08:33.000000Z","updated_at":"2025-03-17T22:08:33.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/1539265\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/1539265\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/1539265\/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\/1539265\/inspections","per_page":100,"prev_page_url":null,"to":24,"total":24}