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 A6WA200940394Floorbeam · crackedUPPER AFT ANGLE ON CROSSBEAM AT FS 280.00, LBL 9.0, WL 72.00 IS CRACKED. CRACK LENGTH IS .350. UPPER AFT ANGLE ON CROSSBEAM AT FS 280.00, LBL 9.00, WL 72.00. REPAIR IAW REO 601R-53-11-136, REV A. (K)SDR A6WA200940400Floorbeam · crackedCROSSBEAM AT FS 280.00, RBL 9.00, WL 71.00 IS CRACKED IN THE LOWER RADIUS. CROSSBEAM AT FS 280.00 RBL 9.00, WL 71.00 REPAIRED IAW REO 601R-53-11-171, REV D. (K)SDR USAA2009071691847Floorbeam · crackedCLT - Q-2 - MAJOR REPAIR - NR 03-0557-8-0242/001- CRACK IN FLOORBEAM AT BS660, BL0. REPAIRED FLOORBEAM AT BS660, BL0 IAW US AIRWAYS EA 101232 & WORK CARD M2C57002.SDR SWAA094252Floorbeam · corrodedDURING SCHEDULED 16Y CHECK, FOUND AFT CARGO LONGITUDINAL FLOORBEAM CORRODED AT BS 731D, LBL 3. REPAIRED BEAM PER SRM & EA.SDR SWAA094241Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND CENTER WING BOX FLOORBEAM CRACKED AT BS 727B, LBL 24.5. REPAIRED BEAM PER EA.SDR FDEA200906302424Floorbeam · misalignedWHILE DELETING PARTS IAW PTF PALLET MOD W/C, PRODUCTION FOUND NUMEROUS HOLES AT STA 1640. STA 1640, RBL 60-67, WHERE FLOORBEAM AND FRAME MEET, A FRAME REPAIR WAS ACCOMPLISHED DUE TO THE DISCREPANCY EFFECTING THE PTF CONVERSION, ON MAE MOD W/C 118330400EZ2R02,SDR SWAA094242Floorbeam · crackedDURING SCHEDULED HC1 CHECK, FOUND E&E COMPT FLOORBEAM CRACKED AT BS 328, RBL 50.5. REPAIRED BEAM PER SRM.SDR FDEA200906292386Floorbeam · corrodedAT BS 1600, LBL 4 FLOORBEAM SUPPORT ANGLE CORRODED. FOUND EXCEEDED SRM ALLOWABLE DAMAGE LIMITS. SUPPORT ANGLE REMOVED AND REPLACED IAW SRM 51-40-02 REV 97. REPAIR IS CLASSIFIED AS MINOR GMM 6-2-100 CRITERIA.SDR FDEA200906292383Floorbeam · corrodedSTA 310, BL-0, FLOOR UPPER CAP CORRODED. REMOVED T-CHORD, WEB, ANGLES, FABRICATED ON MAE TRAV NR T9/794577, T9/794578, T9/794579, AND EXTRUSION MAE REQ NR 2/794539. INSTALLED ALL REPAIR PARTS STA 310, LBL3- RBL38, IAW SRM 51-70-12, 51-40-02.CATEGORY "A", MAJOSDR USAA2009063091637Floorbeam · corrodedSAL - BC4 - MAJOR REPAIR - GALVANIC CORROSION ON FLOORBEAM IN PAX CABIN Y+165 LOCATED BETWEEN FR68 TO FR70. REPLACED FLOORBEAM IN PAX CABIN Y+165 LOCATED BETWEEN FR68 TO FR70 IAW A320 SRM 51-72-11.SDR CALA2009063000340Floorbeam · corrodedFLOORBEAM CORRODED STATION 947.5 AT RBL 50. INSTALLED FLOORBEAM REPAIR REF ECRA 5321-01433, REPLACED PREVIOUS FLOORBEAM REPAIR FROM RBL 26 TO RBL 58 AT STA 947.5.SDR CALA2009063000339Floorbeam · corrodedFLOORBEAM STATION 986.5 CORROSION RBL 30 AND RBL 44. REPLACED PREVIOUS REPAIR UPPER CHORD STATION 986.5 AT LBL 8 TO RBL 50 REF ECRA 5321-01430.SDR ASAA0996059Floorbeam · corrodedCORROSION FLOOR SUPPORT Z-CHANNEL BS 992 RBL 33-42 WL 208. REPLACED FLOOR SUPPORT IAW SRM.SDR ASAA0996058Floorbeam · corrodedCORROSION AFT CARGO BAY FLOORBEAM CORRODED AT FASTENER HOLE AT BS 727D+6 RBL 2.5 WL 156. REPAIRED PER SRM.SDR SWAA094226Floorbeam · corrodedDURING SCHEDULED 10Y CHECK, FOUND AFT CARGO COMPARTMENT FLOORBEAM CORRODED AT BS 772, LBL 2. REPAIRED FLOORBEAM PER EA.SDR SWAA094225Floorbeam · corrodedDURING SCHEDULED 10Y CHECK, FOUND AFT CARGO COMPARTMENT FLOORBEAM CORRODED AT BS 772, RBL 8. REPAIRED FLOORBEAM PER EA.SDR SWAA094224Floorbeam · corrodedDURING SCHEDULED 10Y CHECK, FOUND AFT CARGO COMPARTMENT FLOORBEAM CORRODED AT BS 772, RBL 2. REPAIRED FLOORBEAM PER EA.SDR SWAA094204Floorbeam · corrodedDURING SCHEDULED 22Y CHECK, FOUND FLOORBEAM UPPER CAP CORRODED AT BS 986, LBL 7. REPAIRED FLOORBEAM PER EA.SDR SWAA094190Floorbeam · corrodedDURING SCHEDULED 6Y CHECK, FOUND AFT CARGO COMPARTMENT FLOORBEAM CORRODED AT BS 773, RBL 8. REPAIRED FLOORBEAM PER EA.SDR SWAA094187Floorbeam · corrodedDURING SCHEDULED 6Y CHECK, FOUND AFT CARGO COMPARTMENT FLOORBEAM CORRODED AT BS 794, LBL 12. REPAIRED FLOORBEAM PER EA.SDR UALA2009062901834Floorbeam · crackedMAIN CABIN FLOORBEAM CRACKED STA 1439 AT LBL 25. MAJOR REPAIR ACCOMPLISHED: REMOVED DAMAGED FLOORBEAM LWR FLANGE. DAMAGED FROM BULK PIT HITTING IT. NO CRACK FOUND. INSTALLED FILLER DOUBLER REPAIR.SDR 2009FA0000583Floorbeam · corrodedOUT OF LIMITS CORROSION ON UPPER CHORD OF THE BS 294.5 FLOORBEAM AT RBL 11 AND RBL 14 WL 208.1.SDR USAA2009070991773Floorbeam · crackedCLT - Q2 - MAJOR REPAIR - CRACK ON FLOORBEAM AT BS 658, RBL 24.8. REPAIRED FLOORBEAM AT BS 658, RBL 24.8 IAW US AIRWAYS EA 101230.SDR FDEA200906252332Floorbeam · corrodedFORWARD ENTRY WAY - FLOORBEAM CORRODED AT BS 344 RBL 10 TO LBL 45. REMOVED FLOORBEAM, FABRICATED NEW FLOORBEAM AND INSTALLED IAW DWG SR27-53-007 AND SRM 53-10-2, 51-30-5 AND 51-30-2.SDR SWAA094123Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND FLOORBEAM UPPER CAP CRACKED AT BS 344, LBL 25 TO RBL 25. REPAIRED FLOORBEAM PER SRM.SDR USAA2009062591593Floorbeam · corrodedBFM - C19 - MAJOR REPAIR - LEVEL 2 CORROSION ON FLOORBEAM UPPER CHORD AT BS 967, RBL 18. REPAIRED FLOORBEAM UPPER CHORD AT BS 967, RBL 18 IAW B737 SRM 53-60-51.SDR SWAA094112Floorbeam · corrodedDURING SCHEDULED 6Y CHECK, FOUND AFT CARGO COMPT FLOORBEAM CORRODED AT BS 772, LBL13 TO RBL 13. REPAIRED BEAM PER SWA EA.SDR IPXA09656496Floorbeam · crackedINSPECTION TYPE:7C MAIN DECK BS 246 LBL 27 FLOORBEAM WEB FOUND CRACK. MAIN DECK BS 246 LBL 27 FLOORBEAM WEB REPAIRED AS PER HX RS NO. R53-15-36357 REV A. THIS REPAIR IS CLASSIFIED AS TIME LIMITED UNTIL JUN 25, 2010. PENDING COMPLETION OF THE FATIGUE AND DAMSDR CNMA20090012Floorbeam · corrodedCABIN FLOORBEAM BS 345 IS CORRODED ON UPPER FLANGE BETWEEN BL 0 AND RBL 70. REMOVED DAMAGED PART OF THE FLOORBEAM UPPER CHORD (REF NR37652) ASSEMBLED AND INSTALLED PARTS IAW SRM 53-00-51 FIG 201 DETAIL I.SDR CNMA20090011Floorbeam · corrodedCABIN FLOORBEAM AT BS 345 IS CORRODED ON UPPER FLANGE BETWEEN BL 0 AND LBL 24.75. REMOVED THE DAMAGED PART OF THE FLOORBEAM UPPER CHORD.
ASSEMBLED AND INSTALLED THE REPAIR PARTS IAW SRM 53-00-51 FIG 201 DETAIL I.SDR SWAA094097Floorbeam · corrodedDURING SCHEDULED 6Y CHECK, FOUND LONGITUDINAL FLOORBEAM CORRODED AT BS 797 TO BS 805 RBL 13. REPAIRED BEAM PER SWA EA.SDR FDEA200906232246Floorbeam · corrodedMCD FLOORBEAM AT STA 310, BETWEEN RBL 25 TO RBL 60, HAS CORROSION AROUND FASTENER HOLES. COMPLIED WITH EA F-5310-123995. FUSE, MAIN FRAME BS 310, RBL25 TO RBL 60, FLOORBEAM MINOR CORROSION BLEND REPAIR. MAJOR REPAIR.SDR USAA2009071391815Floorbeam · corrodedSAL - C7 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON FLOORBEAM BETWEEN FR20 TO FR23, -Y189. REPLACED FLOORBEAM BETWEEN FR20 TO FR23, -Y189 IAW SRM 51-72-11. THIS DISCREPANCY IS DETERMINED TO BE LEVEL 2 CORROSION.SDR A6WA200940359Floorbeam · crackedCRACK ON FLOORBEAM CLIP FS 280, LBL 9, INBD AND OTBD. FLOORBEAM CLIP REPLACED ON FS 280, LBL 9 INBD AND OTBD. (K)SDR USAA2009070991775Floorbeam · corrodedSAL - C7 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON FLOORBEAM BETWEEN FR67 TO FR69, Y1165. REPLACED FLOORBEAM BETWEEN FR67 TO FR69, Y1165 IAW SRM 51-72-11.SDR USAA2009070891756Floorbeam · corrodedSAL - C7 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON FLOORBEAM BETWEEN FR66 TO FR67, Y1195. REPLACED FLOORBEAM BETWEEN FR66 TO FR67,Y1195 IAW A320 SRM 51-72-11.SDR USAA2009070991765Floorbeam · corrodedSAL - C7 - MAJOR REPAIR - LEVEL 2 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 FDEA200906222519Floorbeam · corrodedAFT CARGO COMPT- FR60 CROSSBEAM WITH CORROSION BTW Y1300 AND Y1390. BEAM REPAIRED IAW SRM 53-10-15 FIG 207.SDR FDEA200906222209Floorbeam · corrodedMAIN CABIN FLOORBEAM STA 720, LBL- 62, HAS AREA OF CORRODED FUSE, MAIN FRAME BS- 720 FLOORBEAM MINOR CORROSION BLEND REPAIR, COMPLIED WITH EA F-5310-123996, LBL- 62. CATEGORY "A", MAJOR REPAIR.SDR SWAA094062Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 660, BL 0. REPAIRED BEAM PER ER.SDR SWAA094049Floorbeam · crackedDURING SCHEDULED HC1 CHECK, FOUND AFT E/E COMPT RIGHT I/B FLOORBEAM CRACKED AT BS 328, RBL 40.5. REPAIRED BEAM PER SRM.SDR SWAA094048Floorbeam · crackedDURING SCHEDULED HC1 CHECK, FOUND AFT E/E COMPT RIGHT O/B FLOORBEAM CRACKED AT BS 328, RBL 50.5. REPAIRED BEAM PER SRM.SDR MZZA2009062300081Floorbeam · corrodedFWD PASSENGER COMPARTMENT FLOOR STRUCTURE WET AREA FLOORBEAM AT BS 328 WITH CORROSION AT RBL35.6. REPAIR CARRIED OUT IAW EC/RA 5321-01650 REV B.SDR ASOA200900686Floorbeam · corrodedOPERATION 367/CONTINUATION OF JOB 8765821 OP 264, FLOOR BEAM AT LBL 27 OTBD FLANGE IS CORRODED AROUND NUTPLATE FOR FLOORBOARD SCREWS FS 559+80 TO FS 621.0.SDR USAA2009062491584Floorbeam · corrodedBFM - C19 - MAJOR REPAIR - LEVEL 2 CORROSION ON FLOORBEAM AT BS 986.5, WL 208.1, RBL 18. REPAIRED FLOORBEAM AT BS 986.5, WL 208.1, RBL 18 IAW B737 SRM 53-60-51 & 53-00-51.SDR MZZA2009062300080Floorbeam · crackedPASSENGER CABIN COMPARTMENT FLOOR SUPPORT STRUCTURE BRACKET FOUND CRACKED AT BS 536.5, LBL 5.5. PART REPLACED IAW EC/RA 5321-01653.SDR MZZA2009062300079Floorbeam · corrodedAFT PASSENGER WET AREA FLOORBEAM AT BS 967 FOUND WITH CORROSION AT SCREW HOLES AT LBL 47.5 BS 967. FLOORBEAM UPPER CAP REPAIR WAS CARRIED OUT IAW EC/RA NR 53 21-01657 REV B.SDR MZZA2009062300078Floorbeam · corrodedCORROSION FOUND AT FWD WET AREA ON CHANNEL ASSY AT BS 344, RBL 1 AROUND SCREW HOLE AREA. REPAIR CARRIED OUT PER EC/RA NR 5321-01648 REV A.SDR SWAA094032Floorbeam · corrodedDURING SCHEDULED 22Y CHECK, FOUND FLOORBEAM CORRODED AT BS 947, RBL 52. REPAIRED BEAM PER SRM.SDR SWAA093988Floorbeam · corrodedDURING SCHEDULED 8Y CHECK, FOUND FLOORBEAM CORRODED AT BS 294.5, RBL 12. REPAIRED FLOORBEAM PER SWA EA.
Back to JASC 5315