{"current_page":1,"data":[{"id":12121372,"change_date":"2026-06-07 21:34:00","inspection_id":"88066870","dot_number":"3670419","report_state":"NM","report_number":"4660Q4BNHS","insp_date":"2026-06-04 00:00:00","insp_start_time":"1825","insp_end_time":"1900","registration_date":null,"region":"MT","ci_status_code":"C","location":null,"location_desc":"LORDSBURG PORT OF ENTRY","county_code_state":"NM","county_code":"023","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"CO PART","shipping_paper_number":"951278","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":"2026-06-07 21:34:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"2309585","transaction_code":"A","transaction_date":"2026-06-05 00:00:00","upload_date":"2026-06-07 00:00:00","upload_first_byte":"0","upload_dot_number":"03670419","upload_search_indicator":null,"census_search_date":"2026-06-07 21:34:00","snet_input_date":"2026-06-07 00:00:00","source_office":"2NMS001","mcmis_add_date":"2026-06-07 21:34:00","insp_carrier_name":"DELLET FERRER HOTSHOT LLC","insp_carrier_street":"1415 ELDRIDGE PARKWAY #225","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77077","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-06-10T09:40:01.000000Z","updated_at":"2026-06-18T09:30:38.000000Z","inspection_violations":[],"inspection_per_units":[{"id":21059280,"change_date":"2026-06-07 21:34:00","inspection_id":"88066870","insp_unit_id":"213958862","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":"TRU 01","insp_unit_license":"PST8695","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3C7WRTCL6MG578051","insp_unit_decal":"Y","insp_unit_decal_number":"03634150","created_at":"2026-06-10T09:14:54.000000Z","updated_at":"2026-06-18T09:02:05.000000Z"},{"id":21059281,"change_date":"2026-06-07 21:34:00","inspection_id":"88066870","insp_unit_id":"213958863","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"AME","insp_unit_company":"TRL 01","insp_unit_license":"259172N","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"17YGN38308B038581","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-10T09:14:54.000000Z","updated_at":"2026-06-18T09:02:05.000000Z"}]},{"id":12080909,"change_date":"2026-06-02 21:42:00","inspection_id":"88023730","dot_number":"3670419","report_state":"TX","report_number":"V262324438","insp_date":"2026-06-01 00:00:00","insp_start_time":"0109","insp_end_time":"0136","registration_date":null,"region":"MT","ci_status_code":"C","location":null,"location_desc":"42M IH10 WB","county_code_state":"TX","county_code":"141","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"EQUIPMENT MANAGEMENT SERVICES","shipping_paper_number":"DSV1675","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-06-02 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"24500","viol_total":"2","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9976857","transaction_code":"A","transaction_date":"2026-06-02 00:00:00","upload_date":"2026-06-02 00:00:00","upload_first_byte":"0","upload_dot_number":"03670419","upload_search_indicator":"M","census_search_date":"2026-06-02 21:42:00","snet_input_date":"2026-06-01 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-06-02 21:42:00","insp_carrier_name":"DELLET FERRER HOTSHOT LLC","insp_carrier_street":"1415 ELDRIDGE PARKWAY #225","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77077","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1026689","created_at":"2026-06-06T09:40:33.000000Z","updated_at":"2026-06-13T09:31:58.000000Z","inspection_violations":[{"id":21021834,"change_date":"2026-06-02 21:42:00","inspection_id":"88023730","insp_violation_id":"274654829","seq_no":"1","part_no":"390","part_no_section":"21(a)","insp_viol_unit":"1","insp_unit_id":"213880689","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-06-06T10:00:41.000000Z","updated_at":"2026-06-13T09:44:44.000000Z","normalized_code":"39021A"},{"id":21021835,"change_date":"2026-06-02 21:42:00","inspection_id":"88023730","insp_violation_id":"274654830","seq_no":"2","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":"2026-06-06T10:00:41.000000Z","updated_at":"2026-06-13T09:44:44.000000Z","normalized_code":"39524C2III"}],"inspection_per_units":[{"id":20993254,"change_date":"2026-06-02 21:42:00","inspection_id":"88023730","insp_unit_id":"213880689","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"3","insp_unit_license":"TJK0575","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FDWX36F63EA10229","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-06T09:17:34.000000Z","updated_at":"2026-06-13T09:03:30.000000Z"},{"id":20993255,"change_date":"2026-06-02 21:42:00","inspection_id":"88023730","insp_unit_id":"213880690","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":"02","insp_unit_license":"354822T","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"5R8GF4025PM100760","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-06T09:17:34.000000Z","updated_at":"2026-06-13T09:03:30.000000Z"}]},{"id":12020035,"change_date":"2026-05-26 21:40:00","inspection_id":"87959592","dot_number":"3670419","report_state":"TX","report_number":"7FRD9DTA0Y","insp_date":"2026-05-23 00:00:00","insp_start_time":"1300","insp_end_time":"1338","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0010 IN ORANGE CO. (855-880","county_code_state":"TX","county_code":"361","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"INSURANCE AUTO GROUP","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-05-26 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"9968549","transaction_code":"A","transaction_date":"2026-05-26 00:00:00","upload_date":"2026-05-26 00:00:00","upload_first_byte":"0","upload_dot_number":"03670419","upload_search_indicator":"M","census_search_date":"2026-05-26 21:40:00","snet_input_date":"2026-05-23 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-05-26 21:40:00","insp_carrier_name":"DELLET FERRER HOTSHOT LLC","insp_carrier_street":"1415 ELDRIDGE PARKWAY #225","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77077","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1026689","created_at":"2026-05-29T09:40:01.000000Z","updated_at":"2026-06-06T09:32:09.000000Z","inspection_violations":[{"id":20913290,"change_date":"2026-05-26 21:40:00","inspection_id":"87959592","insp_violation_id":"274505896","seq_no":"1","part_no":"395","part_no_section":"8E1-PC","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":"2026-05-29T09:59:42.000000Z","updated_at":"2026-06-06T09:44:31.000000Z","normalized_code":"3958E1PC"}],"inspection_per_units":[{"id":20893469,"change_date":"2026-05-26 21:40:00","inspection_id":"87959592","insp_unit_id":"213757223","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":"1","insp_unit_license":"PST8695","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3C7WRTCL6MG578051","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-29T09:17:40.000000Z","updated_at":"2026-06-06T09:04:24.000000Z"},{"id":20893470,"change_date":"2026-05-26 21:40:00","inspection_id":"87959592","insp_unit_id":"213757224","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"AMER","insp_unit_company":"1","insp_unit_license":"259172N","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"17YGN38308B038581","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-29T09:17:40.000000Z","updated_at":"2026-06-06T09:04:24.000000Z"}]},{"id":11966434,"change_date":"2026-05-19 21:41:00","inspection_id":"87902900","dot_number":"3670419","report_state":"IA","report_number":"000P16CWZN","insp_date":"2026-05-07 00:00:00","insp_start_time":"1947","insp_end_time":"2020","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":"1","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"SCHLAGEL, INC.","shipping_paper_number":"334337","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":"2026-05-19 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"39900","viol_total":"3","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1399846","transaction_code":"A","transaction_date":"2026-05-19 00:00:00","upload_date":"2026-05-19 00:00:00","upload_first_byte":"0","upload_dot_number":"03670419","upload_search_indicator":"M","census_search_date":"2026-05-19 21:41:00","snet_input_date":"2026-05-07 00:00:00","source_office":"3IAS001","mcmis_add_date":"2026-05-19 21:41:00","insp_carrier_name":"DELLET FERRER HOTSHOT LLC","insp_carrier_street":"1415 ELDRIDGE PARKWAY #225","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77077","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-05-22T09:41:17.000000Z","updated_at":"2026-05-30T09:31:19.000000Z","inspection_violations":[{"id":20815296,"change_date":"2026-05-19 21:41:00","inspection_id":"87902900","insp_violation_id":"274375473","seq_no":"2","part_no":"395","part_no_section":"22G","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":"2026-05-22T10:01:47.000000Z","updated_at":"2026-05-30T09:42:11.000000Z","normalized_code":"39522G"},{"id":20815295,"change_date":"2026-05-19 21:41:00","inspection_id":"87902900","insp_violation_id":"274375472","seq_no":"1","part_no":"393","part_no_section":"60D","insp_viol_unit":"1","insp_unit_id":"213651588","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"8ARB26050720161","created_at":"2026-05-22T10:01:47.000000Z","updated_at":"2026-05-30T09:42:11.000000Z","normalized_code":"39360D"},{"id":20815297,"change_date":"2026-05-19 21:41:00","inspection_id":"87902900","insp_violation_id":"274375474","seq_no":"3","part_no":"392","part_no_section":"2DIM","insp_viol_unit":"2","insp_unit_id":"213651589","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-05-22T10:01:47.000000Z","updated_at":"2026-05-30T09:42:11.000000Z","normalized_code":"3922DIM"}],"inspection_per_units":[{"id":20805834,"change_date":"2026-05-19 21:41:00","inspection_id":"87902900","insp_unit_id":"213651588","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"04","insp_unit_license":"K130111","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FT8W3DT9KEC96861","insp_unit_decal":"Y","insp_unit_decal_number":"36426833","created_at":"2026-05-22T09:21:57.000000Z","updated_at":"2026-05-30T09:03:51.000000Z"},{"id":20805835,"change_date":"2026-05-19 21:41:00","inspection_id":"87902900","insp_unit_id":"213651589","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIGT","insp_unit_company":"2","insp_unit_license":"229C171","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"16V3F4821R6342371","insp_unit_decal":"Y","insp_unit_decal_number":"36426834","created_at":"2026-05-22T09:21:57.000000Z","updated_at":"2026-05-30T09:03:51.000000Z"}]},{"id":11543965,"change_date":"2026-04-03 21:38:00","inspection_id":"87466497","dot_number":"3670419","report_state":"TX","report_number":"V262257854","insp_date":"2026-03-29 00:00:00","insp_start_time":"1731","insp_end_time":"1827","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"37801 IH10 WB SVC RD","county_code_state":"TX","county_code":"071","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"VALUE CITY FURNITURE","shipping_paper_number":"674529","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-04-01 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"39900","viol_total":"4","oos_total":"1","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9904625","transaction_code":"C","transaction_date":"2026-04-03 00:00:00","upload_date":"2026-04-03 00:00:00","upload_first_byte":"0","upload_dot_number":"03670419","upload_search_indicator":"M","census_search_date":"2026-04-01 21:40:00","snet_input_date":"2026-03-29 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-04-01 21:40:00","insp_carrier_name":"DELLET FERRER HOTSHOT LLC","insp_carrier_street":"1415 ELDRIDGE PARKWAY #225","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77077","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1026689","created_at":"2026-04-04T09:43:32.000000Z","updated_at":"2026-04-14T09:31:09.000000Z","inspection_violations":[{"id":19545846,"change_date":"2026-04-03 21:38:00","inspection_id":"87466497","insp_violation_id":"272856621","seq_no":"1","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"212531469","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-06T10:18:10.000000Z","updated_at":"2026-04-13T10:11:17.000000Z","normalized_code":"3939"},{"id":19545847,"change_date":"2026-04-03 21:38:00","inspection_id":"87466497","insp_violation_id":"272856622","seq_no":"2","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"212531470","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-06T10:18:10.000000Z","updated_at":"2026-04-13T10:11:17.000000Z","normalized_code":"3939"},{"id":19545848,"change_date":"2026-04-03 21:38:00","inspection_id":"87466497","insp_violation_id":"272856623","seq_no":"3","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"212531470","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-04-06T10:18:10.000000Z","updated_at":"2026-04-13T10:11:17.000000Z","normalized_code":"3939"},{"id":19545849,"change_date":"2026-04-03 21:38:00","inspection_id":"87466497","insp_violation_id":"272856624","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":"3","citation_number":null,"created_at":"2026-04-06T10:18:10.000000Z","updated_at":"2026-04-13T10:11:17.000000Z","normalized_code":"3958AELD"}],"inspection_per_units":[{"id":19817595,"change_date":"2026-04-03 21:38:00","inspection_id":"87466497","insp_unit_id":"212531469","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"K130111","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FT8W3DT9KEC96861","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-06T09:38:26.000000Z","updated_at":"2026-04-14T09:03:50.000000Z"},{"id":19817596,"change_date":"2026-04-03 21:38:00","inspection_id":"87466497","insp_unit_id":"212531470","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIGT","insp_unit_company":null,"insp_unit_license":"229C171","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"16V3F4821R6342371","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-06T09:38:26.000000Z","updated_at":"2026-04-14T09:03:50.000000Z"}]},{"id":11309877,"change_date":"2026-03-06 21:42:00","inspection_id":"87225989","dot_number":"3670419","report_state":"KS","report_number":"HP00967455","insp_date":"2026-03-05 00:00:00","insp_start_time":"1303","insp_end_time":"1412","registration_date":null,"region":"CT","ci_status_code":"C","location":"CF","location_desc":"COFFEY COUNTY - 031","county_code_state":"KS","county_code":"031","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"EBOH SERVICES","shipping_paper_number":"49","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":"2026-03-06 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"17","oos_total":"5","driver_viol_total":"5","driver_oos_total":"2","vehicle_viol_total":"12","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1390612","transaction_code":"A","transaction_date":"2026-03-05 00:00:00","upload_date":"2026-03-06 00:00:00","upload_first_byte":"0","upload_dot_number":"03670419","upload_search_indicator":null,"census_search_date":"2026-03-06 21:42:00","snet_input_date":"2026-03-05 00:00:00","source_office":"3KSS001","mcmis_add_date":"2026-03-06 21:42:00","insp_carrier_name":"DELLET FERRER HOTSHOT LLC","insp_carrier_street":"1415 ELDRIDGE PARKWAY #225","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77077","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-09T09:42:39.000000Z","updated_at":"2026-03-17T09:31:05.000000Z","inspection_violations":[{"id":19028987,"change_date":"2026-03-06 21:42:00","inspection_id":"87225989","insp_violation_id":"272247822","seq_no":"1","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"212011028","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-09T10:08:42.000000Z","updated_at":"2026-03-17T09:40:17.000000Z","normalized_code":"39360C"},{"id":19028988,"change_date":"2026-03-06 21:42:00","inspection_id":"87225989","insp_violation_id":"272247823","seq_no":"2","part_no":"393","part_no_section":"60D","insp_viol_unit":"1","insp_unit_id":"212011028","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-09T10:08:42.000000Z","updated_at":"2026-03-17T09:40:17.000000Z","normalized_code":"39360D"},{"id":19028989,"change_date":"2026-03-06 21:42:00","inspection_id":"87225989","insp_violation_id":"272247824","seq_no":"3","part_no":"393","part_no_section":"43D-B","insp_viol_unit":"2","insp_unit_id":"212011029","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-03-09T10:08:42.000000Z","updated_at":"2026-03-17T09:40:17.000000Z","normalized_code":"39343DB"},{"id":19028990,"change_date":"2026-03-06 21:42:00","inspection_id":"87225989","insp_violation_id":"272247825","seq_no":"4","part_no":"393","part_no_section":"48A-BIHE","insp_viol_unit":"2","insp_unit_id":"212011029","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-09T10:08:42.000000Z","updated_at":"2026-03-17T09:40:17.000000Z","normalized_code":"39348ABIHE"},{"id":19028991,"change_date":"2026-03-06 21:42:00","inspection_id":"87225989","insp_violation_id":"272247826","seq_no":"5","part_no":"393","part_no_section":"48A-BIHE","insp_viol_unit":"2","insp_unit_id":"212011029","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-09T10:08:42.000000Z","updated_at":"2026-03-17T09:40:17.000000Z","normalized_code":"39348ABIHE"},{"id":19028992,"change_date":"2026-03-06 21:42:00","inspection_id":"87225989","insp_violation_id":"272247827","seq_no":"6","part_no":"393","part_no_section":"48A-BIHE","insp_viol_unit":"2","insp_unit_id":"212011029","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-09T10:08:42.000000Z","updated_at":"2026-03-17T09:40:17.000000Z","normalized_code":"39348ABIHE"},{"id":19028993,"change_date":"2026-03-06 21:42:00","inspection_id":"87225989","insp_violation_id":"272247828","seq_no":"7","part_no":"393","part_no_section":"48A-BIHE","insp_viol_unit":"2","insp_unit_id":"212011029","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-09T10:08:42.000000Z","updated_at":"2026-03-17T09:40:17.000000Z","normalized_code":"39348ABIHE"},{"id":19028994,"change_date":"2026-03-06 21:42:00","inspection_id":"87225989","insp_violation_id":"272247829","seq_no":"8","part_no":"396","part_no_section":"3A1-BOS","insp_viol_unit":"2","insp_unit_id":"212011029","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-03-09T10:08:42.000000Z","updated_at":"2026-03-17T09:40:17.000000Z","normalized_code":"3963A1BOS"},{"id":19028995,"change_date":"2026-03-06 21:42:00","inspection_id":"87225989","insp_violation_id":"272247830","seq_no":"9","part_no":"393","part_no_section":"9A-LIL","insp_viol_unit":"2","insp_unit_id":"212011029","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-09T10:08:42.000000Z","updated_at":"2026-03-17T09:40:17.000000Z","normalized_code":"3939ALIL"},{"id":19028996,"change_date":"2026-03-06 21:42:00","inspection_id":"87225989","insp_violation_id":"272247831","seq_no":"10","part_no":"393","part_no_section":"9A-LLPL","insp_viol_unit":"2","insp_unit_id":"212011029","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-09T10:08:42.000000Z","updated_at":"2026-03-17T09:40:17.000000Z","normalized_code":"3939ALLPL"},{"id":19028997,"change_date":"2026-03-06 21:42:00","inspection_id":"87225989","insp_violation_id":"272247832","seq_no":"11","part_no":"395","part_no_section":"22G-ELDMFV","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":"2026-03-09T10:08:42.000000Z","updated_at":"2026-03-17T09:40:17.000000Z","normalized_code":"39522GELDMFV"},{"id":19028998,"change_date":"2026-03-06 21:42:00","inspection_id":"87225989","insp_violation_id":"272247833","seq_no":"12","part_no":"391","part_no_section":"41APC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-09T10:08:42.000000Z","updated_at":"2026-03-17T09:40:17.000000Z","normalized_code":"39141APC"},{"id":19028999,"change_date":"2026-03-06 21:42:00","inspection_id":"87225989","insp_violation_id":"272247834","seq_no":"13","part_no":"395","part_no_section":"24C2II-ELDTN","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":"2026-03-09T10:08:42.000000Z","updated_at":"2026-03-17T09:40:17.000000Z","normalized_code":"39524C2IIELDTN"},{"id":19029000,"change_date":"2026-03-06 21:42:00","inspection_id":"87225989","insp_violation_id":"272247835","seq_no":"14","part_no":"395","part_no_section":"24C2III-ELDSDN","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":"2026-03-09T10:08:42.000000Z","updated_at":"2026-03-17T09:40:17.000000Z","normalized_code":"39524C2IIIELDSDN"},{"id":19029001,"change_date":"2026-03-06 21:42:00","inspection_id":"87225989","insp_violation_id":"272247836","seq_no":"15","part_no":"396","part_no_section":"17C-PI","insp_viol_unit":"2","insp_unit_id":"212011029","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-09T10:08:42.000000Z","updated_at":"2026-03-17T09:40:17.000000Z","normalized_code":"39617CPI"},{"id":19029002,"change_date":"2026-03-06 21:42:00","inspection_id":"87225989","insp_violation_id":"272247837","seq_no":"16","part_no":"393","part_no_section":"75C-TAOTD-LT1\/32","insp_viol_unit":"2","insp_unit_id":"212011029","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-03-09T10:08:42.000000Z","updated_at":"2026-03-17T09:40:17.000000Z","normalized_code":"39375CTAOTDLT1\/32"},{"id":19029003,"change_date":"2026-03-06 21:42:00","inspection_id":"87225989","insp_violation_id":"272247838","seq_no":"17","part_no":"391","part_no_section":"11B2-Q","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"54","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-09T10:08:42.000000Z","updated_at":"2026-03-17T09:40:17.000000Z","normalized_code":"39111B2Q"}],"inspection_per_units":[{"id":19350327,"change_date":"2026-03-06 21:42:00","inspection_id":"87225989","insp_unit_id":"212011028","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"RJF8556","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FT8W3DT9HEC42839","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-09T09:28:25.000000Z","updated_at":"2026-03-17T09:03:29.000000Z"},{"id":19350328,"change_date":"2026-03-06 21:42:00","inspection_id":"87225989","insp_unit_id":"212011029","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":"02","insp_unit_license":"034899M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5RVFS4028MP102226","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-09T09:28:25.000000Z","updated_at":"2026-03-17T09:03:29.000000Z"}]},{"id":11162842,"change_date":"2026-02-18 21:38:00","inspection_id":"87078143","dot_number":"3670419","report_state":"OK","report_number":"C106154544","insp_date":"2026-02-18 00:00:00","insp_start_time":"0538","insp_end_time":"0615","registration_date":null,"region":"CT","ci_status_code":"C","location":"14035","location_desc":"NORMAN","county_code_state":"OK","county_code":"027","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"TIMELESS","shipping_paper_number":"BOL26109","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":"2026-02-18 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"812603","transaction_code":"A","transaction_date":"2026-02-18 00:00:00","upload_date":"2026-02-18 00:00:00","upload_first_byte":"0","upload_dot_number":"03670419","upload_search_indicator":"M","census_search_date":"2026-02-18 21:38:00","snet_input_date":"2026-02-18 00:00:00","source_office":"2OKS001","mcmis_add_date":"2026-02-18 21:38:00","insp_carrier_name":"DELLET FERRER HOTSHOT LLC","insp_carrier_street":"1415 ELDRIDGE PARKWAY #225","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77077","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-21T10:38:01.000000Z","updated_at":"2026-03-01T10:30:38.000000Z","inspection_violations":[{"id":18710175,"change_date":"2026-02-18 21:38:00","inspection_id":"87078143","insp_violation_id":"271873532","seq_no":"1","part_no":"392","part_no_section":"2-SLLS1","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-21T10:53:43.000000Z","updated_at":"2026-03-01T10:40:25.000000Z","normalized_code":"3922SLLS1"}],"inspection_per_units":[{"id":19045492,"change_date":"2026-02-18 21:38:00","inspection_id":"87078143","insp_unit_id":"211689886","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"TXJ4735","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FT8W3DT8NEF22781","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-21T10:14:02.000000Z","updated_at":"2026-03-01T10:03:28.000000Z"},{"id":19045493,"change_date":"2026-02-18 21:38:00","inspection_id":"87078143","insp_unit_id":"211689887","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"RAW M","insp_unit_company":null,"insp_unit_license":"089414N","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3EVGF4025S1116965","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-21T10:14:02.000000Z","updated_at":"2026-03-01T10:03:28.000000Z"}]},{"id":11130841,"change_date":"2026-02-13 21:39:00","inspection_id":"87044305","dot_number":"3670419","report_state":"TX","report_number":"7CYI9DMP0H","insp_date":"2026-02-11 00:00:00","insp_start_time":"1803","insp_end_time":"1906","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US-0287 IN ELLIS CO. (484-520)","county_code_state":"TX","county_code":"139","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"COPART","shipping_paper_number":"73893515BK","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-02-13 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"39900","viol_total":"8","oos_total":"0","driver_viol_total":"4","driver_oos_total":"0","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9849650","transaction_code":"A","transaction_date":"2026-02-13 00:00:00","upload_date":"2026-02-13 00:00:00","upload_first_byte":"0","upload_dot_number":"03670419","upload_search_indicator":"M","census_search_date":"2026-02-13 21:39:00","snet_input_date":"2026-02-12 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-02-13 21:39:00","insp_carrier_name":"DELLET FERRER HOTSHOT LLC","insp_carrier_street":"1415 ELDRIDGE PARKWAY #225","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77077","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1026689","created_at":"2026-02-16T10:38:48.000000Z","updated_at":"2026-02-24T10:31:05.000000Z","inspection_violations":[{"id":18646549,"change_date":"2026-02-13 21:39:00","inspection_id":"87044305","insp_violation_id":"271794925","seq_no":"4","part_no":"393","part_no_section":"60D","insp_viol_unit":"1","insp_unit_id":"211621395","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-16T10:54:41.000000Z","updated_at":"2026-02-24T10:39:41.000000Z","normalized_code":"39360D"},{"id":18646547,"change_date":"2026-02-13 21:39:00","inspection_id":"87044305","insp_violation_id":"271794923","seq_no":"1","part_no":"390","part_no_section":"21(a)","insp_viol_unit":"1","insp_unit_id":"211621395","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-16T10:54:41.000000Z","updated_at":"2026-02-24T10:39:41.000000Z","normalized_code":"39021A"},{"id":18646548,"change_date":"2026-02-13 21:39:00","inspection_id":"87044305","insp_violation_id":"271794924","seq_no":"2","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"211621395","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-16T10:54:41.000000Z","updated_at":"2026-02-24T10:39:41.000000Z","normalized_code":"3922RG"},{"id":18646550,"change_date":"2026-02-13 21:39:00","inspection_id":"87044305","insp_violation_id":"271794926","seq_no":"5","part_no":"392","part_no_section":"16","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-16T10:54:41.000000Z","updated_at":"2026-02-24T10:39:41.000000Z","normalized_code":"39216"},{"id":18646551,"change_date":"2026-02-13 21:39:00","inspection_id":"87044305","insp_violation_id":"271794927","seq_no":"6","part_no":"395","part_no_section":"22H4","insp_viol_unit":"1","insp_unit_id":"211621395","insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-16T10:54:41.000000Z","updated_at":"2026-02-24T10:39:41.000000Z","normalized_code":"39522H4"},{"id":18646552,"change_date":"2026-02-13 21:39:00","inspection_id":"87044305","insp_violation_id":"271794928","seq_no":"7","part_no":"395","part_no_section":"24D","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":"2026-02-16T10:54:41.000000Z","updated_at":"2026-02-24T10:39:41.000000Z","normalized_code":"39524D"},{"id":18646553,"change_date":"2026-02-13 21:39:00","inspection_id":"87044305","insp_violation_id":"271794929","seq_no":"8","part_no":"395","part_no_section":"8E1-PC","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":"2026-02-16T10:54:41.000000Z","updated_at":"2026-02-24T10:39:41.000000Z","normalized_code":"3958E1PC"},{"id":18646554,"change_date":"2026-02-13 21:39:00","inspection_id":"87044305","insp_violation_id":"271794930","seq_no":"9","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":"2026-02-16T10:54:41.000000Z","updated_at":"2026-02-24T10:39:41.000000Z","normalized_code":"3958E"}],"inspection_per_units":[{"id":18987481,"change_date":"2026-02-13 21:39:00","inspection_id":"87044305","insp_unit_id":"211621395","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"01","insp_unit_license":"WZN8900","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FT8W3DM3REC00578","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-16T10:15:05.000000Z","updated_at":"2026-02-24T10:03:31.000000Z"},{"id":18987482,"change_date":"2026-02-13 21:39:00","inspection_id":"87044305","insp_unit_id":"211621396","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIGT","insp_unit_company":null,"insp_unit_license":"322896N","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"16V3F4824T6435201","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-16T10:15:05.000000Z","updated_at":"2026-02-24T10:03:31.000000Z"}]},{"id":11140527,"change_date":"2026-02-16 21:35:00","inspection_id":"87054536","dot_number":"3670419","report_state":"AR","report_number":"8240001123","insp_date":"2026-02-11 00:00:00","insp_start_time":"1929","insp_end_time":"2000","registration_date":null,"region":"CS","ci_status_code":"C","location":"302","location_desc":"VAN BUREN AR","county_code_state":"AR","county_code":"033","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"MG3","shipping_paper_number":"LD7674986","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":"2026-02-16 21:35: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":"2892279","transaction_code":"A","transaction_date":"2026-02-15 00:00:00","upload_date":"2026-02-16 00:00:00","upload_first_byte":"0","upload_dot_number":"03670419","upload_search_indicator":null,"census_search_date":"2026-02-16 21:35:00","snet_input_date":"2026-02-11 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-02-16 21:35:00","insp_carrier_name":"DELLET FERRER HOTSHOT LLC","insp_carrier_street":"1415 ELDRIDGE PARKWAY #225","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77077","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-19T10:37:10.000000Z","updated_at":"2026-02-27T10:30:12.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19004275,"change_date":"2026-02-16 21:35:00","inspection_id":"87054536","insp_unit_id":"211641904","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"COURIER","insp_unit_company":"05","insp_unit_license":"K130111","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FT8W3DT9KEC96861","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-19T10:12:50.000000Z","updated_at":"2026-02-27T10:02:25.000000Z"},{"id":19004276,"change_date":"2026-02-16 21:35:00","inspection_id":"87054536","insp_unit_id":"211641905","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIG TEX","insp_unit_company":"02","insp_unit_license":"229C171","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"16V3F4821R6342371","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-19T10:12:50.000000Z","updated_at":"2026-02-27T10:02:25.000000Z"}]},{"id":11101984,"change_date":"2026-02-11 21:38:00","inspection_id":"87014087","dot_number":"3670419","report_state":"MO","report_number":"W110000640","insp_date":"2026-02-06 00:00:00","insp_start_time":"1040","insp_end_time":"1136","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"KEARNEY MO","county_code_state":"MO","county_code":"047","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"NONE","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":"2026-02-11 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"4","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2871682","transaction_code":"A","transaction_date":"2026-02-11 00:00:00","upload_date":"2026-02-11 00:00:00","upload_first_byte":"0","upload_dot_number":"03670419","upload_search_indicator":null,"census_search_date":"2026-02-11 21:38:00","snet_input_date":"2026-02-06 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-02-11 21:38:00","insp_carrier_name":"DELLET FERRER HOTSHOT LLC","insp_carrier_street":"1415 ELDRIDGE PARKWAY #225","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77077","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-14T10:37:30.000000Z","updated_at":"2026-02-22T10:30:22.000000Z","inspection_violations":[{"id":18591440,"change_date":"2026-02-11 21:38:00","inspection_id":"87014087","insp_violation_id":"271724183","seq_no":"1","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"211556333","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-14T10:52:08.000000Z","updated_at":"2026-02-22T10:38:56.000000Z","normalized_code":"39360C"},{"id":18591441,"change_date":"2026-02-11 21:38:00","inspection_id":"87014087","insp_violation_id":"271724184","seq_no":"2","part_no":"393","part_no_section":"60D","insp_viol_unit":"1","insp_unit_id":"211556333","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-14T10:52:08.000000Z","updated_at":"2026-02-22T10:38:56.000000Z","normalized_code":"39360D"},{"id":18591442,"change_date":"2026-02-11 21:38:00","inspection_id":"87014087","insp_violation_id":"271724185","seq_no":"3","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":"2026-02-14T10:52:08.000000Z","updated_at":"2026-02-22T10:38:56.000000Z","normalized_code":"3958EHOSPD"},{"id":18591443,"change_date":"2026-02-11 21:38:00","inspection_id":"87014087","insp_violation_id":"271724186","seq_no":"4","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":"2026-02-14T10:52:08.000000Z","updated_at":"2026-02-22T10:38:56.000000Z","normalized_code":"3958EHOSPD"}],"inspection_per_units":[{"id":18933213,"change_date":"2026-02-11 21:38:00","inspection_id":"87014087","insp_unit_id":"211556333","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"RFJ8556","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FT8W3DT9HEC42839","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-14T10:15:29.000000Z","updated_at":"2026-02-22T10:02:37.000000Z"},{"id":18933214,"change_date":"2026-02-11 21:38:00","inspection_id":"87014087","insp_unit_id":"211556334","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"LAMA","insp_unit_company":null,"insp_unit_license":"034899M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5RVFS4028MP102226","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-14T10:15:29.000000Z","updated_at":"2026-02-22T10:02:37.000000Z"}]},{"id":10599337,"change_date":"2026-01-08 21:39:00","inspection_id":"86738618","dot_number":"3670419","report_state":"IL","report_number":"5005120343","insp_date":"2026-01-07 00:00:00","insp_start_time":"0808","insp_end_time":"0851","registration_date":null,"region":"CT","ci_status_code":"C","location":"115","location_desc":"115 - S I-39 SB WILLOWCREEK R.","county_code_state":"IL","county_code":"103","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"VULCAN FINNED TUBES, L.P.","shipping_paper_number":"16721N","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":"2026-01-08 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"39900","viol_total":"7","oos_total":"3","driver_viol_total":"0","driver_oos_total":"2","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2450135","transaction_code":"A","transaction_date":"2026-01-07 00:00:00","upload_date":"2026-01-08 00:00:00","upload_first_byte":"0","upload_dot_number":"03670419","upload_search_indicator":null,"census_search_date":"2026-01-08 21:39:00","snet_input_date":"2026-01-07 00:00:00","source_office":"3ILS001","mcmis_add_date":"2026-01-08 21:39:00","insp_carrier_name":"DELLET FERRER HOTSHOT LLC","insp_carrier_street":"1415 ELDRIDGE PARKWAY #225","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77077","insp_colonia":null,"docket_number":"127251","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-01-11T10:34:43.000000Z","updated_at":"2026-01-19T10:30:44.000000Z","inspection_violations":[{"id":17817621,"change_date":"2026-01-08 21:39:00","inspection_id":"86738618","insp_violation_id":"271086218","seq_no":"1","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"210977641","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-11T10:39:17.000000Z","updated_at":"2026-01-19T10:31:18.000000Z","normalized_code":"3939"},{"id":17817622,"change_date":"2026-01-08 21:39:00","inspection_id":"86738618","insp_violation_id":"271086219","seq_no":"2","part_no":"392","part_no_section":"2FT","insp_viol_unit":"1","insp_unit_id":"210977640","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-01-11T10:39:17.000000Z","updated_at":"2026-01-19T10:31:18.000000Z","normalized_code":"3922FT"},{"id":17817623,"change_date":"2026-01-08 21:39:00","inspection_id":"86738618","insp_violation_id":"271086220","seq_no":"3","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":"3","citation_number":null,"created_at":"2026-01-11T10:39:17.000000Z","updated_at":"2026-01-19T10:31:18.000000Z","normalized_code":"3958E"},{"id":17817624,"change_date":"2026-01-08 21:39:00","inspection_id":"86738618","insp_violation_id":"271086221","seq_no":"4","part_no":"393","part_no_section":"75C","insp_viol_unit":"2","insp_unit_id":"210977641","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"99","citation_number":null,"created_at":"2026-01-11T10:39:17.000000Z","updated_at":"2026-01-19T10:31:18.000000Z","normalized_code":"39375C"},{"id":17817625,"change_date":"2026-01-08 21:39:00","inspection_id":"86738618","insp_violation_id":"271086222","seq_no":"5","part_no":"393","part_no_section":"75C","insp_viol_unit":"2","insp_unit_id":"210977641","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"99","citation_number":null,"created_at":"2026-01-11T10:39:17.000000Z","updated_at":"2026-01-19T10:31:18.000000Z","normalized_code":"39375C"},{"id":17817626,"change_date":"2026-01-08 21:39:00","inspection_id":"86738618","insp_violation_id":"271086223","seq_no":"6","part_no":"393","part_no_section":"41","insp_viol_unit":"1","insp_unit_id":"210977640","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2026-01-11T10:39:17.000000Z","updated_at":"2026-01-19T10:31:18.000000Z","normalized_code":"39341"},{"id":17817627,"change_date":"2026-01-08 21:39:00","inspection_id":"86738618","insp_violation_id":"271086224","seq_no":"7","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":"3","citation_number":null,"created_at":"2026-01-11T10:39:17.000000Z","updated_at":"2026-01-19T10:31:18.000000Z","normalized_code":"3953A2PROP"}],"inspection_per_units":[{"id":17769179,"change_date":"2026-01-08 21:39:00","inspection_id":"86738618","insp_unit_id":"210977640","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"02","insp_unit_license":"K130111","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FT8W3DT9KEC96861","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-11T10:06:12.000000Z","updated_at":"2026-01-19T10:00:51.000000Z"},{"id":17769180,"change_date":"2026-01-08 21:39:00","inspection_id":"86738618","insp_unit_id":"210977641","insp_unit_type_id":"6","insp_unit_number":"2","insp_unit_make":"BIGT","insp_unit_company":"02","insp_unit_license":"229C171","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"16V3F4821R6342371","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-01-11T10:06:12.000000Z","updated_at":"2026-01-19T10:00:51.000000Z"}]},{"id":10517645,"change_date":"2025-12-26 21:33:00","inspection_id":"86653183","dot_number":"3670419","report_state":"MO","report_number":"0825000353","insp_date":"2025-12-20 00:00:00","insp_start_time":"1700","insp_end_time":"1740","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"HOUSTONIA MO","county_code_state":"MO","county_code":"195","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"84115","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-12-26 21:33: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":"2699345","transaction_code":"A","transaction_date":"2025-12-25 00:00:00","upload_date":"2025-12-26 00:00:00","upload_first_byte":"0","upload_dot_number":"03670419","upload_search_indicator":null,"census_search_date":"2025-12-26 21:33:00","snet_input_date":"2025-12-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-12-26 21:33:00","insp_carrier_name":"DELLET FERRER HOTSHOT LLC","insp_carrier_street":"1415 ELDRIDGE PARKWAY #225","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77077","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-29T10:36:11.000000Z","updated_at":"2026-01-06T10:30:08.000000Z","inspection_violations":[],"inspection_per_units":[{"id":17613898,"change_date":"2025-12-26 21:33:00","inspection_id":"86653183","insp_unit_id":"210801360","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"5","insp_unit_license":"K130111","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FT8W3DT9KEC96861","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-29T10:11:16.000000Z","updated_at":"2026-01-06T10:00:11.000000Z"},{"id":17613899,"change_date":"2025-12-26 21:33:00","inspection_id":"86653183","insp_unit_id":"210801361","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIG TEX","insp_unit_company":"02","insp_unit_license":"229C171","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"16V3F4821R6342371","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-29T10:11:16.000000Z","updated_at":"2026-01-06T10:00:11.000000Z"}]},{"id":10430852,"change_date":"2025-12-14 21:33:00","inspection_id":"86562503","dot_number":"3670419","report_state":"FL","report_number":"4391000992","insp_date":"2025-12-12 00:00:00","insp_start_time":"0943","insp_end_time":"0953","registration_date":null,"region":"ES","ci_status_code":"C","location":null,"location_desc":"MONTICELLO FL","county_code_state":"FL","county_code":"065","insp_level_id":"3","service_center":"SH","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":"U","pen_cen_match":"I","final_status_date":"2025-12-14 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"2","oos_total":"2","driver_viol_total":"2","driver_oos_total":"2","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2656279","transaction_code":"A","transaction_date":"2025-12-13 00:00:00","upload_date":"2025-12-14 00:00:00","upload_first_byte":"0","upload_dot_number":"03670419","upload_search_indicator":null,"census_search_date":"2025-12-14 21:33:00","snet_input_date":"2025-12-12 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-12-14 21:33:00","insp_carrier_name":"DELLET FERRER HOTSHOT LLC","insp_carrier_street":"1415 ELDRIDGE PARKWAY #225","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77077","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-12-17T10:30:31.000000Z","updated_at":"2025-12-25T10:30:12.000000Z","inspection_violations":[{"id":17488986,"change_date":"2025-12-14 21:33:00","inspection_id":"86562503","insp_violation_id":"270672945","seq_no":"1","part_no":"391","part_no_section":"11B2-S","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"54","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":"000900855-1","created_at":"2025-12-17T10:30:47.000000Z","updated_at":"2025-12-25T10:30:21.000000Z","normalized_code":"39111B2S"},{"id":17488987,"change_date":"2025-12-14 21:33:00","inspection_id":"86562503","insp_violation_id":"270672946","seq_no":"2","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":"000900855-2","created_at":"2025-12-17T10:30:47.000000Z","updated_at":"2025-12-25T10:30:21.000000Z","normalized_code":"3958A1HOSP"}],"inspection_per_units":[{"id":17446939,"change_date":"2025-12-14 21:33:00","inspection_id":"86562503","insp_unit_id":"210597549","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"RJF8556","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FT8W3DT9HEC42839","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-17T10:00:36.000000Z","updated_at":"2025-12-25T10:00:15.000000Z"},{"id":17446940,"change_date":"2025-12-14 21:33:00","inspection_id":"86562503","insp_unit_id":"210597550","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"LAMAR","insp_unit_company":null,"insp_unit_license":"034899M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5RVFS4028MP102226","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-12-17T10:00:36.000000Z","updated_at":"2025-12-25T10:00:15.000000Z"}]},{"id":10108460,"change_date":"2025-11-03 21:39:00","inspection_id":"86224406","dot_number":"3670419","report_state":"TX","report_number":"7A2B9DGX2Y","insp_date":"2025-10-30 00:00:00","insp_start_time":"1115","insp_end_time":"1142","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"200 E SAM HOUSTON PK","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-11-03 21:39: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":"9744555","transaction_code":"A","transaction_date":"2025-11-03 00:00:00","upload_date":"2025-11-03 00:00:00","upload_first_byte":"0","upload_dot_number":"03670419","upload_search_indicator":"M","census_search_date":"2025-11-03 21:39:00","snet_input_date":"2025-10-30 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-11-03 21:39:00","insp_carrier_name":"DELLET FERRER HOTSHOT LLC","insp_carrier_street":"1415 ELDRIDGE PARKWAY #225","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77077","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1026689","created_at":"2025-11-06T10:30:44.000000Z","updated_at":"2025-11-07T10:30:54.000000Z","inspection_violations":[{"id":16752455,"change_date":"2025-11-03 21:39:00","inspection_id":"86224406","insp_violation_id":"269697122","seq_no":"1","part_no":"390","part_no_section":"21(a)","insp_viol_unit":"2","insp_unit_id":"209809618","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-11-07T10:31:03.000000Z","updated_at":"2025-11-07T10:31:03.000000Z","normalized_code":"39021A"}],"inspection_per_units":[{"id":16810571,"change_date":"2025-11-03 21:39:00","inspection_id":"86224406","insp_unit_id":"209809617","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":"06","insp_unit_license":"RFLG13","insp_unit_license_state":"FL","insp_unit_vehicle_id_number":"3C63RRGL2EG153867","insp_unit_decal":"Y","insp_unit_decal_number":"35654692","created_at":"2025-11-06T10:00:39.000000Z","updated_at":"2025-11-07T10:01:11.000000Z"},{"id":16810572,"change_date":"2025-11-03 21:39:00","inspection_id":"86224406","insp_unit_id":"209809618","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":"06","insp_unit_license":"664947T","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"7WL3H4023ST000598","insp_unit_decal":"Y","insp_unit_decal_number":"35654693","created_at":"2025-11-06T10:00:39.000000Z","updated_at":"2025-11-07T10:01:11.000000Z"}]},{"id":9914992,"change_date":"2025-10-11 21:33:00","inspection_id":"86020071","dot_number":"3670419","report_state":"UT","report_number":"25FT001451","insp_date":"2025-10-08 00:00:00","insp_start_time":"1007","insp_end_time":"1125","registration_date":null,"region":"MD","ci_status_code":"C","location":null,"location_desc":"MONTICELLO UT","county_code_state":"UT","county_code":"037","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-10-11 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"24000","viol_total":"5","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":"2395502","transaction_code":"A","transaction_date":"2025-10-10 00:00:00","upload_date":"2025-10-11 00:00:00","upload_first_byte":"0","upload_dot_number":"03670419","upload_search_indicator":null,"census_search_date":"2025-10-11 21:33:00","snet_input_date":"2025-10-08 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-10-11 21:33:00","insp_carrier_name":"DELLET FERRER HOTSHOT LLC","insp_carrier_street":"1415 ELDRIDGE PARKWAY #225","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77077","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-14T10:01:31.000000Z","updated_at":"2025-10-15T10:00:06.000000Z","inspection_violations":[{"id":16360908,"change_date":"2025-10-11 21:33:00","inspection_id":"86020071","insp_violation_id":"269241875","seq_no":"1","part_no":"393","part_no_section":"128B-CLWV","insp_viol_unit":"2","insp_unit_id":"209416992","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-10-14T10:17:29.000000Z","updated_at":"2025-10-15T10:15:11.000000Z","normalized_code":"393128BCLWV"},{"id":16360909,"change_date":"2025-10-11 21:33:00","inspection_id":"86020071","insp_violation_id":"269241876","seq_no":"2","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"209416991","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-14T10:17:29.000000Z","updated_at":"2025-10-15T10:15:11.000000Z","normalized_code":"39395F"},{"id":16360910,"change_date":"2025-10-11 21:33:00","inspection_id":"86020071","insp_violation_id":"269241877","seq_no":"3","part_no":"395","part_no_section":"24","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-10-14T10:17:29.000000Z","updated_at":"2025-10-15T10:15:11.000000Z","normalized_code":"39524"},{"id":16360911,"change_date":"2025-10-11 21:33:00","inspection_id":"86020071","insp_violation_id":"269241878","seq_no":"4","part_no":"395","part_no_section":"24","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-10-14T10:17:29.000000Z","updated_at":"2025-10-15T10:15:11.000000Z","normalized_code":"39524"},{"id":16360912,"change_date":"2025-10-11 21:33:00","inspection_id":"86020071","insp_violation_id":"269241879","seq_no":"5","part_no":"393","part_no_section":"11A1-LLPL","insp_viol_unit":"1","insp_unit_id":"209416991","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-14T10:17:29.000000Z","updated_at":"2025-10-15T10:15:11.000000Z","normalized_code":"39311A1LLPL"}],"inspection_per_units":[{"id":16454616,"change_date":"2025-10-11 21:33:00","inspection_id":"86020071","insp_unit_id":"209416991","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"3","insp_unit_license":"XCG1827","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FD8W3HT6REF87978","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-14T09:46:56.000000Z","updated_at":"2025-10-15T09:45:09.000000Z"},{"id":16454617,"change_date":"2025-10-11 21:33:00","inspection_id":"86020071","insp_unit_id":"209416992","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GOOD MFG.","insp_unit_company":"3","insp_unit_license":"149281N","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"7TTGF4029RT000789","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-14T09:46:56.000000Z","updated_at":"2025-10-15T09:45:09.000000Z"}]},{"id":9820858,"change_date":"2025-09-30 21:40:00","inspection_id":"85921199","dot_number":"3670419","report_state":"CA","report_number":"UDFU004400","insp_date":"2025-09-30 00:00:00","insp_start_time":"1147","insp_end_time":"1210","registration_date":null,"region":"PT","ci_status_code":"C","location":"850","location_desc":"HORNBROOK AG STATION","county_code_state":"CA","county_code":"093","insp_level_id":"1","service_center":"WE","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":"2025-09-30 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"16000096","transaction_code":"A","transaction_date":"2025-09-30 00:00:00","upload_date":"2025-09-30 00:00:00","upload_first_byte":"0","upload_dot_number":"03670419","upload_search_indicator":null,"census_search_date":"2025-09-30 21:40:00","snet_input_date":"2025-09-30 00:00:00","source_office":"4CAS001","mcmis_add_date":"2025-09-30 21:40:00","insp_carrier_name":"DELLET FERRER HOTSHOT LLC","insp_carrier_street":"1415 ELDRIDGE PARKWAY #225","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77077","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-03T10:01:56.000000Z","updated_at":"2025-10-04T10:01:22.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16280670,"change_date":"2025-09-30 21:40:00","inspection_id":"85921199","insp_unit_id":"209229235","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"RJF8556","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FT8W3DT9HEC42839","insp_unit_decal":"Y","insp_unit_decal_number":"35327806","created_at":"2025-10-03T09:47:29.000000Z","updated_at":"2025-10-04T09:46:49.000000Z"},{"id":16280671,"change_date":"2025-09-30 21:40:00","inspection_id":"85921199","insp_unit_id":"209229236","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"034899M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5RVFS4028MP102226","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-03T09:47:29.000000Z","updated_at":"2025-10-04T09:46:49.000000Z"}]},{"id":9786031,"change_date":"2025-09-26 21:39:00","inspection_id":"85884610","dot_number":"3670419","report_state":"CO","report_number":"1702110644","insp_date":"2025-09-24 00:00:00","insp_start_time":"1547","insp_end_time":"1630","registration_date":null,"region":"MD","ci_status_code":"C","location":"FCPESB","location_desc":"FORT COLLINS CO","county_code_state":"CO","county_code":"069","insp_level_id":"1","service_center":"WE","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-09-26 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"24000","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":"2329640","transaction_code":"A","transaction_date":"2025-09-25 00:00:00","upload_date":"2025-09-26 00:00:00","upload_first_byte":"0","upload_dot_number":"03670419","upload_search_indicator":null,"census_search_date":"2025-09-26 21:39:00","snet_input_date":"2025-09-24 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-09-26 21:39:00","insp_carrier_name":"DELLET FERRER HOTSHOT LLC","insp_carrier_street":"1415 ELDRIDGE PARKWAY #225","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77077","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-30T10:00:56.000000Z","updated_at":"2025-09-30T10:00:56.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16215536,"change_date":"2025-09-26 21:39:00","inspection_id":"85884610","insp_unit_id":"209157850","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"3","insp_unit_license":"XCG1827","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FD8W3HT6REF87978","insp_unit_decal":"Y","insp_unit_decal_number":"35517979","created_at":"2025-09-29T09:47:03.000000Z","updated_at":"2025-09-30T09:45:12.000000Z"},{"id":16215537,"change_date":"2025-09-26 21:39:00","inspection_id":"85884610","insp_unit_id":"209157851","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GOOD MFG.","insp_unit_company":"3","insp_unit_license":"149281N","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"7TTGF4029RT000789","insp_unit_decal":"Y","insp_unit_decal_number":"35517980","created_at":"2025-09-29T09:47:03.000000Z","updated_at":"2025-09-30T09:45:12.000000Z"}]},{"id":9626385,"change_date":"2025-09-09 21:39:00","inspection_id":"85717209","dot_number":"3670419","report_state":"GA","report_number":"1317000917","insp_date":"2025-09-02 00:00:00","insp_start_time":"1450","insp_end_time":"1530","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"VALDOSTA GA","county_code_state":"GA","county_code":"185","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"N\/A","shipping_paper_number":"N\/A","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":"Y","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-09-09 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"45400","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":"2237612","transaction_code":"A","transaction_date":"2025-09-08 00:00:00","upload_date":"2025-09-09 00:00:00","upload_first_byte":"0","upload_dot_number":"03670419","upload_search_indicator":null,"census_search_date":"2025-09-09 21:39:00","snet_input_date":"2025-09-02 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-09-09 21:39:00","insp_carrier_name":"DELLET FERRER HOTSHOT LLC","insp_carrier_street":"1415 ELDRIDGE PARKWAY #225","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77077","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-09-11T10:46:52.000000Z","updated_at":"2025-09-13T10:46:12.000000Z","inspection_violations":[{"id":15744268,"change_date":"2025-09-09 21:39:00","inspection_id":"85717209","insp_violation_id":"268538043","seq_no":"1","part_no":"390","part_no_section":"21TB2-DOT","insp_viol_unit":"1","insp_unit_id":"208815726","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-12T10:50:59.000000Z","updated_at":"2025-09-13T10:48:16.000000Z","normalized_code":"39021TB2DOT"}],"inspection_per_units":[{"id":15900481,"change_date":"2025-09-09 21:39:00","inspection_id":"85717209","insp_unit_id":"208815726","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"UNIT05","insp_unit_license":"K130111","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FT8W3DT9KEC96861","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-12T10:47:39.000000Z","updated_at":"2025-09-13T09:58:52.000000Z"},{"id":15900482,"change_date":"2025-09-09 21:39:00","inspection_id":"85717209","insp_unit_id":"208815727","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIG TEX","insp_unit_company":"UNIT2","insp_unit_license":"229C171","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"16V3F4821R6342371","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-12T10:47:39.000000Z","updated_at":"2025-09-13T09:58:52.000000Z"}]},{"id":9373815,"change_date":"2025-08-10 21:33:00","inspection_id":"85451956","dot_number":"3670419","report_state":"NM","report_number":"0309P63RWP","insp_date":"2025-08-07 00:00:00","insp_start_time":"2128","insp_end_time":"2158","registration_date":null,"region":"MT","ci_status_code":"C","location":null,"location_desc":"GALLUP PORT OF ENTRY","county_code_state":"NM","county_code":"031","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"ION SOLAR","shipping_paper_number":"3148114088","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-08-10 21:33: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":"2208434","transaction_code":"A","transaction_date":"2025-08-08 00:00:00","upload_date":"2025-08-09 00:00:00","upload_first_byte":"0","upload_dot_number":"03670419","upload_search_indicator":null,"census_search_date":"2025-08-10 21:33:00","snet_input_date":"2025-08-09 00:00:00","source_office":"2NMS001","mcmis_add_date":"2025-08-10 21:33:00","insp_carrier_name":"DELLET FERRER HOTSHOT LLC","insp_carrier_street":"1415 ELDRIDGE PARKWAY #225","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77077","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-14T10:42:16.000000Z","updated_at":"2025-08-14T10:42:16.000000Z","inspection_violations":[],"inspection_per_units":[{"id":15444033,"change_date":"2025-08-10 21:33:00","inspection_id":"85451956","insp_unit_id":"208322791","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"UNIT05","insp_unit_license":"K130111","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FT8W3DT9KEC96861","insp_unit_decal":"Y","insp_unit_decal_number":"35445165","created_at":"2025-08-13T09:45:27.000000Z","updated_at":"2025-08-14T09:45:24.000000Z"},{"id":15444034,"change_date":"2025-08-10 21:33:00","inspection_id":"85451956","insp_unit_id":"208322792","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIGT","insp_unit_company":"UNIT2","insp_unit_license":"229C171","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"16V3F4821R6342371","insp_unit_decal":"Y","insp_unit_decal_number":"35445166","created_at":"2025-08-13T09:45:27.000000Z","updated_at":"2025-08-14T09:45:24.000000Z"}]},{"id":9277366,"change_date":"2025-07-29 21:39:00","inspection_id":"85350517","dot_number":"3670419","report_state":"IA","report_number":"000P14STN4","insp_date":"2025-07-27 00:00:00","insp_start_time":"0723","insp_end_time":"0800","registration_date":null,"region":"CT","ci_status_code":"C","location":"02","location_desc":"02 - I80 EB MM 115 VAN METER","county_code_state":"IA","county_code":"049","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"CRYSTAL SANCHEZ","shipping_paper_number":"701013781","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-29 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"24000","viol_total":"6","oos_total":"1","driver_viol_total":"6","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1368731","transaction_code":"A","transaction_date":"2025-07-29 00:00:00","upload_date":"2025-07-29 00:00:00","upload_first_byte":"0","upload_dot_number":"03670419","upload_search_indicator":"M","census_search_date":"2025-07-29 21:39:00","snet_input_date":"2025-07-27 00:00:00","source_office":"3IAS001","mcmis_add_date":"2025-07-29 21:39:00","insp_carrier_name":"DELLET FERRER HOTSHOT LLC","insp_carrier_street":"1415 ELDRIDGE PARKWAY #225","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77077","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-01T10:42:07.000000Z","updated_at":"2025-08-04T10:00:44.000000Z","inspection_violations":[{"id":15037177,"change_date":"2025-07-29 21:39:00","inspection_id":"85350517","insp_violation_id":"267721989","seq_no":"1","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":"1HOF25072707445","created_at":"2025-08-01T10:44:23.000000Z","updated_at":"2025-08-02T10:42:50.000000Z","normalized_code":"38323A2"},{"id":15037178,"change_date":"2025-07-29 21:39:00","inspection_id":"85350517","insp_violation_id":"267721990","seq_no":"2","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-08-01T10:44:23.000000Z","updated_at":"2025-08-02T10:42:50.000000Z","normalized_code":"3922SLLIFTA"},{"id":15037179,"change_date":"2025-07-29 21:39:00","inspection_id":"85350517","insp_violation_id":"267721991","seq_no":"3","part_no":"395","part_no_section":"30B1","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-08-01T10:44:23.000000Z","updated_at":"2025-08-02T10:42:50.000000Z","normalized_code":"39530B1"},{"id":15037180,"change_date":"2025-07-29 21:39:00","inspection_id":"85350517","insp_violation_id":"267721992","seq_no":"4","part_no":"395","part_no_section":"30B1","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-08-01T10:44:23.000000Z","updated_at":"2025-08-02T10:42:50.000000Z","normalized_code":"39530B1"},{"id":15037181,"change_date":"2025-07-29 21:39:00","inspection_id":"85350517","insp_violation_id":"267721993","seq_no":"5","part_no":"395","part_no_section":"30B1","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-08-01T10:44:23.000000Z","updated_at":"2025-08-02T10:42:50.000000Z","normalized_code":"39530B1"},{"id":15037182,"change_date":"2025-07-29 21:39:00","inspection_id":"85350517","insp_violation_id":"267721994","seq_no":"6","part_no":"395","part_no_section":"30B1","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-08-01T10:44:23.000000Z","updated_at":"2025-08-02T10:42:50.000000Z","normalized_code":"39530B1"}],"inspection_per_units":[{"id":15272288,"change_date":"2025-07-29 21:39:00","inspection_id":"85350517","insp_unit_id":"208137637","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"1","insp_unit_license":"TEMP","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FD8W3HT6REF87978","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-01T09:45:47.000000Z","updated_at":"2025-08-02T09:45:55.000000Z"},{"id":15272289,"change_date":"2025-07-29 21:39:00","inspection_id":"85350517","insp_unit_id":"208137638","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GOODGUYS","insp_unit_company":"1","insp_unit_license":"149281N","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"7TTGF4029RT000789","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-01T09:45:47.000000Z","updated_at":"2025-08-02T09:45:55.000000Z"}]},{"id":9024294,"change_date":"2025-06-30 21:38:00","inspection_id":"85084203","dot_number":"3670419","report_state":"FL","report_number":"1900003406","insp_date":"2025-06-26 00:00:00","insp_start_time":"1424","insp_end_time":"1451","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"LIVE OAK FL","county_code_state":"FL","county_code":"121","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"HENNESSEY PERFORMANCE","shipping_paper_number":"20213763","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-06-30 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"39900","viol_total":"5","oos_total":"4","driver_viol_total":"0","driver_oos_total":"4","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1930332","transaction_code":"A","transaction_date":"2025-06-29 00:00:00","upload_date":"2025-06-30 00:00:00","upload_first_byte":"0","upload_dot_number":"03670419","upload_search_indicator":null,"census_search_date":"2025-06-30 21:38:00","snet_input_date":"2025-06-26 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-06-30 21:38:00","insp_carrier_name":"DELLET FERRER HOTSHOT LLC","insp_carrier_street":"1415 ELDRIDGE PARKWAY #225","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77077","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-03T10:01:30.000000Z","updated_at":"2025-07-04T10:00:05.000000Z","inspection_violations":[{"id":14506858,"change_date":"2025-06-30 21:38:00","inspection_id":"85084203","insp_violation_id":"267115679","seq_no":"1","part_no":"395","part_no_section":"8E-HOSPCDOOS","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-07-03T10:15:31.000000Z","updated_at":"2025-07-04T10:16:37.000000Z","normalized_code":"3958EHOSPCDOOS"},{"id":14506859,"change_date":"2025-06-30 21:38:00","inspection_id":"85084203","insp_violation_id":"267115680","seq_no":"2","part_no":"395","part_no_section":"8E-HOSPCDOOS","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-03T10:15:31.000000Z","updated_at":"2025-07-04T10:16:37.000000Z","normalized_code":"3958EHOSPCDOOS"},{"id":14506860,"change_date":"2025-06-30 21:38:00","inspection_id":"85084203","insp_violation_id":"267115681","seq_no":"3","part_no":"395","part_no_section":"3A2-HOSPDIT","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"4","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-03T10:15:31.000000Z","updated_at":"2025-07-04T10:16:37.000000Z","normalized_code":"3953A2HOSPDIT"},{"id":14506861,"change_date":"2025-06-30 21:38:00","inspection_id":"85084203","insp_violation_id":"267115682","seq_no":"4","part_no":"395","part_no_section":"3A1-HOSPD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"4","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-03T10:15:31.000000Z","updated_at":"2025-07-04T10:16:37.000000Z","normalized_code":"3953A1HOSPD"},{"id":14506862,"change_date":"2025-06-30 21:38:00","inspection_id":"85084203","insp_violation_id":"267115683","seq_no":"5","part_no":"395","part_no_section":"8K2-HOSP","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-03T10:15:31.000000Z","updated_at":"2025-07-04T10:16:37.000000Z","normalized_code":"3958K2HOSP"}],"inspection_per_units":[{"id":14800936,"change_date":"2025-06-30 21:38:00","inspection_id":"85084203","insp_unit_id":"207627183","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"COURIER","insp_unit_company":"05","insp_unit_license":"K130111","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FT8W3DT9KEC96861","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-03T09:45:26.000000Z","updated_at":"2025-07-04T09:45:04.000000Z"},{"id":14800937,"change_date":"2025-06-30 21:38:00","inspection_id":"85084203","insp_unit_id":"207627184","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIG TEX","insp_unit_company":null,"insp_unit_license":"229C171","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"16V3F4821R6342371","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-03T09:45:26.000000Z","updated_at":"2025-07-04T09:45:04.000000Z"}]},{"id":8963690,"change_date":"2025-07-10 21:39:00","inspection_id":"85020561","dot_number":"3670419","report_state":"WY","report_number":"TTMB000057","insp_date":"2025-06-18 00:00:00","insp_start_time":"2116","insp_end_time":"2148","registration_date":"2025-07-10 00:00:00","region":"MT","ci_status_code":"C","location":"23","location_desc":"ROADSIDE","county_code_state":"WY","county_code":"001","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"IPS (BEAUMONT)","shipping_paper_number":"000446561","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":"2025-06-23 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"7","oos_total":"1","driver_viol_total":"7","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"462950","transaction_code":"C","transaction_date":"2025-06-25 00:00:00","upload_date":"2025-07-10 00:00:00","upload_first_byte":"0","upload_dot_number":"03670419","upload_search_indicator":"M","census_search_date":"2025-06-23 21:41:00","snet_input_date":"2025-06-18 00:00:00","source_office":"4WYS001","mcmis_add_date":"2025-06-23 21:41:00","insp_carrier_name":"DELLET FERRER HOTSHOT LLC","insp_carrier_street":"1415 ELDRIDGE PARKWAY #225","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77077","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-28T10:00:37.000000Z","updated_at":"2025-07-14T10:46:43.000000Z","inspection_violations":[{"id":14681878,"change_date":"2025-07-10 21:39:00","inspection_id":"85020561","insp_violation_id":"267326864","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":"WHP379904AB","created_at":"2025-07-13T10:49:31.000000Z","updated_at":"2025-07-14T10:47:33.000000Z","normalized_code":"3958A1HOSP"},{"id":14681879,"change_date":"2025-07-10 21:39:00","inspection_id":"85020561","insp_violation_id":"267326865","seq_no":"2","part_no":"395","part_no_section":"34A1-ELDDFN","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-07-13T10:49:31.000000Z","updated_at":"2025-07-14T10:47:33.000000Z","normalized_code":"39534A1ELDDFN"},{"id":14681880,"change_date":"2025-07-10 21:39:00","inspection_id":"85020561","insp_violation_id":"267326866","seq_no":"3","part_no":"395","part_no_section":"8D3-HOSF","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-07-13T10:49:31.000000Z","updated_at":"2025-07-14T10:47:33.000000Z","normalized_code":"3958D3HOSF"},{"id":14681881,"change_date":"2025-07-10 21:39:00","inspection_id":"85020561","insp_violation_id":"267326867","seq_no":"4","part_no":"395","part_no_section":"8D11-HOSF","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-07-13T10:49:31.000000Z","updated_at":"2025-07-14T10:47:33.000000Z","normalized_code":"3958D11HOSF"},{"id":14681882,"change_date":"2025-07-10 21:39:00","inspection_id":"85020561","insp_violation_id":"267326868","seq_no":"5","part_no":"392","part_no_section":"2-SLLML","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-07-13T10:49:31.000000Z","updated_at":"2025-07-14T10:47:33.000000Z","normalized_code":"3922SLLML"},{"id":14681883,"change_date":"2025-07-10 21:39:00","inspection_id":"85020561","insp_violation_id":"267326869","seq_no":"6","part_no":"391","part_no_section":"11B2-Q","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"54","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-13T10:49:31.000000Z","updated_at":"2025-07-14T10:47:33.000000Z","normalized_code":"39111B2Q"},{"id":14681884,"change_date":"2025-07-10 21:39:00","inspection_id":"85020561","insp_violation_id":"267326870","seq_no":"7","part_no":"392","part_no_section":"2-SLLSIV","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-13T10:49:31.000000Z","updated_at":"2025-07-14T10:47:33.000000Z","normalized_code":"3922SLLSIV"}],"inspection_per_units":[{"id":14954810,"change_date":"2025-07-10 21:39:00","inspection_id":"85020561","insp_unit_id":"207804923","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":null,"insp_unit_license":"PEN840","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3C63RRGL8RG346708","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-13T09:46:52.000000Z","updated_at":"2025-07-14T09:45:15.000000Z"},{"id":14954811,"change_date":"2025-07-10 21:39:00","inspection_id":"85020561","insp_unit_id":"207804924","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNK","insp_unit_company":null,"insp_unit_license":"781610M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3NGGF402XR1000162","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-13T09:46:52.000000Z","updated_at":"2025-07-14T09:45:15.000000Z"}]},{"id":8914346,"change_date":"2025-06-17 21:40:00","inspection_id":"84968032","dot_number":"3670419","report_state":"IN","report_number":"8283009181","insp_date":"2025-06-13 00:00:00","insp_start_time":"1335","insp_end_time":"1454","registration_date":null,"region":"ED","ci_status_code":"C","location":"5370E","location_desc":"TERRE HAUTE IN","county_code_state":"IN","county_code":"167","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"EXPRESSWAY LOGISTIC","shipping_paper_number":"L7677","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-06-17 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"20000","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":"1870791","transaction_code":"A","transaction_date":"2025-06-16 00:00:00","upload_date":"2025-06-17 00:00:00","upload_first_byte":"0","upload_dot_number":"03670419","upload_search_indicator":null,"census_search_date":"2025-06-17 21:40:00","snet_input_date":"2025-06-13 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-06-17 21:40:00","insp_carrier_name":"DELLET FERRER HOTSHOT LLC","insp_carrier_street":"1415 ELDRIDGE PARKWAY #225","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77077","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-20T10:00:46.000000Z","updated_at":"2025-06-22T10:00:06.000000Z","inspection_violations":[{"id":14295788,"change_date":"2025-06-17 21:40:00","inspection_id":"84968032","insp_violation_id":"266876529","seq_no":"1","part_no":"390","part_no_section":"21TB1-MC","insp_viol_unit":"1","insp_unit_id":"207416015","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-20T10:16:19.000000Z","updated_at":"2025-06-21T10:16:40.000000Z","normalized_code":"39021TB1MC"},{"id":14295789,"change_date":"2025-06-17 21:40:00","inspection_id":"84968032","insp_violation_id":"266876530","seq_no":"2","part_no":"392","part_no_section":"2-SLLED","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-20T10:16:19.000000Z","updated_at":"2025-06-21T10:16:40.000000Z","normalized_code":"3922SLLED"},{"id":14295790,"change_date":"2025-06-17 21:40:00","inspection_id":"84968032","insp_violation_id":"266876531","seq_no":"3","part_no":"393","part_no_section":"95A4-EEUS","insp_viol_unit":"1","insp_unit_id":"207416015","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-20T10:16:19.000000Z","updated_at":"2025-06-21T10:16:40.000000Z","normalized_code":"39395A4EEUS"}],"inspection_per_units":[{"id":14606572,"change_date":"2025-06-17 21:40:00","inspection_id":"84968032","insp_unit_id":"207416015","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"WMJ7639","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FT7W2BT4LEC87544","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-20T09:45:59.000000Z","updated_at":"2025-06-22T09:45:07.000000Z"},{"id":14606573,"change_date":"2025-06-17 21:40:00","inspection_id":"84968032","insp_unit_id":"207416016","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GOOD MFG.","insp_unit_company":null,"insp_unit_license":"149281N","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"7TTGF4029RT000789","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-20T09:45:59.000000Z","updated_at":"2025-06-22T09:45:07.000000Z"}]},{"id":8723005,"change_date":"2025-06-03 21:40:00","inspection_id":"84765227","dot_number":"3670419","report_state":"VA","report_number":"7155000689","insp_date":"2025-05-22 00:00:00","insp_start_time":"0624","insp_end_time":"0643","registration_date":"2025-06-03 00:00:00","region":"ED","ci_status_code":"C","location":null,"location_desc":"MIDDLETOWN VA","county_code_state":"VA","county_code":"630","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":"TDR PIPE","shipping_paper_number":"5033","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":"2025-05-23 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"6","oos_total":"5","driver_viol_total":"0","driver_oos_total":"2","vehicle_viol_total":"0","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1772953","transaction_code":"C","transaction_date":"2025-05-23 00:00:00","upload_date":"2025-06-03 00:00:00","upload_first_byte":"0","upload_dot_number":"03670419","upload_search_indicator":null,"census_search_date":"2025-05-23 21:39:00","snet_input_date":"2025-05-22 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-05-23 21:39:00","insp_carrier_name":"DELLET FERRER HOTSHOT LLC","insp_carrier_street":"1415 ELDRIDGE PARKWAY #225","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77077","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-26T10:04:18.000000Z","updated_at":"2025-06-07T10:00:10.000000Z","inspection_violations":[{"id":14074916,"change_date":"2025-06-03 21:40:00","inspection_id":"84765227","insp_violation_id":"266631324","seq_no":"1","part_no":"393","part_no_section":"100B-C","insp_viol_unit":"2","insp_unit_id":"207199075","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-06-06T10:16:26.000000Z","updated_at":"2025-06-07T10:16:46.000000Z","normalized_code":"393100BC"},{"id":14074917,"change_date":"2025-06-03 21:40:00","inspection_id":"84765227","insp_violation_id":"266631325","seq_no":"2","part_no":"392","part_no_section":"9A2-C","insp_viol_unit":"1","insp_unit_id":"207199074","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-06-06T10:16:26.000000Z","updated_at":"2025-06-07T10:16:46.000000Z","normalized_code":"3929A2C"},{"id":14074918,"change_date":"2025-06-03 21:40:00","inspection_id":"84765227","insp_violation_id":"266631326","seq_no":"3","part_no":"393","part_no_section":"43D-B","insp_viol_unit":"2","insp_unit_id":"207199075","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-06-06T10:16:26.000000Z","updated_at":"2025-06-07T10:16:46.000000Z","normalized_code":"39343DB"},{"id":14074919,"change_date":"2025-06-03 21:40:00","inspection_id":"84765227","insp_violation_id":"266631327","seq_no":"4","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-06-06T10:16:26.000000Z","updated_at":"2025-06-07T10:16:46.000000Z","normalized_code":"3922SLLTCD"},{"id":14074920,"change_date":"2025-06-03 21:40:00","inspection_id":"84765227","insp_violation_id":"266631328","seq_no":"5","part_no":"395","part_no_section":"3A1-HOSPD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"4","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-06T10:16:26.000000Z","updated_at":"2025-06-07T10:16:46.000000Z","normalized_code":"3953A1HOSPD"},{"id":14074921,"change_date":"2025-06-03 21:40:00","inspection_id":"84765227","insp_violation_id":"266631329","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-06-06T10:16:26.000000Z","updated_at":"2025-06-07T10:16:46.000000Z","normalized_code":"3958EHOSPD"}],"inspection_per_units":[{"id":14402756,"change_date":"2025-06-03 21:40:00","inspection_id":"84765227","insp_unit_id":"207199074","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"RJF8556","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FT8W3DT9HEC42839","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-06T09:46:22.000000Z","updated_at":"2025-06-07T09:45:10.000000Z"},{"id":14402757,"change_date":"2025-06-03 21:40:00","inspection_id":"84765227","insp_unit_id":"207199075","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":null,"insp_unit_license":"034899M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5RVFS4028MP102226","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-06T09:46:22.000000Z","updated_at":"2025-06-07T09:45:10.000000Z"}]},{"id":8462434,"change_date":"2025-04-24 21:38:00","inspection_id":"84490752","dot_number":"3670419","report_state":"TX","report_number":"V251847019","insp_date":"2025-04-22 00:00:00","insp_start_time":"0850","insp_end_time":"0911","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"IH37 MP 131","county_code_state":"TX","county_code":"029","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"JG CUSTOMS","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":"Y","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-04-24 21:38: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":"9559451","transaction_code":"A","transaction_date":"2025-04-24 00:00:00","upload_date":"2025-04-24 00:00:00","upload_first_byte":"0","upload_dot_number":"03670419","upload_search_indicator":"M","census_search_date":"2025-04-24 21:38:00","snet_input_date":"2025-04-22 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-04-24 21:38:00","insp_carrier_name":"DELLET FERRER HOTSHOT LLC","insp_carrier_street":"1415 ELDRIDGE PARKWAY #225","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77077","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1026689","created_at":"2025-04-27T10:28:34.000000Z","updated_at":"2025-04-28T10:12:24.000000Z","inspection_violations":[],"inspection_per_units":[{"id":13748097,"change_date":"2025-04-24 21:38:00","inspection_id":"84490752","insp_unit_id":"206478318","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"05","insp_unit_license":"K130111","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FT8W3DT9KEC96861","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-27T10:18:00.000000Z","updated_at":"2025-04-28T10:00:09.000000Z"},{"id":13748098,"change_date":"2025-04-24 21:38:00","inspection_id":"84490752","insp_unit_id":"206478319","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIGT","insp_unit_company":null,"insp_unit_license":"229C171","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"16V3F4821R6342371","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-27T10:18:00.000000Z","updated_at":"2025-04-28T10:00:09.000000Z"}]},{"id":8241905,"change_date":"2025-03-28 21:41:00","inspection_id":"84258398","dot_number":"3670419","report_state":"WY","report_number":"TAJM000544","insp_date":"2025-03-27 00:00:00","insp_start_time":"1746","insp_end_time":"1850","registration_date":null,"region":"MT","ci_status_code":"C","location":"ML 25","location_desc":"216.5 I 25 S","county_code_state":"WY","county_code":"025","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"VERMEER MOUNTAIN WEST-BILLINGS 070","shipping_paper_number":"18046","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":"2025-03-28 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"7","oos_total":"1","driver_viol_total":"3","driver_oos_total":"1","vehicle_viol_total":"4","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"459058","transaction_code":"A","transaction_date":"2025-03-28 00:00:00","upload_date":"2025-03-28 00:00:00","upload_first_byte":"0","upload_dot_number":"03670419","upload_search_indicator":null,"census_search_date":"2025-03-28 21:41:00","snet_input_date":"2025-03-27 00:00:00","source_office":"4WYS001","mcmis_add_date":"2025-03-28 21:41:00","insp_carrier_name":"DELLET FERRER HOTSHOT LLC","insp_carrier_street":"1415 ELDRIDGE PARKWAY #225","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77077","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-31T10:32:57.000000Z","updated_at":"2025-04-01T10:14:25.000000Z","inspection_violations":[{"id":12939397,"change_date":"2025-03-28 21:41:00","inspection_id":"84258398","insp_violation_id":"265324189","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":null,"created_at":"2025-03-31T11:14:54.000000Z","updated_at":"2025-03-31T11:24:21.000000Z","normalized_code":"3958A1HOSP"},{"id":12939398,"change_date":"2025-03-28 21:41:00","inspection_id":"84258398","insp_violation_id":"265324190","seq_no":"2","part_no":"395","part_no_section":"34A1-ELDDFN","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-03-31T11:14:54.000000Z","updated_at":"2025-03-31T11:24:21.000000Z","normalized_code":"39534A1ELDDFN"},{"id":12939399,"change_date":"2025-03-28 21:41:00","inspection_id":"84258398","insp_violation_id":"265324191","seq_no":"3","part_no":"391","part_no_section":"41A-MCPC","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-31T11:14:54.000000Z","updated_at":"2025-03-31T11:24:21.000000Z","normalized_code":"39141AMCPC"},{"id":12939400,"change_date":"2025-03-28 21:41:00","inspection_id":"84258398","insp_violation_id":"265324192","seq_no":"4","part_no":"393","part_no_section":"60D","insp_viol_unit":"1","insp_unit_id":"206053661","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-31T11:14:54.000000Z","updated_at":"2025-03-31T11:24:21.000000Z","normalized_code":"39360D"},{"id":12939401,"change_date":"2025-03-28 21:41:00","inspection_id":"84258398","insp_violation_id":"265324193","seq_no":"5","part_no":"393","part_no_section":"104B-C","insp_viol_unit":"2","insp_unit_id":"206053662","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-31T11:14:54.000000Z","updated_at":"2025-03-31T11:24:21.000000Z","normalized_code":"393104BC"},{"id":12939402,"change_date":"2025-03-28 21:41:00","inspection_id":"84258398","insp_violation_id":"265324194","seq_no":"6","part_no":"393","part_no_section":"75C-TAOTD-LT2\/32","insp_viol_unit":"2","insp_unit_id":"206053662","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-31T11:14:54.000000Z","updated_at":"2025-03-31T11:24:21.000000Z","normalized_code":"39375CTAOTDLT2\/32"},{"id":12939403,"change_date":"2025-03-28 21:41:00","inspection_id":"84258398","insp_violation_id":"265324195","seq_no":"7","part_no":"393","part_no_section":"75C-TAOTD-LT2\/32","insp_viol_unit":"2","insp_unit_id":"206053662","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-31T11:14:54.000000Z","updated_at":"2025-03-31T11:24:21.000000Z","normalized_code":"39375CTAOTDLT2\/32"}],"inspection_per_units":[{"id":13334657,"change_date":"2025-03-28 21:41:00","inspection_id":"84258398","insp_unit_id":"206053661","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"8","insp_unit_license":"VWZ9364","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FT8W3DTXHEF31535","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-31T10:23:21.000000Z","updated_at":"2025-04-01T10:03:45.000000Z"},{"id":13334658,"change_date":"2025-03-28 21:41:00","inspection_id":"84258398","insp_unit_id":"206053662","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"AMEM","insp_unit_company":null,"insp_unit_license":"902616M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"17YGN38308B038581","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-31T10:23:21.000000Z","updated_at":"2025-04-01T10:03:45.000000Z"}]},{"id":7652565,"change_date":"2025-01-17 21:40:00","inspection_id":"83638938","dot_number":"3670419","report_state":"WY","report_number":"TAJM000497","insp_date":"2025-01-16 00:00:00","insp_start_time":"0929","insp_end_time":"1024","registration_date":null,"region":"MT","ci_status_code":"C","location":"ML 25","location_desc":"114.5 I 25 SOUTH","county_code_state":"WY","county_code":"031","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"ENTERPRISE VALLEY FARMS","shipping_paper_number":"29565","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":"2025-01-17 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"7","oos_total":"0","driver_viol_total":"7","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"455750","transaction_code":"A","transaction_date":"2025-01-17 00:00:00","upload_date":"2025-01-17 00:00:00","upload_first_byte":"0","upload_dot_number":"03670419","upload_search_indicator":null,"census_search_date":"2025-01-17 21:40:00","snet_input_date":"2025-01-16 00:00:00","source_office":"4WYS001","mcmis_add_date":"2025-01-17 21:40:00","insp_carrier_name":"DELLET FERRER HOTSHOT LLC","insp_carrier_street":"1415 ELDRIDGE PARKWAY #225","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77077","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:57:02.000000Z","updated_at":"2025-03-17T20:57:02.000000Z","inspection_violations":[{"id":11955457,"change_date":"2025-01-17 21:40:00","inspection_id":"83638938","insp_violation_id":"264060627","seq_no":"1","part_no":"392","part_no_section":"16AD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"309290AB\/100","created_at":"2025-03-17T22:04:14.000000Z","updated_at":"2025-03-17T22:04:14.000000Z","normalized_code":"39216AD"},{"id":11955458,"change_date":"2025-01-17 21:40:00","inspection_id":"83638938","insp_violation_id":"264060628","seq_no":"2","part_no":"395","part_no_section":"30B1-ELDDFR","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-17T22:04:14.000000Z","updated_at":"2025-03-17T22:04:14.000000Z","normalized_code":"39530B1ELDDFR"},{"id":11955459,"change_date":"2025-01-17 21:40:00","inspection_id":"83638938","insp_violation_id":"264060629","seq_no":"3","part_no":"395","part_no_section":"24C2III-ELDSDN","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-17T22:04:14.000000Z","updated_at":"2025-03-17T22:04:14.000000Z","normalized_code":"39524C2IIIELDSDN"},{"id":11955460,"change_date":"2025-01-17 21:40:00","inspection_id":"83638938","insp_violation_id":"264060630","seq_no":"4","part_no":"395","part_no_section":"8D9-HOSF","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-03-17T22:04:14.000000Z","updated_at":"2025-03-17T22:04:14.000000Z","normalized_code":"3958D9HOSF"},{"id":11955461,"change_date":"2025-01-17 21:40:00","inspection_id":"83638938","insp_violation_id":"264060631","seq_no":"5","part_no":"395","part_no_section":"8E1-HOSPVID","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-17T22:04:14.000000Z","updated_at":"2025-03-17T22:04:14.000000Z","normalized_code":"3958E1HOSPVID"},{"id":11955462,"change_date":"2025-01-17 21:40:00","inspection_id":"83638938","insp_violation_id":"264060632","seq_no":"6","part_no":"395","part_no_section":"8E1-HOSPVID","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-17T22:04:14.000000Z","updated_at":"2025-03-17T22:04:14.000000Z","normalized_code":"3958E1HOSPVID"},{"id":11955463,"change_date":"2025-01-17 21:40:00","inspection_id":"83638938","insp_violation_id":"264060633","seq_no":"7","part_no":"395","part_no_section":"8E1-HOSPVID","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-17T22:04:14.000000Z","updated_at":"2025-03-17T22:04:14.000000Z","normalized_code":"3958E1HOSPVID"}],"inspection_per_units":[{"id":12348044,"change_date":"2025-01-17 21:40:00","inspection_id":"83638938","insp_unit_id":"204897783","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":"9","insp_unit_license":"PEN840","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3C63RRGL8RG346708","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:51:16.000000Z","updated_at":"2025-03-17T23:51:16.000000Z"},{"id":12348045,"change_date":"2025-01-17 21:40:00","inspection_id":"83638938","insp_unit_id":"204897784","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRLR","insp_unit_company":null,"insp_unit_license":"788866M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3EVGF3627R1108880","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:51:16.000000Z","updated_at":"2025-03-17T23:51:16.000000Z"}]},{"id":7675023,"change_date":"2025-01-21 21:40:00","inspection_id":"83662639","dot_number":"3670419","report_state":"TX","report_number":"V251744114","insp_date":"2025-01-16 00:00:00","insp_start_time":"1425","insp_end_time":"1503","registration_date":null,"region":"CT","ci_status_code":"C","location":"2A403","location_desc":"IH10 WB WINNIE SCALE","county_code_state":"TX","county_code":"071","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"ICC","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-01-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"39900","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":"9479751","transaction_code":"A","transaction_date":"2025-01-21 00:00:00","upload_date":"2025-01-21 00:00:00","upload_first_byte":"0","upload_dot_number":"03670419","upload_search_indicator":"M","census_search_date":"2025-01-21 21:40:00","snet_input_date":"2025-01-16 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-01-21 21:40:00","insp_carrier_name":"DELLET FERRER HOTSHOT LLC","insp_carrier_street":"1415 ELDRIDGE PARKWAY #225","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77077","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1026689","created_at":"2025-03-17T20:57:29.000000Z","updated_at":"2025-03-17T20:57:29.000000Z","inspection_violations":[{"id":11993738,"change_date":"2025-01-21 21:40:00","inspection_id":"83662639","insp_violation_id":"264108799","seq_no":"1","part_no":"393","part_no_section":"75A1","insp_viol_unit":"2","insp_unit_id":"204940899","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-03-17T22:04:26.000000Z","updated_at":"2025-03-17T22:04:26.000000Z","normalized_code":"39375A1"},{"id":11993739,"change_date":"2025-01-21 21:40:00","inspection_id":"83662639","insp_violation_id":"264108800","seq_no":"2","part_no":"396","part_no_section":"5B","insp_viol_unit":"1","insp_unit_id":"204940898","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:26.000000Z","updated_at":"2025-03-17T22:04:26.000000Z","normalized_code":"3965B"}],"inspection_per_units":[{"id":12384756,"change_date":"2025-01-21 21:40:00","inspection_id":"83662639","insp_unit_id":"204940898","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"05","insp_unit_license":"K130111","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FT8W3DT9KEC96861","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:51:39.000000Z","updated_at":"2025-03-17T23:51:39.000000Z"},{"id":12384757,"change_date":"2025-01-21 21:40:00","inspection_id":"83662639","insp_unit_id":"204940899","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIGT","insp_unit_company":"TL01","insp_unit_license":"232C661","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"16VGX3523K6008751","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:51:39.000000Z","updated_at":"2025-03-17T23:51:39.000000Z"}]},{"id":7144628,"change_date":"2025-09-12 21:48:00","inspection_id":"83104175","dot_number":"3670419","report_state":"LA","report_number":"LALD010430","insp_date":"2024-11-02 00:00:00","insp_start_time":"0030","insp_end_time":"0046","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"LA","county_code_state":"LA","county_code":"127","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"R","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":"Y","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-11-07 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"39000","viol_total":"2","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2262152","transaction_code":"C","transaction_date":"2025-09-12 00:00:00","upload_date":"2025-09-12 00:00:00","upload_first_byte":"0","upload_dot_number":"03670419","upload_search_indicator":null,"census_search_date":"2024-11-07 21:40:00","snet_input_date":"2024-11-07 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-11-07 21:40:00","insp_carrier_name":"DELLET FERRER HOTSHOT LLC","insp_carrier_street":"1415 ELDRIDGE PARKWAY #225","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77077","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:45:05.000000Z","updated_at":"2025-09-16T10:47:37.000000Z","inspection_violations":[{"id":15827427,"change_date":"2025-09-12 21:48:00","inspection_id":"83104175","insp_violation_id":"268639501","seq_no":"2","part_no":"392","part_no_section":"22B","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-14T11:57:26.000000Z","updated_at":"2025-09-16T10:49:45.000000Z","normalized_code":"39222B"},{"id":15827428,"change_date":"2025-09-12 21:48:00","inspection_id":"83104175","insp_violation_id":"268639502","seq_no":"1","part_no":"392","part_no_section":"22A","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-14T11:57:26.000000Z","updated_at":"2025-09-16T10:49:45.000000Z","normalized_code":"39222A"}],"inspection_per_units":[{"id":15976872,"change_date":"2025-09-12 21:48:00","inspection_id":"83104175","insp_unit_id":"208901738","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":null,"insp_unit_company":"05","insp_unit_license":"K130111","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FT8W3DT9KEC96861","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-15T09:53:47.000000Z","updated_at":"2025-09-16T09:54:58.000000Z"},{"id":15976873,"change_date":"2025-09-12 21:48:00","inspection_id":"83104175","insp_unit_id":"208901739","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIG TEX","insp_unit_company":"05T","insp_unit_license":"232C661","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"16VGX3523K6008751","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-15T09:53:47.000000Z","updated_at":"2025-09-16T09:54:58.000000Z"}]},{"id":7106597,"change_date":"2024-11-02 21:33:00","inspection_id":"83063957","dot_number":"3670419","report_state":"CO","report_number":"0294870114","insp_date":"2024-10-31 00:00:00","insp_start_time":"0923","insp_end_time":"0950","registration_date":null,"region":"MD","ci_status_code":"C","location":null,"location_desc":"LAMAR CO","county_code_state":"CO","county_code":"099","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"N\/A","shipping_paper_number":"N\/A","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-11-02 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"1","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":"1013624","transaction_code":"A","transaction_date":"2024-11-02 00:00:00","upload_date":"2024-11-02 00:00:00","upload_first_byte":"0","upload_dot_number":"03670419","upload_search_indicator":null,"census_search_date":"2024-11-02 21:33:00","snet_input_date":"2024-10-31 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-11-02 21:33:00","insp_carrier_name":"DELLET FERRER HOTSHOT LLC","insp_carrier_street":"1415 ELDRIDGE PARKWAY #225","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77077","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:44:15.000000Z","updated_at":"2025-03-17T20:44:15.000000Z","inspection_violations":[{"id":11097348,"change_date":"2024-11-02 21:33:00","inspection_id":"83063957","insp_violation_id":"262693678","seq_no":"1","part_no":"396","part_no_section":"3A1-HCM","insp_viol_unit":"2","insp_unit_id":"203706641","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:59:49.000000Z","updated_at":"2025-03-17T21:59:49.000000Z","normalized_code":"3963A1HCM"}],"inspection_per_units":[{"id":11461753,"change_date":"2024-11-02 21:33:00","inspection_id":"83063957","insp_unit_id":"203706640","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODGE","insp_unit_company":null,"insp_unit_license":"VTV7218","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3C63RRGL1PG521314","insp_unit_decal":"Y","insp_unit_decal_number":"34662062","created_at":"2025-03-17T23:41:44.000000Z","updated_at":"2025-03-17T23:41:44.000000Z"},{"id":11461754,"change_date":"2024-11-02 21:33:00","inspection_id":"83063957","insp_unit_id":"203706641","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"EAST SO TR","insp_unit_company":null,"insp_unit_license":"6394A35","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"58SGF4027PE035346","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:41:44.000000Z","updated_at":"2025-03-17T23:41:44.000000Z"}]},{"id":6994064,"change_date":"2024-10-19 21:33:00","inspection_id":"82944530","dot_number":"3670419","report_state":"TN","report_number":"I037D40023","insp_date":"2024-10-17 00:00:00","insp_start_time":"0730","insp_end_time":"0809","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"KINGSTON SPRINGS TN","county_code_state":"TN","county_code":"021","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"EMH INC","shipping_paper_number":"1151","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-10-19 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"39000","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":"962334","transaction_code":"A","transaction_date":"2024-10-19 00:00:00","upload_date":"2024-10-19 00:00:00","upload_first_byte":"0","upload_dot_number":"03670419","upload_search_indicator":null,"census_search_date":"2024-10-19 21:33:00","snet_input_date":"2024-10-17 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-10-19 21:33:00","insp_carrier_name":"DELLET FERRER HOTSHOT LLC","insp_carrier_street":"1415 ELDRIDGE PARKWAY #225","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77077","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:41:49.000000Z","updated_at":"2025-03-17T20:41:49.000000Z","inspection_violations":[],"inspection_per_units":[{"id":11281037,"change_date":"2024-10-19 21:33:00","inspection_id":"82944530","insp_unit_id":"203482922","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"K130111","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FT8W3DT9KEC96861","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:39:49.000000Z","updated_at":"2025-03-17T23:39:49.000000Z"},{"id":11281038,"change_date":"2024-10-19 21:33:00","inspection_id":"82944530","insp_unit_id":"203482923","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIG TEX","insp_unit_company":null,"insp_unit_license":"232C661","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"16VGX3523K6008751","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:39:49.000000Z","updated_at":"2025-03-17T23:39:49.000000Z"}]},{"id":6612931,"change_date":"2024-08-30 21:40:00","inspection_id":"82539053","dot_number":"3670419","report_state":"KS","report_number":"HP02330753","insp_date":"2024-08-29 00:00:00","insp_start_time":"0857","insp_end_time":"1037","registration_date":null,"region":"CT","ci_status_code":"C","location":"EW","location_desc":"ELLSWORTH COUNTY - 053","county_code_state":"KS","county_code":"053","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"NOLAN TRANSPORTATION","shipping_paper_number":"NTG7883455","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-08-30 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"39000","viol_total":"11","oos_total":"0","driver_viol_total":"9","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1335925","transaction_code":"A","transaction_date":"2024-08-29 00:00:00","upload_date":"2024-08-30 00:00:00","upload_first_byte":"0","upload_dot_number":"03670419","upload_search_indicator":null,"census_search_date":"2024-08-30 21:40:00","snet_input_date":"2024-08-29 00:00:00","source_office":"3KSS001","mcmis_add_date":"2024-08-30 21:40:00","insp_carrier_name":"DELLET FERRER HOTSHOT LLC","insp_carrier_street":"1415 ELDRIDGE PARKWAY #225","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77077","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:34:05.000000Z","updated_at":"2025-03-17T20:34:05.000000Z","inspection_violations":[{"id":10282608,"change_date":"2024-08-30 21:40:00","inspection_id":"82539053","insp_violation_id":"261529208","seq_no":"1","part_no":"395","part_no_section":"30(b)(1)","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-03-17T21:55:49.000000Z","updated_at":"2025-03-17T21:55:49.000000Z","normalized_code":"39530B1"},{"id":10282609,"change_date":"2024-08-30 21:40:00","inspection_id":"82539053","insp_violation_id":"261529209","seq_no":"2","part_no":"395","part_no_section":"30(b)(1)","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-03-17T21:55:49.000000Z","updated_at":"2025-03-17T21:55:49.000000Z","normalized_code":"39530B1"},{"id":10282610,"change_date":"2024-08-30 21:40:00","inspection_id":"82539053","insp_violation_id":"261529210","seq_no":"3","part_no":"395","part_no_section":"30(b)(1)","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-03-17T21:55:49.000000Z","updated_at":"2025-03-17T21:55:49.000000Z","normalized_code":"39530B1"},{"id":10282611,"change_date":"2024-08-30 21:40:00","inspection_id":"82539053","insp_violation_id":"261529211","seq_no":"4","part_no":"395","part_no_section":"30(b)(1)","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-03-17T21:55:49.000000Z","updated_at":"2025-03-17T21:55:49.000000Z","normalized_code":"39530B1"},{"id":10282612,"change_date":"2024-08-30 21:40:00","inspection_id":"82539053","insp_violation_id":"261529212","seq_no":"5","part_no":"395","part_no_section":"30(b)(1)","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-03-17T21:55:49.000000Z","updated_at":"2025-03-17T21:55:49.000000Z","normalized_code":"39530B1"},{"id":10282613,"change_date":"2024-08-30 21:40:00","inspection_id":"82539053","insp_violation_id":"261529213","seq_no":"6","part_no":"395","part_no_section":"30(b)(1)","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-03-17T21:55:49.000000Z","updated_at":"2025-03-17T21:55:49.000000Z","normalized_code":"39530B1"},{"id":10282614,"change_date":"2024-08-30 21:40:00","inspection_id":"82539053","insp_violation_id":"261529214","seq_no":"7","part_no":"395","part_no_section":"30(b)(1)","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-03-17T21:55:49.000000Z","updated_at":"2025-03-17T21:55:49.000000Z","normalized_code":"39530B1"},{"id":10282615,"change_date":"2024-08-30 21:40:00","inspection_id":"82539053","insp_violation_id":"261529215","seq_no":"8","part_no":"395","part_no_section":"24(c)(2)(ii)","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-03-17T21:55:49.000000Z","updated_at":"2025-03-17T21:55:49.000000Z","normalized_code":"39524C2II"},{"id":10282616,"change_date":"2024-08-30 21:40:00","inspection_id":"82539053","insp_violation_id":"261529216","seq_no":"9","part_no":"395","part_no_section":"24(c)(2)(iii)","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-03-17T21:55:49.000000Z","updated_at":"2025-03-17T21:55:49.000000Z","normalized_code":"39524C2III"},{"id":10282617,"change_date":"2024-08-30 21:40:00","inspection_id":"82539053","insp_violation_id":"261529217","seq_no":"10","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"202688830","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:49.000000Z","updated_at":"2025-03-17T21:55:49.000000Z","normalized_code":"39395A"},{"id":10282618,"change_date":"2024-08-30 21:40:00","inspection_id":"82539053","insp_violation_id":"261529218","seq_no":"11","part_no":"393","part_no_section":"60(d)","insp_viol_unit":"1","insp_unit_id":"202688830","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:55:49.000000Z","updated_at":"2025-03-17T21:55:49.000000Z","normalized_code":"39360D"}],"inspection_per_units":[{"id":10661787,"change_date":"2024-08-30 21:40:00","inspection_id":"82539053","insp_unit_id":"202688830","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"05","insp_unit_license":"K130111","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FT8W3DT9KEC96861","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:33:25.000000Z","updated_at":"2025-03-17T23:33:25.000000Z"},{"id":10661788,"change_date":"2024-08-30 21:40:00","inspection_id":"82539053","insp_unit_id":"202688831","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIGT","insp_unit_company":null,"insp_unit_license":"232C661","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"16VGX3523K6008751","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:33:25.000000Z","updated_at":"2025-03-17T23:33:25.000000Z"}]},{"id":6651516,"change_date":"2024-09-05 21:42:00","inspection_id":"82580014","dot_number":"3670419","report_state":"AZ","report_number":"7499000829","insp_date":"2024-08-29 00:00:00","insp_start_time":"0638","insp_end_time":"0733","registration_date":null,"region":"MS","ci_status_code":"C","location":"AZ190","location_desc":"CASA GRANDE AZ","county_code_state":"AZ","county_code":"021","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"TEXAS MISC IRON INC","shipping_paper_number":"31873","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-05 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"22000","viol_total":"9","oos_total":"4","driver_viol_total":"0","driver_oos_total":"4","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"815841","transaction_code":"A","transaction_date":"2024-09-05 00:00:00","upload_date":"2024-09-05 00:00:00","upload_first_byte":"0","upload_dot_number":"03670419","upload_search_indicator":null,"census_search_date":"2024-09-05 21:42:00","snet_input_date":"2024-08-29 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-09-05 21:42:00","insp_carrier_name":"DELLET FERRER HOTSHOT LLC","insp_carrier_street":"1415 ELDRIDGE PARKWAY #225","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77077","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:34:51.000000Z","updated_at":"2025-03-17T20:34:51.000000Z","inspection_violations":[{"id":10350267,"change_date":"2024-09-05 21:42:00","inspection_id":"82580014","insp_violation_id":"261622412","seq_no":"1","part_no":"390","part_no_section":"21T(b)(2)","insp_viol_unit":"1","insp_unit_id":"202766870","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:08.000000Z","updated_at":"2025-03-17T21:56:08.000000Z","normalized_code":"39021TB2"},{"id":10350268,"change_date":"2024-09-05 21:42:00","inspection_id":"82580014","insp_violation_id":"261622413","seq_no":"2","part_no":"393","part_no_section":"60(d)","insp_viol_unit":"1","insp_unit_id":"202766870","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:08.000000Z","updated_at":"2025-03-17T21:56:08.000000Z","normalized_code":"39360D"},{"id":10350269,"change_date":"2024-09-05 21:42:00","inspection_id":"82580014","insp_violation_id":"261622414","seq_no":"3","part_no":"390","part_no_section":"21T(b)(1)","insp_viol_unit":"1","insp_unit_id":"202766870","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:08.000000Z","updated_at":"2025-03-17T21:56:08.000000Z","normalized_code":"39021TB1"},{"id":10350270,"change_date":"2024-09-05 21:42:00","inspection_id":"82580014","insp_violation_id":"261622415","seq_no":"4","part_no":"395","part_no_section":"3(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"4","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:08.000000Z","updated_at":"2025-03-17T21:56:08.000000Z","normalized_code":"3953A2"},{"id":10350271,"change_date":"2024-09-05 21:42:00","inspection_id":"82580014","insp_violation_id":"261622416","seq_no":"5","part_no":"395","part_no_section":"3(a)(2)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"4","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:08.000000Z","updated_at":"2025-03-17T21:56:08.000000Z","normalized_code":"3953A2"},{"id":10350272,"change_date":"2024-09-05 21:42:00","inspection_id":"82580014","insp_violation_id":"261622417","seq_no":"6","part_no":"395","part_no_section":"3(a)(3)(i)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"4","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:08.000000Z","updated_at":"2025-03-17T21:56:08.000000Z","normalized_code":"3953A3I"},{"id":10350273,"change_date":"2024-09-05 21:42:00","inspection_id":"82580014","insp_violation_id":"261622418","seq_no":"7","part_no":"395","part_no_section":"3(a)(3)(i)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"4","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:56:08.000000Z","updated_at":"2025-03-17T21:56:08.000000Z","normalized_code":"3953A3I"},{"id":10350274,"change_date":"2024-09-05 21:42:00","inspection_id":"82580014","insp_violation_id":"261622419","seq_no":"8","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:56:08.000000Z","updated_at":"2025-03-17T21:56:08.000000Z","normalized_code":"3958E1"},{"id":10350275,"change_date":"2024-09-05 21:42:00","inspection_id":"82580014","insp_violation_id":"261622420","seq_no":"9","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:56:08.000000Z","updated_at":"2025-03-17T21:56:08.000000Z","normalized_code":"3958E1"}],"inspection_per_units":[{"id":10724080,"change_date":"2024-09-05 21:42:00","inspection_id":"82580014","insp_unit_id":"202766870","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODGE","insp_unit_company":"8555","insp_unit_license":"VGT8555","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3C6UR5CL7RG277478","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:34:02.000000Z","updated_at":"2025-03-17T23:34:02.000000Z"},{"id":10724081,"change_date":"2024-09-05 21:42:00","inspection_id":"82580014","insp_unit_id":"202766871","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNPUBLISHE","insp_unit_company":"1","insp_unit_license":"636774M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"7HYGF402XNH001925","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:34:02.000000Z","updated_at":"2025-03-17T23:34:02.000000Z"}]},{"id":6595947,"change_date":"2024-08-29 21:42:00","inspection_id":"82520980","dot_number":"3670419","report_state":"LA","report_number":"LALE001953","insp_date":"2024-08-27 00:00:00","insp_start_time":"0830","insp_end_time":"0905","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"ROADSIDE","county_code_state":"LA","county_code":"029","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":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2024-08-29 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"1217241","transaction_code":"A","transaction_date":"2024-08-29 00:00:00","upload_date":"2024-08-29 00:00:00","upload_first_byte":"0","upload_dot_number":"03670419","upload_search_indicator":"M","census_search_date":"2024-08-29 21:42:00","snet_input_date":"2024-08-29 00:00:00","source_office":"2LAS001","mcmis_add_date":"2024-08-29 21:42:00","insp_carrier_name":"DELLET FERRER HOTSHOT LLC","insp_carrier_street":"1415 ELDRIDGE PARKWAY #225","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77077","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:33:41.000000Z","updated_at":"2025-03-17T20:33:41.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10633734,"change_date":"2024-08-29 21:42:00","inspection_id":"82520980","insp_unit_id":"202653138","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":"1","insp_unit_license":"RFLG13","insp_unit_license_state":"FL","insp_unit_vehicle_id_number":"3C63RRGL2EG153867","insp_unit_decal":"Y","insp_unit_decal_number":"34329733","created_at":"2025-03-17T23:33:07.000000Z","updated_at":"2025-03-17T23:33:07.000000Z"},{"id":10633735,"change_date":"2024-08-29 21:42:00","inspection_id":"82520980","insp_unit_id":"202653139","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"GATO","insp_unit_company":"T1","insp_unit_license":"450654M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"4Z1GF4025NS001983","insp_unit_decal":"Y","insp_unit_decal_number":"34329734","created_at":"2025-03-17T23:33:07.000000Z","updated_at":"2025-03-17T23:33:07.000000Z"}]},{"id":6487832,"change_date":"2024-08-16 21:39:00","inspection_id":"82405664","dot_number":"3670419","report_state":"IA","report_number":"000P11026X","insp_date":"2024-08-15 00:00:00","insp_start_time":"0900","insp_end_time":"1000","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"HWY 60 NB 17MM","county_code_state":"IA","county_code":"167","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"EQUIPMENT MANAGEMENT SERVICES LLC","shipping_paper_number":"94680","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-08-16 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"22000","viol_total":"3","oos_total":"1","driver_viol_total":"3","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1325397","transaction_code":"A","transaction_date":"2024-08-16 00:00:00","upload_date":"2024-08-16 00:00:00","upload_first_byte":"0","upload_dot_number":"03670419","upload_search_indicator":"M","census_search_date":"2024-08-16 21:39:00","snet_input_date":"2024-08-15 00:00:00","source_office":"3IAS001","mcmis_add_date":"2024-08-16 21:39:00","insp_carrier_name":"DELLET FERRER HOTSHOT LLC","insp_carrier_street":"1415 ELDRIDGE PARKWAY #225","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77077","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:31:34.000000Z","updated_at":"2025-03-17T20:31:34.000000Z","inspection_violations":[{"id":10075347,"change_date":"2024-08-16 21:39:00","inspection_id":"82405664","insp_violation_id":"261235563","seq_no":"1","part_no":"391","part_no_section":"41(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"1DYK24081509512","created_at":"2025-03-17T21:54:44.000000Z","updated_at":"2025-03-17T21:54:44.000000Z","normalized_code":"39141A"},{"id":10075348,"change_date":"2024-08-16 21:39:00","inspection_id":"82405664","insp_violation_id":"261235564","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":null,"created_at":"2025-03-17T21:54:44.000000Z","updated_at":"2025-03-17T21:54:44.000000Z","normalized_code":"3958E1"},{"id":10075349,"change_date":"2024-08-16 21:39:00","inspection_id":"82405664","insp_violation_id":"261235565","seq_no":"3","part_no":"395","part_no_section":"30(b)(1)","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-03-17T21:54:44.000000Z","updated_at":"2025-03-17T21:54:44.000000Z","normalized_code":"39530B1"}],"inspection_per_units":[{"id":10457827,"change_date":"2024-08-16 21:39:00","inspection_id":"82405664","insp_unit_id":"202433476","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":"8555","insp_unit_license":"VGT8555","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3C6UR5CL7RG277478","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:31:21.000000Z","updated_at":"2025-03-17T23:31:21.000000Z"},{"id":10457828,"change_date":"2024-08-16 21:39:00","inspection_id":"82405664","insp_unit_id":"202433477","insp_unit_type_id":"3","insp_unit_number":"2","insp_unit_make":"MAXE","insp_unit_company":"400210T","insp_unit_license":"400201T","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"5R8GF402XPM103279","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:31:21.000000Z","updated_at":"2025-03-17T23:31:21.000000Z"}]},{"id":6158146,"change_date":"2024-07-08 21:41:00","inspection_id":"82052602","dot_number":"3670419","report_state":"FL","report_number":"2837003761","insp_date":"2024-07-02 00:00:00","insp_start_time":"0935","insp_end_time":"1050","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"PENSACOLA FL","county_code_state":"FL","county_code":"033","insp_level_id":"2","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"FLORIDA GAS TRANSMISSION","shipping_paper_number":"16396","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-07-08 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"4","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":"631510","transaction_code":"A","transaction_date":"2024-07-08 00:00:00","upload_date":"2024-07-08 00:00:00","upload_first_byte":"0","upload_dot_number":"03670419","upload_search_indicator":null,"census_search_date":"2024-07-08 21:41:00","snet_input_date":"2024-07-02 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-07-08 21:41:00","insp_carrier_name":"DELLET FERRER HOTSHOT LLC","insp_carrier_street":"1415 ELDRIDGE PARKWAY #225","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77077","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:24:39.000000Z","updated_at":"2025-03-17T20:24:39.000000Z","inspection_violations":[{"id":9558048,"change_date":"2024-07-08 21:41:00","inspection_id":"82052602","insp_violation_id":"260493280","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"12","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:14.000000Z","updated_at":"2025-03-17T21:52:14.000000Z","normalized_code":"3922"},{"id":9558049,"change_date":"2024-07-08 21:41:00","inspection_id":"82052602","insp_violation_id":"260493281","seq_no":"2","part_no":"390","part_no_section":"21T(b)(1)","insp_viol_unit":"1","insp_unit_id":"201758019","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"000814928","created_at":"2025-03-17T21:52:14.000000Z","updated_at":"2025-03-17T21:52:14.000000Z","normalized_code":"39021TB1"},{"id":9558050,"change_date":"2024-07-08 21:41:00","inspection_id":"82052602","insp_violation_id":"260493282","seq_no":"3","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"201758019","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"000814928","created_at":"2025-03-17T21:52:14.000000Z","updated_at":"2025-03-17T21:52:14.000000Z","normalized_code":"3922"},{"id":9558051,"change_date":"2024-07-08 21:41:00","inspection_id":"82052602","insp_violation_id":"260493283","seq_no":"4","part_no":"390","part_no_section":"21T(b)(2)","insp_viol_unit":"1","insp_unit_id":"201758019","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:52:14.000000Z","updated_at":"2025-03-17T21:52:14.000000Z","normalized_code":"39021TB2"}],"inspection_per_units":[{"id":9919936,"change_date":"2024-07-08 21:41:00","inspection_id":"82052602","insp_unit_id":"201758019","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODGE","insp_unit_company":null,"insp_unit_license":"SHL6603","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3C63RRHL7HG656510","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:25:48.000000Z","updated_at":"2025-03-17T23:25:48.000000Z"},{"id":9919937,"change_date":"2024-07-08 21:41:00","inspection_id":"82052602","insp_unit_id":"201758020","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MAXX-D","insp_unit_company":null,"insp_unit_license":"354822T","insp_unit_license_state":"TN","insp_unit_vehicle_id_number":"5R8GF4025PM100760","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:25:48.000000Z","updated_at":"2025-03-17T23:25:48.000000Z"}]},{"id":5937015,"change_date":"2024-06-07 21:38:00","inspection_id":"81814001","dot_number":"3670419","report_state":"KY","report_number":"CV44584997","insp_date":"2024-06-06 00:00:00","insp_start_time":"1210","insp_end_time":"1255","registration_date":null,"region":"ET","ci_status_code":"C","location":"9804","location_desc":"MOREHEAD","county_code_state":"KY","county_code":"205","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"DANIELI ASHLAND SERVICE CENTER","shipping_paper_number":"US1JHY48","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-07 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"39000","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":"2229036","transaction_code":"A","transaction_date":"2024-06-07 00:00:00","upload_date":"2024-06-07 00:00:00","upload_first_byte":"0","upload_dot_number":"03670419","upload_search_indicator":"M","census_search_date":"2024-06-07 21:38:00","snet_input_date":"2024-06-07 00:00:00","source_office":"2KYS001","mcmis_add_date":"2024-06-07 21:38:00","insp_carrier_name":"DELLET FERRER HOTSHOT LLC","insp_carrier_street":"1415 ELDRIDGE PARKWAY #225","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77077","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:20:18.000000Z","updated_at":"2025-03-17T20:20:18.000000Z","inspection_violations":[],"inspection_per_units":[{"id":9562622,"change_date":"2024-06-07 21:38:00","inspection_id":"81814001","insp_unit_id":"201282989","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"04","insp_unit_license":"K130111","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FT8W3DT9KEC96861","insp_unit_decal":"Y","insp_unit_decal_number":"34054859","created_at":"2025-03-17T23:22:10.000000Z","updated_at":"2025-03-17T23:22:10.000000Z"},{"id":9562623,"change_date":"2024-06-07 21:38:00","inspection_id":"81814001","insp_unit_id":"201282990","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIGT","insp_unit_company":"102","insp_unit_license":"232C661","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"16VGX3523K6008751","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:22:10.000000Z","updated_at":"2025-03-17T23:22:10.000000Z"}]},{"id":5841290,"change_date":"2024-05-26 21:32:00","inspection_id":"81710062","dot_number":"3670419","report_state":"FL","report_number":"4965000114","insp_date":"2024-05-20 00:00:00","insp_start_time":"1304","insp_end_time":"1510","registration_date":null,"region":"ED","ci_status_code":"C","location":null,"location_desc":"MONTICELLO FL","county_code_state":"FL","county_code":"065","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"TELLWORKS NDC","shipping_paper_number":"0020731","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-05-26 21:32:00","post_acc_ind":"N","gross_comb_veh_wt":"39000","viol_total":"19","oos_total":"4","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"4","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"513714","transaction_code":"A","transaction_date":"2024-05-26 00:00:00","upload_date":"2024-05-26 00:00:00","upload_first_byte":"0","upload_dot_number":"03670419","upload_search_indicator":null,"census_search_date":"2024-05-26 21:32:00","snet_input_date":"2024-05-20 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-05-26 21:32:00","insp_carrier_name":"DELLET FERRER HOTSHOT LLC","insp_carrier_street":"1415 ELDRIDGE PARKWAY #225","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77077","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:18:37.000000Z","updated_at":"2025-03-17T20:18:37.000000Z","inspection_violations":[{"id":9051754,"change_date":"2024-05-26 21:32:00","inspection_id":"81710062","insp_violation_id":"259725326","seq_no":"11","part_no":"393","part_no_section":"95(a)(1)","insp_viol_unit":"1","insp_unit_id":"201081934","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:44.000000Z","updated_at":"2025-03-17T21:49:44.000000Z","normalized_code":"39395A1"},{"id":9051755,"change_date":"2024-05-26 21:32:00","inspection_id":"81710062","insp_violation_id":"259725327","seq_no":"12","part_no":"393","part_no_section":"95(b)","insp_viol_unit":"1","insp_unit_id":"201081934","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:44.000000Z","updated_at":"2025-03-17T21:49:44.000000Z","normalized_code":"39395B"},{"id":9051756,"change_date":"2024-05-26 21:32:00","inspection_id":"81710062","insp_violation_id":"259725328","seq_no":"13","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"201081934","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:44.000000Z","updated_at":"2025-03-17T21:49:44.000000Z","normalized_code":"3939A"},{"id":9051757,"change_date":"2024-05-26 21:32:00","inspection_id":"81710062","insp_violation_id":"259725329","seq_no":"14","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"201081935","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:44.000000Z","updated_at":"2025-03-17T21:49:44.000000Z","normalized_code":"3939A"},{"id":9051758,"change_date":"2024-05-26 21:32:00","inspection_id":"81710062","insp_violation_id":"259725330","seq_no":"15","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"2","insp_unit_id":"201081935","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:44.000000Z","updated_at":"2025-03-17T21:49:44.000000Z","normalized_code":"3939A"},{"id":9051759,"change_date":"2024-05-26 21:32:00","inspection_id":"81710062","insp_violation_id":"259725331","seq_no":"16","part_no":"395","part_no_section":"30(b)(1)","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:49:44.000000Z","updated_at":"2025-03-17T21:49:44.000000Z","normalized_code":"39530B1"},{"id":9051760,"change_date":"2024-05-26 21:32:00","inspection_id":"81710062","insp_violation_id":"259725332","seq_no":"17","part_no":"395","part_no_section":"30(b)(1)","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:49:44.000000Z","updated_at":"2025-03-17T21:49:44.000000Z","normalized_code":"39530B1"},{"id":9051761,"change_date":"2024-05-26 21:32:00","inspection_id":"81710062","insp_violation_id":"259725333","seq_no":"18","part_no":"395","part_no_section":"30(b)(1)","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:49:44.000000Z","updated_at":"2025-03-17T21:49:44.000000Z","normalized_code":"39530B1"},{"id":9051762,"change_date":"2024-05-26 21:32:00","inspection_id":"81710062","insp_violation_id":"259725334","seq_no":"7","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"201081935","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:44.000000Z","updated_at":"2025-03-17T21:49:44.000000Z","normalized_code":"39348A"},{"id":9051763,"change_date":"2024-05-26 21:32:00","inspection_id":"81710062","insp_violation_id":"259725335","seq_no":"8","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"201081935","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:44.000000Z","updated_at":"2025-03-17T21:49:44.000000Z","normalized_code":"39348A"},{"id":9051764,"change_date":"2024-05-26 21:32:00","inspection_id":"81710062","insp_violation_id":"259725336","seq_no":"9","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"201081935","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:44.000000Z","updated_at":"2025-03-17T21:49:44.000000Z","normalized_code":"39348A"},{"id":9051765,"change_date":"2024-05-26 21:32:00","inspection_id":"81710062","insp_violation_id":"259725337","seq_no":"10","part_no":"393","part_no_section":"48(a)","insp_viol_unit":"2","insp_unit_id":"201081935","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:44.000000Z","updated_at":"2025-03-17T21:49:44.000000Z","normalized_code":"39348A"},{"id":9051766,"change_date":"2024-05-26 21:32:00","inspection_id":"81710062","insp_violation_id":"259725338","seq_no":"19","part_no":"395","part_no_section":"30(b)(1)","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:49:44.000000Z","updated_at":"2025-03-17T21:49:44.000000Z","normalized_code":"39530B1"},{"id":9051767,"change_date":"2024-05-26 21:32:00","inspection_id":"81710062","insp_violation_id":"259725339","seq_no":"1","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"201081935","insp_violation_category_id":"15","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:49:44.000000Z","updated_at":"2025-03-17T21:49:44.000000Z","normalized_code":"3963A1"},{"id":9051768,"change_date":"2024-05-26 21:32:00","inspection_id":"81710062","insp_violation_id":"259725340","seq_no":"2","part_no":"392","part_no_section":"7(a)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:44.000000Z","updated_at":"2025-03-17T21:49:44.000000Z","normalized_code":"3927A"},{"id":9051769,"change_date":"2024-05-26 21:32:00","inspection_id":"81710062","insp_violation_id":"259725341","seq_no":"3","part_no":"392","part_no_section":"8","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:49:44.000000Z","updated_at":"2025-03-17T21:49:44.000000Z","normalized_code":"3928"},{"id":9051770,"change_date":"2024-05-26 21:32:00","inspection_id":"81710062","insp_violation_id":"259725342","seq_no":"4","part_no":"393","part_no_section":"207(a)","insp_viol_unit":"2","insp_unit_id":"201081935","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:49:44.000000Z","updated_at":"2025-03-17T21:49:44.000000Z","normalized_code":"393207A"},{"id":9051771,"change_date":"2024-05-26 21:32:00","inspection_id":"81710062","insp_violation_id":"259725343","seq_no":"5","part_no":"393","part_no_section":"207(a)","insp_viol_unit":"2","insp_unit_id":"201081935","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:49:44.000000Z","updated_at":"2025-03-17T21:49:44.000000Z","normalized_code":"393207A"},{"id":9051772,"change_date":"2024-05-26 21:32:00","inspection_id":"81710062","insp_violation_id":"259725344","seq_no":"6","part_no":"393","part_no_section":"41","insp_viol_unit":"1","insp_unit_id":"201081934","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:49:44.000000Z","updated_at":"2025-03-17T21:49:44.000000Z","normalized_code":"39341"}],"inspection_per_units":[{"id":9407406,"change_date":"2024-05-26 21:32:00","inspection_id":"81710062","insp_unit_id":"201081934","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":"05","insp_unit_license":"K130111","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FT8W3DT9KEC96861","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:20:38.000000Z","updated_at":"2025-03-17T23:20:38.000000Z"},{"id":9407407,"change_date":"2024-05-26 21:32:00","inspection_id":"81710062","insp_unit_id":"201081935","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"BIG TEX","insp_unit_company":"05","insp_unit_license":"232C661","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"16VGX3523K6008751","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:20:38.000000Z","updated_at":"2025-03-17T23:20:38.000000Z"}]},{"id":5361268,"change_date":"2024-03-25 21:41:00","inspection_id":"81187502","dot_number":"3670419","report_state":"TX","report_number":"6TR79DFX9Z","insp_date":"2024-03-22 00:00:00","insp_start_time":"0758","insp_end_time":"0833","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"SH-0225 IN HARRIS CO. (686-700","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-03-25 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":"9230389","transaction_code":"A","transaction_date":"2024-03-25 00:00:00","upload_date":"2024-03-25 00:00:00","upload_first_byte":"0","upload_dot_number":"03670419","upload_search_indicator":"M","census_search_date":"2024-03-25 21:41:00","snet_input_date":"2024-03-22 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-03-25 21:41:00","insp_carrier_name":"DELLET FERRER HOTSHOT LLC","insp_carrier_street":"2416 YORKTOWN ST #371","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77056","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1026689","created_at":"2025-03-17T20:09:01.000000Z","updated_at":"2025-03-17T20:09:01.000000Z","inspection_violations":[{"id":8271968,"change_date":"2024-03-25 21:41:00","inspection_id":"81187502","insp_violation_id":"258565033","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"200073245","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:46:01.000000Z","updated_at":"2025-03-17T21:46:01.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":8634219,"change_date":"2024-03-25 21:41:00","inspection_id":"81187502","insp_unit_id":"200073245","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":null,"insp_unit_license":"PST8695","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3C7WRTCL6MG578051","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:13:18.000000Z","updated_at":"2025-03-17T23:13:18.000000Z"},{"id":8634220,"change_date":"2024-03-25 21:41:00","inspection_id":"81187502","insp_unit_id":"200073246","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":null,"insp_unit_license":"317736M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"17YGN38308B038581","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:13:18.000000Z","updated_at":"2025-03-17T23:13:18.000000Z"}]},{"id":4966910,"change_date":"2024-02-02 21:42:00","inspection_id":"80757179","dot_number":"3670419","report_state":"TX","report_number":"6SBB9DGXSN","insp_date":"2024-01-30 00:00:00","insp_start_time":"1111","insp_end_time":"1204","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"5300  GENOA RED BLUF","county_code_state":"TX","county_code":"201","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"COPART","shipping_paper_number":"37083014","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2024-02-02 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"25300","viol_total":"12","oos_total":"5","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"11","vehicle_oos_total":"4","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9186510","transaction_code":"A","transaction_date":"2024-02-02 00:00:00","upload_date":"2024-02-02 00:00:00","upload_first_byte":"0","upload_dot_number":"03670419","upload_search_indicator":"M","census_search_date":"2024-02-02 21:42:00","snet_input_date":"2024-01-30 00:00:00","source_office":"2TXS001","mcmis_add_date":"2024-02-02 21:42:00","insp_carrier_name":"DELLET FERRER HOTSHOT LLC","insp_carrier_street":"2416 YORKTOWN ST #371","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77056","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1026689","created_at":"2025-03-17T20:01:13.000000Z","updated_at":"2025-03-17T20:01:13.000000Z","inspection_violations":[{"id":7650541,"change_date":"2024-02-02 21:42:00","inspection_id":"80757179","insp_violation_id":"257642456","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:42:56.000000Z","updated_at":"2025-03-17T21:42:56.000000Z","normalized_code":"3958A1"},{"id":7650542,"change_date":"2024-02-02 21:42:00","inspection_id":"80757179","insp_violation_id":"257642457","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"199247712","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:56.000000Z","updated_at":"2025-03-17T21:42:56.000000Z","normalized_code":"3922"},{"id":7650543,"change_date":"2024-02-02 21:42:00","inspection_id":"80757179","insp_violation_id":"257642458","seq_no":"3","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"199247711","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:56.000000Z","updated_at":"2025-03-17T21:42:56.000000Z","normalized_code":"39378"},{"id":7650544,"change_date":"2024-02-02 21:42:00","inspection_id":"80757179","insp_violation_id":"257642459","seq_no":"4","part_no":"393","part_no_section":"60(d)","insp_viol_unit":"1","insp_unit_id":"199247711","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:56.000000Z","updated_at":"2025-03-17T21:42:56.000000Z","normalized_code":"39360D"},{"id":7650545,"change_date":"2024-02-02 21:42:00","inspection_id":"80757179","insp_violation_id":"257642460","seq_no":"5","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"199247712","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:56.000000Z","updated_at":"2025-03-17T21:42:56.000000Z","normalized_code":"39617C"},{"id":7650546,"change_date":"2024-02-02 21:42:00","inspection_id":"80757179","insp_violation_id":"257642461","seq_no":"6","part_no":"393","part_no_section":"43(d)","insp_viol_unit":"2","insp_unit_id":"199247712","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:42:56.000000Z","updated_at":"2025-03-17T21:42:56.000000Z","normalized_code":"39343D"},{"id":7650547,"change_date":"2024-02-02 21:42:00","inspection_id":"80757179","insp_violation_id":"257642462","seq_no":"7","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"199247712","insp_violation_category_id":"24","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:42:56.000000Z","updated_at":"2025-03-17T21:42:56.000000Z","normalized_code":"3963A1"},{"id":7650548,"change_date":"2024-02-02 21:42:00","inspection_id":"80757179","insp_violation_id":"257642463","seq_no":"8","part_no":"396","part_no_section":"3(a)(1)","insp_viol_unit":"2","insp_unit_id":"199247712","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:56.000000Z","updated_at":"2025-03-17T21:42:56.000000Z","normalized_code":"3963A1"},{"id":7650549,"change_date":"2024-02-02 21:42:00","inspection_id":"80757179","insp_violation_id":"257642464","seq_no":"9","part_no":"393","part_no_section":"205(c)","insp_viol_unit":"2","insp_unit_id":"199247712","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:56.000000Z","updated_at":"2025-03-17T21:42:56.000000Z","normalized_code":"393205C"},{"id":7650550,"change_date":"2024-02-02 21:42:00","inspection_id":"80757179","insp_violation_id":"257642465","seq_no":"10","part_no":"393","part_no_section":"104(f)(3)","insp_viol_unit":"2","insp_unit_id":"199247712","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:42:56.000000Z","updated_at":"2025-03-17T21:42:56.000000Z","normalized_code":"393104F3"},{"id":7650551,"change_date":"2024-02-02 21:42:00","inspection_id":"80757179","insp_violation_id":"257642466","seq_no":"11","part_no":"393","part_no_section":"70(b)(2)","insp_viol_unit":"2","insp_unit_id":"199247712","insp_violation_category_id":"17","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2025-03-17T21:42:56.000000Z","updated_at":"2025-03-17T21:42:56.000000Z","normalized_code":"39370B2"},{"id":7650552,"change_date":"2024-02-02 21:42:00","inspection_id":"80757179","insp_violation_id":"257642467","seq_no":"12","part_no":"392","part_no_section":"2","insp_viol_unit":"2","insp_unit_id":"199247712","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:42:56.000000Z","updated_at":"2025-03-17T21:42:56.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":7993810,"change_date":"2024-02-02 21:42:00","inspection_id":"80757179","insp_unit_id":"199247711","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"PPC1817","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FT8W3DT3CEC29402","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:07:27.000000Z","updated_at":"2025-03-17T23:07:27.000000Z"},{"id":7993811,"change_date":"2024-02-02 21:42:00","inspection_id":"80757179","insp_unit_id":"199247712","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"HMDE","insp_unit_company":null,"insp_unit_license":"026370M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"ARKAVTL0050366979","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:07:27.000000Z","updated_at":"2025-03-17T23:07:27.000000Z"}]},{"id":4292081,"change_date":"2023-10-26 21:41:00","inspection_id":"80016438","dot_number":"3670419","report_state":"LA","report_number":"LANL006464","insp_date":"2023-10-25 00:00:00","insp_start_time":"1043","insp_end_time":"1127","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"ROADSIDE","county_code_state":"LA","county_code":"027","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":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-10-26 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"2","oos_total":"2","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1184559","transaction_code":"A","transaction_date":"2023-10-26 00:00:00","upload_date":"2023-10-26 00:00:00","upload_first_byte":"0","upload_dot_number":"03670419","upload_search_indicator":"M","census_search_date":"2023-10-26 21:41:00","snet_input_date":"2023-10-26 00:00:00","source_office":"2LAS001","mcmis_add_date":"2023-10-26 21:41:00","insp_carrier_name":"DELLET FERRER HOTSHOT LLC","insp_carrier_street":"2416 YORKTOWN ST #371","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77056","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:47:52.000000Z","updated_at":"2025-03-17T19:47:52.000000Z","inspection_violations":[{"id":6639521,"change_date":"2023-10-26 21:41:00","inspection_id":"80016438","insp_violation_id":"256061537","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:37:57.000000Z","updated_at":"2025-03-17T21:37:57.000000Z","normalized_code":"3958A1"},{"id":6639522,"change_date":"2023-10-26 21:41:00","inspection_id":"80016438","insp_violation_id":"256061538","seq_no":"2","part_no":"393","part_no_section":"75(a)(3)","insp_viol_unit":"1","insp_unit_id":"197761763","insp_violation_category_id":"23","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:37:57.000000Z","updated_at":"2025-03-17T21:37:57.000000Z","normalized_code":"39375A3"}],"inspection_per_units":[{"id":6902655,"change_date":"2023-10-26 21:41:00","inspection_id":"80016438","insp_unit_id":"197761763","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":"1","insp_unit_license":"PST8695","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3C7WRTCL6MG578051","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:57:53.000000Z","updated_at":"2025-03-17T22:57:53.000000Z"},{"id":6902656,"change_date":"2023-10-26 21:41:00","inspection_id":"80016438","insp_unit_id":"197761764","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"AME","insp_unit_company":"1T","insp_unit_license":"317736M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"17YGN38308B038581","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:57:53.000000Z","updated_at":"2025-03-17T22:57:53.000000Z"}]},{"id":3135432,"change_date":"2023-05-24 21:41:00","inspection_id":"78723306","dot_number":"3670419","report_state":"CA","report_number":"NDRG004319","insp_date":"2023-05-24 00:00:00","insp_start_time":"1040","insp_end_time":"1229","registration_date":null,"region":"PT","ci_status_code":"C","location":"601","location_desc":"SIDEWINDER PLATFORM SCALE","county_code_state":"CA","county_code":"025","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"VALMONT","shipping_paper_number":"900094254","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-05-24 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"3","oos_total":"2","driver_viol_total":"1","driver_oos_total":"1","vehicle_viol_total":"2","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"14916601","transaction_code":"A","transaction_date":"2023-05-24 00:00:00","upload_date":"2023-05-24 00:00:00","upload_first_byte":"0","upload_dot_number":"03670419","upload_search_indicator":null,"census_search_date":"2023-05-24 21:41:00","snet_input_date":"2023-05-24 00:00:00","source_office":"4CAS001","mcmis_add_date":"2023-05-24 21:41:00","insp_carrier_name":"DELLET FERRER HOTSHOT LLC","insp_carrier_street":"1950 SPENWICK DR UNIT #415E","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77055","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:25:00.000000Z","updated_at":"2025-03-17T19:25:00.000000Z","inspection_violations":[{"id":4827860,"change_date":"2023-05-24 21:41:00","inspection_id":"78723306","insp_violation_id":"253065560","seq_no":"1","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":"Y","defect_verification_id":"3","citation_number":"KU51089","created_at":"2025-03-17T21:29:28.000000Z","updated_at":"2025-03-17T21:29:28.000000Z","normalized_code":"3958F1"},{"id":4827861,"change_date":"2023-05-24 21:41:00","inspection_id":"78723306","insp_violation_id":"253065561","seq_no":"2","part_no":"390","part_no_section":"21T(b)","insp_viol_unit":"1","insp_unit_id":"195130036","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:29:28.000000Z","updated_at":"2025-03-17T21:29:28.000000Z","normalized_code":"39021TB"},{"id":4827862,"change_date":"2023-05-24 21:41:00","inspection_id":"78723306","insp_violation_id":"253065562","seq_no":"3","part_no":"393","part_no_section":"106(d)","insp_viol_unit":"2","insp_unit_id":"195130037","insp_violation_category_id":"25","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T21:29:28.000000Z","updated_at":"2025-03-17T21:29:28.000000Z","normalized_code":"393106D"}],"inspection_per_units":[{"id":5043104,"change_date":"2023-05-24 21:41:00","inspection_id":"78723306","insp_unit_id":"195130036","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":"WHT","insp_unit_license":"PST8695","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3C7WRTCL6MG578051","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:45.000000Z","updated_at":"2025-03-17T22:42:45.000000Z"},{"id":5043105,"change_date":"2023-05-24 21:41:00","inspection_id":"78723306","insp_unit_id":"195130037","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"AME","insp_unit_company":"BLK","insp_unit_license":"34591H1","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"17YGN38308B038581","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:42:45.000000Z","updated_at":"2025-03-17T22:42:45.000000Z"}]},{"id":1346034,"change_date":"2022-09-22 21:40:00","inspection_id":"76680319","dot_number":"3670419","report_state":"UT","report_number":"22VB000610","insp_date":"2022-09-21 00:00:00","insp_start_time":"0815","insp_end_time":"0930","registration_date":null,"region":"MT","ci_status_code":"C","location":"MONTI","location_desc":"MONTICELLO PORT OF ENTRY","county_code_state":"UT","county_code":"037","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"HIPPO HOPPER","shipping_paper_number":"HH-27,192","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-09-22 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"859206","transaction_code":"A","transaction_date":"2022-09-21 00:00:00","upload_date":"2022-09-22 00:00:00","upload_first_byte":"0","upload_dot_number":"03670419","upload_search_indicator":null,"census_search_date":"2022-09-22 21:40:00","snet_input_date":"2022-09-21 00:00:00","source_office":"4UTS001","mcmis_add_date":"2022-09-22 21:40:00","insp_carrier_name":"DELLET FERRER HOTSHOT LLC","insp_carrier_street":"1950 SPENWICK DR UNIT #415E","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77055","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:51:36.000000Z","updated_at":"2025-03-17T18:51:36.000000Z","inspection_violations":[{"id":2131849,"change_date":"2022-09-22 21:40:00","inspection_id":"76680319","insp_violation_id":"248589891","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:16:45.000000Z","updated_at":"2025-03-17T21:16:45.000000Z","normalized_code":"3958E1"}],"inspection_per_units":[{"id":2167474,"change_date":"2022-09-22 21:40:00","inspection_id":"76680319","insp_unit_id":"191047684","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"DODG","insp_unit_company":"1","insp_unit_license":"PST8695","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3C7WRTCL6MG578051","insp_unit_decal":"Y","insp_unit_decal_number":"31676483","created_at":"2025-03-17T22:21:50.000000Z","updated_at":"2025-03-17T22:21:50.000000Z"},{"id":2167475,"change_date":"2022-09-22 21:40:00","inspection_id":"76680319","insp_unit_id":"191047685","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"AME","insp_unit_company":"1T","insp_unit_license":"317736M","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"17YGN38308B038581","insp_unit_decal":"Y","insp_unit_decal_number":"31676484","created_at":"2025-03-17T22:21:50.000000Z","updated_at":"2025-03-17T22:21:50.000000Z"}]},{"id":535816,"change_date":"2022-06-16 21:43:00","inspection_id":"75731976","dot_number":"3670419","report_state":"TX","report_number":"6B9A0XVE6B","insp_date":"2022-05-26 00:00:00","insp_start_time":"0950","insp_end_time":"1056","registration_date":"2022-06-16 00:00:00","region":"CT","ci_status_code":"C","location":null,"location_desc":"IH-0010 IN CROCKETT CO. (328-3","county_code_state":"TX","county_code":"105","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"PAYLESS AUTO AUCTION","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-06-02 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"8","oos_total":"0","driver_viol_total":"2","driver_oos_total":"0","vehicle_viol_total":"6","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"8671078","transaction_code":"C","transaction_date":"2022-06-13 00:00:00","upload_date":"2022-06-16 00:00:00","upload_first_byte":"0","upload_dot_number":"03670419","upload_search_indicator":"M","census_search_date":"2022-06-02 21:42:00","snet_input_date":"2022-05-26 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-06-02 21:42:00","insp_carrier_name":"DELLET FERRER HOTSHOT LLC","insp_carrier_street":"1950 SPENWICK DR UNIT #415E","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77055","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1026689","created_at":"2025-03-17T18:37:05.000000Z","updated_at":"2025-03-17T18:37:05.000000Z","inspection_violations":[{"id":846370,"change_date":"2022-06-16 21:43:00","inspection_id":"75731976","insp_violation_id":"246525447","seq_no":"1","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"189302811","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:01.000000Z","updated_at":"2025-03-17T21:11:01.000000Z","normalized_code":"39311"},{"id":846371,"change_date":"2022-06-16 21:43:00","inspection_id":"75731976","insp_violation_id":"246525448","seq_no":"2","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"189302811","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:01.000000Z","updated_at":"2025-03-17T21:11:01.000000Z","normalized_code":"39311"},{"id":846372,"change_date":"2022-06-16 21:43:00","inspection_id":"75731976","insp_violation_id":"246525449","seq_no":"3","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"189302811","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:01.000000Z","updated_at":"2025-03-17T21:11:01.000000Z","normalized_code":"39311"},{"id":846373,"change_date":"2022-06-16 21:43:00","inspection_id":"75731976","insp_violation_id":"246525450","seq_no":"4","part_no":"393","part_no_section":"11","insp_viol_unit":"2","insp_unit_id":"189302811","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:01.000000Z","updated_at":"2025-03-17T21:11:01.000000Z","normalized_code":"39311"},{"id":846374,"change_date":"2022-06-16 21:43:00","inspection_id":"75731976","insp_violation_id":"246525451","seq_no":"6","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:11:01.000000Z","updated_at":"2025-03-17T21:11:01.000000Z","normalized_code":"3958F1"},{"id":846375,"change_date":"2022-06-16 21:43:00","inspection_id":"75731976","insp_violation_id":"246525452","seq_no":"7","part_no":"395","part_no_section":"8","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-03-17T21:11:01.000000Z","updated_at":"2025-03-17T21:11:01.000000Z","normalized_code":"3958"},{"id":846376,"change_date":"2022-06-16 21:43:00","inspection_id":"75731976","insp_violation_id":"246525453","seq_no":"8","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"1","insp_unit_id":"189302810","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:01.000000Z","updated_at":"2025-03-17T21:11:01.000000Z","normalized_code":"39617C"},{"id":846377,"change_date":"2022-06-16 21:43:00","inspection_id":"75731976","insp_violation_id":"246525454","seq_no":"9","part_no":"396","part_no_section":"17(c)","insp_viol_unit":"2","insp_unit_id":"189302811","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:11:01.000000Z","updated_at":"2025-03-17T21:11:01.000000Z","normalized_code":"39617C"}],"inspection_per_units":[{"id":862309,"change_date":"2022-06-16 21:43:00","inspection_id":"75731976","insp_unit_id":"189302810","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"RAM","insp_unit_company":null,"insp_unit_license":"PST8695","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3C7WRTCL6MG578051","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:31.000000Z","updated_at":"2025-03-17T22:13:31.000000Z"},{"id":862310,"change_date":"2022-06-16 21:43:00","inspection_id":"75731976","insp_unit_id":"189302811","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"AMER","insp_unit_company":null,"insp_unit_license":"63976F2","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"17YGN38308B038581","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:13:31.000000Z","updated_at":"2025-03-17T22:13:31.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/3670419\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/3670419\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/3670419\/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\/3670419\/inspections","per_page":100,"prev_page_url":null,"to":44,"total":44}