Proposed ADs that cite it · 4

Newest first, with the revision each cites, as OpenAirDocs read it from the records’ text. OpenAirDocs read these citations from the records’ text, so one can be misread: check it against the record. A newer revision may exist that no record cites.

Query with SQL

SELECT coalesce(p.docket_number, p.fr_document_number, p.proposal_id) AS docket, max(p.publication_date) AS published, string_agg(DISTINCT c.revision, ', ' ORDER BY c.revision) AS revisions, bool_or(c.incorporated_by_reference) AS incorporated_by_reference, bool_or(c.in_regulatory_text) AS in_regulatory_text FROM 'https://openairdocs.org/data/latest/service_document_citation.parquet' c JOIN 'https://openairdocs.org/data/latest/faa_proposed_directive.parquet' p ON p.proposal_id = c.record_id WHERE c.document_id = 'shaw/10101000c-38-2' AND c.record_type = 'faa_proposed_directive' GROUP BY ALL ORDER BY max(c.record_date) DESC

duckdb -csv -c "SELECT coalesce(p.docket_number, p.fr_document_number, p.proposal_id) AS docket, max(p.publication_date) AS published, string_agg(DISTINCT c.revision, ', ' ORDER BY c.revision) AS revisions,
    bool_or(c.incorporated_by_reference) AS incorporated_by_reference, bool_or(c.in_regulatory_text) AS in_regulatory_text
  FROM 'https://openairdocs.org/data/latest/service_document_citation.parquet' c JOIN 'https://openairdocs.org/data/latest/faa_proposed_directive.parquet' p ON p.proposal_id = c.record_id
  WHERE c.document_id = 'shaw/10101000c-38-2' AND c.record_type = 'faa_proposed_directive'
  GROUP BY ALL
  ORDER BY max(c.record_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 coalesce(p.docket_number, p.fr_document_number, p.proposal_id) AS docket, max(p.publication_date) AS published, string_agg(DISTINCT c.revision, ', ' ORDER BY c.revision) AS revisions,
  bool_or(c.incorporated_by_reference) AS incorporated_by_reference, bool_or(c.in_regulatory_text) AS in_regulatory_text
FROM 'https://openairdocs.org/data/latest/service_document_citation.parquet' c JOIN 'https://openairdocs.org/data/latest/faa_proposed_directive.parquet' p ON p.proposal_id = c.record_id
WHERE c.document_id = 'shaw/10101000c-38-2' AND c.record_type = 'faa_proposed_directive'
GROUP BY ALL
ORDER BY max(c.record_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.

NPRM 98-NM-200-ADLockheedPublished Sep 11, 2006 · No revision named NPRM 98-18158Airworthiness Directives; McDonnell Douglas Model DC-8 Series AirplanesPublished Jul 9, 1998 · No revision named NPRM 97-NM-325-ADAirworthiness Directives; Boeing Model 747-100, -200, -300, -SP, and -400F Series AirplanesPublished Jun 15, 1998 · No revision named NPRM 95-NM-111-ADAirworthiness Directives; Boeing Model 737-100, -200, -300, -400, and -500 Series AirplanesPublished Nov 25, 1997 · No revision named

Back to Shaw SB 10101000C-38-2