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 2008UALA01100Crease Beam · corrodedAFT ENTRY DOOR CUTOUT INNER CREASE BEAM CORRODED AT NUT PLATE HOLES AND UPPER SURFACE, BS 963-984 STR 17L. MAJOR REPAIR ACP'D BY REPLACING CREASE BEAM REF SRM 51-40-02.SDR SWAA081122Crease Beam · corrodedDURING SCHEDULED 16Y CHECK, FOUND CREASE BEAM WEB CORRODED AT BS 415, RBL 68. REMOVED AND REPLACED WEB PER SRM.SDR LR7A08037Rib · crackedDURING SCHEDULED C-7 CHECK, PER JOB CARD HC5311, FOUND COCKPIT RT RIB WITH CRACKS AT FS 132, WL 210-220, RBL61. REPAIR ACCOMPLISHED BY REPLACING RIB IAW SMP583 CHAP 51-60 AND 51-70 WITH REFERENCE TO DWG 339010.SDR SWAA081119Door Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND AFT CARGO DOOR CUTOUT AFT FRAME CRACKED AT NR 3 DOOR STOP. REMOVED AND REPLACED FRAME PER BOEING DRAWING.SDR 2008UALA01067Crease Beam · corrodedAFT CABIN RIGHT CREASE BEAM INNER CHORD UPPER SURFACE CORRODED BS 947.5 TO 995 AT STR 17R. MAJOR REPAIR: REMOVED CORRODED CREASE BEAM. REPLACED CREASE BEAM.SDR CALA0800176Door Frame · crackedFORWARD CARGO DOOR CUTOUT AFT FRAME CRACKED AT LOWER STOP FITTING FOOTPRINT. REMOVED AND REPLACED FORWARD CARGO AFT FRAME PER SRM 51-40-02.SDR USAA920080614Door Frame · crackedPIT - MAJOR REPAIR - FPBH INSPECTION - FORWARD CARGO DOOR CUTOUT AFT FRAME CRACKED, BS 492.4, S24R. REPAIRED FORWARD CARGO DOOR CUTOUT AFT FRAME, BS 492.4, S24R IAW USAIRWAYS EA 110728.SDR SIMA200806005Beam · corrodedDURING AN IMBV INSP, THE CENTER HAT BEAM WAS FOUND TO BE CORRODED ON THE LEFT SIDE. REPAIR, REMOVED CENTER BEAM GUSSET, MADE A CUTOUT TO REMOVE THE CORROSION. FABRICATED A DOUBLER USING AL2024T3, TH-.040. CLEANED AND TREATED REPAIR PART. REPAIR DONE IAW ASDR CA080220013Door Frame · gouged(CAN) L1 DOOR CUTOUT FRAME AT STA 349, WL 216 GOUGED AND REPAIRED IAW CUSTOMER EA. (TC NR 20080220013)SDR TRAX200800311Attach Angle · crackedRT WHEEL WELL I/B BATT RIB ATTACH ANGLE CRACKED
SDR SWAA080941Door Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FWD CARGO DOOR CUTOUT FWD FRAME CRACKED AT NR 4 DOOR STOP. REPAIRED FRAME PER SRM.SDR A6WA200840118Beam · crackedAT FS 621, WL 114, LBL 27, BELOW BEAM ANGLE CRACKED. BEAM ANGLE REPLACED IAW SRM 51-24-21. (M)SDR DLM90080242Beam · corrodedCORROSION ON LWR LEG OF MID CARGO DOOR BEAM IN NUMEROUS PLACES ENTIRE LENGTH. REPAIRED DOOR BEAM, IAW MD80 SRM 53-05D FIG 63.SDR SWAA080877Crease Beam · corrodedDURING SCHEDULED 20Y CHECK, FOUND CREASE BEAM WEB CORRODED BETWEEN BS 400 AND BS 420, RBL 65. REMOVED AND REPLACED WEB PER SRM.SDR SWAA080876Crease Beam · corrodedDURING SCHEDULED 20Y CHECK, FOUND CREASE BEAM WEB CORRODED BETWEEN BS 360 AND BS 380, RBL 65. REMOVED AND REPLACED WEB PER SRM.SDR SWAA080875Door Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND AFT CARGO DOOR CUTOUT FWD FRAME UPPER CRACKED. REMOVED AND REPLACED FRAME PER SRM.SDR 2008UALA00905Structure · damagedFUSELAGE DAMAGED AT APPROX STRINGER 31L STA 610, DENT APPROX .097 DEEP.SDR USAA920080521Door Frame · crackedPIT - MAJOR REPAIR - FPBH - FORWARD CARGO DOOR CUTOUT AFT FRAME CRACKED, BS 492.4, S24R. REPAIRED FORWARD CARGO DOOR CUTOUT AFT FRAME, BS 492.4, S24R IAW USAIRWAYS EA 110692.SDR USAA920080451Door Frame · crackedPIT - MAJOR REPAIR - FPBH INSPECTION - FORWARD CARGO COMPARTMENT DOOR CUT OUT FORWARD FRAME CRACKED, BS 44, S24R. REPAIRED FORWARD CARGO COMPARTMENT DOOR CUTOUT FORWARD FRAME, BS 440, S24R IAW USAIRWAYS EA 110651.SDR 2008UALA00872Crease Beam · corrodedCREASE BEAM AT FWD GALLEY SERVICE DOOR FROM STATION 270 T0 360 IS CORRODED. SUSPECT MOISTURE CONTAMINATION. REPLACED CORRODED BEAM WITH NEW CREASE BEAM. AC OK FOR SERVICE.SDR A6WA200840117Structure · crackedFOUND CRACK EXIST ON PASSENGER DOOR EDGE MEMBER FORWARD. REPAIR ON PASSENGER DOOR EDGE CARRIED OUT IAW REO 601R-52-11-279. (M)SDR DLM90080236Beam · corrodedAFT CARGO BAY BRACKET AT AFT END OF LWR BEAM (DOOR CUT-OUT) CORRODED. REMOVED AND REPLACED BRACKET IN AFT OF LWR BEAM, IAW MD90 SRM 51-30-05.SDR UIEA200800047Door Frame · crackedMAIN DECK NR 4R DOOR AFT SIDE EDGE FRAME LOWER POSITION FOUND CRACKED. REPAIRED CRACK PER SRM 52-10-02.SDR 2008UALA00891Door Frame · crackedFORWARD ENTRY DOOR SURROUND STRUCTURE 2 CRACKS ON INTERCOSTAL AT BS 294.5 AND STRINGER S-7L. MAJOR REPAIR ACCOMPLISHED: REPLACED INTERCOSTAL.
SDR 2008UALA00880Door Frame · corrodedFWD LOWER NOSE COMPT, JUST AFT OF ACCESS DOOR, LOWER CHORD CORRODED, BS 227 LBL 2". MAJOR REPAIR ACCOMPLISHED: RMV'D CORROSION. INSTALLED REPAIR ANGLE & INTERCOSTAL.SDR 08FDEA00448Beam · crackedFWD CARGO COMPT PERFORMED REWORKING IAW EO 8-2550-7-2354 P1 ON BEAM FOUND CRACK. REPAIRED BEAM IAW SRM 53-60-01 FIG 3 VOL I.SDR 2008F00005Window Frame · damagedDAMAGED IN MAINT DURING WINDSHIELD REPLACEMENT.SDR 2008F00003Window Frame · damagedPART WAS DAMAGED IN MAINTENANCE, DURING WINDSHIELD REPLACEMENTSDR UPS08M52071Structure · corrodedINSPECTION TYPE:C CENTER CARGO BILGE RT L48 STA 1715-1695 FOUND MAJOR CORROSION ON LONGERON AS MARKED, LONGERON MAJOR CORROSION REMOVED. FOUND EXCEEDED LIMIT PER SRM 53-10-00 FIG 2A V.1R.40. MAT`L REMOVED:0.075 INCH ORIG THK:0.105 INCH. NEW LONG REWORK C/OUSDR DLM88080266Door Frame · corrodedDURING HMV, CORROSION WAS FOUND ON AFT CARGO COMPARTMENT DOOR JAMB DOUBLER AT STA Y=1154 P/N 5936433-5 BETWEEN LONGERONS 30 AND 29 RT. A REPAIR WAS PERFORMED IAW DWG AMR0953586 R2 DATED ON 15 JAN 08.SDR KCSA081075Door Frame · crackedNR 1R MAIN ENTRY DOOR LOWER HORIZ FRAME CRACKED AT FWD CORNER.SDR 2008UALA00816Crease Beam · corrodedZ-ANGLE UPPER SURFACE FROM BS 962 TO 976 IS CORRODED AT AFT GALLEY SERVICE DOOR CUTOUT. MAJOR REPAIR ACCOMPLISHED: REMOVED & REPLACED STR 17R FLOOR CREASE BEAM.SDR SWAA080814Crease Beam · corrodedDURING SCHEDULED 20Y CHECK, FOUND CREASE BEAM WEB CORRODED BETWEEN BS 420 AND BS 440, LBL 65. REMOVED AND REPLACED WEB PER SRM.SDR 08FDEA00408Cap · crackedLT END CAP OF CAC DOMED PRESSURE BULKHEAD CRACKED. REMOVED AND REPLACED END CAP IAW SRM 51-31-01. END CAP FABRICATED ON MAE TRAVELER T8/725202. REMOVED AND REINSTALLED DOUBLER IAW SRM 51-31-01 FOR ACCESS. CLEANED AND RESEALED AREA IAW MM 20-60-08-2.SDR A6WA200840082Door Frame · crackedEXTERNAL AIR COUPLING DOOR FRAME CRACKED AND BENT. (K) REPAIRED IAW BSC EO 601R-53-14474A. (M)SDR SWAA080784Door Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FWD CARGO DOOR CUTOUT AFT FRAME CRACKED AT STR 25R. REPAIRED FRAME PER SRM AND BOEING DRAWING.SDR 2008UALA00742Stop · crackedFWD CARGO DR CUTOUT, FWD FRAME AT LWR STOP PAD FITTING CRACKED ON FWD SIDE OF FRAME IN UPPER RADIUS. MAJOR REPAIR: ACCOMPLISHED REPAIR.SDR 2008UALA00723Door Frame · crackedFWD GALLEY DOOR SN 1245 FRAME CRACKED AT UPPER AFT CORNER NEXT TO THE STOP FITTING.SDR G60A200800010Door Frame · corrodedFOUND CORROSION NOSE WHEEL WELL DOOR JAM STRUCTURE, SHELF.SDR USAA920080386Door Frame · crackedCLT - MAJOR REPAIR - C20 CHECK - NR I2D52004/2, AFT CARGO DOOR FORWARD FRAME CRACKED. REPLACED AFT CARGO DOOR IAW B737 SRM 52-31-00.SDR DHL2008749019Angle · corrodedDURING C CHECK, EXFOLIATION NOTED AT C2 DOOR CUT OUT, BS 990 (FRAME) BETWEEN STRINGERS 26R AND 27R. REMOVED CORROSION AT C2 DOOR CUT OUT BS 990 IAW SRM 51-10-6, ORIGINAL THICKNESS 0.100, MATERIAL LOSS 0.35, MATERIAL REMAINING 0.65, FOUND OUT OF LIMITS IAW SRMSDR ABXA080060Window Frame · crackedDURING WINDOW FRAME MOD TO COCKPIT STRUCTURE, FOUND CENTER FRAME WITH MULTIPLE CRACKS. REPLACED CENTER FRAME SEGMENT IAW DC9 SRM 51-30-2 PER WO 600283624.SDR ABXA080058Window Frame · crackedDURING WINDOW FRAME MOD TO COCKPIT STRUCTURE, FOUND RIGHT SIDE FRAME CRACKED LESS THAN 2.50 INCHES. REPAIRED IAW DC9 SRM 53-03, FIG 34 PER WO 600283624.SDR ABXA080059Window Frame · crackedDURING WINDOW FRAME MOD TO COCKPIT STRUCTURE, FOUND LEFT SIDE FRAME CRACKED LESS THAN 2.50 INCHES. REPAIRED IAW DC9 SRM 53-05, FIG 34 PER WO 600283624.SDR TRAX200800217Support Beam · crackedENGINE SUPPORT BEAM UPPER WEB CRACKED AT AFT EDGE, FS 640, LBL8.0, WL119.12, MEASURES .80 INCHES LONG. ACCOMPLISHED REPAIR TO ENG SUPPORT BEAM BY COMPLYING WITH REO 601R-53-61-345 IAW ASA EO 600-53-0072B CARD EO 600-53-72-0001.SDR SWAA080704Door Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FWD CARGO DOOR CUTOUT FWD FRAME CRACKED AT NR 5 DOOR STOP. REPAIRED FRAME PER ACO.SDR MWEA080027Door Frame · crackedLOWER DEFLECTOR DOOR Z-FRAME IS CRACKED AT STATION 35.669 (RIGHT). FABRICATED AND INSTALLED Z-FRAME.SDR MWEA080026Door Frame · crackedLOWER DEFLECTOR DOOR Z-FRAME CRACKED AT STATION 35.669 (LEFT). FABRICATED AND INSTALLED ANGLE.SDR MWEA080025Door Frame · crackedLOWER DEFLECTOR DOOR Z-FRAME IS CRACKED AT STATION 26.666 (LEFT). FABRICATED AND INSTALLED ANGLE.SDR SWAA080670Door Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FWD CARGO DOOR CUTOUT AFT FRAME CRACKED AT NR 5 DOOR STOP. REPAIRED FRAME PER ACO.
Back to JASC 5310