What was found
HEAVY CHECK, FOUND OPEN HOLES BENEATH AFT CARGO DOOR FWD AND AFT UPPER HINGE HALVES BETWEEN FRAMES 37 AND 39 AND BETWEEN STRINGERS 5L AND 6L. FOUND WHILE ACCOMPLISHING M7 SB ATR42-53-030 & EO 5344-05) REPAIRED PER M7 DRAWING, PERFORMED STEP 1 THRU 6 OF DRAWING 42-470000 SFO-3.
Service documents this report cites · 1
Manufacturers’ service documents named in its text, as OpenAirDocs read them: check each against the text. “Copy” marks those OpenAirDocs holds.
Query with SQL
duckdb -csv -c "SELECT d.issuer, d.type_label, d.number, c.revision, c.revision_date, c.cited_as, c.incorporated_by_reference, c.in_regulatory_text,
'https://openairdocs.org/service-documents/' || d.document_id AS page_url
FROM 'https://openairdocs.org/data/latest/service_document_citation.parquet' c JOIN 'https://openairdocs.org/data/latest/service_document.parquet' d USING (document_id)
WHERE c.record_type = 'faa_service_difficulty_report' AND c.record_id IN ('COEA2012022114908') AND d.issuer_kind <> 'authority'
QUALIFY row_number() OVER (PARTITION BY c.document_id, c.revision_key ORDER BY c.record_date DESC) = 1
ORDER BY c.incorporated_by_reference DESC, c.in_regulatory_text DESC, d.document_id, c.revision_key"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 d.issuer, d.type_label, d.number, c.revision, c.revision_date, c.cited_as, c.incorporated_by_reference, c.in_regulatory_text,
'https://openairdocs.org/service-documents/' || d.document_id AS page_url
FROM 'https://openairdocs.org/data/latest/service_document_citation.parquet' c JOIN 'https://openairdocs.org/data/latest/service_document.parquet' d USING (document_id)
WHERE c.record_type = 'faa_service_difficulty_report' AND c.record_id IN ('COEA2012022114908') AND d.issuer_kind <> 'authority'
QUALIFY row_number() OVER (PARTITION BY c.document_id, c.revision_key ORDER BY c.record_date DESC) = 1
ORDER BY c.incorporated_by_reference DESC, c.in_regulatory_text DESC, d.document_id, c.revision_keyRun 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.