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 AALA200820030Floorbeam · corrodedFLOORBEAM CORRODED. REPAIRED IAW EA B757-53-004790.SDR AALA200820024Floorbeam · corrodedFLOORBEAM CORRODED. REPAIRED IAW EA B757-53-004838 DATED 10/24/2008.SDR COMA0860438Floorbeam · crackedFS 280 FLOOR ANGLE 600-34017-595 IS CRACKED AT LBL9 IN THE LWR FLANGE. CUT OUT DAMAGE AND INSTALLED PERMANENT REPAIR DOUBLER PER REO 601R-53-11-171.SDR 2008UALA06272Floorbeam · corrodedFLOORBEAM 80 HAS CORROSION. STARTED REMOVAL OF FLOORBEAM. CONNECTOR AND FORWARD END OF FLOORBEAM NEED TO BE REMOVED. REMOVED FLOORBEAM 80 AND BEGAN INSTALLING BRACKETS ON FLOORBEAM. INSTALLED ALL BRACKETS AND JOINED FLOORBEAMS 150 AND 80 TOGETHER. READY TSDR 2008UALA06271Floorbeam · damagedBEAM 150 NEEDS REPLACEMENT. MAJOR REPAIR ACCOMPLISHED. BEGAN REMOVAL OF BEAM 150. REMOVED FLOORBEAM 150 AND BEGAN INSTALLING BRACKETS ON BEAM. INSTALLED ALL BRACKETS AND JOINED FLOORBEAMS 150 AND 80 TOGETHER. REPLACED FLOORBEAM 150.
SDR CALA0800999Floorbeam · corrodedFLOORBEAM AT STATION 986.5 UPPER FLANGE BLENDED OUT OF LIMITS. REPAIRED FLOORBEAM 986.5 AT RBL 11 PER SRM 53-00-51 REPAIR 1.SDR CALA0800996Floorbeam · corrodedFLOORBEAM AT STATION 986.5 UPPER FLANGE BLENDED OUT OF LIMITS AT LBL 27. INSTALLED REPAIR PER SRM 53-00-51, FIG 203.SDR CALA0800982Floorbeam · corrodedBODY STATION 325 FLOOR SUPPORT FOUND CORRODED BETWEEN LBL 26 -59. BODY STATION 325 FLOORBEAM LBL 13 - LBL 62 REPAIRED PER SRM 53-00-51 REPAIR 1, FIG 201. HFEC NO CRACK FOUND.SDR CALA0800981Stiffener · crackedE AND E COMPARTMENT M/D FLOORBEAM STATION 246 LBL 40 VERTICAL STIFFENER FOUND CRACKED. MAIN DECK FLOOR BEAM STATION 246 LBL 40 VERTICAL STIFFENER REPAIRED PER ECRA 5310-04854 PART 1. HFEC NIL CRACKS FOUND. REF L/P 7984436 53-DIP, 90691, DIP ISSUED TO PERFORSDR CALA0800980Floorbeam · crackedE AND E COMPARTMENT M/D FLOORBEAM STATION 246 LBL 25 VERTICAL STIFFENER FOUND CRACKED. M/D FLOORBEAM STATION 246 LBL 25 VERTICAL STIFFENER REPLACED PER SRM 51-10-02 AND INSTALLED AS PER SRM 51-40-02.SDR CALA0800979Floorbeam · corrodedBODY STATION 303 FLOOR SUPPORT FOUND CORRODED BETWEEN LBL 22 - 40. BODY STATION 303 FLOORBEAM BETWEEN LBL 6 LBL 63 REPAIRED PER SRM 53-00-51, REPAIR 1, FIG 201, AND HFEC NIL CRACK FOUND.SDR CALA0800978Floorbeam · crackedE AND E COMPARTMENT M/D FLOORBEAM AT STATION 246 MID CHORD FOUND CRACKED AT LBL 40. E AND E COMPARTMENT M/D FLOORBEAM STATION 246 MID CHORD AT LBL 40 REPAIRED PER SRM 53-10-51, REPAIR 2, FIG 1, REF ECRA5310-04854. HFEC NO CRACK FOUND.SDR SWIA200820902Floorbeam · corrodedC-CHECK, 2 CROSS MEMBERS AT FRAME 37 HAVE CRACKS AND CORROSION. REPLACED CROSSMEMBERS PER SRM.SDR HNAA2009012500023Floorbeam · damagedFLOOR BEAM DAMAGE AT STA X129 BENEATH RT INBD SEAT RAIL ATTACHMENT. PERFORM LIQUID PENETRANT INSPECTION PER EO8-53-08-337 NO DEFECT FOUND. REPAIR DAMAGE PART PER EO8-53-08-337SDR DL757081418Floorbeam · corrodedCORROSION AROUND NUTPLATE HOLE BS 1523 LBL 3 FLOOR SUPPORT RAIL. REMOVED DAMAGED SECTION OF FLOOR SUPPORT RAIL BS 1523 LBL 3. FABRICATED REPAIR PARTS, ALODINED, PRIMED, AND INSTALLED WET WITH SEALANT. WORK DONE IAW SRM 53-60-53D FIG 206.SDR 08FDEA04482Floorbeam · crackedFWD CARGO COMPT FR 31 BETWEEN SEAT TRACK NR 4 LT AND TRACK NR 5 LT FLOORBEAM HAS .25 INCH CRACK. REMOVED CRACK AND INSTALLED CROSSBEAM REPAIR AT CRACKED STIFFENER AT FR 31, BETWEEN SEAT TRACK NR 4 LT AND NR 5 LT IAW SRM 53-10-15, FIG 212, PAGE 397/398.SDR SWIA200820595Floorbeam · crackedC-CHECK, FS 280 RBL 9 UPPER FLOOR SUPPORT ANGLE CRACKED. REPAIRED PER REO.SDR SWIA200820594Floorbeam · crackedC-CHECK, FS 280 LBL 9 FLOORBEAM LOWER FLANGE CRACKED. REPAIRED PER REO.SDR SWIA200820593Floorbeam · crackedC-CHECK, FLOORBEAM FS 280 LBL 9 INBOARD CLIP CRACKED. REPLACED PER REO.SDR SWIA200820592Floorbeam · crackedC-CHECK, FLOORBEAM FS 280 RBL 9 INBOARD CLIP CRACKED. REPLACED PER REO.SDR SWIA200820591Floorbeam · crackedC-CHECK, FLOORBEAM FS 280 RBL 9 OUTBOARD CLIP CRACKED. REPLACED PER REO.SDR SWAA085751Floorbeam · corrodedDURING SCHEDULED 6Y CHECK, FOUND FLOORBEAM CORRODED AT BS 700, LBL 3. REPAIRED BEAM PER SWA EA.SDR SWAA085750Floorbeam · corrodedDURING SCHEDULED 6Y CHECK, FOUND FLOORBEAM CORRODED AT BS 700, LBL 8. REPAIRED BEAM PER SWA EA.SDR SWAA085691Floorbeam · corrodedDURING SCHEDULED 18Y CHECK, FOUND FLOORBEAM CORRODED AT BS 986, RBL 47, WL 208. REPAIRED BEAM PER SRM.SDR SWAA085672Floorbeam · corrodedDURING SCHEDULED 24Y CHECK, FOUND FLOORBEAM CORRODED AT BS 987, BETWEEN RBL 44 TO LBL 43, WL 208. REPAIRED BEAM PER PAE ER.SDR SWAA085671Floorbeam · corrodedDURING SCHEDULED 24Y CHECK, FOUND FLOORBEAM CORRODED BETWEEN BS 727 TO BS 727A, STR 27R. REPAIRED BEAM PER SRM.SDR AALA200810154Floorbeam · corrodedCORROSION ON CABIN FLOOR SUPPORT AT STATION 962 AT RBL 16. REMOVED AND REPLACED FLOOR SUPPORT.SDR SWAA085653Floorbeam · crackedDURING SCHEDULED 18Y CHECK, FOUND FLOORBEAM CRACKED AT BS 312, LBL 54. REPAIRED BEAM PER SRM.SDR F3LA2008102200677Floorbeam · corrodedDURING C4/S1 C-CHECK, INSPECTION NOTED CORROSION ON FLOORBEAM -Y1292 AT FRAME 68, PASSENGER CABIN. MAINTENANCE REMOVED AND REPLACED FLOORBEAM IN ACCORDANCE WITH A319 SRM 51-42-11 PAGE 1 AND 2.SDR F3LA2008102200676Floorbeam · corrodedDURING C4/S1 C-CHECK, INSPECTION NOTED CORROSION ON FLOORBEAM LOCATED AT Y1292 AND FRAME 68, PASSENGER CABIN. MAINTENANCE REMOVED AND REPLACED FLOORBEAM IN ACCORDANCE WITH A319 SRM 51-42-11 PAGES 1 AND 2.SDR F3LA2008102200675Floorbeam · corrodedDURING C4/S1 C-CHECK, INSPECTION NOTED CORROSION ON FLOORBEAM Y1292 BETWEEN FRAME 66 AND FRAME 68, PASSENGER CABIN. MAINTENANCE REMOVED AND REPLACED FLOORBEAM IN ACCORDANCE WITH A319 SRM 51-72-11 PAGE 1 AND 2.SDR SWIA200820629Floorbeam · crackedC-CHECK, FS 280 FLOOR SUPPORT BEAM LBL9 LOWER INBOARD AND OUTBOARD CLIPS CRACKED. REPAIRED PER REO.SDR SWIA200820627Floorbeam · crackedC-CHECK, FS 280 FLOOR SUPPORT BEAM RBL9 LOWER INBOARD AND OUTBOARD CLIPS CRACKED. REPAIRED PER REO.SDR SWIA200820626Floorbeam · crackedC-CHECK, STATION 280 FLOOR SUPPORT BEAM RBL9/LBL9 CRACKED. REPAIRED PER REO.SDR SWIA200820590Floorbeam · crackedC-CHECK, FS 280 RBL 12 FLOOR SUPPORT ANGLE CLIP CRACKED. REPLACED PER SRM.SDR SWIA200820589Floorbeam · crackedC-CHECK, FS 280 RBL 9 FLOOR SUPPORT ANGLE CLIPS CRACKED. REPLACED PER SRM.SDR DL757081452Floorbeam · corrodedCORROSION IN AND AROUND FASTENER HOLE AT BS 739, RBL 9 FLOORBEAM, OUT OF LIMITS. REPAIRED PER DELTA ER/A 465406-14 REV ORIG.SDR SWAA085613Floorbeam · corrodedDURING SCHEDULED 8Y CHECK, FOUND FLOORBEAM CORRODED AT BS 986, RBL 43. REPAIRED BEAM PER SRM.SDR SWAA085612Floorbeam · corrodedDURING SCHEDULED 8Y CHECK, FOUND FLOORBEAM CORRODED AT BS 947, BETWEEN RBL 5 TO LBL 5. REPAIRED BEAM PER SWA EA.SDR SWAA085624Floorbeam · crackedDURING SCHEDULED SPV CHECK, FOUND FLOORBEAM CRACKED AT BS 947, LBL 54. REPAIRED BEAM PER PAE ER.SDR SWAA085617Floorbeam · corrodedDURING SCHEDULED 8Y CHECK, FOUND FLOORBEAM CORRODED AT BS 986, RBL 43. REPAIRED BEAM PER SRM.SDR FDEA200810184427Floorbeam · damagedMAIN CABIN FLOORBEAM, STA 1620 LBL25-45 HAS MISDRILLED SCREW HOLES. REPAIRED FLOORBEAM IAW SRM 53-00-51 REPAIR NR 1 FIG 201 AND SRM 51-40-02. MAJOR REPAIR NO FOLLOW-UP INSP REQUIRED.SDR USAA920082041Floorbeam · corrodedCLT Q3 MAJOR REPAIR NR 03C10853028/024 LEVEL 2 EXFOLIATION CORROSION ON FLOOR BEAM T-CAP AT BS986.5, BETWEEN LBL50 TO RBL50. REPLACED FLOOR BEAM T-CAP AT BS986.5, BETWEEN LBL50 TO RBL50 IAW US AIRWAYS TYPICAL REPAIR NR 53-10-05-B.SDR 08FDEA04427Floorbeam · damagedMAIN CABIN FLOORBEAM, STA 1620 LBL25-45 HAS MISDRILLED SCREW HOLES. REPAIRED FLOORBEAM IAW SRM 53-00-51 REPAIR NR 1 FIG 201 AND SRM 51-40-02 MAJOR REPAIR NO FOLLOW-UP INSPECTION REQUIRED.SDR ASOA200801364Floorbeam · corrodedFLIGHT COMPT FLOORBOARD AFT SUPPORT ANGLE HAS CORROSION DAMAGE. REMOVED AND REPLACED AFT SUPPORT ANGLE AT FLIGHT COMPT FLOORBOARD. STARTED DRILLING UP NEW FWD COCKPIT FLOORBOARD LAND ALL HOLES AT PILOT SIZE DRILL UP NEW FWD FLOOR SUPPORT ANGLE EXCEPT CAM-LOCSDR ASOA200801363Floorbeam · corrodedRT FS 280 BEAM HAS CORROSION DAMAGE. R&R BEAM PER SRM 51-42-06. REINSTALLED RT DRIP TRAY IAW SRM 51-42-13 SB 670BA-53-026. REINSTALLED INTERCOSTALS IAW SRM 51-42-21. REINSTALLED PITOT STATIC LINE THRU BEAM IAW AMM 34-11-02. REPLACED WITH NEW T-BRACKET. RESDR ASOA200801362Floorbeam · corrodedLT FS 280 BEAM HAS CORROSION DAMAGE. REMOVED AND REPLACED. REPLACED WITH NEW T-BRACKET P/N BA 670-30072-15B. PICK UP ALL FASTENER HOLES IN BEAM, EXCEPT INTERCOSTALS T-BRACKET AND FWD COCKPIT BOARD LAND. FABRICATED U-BRACKET. ALL WORK DONE IAW SRM 51-24-SDR COEA0807917Floorbeam · corrodedFOUND AT COE MAJOR REPAIR FLOOR BEAM 10 IS CORRODED ON THE UPPER AND LOWER SURFACE OF THE INTERCOSTAL 10 INCHES LT AND RT OF BL 0.SDR DL757081429Floorbeam · corrodedFLOOR SUPPORT BRACKET AT BS 1480 RBL 11 CORRODED. REMOVED AND REPLACED SUPPORT BRACKET IAW SRM 51-30-01, DWG 146N5458, SRM 51-40-02.SDR DL757081427Floorbeam · corrodedFLOOR SUPPORT BRACKET AT BS 1460 RBL 11 CORRODED. REMOVED AND REPLACED SUPPORT BRACKET IAW SRM 51-40-02, SRM 51-30-01, DWG 146N5458.
Back to JASC 5315