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 SWAA064730Floorbeam · corrodedDURING SCHEDULED 20Y CHECK, FOUND FLOORBEAM CORRODED AT BS 986, RBL 19 TO RBL 36. REPAIRED FLOORBEAM PER ER.SDR SWAA064729Floorbeam · corrodedDURING SCHEDULED 10Y CHECK, FOUND FLOORBEAM ZEE CHORD CORRODED AT BS 270, LBL 0 TO LBL 11. REMOVED AND REPLACED ZEE CHORD PER SRM.SDR SWIA200617624Floorbeam · crackedCRACKED CLIP AT FS484 RBL 9 FLOOR SUPPORT, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED REPAIR PER CRJ200 SRM 51-42-06 & 51-42-21.SDR SWIA200617623Floorbeam · crackedFS 280 FWD FLOOR SUPPORT ANGLE CRACKED AT RADIUS RBL 9 BELOW COCKPIT FLOOR, DISCOVERED DURING C-CHECK INSPECTION. FWD FLOOR SUPPORT ANGLE PER CRJ200 SRM 51-42-06 PG.4 P/N 600-34017-21.SDR SWAA064679Floorbeam · corrodedDURING SCHEDULED 8Y CHECK, FOUND FLOORBEAM CORRODED AT BS 986.5, LBL 5. REPAIRED FLOORBEAM PER SWA EA.SDR CALA0600503Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT BS 303, LBL 25-30. THE CORROSION WAS REMOVED AND A REPAIR WAS INSTALLED IAW SRM 53-00-51, REPAIR 1.SDR CALA0600502Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT BS 325, LBL 30-55. THE CORROSION WAS REMOVED AND THE FLOORBEAM WAS REPAIRED IAW SRM 53-00-51, REPAIR 1.SDR SWIA200617617Floorbeam · crackedRBL9 CRACKED AT LOWER FRAME STA280 FLOOR SUPPORT BEAM, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED FABRICATED PARTS AND NEW INBD CLIP P/N 601R-311011-57 IAW CRJ 200 REO 601R-53-11-171, REV C AT STN 280, RBL 9.0 LOWER.SDR QXEA200603255Floorbeam · corrodedC3 OKC - LEFT FS 280.00 FLOOR SUPPORT FRAME UPPER ANGLE HAS SEVERAL AREAS OF CORROSION AT LBL 0 TO 36.0 AND LBL 11.5. REPAIRED IAW REO670-53-11-047, AND SRM 51-42-06.SDR USAA061387Floorbeam · corrodedSTATION 344 BL 0 CORROSION. REPLACED FLOORBEAM TEE CAP IAW SRM 53-10-51, DEFECT SIZE: 1 INCH.SDR 06FDEA04148Floorbeam · corrodedLT FWD CABIN FLOORBEAM UPPER CAP CORRODED FOM STA 620 LBL 1- LBL 24. REMOVED CORROSION AND REPAIRED DAMAGED AREA REF SRM53-10-8 FIG 1 (N00533).SDR USAA061378Floorbeam · corrodedFLOORBEAM AT FRAME 16 Y50 HAS CORROSION. DEFECTIVE PART REPLACED WITH IDENTICAL PART. CORR TASK JA-220-53500, LEVEL 1, DEFECT SIZE: 1 X 1 INCH.SDR USAA061379Floorbeam · crackedY254 AT FRAME 20 CRACKED. DEFECTIVE PART REPLACED WITH IDENTICAL PART. REMOVED AND REPLACED FLOORBEAM PER SRM 51-72-11, DEFECT SIZE: .5 INCH LONG.SDR USAA061381Floorbeam · corrodedFLOORBEAM 500 + OF FR 16 HAS CORROSION. REMOVED & REPLACED FLOORBEAM PER SRM 51-72-11; CORR TASK JA-220-53500; LEVEL 1, DEFECT SIZE: 1 X 6 INCHES.SDR USAA061382Floorbeam · corrodedY254 AT FLOORBEAM 16 CORRODED. REMOVED AND REPLACED FLOORBEAM PER SRM 51-72-11; CORR TASK JA-220-53500, DEFECT SIZE: 2 INCH SQ.SDR K11A2008122672307Floorbeam · corrodedCORROSION ON FLOORBEAM UPPER CHORD LOWER SURFACE, AFT PIT.SDR K11A2008122672306Floorbeam · corrodedCORROSION ON FLOORBEAM UPPER CHORD LOWER SURFACE, AFT PIT.SDR K11A2008122672305Floorbeam · corrodedCORROSION ON FLOORBEAM UPPER CHORD LOWER SURFACE, AFT PIT.SDR SWAA064623Floorbeam · crackedDURING SCHEDULED 8Y CHECK, FOUND FLOORBEAM CORRODED AT BS 986.5, RBL 5. REPAIRED FLOORBEAM PER SRM.SDR SWAA064622Floorbeam · crackedDURING SCHEDULED 8Y CHECK, FOUND FLOORBEAM CRACKED AT BS 947, LBL 15. REPAIRED FLOORBEAM PER SWA EA.SDR DALA1134760682Floorbeam · corrodedFWD CABIN FLOORBEAM AND HAT AT BS 377.7, RBL 10 CORROSION REPAIRED IAW SRM 53-10-51 AND 51-30-2.SDR SWIA200617667Floorbeam · corrodedCABIN CENTER AFT FLOORBEAM CAP CORRODED, DISCOVERED DURING C-CHECK INSPECTION. REPLACED CABIN AFT CENTER FLOORBEAM CAP.SDR KNNA200600004Floorbeam · corrodedFOUND CORROSION AT FLOORBEAM STA 344 LBL 62.50 TO RBL 24.75.SDR 46504Floorbeam · corrodedFOUND CORROSION AT FLOORBEAM STA 344 LBL 62.50 TO RBL 24.75.SDR CALA0600501Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 986.5, BL 0 TO RBL 55. THE FLOORBEAM WAS REPAIRED IAW ECRA 5321-01422.SDR K11A2008122672308Floorbeam · corrodedCORROSION ON FLOORBEAM LOWER CHORD, AFT PIT.SDR USAA061352Floorbeam · corrodedSTATION 859 RBL 2 CORRODED. INSTALLED REPAIR DOUBLER IAW TR 53-10-06B, DEFECT SIZE: .800 INCH.SDR 2006UALA02246Floorbeam · crackedBS 246 FLOORBEAM STIFFENER CRACKED AT LBL 23. REPLACED STIFFENER. CRACKING RESULT OF PRESSURIZATION CYCLES & CABIN SERVICE EQUIPMENT LOADS.SDR SWAA064534Floorbeam · corrodedDURING SCHEDULED 8Y CHECK, FOUND FLOORBEAM CORRODED AT BS 967, LBL 41. REPAIRED FLOORBEAM PER SRM.SDR SWAA064533Floorbeam · corrodedDURING SCHEDULED 8Y CHECK, FOUND FLOORBEAM CORRODED AT BS 967, LBL 5 TO RBL 28. REPAIRED FLOORBEAM PER SWA EA.SDR CALA0600494Floorbeam · corrodedINSPECTION FOUND FLOORBEAM UPPER CHORD CORRODED AT NUT PLATE HOLES, STA 986.5, LBL 43. THE FLOORBEAM WAS REPAIRED IAW ECRA 5321-01419.SDR SWIA200617611Floorbeam · crackedFS 280 LBL9 LOWER ANGLE CRACKED ON FLOOR SUPPORT BEAM AND RBL9 I/B AND O/B 280 CLIPS ARE CRACKED, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED REPAIR ANGLES AND CLIPS AT STA 280 RBL9 LOWER PER CRJ200 REO 601R 53-171 REV 'C' REPAIR SCHEME 'B' .SDR AWXA200602021Floorbeam · corrodedMCN - CORROSION ON MAIN CABIN FLOORBEAM UPPER FLANGE LOWER SURFACE, B/S 1681.8, RBL 32 - RBL 40, WL 208.1. REPAIRED MAIN CABIN FLOORBEAM UPPER FLANGE LOWER SURFACE, B/S 1681.8, RBL 32 - RBL 40, WL 208.1 IAW B757-200 SRM 53-00-51 FIGURE 201.SDR HNAA0600158Floorbeam · corrodedCABIN UNDER FLOOR FRAME LEG BETWEEN 32-33 L/S AT FRAME BEHIND RECIRC FAN MOUNT IS CORRODED AT X291. CLEANED AREA OF FRAME LEG AND FOUND MINOR CORROSION AROUND I/B MOST RIVET. CLEANED ALODINED AND PRIMED AREA.SDR HNAA0600135Floorbeam · corrodedCABIN UNDER FLOOR CORROSION ON FRAME LEG BETWEEN STR 30 AND 31 AT X370 R/S. CLEANED AREA & FOUND MINOR CORROSION AROUND RIVET FASTENER REPAIRED IAW SRM 51-20-11, ALODINED & PRIMED IAW SRM 51-20-16 & 51-20-36.SDR 06FDEA04087Floorbeam · crackedSTRUCTURES-A300/A310 REPAIR IDENTIFICATION AND SUPPLEMENTAL MAINTENANCE COMPLY WITH EO 6-5100-7-5000 REV NR B POS PT1. CABIN FLOOR,TRANSVERSAL BEAM BETWEEN TRACKS Y-450 AND Y-953 AT FRAME 44 FOUND CRACKED REPLACED PER AMM 53-10-00.SDR 06FDEA04084Floorbeam · crackedSTRUCTURES-A300/A310 REPAIR IDENTIFICATION AND SUPPLEMENTAL MAINTENANCE COMPLY WITH EO 6-5100-7-5000 REV NR B POS PT1. CABIN, FLOOR TRANSVERSAL BEAM BETWEEN TRACKS Y-450 AND Y-953 AT FRAME 43 FOUND CRACKED REPLACED PER AMM 53-10-00.SDR SWIA200617601Floorbeam · crackedRT 621.0 FLOORBEAM OTBD SIDE CRACKED, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED ANGLES AT STA 621.0 RT FLOOR SUPPORT PER REO 601R-53-61-117 REV C.SDR SWIA200617600Floorbeam · crackedLT STA 621.0 FLOORBEAM OTBD SIDE CRACKED, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED ANGLE AND REPAIR ANGLE PER BOMBARDIER AEROSPACE REO601R-53-61-117 REV C DATED 2004-AUG-25.SDR CALA0600493Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AROUND FASTENER HOLES ON FORWARD FLANGE AT STA 986.5, RBL 12 TO LBL 12. THE CORROSION WAS REMOVED AND A REPAIR WAS INSTALLED IAW SRM 53-00-51.SDR CALA0600492Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AROUND FASTENER HOLES ON FORWARD FLANGE AT STA 986.5, LBL 23 TO LBL 43. THE CORROSION WAS REMOVED AND A REPAIR WAS INSTALLED IAW SRM 53-00-51.SDR CALA0600491Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AROUND FASTENER HOLES ON FORWARD FLANGE AT STA 986.5, RBL 32-43. THE CORROSION WAS REMOVED AND A REPAIR WAS INSTALLED IAW SRM 53-00-51.SDR CALA0600484Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 986, LBL 43. REPAIRED IAW ECRA 5321-01488.SDR AWXA200602050Floorbeam · corrodedMCN - CORROSION ON MAIN CABIN FLOORBEAM, BS 1640, LBL 11 - RBL 66, WL 208. REPAIRED MAIN CABIN FLOORBEAM, BS 1640, LBL 11 - RBL 66, WL 208 IAW AWA ER 19-5310-06335-ES2.SDR AWXA200602046Floorbeam · corrodedMCN - CORROSION ON MAIN CABIN FLOORBEAM, BS 1660, BL 0 - RBL 51, WL 208. REPAIRED MAIN CABIN FLOORBEAM, BS 1660, BL 0 - RBL 51, WL 208 IAW B757-200 SRM 53-00-51 FIGURE 201.SDR MALA060610Floorbeam · crackedFLOOR FRAME IS CRACKED AT STA 294 RBL 18.3. REPAIRED IAW MESABA EOS53108. SEE EAMS WORK ORDER 214742 TASK 1515.SDR MALA060609Floorbeam · corrodedFLOOR FRAME IS CORRODED OUT OF LIMITS AT STA 258 RBL 9. REPAIRED IAW MESABA EOS53102, SEE EAMS WORK ORDER 214742 TASK 1509.SDR MALA060608Floorbeam · corrodedFLOOR FRAME IS CORRODED OUT OF LIMITS AT STA 258 LBL 9. REPAIRED IAW MESABA EOS53108. SEE EAMS WORK ORDER 214742 TASK 1509.SDR DU4R2006703Floorbeam · corrodedCORROSION CABIN FLOORBEAM AT BS 365.25 12" LEFT OF B/L 0. CUT OUT CORRODED SECTION OF FLOOR BEAM. FABRICATED AND INSTALLED FLOORBEAM REPAIRS 12" BY 1" FROM 7075-T6 .063", 12" BY 1" FROM 7075-T6 .090", 12" BY 1" FROM 7075-T6 .125" AND EXTRUDED TEE 12" BY 3" BSDR AWXA200601966Floorbeam · corrodedSAL - MAJOR REPAIR - CORROSION ON MAIN CABIN FLOORBEAM, FS 68, -Y765. REPLACED MAIN CABIN FLOORBEAM, FS 66 - FS 70, -Y765 IAW A319 SRM 51-72-11.
Back to JASC 5315