JASC 5315
Service difficulty reports · 44,223
Reports filed under 5315 · Fuselage Main, Floor Beam, newest first.
Query with SQL
duckdb -csv -c "SELECT sdr_id, difficulty_date, n_number, aircraft_make, aircraft_model, part_name, part_condition, jasc_code, discrepancy FROM 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet' WHERE jasc_code = '5315' ORDER BY difficulty_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 sdr_id, difficulty_date, n_number, aircraft_make, aircraft_model, part_name, part_condition, jasc_code, discrepancy FROM 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet' WHERE jasc_code = '5315' ORDER BY difficulty_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 2001UALA00700Floorbeam · corrodedFLOORBEAM CORRODED STA 1681 RBL 12. INSTALLED T-CAP REPAIR AND STIFFENERS.SDR 2001UALA00699Floorbeam · corrodedFLOORBEAM CORRODED. STA 1681 RBL 24 TO RBL 30. INSTALLED T-CAP REPAIR WITH STIFFINERS.SDR AALA20011010Floorbeam · corrodedTUL - FOUND FLOORBEAM HAS CORROSION ON TOP FLANGE. FIXED IT PER ESO 11697 DATED 5/9/01. (M)SDR 2001UALA00698Floorbeam · corrodedFLOOR BEAM UPPER SURFACE CORRODED. STA 1681, RBL 12 AND RBL 24 TO RBL 30, WL 208. INSTALLED FILLERS AND DOUBLERS.SDR AWXA0001726Floorbeam · crackedMAIN CABIN BS 520 RBL 45.5 FLOORBEAM CRACKED IN RADIUS OF UPPER CHORD. REPAIRED MAIN CABIN FLOORBEAM IAW EO 53-14-12.SDR 2001UALA00761Floorbeam · corrodedFLOORBEAM CORRODED STA 1681 LBL 12. MAJOR REPAIR ACCOMPLISHED. INSTALLED FILLER AND T-CAP REPAIR.SDR DL73K010748Floorbeam · crackedTHE LONGITUDINAL FLOORBEAM OVER THE CENTER WING BOX AT BL 0 WAS FOUND WITH A CRACK IN THE FLOORBEAM WEB AND UPPER CHORD AT FS 660 AND 2 CRACKS IN THE FLOORBEAM WEB AT FS 705. THE CRACKED BEAM WAS REPAIRED PER BAC S/B 737-57-1210 AND ER/A 380765-14.SDR 2001UALA00697Floorbeam · corrodedFLOORBEAM UPPER SURFACE CORRODED. STA 1640 LBL 31 TO RBL 51 WL 208. INSTALLED T-CAP REPAIR.SDR 2001UALA00692Floorbeam · crackedFLOOR BEAM WEB CRACKED IN TWO PLACES. STA 706-716 BL 0. INSTALLED DOUBLER.SDR AALA20011081Floorbeam · corrodedTUL - FOUND CORROSION ON FLOORBEAM TOP STATION 1338 AT SCREW HOLES UNDER RIGHT AFT LAV. BLENDED OUT CORROSION INSTALLED WEAT STRIPS PER SRM 53-05 PART 1 PAGE 30A. (M)SDR AALA20011080Floorbeam · corrodedTUL - FOUND CORROSION ON TOP OF 1322 FLOORBEAM RIGHT LAV AFT .25 INCH HOLE. BLENDED OUT CORROSION INSTALLED WEAR STRIPS PER SRM 53-05 PART 1 PAG 30A. (M)SDR DL73K010734Floorbeam · crackedTHE LBL 24 LONGITUDINAL FLOORBEAM OVER THE CENTER WING WAS FOUND WITH A CRACK IN THE BEAM WEB DOUBLER AT FS 678. THE CRACKED WEB DOUBLER WAS REMOVED. A NEW WEB DOUBLER WAS INSTALLED AND THE BEAM MODIFIED PER BAC S/B 737-57-1139. THE REPAIR WAS ACCOMPLISHEDSDR DL73K010733Floorbeam · crackedTHE LONGITUDINAL FLOORBEAM OVER THE CENTER WING AT RBL 24 WAS FOUND WITH A CRACK IN THE BEAM WEB DOUBLER AT FS 678 AND IN THE FLOOR BEAM UPPER CHORD AT FS 674. THE CRACKED WEB DOUBLER AND UPPER CHORD WERE REMOVED. A NEW WEB DOUBLER AND CHORD WERE INSTALLED ASDR 2001UALA00662Floorbeam · corrodedCABIN FLOORBEAM CORRODED. STA 365 RBL 51 TO 70. SPLICED IN UPPER CHORD.SDR USAA010688Floorbeam · corrodedPIT - FOUND TOP FLANGE ENTIRE LENGTH OF FLOORBEAM CORRODED 1 INCH BY 2 INCHES, FLOORBEAM STATION 986.5. CORROSION LEVEL 1, TASK C53-107-02. TOP SECTION OF FLOORBEAM REPLACED ENTIRE LENGTH WITH BOEING KIT NR 6132505 PER TYPICAL REPAIR 53-60-01. (M)SDR GAIA01182STFloorbeam · corrodedDURING A LTC INSPECTION, THE BS 950 FLOORBEAM UPPER CHORD WAS DISCOVERED CORRODED LBL 24.75 TO 45.50. ACCOMPLISHED BS 950 FLOORBEAM UPPER CHORD REPAIR LBL 32.75 IAW REPAIR ORDER FASI-101RO-1 REV IR DATED 04/26/01. (M)SDR GAIA01163STFloorbeam · crackedDURING A LTC INSPECTION, IT WAS DISCOVERED AT RBL 24.75 A LONGITUDINAL FLOORBEAM UPPER CHORD IS CRACKED AT BS 760, WL 207. ACCOMPLISHED LONGITUDINAL FLOORBEAM UPPER CHORD REPLACEMENT BS 740-848 RBL 24.75 IAW B727 SRM 51-30-2 AND SRM 51-10-1. (M)SDR GAIA01160STFloorbeam · corrodedDURING A LTC INSPECTION FOUND CORROSION ON A FLOORBEAM WAS DISCOVERED AT BS 1130, BBL 0 AS VIEWED FROM THE AFT PIT. ACCOMPLISHED BS 1130, BBL 0 FLOORBEAM C ANGLE REPAIR IAW B727 SRM 53-10-2 FIG 7 AND SRM 51-30-2. (M)SDR GAIA010150STFloorbeam · crackedDURING A LTC INSPECTION, IT WAS DISCOVERED THAT THE BS 740 FLOORBEAM UPPER CHORD IS CRACKED IN THE RADIUS UNDER THE RBL 45.5 SEAT TRACK. ACCOMPLISHED FLOORBEAM UPPER CHORD REPAIR BS 740 RBL 45.5 IAW B727 SRM 53-10-4 FIG 4. (M)SDR GAIA01147STFloorbeam · corrodedDURING A LTC INSPECTION, FOUND CORROSION ON FLOORBEAM WAS DISCOVERED AT BS 1110 BL 30L AS VIEWED FROM LOWER CARGO COMPARTMENT, LOWER SIDE OF UPPER T-CHORD. ACCOMPLISHED FLOORBEAM UPPER CHORD REPAIR BS 1110 LBL 30 IAW B727 SRM 53-10-8 FIG 8. (M)SDR GAIA01146STFloorbeam · corrodedDURING A LTC INSPECTION, FOUND CORROSION ON FLOORBEAM LOWER SIDE WAS DISCOVERED AT BS 1110, AS VIEWED FROM AFT CARGO. ACCOMPLISHED FLOORBEAM LOWER CHORD REPAIR BS 1110 IAW B727 SRM 53-10-8 FIG 8. (M)SDR GAIA01144STFloorbeam · corrodedDURING A LTC INSPECTION, CORROSION ON FLOORBEAM WAS DISCOVERED AT BS 1130R WHERE SHEAR TIE AND FLOORBEAM INTERSECT, AS VIEWED FROM AFT CARGO. ACCOMPLISHED FLOORBEAM STABILIZATION STRAP REPAIR BS 1130 RBL 45.5 IAW B727 SRM 53-10-8 FIG 6. (M)SDR GAIA01135STFloorbeam · crackedDURING A LTC INSPECTION, A CRACK WAS DISCOVERED AT RBL 45.5 LONGITUDINAL FLOORBEAM UPPER CHORD AT BS 760, WL 207. ACCOMPLISHED LONGITUDINAL FLOORBEAM UPPER CHORD REPLACEMENT BS 760-848 RBL 45.5 IAW B727 SRM 51-30-5 AND SRM 51-30-2. (M)SDR ASAA0140068Floorbeam · corrodedPAE - DURING SI CHECK, FOUND FLOORBEAM UPPER CHORD CORRODED AT BS 486.5, WL 208 AND BUTT LINE 13.5 TO 19.5. (M)SDR ASAA0140069Floorbeam · corrodedPAE - DURING SI CHECK, FOUND CORROSION ON UPPER CHOD OF 947 FLOORBEAM AT BS 947, WL 208, AND LBL 15 TO RBL 15. (M)SDR CALA0100443Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AROUND FASTENER HOLES AT STA 312, LBL 12-RBL 12. THE MAJORITY OF CORROSION WAS BURNISHED OUT. A REPAIR STRAP WAS INSTALLED IAW SRM 53-00-1 AT ONE LOCATION FOUND OUT OF LIMITS.SDR 2001UALA00648Floorbeam · corrodedCABIN FLOORBEAM CAP CORRODED. STA 365 RBL 51 - 60. REMOVED DAMAGE AND INSTALLED NEW T CHORD.SDR 2001F00195Floorbeam · corrodedTHE FLOORBEAM WAS FOUND CORRODED AT BS 328, RBL 32. THE DAMAGED AREA WAS REPAIRED IAW SRM 53-10-9 FIGURE 6. (M)SDR 2001F00188Floorbeam · crackedFOUND FLOORBEAM FOUND CRACKED AT BS 520 RBL 25 WL 208. THE DAMAGED AREA WAS REPAIRED IAW SB 737-53-1120. (M)SDR 2001F00187Floorbeam · crackedFOUND FLOORBEAM AT BS 520 RBL 25 INCH LOWER CHORD HAS CRACK. THE DAMAGED AREA WAS REPAIRED IAW SRM 53-10-9 FIGURE 7. (M)SDR AWXA0001691Floorbeam · corrodedTHREE SPOTS OF CORROSION ON UPPER FLANGE OF FLOORBEAM BS 294 RBL 28-31. REMOVED CORRODED SECTION; FORMED AND INSTALLED SECTION OF UPPER T-CHORD IAW B737 SRM 51-20-01 PG 1 AND 51-40-05 PG 3 AND 53-10-08 PG 12 AND 53-00-51 PG 207 AND 51-10-02 PG 2.SDR AWXA0001679Floorbeam · corrodedCORROSION ON AFT CORNER OF TRACK SECTION AND UPPER FLANGE OF FLOORBEAM AT BS 294 RBL 12-14; CORROSION REMOVAL OUT OF LIMITS. REMOVED FLOORBEAM T-CAP SECTION; LOCATED, DRILLED, TREATED, PRIMED AND INSTALLED NEW T-CAP UPPER CORD IAW B737 SRM 51-40-05 PG 7 AND 5SDR AWXA0001662Floorbeam · corrodedAT LBL 2 FS 328 HAS CORROSION AT FASTENER HOLE AFT FLANGE. REMOVED CORROSION IAW SRM 53-00-51 FIG 203. FOUND OUT OF LIMITS. FABBED AND INSTALLED REPAIR STRAP IAW SRM 53-00-51 FIG 203.SDR 2001UALA00675Floorbeam · corrodedBS 1153 BL-0 TO RBL 46 T-CAP CORRODED. FABRICATED AND INSTALLED REPAIR IN ACCORDANCE WITH BAC DRAWING 146T1060-2 AND SRM 51-40-02.SDR USAA010493Floorbeam · corrodedCLT - FOUND FLOORBEAM T-CAP CORRODED .125 INCH, BS 967, RBL 42. DAMAGE REMOVED, SPLICED IN T-CAP REPLACEMENT PER SRM 53-10-9. (M)SDR USAA010491Floorbeam · corrodedCLT - FOUND FLOORBEAM T-CAP CORRODED APPROX 13 SQUARE INCHES, BS 986.5, LBL 45 TO RBL 45. REMOVED AND REPLACED T-CAP PER TYPICAL REPAIR 53-60-01 REV ''A''. (M)SDR USAA010474Floorbeam · corrodedCLT - FOUND FLOORBEAM T-CAP CORRODED 1 INCH BY .5 INCH AREA, BS 312, BL 0. DAMAGE REMOVED, SPLICED IN REPAIR ANGLES AND T-CAP SECTION PER TYPICAL REPAIR 53-10-13. (M)SDR USAA010473Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED 2 INCHES BY 3 INCHES, BS 1006, LBL 10. DAMAGE REMOVED, INSTALLED FILLER AND REPAIR ANGLES PER SRM 53-10-9 FIG 2. (M)SDR SCNA01319Floorbeam · corrodedDURING C-CHECK, CORROSION WAS DISCOVERED OUT OF LIMITS ON THE FORWARD LOWER FLANGE OF THE FLOORBEAM AT BS 1130, LBL 40 TO RBL 44. ACCOMPLISHED GENERAL REPAIR IAW B727 SRM CHAPTERS 51 AND 531008 FIG 8. TRIMMED LOWER CHORD FLANGE.SDR 2001UALA00599Floorbeam · corrodedAFT CABIN FLOORBEAM STATION 947 UPPER SURFACE CORRODED FROM RBL 10 TO LBL 15. REMOVED DAMAGED AREA. SPLICED IN T-CHORD NESTED ANGLE REPAIR. MAJOR REPAIR ACCOMPLISHED.SDR DL73K010691Floorbeam · crackedTHE LONGITUDINAL FLOOR BEAM AT RBL 24 WAS FOUND WITH A TYPICAL CRACK IN THE BEAM WEB AND WEB DOUBLER AT FS 678. THE BEAM UPPER CHORD WAS FOUND CRACKED AT FS 674. THE UPPER CHORD WAS REMOVED AND REPLACED. THE WEB DOUBLER WAS REPLACED PER BAC S/B 737-57-1SDR USAA010470Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED .5 INCH B.25 INCH, BS 1006, LBL 10. REPLACED T-CAP SECTION PER EA 69149A. (M)SDR QXEA0100737Floorbeam · corrodedYYC - CORROSION ON FLOORBEAM AT FRAME 1385 AND BL280L. BLENDED AS PER FOKKER SRM 51-10-04, PAGE 9, PARAGRAPH 4A. ALODINED AS PER FOKKER SRM 51-10-04, PAGE 7, PARAGRAPH 4.SDR 0101765502Floorbeam · corrodedDURING H-CHECK FOUND CORROSION ON FLOORBEAM AT BS 1681. REPAIRED PER EA 55-183364.SDR RRXA11098Floorbeam · crackedDURING A MAINTENANCE VISIT FOUND CRACK DAMAGE TO FLOORBEAM AT STA.1540 AND RBL44, DAMAGE EXCEEDED LIMITATION IAW DC-8 SRM. REMOVED DAMAGE, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED PART AND INSTALLED IAW DC-8 SRM 51-1-21 AND DHK 996-34S.SDR QXEA0100738Floorbeam · corrodedYYC - CORROSION ON FLOORBEAM AT FRAME 1890 AND BL280L. BLENDED AS PER FOKKER SRM 51-10-4, PAGE 9, PARAGRAPH 4A. ALODINED AS PER FOKKER SRM 51-10-04, PARAGRAPH 4, PAGE 7.SDR AALA20010934Floorbeam · damagedTUL - FOUND STATION 1338, 15 INCHES FROM OUTBOARD END, FLOORBEAM DAMAGED AROUND HOLE. INSTALLED REPAIR STRAP ON FLOORBEAM STATION 1338 RIGHT SIDE PER ESO 80559 4-24-2001. (M)SDR TSAA0151045Floorbeam · corrodedSURFACE CORROSION DISCOVERED ON FLOORBEAM AT BS 312, LBL 12 TO RBL 12. REMOVED CORROSION BY REPLACING THE INTERCOSTAL IAW SRM 51-10-01. AIRCRAFT RETURNED TO SERVICE. (M)SDR TSAA0151044Floorbeam · corrodedEXFOLIATED CORROSION DISCOVERED ON FLOORBEAM AT BS 294.5 PLUS 8 AND PLUS 13 RBL 12. REMOVED CORROSION BY REPLACING THE FLOORBEAM SECTION AT BS 294.5 PLUS 8 AND PLUS 13 IAW BOEING DRAWING 65-45808. AIRCRAFT RETURNED TO SERVICE. (M)SDR TSAA0151042Floorbeam · corrodedEXFOLIATION CORROSION DISCOVERED ON FLOORBEAM AT BS 277. REMOVED CORROSION BY CLEANING AND TREATING AFFECTED AREA PER SRM 51-10-6. AIRCRAFT RETURNED TO SERVICE. (M)
Back to JASC 5315