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 FDEA201402270422Crease Beam · corrodedCREASE BEAM, STRINGER 17L, BS 297 - 420, FOUND CORRODED OUT OF LIMITS. LOCATED & DRILLED NEW CREASE BEAM IAW SRM 53-30-13 & DWG 141N8322. INSTALLED CREASE BEAM IAW SRM 51-40-02 & DWG 141N8322.SDR DALA14014205803Door Frame · gougedR4 DOOR FRAME UPPER FUSELAGE CUT-OUT GOUGED. BLENDED GOUGE ON R4 DOOR SEAL DEPRESSOR, FRAME UPPER FUSELAGE CUTOUT, REF DWG 146N6123. FOUND TO BE OUT OF LIMIT IAW SRM. R & R WITH NEW SEAL DEPRESSOR REF SRM 51-40-02.SDR DALA14013683219Structure · corrodedDURING INSPECTION, FOUND CORROSION ON LOWER AFT CORNER AT FRAME 20 OF RT FWD PAX DOOR CUT OUT. REPLACED LOWER AFT CORNER FITTING IAW SRM 51-72-11 AND DWG D53112225.SDR DALA2016110808563Structure · corrodedCORROSION ON CUT OUT OF FWD LAVATORY SERVICE ACCESS. DAMAGE AREA WAS REPAIRED IAW ER/A 521182-14.SDR SWIA201436840Beam · crackedPILOT'S FLOOR PROP AT OBSERVER SEAT THE OTBD SIDE MAIN BEAM IS CRACKED AND INBD SIDE BRACKET IS CRACKED. C-CHECK, REPAIRED PILOTS FLOOR PROP AT OBSERVERS SEAT OTBD SIDE MAIN BEAM AND REPLACED INBD SIDE BRACKET IAW ETD.SDR UHLA2014022600217Gusset · corrodedGUSSET AT LAV TANK SUPPORT ROD AT FRAME 89 CORRODED. R & R GUSSET PLATE.SDR DALA14013775803Crease Beam · corrodedLEFT CREASE BEAM INNER CHORD ANGLE HAS AREAS OF LIGHT CORROSION BETWEEN BS 1020 AND 1040. R & R CREASE BEAM INNER CHORD ANGLE AT BS 900-1040 MAIN CABIN LT SIDE IAW SRM 51-40-02.SDR ASOA2014032710186Drag Angle · crackedLEFT FUSELAGE TO RUDDER DRAG ANGLE CRACKED AT WHERE WL 102.50 CROSSES REAR SPAR DATUM 67.50 PERCENT. THIS REPAIR IS CLASSIFIED AS A MAJOR REPAIR IAW SOP 5702. REMOVED CRACKED DRAG ANGLE IAW SRM 51-42-34-001-001-A01 LOCATED DRILLED AND DEBURRED NEW DRAG ANGLESDR SWAA2014022725618Window Frame · crackedFLIGHT DECK WINDOW FRAME POST CD RT CRACKED AT THE UPPER CORNER. REPAIRED FRAME IAW EA.SDR CALA2014022590465Door Frame · corrodedR2 DOOR AFT FRAME 68 & STATION 23 HAS CORROSION. REMOVED CORROSION, FABRICATED REPAIR FITTING & INSTALLED IAW SRM 53-41-12 FG 202.SDR COEA2014040237908Window Frame · crackedDURING HEAVY CHECK. A CRACK INDICATION ON LT WINDSHIELD FRAME AT NODE FIVE. REPAIRED IAW SRAS IAW SO ET560 1925 00 1210 ISSUE B.SDR SWAA2014030725868Window Frame · crackedNR 1 LT HAND COCKPIT WINDOW UPPER OTBD FRAME CORNER CRACKED. R & R FRAME IAW ACO.SDR QXEA2014030400174Beam · corrodedFOUND LOWER SILL BEAM AT EMERGENCY EXIT CORRODED. REMOVED SILL BEAM IAW SRM 51-42-05-02-01 AND 51-42-45-02-01. INSTALLED SILL BEAM IAW SRM 51-42-05-02-01 AND 51-42-45-02-01.SDR DALA14013795803Crease Beam · corrodedRIGHT CREASE BEAM INNER ANGLE HAS AREAS OF LIGHT CORROSION FROM BS 1020 TO 1040. BLENDED CORROSION AND FOUND TO BE OUT OF LIMITS IAW IAW SRM 53-30-13. REMOVED AND FABRICATED CREASE BEAM INNER ANGLE BS 900-1040 IAW SRM 51-40-02, 51-40-05, INSTALLED CREASE BEASDR CALA2014022590436Door Frame · corrodedAFT PIT BULK CARGO DOOR FRAME FOUND CORROSION OUT OF LIMITS. REMOVED & FABRICATED PN 146T1281 4 FRAME WEB & 146T8211 2 FLOOR STIFFENER IAW DRAWING 146T1281 & 146T8211. NO DEVIATIONS NOTED.SDR QXEA2014022600159Rivet · corrodedCORRODED RIVETS AT BS 604.5 - 627.5, STRINGER 31R. REPLACED RIVETS IAW SRM 51-42-05 STEP 4E.SDR QXEA2014022600158Rivet · corrodedCORRODED RIVETS AT BS 584.5 - 604.5, STRINGER 31L. REPLACED RIVETS IAW SRM 51-42-05, STEP 4E.SDR QXEA2014022600157Rivet · corrodedCORRODED RIVETS AT BS 584.5 - 604.5 STRINGER 31R. REPLACED RIVETS IAW SRM 51-42-05 STEP 4E.SDR R61A201402230311Beam · corrodedDURING HEAVY CHECK, L2 DOOR CUTOUT LOWER THRESHOLD AROUND GIRT BAR FITTING DRAIN CUP FASTENERS HAVE CORROSION. MX R & R L2 DOOR CUT OUT LOWER THRESHOLD IAW SRM 51-40-02 PAINTED AREA IAW SRM 51-23-055,51-23-06, CONTINUATION CARDS VP-005111-2014/341 C1,C2,C3 FOSDR R61A201402210309Window Frame · damagedLIGHTNING STRIKE DAMAGE AT RT FWD PASSENGER WINDOW PLUG BETWEEN FRAMES 19-20. MAINTENANCE R & R RT FWD PASSENGER WINDOW PLUG IAW SRM 51-40-02, 51-43-04, 51-41-02, 51-41-00,SDR DALA14012059211Beam · corrodedAFT CARGO DOOR FRAME BEAM CORRODED. REMOVED CORROSION. FOUND TO BE OUT OF LIMITS. LOCATED, DRILLED AND INSTALLED DOOR FRAME BEAM IAW SRM 51-30-05, 51-30-02 AND DWG 5936038.SDR ASAA2014022007233Crease Beam · corrodedCREASE BEAM INBD ANGLE AT BS 500C, LT OTBD HAS CORROSION. ACFT GROUNDED. REMOVED ANGLE, FABRICATED NEW, AND INSTALLED IAW SRM 51-40-02-0G-0 AND 51-40-05-0G-0.SDR SWAA2014030425759Window Frame · crackedLT NR 1 COCKPIT WINDOW FRAME UPPER OTBD CORNER CRACKED. REPAIRED FRAME IAW ACO.SDR ASOA2014030310054Post · crackedFS 409+128, BL 0 VERT POST LT SIDE HAS AN INDICATION NOTED IN THE AFT FLANGE RADIUS A WATER LINE 69 APPROX .250"LONG X 60 PERCENT FSH FAILED NDT INSP. C/W REO:601R-53-41-1779, REV (P2). C/W EC/TC 601R-53-41-889 & MET ALL THE REQUIREMENTS OF REO: 601R-53-14-8SDR SWAA2014022625596Window Frame · crackedNR 3 WINDOW FRAME POST EF CRACKED AT NR 8 HOLE FROM TOP. REPAIRED FRAME IAW ACO.SDR DALA14011713745Beam · damagedDURING INSPECTION, FOUND DAMAGE TO SECTION 48 LOWER HORIZONTAL TORQUE BOX BEAM ON EXTRUDED ANGLE AND LIGHTNING HOLE AT APPROX BS 1110 RT SIDE. MAINTENANCE REPAIRED IAW ERA 523346-14, REV 0.SDR FDEA201402190367Strap · corrodedAPU AIR INLET DOOR CUT OUT, FWD STRAP HAS CORROSION AT BS 1787, STRINGERS 3 - 6R. CORROSION REMOVED FOUND OUT OF LIMITS IAW SRM 51-10-02 REV 111. STRAP REMOVED AND REPLACED WITH NEW STRAP IAW DWG. 148N3105 SHT 1 REV C. REPAIR CLASSIFIED MAJOR IAW GMM 6-2SDR UHLA2014021900155Beam · corrodedCORROSION FOUND ON LT BEAM AT FRAMES 86-89. R & R BEAM.SDR UHLA2014021900154Beam · corrodedCORROSION FOUND ON RT BEAM FRAMES 86-89. R & R BEAM.SDR UHLA2014021900151Gusset · corrodedCORROSION FOUND ON RT GUSSET PLATE FRAME 90. R & R GUSSET PLATE.SDR UHLA2014021900141Crossbeam · corrodedCORROSION FOUND ON CROSSBEAM FRAME 17 BETWEEN LT AND RT SEAT TRACK. REMOVED CORROSION BY BLENDING INSTALLED L-ANGLE SUPPORT DOUBLER ON CROSSFRAME, PN 170-21769-403. MAJOR REPAIRSDR IPXA2014022682068Structure · crackedRT MLG GANTRY NR 4 AT FR50.1 OTBD DAMAGED. ACCOMPLISHED REWORK OF RT MLG GANTRY IAW EO A300-5310-24922-B.SDR IPXA2014022682066Structure · crackedLT MLG GANTRY NR 4 AT FR 50.1 OTBD DAMAGED. ACCOMPLISHED REWORK OF LT MLG GANTRY IAW EO A300-5310-24922-B.SDR IPXA2014022682065Structure · crackedLT MLG GANTRY NR 2 AT FR 49.1 DAMAGED. ACCOMPLISHED REWORK OF LT MLG GANTRY IAW EO A300-5310-24922-B.SDR IPXA2014022682064Structure · crackedRT MLG GANTRY NR 3 AT FR49.1 INBD DAMAGED. ACCOMPLISHED REWORK OF THE RT MLG GANTRY IAW EO A300-5310-24922-B, APPENDIX D.SDR IPXA2014022682059Structure · crackedRT MLG GANTRY NR 4 AT FRAME 52 OTBD DAMAGED. ACCOMPLISHED REPAIR OF RT MLG GANTRY IAW EO A300-5310-24922-B.SDR QXEA2014022600154Beam · corrodedAFT SERVICE DOOR EDGE BEAM, AND THRESHOLD HAVE EVIDENCE OF CORROSION. REMOVED EDGE BEAM AT AFT RT SERVICE DOOR, IAW SRM 51-42-05.
INSTALLED EDGE BEAM IAW SRM 51-42-05.SDR FDEA201402180356Crease Beam · corrodedBS 1020 - 1040 CREASE BEAM INBD ANGLE UPPER SURFACE FOUND CORRODED. REPAIRED IAW EA F-5310-T0306951 PART 1. REPAIR IS MAJOR.SDR FDEA201402180355Crease Beam · corrodedCREASE BEAM INBD ANGLE UPPER EDGE FOUND CORRODED BS 997. REPAIRED IAW EA F-5310-T0306904 PART 1. REPAIR CLASSIFIED AS MAJOR.SDR ASOA2014031910140Structure · crackedTRU SHELF CRACKED LT SIDE OTBD OF SERVICING GAUGE, BS 193. COMPLIED WITH REO 601R53-11-081. RECEIVED AND COMPLIED WITH REO 601R-53-2634. MAJOR REPAIR.SDR SWAA2014030325694Window Frame · crackedLT NR 3 WINDOW FRAME E F POST, SECOND FASTENER HOLE FROM BOTTOM CRACKED. REPAIRED FRAME IAW ACO.SDR DALA2016103107996Beam · corrodedDURING INSPECTION FOUND AFT WET AREA STATION 986.5 LBL 4 TO RBL 4 FASTENER HOLES CORRODED. MAINTENANCE REPAIRED BS 986 BEAM AT LBL 4 TO RBL 4 IAW ER/A 464736-14MA.SDR DALA2016103107995Beam · corrodedDURING INSPECTION FOUND FASTENER HOLES CORRODED UPPER SURFACE. MAINTENANCE REPAIRED BEAM AT BS 986, RBL 23-34 IAW ER/A 464736-14MA.SDR SWAA2014030425752Window Frame · crackedRT NR 3 WINDOW FRAME E F POST SECOND FASTENER HOLE FROM BOTTOM CRACKED. REPAIRED FRAME IAW ACO.SDR SWAA2014030325696Window Frame · crackedFLIGHT DECK LT NR 1 WINDOW FRAME OTBD UPPER CORNER CRACKED. R & R FRAME IAW ACO.SDR DALA14010989211Beam · corrodedMID CARGO DOOR FRAME BEAM CORRODED. REMOVED CORROSION. FOUND TO BE OUT OF LIMITS. FABRICATED AND INSTALLED NEW DOUBLER AND SPACER IAW SRM 53-60-02.SDR SWAA2014021925324Window Frame · crackedCAPTAIN`S FWD OUTER WINDOW FRAME CRACKED BELOW UPPER LT UPPER EDGE OF FRAME. REPAIRED FRAME IAW EA.SDR FDEA201402170343Door Frame · corrodedAFT CARGO DOOR FWD CUTOUT FRAME CORRODED AT FR 59A BETWEEN STRINGER 42R - STRINGER 43R. REMOVED CORROSION IAW A300-600 SRM51-74-10 & REPAIR IAW EA6-5310-T0305876. TITLE FUSELAGE MAIN FRAME. CORROSION ON FRAME 59A AT STRINGER 42R - 44R.SDR ASOA20140217019Beam · corrodedDURING C-CHECK, CARGO LOWER BEAM CORRODED BETWEEN FRAMES 65-68. MAINTENANCE R & R CARGO LOWER BEAM IAW SRM 51-40-02. ACFT APPROVED FOR RETURN TO SERVICE.SDR SWAA2014022625589Door Frame · corrodedFWD CARGO COMPARTMENT DOOR CUTOUT LOWER DOOR JAMB CORRODED. REPAIRED JAMB IAW SRM.
Back to JASC 5310