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 FDEA200905151674Floorbeam · damagedFLOORBEAM AT BS 1661, REQUIRES REMOVE AND REPLACEMENT DUE TO EXISTING REPAIRS. REMOVED WEB AT BS 1661-1681, AND FLOORBEAM BS 1661, LBL 63-RBL 63, IAW SRM 51-40-02. ANODIZED NEW FLOORBEAM PER DWG 146N5110. FABRICATED NEW FLOORBEAM PER DWG 146N5110. LOCATED SDR DLM88090858Floorbeam · corrodedFLOOR SUPPORT AT STATION 155 RBL 50 CORRODED OUT OF LIMITS. REPAIRED REPLACEMENT PER 53-10 AND 51-10-04 ON NR 246891.SDR ASOA200900551Floorbeam · corrodedFLT DECK FLOOR SUPPORT ANGLE AT FS 280 CORRODED. REMOVED FLT DECK FLOOR SUPPORT ANGLE IAW SRM 51-42-21. INSTALLED FLT DECK SUPPORT ANGLE IAW SRM 51-42-06, 51-42-21.SDR ASOA200900548Floorbeam · corrodedFS 280 FLOOR SUPPORT CROSSBEAM CORRODED AT LBL9 AND RBL9. ALL WORK DONE IAW REO 670-53-11-047.SDR FDEA200905141661Floorbeam · corrodedMAIN CABIN FLOORBEAM BS 440, RBL 45-65, TOP CHORD IS CORRODED AROUND FASTENERS HOLES. REMOVED CORROSION IAW SRM 51-10-01. FOUND OUT OF LIMITS PER SRM 53-00-51, DETAIL 3. REMOVED DAMAGED SECTION IAW SRM 53-00-51. FABBED NEW TEE. FABRICATED REPAIR ANGLES ANSDR FDEA200905131638Floorbeam · failedEXISTING PATCH REPAIR FOUND ON CABIN FLOORBEAM UPPER TEE AT BS 324 BETWEEN RBL 13 AND RBL 70. EVALUATE AND REPAIR AS NECESSARY. EXISTING REPAIR EVALUATED IAW ATTACHMENT "B" OF EO F-5100-7-5001 PT.1 AND FOUND PREVIOUSLY ACCOMPLISHED BY NON-ROUTINE CARD SEQUENSDR CALA2009051900264Floorbeam · corrodedB757-53-3-0427 MAIN CABIN FLOOR, CORROSION ON FLOORBEAM AT STA 715 RBL 27, ABOVE AND BELOW FASTENER HOLE. DUPLICATE L/P CREATED FOR SCEPTRE AND ESFR REPORTING ONLY, DUE TO REV A OF ECRA. ECRA THAT WAS REVISED IS EC/RA 5310-04943 REV A. ALL WORK ACCOMPLISHEDSDR ASAA0995632Floorbeam · corrodedFWD CARGO BAY FLOOR TRACK BEAM IS CORRODED BEYOND LIMITS. REMOVED FABRICATED AND INSTALLED PER SRM 53-00-53.SDR SWAA093190Floorbeam · corrodedDURING SCHEDULED 10Y CHECK, FOUND FLOORBEAM CORRODED AT BS 772, RBL 3. REPAIRED BEAM PER SWA EA.SDR SWAA093189Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND FLOORBEAM CHORD CRACKED BETWEEN BS 316 TO BS 321, STR 17L. REPAIRED BEAM PER SRM.SDR SWAA093188Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND FLOORBEAM CRACKED AT BS 663, BL 0, WL 201. REPAIRED BEAM PER SI.SDR SWAA093187Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND FLOORBEAM CRACKED AT BS 677, BL 0, WL 206. REPAIRED BEAM PER SI.SDR SWAA093186Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED BETWEEN BS 664 TO BS 667, BBL 0. REPAIRED BEAM PER SI.SDR SWIA200922122Floorbeam · crackedFS 280 FLOORBEAM CRACKED AND CORRODED. (C CHECK) REPAIRED PER REO AND SRM.SDR USAA2009052991336Floorbeam · corrodedSAL - C19 - MAJOR REPAIR - NR 6201895 - CORROSION ON FLOOR SUPPORT BEAM BETWEEN BS986.5 TO BS1006 & ALSO BETWEEN RBL9 TO RBL20. REPLACED FLOOR SUPPORT BEAM BETWEEN BS986.5 TO BS1006 & ALSO BETWEEN RBL9 TO RBL20 IAW B737 SRM 51-10-02 & BOEING DRAWING 65-46812SDR AALA20090521TUL18Floorbeam · corrodedCABIN FLOORBEAM CORRODED STATION 967 LEFT BODYLINE 16. INSTALLED DOUBLER PER AARD 53-00-00-7.SDR CALA2009051900260Intercostal · crackedB737-53-3-0737 SUPPORT CHANNEL BETWEEN FLOORBEAM STA 274.5-294.5 AT BL 0 HAS A CRACK AT FASTENER HOLES. REMOVED AND REPLACED INTERCOSTAL REF SRM 51-40-02 PAR 7.SDR FDEA200905121636Floorbeam · corrodedMCD FLOORBEAM AT STA 365, BETWEEN RBL25 AND RBL 70, HAS CORROSION. REMOVED DAMAGE SECTION IAW SRM 53-00-51. FABRICATED NEW CHORD MAT BAC1505-100617/20. INSTALLED REPAIR PARTS AND CHORD IAW SRM 53-00-51, AT STA 365, LBL14- RBL70. REPAIR NR 3 AND CATEGORY A,SDR USAA2009051391167Floorbeam · corrodedPIT - C8 - MAJOR REPAIR - INTERGRANULAR CORROSION ON FLOORBEAM AT FR16, S23L, Y495. REPLACED FLOORBEAM AT FR16, S23L, Y495 IAW A320 SRM 51-42-11.SDR USAA2009051391166Floorbeam · corrodedPIT - C8 - MAJOR REPAIR - GALVANIC CORROSION ON FLOORBEAM AT FR66, Y1292. REPLACED FLOORBEAM AT FR66, Y1292 IAW A320 SRM 51-72-11.SDR SWAA093109Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND FLOORBEAM LOWER CHORD CRACKED AT BS 663, RBL 24. REPAIRED BEAM PER AAR EA.SDR FDEA200905121623Floorbeam · crackedWING CENTER SECTION OVERWING FLOORBEAM TEE FITTING CRACKED BS 760.9 RBL45. REMOVED TEE FITTING IAW SRM 51-30-2. FABRICATED NEW TEE FITTING IAW SRM 51-30- 5 AND PF SRM 53-10-2 FIG 7A. LOCATED, DRILLED, TREATED, AND PRIMED NEW FITTING IAW SRM 51-30-5 AND 51-1SDR FDEA200905121622Floorbeam · crackedWING CENTER SECTION OVERWING FLOORBEAM TEE CRACKED BS 760.9 LBL 45. REMOVED CRACKED TEE IAW SRM 51-30-2, FABRICATED NEW ANGLE IAW SRM 53-10-2 FIG 7 AND 51-30-5, TREATED AND PRIMED NEW TEE IAW SRM 51-10-2, INSTALLED NEW TEE IAW SRM 53-10-2 AND 51-30-2SDR AALA20090521TUL17Floorbeam · corrodedCABIN FLOORBEAM CORRODED AT UPPER FLANGE STATION 986.5 RIGHT BODYLINE 23 AND RIGHT BODYLINE 29.SDR AALA20090521TUL16Floorbeam · corrodedCABIN FLOORBEAM CORRODED AT UPPER FLANGE STATION 986.5 RIGHT BODYLINE 4. REMOVED CORROSION AND INSTALLED DOUBLER PER AARD 53-00-00-8.SDR ASAA0995553Floorbeam · corrodedFOUND CORROSION ON BS 947.5 FLOORBEAM AFT FLANGE RBL 57 WL 208. REPAIRED PER ER-09-2614-EA-900-53EA-01395.SDR FDEA200905091598Floorbeam · corrodedFLOORBEAM HAS PITTING CORROSION STA 312 LBL45.SDR USAA2009052991340Floorbeam · corrodedSAL - C21 - MAJOR REPAIR - NR 6201747 - GALVANIC CORROSION ON FLOOR BEAM AT BS986.5, RBL39. REPAIRED FLOORBEAM AT BS986.5, RBL39 IAW B737 SRM 53-00-51.SDR ASAA0995556Floorbeam · corrodedCORROSION FLOORBEAM BS 947 LBL 4 TO RBL 4 CORROSION AND PITTING IN UPPER FLANGE AROUND NUT PLATE HOLES. REPAIRED PER ER 09-2614-EA-900-53EA-01395.SDR ASAA0995554Floorbeam · corrodedCORROSION FOUND ON FLOORBEAM STA 947 RBL 53 AND WL 208 FLOOR PANEL HOLE. REPAIRED PER ER 09-2614-EA-900-53EA-01395.SDR FDEA200905081583Floorbeam · corrodedFLOORBEAM AT BS 1320, RBL 24 -45, IS CORRODED ON UPPER CAP AT BS 1320, BETWEEN RBL 24 -45, FLOORBEAM REPAIR WAS ACCOMPLISHED, DUE TO DISCREPANCY EFFECTING THE PTF CONVERSION, ON MAE W/C NR 118350519EZ2R01, AND MAE EA 757-5365-16-F1992, REV A, DATED 04/30/2009.SDR DLM88090958Floorbeam · crackedMAIN CABIN FS 200 RBL 5-LBL 5 FLOORBEAM CRACKED. REPLACED SAME.SDR DLM88090957Floorbeam · corrodedMAIN CABIN FS 180 LBL 16-LBL 36 FLOORBEAM CORRODED. REPLACED FLOOR SUPPORT.SDR ASAA0945519Strap · crackedFLOORBEAM STABILIZATION STRAP CRACKED STA 328 RBL 0 WL 200. REPAIRED STABILIZATION STRAP STA 328 RBL 0 WL 200.SDR ASAA0945518Strap · crackedFLOORBEAM STABILIZATION STRAP CRACKED STA 328 RBL 46 WL 200. REPAIRED STABILIZATION STRAP STA 328 RBL 46 WL 200.SDR ASOA200900520Floorbeam · corrodedFLT DECK FLOOR SUPPORT ANGLE AT FS 280 CORRODED (16064/PG 57).SDR 2009FA0000379Floorbeam · corrodedOUT OF LIMITS CORROSION FOUND ON FLOORBEAM UPPER CHORD AT BS 986.5 RBL26-30, LOWER SURFACE AROUND CLIPNUT HOLES DURING 10 YEAR CHECK. ORIGINAL MATERIAL THICKNESS .150, MATERIAL LOSS .070, BEAM IS LOCATED IN LAV/GALLEY "WET" AREA.SDR 2009FA0000378Floorbeam · corrodedOUT OF LIMITS CORROSION FOUND ON FLOORBEAM UPPER CHORD SURFACE AT BS 847 LBL4-RBL12 DURING 10 YEAR CHECK. ORIGINAL MATERIAL THICKNESS .150, MATERIAL LOSS .080. BEAM IS LOCATED IN LAV/GALLEY "WET" AREA.SDR USAA2009051291162Floorbeam · corrodedPIT - C8 - MAJOR REPAIR - EXFOLIATION CORROSION ON FLOORBEAM AT FR68, Y765. REPLACED FLOORBEAM AT FR68, Y765 IAW A320 SRM 51-71-11.SDR ASAA0995464Floorbeam · corrodedCORROSION FWD CARGO BAY FLOORBEAM SURFACE BS 500K+1 RBL 13 CORRODED AT NUT CLIP. REMOVED DAMAGED SECTION AND REPLACED WITH REPAIR PARTS.SDR 2009FA0000352Floorbeam · corrodedCORROSION ON FLOORBEAM UPPER CHORD UPPER SURFACE BS 947 LBL 4-RBL 12. REPAIRED FLOORBEAM UPPER CHORD UPPER SURFACE BS 947, LBL4-RBL 12 IAW SRM 53-00-51 FIG 203.SDR TRBACPCP20090014Floorbeam · corrodedFLOORBEAM HAS CORROSION AROUND SCREWS HOLES AT FRAME 33 FROM LT TO RT SIDE. REMOVED, FABRICATED AND INSTALLED NEW FLOORBEAM IAW SRM NR 51-21-42, NR 51-10-10, NR 51-21-14, NR 51-71-31 AND DWG NR 13853372411.SDR IPXA09556153Floorbeam · corrodedINSPECTION TYPE:C3 CORROSION MAIN CABIN FLOORBEAM UPPER CHORD BS 1200 LBL 62 TO RBL 62, WL 208. REMOVED CORROSION AND REPAIRED PER ATS ER 09-2707 DATED 27MAY09.SDR ASAA0995456Floorbeam · corrodedBS 986.5 FLOORBEAM CORRODED IN SEVERAL AREAS ON UPPER FLANGES WL 208.1. REPAIRED FLOORBEAM.SDR CALA2009050500234Floorbeam · corrodedFWD ENTRY FLOORBEAM HAS CORROSION AT SCREW HOLES STATION 328, RBL 25-40. INSTALLED ONE FLANGE ANGLE REPAIR PER SRM 53-00-51 REPAIR 1.SDR SWAA092809Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND LONGITUDINAL FLOORBEAM WEB CRACKED BETWEEN BS 698 TO BS 717, BBL 0.07. REPAIRED BEAM PER SI.SDR SWAA092775Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND CENTER LONGITUDINAL FLOORBEAM CRACKED AT BS 707. REPAIRED BEAM PER SI.SDR A6WA200940246Floorbeam · crackedMWC 135102-29 - CROSSBEAM AT FS 280.00, RBL 9.0, WL 70.00 IS CRACKED IN THE LOWER RADIUS. CROSSBEAM AT FS 280.00, RBL 9.0, WL 70.00. REPAIRED IAW REO 601R-53-11-171, REV D SCHEME B. (K)SDR AALA20090520TUL09Web · corrodedCORROSION ON WEB ABOVE FLOORBEAM STATION 1680 LEFT BODYLINE 48 TO 52. INSTALLED DOUBLER PER SRM 53-60-51-2R2.SDR AALA20090520TUL07Floorbeam · corrodedCORROSION ON FLOORBEAM STATION 1680 LEFT BODYLINE 4-5 AT SCREW HOLE FORWARD SIDE. INSTALLED DOUBLER PER AARD 53-60-51-5 REFERENCE EA B757-53-006144.
Back to JASC 5315