Sikorsky service documents: with those not held

233 documents from Sikorsky, 39 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.

233 documents

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 = 'sikorsky'
  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 = 'sikorsky'
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.

Alert Service Bulletin