{"current_page":1,"data":[{"id":11345905,"change_date":"2026-03-11 21:39:00","inspection_id":"87263809","dot_number":"2537675","report_state":"TX","report_number":"V262239136","insp_date":"2026-03-02 00:00:00","insp_start_time":"0939","insp_end_time":"1006","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"14522  FM521","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"MT","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-03-11 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"6","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9880297","transaction_code":"A","transaction_date":"2026-03-11 00:00:00","upload_date":"2026-03-11 00:00:00","upload_first_byte":"0","upload_dot_number":"02537675","upload_search_indicator":"M","census_search_date":"2026-03-11 21:39:00","snet_input_date":"2026-03-02 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-03-11 21:39:00","insp_carrier_name":"BGW TRUCKING","insp_carrier_street":"5212 COUNTY ROAD 1090","insp_carrier_city":"WIERGATE","insp_carrier_state":"TX","insp_carrier_zip_code":"75977","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0890687","created_at":"2026-03-14T09:38:20.000000Z","updated_at":"2026-03-22T09:32:56.000000Z","inspection_violations":[{"id":19109915,"change_date":"2026-03-11 21:39:00","inspection_id":"87263809","insp_violation_id":"272342596","seq_no":"1","part_no":"393","part_no_section":"104C","insp_viol_unit":"1","insp_unit_id":"212087475","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-14T09:55:31.000000Z","updated_at":"2026-03-22T09:54:41.000000Z","normalized_code":"393104C"},{"id":19109916,"change_date":"2026-03-11 21:39:00","inspection_id":"87263809","insp_violation_id":"272342597","seq_no":"2","part_no":"393","part_no_section":"104C","insp_viol_unit":"1","insp_unit_id":"212087475","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-14T09:55:31.000000Z","updated_at":"2026-03-22T09:54:41.000000Z","normalized_code":"393104C"},{"id":19109917,"change_date":"2026-03-11 21:39:00","inspection_id":"87263809","insp_violation_id":"272342598","seq_no":"3","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"212087475","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-14T09:55:31.000000Z","updated_at":"2026-03-22T09:54:41.000000Z","normalized_code":"39347E"},{"id":19109918,"change_date":"2026-03-11 21:39:00","inspection_id":"87263809","insp_violation_id":"272342599","seq_no":"4","part_no":"393","part_no_section":"53B","insp_viol_unit":"1","insp_unit_id":"212087475","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-14T09:55:31.000000Z","updated_at":"2026-03-22T09:54:41.000000Z","normalized_code":"39353B"},{"id":19109919,"change_date":"2026-03-11 21:39:00","inspection_id":"87263809","insp_violation_id":"272342600","seq_no":"5","part_no":"393","part_no_section":"79","insp_viol_unit":"1","insp_unit_id":"212087475","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-14T09:55:31.000000Z","updated_at":"2026-03-22T09:54:41.000000Z","normalized_code":"39379"},{"id":19109920,"change_date":"2026-03-11 21:39:00","inspection_id":"87263809","insp_violation_id":"272342601","seq_no":"6","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"212087475","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-14T09:55:31.000000Z","updated_at":"2026-03-22T09:54:41.000000Z","normalized_code":"3939"}],"inspection_per_units":[{"id":19416881,"change_date":"2026-03-11 21:39:00","inspection_id":"87263809","insp_unit_id":"212087475","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"937","insp_unit_license":"WDG6883","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AA13Y9XW106589","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-14T09:14:58.000000Z","updated_at":"2026-03-22T09:11:36.000000Z"}]},{"id":11345997,"change_date":"2026-03-11 21:39:00","inspection_id":"87263903","dot_number":"2537675","report_state":"TX","report_number":"V262239134","insp_date":"2026-02-27 00:00:00","insp_start_time":"1002","insp_end_time":"1040","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"14522  FM521","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"MT","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-03-11 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"48000","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":"9880059","transaction_code":"A","transaction_date":"2026-03-11 00:00:00","upload_date":"2026-03-11 00:00:00","upload_first_byte":"0","upload_dot_number":"02537675","upload_search_indicator":"M","census_search_date":"2026-03-11 21:39:00","snet_input_date":"2026-02-27 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-03-11 21:39:00","insp_carrier_name":"BGW TRUCKING","insp_carrier_street":"5212 COUNTY ROAD 1090","insp_carrier_city":"WIERGATE","insp_carrier_state":"TX","insp_carrier_zip_code":"75977","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0890687","created_at":"2026-03-14T09:38:20.000000Z","updated_at":"2026-03-22T09:32:58.000000Z","inspection_violations":[{"id":19110161,"change_date":"2026-03-11 21:39:00","inspection_id":"87263903","insp_violation_id":"272342938","seq_no":"1","part_no":"393","part_no_section":"83G","insp_viol_unit":"1","insp_unit_id":"212087661","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-14T09:55:32.000000Z","updated_at":"2026-03-22T09:54:43.000000Z","normalized_code":"39383G"},{"id":19110162,"change_date":"2026-03-11 21:39:00","inspection_id":"87263903","insp_violation_id":"272342939","seq_no":"2","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"212087661","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-14T09:55:32.000000Z","updated_at":"2026-03-22T09:54:43.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":19417035,"change_date":"2026-03-11 21:39:00","inspection_id":"87263903","insp_unit_id":"212087661","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"1568","insp_unit_license":"DRG2255","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKWDR9X8WR763153","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-14T09:14:58.000000Z","updated_at":"2026-03-22T09:11:41.000000Z"}]},{"id":10893512,"change_date":"2026-01-30 21:39:00","inspection_id":"86924558","dot_number":"2537675","report_state":"TX","report_number":"7CJ99DIAFC","insp_date":"2026-01-27 00:00:00","insp_start_time":"0907","insp_end_time":"0935","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"9900  SOUTH FWY","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-01-30 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9834327","transaction_code":"A","transaction_date":"2026-01-30 00:00:00","upload_date":"2026-01-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02537675","upload_search_indicator":"M","census_search_date":"2026-01-30 21:39:00","snet_input_date":"2026-01-27 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-01-30 21:39:00","insp_carrier_name":"BGW TRUCKING","insp_carrier_street":"5212 COUNTY ROAD 1090","insp_carrier_city":"WIERGATE","insp_carrier_state":"TX","insp_carrier_zip_code":"75977","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0890687","created_at":"2026-02-02T10:35:37.000000Z","updated_at":"2026-02-10T10:31:51.000000Z","inspection_violations":[{"id":18241741,"change_date":"2026-01-30 21:39:00","inspection_id":"86924558","insp_violation_id":"271517703","seq_no":"1","part_no":"392","part_no_section":"16","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-02T10:47:14.000000Z","updated_at":"2026-02-10T10:41:05.000000Z","normalized_code":"39216"},{"id":18241742,"change_date":"2026-01-30 21:39:00","inspection_id":"86924558","insp_violation_id":"271517704","seq_no":"2","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"211368107","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-02T10:47:14.000000Z","updated_at":"2026-02-10T10:41:05.000000Z","normalized_code":"3939"}],"inspection_per_units":[{"id":18314763,"change_date":"2026-01-30 21:39:00","inspection_id":"86924558","insp_unit_id":"211368107","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"SNR3635","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AE06Y64N017770","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-02T10:10:08.000000Z","updated_at":"2026-02-10T10:04:58.000000Z"}]},{"id":10508528,"change_date":"2025-12-23 21:39:00","inspection_id":"86643642","dot_number":"2537675","report_state":"TX","report_number":"7BGB9DNF0L","insp_date":"2025-12-19 00:00:00","insp_start_time":"1101","insp_end_time":"1132","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"1700 W PARKWOOD AVE","county_code_state":"TX","county_code":"167","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-12-23 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"48000","viol_total":"6","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9795168","transaction_code":"A","transaction_date":"2025-12-23 00:00:00","upload_date":"2025-12-23 00:00:00","upload_first_byte":"0","upload_dot_number":"02537675","upload_search_indicator":"M","census_search_date":"2025-12-23 21:39:00","snet_input_date":"2025-12-19 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-12-23 21:39:00","insp_carrier_name":"BGW TRUCKING","insp_carrier_street":"5212 COUNTY ROAD 1090","insp_carrier_city":"WIERGATE","insp_carrier_state":"TX","insp_carrier_zip_code":"75977","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0890687","created_at":"2025-12-26T10:38:39.000000Z","updated_at":"2026-01-03T10:30:50.000000Z","inspection_violations":[{"id":17641387,"change_date":"2025-12-23 21:39:00","inspection_id":"86643642","insp_violation_id":"270876511","seq_no":"1","part_no":"393","part_no_section":"67","insp_viol_unit":"1","insp_unit_id":"210784249","insp_violation_category_id":"18","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-26T10:44:34.000000Z","updated_at":"2026-01-03T10:31:34.000000Z","normalized_code":"39367"},{"id":17641388,"change_date":"2025-12-23 21:39:00","inspection_id":"86643642","insp_violation_id":"270876512","seq_no":"3","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"210784249","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-26T10:44:34.000000Z","updated_at":"2026-01-03T10:31:34.000000Z","normalized_code":"3922RG"},{"id":17641389,"change_date":"2025-12-23 21:39:00","inspection_id":"86643642","insp_violation_id":"270876513","seq_no":"4","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"210784249","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-26T10:44:34.000000Z","updated_at":"2026-01-03T10:31:34.000000Z","normalized_code":"3939"},{"id":17641390,"change_date":"2025-12-23 21:39:00","inspection_id":"86643642","insp_violation_id":"270876514","seq_no":"5","part_no":"393","part_no_section":"209D","insp_viol_unit":"1","insp_unit_id":"210784249","insp_violation_category_id":"21","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-12-26T10:44:34.000000Z","updated_at":"2026-01-03T10:31:34.000000Z","normalized_code":"393209D"},{"id":17641391,"change_date":"2025-12-23 21:39:00","inspection_id":"86643642","insp_violation_id":"270876515","seq_no":"6","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"210784249","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-26T10:44:34.000000Z","updated_at":"2026-01-03T10:31:34.000000Z","normalized_code":"39347E"},{"id":17641392,"change_date":"2025-12-23 21:39:00","inspection_id":"86643642","insp_violation_id":"270876516","seq_no":"7","part_no":"393","part_no_section":"53B","insp_viol_unit":"1","insp_unit_id":"210784249","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-12-26T10:44:34.000000Z","updated_at":"2026-01-03T10:31:34.000000Z","normalized_code":"39353B"}],"inspection_per_units":[{"id":17598246,"change_date":"2025-12-23 21:39:00","inspection_id":"86643642","insp_unit_id":"210784249","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"SNR3635","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AE06Y64N017770","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-26T10:09:33.000000Z","updated_at":"2026-01-03T10:00:59.000000Z"}]},{"id":10541005,"change_date":"2025-12-30 21:37:00","inspection_id":"86677442","dot_number":"2537675","report_state":"TX","report_number":"7BD89DHZ52","insp_date":"2025-12-16 00:00:00","insp_start_time":"0835","insp_end_time":"0950","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"2400  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":"SPRING SAND AND CLAY","shipping_paper_number":"70210824","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-12-30 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"13","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"13","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9800865","transaction_code":"A","transaction_date":"2025-12-30 00:00:00","upload_date":"2025-12-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02537675","upload_search_indicator":"M","census_search_date":"2025-12-30 21:37:00","snet_input_date":"2025-12-16 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-12-30 21:37:00","insp_carrier_name":"BGW TRUCKING","insp_carrier_street":"5212 COUNTY ROAD 1090","insp_carrier_city":"WIERGATE","insp_carrier_state":"TX","insp_carrier_zip_code":"75977","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0890687","created_at":"2026-01-02T10:36:38.000000Z","updated_at":"2026-01-10T10:30:29.000000Z","inspection_violations":[{"id":17702777,"change_date":"2025-12-30 21:37:00","inspection_id":"86677442","insp_violation_id":"270953942","seq_no":"1","part_no":"393","part_no_section":"95A","insp_viol_unit":"1","insp_unit_id":"210854403","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-02T10:40:34.000000Z","updated_at":"2026-01-10T10:31:02.000000Z","normalized_code":"39395A"},{"id":17702778,"change_date":"2025-12-30 21:37:00","inspection_id":"86677442","insp_violation_id":"270953943","seq_no":"2","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"210854403","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-02T10:40:34.000000Z","updated_at":"2026-01-10T10:31:02.000000Z","normalized_code":"3939"},{"id":17702779,"change_date":"2025-12-30 21:37:00","inspection_id":"86677442","insp_violation_id":"270953944","seq_no":"3","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"210854403","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-02T10:40:34.000000Z","updated_at":"2026-01-10T10:31:02.000000Z","normalized_code":"39347E"},{"id":17702780,"change_date":"2025-12-30 21:37:00","inspection_id":"86677442","insp_violation_id":"270953945","seq_no":"4","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"210854403","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-02T10:40:34.000000Z","updated_at":"2026-01-10T10:31:02.000000Z","normalized_code":"39347E"},{"id":17702781,"change_date":"2025-12-30 21:37:00","inspection_id":"86677442","insp_violation_id":"270953946","seq_no":"5","part_no":"393","part_no_section":"47C","insp_viol_unit":"1","insp_unit_id":"210854403","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-02T10:40:34.000000Z","updated_at":"2026-01-10T10:31:02.000000Z","normalized_code":"39347C"},{"id":17702782,"change_date":"2025-12-30 21:37:00","inspection_id":"86677442","insp_violation_id":"270953947","seq_no":"6","part_no":"393","part_no_section":"53B","insp_viol_unit":"1","insp_unit_id":"210854403","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-02T10:40:34.000000Z","updated_at":"2026-01-10T10:31:02.000000Z","normalized_code":"39353B"},{"id":17702783,"change_date":"2025-12-30 21:37:00","inspection_id":"86677442","insp_violation_id":"270953948","seq_no":"7","part_no":"396","part_no_section":"3A1B","insp_viol_unit":"1","insp_unit_id":"210854403","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-02T10:40:34.000000Z","updated_at":"2026-01-10T10:31:02.000000Z","normalized_code":"3963A1B"},{"id":17702784,"change_date":"2025-12-30 21:37:00","inspection_id":"86677442","insp_violation_id":"270953949","seq_no":"8","part_no":"393","part_no_section":"47A","insp_viol_unit":"1","insp_unit_id":"210854403","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-02T10:40:34.000000Z","updated_at":"2026-01-10T10:31:02.000000Z","normalized_code":"39347A"},{"id":17702785,"change_date":"2025-12-30 21:37:00","inspection_id":"86677442","insp_violation_id":"270953950","seq_no":"9","part_no":"393","part_no_section":"207A","insp_viol_unit":"1","insp_unit_id":"210854403","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-01-02T10:40:34.000000Z","updated_at":"2026-01-10T10:31:02.000000Z","normalized_code":"393207A"},{"id":17702786,"change_date":"2025-12-30 21:37:00","inspection_id":"86677442","insp_violation_id":"270953951","seq_no":"10","part_no":"396","part_no_section":"3A1BOS","insp_viol_unit":"1","insp_unit_id":"210854403","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-01-02T10:40:34.000000Z","updated_at":"2026-01-10T10:31:02.000000Z","normalized_code":"3963A1BOS"},{"id":17702787,"change_date":"2025-12-30 21:37:00","inspection_id":"86677442","insp_violation_id":"270953952","seq_no":"12","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"210854403","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-02T10:40:34.000000Z","updated_at":"2026-01-10T10:31:02.000000Z","normalized_code":"3922RG"},{"id":17702788,"change_date":"2025-12-30 21:37:00","inspection_id":"86677442","insp_violation_id":"270953953","seq_no":"13","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"210854403","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-02T10:40:34.000000Z","updated_at":"2026-01-10T10:31:02.000000Z","normalized_code":"3922RG"},{"id":17702789,"change_date":"2025-12-30 21:37:00","inspection_id":"86677442","insp_violation_id":"270953954","seq_no":"14","part_no":"393","part_no_section":"100(a)","insp_viol_unit":"1","insp_unit_id":"210854403","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-01-02T10:40:34.000000Z","updated_at":"2026-01-10T10:31:02.000000Z","normalized_code":"393100A"}],"inspection_per_units":[{"id":17657251,"change_date":"2025-12-30 21:37:00","inspection_id":"86677442","insp_unit_id":"210854403","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"SNR3635","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AE06Y64N017770","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-02T10:06:24.000000Z","updated_at":"2026-01-10T10:00:34.000000Z"}]},{"id":9485535,"change_date":"2025-08-22 21:39:00","inspection_id":"85569430","dot_number":"2537675","report_state":"TX","report_number":"783C9DBRA4","insp_date":"2025-08-20 00:00:00","insp_start_time":"1149","insp_end_time":"1226","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"2000  N MAIN ST","county_code_state":"TX","county_code":"039","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"SPRINT SAND AND CLAY","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-08-22 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"48000","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":"9673866","transaction_code":"A","transaction_date":"2025-08-22 00:00:00","upload_date":"2025-08-22 00:00:00","upload_first_byte":"0","upload_dot_number":"02537675","upload_search_indicator":"M","census_search_date":"2025-08-22 21:39:00","snet_input_date":"2025-08-20 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-08-22 21:39:00","insp_carrier_name":"BGW TRUCKING","insp_carrier_street":"5212 COUNTY ROAD 1090","insp_carrier_city":"WIERGATE","insp_carrier_state":"TX","insp_carrier_zip_code":"75977","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0890687","created_at":"2025-08-25T10:43:27.000000Z","updated_at":"2025-08-26T10:45:58.000000Z","inspection_violations":[{"id":15460708,"change_date":"2025-08-22 21:39:00","inspection_id":"85569430","insp_violation_id":"268199188","seq_no":"1","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"208541085","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-25T10:45:46.000000Z","updated_at":"2025-08-26T10:47:36.000000Z","normalized_code":"3939"},{"id":15460709,"change_date":"2025-08-22 21:39:00","inspection_id":"85569430","insp_violation_id":"268199189","seq_no":"2","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"208541085","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-25T10:45:46.000000Z","updated_at":"2025-08-26T10:47:36.000000Z","normalized_code":"3939"}],"inspection_per_units":[{"id":15647027,"change_date":"2025-08-22 21:39:00","inspection_id":"85569430","insp_unit_id":"208541085","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"1568","insp_unit_license":"DRG2255","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKWDR9X8WR763153","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-25T09:46:45.000000Z","updated_at":"2025-08-26T09:46:14.000000Z"}]},{"id":9178901,"change_date":"2025-07-17 21:42:00","inspection_id":"85246923","dot_number":"2537675","report_state":"TX","report_number":"77389DIA4U","insp_date":"2025-07-15 00:00:00","insp_start_time":"0755","insp_end_time":"0830","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"8000  SOUTH FWY","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"LOCAL 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-07-17 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"7","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9641074","transaction_code":"A","transaction_date":"2025-07-17 00:00:00","upload_date":"2025-07-17 00:00:00","upload_first_byte":"0","upload_dot_number":"02537675","upload_search_indicator":"M","census_search_date":"2025-07-17 21:42:00","snet_input_date":"2025-07-15 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-07-17 21:42:00","insp_carrier_name":"BGW TRUCKING","insp_carrier_street":"5212 COUNTY ROAD 1090","insp_carrier_city":"WIERGATE","insp_carrier_state":"TX","insp_carrier_zip_code":"75977","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0890687","created_at":"2025-07-21T10:43:20.000000Z","updated_at":"2025-07-21T10:43:20.000000Z","inspection_violations":[{"id":14824250,"change_date":"2025-07-17 21:42:00","inspection_id":"85246923","insp_violation_id":"267479734","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"207934008","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-21T10:45:49.000000Z","updated_at":"2025-07-21T10:45:49.000000Z","normalized_code":"39378"},{"id":14824251,"change_date":"2025-07-17 21:42:00","inspection_id":"85246923","insp_violation_id":"267479735","seq_no":"2","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"207934008","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-21T10:45:49.000000Z","updated_at":"2025-07-21T10:45:49.000000Z","normalized_code":"3939"},{"id":14824252,"change_date":"2025-07-17 21:42:00","inspection_id":"85246923","insp_violation_id":"267479736","seq_no":"3","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"207934008","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-21T10:45:49.000000Z","updated_at":"2025-07-21T10:45:49.000000Z","normalized_code":"39347E"},{"id":14824253,"change_date":"2025-07-17 21:42:00","inspection_id":"85246923","insp_violation_id":"267479737","seq_no":"4","part_no":"393","part_no_section":"53B","insp_viol_unit":"1","insp_unit_id":"207934008","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-21T10:45:49.000000Z","updated_at":"2025-07-21T10:45:49.000000Z","normalized_code":"39353B"},{"id":14824254,"change_date":"2025-07-17 21:42:00","inspection_id":"85246923","insp_violation_id":"267479738","seq_no":"5","part_no":"393","part_no_section":"48A","insp_viol_unit":"1","insp_unit_id":"207934008","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-21T10:45:49.000000Z","updated_at":"2025-07-21T10:45:49.000000Z","normalized_code":"39348A"},{"id":14824255,"change_date":"2025-07-17 21:42:00","inspection_id":"85246923","insp_violation_id":"267479739","seq_no":"6","part_no":"396","part_no_section":"3A1B","insp_viol_unit":"1","insp_unit_id":"207934008","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-21T10:45:49.000000Z","updated_at":"2025-07-21T10:45:49.000000Z","normalized_code":"3963A1B"},{"id":14824256,"change_date":"2025-07-17 21:42:00","inspection_id":"85246923","insp_violation_id":"267479740","seq_no":"7","part_no":"396","part_no_section":"3A1BOS","insp_viol_unit":"1","insp_unit_id":"207934008","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-07-21T10:45:49.000000Z","updated_at":"2025-07-21T10:45:49.000000Z","normalized_code":"3963A1BOS"}],"inspection_per_units":[{"id":15083717,"change_date":"2025-07-17 21:42:00","inspection_id":"85246923","insp_unit_id":"207934008","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"GFF9108","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AG11Y43M006869","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-20T09:46:33.000000Z","updated_at":"2025-07-21T09:46:14.000000Z"}]},{"id":9217345,"change_date":"2025-07-22 21:42:00","inspection_id":"85287311","dot_number":"2537675","report_state":"TX","report_number":"773F9DCQ32","insp_date":"2025-07-15 00:00:00","insp_start_time":"1530","insp_end_time":"1550","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"2000  ROY","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-07-22 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"50000","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":"9644714","transaction_code":"A","transaction_date":"2025-07-22 00:00:00","upload_date":"2025-07-22 00:00:00","upload_first_byte":"0","upload_dot_number":"02537675","upload_search_indicator":"M","census_search_date":"2025-07-22 21:42:00","snet_input_date":"2025-07-15 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-07-22 21:42:00","insp_carrier_name":"BGW TRUCKING","insp_carrier_street":"5212 COUNTY ROAD 1090","insp_carrier_city":"WIERGATE","insp_carrier_state":"TX","insp_carrier_zip_code":"75977","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0890687","created_at":"2025-07-25T10:46:01.000000Z","updated_at":"2025-07-27T10:41:04.000000Z","inspection_violations":[{"id":14908468,"change_date":"2025-07-22 21:42:00","inspection_id":"85287311","insp_violation_id":"267575049","seq_no":"1","part_no":"393","part_no_section":"75C","insp_viol_unit":"1","insp_unit_id":"208014944","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-25T10:47:41.000000Z","updated_at":"2025-07-26T10:42:53.000000Z","normalized_code":"39375C"}],"inspection_per_units":[{"id":15158788,"change_date":"2025-07-22 21:42:00","inspection_id":"85287311","insp_unit_id":"208014944","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MCKT","insp_unit_company":"2075","insp_unit_license":"WDG6884","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AK06Y06N013371","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-25T09:46:43.000000Z","updated_at":"2025-07-26T09:46:09.000000Z"}]},{"id":9102956,"change_date":"2025-07-09 21:43:00","inspection_id":"85154628","dot_number":"2537675","report_state":"TX","report_number":"76R99DHPGG","insp_date":"2025-07-03 00:00:00","insp_start_time":"0901","insp_end_time":"0912","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0045 IN GALVESTON CO. (0-23","county_code_state":"TX","county_code":"167","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-07-09 08:53:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9629913","transaction_code":"C","transaction_date":"2025-07-09 00:00:00","upload_date":"2025-07-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02537675","upload_search_indicator":"M","census_search_date":"2025-07-09 08:53:00","snet_input_date":"2025-07-03 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-07-09 08:53:00","insp_carrier_name":"BGW TRUCKING","insp_carrier_street":"5212 COUNTY ROAD 1090","insp_carrier_city":"WIERGATE","insp_carrier_state":"TX","insp_carrier_zip_code":"75977","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0890687","created_at":"2025-07-12T10:45:26.000000Z","updated_at":"2025-07-14T10:46:17.000000Z","inspection_violations":[],"inspection_per_units":[{"id":14942714,"change_date":"2025-07-09 21:43:00","inspection_id":"85154628","insp_unit_id":"207786329","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"WDG6884","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AK06Y06N013371","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-12T09:45:55.000000Z","updated_at":"2025-07-13T09:46:23.000000Z"}]},{"id":8864170,"change_date":"2025-06-10 21:41:00","inspection_id":"84914763","dot_number":"2537675","report_state":"TX","report_number":"75ZC9DAWSB","insp_date":"2025-06-05 00:00:00","insp_start_time":"1217","insp_end_time":"1251","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"1700 W PARKWOOD AVE","county_code_state":"TX","county_code":"167","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-06-10 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"9602346","transaction_code":"A","transaction_date":"2025-06-10 00:00:00","upload_date":"2025-06-10 00:00:00","upload_first_byte":"0","upload_dot_number":"02537675","upload_search_indicator":"M","census_search_date":"2025-06-10 21:41:00","snet_input_date":"2025-06-05 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-06-10 21:41:00","insp_carrier_name":"BGW TRUCKING","insp_carrier_street":"5212 COUNTY ROAD 1090","insp_carrier_city":"WIERGATE","insp_carrier_state":"TX","insp_carrier_zip_code":"75977","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0890687","created_at":"2025-06-14T10:00:48.000000Z","updated_at":"2025-06-14T10:00:48.000000Z","inspection_violations":[{"id":14199385,"change_date":"2025-06-10 21:41:00","inspection_id":"84914763","insp_violation_id":"266765623","seq_no":"1","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"1","insp_unit_id":"207316622","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-06-13T10:16:55.000000Z","updated_at":"2025-06-14T10:16:05.000000Z","normalized_code":"39375A3TAOL"}],"inspection_per_units":[{"id":14516432,"change_date":"2025-06-10 21:41:00","inspection_id":"84914763","insp_unit_id":"207316622","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"GFF9108","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AG11Y43M006869","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-13T09:45:45.000000Z","updated_at":"2025-06-14T09:45:52.000000Z"}]},{"id":8416494,"change_date":"2025-04-18 21:40:00","inspection_id":"84442208","dot_number":"2537675","report_state":"TX","report_number":"74LC9DIA0T","insp_date":"2025-04-16 00:00:00","insp_start_time":"1212","insp_end_time":"1243","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"100  MCCARTY","county_code_state":"TX","county_code":"211","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"LOCAL CONSTRUCTION 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":"2025-04-18 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"50000","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":"9553942","transaction_code":"A","transaction_date":"2025-04-18 00:00:00","upload_date":"2025-04-18 00:00:00","upload_first_byte":"0","upload_dot_number":"02537675","upload_search_indicator":"M","census_search_date":"2025-04-18 21:40:00","snet_input_date":"2025-04-16 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-04-18 21:40:00","insp_carrier_name":"BGW TRUCKING","insp_carrier_street":"5212 COUNTY ROAD 1090","insp_carrier_city":"WIERGATE","insp_carrier_state":"TX","insp_carrier_zip_code":"75977","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0890687","created_at":"2025-04-21T10:26:15.000000Z","updated_at":"2025-04-23T10:03:28.000000Z","inspection_violations":[{"id":13280004,"change_date":"2025-04-18 21:40:00","inspection_id":"84442208","insp_violation_id":"265709544","seq_no":"2","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"206389970","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-20T11:15:15.000000Z","updated_at":"2025-04-22T10:32:01.000000Z","normalized_code":"3922RG"},{"id":13280005,"change_date":"2025-04-18 21:40:00","inspection_id":"84442208","insp_violation_id":"265709545","seq_no":"3","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"206389970","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-20T11:15:15.000000Z","updated_at":"2025-04-22T10:32:01.000000Z","normalized_code":"3939"}],"inspection_per_units":[{"id":13665322,"change_date":"2025-04-18 21:40:00","inspection_id":"84442208","insp_unit_id":"206389970","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"2239","insp_unit_license":"SNR3635","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AE06Y64N017770","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-21T10:16:54.000000Z","updated_at":"2025-04-22T10:03:36.000000Z"}]},{"id":8534878,"change_date":"2025-05-02 21:41:00","inspection_id":"84567059","dot_number":"2537675","report_state":"TX","report_number":"74FC9DBV20","insp_date":"2025-04-10 00:00:00","insp_start_time":"1202","insp_end_time":"1215","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":"2025-05-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9566856","transaction_code":"A","transaction_date":"2025-05-02 00:00:00","upload_date":"2025-05-02 00:00:00","upload_first_byte":"0","upload_dot_number":"02537675","upload_search_indicator":"M","census_search_date":"2025-05-02 21:41:00","snet_input_date":"2025-04-10 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-05-02 21:41:00","insp_carrier_name":"BGW TRUCKING","insp_carrier_street":"5212 COUNTY ROAD 1090","insp_carrier_city":"WIERGATE","insp_carrier_state":"TX","insp_carrier_zip_code":"75977","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0890687","created_at":"2025-05-05T10:16:09.000000Z","updated_at":"2025-05-06T10:06:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13877881,"change_date":"2025-05-02 21:41:00","inspection_id":"84567059","insp_unit_id":"206618644","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"937","insp_unit_license":"WDG6883","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AA13Y9XW106589","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-05T10:06:06.000000Z","updated_at":"2025-05-07T10:04:22.000000Z"}]},{"id":7897154,"change_date":"2025-02-18 21:40:00","inspection_id":"83895927","dot_number":"2537675","report_state":"TX","report_number":"V251776604","insp_date":"2025-02-17 00:00:00","insp_start_time":"0952","insp_end_time":"1016","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH 6","county_code_state":"TX","county_code":"039","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"BGW TRUCKING","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-02-18 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"48000","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":"9501845","transaction_code":"A","transaction_date":"2025-02-18 00:00:00","upload_date":"2025-02-18 00:00:00","upload_first_byte":"0","upload_dot_number":"02537675","upload_search_indicator":"M","census_search_date":"2025-02-18 21:40:00","snet_input_date":"2025-02-17 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-02-18 21:40:00","insp_carrier_name":"BGW TRUCKING","insp_carrier_street":"12986 GREENWAY CHASE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77072","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0890687","created_at":"2025-03-17T21:02:02.000000Z","updated_at":"2025-03-17T21:02:02.000000Z","inspection_violations":[{"id":12340316,"change_date":"2025-02-18 21:40:00","inspection_id":"83895927","insp_violation_id":"264571004","seq_no":"1","part_no":"393","part_no_section":"9H","insp_viol_unit":"1","insp_unit_id":"205376967","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:17.000000Z","updated_at":"2025-03-17T22:06:17.000000Z","normalized_code":"3939H"}],"inspection_per_units":[{"id":12747305,"change_date":"2025-02-18 21:40:00","inspection_id":"83895927","insp_unit_id":"205376967","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"1568","insp_unit_license":"DRG2255","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKWDR9X8WR763153","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:55:50.000000Z","updated_at":"2025-03-17T23:55:50.000000Z"}]},{"id":7607575,"change_date":"2025-01-13 21:46:00","inspection_id":"83591834","dot_number":"2537675","report_state":"TX","report_number":"71TB9DAWLW","insp_date":"2025-01-06 00:00:00","insp_start_time":"1137","insp_end_time":"1213","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"2300 W PARKWOOD AVE","county_code_state":"TX","county_code":"167","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-13 21:46:00","post_acc_ind":"N","gross_comb_veh_wt":"48000","viol_total":"4","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9471734","transaction_code":"A","transaction_date":"2025-01-13 00:00:00","upload_date":"2025-01-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02537675","upload_search_indicator":"M","census_search_date":"2025-01-13 21:46:00","snet_input_date":"2025-01-06 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-01-13 21:46:00","insp_carrier_name":"BGW TRUCKING","insp_carrier_street":"12986 GREENWAY CHASE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77072","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0890687","created_at":"2025-03-17T20:56:07.000000Z","updated_at":"2025-03-17T20:56:07.000000Z","inspection_violations":[{"id":11892606,"change_date":"2025-01-13 21:46:00","inspection_id":"83591834","insp_violation_id":"263913376","seq_no":"1","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"204784721","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:56.000000Z","updated_at":"2025-03-17T22:03:56.000000Z","normalized_code":"39347E"},{"id":11892607,"change_date":"2025-01-13 21:46:00","inspection_id":"83591834","insp_violation_id":"263913377","seq_no":"2","part_no":"393","part_no_section":"53B","insp_viol_unit":"1","insp_unit_id":"204784721","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:56.000000Z","updated_at":"2025-03-17T22:03:56.000000Z","normalized_code":"39353B"},{"id":11892608,"change_date":"2025-01-13 21:46:00","inspection_id":"83591834","insp_violation_id":"263913378","seq_no":"3","part_no":"393","part_no_section":"9T","insp_viol_unit":"1","insp_unit_id":"204784721","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:56.000000Z","updated_at":"2025-03-17T22:03:56.000000Z","normalized_code":"3939T"},{"id":11892609,"change_date":"2025-01-13 21:46:00","inspection_id":"83591834","insp_violation_id":"263913379","seq_no":"4","part_no":"393","part_no_section":"203C","insp_viol_unit":"1","insp_unit_id":"204784721","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:56.000000Z","updated_at":"2025-03-17T22:03:56.000000Z","normalized_code":"393203C"}],"inspection_per_units":[{"id":12275361,"change_date":"2025-01-13 21:46:00","inspection_id":"83591834","insp_unit_id":"204784721","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"DRG2255","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKWDR9X8WR763153","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:50:30.000000Z","updated_at":"2025-03-17T23:50:30.000000Z"}]},{"id":7096045,"change_date":"2024-10-31 21:43:00","inspection_id":"83052710","dot_number":"2537675","report_state":"TX","report_number":"V241590435","insp_date":"2024-10-28 00:00:00","insp_start_time":"1212","insp_end_time":"1236","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"13826  FM521","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"SPRING AND SAND","shipping_paper_number":"70162949","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-10-31 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"48000","viol_total":"4","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9416261","transaction_code":"A","transaction_date":"2024-10-31 00:00:00","upload_date":"2024-10-31 00:00:00","upload_first_byte":"0","upload_dot_number":"02537675","upload_search_indicator":"M","census_search_date":"2024-10-31 21:43:00","snet_input_date":"2024-10-28 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-10-31 21:43:00","insp_carrier_name":"BGW TRUCKING","insp_carrier_street":"12986 GREENWAY CHASE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77072","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0890687","created_at":"2025-03-17T20:43:54.000000Z","updated_at":"2025-03-17T20:43:54.000000Z","inspection_violations":[{"id":11080133,"change_date":"2024-10-31 21:43:00","inspection_id":"83052710","insp_violation_id":"262671149","seq_no":"1","part_no":"393","part_no_section":"83G","insp_viol_unit":"1","insp_unit_id":"203686541","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:48.000000Z","updated_at":"2025-03-17T21:59:48.000000Z","normalized_code":"39383G"},{"id":11080134,"change_date":"2024-10-31 21:43:00","inspection_id":"83052710","insp_violation_id":"262671150","seq_no":"2","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"203686541","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:48.000000Z","updated_at":"2025-03-17T21:59:48.000000Z","normalized_code":"3939"},{"id":11080135,"change_date":"2024-10-31 21:43:00","inspection_id":"83052710","insp_violation_id":"262671151","seq_no":"3","part_no":"393","part_no_section":"9TS","insp_viol_unit":"1","insp_unit_id":"203686541","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:48.000000Z","updated_at":"2025-03-17T21:59:48.000000Z","normalized_code":"3939TS"},{"id":11080136,"change_date":"2024-10-31 21:43:00","inspection_id":"83052710","insp_violation_id":"262671152","seq_no":"4","part_no":"393","part_no_section":"95A","insp_viol_unit":"1","insp_unit_id":"203686541","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:48.000000Z","updated_at":"2025-03-17T21:59:48.000000Z","normalized_code":"39395A"}],"inspection_per_units":[{"id":11444640,"change_date":"2024-10-31 21:43:00","inspection_id":"83052710","insp_unit_id":"203686541","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"1568","insp_unit_license":"DRG2255","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKWDR9X8WR763153","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:41:30.000000Z","updated_at":"2025-03-17T23:41:30.000000Z"}]},{"id":6925351,"change_date":"2024-10-09 21:42:00","inspection_id":"82871427","dot_number":"2537675","report_state":"TX","report_number":"V241625316","insp_date":"2024-10-08 00:00:00","insp_start_time":"1128","insp_end_time":"1202","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SCANLAN RD AT SIENNA","county_code_state":"TX","county_code":"157","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"SPRINT SAND AND CLAY","shipping_paper_number":"44105713","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-10-09 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"2","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9398481","transaction_code":"A","transaction_date":"2024-10-09 00:00:00","upload_date":"2024-10-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02537675","upload_search_indicator":"M","census_search_date":"2024-10-09 21:42:00","snet_input_date":"2024-10-08 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-10-09 21:42:00","insp_carrier_name":"BGW TRUCKING","insp_carrier_street":"12986 GREENWAY CHASE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77072","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0890687","created_at":"2025-03-17T20:40:37.000000Z","updated_at":"2025-03-17T20:40:37.000000Z","inspection_violations":[{"id":10794769,"change_date":"2024-10-09 21:42:00","inspection_id":"82871427","insp_violation_id":"262275293","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"203343241","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:58:16.000000Z","updated_at":"2025-03-17T21:58:16.000000Z","normalized_code":"3963A1"},{"id":10794770,"change_date":"2024-10-09 21:42:00","inspection_id":"82871427","insp_violation_id":"262275294","seq_no":"2","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"203343241","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:58:16.000000Z","updated_at":"2025-03-17T21:58:16.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":11169137,"change_date":"2024-10-09 21:42:00","inspection_id":"82871427","insp_unit_id":"203343241","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"GFF9108","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AG11Y43M006869","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:38:39.000000Z","updated_at":"2025-03-17T23:38:39.000000Z"}]},{"id":6864969,"change_date":"2024-10-01 21:42:00","inspection_id":"82807322","dot_number":"2537675","report_state":"TX","report_number":"6YZE9DCOCE","insp_date":"2024-09-26 00:00:00","insp_start_time":"1441","insp_end_time":"1457","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-10-01 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"9390343","transaction_code":"A","transaction_date":"2024-10-01 00:00:00","upload_date":"2024-10-01 00:00:00","upload_first_byte":"0","upload_dot_number":"02537675","upload_search_indicator":"M","census_search_date":"2024-10-01 21:42:00","snet_input_date":"2024-09-26 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-10-01 21:42:00","insp_carrier_name":"BGW TRUCKING","insp_carrier_street":"12986 GREENWAY CHASE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77072","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0890687","created_at":"2025-03-17T20:39:23.000000Z","updated_at":"2025-03-17T20:39:23.000000Z","inspection_violations":[{"id":10691984,"change_date":"2024-10-01 21:42:00","inspection_id":"82807322","insp_violation_id":"262131174","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"203219732","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:46.000000Z","updated_at":"2025-03-17T21:57:46.000000Z","normalized_code":"3922"},{"id":10691985,"change_date":"2024-10-01 21:42:00","inspection_id":"82807322","insp_violation_id":"262131175","seq_no":"2","part_no":"393","part_no_section":"83(g)","insp_viol_unit":"1","insp_unit_id":"203219732","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:46.000000Z","updated_at":"2025-03-17T21:57:46.000000Z","normalized_code":"39383G"},{"id":10691986,"change_date":"2024-10-01 21:42:00","inspection_id":"82807322","insp_violation_id":"262131176","seq_no":"3","part_no":"393","part_no_section":"201(d)","insp_viol_unit":"1","insp_unit_id":"203219732","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:46.000000Z","updated_at":"2025-03-17T21:57:46.000000Z","normalized_code":"393201D"}],"inspection_per_units":[{"id":11070798,"change_date":"2024-10-01 21:42:00","inspection_id":"82807322","insp_unit_id":"203219732","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"GFF9108","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AG11Y43M006869","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:37:40.000000Z","updated_at":"2025-03-17T23:37:40.000000Z"}]},{"id":6874403,"change_date":"2024-10-03 21:42:00","inspection_id":"82817252","dot_number":"2537675","report_state":"TX","report_number":"6YSG9DBVTF","insp_date":"2024-09-19 00:00:00","insp_start_time":"1550","insp_end_time":"1620","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-10-02 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"9391773","transaction_code":"C","transaction_date":"2024-10-03 00:00:00","upload_date":"2024-10-03 00:00:00","upload_first_byte":"0","upload_dot_number":"02537675","upload_search_indicator":"M","census_search_date":"2024-10-02 21:41:00","snet_input_date":"2024-09-19 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-10-02 21:41:00","insp_carrier_name":"BGW TRUCKING","insp_carrier_street":"12986 GREENWAY CHASE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77072","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0890687","created_at":"2025-03-17T20:39:27.000000Z","updated_at":"2025-03-17T20:39:27.000000Z","inspection_violations":[{"id":10707650,"change_date":"2024-10-03 21:42:00","inspection_id":"82817252","insp_violation_id":"262174557","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"203258449","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:51.000000Z","updated_at":"2025-03-17T21:57:51.000000Z","normalized_code":"39347E"},{"id":10707651,"change_date":"2024-10-03 21:42:00","inspection_id":"82817252","insp_violation_id":"262174558","seq_no":"2","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"203258449","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:51.000000Z","updated_at":"2025-03-17T21:57:51.000000Z","normalized_code":"39353B"},{"id":10707652,"change_date":"2024-10-03 21:42:00","inspection_id":"82817252","insp_violation_id":"262174559","seq_no":"3","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"203258449","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:57:51.000000Z","updated_at":"2025-03-17T21:57:51.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":11086457,"change_date":"2024-10-03 21:42:00","inspection_id":"82817252","insp_unit_id":"203258449","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"GFF9108","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AG11Y43M006869","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:37:49.000000Z","updated_at":"2025-03-17T23:37:49.000000Z"}]},{"id":6576519,"change_date":"2024-08-27 21:43:00","inspection_id":"82500113","dot_number":"2537675","report_state":"TX","report_number":"6Y0G9DCOAP","insp_date":"2024-08-22 00:00:00","insp_start_time":"1634","insp_end_time":"1650","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-08-27 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"9361482","transaction_code":"A","transaction_date":"2024-08-27 00:00:00","upload_date":"2024-08-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02537675","upload_search_indicator":"M","census_search_date":"2024-08-27 21:43:00","snet_input_date":"2024-08-22 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-08-27 21:43:00","insp_carrier_name":"BGW TRUCKING","insp_carrier_street":"12986 GREENWAY CHASE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77072","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0890687","created_at":"2025-03-17T20:33:13.000000Z","updated_at":"2025-03-17T20:33:13.000000Z","inspection_violations":[{"id":10223146,"change_date":"2024-08-27 21:43:00","inspection_id":"82500113","insp_violation_id":"261443013","seq_no":"1","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"202612197","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:31.000000Z","updated_at":"2025-03-17T21:55:31.000000Z","normalized_code":"39395A"},{"id":10223147,"change_date":"2024-08-27 21:43:00","inspection_id":"82500113","insp_violation_id":"261443014","seq_no":"2","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"202612197","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:31.000000Z","updated_at":"2025-03-17T21:55:31.000000Z","normalized_code":"39378"},{"id":10223148,"change_date":"2024-08-27 21:43:00","inspection_id":"82500113","insp_violation_id":"261443015","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202612197","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:31.000000Z","updated_at":"2025-03-17T21:55:31.000000Z","normalized_code":"3939A"},{"id":10223149,"change_date":"2024-08-27 21:43:00","inspection_id":"82500113","insp_violation_id":"261443016","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202612197","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:31.000000Z","updated_at":"2025-03-17T21:55:31.000000Z","normalized_code":"3939A"},{"id":10223150,"change_date":"2024-08-27 21:43:00","inspection_id":"82500113","insp_violation_id":"261443017","seq_no":"5","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"202612197","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:55:31.000000Z","updated_at":"2025-03-17T21:55:31.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":10602295,"change_date":"2024-08-27 21:43:00","inspection_id":"82500113","insp_unit_id":"202612197","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"SNR3635","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AE06Y64N017770","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:32:50.000000Z","updated_at":"2025-03-17T23:32:50.000000Z"}]},{"id":6563820,"change_date":"2024-08-26 21:42:00","inspection_id":"82486656","dot_number":"2537675","report_state":"TX","report_number":"6XZE9DCK2H","insp_date":"2024-08-21 00:00:00","insp_start_time":"1447","insp_end_time":"1506","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-08-26 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"6","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9359773","transaction_code":"A","transaction_date":"2024-08-26 00:00:00","upload_date":"2024-08-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02537675","upload_search_indicator":"M","census_search_date":"2024-08-26 21:42:00","snet_input_date":"2024-08-21 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-08-26 21:42:00","insp_carrier_name":"BGW TRUCKING","insp_carrier_street":"12986 GREENWAY CHASE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77072","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0890687","created_at":"2025-03-17T20:33:09.000000Z","updated_at":"2025-03-17T20:33:09.000000Z","inspection_violations":[{"id":10200236,"change_date":"2024-08-26 21:42:00","inspection_id":"82486656","insp_violation_id":"261411162","seq_no":"1","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"202586992","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:25.000000Z","updated_at":"2025-03-17T21:55:25.000000Z","normalized_code":"39395A"},{"id":10200237,"change_date":"2024-08-26 21:42:00","inspection_id":"82486656","insp_violation_id":"261411163","seq_no":"2","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"202586992","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:25.000000Z","updated_at":"2025-03-17T21:55:25.000000Z","normalized_code":"39378"},{"id":10200238,"change_date":"2024-08-26 21:42:00","inspection_id":"82486656","insp_violation_id":"261411164","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202586992","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:25.000000Z","updated_at":"2025-03-17T21:55:25.000000Z","normalized_code":"3939A"},{"id":10200239,"change_date":"2024-08-26 21:42:00","inspection_id":"82486656","insp_violation_id":"261411165","seq_no":"4","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"202586992","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:25.000000Z","updated_at":"2025-03-17T21:55:25.000000Z","normalized_code":"39311"},{"id":10200240,"change_date":"2024-08-26 21:42:00","inspection_id":"82486656","insp_violation_id":"261411166","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202586992","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:25.000000Z","updated_at":"2025-03-17T21:55:25.000000Z","normalized_code":"3939A"},{"id":10200241,"change_date":"2024-08-26 21:42:00","inspection_id":"82486656","insp_violation_id":"261411167","seq_no":"6","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"202586992","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:25.000000Z","updated_at":"2025-03-17T21:55:25.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10581989,"change_date":"2024-08-26 21:42:00","inspection_id":"82486656","insp_unit_id":"202586992","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"SNR3635","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AE06Y64N017770","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:32:37.000000Z","updated_at":"2025-03-17T23:32:37.000000Z"}]},{"id":6199493,"change_date":"2024-07-11 21:41:00","inspection_id":"82097104","dot_number":"2537675","report_state":"TX","report_number":"V241466523","insp_date":"2024-07-03 00:00:00","insp_start_time":"1312","insp_end_time":"1348","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"HANEY RD AT FIG ORCH","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"MT","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"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":"52000","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":"9324013","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":"02537675","upload_search_indicator":"M","census_search_date":"2024-07-11 21:41:00","snet_input_date":"2024-07-03 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-07-11 21:41:00","insp_carrier_name":"BGW TRUCKING","insp_carrier_street":"12986 GREENWAY CHASE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77072","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0890687","created_at":"2025-03-17T20:25:26.000000Z","updated_at":"2025-03-17T20:25:26.000000Z","inspection_violations":[{"id":9628958,"change_date":"2024-07-11 21:41:00","inspection_id":"82097104","insp_violation_id":"260598474","seq_no":"1","part_no":"393","part_no_section":"43(a)","insp_viol_unit":"1","insp_unit_id":"201845744","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:52:36.000000Z","updated_at":"2025-03-17T21:52:36.000000Z","normalized_code":"39343A"},{"id":9628959,"change_date":"2024-07-11 21:41:00","inspection_id":"82097104","insp_violation_id":"260598475","seq_no":"2","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"201845744","insp_violation_category_id":"26","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":"39378"},{"id":9628960,"change_date":"2024-07-11 21:41:00","inspection_id":"82097104","insp_violation_id":"260598476","seq_no":"3","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"201845744","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":9628961,"change_date":"2024-07-11 21:41:00","inspection_id":"82097104","insp_violation_id":"260598477","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"201845744","insp_violation_category_id":"47","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":9987357,"change_date":"2024-07-11 21:41:00","inspection_id":"82097104","insp_unit_id":"201845744","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"1725","insp_unit_license":"HMY8878","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AG11Y53M006010","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":6074603,"change_date":"2024-06-25 21:42:00","inspection_id":"81962920","dot_number":"2537675","report_state":"TX","report_number":"6WAC9DGA1S","insp_date":"2024-06-21 00:00:00","insp_start_time":"1227","insp_end_time":"1301","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"1500  S MAPLE LEAF D","county_code_state":"TX","county_code":"167","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-06-25 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"54900","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":"9308024","transaction_code":"A","transaction_date":"2024-06-25 00:00:00","upload_date":"2024-06-25 00:00:00","upload_first_byte":"0","upload_dot_number":"02537675","upload_search_indicator":"M","census_search_date":"2024-06-25 21:42:00","snet_input_date":"2024-06-21 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-06-25 21:42:00","insp_carrier_name":"BGW TRUCKING","insp_carrier_street":"12986 GREENWAY CHASE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77072","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0890687","created_at":"2025-03-17T20:23:01.000000Z","updated_at":"2025-03-17T20:23:01.000000Z","inspection_violations":[{"id":9426194,"change_date":"2024-06-25 21:42:00","inspection_id":"81962920","insp_violation_id":"260305981","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"201586779","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:37.000000Z","updated_at":"2025-03-17T21:51:37.000000Z","normalized_code":"3939A"},{"id":9426195,"change_date":"2024-06-25 21:42:00","inspection_id":"81962920","insp_violation_id":"260305982","seq_no":"2","part_no":"393","part_no_section":"55(d)(1)","insp_viol_unit":"1","insp_unit_id":"201586779","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:51:37.000000Z","updated_at":"2025-03-17T21:51:37.000000Z","normalized_code":"39355D1"}],"inspection_per_units":[{"id":9783951,"change_date":"2024-06-25 21:42:00","inspection_id":"81962920","insp_unit_id":"201586779","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"V-371","insp_unit_license":"RMG1028","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AK06Y06N013371","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:24:19.000000Z","updated_at":"2025-03-17T23:24:19.000000Z"}]},{"id":5829665,"change_date":"2024-05-23 21:41:00","inspection_id":"81697653","dot_number":"2537675","report_state":"TX","report_number":"6VE99DHP7F","insp_date":"2024-05-20 00:00:00","insp_start_time":"0934","insp_end_time":"0949","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0045 IN GALVESTON CO. (0-23","county_code_state":"TX","county_code":"167","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-05-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9281962","transaction_code":"A","transaction_date":"2024-05-23 00:00:00","upload_date":"2024-05-23 00:00:00","upload_first_byte":"0","upload_dot_number":"02537675","upload_search_indicator":"M","census_search_date":"2024-05-23 21:41:00","snet_input_date":"2024-05-20 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-05-23 21:41:00","insp_carrier_name":"BGW TRUCKING","insp_carrier_street":"12986 GREENWAY CHASE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77072","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0890687","created_at":"2025-03-17T20:18:16.000000Z","updated_at":"2025-03-17T20:18:16.000000Z","inspection_violations":[{"id":9032861,"change_date":"2024-05-23 21:41:00","inspection_id":"81697653","insp_violation_id":"259699154","seq_no":"1","part_no":"393","part_no_section":"209(e)","insp_viol_unit":"1","insp_unit_id":"201058804","insp_violation_category_id":"21","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:40.000000Z","updated_at":"2025-03-17T21:49:40.000000Z","normalized_code":"393209E"},{"id":9032862,"change_date":"2024-05-23 21:41:00","inspection_id":"81697653","insp_violation_id":"259699155","seq_no":"2","part_no":"393","part_no_section":"95(b)","insp_viol_unit":"1","insp_unit_id":"201058804","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:40.000000Z","updated_at":"2025-03-17T21:49:40.000000Z","normalized_code":"39395B"}],"inspection_per_units":[{"id":9388883,"change_date":"2024-05-23 21:41:00","inspection_id":"81697653","insp_unit_id":"201058804","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"SNR3635","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AE06Y64N017770","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:20:27.000000Z","updated_at":"2025-03-17T23:20:27.000000Z"}]},{"id":5780291,"change_date":"2024-05-20 21:42:00","inspection_id":"81643852","dot_number":"2537675","report_state":"TX","report_number":"6V589DKY57","insp_date":"2024-05-11 00:00:00","insp_start_time":"0839","insp_end_time":"0902","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0003 IN GALVESTON CO. (492-","county_code_state":"TX","county_code":"167","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"86241423","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-05-17 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"9275815","transaction_code":"C","transaction_date":"2024-05-20 00:00:00","upload_date":"2024-05-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02537675","upload_search_indicator":"M","census_search_date":"2024-05-17 21:40:00","snet_input_date":"2024-05-11 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-05-17 21:40:00","insp_carrier_name":"BGW TRUCKING","insp_carrier_street":"12986 GREENWAY CHASE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77072","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0890687","created_at":"2025-03-17T20:17:27.000000Z","updated_at":"2025-03-17T20:17:27.000000Z","inspection_violations":[{"id":8949643,"change_date":"2024-05-20 21:42:00","inspection_id":"81643852","insp_violation_id":"259612364","seq_no":"1","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"200986452","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:17.000000Z","updated_at":"2025-03-17T21:49:17.000000Z","normalized_code":"39360C"},{"id":8949644,"change_date":"2024-05-20 21:42:00","inspection_id":"81643852","insp_violation_id":"259612365","seq_no":"2","part_no":"999","part_no_section":null,"insp_viol_unit":"1","insp_unit_id":"200986452","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:17.000000Z","updated_at":"2025-03-17T21:49:17.000000Z","normalized_code":"999"},{"id":8949645,"change_date":"2024-05-20 21:42:00","inspection_id":"81643852","insp_violation_id":"259612366","seq_no":"3","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"200986452","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:17.000000Z","updated_at":"2025-03-17T21:49:17.000000Z","normalized_code":"39311"}],"inspection_per_units":[{"id":9309994,"change_date":"2024-05-20 21:42:00","inspection_id":"81643852","insp_unit_id":"200986452","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"1","insp_unit_license":"HMY8878","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AG11Y53M006010","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:19:39.000000Z","updated_at":"2025-03-17T23:19:39.000000Z"}]},{"id":5633929,"change_date":"2024-04-30 21:42:00","inspection_id":"81485063","dot_number":"2537675","report_state":"TX","report_number":"6UOF9DGAZK","insp_date":"2024-04-24 00:00:00","insp_start_time":"1558","insp_end_time":"1614","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"4200  MCFARLAND RD S","county_code_state":"TX","county_code":"167","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":"2024-04-30 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"54900","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9259720","transaction_code":"A","transaction_date":"2024-04-30 00:00:00","upload_date":"2024-04-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02537675","upload_search_indicator":"M","census_search_date":"2024-04-30 21:42:00","snet_input_date":"2024-04-24 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-04-30 21:42:00","insp_carrier_name":"BGW TRUCKING","insp_carrier_street":"12986 GREENWAY CHASE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77072","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0890687","created_at":"2025-03-17T20:14:19.000000Z","updated_at":"2025-03-17T20:14:19.000000Z","inspection_violations":[{"id":8711393,"change_date":"2024-04-30 21:42:00","inspection_id":"81485063","insp_violation_id":"259228867","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:48:09.000000Z","updated_at":"2025-03-17T21:48:09.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":9074998,"change_date":"2024-04-30 21:42:00","inspection_id":"81485063","insp_unit_id":"200653286","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"V-679","insp_unit_license":"LYG5386","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AG11Y56M048679","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:25.000000Z","updated_at":"2025-03-17T23:17:25.000000Z"}]},{"id":5588746,"change_date":"2024-04-24 21:42:00","inspection_id":"81435738","dot_number":"2537675","report_state":"TX","report_number":"6UBE9DBVO7","insp_date":"2024-04-11 00:00:00","insp_start_time":"1434","insp_end_time":"1513","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":"2024-04-24 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"54900","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":"9256075","transaction_code":"A","transaction_date":"2024-04-24 00:00:00","upload_date":"2024-04-24 00:00:00","upload_first_byte":"0","upload_dot_number":"02537675","upload_search_indicator":"M","census_search_date":"2024-04-24 21:42:00","snet_input_date":"2024-04-11 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-04-24 21:42:00","insp_carrier_name":"BGW TRUCKING","insp_carrier_street":"12986 GREENWAY CHASE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77072","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0890687","created_at":"2025-03-17T20:13:30.000000Z","updated_at":"2025-03-17T20:13:30.000000Z","inspection_violations":[{"id":8640406,"change_date":"2024-04-24 21:42:00","inspection_id":"81435738","insp_violation_id":"259120149","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"200557848","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:52.000000Z","updated_at":"2025-03-17T21:47:52.000000Z","normalized_code":"39347E"},{"id":8640407,"change_date":"2024-04-24 21:42:00","inspection_id":"81435738","insp_violation_id":"259120150","seq_no":"2","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"200557848","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:52.000000Z","updated_at":"2025-03-17T21:47:52.000000Z","normalized_code":"39353B"}],"inspection_per_units":[{"id":9002188,"change_date":"2024-04-24 21:42:00","inspection_id":"81435738","insp_unit_id":"200557848","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"LYG5386","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AG11Y56M048679","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:16:46.000000Z","updated_at":"2025-03-17T23:16:46.000000Z"}]},{"id":5492267,"change_date":"2024-04-11 21:41:00","inspection_id":"81330751","dot_number":"2537675","report_state":"TX","report_number":"6U8A9DBQ62","insp_date":"2024-04-08 00:00:00","insp_start_time":"1012","insp_end_time":"1055","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"2700  CULLEN PKWY","county_code_state":"TX","county_code":"039","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"SPRINT","shipping_paper_number":"1009114","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-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33000","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9245748","transaction_code":"A","transaction_date":"2024-04-11 00:00:00","upload_date":"2024-04-11 00:00:00","upload_first_byte":"0","upload_dot_number":"02537675","upload_search_indicator":"M","census_search_date":"2024-04-11 21:41:00","snet_input_date":"2024-04-08 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-04-11 21:41:00","insp_carrier_name":"BGW TRUCKING","insp_carrier_street":"12986 GREENWAY CHASE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77072","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0890687","created_at":"2025-03-17T20:11:33.000000Z","updated_at":"2025-03-17T20:11:33.000000Z","inspection_violations":[{"id":8483002,"change_date":"2024-04-11 21:41:00","inspection_id":"81330751","insp_violation_id":"258887199","seq_no":"1","part_no":"392","part_no_section":"82(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:07.000000Z","updated_at":"2025-03-17T21:47:07.000000Z","normalized_code":"39282A1"},{"id":8483003,"change_date":"2024-04-11 21:41:00","inspection_id":"81330751","insp_violation_id":"258887200","seq_no":"2","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"200359014","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:07.000000Z","updated_at":"2025-03-17T21:47:07.000000Z","normalized_code":"39378"}],"inspection_per_units":[{"id":8847124,"change_date":"2024-04-11 21:41:00","inspection_id":"81330751","insp_unit_id":"200359014","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"1063","insp_unit_license":"LYG5386","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AG11Y56M048679","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:15:18.000000Z","updated_at":"2025-03-17T23:15:18.000000Z"}]},{"id":5289232,"change_date":"2024-03-14 21:42:00","inspection_id":"81108891","dot_number":"2537675","report_state":"TX","report_number":"V241348769","insp_date":"2024-03-13 00:00:00","insp_start_time":"0720","insp_end_time":"0741","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"FM518 AT BROOKDALE D","county_code_state":"TX","county_code":"167","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"SPRINT SAND & CLAY","shipping_paper_number":"7483776","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-03-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9222795","transaction_code":"A","transaction_date":"2024-03-14 00:00:00","upload_date":"2024-03-14 00:00:00","upload_first_byte":"0","upload_dot_number":"02537675","upload_search_indicator":"M","census_search_date":"2024-03-14 21:42:00","snet_input_date":"2024-03-13 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-03-14 21:42:00","insp_carrier_name":"BGW TRUCKING","insp_carrier_street":"12986 GREENWAY CHASE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77072","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0890687","created_at":"2025-03-17T20:07:29.000000Z","updated_at":"2025-03-17T20:07:29.000000Z","inspection_violations":[{"id":8156514,"change_date":"2024-03-14 21:42:00","inspection_id":"81108891","insp_violation_id":"258392296","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"199921408","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:23.000000Z","updated_at":"2025-03-17T21:45:23.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":8517698,"change_date":"2024-03-14 21:42:00","inspection_id":"81108891","insp_unit_id":"199921408","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"1725","insp_unit_license":"HMY8878","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AG11Y53M006010","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:12:12.000000Z","updated_at":"2025-03-17T23:12:12.000000Z"}]},{"id":5217305,"change_date":"2024-03-06 21:40:00","inspection_id":"81030253","dot_number":"2537675","report_state":"TX","report_number":"6T4E9DAXVX","insp_date":"2024-02-28 00:00:00","insp_start_time":"1815","insp_end_time":"1915","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"1900  AIRPORT BLVD","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"SPRINT SAND & CLAY","shipping_paper_number":"7481905","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-03-05 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"0","viol_total":"14","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"14","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9214207","transaction_code":"C","transaction_date":"2024-03-06 00:00:00","upload_date":"2024-03-06 00:00:00","upload_first_byte":"0","upload_dot_number":"02537675","upload_search_indicator":"M","census_search_date":"2024-03-05 21:41:00","snet_input_date":"2024-02-28 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-03-05 21:41:00","insp_carrier_name":"BGW TRUCKING","insp_carrier_street":"12986 GREENWAY CHASE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77072","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0890687","created_at":"2025-03-17T20:05:48.000000Z","updated_at":"2025-03-17T20:05:48.000000Z","inspection_violations":[{"id":8040515,"change_date":"2024-03-06 21:40:00","inspection_id":"81030253","insp_violation_id":"258242302","seq_no":"1","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"199788619","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:53.000000Z","updated_at":"2025-03-17T21:44:53.000000Z","normalized_code":"39360C"},{"id":8040516,"change_date":"2024-03-06 21:40:00","inspection_id":"81030253","insp_violation_id":"258242303","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"199788619","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:53.000000Z","updated_at":"2025-03-17T21:44:53.000000Z","normalized_code":"3939A"},{"id":8040517,"change_date":"2024-03-06 21:40:00","inspection_id":"81030253","insp_violation_id":"258242304","seq_no":"3","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"199788619","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:53.000000Z","updated_at":"2025-03-17T21:44:53.000000Z","normalized_code":"39311"},{"id":8040518,"change_date":"2024-03-06 21:40:00","inspection_id":"81030253","insp_violation_id":"258242305","seq_no":"4","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"199788619","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:53.000000Z","updated_at":"2025-03-17T21:44:53.000000Z","normalized_code":"39311"},{"id":8040519,"change_date":"2024-03-06 21:40:00","inspection_id":"81030253","insp_violation_id":"258242306","seq_no":"5","part_no":"393","part_no_section":"83(g)","insp_viol_unit":"1","insp_unit_id":"199788619","insp_violation_category_id":"27","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:44:53.000000Z","updated_at":"2025-03-17T21:44:53.000000Z","normalized_code":"39383G"},{"id":8040520,"change_date":"2024-03-06 21:40:00","inspection_id":"81030253","insp_violation_id":"258242307","seq_no":"6","part_no":"393","part_no_section":"83(h)","insp_viol_unit":"1","insp_unit_id":"199788619","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:53.000000Z","updated_at":"2025-03-17T21:44:53.000000Z","normalized_code":"39383H"},{"id":8040521,"change_date":"2024-03-06 21:40:00","inspection_id":"81030253","insp_violation_id":"258242308","seq_no":"7","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"199788619","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:53.000000Z","updated_at":"2025-03-17T21:44:53.000000Z","normalized_code":"39345B2"},{"id":8040522,"change_date":"2024-03-06 21:40:00","inspection_id":"81030253","insp_violation_id":"258242309","seq_no":"8","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"199788619","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:53.000000Z","updated_at":"2025-03-17T21:44:53.000000Z","normalized_code":"39617C"},{"id":8040523,"change_date":"2024-03-06 21:40:00","inspection_id":"81030253","insp_violation_id":"258242310","seq_no":"9","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"199788619","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:53.000000Z","updated_at":"2025-03-17T21:44:53.000000Z","normalized_code":"39347E"},{"id":8040524,"change_date":"2024-03-06 21:40:00","inspection_id":"81030253","insp_violation_id":"258242311","seq_no":"10","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"199788619","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:53.000000Z","updated_at":"2025-03-17T21:44:53.000000Z","normalized_code":"39347E"},{"id":8040525,"change_date":"2024-03-06 21:40:00","inspection_id":"81030253","insp_violation_id":"258242312","seq_no":"11","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"199788619","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:53.000000Z","updated_at":"2025-03-17T21:44:53.000000Z","normalized_code":"3963A1"},{"id":8040526,"change_date":"2024-03-06 21:40:00","inspection_id":"81030253","insp_violation_id":"258242313","seq_no":"12","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"199788619","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:44:53.000000Z","updated_at":"2025-03-17T21:44:53.000000Z","normalized_code":"3963A1"},{"id":8040527,"change_date":"2024-03-06 21:40:00","inspection_id":"81030253","insp_violation_id":"258242314","seq_no":"13","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"199788619","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:53.000000Z","updated_at":"2025-03-17T21:44:53.000000Z","normalized_code":"39345B2"},{"id":8040528,"change_date":"2024-03-06 21:40:00","inspection_id":"81030253","insp_violation_id":"258242315","seq_no":"14","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"199788619","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:44:53.000000Z","updated_at":"2025-03-17T21:44:53.000000Z","normalized_code":"39353B"}],"inspection_per_units":[{"id":8401293,"change_date":"2024-03-06 21:40:00","inspection_id":"81030253","insp_unit_id":"199788619","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"5","insp_unit_license":"DRG2255","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKWDR9X8WR763153","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:08.000000Z","updated_at":"2025-03-17T23:11:08.000000Z"}]},{"id":5064413,"change_date":"2024-02-15 21:43:00","inspection_id":"80863785","dot_number":"2537675","report_state":"TX","report_number":"6SLF9DCO35","insp_date":"2024-02-09 00:00:00","insp_start_time":"1526","insp_end_time":"1550","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":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-02-15 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"4","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9197696","transaction_code":"A","transaction_date":"2024-02-15 00:00:00","upload_date":"2024-02-15 00:00:00","upload_first_byte":"0","upload_dot_number":"02537675","upload_search_indicator":"M","census_search_date":"2024-02-15 21:43:00","snet_input_date":"2024-02-09 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-02-15 21:43:00","insp_carrier_name":"BGW TRUCKING","insp_carrier_street":"12986 GREENWAY CHASE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77072","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0890687","created_at":"2025-03-17T20:03:04.000000Z","updated_at":"2025-03-17T20:03:04.000000Z","inspection_violations":[{"id":7805950,"change_date":"2024-02-15 21:43:00","inspection_id":"80863785","insp_violation_id":"257869228","seq_no":"1","part_no":"393","part_no_section":"201(d)","insp_viol_unit":"1","insp_unit_id":"199450891","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:46.000000Z","updated_at":"2025-03-17T21:43:46.000000Z","normalized_code":"393201D"},{"id":7805951,"change_date":"2024-02-15 21:43:00","inspection_id":"80863785","insp_violation_id":"257869229","seq_no":"2","part_no":"393","part_no_section":"201(d)","insp_viol_unit":"1","insp_unit_id":"199450891","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:46.000000Z","updated_at":"2025-03-17T21:43:46.000000Z","normalized_code":"393201D"},{"id":7805952,"change_date":"2024-02-15 21:43:00","inspection_id":"80863785","insp_violation_id":"257869230","seq_no":"3","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"199450891","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:46.000000Z","updated_at":"2025-03-17T21:43:46.000000Z","normalized_code":"39347E"},{"id":7805953,"change_date":"2024-02-15 21:43:00","inspection_id":"80863785","insp_violation_id":"257869231","seq_no":"4","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"199450891","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:46.000000Z","updated_at":"2025-03-17T21:43:46.000000Z","normalized_code":"39353B"}],"inspection_per_units":[{"id":8152496,"change_date":"2024-02-15 21:43:00","inspection_id":"80863785","insp_unit_id":"199450891","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"MXK5017","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AA13Y9XW106589","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:08:54.000000Z","updated_at":"2025-03-17T23:08:54.000000Z"}]},{"id":5054232,"change_date":"2024-02-14 21:42:00","inspection_id":"80852695","dot_number":"2537675","report_state":"TX","report_number":"6SJC9DAW8N","insp_date":"2024-02-07 00:00:00","insp_start_time":"1210","insp_end_time":"1246","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"700 W PARKWOOD AVE","county_code_state":"TX","county_code":"167","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-02-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"48000","viol_total":"6","oos_total":"3","driver_viol_total":"3","driver_oos_total":"2","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9196245","transaction_code":"A","transaction_date":"2024-02-14 00:00:00","upload_date":"2024-02-14 00:00:00","upload_first_byte":"0","upload_dot_number":"02537675","upload_search_indicator":"M","census_search_date":"2024-02-14 21:42:00","snet_input_date":"2024-02-07 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-02-14 21:42:00","insp_carrier_name":"BGW TRUCKING","insp_carrier_street":"12986 GREENWAY CHASE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77072","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0890687","created_at":"2025-03-17T20:02:46.000000Z","updated_at":"2025-03-17T20:02:46.000000Z","inspection_violations":[{"id":7789752,"change_date":"2024-02-14 21:42:00","inspection_id":"80852695","insp_violation_id":"257845375","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:43:40.000000Z","updated_at":"2025-03-17T21:43:40.000000Z","normalized_code":"3922"},{"id":7789753,"change_date":"2024-02-14 21:42:00","inspection_id":"80852695","insp_violation_id":"257845376","seq_no":"2","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:40.000000Z","updated_at":"2025-03-17T21:43:40.000000Z","normalized_code":"38323A2"},{"id":7789754,"change_date":"2024-02-14 21:42:00","inspection_id":"80852695","insp_violation_id":"257845377","seq_no":"3","part_no":"391","part_no_section":"11(b)(4)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:40.000000Z","updated_at":"2025-03-17T21:43:40.000000Z","normalized_code":"39111B4"},{"id":7789755,"change_date":"2024-02-14 21:42:00","inspection_id":"80852695","insp_violation_id":"257845378","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"199429432","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:40.000000Z","updated_at":"2025-03-17T21:43:40.000000Z","normalized_code":"3939A"},{"id":7789756,"change_date":"2024-02-14 21:42:00","inspection_id":"80852695","insp_violation_id":"257845379","seq_no":"5","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"1","insp_unit_id":"199429432","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:43:40.000000Z","updated_at":"2025-03-17T21:43:40.000000Z","normalized_code":"39348A"},{"id":7789757,"change_date":"2024-02-14 21:42:00","inspection_id":"80852695","insp_violation_id":"257845380","seq_no":"6","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"199429432","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:40.000000Z","updated_at":"2025-03-17T21:43:40.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":8135752,"change_date":"2024-02-14 21:42:00","inspection_id":"80852695","insp_unit_id":"199429432","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"SNR3635","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AE06Y64N017770","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:08:44.000000Z","updated_at":"2025-03-17T23:08:44.000000Z"}]},{"id":5054289,"change_date":"2024-02-14 21:42:00","inspection_id":"80852755","dot_number":"2537675","report_state":"TX","report_number":"6SI99DGBER","insp_date":"2024-02-06 00:00:00","insp_start_time":"0953","insp_end_time":"1014","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"2000  MAPLE LEAF DR","county_code_state":"TX","county_code":"167","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-02-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"54900","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":"9196159","transaction_code":"A","transaction_date":"2024-02-14 00:00:00","upload_date":"2024-02-14 00:00:00","upload_first_byte":"0","upload_dot_number":"02537675","upload_search_indicator":"M","census_search_date":"2024-02-14 21:42:00","snet_input_date":"2024-02-06 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-02-14 21:42:00","insp_carrier_name":"BGW TRUCKING","insp_carrier_street":"12986 GREENWAY CHASE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77072","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0890687","created_at":"2025-03-17T20:02:46.000000Z","updated_at":"2025-03-17T20:02:46.000000Z","inspection_violations":[{"id":7789915,"change_date":"2024-02-14 21:42:00","inspection_id":"80852755","insp_violation_id":"257845599","seq_no":"1","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"199429546","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:40.000000Z","updated_at":"2025-03-17T21:43:40.000000Z","normalized_code":"39345B2"},{"id":7789916,"change_date":"2024-02-14 21:42:00","inspection_id":"80852755","insp_violation_id":"257845600","seq_no":"2","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"199429546","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:40.000000Z","updated_at":"2025-03-17T21:43:40.000000Z","normalized_code":"39378"}],"inspection_per_units":[{"id":8135847,"change_date":"2024-02-14 21:42:00","inspection_id":"80852755","insp_unit_id":"199429546","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"CV7","insp_unit_license":"LYG5386","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AG11Y56M048679","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:08:44.000000Z","updated_at":"2025-03-17T23:08:44.000000Z"}]},{"id":4827575,"change_date":"2024-01-12 21:43:00","inspection_id":"80604676","dot_number":"2537675","report_state":"TX","report_number":"V241275012","insp_date":"2024-01-10 00:00:00","insp_start_time":"1030","insp_end_time":"1105","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"TX6","county_code_state":"TX","county_code":"039","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"SPRINT SAND","shipping_paper_number":"70127963","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-01-12 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"50000","viol_total":"7","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9172343","transaction_code":"A","transaction_date":"2024-01-12 00:00:00","upload_date":"2024-01-12 00:00:00","upload_first_byte":"0","upload_dot_number":"02537675","upload_search_indicator":"M","census_search_date":"2024-01-12 21:43:00","snet_input_date":"2024-01-10 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-01-12 21:43:00","insp_carrier_name":"BGW TRUCKING","insp_carrier_street":"12986 GREENWAY CHASE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77072","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0890687","created_at":"2025-03-17T19:58:26.000000Z","updated_at":"2025-03-17T19:58:26.000000Z","inspection_violations":[{"id":7444158,"change_date":"2024-01-12 21:43:00","inspection_id":"80604676","insp_violation_id":"257328176","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"198949835","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:56.000000Z","updated_at":"2025-03-17T21:41:56.000000Z","normalized_code":"3939A"},{"id":7444159,"change_date":"2024-01-12 21:43:00","inspection_id":"80604676","insp_violation_id":"257328177","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"198949835","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:56.000000Z","updated_at":"2025-03-17T21:41:56.000000Z","normalized_code":"3939A"},{"id":7444160,"change_date":"2024-01-12 21:43:00","inspection_id":"80604676","insp_violation_id":"257328178","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"198949835","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:56.000000Z","updated_at":"2025-03-17T21:41:56.000000Z","normalized_code":"3939A"},{"id":7444161,"change_date":"2024-01-12 21:43:00","inspection_id":"80604676","insp_violation_id":"257328179","seq_no":"4","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"198949835","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:56.000000Z","updated_at":"2025-03-17T21:41:56.000000Z","normalized_code":"3963A1"},{"id":7444162,"change_date":"2024-01-12 21:43:00","inspection_id":"80604676","insp_violation_id":"257328180","seq_no":"5","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"198949835","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:41:56.000000Z","updated_at":"2025-03-17T21:41:56.000000Z","normalized_code":"3963A1"},{"id":7444163,"change_date":"2024-01-12 21:43:00","inspection_id":"80604676","insp_violation_id":"257328181","seq_no":"6","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"198949835","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:56.000000Z","updated_at":"2025-03-17T21:41:56.000000Z","normalized_code":"3965B"},{"id":7444164,"change_date":"2024-01-12 21:43:00","inspection_id":"80604676","insp_violation_id":"257328182","seq_no":"7","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"198949835","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:56.000000Z","updated_at":"2025-03-17T21:41:56.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7767129,"change_date":"2024-01-12 21:43:00","inspection_id":"80604676","insp_unit_id":"198949835","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"2075","insp_unit_license":"RMG1028","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AK06Y06N013371","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:05:25.000000Z","updated_at":"2025-03-17T23:05:25.000000Z"}]},{"id":4728050,"change_date":"2024-12-05 21:37:00","inspection_id":"80495970","dot_number":"2537675","report_state":"TX","report_number":"6R6B9DAW6H","insp_date":"2023-12-20 00:00:00","insp_start_time":"1159","insp_end_time":"1218","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"2200 S FRIENDSWOOD D","county_code_state":"TX","county_code":"167","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-12-28 21:45:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"9159941","transaction_code":"C","transaction_date":"2024-12-05 00:00:00","upload_date":"2024-12-05 00:00:00","upload_first_byte":"0","upload_dot_number":"02537675","upload_search_indicator":"M","census_search_date":"2023-12-28 21:45:00","snet_input_date":"2023-12-20 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-12-28 21:45:00","insp_carrier_name":"BGW TRUCKING","insp_carrier_street":"12986 GREENWAY CHASE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77072","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0890687","created_at":"2025-03-17T19:56:32.000000Z","updated_at":"2025-03-17T19:56:32.000000Z","inspection_violations":[{"id":7300312,"change_date":"2024-12-05 21:37:00","inspection_id":"80495970","insp_violation_id":"263259831","seq_no":"2","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"204206940","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:17.000000Z","updated_at":"2025-03-17T21:41:17.000000Z","normalized_code":"39378"},{"id":7300313,"change_date":"2024-12-05 21:37:00","inspection_id":"80495970","insp_violation_id":"263259832","seq_no":"3","part_no":"393","part_no_section":"45B2","insp_viol_unit":"1","insp_unit_id":"204206940","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:17.000000Z","updated_at":"2025-03-17T21:41:17.000000Z","normalized_code":"39345B2"},{"id":7300314,"change_date":"2024-12-05 21:37:00","inspection_id":"80495970","insp_violation_id":"263259833","seq_no":"4","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"204206940","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:17.000000Z","updated_at":"2025-03-17T21:41:17.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":7605463,"change_date":"2024-12-05 21:37:00","inspection_id":"80495970","insp_unit_id":"204206940","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"LYG5386","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AG11Y56M048679","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:04:00.000000Z","updated_at":"2025-03-17T23:04:00.000000Z"}]},{"id":4712582,"change_date":"2024-12-06 21:44:00","inspection_id":"80479268","dot_number":"2537675","report_state":"TX","report_number":"6R1F9DCOZH","insp_date":"2023-12-15 00:00:00","insp_start_time":"1523","insp_end_time":"1535","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"300  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":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-27 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"6","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9155667","transaction_code":"C","transaction_date":"2024-12-06 00:00:00","upload_date":"2024-12-06 00:00:00","upload_first_byte":"0","upload_dot_number":"02537675","upload_search_indicator":"M","census_search_date":"2023-12-27 21:42:00","snet_input_date":"2023-12-15 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-12-27 21:42:00","insp_carrier_name":"BGW TRUCKING","insp_carrier_street":"12986 GREENWAY CHASE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77072","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0890687","created_at":"2025-03-17T19:56:11.000000Z","updated_at":"2025-03-17T19:56:11.000000Z","inspection_violations":[{"id":7275852,"change_date":"2024-12-06 21:44:00","inspection_id":"80479268","insp_violation_id":"263294088","seq_no":"1","part_no":"393","part_no_section":"95A","insp_viol_unit":"1","insp_unit_id":"204235701","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:07.000000Z","updated_at":"2025-03-17T21:41:07.000000Z","normalized_code":"39395A"},{"id":7275853,"change_date":"2024-12-06 21:44:00","inspection_id":"80479268","insp_violation_id":"263294089","seq_no":"2","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"204235701","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:07.000000Z","updated_at":"2025-03-17T21:41:07.000000Z","normalized_code":"39395F"},{"id":7275854,"change_date":"2024-12-06 21:44:00","inspection_id":"80479268","insp_violation_id":"263294090","seq_no":"3","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"204235701","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:07.000000Z","updated_at":"2025-03-17T21:41:07.000000Z","normalized_code":"39378"},{"id":7275855,"change_date":"2024-12-06 21:44:00","inspection_id":"80479268","insp_violation_id":"263294091","seq_no":"4","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"204235701","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:07.000000Z","updated_at":"2025-03-17T21:41:07.000000Z","normalized_code":"3939"},{"id":7275856,"change_date":"2024-12-06 21:44:00","inspection_id":"80479268","insp_violation_id":"263294092","seq_no":"5","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"204235701","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:07.000000Z","updated_at":"2025-03-17T21:41:07.000000Z","normalized_code":"3939"},{"id":7275857,"change_date":"2024-12-06 21:44:00","inspection_id":"80479268","insp_violation_id":"263294093","seq_no":"6","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"204235701","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:07.000000Z","updated_at":"2025-03-17T21:41:07.000000Z","normalized_code":"3939"}],"inspection_per_units":[{"id":7579984,"change_date":"2024-12-06 21:44:00","inspection_id":"80479268","insp_unit_id":"204235701","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"GFF9108","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AG11Y43M006869","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:03:44.000000Z","updated_at":"2025-03-17T23:03:44.000000Z"}]},{"id":4426158,"change_date":"2023-11-14 21:42:00","inspection_id":"80164770","dot_number":"2537675","report_state":"TX","report_number":"V231227925","insp_date":"2023-11-09 00:00:00","insp_start_time":"1523","insp_end_time":"1618","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH10 EB SVC RD","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"SPRINT SAND AND CLAY","shipping_paper_number":"472480070","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":"Y","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-11-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","viol_total":"9","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"9","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9126017","transaction_code":"A","transaction_date":"2023-11-14 00:00:00","upload_date":"2023-11-14 00:00:00","upload_first_byte":"0","upload_dot_number":"02537675","upload_search_indicator":"M","census_search_date":"2023-11-14 21:42:00","snet_input_date":"2023-11-09 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-11-14 21:42:00","insp_carrier_name":"BGW TRUCKING","insp_carrier_street":"12986 GREENWAY CHASE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77072","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0890687","created_at":"2025-03-17T19:50:42.000000Z","updated_at":"2025-03-17T19:50:42.000000Z","inspection_violations":[{"id":6850378,"change_date":"2023-11-14 21:42:00","inspection_id":"80164770","insp_violation_id":"256399474","seq_no":"1","part_no":"393","part_no_section":"104(c)","insp_viol_unit":"1","insp_unit_id":"198063776","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:00.000000Z","updated_at":"2025-03-17T21:39:00.000000Z","normalized_code":"393104C"},{"id":6850379,"change_date":"2023-11-14 21:42:00","inspection_id":"80164770","insp_violation_id":"256399475","seq_no":"2","part_no":"393","part_no_section":"104(c)","insp_viol_unit":"1","insp_unit_id":"198063776","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:00.000000Z","updated_at":"2025-03-17T21:39:00.000000Z","normalized_code":"393104C"},{"id":6850380,"change_date":"2023-11-14 21:42:00","inspection_id":"80164770","insp_violation_id":"256399476","seq_no":"3","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"198063776","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:00.000000Z","updated_at":"2025-03-17T21:39:00.000000Z","normalized_code":"39378"},{"id":6850381,"change_date":"2023-11-14 21:42:00","inspection_id":"80164770","insp_violation_id":"256399477","seq_no":"4","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"198063776","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:00.000000Z","updated_at":"2025-03-17T21:39:00.000000Z","normalized_code":"39395A"},{"id":6850382,"change_date":"2023-11-14 21:42:00","inspection_id":"80164770","insp_violation_id":"256399478","seq_no":"5","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"198063776","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:00.000000Z","updated_at":"2025-03-17T21:39:00.000000Z","normalized_code":"39617C"},{"id":6850383,"change_date":"2023-11-14 21:42:00","inspection_id":"80164770","insp_violation_id":"256399479","seq_no":"6","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"198063776","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:00.000000Z","updated_at":"2025-03-17T21:39:00.000000Z","normalized_code":"3965B"},{"id":6850384,"change_date":"2023-11-14 21:42:00","inspection_id":"80164770","insp_violation_id":"256399480","seq_no":"7","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"198063776","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:00.000000Z","updated_at":"2025-03-17T21:39:00.000000Z","normalized_code":"3922"},{"id":6850385,"change_date":"2023-11-14 21:42:00","inspection_id":"80164770","insp_violation_id":"256399481","seq_no":"8","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"198063776","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:00.000000Z","updated_at":"2025-03-17T21:39:00.000000Z","normalized_code":"3922"},{"id":6850386,"change_date":"2023-11-14 21:42:00","inspection_id":"80164770","insp_violation_id":"256399482","seq_no":"9","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"198063776","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:39:00.000000Z","updated_at":"2025-03-17T21:39:00.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7118272,"change_date":"2023-11-14 21:42:00","inspection_id":"80164770","insp_unit_id":"198063776","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"937","insp_unit_license":"MXK5017","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AA13Y9XW106589","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:59:46.000000Z","updated_at":"2025-03-17T22:59:46.000000Z"}]},{"id":4325659,"change_date":"2023-10-31 21:40:00","inspection_id":"80053640","dot_number":"2537675","report_state":"TX","report_number":"6PK79DAW4K","insp_date":"2023-10-23 00:00:00","insp_start_time":"0945","insp_end_time":"1028","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"2100 W PARKWOOD AVE","county_code_state":"TX","county_code":"167","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-10-31 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"54900","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":"9113773","transaction_code":"A","transaction_date":"2023-10-31 00:00:00","upload_date":"2023-10-31 00:00:00","upload_first_byte":"0","upload_dot_number":"02537675","upload_search_indicator":"M","census_search_date":"2023-10-31 21:40:00","snet_input_date":"2023-10-23 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-10-31 21:40:00","insp_carrier_name":"BGW TRUCKING","insp_carrier_street":"12986 GREENWAY CHASE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77072","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0890687","created_at":"2025-03-17T19:48:42.000000Z","updated_at":"2025-03-17T19:48:42.000000Z","inspection_violations":[{"id":6690727,"change_date":"2023-10-31 21:40:00","inspection_id":"80053640","insp_violation_id":"256147390","seq_no":"1","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"197841380","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:12.000000Z","updated_at":"2025-03-17T21:38:12.000000Z","normalized_code":"39360C"},{"id":6690728,"change_date":"2023-10-31 21:40:00","inspection_id":"80053640","insp_violation_id":"256147391","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"197841380","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:12.000000Z","updated_at":"2025-03-17T21:38:12.000000Z","normalized_code":"3939A"},{"id":6690729,"change_date":"2023-10-31 21:40:00","inspection_id":"80053640","insp_violation_id":"256147392","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"197841380","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:12.000000Z","updated_at":"2025-03-17T21:38:12.000000Z","normalized_code":"3939A"},{"id":6690730,"change_date":"2023-10-31 21:40:00","inspection_id":"80053640","insp_violation_id":"256147393","seq_no":"4","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"197841380","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:38:12.000000Z","updated_at":"2025-03-17T21:38:12.000000Z","normalized_code":"39345B2"}],"inspection_per_units":[{"id":6956785,"change_date":"2023-10-31 21:40:00","inspection_id":"80053640","insp_unit_id":"197841380","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"HMY8878","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AG11Y53M006010","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:58:24.000000Z","updated_at":"2025-03-17T22:58:24.000000Z"}]},{"id":4176273,"change_date":"2023-10-11 21:41:00","inspection_id":"79888447","dot_number":"2537675","report_state":"TX","report_number":"6OU99DGT8V","insp_date":"2023-09-27 00:00:00","insp_start_time":"0958","insp_end_time":"1028","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"5600  MYKAWA RD","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"BGW","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-10-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"9097253","transaction_code":"A","transaction_date":"2023-10-11 00:00:00","upload_date":"2023-10-11 00:00:00","upload_first_byte":"0","upload_dot_number":"02537675","upload_search_indicator":"M","census_search_date":"2023-10-11 21:41:00","snet_input_date":"2023-09-27 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-10-11 21:41:00","insp_carrier_name":"BGW TRUCKING","insp_carrier_street":"12986 GREENWAY CHASE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77072","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0890687","created_at":"2025-03-17T19:45:30.000000Z","updated_at":"2025-03-17T19:45:30.000000Z","inspection_violations":[{"id":6465642,"change_date":"2023-10-11 21:41:00","inspection_id":"79888447","insp_violation_id":"255782316","seq_no":"2","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"197508180","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:11.000000Z","updated_at":"2025-03-17T21:37:11.000000Z","normalized_code":"39378"},{"id":6465643,"change_date":"2023-10-11 21:41:00","inspection_id":"79888447","insp_violation_id":"255782317","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"197508180","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:11.000000Z","updated_at":"2025-03-17T21:37:11.000000Z","normalized_code":"3939A"},{"id":6465644,"change_date":"2023-10-11 21:41:00","inspection_id":"79888447","insp_violation_id":"255782318","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"197508180","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:11.000000Z","updated_at":"2025-03-17T21:37:11.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":6715862,"change_date":"2023-10-11 21:41:00","inspection_id":"79888447","insp_unit_id":"197508180","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"1063","insp_unit_license":"LYG5386","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AG11Y56M048679","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:19.000000Z","updated_at":"2025-03-17T22:56:19.000000Z"}]},{"id":3677071,"change_date":"2023-08-04 21:41:00","inspection_id":"79332999","dot_number":"2537675","report_state":"TX","report_number":"6NA89DBQ2Q","insp_date":"2023-08-02 00:00:00","insp_start_time":"0809","insp_end_time":"0855","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"3200  CULLEN PKWY","county_code_state":"TX","county_code":"039","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"SPRINT","shipping_paper_number":"1897593","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-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"54900","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9044856","transaction_code":"A","transaction_date":"2023-08-04 00:00:00","upload_date":"2023-08-04 00:00:00","upload_first_byte":"0","upload_dot_number":"02537675","upload_search_indicator":"M","census_search_date":"2023-08-04 21:41:00","snet_input_date":"2023-08-02 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-08-04 21:41:00","insp_carrier_name":"BGW TRUCKING","insp_carrier_street":"12986 GREENWAY CHASE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77072","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0890687","created_at":"2025-03-17T19:35:20.000000Z","updated_at":"2025-03-17T19:35:20.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5912014,"change_date":"2023-08-04 21:41:00","inspection_id":"79332999","insp_unit_id":"196379646","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"1742","insp_unit_license":"GFF9108","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AG11Y43M006869","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:42.000000Z","updated_at":"2025-03-17T22:49:42.000000Z"}]},{"id":3645426,"change_date":"2023-08-01 21:42:00","inspection_id":"79297251","dot_number":"2537675","report_state":"TX","report_number":"6MYE9DJNNC","insp_date":"2023-07-21 00:00:00","insp_start_time":"1431","insp_end_time":"1505","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"300  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":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-08-01 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"50000","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":"9041305","transaction_code":"A","transaction_date":"2023-08-01 00:00:00","upload_date":"2023-08-01 00:00:00","upload_first_byte":"0","upload_dot_number":"02537675","upload_search_indicator":null,"census_search_date":"2023-08-01 21:42:00","snet_input_date":"2023-07-21 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-08-01 21:42:00","insp_carrier_name":"JACKSON, DONALD II","insp_carrier_street":"4210 GROTON DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77047","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0890687","created_at":"2025-03-17T19:34:55.000000Z","updated_at":"2025-03-17T19:34:55.000000Z","inspection_violations":[{"id":5621688,"change_date":"2023-08-01 21:42:00","inspection_id":"79297251","insp_violation_id":"254406318","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196308122","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:05.000000Z","updated_at":"2025-03-17T21:33:05.000000Z","normalized_code":"3939A"},{"id":5621689,"change_date":"2023-08-01 21:42:00","inspection_id":"79297251","insp_violation_id":"254406319","seq_no":"2","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"196308122","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:05.000000Z","updated_at":"2025-03-17T21:33:05.000000Z","normalized_code":"39311"},{"id":5621690,"change_date":"2023-08-01 21:42:00","inspection_id":"79297251","insp_violation_id":"254406320","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196308122","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:05.000000Z","updated_at":"2025-03-17T21:33:05.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":5861607,"change_date":"2023-08-01 21:42:00","inspection_id":"79297251","insp_unit_id":"196308122","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"2075","insp_unit_license":"RMG1028","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AK06Y06N013371","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:49:17.000000Z","updated_at":"2025-03-17T22:49:17.000000Z"}]},{"id":3416600,"change_date":"2023-06-30 21:41:00","inspection_id":"79040426","dot_number":"2537675","report_state":"TX","report_number":"6MBA9DJX4R","insp_date":"2023-06-28 00:00:00","insp_start_time":"1058","insp_end_time":"1115","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"7700  EASTEX FWY","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"SPRINT SAND AND CLAY","shipping_paper_number":"53053456","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-06-30 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"54900","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":"9017628","transaction_code":"A","transaction_date":"2023-06-30 00:00:00","upload_date":"2023-06-30 00:00:00","upload_first_byte":"0","upload_dot_number":"02537675","upload_search_indicator":"M","census_search_date":"2023-06-30 21:41:00","snet_input_date":"2023-06-28 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-06-30 21:41:00","insp_carrier_name":"BGW TRUCKING","insp_carrier_street":"12986 GREENWAY CHASE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77072","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0890687","created_at":"2025-03-17T19:30:37.000000Z","updated_at":"2025-03-17T19:30:37.000000Z","inspection_violations":[{"id":5267389,"change_date":"2023-06-30 21:41:00","inspection_id":"79040426","insp_violation_id":"253828084","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"195790713","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:28.000000Z","updated_at":"2025-03-17T21:31:28.000000Z","normalized_code":"39378"},{"id":5267390,"change_date":"2023-06-30 21:41:00","inspection_id":"79040426","insp_violation_id":"253828085","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"195790713","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:31:28.000000Z","updated_at":"2025-03-17T21:31:28.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":5493222,"change_date":"2023-06-30 21:41:00","inspection_id":"79040426","insp_unit_id":"195790713","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MCKT","insp_unit_company":"2075","insp_unit_license":"RMG1028","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AK06Y06N013371","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:46:20.000000Z","updated_at":"2025-03-17T22:46:20.000000Z"}]},{"id":3345860,"change_date":"2023-06-22 21:42:00","inspection_id":"78960983","dot_number":"2537675","report_state":"TX","report_number":"6LYG9DGTZX","insp_date":"2023-06-15 00:00:00","insp_start_time":"1649","insp_end_time":"1709","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"300 N MAIN ST","county_code_state":"TX","county_code":"201","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"REYTEC CONSTRUCTION RESOURCES","shipping_paper_number":"53051319","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-06-22 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"48000","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9011252","transaction_code":"A","transaction_date":"2023-06-22 00:00:00","upload_date":"2023-06-22 00:00:00","upload_first_byte":"0","upload_dot_number":"02537675","upload_search_indicator":"M","census_search_date":"2023-06-22 21:42:00","snet_input_date":"2023-06-15 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-06-22 21:42:00","insp_carrier_name":"BGW TRUCKING","insp_carrier_street":"12986 GREENWAY CHASE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77072","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0890687","created_at":"2025-03-17T19:29:20.000000Z","updated_at":"2025-03-17T19:29:20.000000Z","inspection_violations":[{"id":5159758,"change_date":"2023-06-22 21:42:00","inspection_id":"78960983","insp_violation_id":"253654350","seq_no":"1","part_no":"392","part_no_section":"16(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"11","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:30:55.000000Z","updated_at":"2025-03-17T21:30:55.000000Z","normalized_code":"39216A"}],"inspection_per_units":[{"id":5378935,"change_date":"2023-06-22 21:42:00","inspection_id":"78960983","insp_unit_id":"195632942","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"1568","insp_unit_license":"DRG2255","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKWDR9X8WR763153","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:45:25.000000Z","updated_at":"2025-03-17T22:45:25.000000Z"}]},{"id":3004600,"change_date":"2023-05-09 21:43:00","inspection_id":"78575900","dot_number":"2537675","report_state":"TX","report_number":"6KQH9DCKET","insp_date":"2023-05-02 00:00:00","insp_start_time":"1703","insp_end_time":"1725","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":"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-09 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"3","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8974401","transaction_code":"A","transaction_date":"2023-05-09 00:00:00","upload_date":"2023-05-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02537675","upload_search_indicator":"M","census_search_date":"2023-05-09 21:43:00","snet_input_date":"2023-05-02 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-05-09 21:43:00","insp_carrier_name":"BGW TRUCKING","insp_carrier_street":"12986 GREENWAY CHASE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77072","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0890687","created_at":"2025-03-17T19:22:36.000000Z","updated_at":"2025-03-17T19:22:36.000000Z","inspection_violations":[{"id":4614920,"change_date":"2023-05-09 21:43:00","inspection_id":"78575900","insp_violation_id":"252727444","seq_no":"1","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"194839808","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:29.000000Z","updated_at":"2025-03-17T21:28:29.000000Z","normalized_code":"39345B2"},{"id":4614921,"change_date":"2023-05-09 21:43:00","inspection_id":"78575900","insp_violation_id":"252727445","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"194839808","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:29.000000Z","updated_at":"2025-03-17T21:28:29.000000Z","normalized_code":"3939A"},{"id":4614922,"change_date":"2023-05-09 21:43:00","inspection_id":"78575900","insp_violation_id":"252727446","seq_no":"3","part_no":"390","part_no_section":"3(e)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"8","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:28:29.000000Z","updated_at":"2025-03-17T21:28:29.000000Z","normalized_code":"3903E"}],"inspection_per_units":[{"id":4834458,"change_date":"2023-05-09 21:43:00","inspection_id":"78575900","insp_unit_id":"194839808","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"HMY8878","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AG11Y53M006010","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:41:04.000000Z","updated_at":"2025-03-17T22:41:04.000000Z"}]},{"id":2678669,"change_date":"2023-03-28 21:41:00","inspection_id":"78205446","dot_number":"2537675","report_state":"TX","report_number":"6JQC9DBPDD","insp_date":"2023-03-27 00:00:00","insp_start_time":"1215","insp_end_time":"1330","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"8000 N MAIN ST","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"SPRINT SAND & CLAY","shipping_paper_number":"47226240","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-28 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","viol_total":"8","oos_total":"2","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"6","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8940215","transaction_code":"A","transaction_date":"2023-03-28 00:00:00","upload_date":"2023-03-28 00:00:00","upload_first_byte":"0","upload_dot_number":"02537675","upload_search_indicator":"M","census_search_date":"2023-03-28 21:41:00","snet_input_date":"2023-03-27 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-03-28 21:41:00","insp_carrier_name":"BGW TRUCKING","insp_carrier_street":"12986 GREENWAY CHASE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77072","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0890687","created_at":"2025-03-17T19:15:55.000000Z","updated_at":"2025-03-17T19:15:55.000000Z","inspection_violations":[{"id":4116352,"change_date":"2023-03-28 21:41:00","inspection_id":"78205446","insp_violation_id":"251910981","seq_no":"1","part_no":"392","part_no_section":"82(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:15.000000Z","updated_at":"2025-03-17T21:26:15.000000Z","normalized_code":"39282A1"},{"id":4116353,"change_date":"2023-03-28 21:41:00","inspection_id":"78205446","insp_violation_id":"251910982","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"194105107","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:15.000000Z","updated_at":"2025-03-17T21:26:15.000000Z","normalized_code":"3939A"},{"id":4116354,"change_date":"2023-03-28 21:41:00","inspection_id":"78205446","insp_violation_id":"251910983","seq_no":"3","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"194105107","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:15.000000Z","updated_at":"2025-03-17T21:26:15.000000Z","normalized_code":"39347E"},{"id":4116355,"change_date":"2023-03-28 21:41:00","inspection_id":"78205446","insp_violation_id":"251910984","seq_no":"4","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"194105107","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:15.000000Z","updated_at":"2025-03-17T21:26:15.000000Z","normalized_code":"39347E"},{"id":4116356,"change_date":"2023-03-28 21:41:00","inspection_id":"78205446","insp_violation_id":"251910985","seq_no":"5","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"194105107","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:15.000000Z","updated_at":"2025-03-17T21:26:15.000000Z","normalized_code":"39347E"},{"id":4116357,"change_date":"2023-03-28 21:41:00","inspection_id":"78205446","insp_violation_id":"251910986","seq_no":"6","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"194105107","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:15.000000Z","updated_at":"2025-03-17T21:26:15.000000Z","normalized_code":"39353B"},{"id":4116358,"change_date":"2023-03-28 21:41:00","inspection_id":"78205446","insp_violation_id":"251910987","seq_no":"7","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"194105107","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:26:15.000000Z","updated_at":"2025-03-17T21:26:15.000000Z","normalized_code":"3963A1"},{"id":4116359,"change_date":"2023-03-28 21:41:00","inspection_id":"78205446","insp_violation_id":"251910988","seq_no":"8","part_no":"390","part_no_section":"3(e)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"8","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:26:15.000000Z","updated_at":"2025-03-17T21:26:15.000000Z","normalized_code":"3903E"}],"inspection_per_units":[{"id":4313141,"change_date":"2023-03-28 21:41:00","inspection_id":"78205446","insp_unit_id":"194105107","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MCKT","insp_unit_company":"1725","insp_unit_license":"HMY8878","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AG11Y53M006010","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:58.000000Z","updated_at":"2025-03-17T22:36:58.000000Z"}]},{"id":2678071,"change_date":"2023-03-28 21:41:00","inspection_id":"78204779","dot_number":"2537675","report_state":"TX","report_number":"6JKE9DGPN4","insp_date":"2023-03-21 00:00:00","insp_start_time":"1403","insp_end_time":"1427","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"7200  EASTEX FWY","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-03-28 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8939167","transaction_code":"A","transaction_date":"2023-03-28 00:00:00","upload_date":"2023-03-28 00:00:00","upload_first_byte":"0","upload_dot_number":"02537675","upload_search_indicator":"M","census_search_date":"2023-03-28 21:41:00","snet_input_date":"2023-03-21 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-03-28 21:41:00","insp_carrier_name":"BGW TRUCKING","insp_carrier_street":"12986 GREENWAY CHASE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77072","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0890687","created_at":"2025-03-17T19:15:55.000000Z","updated_at":"2025-03-17T19:15:55.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4312133,"change_date":"2023-03-28 21:41:00","inspection_id":"78204779","insp_unit_id":"194103893","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"LYG5386","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AG11Y56M048679","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:58.000000Z","updated_at":"2025-03-17T22:36:58.000000Z"}]},{"id":2328506,"change_date":"2023-02-08 21:40:00","inspection_id":"77807020","dot_number":"2537675","report_state":"TX","report_number":"6IAD0XUQ7Y","insp_date":"2023-02-03 00:00:00","insp_start_time":"1305","insp_end_time":"1315","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"FM-0518 IN GALVESTON CO. (692-","county_code_state":"TX","county_code":"167","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-02-08 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"8899024","transaction_code":"A","transaction_date":"2023-02-08 00:00:00","upload_date":"2023-02-08 00:00:00","upload_first_byte":"0","upload_dot_number":"02537675","upload_search_indicator":"M","census_search_date":"2023-02-08 21:40:00","snet_input_date":"2023-02-03 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-02-08 21:40:00","insp_carrier_name":"BGW TRUCKING","insp_carrier_street":"12986 GREENWAY CHASE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77072","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0890687","created_at":"2025-03-17T19:09:37.000000Z","updated_at":"2025-03-17T19:09:37.000000Z","inspection_violations":[{"id":3586858,"change_date":"2023-02-08 21:40:00","inspection_id":"77807020","insp_violation_id":"251025615","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"193300753","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:55.000000Z","updated_at":"2025-03-17T21:23:55.000000Z","normalized_code":"39378"},{"id":3586859,"change_date":"2023-02-08 21:40:00","inspection_id":"77807020","insp_violation_id":"251025616","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"193300753","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:55.000000Z","updated_at":"2025-03-17T21:23:55.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":3747546,"change_date":"2023-02-08 21:40:00","inspection_id":"77807020","insp_unit_id":"193300753","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"937","insp_unit_license":"MXK5017","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AA13Y9XW106589","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:32:50.000000Z","updated_at":"2025-03-17T22:32:50.000000Z"}]},{"id":2109027,"change_date":"2023-01-10 21:41:00","inspection_id":"77556629","dot_number":"2537675","report_state":"TX","report_number":"6HGC0XVRNP","insp_date":"2023-01-04 00:00:00","insp_start_time":"1210","insp_end_time":"1237","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0610 IN HARRIS CO. (0-37)","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"BGW TRUCKING","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":"N","pen_cen_match":null,"final_status_date":"2023-01-10 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","viol_total":"7","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8873306","transaction_code":"A","transaction_date":"2023-01-10 00:00:00","upload_date":"2023-01-10 00:00:00","upload_first_byte":"0","upload_dot_number":"02537675","upload_search_indicator":"M","census_search_date":"2023-01-10 21:41:00","snet_input_date":"2023-01-04 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-01-10 21:41:00","insp_carrier_name":"BGW TRUCKING","insp_carrier_street":"12986 GREENWAY CHASE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77072","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0890687","created_at":"2025-03-17T19:05:31.000000Z","updated_at":"2025-03-17T19:05:31.000000Z","inspection_violations":[{"id":3265307,"change_date":"2023-01-10 21:41:00","inspection_id":"77556629","insp_violation_id":"250490110","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"192794031","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:28.000000Z","updated_at":"2025-03-17T21:22:28.000000Z","normalized_code":"39378"},{"id":3265308,"change_date":"2023-01-10 21:41:00","inspection_id":"77556629","insp_violation_id":"250490111","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"192794031","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:28.000000Z","updated_at":"2025-03-17T21:22:28.000000Z","normalized_code":"3939A"},{"id":3265309,"change_date":"2023-01-10 21:41:00","inspection_id":"77556629","insp_violation_id":"250490112","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"192794031","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:28.000000Z","updated_at":"2025-03-17T21:22:28.000000Z","normalized_code":"3939A"},{"id":3265310,"change_date":"2023-01-10 21:41:00","inspection_id":"77556629","insp_violation_id":"250490113","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"192794031","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:28.000000Z","updated_at":"2025-03-17T21:22:28.000000Z","normalized_code":"3939A"},{"id":3265311,"change_date":"2023-01-10 21:41:00","inspection_id":"77556629","insp_violation_id":"250490114","seq_no":"5","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"192794031","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:28.000000Z","updated_at":"2025-03-17T21:22:28.000000Z","normalized_code":"3963A1"},{"id":3265312,"change_date":"2023-01-10 21:41:00","inspection_id":"77556629","insp_violation_id":"250490115","seq_no":"6","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"192794031","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:28.000000Z","updated_at":"2025-03-17T21:22:28.000000Z","normalized_code":"3922"},{"id":3265313,"change_date":"2023-01-10 21:41:00","inspection_id":"77556629","insp_violation_id":"250490116","seq_no":"7","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"192794031","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:28.000000Z","updated_at":"2025-03-17T21:22:28.000000Z","normalized_code":"39353B"}],"inspection_per_units":[{"id":3394357,"change_date":"2023-01-10 21:41:00","inspection_id":"77556629","insp_unit_id":"192794031","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"1742","insp_unit_license":"GFF9108","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AG11Y43M006869","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:30:18.000000Z","updated_at":"2025-03-17T22:30:18.000000Z"}]},{"id":1949848,"change_date":"2022-12-14 21:40:00","inspection_id":"77374899","dot_number":"2537675","report_state":"TX","report_number":"6GMA9DAWSX","insp_date":"2022-12-05 00:00:00","insp_start_time":"1012","insp_end_time":"1045","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"1800  FRIENDSWOOD PK","county_code_state":"TX","county_code":"167","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2022-12-14 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"8850892","transaction_code":"A","transaction_date":"2022-12-14 00:00:00","upload_date":"2022-12-14 00:00:00","upload_first_byte":"0","upload_dot_number":"02537675","upload_search_indicator":"M","census_search_date":"2022-12-14 21:40:00","snet_input_date":"2022-12-05 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-12-14 21:40:00","insp_carrier_name":"BGW TRUCKING","insp_carrier_street":"12986 GREENWAY CHASE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77072","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0890687","created_at":"2025-03-17T19:02:34.000000Z","updated_at":"2025-03-17T19:02:34.000000Z","inspection_violations":[{"id":3028618,"change_date":"2022-12-14 21:40:00","inspection_id":"77374899","insp_violation_id":"250106215","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:25.000000Z","updated_at":"2025-03-17T21:21:25.000000Z","normalized_code":"3922"},{"id":3028619,"change_date":"2022-12-14 21:40:00","inspection_id":"77374899","insp_violation_id":"250106216","seq_no":"2","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"192433119","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:25.000000Z","updated_at":"2025-03-17T21:21:25.000000Z","normalized_code":"39395A"},{"id":3028620,"change_date":"2022-12-14 21:40:00","inspection_id":"77374899","insp_violation_id":"250106217","seq_no":"3","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"192433119","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:25.000000Z","updated_at":"2025-03-17T21:21:25.000000Z","normalized_code":"39378"},{"id":3028621,"change_date":"2022-12-14 21:40:00","inspection_id":"77374899","insp_violation_id":"250106218","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"192433119","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:25.000000Z","updated_at":"2025-03-17T21:21:25.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":3137498,"change_date":"2022-12-14 21:40:00","inspection_id":"77374899","insp_unit_id":"192433119","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"MXK5017","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AA13Y9XW106589","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:29.000000Z","updated_at":"2025-03-17T22:28:29.000000Z"}]},{"id":1440850,"change_date":"2022-10-04 21:41:00","inspection_id":"76789889","dot_number":"2537675","report_state":"TX","report_number":"6ERF9DJM6P","insp_date":"2022-09-29 00:00:00","insp_start_time":"1520","insp_end_time":"1542","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"4600  S SAM 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":"Y","pen_cen_match":null,"final_status_date":"2022-10-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"48000","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":"8789866","transaction_code":"A","transaction_date":"2022-10-04 00:00:00","upload_date":"2022-10-04 00:00:00","upload_first_byte":"0","upload_dot_number":"02537675","upload_search_indicator":"M","census_search_date":"2022-10-04 21:41:00","snet_input_date":"2022-09-29 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-10-04 21:41:00","insp_carrier_name":"BGW TRUCKING","insp_carrier_street":"12986 GREENWAY CHASE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77072","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0890687","created_at":"2025-03-17T18:53:22.000000Z","updated_at":"2025-03-17T18:53:22.000000Z","inspection_violations":[{"id":2270351,"change_date":"2022-10-04 21:41:00","inspection_id":"76789889","insp_violation_id":"248832446","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"191268826","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:24.000000Z","updated_at":"2025-03-17T21:17:24.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":2319645,"change_date":"2022-10-04 21:41:00","inspection_id":"76789889","insp_unit_id":"191268826","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"DRG2255","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKWDR9X8WR763153","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:22:52.000000Z","updated_at":"2025-03-17T22:22:52.000000Z"}]},{"id":887391,"change_date":"2022-07-25 21:40:00","inspection_id":"76145584","dot_number":"2537675","report_state":"TX","report_number":"6CT89DCG75","insp_date":"2022-07-21 00:00:00","insp_start_time":"0805","insp_end_time":"0838","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"4600  NAVIGATION","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":"2022-07-25 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","viol_total":"6","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8722626","transaction_code":"A","transaction_date":"2022-07-25 00:00:00","upload_date":"2022-07-25 00:00:00","upload_first_byte":"0","upload_dot_number":"02537675","upload_search_indicator":"M","census_search_date":"2022-07-25 21:40:00","snet_input_date":"2022-07-21 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-07-25 21:40:00","insp_carrier_name":"BGW TRUCKING","insp_carrier_street":"12986 GREENWAY CHASE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77072","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0890687","created_at":"2025-03-17T18:43:22.000000Z","updated_at":"2025-03-17T18:43:22.000000Z","inspection_violations":[{"id":1398745,"change_date":"2022-07-25 21:40:00","inspection_id":"76145584","insp_violation_id":"247296516","seq_no":"1","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"189950934","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:34.000000Z","updated_at":"2025-03-17T21:13:34.000000Z","normalized_code":"39395A"},{"id":1398746,"change_date":"2022-07-25 21:40:00","inspection_id":"76145584","insp_violation_id":"247296517","seq_no":"2","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"189950934","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:34.000000Z","updated_at":"2025-03-17T21:13:34.000000Z","normalized_code":"39617C"},{"id":1398747,"change_date":"2022-07-25 21:40:00","inspection_id":"76145584","insp_violation_id":"247296518","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"189950934","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:34.000000Z","updated_at":"2025-03-17T21:13:34.000000Z","normalized_code":"3939A"},{"id":1398748,"change_date":"2022-07-25 21:40:00","inspection_id":"76145584","insp_violation_id":"247296519","seq_no":"4","part_no":"393","part_no_section":"19","insp_viol_unit":"1","insp_unit_id":"189950934","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:34.000000Z","updated_at":"2025-03-17T21:13:34.000000Z","normalized_code":"39319"},{"id":1398749,"change_date":"2022-07-25 21:40:00","inspection_id":"76145584","insp_violation_id":"247296520","seq_no":"5","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"189950934","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:34.000000Z","updated_at":"2025-03-17T21:13:34.000000Z","normalized_code":"39311"},{"id":1398750,"change_date":"2022-07-25 21:40:00","inspection_id":"76145584","insp_violation_id":"247296521","seq_no":"6","part_no":"393","part_no_section":"75(a)(1)","insp_viol_unit":"1","insp_unit_id":"189950934","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:34.000000Z","updated_at":"2025-03-17T21:13:34.000000Z","normalized_code":"39375A1"}],"inspection_per_units":[{"id":1428877,"change_date":"2022-07-25 21:40:00","inspection_id":"76145584","insp_unit_id":"189950934","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"MXK5017","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M1AA13Y9XW106589","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:16:58.000000Z","updated_at":"2025-03-17T22:16:58.000000Z"}]},{"id":702567,"change_date":"2022-06-27 21:41:00","inspection_id":"75929710","dot_number":"2537675","report_state":"TX","report_number":"6C089DGB4S","insp_date":"2022-06-22 00:00:00","insp_start_time":"0817","insp_end_time":"0839","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0045 IN GALVESTON CO. (0-23","county_code_state":"TX","county_code":"167","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2022-06-27 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"4","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8695851","transaction_code":"A","transaction_date":"2022-06-27 00:00:00","upload_date":"2022-06-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02537675","upload_search_indicator":"M","census_search_date":"2022-06-27 21:41:00","snet_input_date":"2022-06-22 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-06-27 21:41:00","insp_carrier_name":"BGW TRUCKING","insp_carrier_street":"12986 GREENWAY CHASE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77072","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0890687","created_at":"2025-03-17T18:40:09.000000Z","updated_at":"2025-03-17T18:40:09.000000Z","inspection_violations":[{"id":1104238,"change_date":"2022-06-27 21:41:00","inspection_id":"75929710","insp_violation_id":"246745485","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"189485587","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:11.000000Z","updated_at":"2025-03-17T21:12:11.000000Z","normalized_code":"39378"},{"id":1104239,"change_date":"2022-06-27 21:41:00","inspection_id":"75929710","insp_violation_id":"246745486","seq_no":"2","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"189485587","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:11.000000Z","updated_at":"2025-03-17T21:12:11.000000Z","normalized_code":"39347E"},{"id":1104240,"change_date":"2022-06-27 21:41:00","inspection_id":"75929710","insp_violation_id":"246745487","seq_no":"3","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"189485587","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:11.000000Z","updated_at":"2025-03-17T21:12:11.000000Z","normalized_code":"39353B"},{"id":1104241,"change_date":"2022-06-27 21:41:00","inspection_id":"75929710","insp_violation_id":"246745488","seq_no":"4","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"189485587","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:11.000000Z","updated_at":"2025-03-17T21:12:11.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":1129417,"change_date":"2022-06-27 21:41:00","inspection_id":"75929710","insp_unit_id":"189485587","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"CV7","insp_unit_license":"GFF9108","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AG11Y43M006869","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:08.000000Z","updated_at":"2025-03-17T22:15:08.000000Z"}]},{"id":663799,"change_date":"2022-06-21 21:42:00","inspection_id":"75883947","dot_number":"2537675","report_state":"TX","report_number":"6BRF9DJM3T","insp_date":"2022-06-13 00:00:00","insp_start_time":"1528","insp_end_time":"1550","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"4600  S SAM 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":"Y","pen_cen_match":null,"final_status_date":"2022-06-21 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"8690181","transaction_code":"A","transaction_date":"2022-06-21 00:00:00","upload_date":"2022-06-21 00:00:00","upload_first_byte":"0","upload_dot_number":"02537675","upload_search_indicator":"M","census_search_date":"2022-06-21 21:42:00","snet_input_date":"2022-06-13 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-06-21 21:42:00","insp_carrier_name":"BGW TRUCKING","insp_carrier_street":"12986 GREENWAY CHASE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77072","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0890687","created_at":"2025-03-17T18:39:29.000000Z","updated_at":"2025-03-17T18:39:29.000000Z","inspection_violations":[{"id":1045061,"change_date":"2022-06-21 21:42:00","inspection_id":"75883947","insp_violation_id":"246631606","seq_no":"1","part_no":"393","part_no_section":"83(g)","insp_viol_unit":"1","insp_unit_id":"189388141","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:55.000000Z","updated_at":"2025-03-17T21:11:55.000000Z","normalized_code":"39383G"},{"id":1045062,"change_date":"2022-06-21 21:42:00","inspection_id":"75883947","insp_violation_id":"246631607","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"189388141","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:55.000000Z","updated_at":"2025-03-17T21:11:55.000000Z","normalized_code":"3939A"},{"id":1045063,"change_date":"2022-06-21 21:42:00","inspection_id":"75883947","insp_violation_id":"246631608","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"189388141","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:55.000000Z","updated_at":"2025-03-17T21:11:55.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":1067057,"change_date":"2022-06-21 21:42:00","inspection_id":"75883947","insp_unit_id":"189388141","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"GFF9108","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AG11Y43M006869","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:46.000000Z","updated_at":"2025-03-17T22:14:46.000000Z"}]},{"id":663350,"change_date":"2022-06-21 21:42:00","inspection_id":"75883436","dot_number":"2537675","report_state":"TX","report_number":"6BLC9DAWNB","insp_date":"2022-06-07 00:00:00","insp_start_time":"1213","insp_end_time":"1245","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"700  MANISON PKWY","county_code_state":"TX","county_code":"167","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2022-06-21 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"8689424","transaction_code":"A","transaction_date":"2022-06-21 00:00:00","upload_date":"2022-06-21 00:00:00","upload_first_byte":"0","upload_dot_number":"02537675","upload_search_indicator":"M","census_search_date":"2022-06-21 21:42:00","snet_input_date":"2022-06-07 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-06-21 21:42:00","insp_carrier_name":"BGW TRUCKING","insp_carrier_street":"12986 GREENWAY CHASE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77072","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0890687","created_at":"2025-03-17T18:39:29.000000Z","updated_at":"2025-03-17T18:39:29.000000Z","inspection_violations":[{"id":1043950,"change_date":"2022-06-21 21:42:00","inspection_id":"75883436","insp_violation_id":"246630088","seq_no":"1","part_no":"392","part_no_section":"82(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:55.000000Z","updated_at":"2025-03-17T21:11:55.000000Z","normalized_code":"39282A1"},{"id":1043951,"change_date":"2022-06-21 21:42:00","inspection_id":"75883436","insp_violation_id":"246630089","seq_no":"2","part_no":"390","part_no_section":"21(a)","insp_viol_unit":"1","insp_unit_id":"189387194","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:55.000000Z","updated_at":"2025-03-17T21:11:55.000000Z","normalized_code":"39021A"},{"id":1043952,"change_date":"2022-06-21 21:42:00","inspection_id":"75883436","insp_violation_id":"246630090","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"189387194","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:55.000000Z","updated_at":"2025-03-17T21:11:55.000000Z","normalized_code":"3939A"},{"id":1043953,"change_date":"2022-06-21 21:42:00","inspection_id":"75883436","insp_violation_id":"246630091","seq_no":"5","part_no":"396","part_no_section":null,"insp_viol_unit":"1","insp_unit_id":"189387194","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:55.000000Z","updated_at":"2025-03-17T21:11:55.000000Z","normalized_code":"396"}],"inspection_per_units":[{"id":1066282,"change_date":"2022-06-21 21:42:00","inspection_id":"75883436","insp_unit_id":"189387194","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"1568","insp_unit_license":"DRG2255","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKWDR9X8WR763153","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:46.000000Z","updated_at":"2025-03-17T22:14:46.000000Z"}]},{"id":673375,"change_date":"2022-06-22 21:40:00","inspection_id":"75895148","dot_number":"2537675","report_state":"TX","report_number":"6BIE9DBZ1K","insp_date":"2022-06-04 00:00:00","insp_start_time":"1404","insp_end_time":"1417","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"4600  SOUTH SAM HOUS","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"PICK UP 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":"2022-06-22 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8691868","transaction_code":"A","transaction_date":"2022-06-22 00:00:00","upload_date":"2022-06-22 00:00:00","upload_first_byte":"0","upload_dot_number":"02537675","upload_search_indicator":"M","census_search_date":"2022-06-22 21:40:00","snet_input_date":"2022-06-04 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-06-22 21:40:00","insp_carrier_name":"BGW TRUCKING","insp_carrier_street":"12986 GREENWAY CHASE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77072","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0890687","created_at":"2025-03-17T18:39:32.000000Z","updated_at":"2025-03-17T18:39:32.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1082272,"change_date":"2022-06-22 21:40:00","inspection_id":"75895148","insp_unit_id":"189411212","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":null,"insp_unit_license":"GFF9108","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AG11Y43M006869","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:51.000000Z","updated_at":"2025-03-17T22:14:51.000000Z"}]},{"id":485174,"change_date":"2022-06-10 21:41:00","inspection_id":"75671648","dot_number":"2537675","report_state":"TX","report_number":"6B2D9DGAGX","insp_date":"2022-05-19 00:00:00","insp_start_time":"1318","insp_end_time":"1405","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"FM-0528 IN GALVESTON CO. (692-","county_code_state":"TX","county_code":"167","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2022-05-25 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","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":"8666325","transaction_code":"C","transaction_date":"2022-06-10 00:00:00","upload_date":"2022-06-10 00:00:00","upload_first_byte":"0","upload_dot_number":"02537675","upload_search_indicator":"M","census_search_date":"2022-05-25 21:42:00","snet_input_date":"2022-05-19 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-05-25 21:42:00","insp_carrier_name":"BGW TRUCKING","insp_carrier_street":"12986 GREENWAY CHASE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77072","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0890687","created_at":"2025-03-17T18:36:18.000000Z","updated_at":"2025-03-17T18:36:18.000000Z","inspection_violations":[{"id":769740,"change_date":"2022-06-10 21:41:00","inspection_id":"75671648","insp_violation_id":"246384061","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"189183955","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:39.000000Z","updated_at":"2025-03-17T21:10:39.000000Z","normalized_code":"39617C"},{"id":769741,"change_date":"2022-06-10 21:41:00","inspection_id":"75671648","insp_violation_id":"246384062","seq_no":"2","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"189183955","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:39.000000Z","updated_at":"2025-03-17T21:10:39.000000Z","normalized_code":"39347E"},{"id":769742,"change_date":"2022-06-10 21:41:00","inspection_id":"75671648","insp_violation_id":"246384063","seq_no":"3","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"189183955","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:39.000000Z","updated_at":"2025-03-17T21:10:39.000000Z","normalized_code":"39353B"}],"inspection_per_units":[{"id":780306,"change_date":"2022-06-10 21:41:00","inspection_id":"75671648","insp_unit_id":"189183955","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"V-869","insp_unit_license":"GFF9108","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AG11Y43M006869","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:00.000000Z","updated_at":"2025-03-17T22:13:00.000000Z"}]},{"id":150497,"change_date":"2022-04-15 21:37:00","inspection_id":"75272455","dot_number":"2537675","report_state":"TX","report_number":"69XA9DGXM9","insp_date":"2022-04-08 00:00:00","insp_start_time":"1029","insp_end_time":"1056","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"5400  GENOA RED BLUF","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":"2022-04-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"8","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"8","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8617392","transaction_code":"C","transaction_date":"2022-04-15 00:00:00","upload_date":"2022-04-15 00:00:00","upload_first_byte":"0","upload_dot_number":"02537675","upload_search_indicator":"M","census_search_date":"2022-04-11 21:41:00","snet_input_date":"2022-04-08 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-04-11 21:41:00","insp_carrier_name":"BGW TRUCKING","insp_carrier_street":"12986 GREENWAY CHASE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77072","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0890687","created_at":"2025-03-17T18:30:10.000000Z","updated_at":"2025-03-17T18:30:10.000000Z","inspection_violations":[{"id":225484,"change_date":"2022-04-15 21:37:00","inspection_id":"75272455","insp_violation_id":"245195325","seq_no":"2","part_no":"393","part_no_section":"83(g)","insp_viol_unit":"1","insp_unit_id":"188183757","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:06.000000Z","updated_at":"2025-03-17T21:08:06.000000Z","normalized_code":"39383G"},{"id":225485,"change_date":"2022-04-15 21:37:00","inspection_id":"75272455","insp_violation_id":"245195326","seq_no":"3","part_no":"393","part_no_section":"55(c)(2)","insp_viol_unit":"1","insp_unit_id":"188183757","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:06.000000Z","updated_at":"2025-03-17T21:08:06.000000Z","normalized_code":"39355C2"},{"id":225486,"change_date":"2022-04-15 21:37:00","inspection_id":"75272455","insp_violation_id":"245195327","seq_no":"4","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"188183757","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:06.000000Z","updated_at":"2025-03-17T21:08:06.000000Z","normalized_code":"39345B2"},{"id":225487,"change_date":"2022-04-15 21:37:00","inspection_id":"75272455","insp_violation_id":"245195328","seq_no":"5","part_no":"393","part_no_section":"65(f)","insp_viol_unit":"1","insp_unit_id":"188183757","insp_violation_category_id":"18","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:06.000000Z","updated_at":"2025-03-17T21:08:06.000000Z","normalized_code":"39365F"},{"id":225488,"change_date":"2022-04-15 21:37:00","inspection_id":"75272455","insp_violation_id":"245195329","seq_no":"6","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"188183757","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:06.000000Z","updated_at":"2025-03-17T21:08:06.000000Z","normalized_code":"3965B"},{"id":225489,"change_date":"2022-04-15 21:37:00","inspection_id":"75272455","insp_violation_id":"245195330","seq_no":"7","part_no":"393","part_no_section":"100(a)","insp_viol_unit":"1","insp_unit_id":"188183757","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:08:06.000000Z","updated_at":"2025-03-17T21:08:06.000000Z","normalized_code":"393100A"},{"id":225490,"change_date":"2022-04-15 21:37:00","inspection_id":"75272455","insp_violation_id":"245195331","seq_no":"8","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"188183757","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:08:06.000000Z","updated_at":"2025-03-17T21:08:06.000000Z","normalized_code":"3963A1"},{"id":225491,"change_date":"2022-04-15 21:37:00","inspection_id":"75272455","insp_violation_id":"245195332","seq_no":"9","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"188183757","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:08:06.000000Z","updated_at":"2025-03-17T21:08:06.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":244137,"change_date":"2022-04-15 21:37:00","inspection_id":"75272455","insp_unit_id":"188183757","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"MACK","insp_unit_company":"CV7","insp_unit_license":"GFF9108","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1M2AG11Y43M006869","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:40.000000Z","updated_at":"2025-03-17T22:09:40.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/2537675\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/2537675\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/2537675\/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\/2537675\/inspections","per_page":100,"prev_page_url":null,"to":56,"total":56}