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 SWIA200514891Floorbeam · crackedMAIN FUSELAGE FLOORBEAM AT LBL 9.0 OUTBOARD ATTACH ANGLE AT FS 280 IS CRACKED. ITEM FOUND AT C-CHECK INSPECTION. REPLACED ANGLE IAW CRJ SRM 51-40-11, 51-42-06, 51-42-21, 51-21-11, 51-25-16, 51-23-00.SDR SWAA051009Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND CORROSION ON CABIN FLOORBEAM UPPER CHORD AT BS 344, BETWEEN RBL 8 TO LBL 35. REPAIRED FLOORBEAM PER SRM.SDR SWAA051008Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND CORROSION ON CABIN FLOORBEAM UPPER CHORD AT BS 328, LBL 16. REPAIRED FLOORBEAM PER SRM.SDR EIA2005099Floorbeam · crackedBS 600 UPPER DECK FLOOR BEAM UPPER CHORD HORIZONAL FLANGE FASTENER HOLE AT RBL 27 FOUND CRACKED APPROX .0030 INCH IN LENGTH RUNNING AFT. CRACKED FASTENER HOLE FURTHER OVERSIZED TO .31 INCH. FOUND CRACK FREE CONDITION. THE HOLE REPAIRED PER SB53A2452 PT 3 RESDR USAA050522Floorbeam · corrodedPIT - FOUND FLOORBEAM CORRODED 2 INCH BY 2 INCH AREA, LEFT INBOARD AFT FLOORBEAM Y765 FRAME C64-C70. DEFECTIVE PART REPLACED WITH IDENT PART PER SRM 53-41-14. CORROSION LEVEL 1, TASK JA-260-53500. (M)SDR 2005UALA00310Floorbeam · corrodedAFT CABIN FLOORBEAM IS CORRODED AROUND FASTENERS AT APPROXIMATELY BS 1661 RBL 58. DAMAGE CAUSED BY FLOORBEAM CORROSION IN WET AREAS OF THE CABIN. NEW T-CAP WAS FABRICATED AND INSTALLED TO REPLACE THE DAMAGED PORTION OF THE FLOORBEAM.SDR USAA050465Floorbeam · corrodedPIT - FOUND FLOORBEAM CORRODED 1 BY .5 BY .030 INCH, .75 INCH BY .5 INCH BY .030 INCH, .75 BY .3750 BY .05, FLOOR BEAM 10 INCHES LEFT OF CENTER LINE BETWEEN C16 AND C22. DEFECTIVE PART REPLACED WITH IDENT PART. (M)SDR 05FDEA00851Floorbeam · damagedREPAIR NEEDS EVALUATION FOR FAA APPROVED DATA AND MAJOR OR MINOR CLASSIFICATION. FLOORBEAM NR 35 C R OF CENTER LINE. COMPLIED WITH FEDEX EA NR 6-5310-87772 AND CLASSIFIED AS A MINOR REPAIR PER FEDEX EA NR 6-5310-87772 AND FEDEX GMM 6-2-100.SDR 05FDEA00850Floorbeam · damagedREPAIR NEEDS EVALUATION FOR FAA APPROVED DATA AND MAJOR OR MINOR CLASSIFICATION. FLOORBEAM NR 34 R L OF CENTER LINE. COMPLIED WITH FEDEX EA NR 6-5310-87772 AND CLASSIFIED AS A MINOR REPAIR PER FEDEX EA NR 6-5310-87772 AND FEDEX GMM 6-2-100.SDR EIA2005093Floorbeam · crackedU/D FLOORBEAM UPPER CHORD AT BS 340 CRACK FOUND AT 4 EA FASTENERS HOLES AS PER ATTACHED FIGURE. FLOORBEAM UPPER CHORD REPAIRED AT BS 340 RBL 42 TO RT MOST O/B PER HAECO REPAIR SCHEME R53-35268 AND LBL37, LBL 46 REPAIRED PER SB63A2431 FIG 9.SDR EIA2005092Stiffener · crackedU/D B480 FLOORBEAM WEB ATT VERTICAL STIFFENER CRACKED. STIFFENER WAS REPLACED PER SRM 51-10-01.SDR AWXA200500508Floorbeam · corrodedSAL - MAJOR REPAIR - DURING C-08 CHECK, CORROSION WAS FOUND ON BEAM Y1292 AT FR 67. MAINTENANCE REMOVED CORRODED SECTION OF BEAM Y1292 FROM FS 66 TO FS 68; FABRICATED A NEW REPLACEMENT BEAM PER DWG D53472172; INSTALLED REPAIR PART IAW A320 SRM 51-42-11.SDR AWXA200500507Floorbeam · corrodedSAL - MAJOR REPAIR - DURING C-08 CHECK, EXFOLIATION CORROSION WAS FOUND ON BEAM -Y765 AT FS 66 HARD POINT. MAINTENANCE REMOVED CORRODED SECTION OF BEAM -Y765 FROM FS 66 TO FS 68+4"; RECEIVED AND INSTALLED NEW REPLACEMENT BEAM IAW A320 SRM 51-72-11.SDR AWXA200500496Floorbeam · corrodedSAL - MAJOR REPAIR - DURING C-08 CHECK GALVANIC CORROSION WAS FOUND ON BEAM Y500 LT AT FR 66. MAINTENANCE REMOVED CORRODED BEAM Y500 LT AT FR 66; FABRICATED A NEW REPLACEMENT BEAM; INSTALLED REPAIR PART IAW A320 SRM 51-72-11.SDR SWIA200515561Floorbeam · crackedFS 621 FLOORBEAM ANGLE RBL 42 CRACKED, ITEM FOUND AT C-CHECK INSPECTION. REPAIRED ANGLE IAW CRJ REO 601R-53-61-117 REV "B".SDR SWIA200515560Floorbeam · crackedFS 621 FLOORBEAM ANGLE LBL 42 CRACKED, ITEM FOUND AT C-CHECK INSPECTION. REPAIRED ANGLE IAW CRJ REO 601R-53-61-117 REV "B".SDR USAA050534Floorbeam · corrodedBFM - FOUND FLOOR SUPPORT CORRODED 2.5 INCHES LONG BY 1 INCH WIDE BY .045 INCH DEEP, AFT CARGO FLOOR SUPPORT BS 773 LBL 12.5 - RBL 8.10. FABRICATED DOUBLERS AND INSTALLED PER TYPICAL REPAIR 53-10-06B. (M)SDR USAA050450Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED .5 INCH, STATION 328 RBL 11. INSTALLED REPAIR DOUBLERS IAW SRM 51-10-51. (M)SDR 2005UALA00292Floorbeam · corrodedFLOORBEAM HAS LIGHT SURFACE CORROSION LOCATED STA 294.5 RT RBL 38. REPLACED HAT CHANNEL.SDR 2005UALA00291Floorbeam · damagedAFT CABIN FLOORBEAM HAS EXCESSIVE MATERIAL LOSS OF 15 PERCENT TO 88 PERCENT STA 947 LBL 43 TO RBL 52. REPLACED T-CAP.SDR AWXA200500466Floorbeam · corrodedMCN - MAJOR REPAIR - DURING C-19 CHECK CORROSION WAS FOUND ON TRANSVERSE FLOORBEAM UPPER CHORD AT BS 986 BETWEEN RBL 18 AND RBL 43, WL 208. MAINTENANCE BLENDED OUT CORROSION ON TRANSVERSE FLOORBEAM UPPER CHORD AT BS 986 BETWEEN RBL 18 AND RBL 43; FABRICATED ASDR 2005UALA00287Floorbeam · corrodedSTATION 1016 FLOORBEAM UPPER T-CAP HAS CORROSION FROM LBL 25 TO LBL 45. REPLACED T-CAP.SDR 2005UALA00271Floorbeam · corrodedCABIN FLOORBEAM CAP AT FS 365 RBL 33 CORRODED AT EXISTING REPAIR. DAMAGE TO THE FLOOR BEAM CAUSED BY TYPICAL CORROSION. REMOVED THE EXISTING REPAIR AND FABRICATED NEW T-CAP SPLICED INTO EXISTING TEE CAP.SDR 05FDEA00755Floorbeam · crackedFLOORBEAM IS CRACKED 66 INCH RIGHT OF CENTER LINE AT FRAME 54.3 UNDER CEILING PANEL 152BC IN AFT CARGO, (PANEL NOT REMOVED FOR C-CHECK). REMOVED FLOOR PANEL 252DF AND CEILING PANEL 152BC FOR ACCESS IAW A310-200 SRM 51- 40-21. CUT OUT DAMAGED AREA, FABRICATESDR 05FDEA00722Floorbeam · crackedCTR CARGO, DOOR ENTRANCE AFT AREA STA 1781 RT MOST OUTBD END LATERAL FLOORBEAM UPPER CAP FOUND CRACK. CARRIED OUT REPAIR IAW FEDEX EA 1-5310-83087.SDR USAA050529Floorbeam · corrodedBFM - FOUND FLOOR SUPPORT CORRODED 4 INCHES LONG BY 2.5 INCHES WIDE BY .05 INCHES DEEP, AFT CARGO COMPARTMENT FLOOR SUPPORT BS 727D PLUS LBL 12.5- RBL 8.10 INCH. CORROSION LEVEL 1, TASK C53-202-01. INSTALLED REPAIR ANGLE IAW TYPICAL REPAIR 53-10-06B AND 53-6SDR 0500695531Floorbeam · crackedDURING H-CHECK FOUND CRACK IN FLOORBEAM AT BS 660 LBL 45. REPAIRED PER EA 55-202918.SDR EIA2005054Floorbeam · crackedUPPER DECK FLOORBEAM UPPER CHORD AT BS 360 FOUND CRACKED AT 4 EA FASTENER HOLES. LOCATION AT LBL 55, RBL 23, RBL 58 REPAIRED PER S/B 53A2431 FIG 9. LBL 33 REPAIRED PER S/B 53A2431 FIG 10.SDR SWIA200514865Floorbeam · crackedRBL 9 AT FS 280.00 INBOARD ANGLE IS CRACKED. ITEM FOUND AT C-CHECK INSPECTION. CLIP REPLACED IAW CRJ SRM 51-42-21 AND 51-42-06.SDR SWIA200514864Floorbeam · crackedRBL 9 AT FS 280.00 OUTBOARD ANGLE IS CRACKED. ITEM FOUND AT C-CHECK INSPECTION. CLIP REPLACED IAW CRJ SRM 51-42-21 AND 51-42-06.SDR SWIA200514863Floorbeam · crackedLBL 9 AT FS 280.00 OUTBOARD ANGLE IS CRACKED. ITEM FOUND AT C-CHECK INSPECTION. REPLACED CLIP IAW CRJ SRM 51-42-21, 51-42-06.SDR SWIA200514862Floor Support · crackedFLOOR SUPPORT ANGLE CRACKED AT FUSELAGE STA 621.0 LEFT SIDE LBL 38. ITEM FOUND AT C-CHECK INSPECTION. REPAIR ANGLE IAW CRJ REO 601R-53-61-117 REV B.SDR USAA050431Floorbeam · corrodedCLT - Q4 - FLOORBEAM, (.5 INCH) CORROSION. STA 312, BL 0 TO RBL 10. SPLICED IN NEW T-CAP IAW SRM. (K)SDR SWAA050966Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND CORROSION ON FLOORBEAM UPPER T-CAP AT BS 986, BETWEEN RBL 45 TO LBL 45. REMOVED AND REPLACED UPPER T-CAP PER TYPICAL REPAIR MANUAL.SDR USAA050457Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED .5 INCH DIAMETER, STATION 312 BL 0 TO BL 10 RT. SPLICED IN NEW T-CAP IAW SRM 53-10-51. (M)SDR EIA2005052Floorbeam · crackedU/D FLOORBEAM UPPER CHORD ONE FASTENER HOLE FOUND CRACKED AT BS 520 LBL 45 AFT FLANGE. THE CRACK PORTION TRIMMED OFF AND NDT CONFIRMED CRACK FREE CONDITION, THE FLOORBEAM REPAIRED PER SB 747-53-2452 FIG 9.SDR 2005UALA00270Floorbeam · corrodedAFT CABIN FLOORBEAM T-CAP HAS CORROSION AT STA 967 LBL 17 TO RBL 12. REPLACED TEE CAP.SDR 2005UALA00269Floorbeam · corrodedCABIN FLOORBEAM UPPER SURFACE LIGHT CORROSION AT STA 312 AT RBL 8 WL 208. REPLACED TEE CHORD.SDR 2005UALA00268Floorbeam · corrodedAFT CABIN FLOORBEAM STA 986 RBL 16 TO RBL 28 WL 208 IS CORRODED. REPAIR ANGLE AND FLOOR BEAM T-CAP REPLACED.SDR AWXA200500476Floorbeam · corrodedMCN - MAJOR REPAIR - DURING C-19 CHECK CORROSION WAS FOUND ON FLOORBEAM UPPER CHORD AT BS 312 BETWEEN LBL 8 AND RBL 8, WL 208. MAINTENANCE CUTOUT DAMAGED SECTION OF FLOORBEAM UPPER CHORD AT BS 312 FROM LBL 20 TO RBL 21; FABRICATED A NEW REPLACEMENT SECTION OFSDR AWXA200500474Floorbeam · corrodedMCN - MAJOR REPAIR - DURING C-19 CHECK CORROSION WAS FOUND ON UPPER CHORD AT BS 294 BETWEEN RBL 7 AND RBL 44, WL 208. MAINTENANCE CUTOUT DAMAGED UPPER CHORD AT BS 294 FROM RBL 7 TO RBL 44; FABRICATED A NEW REPLACEMENT SECTION OF UPPER CHORD AND 2 EACH REPAIR SDR DHL2005740017Floorbeam · corrodedMAIN CABIN FLOORBEAM TEE CAP DAMAGED AT BS 344 RBL 65.5 TO LBL 65.5. REMOVED AND REPLACED TEE CAP BS 344 RBL 65.5 TO 65.5 FROM P/N BAC1505-29222 PO NR 9001043 DIM 12 FT IAW B727 SRM 53-10-2 FIG 6, 51-30-5 AND DWG NR 2902 VENTURA AEROSPACE. TREATED AND PRIMEDSDR ASOA05310Floorbeam · corrodedDURING HANGAR MAINTENANCE, THE FS 280 FLOORBEAM WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REPAIRED THE FS 280 FLOORBEAM IAW EO. (K)SDR CALA0500088Floorbeam · corrodedINSPECTION FOUND THE MAIN CABIN FLOORBEAM CORRODED AT STA 986.5, LBL 43. REPAIRED IAW ECRA 5321-01211.SDR 05FDEA00633Floorbeam · damagedWHILE ACCESSING FOR BARRIER MOD FOUND REPAIR ON FLOORBEAM BL 0 NEEDS REWORK TO ACCOMPLISH INSTALLATION OF EXTENDED SEAT TRACK. REPAIRED PER SRM 53-10-8SDR SWIA200515125Floorbeam · crackedFS 621 LT FLOORBEAM ANGLE CRACKED AT LBL 41.0, ITEM FOUND AT C-CHECK INSPECTION. REPAIRED IAW CRJ REO 601R-53-61-117 REV B.SDR SWIA200515124Floorbeam · crackedFS 621 RT FLOOR SUPPORT ANGLE CRACKED AT LBL 41.0, ITEM FOUND AT C-CHECK INSPECTION. REPAIRED FLOOR SUPPORT ANGLE IAW CRJ REO 601R-53-61-117 REV B.SDR ASAA0540197Floorbeam · corrodedFLOORBEAM FORWARD UPPER TEE IS CORRODED AT BSTA 344 LBL 15. REMOVED DAMAGED (T) CHORD, FABRICATED AND INSTALLED A REPLACEMENT (T) CHORD IAW SRM. (K)SDR ASAA0540194Web · crackedMAIN CABIN STA 344 APPROX. LBL 45 AT T-CHORD IS CRACKED. REMOVED DAMAGE, FABRICATED AND INSTALLED A REPLACEMENT DOUBLER, A REPAIR PLATE, AND REPAIR WEB SEGMENT. (K)SDR SWIA200515206Floorbeam · crackedFS 280 L FLOORBEAM LBL 9.0 OB ATTACH ANGLE CRACKED (ITEM FOUND AT C-CHECK INSPECTION.) ANGLE REPLACED IAW CRJ SRM 51-40-11, 51-42-06, 51-42-21, 51-23-00 AND 51-21-11.
Back to JASC 5315