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 08FDEA04549Crease Beam · crackedR-1 DOOR CREASE BEAM WEB CRACKED AT FWD END OF CUT-OUT. REMOVED AND REPLACED RT CREASE BEAM WEB REF DWG 65-56153 AND SRM 51-30-2. THIS IS CLASSIFIED AS A MAJOR REPAIRSDR AALA200810039Spar · corroded03 PLANK BOLTS SEALANT LOOSE AND EMITTING RUST AT CENTER SPAR BOX RIGHT TOP SIDE. REMOVED 05 BOLTS, FOUND CORROSION IN BORES. REAMED HOLES TO REMOVE CORROSION. TREATED AND PRIMED BORES. MANUFACTURED AND INSTALLED 05 BUSHINGS IN ACCORDANCE WITH ESO 80559 DASDR DLM88081437Door Frame · corrodedC1 CARGO JAMB WAS FOUND CORRODED BEYOND LIMITS AND REPAIRED PER SRM 53-05D FIG 804.SDR SWIA200821041Support · damagedRADAR ANTENNA SUPPORT STRUCTURE DAMAGED, DAMAGE REPAIR. REPLACED STRUCTURE PER SRM.SDR SWIA200820904Buttstrap · corrodedC-CHECK, BUTT STRAPS BETWEEN LAV AND GALLEY CORRODED. REPLACED PER SRM.SDR SWAA085626Crease Beam · corrodedDURING SCHEDULED SPV CHECK, FOUND CREASE BEAM CORRODED BETWEEN RT BS 493 TO BS 500. REPAIRED BEAM PER SRM.SDR SWAA085625Crease Beam · corrodedDURING SCHEDULED SPV CHECK, FOUND CREASE BEAM CORRODED AT BETWEEN RT BS 480 TO BS 492. REPAIRED BEAM PER SRM.SDR FDEA200810184425Window Frame · damagedLIGHTNING STRIKE, LT CABIN WINDOW CUT OUT BS 395- BS 418. REPAIRED LIGHTNING STRIKE IAW SRM 56-20-02 REPAIR NR 1 FIGURE 201 SHT-3 MAJOR REPAIR NO FOLLOW-UP INSP REQUIRED.SDR 08FDEA04425Window Frame · damagedLIGHTNING STRIKE, LT CABIN WINDOW CUT OUT BS 395- BS 418. REPAIRED LIGHTNING STRIKE IAW SRM 56-20-02 REPAIR NR 1 FIGURE 201 SHT, 3 MAJOR REPAIR. NO FOLLOW-UP INSPECTION REQUIRED.SDR AALA200810085Beam · corrodedMID CARGO DOOR BEAM CORRODED AT STATION 636-693. REMOVED CORROSION AND INSTALLED DOUBLER PER AARD 53-10-00-3.SDR FDEA200810164384Crease Beam · corrodedCREASE BEAM INBD CHORD RT SIDE, CORRODED FROM FR 450-660, RBL 58. BLENDED AREA FOUND TO BE OUT OF LIMITS IAW SRM 53-30-13. REMOVED CREASE BEAM FABRICATED NEW CREASE BEAM INBD CHORD IAW DWG 143N5520 IAW SRM 51-40-05. LOCATED AND DRILLED IAW SRM 51-40-05, TRESDR AALA200810094Beam · corrodedAFT CARGO DOOR BEAM CORRODED AT STATION 1155-1211. REMOVED CORROSION AND INSTALLED REPAIR DOUBLER PER AARD 53-10-00-3.SDR USAA920081915Stop Fitting · crackedCLT Q3 MAJOR REPAIR NR 03C100652003/011 AND 03C10652003/010 R1 DOOR STOP FITTINGS CRACKED 3RD AND 4TH FROM TOP/TRAILING EDGE. REPAIRED R1 DOOR STOP FITTINGS 3RD AND 4TH FROM TOP/TRAILING EDGE IAW US AIRWAYS TYPICAL REPAIR NR 51-10-11.SDR USAA920081949Door Frame · crackedCLT Q3 MAJOR REPAIR NR 03C10853030/001CRACK AT RT AFT SERVICE DOOR CUTOUT INTERIOR STRUCTURE UPPER FORWARD LATCH SUPPORT. REPAIRED RT AFT SERVICE DOOR CUTOUT INTERIOR STRUCTURE UPPER FORWARD LATCH SUPPORT IAW B737 SRM 51-40-02.SDR USAA920081950Door Frame · crackedCLT Q3 MAJOR REPAIR NR 03C10652003/012 CRACK AT FORWARD SERVICE DOOR STOP FITTING CUTOUT, 2ND FROM TRAILING EDGE. REPAIRED FORWARD SERVICE DOOR STOP FITTING CUTOUT IAW EA NR 100689 AND TYPICAL REPAIR NR 52-10-11.SDR 08FDEA04384Crease Beam · corrodedCREASE BEAM INBOARD CHORD RT SIDE CORRODED FROM FR 450-660, RBL 58. BLENDED AREA FOUND TO BE OUT OF LIMITS IAW SRM 53-30-13. REMOVED CREASE BEAM. FABRICATED NEW CREASE BEAM IAW DRAWING NR 143N5520 IAW SRM 51-40-05. LOCATED AND DRILLED IAW SRM 51-40-05. TRSDR AALA200820015Failsafe · corrodedFAIL/SAFE RING FASTENERS CORRODED. REMOVED CORROSION IAW EA A300-53-004721 DATED 13 OTC 2008.SDR AALA200810072Window Frame · crackedCRACK AT BELT BOTTOM CORNER ON WINDOW FRAME STATION 1098 RIGHT. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA200810071Structure · crackedFORWARD LOWER TANG CRACKED ON LT WINDOW PAN. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA200810019Beam · corrodedAFT DOOR BEAM CORRODED. INSTALLED DOUBLER PER AARD 53-10-00-03.SDR AALA200810013Beam · out of limitsMID CARGO DOOR LAMB BEAM DAMAGE OUT OF LIMITS. INSTALLED REPAIR DOUBLER PER AARD 53-10-00-3.SDR 08FDEA04328Window Frame · damagedLIGHTENING STRIKE AT LT CABIN WINDOW CUT OUT, BS 335. REPAIRED DAMAGE IAW SRM 56-20-06 AND MAE TRAVELER T8/760848. THIS REPAIR IS CLASSIFIED AS A CATEGORY "A" MAJOR REPAIR WITH NO FOLLOW UP TRACKING REQUIREMENTS.SDR 08FDEA04318Door Frame · crackedCRACK INDICATION FOUND ON SECOND LAYER WEB FROM TOP DURING HFEC OPEN HOLE INSPECTION ON 0.520" HOLES AT MAIN CARGO DOOR NR 7 LOWER JAMB AT HOLES A AND B. CARRIED OUT REPAIR AS PER FEDEX EA 1-5310-125556, REPAIR CLASSIFIED AS MAJOR PER GMM 6-2-100.SDR 08FDEA04317Door Frame · crackedCRACK INDICATION FOUND ON SECOND LAYER WEB FROM TOP DURING HFEC OPEN HOLE INSPECTION ON 0.520" HOLES AT MAIN CARGO DOOR NR 6 LOWER JAMB AT HOLE A. CARRIED OUT REPAIR AS PER FEDEX E.A. 1-5310-125556, REPAIR CLASSIFIED AS MAJOR PER GMM 6-2-100.SDR USAA920081919Crease Beam · corrodedBFM MAJOR REPAIR C3 CHECK NR 6013042, CORROSION ON CREASEBEAM, BS 1502, BS 1518, RBL 84. REPAIRED CREASEBEAM, BS 1502, BS 1518, RBL 84 IAW EA 134030.SDR KCSA081527Door Frame · crackedL1 MAIN ENTRY DOOR LOWER FRAME CRACKED AT FWD EDGE BS 442 TO 450.SDR KCSA081521Door Frame · crackedL-5 DOOR FORWARD LOWER CORNER VERTICAL FRAME CRACKED .5 INCHES. (K)SDR FDEA200810084277Crease Beam · corrodedAREA ABOVE RT MLG WW, BS 1180 BULKHEAD ZONE 141, RBL 58, CREASE BEAM INNER CHORD HAS CORROSION AT NUTPLATE. BLENDED AREA AND FOUND TO BE OUT OF LIMITS IAW SRM 53-16-13 . REMOVED CREASE BEAM INBD CHORD, STA 1040-1180, RBL 58. FABRICATED NEW CREASE BEAM I/B SDR SWIA200820572Window Frame · crackedC-CHECK, LEFT FRAME WEB CRACKED, AFT OF CENTER DV WINDOW FRAME. REPAIRED PER SRM.SDR AALA200810010Window Frame · crackedFORWARD LOWER SIDE OF WINDOW PAN IS CRACKED AT AFT SIDE OF STATION 1022 RIGHT SIDE. INSTALLED REPAIR ANGLE PER AARD 53-40-00-25.SDR AALA200810009Window Frame · crackedAFT UPPER CORNER OF WINDOW PANE IS CRACKED. DOUBLER INSTALLED PER AARD 53-10-00-25.SDR AALA200810008Window Frame · crackedAFT UPPER CORNER OF WINDOW PAN IS CRACKED AT STATION 1041 LEFT SIDE. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR GLBA200810008088Window Post · crackedSUPPLEMENTAL INFORMATION - MAJOR REPAIR. CRACK IN RT FWD DV WINDOW POST. C/W EO 04-716L-01 ON RT DV WINDOW IAW THE INCLUDED INSTRUCTIONS AND SB 120-53-0072. SCHEDULED MAINTENANCE INSPECTION IT WAS DISCOVERED THAT THIS REPAIR DOES NOT CONFORM TO GIVEN DOCUMESDR SWAA085474Crease Beam · corrodedDURING SCHEDULED 14Y CHECK, FOUND CREASE BEAM CORRODED BETWEEN BS 360 TO BS 380 AT STR 17R. REMOVED AND REPLACED BEAM PER SRM.SDR 08FDEA04277Crease Beam · corrodedAREA ABOVE RT MLG WW, BS 1180 BULKHEAD ZONE 141, CREASE BEAM HAS CORROSION AT NUTPLATE. BLENDED AREA AND FOUND TO BE OUT OF LIMITS IAW SRM 53-16-13. REMOVED CREASE BEAM BS 1040-1180, FABRICATED NEW CREASE BEAM IAW SRM 53-30-13 . LOCATED AND DRILLED, TREATESDR 08FDEA04269Gusset · corrodedLOWER FWD CARGO DOOR S/N 822, INTERNAL LOWER FRAME, 2 GUSSETS ARE CORRODED AT LWR END. 1 AT 28" AFT, 2ND AT 39" AFT. REMOVED AND REPLACED GUSSETS REF SRM 51-30-02 P 1-4. THIS IS CLASSIFIED AS A MINOR REPAIR.SDR 08FDEA04268Door Frame · crackedMAIN ENTRY DOOR 1L CUTOUT, AFT FRAME, BS 344, STR 15L JUST BELOW 2ND STOP FITTING FROM BOTTOM, FRAME CRACKED FABRICATED REPAIR PARTS PER DWG 65-17685-24, -9, -7. REPLACED LWR AFT FRAME REF SRM 51-30-2. THIS IS CLASSIFIED AS A MAJOR REPAIR.SDR FDEA200810074256Crease Beam · damagedMAIN CABIN CREASE BEAM, INB CHORD BS 755-BS 865 HEAVE SEVERAL TOOLING MARKS. REMOVED AND REPLACED CREASE BEAM STA 755-865 IAW SRM 51-40-01,53-30-13 AND 51-20-01 MAJOR REPAIR NO FOLLOW-UP REQUIRED.SDR 08FDEA04256Crease Beam · damagedMAIN CABIN CREASE BEAM, BS 755-BS 865 HAS SEVERAL TOOLING MARKS. REMOVED AND REPLACED CREASE BEAM STA. 755-865 IAW SRM 51-40-01, 53-30-13, AND 51-20-01 MAJOR REPAIR NO FOLOW-UP REQUIRED.SDR FDEA200810064248Crease Beam · corrodedCREASE BEAM ANGLE FITTING ATTACHMENT AND CHORD HAS CORROSION AT S-17R, BS 520-540. REMOVED AND REPLACED CREASE BEAM ANGLES, 2EA, ANGLE SPLICES, 4EA, AND O/B CHORD IAW MAE TRAVELERS T8/760009, T8/760007, T8/760010 AND EA F-5310-110929, REV-, DATED 10/03/08.SDR SWAA085413Crease Beam · corrodedDURING SCHEDULED 18Y CHECK, FOUND LT CREASE BEAM CORRODED BETWEEN BS 312 TO BS 344. REMOVED AND REPLACED BEAM PER SRM.SDR 08FDEA04248Crease Beam · corrodedCREASE BEAM ANGLE FITTING ATTACHMENT AND CHORD HAS CORROSION AT S17R, BS 520-540. REMOVED AND REPLACED CREASE BEAM ANGLES, ANGLE SPLICES, AND O/B CHORD IAW MAE TRAVELERS T8/760009, T8/760007, T8/760010 AND EA F-5310-110929. THIS REPAIR IS CLASSIFIED AS A CATEGSDR 2008UALA06009Door Frame · crackedFWD RIGHT GALLEY DOOR OPENING CRACKED AT AFT LOWER CORNER. INSTALLED DOUBLER REPAIR AT AFT LWR CORNER OF FWD RT GALLEY DOOR OPENING.SDR 2008UALA06002Door Frame · crackedDOOR 1R CUTOUT HAS A 2 INCH CRACK THRU FASTENER AT LOWER AFT CORNER. INSTALLED DOUBLER REPAIR.
SDR FDEA200810034196Crease Beam · corrodedCREASE BEAM WEB FROM STA 600-620 RBL 65 HAS CORROSION ON UPPER SURFACE. R & R WEB AND ANGLE, BS 600-620, RBL 65, TRAVELER T8/761895 AND T8/758987 IAW SRM 51-40-02 DWG 143N5520. THIS IS CLASSIFIED AS A CATEGORY "A" MAJOR REPAIR.SDR FDEA200810034192Crease Beam · corrodedCREASE BEAM RT SIDE HAS SCRIBE MARKS AND CORRODED, FR 900-1040. R & R CREASE BEAM INBD CHORD, BS 900-1040, RBL 58, IAW SRM 51-40-02.SDR FDEA200810034191Crease Beam · corrodedLT SIDE INBD CREASE BEAM CHORD STA 1300- STA 1320, LBL 58, HAS CORROSION. R & R CREASE BEAM INBD CHORD, BS 1300-1380, LBL 58, IAW SRM 51-40-02. FABRICATED ON MAE TRAVELER T8/759465. THIS IS A CATEGORY "A" MAJOR REPAIR.SDR FDEA200810034190Crease Beam · corrodedFR-1020, CREASE BEAM WEB CORRODED, FWD SIDE OF FR-1020. R & R WEB AND ANGLE, BS 1020, RBL 65, IAW SRM 51-40-02. REPAIR PARTS FABRICATED ON MAE TRAVELERS T8/759254, T8/760846. THIS REPAIR IS CLASSIFIED AS A CATEGORY "A" MAJOR REPAIR.SDR FDEA200810034189Crease Beam · corrodedBS 900-920 RT SIDE FOUND CREASE BEAM WEB CORRODED. R & R WEB AND FLANGED DOUBLER, BS 900-920, RBL 62-65, IAW SRM 51-40-02. REPAIR PARTS FABRICATED ON MAE TRAVELERS T8/761489 AND T8/761490. THIS REPAIR IS CLASSIFIED AS A CATEGORY "A" MAJOR REPAIR.SDR FDEA200810034182Crease Beam · corrodedMAIN CABIN, STA 1620-1640, RT SIDE INBD CREASE BEAM CHORD HAS CORROSION. REMOVED CORROSION AND CHECK LIMITS, FOUND TO BE OUT OF LIMITS IAW SRM 53-60-03 FIG 101 DETAIL III. REMOVED CREASE BEAM INBD CHORD, FABRICATED CREASE BEAM INBD CHORD IAW SRM 51-10-02 SEC
Back to JASC 5310