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 SWAA061499Crease Beam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND CREASE BEAM WEB CORRODED AT LEFT BS 500. REPAIRED CREASE BEAM WEB PER SWA EA AND SRM.SDR QXEA200601239Panel · chafedPDX - C3 AFT APERTURE FLANGE CHAFED FOR PANEL 212AR. REPAIRED IAW SRM 53-00-00 AND SRM 51-21-01.SDR QXEA200601238Panel · chafedPDX - C3 AFT APERTURE FLANGE CHAFED FOR PANEL 211AL. REPAIRED IAW SRM 53-00-00 AND SRM 51-21-01.SDR SWAA061476Crease Beam · crackedDURING SCHEDULED 1/4D CHECK, FOUND CREASE BEAM WEB CRACKED AT BS 360, STR 17L. REPAIRED CREASE BEAM PER SWA EA AND SRM.SDR A6WA200640169Support Channel · crackedFOUND FS 574 BAGGAGE DOOR CAM TRACK LOWER SUPPORT CHANNEL P/N 601R-35050-25 IS CRACKED .75 INCH LONG. REMOVED AND REPLACED CHANNEL, P/N 601R35050-25 IAW CRJ SRM 51-42-06. (M)SDR DU4R2006432Door Frame · corrodedCORROSION LT AC BAY DOOR HINGE FRAME FROM BS 900 TO 1040. FABRICATED AND INSTALLED REPLACEMENT BEAM 38 X 1.625 X 2.875 X 1.5 INCHES FROM BAC1505-10047 IAW B757 SRM 51-20-01 AND 51-40-02.SDR SWAA061453Window Post · crackedDURING SCHEDULED 1/4D CHECK, FOUND COCKPIT R1 WINDOW POST CRACKED. REPAIRED WINDOW POST PER SRM.SDR QXEA200601532Door Frame · damagedYYC C3 SERVICE DOOR, FORWARD AND AFT VERTICAL FRAMES HAVE NUMEROUS CUT MARKS FROM BOX CUTTERS. REPAIRED IAW RD 8/4-52-255, ISSUE 2 AND HORIZON AIR EA 6-52-455.SDR UPS06246878Door Frame · crackedINSPECTION TYPE:C NDT CONFIRMED TWO CRACKS ON THE FWD FRAME OF THE FWD CARGO DOOR CUTOUT. REMOVED EXISTING REPAIR AND DOOR STOP IAW SRM 51-30-02. ANGLES BETWEEN STR 19R AND STR 24R REMOVED IAW SRM 51-30-02. FRAME WEB SKIN REMOVED IAW SRM 51-30-02. FRAME RESDR UPS06846845Door Frame · crackedINSPECTION TYPE:C3 VISUAL AND HFEC INSP DETECTED A .750" CRACK ON THE AFT UPPER DOOR JAMB OF THE C-4 DOOR. CUT OUT DAMAGED SECTION OF AFT UPPER DOOR JAMB OF THE C-PIT DOOR IAW SRM 53-2-0 FIG 21. FABRICATED AND INSTALLED FILLER, DOUBLER AND TRIPLER IAW SRM 53SDR UPS06146849Shear Plate · crackedINSPECTION TYPE:5YR SHEAR PLATE CRACKED AT FR 79/80 RBL 60 IN MAIN DECK CARGO COMPARTMENT. REMOVED & REPLACED SHEAR PLATE PER A300 SRM 51-40-21.SDR SWIA200616633Beam · damagedDAMAGE TO BEAM ASSY AT LOCATION FS 529.0 CAUSED BY RIGHT MLG DOOR PUSH PULL ROD. CUT OUT DAMAGED AREA AND INSTALLED DOUBLER AND FILLER IAW CRJ REO 601R-53-41-417 AND REO 601R-53-41-418.SDR MALA060273Post · corrodedDURING 2 YEAR CHECK IN BNA, FOUND LT COCKPIT DOOR POST AT FS 225 IS CORRODED AT FLOOR LEVEL AND HAS BEEN REPAIRED IAW MESABA EO S53185. REF: EAMS WORK ORDER 213767 TASK 1518.SDR ASAA0640512Door Frame · chafedAFT CARGO DOOR FWD LWR FRAME IS CHAFED. REMOVED AND REPALCED FWD LWR CARGO DOOR FRAME ON AFT CARGO DOOR PER SRM 51 40 02.SDR EIA2006101Door Frame · crackedFOUND 3 HOLES CRACKED R5 DOOR FRAME BS 2231. FABRICATED AND INSTALLED REPAIR PER B747 SRM 53-10-04 FIG 115 PG'S 689-705 AND EO 53-747-1601 REV D SEP 16.SDR 2006UALA00813Door Frame · gougedRT OVERWING EXIT HAS A DEEP GOUGE ON AFT FRAME STA 639 WL 237.SDR CALA0600143Beam · corrodedAFT ENTRY CORRODED AT STA 986.5 AND RBL 18. REPAIRED PER SRM 53-00-51, FIG 203, PG 208.SDR SWAA061399Structure · crackedDURING SCHEDULED C4 CHECK, FOUND L1 DOOR UPPER HINGE BOX CRACKED INTO RADIUS. R&R UPPER HINGE BOX PER SRM.SDR SWAA061398Crease Beam · corrodedDURING SCHEDULED 10Y CHECK, FOUND CREASE BEAM WEB CORRODED AT BS 460 TO BS 480, RBL 65. R&R WEB PER SRM.SDR SWAA061395Door Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME WEB CRACKED AT BS 794, AFT CARGO DOOR CUTOUT #5 STOP PAD. REPAIRED FRAME WEB PER ER AND SB.SDR SWAA061394Door Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 494, FWD CARGO DOOR CUTOUT #1 STOP PAD. REPAIRED FRAME SECTION PER ER AND SB.SDR SWAA061393Door Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 440, FWD CARGO DOOR CUTOUT #5 STOP PAD. REPAIRED FRAME SECTION PER ER AND SB.SDR ASAA0680473Beam · corrodedAFT CARGO DOOR CUTOUT LOWER BEAM CORRODED ON LOWER OUTBOARD FLANGE. REPLACED BEAM PER SRM 51 10 4 AND 51 30 5.SDR ABXA060177Repair · unknownPREVIOUS REPAIR FOUND AT BOTTOM AFT 2 DOOR STOPS OF FORWARD PASSENGER DOOR (REFER TO NEA53100033-001). REMOVED AND INSTALLED REPAIR IAW DWG SR09530252.SDR ASAA0640497Door Frame · corrodedFOUND CORROSION ON AFT CARGO DOOR CUTOUT LOWER CHORD. REMOVED AND REPLACED PER EA 5310 02613.SDR 06FDEA1577Structure · crackedBS 961, RBL 10, STR 29R AT BS 961, RBL 10, STR 29R, STRUCTURE IS CRACKED. REMOVED DAMAGE AND REPAIRED CHORD PER SRM 51-40-04.SDR TRAX200600132Plate · corrodedFOUND CORROSION ON HORIZ PLATE FS310 TO 349, UNDER PAX DOOR HINGE BL45 LT. REPAIRED CORROSION ON HORIZONTAL PLATE AT FS 310-349 IAW REO600-53-0341 (CLOSED)SDR DU4R2006398Door Frame · corrodedFOUND CORROSION IN RT AFT PIT LOWER CUTOUT. FABRICATED AND INSTALLED REPAIR DOUBLER 34" X 1.25" X 2.25" X 1.5" FROM 6AL-4V .040" IAW MD-88 SRM 53-05D FIG 63 AND 51-10-3.SDR DHL2006364511Structure · corrodedUPPER FUSELAGE LT STA 4641 (FS 75) STR 6L HAS CORROSION. REMOVED CORROSION AT UPPER FS LT STA 4641 (FS 75) STR 6L MAT. REMOVED .020 MAT, REMAINING.063 BEYOND LIMITS IAW A300 SRM 53-10-00. CUT OUT AREA OF DAMAGE 4" BY 3 1/2" IAW A300 SRM 53-10-00 FIG 701. ISDR SWAA061365Door Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FWD CARGO DOOR CUTOUT FWD FRAME CRACKED AT INBOARD CORNER. R&R FWD FRAME SECTION PER SRM.SDR QXEA200601124Stop · wornPDX - C4 MAIN CABIN DOOR AFT BOTTOM STOP ON APERTURE WORN. REPAIRED IAW RD 8-53-3933, PAGE 4, STEPS 4-7.SDR QXEA200601123Stop · wornPDX - C4 MAIN CABIN DOOR AFT TOP STOP GUIDE ON APERTURE WORN. REPAIRED IAW RD 8-53-3933, PAGE 4, STEPS 4-7.SDR QXEA200601122Stop · wornPDX - C4 MAIN CABIN DOOR FORWARD TOP STOP GUIDE ON APERATURE IS WORN. REPAIRED IAW RD 8-53-3933, STEPS 4 - 7.SDR QXEA200601121Stop · wornPDX - C4 MAIN CABIN DOOR FORWARD BOTTOM STOP ON APERTURE WORN. REPAIRED IAW RD 8-53-3933, PAGE 4, STEPS 4-7.SDR ASAA0640472Door Frame · corrodedAFT CARGO DOOR JAMB BOTTOM PAN CORRODED. REPLACED PER SRM 51 40 02 PG 34 FIG 10.SDR 2006FA0000579Door Frame · corrodedFORWARD FUSELAGE STRUTS (DOOR POSTS) CORRODED THROUGH FROM INSIDE OUT. THIS IS THE SAME DESIGN AS THE DOOR POST THAT ARE REQUIRED BY AD TO BE REPLACED EVERY 15 YEARS OR INSPECTED ANNUALLY BY ULTRASOUND. (K)SDR 2006UALA00751Structure · crackedAFT GALLEY DOOR, EXTERNAL FUSELAGE TORQUE TUBE ACCESS PANEL CUTOUT, LOWER FWD CORNER RADIUS CRACKED. INSTALLED EXTERNAL SKIN DOUBLER-TRIPLER PER SRM 53-60-01 REPAIR 8.SDR QXEA200601184Access Panel · corrodedPDX - C4 LAV ACCESS CUTOUT, THE LOWER EDGE HAS CORROSION AROUND ONE FASTENER. REPAIRED IAW DHC-8-200 SRM 51-20-11, RD 8-53-3299 AND HORIZON AIR EA 2-53-736.SDR USAA060596Strap · crackedFOUND STRAP CRACKED, BS 312 LBL 10. REPLACED PART WITH IDENTICAL PART, REMOVED CRACKED STRAP AND INSTALLED NEW STRAP IAW SRM 51-10-02, DEFECT SIZE: .50".SDR SWAA061339Crease Beam · corrodedDURING SCHEDULED 10Y CHECK, FOUND CREASE BEAM WEB CORRODED AT BS 346, RBL 64. REMOVED AND REPLACED CREASE BEAM WEB PER SRM.SDR DU4R2006386Door Frame · corrodedFOUND CORROSION AT FWD CARGO DOOR OPENING LOWER JAMB, AT AFT DOOR STOP, FS 408. CUT OUT CORRODED DOOR JAMB. FABRICATED AND INSTALLED DOOR JAMB PAN, SPLICE REPAIR AND ANGLE FROM 2024-T3 .030 AND .040 IAW MD-80 SRM 53-05 FIG 44.SDR UPS06246851Pin · corrodedINSPECTION TYPE:C BS 740 LT BOTTLE PIN FOUND CORRODED. REPLACED BS 740 LT SIDE IN CONJUNCTION WITH MM 57-41-01.SDR 2006UALA00747Door Frame · corrodedAFT CARGO DOOR CUTOUT FWD FRAME HAS CORROSION AT STA 794 BETWEEN STR 24R & 27R. INSTALLED EXTERNAL ANGLE DOUBLER REPAIR PER SRM 51-70-11 FIG 1.SDR 06FDEA1515Door Frame · corrodedR3 DOOR JAMB AREA FOUND WITH CORROSION. R3 DOOR JAMB AREA CARRIED OUT REPAIR AS PER SRM 53-50-00 FIG 17 VOL I. THIS REPAIR CLASSIFIED AS MAJOR AS PER FEDEX GMM 6-2-100.SDR DHL200786500Beam · corrodedHORIZONTAL WALKING BEAM AND CHORDS/HAVE HEAVY CORROSION ON LT SIDE BS 312 ON UPPER CHORD AREA, ALSO SOME CORROSION. REMOVED CORRODED VERTICAL ON LT WALKWAY BEAM AREA STA 312 IAW B727 SRM. CUT OUT CORRODED WEB SECTION AT STA 312 3" X 1.5" IAW B727 SRM 51-40-2SDR C2XA06SH047Door Frame · corrodedSHV - DURING C-CHECK THE AFT LOWER SERVICE DOOR CUTOUT FRAME WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED THE DAMAGED AREA AND INSTALLED A DOUBLER REPAIR IAW EC5310-01373. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR 06FDEA1513Door Frame · crackedMAIN CABIN INT STRUCTURE STA 1256 X107 LT FOUND 3EA CRACK ON LOWER L3 JAMB DOOR WEB. REPAIRED IAW SRM 53-50-00 FIG 19 SHT 1 VOL 1. FABRICATED PART IAW DETAIL PART TRAVELER F166702/N00702 AND IAW SRM 53-50-00 FIG 19 SHT 1 VOL 1.SDR QXEA200601193Door Frame · corrodedPDX - C4 CORROSION ON AFT LOWER PASSENGER DOOR FRAME. JUST FORWARD OF FRAME 253.4. REPAIRED IAW DHC-8-200 SRM 51-20-11, 2C (3), PAGE 7.SDR 2006UALA00728Door Frame · corrodedAFT PIT DOOR CUTOUT, FWD FRAME BS 794.3 CORRODED FROM RBL 16" - 20". INSTALLED NEW FRAME REPLACEMENT REPAIR PER SRM 51-40-02.SDR QXEA200601119Panel · chafedPDX - C4 REAR MATING SURFACE ON AIRCRAFT FOR PANEL 261NT HAS CHAFED AREA IN CENTER SECTION. REPAIRED IAW RD 8-57-1441 AND AMM 53-50-01.
Back to JASC 5310