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 DALA14031149222Door Frame · corrodedC3 CARGO DOOR CUT OUT LOWER FORWARD CORNER BS 1212, FITTING CORRODED. REMOVED AND REPLACED FITTING IAW DWG 5936469.SDR DALA14031049213Structure · corrodedBS 1344-1364 S29-30L CORRODED. REMOVED CORROSION. FOUND TO BE OUT OF LIMITS. FABRICATED AND INSTALLED NEW SECTION IAW SRM 51-10-02 AND 53-10-01.SDR ASOA20140517076Beam · corrodedDURING C-CHECK THE LT WINDSHIELD LOWER FRONT CUTOUT BEAM WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED THE CORROSION AND PERFORMED BUSHING REPAIRS IAW EC5310-01782. THE ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR IPXA2014060683203Door Frame · cracked4C INSPECTION, L3 DOOR FRAME LOWER FWD LIGHTNING HOLE IS CRACKED. REPAIRED IAW SRM 53-40-15, FIG 201, REPAIR 3.SDR IPXA2014060683201Door Frame · cracked4C INSPECTION, R3 DOOR FRAME LOWER FWD LIGHTNING HOLE IS CRACKED. REPAIRED IAW SRM 53-40-15, FIG 201.SDR SWAA2014060228585Window Frame · crackedFLIGHT DECK NR 1 RT WINDOW FRAME CRACKED AT UPPER OTBD CORNER. REPAIRED FRAME IAW ACO.SDR IPXA2014053083115Door Frame · cracked4C INSPECTION, R3 DOOR FRAME LOWER AFT LIGHTNING HOLE CRACKED. REPAIRED IAW SRM 53-40-15, REPAIR 3, REV 55.SDR USAA2014052100010Crease Beam · corrodedC4 CHECK LEVEL 2 GALVANIC CORROSION ON CREASE BEAM WEB BETWEEN BS 310.5 TO BS 324, RBL 62. REPLACED CREASE BEAM WEB BETWEEN BS 310.5 TO BS 324, RBL 62 IAW SRM 51-40-02, 51-20-01, 51-40-05 & AMM 51-21-10.SDR DALA14031099222Fitting · unknownC3 DOOR CORNER FITTING LOWER AFT BS 1268 OUTBOARD OF L28R. REMOVED AND REPLACED FITTING IAW DWG 5936469.SDR 7AHR201405162458Structure · crackedCRACK AT BS 1497, S12L INTERNAL STRUCTURE. REMOVED CRACKED REPAIR DOUBLER, FABRICATED NEW REPAIR DOUBLER AND INSTALLED IAW SRM 51-30-0, 51-10-2.SDR MTNA20140518012Crease Beam · corrodedFOUND CREASE BEAM PN S53373000226 CORRODED OUT OF LIMITS. REPLACED WEB IAW SRM.SDR MTNA20140518011Crease Beam · corrodedFOUND CREASE BEAM WEB PN S53374000204 CORRODED OUT OF LIMITS. REPLACED WEB IAW SRM.SDR MTNA20140518010Crease Beam · corrodedFOUND CREASE BEAM WEB PN S53374000228 CORRODED BEYOND LIMITS. REPLACED WEB IAW SRM.SDR DALA14030589222Structure · crackedCATWALK EMERGENCY WALKWAY CRACKED AT BOTH FORWARD SIDES. FABRICATED AND INSTALLED DOUBLERS IAW SRM 53-00-02 AND ERA 489806-14MA.SDR SWAA2014052328313Forging · crackedRIGHT BS 887+10 WINDOW FRAME FORGING CRACKED AT HOLE NR 5. R & R FORGING IAW BAC.SDR CALA2014051500596Pressure Deck · corrodedAFT GALLEY PRESS DECK HAS CORROSION FROM BL0 TO APPROXIMATELY LBL 37 STATION 1720. REMOVED CORROSION ON AFT GALLEY PRESS DECK FROM BL0 TO APPROXIMATELY LBL 37 STATION 1720. INSTALLED REPAIR DOUBLER IAW ERRA 5310 -06079. SEE WIP ENTRIES FOR WORK ACCOMPLISHEDSDR CALA2014051500595Pressure Deck · corrodedAFT DECK HAS CORROSION FROM BL0 TO APPROXIMATELY RBL 54 STATION 1720. REMOVED CORROSION ON AFT GALLEY PRESS DECK FROM BL 0 TO APPROXIMATELY LBL 54 STATION 1720. INSTALLED REPAIR DOUBLER IAW ERRA 5310. SEE WIP ENTRIES FOR WORK ACCOMPLISHED.SDR SWIA201437837Window Frame · crackedPOSSIBLE CRACK ON WINDSHIELD CENTER POST LEFT LOWER ANGLE FITTING. C-CHECK, REPLACED POST IAW SRM.SDR SWAA2014052328312Forging · crackedRIGHT BS 727B+10 WINDOW FRAME FORGING CRACKED AT HOLE 7. R & R FORGING IAW DWG.SDR SWAA2014052328311Forging · crackedRIGHT BS 807+10 WINDOW FRAME FORGING CRACKED AT HOLE NR 11. R & R FORGING IAW DWG.SDR DALA14030260965Door Frame · crackedUPPER FUSELAGE, INTGERNAL AREA, L1 DOOR BETWEEN BS 208 - 218, LONGERON 9L, WEB CRACKED ON AFT FRAME DOOR. TRIMMED OUT DAMAGE WEB IAW SRM 53-65 FIG 142. FABRICATED FILLER AND DOUBLER IAW SRM 53-05 FIG. 142. INSTALLED REPAIR IAW SRM 53-05 PARA 153 FIG. 143.SDR DALA14029619213Structure · gougedL1 DOOR GUST LOCK LATCH POINT ON BS 133 PANE IS GOUGED OVER PREVIOUS REPAIR. REMOVED, FABRICATED AND INSTALLED DOUBLER IAW SRM 51-30-02 AND ERA 38169-14.SDR SWAA2014060528712Door Frame · crackedL1 DOOR CUT OUT FRAME INNER CHORD CRACKED AT BS 348.2, STRINGER 15L. STOP FITTING CTR LINE, FWD ENTRY DOOR CUT OUT. REPAIRED CHORD IAW EA.SDR SWAA2014052828380Window Frame · crackedRIGHT NR 3 WINDOW FRAME E-F POST CRACKED IN NR 8 HOLE. REPAIRED POST IAW ACO.SDR SWAA2014052828379Window Frame · crackedLEFT NR 3 WINDOW FRAME E-F POST CRACKED IN NR 8 HOLE. REPAIRED POST IAW ACO.SDR FDEA201405120987Crease Beam · corrodedCORROSION FOUND ON THE CREASE BEAM INNER ANGLE BS 1040. REMOVED CORROSION IAW SRM 51-10-02, FOUND OUT OF LIMITS IAW SRM 53-40-13 FIG 101 DET. VII REMOVED AND REPLACED CREASE BEAM ANGLE IAW SRM 51-40-02 AND DWGS 144N5214 SHEET 1 AND 144N5200 SHEETS 2,3,4. MAJOSDR USAA2014051500008Crease Beam · corrodedC4 CHECK LEVEL 2 GALVANIC CORROSION ON INNER CHORD OF CREASE BEAM BETWEEN BS 1300 TO BS 1360, RBL 58.22. REPLACED CREASE BEAM BETWEEN BS 1300 TO BS 1360, RBL 58.22 IAW SRM 51-40-02.SDR RAIA201405120001Structure · corrodedLAVATORY CUP HAS LEVEL 2 CORROSION. MAINTENANCE REPLACED LAVATORY CUP.SDR DALA14033253262Structure · corrodedCORROSION AT FWD LOWER CORNER OF AFT LAVATORY SERVICE PAN, INSIDE AFT CARGO BIN AFT BULKHEAD. REPAIRED IAW ERA 525852-14, REV ORIG COMPLIED WITH PERMANENT REPAIR SECTION II OF AFT LAV SERVICE PAN DOUBLER AND STRINGER 38R IAW ERA 525852-14, REV B. SERVICE CHESDR SWAA2014060228569Crease Beam · corrodedCREASE BEAM WEB CORRODED BETWEEN BS 480 TO BS 500, STRINGER 17R. REPAIRED WEB IAW EA.SDR SWAA2014052928454Crease Beam · corrodedCREASE BEAM WEB CORRODED BETWEEN BS 400 TO BS 420, STRINGER 17R. REPAIRED WEB IAW EA.SDR QXEA2014051600421Door Frame · corrodedFWD PAX DOOR FWD FRAME STA 1.0 HAS TWO HOLES CORRODED INSIDE. REAMED HOLES TO SIZE IAW RD8/4-53-6146, ISSUE 1. MANUFACTURED BUSHINGS IAW RD8/4-53-6146 ISSUE 1 DATED 5/1/2014 FROM 17-4 S/S CONDITION H1150 PO TX00000975. PERFORMED ET INSP ON FWD PAX DOOR FWD FRSDR QXEA2014051600420Beam · corrodedTYPE II EMERGENCY EXIT BEAM ASSY, CORRODED. REMOVED BEAM, IAW SRM 51-42-05. INSTALLED BEAM IAW SRM 51-42-05.SDR QXEA2014051600419Door Frame · corrodedFWD PAX DOOR AFT FRAME AT STA 32.4 HAS 2 HOLES CORRODED INSIDE. REAMED HOLES TO SIZE IAW RD 8/4-53-6146, ISSUE 1. MANUFACTURED BUSHINGS IAW RD8/4-53-6146, ISSUE 1, FROM 17-4 S/S CONDITION H1150 PO TX00000975. PERFORMED E/T INSP ON FWD PAX DOOR AFT FRAME AT SSDR QXEA2014051600418Rib · corrodedFIVE RIBS COMMON TO INNER AND OUTER EDGE BEAMS AFT PAX DOOR CORRODED. REMOVED RIBS AS SRM 51-42-05. INSTALLED 4 NEW RIBS AT AFT PAX DOOR REF SRM 51-42-05. NEW RIB COMMON TO INNER AND OUTER EDGE BEAMS AFT PAX DOOR LOC'N INSTALLED AT X 684.00 REF SRM 51-42-05. CSDR SWAA2014062329319Window Frame · crackedRIGHT NR 3 WINDOW FRAME E - F POST CRACKED AT SECOND LOWEST HOLE. REPAIRED FRAME IAW ER & EA.SDR FDEA201405100973Crease Beam · crackedCABIN, STATION 996 - 1020 LT CREASE BEAM WEB CRACKED AT LIGHTING HOLE EDGE. EVALUATED CRACK & FOUND OUT OF LIMIT AS PER SRM 53-40-13 FIG 101 REV 111. CRACK CREASE BEAM WEB REMOVED AS PER SRM 51-40-02 REV 111. CREASE BEAM WEB FABRICATED & INSTALLED AS PER BOSDR DALA14029589213Structure · corrodedAFT ACCESSORY COMPARTMENT, LAVATORY SERVICE PANEL INTERIOR AREA CORRODED ALL AROUND. REMOVED CORROSION. FABRICATED AND INSTALLED NEW DOUBLER SUPPORT IAW DWG 5965767, REV I AND ERA 524969-14, REV O.SDR CALA2014051200580Crease Beam · corrodedB757-53-3-0479 STATION 301 RBL 64 CABIN FLOOR CREASE BEAM CORRODED. SDR FORM ATTACHED. R & R CABIN FLOOR CREASE BEAM ANGLE IAW DWG 141N8422 & SRM 51-40-02, AT RBL 64 & BETWEEN STATION 301 - 377. FORM 44-0008 PGS 1 & STEPS 6.SDR DALA14030159213Fitting · corrodedAFT CARGO BAY, CORROSION AT BS 1395 L27L. REMOVED CORROSION, FABRICATED AND INSTALLED NEW END FITTING IAW DWG 5936667, REV CD.SDR ASOA2014060210624Door Frame · corrodedDOOR FRAME BS 280, RT SIDE LOWER EDGE CORRODED. REMOVED CORROSION IAW SRM 51-21-001-001-A01. FOUND OUT OF LIMITS IAW SRM 53-00-00-99-803 AND COMPLIED WITH EC/TC REO 670-53-11-944.SDR IPXA2014052883089Fitting · crackedRT SIDE, FRAME 12A, FITTING IS CRACKED. REPAIRED FITTING IAW EO A300-5310-23539-G.SDR FDEA201405070955Crease Beam · corrodedBS 1180 - 1200 LT CREASE BEAM WEB CORRODED. CORROSION REMOVED IAW SRM 51-10-02 REV 111. FOUND OUT OF LIMITS IAW SRM 53-60-13. NEW CREASE BEAM WEB FABRICATED IAW DRAWING 146N5590 SHT 1 REV F. REMOVED & REPLACED IAW DRAWING 146N5590 SHT 1 REV F AND SRM 51SDR SWAA2014060328645Door Frame · crackedL1 DOOR FRAME OUTER CHORD CRACKED AT BS 348.2, STRINGER 16L. REPAIRED CHORD IAW EA.SDR SCNA20140527084Beam · corrodedBEAM JUST INBD OF R2 MOP SEAL HAS CORROSION BETWEEN BS 951-967. BLENDED CORROSION, FOUND TO BE OUT OF LIMITS. R & R BEAM.SDR SWAA2014051327891Window Frame · crackedRIGHT COCKPIT WINDOW UPPER C - D FRAME POST CRACKED. REPAIRED FRAME POST IAW SRM.SDR SWAA2014051327890Window Frame · crackedLEFT COCKPIT WINDOW UPPER C - D FRAME POST CRACKED. REPAIRED FRAME POST IAW SRM.SDR SWAA2014060228576Window Frame · crackedCOCKPIT RT NR 3 WINDOW FRAME E - F POST CRACKED AT UPPER FASTENER COMMON TO NR 2 WINDOW FRAME. R & R FRAME IAW DWG & SRM.SDR SWAA2014060228575Window Frame · crackedCOCKPIT LT NR 3 WINDOW FRAME E - F WINDOW POST CRACKED AT UPPER FASTENER, COMMON TO NR 2 WINDOW FRAME. R & R FRAME IAW DWG & SRM.SDR ASOA2014052710597Beam · corrodedBS 349.00 TRANSVERSE BEAM IS CORRODED OTBD OF RBL 27.00. REO 601R-53-21-2534 REV--HAS BEEN ACCOMPLISHED AND ALL STEPS HAVE BEEN DOCUMENTED AND SIGNED FOR ON A NRI WORK CARD. RII'S HAVE BEEN ACCOMPLISHED IAW GMM 3-3 PROCEDURES PRIOR TO THE ACFT BEING RETURNE
Back to JASC 5310