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 DL757081329Floorbeam · corrodedCORROSION ON FLOORBEAM 1470 AT LBL 8. REPAIRED ON NR 00051PER 51-40-05 FIGURE 4.SDR DL757081328Floorbeam · corrodedCORROSION ON FLOORBEAM STATION 1470 RBL 3. REPAIRED ON NR 00053 PER 51-40-07 FIGURE 1.SDR DL757081327Floorbeam · corrodedCORROSION ON FLOORBEAM STATION 1470 RBL 115. REPAIRED ON NR 00055 PER 51-40-02 STEP 7.SDR DL757081326Floorbeam · corrodedCORROSION ON FLOORBEAM AT STATION 1470 LBL 3. REPAIRED ON NR 00052 PER 51-40-05 FIGURE 4.SDR DL757081325Floorbeam · corrodedCORROSION ON FLOORBEAM BS 1470 AT RBL 8. REPAIRED ON NR 00054 PER 51-40-07 STEP 7.SDR DL757081319Floorbeam · corrodedCORROSION ON FLOORBEAM STATION 1510 AT LBL 3. REPAIRED ON NR 00061 PER SRM 53-60-53 FIGURE 206.SDR DL757081318Floorbeam · corrodedCORROSION ON FLOORBEAM AT STATION 1510 AT RBL 3. REPAIRED ON NR 00062 PER SRM 53-60-53.SDR DL757081317Floorbeam · corrodedCORROSION ON FLOORBEAM STATION 1510 AT LBL 7. REPAIRED ON NR 00060 PER 53-60-53 FIG 206.SDR DL757081316Support Angle · corrodedCORROSION FOUND FLOORBEAM SUPPORT ANGLE AT STATION 1497 AT RBL 14. REPAIRED ON NR 00065 PER 53-00-53 DETAIL V.SDR DL757081308Floorbeam · corrodedAFT CARGO FLOORBEAM STATION 1470 CORRODED AT LBL 17. REPAIRED ON NR 00050 PER 51-70-11 FIGURE 1 SHT 1.SDR 08FDEA04251Floorbeam · corrodedCABIN FLOORBEAM FS 324, RBL 30- 50, CORRODED. ACCOMPLISHED REWORK ON EA F-5310-123907. THIS IS A CATEGORY "A " MAJOR REPAIR.SDR 08FDEA04249Floorbeam · misalignedMAIN CABIN FLOORBEAM , BS 1600 LBL 25.45 HAS MISDRILLED HOLES. REMOVED DAMAGED AREA OF FLOOR , REMOVED STIFFENER, FABRICATED NEW PART, ANGLE SHIMS AND STRAPS IAW SRM 53-00-51. TREATED AND PRIMES NEW PARTS, INSTALLED FABRICATED PARTS IAW SRM 51-40-02. THIS IS ASDR UALA2008111306217Floorbeam · corrodedBEAM 95 CORRODED. REMOVED FLOORBEAM 95. REMOVED BRACKETS AND DRILLED NEW BEAM. ALL BRACKETS AND ATTACH FITTINGS INSTALLED. BEAM INSTALLED, ATTACHMENT COMPLETE AT FRAME 64, NEEDS BOLTS AT FRAME 66 AND 65. COMPLETED INSTALLATION OF BEAM.SDR 2008UALA06217Floorbeam · corrodedBEAM 95 CORRODED. REMOVED FLOORBEAM 95. REMOVED BRACKETS AND DRILLED NEW BEAM. ALL BRACKETS AND ATTACH FITTINGS INSTALLED. BEAM INSTALLED, ATTACHMENT COMPLETE AT FRAME 64, NEEDS BOLTS AT FRAME 66 AND 65. COMPLETED INSTALLATION OF BEAM.SDR SWAA085441Floorbeam · corrodedDURING SCHEDULED 6Y CHECK, FOUND AFT CARGO FLOORBEAM CORRODED AT BS 767 + 5, LBL 12. REPAIRED BEAM PER SWA EA.SDR SWAA085440Floorbeam · corrodedDURING SCHEDULED 6Y CHECK, FOUND AFT CARGO FLOORBEAM CORRDED AT BS 767 + 5, LBL 7.5. REPAIRED BEAM PER SWA EA.SDR SWAA085439Floorbeam · corrodedDURING SCHEDULED 6Y CHECK, FOUND AFT CARGO FLOORBEAM CORRDED AT BS 767 + 5, LBL 3. REPAIRED BEAM PER SWA EA.SDR SWAA085438Floorbeam · corrodedDURING SCHEDULED 6Y CHECK, FOUND AFT CARGO FLOORBEAM CORRDED AT BS 767 + 5, RBL 7.5. REPAIRED BEAM PER SWA EA.SDR SWAA085437Floorbeam · corrodedDURING SCHEDULED 6Y CHECK, FOUND AFT CARGO FLOORBEAM CORRODED AT BS 767 + 5, RBL 3. REPAIRED BEAM PER SWA EA.SDR 08FDEA04204Floorbeam · corrodedCABIN FLOORBEAM BS 377.7 BL 0- LBL 62, CORRODED AT FASTENER HOLES. REMOVED CORROSION IAW SRM 51-10-02. FABRICATED ANGLES ON MAE TRAV T8/760222. FABRICATED STRAPS ON MAE TRAV T8/760223. INSTALLED REPAIR PARTS IAW SRM 53-00-51. MAJOR REPAIR.SDR SWIA200820580Floorbeam · crackedC-CHECK, FS 280 FLOORBEAM LBL 9 LOWER SUPPORT RADIUS CRACKED. REPAIRED PER REO.SDR SWIA200820579Floorbeam · crackedC-CHECK, FS 280 FLOORBEAM LBL9 UPPER FLOOR SUPPORT CRACKED IN RADIUS. REPAIRED PER REO.SDR SWIA200820578Floorbeam · crackedC-CHECK, FS 280 FLOORBEAM RBL9 UPPER FLOOR SUPPORT CRACKED IN RADIUS. REPAIRED PER REO.SDR SWIA200820577Floorbeam · crackedC-CHECK, FS 280 FLOORBEAM RBL9 LOWER SUPPORT RADIUS CRACKED. REPAIRED PER REO.SDR USAA920081807Floorbeam · corrodedSAL - C7 - MAJOR REPAIR, CORROSION ON FLOORBEAM IN PAX CABIN AT FR 64+10.5 INCHES, BL -Y765. REPLACED FLOORBEAM IN PAX CABIN AT FR 64+10.5 INCHES, BL -Y765 IAW A320SRM 51-72-11.SDR USAA920081906Floorbeam · corrodedSAL C7 MAJOR REPAIR NR 6109453 GALVANIC CORROSION ON FLOORBEAM AT FR66 Y512. REPLACED FLOORBEAM AT FR66, Y512 IAW A320 SRM 51-72-11.SDR SWIA200820564Floorbeam · crackedDURING C-CHECK, FS 280 UPPER FLOOR SUPPORT AT RBL9 CRACKED. REPAIRED PER REO.SDR SWIA200820563Floorbeam · crackedDURING C-CHECK, FS 280 RBL9 FLOOR SUPPORT AND CLIPS CRACKED. REPAIRED PER REO.SDR SWIA200820562Floorbeam · crackedDURING C-CHECK, FS 280 LBL 9 LOWER FLOOR SUPPORT CRACKED. REPAIRED PER REO.SDR SWIA200820561Floorbeam · crackedDURING C-CHECK, FS 280 FORWARD FLOOR SUPPORT AT RBL 9 RADIUS CRACKED. REPLACED PER SRM.SDR USAA920081842Floorbeam · corrodedSAL - C7 - MAJOR REPAIR, CORROSION ON FLOORBEAM IN PAX CABIN BETWEEN FR12 & FR16, Y498. REPLACED FLOORBEAM ASSEMBLY BETWEEN FR12 & FR16, Y498 IAW A320 SRM 51-72-11.SDR ASAA0873649Floorbeam · corrodedCORROSION FOUND ON FLOORBEAM BS 312 LBL 11 TO LBL 30. CORROSION ON FLOORBEAM BS 312 LBL 11 TO LBL 30 BLENDED OUT. BLEND AREA FOUND TO BE BEYOND ALLOWABLE DAMAGE LIMIT. FLOORBEAM REPAIRED IAW ERO 8711 AND EA.SDR ASAA0873648Floorbeam · corrodedCORROSION FOUND ON FLOORBEAM BS 294.5 RBL 10 52. CORROSION ON FLOORBEAM BS 294.5 RBL 10 52 BLENDED OUT. BLEND AREA FOUND TO BE BEYOND ALLOWABLE DAMAGE LIMIT. FLOORBEAM REPAIRED IAW B737 ERO 8715 AND EA.SDR ASAA0873646Floorbeam · corrodedAFT PASSENGER CABIN CORROSION ON FLOORBEAM AT BS 986 RBL 12. CORROSION ON FLOORBEAM BLENDED OUT BLEND AREA FOUND TO BE BEYOND LIMIT. FLOORBEAM REPAIRED IAW B737 700 SRM 53 00 51 FIG 203 REPAIR 1.SDR ASAA0873645Floorbeam · corrodedFORWARD PASSENGER CABIN MINOR SCRATCH ON FLOORBEAM AT BS 328 RBL 11. SCRATCH AND CORROSION ON FLOORBEAM AT BS 328 RBL 11 BLENDED OUT. BLEND AREA FOUND TO BE BEYOND ALLOWABLE DAMAGE LIMIT. FLOORBEAM REPAIRED IAW ERO 8710 AND EA.SDR ASAA0873627Floorbeam · scratchedFWD PASSENGER CABIN BS 328 344 LBL 12 FLOORBEAM SCRATCHED. FLOORBEAM BS 328 344 LBL 12 REPLACED WITH MADE REPAIR PART IAW B737 700 SRM 51 40 02.SDR ASAA0873626Floorbeam · scratchedFWD PASSENGER CABIN FLOORBEAM BS 312-328 LBL 12 SCRATCHED. FLOORBEAM AT BS 312 328 LBL 12 REPLACED WITH MADE REPAIR PART IAW B737 700 SRM 51 40 02.SDR 08FDEA04193Floorbeam · misalignedMAIN CABIN FLOORBEAM BS 1580 LBL 25-45 HAS MISDRILLED HOLES. REPAIRED IAW SRM 53-00-51.SDR 08FDEA04181Floorbeam · corrodedMAIN CABIN FLOORBEAM, BS 345, RBL 0-25 HAS CORROSION. REMOVED CORROSION FROM BS 345 AT RBL 0-25. CORROSION CHECKED OUT OF LIMITS IAW SRM 53-00-51 . REMOVED DAMAGED AREA, FABRICATED REPAIR PARTS INSTALLED REPAIR PARTS AT BS 345 LBL-53 TO RBL 32 WORK DONE IAW SSDR F3LA2008100600662Floorbeam · corrodedDURING C3 C-CHECK, INSPECTION NOTED FLOORBEAM Y1292 AT FRAME 68, FORWARD AND AFT HOLES HAVE CORROSION. MAINTENANCE BLENDED CORROSION AND OVERSIZED HOLES IN ACCORDANCE WITH THE REQUIREMENTS OF A319 SRM 53-00-14, FIGURE 102. MAINTENANCE PERFORMED ROTO-PROBE INSDR F3LA2008100600661Floorbeam · corrodedDURING C3 C-CHECK, INSPECTION NOTED FLOORBEAM Y1292 BETWEEN FRAME 66 AND FRAME 68, HAS CORROSION IN SEVERAL HOLES. MAINTENANCE BLENDED CORROSION AND OVERSIZED HOLES, HOLES OUT OF LIMITS PER SRM 53-00-14. MAINTENANCE REMOVED CORRODED FLOORBEAM AND UPPER COUPLSDR F3LA2008100600660Floorbeam · corrodedDURING C3 C-CHECK, INSPECTION NOTED FLOORBEAM Y1292 BETWEEN FRAME 66 AND FRAME 68, HAS CORROSION IN SEVERAL HOLES. MAINTENANCE BLENDED CORROSION AND OVERSIZED HOLES, HOLES OUT OF LIMITS PER SRM 53-00-14. MAINTENANCE REMOVED CORRODED FLOORBEAM AND UPPER COUPLSDR F3LA2008100600658Floorbeam · corrodedDURING C3 C-CHECK, INSPECTION NOTED FLOORBEAM Y1292 AT FRAME 66, FORWARD HOLE HAS CORROSION. MAINTENANCE BLENDED CORROSION, OVERSIZED HOLE, ROTO-PROBED, TREATED, PRIMED AND PAINTED IN ACCORDANCE WITH THE REQUIREMENTS OF A319 SRM 53-00-14, NONDESTRUCTIVE TESTISDR F3LA200800656Floorbeam · corrodedREFERENCE NON ROUTINE C051966. DURING C3 C CHECK, INSPECTION NOTED FLOOR BEAM Y-1292 BETWEEN FRAME 66 AND FRAME 68 HAS CORROSION IN SEVERAL HOLES. MX R&R FLOOR BEAM IAW THE REQUIREMENTS OF A319 SRM 51-42-11 AND DRAWING D53472780. UPON COMPLETION OF THE REPASDR AALA200810004Floorbeam · corrodedCORROSION AND TOOLING MARKS TOP OF 328 BEAM. REPAIRED FLOORBEAM PER ESO 61000 DATED 10-02-2008.SDR 2008UALA05963Floorbeam · corrodedBEAM 150 CORRODED. REMOVED FLOORBEAM 150. REMOVED BRACKETS AND DRILLED NEW BEAM AND READY FOR BRACKET INSTALL ON NEW BEAM. INSTALLED BEAM, NEEDS 2 BOLTS AT STA 70, 8 BOLTS AT STA 68. COMPLETED INSTALLATION OF BEAM. INSPECTED FINAL INSTALLATION OF BEAM 150SDR 2008UALA05961Floorbeam · corrodedBEAM 95 CORRODED. REMOVED FLOORBEAM 95. REMOVED BRACKETS AND DRILLED NEW BEAM AND READY FOR BRACKET INSTALL. ALL BRACKETS AND ATTACH FITTINGS INSTALLED AND READY FOR INSTALLATION INTO AC. BEAM INSTALLED, ATTACHMENT COMPLETE AT FRAME 64, NEEDS BOLTS AT FRAMSDR 2008UALA05960Floorbeam · corrodedBEAM 80 CORRODED. REMOVED FLOORBEAM 80. TRANSFERRING FASTENER HOLES TO NEW BEAM. INSTALLED BEAM.SDR 2008UALA05959Floorbeam · corrodedBEAM 140 CORRODED. REMOVED FLOORBEAM 140. TRANSFERRING FASTENER HOLES TO NEW BEAM. INSTALLING FASTENERS IN NEW BEAM. INSTALLED BEAM.SDR 2008UALA05958Floorbeam · corrodedBEAM 145 CORRODED. REMOVED FLOORBEAM 145. TRANSFERRING FASTENER HOLES TO NEW BEAM. INSTALLING FASTENERS IN NEW BEAM. INSTALLED NEW BEAM.
Back to JASC 5315