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 2007UALA03308Crease Beam · damagedAFT CARGO CREASE BEAM AT WL 208 IS DAMAGED. MAJOR REPAIR ACCOMPLISHED: INSTALLED TYPICAL EXTRUDED SECTION REPAIR. CREASE BEAM CUT AT STA 776. REPAIRED FROM STA 770-782 STR 17R.SDR IXXA07SMN224SStructure · misrepairedDURING ROUTINE C CHECK INSPECTION, FS 1345, LONGERON 30.5 LEFT. DOUBLER BELOW AND AFT OF AFT EMERGENCY EXIT DOOR. REPAIR NUMBER 606 AL-R36. PROBLEM: SIDE 2, 2ND ROW EXCEEDS MAS RIVET SPACING. DISPOSITION: ADD RIVETS TO BRING INTO LIMITS OR UPGRADE.SDR SWAA074127Door Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND AFT CARGO DOOR CUTOUT FWD FRAME CRACKED AT NR 5 DOOR STOP. REPAIRED FRAME PER ACO.SDR SWAA074132Crease Beam · corrodedDURING SCHEDULED 20Y CHECK, FOUND CREASE BEAM WEB CORRODED BETWEEN BS 500A AND BS 500C, STR 17L. REMOVED AND REPLACED CREASE BEAM WEB PER SRM.SDR ABXA070294Pan · crackedWINDOW PAN RING CRACKED AT FORWARD TOP AND AFT LOWER TABS AT STA 677. REPAIRED AREA IAW DC9 SSRM K07226.SDR 2007UALA03282Crease Beam · corrodedCREASE BEAM CORRODED: LT PASS CABIN CREASE BEAM WEB CORRODED AT STA 727C+17 WL 208. REMOVED CORROSION. FABRICATED & INSTALLED FILLER & REPAIR STRAP.SDR 07FDEA02989Fitting · damagedFOUND IN MANHOLE FITTING AN EXISTING POCKED REPAIR IN BAD CONDITION AT C38.2. REPAIR PERFORMED BY INSTALLING NEW FILLER IAW EA 6-5314-112469, APPROVED BY RAS/DABRE/70008163/2007 ISSUE "A".SDR 07FDEA02981Beam · corrodedCORROSION ON FWD CARGO DOOR SILL BEAM AT FRAME LOCATIONS 25 AND 25A. REPAIR PERFORMED WITH CUTOUT OF UPPER FLANGE AND INSTALLATION OF A MACHINED ANGLE IAW TD/K7/S1/08107/2007 IN EA 6-5313-112452, APPROVED BY RAS/DABRE/7008107/2007 ISSUE "B".SDR 07FDEA02978Beam · corrodedAFTER BLEND OUT OF HEAVY CORROSION ON FOLLOWING PART AT C67-69 BULK CARGO DOOR CUT OUT, REMAINING THICKNESS IS UP TO 50 PERCENT. BEAM SECTION: A539-730057-202 REPAIR PERFORMED BY REPLACEMENT OF BEAM SECTION IAW SRM 51-72-10.SDR 07FDEA02977Structure · corrodedAFTER BLEND OUT OF HEAVY CORROSION ON FOLLOWING PART AT 69 BULK CARGO DOOR CUT OUT, REMAINING THICKNESS IS UP TO 50 PERCENT. REPAIR PERFORMED BY REPLACEMENT OFF MENTIONED PART IAW SRM 51-72-10.SDR 07FDEA02976Structure · corrodedSTRUCTURE CORRODED BETWEEN C65- 70, P 56-57 REPAIR PERFORMED BY REPLACEMENT OF PART IAW SRM 51-72-10.SDR COEA0706821Crease Beam · damagedFOUND TOOLING DAMAGE (3) PLACES ON CREASE BEAM WEB. FABRICATED REPLACEMENT CREASE BEAM WEB. WO NR 72242, NR 200066. (K)SDR DLM88071123Fitting · corrodedEXFOLIATION CORROSION ON FITTING IN FWD LWR CORNER OF C-3 AT JOINT WITH FUSELUGE SKIN AND DOOR JAMB BEAM. (TASK 57-53300). REPLACED PER DRWG, 5930483 ON N/R T0064934 IN HMV AT GDL.SDR DLM88071104Door Frame · corrodedFOUND CORROSION ON C-2 LOWER DOOR JAMB FROM FS=636 TO FS 693 (TASK 51-53300). REPAIRED PER SRM 53-05D FIG 63 ON N/R T0064848 AT HMV IN GDL.SDR 2007UALA03255Door Frame · gougedAFT CARGO DOOR OPENING, FWD FRAME HAS DEEP GOUGE AT LOWER END, MAJOR REPAIR ACCOMPLISHED: REMOVED AND REPLACED FRAME.SDR DLM88071122Structure · crackedFOUND CRACK ON STRUCTURE OF RIGHT SIDE OF AFT PASSENGER DOOR JAMB STA 1348 Z 20. REPLACED IAW DWG 5917579.SDR 2007UALA03214Crease Beam · damagedAFT PIT OPENING, NEED TO CUT RT CREASE BEAM INNER CHORD AT CABIN FLOOR STR 17R TO REMOVE SEGMENT TO FACILITATE FRAME REPAIR AT BS 781. REPAIRED PER SRM 51-70-12 FIG 1 SHEET 3 PAGE 5-6.SDR 2007UALA03213Door Frame · crackedFWD CARGO DOOR OPENING, AFT FRAME IS CRACKED AT LOWER STOP FITTING. REPAIRED FWD CARGO DOOR AFT FRAME PER MM 53-30-75 PG 801-815.SDR 2007UALA03212Crease Beam · crackedFOUND CREASE BEAM WEB CRACKED AT BS 639L, LBL 62. MAJOR REPAIR ACCOMPLISHED: INSTALLED DOUBLER REPAIR ON CREASE BEAM WEB.SDR 07FDEA02945Beam · corrodedCORROSION ON AFT CARGO DOOR SILL BEAM, C59-62 REPAIR PERFORMED BY REPLACEMENT OF UPPER FLANGE OF SILL BEAM IAW SRM 53-17-18 AND DRAWING 17R53970133, APPROVED BY EA 6-5317-114839 AND RAS/DATLS/0003813/2007 ISS B.SDR 07FDEA02943Fitting · corrodedCORROSION ON UPPER CORNER FITTING C88 RT REPAIR PERFORMED BY DOUBLER INSTALLATION IAW EA 6-5319-10651 AND RAS/DATLS/0003749/2007 ISS B.SDR SWIA200718690Rib · crackedLEFT DV WINDOW CENTER SUPPORT RIB AT AFT END OF CUT OUT IS CRACKED, DISCOVERED AT C-CHECK. REPLACED LEFT WINDOW CENTER SUPPORT RIB PER EMB SRM 51-40-02.SDR 07FDEA02924Door Frame · crackedLT AFT SERVICE DOOR FWD UPPER CAM ROLLER FRAME HAS A CRACK. REMOVED AND REPLACED FWD FRAME IAW SRM 51-30-2.SDR 07FDEA02921Beam · crackedNR 1 LWR CARGO DOOR, LWR BEAM ANGLE, 3RD FROM AFT EDGE REMOVED, LOCATED AND DRILLED, AND INSTALLED LOWER BEAM ANGLE REF SRM 51-30-2 PG 1. RESTORED LEVELING COMPOUND REF OM MM 52-36-21,G. 406A. THIS IS CLASSIFIED AS A MAJOR REPAIR.SDR 07FDEA02920Beam · corrodedCORROSION ON BULK CARGO DOOR SILL BEAM REPAIR PERFORMED BY REPLACEMENT OF PART IAW SRM 51-72-10.SDR 07FDEA02919Beam · corrodedSEVERAL CORROSION SPOTS ON AFT CARGO DOOR SILL BEAM, OUT OF LIMIT IAW SRM 53-10-00. REPAIR PERFORMED BY REPLACEMENT OF PART IAW SRM 51-72-10, SRM 53-17-18 FIG 207 AND DRAWING R539-70133-000.SDR 07FDEA02918Crossbeam · corrodedFOUND CORROSION ON CROSSBEAM C 61 RT. REPAIR PERFORMED BY REPLACEMENT OF PART IAW SRM 51-72-10.SDR 07FDEA02877Door Frame · corrodedFOUND MAIN CARGO LOWER DOOR JAMB HAS CORROSION ON LOWER BEAM AT STA 750. 09-04-07 REMOVED AND REPLACED MAIN CARGO DOOR JAMB LOWER DOOR JAMB LOWER BEAM IN REF TO DC/MD10 SRM 51-33-01 VOL II PAGE 1, AND DAC DRAWING ACA7224 REV.G. MAJOR REPAIR.SDR IXXA07SMN210SBeam · dentedDURING ROUTINE C CHECK INSPECTION, ACCESS CMPT CORROSION ON BEAM AT STA 50.000 AND RBL 35".SDR DLM88071063Door Frame · corrodedTHE NR 2 CARGO DOOR OPENING LOWER THRESHOLD HAD CORROSION REVOAL IN SEVERAL LOCATIONS. LOCAL BLENDING RESULTED IN THE AFT C/L DOOR STOP HOLE BREAKING OUT. REPAIR PER SRM 53-05 FIG 63 INSTALLED.SDR 07FDEA02838Crossbeam · misrepairedOLD SPLICE REPAIR ON TOP CAP BEAM C 63 NOT CONFORM TO SRM REPAIR RENEWED IAW SRM 53-10-15 FIG 207.SDR DHL2007750504Door Frame · corrodedC2 DOOR LWR AFT FRAME CORRODED. REMOVED DOOR AFT CORNER AND DISPLACED WEB TO GAIN ACCESS IAW B727 SRM 51-30-2. CUT-OUT DAMAGED SECTION OF FRAME DIM 13 1/2" BY 6" IAW B727 51-10-1 AND 51-40-3 FIG 1. FABRICATED NEW FRAME SECTION FROM 7075-T6 .063" PO NR 90053SDR A6WA200740455Support Beam · crackedFOUND CARGO DOOR TRACK SUPPORT BEAM ANGLE AT FS 621 IS CRACKED AT BOTTOM ANGLE. MAINTENANCE REPLACED ANGLE IAW CRJ 200 SRM 51-42-21. (M)SDR A6WA20074055Support Beam · crackedFOUND CARGO DOOR TRACK SUPPORT BEAM ANGLE AT FS 621 IS CRACKED AT BOTTOM ANGLE. (M)SDR DHL2007741556Beam · corrodedNOSE SECTION INTERIOR, HORIZ WALKWAY BEAM RT SIDE MID CHORD CORRODED AT FWD END, BS 300. CORROSION REMOVAL EXCEEDS ALLOWABLE LIMITS. GAINED ACCESS AS REQUIRED. REMOVED RT MID CHORD, LOCATED, DRILLED, TREATED, PRIMED, AND INSTALLED NEW MID CHORD, P/N 65-1986SDR DLM90071073Door Frame · corrodedMID PIT DOOR JAMB BEAM HAS CORROSION FROM FS 685 TO 757. REPAIRED MID PIT DOOR JAMB BEAM IAW MD80 SRM 53-05D.SDR SWIA200718596Rib · damagedSECOND RIB JUST AFT OF RADOME IS DAMAGED. REPLACED SECOND RIB AFT OF RADOME IAW CRJ SRM 51-42-06.SDR DL757081686Structure · dentedMAJOR REPAIR ER/A 463313-14. THREE DENTS NEAR A/C NOSE REPAIRED.SDR M7K2007F00001Support Fitting · damagedDURING ROUTINE POSTFLIGHT INSPECTION THE CRACK WAS FOUND VISUALLY ON THE RT LOWER SUPPORT FITTING POSITION ON THE PARTS TRAILING EDGE FACE AND FOUND TO EXTEND ALMOST 2 INCHES OR ALMOST HALF WAY ACROSS THE PART. THIS IS A COMMON FAILURE FOR THIS PART. BELIEVESDR 2007UALA03032Door Frame · corrodedFWD CARGO PIT, FOUND CORROSION ON ANGLE FRAME INSIDE NEXT TO ROLLOUT STOP 3RD FROM MOST FORWARD POSITION AT STA 575. 08-31-07 REMOVED CORROSION VERIFIED MATERIAL LOSS WITHIN LIMIT. OK FOR SERVICE.SDR QXEA200701298Threshold · corrodedC5 PDX - MAIN CABIN DOOR THRESHOLD IS CORRODED ON UPPER SURFACE AT STATION X222.7 - X253.4. REPAIRED IAW SRM 51-40-11, 51-40-00.SDR P5CA0701529Windshield · crackedCAPT'S L1 WINDSHIELD CRACKED ON OUTER PANE ORIG IN PVG. REMOVED AND REPLACED WINDSHIELD BOR PART FROM KOREAN AIR PER AMM REF 56-11-01-404-016.SDR 2007UALA03009Door Frame · crackedFWD CARGO DOOR CUTOUT FWD FRAME IS CRACKED AT LOWER BOTTOM STOP FITTING OUTBOARD LOWER CORNER. MAJOR REPAIR ACCOMPLISHED: REMOVED CARGO COMPARTMENT COMPONENTS TO ACCESS FRAME REPAIR, FABRICATED DOUBLERS, NDT, INSTALLED DOUBLERS, RIG DOOR, OPS CHECK DOOR SWITSDR 2007UALA03007Door Frame · crackedAFT CARGO DOOR CUTOUT AFT FRAME IS CRACKED AT LOWER BOTTOM STOP FITTING OUTBOARD LOWER CORNER AROUND BOTTOM FASTENER. MAJOR REPAIR ACCOMPLISHED: REPLACED AFT CARGO PIT AFT FRAME AROUND DOOR CUTOUT.SDR SWIA200718745Doubler · crackedFOUND AT C-CHECK, DOUBLER CRACKED AT FS 640 ON LEFT SIDE OF SUPPORT BEAM. COMPLIED WITH SB 601R-53-065.
SDR C2XA07SH044Door Frame · corrodedSHV - DURING C-CHECK MAINTENANCE FOUND CARGO DOOR CUTOUT WITH VARIOUS AREAS OF CORROSION AT LOWER SECTION. MAINTENANCE INSTALLED NEW LOWER SECTION AT CARGO DOOR CUTOUT IAW EMB 145 SRM 51-40-02 & CPM 51-21-07. AIRCRAFT WAS APPROVED TO RETURN TO SERVICE.SDR 2007UALA02996Unknown · vibrationFLIGHT DIVERTED DUE TO VIBRATION IN THE AFT GALLEY FLOOR. CREW REPORTS NO WATER PRESS IN ALL GALLEY AND LAVS. ALSO REPORT VIBRATION IN AFT GALLEY FLOOR AREA , CHECKED EXTERIOR SERVICE PANEL DOOR FOR SECURITY AND VERIFIED THAT SERVICE HANDLE WAS FULLY CLOSSDR DHL2007804511Structure · misrepairedPERFORMED DETAILED VISUAL INSPECTION AND FOUND PREVIOUS REPAIR NOT IN ACCORDANCE WITH SRM. PERFORMED MAJOR REPAIR IAW SRM 53-2-1 FIG 7 SHEET 1, 3. REMOVED NON STANDARD REPAIR IAW SRM 51-1-21, SRM 51-1-20D. CUT OUT DAMAGED SECTION AND FABRICATED REPAIR DOUBLSDR DHL2007804510Structure · misrepairedPERFORMED DETAILED VISUAL INSPECTION AND FOUND PREVIOUS REPAIR NOT IN ACCORDANCE WITH SRM. PERFORMED MAJOR REPAIR IAW SRM 53-2-1 FIG 7 SHEET 1, 5. REMOVED EXISTING NON STANDARD REPAIR IAW SRM 51-1-21, SRM 51-1-20D. CUT OUT DAMAGED SECTION AND FABRICATED REPSDR DHL2007804507Structure · misrepairedPERFORMED DETAILED VISUAL INSPECTION AND FOUND PREVIOUS REPAIR NOT IN ACCORDANCE WITH SRM. PERFORMED MAJOR REPAIR IAW SRM 53-2-1 FIG 7 SHEET 1-5. REMOVED EXISTING NON-STANDARD REPAIR IAW SRM 51-1-21, SRM 51-1-20D. CUT OUT DAMAGED SECTION AND FABRICATED REPA
Back to JASC 5310