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 SWAA094720Crease Beam · corrodedDURING SCHEDULED 14Y CHECK, FOUND CREASE BEAM CORRODED BETWEEN BS 842 TO BS 847, LBL 68. REPAIRED BEAM PER SRM.SDR UALA2009072202165Panel · corrodedAFT CARGO PIT FLOOR PANEL DAMAGED AND CORROSION ON UNDERLYING STRUCTURE. MAJOR REPAIR ACCOMPLISHED. FLOOR PANEL REMOVAL. CORROSION WAS NOTED AT THE SILL PLATE HAT CHANNEL EXTENDING THE WIDTH OF THE CARGO PIT ENTRY WAY. REMOVED AFT PIT UPPER SCUFF PLATE. OSDR UALA2009072102159Structure · damagedSTA 246 CABIN FLOORBEAM MID CHORD FASTENER HOLE AT LBL 11 FOUND PREVIOUSLY DAMAGED AND FILLED WITH SEALANT. MAJOR REPAIR ACCOMPLISHED: INSTALLED FREEZE PLUG REPAIR.SDR SWAA094655Crease Beam · crackedDURING SCHEDULED 12Y CHECK, FOUND LT CREASE BEAM CRACKED BETWEEN BS 787 TO BS 807. REPAIRED BEAM PER SRM.SDR FDEA200907212688Crossbeam · corrodedPAX DOOR LT 1 INTERNAL STRUCTURE CORRODED. CORRODED STRUCTURAL PARTS CHANGED BY NEW PARTS IAW SRM 51-72-10; 51-24-00 AND 51-75-10.SDR FDEA200907212681Structure · crackedCENTER LANDING GEAR - RT CUT-OUT FOR SPOILER MIXER INPUT ROD DOUBLER CRACKED. CTR LANDING GEAR - RT CUT-OUT FOR SPOILER MIXER INPUT ROD DOUBLER REMOVED AND REPLACED WITH NEW DOUBLER IAW SRM 51-31-01 VOL. II REV. 40. THIS REPAIR CLASSIFIED AS MINOR IAW GMM 6SDR FDEA200907212680Structure · crackedCENTER LANDING GEAR- LT CUT-OUT FOR SPOILER MIXER INPUT ROD DOUBLER CRACKED. CTR LANDING GEAR- LT CUT-OUT FOR SPOILER MIXER INPUT ROD DOUBLER REMOVED AND REPLACED WITH NEW DOUBLER IAW SRM 51-31-01 VOL. II REV. 40. REPAIR CLASSIFIED AS MINOR IAW GMM 6-2-100SDR C2XA09SH209Door Frame · corrodedSHV - DURING C-CHECK SERVICE DOOR CUTOUT AFT STRUCTURE AT FRAME 22 BETWEEN STRINGER 15R AND 16R HAS CORROSION AT BOLT HOLE. MAINTENANCE REPAIRED SERVICE DOOR CUTOUT AFT STRUCTURE AT FRAME 22 BETWEEN STRINGER 15R AND 16R AT BOLT HOLE IAW EC5310-01373. THE AIRSDR FDEA200907202671Beam · crackedCTR CARGO BILGE INSP FOUND CRACK ON BEAM. REPAIRED AREA IAW SRM 53-00-01 FIG 9 SHT 9 VOL I.SDR SWAA094603Crease Beam · corrodedDURING SCHEDULED 24Y CHECK, FOUND LT CREASE BEAM CORRODED BETWEEN BS 847 TO BS 867. REPAIRED BEAM PER SRM.SDR EIAA200900100Tension Tie · damagedTENSION TIE STA. 940 LT AND RT HAS APPROX 30EA OUT OF ROUND HOLES. REMOVED AND REPLACED TENSION TIE BEAM AT BS 940 FROM RBL 99 TO LBL 99 PER SRM 51-30-02 PG. 2-3,4 AND 33-35.SDR AALA20090724TUL05Stop Fitting · crackedTUL - RIGHT CENTER VAULT DOOR JAMB STOP BRACKET IS CRACKED. REMOVED AND REPLACED BRACKET PER SRM 53-01-00.SDR AALA20090724TUL04Stop Fitting · crackedTUL - LEFT CENTER VAULT DOOR JAMB STOP BRACKET IS CRACKED. REMOVED AND REPLACED STOP BRACKET PER SRM 53-01-00.SDR A6WA200940428Door Frame · crackedCARGO DOOR SURROUND LANDING PLATE IS CRACKED AT FS 589 AND FS 605. CARGO DOOR SURROUND LANDING PLATE AT FS 589 AND FS 605 REPAIRED IAW REO 601R-53-61-433. (K)SDR AALA20090723TUL37Door Frame · crackedCABIN FORWARD ENTRY JAMB CRACKED TAB ON DOOR JAMB WEB STATION 208 AT LONGERON 15L. INSTALLED DOUBLER PER AARD 53-10-00-11.SDR AALA20090723TUL12Door Frame · crackedCRACKED DOOR JAMB WEBBING AFT TAB. INSTALLED DOUBLER ON DOOR JAMB WEBBING PER AARD 53-10-00-11.SDR COEA2009071406901Sill · bentORIG / OPEN: FOUND IN COE HEAVY CHECK: MAJOR REPAIR: CAPTAIN'S WINDOW UPPER SILL IS BENT AT LBL 21 INCHES AT LOWER EDGE OF UPPER RETAINER.SDR COEA2009071405901Structure · corrodedFOUND IN COE HEAVY CHECK: LEVEL 2 CORROSION/ MAJOR REPAIR: INTERIOR CARGO COMPARTMENT, RT MLG PRESSURE DECK LOWER SIDE BOX BETWEEN FR 26-27 HAS AREAS OF CORROSION AND CORRODED FASTENER HEADS.SDR COEA2009071404901Crease Beam · corrodedFOUND IN COE HEAVY CHECK: LEVEL 2 CORROSION: RT CREASE BEAM WEB BETWEEN FR 27 - 28 HAS AREAS OF SURFACE (LEVEL 2) CORROSION.SDR SWAA094495Crease Beam · corrodedDURING SCHEDULED 24Y CHECK, FOUND RT CREASE BEAM CORRODED BETWEEN BS 727E TO BS 747. REPAIRED BEAM PER SRM.SDR SWAA094486Crease Beam · corrodedDURING SCHEDULED 14Y CHECK, FOUND LT CREASE BEAM WEB CORRODED BETWEEN BS 386 TO BS 392. REMOVED AND REPLACED WEB PER SRM.SDR EIAA200900097Structure · damagedBS 240 STR. 34L HAS ONE ELONGATED HOLE AND DENT COMMONT TO STR. CLIP. REMOVED DAMAGE, FABBED AND INSTALLED REPAIR PER SRM 53-10-03 FIG 3 DETAIL II.SDR EIAA200900096Structure · damagedBS 220 STR 28 AR HAS A ELONGATED HOLE COMMON TO STRIP CLIP. REMOVED AND REPLACED STR AT BS 220-240 STR 28 AR PER SRM 51-30-02 PG 2-3 AND7-8SDR FDEA200907132611Floorbeam · misalignedDUE TO EXISTING FLOORBEAM REPAIR AT STA 1320, LBL 4-38, CAN NOT INSTALL MOD FITTING NR 657N3320-1 AT STA 1640, WL 208.10, LBL 24.75, A PREVIOUS REPAIR CONFLICTED WITH ACCOMPLISHMENT OF PTF CONVERSION. A NEW REPAIR WAS ACCOMPLISHED ON MAE W/C 118350521EZ2, ANDSDR FDEA200907132606Beam · corrodedFOUND COROSION IN THE AREA OF ACCESS DOOR 312AR LOWER BEAM C 84-85, P 30-36 RT. REPAIR PERFORMED BY BLEND OUT THE CORROSION , NDT FOR DAMAGE FREE CONDITION AND INSTALLING A REINFORCING ANGLE IAW RAS/EFW/9000202/2009 ISS. A, APPROVED BY EA 6-5310-129162.SDR 2009FA0000700Door Frame · corrodedDURING AN IMBV THE SERVICE DOOR CUT OUT AFT FRAME WAS FOUND TO BE CORRODED. DO NOT HAVE ENOUGH INFORMATION AT THIS TIME TO DETERMINE THE EXACT CAUSE OF DAMAGE. (K)SDR SIMA200919505Door Frame · corrodedDURING IMBV THE SERVICE DOOR FRAME WAS FOUND TO BE CORRODED. AIRCRAFT REMOVED FROM SERVICE. REMOVED THE CORRODED FRAME. PREPPED, CLEANED, ALODINED, PRIMED AND INSTALLED NEW FRAME P/N 145-22191-015 IAW SRM 51-20-01, 51-20-03, 51-40-02, 51-40-04, 51-40-06 ANDSDR FDEA200907102580Splice · cracked2 EA FASTENER HOLES HAVE SMALL CRACKS ON EDGES STA 1640- 1660, STR 4L. REMOVED DAMAGE, FABRICATED NEW SPLICE ON MAE TRAV NR T9/798311. INSTALLED SPLICE AND FILLER STA 1640- 1660, STR 4L, IAW SRM 53-00-03. CATEGORY "A", MAJOR REPAIR.SDR C2XA09TY149Door Frame · corrodedCORROSION ON AFT LOWER END OF SERVICE DOOR CUT OUT FRAME. DOUBLER WAS MADE FROM A SPARE FRAME AND INSTALLED IAW EC 5310-01373.SDR FDEA200907092548Door Frame · crackedCRACK INDICATION FOUND ON 1ST LAYER WEB FROM TOP DURING HFEC OPEN HOLE INSPECTION ON 0.520" HOLE AT MAIN CARGO DOOR NO. 7 LOWER JAMB FITTING AT HOLE B. REPAIRED IAW EA 1-5310-132150.SDR FDEA200907092547Door Frame · crackedCRACK INDICATION FOUND ON 2ND LAYER WEB FROM TOP DURING HFEC OPEN HOLE INSPECTION ON 0.520 INCH HOLE AT MAIN CARGO DOOR NR 6 LWR JAMB FITTING AT HOLES B AND D. REPAIRED IAW EA 1-5310-132150.SDR FDEA200907092546Door Frame · crackedCRACK INDICATION FOUND ON 1ST LAYER WEB FROM TOP DURING HFEC OPEN HOLE INSPECTION ON 0.520 INCH HOLE AT MAIN CARGO DOOR NR 6 LWR JAMB FITTING AT HOLE D. REPAIR IAW EA 1-5310-132150.SDR FDEA200907092545Door Frame · crackedCRACK INDICATION FOUND ON 1ST LAYER WEB FROM TOP DURING HFEC OPEN HOLE INSPECTION ON 0.520 INCH HOLE AT MAIN CARGO DOOR NR 1 LWR JAMB FITTING AT HOLES A AND C. REPAIR IAW EA 1-5310-132150.SDR FDEA200907082532Failsafe · corrodedFOUND CORROSION ON RT FWD PAX DOOR 1 LOWER FAIL SAFE RING. REPAIR PERFORMED BY BLEND OUT THE CORROSION , NDT FOR CRACK FREE CONDITION IAW RAS 70520367/004/2009 ISS. A , APPROVED BY EA 6-5310-131247SDR FDEA200907072523Structure · damagedWHILE LOCATING CHORD 144N8007-64, IAW PTF MOD W/C PRODUCTION FOUND THAT IF DRILLED THE CHORD WOULD HAVE SHORT ED. COMMON TO THE TRANSVERSE WEBS AT STA 1160, RBL63 TO LBL63. AT BS 1160, RBL63 TO LBL 63, UPPER CHORD REPLACEMENT WAS ACCOMPLISHED, DUE TO DISCRESDR IPXA09556749Door Frame · gougedINSPECTION TYPE: C2 MAIN CARGO DOOR BS570 FRAME HAS A SCREW GOUGE 7 INCHES DOWN FROM STR 1 4L. REPAIRED IAW ATS ER 09-3504 DATED 20JUL09.SDR SWAA094315Crease Beam · corrodedDURING SCHEDULED 14Y CHECK, FOUND RT CREASE BEAM WEB CORRODED BETWEEN BS 767 TO BS 772. REMOVED AND REPLACED WEB PER SRM.SDR FDEA200907072505Beam · crackedFOUND CRACK IN LT BEAM NR4 LWR FLANGE AT C49. REPAIR PERFORMED IAW DWG R538-10581 WITH DEVIATION IAW RAS 70520550/004/2009 ISS. A, APPROVED BY EA 6-5310-131201.SDR FDEA200907072501Beam · crackedFOUND CRACK IN BEAM 5 LT C 52-53. REPAIR PERFORMED BY DWG R538-10583-02, EXCEPT TRIMMING THE REPAIR ANGLE BY 2 ROWS, APPROVED BY RAS 70520670/009/2009 ISS. A AND EA 6-5310-129194.SDR 2009FA0000611Structure · corrodedOUT OF LIMITS CORROSION ON R2 ENTRY INNER CHORD AT BS 1006-1016, RBL 56, WL 208.1.SDR DLM88091117Beam · corrodedDURING HMV EXFOLIATION CORROSION WAS FOUND ON C2 LOWER DOOR JAMB BEAM. BEAM WAS REPAIRED IAW SRM 53-05 FIG 123SDR DLM88091112Door Frame · corrodedDURING HMV EXFOLIATION CORROSION WAS FOUND ON LOWER DOOR JAMB AT STAY=370 TO 427 AT C1 SECTION OF LOWER DOOR JAMB WAS REPLACED IAW SRM 53-05D FIG 804SDR ASAA0976106Door Frame · crackedFWD GALLEY DOOR FRAME CRACKED BS 296, WL 208, RBL 53. REMOVED DAMAGE FABRICATED REPAIR PARTS AND INSTALLED.SDR C2XA09SH189Beam · corrodedSHV - DURING C-CHECK CARGO DOOR CUTOUT LOWER BEAM CORRODED. MAINTENANCE REMOVED AND REPLACED CARGO DOOR CUTOUT LOWER BEAM IAW SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR DL757091182Failsafe · misinstalledDURING WIFI RACK INSTALLATION THE FUSELAGE FRAME FAILSAFE WAS MISDRILLED AT FS 1540 BETWEEN S21R AND S22R IN THE AFT CARGO BIN RIGHT LOWER LOBE. REPAIR ACCOMPLISHED PER ERA 475918-14_REV 2 DTD 11JUL09/1300.SDR ASAA0996101Sill · corrodedCORROSION ON MOP SILL BS 328, RBL 58, WL 208. REPLACED MOP SILL PER SRM.SDR ASAA0996092Vapor Barrier · crackedBS 662 BULKHEAD VAPOR BARRIER AT RBL 14.5 WL 146 HAS A CRACK. REPAIRED CRACK PER SRM.SDR ASAA0996093Doubler · bentDOUBLER RING FOR DUCT AT BS 663, LBL 15 27 WL 146 IS CROOKED. FABRICATED AND REPLACED DOUBLER.SDR 2009FA0000595Floorbeam · corrodedOUT OF LIMITS CORROSION ON BS 986.5 FLOORBEAM UPPER AND LOWER SURFACES LBL22- RBL44.SDR UALA2009070101889Structure · crackedFOUND CRACK ON E/E COOLING DUCT CUTOUT. LOWER FUSELAGE BS BETWEEN 360-380 AND 28L/R. ACP HFEC OF SUSPECT CRACK IN SKIN AFT OF EQUIP COOLING EXHAUST OPENING. AREA IS CRACKED APPROX ONE HALF INCH LONG FROM EXHAUST OPENING AND TERMINATED AT SCREW FASTENER HOLE
Back to JASC 5310