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 07FDEA04909Door Frame · corrodedMAIN CARGO DOOR LOWER JAMB AT NR 7 SPOOL LOCATION, ALL FOUR HOLES (A, B, C, D) HAD EVIDENCE OF CORROSION. REAMED HOLES A,B,D TO .517 AND HOLE D TO .484 TO REMOVE CORROSION IN REF TO MD/DC10-10 SRM 53-50-01 FIG 17 VOL I. ACCOMPLISHED BHEC IN REF TO NTSPM 06-SDR 07FDEA04908Door Frame · corrodedMAIN CARGO DOOR LOWER JAMB AT NR 6 SPOOL LOCATION, ALL 4 HOLES (A, B, C, D) HAD EVIDENCE OF CORROSION. REAMED HOLES A,B,C TO 0517 AND HOLE D TO .484 TO REMOVE CORROSION IN REF TO MD/DC10-10 SRM 53-50-00 FIG 17 VOL I. ACCOMPLISHED BHEC IN REF TO NTSPM 06-10-SDR 07FDEA04907Door Frame · corrodedMAIN CARGO DOOR LOWER JAMB AT NR 5 SPOOL LOCATION, ALL 4 HOLES (A, B, C, D) HAD EVIDENCE OF CORROSION. REAMED HOLES A,B,D TO .517 AND HOLE D TO .484 TO REMOVE CORROSION IN REF TO MD/DC10-10 SRM 53-50-01 FIG 17 VOL I. ACCOMPLISHED BHEC IN REF TO NTSPM 06-10-SDR 07FDEA04906Door Frame · corrodedMAIN CARGO DOOR LOWER JAMB AT NR 4 SPOOL LOCATION, ALL 4 HOLES (A, B, C, D) HAD EVIDENCE OF CORROSION. REAMED HOLES A,B,C TO .460 TO REMOVE CORROSION. WITHIN LIMITS OF MD/DC10-10 SRM 53- 50-00 FIG 17 VOL I. HOLE D REAMED TO REMOVE CORROSION AND INSTALLED BSDR 07FDEA04905Door Frame · corrodedMAIN CARGO DOOR LOWER JAMB AT NR 2 SPOOL LOCATION, ALL 4 HOLES (A, B, C, D) HAD EVIDENCE OF CORROSION. REAMED HOLES A,B,C,D TO REMOVE CORROSION AND INSTALLED REPAIR BUSHINGS. FOUND REPAIR BUSHINGS WOULD NOT MEET THE LIMITS STATED IN MD/DC10-10 SRM 53-50-00 SDR 07FDEA04904Door Frame · corrodedMAIN CARGO DOOR LOWER JAMB AT NR 1 SPOOL LOCATION, ALL 4 HOLES (A, B, C, D) HAD EVIDENCE OF CORROSION. REAMED HOLES A,B,C,D TO REMOVE COROSION AND INSTALLED REPAIR BUSHINGS. FOUND REPAIR BUSHINGS WOULD NOT MEET THE LIMITS STATED IN MD/DC10-10 SRM 53-50-00 FSDR 07FDEA04903Beam · corrodedMAIN CARGO DOOR JAMB TOP SURFACE UNDER CENTERING GUIDE HAS SURFACE CORROSION, STA 660. REMOVED AND REPLACED BEAMS ACA7225-1 AND ACA7226-1 IN REF TO DAC DRAWING ACA7224 REV G AND DC/MD10-10 SRM 51-31-01 VOL II PG 1, MD/DC10-10 SRM 51-33-01 VOL II PG 1 AND DC/SDR TRAX200701772Structure · corrodedPAX DOOR CUTOUT FRAME FS 349.00 HAS CORROSION. REMOVED MINOR SURFACE CORROSION FROM FWD BRACKET. IAW CRJ SRM 51-21-06. ASSEMBLED BRACKETS TO ANGLES REPLACING CORRODED PART.
SDR DHL2007742014Tear Strap · corrodedAFT CARGO COMPARTMENT TEAR STRAP AT BS 1148 AT STRINGER 26R TO 25R IS EXFOLIATED. CUT OUT DAMAGED TEAR STRAP SECTION, FABRICATED TEAR STRAP REPAIR IAW B-727 SRM 53-30-4 FIGURE 9 AND 51-10-1. TREATED AND PRIMED PART IAW B-727 SRM 51-10-2 AND INSTALLED REPAIR SDR EIA2007224Door Frame · misrepairedMAIN ENTRY DOOR NR 5L FRAME WEB BS 2231 STR 16L-17L IMPROPER EXISTING REPAIR. REMOVED REPAIR DOUBLER, FABBED AND INSTALLED NEW REPAIR PER B747 SRM 53-10-04 FIGURE 91.SDR 2007UALA04776Crease Beam · corrodedCABIN FLOOR CREASE BEAM HAS SPOTS OF CORROSION AT BS 294-360, RBL 49". REMOVED AND REPLACED CREASE BEAM.SDR 07FDEA04882Torque Box · crackedR-3 DOOR FWD JAMB TORQUE BOX WEB CRACKED AT FLOOR LINE REPAIRED WEB IAW SRM 53-50-00 FIG 19 SHEET 1.SDR 07FDEA04881Web · crackedR-3 DOOR AFT JAMB TORQUE BOX WEB CRACKED AT FLOOR LINE REPAIRED WEB IAW SRM 53-50-00 FIG 19 SHEET 2.SDR 07FDEA04846Door Frame · deformedDURING MODIFICATION MD10 TO ACF (ADVANCED COMMON FLIGHT DECK), VANE AIR CONDITION COMPT LT SIDE BAY JAMB STRUCTURE FRAME AT STA 486 DEFORMED REPAIRED FOR SRM 53-30-00 FIG 5 VOL I.SDR CALA0700693Door Frame · corrodedINSPECTION FOUND L-1 DOOR CHORD CORRODED AT STA 291.5-360, LBL 43. THE CHORD WAS REMOVED AND REPLACED IAW SRM 51-40-02 AND GMM 10-900-02.SDR SWAA075739Door Frame · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FWD CARGO DOOR CUTOUT, FWD FRAME CRACKED AT BS 440, LOWER STOP FITTING. REMOVED AND REPLACED FWD CARGO DOOR FWD FRAME PER SWA ACO.SDR SWAA075740Door Frame · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FWD CARGO DOOR CUTOUT, AFT FRAME CRACKED AT BS 492, LOWER STOP FITTING. REMOVED AND REPLACED FWD CARGO DOOR AFT FRAME PER SWA ACO.SDR 2007UALA04704Door Frame · crackedFWD CARGO DOOR CUTOUT, FWD FRAME CRACKED AT INNER CHORD RADIUS ABOVE LWR DOOR STOP FITTING, AT BS 440 STR 24R. REMOVED DAMAGE. INSTALLED ANGLE DOUBLER REPAIR.SDR 2007UALA04700Crease Beam · corrodedRIGHT CABIN CREASE BEAM WEB ADJACENT TO STRINGER 17L IS CORRODED ON UPPER SURFACE BETWEEN BS 727D & S 727E WL 208. BLENDED OUT CORROSION. FABRICATED AND INSTALLED A TYPICAL WEB REPAIR ON UPPER SURFACE.
SDR 2007UALA04699Crease Beam · corrodedLEFT CABIN CREASE BEAM WEB ADJACENT TO STRINGER 17L IS CORRODED ON UPPER SURFACE BETWEEN BS 500B & S 500C WL 208. BLENDED OUT CORROSION. FABRICATED AND INSTALLED A TYPICAL WEB REPAIR ON UPPER SURFACE.SDR USAA920071358Door Frame · crackedCLT - MAJOR REPAIR - C18 CHECK, AFT CARGO COMPARTMENT DOOR CUTOUT AFT FRAME CRACKED, BS 847, S20R. REPLACED AFT CARGO COMPARTMENT DOOR CUTOUT AFT FRAME, BS 847, S20R IAW B737 SRM 51-40-02.SDR 2007UALA04688Door Frame · damagedFWD CARGO DOOR, AFT FRAME LWR OF CUTOUT, HAS TEMP REPAIR PER EVA. SUPPLEMENTAL DATA UPDATE:REPLACED FWD CARGO DOOR AFT FRAME.SDR ZZDA2007301Structure · dentedDENT AT AFT OF L1 DOOR STA 219 - 229 L16L. CUT OUT DAMAGED AREA IAW B717 SRM 53-00-01, INSPECTED CUTOUT WITH HFEC IAW NDTSPM PART 6 10-01-001. NO CRACKS NOTED, INSTALLED NEW SKIN SECTION IAW B717 SRM 53-00-01.SDR SWAA075685Window Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND L1 WINDOW UPPER FRAME CRACKED AT OUTBOARD END. REPAIRED FRAME PER SRM.SDR F3LA200700355Fastener · corrodedDURING C4/S1 CHECK, INSPECTION REPORTED SCREWS RUSTY AROUND THE OUTSIDE OF THE FIRST OFFICER'S RT AFT FIXED COCKPIT WINDOW. REMOVED FIXED WINDOW IAW AMM 56-11-12-000-001. INSTALLED FIXED WINDOW IAW AMM 56-11-12-000-002. PERFORMED OPS TEST OF WINDOW HEAT SYSSDR ABXA070376Angle · crackedDURING COCKPIT WINDSHIELD FRAME MOD, FOUND RIGHT ANGLE CRACKED AT AFT END. REPLACED ANGLE IAW DC9 SRM 51-30-2.SDR ABXA070377Window Frame · crackedDURING COCKPIT WINDSHIELD FRAME MOD, FOUND LOWER SILL CENTER FRAME CRACKED AT LEFT AND RIGHT ENDS. REPAIRED FRAME IAW DC9 SRM 53-03, FIGURE 34.SDR ABXA070375Window Frame · crackedDURING COCKPIT WINDSHIELD FRAME MOD, FOUND LOWER SILL RIGHT SIDE FRAME CRACKED. FRAME REPAIRED IAW DC9 SRM 53-03, FIGURE 34.SDR ABXA070374Window Frame · crackedDURING COCKPIT WINDSHIELD FRAME MOD, FOUND COCKPIT WINDOW LOWER SILL LEFT SIDE FRAME CRACKED AT UPPER INBOARD END. FRAME REPAIRED IAW DC9 SRM 53-03, FIGURE 34.SDR 07FDEA04765Frame · corrodedBODY FAIRING FRAME HAS CORROSION LOCATED FORWARD END OF PANEL 3455R. REMOVED CORROSION, FOUND TO BE OUT OF LIMITS, ORIGINAL .050'. REMOVED .025", REMAINING .025", IAW SRM 53-10-1. TOOL AAR23841 CAL DATE .SDR UIEA200700470Support Beam · crackedMAIN DECK CARGO SIDE DOOR AREA, SUPPORT BEAM BETWEEN STA 1820-1840 AND 1840-1860 LBL 102.250, CRACKED AND DENTED. PERMANENT REPAIR ACCOMPLISHED AS PER ATLAS AIR XEO 53-110607, BOEING DRAWING 65B17951 AND FAA FORM 8100-9.SDR CALA0700668Door Frame · crackedINSPECTION FOUND A .25 INCH CRACK IN FORWARD CARGO DOOR AFT FRAME AT LOWER DOOR STOP AREA, STA 440-460, S14R TO S27R. THE AFT FRAME WAS REMOVED AND REPLACED IAW SRM 51-40-02.SDR SWAA075597Crease Beam · corrodedDURING SCHEDULED 16Y CHECK, FOUND CREASE BEAM CHORD CORRODED BETWEEN BS 947 AND BS 995, RBL 50. REPAIRED CHORD PER SRM.SDR SWAA075574Crease Beam · corrodedDURING SCHEDULED 16Y CHECK, FOUND CREASE BEAM CORRODED BETWEEN BS 320 AND BS 338, LBL 70. REPAIRED CREASE BEAM PER SRM.SDR DHLA200700055Torque Box · crackedDURING AN"A" CHECK, TORQUE BOX AREA, LIGHTING HOLES AT STA 1223 LT AND RT HAVE SMALL CRACKS 2 AFT AIR STAIR AREA (PREVIOUSLY REJECTED ON NR 138359). CUT OUT DAMAGED AREA AT TORQUE BOX AREA LIGHTING HOLES/H DIMENSION CUTOUT 3/4" BY 1/4" IAW B727 SRM 53-10-1 FISDR USAA920071373Crease Beam · crackedCLT - MAJOR REPAIR - C-18 CHECK- A CRACK FOUND ON INNER CHORD OF LEFT CREASE BEAM AT ATTACHMENT TO BS 616, LBL 4. REMOVED DAMAGE AND INSTALLED FABRICATED REPAIR ANGLE IAW US AIRWAYS EA 100058.SDR USAA920071359Crease Beam · crackedCLT - MAJOR REPAIR - C18 CHECK, CRACKED LEFT CREASE BEAM WEB, BS 616 - BS 639. REPLACED LEFT CREASE BEAM WEB, BS 616 - BS 639 IAW USAIRWAYS EA 10058.SDR DHL2007748034Window Frame · corrodedLT WINDOW FRAME PLUG AT STATION 950F TO 970 HAS CORROSION. REMOVED WINDOW PANE AND PLUG IAW MM 53-20-00 AND DRAWING NR AE727-1-105. CLEANED WINDOW PLUG PANE FOR EVALUATION NO CORROSION NOTED IAW S0PM 20-30-3. REMOVED CORROSION ON WINDOW FRAME. CORROSION FOSDR DHL2007748033Window Frame · corrodedRIGHT WINDOW FRAME PLUG AT STATION 950F TO 970 HAS CORROSION. REMOVED WINDOW PANE AND PLUG AT BS 950F TO 970 RIGHT IAW M/M 53-20-00 FIGURE 1 AND AEI DRAWING NR AE727-1-105 REV B. REMOVED CORROSION FROM WINDOW FRAME, FOUND OUT OF LIMITS IAW SRM 51-10-6, 56-2SDR MWEA070278Door Frame · crackedLEFT MAIN LANDING FORWARD DOOR FRAME CRACKED AT STATION X56.25, Y764.50, Z30.25. = 80 INCHES LONG. FABRICATED AND INSTALLED DOUBLER.SDR 07FDEA04716Door Frame · crackedMAIN CABIN R1 DOOR FWD JAMB DURING PERFORM OAN J/C SP10240272-7001-2J FOUND CRACK ON FRAME. REPAIRED FRAME IAW SRM 53-00-01 VOL I FIG 8.SDR 07FDEA04712Beam · crackedFOUND CRACK (ABOUT 12MM) AT GANTRY 5 LT, C50B REPAIR PERFORMED IAW DRAWING R538-10737-204, APPROVED BY EA 6-5315-114912 AND RAS/054790/009/2007 ISS A .SDR 2007UALA04528Door Frame · crackedFWD CARGO DOOR CUTOUT, FWD FRAME BS 440 AT STR 24R, HAS CRACK EMINATING FROM LOWER BOTTOM STOP FITTING, APPROX 1". MAJOR REPAIR ACP'D, INST'D NESTED DOUBLER TRIPLER REPAIR ANGLE REPAIR.SDR DALA1129169220Door Frame · corrodedFWD LOWER CARGO DOOR JAMB PAN CORROSION REPAIR FWD CORNER TO AFT CORNER.SDR QXEA200701671Structure · corrodedC2 PDX - AFT CARGO BAY CORROSION FASTENER HOLES INBOARD OF CARGO DOOR LIP. REPAIRED IAW SRM 51-14-00, 51-21-10.SDR DHL2007785040Beam · corrodedSURFACE CORROSION AT BS 1183 LOWER HORIZONTAL "I" BEAM INBOARD SIDE JUST AFT OF OUT FLOW VALVE, STRINGER 26R. REMOVED CORROSION IAW B-727 SRM 51-10-6, CORROSION FOUND OUT OF LIMITS IAW B-727 SRM 53-10-1 FIGURE 1, REMOVED BEAM IAW B-727 SRM 51-30-2, FABRICATEDSDR 2007UALA04477Structure · dentedAFT OF L1 DOOR BETWEEN FRAMES 23 & 24, S22-23L. A LARGE DENT MEASURING 3.5 INCHES BY 2 INCHES AND .250 INCHES DEEP. PATCH ON FWD EDGE IS ALSO DENTED.SDR 2007UALA04494Door Frame · damagedR-2 DOOR AT UPPER HINGE CUT-OUT IS DAMAGED.SDR 2007UALA04484Door Frame · crackedFORWARD CARGO COMPARTMENT DOOR CUTOUT FWD FRAME IS CRACKED ON AFT SIDE OF LOWER OUTBOARD CORNER OF BOTTOM DOOR STOP FITTING. ACCOMPLISHED MAJOR REPAIR.SDR KCSA071505Door Frame · crackedL5 MAIN ENTRY DOOR LOWER O/B HORIZONTAL FRAME CRACKED BS 2240.
Back to JASC 5310