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 USAA040992Floorbeam · corrodedBFM - S1 - BEAM, 2 INCH X 2 INCH X 0.02 INCH CORRODED AREA. CORROSION; LEVEL 2; TASK NR JA-260-53500, MAIN CABIN FLOOR BEAM BTW, FR 66-68, BL Y 1162-Y1292. REMOVED AND REPLACED BEAM IAW SRM 51-74-00, 53-00-14, 51-42-11.SDR C1HA200493010Floorbeam · corrodedFLOORBEAM FS 380 BETWEEN RBL 24.75 AND LBL 24.75 UPPER CAP IS CORRODED, SRM REPAIR MINOR.SDR SIMA200432904Floorbeam · corrodedDURING A MBV INSPECTION, CORROSION WAS FOUND ON THE GALLEY CENTER FLOORBEAM AT FRAME 20. REMOVED CORROSION BY CUTOUT. FABRICATED A REPAIR DOUBLER. REPAIR DONE IAW SRM. (SW21200501183)SDR 2004UALA01142Floorbeam · corrodedCABIN FLOORBEAM STA 324 AND RBL 53 HAS CORROSION. REMOVED DAMAGED T CAP SECTION AND INSTALLED NEW SECTION SPLICED WITH DOUBLERS.SDR SWAA043383Floorbeam · crackedDURING SCHEDULED 1/4D CHECK, FOUND FLOORBEAM UPPER CHORD AT BS 665, BL 0, CRACKED. REPAIRED CHORD PER EA.SDR DHL2004873518Floorbeam · corrodedMAIN CARGO COMPT UPPER FLOORBEAM FLANGE CORRODED, STA 1300.000 RBL 8 TO RBL 16 (MAJOR REPAIR). PERFORMED MAJOR REPAIR IAW SRM 53-2-0 FIG 1G, TR 53-124. REMOVED CORROSION FROM UPPER FLOORBEAM FLANGE AT STA 1300.000 RBL 8 TO RBL 16 IAW SRM 51-1-8 PG 17-18. FOSDR ASAA0410546Floorbeam · corrodedPAE - FOUND CORROSION LOWER FLOORBEAM BS 787 STRINGER 18R WL 201. REPAIRED TRANSVERSE BEAM PER EA 5310-02402 AND EO 04-3651. (M)SDR SWAA043375Floorbeam · crackedDURING SCHEDULED 1/4D CHECK, FOUND FLOORBEAM UPPER CHORD AT BS 663, BL 0, CRACKED. REPAIRED CHORD PER EA.SDR ASAA0410558Floorbeam · corrodedPAE - FLOORBEAM CORROSION AT FASTENER HOLES UPPER FLANGE, UPPER AND LOWER SURFACES. REPAIRED PER EA. (M)SDR ASAA0410556Floorbeam · corrodedPAE - FOUND CORROSION ON FLOORBEAM. REPAIRED PER EA. (M)SDR ASAA0410538Floorbeam · corrodedOKC - FLOORBEAM STATION 500A RBL 24 TO 63 IC CORRODED. REMOVED EXISTING REPAIR STRAPS, REMOVED CORROSION, FABRICATED AND INSTALLED REPAIR STRAPS IAW AS AND AAR EA. (M)SDR USAA040989Floorbeam · corrodedBFM - S1 - BEAM, 2.5 INCH X 2.0 INCH X .03 INCH DEEP; CORROSION; LEVEL 1; TASK NR JA-260-53500, LONGERON FLOORBEAM AT FR 66; Y1292 (LT). REMOVED AND REPLACED AT FR 66; Y 1292 (LT). REMOVED AND REPLACED BEAM ASSY IAW SRM 51-74-00, SRM 51-42-11.SDR USAA040871Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED 2 SQUARE INCHES, STATION 347 RBL 48. ACCOMPLISHED T-CAP REPAIR IAW SRM 53-00-01. (M)SDR USAA041005Floorbeam · corrodedBFM - S1 - BEAM, 2.5 INCH X 1.25 INCH X 0.06 INCH AREA, CORROSION; LEVEL 2; TASK NR JA-260-53500, FLOORBEAM BTW FR 68-69 AT BL-Y1162. REMOVED AND REPLACED BEAM PER SRM 51-74-00, 53-00-14, 51-42-11.SDR USAA041004Floorbeam · corrodedBFM - S1 - BEAM, 2 INCHES X 1 INCH X .035 INCH AREA, CORROSION; LEVEL 2; TASK NR JA-260-53500, FLOORBEAM BTW FR 66-68, BTW BL Y-1162 AND Y-1292. REMOVED AND REPLACED BEAM IAW SRM 51-74-00, 53-00-14, 51-42-11.SDR USAA041003Floorbeam · corrodedBFM - S1 - BEAM, 1.5 INCH X 1 INCH X .025 INCH AREA, CORROSION; LEVEL 2; TASK NR JA-260-53500, FLOORBEAM AT FR 66, BL-Y1292. REMOVED AND REPLACED BEAM IAW SRM 51-74-00, 53-00-14, 51-42-11.SDR 2004UALA01065Floorbeam · corrodedMAIN CABIN STA 324 RS FLOORBEAM CORRODED FROM RBL 40 TO CUSP. REMOVED CORROSION DAMAGE AND INSTALLED FLOORBEAM REPAIR.SDR 2004UALA01064Floorbeam · corrodedMAIN CABIN STA 365 FLOORBEAM CORRODED FROM RBL 26 TO RBL 0. REMOVED DAMAGE, FABRICATED AND INSTALLED REPLACEMENT FLOORBEAM.SDR 2004UALA01062Floorbeam · corrodedSTA 365 RBL 58 TO 63 FLOORBEAM CORRODED. REMOVED CORROSION AND INSTALLED REPAIR TO FLOORBEAM.SDR 04FDEA03107Floorbeam · damagedCORROSION MECHANICAL DAMAGE ON FLOORBEAM BS 680 UPPER CHORD LWR SURFACE AT LBL 64 WL 208.SDR 2004UALA01111Floorbeam · corrodedSTA 986 FLOOR BEAM UPR CAP HAS CORROSION AT RBL 16 . SUPPLEMENTAL DATA UPDATE MAJOR REPAIR ACCOMPLISHED. SPLICED UPR T-CAP SECTION AT STA 986 FROM RBL 24 TO LBL 65.SDR SWAA043337Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND FLOORBEAM AT BS 771, LBL 13, CORRODED. REPAIRED FLOORBEAM PER EA.SDR SWAA043334Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM AT BS 986, BETWEEN RBL 47 TO LBL 47, CORRODED. REMOVED AND REPLACED FLOORBEAM SECTION PER ER.SDR SWAA043333Floorbeam · crackedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM AT BS 947.5, LBL 54, CRACKED. REPAIRED FLOORBEAM SECTION PER ER.SDR 2005UALA00406Floorbeam · damagedFLOORBEAM AT STA 324 RBL 60 IS DAMAGED. MAJOR REPAIR ACCOMPLISHED. FABRICATED & INSTALLED FLOORBEAM CHORD SPLICE REPAIR.SDR ASAA0410523Floorbeam · corrodedOKC - FLOORBEAM HAS CORROSION ON TOP. REMOVED DAMAGE, FABRICATED AND INSTALLED REPAIR T-CHORD, ANGLES, STRAPS AND FILLERS IAW EA. (M)SDR 2004UALA01048Floorbeam · damagedCABIN FLOORBEAM CAP AT BS 324 RBL 44, RBL 48, AND RBL 62 IS CORRODED. SUPPLEMENTAL DATA UPDATE, TYPICAL FLOORBEAM CORROSION. REMOVED DAMAGE AND INSTALLED REPAIR ANGLES TO FLOORBEAMS.SDR 2004UALA01110Floorbeam · corrodedCABIN FLOORBEAM STA 1640 HAS CORROSION RBL 44 TO 52, UPPER CAP. CORRODED SECTION REMOVED AND A FLOORBEAM DOUBLER REPAIR WAS INSTALLED.SDR SWIA200414082Floorbeam · crackedFS 280 RIGHT FLOORBEAM RBL 9.0 INBOARD AND OUTBOARD ATTACH ANGLES CRACKED. ITEM FOUND AT C-CHECK INSPECTION. REPLACED ANGLES IAW CRJ SRM 51-40-11, 51-42-06, 51-42-21, 51-23-00, 51-21-11.SDR SWIA200414081Floorbeam · crackedFS 280 LEFT FLOORBEAM LBL 9.0 INBOARD AND OUTBOARD ATTACH ANGLES CRACKED. ITEM FOUND AT C-CHECK INSPECTION. REPLACED ANGLES IAW CRJ SRM 51-40-11, 51-42-06, 51-42-21, 51-23-00, 51-21-11.SDR 04FDEA03080Floorbeam · corrodedCORROSION WHILE WORKING EO 7-5340-82473, FOUND CORROSION ON FLOORBEAM SPLICE AT BS 344, RBL 18. REPAIRED PER SRM 53-10-1, 51-10-2, 51-30-2, 51-30-5, 51-30-8, AND FED EX SRD 27-53-007.SDR 04FDEA03079Floorbeam · corrodedFLOORBEAM CORRODED RBL 18, W/L 200. REPAIRED PER SRM 53-10-8SDR IXXA0500100SFloorbeam · corrodedDURING A ROUTINE C CHECK INSPECTION, FOUND FOWARD CARGO COMPARTMENT FLOORBEAM CORRODED AT STA 560.000 RBL 60. MAJOR REPAIR ACCOMPLISHED BLEND OUT OF DAMAGED AREA. FOUND OUT OF LIMITS IAW DC8 SRM 53.2.0 FIG 1F. FABRICATED REPAIR ANGLE IAW EC8 SRM 53-2-0 FIG 1SDR USAA041010Floorbeam · corrodedBFM - S1 - FLOORBEAM, 2 INCH X 1 INCH X .024 INCH AREA, CORROSION; LEVEL 2; TASK NR JA-260-53500, AFT CABIN AREA Y765, FR68. REMOVED AND REPLACED IAW SRM 51-42-11, 51-74-00, 53-00-14.SDR 2004UALA01119Floorbeam · buckledCARGO PIT FLOOR JUST IN FRONT OF DOORWAY IS SEVERELY BUCKLED.SDR ABXA040382Floorbeam · corrodedFLOORBEAM AT STA 52, RIGHT BUTTLINE 51 HAD CORROSION ON BOTTOM CAP. REPAIRED AREA IAW REA D853-50309MR.SDR SWAA043297Floorbeam · corrodedDURING SCHEDULED 5Y CHECK, FOUND FLOORBEAM AT BS 772, BETWEEN LBL 3 AND RBL 8, CORRODED. REPAIRED FLOORBEAM PER EA.SDR 04FDEA03071Floorbeam · corrodedCORROSION AT FLOORBEAM UPPER AND LOWER SURFACE BS 344 LBL 10 - RBL 10. REPAIRED FLOORBEAM BS 344 LBL 10 - RBL10 PER SRM 53-10-1 AND FEDEX SR 27-53-007.SDR 04FDEA03068Floorbeam · damagedMECHANICAL DAMAGE ON FLOORBEAM STA 700 TOP CHORD LWR SURFACE LBL 64. REJECTED DUE TO DAMAGE STILL EXISTS. REPAIRED PER SRM 53-10-8SDR ASAA0410500Floorbeam · corrodedOKC - FLOORBEAM HAS CORROSION. REMOVED DAMAGE, REMOVED PRE-EXISTING REPAIRS, FLAT PEENED, TREATED, PRIMED, TOPCOATED, AND REINSTALLED PRE-EXISTING REPAIRS IAW EA. (M)SDR 2004UALA01030Floorbeam · corrodedCABIN FLOORBEAM CAP AT BS 310 CORRODED RBL 44. FABRICATED & INSTALLED NESTED ANGLE REPAIR WITH FILLERS & SHIMS.SDR 04FDEA03055Floorbeam · damagedMECHANICAL DAMAGE ON FLOORBEAM BS 720 TOP CHORD LWR SURFACE LBL 64. REJECTED DUE TO DAMAGE STILL EXISTS. REPAIRED PER SRM 53-10-8SDR USAA040832Floorbeam · corrodedC4, FLOORBEAM CAP, .5000 INCH SQUARE, CORROSION, STA 365, RBL 62. ACCOMPLISHED TEE CAP REPAIR IAW TR 53-15-02, SRM 51-10-02, 53-00-51.SDR 2004UALA01020Floorbeam · crackedNOSE COMPARTMENT AT STATION 247 APPROXIMATELY AT RBL 77 FLOORBEAM P-N 141T5104-7 WAS FOUND CRACKED AT WL 195.50.SDR 04FDEA03045Floorbeam · corrodedFOUND CORROSION ON FLOORBEAM AT BS 620 BL O - LBL 8 (C53-111-01(3)). CORROSION REMOVED ON FLOORBEAM FOUND TO BE OUT OF LIMITS. FLOORBEAM TO BE REPAIRED ON N00920.SDR 04FDEA03047Floorbeam · corrodedCORROSION (C53-224-01) AT FLOORBEAM UPPER CHORD AT BS 620, LBL 45-65, WL 208.SDR 04FDEA03046Floorbeam · corrodedCORROSION FLOORBEAM STA 620 LWR CHORD LWR SURFACE CORRODED LBL 8 AROUND NUTPLATE HOLE. REPAIRED PER SRM 53-10-1, 53-10-8SDR ASAA0410505Floorbeam · corrodedOKC - FOUND FLOORBEAM HAS CORROSION AT TOP FLANGE. REMOVED DAMAGED REPAIR, FABRICATED AND INSTALLED REPAIR TEE CHORD, TRIPLER ANGLE, SPLICE ANGLE, REPAIR STRAP, TRIPLER STRAP, AND FILLER IAW EA. (M)SDR ASAA0410504Floorbeam · corrodedOKC - FOUND FLOORBEAM HAS CORROSION AT TOP FLANGE. REMOVED DAMAGED REPAIR, FABRICATED AND INSTALLED REPLACEMENT FLOORBEAM T-CAP IAW EA. (M)SDR SIMA200432211Floorbeam · corrodedTHE GALLEY AREA FORWARD DIGITAL WAS FOUND TO BE CORRODED. REMOVED THE GALLEY AREA FWD DIGITAL. INSTALLED THE NEW DIGITAL IAW SRM.
Back to JASC 5315