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 DHL2007804506Structure · misrepairedPPERFORMED DETAILED VISUAL INSPECTION AND FOUND A PREVIOUS REPAIR NOT IN ACCORDANCE WITH SRM. PERFORMED MAJOR REPAIR IAW SRM 53-2-1 FIG 7 SHEET 1, 4. REMOVED EXISTING NON STANDARD REPAIR IAW SRM 51-1-21, SRM 51-1-20D. FABRICATED REPAIR DOUBLER (AL7075T6 0.0SDR 2007UALA03029Frame · crackedFWD CARGO DOOR CUTOUT AFT FRAME IS CRACKED ON FWD SIDE IN THREE PLACES. AFT SIDE ON TOP OF CREASE, FWD SIDE AT BOTTOM OF STOP FITTING, UPPER CORNER OF STOP FITTING, O/B LOWER CORNER OF STOP FITTING AND THROUGH I/B LOWER BOLT HOLE OF STOP FITTING AFT SIDE CRACSDR 2007UALA02998Door Frame · crackedEXTERNAL FUSELAGE FWD CARGO DOOR CUTOUT FRAME. FWD CARGO DOOR CUTOUT AFT FRAME IS CRACKED ON FWD SIDE IN THREE PLACES. AFT SIDE ON TOP OF CREASE, FWD SIDE AT BOTTOM OF STOP FITTING, UPPER CORNER OF STOP FITTING, OB LOWER CORNER OF STOP FITTING AND THROUGH IB SDR SWAA073910Door Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FWD CARGO DOOR CUTOUT AFT FRAME CRACKED AT UPPER INBOARD CORNER. REPAIRED FRAME PER SRM.SDR DHL2007741527Beam · corrodedNOSE SECTION INTERIOR HORIZ WALKWAY BEAM LEFT SIDE MID CHORD CORRODED AT FWD END, BS 298, LWR SIDE. REMOVED CORROSION, MATERIAL REMOVAL EXCEEDED LIMITS PER B727 SRM 53-10-1 FIG 1. REMOVED, LOCATED, DRILLED UP, TREATED, PRIMED, AND INSTALLED NEW MID CHORD PERSDR 07FDEA02746Crossbeam · corrodedAFTER BLENDING CORROSION ON CROSSBEAM C67 RT, Y-1200 WAS OUT OF LIMIT. REPAIR PERFORMED BY REPLACEMENT IAW SRM 51-72-10.SDR SWIA200718727Window Post · crackedFOUND AT C-CHECK, LEFT WINDSHIELD SIDE ATTACHMENT POST APPEARS TO BE CRACKED. REPLACED LOWER WINDSHIELD STRUCTURE IAW SRM 120 51-10-02 PG 3 SEC 3A.
SDR SWAA073899Crease Beam · crackedDURING SCHEDULED BRDG CHECK, FOUND CREASE BEAM WEB CRACKED AT BS 574, STR 17L. REMOVED AND REPLACED WEB PER SWA EA.SDR SWAA073901Door Frame · crackedDURING SCHEDULED SPV CHECK, FOUND AFT CARGO DOOR CUTOUT AFT FRAME CRACKED AT NR 2 STOP. REPAIRED FRAME PER ACO.SDR 07FDEA02727Door Frame · corrodedMAIN CARGO DOOR CUT-OUT LOWER JAMB TOP SIDE, JUST FWD OF NR 3 LATCH SPOOL FITTING WEB CORRODED. 09-04-07 REMOVED AND REPLACED MAIN CARGO DOOR JAMB UPPER BEAM ACA7226-1 IN REF TO DC/MD10 SRM 51-33-01 VOL II PAGE1 AND DAC DRAWING ACA7224 REV G. MAJOR REPAIRSDR 07FDEA02724Crease Beam · crackedLT AFT FUSELAGE UNDER REMOVED CENTER ENG SUPPORT EXT SKIN PANEL, CREASE ANGLE IS CRACKED UNDER TRIANGULAR RIB, UPPER IB CORNER ATTACHED TO OB SIDE OF VERT STAB SKIN BS 1360 THE CREASE CHORD WAS REPAIRED REF EO NR 7-5530-7-2303 PRT 5, REV Q. JPF STEPS 20-30 ANDSDR DHL2007804509Door Frame · cracked"B" CARGO DOOR FWD LWR JAMB CORNER CRACKED 1/2" STA 521.000 L-31R TO L-32R (MAJOR REPAIR). PERFORMED MAJOR REPAIR IAW FAA FORM 8100-9 DATED 07-20-07, BOEING MSG NR 1-425040944-2 DATED 07-20-07, AD2005-18-07, DOUGLAS DWG NR 57507776, ASTAR EVAD852-00012 REV IRSDR TAMF20070005SBeam · corrodedDURING C-CHECK INSPECTION (TASK CARD 53-426-00) WAS FOUND CORROSION ON NLG W/W BULKHEAD, STA 287, CENTER BEAM PN 141T2939. CORRODED AREA WAS REMOVED IAW SRM 51-10-02 PAG 12-13 AND IT WAS FOUND OUT OF LIMITS (MAX 0.190 IN, MIN 0.160 IN) IAW SRM 53-10-14 FIGURESDR SWAA073856Door Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND AFT CARGO DOOR CUTOUT FWD FRAME CRACKED AT NR 5 DOOR STOP. REPAIRED FRAME PER SRM.SDR 2007UALA02935Door Frame · crackedFWD GALLEY CARGO PIT AFT OF DOOR CUTOUT APPROX STA 455, STR 24R CRACKED. MAJOR REPAIR ACCOMPLISHED: INSTALLED NESTED REPAIR ANGLES & U-CHANNEL REPAIR.SDR CPCP20070092Structure · damagedFRAME 28B BETWEEN STR LT 21-20 CORROSION FOUND. FRAME 28B CENTER SEGMENT REPLACED AS PER SRM 51-25-01.SDR SWAA073738Door Frame · crackedDURING SCHEDULED HC2 CHECK, FOUND AFT CARGO DOOR AFT LOWER FRAME CRACKED. REMOVED AND REPLACED CARGO DOOR PER MM.SDR SWIA200718844Door Frame · corrodedLEFT EMERGENCY EXIT DOOR SURROUND HAS CORRODED HINGE PINS, FOUND AT C-CHECK. REPLACED PINS ON LEFT EMERGENCY EXIT DOOR SURROUND PER CRJ200 AMM 20-24-00-910-801.SDR SWIA200718839Door Frame · crackedPAX DOOR FRAME IS CRACKED STA 338, DISCOVERED AT C-CHECK. INSTALLED REPAIR PARTS ON PAX DOOR PER REO 601R-52-11-402 REV G.
SDR USAA070581Door Frame · crackedBS 440 & S-24R HAS CRACK. INSTALLED DOUBLER PER EA 98810, DEFECT SIZE: .5 INCH.SDR USAA070582Door Frame · crackedBS 492.4 & S-24R HAS CRACK. INSTALLED DOUBLER PER EA 98809, DEFECT SIZE: .4 INCH.SDR 2007FA0000671Bridge · crackedDURING A ROUTINE DYE-PENETRANT INSPECTION ON TG-10B CRACKS WERE DISCOVERED AT SEVERAL WELDS ON THE A741 210N BRIDGE ASSEMBLY. A REPLACEMENT BRIDGE ASSY CANNIBALIZED FROM ANOTHER TG-10B IN AN EFFORT TO PLACE THE FIRST NOTED AIRCRAFT BACK IN SERVICE. AS A PRSDR 2007UALA02855Door Frame · crackedFWD GALLEY DOOR SN1223 LWR FWD FRAME CORNER HAS 2 HOLES CRACKED. INSTALLED KIT SPLICE FRAME REPAIR.SDR 2007UALA02854Door Frame · damagedFWD GALLEY DOOR SN1223 LWR AFT FRAME CORNER HAS 3 ELONGATED HOLES AND ONE HOLE CRACKED. REPLACED DAMAGED FRAME SECTION.SDR TIPR200736005Structure · crackedCRACK INDICATIONS ON LT AND RT VERTICAL STIFFENERS IN NOSE WHEEL WELL APPROX 12 INCHES DOWN FROM TOP OF CHORD. REPAIRED LT AND RT CHORDS IN ACCORDANCE WITH B767 SRM 51-70-12 FIG 1 AND AD 2005-02-02. REFERENCE SERVICE ORDER 599125 OPERATION 26110.SDR SWAA073656Door Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND AFT CARGO DOOR CUTOUT AFT FRAME WEB CRACKED AT LOWER OUTBOARD CORNER. REMOVED AND REPLACED FRAME WEB PER ACO.SDR 2007UALA02811Door Frame · crackedDOOR 1R CUTOUT FWD FRAME LOWER INBD CORNER OF FRAME CRACKED OFF THROUGH RIVET HOLES. FABRICATED AND INSTALLED FILLER-DOUBLER REPAIR PER SRM 51-70-11 AND SRM 51-40-02.SDR F3LA200700184Plate · damagedDURING C-3 CHECK, INSPECTION REPORTED HOLES ON JOINT PLATE COMMON TO FLOORBEAM AT -Y1292 BETWEEN FR68 AND FR69 DAMAGED. FABRICATED AND INSTALLED REPLACEMENT JOINT PLATE IAW A318 SRM 53-41-14, FIG 17, AND 51-42-11, STEP 7B.SDR KCSA071250Stop Fitting · crackedNR 3R MED, NR 6 STOP SUPPORT FITTING IS CRACKED AT I/B AFT AREA OF FITTING.SDR UPS07850338Angle · crackedINSPECTION TYPE: C2 C-PIT FWD BULKHEAD STA 986 LBL 46, ANGLE CRACKED. STOP DRILLED CRACKED ANGLE AT STA 986 LBL 46 IAW SRM 53-02-00-0 FIG 001B. FABRICATED AND INSTALLED REPAIR ANGLE AT STA 986 LBL 46 IAW SRM 53-02-00-0, AND DWG 5704721SDR 2007UALA02802Crease Beam · corrodedCABIN FLOOR CREASE BEAM INBD OR DOOR 1R CORRODED BS 294- 328. INSTALLED REPLACEMENT CREASE BEAM.SDR 07FDEA02566Crossbeam · corrodedCORROSION ON CROSSBEAM AT C67 RT (-Y805 TILL -Y1470, P/N A539-74360-200) AND C56A LT (Y805 TILL Y1470, P/N A539-74268-200). AFTER BLENDING, REMAINING THICKNESS WAS OUT OF LIMIT. REPAIR PERFORMED BY INSTALLING SPLICE IAW SRM 53-10-15/FIG 207.SDR A6WA200740412Track · crackedCARGO DOOR FWD ROLLER TRACK U-CHANNEL (PN 601R35050-25) CRACKED APPROX .2 INCH LONG AT BOTTOM OF TRACK. (K) MAINTENANCE REMOVED AND REPLACED U-CHANNEL IAW CRJ 200 SRM 51-42-06. (M)SDR 2007UALA02769Crease Beam · corrodedCREASE BEAM CORRODED ADJACENT TO MED 2R BS 986. MAJOR REPAIR: REPLACED CREASE BEAM PER SRM 51-40-02.SDR A6WA200740466Structure · crackedFS 280 RBL 9 CLIP P/N 601R31113-58 (OUTBD) IS CRACKED .25 INCH. MAINTENANCE REMOVED AND REPLACED ANGLE IAW CRJ 200 SRM 51-42-13 AND BSC SR 601R-53-0057A. (M)SDR A6WA200740408Vertical Beam · crackedFS 409.0+128 VERTICAL BEAM AT RBL 27 CRACKED APPROX.2 INCH LONG ON IB SIDE AT BOTTOM RIVET. (K) MAINTENANCE REMOVED DAMAGE FABRICATED AND INSTALLED REPAIR PARTS IAW BOMBARDIER REO 601R-53-41-056 REV E AND BSC EO 601R-53-12516. (M)SDR DLM90071015Beam · corrodedAFT PIT DOOR CUT OUT LOWER BEAM CORRODED ON VERTICAL AND HORIZONTAL FLANGE. REPAIRED AFT PIT DOOR CUT OUT LOWER BEAM IAW MD-80 SRM 53-05D FIG 63 AND SRM 51-00-01 PG 2 MD90.SDR 2007UALA02765Door Frame · crackedAFT CARGO PIT DOOR CUTOUT, FWD FRAME WEB CRACKED AT LOWER STOP PAD, LOWER OUTBOARD CORNER. MAJOR REPAIR: REMOVED AND INSTALLED NEW FRAME PER SRM 51-40-02, PG 1-40.SDR 07FDEA02548Beam · corrodedCORROSION ON BEAM BULK CARGO DOOR CUT OUT REPAIR PERFORMED BY REPLACING THE PART IAW SRM 51-72-10.SDR 07FDEA02530Structure · corrodedCENTER ACCESSORY COMPARTMENT BILGE AREA AT LONGERON 51R BETWEEN STA 1139 AND STA 1159, FOUND CORROSION. [08-06-07] REMOVED AND REPLACED WITH NEW LONGERON AS PER SRM 51-33-01 VOLUME II. REPAIR CLASSIFIED AS MAJOR PER GMM 6-2-100.SDR 2007UALA02740Door Frame · crackedRIGHT AFT GALLEY DOOR CUTOUT HAS CRACK AT FWD LOWER CORNER. MAJOR REPAIR ACCOMPLISHED: REMOVED DAMAGE. ACCOMPLISHED 2EA DOUBLER & 1EA TRIPLER REPAIR.SDR 2007UALA02739Door Frame · crackedFWD CARGO DOOR CUTOUT, AFT FRAME, CRACKED AT INNER RADIUS JUST ABOVE LOWER STOP PAD FITTING. MAJOR REPAIR ACCOMPLISHED: FABRICATED & INSTALLED ANGLE REPAIR.SDR SWAA073572Door Frame · crackedDURING SCHEDULED SPV CHECK, FOUND AFT CARGO DOOR CUTOUT FWD FRAME CRACKED NR 5 DOOR STOP. REPAIRED FRAME PER SRM.SDR CALA0700440Door Frame · crackedINSPECTION FOUND A CRACK IN THE AFT CARGO DOOR CUTOUT STA 794.3 FRAME. THE FRAME WAS REPAIRED IAW ECRA 5311-01344.SDR NWAA072705503Crease Beam · corrodedDURING "M" CHECK, FOUND CORROSION ON RT CREASE BEAM INNER CHORD FROM BS 760 TO 780 RBL 64. REPAIRED PER EA 55-209992.SDR SWAA073550Crease Beam · corrodedDURING SCHEDULED 10Y CHECK, FOUND CREASE BEAM CORRODED BETWEEN BS 956 AND BS 982, RBL 70. REPAIRED CREASE BEAM PER SRM.SDR USAA200707004Door Frame · crackedA .5 INCH CRACK AT FWD CARGO DOOR OPENING, AFT FRAME BS 492, LOWER DOOR STOP FITTING, S-24R. CUT OUT DAMAGED AREA, FABRICATED & INSTALLED REPAIR FILLER & ANGLES PER EA 98795.SDR K11A2008121072009Door Frame · corrodedOVERWING ESCAPE HATCH LOWER EDGE FRAME HAS CORROSION (RT AFT OVERWING HATCH).SDR 2007UALA02636Structure · corrodedFWD PIT HAS NUMEROUS CORRODED FASTENERS FROM FRAME 24B THROUGH FRAME 34 AND BETWEEN STR 38R & 38L. AREA WAS REPAIREDSDR SWAA073472Crease Beam · crackedDURING SCHEDULED BRDG CHECK, FOUND CREASE BEAM CRACKED AT BS 520, RBL 70. REPAIRED CREASE BEAM PER SRM.
Back to JASC 5310