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 AALA20050697Floorbeam · corrodedAFW FLOORBEAM AT STATION 325 HAS CORROSION REMOVED ON UPPER AND LOWER SURFACE BEYOND SRM LIMITS. AREA IS 1.0 INCH BY .021 INCH AT RT BUTTLINE 16, 1.1 BY .040 AT RT BUTTLINE 19.5, 1.2 BY .045 INCH AT RT BUTTLINE 25.5 AND 2.0 BY .021 INCH AT RT BUTTLINE 54 WITSDR AALA20050696Floorbeam · corrodedFLOORBEAM AT STATION 347 HAS CORROSION REMOVED ON UPPER AND LOWER SURFACE BEYOND SRM LIMITS. AREA IS 1.0 BY .027 INCH AT RT BUTTLINE 26, 1.2 BY .033 INCH AT RIGHT BUTTLINE 33, 1.1 BY .036 INCH AT RIGHT BUTTLINE 36 AND 1.0 BY .048 INCH AT RIGHT BUTTLINE 37. DESDR AALA20050592Floorbeam · corrodedAFW FLOORBEAM AT STATION 764 HAS CORROSION REMOVAL BEYOND SRM LIMITS. AREA WAS 1.0 INCH BY .030 INCH WITH A DEPTH OF .030 INCH. FABRICATED REPAIR STRAP FROM 301 AND A HALF HARD STAINLESS STEEL .063 THICK. ALODINED ALL BARE ALUMINUM SURFACES. FINISHED BLENSDR SWAA052606Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND FUSELAGE FLOORBEAM CORRODED AT BS 986, LBL 46. REPAIRED FLOORBEAM PER BFG ER.SDR DHL2005806512Floorbeam · corrodedAFT CARGO COMPT FLOORBEAM UPPER FLANGE CORRODED STA 1320.000 RBL 40 (MAJOR REPAIR). PERFORMED MAJOR REPAIR IAW DC8 SRM 51-2-1 FIG 1 SHEET 9-12, TR 51-130. REMOVED FASTENERS IAW SRM 51-1-20D. REMOVED CORROSION ON FLOORBEAM UPPER FLANGE STA 1320 RBL 40 IAW SRSDR UPS05245436Floorbeam · corrodedINSPECTION TYPE:C SURFACE CORRSION AT BS 1130 JOINT BETWEEN FLOORBEAM TOP AND CREASE WEB AT RBL 62. REPAIR PARTS FABRICATED IAW AAAE EO 2005-081-003 - UPS ENG FILE 72 7-53-20189. DOUBLER INSTALLED IAW SRM 51-30-02.SDR 05FDEA02696Floorbeam · damagedAFT CABIN, AFTER REMOVAL OF CORRODED SEAT TRACK, FLOORBEAM WEB UPPER CHORD AT STA 1828 LBL 27.5, FOUND EXTRA HOLE CLOSE TO EDGE AS MARKED. REMOVED AND REPLACED FROM S1464579-7075T6511 AS PER DRAWING AGA 7070.SDR UPS05545376Floorbeam · corrodedINSPECTION TYPE:C MAIN CARGO BAY FLOORBEAM CORRODED BS 620 LBL 4-10. REPAIR PER SRM 51-20-06 AND ER 05-3962.SDR USAA051058Floorbeam · corrodedFLOOR SUPPORT Y1732 AT FRAME 66. INSTALLED REPAIR DOUBLERS PER ASRM 53-41-14, DEFECT SIZE: 1 INCH DIA.SDR USAA051059Floorbeam · corrodedRT FLOORBEAM OF FRAME 20 FLOORBEAM 1292. DEFECTIVE PART REPLACED WITH IDENT PART PER SRM 51-72-11, DEFECT SIZE: .5 X 10.SDR USAA051061Floorbeam · corrodedFROM 3 INCHES FWD OF FS 66 TO 5 INCHES FWD OF FS 68 IN Y1292 BEAM. DEFECTIVE PART REPLACED WITH IDENTICAL PART DEFECT SIZE: 3 X 1.5, 4 X 1.5, 1 X 1, .5 X 1, .5 X 1.SDR CALA0500282Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 986.5, RBL 9 TO RBL 45. REPAIRED IAW ECRA 5321-01273.SDR 2005UALA00879Floorbeam · corrodedFLOORBEAM AT BS 324 IS CORRODED FROM THE CIRCUMFERENTIAL FRAME TO THE SPLICE AT RBL 50, AND THE T-CAP. FABED REPAIR PARTS PER SRM 53-00-51, ALODINE, PRIME, AND PAINT. INSTALL REPAIR PARTS PER MM 53-00-98.SDR DU4R0508184Floorbeam · damagedFLOORBEAM AT BS 480 HAS SEVERAL ELONGATED HOLES FORM OB SEAT TRACK TO CREASEBEAM.SDR 180Floorbeam · corrodedCORROSION ON CABIN FLOORBEAM BS 365 RBL 73.SDR DU4R0508179Floorbeam · gougedTOP OF FLOORBEAM IS GOUGED AT STA 1400 LBL 51 WL 208.1. S/O 283002, N/R 23803.SDR ASAA0540429Floorbeam · corrodedCORROSION ON FLOORBEAM. REMOVED TOP SECTION OF FLOORBEAM, FABRICATED AND INSTALLED REPAIR PARTS AND INSTALLED. (K)SDR ASAA0540425Floorbeam · corrodedCORROSION ON FLOORBEAM BSTA 947.5, LBL 16, RBL 16, WL 208. REPAIRED FLOORBEAM IAW SRM AND EA. (K)SDR DHL2005806511Floorbeam · corrodedAFT CARGO COMPT FLOORBEAM LWR FLANGE CORRODED, STA 1240.000 RBL 30" (MAJOR REPAIR). PERFORMED MAJOR REPAIR IAW SRM 51-2-1 FIG 1 SHEET 9, TR 51-130. REMOVED FASTENERS IAW SRM 51-1-20D. REMOVED CORROSION FROM FLOORBEAM LWR FLANGE, STA 1240.000 RBL 30" IAW SRMSDR 2005UALA00869Floorbeam · corrodedCABIN FLOOR, STA 294.5 LBL 7, FLOORBEAM UPPER SURFACE, CORROSION.SDR 2005UALA00867Floorbeam · corrodedCABIN FLOORBEAM TOP CORRODED IN SEVERAL PLACES.SDR SWAA052530Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FLOORBEAM TEE CORRODED AT BS 270, LBL 11 TO RBL 11. REMOVED AND REPLACED FLOORBEAM T-CHORD PER SRM.SDR SWAA052529Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FLOORBEAM CORRODED AT BS 312, LBL 1.0. REPAIRED FLOORBEAM PER SRM.SDR CALA0500275Floorbeam · corrodedINSPECTION FOUND CABIN FLOORBEAM CORRODED AT STA 360, LBL 8. REPAIRED IAW ECRA 5321-01277.SDR ASOA05677Floorbeam · crackedDURING A C-CHECK IN MCN, THE FLOORBEAM AT FS 584, LBL 9 WAS FOUND TO BE CRACKED BEYOND LIMITS. MAINTENANCE IS REPAIRING THE FLOORBEAM AT S 584, LBL 9 IAW CRJ200 SRM 53-00-43. (M)SDR 05FDEA02541Floorbeam · damagedAFT CARGO COMPARTMENT, STA 1841 LOWER FRAME FLOORBEAM SKIN FOUND DAMAGED AS MARKED. AFT CARGO COMPARTMENT, LOWER FRAME FLOORBEAM WEB AT STA 1841, REMOVED AS PER SRM 51-33-01 AND 51-35-01 VOL II. NEW WEB FABRICATED AS PER DRAWING AGA 7170 AND NEW WEB INSTALSDR 05FDEA02506Floorbeam · damagedAFT CARGO COMPARTMENT STA 1841 LOWER FRAME FLOORBEAM WEB FOUND DAMAGED, AS MARKED. REMOVED AS PER SRM 51-33-01 AND 51-35-01 VOL II. NEW WEB FABRICATED AS PER DRAWING AGA 7170 AND NEW WEB INSTALLED AS PER SRM 51-33-01 AND 51-35-01 VOL II. MINOR REPAIR AS PESDR GTIA050247Floorbeam · corrodedLEFT COCKPIT ENTRY WAY FLOORBEAM HAS AREAS OF CORROSION. AREAS OF CORROSION FOUND OUT OF LIMITS. FABRICATED ENTRY WAY FLOORBEAM. TREATED, PRIMED AND INSTALLED FABRICATED FLOORBEAM. (M)SDR USAA051024Floorbeam · corrodedBFM - Q2 - FLOORBEAM UPPER CHORD, 50 INCH CORROSION; NO LEVEL OR TASK; FS 986.5, LBL 0 TO LBL 50 INCH. FABED PART FLOORBEAM UPPER CHORD, INSTALLED IAW SRM. (K)SDR USAA051018Floorbeam · corrodedPIT - S1 - BEAM CORROSION; LEVEL 1; TASK JA-220-53500, C20-Y1292. REPLACED BEAM IAW SRM. (K)SDR USAA051017Floorbeam · corrodedPIT - S1 - FLOORBEAM, .5 INCH X .7500 INCH X 1 INCH SQ. CORROSION; LEVEL; TASK JA-260-53500, FRAME 67 Y117MM. REMOVED AND REPLACED WITH SAME PN. (K)SDR USAA051016Floorbeam · corrodedPIT - S1 - FLOORBEAM, 1 INCH X 1 INCH CORROSION; LEVEL 2; TASK JA260-53500, FRAME 68-69, Y120MM. REMOVED AND REPLACED FLOORBEAM WITH SAME PN. (K)SDR USAA051014Floorbeam · corrodedPIT - S2 - FLOORBEAM, 2 INCH X 6 INCH CORROSION, LEVEL 2; TASK JA-220-53500, 9 INCHES RT OF CENTER FROM FRAME C16 TO C21. REPLACED IAW SRM. (K)SDR ASAA0540411Floorbeam · corrodedCORROSION ON FLOORBEAM BSTA 1076, RBL 25-30, WL 208. BLENDED CORROSION, DETERMINED TO BE OUT OF LIMITS, REPAIRED FLOORBEAM IAW SRM. (K)SDR ASAA0540402Floorbeam · corrodedCORROSION ON FLOORBEAM. REPAIRED IAW SRM. (K)SDR UPS05845369Floorbeam · crackedINSPECTION TYPE:C1 FLOORBEAM CRACKED AT FS 55 LBL 12. CUT OUT DAMAGED AREA OF FLOORBEAM IAW SRM 53-2-0 TEMP REV 53-152, FABRICATED DOUBLER AND FILLER AND INSTALLED REPAIR PARTS IAW SRM 53-2-0 TEMP REV 53-152 AND 51-1-20D.SDR CALA0500266Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 720, RBL 48.5 TO RBL 60. A REPAIR WAS INSTALLED IAW SRM 53-00-01, FIGURE 201.SDR SWAA052447Floorbeam · corrodedDURING SCHEDULED 5Y CHECK, FOUND LONGITUDINAL FLOORBEAMS CORRODED AT BS 727D, LBL 3 & BS 772 TO BS 774, LBL 17. REPAIRED FLOORBEAMS PER SWA EA.SDR 05FDEA02453Floorbeam · crackedMAIN CARGO DECK FLOORBEAM STA 312 LBL 32 SUPPORT IS CRACKED. REMOVED AND REPLACED SUPPORT IAW SRM 51-30-2.SDR 05FDEA02452Floorbeam · unknownEVALUATE TO DETERMINE IF REPAIR IS MAJOR OR MINOR AND IF REPAIR IS IN ACCORDANCE WITH FAA APPROVED DATA, (FLOORBEAM REPAIR AT BS 380, RBL 52-63). EMOVED EXISTING REPAIR B/S 380 RBL 52-63 FABRICATED & INSTALLED NEW REPAIR IAW FED EX SR DRW 52-034E THIS IS A SDR 05FDEA02441Floorbeam · unknownREPAIR ON FLOORBEAM AT STA 1130 BL 0 THRU RBL 18, PREVIOUS REPAIR AT STA 1130 , BL 0 TO RBL 18 NEEDS ENG EVALUATION TO DETERMINE IF MAJOR OR MINOR AND IF REPAIR IS IAW FAA APPROVED DATA. NO ENGINEERING NEEDED. THE REPAIR IS WAS INSTALLED IAW SRM 53-10-8 ANDSDR GTIA050245Floorbeam · corrodedFOUND LEFT FLOORBEAM IN FRONT OF L1 DOOR CORRODED. MEASURED CORRODED AREAS, FOUND OUT OF LIMITS. MANUFACTURED FLOORBEAM. TREATED, PRIMED AND INSTALLED FLOORBEAM. (M)SDR GTIA050246Floorbeam · corrodedFTW - FOUND FLOORBEAM LEFT OF DOT 204 HAS SEVERAL AREAS OF CORROSION. FLOORBEAM CORROSION FOUND OUT OF LIMITS. MANUFACTURED FLOORBEAM. TREATED, PRIMED AND INSTALLED FLOORBEAM. (M)SDR 2005UALA00804Stiffener · crackedFWD NOSE SECTION, BS 246 FLOORBEAM, FWD SIDE APPROX LBL 17, VERTICAL STIFFENER CRACKED. ROUTINE INSPECTION IN PLACE TO FIND AND FIX THESE CRACKED STIFFENERS. THIS IS A KNOWN ISSUE ADDRESSED BY BOEING SERVICE BULLETIN AND UA MAINTENANCE PROGRAM.SDR SWAA052407Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND FUSELAGE FLOORBEAM CORRODED AT BS 986, BETWEEN LBL 52 TO RBL 52. REPAIRED FLOORBEAM PER BFG ER.SDR CALA0500262Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 986.5, LBL 35 TO RBL 35. THE FLOORBEAM WAS REPAIRED IAW ECRA 5321-01268.SDR 05FDEA02431Floorbeam · corrodedPREVIOUS REPAIR AT STA 1070 BL 0 TO RBL 65 ON FLOORBEAM IS IAW SRM 53-10-8 AND IS A MAJOR REPAIR.SDR 05FDEA02426Floorbeam · damagedFLOORBEAM WEB DAMAGED AT BS 328, LBL 31, WL 207. REPAIRED DAMAGED FLOOR BEAM WEB PER SRM 51-10-1, 53-10-1, 51-40-2SDR 05FDEA02432Floorbeam · corrodedPREVIOUS REPAIR AT STA 1050 FLOORBEAM AT BL 0 IS IAW SRZ 27-53-034E AND IS A MAJOR REPAIR.SDR C2XA05SH99Floorbeam · corrodedSHV - DURING C-CHECK CENTER OMEGA BEAM HAS CORROSION AT FR 61. MAINTENANCE REPAIRED THE CENTER OMEGA BEAM AT FR 61 IAW EC 5320-01255. THE AIRCRAFT WAS APPROVED TO RETURNED FOR SERVICE.
Back to JASC 5315