{"current_page":1,"data":[{"id":12081412,"change_date":"2026-06-02 21:42:00","inspection_id":"88024274","dot_number":"3504755","report_state":"TX","report_number":"V262396175","insp_date":"2026-05-30 00:00:00","insp_start_time":"1805","insp_end_time":"1823","registration_date":null,"region":"CT","ci_status_code":"C","location":"2B141","location_desc":"US59 NB NACOGDOCHES SCALE","county_code_state":"TX","county_code":"347","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"APROJECTS","shipping_paper_number":"SUS1AP20001952","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":"132000","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":"9977281","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":"03504755","upload_search_indicator":"M","census_search_date":"2026-06-02 21:42:00","snet_input_date":"2026-05-30 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-06-02 21:42:00","insp_carrier_name":"ANDYY FREIGHT LLC","insp_carrier_street":"7522 NAVIDAD RD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77083","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1001404","created_at":"2026-06-06T09:40:33.000000Z","updated_at":"2026-06-13T09:32:02.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20994088,"change_date":"2026-06-02 21:42:00","inspection_id":"88024274","insp_unit_id":"213881678","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"15","insp_unit_license":"R791329","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3AKJGLD5XFSGK2622","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-06T09:17:36.000000Z","updated_at":"2026-06-13T09:03:38.000000Z"},{"id":20994089,"change_date":"2026-06-02 21:42:00","inspection_id":"88024274","insp_unit_id":"213881679","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FONA","insp_unit_company":"15","insp_unit_license":"DP7758","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"13N153207G1514822","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-06-06T09:17:36.000000Z","updated_at":"2026-06-13T09:03:38.000000Z"}]},{"id":11889507,"change_date":"2026-05-12 21:39:00","inspection_id":"87827558","dot_number":"3504755","report_state":"TX","report_number":"V262339489","insp_date":"2026-05-06 00:00:00","insp_start_time":"1011","insp_end_time":"1037","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"US 290 @ KICKAPOO RD","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"VARIOUS","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-12 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"128000","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":"9951536","transaction_code":"A","transaction_date":"2026-05-12 00:00:00","upload_date":"2026-05-12 00:00:00","upload_first_byte":"0","upload_dot_number":"03504755","upload_search_indicator":"M","census_search_date":"2026-05-12 21:39:00","snet_input_date":"2026-05-06 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-05-12 21:39:00","insp_carrier_name":"ANDYY FREIGHT LLC","insp_carrier_street":"7522 NAVIDAD RD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77083","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1001404","created_at":"2026-05-14T12:39:36.000000Z","updated_at":"2026-05-23T09:31:27.000000Z","inspection_violations":[],"inspection_per_units":[{"id":20671870,"change_date":"2026-05-12 21:39:00","inspection_id":"87827558","insp_unit_id":"213511851","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"17","insp_unit_license":"39R743N","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKYD49X0GJ463361","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-14T12:01:43.000000Z","updated_at":"2026-05-23T09:04:29.000000Z"},{"id":20671871,"change_date":"2026-05-12 21:39:00","inspection_id":"87827558","insp_unit_id":"213511852","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FONA","insp_unit_company":"15","insp_unit_license":"DP7758","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"13N153207G1514822","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-05-14T12:01:43.000000Z","updated_at":"2026-05-23T09:04:29.000000Z"}]},{"id":11658017,"change_date":"2026-04-15 21:39:00","inspection_id":"87587854","dot_number":"3504755","report_state":"TX","report_number":"V262315271","insp_date":"2026-04-14 00:00:00","insp_start_time":"0900","insp_end_time":"0925","registration_date":null,"region":"CT","ci_status_code":"C","location":"2B141","location_desc":"US59 NB NACOGDOCHES SCALE","county_code_state":"TX","county_code":"347","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"LALLY PIPE & TUBE","shipping_paper_number":"S60408BH003","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2026-04-15 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9919787","transaction_code":"A","transaction_date":"2026-04-15 00:00:00","upload_date":"2026-04-15 00:00:00","upload_first_byte":"0","upload_dot_number":"03504755","upload_search_indicator":"M","census_search_date":"2026-04-15 21:39:00","snet_input_date":"2026-04-14 00:00:00","source_office":"2TXS001","mcmis_add_date":"2026-04-15 21:39:00","insp_carrier_name":"ANDYY FREIGHT LLC","insp_carrier_street":"7522 NAVIDAD RD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77083","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1001404","created_at":"2026-04-26T09:31:18.000000Z","updated_at":"2026-04-26T09:31:18.000000Z","inspection_violations":[{"id":20245412,"change_date":"2026-04-15 21:39:00","inspection_id":"87587854","insp_violation_id":"273629967","seq_no":"1","part_no":"393","part_no_section":"83G","insp_viol_unit":"1","insp_unit_id":"213038141","insp_violation_category_id":"27","out_of_service_indicator":"Y","defect_verification_id":"4","citation_number":null,"created_at":"2026-04-26T09:42:29.000000Z","updated_at":"2026-04-26T09:42:29.000000Z","normalized_code":"39383G"}],"inspection_per_units":[{"id":20278398,"change_date":"2026-04-15 21:39:00","inspection_id":"87587854","insp_unit_id":"213038141","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"11","insp_unit_license":"R512510","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2FUPCSEBXWA903709","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-26T09:04:11.000000Z","updated_at":"2026-04-26T09:04:11.000000Z"},{"id":20278399,"change_date":"2026-04-15 21:39:00","inspection_id":"87587854","insp_unit_id":"213038142","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"WILS","insp_unit_company":"747","insp_unit_license":"EB5293","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"4WWBGB6B8VN601139","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-04-26T09:04:11.000000Z","updated_at":"2026-04-26T09:04:11.000000Z"}]},{"id":11276088,"change_date":"2026-03-03 21:35:00","inspection_id":"87190538","dot_number":"3504755","report_state":"IL","report_number":"5009670026","insp_date":"2026-03-02 00:00:00","insp_start_time":"1000","insp_end_time":"1020","registration_date":null,"region":"CT","ci_status_code":"C","location":"011","location_desc":"011 - WADSWORTH - US41","county_code_state":"IL","county_code":"097","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"AXIS PIPE AND TUBE","shipping_paper_number":"60098586","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-03 21:35:00","post_acc_ind":"N","gross_comb_veh_wt":"160000","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":"2459503","transaction_code":"A","transaction_date":"2026-03-02 00:00:00","upload_date":"2026-03-03 00:00:00","upload_first_byte":"0","upload_dot_number":"03504755","upload_search_indicator":null,"census_search_date":"2026-03-03 21:35:00","snet_input_date":"2026-03-02 00:00:00","source_office":"3ILS001","mcmis_add_date":"2026-03-03 21:35:00","insp_carrier_name":"ANDYY FREIGHT LLC","insp_carrier_street":"7522 NAVIDAD RD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77083","insp_colonia":null,"docket_number":"115804","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-03-06T10:39:40.000000Z","updated_at":"2026-03-14T09:30:31.000000Z","inspection_violations":[],"inspection_per_units":[{"id":19284105,"change_date":"2026-03-03 21:35:00","inspection_id":"87190538","insp_unit_id":"211940276","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"16","insp_unit_license":"R756964","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUPCSZB5YPF01552","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-06T10:17:05.000000Z","updated_at":"2026-03-14T09:03:05.000000Z"},{"id":19284106,"change_date":"2026-03-03 21:35:00","inspection_id":"87190538","insp_unit_id":"211940277","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FOTR","insp_unit_company":"202147","insp_unit_license":"DP7757","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"13N15320XH1515027","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-06T10:17:05.000000Z","updated_at":"2026-03-14T09:03:05.000000Z"}]},{"id":11056203,"change_date":"2026-02-27 21:41:00","inspection_id":"86956943","dot_number":"3504755","report_state":"IL","report_number":"4289750263","insp_date":"2026-02-02 00:00:00","insp_start_time":"2207","insp_end_time":"2243","registration_date":"2026-02-26 00:00:00","region":"CT","ci_status_code":"C","location":"999","location_desc":"I-57 SOUTH","county_code_state":"IL","county_code":"041","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"BULL MOOSE TUBE","shipping_paper_number":"HOU214889","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-02-04 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"115000","viol_total":"6","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":"2454468","transaction_code":"C","transaction_date":"2026-02-02 00:00:00","upload_date":"2026-02-27 00:00:00","upload_first_byte":"0","upload_dot_number":"03504755","upload_search_indicator":null,"census_search_date":"2026-02-04 21:39:00","snet_input_date":"2026-02-02 00:00:00","source_office":"3ILS001","mcmis_add_date":"2026-02-04 21:39:00","insp_carrier_name":"ANDYY FREIGHT LLC","insp_carrier_street":"7522 NAVIDAD RD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77083","insp_colonia":null,"docket_number":"115804","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-08T10:37:22.000000Z","updated_at":"2026-03-10T09:31:21.000000Z","inspection_violations":[{"id":18885820,"change_date":"2026-02-27 21:41:00","inspection_id":"86956943","insp_violation_id":"272091802","seq_no":"1","part_no":"393","part_no_section":"9T","insp_viol_unit":"2","insp_unit_id":"211881356","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-02T10:58:21.000000Z","updated_at":"2026-03-10T09:44:20.000000Z","normalized_code":"3939T"},{"id":18885821,"change_date":"2026-02-27 21:41:00","inspection_id":"86956943","insp_violation_id":"272091803","seq_no":"2","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"211881356","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-02T10:58:21.000000Z","updated_at":"2026-03-10T09:44:20.000000Z","normalized_code":"3939"},{"id":18885822,"change_date":"2026-02-27 21:41:00","inspection_id":"86956943","insp_violation_id":"272091804","seq_no":"3","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"211881356","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-02T10:58:21.000000Z","updated_at":"2026-03-10T09:44:20.000000Z","normalized_code":"3939"},{"id":18885823,"change_date":"2026-02-27 21:41:00","inspection_id":"86956943","insp_violation_id":"272091805","seq_no":"4","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"211881356","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-02T10:58:21.000000Z","updated_at":"2026-03-10T09:44:20.000000Z","normalized_code":"3939"},{"id":18885824,"change_date":"2026-02-27 21:41:00","inspection_id":"86956943","insp_violation_id":"272091806","seq_no":"5","part_no":"393","part_no_section":"9","insp_viol_unit":"2","insp_unit_id":"211881356","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-02T10:58:21.000000Z","updated_at":"2026-03-10T09:44:20.000000Z","normalized_code":"3939"},{"id":18885825,"change_date":"2026-02-27 21:41:00","inspection_id":"86956943","insp_violation_id":"272091807","seq_no":"6","part_no":"393","part_no_section":"11TU","insp_viol_unit":"1","insp_unit_id":"211881355","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-03-02T10:58:21.000000Z","updated_at":"2026-03-10T09:44:20.000000Z","normalized_code":"39311TU"}],"inspection_per_units":[{"id":19233587,"change_date":"2026-02-27 21:41:00","inspection_id":"86956943","insp_unit_id":"211881355","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"15","insp_unit_license":"R791329","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3AKJGLD5XFSGK2622","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-02T10:16:25.000000Z","updated_at":"2026-03-10T09:02:20.000000Z"},{"id":19233588,"change_date":"2026-02-27 21:41:00","inspection_id":"86956943","insp_unit_id":"211881356","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"FONA","insp_unit_company":"UNK","insp_unit_license":"DP7757","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"13N15320XH1515027","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-03-02T10:16:25.000000Z","updated_at":"2026-03-10T09:02:20.000000Z"}]},{"id":10084382,"change_date":"2025-10-30 21:43:00","inspection_id":"86199135","dot_number":"3504755","report_state":"TX","report_number":"V251912440","insp_date":"2025-10-29 00:00:00","insp_start_time":"0810","insp_end_time":"0841","registration_date":null,"region":"CT","ci_status_code":"C","location":"2A601","location_desc":"US59 SB DIBOLL SCALE","county_code_state":"TX","county_code":"005","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"ALPINE HW","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-10-30 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"0","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":"9742434","transaction_code":"A","transaction_date":"2025-10-30 00:00:00","upload_date":"2025-10-30 00:00:00","upload_first_byte":"0","upload_dot_number":"03504755","upload_search_indicator":"M","census_search_date":"2025-10-30 21:43:00","snet_input_date":"2025-10-29 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-10-30 21:43:00","insp_carrier_name":"ANDYY FREIGHT LLC","insp_carrier_street":"7522 NAVIDAD RD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77083","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1001404","created_at":"2025-11-02T11:02:24.000000Z","updated_at":"2025-11-03T11:04:22.000000Z","inspection_violations":[],"inspection_per_units":[{"id":16763760,"change_date":"2025-10-30 21:43:00","inspection_id":"86199135","insp_unit_id":"209754177","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"KW","insp_unit_company":"11","insp_unit_license":"R512518","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1XKWD49X88J221667","insp_unit_decal":"Y","insp_unit_decal_number":"35660981","created_at":"2025-11-02T10:47:42.000000Z","updated_at":"2025-11-03T10:46:51.000000Z"},{"id":16763761,"change_date":"2025-10-30 21:43:00","inspection_id":"86199135","insp_unit_id":"209754178","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"OTHR","insp_unit_company":"11VB","insp_unit_license":"DP7758","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"13N153207G1514822","insp_unit_decal":"Y","insp_unit_decal_number":"35660982","created_at":"2025-11-02T10:47:42.000000Z","updated_at":"2025-11-03T10:46:51.000000Z"}]},{"id":9622784,"change_date":"2025-09-08 21:38:00","inspection_id":"85713505","dot_number":"3504755","report_state":"TX","report_number":"V251986296","insp_date":"2025-09-04 00:00:00","insp_start_time":"0732","insp_end_time":"0755","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"6272  US59 NB","county_code_state":"TX","county_code":"373","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"GULF STREAM","shipping_paper_number":"510198661","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-09-08 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9690130","transaction_code":"A","transaction_date":"2025-09-08 00:00:00","upload_date":"2025-09-08 00:00:00","upload_first_byte":"0","upload_dot_number":"03504755","upload_search_indicator":"M","census_search_date":"2025-09-08 21:38:00","snet_input_date":"2025-09-04 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-09-08 21:38:00","insp_carrier_name":"ANDYY FREIGHT LLC","insp_carrier_street":"7522 NAVIDAD RD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77083","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1001404","created_at":"2025-09-10T10:46:13.000000Z","updated_at":"2025-09-11T10:46:35.000000Z","inspection_violations":[{"id":15737743,"change_date":"2025-09-08 21:38:00","inspection_id":"85713505","insp_violation_id":"268527938","seq_no":"1","part_no":"393","part_no_section":"104B","insp_viol_unit":"2","insp_unit_id":"208805403","insp_violation_category_id":"25","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-11T10:48:16.000000Z","updated_at":"2025-09-12T10:50:33.000000Z","normalized_code":"393104B"},{"id":15737744,"change_date":"2025-09-08 21:38:00","inspection_id":"85713505","insp_violation_id":"268527939","seq_no":"2","part_no":"393","part_no_section":"9","insp_viol_unit":"1","insp_unit_id":"208805404","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-09-11T10:48:16.000000Z","updated_at":"2025-09-12T10:50:33.000000Z","normalized_code":"3939"}],"inspection_per_units":[{"id":15894565,"change_date":"2025-09-08 21:38:00","inspection_id":"85713505","insp_unit_id":"208805403","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MACK","insp_unit_company":"5","insp_unit_license":"228B581","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5MAPA5322NH062572","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-11T09:53:43.000000Z","updated_at":"2025-09-12T10:47:19.000000Z"},{"id":15894566,"change_date":"2025-09-08 21:38:00","inspection_id":"85713505","insp_unit_id":"208805404","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"15","insp_unit_license":"R791329","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"3AKJGLD5XFSGK2622","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-09-11T09:53:43.000000Z","updated_at":"2025-09-12T10:47:19.000000Z"}]},{"id":8427073,"change_date":"2025-04-21 21:40:00","inspection_id":"84453476","dot_number":"3504755","report_state":"MO","report_number":"W236009313","insp_date":"2025-04-18 00:00:00","insp_start_time":"1135","insp_end_time":"1235","registration_date":null,"region":"CD","ci_status_code":"C","location":"E1S","location_desc":"CHARLESTON MO","county_code_state":"MO","county_code":"133","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"F","shipper_name":"OHIO STEEL","shipping_paper_number":"381171","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-04-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","viol_total":"6","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1623022","transaction_code":"A","transaction_date":"2025-04-21 00:00:00","upload_date":"2025-04-21 00:00:00","upload_first_byte":"0","upload_dot_number":"03504755","upload_search_indicator":null,"census_search_date":"2025-04-21 21:40:00","snet_input_date":"2025-04-18 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-04-21 21:40:00","insp_carrier_name":"ANDYY FREIGHT LLC","insp_carrier_street":"7522 NAVIDAD RD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77083","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-24T10:02:53.000000Z","updated_at":"2025-04-26T10:23:14.000000Z","inspection_violations":[{"id":13303095,"change_date":"2025-04-21 21:40:00","inspection_id":"84453476","insp_violation_id":"265733914","seq_no":"1","part_no":"392","part_no_section":"2-SLLIRP","insp_viol_unit":"1","insp_unit_id":"206409947","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-24T10:23:26.000000Z","updated_at":"2025-04-25T10:36:50.000000Z","normalized_code":"3922SLLIRP"},{"id":13303096,"change_date":"2025-04-21 21:40:00","inspection_id":"84453476","insp_violation_id":"265733915","seq_no":"2","part_no":"393","part_no_section":"75A1-TEPBM","insp_viol_unit":"2","insp_unit_id":"206409948","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-24T10:23:26.000000Z","updated_at":"2025-04-25T10:36:50.000000Z","normalized_code":"39375A1TEPBM"},{"id":13303097,"change_date":"2025-04-21 21:40:00","inspection_id":"84453476","insp_violation_id":"265733916","seq_no":"3","part_no":"393","part_no_section":"9A-LTSI","insp_viol_unit":"2","insp_unit_id":"206409948","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-04-24T10:23:26.000000Z","updated_at":"2025-04-25T10:36:50.000000Z","normalized_code":"3939ALTSI"},{"id":13303098,"change_date":"2025-04-21 21:40:00","inspection_id":"84453476","insp_violation_id":"265733917","seq_no":"4","part_no":"393","part_no_section":"45D-BAAL","insp_viol_unit":"1","insp_unit_id":"206409947","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-04-24T10:23:26.000000Z","updated_at":"2025-04-25T10:36:50.000000Z","normalized_code":"39345DBAAL"},{"id":13303099,"change_date":"2025-04-21 21:40:00","inspection_id":"84453476","insp_violation_id":"265733918","seq_no":"5","part_no":"393","part_no_section":"75A1-TEPBM","insp_viol_unit":"2","insp_unit_id":"206409948","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-24T10:23:26.000000Z","updated_at":"2025-04-25T10:36:50.000000Z","normalized_code":"39375A1TEPBM"},{"id":13303100,"change_date":"2025-04-21 21:40:00","inspection_id":"84453476","insp_violation_id":"265733919","seq_no":"6","part_no":"393","part_no_section":"75A1-TEPBM","insp_viol_unit":"2","insp_unit_id":"206409948","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-24T10:23:26.000000Z","updated_at":"2025-04-25T10:36:50.000000Z","normalized_code":"39375A1TEPBM"}],"inspection_per_units":[{"id":13684523,"change_date":"2025-04-21 21:40:00","inspection_id":"84453476","insp_unit_id":"206409947","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"16","insp_unit_license":"R766031","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUPCSZB5YPF01552","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-24T09:51:42.000000Z","updated_at":"2025-04-25T09:54:32.000000Z"},{"id":13684524,"change_date":"2025-04-21 21:40:00","inspection_id":"84453476","insp_unit_id":"206409948","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"TRANSCRAFT","insp_unit_company":"16B","insp_unit_license":"X25222","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1TTF4820X12007994","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-24T09:51:42.000000Z","updated_at":"2025-04-25T09:54:32.000000Z"}]},{"id":8298051,"change_date":"2025-04-04 21:41:00","inspection_id":"84317453","dot_number":"3504755","report_state":"TX","report_number":"733E9DBV09","insp_date":"2025-02-21 00:00:00","insp_start_time":"1417","insp_end_time":"1440","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"300  MERCURY","county_code_state":"TX","county_code":"201","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"EDGEN MURRAT","shipping_paper_number":"3816611","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-04-04 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","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":"9541112","transaction_code":"A","transaction_date":"2025-04-04 00:00:00","upload_date":"2025-04-04 00:00:00","upload_first_byte":"0","upload_dot_number":"03504755","upload_search_indicator":"M","census_search_date":"2025-04-04 21:41:00","snet_input_date":"2025-02-21 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-04-04 21:41:00","insp_carrier_name":"ANDYY FREIGHT LLC","insp_carrier_street":"7522 NAVIDAD RD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77083","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1001404","created_at":"2025-04-07T10:22:18.000000Z","updated_at":"2025-04-08T10:09:48.000000Z","inspection_violations":[{"id":13048044,"change_date":"2025-04-04 21:41:00","inspection_id":"84317453","insp_violation_id":"265447233","seq_no":"1","part_no":"393","part_no_section":"75C","insp_viol_unit":"2","insp_unit_id":"206161739","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-07T10:51:22.000000Z","updated_at":"2025-04-07T10:59:21.000000Z","normalized_code":"39375C"}],"inspection_per_units":[{"id":13454417,"change_date":"2025-04-04 21:41:00","inspection_id":"84317453","insp_unit_id":"206161738","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":null,"insp_unit_license":"R582938","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUYSXYB1WL909540","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-07T10:12:28.000000Z","updated_at":"2025-04-08T10:00:33.000000Z"},{"id":13454418,"change_date":"2025-04-04 21:41:00","inspection_id":"84317453","insp_unit_id":"206161739","insp_unit_type_id":"10","insp_unit_number":"2","insp_unit_make":"TRAO","insp_unit_company":null,"insp_unit_license":"X25222","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1TTF4820X12007994","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-07T10:12:28.000000Z","updated_at":"2025-04-08T10:00:33.000000Z"}]},{"id":6758819,"change_date":"2024-09-18 21:42:00","inspection_id":"82694151","dot_number":"3504755","report_state":"IL","report_number":"4181171079","insp_date":"2024-09-17 00:00:00","insp_start_time":"1420","insp_end_time":"1435","registration_date":null,"region":"CT","ci_status_code":"C","location":"999","location_desc":"I-57","county_code_state":"IL","county_code":"199","insp_level_id":"2","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"PLUG","shipping_paper_number":"5118990","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-09-18 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"124000","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":"2357373","transaction_code":"A","transaction_date":"2024-09-17 00:00:00","upload_date":"2024-09-18 00:00:00","upload_first_byte":"0","upload_dot_number":"03504755","upload_search_indicator":null,"census_search_date":"2024-09-18 21:42:00","snet_input_date":"2024-09-17 00:00:00","source_office":"3ILS001","mcmis_add_date":"2024-09-18 21:42:00","insp_carrier_name":"ANDYY FREIGHT LLC","insp_carrier_street":"7522 NAVIDAD RD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77083","insp_colonia":null,"docket_number":"115804","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:36:59.000000Z","updated_at":"2025-03-17T20:36:59.000000Z","inspection_violations":[],"inspection_per_units":[{"id":10898817,"change_date":"2024-09-18 21:42:00","inspection_id":"82694151","insp_unit_id":"203007898","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"12","insp_unit_license":"R582938","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUYSXYB1WL909540","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:35:52.000000Z","updated_at":"2025-03-17T23:35:52.000000Z"},{"id":10898818,"change_date":"2024-09-18 21:42:00","inspection_id":"82694151","insp_unit_id":"203007899","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"DORS","insp_unit_company":"12B","insp_unit_license":"CU8995","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1DTP80Z25VG051401","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:35:52.000000Z","updated_at":"2025-03-17T23:35:52.000000Z"}]},{"id":4244881,"change_date":"2023-10-20 21:40:00","inspection_id":"79963944","dot_number":"3504755","report_state":"AR","report_number":"E594003160","insp_date":"2023-10-19 00:00:00","insp_start_time":"1353","insp_end_time":"1425","registration_date":null,"region":"CT","ci_status_code":"C","location":"61","location_desc":"RANDOLPH COUNTY","county_code_state":"AR","county_code":"121","insp_level_id":"3","service_center":"SH","census_source_id":"4","insp_facility":"R","shipper_name":"BULL MOOSE","shipping_paper_number":"601569","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2023-10-20 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","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":"1480264","transaction_code":"A","transaction_date":"2023-10-20 00:00:00","upload_date":"2023-10-20 00:00:00","upload_first_byte":"0","upload_dot_number":"03504755","upload_search_indicator":"M","census_search_date":"2023-10-20 21:40:00","snet_input_date":"2023-10-20 00:00:00","source_office":"2ARS001","mcmis_add_date":"2023-10-20 21:40:00","insp_carrier_name":"ANDYY FREIGHT LLC","insp_carrier_street":"7522 NAVIDAD RD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77083","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:47:02.000000Z","updated_at":"2025-03-17T19:47:02.000000Z","inspection_violations":[{"id":6573204,"change_date":"2023-10-20 21:40:00","inspection_id":"79963944","insp_violation_id":"255956484","seq_no":"1","part_no":"392","part_no_section":"2","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"45","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"500A1262158","created_at":"2025-03-17T21:37:40.000000Z","updated_at":"2025-03-17T21:37:40.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":6826303,"change_date":"2023-10-20 21:40:00","inspection_id":"79963944","insp_unit_id":"197660905","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"11","insp_unit_license":"R512510","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2FUPCSEBXWA903709","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:57:14.000000Z","updated_at":"2025-03-17T22:57:14.000000Z"},{"id":6826304,"change_date":"2023-10-20 21:40:00","inspection_id":"79963944","insp_unit_id":"197660906","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"MCKT","insp_unit_company":"5","insp_unit_license":"228B581","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"5MAPA5322NH062572","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:57:14.000000Z","updated_at":"2025-03-17T22:57:14.000000Z"}]},{"id":4183468,"change_date":"2023-10-12 21:41:00","inspection_id":"79896345","dot_number":"3504755","report_state":"IL","report_number":"4037570477","insp_date":"2023-10-11 00:00:00","insp_start_time":"0640","insp_end_time":"0652","registration_date":null,"region":"CT","ci_status_code":"C","location":"999","location_desc":"I-57","county_code_state":"IL","county_code":"199","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"STEEL WAREHOUSE","shipping_paper_number":"01830505","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2023-10-12 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"80000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2280563","transaction_code":"A","transaction_date":"2023-10-11 00:00:00","upload_date":"2023-10-12 00:00:00","upload_first_byte":"0","upload_dot_number":"03504755","upload_search_indicator":null,"census_search_date":"2023-10-12 21:41:00","snet_input_date":"2023-10-11 00:00:00","source_office":"3ILS001","mcmis_add_date":"2023-10-12 21:41:00","insp_carrier_name":"ANDYY FREIGHT LLC","insp_carrier_street":"7522 NAVIDAD RD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77083","insp_colonia":null,"docket_number":"115804","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:45:49.000000Z","updated_at":"2025-03-17T19:45:49.000000Z","inspection_violations":[{"id":6476830,"change_date":"2023-10-12 21:41:00","inspection_id":"79896345","insp_violation_id":"255799990","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:37:12.000000Z","updated_at":"2025-03-17T21:37:12.000000Z","normalized_code":"3958E1"}],"inspection_per_units":[{"id":6727468,"change_date":"2023-10-12 21:41:00","inspection_id":"79896345","insp_unit_id":"197523942","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"12","insp_unit_license":"R582938","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUYSXYB1WL909540","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:24.000000Z","updated_at":"2025-03-17T22:56:24.000000Z"},{"id":6727469,"change_date":"2023-10-12 21:41:00","inspection_id":"79896345","insp_unit_id":"197523943","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"DORS","insp_unit_company":null,"insp_unit_license":"CU8995","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1DTP80Z25VG051401","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:56:24.000000Z","updated_at":"2025-03-17T22:56:24.000000Z"}]},{"id":1968231,"change_date":"2022-12-18 21:31:00","inspection_id":"77395852","dot_number":"3504755","report_state":"AR","report_number":"748D000760","insp_date":"2022-12-18 00:00:00","insp_start_time":"1150","insp_end_time":"1245","registration_date":null,"region":"CT","ci_status_code":"C","location":"29-403","location_desc":"HEMPSTEAD CO (HOPE EAST STN)","county_code_state":"AR","county_code":"057","insp_level_id":"1","service_center":"SH","census_source_id":"4","insp_facility":"F","shipper_name":"ANDYY FREIGHT LLC","shipping_paper_number":"MC22254","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":"I","final_status_date":"2022-12-18 21:31:00","post_acc_ind":"N","gross_comb_veh_wt":"122000","viol_total":"2","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"2","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1436063","transaction_code":"A","transaction_date":"2022-12-18 00:00:00","upload_date":"2022-12-18 00:00:00","upload_first_byte":"0","upload_dot_number":"03504755","upload_search_indicator":"M","census_search_date":"2022-12-18 21:31:00","snet_input_date":"2022-12-18 00:00:00","source_office":"2ARS001","mcmis_add_date":"2022-12-18 21:31:00","insp_carrier_name":"ANDYY FREIGHT LLC","insp_carrier_street":"7522 NAVIDAD RD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77083","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T19:02:56.000000Z","updated_at":"2025-03-17T19:02:56.000000Z","inspection_violations":[{"id":3056191,"change_date":"2022-12-18 21:31:00","inspection_id":"77395852","insp_violation_id":"250151792","seq_no":"1","part_no":"393","part_no_section":"45(b)(2)","insp_viol_unit":"1","insp_unit_id":"192474737","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:30.000000Z","updated_at":"2025-03-17T21:21:30.000000Z","normalized_code":"39345B2"},{"id":3056192,"change_date":"2022-12-18 21:31:00","inspection_id":"77395852","insp_violation_id":"250151793","seq_no":"2","part_no":"393","part_no_section":"95(a)","insp_viol_unit":"1","insp_unit_id":"192474737","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:21:30.000000Z","updated_at":"2025-03-17T21:21:30.000000Z","normalized_code":"39395A"}],"inspection_per_units":[{"id":3166795,"change_date":"2022-12-18 21:31:00","inspection_id":"77395852","insp_unit_id":"192474737","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"11","insp_unit_license":"R512510","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2FUPCSEBXWA903709","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:41.000000Z","updated_at":"2025-03-17T22:28:41.000000Z"},{"id":3166796,"change_date":"2022-12-18 21:31:00","inspection_id":"77395852","insp_unit_id":"192474738","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"UNK","insp_unit_company":"48528","insp_unit_license":"BZ7142","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1A92F5029YM277339","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:28:41.000000Z","updated_at":"2025-03-17T22:28:41.000000Z"}]},{"id":1213040,"change_date":"2022-09-09 21:38:00","inspection_id":"76525774","dot_number":"3504755","report_state":"LA","report_number":"LAPK001662","insp_date":"2022-09-05 00:00:00","insp_start_time":"1022","insp_end_time":"1036","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"ROADSIDE","county_code_state":"LA","county_code":"017","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":"U","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-09-06 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"120000","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":"1141805","transaction_code":"C","transaction_date":"2022-09-09 00:00:00","upload_date":"2022-09-09 00:00:00","upload_first_byte":"0","upload_dot_number":"03504755","upload_search_indicator":"M","census_search_date":"2022-09-06 21:42:00","snet_input_date":"2022-09-06 00:00:00","source_office":"2LAS001","mcmis_add_date":"2022-09-06 21:42:00","insp_carrier_name":"ANDYY FREIGHT LLC","insp_carrier_street":"7522 NAVIDAD RD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77083","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T18:49:00.000000Z","updated_at":"2025-03-17T18:49:00.000000Z","inspection_violations":[],"inspection_per_units":[{"id":1951007,"change_date":"2022-09-09 21:38:00","inspection_id":"76525774","insp_unit_id":"190805083","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"12","insp_unit_license":"R582938","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUYSXYB1WL909540","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:25.000000Z","updated_at":"2025-03-17T22:20:25.000000Z"},{"id":1951008,"change_date":"2022-09-09 21:38:00","inspection_id":"76525774","insp_unit_id":"190805084","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"DORS","insp_unit_company":"12B","insp_unit_license":"207B086","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1DTP80Z25VG051401","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:20:25.000000Z","updated_at":"2025-03-17T22:20:25.000000Z"}]},{"id":775427,"change_date":"2022-08-03 21:42:00","inspection_id":"76014868","dot_number":"3504755","report_state":"TX","report_number":"6CEA0XHX5A","insp_date":"2022-07-06 00:00:00","insp_start_time":"1014","insp_end_time":"1035","registration_date":"2022-08-03 00:00:00","region":"CT","ci_status_code":"C","location":"1A501","location_desc":"US 59 QUEEN CITY","county_code_state":"TX","county_code":"067","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"TENARIS","shipping_paper_number":"103767506","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2022-07-07 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"132000","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":"8707883","transaction_code":"C","transaction_date":"2022-07-07 00:00:00","upload_date":"2022-08-03 00:00:00","upload_first_byte":"0","upload_dot_number":"03504755","upload_search_indicator":"M","census_search_date":"2022-07-07 21:42:00","snet_input_date":"2022-07-06 00:00:00","source_office":"2TXS001","mcmis_add_date":"2022-07-07 21:42:00","insp_carrier_name":"ANDYY FREIGHT LLC","insp_carrier_street":"7522 NAVIDAD RD","insp_carrier_city":"HOUSTON","insp_carrier_state":"TX","insp_carrier_zip_code":"77083","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1001404","created_at":"2025-03-17T18:41:16.000000Z","updated_at":"2025-03-17T18:41:16.000000Z","inspection_violations":[{"id":1224904,"change_date":"2022-08-03 21:42:00","inspection_id":"76014868","insp_violation_id":"247498739","seq_no":"1","part_no":"393","part_no_section":"9(a)","insp_viol_unit":"1","insp_unit_id":"190122778","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:12:46.000000Z","updated_at":"2025-03-17T21:12:46.000000Z","normalized_code":"3939A"}],"inspection_per_units":[{"id":1247813,"change_date":"2022-08-03 21:42:00","inspection_id":"76014868","insp_unit_id":"190122778","insp_unit_type_id":"11","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"12","insp_unit_license":"R582938","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1FUYSXYB1WL909540","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:51.000000Z","updated_at":"2025-03-17T22:15:51.000000Z"},{"id":1247814,"change_date":"2022-08-03 21:42:00","inspection_id":"76014868","insp_unit_id":"190122779","insp_unit_type_id":"9","insp_unit_number":"2","insp_unit_make":"DORS","insp_unit_company":null,"insp_unit_license":"207B086","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"1DTP80Z25VG051401","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T22:15:51.000000Z","updated_at":"2025-03-17T22:15:51.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/3504755\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/3504755\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/3504755\/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\/3504755\/inspections","per_page":100,"prev_page_url":null,"to":15,"total":15}