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 IPXA10559466Floorbeam · corrodedINSPECTION TYPE:C4, BS1200 FLOORBEAM HAS CORROSION ON UPPER SURFACE OF UPPER FLANGE AT SEVERAL NUTPLATE LOCATIONS, LBL24 TO RBL50 WL208.1. (MARKED) REMOVED CORROSION IAW SRM 51-10-02, FOUND AREAS TO BE OUT OF LIMITS, FABRICATED REPAIR AND INSTALLED IAW REPAISDR IPXA10559355Floorbeam · corrodedINSPECTION TYPE:C4 WHILE WORKING REPAIR OF WEB FOUND CORROSION ON UPPER AND LWR SURFACE OF FLOOR PANEL ATTACH NUT PLATE HOLE THRU BS 1681 FLOORBEAM, LBL 31, WL 208. REPAIR PER ATS ER 10-2302 UPS EO B757-5310-37439-A.SDR USAA2010041390793Floorbeam · corrodedPIT - S4 - MAJOR REPAIR - LEVEL 2 CORROSION ON FLOORBEAM BETWEEN FR66 TO FR68, -Y1292. REPLACED FLOORBEAM BETWEEN FR66 TO FR68, -Y1292 IAW A319 SRM 51-74-00 & 51-73-11.SDR USAA2010041390792Floorbeam · corrodedPIT - S4 - MAJOR REPAIR - LEVEL 2 CORROSION ON FLOORBEAM BETWEEN FR66 TO FR70, -Y765. REPLACED FLOORBEAM BETWEEN FR66 TO FR70, -Y765 IAW A319 SRM 51-71-11.SDR USAA2010041390791Floorbeam · corrodedPIT - S4 - MAJOR REPAIR - LEVEL 2 CORROSION ON FLOORBEAM BETWEEN FR66 TO FR70, -Y765. REPLACED FLOORBEAM BETWEEN FR66 TO FR70, -Y765 IAW A319 SRM 51-71-11.SDR IPXA10559211Floorbeam · corrodedINSP TYPE:C4 BS 1200 FLOORBEAM HAS CORROSION ON UPPER SURFACE OF UPPER FLANGE AT SEVERAL NUTPLATE LOCATIONS, LBL 24 TO RBL 50, WL 208.1 (MARKED) REMOVED CORROSION IAW SRM 51-10-02 FOUND AREA TO BE OUT OF LIMITS. FABRICATED REPAIR AND INSTALLED IAW REPAIR DSDR DALA107109867Floorbeam · corrodedDURING H-CHECK, FOUND CORROSION ON FLOOR SUPPORT AT BS200 BETWEEN RBL 22-44. REPAIRED IAW SRM 53-13-1, 51-30-2.SDR DALA106979867Floorbeam · corrodedDURING H-CHECK FOUND CORROSION ON FLOOR SUPPORT AT BS 200 BETWEEN LBL 22-44. REPAIRED IAW 53-01-1, 51-10-4, 51-30-5.SDR SWIA201023951Floorbeam · crackedFS 280 BEAM CRACKED AND CORRODED. (C CHECK) REPLACE PER REO.SDR SWIA201024429Floorbeam · crackedFS 280 FLOORBEAM CRACKED. (C CHECK) REPAIRED PER REO.SDR CNMA20100018Floorbeam · corrodedBS 2007, LBL 20-28 CORROSION ON M/D FLOOR SUPPORT TEE CHORD. ALL OPEN HOLES WERE NDT INSPECTED - NO CRACKS OR CORROSION WERE FOUND. THIS SECTION OF CHORD WAS INCLUDED IN THE REPAIR OF NRC -387. SEE NRC 387. (NONRO 387 CORRODED SECTION OF CHORD WAS TRIMMED OUSDR CNMA20100017Floorbeam · corrodedBS 2007, LBL 53-68 CORROSION ON FLOOR SUPPORT TEE CHORD. ALL OPEN HOLES NDT INSPECTED - NO CRACKS OR CORROSION FOUND. THIS SECTION WAS INCLUDED IN THE REPAIR OF NRC 387. NRC 387. (NONRO 387, CORRODED SECTION OF CHORD WAS TRIMMED OUT. NEW SECTION FABRICATED FRSDR CNMA20100016Floorbeam · corrodedBS 2007 LBL 77 CORROSION ON TEE CHORD FLOOR SUPPORT. ALL OPEN HOLES WERE NDT INSPECTED - NO CRACKS OR CORROSION FOUND. THIS SECTION OF CHORD WAS INCLUDED IN THE REPAIR OF NRC-387. SEE NRC 387. (NONRO 387, CORRODED SECTION OF CHORD WAS TRIMMED OUT. NEW SECTISDR CNMA20100015Floorbeam · corrodedBS 2007, LBL16 CORROSION ON THE TEE CHORD FLOOR STRUCTURE. CORRODED SECTION OF CHORD WAS TRIMMED OUT. NEW SECTION FABRICATED FROM THE TEE PN NJC6040-175 WAS INSTALLED WITH SPLICES PN N621AX-NRC387-1/-2 IAW SRM VOL I 53-40-00, FIG 16 AND USING FASTENERS IAW SSDR IPXA10559281Floorbeam · corrodedINSPECTION TYPE:C4 MAIN CARGO FLOOR AT STA 1052 RBL 9-RBL 21 WL 208 CORROSION AROUND NUT PLATES. R & R SUPPORT IAW SRM 51-40-02.SDR USAA2010041390784Floorbeam · corrodedPIT - S4 - MAJOR REPAIR - LEVEL 2 CORROSION ON TOP OF FLOORBEAM AT FR66 TO FR70, Y765. REPLACED FLOORBEAM AT FR66 TO FR70, Y765 IAW A319 SRM 51-72-11.SDR USAA2010041390783Floorbeam · corrodedPIT - S4 - MAJOR REPAIR - LEVEL 2 CORROSION ON TOP OF FLOORBEAM AT FR66 TO FR70, Y765. REPLACED FLOORBEAM AT FR66 TO FR70, Y765 IAW A319 SRM 51-72-11.SDR DALA106873250Fitting · damagedDURING H-CHECK FOUND DAMAGE TO FWD CABIN SUPPORT BEAM CONNECTING FITTING AT -Y254 FR12. REPAIRED IAW SRM 51-42-11.SDR USAA2010040190705Floorbeam · corrodedPIT - S4 - MAJOR REPAIR - LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM BETWEEN FR66 THRU FR70, Y765. REPLACED FLOORBEAM BETWEEN FR66 THRU FR70, Y765 IAW A319 SRM 51-72-11.SDR AALA20100331TUL02Floorbeam · corrodedNUMEROUS AREAS OF CORROSION ALONG STATION 1680 FLOORBEAM T-CAP LEFT BUTTLINE 54 TO RIGHT BUTTLINE 54. REMOVED AND REPLACED ENTIRE FLOORBEAM T-CAP PER EA B757-53-009489.SDR USAA2010041390790Floorbeam · corrodedPIT - S4 - MAJOR REPAIR - LEVEL 2 CORROSION ON FLOORBEAM AT FR24, FR25 & FR30, -Y1292. REPLACED FLOORBEAM AT FR24, FR25 & FR30, -Y1292 IAW A319 SRM 51-42-00, 51-44-11, & 51-72-11.SDR USAA2010041390789Floorbeam · corrodedPIT - S4 - MAJOR REPAIR - LEVEL 2 CORROSION ON TOP OF FLOORBEAM BETWEEN FR16 TO FR20, Y1292. REPLACED FLOORBEAM BETWEEN FR16 TO FR20, Y1292 IAW A319 SRM 51-72-11 & 51-42-11.SDR USAA2010033190694Floorbeam · corrodedPIT - S4 - MAJOR REPAIR - LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM AT FR66, Y254. REPLACED FLOORBEAM AT FR66, Y254 IAW AIRBUS DRAWING 18D53472800 & D53472750.SDR USAA2010033190693Floorbeam · corrodedPIT - S4 - MAJOR REPAIR - LEVEL 2 FILIFORM CORROSION ON FLOORBEAM BETWEEN FR64 TO FR66, Y254. REPLACED FLOORBEAM BETWEEN FR64 TO FR66, Y254 IAW AIRBUS DRAWING 18D53472800 & 10D53472750.SDR USAA2010033190692Floorbeam · corrodedPIT - S4 - MAJOR REPAIR - LEVEL 2 FILIFORM CORROSION ON FLOORBEAM AT FR66, S20R, -Y300. REPLACED FLOORBEAM AT FR66, S20R, -Y300 IAW A319 SRM 51-72-11.SDR FDEA201003311042Floorbeam · crackedAFT CARGO FR 64 UPPER FLOORBEAM BETWEEN 4L & 5L IS CRACKED ON AFT SIDE. REMOVED DAMAGE ON AFT CARGO FR 64 UPPER FLOORBEAM BETWEEN 4L & 5L AFT SIDE CHEM MILL, FABRICATED, DRILLED AND INSTALLED REPAIR CHANNEL IAW FREIGHTER SRM 53-10-15 FIG 21. REMOVED AND REINSDR FDEA201003311041Floorbeam · crackedFWD CARGO FRAME 30 UPPER FLOORBEAM BETWEEN S/T 2R AND 3R IS CRACKED ON FWD SIDE. PERFORMED CROSSBEAM REPAIR AT FWD FACE OF FLOORBEAM FRAME 30 BETWEEN SEAT TRACK 2R AND 3R BY REMOVING DAMAGE, FABRICATING, LOCATING AND DRILLING A FILLER AND REPAIR CHANNEL AND INSDR USAA2010040190704Strap · brokenCLT - C1 - MAJOR REPAIR - FLOORBEAM STABILIZER TIE STRAP BROKEN BETWEEN BS 337.7 TO BS 365.2, LBL 45.5. REPAIRED FLOORBEAM STABILIZER TIE STRAP BETWEEN BS 337.7 TO BS 365.2, LBL 45.5 IAW EA 101852.SDR USAA2010040190699Floorbeam · corrodedPIT - S4 - MAJOR REPAIR - LEVEL 2 CORROSION ON FLOORBEAM AT FR66, -Y464.8. REPLACED FLOORBEAM AT FR66, -Y464.8 IAW A319 SRM 51-72-11.SDR FDEA201003301030Floorbeam · crackedAFT CARGO PIT FLOORBEAM FR 58 BETWEEN SEAT TRACK 2&3 RT CRACK, PREVIOUS REPAIR IN AREA WITH 1EA HYLOCK COLLARS MISSING & 1 EA COLLAR BROKEN. R & R CROSSBEAM SECTION AT FR 58. INSTALLED 4 EA REPAIR COUPLING AND 4 EA COUPLING STRAPS IAW SRM 53-10-15 FIG 207.SDR IPXA10659143Floorbeam · crackedINSPECTION TYPE:C FX STA246 MAIN DECK FLOORBEAM ATT CLIP FOUND CRACK AT RBL10". FX STA 246 MAIN DECK FLOORBEAM ATT CLIP AT RBL10" AREA REPLACED AND INSTALLED IAW SRM 51-10-02 AND 51-40-02, REV 46.SDR IPXA10659142Floorbeam · crackedINSPECTION TYPE:C, AFT BULK CARGO COMPT MAIN DECK FLOORBEAM ATT ANGLE FOUND CRACK AT STA1581 LBL70". AFT BULK CARGO COMPT MAIN DECK FLOORBEAM ATT ANGLE REPLACED AND INSTALLED AT STA1581 LBL70" IAW SRM 51-10-02 AND 51-40-02, REV 46.SDR IPXA10659139Floorbeam · crackedINSP TYPE:6C, AFT BULK CARGO COMPT MAIN DECK FLOORBEAM ATT ANGLE FOUND CRACKED AT STA 1581, RBL70". AFT BULK CARGO COMPT MAIN DECK FLOORBEAM ATT ANGLE REPLACED AND INSTALLED AT STA 1581 RBL 70" IAW SRM 51-10-02 AND 51-40-02 REV46.SDR DALA106613250Floorbeam · corrodedDURING L-CHECK FOUND CORROSION ON FLOOR SUPPORT BEAM AT Y512 FR64-FR66. REPAIRED IAW SRM 51-42-11.SDR CNMA20100013Floorbeam · corrodedCORROSION ON CTR CARGO LWR PANEL SUPPORT BS 1741 LBL 16. DAMAGED SUPPORT REMOVED NEW FABRICATED PN OAI-53-0008 IAW SRM DWG AD0145-30 & OMNI GMM 4.45 AND INSTALLED WITH FASTNERS IAW SRM VOL 2 51-35-01, PAGE 1.SDR CNMA20100012Floorbeam · corrodedCORROSION ON CTR CARGO LWR PANEL SUPPORT BS 1741 RBL 16. DAMAGED SUPPORT REMOVED NEW FABRICATED PN OAI-53-0007 IAW SRM DWG AD00145 OMNI GMM 4.45 AND INSTALLED WITH FASTNERS IAW SRM VOL 2 51-35-01, PAGE 1.SDR CNMA20100011Floorbeam · corrodedCORROSION ON CTR CARGO LWR PANEL SUPPORT BS 1741 RBL 12-14. DAMAGED SUPPORT REMOVED NEW FABRICATED PN OAI-53-0009 IAW DWG AD00145 & OMNI GMM 4-45 AND INSTALLED WITH FASTNERS IAW SRM VOL 2 51-35-01, PAGE 1.SDR USAA2010032990657Floorbeam · corrodedPIT - S4 - MAJOR REPAIR - LEVEL 2 EXFOLIATION CORROSION ON TOP OF FLOOR SUPPORT BEAM AT FR66, Y460. REPLACED FLOOR SUPPORT BEAM AT FR66, Y460 IAW A319 SRM 51-42-11 & 51-72-11.SDR SWAA101755Floorbeam · corrodedDURING SCHEDULED 6Y CHECK, FOUND FLOORBEAM CORRODED AT BS 772, LBL 8. REPAIRED BEAM PER EA.SDR SWAA101754Floorbeam · corrodedDURING SCHEDULED 6Y CHECK, FOUND FLOORBEAM CORRODED AT BS 772, LBL 12.5. REPAIRED BEAM PER EA.SDR SWAA101753Floorbeam · corrodedDURING SCHEDULED 6Y CHECK, FOUND FLOORBEAM CORRODED AT BS 772, RBL 3. REPAIRED BEAM PER EA.SDR SWAA101752Floorbeam · corrodedDURING SCHEDULED 6Y CHECK, FOUND FLOORBEAM CORRODED AT BS 772, RBL 8. REPAIRED BEAM PER EA.SDR SWAA101751Floorbeam · corrodedDURING SCHEDULED 6Y CHECK, FOUND FLOORBEAM CORRODED AT BS 772, LBL 3. REPAIRED BEAM PER EA.SDR ABXA201004090038Floorbeam · crackedDURING CARGO CONVERSION FOUND CORROSION AND 2.5 INCH CRACK ON UPPER CHORD OF FLC FLOORBEAM AT STA 632 RBL 15 TO RBL 20. REPAIRED CHORD IAW B767 SRM 53-00-7.SDR FDEA201003271026Floorbeam · damagedSTA 1166 FLOORBEAM HAS DOUBLE DRILLED HOLES LBL 25. CUT OUT DAMAGED AREA, FABRICATED NEW UPPER CHORD USING BAC1505-100617 7075T-73 PO 29103139 DIMS 11 5/8" X 2", FABRICATED 2 EACH SUPPORT ANGLES USING BAC1490-2831 7075T-62 PO 9006081 DIMS 11 1/2" X 3" AND BSDR ASOA201000443Floorbeam · corrodedFLOOR SUPPORT FRAME CORRODED. REMOVED CORRODED FLOOR SUPPORT FRAME. NEW FRAME ON REQ. WORK DONE IAW SRM 51-42-02. PICKED UP FASTENER HOLES ,COUNTERSUNK, INSTALLED NUT PLATES AND INSTALLED NEW FRAME SUPPORT. SRM 51-42-06,51-41-02. APPLIED CHEMICAL CONVERSIOSDR USAA2010032990658Floorbeam · corrodedPIT - S4 - MAJOR REPAIR - LEVEL 2 FILIFORM CORROSION ON FLOORBEAM BETWEEN FR12 TO FR16, Y81. REPLACED FLOORBEAM BETWEEN FR12 TO FR16, Y81 IAW A319 SRM 51-42-00 & 51-72-11.SDR DALA106529862Floorbeam · crackedDURING L-CHECK FOUND FLOOR SUPPORT AT FLOOR PANEL NR 69 HAS CRACKS AROUND RIVETS. REPAIRED IAW SRM 51-10-4, 51-30-2.SDR IPXA10559022Floorbeam · crackedINSPECTION TYPE:C2, FLOOR SUPPORT UPPER SKIN IS CRACKED STA 900 RBL 0-25 WL 208. REPLACED COVER PLATE IAW SRM 53-00-51-1A1, SRM 51-40-02-0G, SRM 51-40-05.SDR SWIA201023936Floorbeam · crackedFS 280 FLOORBEAM CRACKED. (C CHECK) REPLACED BEAM PER REO.
Back to JASC 5315