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 QXEA200601051Floorbeam · corrodedYYC - C4 FUSELAGE INTERIOR FORWARD STATION 222, LBL9 FLOORBEAM IS CORRODED AROUND BOLT HOLE. REPAIRED IAW DHC-8-200 SRM 51-40-11.SDR AMTA200600237Floorbeam · corrodedCABIN FLOORBEAM LWR SURFACE AT RBL 80, FS 923, HAS SURFACE CORROSION. CLEANED CORROSION AND FOUND BEYOND NEGLIGIBLE DAMAGE LIMITS IAW SRM. REPAIRED LWR FLANGE OF CABIN FLO OR BEAM FS 923, RBL 80, IAW SRM. (K)SDR ASAA0610349Floorbeam · corrodedFOUND FLOORBEAM CORRODED. REPAIRED CORRODED FLOORBEAM PER EA 5310 02589.SDR ASAA0610347Floorbeam · maint errorFOUND FLOORBEAM HAS DOUBLE DRILLED HOLES. REPAIRED FLOORBEAM WITH FABRICATED REPAIR PART.SDR 061072Floorbeam · corrodedFOUND MAIN DECK FLOORBEAM SPLICE CORRODED AT BS 520, LBL63.SDR 061071Floorbeam · damagedFOUND MAIN DECK FLOORBEAM WEB DAMAGED AT BS 480, LBL20 TO LBL 90. FLOORBEAM REPAIRED IAW B747 SRM 53-10-07 FIG 18.SDR 061070Floorbeam · damagedFOUND MAIN DECK FLOORBEAM UPPER CAP HAS HOLE DAMAGE AT BS 960, LBL 48.5.SDR 061069Floorbeam · corrodedFOUND UPPER DECK FLOORBEAM FRAME CORRODED AT BS 460, RBL 85.SDR CALA0600100Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 303, LBL 5 TO LBL 32. REPAIRED IAW SRM 53-00-51, REPAIR 1, FIGURE 201.SDR 06FDEA1272Floorbeam · corrodedMAIN DECK FLOORBEAM AT STA 620 BETWEEN LBL 45 TO RBL 24.5 HAS CORROSION. REMOVED DAMAGED FLOORBEAM IAW SR 27-53-034, FABRICATED FILLER PLATE, ANGLES, BRACKET AND FLOORBEAM IAW SR 27-53-034, REINSTALLED ALL REPAIR PARTS IAW SRM 51-30-2 AND SR 27-53-034, REPAIRSDR DU4R2006309Floorbeam · corrodedCORROSION NOTED ON CABIN FLOORBEAM BS 365 0 RBL 0 TO RBL 24. FABRICATED AND INSTALLED REPAIR ANGLE 22-1/4" FROM 7075-T6 .063 IAW B757 SRM 53-30-51 AND 51-20-01.SDR 06FDEA1271Floorbeam · corrodedMAIN DECK FLOORBEAM AT STA 560, LBL 62 TO RBL 24.5 HAS CORROSION, AFTER CORROSION REMOVAL FOUND OUT OF LIMITS. REMOVED FLOORBEAM IAW SRM 51-30-2 AND SRZ 27-53-034, FABRICATED FLOORBEAM SECTION IAW SR 27-53-034 AND REINSTALLED ALL REPAIR PARTS IAW SRM 51-30-2,SDR 06FDEA1269Floorbeam · damagedAFT CARGO BAY BS 1130 FLOORBEAM VERTICAL WEB CUT INTO A BL 0 VERTICAL ATTACH BRACKET. REPAIRED PER FED EX EA 7-5310-99474.SDR ASAA0610304Floorbeam · corrodedFOUND FLOORBEAM CORRODED. REPAIRED FLOORBEAM IAW EA 5310 02602 AND ERO 5606.SDR ASAA0610300Floorbeam · corrodedFLOORBEAM CAP CORRODED. REPAIRED FLOORBEAM CAP PER EA 5310 032374.SDR ASAA0610292Floorbeam · corrodedFLOORBEAM CORRODED. REPAIRED FLOORBEAM PER SRM 51-30-12 AND EA 5310 02601.SDR ASAA0610290Floorbeam · corrodedFOUND FLOORBEAM CAP CORRODED. REPAIRED AFT CABIN FLOOR BEAM CAP IAW EA 5310 02232.SDR QXEA200601047Floorbeam · corrodedYYC - C4 FORWARD BAGGAGE COMPARTMENT SUB FLOOR STRUCTURE AT FUSELAGE STATION X597 SPAN WISE ANGLE FOR FLOORBOARD ATTACHMENT HAS THREE AREAS OF SURFACE CORROSION AROUND THREE ANCHOR NUTS AT STATION Y6LH, Y21LH. REPAIRED IAW DHC-8-200 SRM 51-40-11, PAGES 1-4.SDR 061049Floorbeam · corrodedFWD PIT FLOORBEAM CORRODED AT BS 900, LBL 50 TO LBL 60.SDR AWXA200600664Floorbeam · corrodedGYR - DURING C12 CHECK DISCOVERED LEVEL 2 GALVANIC CORROSION ON THE MAIN CABIN FLOORBEAM UPPER EDGE AT BS 365 FROM BL 15R TO BL 35R. CORROSION WAS FOUND TO BE OUT OF LIMITS IAW BOEING 757-200 SRM 53-00-51-2A. MAINTENANCE CUT OUT AND REMOVED DAMAGED AREA IAWSDR AWXA200600652Floorbeam · crackedMCN - DURING C11 CHECK DISCOVERED FLOOR STRAP CHANNEL CRACKED, 2.0 INCHES, ON BOTTOM OF CABIN FLOORBEAM AT BS 390, BL 25L, WL 201.5. MAINTENANCE REMOVED DAMAGED SECTION OF STRAP CHANNEL AT BS 390, BL 25L, WL 201.5 IAW BOEING 757-200 SRM 51-40-02-OG. FABRICATSDR CALA0600097Floorbeam · corrodedINSPECTION FOUND FORWARD CARGO FLOORBEAM FORWARD FACE CORRODED AT STA 500D, LBL 14. THE FLOORBEAM WAS REPAIRED IAW SRM 53-00-07, PAGE 203, FIGURE 201.SDR AWXA200600616Floorbeam · corrodedGYR - DURING C12 CHECK DISCOVERED LEVEL 2 GALVANIC CORROSION ON FLOORBEAM AT BS 740 FROM BL 45.5R TO BL 55.5R, WL 208. MAINTENANCE CUT OUT DAMAGED AREA AT BS 740 BL 45.5R IAW SRM 53-00-51-2R. CORROSION FOUND TO BE OUT OF SRM LIMITS. FABRICATED REPAIR ANGLESDR GTIA200600029Floorbeam · corrodedFWD PIT CEILING FLOORBEAM CORRODED STA 256 RBL 4-12. REMOVED CORRODED FLOOR SUPPORT AND MADE NEW SUPPORT.SDR AWXA200600535Floorbeam · corrodedSAL - MAJOR REPAIR - DURING BC4 CHECK DISCOVERED LEVEL 2 EXFOLIATION CORROSION AROUND TWO FASTENERS HOLES LOCATED AT Y-1292 FR67+17"AND FR68. CORROSION WAS FOUND OUT OF LIMITS AND BEAM WAS REPLACED FROM FR 67+15" TO FR 69+4" IAW AIRBUS 319 SRM 51-72-11 AND 51SDR USAA060518Floorbeam · corrodedY495 AT FRAME 14 CORRODED. DEFECTIVE PART REPLACED WITH IDENT PART PER SRM 51-42-11; CORR TASK JA-220-53500; LEVEL 1, DEFECT SIZE: 1 INCH DIA.SDR USAA060520Floorbeam · corrodedY1292 BETWEEN FRAME 68 & 69 CORRODED. DEFECTIVE PART REPLACED WITH IDENT PART PER SRM 51-42-11; CORR TASK JA-260-53500; LEVEL 2, DEFECT SIZE: .5"L X .5"W X .070"D.SDR USAA060521Floorbeam · corrodedY1292, FRAME 68 CORRODED. DEFECTIVE PART REPLACED WITH IDENT PART PER SRM 51-42-11; CORR TASK JA-260-53500; LEVEL 2, DEFECT SIZE: .5"L X .5"W X .060"D.SDR USAA060522Floorbeam · corrodedY1292 FRAME 66 CORRODED. DEFECTIVE PART REPLACED WITH IDENT PART PER SRM 51-42-11; CORR TASK JA-260-53500; LEVEL 2, DEFECT SIZE: .5"L X 1"W X .080"D.SDR AWXA200600752Floorbeam · crackedDURING C12 CHECK DISCOVERED FLOORBEAM CRACKED IN TWO PLACES AT BS 700, ONE CRACK AT BL 24R AND THE OTHER AT BL 46R. EACH CRACK WAS APPROXIMATELY 1 INCH LONG. MAINTENANCE CUT OUT DAMAGED AREA. FABRICATED SUPPORT ANGLES, REINFORCEMENT STRAPS, AND FILLER IAW ASDR KCSA061027Floorbeam · corrodedFWD CARGO PIT FLOORBEAM UPPER CHORD CORRODED AT BS 900, LBL 50 TO LBL 60.SDR KCSA061026Floorbeam · corrodedMAIN DECK FLOORBEAM CORRODED AT BS 480 LBL 36 TO LBL 93.SDR KCSA061024Floorbeam · damagedMAIN DECK FLOORBEAM WEB DAMAGED AT BS 500, RBL 78. REPAIRED WEB IAW B747 SRM 53-10-07 FIG 11.SDR SWAA061017Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND COCKPIT FLOOR Z-CHORD CORRODED AT BS 270, BETWEEN LBL 10 TO RBL 10, WL 208. REMOVED AND REPLACED Z-CHORD PER SRM.SDR SWAA061016Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FLOORBEAM CORRODED AT BS 344, LBL 12, WL 208. REPAIRED FLOORBEAM PER SRM.SDR 061018Floorbeam · damagedAFT LOWER CARGO COMPARTMENT FLOORBEAM AT BS 1520 UPPER CHORD DAMAGED/BENT AT RBL 24.SDR DU4R2006345Floorbeam · crackedCRACK IN CABIN FLOOR SUPPORT BS 760 RBL 1. REMOVED AND REPLACED FLOOR SUPPORT WITH IAW B727 SRM 51-30-2 AND 51-30-5.SDR SWAA060998Floorbeam · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FLOORBEAM CRACKED AT BS 947, LBL 53, WL 208. REPAIRED FLOORBEAM PER BFG ER.SDR SWAA060990Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FLOORBEAM CORRODED AT BS 947, RBL 48, WL 208. REPAIRED FLOORBEAM PER BFG ER.SDR USAA060503Floorbeam · corrodedSTA 400 RBL 10-24 CORROSION. REPLACED WITH NEW PART PER SRM 53-00-51, 51-40-02, 51-40-05, DEFECT SIZE: 3"L X 8"W X .012"D.SDR USAA060474Floorbeam · corrodedCABIN FLOOR STA 365, RBL 49-56, RBL 63-66 CORROSION. FAB REPLACEMENT CHORD, NEW SPLICE ANGLES & NEW SPLICE STRAPS PER EA 97460; CORR TASK C53-222-03, DEFECT SIZE: 2"L X 2"W X .021"D, 7"L X 2"W X .022"D; 3"L X 2"W X .015"D.SDR USAA060475Floorbeam · corrodedSTA 1640 RBL 65 - LBL 65 CORROSION. FAB'D T-CHORD, FILLERS, INSTALLED PARTS PER EA 97440; CORR TASK C53-251-02, LEVEL 1, DEFECT SIZE: 2"L X 1.5"W X .025"D, 2"L X 7"W X .015"D, 2.5"L X 1.6"W X .025D, 27"L X 2"W X .2.SDR USAA060476Floorbeam · corrodedSTA 324 RBL 45-65; CORR TASK C53-221-03, LEVEL 1. FAB NEW PARTS & INSTALLED PER EA 97745, DEFECT SIZE: 3"L X 2"W X .019"D.SDR USAA060485Floorbeam · corrodedCABIN FLOOR STA 1661 BL 0 CORROSION. FAB NEW UPPER T-CHORD, ANGLES SPLICE & SPLICE STRAPS PER TYP REPAIR 53-15-01; CORR TASK C53-251-02, DEFECT SIZE: 5.7"L X 2"W X .025"D.SDR UPS06446541Floorbeam · crackedBS 2060 RBL 98 FLOOR SUPPORT BRACKET FOUND CRACK, CRACK LENGTH 0.75". SUPPORT BRACKET REPLACED AS PER SRM 51-10-01 PG 9 AND INSTALLED AS PER SRM 51-30-02.SDR 061012Floorbeam · damagedFOUND MAIN DECK FLOORBEAM WEB DAMAGED AT BS 280 LBL10. WEB REPAIRED IAW B747 SRM 51-40-02 FIG 1.SDR USAA060468Floorbeam · corrodedFLOORBEAM Y-765 STA 16-24; CORR LEVEL 1; TASK JA-220-53500. REMOVED & REPLACED PER SRM 51-72-11, DEFECT SIZE: .25" X .25".SDR USAA060469Floorbeam · corrodedFLOORBEAM BETWEEN FR 68 & 66 CORROSION. REMOVED & REPLACED PER SRM 51-72-11; CORR LEVEL 1; TASK JA-260-53500 DEFECT SIZE: 2" X 6'.SDR USAA060470Floorbeam · corrodedBEAM AT -Y1160 AT FR 68 CORROSION. REMOVED & REPLACED PER SRM 51-72-11; CORR LEVEL 1; TASK JA-260-53500, DEFECT SIZE: 2" X 4'.SDR MALA060183Floorbeam · corrodedDURING 2 YEAR CHECK IN BNA, FOUND FLOOR FLANGE AT FS 258 IS CORRODED OUT OF LIMITS. THE FLANGE HAS BEEN REMOVED AND A NEW PART FABRICATED PER SAMPLE IAW SRM 51-20-20 AND INSTALLED IAW SRM 51-40-21. REF: EAMS WORK ORDER 213643 TASK 1513.
Back to JASC 5315