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 USAA001224Floorbeam · corrodedCLT - FOUND FLOORBEAM T-CAP .5 INCH BY .5 INCH, IN 3 AREAS, STATION 377.7, LBL 22.25, 27, 48. FABRICATED FLOORBEAM REPAIR PER SRM 53-00-51 FIG 203. CORROSION LEVEL 1. (M)SDR USAA001209Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED 104 INCHES BY 2.1875, STATION 986, FLOORBEAM TOP SURFACE. CORROSION LEVEL 1, C53-107-02. INSTALLED T-CAP PER TR 53-10-05A. (M)SDR USAA001210Floorbeam · crackedCLT - FOUND FLOORBEAM CRACKED 12 INCHES, STATION 312, BL 0 TO RBL 12. REPLACED BEAM PER SRM 53-10-51. (M)SDR GAIA00476Floorbeam · corrodedFOUND DURING ROUTINE SCHEDULED MAINTENANCE, MAIN CABIN FLOORBEAM HAS CORROSION AROUND CLIP NUT HOLES AT BS 312, LBL 3 AND LBL 10, REF NR 20622. REPAIRED FLOORBEAM IAW B727 SRM 53-10-8, FIGURE 9. THE AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR 0002856717Floorbeam · corrodedDURING M CHECK, FOUND CORROSION ON FLOORBEAM UPPER CHORD HORIZONTAL FLANGE BS 660 BETWEEN LBL 3 AND LBL 19. REPAIRED PER EA 178199.SDR CALA0001230Floorbeam · mismanufacturedTHE RT SIDE FLOORBEAM AT BS 1016 WAS FOUND TO HAVE AN INSUFFICIENT NUMBER OF FASTENERS DURING ACCOMPLISHMENT OF FCD 5321-01052. REPAIRED IAW ECRA 5310-03851 REVISION A.SDR CALA0001229Floorbeam · corrodedINSPECTION FOUND FLOORBEAM UPPER CHORD CORRODED AT NUT CLIPS, BS 986.5. REPAIRED IAW ECRA 5310-03851.SDR USAA001149Floorbeam · crackedCLT - FOUND FLOORBEAM CRACKED 2 INCHES, BS 663, BL 0. INSTALLED STIFFENER FILLER AND DOUBLER PER EA 67727. (M)SDR F3LA00168Floorbeam · corrodedDEN - DURING C-2 CHECK INSPECTION, REPORTED CORROSION ON TOP OF FLOORBEAM AT STATION 329, LBL 30. MAINTENANCE REMOVED CORROSION BUT FOUND IT TO BE OUT OF LIMITS PER SRM 53-10-01. REMOVED DAMAGED SECTION, FABRICATED AND INSTALLED NEW REPAIR ANGLES PER SRM 51-SDR F3LA00173Floorbeam · corrodedDEN - DURING C-2 CHECK INSPECTION, REPORTED CORROSION ON TOP OF FLOORBEAM AT STATION 295.0, RBL 10. MAINTENANCE REPLACED FLOORBEAM PER FRONTIER ENGINEERING AUTHORIZATION 53-737-082 AND SRM 51-30-02. (M)SDR 00FDEA00517Floorbeam · corrodedCORROSION (C53-111-01 ,3) AROUND NUT PLATE HOLE, LWR CHORD OF BS 1148 FLOORBEAM, RBL 22, WL 201. *S/D* REMOVED AND REPLACED FEDEX EA 7-5310-52128 & SRM 53-10-8.SDR USAA001144Floorbeam · corrodedCLT - FOUND FLOORBEAM T-CAP CORRODED 3 INCHES BY 6 INCHES, STATION 986.5 FULL LENGTH OF BEAM. INSTALLED NEW T-CAP, SPLICE ANGLE AND STRAP PER SRM 53-00-51. CORROSION LEVEL 2, C53-107-02. (M)SDR USAA001143Floorbeam · corrodedCLT - FOUND FLOORBEAM T-CAP CORRODED 1 INCH BY 1 INCH AREA, STATION 947. CORROSION LEVEL 2, C53-107-02. REMOVED DAMAGE SPLICED IN T-CAP PER TR 53-60-02A. (M)SDR QXEA0002310Floorbeam · corrodedYXX- CORROSION ON FLOORBEAM AROUND RIVET AT FUSELAGE STATION X222.000 ONE FOOT INBOARD OF FORWARD EDGE OF MAIN CABIN DOOR. REPAIRED IAW DHC-8 SRM 51-20-00 AND 53-00-16 TABLE 2.SDR 00FDEA00514Floorbeam · misdrilledWHILE INSP NRC 0901 (INT 194) FINAL BAY OFF FOUND DOUBLE DRILLED HOLE AT BS 360, LBL 23, WL 208. *S/D* DAMAGE OUT OF LIMITS IAW FEDEX SRM 53-10-1 AND REPAIRED PER IAW FEDEX SRM 57-10-8 FIG 8.SDR USAA001117Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED 15 INCHES, STATION 344 FROM RBL 2 TO LBL 13 FLOOR LEVEL. REPLACED T-CAP PER SRM 53-10-51. CORROSION LEVEL 1. (M)SDR USAA001124Floorbeam · corrodedCLT - FOUND FLOORBEAM T-CAP CORRODED 2 INCHES, STATION 328, LBL 49. CORROSION LEVEL 1, C53-107-01. REMOVED CORROSION AND INSTALLED NEW T-CAP PER SRM 51-70-12 FIG 1. (M)SDR USAA001137Floorbeam · corrodedCLT - FOUND FLOORBEAM INTERCOSTAL 1661 TO 1682, RBL 10, CORRODED 2 INCHES BY 6 INCHES. INSTALLED NEW TOP ANGLE PER SRM 53-60-57. (M)SDR L1GA200000210Floorbeam · corrodedCORRODED AREAS 1 X 1 INCH AREAS 6 PLACES. REMOVED CORROSION OUT OF LIMITS. R2 UPPER CAP ON FLOORBEAM AT FS 980.SDR L1GA200000209Floorbeam · corrodedFLOORBEAM CORRODED AT FS 996, X20 TO X50, Z0 SEVERAL 1 TO 2 INCH AREAS. REMOVED AND FABRICATED NEW FLOORBEAM ANGLE.SDR L1GA200000205Floorbeam · corrodedCORRODED AREA 1 X 6 INCH STATION 996 RT X35 Z-0 FLOORBEAM. REPAIRED WITH ANGLE.SDR L1GA200000201Floorbeam · chafedA .75 INCH CHAFED AREA 6 PLACES AT FS 598 BL 7, 10, 14, LT ON TOP OF FLOORBEAM. BLENDED AREA AND FOUND WITHIN LIMITS.SDR L1GA200000199Floorbeam · gougedA .75 INCH GOUGE TOP OF FLOORBEAM BL 20.5 RT FS 639 - 658. BLENDED AREA WITHIN LIMITS. TREATED AND PRIMED.SDR USAA001085Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED 1 INCH BY 2 INCH AREA, STATION 294.5, RBL 45. REMOVED AND INSTALLED FABRICATED ANGLE PER SRM 53-10-08 AND 51-40-02. (M)SDR USAA001076Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED 1 INCH IN 15 AREAS, BS 312 UPPER CHORD FRAME RBL 36, LBL 15. CORROSION LEVEL 1. FABRICATED NEW FLOORBEAM T-CAP PER SRM 53-10-08, 53-10-51. (M)SDR USAA001075Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED 3 INCHES BY 5 INCHES, STATION 360, BBL 0. CORROSION LEVEL 1, C53-107-01. REMOVED DAMAGE AND INSTALLED DOUBLER PER SRM 53-30-51. (M)SDR USAA001103Floorbeam · corrodedCLT - FLOORBEAM CORRODED 1.5 INCHES, RBBL 13 INCHES PLUS STATION 365. INSTALLED REPAIR ANGLE PER TR 53-15-01. CORROSION LEVEL 1. (M)SDR USAA001102Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED 3 INCHE BY 3 INCHES, STATION 1640 BETWEEN RBL 0 AND RBL 45 TOP OF T-CAP. FABRICATED NEW T-CAP PER SRM 51-10-00. (M)SDR EIA2000233Floorbeam · crackedFOUND FLOORBEAM UPPER CHORD AT BS 340, BS 360, BS 380 CRACKS AT FASTENERS BETWEEN LBL 0 AND LBL 60. BS 340 U/D FLOORBEAM LBL 36, LBL 10, LBL 29, LBL 13 CLIPNUT HOLES; BS 360 U/D FLOORBEAM LBL 53, LBL 42, LBL 33 CLIPNUT HOLES; BS 380 U/D FLOORBEAM LBL 67, LBL SDR AALA20001295Floorbeam · corrodedTUL - FOUND FLOORBEAM PLATE CORRODED 20 INCHES RBL. REPAIRED FLOORBEAM PER SRM 53-05 AND AARD 53-00-00-06. (M)SDR TWAA0013206Floorbeam · corrodedDURING CHECK-C MAINT, FOUND CORROSION ON MEMBRANE AT STA 200, LBL 55, TOP OF FLOORBEAM. REMOVED CORROSION BY CUTTING OLD MEMBRANE OUT AND INSTALLED DOUBLER PER SRM 53-07 FIG 2.SDR TWAA0013505Seat Track · corrodedDURING OP 15 MAINT CHECK, FOUND MEMBRANE BADLY CORRODED O/B OF NUMBER 1 CHAIR TRACK, STA 218 TO 237. REMOVED DAMAGED SECTION OF WEB. MADE NEW IN SHOP PER SRM 6-70-01 PAGE 3. INSTALLED PER SRM 51-30-1, 51-30-2 AND 51-30-5.SDR UPS00833652Floorbeam · corrodedINSPECTION TYPE:N/A, CORRODED FLOORBEAMS STA 1420, 1440, 1460. *S/D* REPAIRED FLOORBEAM CORROSION AT STA 1420 AND 1440 AS PER EO DC8-5310-13142A.SDR AALA20001294Floorbeam · corrodedTUL - FOUND FLOORBEAM CORRODED AT 1338, 20 INCHES RBL. INSTALLED DOUBLER PER SRM 53-05. (M)SDR QXEA0002341Floorbeam · gougedYXX- UPPER CARGO DECK LEFT HAND FLOORBEAM Y9.250 HAS VARIOUS SPOTS OF CORROSION AND GOUGING BETWEEN X600.000 AND X644.897. REPAIRED IAW DHC-8 SRM 51-20-36 AND 51-20-16.SDR QXEA0002340Floorbeam · corrodedYXX- UPPER CARGO DECK RIGHT HAND FLOORBEAM AT Y9.250 HAS VARIOUS SPOTS OF CORROSION AND GOUGING BETWEEN X600.000 AND X644.897. REPAIRED IAW DHC-8 SRM 51-20-36 AND 51-20-16.SDR 00FDEA00499Floorbeam · corrodedCORROSION (C53-111-01, 3) ON LOWER CHORD BS 1148 FLOORBEAM LBL 1 - 3, 10, 21, 29, WL 200. *S/D* ACCOMPLISHED PER FEDEX EA 7-5310-52128. OUT OF LIMITS PER FEDEX 53-10-1.SDR 00FDEA00497Floorbeam · corrodedCORROSION (C53-224-01,3) AROUND NUT PLATE HOLES UPPER CHORD, BS 1030 FLOORBEAM, RBL 21, RBL 28, RBL 35, WL 208. *S/D* REMOVED AND REPLACED PER FEDEX SRM 53-10-8.SDR 00FDEA00498Floorbeam · corrodedCORROSION (C53-111-01, 3) ON LOWER CHORD BS 1130 FLOORBEAM, LBL 43 - RBL 50, WL 208. *S/D* REMOVED AND REPLACED PER FEDEX 51-30-2, 51-20-4.SDR SWAA001414Floorbeam · crackedDURING SCHEDULED D-CHECK, FOUND BS 772 UPPER SURFACE CORRODED, LBL 8 - RBL 3. REPAIRED FLOORBEAM PER SRM.SDR 00FDEA00494Floorbeam · corrodedCORROSION (C53-224-01,1) ON FLOORBEAM BS 344, LBL 38, WL 208. *S/D* REMOVED AND REPLACED CORROSION PER IAW FEDEX SRM 53-10-4, 51-30-2 & SR 27-53-007.SDR 00FDEA00495Floorbeam · corrodedCORROSION ON FLOOR SUPPORT UPPER FLANGE LOWER FWD, AND AFT SIDE AT BS 720A, LBL 10, WL 208. *S/D* REMOVED AND REPLACED CORROSION PER IAW FEDEX SRM 51-10-6, 53-10-1. ALODINED, PRIMED, INSTALLED PARTS AND SEAT TRACK PER IAW FEDEX SRM 53-10-9, 51-20-021, 51-20SDR TWAA0013413Web · crackedDURING OP 15 MAINT CHECK, FOUND CRACKS IN FLOOR MEMBRANE AT STA 617 TO 615, LBL 54. INSTALLED WEB REPAIR PER SRM 53-01, PAGE 9 FIG 2 SHEET 3.SDR TWAA0013123Floorbeam · corrodedDURING CHECK-C MAINT FLOORBEAM UPPER FLANGE AT STA 1338 HAD CORROSION, RBL 22 TO O/B END. INSTALLED NEW UPPER FLANGE. TREATED AND PAINTED SAME. INSTALLED ALL FASTENERS AND ATTACHING PART PER SRM 51-30-0 AND DAC DRAWING 9915561.SDR SWAA001407Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND BS 773 FLOORBEAM UPPER SURFACE CORRODED, RBL 8. REPAIRED BEAM PER T1-253-025.SDR AT0000364Floorbeam · corrodedDURING A SCHEDULED INSPECTION AT TIMCO IN LAKE CITY FL, FOUND FLOORBEAM AT BS 200 RBL 0 - 22 CORRODED BEYOND LIMITS. FABRICATED AND INSTALLED NEW FLOORBEAM IAW DC9 SRM 51-10-04, 51-10-03, 53-11-01, AND 51-30.SDR AT0000363Floorbeam · corrodedDURING A SCHEDULED INSPECTION AT TIMCO IN LAKE CITY FL, FOUND FLOORBEAM AT BS 200 RBL 22 - 44 CORRODED BEYOND LIMITS. FABRICATED AND INSTALLED NEW FLOOR SUPPORT IAW DC9 SRM 51-10-04, 51-10-03, 53-11-01, AND 51-30-05.SDR 00FDEA00491Floorbeam · corrodedCORROSION (C53-224-01, 1) ON FLOORBEAM AT BS 328, LBL 44, WL 208. *S/D* REMOVED AND REPLACED PER FEDEX DRAWING SR 27-53-017.SDR SWAA001394Floorbeam · crackedDURING SCHEDULED D-CHECK, FOUND BS 947 FLOORBEAM UPPER CHORD CRACKED AT FASTENER HOLE, LBL 56. REPAIRED BEAM PER T1-453-037.SDR UPS00833583Floorbeam · corrodedINSPECTION TYPE:C123, STA 1540 FLOORBEAM IS CORRODED BEYOND LIMITS AT LBL 50. REPAIRED IAW 8110-3 APPROVED DH SK 806-428.
Back to JASC 5315