Pacific Aerospace service documents: with those not held
53 documents from Pacific Aerospace, 17 of them held. Manufacturers’ service bulletins, letters and instructions that OpenAirDocs holds a copy of, as the FAA filed them in AD dockets on regulations.gov, with their text. Each copy belongs to its rights holder and isn’t covered by OpenAirDocs’ CC0 dedication. A newer revision may exist: ask the manufacturer.
Showing the documents FAA records cite that OpenAirDocs holds no PDF of too, marked “no copy”. Show only documents with PDFs
Query with SQL
duckdb -csv -c "SELECT document_id, issuer, type_label, number, title, latest_revision, latest_revision_date, has_file
FROM 'https://openairdocs.org/data/latest/service_document.parquet'
WHERE issuer_kind <> 'authority'
AND issuer_key = 'pacific-aerospace'
ORDER BY type_label, number"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 document_id, issuer, type_label, number, title, latest_revision, latest_revision_date, has_file FROM 'https://openairdocs.org/data/latest/service_document.parquet' WHERE issuer_kind <> 'authority' AND issuer_key = 'pacific-aerospace' ORDER BY type_label, number
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.