Boeing Special Attention Service Bulletin 737-53-1083
Service difficulty reports that cite it · 10
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-1083' 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-1083' 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 DL73S040932Skin · Boeing 737232THE FUSELAGE SKIN AT THE L1 DOOR OPENING WAS FOUND CRACKED AT THE CUTOUT EDGE JUST ABOVE THE LOWER AFT CORNER. THE CRACKS WERE SMALL AND TYPICAL OF BAC S/B 737-53-1083. THE CRACKS WERE TRIMMED OUT OF SDR BJNA040902Skin · Boeing 737282DURING C-CHECK INSPECTION, FOUND FUSELAGE SKIN CRACKED AT BOTTOM OF L1 DOOR CUT OUT BS 336. INSTALLED DOUBLER AND STRAP AT L1 DOOR LOWER CUTOUT IAW SB 737-53-1083 REV 3. (M)SDR DL73K010012Skin · Boeing 737232A 1 INCH CRACK WAS FOUND IN THE FUSELAGE SKIN JUST FORWARD OF THE LOWER AFT CORNER OF THE L1 DOOR. THE DAMAGE WAS REPAIRED PER BACO DWG 65C27257 AND BACO S/B 737-53-1083. THE DAMAGE WAS FOUND AT HMV.SDR P2EA00333Door Frame · Boeing 737247SJO - DURING Q-CHECK, FO UND THE L-1 DOOR JAMB AFT LOWER CORNER SKIN WITH CRACK 2.5 INCH BY .002 INCH. IDENTIFIED AS REPORTABLE ON 11-07-2000. REPAIRED THE L-1 DOOR JAMB AFT LOWER CORNER SKIN IAW BOEISDR DL73K000705Skin · Boeing 737232THE FUSELAGE SKIN ASSY BELOW THE L1 DOOR CUTOUT LOWER SILL NEAR THE AFT CORNER WAS FOUND WITH A 1 INCH CRACK. THE CRACK IS TYPICAL OF BAC S/B 737-53-1083. THE CRACK WAS ROUTED OUT AND REPAIRED WITH TWSDR DL73K992217Skin · Boeing 737232FUSELAGE, SKIN ASSY, L1 DOOR CUTOUT, CRACK REPAIR. A CRACK WAS FOUND IN THE SKIN, DOUBLER, AND BEAR STRAP AT THE LOWER AFT CORNER OF THE L1 DOOR CUTOUT. THE CRACK IS TYPICAL OF BAC S/B 737-53-1083. THSDR USAA990826Skin · Boeing 7372B7TPA - DURING CX-6 CHECK VISUAL AND EDDY CURRENT INSPECTION, FOUND A .25 INCH CRACK ABOVE RIVET .125 INCH CRACK BELOW RIVET STRINGER 17R, WL STATION 344 SKIN. INSTALLED REPAIR DOUBLER PER SB 737-53-108SDR DL73E982302Skin · Boeing 7372S3THE FUSELAGE SKIN WAS FOUND WITH A 1.875 INCH CRACK BELOW THE L1 DOOR AT APPROX FS 335. THE CRACK IS TYPICAL OF BAC S/B 737-53-1083. THE CRACK WAS STOP DRILLED AND REPAIRED WITH AN INTERIM DOUBLER REPSDR 97ZZZM663Skin · Boeing 737222DURING COMPLIANCE OF BOEING SB INSPECTION, FOUND AFT LOWER L1 DOOR CUTOUT CRACKED VERTICALLY 1.5 INCH LONG AT FUSELAGE STATION 340. REMOVED SCUFF PLATE AND INSTALLED INTERMI REPAIR PER BOEING SB 737-5SDR DL73S960373Door Cutout · Boeing 737232DURING INSPECTION, BOTH THE L1 AND R1 DOOR CUTOUTS HAD CRACKS RUNNING FROM THE LOWER AFT CORNER EDGES AND TERMINATING IN FASTENER HOLES. BOTH CRACKS EXTEND THROUGH THE SKIN, BONDED DOUBLER AND UNDERLY
Back to Boeing Special Attention Service Bulletin 737-53-1083