ADs that cite this AC · 16

duckdb -csv -c "SELECT d.ad_number, d.status, d.subject, d.effective_date, min(x.cited_as) AS cited_as
  FROM 'https://openairdocs.org/data/latest/faa_directive_ac.parquet' x JOIN 'https://openairdocs.org/data/latest/faa_directive.parquet' d USING (ad_id)
  WHERE x.ac_family = 'AC 20-176'
  GROUP BY d.ad_id, d.ad_number, d.status, d.subject, d.effective_date, d.publication_date
  ORDER BY coalesce(d.effective_date, d.publication_date) DESC"

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 d.ad_number, d.status, d.subject, d.effective_date, min(x.cited_as) AS cited_as
FROM 'https://openairdocs.org/data/latest/faa_directive_ac.parquet' x JOIN 'https://openairdocs.org/data/latest/faa_directive.parquet' d USING (ad_id)
WHERE x.ac_family = 'AC 20-176'
GROUP BY d.ad_id, d.ad_number, d.status, d.subject, d.effective_date, d.publication_date
ORDER BY coalesce(d.effective_date, d.publication_date) DESC

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.