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 KCSA071027Floorbeam · corrodedCORROSION ON MAIN DECK FLOORBEAM LOWER SPLICE AT BS 1580, LBL 90 TO LBL 100.SDR 07FDEA00104Floorbeam · crackedDURING ACCESS OPENING ON MAIN CARGO DECK CROSS TRACK FS 45,Y1456/Y1956, P/N R53DD1048-200-00, WAS FOUND CRACKED AND NEED TO BE REPLACED TRACK REPLACED PER SRM 51-40-00.SDR 07FDEA00091Floorbeam · corrodedAT FS 740 RBL 70, TEE CAP AND FITTING AT LIGHTENING HOLE HAS BEEN GROUND ON, NOT TREATED OR PRIMED, AREA HAS CORROSION ON BOTH PARTS. REMOVED CORROSION REF SRM 51-10-1 PAGES 14-16, ROTO PEENED REF SOPM 20-10-03 PG 19. ALODINED AND PRIMED AREA REF EA IO 70053SDR 0700239861Floorbeam · tool damageDURING "L" CHECK, FOUND DRILL START IN THE UPPER FLANGE OF THE FLOORBEAM AT BS 148 RBL 13. REPAIRED PER EA 98-208456.SDR 07FDEA00089Floorbeam · corrodedCOMPLIED WITH EA 7-5310-102014 FUSELAGE-BASIC-BS 870 FLOORBEAM UPPER CAP CORROSION, RBL 51-57.SDR SIMA200701512Floorbeam · corrodedFOUND LEFT OMEGA BEAM CORRODED AT FRAME 20. REMOVED EXISTING REPAIR. CLEAN AND TREATED AREA. FABRICATED REPAIR DOUBLER. INSTALLED DOUBLER AND RESTORED PROTECTIVE FINISH IAW EMB SRM 53-00-10. RETURNED AIRCRAFT TO SERVICE.SDR SWAA070196Floorbeam · corrodedDURING SCHEDULED 8Y CHECK, FOUND FLOORBEAM CORRODED AT BS 986, RBL 40 TO RBL 44. REPAIRED BEAM PER SRM.SDR SWAA070195Floorbeam · corrodedDURING SCHEDULED 8Y CHECK, FOUND AFT CARGO FLOORBEAM CORRODED AT BS 772, LBL 3. REPAIRED FLOORBEAM PER SWA EA.SDR 2007UALA00087Floorbeam · corrodedFLOORBEAM CORRODED AT STA 947 LBL 16 - RBL 16. MAJOR REPAIR: REMOVED DAMAGE. REPAIRED THE T-CAP AT STA 947 PER MM 53-10-95. REPLACED ENTIRE UPPOER FLOOR BEAM CAP, SPLICE LOCATED AT 947 RBL6.SDR TRAX200700073Floorbeam · corrodedFOUND FS 280 HAS CORROSION ON CROSS BEAM. WORK COMPLETED IN ACCORDANCE WITH: CRJ700 REO 670-53-11-046, REO 670-53-11-047, IS 67053110002, AND ASA SP 607 AND EO700-53-0061.SDR SIMA200705806Floorbeam · corrodedFOUND STATION 280 FLOORBEAM CORRODED AND CRACKED. SPLICED IN FRAME 280 AND EXTENSION MOUNTS IAW AMERICAN EAGLE ENGINEERING ORDER CR-53MR-101. RETURNED AIRCRAFT TO SERVICE.SDR WRLA2007019Floorbeam · corrodedDURING 2C+12A+150M CHECK, EGAT MECHANIC FOUND M/D CARGO FLOORBEAM CORRODED AT STA Y=1321,X= -8 TO -25 AREA. FABRICATED THE NEW PARTS IAW E1 NR W2007P53B-056 REV. 00 AND APPROVED DOCUMENT MFG CONTROL NR PO209366. INSTALLED THE NEW FABRICATED PARTS IAW MD-11F SSDR SWAA070176Floorbeam · corrodedDURING SCHEDULED 10Y CHECK, FOUND FLOORBEAM CORRODED AT BS 328, RBL 27 TO RBL 48. REPAIRED FLOORBEAM PER SRM.SDR CALA0700013Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 986.5, LBL 43 TO RBL 43. THE FLOORBEAM WAS REPAIRED IAW ECRA 5321-01435.SDR UPS07449079Floorbeam · corrodedINSPECTION TYPE:C AFT CARGO COMPT - LEFT FLOORBEAM LOWER SURFACE FOUND SURFACE CORROSION AT STA 1820 LBL 42 TO LBL 45 ANCHOR NUT AREA. CORROSION BLEND OUT 0.041 X 2 X 3 INCHES EXCEED SRM LIMIT. AFT CARGO COMPT - LEFT FLOORBEAM REPAIRED AT BS 1820 LBL 20 TO LSDR USAA070030Floorbeam · corrodedSTATION 312 LBL 7 TO LBL 8 HAS CORROSION. ACCOMPLISHED T-CAP REPAIR IAW SRM 53-10-51, DEFECT SIZE: 1 INCH.SDR USAA070038Floorbeam · corrodedTOPSIDE OF FLOORBEAM Y1732 AT FR 66 HAS CORROSION. ACCOMPLISHED REPAIR PER SRM 53-41-14; CORR TASK JA-260-53500; LEVEL 1, DEFECT SIZE: 2 X 2 INCHES.SDR K11A2008122372310Floorbeam · corrodedMAIN DECK FLOORBEAM UPPER CHORD HAS CORROSION.SDR A6WA200740014Floorbeam · crackedFOUND LEFT FS 280 FLOOR SUPPORT CLIP, P/N 601R31113-57 CRACKED APPROX .1 INCH LONG OUTBOARD SIDE LBL 9.0. REMOVED CRACKED ANGLE. FITTED AND INSTALLED NEW ANGLE P/N 601R31113-57 IAW CRJ SRM 51-42-06, 51-42-13-51-40-11, 51-42-21 AND BSC STANDARD REPAIR 601R-53SDR UPS07448966Floorbeam · corrodedINSPECTION TYPE:C M/D BS 2040 LBL 85 FLOORBEAM FOUND CORRODED. M/D BS 2040 FLOORBEAM UPPER CHORD REPAIRED AS PER SRM 51-40-04 FIG 1 JUST BETWEEN LBL 43 AND LBL 118 LT MOST O/B.SDR DL757070046Floorbeam · corrodedTHE STA 1681.8 FLOORBEAM WAS FOUND CORRODED BEYOND SRM LIMITS AT SEVERAL LOCATIONS ON THE UPPER CAP. CUT OFF THE DAMAGED UPPER CAP AND REPLACED IT WITH A NEW TEECAP SECTION.SDR USAA070024Floorbeam · corrodedFLOORBEAM AT STATION 727 + 7 RBL8. ACCOMPLISHED DOUBLER REPAIR IAW SRM 51-10-02, 53-60-53, TR 53-10-06B DEFECT SIZE: .5"SDR USAA070023Floorbeam · corrodedFLOORBEAM AT STATION 727 + 7 RBL 3. ACCOMPLISHED DOUBLER REPAIR IAW SRM 51-10-02, 53-60-53, TR 53-10-06B DEFECT SIZE: .5"SDR SWAA070130Floorbeam · corrodedDURING SCHEDULED 22Y CHECK, FOUND FLOORBEAM CORRODED AT BS 344, RBL 5, WL 208. REMOVED AND REPLACED FLOORBEAM SECTION PER SRM.SDR UPS07848994Floorbeam · corrodedINSPECTION TYPE:C3 STA 1700 LBL 26 UNDERSIDE OF FLOORBEAM HAS CORROSION. REMOVED CORROSION, FABRICATED AND INSTALLED STRAP AND 2 EA REPAIR ANGLES IAW SRM 51-1-21 AND 53-2-0.SDR AWXA200700091Floorbeam · corrodedSAL - CORROSION ON MAIN CABIN FLOORBEAM, FR 68, -Y1162. REPLACED MAIN CABIN FLOORBEAM, FR 68 - FR 69, -Y1162 IAW A319 SRM 51-72-11.SDR AWXA200700079Floorbeam · crackedMCN - MAJOR REPAIR -E/E BAY CABIN FLOORBEAM LOWER STRAP CRACKED, BS 324, RBL 24. REPAIRED E/E BAY CABIN FLOORBEAM LOWER STRAP, BS 324, RBL 24, IAW B737-300 SRM 53-10-51-2R4, FIGURE 201, DETAIL VI.SDR CALA0700012Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT BS 325, LBL 30 TO LBL 55. THE FLOORBEAM WAS REPAIRED IAW SRM 53-00-51, REPAIR 1, FIGURE 201.SDR CALA0700010Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT BS 303, LBL 28 TO 50. THE CORROSION WAS REMOVED AND THE FLOORBEAM WAS REPAIRED IAW SRM 53-00-51, REPAIR 1, FIGURE 201.SDR USAA070016Floorbeam · corrodedAFT CARGO FLOORBEAM AT STATION 847 + 12 RBL 13 HAS CORROSION. REPAIRED IAW TR 53-10-06B, DEFECT SIZE: 4 INCHES.SDR USAA070017Floorbeam · corrodedAFT CARGO FLOOR TRACK/BEAM AT STATION 847 + 12 LBL 8 HAS CORROSION. REPAIRED IAW TR 53-10-06B, DEFECT SIZE: .5 INCH.SDR TRAX200700047Floorbeam · corrodedFOUND FLOORBEAM AT FS STA 349 LBL 45 HAS CORROSION.SDR SWAA070078Floorbeam · corrodedDURING SCHEDULED 8Y CHECK, FOUND FLOORBEAM CORRODED AT BS 986.5, RBL 26 TO RBL 42. REPAIRED FLOORBEAM PER SWA EA.SDR K11A2008122272309Floorbeam · corrodedCORROSION ON FLOORBEAM UPPER CHORD AFT SURFACE.SDR TRAX200700037Floorbeam · corrodedFOUND STA 349 TRANSVERSE BEAM CORRODED RT SIDE AT RBL 45 (MARKED). REMOVED CORROSION AND FOUND WITHIN LIMITS IAW CRJ SRM 53-21-15 AND REPLACED AFT ANGLE IAW CRJ SRM 51-42-13.SDR F3LA200700003Floorbeam · corrodedDURING C-3 CHECK, INSPECTION REPORTED CORROSION AROUND FASTENER HOLE AT FR68, RT SIDE, APPROX ONE FOOT INBD OF DOOR SKIN. BLENDED CORROSION AROUND HOLE AND FOUND INTERGRANULAR CORROSION INSIDE FASTENER HOLE THAT WAS FOUND TO BE OUT OF LIMITS IAW SRM 51-74-00.SDR SWIA200717738Floorbeam · crackedLT STA621 LOWER CORNER CRACK AT FLOOR LEVEL, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED REPAIR PARTS 601R-53-61-117 ANGLE, REPAIR ANGLE AND STRAP IAW CR200 SRM 51-23-00 AND REO 601R-53-61-117.SDR SIMA200700807Floorbeam · corrodedFOUND PREVIOUS LEFT OMEGA BEAM REPAIR CORRODED AT FRAME 20. REMOVED EXISTING REPAIR. CLEANED AND TREATED AREA. FABRICATED AND INSTALLED REPAIR FILLER AND DOUBLER IAW EMB SRM 53-00-10. RETURNED AIRCRAFT TO SERVICE.SDR CALA0700004Floorbeam · corrodedINSPECTION FOUND FLOORBEAM UPPER FLANGE CORRODED AROUND SCREW HOLES AT STA 986.5, RBL 19 TO RBL 46. THE CORRODED SECTION OF FLOORBEAM WAS CUT OUT AND A TEE REPAIR ANGLE AND STRAP WERE INSTALLED IAW ECRA 5310-04494, REPAIR OPTION B.SDR CALA0700001Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AROUND HOLE AT STA 967, RBL 30. THE CORRODED SECTION OF FLOORBEAM WAS CUT OUT AND A REPAIR SECTION WAS INSTALLED IAW SRM 53-00-51, FIGURE 201.SDR USAA07007Floorbeam · wornSTA 827 RBL 15-20 WORN. INSTALLED REPAIR ANGLES IAW SRM 51-70-12, DEFECT SIZE: .5 X .5 INCH.SDR K11A2008123072308Floorbeam · crackedFLOORBEAM HAS CRACK.SDR UPS07849074Floorbeam · crackedINSPECTION TYPE:C2 FLOORBEAM VIEWED FROM A-PIT STA 240 LBL 36 HAS A 9 INCH CRACK. REPAIRED FLOORBEAM AT STA 240 LBL 36 IAW SAA EA008-5310-01-A00586 UPS RAA DC8-53-20605-A, BAC MSG 1-271080190, AND FAA FORM 8100-9.SDR KCSA071003Floorbeam · damagedAFT PIT FLOORBEAM DAMAGED AT BS 1800, LBL 50.SDR CALA0700049Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 986.5, LBL 25.5. REPAIRED IAW SRM 53-00-51.SDR SWAA065131Floorbeam · corrodedDURING SCHEDULED 6Y CHECK, FOUND FLOORBEAM CORRODED AT BS 772, LBL 8. REPAIRED FLOORBEAM PER SWA EA.SDR CALA0600546Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 986.5, LBL 50 TO RBL 50. THE FLOORBEAM WAS REPAIRED IAW ECRA 5321-01430.SDR NWAA62895513Floorbeam · crackedDURING "M" CHECK, FOUND CRACK IN FLOORBEAM AT BS 700 LBL 45. REPAIRED PER EA 55-208669.SDR NWA602885513Floorbeam · crackedDURING "M" CHECK, FOUND CRACK IN FLOORBEAM AT BS 700 LBL 25. REPAIRED PER EA 55-208668.SDR SIMA200700805Floorbeam · corrodedLEFT OMEGA BEAM AT FRAME 20 CORRODED. REMOVED CORROSION AND INSTALLED REPAIR DOUBLER IAW EMB SRM 53-00-10. RETURNED AIRCRAFT TO SERVICE.
Back to JASC 5315