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 QXEA200602737Floorbeam · corrodedC3 PDX - AFT BAGGAGE COMPARTMENT FLOORBEAM ANGLE FORWARD OF X783.10 CORROSION AT STATION YL13 TO YL23. REPAIRED IAW SRM 51-21-00, 51-14-00, AND 51-21-10.SDR AWXA200601755Floorbeam · corrodedSAL - MAJOR REPAIR - CORROSION ON MAIN CABIN FLOORBEAM, FR20, -Y765. REPAIRED MAIN CABIN FLOORBEAM, FS 18+ 6" TO FS 19 - 5", -Y765 IAW A319 SRM 53-11-15, FIG 202.SDR F3LA200600133Floorbeam · corrodedDURING C-4 CHECK, INSPECTION REPORTED CORROSION THROUGH FLOORBEAM Y254L AT FRAME C16 IN FWD CABIN. CORRODED AREAS FOUND TO BE OUT OF LIMITS PER SRM 53-11-14. CUT OUT CORRODED AREA PER SRM 53-11-14, FIG 201. FABRICATED AND INSTALLED REPAIR ANGLES PER SRM'S 5SDR 06FDEA03592Floorbeam · corrodedMAIN DECK CARGO, ON FLOOR PANEL OPEN UP FOUND UNDERFLOOR STRUCTURE AT STA 1225 RBL 4 WITH CORROSION. CORROSION ON MAIN DECK CARGO ON FLOOR PANEL UNDERFLOOR STRUCTURE AT STA 1225 RBL 4 REMOVED AS PER SRM 51-21-01 VOLUME II AND FOUND EXCEEDED LIMIT AS PER SSDR 06FDEA03591Floorbeam · corrodedFOUND CENTER CARGO COMPARTMENT, FLOOR PANEL SUPPORT CORRODED AT STA 1841 RBL 54. REPAIR CARRIED OUT AS PER FEDEX E.A. 1-5310-104803.SDR 06FDEA03589Floorbeam · damagedFLOOR DAMAGE AT POSITION 9L/13L DUE TO LOCK BEING PULLED FROM FLOOR. LOCK ID D1696 AT FRAME 66. UPON FURTHER INVESTIGATION FOUND FLOORBEAM ROLLED WITH A 1.25" CRACK AT LIGHTNING HOLE. REF WRI 5310-9370 FOR EA APPLYING TO THE FLOORBEAM DAMAGE EA #6-5310-1052SDR KCSA061398Floorbeam · damagedFOUND UPPER DECK STA 440 FLOORBEAM WEB DAMAGED AROUND LBL 48.SDR AWXA200601754Floorbeam · corrodedSAL - MAJOR REPAIR - CORROSION ON MAIN CABIN FLOORBEAM, FS 20, -Y1292. REPAIRED MAIN CABIN FLOORBEAM, FS 18+10" TO FS 24, -Y1292 IAW A319 SRM 53-11-15, FIG 202.SDR SWIA200617509Floorbeam · crackedFS 280 FLOOR SUPPORT CRACKED JUST OTBD OF LBL 9 LEFT, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED ANGLES AS PER BOMBARDIER REO 601R-53-11-138-NC SHT 1-3.SDR DU4R2006661Floorbeam · corrodedCORROSION ON FLOORBEAM AT RBL 12 TO RBL 47 FS 200. BLENDED PER DC-9/MD-80 SRM 51-10-3 AND 53-01D, FOUND TO BE OUT OF LIMITS. FABRICATED AND INSTALLED FLOORBEAM 37.5" BY 2-1/2" IAW DC-9/MD-88 SRM 51-10-2, 51-10-4, 51-10-3D AND 51-30-5.SDR F3LA200600143Floorbeam · corrodedDURING C-4 CHECK, INSPECTION REPORTED CORRODED FLOORBEAM FASTENER HOLE AT Y1292, CROSSBEAM FS 68, RT SIDE AFT FUSELAGE. FOUND FLOORBEAM TO BE OUT OF LIMITS PER SRM 53-00-14. REMOVED AND REPLACED FLOORBEAM AT Y1292 FROM FS 66 TO FS 68 PER SRM'S 51-42-11, 51-4SDR F3LA200600136Floorbeam · corrodedDURING C-4 CHECK, INSPECTION REPORTED AFT FUSELAGE LT FLOORBEAM FASTENER HOLES CORRODED AT Y1292, BETWEEN FS 69 AND FS 70. REMOVED CORROSION ON FLOORBEAM AND FOUND FLOORBEAM TO BE OUT OF LIMITS PER SRM 53-00-14, FIG 102. REMOVED AND REPLACED FLOORBEAM BETWEESDR F3LA200600131Stand Off · corrodedDURING C-4 CHECK, INSPECTION REPORTED DAMAGED STANDOFF ON AFT BULKHEAD RT FLOORBEAM, Y1732 AT CROSSBEAM FR66. FOUND DAMAGE TO BE OUT OF LIMITS PER SRM 53-00-14, FIG 102. REMOVED CORROSION FROM SILL BEAM AT FR66 PER SRM 53-41-14 FIG 201. FABRICATED AND INSTASDR F3LA200600130Shear Web · corrodedDURING C-4 CHECK, INSPECTION REPORTED HEAVY CORROSION ON AFT FUSELAGE RT FLOORBEAM SHEAR PLATE WEB AT Y1292 (BETWEEN CROSSBEAMS FR69 AND FR70). FOUND CORROSION ON SHEAR PLATE AND ANGLED WEB TO BE OUT OF LIMITS PER SRM 51-11-15. REMOVED DAMAGED SHEAR PLATE ANSDR F3LA200600129Shear Web · corrodedDURING C-4 CHECK, INSPECTION REPORTED HEAVY CORROSION ON AFT FUSELAGE LT FLOORBEAM SHEAR PLATE WEB AT Y1292 (BETWEEN FRAMES FR69 AND FR70). FOUND CORROSION ON SHEAR PLATE WEB TO BE BEYOND REPAIR LIMITS PER SRM 53-41-14. REMOVED DAMAGED SHEAR PLATE AND SUPPORSDR QXEA200602645Floorbeam · corrodedC3 PDX-AFT BAGGAGE COMPARTMENT TOP OF BEAM AT STATION FS783.102 CORROSION ON CLIP YL8.5. REPAIRED IAW SRM 51-21-00.SDR KCSA061381Floorbeam · misdrilledFOUND FASTENER HOLE HAVE SHORT EDGE DISTANCE ON BS 440 UPPER DECK FLOORBEAM UPPER HORIZ CHORD LBL 43 TO LBL 51 AND RBL 43 TO RBL 51.SDR KCSA061377Floorbeam · corrodedFOUND MAIN DECK FLOORBEAM UPPER CAP SPLICE CORRODED BS 800, RBL 110.SDR NOCA15506Floorbeam · corrodedAFT CARGO FLOORBOARD TIEDOWN CONNECTION STRIP ON FLOORBEAMS CORRODED. REMOVED CORROSION FROM FLOORBEAMS, CONNECTON STRIP OUT OF LIMITS PER SRM 51-10-02. REINSPECT AND EVALUATE FOR CORROSION LEVEL. TREATED AND PRIMED BARE METAL AND REPLACED CONNECTION STRIP SDR 06FDEA03484Floorbeam · damagedFOUND FLOORBEAM STA 1130 RBL 50 WL 208 HAS A DOUBLE HOLE ON AFT FLANGE. REPAIRED FLOORBEAM AT BS 1130 RBL 50 WL 208 IAW SRM 53-10-8M THIS IS A MAJOR REPAIR.SDR USAA061200Floorbeam · corrodedBSTA 365 BL-0 RBL 60 CORRODED. REMOVED DAMAGE, FABRICATED NEW PART & INSTALLED PER SRM 51-40-02, 53-15-01; DEFECT SIZE: 2.5"W X 60"L X 0.107"D.SDR DHL2006805519Floorbeam · corrodedUPPER CARGO COMPT FLOORBEAM LWR FLANGE HAS CORROSION DAMAGE STA 902.000 LBL 52" (MAJOR REPAIR). PERFORMED MAJOR REPAIR IAW FAA FORM 8100-9 DATED 09-27-06, BOEING MESSAGE 1-230914076-2 (SEMAN DWG ED-4320) DATED 09-27-06. REMOVED RETAINER AND SPLICE ANGLES IAWSDR DHL2006770515Floorbeam · corrodedLOWER LOBE AND WALKWAY BEAM LT SIDE, BS 294, CORROSION ON CHORD. REMOVED, FAB AND REPLACED CORRODED STIFFENER FROM P/N BAC 1505-29222, PO NR 9003865, IAW SRM 51-30-2, 51-30-5, 53-10-2 FIG 1 AND 51-20-1 FIG2. CUT OUT DAMAGED WEB AND FAB DOUBLER FROM 2024-0, .SDR PIDR2006019Floorbeam · corrodedUNDERSIDE OF BS 727D+5 FLOORBEAM IN AFT CARGO BIN IS CORRODED FROM LBL17 TO RBL8. REPAIRED AREA IAW SRM 53-00-53 FIG. 201.SDR PIDR2006022Floorbeam · corrodedFLOORBEAM AT BS 312 CORRODED AT NUTPLATE HOLES FROM RBL8 TO RBL32. REPLACED FLOORBEAM T-CAP IAW SRM 53-10-51.SDR DL76S060797Floorbeam · corrodedCABIN FLOORBEAM UPPER CHORD STA 287 CORRODED AT RBL 51 TO RBL 62 AND ALSO EXISTING SPLICE PLATE CORRODED AT RBL 10 TO RBL 15. REPAIRED PER SRM 53-00-51D FIGURE 201, AMM 32-41-00.SDR DL76S060796Floorbeam · crackedCABIN FLOORBEAM AT STA 325 LBL 32 UPPER STRUCTURE BENT AND CRACKED IN RADIUS AS MARKED. REPAIRED PER SRM 53-00-51D FIGURE 201.SDR COMA0660556Floorbeam · crackedANGLE BRACKET AT FS 484.00 RBL36 MARKED IS CRACKED. REMOVED AND REPLACED ANGLE BRACKET CLIP IAW REO 601R-53-41-059.SDR CALA0600372Floorbeam · corrodedINSPECTION FOUND BEAM AT GALLEY MOUNT CORRODED AT STA 947, RBL 49.25-54. REPAIRED IAW ECRA 5321-01397.SDR QXEA200602687Floorbeam · corrodedBAGGAGE COMPARTMENT FLOORBOARD SUPPORT ANGLE AT STATION X600 HAS CORROSION ON TOP SURFACE BETWEEN BL0 AND LBL6.0. REPAIRED IAW SRM 51-20-11, 51-20-36, AND 51-20-51.SDR KCSA061371Floorbeam · corrodedFOUND STA 520 FLOORBEAM UPPER CHORD HAS AREA OF CORROSION BETWEEN RBL 15 AND RBL40.SDR KCSA061370Floorbeam · corrodedFOUND STA520 FLOORBEAM UPPER CHORD HAS AREA OF CORROSION AT RBL 51.SDR KCSA061367Floorbeam · damagedUPPER DECK AREA AT STA 440 FLOORBEAM WEB DAMAGED BETWEEN LBL 9 TO RBL 45.SDR KCSA061366Floorbeam · corrodedSTA 480 FLOORBEAM UPPER TEE CORRODED AT RBL 44.SDR AWXA200601664Floorbeam · crackedMCN - FLOORBEAM WEB CRACKED, BS 382, LBL 1, WL 207. REPLACED FLOORBEAM WEB, BS 382, LBL 1, WL 207 IAW B737-300 SRM 51-40-02 FIGURE 12.SDR SWAA063678Floorbeam · corrodedDURING SCHEDULED 20Y CHECK, FOUND FLOORBEAM CORRODED AT BS 1016, LBL 9 TO LBL 36. REPAIRED FLOORBEAM PER SRM.SDR 06FDEA03433Floorbeam · corrodedMAIN CARGO DECK, FLOORBEAM UPPER SURFACE CORRODED, BS 1070, RBL 25-45, WL 208. REMOVED CORROSION ON FLOORBEAM UPR SURFACE BS 1070 RBL 25-45 WL 208 AND REPAIRED IAW SRM 53-10-8.SDR KCSA061364Floorbeam · corrodedSTA 340 FLOORBEAM UPPER TEE HAS CORROSION AT LBL 38.SDR ASAA0671020Floorbeam · brokenFOUND FLOORBEAM AT BS 540 BL 0-24 BROKEN, REPAIRED IAW SRM 51 30 01 51 40 02 AND DWG 143A5240.SDR ASAA0671012Floorbeam · corrodedAFT PIT FLOORBEAM AND ANCHOR NUT HOLES CORRODED AT BS 767+5. REPAIRED IAW SRM 53 00 53.SDR ASAA0670998Strap · corrodedAFT CARGO FLOORBOARD STRAP IS CORRODED REPAIRED IAW SRM 51 40 05.SDR CALA0600367Floorbeam · corrodedINSPECTION FOUND BEAM CORRODED AT NUT PLATE HOLE, STA 986.5, RBL 43. THE BEAM WAS REPAIRED IAW ECRA 5321-01397.SDR CALA0600366Floorbeam · corrodedINSPECTION FOUND BEAM CORRODED AT NUT PLATE HOLE, STA 986.5, RBL 29.5. REPAIRED IAW ECRA 5321-01396.SDR CALA0600365Floorbeam · corrodedINSPECTION FOUND BEAM CORRODED AT STA 328, RBL 37-45 NEAR R-1 DOOR. REPAIRED IAW ECRA 5321-01398.SDR C1HA200697018Floorbeam · corrodedCORROSION AT FLOORBEAM 360 RBL 5. REMOVED FABRICATED NEW BACL 505-100617 AND INSTALLED AT LBL 8- RBL 14 IAW SRM 53-10-8 FIG 3 AND 51-30-2.SDR C1HA200697009Floorbeam · corrodedCORROSION ON CABIN FLOOR BEAM BS 440 LBL 45 TO RBL 24. REPAIRED FLOORBEAM AT BS 440 IAW SRM 53-10-8 FIG 3.SDR C1HA200697017Floorbeam · corrodedCORROSION OF FLOORBEAM BS 1110 LBL 65 TO RBL 65. REPAIRED DAMAGED AREA ON FLOORBEAM BS 1110 FROM LBL 66 TO RBL 15 IAW SRM 53-10-2 AND 53-10-8.SDR C1HA200697014Floorbeam · corrodedCORROSION ON CABIN FLOORBEAM BS 340 LBL 65 - RBL 65 UPPER AND LOWER SURFACE. REPAIRED CORRODED AREA AT BS 340 FROM BL 0 TO RBL 28 IAW B727 SRM 53-10-2 AND 53-10-8 FIG 3.SDR C1HA200697010Floorbeam · corrodedCORROSION ON FLOORBEAM (CABIN) BS 400 LBL 45- RBL 24 (UPPER T-SECTION). REMOVED UPPER T-SECTION OF FLOORBEAM FROM LBL 14 - RBL 17 IAW B727 SRM 53-10-8 FIG 3. FAB NEW SECTION P/N BAC1505100617 IAW B727 SRM 53-10-8 FIG 3. INSTALLED REPAIR PART IAW B727 SRM 51SDR C1HA200697008Floorbeam · corrodedFOUND FLOORBEAM CORRODED BS 460 RBL 24-65. REPAIRED FLOORBEAM BS 460 FROM RBL 33 TO RBL 36 IAW B727 SRM 53-10-2 AND 53-10-8.
Back to JASC 5315