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 UPS01437275Web · crackedINSPECTION TYPE:C R/H SIDE NWW AT BS 320 VERTICAL BEAM WEB FASTENER 1EA COMMON TO THE INNER CHORD CRACKED JUST BETWEEN #5 AND #6 STIFFENER ( COUNTED FROM TOP ) AS MARKED. R/H NOSE WHEEL WELL BS 320 VERTICAL BEAM WEB REPLACED AS PER SRM 51-10-01.SDR UPS01437273Frame · crackedINSPECTION TYPE:C L/H BS 300 NOSE WHEEL WELL FRAME CRACK FOUND AT WEB 2EA FASTENER HOLES, PLS REFER ATT FIG. LH BS 300 WHEEL WELL FRAME AT STR L 39 TO STR L 41 CRACKED AREA REPAIRED AS PER SRM 51-40-03 FIG 1.SDR UPS01437272Frame · crackedINSPECTION TYPE:C R/H BS 300 NOSE WHEEL WELL FRAME CRACK FOUND AT WEB 4EA FASTENER HOLES, PLS REFER ATT FIG. R/H BS 300 NOSE WHEEL WELL STR R 39 TO R 41 FRAME CRACKED AREA REPAIRED AS PER SRM 51-40-03 FIG 1.SDR AALA20011993Door Frame · corrodedTUL - LOWER AFT CARGO DOOR JAMB CORRODED FROM STATION 1155 TO STATION 1212 AT STRINGER 28R. INSTALLED REPAIR DOUBLER OVER OUT OF LIMIT AREA PER AARD 53-10-00-16 AND AARD 53-10-00-3. (M)SDR JGV2001F00015Door Frame · corrodedCORROSION OF LOWER AFT DOOR FRAME AND SUPPORT BOX STRUCTURE. CONTAMINATION OF FIBERGLASS INSULATION WITH WATER LED TO CORROSION OF STRUCTURE IN THIS UNACCESSIBLE AND CLOSED AREA. (PN OF CORRODED PARTS: 5410160-39, 5410557-112, 5415572-46, 5410557-16, 5410557SDR P5CA0100606Web · crackedNOSE GEAR WHEEL WELL FRAME WEB CRACKED, APPROX. 1/8" LONG, BY INSULATION HOLES FIRST & FOUR FROM FLOOR CHORD ANGLE ON RIGHT SIDE. OPENED HOLES TO 7/16", RE-INSPECTED BY H.F.E.C. - NO INDICATIONS. REPAIRED IAW BOEING SERVICE LETTER PAO-LGB-01-0015514, SB74752SDR AALA20011989Door Frame · corrodedTUL - FOUND AFT CARGO DOOR CUTOUT LOWER BEAM HAS HEAVY CORROSION STATION 1165 TO 1211. REMOVED CORRODED DOOR BEAM AND INSTALLED NEW ONE PER SRM 51-01. ALSO INSTALLED/SPLICED IN NEW WEB SECTION (PREVIOUSLY REPAIRED) PER AARD 53-10-00-24 ON E58 NR 4042956. (MSDR UPS01437297Doubler · crackedINSPECTION TYPE:C M/D - LH #1 MED EXTERIOR SKIN LWR HINGE CUTOUT ATT DOUBLER FOUND CRACK AS MARKED. DOUBLER REPLACED AS PER R.S R52-11-34699.SDR SWAA012968Skin · crackedDURING SCHEDULED C2 CHECK, FOUND 1 INCH FUSELAGE SKIN CRACK AT BS 500B, STR 10R. REPAIRED SKIN PER SRM.SDR SWAA012967Skin · crackedDURING SCHEDULED C2 CHECK, FOUND 2 INCH FUSELAGE SKIN CRACK AT BS 927, STR 21L. REPAIRED SKIN PER SRM.SDR ASAA0140134Door Frame · corrodedPAE - DURING C-CHECK, FOUND AFT CARGO BAY BS 792, RBL 24-28 WL 160 DOOR FRAME PLATE IS CORRODED. REMOVED AND REPLACED PLATE IAW SRM. (M)SDR GTIA012006Door Frame · corrodedAFT CARGO COMPARTMENT DOOR JAMB BEAM CORRODED, LEVEL 1. REMOVED JAMB BEAM. CARGO TRACK SUPPORT AT STATION 1219 FOUND TO BE OUT OF LIMITS. LOCATED AND DRILLED NEW DOOR JAMB BEAM. INSTALLED CARGO TRACK SUPPORT BRACKET AT STATION 1219. INSTALLED DOOR JAMB BESDR 2001UALA02177Door Frame · crackedFWD GALLEY DOOR AFT DOOR FRAME AT, 3RD STOP FITTING FROM BOTTOM, CRACKED. MAJOR REPAIR ACCOMPLISHED. INSTALLED DOUBLER TO FRAME CUTOUT.SDR SWAA012970Post · crackedDURING SCHEDULED 1/2D CHECK, FOUND F/O'S UPPER WINDOW POST CRACKED. REPAIRED F/O'S WINDOW POST PER SRM.SDR SWAA012969Web · crackedDURING SCHEDULED 1/2D CHECK, FOUND WEB IN RH MLG W/W CEILING CRACKED AT BS 675, RBL 35. REPAIRED WEB PER SWA TI.SDR 2001UALA02176Attach Angle · crackedFUSELAGE FRAME STATION 188 WL 207 RADIUS CRACKED IN SKIN ATTACH FLANGE. MAJOR REPAIR ACCOMPLISHED. INSTALLED DOUBLER.SDR SWIA200110306Window Frame · crackedLEFT SIDE DV WINDOW FRAME IS CRACKED. COMPLIED WITH SB 120-53-0072 STEPS 2.1 THROUGH 2.7 - INSTALLATION OF NEW DOUBLERS AND REPLACEMENT RIVETS.SDR USAA011342Door Frame · crackedCLT - FOUND DOOR FRAME CRACKED 4.75 INCH BY 4.75 INCH, R-4 FUSELAGE CUT OUT FORWARD FRAME LOWER SIDE. STOPPED DRILLED CRACK, INSTALLED DOUBLER PER EA 85569. (M)SDR SWAA012963Web · crackedDURING SPECIAL VISIT, FOUND VERTICAL WEB CRACKED AT BS 182, LBL 17.1, WL 175. REPAIRED WEB PER SWA RA.SDR SWAA012937Shear Tie · corrodedDURING SCHEDULED 1/4D CHECK, FOUND SHEAR TIE FRAME CORRODED AT BS 747, BETWEEN STR 26R & 27R. REPAIRED SHEAR TIE FRAME PER SRM.SDR AALA20012013Angle · crackedTUL - FOUND CRACK NEAR 1ST FASTENER .25 INCH LONG IN ANGLE OF WINDOW CUT OUT INTERNAL DOUBLER AT STATION 1137 AND LONGERON 14R. STOP DRILLED CRACK AND INSTALLED DOUBLER PER AARD 53-10-00-25. (M)SDR DL72E011730Beam · crackedBULKHEAD FS 1183 VERTICAL BEAM RBL 8 WL 182 CRACKED. THE RBL 8 VERTICAL BEAM ON THE FS 1183 BULKHEAD WAS FOUND WITH A 1 INCH CRACK AT THE LOWER END AT WL 182. THE CRACK IS TYPICAL OF BAC SB 727-53-0175. THE CRACK WAS REPAIRED PER THE SB AND PER ER/A 382022-14SDR SWAA012983Clip · crackedDURING SCHEDULED 1/4D CHECK, FOUND SEVERAL TIE CLIPS CRACKED AT BS 616. R&R TIE CLIPS PER SRM.SDR 2001UALA02164Crease Beam · damagedBODY STATION 185 STRINGER 17R CREASE BEAM FOUND DAMAGED, REQUIRED BLENDING BEYOND LIMITS. MAJOR REPAIR ACCOMPLISHED. DAMAGE REMOVED AND REPLACEMENT INSTALLED.SDR SWAA012966Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND FRAME CRACKED AT BS 360, ABOVE STR 14R. REPAIRED FRAME PER SRM.SDR WRNA200100017Stringer · corrodedDURING WALK AROUND FOUND CORROSION ON FUSELAGE AT BULK CARGO DOOR AREA. LOCATED AFT, L/H LOWER CORNER. STA. 365 STRINGER 47RCORRECTIVE ACTION: REPAIR CARRIED OUT I/A/W SRM 53-10-20 FIG. 701 SHEET 3 LAP JOINT REPAIRSDR SWAA012911Shear Tie · corrodedDURING SCHEDULED D CHECK, FOUND SHEAR TIE CORRODED AT BS 360, BETWEEN STR'S 28L & 28R. REPAIRED SHEAR TIE PER SRM & BFG ER 01-0911.SDR SWAA012904Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, BETWEEN STR 8R & 9R. REPAIRED FRAME PER BFG ER 01-0885.SDR MWEA011404Longeron · unserviceableFORWARD CARGO BAY LONGERON 21 RIGHT HAS PREVIOUS REPAIR ON UPPER FLANGE BETWEEN STATION 298 THROUGH 303. -- FABRICATED AND INSTALLED REPAIR SPLICE SECTIONS.SDR SWAA012900Stringer · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE STRINGER CRACKED AT BS 460, STR 17B. REPAIRED STRINGER PER SRM.SDR ASAA0140626Shear Tie · corrodedPAE - DURING C-CHECK, FOUND CORROSION ON SHEAR TIE AT STATION 520 AND STRINGER 27L TO 28L. REPAIR IAW SRM. (M)SDR SWAA012960Strap · crackedDURING SCHEDULED 1/2D CHECK, FOUND AFT SERVICE DOOR LOWER FWD CUT OUT BEAR STRAP CRACKED. REPAIRED STRAP ASSY PER SWA RA.SDR 2001UALA02135Crease Beam · corrodedSTATION 978 WL 209 LBL 45 STRINGER 17 ZEE CREASE BEAM CORRODED. MAJOR REPAIR ACCOMPLISHED. REPLACED CREASE BEAM.SDR 0103909607Angle · crackedDuring Hck in ATL, an existing repair angle was found cracked on the sta 1076 frame at the longeron 2R. The repair angle was removed and replaced with an identical repair. The repair angle was installed because a B/P 0.25 inch hole used to attach th 5910090-73SDR UPS01237213Lap Joint · corrodedINSPECTION TYPE:C SUSPECT CORROSION AT LAP JOINT AT BS 1141 STR 4 R LFEC CARRIED OUT, 30%CORROSION INDICATED. AREA OF DAMAGE , CUTOUT HF EC NDF. REPAIR PARTS FABRICATED AND INSTALLED IAW UPS EO B727-5330-0 509 APPENDIX 8.3. AREA REPROTECTED IAW SRM.SDR SWAA012907Shear Tie · crackedDURING SCHEDULED D CHECK, FOUND SHEAR TIE CRACKED AT BS 277, STR 8L. R&R SHEAR TIE PER BFG ER 01-0908.SDR 2001UALA02136Door Frame · dentedAFT PIT DOOR CUTOUT AFT FRAME BETWEEN STRINGER 23 & 22 CARGO DOOR SKIN CUTOUT FRAME, SKIN DENTED. MAJOR REPAIR ACCOMPLISHED. INSTALLED REPAIR DOUBLER.SDR SWAA012864Frame · crackedDURING SCHEDULED 142D CHECK, FOUND FWD SVC DOOR CUT OUT LWR STUB FRAME CRACKED AT BS 294.5. REPAIRED FRAME PER SRM.SDR SWAA012862Web · crackedDURING SCHEDULED 1/4D CHECK, FOUND WEB CRACKED AT BS 178, RBL 5, WL 212. REPAIRED WEB PER SRM.SDR SWAA012861Web · crackedDURING SCHEDULED 1/4D CHECK, FOUND BEADED PRESS WEB CRACKED AT BS 663, RBL 42. REPAIRED WEB PER SWA TI-353-032.SDR UPS01237093Stringer · crackedINSPECTION TYPE:N/A STRINGER 20R CRACKED AT FRAME 294 FWD OF LAV WASTE CHUTE STRINGER REPAIRED AS PER SRM 53-10-03. STATION 319 TO 284.5 REPAIREDSDR 0103939758Pad · crackedDURING A RON IN DTW, A CHAFE PAD LOCATED ON THE AFT DOOR JAMB ON THE RHS AFT EMERGENCY EXIT WAS FOUND CRACKED. IN SPITE OF THE DAMAGE, THE CHAFE WAS REPORTED SECURED TO THE STRUCTURE. EA 97-185229.SDR SWAA012882Frame · corrodedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 1018, RBL 1 & WL 191. REPAIRED FRAME PER SRM.SDR SWAA012881Shear Tie · corrodedDURING SCHEDULED D CHECK, FOUND SHEAR TIE CORRODED AT BS 847, RBL 2 & WL156. R&R SHEAR TIE PER SRM.SDR 0103639758Shim · crackedDuring a RON in DTW, A shim angle P/N 5919159-15 located on the aft door jamb on the RHS aft emergency exit was found cracked. Repaired per EA 97-185229.SDR 2001UALA02137Crease Beam · damagedAFT CABIN RIGHT HAND CREASE BEAM HAS EXCESSIVE MATERIAL LOSS. MAJOR REPAIR ACCOMPLISHED. REPLACED CREASE BEAM FROM STATION 927 TO 990.SDR UPS02239905Fitting · crackedINSPECTION TYPE:C&SI WHILE CARRYING OUT NDT INSP. OF L/H 870 FTG, RECENT CRACK FOUND FROM HOLE COMMON TO STR. END AT 1ST ROW, ALSO 2 OTHER HOLES HAVE CORROSI ON INDICATIONS L/H 870 REPLACED IAW EO B727-5310-3056-F & DRAWING 65C13724SDR ASAA0140599Door Frame · corrodedPAE - DURING C-CHECK, FOUND CORROSION ON FORWARD SURFACE AFT FRAME OF AFT CARGO DOOR CUT OUT AT STRINGER 25R TO 23R. REPAIRED DAMAGED FRAME BY INSTALLING DOUBLER PER ENGINEERING REPAIR. (M)SDR ASAA0140616Shear Tie · corrodedPAE - DURING C-CHECK, FOUND CORROSION ON SHEAR TIE AT STATION 520 BETWEEN STRINGER 26L AND 27L. REPAIRED SHEAR TIE IAW SRM. (M)SDR ASAA0140604Shear Tie · corrodedPAE -DURING C-CHECK FOUND CORROSION ON SHEAR TIE STATION 520 BETWEEN STRINGER 26L AND 27L. REPAIRED IAW SRM. (M)
Back to JASC 5310