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 FDEA200911184015Frame · dentedMAIN DECK UPPER SIDEWALL AT LT STA 1661, 15L FOUND DENTED. REPAIRED IAW SRM 53-00-07 FIG. 201, REPAIR 2 REV 42. REPETITIVE INSP REQUIRED, INITIAL AT 14,500 CYCLES AND REPETITIVE INSP AT 9,500 CYCLES TO BE CARRIED OUT IAW SRM 53-00-07 FIG. 201 REPAIR 2, REVSDR QXEA2009111900968Structure · corrodedSEVERAL AREA OF CORROSION FOUND UNDER SERVICE DOOR SCUFF PLATE, FOUND ONE DENT AT FS 333.00 UNDER SCUFF PLATE. BLENDED CORROSION IAW SRM 51-21-06-001-001-A01. MAX MATERIAL REMOVED .008". SIZE OF BLENDS MEASURE .750 " WIDE, 1.000 LONG AND .800 WIDE BY 1.500 LSDR QXEA2009111800967Unknown · corrodedCORROSION FOUND FS 280.00 - 295.00 STR 23R. REMOVED CORROSION, WORK DONE IAW SRM 51-21-06-001-001-A01, 51-42-06-001-001-A01 PG 9 AND 53-21-03-002A-1 PG 104. REQUESTED REO REPAIR FROM MFG. PERFORMED ECI ON STR 23R FS 280-295.00, NO CRACKS OR CORROSION FOUND SDR FDEA200911153974Beam · chafedLT MLG STRUT DOOR AFT JAMB FOUND CHAFED. LT MLG STRUT DOOR AFT JAMB CHAFED REPAIR CARRIED OUT IAW EA 1-5710-135652, REPAIR CLASSIFIED AS MAJOR IAW GMM 6-2-100 REV 108.SDR QXEA2009111700966Unknown · corrodedCORROSION FOUND FS 280.00 THRU 295.00 STR 19L. REMOVED CORROSION IAW SRM 51-21-06-001-001-A01. BLENDED TO .009 DEEP BY .024 WIDE BY 2.0 LONG, NO ALLOWABLE DAMAGE IAW SRM 51-21-03-001-001-A01. PERFORMED ECI ON STR 19L FS 280 TO 295, NO CRACKS OR CORROSION FOSDR QXEA2009111300939Structure · corrodedDURING INSP, FOUND CORROSION ON FS 333.00 BETWEEN STR 27 AND STR 26L. REMOVED FASTENERS FOR ACCESS IAW SRM 51-42-06-001-001-A01 PG 9. BLENDED DAMAGED IAW SRM 51-21-06-001-001-A01. PERFORMED ECI IAW ECI NDTM 51-20-006. TREATED, PRIMED, INSTALLED RIVETS AS REQSDR QXEA2009111300935Structure · corrodedCORROSION FOUND AT FS 517.00 STR 25L FWD CARGO. REMOVED 3 RIVETS IAW SRM 51-42-06. BLENDED IAW SRM 51-21-06, FOUND WITHIN LIMITS IAW SRM 53-31-06-003-A01. TREATED IAW SRM 51-21-11. PRIMED IAW SRM 51-25-06-001-001-A01. PAINTED AREA AND RIVETS IAW SRM 51-25-SDR FDEA200911113926Crease Beam · corrodedRT CREASE BEAM STA 1240-1280 CORRODED. REMOVED CORROSION IAW SRM 53-60-13 ORIGINAL THICKNESS - .070", AFTER REWORK - .060", .010" MATERIAL REMOVED. FOUND TO BE OUT OF LIMITS IAW SRM 53-60-13, DETAIL 1. REMOVED CREASE BEAM IAW SRM 51-40-02. FABRICATED NEW CRSDR SWAA097217Crease Beam · corrodedDURING SCHEDULED SPV CHECK, FOUND LT CREASE BEAM CORRODED AT BS 500B+7. REPAIRED CREASE BEAM PER SRM.SDR WX0A070477Structure · corrodedDURING BOW 1C/3C/S2/S4, FOUND CORROSION ON SUBFLOOR AT STA 196-198 RBL 4 TO LBL 4. REPAIRED PER ESO 80559, AARD 53-20-00-16. ADDRESSED AS REQUIRED.SDR WX0A070475Beam · corrodedDURING BOW 1C/3C/S2/S4, FOUND MID CARGO DOOR BEAM CORRODED STA 636-693. ADDRESSED AS REQUIRED.SDR WX0A070473ABeam · corrodedDURING BOW 1C/3C/S2/S4, FOUND MID CARGO DOOR BEAM CORRODED STA 636-693. ADDRESSED AS REQUIRED.SDR WX0A2009119001Beam · corrodedDURING BOW 1C/3C/S2/S4, FOUND MID CARGO DOOR BEAM CORRODED STA 636-693. ADDRESSED AS REQUIRED.SDR ASAA0946957Door Frame · crackedFORWARD SERVICE DOOR (R1) AFT FRAME CRACKED. INSTALLED NEW AFT FRAME PER SRM 51-40-02 AND DWG 65 45871.SDR C2XA09SH407Door Frame · corrodedSHV - DURING C-CHECK, SERVICE DOOR CUTOUT HAS CORROSION UNDER AFT LWR TEFLON GUIDE. REPAIRED SERVICE DOOR CUTOUT IAW ETD2009-145/09007A. AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR ZZDA2009400Door Frame · corrodedAFT CARGO DOOR JAMB PAN, CORROSION. ACCOMPLISHED JAMB PAN SPLICE REPAIR PER B717 SRM 53-20-15 REPAIR 7 FIG 201.SDR ZZDA2009401Door Frame · corrodedFWD CARGO DOOR JAMB PAN, CORROSION. ACCOMPLISHED JAMB PAN BLENDING WITHIN LIMITS PER B717 SRM 51-10-04 AND B717 SRM 53-00-00 FIG 103.SDR DLM88091733Door Frame · corrodedDURING HMV EXFOLIATION CORROSION WAS FOUND ON LWR MID CARGO COMPARTMENT DOORJAMB STA Y=652. LOWER DOORJAMB WAS REPAIRED IAW SRM 53-05 FIG 123.SDR FDEA200911063880Crease Beam · corrodedMAIN CABIN STA 740-760 RT SIDE INBD CREASE BEAM CHORD HAS CORROSION. REMOVED CORROSION ON CREASE BEAM IAW SRM 53-30-13 ORIG THICKNESS .070, AFTER REWORK .006 WITHIN LIMITS , REMOVED CORROSION ON WEB FOUND OUT OF LIMITS IAW SRM 53-30-15 FIG. 101 DET 4, ORIG. MSDR TSAA0953010Door Frame · crackedDURING SCHEDULED INSP A 2 INCH CRACK WAS DISCOVERED AT BS 492.4, S-24R FWD CARGO DOOR AFT FRAME LWR DOOR STOP WEB IAW (AD 2005-07-19) INSP AFT AND FWD CARGO DOOR STRUCTURE CUT-OUTS. R & R FWD CARGO DOOR AFT FRAME ASSY. IAW ECO 3512 R3. ACFT RETURNED TO SERVISDR SWIA200923110Door Frame · crackedAFT CARGO DOOR SILL FRAMES CRACKED. (C-CHECK) REPAIRED PER REO.SDR WX0A070464Beam · corrodedDURING BOW 1C/2C/S1/S2/S4, FOUND AFT CARGO DOOR BEAM LOWER LEG CORRODED STA 1155 TO 1211. ADDRESSED AS REQUIRED.SDR ZZDA2009334Door Frame · corrodedFWD CARGO DOOR JAMB PAN, STA 372 TO 425, CORROSION. ACCOMPLISHED CARGO DOOR JAMB PAN SPLICE REPAIR PER B717 SRM 53-20-15 REPAIR 6 FIG 201. SEE NR 3634 AND 3728.SDR SWAA097078Crease Beam · corrodedDURING SCHEDULED 12Y CHECK, FOUND RT CREASE BEAM CORRODED AT BS 967 TO BS 987. REPAIRED CREASE BEAM PER SRM.SDR SWAA097034Crease Beam · crackedDURING SCHEDULED SPV CHECK, FOUND CREASE BEAM CRACKED AT BS 312, LBL 60. REPAIRED BEAM PER SRM.SDR SWAA097030Door Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND SUB FRAME CRACKED AT LOWER FWD CORNER OF L2 DOOR CUTOUT. REPAIRED FRAME PER SRM.SDR SWAA097020Crease Beam · crackedDURING SCHEDULED 20Y CHECK, FOUND CREASE BEAM OUTER CHORD CRACKED BETWEEN BS 431 TO BS 435. REMOVED AND REPLACED BEAM PER AAR EA.SDR SWAA096977Crease Beam · corrodedDURING SCHEDULED 12Y CHECK, FOUND CREASE BEAM CORRODED BETWEEN BS 950 TO BS 997, BETWEEN RBL 55 TO RBL 46. REMOVED AND REPLACED BEAM PER SRM.SDR ZZDA2009387Door Frame · corrodedAFT CARGO DOOR JAMB PAN, STA 954 TO 994, CORROSION. ACCOMPLISHED JAMB PAN SPLICE REPAIR PER B717 SRM 53-20-15 REPAIR 7 FIG 201. SEE NR 3236 AND 1133.SDR FDEA200911033796Fitting · corrodedBETWEEN STA 1862 AND 1885, 8" BELOW STR 8L FORGED LONGERON FITTING CORRODED AROUND FASTENERS AND RUNNING INTO SKIN AT STA 1883. TEE CLIP AT STR 8L FOUND CORRODED. TEE CLIP REMOVED AND REPLACED IAW SRM 51-40-02, REV 98. REPAIR IS CLASSIFIED AS MINOR IAW GMSDR SWAA096936Crease Beam · corrodedDURING SCHEDULED 12Y CHECK, FOUND CREASE BEAM CHORD CORRODED BETWEEN BS 956 TO BS 986.5, BETWEEN LBL 56 TO LBL 48. REMOVED AND REPLACED BEAM PER SRM.SDR SWAA096917Door Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FWD CARGO DOOR CUTOUT FRAME CRACKED. REMOVED AND REPLACED FRAME PER SRM.SDR FDEA200911023768Structure · corrodedINBD CHORD ON WEB BETWEEN STA 1885 AND STA 1896 CORRODED STR S-5L AREA. REMOVED AND REPLACED IN ACCORDANCE WITH SRM 51-40-02 REV. 98. NEW CHORD FABRICATED AS PER DRAWING 148N8501 SHEET 1 REV. E AND PART LIST FEV. M. PART MARKED AS PER GMM 7-0-1001. REPAIR ISSDR FDEA200911023790Crease Beam · corrodedMAIN DECK FLOOR, BS 664-753, LBL 64, IS CORRODED IN SEVERAL AREAS. REMOVED CORROSION IAW SRM 51-10-02. BLENDED ORIGINAL THICKNESS, .080", AFTER REWORK, LOST .028" THICKNESS. FOUND TO BE OUT OF LIMITS IAW SRM 53-30-13. -REMOVED CREASE BEAM IAW SRM 51-40-02SDR SWIA200923573Door Frame · crackedAFT CARGO DOOR SILL FRAMES CRACKED. (C CHECK) REPAIRED PER REO.SDR QXEA2009110300907Buttstrap · corrodedDURING INSPECTION FOUND CORROSION ON BUTT STRAP AT FS 283 APPROX 1" OTBD OF STR 26RT. BLENDED OUT CORROSION IAW SRM 51-21-06. PERFORM LPI INSPECTION IAW NDTM 51-20-008 NO DEFECTS NOTED. TREATED, PRIMED AND PAINTED BLEND AREA IAW SRM 51-21-11, 51-25-06 AND 5SDR SWAA096897Door Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND AFT CARGO DOOR CUTOUT AFT FAME CRACKED AT BS 847, RBL 25. REPAIRED FRAME PER SRM.SDR FDEA200911013757Door Frame · corrodedFWD CARGO DOOR STA 680, S-25L TO S-26L FRAME CORRODED. CORRODED FRAME SPLICE AT STA 680, S-25L TO S-26L REMOVED AND REPLACED IAW SRM 51-40-02 REV. 98. FRAME SPLICE FABRICATED IAW DWG NR 143N1030 SHEET 1 REV. PART MARKED IAW GMM 7-0-1001. REPAIR IS CLASSIFISDR FDEA200911013756Frame · corrodedFWD CARGO DOOR STA 700, S-25R TO S-26R FRAME CORRODED. CORRODED FRAME SPLICE AT STA 700, S-25R TO S-26R REMOVED AND REPLACED IAW SRM 51-40-02 REV. 98. FRAME SPLICE FABRICATED IAW DWG NR 143N1030 SHEET 1 REV. PART MARKED IAW GMM 7-0-1001. REPAIR IS CLASSIFIESDR ZZDA2009383Door Frame · corrodedAFT CARGO DOOR JAMB PAN, STA 954 TO 994, CORROSION. ACCOMPLISHED JAMB PAN SPLICE REPAIR PER B717 SRM 53-20-15 REPAIR 7 FIG 201. SEE NR 3422 AND 3532.SDR ZZDA2009379Door Frame · corrodedAFT CARGO DOOR JAMB PAN, CORROSION. ACCOMPLISHED CARGO DOOR JAMB PAN SPLICE REPAIR PER B717 SRM 53-20-15 REPAIR 7 FIG 201. SEE NR 3618, 4185 AND 3656.SDR ASOA200901209Support Beam · crackedCARGO DOOR SUPPORT BEAM LWR AFT ANGLE IS CRACKED APPROX 1.5" IN LENGTH. REMOVED CARGO DOOR SUPPORT BEAM LWR AFT ANGLE, LOCATED AND INSTALLED NEW SERVICEABLE ANGLE IAW SRM 51-42-21.SDR SWAA096880Crease Beam · corrodedDURING SCHEDULED 12Y CHECK, FOUND CREASE BEAM CORRODED BETWEEN BS 312 TO BS 328, LBL 60. REPAIRED BEAM PER SRM.SDR DL757100302Crease Beam · corrodedSTR 17L CREASE BEAM WEB BETWEEN STA STA 1060 AND 1080 HAS CORROSION. REPAIRED CREASE BEAM WEB AT SAA SAT REFERENCE NON ROUTINE 144331.SDR USAA2009111793132Crease Beam · corrodedCLT - Q3 - MAJOR REPAIR - LEVEL 2 EXFOLIATION CORROSION ON LEFT CREASE BEAM WEB BETWEEN BS 1006 TO BS 1016, WL 217. REPLACED LEFT CREASE BEAM WEB BETWEEN BS 1006 TO BS 1016, WL 217 IAW BOEING DRAWING 65-52878.SDR DL757100335Door Frame · corrodedMAIN CABIN L2 DOOR CUTOUT FWD FRAME HAS HEAVY CORROSION AT STG 630 LBL 65 JUST FWD OF DOOR SILL/ INSTALLED NEW FRAM AND 2 FITTINGS AT SAA SAT REF NON ROUTINE 141220.SDR FDEA200910283701Stringer · crackedSTR 6L BETWEEN STA 1862 AND STA 1885 CORRODED. EVALUATE AND RECTIFY. STR 6L BETWEEN STA 1862 AND STA 1885, CORROSION ON STR FOUND OUT OF LIMITS IAW SRM 53-00-03 DETAIL II, FIG. 101 REV. 98, ORIGINAL MATERIAL THICKNESS IS 0.071" AND REMAINING MATERIAL IS 0.055SDR WX0A070451Beam · corrodedDURING BOW 1C/2C/S1/S2/S4, WO 94586 CORROSION WAS FOUND ON THE AFT CARGO DOOR BEAM THAT WAS OUT OF LIMITS STA 1155 TO 1211. ADDRESSED AS REQUIRED.SDR AALA20091027TUL02Tab · crackedFOUND CRACK AT LEFT UPPER AFT WINDOW PAN TAB AT STATION 1041. INSTALLED DOUBLER ANGLE PER AARD 53-10-00-25.SDR AALA20091027TUL01Tab · crackedFOUND CRACK AT LEFT UPPER AFT WINDOW PAN TAB AT STATION 1060. INSTALLED DOUBLER PER AARD 53-10-00-25.
Back to JASC 5310