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 00FDEA00377Floorbeam · corrodedDURING ROUTINE INSPECTION, FLOORBEAM BS 640 FOUND CORRODED BEYOND LIMITS 4 INCHES LEFT OF NR 4 SEAT TRACK. CUT OUT DAMAGED AREA, FAB AND INSTALLED REPAIR PER IAW SRM 53-10-8.SDR 00FDEA00376Floorbeam · corrodedDURING ROUTINE INSPECTION, FLOORBEAM BS 344 FOUND CORRODED BEYOND LIMITS ON UPPER CHORD AT RBL 50. CUT OUT DAMAGE, FAB AND INSTALL PER IAW SRM 53-10-8.SDR 00FDEA00375Floorbeam · corrodedDURING ROUTINE INSPECTION, FLOORBEAM BS 344, RT O/B END FOUND CORRODED BEYOND LIMITS ON LWR FLANGE. CUT OUT DAMAGE. FAB AND INSTALLED PER IAW SRM 53-10-8.SDR 00FDEA00373Floorbeam · crackedDURING ROUTINE INSPECTION, LWR FLOORBEAM CORROSION AT BS 848 FROM RBL 0 - 24 AND CRACKED AT RBL 1. REMOVED CORROSION IAW SRM 51-10-6, STOP DRILLED CRACK. FABRICATED AND INSTALLED REPAIR ANGLE AND SUPPORT DOUBLER IAW 51-40-3 & 51-30-2.SDR TWAA0009005Floorbeam · corrodedDURING CHECK-C MAINT, FOUND CABIN MEMBRANE CORRODED AT STA 503 TO 522, LONGERON 18L. REMOVED CORRODED AREA AND INSTALLED DOUBLER PER SRM 53-01, PAGE 9.SDR LR7A00141Plate · corrodedDURING SCHEDULED C2 INSPECTION PER JOB CARD HSP53161 FOUND RT CHINE PLATE CORRODED FS 245E TO 345E, RBL 55, WL 146. REPLACED CHINE PLATE PER SRM SMP 583-51-70. NR 39393.SDR LR7A00140Plate · corrodedDURING SCHEDULED C2 INSPECTION PER JOB CARD HSP53161 FOUND LT CHINE PLATE CORRODED FS 245E TO 345E, LBL 55, WL 146. REPLACED CHINE PLATE PER SRM SMP 583-51-70. NR 39392.SDR LR7A00126Fitting · corrodedDURING SCHEDULED C2 NSPECTION, FOUND LT FS 737E GUSSET FITTING CORRODED AT LBL 60, WL 144. REPLACED FITTING IAW SRM SMP 583-51-70. NR 39349.SDR LR7A00119Floorbeam · corrodedDURING SCHEDULED C2 INSPECTION, FOUND FS 245 FLOORBEAM CORRODED AROUND SCREW HOLES AND NUT PLATES RBL 20 TO RBL 63, WL 146. REPLACED FLOORBEAM PER SRM SMP 583-51-30, 51-60 AND 51-70. NR 39312.SDR LR7A00115Floorbeam · corrodedDURING SCHEDULED C2 INSPECTION NR 26994 ACCOMPLISHMENT FOUND FS 228 FLOORBEAM CORRODED LBL 24 TO LBL 27, WL 146. REPAIRED PER SRM SMP 583-51-60 AND 51-70.SDR LR7A0087Floorbeam · corrodedDURING SCHEDULED C2 INSPECTION PER JOB CARD HSP53161, FOUND FS 212 FLOORBEAM UPPER CHORD UPPER AND LOWER SURFACE CORRODED AT LBL 25 TO LBL 54, WL 146. REPAIRED PER SRM SMP 583-51-30.SDR LR7A0086Floorbeam · corrodedDURING SCHEDULED C2 INSPECTION PER JOB CARD HSP53161, FOUND FS 257E FLOORBEAM UPPER CHORD, FWD FLANGE LOWER SURFACE CORRODED AT RBL 40R, WL 146. REPAIRED PER SRM SMP 583-51-140-61.SDR USAA000782Floorbeam · corrodedCLT - FOUND FLOORBEAM T-CAP CORRODED 1 INCH IN 6 AREAS, BS 344 LBL 49, BL 0 FASTENER HOLES. INSTALLED NEW T-CAP PER TR 53-10-13. (M)SDR GAIA00307Floorbeam · corrodedDURING HEAVY C-CHECK AT TIMCO/OSC, FOUND CORROSION ON FLOORBEAM AT STATION 344 RBL 12. REPAIRED FLOORBEAM IAW SRM 53-10-2. THIS AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR GAIA00325Floorbeam · corrodedDURING HEAVY C-CHECK AT TIMCO/OSC, FOUND STATION 480 RBL 24 FLOORBEAM HAS CORROSION ON TOP CAP. REPAIRED FLOORBEAM UPPER CAP IAW SRM 53-10-8. THIS AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR GAIA00295Floorbeam · corrodedDURING HEAVY C-CHECK AT TIMCO/OSC, FOUND CORROSION ON FLOORBEAM STATION 540 AT FASTENER HOLE RBL 50. REPAIRED FLOORBEAM IAW SRM 53-10-8. THIS AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR 0002332299Floorbeam · corrodedDURING H CHECK, FOUND CORROSION ON FLOORBEAM AT B.S. 1130, LBL 35 TO 40, W.L. 208. REPAIRED PER EA 22-175166.SDR TWAA0009006Floorbeam · corrodedDURING CHECK-C MAINT, FOUND CORROSION ON FLOOR MEMBRANE AT LONGERON 18L, BETWEEN STA 1022 AND 1002. REPAIRED MEMBRANE PER SRM 53-01, PAGE 9 (TYPICAL DOUBLER REPAIR).SDR USAA000770Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED 1 INCH, STATION 312, LBBL 1 PLUS 8. FABRICATED ANGLES AND INSTALLED PER SRM 53-10-51. CORROSION LEVEL 2. (M)SDR USAA000772Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED 2 INCHES, 328 FLOORBEAM, RBBL 36 TO 38. REPLACED T-CAP PER SRM 53-10-51 FIG 205. CORROSION LEVEL 2. (M)SDR USAA000742Floorbeam · crackedCLT - FOUND FLOORBEAM CRACKED .250 INCH, BS 520, LBL 45. INSTALLED DOUBLER AND ANGLES PER EA 67167. (M)SDR COMA0010152Floorbeam · corrodedUPON COMPLIANCE OF 2C INSPECTION TASK 151/152-01Z, THE RT FLOOR CROSSBEAM FRAME 33 WAS FOUND TO BE CORRODED. THE DAMAGED PART WAS REPLACED IAW EMB-120 STRUCTURAL REPAIR MANUAL STANDARD PRACTICES.SDR COMA0010149Floorbeam · corrodedUPON COMPLIANCE OF 2C INSPECTION TASK 131/132-01Z, THE RIGHT HAND FLOOR CROSSBEAM AT FRAME 19 WAS FOUND TO BE CORRODED. THE DAMAGED PART WAS REPLACED IAW EMB-120 STRUCTURAL REPAIR MANUAL STANDARD PRACTICES.SDR COMA0010148Floorbeam · corrodedUPON COMPLIANCE OF 2C INSPECTION TASK 131/132-01Z, THE FRAME 16 FLOOR T SECTION WAS FOUND TO BE CORRODED. THE DAMAGED PART WAS REPLACED IAW EMB-120 STRUCTURAL REPAIR MANUAL STANDARD PRACTICES.SDR COMA0010145Strap · corrodedUPON COMPLIANCE OF 2C INSPECTION TASK 131/132-01Z, THE RIGHT HAND NR 1 BUTT STRAP WAS FOUND TO BE CORRODED. THE DAMAGED PART WAS REPLACED IAW EMB-120 STRUCTURAL REPAIR MANUAL STANDARD PRACTICES.SDR COMA0010144Floorbeam · corrodedUPON COMPLIANCE OF 2C INSPECTION TASK 141/142-01Z, THE LEFT HAND FLOOR CROSSBEAM AT FRAME 23 WAS FOUND TO BE CORRODED. THE DAMAGED PART WAS REPLACED IAW EMB-120 STRUCTURAL REPAIR MANUAL STANDARD PRACTICES.SDR COMA0010139Strap · corrodedUPON COMPLIANCE OF 2C INSPECTION TASK 141/142-01Z, THE LEFT HAND NR 2 BUTT STRAP WAS FOUND TO BE CORROCED. THE DAMAGED PART WAS REPLACED IAW EMB-120 STRUCTURAL REPAIR MANUAL STANDARD PRACTICES.SDR COMA0010130Floorbeam · crackedUPON COMPLIANCE OF 2C INSPECTION TASK 5310-121/122-01I, THE LEFT AND RIGHT FLOOR PROP ANGLES WAS FOUND TO BE CRACKED. THE DAMAGED PART WAS REPAIRED IAW EMB-120 STRUCTURAL REPAIR MANUAL STANDARD PRACTICES AND AERODESIGN REPORT 3647-1.SDR TWAA0008807Floorbeam · corrodedDURING CHECK-C MAINT, FOUND CORROSION ON FLOOR MEMBRANE AT LONGERON 18L, STA 750 TO 731, AND STA 712 TO 731. CUT OUT CORRODED AREA AND REPAIRED PER SRM 53-01. TREATED AREA PER SRM 51-10-3.SDR CALA0000787Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT FS 1155, LBL 22 - 44. THE BEAM WAS REMOVED AND A NEW BEAM WAS INSTALLED IAW SRM 51-10-04, 51-10-03, 51-30-01, AND 51-30-05.SDR CALA0000786Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT FS 180, LBL 14-34. THE FLOORBEAM WAS REMOVED AND A NEW FLOORBEAM WAS INSTALLED IAW SRM 51-30-02, 51-10-04, AND 51-10-03.SDR CALA0000785Floorbeam · corrodedINSPECTION FOUND SUBFLOOR WEB CORRODED AT FS 160 - 200, LB 12 - 44. A REPAIR DOUBLER WAS INSTALLED IAW SRM 53-01, FIGURE 4 AND 51-10-03.SDR AWXA0000350Floorbeam · corrodedC-CHECK, UPPER T CAP AT FS 294.5 RBL 32 - RBL 54 CORROSION OUT OF LIMITS. REMOVED FLOORBEAM IAW SRM 51-40-03, FABRICATED T CAP FROM (AND 10136-240), TREATED AND PRIMED REPAIR PARTS, INSTALLED PARTS IAW 737 SRM 53-10-51 FIG 205.SDR EIA2000197Floorbeam · corrodedC2-CHECK, FOUND FLOORBEAM CORRODED AT BS 600 LBL 55-70. CORROSION REMOVED AND FLOORBEAM REPAIRED PER SRM 51-40-04 FIG 3. (M)SDR EIA2000168Web · damagedC2-CHECK, AFT CARGO COMPARTMENT BS 1680 LBL 60 FLOORBEAM WEB FOUND PUNCH HOLE. TRIMMED OFF, NDT INSPECTED AND REPAIRED PER SRM 51-40-02. (M)SDR EIA2000206Fitting · corrodedFOUND BS 480 RBL 43 FLOORBEAM ATTACH TIE DOWN SUPPORT CORRODED. REPLACED TIE DOWN FITTING PER SRM 51-10-01 PAGE 18. (M)SDR EIA2000185Structure · crackedFOUND BS 330 RBL 66 FLOORBEAM UPPER CHORD AND WEB CRACKED. UPPER CHORD AND WEB REPAIRED PER BSB53-2272 AND RS R53-15-34365. (M)SDR AT0000310Floorbeam · corrodedFOUND FLOORBEAM AT BS 160 RBL 0-55 CORRODED. REMOVED AND REPLACED FLOOR SUPPORT IAW TIMCO SERVICE ORDER 151057-47171.SDR QXEA0001590Floorbeam · corrodedYYC- CENTER FLOORBEAM AT STATION 5000 UNDER PANEL 37AB HAS A CORRODED CAMLOCK. REPAIRED IAW HORIZON AIR EA 4-53-1189.SDR SWAA000971Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND BS 987 FLOORBEAM UPPER SURFACE CORRODED, LBL 45 TO RBL 45. REPAIRED BEAM PER SRM.SDR SWAA000968Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND BS 328 FLOORBEAM UPPER SURFACE CORRODED, LBL 28 TO RBL 28. REMOVED AND REPLACED BEAM UPPER CHORD SECTION PER SWA RA NR 1-353-424.SDR F3LA00112Floorbeam · corrodedDEN - DURING C-7 CHECK INSPECTION REPORTED CORROSION ON FLOORBEAM AT BS 328, RBL 12. MAINTENANCE INSTALLED INTERCOSTAL, HI-LOCKS. ANGLE BRACKETS AND FLOOR CAP PER SRM 51-40-3. (M)SDR TWAA0008809Floorbeam · corrodedDURING CHECK-C MAINT, FOUND CABIN CORROSION ON MEMBRANE AT LONGERON 18R, STA 1098 TO 1079 AND STA 1098 TO 1117. CUT OUT CORROSION AND FABRICATED DOUBLER FROM 0.025, 7075-T6 MATERIAL. INSTALLED DOUBLER WITH 1422 SEALANT AND 2 ROWS OF FASTENERS PER SRM 53-01 FSDR TWAA0008808Floorbeam · corrodedDURING CHECK-C MAINT, FOUND CABIN CORROSION ON FLOOR MEMBRANE AT LONGERON 18L, STA 560 TO 579 AND STA 541 TO 522. REMOVED CORROSION PER SRM 51-10-3. PRIMED PER 51-10-3. REPAIRED PER SRM 53-01 FIG 4 PAGE 18.SDR SWAA000970Floorbeam · crackedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM CRACKED ON UPPER SURFACE, BS 947, LBL 53. REPAIRED BEAM PER SWA RA NR 1-353-2292.SDR UPS00232740Floorbeam · corrodedINSPECTION TYPE:C, FLOORBEAM LOWER CHORD CORRODED BS 600 LBL 12 TO 14. CORROSION REMOVED PER SRM 51-10-06, FLOORBEAM REPAIRED IAW SMRO EO 2000-018-006, UPS ENGINEERING FILE NUMBER 727-53-2257.SDR CALA0000770Floorbeam · corrodedINSPECTION FOUND CORROSION ON FLOORBEAM UPPER CHORD AT STA 160, RBL 48. A REPAIR WAS INSTALLED IAW ECRA 5310-04017, EA 9-5310-2-A0701, SRM 51-10-4 AND 51-10-3.SDR QXEA0001593Floorbeam · corrodedYYC- AUXILIARY FLOORBEAM HAS CORROSION ON CABIN FLOOR STRUCTURE FRAME 3820 THROUGH 3870. REPAIRED IAW FOKKER SRM 53-01-01.SDR TWAA0008810Floorbeam · corrodedDURING CHECK-C MAINT, IN LT CABIN FOUND CORROSION ON FLOOR MEMBRANE AT LONGERON 18L STA 655 TO 674. REMOVED CORROSION PER SRM 51-10-3. PRIMED PER SRM 51-10-3B. INSTALLED FASTENERS PER SRM 51-10-05.SDR UPS00232737Floorbeam · corrodedINSPECTION TYPE:C&SI, CORROSION UNDER ANCHOR NUT ON CARGO FLOOR, FLOORBEAM AFT CARGO BAY, AT STA 1045 APP AND RBL 8. REPAIR CARRIED OUT IAW SRM 51-30-2 SRM 51-10-6 53-10-5 FIG 4.
Back to JASC 5315