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 TRAX200700611Floorbeam · corrodedCORROSION ON FLOORBEAM BETWEEN FS 559.00 + TO 621.00 AND LBL 2. [SUP 05-17-07] REMOVED CORROSION AND FOUND OUT OF LIMITS IAW REO 601R-53-00-005. FLOORBEAM FABRICATED AS PER SRM 51-24-36. FABRICATE FLOORBEAM INSTALLED AS PER SRM 51-42-20.SDR TRAX200700609Floorbeam · corrodedCORROSION ON FLOORBEAM BETWEEN FS 559.00 +112 TO 621 AND LBL 9. [SUP 05-15-07] CORROSION ON FLOOR BEAM BTWN FS 559.00 +112 TO 621 AND LBL 9 REMOVED AS PER SRM 51-21-06. ALODINED AND PRIMED AS PER SRM 51-21-11. PAINTED AS PER SRM 51-21-11.SDR 2007UALA01383Floorbeam · corrodedRIGHT MAIN CABIN FLOOR STRUCTURE, EVIDENCE OF CORROSION BETWEEN FLOOR WEB AND SUPPORT ANGLE, BS 1681, RBL 34. MAJOR REPAIR ACCOMPLISHED: REMOVED ENTIRE LENGTH OF DAMAGED FLOORBEAM T-CAP. FABRICATED & INSTALLED REPLACEMENT CHORD.SDR SWAA072193Floorbeam · crackedDURING SCHEDULED 10Y CHECK, FOUND FLOOR BEAM CRACKED AT BS 328, RBL 50. REPAIRED FLOOR BEAM PER SRM.SDR SWIA200718273Floorbeam · corrodedCOCKPIT FLOORBEAM AT FS 280 CORRODED, DISCOVERED AT C-CHECK. INSTALLED NEW COCKPIT FLOOR SUPPORT ANGLE P/N:CC670-33292-13 IAW CRJ700 SRM TASK 51-42-06-001-001-A01.SDR SWIA200718270Floorbeam · crackedFS 280 FLOORBEAM CRACKED AT RIGHT AND LEFT BUTTLINE 9, DISCOVERED AT C-CHECK. INSTALLED CROSS BEAM SPLICE AT FS 280 PER REO 670-53-11-047. INSTALLED INTERCOSTALS PER CRJ700 SRM 51-42-21.SDR SIMA200712813Floorbeam · corrodedFLOOR SUPPORT CORRODED AT FRAME 25 AROUND FASTENERS. REMOVED AND REPLACED FLOOR SUPPORT IAW EMB SRM 51-40-02. AIRCRAFT RETURNED TO SERVICE.SDR SIMA200712805Floorbeam · corrodedLEFT OMEGA BEAM CORRODED AT FRAME 20 CROSSMEMBER, REPLACED PREVIOUS DOUBLERS IAW EMB SRM 53-00-10. RETURNED AIRCRAFT TO SERVICE.SDR SIMA200712816Floorbeam · corrodedRIGHT OMEGAS BEAM INBOARD SIDE FOUND CORRODED BETWEEN FRAME 31 AND FRAME 33. REMOVED AND REPLACED OMEGA BEAM IAW EMB SRM 51-40-02. RETURNED AIRCRAFT TO SERVICE.SDR SIMA200712815Floorbeam · corrodedRIGHT OMEGA BEAM INBOARD SIDE CORRODED BETWEEN FRAME 24 AND FRAME 25. REMOVED AND REPLACED OMEGA BEAM IAW EMB SRM 51-40-02. RETURNED AIRCRAFT TO SERVICE.SDR SIMA200712804Floorbeam · corrodedLEFT OMEGA FOUND CORRODED AT FRAME 24 AND FRAME 25. REPAIRED OMEGA BEAM IAW EMB SRM 53-00-10, FIGURE 202. AIRCRAFT RETURNED TO SERVICE.SDR 07FDEA01680Floorbeam · bentAFT CARGO PIT, CABIN FLOORBEAM LOWER FLANGE BENT, FR60, STA X3991, BL - Y1750 TO 2050. REPAIRED LOWER FLANGE ON FLOORBEAM FR60, STA X3991, BL - Y1750-2050 IAW FED EX EA 6-5310-109141.SDR SWAA072166Floorbeam · crackedDURING SCHEDULED 8Y CHECK, FOUND FLOOR BEAM UPPER CHORD CRACKED AT BS 294.5, RBL 52. REPAIRED CHORD PER ER.SDR USAA070348Floorbeam · corrodedSTA 967 RBL 17 HAS CORROSION. FAB'D BEAM CAP & SUPPORT ANGLES, STRAPS PER SRM 53-00-51 FIG 201; CORR TASK C53-107-01; LEVEL 2, DEFECT SIZE: 42.5 INCHES.SDR A6WA200740233Floorbeam · crackedRT FS 621.00 FLOOR SUPPORT ANGLE IS CRACKED .5 INCH LONG IN OB RADIUS. (K) [07-17-07] MAINTENANCE REPAIRED IAW BOMBARDIER AEROSPACE REO 601R-53-61-117. (M)SDR A6WA200740232Floorbeam · crackedLT FS 621.00 FLOOR SUPPORT ANGLE IS CRACKED .5 INCH LONG ON OB RADIUS. (K) [07-17-07] MAINTENANCE CUT AWAY DAMAGED ANGLE AND INSTALLED REPAIR ANGLE IAW BOMBARDIER REO 601R53-61-117 REV C. (M)SDR SWAA072118Floorbeam · crackedDURING SCHEDULED 10Y CHECK, FOUND FLOOR BEAM WEB CRACKED AT BS 727B, LBL 26. R&R WEB PER SRM.SDR 2007UALA01353Floorbeam · crackedMAIN CABIN FLOORBEAM INTERCOSTAL UPPER ANGLE CRACKED AT STA 337, LBL 41. MAJOR REPAIR ACCOMPLISHED: REMOVED CRACKED ANGLE. FABRICATED & INSTALLED NEW ANGLE.SDR 2007UALA01351Floorbeam · crackedSTA 246 FLOORBEAM UPPER WEB CRACKED OUT OF LWR FASTENER AT LBL 21. MAJOR REPAIR ACCOMPLISHED: FABRICATED & INSTALLED DOUBLER REPAIR.SDR 2007UALA01350Floorbeam · crackedSTA 246 FLOORBEAM LBL 11 AFT SIDE MID CHORD CRACKED AT LWR RADIUS NEAR FASTENER. MAJOR REPAIR ACCOMPLISHED: CUT OUT CHORD DAMAGE FROM LBL 59 TO RBL 49. FABRICATED & INSTALLED REPAIR ANGLE, STRAPS & MID CHORD.SDR PIDA07027Floorbeam · corrodedDURING MAINTENANCE, NOTED CORROSION ON THE UPPER CORD OF THE BS 344 FLOORBEAM FROM LBL 50 TO RBL 16. INSTALLED REPLACEMENT SECTION OF -T- CAP PER SRM 53-10-09.SDR PIDA07029Floorbeam · corrodedDURING MAINTENANCE, NOTED CORROSION ON UPPER CORD OF BS 294 FLOORBEAM FROM BL 0 TO LBL 12. REPLACED SECTION OF FLOORBEAM -T- CAP FROM LBL 12 TO THE RIGHT SERVICE DOOR PER SRM 53-10-9 FIGURE 5.SDR KCSA071164Floorbeam · corrodedFLOORBEAM UPPER CHORD IS CORRODED AT STA 1640 RBL49 WL-200.SDR CPCP20070033Floorbeam · corrodedFOUND FRAME 38 FLOORBEAM CORRODED. FRAME 38 FLOORBEAM REPAIRED AS PER SRM 53-00-00 FIG 450.SDR CPCP20070032Floorbeam · corrodedFOUND FRAME 36 FLOORBEAM CORRODED. FRAME 36 FLOOR SPLICED AS PER SRM 55-00-00.SDR CPCP20070034Floorbeam · corrodedFOUND FRAME 39 FLOORBEAM CORRODED. FRAME 39 FLOORBEAM REPAIRED AS PER SRM 53-00-00 FIG 450.SDR DL76P070500Floorbeam · corrodedFWD GALLEY FLOOR SUPPORT TOP SURFACE CORRODED STA 287 RBL18. REPAIRED PER SRM 53-00-51D REF NR 67268820001 STA 287 FLOORBEAM.SDR SIMA200712827Floorbeam · corrodedLEFT OMEGA BEAM INBOARD SIDE CORRODED AT FRAME 20 CROSSBEAM. REMOVED DAMAGE AND INSTALLED DOUBLER IAW EMB SRM 53-00-01, FIGURE 201. AIRCRAFT RETURNED TO SERVICE.SDR CALA0700237Floorbeam · crackedINSPECTION FOUND TWO SMALL CRACKS ON THE OUTBOARD FLANGE OF THE LBL 45 LONGITUDINAL FLOORBEAM JUST FORWARD OF STA 727B. REPAIRED IAW ECRA 5311-01316.SDR F3LA200700107Floorbeam · damagedDURING C-3 CHECK, INSPECTION REPORTED FWD SPLICE OF R2 DOOR SILL HAD TWO DOUBLE DRILLED HOLES, ONE COMPLETELY THROUGH THE FWD FLOORBEAM. REPLACED DAMAGED FLOORBEAM IAW SRM 51-42-11.SDR 2007UALA01298Floorbeam · corrodedAFT CABIN FLOOR STRUCTURE, UPPER "T" CAP CORRODED ON UPPER SURFACE AT BS 1016 LBL5 TO 39 WL 208. MAJOR REPAIR ACCOMPLISHED: REMOVED CORROSION. FABRICATED & INSTALLED FILLER, STRAP & NESTED ANGLE REPAIR.SDR 2007UALA01297Floorbeam · corrodedAFT CABIN FLOOR STRUCTURE, FLOORBEAM UPPER "T" CAP UPPER SURFACE HAS 2 SPOTS OF CORROSION. BS 1016 RBL 5 TO 14.5 AT WL 208. MAJOR REPAIR ACCOMPLISHED: REMOVED CORROSION. FABRICATED & INSTALLED FILLER, STRAP & NESTED ANGLE REPAIR ON FWD SIDE OF FLOORBEAM CASDR SWAA072051Crease Beam · corrodedDURING SCHEDULED 22Y CHECK, FOUND CREASE BEAM WEB CORRODED AT BS 807 TO BS 827, RBL 70. REMOVED AND REPLACED CREASE BEAM WEB PER SRM.SDR USAA070325Floorbeam · corrodedFOUND CORROSION FLOORBEAM -Y254 BETWEEN FR 19 AND 20. REMOVED CORROSION AND INSTALLED FILLER AND DOUBLER PER SRM 53-00-14, FIG 204, CORROSION TASK JA-220-53500, DEFECT SIZE: 1" BY 1".SDR USAA070326Floorbeam · corrodedFOUND CORROSION AROUND SCREW HOLE, FRAME 66, Y-1292. CUT OUT DAMAGE, INSTALLED FILLER AND REPAIR ANGLES PER SRM 53-41-14, PRINCIPLE 6; CORROSION TASK JA-260-535, DEFECT SIZE: 1".SDR A6WA200740212Floorbeam · crackedLT FS 621.00 FLOOR SUPPORT ANGLE CRACKED. MAINTENANCE REPAIRED CRACK IAW REO 601R-53-61-117, REV C. (K)SDR DL76P070585Floorbeam · corrodedDURING HMV2 AT MAE, FOUND FWD CARGO COMPARTMENT BILGE AREA STA 740 LBL 29-46 FLOOR PANEL SUPPORT ANGLE CORRODED. REPAIRED PER SRM 53-00-07 REPAIR 4.SDR 07FDEA01555Floorbeam · corrodedTOP CAP BEAM C33 CORRODED SPLICE REPAIR OF TOP CAP BEAM PERFORMED IAW SRM 53-10-15 FIG 207.SDR AWXA200700521Floorbeam · corrodedSAL - FOUND CORROSION ON CABIN FLOORBEAM, FR 66 TO FR 67, - Y1162 TO -Y1292. REPLACED CABIN FLOORBEAM, FR 66 - FR 67, -Y1162 TO -Y1292 IAW A320 SRM 51-72-11.SDR AWXA200700520Floorbeam · corrodedSAL - CORROSION ON CABIN FLOORBEAM, FR 68 - 6" TO FR 69, - Y1162. REPLACED CABIN FLOORBEAM , FR 68 - FR 69, -Y1162 IAW A320 SRM 51-72-11.SDR AWXA200700519Floorbeam · corrodedSAL - CORROSION ON CABIN FLOORBEAM, FR 66 + 6" TO FR 67 + 17", + Y1162 TO +Y1292. REPLACED CABIN FLOORBEAM, FR 66 - FR 68, +Y1162 TO +Y1292 IAW A320 SRM 51-72-11.SDR AWXA200700518Floorbeam · corrodedSAL - FOUND CORROSION ON CABIN FLOORBEAM, FR 68.6" TO FR 69 + 3", + Y1162. REPLACED CABIN FLOORBEAM, FR 68 - FR 69 + 3", +Y1162 IAW A320 SRM 51-72-11.SDR 07FDEA01549Floorbeam · corrodedFLOOR STRUCTURE CORROSION AROUND CLIP NUT ATTACHMENT STA 735 RBL 58-72. REMOVED AND REPLACED SUPPORT AEAO397-503 IN REFERENCE TO MD/DC SRM 51-35-01 VOL II PG 1. REPAIR CLASSIFIED AS MAJOR.SDR SWAA072007Floorbeam · corrodedDURING SCHEDULED 22Y CHECK, FOUND FLOORBEAM CORRODED AT BS 947, LBL 3 TO LB 5. REPAIRED FLOORBEAM PER SRM.SDR SWAA072006Floorbeam · corrodedDURING SCHEDULED 8Y CHECK, FOUND FLOORBEAM CORRODED AT BS 986.5, RBL 5. REPAIRED FLOORBEAM PER SWA EA.SDR SWAA072005Floorbeam · corrodedDURING SCHEDULED 8Y CHECK, FOUND FLOORBEAM CORRODED AT BS 328, RBL 19 TO RBL 47. REMOVED AND REPLACED FLOORBEAM PER SWA EA.SDR USAA070307Floorbeam · corrodedAROUND SCREW HOLE, FRAME 66, Y-1292 HAS CORROSION. CUT OUT DAMAGE, INSTALLED FILLER & REPAIR ANGLES PER SRM 53-41-14,; CORR TASK JA-260-53500; LEVEL 1, DEFECT SIZE: 1 INCH.SDR DL76S070485Floorbeam · corrodedFWD CARGO COMPT FLOORBEAM CHORD FOUND AT STATION 654+110 LBL 20 AND REPAIRED ON NR 52120 SRM 53-00-07 FIGURE 201, REPAIR 4.SDR ASAA0771617Floorbeam · corrodedFLOOR SUPPORT AT STA 950 IS CORRODED ON UPPER FLANGE REPAIRED IAW SRM 51 40 02.SDR ASAA0771604Floorbeam · corrodedFLOORBEAM AT STA 986.5 IS CORRODED AT FASTENER HOLES REPAIRED IAW EA 5310 02717.
Back to JASC 5315