Boeing SB 737-52-1096
Service difficulty reports that cite it · 18
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-52-1096' 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-52-1096' 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 USAA011387Skin · Boeing 737401TPA - FOUND SKIN .250 INCH, UPPER HINGE CUTOUT ON MAIN ENTRY DOOR. INSTALLED DOUBLER PER SB 737-52-1096 ALSO EA NR 94248. (M)SDR USAA010884Skin · Boeing 7373B7TPA - FOUND DOOR EXT SKIN CRACKED .25 INCH, FORWARD SERVICE DOOR, UPPER HINGE CUTOUT. REPAIR DOUBLER INSTALLED PER SRM 52-10-01 PAGE 201 AND SB 737-52-1096. (M)SDR USAA010869Skin · Boeing 7373B7TPA - FOUND DOOR EXTERIOR SKIN CRACKED .25 INCH, AFT ENTRY DOOR, UPPER HINGE CUTOUT. INSTALLED DOUBLER PER SRM 52-10-01 AND SERVICE BULLETIN 737-52-1096. (M)SDR USAA010870Skin · Boeing 7373B7TPA - FOUND DOOR EXTERIOR SKIN CRACKED .25 INCH, FORWARD SERVICE DOOR, LOWER HINGE CUTOUT. INSTALLED REPAIR DOUBLER PER SRM 52-10-01 PAGE 201 AND SB 737-52-1096. (M)SDR USAA010728Skin · Boeing 737301PIT - FOUND SKIN CRACKED .095 INCH, LOWER HINGE CUTOUT. ROUTED OUT CRACK AND INSTALLED DOUBLER PER SRM 52-10-01 S/B 737-52-1096. (M)SDR AWXA0001181Skin · Boeing 7373G7R1 DOOR SKIN CRACKED AT UPPER HINGE CUT OUT. CUT OUT DAMAGE AND REPAIRED IAW SB 737-52-1096 FIG 6 DETAIL 1, AWA EO 52-00-02, AND SRM 51-40-02SDR USAA001949Skin · Boeing 7373B7PIT - FOUND SKIN CRACKED .25 INCH, FORWARD S/E DOOR SKIN LOWER HINGE RADIUS INTO DRAIN TABLE. INSTALLED DOUBLER REPAIR AND ROUTED OUT DAMAGE PER SB 737-52-1096 AND EA 56696. (M)SDR AWXA0000529Skin · Boeing 7373G7C-CHECK, R-1 DOOR SKIN CRACKED AT UPPER HINGE CUTOUT. STOP DRILLED CRACK, FABRICATED AND INSTALLED REPAIR DOUBLER FOR DOOR SKIN IAW SB 737-52-1096 ON UPPER HINGE ONLY.SDR P2EA00184Skin · Boeing 737222SJO - DURING C-CHECK, FOUND R-1 DOOR LOWER HINGE SECTION, BS 306-313 BEAM 5-7 SKIN WITH CRACK LENGTH .50 INCH, WIDTH .002 INCH. REPAIRED R-1 DOOR LOWER HINGE SECTION, BS 306-313 BEAM 5-7, SKIN IAW BOESDR DL733000888Skin · Boeing 7373B7THE UPPER AFT CORNER OF THE LOWER HINGE CUTOUT ON THE R1 DOOR WAS FOUND WITH A .25 INCH CRACK. THE CRACK IS TYPICAL OF BAC S/B 737-52-1096. THE CRACK WAS REPAIRED WITH AN EXTERNAL ALUMINUM DOUBLER PERSDR USAA990827Skin · Boeing 7372B7TPA - DURING CX-2 CHECK EDDY CURRENT INSPECTION, FOUND A .125 INCH CRACK LOWER HINGE CUTOUT FORWARD SERVICE DOOR SKIN. REMOVED CRACK AND INSTALLED DOUBLER PER SB 737-52-1096 AND SRM 51-10-01. (M)SDR USAA990435Skin · Boeing 7373B7TPA - DURING CX-3 CHECK, FOUND .25 INCH CRACK IN DOOR SKIN AT FORWARD ENTRY DOOR LOWER HINGE CUT OUT AFT LOWER CORNER. INSTALLED REPAIR DOUBLER PER EA 64557 AND BOEING SB 737-52-1096 FIG 3. (M)SDR USAA980598Skin · Boeing 737301TPA - DURING CX-1 CHECK VISUAL INSPECTION VERIFIED WITH HFEC, FOUND A .375 INCH CRACK LOWER HINGE CUTOUT ON FORWARD ENTRY DOOR SKIN. FABRICATED DOUBLER AND INSTALLED PER SB 737-52-1096 FIG 3 AND EA 63SDR USAA980599Skin · Boeing 737301TPA - DURING CX-1 CHECK VISUAL INSPECTION VERIFIED WITH HFEC, FOUND A .375 INCH CRACK LOWER HINGE CUTOUT ON FORWARD SERVICE DOOR SKIN. FABRICATED DOUBLER AND INSTALLED PER SB 737-52-1096 FIG 3 AND EA SDR USAA980600Skin · Boeing 737301TPA - DURING CX-1 CHECK VISUAL INSPECTION VERIFIED WITH HFEC FOUND A .125 INCH CRACK UPPER HINGE CUTOUT ON FORWARD SERVICE DOOR SKIN. FABRICATED DOUBLER AND INSTALLED PER SB 737-52-1096 FIG 6 AND EA 6SDR USAA980498Skin · Boeing 7373B7CLT - DURING Q-5 CHECK VISUAL INSPECTION, FOUND A 2 INCH CRACK FORWARD GALLEY DOOR UPPER HINGE AREA. INSTALLED DOUBLER PER EA 38966A SB 737-52-1096 REV 1. (M)SDR USAA980379Skin · Boeing 7373B7TPA - DURING CX-5 CHECK VISUAL AND EDDY CURRENT INSPECTION, FOUND .125 INCH CRACK ON DOOR OUTER SKIN FORWARD SERVICE DOOR LOWER HINGE CUTOUT AFT UPPER CORNER. INSTALLED DOUBLER MADE FROM .063 2024 T-3SDR F3LA98081Skin · Boeing 737201PAE - DURING C-CHECK INSPECTION, REPORTED CRACK IN FORWARD ENTRY DOOR OUTER SKIN, LOWER HINGE CUTOUT, UPPER AFT CORNER. MAINTENANCE REMOVED DAMAGED AREA, FABRICATED REPLACEMENT PARTS AND REPAIRED PER
Back to Boeing SB 737-52-1096