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 UHLA2014011900037Doubler · corrodedCORROSION FOUND ON WASTE BOX SKIN DOUBLER. R & R WASTE BOX SKIN DOUBLER.SDR SWAA2014020424847Window Frame · crackedRT NR 1 WINDOW FRAME CRACKED AT UPPER OTBD INNER CORNER. R & R FRAME IAW ACO.SDR IPXA2014020381744Doubler · crackedINSPECTION C, BS 400 LEFT SIDE NOSE WHEEL WELL AFT CORNER FOUND CRACKED AT SECOND LAYER FROM SURFACE TOWARD UP & DOWN WITH LENGTH APPROX 0.030" & 0.020". INTERNAL SPLICE PLATE IS REPLACED AND INSTALLED IAW SRM 51-10-02, REV.27 AND HX RI NO RI-53-11-10442 RESDR IPXA2014020381740Doubler · crackedINSPECTION C, BS 400 LT SIDE NOSE WHEEL WELL AFT CORNER FOUND CRACKED . REPAIRED BETWEEN BS 380 - 420, S43-47L IAW RI-53-11-10442, REV A AND EO-5330-53287-A.SDR UHLA2014011700036Structure · crackedCRACK COMING OUT OF AFT RIVET HOLE GOING FWD ON FWD LWR FLANGE OF RIB 12. REPAIRED LOWER FWD FLANGE OF RIB 12A CRACK L=.25" IAW ETD 2014-170-04836, REV A. MAJOR REPAIRSDR SWAA2014013124719Window Frame · crackedLT NR 3 WINDOW FWD FRAME E F POST CRACKED AT FASTENER HOLE AT 2ND LOWER HOLE. REPAIRED FRAME IAW ACO.SDR DALA1400223718Door Frame · damagedDAMAGE AROUND THE AFT E/E DOOR LATCH HOLE ON THE LOWER FRAME WEB AT BS 351.2 AND BL 0. DAMAGE CAUSED BY POSSIBLE IMPROPER RIGGING OF THE E/E DOOR THE DAMAGE WAS CUT OUT AND REPAIRED IAW SRM 51-70-13, REPAIR 1.SDR DALA14004526715Door Frame · crackedL1 DOOR FWD CUTOUT CRACKED AT BS 338 INBD FLANGE AT WL 255. TRIMED OUT DAMAGE, FABRICATED AND INSTALLED REPAIR STRAP IAW ER/A 520321-14, REV ORIGINAL.SDR DALA14004333769Crease Beam · corrodedDURING INSPECTION, FOUND AFT GALLEY WET AREA CREASE BEAM IS CORROED AT THE L-2 ENTRY DOOR. MAINTENANCE REPLACED CREASE BEAM WITH NEW IAW SRM 51-40-02 AND DWG 147A8501, REV C.SDR SWAA2014020424846Window Frame · crackedRT NR 3 WINDOW FRAME CRACKED BETWEEN THE 2ND & 3RD FASTENER HOLES FROM THE BOTTOM. REPAIRED FRAME IAW ACO.SDR SWAA2014020324800Window Frame · crackedLT NR 3 WINDOW FRAME CRACKED ON THE 2ND FASTENER HOLE FROM THE BOTTOM. REPAIRED FRAME IAW ACO.SDR SWAA2014013024716Window Frame · crackedLT NR 1 WINDOW FRAME CRACKED IN UPPER OTBD CORNER. REPAIRED FRAME IAW EA.SDR SWAA2014013024715Window Frame · crackedRT NR 1 WINDOW FRAME CRACKED IN UPPER OTBD CORNER. REPAIRED FRAME IAW EA.SDR SWAA2014012424497Window Frame · crackedNR 3 FLIGHT DECK WINDOW FRAME 2ND FROM BOTTOM NR 8 FASTENER HOLE CRACKED. REPAIRED FRAME IAW SI & ACO.SDR DALA14004323769Crease Beam · corrodedDURING INSPECTION, FOUND RT AFT SERVICE R2 DOOR, CREASE BEAM INNER ANGLE HAS CORROSION ON UPPER SURFACE. MAINTENANCE REPLACED CREASE BEAM WITH NEW, IAW DWG 147A8501, REV B, AND SRM 51-40-02.SDR SWAA2014020324820Doubler · crackedLT CABIN WINDOW FRAME DOUBLER NR 35 CRACKED AT LOWER AFT CORNER OF WINDOW PANE. REPAIRED DOUBLER IAW SRM & DRAWING.SDR SWAA2014013024704Window Frame · crackedFLIGHT DECK LT NR 1 WINDOW FRAME UPPER OTBD CORNER OF WINDOW PANE CUTOUT, FLIGHT DECK LT NR 1 WINDOW FRAME, UPPER OUTBOARD CORNER OF WINDOW PANE CUT OUT IN FRAME CRACKED. R & R FRAME IAW ACO.SDR SWAA2014012424496Window Frame · crackedNR 3 FLIGHT DECK WINDOW FRAME CRACKED AT FASTENER HOLE E - F POST IN NR 8 HOLE FROM TOP. REPAIRED FRAME IAW ACO.SDR GLBA2014011300367Door Frame · crackedDURING A SCHEDULED INSPECTION, FOUND A CRACK IN THE PAX DOOR CUTOUT LOWER FRAME AT APPROXIMATELY FS 172 LOWER AFT CORNER, 1 INCH IN LENGTH. REPAIRED IAW EO 13-1900-53-002.SDR SWAA2014020324816Doubler · crackedRT CABIN WINDOW FRAME DOUBLER NR 35 CRACKED AT LOWER AFT CORNER OF WINDOW PANE. REPAIRED DOUBLER IAW SRM & DRAWING.SDR SWAA2014020324815Doubler · crackedLT CABIN WINDOW FRAME DOUBLER NR 36 CRACKED AT UPPER FWD CORNER. REPAIRED DOUBLER IAW SRM & DRAWING.SDR CA140113013Tube · cracked(CAN) DURING A SCHEDULED 100 HR INSPECTION, THE FORWARD LT DIAGONAL TUBE OF THE FWD TUBULAR STRUCTURE WAS FOUND CRACKED DUE TO INTERNAL CORROSION. THE DAMAGED TUBE WAS CUT OUT AND THE STRUCTURE WAS REPAIRED TO RECTIFY THE DEFECT. THE REPAIRED AREA WAS PREPPESDR AALA20140110004Door Frame · damagedAFT SIDE OF STATION 37, LOWER JAMB DAMAGED. INSTALLED NEW JAMB IAW SRM 51-10-05.SDR AALA20140110003Door Frame · damagedSTATION 37 LOWER HALF SECTION OF JAMB DAMAGED. INSTALLED NEW JAMB IAW SRM 51-10-05.SDR 7AHR201410236Door Frame · damagedDURING A C CHECK THE AFT BULKHEAD DOOR JAMB, WAS NOTED WITH DAMAGE AT THE UPPER & LOWER DOOR LATCH POINTS. A 5 DOUBLER WAS INSTALLED IAW MD-80 SRM 53-05, FIG 69.SDR SWIA201436831Post · crackedWINDSHIELD CENTER POST LOWER LT AND RT POST FITTINGS ARE CRACKED. C-CHECK, REPLACED POST IAW SRM.SDR FDEA201401090075Door Frame · corrodedAFT CARGO DOOR CUT OUT FWD FRAME BS 1380, FRAME HAS CORROSION ON AFT WEB BETWEEN STRINGER 23 & 24R. REPAIRED IAW EA F-5310-T0305241 P1. REPAIR CLASSIFIED AS MAJOR.SDR ASAA2014010912460Door Frame · crackedFWD CARGO DOOR FORWARD FRAME IS CRACKED AT LOWER STOP FITTING, ACFT GROUNDED. R & R FWD CARGO DOOR CUT OUT FWD FRAME IAW SRM 51-40-02-0G-0-PAR-7D.SDR SWAA2014012024300Window Frame · crackedCABIN WINDOW 33 RT PANE FRAME AFT UPPER CORNER CRACKED BETWEEN BS 832 TO BS 851. REPAIRED FRAME IAW SRM & DRAWING.SDR SWAA2014012024299Window Frame · crackedCABIN WINDOW 34 RT PANE FRAME AFT LOWER CORNER CRACKED BETWEEN BS 851 TO BS 870. REPAIRED FRAME IAW SRM & DRAWING.SDR SWAA2014012024298Window Frame · crackedCABIN WINDOW 33 LT PANE FRAME AFT LOWER CORNER CRACKED BETWEEN BS 832 TO BS 851. REPAIRED FRAME IAW SRM & DRAWING.SDR SWAA2014012024297Window Frame · crackedCABIN WINDOW 34 LT PANE FRAME CORNER CUTOUT CRACKED BETWEEN BS 851 TO BS 870. REPAIRED FRAME IAW SRM & DRAWING.SDR SWAA2014012024296Window Frame · crackedCABIN WINDOW NR 36 LT PANE FRAME AFT LOWER CORNER CRACKED BETWEEN BS 889 TO BS 908. REPAIRED FRAME IAW SRM & DRAWING.SDR SWAA2014011424119Window Frame · crackedRT FLIGHT DECK WINDOW FRAME CRACKED. REPAIRED FRAME IAW SWA EA.SDR SCNA20140207016Window Frame · crackedLEFT NR 3 WINDOW FRAME HAS TWO CRACK INDICATIONS IN SECOND LOWER CORNER FASTENER HOLE. COMPLIED WITH NR 3 LEFT WINDOW FRAME REPAIR.SDR SCNA20140207015Window Frame · crackedRIGHT NR 3 WINDOW FRAME HAS TWO CRACK INDICATIONS IN SECOND LWR CORNER FASTENER HOLE. COMPLIED WITH NR 3 RT WINDOW FRAME REPAIR.SDR 39LA2014010848Door Frame · damagedPERFORM A PERMANENT REPAIR OF THE RT FWD EXIT DOOR FRAME. REPAIRED RT FWD EXIT DOOR FRAME IAW DASH 8 SRM 51-40-11 & RD 8-53-4940.SDR 39LA2014010844Door Frame · crackedPAX DOOR FRAME CRACKED AT THE UPPER FWD CORNER, INBD SIDE, JUST ABOVE STRINGER 9L. REPAIRED PAX DOOR FRAME CRACK AT UPPER FWD CORNER IAW BOMBARDIER REPAIR DRAWING 8-53-13454 REV 3.SDR SWAA2014020324810Door Frame · corrodedRT JAMB CORRODED BETWEEN BS 370 TO BS 427. REPAIRED JAMB IAW SRM.SDR DALA14001863768Crease Beam · corrodedDURING INSPECTION, FOUND AFT WET AREA, BS 957- 990, RBL 45 - 52, CREASE BEAM INNER ANGLE IS CORRODED. REMOVED AND REPLACED IAW SRM 51-40-02 AND DWG 14TA8501, REV C.SDR DALA2016102807865Door Frame · corrodedMID CARGO DOOR OPENING LOWER FRAME CORRODED. REPAIR IAW SRM 53-05 FIG 123.SDR SWAA2014011324011Window Frame · crackedLT NR 3 FLIGHT DECK WINDOW FRAME EF POST SECOND LOWER FASTENER HOLE CRACKED. REPAIRED FRAME ASSEMBLY IAW ACO.SDR SWAA2014012824621Door Frame · corrodedAFT CARGO DOOR JAMB LOWER AREA CORRODED BETWEEN BS 994 TO BS 1022 LONGERON 28R. R & R JAMB IAW SRM.SDR ASOA20140106002Beam · corrodedCARGO DOOR CUTOUT THRESHOLD BEAM CORRODED BEYOND LIMITS AFTER BLEND-OUT. R & R THRESHOLD BEAM.SDR SWAA2014012724580Door Frame · corrodedAFT CARGO DOOR JAMB LOWER AREA CORRODED. REPAIRED JAMB IAW SRM.SDR DALA14000995642Door Frame · crackedR2 DOOR , CRACKED IN FRAME SKIN AT UPPER HINGE CUT OUT. REPAIRED AREA IAW SRM 51-20-01, PG. 1-8 AND 52-10-02, FIG 7, DETAIL 3 , PG 207.SDR SWAA2015010735520Window Frame · crackedLEFT NR 1 WINDOW FRAME CRACKED. REPAIRED FRAME IAW ACO & EA.SDR FDEA201401020003Crossbeam · crackedAVIONICS COMPARTMENT, CROSSBEAM NLG FRAME 15A WEB FACE AT ATTACHMENT FITTING OF RACK 107VU FOUND CRACKED. DRILLED FASTENER HOLES TO ALL THE REPAIR PARTS PER A300-600F SRM51-40-40 APPLIED PAINT PER A300-600F SRM51-75-21 INSTALLED REPAIR PARTS PER A300-600FSDR SWAA2014012024339Crease Beam · corrodedCREASE BEAM CORRODED BETWEEN BS 685 TO BS 727 LBL 55. REPAIRED CHORD IAW ER & EA.SDR WX0A071808Beam · corrodedAFT CARGO DOOR CUTOUT LOWER JAMB BEAM CORRODED. REMOVED CORROSION & CUTOUT SMALL SECTION AT AFT DOOR STOP ON BEAM. FABRICATED REPAIR DOUBLER & REPAIR PARTS, LOCATED, DRILLED & INSTALLED PERMANENT REPAIR IAW MD80 SRM 53-05 FIGURE 123A OPTION 2
Back to JASC 5310