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 SWAA2013110421828Crease Beam · corrodedCREASE BEAM INNER CHORD CORRODED BETWEEN BS 710 TO BS 713, RBL 65. REPAIRED CHORD IAW ER & EA.SDR SWAA2013110421827Crease Beam · corrodedCREASE BEAM WEB LOWER SURFACE CORRODED BETWEEN BS 710 TO BS 712, RBL 65. REPAIRED WEB IAW ER & EA.SDR SWAA2013110421811Crease Beam · corrodedLT CREASE BEAM INNER CHORD CORRODED BETWEEN BS 706 TO BS 727. REPAIRED CHORD IAW ER & EA.SDR SWAA2013102821594Crease Beam · corrodedCREASE BEAM WEB CORRODED BETWEEN BS 400 TO BS 420, STRINGER 17L. R & R WEB IAW SRM & DRAWING.SDR REXA2013101402067Structure · gougedGOUGE AT BS 913-927, STR 27. REPAIRED GOUGE DAMAGE IAW EO R53508.SDR DALA13052650955Structure · corrodedDURING SCHEDULED CHECK, CORROSION WAS FOUND ON PREVIOUS REPAIR DOUBLERS BETWEEN BS 731 & 750 IN THE CABIN FLOOR STRUCTURE. DOUBLERS WERE REMOVED AND NEW REPAIR DOUBLERS INSTALLED IAW SRM 53-05, FIGURE 131A.SDR ASOA2013103009306Doubler · corrodedAIRFRAME THE DOUBLER FS 319.7 - 349.00 CORRODED. REMOVED CORROSION IAW SRM 51-21-06.SDR SWAA2013102821458Window Frame · crackedLT NR 1 WINDOW FRAME CRACKED AT EXISTING FASTENER HOLE. R & R FRAME IAW ACO.SDR FDEA201310132484Angle · corrodedRT CREASE BEAM INBD ANGLE BS 1320 -1340 FOUND CORRODED AROUND FASTENER HOLES. REMOVED AND REPLACED IAW DWG 146N8322 SHT.1 REV.F. REPAIR IS MAJOR.SDR ASOA2013103009304Crossbeam · corrodedCROSSBEAM AT FS 349 CORRODED. REMOVED CORROSION IAW SRM 51-21-06 CORROSION, FOUND TO BE OUT OF LIMITS IAW SRM TR 53-27, FIG 102.SDR ASOA2013111109392Door Frame · corrodedLEFT INBD SIDE OF COCKPIT DOOR CUTOUT AT FRAME 279 CORRODED. REPAIRED CORRODED AREA IAW REO 670-53-11-745.SDR SWAA2013102821457Window Frame · crackedRT NR 1 COCKPIT WINDOW FRAME CRACKED IN UPPER OTBD CORNER AT WINDOW CUTOUT. R & R FRAME IAW ACO.SDR A6WA201310114293Drag Angle · crackedRIGHT DRAG ANGLE AT BATTERY RIB IS CRACKED. REMOVED RT DRAG ANGLE SHOWING CRACKED AFTER FURTHER EVALUATION, NO CRACK NDTM 51-20-06. THERE WAS SLITE CORROSION BOTH FWD & AFT ENDS BLENDED 1 EA RT DRAG ANGLE IAW SRM 51-12-00 ORIG MAT .100. REMOVED .005 REMAINISDR USAA2013111400014Failsafe · corrodedDURING C4 CHECK, CORROSION WAS FOUND ON AFT CARGO FAIL SAFE AT BS 1280, S17L. REPLACED FAIL SAFE IAW EA 105238.SDR CALA2013101091934Failsafe · crackedFAILSAFE CRACKED AT TENSION TIE BS 1140 RT. CUTOUT DAMAGED SECTION OF FAILSAFE IAW AMM 53-10-99 AND SRM 53-40-07 REPAIR 2. HFEC INSPECTION IAW NDT PT 6, 51-00-OO, NO CRACK INDICATION. FABRICATED REPAIR PARTS & INSTALLED IAW AMM 53-10-99 & SRM 53-40-07.SDR SWAA2013102821576Window Frame · crackedLT NR 1 WINDOW FRAME ASSEMBLY CRACKED. R & R FRAME ASSEMBLY IAW ACO.SDR DALA13052450956Former · corrodedCORROSION ON FORMERS BS 1380 BETWEEN X=12. CORROSION REMOVED WAS BEYOND ACCEPTABLE LIMITS AND REPAIR DOUBLERS WERE FABRICATED AND INSTALLED IAW SRM 51-70-5, FIG 1.SDR SWAA2013111822516Window Frame · crackedLT NR 1 WINDOW FRAME AT UPPER CORNER CRACKED. REPAIRED FRAME IAW EA.SDR SWAA2013102821575Window Frame · crackedRT NR 1 WINDOW FRAME CRACKED AT INSIDE UPPER OTBD CORNER. R & R FRAME ASSEMBLY IAW ACO.SDR SWAA2013102821567Window Frame · crackedLT HAND NR 3 WINDOW FRAME CRACKED AT E-F POST 2ND FASTENER FROM BOTTOM. REPAIRED FRAME IAW ACO.SDR HALA2013100900144Crease Beam · corrodedCORROSION FOUND ON CREASE BEAM TRUSS BS 619, STR. 20L. REPLACED , IAW SRM 51-40-02-0G-0, 51-40-05, 53-30-51-1A-1 AND DWG 143T5200.SDR A6WA201310094261Fitting · crackedRT WINDSHIELD SIDE POST LOWER OTBD FITTING IS CRACKED. REPLACED FITTING IAW SRM.SDR A6WA201310094246Vertical Beam · crackedVERTICAL BEAM AT LBL27, FS 409+128 CRACKED AT BOTTOM. COMPLIED WITH REO 601R-53-41-056, REV E.SDR DALA13051430955Door Frame · crackedCRACK ON INTERNAL DOUBLER AT THE LOWER AFT DOOR FRAME CORNER, BS 423.5 BETWEEN LONGERONS 27-28R AT THE FWD CARGO BAY. FASTENERS WERE REMOVED AND DAMAGE REMOVED IAW SRM 51-30-2 AND 51-30-5 AND 53-05, FIG 105. DOUBLERS AND FILLERS WERE FABRICATED IAW SRM 53-05SDR SWAA2013102921669Window Frame · crackedLT NR 3 WINDOW, E-F POST, 2ND & 3RD HOLES FROM BOTTOM CRACKED. R & R FRAME IAW EA.SDR SIMA20131008008Door Frame · corrodedCARGO DOOR FWD FRAME CORRODED AT FOUR NUTPLATES. REPAIRED IAW EO-EM-52MR-379.SDR DALA13051963762Crease Beam · crackedDURING INSPECTION, FOUND CABIN 1R DOOR CUT OUT LOWER SILL CREASE BEAM INBD CHORD OTBD CLIP IS CRACKED BS 296, STR 17R. MX R & R CLIP FRAME AT CABIN 1R DOOR CUT OUT LOWER SILL CREASE BEAM INBD CHORD, OTBD CLIP AND FRAME AT BS 296 IAW SRM 51-40-02, FIG 8 & 51-4SDR C77A20131009005Seal Depressor · corrodedFWD CARGO DOOR CUTOUT STRUCTURE AFT LOWER CORNER SEAL DEPRESSOR HAS CORROSION. REPAIRED IAW EO E175-53MR-108.SDR C77A20131009004Seal Depressor · corrodedFWD CARGO DOOR CUTOUT STRUCTURE CENTER LOWER SEAL DEPRESSOR HAS CORROSION IN MULTIPLE LOCATIONS. REPAIRED IAW EO E175-53MR-108.SDR C77A20131009003Seal Depressor · corrodedFWD CARGO DOOR CUTOUT STRUCTURE FWD LOWER CORNER SEAL DEPRESSOR HAS CORROSION. REPAIRED IAW EO E175-53MR-108.SDR UHLA2013100700508Beam · corrodedCORROSION FOUND ON RT BEAM AROUND FASTENER HEAD AND NUT PLATE. R & R RT SHEAR PLATE.SDR UHLA2013100700506Beam · corrodedCORROSION FOUND ON RT BEAM AROUND FASTENER HEAD AND NUT PLATE. R & R BEAM.SDR UHLA2013100700504Beam · corrodedCORROSION FOUND ON BEAM FRAME 87 AROUND RIVET HEAD. R & R BEAM.SDR UHLA2013100700502Splice · corrodedCORROSION FOUND ON RT SPLICE AT FRAME 90. R & R SPLICE.SDR UHLA2013100700497Gusset · corrodedCORROSION FOUND ON GUSSET PLATE FRAME 90 LT SIDE. R & R GUSSETT.SDR UHLA2013100700494Gusset · corrodedCORROSION FOUND ON GUSSET PLATE FRAME 90 RT SIDE. R & R GUSSETT.SDR DALA13052520980Structure · damagedTHE NLG RT SIDEWALL HAD DAMAGE FROM CONTACTING THE STEERING ACTUATOR. THE GOUGED AREA WAS BLENDED AND THE REMOVED MATERIAL EXCEEDED ALLOWABLE LIMITS. REPAIR ACCOMPLISHED IAW SRM 53-05, FIGURE 36 AND THE REQUIRED INSPECTION WAS COMPLETED.SDR DALA13051083762Crease Beam · corrodedDURING INSPECTION FOUND MAIN DECK R1 DOOR CREASE BEAM ZEE ANGLE, BS 324 -332 UPPER SURFACE HAS CORRODED. MX REPLACED FORWARD RT CREASE ZEE ANGLE IAW SRM 51-40-02.SDR DALA13049866309Door Frame · crackedMAIN CABIN DOOR CUTOUT FWD DOOR FRAME JUST BELOW S-17 FOUND CRACKED. CRACKED AREA CUTOUT AND REPAIRED IAW ERA 512578-14, REV ORIGINAL.SDR DALA13049856309Door Frame · crackedNR 5 MAIN CABIN DOOR CUT OUT FWD DOOR FRAME JUST BELOW S17L AREA FOUND CRACKED. CRACK CUTOUT AND REPAIRED IAW ERA 512578-14, REV ORIGINAL.SDR SWIA201335566Door Frame · corrodedFUSELAGE FRAME AT FS 349.00 IS CORRODED AT RT OTBD EDGE AT SERVICE DOOR CUTOUT. C-CHECK REPAIRED IAW SRM.SDR V0XR2013100800263Structure · damagedPASSENGER DOOR LOWER SURROUND STRUCTURE HAS TWO DAMAGED RIVETS ON THE FWD LOWER AND AFT LOWER CORNER CAPS. R & R RIVETS IAW SRM 51-42-10.SDR SWAA2013103121735Window Frame · crackedFLIGHT DECK LT NR 1 WINDOW FRAME UPPER LT CORNER CRACKED ON INSIDE SURFACE. REPAIRED FRAME IAW SRM & ACO.SDR USAA2013103000012Door Frame · crackedDURING 2S CHECK, A CRACK FOUND ON FRAME SEGMENT OF LT EMERGENCY EXIT DOOR 834 BETWEEN FRAMES 40 - 41 & BETWEEN BEAMS 1 TO 3. REPLACED FRAME IAW EO 5210Y228.SDR USAA2013103000011Door Frame · crackedDURING 2S CHECK, A CRACK FOUND ON FRAME SEGMENT OF RT EMERGENCY EXIT DOOR 844 BETWEEN FRAMES 40-41 & BETWEEN BEAM 1 TO BEAM 3. REPLACED FRAME IAW EO 5210Y228.SDR SWAA2013102821565Window Frame · crackedFLIGHT DECK RT NR 1 WINDOW FRAME UPPER RT CORNER CRACKED ON INSIDE SURFACE. R & R FRAME IAW ACO.SDR SWAA2013101121079Window Frame · crackedRT NR 3 FLIGHT DECK WINDOW FRAME E-F POST, THIRD FASTENER HOLE FROM BOTTOM CRACKED. REPAIRED FRAME IAW SWA ACO.SDR VNAA2013100513002Post · crackedDURING SCHEDULED MX THE FS 202.75 VERTICAL POST WAS CRACKED. THE AREA WAS INSPECTED AND REPAIRED USING AMM. ACFT WAS RELEASED FOR SERVICE.SDR AALA20131005004Stop Fitting · crackedFOUND CRACKED DOOR STOP FITTING ON RT SIDE, WL+36 OF VAULT DOOR JAMB. REPLACED DOOR STOP FITTING.SDR DALA13050573762Crease Beam · corrodedDURING INSPECTION, FOUND MAIN DECK L2 DOOR THRESHOLD AREA, LT CREASE BEAM UPPER FLANGE BS 967-986 UPPER AND LOWER SURFACES ARE CORRODED. MX R & R CREASE BEAM IAW SRM 51-40-02.
Back to JASC 5310