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 DALA1216386304Door Frame · crackedDURING HFEC OPEN HOLE INSP ON AFT CARGO DOOR CUTOUT UPPER FWD CORNER, HOLES NR 2 AND NR 4 FOUND WITH CRACK INDICATION.
WORK CARRIED OUT AS PER PRI 501579-14 REV 0 AND PRI 501579-14 REV 1 FOUND IN COMPLIANCE WITH ER/A 501579-14, JOB COMPLETED.
SDR SIMA20120306005Crossbeam · crackedDURING MAINTENANCE INSPECTION FOUND THE INTERIOR CROSSBEAM FS 280.00 HAS CORROSION, WITH A 1 INCH CRACK ON RIGHT SIDE OD DIP TRAY. THE AIRCRAFT WAS REMOVED FROM SERVICE. REPAIRED CROSSBEAM IAW CRJ STRUCTURAL REPAIR MANUAL 51-42-06 AND 51-42-21. THE AIRCRAFT SDR SWAA2012032602540Door Frame · crackedCARGO DOOR CUTOUT UPPER WEB HAS CRACK ON FWD O/B CORNER. REPAIR SKIN IAW SRM & AMM.SDR UIEA2012042000153Tension Tie · crackedBS 1180 RT TENSION TIE AREA FOUND CRACKED AT FRAME. REPAIRED IAW EO 4453A197 AND SB 747-53A2507 FIG 11, OVERSIZE HOLE REPAIR.SDR IPXA2572537Structure · damagedINSPECTION TYPE: C, MAIN CARGO COMPARTMENT FLOOR AREA, BS 1692, LBL 18. CORROSION BLENDED BEYOND LIMITS. BLENDED CORROSION ORIG "T" .073 REMOVED .012, REMAINING .061. RESTORED FINISH IAW EA 120360 IR AND EO B757-5310-46393-A.SDR IPXA2572536Structure · damagedINSPECTION TYPE: C, MAIN CARGO COMPARTMENT FLOOR AREA, BS 1681 LBL 5. CORROSION BLENDED BEYOND LIMITS. BLENDED CORROSION ORIG "T" .073 REMOVED N .008, REMAINING .065. RESTORED FINISH IAW EA 120360 IR AND EO B757-5310-46393-A.SDR SWAA2012032602534Door Frame · crackedAFT CARGO DOOR CUTOUT FORWARD FRAME CRACKED AT BS 794, STR 23R. REMOVED AND REPLACED FRAME IAW SRM AND DWG.SDR FDEA201203140939Crease Beam · corrodedMAIN CABIN LEFT BS 395 - 377, S17L CREASE BEAM CORRODED.SDR 2012FA0000274Arm · wornUPON RT CABIN FLOOR PANEL REMOVAL (162ET) IT WAS OBSERVED THAT THERE WAS SOME FRETTING MATERIAL ON THE INSULATION BAGS AND THE SURROUNDING AREA. FURTHER INVESTIGATION REVEALED THAT THE RT (PN 6964000-16) AND LEFT (PN 6964000-15) ARMS THAT CONNECT THE BRAKE MESDR 2012FA0000273Arm · wornUPON RT CABIN FLOOR PANEL REMOVAL (162ET) IT WAS OBSERVED THAT THERE WAS SOME FRETTING MATERIAL ON THE INSULATION BAGS AND THE SURROUNDING AREA. FURTHER INVESTIGATION REVEALED THAT THE RT (PN 6964000-16) AND LEFT (PN 6964000-15) ARMS THAT CONNECT THE BRAKE MESDR SWAA2012031902379Crease Beam · corrodedLT CREASE BEAM INNER CHORD CORRODED AT BS 312 TO STA 344. REMOVED AND REPLACED BEAM IAW SRM & DWG.SDR USAA2012031900014Stop Fitting · crackedC4 CHECK - 1 INCH CRACKS ON LEFT FORWARD EMERGENCY EXIT CUTOUT, FORWARD UPPER & LOWER STOP PAD (BEARING PLATE). REPLACED LEFT FORWARD EMERGENCY EXIT CUTOUT, FORWARD UPPER & LOWER STOP PAD (BEARING PLATE) IAW BOEING DRAWING 69-37977 FLAGNOTE 3.SDR USAA2012031900013Stop Fitting · crackedC4 CHECK - 1 INCH CRACKS ON LEFT FORWARD EMERGENCY EXIT CUTOUT, FORWARD UPPER, AFT UPPER & AFT LOWER STOP PAD (BEARING PLATE). REPLACED LEFT FORWARD EMERGENCY EXIT CUTOUT, FORWARD UPPER, AFT UPPER & AFT LOWER STOP PAD (BEARING PLATE) IAW BOEING DRAWING 69-379SDR USAA2012031900012Stop Fitting · brokenC4 CHECK - LEFT FORWARD EMERGENCY EXIT CUTOUT, FORWARD LOWER STOP PAD BROKEN OFF (BEARING PLATE). REPLACED LEFT FORWARD EMERGENCY EXIT CUTOUT, FORWARD LOWER STOP PAD BROKEN OFF (BEARING PLATE) IAW BOEING DRAWING 69-37977 FLAGNOTE 3.SDR USAA2012031900011Stop Fitting · crackedC4 CHECK - 1.0 INCH LONG CRACKED AT RIGHT AFT EMERGENCY EXIT CUTOUT, FORWARD UPPER & LOWER STOP PADS & AFT LOWER STOP PAD (BEARING PLATE). REPLACED AFT EMERGENCY EXIT CUTOUT STOP PAD (BEARING PLATES) IAW BOEING DRAWING 69-37699 FLAGNOTE 3.SDR SWAA2012031602277Crease Beam · corrodedRT CREASE BEAM WEB CORRODED AT BS 957 TO BS 992. REPAIRED CREASE BEAM PER SRM.SDR FDEA201203100876Crease Beam · corrodedMAIN CABIN LT SIDE BETWEEN BS333.45 TO BS310.5 CREASE BEAM CORRODED. REMOVED CORROSION IAW SRM 51-10-02, MAT LOSS .002, ORIG MAT .071, AFTER BLEND .069, FOUND TO BE WITHIN LIMITS IAW SRM 53-30-13, FIG.101, PAGE 105.SDR FDEA201203100875Crease Beam · corrodedMAIN CABIN LT SIDE BS 418-395 CREASE BEAM CORRODED.SDR FXGA201203091220Doubler · crackedCABIN HEATER EXHAUST DOUBLER BS 572 HAS TWO CRACKS. FABRICATE TWO INSERTS & AN EXTERNAL DOUBLER.SDR ASOA201200859Structure · corrodedFUSELAGE AT FS 265 BETWEEN STR 26 -27R IS CORRODED. REPAIRED IAW REO 670-53-11-688.SDR V0XR201203090002Mount · damagedRIVETS PULLED THROUGH ON ELEVATOR HORN HEAT MX SWITCH BRACKET IN AFT ACCESS DOOR. REPAIRED CONDENSOR MIXER MOUNTING STRUCTURE AND ELEVATOR HORN HEAT MX SWITCH BRACKET IAW RD 8-55-2394, PERMANENT REPAIR INSTRUCTION FOR DAMAGED HOLES IN CONDENSOR MIXER MOUNTINGSDR ASOA201200853Crossbeam · corrodedCROSSBEAM HAS CORROSION. REPAIRED IAW REO 670-53-11-047.SDR FDEA201203080827Crossbeam · crackedFWD CARGO COMPARTMENT FRAME 31 BETWEEN SEAT TRACKS 4L AND 5L UPPER STIFFENER HAS APPROX .380" REPAIRED CROSSBEAM AT FR 31 LT SIDE BETWEEN STA Y1959 & Y1456 IAW SRM 53-10-15, FIG 212, SHEET 1.SDR UIEA2012042000152Beam · crackedLT MLG INBD WW DOOR AFT EDGE BEAM CORROSION CRACKED. LT MLG INBD WW DOOR 65B10919-35, REPLACED IAW SRM 51-10-02.SDR SIMA20120307007Beam · corrodedDURING B-INSPECTION FOUND THE LAV CENTER BEAM GUSSETT CORRODED & THE LAV LEFT BEAM GUSSETT CORRODED. THE AIRCRAFT WAS REMOVED FROM SERVICE. REMOVED AND REPLACED NEW LAV CENTER BEAM GUSSETT IAW SRM 51-40-02, AND NEW LAV LEFT BEAM GUSSETT IAW SRM 51-40-02. TSDR FDEA201203070799Failsafe · corrodedDURING VISUAL INSPECTION OF LT FWD CREW/COURIER DOOR AT LWR AFT CORNER RADIUS FAILSAFE RING, 1 SQ IN PITTED CORROSION FOUND. AFT CORNER FITING FOUND TO BE OUT OF LIMITS IAW DWG A53611556. R & R FITTING IAW SRM 51-40-21.SDR FOTR0312201226588Door Frame · corrodedMULTIPLE AREAS OF CORROSION ALONG C1 DOOR FRAME (LOWER).SDR AALA20120306009Door Frame · corrodedAFT CARGO DOOR JAMB UPPER WEB HAS CORROSION SEVERAL PLACES BETWEEN STATIONS 1155 TO 1212. INSTALLED FASTENERS PER SRM 51-30-05 AND SRM 51-30-02.SDR AALA20120306003Door Frame · corrodedAFT CARGO DOOR JAMB UPPER WEB HAS CORROSION SEVERAL PLACES BTWN STATIONS 1155 TO 1212. REPLACED WEB PER AARD 51-10-00-5.SDR K11A2012060816009Door Frame · corrodedAFT EMERGENCY DOOR CUTOUT LT LOWER CORNER STRUCTURE CORRODED (1 INCH).SDR SWAA2012030601945Crease Beam · crackedCREASE BEAM INNER CHORD CRACKED AT BS 616, RBL 60. REMOVED AND REPLACED CHORD IAW SRM.SDR UALA2012030501324Crease Beam · corrodedCREASE BEAM WEB HAS CORROSION RT SIDE BS-960. MAJOR REPAIR ACCOMPLISHED PER ECRA 5310-05463 ON SCAL LP# 9961379.SDR UALA2012030501323Crease Beam · corrodedCABIN, CREASE BEAM WEB BETWEEN STA 1400-1420 RT SIDE HAS CORROSION AT TOP SURFACE. MAJOR REPAIR ACCOMPLISHED. REPAIRED CREASE BEAM PER ECRA 5310-05463 DURING SCAL HMV ON LOG PAGE 9961173.SDR SWAA2012032602577Crease Beam · corrodedLEFT CREASE BEAM WEB CORRODED BETWEEN BS 727E TO BS 747. REPAIRED WEB PER SRM.SDR SWAA2012032602576Crease Beam · corrodedLEFT CREASE BEAM WEB CORRODED BETWEEN BS 807 TO BS 827. REPAIRED WEB PER SRM.SDR SWAA2012032602575Crease Beam · corrodedLEFT CREASE BEAM WEB CORRODED BETWEEN BS 500 TO BS 500A. REPAIRED WEB PER SRM.SDR SWAA2012032202484Crease Beam · corrodedRT CREASE BEAM WEB CORRODED BETWEEN BS 420 TO BS 440. REMOVED AND REPLACED WEB IAW SRM.SDR SWAA2012032202483Crease Beam · corrodedRT CREASE BEAM WEB CORRODED BETWEEN BS 400 TO BS 420. REMOVED AND REPLACED WEB PER SRM & DWG.SDR SWAA2012031902312Crease Beam · corrodedCREASE BEAM WEB CORRODED BETWEEN BS 500A TO BS 500B. REMOVED AND REPLACED WEB IAW SRM.SDR SWAA2012031602276Crease Beam · corrodedRT CREASE BEAM WEB CORRODED AT BS 500 TO BS 500A. REPAIRED CREASE BEAM PER SRM.SDR SWAA2012030902049Crease Beam · corrodedCREASE BEAM INNER CHORD CORRODED BETWEEN BS 368 TO BS 371, LBL 61. REPAIRED CHORD IAW SRM & AMM.SDR SWAA2012030902027Crease Beam · corrodedRT CREASE BEAM INNER CHORD CORRODED AT BS 728.5, RBL 63. REPAIRED CHORD IAW ER AND EA.SDR SWAA2012030902026Crease Beam · corrodedRT CREASE BEAM INNER CHORD CORRODED AT BS 724.5, RBL 63. REPAIRED CHORD IAW ER AND EA.SDR SWAA2012030902025Crease Beam · corrodedRT CREASE BEAM INNER CHORD CORRODED AT BS 722, RBL 63. REPAIRED CHORD IAW EA AND ER.SDR SWAA2012030902024Crease Beam · corrodedRT CRASE BEAM INNER CHORD CORRODED AT BS 719.7, RBL 63. REPAIRED CHORD IAW ER AND EA.SDR SWAA2012030902023Crease Beam · corrodedRT CREASE BEAM INNER CHORD CORRODED AT BS 712.8, RBL 63. REPAIRED CHORD IAW ER AND EA.SDR SWAA2012030902022Crease Beam · corrodedRT CREASE BEAM INNER CHORD CORRODED AT BS 710.4, RBL 63. REPAIRED CHORD IAW ER AND EA.SDR DALA1212609202Door Frame · corrodedAFT PRESSURE BULKHEAD DOOR JAMB AT LT AND RT LWR SIDE WITH CORROSION. REMOVED LT AND RT LOWER DOOR JAMB CHANNELS AND LOWER DOOR JAMB FOUND WITH TOTAL MATERIAL LOSS. CUT AND REMOVED AFT PASS DOOR JAMB FRAME IN REF WITH MD90 SRM 53-60-02 FIG 3. DRILLED AND INSDR SCNA20120423003Window Frame · crackedDURING MAINTENANCE INSPECTION, FOUND R3 WINDOW FRAME CRACKED AT FWD LWR FASTENER HOLE. REMOVED CRACKED R3 WINDOW FRAME. INSTALLED NEW R3 WINDOW FRAME.SDR SCNA20120423002Window Frame · crackedDURING MAINTENANCE INSPECTION, FOUND L3 WINDOW FRAME CRACKED AT FWD LWR FASTENER HOLE. REMOVED L3 WINDOW FRAME. INSTALLED NEW L3 WINDOW FRAME.
Back to JASC 5310