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 2002UALA01677Crease Beam · crackedNOSE STATION 196 LEFT HAND CREASE BEAM WEB CRACKED. MAJOR REPAIR ACCOMPLISHED. REPLACED CREASE BEAM WEB.SDR 2002UALA01676Crease Beam · crackedNOSE FLIGHT DECK FLOOR STATION 196 RIGHT HAND CREASE BEAM WEB CRACKED. MAJOR REPAIR ACCOMPLISHED. REPLACED CREASE BEAM WEB.SDR C1HA2002020Shear Tie · corrodedCORRODED SHEAR TIE BS 950F STR 29R.SDR DL72S021302Torque Box · crackedFUSELAGE / VENTRAL STAIRWAY / RH TORQUE BOX STRUCTURE / FS 1263 : CRACK REPAIR THE VENTRAL STAIRWAY ACTUATOR ON THE RH TORQUE BOX AT FS 1263 WAS FOUND PULLED THROUGH THE UPPER WEB OF THE TORQUE BOX, RESULTING IN CRSDR 2002UALA01672Crease Beam · corrodedFUSELAGE RT CREASE BEAM CORRODED, STA 1420. MAJOR REPAIR ACCOMPLISHED. REPLACED CREASE BEAM.SDR 2002UALA01671Crease Beam · corrodedFUSELAGE RT SIDE CREASE BEAM HAS CORRODED FASTENERS. STA 1420 - 1440. MAJOR REPAIR ACCOMPLISHED. REPLACED CREASE BEAM WEB.SDR USAA020423Shear Tie · crackedPIT - FOUND SHEAR TIE CRACKED .5 INCH LONG, SHEAR TIE S2L AT STATION 639. DEFECTIVE PART REPLACED WITH IDENT PART NR. (M)SDR 2002UALA01655Crease Beam · corrodedCABIN FLOOR CREASE BEAM WEB CORRODED, STA 742, RBL 62. MAJOR REPAIR ACCOMPLISHED. REPLACED CREASE BEAM WEB.SDR 2002UALA01654Crease Beam · corrodedDOOR 2R CUT OUT CREASE BEAM IB CHORD CORRODED. MAJOR REPAIR ACCOMPLISHED. REPLACED IB CHORD OF CREASE BEAM.SDR C1HA2002015Shear Tie · corrodedCORROSION ON SHEAR TIE IN AFT PIT STA 950 BL 0.SDR 0203669869Bracket · crackedDuring an Mck in ATL P/N 9957860-6 bracket was found with a .25" long crack. Rpaired per EA 98-190823.SDR 2002UALA01651Crease Beam · corrodedCREASE BEAM INBOARD CHORD STA 733-755, LBL 63 STR 17L CORRODED. MAJOR REPAIR ACCOMPLISHED. REPLACED INNER CHORD.SDR C1HA2002009Shear Tie · corrodedCORROSION ON FRAME TO SKIN TIE AT STA 720A BETWEEN STR 28R - 27R FWD SIDE OF FRAME.SDR 02FDEA00817Shear Tie · corrodedCORROSION ON SHEAR TIE AT BS 720C+1 BETWEEN STR 18L - 28R. R&R SHEAR TIE PER SRM 51-30-2, 51-20-1.SDR CALA0200520Structure · damagedFUSELAGE AND VHF ANTENNA DAMAGE ADJACENT TO FWD CARGO DOOR. REPAIRED PER ECRA 5330-03175.SDR AALA20021632Door Frame · corrodedTUL - FOUND AFT CARGO LOWER DOOR JAMB BEAM HAS HEAVY CORROSION. REMOVED AND REPLACED AFT CARGO DOOR BEAM PER SRM 51-01-00. (M)SDR ASAA0280490Shear Tie · corrodedOKC - FOUND DURING 30K CHECK, AFT CARGO BAY SHEAR TIE CORRODED AT FS 1174, LONGERON 29L 29R. REPLACED SHEAR TIE PER SRM 53-14-3, 51-10-2 AND 51-30-5. (M)SDR AALA20021635Door Frame · corrodedTUL - FOUND SEVERAL CORRODED AREAS ON LOWER DOOR BEAM. INSTALLED DOUBLER ON DOOR BEAM PER SRM 53-10-00-03. (M)SDR AWXA200201120Crease Beam · corrodedDURING C-18 CHECK EXFOLIATION CORROSION WAS FOUND ON THE UPPER SURFACE OF CREASE BEAM (INNER CHORD) AT BS 967 - 1006, RBL 52. MAINTENANCE REMOVED CORROSION AND FOUND MATERIAL LOSS OUT OF LIMITS; REMOVED DRAIN TROUGH, 2 EACH SUPPORT ANGLES, AND DAMAGED CREASE BSDR MWEA020659Door Frame · corrodedAFT CARGO COMPARTMENT HAS MODERATE CORROSION ALONG LOWER DOOR JAMB STATION 1155-1193. REMOVED LOWER DOOR JAMB, LOCATED AND DRILLED DEBURRED DOOR JAMB.SDR CALA0200512ChannelCORROSION ON ANTENNA DOUBLER BETWEEN STA 500-500A, BL0. REMOVED AND REPLACED DOUBLER PER SRM 51-10-02.SDR MWEA020642Intercostal · bentFORWARD PASSENGER DOOR INTERCOSTAL BETWEEN #3 AND #4 BEAM IS BENT. -- REMOVED AND REPLACED INTERCOSTAL.SDR MWEA020641Strap · crackedFORWARD PASSENGER DOOR STRAP DOUBLER IS CRACKED AT #3 DOOR BEAM. -- REMOVED AND REPLACED STRAP.SDR CALA0200510Floor SupportMAIN CABIN FLOOR SUPPORT HAS CORROSION BETWEEN 312-328 AT LBL 11. REMOVED AND REPLACED FLOOR SUPPORT PER SRM 51-10-02.SDR GTIA021182Door Frame · corrodedFTW - FOUND MID B/B DOOR, LOWER JAMB CORROSION FROM 636-693. REMOVED JAMB BEAM. LOCATED AND DRILLED NEW DOOR BEAM. INSTALLED JAMB BEAM PER MD80 SRM 51-30-5. (M)SDR SWIA200211565Brace · crackedFRAME 13 LEFT INBOARD AND OUTBOARD SIDES, AND FRAME 13 RIGHT SIDE INBOARD SIDE OF VERTICAL BRACES CRACKED AT COCKPIT DOOR OPENING. FOUND DURING C CHECK INSPECTION. STOP DRILLED CRACKS IN BRACE. REMOVED CRACKED IB ANGLES. FABRICATED AND INSTALLED A NEW IB ASDR UPS02239863Panel · crackedINSPECTION TYPE:C&SI CRACK SUSPECT ON NLG BAY R/H SIDE PANEL @ BS 249.3 BETWEEN FASTENERS AFT OF R/H FWD PRESSURE PANEL CUTOUT REPAIR CARRIED OUT IAW SRM 51-40-2 FIG 1SDR 02FDEA00790Shear Tie · corrodedCORROSION ON SHEAR TIE AT BS 950B, STR 29R. R&R SHEAR TIE PER SRM 53-10-4 & EA 7-5310-67049.SDR 02FDEA00785Shear Tie · corrodedCORROSION ON SHEAR TIE AT BS 950B, STR 29R.SDR CALA0200509StringerCRACK IN STRINGER 16R FORWARD OF LIGHT AT APPROXIMATELY 500B. INSTALLED NEW STRINGER AND DOUBLER PER SRM 53-00-03.SDR ASAA0282460Shear Tie · corrodedSHEAR TIE CORRODED IN AFT CARGO BAY AT FUSELAGE STATION 1098, L30-L29R. REPLACED SHEAR TIE IAW SRM.SDR ASAA0280456Shear Tie · corrodedSHEAR TIE CORRODED IN AFT CARGO BAY AT FUSELAGE STATION 1287, L29L-L29R. REMOVED CORROSION AND INSTALLED DOUBLER IAW SRM.SDR UPS02239900Beam · crackedINSPECTION TYPE: C & SI, WHILE REMOVING RT BS 870 FITTING CRACK FOUND IN SIDE LOAD BEAM AT R BBL 54.50 REPAIRED IAW SMRO EO 2002-055-009. UPS ENGINEERING FILE NO. 727-53-2 0084SDR CALA0200508Bulkhead · corrodedAFT PRESSURE BULKHEAD SKIN AT STA. 1016 UNDER RT STIFFENER CORRODED AT BL0. INSTALLED DOUBLER PER EA 5310-04045.SDR C2XA02TY155Sill · corrodedDURING A SCHEDULED INSPECTION THE SERVICE DOOR FORWARD SILL WAS FOUND TO HAVE SEVERAL AREAS OF CORROSION. MAINTENANCE ACCOMPLISHED A BLEND-OUT REPAIR IAW EMBRAER GST 1927/02A, THE REPAIR WAS SATISFACTORY. THE AIRCRAFT WILL BE RELEASED UPON COMPLETION OF INSPSDR AALA20021585Door Frame · corrodedTUL - FOUND LIGHT CORROSION IN SPOTS ALONG AFT CARGO DOOR BEAM. INSTALLED DOUBLER ON AFT CARGO LOWER DOOR JAMB PER AARD 53-10-3. (M)SDR AALA20021549Shear Tie · crackedTUL - FOUND SHEAR TIE CRACKED, FS 1380. INSTALLED DOUBLER PER AARD 53-10-00-20. (M)SDR GAIA02150STDoor Frame · crackedDURING A ROUTINE INSPECTION, IT WAS DISCOVERED THAT THE C-1 DOOR CUTOUT AFT RIGHT FRAME HAD A CRACK IN THE SKIN IN TWO PLACES AT STRINGER S26R. REPAIR WAS ACCOMPLISHED IAW BOEING 727 SRM 51-40-2, FIGURE 1. THE AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR ABXA020283Shear Tie · crackedSHEAR TIES CRACKED ABOVE AND BELOW LONGERON 15 LEFT AT FS 1024. REPLACED CRACKED SECTION IAW DC-9 SRM 51-30-2 AND 51-30-5.SDR UPS02239865Frame · crackedINSPECTION TYPE:C&SI SUSPECT CRACK AT FUSELAGE FRAME ATTACH POINT AT BS 990 STR. 29L IN A FT CARGO BAY REPAIRED FRAME AS PER SRM 53-10-4 FIG 11SDR C2XAO2SH114Threshold · corrodedDURING C CHECK AFT SUPPORT UNDER MAIN DOOR THRESHOLD WAS FOUND TO HAVE CORROSION. MAINTENANCE REMOVED DAMAGE AND REPLACED AFFECTED SUPPORT IAW 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED TO RETURN TO SERVICE.SDR F3LA200200362Door Frame · crackedDURING C 2 CHECK, A CRACK WAS FOUND IN THE LOWER, FORWARD AND AFT CORNERS OF THE DOOR FRAME ON THE FORWARD BAGGAGE COMPARTMENT DOOR. THE LOWER, FORWARD AND AFT FRAMES OF THE FORWARD BAGGAGE COMPARTMENT DOOR WERE REPLACED IAW SB 737-52A1100, FIGURE 2, AND COMPSDR IXXA0200153SDoor Actuator · damagedDURING ROUTINE C-CHECK INSPECTION, A TEMPORARY REPAIR WAS DISCOVERED ON THE UPPER FORWARD L-1 DOOR JAMB STATION 25. REPAIR ACCOMPLISHED REMOVAL OF TEMPORARY REPAIR AND DAMAGED AREA FABRICATION AND INSTALLATION OF REPAIR DOUBLER AND TRIPLER IN ACCORDANCE WITH SDR IXXA0200152SDoor Frame · damagedDURING ROUTINE C-CHECK INSPECTION, A TEMPORARY REPAIR WAS DISCOVERED IN THE LOWER FORWARD L-2 DOOR JAMB STATION 1620. REPAIR ACCOMPLISHED REMOVAL OF TEMPORARY REPAIR AND DAMAGED AREA FABRICATION AND INSTALLATION OF REPAIR DOUBLER AND TRIPLER IN ACCORDANCE WITSDR ABXA020303Window Frame · crackedHFEC CRACK INDICATION AT WINDOW 21 RIGHT, 1/8 INCH FROM UPPER AFT EDGE, 3/16 INCH LONG. REPAIRED AREA IAW REA D953-45696-MR.SDR UPS02839823Shear Tie · crackedINSPECTION TYPE:C-2 SHEAR TIE AT FS 1680 CRACKED AT LONG 18L. REMOVED AND REPLACED SHEAR TIE IAW DAC DWG 5640243-1.SDR MWEA020622Door Frame · corrodedAFT CARGO DOOR JAMB LOWER PORTION LONGERON 28 RIGHT MODERATE CORROSION ON AND UNDER DOUBLER PLATE. REMOVED DOUBLER, FABRICATED AND INSTALLED NEW DOUBLER.SDR ASAA0280414Shear Tie · corrodedOKC - FOUND DURING 30K CHECK, SHEAR TIE CORRODED AT FS 1150, LONGERON 29L-29R. REPLACED SHEAR TIE PER SRM 53-14-3 AND 51-30-5. (M)SDR ASAA0280399Shear Tie · corrodedOKC - FOUND DURING 30K CHECK, AFT CARGO BAY SHEAR TIE CORRODED TWO PLACES AT FS 1212. REPAIRED SHEAR TIE PER SRM 53-03, FIG 6. (M)SDR ASAA0280400Shear Tie · corrodedOKC - FOUND 30K CHECK, AFT CARGO BAY SHEAR TIE FASTENER HOLES (8 EACH) CORRODED AT FS 1212. REPLACED SHEAR TIE PER SRM 51-30-2. (M)
Back to JASC 5310