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 0601033Floorbeam · corrodedREPAIRED FUSELAGE MAIN CARGO CABIN FLOOR BEAM UPPER CHORD DUE TO CORROSION.SDR 0601032Floorbeam · corrodedREPAIRED FUSELAGE MAIN CARGO CABIN FLOORBEAM UPPER CHORD DUE TO CORROSION.SDR 0601042Floorbeam · corrodedREPAIRED MAIN CARGO CABIN TRANSVERSAL BEAM DUE TO CORROSION.SDR 0601045Floorbeam · corrodedREPAIRED FUSELAGE MAIN CARGO CABIN FLOORBEAM WEB AND REPLACED PRODUCTION DOUBLER DUE TO CORROSION.SDR ASOA06018Floorbeam · corrodedDURING A C-CHECK, CORROSION WAS FOUND ON THE TRANSVERSE FLOORBEAM CAP AT FS559.112, RBL27-45. THIS MRR WILL REMAIN OPEN PENDING MAINTENANCE DETERMINATION OF THE APPROPRIATE CORRECTIVE ACTION. (K)SDR 06FDEA0062Floorbeam · gougedFOUND GOUGED AFT SIDE OF BS 880 FLOORBEAM AT RBL 47 WL 204. REPAIRED PER FED EX E.A. 7-5310-96540.SDR 06FDEA0060Floorbeam · corrodedFOUND CORROSION ON FLOORBEAM UPPER FLANGE AROUND NUTPLATES AT BS 1130, LBL 10 TO RBL 29, WL 208. REPAIRED FLOORBEAM UPPER FLANGE BS1130, RBL 10, WL 208 IAW SRM 53-10-8.SDR PIDR2006023Floorbeam · corrodedBS 986.5 FLOORBEAM CORRODED AT A PREVIOUS REPAIR FROM RBL14 TO RBL18. REPLACED UPPER T CAP OF FLOORBEAM IAW EA NR 53-264.SDR AWXA200600611Floorbeam · corrodedGYR - DURING C08 CHECK DISCOVERED LEVEL 2 GALVANIC CORROSION ON LOWER SURFACE OF FLOORBEAM UPPER CHORD AT BS 1681 BL 53R. MAINTENANCE REMOVED CORROSION IAW 757-200 SRM 53-00-51. REWORK FOUND OUT OF SRM LIMITS. REPAIRED FLOORBEAM AT BS 1681 FROM BL 47R TO 55SDR IXXA06SMN017SFloorbeam · corrodedDURING ROUTINE C-CHECK INSPECTION, AFT CARGO COMPT - FLOORBEAM UPPER FLANGE CORRODED; STA 1500.000 RBL 42 - RBL 50. PERFORMED MAJOR REPAIR IAW DC8 SRM 51-2-1 FIG 1 (SHEET 9), TR 51-130 DATED 01-26-04. REMOVED FASTENERS IAW DC8 SRM 51-1-21. REMOVED DAMAGED SSDR IXXA06SMN016SFloorbeam · corrodedDURING C CHECK INSPECT, AFT CARGO COMPT BEAM FLOOR WEB CORRODED , STA 1440.000 RBL 45. PERFORMED MAJOR REPAIR IAW DC8 SRM 51-2-1 FIG 1 (SHEET 2, 12), TR 51-130 DATED 01-26-04. REMOVED FASTENERS IAW DC8 SRM 51-1-20D. REMOVED CORROSION IAW DC8 SRM 51-1-8 PG SDR ASOA06013Floorbeam · crackedDURING A C-CHECK, THE FS280 FLOOR SUPPORT ANGLE, OB OF LBL9, AT ALTERNATE GEAR EXTENSION PULLEY, WAS FOUND TO BE CRACKED BEYOND LIMITS. MAINTENEANCE REMOVED AND REPLACED THE FS280 FLOOR SUPPORT ANGLE, OB OF LBL9, AT ALTERNATE GEAR EXTENSION PULLEY, IAW REO 60SDR AWXA200600612Floorbeam · corrodedGYR - DURING C08 CHECK DISCOVERED LEVEL 2 GALVANIC CORROSION ON FLOORBEAM AT BS 1681 ON LOWER SURFACE OF UPPER CHORD BL 48R TO BL 48L AT WL 208. MAINTENANCE FOUND CORROSION REWORK OUT OF LIMITS. FABRICATED REPAIR ANGLE IAW AWA ER 19-5365-06084-DF1. INSTALLESDR UPS06445946Floorbeam · crackedINSPECTION TYPE:C U/D BS 340 FLOORBEAM UPPER CHORD HORIZONTAL AFT FLANGE 6 FLOOR PNL ATTACH HOLES FOUND CRACKED BETWEEN RBL 10" - RBL 45" (CRACK LENGTH 0.060" ). U/D BS 340 RBL 3" TO RBL 50" FLOORBEAM UPPER CHORD HORIZONTAL AFT FLANGE CRACK HOLES REPAIRED AS SDR UPS06445945Floorbeam · crackedU/D BS 340 FLOORBEAM UPPER CHORD HORIZONTAL AFT FLANGE 1 FLOOR PANEL ATTACHED HOLE FOUND CRACKED AT LBL 48". U/D BS 340 LBL 41" TO LBL 53" FLOORBEAM UPPER CHORD HORIZONTAL AFT FLANGE CRACK HOLE REPAIRED AS PER EO NR B747-5320-12407 FIG 3 PLAN 'C'.SDR UPS06445938Floorbeam · crackedINSPECTION TYPE:C U/D BS 380 FLOORBEAM UPPER CHORD FWD HORIZONATAL FLANGE 1EA FLOOR PANEL ATT HOLE FOUND CRACKED, CRACK LENGTH 0.060". U/D BS 380 RBL 61" TO RBL 71" FLOORBEAM UPPER CHORD FWD HORIZONATAL FLANGE REPAIRED AS PER EO NR B747-5320-12407 FIG 3 PLAN SDR UPS06445935Floorbeam · damagedINSPECTION TYPE:C COCKPIT BS 340 LBL 49" LBL 55" AND LBL 61" FLOORBEAM UPPER CHORD AFT FLANGE ANCHOR NUT SHORT EDGE MARGIN. COCKPIT BS 340 LBL 41" TO LBL 64" FLOORBEAM UPPER CHORD AFT FLANGE REPAIRED AS PER EO NR B747-5320-12407 FIG 2 PLAN B.SDR UPS06445933Floorbeam · damagedINSPECTION TYPE:C COCKPIT BS 340 RBL 61" FLOORBEAM UPPER CHORD AFT FLANGE ANCHOR NUT HOLE FOUND SHORT EDGE MARGIN. COCKPIT BS 340 RBL 56 TO RBL 64 FLOORBEAM UPPER CHORD AFT FLANGE REPAIRED AS PER EO NR B747-5320-12407 FIG 2 PLAN B.SDR UPS06445932Floorbeam · damagedINSPECTION TYPE:C COCKPIT BS 380 LBL 66" LBL 72" FLOORBEAM UPPER CHORD AFT FLANGE FOUND SHORT EDGE MARGIN, ANCHOR NUT HOLES. COCKPIT BS 380 LBL 61" - LBL 75" FLOORBEAM UPPER CHORD AFT FLANGE REPAIRED AS PER EO NR B747-5320-12407 FIG 2 PLAN B.SDR SWIA200616365Floorbeam · crackedFS 280 - CROSSMEMBER SUPPORT ANGLE IS CRACKED AT (2) PLACES - RBL 3 & RBL 9 IN THE UPPER AFT RADIUS - WL 71. ITEM FOUND AT C-CHECK INSPECTION. INSTALLED CLIPS AND REPAIR PARTS AT FS 280 APPROX LBL 11 - RBL 11 IAW REO 601R-53-11-136.SDR UPS06445937Floorbeam · corrodedINSPECTION TYPE:C U/D BS 400 RBL 40" - RBL 68" FLOORBEAM UPPER CHORD ANCHOR NUTS AREA FOUND CORROSION. CORROSION BLEND OUT 0.055" BY 2" BY 2" EXCEED SRM 53-10-01 FIG 1 LIMITS, U/D BS 400 RBL 33 TO MOST RT O/B FLOORBEAM UPPER CHORD REPAIRED IAW SRM 53-10-07 FISDR UPS06445936Floorbeam · corrodedINSPECTION TYPE:C COCKPIT BS 360 LBL 12" - LBL 34" FLOORBEAM UPPER CHORD FOUND CORROSION. CORROSION BLEND OUT 0.065" BY 2" BY 3" EXCEED SRM 53-10-01 FIG 1 LIMITS, COCKPIT BS 360 LBL 4" TO LBL 42" FLOORBEAM UPPER CHORD REPAIRED IAW SRM 53-10-07 FIG 23.SDR UPS06445934Floorbeam · scoredINSPECTION TYPE:C COCKPIT BS 360 RBL 50" - RBL 54" FLOORBEAM UPPER CHORD SEVERAL SCORE MARK. COCKPIT BS 360 RBL 42" TO RBL 62" FLOORBEAM UPPER CHORD REPAIRED IAW SRM 53-10-07 FIG 23.SDR 06FDEA0012Floorbeam · corrodedFOUND CORROSION, STA 344 LBL 50 TO RBL 15 WL 208 CORROSION ON FLOORBEAM UPPER CHORD. REMOVED DAMAGED SECTION OF UPPER CHORD, FABRICATED AND INSTALLED REPAIR PER SRM 53-10-8.SDR 06FDEA0002Floorbeam · corrodedFOUND CORROSION ON FLOORBEAM LOWER FLANGE BS 1070 LBL 44- RBL 44 WL 201. REPAIRED FLOOR BEAM LWR FLANGE BS 1070 LBL 44 - RBL 44 WL 201 IAW SR27-53-034 REPAIR NR 8, AND SRM 51-30-2.SDR KCSA061559Floorbeam · damagedAFT PIT FLOORBEAM DAMAGED AT BS 1800, LBL 50.SDR SIMA200600507Floorbeam · corrodedTHE GALLEY FORWARD DIGITAL WAS FOUND TO BE CORRODED. REMOVED THE CORROSION BY MAKING CUT OUT. FABRICATED A DOUBLER. REPAIR DONE IAW SRM. (K)SDR QXEA200600054Floorbeam · corrodedPDX - BAG COMPARTMENT FORWARD FLOOR BOARD AFT SUPPORT ANGLE CORROSION APPROIMATELY STATION X799.0 AT YR27.0. REPAIRED IAW DHC-8-200 SRM 51-20-11 AND SRM 51-20-16.SDR ASAA0540766Floorbeam · corrodedPAE- CORROSION ON TOP CHORD OF FLOOR BEAM. REPAIRED FLOOR BEAM IAW SRM. (K)SDR USAA051669Floorbeam · corrodedFLOORBEAM Y765 AT FR 66 CORRODED. REMOVED & REPLACED FLOORBEAM PER SRM 51-42-21, DEFECT SIZE: 1 X 1 INCH.SDR USAA051657Floorbeam · corrodedAT 1732L AND FR 66 CORROSION. DEFECTIVE PART REPLACED WITH IDENT PART PER SRM 53-41-14; CORROSION LEVEL 1; TASK JA216053500, DEFECT SIZE: .25 X .25 INCH.SDR CALA0500461Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT BS 325, LBL 28 TO LBL 60. THE FLOORBEAM WAS REPAIRED IAW SRM 53-00-51, FIGURE 201, REPAIR 1.SDR CALA0500458Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT BS 303, LBL 19 TO LBL 32. REPAIRED IAW SRM 53-00-51, FIGURE 201, REPAIR 1.SDR CALA0500455Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 947.5, BETWEEN LBL 12 AND RBL 18. A NEW FLOORBEAM WAS INSTALLED IAW ECRA 5311-01246.SDR 05FDEA04419Floorbeam · corrodedFOUND CORROSION IB FLOORBEAM LOWER FLANGE BS 1130 LBL 44-RBL 44 WL 201. REPAIRED FLOORBEAM LOWER CHORD BS 12130 RBL 44 TO LBL 44 IAW SRM 51-10-2.SDR 2006AP01001Floorbeam · crackedNOSE WHEELWELL, BS 400, RBL 8, RETRACT ARM FAIRING, LWR ANGLE, CRACK LT WING GEAR FWD TRUN BRG HSG SUPT STRUCT IB FITTING MTG BOLT 2ND, UPR SHEARED OFF LT MLG W/W, BS 1241 LBL 1 VERT BEAM W/EXPO, CORROSION/CRACKED. R1 MED INTL STRUCT BET BEAM NR1,2, 14 INCH FSDR SWIA200516397Floorbeam · crackedFUSELAGE, UPPER FLOORBEAM IS CRACKED, FS 280.00, LBL 11.0. (ITEM FOUND AT C-CHECK INSPECTION.) REPAIRED IAW CRJ REO 601R-53-11-138 REV NC.SDR SWIA200516396Floorbeam · crackedFUSELAGE, LOWER FLOORBEAM IS CRACKED, FS 280.0, LBL 11.0, ITEM FOUND AT C-CHECK INSPECTION. REPAIRED IAW CRJ REO 601R-53-11-171 REV C.SDR SWIA200516395Floorbeam · crackedFUSELAGE, LOWER FLOORBEAM IS CRACKED, FS 280.00, RBL 11.0, ITEM FOUND AT C-CHECK INSPECTION. REPAIRED IAW CRJ REO 601R-53-11-171 REV C.SDR SWIA200516392Floorbeam · crackedCARGO COMPARTMENT FS 621 LT FLOORBEAM CRACKED LBL 42, ITEM FOUND AT C-CHECK INSPECTION. FLOORBEAM REPAIRED IAW CRJ REO 601R-53-61-117 REV "C".SDR AWXA200600121Floorbeam · corrodedMCN - DURING C19 CHECK DISCOVERED CORROSION ON BS 1016 FLOORBEAM FROM BL 17R TO BL 17L, WL 208. MAINTENANCE REMOVED DAMAGED AREA AND FOUND CORROSION TO BE OUT OF LIMITS IAW BOEING 737-300 SRM 53-60-15-1A1 FIG 101. FABRICATED REPAIR STRAPS IAW BOEING 737-300 SDR SWIA200516430Floorbeam · crackedCARGO COMPT, FS 605.00 TRANSVERSE BEAM ATTACH ANGLE FOR LANDING PLATE STOP FITTINGS CRACKED, ITEM FOUND AT C CHECK INSPECTION. REPLACED ANGLE IAW CRJ SRM 51-40-11, 51-42-06, 51-42-13, 51-42-21, 51-41-02 AND 51-41-04.SDR SWIA200516424Floorbeam · crackedCARGO PIT, FS 589.00 TRANSVERSE BEAM ATTACH ANGLE CRACKED AT CARGO DOOR LANDING PLATE, ITEM FOUND AT C CHECK INSPECTION. REPLACED ANGLE IAW CRJ SRM 51-40-11, 51-42-06, 51-42-13, 51-42-21, 51-41-02, 51-41-04.SDR AWXA200600029Floorbeam · corrodedSAL - DURING BC4 CHECK DISCOVERED CORROSION ON FLOORBEAM LOCATED AT FR 16 AND Y503.2. RE-WORK AREA WAS FOUND TO BE OUT OF LIMITS IAW AIRBUS 319 SRM 53-11-14. MAINTENANCE REMOVED AND INSTALLED NEW FLOORBEAM FROM FR 12 TO FR 16 AND Y503.2 IAW AIRBUS 319 SRM 51SDR AWXA200600028Floorbeam · corrodedSAL - DURING BC4 CHECK DISCOVERED CORROSION ON FLOORBEAM LOCATED AT FR 66+8" AND Y-1292. RE-WORK AREA WAS FOUND TO BE OUT OF LIMITS IAW AIRBUS 319 SRM 53-00-14. MAINTENANCE REMOVED AND INSTALLED NEW FLOORBEAM FROM FR 67 TO FS 68 AND Y-1292 IAW AIRBUS 319 SRSDR AWXA200600027Floorbeam · corrodedSAL - DURING BC4 CHECK DISCOVERED CORROSION ON FLOORBEAM LOCATED AT FR 68 AND Y-1162. RE-WORK AREA WAS FOUND TO BE OUT OF LIMITS IAW AIRBUS 319 SRM 53-00-14. MAINTENANCE REMOVED AND INSTALLED NEW FLOORBEAM FROM FR 68 TO FR 69 AND Y-1162 IAW AIRBUS 319 SRM 51SDR 05FDEA04400Floorbeam · misrepairedAFT CARGO COMPT AT STA 1902 FOUND 1 FLOORBEAM REPAIRED FROM X 55 LT TO X -55 RT AT Z-83 WITH 1 SPLICE AND 1 WEB. STRIPPED AREA IAW SRM 51-21-01 PAR 33 VOL 2. PERFORMED INSPECTION AND REPORTED VALUE ON ATTACHED SHEET. PERFORMED CONDUCTIVITY INSPECTION REPORTSDR 05FDEA04397Repair · misinstalledREPAIR ON MAIN DECK FLOORBEAM UPPER FLANGE BS 480, LBL 5 TO RBL 24. REQUIRES EVALUATION FOR MAJOR/MINOR DETERMINATION AND IF THE REPAIR WAS ACCOMPLISHED USING FAA APPROVED DATA. REPAIR EVALUATED TO NOT BE IAW SRM 53-10-8. REMOVED AND REPLACED REPAIR IAW SDR 05FDEA04390Floorbeam · misrepairedEVALUATED FLOORBEAM REPAIR AT BS 560 RBL 10 FOUND NOT TO BE DONE IAW SRM 53-10-8. REPAIRED FLOORBEAM IAW SRM 53-10-8 FIG 3.SDR 05FDEA04396Floorbeam · crackedFOUND STA BS1179, 3 EACH ELONGATED NUTPLATE FASTENER HOLES; LBL 2 IS ELONGATED AND CRACKED, AND RBL 3.5 AND RBL 10.5 ARE ELONGATED. COMPLIED WITH FEDEX EA# 7-5321-92600 "FUSELAGE FLOOR CHORD AT STA BS 1179 HAS DAMAGED FLANGE - REPAIR ".
Back to JASC 5315