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 08FDEA03883Floorbeam · corrodedCABIN FLOORBEAM, BS 345, BL0 - RBL 10, UPPER CHORD CORRODED. REPAIRED FLOOR BEAM UPPER CHORD, BS 345, BL0 - RBL 10 IAW SRM 53-00-51, REPAIR NR 3. THIS IS CLASSIFIED AS A CATEGORY "A" MAJOR REPAIR WITH NO FOLLOW UP TRACKING.SDR SWIA200820519Floorbeam · crackedDURING C-CHECK, FS 280 UPPER FLOORBEAM ANGLE CRACKED AT RBL 10 AND LBL 11. REPAIRED PER REO.SDR SWIA200820518Floorbeam · crackedDURING C-CHECK, FS 280 LOWER FLOOR SUPPORT CRACKED AT LBL 11. REPAIRED PER REO.SDR SWIA200820517Floorbeam · crackedDURING C-CHECK, FS 280 LOWER FLOORBEAM CRACKED AT RBL 12. REPAIRED PER REO.SDR ASAA0843617Floorbeam · corrodedAFT CABIN FLOORBEAM STA 947 CORRODED AT EXISTING UPPER CHORD REPAIR LBL 40 TO RBL 40. REMOVED DAMAGED UPPER CHORD, FABRICATED REPAIR TEE SECTION, REPAIR SPLICES AND STRAPS, LOCATED, DRILLED AND INSTALLED IAW AAR EA 12921 AND ASA EA 5310 02824.SDR ASAA0843616Floorbeam · corrodedAFT CABIN FLOORBEAM STA 986 CORRODED AT EXISTING UPPER CHORD REPAIR RBL 40 TO LBL 40. REMOVED DAMAGED UPPER CHORD, FABRICATED REPAIR TEE SECTIONS REPAIR SPLICES, HEAT TREATED, LOCATED, DRILLED AND INSTALLED IAW AAR EA 12922 AND ASA EA 5310 02823.SDR ASAA0843607Floorbeam · corrodedAFT CABIN FLOORBEAM STA 967 CORRODED RBL 40 TO LBL 40. CUT OUT DAMAGED AREA OF UPPER CHORD, FABRICATED REPAIR PARTS, LOCATED, DRILLED, INSTALLED REPAIR PARTS UPPER CHORD IAW B737 400 SRM 53 00 51 FIG 201.SDR K11A2008102372213Floorbeam · corrodedFLOORBEAM HAS CORROSION ON UPPER CHORD, UPPER SURFACE.SDR UPS08653343Stiffener · crackedINSPECTION TYPE:C MEC CABIN FLOORBEAM STA 246 LBL 20 VERT STIFFENER CRACK (CRACK LENGTH 1 INCH). VERT STIFFENER REPLACED AS PER SRM 53-10-51-2R FIG 201 REPAIR 3. UPS MPI P19868 RAISED FOR REPEAT DVI AT 3000 CYCLES OR 24 MONTHS WHICHEVER COMES FIRST.SDR 2008UALA05733Floorbeam · corrodedFWD GALLEY FLOORBEAM "A" HAS CORROSION AT FR16. MAJOR REPAIR ACCOMPLISHED. FABRICATED & INSTALLED REPAIR ANGLE.SDR 2008UALA05697Floorbeam · corrodedMAIN CABIN T-CAP AT BS 324, RBL 58, IS CORRODED BEYOND LIMITS. *S/D* MAJOR REPAIR ACCOMPLISHED. REMOVED DAMAGED SECTION OF T-CAP. FABRICATED & INSTALLED A NEW REPAIR SECTION.SDR KCS2008F00012Floorbeam · damagedFORWARD BILGE FLOORBEAM UPPER CHORD IS DAMAGED AT STA 600, RBL 21. (K)SDR UPS08653345Stiffener · crackedINSPECTION TYPE:C MEC CABIN FLOORBEAM STA 246 LBL 55 VERTICAL STIFFENER FOUND CRACK (CRACK LENGTH 1 INCH). VERT STIFFENER REPLACED AS PER SRM 53-10-51-2R FIG 201 REPAIR 3 UPS MPI P19867 RAISED FOR REPEAT DVI AT 3000 CYC OR 24 MONTHS, WHICHEVER COMES FIRST.SDR USAA920081745Floorbeam · corrodedCLT - MAJOR REPAIR - Q1 CHECK, LEVEL 2 CORROSION ON CABIN FLOORBEAM T-CAP AT BS 328, LBL 51. REPAIRED CABIN FLOORBEAM T-CAP AT BS 328, LBL 51 IAW US AIRWAYS EA 100632 AND B737 SRM 53-10-51 REPAIR 5.SDR 2008UALA05742Floorbeam · corrodedFWD GALLEY OUTBOARD "B" FLOORBEAM HAS ONE FOOT SECTION WITH CORROSION. MAJOR REPAIR ACCOMPLISHED. INSTALLED BRACKETS. INSTALLED MFG'ED BEAM. INSTALLED ALL WIRE BUNDLES AND SECURED ALL CLAMPS BEAM. FINAL INSTALLATION IS COMPLETE.SDR 2008UALA05668Floorbeam · corrodedFLOORBEAM - Y765 HAS CORROSION FWD OF FR68. MAJOR REPAIR ACCOMPLISHED. BEAMS REMOVED AND BRACKETS TRANSFERRED (BEAM 95 AND 150) BEAMS NEED TO BE SPLICED TOGETHER AND INSTALLED. SPLICE INSTALLED AND BEAMS 95 AND 150 INSTALLED.SDR SWAA085006Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND FLOORBEAM CHANNEL CRACKED AT BS 773, LBL 12. REPAIRED FLOORBEAM CHANNEL PER SWA EA.SDR DHLA2008745582Floorbeam · corrodedUPPER FUSELAGE MAIN CABIN BS 328 LBL 45 FLOORBEAM UPPER CHORD CORRODED. REPAIRED UPPER FUSELAGE FLOORBEAM UPPER CHORD SECTION AT BS 328 BETWEEN LBL 38.5 AND LBL 51.5 IAW B727 SRM 53-10-8 FIG 9.SDR KCSA081459Floorbeam · dentedBS 1820 FLOORBEAM UPPER CHORD DENTED BETWEEN LBL 1 AND RBL 3.SDR KCSA081457Floorbeam · damagedBULK PIT FLOORBEAM UPPER CHORD DAMAGED AT BS 2080, RBL 23SDR 08FDEA03796Floor Support · gougedDAMAGED FLOOR CAP AT FRAME 13 AND FWD; BL 0. REPAIRED DAMAGED FLOOR CAP IN REF TO SRM 51-71-50 & DWG A53612213.0SDR 08FDEA03798Floorbeam · crackedTHERE ARE TOOL MARKS ON THE FLOOR CAPS IN THE MAIN CABIN AT FRAME 11, LBL 20 TO RBL 10. REMOVED DAMAGE. MATERIAL ID FOR REPAIR. FABRICATED AND INSTALLED REPAIR IAW SRM 51-70-10. ALODINED AND PRIMED IAW AMM 51-75-10-8.SDR HNAA2008101700315Repair · corrodedUNRECORDED AND CORRODED REPAIR FOUND ON LT FLOORBEAM AT STATIONS 270.5 AND 240.5. REMOVED UNRECORDED REPAIR AND REPLACED WITH A REPAIR APPROVED BY EO8-53-08-3278. BRACKETS FABRICATED IN HOUSE IAW DRAWING NUMBER 85320044 AND INSTALLED IAW SRM 51-40-00.SDR 2008UALA05664Floorbeam · corrodedFLOORBEAM Y254 HAS CORROSION BETWEEN FR65 AND FR66 (MARKED). REPLACED BEAM 160. REPLACED FLOORBEAM 160.SDR 2008UALA05665Floorbeam · corrodedFLOORBEAM 145 HAS LOOSE RIVET(MARKED). MAJOR REPAIR ACCOMPLISHED. BEAM OUT AND ON BENCH WORKING. FOUND CORRODED BEAM REPLACED. ACP INSP OF BEAM 145.SDR 2008UALA05663Floorbeam · corrodedFLOORBEAM -Y1292 HAS CORROSION JUST AFT OF FR66. MAJOR REPAIR ACCOMPLISHED. REPLACED BEAM & SECURED WITH FASTENERS. ACP BEAM INSTALLATION FOR Y1292 FWD OF BEAM 140.SDR SWAA084967Floorbeam · corrodedDURING SCHEDULED 24Y CHECK, FOUND FLOORBEAM CORRODED AT BS 860, RBL 8. REPAIRED FLOORBEAM PER SWA EA.SDR K11A2008110472201Floorbeam · corrodedMAIN DECK, CORROSION ON BS 1110 FLOORBEAM UPPER CHORD AT RBL 62. CORROSION 2 X 1 INCHES.SDR 2008UALA05661Floorbeam · corrodedFLOORBEAM 190 HAS CORROSION AFT OF FR68 (MARKED). MAJOR REPAIR ACCOMPLISHED. STARTED REMOVING FASTENERS. BEAM REMOVED. STARTED INSTALLATION OF BEAMS 190 AND 195. SECURED NUT PLATES FOR FLOORBOARD. INSTALLATION IS COMPLETE.SDR 2008UALA05659Floorbeam · corrodedFLOORBEAM 195 HAS CORROSION ALONG LENGTH (MARKED). MAJOR REPAIR ACCOMPLISHED. STARTED REMOVING FASTENERS. REMOVED SEVERAL FASTENERS FROM BEAM 190 TO REMOVE BEAM 195. BEAM REMOVED. INSTALLED 8 NUT PLATES ON BEAM 195 FOR PNL 261FF. SECURED NUT PLATES FOR FSDR 2008UALA05658Floorbeam · corrodedFLOORBEAM 185 HAS CORROSION AT FR68 (MARKED). MAJOR REPAIR ACCOMPLISHED. REMOVED FLOORBEAM. BEAM OUT AND ON BENCH WORKING. STARTED INSTALLATION OF BRACKETS. RIVETING OF STANDOFF BRACKETS IS WHAT IS LEFT. DRILLED AND INSTALLED NEW BEAM 185. ALL BRACKETS SDR SWAA084938Floorbeam · corrodedDURING SCHEDULED SPV CHECK, FOUND FLOORBEAM CORRODED AT BS 967, RBL 30. REPAIRED FLOORBEAM PER SRM.SDR 08FDEA03755Floorbeam · corrodedCORROSION FOUND IN AFT CARGO COMPARTMENT AT CROSSBEAM C 60. SPLICE REPAIR PERFORMED IAW SRM 53-10-15 FIG 207.SDR KCSA081450Floorbeam · dentedBS 1720, BBL-0 FLOORBEAM UPPER T-CHORD DENTED. (K)SDR KCSA081480Floorbeam · dentedSTA 1720 BB L 0.00, FLOORBEAM UPPER "T" CHORD DENTED. (K)SDR DL757081184Floorbeam · damagedCABIN FLOOR BEAM UPPER CAP REQUIRES REPLACEMENT AT STA 1640 REPLACED CABIN FLOOR BEAMSDR 2008UALA05657Floorbeam · corrodedFLOORBEAM 175 HAS CORROSION ALONG LENGTH BETWEEN FR68 AND FR70. MAJOR REPAIR ACCOMPLISHED. REMOVED FLOORBEAM. INSTALLED LAV AND GALLEY MOUNT FITTINGS TO NEW FLOORBEAM. DRILLED AND INSTALLED BEAM.
SDR SWAA084929Floorbeam · corrodedDURING SCHEDULED 8Y CHECK, FOUND FLOORBEAM CORRODED AT BS 328, RBL 32.5 TO RBL 11. REPAIRED BEAM PER SWA EA.SDR SWAA084890Floorbeam · corrodedDURING SCHEDULED 24Y CHECK, FOUND FLOORBEAM CHORD CORRODED AT BS 294.5, LBL 10.5. REPAIRED FLOORBEAM CHORD PER SRM.SDR F3LA200800601Floorbeam · corrodedDURING C3 C-CHECK, INSPECTION NOTED SEVERAL NUT PLATE HOLES ON FRAME Y-1292 BETWEEN FRAME 66 AND FRAME 68 HAS CORROSION. MAINTENANCE REMOVED AND REPLACED FLOORBEAM IN ACCORDANCE WITH A319 SRM 51-42-11.SDR F3LA200800600Floorbeam · corrodedREF NON ROUTINE C050600. DURING C3 C-CHECK, INSPECTION NOTED FWD NUT PLATE HOLE ON FRAME Y-1292 AT FRAME 66, HAD CORROSION. MAINT REMOVED CORROSION FROM HOLE, FABRICATED REPAIR BUSHING AND INSTALLED IAW WITH THE REQUIREMENTS OF ENGINEERING AUTHORIZATION NR A9SDR F3L2008F00005Floor Support · corrodedREF: NON ROUTINE C050602. DURING C3 C-CHECK, INSPECTION NOTED SEVERAL NUT PLATE HOLES ON FRAME Y-1292 BETWEEN FRAME 66 AND FRAME 68, HAD CORROSION. MAINTENANCE REMOVED AND REPLACED FLOORBEAM IAW WITH THE REQUIREMENTS OF A319 SRM 51-42-11. UPON COMPLETION OF THSDR DL757081185Strap · damagedCABIN FLOORBEAM LOWER TORSION STRAP REQUIRES REPLACENT AT STA 1390 RBL 48SDR 2008UALA05660Floorbeam · corrodedFLOORBEAM 140 HAS CORROSION ON ENTIRE LENGTH. MAJOR REPAIR ACCOMPLISHED. BEAM OUT AND ON BENCH WORKING. FAB'D SPLICES FOR BEAMS FORE AND AFT PRIMED, SEALED & INSTALLED AFT END TO BEAM 145, FWD READY TO INSTALL. INSTALLED SPLICE TO BEAM 80. REPLACED BEAM ASDR DHLA2008745639Floorbeam · corrodedUPPER FUSELAGE MAIN CABIN FLOORBEAM UPPER CHORD WITH CORROSION AT BS 400 RBL 10. REPAIRED FLOORBEAM UPPER CHORD AT BS 400 BETWEEN RBL 2 AND RBL 19 IAW B727 SRM 53-10-8 FIG 8.SDR DHLA2008745583Floorbeam · crackedUPPER FUSELAGE MAIN CABIN AT BS 783.45 WL 202 RBL 54 FLOORBEAM WEB CRACKED. REPAIRED FUSELAGE WEB SECTION AT BS 783 WL202 FROM RBL 45.5 TO RBL 49.5 DUE TO CRACK IAW EO COO-2-53-267008 DTD 9/9/08 DOCUMENTED ON FAA FORM 8110-3.SDR 08FDEA03725Floorbeam · damagedTOOL MARK AT FLOOR SUPPORT MAIN CABIN STA 328 TOP OF FRAME APROX 11" FROM I/B EDGE OF LWR SILL. REMOVED PREVIOUS REPAIR IAW B727 SRM 51-30-2. CUTOUT DAMAGE AREA DIM 9 1/2 PER 2 INCH IAW B727 SRM 53-10-8 FIG 9. FABRICATED FILLER MAT USED 7075T6 0.071 AND 04 SDR DHLA2008745552Floorbeam · corrodedUPPER FUSELAGE PAX CABIN BS 950 BETWEEN LBL64 FLOORBEAM UPPER CHORD UPPER AND LOWER FACE CORROSION. REPAIRED UPPER FUSELAGE FLOORBEAM UPPER CHORD AT BS 950 BETWEEN RBL 30 TO RBL42 IAW COOPESA EO NR COO-2-52-268-08 DTD SEPT 11 2008 DOCUMENTED ON FAA FORM 8110-SDR F3LA200800599Floorbeam · corrodedREF NON ROUTINE C050605. DURING C3 C-CHECK, INSPECTION NOTED SEVERAL NUT PLATE HOLES ON FRAME Y-1292 BETWEEN FRAME 66 AND FRAME 68, HAD CORROSION. MAINT REMOVED CORROSION FROM HOLES, FABRICATED REPAIR PROFILE AND FILLER, AND INSTALLED IAW THE REQUIREMENTS OFSDR TRAX200801110Floorbeam · corrodedLT BS 280 BEAM CORRODED. 9/15/2008 - SUP- (RESOLVED W/O 99610 TASKCARD NR 00181) WORK COMPLETED IAW: INSTALLED DRUO TRAYS IAW SB 670BA-53-026.
Back to JASC 5315