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 SWIA201024925Floorbeam · corrodedTHE 280.0 FLOORBEAM IS CORRODED ON THE LEFT & RIGHT SIDES UPPER FLANGE. (C-CHECK) REPAIRED PER SRM.SDR ASOA201001142Floorbeam · corrodedCARGO BAY UNDER FLOOR , FLOORBEAM AT LBL 27.00 HAS CORROSION AT MULTIPLE NUTPLATES JUST OF FS 621.00. RELAMPED AFT CABIN CEILING LIGHT IAW AMM 33-51-16. OPS CHECK GOOD.SDR SWAA104831Floorbeam · corrodedDURING SCHEDULED 16Y CHECK, FOUND FLOORBEAM CORRODED AT BS 312, RBL 7.5. REPAIRED BEAM PER TI.SDR SWAA104830Floorbeam · corrodedDURING SCHEDULED 16Y CHECK, FOUND FLOORBEAM CORRODED AT BS 312, BETWEEN BBL 0 TO LBL 21. REPAIRED BEAM PER TI.SDR SWAA104829Floorbeam · corrodedDURING SCHEDULED 16Y CHECK, FOUND FLOORBEAM CORRODED AT BS 328, LBL 49. REPAIRED BEAM PER TI.SDR ASOA201001134Floorbeam · corrodedFS 280, FWD J ANGLE ON TRANSVERSE BEAM HAS SEVERAL AREAS OF CORROSION. REMOVED FS 280 FWD J ANGLE IAW SRM 51-40-11. LOCATED AND DRILLED NEW ANGLE IAW SRM 51-40-11. INSTALLED REQUIRED. INSTALLED NEW SERVICEABLE FWD FLOOR SUPPORT ANGLE AT FS 280 IAW SRM 51-4SDR ASOA201001133Floorbeam · crackedPILOTS BULKHEAD FS 280, LBL 9.0 FLOORBEAM IS CRACKED 2". C/W STEP 1 OF REO 601R-53-11-171. PERFORMED EDDY CURRENT INSP ON CUT OUT EDGES OF FLOOR ANGLE. NO INDICATIONS FOUND AT THIS TIME, REPORT ATTACHED IAW STEP 2 OF REO 601R-53-11-171D AND NDTM PT 1 51-20-SDR AALA20100815TUL02Floorbeam · crackedSTATION 700 FLOORBEAM CRACK LEFT BUTTLINE 24 TO LEFT BUTTLINE 45. REPAIRED PER SRM 53-00-51.SDR USAA2010082491766Support · corrodedPIT - S5 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON FLOORBEAM SUPPORT AT FR20, -Y189. REPLACED FLOORBEAM AT FR20, -Y189 IAW A320 SRM 51-72-11.SDR ASOA201001118Floorbeam · corrodedFWD FLOOR ANGLE AT FS 280 IS CORRODED AND REQUIRES REPLACEMENT. REMOVED AND REPLACED FWD FLOOR ANGLE AT STA 280 IAW SRM 51-42-06 AND 51-42-21.SDR EE4Y100336Floorbeam · corrodedUPPER FUSELAGE, FLOORBEAM LOWER FLANGE WITH CORROSION AT STA 847 BETWEEN RBL 42 AND RBL 59. THE CORROSION REQUIRES A MAJOR REPAIR.SDR EE4Y100335Floorbeam · corrodedUPPER FUSELAGE, FLOORBEAM LOWER FLANGE WITH CORROSION AT STA 867 BETWEEN RBL 26 AND RBL 56. THE CORROSION REQUIRES A MAJOR REPAIR.SDR EE4Y100337Floorbeam · corrodedUPPER FUSELAGE, FLOORBEAM WITH CORROSION AT UPPER FLANGE AT STA 344 BETWEEN LBL 43 & RBL 11. THE CORROSION REQUIRES MAJOR REPAIR.SDR USAA2010082091727Floorbeam · corrodedSAL - Q4 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION AROUND HOLE OF FLOORBEAM LOCATED BL 0, BS 420. REPAIRED FLOORBEAM AT BS 420, BL 0 IAW B737 SRM 53-30-51 REPAIR 2.SDR FDEA201008122960Floorbeam · misrepairedFORWARD CARGO - EXISTING REPAIR AT FLOORBEAM STA 1099, X = 4 TO X = 14. EXISTING REPAIR AT FORWARD CARGO FLOORBEAM EVALUATED AND FOUND NOT IN ACCORDANCE WITH ANY SRM REPAIR SCHEME. EXISTING REPAIR REMOVED AND NEW REPAIR CARRIED OUT PER E.A. 8-5310-140428, RSDR SWAA104735Floorbeam · crackedDURING SCHEDULED 12Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 547, RBL 15. REPAIRED BEAM PER SRM.SDR SWAA104734Floorbeam · crackedDURING SCHEDULED 12Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 547, RBL 7. REPAIRED BEAM PER SRM.SDR SWAA104733Floorbeam · crackedDURING SCHEDULED 12Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 547, LBL 7. REPAIRED BEAM PER SRM.SDR SWAA104732Floorbeam · crackedDURING SCHEDULED 12Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 547, LBL 15. REPAIRED BEAM PER SRM.SDR SWAA104731Floorbeam · crackedDURING SCHEDULED 12Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 547, RBL 33. REPAIRED BEAM PER SRM.SDR DALA1019213270Floorbeam · corrodedDURING M-CHECK FOUND CORROSION ON FLOORBEAM AT +Y254 BETWEEN FR 16 & FR 21. REPAIRED IAW SRM 51-44-11, SRM 51-42-11, ERA 484240-14.SDR FDEA201008122957Floorbeam · corrodedCORROSION FLOORBEAM, TOP MAIN CABIN FRONT OF 9G BARRIER. CUTOUT DAMAGED AREA, FABRICATED REPAIR ANGLES & FILLER & INSTALLED FLOORBEAM. REPAIR AT BS 344 IAW SRM 53-10-8, FIG 9, SRM 51-10-2, SRM 51-30-2.SDR EE4Y100333Floorbeam · corrodedUPPER FUSELAGE, BS 787 FLOORBEAM, LOWER FLANGE CORRODED. THE DAMAGE REQUIRES A MAJOR REPAIR.SDR ASOA201001111Floorbeam · crackedSUPPORT CLIPS AT FS 280, RBL 9.0 ARE CRACKED. REPLACEMENT OF SUPPORT CLIP AT FS 280, RBL 9.0 IAW REO 601R-53-11-926, REV B.SDR VGQY2010081100077Floorbeam · crackedHFEC OPEN HOLE INSP CARRIED OUT AND FOUND ONE HOLE WITH CRACK INDICATION AT BS 420 UPPER DECK FLOORBEAM UPPER CHORD AFT FLANGE LBL 3 AT 6 O'CLOCK BY PLAIN VIEW. COMPLIED WITH EN 1191-10, REPAIR FOR BOEING UPPER TEE HOLES FOUND CRACKED STA 420 & STA 520.SDR SWAA104705Floorbeam · crackedDURING SCHEDULED 12Y CHECK, FOUND FLOORBEAM WEB CRACKED AT BS 492, STR 26R. REPAIRED WEB PER SRM.SDR VGQY2010081000074Floorbeam · crackedHFEC OPEN HOLE INSP CARRIED OUT AND FOUND ONE HOLE WITH CRACK INDICATION AT BS 520 UPPER DECK FLOORBEAM UPPER CHORD AFT FLANGE RBL 15 AT 6 AND 12 O'CLOCK BY PLAIN VIEW. COMPLIED WITH EN 1191-10, REPAIR FOR UPPER DECK FLOORBEAM UPPER T-CHORD HOLES FOUND CRACK SDR VGQY2010081000073Floorbeam · crackedHFEC OPEN HOLE INSP CARRIED OUT AND FOUND ONE HOLE WITH CRACK INDICATION AT BS 520 UPPER DECK FLOORBEAM UPPER CHORD AFT FLANGE RBL 10 AT 6 AND 12 O'CLOCK BY PLAIN VIEW. COMPLIED WITH EN 1191-10, REPAIR FOR UPPER DECK FLOOR BEAM UPPER T-CHORD HOLES FOUND CRACSDR VGQY2010081000072Floorbeam · crackedHFEC OPEN HOLE INSP CARRIED OUT AND FOUND ONE HOLE WITH CRACK INDICATION AT BS 520 UPPER DECK FLOORBEAM UPPER CHORD AFT FLANGE LBL 15.5 AT 6 AND 12 O'CLOCK BY PLAIN VIEW. COMPLIED WITH EN 1191-10, REPAIR FOR UPPER DECK FLOORBEAM UPPER T-CHORD HOLES FOUND CRACSDR VGQY2010081000071Floorbeam · crackedHFEC OPEN HOLE INSP CARRIED OUT AND FOUND ONE HOLE WITH CRACK INDICATION AT BS 520 UPPER DECK FLOORBEAM UPPER CHORD AFT FLANGE LBL 10 AT 6 AND 12 O'CLOCK BY PLAIN VIEW. COMPLIED WITH EN 1191-10, REPAIR FOR UPPER DECK FLOORBEAM UPPER T-CHORD HOLES FOUND CRACK SDR VGQY2010081000070Floorbeam · crackedHFEC OPEN HOLE INSP CARRIED OUT AND FOUND ONE HOLE WITH CRACK INDICATION AT BS 520 UPPER DECK FLOORBEAM UPPER CHORD AFT FLANGE LBL 5 AT 6 AND 12 O'CLOCK BY PLAIN VIEW. COMPLIED WITH EN 1191-10, REPAIR FOR UPPER DECK FLOOR BEAM UPPER T-CHORD HOLES FOUND CRACK SDR VGQY2010081000069Floorbeam · crackedHFEC OPEN HOLE INSP CARRIED OUT AND FOUND ONE HOLE WITH CRACK INDICATION AT BS 520 UPPER DECK FLOORBEAM UPPER CHORD AFT FLANGE BBL 0 AT 6 AND 12 O'CLOCK BY PLAIN VIEW. COMPLIED WITH EN 1191-10, REPAIR FOR UPPER DECK FLOORBEAM UPPER T-CHORD HOLES FOUND CRACK ASDR VGQY2010081000068Floorbeam · crackedHFEC OPEN HOLE INSP CARRIED OUT AND FOUND ONE HOLE WITH CRACK INDICATION AT BS 520 UPPER DECK FLOORBEAM UPPER CHORD FWD FLANGE RBL 22 AT 6 O'CLOCK BY PLAIN VIEW. COMPLIED WITH EN 1191-10, REPAIR FOR UPPER DECK FLOORBEAM UPPER TEE CHORD HOLES FOUND CRACK AT STSDR VGQY2010081000067Floorbeam · crackedHFEC OPEN HOLE INSP CARRIED OUT AND FOUND ONE HOLE WITH CRACK INDICATION AT BS 520 UPPER DECK FLOORBEAM UPPER CHORD FWD FLANGE LBL 17 AT 12 O'CLOCK BY PLAIN VIEW. COMPLIED WITH EN 1191-10.SDR FDEA201008092894Floorbeam · crackedMAIN DECK CARGO AT STA 1887 X=-57, BELOW FLOOR SUPPORT BEAM END FOUND CRACKED AS MARKED. R & R IAW SRM 51-31-01, REV 44. NEW FLOOR SUPPORT FABRICATED BY MACHINING IAW DWG AGA7551, REV G. REPAIR CLASSIFIED AS MAJOR IAW GMM 6-2-100, REV 110.SDR SWAA104677Floorbeam · corrodedDURING SCHEDULED 16Y CHECK, FOUND FLOORBEAM CORRODED AT BS 986.5, BETWEEN BBL 0 TO RBL 45. REPAIRED BEAM PER ER.SDR SWAA104666Floorbeam · crackedDURING SCHEDULED 16Y CHECK, FOUND FLOORBEAM CHORD CRACKED AT BS 294.5, LBL 52.25. REPAIRED BEAM PER SRM.SDR EE4Y100311Floorbeam · corrodedUPPER FUSELAGE PAX CABIN STA Y786, +X50, -Z4 FLOORBEAM WEB WITH CORROSION.SDR EE4Y100301Floorbeam · corrodedUPPER FUSELAGE PAX CABIN STA Y786 +X50, -Z4 FLOORBEAM WEB WITH CORROSION.SDR 2010FA0000812Floorbeam · corrodedCORROSION ON CABIN FLOORBEAM FR 24A LBL 10. NO CORROSION REMOVAL LIMITS FOUND IN SRM. R & R FLOORBEAM IAW SRM 51-42-11. FLOORBEAM IS LISTED AS PRIMARY STRUCTURE.SDR SWAA104658Floorbeam · crackedDURING SCHEDULED 18Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 727B, LBL 43.5. REPAIRED BEAM PER EA.SDR SWAA104606Floorbeam · corrodedDURING SCHEDULED 8Y CHECK, FOUND FLOORBEAM CORRODED AT BS 987, BETWEEN RBL 43 TO LBL 43. REPAIRED BEAM PER EA.SDR SWIA201024792Floorbeam · corrodedFLOORBEAM AT FS 610 HAS CORROSION. (C-CHECK) REMOVED AND REPLACED FLOORBEAM.SDR IPXA10561553Floorbeam · corrodedINSPECTION TYPE:C2, MCB FLOOR SUPPORT PLATE HAS CORROSION ON UPPER SURFACE BS 1017, RBL 26 TO RBL 42, WL 208. REPLACED IAW SRM.SDR R61A20100391Floorbeam · corrodedWHILE A/C WAS IN FOR HEAVY CHECK FOUND SUB TOPCOAT CORROSION SPLICE PLATE AT O/B SIDE OF RIGHT SHEAR PANEL FR87-88.SDR TRBACPCP2010052Floorbeam · corrodedLT FLOORBOARD BEAM AT FR 33 HAS CORROSION REFER TO CRIC CARD 006676. REMOVED CORROSION ON LT FLOORBEAM AT FR 33 FOUND TO BE OUT OF LIMITS IAW SRM 53-00-00 FABRICATED REPAIR IAW SRM 53-00-00 SEE ART FORM PL-004-1R1 FOR REPAIR PARTS FABRICATION DETAILS. INSTALLESDR FDEA201008062860Crossbeam · corrodedFWD MDCC - CROSS BEAM AT FR16A - CORROSION SPOTS FOUND AT Y-2004. CROSSBEAM REPLACED AS PER SRM 51-72-10.SDR R61A20100380Floorbeam · corrodedWHILE AIRCRAFT WAS IN FOR HEAVY CHECK, CORROSION LEVEL TWO WAS FOUND ON LT SIDE OF FLOORBEAM AT FR 84 O/B FLOOR PANEL SUPPORT. MAINTENANCE REMOVED AND REPLACED LEFT SIDE OF FLOORBEAM PANEL SUPPORT AT FRAME 84 IAW EMB 170 SRM 51-41-02, 51-40-04 & 51-41-01. A/SDR R61A20100379Floorbeam · corrodedWHILE AIRCRAFT WAS IN FOR HEAVY CHECK, CORROSION LEVEL TWO WAS FOUND ON LT LONG BEAM IN PAX CABIN AT FRAME 86 - 89. MAINTENANCE REMOVED AND REPLACED THE LT FLOORBEAM AT FRAME 86 - 89 IAW EMB 170 SRM 51-41-01, 51-43-03 & 51-40-02. A/C STILL OUT OF SERVICE FORSDR COMA2010080650167Floorbeam · corrodedCORROSION FOUND ON FLOORBEAM UPPER FLANGE AT LBL 27, FS 615, AROUND NUT PLATE HOLE. REPAIRED IN ACCORDANCE WITH REO 601R-53-61-3757 DATED 2010-08-05.
Back to JASC 5315