Boeing SB 737-53-1145
Service difficulty reports that cite it · 19
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-1145' 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-1145' 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 SPAA20141105Stringer · Boeing 7372T4STRINGER 16L, HAS TWO CRACKS BS 500-520. REPAIRED IAW SB 737-53-1145, REV 0 AND EO R22529 1-053-007-032.SDR SPAA2014111900002Stringer · Boeing 7372T4STRINGER 16R AT BS 500-520 HAS 2 CRACKS. REPAIRED IAW SB 737-53-1145 AND EO R22529-1-053-011-03.SDR PIDA07031Stringer · Boeing 7372K5DURING MAINTENANCE, NOTED CRACK AT THE END OF STR 16RT AT BS 500B+2. REPAIRED PER SB 737-53-1145.SDR AWXA200100592Stringer · Boeing 7373G7MCN - C12 CK - "C" - CRACK FOUND AT FWD EDGE OF WING SCANNING LIGHT CUTOUT AT BS 500C+4, STR 16R, 1.1" LONG. MAINTENANCE REMOVED CRACKED STRINGER END, FABRICATED REPAIR CHANNEL AND FILLER AND INSTALLESDR AWXA0001899Stringer · Boeing 7373G7D: STR 16L (Left side) Cracked Just Fwd of L/E Wing Light ReceplacleC: Repaired IAW S/B 737-53-1145SDR AWXA0001901Stringer · Boeing 7373G7STRINGER R:16 CRACKED JUST FWD OF L/E WING LIGHT RECEPTACLE BS 500C. REMOVED DAMAGED AREA FROM STR R-16 BS 500C. FORMED AND INSTALLED LL CHANNEL REPAIR AT STRINGER R-16 BS 500C ALL IAW AWA ER 03-5312-SDR AWXA0001070Longeron · Boeing 7373Y0CABIN STA 500C+6 LONGERON 16R CRACKED. REMOVED STR SECTION IAW S/B 737-53-1145; NDT VERIFIED NO CRACKS; FABED AND INSTALLED REPAIR PARTS IAW S/B 737-53-1145, ER03-5314-0032-DL1SDR AWXA0000910Stringer · Boeing 7373G7CABIN STR CRACKED AT FS 500C STR 16L AT WING ICE LIGHT (FWD OF LIGHT). REMOVED FASTENERS FROM STR 16L STA 500C; CUT OUT DAMAGE IAW SB52-1145; FABBED RADIUS FILLER AND CHANNEL SHT IAW SB 737-53-1145; ISDR AWXA0000911Stringer · Boeing 7373G7CABIN STR CRACKED AT FS 500C STR 16R AT WING ICE LIGHT (FWD OF LIGHT). REMOVED FASTENERS FROM STR 16R STA 500C; CUT OUT DAMAGE IAW SB52-1145; FABBED RADIUS FILLER AND CHANNEL SHT IAW SB 737-53-1145; ISDR AWXA0000872Stringer · Boeing 7373G7CABIN FS 500C STR 16L AT WING ICE LIGHT STR CRACKED FWD OF LIGHT. REMOVED FASTENERS FROM STR 16L FS 500C, FAB RADIUS FILLER AND CHANNEL SHT IAW SB 737-53-1145, INSTALLED ALL PARTS IAW SB 53-1145 & SRMSDR AWXA0000869Stringer · Boeing 7373G7CABIN FS 500C, STR 16R, CRACKED.REMOVED FASTENERS, FABRICATED RADIUS FILLER AND CHANNEL, INSTALLED IAW SB 737-53-1145 AND SRM 51-40-02.SDR DL73K981778Skin · Boeing 737232A CRACK WAS FOUND IN THE SKIN AT FS 520 AND STR 16L. THE UNDERLYING STRINGER WAS FOUND WITH A TYPICAL CRACK AT THE END OF THE STRINGER AS OUTLINED IN BAC S/B 737-53-1145. THE SKIN WAS REPAIRED WITH ANSDR AWXA9700551Stringer · Boeing 73733ADURING ROUTINE MAINTENANCE CHECK, FOUND FUSELAGE STRINGER 16 RT AT WING SCANNING LIGHT CUTOUT TO BE CRACKED AT STA 500C + 4 AND 500C + 16. REPAIRED DAMAGED STRINGER 16 RT, STA 500C + 4 AND 500C + 16 ISDR F3LA97053Stringer · Boeing 737201PAE - AT STATION 500B PLUS 2.5, STRINGER 16L IS CRACKED, LENGTH OF CRACK .25 INCH. CUTOUT DAMAGED AREA AND REPAIRED PER TRAMCO EWO NR 97-0115 AND BOEING SB 737-53-1145. WORK ACCOMPLISHED ON TRAMCO WORSDR ASAA9610096Stringer · Boeing 737290CSEA - DURING D-CHECK, A CRACK WAS IDENTIFIED AT THE ENDS OF STRINGER 16R, BS 500B, WHICH TERMINATES AT THE RIGHT WING LEADING EDGE LIGHT. REPAIRED PER EA 5310-1456 AND BOEING SERVICE BULLETIN 737-53-1SDR 96ZZZM603Stringer · Boeing 737290CSEA - DURING D-CHECK A CRACK WAS FOUND AT THE ENDS OF STRINGER 16R, BS 500B WHICH TERMINATES AT THE OVERWING LIGHT. REPAIRED PER EA 5310-01400 AND BOEING SB 737-53-1145. REFERENCE ASAA9610031.SDR ASAA9610031Stringer · Boeing 737290CSEA - DURING D-CHECK A CRACK WAS FOUND AT THE ENDS OF STRINGER 16R, BS 500B WHICH TERMINATES AT THE OVERWING LIGHT. REPAIRED PER EA 5310-01400 AND BOEING SB 737-53-1145. (M)SDR 96ZZZX2120Stringer · Boeing 7372P6CLT - DURING A C-2 CHECK INSPECTION, VISUALLY FOUND A 1 INCH CRACK AROUND RIVET HOLE IN STR STA 516, S15L. INSTALLED DOUBLER PER IAW SB 737-53-1145.SDR 96ZZZX2121Stringer · Boeing 7372P6CLT - DURING A C-2 CHECK INSPECTION, VISUALLY FOUND A 1 INCH CRACK AROUND RIVET HOLE IN STR STA 503, S15L. REPAIRED PER SB. INSTALLED DOUBLER. BOEING SB 737-53-1145.
Back to Boeing SB 737-53-1145