Piper service documents: service letters, with those not held
526 documents from Piper, 32 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.
106 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 = 'piper'
AND document_type = 'service_letter'
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 = 'piper' AND document_type = 'service_letter' 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.
Service Letter
124no copy129no copy162no copy165no copy213no copy225no copy250no copy291no copy305no copy322no copy324no copy355no copy356no copy362no copy364no copy366no copy367no copy379no copy389no copy396no copy400no copy405no copy407no copy409no copy420no copy428no copy445no copy451no copy455no copy462no copy463no copy471no copy476no copy478no copy516no copy518no copy527no copy533no copy534no copy552no copy568no copy576no copy580no copy588no copy589no copy590no copy595no copy600no copy600-60no copy606no copy