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 SWIA200719162Floorbeam · crackedLBL 9 AT FS 280 SHOWS SIGNS OF CRACKING, FOUND AT C-CHECK. COMPLIED WITH REPAIR OF CRACKED ANGLE AT FS 280 AND LBL 9 FLOORBEAM IAW CRJ200 REO 601R-53-11-138 REV NC.SDR ASAA0772184Floorbeam · corrodedAFT CABIN BS 986.5 FLOORBEAM UPPER CAP CORRODED AT RBL 17. REPLACED UPPER CAP IAW ERD 7360.SDR ASAA0772183Floorbeam · corrodedAFT CABIN BS 986.5 FLOORBEAM UPPER CAP CORRODED AT RBL 22. REPLACED UPPER CAP IAW ERD 7360.SDR ASAA0772182Floorbeam · corrodedAFT CABIN BS 986.5 FLOORBEAM UPPER CAP CORRODED AT RBL 28. REPLACED UPPER CAP IAW ERD 7360.SDR ASAA0772181Floorbeam · corrodedAFT CABIN BS 986.5 FLOORBEAM UPPER CAP CORRODED AT RBL 32. REPLACED UPPER CAP IAW ERD 7360.SDR ASAA0772180Floorbeam · corrodedAFT CABIN BS 986.5 FLOORBEAM UPPER CAP CORRODED AT RBL 4. REPLACED UPPER CAP IAW ERD 7360.SDR ASAA0772179Floorbeam · corrodedAFT CABIN BS 986.5 FLOORBEAM UPPER CAP CORRODED AT RBL 10. REPLACE UPPER CAP IAW ERD 7360.SDR ASAA0772178Floorbeam · corrodedAFT CABIN BS 986.5 FLOORBEAM UPPER CAP CORRODED AT LBL 18. REPLACED UPPER CAP IAW CASCADE ERD 7360.SDR ASAA0772177Floorbeam · corrodedAFT CABIN BS 986.5 FLOORBEAM UPPER CAP CORRODED AT LBL 24. REPLACED UPPER CAP IAW ERD 7360 & EA5310 02739.SDR DU4R2007181Floorbeam · gougedFOUND FWD CABIN FLOORBEAM GOUGED AT BS 600 LBL 27, 44. REPAIRED BY CUTTING OUT GOUGED AREA BS 600 LBL 7 TO LBL 71. FABRICATED AND INSTALLED T CHORD REPAIR 69 BY 2-1/8 BY 0.125 FROM BAC1505-100617 AND REPAIR ANGLE 11 BY 2 BY 0.063" FROM BAC1490-2734 AND ANGLESDR USAA920070974Floorbeam · corrodedSAL - MAJOR REPAIR - BC4 CHECK - CORROSION ON CABIN FLOORBEAM, BS 3101 / FR 65 - BS 3207 / FR 67, +Y1292. REPLACED CABIN FLOORBEAM, BS 3101 / FR 65 - BS 3207 / FR 67, +Y1292 IAW A320 SRM 51-72-11.SDR TRAX200701533Floorbeam · crackedFLOOR SUPPORT ANGLE CRACKED AT FS 280, O/B OF LBL 9.00. 10-30-07 COMPLIED WITH ASA CARD NR REO 601R-53-11-138.
SDR ASAA0742123Floorbeam · corrodedMAIN CABIN STA 312 LBL 12 RBL 20 FLOORBEAM HAS CORROSION ON TEE CAP. REMOVED CORROSION FOUND TO BE OUT OF LIMITS IAW B73753 10 51 FIG 101 (SHEET 11 OF 16). REMOVED AND REPLACED UPPER CHORD IAW B737 SRM 53-10-51 FIG 2D (SHEET 1 4).SDR 07FDEA04650Floorbeam · corrodedSEVERAL LOCATIONS OF CORROSION ON FLOORBEAM FROM FS 760 TO 840, RBL 45.5. REMOVED FLOORBEAM STA 760 - 840, RBL 45.5. FABRICATED AND INSTALLED REPLACEMENT FLOORBEAM IAW DWG 65-16279 AND SRM 51-30-02 P1. THIS IS CLASSIFIED AS A MAJOR REPAIR.SDR 2007UALA04310Floorbeam · corrodedMAIN CABIN FLOORBEAM TEE CAP CORRODED RBL 24 TO RBL 56, BS 365. REPLACED TEE CAP LBL 8 TO RB L 56, STA 365.
SDR SWAA075147Floorbeam · corrodedDURING SCHEDULED BRDG CHECK, FOUND FLOORBEAM CORRODED AT BS 732 LBL 3. REPAIRED FLOORBEAM PER SWA EA.SDR F3LA200700312Floorbeam · corrodedDURING C4/S1 CHECK, INSPECTION REPORTED FLOORBEAM BETWEEN FRAME 68R AND 69R CORRODED. BLENDED CORRODED AREA AND FOUND FLOORBEAM TO BE OUT OF LIMITS IAW SRM 53-00-14, FIG 102. REMOVED AND INSTALLED FLOORBEAM IAW SRM'S 51-42-11, 51-44-00, AND 51-72-11.SDR F3LA200700307Floorbeam · corrodedDURING C4/S1 CHECK, INSPECTION REPORTED CABIN FLOORBEAM AT FR 69 RT CORRODED IN NUTPLATE HOLE. REMOVED AND REPLACED FLOORBEAM IAW SRM 53-00-14, FIG. 102, 51-42-11 AND 51-72-11.SDR F3LA200700289Floorbeam · corrodedDURING C4/S1 CHECK, INSPECTION REPORTED FLOORBEAM AT FR67R CORRODED IN NUTPLATE HOLES. REMOVED AND REPLACED FLOORBEAM IAW SRM 51-42-11, PARA 5, AND 71-72-11.SDR SWIA200719166Floorbeam · crackedFS 280 COCKPIT FLOORBEAM IS CRACKED AT RBL9 AND LBL9, FOUND AT C-CHECK. REPLACED COCKPIT FLOORBEAM PER CRJ700 SRM 51-42-06.
SDR SWIA200719165Floorbeam · crackedFS 280 CROSS BEAM IS CRACKED AT RBL9 AND LBL9, FOUND AT C-CHECK. COMPLIED WITH REPAIR OF BEAM PER REO 670-53-11-047.SDR SWIA200719149Floorbeam · crackedAFT FLOOR SUPPORT CRACKED AT FS 621 AND LBL 41, FOUND AT C-CHECK. INSTALLED REPAIR PARTS PER REO 601R-53-61-117 REV A.SDR MASA200700704Floorbeam · unknownREPAIR TO FLOORBEAM AT FS 280 AND RBL 12 LOWER FLANGE.SDR USAA920071045Strap · crackedCLT - MAJOR REPAIR - C16 CHECK, CRACKED FLOORBEAM STABILIZER STRAP, BS 328, BL 0. REPAIRED FLOORBEAM STABILIZER STRAP, BS 328, BL 0 IAW B737 SRM 53-10-51.SDR DU4R2007178Floorbeam · corrodedFOUND CORRODED FLOORBEAM AT BS 1640 BETWEEN LBL 24 - RBL 28 IN MAIN CABIN AFT SECTION. REPAIRED BY CUTTING OUT 18 CORRODED SECTION OF T CAP. FABRICATED DRILLED AND INSTALLED T CAP REPAIR 32-5/8 FROM BAC1505-100617, 2 SPLICES 9 BY 2 BY 1 AND 6 BY 2 BY 1 FROM SDR SWAA075111Floorbeam · corrodedDURING SCHEDULED 8Y CHECK, FOUND FLOORBEAM UPPER TEE CAP CORRODED AT BS 986, LBL 34 TO LBL 44. REMOVED AND REPLACED TEE CAP PER SWA EA.SDR 07FDEA04608Floorbeam · crackedMAIN CARGO COMPARTMENT FLOORBEAM CRACKED FRAME 27 BETWEEN YD AND YE(RBC 37 AND RBL18). FABRICATED AND INSTALLED CROSSBEAM COUPLING IAW SRM 53-10-15.SDR USAA920071168Floorbeam · corrodedSAL - MAJOR REPAIR - BC4 CHECK - CORROSION ON CABIN FLOORBEAM, BS 3158 / FR 66, -Y1292. REPAIRED CABIN FLOORBEAM, BS 3158 / FR 66, -Y1292 IAW A320 SRM 51-72-11.SDR F3LA200700311Floorbeam · corrodedDURING C4/S1 CHECK, INSPECTION REPORTED CORROSION ON UPPER SURFACE OF FLOORBEAM Y254, BETWEEN FRAMES 16 AND 18. BLENDED 3 AREAS ON FLOOR SUPPORT Y254, ALL FOUND TO BE OUT OF LIMITS PER SRM 53-11-14-FIG 104. CUT OUT CORRODED UPPER CAP SECTION OF FLOOR SUPPORTSDR USAA920071051Floorbeam · crackedCLT - MAJOR REPAIR - C20 CHECK, CRACKED FLOORBEAM INNER CHORD, BS 639. REPAIRED FLOORBEAM INNER CHORD, BS 639 IAW EA 98917.SDR USAA920070979Floorbeam · corrodedSAL - MAJOR REPAIR - BC4 CHECK - CORROSION ON CABIN FLOORBEAM, BS 3257 / FR 68 - BS 3366 / FR 70, -Y1162. REPLACED CABIN FLOORBEAM, BS 3257 / FR 68 - BS 3366 / FR 70, -Y1162 IAW A320 SRM 51-72-11.SDR KCSA071473Floorbeam · damagedFLOORBEAM AT STA 780 IS DAMAGED ON AFT SIDE AT LBL 50 TO LBL 53 ON THE UPPER SIDE OF CHORD.SDR USAA920070946Floorbeam · crackedMCN - MAJOR REPAIR - C-12 CHECK - NR 5976770, CRACKED FLOORBEAM, BS 700, RBL 24.75, WL 208. REPAIRED FLOORBEAM, BS 700, RBL 24.75, WL 208 IAW B737-300 SRM 53-00-51-2R1, FIGURE 201.SDR USAA920070945Floorbeam · crackedMCN - MAJOR REPAIR - C-12 CHECK - NR 5976877, CRACKED FLOORBEAM VERTICAL SUPPORT ANGLE, BS 700, RBL 24.75, WL 208. REPLACED FLOORBEAM VERTICAL SUPPORT ANGLE, BS 700, RBL 24.75, WL 208 IAW B737-300 SRM 51-40-02.SDR SWIA200719153Floorbeam · crackedSTA 280 AT LBL9 LOWER FLOORBEAM IS CRACKED, FOUND AT C-CHECK. COMPLIED WITH FLOORBEAM REPAIR PER CRJ200 REO 601R 53-11-171. SCHEME B DATED 13-02-2007.
SDR SWIA200719152Floorbeam · crackedUPPER FLOORBEAM IS CRACKED AT STA 280 AND RBL9, FOUND AT C-CHECK. COMPLIED WITH REPAIR OF UPPER FLOORBEAM PER CRJ200 REO 601R 53-11-136 DATED 10-02-99.
SDR 07FDEA04580Floorbeam · crackedMAIN CARGO COMPARTMENT FLOORBEAM CRACKED FRAME 30 BETWEEN YD TO YE. FABRICATED AND INSTALLED CROSSBEAM COUPLING IAW SRM 53-10-15 .SDR USAA920070939Floorbeam · crackedMCN - MAJOR REPAIR - C-18 CHECK - NR 6505201, CRACKED FLOORBEAM TEE CAP, BS 663.75, BL 0, WL 208. REPAIRED FLOORBEAM TEE CAP, BS 663.75, BL 0, WL 208 IAW USAIRWAYS EA 120277.SDR C2XA07SH083Floorbeam · corrodedSHV - DURING C-CHECK LEFT OMEGA BEAM HAS CORROSION ON FR 20. MX REPAIRED LEFT OMEGA BEAM AT FR 20 IAW EMB 145 SRM 53-00-13. THE AIRCRAFT WAS APPROVED TO RETURN FOR SERVICE.SDR CPCP200700115Floorbeam · corrodedFLOORBEAM 39 CORRODED ON UPPER AND LOWER SURFACE. CORROSION OF FLOORBEAM 39 REPAIRED IAW SRM 53-00-00 FIGURE 450 AT 2 LOCATIONS.SDR HYIA12136Floorbeam · corrodedFOUND FLOORBEAM AT FRAME 39 IS CORRODED. CORROSION REMOVED AND FOUND TO BE BEYOND MANUFACTURERS LIMITS. REMOVED AND REPLACED FLOORBEAM IN ACCORDANCE WITH 51-25-01.SDR HYIA12135Floorbeam · corrodedFOUND FLOORBEAM AT FRAME 36 IS CORRODED. CORROSION REMOVED AND FOUND TO BE BEYOND MANUFACTURERS LIMITS. REMOVED AND REPLACED FLOORBEAM IN ACCORDANCE WITH 51-25-01.SDR HYIA12134Floorbeam · corrodedFOUND FLOORBEAM AT FRAME 13 IS CORRODED. CORROSION REMOVED AND FOUND TO BE BEYOND MANUFACTURERS LIMITS. REPAIRED FLOORBEAM WITH SPLICE IN ACCORDANCE WITH SRM 53-00-00 FIGURE 435.SDR GTIA200700031Floorbeam · corrodedFLOORBEAM CORROSION, 6" AFT OF FRAME 67 AT Y765. REPAIRED DAMAGED AREA.SDR GTIA200700030Floorbeam · corrodedFLOORBEAM CORROSION AT Y-1732 15" AFT OF FRAME 67. REPLACED SECTION OF FLOORBEAM.SDR UPS07850925Floorbeam · corrodedINSPECTION TYPE:C2 CORROSION AND DEEP TOOLING MARKS/GOUGES ON GUSSET AT BOTTOM OF STA 55 FLOORBEAM RBL 48. REMOVED, FABRICATED, AND INSTALLED REPAIR GUSSET AT STA 55 RBL 48 FLOORBEAM IAW DWG 5641543, AND SRM 51-3-2, AND SRM 51-1-20D.SDR USAA920070918Floor Support · corrodedMCN - MAJOR REPAIR - C-12 CHECK - NR 6501492, CORROSION ON CABIN FLOOR SUPPORT, BS 365.25 - BS 377.70, LBL 60, WL 208. REPLACED CABIN FLOOR SUPPORT, BS 365.25 - BS 377.70, LBL 60, WL 208 IAW B757-200 SRM 51-40-02.SDR SWAA075040Floorbeam · corrodedDURING SCHEDULED BRDG CHECK, FOUND FLOORBEAM CORRODED AT BS 986, RBL 14. REPAIRED FLOORBEAM PER SRM.SDR 12113Floorbeam · corrodedFOUND FLOORBEAM 40 IS CORRODED. REMOVED CORROSION AND FOUND TO BE BEYOND MANUFACTURERS LIMITS. REMOVED AND REPLACED FLOORBEAM IN ACCORDANCE WITH SRM 51-25-01.SDR 12112Floorbeam · corrodedFOUND FLOORBEAM 38 IS CORRODED. CORROSION REMOVED AND FOUND TO BE BEYOND MANUFACTURERS ALLOWABLE LIMITS. REMOVED AND REPLACED FLOORBEAM 38 IN ACCORDANCE WITH SRM 51-25-01.
Back to JASC 5315