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 ASAA0771610Floorbeam · corrodedFLOORBEAM AT STA 950 IS CORRODED REPAIRED IAW 51 40 02.SDR IXXA07SMN154SFloorbeam · corrodedDURING ROUTINE C CHECK INSPECTION, FOUND MAIN CARGO COMPARTMENT FLOORBEAM WEB CORRODED AT STATION 960.000 RT BOTTOM LINE 40". REMOVED FASTENERS AS NEEDED TO PERFORM REPAIR, REMOVED CORROSION. FOUND OUT OF LIMIT. FABRICATE REPAIR ANGLES OF EXTRUSION. CLEANESDR DL76S070470Floorbeam · corrodedFWD CARGO COMPT FLOORBEAM CHORD FOUND CORROSION AT STA 434 RBL44 AND WAS REPAIRED ON SRM 53-00-07 FIG 201 REPAIR SCHEME ON NR 520726.SDR DL76S070469Floorbeam · corrodedFWD CARGO COMPT FLOORBEAM CHORD CORRODED AT STA 456 RBL 44 AND REPAIRED PER 53-00-07 FIG 201 ON NR 52071SDR F3LA200700090Floorbeam · corrodedDURING C-3 CHECK, INSPECTION REPORTED CORROSION AROUND NUT PLATE HOLE ON FLOORBEAM -Y1292, AFT OF FR68. REPLACED FLOORBEAM AT FR68 STATION -Y1292 IAW SRM 51-42-11.SDR F3LA200700088Floorbeam · corrodedDURING C-3 CHECK, INSPECTION REPORTED CORROSION AROUND NUT PLATE HOLE ON FLOORBEAM Y1292 FWD OF FR68. REPLACED FLOORBEAM AT Y1292 FWD OF FR68 IAW SRM 51-42-11, FIG 6 AND 7.SDR F3LA200700087Floorbeam · corrodedDURING C-3 CHECK, INSPECTION REPORTED CORROSION AROUND NUT PLATE ON FLOORBEAM Y1292, AFT OF FR66. REPLACED FLOORBEAM AT Y1292 AFT OF FR66 IAW SRM 51-42-11, FIG 6 AND 7.SDR F3LA200700089Floorbeam · corrodedDURING C-3 CHECK, INSPECTION REPORTED CORROSION AROUND NUT PLATE HOLE ON FLOORBEAM Y1292 AFT OF FR68. REPLACED FLOORBEAM AT Y1292 AFT OF FR68 IAW 51-42-11, FIG 6 AND 7.SDR AWXA200700527Floorbeam · corrodedSAL - FOUND CORROSION ON MAIN CABIN FLOORBEAM, FR 66 + 6" TO FR 70, -Y765. REPLACED MAIN CABIN FLOORBEAM, FR 66 + 6" TO FR 70, -Y765 IAW A320 SRM 51-72-11.SDR PIDA07020Floorbeam · corrodedDURING MAINTENANCE CHECK, NOTED CORROSION ON UPPER CHORD OF BS 312 FLOORBEAM FROM BL 0 TO LBL 12. REPLACED SECTION OF TEE CAP PER SRM 53-10-9 FIGURE 5.SDR ASAA0771600Floorbeam · corrodedFLOORBEAM AT STA 344 UPPER FLANGE CORRODED REPAIRED IAW 5310 02716.SDR ASAA0741581Floorbeam · corrodedCORROSION ON FLOORBEAM. REPAIRED CORRODED FLOORBEAM IAW EA 5310 02713.SDR DL76S070477Floorbeam · corrodedCABIN BS 325, 20 TO 25 FLOORBEAM UPPER SURFACE FOUND CORRODED REPAIRED ON NR 51553.SDR 2007UALA01228Floorbeam · corrodedRT MAIN CABIN FLOORBEAM, UPPER CHORD HAS CORROSION BEYOND LIMITS, BS 1640, BETWEEN LBL10 TO RBL 87. [SUP 05-04-07] MAJOR REPAIR ACCOMPLISHED: REMOVED DAMAGED CHORD. FABRICATED & INSTALLED NEW CHORD.SDR SWAA071952Floorbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND FLOORBEAM CRACKED AT BS 947, LBL 55. REPAIRED FLOORBEAM PER ER.SDR CPCP20070029Floorbeam · corrodedFLOORBEAM 39 UPPER AND LOWER SURFACE CORRODED. FLOORBEAM 39 REPLACED AS PER SRM 51-25-01.SDR CPCP20070028Floorbeam · corrodedFLOORBEAM 36 CORRODED ON UPPER AND LOWER SURFACE. NEW FLOORBEAM 36 INSTALLED IAW SRM 51-25-01.SDR SIMA200712825Floorbeam · corrodedSTA 280 FLOORBEAM CORRODED ALONG TOP FLANGE. SPLICED IN NEW STA 280 FLOOR BEAM AND EXTENTION MOUNTS IAW AMERICAN EAGLE ENGINEERING ORDER CR-53MR-119. RETURNED AIRCRAFT TO SERVICE.SDR DL76S070471Floorbeam · corrodedCABIN BS RBL 15 TO 40 FLOOR BEAM FOUND CORRODED, REPAIRED ON NR 51179 PER 53-00-01 FIG 101.SDR SWAA071919Floorbeam · corrodedDURING SCHEDULED 22Y CHECK, FOUND FLOORBEAM UPPER CHORD CORRODED AT BS 967, LBL 26 TO RBL 43. REMOVED AND REPLACED UPPER CHORD PER SRM.SDR USAA070283Floorbeam · corrodedFOUND CORROSION FWD OF L4 DOOR SILL AT FRAME 66. CUT OUT DAMAGED AREA AND FABRICATED FILLER PER SRM 53-41-14; CORROSION TASK JA-260-53500; LEVEL 1 DEFECT SIZE: 1/2" DIA.SDR DHL2007806577Floorbeam · corrodedITEM REF. NR. 049960: AFT CARGO COMPT FLOORBEAM SUPPORT FITTING CORRODED, STA 1220.000 RBL 50". REMOVED CORROSION IAW SRM 51-1-8 PG 17-18. FOUND OUT OF LIMITS IAW SRM 53-2-0 PG 2P. REMOVED CORRODED FITTING IAW SRM 51-1-20D. FABRICATED NEW FITTING (AL7075"0SDR DL76L070376Floorbeam · corrodedFOUND DURING HMV IN GSO, MAIN CABIN FLOORBEAM HAS CORROSION GS 1483 LBL 1 - LBL 45. REPAIRED FLOORBEAM IAW SRM 53-00-51D FIG 201. WORK ACCOMPLISHED ON N/R 24135.SDR 2007UALA01213Floorbeam · corrodedMAIN CABIN TEE CAP AT STA 324 IS CORRODED. [06-14-07] MAJOR REPAIR ACCOMPLISHED. REMOVED DAMAGED SECTION OF T-CAP, MOST OUTBOARD 14 IN. RBL. FABRICATED PER UA ENGINEERING SPECIFICATIONS AND INSTALLED NEW REPAIR.SDR CALA0700182Floorbeam · corrodedFLOOR SUPPORT CORRODED AT BS 325, LBL 53-55. REPAIRED IAW SRM 53-00-51 FIG 201, REPAIR 1.SDR CALA0700180Floorbeam · corrodedFLOOR SUPPORT CORRODED AT BS 325 LBL 53-55. REPAIRED IAW SRM 53-00-51 FIG 201, REPAIR 1.SDR SWIA200718289Floorbeam · crackedFS 280 SUPPORT BEAM IS CRACKED AT FITTINGS ON LEFT AND RIGHT BUTT LINE 9, DISCOVERED AT C-CHECK. INSTALLED FS 280 BEAM PER REO 670-53-11-047. INSTALLED COCKPIT FLOOR SUPPORT BEAM PN CC670-33292-13 PER CRJ700 SRM 51-42-06.SDR DHL2007806600Floorbeam · corrodedMAIN CARGO COMPT FLOORBEAM CORRODED STA 55.000 RBL 54 (FLOORBEAM SEGMENT) MAJOR REPAIR. REMOVED CORROSION IAW SRM 51-1-8 PG 17-18. FOUND OUT OF LIMITS IAW SRM 53-2-0 PG 2P. REMOVED CORRODED FLOORBEAM IAW SRM 51-1-20D. FABRICATED NEW FLOOR (EXTRUSION P/N S2SDR AWXA200700506Floorbeam · corrodedSAL - FOUND CORROSION ON CABIN FLOORBEAM, FR 66 + 7", -Y1292. REPLACED CABIN FLOORBEAM, FR 66 - FR 68, -Y1292 IAW A320 SRM 51-72-11.SDR DHL2007782503Floorbeam · crackedCABIN FLOOR PANEL SUPPORT AT BS 760, BETWEEN LBL 44 AND LBL 66, IS CRACKED AT I/B ENDS. REMOVED FLOOR SUPPORT, FABRICATED REPAIR ANGLES FROM 7075-T6, .032" BY 6" BY 2" (2 EA.), PO NR 9004042, PER B727 SRM 51-10-3 AND 51-40-3 FIG 1. TREATED, PRIMED, AND INSTASDR MASA200700233Floorbeam · crackedFLOOR SUPPORT ANGLE AT FS 621 RT IS CRACKED. REPAIRED ANGLE.SDR 07FDEA01466Floorbeam · corrodedCORRODED TOP CAP FLOORBEAM AT C33 LT. REPAIR PERFORMED BY SPLICING IAW SRM 53-10-15 / FIG.207.SDR DU4R2007105Floorbeam · corrodedFOUND CORROSION AT FWD CABIN FLOORBEAM UPPER SURFACE BS 324 B/O RBL 50. REPAIRED BY REMOVING CORRODED T CAP, FABRICATED AND INSTALLED NEW T CAP 72 BY 3 BY 2 FROM AND10136-2409 EXTRUSION IAW B757 SRM 51-40-05, AND 53-10-08D.SDR 07FDEA01418Floorbeam · corrodedHEAVY CORROSION ON THE TOP CAP BEAM AT C24 LT. TOP CAP BEAM REPAIR PERFORMED IAW SRM 53-10-15 / FIG 207 AND SRM 51-72-10.SDR C2XA07SH018Floorbeam · corrodedSHV - DURING C-CHECK MAINTENANCE FOUND SURFACE CORROSION ON THE LEFT HAND OMEGA BEAM UNDER THE CARBON FIBER CROSS BEAM AND THE SURROUNDING AREAS. MAINTENANCE REPAIRED THE LEFT HAND OMEGA BEAM AT FRAME 20 IAW EMB 145XR SRM 53-00-10 FIG 201 SHEET 2. AIRCRAFT WSDR 07FDEA01395Floorbeam · corrodedCORROSION ON TOP CAP BEAM UPPER FLANGE LT AT C38 AND C38.1. REPAIR PERFORMED IAW 53-10-15/FIG 207 AND SRM 51-72-10.SDR 07FDEA01392Floorbeam · corrodedFOUND CORROSION ON TOP CAP BEAM (UPPER FLANGE) AT C33. REPAIR PERFORMED BY REPLACEMENT IAW SRM 51-72-10.SDR AWXA200700499Floorbeam · crackedMCN - CRACKED FLOORBEAM STRAP, BS 328, RBL 36, WL 200. REPAIRED FLOORBEAM STRAP, BS 328, RBL 36, WL 200 IAW B737-300 SRM 53-10-51-2R4 FIGURE 201.SDR F3LA200700072Floorbeam · corrodedDURING C4/S1 CHECK, INSPECTION REPORTED CORROSION IN AND AROUND FASTENER HOLES WHERE FLOORBEAM Y1292 ATTACHES TO FR68. REMOVED AND REPLACED FLOORBEAM ASSY. IAW A319 SRM 51-42-11.SDR USAA070269Floorbeam · corrodedFLOORBEAM AT Y476.4 FR 16 HAS CORROSION. REMOVED AND REPLACED FLOORBEAM PER SRM 51-72-11; CORR LEVEL 1; TASK JA-220-53500, DEFECT SIZE: 2 SQ INCHES.SDR KCSA071135Floorbeam · damagedUPPER DECK FLOORBEAM AT STA 460 HAS DOUBLE DRILLED HOLE LBL 53 WL 308.SDR SWIA200718279Floorbeam · crackedFS 280 FLOORBEAM UPPER ANGLE IS CRACKED AT RBL9, DISCOVERED AT C-CHECK. INSTALLED REPAIR PARTS AND CLIPS IAW CRJ200 REO 601R-53-11-137 STEP 7 & 8.SDR SIMA200710703Floorbeam · corrodedGALLEY FLOOR DIGITAL FOUND CORRODED. PERFORMED CUTOUT OF CORRODED AREA. REPLACED CORRODED AREA IAW EMB SRM 53-21-10, FIGURE 201. RETURNED AIRCRAFT TO SERVICE.SDR DU4R2007117Floorbeam · corrodedFOUND CORROSION ON FLOORBEAM UPPER TEE CAP AT BS 377 AND LBL 19. REPAIRED BY CUTTING OUT CORRODED AREA, FABRICATED AND INSTALLED REPAIR TEE CAP 13 BY 2 BY 2 BY 2-1/2 FROM BAC1505-100617, REPAIR L-ANGLE 11 BY ½ BY 2 FROM BAC 1490-6199 7075-T6 .063 AND 13 BY SDR SIMA200709914Floorbeam · corrodedLEFT OMEGA BEAM CORRODED AT FRAME 20. PERFORMED CUTOUT FOR CORROSION, FABRICATED AND INSTALLED REPAIR PARTS IAW EMB SRM 53-00-10. RETURNED AIRCRAFT TO SERVICE.SDR SIMA200709913Floorbeam · corrodedCENTER OMEGA BEAM CORRODED AT FRAME 33. PERFORMED CUTOUT OF CORROSION, FABRICATED AND INSTALLED REPAIR PARTS IAW EMB SRM 53-00-10, FIGURE 203. RETURNED AIRCRAFT TO SERVICE.SDR SWIA200718219Floorbeam · crackedFS 280 FLOOR SUPPORT BEAM HAS CRACKED UPPER SUPPORT ANGLE AT LBL9/RBL9 AND ALL FOUR CLIPS ARE CRACKED, DISCOVERED AT C-CHECK. REPLACED FILLER ANGLE, SPLICE ANGLES AND CLIPS AT STA280 LBL9/RBL9.SDR SIMA200709912Floorbeam · corrodedLEFT OMEGA BEAM CORRODED AT FRAME 20. PERFORM CUTOUT OF CORROSION, FABRICATED AND INSTALLED REPAIR PARTS IAW EMB SRM 53-00-10. RETURNED AIRCRAFT TO SERVICE.SDR DL76G070304Floorbeam · corrodedAFT CARGO COMPARTMENT STA 1197+44 RBL 22.5 FLOORBEAM AFT FACE UNDERSIDE CORRODED AND REPAIRED PER SRM 53-00-07 REPAIR 4 FIG 201 DETAIL V.SDR DL76G070303Floorbeam · corrodedAFT COMPARTMENT STA 1197 RBL 23 TO 29 FLOORBEAM FWD OF AFT UNDER SIDE CORRODED AND REPAIRED PER SRM53-00--7 FIG 201 REPAIR 4 DETAIL V.
Back to JASC 5315