[{"id":"e3201a6a-edc3-41b9-ab82-fe8204492785","publication_cycle_id":"89601246-26ea-4a86-b344-b81d051f6b91","publication_cycle_date":"2026-03-19","family":"nasr_airports","artifact_role":"apt","artifact_kind":"archive","required":true,"sequence":0,"status":"extracted","source_url":"https://nfdc.faa.gov/webContent/28DaySub/2026-03-19/APT.zip","filename":"APT.zip","http_status_code":206,"remote_size_bytes":9987313,"remote_last_modified_at":"2026-02-18T21:39:54","remote_etag":"W/\"9987313-1771450794564\"","discovered_at":"2026-04-02T20:33:21.266298","available_at":"2026-04-02T20:33:21.266298","local_relative_path":"raw/2026-03-19/nasr_airports/APT.zip","downloaded_at":"2026-04-02T20:33:32.681430","extracted_relative_path":"extracted/2026-03-19/nasr_airports/apt","extracted_at":"2026-04-02T20:33:32.810803","last_error":null,"next_job_type":"upsert_chart_inventory","next_job_status":"succeeded"},{"id":"ef03597f-46be-4f78-be26-07d3fe1847bc","publication_cycle_id":"5a93c0fc-4646-4f41-8073-f84f80b54642","publication_cycle_date":"2026-03-19","family":"nasr_towers","artifact_role":"twr","artifact_kind":"archive","required":true,"sequence":0,"status":"extracted","source_url":"https://nfdc.faa.gov/webContent/28DaySub/2026-03-19/TWR.zip","filename":"TWR.zip","http_status_code":206,"remote_size_bytes":1030893,"remote_last_modified_at":"2026-02-18T21:39:56","remote_etag":"W/\"1030893-1771450796424\"","discovered_at":"2026-04-02T20:33:21.266298","available_at":"2026-04-02T20:33:21.266298","local_relative_path":"raw/2026-03-19/nasr_towers/TWR.zip","downloaded_at":"2026-04-02T20:33:30.334895","extracted_relative_path":"extracted/2026-03-19/nasr_towers/twr","extracted_at":"2026-04-02T20:33:30.361533","last_error":null,"next_job_type":"upsert_chart_inventory","next_job_status":"succeeded"},{"id":"99253bc3-d70f-46f8-8a38-629ef40a4f50","publication_cycle_id":"7dfbbe2d-53fb-487a-9853-4b11a0ab8c8f","publication_cycle_date":"2026-03-19","family":"vfr_caribbean","artifact_role":"caribbean","artifact_kind":"archive","required":true,"sequence":0,"status":"extracted","source_url":"https://aeronav.faa.gov/visual/03-19-2026/All_Files/Caribbean.zip","filename":"Caribbean.zip","http_status_code":200,"remote_size_bytes":82708552,"remote_last_modified_at":"2026-02-26T14:08:13","remote_etag":"\"11cc3d5829a7dc1:0\"","discovered_at":"2026-04-01T02:05:26.011137","available_at":"2026-04-01T00:10:18.067767","local_relative_path":"raw/2026-03-19/vfr_caribbean/Caribbean.zip","downloaded_at":"2026-04-01T05:38:49.238884","extracted_relative_path":"extracted/2026-03-19/vfr_caribbean/caribbean","extracted_at":"2026-04-01T05:38:49.434916","last_error":null,"next_job_type":"upsert_chart_inventory","next_job_status":"succeeded"},{"id":"32470719-70a5-43c6-9c41-0dda916c7fdf","publication_cycle_id":"92e073bf-09a0-4524-9619-3cf52bc455dc","publication_cycle_date":"2026-03-19","family":"vfr_grand_canyon","artifact_role":"grand_canyon","artifact_kind":"archive","required":true,"sequence":0,"status":"extracted","source_url":"https://aeronav.faa.gov/visual/03-19-2026/All_Files/Grand_Canyon.zip","filename":"Grand_Canyon.zip","http_status_code":200,"remote_size_bytes":37785359,"remote_last_modified_at":"2026-02-26T14:07:29","remote_etag":"\"951963e29a7dc1:0\"","discovered_at":"2026-04-01T02:05:26.011137","available_at":"2026-04-01T00:10:18.067767","local_relative_path":"raw/2026-03-19/vfr_grand_canyon/Grand_Canyon.zip","downloaded_at":"2026-04-01T05:39:54.650170","extracted_relative_path":"extracted/2026-03-19/vfr_grand_canyon/grand_canyon","extracted_at":"2026-04-01T05:39:54.740152","last_error":null,"next_job_type":"upsert_chart_inventory","next_job_status":"succeeded"},{"id":"8bbe2488-f617-4667-9d70-5b8f4bb8ab0a","publication_cycle_id":"1170e794-3501-4c03-8221-12c06ee869c3","publication_cycle_date":"2026-03-19","family":"vfr_helicopter","artifact_role":"helicopter","artifact_kind":"archive","required":true,"sequence":0,"status":"extracted","source_url":"https://aeronav.faa.gov/visual/03-19-2026/All_Files/Helicopter.zip","filename":"Helicopter.zip","http_status_code":200,"remote_size_bytes":287675683,"remote_last_modified_at":"2026-02-26T14:12:28","remote_etag":"\"5fdc3cf029a7dc1:0\"","discovered_at":"2026-04-01T02:05:26.011137","available_at":"2026-04-01T00:10:18.067767","local_relative_path":"raw/2026-03-19/vfr_helicopter/Helicopter.zip","downloaded_at":"2026-04-01T05:48:41.418474","extracted_relative_path":"extracted/2026-03-19/vfr_helicopter/helicopter","extracted_at":"2026-04-01T05:48:42.094259","last_error":null,"next_job_type":"upsert_chart_inventory","next_job_status":"succeeded"},{"id":"cb30e07c-3fa0-46e1-b0c4-2a468ec004f6","publication_cycle_id":"24436aca-a89b-4515-86fc-0b32a4cdb56a","publication_cycle_date":"2026-03-19","family":"vfr_planning","artifact_role":"planning","artifact_kind":"archive","required":true,"sequence":0,"status":"extracted","source_url":"https://aeronav.faa.gov/visual/03-19-2026/All_Files/Planning.zip","filename":"Planning.zip","http_status_code":200,"remote_size_bytes":100243053,"remote_last_modified_at":"2026-02-26T14:11:25","remote_etag":"\"7147c5ca29a7dc1:0\"","discovered_at":"2026-04-01T02:05:26.011137","available_at":"2026-04-01T00:10:18.067767","local_relative_path":"raw/2026-03-19/vfr_planning/Planning.zip","downloaded_at":"2026-04-01T05:51:31.588015","extracted_relative_path":"extracted/2026-03-19/vfr_planning/planning","extracted_at":"2026-04-01T05:51:31.821077","last_error":null,"next_job_type":"upsert_chart_inventory","next_job_status":"succeeded"},{"id":"3d4ba36f-78c9-4e39-aa0b-5066464fd321","publication_cycle_id":"2b0a36b0-5d1b-4756-b601-733d950c9688","publication_cycle_date":"2026-03-19","family":"vfr_sectional","artifact_role":"sectional","artifact_kind":"archive","required":true,"sequence":0,"status":"extracted","source_url":"https://aeronav.faa.gov/visual/03-19-2026/All_Files/Sectional.zip","filename":"Sectional.zip","http_status_code":200,"remote_size_bytes":3287620717,"remote_last_modified_at":"2026-03-17T18:19:58","remote_etag":"\"6deecaa93ab6dc1:0\"","discovered_at":"2026-04-01T02:05:26.011137","available_at":"2026-04-01T00:10:18.067767","local_relative_path":"raw/2026-03-19/vfr_sectional/Sectional.zip","downloaded_at":"2026-04-01T06:45:44.040939","extracted_relative_path":"extracted/2026-03-19/vfr_sectional/sectional","extracted_at":"2026-04-01T06:45:51.561577","last_error":null,"next_job_type":"upsert_chart_inventory","next_job_status":"succeeded"},{"id":"5b055812-32d2-4cbe-84be-df89a815f2c2","publication_cycle_id":"3a1c7d99-4a52-4d52-a8bd-5a677e910542","publication_cycle_date":"2026-03-19","family":"vfr_terminal","artifact_role":"terminal","artifact_kind":"archive","required":true,"sequence":0,"status":"extracted","source_url":"https://aeronav.faa.gov/visual/03-19-2026/All_Files/Terminal.zip","filename":"Terminal.zip","http_status_code":200,"remote_size_bytes":849093793,"remote_last_modified_at":"2026-02-26T14:29:15","remote_etag":"\"2b2db482ca7dc1:0\"","discovered_at":"2026-04-01T02:05:26.011137","available_at":"2026-04-01T00:10:18.067767","local_relative_path":"raw/2026-03-19/vfr_terminal/Terminal.zip","downloaded_at":"2026-04-01T06:46:07.839929","extracted_relative_path":"extracted/2026-03-19/vfr_terminal/terminal","extracted_at":"2026-04-01T06:46:09.835633","last_error":null,"next_job_type":"upsert_chart_inventory","next_job_status":"succeeded"},{"id":"67cdeca7-f6ce-4f94-8787-e5e5db85bbfc","publication_cycle_id":"f9b0a2e5-646c-406b-b8a7-f551487fc3d7","publication_cycle_date":"2026-03-19","family":"ifr_enroute","artifact_role":"ddecus_zip","artifact_kind":"archive","required":true,"sequence":0,"status":"extracted","source_url":"https://aeronav.faa.gov/enroute/03-19-2026/DDECUS.zip","filename":"DDECUS.zip","http_status_code":200,"remote_size_bytes":1212658025,"remote_last_modified_at":"2026-02-25T22:04:46","remote_etag":"\"447096c0a2a6dc1:0\"","discovered_at":"2026-04-01T02:05:26.011137","available_at":"2026-04-01T00:10:18.067767","local_relative_path":"raw/2026-03-19/ifr_enroute/DDECUS.zip","downloaded_at":"2026-04-01T03:02:22.628042","extracted_relative_path":"extracted/2026-03-19/ifr_enroute/ddecus_zip","extracted_at":"2026-04-01T03:02:22.976731","last_error":null,"next_job_type":"upsert_chart_inventory","next_job_status":"succeeded"},{"id":"06a8056b-8d7c-4c4f-adcf-cd7d07ba005f","publication_cycle_id":"8d9006df-b8a5-4848-ab95-6011cd9aee15","publication_cycle_date":"2026-03-19","family":"terminal_procedures","artifact_role":"ddtppa_zip","artifact_kind":"archive","required":true,"sequence":1,"status":"extracted","source_url":"https://aeronav.faa.gov/Upload_313-d/terminal/DDTPPA_260319.zip","filename":"DDTPPA_260319.zip","http_status_code":200,"remote_size_bytes":979235850,"remote_last_modified_at":"2026-02-26T16:54:48","remote_etag":"\"8be1229e40a7dc1:0\"","discovered_at":"2026-04-01T02:05:26.011137","available_at":"2026-04-01T00:10:18.067767","local_relative_path":"raw/2026-03-19/terminal_procedures/DDTPPA_260319.zip","downloaded_at":"2026-04-01T03:42:56.059071","extracted_relative_path":"extracted/2026-03-19/terminal_procedures/ddtppa_zip","extracted_at":"2026-04-01T03:43:00.579032","last_error":null,"next_job_type":null,"next_job_status":null},{"id":"ea75b13a-d7c3-43ad-9e80-2c63fc97ee5b","publication_cycle_id":"8d9006df-b8a5-4848-ab95-6011cd9aee15","publication_cycle_date":"2026-03-19","family":"terminal_procedures","artifact_role":"ddtppb_zip","artifact_kind":"archive","required":true,"sequence":2,"status":"extracted","source_url":"https://aeronav.faa.gov/Upload_313-d/terminal/DDTPPB_260319.zip","filename":"DDTPPB_260319.zip","http_status_code":200,"remote_size_bytes":976341623,"remote_last_modified_at":"2026-02-26T17:05:13","remote_etag":"\"b29f671242a7dc1:0\"","discovered_at":"2026-04-01T02:05:26.011137","available_at":"2026-04-01T00:10:18.067767","local_relative_path":"raw/2026-03-19/terminal_procedures/DDTPPB_260319.zip","downloaded_at":"2026-04-01T04:23:23.440427","extracted_relative_path":"extracted/2026-03-19/terminal_procedures/ddtppb_zip","extracted_at":"2026-04-01T04:23:25.757659","last_error":null,"next_job_type":null,"next_job_status":null},{"id":"d419c4e0-a362-4a35-a251-2a7aad806997","publication_cycle_id":"8d9006df-b8a5-4848-ab95-6011cd9aee15","publication_cycle_date":"2026-03-19","family":"terminal_procedures","artifact_role":"ddtppc_zip","artifact_kind":"archive","required":true,"sequence":3,"status":"extracted","source_url":"https://aeronav.faa.gov/Upload_313-d/terminal/DDTPPC_260319.zip","filename":"DDTPPC_260319.zip","http_status_code":200,"remote_size_bytes":880558333,"remote_last_modified_at":"2026-02-26T17:01:10","remote_etag":"\"52bb9e8141a7dc1:0\"","discovered_at":"2026-04-01T02:05:26.011137","available_at":"2026-04-01T00:10:18.067767","local_relative_path":"raw/2026-03-19/terminal_procedures/DDTPPC_260319.zip","downloaded_at":"2026-04-01T04:57:56.191450","extracted_relative_path":"extracted/2026-03-19/terminal_procedures/ddtppc_zip","extracted_at":"2026-04-01T04:57:58.380164","last_error":null,"next_job_type":null,"next_job_status":null},{"id":"edbcf399-707a-4737-9826-33bcef24b887","publication_cycle_id":"8d9006df-b8a5-4848-ab95-6011cd9aee15","publication_cycle_date":"2026-03-19","family":"terminal_procedures","artifact_role":"ddtppd_zip","artifact_kind":"archive","required":true,"sequence":4,"status":"extracted","source_url":"https://aeronav.faa.gov/Upload_313-d/terminal/DDTPPD_260319.zip","filename":"DDTPPD_260319.zip","http_status_code":200,"remote_size_bytes":918439742,"remote_last_modified_at":"2026-02-26T16:44:02","remote_etag":"\"ecf6ec1c3fa7dc1:0\"","discovered_at":"2026-04-01T02:05:26.011137","available_at":"2026-04-01T00:10:18.067767","local_relative_path":"raw/2026-03-19/terminal_procedures/DDTPPD_260319.zip","downloaded_at":"2026-04-01T05:38:05.791990","extracted_relative_path":"extracted/2026-03-19/terminal_procedures/ddtppd_zip","extracted_at":"2026-04-01T05:38:08.048290","last_error":null,"next_job_type":null,"next_job_status":null},{"id":"ed3fa7d2-a6be-47cf-9efd-e057c116329f","publication_cycle_id":"8d9006df-b8a5-4848-ab95-6011cd9aee15","publication_cycle_date":"2026-03-19","family":"terminal_procedures","artifact_role":"ddtppe_zip","artifact_kind":"archive","required":true,"sequence":5,"status":"extracted","source_url":"https://aeronav.faa.gov/Upload_313-d/terminal/DDTPPE_260319.zip","filename":"DDTPPE_260319.zip","http_status_code":200,"remote_size_bytes":976263956,"remote_last_modified_at":"2026-02-26T16:54:18","remote_etag":"\"6de36c8c40a7dc1:0\"","discovered_at":"2026-04-01T02:05:26.011137","available_at":"2026-04-01T00:10:18.067767","local_relative_path":"raw/2026-03-19/terminal_procedures/DDTPPE_260319.zip","downloaded_at":"2026-04-01T05:38:19.655889","extracted_relative_path":"extracted/2026-03-19/terminal_procedures/ddtppe_zip","extracted_at":"2026-04-01T05:38:21.564119","last_error":null,"next_job_type":null,"next_job_status":null},{"id":"277b9550-a2a4-4156-9119-9eb5c271e017","publication_cycle_id":"8d9006df-b8a5-4848-ab95-6011cd9aee15","publication_cycle_date":"2026-03-19","family":"terminal_procedures","artifact_role":"dtpp_metafile_xml","artifact_kind":"metafile","required":true,"sequence":99,"status":"extracted","source_url":"https://aeronav.faa.gov/d-tpp/2603/xml_data/d-TPP_Metafile.xml","filename":"d-TPP_Metafile.xml","http_status_code":200,"remote_size_bytes":20,"remote_last_modified_at":"2026-02-26T15:06:21","remote_etag":"\"20b0be7731a7dc1:0\"","discovered_at":"2026-04-01T02:05:26.011137","available_at":"2026-04-01T00:10:18.067767","local_relative_path":"raw/2026-03-19/terminal_procedures/d-TPP_Metafile.xml","downloaded_at":"2026-04-01T05:38:25.736396","extracted_relative_path":"raw/2026-03-19/terminal_procedures/d-TPP_Metafile.xml","extracted_at":"2026-04-01T05:38:25.741299","last_error":null,"next_job_type":"upsert_chart_inventory","next_job_status":"succeeded"},{"id":"4f7a919b-8efb-4c42-ba3f-4966d4028146","publication_cycle_id":"c1cdb27c-3014-4149-8587-699761a71272","publication_cycle_date":"2026-04-16","family":"vfr_helicopter","artifact_role":"helicopter","artifact_kind":"archive","required":true,"sequence":0,"status":"missing","source_url":"https://aeronav.faa.gov/visual/04-16-2026/All_Files/Helicopter.zip","filename":"Helicopter.zip","http_status_code":404,"remote_size_bytes":null,"remote_last_modified_at":null,"remote_etag":null,"discovered_at":"2026-04-01T02:05:26.011137","available_at":null,"local_relative_path":null,"downloaded_at":null,"extracted_relative_path":null,"extracted_at":null,"last_error":null,"next_job_type":null,"next_job_status":null},{"id":"38e83c96-52ca-4d73-9bda-20525a45cc90","publication_cycle_id":"ac4fcf72-7757-4442-9370-1ab2ef9db65e","publication_cycle_date":"2026-04-16","family":"vfr_planning","artifact_role":"planning","artifact_kind":"archive","required":true,"sequence":0,"status":"missing","source_url":"https://aeronav.faa.gov/visual/04-16-2026/All_Files/Planning.zip","filename":"Planning.zip","http_status_code":404,"remote_size_bytes":null,"remote_last_modified_at":null,"remote_etag":null,"discovered_at":"2026-04-01T02:05:26.011137","available_at":null,"local_relative_path":null,"downloaded_at":null,"extracted_relative_path":null,"extracted_at":null,"last_error":null,"next_job_type":null,"next_job_status":null},{"id":"244daa4d-e28f-47cc-be95-fe326a2cd626","publication_cycle_id":"994de06e-0e96-42e7-b079-c27ac666ce61","publication_cycle_date":"2026-04-16","family":"vfr_sectional","artifact_role":"sectional","artifact_kind":"archive","required":true,"sequence":0,"status":"missing","source_url":"https://aeronav.faa.gov/visual/04-16-2026/All_Files/Sectional.zip","filename":"Sectional.zip","http_status_code":404,"remote_size_bytes":null,"remote_last_modified_at":null,"remote_etag":null,"discovered_at":"2026-04-01T02:05:26.011137","available_at":null,"local_relative_path":null,"downloaded_at":null,"extracted_relative_path":null,"extracted_at":null,"last_error":null,"next_job_type":null,"next_job_status":null},{"id":"6b30b98e-7fb5-45d1-a28b-1958a748f027","publication_cycle_id":"b0e02614-5896-41c5-86c8-fe3e04203cf0","publication_cycle_date":"2026-04-16","family":"vfr_terminal","artifact_role":"terminal","artifact_kind":"archive","required":true,"sequence":0,"status":"missing","source_url":"https://aeronav.faa.gov/visual/04-16-2026/All_Files/Terminal.zip","filename":"Terminal.zip","http_status_code":404,"remote_size_bytes":null,"remote_last_modified_at":null,"remote_etag":null,"discovered_at":"2026-04-01T02:05:26.011137","available_at":null,"local_relative_path":null,"downloaded_at":null,"extracted_relative_path":null,"extracted_at":null,"last_error":null,"next_job_type":null,"next_job_status":null},{"id":"4a72bc3e-8d87-48d0-8e84-4bc6b0d22cd1","publication_cycle_id":"64c183ad-ad03-4c38-b310-aeeb02a5b107","publication_cycle_date":"2026-04-16","family":"ifr_enroute","artifact_role":"ddecus_zip","artifact_kind":"archive","required":true,"sequence":0,"status":"missing","source_url":"https://aeronav.faa.gov/enroute/04-16-2026/DDECUS.zip","filename":"DDECUS.zip","http_status_code":404,"remote_size_bytes":null,"remote_last_modified_at":null,"remote_etag":null,"discovered_at":"2026-04-01T02:05:26.011137","available_at":null,"local_relative_path":null,"downloaded_at":null,"extracted_relative_path":null,"extracted_at":null,"last_error":null,"next_job_type":null,"next_job_status":null},{"id":"954c3942-b567-4d18-8867-2bc14c69d62c","publication_cycle_id":"89306d39-3f69-4138-9c09-be3a1c5883b9","publication_cycle_date":"2026-04-16","family":"terminal_procedures","artifact_role":"ddtppa_zip","artifact_kind":"archive","required":true,"sequence":1,"status":"extracted","source_url":"https://aeronav.faa.gov/Upload_313-d/terminal/DDTPPA_260416.zip","filename":"DDTPPA_260416.zip","http_status_code":200,"remote_size_bytes":980226549,"remote_last_modified_at":"2026-03-25T20:00:25","remote_etag":"\"238561592bcdc1:0\"","discovered_at":"2026-04-01T02:05:26.011137","available_at":"2026-04-01T00:10:18.067767","local_relative_path":"raw/2026-04-16/terminal_procedures/DDTPPA_260416.zip","downloaded_at":"2026-04-01T00:46:03.900350","extracted_relative_path":"extracted/2026-04-16/terminal_procedures/ddtppa_zip","extracted_at":"2026-04-01T01:51:15.418691","last_error":null,"next_job_type":null,"next_job_status":null},{"id":"8556e15d-2157-40fa-a449-5947112f8f2e","publication_cycle_id":"89306d39-3f69-4138-9c09-be3a1c5883b9","publication_cycle_date":"2026-04-16","family":"terminal_procedures","artifact_role":"ddtppb_zip","artifact_kind":"archive","required":true,"sequence":2,"status":"extracted","source_url":"https://aeronav.faa.gov/Upload_313-d/terminal/DDTPPB_260416.zip","filename":"DDTPPB_260416.zip","http_status_code":200,"remote_size_bytes":976546893,"remote_last_modified_at":"2026-03-25T19:57:05","remote_etag":"\"4d18e91bcdc1:0\"","discovered_at":"2026-04-01T02:05:26.011137","available_at":"2026-04-01T00:10:18.067767","local_relative_path":"raw/2026-04-16/terminal_procedures/DDTPPB_260416.zip","downloaded_at":"2026-04-01T01:21:22.393146","extracted_relative_path":"extracted/2026-04-16/terminal_procedures/ddtppb_zip","extracted_at":"2026-04-01T01:51:17.621708","last_error":null,"next_job_type":null,"next_job_status":null},{"id":"2bd5d61d-0708-4e89-aeae-4422b24fc6d7","publication_cycle_id":"89306d39-3f69-4138-9c09-be3a1c5883b9","publication_cycle_date":"2026-04-16","family":"terminal_procedures","artifact_role":"ddtppc_zip","artifact_kind":"archive","required":true,"sequence":3,"status":"extracted","source_url":"https://aeronav.faa.gov/Upload_313-d/terminal/DDTPPC_260416.zip","filename":"DDTPPC_260416.zip","http_status_code":200,"remote_size_bytes":881423382,"remote_last_modified_at":"2026-03-25T19:49:29","remote_etag":"\"2cba97e90bcdc1:0\"","discovered_at":"2026-04-01T02:05:26.011137","available_at":"2026-04-01T00:10:18.067767","local_relative_path":"raw/2026-04-16/terminal_procedures/DDTPPC_260416.zip","downloaded_at":"2026-04-01T02:07:47.919179","extracted_relative_path":"extracted/2026-04-16/terminal_procedures/ddtppc_zip","extracted_at":"2026-04-01T02:08:19.075784","last_error":null,"next_job_type":null,"next_job_status":null},{"id":"cfe471d8-6c69-4d31-b084-ce521ef15e46","publication_cycle_id":"89306d39-3f69-4138-9c09-be3a1c5883b9","publication_cycle_date":"2026-04-16","family":"terminal_procedures","artifact_role":"ddtppd_zip","artifact_kind":"archive","required":true,"sequence":4,"status":"extracted","source_url":"https://aeronav.faa.gov/Upload_313-d/terminal/DDTPPD_260416.zip","filename":"DDTPPD_260416.zip","http_status_code":200,"remote_size_bytes":919799223,"remote_last_modified_at":"2026-03-25T20:03:50","remote_etag":"\"dc88a07f92bcdc1:0\"","discovered_at":"2026-04-01T02:05:26.011137","available_at":"2026-04-01T00:10:18.067767","local_relative_path":"raw/2026-04-16/terminal_procedures/DDTPPD_260416.zip","downloaded_at":"2026-04-01T03:00:51.387247","extracted_relative_path":"extracted/2026-04-16/terminal_procedures/ddtppd_zip","extracted_at":"2026-04-01T03:42:58.337400","last_error":null,"next_job_type":null,"next_job_status":null},{"id":"aa806eb0-049f-4960-846d-a1ec6cd82501","publication_cycle_id":"89306d39-3f69-4138-9c09-be3a1c5883b9","publication_cycle_date":"2026-04-16","family":"terminal_procedures","artifact_role":"ddtppe_zip","artifact_kind":"archive","required":true,"sequence":5,"status":"extracted","source_url":"https://aeronav.faa.gov/Upload_313-d/terminal/DDTPPE_260416.zip","filename":"DDTPPE_260416.zip","http_status_code":200,"remote_size_bytes":8423184,"remote_last_modified_at":"2026-03-25T19:57:08","remote_etag":"\"4645a88f91bcdc1:0\"","discovered_at":"2026-04-01T02:05:26.011137","available_at":"2026-04-01T00:10:18.067767","local_relative_path":"raw/2026-04-16/terminal_procedures/DDTPPE_260416.zip","downloaded_at":"2026-04-01T02:05:51.899714","extracted_relative_path":"extracted/2026-04-16/terminal_procedures/ddtppe_zip","extracted_at":"2026-04-01T02:05:51.926303","last_error":null,"next_job_type":null,"next_job_status":null},{"id":"18dae170-a31d-4972-ba4b-167866a3d9d8","publication_cycle_id":"89306d39-3f69-4138-9c09-be3a1c5883b9","publication_cycle_date":"2026-04-16","family":"terminal_procedures","artifact_role":"dtpp_metafile_xml","artifact_kind":"metafile","required":true,"sequence":99,"status":"extracted","source_url":"https://aeronav.faa.gov/d-tpp/2604/xml_data/d-TPP_Metafile.xml","filename":"d-TPP_Metafile.xml","http_status_code":200,"remote_size_bytes":20,"remote_last_modified_at":"2026-03-25T18:08:59","remote_etag":"\"1d55e7482bcdc1:0\"","discovered_at":"2026-04-01T02:05:26.011137","available_at":"2026-04-01T00:10:18.067767","local_relative_path":"raw/2026-04-16/terminal_procedures/d-TPP_Metafile.xml","downloaded_at":"2026-04-01T02:05:59.341424","extracted_relative_path":"raw/2026-04-16/terminal_procedures/d-TPP_Metafile.xml","extracted_at":"2026-04-01T02:05:59.344329","last_error":null,"next_job_type":"upsert_chart_inventory","next_job_status":"succeeded"},{"id":"bfc7ade0-36e4-4e55-b5be-88d988800aa5","publication_cycle_id":"460452ca-8c5f-476b-9f33-c2c99c6d8836","publication_cycle_date":"2026-04-16","family":"vfr_caribbean","artifact_role":"caribbean","artifact_kind":"archive","required":true,"sequence":0,"status":"missing","source_url":"https://aeronav.faa.gov/visual/04-16-2026/All_Files/Caribbean.zip","filename":"Caribbean.zip","http_status_code":404,"remote_size_bytes":null,"remote_last_modified_at":null,"remote_etag":null,"discovered_at":"2026-04-01T02:05:26.011137","available_at":null,"local_relative_path":null,"downloaded_at":null,"extracted_relative_path":null,"extracted_at":null,"last_error":null,"next_job_type":null,"next_job_status":null},{"id":"b376959b-4ea0-4655-b337-55d1779c826a","publication_cycle_id":"61b4119c-298d-4b75-b9aa-8550de043455","publication_cycle_date":"2026-04-16","family":"vfr_grand_canyon","artifact_role":"grand_canyon","artifact_kind":"archive","required":true,"sequence":0,"status":"missing","source_url":"https://aeronav.faa.gov/visual/04-16-2026/All_Files/Grand_Canyon.zip","filename":"Grand_Canyon.zip","http_status_code":404,"remote_size_bytes":null,"remote_last_modified_at":null,"remote_etag":null,"discovered_at":"2026-04-01T02:05:26.011137","available_at":null,"local_relative_path":null,"downloaded_at":null,"extracted_relative_path":null,"extracted_at":null,"last_error":null,"next_job_type":null,"next_job_status":null},{"id":"d390c81f-5e36-40dc-b102-2ac3ef970c36","publication_cycle_id":"1f6adcc4-8c18-4aac-ab9d-387077271363","publication_cycle_date":"2026-05-14","family":"terminal_procedures","artifact_role":"ddtppd_zip","artifact_kind":"archive","required":true,"sequence":4,"status":"missing","source_url":"https://aeronav.faa.gov/Upload_313-d/terminal/DDTPPD_260514.zip","filename":"DDTPPD_260514.zip","http_status_code":404,"remote_size_bytes":null,"remote_last_modified_at":null,"remote_etag":null,"discovered_at":"2026-04-01T02:05:26.011137","available_at":null,"local_relative_path":null,"downloaded_at":null,"extracted_relative_path":null,"extracted_at":null,"last_error":null,"next_job_type":null,"next_job_status":null},{"id":"0a714bb2-5588-40e0-b4ca-765147cacf7d","publication_cycle_id":"1f6adcc4-8c18-4aac-ab9d-387077271363","publication_cycle_date":"2026-05-14","family":"terminal_procedures","artifact_role":"ddtppe_zip","artifact_kind":"archive","required":true,"sequence":5,"status":"missing","source_url":"https://aeronav.faa.gov/Upload_313-d/terminal/DDTPPE_260514.zip","filename":"DDTPPE_260514.zip","http_status_code":404,"remote_size_bytes":null,"remote_last_modified_at":null,"remote_etag":null,"discovered_at":"2026-04-01T02:05:26.011137","available_at":null,"local_relative_path":null,"downloaded_at":null,"extracted_relative_path":null,"extracted_at":null,"last_error":null,"next_job_type":null,"next_job_status":null},{"id":"14f38ad3-a402-4288-9c08-276eb0d6794c","publication_cycle_id":"1f6adcc4-8c18-4aac-ab9d-387077271363","publication_cycle_date":"2026-05-14","family":"terminal_procedures","artifact_role":"dtpp_metafile_xml","artifact_kind":"metafile","required":true,"sequence":99,"status":"missing","source_url":"https://aeronav.faa.gov/d-tpp/2605/xml_data/d-TPP_Metafile.xml","filename":"d-TPP_Metafile.xml","http_status_code":404,"remote_size_bytes":null,"remote_last_modified_at":null,"remote_etag":null,"discovered_at":"2026-04-01T02:05:26.011137","available_at":null,"local_relative_path":null,"downloaded_at":null,"extracted_relative_path":null,"extracted_at":null,"last_error":null,"next_job_type":null,"next_job_status":null},{"id":"cbb1dca8-6aa0-473e-8347-c34136b9608c","publication_cycle_id":"e4d95f8f-47dc-4028-bf3f-b6e23b0b91da","publication_cycle_date":"2026-05-14","family":"vfr_caribbean","artifact_role":"caribbean","artifact_kind":"archive","required":true,"sequence":0,"status":"missing","source_url":"https://aeronav.faa.gov/visual/05-14-2026/All_Files/Caribbean.zip","filename":"Caribbean.zip","http_status_code":404,"remote_size_bytes":null,"remote_last_modified_at":null,"remote_etag":null,"discovered_at":"2026-04-01T02:05:26.011137","available_at":null,"local_relative_path":null,"downloaded_at":null,"extracted_relative_path":null,"extracted_at":null,"last_error":null,"next_job_type":null,"next_job_status":null},{"id":"98a180e3-b836-4247-8ac0-7b36168a7903","publication_cycle_id":"635063a2-8a85-4971-9d16-cf766acfe4d2","publication_cycle_date":"2026-05-14","family":"vfr_grand_canyon","artifact_role":"grand_canyon","artifact_kind":"archive","required":true,"sequence":0,"status":"missing","source_url":"https://aeronav.faa.gov/visual/05-14-2026/All_Files/Grand_Canyon.zip","filename":"Grand_Canyon.zip","http_status_code":404,"remote_size_bytes":null,"remote_last_modified_at":null,"remote_etag":null,"discovered_at":"2026-04-01T02:05:26.011137","available_at":null,"local_relative_path":null,"downloaded_at":null,"extracted_relative_path":null,"extracted_at":null,"last_error":null,"next_job_type":null,"next_job_status":null},{"id":"0f220f3e-9a1d-490e-b3a0-b71356178a38","publication_cycle_id":"d8759c3e-fc66-49af-8758-0ca1977b6733","publication_cycle_date":"2026-05-14","family":"vfr_helicopter","artifact_role":"helicopter","artifact_kind":"archive","required":true,"sequence":0,"status":"missing","source_url":"https://aeronav.faa.gov/visual/05-14-2026/All_Files/Helicopter.zip","filename":"Helicopter.zip","http_status_code":404,"remote_size_bytes":null,"remote_last_modified_at":null,"remote_etag":null,"discovered_at":"2026-04-01T02:05:26.011137","available_at":null,"local_relative_path":null,"downloaded_at":null,"extracted_relative_path":null,"extracted_at":null,"last_error":null,"next_job_type":null,"next_job_status":null},{"id":"2e68bf58-250d-429a-81ae-9babfacb200d","publication_cycle_id":"f6f177d3-7ebe-4262-8b1c-5fb17fd9b2b7","publication_cycle_date":"2026-05-14","family":"vfr_planning","artifact_role":"planning","artifact_kind":"archive","required":true,"sequence":0,"status":"missing","source_url":"https://aeronav.faa.gov/visual/05-14-2026/All_Files/Planning.zip","filename":"Planning.zip","http_status_code":404,"remote_size_bytes":null,"remote_last_modified_at":null,"remote_etag":null,"discovered_at":"2026-04-01T02:05:26.011137","available_at":null,"local_relative_path":null,"downloaded_at":null,"extracted_relative_path":null,"extracted_at":null,"last_error":null,"next_job_type":null,"next_job_status":null},{"id":"4461f46d-b9b5-43a8-ad9c-f18842ea7b1d","publication_cycle_id":"c22ad2e1-d7c5-4772-b0c3-939f62513b8f","publication_cycle_date":"2026-05-14","family":"vfr_sectional","artifact_role":"sectional","artifact_kind":"archive","required":true,"sequence":0,"status":"missing","source_url":"https://aeronav.faa.gov/visual/05-14-2026/All_Files/Sectional.zip","filename":"Sectional.zip","http_status_code":404,"remote_size_bytes":null,"remote_last_modified_at":null,"remote_etag":null,"discovered_at":"2026-04-01T02:05:26.011137","available_at":null,"local_relative_path":null,"downloaded_at":null,"extracted_relative_path":null,"extracted_at":null,"last_error":null,"next_job_type":null,"next_job_status":null},{"id":"a6f94106-ebd7-4e24-b945-c4a7d80418d4","publication_cycle_id":"ef61b95d-aa4c-4c20-89bf-e25d64118e3a","publication_cycle_date":"2026-05-14","family":"vfr_terminal","artifact_role":"terminal","artifact_kind":"archive","required":true,"sequence":0,"status":"missing","source_url":"https://aeronav.faa.gov/visual/05-14-2026/All_Files/Terminal.zip","filename":"Terminal.zip","http_status_code":404,"remote_size_bytes":null,"remote_last_modified_at":null,"remote_etag":null,"discovered_at":"2026-04-01T02:05:26.011137","available_at":null,"local_relative_path":null,"downloaded_at":null,"extracted_relative_path":null,"extracted_at":null,"last_error":null,"next_job_type":null,"next_job_status":null},{"id":"3fa469db-5c30-4ba4-8a22-79a7f2cfb9ab","publication_cycle_id":"b7c8770a-7f74-4d26-96b0-d5dcf36ecb26","publication_cycle_date":"2026-05-14","family":"ifr_enroute","artifact_role":"ddecus_zip","artifact_kind":"archive","required":true,"sequence":0,"status":"missing","source_url":"https://aeronav.faa.gov/enroute/05-14-2026/DDECUS.zip","filename":"DDECUS.zip","http_status_code":404,"remote_size_bytes":null,"remote_last_modified_at":null,"remote_etag":null,"discovered_at":"2026-04-01T02:05:26.011137","available_at":null,"local_relative_path":null,"downloaded_at":null,"extracted_relative_path":null,"extracted_at":null,"last_error":null,"next_job_type":null,"next_job_status":null},{"id":"326ea0c1-c887-40b9-87cc-46439c37aad7","publication_cycle_id":"1f6adcc4-8c18-4aac-ab9d-387077271363","publication_cycle_date":"2026-05-14","family":"terminal_procedures","artifact_role":"ddtppa_zip","artifact_kind":"archive","required":true,"sequence":1,"status":"missing","source_url":"https://aeronav.faa.gov/Upload_313-d/terminal/DDTPPA_260514.zip","filename":"DDTPPA_260514.zip","http_status_code":404,"remote_size_bytes":null,"remote_last_modified_at":null,"remote_etag":null,"discovered_at":"2026-04-01T02:05:26.011137","available_at":null,"local_relative_path":null,"downloaded_at":null,"extracted_relative_path":null,"extracted_at":null,"last_error":null,"next_job_type":null,"next_job_status":null},{"id":"1576aea9-1e54-40d7-a602-20308d334187","publication_cycle_id":"1f6adcc4-8c18-4aac-ab9d-387077271363","publication_cycle_date":"2026-05-14","family":"terminal_procedures","artifact_role":"ddtppb_zip","artifact_kind":"archive","required":true,"sequence":2,"status":"missing","source_url":"https://aeronav.faa.gov/Upload_313-d/terminal/DDTPPB_260514.zip","filename":"DDTPPB_260514.zip","http_status_code":404,"remote_size_bytes":null,"remote_last_modified_at":null,"remote_etag":null,"discovered_at":"2026-04-01T02:05:26.011137","available_at":null,"local_relative_path":null,"downloaded_at":null,"extracted_relative_path":null,"extracted_at":null,"last_error":null,"next_job_type":null,"next_job_status":null},{"id":"543a6af5-a4e1-426b-a597-8094bc9db657","publication_cycle_id":"1f6adcc4-8c18-4aac-ab9d-387077271363","publication_cycle_date":"2026-05-14","family":"terminal_procedures","artifact_role":"ddtppc_zip","artifact_kind":"archive","required":true,"sequence":3,"status":"missing","source_url":"https://aeronav.faa.gov/Upload_313-d/terminal/DDTPPC_260514.zip","filename":"DDTPPC_260514.zip","http_status_code":404,"remote_size_bytes":null,"remote_last_modified_at":null,"remote_etag":null,"discovered_at":"2026-04-01T02:05:26.011137","available_at":null,"local_relative_path":null,"downloaded_at":null,"extracted_relative_path":null,"extracted_at":null,"last_error":null,"next_job_type":null,"next_job_status":null}]