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 2007UALA00930Floorbeam · corrodedMAIN CABIN FLOORBEAM CORRODED STA 1681, BL 0 (AFT SHEAR WEB DECK PLATE). *S/D* MAJOR REPAIR ACCOMPLISHED: REMOVED DAMAGED AREA. INSTALLED DOUBLER-TRIPLER FILLER REPAIR.SDR KCSA071093Floorbeam · corrodedSTA 360 FLOORBEAM UPPER CHORD HAS AREA OF CORROSION AT LBL 34, WL 312.SDR KCSA071091Floorbeam · bentAFT PIT FLOORBEAM UPPER CAP BENT AT BS 1580, RBL 54.SDR KCSA071090Floorbeam · dentedAFT PIT FLOORBEAM UPPER CAP DENTED AT BS 1720, RBL 46.SDR ABXA070120Floorbeam · corrodedFLOOR SUPPORT CORRODED AT FS 1402, LEFT BUTT LINE 21. REMOVED, REPAIRED AND REINSTALLED FLOOR SUPPORT IAW B767 51-70-12 AND 51-40-O2.SDR SIMA200709203Floorbeam · corrodedRIGHT FLOORBEAM SUPPORT FOUND CORRODED IN GALLEY AREA. REMOVED AND REPLACED SUPPORT IAW EMB SRM 51-40-02. OPERATIONAL CHECK GOOD.SDR SWAA071592Floorbeam · corrodedDURING SCHEDULED 20Y CHECK, FOUND FLOORBEAM CORRODED AT BS 1016 UPPER SURFACE. REPAIRED FLOORBEAM PER SRM.SDR 07FDEA01143Floorbeam · corrodedMAIN DECK AT FS 480 FLOORBEAM CORRODED BETWEEN LBL 26 AND LBL 45. REMOVED CORROSION REF SRM 53-10-01. ORIGINAL MATERIAL MEASURED AT .125 BLEND OUT MATERIAL LOSS AT DEEPEST LOCATION MEASURES .016. REMAINING MATERIAL AFTER BLEND IS .109 AND IS STRUCTURALLY SDR SIMA200708608Floorbeam · corrodedLEFT OMEGA BEAM CORRODED AT FRAME 20. REPAIRED OMEGA BEAM IAW EMB SRM 53-00-10. RETURNED AIRCRAFT TO SERVICE.SDR KCSA071083Stiffener · crackedAFT PIT, BS 1800, RBL 4, FLOORBEAM VERTICAL SUPPORT CRACKED 2 INCHES BELOW UPPER CAP.SDR KCSA071082Stiffener · crackedAFT PIT, BS 1800, RBL 10 FLOORBEAM VERTICAL SUPPORT CRACKED 2 INCHES BELOW UPPER CAP.SDR DHL2007806504Angle · corrodedFWD ACCY COMPT SUB-FLOORBEAM ANGLE CORRODED STA 50.000 LBL 30". REMOVED CORROSION IAW SRM 51-1-8 PG 17-18. FOUND OUT OF LIMITS IAW SRM 53-2-0 PG 2P. REMOVED CORRODED SUPPORT ANGLE IAW SRM 51-1-21. FABRICATED NEW SUPPORT ANGLE (AL2024T3 0.050") IAW SRM 53-2SDR 2007UALA00890Floorbeam · corrodedMAIN DECK FLOORBEAM AREA, WEB IS CORRODED AT BS 960, RBL 67. MAJOR REPAIR ACCOMPLISHED: FABRICATED & INSTALLED FLOORBEAM WEB.SDR 07FDEA01127Floorbeam · corrodedCABIN FLOORBEAM UPPER SURFACE HAS CORROSION, FS 620, LBL 24.75, TO RBL 24.75. REMOVED CORROSION IAW SRM 51-10-6. FABRICATED REPAIR PARTS ON MAE TRAV NR T7/669488,T7/669489, AND T7/668025 AND INSTALLED REPAIR PARTS IAW SRM 51-30-2. MAJOR REPAIR.SDR CPCP20070021Floorbeam · corrodedFLOORBEAM FRAME 39 FOUND CORRODED NEAR SERVICE DOOR THRESHOLD. FLOOR BEAM REPLACEMENT C/OUT ON NRWC 174954.SDR 07FDEA01122Floorbeam · corrodedCABIN FLOORBEAM HAS CORROSION ON UPPER SURFACE FS 720D, LBL 24.75 TO LBL 65. REMOVED CORROSION, REMOVED DAMAGE PORTION SR 27-53-034. FABED NEW PARTS PER SR 27-53-034. INSTALLED NEW ANGLES AND NEW FILLER REPAIR IAW SRM 51-30-2.SDR CPCP20070002Floorbeam · corrodedCORROSION FOUND ON FLOORBEAM ON FRAME 40.SDR SIMA200708607Floorbeam · corrodedLEFT OMEGA BEAM FOUND CORRODED AT FRAME 25. CUT OUT CORROSION, FABRICATED AND INSTALLED REPAIR PARTS IAW EMB IC2007-145/01986, DATED 03-21-07. AIRCRAFT RETURNED TO SERVICESDR USAA070231Floorbeam · corrodedRIGHT FLOORBEAM TOP FLANGE FROM FR 64-69, -Y1160-Y1292 HAS CORROSION. REMOVED AND REPLACED FLOORBEAM PER SRM 51-72-11; CORR TASK JA-260-53500, LEVEL 1, DEFECT SIZE: 1.5 SQ INCH.SDR USAA070232Floorbeam · corrodedRIGHT FLOORBEAM TOP FLANGE FROM FR 64-FR 69, -Y1160 TO -Y1192 HAS CORROSION. REMOVED AND REPLACED FLOORBEAM PER SRM 51-72-11; CORR TASK JA-260-53500; LEVEL 1, DEFECT SIZE: 1.5 SQ INCH.SDR SWIA200718179Floorbeam · crackedFLOORBEAM IS CRACKED AT LBL11 DISCOVERED AT C-CHECK. INSTALLED REPAIR ANGLE AND FILLER AT LBL9 PER CRJ200 REO 601R 53-11-171 REV 'D' AND CLIPS AND FILLER AT LBL9 PER REO 601R 53-11-171 REV 'D'.SDR SWIA200718175Floorbeam · crackedFLOORBEAM IS CRACKED AT LBL11, DISCOVERED AT C-CHECK. INSTALLED FILLER ANGLE AND SPLICE ANGLES IAW CRJ200 REO 601R-53-11-138.SDR SWIA200718174Floorbeam · crackedFLOORBEAM IS CRACKED AT RBL11 AND BOTH INBOARD AND OUTBOARD CLIPS ARE CRACKED, DISCOVERED AT C-CHECK. INSTALLED REPAIR ANGLE, CLIP, FILLER, ANGLE FILLER, SHIM P/N 601R-53-11-1169-1 AND CLIP P/N 601R31113-58 IAW CRJ200 REO 601R-53-11-171, REV D AND REO 601R-53SDR SWAA071540Floorbeam · crackedDURING SCHEDULED 18Y CHECK, FOUND FLOORBEAM CRACKED AT BS 986.5, RBL 5. REPAIRED FLOORBEAM PER ER.SDR CALA0700138Floorbeam · crackedINSPECTION FOUND A .25 INCH CRACK IN FLOORBEAM AT STA 727B, LBL 44. THE FLOORBEAM WAS REPAIRED IAW ECRA 5311-01303.SDR 07FDEA01092Floorbeam · corrodedAFT PIT TOP OF FLOORBEAM CORRODED AT STA 1841 RBL 17 TO 23. REMOVED AND REPLACED FLOORBEAM AGA3874-3, AND AFT ATTACHED ANGLE AGA3874-9 IAW DAC DWG AGA3874 REV B, AND MD/DC10 SRM 51-33-01 PG 1 VOL 11. MD/DC10 RSM 51-35-01 PG 1 VOL 11.SDR 07FDEA01080Floorbeam · crackedFORWARD CARGO COMPARTMENT, FLOORBEAM (C25) FORWARD FACE OF BEAM LOCATED BETWEEN R2 AND R3 SEAT TRACK HAS A .400 INCH CRACK IN VERTICAL STIFFENER. REPAIRED FLOORBEAM IAW A310/200 SRM SUPPLEMENT 53-10-15. REMOVED AND REINSTALLED FLOORBOARD IAW A310/200 AMM SUPSDR 07FDEA01078Floorbeam · crackedFWD CARGO COMPARTMENT, OVER HEAD FLOORBEAM [ C34 ] FWD FACE OF BEAM , LOCATED BETWEEN L4 AND L5 SEAT TRACK HAS A 0.425 INCH CRACK IN VERTICAL STIFFENER. REMOVED AND REINSTALLED FLOOR BOARD 231KF AND 231QF TO FOM REPAIR IAW A310-200 AMM 53-10-25-4. REPAIRED FSDR FDKA200703145Floorbeam · crackedFLOORBEAM TEE AT FRAME 65 LT SIDE IS CRACKED. THE DAMAGED CROSS FRAME HAS BEEN REMOVED AND REPLACED.SDR UPS07849576Floorbeam · corrodedINSPECTION TYPE:C3 FLOORBEAM STA 1790 LBL 8 HAS DEEP GOUGE AND EXFOLIATED CORROSION. REMOVED FLOORBEAM AT STA 1790 LBL 8 IAW SRM 51-3-0. FABRICATED AND INSTALLED FLOORBEAM AT STA 1790 LBL 8 IAW SRM 53-7-3, AND SRM 51-3-0.SDR DU4R2007077Floorbeam · corrodedFOUND CORROSION ON FLOORBEAM UPPER CAP AT FS 1640 LBL 24. FABRICATED AND INSTALLED 63.0 LONG T CAP FROM 7075-T6 .090, 2 SUPPORT ANGLES 11.0 FROM 7075-T6 .063, 2 6.0 RADIUS FILLERS FROM 7075-T6 .125, 2 REINFORCEMENT STRAPS 8.0 FROM 7075-T6 .090 6 IAW DELTA BSDR 07FDEA01075Floorbeam · corrodedMDCC FLOORBEAM AT FR 14 LT 64 INCHES FROM CENTER HAS 1 SPOT OF CORROSION ON FORWARD BOTTOM FACE 15" LONG BY 1" WIDE. REMOVED CORROSION IAW SRM 51-74-10 CHECKED LIMITS IAW SRM 53-12-15, OUT OF LIMITS. FABBED REPAIR IAW A310/200 SRTM 53-12-15 PB210 FIG 201. RSDR 07FDEA01073Floorbeam · misrepairedREWORK OF FR 14 REPAIR DOUBLER TO FLOOR CROSSBEAM REQUIRED DUE TO INSUFFICIENT ED ON FASTENER HOLES COMMON TO STAND OFF BRACKETS. REMOVED REPAIR DOUBLER (ANGLE) AND FILLER SHIM IAW A310-200 SRM 51-40-21. FABRICATED NEW REPAIR DOUBLER (ANGLE) AND FILLER SSDR 07FDEA01071Floorbeam · misrepairedPREVIOUS REPAIR LOCATED ON MAIN CABIN FLOORBEAM FRAME 36 BETWEEN SEAT TRACKS 2 AND 3 RT FWD AND AFT UPPER FLANGE HAS 2 EACH REPAIR ANGLES THE FWD ANGLE IS 10.25" BY 1 " AND THE AFT ANGLE IS 12.2" BY 1.82" PREVIOUSLY INSTALLED REPAIR LOCATED AT MAIN CABIN FLOORSDR 07FDEA01070Floorbeam · misrepairedPREVIOUS REPAIR LOCATED ON MAIN CABIN FLOORBEAM FRAME 34 BETWEEN SEAT TRACKS 2 AND 3 RT FWD AND AFT UPPER FLANGE HAS 2 EACH REPAIR ANGLES THE FWD ANGLE IS 10.25" BY 1" AND THE AFT ANGLE IS 12.2" BY 1.82" PREVIOUSLY INSTALLED REPAIR LOCATED AT MAIN CABIN FLOORBSDR 07FDEA01069Floorbeam · misrepairedPREVIOUS REPAIR LOCATED ON MAIN CABIN FLOORBEAM FRAME 35 BETWEEN SEAT TRACKS 2 AND 3 RT FWD AND AFT UPPER FLANGE HAS 2 EACH REPAIR ANGLES THE FWD ANGLE IS 10.3" BY 1" AND THE AFT ANGLE IS 12.4" BY 1.82". REPAIR FOUND NOT TO BE IAW EA6-5321-29300. REMOVED EXISDR 07FDEA01068Stiffener · crackedMDCC - FLOORBEAM C37, FWD FACE, VERTICAL STIFFENER AT TOP HAS .5 INCH CRACK LOCATED BETWEEN NR 4L AND 5L SEAT TRACK ROUTED OUT CRACKED VERTICAL STIFFENER IAW A310/200 SRM 53-10-15 NDT VERIFIED CRACK. REMOVAL FABRICATED REPAIR ANGLES IAW A310/200 SRM, 53-10-SDR 07FDEA01024Floorbeam · corrodedFOUND CABIN FLOORBEAM UPPER SURFACE HAS CORROSION, FS 580, RBL 24.75, TO RBL 45.5. REWORKED IAW FEDEX EA 7-5310-102028.SDR USAA070229Floorbeam · corrodedY1732 FR 66 - FR 65, CORROSION AROUND SCREW HOLE CORRODED. CUT OUT DAMAGE & INSTALLED REPAIR ANGLES & FILLER PER SRM 53-41-14; CORR TASK JA-260-53500; LEVEL 1, DEFECT SIZE: 1 INCH DIA.SDR USAA070230Floorbeam · corrodedY-1732 BETWEEN FR 65 & 66 CORRODED. CUT OUT DAMAGE, INSTALLED REPAIR ANGLES & FILLER PER SRM 53-41-14; CORR TASK JA-260-53500; LEVEL 1, DEFECT SIZE: 1 INCH DIA.SDR USAA070221Floorbeam · corrodedSTA 986 HAS CORROSION. REMOVED DAMAGE & INSTALLED REPAIR PARTS PER EA 98538; CORR TASK C53-107-02; LEVEL 2, DEFECT SIZE: .5 INCH DIA.SDR UPS07M49810Floorbeam · corrodedINSPECTION TYPE:C CENTER CARGO, STA 1841 BETWEEN RBL 4 & 22, FLOORBEAM WEB FWD FACE ATTACHED MID CHORD, CORROSION FOUND AT SEVERAL SPOTS. CORROSION ON FLOORBEAM WEB FACE MID CHORD REMOVED SRM 51-21-01VOL II R38. ORI THK 0.080" MATL REMOVED 0.060" (RBL 4"-10"SDR TRAX200700390Floorbeam · corrodedCORROSION FOUND ON FWD SUPPORT FLOOR ANGLE OF THE 280. REMOVED FWD 280 FLOOR SUPOPRT AGNLE DUE TO CORROSION ALL WORK DONE IAW CRJ 200 SRM 51-42-06. REMOVED AND REPLACED FWD FLOOR SUPPORT ANGLE ON 280 IAW REO 601R-53-11-926. TASK COMPLETED ON TASK CARD N/R-0SDR DLM90070242Floorbeam · corrodedFOUND CABIN FLOORBEAM FS 1364 CORRODED. REPAIR PER SRM 51-70-01 FIG 1.SDR TRAX200700381Floorbeam · corrodedSTA 280 AFT FLOOR SUPPORT ANGLE HAS SURFACE CORROSION AT BL 0. ALL WORK DONE IAW REO 601R-53-11-926SDR KCSA071068Floorbeam · dentedAFT BILGE FLOORBEAM STANCHION AT BOTTOM NEAR CARGO DOOR IS DENTED AT STA 1920, RBL 64.SDR 2007UALA00811Floorbeam · corrodedMAIN CABIN FLOORBEAM T-CAP CORROSION, STA 1640 RBL 56-59. MAJOR REPAIR ACCOMPLISHED: REMOVED DAMAGED SECTION. INSTALLED NEW T-CAP SECTION.SDR TRAX200700378Floorbeam · crackedSTA 461 FLOORBEAM FITTING CRACKED RBL 9 OUTBOARD SIDE. INSTALLED NEW FITTING COMPLETE WITH LOCK FASTENERS IAW CRJ 200 SRM 51-42-21 .SDR TRAX200700377Floorbeam · crackedFLOORBEAM FITTING CRACKED AT UPPER AFT CORNER STA 461 RBL 9 INBOARD FITTING. (SUPPLEMENTAL 28 MARCH 07) INSTALLED NEW REPLACEMENT FITTING IAW SRM 51-42-21.SDR ASAA0771540Floorbeam · corrodedFLOORBEAM UPPER TEE IS CORRODED AT BS 986 REPAIRED IAW EA 5310 02703.
Back to JASC 5315