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 TRAX200700462Crossbeam · corrodedRIGHT FS 280 CROSSBEAM HAS CORROSION ON UPPER FLANGE. REMOVED RT FS 280 CROSSBEAM IAW CRJ 700 SRM 51-42-06 AND 51-42-21. LOCATED NEW SERVICEABLE CROSSBEAM IAW CRJ 700 SRM 51-40-11.SDR TRAX200700461Crossbeam · corrodedLEFT FS 280 CROSSBEAM HAS CORROSION ON UPPER FLANGE. STARTED REMOVING FASTENERS FROM LT 280 BEAM IAW CRJ 700 SRM 51-42-21 AND 51-42-06. CONTINUED TO REMOVED FASTENERS FROM 280 CROSSBEAM IAW CRJ 700 SRM 51-42-21 AND 51-42-06. FINISHED REMOVING FS 280SDR TRAX200700459Beam · corrodedTHE 280 BEAM CORRODED LBL 9-14. REMOVED AND REPLACED 280 CROSSBEAM IAW IS67053110026 AND REO 670-53-11-047.SDR 07FDEA01322Beam · corrodedFOUND CORROSION WITH EXFOLIATION ON BEAM AT STA 1099 LONGERON 43 LT. REPAIRED BEAM IAW SRM 53-60-01 FIGURE 3 VOL 1.SDR 07FDEA01280Beam · crackedFWD CARGO COMPT CRACK 2" ON LOWER BEAM STA 1099. REPAIRED BEAM IAW SRM 53-60-01 FIG 3 VOL 1.SDR DHL2007806523Door Frame · misrepairedREPAIR ON FWD UPPER JAMB CORNER OF "B" CARGO DOOR IS NOT IN ACCORDANCE WITH DWG SR08530019 (STA 520.000 - 540.000 L-25R TO L-27R) MAJOR REPAIR. PERFORMED MAJOR REPAIR IAW AD2005-18-07, S/B DC8 53-078, DOUGLAS DWG NR SR08530019, 5750776. REMOVED EXISTING NON SDR DHL2007806519Door Frame · misrepairedREPAIR ON FWD UPPER JAMB CORNER OF "C" CARGO DOOR (STA 1160.000 - 1180.000, L-21R TO L-23R) IS NOT IN ACCORDANCE WITH DWG NR SR08530019 (MAJOR REPAIR). PERFORMED MAJOR REPAIR IAW AD2005-18-07, S/B DC8 53-078, DOUGLAS DWG NR SR08530019, 5750776. REMOVED NON SSDR 2007UALA00985Door Frame · dentedDENT IN FUSELAGE FWD OF AFT CARGO DOOR. LOCATED ON FWD DOOR FRAME, 19 INCHES FROM BOTTOM OF DOOR. DAMAGE IS ACROSS SEVERAL FLUSH RIVET HEADS. ALSO HAS A CRACK IN THE OUTER SKIN. *S/D* MAJOR REPAIR: DAMAGE REMOVED, FABRICATED AND INSTALLED REPAIR PARTS. SDR MWEA070070Window Frame · corrodedCENTER WINDSHIELD LOWER FRAME HAS LIGHT CORROSION. FABRICATED AND INSTALLED ZEE.SDR COMA0770021Crossbeam · corrodedFS 280.0 CROSSBEAM CORRODED. REPAIRED IAW REO 670-53-11-047.SDR CALA0700162Door Frame · crackedINSPECTION FOUND A .5 INCH CRACK IN FORWARD CARGO DOOR CUTOUT FORWARD FRAME WEB AT LOWER DOORSTOP FITTING, WL 160, S24R. THE FRAME WAS REMOVED AND REPLACED IAW SRM 51-40-02.SDR 07FDEA01189Fitting · crackedMAIN CARGO DECK FRAME 12A FITTING RT SIDE FOUND CRACKED. REMOVED AND REPLACED FITTING ON EO NR 6-5340-7-5002 A PART 2 AND PART 3.SDR UPS07M49813Door Frame · damagedINSPECTION TYPE:C AFT CARGO DOOR FWD AND AFT JAMBS HAS SCALLOPED IN SEVERAL AREA. REMOVED HEAT DUCT ON AFT CARGO STA 1926 PER AMM20-50-02 REV 50. FWD & AFT JAMB FASTENERS REMOVED PER SRM 51-31-01 VOL 2 REV 38. HFEC INSP CUT OUT FOUND NO CRACK. REPAIR DOUBLSDR DLM88070453Door Frame · corrodedSTRUCTURAL REPAIR AT THE FWD CARGO DOOR JAMB - EXFOLIATION CORROSION. CORROSION REMOVED, PERMANENT REPAIR INSTALLED PER SRM 53-05D, FIG 804D.SDR DHL2007786504Torque Box · crackedCRACK AT LIGHTENING HOLE, RT LOWER TORQUE BOX STA 1329. STOPPED DRILLED 0.250" DIAMETER HOLE AT LIGHTENING HOLE RT LOWER TORQUE BOX STA 1329 IAW B727 SRM 51-40-2. NDT C/W HFEC FOR CRACK STOP VERIFED, IAW B727 NDTM, PT6 51-00-00 FIG 23. FABRICATED DOUBLER RESDR NWAA071279956Door Frame · chafedDURING "H" CHECK, FOUND CHAFING DAMAGE TO MAIN CABIN RT EMERGENCY EXIT LOWER JAMB AT BS 666 AND BS 707. REPAIRED PER EA 99-208476.SDR 07FDEA01146Crossbeam · misrepairedPREVIOUSLY INSTALLED REPAIR FOUND ON CROSS BEAM AT FRAME 36 YA TO YB DOES NOT FOLLOW SRM CRITERIA. REMOVED PREVIOUSLY INSTALLED REPAIR ANGLES IAW SRM 51-40-21. FABBED NEW ANGLES IAW SRM 53-10-15 FROM 60-15 36/15 7075-0 AND HEAT TREATED ON MAE TRAV T7/670475.SDR DLM90070262Pan · corrodedFOUND LWR FLANGE OF FWD CARGO DOOR CUTOUT CORRODED. REPAIR PER SRM 51-70-01 FIG 1 REF N/R 1400-0343 AT HMV 2.SDR CALA0700147Door Frame · crackedINSPECTION FOUND A .75 INCH CRACK IN FORWARD CARGO DOOR CUTOUT FORWARD FRAME LOWER STOP PAD AT STA 440, S24R. THE FRAME WAS REPLACED IAW SRM 51-40-02.SDR CALA0700146Door Frame · crackedINSPECTION FOUND A .75 INCH CRACK IN FORWARD CARGO DOOR CUTOUT AFT FRAME LOWER STOP PAD, STA 480, S24R. THE AFT FRAME WAS REPLACED IAW SRM 51-40-02.SDR A6WA200740209Support Beam · crackedCARGO DOOR SUPPORT BEAM LOWER ANGLE THAT ATTACHES TO REAR PRESSURE BULKHEAD IS CRACKED .4 INCH IN LENGTH. MAINTENANCE REMOVED AND REPLACED CARGO DOOR SUPPORT BEAM LOWER ANGLE IAW CRJ 200 SRM 51-42-21. (M)SDR UPS07849635Door Frame · damagedINSPECTION TYPE:C2 REMOVE STEEL DOUBLER FROM C-2 (B-PIT) DOOR JAMB UPPER FWD CORNER AND REPAIR PER DC8 SRM 53-2-0 FIG 20. REMOVED STEEL DOUBLER FROM B-PIT DOOR JAMB UPPER FWD CORNER IAW SRM 51-01-21A. FABRICATED AND INSTALLED CORRECT TRIPLER, DOUBLER, AND FISDR UPS07849627Door Frame · damagedINSPECTION TYPE:C2 REMOVE STEEL DOUBLER FROM C-3(C-PIT) DOOR JAMB LWR FWD CORNER AND REPAIR PER DC8 SRM 53-2-0, FIG 22 AND/OR DWG SRO8530019. REPAIRED DOOR CORNER IAW SAA EA 008-5310-01-A0755.SDR A6WA200740162Vertical Beam · crackedFS 409.0 + 128.0 VERTICAL BEAM AT RBL 27.0 IS CRACKED .4 INCH. (K) [SUP 05-09-07] MAINTENANCE TRIMMED OUT DAMAGED AREA, PERFORMED EDDY CURRENT, FABRICATED REPAIR ANGLE AND INSTALLED IAW BOMBARDIER REO 601R-53-41-056 REV E AND BSC EO 601R-53-11286. (M)SDR K11A2008112572403Beam · damagedTRANSVERSE LOWER CHORD BEAM DAMAGED.SDR DHL2007762501Torque Box · gougedLEFT AFT AIR STAIRS TORQUE BOX LIGHTING HOLE GOUGED BS 1320. ROUTED OUT GOUGED AREA, MATERIAL LOSS .008 IAW B727 SRM 53-30-1 FIG 1. FAB REPAIR DOUBLER 4" BY 2.5" BY .050, 7075T6 IAW B727 SRM 53-10-2 FIG 6 AND 51-40-1, FIG 1. TREATED ALODINE AND PRIMED IAW BSDR SWAA071543Crease Beam · crackedDURING SCHEDULED 18Y CHECK, FOUND CREASE BEAM WEB CRACKED AT BS 192.5, STR 17R. REPAIRED WEB PER SRM.SDR 07FDEA01093Beam · damagedDURING SB: A310-53-2095, FOUND ENLARGED HOLES ON AFT CARGO DOOR ACTUATOR BEAM BETWEEN C61-C62. REPLACEMENT OF EXISTING BEAM (A537-81256-002) BY NEW ONE IAW SRM 51-72-10.SDR UPS07M49856Panel · crackedINSPECTION TYPE:C AFT FUSELAGE COMPARTMENT, ADJACENT STA 2011 AT UPPER TORQUE BOX RT ACCESS DOOR CUTOUT EDGE, PLANE PANEL FOUND CRACKED. CRACKED AREA TRIMMED PER EN1223-07. HFEC INSP C/O DAC NDTSPM R13 06-10 -01.001 ON TRIM AREA, FOUND NO CRACK EVIDENT. FILSDR CA070321008Beam · cracked(CAN) WEB P/N 205-030-163-395 FOUND CRACKED AT INDUCTION BAFFLE SUPPORT WL 80.13. THE CRACK WAS APPROX 1 INCH IN LENGTH AND .5 INCH DOWN . REPAIR SCHEME IN PROGRESS THROUGH MFG. (TC NR 20070321008)SDR 07FDEA01051Crease Beam · misrepairedCABIN FLOOR CREASE BEAM RT INNER CHORD HAS 7 PLUGGED HOLES BS 740-760, REPLACED CABIN FLOOR CREASE BEAM ANGLE AT CREASE BEAM STA 740-760 ON RT SIDE AT RBL 63" REFERENCE SRM 51-30-2.SDR 2007UALA00828Crease Beam · corrodedAFT GALLEY DOOR INNER CHORD OF CREASE BEAM CORRODED STA 967-977 LBL 45-49, WL 208-208. REMOVED CORROSION. REFERENCE SRM 53-60-51 PAGE 6 ITEM 105 THRU 113.SDR USAA070225Structure · damagedSTA 760, S4R, SKIN FASTENER & STRINGER SECTION HAS HOLE. CUT OUT SECTION OF STRINGER, FAB'S SPLICE, NEW CLIP & INSTALLED PER SRM 53-00-03, FIG 201 REP 3, DEFECT SIZE: .1875 INCH.SDR 2007UALA00853Unknown · vibrationEXCESSIVE VIBRATION ON APPROACH FLAPS 5. FOUND E&E DOOR SEAL DAMAGED AT TWO PLACES AND FREEPLAY AT ELEV TRIM TAB IS OUT OF LIMITS. REPLACED E&E DOOR SEAL AND REPLACED THE FLANGED BUSHINGS ON ELEVATOR FITTING FOR TAB ATTACH HINGE AT POSITIONS NR 1, 3, AND 4.SDR 07FDEA00991Crease Beam · damagedCABIN LT CREASE BEAM INNER CHORD HAS 5 EA PLUGGED HOLES WL 208, BS 740 - 760. REMOVED SUPPORT ANGLE, AND INSTALLED NEW SUPPORT ANGLE, REFERENCE SRM 51-30-02. CLASSIFIED AS MAJOR REPAIR.SDR DLM90070240Door Frame · crackedFOUND FWD ENTRY DOOR JAMB AFT WEB CRACKED FS 200. FAB AND INST REPAIR IAW SRM 51-11-01 PG 05.SDR TRAX200700376Door Frame · crackedPAX DOOR FRAME CRACKED AT FS 338. REPAIRED PAX DOOR FRAME IAW EO'S REO 601R-52-11-1205 AND REO 601R-52-11-402.SDR TRAX200700372Frame · corrodedCORROSION ON FRAME LEG AT FS 310 BETWEEN STR 26L TO 26R.SDR SWAA071412Crease Beam · corrodedDURING SCHEDULED 18Y CHECK, FOUND CREASE BEAM WEB CORRODED AT BS 816, RBL 68. REMOVED AND REPLACED CREASE BEAM WEB PER SRM.SDR SWAA071411Crease Beam · corrodedDURING SCHEDULED 18Y CHECK, FOUND CREASE BEAM WEB CORRODED AT BS 510, LBL 68. REMOVED AND REPLACED CREASE BEAM WEB PER SRM.SDR 07FDEA00972Door Frame · corrodedFWD PIT BILGE STA 879 LWR SURFACE OF TOP FLANGE OF WEB CORRODED AT LONGERON 43R. ACCOMPLISHED REPAIR PER EA FUSELAGE FWD LOWER CARGO DOOR JAMB FRAME STA 866 CHORD REPAIR {8-5310-105181}.SDR 07FDEA00971Door Frame · corrodedFWD PIT BILGE STA 879 LWR SURFACE OF TOP FLANGE OF WEB CORRODED AT LONGERON 43R. ACCOMPLISHED REPAIR PER EAM FUSELAGE FWD LOWER CARGO DOOR JAMB FRAME STA 866 CHORD REPAIR {8-5310-105181}.SDR 07FDEA00952Crossbeam · corrodedFOUND CORRODED CROSSBEAM AT C67, Y-1070-1115. PART REPLACED IAW SRM 51-72-10.SDR 07FDEA00951Beam · damagedTWO LONGITUDINAL BEAMS BETWEEN C64-65, -Y 525 AND Y 805 WITH WRONG EXISTING HOLES. PARTS REPLACED IAW SRM 51-72-10.SDR 07FDEA00928Door Frame · damagedOLD MARKS ON FWD CARGO DOOR FRAME FWD LOWER CORNER. REPAIR WAS PERFORMED BY BLEND OUT WITH LHT SDR.SDR 2007UALA00789Door Frame · crackedTHE 2L MED UPPER HINGE FRAME CUTOUT LWR RADIUS CRACKED. MAJOR REPAIR ACCOMPLISHED: COMPLETED A DOUBLER REPAIR ACCORDING TO A BOEING APPROVED REPAIR.SDR 2007UALA00779Unknown · vibrationFLIGHT DIVERTED DUE TO AN AIRFRAME VIBRATION. UNIDENTIFIED RUMBLE- VIBRATION VERY STRONG AFT GALLEY MIDDLE FLOOR. FOUND WATER FILL VALVE OPEN, CLOSED VALVE. SERVICE PANEL HAD ICE CHUNKS BANGING AROUND INSIDE CAUSING NOISE. CLEANED OUT PANEL AND CLOSED. REMOVSDR COMA0760260Crossbeam · corrodedFS 280 CROSSBEAM CORRODED. REPAIRED CROSSBEAM IAW REO 601R-53-21-069.SDR AWXA200700367Door Frame · crackedMCN - FOUND FORWARD CARGO COMPARTMENT DOOR CUT OUT FORWARD FRAME CRACKED, BS 492, S24R - S25R, AT THE LOWER DOOR STOP FITTING. REPAIRED FORWARD CARGO COMPARTMENT DOOR CUT OUT FORWARD FRAME, BS 492, S24R - S25R, AT THE LOWER DOOR STOP FITTING IAW AWA ER 03-533SDR 07FDEA00904Crossbeam · corrodedFOUND CORROSION AT CROSS BEAM C63 LT. CROSS BEAM REPAIRED IAW SRM 53-10-15, PAGE 241/242.
Back to JASC 5310