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 06FDEA1982Crease Beam · dentedFOUND CREASE BEAM WEB DENTED ON THE LIGHTENING HOLE, BS 925, LBL 66, WL 208. REPLACED WEB PER SRM 51-40-5, 51-30-2.SDR TRAX200600248Clip · crackedFOUND CLIP CRACKED ON TOP OF BOX BEAM, FS 639 BELOW STR 9.SDR COMA0670145Beam · corrodedFS 280 TRANSVERSE BEAM CORRODED BEYOND REPAIRABLE LIMITS. REPLACED THE TRANSVERSE BEAM AT FS 280 IAW BOMBARDIER REO 670-53-11-047 REV D.SDR IXXA06SMN150SDoor Frame · crackedDURING ROUTINE C CHECK INSPECTION, FOUND AFT PASSENGER DOOR JAMB FORWARD UPPER CORNER CRACKED 1 INCH. PERFORMED MAJOR REPAIR IAW AD 2000-20-08, SB 53-075, DOUGLAS DRAWING SR 08530021, 5750776. REMOVED DAMAGED AREA IAW DOUGLAS DRAWING SR 08530021. PERFORMED NDSDR 2006UALA00971Crease Beam · corrodedFWD GALLEY DOOR CREASE BEAM INBD OF THRESHOLD FROM STA 294-340 HAS CORROSION.SDR 2006UALA00970Door Frame · crackedFWD PIT AFT DOOR OPENING AFT FRAME STA 492.4 CRACKED AT STR 24R.SDR 2006UALA00968Crease Beam · corrodedCABIN FLOOR LT CREASE BEAM INBOARD CHORD IS CORRODED BS 947-994 STR 17L WL 208.SDR ASAA0640604Stop Fitting · damagedFOUND MECHANICAL DAMAGE ON DOOR STOP FITTING. REPLACED STOP FITTING PER SRM 51 40 02.SDR UPS06146930Crossbeam · crackedMAIN CABIN, CROSSBEAM CRACKED AT FS 49 RBL36. REMOVED AND REPLACED CROSSBEAM PER A300 SRM 51-40-21.SDR 2006UALA00959Crease Beam · corrodedFWD ENTRY DOOR CREASE BEAM FROM APPROX STA 320 - STA 360 HAS CORROSION.SDR TRAX200600233Beam · crackedSUSPECT POSSIBLE CRACK ON CENTER BOX BEAM UNDER FIRE LOOP CLIP.SDR SWAA061689Door Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FWD CARGO DOOR CUTOUT FRAME CRACKED AT BS 495, NR 5 DOOR STOP FITTING. REPAIRED FRAME PER SB.SDR 06FDEA1938Shear Tie · tool damageDRILL START ON LOWER SHEAR TIE AT BS 720A BETWEEN STR 20L, STR 21L. REPAIRED SHEAR TIE PER SRM 53-10-1.SDR SWAA061672Window Post · crackedDURING SCHEDULED 1/4D CHECK, FOUND COCKPIT L1 WINDOW UPPER OUTBOARD POST CRACKED. REPAIRED WINDOW POST PER SRM.SDR DHL2006754509Door Frame · corrodedAFT CARGO COMPT CUTOUT STA 990 INNER CHORD IS CORRODED WITH EXFOLIATION ON AFT SURFACE BETWEEN STR 26R AND STR 27R. CUT OUT DAMAGE AREA AT STA 990 STR 26R TO 27R DIM .75 X .75 INCH IAW B727 SRM 51-40-4 FIG 1. FAB ANGLE REPAIR MAT USED BAC1514-1437 PO 610110SDR DHL2006754501Structure · corrodedFWD CARGO COMPT, STA 740 STRUCTURE IS CORRODED AT STR 27R. REMOVED PANELS, REMOVED STIFFENER AND CLIPS, FABBED DOUBLER REPAIR 2 EACH DIM (13.5 X 3.5) (11 X 3.5). HEAT TREATED, ALODINED PRIMED AND INSTALLED. REINSTALLED PANELS AND CLIPS. ALL WORK DONE IAW BSDR QXEA200601365Structure · corrodedPDX: C3. AFT BAGGAGE COMPARTMENT AT PANEL 144JZ APERATURE HAS CORROSION. MAINTENANCE REPAIRED IAW Q400 SRM 51-21-00-350-801 AND SRM 51-21-00-800-801.SDR 06FDEA1928Door Frame · corrodedLEFT AFT EMERGENCY EXIT SEAL FRAME CORRODED. FOUND CORROSION ON SEAL FRAME TO BE OUT OF LIMITS. REMOVED AND REPLACED LT AFT EMERGENCY EXIT HATCH PER MM 52-21-000-5.SDR A6WA200640186Rib · crackedFOUND RIGHT MLG WHEEL WELL BATTERY RIB HAS A .5 INCH LONG CRACK IN TOP RADIUS. REPAIRED RT MLG WHEEL WELL BATTERY RIB BY TRIMMING OUT DAMAGED AREA, CUT DOUBLER, FABRICATED REPAIR PARTS AND WET INSTALLED IAW BOMBARDIER REO 601R-57-51-046 REV B REPAIR NR 1. (MSDR DHL2006754514Vertical Beam · crackedSTA 1183 VERTICAL BEAM IS CRACKED AT RBL 36. STOP DRILL CRACK .250 INCH DIAM AT STA 1183 RBL 36 IAW B727 SRM 51-10-1, LOCATED & DRILLED HOLES AT VERTICAL BEAM REINFORCEMENT ANGLE P/N 65C34488-3 PO 626096 & P/N 65C34488-2 PO 626095 (6EA) IAW DWG BOEING 65C3440SDR 2006UALA00936Crease Beam · damagedLEFT CABIN CREASE BEAM OUTER CHORD BS 630 IS DAMAGED. REPAIR SPLICE AND SPLICE ANGLES INSTALLED.SDR USAA060697Door Frame · crackedIN FWD SERVICE DOOR CUTOUT FRAME AT FWD UPPER STOP FITTING GLOWER O/B CORNER CRACKED. MAJOR REPAIR IAW SRM 51-10-02, DEFECT SIZE: .250 INCH.SDR IXXA06SMN120SRepair · improperDURING ROUTINE C CHECK INSPECTION, EXTERNAL FUSELAGE LEFT HAND FORWARD PASSENGER DOOR LOWER AFT JAMB CORNER HAS NON STANDARD REPAIR AT STATION 55.000 FROM LONGERON-20 LEFT TO LONGERON 22 LEFT. PERFORMED MAJOR REPAIR IAW AD 2000-20-08, SB DC8 53-075, DOUGLAS DSDR IXXA06SMN119SRepair · improperDURING ROUTINE C CHECK INSPECTION, EXTERNAL FUSELAGE LEFT HAND FORWARD PASSENGER DOOR UPPER FORWARD JAMB CORNER HAS NON STANDARD REPAIR AT STATION 25.000, FROM LONGERON-9 LEFT TO LONGERON 11 LEFT. PERFORMED MAJOR REPAIR IAW AD 2000-20-08, SB DC8 53-075, DOUGLSDR IXXA06SMN118SRepair · improperDURING ROUTINE C CHECK INSPECTION, EXTERNAL FUSELAGE LEFT HAND FORWARD PASSENGER DOOR UPPER AFT JAMB CORNER HAS NON STANDARD REPAIR AT STATION 55.000, FROM LONGERON-9 LEFT, TO LONGERON-11LEFT. PERFORMED MAJOR REPAIR IAW AD 2000-20-08, SB DC8 53-075, DOUGLAS DSDR IXXA06SMN109SDoor Frame · crackedDURING ROUTINE C CHECK INSPECTION, EXTERNAL FUSELAGE AFT PASSENGER DOOR LEFT HAND LOWER CORNER CRACKED 2". PERFORMED MAJOR REPAIR IAW AD 2000-20-08, SB DC8 53-075, DOUGLAS DRAWING SR 08530021, S750776. REMOVED EXISTING FASTENERS IAW DC8 SRM 51-1-2L, DC-8 SRM SDR CA060511001Door Frame · cracked.5 INCH CRACK FOUND IN LOWER LT DOOR POST JAMB DURING ROUTINE INSPECTION.SDR 2006UALA00931Crease Beam · corrodedFOUND CABIN FLOOR CREASE BEAM WEB CORRODED LT BS 418.SDR 06FDEA1801Structure · ground damageLEFT SIDE OF FUSELAGE JUST FWD OF WING L/E WAS STRUCK BY VENDORS CREW, ENTRY STAIRS CAUSING MAJOR DAMAGE. REPAIRED FUSELAGE SKIN DAMAGE AS PER E.A. 7-5330-100531 AND SRM 53-30-3 FIG.12.REF N/R 9SDR 06FDEA1797Structure · corrodedFOUND FUSELAGE BS 336 LBL 18 WL 148, LONGITUDINAL CHORD ATTACH CLIP CORRODED. REPLACED ATTACH ANGLE PER SRM 51-30-2.SDR USAA060686Door Frame · crackedFWD SERVICE DOOR CUTOUT FWD FRAME INNER CHORD ANGLE CRACKED. INSTALLED DOUBLER IAW SRM 51-70-11, DEFECT SIZE: .750 INCH.SDR UPS06446932Stiffener · crackedINSPECTION TYPE:C NWW LT SIDE PANEL BS260-280 WL 180 STIFFENER RADIUS AREA. FOUND CRACK APP 1 3/8" LONG, STIFFENER. REPLACED AS PER SRM 51-10-01 PG9 AND INSTALLED AS PER SRM 51-30-02.SDR 2006FA0000497Threshold · crackedCABIN ENTRY THRESHOLD CRACKED AT AFT STEP ATTACH BOLT HOLE. COMBINATION OF BOLT HOLE LOCATED IN RADIUS OF FRAME AND MATERIAL THICKNESS NOT SUFFICIENT TO SUPPORT WEIGHT OF PERSON ENTERING OR EXITING AIRCRAFT. RECOMEND STRENGTHING STRUCTURE, USING THICKER METASDR 06FDEA1753Repair · misinstalledFOUND PREVIOUSLY REPAIR INSTALLED AT STA 765 STR 8R IS NOT CONFORMED TO FAA APPROVED DATA, REMOVED EXISTING REPAIR AND REINSTALLED REPAIR DOUBLER AND FILLER IAW SRM 53-30-3 AND SRM 51-30-2. REPAIR IS CLASSIFIED AS MAJOR PER FEDEX GMM 6- 2-100.SDR USAA060674Door Frame · crackedFWD SVC DOOR CUTOUT FWD FRAME CRACKED. INSTALLED DOUBLER IAW SRM 51-70-11, DEFECT SIZE: .750 INCH.SDR UPS06846866Door Frame · crackedINSPECTION TYPE:C1 HFEC AND VISUAL INSP DETECTED A .250 INCH CRACK ON THE D-PIT UPPER FWD DOOR JAMB CORNER. CUT OUT DAMAGED AREA ON C-PIT UPPER FWD DOOR JAMB CORNER IAW SRM 53-02-00 FIG 021, FABRICATED AND INSTALLED FILLER, DOUBLER AND TRIPLER AT THE C-PIT UPSDR SWAA061548Door Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND R1 DOOR FRAME CUTOUT CRACKED AT BS 296.5, STR 6R. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA061539Window Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND COCKPIT WINDOW L1 FRAME CRACKED AT UPPER OUTBOARD CORNER. REPAIRED WINDOW FRAME PER SWA EA AND SRM.SDR SWAA061537Door Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FWD CARGO DOOR CUTOUT AFT FRAME CRACKED AT UPPER INBOARD CORNER OF NR 5 STOP. REPAIRED FRAME SECTION PER EA.SDR ASAA0640555Shear Tie · crackedFOUND CRACKED SHEAR TIE. CUTOUT SHEAR TIE AND REPLACED PER SRM 53 00 07.SDR UPS06446917Stiffener · crackedNWW TOP PANEL BS280-300 RBL 10 STIFFENER RADIUS AREA FOUND CRACK APP 3/4". NWW TOP PANEL BS280-300 RBL10 STIFFENER REPLACED AS PER SRM 51-10-01 PG9 AND INSTALLED AS PER SRM 51-30-02.SDR 2006UALA00901Crease Beam · corrodedFOUND CABIN CREASE BEAM WEB CORRODED AT STA 807-827 LBL 65- 71 WL 208.SDR SWAA061521Door Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FWD CARGO DOOR CUTOUT FRAME CRACKED AT UPPER AFT CORNER LOWER DOOR STOP. REPAIRED FRAME PER ER.SDR TRAX200600189Beam · crackedFS 280 BEAM CRACKED AT LOWER RADIUS AT LBL 9, RESOLVED ON W/O: 24018 TASKCARD: N/R-00228. REPAIRED FS 280 BEAM CRACK INCORPORATING EC REO 601R-53-11-926.SDR TRAX200600187Beam · corrodedFS 280 BEAM CORRODED ON TOP FLANGE AT NUTPLATE HOLES, RESOLVED ON W/O: 24018 TASKCARD: N/R-00229. REPAIRED CORROSION TO 280 BEAM IAW REO 601R-53-11-926.SDR TRAX200600179Beam · crackedRT LOWER BOX BEAM WEB CRACKED AT ACCESS PANEL FWD I/B NP, RESOLVED ON W/O: 24018 TASKCARD: N/R-00139. REPAIRED IAW REO 601R 53-61-366.SDR TRAX200600177Beam · crackedLT LOWER BOX BEAM WEB CRACKED AT ACCESS PANEL FWD I/B NP, RESOLVED ON W/O: 24018 TASKCARD: N/R-00138. REPAIRED IAW REO 601R-53-61-366.SDR SWAA061505Door Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FWD CARGO DOOR FRAME CUTOUT CRACKED AT BS 440, NR 5 STOP PAD. REPAIRED FRAME SECTION PER ER AND SB.SDR QXEA200601568Frame · corrodedYYC - C3 AFT BAGGAGE COMPARTMENT UNDER FLOOR PANEL 144DZ SMALL FRAMES FOR DOOR SILL AT STATION X747.0, X755.0, X763.0 AND X775.0 ARE CORRODED BEYOND LIMITS. REMOVED AND REPLACED IAW DHC-8-400 SRM 51-40-07-320-801, 51-25-15-370-801 AND 51-23-00-800-801.SDR 2006UALA00877Drag Brace · corrodedAC FUSELAGE RT VERTICLE DRAG BRACE HAS LIGHT CORROSION ON AFT SIDE OB.
Back to JASC 5310