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 SWIA200312293Floorbeam · crackedCARGO PIT HAS FLOORBEAM WITH BUCKLED WEB & CRACKED AT FS 589.0 - FS 605.0; LBL 27 INBOARD SIDE. DISCOVERED DURING C-CHECK, REPAIRED IAW CRJ SRM 51-24-36.SDR 2003UALA00576Floorbeam · corrodedMAIN CABIN FLOORBEAM STA 947.5 HAS CORRODED T- CAP BEYOND LIMITS. MAJOR REPAIR ACCOMPLISHED. INSTALLED T-CAP SECTION SPLICE REPAIR.SDR CALA0300396Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT L-2 DOOR AFT GIRT BAR ATTACH POINT, STA 986. A REPAIR WAS ACCOMPLISHED ON UPPER CHORD OF FLOORBEAM IAW ECRA 5310-03851.SDR DL73S030674Floorbeam · damagedDURING ACCOMPLISHMENT OF EO 03-062982-03AD, MTC ADDED ADDITIONAL FASTENER HOLES THROUGH THE UPPER CAP AND SPLICE ANGLES OF THE CENTER WING BOX FLOORBEAMS FROM BS 650 TO 675 AT BL 0.07. REPAIR PER ER/A 385423-14AD.SDR USAA030119Floorbeam · crackedPIT - FOUND FLOORBEAM CRACKED APPROX 1 INCH, BS 328 RBL 10.0. DOUBLER INSTALLED PER EA 76205. (M)SDR C2XA03SH222Floorbeam · corrodedDURING C-CHECK, THE LT FLOORBEAM AT FRAME 20 WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED THE DAMAGED AREA AND PERFORMED A DOUBLER REPAIR IAW EMB 145 SRM 53-21-10 FIGURE 201. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR CALA0300665Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED IN FORWARD GALLEY AREA AT STA 328, RBL 29. THE CORROSION WAS REMOVED AND A STRAP WAS INSTALLED IAW SRM 53-00-51.SDR CALA0300664Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 986.5, RBL 16. REPAIRED IAW SRM 51-10-02.SDR CALA0300663Floorbeam · corrodedINSPECTION FOUND AFT CABIN FLOORBEAM CORRODED AT STA 1006, LBL 15. A STRAP DOUBLER WAS INSTALLED IAW SRM 53-00-51.SDR CALA0300662Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED IN AFT LAV AREA AT STA 1016, RBL 10. INSTALLED REPAIR STRAP IAW SRM 53-00-51, FIGURE 203.SDR CALA0300661Floorbeam · corrodedINSPECTION FOUND AFT CABIN FLOORBEAM CORRODED AT STA 986.5, RBL 46. REPAIRED IAW SRM 53-00-51, FIGURE 203.SDR SWAA031566Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND FLOORBEAM CORRODED AT BS 312, WL 208 AND LBL 17 TO RBL 12. REPAIRED FLOORBEAM PER SRM.SDR 2003UALA00563Floorbeam · corrodedCABIN AT BS 852, RBL 56, TRANSBEAM UPPER CAP IS CORRODED. MAJOR REPAIR ACCOMPLISHED. INSTALLED SPLICE, ANGLE AND FILLER REPAIR.SDR ASOA03311Floorbeam · crackedDUIRNG HANGAR MAINTENANCE AT CKB, THE FLOORBEAM ON THE PILOTS BULKHEAD AT FS 280, LBL AND RBL 9 WAS FOUND TO BE CRACKED BEYOND LIMITS. MAINTENANCE REPAIRD THE FLOORBEAM ON THE PILOTS BULKHEAD AT FS 280, LBL AND RBL 9 IAW ASA EO 600-53-0090. (M)SDR 2003UALA00559Floorbeam · gougedMAIN CABIN FLOORBEAM TOP CAP GOUGED AT BS 340, RBL 28 TO RBL 30. MAJOR REPAIR ACCOMPLISHED. REPAIRED FLOORBEAM T-CAP WITH SPLICE SECTION, ANGLES AND FILLERS.SDR 03FDEA01097Floorbeam · crackedFLOORBEAM CRACKED ON BEAM 27 FWD LOWER CARGO PIT 17 INCHES OF CENTRLINE. REPAIRED FLOORBEAM IAW A300-600 IAW ENG DISPO PAGE 2 AND 3. FAB 2 EA ANGLES IAW SRM 53-10-15,HFEC INSPECT IAW SRM 51-10-08. PENETRANT INSPECTION IAW SRM 51-90-00,PART ID PMS 01-06-08.SDR AWXA200300854Floorbeam · crackedDURING C-14 CHECK .25 INCH CRACK WAS FOUND ON UPPER SURFACE OF FLOORBEAM BS 312, RBL 11, WL 208. MAINTENANCE CUT OUT DAMAGE ON UPPER SURFACE OF FLOORBEAM BS 312, RBL 11; FABRICATED A NEW SECTION OF FLOORBEAM, A FILLER, AND 2 EACH REPAIR ANGLES; INSTALLED REPASDR SWAA031541Floorbeam · corrodedDURING SCHEDULED SPECIAL VISIT, FOUND FLOORBEAM CORRODED AT BS 344, BL 0. REPAIRED FLOORBEAM PER SRM.SDR SWAA031542Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM CORRODED AT BS 986, RBL 44. REPAIRED FLOORBEAM PER T1-453-037.SDR SWAA031538Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND LONGITUDINAL FLOORBEAM CORRODED AT BS 752, RBL 3. REPAIRED FLOORBEAM PER SWA EA.SDR SWAA031534Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND LONGITUDINAL FLOORBEAM CORRODED AT BS 727D + 6, FROM RBL 3 TO LBL 12. REPAIRED FLOORBEAM PER SWA EA.SDR SWAA031533Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND LONGITUDINAL FLOORBEAM CORRODED AT BS 772, FROM LBL 3 TO LBL 12. REPAIRED FLOORBEAM PER SWA EA.SDR 03FDEA01094Floorbeam · corrodedCORROSION ON FLOOR SUPPORT BS 344, LBL 45, WL 208. CORROSION ON FLOORBEAM BS 344, LBL 45, WL 208. REPAIRED FLOORBEAM IAW SRM 53-10- 1, 51-10-1, 51-30-2 & 53-10-8.SDR ASOA03330Floorbeam · corrodedDURING A C-CHECK IN BNA, THE FLOORBEAM AT FS 36 TO FS 39 WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REPAIRED THE FLOORBEAM AT FS 36 AND FS 39 IAW SRM 51-25-01. (M)SDR SIMA200319705Floorbeam · corrodedABI - DURING AN MBV INSPECTION, THE LEFT OMEGA BEAM AT FRAME 20 WAS FOUND TO BE CORRODED BELOW SRM LIMITS. CUT OUT DAMAGED SECTIN OF OMEGA BEAM, CLEANED AND TREATED THE REPAIR AREA. FABRICATED AND EXTERNAL ANGLE, ANGLE, FILLER, AND TWO SHIMS. REPAIR DONE IASDR SIMA200319706Floorbeam · corrodedABI - DURING AN MBV INSPECTION, THE LEFT OMEGA BEAM AT FRAME 20 WAS FOUND TO BE CORRODED BELOW SRM LIMITS. CUTOUT DAMAGED SECTION OF LEFT OMEGA BEAM CLEANED AND TREATED THE REPAIR AREA. FABRICATED AN EXTERNAL ANGLE, FILLER AND TWO SHIMS. REPAIR DONE IAW EMBSDR AWXA200300835Floorbeam · corrodedMCN - MAJOR REPAIR - DURING C-04 CHECK EXFOLIATION CORROSION WAS FOUND ON UPPER SURFACE OF FLOORBEAM Y1292, BETWEEN FR 16-18. MAINTENANCE REMOVED CORROSION AND FOUND MATERIAL LOSS TO BE OUT OF LIMITS; CUT OUT DAMAGED AREA OF FLOORBEAM Y1292, BETWEEN FR 16-17; SDR AWXA200300833Floorbeam · corrodedMCN - MAJOR REPAIR - DURING C-04 CHECK EXFOLIATION CORROSION WAS FOUND ON UPPER SURFACE OF FLOORBEAM (DUMMY RAIL) Y503, FR 16. MAINTENANCE REMOVED CORROSION AND FOUND MATERIAL LOSS TO BE OUT OF LIMITS; REMOVED FLOORBEAM Y503 FROM FR 12 TO FR 16; FABRICATED A NSDR AWXA200300832Floorbeam · corrodedMCN - MAJOR REPAIR - DURING C-04 CHECK CORROSION WAS FOUND ON UPPER SURFACE OF FLOORBEAM Y1292, FR 66. MAINTENANCE REMOVED CORROSION AND FOUND MATERIAL LOSS TO BE OUT OF LIMITS; REMOVED FLOOR BEAM Y1292 FROM FR 64 TO FR 66; FABRICATED A NEW REPLACEMENT SECTIONSDR AWXA200300831Floorbeam · corrodedMCN - MAJOR REPAIR - DURING C-04 CHECK EXFOLIATION CORROSION WAS FOUND ON UPPER SURFACE OF FLOORBEAM Y1292, FR 68. MAINTENANCE REMOVED CORROSION AND FOUND MATERIAL LOSS TO BE OUT OF LIMITS; REMOVED FLOORBEAM Y1292 FROM FR 68 TO FR 69; FABRICATED A NEW REPLACESDR AWXA200300820Floorbeam · corrodedDURING C-04 CHECK EXFOLIATION CORROSION WAS FOUND ON UPPER SURFACE OF FLOORBEAM Y1292 AT FR 68. MAINTENANCE REMOVED CORROSION AND FOUND MATERIAL LOSS TO BE OUT OF LIMITS; REMOVED DAMAGED SECTION OF FLOORBEAM 1292 AT FR 68; FABRICATED A NEW REPLACEMENT SECTIONSDR AWXA200300818Floorbeam · corrodedMCN - MAJOR REPAIR - DURING C-04 CHECK EXFOLIATION CORROSION WAS FOUND ON FLOORBEAM Y254, FR 20. MAINTENANCE BLENDED OUT CORROSION AND FOUND MATERIAL LOSS TO BE OUT OF LIMITS; REMOVED DAMAGED AREA OF FLOORBEAM Y254 AT FR 20; FABRICATED A REPAIR ANGLE AND FISDR AWXA200300809Floorbeam · corrodedDURING C-04 CHECK EXFOLIATION CORROSION WAS FOUND ON FLOORBEAM Y-1292, BETWEEN FR67 AND FR 68. MAINTENANCE REMOVED CORROSION AND FOUND MATERIAL LOSS TO BE OUT OF LIMITS; REMOVED CORRODED FLOORBEAM Y-1292, BETWEEN FR67 AND FR 68; INSTALLED A NEW REPLACEMENT FLSDR UPS03841041Floorbeam · corrodedINSPECTION TYPE: C2, MAIN CABIN STA 920 LBL 49 FLOORBEAM HAS CORROSION. REMOVED CORROSION IAW DC8 SRM 51-1-8. ORIG .340 INCH REMAINING .120 INCH OUT OF LIMITS IAW DC8 SRM 53-2-0. FABRICATED REPAIR ANGLES, SHIM FOR ANGLES AND SHIM FOR BLENDED OUT DAMAGE IAW SDR UPS03841040Floorbeam · corrodedINSPECTION TYPE: C2, FLOORBEAM CORRODED AT STA 980 LBL 58 MAIN CABIN. REMOVED CORROSION, OUT OF LIMITS IAW DC8 SRM 53-2-0, 51-1-8; CUT OUT DAMAGE IAW DC8 SRM 53-2-0. FABBED FILLER, ANGLE, SHIM FOR WEB IAW DC8 SRM 53-2-0 FIG 1B&G; ALODINED & PRIMED IAW DCSDR 2003UALA00547Floorbeam · corrodedCABIN FLOORBEAM BS 286, RBL 88 CORRODED. MAJOR REPAIR ACCOMPLISHED. INSTALLED SPLICE SECTION, ANGLES AND FILLERS.SDR 2003UALA00546Floorbeam · corrodedFLOOR BEAM TOP CAP CORRODED AT BS 266 RBL 76. MAJOR REPAIR ACCOMPLISHED. INSTALLED SPLICE SECTION, ANGLES AND FILLERS.SDR 2003UALA00544Floorbeam · corrodedCABIN FLOOR AT BS 852, RBL 56, TRANSBEAM UPPER CAP IS CORRODED. MAJOR REPAIR ACCOMPLISHED. INSTALLED SPLICE SECTION, ANGLES AND FILLERS.SDR 2003UALA00536Floorbeam · corrodedMAIN CABIN STATION 246 FLOORBEAM IS CORRODED AT RBL 78- T-CAP. MAJOR REPAIR ACCOMPLISHED. INSTALLED SPLICE SECTION, ANGLES AND FILLERS .SDR 2003UALA00535Floorbeam · corrodedFLOORBEAM CORRODED AT STATION 830-873, LBL 12. MAJOR REPAIR ACCOMPLISHED. INSTALLED SPLICE SECTION WITH ANGLES AND FILLERS.SDR CALA0300361Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED ON UPPER SURFACE AT STA 1006 BETWEEN RBL 24 AND RBL 32 AND RBL 27 INTERCOSTAL BS 1006-1016. A REPAIR WAS INSTALLED IAW SRM 53-00-51, FIGURE 202, PAGE 207-211.SDR GTIA030590Floorbeam · corrodedFTW - FOUND CABIN FS 1338 FLOORBEAM UPPER SIDE CORRODED/BARE METAL LBL 57-RBL 57. CUT APPROX 2 INCHES BY 1 INCH SECTION OUT OF TOP FLANGE. FABRICATED REPAIR ANGLE-FILLER. INSTALLED REPAIR ANGLE AND FILLERS. (M)SDR SWAA031457Floorbeam · crackedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM CRACKED AT BS 706, LBL 57. REPAIRED FLOORBEAM PER SWA EA.SDR 2003F00570Floorbeam · corrodedDURING C-CHECK INSPECTION, THE FLOORBEAM UPPER CHORD WAS FOUND TO BE CORRODED AT THE L1 DOOR AT STATION 344 LBL 24. THE DAMAGE EXCEEDS THE ALLOWABLE DAMAGE LIMITATIONS AND IS BEING REPAIRED ON NON ROUTINE 031642. (M)SDR USAA030102Floorbeam · corrodedFOUND FLOORBEAM CORRODED .5 INCH BY 1 INCH AREA, FLOORBEAM STATION 947 LBL 24.75 TO RBL 24.75. REPAIR FLANGE PER TYPICAL REPAIR 53-60-02 REV A, PART B. (M)SDR C2XA03SH203Floorbeam · corrodedSHV-DURING C-CHECK THE CENTER FLOORBEAM BETWEEN FRAMES 16 AND 24 WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED FLOORBEAM IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR SWIA200312150Floorbeam · crackedFS 280 FLOORBEAM I/B AND O/B ATTACH ANGLES RBL 9.0 CRACKED. DISCOVERED DURING C-CHECK. ANGLES REPLACED IAW CRJ SRM 51-40-11.SDR AWXA200300781Floorbeam · crackedMCN - MAJOR REPAIR - DURING C-14 CHECK A .3125 INCH CRACK WAS FOUND THE LOWER SURFACE OF TRANSVERSE FLOOR BEAM AT BS 344, LBL 46. MAINTENANCE REPAIRED CRACKED STRAP ON LOWER SURFACE PER BOEING SRM 53-10-51 PAGE 213-219 FIG. 204.SDR 03FDEA00971Floorbeam · chafedBS 740 FLOORBEAM IS CHAFED IN AREAS FROM LBL-45 RBL 45 WL 208. REPAIRED FLOORBEAM IAW EA 7-5310-54878.SDR AWXA200300752Channel · crackedMCN - MAJOR REPAIR - DURING C-14 CHECK A .6875 INCH CRACK WAS FOUND ON STRAP LOWER SURFACE OF TRANSVERSE FLOORBEAM AT BS 328, BL 0. MAINTENANCE STOP DRILLED CRACK ON STRAP LOWER SURFACE OF TRANSVERSE FLOORBEAM AT BS 328, BL 0; FABRICATED A STRAP REPAIR DOUBLE
Back to JASC 5315