{"current_page":1,"data":[{"id":11089300,"change_date":"2026-02-10 21:37:00","inspection_id":"87000770","dot_number":"4087455","report_state":"NY","report_number":"SPD3011618","insp_date":"2026-02-03 00:00:00","insp_start_time":"1216","insp_end_time":"1230","registration_date":null,"region":"ES","ci_status_code":"C","location":"30445S","location_desc":"TULLY NY","county_code_state":"NY","county_code":"067","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"MELODIA EXPRESS LLC","shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2026-02-10 21:37:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","viol_total":"4","oos_total":"0","driver_viol_total":"1","driver_oos_total":"0","vehicle_viol_total":"3","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2865524","transaction_code":"A","transaction_date":"2026-02-09 00:00:00","upload_date":"2026-02-10 00:00:00","upload_first_byte":"0","upload_dot_number":"04087455","upload_search_indicator":null,"census_search_date":"2026-02-10 21:37:00","snet_input_date":"2026-02-03 00:00:00","source_office":"1DCH001","mcmis_add_date":"2026-02-10 21:37:00","insp_carrier_name":"MELODIA EXPRESS LLC","insp_carrier_street":"806 COLORADO ST","insp_carrier_city":"WATERLOO","insp_carrier_state":"IA","insp_carrier_zip_code":"50703","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2026-02-13T10:37:42.000000Z","updated_at":"2026-02-21T10:30:06.000000Z","inspection_violations":[{"id":18563953,"change_date":"2026-02-10 21:37:00","inspection_id":"87000770","insp_violation_id":"271693344","seq_no":"1","part_no":"392","part_no_section":"2-SLLIFTA","insp_viol_unit":"1","insp_unit_id":"211530603","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-13T10:51:55.000000Z","updated_at":"2026-02-21T10:38:13.000000Z","normalized_code":"3922SLLIFTA"},{"id":18563954,"change_date":"2026-02-10 21:37:00","inspection_id":"87000770","insp_violation_id":"271693345","seq_no":"2","part_no":"395","part_no_section":"8A","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-13T10:51:55.000000Z","updated_at":"2026-02-21T10:38:13.000000Z","normalized_code":"3958A"},{"id":18563955,"change_date":"2026-02-10 21:37:00","inspection_id":"87000770","insp_violation_id":"271693346","seq_no":"3","part_no":"390","part_no_section":"21TB1-MC","insp_viol_unit":"1","insp_unit_id":"211530603","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-13T10:51:55.000000Z","updated_at":"2026-02-21T10:38:13.000000Z","normalized_code":"39021TB1MC"},{"id":18563956,"change_date":"2026-02-10 21:37:00","inspection_id":"87000770","insp_violation_id":"271693347","seq_no":"4","part_no":"390","part_no_section":"21TB2-DOT","insp_viol_unit":"1","insp_unit_id":"211530603","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2026-02-13T10:51:55.000000Z","updated_at":"2026-02-21T10:38:13.000000Z","normalized_code":"39021TB2DOT"}],"inspection_per_units":[{"id":18909593,"change_date":"2026-02-10 21:37:00","inspection_id":"87000770","insp_unit_id":"211530603","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"NXK703","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"5PVNJ7AV5R5T55591","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2026-02-13T10:15:32.000000Z","updated_at":"2026-02-21T10:02:38.000000Z"}]},{"id":9866252,"change_date":"2025-10-06 21:40:00","inspection_id":"85969018","dot_number":"4087455","report_state":"IL","report_number":"4289750179","insp_date":"2025-09-29 00:00:00","insp_start_time":"1805","insp_end_time":"1900","registration_date":null,"region":"CT","ci_status_code":"C","location":"999","location_desc":"I-74","county_code_state":"IL","county_code":"019","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"CONAGRA","shipping_paper_number":"12566709","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-10-06 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"13","oos_total":"2","driver_viol_total":"0","driver_oos_total":"2","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2436696","transaction_code":"A","transaction_date":"2025-09-29 00:00:00","upload_date":"2025-10-06 00:00:00","upload_first_byte":"0","upload_dot_number":"04087455","upload_search_indicator":null,"census_search_date":"2025-10-06 21:40:00","snet_input_date":"2025-09-29 00:00:00","source_office":"3ILS001","mcmis_add_date":"2025-10-06 21:40:00","insp_carrier_name":"MELODIA EXPRESS LLC","insp_carrier_street":"806 COLORADO ST","insp_carrier_city":"WATERLOO","insp_carrier_state":"IA","insp_carrier_zip_code":"50703","insp_colonia":null,"docket_number":"155637","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-10-09T10:00:50.000000Z","updated_at":"2025-10-10T10:01:14.000000Z","inspection_violations":[{"id":16255458,"change_date":"2025-10-06 21:40:00","inspection_id":"85969018","insp_violation_id":"269123221","seq_no":"4","part_no":"395","part_no_section":"30B1","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-09T10:16:14.000000Z","updated_at":"2025-10-10T10:16:53.000000Z","normalized_code":"39530B1"},{"id":16255459,"change_date":"2025-10-06 21:40:00","inspection_id":"85969018","insp_violation_id":"269123222","seq_no":"5","part_no":"395","part_no_section":"30B1","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-09T10:16:14.000000Z","updated_at":"2025-10-10T10:16:53.000000Z","normalized_code":"39530B1"},{"id":16255460,"change_date":"2025-10-06 21:40:00","inspection_id":"85969018","insp_violation_id":"269123223","seq_no":"6","part_no":"395","part_no_section":"30B1","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-09T10:16:14.000000Z","updated_at":"2025-10-10T10:16:53.000000Z","normalized_code":"39530B1"},{"id":16255461,"change_date":"2025-10-06 21:40:00","inspection_id":"85969018","insp_violation_id":"269123224","seq_no":"7","part_no":"395","part_no_section":"30B1","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-09T10:16:14.000000Z","updated_at":"2025-10-10T10:16:53.000000Z","normalized_code":"39530B1"},{"id":16255462,"change_date":"2025-10-06 21:40:00","inspection_id":"85969018","insp_violation_id":"269123225","seq_no":"8","part_no":"395","part_no_section":"8E","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-09T10:16:14.000000Z","updated_at":"2025-10-10T10:16:53.000000Z","normalized_code":"3958E"},{"id":16255463,"change_date":"2025-10-06 21:40:00","inspection_id":"85969018","insp_violation_id":"269123226","seq_no":"9","part_no":"395","part_no_section":"8E","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-09T10:16:14.000000Z","updated_at":"2025-10-10T10:16:53.000000Z","normalized_code":"3958E"},{"id":16255464,"change_date":"2025-10-06 21:40:00","inspection_id":"85969018","insp_violation_id":"269123227","seq_no":"10","part_no":"395","part_no_section":"8E","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-09T10:16:14.000000Z","updated_at":"2025-10-10T10:16:53.000000Z","normalized_code":"3958E"},{"id":16255465,"change_date":"2025-10-06 21:40:00","inspection_id":"85969018","insp_violation_id":"269123228","seq_no":"11","part_no":"395","part_no_section":"8E","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-09T10:16:14.000000Z","updated_at":"2025-10-10T10:16:53.000000Z","normalized_code":"3958E"},{"id":16255466,"change_date":"2025-10-06 21:40:00","inspection_id":"85969018","insp_violation_id":"269123229","seq_no":"12","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-10-09T10:16:14.000000Z","updated_at":"2025-10-10T10:16:53.000000Z","normalized_code":"3953A3II"},{"id":16255467,"change_date":"2025-10-06 21:40:00","inspection_id":"85969018","insp_violation_id":"269123230","seq_no":"13","part_no":"395","part_no_section":"3A2-PROP","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"4","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-09T10:16:14.000000Z","updated_at":"2025-10-10T10:16:53.000000Z","normalized_code":"3953A2PROP"},{"id":16255468,"change_date":"2025-10-06 21:40:00","inspection_id":"85969018","insp_violation_id":"269123231","seq_no":"1","part_no":"395","part_no_section":"30B1","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-09T10:16:14.000000Z","updated_at":"2025-10-10T10:16:53.000000Z","normalized_code":"39530B1"},{"id":16255469,"change_date":"2025-10-06 21:40:00","inspection_id":"85969018","insp_violation_id":"269123232","seq_no":"2","part_no":"395","part_no_section":"30B1","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-09T10:16:14.000000Z","updated_at":"2025-10-10T10:16:53.000000Z","normalized_code":"39530B1"},{"id":16255470,"change_date":"2025-10-06 21:40:00","inspection_id":"85969018","insp_violation_id":"269123233","seq_no":"3","part_no":"395","part_no_section":"30B1","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"50","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-10-09T10:16:14.000000Z","updated_at":"2025-10-10T10:16:53.000000Z","normalized_code":"39530B1"}],"inspection_per_units":[{"id":16364747,"change_date":"2025-10-06 21:40:00","inspection_id":"85969018","insp_unit_id":"209320425","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":"5020","insp_unit_license":"QBN947","insp_unit_license_state":"IA","insp_unit_vehicle_id_number":"3HAEUMML4LL063773","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-10-09T09:45:47.000000Z","updated_at":"2025-10-10T09:46:34.000000Z"}]},{"id":9041711,"change_date":"2025-08-12 21:40:00","inspection_id":"85102490","dot_number":"4087455","report_state":"PA","report_number":"E514518189","insp_date":"2025-06-30 00:00:00","insp_start_time":"1210","insp_end_time":"1242","registration_date":"2025-08-11 00:00:00","region":"ET","ci_status_code":"C","location":"098","location_desc":"I80 EB MM 30 IRWIN TWP - EASTB","county_code_state":"PA","county_code":"121","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"Y","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-07-01 21:38:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"2","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2527194","transaction_code":"C","transaction_date":"2025-06-30 00:00:00","upload_date":"2025-08-12 00:00:00","upload_first_byte":"0","upload_dot_number":"04087455","upload_search_indicator":null,"census_search_date":"2025-07-01 21:38:00","snet_input_date":"2025-06-30 00:00:00","source_office":"1PAS001","mcmis_add_date":"2025-07-01 21:38:00","insp_carrier_name":"MELODIA EXPRESS LLC","insp_carrier_street":"806 COLORADO ST","insp_carrier_city":"WATERLOO","insp_carrier_state":"IA","insp_carrier_zip_code":"50703","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-07-04T10:01:13.000000Z","updated_at":"2025-08-16T10:00:36.000000Z","inspection_violations":[{"id":15262918,"change_date":"2025-08-12 21:40:00","inspection_id":"85102490","insp_violation_id":"267982611","seq_no":"1","part_no":"390","part_no_section":"21TB2-DOT","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-08-15T10:45:43.000000Z","updated_at":"2025-08-16T10:43:41.000000Z","normalized_code":"39021TB2DOT"},{"id":15262919,"change_date":"2025-08-12 21:40:00","inspection_id":"85102490","insp_violation_id":"267982612","seq_no":"2","part_no":"395","part_no_section":"8A1-HOSP","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-08-15T10:45:43.000000Z","updated_at":"2025-08-16T10:43:41.000000Z","normalized_code":"3958A1HOSP"}],"inspection_per_units":[{"id":15472125,"change_date":"2025-08-12 21:40:00","inspection_id":"85102490","insp_unit_id":"208359700","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTL","insp_unit_company":null,"insp_unit_license":"3DA025","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"3HAEUMMMXLL824847","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-08-15T09:46:20.000000Z","updated_at":"2025-08-16T09:45:45.000000Z"}]},{"id":8576154,"change_date":"2025-05-08 21:40:00","inspection_id":"84610434","dot_number":"4087455","report_state":"CO","report_number":"1330011371","insp_date":"2025-05-06 00:00:00","insp_start_time":"0909","insp_end_time":"1002","registration_date":null,"region":"MD","ci_status_code":"C","location":"DUPEWB","location_desc":"DUMONT CO","county_code_state":"CO","county_code":"019","insp_level_id":"3","service_center":"WE","census_source_id":"5","insp_facility":"F","shipper_name":"GREENTECH RENEWABLES","shipping_paper_number":"BATTERIES 9","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"Y","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2025-05-08 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"4","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1699102","transaction_code":"A","transaction_date":"2025-05-08 00:00:00","upload_date":"2025-05-08 00:00:00","upload_first_byte":"0","upload_dot_number":"04087455","upload_search_indicator":null,"census_search_date":"2025-05-08 21:40:00","snet_input_date":"2025-05-06 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-05-08 21:40:00","insp_carrier_name":"MELODIA EXPRESS LLC","insp_carrier_street":"806 COLORADO ST","insp_carrier_city":"WATERLOO","insp_carrier_state":"IA","insp_carrier_zip_code":"50703","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-05-11T10:20:59.000000Z","updated_at":"2025-05-12T10:02:27.000000Z","inspection_violations":[{"id":13620677,"change_date":"2025-05-08 21:40:00","inspection_id":"84610434","insp_violation_id":"266100901","seq_no":"1","part_no":"395","part_no_section":"3A3-HOSPRNP","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"4","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-10T11:32:54.000000Z","updated_at":"2025-05-12T10:21:06.000000Z","normalized_code":"3953A3HOSPRNP"},{"id":13620678,"change_date":"2025-05-08 21:40:00","inspection_id":"84610434","insp_violation_id":"266100902","seq_no":"2","part_no":"395","part_no_section":"3A2-HOSPRNP","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"4","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-10T11:32:54.000000Z","updated_at":"2025-05-12T10:21:06.000000Z","normalized_code":"3953A2HOSPRNP"},{"id":13620679,"change_date":"2025-05-08 21:40:00","inspection_id":"84610434","insp_violation_id":"266100903","seq_no":"3","part_no":"392","part_no_section":"2SLSNC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":"422501625","created_at":"2025-05-10T11:32:54.000000Z","updated_at":"2025-05-12T10:21:06.000000Z","normalized_code":"3922SLSNC"},{"id":13620680,"change_date":"2025-05-08 21:40:00","inspection_id":"84610434","insp_violation_id":"266100904","seq_no":"4","part_no":"395","part_no_section":"30B1-ELDDFR","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"7","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-05-10T11:32:54.000000Z","updated_at":"2025-05-12T10:21:06.000000Z","normalized_code":"39530B1ELDDFR"}],"inspection_per_units":[{"id":13997338,"change_date":"2025-05-08 21:40:00","inspection_id":"84610434","insp_unit_id":"206751524","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"828094","insp_unit_license":"3538600","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1HTMMMML0KH250413","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-05-11T03:53:42.000000Z","updated_at":"2025-05-12T09:49:09.000000Z"}]},{"id":8388118,"change_date":"2025-04-16 21:40:00","inspection_id":"84412283","dot_number":"4087455","report_state":"MD","report_number":"3054C00010","insp_date":"2025-04-15 00:00:00","insp_start_time":"0845","insp_end_time":"1020","registration_date":null,"region":"ED","ci_status_code":"C","location":"011015","location_desc":"PERRYVILLE MD","county_code_state":"MD","county_code":"015","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":"WHITE CAP","shipping_paper_number":"65382364","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-16 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"25999","viol_total":"7","oos_total":"3","driver_viol_total":"0","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"2","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1599338","transaction_code":"A","transaction_date":"2025-04-15 00:00:00","upload_date":"2025-04-16 00:00:00","upload_first_byte":"0","upload_dot_number":"04087455","upload_search_indicator":null,"census_search_date":"2025-04-16 21:40:00","snet_input_date":"2025-04-15 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-04-16 21:40:00","insp_carrier_name":"MELODIA EXPRESS LLC","insp_carrier_street":"806 COLORADO ST","insp_carrier_city":"WATERLOO","insp_carrier_state":"IA","insp_carrier_zip_code":"50703","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-04-19T10:18:46.000000Z","updated_at":"2025-04-20T10:23:17.000000Z","inspection_violations":[{"id":13226323,"change_date":"2025-04-16 21:40:00","inspection_id":"84412283","insp_violation_id":"265648610","seq_no":"1","part_no":"395","part_no_section":"8E-HOSPD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-18T11:08:04.000000Z","updated_at":"2025-04-20T10:35:42.000000Z","normalized_code":"3958EHOSPD"},{"id":13226324,"change_date":"2025-04-16 21:40:00","inspection_id":"84412283","insp_violation_id":"265648611","seq_no":"2","part_no":"395","part_no_section":"8E-HOSPD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-18T11:08:04.000000Z","updated_at":"2025-04-20T10:35:42.000000Z","normalized_code":"3958EHOSPD"},{"id":13226325,"change_date":"2025-04-16 21:40:00","inspection_id":"84412283","insp_violation_id":"265648612","seq_no":"3","part_no":"395","part_no_section":"8E-HOSPD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-18T11:08:04.000000Z","updated_at":"2025-04-20T10:35:42.000000Z","normalized_code":"3958EHOSPD"},{"id":13226326,"change_date":"2025-04-16 21:40:00","inspection_id":"84412283","insp_violation_id":"265648613","seq_no":"4","part_no":"395","part_no_section":"8E-HOSPD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-18T11:08:04.000000Z","updated_at":"2025-04-20T10:35:42.000000Z","normalized_code":"3958EHOSPD"},{"id":13226327,"change_date":"2025-04-16 21:40:00","inspection_id":"84412283","insp_violation_id":"265648614","seq_no":"5","part_no":"395","part_no_section":"8E-HOSPD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-04-18T11:08:04.000000Z","updated_at":"2025-04-20T10:35:42.000000Z","normalized_code":"3958EHOSPD"},{"id":13226328,"change_date":"2025-04-16 21:40:00","inspection_id":"84412283","insp_violation_id":"265648615","seq_no":"6","part_no":"393","part_no_section":"45B2-BHTD","insp_viol_unit":"1","insp_unit_id":"206335367","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-04-18T11:08:04.000000Z","updated_at":"2025-04-20T10:35:42.000000Z","normalized_code":"39345B2BHTD"},{"id":13226329,"change_date":"2025-04-16 21:40:00","inspection_id":"84412283","insp_violation_id":"265648616","seq_no":"7","part_no":"393","part_no_section":"45B2-BHTD","insp_viol_unit":"1","insp_unit_id":"206335367","insp_violation_category_id":"16","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-04-18T11:08:04.000000Z","updated_at":"2025-04-20T10:35:42.000000Z","normalized_code":"39345B2BHTD"}],"inspection_per_units":[{"id":13614970,"change_date":"2025-04-16 21:40:00","inspection_id":"84412283","insp_unit_id":"206335367","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"INTERNATIO","insp_unit_company":"828094","insp_unit_license":"3538600","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1HTMMMML0KH250413","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-04-19T10:02:58.000000Z","updated_at":"2025-04-20T09:51:16.000000Z"}]},{"id":7864859,"change_date":"2025-02-13 21:40:00","inspection_id":"83861999","dot_number":"4087455","report_state":"IA","report_number":"000P15H6KH","insp_date":"2025-02-11 00:00:00","insp_start_time":"1226","insp_end_time":"1315","registration_date":null,"region":"CT","ci_status_code":"C","location":"99","location_desc":"I80 WB @ 303 MM","county_code_state":"IA","county_code":"163","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"EMPTY","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-02-13 21:40:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"3","oos_total":"1","driver_viol_total":"2","driver_oos_total":"1","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1349397","transaction_code":"A","transaction_date":"2025-02-13 00:00:00","upload_date":"2025-02-13 00:00:00","upload_first_byte":"0","upload_dot_number":"04087455","upload_search_indicator":"M","census_search_date":"2025-02-13 21:40:00","snet_input_date":"2025-02-11 00:00:00","source_office":"3IAS001","mcmis_add_date":"2025-02-13 21:40:00","insp_carrier_name":"MELODIA EXPRESS LLC","insp_carrier_street":"806 COLORADO ST","insp_carrier_city":"WATERLOO","insp_carrier_state":"IA","insp_carrier_zip_code":"50703","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T21:01:32.000000Z","updated_at":"2025-03-17T21:01:32.000000Z","inspection_violations":[{"id":12290112,"change_date":"2025-02-13 21:40:00","inspection_id":"83861999","insp_violation_id":"264506061","seq_no":"1","part_no":"390","part_no_section":"21TE","insp_viol_unit":"1","insp_unit_id":"205313957","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:59.000000Z","updated_at":"2025-03-17T22:05:59.000000Z","normalized_code":"39021TE"},{"id":12290113,"change_date":"2025-02-13 21:40:00","inspection_id":"83861999","insp_violation_id":"264506062","seq_no":"2","part_no":"392","part_no_section":"2DL","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:59.000000Z","updated_at":"2025-03-17T22:05:59.000000Z","normalized_code":"3922DL"},{"id":12290114,"change_date":"2025-02-13 21:40:00","inspection_id":"83861999","insp_violation_id":"264506063","seq_no":"3","part_no":"395","part_no_section":"8E1-PC","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":"6SMI25021112495","created_at":"2025-03-17T22:05:59.000000Z","updated_at":"2025-03-17T22:05:59.000000Z","normalized_code":"3958E1PC"}],"inspection_per_units":[{"id":12693868,"change_date":"2025-02-13 21:40:00","inspection_id":"83861999","insp_unit_id":"205313957","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HIN","insp_unit_company":"483334","insp_unit_license":"3299330","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"5PVNJ7AVXP5T51839","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:55:12.000000Z","updated_at":"2025-03-17T23:55:12.000000Z"}]},{"id":7782371,"change_date":"2025-02-04 21:39:00","inspection_id":"83775451","dot_number":"4087455","report_state":"MD","report_number":"2141006793","insp_date":"2025-02-04 00:00:00","insp_start_time":"1050","insp_end_time":"1100","registration_date":null,"region":"ET","ci_status_code":"C","location":"038","location_desc":"BALTIMORE COUNTY","county_code_state":"MD","county_code":"005","insp_level_id":"2","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":"NA","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2025-02-04 21:39:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"0","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2777579","transaction_code":"A","transaction_date":"2025-02-04 00:00:00","upload_date":"2025-02-04 00:00:00","upload_first_byte":"0","upload_dot_number":"04087455","upload_search_indicator":null,"census_search_date":"2025-02-04 21:39:00","snet_input_date":"2025-02-04 00:00:00","source_office":"1MDS001","mcmis_add_date":"2025-02-04 21:39:00","insp_carrier_name":"MELODIA EXPRESS LLC","insp_carrier_street":"806 COLORADO ST","insp_carrier_city":"WATERLOO","insp_carrier_state":"IA","insp_carrier_zip_code":"50703","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:59:53.000000Z","updated_at":"2025-03-17T20:59:53.000000Z","inspection_violations":[],"inspection_per_units":[{"id":12559605,"change_date":"2025-02-04 21:39:00","inspection_id":"83775451","insp_unit_id":"205149420","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":null,"insp_unit_license":"3299330","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"5PVNJ7AVXP5T51839","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:53:41.000000Z","updated_at":"2025-03-17T23:53:41.000000Z"}]},{"id":7763679,"change_date":"2025-02-01 21:33:00","inspection_id":"83755686","dot_number":"4087455","report_state":"TN","report_number":"I033AG1554","insp_date":"2025-01-30 00:00:00","insp_start_time":"2120","insp_end_time":"2137","registration_date":null,"region":"ES","ci_status_code":"C","location":"KNXEN","location_desc":"KNOXVILLE TN","county_code_state":"TN","county_code":"093","insp_level_id":"3","service_center":"SH","census_source_id":"5","insp_facility":"F","shipper_name":"OLHAUSEN BILLIARDS MFG., INC","shipping_paper_number":"167678","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-01 21:33:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"1","oos_total":"1","driver_viol_total":"0","driver_oos_total":"1","vehicle_viol_total":"0","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"1312355","transaction_code":"A","transaction_date":"2025-02-01 00:00:00","upload_date":"2025-02-01 00:00:00","upload_first_byte":"0","upload_dot_number":"04087455","upload_search_indicator":null,"census_search_date":"2025-02-01 21:33:00","snet_input_date":"2025-01-30 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-02-01 21:33:00","insp_carrier_name":"MELODIA EXPRESS LLC","insp_carrier_street":"806 COLORADO ST","insp_carrier_city":"WATERLOO","insp_carrier_state":"IA","insp_carrier_zip_code":"50703","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:59:30.000000Z","updated_at":"2025-03-17T20:59:30.000000Z","inspection_violations":[{"id":12129570,"change_date":"2025-02-01 21:33:00","inspection_id":"83755686","insp_violation_id":"264287931","seq_no":"1","part_no":"395","part_no_section":"8E-HOSPD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:05:10.000000Z","updated_at":"2025-03-17T22:05:10.000000Z","normalized_code":"3958EHOSPD"}],"inspection_per_units":[{"id":12528844,"change_date":"2025-02-01 21:33:00","inspection_id":"83755686","insp_unit_id":"205112716","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"483334","insp_unit_license":"3299330","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"5PVNJ7AVXP5T51839","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:53:18.000000Z","updated_at":"2025-03-17T23:53:18.000000Z"}]},{"id":7660251,"change_date":"2025-01-19 21:34:00","inspection_id":"83647051","dot_number":"4087455","report_state":"TN","report_number":"I3A1780098","insp_date":"2025-01-17 00:00:00","insp_start_time":"0900","insp_end_time":"0945","registration_date":null,"region":"CS","ci_status_code":"C","location":null,"location_desc":"MANCHESTER TN","county_code_state":"TN","county_code":"031","insp_level_id":"1","service_center":"SH","census_source_id":"5","insp_facility":"R","shipper_name":"TREDIT TIRE & WHEEL CO","shipping_paper_number":"011525AIA","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-01-19 21:34:00","post_acc_ind":"N","gross_comb_veh_wt":"25950","viol_total":"9","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":"1266438","transaction_code":"A","transaction_date":"2025-01-19 00:00:00","upload_date":"2025-01-19 00:00:00","upload_first_byte":"0","upload_dot_number":"04087455","upload_search_indicator":null,"census_search_date":"2025-01-19 21:34:00","snet_input_date":"2025-01-17 00:00:00","source_office":"1DCH001","mcmis_add_date":"2025-01-19 21:34:00","insp_carrier_name":"MELODIA EXPRESS LLC","insp_carrier_street":"806 COLORADO ST","insp_carrier_city":"WATERLOO","insp_carrier_state":"IA","insp_carrier_zip_code":"50703","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:57:24.000000Z","updated_at":"2025-03-17T20:57:24.000000Z","inspection_violations":[{"id":11968595,"change_date":"2025-01-19 21:34:00","inspection_id":"83647051","insp_violation_id":"264077620","seq_no":"1","part_no":"395","part_no_section":"3B2-HOSPD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"6","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:19.000000Z","updated_at":"2025-03-17T22:04:19.000000Z","normalized_code":"3953B2HOSPD"},{"id":11968596,"change_date":"2025-01-19 21:34:00","inspection_id":"83647051","insp_violation_id":"264077621","seq_no":"2","part_no":"395","part_no_section":"8E-HOSPD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:19.000000Z","updated_at":"2025-03-17T22:04:19.000000Z","normalized_code":"3958EHOSPD"},{"id":11968597,"change_date":"2025-01-19 21:34:00","inspection_id":"83647051","insp_violation_id":"264077622","seq_no":"3","part_no":"395","part_no_section":"8E-HOSPD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:19.000000Z","updated_at":"2025-03-17T22:04:19.000000Z","normalized_code":"3958EHOSPD"},{"id":11968598,"change_date":"2025-01-19 21:34:00","inspection_id":"83647051","insp_violation_id":"264077623","seq_no":"4","part_no":"395","part_no_section":"8E-HOSPD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:19.000000Z","updated_at":"2025-03-17T22:04:19.000000Z","normalized_code":"3958EHOSPD"},{"id":11968599,"change_date":"2025-01-19 21:34:00","inspection_id":"83647051","insp_violation_id":"264077624","seq_no":"5","part_no":"393","part_no_section":"9A-LSLIWR","insp_viol_unit":"1","insp_unit_id":"204912590","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:04:19.000000Z","updated_at":"2025-03-17T22:04:19.000000Z","normalized_code":"3939ALSLIWR"},{"id":11968600,"change_date":"2025-01-19 21:34:00","inspection_id":"83647051","insp_violation_id":"264077625","seq_no":"6","part_no":"395","part_no_section":"8E-HOSPD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:19.000000Z","updated_at":"2025-03-17T22:04:19.000000Z","normalized_code":"3958EHOSPD"},{"id":11968601,"change_date":"2025-01-19 21:34:00","inspection_id":"83647051","insp_violation_id":"264077626","seq_no":"7","part_no":"393","part_no_section":"9A-LTSI","insp_viol_unit":"1","insp_unit_id":"204912590","insp_violation_category_id":"20","out_of_service_indicator":"Y","defect_verification_id":"99","citation_number":null,"created_at":"2025-03-17T22:04:19.000000Z","updated_at":"2025-03-17T22:04:19.000000Z","normalized_code":"3939ALTSI"},{"id":11968602,"change_date":"2025-01-19 21:34:00","inspection_id":"83647051","insp_violation_id":"264077627","seq_no":"8","part_no":"395","part_no_section":"8E-HOSPD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:19.000000Z","updated_at":"2025-03-17T22:04:19.000000Z","normalized_code":"3958EHOSPD"},{"id":11968603,"change_date":"2025-01-19 21:34:00","inspection_id":"83647051","insp_violation_id":"264077628","seq_no":"9","part_no":"395","part_no_section":"8E-HOSPD","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"2","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T22:04:19.000000Z","updated_at":"2025-03-17T22:04:19.000000Z","normalized_code":"3958EHOSPD"}],"inspection_per_units":[{"id":12360557,"change_date":"2025-01-19 21:34:00","inspection_id":"83647051","insp_unit_id":"204912590","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"HINO","insp_unit_company":"483334","insp_unit_license":"3299330","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"5PVNJ7AVXP5T51839","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:51:25.000000Z","updated_at":"2025-03-17T23:51:25.000000Z"}]},{"id":7011867,"change_date":"2024-10-22 21:41:00","inspection_id":"82963431","dot_number":"4087455","report_state":"MO","report_number":"W134008214","insp_date":"2024-10-22 00:00:00","insp_start_time":"1220","insp_end_time":"1236","registration_date":null,"region":"CD","ci_status_code":"C","location":null,"location_desc":"STEELE MO","county_code_state":"MO","county_code":"155","insp_level_id":"3","service_center":"MW","census_source_id":"5","insp_facility":"R","shipper_name":"ACCELERATED INC","shipping_paper_number":"2784808B","cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"U","pen_cen_match":"I","final_status_date":"2024-10-22 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"2","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":"971806","transaction_code":"A","transaction_date":"2024-10-22 00:00:00","upload_date":"2024-10-22 00:00:00","upload_first_byte":"0","upload_dot_number":"04087455","upload_search_indicator":null,"census_search_date":"2024-10-22 21:41:00","snet_input_date":"2024-10-22 00:00:00","source_office":"1DCH001","mcmis_add_date":"2024-10-22 21:41:00","insp_carrier_name":"MELODIA EXPRESS LLC","insp_carrier_street":"806 COLORADO ST","insp_carrier_city":"WATERLOO","insp_carrier_state":"IA","insp_carrier_zip_code":"50703","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:42:17.000000Z","updated_at":"2025-03-17T20:42:17.000000Z","inspection_violations":[{"id":10941268,"change_date":"2024-10-22 21:41:00","inspection_id":"82963431","insp_violation_id":"262478826","seq_no":"1","part_no":"390","part_no_section":"21TB1-MC","insp_viol_unit":"1","insp_unit_id":"203519471","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:05.000000Z","updated_at":"2025-03-17T21:59:05.000000Z","normalized_code":"39021TB1MC"},{"id":10941269,"change_date":"2024-10-22 21:41:00","inspection_id":"82963431","insp_violation_id":"262478827","seq_no":"2","part_no":"395","part_no_section":"8A1-HOSP","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"3","out_of_service_indicator":"Y","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:59:05.000000Z","updated_at":"2025-03-17T21:59:05.000000Z","normalized_code":"3958A1HOSP"}],"inspection_per_units":[{"id":11309633,"change_date":"2024-10-22 21:41:00","inspection_id":"82963431","insp_unit_id":"203519471","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FREIGHTLIN","insp_unit_company":"414492","insp_unit_license":"3416412","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FVACWFC6RHUN5695","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:40:05.000000Z","updated_at":"2025-03-17T23:40:05.000000Z"}]},{"id":6962939,"change_date":"2024-11-14 21:41:00","inspection_id":"82911402","dot_number":"4087455","report_state":"PA","report_number":"E922428639","insp_date":"2024-10-12 00:00:00","insp_start_time":"0935","insp_end_time":"1010","registration_date":"2024-11-14 00:00:00","region":"ET","ci_status_code":"C","location":"316","location_desc":"I380 SB MM 16.5 COVINGTON TWP","county_code_state":"PA","county_code":"069","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"F","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-10-15 21:43:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","viol_total":"1","oos_total":"0","driver_viol_total":"0","driver_oos_total":"0","vehicle_viol_total":"1","vehicle_oos_total":"0","hazmat_viol_total":"0","hazmat_oos_total":"0","snet_sequence_id":"2472725","transaction_code":"C","transaction_date":"2024-10-12 00:00:00","upload_date":"2024-11-14 00:00:00","upload_first_byte":"0","upload_dot_number":"04087455","upload_search_indicator":null,"census_search_date":"2024-10-15 21:43:00","snet_input_date":"2024-10-12 00:00:00","source_office":"1PAS001","mcmis_add_date":"2024-10-15 21:43:00","insp_carrier_name":"MELODIA EXPRESS LLC","insp_carrier_street":"806 COLORADO ST","insp_carrier_city":"WATERLOO","insp_carrier_state":"IA","insp_carrier_zip_code":"50703","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:41:22.000000Z","updated_at":"2025-03-17T20:41:22.000000Z","inspection_violations":[{"id":10856079,"change_date":"2024-11-14 21:41:00","inspection_id":"82911402","insp_violation_id":"262897475","seq_no":"1","part_no":"390","part_no_section":"21TE","insp_viol_unit":"1","insp_unit_id":"203883535","insp_violation_category_id":"51","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:58:35.000000Z","updated_at":"2025-03-17T21:58:35.000000Z","normalized_code":"39021TE"}],"inspection_per_units":[{"id":11230217,"change_date":"2024-11-14 21:41:00","inspection_id":"82911402","insp_unit_id":"203883535","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FRHT","insp_unit_company":"414492","insp_unit_license":"3416412","insp_unit_license_state":"IN","insp_unit_vehicle_id_number":"1FVACWFC6RHUN5695","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:39:17.000000Z","updated_at":"2025-03-17T23:39:17.000000Z"}]},{"id":6367575,"change_date":"2024-08-01 21:41:00","inspection_id":"82277013","dot_number":"4087455","report_state":"NY","report_number":"SPL0183444","insp_date":"2024-07-30 00:00:00","insp_start_time":"1406","insp_end_time":"1425","registration_date":null,"region":"ET","ci_status_code":"C","location":"00634D","location_desc":"PLAINVIEW - SOUTH SERVICE RD","county_code_state":"NY","county_code":"059","insp_level_id":"3","service_center":"EA","census_source_id":"5","insp_facility":"R","shipper_name":null,"shipping_paper_number":null,"cargo_tank":null,"hazmat_placard_req":null,"snet_version_number":"4.2.0.1","snet_search_date":null,"alcohol_control_sub":"N","drug_intrdctn_search":"N","drug_intrdctn_arrests":"0","size_weight_enf":"N","traffic_enf":"N","local_enf_jurisdiction":"N","pen_cen_match":null,"final_status_date":"2024-08-01 21:41:00","post_acc_ind":"N","gross_comb_veh_wt":"26000","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":"2941655","transaction_code":"A","transaction_date":"2024-08-01 00:00:00","upload_date":"2024-08-01 00:00:00","upload_first_byte":"0","upload_dot_number":"04087455","upload_search_indicator":"M","census_search_date":"2024-08-01 21:41:00","snet_input_date":"2024-08-01 00:00:00","source_office":"1NYS001","mcmis_add_date":"2024-08-01 21:41:00","insp_carrier_name":"MELODIA EXPRESS LLC","insp_carrier_street":"806 COLORADO ST","insp_carrier_city":"WATERLOO","insp_carrier_state":"IA","insp_carrier_zip_code":"50703","insp_colonia":null,"docket_number":"0","insp_interstate":"Y","insp_carrier_state_id":null,"created_at":"2025-03-17T20:29:05.000000Z","updated_at":"2025-03-17T20:29:05.000000Z","inspection_violations":[{"id":9886154,"change_date":"2024-08-01 21:41:00","inspection_id":"82277013","insp_violation_id":"260965079","seq_no":"1","part_no":"391","part_no_section":"41(a)(1)","insp_viol_unit":"D","insp_unit_id":null,"insp_violation_category_id":"1","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:50.000000Z","updated_at":"2025-03-17T21:53:50.000000Z","normalized_code":"39141A1"},{"id":9886155,"change_date":"2024-08-01 21:41:00","inspection_id":"82277013","insp_violation_id":"260965080","seq_no":"2","part_no":"392","part_no_section":"2","insp_viol_unit":"1","insp_unit_id":"202188486","insp_violation_category_id":"14","out_of_service_indicator":"N","defect_verification_id":"3","citation_number":null,"created_at":"2025-03-17T21:53:50.000000Z","updated_at":"2025-03-17T21:53:50.000000Z","normalized_code":"3922"}],"inspection_per_units":[{"id":10261065,"change_date":"2024-08-01 21:41:00","inspection_id":"82277013","insp_unit_id":"202188486","insp_unit_type_id":"10","insp_unit_number":"1","insp_unit_make":"FORD","insp_unit_company":null,"insp_unit_license":"3JR930","insp_unit_license_state":"OK","insp_unit_vehicle_id_number":"1FDNF6AN3RDF06599","insp_unit_decal":"N","insp_unit_decal_number":null,"created_at":"2025-03-17T23:29:18.000000Z","updated_at":"2025-03-17T23:29:18.000000Z"}]}],"first_page_url":"https:\/\/searchcarriers.com\/company\/4087455\/inspections?page=1","from":1,"last_page":1,"last_page_url":"https:\/\/searchcarriers.com\/company\/4087455\/inspections?page=1","links":[{"url":null,"label":"« Previous","page":null,"active":false},{"url":"https:\/\/searchcarriers.com\/company\/4087455\/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\/4087455\/inspections","per_page":100,"prev_page_url":null,"to":12,"total":12}