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 UPS05845774Finger Doubler · crackedINSPECTION TYPE:C2 FINGER DOUBLER CRACKED AT STA 920-940 LBL 60. REMOVED FINGER DOUBLER AT STA 920-940 LBL 60 IAW SRM 51-1-20D AND 51-3-0. FABRICATED AND INSTALLED FINGER DOUBLER AT STA 920-940 LBL 60 IAW SRM 53-07-03 FIG 004 AND SRM 51-1-21 SRM 51-1-20D.SDR UPS05845635Door Frame · crackedA-PIT DOOR JAMB FWD LWR CORNER O/B OF L33R STA 280 ANGLE IS CRACKED APPROX 1". REMOVED AND REPLACED DOOR FRAME JAMB FITTING IAW SRM 51-1-20D AND SRM 51-1-8.SDR 724000016Structure · crackedCRACK IN LOWER CHORD.SDR 05FDEA03195Repair · unknownMID CABIN- CENTER AUX TANK UPPER SURFACE AT STA 1199 TO 1219 Z=-31 FOUND EXISTING PATCH REPAIR. CENTER AUX TANK UPPER SURFACE AT STA 1199 TO 1219 Z=-31 EXISTING PATCH. REPAIR EVALUATED AND CARRIED OUT AS PER EA NR 1-5720-93203 TITLE: WINGS, PLATES AND SKINS,SDR SWAA053043Crease Beam · corrodedDURING SCHEDULED D CHECK, FOUND RT CREASE BEAM WEB CORRODED AT BS 300, WL 208. REPAIRED CREASE BEAM WEB PER SRM.SDR SWAA053030Crease Beam · corrodedDURING SCHEDULED D CHECK, FOUND LT CREASE BEAM WEB CORRODED BETWEEN BS 787 TO BS 807, WL 208. REPAIRED CREASE BEAM PER SRM.SDR 05FDEA03197Structure · corrodedHORIZ STAB RT BARREL NUT BORE NR 14 FOUND WITH CORROSION. REMOVED AND NEW FITTING INSTALLED IAW SRM 51-32-01 VOL.II, SRM 51-38-01 VOL.II, SRM 51-33-01 VOL.II AND E1-5510-7-5000 D1 PT1. MINOR REPAIR I.A.W FEDEX GMM 6-2-100.SDR 05FDEA03196Structure · crackedLOWER FUSELAGE, AIRCON COMP 1 AT STA 535 TO 547 LONG 32-33 FOUND EDGE CRACK. REMOVED AND REPLACED AS PER SRM 51-31-01 VOL.II. MAJOR REPAIR PER GMM 6-2-100.SDR USAA051181Beam · corrodedFOUND CORROSION TASK JA-260-53500; LEVEL 1; AFT SVD DOOR SILL BEAM AT FS 66. REMOVED AND REPLACED BEAM PER SRM 51-42-00, DEFECT SIZE: 4" BY 6".SDR UPS05845776Shear Web · corrodedINSPECTION TYPE:C2 HEAVY CORROSION ON RT W/W FWD BULKHEAD STA 857, RBL 26. CUT OUT CORROSION IN SHEAR WEB AT STA 857 RBL 26 AND INSTALLED REPAIR PARTS IAW UPS ENG FILE DC8-53-20517 SAA SK 866-832582, BOEING MESSAGE 1-137210970-2, AND FAA FORM 8100-9.SDR UPS05845603Finger Doubler · corrodedINSPECTION TYPE:C2 STA 880 RBL 65 SUBFLOOR FINGER DOUBLER HAS HEAVY CORROSION. REMOVED FINGER DOUBLER AT STA 880 RBL 65 IAW SRM 51-1-21, AND 51-3-0, FABRICATED AND INSTALLED FINGER DOUBLER AT FS 880 RBL 65 IAW SRM 53-7-3 FIG4, 51-9-0 FIG 68A, AND SRM 51-1-21.SDR AT0700040Door Frame · corrodedFWD CARGO DOOR LOWER CUTOUT WELL WITH CORROSION. INSTALLED REPAIR AT FWD CARGO LOWER DOOR JAMB IAW DC9/MD80 SRM 531-05 AND RES 05-123 DATED 09/30/05.SDR SIMA200527702Beam · corrodedTHE CENTER BEAM AT FRAME 24 WAS FOUND CORRODED. PERFORMED A CUT OUT TO REMOVE THE CORROSION. FABRICATED A FILLER, DOUBLER AND SHIMS. REPAIR DONE IAW EMB REPAIR STATEMENT IC 2005-145/5255 DATED SEPT 21, 2005 AND EMB 145 SRM, SRM EMB 145/1142 REV 30, CHAPTER SDR COMA0570105Crossbeam · corrodedTHE TRANSVERSE BEAM AT FS 280 IS CORRODED FROM LBL 36 TO RBL 36. THE CORRODED TRANSVERSE BEAM WAS REMOVED. A NEW TRANSVERSE BEAM WILL BE INSTALLED IAW REO 670-53-11-047 REV C.SDR SWAA052961Crease Beam · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE CREASE BEAM WEB CRACKED AT BS 578.5, RBL 66. REPAIRED CREASE BEAM WEB PER SRM.SDR SWAA052952Crease Beam · corrodedDURING SCHEDULED D CHECK, FOUND FUSELAGE CREASE BEAM WEB CORRODED AT BS 988, RBL 48. REPAIRED CREASE BEAM WEB PER SRM.SDR USAA051151Skate Angle · wornRIGHT SIDE BS 1016 L/E STATION 0.0. FABRICATED AND INSTALLED A NEW SKATE ANGLE IAW TYP REP 53-20-05A, DEFECT SIZE: .5" X 1.3".SDR 05FDEA03112Frame · dentedUPPER CARGO RIGHT SIDEWALL, FRAME AT STA 1561 INNER CHORD FOUND DENT AT LONGERON 12R TO LONGERON 13R. CARRIED OUT REPAIR AS PER SRM 53-30-00 FIGURE 1 VOLUME I DUE TO CAT B REPAIR. REFER TO FEDEX EA 1-5330-90040.SDR CALA0500319Crossbeam · corrodedINSPECTION FOUND TOP OF CROSSBEAM CORRODED AT STA 344, LBL 17 TO RBL 7. REPAIRED IAW ECRA 5321-01294.SDR QXEA200501337Guide · damagedPDX - AFT PASSENGER DOOR SURROUND UPPER FWD ROLLER GUIDE IS NOTCHED IN THE INBOARD FACE OF THE LOWER CHANNEL. MAINTENANCE BLENDED DAMAGED AREA IAW EA 6-52-405 TO REMOVE SHARP EDGES. MAPPED ROLLER GUIDE FOR ENGINEERING. HFEC INSP OF BLENDED AREA FOR CRACKS ISDR 2005UALA01026Crease Beam · corrodedAFT CABIN FLOOR STA 962 TO STA 1006 WL 208 RBL 54 RT CREASE BEAM CORRODED. REMOVED DAMAGE CREASE BEAM INNER CORD. MATCH DRILLED AND INSTALLED NEW CORD REF SRM 51-40-0 2.SDR IXXA05SMN194SCap · crackedDURING ROUTINE C CHECK INSPECTION, MID ACCY CMPT. CAP CRACKED 1, STA 680.000 BETWEEN L 27 AND L 28LPERFORMED MAJOR REPAIR IAW SRM 53-2-5 FIG 14, EO SEMAN NR 20051313 DATED 09-30-05. REMOVED FASTENERS IAW SRM 51-1-20D PG 1. STOP DRILLED ON CRACK END IAW SRMSDR ASOA05778Beam · crackedDURING A C-CHECK IN MCN, THE CENTER BOX BEAM WAS SUSPECTED OF BEING CRACKED UNDER THE CLIP. MAINTENANCE WILL REPAIR THE CENTER BOX BEAM IAW ASA EO 600-53-0072B. (M)SDR UPS05845584Structure · corrodedINSPECTION TYPE:SP, STA 70 LOWER AFT CHORD HAS EXFOLIATION CORROSION AT APPROX L28R-L33L. CUT OUT CORRODED CHORD, FABRICATED AND INSTALLED REPAIR PARTS IAW SRM 51-1-21, 51-1-20D, 53-2-5 FIG 8C.SDR 05FDEA03061Stringer · misrepairedIMPROPER STRINGER SPLICE AT STR 23R BETWEEN STA 680 TO 720. REMOVED, FABRICATED, ALODINED, PRIMED AND INSTALLED STRINGER REPAIR AT STA 680 TO 720 ON STRINGER 23R ALL IAW FX B727 SRM 53-10-3, 51-30-2 AND 51-10-2.SDR ASOA05847Door Frame · crackedDURING A C-CHECK IN HTO, THE FS 338 PASSENGER DOOR FRAME WAS FOUND TO BE CRACKED BEYOND LIMITS. MAINTENANCE REPAIRED THE FS 338 PASSENGER DOOR FRAME IAW BOMBARDIER REO 601R-52-11-402. (M)SDR SWAA052876Crease Beam · corrodedDURING SCHEDULED D-CHECK, FOUND FUSELAGE LT CREASE BEAM CORRODED AT BS 817. REPAIRED CREASE BEAM PER SRM.SDR 0509013Support · corrodedCONTROL CABIN WINDSHIELD WITH SUPPORT CORRODED.SDR ASAA0510302Doubler · dentedYXX - FOUND DOUBLER DAMAGED AT BS 360 BETWEEN STRINGER 27R TO 28L PLUS 14 INCHES. REPLACED DOUBLER PER B737-200 SRM 57-40-3 FIGURE 1. (M)SDR ASAA0540494Shear Web · crackedSHEAR WEB CRACKED AT BSTA 998, RBL 41, WL 208. REMOVED AND REPLACED SHEAR WEB AT BSTA 986.5 - 1016, RBL 29-41, WL 208 IAW SRM. (K)SDR 05FDEA03000Adapter · damagedMDCC CLAS ADAPTER AT FR 42 AND FR 44 BETWEEN S/T L4 AND L5 HAVE DAMAGE IN SCALLOP AREAS. REMOVED AND REPLACED 2 CROSSBEAMS IAW A300-600 SRM 51-72-10.SDR USAA051114Beam · corrodedFOUND CORROSION RT BEAM STA 66-68 INB OF RT DOOR SEAL AT ATTACH HOLES. REPLACED WITH IDENTICAL PART NUMBER PER SRM 51-42-0, DEFECT SIZE: 1" X 2".SDR USAA051122Door Frame · crackedFOUND CRACK FWD SVC DOOR, FWD FRAME AT UPPER DOOR STOP FTG LWR O/B CRNR, STA 296 S-8R-10. REMOVED DAMAGED FRAME AND INSTALLED FRAME PIN PER BOEING DWG 65-45807 AND 65C34778, SRM 51-10-02, 51-40-DEFECT SIZE: 1.25".SDR USAA051124Beam · corrodedFOUND CORROSION FR 16 AND BETWEEN FR 19 AND 20 CENTER BEAM. INSTALLED DOUBLERS PER SRM 53-00-14 FIG 206, DEFECT SIZE: 2" X 2" AND 1" X 1".SDR ASAA0540480Door Frame · corrodedOKC - FOUND INNER CHORD AT BS 259-360 AT RBL 55 IS CORRODED AT R-1 DOOR AREA. REMOVED CORRODED CHORD, REPLACED WITH NEW CHORD IAW 737-400 SRM 51-40-02. (M)SDR SWAA052837Post · crackedDURING SCHEDULED 1/2D CHECK, FOUND L1 COCKPIT WINDOW POST CRACKED AT UPPER OUTBOARD CORNER. REPAIRED WINDOW POST PER SRM.SDR QXEA200501297Door Frame · damagedYYC - AFT BAGGAGE BAY DOOR TRACKS STRUCTURE HAS SCRATCHES ON FORWARD AND AFT FRAMES. REPAIRED IAW EA R-53-297 AND REO 670-53-61-199. TOUCHED UP REWORK AREA.SDR CA050921001Door Frame · cracked(CAN) DURING A DAILY INSPECTION 2 CRACKS WERE DETECTED ON EACH SIDE OF THE UPPER ATTACHMENT FOR THE REAR DOOR. THE PART WAS REPLACED.SDR SWAA052824Crease Beam · corrodedDURING SCHEDULED D-CHECK, FOUND RT CREASE BEAM WEB CORRODED BETWEEN BS 380 TO BS 400. REPAIRED CREASE BEAM WEB PER SRM.SDR SWAA052823Crease Beam · corrodedDURING SCHEDULED D-CHECK, FOUND RIGHT CREASE BEAM WEB CORRODED BETWEEN BS 460 TO BS 480. REPAIRED CREASE BEAM WEB PER SRM.SDR ASAA0540462Crease Beam · damagedOKC - FOUND STRINGER 17 CREASE BEAM HAS SHORT EDGE DISTANCE FROM PREVIOUS REPAIR. REMOVED DAMAGED SECTION OF CREASE BEAM AND INSTALLED NEW SECTION OF CREASE BEAM IAW B737-400 SRM 53-00-01 FIG 201 AND SRM 51-40-02. (M)SDR SWAA052796Crease Beam · corrodedDURING SCHEDULED D-CHECK, FOUND LT CREASE BEAM WEB CORRODED BETWEEN BS 727D TO BS 727E. REPAIRED CREASE BEAM WEB SECTION PER SRM.SDR DHL2005742520Window Frame · crackedPILOT'S NR 2 WINDOW AFT LOWER INTERNAL CORNER ANGLE CRACKED AND CORRODED. REMOVED FITTING P/N 69-367305, FABRICATED SHIMS IAW EA NR AA15-53-1 REV. IR, DRILLED UP FITTING IAW SRM 51-30-2. INSTALLED FITTING IAW SRM 51-30-2, HEAT CHECK IAW MM 56-12-11 STEP.SDR 05FDEA02890Door Frame · crackedL1 DOOR CUT-OUT UPPER HINGE CAVITY, FRAME IS CRACKED AROUND HOLE.SDR SWIA200515602Door Frame · crackedPAX DOOR, DOOR FRAME IS CRACKED ON UPPER END, FS 320.10, ITEM FOUND AT C-CHECK INSPECTION. INSTALLED FRAME IAW CRJ REO 601R-52-11-402 REV E.SDR 05FDEA02839Shear Tie · corrodedCORROSION FWD CARGO FLOOR SHEAR TIE BS 700, BL 0, WL 148. REMOVE AND REPLACE SHEAR TIE PER SRM 53-10-1SDR 05FDEA02824Seat Track · wornAFT CABIN, STA 1828 TO 1829 RBL 107 FOUND SEAT TRACK CROWN WORN. SNRM N1611: AFT CABIN STA 1771 TO STA 1831 RBL 107 CROWN WORN SEAT TRACK REPAIRED AS PER SRM 53-70-00 FIG.1 VOL.I. CLASSIFIED MAJOR REPAIR PER GMM 6-2-100.SDR 05FDEA02829Shear Tie · corrodedFWD CARGO CORROSION FLOOR SHEAR TIE STA 660 RBL 4 TO LBL 4 WL 148. REPAIRED PER SRM 53-10-4.SDR USAA051075Beam · corrodedFRAME 66 OUTBOARD LT DOOR SILL. REMOVED & REPLACED PER SRM 51-72-11, 53-41-14, DEFECT SIZE: 1 X 2 INCH.SDR USAA051074Beam · corrodedCORROSION BETWEEN FR 66 & 69 Y1292. REMOVED & REPLACED BEAMS PER SRM 57-72-11, DEFECT SIZE: 2 X 2, 1.5 X 2, 3 X 2 INCH.
Back to JASC 5310