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 UPS09554593Floorbeam · corrodedINSPECTION TYPE:C3 FLOORBEAM BS 620 HAS CORROSION ON TOP SURFACE AT RBL 14. REPAIRED FLOORBEAM PER ER09-1280 DATED 02-02-09.SDR UPS09554592Floorbeam · corrodedINSPECTION TYPE:C3 FLOORBEAM STA 440 LBL 35 HAS CORROSION ON TOP SURFACE. BLENDED AREA, APPLIED ALODINE, PRIMER, SEALED VOID, APPLIED CIC IAW ER 09-1288.SDR K11A2009020472001Floorbeam · corrodedFLOORBEAM LOWER CHORD REPAIR CORRODED ON FORWARD SIDE.SDR USAA2009020490271Floorbeam · corrodedPIT - S4 - MAJOR REPAIR - LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM BETWEEN FR18 TO FR21, Y254. REPAIRED FLOORBEAM BETWEEN FR18 TO FR21, Y254 IAW A319 SRM 51-72-11.SDR USAA2009012890208Strap · crackedCLT - Q5 - MAJOR REPAIR - FLOORBEAM TIE STRAP CRACKED AT BS 312, BL 0. REPLACED FLOORBEAM TIE STRAP AT BS 312, BL 0 IAW B737 SRM 51-10-02.SDR USAA2009012890207Attach Bracket · crackedCLT - Q5 - MAJOR REPAIR - FLOORBEAM LOWER ATTACH BRACKET CRACKED AT BS 327, S17L. REPLACED FLOORBEAM LOWER ATTACH BRACKET AT BS 327, S17L IAW B737 SRM 51-10-02.SDR K11A200912872001Repair · corrodedFLOORBEAM LOWER CHORD REPAIR CORRODED ON FORWARD SIDE.SDR FDEA200901230313Floorbeam · damagedEXISTING FLOORBEAM REPAIR AT BS 1640, LBL 52, WL 208, UPON EVALUATION OF EO F-5100-7-5001, PART 1, ATTACHMENT "B", DOES NOT MEET SRM REQUIREMENTS AND INTERFERES WITH PTF MODIFICATION. PERMANENT FLOORBEAM CAT "A" MAJOR REPAIRS ACCOMPLISHED PER MAE EA'S 757-536SDR CALA2009012600056Floorbeam · corrodedBLENDOUT OF CORROSION ON FLOORBEAM AT STATION 986.5 RBL 29 OUT OF SRM LIMITS. REPAIRED FLOORBEAM REF SRM 53-00-51 FIG 203 REPAIR 1.SDR EIAA20090021Floorbeam · crackedDURING INCORPORATION OF SB 747-53-2439, ONE FLOORBEAM PANEL ATTACH HOLE WAS FOUND CRACKED AND NUT PLATE WAS FOUND DAMAGED. FILLED EXISTING MISDRILLED NUT PLATE IN UPPER CHORD, PERFORM HFEC INSP. FABRICATE TWO REPAIR STRAPS AND ONE REPAIR FILLER, HEAT TREAT ASDR AALA2009020900026Floorbeam · corrodedCORROSION ON FLOORBOARD SUPPORT ZEE ANGLE AT STATION 994 BETWEEN RIGHT BUTTLINE 33 AND 45. INSTALLED NEW ZEE ANGLE IN ACCORDANCE WITH SRM 51 10 02 08.SDR SIMA200902302Floorbeam · corrodedDURING IMBV, THE LEFT OMEGA BEAM AT FRAME 20 WAS FOUND CORRODED. REMOVED PREVIOUS REPAIR AND RETAINED 2 SHIMS AND 1 PLATE. TRIMMED P/N EPNEM53EP54701 TO 18.5 INCH FOR A DOUBLER AND EPNEM53EP54703 TO 12.5 INCH FOR A FILLER. CLEANED, ALODINED, PRIMED AND INSTSDR FDEA200901220309Floorbeam · gougedMAIN CABIN FLOORBEAM WEB AT STA 365 RBL 41 HAS DAMAGE. REPAIRED IAW EA 757-5315-16-F1708, REV A. AS PER EA FUNCTION IS ALTERATION AND CLASSIFICATION IS FORM 8110-3/RAS/8100-9.SDR AALA2009020900025Floorbeam · corrodedCORROSION ON UPPER FLANGE OF FLOORBEAM AT STATION 986.5 30-34 INCHES ON RIGHT BODY LINE. INSTALLED ANGLE REPAIR ON FLOORBEAM PER AARD 53 00 00 7.SDR SWAA090474Floorbeam · crackedDURING SCHEDULED SPV CHECK, FOUND LONGITUDINAL FLOOR STUB BEAM CRACKED AT BS 639, LBL 45. REMOVED AND REPLACED BEAM PER DWG.SDR SWAA090472Floorbeam · crackedDURING SCHEDULED 12Y CHECK, FOUND FLOORBEAM CRACKED AT BS 312, BETWEEN RBL 20 TO RBL 22. REPAIRED BEAM PER SRM.SDR FDEA200901210297Floorbeam · corrodedSTA 377 FLOORBEAM HAS CORROSION, REMOVED CORROSION IAW SRM 53-00-51. FABRICATED NEW UPPER CHORD AND SPLICE ANGLES ON MAE TRAV NR T9/445482, AND T9/445483. INSTALLED REPAIR PARTS IAW SRM 53-00-51, STA 377, RBL 36- LBL 70, MAJOR REPAIR NR 3. CATEGORY B.SDR SWAA090468Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND LONGITUDINAL BEAM CRACKED AT BS 727B, RBL 24. REPAIRED BEAM PER ER.SDR SWAA090466Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 663, LBL 24. REPAIRED BEAM PER ER.SDR AALA2009020900036Floorbeam · corrodedCORROSION ON UPPER FLANGE OF CABIN FLOORBEAM AT STATION 986.5 LEFT BUTTLINE 4 TO 10.SDR ASOA200900099Floorbeam · corrodedLT 280 BEAM BADLY CORRODED. REMOVED AND REPLACED BEAM PER SRM 51-42-06, 51-42-13 AND 53-11-10.SDR C2XA09SH027Floorbeam · corrodedDURING C-CHECK, LT OMEGA BEAM HAS CORROSION BETWEEN FR 45-50. REPAIRED LT OMEGA BEAM IAW IC2009/145-00195. ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA09SH026Floorbeam · corrodedDURING C-CHECK, CENTER OMEGA BEAM HAS CORROSION AT FR 59. REPAIRED CENTER OMEGA BEAM IAW IC2009-145/00195. ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA09SH025Floorbeam · corrodedDURING C-CHECK, LT OMEGA BEAM HAS CORROSION AT FR 33-34. REPAIRED LT OMEGA BEAM IAW EMB 145 SRM 53-00-10. ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA09SH017Floorbeam · corrodedDURING C-CHECK LT OMEGA BEAM AT FR 59 HAS CORROSION. REPAIRED LT OMEGA BEAM IAW IC2009-145/00197. THIS ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA09SH016Floorbeam · corrodedDURING C-CHECK RT OMEGA BEAM @ FR 59 HAS CORROSION. REPAIRED RT OMEGA BEAM IAW IC2009-145/00197. THIS ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR SWIA200921168Floorbeam · crackedC-CHECK, INBOARD AND OUTBOARD CLIPS AT FS 280 CRACKED. REPAIRED PER REO.SDR SWIA200921166Floorbeam · crackedC-CHECK, OUTBOARD RBL9 FS 280 CLIP CRACKED. REPAIRED PER REO.SDR USAA2009012690163Floorbeam · corrodedSAL - C3 - 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 AALA2009020900035Floorbeam · corrodedCORROSION FOUND ON FLOORBEAM UPPER FLANGE AT STATION 967 RIGHT BUTTLINE 18 AROUND FASTENER HOLE. REMOVED CORROSION BY CUTTING DAMAGED AREA OUT AND INSTALLING REPAIR ANGLE AND STRAP IN ACCORDANCE WITH SRM 53 00 51.SDR DHLA2009743544Floorbeam · corrodedCABIN FLOORBEAM AT BS 950F CORRODED ON UPPER FLANGE AT RBL 11. ACCOMPLISHED FLOORBEAM REPAIR PER SRM 53-10-8 FIG 8.SDR DHLA2009743542Floorbeam · damagedCABIN FLOORBEAM AT BS 660 HAS DOUBLE DRILLED HOLES AT RBL 62.5. REPAIRED FLOORBEAM AS REQUIRED IN EO COO-2-53-470-08 DATED 12/17/08. REF FAA FORM 8110-3 DATED 12/24/08 AND ASTAR EVA B253-00205 FOR REPAIR APPROVAL.SDR SWIA200921219Floorbeam · crackedFLOOR SUPPORT BEAM AT FS 280 LBL11 AND RBL9 CRACKED. C CHECK, REPAIRED PER REO.SDR USAA2009012290121Floorbeam · corrodedCLT - Q5 - MAJOR REPAIR - LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM T-CAP AT BS 328, LBL 28. REPAIRED FLOORBEAM T-CAP AT BS 328, LBL 28 IAW B737 SRM 53-10-51 REPAIR 5.SDR USAA2009012290120Floorbeam · corrodedCLT - Q5 - MAJOR REPAIRS - LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM T-CAP AT BS 344, BL 0. REPAIRED FLOORBEAM T-CAP AT BS 344, BL 0 IAW B737 SRM 53-10-51 REPAIR 6.SDR ASAA0944333Floorbeam · corrodedAFT GALLEY AREA FLOORBEAM UPPER SURFACE CORRODED AT FS 967 RBL 16. REMOVED CORROSION REPAIRED FLOORBEAM IAW EA EA 400-53, EA 00544.SDR QXEA2009011900025Floorbeam · crackedFS 280 FLOORBEAM HAS A CRACK ON THE TOP FLANGE AT RBL 13.00. REMOVED DRIP TRAY ON RT SIDE AT 280 FLOORBEAM IAW SRM 51-42-13. REMOVED THE RT SIDE OF THE 280 FLOORBEAM AND THE ATTACHING INTERCOSTAL IAW REO 670-53-11-047. CUT NEW SECTION OF 280 FLOORBEAM, LOCASDR SWAA090352Floorbeam · crackedDURING SCHEDULED 16Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 727A, RBL 45. REPAIRED BEAM PER AAR EA.SDR SWAA090351Floorbeam · crackedDURING SCHEDULED 16Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 727A, LBL 45. REPAIRED BEAM PER AAR EA.SDR SWAA090346Floorbeam · corrodedDURING SCHEDULED 8Y CHECK, FOUND FLOORBEAM CORRODED AT BS 294, LBL 7 TO RBL 20. REMOVED AND REPLACED BEAM PER SWA EA.SDR CALA2009011500038Floorbeam · corrodedFLOORBEAM 986.5 HAS CORROSION LBL 5 TO RBL 44. INSTALLED ONE FLANGE REPAIR REF SRM 53-00-51 REPAIR 1 AND ECRA 5310-04886.SDR UHLA2009011400169Floorbeam · corrodedLEVEL 2 CORROSION ON FLOORBEAM BETWEEN FR85 TO FR89 RT. REPLACED FLOORBEAM IAW SRM 51-41-01 AND SRM 51-43-03.SDR USAA2009021390333Floorbeam · corrodedMCN C12 MAJOR REPAIR NR 6187584 EXFOLIATION CORROSION FLOOR BEAM CHORD AT BS324, WL208, RBL54. REPAIRED FLOOR BEAM CHORD AT BS324, WL208, RBL54 IAW US AIRWAYS EA NR 130185.SDR USAA2009012890214Floorbeam · corrodedSAL - C7 - MAJOR REPAIR - GALVANIC CORROSION ON FLOORBEAM AT FR68, Y1162. REPLACED FLOORBEAM AT FR68, Y1162 IAW A320 SRM 51-72-11.SDR USAA2009012390141Floorbeam · corrodedSAL - C7 - 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 USAA2009012390140Floorbeam · corrodedSAL - C7 - 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 QXEA2009011900026Floorbeam · damagedFS 280.0 BEAM SPLICE AT AIRCRAFT CENTER HAS ELONGATED HOLES. LOCATED AND DRILLED NEW SPLICE PLATE. INSTALLED SPLICE PLATE IAW 51-42-06 IAW SRM 51-42-06.SDR QXEA2009011900024Floorbeam · corrodedFS 280 FLOORBEAM HAS AREAS OF CORROSION ON THE TOP FLANGE BETWEEN LBL 6.00 AND 18.00. BLENDED CORRODED AREAS PLUS 2 ADDITIONAL AREAS OUTBOARD OF THESE LOCATIONS (6.00 AND 18.00) IAW REO 670-53-11-046. FOUND REMAINING MATERIAL TO MEASURE NO LESS THAN .036 INCSDR SWAA090330Attach Fitting · crackedDURING SCHEDULED 16Y CHECK, FOUND FLOORBEAM ATTACH FITTING CRACKED AT BS 540, RBL 32. REMOVED AND REPLACED FITTING PER SRM.SDR SWAA090329Attach Fitting · crackedDURING SCHEDULED 16Y CHECK, FOUND FLOORBEAM ATTACH FITTING CRACKED AT BS 540, LBL 32. REMOVED AND REPLACED FITTING PER SRM.
Back to JASC 5315