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 USAA010822Floorbeam · corrodedPIT - FOUND FLOORBEAM CORRODED 2 INCHES BY 4 INCHES, FLOORBEAM 360 LEFT. CORROSION LEVEL 1. REMOVED AREAS OF LIGHT CORROSION, TREATED, PRIMED PER SRM 53-10-15. (M)SDR AALA20011159Floorbeam · corrodedTUL - FOUND TOP FLANGE OF FLOORBEAM CORRODED AT STATION 1070 APPROX LBL 15. INSTALLED DOUBLER PER SRM 53-10-07-02 TREATED AND PRIMED. (M)SDR AT0100192Floor Support · corrodedFOUND CABIN FLOOR SUPPORT AT BS 992 CORRODED. CORRECTIVE ACTION: REMOVED CORROSION, FABRICATED AND INSTALLED FLOOR SUPPORT REPAIR. IAW DC9 SRM 53-11-1 FIGURE 11, 51-10-3,51-30-2, 53-01 FIGURE 2SDR USAA010558Floorbeam · crackedCLT - FOUND FLOORBEAM T-CAP CRACKED, BS 520, RBL 25, WL 208. INSTALLED DOUBLER AND PIVOT LINK ASSY PER SB 737-53-1120 AND EA 69537. (M)SDR DL767010818Floorbeam · corrodedCORROSION FOUND ON THE STA 1480 FLOORBEAM AT THE RT O/B FRAME ATTACHMENT LOCATION AND AT RBL 72 AFT UPPER FLANGE. ER/A 397554-14.SDR SWAA011488Floorbeam · crackedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM CRACKED AT BS 647.5, LBL 54, WL 208. REPAIRED FLOORBEAM PER SRM.SDR 2001UALA00770Floorbeam · damagedCABIN FLOORBEAM UPPER FLANGE HAS EXCESSIVE MATERIAL LOSS AT STA 294, RBL 16 TO RBL 45, WL 208. REPLACED FLOORBEAM UPPER FLANGE. MAJOR REPAIR ACCOMPLISHED.SDR 2001UALA00757Floorbeam · damagedFLOORBEAM WEB HAS ELONGATED FASTENER HOLES STA 324 RBL 43 WL 204. MAJOR REPAIR ACCOMPLISHED. INSTALLED FREEZE PLUGS, ANGLE REPAIR AND DOUBLER.SDR AT0100198Longeron · corrodedFOUND LONGERON 16L CORRODED. CORRECTIVE ACTION: REMOVED AND REPLACED LONGERON SECTION AT BS 680-699. IAW DC9 SRM 51-10-1 FIGURE 36SDR AT0100191Floor Support · corrodedFOUND CABIN FLOOR SUPPORT AT BS 200 CORRODED. CORRECTIVE ACTION: REMOVED CORROSION, FABRICATED AND INSTALLED FLOOR SUPPORT REPAIR. IAW DC9 SRM 53-01,51-10-4,53-11-1,51-30-5SDR AT0100190Floor Support · corrodedFOUND CABIN FLOOR SUPPORT AT BS 160-218 CORRODED. CORRECTIVE ACTION: REMOVED CORROSION, FABRICATED AND INSTALLED FLOOR SUPPORT REPAIR. IAW DC9 SRM 53-11-1 FIGURE 11, 51-10-3,51-30-2SDR 2001UALA00756Floorbeam · corrodedCABIN FLOORBEAM UPPER CHORD IS CORRODED AT BS 1016, LBL 42 TO RBL 42, AT WL 208. REPLACED ENTIRE UPPER CHORD. MAJOR REPAIR ACCOMPLISHED.SDR 2001UALA00742Floorbeam · corrodedCABIN FLOORBEAM UPER SURFACE CORRODED STA 1681, STR RBL 12, RBL 24 TO RBL 30, WL 208. MAJOR REPAIR ACCOMPLISHED. INSTALLED FILLERS AND DOUBLERS.SDR AT0100197Angle · corrodedFOUND CORROSION IN THE AFT PIT ON THE CABIN FLOOR BEAM AT BS 996. CORRECTIVE ACTION: REMOVED, FABRICATED, DRILLED, AND INSTALLED REPLACEMENT UPPER CAP. IAW DC9 SRM 51-10-3, 53-01 FIGURE 1 51-30-2, 51-30-5, 51-10-4, 55-11-3SDR USAA010591Floorbeam · corrodedPIT - FOUND FLOORBEAM CORRODED .5 INCH BY 1 FOOT, STATION 344 UNDER FLOORBOARD NR 8. SPLICED IN BEAM REPAIR. (M)SDR 2001UALA00747Floorbeam · damagedFLOORBEAM STA 947, LBL 22 THRU RBL 18 HAS EXCESS MATERIAL REMOVED. ACCOMPLISHED SPLICE REPAIR. MAJOR REPAIR ACCOMPLISHED.SDR 2001UALA00744Floorbeam · crackedFLOORBEAM CRACKED AT FLOOR LEVEL AT BS 663, BL 0. REMOVED DAMAGED AREA. ACCOMPLISHED SPLICE REPAIR. MAJOR REPAIR ACCOMPLISHED.SDR 2001UALA00743Floorbeam · corrodedCABIN FLOORBEAM WEB CORRODED STA 1425, STR RBL 70. MAJOR REPAIR ACCOMPLISHED. INSTALLED NEW WEB.SDR HN6R0000177Floorbeam · corrodedCORROSION ON TOP FLANGE OF FLOOR BEAM. BS 328, WL208, RBL 10 FOR RBL 50. REMOVED AND REPLACED SECTION OF TOP FLANGE ER 01-0286.SDR HN6R0000172Floorbeam · corrodedCORROSION ON TOP AND BOTTOM SIDE OF TOP FLANGE OF FLOOR BEAM. BS 312, WL 208, RBL 45 TO LBL 25. REMOVED , FABRICATED, AND REPLACED 25 T CHORD ON FLOOR BEAM ER 01-0287.SDR HN6R0000499Floorbeam · corrodedFLOOR SPAR IS CORRODED AT BS 986, WL 208, RBL 43. REMOVED CORROSION, FABRICATED REPAIR PARTS AND INSTALLED.SDR USAA010544Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED SEVERAL 1 INCH AREAS, BS 312, BETWEEN LBL 12 AND RBL 12, AT FLOOR LEVEL. REMOVED AND REPLACED PREVIOUS T-CAP REPAIR PER TYPICAL REPAIR 53-10-13. (M)SDR USAA010543Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED 1 INCH BY 24 INCHES, BS 259.5 RBL 12 TO LBL 12 ALONG COCKPIT FLOOR. DAMAGED REMOVED, INSTALLED REPAIR PER SRM 51-10-02 AND TR 53-10-16. (M)SDR USAA010541Floorbeam · corrodedCLT - FOUND FLOORBEAM T-CAP CORRODED SEVERAL 1 INCH DIAMETER AREAS, BS 947 BETWEEN RBL 14 AND LBL 14. REMOVED AND REPLACED PREVIOUS T-CAP REPAIR PER SRM 53-10-9, FIG 2. (M)SDR USAA010540Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED, SEVERAL 1 INCH AREAS, BS 1006, BETWEEN LBL 10 AND LBL 30. REMOVED AND REPLACED UPPER T-CAP PER SRM 51-30-0. (M)SDR USAA010538Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED SEVERAL AREAS 1 INCH, BS 328, RBL 12 TO RBL 60 TO FLOOR LEVEL. REMOVED AND REPLACED UPPER T-CAP OF FLOORBEAM PER TYPICAL REPAIR 53-10-13. (M)SDR 01FDEA00367Floorbeam · corroded(C53-221-01) AT UPPER SURFACE OF 25-G BEAM BS 270, WL 208, LBL 1-6.SDR 01FDEA00364Floorbeam · corrodedCORROSION ON FLOORBEAM AT FASTENER HOLES BS 560 BETWEEN RBL 25 & LBL 25, WL 208. REMOVED, REPLACED AND FAB PER IAW FEDEX SRM 53-10-1, 53-10-8, 51-10-2, 51-20-4 & 51-30-2.SDR HN6R0000180Floorbeam · corrodedCORROSION ON TOP OF FLOORBEAM. BS 344, WL 208, LBL 65 TO RBL 15. FABRICATED AND REPLACED SECTION OF FLOORBEAM ER 01-0286SDR ASAA0140074Floorbeam · corrodedPAE - DURING SI CHECK, FOUND FLOORBEAM SUPPORT ANGLE AT BS 328 TO 338, RBL 63, AND WL 208 CORRODED. REPAIRED IAW SRM. (M)SDR 2001UALA00710Floorbeam · corrodedFLOORBEAM UPPER CAP CORRODED STA 324, RBL 43-48. MAJOR REPAIR ACCOMPLISHED. INSTALLED FILLER AND ANGLE REPAIR.SDR DL757010774Floorbeam · corrodedTHE UPPER CAP OF THE FS 1681 PASSENGER FLOORBEAM WAS FOUND WITH SEVERAL AREAS OF CORROSION ALONG ITS LENGTH. THE UPPER CAP WAS TRIMMED OFF ALONG THE ENTIRE BEAM LENGTH TO REMOVE ALL CORROSION. A NEW UPPER CAP WAS FABRICATED FROM AN ALUMINUM EXTRUSION AND INSTSDR AWXA0001747Floorbeam · corrodedFLOORBEAM AT STA 986.5 HAS SURFACE CORROSION. REPAIRED IAW AWA ER 03-5305-01117-DD3.SDR AWXA0001744Floorbeam · corrodedCORROSION ON STA 1016 FLOORBEAM FROM LBL 12 - RBL 35. REPAIRED FLOORBEAM IAW AWA ER 03-5310-01118-JS1.SDR AWXA0001736Floorbeam · corrodedSTA 1006 FLOORBEAM HAS CORROSION RBL 14-28. REPAIRED FLOORBEAM IAW SRM 53-00-51 FIG 203.SDR AWXA0001735Floorbeam · corrodedFLOORBEAM STA 967 HAS SURFACE CORROSION LBL 30-31. REMOVED CORROSION; FABBED AND INSTALLED REPAIR STRAP AND TAPERED FILTER IAW SRM 53-00-51.SDR AWXA0001733Floorbeam · corrodedFLOORBEAM AT STA 294.5 HAS CORROSION. REMOVED AND REPLACED FLOORBEAM IAW SRM 53-10-08 AND 53-10-51.SDR COMA0160375Floorbeam · crackedFLOOR MEMBER AT FS 280.00 IS CRACKED JUST RIGHT OF FLOOR SUPPORT AT RBL 9. TRIMMED OUT CRACKED AREA IN FLOOR MEMBER, LPI CHECKED, FABBED REPAIR ANGLE AND INSTALLED IAW WVAC EO 601R-53-2450.SDR COMA0160373Floorbeam · corrodedFLOORBEAM WEB AT FS 280.00 IS CORRODED ON THE UPPER EDGE BETWEEN RBL 9 AND LBL 9. REMOVED FWD J-ANGLE, TRIMMED OUT CORRODED AREA OF WEB, FABBED FILLER, REPAIR DOUBLER AND INSTALLED IAW WVAC EO WVAC 601R-53-2455A.SDR AWXA0001979Support · crackedD: Aft Cabin Floor Support (shear web) at RBL 0, Between STA 927-947.5 has crack at fastner holes.C: Removed shear web support & formed new shear support from 2024T3 0.040 P/O 9502524402. Treated, primed, top coated & installed support REF DWG PL 69-36656 SRMSDR 2001UALA00709Floorbeam · crackedFLOORBEAM WEB CRACKED STA 520 RBL 45.5. MAJOR REPAIR ACCOMPLISHED. INSTALLED DOUBLER REPAIR.SDR USAA010533Floorbeam · corrodedCLT - FOUND SEVERAL 1 INCH AREAS OF CORROSION ON FLOORBEAM, BS 967, RBL 28 TO LBL 28. REMOVED DAMAGE, INSTALLED T-CAP SPLICE REPAIR PER SRM 53-10-09. (M)SDR 2001UALA00716Floorbeam · corrodedFLOORBEAM UPPER SURFACE CORRODED STA 294, RBL 36-51. MAJOR REPAIR ACCOMPLISHED. INSTALLED FLOORBEAM SPLICE REPAIR.SDR SWAA011424Floorbeam · crackedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM UPPER CHORD IS CRACKED AT BS 947.5, LBL 55. REPAIRED CHORD PER BFG ER.SDR 2001UALA00706Floorbeam · crackedFLOORBEAM WEB CRACKED STA 195 WL 207 LBL 30 INBD OF STR 17L. INSTALLED NEW WEB.SDR USAA010532Floorbeam · corrodedCLT - FOUND FLOORBEAM T-CAP CORRODED IN SIX LOCATIONS EACH ONE IS 1 INCH BY 1 INCH AREA, BS 377.7, LBL 63 TO RBL 63. REMOVED DAMAGE AND INSTALLED REPAIR FILLER AND DOUBLER PER 53-00-51 FIG 205. (M)SDR 2001F00058Floorbeam · corrodedSAW - DURING CPCP-2 INSPECTION MAINTENANCE REPORTED FLOORBEAM 38 AND 40 CORRODED. MAINTENANCE REMOVED AND REPLACED THE FLOORBEAMS IAW SRM 51-25-01. AIRCRAFT WAS RETURNED TO SERVICE. REF SIMA20011433. (M)SDR SIMA20011433Floorbeam · crackedSAW - DURING CPCP-2 INSPECTION MAINTENANCE REPORTED FLOORBEAM 38 AND 40 CORRODED. MAINTENANCE REMOVED AND REPLACED THE FLOORBEAMS IAW SRM 51-25-01. AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR SWAA011402Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM CORRODED AT BS 1016, RBL 50 TO LBL 50. REPAIRED PER SWA TI.SDR 2001UALA00701Floorbeam · corrodedFLOORBEAM CORRODED STA 1681 RBL 32. INSTALLED T-CAP REPAIR AND STIFFENERS.
Back to JASC 5315