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 SWAA2014090231495Door Frame · crackedL1 DOOR FRAME CRACKED AT BS 340 STRINGER 6L. REPAIRED FRAME IAW EA.SDR SWAA2014081330830Crease Beam · corrodedCREASE BEAM INNER CHORD CORRODED BETWEEN BS 305 TO 344 BETWEEN LBL 54 TO LBL 60. R & R CHORD IAW SRM & DWG.SDR SWAA2014071630035Crease Beam · corrodedR1 DOOR CREASE BEAM INNER CHORD CORRODED BETWEEN BS 292 TO 358 BETWEEN LBL 54 TO LBL 60. R & R CREASE BEAM IAW SRM & DWG.SDR ASOA20140702178Partition · corrodedDURING C-CHECK, RT WALL DOUBLER AT FRAME 60 HAS CORROSION, 100 PERCENT THROUGH. MAINTENANCE R & R RT WALL DOUBLER IAW SRM 51-40-02. ACFT APPROVED FOR RETURN TO SERVICE.SDR ASAA2014070208566Window Frame · corrodedRIGHT WINDOW CASTING DOUBLER AT BS 470 HAS CORROSION. ACFT GROUNDED. REMOVED AND DRILLED AND INSTALLED NEW WINDOW CASTING IAW SRM 5140-02-0G-0.SDR ASAA2014070208514Window Frame · corrodedRIGHT WINDOW CASTING DOUBLER AT BS 450 HAS CORRODED. ACFT GROUNDED. R & R WITH A NEW RT WINDOW CASTING AT STA 450 IAW SRM 51-40-02-0G-0, W 1", O .120, R .109, L 2", D .011.SDR DALA2014071004027Structure · corrodedCORROSION ON TOP OF CENTER WING BOX UPPER SKIN, LBL 50-54, FS 1003. REMOVED CORROSION. FOUND TO BE OUT OF LIMITS. WORKED AREA PER SRM 51-10-03 AND ERA 526001-14, REV I.SDR DALA2014070803958Door Frame · corrodedAFT CARGO DOOR LOWER FRAME CORRODED. FABRICATED AND INSTALLED NEW THRESHOLD AND SPACER IAW SRM 53-60-02, FIG 9A.SDR USAA2014070700043Crease Beam · corrodedC4 CHECK CREASE BEAM CORRODED AT BS 1240 & RBL 63. FABRICATED & INSTALLED REPLACEMENT BEAM IAW SRM 53-60-13 FIG 101 DETAIL 8, 51-40-02 & DWG 146N5590.SDR DALA2014070303923Structure · crackedCRACK ON PRIMARY STAND BY EXHAUST AREA BETWEEN LONGERONS 21-22L BS 261. EXHAUST DUCT WAS REMOVED, DAMAGE AREA WAS REMOVED, REPAIR SECTION WAS FABRICATED AND INSTALLED IAW SRM 51-30-2, 51-10-3 PAR 14/21 AND ERA 464964-14MA.SDR SWAA2014090231503Door Frame · crackedFORWARD GALLEY DOOR CUT OUT STRUCTURE FRAME CRACKED AT BS 294.5 STRINGER 7R. REPAIRED FRAME IAW EA.SDR ASOA2014072110915Door Frame · corrodedCORROSION FOUND AT FS 364-394, S25 LT - 25RT AVI DOOR SURROUND INSIDE. REMOVED CORROSION IAW SRM 851-21-06-001-001. BLENDED AREA IS OUT OF LIMITS IAW SRM 53-21-01-101-000801. REPAIRED IAW REO 670-53-21-242. MAJOR REPAIR.SDR DALA2014070803959Door Frame · crackedLEFT WHEEL WELL OPENING CRACKED AT AFT OUTBOARD EDGE. DAMAGE CONTAINED. FABRICATED AND INSTALLED FRAME REPAIR IAW SRM 53-60-02, FIG 8.SDR SWAA2014080630630Door Frame · crackedFORWARD ENTRY DOOR FRAME OUTER CHORD CRACKED AT BS 348.2. REPAIRED CHORD IAW EA.SDR VNAA2014063000025Crossbeam · crackedDURING SCHEDULED MAINTENANCE, THE BS 280 CROSSBEAM WAS FOUND CRACKED OTBD OF RBL 9. THE AREA WAS INSPECTED AND REPAIRED IAW AMM. ACFT WAS RELEASED FOR SERVICE.SDR IPXA201407023456Structure · damagedSEVERAL GOUGES FWD OF TAILSTAND BALL. REPAIRED IAW EO A300-5330-54611-A.SDR 7AHR548B2601Structure · chafedBS 1401, AFT STAIRWAY INBD OF LT HEAT EXCHANGER THE WALKWAY STRUCTURE IS CHAFED. REMOVED UPPER SECTION OF FRAME IAW SRM 51-70-5. FABRICATED REPAIR AND INSTALLED IAW SRM 51-310-3, 51-70-5, 51-30-2 & 51-30-5.SDR R61A201406290856Beam · corrodedDURING HEAVY CHECK, L2 DOOR SEAL BOTTOM FRAMES 85-87 AT 3 LOCATIONS CORRODED. MX BLENDED OUT CORROSION REMOVED LOWER SILL MATCH DRILLED REPLACED LOWER SILL BEAM IAW SRM 51-43-04,51-43-03. RESTORED TOP COAT APPLIED CIC TO L2 DOOR LOWER BEAM IAW 51-23-06 CPM SDR DALA2014063003869Pan · crackedCRACK ON PAN OF LT EMERGENCY OVERWING AFT EXIT DOOR AFT MID SECTION. NEW DOUBLER WAS FABRICATED, DRILLED, TRIMED, AND INSTALLED IAW SRM 52-05D, FIG 51.SDR R61A201406290800Fastener · corrodedDURING HEAVY CHECK, R2 DOOR BOTTOM SEAL FRAMES 85-87 FASTENERS ARE CORRODED. MX R & R FASTENERS IAW SRM 51-41-02, 51-23-02,51-23-06, FCBS 53-23-007.SDR SWAA2014072130147Stop Fitting · crackedL1 DOOR STOP FITTING CRACKED AT BS 348 STRINGER 16L. REPAIRED FITTING IAW SRM.SDR SWIA201438671Splice · crackedINBD AND OTBD SPLICE ANGLES AT BS 283, S3L CRACKED. C-CHECK, INSTALLED NEW SPLICE ANGLES IAW SRM.SDR SWAA2014071029857Crease Beam · corrodedLEFT CREASE BEAM WEB CORRODED BETWEEN BS 747 TO 767. R & R WEB IAW SRM.SDR DALA2014063003831Door Frame · crackedLEFT WHEEL WELL, AFT DOOR FRAME CRACKED AT OTBD END. REPAIR COMPLETED IAW SRM 53-60-02, FIG 8 AND ERA 520684-14MA, REV O.SDR SWAA2014072530317Crease Beam · crackedRIGHT CREASE BEAM INNER CHORD CRACKED AT BS 639 WL 208. REPAIRED CHORD IAW EA.SDR SWAA2014071530009Crease Beam · buckledLEFT CREASE BEAM WEB BUCKLED BETWEEN BS 360 TO 380 STRINGER 17L. R & R WEB IAW SRM & DWG.SDR SWAA2014071429938Crease Beam · corrodedRIGHT CREASE BEAM WEB CORRODED BETWEEN BS 847 TO 867. REPAIRED WEB IAW SRM & DWG.SDR R61A201406260829Crossbeam · corrodedDURING HEAVY CHECK, CROSSBEAM AT FRAME 17 HAS RAZOR GOUGE WITH CORROSION. MX REPAIRED FRAME 17 CROSSBEAM IAW ETD 170-053968.SDR DALA2014062703821Finger Doubler · corrodedAFT CARGO LONGERON 26L, FINGER DOUBLER CORRODED, BS 1260-1307. REMOVED DAMAGE. FABRICATED AND INSTALLED NEW FINGER DOUBLER DWG 5936667, REV BZ, BW, AND CD, DWG S00056 AND SR 53-00-01.SDR USAA2014062700026Crease Beam · corrodedC4 CHECK LEVEL 2 GALVANIC CORROSION ON CREASE BEAM BETWEEN BS 640 - 900, RBL67. REPLACED CREASE BEAM BETWEEN BS 640 - 900, RBL 67 IAW SRM 51-40-02, 51-40-05, 51-20-01 & AMM 51-21-00.SDR YENA20140626118Crossbeam · corrodedON MAINTENANCE CHECK, FOUND CORROSION ON FWD CABIN CROSSBEAM AT FRAME 14 OTBD OF RT SEAT TRACK ON REAR. REMOVED STRAP, FABRICATED REPAIR STRAP, ACCOMPLISHED DVI OF BEAM, PRIMED AND TOPCOAT REPAIR. WORK COMPLIED WITH TC EC E14-307-01.SDR ASAA2014062508429Door Frame · corrodedAFT CARGO DOOR CUT-OUT, WEB CORRODED BS 803-BS 830, RBL 26. ACFT GROUNDED. REMOVED CORROSION FROM AFT CARGO CUT-OUT SILL WEB FROM BS830, RBL 26. ORIGINAL MATERIAL THICKNESS 0.056. MATERIAL LOSS 0.016. MAX ALLOWABLE MATERIAL LOSS 0.005. REMAINING MATERIAL THSDR R61A201406250837Beam · corrodedDURING HEAVY CHECK, BOTH AFT SERVICE DOOR EMERGENCY EVAC FITTINGS ARE CORRODED. MX R & R LOWER SILL BEAM AND REPLACED IAW SRM 51-40-04, 51-40-02, 51-41-01, 51-41-02, 51-43-03, 51-43-04. MAJOR REPAIRSDR R61A201406240827Structure · corrodedDURING HEAVY CHECK, WASTE SERVICE BOX DOUBLER FWD INBD CORNER IS CORRODED. MX R & R WASTE SERVICE BOX IAW E0-53-10-0020 AND 51-43-04. APPLIED TOP COAT AND CIC PROTECTION IAW SRM 51-23-06 CPM 51-25-00.SDR R61A201406240823Bolt · corrodedDURING HEAVY C-CHECK, R2 DOOR CUT OUT, ALL DOOR STOP MOUNTING BOLTS RUSTY. MX R & R R2 DOOR DOOR STOP MOUNTING BOLTS IAW AMM2-23-25.SDR DALA2014062603794Door Frame · corrodedCORROSION ON AFT DOOR FRAME BS 1212 LONGERON 26 RT. DAMAGE AREA WAS REMOVED, FILLER AND DOUBLER WERE FABRICATED, NDT CHECK AND WERE TREATED AND PAINTED, REPAIR PARTS WERE INSTALLED IAW SRM 51-10-3 PAR. 21, 14, 38 AND 53-01, FIG. 2.SDR USAR2014F00096Door Frame · crackedMAINTENANCE FOUND TWO CRACKS ON THE LOWER AFT SIDE OF THE MAIN ENTRY DOOR FRAME, TOP PART OF THE LOWER AFT MOUNT CONNECTING TO THE LOWER DOOR SUPPORT STRUT.SDR USAR2014FA0000397Door Frame · crackedMAINTENANCE FOUND TWO CRACKS ON LOWER FWD AND AFT OF THE ENTRY DOOR FRAME, TOP PART OF THE MOUNT CONNECTING TO THE LOWER DOOR SUPPORT STRUT.SDR USAR2014F00098Door Frame · crackedDURING PERIODIC MAINTENANCE DAILY INSPECTION. PERSONNEL DISCOVERED A CRACK IN THE LOWER FORWARD CORNER OF THE ENTRY/CARGO DOOR FRAME, APPROXIMATELY 1.300" IN LENGTH.SDR SWAA2014072830383Door Frame · crackedFORWARD GALLEY DOOR CUT OUT STRUCTURE OTBD OF FWD UPPER LATCH FITTING CRACKED. R & R STUB FRAME IAW DWG & SRM.SDR SWAA2014070229569Post · crackedCOCKPIT LT NR 1 WINDOW POST CRACKED. REPAIRED POST IAW ACO.SDR SWAA2014070229568Window Post · crackedCOCKPIT RT NR 3 WINDOW POST CRACKED. REPAIRED POST IAW ACO.SDR SWAA2014070229567Window Post · crackedCOCKPIT LT NR 3 WINDOW POST CRACKED. REPAIRED POST IAW ACO.SDR FDEA201406231530Crease Beam · corrodedR2 DOOR LOWER CUT OUT CREASE BEAM ANGLE CORRODED. R & R R2 DOOR INBD CHORD STATION 670 RT - 760 RT IAW SRM 51-40-02 & DWG 143N8322. REMOVED CORROSION IAW SRM 51-10-02, FOUND TO BE OUT OF LIMITS IAW SRM 53- 30-13 FIG 10 DET VIII.SDR FDEA201406231529Crease Beam · corrodedL2 DOOR CUT OUT CREASE BEAM ANGLE CORRODED AT BS 740 - 760. R & R INBD CHORD IAW SRM 51-40-02 & DWG 143N8322. REMOVED CORROSION IAW SRM 51-10-02, FOUND TO BE OUT OF LIMITS IAW SRM 53-30-15, FIG 101, DET VI.SDR UHLA2014062200483Crossbeam · corrodedCORROSION FOUND ON CROSSBEAM FRAME 84 LT. REPAIRED CROSSBEAM. MAJOR REPAIR.SDR UHLA2014062200482Crossbeam · corrodedCORROSION FOUND ON CROSSBEAM BETWEEN SEAT TRACKS FRAME 84. REPAIRED CROSSBEAM. MAJOR REPAIR.SDR UHLA2014062200481Crossbeam · corrodedCORROSION FOUND ON CROSSBEAM FRAME 84 RT. REPAIRED CROSSBEAM. MAJOR REPAIR.SDR UHLA2014062200479Crossbeam · corrodedCORROSION FOUND ON CROSSBEAM, FRAME 17 BETWEEN SEAT TRACKS. CUT OUT DAMAGED AREA AND INSTALLED A ANGLE DOUBLER IAW ETD2014-170-053184. MAJOR REPAIR.SDR UHLA2014062200478Crossbeam · corrodedCORROSION FOUND ON CROSSBEAM FRAME 17 Y+10.748. CUT OUT DAMAGED AREA OF CROSSBEAM AND INSTALLED AN ANGLE DOUBLER IAW ETD2014-170-053184. MAJOR REPAIR.
Back to JASC 5310