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 07FDEA00900Structure · corrodedFOUND CORRODED L-SECTION AT C95. REPAIR WAS PERFORMED BY FRAME CUT AND SPLICE IAW EA 6-5319-103401 AND RAS/DATLS/0003411/2006 ISSUE "A".SDR 07FDEA00878Crossbeam · corrodedFOUND CROSSBEAM C62 RT CORRODED. REPAIR WAS PERFORMED BY REPLACEMENT OF CROSS BEAM IAW SRM 51-72-10.SDR 07FDEA00870Beam · corrodedAC BAY LBL 13 BEAM LOWER CHORD HAS CORROSION AROUND GROUND STUDS AND CLAMP SCREW BS 745-765, WL 140 ACCOMPLISHED REPAIR AT A/C BAY LBL 13 BEAM LOWER CHORD BS 745-765 REF SRM 51-40-3 PG 1-6. CLASSIFIED AS A MAJOR REPAIR.SDR USAA070215Structure · corrodedNOSE GEAR VIEW PORT WINDOW HAS CORROSION. REMOVED DAMAGE & INSTALLED FAB'D REPAIR PARTS PER SRM 51-70-12, DEFECT SIZE: 8 INCHES.SDR USAA070214Crease Beam · corrodedRIGHT CREASE BEAM INNER CHORD ANGLE, STA 270-360 RIGHT SIDE HAS CORROSION. REPLACED NEW ZEE ANGLE PER SRM 51-10-02; DWG 65-45875; CORR TASK C53-107-01; LEVEL 2, DEFECT SIZE: 38 X 2 INCHES.SDR USAA070201Frame · crackedBS 727B S-8R CRACKED. REMOVED DAMAGE & INSTALLED DOUBLERS PER TR 53-10-20E, DEFECT SIZE: .500 INCH.SDR USAA070199Strap · crackedSTRAP BETWEEN BS 294.5 & 305, BETWEEN S-9L & S-10L CRACKED. REMOVED DAMAGE & INSTALLED NEW & FABRICATED REPAIR PARTS PER 51-10-02; BOEING DWG 65-17684, DEFECT SIZE: .750 INCH.SDR SIMA200708503Gusset · corrodedGALLEY FORWARD GUSSET FOUND TO BE CORRODED. BLENDED THE AREA REMOVING CORROSION, FABRICATED AND INSTALLED REPAIR DOUBLER IAW EMB IC2007-145/01751, DATED 3-12-07. RETURNED AIRCRAFT TO SERVICE.SDR QXEA200700424Door Frame · corrodedC4 PDX - ANGLE CONNECTING FORWARD RIGHT EMERGENCY DOOR FRAME BY 240.5 TO GALLEY MOUNT ANGLE HAS CORROSION AROUND NUTPLATE LOWER SIDE OF ANGLE. REPAIRED IAW SRM 51-20-11, RD8-53-9512.SDR SWAA071391Door Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND AFT CARGO DOOR LOWER FRAME CRACKED AT PULLEY BRACKET LOCATION. REMOVED AND REPLACED DOOR FRAME PER SRM & BAC DRAWING.SDR SWAA071390Door Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND AFT CARGO DOOR UPPER FRAME CRACKED AT PULLEY BRACKET LOCATION. REMOVED AND REPLACED DOOR FRAME PER SRM & BAC DRAWING.SDR SWAA071365Crease Beam · corrodedDURING SCHEDULED 20Y CHECK, FOUND RIGHT CREASE BEAM CORRODED AT BS 948. REPAIRED CREASE BEAM PER SRM.SDR SWAA071362Crease Beam · corrodedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE CREASE BEAM CORRODED AT BS 996 LEFT SIDE. REPAIRED CREASE BEAM SECTION PER SRM.SDR 07FDEA00784Crossbeam · misrepairedOLD CROSS BEAM REPAIR WHICH WAS NOT CONFORM TO SRM. THE SRM REPAIR IN SOURCE DR330 ISN'T APPLICABLE. ANOTHER CROSSBEAM REPAIR WAS NECESSARY. CROSSBEAM REPAIR PERFORMED IAW SRM 53-10-15, FIG.207.SDR 07FDEA00783Crossbeam · misrepairedOLD CROSSBEAM REPAIR AT C62 WHICH IS NOT CONFORM TO THE SRM. REPAIR PERFORMED IAW SRM 53-10-15, FIG 207, PERFORMED WITH FOLLOW DR511.SDR 07FDEA00771Torque Box · unknownEXTERNAL DOUBLER SECTION 48, RT LOWER TORQUE BOX, ATA 1227.5,RBL 20, WL 190. COMPLY WITH ATTACHMENT "B" OF EO 7-5100-7-5005 PT2. COMPLIED WITH ATTACHMENT "B" OF EO 7-5100-7-5005 PT2, MAJOR REPAIR.SDR 07FDEA00761Longeron · crackedCTR CARGO BILGE AREA LONGERON 41L SPLICE AT STA 1531 SUSPECT CRACKED. CTR CARGO BILGE AREA LONGERON 41L SPLICE AT STA 1531 REMOVED & REPLACED AS PER SRM 51-33- 01 VOL.II. THIS REPAIR CLASSIFIED AS MAJOR AS PER FEDEX GMM 6-2-100.SDR 07FDEA00743Crossbeam · corrodedFOUND CORROSION ON CROSSBEAMS C56 AND C58. PARTS REPLACED IAW SRM 71-52-10.SDR 2007UALA00720Door Frame · crackedFWD CARGO DOOR CUTOUT AFT DOORWAY FRAME IS CRACKED ON AFT SIDE OF FRAME IN RADIUS AT UPPER I/B CORNER AT DOOR LOWER BOTTOM STOP FITTING. MAJOR REPAIR ACCOMPLISHED: INSTALLED NESTED ANGLE DOUBLER FRAME REPAIR.SDR TRAX200700332Crossbeam · corrodedLEFT FS 280 CROSSBEAM HAS CORROSION ON UPPER FLANGE. REMOVED LEFT 280.00 CROSSBEAM IAW 700/900 SERIES SRM 51-42-06, 51-42-13, 51-42-21. LOCATED HOLES ON SERVICEABLE CROSSBEAM P/N CC670-34175-7, IAW CRJ 700 SRM 51-40-11. INSTALLED LEFT 280.00 CROSSBEAM SECTISDR TRAX200700333Crossbeam · corrodedRIGHT FS 280 CROSSBEAM HAS CORROSION ON UPPER FLANGE. [SUP 05-02-07] REMOVED RT 280.00 CROSSBEAM IAW CRJ 700/900 SERIES SRM 51-42-06. 51-42-13, 51-42-21. LOCATED ALL HOLES IN NEW SERVICEABLE R CROSSBEAM.SDR SWAA071308Crease Beam · corrodedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE RIGHT CREASE BEAM CORRODED AT BS 996. REMOVED AND REPLACED CREASE BEAM SECTION PER SRM.SDR SWAA071275Crease Beam · corrodedDURING SCHEDULED 18Y CHECK, FOUND CREASE BEAM WEB CORRODED AT BS 460 TO BS 480, STR 17L. REMOVED AND REPLACED CREASE BEAM WEB PER SRM.SDR CALA0700124Door Frame · corrodedINSPECTION FOUND CORROSION AROUND FASTENER HOLES ON L-2 CHORD AT STA 947-987, LBL 53 TO LBL 54. THE CHORD WAS REPLACED IAW SRM 51-40-02.SDR SWAA071260Crease Beam · corrodedDURING SCHEDULED 18Y CHECK, FOUND CREASE BEAM WEB CORRODED AT BS 440 TO BS 460, STR 17L. REMOVED AND REPLACED CREASE BEAM WEB PER SRM.SDR SWAA071262Door Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FWD CARGO DOOR CUTOUT FWD FRAME CRACKED AT NR 5 DOOR STOP. REMOVED AND REPLACED FRAME PER SRM.SDR 07FDEA00674Beam · corrodedCORROSION AT ATTACHMENT HOLES ON SILL BEAM BETWEEN C25 AND 25A AT FWD CARGO DOOR. REPAIR WAS PERFORMED IAW TD/K7/S1/07372/2006 ISS A AND EA 6-5313-106401 AND IS APPROVED BY RAS/DABRE/7007372/2006 ISS A.SDR 07FDEA00671Crossbeam · corrodedFOUND CORROSION ON CROSSBEAM C67 RT. REPAIR WAS PERFORMED IAW SRM 53-10-15, FIG 207.SDR CALA0700122Door Frame · corrodedINSPECTION FOUND CORROSION AROUND FASTENER HOLES ON R-2 FRAME AT BS 947-995, RBL 43 TO RBL 63. THE CHORD WAS REMOVED AND REPLACED IAW SRM 51-40-02.SDR SWAA071240Crease Beam · crackedDURING SCHEDULED 20Y CHECK, FOUND CREASE BEAM CHORD CRACKED AT BS 639, LBL 70. REMOVED AND REPLACED CREASE BEAM CHORD PER ER.SDR UIEA200700130Strap · crackedCRACKS FOUND ON BS 800 LT STRAP AND INNER CHORD AT NR 2 MAIN ENTRY DOOR. REPAIRED ACCOMPLISHED IAW SR ID NR 1-289052431 AND FAA FORM 8100-9.SDR 2007UALA00642Crease Beam · corrodedFWD CABIN AREA RIGHT CREASE BEAM CHORD IS CORRODED FROM BS 277 TO BS 360 STR 17R, WL 208. *S/D* MAJOR REPAIR: REPLACED CREASE BEAM REF SRM 51-40-02.SDR UIEA200700108Window Frame · crackedNR 3L WINDOW FRAME FOUND CRACK AT STATION 340 STR 8L SKIN LOWER CORNER. SKIN REPAIRED AS PER BOEING MESSAGE 1-289012478-7 AND 12 AND 8100-9.SDR SWAA071212Crease Beam · corrodedDURING SCHEDULED 10Y CHECK, FOUND CREASE BEAM CORRODED AT BS 344, STR 17R. REMOVED AND REPLACED CREASE BEAM PER SRM.SDR NWAA071089758Door Frame · damagedDURING "H" CHECK, FOUND FORWARD CARGO DOOR JAMB DOUBLER WITH MULTIPLE OVERSIZED HOLES. REPAIRED PER EA 97-208465 SECTION I. SECTION II REQUIRES INSPECTIONS AT "L" CHECK INTERVALS.SDR 2007UALA00639Door Frame · crackedFWD CARGO DOOR AFT FRAME IS CRACKED IN UPPER FLANGE AT LOWER STOP FITTING. MAJOR REPAIR: REMOVED DAMAGE. INSTALLED NEW FRAME SECTION PER SRM 51-40-02.SDR SIMA200706708Beam · corrodedRIGHT HAT BEAM FOUND CORRODED AT FRAMES 22 AND 23. BLENEDED CORRODED AREA AND FILLED WITH EA934NA RESIN. FABRICATED AND INSTALLED DOUBLER IAW EMB IC2007-145/01376, DATED 02/26/07. RETURNED AIRCRAFT TO SERVICE.SDR CALA0700111Door Frame · crackedABB DOOR CUTOUT FWD FRAME CRACKED AT SECOND STOP FROM THE BOTTOM. REPLACED FRAME IAW BOEING DRAWING 65-47959.SDR SWAA071161Crease Beam · crackedDURING SCHEDULED 20Y CHECK, FOUND RIGHT CREASE BEAM CRACKED AT BS 639, RBL 70. REPAIRED CREASE BEAM PER ER.SDR 07FDEA00616Door Frame · corrodedMAIN DECK CARGO DOOR JAMB UNDER CENTERING GUIDE AREA FOUND CORROSION. COMPLIED WITH FEDEX EA 1-5310-106596. REPAIR CLASSIFIED AS MAJOR AS PER FEDEX GMM 6-2-100.SDR UIEA200700097Crease Beam · crackedM/DECK RTH SIDE STA 940, S-8R CREASE BEAM WEB FOUND CRACKED. CREASE BEAM WEB REPLACED AS PER SRM 51-10-01 AND 51-30-02.SDR UIEA200700095Crease Beam · crackedFOUND M/DECK STA960, S-7R CREASE BEAM SUPPORT ANGLE FOUND CRACKED. CREASE BEAM SUPPORT WEB REPLACED AS PER SRM 51-10-01.SDR USAA070168Door Frame · crackedFWD FRAME OF FWD CARGO DOOR CUTOUT STA 440 RT NR 2 STOP HAS CRACK. CUT OUT DAMAGE, FAB'D DOUBLER & INSTALLED PER EA 98509, DEFECT SIZE: 1 INCH.SDR USAA070169Door Frame · crackedAFT FRAME OF FWD CARGO DOOR CUTOUT STA 492.4, RT S-24R HAS CRACK. CUT OUT DAMAGE, FAB'D DOUBLER, INSTALLED REPAIR PER EA 98508, DEFECT SIZE: 0.125 INCH.SDR 07FDEA00613Door Frame · misrepairedFOUND FWD LOWER CARGO COMPT, FWD DOOR JAMB AT STA 889 LONGS NR 43 RT AND 40 RT, EXISTING REPAIR AT WEB AND DOOR FRAME. REMOVED WEB REPAIR, FRAME SPLICE REPAIR TWO INTERNAL ANGLE SPLICE AND OPEN WEB AS REQ`D FOR ACCESS IAW SRM 51-30-00 VOL 2. REMOVED AND REPLSDR 2007UALA00612Unknown · vibrationWHILE DEPARTING FELT VIBRATION FOR APPROX FOUR MINUTES. F/A'S HEARD LOUD NOISE AROUND WING. DEBRIEFED CREW FLIGHT ATTENDANTS FELT VIBRATION IN FLOOR MID AREA OVER WINGS MOSTLY ON LEFT SIDE THROUGHOUT FLIGHT. NOISE DECREASED WHILE DESCENDING. 21 MARCH 07SDR SWAA071139Door Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND AFT CARGO DOOR CUTOUT FWD FRAME CRACKED AT LOWER CORNER. REPAIRED FRAME PER SRM.SDR 07FDEA00607Door Frame · damagedFOUND INTERNAL FUSELAGE AFT MAIN CABIN AT STA 1306 TO STA 1317 LONGS NR 26 RT AND 27 RT DOOR JAMB FRAME EXISTING DOUBLER REPAIR. PERFORMED INSPECT REPAIR IAW FEDEX EA NR 8-5350-105644 P1, INSTRUCTION 3.SDR 07FDEA00606Door Frame · damagedFOUND INTERNAL FUSELAGE AT STA 1250 TO STA 1257 LONGS NR 26 RT AND 27 RT DOOR JAMB FRAME EXISTING DOUBLER REPAIR. PERFORMED INSPECT REPAIR IAW FEDEX EA NR 8-5350-105644 P1, INSTRUCTION 2.SDR 07FDEA00598Door Frame · damagedFOUND AFT LOWER CARGO COMPT FWD JAMB DOOR FRAME, EXISTING REPAIR AT STA 1781 LONG NR 40 TO 42 LT. REMOVED 2 PLATE CONTAINER GUIDE AND 2 SUPPORT LINING SUPPORT AND WEB COVER IAW SRM 51-30-00 VOL 2. PERFORMED GVI, FOUND IN COMPLIANCE WITH CRITERIA REQUEST BY E
Back to JASC 5310