ATR service documents: with those not held
315 documents from ATR, 59 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.
315 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 = 'atr'
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 = 'atr' 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 Bulletin
72-53-1078no copy92-1051-00138-25-008no copyATR 42-25-0006no copyATR 42-30-0021no copyATR 42-79-0002no copyATR-42-30-0011no copyATR42-21-0069no copyATR42-22-0012no copyATR42-22-0015no copyATR42-23-0002no copyATR42-23-0018no copyATR42-24-0062ATR42-25-0075no copyATR42-25-0082no copyATR42-25-0084no copyATR42-25-0094no copyATR42-25-0108no copyATR42-25-0134no copyATR42-25-0141no copyATR42-25-0155no copyATR42-25-0180ATR42-25-0185ATR42-25-0186ATR42-25-0191no copyATR42-25-1034no copyATR42-26-0010no copyATR42-26-0023no copyATR42-26-0031ATR42-27-0004no copyATR42-27-0010no copyATR42-27-0014no copyATR42-27-0015no copyATR42-27-0021no copyATR42-27-0027no copyATR42-27-0046no copyATR42-27-0048no copyATR42-27-0049no copyATR42-27-0050no copyATR42-27-0051no copyATR42-27-0052no copyATR42-27-0058no copyATR42-27-0068no copyATR42-27-0069no copyATR42-27-0070no copyATR42-27-0071no copyATR42-27-0081no copyATR42-27-0083no copyATR42-27-0092no copyATR42-27-0098no copy