# Transport / Aviation Alternatives Log

**Date:** 2026-06-18  
**Scope:** NCAA 2023 Q2–Q4 executive summaries; FRSC Annual Reports 2020–2023  
**Output folder:** `C:\Users\HP\palmgrove\NEFDB\datasets\transport_aviation\`

---

## 1. NCAA 2023 Q2–Q4 Executive Summaries

### Search performed
- Crawled NCAA `/media/news/` listing pages 1–19 (≈380 entries) for 2023 posts.
- Queried NCAA site search for:
  - `quarterly executive summary 2023`
  - `executive summary April June 2023`
  - `executive summary July September 2023`
  - `executive summary October December 2023`
  - `Q2 2023 executive summary`, `Q3 2023 executive summary`, `Q4 2023 executive summary`
- Probed common slug patterns (all returned HTTP 404):
  - `executive-summary-on-international-and-domestic-flight-operations-april-june-2023/`
  - `...-july-september-2023/`
  - `...-october-december-2023/`
  - `...-q2-2023/`, `...-q3-2023/`, `...-q4-2023/`
- Checked Wayback Machine CDX for `ncaa.gov.ng/media/*2023*.pptx/pdf` and `*executive*` news pages — no archived snapshots.
- Verified only NCAA 2023 quarterly executive summary on the site is **Q1 (January – March, 2023)** at:  
  `https://ncaa.gov.ng/media/news/executive-summary-on-international-and-domestic-flight-operations-january-march-2023/`

### Result
| Item | Status | Page URL | File URL | Note |
|------|--------|----------|----------|------|
| NCAA Q1 2023 Executive Summary | Found (not requested) | https://ncaa.gov.ng/media/news/executive-summary-on-international-and-domestic-flight-operations-january-march-2023/ | https://ncaa.gov.ng/media/0rdkglzs/quaterlty-report-january-march-2023-3.pptx | Not downloaded — only Q1 exists |
| NCAA Q2 2023 Executive Summary | **Not found** | — | — | No news post or attachment located |
| NCAA Q3 2023 Executive Summary | **Not found** | — | — | No news post or attachment located |
| NCAA Q4 2023 Executive Summary | **Not found** | — | — | No news post or attachment located |

**Conclusion:** NCAA did not publish separate Q2–Q4 2023 executive summary posts/attachments on `ncaa.gov.ng/media/news/` as of this search. Only Q1 2023 and annual summaries for 2019–2022 exist.

---

## 2. FRSC Annual Reports 2020–2023

### Source discovered
The current FRSC site (`https://frsc.gov.ng/documentations/annual-reports/`) loads data from a Strapi CMS endpoint:  
`https://staging.frsc.gov.ng/frsc-admin/api/publications?filters[category][id]=18&filters[isActive]=true&sort[0]=year:desc&sort[1]=orderIndex:asc&pagination[limit]=500&populate=*`

This API exposes direct PDF URLs for all years. The old `old.frsc.gov.ng/annual-reports/` archive remains unreachable.

### Downloaded files

| Year | Source URL | Saved file | Size | Status |
|------|------------|------------|------|--------|
| 2020 | https://frsc.gov.ng/wp-content/uploads/2022/11/2020-ANNUAL-REPORT-COMPLETE-WORK3_compressed.pdf | `FRSC_Annual_Report_2020.pdf` | 45.3 MB | Downloaded, magic header `%PDF` |
| 2021 | https://frsc.gov.ng/wp-content/uploads/2022/11/2021-ANNUAL-REPORT-1.pdf | `FRSC_Annual_Report_2021.pdf` | 224.3 MB | Downloaded, magic header `%PDF` |
| 2022 | https://staging.frsc.gov.ng/frsc-admin/uploads/2022_ANNUAL_REPORT_1_14_compressed_8279ef83c7.pdf | `FRSC_Annual_Report_2022.pdf` | 37.7 MB | Downloaded, magic header `%PDF` |
| 2023 | https://staging.frsc.gov.ng/frsc-admin/uploads/2023_ANNUAL_REPORT_1_compressed_2d222e78c9.pdf | `FRSC_Annual_Report_2023.pdf` | 28.2 MB | Downloaded, magic header `%PDF` |

All four PDFs were saved to:  
`C:\Users\HP\palmgrove\NEFDB\datasets\transport_aviation\`

---

## Summary

- **NCAA 2023 Q2–Q4 executive summaries:** No public PPTX/PDF alternatives found on the NCAA website or in web archives. Only the Q1 2023 summary is publicly posted.
- **FRSC Annual Reports 2020–2023:** Successfully retrieved from the current FRSC CMS API after the legacy archive (`old.frsc.gov.ng/annual-reports/`) failed. All four PDFs are saved and verified.