Boeing SB 737-53-1170
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-737-53-1170' 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-737-53-1170' 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 DL73K010979Keelbeam · Boeing 737232THE RT STRINGER 18A SHEAR BEAM AT FS 727 WAS FOUND WITH A 2 INCH CRACK. THE CRACK IS SIMILAR TO BAC S/B 737-53-1170, EXCEPT THE SB IS NOT EFFECTIVE FOR THIS AIRCRAFT. THE CRACK WAS STOP DRILLED AND RESDR USAA010670Stringer · Boeing 737301CLT - FOUND 18A SHELF CRACKED .5 INCH, LEFT WHEEL WELL, BS 725, LBL 62. REMOVED AND REPLACED 18A SHELF PER EA69680 AND SB 737-53-1170. (M)SDR DL73S010764Web · Boeing 737232CRACKS WERE FOUND IN LT AND RT STR 18A AT FS 727. THE CRACKS ARE SIMILIAR TO THAT IN S/B 737-53-1170. THE WEBS WERE REPLACED AND THE PREVENTATIVE MODIFICATION WAS ACCOMPLISHED AT HMV.SDR DL73K000892Stringer · Boeing 737232CRACKS WERE DISCOVERED ON THE WEB OF STR 18AL AT FS 727. ERA 334331-14 REPAIRS THE DAMAGE SIMILIARLY TO THAT OF S/B 737-53-1170. THE DAMAGE WAS FOUND AT HMV.SDR DL73K000660Stringer · Boeing 737247A CRACK WAS FOUND IN THE WEB OF STRINGER R18A SIMILAR TO THOSE NOTED IN S/B 737-53-1170. THE S/B REPAIR WAS INSTALLED PER ERA 334260-14 AT HMV.SDR DL73K992733Stringer · Boeing 737247THE LT STR 18A HAD A CRACK RUNNING FWD AND AFT SIMILIAR TO THOSE NOTED IN S/B 737-53-1170 AND 737-53-1066. THE DAMAGE WAS FOUND AT MV AND REPAIRED PER ERA 333890-14.SDR DL73K992697Stringer · Boeing 737247THE RIGHT STR 18A HAD A CRACK IN THE SHEAR WEB SIMILAR TO THAT OF S/B 737-53-1170. DAMAGE WAS FOUND AT AMV IN ATL. DAMAGE WAS REPAIRED PER ERA 333859-14.SDR USAA991052Shear Beam · Boeing 737301CLT - DURING Q-4 CHECK VISUAL INSPECTION, FOUND A .75 INCH CRACK AT BS 726, LBL 61, WL 188 STRINGER 18A SHEAR BEAM WEB. FABRICATED REPAIR ANGLES, AND INSTALLED PER EA 65576, SRM 51-40-05 AND SB 737-53SDR USAA991059Shear Beam · Boeing 737301CLT - DURING Q-4 CHECK VISUAL INSPECTION, FOUND A .75 INCH CRACK AT STATION 726, STRINGER 18A RIGHT, RBL 61, WL 188 SHEAR BEAM WEB. INSTALLED NEW WEB AND GUSSETT PLATE PER EA 65576 AND SB 737-53-1170.SDR USAA990791Stringer · Boeing 737301CLT - DURING Q3 CHECK, FOUND .75 INCH CRACK AT BS 727 STRINGER 18A WEB S18AL. REPAIRED WITH REPLACEMENT REF SB 737-53-1170. (M)SDR W8PA960044Stringer · Boeing 7373B7DURING INSPECTION OF STR 18A WEB PER SB 737-53-1170, FOUND CRACKS IN THE AFT INBOARD LEFT SIDE HOLES. REPAIRED IAW SB 737-53-1170. (X)
Back to Boeing SB 737-53-1170