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 05FDEA02387Floorbeam · corrodedBS 277, LBL 14, WL 208 CORROSION ON FLOORBEAM. INSTALLED REPAIR PER SRM 51-40-4, THIS REPAIR IS MAJORSDR 05FDEA02379Floorbeam · interferenceBS 344 FLOORBEAM SPLICE INTERFER'S WITH BL O SEAT TRACK TO COMPLY WITH BARRIER MOD.SDR SWIA200515489Floorbeam · crackedFS 280 , TRANSVERSE BEAM CRACKED ON UPPER SUPPORT ANGLE LBL 13, ITEM FOUND AT C-CHECK INSPECTION. REPAIRED TRANSVERSE BEAM IAW CRJ REO 601R-53-11-138 REV "NC".SDR SWIA200515488Floorbeam · crackedFS 280, RT FLOORBEAM INBOARD AND OUTBOARD ATTACH ANGLES CRACKED, ITEM FOUND AT C-CHECK INSPECTION. FS 280 INBD & OB ATTACH ANGLES REPLACED IAW CRJ SRM 51-40-11, 51-42-06, 51-42-21, 51-42-13, 51-21-11, 51-25-16, 51-23-00.SDR AWXA200501014Floorbeam · corrodedMCN - MAJOR REPAIR - DURING C15 CHECK DISCOVERED CORROSION LOCATED ON BS 986 FLOORBEAM T-CAP FROM BL 17L TO BL 17R. MAINTENANCE REMOVED CORROSION AT BS 986 FLOORBEAM IAW BOEING 737-300 SRM 51-10-02-0. MATERIAL LOSS FOUND TO BE OUT OF LIMITS IAW BOEING 737-30SDR 05FDEA02341Floorbeam · damagedAT STA 919, X=58, Z=-97 AFTER REMOVED OLD CHANNEL WITH NRC N01214, FOUND FLOORBEAM DAMAGED ON OLD REPAIR. REPAIR BEAM PER SRM 53-60-01 VOL 1 FIG 3.SDR DU4R0508177Floorbeam · corrodedCORROSION RUNNING UNDER REPAIR DOUBLER AT STA. 377.7 LBL 59.SDR AWXA200501025Strap · brokenDURING C15 CHECK DISCOVERED, FLOOR STRAP BROKEN BOTTOM OF BS 312 BEAM AT BL 45R. MAINTENANCE FABRICATED REPAIR PLATE IAW BOEING 737-300 SRM 53-10-51-2. INSTALLED FABRICATED REPAIR PARTS IAW BOEING 737-300 SRM 53-10-51-2.SDR AWXA200500988Strap · crackedMCN - DURING C15 CHECK DISCOVERED FLOOR STRAP CRACKED, .7 INCHES IN LENGTH, ON THE BOTTOM OF BS 344 BEAM AT BL 45L. MAINTENANCE STOP DRILLED CRACK ON FLOORBEAM AT BS 344, BL 45L IAW BOEING 737-300 SRM 53-10-51-2 FIG 204. FABRICATED REPAIR PLATE AND INSTALLEDSDR AWXA200500986Strap · crackedDURING C15 CHECK, DISCOVERED FLOOR STRAP CRACKED, 2.0 INCHES IN LENGTH, ON THE BOTTOM OF BS 328 BEAM AT BL 11L. MAINTENANCE STOP DRILLED CRACK ON FLOORBEAM AT BS 328, BL 11L IAW BOEING 737-300 SRM 53-10-51-2 FIG 204. FABRICATED REPAIR PLATE AND INSTALLED ON SDR SWAA052352Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND LONGITUDINAL FLOORBEAM CORRODED AT BS 986, RBL 45. REPAIRED FLOORBEAM PER BFG ER.SDR SWAA052339Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND LONGITUDINAL FLOORBEAM CORRODED BETWEEN BS 727D TO BS 867, LBL 8. REPAIRED FLOORBEAM PER SRM.SDR USAA050977Floorbeam · corrodedPIT, S2, BEAM, .018, .028, .026, CORROSION; LEVEL 1 ASK JA-260-53500, FLOOR SUPPORT BEAM, FR66-68, Y1182 TO Y1292. DEVECTIVE PART REPLACED WITH IDENTICAL PART NUMBER. (K)SDR USAA050985Floorbeam · corrodedPIT - S2 - FLOORBEAM, 2 INCH X 36 INCH, CORROSION; LEVEL 1; TASK JA-260-53500, FLOOR SUPPORT BEAM FROM FR 68-66, IB AFT ENTRY DOOR. DEFECTIVE PART REPLACED WITH IDENTICAL PART. (K)SDR USAA050982Floorbeam · corrodedPIT - S2 - FLOORBEAM, 2 INCH X 96 INCH, CORROSION; LEVEL 1; TASK JA-260-53500, FLOOR SUPPORT FR 64-70 IB AFT ENTRY DOOR. DEFECTIVE PART REPLACED WITH IDENTENTICAL PART IAW SRM. (K)SDR USAA050983Floorbeam · corrodedPIT - S2 - FLOORBEAM, 2 INCH X 2 INCH, 2 INCH X 2 INCH, 1.5 INCH X .5 INCH, CORROSION; LEVEL 1; TASK JA-220-53500, BETWEEN C18 AND C24 - Y1292. DEFECTIVE PART REPLACED WITH IDENTICAL PART IAW SRM. (K)SDR USAA050981Floorbeam · corrodedA .7500 INCH DIA AREA OR LEVEL 1 CORROSION ON FLOORBEAM AT Y765 FR C-16. DEFECTIVE PART REPLACED WITH IDENTICAL PART IAW SRM. (K)SDR USAA050980Floorbeam · corroded1 INCH OF CORROSION. NO LEVEL OR TASK, FRAME 66 Y-765 AT ATTACH FITTING. DEFECTIVE PART REPLACED WITH IDENTICAL PART IAW SRM. (K)SDR USAA050979Floorbeam · corrodedPIT - S2 - FLOORBEAM, 1 IN DIA AND .7500 INCH DIA AREA, CORROSION; LEVEL 1; TASK JA-220-53500, FLOORBEAM AT Y765 BETWEEN C16 ADN C20. DEFECTIVE PART REPLACED WITH IDENTICAL PART IAW SRM. (K)SDR USAA050978Floorbeam · corrodedPIT - S2 - BEAM, .5 INCHES X .5 INCHES, CORROSION; LEVEL 1; TASK JA-260-53500, FLOOR SUPPORT BEAM FR 66-68, Y1182 TO Y1292. DEFECTIVE PART REPLACED WITH IDENTICAL PART. (K)SDR USAA050975Floorbeam · corrodedPIT - S2 - FLOORBEAM, 2 INCH X 3 INCH CORROSION, LEVEL 2; TASK: JA-220-53500 20 INCH LT OF CENTER AT FRAME C-16. REMOVED AND REPLACED IAW SRM. (K)SDR USAA050987Floorbeam · crackedBFM, Q2, TEE CHORD, .5 INCH CRACK, CABIN FLOORBEAM AT STA 312 RBL 35. FABRICATED NEW UPPER CHORD, LOCATED DRILLED AND INSTALLED ALL REPAIR PARTS IAW SRM. (K)SDR CALA0500255Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT ALL NUT CLIPS TOP AND BOTTOM AT STA 986.5, S18L TO S18R. REPAIRED IAW ECRA 5311-01235.SDR CALA0500254Floorbeam · corrodedINSPECTION FOUND THE AFT CABIN FLOORBEAM UPPER CHORD CORRODED AT STA 986.5, LBL 48 TO RBL 48. REPAIRED IAW ECRA 5311-01234.SDR USAA050974Floorbeam · corrodedPIT - S2 - FLOORBEAM, .5 INCH X .5 INCH AND 3 INCH X 2.5 INCH, CORROSION; LEVEL 1; TASK JA260-53500, FWD OF FRA 66-68, 30 INCHES LT OF CTR. REMOVED AND REPLACED BEAM. DEFECTIVE PART REPLACED WITH IDENTICAL PART. (K)SDR SWAA052320Web · corrodedDURING SCHEDULED D-CHECK, FOUND RT CREASE BEAM WEB CORRODED BETWEEN BS 400 TO BS 480 & BETWEEN BS 887 TO BS 907. REMOVED AND REPLACED CREASE BEAM WEB SECTIONS PER SRM.SDR USAA050964Floorbeam · corrodedCLT - FOUND BEAM CORRODED 28 INCHES, T-CAP OF FLOORBEAM STATION 312, LBL 2, RBL 26. REMOVED PREVIOUS T-CAP AND REPLACED WITH NEW CAP EXTENDING SPLICES PER SRM IAW SRM 53-10-51. (M)SDR USAA050960Floorbeam · corrodedCLT - FOUND BEAM T-CAP CORRODED 6 INCHES, STATION 360, RBL 55 - RBL 61. REMOVED DAMAGED METAL, INSTALLED NEW T-CAP FROM RBL 35 - RBL 72 IAW SRM 53-00-51. (M)SDR USAA050956Floorbeam · corrodedCLT - FOUND FLOORBEAM UPPER CHORD CORRODED 1 INCH BY 1 INCH, BS 344 BETWEEN LBL 55 - RBL 13. REMOVED UPPER CHORD OF FLOORBEAM. INSTALLED NEW CHORD AND ASSOCIATED REPAIR SPLICES IAW SRM 53-10-51. (M)SDR UPS05245263Floorbeam · corrodedFLOORBEAM TOP CHORD CORROSION OUTSIDE LIMITS BS 328 RBL 12. REPAIR CARRIED OUT IAW SRM 53-10-8 & 51-10-2.SDR USAA050940Floorbeam · corrodedPIT - S2 - FLOORBEAM, 1 INCH DIA AREA CORROSION; LEVEL 1; TASK JA-260-53500, FLOOR SUPPORT BEAM, FR 66 AT RT AFT ENTRY DOOR. INSTALLED DOUBLERS/ REPAIR ANGELS IAW SRM. (K)SDR SWAA052306Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND COCKPIT FLOORBEAM CORRODED AT BS 270, LBL 10 TO RBL 10, WL 208. REPAIRED FLOORBEAM PER SRM.SDR SWAA052272Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND 2 EACH LONGITUDINAL FLOORBEAMS CORRODED AT BS 847 + 10, LBL 7 & LBL 12. REPAIRED FLOORBEAMS PER SWA EA.SDR SWAA052271Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND LONGITUDINAL FLOORBEAM CORRODED AT BS 867, LBL 7. REPAIRED FLOORBEAM PER SWA EA.SDR 05FDEA02163Floorbeam · crackedFWD CARGO COMPARTMENT AT STA 939 APPROXIMATELY RBL 60 FLOORBEAM LOWER CHORD DENTED AND WEB CRACK AS MARKED. REPAIRED AS PER EA 1-5310-87607.SDR AWXA200500969Floorbeam · corrodedMCN - MAJOR REPAIR - DURING C16 CHECK DISCOVERED CORROSION UNDER SURFACE OF BEAM LOCATED AT BS 1016, BL 6R, AND WL 208. MAINTENANCE REMOVED CORROSION AND FOUND TO BE OUT OF LIMITS IAW BOEING 737-300 SRM 53-60-51-1. MAINTENANCE FABRICATED REPAIR STRAP IAW BOESDR AWXA200500964Floorbeam · corrodedMCN - MAJOR REPAIR - DURING C16 CHECK DISCOVERED CORROSION ON UPPER SURFACE OF FLOOR SUPPORT BS 965, BL 18R, WL 208. MAINTENANCE REMOVED CORROSION AND FOUND TO BE OUT OF LIMITS IAW BOEING 737-300 SRM 53-60-51-1. REMOVED FLOOR SUPPORT AT BS 965, BL 18R, WL 20SDR USAA050932Floorbeam · corrodedPIT - FOUND BEAM CORRODED .75 INCH BY .75 INCH, ON FLOORBEAM FRAME 66 - Y 53 INCH. CORROSION LEVEL 1, TASK JA-260-53500. REPLACED BEAM PER SRM 53-41-00. (M)SDR USAA050933Floorbeam · corrodedPIT - FOUND BEAM CORRODED 1 SQUARE INCH, FLOOR SUPPORT AT C-20 Y-254. INSTALLED REPAIR ANGLE PER SRM 53-00-14, PAGE 223/224 FIG 204. (M)SDR USAA050934Floorbeam · corrodedPIT - FOUND FLOORBEAM CORRODED .75 INCH DIAMETER AREA, FLOORBEAM AT Y1292 LEFT AT C-20. CUT OUT DAMAGE, INSTALLED FILLER AND ANGLES PER SRM 53-10-14. CORROSION LEVEL 1, TASK JA-220-53500.SDR USAA050937Floorbeam · corrodedPIT - FOUND FLOORBEAM CORRODED 1 SQUARE INCH, BETWEEN FRAME 66/68 AT Y-48 INCHES LEFT. DEFECTIVE PART REPLACED WITH IDENTICAL PART NR PER SRM 51-72-11. CORROSION LEVEL 1, TASK JA-260-53500. (M)SDR USAA050916Floorbeam · corrodedBFM - C3 - FLOORBEAM CAP, 6 INCHES L X 2.5 INCHES W X .05 INCH, CORROSION; NO LEVEL OR TASK, STA 324, RBL 40-46. REPAIRED IAW SRM AND EA. (K)SDR USAA050915Floorbeam · corrodedBFM - C3 - FLOORBEAM CAP 4.2 INCH X .020 INCH, 2 INCH X 2 INCH X .027 INCH, 2 INCH X 3 INCH X .020 INCH, 3.5 INCH X 2 INCH X .020 INCH, CORROSION; NO LEVEL OR TASK, STA 365, RBL 4 INCH/ RBL, 14 INCH/RBL 55 INCH/RBL 61. REPAIRED IAW EA. (K)SDR 05FDEA02141Floorbeam · corrodedFLOORBEAM AT STA 620 RBL 0-24.5 HAS CORROSION ON UPPER CAP. REMOVED DAMAGED AREA IAW SRM 53-10-8. FAB REPAIR PARTS, T-ANGLE, SUPPORT ANGLE, STRAP, IAW SRM 53-10-3 FG 3 PG 18. TREATED AND PRIMED PARTS IAW SRM 51-10-2. INSTALLED PARTS IAW SRM 53-10-8 FIG 3 PSDR SWAA052251Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND LONGITUDINAL FLOORBEAM CORRODED AT BS 794, BETWEEN LBL 8 & LBL 12. REPAIRED FLOORBEAM PER SWA EA.SDR AWXA200500971Floorbeam · corrodedMCN - MAJOR REPAIR - DURING C16 CHECK DISCOVERED CORROSION ON FLOOR BEAM SUPPORT AT BL 29L AND BL 14R, BS 995, WL 208. MAINTENANCE REMOVED CORROSION FROM FLOOR BEAM SUPPORTS AND FOUND TO BE OUT OF LIMITS IAW BOEING 737-300 SRM 53-60-51-1 FIG 101. REMOVED FLOSDR SWAA052232Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND COCKPIT FLOORBEAM CORRODED AT BS 270, BL 0 TO RBL 14. REPAIRED FLOORBEAM PER SRM.SDR 05FDEA02126Floorbeam · corrodedBS 344 FLOORBEAM CORROSION FOUND ALONG TOP OF FLANGE IN VARIOUS PLACES.SDR DU4R0507167Floorbeam · crackedCRACKED CAP ON FLOORBEAM AT BS 900 BL 54L TO 64L WL 208.1.SDR SWAA052208Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FLOORBEAM CORRODED AT BS 986, RBL 25 TO RBL 44. REPAIRED FLOORBEAM PER SRM.
Back to JASC 5315