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 USAA070063Door Frame · crackedFWD CARGO DOOR/FWD FRAME AT 1F FOOTPRINT HAS CRACK. REMOVED DAMAGE & INSTALLED FABRICATED REPAIR PARTS FROM EA 98414, DEFECT SIZE: 2 INCHES.SDR UIEA200700015Crease Beam · crackedM/DECK STA 940-960 S-7R TO S-8R CREASE BEAM WEB FOUND CRACKED. REPAIRED ACCOMPLISHED AS PER SRM 51-10-01.SDR ZZDA070123108Structure · crackedAIRCRAFT LEFT TAXI WAY NOSE GEAR STUCK IN MUD. TEE CAP AT STA 110 CRACKED AND BENT BEYOND REPAIR. REPAIRED TEE CAP AT STA 110 PER MDC DRAWING 9911509 REV L DATED 5/13/02 AND PER BOEING ENGINEERING ROD/SKETCH NUMBER 06-12-10-003-001, 8100-9 APPROVED ON 01-07-SDR SWAA070327Door Frame · crackedDURING SCHEDULED SPV CHECK, FOUND AFT CARGO DOOR CUTOUT AFT FRAME CRACKED AT BS 847, STR 18R. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR CA070122003Shroud · cracked(CAN) DURING A ROUTINE 100 HR ENGINE/AIRFRAME INSP, IT WAS NOTED THAT THE SUBJECT SHROUD WAS CRACKED JUST AFT OF THE UPPER/AFT MOUNTING SCREW LOCATION. THE SHROUD IS PART OF A SERIES OF SHROUD COVERS THAT SURROUND THE ENGINE FOR COOLING PURPOSES. THE SHROUD HASDR USAA070049Door Frame · crackedBS 492 S-24R DOOR FRAME CRACKED. REPAIRED PER EA 98396, DEFECT SIZE: .625 INCH.SDR AWXA200700297Door Frame · crackedMCN - FOUND AFT CARGO DOOR LOWER FORWARD FRAME CRACKED, BS 800, S22R - S25R. REPLACED AFT CARGO DOOR LOWER FORWARD FRAME, BS 800, S22R - S25R IAW B737-300 SRM 51-40-02.SDR DHL2007802507Door Frame · unknownPERFORM REPAIR/MODIFICATION OF FWD PAX DOOR UPPER AFT JAMB CORNER IAW AD2000-20-08, DWG SR08530021 (MAJOR REPAIR). PERFORMED MAJOR REPAIR IAW AD2000-20-08, S/B DC8 53-075, DOUGLAS DWG SR08530021, 5750776. REMOVED FASTENERS IAW SRM 51-1-21, SRM 51-1-20D. PERSDR DHL2007802506Door Frame · unknownPERFORM REPAIR/MODIFICATION OF FWD PAX DOOR LWR FWD JAMB CORNER IAW AD2000-20-08, DWG SR08530021 (MAJOR REPAIR). PERFORMED MAJOR REPAIR IAW AD2000-20-08, S/B DC8 53-075, DOUGLAS DWG NR SR08530021, 5750776. REMOVED FASTENERS IAW SRM 51-1-21, SRM 51-1-20D. PESDR SWIA200718022Window Post · crackedCRACK ON CAPTAIN'S SIDE LOWER DV WINDOW BEAM AT VERTICLE WINDOW POST AREA. (DISCOVERED DURING C-CHECK INSPECTION) REPLACED CAPTAIN'S SIDE DV WINDOW BEAM IAW SRM 51-10-02 PG SEC. 3A AND RII 53-800-1000.SDR AWXA200700275Door Frame · crackedMCN - FOUND R1 DOOR CUT OUT FORWARD UPPER FRAME CRACKED, BS 294, S8L - S10L. REPLACED R1 DOOR CUT OUT FORWARD UPPER FRAME, BS 294, S8L - S10L IAW B737-300 SRM 51-40-02.SDR DLM88070435Door Frame · corrodedEXFOLIATION CORROSION ON DOOR JAMB AFT CARGO COMPARTMENT - LOWER SECTION. CORROSION REMOVED AND PERMANENT REPAIR INSTALLED PER SRM 53-05D FIG 63.SDR DLM88070434Door Frame · corrodedSUPERFICIAL CORROSION O AFT PASS DOOR JAMB - CORROSION ON LOWER HORIZ SECTION OF AFT PAX DOOR JAMB FWD SURFACE NEAR STA 1338. CORROSION REMOVED, PERMANENT REPAIR INSTALLED PER SRM 53-05D FIG 34.SDR 07FDEA00131Window Frame · maint errorL - ANGLE ATTACHED TO FS 950E FRAME JUST BELOW WINDOW ON AFT SIDE OF FRAME HAS 1 EACH MISSDRILLED HOLE REMOVED DAMAGE. FABRICATED REPAIR ANGLES, TREATED, PRIMED AND INSTALLED REPAIR PIECES REF SRM 51-30-02 PG 32 AND SRM 51-10-02 PG. 1. CLASSIFIED AS A MAJOR SDR LR7A07006Window Frame · crackedDURING SCHEDULED B 2 CHECK PER JOB CARD HB5301, FOUND LT DV WINDOW FRAME CRACKED AT FS 124, WL 251.5 - WL 255. REPAIRED FRAME IAW SMP583 53-30-25 AND LAC MEA 382-53-07-002.SDR 2007UALA00114Door Frame · crackedFWD CARGO DOOR CUTOUT, AFT DOORWAY FRAME BS 492 IS CRACKED IN TWO PLACES JUST ABOVE LOWER STOP FITTING. MAJOR REPAIR: INSTALLED NESTED DOUBLER FRAME REPAIR PER AAR EA I060559 AND UA EVA 70030 ON AAR NR11660-1400-0001.SDR SWAA070235Door Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FWD CARGO DOOR CUTOUT FWD FRAME CRACKED AT NR 5 DOOR STOP. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA070234Hinge Fitting · crackedDURING SCHEDULED 10Y CHECK, FOUND L1 DOOR CUTOUT FWD FRAME LOWER HINGE FITTING UPPER HALF CRACKED. REMOVED AND REPLACED HINGE FITTING PER SWA EA AND SB.SDR QXEA200700057Door Frame · damagedC2 PDX - REPLACE BURNED RIVET LOCATED AT FS 292.2 12" BELOW TOP OF MAIN CABIN DOOR FRAME. REPAIRED IAW SRM 51-42-06 AND 53-21-01.SDR AWXA200700151Door Frame · corrodedMCN - FOUND CORROSION ON L2 DOOR CUT OUT INNER CHORD, BS 967 - BS 986.5, LBL 62, WL 208. REPLACED L2 DOOR CUT OUT INNER CHORD, BS 967 - BS 986.5, LBL 62, WL 208 IAW B737-300 SRM 51-40-02.SDR 0700306740Tension Tie · crackedDURING "M" CHECK, FOUND CRACK IN TENSION TIE LT FORWARD CHANNEL AT BS 780. REPAIRED PER EA 67-208610.SDR 0700296740Tension Tie · crackedDURING "M" CHECK, FOUND CRACKS IN TENSION TIE RT FRAME DOUBLER AND LT FRAME AT BS 820. REPAIRED PER EA 67-207929.SDR 0700286740Tension Tie · crackedDURING "M" CHECK, FOUND CRACK IN TENSION TIE FORWARD CHANNEL AT BS 880. REPAIRED PER EA 67-207926.SDR 0700276740Tension Tie · crackedDURING "M" CHECK, FOUND CRACKS IN FRAME TENSION TIE AT LT FORWARD AND RT AFT CHANNELS AT BS 800. REPAIRED PER EA 67-207924.SDR 07FDEA00118Beam · corrodedAFT CARGO COMPT AREA FOUND CORROSION WITH EXFOLIATION ON BEAM AT STA 1902 BTWN X=0 CTR & X= 20 LT. REPAIRED BEAM IAW SRM 53-00-01 VOL 1 FIG 8. FABRICATED PARTS IAW DETAIL PARTS TRAVELER I025371/N00371 IAW SRM 53-30-00 VOL1 FIG 5 AND SRM 53-00-01 VOL 1 FIG 8.SDR QXEA200700088Structure · damagedC2 PDX - FOUND EVIDENCE OF LIGHTNING STRIKE ON RIVET HEAD AT FS 273 STRINGER 22R. REPAIRED IAW SRM 51-42-06, 53-00-01, 51-21-11, 51-25-01.SDR AWXA200700152Door Frame · crackedMCN - FOUND FORWARD CARGO COMPARTMENT DOOR CUT OUT AFT FRAME CRACKED, BS 492.50, S24R. REPAIRED FORWARD CARGO COMPARTMENT DOOR CUT OUT AFT FRAME, BS 492.50, S24R IAW AWA ER 03-5331-07032-ES2.SDR 0700326740Tension Tie · crackedDURING "M" CHECK, FOUND CRACK IN LT TENSION TIE FORWARD CHANNEL AT BS 840. REPAIRED PER EA 67-208612.SDR SWIA200717657Window Frame · crackedFRAME BEHIND CAPT'S DV WINDOW CRACKED, DISCOVERED DURING C-CHECK INSPECTION. REPLACED FRAME BEHIND CAPT'S DV WINDOW IAW SRM 120 51-10-02 PG 3 SEC 3A AND RII 53-800-1000.SDR 2007UALA00083Crease Beam · corrodedAFT GALLEY DOOR TRESHOLD SEAL AREA HAS NUMEROUS SPOTS OF CORROSION, CREASE BEAM INNER CHORD CORRODED STA 947.5 - STA 994. 5 STR 17R RBL 44 TO RBL 52. MAJOR REPAIR: REMOVED AND REPLACED CREASE BEAM PER SRM 51-40-02 AND SRM 51-20-01.SDR SWAA070168Door Frame · crackedDURING SCHEDULED SPV CHECK, FOUND AFT CARGO DOOR CUTOUT AFT FRAME CRACKED AT NR 5 DOOR STOP. REPAIRED FRAME SECTION PER ER.SDR UIEA200700004Door Frame · crackedAT XMN UNDER C-1 CHECK, DURING PERFORMING EO NR 4753A531 AS PER AD 2005-22-06.AS PER NR NR 215, CRACK FOUND DURING HFEC AT BS488 ME DOOR 1L CUT OUT FRAME WEB AT STOP 9. RECTIFICATION, BS 488 MED 1L DOOR FRAME WEB REPAIRED AS PER SRM 53-10-04 FIG 121.SDR KCSA071010Tension Tie · crackedFUSELAGE TENSION TIE FORWARD CHANNEL IS CRACKED (1 INCH) AT UPPER FLANGE STA. 920, LBL 15.SDR KCSA071006Shear Web · crackedFUSELAGE LT SLOPING SHEAR WEB IS CRACKED (1 INCH) AT STA. 820, LBL 77, STR. 9L.SDR KCSA071005Shear Web · crackedFUSELAGE RT SLOPING SHEAR WEB IS CRACKED (1 INCH) AT STA. 820, RBL 77, STR. 9R.SDR SWAA070122Door Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND L1 DOOR CUTOUT AFT LOWER FRAME CRACKED AT BS 348, WL 209. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR COEA0704903Window Frame · dentedDURING HEAVY CHECK MAINTENANCE FOUND DENT ON CAPTAIN WINDSHIELD FRAME UPPER POST. REMOVED WINDSHIELD, NO CRACKS FOUND. DENT DRESSED BACK PER DO/TS-386/07-8256. WINDSHIELD INSTALLED. REFERENCE SRAS DO/TS-386/07. 3978 AS A PERMANENT REPAIR. (M)SDR UPS07449116Doubler · corrodedINSPECTION TYPE:C L/G - LT WLG W/W AT BS1245 LBL0 HYD TUBE CUTOUT DOUBLER FOUND CORRODED CRACKED. CORROSION BLEND OUT 0.045" BY 1/2" BY 4" EXCEED SRM LIMIT. DOUBLER REPLACED AS PER SRM 51-10-01 P9 AND INSTALLED AS PER SRM 51-30-02.SDR 2007UALA00073Door Frame · crackedFWD ENTRY DOOR AFT FRAME CRACKED AT 4TH STOP FROM BOTTOM. REMOVED DAMAGE. FABRICATED AND INSTALLED EXTERNAL DOUBLER REPAIR PER SRM 51-70-11 PAGE 1-6.SDR HALA0700016Door Frame · damaged3.5 INCH SCRATCH IN FUSELAGE AT TOP RIGHT CORNER OF C 2 DOOR FRAME. SCRATCH WITHIN SRM 53 00 01 LIMITS CLEANED SCRATCHES PER FIGURE 101. NO FLIGHT RESTRICTIONS OK FOR SERVICE ALLOWABLE DAMAGE PER FIG 101.SDR SWIA200717850Door Frame · crackedPAX DOOR FRAME FS 323.5 IS CRACKED ON INNER FLANGE, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED NEW FRAME PER CRJ200 SRM 31-42-06 AND SRM 51-42-21.SDR SWIA200717849Door Frame · crackedPAX DOOR FRAME FS321.5 IS CRACKED ON INNER FLANGE, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED FRAME INSERT, SPLICES, SHIM AND CLEAT PER REO 601R-52-11-402.SDR SWIA200717848Door Frame · crackedPAX DOOR FRAME FS336 HAS A CRACK ON INNER FLANGE, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED NEW FRAME PER CRJ200 SRM 51-42-06 AND SRM 51-42-21.SDR SWIA200717847Door Frame · crackedPAX DOOR FRAME FS388 HAS A CRACK ON INNER FLANGE, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED FRAME INSERT, SPLICES, SHIM AND NEW CLEAT PER REO 601R-52-11-402.SDR N921R53410Door Frame · crackedFUSELAGE STA 8 NLG W/W DOOR JAMB RT CORNER SKIN WITH 1" CRACK. REPAIRED SKIN IAW FLIGHT VEHICLES CONSULTING INC DWG NR 51-07030-1 REV NEW 01-25-07 PAGE 1 AND 2. ISSUED FAA FORM 8110-3 CPCP 4000 0551.SDR SWAA070074Door Frame · crackedDURING SCHEDULED C2 CHECK, FOUND AFT CARGO DOOR FWD FRAME CRACKED AT BETWEEN NR 2 AND NR 3 STOP FITTINGS. REMOVED AND REPLACED CARGO DOOR PER MM.SDR UPS07448875Vertical Beam · crackedINSPECTION TYPE:C NWW TUNNEL RT BS 320 VERTICAL BEAM WEB WL 190 STAND OFF HOLE FOUND CRACKED. NWW RT TUNNEL BS 320 VERTICAL BEAM WEB REPLACED AS PER SRM 51-10-01 P9 AND INSTALLED AS PER SRM 51-30-02.SDR UPS07449147Plate · misrepairedINSPECTION TYPE:C M/D RIGHT BS 900 TENSION TIE ATT STEEL PLATE FOUND SHORT EDGE MARGIN. M/D RIGHT BS 900 TENSION TIE ATTACH STEEL PLATE SHORT EDGE MARGIN REPAIRED AS PER RS R53-25-35715. CONTINUE INSPECTION IS REQUIRED AS PER RS R53-25-35715 AND UPS EO B747SDR UPS07449146Plate · misrepairedINSPECTION TYPE:C M/D LEFT BS 780 TENSION TIE ATT STEEL PLATE FOUND SHORT EDGE MARGIN. M/D LEFT BS 780 TENSION TIE ATTACH STEEL PLATE SHORT EDGE MARGIN REPAIRED AS PER RS R53-25-35713. CONTINUE INSPECTION IS REQUIRED AS PER RS R53-25-35713 AND UPS EO B747-53SDR UPS07449145Tension Tie · crackedINSPECTION TYPE:C M/D LEFT BS 940 TENSION TIE TO FRAME CONNECTION FOUND 1EA HOLE CRACK AT TENSION TIE AFT CHANNEL RUNNING UP THRU THICKNESS APPROX 0.060 INCH, CRACK LENGTH 0.060 INCH. M/D LT BS 940 TENSION TIE LT AFT CHANNEL REPAIRED AS PER RS R53-25-35712.
Back to JASC 5310