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 IPXA1B66700Rib · corrodedINSPECTION TYPE:D, STA 960-987 LBL 5" AREA BODY FAIRING SUPPORT RIB FOUND CORRODED. FX - STA 960-987 LBL 5" AREA BODY FAIRING SUPPORT RIB REPLACED AND INSTALLED IAW SRM 51-10-02 AND 51-40-02, REV 59. THIS REPAIR IS CLASSIFIED AS MINOR REPAIR.SDR IPXA11566224Frame · damagedINSPECTION TYPE:SP, REPLACED UPPER SKIN ON MCD, FOUND DOUBLE HOLE COMMON TO BS 520, STR 10L LOWER SKIN PANEL LAP AREA'S. REPAIR IAW ATS ER 11-02359.SDR LR7A2011041900176Frame · corrodedDURING SCHEDULED C-9 CK IAW FOUND BELLY ANTENNA FRAME STRESS CORROSION AT FS257 TO FS277, BL0 WL126. REPAIR ACCOMPLISHED BY REPLACING FRAME IAW SMP583 CHAP 51-60 & 51-70.SDR ASOA201100746Door Frame · corrodedCORROSION AT BOTTOM CORNER OF SERVICE DOOR FRAME CUT OUT. FABRICATED OF REPAIR PARTS AND INSTALLED IAW REO 601R-53-21-1267 IAW STEP 4-11.SDR ASOA201100745Beam · corrodedWHILE INSPECTING AVIONICS COMPARTMENT DOOR CUTOUT SURROUNDING STRUCTURE, FOUND CORROSION ON BEAM AT FS 333 BETWEEN S26 - 27R. INSTALLED BEAM IAW SRM 51-42-06.SDR CALA2011041100278Crease Beam · corrodedACCOMPLISH A PERMANENT REPAIR WITHIN 12 MONTHS OF MARCH 30-2011 PLANNING CONTACT ENGINEERING AFTER 10 MONTHS BUT BEFORE 11 MONTHS FOR A PERMANENT REPAIR. REFERENCE ECRA 5310-05367 LT CREASE BEAM I/B CHORD CORROSION AT STATION 1300-1310. INITIATING A DIP TO ASDR IPXA11566111Structure · wornINSPECTION TYPE:C1, WHILE ACCESSING FOR INTERCOSTAL (CARD 930410) FOUND SCREW AND INSERT WEAR AT 4 EA LOCATIONS ON INNER CHORD BS 297 TO BS 324 LBL 62. R & R INNER CHORD IAW SRM 51-40-05-0G, 51-20-01-0G, 51-40-02-0G AND MM 25-00-00-7.SDR SWAA112564Crease Beam · corrodedDURING SCHEDULED 16Y CHECK, FOUND CREASE BEAM WEB CORRODED BETWEEN BS 807 TO BS 827, STR 17L. REMOVED AND REPLACED WEB PER SRM AND BAC DWG.SDR FDEA201104061339Door Frame · corrodedAFT CARGO CUT-OUT LOWER AFT INNER FLANGE SEAL BELOW FRAME WITH CORROSION. AFT CARGO DOOR CUT-OUT LOWER FWD CORRODED SEAL FRAME ANGLE R & R WITH NEW ANGLE 65-59595-4 IAW SRM 51-40-02, REV 102. REPAIR IS CLASSIFIED AS MINOR IAW GMM 6-2-100 CRITERIA.SDR FDEA201104061338Door Frame · corrodedAFT CARGO CUT-OUT LOWER FORWARD INNER FLANGE BELOW SEAL FRAME WITH CORROSION. AFT CARGO DOOR CUT-OUT LOWER FWD CORRODED SEAL FRAME ANGLE R & R WITH NEW ANGLE 65-59595-3 IAW SRM 51-40-02, REV 102. REPAIR IS CLASSIFIED AS MINOR GMM 6-2-100 CRITERIA.SDR V0XR413Y040611018Door Frame · crackedFS 1047 AFT BAGGAGE COMPARTMENT, AFT DOOR JAM CHANNEL CRACKED. REMOVED CRACKED CHANNEL IAW SRM 51-42-06. BLENDED OUT CRACK IAW REO 670-53-61-713 & CSRM 51-12-60. NDT VERIFIED THAT CRACK NO LONGER EXISTS. TREATED & PRIMED IAW SRM 53-61-58. INSTALLED CHANNESDR ASAA1149633Crease Beam · crackedR1 DOOR CREASE BEAM WEB CRACKED. REMOVED AND REPLACED SILL WEB IAW B737 400 SRM 51 40 02.SDR AALA20110405TUL06Pan · crackedCRACK IN WINDOW PAN UPPER AFT CORNER STATION 1060 RIGHT SIDE. INSTALLED REPAIR DOUBLER PER AARD 53-10-00-25.SDR AALA20110405TUL05Pan · crackedWINDOW PAN CRACKED UPPER FORWARD CORNER STATION 886 LEFT SIDE. INSTALLED REPAIR DOUBLER IN ACCORDANCE WITH AARD 53-10-00-25.SDR AALA20110405TUL04Door Frame · crackedFORWARD ENTRY DOOR JAMB WEB AT STATION 208 LONGERON 15 LEFT IS CRACKED. INSTALLED REPAIR STRAP PER AARD53-10-00-11.SDR AALA20110405TUL02Crease Beam · corrodedCORROSION ON CREASE BEAM STATIONS 1588 TO 1591. REPLACED CREASE BEAM.SDR IPXA11M66175Door Frame · crackedINSPECTION TYPE:4C, CRACK FOUND IN LOWER AFT SECTION OF R3 DOOR JAMB. FABRICATED AND INSTALLED REPAIR AT R3 DOOR JAMB AFT WEB BETWEEN STA 1305-1315 SRM 53-40-15, REPAIR 3, FIG 201.SDR ASOA201100690Beam · corrodedWHILE INSPECTING AVIONICS COMPARTMENT DOOR CUTOUT SURROUNDING STRUCTURE, FOUND CORROSION ON BEAM AT FS333.00 BETWEEN S27 AND 26 RT. REPAIRED IAW SRM 51-42-06.SDR UALA2011040401622Crease Beam · corrodedCREASE BEAM TRUSS BETWEEN BS 500 AND BS 480 HAS EVIDENCE OF CORROSION. MAJOR REPAIR ACCOMPLISHED: AFTER CORROSION FOUND OUT OF LIMITS PER SRM. FABRICATED CREASE BEAM ANGLES OUT OF 7075-T6 PER SRM. TREATED, PRIMED AND INSTALLED PER SRM.SDR DALA1124049871Window Frame · crackedMAIN CABIN WINDOW FRAME BETWEEN STA 794 AND 813 CRACKED AT UPPER FWD END. REMOVED RIVETS FOR ACCESS IAW SRM 51-30-2 PG-15. TRIMMED DAMAGED AREA IAW SRP DC9-A-56-20-02-801-66-3A-A. FABRICATED ANGLE 7075T6.063" IAW DC9-A-56-20-02-801-66-3A-A. INSTALLED REPAISDR SWAA112444Web · corrodedDURING SCHEDULED 16Y CHECK, FOUND WEB CORRODED BETWEEN BS 787 TO BS 807, STR 17L. REMOVED AND REPLACED WEB PER SRM AND BAC DWG.SDR SWAA112442Crease Beam · corrodedDURING SCHEDULED 16Y CHECK, FOUND CREASE BEAM WEB CORRODED BETWEEN BS 867 TO BS 887, STR 17L. REMOVED AND REPLACED WEB PER SRM AND BAC DWG.SDR SWAA112441Crease Beam · corrodedDURING SCHEDULED 16Y CHECK, FOUND CREASE BEAM WEB CORRODED BETWEEN BS 907 TO BS 927.5, STR 17L. REMOVED AND REPLACED WEB PER SRM AND BAC DWG.SDR SWAA112440Crease Beam · corrodedDURING SCHEDULED 16Y CHECK, FOUND CREASE BEAM WEB CORRODED BETWEEN BS 500B TO BS 500C, STR 17R. REMOVED AND REPLACED WEB PER SRM AND BAC DWG.SDR SWAA112439Crease Beam · corrodedDURING SCHEDULED 16Y CHECK, FOUND CREASE BEAM WEB CORRODED BETWEEN BS 360 TO BS 380, STR 17R. REMOVED AND REPLACED WEB PER SRM AND BAC DWG.SDR SWAA112435Crease Beam · corrodedDURING SCHEDULED 16Y CHECK, FOUND CREASE BEAM WEB CORRODED BETWEEN BS 887 TO BS 907, STR 17R. REMOVED AND REPLACED WEB PER SRM AND BAC DWG.SDR COEA2011040414903Crease Beam · corrodedHEAVY CK COE / MAJOR REPAIR / LEVEL 2 CORROSION: RT CREASE BEAM WEB FR 18-19 CORRODED ON UPPER AND LOWER SURFACES WITH A TOOLING MARK ON UPPER SURFACE (LENGTH 1.0', WIDTH .400"). REMOVED CORROSION AND TOOLING MARK, FABRICATED AND INSTALLED RT CREASE BEAM WEBSDR COEA2011040413903Crease Beam · corrodedHEAVY CK COE / LEVEL 2 CORROSION: LT CREASE BEAM INNER CHORD FR 17 - 22 CORRODED (LENGTH 4.00, WIDTH .700, DEPTH .013 INCH). REMOVED CORROSION, REMOVED AND REPLACED LT INNER CHORD IAW ATR42 SRM.SDR COEA2011040412903Crease Beam · corrodedHEAVY CK COE / LEVEL 2 CORROSION: RT CREASE BEAM INNER CHORD HAS THREE SMALL AREAS OF CORROSION FR 18-22. REMOVED CORROSION; REMOVED AND REPLACED CREASE BEAM INNER CHORD IAW ATR SRM.SDR DALA1123819870Door Frame · damagedMAIN PASSENGER CABIN FWD SERVICE DOOR JAMB REPAIR 53-05 FIG 55 DOOR SPLICE -43 SPLICE HOLES FALL IN RADIUS. FAB -43 SPLICE FROM MAT .071 2024-0. HEAT TREATED TO .071 2024-T42 ON PEMCO TRAVELER 2469NO1540. DRILLED AND INSTALLED -43 SPLICE IAW DC9 ERA 490833-SDR CA110331019Beam · corroded(CAN) CORROSION LEVEL 3 FOUND ON CABIN FLOOR STRUCTURE, CTR FUSELAGE I MIDDLE BEAM, BETWEEN FRAME 17 & 25.SDR FDEA201103311262Roller · corrodedROLLER TRACK Y805 FR60-63 HAS CORROSION TO THE AREAS ADJACENT TO THE FASTENER HOLES, CORROSION FOUND TO BE BEYOND SRM LIMITS. ROLLER TRACK CONSIDERED TO BE PRIMARY STRUCTURE. ROLLER TRACK FABRICATED IAW DRAWING A25775021 AND GMM 6-2-100 TRACK INSTALED IAW AMSDR FDEA201103311261Roller · corrodedROLLER TRACK FR32-38.2 Y STATION 1470 IS CORRODED BEYOND SRM LIMITS 53-10-15 ROLLER TRACK CONSIDERED PRIMARY STRUCTURE. ROLLER TRACK FABRICATED IAW DRAWING A25771313 AND GMM 6-2-100 AND REFITTED IAW AMM 25-52-21 PB401.SDR FDEA201103311260Roller · corrodedROLLER TRACK FR 32-38.2 Y STATION -140 IS CORRODED BEYOND SRM LIMITS REF 53-10-15 ROLLER TRACK CONSIDERED PRIMARY STUCTURE. ROLLER TRACK FABRICATED IAW DRAWING A25771313 AND GMM 6-2-100 AND REFIITED 6-2-100SDR FDEA201103311259Roller · corrodedROLLER TRACK FR32-38.2 Y STATION -1470 IS CORRODED BEYOND SRM LIMITS REF 53-10-15. ROLLER TRACK CONSIDERED PRIMARY STRUCTURE. REPLACEMENT ROLLER TRACK FABRICATED IAW DRAWING A255771313 AND GMM 6-2-100. TRACK REFITTED IAW AMM 25-52-21 PB 401SDR IPXA11566096Door Frame · gougedINSPECTION TYPE:C1, AFT CARGO DOOR LOWER EDGE FRAME IS GOUGED 31" FROM THE FWD EDGE. REPLACED EDGE BEAM IAW SRM 52-30-02-1A, SRM 52-30-02-0I, SRM 51-40-02-0G, SRM 51-40-08-0G, AMM 51-41-00-2.SDR AALA20110331TUL04Crease Beam · corrodedCORROSION ON TOP OF RIGHT FLOOR BOARD SUPPORT. REPLACED CREASE BEAM.SDR SWAA112385Crease Beam · corrodedDURING SCHEDULED 12Y CHECK, FOUND LT CREASE BEAM CORRODED AT BS 360-4, LBL 61, WL 208. REPAIRED BEAM PER SRM AND BAC DWG.SDR JR2R2011033100112Striker · corrodedSERVICE DOOR SILL SEAL STRIKER CORRODED AT FASTENER HOLE. REMOVED AND REPLACED DOOR SILL SEAL STRIKER IAW CRJ 900 SRM 51-42-06 AND 1-42-13.SDR IXXA11SMN0059SFitting · corrodedDURING ROUTINE C-CHECK INSP FOUND "D" CARGO DOOR JAMB FITTING CORRODED AT STA 1280.000, LONGERON 34 REMOVED CORRODED FITTING. CLEANED, TREATED AND PRIMED AREA. INSTALLED NEW FITTING IAW SRM 51-1-20D, SRM 51-1-8B, SRM 51-1-20D AND SRM 51-3-1.SDR AALA20110330TUL07Structure · dentedDENT IN FUSELAGE STATION 58.75 LONGERON 18 RIGHT. INSTALLED DOUBLER PER SRM 53-04-03.SDR FDEA201103291241Fitting · crackedDURING OPEN HOLE HIGH FREQUENCY EDDY CURRENT INSP ON FRAME 47 SPLICE FITTING BETWEEN STRINGER 24 AND STRINGER 26 IAW SB A300-53-6123R04, HOLE 'J' FOUND CRACKED. REPAIRED CARRIED OUT AS PER EO 6-5310-7-5017 A5 PART 5, REPAIR CLASSIFIED AS MAJOR PER GMM 6-2-1SDR FDEA201103291240Fitting · crackedDURING OPEN HOLE HIGH FREQUENCY EDDY CURRENT INSP ON FRAME 47 SPLICE FITTING BETWEEN STRINGER 24 AND STRINGER 26 IAW SB A300-53-6123R04, HOLE 'F' FOUND CRACKED. REPAIRED CARRIED OUT AS PER EO 6-5310-7-5017 A5 PART 5, REPAIR CLASSIFIED AS MAJOR PER GMM 6-2-10SDR FDEA201103291468Beam · damagedBS 1183 BULKHEAD LBL 20 BEAM AND WEB HAVE CLOSE ON CENTER SPACING BETWEEN FASTENERS. ACCOMPLISHED EA 7-5310-123586.SDR UALA2011033001516Crease Beam · corrodedRIGHT CREASE BEAM UPPER SURFACE HAS CORROSION AT BS 975 AT RBL 71. MAJOR REPAIR ACCOMPLISHED: CORROSION FOUND TO BE OUT OF LIMITS PER SRM. FABRICATED NEW CREASE BEAM WEB OUT OF 7075-0 .063 PER SRM. HEAT TREATED AND PRIMED PER AMM. TOP COATED CREASE BEAM WSDR DHLA201100505Door Frame · misrepairedREPAIR LOCATED ON C4 DOOR FRAME STA 1440.000, L 30R TO L 32R DOES NOT CONFORM , REMOVED REPAIR IAW SRM 51-1-21, SRM 51-1-20D. FABRICATED FILLER, DOUBLER, & TRIPLER IAW DWG ES D85300402-001-D, REV IR DATED 04-13-11. NDT INSPECTED CUT OUT AREA. NO CRACKS SDR ASOA201100652Doubler · corrodedLOWER DOOR FRAME DOUBLER AT FS 319.70 AND FS 349.00, RBL 42 SHOWS EVIDENCE OF CORROSION. REO 601R-53-21-1261 HAS BEEN ACCOMPLISHED AND ALL STEPS HAVE BEEN DOCUMENTED AND SIGNED FOR ON A NON-ROUTINE WORKCARD. ALL RII'S HAVE BEEN ACCOMPLISHED BY A TRAINED, QUASDR UALA2011032901496Crease Beam · corrodedLEFT CREASE BEAM O/B FLANGE COMMON TO INTERNAL FUSELAGE CORRODED AT STA 1006, LBL 71. AGING ACFT INSP FINDINGS. MAJOR REPAIR ACCOMPLISHED: REMOVED CORROSION, FABBED ANGLE, ACP'D HFEC ON ALL HOLES AND AREA FOR CRACKS. NO DEFECTS NOTED. INSTALLED ANGLE PER SDR SWAA112258Crease Beam · corrodedDURING SCHEDULED 12Y CHECK, FOUND CREASE BEAM CORRODED BETWEEN BS 316 TO BS 336. REPAIRED BEAM PER SRM.SDR SWAA112247Crease Beam · corrodedDURING SCHEDULED 242 CHECK, FOUND CREASE BEAM WEB CORRODED BETWEEN BS 360 TO BS 380, STR 17L. REMOVED AND REPLACED WEB PER SRM.
Back to JASC 5310