Boeing SB 737-53-1074
Service difficulty reports that cite it · 12
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-1074' 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-1074' 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 DL73S060468Skin · Boeing 737232THE FUSELAGE SKIN HAS A 0.5 INCH CRACK AT THE LOWER HINGE CUTOUT FOR THE R1 DOOR. THE DAMAGED SKIN WAS CUTOUT AND A REPAIR DOUBLER WAS INSTALLED. ALSO MODIFIED PER S/B 737-53-1074.SDR AWXA200300683Skin · Boeing 737277DURING C-15 CHECK A .375 INCH CRACK WAS FOUND AT FASTENER HOLE ON FUSELAGE SKIN, LOWER FORWARD CORNER OF R-1 DOOR CUTOUT BS 294.5. MAINTENANCE REMOVED FASTENER AT LOWER FORWARD CORNER OF R-1 DOOR CUTOSDR AWXA200200115Skin · Boeing 737277MCN - MAJOR REPAIR - "C" - DURING C-20 CHECK A GOUGE WAS FOUND ON INNER SKIN AT FRAME TORQUE TUBE BOX OF THE L1 DOOR BS 305, STR 11-12, IN ADDITION TWO EXISTING REPAIRS WILL NEED TO BE INCORPORATED INSDR P2EA01071Skin · Boeing 7372B7SJO - DURING C-CHECK, FUSELAGE STATION 307 BETWEEN STRINGER 10 AND 11 LEFT SKIN WITH CRACKS. MODIFIED FUSELAGE FORWARD ENTRY DOOR WAY SKIN CUT OUT FROM BS 303 TO BS 311 BETWEEN STRINGER 10 AND 13 LEFTSDR P2EA00065Hinge · Boeing 737222SJO - DURING Q-CHECK, R1 DOOR UPPER HINGE INNER DOUBLER AT BS 302 WORN AND UPPER HINGE CRACKED. REPAIRED STRUCTURE FROM BS 295 TO BS 305 BETWEEN STRINGER 8L AND STRINGER 12L IAW COOPESA EO COO-3-53-08SDR 98ZZZX4177Skin · Boeing 7372H4SKIN CRACKED AT AFT ENTRANCE DOOR, LOWER HINGE CUTOUT, AT STR 14L BETWEEN STA 908 - STA 951. SKIN CRACKED AT AFT SERVICE DOOR, LOWER HINGE CUTOUT, AT STR 14R BETWEEN STA 908 - STA 951. REPAIRED PER DASDR 98ZZZX3392Skin · Boeing 7372H4THREE EACH FASTENER HOLES CRACKED IN FUSELAGE SKIN AT STA 908 TO STA 927, STR 14R. EIGHT EACH FASTENER HOLES CRACKED IN FUSELAGE SKIN AT STA 932 TO STA 947, STR 14R. BEAR STRAP IS CRACKED AT THE AFT ESDR 98ZZZX3393Skin · Boeing 7372H4THREE EACH FASTENER HOLES CRACKED IN FUSELAGE SKIN AT STA 908 TO STA 927, STR 14R. EIGHT EACH FASTENER HOLES CRACKED IN FUSELAGE SKIN AT STA 932 TO STA 947, STR 14R. BEAR STRAP IS CRACKED AT THE AFT ESDR USAA980105Skin · Boeing 737201INT - DURING Q-6 CHECK EDDY CURRENT INSPECTION, FOUND .125 INCH CRACK ON EXTERNAL FUSELAGE SKIN AT FORWARD RT SERVICE DOOR LOWER HINGE CUTOUT FORWARD EDGE SKIN. REMOVED SECTION OF SKIN AND INSTALLED RSDR SWAA960520Skin · Boeing 7372T4DURING SCHEDULED SV CHECK, FOUND FUSELAGE SKIN CRACKED .5 INCH ON LOWER AFT ENTRY DOOR CUTOUT. REPAIRED PER BOEING SRM AND S/B 737-53-1074.SDR AWXA960074Skin · Boeing 7372A6PAE - FLT NR 3839 - DURING SCHEDULED C-12 MAINTENANCE CHECK, FOUND FORWARD GALLEY DOOR WAY OUTER SKIN CRACKED THROUGH FASTENER HOLE AT FORWARD LOWER CORNER OF DOORWAY. REPAIRED IAW SB 737-53-1074 AND SDR SWAA950552Skin · Boeing 7372H4DURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED AT LOWER HINGE CUTOUT OF AFT SERVICE DOOR. REPAIRED PER BOEING S/B 737-53-1074 AND STRUCTURAL REPAIR MANUAL.
Back to Boeing SB 737-53-1074