{"current_page":1,"data":[{"id":9274773,"change_date":"2025-07-29 21:39:00","inspection_id":"85347777","dot_number":"4246535","report_state":"US","report_number":"1642001208","insp_date":"2025-07-26 00:00:00","insp_start_time":"0627","insp_end_time":"0729","registration_date":null,"region":"MD","ci_status_code":"C","location":null,"location_desc":"EL PASO TX","county_code_state":"TX","county_code":"141","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-07-29 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","viol_total":"3","oos_total":"1","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2058263","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":"04246535","upload_search_indicator":null,"census_search_date":"2025-07-29 21:39:00","snet_input_date":"2025-07-26 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-07-29 21:39:00","insp_carrier_name":"TOURS OF FRIENDLY LLC","insp_carrier_street":"5009 W 29TH ST","insp_carrier_city":"CICERO","insp_carrier_state":"IL","insp_carrier_zip_code":"60804-3525","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-08-01T10:42:04.000000Z","updated_at":"2025-08-04T10:00:31.000000Z","inspection_violations":[{"id":15033714,"change_date":"2025-07-29 21:39:00","inspection_id":"85347777","insp_violation_id":"267717231","seq_no":"1","part_no":"390","part_no_section":"21TE-LCMVINFO","insp_viol_unit":"1","insp_unit_id":"208132467","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-01T10:44:18.000000Z","updated_at":"2025-08-02T10:42:35.000000Z","normalized_code":"39021TELCMVINFO"},{"id":15033715,"change_date":"2025-07-29 21:39:00","inspection_id":"85347777","insp_violation_id":"267717232","seq_no":"2","part_no":"393","part_no_section":"45D-BAAL","insp_viol_unit":"1","insp_unit_id":"208132467","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-08-01T10:44:18.000000Z","updated_at":"2025-08-02T10:42:35.000000Z","normalized_code":"39345DBAAL"},{"id":15033716,"change_date":"2025-07-29 21:39:00","inspection_id":"85347777","insp_violation_id":"267717233","seq_no":"3","part_no":"387","part_no_section":"31A","insp_viol_unit":"1","insp_unit_id":"208132467","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-01T10:44:18.000000Z","updated_at":"2025-08-02T10:42:35.000000Z","normalized_code":"38731A"}],"inspection_per_units":[{"id":15268037,"change_date":"2025-07-29 21:39:00","inspection_id":"85347777","insp_unit_id":"208132467","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"MERCEDES B","insp_unit_company":"1412","insp_unit_license":"53RC4A","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"3MBFAJMB3PM075481","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-01T09:45:44.000000Z","updated_at":"2025-08-02T09:45:39.000000Z"}]},{"id":9214170,"change_date":"2025-07-22 21:42:00","inspection_id":"85283957","dot_number":"4246535","report_state":"US","report_number":"1629001362","insp_date":"2025-07-19 00:00:00","insp_start_time":"0630","insp_end_time":"0706","registration_date":null,"region":"MD","ci_status_code":"C","location":null,"location_desc":"EL PASO TX","county_code_state":"TX","county_code":"141","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-07-22 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"54000","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":"2026305","transaction_code":"A","transaction_date":"2025-07-22 00:00:00","upload_date":"2025-07-22 00:00:00","upload_first_byte":"0","upload_dot_number":"04246535","upload_search_indicator":null,"census_search_date":"2025-07-22 21:42:00","snet_input_date":"2025-07-19 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-07-22 21:42:00","insp_carrier_name":"TOURS OF FRIENDLY LLC","insp_carrier_street":"5009 W 29TH ST","insp_carrier_city":"CICERO","insp_carrier_state":"IL","insp_carrier_zip_code":"60804-3525","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-25T10:45:58.000000Z","updated_at":"2025-07-27T10:40:51.000000Z","inspection_violations":[{"id":14904120,"change_date":"2025-07-22 21:42:00","inspection_id":"85283957","insp_violation_id":"267569009","seq_no":"1","part_no":"395","part_no_section":"3A3II","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-07-25T10:47:36.000000Z","updated_at":"2025-07-26T10:42:36.000000Z","normalized_code":"3953A3II"},{"id":14904121,"change_date":"2025-07-22 21:42:00","inspection_id":"85283957","insp_violation_id":"267569010","seq_no":"2","part_no":"396","part_no_section":"5B-L","insp_viol_unit":"1","insp_unit_id":"208008825","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-25T10:47:36.000000Z","updated_at":"2025-07-26T10:42:36.000000Z","normalized_code":"3965BL"},{"id":14904122,"change_date":"2025-07-22 21:42:00","inspection_id":"85283957","insp_violation_id":"267569011","seq_no":"3","part_no":"393","part_no_section":"207F-SLAS","insp_viol_unit":"1","insp_unit_id":"208008825","insp_violation_category_id":"22","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-25T10:47:36.000000Z","updated_at":"2025-07-26T10:42:36.000000Z","normalized_code":"393207FSLAS"},{"id":14904123,"change_date":"2025-07-22 21:42:00","inspection_id":"85283957","insp_violation_id":"267569012","seq_no":"4","part_no":"393","part_no_section":"45D-B","insp_viol_unit":"1","insp_unit_id":"208008825","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-25T10:47:36.000000Z","updated_at":"2025-07-26T10:42:36.000000Z","normalized_code":"39345DB"},{"id":14904124,"change_date":"2025-07-22 21:42:00","inspection_id":"85283957","insp_violation_id":"267569013","seq_no":"5","part_no":"393","part_no_section":"95A1","insp_viol_unit":"1","insp_unit_id":"208008825","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-25T10:47:36.000000Z","updated_at":"2025-07-26T10:42:36.000000Z","normalized_code":"39395A1"},{"id":14904125,"change_date":"2025-07-22 21:42:00","inspection_id":"85283957","insp_violation_id":"267569014","seq_no":"6","part_no":"393","part_no_section":"62-BEMEO","insp_viol_unit":"1","insp_unit_id":"208008825","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-07-25T10:47:36.000000Z","updated_at":"2025-07-26T10:42:36.000000Z","normalized_code":"39362BEMEO"}],"inspection_per_units":[{"id":15153695,"change_date":"2025-07-22 21:42:00","inspection_id":"85283957","insp_unit_id":"208008825","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"MERCEDEZ B","insp_unit_company":"1412","insp_unit_license":"53RC4A","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"3MBFAJMB3PM075481","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-25T09:46:40.000000Z","updated_at":"2025-07-26T09:45:51.000000Z"}]},{"id":9201332,"change_date":"2025-07-21 21:40:00","inspection_id":"85270515","dot_number":"4246535","report_state":"US","report_number":"1035002012","insp_date":"2025-07-18 00:00:00","insp_start_time":"0704","insp_end_time":"0825","registration_date":null,"region":"MD","ci_status_code":"C","location":"USTX04","location_desc":"EL PASO TX","county_code_state":"TX","county_code":"141","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"TOURS R FRIENDLY","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-07-21 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"49000","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":"2021095","transaction_code":"A","transaction_date":"2025-07-21 00:00:00","upload_date":"2025-07-21 00:00:00","upload_first_byte":"0","upload_dot_number":"04246535","upload_search_indicator":null,"census_search_date":"2025-07-21 21:40:00","snet_input_date":"2025-07-18 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-07-21 21:40:00","insp_carrier_name":"TOURS OF FRIENDLY LLC","insp_carrier_street":"5009 W 29TH ST","insp_carrier_city":"CICERO","insp_carrier_state":"IL","insp_carrier_zip_code":"60804-3525","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-25T10:45:18.000000Z","updated_at":"2025-07-25T10:45:18.000000Z","inspection_violations":[{"id":14868374,"change_date":"2025-07-21 21:40:00","inspection_id":"85270515","insp_violation_id":"267529767","seq_no":"1","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"207977295","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-25T10:46:41.000000Z","updated_at":"2025-07-25T10:46:41.000000Z","normalized_code":"39360C"},{"id":14868375,"change_date":"2025-07-21 21:40:00","inspection_id":"85270515","insp_violation_id":"267529768","seq_no":"2","part_no":"396","part_no_section":"3A1-OAL","insp_viol_unit":"1","insp_unit_id":"207977295","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-25T10:46:41.000000Z","updated_at":"2025-07-25T10:46:41.000000Z","normalized_code":"3963A1OAL"},{"id":14868376,"change_date":"2025-07-21 21:40:00","inspection_id":"85270515","insp_violation_id":"267529769","seq_no":"3","part_no":"393","part_no_section":"205A-WRC","insp_viol_unit":"1","insp_unit_id":"207977295","insp_violation_category_id":"24","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-25T10:46:41.000000Z","updated_at":"2025-07-25T10:46:41.000000Z","normalized_code":"393205AWRC"}],"inspection_per_units":[{"id":15124081,"change_date":"2025-07-21 21:40:00","inspection_id":"85270515","insp_unit_id":"207977295","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"MERCEDES-B","insp_unit_company":"1408","insp_unit_license":"149RR3","insp_unit_license_state":"DG","insp_unit_vehicle_id_number":"3MBFAJMB3JM064861","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-24T09:45:30.000000Z","updated_at":"2025-07-25T09:45:33.000000Z"}]},{"id":9179596,"change_date":"2025-07-17 21:42:00","inspection_id":"85247684","dot_number":"4246535","report_state":"TX","report_number":"V251951188","insp_date":"2025-07-17 00:00:00","insp_start_time":"0622","insp_end_time":"0655","registration_date":null,"region":"CT","ci_status_code":"C","location":"6A202","location_desc":"IH35 NB DEVINE SCALE","county_code_state":"TX","county_code":"325","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"TOURS OF FRIENDLY LLC","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-07-17 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"54564","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":"9641564","transaction_code":"A","transaction_date":"2025-07-17 00:00:00","upload_date":"2025-07-17 00:00:00","upload_first_byte":"0","upload_dot_number":"04246535","upload_search_indicator":"M","census_search_date":"2025-07-17 21:42:00","snet_input_date":"2025-07-17 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-07-17 21:42:00","insp_carrier_name":"TOURS OF FRIENDLY LLC","insp_carrier_street":"5009 W 29TH ST","insp_carrier_city":"CICERO","insp_carrier_state":"IL","insp_carrier_zip_code":"60804-3525","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1093743","created_at":"2025-07-21T10:43:21.000000Z","updated_at":"2025-07-21T10:43:21.000000Z","inspection_violations":[{"id":14826431,"change_date":"2025-07-17 21:42:00","inspection_id":"85247684","insp_violation_id":"267482695","seq_no":"1","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"207935546","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-21T10:45:51.000000Z","updated_at":"2025-07-21T10:45:51.000000Z","normalized_code":"3922RG"},{"id":14826432,"change_date":"2025-07-17 21:42:00","inspection_id":"85247684","insp_violation_id":"267482696","seq_no":"2","part_no":"392","part_no_section":"2W","insp_viol_unit":"1","insp_unit_id":"207935546","insp_violation_category_id":"47","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-21T10:45:51.000000Z","updated_at":"2025-07-21T10:45:51.000000Z","normalized_code":"3922W"}],"inspection_per_units":[{"id":15084970,"change_date":"2025-07-17 21:42:00","inspection_id":"85247684","insp_unit_id":"207935546","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"1410","insp_unit_license":"55RC4A","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"3CET2P625P5208543","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-20T09:46:33.000000Z","updated_at":"2025-07-21T09:46:18.000000Z"}]},{"id":9235889,"change_date":"2025-07-31 21:41:00","inspection_id":"85297525","dot_number":"4246535","report_state":"TX","report_number":"V251952471","insp_date":"2025-07-15 00:00:00","insp_start_time":"0646","insp_end_time":"0742","registration_date":null,"region":"CT","ci_status_code":"C","location":null,"location_desc":"802 S LBJ DR","county_code_state":"TX","county_code":"209","insp_level_id":"2","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"TERMINAL","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-07-23 21:42:00","post_acc_ind":"N","gross_comb_veh_wt":"68000","viol_total":"8","oos_total":"2","driver_viol_total":"3","driver_oos_total":"1","vehicle_viol_total":"5","vehicle_oos_total":"1","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"9645572","transaction_code":"C","transaction_date":"2025-07-31 00:00:00","upload_date":"2025-07-31 00:00:00","upload_first_byte":"0","upload_dot_number":"04246535","upload_search_indicator":"M","census_search_date":"2025-07-23 21:42:00","snet_input_date":"2025-07-15 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-07-23 21:42:00","insp_carrier_name":"TOURS OF FRIENDLY LLC","insp_carrier_street":"5009 W 29TH ST","insp_carrier_city":"CICERO","insp_carrier_state":"IL","insp_carrier_zip_code":"60804-3525","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1093743","created_at":"2025-07-27T10:41:53.000000Z","updated_at":"2025-08-04T10:01:31.000000Z","inspection_violations":[{"id":15079541,"change_date":"2025-07-31 21:41:00","inspection_id":"85297525","insp_violation_id":"267775394","seq_no":"1","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":"2025-08-03T10:45:01.000000Z","updated_at":"2025-08-04T10:45:17.000000Z","normalized_code":"39111B2Q"},{"id":15079542,"change_date":"2025-07-31 21:41:00","inspection_id":"85297525","insp_violation_id":"267775395","seq_no":"2","part_no":"393","part_no_section":"11","insp_viol_unit":"1","insp_unit_id":"208182718","insp_violation_category_id":"20","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-03T10:45:01.000000Z","updated_at":"2025-08-04T10:45:17.000000Z","normalized_code":"39311"},{"id":15079543,"change_date":"2025-07-31 21:41:00","inspection_id":"85297525","insp_violation_id":"267775396","seq_no":"3","part_no":"393","part_no_section":"60D","insp_viol_unit":"1","insp_unit_id":"208182718","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-03T10:45:01.000000Z","updated_at":"2025-08-04T10:45:17.000000Z","normalized_code":"39360D"},{"id":15079544,"change_date":"2025-07-31 21:41:00","inspection_id":"85297525","insp_violation_id":"267775397","seq_no":"4","part_no":"393","part_no_section":"62A","insp_viol_unit":"1","insp_unit_id":"208182718","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-08-03T10:45:01.000000Z","updated_at":"2025-08-04T10:45:17.000000Z","normalized_code":"39362A"},{"id":15079545,"change_date":"2025-07-31 21:41:00","inspection_id":"85297525","insp_violation_id":"267775398","seq_no":"5","part_no":"393","part_no_section":"78","insp_viol_unit":"1","insp_unit_id":"208182718","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-03T10:45:01.000000Z","updated_at":"2025-08-04T10:45:17.000000Z","normalized_code":"39378"},{"id":15079546,"change_date":"2025-07-31 21:41:00","inspection_id":"85297525","insp_violation_id":"267775399","seq_no":"6","part_no":"395","part_no_section":"15I9","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-08-03T10:45:01.000000Z","updated_at":"2025-08-04T10:45:17.000000Z","normalized_code":"39515I9"},{"id":15079547,"change_date":"2025-07-31 21:41:00","inspection_id":"85297525","insp_violation_id":"267775400","seq_no":"7","part_no":"396","part_no_section":"17C","insp_viol_unit":"1","insp_unit_id":"208182718","insp_violation_category_id":"29","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-03T10:45:01.000000Z","updated_at":"2025-08-04T10:45:17.000000Z","normalized_code":"39617C"},{"id":15079548,"change_date":"2025-07-31 21:41:00","inspection_id":"85297525","insp_violation_id":"267775401","seq_no":"11","part_no":"392","part_no_section":"2W","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-08-03T10:45:01.000000Z","updated_at":"2025-08-04T10:45:17.000000Z","normalized_code":"3922W"}],"inspection_per_units":[{"id":15309457,"change_date":"2025-07-31 21:41:00","inspection_id":"85297525","insp_unit_id":"208182718","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"OTHR","insp_unit_company":"7530","insp_unit_license":"91Y953V","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"WMARR6ZZ3CC017530","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-03T09:46:23.000000Z","updated_at":"2025-08-04T09:45:52.000000Z"}]},{"id":9120857,"change_date":"2025-07-11 21:39:00","inspection_id":"85186060","dot_number":"4246535","report_state":"US","report_number":"1108000137","insp_date":"2025-07-11 00:00:00","insp_start_time":"0615","insp_end_time":"0647","registration_date":null,"region":"MD","ci_status_code":"C","location":null,"location_desc":"EL PASO TX","county_code_state":"TX","county_code":"141","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"R","shipper_name":"TOURS OF FRIENDLY","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-07-11 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"70546","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":"1978872","transaction_code":"A","transaction_date":"2025-07-11 00:00:00","upload_date":"2025-07-11 00:00:00","upload_first_byte":"0","upload_dot_number":"04246535","upload_search_indicator":null,"census_search_date":"2025-07-11 21:39:00","snet_input_date":"2025-07-11 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-07-11 21:39:00","insp_carrier_name":"TOURS OF FRIENDLY LLC","insp_carrier_street":"5009 W 29TH ST","insp_carrier_city":"CICERO","insp_carrier_state":"IL","insp_carrier_zip_code":"60804-3525","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-14T10:47:01.000000Z","updated_at":"2025-07-16T10:44:33.000000Z","inspection_violations":[{"id":14705230,"change_date":"2025-07-11 21:39:00","inspection_id":"85186060","insp_violation_id":"267342349","seq_no":"1","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"207816323","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-14T10:48:43.000000Z","updated_at":"2025-07-16T10:45:47.000000Z","normalized_code":"39360C"}],"inspection_per_units":[{"id":14975159,"change_date":"2025-07-11 21:39:00","inspection_id":"85186060","insp_unit_id":"207816323","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"MERCEDES","insp_unit_company":"1407","insp_unit_license":"150RR3","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"3MBFAJMB5JM064862","insp_unit_decal":"Y","insp_unit_decal_number":"35541153","created_at":"2025-07-14T09:46:05.000000Z","updated_at":"2025-07-15T09:45:30.000000Z"}]},{"id":9120761,"change_date":"2025-07-11 21:39:00","inspection_id":"85185960","dot_number":"4246535","report_state":"US","report_number":"1701001373","insp_date":"2025-07-10 00:00:00","insp_start_time":"0517","insp_end_time":"0541","registration_date":null,"region":"MD","ci_status_code":"C","location":"USTX04","location_desc":"EL PASO TX","county_code_state":"TX","county_code":"141","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"TOURS OF FRIENDLY LLC","shipping_paper_number":"NON-LADEN","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-07-11 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"54500","viol_total":"2","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":"1978700","transaction_code":"A","transaction_date":"2025-07-11 00:00:00","upload_date":"2025-07-11 00:00:00","upload_first_byte":"0","upload_dot_number":"04246535","upload_search_indicator":null,"census_search_date":"2025-07-11 21:39:00","snet_input_date":"2025-07-10 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-07-11 21:39:00","insp_carrier_name":"TOURS OF FRIENDLY LLC","insp_carrier_street":"5009 W 29TH ST","insp_carrier_city":"CICERO","insp_carrier_state":"IL","insp_carrier_zip_code":"60804-3525","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-14T10:47:01.000000Z","updated_at":"2025-07-16T10:44:33.000000Z","inspection_violations":[{"id":14705034,"change_date":"2025-07-11 21:39:00","inspection_id":"85185960","insp_violation_id":"267342115","seq_no":"1","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"207816142","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-14T10:48:43.000000Z","updated_at":"2025-07-16T10:45:47.000000Z","normalized_code":"39360C"},{"id":14705035,"change_date":"2025-07-11 21:39:00","inspection_id":"85185960","insp_violation_id":"267342116","seq_no":"2","part_no":"393","part_no_section":"75C-TAOTD-LT2\/32","insp_viol_unit":"1","insp_unit_id":"207816142","insp_violation_category_id":"23","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-14T10:48:43.000000Z","updated_at":"2025-07-16T10:45:47.000000Z","normalized_code":"39375CTAOTDLT2\/32"}],"inspection_per_units":[{"id":14975000,"change_date":"2025-07-11 21:39:00","inspection_id":"85185960","insp_unit_id":"207816142","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"MERCEDES B","insp_unit_company":"1405","insp_unit_license":"129RR3","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"3MBFAJMB4HM060277","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-14T09:46:05.000000Z","updated_at":"2025-07-15T09:45:29.000000Z"}]},{"id":9105667,"change_date":"2025-07-09 21:43:00","inspection_id":"85169945","dot_number":"4246535","report_state":"TX","report_number":"V251931962","insp_date":"2025-07-08 00:00:00","insp_start_time":"0942","insp_end_time":"1020","registration_date":null,"region":"CT","ci_status_code":"C","location":"6A201","location_desc":"IH35 SB DEVINE SCALE","county_code_state":"TX","county_code":"325","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"TOURS OF FRENDLY LLC","shipping_paper_number":"7-8-25","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-07-09 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"27500","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":"9631635","transaction_code":"A","transaction_date":"2025-07-09 00:00:00","upload_date":"2025-07-09 00:00:00","upload_first_byte":"0","upload_dot_number":"04246535","upload_search_indicator":"M","census_search_date":"2025-07-09 21:43:00","snet_input_date":"2025-07-08 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-07-09 21:43:00","insp_carrier_name":"TOURS OF FRIENDLY LLC","insp_carrier_street":"5009 W 29TH ST","insp_carrier_city":"CICERO","insp_carrier_state":"IL","insp_carrier_zip_code":"60804-3525","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1093743","created_at":"2025-07-12T10:45:31.000000Z","updated_at":"2025-07-14T10:46:28.000000Z","inspection_violations":[{"id":14673723,"change_date":"2025-07-09 21:43:00","inspection_id":"85169945","insp_violation_id":"267307709","seq_no":"1","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"207786660","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-13T10:49:19.000000Z","updated_at":"2025-07-13T10:49:19.000000Z","normalized_code":"3922RG"},{"id":14673724,"change_date":"2025-07-09 21:43:00","inspection_id":"85169945","insp_violation_id":"267307710","seq_no":"2","part_no":"392","part_no_section":"2W","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-07-13T10:49:19.000000Z","updated_at":"2025-07-13T10:49:19.000000Z","normalized_code":"3922W"}],"inspection_per_units":[{"id":14947285,"change_date":"2025-07-09 21:43:00","inspection_id":"85169945","insp_unit_id":"207786660","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"OTHR","insp_unit_company":"7530","insp_unit_license":"62RE6G","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"WMARR6ZZ3CC017530","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-12T09:45:57.000000Z","updated_at":"2025-07-13T09:46:38.000000Z"}]},{"id":9071875,"change_date":"2025-07-07 21:39:00","inspection_id":"85134393","dot_number":"4246535","report_state":"US","report_number":"1526001130","insp_date":"2025-07-04 00:00:00","insp_start_time":"0342","insp_end_time":"0420","registration_date":null,"region":"MD","ci_status_code":"C","location":"USTX04","location_desc":"EL PASO TX","county_code_state":"TX","county_code":"141","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"GUADIANA EXPRESS","shipping_paper_number":"NON-LADEN","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-07-07 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"40400","viol_total":"3","oos_total":"2","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1958811","transaction_code":"A","transaction_date":"2025-07-07 00:00:00","upload_date":"2025-07-07 00:00:00","upload_first_byte":"0","upload_dot_number":"04246535","upload_search_indicator":null,"census_search_date":"2025-07-07 21:39:00","snet_input_date":"2025-07-04 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-07-07 21:39:00","insp_carrier_name":"TOURS OF FRIENDLY LLC","insp_carrier_street":"5009 W 29TH ST","insp_carrier_city":"CICERO","insp_carrier_state":"IL","insp_carrier_zip_code":"60804-3525","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-11T10:44:28.000000Z","updated_at":"2025-07-11T10:44:28.000000Z","inspection_violations":[{"id":14605493,"change_date":"2025-07-07 21:39:00","inspection_id":"85134393","insp_violation_id":"267225127","seq_no":"1","part_no":"393","part_no_section":"45A-BHTIJ","insp_viol_unit":"1","insp_unit_id":"207718587","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-07-10T10:42:26.000000Z","updated_at":"2025-07-11T10:45:18.000000Z","normalized_code":"39345ABHTIJ"},{"id":14605494,"change_date":"2025-07-07 21:39:00","inspection_id":"85134393","insp_violation_id":"267225128","seq_no":"2","part_no":"393","part_no_section":"209E-SPSLA","insp_viol_unit":"1","insp_unit_id":"207718587","insp_violation_category_id":"21","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-10T10:42:26.000000Z","updated_at":"2025-07-11T10:45:18.000000Z","normalized_code":"393209ESPSLA"},{"id":14605495,"change_date":"2025-07-07 21:39:00","inspection_id":"85134393","insp_violation_id":"267225129","seq_no":"3","part_no":"393","part_no_section":"45D-BAAL","insp_viol_unit":"1","insp_unit_id":"207718587","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"1","citation_number":null,"created_at":"2025-07-10T10:42:26.000000Z","updated_at":"2025-07-11T10:45:18.000000Z","normalized_code":"39345DBAAL"}],"inspection_per_units":[{"id":14886739,"change_date":"2025-07-07 21:39:00","inspection_id":"85134393","insp_unit_id":"207718587","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"MOTORCOACH","insp_unit_company":"1408","insp_unit_license":"56RB7B","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"3MBFAJMB3JM064861","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-10T09:45:19.000000Z","updated_at":"2025-07-11T09:45:21.000000Z"}]},{"id":9061958,"change_date":"2025-07-04 21:33:00","inspection_id":"85123742","dot_number":"4246535","report_state":"US","report_number":"1626001550","insp_date":"2025-07-03 00:00:00","insp_start_time":"0633","insp_end_time":"0738","registration_date":null,"region":"MD","ci_status_code":"C","location":"USTX04","location_desc":"EL PASO TX","county_code_state":"TX","county_code":"141","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"TOURS OF FRIENDLY LLC","shipping_paper_number":"NON-LADEN","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-07-04 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"70546","viol_total":"3","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":"1949084","transaction_code":"A","transaction_date":"2025-07-04 00:00:00","upload_date":"2025-07-04 00:00:00","upload_first_byte":"0","upload_dot_number":"04246535","upload_search_indicator":null,"census_search_date":"2025-07-04 21:33:00","snet_input_date":"2025-07-03 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-07-04 21:33:00","insp_carrier_name":"TOURS OF FRIENDLY LLC","insp_carrier_street":"5009 W 29TH ST","insp_carrier_city":"CICERO","insp_carrier_state":"IL","insp_carrier_zip_code":"60804-3525","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-07T10:07:41.000000Z","updated_at":"2025-07-09T10:00:13.000000Z","inspection_violations":[{"id":14585291,"change_date":"2025-07-04 21:33:00","inspection_id":"85123742","insp_violation_id":"267203978","seq_no":"1","part_no":"393","part_no_section":"207A-STCB","insp_viol_unit":"1","insp_unit_id":"207700290","insp_violation_category_id":"22","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-07-07T10:16:00.000000Z","updated_at":"2025-07-08T10:15:21.000000Z","normalized_code":"393207ASTCB"},{"id":14585292,"change_date":"2025-07-04 21:33:00","inspection_id":"85123742","insp_violation_id":"267203979","seq_no":"2","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"207700290","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-07T10:16:00.000000Z","updated_at":"2025-07-08T10:15:21.000000Z","normalized_code":"39360C"},{"id":14585293,"change_date":"2025-07-04 21:33:00","inspection_id":"85123742","insp_violation_id":"267203980","seq_no":"3","part_no":"393","part_no_section":"95F","insp_viol_unit":"1","insp_unit_id":"207700290","insp_violation_category_id":"28","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-07T10:16:00.000000Z","updated_at":"2025-07-08T10:15:21.000000Z","normalized_code":"39395F"}],"inspection_per_units":[{"id":14868761,"change_date":"2025-07-04 21:33:00","inspection_id":"85123742","insp_unit_id":"207700290","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"MERCEDES B","insp_unit_company":"1407","insp_unit_license":"150RR3","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"3MBFAJMB5JM064862","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-07T09:45:40.000000Z","updated_at":"2025-07-08T09:45:15.000000Z"}]},{"id":9047860,"change_date":"2025-07-02 21:40:00","inspection_id":"85108965","dot_number":"4246535","report_state":"US","report_number":"1626001541","insp_date":"2025-07-01 00:00:00","insp_start_time":"0600","insp_end_time":"0643","registration_date":null,"region":"MD","ci_status_code":"C","location":"USTX04","location_desc":"EL PASO TX","county_code_state":"TX","county_code":"141","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"TOURS OF FRIENDLY LLC","shipping_paper_number":"NON-LADEN","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-07-02 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"54500","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":"1941669","transaction_code":"A","transaction_date":"2025-07-02 00:00:00","upload_date":"2025-07-02 00:00:00","upload_first_byte":"0","upload_dot_number":"04246535","upload_search_indicator":null,"census_search_date":"2025-07-02 21:40:00","snet_input_date":"2025-07-01 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-07-02 21:40:00","insp_carrier_name":"TOURS OF FRIENDLY LLC","insp_carrier_street":"5009 W 29TH ST","insp_carrier_city":"CICERO","insp_carrier_state":"IL","insp_carrier_zip_code":"60804-3525","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-07T10:07:20.000000Z","updated_at":"2025-07-07T10:07:20.000000Z","inspection_violations":[{"id":14555926,"change_date":"2025-07-02 21:40:00","inspection_id":"85108965","insp_violation_id":"267167435","seq_no":"1","part_no":"396","part_no_section":"3A1-ALBV","insp_viol_unit":"1","insp_unit_id":"207672129","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-05T10:16:33.000000Z","updated_at":"2025-07-06T10:17:16.000000Z","normalized_code":"3963A1ALBV"},{"id":14555927,"change_date":"2025-07-02 21:40:00","inspection_id":"85108965","insp_violation_id":"267167436","seq_no":"2","part_no":"393","part_no_section":"201A-FRCLS","insp_viol_unit":"1","insp_unit_id":"207672129","insp_violation_category_id":"19","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-05T10:16:33.000000Z","updated_at":"2025-07-06T10:17:16.000000Z","normalized_code":"393201AFRCLS"},{"id":14555928,"change_date":"2025-07-02 21:40:00","inspection_id":"85108965","insp_violation_id":"267167437","seq_no":"3","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"207672129","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-07-05T10:16:33.000000Z","updated_at":"2025-07-06T10:17:16.000000Z","normalized_code":"39360C"}],"inspection_per_units":[{"id":14844149,"change_date":"2025-07-02 21:40:00","inspection_id":"85108965","insp_unit_id":"207672129","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"MERCEDES B","insp_unit_company":"1405","insp_unit_license":"129RR3","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"3MBFAJMB4HM060277","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-05T09:46:07.000000Z","updated_at":"2025-07-06T09:45:29.000000Z"}]},{"id":9009350,"change_date":"2025-06-27 21:38:00","inspection_id":"85068506","dot_number":"4246535","report_state":"US","report_number":"1593001908","insp_date":"2025-06-26 00:00:00","insp_start_time":"0552","insp_end_time":"0639","registration_date":null,"region":"MD","ci_status_code":"C","location":"USTX04","location_desc":"EL PASO TX","county_code_state":"TX","county_code":"141","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"TOURS OF FRIENDLY LLC.","shipping_paper_number":"NON-LADEN","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-27 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"49999","viol_total":"5","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":"1921660","transaction_code":"A","transaction_date":"2025-06-27 00:00:00","upload_date":"2025-06-27 00:00:00","upload_first_byte":"0","upload_dot_number":"04246535","upload_search_indicator":null,"census_search_date":"2025-06-27 21:38:00","snet_input_date":"2025-06-26 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-06-27 21:38:00","insp_carrier_name":"TOURS OF FRIENDLY LLC","insp_carrier_street":"5009 W 29TH ST","insp_carrier_city":"CICERO","insp_carrier_state":"IL","insp_carrier_zip_code":"60804-3525","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-30T10:01:18.000000Z","updated_at":"2025-07-03T10:00:15.000000Z","inspection_violations":[{"id":14482196,"change_date":"2025-06-27 21:38:00","inspection_id":"85068506","insp_violation_id":"267087369","seq_no":"1","part_no":"393","part_no_section":"78A-WS","insp_viol_unit":"1","insp_unit_id":"207599309","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-30T10:17:35.000000Z","updated_at":"2025-07-02T10:15:26.000000Z","normalized_code":"39378AWS"},{"id":14482197,"change_date":"2025-06-27 21:38:00","inspection_id":"85068506","insp_violation_id":"267087370","seq_no":"2","part_no":"393","part_no_section":"55C1","insp_viol_unit":"1","insp_unit_id":"207599309","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-30T10:17:35.000000Z","updated_at":"2025-07-02T10:15:26.000000Z","normalized_code":"39355C1"},{"id":14482198,"change_date":"2025-06-27 21:38:00","inspection_id":"85068506","insp_violation_id":"267087371","seq_no":"3","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"207599309","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-30T10:17:35.000000Z","updated_at":"2025-07-02T10:15:27.000000Z","normalized_code":"39360C"},{"id":14482199,"change_date":"2025-06-27 21:38:00","inspection_id":"85068506","insp_violation_id":"267087372","seq_no":"4","part_no":"396","part_no_section":"5B-L","insp_viol_unit":"1","insp_unit_id":"207599309","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-30T10:17:35.000000Z","updated_at":"2025-07-02T10:15:27.000000Z","normalized_code":"3965BL"},{"id":14482200,"change_date":"2025-06-27 21:38:00","inspection_id":"85068506","insp_violation_id":"267087373","seq_no":"5","part_no":"396","part_no_section":"3A1-ALBV","insp_viol_unit":"1","insp_unit_id":"207599309","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-30T10:17:35.000000Z","updated_at":"2025-07-02T10:15:27.000000Z","normalized_code":"3963A1ALBV"}],"inspection_per_units":[{"id":14775257,"change_date":"2025-06-27 21:38:00","inspection_id":"85068506","insp_unit_id":"207599309","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"UNKNOWN","insp_unit_company":"1405","insp_unit_license":"129RR3","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"3MBFAJMB4HM060277","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-07-01T09:47:33.000000Z","updated_at":"2025-07-01T09:49:15.000000Z"}]},{"id":8978684,"change_date":"2025-06-25 21:39:00","inspection_id":"85036462","dot_number":"4246535","report_state":"US","report_number":"1593001896","insp_date":"2025-06-24 00:00:00","insp_start_time":"0505","insp_end_time":"0557","registration_date":null,"region":"MD","ci_status_code":"C","location":"USTX04","location_desc":"EL PASO TX","county_code_state":"TX","county_code":"141","insp_level_id":"1","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"TOURS OF FRIENDLY LLC.","shipping_paper_number":"NON-LADEN","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-25 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"45000","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":"1911925","transaction_code":"A","transaction_date":"2025-06-25 00:00:00","upload_date":"2025-06-25 00:00:00","upload_first_byte":"0","upload_dot_number":"04246535","upload_search_indicator":null,"census_search_date":"2025-06-25 21:39:00","snet_input_date":"2025-06-24 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-06-25 21:39:00","insp_carrier_name":"TOURS OF FRIENDLY LLC","insp_carrier_street":"5009 W 29TH ST","insp_carrier_city":"CICERO","insp_carrier_state":"IL","insp_carrier_zip_code":"60804-3525","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-06-28T10:01:01.000000Z","updated_at":"2025-06-30T10:00:19.000000Z","inspection_violations":[{"id":14432012,"change_date":"2025-06-25 21:39:00","inspection_id":"85036462","insp_violation_id":"267030546","seq_no":"1","part_no":"396","part_no_section":"3A1-ALATR","insp_viol_unit":"1","insp_unit_id":"207541758","insp_violation_category_id":"16","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-28T10:16:51.000000Z","updated_at":"2025-06-29T10:15:32.000000Z","normalized_code":"3963A1ALATR"},{"id":14432013,"change_date":"2025-06-25 21:39:00","inspection_id":"85036462","insp_violation_id":"267030547","seq_no":"2","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"207541758","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-28T10:16:51.000000Z","updated_at":"2025-06-29T10:15:32.000000Z","normalized_code":"39360C"},{"id":14432014,"change_date":"2025-06-25 21:39:00","inspection_id":"85036462","insp_violation_id":"267030548","seq_no":"3","part_no":"393","part_no_section":"78A-WS","insp_viol_unit":"1","insp_unit_id":"207541758","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-28T10:16:51.000000Z","updated_at":"2025-06-29T10:15:32.000000Z","normalized_code":"39378AWS"}],"inspection_per_units":[{"id":14721764,"change_date":"2025-06-25 21:39:00","inspection_id":"85036462","insp_unit_id":"207541758","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"UNKNOWN","insp_unit_company":"1408","insp_unit_license":"149RR3","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"3MBFAJMB3JM064861","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-28T09:46:11.000000Z","updated_at":"2025-06-29T09:45:29.000000Z"}]},{"id":8838615,"change_date":"2025-06-10 21:41:00","inspection_id":"84887497","dot_number":"4246535","report_state":"TX","report_number":"V251899045","insp_date":"2025-06-05 00:00:00","insp_start_time":"1428","insp_end_time":"1448","registration_date":null,"region":"CT","ci_status_code":"C","location":"6A201","location_desc":"IH35 SB DEVINE SCALE","county_code_state":"TX","county_code":"325","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"TOURS OF FRIENDLY LLC","shipping_paper_number":"NONE","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"Y","pen_cen_match":null,"final_status_date":"2025-06-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"54945","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":"9601720","transaction_code":"C","transaction_date":"2025-06-10 00:00:00","upload_date":"2025-06-10 00:00:00","upload_first_byte":"0","upload_dot_number":"04246535","upload_search_indicator":"M","census_search_date":"2025-06-06 21:40:00","snet_input_date":"2025-06-05 00:00:00","source_office":"2TXS001","mcmis_add_date":"2025-06-06 21:40:00","insp_carrier_name":"TOURS OF FRIENDLY LLC","insp_carrier_street":"5009 W 29TH ST","insp_carrier_city":"CICERO","insp_carrier_state":"IL","insp_carrier_zip_code":"60804-3525","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":"1093743","created_at":"2025-06-09T10:01:20.000000Z","updated_at":"2025-06-14T10:00:47.000000Z","inspection_violations":[{"id":14197525,"change_date":"2025-06-10 21:41:00","inspection_id":"84887497","insp_violation_id":"266766492","seq_no":"1","part_no":"390","part_no_section":"21(a)","insp_viol_unit":"1","insp_unit_id":"207317041","insp_violation_category_id":"30","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-13T10:16:53.000000Z","updated_at":"2025-06-14T10:15:58.000000Z","normalized_code":"39021A"},{"id":14197526,"change_date":"2025-06-10 21:41:00","inspection_id":"84887497","insp_violation_id":"266766493","seq_no":"2","part_no":"392","part_no_section":"2RG","insp_viol_unit":"1","insp_unit_id":"207317041","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-06-13T10:16:53.000000Z","updated_at":"2025-06-14T10:15:58.000000Z","normalized_code":"3922RG"},{"id":14197527,"change_date":"2025-06-10 21:41:00","inspection_id":"84887497","insp_violation_id":"266766494","seq_no":"3","part_no":"392","part_no_section":"2W","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-13T10:16:53.000000Z","updated_at":"2025-06-14T10:15:58.000000Z","normalized_code":"3922W"},{"id":14197528,"change_date":"2025-06-10 21:41:00","inspection_id":"84887497","insp_violation_id":"266766495","seq_no":"4","part_no":"392","part_no_section":"2W","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-13T10:16:53.000000Z","updated_at":"2025-06-14T10:15:58.000000Z","normalized_code":"3922W"}],"inspection_per_units":[{"id":14515478,"change_date":"2025-06-10 21:41:00","inspection_id":"84887497","insp_unit_id":"207317041","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"VOLV","insp_unit_company":"1416","insp_unit_license":"85RC4A","insp_unit_license_state":"MX","insp_unit_vehicle_id_number":"3CET2P620S5216221","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-06-13T09:45:45.000000Z","updated_at":"2025-06-14T09:45:49.000000Z"}]},{"id":7881879,"change_date":"2025-02-17 21:35:00","inspection_id":"83879907","dot_number":"4246535","report_state":"IL","report_number":"0097001336","insp_date":"2025-02-10 00:00:00","insp_start_time":"0913","insp_end_time":"1018","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"CHICAGO IL","county_code_state":"IL","county_code":"031","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-02-17 21:35:00","post_acc_ind":"N","gross_comb_veh_wt":"50000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1368153","transaction_code":"A","transaction_date":"2025-02-17 00:00:00","upload_date":"2025-02-17 00:00:00","upload_first_byte":"0","upload_dot_number":"04246535","upload_search_indicator":null,"census_search_date":"2025-02-17 21:35:00","snet_input_date":"2025-02-10 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-02-17 21:35:00","insp_carrier_name":"TOURS OF FRIENDLY LLC","insp_carrier_street":"5009 W 29TH ST","insp_carrier_city":"CICERO","insp_carrier_state":"IL","insp_carrier_zip_code":"60804-3525","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:01:56.000000Z","updated_at":"2025-03-17T21:01:56.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12722027,"change_date":"2025-02-17 21:35:00","inspection_id":"83879907","insp_unit_id":"205347482","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"MOTORCOACH","insp_unit_company":null,"insp_unit_license":"K128898","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2M93JMPA77W063904","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:55:33.000000Z","updated_at":"2025-03-17T23:55:33.000000Z"}]},{"id":7882464,"change_date":"2025-02-17 21:35:00","inspection_id":"83880525","dot_number":"4246535","report_state":"IL","report_number":"0092001916","insp_date":"2025-02-10 00:00:00","insp_start_time":"0825","insp_end_time":"0955","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"CHICAGO IL","county_code_state":"IL","county_code":"031","insp_level_id":"1","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-02-17 21:35:00","post_acc_ind":"N","gross_comb_veh_wt":"59524","viol_total":"4","oos_total":"3","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"3","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1368894","transaction_code":"A","transaction_date":"2025-02-17 00:00:00","upload_date":"2025-02-17 00:00:00","upload_first_byte":"0","upload_dot_number":"04246535","upload_search_indicator":null,"census_search_date":"2025-02-17 21:35:00","snet_input_date":"2025-02-10 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-02-17 21:35:00","insp_carrier_name":"TOURS OF FRIENDLY LLC","insp_carrier_street":"5009 W 29TH ST","insp_carrier_city":"CICERO","insp_carrier_state":"IL","insp_carrier_zip_code":"60804-3525","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:01:57.000000Z","updated_at":"2025-03-17T21:01:57.000000Z","inspection_violations":[{"id":12319200,"change_date":"2025-02-17 21:35:00","inspection_id":"83880525","insp_violation_id":"264544135","seq_no":"1","part_no":"393","part_no_section":"91-BASIW","insp_viol_unit":"1","insp_unit_id":"205348483","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:06:06.000000Z","updated_at":"2025-03-17T22:06:06.000000Z","normalized_code":"39391BASIW"},{"id":12319201,"change_date":"2025-02-17 21:35:00","inspection_id":"83880525","insp_violation_id":"264544136","seq_no":"2","part_no":"393","part_no_section":"62-BEI","insp_viol_unit":"1","insp_unit_id":"205348483","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:06:06.000000Z","updated_at":"2025-03-17T22:06:06.000000Z","normalized_code":"39362BEI"},{"id":12319202,"change_date":"2025-02-17 21:35:00","inspection_id":"83880525","insp_violation_id":"264544137","seq_no":"3","part_no":"393","part_no_section":"60C","insp_viol_unit":"1","insp_unit_id":"205348483","insp_violation_category_id":"26","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:06:06.000000Z","updated_at":"2025-03-17T22:06:06.000000Z","normalized_code":"39360C"},{"id":12319203,"change_date":"2025-02-17 21:35:00","inspection_id":"83880525","insp_violation_id":"264544138","seq_no":"4","part_no":"393","part_no_section":"62-BENM","insp_viol_unit":"1","insp_unit_id":"205348483","insp_violation_category_id":"30","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:06:06.000000Z","updated_at":"2025-03-17T22:06:06.000000Z","normalized_code":"39362BENM"}],"inspection_per_units":[{"id":12722955,"change_date":"2025-02-17 21:35:00","inspection_id":"83880525","insp_unit_id":"205348483","insp_unit_type_id":"5","insp_unit_number":"1","insp_unit_make":"MAN","insp_unit_company":null,"insp_unit_license":"62RE6G","insp_unit_license_state":"DG","insp_unit_vehicle_id_number":"WMARR6ZZ3CC017530","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:55:33.000000Z","updated_at":"2025-03-17T23:55:33.000000Z"}]},{"id":7832636,"change_date":"2025-02-10 21:40:00","inspection_id":"83828292","dot_number":"4246535","report_state":"IL","report_number":"4249040298","insp_date":"2025-02-08 00:00:00","insp_start_time":"2320","insp_end_time":"0049","registration_date":null,"region":"CT","ci_status_code":"C","location":"999","location_desc":"INTERSTATE 57","county_code_state":"IL","county_code":"053","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"TOURS OF FRIENDLY LLC","shipping_paper_number":"0","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"Y","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-02-10 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"50000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2384428","transaction_code":"A","transaction_date":"2025-02-08 00:00:00","upload_date":"2025-02-10 00:00:00","upload_first_byte":"0","upload_dot_number":"04246535","upload_search_indicator":null,"census_search_date":"2025-02-10 21:40:00","snet_input_date":"2025-02-08 00:00:00","source_office":"3ILS001","mcmis_add_date":"2025-02-10 21:40:00","insp_carrier_name":"TOURS OF FRIENDLY LLC","insp_carrier_street":"5009 W 29TH ST","insp_carrier_city":"CICERO","insp_carrier_state":"IL","insp_carrier_zip_code":"608043525","insp_colonia":null,"docket_number":"167409","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:00:47.000000Z","updated_at":"2025-03-17T21:00:47.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12641116,"change_date":"2025-02-10 21:40:00","inspection_id":"83828292","insp_unit_id":"205251558","insp_unit_type_id":"1","insp_unit_number":"1","insp_unit_make":"MCIN","insp_unit_company":"3904","insp_unit_license":"K128898","insp_unit_license_state":"TX","insp_unit_vehicle_id_number":"2M93JMPA77W063904","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:54:39.000000Z","updated_at":"2025-03-17T23:54:39.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/4246535\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/4246535\/inspections?page=1","links":[{"url":null,"label":"&laquo; Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/4246535\/inspections?page=1","label":"1","page":1,"active":true},{"url":null,"label":"Next &raquo;","page":null,"active":false}],"next_page_url":null,"path":"https:\/\/searchcarriers.com\/company\/4246535\/inspections","per_page":100,"prev_page_url":null,"to":17,"total":17}