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 DL76G071279Floorbeam · corrodedAFT COMPARTMENT STATION 1197 AT LBL 22 CARGO LOWER FLOORBEAM TOP SURFACE CORRODED. REPAIRED PER 53-00-07 REPAIR 4 FIGURE 201 ON NON ROUTINE AMW512514.SDR SWAA074899Floorbeam · corrodedDURING SCHEDULED 8Y CHECK, FOUND FLOORBEAM CORRODED AT BS 328, RBL 20. REPAIRED FLOORBEAM PER SWA EA.SDR SWAA074896Floorbeam · corrodedDURING SCHEDULED 8Y CHECK, FOUND FLOORBEAM CORRODED AT BS 986.5, LBL 15 TO RBL 25. REPAIRED FLOORBEAM PER ER.SDR 07FDEA04426Floorbeam · corrodedFOUND CORROSION AT UPPER FLANGE OF TOP CAP BEAM C33 SPLICE REPAIR PERFORMED IAW SRM 53-10-15 FIG 207.SDR 07FDEA04397Floorbeam · damagedFOUND OLD MISDRILLED HOLE AT CROSSBEAM C 64 REPAIR PERFORMED BY REPLACEMENT OF PART IAW SRM 51-72-10.SDR 07FDEA04389Floorbeam · corrodedFOUND CROSSBEAM C 63 CORRODED. REPAIR PERFORMED BY REPLACEMENT OF PART IAW SRM 51-72-10.SDR C1HA200786005Floorbeam · corrodedCORROSION ON FLOORBEAM AT BS 1035 LBL 24-45. REMOVED EXISTING PART, FABRICATED NEW PART; TREATED AND PRIMED AND INSTALLED NEW PART IAW B727 SRM 51-30-2 FIG 1 AND 3.SDR C1HA200786003Floorbeam · corrodedNUMEROUS AREAS OF CORROSION ON FLOOR BEAM AT BS 344 LBL 25 - RBL 6. CUT OUT DAMAGED AREA. FABRICATED REPAIR PARTS AND INSTALLED REPAIR PARTS IAW B727 SRM 53-10-8 FIG 9.SDR C1HA200786002Floorbeam · corrodedBS 1030 FLOORBEAM CORROSION LBL 25 - RBL 25 TOP SURFACE UPPER CHORD. REMOVED AND REPLACED PREVIOUS UPPER "T" CHORD REPAIR IAW B727 SRM 53-10-8 FIG 3.SDR C1HA200786001Floorbeam · corrodedBS 1110 FLOORBEAM CORROSION LBL 45 - RBL 45 TOP SURFACE UPPER CHORD. REPAIR BS 1110 FLOORBEAM IAW B727 SRM 53-10-8 FIG 3.SDR A6WA200740554Floorbeam · crackedFOUND LEFT SIDE UNDER FLOORBEAM HAS A CRACKED ATTACH ANGLE AT THE OUTBOARD SIDE OF LBL 27, FS 484, WL 70.73. (M) MAINTENANCE REMOVED CRACKED ANGLE, FABRICATED AND INSTALLED REPLACEMENT ANGLE IAW BSC SR 601R-53-0029B. (M)SDR A6WA200740553Floorbeam · crackedRIGHT SIDE UNDER FLOORBEAM HAS A CRACKED ATTACH ANGLE AT THE OUTBOARD SIDE OF RBL 27, FS 484, WL 70.73. (M) MAINTENANCE PERFORMED REPAIR TO RT SIDE FLOOR SUPPORT INTERCOSTAL ATTACH ANGLE OUTBOARD SIDE OF RBL 27 FS 484 IAW BSC SR 601R-53-0029B AND CRJ 200 SRMSDR TRAX200701430Floorbeam · corrodedETNRC - FLOORBEAM 39 CORRODED. CORROSION ON FLOORBEAM 39 REMOVED IAW SRM 51-21-42 REPAIR DETERMINED NOT TO BE A MAJOR REPAIR IN ACCORDANCE WITH S.P. 663 AND FAR 43, APPENDIX A. REPAIR ACCOMPLISHED IN ACCORDANCE WITH SRM 51-21-42 MATERIAL THICKNESS: 0.0SDR TRAX200701429Floorbeam · corrodedETNRC - FLOORBEAM 38 CORRODED. CORROSION ON FLOORBEAM 38 REMOVED IAW SRM 51-21-42. REPAIR DETERMINED NOT TO BE A MAJOR REPAIR
IN ACCORDANCE WITH S.P. 663 AND FAR 43, APPENDIX A. REPAIR ACCOMPLISHED IN ACCORDANCE WITH SRM 51-21-42 MATERIAL THICKNESS:SDR TRAX200701436Floorbeam · corrodedETNRC - FOUND CORROSION ON CROSSBEAM AT 281 JLE POSITION (CARGO) FLOOR ATTACHMENT HOLE. 10-11-07 CORROSION ON CROSS BEAM REMOVED IAW SRM 51-21-06, ALODINE APPLIED IAW SRM 51-21-11, PRIMER APPLIED IAW SRM 51-25-06 AND WHITE TOPCOUT APPLIED IAW SRM 51-25-16 SDR 07FDEA04366Floorbeam · corrodedMAIN DECK FLOORBEAM AT STA 720A LBL62 WL 208 T-CAP CORRODED OUT OF LIMITS. REMOVED CORRODED AREA, INSTALLED T-ANGLE AND SPLICE PLATE REPAIR IAW SRM 51-30-2.SDR COEA0702919Floorbeam · crackedFOUND DURING HEAVY CHECK. FOUND M7 STC NR ST01189WI FLOORBOARD SUPPORT BEAM CRACKED IN RADIUS. REMOVED AND INSTALLED NEW FABRICATED SUPPORT BEAM. (K)SDR 07FDEA04352Floorbeam · corrodedAFT CARGO STA 950F LBL 44 MAIN DECK FLOORBEAM HAS CORROSION AROUND FASTENER HOLE. REMOVED AND REPLACED T-CAP IAW SRM 51-30 AND SRM 27-53-034.SDR KCSA071428Floorbeam · damagedFLOORBEAM AT STA 760 IS DAMAGED ON AFT SIDE AT LBL 30 TO LBL 33.SDR HALA0700418Floorbeam · crackedCRACK ON FLOORBEAM AT BS 246 ON VERTICAL STIFFENER AT LBL 40 BELOW MID CHORD. REPAIRED IAW 767-300 SRM 53-10-51 FIG 206 REPAIR 2.SDR 07FDEA04351Floorbeam · corrodedMAIN CARGO DECK, STA 560 RBL 1-24, WL 208, FLOORBEAM TOP SURFACE HAS CORROSION. REMOVED AND REPLACED FLOORBEAM TEE CAP AND ANGLES IAW SR 27-53-034.SDR 07FDEA04325Floorbeam · corrodedHEAVY CORROSION ON CROSSBEAM BETWEEN FLOORBEAM 12A-14. REPLACEMENT OF CROSSBEAM IAW SRM 51-72-10.SDR 07FDEA04323Floorbeam · corrodedFOUND CORROSION ON CROSSBEAM AT FRAME 58, AFT CARGO COMPARTMENT. CROSSBEAM SPLICE REPAIR PERFORMED IAW SRM 53-10-15/FIG 207/SEC F-F.SDR 07FDEA04322Floorbeam · corrodedCORROSION ON CROSSBEAM AT FRAME 60 LT, AFT CARGO COMPARTMENT. REPAIR PERFORMED REPLACEMENT OF LT HALF-BEAM IAW SRM 51-72-10 AND BEAM SPLICE IAW SRM 53-10-15/FIG 207/SEC "E-E".SDR 07FDEA04321Floorbeam · corrodedCORROSION ON CROSSBEAM AT FRAME 62 RT, AFT CARGO COMPARTMENT. REPLACEMENT OF THE CORRODED RT HALF-BEAM IAW SRM 51-72-10 AND SPLICE IAW SRM 53-10-15/FIG 207/SEC F-F.SDR 07FDEA04320Floorbeam · corrodedFOUND CORROSION ON CROSSBEAM FRAME 62 RT OUTSIDE, AFT CARGO COMPARTMENT. REPLACEMENT OF CROSSBEAM IAW SRM 51-72-10.SDR UIEA200700404Floorbeam · corrodedMAIN DECK BS 1720 LBL 76- LBL 98 FLOORBEAM UPPER CHORD HAS LEVEL 2 CORROSION. REPAIRED PER SRM 53-10-07 FIG 2. RAM FORM AND CPCP SUBMITTED TO ENGINEERING.SDR USAA920070861Floorbeam · corrodedPIT - MAJOR REPAIR - C-4 CHECK, CORROSION ON FLOORBEAM T-CAP, BS 365.25. REPAIRED FLOORBEAM T-CAP, BS 365.25 IAW USAIRWAYS TYPICAL REPAIR 53-15-01.SDR SWAA074830Floorbeam · crackedDURING SCHEDULED SPV CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 539, RBL 25. REPAIRED FLOORBEAM PER ER.SDR SWIA200719099Floorbeam · crackedFS 280 FLOOR SUPPORT BEAM IS CRACKED AT RBL9, FOUND AT C-CHECK. COMPLIED WITH REPAIR OF FLOOR SUPPORT BEAM PER CRJ200 REO 53-11-171 REV D SCHEME B.
SDR SWIA200719098Floorbeam · crackedFS 280 FLOOR SUPPORT BEAM IS CRACKED AT LBL 9, FOUND AT C-CHECK. COMPLIED WITH REPAIR OF FLOOR SUPPORT BEAM PER CRJ200 REO 53-11-171 REV D SCHEME B.
SDR SWIA200719097Floorbeam · crackedFS 280 FLOOR SUPPORT BEAM IS CRACKED AT LBL9, FOUND AT C-CHECK. REPAIRED DAMAGED SECTION OF FLOOR ANGLE AT STA 280 LBL9 IAW CRJ200 REO 601R-53-11-138 REV NC.
SDR F3LA200700255Floorbeam · corrodedDURING C-3 CHECK, INSPECTION REPORTED CORROSION ON FLOORBEAM -Y1292 ON UPPER SURFACE AT NUTPLATE HOLE, APPROX 8 INCHES AFT OF FR 67. REMOVED AND REPLACED FLOORBEAM IAW SRM'S 51-42-11, 51-72-11 AND 51-44-11.SDR DL76G071263Floorbeam · corrodedFLOORBEAM CORRODED. REMOVED AND REPLACED FLOORBEAM UPPER CHORD PER SRM 53-00-51D.SDR DL76G071262Floorbeam · corrodedFLOORBEAM CORRODED. REMOVED AND REPLACED FLOORBEAM UPPER CHORD PER SRM 53-0051D.SDR DL76G071261Floorbeam · corrodedFLOORBEAM CORRODED. REMOVED AND REPLACED FLOORBEAM UPPER CHORD PER SRM 53-00-51.SDR DL76G071260Floorbeam · corrodedFLOORBEAM FOUND CORRODED. REMOVED AND REPLACED FLOORBEAM UPPER CHORD PER SRM 53-51D.SDR 07FDEA04263Floorbeam · corrodedHEAVY CORROSION ON CROSSBEAM, FRAME 38.2 RT TO LT, Y-805 TO 805. CROSSBEAM SPLICE REPAIR PERFORMED IAW SRM 53-10-15/FIG 207.SDR KCSA071401Floorbeam · damagedUPPER DECK FLOORBEAM DAMAGED AT BS 740, LBL 71.SDR SWIA200719117Floorbeam · crackedFS 280 FLOORBEAM IS CRACKED AT LBL9, FOUND AT C-CHECK. INSTALLED FLOORBEAM REPAIR PER CRJ700/900 SRM 51-42-21 AND 51-42-06.
SDR SWIA200719116Floorbeam · crackedCOCKPIT FLOORBEAM IS CRACKED AT FS 280 AND RBL 9, FOUND AT C-CHECK. INSTALLED COCKPIT FLOORBEA, PER CRJ700/900 SRM 51-42-06 AND 51-40-11.
SDR SIMA200727305Floorbeam · corrodedDURING A MBV INSPECTION, THE CENTER BEAM AT FRAME 20 WAS FOUND TO BE CORRODED. REMOVED OLD DOUBLER AND REPLACED WITH A NEW DOUBLER IAW EMB 145 SRM 53-21-10 STEPS 1-6. AIRCRAFT RETURNED TO SERVICE.SDR SIMA200727306Floorbeam · corrodedDURING A MBV INSPECTION, THE CENTER BEAM AT FRAME 20 WAS FOUND TO BE CORRODED ON THE LT SIDE. REMOVED OLD DOUBLER AND REPLACED WITH A NEW DOUBLER IAW EMB 145 SRM 53-21-10 STEPS 1-6. AIRCRAFT RETURNED TO SERVICESDR DL76G071246Floorbeam · corrodedFLOORBEAM UPPER CHORD FOUND CORROSION AT BS 325 RBL 26-54. REMOVED AND REPLACED FLOORBEAM PER SRM 53-00-51D.SDR 07FDEA04237Floorbeam · corrodedFOUND CORROSION AT CROSS BEAM C 64 REPAIR PERFORMED BY REPLACEMENT OF PART IAW SRM 51-72-10.SDR 07FDEA04234Floorbeam · corrodedFOUND CORROSION AT TOP CAP BEAM C63 REPAIR PERFORMED BY REPLACEMENT OF PART IAW SRM 51-72-10.SDR 07FDEA04223Floorbeam · corrodedFOUND CORROSION AT TOP CAP BEAM C64 SPLICE REPAIR PERFORMED IAW SRM 53-10-15 FIG 207.SDR 07FDEA04222Floorbeam · corrodedFOUND CORROSION AT FLANGE OF TOP CAP BEAM C 30 LT SPLICE REPAIR PERFORMED IAW SRM 53-10-15 FIG 207.SDR 07FDEA04214Floorbeam · corrodedFOUND CORROSION AT FLANGE OF TOP CAP BEAM C 32. SPLICE REPAIR PERFORMED IAW SRM 53-10-15 FIG 207.SDR 07FDEA04213Floorbeam · corrodedFOUND CORROSION AT STRUT OF TOP CAP BEAM C 38.2, REPAIR PERFORMED BY REPLACEMENT OF PART IAW SRM 51-72-10.
Back to JASC 5315