{"current_page":1,"data":[{"id":9728132,"change_date":"2025-09-19 21:38:00","inspection_id":"85824295","dot_number":"3547997","report_state":"MO","report_number":"0520000374","insp_date":"2025-09-18 00:00:00","insp_start_time":"1826","insp_end_time":"1935","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"FREDERICKTOWN MO","county_code_state":"MO","county_code":"123","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"INDUSTRIAL SHELVING SYSTEMS","shipping_paper_number":"9163069","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":"U","pen_cen_match":"I","final_status_date":"2025-09-19 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"12500","viol_total":"3","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2300757","transaction_code":"A","transaction_date":"2025-09-19 00:00:00","upload_date":"2025-09-19 00:00:00","upload_first_byte":"0","upload_dot_number":"03547997","upload_search_indicator":null,"census_search_date":"2025-09-19 21:38:00","snet_input_date":"2025-09-18 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-09-19 21:38:00","insp_carrier_name":"CALTEX EXPRESS TRANSPORT LLC","insp_carrier_street":"923 FLORES DEL SOL","insp_carrier_city":"ALAMO","insp_carrier_state":"TX","insp_carrier_zip_code":"78516","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-23T10:02:42.000000Z","updated_at":"2025-09-23T10:02:42.000000Z","inspection_violations":[{"id":15972913,"change_date":"2025-09-19 21:38:00","inspection_id":"85824295","insp_violation_id":"268805403","seq_no":"1","part_no":"393","part_no_section":"43DBMA","insp_viol_unit":"2","insp_unit_id":"209045179","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-09-22T10:18:24.000000Z","updated_at":"2025-09-23T10:16:11.000000Z","normalized_code":"39343DBMA"},{"id":15972914,"change_date":"2025-09-19 21:38:00","inspection_id":"85824295","insp_violation_id":"268805404","seq_no":"2","part_no":"393","part_no_section":"41-BNPB","insp_viol_unit":"1","insp_unit_id":"209045178","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-09-22T10:18:24.000000Z","updated_at":"2025-09-23T10:16:11.000000Z","normalized_code":"39341BNPB"},{"id":15972915,"change_date":"2025-09-19 21:38:00","inspection_id":"85824295","insp_violation_id":"268805405","seq_no":"3","part_no":"393","part_no_section":"40A-B","insp_viol_unit":"2","insp_unit_id":"209045179","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-22T10:18:24.000000Z","updated_at":"2025-09-23T10:16:11.000000Z","normalized_code":"39340AB"}],"inspection_per_units":[{"id":16109587,"change_date":"2025-09-19 21:38:00","inspection_id":"85824295","insp_unit_id":"209045178","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"DODGE","insp_unit_company":"MS04","insp_unit_license":"VZG1969","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3C6UR5HL1KG707021","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-22T09:47:03.000000Z","updated_at":"2025-09-23T09:45:50.000000Z"},{"id":16109588,"change_date":"2025-09-19 21:38:00","inspection_id":"85824295","insp_unit_id":"209045179","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":"004","insp_unit_license":"069606N","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1P9GF3526LL375277","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-22T09:47:03.000000Z","updated_at":"2025-09-23T09:45:50.000000Z"}]},{"id":9716432,"change_date":"2025-09-18 21:42:00","inspection_id":"85812043","dot_number":"3547997","report_state":"AL","report_number":"1836003565","insp_date":"2025-09-16 00:00:00","insp_start_time":"0810","insp_end_time":"0930","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"ATTALLA AL","county_code_state":"AL","county_code":"055","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"CALTEX EXPRESS TRANSPORT 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":"U","pen_cen_match":"I","final_status_date":"2025-09-18 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"18","oos_total":"5","driver_viol_total":"0","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"4","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2295328","transaction_code":"A","transaction_date":"2025-09-18 00:00:00","upload_date":"2025-09-18 00:00:00","upload_first_byte":"0","upload_dot_number":"03547997","upload_search_indicator":null,"census_search_date":"2025-09-18 21:42:00","snet_input_date":"2025-09-16 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-09-18 21:42:00","insp_carrier_name":"CALTEX EXPRESS TRANSPORT LLC","insp_carrier_street":"923 FLORES DEL SOL","insp_carrier_city":"ALAMO","insp_carrier_state":"TX","insp_carrier_zip_code":"78516","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-23T10:02:20.000000Z","updated_at":"2025-09-23T10:02:20.000000Z","inspection_violations":[{"id":15952056,"change_date":"2025-09-18 21:42:00","inspection_id":"85812043","insp_violation_id":"268779757","seq_no":"1","part_no":"395","part_no_section":"8A1-HOSP","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"W001682","created_at":"2025-09-22T10:17:41.000000Z","updated_at":"2025-09-22T10:17:41.000000Z","normalized_code":"3958A1HOSP"},{"id":15952057,"change_date":"2025-09-18 21:42:00","inspection_id":"85812043","insp_violation_id":"268779758","seq_no":"2","part_no":"393","part_no_section":"60D","insp_viol_unit":"1","insp_unit_id":"209021861","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-22T10:17:41.000000Z","updated_at":"2025-09-22T10:17:41.000000Z","normalized_code":"39360D"},{"id":15952058,"change_date":"2025-09-18 21:42:00","inspection_id":"85812043","insp_violation_id":"268779759","seq_no":"3","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"209021861","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-22T10:17:41.000000Z","updated_at":"2025-09-22T10:17:41.000000Z","normalized_code":"3939ALIL"},{"id":15952059,"change_date":"2025-09-18 21:42:00","inspection_id":"85812043","insp_violation_id":"268779760","seq_no":"4","part_no":"393","part_no_section":"9A-LCL","insp_viol_unit":"1","insp_unit_id":"209021861","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-22T10:17:41.000000Z","updated_at":"2025-09-22T10:17:41.000000Z","normalized_code":"3939ALCL"},{"id":15952060,"change_date":"2025-09-18 21:42:00","inspection_id":"85812043","insp_violation_id":"268779761","seq_no":"5","part_no":"392","part_no_section":"2-SLLSR","insp_viol_unit":"1","insp_unit_id":"209021861","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-22T10:17:41.000000Z","updated_at":"2025-09-22T10:17:41.000000Z","normalized_code":"3922SLLSR"},{"id":15952061,"change_date":"2025-09-18 21:42:00","inspection_id":"85812043","insp_violation_id":"268779762","seq_no":"6","part_no":"393","part_no_section":"75C-TAOTD-LT2\/32","insp_viol_unit":"2","insp_unit_id":"209021862","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-22T10:17:41.000000Z","updated_at":"2025-09-22T10:17:41.000000Z","normalized_code":"39375CTAOTDLT2\/32"},{"id":15952062,"change_date":"2025-09-18 21:42:00","inspection_id":"85812043","insp_violation_id":"268779763","seq_no":"7","part_no":"393","part_no_section":"41-BNPB","insp_viol_unit":"1","insp_unit_id":"209021861","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-09-22T10:17:41.000000Z","updated_at":"2025-09-22T10:17:41.000000Z","normalized_code":"39341BNPB"},{"id":15952063,"change_date":"2025-09-18 21:42:00","inspection_id":"85812043","insp_violation_id":"268779764","seq_no":"8","part_no":"393","part_no_section":"75C-TAOTD-LT2\/32","insp_viol_unit":"2","insp_unit_id":"209021862","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-22T10:17:41.000000Z","updated_at":"2025-09-22T10:17:41.000000Z","normalized_code":"39375CTAOTDLT2\/32"},{"id":15952064,"change_date":"2025-09-18 21:42:00","inspection_id":"85812043","insp_violation_id":"268779765","seq_no":"9","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"2","insp_unit_id":"209021862","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-22T10:17:41.000000Z","updated_at":"2025-09-22T10:17:41.000000Z","normalized_code":"3939ALIL"},{"id":15952065,"change_date":"2025-09-18 21:42:00","inspection_id":"85812043","insp_violation_id":"268779766","seq_no":"10","part_no":"393","part_no_section":"48A-BIHE","insp_viol_unit":"2","insp_unit_id":"209021862","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-22T10:17:41.000000Z","updated_at":"2025-09-22T10:17:41.000000Z","normalized_code":"39348ABIHE"},{"id":15952066,"change_date":"2025-09-18 21:42:00","inspection_id":"85812043","insp_violation_id":"268779767","seq_no":"11","part_no":"393","part_no_section":"48A-BIHE","insp_viol_unit":"2","insp_unit_id":"209021862","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-22T10:17:41.000000Z","updated_at":"2025-09-22T10:17:41.000000Z","normalized_code":"39348ABIHE"},{"id":15952067,"change_date":"2025-09-18 21:42:00","inspection_id":"85812043","insp_violation_id":"268779768","seq_no":"12","part_no":"393","part_no_section":"48A-BIHE","insp_viol_unit":"2","insp_unit_id":"209021862","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-22T10:17:41.000000Z","updated_at":"2025-09-22T10:17:41.000000Z","normalized_code":"39348ABIHE"},{"id":15952068,"change_date":"2025-09-18 21:42:00","inspection_id":"85812043","insp_violation_id":"268779769","seq_no":"13","part_no":"393","part_no_section":"48A-BIHE","insp_viol_unit":"2","insp_unit_id":"209021862","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-22T10:17:41.000000Z","updated_at":"2025-09-22T10:17:41.000000Z","normalized_code":"39348ABIHE"},{"id":15952069,"change_date":"2025-09-18 21:42:00","inspection_id":"85812043","insp_violation_id":"268779770","seq_no":"14","part_no":"396","part_no_section":"3A1-BOS","insp_viol_unit":"2","insp_unit_id":"209021862","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-09-22T10:17:41.000000Z","updated_at":"2025-09-22T10:17:41.000000Z","normalized_code":"3963A1BOS"},{"id":15952070,"change_date":"2025-09-18 21:42:00","inspection_id":"85812043","insp_violation_id":"268779771","seq_no":"15","part_no":"393","part_no_section":"43D-B","insp_viol_unit":"2","insp_unit_id":"209021862","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-09-22T10:17:41.000000Z","updated_at":"2025-09-22T10:17:41.000000Z","normalized_code":"39343DB"},{"id":15952071,"change_date":"2025-09-18 21:42:00","inspection_id":"85812043","insp_violation_id":"268779772","seq_no":"16","part_no":"393","part_no_section":"75C-TAOTD-LT2\/32","insp_viol_unit":"2","insp_unit_id":"209021862","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-22T10:17:41.000000Z","updated_at":"2025-09-22T10:17:41.000000Z","normalized_code":"39375CTAOTDLT2\/32"},{"id":15952072,"change_date":"2025-09-18 21:42:00","inspection_id":"85812043","insp_violation_id":"268779773","seq_no":"17","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"209021862","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"U5632324","created_at":"2025-09-22T10:17:41.000000Z","updated_at":"2025-09-22T10:17:41.000000Z","normalized_code":"39617CPI"},{"id":15952073,"change_date":"2025-09-18 21:42:00","inspection_id":"85812043","insp_violation_id":"268779774","seq_no":"18","part_no":"396","part_no_section":"3A1-HCM","insp_viol_unit":"2","insp_unit_id":"209021862","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-09-22T10:17:41.000000Z","updated_at":"2025-09-22T10:17:41.000000Z","normalized_code":"3963A1HCM"}],"inspection_per_units":[{"id":16089110,"change_date":"2025-09-18 21:42:00","inspection_id":"85812043","insp_unit_id":"209021861","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODGE","insp_unit_company":"01","insp_unit_license":"K183890","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3C63RRGL1GG143866","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-21T09:45:54.000000Z","updated_at":"2025-09-22T09:46:03.000000Z"},{"id":16089111,"change_date":"2025-09-18 21:42:00","inspection_id":"85812043","insp_unit_id":"209021862","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":"P03","insp_unit_license":"205C588","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4C9GF4023NM546337","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-21T09:45:54.000000Z","updated_at":"2025-09-22T09:46:03.000000Z"}]},{"id":9477835,"change_date":"2025-08-22 21:38:00","inspection_id":"85561374","dot_number":"3547997","report_state":"TN","report_number":"I3A1081891","insp_date":"2025-08-20 00:00:00","insp_start_time":"0847","insp_end_time":"0918","registration_date":null,"region":"ED","ci_status_code":"C","location":"KNXEN","location_desc":"KNOXVILLE TN","county_code_state":"TN","county_code":"093","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"SOY INK","shipping_paper_number":"056564","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":"U","pen_cen_match":"I","final_status_date":"2025-08-22 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"21500","viol_total":"9","oos_total":"8","driver_viol_total":"0","driver_oos_total":"8","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2162993","transaction_code":"A","transaction_date":"2025-08-21 00:00:00","upload_date":"2025-08-22 00:00:00","upload_first_byte":"0","upload_dot_number":"03547997","upload_search_indicator":null,"census_search_date":"2025-08-22 21:38:00","snet_input_date":"2025-08-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-08-22 21:38:00","insp_carrier_name":"CALTEX EXPRESS TRANSPORT LLC","insp_carrier_street":"923 FLORES DEL SOL","insp_carrier_city":"ALAMO","insp_carrier_state":"TX","insp_carrier_zip_code":"78516","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-25T10:43:11.000000Z","updated_at":"2025-08-26T10:45:19.000000Z","inspection_violations":[{"id":15447582,"change_date":"2025-08-22 21:38:00","inspection_id":"85561374","insp_violation_id":"268182715","seq_no":"1","part_no":"395","part_no_section":"8E-HOSPDOOS","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"N\/A","created_at":"2025-08-25T10:45:28.000000Z","updated_at":"2025-08-26T10:46:37.000000Z","normalized_code":"3958EHOSPDOOS"},{"id":15447583,"change_date":"2025-08-22 21:38:00","inspection_id":"85561374","insp_violation_id":"268182716","seq_no":"2","part_no":"395","part_no_section":"8E-HOSPDOOS","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"N\/A","created_at":"2025-08-25T10:45:28.000000Z","updated_at":"2025-08-26T10:46:37.000000Z","normalized_code":"3958EHOSPDOOS"},{"id":15447584,"change_date":"2025-08-22 21:38:00","inspection_id":"85561374","insp_violation_id":"268182717","seq_no":"3","part_no":"395","part_no_section":"8E-HOSPDOOS","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"N\/A","created_at":"2025-08-25T10:45:28.000000Z","updated_at":"2025-08-26T10:46:37.000000Z","normalized_code":"3958EHOSPDOOS"},{"id":15447585,"change_date":"2025-08-22 21:38:00","inspection_id":"85561374","insp_violation_id":"268182718","seq_no":"4","part_no":"395","part_no_section":"8E-HOSPDOOS","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"N\/A","created_at":"2025-08-25T10:45:28.000000Z","updated_at":"2025-08-26T10:46:37.000000Z","normalized_code":"3958EHOSPDOOS"},{"id":15447586,"change_date":"2025-08-22 21:38:00","inspection_id":"85561374","insp_violation_id":"268182719","seq_no":"5","part_no":"395","part_no_section":"8E-HOSPDOOS","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"N\/A","created_at":"2025-08-25T10:45:28.000000Z","updated_at":"2025-08-26T10:46:37.000000Z","normalized_code":"3958EHOSPDOOS"},{"id":15447587,"change_date":"2025-08-22 21:38:00","inspection_id":"85561374","insp_violation_id":"268182720","seq_no":"6","part_no":"393","part_no_section":"9A-LRLI","insp_viol_unit":"2","insp_unit_id":"208525779","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"N\/A","created_at":"2025-08-25T10:45:28.000000Z","updated_at":"2025-08-26T10:46:37.000000Z","normalized_code":"3939ALRLI"},{"id":15447588,"change_date":"2025-08-22 21:38:00","inspection_id":"85561374","insp_violation_id":"268182721","seq_no":"7","part_no":"395","part_no_section":"8E-HOSPDOOS","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"N\/A","created_at":"2025-08-25T10:45:28.000000Z","updated_at":"2025-08-26T10:46:37.000000Z","normalized_code":"3958EHOSPDOOS"},{"id":15447589,"change_date":"2025-08-22 21:38:00","inspection_id":"85561374","insp_violation_id":"268182722","seq_no":"8","part_no":"395","part_no_section":"8E-HOSPDOOS","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"N\/A","created_at":"2025-08-25T10:45:28.000000Z","updated_at":"2025-08-26T10:46:37.000000Z","normalized_code":"3958EHOSPDOOS"},{"id":15447590,"change_date":"2025-08-22 21:38:00","inspection_id":"85561374","insp_violation_id":"268182723","seq_no":"9","part_no":"395","part_no_section":"8E-HOSPDOOS","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"N\/A","created_at":"2025-08-25T10:45:28.000000Z","updated_at":"2025-08-26T10:46:37.000000Z","normalized_code":"3958EHOSPDOOS"}],"inspection_per_units":[{"id":15634211,"change_date":"2025-08-22 21:38:00","inspection_id":"85561374","insp_unit_id":"208525778","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODGE","insp_unit_company":"04","insp_unit_license":"VZG1969","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3C6UR5HL1KG707021","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-25T09:46:29.000000Z","updated_at":"2025-08-26T09:45:22.000000Z"},{"id":15634212,"change_date":"2025-08-22 21:38:00","inspection_id":"85561374","insp_unit_id":"208525779","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNKNOWN","insp_unit_company":"004","insp_unit_license":"069606N","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1P9GF3526LL375277","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-25T09:46:29.000000Z","updated_at":"2025-08-26T09:45:22.000000Z"}]},{"id":9473799,"change_date":"2025-08-21 21:41:00","inspection_id":"85557189","dot_number":"3547997","report_state":"TX","report_number":"V251978388","insp_date":"2025-08-19 00:00:00","insp_start_time":"1337","insp_end_time":"1431","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US287 NB","county_code_state":"TX","county_code":"199","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"EQUIPMENT SHARE","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-21 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"9672950","transaction_code":"A","transaction_date":"2025-08-21 00:00:00","upload_date":"2025-08-21 00:00:00","upload_first_byte":"0","upload_dot_number":"03547997","upload_search_indicator":"M","census_search_date":"2025-08-21 21:41:00","snet_input_date":"2025-08-19 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-08-21 21:41:00","insp_carrier_name":"CALTEX EXPRESS TRANSPORT LLC","insp_carrier_street":"923 FLORES DEL SOL","insp_carrier_city":"ALAMO","insp_carrier_state":"TX","insp_carrier_zip_code":"78516","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1028150","created_at":"2025-08-25T10:42:56.000000Z","updated_at":"2025-08-25T10:42:56.000000Z","inspection_violations":[{"id":15438433,"change_date":"2025-08-21 21:41:00","inspection_id":"85557189","insp_violation_id":"268173075","seq_no":"2","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"208518352","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-24T10:48:52.000000Z","updated_at":"2025-08-25T10:45:01.000000Z","normalized_code":"3939"}],"inspection_per_units":[{"id":15626155,"change_date":"2025-08-21 21:41:00","inspection_id":"85557189","insp_unit_id":"208518351","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":"00","insp_unit_license":"K183890","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3C63RRGL1GG143866","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-24T09:46:45.000000Z","updated_at":"2025-08-25T09:46:12.000000Z"},{"id":15626156,"change_date":"2025-08-21 21:41:00","inspection_id":"85557189","insp_unit_id":"208518352","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":"00","insp_unit_license":"205C588","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4C9GF4023NM546337","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-24T09:46:45.000000Z","updated_at":"2025-08-25T09:46:12.000000Z"}]},{"id":9409133,"change_date":"2025-08-14 21:39:00","inspection_id":"85488968","dot_number":"3547997","report_state":"OH","report_number":"3294000872","insp_date":"2025-08-12 00:00:00","insp_start_time":"1538","insp_end_time":"1600","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"MARION OH","county_code_state":"OH","county_code":"101","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"WERK BRAU","shipping_paper_number":"2920188","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":"U","pen_cen_match":"I","final_status_date":"2025-08-14 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"21500","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":"2127394","transaction_code":"A","transaction_date":"2025-08-13 00:00:00","upload_date":"2025-08-14 00:00:00","upload_first_byte":"0","upload_dot_number":"03547997","upload_search_indicator":null,"census_search_date":"2025-08-14 21:39:00","snet_input_date":"2025-08-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-08-14 21:39:00","insp_carrier_name":"CALTEX EXPRESS TRANSPORT LLC","insp_carrier_street":"923 FLORES DEL SOL","insp_carrier_city":"ALAMO","insp_carrier_state":"TX","insp_carrier_zip_code":"78516","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-17T10:01:09.000000Z","updated_at":"2025-08-20T10:43:36.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15507476,"change_date":"2025-08-14 21:39:00","inspection_id":"85488968","insp_unit_id":"208390878","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODGE","insp_unit_company":null,"insp_unit_license":"VGZ1969","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3C6UR5HL1KG707021","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-17T09:46:21.000000Z","updated_at":"2025-08-18T09:45:17.000000Z"},{"id":15507477,"change_date":"2025-08-14 21:39:00","inspection_id":"85488968","insp_unit_id":"208390879","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNKNOWN","insp_unit_company":null,"insp_unit_license":"069606N","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1P9GF3526LL375277","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-17T09:46:21.000000Z","updated_at":"2025-08-18T09:45:17.000000Z"}]},{"id":9253013,"change_date":"2025-07-26 21:33:00","inspection_id":"85324879","dot_number":"3547997","report_state":"OH","report_number":"1532000630","insp_date":"2025-07-24 00:00:00","insp_start_time":"1346","insp_end_time":"1420","registration_date":null,"region":"ED","ci_status_code":"C","location":"OTP MP","location_desc":"YOUNGSTOWN OH","county_code_state":"OH","county_code":"099","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"ACOUSTICAL CONTROL 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":"U","pen_cen_match":"I","final_status_date":"2025-07-26 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"25900","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":"2043833","transaction_code":"A","transaction_date":"2025-07-25 00:00:00","upload_date":"2025-07-26 00:00:00","upload_first_byte":"0","upload_dot_number":"03547997","upload_search_indicator":null,"census_search_date":"2025-07-26 21:33:00","snet_input_date":"2025-07-24 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-07-26 21:33:00","insp_carrier_name":"CALTEX EXPRESS TRANSPORT LLC","insp_carrier_street":"923 FLORES DEL SOL","insp_carrier_city":"ALAMO","insp_carrier_state":"TX","insp_carrier_zip_code":"78516","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-30T10:01:25.000000Z","updated_at":"2025-07-30T10:01:25.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15227917,"change_date":"2025-07-26 21:33:00","inspection_id":"85324879","insp_unit_id":"208089851","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODGE","insp_unit_company":null,"insp_unit_license":"K183882","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3C63RRHL9KG524162","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-29T09:46:14.000000Z","updated_at":"2025-07-30T09:45:07.000000Z"},{"id":15227918,"change_date":"2025-07-26 21:33:00","inspection_id":"85324879","insp_unit_id":"208089852","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"AMERICAN","insp_unit_company":"12","insp_unit_license":"064854M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"17YGA3224MB081620","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-29T09:46:14.000000Z","updated_at":"2025-07-30T09:45:07.000000Z"}]},{"id":9261557,"change_date":"2025-07-28 21:39:00","inspection_id":"85333948","dot_number":"3547997","report_state":"MO","report_number":"W230003928","insp_date":"2025-07-24 00:00:00","insp_start_time":"0835","insp_end_time":"0920","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"MINER MO","county_code_state":"MO","county_code":"201","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"STRONGWELL","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":"U","pen_cen_match":"I","final_status_date":"2025-07-28 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"21500","viol_total":"4","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2051185","transaction_code":"A","transaction_date":"2025-07-28 00:00:00","upload_date":"2025-07-28 00:00:00","upload_first_byte":"0","upload_dot_number":"03547997","upload_search_indicator":null,"census_search_date":"2025-07-28 21:39:00","snet_input_date":"2025-07-24 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-07-28 21:39:00","insp_carrier_name":"CALTEX EXPRESS TRANSPORT LLC","insp_carrier_street":"923 FLORES DEL SOL","insp_carrier_city":"ALAMO","insp_carrier_state":"TX","insp_carrier_zip_code":"78516","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-31T10:00:22.000000Z","updated_at":"2025-08-01T10:41:06.000000Z","inspection_violations":[{"id":15002986,"change_date":"2025-07-28 21:39:00","inspection_id":"85333948","insp_violation_id":"267683460","seq_no":"1","part_no":"395","part_no_section":"8E-HOSPD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-31T10:43:12.000000Z","updated_at":"2025-08-01T10:42:37.000000Z","normalized_code":"3958EHOSPD"},{"id":15002987,"change_date":"2025-07-28 21:39:00","inspection_id":"85333948","insp_violation_id":"267683461","seq_no":"2","part_no":"395","part_no_section":"8E-HOSPD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-31T10:43:12.000000Z","updated_at":"2025-08-01T10:42:37.000000Z","normalized_code":"3958EHOSPD"},{"id":15002988,"change_date":"2025-07-28 21:39:00","inspection_id":"85333948","insp_violation_id":"267683462","seq_no":"3","part_no":"393","part_no_section":"95A1","insp_viol_unit":"1","insp_unit_id":"208105405","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-31T10:43:12.000000Z","updated_at":"2025-08-01T10:42:37.000000Z","normalized_code":"39395A1"},{"id":15002989,"change_date":"2025-07-28 21:39:00","inspection_id":"85333948","insp_violation_id":"267683463","seq_no":"4","part_no":"393","part_no_section":"43D-B","insp_viol_unit":"2","insp_unit_id":"208105406","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-07-31T10:43:12.000000Z","updated_at":"2025-08-01T10:42:37.000000Z","normalized_code":"39343DB"}],"inspection_per_units":[{"id":15242808,"change_date":"2025-07-28 21:39:00","inspection_id":"85333948","insp_unit_id":"208105405","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODGE","insp_unit_company":null,"insp_unit_license":"VZG1969","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3C6UR5HL1KG707021","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-01T09:45:26.000000Z","updated_at":"2025-08-01T09:45:26.000000Z"},{"id":15242809,"change_date":"2025-07-28 21:39:00","inspection_id":"85333948","insp_unit_id":"208105406","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNKNOWN","insp_unit_company":null,"insp_unit_license":"069606N","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1P9GF3526LL375277","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-01T09:45:26.000000Z","updated_at":"2025-08-01T09:45:26.000000Z"}]},{"id":9113691,"change_date":"2025-07-10 21:39:00","inspection_id":"85178518","dot_number":"3547997","report_state":"MS","report_number":"5009012662","insp_date":"2025-06-30 00:00:00","insp_start_time":"1150","insp_end_time":"1218","registration_date":null,"region":"CT","ci_status_code":"C","location":"38","location_desc":"LAUDERDALE COUNTY","county_code_state":"MS","county_code":"075","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"PALLET ONE","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":"2025-07-10 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":null,"viol_total":"1","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1111097","transaction_code":"A","transaction_date":"2025-06-30 00:00:00","upload_date":"2025-07-10 00:00:00","upload_first_byte":"0","upload_dot_number":"03547997","upload_search_indicator":null,"census_search_date":"2025-07-10 21:39:00","snet_input_date":"2025-07-10 00:00:00","source_office":"2MSS002","mcmis_add_date":"2025-07-10 21:39:00","insp_carrier_name":"CALTEX EXPRESS TRANSPORT LLC","insp_carrier_street":"923 FLORES DEL SOL","insp_carrier_city":"ALAMO","insp_carrier_state":"TX","insp_carrier_zip_code":"78516","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-14T10:46:49.000000Z","updated_at":"2025-07-14T10:46:49.000000Z","inspection_violations":[{"id":14689672,"change_date":"2025-07-10 21:39:00","inspection_id":"85178518","insp_violation_id":"267325338","seq_no":"1","part_no":"395","part_no_section":"8E1PC-OOS","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":"500324217","created_at":"2025-07-13T10:49:41.000000Z","updated_at":"2025-07-14T10:48:05.000000Z","normalized_code":"3958E1PCOOS"}],"inspection_per_units":[{"id":14961822,"change_date":"2025-07-10 21:39:00","inspection_id":"85178518","insp_unit_id":"207802192","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":"MS04","insp_unit_license":"VZG1969","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3C6UR5HL1KG707021","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-13T09:46:56.000000Z","updated_at":"2025-07-14T09:45:39.000000Z"},{"id":14961823,"change_date":"2025-07-10 21:39:00","inspection_id":"85178518","insp_unit_id":"207802193","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":"MS004","insp_unit_license":"069606N","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1P9GF3526LL375277","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-13T09:46:56.000000Z","updated_at":"2025-07-14T09:45:39.000000Z"}]},{"id":8586877,"change_date":"2025-05-09 21:41:00","inspection_id":"84621638","dot_number":"3547997","report_state":"TN","report_number":"I5Z1911461","insp_date":"2025-05-07 00:00:00","insp_start_time":"1230","insp_end_time":"1315","registration_date":null,"region":"ED","ci_status_code":"C","location":"GRENS","location_desc":"MOHAWK TN","county_code_state":"TN","county_code":"059","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"STRONGWELL","shipping_paper_number":"133113","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":"U","pen_cen_match":"I","final_status_date":"2025-05-09 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"21500","viol_total":"7","oos_total":"3","driver_viol_total":"0","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1704333","transaction_code":"A","transaction_date":"2025-05-09 00:00:00","upload_date":"2025-05-09 00:00:00","upload_first_byte":"0","upload_dot_number":"03547997","upload_search_indicator":null,"census_search_date":"2025-05-09 21:41:00","snet_input_date":"2025-05-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-05-09 21:41:00","insp_carrier_name":"CALTEX EXPRESS TRANSPORT LLC","insp_carrier_street":"923 FLORES DEL SOL","insp_carrier_city":"ALAMO","insp_carrier_state":"TX","insp_carrier_zip_code":"78516","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-12T10:02:50.000000Z","updated_at":"2025-05-13T10:02:23.000000Z","inspection_violations":[{"id":13641269,"change_date":"2025-05-09 21:41:00","inspection_id":"84621638","insp_violation_id":"266123891","seq_no":"7","part_no":"393","part_no_section":"201C-FR","insp_viol_unit":"2","insp_unit_id":"206771930","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-12T10:26:39.000000Z","updated_at":"2025-05-13T10:21:16.000000Z","normalized_code":"393201CFR"},{"id":13641270,"change_date":"2025-05-09 21:41:00","inspection_id":"84621638","insp_violation_id":"266123892","seq_no":"1","part_no":"396","part_no_section":"5B-L","insp_viol_unit":"1","insp_unit_id":"206771929","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-12T10:26:39.000000Z","updated_at":"2025-05-13T10:21:16.000000Z","normalized_code":"3965BL"},{"id":13641271,"change_date":"2025-05-09 21:41:00","inspection_id":"84621638","insp_violation_id":"266123893","seq_no":"2","part_no":"392","part_no_section":"2-SLLMF","insp_viol_unit":"2","insp_unit_id":"206771930","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-12T10:26:39.000000Z","updated_at":"2025-05-13T10:21:16.000000Z","normalized_code":"3922SLLMF"},{"id":13641272,"change_date":"2025-05-09 21:41:00","inspection_id":"84621638","insp_violation_id":"266123894","seq_no":"3","part_no":"393","part_no_section":"95A4-EEUS","insp_viol_unit":"1","insp_unit_id":"206771929","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-12T10:26:39.000000Z","updated_at":"2025-05-13T10:21:17.000000Z","normalized_code":"39395A4EEUS"},{"id":13641273,"change_date":"2025-05-09 21:41:00","inspection_id":"84621638","insp_violation_id":"266123895","seq_no":"4","part_no":"396","part_no_section":"3A1-BOS","insp_viol_unit":"1","insp_unit_id":"206771929","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-05-12T10:26:39.000000Z","updated_at":"2025-05-13T10:21:17.000000Z","normalized_code":"3963A1BOS"},{"id":13641274,"change_date":"2025-05-09 21:41:00","inspection_id":"84621638","insp_violation_id":"266123896","seq_no":"5","part_no":"396","part_no_section":"3A1-BOS","insp_viol_unit":"2","insp_unit_id":"206771930","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-05-12T10:26:39.000000Z","updated_at":"2025-05-13T10:21:25.000000Z","normalized_code":"3963A1BOS"},{"id":13641275,"change_date":"2025-05-09 21:41:00","inspection_id":"84621638","insp_violation_id":"266123897","seq_no":"6","part_no":"395","part_no_section":"8E-HOSPD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-12T10:26:39.000000Z","updated_at":"2025-05-13T10:21:25.000000Z","normalized_code":"3958EHOSPD"}],"inspection_per_units":[{"id":14016311,"change_date":"2025-05-09 21:41:00","inspection_id":"84621638","insp_unit_id":"206771929","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODGE","insp_unit_company":"004","insp_unit_license":"VZG1969","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3C6UR5HL1KG707021","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-12T09:48:37.000000Z","updated_at":"2025-05-13T09:47:32.000000Z"},{"id":14016312,"change_date":"2025-05-09 21:41:00","inspection_id":"84621638","insp_unit_id":"206771930","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":"004","insp_unit_license":"069606N","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1P9GF3526LL375277","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-12T09:48:37.000000Z","updated_at":"2025-05-13T09:47:32.000000Z"}]},{"id":8549609,"change_date":"2025-05-05 21:40:00","inspection_id":"84582682","dot_number":"3547997","report_state":"IA","report_number":"000P15NDQN","insp_date":"2025-05-03 00:00:00","insp_start_time":"1232","insp_end_time":"1350","registration_date":null,"region":"CT","ci_status_code":"C","location":"15","location_desc":"15 - I380 NB MM 51 BRANDON","county_code_state":"IA","county_code":"019","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"CHARTER COMMUNICATION","shipping_paper_number":"17330620","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":"2025-05-05 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25900","viol_total":"22","oos_total":"7","driver_viol_total":"14","driver_oos_total":"5","vehicle_viol_total":"8","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1358943","transaction_code":"A","transaction_date":"2025-05-05 00:00:00","upload_date":"2025-05-05 00:00:00","upload_first_byte":"0","upload_dot_number":"03547997","upload_search_indicator":"M","census_search_date":"2025-05-05 21:40:00","snet_input_date":"2025-05-03 00:00:00","source_office":"3IAS001","mcmis_add_date":"2025-05-05 21:40:00","insp_carrier_name":"CALTEX EXPRESS TRANSPORT LLC","insp_carrier_street":"923 FLORES DEL SOL","insp_carrier_city":"ALAMO","insp_carrier_state":"TX","insp_carrier_zip_code":"78516","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-08T10:03:43.000000Z","updated_at":"2025-05-09T10:23:24.000000Z","inspection_violations":[{"id":13547225,"change_date":"2025-05-05 21:40:00","inspection_id":"84582682","insp_violation_id":"266011270","seq_no":"1","part_no":"392","part_no_section":"2C","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"0LEE25050312481","created_at":"2025-05-08T10:27:14.000000Z","updated_at":"2025-05-09T10:46:07.000000Z","normalized_code":"3922C"},{"id":13547226,"change_date":"2025-05-05 21:40:00","inspection_id":"84582682","insp_violation_id":"266011271","seq_no":"2","part_no":"383","part_no_section":"23A2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"0LEE25050312483","created_at":"2025-05-08T10:27:14.000000Z","updated_at":"2025-05-09T10:46:07.000000Z","normalized_code":"38323A2"},{"id":13547227,"change_date":"2025-05-05 21:40:00","inspection_id":"84582682","insp_violation_id":"266011272","seq_no":"3","part_no":"392","part_no_section":"2-SLLIFTA","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-08T10:27:14.000000Z","updated_at":"2025-05-09T10:46:07.000000Z","normalized_code":"3922SLLIFTA"},{"id":13547229,"change_date":"2025-05-05 21:40:00","inspection_id":"84582682","insp_violation_id":"266011274","seq_no":"5","part_no":"393","part_no_section":"43D","insp_viol_unit":"2","insp_unit_id":"206646827","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"0LEE25050313441","created_at":"2025-05-08T10:27:14.000000Z","updated_at":"2025-05-09T10:46:07.000000Z","normalized_code":"39343D"},{"id":13547230,"change_date":"2025-05-05 21:40:00","inspection_id":"84582682","insp_violation_id":"266011275","seq_no":"6","part_no":"393","part_no_section":"48A","insp_viol_unit":"2","insp_unit_id":"206646827","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-08T10:27:14.000000Z","updated_at":"2025-05-09T10:46:07.000000Z","normalized_code":"39348A"},{"id":13547231,"change_date":"2025-05-05 21:40:00","inspection_id":"84582682","insp_violation_id":"266011276","seq_no":"7","part_no":"393","part_no_section":"48A","insp_viol_unit":"1","insp_unit_id":"206646826","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-08T10:27:14.000000Z","updated_at":"2025-05-09T10:46:07.000000Z","normalized_code":"39348A"},{"id":13547232,"change_date":"2025-05-05 21:40:00","inspection_id":"84582682","insp_violation_id":"266011277","seq_no":"8","part_no":"393","part_no_section":"48A","insp_viol_unit":"2","insp_unit_id":"206646827","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-08T10:27:14.000000Z","updated_at":"2025-05-09T10:46:07.000000Z","normalized_code":"39348A"},{"id":13547233,"change_date":"2025-05-05 21:40:00","inspection_id":"84582682","insp_violation_id":"266011278","seq_no":"9","part_no":"393","part_no_section":"48A","insp_viol_unit":"2","insp_unit_id":"206646827","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-08T10:27:14.000000Z","updated_at":"2025-05-09T10:46:07.000000Z","normalized_code":"39348A"},{"id":13547234,"change_date":"2025-05-05 21:40:00","inspection_id":"84582682","insp_violation_id":"266011279","seq_no":"10","part_no":"396","part_no_section":"3A1BOS","insp_viol_unit":"1","insp_unit_id":"206646826","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-05-08T10:27:14.000000Z","updated_at":"2025-05-09T10:46:07.000000Z","normalized_code":"3963A1BOS"},{"id":13547235,"change_date":"2025-05-05 21:40:00","inspection_id":"84582682","insp_violation_id":"266011280","seq_no":"11","part_no":"393","part_no_section":"95A","insp_viol_unit":"1","insp_unit_id":"206646826","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-08T10:27:14.000000Z","updated_at":"2025-05-09T10:46:07.000000Z","normalized_code":"39395A"},{"id":13547236,"change_date":"2025-05-05 21:40:00","inspection_id":"84582682","insp_violation_id":"266011281","seq_no":"12","part_no":"395","part_no_section":"24C2III","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-08T10:27:14.000000Z","updated_at":"2025-05-09T10:46:07.000000Z","normalized_code":"39524C2III"},{"id":13547237,"change_date":"2025-05-05 21:40:00","inspection_id":"84582682","insp_violation_id":"266011282","seq_no":"13","part_no":"395","part_no_section":"8E","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-05-08T10:27:14.000000Z","updated_at":"2025-05-09T10:46:07.000000Z","normalized_code":"3958E"},{"id":13547228,"change_date":"2025-05-05 21:40:00","inspection_id":"84582682","insp_violation_id":"266011273","seq_no":"4","part_no":"392","part_no_section":"2IRP","insp_viol_unit":"1","insp_unit_id":"206646826","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"0LEE25050312492","created_at":"2025-05-08T10:27:14.000000Z","updated_at":"2025-05-09T10:46:07.000000Z","normalized_code":"3922IRP"},{"id":13547238,"change_date":"2025-05-05 21:40:00","inspection_id":"84582682","insp_violation_id":"266011283","seq_no":"14","part_no":"395","part_no_section":"8E","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-05-08T10:27:14.000000Z","updated_at":"2025-05-09T10:46:07.000000Z","normalized_code":"3958E"},{"id":13547239,"change_date":"2025-05-05 21:40:00","inspection_id":"84582682","insp_violation_id":"266011284","seq_no":"15","part_no":"395","part_no_section":"8E","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-08T10:27:14.000000Z","updated_at":"2025-05-09T10:46:07.000000Z","normalized_code":"3958E"},{"id":13547240,"change_date":"2025-05-05 21:40:00","inspection_id":"84582682","insp_violation_id":"266011285","seq_no":"16","part_no":"395","part_no_section":"8E","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-08T10:27:14.000000Z","updated_at":"2025-05-09T10:46:07.000000Z","normalized_code":"3958E"},{"id":13547241,"change_date":"2025-05-05 21:40:00","inspection_id":"84582682","insp_violation_id":"266011286","seq_no":"17","part_no":"395","part_no_section":"8E","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-08T10:27:14.000000Z","updated_at":"2025-05-09T10:46:07.000000Z","normalized_code":"3958E"},{"id":13547242,"change_date":"2025-05-05 21:40:00","inspection_id":"84582682","insp_violation_id":"266011287","seq_no":"18","part_no":"395","part_no_section":"8E","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-08T10:27:14.000000Z","updated_at":"2025-05-09T10:46:07.000000Z","normalized_code":"3958E"},{"id":13547243,"change_date":"2025-05-05 21:40:00","inspection_id":"84582682","insp_violation_id":"266011288","seq_no":"19","part_no":"395","part_no_section":"8E","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-08T10:27:14.000000Z","updated_at":"2025-05-09T10:46:07.000000Z","normalized_code":"3958E"},{"id":13547244,"change_date":"2025-05-05 21:40:00","inspection_id":"84582682","insp_violation_id":"266011289","seq_no":"20","part_no":"395","part_no_section":"8E","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-08T10:27:14.000000Z","updated_at":"2025-05-09T10:46:07.000000Z","normalized_code":"3958E"},{"id":13547245,"change_date":"2025-05-05 21:40:00","inspection_id":"84582682","insp_violation_id":"266011290","seq_no":"21","part_no":"395","part_no_section":"3A3-PROP","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"4","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-05-08T10:27:14.000000Z","updated_at":"2025-05-09T10:46:07.000000Z","normalized_code":"3953A3PROP"},{"id":13547246,"change_date":"2025-05-05 21:40:00","inspection_id":"84582682","insp_violation_id":"266011291","seq_no":"22","part_no":"395","part_no_section":"3A2-PROP","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"4","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-05-08T10:27:14.000000Z","updated_at":"2025-05-09T10:46:07.000000Z","normalized_code":"3953A2PROP"}],"inspection_per_units":[{"id":13904129,"change_date":"2025-05-05 21:40:00","inspection_id":"84582682","insp_unit_id":"206646826","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":"3","insp_unit_license":"K128265","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3C63RRHL9KG524162","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-08T09:56:48.000000Z","updated_at":"2025-05-09T10:03:41.000000Z"},{"id":13904130,"change_date":"2025-05-05 21:40:00","inspection_id":"84582682","insp_unit_id":"206646827","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"AME","insp_unit_company":"12","insp_unit_license":"064854M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"17YGA3224MB081620","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-08T09:56:48.000000Z","updated_at":"2025-05-09T10:03:41.000000Z"}]},{"id":8542364,"change_date":"2025-05-04 21:33:00","inspection_id":"84575038","dot_number":"3547997","report_state":"TN","report_number":"I032G40065","insp_date":"2025-05-02 00:00:00","insp_start_time":"1112","insp_end_time":"1130","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"SOUTH PITTSBURG TN","county_code_state":"TN","county_code":"115","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"CHARTER COMMUNICATIONS","shipping_paper_number":"104300997104","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":"U","pen_cen_match":"I","final_status_date":"2025-05-04 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"25900","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":"1681723","transaction_code":"A","transaction_date":"2025-05-04 00:00:00","upload_date":"2025-05-04 00:00:00","upload_first_byte":"0","upload_dot_number":"03547997","upload_search_indicator":null,"census_search_date":"2025-05-04 21:33:00","snet_input_date":"2025-05-02 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-05-04 21:33:00","insp_carrier_name":"CALTEX EXPRESS TRANSPORT LLC","insp_carrier_street":"923 FLORES DEL SOL","insp_carrier_city":"ALAMO","insp_carrier_state":"TX","insp_carrier_zip_code":"78516","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-08T10:02:35.000000Z","updated_at":"2025-05-08T10:02:35.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13890170,"change_date":"2025-05-04 21:33:00","inspection_id":"84575038","insp_unit_id":"206632482","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODGE","insp_unit_company":null,"insp_unit_license":"VFM9733","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3C6UR5HL1KG707021","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-07T10:12:48.000000Z","updated_at":"2025-05-08T09:52:31.000000Z"},{"id":13890171,"change_date":"2025-05-04 21:33:00","inspection_id":"84575038","insp_unit_id":"206632483","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"ACE TRAILE","insp_unit_company":null,"insp_unit_license":"064854M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"17YGA3224MB081620","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-07T10:12:48.000000Z","updated_at":"2025-05-08T09:52:31.000000Z"}]},{"id":8320144,"change_date":"2025-04-08 21:40:00","inspection_id":"84340682","dot_number":"3547997","report_state":"IA","report_number":"000P123G4S","insp_date":"2025-04-07 00:00:00","insp_start_time":"1325","insp_end_time":"1432","registration_date":null,"region":"CT","ci_status_code":"C","location":"39","location_desc":"39 - I35 SB MM 212 NORTHWOOD","county_code_state":"IA","county_code":"195","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"CALTEX AUTO SALES","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":"2025-04-08 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"3","oos_total":"1","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1355842","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":"03547997","upload_search_indicator":"M","census_search_date":"2025-04-08 21:40:00","snet_input_date":"2025-04-07 00:00:00","source_office":"3IAS001","mcmis_add_date":"2025-04-08 21:40:00","insp_carrier_name":"CALTEX EXPRESS TRANSPORT LLC","insp_carrier_street":"923 FLORES DEL SOL","insp_carrier_city":"ALAMO","insp_carrier_state":"TX","insp_carrier_zip_code":"78516","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-11T10:12:19.000000Z","updated_at":"2025-04-12T10:22:00.000000Z","inspection_violations":[{"id":13093174,"change_date":"2025-04-08 21:40:00","inspection_id":"84340682","insp_violation_id":"265497519","seq_no":"1","part_no":"392","part_no_section":"2C","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"1LOP25040714161","created_at":"2025-04-11T10:39:14.000000Z","updated_at":"2025-04-11T10:46:59.000000Z","normalized_code":"3922C"},{"id":13093175,"change_date":"2025-04-08 21:40:00","inspection_id":"84340682","insp_violation_id":"265497520","seq_no":"2","part_no":"393","part_no_section":"60D","insp_viol_unit":"1","insp_unit_id":"206203903","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-11T10:39:14.000000Z","updated_at":"2025-04-11T10:46:59.000000Z","normalized_code":"39360D"},{"id":13093176,"change_date":"2025-04-08 21:40:00","inspection_id":"84340682","insp_violation_id":"265497521","seq_no":"3","part_no":"393","part_no_section":"43D","insp_viol_unit":"2","insp_unit_id":"206203904","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-04-11T10:39:14.000000Z","updated_at":"2025-04-11T10:46:59.000000Z","normalized_code":"39343D"}],"inspection_per_units":[{"id":13493913,"change_date":"2025-04-08 21:40:00","inspection_id":"84340682","insp_unit_id":"206203903","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":"3","insp_unit_license":"VFM9733","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3C63RRHL9KG524162","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-11T10:04:49.000000Z","updated_at":"2025-04-12T09:59:33.000000Z"},{"id":13493914,"change_date":"2025-04-08 21:40:00","inspection_id":"84340682","insp_unit_id":"206203904","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CALTEX","insp_unit_company":null,"insp_unit_license":"205C588","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4C9GF4023NM546337","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-11T10:04:49.000000Z","updated_at":"2025-04-12T09:59:33.000000Z"}]},{"id":8249630,"change_date":"2025-05-07 21:44:00","inspection_id":"84266549","dot_number":"3547997","report_state":"TN","report_number":"I01R101182","insp_date":"2025-03-28 00:00:00","insp_start_time":"1310","insp_end_time":"1350","registration_date":null,"region":"CT","ci_status_code":"C","location":"HAYWDE","location_desc":"HAYWOOD COUNTY SCALES EB","county_code_state":"TN","county_code":"075","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"16061165758","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":"2025-03-30 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"21500","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":"1822488","transaction_code":"C","transaction_date":"2025-04-07 00:00:00","upload_date":"2025-05-06 00:00:00","upload_first_byte":"0","upload_dot_number":"03547997","upload_search_indicator":null,"census_search_date":"2025-03-30 21:33:00","snet_input_date":"2025-03-28 00:00:00","source_office":"2TNS001","mcmis_add_date":"2025-03-30 21:33:00","insp_carrier_name":"CALTEX EXPRESS TRANSPORT LLC","insp_carrier_street":"923 FLORES DEL SOL","insp_carrier_city":"ALAMO","insp_carrier_state":"TX","insp_carrier_zip_code":"78516","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-02T10:01:08.000000Z","updated_at":"2025-05-11T10:14:44.000000Z","inspection_violations":[{"id":13593919,"change_date":"2025-05-07 21:44:00","inspection_id":"84266549","insp_violation_id":"266063940","seq_no":"2","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"206691496","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-05-09T11:18:54.000000Z","updated_at":"2025-05-10T11:32:52.000000Z","normalized_code":"39617CPI"},{"id":13593918,"change_date":"2025-05-07 21:44:00","inspection_id":"84266549","insp_violation_id":"266063939","seq_no":"1","part_no":"393","part_no_section":"43D-B","insp_viol_unit":"1","insp_unit_id":"206691496","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"1","citation_number":null,"created_at":"2025-05-09T11:18:54.000000Z","updated_at":"2025-05-10T11:32:52.000000Z","normalized_code":"39343DB"},{"id":13593920,"change_date":"2025-05-07 21:44:00","inspection_id":"84266549","insp_violation_id":"266063941","seq_no":"3","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"1","insp_unit_id":"206691496","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-05-09T11:18:54.000000Z","updated_at":"2025-05-10T11:32:52.000000Z","normalized_code":"39617CPI"}],"inspection_per_units":[{"id":13954014,"change_date":"2025-05-07 21:44:00","inspection_id":"84266549","insp_unit_id":"206691496","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"TRUK","insp_unit_company":"004","insp_unit_license":"VZG1969","insp_unit_license_state":"UK","insp_unit_vehicle_id_number":"3C6UR5HL1KG707021","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-10T10:29:13.000000Z","updated_at":"2025-05-11T03:15:48.000000Z"},{"id":13954015,"change_date":"2025-05-07 21:44:00","inspection_id":"84266549","insp_unit_id":"206691497","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":"004","insp_unit_license":"069606N","insp_unit_license_state":"UK","insp_unit_vehicle_id_number":"1P9GF3526LL375277","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-10T10:29:13.000000Z","updated_at":"2025-05-11T03:15:48.000000Z"}]},{"id":7657062,"change_date":"2025-05-07 21:46:00","inspection_id":"83643642","dot_number":"3547997","report_state":"TN","report_number":"I031P70068","insp_date":"2025-01-16 00:00:00","insp_start_time":"1140","insp_end_time":"1227","registration_date":null,"region":"ET","ci_status_code":"C","location":"UNK","location_desc":"INTERSTATE 75","county_code_state":"TN","county_code":"013","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"618-25","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":"2025-01-18 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"25900","viol_total":"1","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":"1802119","transaction_code":"C","transaction_date":"2025-01-29 00:00:00","upload_date":"2025-05-06 00:00:00","upload_first_byte":"0","upload_dot_number":"03547997","upload_search_indicator":null,"census_search_date":"2025-01-18 21:33:00","snet_input_date":"2025-01-16 00:00:00","source_office":"2TNS001","mcmis_add_date":"2025-01-18 21:33:00","insp_carrier_name":"CALTEX EXPRESS TRANSPORT LLC","insp_carrier_street":"923 FLORES DEL SOL","insp_carrier_city":"ALAMO","insp_carrier_state":"TX","insp_carrier_zip_code":"78516","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:57:04.000000Z","updated_at":"2025-05-11T10:20:14.000000Z","inspection_violations":[{"id":11963043,"change_date":"2025-01-18 21:33:00","inspection_id":"83643642","insp_violation_id":"264070997","seq_no":"1","part_no":"393","part_no_section":"60D","insp_viol_unit":"1","insp_unit_id":"204906737","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T22:04:18.000000Z","updated_at":"2025-03-17T22:04:18.000000Z","normalized_code":"39360D"}],"inspection_per_units":[{"id":13981644,"change_date":"2025-05-07 21:46:00","inspection_id":"83643642","insp_unit_id":"206731873","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"K127966","insp_unit_license_state":"UK","insp_unit_vehicle_id_number":"1FT7W2BT1KED37735","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-10T15:24:32.000000Z","updated_at":"2025-05-11T03:51:08.000000Z"},{"id":13981645,"change_date":"2025-05-07 21:46:00","inspection_id":"83643642","insp_unit_id":"206731874","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIGT","insp_unit_company":null,"insp_unit_license":"205C588","insp_unit_license_state":"UK","insp_unit_vehicle_id_number":"16V3F3829R6316711","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-10T15:24:32.000000Z","updated_at":"2025-05-11T03:51:08.000000Z"}]},{"id":7565658,"change_date":"2025-01-07 21:40:00","inspection_id":"83547717","dot_number":"3547997","report_state":"IA","report_number":"000P120DCN","insp_date":"2025-01-06 00:00:00","insp_start_time":"1330","insp_end_time":"1430","registration_date":null,"region":"CT","ci_status_code":"C","location":"39","location_desc":"39 - I35 SB MM 212 NORTHWOOD","county_code_state":"IA","county_code":"195","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"CALTEX EXPRESS TRANSPORT LLC","shipping_paper_number":"2137","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":"2025-01-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"22000","viol_total":"4","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1344777","transaction_code":"A","transaction_date":"2025-01-07 00:00:00","upload_date":"2025-01-07 00:00:00","upload_first_byte":"0","upload_dot_number":"03547997","upload_search_indicator":"M","census_search_date":"2025-01-07 21:40:00","snet_input_date":"2025-01-06 00:00:00","source_office":"3IAS001","mcmis_add_date":"2025-01-07 21:40:00","insp_carrier_name":"CALTEX EXPRESS TRANSPORT LLC","insp_carrier_street":"923 FLORES DEL SOL","insp_carrier_city":"ALAMO","insp_carrier_state":"TX","insp_carrier_zip_code":"78516","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:55:15.000000Z","updated_at":"2025-03-17T20:55:15.000000Z","inspection_violations":[{"id":11825829,"change_date":"2025-01-07 21:40:00","inspection_id":"83547717","insp_violation_id":"263793943","seq_no":"1","part_no":"393","part_no_section":"60D","insp_viol_unit":"1","insp_unit_id":"204687754","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:38.000000Z","updated_at":"2025-03-17T22:03:38.000000Z","normalized_code":"39360D"},{"id":11825830,"change_date":"2025-01-07 21:40:00","inspection_id":"83547717","insp_violation_id":"263793944","seq_no":"2","part_no":"392","part_no_section":"2C","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"3KOO25010613481","created_at":"2025-03-17T22:03:38.000000Z","updated_at":"2025-03-17T22:03:38.000000Z","normalized_code":"3922C"},{"id":11825831,"change_date":"2025-01-07 21:40:00","inspection_id":"83547717","insp_violation_id":"263793945","seq_no":"3","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"204687755","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:03:38.000000Z","updated_at":"2025-03-17T22:03:38.000000Z","normalized_code":"3939"},{"id":11825832,"change_date":"2025-01-07 21:40:00","inspection_id":"83547717","insp_violation_id":"263793946","seq_no":"4","part_no":"395","part_no_section":"8A-ELD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:03:38.000000Z","updated_at":"2025-03-17T22:03:38.000000Z","normalized_code":"3958AELD"}],"inspection_per_units":[{"id":12207056,"change_date":"2025-01-07 21:40:00","inspection_id":"83547717","insp_unit_id":"204687754","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":"7021","insp_unit_license":"K127966","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3C6UR5HL1KG707021","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:49:45.000000Z","updated_at":"2025-03-17T23:49:45.000000Z"},{"id":12207057,"change_date":"2025-01-07 21:40:00","inspection_id":"83547717","insp_unit_id":"204687755","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"CAL","insp_unit_company":"6337","insp_unit_license":"205C588","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4C9GF4023NM546337","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:49:45.000000Z","updated_at":"2025-03-17T23:49:45.000000Z"}]},{"id":7076664,"change_date":"2024-10-30 21:40:00","inspection_id":"83032087","dot_number":"3547997","report_state":"TN","report_number":"I032G90056","insp_date":"2024-10-28 00:00:00","insp_start_time":"2355","insp_end_time":"0029","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"MANCHESTER TN","county_code_state":"TN","county_code":"031","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"STATESBORO MFG","shipping_paper_number":"3793430","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":"U","pen_cen_match":"I","final_status_date":"2024-10-30 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25900","viol_total":"1","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":"999019","transaction_code":"A","transaction_date":"2024-10-30 00:00:00","upload_date":"2024-10-30 00:00:00","upload_first_byte":"0","upload_dot_number":"03547997","upload_search_indicator":null,"census_search_date":"2024-10-30 21:40:00","snet_input_date":"2024-10-29 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-10-30 21:40:00","insp_carrier_name":"CALTEX EXPRESS TRANSPORT LLC","insp_carrier_street":"923 FLORES DEL SOL","insp_carrier_city":"ALAMO","insp_carrier_state":"TX","insp_carrier_zip_code":"78516","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:43:29.000000Z","updated_at":"2025-03-17T20:43:29.000000Z","inspection_violations":[{"id":11047858,"change_date":"2024-10-30 21:40:00","inspection_id":"83032087","insp_violation_id":"262626148","seq_no":"1","part_no":"392","part_no_section":"2-SLLTCD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:37.000000Z","updated_at":"2025-03-17T21:59:37.000000Z","normalized_code":"3922SLLTCD"}],"inspection_per_units":[{"id":11412965,"change_date":"2024-10-30 21:40:00","inspection_id":"83032087","insp_unit_id":"203647258","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODGE","insp_unit_company":"01","insp_unit_license":"VFM9733","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3C63RRHL9KG524162","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:41:10.000000Z","updated_at":"2025-03-17T23:41:10.000000Z"},{"id":11412966,"change_date":"2024-10-30 21:40:00","inspection_id":"83032087","insp_unit_id":"203647259","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"AMERICAN T","insp_unit_company":"01","insp_unit_license":"064854M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"17YGA3224MB081620","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:41:10.000000Z","updated_at":"2025-03-17T23:41:10.000000Z"}]},{"id":6987586,"change_date":"2024-10-18 21:42:00","inspection_id":"82937644","dot_number":"3547997","report_state":"MD","report_number":"2345001255","insp_date":"2024-10-17 00:00:00","insp_start_time":"0955","insp_end_time":"1115","registration_date":null,"region":"ET","ci_status_code":"C","location":"037","location_desc":"BALTIMORE CITY","county_code_state":"MD","county_code":"510","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-10-18 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"37900","viol_total":"4","oos_total":"2","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"3","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2755070","transaction_code":"A","transaction_date":"2024-10-17 00:00:00","upload_date":"2024-10-18 00:00:00","upload_first_byte":"0","upload_dot_number":"03547997","upload_search_indicator":null,"census_search_date":"2024-10-18 21:42:00","snet_input_date":"2024-10-17 00:00:00","source_office":"1MDS001","mcmis_add_date":"2024-10-18 21:42:00","insp_carrier_name":"CALTEX EXPRESS TRANSPORT LLC","insp_carrier_street":"923 FLORES DEL SOL","insp_carrier_city":"ALAMO","insp_carrier_state":"TX","insp_carrier_zip_code":"78516","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:41:47.000000Z","updated_at":"2025-03-17T20:41:47.000000Z","inspection_violations":[{"id":10901589,"change_date":"2024-10-18 21:42:00","inspection_id":"82937644","insp_violation_id":"262423423","seq_no":"1","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"1","insp_unit_id":"203470107","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:54.000000Z","updated_at":"2025-03-17T21:58:54.000000Z","normalized_code":"3939ALIL"},{"id":10901590,"change_date":"2024-10-18 21:42:00","inspection_id":"82937644","insp_violation_id":"262423424","seq_no":"2","part_no":"393","part_no_section":"75A3-TAOL","insp_viol_unit":"2","insp_unit_id":"203470108","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"4H70V24","created_at":"2025-03-17T21:58:54.000000Z","updated_at":"2025-03-17T21:58:54.000000Z","normalized_code":"39375A3TAOL"},{"id":10901591,"change_date":"2024-10-18 21:42:00","inspection_id":"82937644","insp_violation_id":"262423425","seq_no":"3","part_no":"393","part_no_section":"75A1","insp_viol_unit":"2","insp_unit_id":"203470108","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:54.000000Z","updated_at":"2025-03-17T21:58:54.000000Z","normalized_code":"39375A1"},{"id":10901592,"change_date":"2024-10-18 21:42:00","inspection_id":"82937644","insp_violation_id":"262423426","seq_no":"4","part_no":"395","part_no_section":"8E-HOSPDOOS","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:54.000000Z","updated_at":"2025-03-17T21:58:54.000000Z","normalized_code":"3958EHOSPDOOS"}],"inspection_per_units":[{"id":11270426,"change_date":"2024-10-18 21:42:00","inspection_id":"82937644","insp_unit_id":"203470107","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":null,"insp_unit_license":"K115021","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3C63RRGL1GG143866","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:39:42.000000Z","updated_at":"2025-03-17T23:39:42.000000Z"},{"id":11270427,"change_date":"2024-10-18 21:42:00","inspection_id":"82937644","insp_unit_id":"203470108","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIGT","insp_unit_company":null,"insp_unit_license":"128C946","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"16VGX3524K6086018","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:39:42.000000Z","updated_at":"2025-03-17T23:39:42.000000Z"}]},{"id":6795979,"change_date":"2024-09-23 21:41:00","inspection_id":"82734194","dot_number":"3547997","report_state":"IA","report_number":"000P141H8W","insp_date":"2024-09-22 00:00:00","insp_start_time":"1145","insp_end_time":"1220","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"NB I35 HANLONTOWN","county_code_state":"IA","county_code":"195","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"HOUSTON TUBLARS INC","shipping_paper_number":"79424842","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":"N","pen_cen_match":null,"final_status_date":"2024-09-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"30000","viol_total":"2","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1330399","transaction_code":"A","transaction_date":"2024-09-23 00:00:00","upload_date":"2024-09-23 00:00:00","upload_first_byte":"0","upload_dot_number":"03547997","upload_search_indicator":"M","census_search_date":"2024-09-23 21:41:00","snet_input_date":"2024-09-22 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-09-23 21:41:00","insp_carrier_name":"CALTEX EXPRESS TRANSPORT LLC","insp_carrier_street":"923 FLORES DEL SOL","insp_carrier_city":"ALAMO","insp_carrier_state":"TX","insp_carrier_zip_code":"78516","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:37:46.000000Z","updated_at":"2025-03-17T20:37:46.000000Z","inspection_violations":[{"id":10583731,"change_date":"2024-09-23 21:41:00","inspection_id":"82734194","insp_violation_id":"261982780","seq_no":"1","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"8WAA24092212013","created_at":"2025-03-17T21:57:16.000000Z","updated_at":"2025-03-17T21:57:16.000000Z","normalized_code":"38323A2"},{"id":10583732,"change_date":"2024-09-23 21:41:00","inspection_id":"82734194","insp_violation_id":"261982781","seq_no":"2","part_no":"395","part_no_section":"8(e)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:57:16.000000Z","updated_at":"2025-03-17T21:57:16.000000Z","normalized_code":"3958E1"}],"inspection_per_units":[{"id":10959160,"change_date":"2024-09-23 21:41:00","inspection_id":"82734194","insp_unit_id":"203082813","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":"00","insp_unit_license":"VFM9733","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3C63RRHL9KG524162","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:31.000000Z","updated_at":"2025-03-17T23:36:31.000000Z"},{"id":10959161,"change_date":"2024-09-23 21:41:00","inspection_id":"82734194","insp_unit_id":"203082814","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIGT","insp_unit_company":"00","insp_unit_license":"224579M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"16V3F4822M6070499","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:31.000000Z","updated_at":"2025-03-17T23:36:31.000000Z"}]},{"id":6787641,"change_date":"2024-09-22 21:33:00","inspection_id":"82725210","dot_number":"3547997","report_state":"TN","report_number":"I039280055","insp_date":"2024-09-20 00:00:00","insp_start_time":"1350","insp_end_time":"1429","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"EASTVIEW TN","county_code_state":"TN","county_code":"109","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"INDIANA GRATINGS","shipping_paper_number":"132467","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":"U","pen_cen_match":"I","final_status_date":"2024-09-22 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"21500","viol_total":"1","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":"871415","transaction_code":"A","transaction_date":"2024-09-22 00:00:00","upload_date":"2024-09-22 00:00:00","upload_first_byte":"0","upload_dot_number":"03547997","upload_search_indicator":null,"census_search_date":"2024-09-22 21:33:00","snet_input_date":"2024-09-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-09-22 21:33:00","insp_carrier_name":"CALTEX EXPRESS TRANSPORT LLC","insp_carrier_street":"923 FLORES DEL SOL","insp_carrier_city":"ALAMO","insp_carrier_state":"TX","insp_carrier_zip_code":"78516","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:37:44.000000Z","updated_at":"2025-03-17T20:37:44.000000Z","inspection_violations":[{"id":10570745,"change_date":"2024-09-22 21:33:00","inspection_id":"82725210","insp_violation_id":"261964717","seq_no":"1","part_no":"393","part_no_section":"95(a)(1)","insp_viol_unit":"1","insp_unit_id":"203066474","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"VERBAL","created_at":"2025-03-17T21:57:11.000000Z","updated_at":"2025-03-17T21:57:11.000000Z","normalized_code":"39395A1"}],"inspection_per_units":[{"id":10945714,"change_date":"2024-09-22 21:33:00","inspection_id":"82725210","insp_unit_id":"203066474","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODGE","insp_unit_company":"MS04","insp_unit_license":"K128302","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3C6UR5HL1KG707021","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:24.000000Z","updated_at":"2025-03-17T23:36:24.000000Z"},{"id":10945715,"change_date":"2024-09-22 21:33:00","inspection_id":"82725210","insp_unit_id":"203066475","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EZZ PULL","insp_unit_company":"06-A","insp_unit_license":"792467K","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1P9GF3526LL375277","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:36:24.000000Z","updated_at":"2025-03-17T23:36:24.000000Z"}]},{"id":6267089,"change_date":"2024-07-21 21:32:00","inspection_id":"82169567","dot_number":"3547997","report_state":"OK","report_number":"H800154137","insp_date":"2024-07-19 00:00:00","insp_start_time":"1746","insp_end_time":"1810","registration_date":null,"region":"CT","ci_status_code":"C","location":"64375","location_desc":"OK375 18MM NB","county_code_state":"OK","county_code":"127","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"REI","shipping_paper_number":"77231","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":"2024-07-21 21:32:00","post_acc_ind":"N","gross_comb_veh_wt":"39900","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":"755025","transaction_code":"A","transaction_date":"2024-07-19 00:00:00","upload_date":"2024-07-21 00:00:00","upload_first_byte":"0","upload_dot_number":"03547997","upload_search_indicator":null,"census_search_date":"2024-07-21 21:32:00","snet_input_date":"2024-07-19 00:00:00","source_office":"2OKS001","mcmis_add_date":"2024-07-21 21:32:00","insp_carrier_name":"CALTEX EXPRESS TRANSPORT LLC","insp_carrier_street":"923 FLORES DEL SOL","insp_carrier_city":"ALAMO","insp_carrier_state":"TX","insp_carrier_zip_code":"78516","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:27:00.000000Z","updated_at":"2025-03-17T20:27:00.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10097424,"change_date":"2024-07-21 21:32:00","inspection_id":"82169567","insp_unit_id":"201983988","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":null,"insp_unit_license":"K152605","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3C63RRHL9JG268104","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:27:38.000000Z","updated_at":"2025-03-17T23:27:38.000000Z"},{"id":10097425,"change_date":"2024-07-21 21:32:00","inspection_id":"82169567","insp_unit_id":"201983989","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"655838K","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4ZEGH4029F1077299","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:27:38.000000Z","updated_at":"2025-03-17T23:27:38.000000Z"}]},{"id":6059879,"change_date":"2024-06-24 21:42:00","inspection_id":"81947127","dot_number":"3547997","report_state":"MS","report_number":"7649010609","insp_date":"2024-06-21 00:00:00","insp_start_time":"1334","insp_end_time":"1430","registration_date":null,"region":"CT","ci_status_code":"C","location":"57","location_desc":"OSYKA INSP. STATION","county_code_state":"MS","county_code":"113","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"FAUBORG BREWERY","shipping_paper_number":"386773","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":"2024-06-24 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":null,"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":"1071566","transaction_code":"A","transaction_date":"2024-06-21 00:00:00","upload_date":"2024-06-24 00:00:00","upload_first_byte":"0","upload_dot_number":"03547997","upload_search_indicator":null,"census_search_date":"2024-06-24 21:42:00","snet_input_date":"2024-06-24 00:00:00","source_office":"2MSS002","mcmis_add_date":"2024-06-24 21:42:00","insp_carrier_name":"CALTEX EXPRESS TRANSPORT LLC","insp_carrier_street":"923 FLORES DEL SOL","insp_carrier_city":"ALAMO","insp_carrier_state":"TX","insp_carrier_zip_code":"78516","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:22:40.000000Z","updated_at":"2025-03-17T20:22:40.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9760001,"change_date":"2024-06-24 21:42:00","inspection_id":"81947127","insp_unit_id":"201554265","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":"MM11","insp_unit_license":"K152605","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3C63RRHL9JG268104","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:24:07.000000Z","updated_at":"2025-03-17T23:24:07.000000Z"},{"id":9760002,"change_date":"2024-06-24 21:42:00","inspection_id":"81947127","insp_unit_id":"201554266","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":"MS005","insp_unit_license":"655838K","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4ZEGH4029F1077299","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:24:07.000000Z","updated_at":"2025-03-17T23:24:07.000000Z"}]},{"id":5605832,"change_date":"2024-05-02 21:42:00","inspection_id":"81454295","dot_number":"3547997","report_state":"AL","report_number":"1822000113","insp_date":"2024-04-26 00:00:00","insp_start_time":"1257","insp_end_time":"1428","registration_date":"2024-05-02 00:00:00","region":"CT","ci_status_code":"C","location":"52","location_desc":"EXIT RAMP","county_code_state":"AL","county_code":"103","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"RAILWAY SYSTEMS","shipping_paper_number":"5136871","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":"N","pen_cen_match":null,"final_status_date":"2024-04-26 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"39900","viol_total":"3","oos_total":"0","driver_viol_total":"3","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1002503","transaction_code":"C","transaction_date":"2024-04-27 00:00:00","upload_date":"2024-05-02 00:00:00","upload_first_byte":"0","upload_dot_number":"03547997","upload_search_indicator":null,"census_search_date":"2024-04-26 21:39:00","snet_input_date":"2024-04-26 00:00:00","source_office":"2ALS001","mcmis_add_date":"2024-04-26 21:39:00","insp_carrier_name":"CALTEX EXPRESS TRANSPORT LLC","insp_carrier_street":"923 FLORES DEL SOL","insp_carrier_city":"ALAMO","insp_carrier_state":"TX","insp_carrier_zip_code":"78516","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:13:51.000000Z","updated_at":"2025-03-17T20:13:51.000000Z","inspection_violations":[{"id":8667652,"change_date":"2024-05-02 21:42:00","inspection_id":"81454295","insp_violation_id":"259279262","seq_no":"1","part_no":"395","part_no_section":"8(e)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"U4624295","created_at":"2025-03-17T21:47:58.000000Z","updated_at":"2025-03-17T21:47:58.000000Z","normalized_code":"3958E1"},{"id":8667653,"change_date":"2024-05-02 21:42:00","inspection_id":"81454295","insp_violation_id":"259279263","seq_no":"2","part_no":"395","part_no_section":"8(e)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:58.000000Z","updated_at":"2025-03-17T21:47:58.000000Z","normalized_code":"3958E1"},{"id":8667654,"change_date":"2024-05-02 21:42:00","inspection_id":"81454295","insp_violation_id":"259279264","seq_no":"3","part_no":"395","part_no_section":"8(e)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:47:58.000000Z","updated_at":"2025-03-17T21:47:58.000000Z","normalized_code":"3958E1"}],"inspection_per_units":[{"id":9029658,"change_date":"2024-05-02 21:42:00","inspection_id":"81454295","insp_unit_id":"200695102","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":"MS05","insp_unit_license":"K152605","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3C63RRHL9JG268104","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:00.000000Z","updated_at":"2025-03-17T23:17:00.000000Z"},{"id":9029659,"change_date":"2024-05-02 21:42:00","inspection_id":"81454295","insp_unit_id":"200695103","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":"MS005","insp_unit_license":"655838K","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4ZEGH4029F1077299","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:17:00.000000Z","updated_at":"2025-03-17T23:17:00.000000Z"}]},{"id":5575760,"change_date":"2024-04-23 21:41:00","inspection_id":"81421540","dot_number":"3547997","report_state":"IA","report_number":"000P144SFV","insp_date":"2024-04-21 00:00:00","insp_start_time":"1609","insp_end_time":"1645","registration_date":null,"region":"CT","ci_status_code":"C","location":"10","location_desc":"10 - I35 NB MM 30 OSCEOLA","county_code_state":"IA","county_code":"039","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"WESTERN LOGISTICS EXP","shipping_paper_number":"200003240424","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":"2024-04-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"39900","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":"1310229","transaction_code":"A","transaction_date":"2024-04-23 00:00:00","upload_date":"2024-04-23 00:00:00","upload_first_byte":"0","upload_dot_number":"03547997","upload_search_indicator":"M","census_search_date":"2024-04-23 21:41:00","snet_input_date":"2024-04-21 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-04-23 21:41:00","insp_carrier_name":"CALTEX EXPRESS TRANSPORT LLC","insp_carrier_street":"923 FLORES DEL SOL","insp_carrier_city":"ALAMO","insp_carrier_state":"TX","insp_carrier_zip_code":"78516","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:13:10.000000Z","updated_at":"2025-03-17T20:13:10.000000Z","inspection_violations":[],"inspection_per_units":[{"id":8981540,"change_date":"2024-04-23 21:41:00","inspection_id":"81421540","insp_unit_id":"200529921","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":"MM11","insp_unit_license":"K152605","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3C63RRHL9JG268104","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:16:35.000000Z","updated_at":"2025-03-17T23:16:35.000000Z"},{"id":8981541,"change_date":"2024-04-23 21:41:00","inspection_id":"81421540","insp_unit_id":"200529922","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LOADTRIAL","insp_unit_company":"MS005","insp_unit_license":"655838K","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4ZEGH4029F1077299","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:16:35.000000Z","updated_at":"2025-03-17T23:16:35.000000Z"}]},{"id":4693950,"change_date":"2023-12-22 21:41:00","inspection_id":"80458898","dot_number":"3547997","report_state":"IA","report_number":"000P13DL8P","insp_date":"2023-12-20 00:00:00","insp_start_time":"1224","insp_end_time":"1300","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 75 NB & HWY 60","county_code_state":"IA","county_code":"149","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"NA","shipping_paper_number":"NA","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":"N","pen_cen_match":null,"final_status_date":"2023-12-22 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"21500","viol_total":"6","oos_total":"1","driver_viol_total":"5","driver_oos_total":"1","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1298071","transaction_code":"A","transaction_date":"2023-12-21 00:00:00","upload_date":"2023-12-21 00:00:00","upload_first_byte":"0","upload_dot_number":"03547997","upload_search_indicator":"M","census_search_date":"2023-12-22 21:41:00","snet_input_date":"2023-12-20 00:00:00","source_office":"3IAS001","mcmis_add_date":"2023-12-22 21:41:00","insp_carrier_name":"CALTEX EXPRESS TRANSPORT LLC","insp_carrier_street":"923 FLORES DEL SOL","insp_carrier_city":"ALAMO","insp_carrier_state":"TX","insp_carrier_zip_code":"78516","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:55:48.000000Z","updated_at":"2025-03-17T19:55:48.000000Z","inspection_violations":[{"id":7253472,"change_date":"2023-12-22 21:41:00","inspection_id":"80458898","insp_violation_id":"257032020","seq_no":"1","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"198641966","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:01.000000Z","updated_at":"2025-03-17T21:41:01.000000Z","normalized_code":"39617C"},{"id":7253473,"change_date":"2023-12-22 21:41:00","inspection_id":"80458898","insp_violation_id":"257032021","seq_no":"2","part_no":"395","part_no_section":"8(e)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:01.000000Z","updated_at":"2025-03-17T21:41:01.000000Z","normalized_code":"3958E1"},{"id":7253474,"change_date":"2023-12-22 21:41:00","inspection_id":"80458898","insp_violation_id":"257032022","seq_no":"3","part_no":"395","part_no_section":"22(g)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"7HIL23122012532","created_at":"2025-03-17T21:41:01.000000Z","updated_at":"2025-03-17T21:41:01.000000Z","normalized_code":"39522G"},{"id":7253475,"change_date":"2023-12-22 21:41:00","inspection_id":"80458898","insp_violation_id":"257032023","seq_no":"4","part_no":"395","part_no_section":"26(b)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:01.000000Z","updated_at":"2025-03-17T21:41:01.000000Z","normalized_code":"39526B"},{"id":7253476,"change_date":"2023-12-22 21:41:00","inspection_id":"80458898","insp_violation_id":"257032024","seq_no":"5","part_no":"395","part_no_section":"8(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"7HIL23122012492","created_at":"2025-03-17T21:41:01.000000Z","updated_at":"2025-03-17T21:41:01.000000Z","normalized_code":"3958A1"},{"id":7253477,"change_date":"2023-12-22 21:41:00","inspection_id":"80458898","insp_violation_id":"257032025","seq_no":"6","part_no":"395","part_no_section":"3(a)(3)(ii)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:41:01.000000Z","updated_at":"2025-03-17T21:41:01.000000Z","normalized_code":"3953A3II"}],"inspection_per_units":[{"id":7550179,"change_date":"2023-12-22 21:41:00","inspection_id":"80458898","insp_unit_id":"198641966","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":"MS04","insp_unit_license":"K128302","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3C6UR5HL1KG707021","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:03:31.000000Z","updated_at":"2025-03-17T23:03:31.000000Z"},{"id":7550180,"change_date":"2023-12-22 21:41:00","inspection_id":"80458898","insp_unit_id":"198641967","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"PUL","insp_unit_company":"36391","insp_unit_license":"792467K","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1P9GF3526LL375277","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:03:31.000000Z","updated_at":"2025-03-17T23:03:31.000000Z"}]},{"id":4537757,"change_date":"2023-12-01 21:42:00","inspection_id":"80287445","dot_number":"3547997","report_state":"TN","report_number":"TFHS000103","insp_date":"2023-11-30 00:00:00","insp_start_time":"1100","insp_end_time":"1140","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"I-24 E BRAKE CHECK STATION","county_code_state":"TN","county_code":"115","insp_level_id":"1","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":"MULLINS MECHANICAL","shipping_paper_number":"0549543","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":"I","final_status_date":"2023-12-01 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"21500","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":"1693633","transaction_code":"A","transaction_date":"2023-11-30 00:00:00","upload_date":"2023-12-01 00:00:00","upload_first_byte":"0","upload_dot_number":"03547997","upload_search_indicator":null,"census_search_date":"2023-12-01 21:42:00","snet_input_date":"2023-12-01 00:00:00","source_office":"2TNS001","mcmis_add_date":"2023-12-01 21:42:00","insp_carrier_name":"CALTEX EXPRESS TRANSPORT LLC","insp_carrier_street":"923 FLORES DEL SOL","insp_carrier_city":"ALAMO","insp_carrier_state":"TX","insp_carrier_zip_code":"78516-1651","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:52:37.000000Z","updated_at":"2025-03-17T19:52:37.000000Z","inspection_violations":[],"inspection_per_units":[{"id":7297929,"change_date":"2023-12-01 21:42:00","inspection_id":"80287445","insp_unit_id":"198305398","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":"MS04","insp_unit_license":"K128302","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3C6UR5HL1KG707021","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:18.000000Z","updated_at":"2025-03-17T23:01:18.000000Z"},{"id":7297930,"change_date":"2023-12-01 21:42:00","inspection_id":"80287445","insp_unit_id":"198305399","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNK","insp_unit_company":"36391","insp_unit_license":"792467K","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1P9GF3526LL375277","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:01:18.000000Z","updated_at":"2025-03-17T23:01:18.000000Z"}]},{"id":4013733,"change_date":"2023-09-20 21:39:00","inspection_id":"79707999","dot_number":"3547997","report_state":"WI","report_number":"L050000099","insp_date":"2023-09-19 00:00:00","insp_start_time":"1350","insp_end_time":"1516","registration_date":null,"region":"CT","ci_status_code":"C","location":"71(67)","location_desc":"NEW BERLIN (CITY)","county_code_state":"WI","county_code":"133","insp_level_id":"1","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":"CALTEX EXPRESS TRANSPORT 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":"I","final_status_date":"2023-09-20 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"21500","viol_total":"6","oos_total":"3","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"5","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"907046","transaction_code":"A","transaction_date":"2023-09-20 00:00:00","upload_date":"2023-09-20 00:00:00","upload_first_byte":"0","upload_dot_number":"03547997","upload_search_indicator":"M","census_search_date":"2023-09-20 21:39:00","snet_input_date":"2023-09-20 00:00:00","source_office":"3WIS001","mcmis_add_date":"2023-09-20 21:39:00","insp_carrier_name":"CALTEX EXPRESS TRANSPORT LLC","insp_carrier_street":"923 FLORES DEL SOL","insp_carrier_city":"ALAMO","insp_carrier_state":"TX","insp_carrier_zip_code":"78516","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:42:03.000000Z","updated_at":"2025-03-17T19:42:03.000000Z","inspection_violations":[{"id":6210486,"change_date":"2023-09-20 21:39:00","inspection_id":"79707999","insp_violation_id":"255374743","seq_no":"1","part_no":"395","part_no_section":"8(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:58.000000Z","updated_at":"2025-03-17T21:35:58.000000Z","normalized_code":"3958A1"},{"id":6210487,"change_date":"2023-09-20 21:39:00","inspection_id":"79707999","insp_violation_id":"255374744","seq_no":"2","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"197145174","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:58.000000Z","updated_at":"2025-03-17T21:35:58.000000Z","normalized_code":"39360C"},{"id":6210488,"change_date":"2023-09-20 21:39:00","inspection_id":"79707999","insp_violation_id":"255374745","seq_no":"3","part_no":"393","part_no_section":"43","insp_viol_unit":"2","insp_unit_id":"197145175","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:35:58.000000Z","updated_at":"2025-03-17T21:35:58.000000Z","normalized_code":"39343"},{"id":6210489,"change_date":"2023-09-20 21:39:00","inspection_id":"79707999","insp_violation_id":"255374746","seq_no":"4","part_no":"393","part_no_section":"71(h)(10)","insp_viol_unit":"2","insp_unit_id":"197145175","insp_violation_category_id":"17","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:35:58.000000Z","updated_at":"2025-03-17T21:35:58.000000Z","normalized_code":"39371H10"},{"id":6210490,"change_date":"2023-09-20 21:39:00","inspection_id":"79707999","insp_violation_id":"255374747","seq_no":"5","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"197145175","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:58.000000Z","updated_at":"2025-03-17T21:35:58.000000Z","normalized_code":"39311"},{"id":6210491,"change_date":"2023-09-20 21:39:00","inspection_id":"79707999","insp_violation_id":"255374748","seq_no":"6","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"197145175","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:35:58.000000Z","updated_at":"2025-03-17T21:35:58.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":6453760,"change_date":"2023-09-20 21:39:00","inspection_id":"79707999","insp_unit_id":"197145174","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":null,"insp_unit_license":"K128302","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3C6UR5HL1KG707021","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:54:10.000000Z","updated_at":"2025-03-17T22:54:10.000000Z"},{"id":6453761,"change_date":"2023-09-20 21:39:00","inspection_id":"79707999","insp_unit_id":"197145175","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTH","insp_unit_company":"36391","insp_unit_license":"792467K","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1P9GF3526LL375277","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:54:10.000000Z","updated_at":"2025-03-17T22:54:10.000000Z"}]},{"id":3533394,"change_date":"2023-07-18 21:42:00","inspection_id":"79171380","dot_number":"3547997","report_state":"TN","report_number":"TBLW002844","insp_date":"2023-07-17 00:00:00","insp_start_time":"1020","insp_end_time":"1037","registration_date":null,"region":"ET","ci_status_code":"C","location":"SCALES","location_desc":"THP 1 I-40 KNOXVILLE SCALES","county_code_state":"TN","county_code":"093","insp_level_id":"1","service_center":"SH","census_source_id":"4","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-07-18 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"37900","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":"1661224","transaction_code":"A","transaction_date":"2023-07-17 00:00:00","upload_date":"2023-07-18 00:00:00","upload_first_byte":"0","upload_dot_number":"03547997","upload_search_indicator":null,"census_search_date":"2023-07-18 21:42:00","snet_input_date":"2023-07-18 00:00:00","source_office":"2TNS001","mcmis_add_date":"2023-07-18 21:42:00","insp_carrier_name":"CALTEX EXPRESS TRANSPORT LLC","insp_carrier_street":"923 FLORES DEL SOL","insp_carrier_city":"ALAMO","insp_carrier_state":"TX","insp_carrier_zip_code":"78516-1651","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:32:49.000000Z","updated_at":"2025-03-17T19:32:49.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5681025,"change_date":"2023-07-18 21:42:00","inspection_id":"79171380","insp_unit_id":"196054930","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"MS01","insp_unit_license":"K115021","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3C63RRGL1GG143866","insp_unit_decal":"Y","insp_unit_decal_number":"33102322","created_at":"2025-03-17T22:47:50.000000Z","updated_at":"2025-03-17T22:47:50.000000Z"},{"id":5681026,"change_date":"2023-07-18 21:42:00","inspection_id":"79171380","insp_unit_id":"196054931","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":"T022","insp_unit_license":"128C946","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"16VGX3524K6086018","insp_unit_decal":"Y","insp_unit_decal_number":"33102323","created_at":"2025-03-17T22:47:50.000000Z","updated_at":"2025-03-17T22:47:50.000000Z"}]},{"id":3374447,"change_date":"2023-06-27 21:40:00","inspection_id":"78992892","dot_number":"3547997","report_state":"OK","report_number":"PE20000147","insp_date":"2023-06-26 00:00:00","insp_start_time":"1947","insp_end_time":"2045","registration_date":null,"region":"CT","ci_status_code":"C","location":"43035","location_desc":"LOVE PORT OF ENTRY","county_code_state":"OK","county_code":"085","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"MUNTERS CORPORATION","shipping_paper_number":"22264483-01,02","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-06-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"38000","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":"714623","transaction_code":"A","transaction_date":"2023-06-27 00:00:00","upload_date":"2023-06-27 00:00:00","upload_first_byte":"0","upload_dot_number":"03547997","upload_search_indicator":"M","census_search_date":"2023-06-27 21:40:00","snet_input_date":"2023-06-26 00:00:00","source_office":"2OKS001","mcmis_add_date":"2023-06-27 21:40:00","insp_carrier_name":"CALTEX EXPRESS TRANSPORT LLC","insp_carrier_street":"923 FLORES DEL SOL","insp_carrier_city":"ALAMO","insp_carrier_state":"TX","insp_carrier_zip_code":"78516","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:29:47.000000Z","updated_at":"2025-03-17T19:29:47.000000Z","inspection_violations":[],"inspection_per_units":[{"id":5424545,"change_date":"2023-06-27 21:40:00","inspection_id":"78992892","insp_unit_id":"195694825","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":"MS06","insp_unit_license":"K172055","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3C63RRHL6NG104508","insp_unit_decal":"Y","insp_unit_decal_number":"32761173","created_at":"2025-03-17T22:45:47.000000Z","updated_at":"2025-03-17T22:45:47.000000Z"},{"id":5424546,"change_date":"2023-06-27 21:40:00","inspection_id":"78992892","insp_unit_id":"195694826","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"RAWMA","insp_unit_company":"MS006","insp_unit_license":"026F177","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3EVGF4023N1102504","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:45:47.000000Z","updated_at":"2025-03-17T22:45:47.000000Z"}]},{"id":3221437,"change_date":"2023-06-06 21:44:00","inspection_id":"78820510","dot_number":"3547997","report_state":"TN","report_number":"TBYQ004227","insp_date":"2023-06-05 00:00:00","insp_start_time":"0920","insp_end_time":"0956","registration_date":null,"region":"CT","ci_status_code":"C","location":"SCALES","location_desc":"THP 4 HAYWOOD COUNTY SCALE","county_code_state":"TN","county_code":"075","insp_level_id":"1","service_center":"SH","census_source_id":"4","insp_facility":"F","shipper_name":"AEP","shipping_paper_number":"80429357","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":"I","final_status_date":"2023-06-06 21:44:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"2","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1651027","transaction_code":"A","transaction_date":"2023-06-05 00:00:00","upload_date":"2023-06-06 00:00:00","upload_first_byte":"0","upload_dot_number":"03547997","upload_search_indicator":null,"census_search_date":"2023-06-06 21:44:00","snet_input_date":"2023-06-06 00:00:00","source_office":"2TNS001","mcmis_add_date":"2023-06-06 21:44:00","insp_carrier_name":"CALTEX EXPRESS TRANSPORT LLC","insp_carrier_street":"923 FLORES DEL SOL","insp_carrier_city":"ALAMO","insp_carrier_state":"TX","insp_carrier_zip_code":"78516-1651","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:26:51.000000Z","updated_at":"2025-03-17T19:26:51.000000Z","inspection_violations":[{"id":4965059,"change_date":"2023-06-06 21:44:00","inspection_id":"78820510","insp_violation_id":"253319319","seq_no":"1","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"195344519","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"WARNING","created_at":"2025-03-17T21:30:07.000000Z","updated_at":"2025-03-17T21:30:07.000000Z","normalized_code":"39360C"},{"id":4965060,"change_date":"2023-06-06 21:44:00","inspection_id":"78820510","insp_violation_id":"253319320","seq_no":"2","part_no":"393","part_no_section":"43","insp_viol_unit":"2","insp_unit_id":"195344520","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":"WARNING","created_at":"2025-03-17T21:30:07.000000Z","updated_at":"2025-03-17T21:30:07.000000Z","normalized_code":"39343"}],"inspection_per_units":[{"id":5180818,"change_date":"2023-06-06 21:44:00","inspection_id":"78820510","insp_unit_id":"195344519","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":"MS04","insp_unit_license":"K128302","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3C6UR5HL1KG707021","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:43:50.000000Z","updated_at":"2025-03-17T22:43:50.000000Z"},{"id":5180819,"change_date":"2023-06-06 21:44:00","inspection_id":"78820510","insp_unit_id":"195344520","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":"01","insp_unit_license":"792467K","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1P9GF3526LL375277","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:43:50.000000Z","updated_at":"2025-03-17T22:43:50.000000Z"}]},{"id":2907484,"change_date":"2023-04-27 21:42:00","inspection_id":"78466162","dot_number":"3547997","report_state":"MS","report_number":"6628005521","insp_date":"2023-04-26 00:00:00","insp_start_time":"1446","insp_end_time":"1528","registration_date":null,"region":"CT","ci_status_code":"C","location":"77","location_desc":"WAYNE COUNTY","county_code_state":"MS","county_code":"153","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"IRON PLANET","shipping_paper_number":"9469262","cargo_tank":null,"hazmat_placard_req":"Y","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":"N","pen_cen_match":null,"final_status_date":"2023-04-27 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":null,"viol_total":"6","oos_total":"4","driver_viol_total":"2","driver_oos_total":"2","vehicle_viol_total":"4","vehicle_oos_total":"2","hazmat_viol_total":"1","hazmat_oos_total":"1","snet_sequence_id":"1023848","transaction_code":"A","transaction_date":"2023-04-26 00:00:00","upload_date":"2023-04-27 00:00:00","upload_first_byte":"0","upload_dot_number":"03547997","upload_search_indicator":null,"census_search_date":"2023-04-27 21:42:00","snet_input_date":"2023-04-27 00:00:00","source_office":"2MSS002","mcmis_add_date":"2023-04-27 21:42:00","insp_carrier_name":"CALTEX EXPRESS TRANSPORT LLC","insp_carrier_street":"923 FLORES DEL SOL","insp_carrier_city":"ALAMO","insp_carrier_state":"TX","insp_carrier_zip_code":"78516","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:20:25.000000Z","updated_at":"2025-03-17T19:20:25.000000Z","inspection_violations":[{"id":4461726,"change_date":"2023-04-27 21:42:00","inspection_id":"78466162","insp_violation_id":"252478444","seq_no":"1","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"500286750","created_at":"2025-03-17T21:27:49.000000Z","updated_at":"2025-03-17T21:27:49.000000Z","normalized_code":"38323A2"},{"id":4461727,"change_date":"2023-04-27 21:42:00","inspection_id":"78466162","insp_violation_id":"252478445","seq_no":"2","part_no":"172","part_no_section":"200(a)","insp_viol_unit":"1","insp_unit_id":"194619901","insp_violation_category_id":"31","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"500286751","created_at":"2025-03-17T21:27:49.000000Z","updated_at":"2025-03-17T21:27:49.000000Z","normalized_code":"172200A"},{"id":4461728,"change_date":"2023-04-27 21:42:00","inspection_id":"78466162","insp_violation_id":"252478446","seq_no":"3","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"194619901","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:49.000000Z","updated_at":"2025-03-17T21:27:49.000000Z","normalized_code":"39395A"},{"id":4461729,"change_date":"2023-04-27 21:42:00","inspection_id":"78466162","insp_violation_id":"252478447","seq_no":"4","part_no":"393","part_no_section":"104(b)","insp_viol_unit":"2","insp_unit_id":"194619902","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:27:49.000000Z","updated_at":"2025-03-17T21:27:49.000000Z","normalized_code":"393104B"},{"id":4461730,"change_date":"2023-04-27 21:42:00","inspection_id":"78466162","insp_violation_id":"252478448","seq_no":"5","part_no":"392","part_no_section":"9a(a)(1)","insp_viol_unit":"1","insp_unit_id":"194619901","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"500286752","created_at":"2025-03-17T21:27:49.000000Z","updated_at":"2025-03-17T21:27:49.000000Z","normalized_code":"3929AA1"},{"id":4461731,"change_date":"2023-04-27 21:42:00","inspection_id":"78466162","insp_violation_id":"252478449","seq_no":"6","part_no":"383","part_no_section":"23(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:27:49.000000Z","updated_at":"2025-03-17T21:27:49.000000Z","normalized_code":"38323A2"}],"inspection_per_units":[{"id":4677347,"change_date":"2023-04-27 21:42:00","inspection_id":"78466162","insp_unit_id":"194619901","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":"MS02","insp_unit_license":"K128265","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3C63RRHL9KG524162","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:39:53.000000Z","updated_at":"2025-03-17T22:39:53.000000Z"},{"id":4677348,"change_date":"2023-04-27 21:42:00","inspection_id":"78466162","insp_unit_id":"194619902","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"BIGT","insp_unit_company":"2","insp_unit_license":"128C946","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"16VGX3524K6086018","insp_unit_decal":"Y","insp_unit_decal_number":"00005521","created_at":"2025-03-17T22:39:53.000000Z","updated_at":"2025-03-17T22:39:53.000000Z"}]},{"id":2762116,"change_date":"2023-06-13 21:41:00","inspection_id":"78301415","dot_number":"3547997","report_state":"NJ","report_number":"SPQFI03332","insp_date":"2023-04-06 00:00:00","insp_start_time":"0801","insp_end_time":"0911","registration_date":null,"region":"ET","ci_status_code":"C","location":"2113","location_desc":"KNOWLTON SCALE","county_code_state":"NJ","county_code":"041","insp_level_id":"1","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":"6321-9521-304.0","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":"N","pen_cen_match":null,"final_status_date":"2023-04-11 12:03:00","post_acc_ind":"N","gross_comb_veh_wt":"39900","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":"1151176","transaction_code":"C","transaction_date":"2023-06-12 00:00:00","upload_date":"2023-06-13 00:00:00","upload_first_byte":"0","upload_dot_number":"03547997","upload_search_indicator":null,"census_search_date":"2023-04-11 12:03:00","snet_input_date":"2023-04-06 00:00:00","source_office":"1NJS001","mcmis_add_date":"2023-04-11 12:03:00","insp_carrier_name":"CALTEX EXPRESS TRANSPORT LLC","insp_carrier_street":"923 FLORES DEL SOL","insp_carrier_city":"ALAMO","insp_carrier_state":"TX","insp_carrier_zip_code":"78516","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:17:39.000000Z","updated_at":"2025-03-17T19:17:39.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4445478,"change_date":"2023-06-13 21:41:00","inspection_id":"78301415","insp_unit_id":"195460962","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":null,"insp_unit_license":"K163226","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1GT49WEY2MF142488","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:01.000000Z","updated_at":"2025-03-17T22:38:01.000000Z"},{"id":4445479,"change_date":"2023-06-13 21:41:00","inspection_id":"78301415","insp_unit_id":"195460963","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIGT","insp_unit_company":null,"insp_unit_license":"219B722","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"16VGX3529K6082580","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:38:01.000000Z","updated_at":"2025-03-17T22:38:01.000000Z"}]},{"id":2714763,"change_date":"2023-04-28 21:39:00","inspection_id":"78247879","dot_number":"3547997","report_state":"TN","report_number":"TETD000260","insp_date":"2023-03-31 00:00:00","insp_start_time":"0725","insp_end_time":"0756","registration_date":null,"region":"CT","ci_status_code":"C","location":"SCALES","location_desc":"INTERSTATE 40 SCALES HAYWOOD","county_code_state":"TN","county_code":"075","insp_level_id":"1","service_center":"SH","census_source_id":"4","insp_facility":"F","shipper_name":"IRAY LOGISTICS","shipping_paper_number":"ASFL303481","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":"N","pen_cen_match":"I","final_status_date":"2023-04-03 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"21500","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":"1638832","transaction_code":"C","transaction_date":"2023-04-25 00:00:00","upload_date":"2023-04-28 00:00:00","upload_first_byte":"0","upload_dot_number":"03547997","upload_search_indicator":null,"census_search_date":"2023-04-03 21:40:00","snet_input_date":"2023-04-03 00:00:00","source_office":"2TNS001","mcmis_add_date":"2023-04-03 21:40:00","insp_carrier_name":"CALTEX EXPRESS TRANSPORT LLC","insp_carrier_street":"923 FLORES DEL SOL","insp_carrier_city":"ALAMO","insp_carrier_state":"TX","insp_carrier_zip_code":"78516-1651","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:16:37.000000Z","updated_at":"2025-03-17T19:16:37.000000Z","inspection_violations":[],"inspection_per_units":[{"id":4368931,"change_date":"2023-04-28 21:39:00","inspection_id":"78247879","insp_unit_id":"194642434","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":null,"insp_unit_license":"K128302","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3C6UR5HL1KG707021","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:23.000000Z","updated_at":"2025-03-17T22:37:23.000000Z"},{"id":4368932,"change_date":"2023-04-28 21:39:00","inspection_id":"78247879","insp_unit_id":"194642435","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"792467K","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1P9GF3526LL375277","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:37:23.000000Z","updated_at":"2025-03-17T22:37:23.000000Z"}]},{"id":2613649,"change_date":"2023-03-20 21:41:00","inspection_id":"78132201","dot_number":"3547997","report_state":"IL","report_number":"4038430236","insp_date":"2023-03-18 00:00:00","insp_start_time":"1130","insp_end_time":"1220","registration_date":null,"region":"CT","ci_status_code":"C","location":"999","location_desc":"I-55","county_code_state":"IL","county_code":"135","insp_level_id":"2","service_center":"MW","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-03-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"3","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":"2230272","transaction_code":"A","transaction_date":"2023-03-18 00:00:00","upload_date":"2023-03-20 00:00:00","upload_first_byte":"0","upload_dot_number":"03547997","upload_search_indicator":null,"census_search_date":"2023-03-20 21:41:00","snet_input_date":"2023-03-18 00:00:00","source_office":"3ILS001","mcmis_add_date":"2023-03-20 21:41:00","insp_carrier_name":"CALTEX EXPRESS TRANSPORT LLC","insp_carrier_street":"923 FLORES DEL SOL","insp_carrier_city":"ALAMO","insp_carrier_state":"TX","insp_carrier_zip_code":"78516","insp_colonia":null,"docket_number":"118718","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:14:52.000000Z","updated_at":"2025-03-17T19:14:52.000000Z","inspection_violations":[{"id":4019507,"change_date":"2023-03-20 21:41:00","inspection_id":"78132201","insp_violation_id":"251754673","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"193955938","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:25:48.000000Z","updated_at":"2025-03-17T21:25:48.000000Z","normalized_code":"3922"},{"id":4019508,"change_date":"2023-03-20 21:41:00","inspection_id":"78132201","insp_violation_id":"251754674","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:25:48.000000Z","updated_at":"2025-03-17T21:25:48.000000Z","normalized_code":"3922"},{"id":4019509,"change_date":"2023-03-20 21:41:00","inspection_id":"78132201","insp_violation_id":"251754675","seq_no":"3","part_no":"393","part_no_section":"60(c)","insp_viol_unit":"1","insp_unit_id":"193955938","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:25:48.000000Z","updated_at":"2025-03-17T21:25:48.000000Z","normalized_code":"39360C"}],"inspection_per_units":[{"id":4207286,"change_date":"2023-03-20 21:41:00","inspection_id":"78132201","insp_unit_id":"193955938","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"GMC","insp_unit_company":null,"insp_unit_license":"K163226","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1GT49WEY2MF142488","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:10.000000Z","updated_at":"2025-03-17T22:36:10.000000Z"},{"id":4207287,"change_date":"2023-03-20 21:41:00","inspection_id":"78132201","insp_unit_id":"193955939","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIGT","insp_unit_company":null,"insp_unit_license":"219B722","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"16VGX3529K6082580","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:36:10.000000Z","updated_at":"2025-03-17T22:36:10.000000Z"}]},{"id":2423273,"change_date":"2023-02-22 21:40:00","inspection_id":"77915758","dot_number":"3547997","report_state":"TN","report_number":"TBSG001560","insp_date":"2023-02-21 00:00:00","insp_start_time":"0943","insp_end_time":"1017","registration_date":null,"region":"ET","ci_status_code":"C","location":"SCALES","location_desc":"HIGWAY 411 INSPECTION STATION","county_code_state":"TN","county_code":"123","insp_level_id":"1","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-02-22 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25900","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":"1630557","transaction_code":"A","transaction_date":"2023-02-21 00:00:00","upload_date":"2023-02-22 00:00:00","upload_first_byte":"0","upload_dot_number":"03547997","upload_search_indicator":null,"census_search_date":"2023-02-22 21:40:00","snet_input_date":"2023-02-22 00:00:00","source_office":"2TNS001","mcmis_add_date":"2023-02-22 21:40:00","insp_carrier_name":"CALTEX EXPRESS TRANSPORT LLC","insp_carrier_street":"923 FLORES DEL SOL","insp_carrier_city":"ALAMO","insp_carrier_state":"TX","insp_carrier_zip_code":"78516-1651","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:11:24.000000Z","updated_at":"2025-03-17T19:11:24.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3900207,"change_date":"2023-02-22 21:40:00","inspection_id":"77915758","insp_unit_id":"193520085","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"M03","insp_unit_license":"K127966","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FT7W2BT1KED37735","insp_unit_decal":"Y","insp_unit_decal_number":"32372468","created_at":"2025-03-17T22:33:57.000000Z","updated_at":"2025-03-17T22:33:57.000000Z"},{"id":3900208,"change_date":"2023-02-22 21:40:00","inspection_id":"77915758","insp_unit_id":"193520086","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIGT","insp_unit_company":"02","insp_unit_license":"150B981","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"16V3F3820M6091913","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:33:57.000000Z","updated_at":"2025-03-17T22:33:57.000000Z"}]},{"id":2233083,"change_date":"2023-01-26 21:41:00","inspection_id":"77698734","dot_number":"3547997","report_state":"AR","report_number":"422C000191","insp_date":"2023-01-26 00:00:00","insp_start_time":"0830","insp_end_time":"0915","registration_date":null,"region":"CT","ci_status_code":"C","location":"17-301","location_desc":"CRAWFORD COUNTY(ALMA EAST STN)","county_code_state":"AR","county_code":"033","insp_level_id":"1","service_center":"SH","census_source_id":"4","insp_facility":"F","shipper_name":"SLIPNOT METAL SAFETY FLOORING","shipping_paper_number":"73728-008 009","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":"N","pen_cen_match":"I","final_status_date":"2023-01-26 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"21500","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":"1442262","transaction_code":"A","transaction_date":"2023-01-26 00:00:00","upload_date":"2023-01-26 00:00:00","upload_first_byte":"0","upload_dot_number":"03547997","upload_search_indicator":"M","census_search_date":"2023-01-26 21:41:00","snet_input_date":"2023-01-26 00:00:00","source_office":"2ARS001","mcmis_add_date":"2023-01-26 21:41:00","insp_carrier_name":"CALTEX EXPRESS TRANSPORT LLC","insp_carrier_street":"923 FLORES DEL SOL","insp_carrier_city":"ALAMO","insp_carrier_state":"TX","insp_carrier_zip_code":"78516","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:07:46.000000Z","updated_at":"2025-03-17T19:07:46.000000Z","inspection_violations":[{"id":3450190,"change_date":"2023-01-26 21:41:00","inspection_id":"77698734","insp_violation_id":"250793677","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"193078709","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:19.000000Z","updated_at":"2025-03-17T21:23:19.000000Z","normalized_code":"3939A"},{"id":3450191,"change_date":"2023-01-26 21:41:00","inspection_id":"77698734","insp_violation_id":"250793678","seq_no":"2","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"193078710","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:19.000000Z","updated_at":"2025-03-17T21:23:19.000000Z","normalized_code":"3939A"},{"id":3450192,"change_date":"2023-01-26 21:41:00","inspection_id":"77698734","insp_violation_id":"250793679","seq_no":"3","part_no":"393","part_no_section":"102(a)(1)(i)","insp_viol_unit":"2","insp_unit_id":"193078710","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:23:19.000000Z","updated_at":"2025-03-17T21:23:19.000000Z","normalized_code":"393102A1I"}],"inspection_per_units":[{"id":3594177,"change_date":"2023-01-26 21:41:00","inspection_id":"77698734","insp_unit_id":"193078709","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":"MS04","insp_unit_license":"K128302","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3C6UR5HL1KG707021","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:31:46.000000Z","updated_at":"2025-03-17T22:31:46.000000Z"},{"id":3594178,"change_date":"2023-01-26 21:41:00","inspection_id":"77698734","insp_unit_id":"193078710","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNK","insp_unit_company":"004","insp_unit_license":"792467K","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1P9GF3526LL375277","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:31:46.000000Z","updated_at":"2025-03-17T22:31:46.000000Z"}]},{"id":2167183,"change_date":"2023-01-18 21:40:00","inspection_id":"77623806","dot_number":"3547997","report_state":"OH","report_number":"3220006835","insp_date":"2023-01-17 00:00:00","insp_start_time":"1435","insp_end_time":"1530","registration_date":null,"region":"ET","ci_status_code":"C","location":"03330","location_desc":"ROADSIDE INSPECTION","county_code_state":"OH","county_code":"033","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"R","shipper_name":null,"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":"I","final_status_date":"2023-01-18 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"21500","viol_total":"1","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1635666","transaction_code":"A","transaction_date":"2023-01-17 00:00:00","upload_date":"2023-01-18 00:00:00","upload_first_byte":"0","upload_dot_number":"03547997","upload_search_indicator":null,"census_search_date":"2023-01-18 21:40:00","snet_input_date":"2023-01-18 00:00:00","source_office":"3OHS001","mcmis_add_date":"2023-01-18 21:40:00","insp_carrier_name":"CALTEX EXPRESS TRANSPORT LLC","insp_carrier_street":"923 FLORES DEL SOL","insp_carrier_city":"ALAMO","insp_carrier_state":"TX","insp_carrier_zip_code":"78516-1651","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:06:36.000000Z","updated_at":"2025-03-17T19:06:36.000000Z","inspection_violations":[{"id":3351594,"change_date":"2023-01-18 21:40:00","inspection_id":"77623806","insp_violation_id":"250632529","seq_no":"1","part_no":"395","part_no_section":"8(e)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:22:50.000000Z","updated_at":"2025-03-17T21:22:50.000000Z","normalized_code":"3958E1"}],"inspection_per_units":[{"id":3488048,"change_date":"2023-01-18 21:40:00","inspection_id":"77623806","insp_unit_id":"192926548","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":"MS04","insp_unit_license":"K128302","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3C6UR5HL1KG707021","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:31:00.000000Z","updated_at":"2025-03-17T22:31:00.000000Z"},{"id":3488049,"change_date":"2023-01-18 21:40:00","inspection_id":"77623806","insp_unit_id":"192926549","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":"004","insp_unit_license":"792467K","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1P9GF3526LL375277","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:31:00.000000Z","updated_at":"2025-03-17T22:31:00.000000Z"}]},{"id":1984590,"change_date":"2022-12-20 21:41:00","inspection_id":"77414545","dot_number":"3547997","report_state":"IN","report_number":"7250005028","insp_date":"2022-12-13 00:00:00","insp_start_time":"0825","insp_end_time":"0858","registration_date":null,"region":"ET","ci_status_code":"C","location":"4274W","location_desc":"#42  I-74  WB  DEARBORN","county_code_state":"IN","county_code":"029","insp_level_id":"3","service_center":"MW","census_source_id":"4","insp_facility":"F","shipper_name":null,"shipping_paper_number":"0042EB6240","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":"I","final_status_date":"2022-12-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"21500","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":"2165822","transaction_code":"A","transaction_date":"2022-12-15 00:00:00","upload_date":"2022-12-20 00:00:00","upload_first_byte":"0","upload_dot_number":"03547997","upload_search_indicator":"M","census_search_date":"2022-12-20 21:41:00","snet_input_date":"2022-12-15 00:00:00","source_office":"3INS001","mcmis_add_date":"2022-12-20 21:41:00","insp_carrier_name":"CALTEX EXPRESS TRANSPORT LLC","insp_carrier_street":"923 FLORES DEL SOL","insp_carrier_city":"ALAMO","insp_carrier_state":"TX","insp_carrier_zip_code":"78516","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:03:17.000000Z","updated_at":"2025-03-17T19:03:17.000000Z","inspection_violations":[],"inspection_per_units":[{"id":3192647,"change_date":"2022-12-20 21:41:00","inspection_id":"77414545","insp_unit_id":"192511609","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":"MS04","insp_unit_license":"K128302","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3C6UR5HL1KG707021","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:51.000000Z","updated_at":"2025-03-17T22:28:51.000000Z"},{"id":3192648,"change_date":"2022-12-20 21:41:00","inspection_id":"77414545","insp_unit_id":"192511610","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":"004","insp_unit_license":"792467K","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1P9GF3526LL375277","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:51.000000Z","updated_at":"2025-03-17T22:28:51.000000Z"}]},{"id":1486154,"change_date":"2022-10-11 21:41:00","inspection_id":"76842641","dot_number":"3547997","report_state":"IA","report_number":"000P14KG51","insp_date":"2022-10-10 00:00:00","insp_start_time":"0722","insp_end_time":"0820","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"I-35 188MM NB","county_code_state":"IA","county_code":"033","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"HELMERICH & PAYNE INTERNATIONAL DRI","shipping_paper_number":"HOU25433","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":"N","pen_cen_match":null,"final_status_date":"2022-10-11 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"25900","viol_total":"8","oos_total":"2","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"6","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1246269","transaction_code":"A","transaction_date":"2022-10-11 00:00:00","upload_date":"2022-10-11 00:00:00","upload_first_byte":"0","upload_dot_number":"03547997","upload_search_indicator":"M","census_search_date":"2022-10-11 21:41:00","snet_input_date":"2022-10-10 00:00:00","source_office":"3IAS001","mcmis_add_date":"2022-10-11 21:41:00","insp_carrier_name":"CALTEX EXPRESS TRANSPORT LLC","insp_carrier_street":"923 FLORES DEL SOL","insp_carrier_city":"ALAMO","insp_carrier_state":"TX","insp_carrier_zip_code":"78516","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:54:07.000000Z","updated_at":"2025-03-17T18:54:07.000000Z","inspection_violations":[{"id":2338877,"change_date":"2022-10-11 21:41:00","inspection_id":"76842641","insp_violation_id":"248949473","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"191372493","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:42.000000Z","updated_at":"2025-03-17T21:17:42.000000Z","normalized_code":"3939A"},{"id":2338878,"change_date":"2022-10-11 21:41:00","inspection_id":"76842641","insp_violation_id":"248949474","seq_no":"2","part_no":"395","part_no_section":"8(e)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"1SCO22101008144","created_at":"2025-03-17T21:17:42.000000Z","updated_at":"2025-03-17T21:17:42.000000Z","normalized_code":"3958E1"},{"id":2338879,"change_date":"2022-10-11 21:41:00","inspection_id":"76842641","insp_violation_id":"248949475","seq_no":"3","part_no":"395","part_no_section":"22(h)(4)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:42.000000Z","updated_at":"2025-03-17T21:17:42.000000Z","normalized_code":"39522H4"},{"id":2338880,"change_date":"2022-10-11 21:41:00","inspection_id":"76842641","insp_violation_id":"248949476","seq_no":"4","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"191372493","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:42.000000Z","updated_at":"2025-03-17T21:17:42.000000Z","normalized_code":"3922"},{"id":2338881,"change_date":"2022-10-11 21:41:00","inspection_id":"76842641","insp_violation_id":"248949477","seq_no":"5","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"191372493","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:42.000000Z","updated_at":"2025-03-17T21:17:42.000000Z","normalized_code":"39617C"},{"id":2338882,"change_date":"2022-10-11 21:41:00","inspection_id":"76842641","insp_violation_id":"248949478","seq_no":"6","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"191372493","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:42.000000Z","updated_at":"2025-03-17T21:17:42.000000Z","normalized_code":"3922"},{"id":2338883,"change_date":"2022-10-11 21:41:00","inspection_id":"76842641","insp_violation_id":"248949479","seq_no":"7","part_no":"393","part_no_section":"104(b)","insp_viol_unit":"2","insp_unit_id":"191372493","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:17:42.000000Z","updated_at":"2025-03-17T21:17:42.000000Z","normalized_code":"393104B"},{"id":2338884,"change_date":"2022-10-11 21:41:00","inspection_id":"76842641","insp_violation_id":"248949480","seq_no":"8","part_no":"393","part_no_section":"110(b)","insp_viol_unit":"2","insp_unit_id":"191372493","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:17:42.000000Z","updated_at":"2025-03-17T21:17:42.000000Z","normalized_code":"393110B"}],"inspection_per_units":[{"id":2391393,"change_date":"2022-10-11 21:41:00","inspection_id":"76842641","insp_unit_id":"191372492","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":"01","insp_unit_license":"K115021","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3C63RRGL1GG143866","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:23.000000Z","updated_at":"2025-03-17T22:23:23.000000Z"},{"id":2391394,"change_date":"2022-10-11 21:41:00","inspection_id":"76842641","insp_unit_id":"191372493","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"RANC","insp_unit_company":"01","insp_unit_license":"064854M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"17YGA3224MB081620","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:23:23.000000Z","updated_at":"2025-03-17T22:23:23.000000Z"}]},{"id":1119069,"change_date":"2022-08-23 21:42:00","inspection_id":"76416607","dot_number":"3547997","report_state":"TX","report_number":"6DMK0XTVNR","insp_date":"2022-08-19 00:00:00","insp_start_time":"1949","insp_end_time":"2044","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US-0075 IN GRAYSON CO. (194-22","county_code_state":"TX","county_code":"181","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"AEP YARD","shipping_paper_number":"27378858","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-23 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"21900","viol_total":"4","oos_total":"2","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8752009","transaction_code":"A","transaction_date":"2022-08-23 00:00:00","upload_date":"2022-08-23 00:00:00","upload_first_byte":"0","upload_dot_number":"03547997","upload_search_indicator":"M","census_search_date":"2022-08-23 21:42:00","snet_input_date":"2022-08-20 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-08-23 21:42:00","insp_carrier_name":"CALTEX EXPRESS TRANSPORT LLC","insp_carrier_street":"923 FLORES DEL SOL","insp_carrier_city":"ALAMO","insp_carrier_state":"TX","insp_carrier_zip_code":"78516","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1028150","created_at":"2025-03-17T18:47:17.000000Z","updated_at":"2025-03-17T18:47:17.000000Z","inspection_violations":[{"id":1768055,"change_date":"2022-08-23 21:42:00","inspection_id":"76416607","insp_violation_id":"247946969","seq_no":"1","part_no":"395","part_no_section":"15(g)(2)","insp_viol_unit":"1","insp_unit_id":"190504128","insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:14.000000Z","updated_at":"2025-03-17T21:15:14.000000Z","normalized_code":"39515G2"},{"id":1768056,"change_date":"2022-08-23 21:42:00","inspection_id":"76416607","insp_violation_id":"247946970","seq_no":"2","part_no":"393","part_no_section":"43(d)","insp_viol_unit":"1","insp_unit_id":"190504128","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:15:14.000000Z","updated_at":"2025-03-17T21:15:14.000000Z","normalized_code":"39343D"},{"id":1768057,"change_date":"2022-08-23 21:42:00","inspection_id":"76416607","insp_violation_id":"247946971","seq_no":"3","part_no":"395","part_no_section":"8(f)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:14.000000Z","updated_at":"2025-03-17T21:15:14.000000Z","normalized_code":"3958F1"},{"id":1768058,"change_date":"2022-08-23 21:42:00","inspection_id":"76416607","insp_violation_id":"247946972","seq_no":"4","part_no":"391","part_no_section":"11(b)(5)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:15:14.000000Z","updated_at":"2025-03-17T21:15:14.000000Z","normalized_code":"39111B5"}],"inspection_per_units":[{"id":1800157,"change_date":"2022-08-23 21:42:00","inspection_id":"76416607","insp_unit_id":"190504128","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"K127966","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FT7W2BT1KED37735","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:25.000000Z","updated_at":"2025-03-17T22:19:25.000000Z"},{"id":1800158,"change_date":"2022-08-23 21:42:00","inspection_id":"76416607","insp_unit_id":"190504129","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"AMER","insp_unit_company":null,"insp_unit_license":"064854M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"17YGA3224MB081620","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:19:25.000000Z","updated_at":"2025-03-17T22:19:25.000000Z"}]},{"id":1060658,"change_date":"2022-08-17 21:40:00","inspection_id":"76348423","dot_number":"3547997","report_state":"GA","report_number":"1396000445","insp_date":"2022-07-08 00:00:00","insp_start_time":"0730","insp_end_time":"0815","registration_date":null,"region":"ET","ci_status_code":"C","location":"276","location_desc":"TROUP CO I\/S NB","county_code_state":"GA","county_code":"285","insp_level_id":"1","service_center":"SH","census_source_id":"4","insp_facility":"F","shipper_name":"TSH LAREDO YARD","shipping_paper_number":"1806015","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":"I","final_status_date":"2022-08-17 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25500","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":"1907032","transaction_code":"A","transaction_date":"2022-07-08 00:00:00","upload_date":"2022-08-17 00:00:00","upload_first_byte":"0","upload_dot_number":"03547997","upload_search_indicator":null,"census_search_date":"2022-08-17 21:40:00","snet_input_date":"2022-08-04 00:00:00","source_office":"2GAS001","mcmis_add_date":"2022-08-17 21:40:00","insp_carrier_name":"CALTEX EXPRESS TRANSPORT LLC","insp_carrier_street":"923 FLORES DEL SOL","insp_carrier_city":"ALAMO","insp_carrier_state":"TX","insp_carrier_zip_code":"78516-1651","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:46:29.000000Z","updated_at":"2025-03-17T18:46:29.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1706482,"change_date":"2022-08-17 21:40:00","inspection_id":"76348423","insp_unit_id":"190365147","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":"MS02","insp_unit_license":"K128265","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3C63RRHL9KG524162","insp_unit_decal":"Y","insp_unit_decal_number":"03164067","created_at":"2025-03-17T22:18:46.000000Z","updated_at":"2025-03-17T22:18:46.000000Z"},{"id":1706483,"change_date":"2022-08-17 21:40:00","inspection_id":"76348423","insp_unit_id":"190365148","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":"04","insp_unit_license":"792467K","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1P9GF3526LL375277","insp_unit_decal":"Y","insp_unit_decal_number":"31640268","created_at":"2025-03-17T22:18:46.000000Z","updated_at":"2025-03-17T22:18:46.000000Z"}]},{"id":728842,"change_date":"2022-06-30 21:41:00","inspection_id":"75960559","dot_number":"3547997","report_state":"TN","report_number":"TFAT000473","insp_date":"2022-06-29 00:00:00","insp_start_time":"0830","insp_end_time":"0845","registration_date":null,"region":"CT","ci_status_code":"C","location":"ROAD","location_desc":"I-155 5 MM","county_code_state":"TN","county_code":"045","insp_level_id":"1","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":"PRESTO LIFTS","shipping_paper_number":"V000079958","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":"I","final_status_date":"2022-06-30 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"41500","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":"1582925","transaction_code":"A","transaction_date":"2022-06-29 00:00:00","upload_date":"2022-06-30 00:00:00","upload_first_byte":"0","upload_dot_number":"03547997","upload_search_indicator":null,"census_search_date":"2022-06-30 21:41:00","snet_input_date":"2022-06-30 00:00:00","source_office":"2TNS001","mcmis_add_date":"2022-06-30 21:41:00","insp_carrier_name":"CALTEX EXPRESS TRANSPORT LLC","insp_carrier_street":"923 FLORES DEL SOL","insp_carrier_city":"ALAMO","insp_carrier_state":"TX","insp_carrier_zip_code":"78516-1651","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:40:32.000000Z","updated_at":"2025-03-17T18:40:32.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1171542,"change_date":"2022-06-30 21:41:00","inspection_id":"75960559","insp_unit_id":"189548512","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"01","insp_unit_license":"K127966","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FT7W2BT1KED37735","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:23.000000Z","updated_at":"2025-03-17T22:15:23.000000Z"},{"id":1171543,"change_date":"2022-06-30 21:41:00","inspection_id":"75960559","insp_unit_id":"189548513","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIGT","insp_unit_company":"01T","insp_unit_license":"150B981","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"16V3F3820M6091913","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:23.000000Z","updated_at":"2025-03-17T22:15:23.000000Z"}]},{"id":563460,"change_date":"2022-06-08 21:40:00","inspection_id":"75764482","dot_number":"3547997","report_state":"TN","report_number":"BBAA035653","insp_date":"2022-06-06 00:00:00","insp_start_time":"1110","insp_end_time":"1140","registration_date":null,"region":"ET","ci_status_code":"C","location":"SCALES","location_desc":"THP1 KNOX SCALES WEST","county_code_state":"TN","county_code":"093","insp_level_id":"1","service_center":"SH","census_source_id":"4","insp_facility":"F","shipper_name":"MILLER INDUSTRIES","shipping_paper_number":"9237920","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":"I","final_status_date":"2022-06-08 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"21500","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":"1577462","transaction_code":"A","transaction_date":"2022-06-06 00:00:00","upload_date":"2022-06-08 00:00:00","upload_first_byte":"0","upload_dot_number":"03547997","upload_search_indicator":null,"census_search_date":"2022-06-08 21:40:00","snet_input_date":"2022-06-08 00:00:00","source_office":"2TNS001","mcmis_add_date":"2022-06-08 21:40:00","insp_carrier_name":"CALTEX EXPRESS TRANSPORT LLC","insp_carrier_street":"923 FLORES DEL SOL","insp_carrier_city":"ALAMO","insp_carrier_state":"TX","insp_carrier_zip_code":"78516-1651","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:37:44.000000Z","updated_at":"2025-03-17T18:37:44.000000Z","inspection_violations":[],"inspection_per_units":[{"id":906403,"change_date":"2022-06-08 21:40:00","inspection_id":"75764482","insp_unit_id":"189114641","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":"MS04","insp_unit_license":"K128302","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3C6UR5HL1KG707021","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:47.000000Z","updated_at":"2025-03-17T22:13:47.000000Z"},{"id":906404,"change_date":"2022-06-08 21:40:00","inspection_id":"75764482","insp_unit_id":"189114642","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"792467K","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1P9GF3526LL375277","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:47.000000Z","updated_at":"2025-03-17T22:13:47.000000Z"}]},{"id":598111,"change_date":"2022-06-15 21:41:00","inspection_id":"75806217","dot_number":"3547997","report_state":"TX","report_number":"6BED0AHFYE","insp_date":"2022-05-31 00:00:00","insp_start_time":"1309","insp_end_time":"1410","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US-0059 IN NACOGDOCHES CO. (34","county_code_state":"TX","county_code":"347","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"LA","shipping_paper_number":"DNO28034","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-06-13 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"25900","viol_total":"1","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8676424","transaction_code":"C","transaction_date":"2022-06-15 00:00:00","upload_date":"2022-06-15 00:00:00","upload_first_byte":"0","upload_dot_number":"03547997","upload_search_indicator":"M","census_search_date":"2022-06-13 21:42:00","snet_input_date":"2022-05-31 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-06-13 21:42:00","insp_carrier_name":"CALTEX EXPRESS TRANSPORT LLC","insp_carrier_street":"923 FLORES DEL SOL","insp_carrier_city":"ALAMO","insp_carrier_state":"TX","insp_carrier_zip_code":"78516","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1028150","created_at":"2025-03-17T18:38:08.000000Z","updated_at":"2025-03-17T18:38:08.000000Z","inspection_violations":[{"id":939176,"change_date":"2022-06-15 21:41:00","inspection_id":"75806217","insp_violation_id":"246491373","seq_no":"1","part_no":"395","part_no_section":"8(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:23.000000Z","updated_at":"2025-03-17T21:11:23.000000Z","normalized_code":"3958A1"}],"inspection_per_units":[{"id":961586,"change_date":"2022-06-15 21:41:00","inspection_id":"75806217","insp_unit_id":"189273497","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":"MS05","insp_unit_license":"K162803","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3C6UR5CL2NG201208","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:07.000000Z","updated_at":"2025-03-17T22:14:07.000000Z"},{"id":961587,"change_date":"2022-06-15 21:41:00","inspection_id":"75806217","insp_unit_id":"189273498","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIGT","insp_unit_company":"MS005","insp_unit_license":"255160M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"16V3F4127N6186759","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:14:07.000000Z","updated_at":"2025-03-17T22:14:07.000000Z"}]},{"id":479476,"change_date":"2022-05-27 21:40:00","inspection_id":"75664772","dot_number":"3547997","report_state":"VA","report_number":"4415004761","insp_date":"2022-05-25 00:00:00","insp_start_time":"1200","insp_end_time":"1230","registration_date":null,"region":"ET","ci_status_code":"C","location":"0081","location_desc":"TRUCK REST AREA","county_code_state":"VA","county_code":"191","insp_level_id":"3","service_center":"EA","census_source_id":"4","insp_facility":"R","shipper_name":"WELIBILT FOODSERVICE WALK-INS","shipping_paper_number":"6254940","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":"I","final_status_date":"2022-05-27 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"37900","viol_total":"1","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"833157","transaction_code":"C","transaction_date":"2022-05-26 00:00:00","upload_date":"2022-05-26 00:00:00","upload_first_byte":"0","upload_dot_number":"03547997","upload_search_indicator":"M","census_search_date":"2022-05-27 21:40:00","snet_input_date":"2022-05-25 00:00:00","source_office":"1VAS001","mcmis_add_date":"2022-05-25 21:41:00","insp_carrier_name":"CALTEX EXPRESS TRANSPORT LLC","insp_carrier_street":"923 FLORES DEL SOL","insp_carrier_city":"ALAMO","insp_carrier_state":"TX","insp_carrier_zip_code":"78516-1651","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:36:01.000000Z","updated_at":"2025-03-17T18:36:01.000000Z","inspection_violations":[{"id":758795,"change_date":"2022-05-27 21:40:00","inspection_id":"75664772","insp_violation_id":"246123958","seq_no":"1","part_no":"395","part_no_section":"22(g)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:10:36.000000Z","updated_at":"2025-03-17T21:10:36.000000Z","normalized_code":"39522G"}],"inspection_per_units":[{"id":771053,"change_date":"2022-05-27 21:40:00","inspection_id":"75664772","insp_unit_id":"188953255","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":"MS02","insp_unit_license":"K128265","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3C63RRHL9KG524162","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:56.000000Z","updated_at":"2025-03-17T22:12:56.000000Z"},{"id":771054,"change_date":"2022-05-27 21:40:00","inspection_id":"75664772","insp_unit_id":"188953256","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIGT","insp_unit_company":"T022","insp_unit_license":"128C946","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"16VGX3524K6086018","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:56.000000Z","updated_at":"2025-03-17T22:12:56.000000Z"}]},{"id":486771,"change_date":"2022-05-26 21:42:00","inspection_id":"75673621","dot_number":"3547997","report_state":"GA","report_number":"1326002267","insp_date":"2022-05-25 00:00:00","insp_start_time":"1439","insp_end_time":"1518","registration_date":null,"region":"ET","ci_status_code":"C","location":"269","location_desc":"FRANKLIN CO I\/S NB","county_code_state":"GA","county_code":"119","insp_level_id":"1","service_center":"SH","census_source_id":"4","insp_facility":"F","shipper_name":"CARRIER","shipping_paper_number":"5645","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":"I","final_status_date":"2022-05-26 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"21500","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":"1895630","transaction_code":"A","transaction_date":"2022-05-25 00:00:00","upload_date":"2022-05-26 00:00:00","upload_first_byte":"0","upload_dot_number":"03547997","upload_search_indicator":null,"census_search_date":"2022-05-26 21:42:00","snet_input_date":"2022-05-26 00:00:00","source_office":"2GAS001","mcmis_add_date":"2022-05-26 21:42:00","insp_carrier_name":"CALTEX EXPRESS TRANSPORT LLC","insp_carrier_street":"923 FLORES DEL SOL","insp_carrier_city":"ALAMO","insp_carrier_state":"TX","insp_carrier_zip_code":"78516-1651","insp_colonia":null,"docket_number":"0","insp_interstate":"N","insp_carrier_state_id":null,"created_at":"2025-03-17T18:36:19.000000Z","updated_at":"2025-03-17T18:36:19.000000Z","inspection_violations":[],"inspection_per_units":[{"id":782546,"change_date":"2022-05-26 21:42:00","inspection_id":"75673621","insp_unit_id":"188922267","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":null,"insp_unit_license":"K128302","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3C6UR5HL1KG707021","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:00.000000Z","updated_at":"2025-03-17T22:13:00.000000Z"},{"id":782547,"change_date":"2022-05-26 21:42:00","inspection_id":"75673621","insp_unit_id":"188922268","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"OTH","insp_unit_company":null,"insp_unit_license":"792467K","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1P9GF3526LL375277","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:00.000000Z","updated_at":"2025-03-17T22:13:00.000000Z"}]},{"id":444930,"change_date":"2022-05-20 21:41:00","inspection_id":"75623494","dot_number":"3547997","report_state":"KS","report_number":"HP02890435","insp_date":"2022-05-19 00:00:00","insp_start_time":"1002","insp_end_time":"1026","registration_date":null,"region":"CT","ci_status_code":"C","location":"#26A","location_desc":"SOUTH HAVEN M.C.I.S. #26A","county_code_state":"KS","county_code":"191","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":"N","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-05-20 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"24500","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":"1250862","transaction_code":"A","transaction_date":"2022-05-19 00:00:00","upload_date":"2022-05-20 00:00:00","upload_first_byte":"0","upload_dot_number":"03547997","upload_search_indicator":null,"census_search_date":"2022-05-20 21:41:00","snet_input_date":"2022-05-19 00:00:00","source_office":"3KSS001","mcmis_add_date":"2022-05-20 21:41:00","insp_carrier_name":"CALTEX EXPRESS TRANSPORT LLC","insp_carrier_street":"923 FLORES DEL SOL","insp_carrier_city":"ALAMO","insp_carrier_state":"TX","insp_carrier_zip_code":"78516","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:35:36.000000Z","updated_at":"2025-03-17T18:35:36.000000Z","inspection_violations":[],"inspection_per_units":[{"id":717031,"change_date":"2022-05-20 21:41:00","inspection_id":"75623494","insp_unit_id":"188818148","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"MS03","insp_unit_license":"K127966","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FT7W2BT1KED37735","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:37.000000Z","updated_at":"2025-03-17T22:12:37.000000Z"},{"id":717032,"change_date":"2022-05-20 21:41:00","inspection_id":"75623494","insp_unit_id":"188818149","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIGT","insp_unit_company":"MS003","insp_unit_license":"150B981","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"16V3F3820M6091913","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:37.000000Z","updated_at":"2025-03-17T22:12:37.000000Z"}]},{"id":463869,"change_date":"2022-06-08 21:41:00","inspection_id":"75646248","dot_number":"3547997","report_state":"TX","report_number":"6B180XUZ34","insp_date":"2022-05-18 00:00:00","insp_start_time":"0846","insp_end_time":"0920","registration_date":null,"region":"CT","ci_status_code":"C","location":"1A402","location_desc":"IH 30 WESTBOUND MT PLEASANT","county_code_state":"TX","county_code":"449","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"SAMUEL","shipping_paper_number":"156013","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-05-23 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"24000","viol_total":"2","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8663210","transaction_code":"C","transaction_date":"2022-06-08 00:00:00","upload_date":"2022-06-08 00:00:00","upload_first_byte":"0","upload_dot_number":"03547997","upload_search_indicator":"M","census_search_date":"2022-05-23 21:43:00","snet_input_date":"2022-05-18 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-05-23 21:43:00","insp_carrier_name":"CALTEX EXPRESS TRANSPORT LLC","insp_carrier_street":"923 FLORES DEL SOL","insp_carrier_city":"ALAMO","insp_carrier_state":"TX","insp_carrier_zip_code":"78516","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1028150","created_at":"2025-03-17T18:35:56.000000Z","updated_at":"2025-03-17T18:35:56.000000Z","inspection_violations":[{"id":735071,"change_date":"2022-06-08 21:41:00","inspection_id":"75646248","insp_violation_id":"246310468","seq_no":"1","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"189122764","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:10:26.000000Z","updated_at":"2025-03-17T21:10:26.000000Z","normalized_code":"39348A"},{"id":735072,"change_date":"2022-06-08 21:41:00","inspection_id":"75646248","insp_violation_id":"246310469","seq_no":"2","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"189122764","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T21:10:26.000000Z","updated_at":"2025-03-17T21:10:26.000000Z","normalized_code":"3963A1"}],"inspection_per_units":[{"id":747503,"change_date":"2022-06-08 21:41:00","inspection_id":"75646248","insp_unit_id":"189122763","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"K127966","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FT7W2BT1KED37735","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:48.000000Z","updated_at":"2025-03-17T22:12:48.000000Z"},{"id":747504,"change_date":"2022-06-08 21:41:00","inspection_id":"75646248","insp_unit_id":"189122764","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIGT","insp_unit_company":null,"insp_unit_license":"150B981","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"16V3F3820M6091913","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:48.000000Z","updated_at":"2025-03-17T22:12:48.000000Z"}]},{"id":418569,"change_date":"2022-05-18 21:43:00","inspection_id":"75592200","dot_number":"3547997","report_state":"TN","report_number":"BBBA022317","insp_date":"2022-05-17 00:00:00","insp_start_time":"1042","insp_end_time":"1100","registration_date":null,"region":"ET","ci_status_code":"C","location":"SCALES","location_desc":"THP 1 KNOX SCALES - WEST","county_code_state":"TN","county_code":"093","insp_level_id":"1","service_center":"SH","census_source_id":"4","insp_facility":"F","shipper_name":"BNSF LOGISTICS","shipping_paper_number":"1108091","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":"N","pen_cen_match":"I","final_status_date":"2022-05-18 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"12000","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":"1573407","transaction_code":"A","transaction_date":"2022-05-17 00:00:00","upload_date":"2022-05-18 00:00:00","upload_first_byte":"0","upload_dot_number":"03547997","upload_search_indicator":null,"census_search_date":"2022-05-18 21:43:00","snet_input_date":"2022-05-18 00:00:00","source_office":"2TNS001","mcmis_add_date":"2022-05-18 21:43:00","insp_carrier_name":"CALTEX EXPRESS TRANSPORT LLC","insp_carrier_street":"923 FLORES DEL SOL","insp_carrier_city":"ALAMO","insp_carrier_state":"TX","insp_carrier_zip_code":"78516-1651","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:34:50.000000Z","updated_at":"2025-03-17T18:34:50.000000Z","inspection_violations":[],"inspection_per_units":[{"id":675522,"change_date":"2022-05-18 21:43:00","inspection_id":"75592200","insp_unit_id":"188756972","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"03","insp_unit_license":"K127966","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FT7W2BT1KED37735","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:21.000000Z","updated_at":"2025-03-17T22:12:21.000000Z"},{"id":675523,"change_date":"2022-05-18 21:43:00","inspection_id":"75592200","insp_unit_id":"188756973","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIGT","insp_unit_company":"MS003","insp_unit_license":"150B981","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"16V3F3820M6091913","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:12:21.000000Z","updated_at":"2025-03-17T22:12:21.000000Z"}]},{"id":164439,"change_date":"2022-04-13 21:40:00","inspection_id":"75288893","dot_number":"3547997","report_state":"NC","report_number":"0006410307","insp_date":"2022-04-13 00:00:00","insp_start_time":"1110","insp_end_time":"1140","registration_date":null,"region":"ET","ci_status_code":"C","location":"HALIFA","location_desc":"HALIFAX WEIGH STATION I-95 NB","county_code_state":"NC","county_code":"083","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-04-13 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"37900","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":"1943682","transaction_code":"A","transaction_date":"2022-04-13 00:00:00","upload_date":"2022-04-13 00:00:00","upload_first_byte":"0","upload_dot_number":"03547997","upload_search_indicator":"M","census_search_date":"2022-04-13 21:40:00","snet_input_date":"2022-04-13 00:00:00","source_office":"2NCS001","mcmis_add_date":"2022-04-13 21:40:00","insp_carrier_name":"CALTEX EXPRESS TRANSPORT LLC","insp_carrier_street":"923 FLORES DEL SOL","insp_carrier_city":"ALAMO","insp_carrier_state":"TX","insp_carrier_zip_code":"78516","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:30:28.000000Z","updated_at":"2025-03-17T18:30:28.000000Z","inspection_violations":[],"inspection_per_units":[{"id":266355,"change_date":"2022-04-13 21:40:00","inspection_id":"75288893","insp_unit_id":"188126821","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":null,"insp_unit_license":"KI28265","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3C63RRHL9KG524162","insp_unit_decal":"Y","insp_unit_decal_number":"31350382","created_at":"2025-03-17T22:09:48.000000Z","updated_at":"2025-03-17T22:09:48.000000Z"},{"id":266356,"change_date":"2022-04-13 21:40:00","inspection_id":"75288893","insp_unit_id":"188126822","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIGT","insp_unit_company":null,"insp_unit_license":"128C946","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"16VGX3524K6086018","insp_unit_decal":"Y","insp_unit_decal_number":"31350383","created_at":"2025-03-17T22:09:48.000000Z","updated_at":"2025-03-17T22:09:48.000000Z"}]},{"id":89176,"change_date":"2022-04-01 21:39:00","inspection_id":"75197234","dot_number":"3547997","report_state":"WI","report_number":"2628004004","insp_date":"2022-03-31 00:00:00","insp_start_time":"0850","insp_end_time":"0930","registration_date":null,"region":"CT","ci_status_code":"C","location":"S71","location_desc":"SUPERIOR SWEF","county_code_state":"WI","county_code":"031","insp_level_id":"2","service_center":"MW","census_source_id":"4","insp_facility":"F","shipper_name":"PEERLESS AMERICA INC","shipping_paper_number":"11595282","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":"I","final_status_date":"2022-04-01 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"21500","viol_total":"2","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"856583","transaction_code":"A","transaction_date":"2022-04-01 00:00:00","upload_date":"2022-04-01 00:00:00","upload_first_byte":"0","upload_dot_number":"03547997","upload_search_indicator":"M","census_search_date":"2022-04-01 21:39:00","snet_input_date":"2022-04-01 00:00:00","source_office":"3WIS001","mcmis_add_date":"2022-04-01 21:39:00","insp_carrier_name":"CALTEX EXPRESS TRANSPORT LLC","insp_carrier_street":"923 FLORES DEL SOL","insp_carrier_city":"ALAMO","insp_carrier_state":"TX","insp_carrier_zip_code":"78516","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:29:08.000000Z","updated_at":"2025-03-17T18:29:08.000000Z","inspection_violations":[{"id":132382,"change_date":"2022-04-01 21:39:00","inspection_id":"75197234","insp_violation_id":"244913184","seq_no":"1","part_no":"391","part_no_section":"45(b)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:41.000000Z","updated_at":"2025-03-17T21:07:41.000000Z","normalized_code":"39145B"},{"id":132383,"change_date":"2022-04-01 21:39:00","inspection_id":"75197234","insp_violation_id":"244913185","seq_no":"2","part_no":"395","part_no_section":"8(e)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:41.000000Z","updated_at":"2025-03-17T21:07:41.000000Z","normalized_code":"3958E1"}],"inspection_per_units":[{"id":144815,"change_date":"2022-04-01 21:39:00","inspection_id":"75197234","insp_unit_id":"187940882","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":null,"insp_unit_license":"K128302","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3C6UR5HL1KG707021","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:06.000000Z","updated_at":"2025-03-17T22:09:06.000000Z"},{"id":144816,"change_date":"2022-04-01 21:39:00","inspection_id":"75197234","insp_unit_id":"187940883","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"OTH","insp_unit_company":null,"insp_unit_license":"792467K","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1P9GF3526LL375277","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:06.000000Z","updated_at":"2025-03-17T22:09:06.000000Z"}]},{"id":94403,"change_date":"2022-04-26 21:41:00","inspection_id":"75203493","dot_number":"3547997","report_state":"PA","report_number":"D411208778","insp_date":"2022-03-28 00:00:00","insp_start_time":"1430","insp_end_time":"1530","registration_date":"2022-04-26 00:00:00","region":"ET","ci_status_code":"C","location":"999","location_desc":"ON I79 N AT ITS INTERSECTION W","county_code_state":"PA","county_code":"019","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","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":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-04-02 21:30:00","post_acc_ind":"N","gross_comb_veh_wt":"21500","viol_total":"3","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2243219","transaction_code":"C","transaction_date":"2022-03-28 00:00:00","upload_date":"2022-04-26 00:00:00","upload_first_byte":"0","upload_dot_number":"03547997","upload_search_indicator":null,"census_search_date":"2022-04-02 21:30:00","snet_input_date":"2022-03-28 00:00:00","source_office":"1PAS001","mcmis_add_date":"2022-04-02 21:30:00","insp_carrier_name":"CALTEX EXPRESS TRANSPORT LLC","insp_carrier_street":"923 FLORES DEL SOL","insp_carrier_city":"ALAMO","insp_carrier_state":"TX","insp_carrier_zip_code":"785161651","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:29:10.000000Z","updated_at":"2025-03-17T18:29:10.000000Z","inspection_violations":[{"id":139652,"change_date":"2022-04-26 21:41:00","inspection_id":"75203493","insp_violation_id":"245381008","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"40","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:42.000000Z","updated_at":"2025-03-17T21:07:42.000000Z","normalized_code":"3922"},{"id":139653,"change_date":"2022-04-26 21:41:00","inspection_id":"75203493","insp_violation_id":"245381009","seq_no":"2","part_no":"391","part_no_section":"45(b)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:42.000000Z","updated_at":"2025-03-17T21:07:42.000000Z","normalized_code":"39145B"},{"id":139654,"change_date":"2022-04-26 21:41:00","inspection_id":"75203493","insp_violation_id":"245381010","seq_no":"3","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"188349529","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:07:42.000000Z","updated_at":"2025-03-17T21:07:42.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":153140,"change_date":"2022-04-26 21:41:00","inspection_id":"75203493","insp_unit_id":"188349528","insp_unit_type_id":"6","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":null,"insp_unit_license":"K128302","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3C6UR5HL1KG707021","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:09.000000Z","updated_at":"2025-03-17T22:09:09.000000Z"},{"id":153141,"change_date":"2022-04-26 21:41:00","inspection_id":"75203493","insp_unit_id":"188349529","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"PULD","insp_unit_company":null,"insp_unit_license":"792467K","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1P9GF3526LL375277","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:09:09.000000Z","updated_at":"2025-03-17T22:09:09.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/3547997\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/3547997\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/3547997\/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\/3547997\/inspections","per_page":100,"prev_page_url":null,"to":51,"total":51}