{"current_page":1,"data":[{"id":9403753,"change_date":"2025-08-13 21:39:00","inspection_id":"85483376","dot_number":"2788234","report_state":"TX","report_number":"77U99DIA68","insp_date":"2025-08-11 00:00:00","insp_start_time":"0904","insp_end_time":"0940","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"13500  EAST FWY","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-08-13 21:39: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":"9664474","transaction_code":"A","transaction_date":"2025-08-13 00:00:00","upload_date":"2025-08-13 00:00:00","upload_first_byte":"0","upload_dot_number":"02788234","upload_search_indicator":"M","census_search_date":"2025-08-13 21:39:00","snet_input_date":"2025-08-11 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-08-13 21:39:00","insp_carrier_name":"CE TRUCKING LLC","insp_carrier_street":"7015 WINFREE DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77087","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0908286","created_at":"2025-08-16T10:01:25.000000Z","updated_at":"2025-08-17T10:00:49.000000Z","inspection_violations":[{"id":15293215,"change_date":"2025-08-13 21:39:00","inspection_id":"85483376","insp_violation_id":"268009715","seq_no":"2","part_no":"393","part_no_section":"203C","insp_viol_unit":"1","insp_unit_id":"208381276","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-16T10:45:12.000000Z","updated_at":"2025-08-17T10:44:36.000000Z","normalized_code":"393203C"},{"id":15293216,"change_date":"2025-08-13 21:39:00","inspection_id":"85483376","insp_violation_id":"268009716","seq_no":"3","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"208381276","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-16T10:45:12.000000Z","updated_at":"2025-08-17T10:44:36.000000Z","normalized_code":"39347E"},{"id":15293217,"change_date":"2025-08-13 21:39:00","inspection_id":"85483376","insp_violation_id":"268009717","seq_no":"4","part_no":"393","part_no_section":"53B","insp_viol_unit":"1","insp_unit_id":"208381276","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-16T10:45:12.000000Z","updated_at":"2025-08-17T10:44:36.000000Z","normalized_code":"39353B"}],"inspection_per_units":[{"id":15498641,"change_date":"2025-08-13 21:39:00","inspection_id":"85483376","insp_unit_id":"208381276","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"30","insp_unit_license":"TBZ0164","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKADB9X97J171066","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-16T09:46:40.000000Z","updated_at":"2025-08-17T09:45:59.000000Z"}]},{"id":9486073,"change_date":"2025-08-25 21:40:00","inspection_id":"85569986","dot_number":"2788234","report_state":"TX","report_number":"76YE9DCJ08","insp_date":"2025-07-10 00:00:00","insp_start_time":"1444","insp_end_time":"1458","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"13  WAUGH 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":"2025-08-22 21:39: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":"9673546","transaction_code":"C","transaction_date":"2025-08-25 00:00:00","upload_date":"2025-08-25 00:00:00","upload_first_byte":"0","upload_dot_number":"02788234","upload_search_indicator":"M","census_search_date":"2025-08-22 21:39:00","snet_input_date":"2025-07-10 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-08-22 21:39:00","insp_carrier_name":"CE TRUCKING LLC","insp_carrier_street":"7015 WINFREE DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77087","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0908286","created_at":"2025-08-25T10:43:27.000000Z","updated_at":"2025-08-29T10:42:41.000000Z","inspection_violations":[{"id":15488312,"change_date":"2025-08-25 21:40:00","inspection_id":"85569986","insp_violation_id":"268235094","seq_no":"1","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"208570734","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-28T10:44:03.000000Z","updated_at":"2025-09-05T10:48:36.000000Z","normalized_code":"3939"},{"id":15488313,"change_date":"2025-08-25 21:40:00","inspection_id":"85569986","insp_violation_id":"268235095","seq_no":"2","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"208570734","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-28T10:44:03.000000Z","updated_at":"2025-09-05T10:48:36.000000Z","normalized_code":"3939"}],"inspection_per_units":[{"id":15669452,"change_date":"2025-08-25 21:40:00","inspection_id":"85569986","insp_unit_id":"208570734","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"32","insp_unit_license":"TSR8392","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDDB9XX5J071391","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-28T09:45:33.000000Z","updated_at":"2025-08-29T09:45:47.000000Z"}]},{"id":8864000,"change_date":"2025-06-10 21:41:00","inspection_id":"84914583","dot_number":"2788234","report_state":"TX","report_number":"75X99DKYH8","insp_date":"2025-06-03 00:00:00","insp_start_time":"0910","insp_end_time":"0940","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":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"SPRINT SAND","shipping_paper_number":"86292189","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":"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":"9602184","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":"02788234","upload_search_indicator":"M","census_search_date":"2025-06-10 21:41:00","snet_input_date":"2025-06-03 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-06-10 21:41:00","insp_carrier_name":"CE TRUCKING LLC","insp_carrier_street":"7015 WINFREE DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77087","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0908286","created_at":"2025-06-14T10:00:47.000000Z","updated_at":"2025-06-14T10:00:47.000000Z","inspection_violations":[{"id":14198696,"change_date":"2025-06-10 21:41:00","inspection_id":"84914583","insp_violation_id":"266764847","seq_no":"1","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"207316323","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-13T10:16:54.000000Z","updated_at":"2025-06-14T10:16:02.000000Z","normalized_code":"39617C"},{"id":14198697,"change_date":"2025-06-10 21:41:00","inspection_id":"84914583","insp_violation_id":"266764848","seq_no":"2","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"207316323","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-13T10:16:54.000000Z","updated_at":"2025-06-14T10:16:02.000000Z","normalized_code":"39378"},{"id":14198698,"change_date":"2025-06-10 21:41:00","inspection_id":"84914583","insp_violation_id":"266764849","seq_no":"3","part_no":"392","part_no_section":"2WC","insp_viol_unit":"1","insp_unit_id":"207316323","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-13T10:16:54.000000Z","updated_at":"2025-06-14T10:16:02.000000Z","normalized_code":"3922WC"},{"id":14198699,"change_date":"2025-06-10 21:41:00","inspection_id":"84914583","insp_violation_id":"266764850","seq_no":"4","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"207316323","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-13T10:16:54.000000Z","updated_at":"2025-06-14T10:16:02.000000Z","normalized_code":"39347E"},{"id":14198700,"change_date":"2025-06-10 21:41:00","inspection_id":"84914583","insp_violation_id":"266764851","seq_no":"5","part_no":"393","part_no_section":"47E","insp_viol_unit":"1","insp_unit_id":"207316323","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-13T10:16:54.000000Z","updated_at":"2025-06-14T10:16:02.000000Z","normalized_code":"39347E"},{"id":14198701,"change_date":"2025-06-10 21:41:00","inspection_id":"84914583","insp_violation_id":"266764852","seq_no":"6","part_no":"393","part_no_section":"53B","insp_viol_unit":"1","insp_unit_id":"207316323","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-13T10:16:54.000000Z","updated_at":"2025-06-14T10:16:02.000000Z","normalized_code":"39353B"},{"id":14198702,"change_date":"2025-06-10 21:41:00","inspection_id":"84914583","insp_violation_id":"266764853","seq_no":"7","part_no":"396","part_no_section":"3A1BOS","insp_viol_unit":"1","insp_unit_id":"207316323","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-06-13T10:16:54.000000Z","updated_at":"2025-06-14T10:16:02.000000Z","normalized_code":"3963A1BOS"}],"inspection_per_units":[{"id":14516157,"change_date":"2025-06-10 21:41:00","inspection_id":"84914583","insp_unit_id":"207316323","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"30","insp_unit_license":"TBZ0164","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKADB9X97J171066","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-13T09:45:45.000000Z","updated_at":"2025-06-14T09:45:51.000000Z"}]},{"id":8837827,"change_date":"2025-06-06 21:40:00","inspection_id":"84886682","dot_number":"2788234","report_state":"TX","report_number":"75SH9DBI16","insp_date":"2025-05-29 00:00:00","insp_start_time":"1714","insp_end_time":"1735","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0099 IN HARRIS CO. (698-750","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-06-06 21:40: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":"9600659","transaction_code":"A","transaction_date":"2025-06-06 00:00:00","upload_date":"2025-06-06 00:00:00","upload_first_byte":"0","upload_dot_number":"02788234","upload_search_indicator":"M","census_search_date":"2025-06-06 21:40:00","snet_input_date":"2025-05-29 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-06-06 21:40:00","insp_carrier_name":"CE TRUCKING LLC","insp_carrier_street":"7015 WINFREE DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77087","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0908286","created_at":"2025-06-09T10:01:19.000000Z","updated_at":"2025-06-10T10:00:38.000000Z","inspection_violations":[{"id":14150333,"change_date":"2025-06-06 21:40:00","inspection_id":"84886682","insp_violation_id":"266709528","seq_no":"2","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"207266228","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-09T10:16:51.000000Z","updated_at":"2025-06-10T10:16:08.000000Z","normalized_code":"39311"},{"id":14150334,"change_date":"2025-06-06 21:40:00","inspection_id":"84886682","insp_violation_id":"266709529","seq_no":"3","part_no":"393","part_no_section":"55D1","insp_viol_unit":"1","insp_unit_id":"207266228","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-09T10:16:51.000000Z","updated_at":"2025-06-10T10:16:08.000000Z","normalized_code":"39355D1"}],"inspection_per_units":[{"id":14470446,"change_date":"2025-06-06 21:40:00","inspection_id":"84886682","insp_unit_id":"207266228","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"TSR8392","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDDB9XX5J071391","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-09T09:46:19.000000Z","updated_at":"2025-06-10T09:45:51.000000Z"}]},{"id":8648551,"change_date":"2025-05-15 21:44:00","inspection_id":"84686538","dot_number":"2788234","report_state":"TX","report_number":"75C79DCP0A","insp_date":"2025-05-13 00:00:00","insp_start_time":"0712","insp_end_time":"0740","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0045 IN HARRIS CO. (24-72)","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-15 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"5","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9578608","transaction_code":"A","transaction_date":"2025-05-15 00:00:00","upload_date":"2025-05-15 00:00:00","upload_first_byte":"0","upload_dot_number":"02788234","upload_search_indicator":"M","census_search_date":"2025-05-15 21:44:00","snet_input_date":"2025-05-13 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-05-15 21:44:00","insp_carrier_name":"CE TRUCKING LLC","insp_carrier_street":"7015 WINFREE DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77087","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0908286","created_at":"2025-05-18T10:04:40.000000Z","updated_at":"2025-05-19T10:06:32.000000Z","inspection_violations":[{"id":13760451,"change_date":"2025-05-15 21:44:00","inspection_id":"84686538","insp_violation_id":"266258985","seq_no":"1","part_no":"390","part_no_section":"21(a)","insp_viol_unit":"1","insp_unit_id":"206889211","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-18T10:32:08.000000Z","updated_at":"2025-05-19T10:32:25.000000Z","normalized_code":"39021A"},{"id":13760452,"change_date":"2025-05-15 21:44:00","inspection_id":"84686538","insp_violation_id":"266258986","seq_no":"2","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"206889211","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-18T10:32:08.000000Z","updated_at":"2025-05-19T10:32:25.000000Z","normalized_code":"39378"},{"id":13760453,"change_date":"2025-05-15 21:44:00","inspection_id":"84686538","insp_violation_id":"266258987","seq_no":"3","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"206889211","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-18T10:32:08.000000Z","updated_at":"2025-05-19T10:32:25.000000Z","normalized_code":"3939"},{"id":13760454,"change_date":"2025-05-15 21:44:00","inspection_id":"84686538","insp_violation_id":"266258988","seq_no":"4","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"206889211","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-18T10:32:08.000000Z","updated_at":"2025-05-19T10:32:25.000000Z","normalized_code":"3939"},{"id":13760455,"change_date":"2025-05-15 21:44:00","inspection_id":"84686538","insp_violation_id":"266258989","seq_no":"5","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"206889211","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-18T10:32:08.000000Z","updated_at":"2025-05-19T10:32:25.000000Z","normalized_code":"3939"}],"inspection_per_units":[{"id":14124535,"change_date":"2025-05-15 21:44:00","inspection_id":"84686538","insp_unit_id":"206889211","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"29","insp_unit_license":"WBB4137","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKAD29X6KS537732","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-18T09:50:26.000000Z","updated_at":"2025-05-19T09:52:30.000000Z"}]},{"id":8690843,"change_date":"2025-05-20 21:41:00","inspection_id":"84731130","dot_number":"2788234","report_state":"TX","report_number":"75BF9DBC1F","insp_date":"2025-05-12 00:00:00","insp_start_time":"1535","insp_end_time":"1608","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"15126  CYPRESS N HOU","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"SPRING SAND & CLAY","shipping_paper_number":"2788234","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-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"0","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":"9583917","transaction_code":"A","transaction_date":"2025-05-20 00:00:00","upload_date":"2025-05-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02788234","upload_search_indicator":"M","census_search_date":"2025-05-20 21:41:00","snet_input_date":"2025-05-12 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-05-20 21:41:00","insp_carrier_name":"CE TRUCKING LLC","insp_carrier_street":"7015 WINFREE DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77087","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0908286","created_at":"2025-05-23T10:04:24.000000Z","updated_at":"2025-05-24T10:06:01.000000Z","inspection_violations":[{"id":13848025,"change_date":"2025-05-20 21:41:00","inspection_id":"84731130","insp_violation_id":"266357048","seq_no":"1","part_no":"393","part_no_section":"55D1","insp_viol_unit":"1","insp_unit_id":"206970748","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-23T10:37:10.000000Z","updated_at":"2025-05-24T10:26:44.000000Z","normalized_code":"39355D1"},{"id":13848026,"change_date":"2025-05-20 21:41:00","inspection_id":"84731130","insp_violation_id":"266357049","seq_no":"2","part_no":"393","part_no_section":"75A3","insp_viol_unit":"1","insp_unit_id":"206970748","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-05-23T10:37:10.000000Z","updated_at":"2025-05-24T10:26:44.000000Z","normalized_code":"39375A3"},{"id":13848027,"change_date":"2025-05-20 21:41:00","inspection_id":"84731130","insp_violation_id":"266357050","seq_no":"3","part_no":"396","part_no_section":"5B","insp_viol_unit":"1","insp_unit_id":"206970748","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-23T10:37:10.000000Z","updated_at":"2025-05-24T10:26:45.000000Z","normalized_code":"3965B"},{"id":13848028,"change_date":"2025-05-20 21:41:00","inspection_id":"84731130","insp_violation_id":"266357051","seq_no":"4","part_no":"392","part_no_section":"2WC","insp_viol_unit":"1","insp_unit_id":"206970748","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-23T10:37:10.000000Z","updated_at":"2025-05-24T10:26:45.000000Z","normalized_code":"3922WC"}],"inspection_per_units":[{"id":14200052,"change_date":"2025-05-20 21:41:00","inspection_id":"84731130","insp_unit_id":"206970748","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"29","insp_unit_license":"WDD9472","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDDB9X46J128458","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-23T09:49:15.000000Z","updated_at":"2025-05-24T09:51:32.000000Z"}]},{"id":8632863,"change_date":"2025-05-14 21:42:00","inspection_id":"84670049","dot_number":"2788234","report_state":"TX","report_number":"75489DNF09","insp_date":"2025-05-05 00:00:00","insp_start_time":"0816","insp_end_time":"0843","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"100 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-05-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"9577236","transaction_code":"A","transaction_date":"2025-05-14 00:00:00","upload_date":"2025-05-14 00:00:00","upload_first_byte":"0","upload_dot_number":"02788234","upload_search_indicator":"M","census_search_date":"2025-05-14 21:42:00","snet_input_date":"2025-05-05 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-05-14 21:42:00","insp_carrier_name":"CE TRUCKING LLC","insp_carrier_street":"7015 WINFREE DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77087","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0908286","created_at":"2025-05-17T10:05:22.000000Z","updated_at":"2025-05-18T10:06:18.000000Z","inspection_violations":[{"id":13728472,"change_date":"2025-05-14 21:42:00","inspection_id":"84670049","insp_violation_id":"266223167","seq_no":"1","part_no":"392","part_no_section":"2WC","insp_viol_unit":"1","insp_unit_id":"206859015","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-18T10:27:25.000000Z","updated_at":"2025-05-18T10:34:00.000000Z","normalized_code":"3922WC"},{"id":13728473,"change_date":"2025-05-14 21:42:00","inspection_id":"84670049","insp_violation_id":"266223168","seq_no":"3","part_no":"393","part_no_section":"45B2UV","insp_viol_unit":"1","insp_unit_id":"206859015","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-18T10:27:25.000000Z","updated_at":"2025-05-18T10:34:00.000000Z","normalized_code":"39345B2UV"},{"id":13728474,"change_date":"2025-05-14 21:42:00","inspection_id":"84670049","insp_violation_id":"266223169","seq_no":"4","part_no":"396","part_no_section":"3A1-TC","insp_viol_unit":"1","insp_unit_id":"206859015","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-05-18T10:27:25.000000Z","updated_at":"2025-05-18T10:34:00.000000Z","normalized_code":"3963A1TC"},{"id":13728475,"change_date":"2025-05-14 21:42:00","inspection_id":"84670049","insp_violation_id":"266223170","seq_no":"5","part_no":"393","part_no_section":"45DLUV","insp_viol_unit":"1","insp_unit_id":"206859015","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-18T10:27:25.000000Z","updated_at":"2025-05-18T10:34:00.000000Z","normalized_code":"39345DLUV"}],"inspection_per_units":[{"id":14096597,"change_date":"2025-05-14 21:42:00","inspection_id":"84670049","insp_unit_id":"206859015","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"WDD9472","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDDB9X46J128458","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-17T09:49:19.000000Z","updated_at":"2025-05-18T09:51:55.000000Z"}]},{"id":8321130,"change_date":"2025-04-08 21:40:00","inspection_id":"84341727","dot_number":"2788234","report_state":"TX","report_number":"748B9DHPDN","insp_date":"2025-04-03 00:00:00","insp_start_time":"1146","insp_end_time":"1210","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-04-08 21:40: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":"9543627","transaction_code":"A","transaction_date":"2025-04-08 00:00:00","upload_date":"2025-04-08 00:00:00","upload_first_byte":"0","upload_dot_number":"02788234","upload_search_indicator":"M","census_search_date":"2025-04-08 21:40:00","snet_input_date":"2025-04-03 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-04-08 21:40:00","insp_carrier_name":"CE TRUCKING LLC","insp_carrier_street":"7015 WINFREE DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77087","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0908286","created_at":"2025-04-11T10:12:23.000000Z","updated_at":"2025-04-12T10:22:26.000000Z","inspection_violations":[{"id":13095589,"change_date":"2025-04-08 21:40:00","inspection_id":"84341727","insp_violation_id":"265501234","seq_no":"1","part_no":"393","part_no_section":"82","insp_viol_unit":"1","insp_unit_id":"206206278","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-11T10:40:39.000000Z","updated_at":"2025-04-11T10:49:16.000000Z","normalized_code":"39382"},{"id":13095590,"change_date":"2025-04-08 21:40:00","inspection_id":"84341727","insp_violation_id":"265501235","seq_no":"2","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"206206278","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-11T10:40:39.000000Z","updated_at":"2025-04-11T10:49:16.000000Z","normalized_code":"39378"}],"inspection_per_units":[{"id":13495554,"change_date":"2025-04-08 21:40:00","inspection_id":"84341727","insp_unit_id":"206206278","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"TSR8391","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKAD69X8SR662455","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-11T10:06:05.000000Z","updated_at":"2025-04-12T10:01:14.000000Z"}]},{"id":8229096,"change_date":"2025-03-27 21:42:00","inspection_id":"84244865","dot_number":"2788234","report_state":"TX","report_number":"73ZC9DDA3R","insp_date":"2025-03-25 00:00:00","insp_start_time":"1224","insp_end_time":"1236","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"2000  BAYPORT BLVD","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-03-27 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"60000","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":"9533865","transaction_code":"A","transaction_date":"2025-03-27 00:00:00","upload_date":"2025-03-27 00:00:00","upload_first_byte":"0","upload_dot_number":"02788234","upload_search_indicator":"M","census_search_date":"2025-03-27 21:42:00","snet_input_date":"2025-03-25 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-03-27 21:42:00","insp_carrier_name":"CE TRUCKING LLC","insp_carrier_street":"7015 WINFREE DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77087","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0908286","created_at":"2025-03-30T10:38:47.000000Z","updated_at":"2025-03-31T10:31:00.000000Z","inspection_violations":[{"id":12913860,"change_date":"2025-03-27 21:42:00","inspection_id":"84244865","insp_violation_id":"265294967","seq_no":"1","part_no":"396","part_no_section":"5B","insp_viol_unit":"1","insp_unit_id":"206028919","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-29T10:53:55.000000Z","updated_at":"2025-03-31T10:55:58.000000Z","normalized_code":"3965B"},{"id":12913861,"change_date":"2025-03-27 21:42:00","inspection_id":"84244865","insp_violation_id":"265294968","seq_no":"2","part_no":"393","part_no_section":"45B2PC","insp_viol_unit":"1","insp_unit_id":"206028919","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-29T10:53:55.000000Z","updated_at":"2025-03-31T10:55:58.000000Z","normalized_code":"39345B2PC"},{"id":12913862,"change_date":"2025-03-27 21:42:00","inspection_id":"84244865","insp_violation_id":"265294969","seq_no":"3","part_no":"396","part_no_section":"3A1B","insp_viol_unit":"1","insp_unit_id":"206028919","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-29T10:53:55.000000Z","updated_at":"2025-03-31T10:55:58.000000Z","normalized_code":"3963A1B"}],"inspection_per_units":[{"id":13312086,"change_date":"2025-03-27 21:42:00","inspection_id":"84244865","insp_unit_id":"206028919","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"28","insp_unit_license":"VCL9043","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKADB9X8MS555135","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-30T10:27:36.000000Z","updated_at":"2025-03-31T10:08:10.000000Z"}]},{"id":8257791,"change_date":"2025-03-31 21:41:00","inspection_id":"84275165","dot_number":"2788234","report_state":"TX","report_number":"73VA9DTG9C","insp_date":"2025-03-21 00:00:00","insp_start_time":"1033","insp_end_time":"1120","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0146 IN GALVESTON CO. (502-","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":"OPEN","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-03-31 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"9536268","transaction_code":"A","transaction_date":"2025-03-31 00:00:00","upload_date":"2025-03-31 00:00:00","upload_first_byte":"0","upload_dot_number":"02788234","upload_search_indicator":"M","census_search_date":"2025-03-31 21:41:00","snet_input_date":"2025-03-21 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-03-31 21:41:00","insp_carrier_name":"CE TRUCKING LLC","insp_carrier_street":"7015 WINFREE DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77087","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0908286","created_at":"2025-04-03T10:04:37.000000Z","updated_at":"2025-04-04T10:19:51.000000Z","inspection_violations":[{"id":12970752,"change_date":"2025-03-31 21:41:00","inspection_id":"84275165","insp_violation_id":"265359549","seq_no":"1","part_no":"393","part_no_section":"55D1","insp_viol_unit":"1","insp_unit_id":"206084844","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-03T10:29:54.000000Z","updated_at":"2025-04-04T10:42:42.000000Z","normalized_code":"39355D1"},{"id":12970753,"change_date":"2025-03-31 21:41:00","inspection_id":"84275165","insp_violation_id":"265359550","seq_no":"2","part_no":"396","part_no_section":"5B-HLOW","insp_viol_unit":"1","insp_unit_id":"206084844","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-03T10:29:54.000000Z","updated_at":"2025-04-04T10:42:42.000000Z","normalized_code":"3965BHLOW"},{"id":12970754,"change_date":"2025-03-31 21:41:00","inspection_id":"84275165","insp_violation_id":"265359551","seq_no":"4","part_no":"393","part_no_section":"45","insp_viol_unit":"1","insp_unit_id":"206084844","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-04-03T10:29:54.000000Z","updated_at":"2025-04-04T10:42:42.000000Z","normalized_code":"39345"}],"inspection_per_units":[{"id":13363559,"change_date":"2025-03-31 21:41:00","inspection_id":"84275165","insp_unit_id":"206084844","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"29","insp_unit_license":"WDD9472","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDDB9X46J128458","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-03T10:00:27.000000Z","updated_at":"2025-04-04T10:03:03.000000Z"}]},{"id":8157091,"change_date":"2025-03-19 21:41:00","inspection_id":"84169079","dot_number":"2788234","report_state":"TX","report_number":"73LC9DDA39","insp_date":"2025-03-11 00:00:00","insp_start_time":"1208","insp_end_time":"1222","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"3300  BAYPORT BLVD","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-03-19 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"50000","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":"9525315","transaction_code":"A","transaction_date":"2025-03-19 00:00:00","upload_date":"2025-03-19 00:00:00","upload_first_byte":"0","upload_dot_number":"02788234","upload_search_indicator":"M","census_search_date":"2025-03-19 21:41:00","snet_input_date":"2025-03-11 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-03-19 21:41:00","insp_carrier_name":"CE TRUCKING LLC","insp_carrier_street":"7015 WINFREE DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77087","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0908286","created_at":"2025-03-22T10:35:34.000000Z","updated_at":"2025-03-23T10:50:42.000000Z","inspection_violations":[{"id":12770365,"change_date":"2025-03-19 21:41:00","inspection_id":"84169079","insp_violation_id":"265131270","seq_no":"1","part_no":"393","part_no_section":"47B","insp_viol_unit":"1","insp_unit_id":"205882690","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-22T10:51:45.000000Z","updated_at":"2025-03-22T11:08:30.000000Z","normalized_code":"39347B"},{"id":12770366,"change_date":"2025-03-19 21:41:00","inspection_id":"84169079","insp_violation_id":"265131271","seq_no":"2","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"205882690","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-22T10:51:45.000000Z","updated_at":"2025-03-22T11:08:30.000000Z","normalized_code":"3939"},{"id":12770367,"change_date":"2025-03-19 21:41:00","inspection_id":"84169079","insp_violation_id":"265131272","seq_no":"3","part_no":"396","part_no_section":"5B","insp_viol_unit":"1","insp_unit_id":"205882690","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-22T10:51:45.000000Z","updated_at":"2025-03-22T11:08:30.000000Z","normalized_code":"3965B"},{"id":12770368,"change_date":"2025-03-19 21:41:00","inspection_id":"84169079","insp_violation_id":"265131273","seq_no":"4","part_no":"396","part_no_section":"3A1","insp_viol_unit":"1","insp_unit_id":"205882690","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-22T10:51:45.000000Z","updated_at":"2025-03-22T11:08:30.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":13177964,"change_date":"2025-03-19 21:41:00","inspection_id":"84169079","insp_unit_id":"205882690","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"33","insp_unit_license":"TSR8391","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKAD69X8SR662455","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-22T10:07:25.000000Z","updated_at":"2025-03-23T10:04:10.000000Z"}]},{"id":7221688,"change_date":"2024-11-18 21:41:00","inspection_id":"83185842","dot_number":"2788234","report_state":"TX","report_number":"70689DAWJV","insp_date":"2024-11-08 00:00:00","insp_start_time":"0812","insp_end_time":"0831","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":"2024-11-18 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"50000","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":"9429379","transaction_code":"A","transaction_date":"2024-11-18 00:00:00","upload_date":"2024-11-18 00:00:00","upload_first_byte":"0","upload_dot_number":"02788234","upload_search_indicator":"M","census_search_date":"2024-11-18 21:41:00","snet_input_date":"2024-11-08 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-11-18 21:41:00","insp_carrier_name":"CE TRUCKING LLC","insp_carrier_street":"7015 WINFREE DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77087","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0908286","created_at":"2025-03-17T20:46:47.000000Z","updated_at":"2025-03-17T20:46:47.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11648743,"change_date":"2024-11-18 21:41:00","inspection_id":"83185842","insp_unit_id":"203937672","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"TSR8391","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKAD69X8SR662455","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:43:42.000000Z","updated_at":"2025-03-17T23:43:42.000000Z"}]},{"id":7016374,"change_date":"2024-10-22 21:42:00","inspection_id":"82968219","dot_number":"2788234","report_state":"TX","report_number":"6ZLF9DTG4L","insp_date":"2024-10-18 00:00:00","insp_start_time":"1504","insp_end_time":"1531","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":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"OPEN","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-10-22 21:42: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":"9408052","transaction_code":"A","transaction_date":"2024-10-22 00:00:00","upload_date":"2024-10-22 00:00:00","upload_first_byte":"0","upload_dot_number":"02788234","upload_search_indicator":"M","census_search_date":"2024-10-22 21:42:00","snet_input_date":"2024-10-18 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-10-22 21:42:00","insp_carrier_name":"CE TRUCKING LLC","insp_carrier_street":"7015 WINFREE DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77087","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0908286","created_at":"2025-03-17T20:42:18.000000Z","updated_at":"2025-03-17T20:42:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11316828,"change_date":"2024-10-22 21:42:00","inspection_id":"82968219","insp_unit_id":"203529712","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"28","insp_unit_license":"VCL9043","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKADB9X8MS555135","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:40:11.000000Z","updated_at":"2025-03-17T23:40:11.000000Z"}]},{"id":7016055,"change_date":"2024-10-23 21:42:00","inspection_id":"82967886","dot_number":"2788234","report_state":"TX","report_number":"6ZKB9DGA4Y","insp_date":"2024-10-17 00:00:00","insp_start_time":"1102","insp_end_time":"1131","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":"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-22 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":"9407906","transaction_code":"C","transaction_date":"2024-10-23 00:00:00","upload_date":"2024-10-23 00:00:00","upload_first_byte":"0","upload_dot_number":"02788234","upload_search_indicator":"M","census_search_date":"2024-10-22 21:42:00","snet_input_date":"2024-10-17 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-10-22 21:42:00","insp_carrier_name":"CE TRUCKING LLC","insp_carrier_street":"7015 WINFREE DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77087","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0908286","created_at":"2025-03-17T20:42:18.000000Z","updated_at":"2025-03-17T20:42:18.000000Z","inspection_violations":[{"id":10949412,"change_date":"2024-10-23 21:42:00","inspection_id":"82967886","insp_violation_id":"262518853","seq_no":"1","part_no":"393","part_no_section":"203A","insp_viol_unit":"1","insp_unit_id":"203551147","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:06.000000Z","updated_at":"2025-03-17T21:59:06.000000Z","normalized_code":"393203A"}],"inspection_per_units":[{"id":11316297,"change_date":"2024-10-23 21:42:00","inspection_id":"82967886","insp_unit_id":"203551147","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"V-081","insp_unit_license":"HMV5333","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKADU9X5YJ834081","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:40:11.000000Z","updated_at":"2025-03-17T23:40:11.000000Z"}]},{"id":7073900,"change_date":"2024-10-29 21:42:00","inspection_id":"83029225","dot_number":"2788234","report_state":"TX","report_number":"6ZK99DAWIO","insp_date":"2024-10-17 00:00:00","insp_start_time":"0955","insp_end_time":"1018","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"300  IH 45 FWY","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":"2024-10-29 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"48000","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":"9413396","transaction_code":"A","transaction_date":"2024-10-29 00:00:00","upload_date":"2024-10-29 00:00:00","upload_first_byte":"0","upload_dot_number":"02788234","upload_search_indicator":"M","census_search_date":"2024-10-29 21:42:00","snet_input_date":"2024-10-17 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-10-29 21:42:00","insp_carrier_name":"CE TRUCKING LLC","insp_carrier_street":"7015 WINFREE DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77087","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0908286","created_at":"2025-03-17T20:43:28.000000Z","updated_at":"2025-03-17T20:43:28.000000Z","inspection_violations":[{"id":11043235,"change_date":"2024-10-29 21:42:00","inspection_id":"83029225","insp_violation_id":"262620705","seq_no":"1","part_no":"393","part_no_section":"209D","insp_viol_unit":"1","insp_unit_id":"203642297","insp_violation_category_id":"21","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:59:36.000000Z","updated_at":"2025-03-17T21:59:36.000000Z","normalized_code":"393209D"},{"id":11043236,"change_date":"2024-10-29 21:42:00","inspection_id":"83029225","insp_violation_id":"262620706","seq_no":"2","part_no":"396","part_no_section":"5B","insp_viol_unit":"1","insp_unit_id":"203642297","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:36.000000Z","updated_at":"2025-03-17T21:59:36.000000Z","normalized_code":"3965B"},{"id":11043237,"change_date":"2024-10-29 21:42:00","inspection_id":"83029225","insp_violation_id":"262620707","seq_no":"3","part_no":"396","part_no_section":"3A1B","insp_viol_unit":"1","insp_unit_id":"203642297","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:36.000000Z","updated_at":"2025-03-17T21:59:36.000000Z","normalized_code":"3963A1B"},{"id":11043238,"change_date":"2024-10-29 21:42:00","inspection_id":"83029225","insp_violation_id":"262620708","seq_no":"4","part_no":"393","part_no_section":"51","insp_viol_unit":"1","insp_unit_id":"203642297","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:36.000000Z","updated_at":"2025-03-17T21:59:36.000000Z","normalized_code":"39351"},{"id":11043239,"change_date":"2024-10-29 21:42:00","inspection_id":"83029225","insp_violation_id":"262620709","seq_no":"5","part_no":"393","part_no_section":"9H","insp_viol_unit":"1","insp_unit_id":"203642297","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:36.000000Z","updated_at":"2025-03-17T21:59:36.000000Z","normalized_code":"3939H"},{"id":11043240,"change_date":"2024-10-29 21:42:00","inspection_id":"83029225","insp_violation_id":"262620710","seq_no":"6","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"203642297","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:36.000000Z","updated_at":"2025-03-17T21:59:36.000000Z","normalized_code":"3939"},{"id":11043241,"change_date":"2024-10-29 21:42:00","inspection_id":"83029225","insp_violation_id":"262620711","seq_no":"7","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"203642297","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:36.000000Z","updated_at":"2025-03-17T21:59:36.000000Z","normalized_code":"3922RG"}],"inspection_per_units":[{"id":11408518,"change_date":"2024-10-29 21:42:00","inspection_id":"83029225","insp_unit_id":"203642297","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"VMC4219","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKAD29X6KS537732","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:41:07.000000Z","updated_at":"2025-03-17T23:41:07.000000Z"}]},{"id":6819297,"change_date":"2024-09-26 21:40:00","inspection_id":"82758865","dot_number":"2788234","report_state":"TX","report_number":"6YQ99DGA3S","insp_date":"2024-09-17 00:00:00","insp_start_time":"0905","insp_end_time":"0942","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-09-25 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":"9385878","transaction_code":"C","transaction_date":"2024-09-26 00:00:00","upload_date":"2024-09-26 00:00:00","upload_first_byte":"0","upload_dot_number":"02788234","upload_search_indicator":"M","census_search_date":"2024-09-25 21:41:00","snet_input_date":"2024-09-17 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-09-25 21:41:00","insp_carrier_name":"CE TRUCKING LLC","insp_carrier_street":"7015 WINFREE DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77087","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0908286","created_at":"2025-03-17T20:38:15.000000Z","updated_at":"2025-03-17T20:38:15.000000Z","inspection_violations":[{"id":10619043,"change_date":"2024-09-26 21:40:00","inspection_id":"82758865","insp_violation_id":"262054159","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"203149006","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:23.000000Z","updated_at":"2025-03-17T21:57:23.000000Z","normalized_code":"39378"},{"id":10619044,"change_date":"2024-09-26 21:40:00","inspection_id":"82758865","insp_violation_id":"262054160","seq_no":"2","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"203149006","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:23.000000Z","updated_at":"2025-03-17T21:57:23.000000Z","normalized_code":"39311"},{"id":10619045,"change_date":"2024-09-26 21:40:00","inspection_id":"82758865","insp_violation_id":"262054161","seq_no":"3","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"203149006","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:57:23.000000Z","updated_at":"2025-03-17T21:57:23.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":10996869,"change_date":"2024-09-26 21:40:00","inspection_id":"82758865","insp_unit_id":"203149006","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"V-135","insp_unit_license":"VCL9043","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKADB9X8MS555135","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:54.000000Z","updated_at":"2025-03-17T23:36:54.000000Z"}]},{"id":6738544,"change_date":"2024-09-16 21:43:00","inspection_id":"82672572","dot_number":"2788234","report_state":"TX","report_number":"V241530179","insp_date":"2024-09-12 00:00:00","insp_start_time":"1512","insp_end_time":"1536","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"14811 IH45 SB","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CE TRUCKING LLC","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-09-16 21:43: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":"9378032","transaction_code":"A","transaction_date":"2024-09-16 00:00:00","upload_date":"2024-09-16 00:00:00","upload_first_byte":"0","upload_dot_number":"02788234","upload_search_indicator":"M","census_search_date":"2024-09-16 21:43:00","snet_input_date":"2024-09-12 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-09-16 21:43:00","insp_carrier_name":"CE TRUCKING LLC","insp_carrier_street":"7015 WINFREE DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77087","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0908286","created_at":"2025-03-17T20:36:34.000000Z","updated_at":"2025-03-17T20:36:34.000000Z","inspection_violations":[{"id":10492796,"change_date":"2024-09-16 21:43:00","inspection_id":"82672572","insp_violation_id":"261833066","seq_no":"1","part_no":"393","part_no_section":"203(c)","insp_viol_unit":"1","insp_unit_id":"202950756","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:48.000000Z","updated_at":"2025-03-17T21:56:48.000000Z","normalized_code":"393203C"},{"id":10492797,"change_date":"2024-09-16 21:43:00","inspection_id":"82672572","insp_violation_id":"261833067","seq_no":"2","part_no":"393","part_no_section":"83(g)","insp_viol_unit":"1","insp_unit_id":"202950756","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:48.000000Z","updated_at":"2025-03-17T21:56:48.000000Z","normalized_code":"39383G"}],"inspection_per_units":[{"id":10866115,"change_date":"2024-09-16 21:43:00","inspection_id":"82672572","insp_unit_id":"202950756","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"33","insp_unit_license":"TSR8391","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKAD69X8SR662455","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:35:34.000000Z","updated_at":"2025-03-17T23:35:34.000000Z"}]},{"id":6540603,"change_date":"2024-08-23 21:41:00","inspection_id":"82461849","dot_number":"2788234","report_state":"TX","report_number":"V241522289","insp_date":"2024-08-21 00:00:00","insp_start_time":"0635","insp_end_time":"0658","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH45 SB @ FM 518","county_code_state":"TX","county_code":"167","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"XX","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":"2024-08-22 21:43: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":"9358233","transaction_code":"C","transaction_date":"2024-08-23 00:00:00","upload_date":"2024-08-23 00:00:00","upload_first_byte":"0","upload_dot_number":"02788234","upload_search_indicator":"M","census_search_date":"2024-08-22 21:43:00","snet_input_date":"2024-08-21 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-08-22 21:43:00","insp_carrier_name":"CE TRUCKING LLC","insp_carrier_street":"7015 WINFREE DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77087","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0908286","created_at":"2025-03-17T20:32:44.000000Z","updated_at":"2025-03-17T20:32:44.000000Z","inspection_violations":[{"id":10161590,"change_date":"2024-08-23 21:41:00","inspection_id":"82461849","insp_violation_id":"261379725","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202559368","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:12.000000Z","updated_at":"2025-03-17T21:55:12.000000Z","normalized_code":"3939A"},{"id":10161591,"change_date":"2024-08-23 21:41:00","inspection_id":"82461849","insp_violation_id":"261379726","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"202559368","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:12.000000Z","updated_at":"2025-03-17T21:55:12.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10543940,"change_date":"2024-08-23 21:41:00","inspection_id":"82461849","insp_unit_id":"202559368","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"32","insp_unit_license":"TSR8392","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDDB9XX5J071391","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:32:11.000000Z","updated_at":"2025-03-17T23:32:11.000000Z"}]},{"id":6518025,"change_date":"2024-08-20 21:43:00","inspection_id":"82437857","dot_number":"2788234","report_state":"TX","report_number":"V241506254","insp_date":"2024-08-15 00:00:00","insp_start_time":"0637","insp_end_time":"0703","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH45 SB @ FM 518","county_code_state":"TX","county_code":"167","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CE TRUCKING LLC","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-08-20 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"54900","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":"9355915","transaction_code":"A","transaction_date":"2024-08-20 00:00:00","upload_date":"2024-08-20 00:00:00","upload_first_byte":"0","upload_dot_number":"02788234","upload_search_indicator":"M","census_search_date":"2024-08-20 21:43:00","snet_input_date":"2024-08-15 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-08-20 21:43:00","insp_carrier_name":"CE TRUCKING LLC","insp_carrier_street":"7015 WINFREE DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77087","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0908286","created_at":"2025-03-17T20:32:01.000000Z","updated_at":"2025-03-17T20:32:01.000000Z","inspection_violations":[{"id":10125559,"change_date":"2024-08-20 21:43:00","inspection_id":"82437857","insp_violation_id":"261304260","seq_no":"1","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"202493758","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:55:01.000000Z","updated_at":"2025-03-17T21:55:01.000000Z","normalized_code":"39375A3"},{"id":10125560,"change_date":"2024-08-20 21:43:00","inspection_id":"82437857","insp_violation_id":"261304261","seq_no":"2","part_no":"393","part_no_section":"75(c)","insp_viol_unit":"1","insp_unit_id":"202493758","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:01.000000Z","updated_at":"2025-03-17T21:55:01.000000Z","normalized_code":"39375C"},{"id":10125561,"change_date":"2024-08-20 21:43:00","inspection_id":"82437857","insp_violation_id":"261304262","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202493758","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:01.000000Z","updated_at":"2025-03-17T21:55:01.000000Z","normalized_code":"3939A"},{"id":10125562,"change_date":"2024-08-20 21:43:00","inspection_id":"82437857","insp_violation_id":"261304263","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202493758","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:01.000000Z","updated_at":"2025-03-17T21:55:01.000000Z","normalized_code":"3939A"},{"id":10125563,"change_date":"2024-08-20 21:43:00","inspection_id":"82437857","insp_violation_id":"261304264","seq_no":"5","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"202493758","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:01.000000Z","updated_at":"2025-03-17T21:55:01.000000Z","normalized_code":"39395A"},{"id":10125564,"change_date":"2024-08-20 21:43:00","inspection_id":"82437857","insp_violation_id":"261304265","seq_no":"6","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"202493758","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:01.000000Z","updated_at":"2025-03-17T21:55:01.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10507485,"change_date":"2024-08-20 21:43:00","inspection_id":"82437857","insp_unit_id":"202493758","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"31","insp_unit_license":"HMV5333","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKADU9X5YJ834081","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:31:50.000000Z","updated_at":"2025-03-17T23:31:50.000000Z"}]},{"id":6433208,"change_date":"2024-08-09 21:38:00","inspection_id":"82347369","dot_number":"2788234","report_state":"TX","report_number":"V241507193","insp_date":"2024-08-07 00:00:00","insp_start_time":"0638","insp_end_time":"0716","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH45 NB @ AIRTEX","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CE TRUCKING","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-09 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"54900","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":"9345942","transaction_code":"A","transaction_date":"2024-08-09 00:00:00","upload_date":"2024-08-09 00:00:00","upload_first_byte":"0","upload_dot_number":"02788234","upload_search_indicator":"M","census_search_date":"2024-08-09 21:38:00","snet_input_date":"2024-08-07 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-08-09 21:38:00","insp_carrier_name":"CE TRUCKING LLC","insp_carrier_street":"7015 WINFREE DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77087","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0908286","created_at":"2025-03-17T20:30:19.000000Z","updated_at":"2025-03-17T20:30:19.000000Z","inspection_violations":[{"id":9990984,"change_date":"2024-08-09 21:38:00","inspection_id":"82347369","insp_violation_id":"261116656","seq_no":"1","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"202322945","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:19.000000Z","updated_at":"2025-03-17T21:54:19.000000Z","normalized_code":"39378"},{"id":9990985,"change_date":"2024-08-09 21:38:00","inspection_id":"82347369","insp_violation_id":"261116657","seq_no":"2","part_no":"393","part_no_section":"82","insp_viol_unit":"1","insp_unit_id":"202322945","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:19.000000Z","updated_at":"2025-03-17T21:54:19.000000Z","normalized_code":"39382"},{"id":9990986,"change_date":"2024-08-09 21:38:00","inspection_id":"82347369","insp_violation_id":"261116658","seq_no":"3","part_no":"393","part_no_section":"83(g)","insp_viol_unit":"1","insp_unit_id":"202322945","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:19.000000Z","updated_at":"2025-03-17T21:54:19.000000Z","normalized_code":"39383G"},{"id":9990987,"change_date":"2024-08-09 21:38:00","inspection_id":"82347369","insp_violation_id":"261116659","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202322945","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:19.000000Z","updated_at":"2025-03-17T21:54:19.000000Z","normalized_code":"3939A"},{"id":9990988,"change_date":"2024-08-09 21:38:00","inspection_id":"82347369","insp_violation_id":"261116660","seq_no":"5","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202322945","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:19.000000Z","updated_at":"2025-03-17T21:54:19.000000Z","normalized_code":"3939A"},{"id":9990989,"change_date":"2024-08-09 21:38:00","inspection_id":"82347369","insp_violation_id":"261116661","seq_no":"6","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"202322945","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:54:19.000000Z","updated_at":"2025-03-17T21:54:19.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10368390,"change_date":"2024-08-09 21:38:00","inspection_id":"82347369","insp_unit_id":"202322945","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"28","insp_unit_license":"VCL9043","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKADB9X8MS555135","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:30:27.000000Z","updated_at":"2025-03-17T23:30:27.000000Z"}]},{"id":6371246,"change_date":"2024-08-01 21:41:00","inspection_id":"82281049","dot_number":"2788234","report_state":"TX","report_number":"6XD89DCALH","insp_date":"2024-07-30 00:00:00","insp_start_time":"0831","insp_end_time":"1000","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"13500  EAST FWY SER","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"HEIDELBERG MATERIALS","shipping_paper_number":"1132091695","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-01 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"33001","viol_total":"6","oos_total":"2","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"5","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9339225","transaction_code":"A","transaction_date":"2024-08-01 00:00:00","upload_date":"2024-08-01 00:00:00","upload_first_byte":"0","upload_dot_number":"02788234","upload_search_indicator":"M","census_search_date":"2024-08-01 21:41:00","snet_input_date":"2024-07-30 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-08-01 21:41:00","insp_carrier_name":"CE TRUCKING LLC","insp_carrier_street":"7015 WINFREE DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77087","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0908286","created_at":"2025-03-17T20:29:06.000000Z","updated_at":"2025-03-17T20:29:06.000000Z","inspection_violations":[{"id":9891463,"change_date":"2024-08-01 21:41:00","inspection_id":"82281049","insp_violation_id":"260974259","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"202197422","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:51.000000Z","updated_at":"2025-03-17T21:53:51.000000Z","normalized_code":"39347E"},{"id":9891464,"change_date":"2024-08-01 21:41:00","inspection_id":"82281049","insp_violation_id":"260974260","seq_no":"2","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"202197422","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:51.000000Z","updated_at":"2025-03-17T21:53:51.000000Z","normalized_code":"39353B"},{"id":9891465,"change_date":"2024-08-01 21:41:00","inspection_id":"82281049","insp_violation_id":"260974261","seq_no":"3","part_no":"383","part_no_section":"51(a)","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:53:51.000000Z","updated_at":"2025-03-17T21:53:51.000000Z","normalized_code":"38351A"},{"id":9891466,"change_date":"2024-08-01 21:41:00","inspection_id":"82281049","insp_violation_id":"260974262","seq_no":"5","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"202197422","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:51.000000Z","updated_at":"2025-03-17T21:53:51.000000Z","normalized_code":"3922"},{"id":9891467,"change_date":"2024-08-01 21:41:00","inspection_id":"82281049","insp_violation_id":"260974263","seq_no":"6","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"202197422","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:51.000000Z","updated_at":"2025-03-17T21:53:51.000000Z","normalized_code":"39345B2"},{"id":9891468,"change_date":"2024-08-01 21:41:00","inspection_id":"82281049","insp_violation_id":"260974264","seq_no":"7","part_no":"392","part_no_section":"9(a)(2)","insp_viol_unit":"1","insp_unit_id":"202197422","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:53:51.000000Z","updated_at":"2025-03-17T21:53:51.000000Z","normalized_code":"3929A2"}],"inspection_per_units":[{"id":10267181,"change_date":"2024-08-01 21:41:00","inspection_id":"82281049","insp_unit_id":"202197422","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"29","insp_unit_license":"KKL8229","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKAD29X6KS537732","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:29:22.000000Z","updated_at":"2025-03-17T23:29:22.000000Z"}]},{"id":6275235,"change_date":"2024-07-25 21:44:00","inspection_id":"82178494","dot_number":"2788234","report_state":"TX","report_number":"6X2D9DKY73","insp_date":"2024-07-19 00:00:00","insp_start_time":"1317","insp_end_time":"1341","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"1400  AMBURN RD","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":"OPEN","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-07-22 21:42: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":"9330871","transaction_code":"C","transaction_date":"2024-07-24 00:00:00","upload_date":"2024-07-24 00:00:00","upload_first_byte":"0","upload_dot_number":"02788234","upload_search_indicator":"M","census_search_date":"2024-07-22 21:42:00","snet_input_date":"2024-07-19 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-07-22 21:42:00","insp_carrier_name":"CE TRUCKING LLC","insp_carrier_street":"7015 WINFREE DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77087","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0908286","created_at":"2025-03-17T20:27:03.000000Z","updated_at":"2025-03-17T20:27:03.000000Z","inspection_violations":[{"id":9746939,"change_date":"2024-07-25 21:44:00","inspection_id":"82178494","insp_violation_id":"260848977","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"202077621","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:10.000000Z","updated_at":"2025-03-17T21:53:10.000000Z","normalized_code":"3922"},{"id":9746940,"change_date":"2024-07-25 21:44:00","inspection_id":"82178494","insp_violation_id":"260848978","seq_no":"2","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"202077621","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:10.000000Z","updated_at":"2025-03-17T21:53:10.000000Z","normalized_code":"3963A1"},{"id":9746941,"change_date":"2024-07-25 21:44:00","inspection_id":"82178494","insp_violation_id":"260848979","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202077621","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:10.000000Z","updated_at":"2025-03-17T21:53:10.000000Z","normalized_code":"3939A"},{"id":9746942,"change_date":"2024-07-25 21:44:00","inspection_id":"82178494","insp_violation_id":"260848980","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"202077621","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:10.000000Z","updated_at":"2025-03-17T21:53:10.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":10110753,"change_date":"2024-07-25 21:44:00","inspection_id":"82178494","insp_unit_id":"202077621","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"28","insp_unit_license":"VCL9043","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKADB9X8MS555135","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:27:46.000000Z","updated_at":"2025-03-17T23:27:46.000000Z"}]},{"id":5731967,"change_date":"2024-05-15 21:44:00","inspection_id":"81591630","dot_number":"2788234","report_state":"TX","report_number":"6UW79DKY4V","insp_date":"2024-05-02 00:00:00","insp_start_time":"0707","insp_end_time":"0728","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":"OPEN","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":"2024-05-13 21:42: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":"9271042","transaction_code":"C","transaction_date":"2024-05-15 00:00:00","upload_date":"2024-05-15 00:00:00","upload_first_byte":"0","upload_dot_number":"02788234","upload_search_indicator":"M","census_search_date":"2024-05-13 21:42:00","snet_input_date":"2024-05-02 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-05-13 21:42:00","insp_carrier_name":"CE TRUCKING LLC","insp_carrier_street":"7015 WINFREE DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77087","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0908286","created_at":"2025-03-17T20:16:19.000000Z","updated_at":"2025-03-17T20:16:19.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9232270,"change_date":"2024-05-15 21:44:00","inspection_id":"81591630","insp_unit_id":"200912249","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"32","insp_unit_license":"51N545M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDDB9XX5J071391","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:18:55.000000Z","updated_at":"2025-03-17T23:18:55.000000Z"}]},{"id":5545712,"change_date":"2024-04-18 21:40:00","inspection_id":"81388943","dot_number":"2788234","report_state":"TX","report_number":"6UG99DCPGB","insp_date":"2024-04-16 00:00:00","insp_start_time":"0950","insp_end_time":"1015","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"13500  EAST FWY SOUT","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-18 21:40: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":"9251293","transaction_code":"A","transaction_date":"2024-04-18 00:00:00","upload_date":"2024-04-18 00:00:00","upload_first_byte":"0","upload_dot_number":"02788234","upload_search_indicator":"M","census_search_date":"2024-04-18 21:40:00","snet_input_date":"2024-04-16 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-04-18 21:40:00","insp_carrier_name":"CE TRUCKING LLC","insp_carrier_street":"7015 WINFREE DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77087","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0908286","created_at":"2025-03-17T20:12:44.000000Z","updated_at":"2025-03-17T20:12:44.000000Z","inspection_violations":[{"id":8569771,"change_date":"2024-04-18 21:40:00","inspection_id":"81388943","insp_violation_id":"259014917","seq_no":"1","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"200470659","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:32.000000Z","updated_at":"2025-03-17T21:47:32.000000Z","normalized_code":"3965B"},{"id":8569772,"change_date":"2024-04-18 21:40:00","inspection_id":"81388943","insp_violation_id":"259014918","seq_no":"2","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"200470659","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:32.000000Z","updated_at":"2025-03-17T21:47:32.000000Z","normalized_code":"39345B2"}],"inspection_per_units":[{"id":8933195,"change_date":"2024-04-18 21:40:00","inspection_id":"81388943","insp_unit_id":"200470659","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"HMV5333","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKADU9X5YJ834081","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:16:07.000000Z","updated_at":"2025-03-17T23:16:07.000000Z"}]},{"id":5512967,"change_date":"2024-04-15 21:41:00","inspection_id":"81353205","dot_number":"2788234","report_state":"TX","report_number":"6UBA9DGBGF","insp_date":"2024-04-11 00:00:00","insp_start_time":"0917","insp_end_time":"1037","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":"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-15 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"50000","viol_total":"8","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9249023","transaction_code":"A","transaction_date":"2024-04-15 00:00:00","upload_date":"2024-04-15 00:00:00","upload_first_byte":"0","upload_dot_number":"02788234","upload_search_indicator":"M","census_search_date":"2024-04-15 21:41:00","snet_input_date":"2024-04-11 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-04-15 21:41:00","insp_carrier_name":"CE TRUCKING LLC","insp_carrier_street":"7015 WINFREE DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77087","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0908286","created_at":"2025-03-17T20:11:57.000000Z","updated_at":"2025-03-17T20:11:57.000000Z","inspection_violations":[{"id":8517100,"change_date":"2024-04-15 21:41:00","inspection_id":"81353205","insp_violation_id":"258935623","seq_no":"1","part_no":"393","part_no_section":"203(a)","insp_viol_unit":"1","insp_unit_id":"200400905","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:14.000000Z","updated_at":"2025-03-17T21:47:14.000000Z","normalized_code":"393203A"},{"id":8517101,"change_date":"2024-04-15 21:41:00","inspection_id":"81353205","insp_violation_id":"258935624","seq_no":"2","part_no":"392","part_no_section":"8","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:14.000000Z","updated_at":"2025-03-17T21:47:14.000000Z","normalized_code":"3928"},{"id":8517102,"change_date":"2024-04-15 21:41:00","inspection_id":"81353205","insp_violation_id":"258935625","seq_no":"3","part_no":"393","part_no_section":"95(b)","insp_viol_unit":"1","insp_unit_id":"200400905","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:14.000000Z","updated_at":"2025-03-17T21:47:14.000000Z","normalized_code":"39395B"},{"id":8517103,"change_date":"2024-04-15 21:41:00","inspection_id":"81353205","insp_violation_id":"258935626","seq_no":"4","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"200400905","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:14.000000Z","updated_at":"2025-03-17T21:47:14.000000Z","normalized_code":"39395F"},{"id":8517104,"change_date":"2024-04-15 21:41:00","inspection_id":"81353205","insp_violation_id":"258935627","seq_no":"5","part_no":"393","part_no_section":"28","insp_viol_unit":"1","insp_unit_id":"200400905","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:14.000000Z","updated_at":"2025-03-17T21:47:14.000000Z","normalized_code":"39328"},{"id":8517105,"change_date":"2024-04-15 21:41:00","inspection_id":"81353205","insp_violation_id":"258935628","seq_no":"6","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"200400905","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:14.000000Z","updated_at":"2025-03-17T21:47:14.000000Z","normalized_code":"3922"},{"id":8517106,"change_date":"2024-04-15 21:41:00","inspection_id":"81353205","insp_violation_id":"258935629","seq_no":"7","part_no":"393","part_no_section":"45(d)","insp_viol_unit":"1","insp_unit_id":"200400905","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:14.000000Z","updated_at":"2025-03-17T21:47:14.000000Z","normalized_code":"39345D"},{"id":8517107,"change_date":"2024-04-15 21:41:00","inspection_id":"81353205","insp_violation_id":"258935630","seq_no":"8","part_no":"393","part_no_section":"47(a)","insp_viol_unit":"1","insp_unit_id":"200400905","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:47:14.000000Z","updated_at":"2025-03-17T21:47:14.000000Z","normalized_code":"39347A"}],"inspection_per_units":[{"id":8880433,"change_date":"2024-04-15 21:41:00","inspection_id":"81353205","insp_unit_id":"200400905","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"31","insp_unit_license":"HMV5333","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKADU9X5YJ834081","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:15:38.000000Z","updated_at":"2025-03-17T23:15:38.000000Z"}]},{"id":5319874,"change_date":"2024-03-19 21:45:00","inspection_id":"81142519","dot_number":"2788234","report_state":"TX","report_number":"6TH99DCPFI","insp_date":"2024-03-12 00:00:00","insp_start_time":"0915","insp_end_time":"0945","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"13500  EAST FWY SOUT","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-03-19 21:45:00","post_acc_ind":"N","gross_comb_veh_wt":"54900","viol_total":"9","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"9","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9226446","transaction_code":"A","transaction_date":"2024-03-19 00:00:00","upload_date":"2024-03-19 00:00:00","upload_first_byte":"0","upload_dot_number":"02788234","upload_search_indicator":"M","census_search_date":"2024-03-19 21:45:00","snet_input_date":"2024-03-12 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-03-19 21:45:00","insp_carrier_name":"CE TRUCKING LLC","insp_carrier_street":"7015 WINFREE DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77087","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0908286","created_at":"2025-03-17T20:07:57.000000Z","updated_at":"2025-03-17T20:07:57.000000Z","inspection_violations":[{"id":8208247,"change_date":"2024-03-19 21:45:00","inspection_id":"81142519","insp_violation_id":"258468037","seq_no":"1","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"199986233","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:41.000000Z","updated_at":"2025-03-17T21:45:41.000000Z","normalized_code":"39395A"},{"id":8208248,"change_date":"2024-03-19 21:45:00","inspection_id":"81142519","insp_violation_id":"258468038","seq_no":"2","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"199986233","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:41.000000Z","updated_at":"2025-03-17T21:45:41.000000Z","normalized_code":"39378"},{"id":8208249,"change_date":"2024-03-19 21:45:00","inspection_id":"81142519","insp_violation_id":"258468039","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"199986233","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:41.000000Z","updated_at":"2025-03-17T21:45:41.000000Z","normalized_code":"3939A"},{"id":8208250,"change_date":"2024-03-19 21:45:00","inspection_id":"81142519","insp_violation_id":"258468040","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"199986233","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:41.000000Z","updated_at":"2025-03-17T21:45:41.000000Z","normalized_code":"3939A"},{"id":8208251,"change_date":"2024-03-19 21:45:00","inspection_id":"81142519","insp_violation_id":"258468041","seq_no":"5","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"199986233","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:45:41.000000Z","updated_at":"2025-03-17T21:45:41.000000Z","normalized_code":"39375A3"},{"id":8208252,"change_date":"2024-03-19 21:45:00","inspection_id":"81142519","insp_violation_id":"258468042","seq_no":"6","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"199986233","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:41.000000Z","updated_at":"2025-03-17T21:45:41.000000Z","normalized_code":"39347E"},{"id":8208253,"change_date":"2024-03-19 21:45:00","inspection_id":"81142519","insp_violation_id":"258468043","seq_no":"7","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"199986233","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:41.000000Z","updated_at":"2025-03-17T21:45:41.000000Z","normalized_code":"39347E"},{"id":8208254,"change_date":"2024-03-19 21:45:00","inspection_id":"81142519","insp_violation_id":"258468044","seq_no":"8","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"199986233","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:45:41.000000Z","updated_at":"2025-03-17T21:45:41.000000Z","normalized_code":"39353B"},{"id":8208255,"change_date":"2024-03-19 21:45:00","inspection_id":"81142519","insp_violation_id":"258468045","seq_no":"9","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"199986233","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:45:41.000000Z","updated_at":"2025-03-17T21:45:41.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":8567739,"change_date":"2024-03-19 21:45:00","inspection_id":"81142519","insp_unit_id":"199986233","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"HMV5333","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKADU9X5YJ834081","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:12:39.000000Z","updated_at":"2025-03-17T23:12:39.000000Z"}]},{"id":5260473,"change_date":"2024-03-11 21:44:00","inspection_id":"81077623","dot_number":"2788234","report_state":"TX","report_number":"6TCD9DGBFH","insp_date":"2024-03-07 00:00:00","insp_start_time":"1312","insp_end_time":"1328","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-03-11 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"50000","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":"9219502","transaction_code":"A","transaction_date":"2024-03-11 00:00:00","upload_date":"2024-03-11 00:00:00","upload_first_byte":"0","upload_dot_number":"02788234","upload_search_indicator":"M","census_search_date":"2024-03-11 21:44:00","snet_input_date":"2024-03-07 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-03-11 21:44:00","insp_carrier_name":"CE TRUCKING LLC","insp_carrier_street":"7015 WINFREE DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77087","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0908286","created_at":"2025-03-17T20:07:02.000000Z","updated_at":"2025-03-17T20:07:02.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8470993,"change_date":"2024-03-11 21:44:00","inspection_id":"81077623","insp_unit_id":"199857429","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"28","insp_unit_license":"CKF2250","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKADB9X8MS555135","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:11:47.000000Z","updated_at":"2025-03-17T23:11:47.000000Z"}]},{"id":5053888,"change_date":"2024-02-14 21:42:00","inspection_id":"80852324","dot_number":"2788234","report_state":"TX","report_number":"6SK79DGTIS","insp_date":"2024-02-08 00:00:00","insp_start_time":"0704","insp_end_time":"0759","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"13500  EAST FWY SOUT","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-02-14 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"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":"9196262","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":"02788234","upload_search_indicator":"M","census_search_date":"2024-02-14 21:42:00","snet_input_date":"2024-02-08 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-02-14 21:42:00","insp_carrier_name":"CE TRUCKING LLC","insp_carrier_street":"7015 WINFREE DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77087","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0908286","created_at":"2025-03-17T20:02:46.000000Z","updated_at":"2025-03-17T20:02:46.000000Z","inspection_violations":[{"id":7788685,"change_date":"2024-02-14 21:42:00","inspection_id":"80852324","insp_violation_id":"257843970","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"199428704","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:43:40.000000Z","updated_at":"2025-03-17T21:43:40.000000Z","normalized_code":"3922"},{"id":7788686,"change_date":"2024-02-14 21:42:00","inspection_id":"80852324","insp_violation_id":"257843971","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"199428704","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":7788687,"change_date":"2024-02-14 21:42:00","inspection_id":"80852324","insp_violation_id":"257843972","seq_no":"4","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"199428704","insp_violation_category_id":"15","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":"39347E"},{"id":7788688,"change_date":"2024-02-14 21:42:00","inspection_id":"80852324","insp_violation_id":"257843973","seq_no":"5","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"199428704","insp_violation_category_id":"15","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":"39347E"},{"id":7788689,"change_date":"2024-02-14 21:42:00","inspection_id":"80852324","insp_violation_id":"257843974","seq_no":"6","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"199428704","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":"39353B"},{"id":7788690,"change_date":"2024-02-14 21:42:00","inspection_id":"80852324","insp_violation_id":"257843975","seq_no":"7","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"199428704","insp_violation_category_id":"15","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":"3963A1"},{"id":7788691,"change_date":"2024-02-14 21:42:00","inspection_id":"80852324","insp_violation_id":"257843976","seq_no":"8","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"199428704","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":"3963A1"}],"inspection_per_units":[{"id":8135175,"change_date":"2024-02-14 21:42:00","inspection_id":"80852324","insp_unit_id":"199428704","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"28","insp_unit_license":"CKF2250","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKADB9X8MS555135","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":4581313,"change_date":"2024-12-10 21:41:00","inspection_id":"80335387","dot_number":"2788234","report_state":"TX","report_number":"6QQD9DHP60","insp_date":"2023-12-04 00:00:00","insp_start_time":"1326","insp_end_time":"1345","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":"2023-12-07 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"50000","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":"9142299","transaction_code":"C","transaction_date":"2024-12-10 00:00:00","upload_date":"2024-12-10 00:00:00","upload_first_byte":"0","upload_dot_number":"02788234","upload_search_indicator":"M","census_search_date":"2023-12-07 21:41:00","snet_input_date":"2023-12-04 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-12-07 21:41:00","insp_carrier_name":"CE TRUCKING LLC","insp_carrier_street":"7015 WINFREE DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77087","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":"0908286","created_at":"2025-03-17T19:53:45.000000Z","updated_at":"2025-03-17T19:53:45.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7368718,"change_date":"2024-12-10 21:41:00","inspection_id":"80335387","insp_unit_id":"204299696","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"TBZ0164","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKADB9X97J171066","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:55.000000Z","updated_at":"2025-03-17T23:01:55.000000Z"}]},{"id":4274823,"change_date":"2023-10-24 21:40:00","inspection_id":"79997423","dot_number":"2788234","report_state":"TX","report_number":"6PD99DNAYK","insp_date":"2023-10-16 00:00:00","insp_start_time":"0915","insp_end_time":"1000","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"1000  S. KATY FT BEN","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"TEAMWORK CONST","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-10-24 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":"9108305","transaction_code":"A","transaction_date":"2023-10-24 00:00:00","upload_date":"2023-10-24 00:00:00","upload_first_byte":"0","upload_dot_number":"02788234","upload_search_indicator":"M","census_search_date":"2023-10-24 21:40:00","snet_input_date":"2023-10-16 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-10-24 21:40:00","insp_carrier_name":"CE TRUCKING LLC","insp_carrier_street":"7015 WINFREE DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77087","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0908286","created_at":"2025-03-17T19:47:28.000000Z","updated_at":"2025-03-17T19:47:28.000000Z","inspection_violations":[{"id":6612479,"change_date":"2023-10-24 21:40:00","inspection_id":"79997423","insp_violation_id":"256020456","seq_no":"1","part_no":"393","part_no_section":"83(g)","insp_viol_unit":"1","insp_unit_id":"197726379","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:51.000000Z","updated_at":"2025-03-17T21:37:51.000000Z","normalized_code":"39383G"},{"id":6612480,"change_date":"2023-10-24 21:40:00","inspection_id":"79997423","insp_violation_id":"256020457","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"197726379","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:37:51.000000Z","updated_at":"2025-03-17T21:37:51.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6875245,"change_date":"2023-10-24 21:40:00","inspection_id":"79997423","insp_unit_id":"197726379","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"88","insp_unit_license":"SGJ4453","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDD49X5AJ277093","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:57:40.000000Z","updated_at":"2025-03-17T22:57:40.000000Z"}]},{"id":4116775,"change_date":"2023-10-03 21:41:00","inspection_id":"79822703","dot_number":"2788234","report_state":"TX","report_number":"6OT99DFPO1","insp_date":"2023-09-26 00:00:00","insp_start_time":"0909","insp_end_time":"0948","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"200 E SAM HOUSTON PK","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":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-10-03 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"52000","viol_total":"5","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9090558","transaction_code":"A","transaction_date":"2023-10-03 00:00:00","upload_date":"2023-10-03 00:00:00","upload_first_byte":"0","upload_dot_number":"02788234","upload_search_indicator":"M","census_search_date":"2023-10-03 21:41:00","snet_input_date":"2023-09-26 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-10-03 21:41:00","insp_carrier_name":"CE TRUCKING LLC","insp_carrier_street":"7015 WINFREE DR","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77087","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0908286","created_at":"2025-03-17T19:44:05.000000Z","updated_at":"2025-03-17T19:44:05.000000Z","inspection_violations":[{"id":6369465,"change_date":"2023-10-03 21:41:00","inspection_id":"79822703","insp_violation_id":"255632818","seq_no":"1","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"197377493","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:43.000000Z","updated_at":"2025-03-17T21:36:43.000000Z","normalized_code":"3965B"},{"id":6369466,"change_date":"2023-10-03 21:41:00","inspection_id":"79822703","insp_violation_id":"255632819","seq_no":"2","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"197377493","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:43.000000Z","updated_at":"2025-03-17T21:36:43.000000Z","normalized_code":"39345B2"},{"id":6369467,"change_date":"2023-10-03 21:41:00","inspection_id":"79822703","insp_violation_id":"255632820","seq_no":"3","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"197377493","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:43.000000Z","updated_at":"2025-03-17T21:36:43.000000Z","normalized_code":"39345B2"},{"id":6369468,"change_date":"2023-10-03 21:41:00","inspection_id":"79822703","insp_violation_id":"255632821","seq_no":"4","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"197377493","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:36:43.000000Z","updated_at":"2025-03-17T21:36:43.000000Z","normalized_code":"3963A1"},{"id":6369469,"change_date":"2023-10-03 21:41:00","inspection_id":"79822703","insp_violation_id":"255632822","seq_no":"5","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:36:43.000000Z","updated_at":"2025-03-17T21:36:43.000000Z","normalized_code":"39282A1"}],"inspection_per_units":[{"id":6619150,"change_date":"2023-10-03 21:41:00","inspection_id":"79822703","insp_unit_id":"197377493","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"30","insp_unit_license":"TBZ0164","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKADB9X97J171066","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:55:31.000000Z","updated_at":"2025-03-17T22:55:31.000000Z"}]},{"id":3792472,"change_date":"2023-08-21 21:42:00","inspection_id":"79461574","dot_number":"2788234","report_state":"TX","report_number":"6NNF9DBHB5","insp_date":"2023-08-15 00:00:00","insp_start_time":"1539","insp_end_time":"1718","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0010 IN HARRIS CO. (742-797","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"ELSON","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-08-21 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"48000","viol_total":"5","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"5","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9056601","transaction_code":"A","transaction_date":"2023-08-21 00:00:00","upload_date":"2023-08-21 00:00:00","upload_first_byte":"0","upload_dot_number":"02788234","upload_search_indicator":"M","census_search_date":"2023-08-21 21:42:00","snet_input_date":"2023-08-15 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-08-21 21:42:00","insp_carrier_name":"CE TRUCKING LLC","insp_carrier_street":"7015 WINFREE DRIVE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77087","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0908286","created_at":"2025-03-17T19:37:42.000000Z","updated_at":"2025-03-17T19:37:42.000000Z","inspection_violations":[{"id":5849909,"change_date":"2023-08-21 21:42:00","inspection_id":"79461574","insp_violation_id":"254780395","seq_no":"1","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"196644058","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:11.000000Z","updated_at":"2025-03-17T21:34:11.000000Z","normalized_code":"39360C"},{"id":5849910,"change_date":"2023-08-21 21:42:00","inspection_id":"79461574","insp_violation_id":"254780396","seq_no":"2","part_no":"393","part_no_section":"28","insp_viol_unit":"1","insp_unit_id":"196644058","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:11.000000Z","updated_at":"2025-03-17T21:34:11.000000Z","normalized_code":"39328"},{"id":5849911,"change_date":"2023-08-21 21:42:00","inspection_id":"79461574","insp_violation_id":"254780397","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196644058","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:11.000000Z","updated_at":"2025-03-17T21:34:11.000000Z","normalized_code":"3939A"},{"id":5849912,"change_date":"2023-08-21 21:42:00","inspection_id":"79461574","insp_violation_id":"254780398","seq_no":"4","part_no":"393","part_no_section":"209(e)","insp_viol_unit":"1","insp_unit_id":"196644058","insp_violation_category_id":"21","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:11.000000Z","updated_at":"2025-03-17T21:34:11.000000Z","normalized_code":"393209E"},{"id":5849913,"change_date":"2023-08-21 21:42:00","inspection_id":"79461574","insp_violation_id":"254780399","seq_no":"5","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"196644058","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:34:11.000000Z","updated_at":"2025-03-17T21:34:11.000000Z","normalized_code":"3965B"}],"inspection_per_units":[{"id":6098086,"change_date":"2023-08-21 21:42:00","inspection_id":"79461574","insp_unit_id":"196644058","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"29","insp_unit_license":"KKL8229","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKAD29X6KS537732","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:51:14.000000Z","updated_at":"2025-03-17T22:51:14.000000Z"}]},{"id":3665929,"change_date":"2023-08-03 21:41:00","inspection_id":"79320493","dot_number":"2788234","report_state":"TX","report_number":"6N999DGT46","insp_date":"2023-08-01 00:00:00","insp_start_time":"0958","insp_end_time":"1040","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"13500  EAST FWY SOUT","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-08-03 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"54900","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":"9043581","transaction_code":"A","transaction_date":"2023-08-03 00:00:00","upload_date":"2023-08-03 00:00:00","upload_first_byte":"0","upload_dot_number":"02788234","upload_search_indicator":"M","census_search_date":"2023-08-03 21:41:00","snet_input_date":"2023-08-01 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-08-03 21:41:00","insp_carrier_name":"CE TRUCKING LLC","insp_carrier_street":"7015 WINFREE DRIVE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77087","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0908286","created_at":"2025-03-17T19:35:16.000000Z","updated_at":"2025-03-17T19:35:16.000000Z","inspection_violations":[{"id":5652153,"change_date":"2023-08-03 21:41:00","inspection_id":"79320493","insp_violation_id":"254457490","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"196354849","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:33:11.000000Z","updated_at":"2025-03-17T21:33:11.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":5894319,"change_date":"2023-08-03 21:41:00","inspection_id":"79320493","insp_unit_id":"196354849","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"001","insp_unit_license":"HMV5333","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKADU9X5YJ834081","insp_unit_decal":"Y","insp_unit_decal_number":"32982966","created_at":"2025-03-17T22:49:32.000000Z","updated_at":"2025-03-17T22:49:32.000000Z"}]},{"id":3582008,"change_date":"2023-07-24 21:42:00","inspection_id":"79226287","dot_number":"2788234","report_state":"TX","report_number":"6MY89DCONU","insp_date":"2023-07-21 00:00:00","insp_start_time":"0806","insp_end_time":"0820","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"9500 S SAM HOUSTON P","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"T CONSTRUCTION","shipping_paper_number":"30","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-07-24 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":"9034932","transaction_code":"A","transaction_date":"2023-07-24 00:00:00","upload_date":"2023-07-24 00:00:00","upload_first_byte":"0","upload_dot_number":"02788234","upload_search_indicator":"M","census_search_date":"2023-07-24 21:42:00","snet_input_date":"2023-07-21 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-07-24 21:42:00","insp_carrier_name":"CE TRUCKING LLC","insp_carrier_street":"7015 WINFREE DRIVE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77087","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0908286","created_at":"2025-03-17T19:33:50.000000Z","updated_at":"2025-03-17T19:33:50.000000Z","inspection_violations":[{"id":5523568,"change_date":"2023-07-24 21:42:00","inspection_id":"79226287","insp_violation_id":"254247698","seq_no":"1","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"196166920","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:32:38.000000Z","updated_at":"2025-03-17T21:32:38.000000Z","normalized_code":"39360C"}],"inspection_per_units":[{"id":5759943,"change_date":"2023-07-24 21:42:00","inspection_id":"79226287","insp_unit_id":"196166920","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"30","insp_unit_license":"TBZ0164","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKADB9X97J171066","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:48:27.000000Z","updated_at":"2025-03-17T22:48:27.000000Z"}]},{"id":3204461,"change_date":"2023-06-02 21:42:00","inspection_id":"78801451","dot_number":"2788234","report_state":"TX","report_number":"6LI79DGPQO","insp_date":"2023-05-30 00:00:00","insp_start_time":"0716","insp_end_time":"0745","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"8000  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-06-02 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"50000","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":"8994777","transaction_code":"A","transaction_date":"2023-06-02 00:00:00","upload_date":"2023-06-02 00:00:00","upload_first_byte":"0","upload_dot_number":"02788234","upload_search_indicator":"M","census_search_date":"2023-06-02 21:42:00","snet_input_date":"2023-05-30 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-06-02 21:42:00","insp_carrier_name":"CE TRUCKING LLC","insp_carrier_street":"7015 WINFREE DRIVE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77087","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0908286","created_at":"2025-03-17T19:26:27.000000Z","updated_at":"2025-03-17T19:26:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5154063,"change_date":"2023-06-02 21:42:00","inspection_id":"78801451","insp_unit_id":"195287367","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"88","insp_unit_license":"SGJ4453","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDD49X5AJ277093","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:43:36.000000Z","updated_at":"2025-03-17T22:43:36.000000Z"}]},{"id":3121487,"change_date":"2023-05-23 21:43:00","inspection_id":"78707803","dot_number":"2788234","report_state":"TX","report_number":"6L699DCGQ2","insp_date":"2023-05-18 00:00:00","insp_start_time":"0915","insp_end_time":"0942","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"6200 W FUQUA","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-23 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"49900","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":"8986022","transaction_code":"A","transaction_date":"2023-05-23 00:00:00","upload_date":"2023-05-23 00:00:00","upload_first_byte":"0","upload_dot_number":"02788234","upload_search_indicator":"M","census_search_date":"2023-05-23 21:43:00","snet_input_date":"2023-05-18 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-05-23 21:43:00","insp_carrier_name":"CE TRUCKING LLC","insp_carrier_street":"7015 WINFREE DRIVE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77087","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0908286","created_at":"2025-03-17T19:24:55.000000Z","updated_at":"2025-03-17T19:24:55.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5021073,"change_date":"2023-05-23 21:43:00","inspection_id":"78707803","insp_unit_id":"195101006","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"HMV5333","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKADU9X5YJ834081","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:36.000000Z","updated_at":"2025-03-17T22:42:36.000000Z"}]},{"id":2889795,"change_date":"2023-04-25 21:40:00","inspection_id":"78446052","dot_number":"2788234","report_state":"TX","report_number":"6KIE9DCKEG","insp_date":"2023-04-24 00:00:00","insp_start_time":"1419","insp_end_time":"1442","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"500 W 28TH ST","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"UNK","shipping_paper_number":"UNK","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-04-25 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"50000","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":"8964305","transaction_code":"A","transaction_date":"2023-04-25 00:00:00","upload_date":"2023-04-25 00:00:00","upload_first_byte":"0","upload_dot_number":"02788234","upload_search_indicator":"M","census_search_date":"2023-04-25 21:40:00","snet_input_date":"2023-04-24 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-04-25 21:40:00","insp_carrier_name":"CE TRUCKING LLC","insp_carrier_street":"7015 WINFREE DRIVE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77087","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0908286","created_at":"2025-03-17T19:20:04.000000Z","updated_at":"2025-03-17T19:20:04.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4649947,"change_date":"2023-04-25 21:40:00","inspection_id":"78446052","insp_unit_id":"194580723","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"CKF2250","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKADB9X8MS555135","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:39:39.000000Z","updated_at":"2025-03-17T22:39:39.000000Z"}]},{"id":2889211,"change_date":"2023-04-25 21:40:00","inspection_id":"78445407","dot_number":"2788234","report_state":"TX","report_number":"6KE69DGPOX","insp_date":"2023-04-20 00:00:00","insp_start_time":"0637","insp_end_time":"0710","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"5900  KATY 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-04-25 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"48000","viol_total":"4","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8962892","transaction_code":"A","transaction_date":"2023-04-25 00:00:00","upload_date":"2023-04-25 00:00:00","upload_first_byte":"0","upload_dot_number":"02788234","upload_search_indicator":"M","census_search_date":"2023-04-25 21:40:00","snet_input_date":"2023-04-20 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-04-25 21:40:00","insp_carrier_name":"CE TRUCKING LLC","insp_carrier_street":"7015 WINFREE DRIVE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77087","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0908286","created_at":"2025-03-17T19:20:04.000000Z","updated_at":"2025-03-17T19:20:04.000000Z","inspection_violations":[{"id":4434791,"change_date":"2023-04-25 21:40:00","inspection_id":"78445407","insp_violation_id":"252434345","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"194579423","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:40.000000Z","updated_at":"2025-03-17T21:27:40.000000Z","normalized_code":"3922"},{"id":4434792,"change_date":"2023-04-25 21:40:00","inspection_id":"78445407","insp_violation_id":"252434346","seq_no":"3","part_no":"393","part_no_section":"201(d)","insp_viol_unit":"1","insp_unit_id":"194579423","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:40.000000Z","updated_at":"2025-03-17T21:27:40.000000Z","normalized_code":"393201D"},{"id":4434793,"change_date":"2023-04-25 21:40:00","inspection_id":"78445407","insp_violation_id":"252434347","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"194579423","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:40.000000Z","updated_at":"2025-03-17T21:27:40.000000Z","normalized_code":"3939A"},{"id":4434794,"change_date":"2023-04-25 21:40:00","inspection_id":"78445407","insp_violation_id":"252434348","seq_no":"5","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:27:40.000000Z","updated_at":"2025-03-17T21:27:40.000000Z","normalized_code":"3903E"}],"inspection_per_units":[{"id":4648930,"change_date":"2023-04-25 21:40:00","inspection_id":"78445407","insp_unit_id":"194579423","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"002","insp_unit_license":"KKL8229","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKAD29X6KS537732","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:39:39.000000Z","updated_at":"2025-03-17T22:39:39.000000Z"}]},{"id":2678426,"change_date":"2023-03-28 21:41:00","inspection_id":"78205176","dot_number":"2788234","report_state":"TX","report_number":"6JK89DGPN1","insp_date":"2023-03-21 00:00:00","insp_start_time":"0824","insp_end_time":"0852","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"13500  EAST 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":"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":"8939164","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":"02788234","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":"CE TRUCKING LLC","insp_carrier_street":"7015 WINFREE DRIVE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77087","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0908286","created_at":"2025-03-17T19:15:55.000000Z","updated_at":"2025-03-17T19:15:55.000000Z","inspection_violations":[{"id":4115770,"change_date":"2023-03-28 21:41:00","inspection_id":"78205176","insp_violation_id":"251910205","seq_no":"1","part_no":"393","part_no_section":"79","insp_viol_unit":"1","insp_unit_id":"194104612","insp_violation_category_id":"26","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":"39379"}],"inspection_per_units":[{"id":4312733,"change_date":"2023-03-28 21:41:00","inspection_id":"78205176","insp_unit_id":"194104612","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"028","insp_unit_license":"CKF2250","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKADB9X8MS555135","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":2535558,"change_date":"2023-03-08 21:41:00","inspection_id":"78043160","dot_number":"2788234","report_state":"TX","report_number":"6J079DGPLB","insp_date":"2023-03-01 00:00:00","insp_start_time":"0707","insp_end_time":"0743","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"19400  KATY FWY","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-03-08 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":"8922888","transaction_code":"A","transaction_date":"2023-03-08 00:00:00","upload_date":"2023-03-08 00:00:00","upload_first_byte":"0","upload_dot_number":"02788234","upload_search_indicator":"M","census_search_date":"2023-03-08 21:41:00","snet_input_date":"2023-03-01 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-03-08 21:41:00","insp_carrier_name":"CE TRUCKING LLC","insp_carrier_street":"7015 WINFREE DRIVE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77087","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0908286","created_at":"2025-03-17T19:13:22.000000Z","updated_at":"2025-03-17T19:13:22.000000Z","inspection_violations":[{"id":3899487,"change_date":"2023-03-08 21:41:00","inspection_id":"78043160","insp_violation_id":"251552537","seq_no":"1","part_no":"393","part_no_section":"83(g)","insp_viol_unit":"1","insp_unit_id":"193775270","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:25:16.000000Z","updated_at":"2025-03-17T21:25:16.000000Z","normalized_code":"39383G"}],"inspection_per_units":[{"id":4081443,"change_date":"2023-03-08 21:41:00","inspection_id":"78043160","insp_unit_id":"193775270","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"88","insp_unit_license":"SGJ4453","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKDD49X5AJ277093","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:35:15.000000Z","updated_at":"2025-03-17T22:35:15.000000Z"}]},{"id":2484371,"change_date":"2023-03-01 21:42:00","inspection_id":"77985153","dot_number":"2788234","report_state":"TX","report_number":"6ITA9DNARL","insp_date":"2023-02-22 00:00:00","insp_start_time":"0930","insp_end_time":"1015","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"5200  MORTON RD","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"XX","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-03-01 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"0","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":"8917276","transaction_code":"A","transaction_date":"2023-03-01 00:00:00","upload_date":"2023-03-01 00:00:00","upload_first_byte":"0","upload_dot_number":"02788234","upload_search_indicator":"M","census_search_date":"2023-03-01 21:42:00","snet_input_date":"2023-02-22 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-03-01 21:42:00","insp_carrier_name":"CE TRUCKING LLC","insp_carrier_street":"7015 WINFREE DRIVE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77087","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0908286","created_at":"2025-03-17T19:12:30.000000Z","updated_at":"2025-03-17T19:12:30.000000Z","inspection_violations":[{"id":3822861,"change_date":"2023-03-01 21:42:00","inspection_id":"77985153","insp_violation_id":"251425548","seq_no":"1","part_no":"393","part_no_section":"205(c)","insp_viol_unit":"1","insp_unit_id":"193658418","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:24:59.000000Z","updated_at":"2025-03-17T21:24:59.000000Z","normalized_code":"393205C"}],"inspection_per_units":[{"id":3998040,"change_date":"2023-03-01 21:42:00","inspection_id":"77985153","insp_unit_id":"193658418","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"001","insp_unit_license":"HMV5333","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKADU9X5YJ834081","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:34:38.000000Z","updated_at":"2025-03-17T22:34:38.000000Z"}]},{"id":2328801,"change_date":"2023-02-08 21:40:00","inspection_id":"77807352","dot_number":"2788234","report_state":"TX","report_number":"6I799DGX3X","insp_date":"2023-01-31 00:00:00","insp_start_time":"0844","insp_end_time":"0921","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"200 E SAM HOUSTON PK","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2023-02-08 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"50000","viol_total":"10","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"10","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8898170","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":"02788234","upload_search_indicator":"M","census_search_date":"2023-02-08 21:40:00","snet_input_date":"2023-01-31 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-02-08 21:40:00","insp_carrier_name":"CE TRUCKING LLC","insp_carrier_street":"7015 WINFREE DRIVE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77087","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0908286","created_at":"2025-03-17T19:09:37.000000Z","updated_at":"2025-03-17T19:09:37.000000Z","inspection_violations":[{"id":3587475,"change_date":"2023-02-08 21:40:00","inspection_id":"77807352","insp_violation_id":"251026397","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"193301378","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:56.000000Z","updated_at":"2025-03-17T21:23:56.000000Z","normalized_code":"3963A1"},{"id":3587476,"change_date":"2023-02-08 21:40:00","inspection_id":"77807352","insp_violation_id":"251026398","seq_no":"2","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"193301378","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:56.000000Z","updated_at":"2025-03-17T21:23:56.000000Z","normalized_code":"39347E"},{"id":3587477,"change_date":"2023-02-08 21:40:00","inspection_id":"77807352","insp_violation_id":"251026399","seq_no":"3","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"193301378","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:56.000000Z","updated_at":"2025-03-17T21:23:56.000000Z","normalized_code":"39347E"},{"id":3587478,"change_date":"2023-02-08 21:40:00","inspection_id":"77807352","insp_violation_id":"251026400","seq_no":"4","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"193301378","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:56.000000Z","updated_at":"2025-03-17T21:23:56.000000Z","normalized_code":"39353B"},{"id":3587479,"change_date":"2023-02-08 21:40:00","inspection_id":"77807352","insp_violation_id":"251026401","seq_no":"5","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"193301378","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:23:56.000000Z","updated_at":"2025-03-17T21:23:56.000000Z","normalized_code":"3963A1"},{"id":3587480,"change_date":"2023-02-08 21:40:00","inspection_id":"77807352","insp_violation_id":"251026402","seq_no":"6","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"193301378","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:56.000000Z","updated_at":"2025-03-17T21:23:56.000000Z","normalized_code":"39360C"},{"id":3587481,"change_date":"2023-02-08 21:40:00","inspection_id":"77807352","insp_violation_id":"251026403","seq_no":"7","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"193301378","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:56.000000Z","updated_at":"2025-03-17T21:23:56.000000Z","normalized_code":"39395A"},{"id":3587482,"change_date":"2023-02-08 21:40:00","inspection_id":"77807352","insp_violation_id":"251026404","seq_no":"8","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"193301378","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:56.000000Z","updated_at":"2025-03-17T21:23:56.000000Z","normalized_code":"3963A1"},{"id":3587483,"change_date":"2023-02-08 21:40:00","inspection_id":"77807352","insp_violation_id":"251026405","seq_no":"9","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"193301378","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:56.000000Z","updated_at":"2025-03-17T21:23:56.000000Z","normalized_code":"39345B2"},{"id":3587484,"change_date":"2023-02-08 21:40:00","inspection_id":"77807352","insp_violation_id":"251026406","seq_no":"10","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193301378","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:56.000000Z","updated_at":"2025-03-17T21:23:56.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":3748069,"change_date":"2023-02-08 21:40:00","inspection_id":"77807352","insp_unit_id":"193301378","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"028","insp_unit_license":"CXF2250","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKADB9X8MS555135","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":2218842,"change_date":"2023-01-24 21:43:00","inspection_id":"77682592","dot_number":"2788234","report_state":"TX","report_number":"6HTF9DBZF3","insp_date":"2023-01-17 00:00:00","insp_start_time":"1519","insp_end_time":"1542","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"18100  KATY FWY SERV","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-01-24 21:43: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":"8885537","transaction_code":"A","transaction_date":"2023-01-24 00:00:00","upload_date":"2023-01-24 00:00:00","upload_first_byte":"0","upload_dot_number":"02788234","upload_search_indicator":"M","census_search_date":"2023-01-24 21:43:00","snet_input_date":"2023-01-17 00:00:00","source_office":"2TXS001","mcmis_add_date":"2023-01-24 21:43:00","insp_carrier_name":"CE TRUCKING LLC","insp_carrier_street":"7015 WINFREE DRIVE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77087","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0908286","created_at":"2025-03-17T19:07:24.000000Z","updated_at":"2025-03-17T19:07:24.000000Z","inspection_violations":[{"id":3426802,"change_date":"2023-01-24 21:43:00","inspection_id":"77682592","insp_violation_id":"250755756","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193044693","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:13.000000Z","updated_at":"2025-03-17T21:23:13.000000Z","normalized_code":"3922"},{"id":3426803,"change_date":"2023-01-24 21:43:00","inspection_id":"77682592","insp_violation_id":"250755757","seq_no":"2","part_no":"393","part_no_section":"205(c)","insp_viol_unit":"1","insp_unit_id":"193044693","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:13.000000Z","updated_at":"2025-03-17T21:23:13.000000Z","normalized_code":"393205C"}],"inspection_per_units":[{"id":3571294,"change_date":"2023-01-24 21:43:00","inspection_id":"77682592","insp_unit_id":"193044693","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"CKF2250","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKADB9X8MS555135","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:31:37.000000Z","updated_at":"2025-03-17T22:31:37.000000Z"}]},{"id":1863201,"change_date":"2022-12-02 21:41:00","inspection_id":"77275594","dot_number":"2788234","report_state":"TX","report_number":"6GIF9DCNW3","insp_date":"2022-12-01 00:00:00","insp_start_time":"1550","insp_end_time":"1610","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"500  MELWOOD ST","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CE TRUCKING LLC","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-02 21:41: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":"8841549","transaction_code":"A","transaction_date":"2022-12-02 00:00:00","upload_date":"2022-12-02 00:00:00","upload_first_byte":"0","upload_dot_number":"02788234","upload_search_indicator":"M","census_search_date":"2022-12-02 21:41:00","snet_input_date":"2022-12-01 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-12-02 21:41:00","insp_carrier_name":"CE TRUCKING LLC","insp_carrier_street":"7015 WINFREE DRIVE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77087","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0908286","created_at":"2025-03-17T19:01:04.000000Z","updated_at":"2025-03-17T19:01:04.000000Z","inspection_violations":[{"id":2903669,"change_date":"2022-12-02 21:41:00","inspection_id":"77275594","insp_violation_id":"249899537","seq_no":"1","part_no":"393","part_no_section":"95(f)","insp_viol_unit":"1","insp_unit_id":"192240038","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:52.000000Z","updated_at":"2025-03-17T21:20:52.000000Z","normalized_code":"39395F"},{"id":2903670,"change_date":"2022-12-02 21:41:00","inspection_id":"77275594","insp_violation_id":"249899538","seq_no":"2","part_no":"393","part_no_section":"83(g)","insp_viol_unit":"1","insp_unit_id":"192240038","insp_violation_category_id":"27","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:20:52.000000Z","updated_at":"2025-03-17T21:20:52.000000Z","normalized_code":"39383G"}],"inspection_per_units":[{"id":2998566,"change_date":"2022-12-02 21:41:00","inspection_id":"77275594","insp_unit_id":"192240038","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"HMV5333","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKADU9X5YJ834081","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:27:31.000000Z","updated_at":"2025-03-17T22:27:31.000000Z"}]},{"id":1183678,"change_date":"2022-08-31 21:43:00","inspection_id":"76491764","dot_number":"2788234","report_state":"TX","report_number":"6DTE0XVRFR","insp_date":"2022-08-26 00:00:00","insp_start_time":"1430","insp_end_time":"1458","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US-0290 IN HARRIS CO. (706-738","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CE 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":"2022-08-31 21:43: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":"8759959","transaction_code":"A","transaction_date":"2022-08-31 00:00:00","upload_date":"2022-08-31 00:00:00","upload_first_byte":"0","upload_dot_number":"02788234","upload_search_indicator":"M","census_search_date":"2022-08-31 21:43:00","snet_input_date":"2022-08-26 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-08-31 21:43:00","insp_carrier_name":"CE TRUCKING LLC","insp_carrier_street":"7015 WINFREE DRIVE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77087","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0908286","created_at":"2025-03-17T18:48:35.000000Z","updated_at":"2025-03-17T18:48:35.000000Z","inspection_violations":[{"id":1879635,"change_date":"2022-08-31 21:43:00","inspection_id":"76491764","insp_violation_id":"248140122","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"190657476","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:39.000000Z","updated_at":"2025-03-17T21:15:39.000000Z","normalized_code":"3939A"},{"id":1879636,"change_date":"2022-08-31 21:43:00","inspection_id":"76491764","insp_violation_id":"248140123","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"190657476","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:39.000000Z","updated_at":"2025-03-17T21:15:39.000000Z","normalized_code":"3939A"},{"id":1879637,"change_date":"2022-08-31 21:43:00","inspection_id":"76491764","insp_violation_id":"248140124","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"190657476","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:39.000000Z","updated_at":"2025-03-17T21:15:39.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":1903851,"change_date":"2022-08-31 21:43:00","inspection_id":"76491764","insp_unit_id":"190657476","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"001","insp_unit_license":"HMV5333","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKADU9X5YJ834081","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:05.000000Z","updated_at":"2025-03-17T22:20:05.000000Z"}]},{"id":1088942,"change_date":"2022-08-19 21:36:00","inspection_id":"76381531","dot_number":"2788234","report_state":"TX","report_number":"6D589DCI3D","insp_date":"2022-08-02 00:00:00","insp_start_time":"0840","insp_end_time":"0920","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0288 IN HARRIS CO. (472-484","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2022-08-19 21:36: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":"8747322","transaction_code":"A","transaction_date":"2022-08-19 00:00:00","upload_date":"2022-08-19 00:00:00","upload_first_byte":"0","upload_dot_number":"02788234","upload_search_indicator":"M","census_search_date":"2022-08-19 21:36:00","snet_input_date":"2022-08-02 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-08-19 21:36:00","insp_carrier_name":"CE TRUCKING LLC","insp_carrier_street":"7015 WINFREE DRIVE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77087","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0908286","created_at":"2025-03-17T18:46:54.000000Z","updated_at":"2025-03-17T18:46:54.000000Z","inspection_violations":[{"id":1715357,"change_date":"2022-08-19 21:36:00","inspection_id":"76381531","insp_violation_id":"247858122","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"190432693","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:59.000000Z","updated_at":"2025-03-17T21:14:59.000000Z","normalized_code":"3922"},{"id":1715358,"change_date":"2022-08-19 21:36:00","inspection_id":"76381531","insp_violation_id":"247858123","seq_no":"2","part_no":"393","part_no_section":"19","insp_viol_unit":"1","insp_unit_id":"190432693","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:59.000000Z","updated_at":"2025-03-17T21:14:59.000000Z","normalized_code":"39319"},{"id":1715359,"change_date":"2022-08-19 21:36:00","inspection_id":"76381531","insp_violation_id":"247858124","seq_no":"3","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"190432693","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:14:59.000000Z","updated_at":"2025-03-17T21:14:59.000000Z","normalized_code":"3939A"},{"id":1715360,"change_date":"2022-08-19 21:36:00","inspection_id":"76381531","insp_violation_id":"247858125","seq_no":"4","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"190432693","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:59.000000Z","updated_at":"2025-03-17T21:14:59.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":1751665,"change_date":"2022-08-19 21:36:00","inspection_id":"76381531","insp_unit_id":"190432693","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":null,"insp_unit_license":"CKF2250","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKADB9X8MS555135","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:03.000000Z","updated_at":"2025-03-17T22:19:03.000000Z"}]},{"id":946242,"change_date":"2022-08-02 21:40:00","inspection_id":"76214850","dot_number":"2788234","report_state":"TX","report_number":"6CTG9DJN4F","insp_date":"2022-07-21 00:00:00","insp_start_time":"1605","insp_end_time":"1650","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":"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-08-02 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"54900","viol_total":"7","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"7","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8729699","transaction_code":"A","transaction_date":"2022-08-02 00:00:00","upload_date":"2022-08-02 00:00:00","upload_first_byte":"0","upload_dot_number":"02788234","upload_search_indicator":"M","census_search_date":"2022-08-02 21:40:00","snet_input_date":"2022-07-21 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-08-02 21:40:00","insp_carrier_name":"CE TRUCKING LLC","insp_carrier_street":"7015 WINFREE DRIVE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77087","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0908286","created_at":"2025-03-17T18:44:23.000000Z","updated_at":"2025-03-17T18:44:23.000000Z","inspection_violations":[{"id":1492598,"change_date":"2022-08-02 21:40:00","inspection_id":"76214850","insp_violation_id":"247467552","seq_no":"1","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"190094635","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:04.000000Z","updated_at":"2025-03-17T21:14:04.000000Z","normalized_code":"39347E"},{"id":1492599,"change_date":"2022-08-02 21:40:00","inspection_id":"76214850","insp_violation_id":"247467553","seq_no":"2","part_no":"393","part_no_section":"47(e)","insp_viol_unit":"1","insp_unit_id":"190094635","insp_violation_category_id":"15","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:04.000000Z","updated_at":"2025-03-17T21:14:04.000000Z","normalized_code":"39347E"},{"id":1492600,"change_date":"2022-08-02 21:40:00","inspection_id":"76214850","insp_violation_id":"247467554","seq_no":"3","part_no":"393","part_no_section":"53(b)","insp_viol_unit":"1","insp_unit_id":"190094635","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:04.000000Z","updated_at":"2025-03-17T21:14:04.000000Z","normalized_code":"39353B"},{"id":1492601,"change_date":"2022-08-02 21:40:00","inspection_id":"76214850","insp_violation_id":"247467555","seq_no":"4","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"1","insp_unit_id":"190094635","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:14:04.000000Z","updated_at":"2025-03-17T21:14:04.000000Z","normalized_code":"3963A1"},{"id":1492602,"change_date":"2022-08-02 21:40:00","inspection_id":"76214850","insp_violation_id":"247467556","seq_no":"5","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"190094635","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:14:04.000000Z","updated_at":"2025-03-17T21:14:04.000000Z","normalized_code":"3965B"},{"id":1492603,"change_date":"2022-08-02 21:40:00","inspection_id":"76214850","insp_violation_id":"247467557","seq_no":"6","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"190094635","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:04.000000Z","updated_at":"2025-03-17T21:14:04.000000Z","normalized_code":"39345B2"},{"id":1492604,"change_date":"2022-08-02 21:40:00","inspection_id":"76214850","insp_violation_id":"247467558","seq_no":"7","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"190094635","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:14:04.000000Z","updated_at":"2025-03-17T21:14:04.000000Z","normalized_code":"3965B"}],"inspection_per_units":[{"id":1523725,"change_date":"2022-08-02 21:40:00","inspection_id":"76214850","insp_unit_id":"190094635","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"002","insp_unit_license":"KKL8229","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKAD29X6KS537732","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:17:35.000000Z","updated_at":"2025-03-17T22:17:35.000000Z"}]},{"id":842727,"change_date":"2022-07-18 21:43:00","inspection_id":"76093533","dot_number":"2788234","report_state":"TX","report_number":"6CMF0XLI5B","insp_date":"2022-07-14 00:00:00","insp_start_time":"1446","insp_end_time":"1515","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"FM-0521 IN HARRIS CO. (728-734","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"CE TRUCKING","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":"2022-07-18 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"54900","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":"8716689","transaction_code":"A","transaction_date":"2022-07-18 00:00:00","upload_date":"2022-07-18 00:00:00","upload_first_byte":"0","upload_dot_number":"02788234","upload_search_indicator":"M","census_search_date":"2022-07-18 21:43:00","snet_input_date":"2022-07-14 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-07-18 21:43:00","insp_carrier_name":"CE TRUCKING LLC","insp_carrier_street":"7015 WINFREE DRIVE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77087","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0908286","created_at":"2025-03-17T18:42:38.000000Z","updated_at":"2025-03-17T18:42:38.000000Z","inspection_violations":[{"id":1330169,"change_date":"2022-07-18 21:43:00","inspection_id":"76093533","insp_violation_id":"247169877","seq_no":"1","part_no":"396","part_no_section":"5(b)","insp_viol_unit":"1","insp_unit_id":"189841429","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:13:16.000000Z","updated_at":"2025-03-17T21:13:16.000000Z","normalized_code":"3965B"}],"inspection_per_units":[{"id":1356643,"change_date":"2022-07-18 21:43:00","inspection_id":"76093533","insp_unit_id":"189841429","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"002","insp_unit_license":"KKL8229","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKAD29X6KS537732","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:16:31.000000Z","updated_at":"2025-03-17T22:16:31.000000Z"}]},{"id":619319,"change_date":"2022-06-15 21:41:00","inspection_id":"75831283","dot_number":"2788234","report_state":"TX","report_number":"6BH99DNAIB","insp_date":"2022-06-03 00:00:00","insp_start_time":"0830","insp_end_time":"0915","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"5600  MORTON RD","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"XX","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":"2022-06-15 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"0","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":"8680807","transaction_code":"A","transaction_date":"2022-06-15 00:00:00","upload_date":"2022-06-15 00:00:00","upload_first_byte":"0","upload_dot_number":"02788234","upload_search_indicator":"M","census_search_date":"2022-06-15 21:41:00","snet_input_date":"2022-06-03 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-06-15 21:41:00","insp_carrier_name":"CE TRUCKING LLC","insp_carrier_street":"7015 WINFREE DRIVE","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77087","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"0908286","created_at":"2025-03-17T18:38:30.000000Z","updated_at":"2025-03-17T18:38:30.000000Z","inspection_violations":[{"id":972468,"change_date":"2022-06-15 21:41:00","inspection_id":"75831283","insp_violation_id":"246494917","seq_no":"1","part_no":"393","part_no_section":"209(d)","insp_viol_unit":"1","insp_unit_id":"189275596","insp_violation_category_id":"21","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:33.000000Z","updated_at":"2025-03-17T21:11:33.000000Z","normalized_code":"393209D"}],"inspection_per_units":[{"id":996101,"change_date":"2022-06-15 21:41:00","inspection_id":"75831283","insp_unit_id":"189275596","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"002","insp_unit_license":"KKL8229","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKAD29X6KS537732","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:20.000000Z","updated_at":"2025-03-17T22:14:20.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/2788234\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/2788234\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/2788234\/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\/2788234\/inspections","per_page":100,"prev_page_url":null,"to":49,"total":49}