Boeing SB 737-53-1182
Service difficulty reports that cite it · 21
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-1182' 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-1182' 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 SROM200700006Frame · Boeing 737205NR63-CRACK ON BODY FRAME INNER CHORD BS616 RT SIDE AT STUB BEAM LOWER CHORD ATTACH (ABOVE WING BOX BL64R). DAMAGE OF BODY FRAME INNER CHORD STA 616 RT SIDE AT STUB BEAM LOWER CHORD ATTACH REMOVED IAW SDR PIDR2006033Frame · Boeing 737301CRACK IN BS 616 FRAME RT SIDE BELOW FLOOR. REPAIRED DAMAGED AREA IAW SB 737-53-1182.SDR PIDA06114Frame · Boeing 7374B7CRACK AT FRAME STA 616 RBL 64 JUST BELOW FLOOR LEVEL. REPAIRED IAW SB 737-53-1182 FIG 9.SDR PIDA06087Attach Angle · Boeing 7374B7STA 601 BEAM AFT SIDE OF FWD OVERWING EXIT HAS A CRACKED ATTACH ANGLE. REPAIRED PER EA 53-219 AND SB 737-53-1182.SDR PIDA06088Frame · Boeing 7374B7INBOARD CHORD OF STA 601R FRAME IS CRACKED AT BOTTOM FASTENER. REPAIRED PER SB 737-53-1182 AND EA 53-217.SDR PIDA20050150Frame · Boeing 737228CRACK AT I/B CHORD LOWER FASTENER HOLE IN BS 616 FRAME LEFT. REPAIRED FRAME PER SB 737-53-1182.SDR DL73K011088Frame · Boeing 737232CRACKS WERE FOUND AT THE BOTTOM TWO FASTENERS ON THE INNER CCHORD OF THE LEFT FS 616 FRAME AT THE OVERWING FRAME TO STUB BEAM JOINT. THE CRACKS ARE TYPICAL OF THAT SHOWN IN S/B 737-53-1182. THE CRACKSSDR AWXA0001830Frame · Boeing 73733Afuselage frame inner chord cracked at FLOORBEAM attach point left side BS 616. cut out damaged area; FABBED repair angle and filler; drilled, treated, primed and installed repair IAW BOEING S/B 737-53SDR AWXA0001806Frame · Boeing 7373G7FWD SIDE OF FUSELAGE FRAME CRACKED ABOVE CENTER WING BS 616 LBL 65. TRIMMED OUT DAMAGE; INSTALLED REPAIR ANGLE AND FILLER IAW AWA ER 03-5311-01130-DL2 AND SB 737-53-1182.SDR DL73K010869Frame · Boeing 737232A CRACK WAS FOUND IN THE LOWER FASTENER HOLE OF BOTH THE LT AND RT FS 616 FRAME TO STUB BEAM. THE CRACK WAS REMOVED AND REPAIRED PER S/B 737-53-1182 AT HMV.SDR DL73K010230Frame · Boeing 737232A CRACK WAS FOUND AT THE LOWER FASTENER ON THE LEFT SIDE OF THE FS 616 FRAME AT THE OVERWING FRAME TO STUB BEAM. THE CRACK IS TYPICAL TO THAT SHOWN ON S/B 737-53-1182. THE DAMAGE WAS REPAIRED PER S/B SDR AWXA0001266Frame · Boeing 7373G7FUSELAGE FRAME INNER CHORD CRACKED STA 616 LBL 65. REPAIRED IAW SERVICE BULLETIN 737-53-1182.SDR AWXA0001267Frame · Boeing 7373G7FUSELAGE FRAME INNER CHORD CRACKED STA 616 RBL 65. REPAIRED IAW SERVICE BULLETIN 737-53-1182.SDR DL73K010018Frame · Boeing 737232A CRACK WAS FOUND AT THE LOWER FASTENER ON THE INNER CHORD OF THE LEFT AND RIGHT SIDE FS 616 FRAMES AT THE OVERWING FRAME TO STUB JOINT. THIS IS THE TYPICAL CRACK OF S/B 737-53-1182. THE CRACK WAS CUTSDR DL73K002106Frame · Boeing 737232A CRACK WAS FOUND AT THE LOWER FASTENER ON THE INNER CHORD OF THE LEFT AND RIGHT FS 616 FRAMES AT THE OVERWING FRAME TO BEAM JOINT STUB. ERA 396361-14 AUTHORIZES A REPAIR SIMILIAR TO THAT OF SB 737-53SDR DL73K001336Frame · Boeing 737232ONE CRACK WAS FOUND IN EACH OF THE LEFT AND RIGHT FS 616 IN THE LOWER FASTENER OF THE INNER CHORD AT FRAME TO STUB BEAM JOINT. THE CRACKS WERE 1.25 INCH IN LENGTH AND WERE TYPICAL TO THOSE SHOWN IN S/SDR DL73K001276Frame · Boeing 737232A CRACK WAS FOUND IN THE LOWER FASTENER OF THE INBOARD CHORD OF THE FS 616 JUST BELOW THE CABIN FLOOR. THE CRACK IS SIMILIAR TO THAT OF S/B 737-53-1182. ADDITIONALLY, A PILOT HOLE FROM THE FACTORY WASSDR USAA990810Frame · Boeing 737301CLT - DURING Q-1 CHECK VISUAL INSPECTION, FOUND A .50 INCH CRACK BOTTOM END OF FRAME STA 616 INBOARD CHORD ANGLE RT SIDE FRAME. INSTALLED FILLER AND DOUBLER PER SB 737-53-1182 AND EA 64972. (X)SDR 98ZZZM499Frame · Boeing 73733ADURING 'C' CHECK INSPECTION DISCOVERED CRACKING CONDITIONS ON THE BOTTOM OF THE INNER FRAME CHORD ON BOTH LEFT (LBL 70.53) AND RIGHT (RB 70.53) SIDES OF THE AIRCRAFT AT BS 616. REPAIRED BY INSPECTING SDR W8PA970613Frame · Boeing 7373B7CRACK IN FRAME INNER CHORD BS 616, RBL 665, WL 201. CRACK WAS REPAIRED PER SB 737-53-1182. (X)SDR W8PA970744Frame · Boeing 7373L9FOUND BS 616 RBL 65, WL 201 CRACK ON FRAME INNER CHORD BY LOWER FASTENER. CUT OUT DAMAGE AREA OF FRAME INNER CHORD. FABRICATED REPAIR ANGLES AND FILLER AND INSTALLED. ALL WORK DONE IAW SB 737-53-1182
Back to Boeing SB 737-53-1182