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 20000615SH021Floorbeam · corrodedDURING C-CHECK, FOUND CORROSION ON FLOORBEAM, PN 9958212-25 AT BS 756, APPROXIMATELY LBL 14.5. CAUSE UNKNOWN. (X)SDR 20000615SH016Floorbeam · gougedDURING C-CHECK, FOUND GOUGE IN FLOORBEAM WEB BS 100, RBL 10. CAUSE UNKNOWN. (X)SDR 00FDEA00222Floorbeam · corrodedCORROSION ON LWR CHORD FLOORBEAM BS 1130, RBL 16-34 AROUND FASTENER HOLES. ** S/D ** R&R CORROSION FND TO BE OUT OF LIMITS PER ER 005113.SDR 00FDEA00230Floorbeam · corrodedCORROSION ON FLOORBEAM UPPER FLANGE BS 680, BL 0 TO LBL 45, WL 208. *S/D* REMOVED AND REPLACED PER FEDEX SRM 53-10-8 FIG 3.SDR 00FDEA00227Floorbeam · corrodedCORROSION (C53-224-04) AROUND FASTENER HOLE BS 950F, LBL 11, WL 208. *S/D* REMOVED AND REPLACED PER FEDEX SRM 53-10-8 FIG 8 & FEDEX SRM 53-10-2 FIG 7 SHEET 2, 24.SDR 00FDEA00228Floorbeam · corrodedCORROSION ON FLOORBEAM UPPER FLANGE BS 620, LBL 45 TO RBL 25, WL 208.SDR USAA000538Floorbeam · crackedCLT - FOUND FLOORBEAM WEB CRACKED 4 PLACES .25 INCH, BS 328, RBL 44, WL 202.5 RIVET HOLES. REMOVED DAMAGED PER EA 66993. (M)SDR RRXA002328Floorbeam · misdrilledDURING A MAINTENANCE VISIT FOUND SEVERAL DRILLED HOLES IN FLOORBEAM AT FS 740, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AREA IAW DC-8 SRM 51-1-8. RECEIVED REPAIR AND INSTALLED IAW DC-8 SRM 51-1-21 AND EO NR 00-047 WITH APPROVED 8110-SDR RRXA002266Floorbeam · misdrilledDURING A MAINTENANCE VISIT FOUND SEVERAL DRILLED HOLES IN THE FLOORBEAM AT FS 760, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED DOUBLER IAW DC-8 SRM 51-1-21, 51-1-4, 51-1-20D SDR GAIA00196Floorbeam · misdrilledDURING LIGHT C-CHECK AT TIMCO/OSC, FOUND FLOORBEAM UPPER CHORD HAS NUMEROUS HOLES DRILLED AT BS 460, LBL 45. REPAIRED IAW SRM 53-10-8. THE AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR L1GA200000027Floorbeam · corrodedTHE FLOORBEAM STAND OFF TAB AT FS 680 ON LT FLOORBOARD NR 24 BROKEN ATTRIBUTED TO LEVEL 2 CORROSION.SDR L1GA200000006Floorbeam · corrodedCORROSION FOUND ON FLOOR WEB BETWEEN PANELS 17 & 18.SDR L1GA200000005Floorbeam · crackedHEAVY CORROSION AND CRACKS ON FLOORBEAM FS 996 X54L.SDR AALA20000717Longeron · crackedTUL - LONGERON 176 CRACKED AT STA 256 AND STA 275. BEAM ATTACH AT BOTH LEGS OF LONGERON. SPLICED IN LONGERON. REPAIRED PER SRM 53-02 FIG 18. (X)SDR SWAA000682Floorbeam · corrodedDURING SCHEDULED -D- CHECK, FOUND FLOORBEAM CORRODED ON UPPER SURFACE, BS 967, LBL 72 TO RBL 18. REPAIRED BEAM PER SRM.SDR RRXA002344Floorbeam · misdrilledDURING A MAINTENANCE VISIT FOUND SEVERAL MISDRILLED HOLES IN THE FLOORBEAM AT FS 840, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. PLUGGED MISDRILLED HOLES PER EO NR 00-047 WITH APPROVED 8110-3 DATED SDR RRXA002235Floorbeam · misdrilledDURING A MAINTENANCE VISIT FOUND NUMEROUS DRILLED HOLES TO THE FLOORBEAM 1280 CUSP TO CUSP, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED DOUBLER IAW DC-8 SRM 51-1-4, 51-1-21 ASDR RRXA002226Floorbeam · misdrilledDURING A MAINTENANCE VISIT FOUND NUMEROUS DRILLED HOLES TO THE FLOORBEAM 1200 CUSP TO CUSP, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED DOUBLERS IAW DC-8 SRM 51-1-21, 51-1-4,SDR F3LA00038Floorbeam · corrodedDEN - DURING C-7 CHECK INSPECTION REPORTED CORROSION ON TOP OF FLOORBEAM BS 947, BL 12L TO BL 12R. MAINTENANCE REPLACED PREVIOUS REPAIR T-CHORD AT BS 947 PER SRM 51-30-2 AND SRM 53-10-0. REMOVED FLOORBEAM UPPER T-CHORD AT BS 947, RBL 60, TO LBL 60 PER SRM 51SDR ABXA000263Floorbeam · corrodedDURING ''''D'''' CHECK, FOUND FLOORBEAM CORRODED AT STA 313 AND LBL 40. REPAIRED FLOORBEAM IAW DC9 SRM 53-05.SDR 0001766304Floorbeam · corrodedDURING ''M'' CHECK, FOUND CORROSION ON UNDER SIDE OF FLOOR FRAME AT BS 980, RBL 40 TO 75. REPAIRED PER EA 63-175729.SDR CALA0000445Floorbeam · corrodedINSPECTION FOUND MID CARGO BAY FLOORBOARD SUPPORT CORRODED ON LOWER SIDE AT FS 636, LBL 15 TO RBL 15. THE FLOOR SUPPORT WAS REMOVEDAND REPLACED IAW SRM 51-30-2.SDR CALA0000443Floorbeam · corrodedINSPECTION FOUND TOP T-CHORD OF FLOORBEAM CORRODED THE ENTIRE LENGTH AT STA 1322 LT, RT AND CENTER AISLE. THE FLOORBEAM WAS REMOVED AND REPLACED IAW SRM 53-05, FIGURE 20A.SDR RRXA002463Floorbeam · misdrilledDURING A MAINTENANCE VISIT FOUND NUMEROUS DRILLED HOLES TO THE FLOORBEAM AT STA 480 CUSP TO CUSP, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED PART IAW DC-8 SRM 51-1-4, 51-1-2SDR RRXA002343Floorbeam · misdrilledDURING A MAINTENANCE VISIT FOUND SEVERAL MISDRILLED HOLES IN THE FLOORBEAM AT FS 830, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED DOUBLER IAW DC-8 SRM 51-1-4, 51-1-21 AND EO SDR USAA000530Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED .5 INCH, STATION 1016, LBL 15 FLOORBEAM. INSTALLED REPAIR PER SRM 53-00-51 FIG 203. (M)SDR TWAA0005803Floorbeam · crackedDURING C CHECK, MAINT FOUND CRACK IN FLOORBEAM CAP AT STA 237, RBL 4, CARGO CEILING AREA. FABRICATED NEW FLOORBEAM CAP PER SPM 6-70-01 AND SRM 51-10-03. ---CLOSED---SDR 0001572275Floorbeam · corrodedDURING H CHECK, FOUND CORROSION ON UPPER AND LOWER FLANGE OF FLOORBEAM. REPAIRED PER EA22-175140.SDR CALA0000414Floorbeam · corrodedINSPECTION FOUND LT AFT FLOORBEAM CORRODED AT STA 1338. THE FLOORBEAM WAS REPAIRED IAW SRM 53-05, FIGURE 20A.SDR AALA20000617Floorbeam · corrodedTUL - FOUND UPPER CHORD ANGLE OF WALKWAY FLOORBEAM CORRODED. REMOVED CORROSION, INSTALLED 301.5 HARD DOUBLER .040 PER AARD 51-40-00-1 28 FPG NR 1 LOCKS THROUGH WEB 10 F26 HI-LOCKS THROUGH UPPER LEG. (M)SDR AWXA0000239Floorbeam · crackedC-CHECK, REPAIR DOUBLER ON AFT FACE OF FLOORBEAM AT BS 520 LBL 45.5 CRACKED IN RADIUS .5 INCH. REMOVED DAMAGED DOUBLER AND REPAIRED IAW AWA EO 53-14-12.SDR AWXA0000238Floorbeam · corrodedC-CHECK, FLOOR SUPPORT AT FS 950 LBL 50 - LBL 20 CORRODED AT FASTENER HOLES. REMOVED AND REPLACED DAMAGED PARTS IAW 737 SRM 51-40-02, FABRICATED SUPPORT FROM BAC 1506-43 7050 T76511, SHIM 7075T6 .080 IAW 737 SRM 51-40-02, TREATED AND PRIMED IAW 737 SRM 53-60-SDR AWXA0000237Floorbeam · corrodedC-CHECK, TOP SURFACE OF FLOOR SUPPORT BEAM FROM FS 1016 LBL 5 TO FS 986 LBL 20 HAS EXFOLIATED CORROSION. REMOVED AND REPLACED FLOOR SUPPORT IAW 737 SRM 51-40-02, FABRICATED REPAIR PARTS IAW 737 SRM 51-20-02 FROM 2024T3 .063 7075T6 .125, TREATED AND PRIMED IAWSDR AWXA0000236Floorbeam · corrodedC-CHECK, STA 1016 FLOORBEAM UPPER T FLANGE CORRODED AT LBL 5. CUT OUT DAMAGED AREA IAW 737 SRM 53-00-5, FABRICATED REPAIR SECTION FROM (BAC 1505-100617 7075T73), TREATED AND PRIMED IAW 737 SRM 51-20-01, INSTALLED IAW 737 SRM 51-40-02, PARTS ALODINED AND PRIMESDR AWXA0000235Floorbeam · corrodedC-CHECK, FS 967 RBL 44 UPPER T-CAP CORRODED. CUT OUT DAMAGED AREA 737 SRM 53-30-51, FABRICATED REPAIR PARTS IAW 737 SRM 53-30-51, INSTALLED PARTS IAW 737 SRM 53-30-51 FIG 202, MAT''L USED ANGLE, BAC 1490-2887 7075T6 FILLER .125 7075 T6.SDR AWXA0000234Floorbeam · corrodedC-CHECK, FLOORBEAM AT BS 967 RBL 6 CORRODED. CUT OUT DAMAGED AREA, FABRICATED REPLACEMENT PARTS IAW 737 SRM 53-00-51, TREATED AND PRIMED IAW 737 SRM 51-20-02, INSTALLED REPAIR PARTS IAW 737 SRM 51-40-02, MAT USED: SUPPORT ANGLE BAC 1505-100617, STRAPS .063 QSDR AWXA0000233Floorbeam · corrodedC-CHECK, FLOORBEAM FS 1006 CORRODED AT FASTENER HOLE RBL 12. REMOVED DAMAGED AREA IAW 737 SRM 53-00-51 FIG 202, FABRICATED REPAIR STRAP FROM .125 7075 T6, ALODINED AND PRIMED STRAP, INSTALLED STRAP IAW 737 SRM 53-00-51 FIG 202.SDR AWXA0000230Floorbeam · corrodedC-CHECK, FLOORBEAM AT 986.5 TOP T-ANGLE CORRODED FROM RBL 20 TO LBL 20 (PREVIOUS REPAIR). REMOVED DAMAGED SECTION IAW 737 SRM 53-00-51, FABRICATED PART AND INSTALLED IAW 737 SRM 53-00-51 AND 51-40-02, ALODINED AND PRIMED PARTS IAW 737 SRM 51-10-02, MAT USED: SDR AALA20000619Floorbeam · corrodedTUL - FOUND CORROSION ON BOTTOM FLANGE OF FLOORBEAM. CUTOUT DAMAGED AND INSTALLED FILLER AND DOUBLER DE301.5 HARD STAINLESS .071 PER ESO 11697 DATED 3-29-2000 AND AARD 53-10-07-1. (M)SDR AALA20000620Floorbeam · corrodedTUL - CORROSION ON STA 1130 FLOORBEAM FLANGE, BL ZERO, THROUGH LBL 25. REMOVED CORROSION BY BLEND AND CUT OUT. INSTALLED DOUBLER PER ESO 11697 DATED 3-29-2000. (X)SDR USAA000525Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED .5 INCH BY .5 INCH, STATION 947.5 LBL 4. REPAIRED FILLER, DOUBLER AND SPLICE ANGLES PER SRM 53-10-09 DET 1. CORROSION LEVEL 2. (M)SDR 0001592275Floorbeam · corrodedDURING H CHECK FOUND CORROSION ON FLOORBEAM. REPAIRED PER EA 22-175137.SDR COMA0060319Floorbeam · corrodedFLOORBEAMS LBL 9, RBL 9, RBL 27 BETWEEN FS 323 TO FS 349 CORRODED. SPLICED IN NEW BEAMS CAPS IAW CRJ REO 601R-53-00-027 AND WVAC EO 601R-53-1133.SDR CALA0000397Floorbeam · corrodedINSPECTION FOUND FLOOR SUPPORT CORRODED AT L-2 DOOR, FS 1140, LBL 53. THE FLOOR SUPPORT WAS REMOVED AND REPLACED IAW SRM 51-30-5.SDR CALA0000394Floorbeam · gougedINSPECTION FOUND A HOLE GOUGED IN CABIN FLOORBEAM AT STA 396. A REPAIR WAS INSTALLED IAW SRM 53-05 SHEETS 1, 2 & 3.SDR AWXA0000222Floorbeam · corrodedC-CHECK, CORROSION OUT OF LIMITS STA 967 RBL 17-36 (FLOORBEAM T-CAP). REMOVED DAMAGED T-CAP, FABRICATED PARTS FROM (BAC 1505-100617 7075T6X.071 ANGLE, 7075T6X.071 STRAP, AND 7075 T6 X .063 STRAP) TREATED, PRIMED, AND INSTALLED IAW 737 SRM 53-10-9.SDR AALA20000615Floorbeam · corrodedTUL - FOUND FLOORBEAM STATION 380 UPPER CHORD ANGLE AFT SIDE CORRODED AT FLOORBOARD FASTENER HOLE RBL 32 INCHES. CUT OUT DAMAGED AREA AND INSTALLED DOUBLER/FILLER REPAIR PER SRM 53-10-8 PAGES 45-48. (M)SDR 0001552275Floorbeam · corrodedDURING H CHECK FOUND CORROSION ON FLOORBEAM UPPER FLANGE FORWARD LIP, BS 1148. REPAIRED PER EA22-175136.SDR TWAA0005805Floorbeam · corrodedDURING C CHECK, MAINT CABIN FLOOR MEMBRANE LOWER SURFACE, AT STA 200 AFT SIDE OF FLOORBEAM, AT BL 0 WAS CORRODED. REMOVED CORRODED FLOOR MEMBRANE AT STA 200 TO 218, LBL 25 TO RBL 26. INSTALLED NEW SECTION OF MEMBRANE 0.025. REF SRM 53-14-1 PAGE 27. -SDR TWAA0005804Floorbeam · corrodedDURING C CHECK, MAINT CABIN FLOOR MEMBRANE LOWER SURFACE AT AFT SIDE OF STA 200 FLOORBEAM, RBL 22, WAS CORRODED. REMOVED CORRODED MEMBRANE AT STA 200 TO 218, LBL 25 TO RBL 26. INSTALLED NEW SECTION OF MEMBRANE 0.025 7075-T6 REF SRM 53-14-1 PAGE 27. -
Back to JASC 5315