Boeing SB 757-54-0035
Service difficulty reports that cite it · 11
Newest first, with the revision each cites, as OpenAirDocs read it from the records’ text. OpenAirDocs read these citations from the records’ text, so one can be misread: check it against the record. A newer revision may exist that no record cites.
Query with SQL
duckdb -csv -c "SELECT s.sdr_id, s.difficulty_date, s.aircraft_make, s.aircraft_model, s.part_name, string_agg(DISTINCT c.revision, ', ' ORDER BY c.revision) AS revisions,
bool_or(c.incorporated_by_reference) AS incorporated_by_reference, bool_or(c.in_regulatory_text) AS in_regulatory_text
FROM 'https://openairdocs.org/data/latest/service_document_citation.parquet' c JOIN 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet' s ON s.sdr_id = c.record_id
WHERE c.document_id = 'boeing/sb-757-54-0035' AND c.record_type = 'faa_service_difficulty_report'
GROUP BY ALL
ORDER BY max(c.record_date) DESC"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 s.sdr_id, s.difficulty_date, s.aircraft_make, s.aircraft_model, s.part_name, string_agg(DISTINCT c.revision, ', ' ORDER BY c.revision) AS revisions, bool_or(c.incorporated_by_reference) AS incorporated_by_reference, bool_or(c.in_regulatory_text) AS in_regulatory_text FROM 'https://openairdocs.org/data/latest/service_document_citation.parquet' c JOIN 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet' s ON s.sdr_id = c.record_id WHERE c.document_id = 'boeing/sb-757-54-0035' AND c.record_type = 'faa_service_difficulty_report' GROUP BY ALL ORDER BY max(c.record_date) DESC
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.
SDR IPXA2022032680523Shear Tie · Boeing 75724APFINSPECTION TYPE:SEG2#2 PYLON AFT REAR STRUT ASSY RH SIDE SHEAR CLIP P/N 311N5220-45 WAS FOUND TO BE CRACKED DURING PYLON SKIN REPLACEMENTREMOVED AND INSTALLED REPLACEMENT SHEAR CLIP PER SRM 51-40-02, SDR FDEA201310072444Structure · Boeing 757236HOLE ON LT WING FOUND TO BE .375 SHOULD BE .308 -.313. FOUND DURING SB 757-54-0035, REV 6. COMPLIED WITH EA F-5710-T0300911. CLASSIFIED AS A CATEGORY B, MAJOR REPAIR.SDR FDEA201302070290Skin · Boeing 757204NR 2 NACELLE STRUT PYLON STRUCTURE INBD SKIN AT PPSTA 185.0 FOUND BULGING. REPAIRED IAW EA F-5450-16290, PART 1. AD 2004-12-07, EO F-5450-7-5003, SB 757-54-0035 R4. MAJOR REPAIR.SDR FDEA201205041736Bushing · Boeing 757225NR 2 PYLON MID SPAR ATTACH FITTING LUG RT SIDE BUSHING MIGRATED. (RT SIDE) ACFT SIDE. REMOVED MIGRATED BUSHING IAW SOPM-20-50-03. NO CORROSION NOTED, MEASURED LUG BORE AND IT IS 1.8140 FOUND TO BE OVESDR FDEA200909123292Skin · Boeing 75728ART NAC- FWD INBD SKIN INNER WALL CORRODED, JUST AFT OF 443 GL ACCESS PANEL CUT-OUT. REMOVED CORROSION IAW SRM 54-50-01 FIG 101 L=1.0 INCH, W=1.0 INCH, D=0.035 INCH, ORIGINAL MAT. 0.90 INCH, MAT REMAINSDR 08FDEA02345None · Boeing 7572B7ACCOMPLISH SB 757-54-0035, R2, PARA 3, PART 2; WING STRUCTURE CHANGES FOR THE NR 2 STRUT AND RT WING PER EA F-5450-108907, DATED 11 OCT 2007. ACCOMPLISHED SB 757-54-0035, PART 2, ON NR 2 STRUT, AS PERSDR 08FDEA02346None · Boeing 7572B7ACCOMPLISHED BOEING SB 757-54-0035, R2, PARA. 3, PART 3, STRUCTURE CHANGES FOR THE NR 2 STRUT, EXCEPT STEO Q, PANEL 5, PER FEDEX EA F-5450-108907, DATED 11 OCT 2007. COMPLIED WITH FEDEX EA F-5450-1089SDR 08FDEA00265Panel · Boeing 7572B7NR 1 NACELLE STRUT I/B SKIN PANEL ASSY PN: 311N5046-34 HAS AREAS OF CORROSION C/M TO THE INNER SKIN SURFACE BETWEEN PP STA 153.9 AND PP 176 REMOVED CORROSION IAW SRM 54-50-01. ORIGINAL MATERIAL THICKNSDR 07FDEA04710Fitting · Boeing 7572B7RT WING I/B LOAD FITTING HAS 3 FASTENER HOLES DAMAGED COMMON TO THE SIDE LOAD FITTING. REF S/B 757-54-0035 FIG 7, PANEL 3, STEPS 2 AND 3 IAW EA NR F-5450-108908, REAMED EACH HOLE TO REMOVE DAMAGE. ACCSDR AWXA200600648Shim · Boeing 7572G7GYR - DURING C12 CHECK DISCOVERED NR 1 PYLON DIAGONAL BRACE FITTING SHIMS MIGRATING LEFT SHIM HORIZONTAL MOVEMENT 0.400 INCHES AND VERTICAL MOVEMENT 0.900 INCHES. MAINTENANCE REPAIRED PER AWA ER 19-54SDR AWXA200500763Fitting · Boeing 7572S7DURING C-10 CHECK, FOUND ELONGATED HOLE ON THE RT WING SIDE LOAD DRAG FITTING. MAINTENANCE OVERSIZED THE HOLE IAW AMERICA WEST AIRLINES (AWA) ENGINEERING REPAIR (ER) 19-5704-05175-ES3. FABRICATED BUSH
Back to Boeing SB 757-54-0035