What was found
CRACK NOTED IN BOTTOM LAYER OF HOLE AT RBL 45.5 SEAT TRACK AT BS-727B. ; / [01] REMOVED FASTNERS IN H BRACKET BS 727B RBL 45.5 PER SRM 51-40-02-OG-0; [02] ET INSPECTED HOLE IAW 737 NDTM PART 6 51-00-00 PROCEDURE 16; NO CRACKS NOTED.<BR><BR>CAL ID ATS1645 N600; [03] COMPLETED H-BRACKET REMOVAL PRIOR TO NDT OPEN HOLE INSPECTION; [04] UPDATED MEASUREMENTS TABLE; [05] VERIFIED MEASUREMENT TABLE; [06] FINAL HOLE SIZE MEASURED AT .246' USING BALL GAUGE ATS S829EZ-H3-1; CALIPER ATS1317;S/N:NSN;DUE 06/2022; [07] VERIFIED FINAL HOLE SIZE.; [08] LOCATED AND DRILLED NEW STRAP P/N 146A5342-26 AT BS 727B RBL 45.5 WL207 IAW SRM 51-40-05-OG-0; [09] OK TO INSTALL NEW STRAP P/N 146A5342-26; [10] VERIFIED STEPS 8 AND 9 OK TO INSTALL; [11] INSTALLED NEW STRAP IAW SRM 51-40-02-OG-0; [12] INSTALLED NEW STRAP IAW SRM 51-40-02-OG-0; [13] COMPLETED INSTALLATION OF STRAP P/N 146A5342-26 AT BS 727B RBL 45.5 WL207 IAW SRM 51-40-02-OG-O; [14] COMPLETED INSTALLATION OF STRAP P/N 146A5342-26 AT BS 727B RBL 45.5 WL207 IAW SRM 51-40-02-OG-O AND SB 737-53-1296; [15] UPDATED INSTALLATION REFERENCE TO INCLUDE SERVICE BULLETIN; [16] VERIFIED INSTALLATION OF STRAP P/N 146A5342-26 AT BS 727B RBL 45.5 WL207 IAW SRM 51-40-02-OG-O AND SB 737-53-1296; [17] COMPLETE
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 ('SWAA2021081191813') 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 ('SWAA2021081191813') 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.