What was found
NR 3 HOLE ON FIGURE 8, AREA ON RT PAX DOOR INDICATED AS CRACKED WHEN CHECKED BY BHEC IAW NDT MANUAL 53-30-53 USING MACHINE T8209A. REAMED HOLE IN REF TO SRM 51-40-51. PERFORMED BHEC IAW NTM 53-30-53-NO CRACKS FOUND. FABRICATED REPAIR BUSHING, PRIMED, PAINTED AND INSTALLED REPAIR BUSHING AND FASTENER IN REF TO EA 6-5310-112988 PT1, "FUSELAGE-AD2007-11-12, SB A310-53-2037, SB A310-53-2017, EO 6-5310-7-3318, RI DOOR UPPER HEADER AT FR14C-REPAIR"
Service documents this report cites · 2
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 ('07FDEA04863') 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 ('07FDEA04863') 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.