JASC 5310
Service difficulty reports · 38,573
Reports filed under 5310 · Fuselage Main, Structure, 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 = '5310' 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 = '5310' 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 USAA040128Crossbeam · corrodedBFM - FOUND 1.5 INCH LONG BY 1 INCH WIDE BY .02 INCH DEEP 4 PLACES, FR 1732 BETWEEN CROSSBEAM C66 AND C68. REMOVED AND REPLACED BEAM PER SRM 51-74-00, 53-00-14, 51-42-11. (M)SDR SIMA200311204Window Post · corrodedWHILE CHANGING THE CO-PILOTS WINDSHIELD TWO FASTENER HOLES IN THE LOWER AFT CORNER OF THE AIRFRAME OPENING WERE FOUND TO BE CORRODED. ONE OF THE FASTENER HOLES REMAINED WITHIN MANUFACTURERS LIMITS AFTER REMOVAL OF CORROSION. APPLIED ALODINE AND EPOXY PRIMER SDR SWIA200413177Beam · crackedMAIN FUSELAGE; UPPER TRANSVERSE BEAM CRACKED AT FS 280.00 LBL 11.0. DISCOVERED DURING C-CHECK INSPECTION. REPAIRED IAW CRJ REO 601R-53-11-138 REV NC AND RII53-401.SDR SWIA200413176Beam · crackedMAIN FUSELAGE; LOWER TRANSVERSE BEAM CRACKED AT FS 280.00 LBL 11.0. DISCOVERED DURING C-CHECK INSPECTION. REPAIRED IAW CRJ REO 601R-53-11-171 REV NC AND RII 53-401.SDR 2004UALA00353Door Frame · crackedMAIN CABIN AT STA 294 STR 7R DOOR JAM CORNER CRACKED. MAJOR REPAIR ACCOMPLISHED. FABRICATED & INSTALLED REPAIR DOUBLER.SDR 2004UALA00342Shear Tie · crackedAFT CARGO PIT STA 1300, STR 20L-21L, SHEAR TIE IS CRACKED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED NEW SHEAR TIE.SDR SWAA041053Crease Beam · corrodedDURING SCHEDULED D CHECK, FOUND CREASE BEAM WEB AT BS 360 TO BS 380, RBL 70, CORRODED. REMOVED AND REPLACED CREASE BEAM WEB PER SRM.SDR C7WA200400011Door Frame · crackedFOUND MAIN CARGO DOOR FORWARD UPPER FRAME CRACKED. REPAIRED FRAME IAW AERONAUTICAL ENGINEERS INC EO NR 1434. (M)SDR USAA040130Shear Plate · corrodedBFM - FOUND SHEAR PLATE CORRODED 3.5 INCH IN DIAMETER AND .010 INCH DEEP AREA, FRAME 71292 BETWEEN CROSSBEAM C89 AND C70 -Z40. REMOVED AND REPLACED SHEAR PLATE PER SRM 51-74-00, 53-41-17 AND 51-42-11. (M)SDR USAA040139Beam · corrodedBFM - FOUND BEAM CORRODED 2 INCHES BY 1.5 INCHES BY .025 INCH AREA, Y-254, FR 66-68, -Z240. REMOVED AND REPLACED BEAM PE SRM 51-42-11, 53-00-14. CORROSION LEVEL 2, TASK NR JA-260-53500. (M)SDR ASAA0480273Shear Tie · corrodedOKC - FOUND DURING HV CHECK, SHEAR TIE CORRODED AT FS 636. REPLACED SHEAR TIE PER SRM 51-30-5. (M)SDR C2XA04TY065Gusset · corrodedTYS - DURING A SCHEDULED INSPECTION CORROSION WAS FOUND ON THE GUSSET TOP CAP AT FRAME 20. MAINTENANCE ACCOMPLISHED THE BLEND-OUT REPAIR IAW EMB SRM 53-21-10 AND CPM 51-21-04, 05 AND 06. THE AIRCRAFT WILL BE RELEASED UPON COMPLETION OF INSPECTION.SDR USAA040140Beam · corrodedBFM - FOUND BEAM CORRODED 2 INCHES BY 2 INCHES BY .020 INCH DEEP, BETWEEN FRAME 64 AND 65, Y765, -Z240. REMOVED AND REPLACED BEAM PER SRM 53-00-14, 51-74-00, 51-42-11. (M)SDR SWAA041038Crease Beam · corrodedDURING SCHEDULED D CHECK, FOUND CREASE BEAM WEB FROM BS 328 TO BS 344, RBL 65, WL 208, CORRODED. REMOVED AND REPLACED WEB SECTION PER SRM.SDR GTIA040415Stop Fitting · corrodedFTW - FOUND AFT PIT DOOR STOP FITTINGS CORRODED AND RUSTY STATION 1193 FORWARD AND AFT. LOCATED AND DRILLED TWO NEW DOOR STOP FITTINGS. (M)SDR SWAA041029Crease Beam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND CREASE BEAM AT LT BS 907 TO LT BS 927, CORRODED. REMOVED AND REPLACED CREASE BEAM SECTION PER EA.SDR MWEA040050Angle · scratchedAFT CABIN DOOR JAMB AREA, LEFT SIDE OF AFT CABIN DOOR ANGLE HAS A DEEP SCRATCH IN RADIUS, IN BAY LONGERON 3. -- FABRICATED AND INSTALLED NEW ANGLE.SDR SWAA041015Crease Beam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND CREASE BEAM WEB AT RT BS 360 TO RT BS 380, LT BS 400 TO LT BS 420, CORRODED. REMOVED AND REPLACED CREASE BEAM WEB PER EA.SDR SWIA200413342Fitting · crackedMAIN FUSELAGE; PRESSURE FLOOR/WING TIE BEAM FITTING IS DENTED AND CRACKED ALONG LOWER FLANGE; LBL 3.0 FS 460.00. DISCOVERED DURING C-CHECK INSPECTION. NEW TIE BEAM FIT, DRILLED AND INSTALLED IAW CRJ SRM 51-40-11.SDR ABXA040144Beam · crackedCRACK INDICATION FOUND ON FORWARD LOWER CARGO DOOR NR 2 BEAM TEE FORWARD END AT SKIN RIVET. REPAIRED AREA IAW DC-9 SRM K05159 AND DC-9 SRM 51-30-5.SDR ABXA040149Shear Tie · corrodedCORROSION ON SHEAR TIE STA 851 ABOUT 6 INCHES ABOVE LONGERON 15 RIGHT. REPLACED SHEAR TIE IAW DC-9 SRM.SDR CALA0400350Shear Tie · crackedINSPECTION FOUND A 3 INCH CRACK IN FRAME SHEAR TIE AT STA 277 BETWEEN S16L AND S17L. A NEW SHEAR TIE SECTION WAS INSTALLED IAW SRM 53-00-07, FIGURE 207.SDR CALA0400344Shear Tie · crackedINSPECTION FOUND A 5 INCH CRACK IN FRAME SHEAR TIE AT STA 277 BETWEEN S15L AND S16L. A DOUBLER WAS INSTALLED IAW SRM 53-00-07, FIGURE 207.SDR GTIA040398Door Frame · corrodedFTW - FOUND CORROSION AT AFT PIT THRESHOLD BETWEEN SKIN AND DOUBLER. UPON FURTHER NOTICE, FOUND AFT DOOR JAMB BEAM CORRODED AND OUT OF LIMITS. REMOVED DOOR JAMB BEAM. REMOVED CORROSION FROM BETWEEN SKIN AND DOUBLER AT AFT THRESHOLD. FOUND SKIN TO BE OUT OFSDR CALA0400337Shear Tie · crackedINSPECTION FOUND A 3 INCH CRACK IN FRAME SHEAR TIE AT STA 277 BETWEEN STRINGERS 14 AND 15L. THE CRACKED SECTION OF SHEAR TIE WAS REMOVED AND A NEW SECTION WAS INSTALLED IAW SRM 53-00-07, FIGURE 207.SDR C2XA04SH205Buttstrap · corrodedDURING C-CHECK THE CENTER BUTTSTRAP AT FRAME 20 WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED BUTTSTRAP IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR UPS04242241Door Frame · crackedINSPECTION TYPE:C LWR FWD CARGO DOOR CUTOUT FRAME, CRACK INDICATION IN AREA NR 4 FWD DOOR STOP. REPAIR CARRIED OUT IAW SMRO EO 2004-027-01 UPS ENGINEERING FILE NR B727-5310-20302-ASDR HNAA0400033Beam · crackedTRANSVERSE BEAM CRACKED AT RELEASE CABLE HOLE AT R/H SIDE IN NLG BAY APPROX .3 INCH LONG, REPAIRED IAW EO 8-53-04-0241SDR 2004UALA00312Door Frame · crackedMAIN CABIN AT STA 294 STR 7R DOOR JAMB CORNER CRACKED. MAJOR REPAIR ACCOMPLISHED. INSTALLED REPAIR DOUBLER AND FILLER.SDR ASAA0480252Doubler · corrodedOKC - FOUND DOUBLER ATTACHED TO STATION 1271 CORRODED LONGERON 29R TO 29L. REMOVED DAMAGED DOUBLER, FABRICATED AND INSTALLED REPAIR DOUBLER IAW MD80 SRM 53-03. (M)SDR LR7A04037Beam · crackedDURING SCHEDULED C4 INSPECTION PER JOB CARD HC3212 FOUND RMLG WHEEL WELL BEAM ASSY CRACKED AT FS 530 AND 569, RBL 62, WL 240. REPLACED BEAM IAW SRM SMP 583 51-60 AND 51-70. NR 2086SDR ASAA0480205Door Frame · crackedFOUND HV CHECK, FOUND FASTENER HOLE CRACKED ON LEFT SIDE OF FUSELAGE ABOVE NOSE WHEEL WELL DOOR CUT OUT AT STATION 47. STOP DRILLED CRACK, INSTALLED DOUBLER PER SRM 53-01. (M)SDR AWXA200400440Pressure Panel · crackedMCN - MAJOR REPAIR - DURING C-15 CHECK A 1 INCH CRACK WAS FOUND IN MAIN DECK PRESSURE WEB AT BS 665, LBL 31. MAINTENANCE CUTOUT DAMAGED SECTION OF PRESSURE WEB AT BS 665, LBL 31; PERFORMED HFEC INSPECTION OF CUTOUT TO VERIFY NO CRACKS EXIST; FABRICATED A FILLESDR UPS04842166Shear Tie · corrodedINSPECTION TYPE:C3 STATION 1000 BETWEEN LONG 28L TO 29L SHEAR TIE IS CORRODED. REMOVED, FABRICATED AND REPLACED SPLICE PLATE AND FILLER IAW SRM 53-2-0 FIG 2A AND 2B.SDR SWAA040976Shear Tie · corrodedDURING SCHEDULED 1/4D CHECK, FOUND SHEAR TIE AT BS 867, RT AFT CARGO COMPARTMENT TRACK TO FRAME CORRODED. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR AALA20040433Shear Tie · corrodedTUL - SHEAR TIE ON FRAME 18 AT STATION 1340 HAS 2 INCH BY 2 INCH SECTION OF CORROSION. REPAIRED FRAME 18 AT SECTION 1340 PER SRM 53-10-13.SDR ASAA0440090Shear Tie · corrodedGYR - FOUND FORWARD CARGO COMPARTMENT, STATION 520 RBL 3, LOWER FRAME SHEAR TIE 100 PERCENT EXFOLIATED. FABRICATED AND INSTALLED 65-46534-9 SHEAR TIE. (M)SDR ASAA0440092Crease Beam · corrodedGYR - FOUND R1 DOOR THRESHOLD CREASEBEAM AT STATION 294.5 APPROX RBL 55, CORRODED IN NUMEROUS AREAS OF UPPER SURFACE. REMOVED AND REPLACED R-1 DOOR THRESHOLD CHORD STATION 262 TO 380 RBL 55 PER SRM 51-40-02. (M)SDR ABXA040136Door Frame · crackedTWO CRACKS EMANATED FROM FASTENER ON FORWARD LOWER CARGO DOOR JAMB UPPER FORWARD CORNER, 6 INCHES ABOVE UPPER FORWARD DOOR STOP AT FS 372, BETWEEN LONGERONS 20 AND 21 RIGHT. FORWARD CRACK LENGTH WAS .0937 INCH LONG, AFT CRACK LENGTH WAS .1562 INCH LONG. REPASDR ASOA04255Support Beam · crackedDURING A C-CHECK IN MCN, THE CENTER ENGINE SUPPORT BEAM UPPER WEB NEAR BL 0 WAS FOUND TO BE CRACKED BEYOND LIMITS. MAINTENANCE IS REPAIRING THE CENTER ENGINE SUPPORT BEAM UPPER WEB NEAR BL 0 IAW ASA EO 600-53-0072. (M)SDR USAA040075Beam · corrodedBFM - FOUND BEAM CORRODED 1.8 INCHES BY 1.4 INCHES BY .060 INCH AREA, FRAME 66-68, -Y1220, -Z240. REMOVED AND REPLACED BEAM PER SRM 53-00-14, 51-74-00, 51-42-11. CORROSION LEVEL 2, TASK NR JA-260-53500. (M)SDR USAA040074Beam · corrodedBFM - FOUND BEAM CORRODED 1.8 INCHES BY 1.4 INCHES BY .060 INCH AREA, FRAME 64, -Y1270, -Z240. REMOVED AND REPLACED BEAM. CORROSION LEVEL 2, TASK NR JA-260-53500. (M)SDR SWAA040939Crease Beam · crackedDURING SCHEDULED D CHECK, FOUND CREASE BEAM WEB AT BS 639, RBL 68, CRACKED. REMOVED AND REPLACED WEB PER SRM.SDR 2004UALA00299Shear Tie · crackedBS 767 STR 22L AND STR 23L HAVE CRACKED SHEAR TIES. MAJOR REPAIR ACCOMPLISHED. REPLACED SHEAR TIES.SDR 2004UALA00298Shear Tie · crackedBS 747 STR 22L AND STR 23L HAVE CRACKED SHEAR TIES. MAJOR REPAIR ACCOMPLISHED. REPLACED SHEAR TIES.SDR 2004UALA00297Shear Tie · crackedBS 787 STR 23L SHEAR TIE CRACKED AFT CARGO COMPARTMENT. MAJOR REPAIR ACCOMPLISHED. REPLACED SHEAR TIES.SDR 04FDEA00775Shear Tie · corrodedCORROSION WHILE WORKING N00607 FOUND CORROSION AT BS 1148 WL 153 ON SHEAR TIE. COMPLIED WITH FED EX EA 7-5310-55267 ON SHEAR TIE THAT WAS CORRODED AT BS 1148 WL 153.SDR 04FDEA00773Shear Tie · corrodedCORROSION ON SHEAR TIE, IN AFT CARGO BAY, BS 1148, WL 149, LBL 9. *S/D* COMPLIED WITH FED EX EA 7-5310-55267 ON SHEAR TIE THAT WAS CORRODED AT BS 1148 WL 149 LBL 9.SDR SWAA040922Window Post · crackedDURING SCHEDULED 1/4D CHECK, FOUND COCKPIT NR 1 WINDOW LT POST, OUTBOARD UPPER CORNER CRACKED. REPAIRED WINDOW POST PER SRM.SDR MWEA040044Door Frame · chafedMID CARGO PIT DOOR JAMB FORWARD HINGE, FORWARD SUPPORT IS CHAFED AT THE HINGE BOLT. FABRICATED AND INSTALLED DOUBLER.
Back to JASC 5310