BAE Systems service documents: with those not held
777 documents from BAE Systems, 40 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.
777 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 = 'bae-systems'
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 = 'bae-systems' 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
27-95-70420Ano copy27-112no copy27-114-01028Bno copy27-125no copy27-140no copy27-142no copy27-149no copy27-150-01510Bno copy27-155no copy27-A-JAno copy27-A-JM7328no copy27-A105no copy27-JAno copy27-JA18104027-JMno copy27-JM-5257no copy27-JM535027-JM7861no copy27/110no copy28-67no copy28-69no copy28-86no copy28-87no copy28-A23no copy28-A66no copy28-JA850911no copy28-JMno copy28-JM8226no copy29-31-01339Ano copy29-89-3269Ano copy29-JAno copy29-JMno copy29A 35-3171no copy30-JAno copy30-JKno copy30-JMno copy30-JM-7453no copy32-18no copy32-19no copy32-29no copy32-32no copy32-3632-46no copy32-73no copy32-104-01159Ano copy32-131no copy32-143no copy32-144no copy32-145no copy32-150-70656Ano copy