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 FDEA201007132502Floorbeam · corrodedCABIN FLOOR FRAME T-CAP AT STA 377.7 FROM LBL 50.22 TO BL-0 CORRODED. REMOVED CORROSION STA 377 UPPER CHORD IAW SRM 51-10-02. REMOVED .017 FROM ORIG MATERIAL .125 FOUND TO BE OUT OF LIMITS IAW SRM 53-00-51, FIG 101, DETAIL III. L=2.0 W=.1.5. R & R UPPER CHOSDR USAA2010071991451Floorbeam · corrodedPIT - MAJOR REPAIR - S4 - LEVEL 2 GALVANIC CORROSION ON FLOORBEAM BETWEEN FR 64-66 AND FR 68 -70 STR 23R, BL -Y1292. REPLACED FLOORBEAM BETWEEN FR 64-66 AND FR 68 -70 STR 23R, BL -Y1292 IAW A319 SRM 51-72-11.SDR USAA2010071991446Floorbeam · corrodedPIT - MAJOR REPAIR - S4 - LEVEL 2 GALVANIC CORROSION ON FLOORBEAM BETWEEN FR 66-68, STR 23R, BL -Y1160. REPLACED FLOORBEAM BETWEEN FR 66-68, STR 23R, BL -Y1160 IAW A319 SRM 51-72-11.SDR R61A20100334Floorbeam · corrodedGENERATED WHILE A/C WAS IN HEAVY CHECK. LT FLOORBEAM CORRODED AT FR 87. MAINTENANCE REMOVED AND REPLACED FLOORBEAM IAW EMB 170 SRM 51-40-02, 51-40-00, AND 51-43-01.SDR QXEA2010071300410Floorbeam · corrodedC-CHECK. FOUND CORROSION ON FLOOR SUPPORT ANGLE AT FS 280 FOR PANEL 141 ALF. REMOVED CORROSION FROM FLOOR SUPPORT ANGLE FOUND TO BE OUT OF LIMITS. REMOVED FLOOR ANGLE IAW IAW SRM 51-42-06-001-001-A01. LOCATED FASTENER HOLES IN NEW ANGLE IAW SRM 51-40-11-00SDR SWAA104075Floorbeam · crackedDURING SCHEDULED 14Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 672, LBL 24.8. REPAIRED BEAM PER SRM.SDR SWAA104062Floorbeam · corrodedDURING SCHEDULED 16Y CHECK, FOUND FLOORBEAM CORRODED AT BS 328, LBL 28. REPAIRED BEAM PER SRM.SDR SWAA104046Floorbeam · corrodedDURING SCHEDULED 10Y CHECK, FOUND FLOORBEAM CORRODED AT BS 772, LBL 12. REPAIRED BEAM PER EA.SDR SWAA104045Floorbeam · corrodedDURING SCHEDULED 10Y CHECK, FOUND FLOORBEAM CORRODED AT BS 772, LBL 17. REPAIRED BEAM PER EA.SDR SWAA104044Floorbeam · corrodedDURING SCHEDULED 10Y CHECK, FOUND FLOORBEAM CORRODED AT BS 772, RBL 14. REPAIRED BEAM PER EA.SDR SWAA104043Floorbeam · corrodedDURING SCHEDULED 10Y CHECK, FOUND FLOORBEAM CORRODED AT BS 772, RBL 8. REPAIRED BEAM PER EA.SDR SWAA104042Floorbeam · corrodedDURING SCHEDULED 10Y CHECK, FOUND FLOORBEAM CORRODED AT BS 772, RBL 3. REPAIRED BEAM PER EA.SDR K11A2010071072209Floorbeam · corrodedFLOORBEAM UPPER CHORD CORROSION 3 INCHES.SDR K11A2010071072203Floorbeam · corrodedFLOORBEAM UPPER CHORD CORROSION 5 INCHES.SDR K11A2010070972209Floorbeam · corrodedFLOORBEAM CORROSION 57 INCHES.SDR K11A2010070972207Floorbeam · corrodedFLOORBEAM CORROSION 50 INCHES.SDR YENA20100709099Floorbeam · corrodedFLT 6420 ON HEAVY MAINTENANCE VISIT AT BNA, UPON INSPECTION FOUND CORROSION ON RT FLOORBEAM TRACK AT FRAME 13, FRAME 14, FRAME 15, FRAME 16 AND FRAME 17. FABRICATED, REPAIRED DOUBLER AND REPAIRED CABIN FLOORBEAMS AS PER EA E10-342-01 REF EAMS NR H14.SDR YENA20100709098Floorbeam · corrodedFLT 6420, ON HEAVY MAINTENANCE VISIT AT BNA, UPON INSPECTION FOUND CORROSION ON LT FLOORBEAM TRACK AT FRAME 14, FRAME 15, FRAME 16 FRAME 17, AND FRAME 19. FABRICATED REPAIRED DOUBLER AND REPAIRED CABIN FLOORBEAMS AS PER EA E10-342-01 REF EAMS NR H1479.SDR UALA2010070902451Floorbeam · corrodedCORROSION FOUND ON FLOORBEAMS FRAME 24 DURING FLOORBOARD REPLACEMENT. THREE (3) EA FLOORBEAMS EXTENSIVE CORROSION. EXFOLIATION CORROSION FOUND BETWEEN FRAME 21 AND FRAME 24 ON RT SIDE FLOOR RAIL Y-765 APPROX 4 INCHES LONG BY 1 INCH WIDE. CORROSION FOUND ON SDR K11A2010070872203Floor Support · corrodedFLOOR SUPPORT CORRODED 18 INCHES.SDR FDEA201007082420Floorbeam · corrodedCABIN FLOORBEAM AT STA 700 IN BETWEEN LBL 45.50 AND 58.22 CORRODED. REMOVED CORROSION IAW SRM 51-10-02 BLENDED AREA ORIG. MAT. .125 MAT LOSS .009", L=.014", W=2.050", D=.009". FOUND TO BE WITHIN LIMIT IAW SRM 53-00-51 FIG 101 DETAIL II. TREATED & PRIMED FLOOSDR ASOA201000999Floorbeam · crackedFS 280.00 FLOOR SUPPORT CLIPS AT RBL & LBL 9 INBD & OTBD ARE CRACKED. REMOVED CLIPS (4 EA) IAW SRM 51-42-21. LOCATED AND DRILLED FS 280, LBL 9 INBD AND OTBD CLIPS AND RBL 9 INBD CLIP IAW SRM 51-40-11. INSTALLED CLIPS IAW SRM 51-42-21. FOUND FS 280, RBL 9 OTBSDR ASOA201000998Floorbeam · corrodedFLOORBEAM CAP AT LBL 27 FS 621.00 TO FS 574.00 IS CORRODED. REMOVED FLOORBEAM CAP AT LBL 27 FS 621-574 BY REMOVING ALL FASTENERS IAW SRM 51-42-06 AND 51-42-21. LOCATED AND DRILLED NEW SERVICEABLE CAP IAW SRM 51-40-11. INSTALLED BEAM CAP IAW SRM 51-42-21 ASDR ASOA201000997Floorbeam · corrodedFLOORBEAM CAP AT LBL 9 FS 621.00 TO FS 574.00 IS CORRODED. FOUND 80 PERCENT MATERIAL LOSS ON FLOORBEAM CAP AT LBL 9, FS 589 BRINGING CAP OUT OF LIMITS IAW IAW SRM 53-61-43. REMOVED MS20470AD RIVETS FROM FLOORBEAM CAP AT LBL 9, FS 574 TO 621 IAW SRM 51-42-06.SDR SWAA104037Support · corrodedDURING SCHEDULED 10Y CHECK, FOUND AFT CARGO FLOORBEAM SUPPORT CORRODED BS 772, RBL 7.5. REMOVED AND REPLACED BEAM PER EA.SDR SWAA104036Support · corrodedDURING SCHEDULED 10Y CHECK, FOUND AFT CARGO FLOORBEAM SUPPORT CORRODED BS 772, RBL 2.5. REMOVED AND REPLACED BEAM PER EA.SDR SWAA104035Support · corrodedDURING SCHEDULED 10Y CHECK, FOUND AFT CARGO FLOORBEAM SUPPORT CORRODED BS 772, LBL 12. REMOVED AND REPLACED BEAM PER EA.SDR SWAA104034Support · corrodedDURING SCHEDULED 10Y CHECK, FOUND AFT CARGO FLOORBEAM SUPPORT CORRODED BS 772, LBL 7.5. REMOVED AND REPLACED BEAM PER EA.SDR SWAA104033Support · corrodedDURING SCHEDULED 10Y CHECK, FOUND AFT CARGO FLOORBEAM SUPPORT CORRODED BS 772, LBL 2.5. REMOVED AND REPLACED BEAM PER EA.SDR SWAA104032Support · corrodedDURING SCHEDULED 10Y CHECK, FOUND AFT CARGO FLOORBEAM SUPPORT CORRODED BETWEEN BS 727 TO BS 736B, RBL 13. REMOVED AND REPLACED BEAM PER SRM AND BAC DWG.SDR FDEA201007082419Floorbeam · corrodedCABIN FLOORBEAM PANEL HOLES AT STA 740 BETWEEN LBL-24.75 AND LBL-58-22 HAS CORROSION. REMOVED CORROSION IAW SRM 51-10-02. BLEND OUT DIM L=8.0 W=2.0 D=.016. ORIG MATERIAL .125 AFTER REWORK .109 FOUND OUT OF LIMITS IAW SRM 53-00-51 FIG 101 DETAIL III. REPASDR USAA2010070991390Floorbeam · corrodedCLT - RON - MAJOR REPAIR - CORROSION ON FLOORBEAM BETWEEN FR66 TO FR68, Y1292. REPLACED FLOORBEAM BETWEEN FR66 TO FR68, Y1292 IAW AIRBUS DRAWING D5347217220290.SDR USAA2010070991389Floorbeam · corrodedCLT - RON - MAJOR REPAIR - CORROSION ON FLOORBEAM BETWEEN FR66 TO FR68, -Y140. REPLACED FLOORBEAM BETWEEN FR66 TO FR68 IAW AIRBUS DRAWING D534721722039.SDR USAA2010070991388Floorbeam · corrodedCLT - RON - MAJOR REPAIR - CORROSION ON FLOORBEAM AT FR67, -Y765. REPLACED FLOORBEAM AT FR67, -Y765 IAW AIRBUS DRAWING D5347209300000.SDR USAA2010070891379Floorbeam · corrodedCLT - RON - MAJOR REPAIR - CORROSION ON FLOORBEAM BETWEEN FR68 TO FR69, -Y1292. REPLACED FLOORBEAM BETWEEN FR68 TO FR69, -Y1292 IAW AIRBUS DRAWING D5347218920400.SDR USAA2010070891378Floorbeam · corrodedCLT - RON - MAJOR REPAIR - CORROSION ON FLOORBEAM AT FR66, Y1292. REPLACED FLOORBEAM AT FR66, Y1292 IAW AIRBUS DRAWING D5347209001000.SDR USAA2010070891377Floorbeam · corrodedCLT - RON - MAJOR REPAIR - CORROSION ON FLOORBEAM AT FR68, Y1292. REPLACED FLOOR BEAM AT FR68, Y1292 IAW AIRBUS DRAWING D5347214220000.SDR USAA2010070891376Floorbeam · corrodedCLT - RON - MAJOR REPAIR - CORROSION ON FLOORBEAM AT FR67, Y765. REPLACED FLOORBEAM AT FR67, Y765 IAW AIRBUS DRAWING D5347219220000.SDR FDEA201007072395Floorbeam · corrodedMAIN DECK CARGO COMPT FLOORBEAM CORRODED ON UPPER SURFACE,FR 14 AT SEAT TRACK 3 LT REMOVED LEVEL 1CORROSION. REMOVED, FABRICATED REPLACEMENT TRACK SECTION AND REPLACED DAMAGED SECTION OF TRACK NR3 LT BETWEEN FR 10 AND FR 15A IAW SRM 51-72-10 AND SRM 53-12-15.SDR FDEA201007072382Floorbeam · crackedFWD CARGO COMPT. MAIN DECK FLOORBEAM FR 36 , 0.25 INCH CRACK ON FRAME JUST BELOW UPPER T CAP, BETWEEN SEAT TRACKS 4L-5L CUT OUT CRACKAND BLENDED AREA IAW A310 SRM 51-27-11, NDT CHECKED IAW NTM FOR CRACKS NO CRACK NOTED. REPAIRED CROSS BEAM IAW A310 SRM 53SDR FDEA201007062370Floorbeam · crackedAFT CARGO COMPARTMENT UPPER MCD FLOORBEAM IS CRACKED AT FRAME 54.3; RT SIDE. REPAIRED FLOORBEAM IN REF TO SRM SUPPLEMENT 53-10-15 FIG. 201SDR SWIA201024497Floorbeam · corrodedFS 280 FLOORBEAM SUPPORT CORRODED. (C CHECK) REPLACE PER SRM.SDR SWAA103980Floorbeam · crackedDURING SCHEDULED 26Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED BETWEEN BS 706 TO BS 717, BL 0. REPAIRED BEAM PER SRM.SDR SWAA103971Floorbeam · corrodedDURING SCHEDULED 6Y CHECK, FOUND FLOORBEAM CORRODED AT BS 767, RBL 3. REPAIRED BEAM PER EA.SDR SWAA103970Floorbeam · corrodedDURING SCHEDULED 6Y CHECK, FOUND FLOORBEAM CORRODED AT BS 767, RBL 8. REPAIRED BEAM PER EA.SDR SWAA103969Floorbeam · corrodedDURING SCHEDULED 6Y CHECK, FOUND FLOORBEAM CORRODED BETWEEN BS 731D, TO BS 807, RBL 8. REPAIRED BEAM PER EA.SDR SWAA103942Floorbeam · crackedDURING SCHEDULED 16Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 727B, LBL 24.8. REPAIRED BEAM PER EO.SDR TRBACPCP2010045Floorbeam · corrodedFR 30, RT TO FR, LT TOP OF FLOORBEAM HAS CORROSION REF CRIC 006659. R & R DAMAGED SECTION OF FRAME 30, FLOORBEAM IAW ATR 72, SRM 51-25-04 & 51-25-01 REF FORM PL-004-2R1.SDR TRBACPCP2010041AFloorbeam · corrodedFR 30 RT TO LT TOP OF FLOORBEAM HAS CORROSION CRIC006659/ATR FORM. R & R DAMAGED SECTION OF FRAME 30 FLOORBEAM IAW SRM 51-25-04 & 51-25-01 REF FORM PL-004-2R1.SDR IPXA10561109Floorbeam · corrodedINSPECTION TYPE:C4, MAIN CARGO FLOOR SUPPORT HAS CORROSION STA 900, RBL 4, WL 208. REPLACED IAW SRM 51-40-02-0G, SRM 51-40-06-0G, SRM 51-40-05-0G, DWG NR 144N5003, SOPM 20-41-02, SRM 51-10-02-0G, STEP 8 C.
Back to JASC 5315