JASC codes

duckdb -csv -c "SELECT j.jasc_code, j.ata_chapter, j.chapter_title, j.title, count(s.sdr_id) AS reports
  FROM 'https://openairdocs.org/data/latest/faa_jasc_code.parquet' j LEFT JOIN 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet' s ON s.jasc_code = j.jasc_code
  GROUP BY ALL
  ORDER BY j.jasc_code"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

SELECT j.jasc_code, j.ata_chapter, j.chapter_title, j.title, count(s.sdr_id) AS reports
FROM 'https://openairdocs.org/data/latest/faa_jasc_code.parquet' j LEFT JOIN 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet' s ON s.jasc_code = j.jasc_code
GROUP BY ALL
ORDER BY j.jasc_code

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.