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 USAA2009030390494Floorbeam · corrodedPIT - S4 - MAJOR REPAIR - LEVEL 2 FILIFORM CORROSION ON FLOORBEAM BETWEEN FR16 TO FR20, Y1292. REPLACED FLOORBEAM BETWEEN FR16 TO FR20, Y1292 IAW A319 SRM 51-71-11.SDR AALA20090304TUL05Floorbeam · corrodedTOP OF FLOORBEAM CORRODED STATION 986. INSTALLED FLOORBEAM DOUBLER TOP CHORD REPAIR PER SRM 53-70-51-2R-4.SDR EIAA20090046SUPFloorbeam · damagedMAIN DECK FLOORBEAM UPPER CHORD BS 520 LBL 80 HAS 2 DOUBLE DRILLED HOLES. FABBED AND INSTALLED REPAIR PER B747 SRM 53-10-07 FIG 10.SDR EIAA20090045SUPFloorbeam · damagedHOLE IN FLOORBEAM BS 420 UPPER DECK CENTER HAS NO EDGE DISTANCE. FABBED AND INSTALLED REPAIR FLOORBEAM LWR CHORD STA 4020 CENTER PER B747 SRM 51-30-02 PG 8-9.SDR EIAA20090046Floorbeam · damagedMAIN DECK FLOORBEAM UPPER CHORD BS 520 LBL 80 HAS 2 DOUBLE DRILLED HOLES. FABBED AND INSTALLED REPAIR PER B747 SRM 53-10-07 FIG 10.SDR EIAA20090045Floorbeam · damagedHOLE IN FLOORBEAM BS 420 UPPER DECK CENTER HAS NO EDGE DISTANCE. FABBED AND INSTALLED REPAIR FLOORBEAM LWR CHORD STA 4020 CENTER PER B747 SRM 51-30-02 PG 8-9.SDR FDEA200902280770Floorbeam · corrodedFWD CARGO COMPT AREA INP SEVERE CORROSION ON BEAM LOWER PANEL FLOOR. REPAIRED BEAM IAW SRM 53-00-01, FIG 9, SHT 8, VOL I AND SRM 53-70-00, FIG 18, VOL I.SDR CA090306002Floorbeam · corroded(CAN) AFT GALLEY FLOOR AREA WAS FOUND WITHOUT SEALANT BETWEEN THE FLOORBOARDS. WITH FLOORBOARDS REMOVED, CORROSION WAS DISCOVERED ON SEVERAL FLOORBEAMS, SEAT TRACKS AND SHEAR PLATES.SDR USAA2009031690607Floorbeam · corrodedSAL - C2 - MAJOR REPAIR - GALVANIC CORROSION ON FLOORBEAM BETWEEN FR66 TO FR70, Y765. REPLACED FLOORBEAM BETWEEN FR66 TO FR70, Y765 IAW A320 SRM 51-72-11.SDR USAA2009031290583Floorbeam · corrodedSAL - C2 - MAJOR REPAIR - GALVANIC CORROSION ON FLOORBEAM BETWEEN FR67 + 16 INCHES TO FR69 + 4 INCHES, -Y1165. REPLACED FLOORBEAM BETWEEN FR67 + 16 INCHES TO FR69 + 4 INCHES, -Y1165 IAW A320 SRM 51-72-11.SDR USAA2009031290582Floorbeam · corrodedSAL - C2 - MAJOR REPAIR - GALVANIC CORROSION ON FLOORBEAM BETWEEN FR66 + 5 INCHES TO FR67 + 16 INCHES, Y1295. REPLACED FLOORBEAM BETWEEN FR66 + 5 INCHES TO FR67 + 16 INCHES, Y1295 IAW A320 SRM 51-72-11.SDR USAA2009031290581Floorbeam · corrodedSAL - C2 - MAJOR REPAIR - GALVANIC CORROSION ON FLOORBEAM BETWEEN FR66 + 5 INCHES TO FR70, -Y765. REPLACED FLOORBEAM BETWEEN FR66 + 5 INCHES TO FR70, -Y765 IAW A320 SRM 51-72-11.SDR USAA2009031290580Floorbeam · corrodedSAL - C2 - MAJOR REPAIR - GALVANIC CORROSION ON FLOORBEAM BETWEEN FR64 TO FR66, Y1292. REPLACED FLOORBEAM BETWEEN FR64 TO FR66, Y1292 IAW A320 SRM 51-72-11.SDR USAA2009031290579Floorbeam · corrodedSAL - C2 - MAJOR REPAIR - GALVANIC CORROSION ON FLOORBEAM BETWEEN FR68 TO FR70, Y1162. REPLACED FLOORBEAM BETWEEN FR68 TO FR70, Y1162 IAW A320 SRM 51-72-11.SDR USAA2009031290578Floorbeam · corrodedSAL - C2 - MAJOR REPAIR - GALVANIC CORROSION ON FLOORBEAM ASSEMBLY BETWEEN FR65 TO FR66, -Y1465. REPLACED FLOORBEAM ASSEMBLY BETWEEN FR65 TO FR66, -Y1465 IAW A320 SRM 51-72-11.SDR USAA2009031290577Floorbeam · corrodedSAL - C2 - MAJOR REPAIR - GALVANIC CORROSION ON SEAT BEAM BETWEEN FR64 TO FR66 + 5 INCHES, -Y1292. REPLACED SEAT BEAM BETWEEN FR64 TO FR66 + 5 INCHES, -Y1292 IAW A320 SRM 51-72-11.SDR USAA2009031290576Floorbeam · corrodedSAL - C2 - MAJOR REPAIR - GALVANIC CORROSION ON FLOORBEAM HARD POINT BETWEEN FR65 TO FR67, Y920. REPLACED FLOORBEAM HARD POINT BETWEEN FR65 TO FR67, Y920 IAW A320 SRM 51-72-11.SDR USAA2009031290575Floorbeam · corrodedSAL - C2 - MAJOR REPAIR - GALVANIC CORROSION ON FLOORBEAM BETWEEN FR66 + 5 INCHES TO FR67 +16 INCHES, -Y1245. REPLACED FLOORBEAM BETWEEN FR66 + 5 INCHES TO FR67 +16 INCHES, -Y1245 IAW A320 SRM 51-72-11.SDR A6WA200940091Floorbeam · crackedUPPER AFT ANGLE AT FS 280.00, LBL 9.0 FOUND CRACKED (CRACK LENGTH 1.000 IN). REPAIR PERFORMED AT UPPER AFT ANGLE AT FS 280.00, LBL 9.0 IAW REO 601R 53-11-138 REV, NC. (K)SDR USAA2009030290486Floorbeam · corrodedPIT - S4 - MAJOR REPAIR - LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM AT FR16, Y254. REPLACED FLOORBEAM AT FR16, Y254 IAW A319 SRM 51-72-00.SDR FDEA200902270749Floorbeam · corrodedMAIN CABIN FLOORBEAM FR 14 LT, Y1600 HAS CORROSION ON TOP CAP. .030 IN DEEP BY 2.50 IN BY .500 IN. REMOVED LEVEL 1 CORROSION. REWORKED AREA AFTER CORROSION REMOVED AND INSTALLED FLOOR CROSSBEAM FLANGE REPAIR AT FR 14 LT, Y1600 IAW A310 SRM 53-12-15, FIG 206SDR SWIA200921887Floorbeam · corrodedFS 280 FLOORBEAM CORRODED. (C CHECK) REPAIRED PER REO.SDR USAA2009022790467Strap · crackedCLT - Q4 - MAJOR REPAIR - CRACK ON FLOORBEAM STRAP AT BS 312 & BS 328, BL 0. REPLACED FLOORBEAM STRAP AT BS 312 & BS 328, BL 0 IAW B737 SRM 51-10-02.SDR USAA2009022790466Strap · crackedCLT - Q4 - MAJOR REPAIR - CRACK ON FLOORBEAM STRAP AT BS 312, LBL 12. REPLACED FLOORBEAM STRAP AT BS 312, LBL 12 IAW B737 SRM 51-10-02.SDR USAA2009022790462Strap · crackedCLT - Q4 - MAJOR REPAIR - CRACK ON FLOORBEAM STRAP BETWEEN BS 312 TO BS 344, LBL 45. REPLACED FLOORBEAM STRAP BETWEEN BS 312 TO BS 344, LBL 45 IAW B737 SRM 51-10-02.SDR DU4R2009305Floorbeam · corrodedS/O 312003 N/R 25935 DURING SCHEDULED INSPECTION, FOUND CORROSION ON FLOORBEAM AT BS 1006 AFT TO 1040 BL 25R.SDR DU4R2009304Floorbeam · corrodedS/O 312003 N/R 25934 DURING SCHEDULED INSPECTION, FOUND CORROSION ON FLOORBEAM AT BS 1006 TO 1040 BL 16R AFT TO PRESSURE BULKHEAD.SDR CALA2009022700116Floorbeam · corrodedCORROSION AT THE TOP FLANGE OF FLOORBEAM STATION 1640 BL 0. REPAIRED PER ECRA 5321-01609.SDR AALA2009022500228Floorbeam · corrodedFLOOR STRAP CORRODED AT MOUNT HOLE STATION 1023 AT LT BODY LINE 18. REMOVED AND REPLACED STRAP IAW SRM 51-10-02 AT LT BODY LINE 18 STA 1023.SDR USAA2009030290485Floorbeam · corrodedPIT - S4 - MAJOR REPAIR - LEVEL 2 FILIFORM CORROSION ON FLOORBEAM BETWEEN FR66 TO FR68 & BETWEEN Y1162 TO Y1292. REPLACED FLOORBEAM BETWEEN FR66 TO FR68 & BETWEEN Y1162 TO Y1292 IAW A319 SRM 51-72-11.SDR USAA2009030290484Floorbeam · corrodedPIT - S4 - MAJOR REPAIR - LEVEL 2 FILIFORM CORROSION ON FLOORBEAM BETWEEN FR66 TO FR68 & BETWEEN Y1162 TO Y1292. REPLACED FLOORBEAM BETWEEN FR66 TO FR68 & BETWEEN Y1162 TO Y1292 IAW A319 SRM 51-72-11.SDR USAA2009022790456Floorbeam · corrodedPIT - S4 - MAJOR REPAIR - LEVEL 2 FILIFORM CORROSION ON FLOORBEAM BETWEEN FR66 TO FR68 & BETWEEN Y1162 TO Y1292. REPLACED FLOORBEAM BETWEEN FR66 TO FR68 & BETWEEN Y1162 TO Y1292 IAW A319 SRM 51-72-11.SDR ASAA0944519Floorbeam · corrodedCORROSION ON FLOORBEAM. REMOVED UPPER CHORD AND INSTALLED REPAIR CHORD SECTION AND SPLICES.SDR ASAA0944518Floorbeam · corrodedCORROSION ON FLOORBEAM. REMOVED TOP CHORD OF FLOORBEAM, FABRICATED REPAIR PARTS AND NEW TOP CHORD AND INSTALLED PER SRM 53-10-51.SDR ASAA0944517Floorbeam · corrodedBS 986 FLOORBEAM UPPER CAP CORRODED. REPAIRED FLOORBEAM PER ER 09-1817-EA-400-53EA-00969.SDR USAA2009022790458Floorbeam · corrodedPIT - S4 - MAJOR REPAIR - LEVEL 2 FILIFORM CORROSION ON FLOORBEAM BETWEEN FR67 TO FR68, -Y765. REPLACED FLOORBEAM BETWEEN FR67 TO FR68, -Y765 IAW A319 SRM 51-72-11.SDR USAA2009022790457Floorbeam · corrodedPIT - S4 - MAJOR REPAIR - LEVEL 2 FILIFORM CORROSION ON FLOORBEAM BETWEEN FR12 TO FR16, Y503. REPLACED FLOORBEAM BETWEEN FR12 TO FR16, Y503 IAW A319 SRM 51-72-00.SDR SWIA200921336Floorbeam · crackedC-CHECK, FS 280 FLOOR SUPPORT ANGLE CRACKED. REPAIRED PER REO.SDR SWIA200921335Floorbeam · crackedDURING C-CHECK, FS 280 FLOOR SUPPORT CRACKED IN RADIUS. REPAIRED PER SRM.SDR EIAA20090043SUPFloorbeam · damagedMAIN CABIN BS 820, BL 84, WATER LINE 199 FLOORBEAM UPPER CHORD DOUBLE DRILLED HOLE. FABBED REPAIR AND INSTALLED PER B747 SRM 53-10-07 FIG 10.SDR EIAA20090043Floorbeam · damagedMAIN CABIN BS 820, BL 84, WATER LINE 199 FLOORBEAM UPPER CHORD DOUBLE DRILLED HOLE. FABBED REPAIR AND INSTALLED PER B747 SRM 53-10-07 FIG 10.SDR FDEA200902240696Floorbeam · corrodedFOUND TOP CAP BEAM HEAVY CORRODED ON C 60 REPAIR PERFORMED BY REPLACEMENT OF PART IAW SRM 51-72-10.SDR FDEA200902240691Floorbeam · corrodedFOUND CORROSION ON CROSS BEAM C 58 RT SLICE REPAIR PERFORMED IAW SRM 53-10-15 FIG 207 A.SDR SWIA200921885Floorbeam · corrodedFS 280 FLOORBEAM CORRODED. (C CHECK) REPAIRED PER REO.SDR FDEA200902230871Floorbeam · gougedMAIN CABIN FLOOR SUPPORT FITTING GOUGED FR48 LBL 17.5 FABRICATED 1 EA SUPPORT BRACKET IAW AIRBUS DWG A53812968 REV A AND SRM 51-21-10. DRILLED UP SUPPORT BRACKET IAW AIRBUS DWG A53812968 REV A. TOP COATED IAW SRM 51-23-10. PART MARKED SUPPORT BRACKET IAW GSDR HALA2009022300080Floorbeam · corrodedCORROSION ON TOP SURFACE OF FLOORBEAM AT STA 349 + RBL 44. REPLACED DAMAGED STRUCTURE PER SRM 53-00-51, FIG 201, SRM 51-40-02, AND BOEING DRAWING 1412200.SDR SWAA091273Attach Angle · crackedDURING SCHEDULED 24Y CHECK, FOUND LONGITUDINAL FLOORBEAM ATTACH ANGLE CRACKED AT BS 639, RBL 45.5. REMOVED AND REPLACED ANGLE PER SRM & ER.SDR SWAA091262Floorbeam · corrodedDURING SCHEDULED 20Y CHECK, FOUND FLOORBEAM CORRODED AT BS 732, RBL 3. REPAIRED BEAM PER EA.SDR SWAA091261Floorbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 656+16, LBL 25.5. REPAIRED BEAM PER EA.SDR FDEA200902230671Floorbeam · corrodedMAIN CABIN FLOORBEAM UPPER CHORD LOWER SURFACE HAS CORROSION, STA 1681. MAIN CABIN FLOORBEAM UPPER CHORD REPAIRED IAW EA 757-5365-16-F1710 REV-C AT STA 1681, LBL- 58, TO RBL- 58. REPAIR CLASSIFIED AS MAJOR ALTERATION.
Back to JASC 5315