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 08FDEA00633Floorbeam · corrodedMAIN DECK FLOORBEAM UPPER FLAG IS CORRODED/MISDRILLED BS 1110, LBL 27-34, WL 208. REMOVED CORROSION BS 1110, LBL 27 - LBL 31, MAT. THICK .125". REMOVED .116", REMAINING .009" OUT OF LIMITS REF 727-PF SRM 53-10-1 PG 25-41. AAR TOOL 18172, CAL DATE DUE 10/1SDR 2008UALA01085Floorbeam · corrodedMAIN CABIN FLOORBEAM STA 287, RBL 70.5 UPPER FLANGE IS CORRODED.SDR A6WA200840126Floorbeam · crackedBULKHEAD WEB FLOORBEAM CRACK AT FS 280 RBL 9.0. REPAIR PERFORMED IAW REO 601R53-11-171 REV D SCHEM B. (M)SDR USAA920080663Floorbeam · corrodedSAL - MAJOR REPAIR - C7 CHECK - CORROSION ON FLOORBEAM, BS 2786/FR 66 - BS 2884/FR 68, -Y1292. REPLACED FLOORBEAM, BS 2786/FR 66 - BS 2884/FR 68, -Y1292 IAW A319 SRM 51-72-11.SDR USAA920080662Floorbeam · corrodedSAL - MAJOR REPAIR - C7 CHECK - CORROSION ON FLOORBEAM, BS 2884/FR 68, -Y1292. REPLACED FLOORBEAM, BS 2884/FR 68, -Y1292 IAW A319 SRM 51-72-11.SDR USAA920080586Floorbeam · corrodedSAL - MAJOR REPAIR - C7 CHECK - CORROSION ON CABIN FLOORBEAM, BS 3158 /FR 66, +Y519.5. REPLACED CABIN FLOORBEAM, BS 3158 /FR 66, +Y519.5 IAW A320 SRM 51-72-11.SDR USAA920080575Floorbeam · corrodedSAL - MAJOR REPAIR - C7 CHECK - CORROSION ON CABIN FLOORBEAM, BS 2884 / FR 68, +Y1292. REPLACED CABIN FLOORBEAM, BS 2884 / FR 68, +Y1292 IAW A319 SRM 51-72-11.SDR USAA920080574Floorbeam · corrodedSAL - MAJOR REPAIR - C7 CHECK - CORROSION ON CABIN FLOORBEAM, BS 2835 / FR 67, +Y1292. REPLACED CABIN FLOORBEAM, BS 2835 / FR 67, +Y1292 IAW A319 SRM 51-72-11.SDR USAA920080570Floorbeam · corrodedSAL - MAJOR REPAIR - C7 CHECK - CORROSION ON CABIN FLOORBEAM, BS 3257 /FR 68, +Y765. REPLACED CABIN FLOORBEAM, BS 3257 /FR 68, +Y765 IAW A320 SRM 51-72-11.SDR USAA920080569Floorbeam · corrodedSAL - MAJOR REPAIR - C7 CHECK - CORROSION ON CABIN FLOORBEAM, BS 3158 /FR 66 - BS 3366 /FR 70, -Y765. REPLACED CABIN FLOORBEAM, BS 3158 /FR 66 - BS 3366 /FR 70, -Y765 IAW A320 SRM 51-72-11.SDR ABXA080100Floorbeam · corrodedFLOORBEAM CORRODED AROUND NUT PLATE AT FS 720, UNDER LEFT OUTER ROLLER TRAY. REPAIRED FLOORBEAM IAW SRM.SDR 08FDEA00591Floorbeam · corrodedCORROSION ON FLOORBEAM AT STA 1280, RBL6, RBL10, RBL14. CORROSION FOUND EXCEED LIMITS IN SRM 53-00-51 FIG 101. REPAIR CARRIED OUT IAW SRM 53-00-51, REPAIR 3, FIG. 201. REPAIR CLASSIFIED AS MAJOR PER GMM 6-2-100.SDR USAA920080588Floorbeam · corrodedSAL - MAJOR REPAIR - C7 CHECK - CORROSION ON CABIN FLOORBEAM, BS 3158 /FR 66 - BS 3257 /FR 68, -Y1292. REPLACED CABIN FLOORBEAM, BS 3158 /FR 66 - BS 3257 /FR 68, -Y1292 IAW A320 SRM 51-72-11.SDR USAA920080587Floorbeam · corrodedSAL - MAJOR REPAIR - C7 CHECK - CORROSION ON CABIN FLOORBEAM, BS 3257 /FR 68 - BS 3310 /FR 69, -Y1162. REPLACED CABIN FLOORBEAM, BS 3257 /FR 68 - BS 3310 /FR 69, -Y1162 IAW A320 SRM 51-72-11.SDR USAA920080585Floorbeam · corrodedSAL - MAJOR REPAIR - C7 CHECK - CORROSION ON CABIN FLOORBEAM, BS 3101 /FR 65 - BS 3207 /FR 67, +Y919. REPLACED CABIN FLOORBEAM, BS 3101 /FR 65 - BS 3207 /FR 67, +Y919 IAW A320 SRM 51-72-11.SDR USAA920080573Floorbeam · corrodedSAL - MAJOR REPAIR - C7 CHECK - CORROSION ON CABIN FLOORBEAM, BS 3043 /FR 64 - BS 3158 /FR 66, -Y1292. REPLACED CABIN FLOORBEAM, BS 3043 /FR 64 - BS 3158 /FR 66, -Y1292 IAW A320 SRM 51-72-11.SDR SWAA081029Floorbeam · corrodedDURING SCHEDULED 8Y CHECK, FOUND FLOORBEAM CORRODED AT BS 947, RBL 53. REPAIRED FLOORBEAM PER SWA EA.SDR SWAA081028Floorbeam · corrodedDURING SCHEDULED 8Y CHECK, FOUND FLOORBEAM CORRODED AT BS 986, RBL 35 TO RBL 45. REPAIRED FLOORBEAM PER SWA EA.SDR 08FDEA00588Floorbeam · corrodedMAIN DECK FLOORBEAM, UPPER FLANGE IS CORRODED, BS 1070, LBL 47-60, WL 208. REMOVED CORROSION ON MAIN DECK FLOORBEAM UPPER FLANGE, STA 1070, LBL 47"-60". FOUND TO BE OUT OF LIMITS, FABRICATED AND INSTALLED REPAIR, REF SRM 53-10-08 FIG 1. THIS IS CLASSIFIED ASDR CA080228002Floorbeam · corroded(CAN) CORROSION FOUND ON FLOORBEAM LOCATED AT Y = 272 AND Z = -490.0 JUNCTION WITH FRAMES 16, 17, 18 . ALSO (3) SILL PLATES CORRODED BEYOND LIMITS. CORROSION WAS ALSO FOUND ON FR 87, 88, 89 AND 90 UNDER THE AFT RT GALLEY ATTACHMENT POINT AT FLOOR STRUCTURE. RESDR NWAA081606310Floorbeam · corrodedDURING "M" CHECK, FOUND CORROSION ON UPPER DECK FLOORBEAM AT BS 1040 RBL 42. REPAIRED PER EA 63-212526.SDR USAA920080659Floorbeam · crackedMCN - MAJOR REPAIR - C20 CHECK - CRACKED FLOORBEAM CHORD, BS 662, BL 0. REPAIRED FLOORBEAM CHORD, BS 662, BL 0 IAW USAIRWAYS EA 100292.SDR USAA920080657Floorbeam · crackedMCN - MAJOR REPAIR - CRACKED FLOORBEAM CHORD, BS 663 AND BS 670, LBL 24, WL 208. REPAIRED FLOORBEAM CHORD, BS 663 AND BS 670, LBL 24, WL 208 IAW USAIRWAYS EA 100302.SDR CA080222010Floorbeam · corroded(CAN) CORROSION FOUND ON FLOORBEAM LOCATED AT Y = 272.0 AND Z = -490.0 JUNCTION WITH FRAMES 16, 17, 18 AND ON FLOORBEAM LOCATED AT Y = -272.0 AND Z = -490.0 AND ON FRAME NR 14 AT Y = -337.0 AND Z = -490.0 ALSO (3) SILL PLATES CORRODED BEYOND LIMITS. CORROSION SDR ABXA080095Floorbeam · corrodedCORROSION ON FLOORBEAM AT FS 368, RIGHT BUTT LINE 25. REPAIRED 9G NET STRAP FITTING IAW REA B653-57096-MR.SDR CALA0800165Floorbeam · corrodedFOUND CORROSION ON CABIN LATERAL FLOORBEAM UPPER CAP AT BS 344 AND LBL 6.0 AS VIEWED FROM E&E CEILING. INSTALLED REPAIR PER SRM 53-10-51.SDR CALA0800164Floorbeam · corrodedFOUND CORROSION ON FLOORBEAM AT BS 328 AND LBL 30.0 AS SEEN FROM E&E COMPARTMENT CEILING. INSTALLED REPAIR AND REPAIR PARTS PER SRM 53-10-51.SDR SWIA200819591Floorbeam · corrodedCOCKPIT FLOOR SUPPORT AT FS280 IS CRACKED AND CORRODED AT RBL9, FOUND AT C-CHECK. REPAIRED COCKPIT FLOOR SUPPORT PER CRJ700/900 SRM 51-42-06.
SDR SWIA200819590Floorbeam · corrodedFS 280 BEAM IS CRACKED AND CORRODED AT RBL9, FOUND AT C-CHECK. COMPLIED WITH REQUIRED REPAIRS PER CRJ700/900 SRM 51-42-06.SDR USAA920080453Floorbeam · corrodedSAL - MAJOR REPAIR - C7 CHECK - CORROSION ON CABIN FLOORBEAM, BS 3207 / FR 67 - BS 3310 / FR 69, +Y1162.5. REPLACED CABIN FLOORBEAM, BS 3207 / FR 67 - BS 3310 / FR 69, +Y1162.5 IAW A320 SRM 51-72-11.SDR SWAA080964Floorbeam · corrodedDURING SCHEDULED 6Y CHECK, FOUND FLOORBEAM CORRODED AT BS 767, LBL 13 TO LBL 17. REPAIRED FLOORBEAM PER SWA EA.SDR SIMA200805301Floorbeam · corrodedDURING HEAVY CHECK, FLOORBEAM BETWEEN FRAME 24 AND FRAME 29, AT FRAME 25, WAS FOUND TO HAVE CORROSION. FLOORBEAM WAS REPAIRED IAW SRM 53-22-10. AIRCRAFT WAS RETURNED TO SERVICE.SDR SIMA200805102Floorbeam · corrodedDURING MBV INSPECTION, FOUND LT OMEGA BEAM CORRODED AT FR 20 AT CARBON CROSS MEMBER AREA. INSTALLED NEW REPAIR DOUBLERS FROM PREVIOUS REPAIR IAW SRM 53-00-12. A/C WAS RETURNED TO SERVICE.SDR KCSA081086Floorbeam · dentedUPPER DECK FLOORBEAM WEB DENTED AT BS 780, RBL 20.SDR KCSA081085Floorbeam · corrodedUPPER DECK FLOORBEAM LOWER CHORD CORRODED AT BS 780, RBL 20.SDR USAA920080454Floorbeam · corrodedSAL - MAJOR REPAIR - C7 CHECK - CORROSION ON CABIN FLOORBEAM, BS 3101 / FR 65, -Y464.8. REPLACED CABIN FLOORBEAM, BS 3043 / FR 64 - BS 3207 / FR 67, -Y464.8 IAW A320 SRM 51-72-11.SDR CALA0800158Floorbeam · corrodedBS 325 LBL 22-44 FLOOR SUPPORT FOUND CORRODED. FLOORBEAM REPAIRED PER SRM 53-00-51.SDR UIEA200800051Floorbeam · crackedAFT CARGO COMPARTMENT STA 1700 RBL 55 FLOORBEAM CHORD ANCHOR NUT AREA FOUND MINOR CORROSION. LEVEL 1, BLENDED OUT CORROSION IAW SRM 51-10-01 0.049" 1" WIDE 2" LONG. REPROTECTED PER 51-10-02. APPLIED CORROSION INHIBITOR COMPOUND.SDR SWAA080915Floorbeam · corrodedDURING SCHEDULED 16Y CHECK, FOUND FLOORBEAM CHORD CORRODED AT BS 360, RBL 45 TO RBL 60. REPAIRED FLOORBEAM CHORD PER SRM.SDR CALA0800149Floorbeam · corrodedCABIN STA 303 LBL 15 TO 32 FLOOR SUPORT UPPER CHORD FOUND CORRODED. FLOORBEAM REPAIRED PER SRM 53-0051.SDR CALA0800148Floorbeam · crackedBODY STA 246 FLOORBEAM LBL 40 MID CHORD CRACKED. FLOORBEAM MID CHORD REPAIRED PER ECRA 5310-04718.SDR SWIA200819588Floorbeam · crackedLOWER FLOOR FRAME AT FS 280 AND LBL9.0 IS CRACKED, FOUND AT C-CHECK. INSTALLED REPAIR PARTS FOR LOWER FLOOR FRAME AT FS 280 AND LBL 9.0 PER CRJ200 REO 601R-53-11-171.SDR SWIA200819587Floorbeam · crackedUPPER FLOOR ANGLE AT FS280 AND RBL9.0 IS CRACKED, FOUND AT C-CHECK. INSTALLED REPAIR PARTS ON UPPER FLOOR ANGLE PER CRJ200 REO 601R-53-11-137.
SDR SWIA200819585Floorbeam · failedRIVET SHEARED ON FLOOR SUPPORT BEAM BRACKET AT FS 461 AND LBL9, FOUND AT C-CHECK. COMPLIED WITH NECESSARY REPAIRS PER CRJ200 SRM 51-42-06 PG 11.
SDR USAA920080459Floorbeam · corrodedSAL - MAJOR REPAIR - C7 CHECK - CORROSION ON CABIN FLOORBEAM, BS 3257 / FR 68, -Y1162.5. REPLACED CABIN FLOORBEAM, BS 3207 / FR 67 - BS 3310 / FR 69 , -Y1162.5 IAW A320 SRM 51-72-11.SDR USAA920080438Floorbeam · corrodedSAL - MAJOR REPAIR - C7 CHECK - CORROSION ON CABIN FLOORBEAM, BS 3158 / FR 66 - BS 3207 / FR 67 , +Y1292. REPLACED CABIN FLOORBEAM, BS 3158 / FR 66 - BS 3207 / FR 67 , +Y1292 IAW A320 SRM 51-72-11.SDR USAA920080461Floorbeam · corrodedSAL - MAJOR REPAIR - C7 CHECK - CORROSION ON CABIN FLOORBEAM, BS 3043 / FR 64 - BS 3207 / FR 67, +Y512. REPLACED CABIN FLOORBEAM, BS 3043 / FR 64 - BS 3207 / FR 67, +Y512 IAW A320 SRM 51-72-11.SDR 08FDEA00417Floorbeam · corrodedMAIN CABIN, FLOORBEAM UPPER SURFACE HAS CORROSION AT STA 846, LBL 48. REMOVED SEAT TRACK AND REMOVED SUPPORT TEE IAW SRM 51-30-2. FABRICATED, LOCATED AND DRILLED NEW TEE BEAM IAW SRM 53-10-2 FIG7 AND 51-30-5.TREATED AND PRIMED AFFECTED AREA IAW SRM 51-10-2. ISDR AMTA200800082Floorbeam · corrodedFLOORBEAM CORRODED AROUND NUTPLATE HOLES AT SAT 986. 5 FROM BL0 THRU BL45R. REMOVED CORROSION AND FOUND OUT OF LIMITS IAW SRM 53-70-51 FIG 03. ACCOMPLISHED REPAIR WITH NR 2015516001 EA 737-5370-A0003. (K)SDR USAA920080488Floorbeam · corrodedMIA - MAJOR REPAIR - C4 CHECK - LEVEL 2 CORROSION ON CABIN FLOORBEAM, BS 347, RBL 34 - RBL 88. REPAIRED CABIN FLOORBEAM, BS 347, RBL 34 - RBL 88 IAW B767 SRM 53-00-51.
Back to JASC 5315