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 SWAA061310Crease Beam · corrodedDURING SCHEDULED 10Y CHECK, FOUND LT CREASE BEAM WEB CORRODED BETWEEN BS 500 TO BS 500A, WL 208. REPAIRED WEB PER MM.SDR QXEA200601626Fitting · wornYYC - C3 FUSELAGE FORWARD PASSENGER AIRSTAIRS DOOR SURROUND STRUCTURE TWO AFT TOP STOP FITTINGS HAVE WEAR. REPAIRED IAW RD 8/4-53-1459 AND EA 6-53-664.SDR 2006UALA00715Crease Beam · corrodedCREASE BEAM WEB CORRODED BETWEEN BS 727B TO 727C AT STR 17 LT AT FLOOR LEVEL. REMOVED & REPLACED CREASE BEAM WEB REF SRM 53-40-02 & REPAIRED FLOORBEAM REF MM 53-10-95 REPAIR XII Y.SDR TRAX200600112Doubler · corrodedFOUND CORROSION ON DOUBLER, FS 522 - 529, BL44-41RT, RESOLVED ON W/O: 22159 TASKCARD: N/R-00203. REPAIRED CORROSION ON DOUBLER IAW T/C REO 601R-53-41-413.SDR TRAX200600094Doubler · corrodedFOUND CORROSION ON DOUBLER AT FS 509-513 - BL44-37RT. REPAIRED CORROSION ON DOUBLER IAW T/C REO 601R-53-41-413.SDR TRAX200600093Doubler · corrodedFOUND CORROSION ON DOUBLER AT FS 499-513 - BL44-41RT. REPAIRED CORROSION ON DOUBLER IAW T/C REO 601R-53-41-413.SDR TRAX200600090Doubler · corrodedFOUND CORROSION ON DOUBLER FS 555 TO 558- BL44-41RT. REPAIRED CORROSION ON DOUBLER IAW T/C REO 601R-53-41-413.SDR TRAX200600088Doubler · corrodedFOUND CORROSION ON DOUBLER AT FS 469-473 - BL42RT. REPAIRED CORROSION ON DOUBLER IAW T/C REO 601R-53-41-413.SDR TRAX200600086Doubler · corrodedFOUND CORROSION ON DOUBLER AT FS 484 - BL44-41RT. REPAIRED CORROSION ON DOUBLER IAW T/C REO 601R-53-41-413SDR TRAX200600080Doubler · corrodedFOUND CORROSION ON DOUBLER, FS 544 - 44-41RT. REPAIRED CORROSION ON DOUBLER IAW T/C REO 601R-53-41-413.SDR TRAX200600079Doubler · corrodedFOUND CORROSION ON DOUBLER, FS 540 - BL44-41RT. REPAIRED CORROSION ON DOUBLER IAW T/C REO 601R-53-41-413SDR TRAX200600072Structure · corrodedFOUND CORROSION AROUND NUTPLATE AT FS486 - BL43. C/W CORROSION AROUND NUTPLATE IAW E/C REO 601R-53-41-413.SDR TRAX200600077Unknown · corrodedFOUND CORROSION AROUND N/P AT FS558 - BL39RT, RESOLVED ON W/O: 22159 TASKCARD: N/R-00207. C/W CORROSION AROUND N/P IAW E/C REO 601R-53-41-413.SDR TRAX200600076Unknown · corrodedFOUND CORROSION AROUND N/P FS508 - BL43RT, RESOLVED ON W/O: 22159 TASKCARD: N/R-00202. C/W CORROSION AROUND N/P IAW E/C REO 601R-53-41-413.SDR TRAX200600073Unknown · corrodedFOUND CORROSION AROUND N/P AT FS 451- BL44-42RT, RESOLVED ON W/O: 22159 TASKCARD: N/R-00191. C/W CORROSION AROUND N/P IAW E/C REO 601R-53-41-413.SDR TRAX200600071Unknown · corrodedFOUND CORROSION AROUND N/P AT FS462 - BL43RT, RESOLVED ON W/O: 22159 TASKCARD: N/R-00192. C/W CORROSION AROUND N/P IAW E/C REO 601R-53-41-413.SDR TRAX200600069Structure · corrodedFOUND CORROSION AROUND N/P AT FS 468 - BL43RT, RESOLVED ON W/O: 22159 TASKCARD: N/R-00195. C/W CORROSION AROUND N/P IAW E/C REO 601R-53-41-413.SDR TRAX200600081Doubler · corrodedFOUND CORROSION ON DOUBLER AT FS 422-427 - BL44-37 LT, (RESOLVED ON W/O: 22159 TASKCARD: N/R-00215). BLENDED CORROSION ON DOUBLER IAW 53-41-45 REQUEST THICKNESS CHECK OF BLENDED AREA SM18595. COMPLIED WITH UT THICKNESS CHECK OF BLENDED AREA IAW CRJ NDTM 51-SDR TRAX200600097Doubler · corrodedFOUND CORROSION ON DOUBLER AT FS 439=BL42-44RT, RESOLVED ON W/O: 22159 TASKCARD: N/R-00216. BLENDED CORRODED AREA IAW CRJ 200 SRM 51-41-45 REQUEST THICKNESS CHECK OF BLENDED AREA DK 7022603 ALSO BLENDED OUTSIDE OF DOUBLER AREA REQUIRES THICKNESS CHECK. C/W SDR TRAX200600070Unknown · corrodedFOUND CORROSION AROUND N/P AT FS468 - BL43LT, RESOLVED ON W/O: 22159 TASKCARD: N/R-00220. BLENDED CORRODED AREA IAW CRJ 200 SRM 51-41-45 REQUEST THICKNESS CHECK OF BLENDED AREA DK 7022603. C/W THICKNESS CHECK AT BLENDED AREA IAW CRJ 200 NDT MANUAL 51-20-04 PSDR TRAX200600110Doubler · corrodedFOUND CORROSION ON DOUBLER AT FS 473-477 -BL41-44 LT (RESOLVED ON W/O: 22159 TASKCARD: N/R-00222 ). BLENDED CORRODED AREA OF DOUBLER AT FS 473-477 BL41-44LT IAW CRJ 200 SRM 51-41-45. REQUEST THICKNESS CHECK OF BLENDED AREA DK 7022603. C/W THICKNESS CHECK ATSDR TRAX200600074Unknown · corrodedFOUND CORROSION AROUND N/P AT FS478 - BL43LT, RESOLVED ON W/O: 22159 TASKCARD: N/R-00224. BLENDED CORRODED AREA OF PRESSURE DECK AROUND NUT PLATE FS 478 - BL43LT IAW CRJ 200 SRM 51-41-45 REQUEST THICKNESS CHECK OF BLENDED AREA DK 7022603. C/W THICKNESS CHECKSDR TRAX200600075Unknown · corrodedFOUND CORROSION AROUND N/P 485 - BL43LT, RESOLVED ON W/O: 22159 TASKCARD: N/R-00225. BLENDED CORRODED AREA AROUND NUT PLATE ON PRESSURE DECK FS 485-BL 43LT IAW CRJ 200 SRM 51-41-45 REQUEST THICKNESS CHECK OF BLENDED AREA DK 7022603. C/W THICKNESS CHECK AT BLSDR TRAX200600113Doubler · corrodedCORROSION ON DOUBLER AT FS 498-513 - BL42-44LT (RESOLVED ON W/O: 22159 TASKCARD: N/R-00226 ). BLENDED CORRODED AREA ON DOUBLER AT FS 498-513-BL42-44LT IAW CRJ 200 SRM 51-41-45 REQUEST THICKNESS CHECK OF BLENDED AREA ALSO AROUND 491.5 OF PRESSURE DECK DK 70226SDR DHL2006801549Pressure Panel · corrodedLT MLG W/W HORIZONTAL PRESSURE PANEL CORRODED, STA 902.000 LBL 53" (MAJOR REPAIR). PERFORMED MAJOR REPAIR IAW FAA FORM 8110-3 DATED 03-20-06, EO NR AST060305 DATED 03-16-06. REMOVED CORROSION FROM HORIZ PRESS PANEL IAW SRM 51-1-8 PG 17-18. FOUND OUT OF LIMISDR TRAX200600116Doubler · corrodedFOUND CORROSION ON DOUBLER AT FS 540 - BL44, 42RT.SDR TRAX200600114Doubler · corrodedFOUND CORROSIOIN ON DOUBLER AT FS 555-558, BL44-42 RT.SDR TRAX200600108Doubler · corrodedFOUND CORROSION ON DOUBLER AT FS 522-529 - BL41-44 LT.SDR TRAX200600095Doubler · corrodedFOUND CORROSION ON DOUBLER AT FS 455 - BL44LT.SDR SWAA061291Door Frame · corrodedDURING SCHEDULED 10Y CHECK, FOUND R2 DOOR CUTOUT, LOWER AFT FRAME CORRODED AT BS 992, RBL 55, WL 210. REPAIRED FRAME PER SRM.SDR TRAX200600061Frame · crackedSUSPECTED CRACK IN LOWER RADIUS OF 280 FRAME - APPROX BL 12RT (RESOLVED ON W/O: 22159 TASKCARD: N/R-00121). REPAIRED PILOTS BULKHEAD AT FS 280 RBL 9.0 IAW EO 600-53-0090.SDR QXEA200601619Housing · corrodedYYC - C3 LAV SERVICE HOUSING EXTERNAL, AROUND DRAIN, SOLID RIVET HEADS HAVE SURFACE CORROSION. REPAIRED IAW DHC-8-400 SRM 51-42-00-800-801 AND 51-25-10-370-801.SDR USAA060587Stiffener · corrodedFOUND VERTICAL STIFFENER CORRODED, BSS 222TO BSS 227.8 AT BL 0 TO RBL 8. REMOVED AND REPLACED TWO VERTICAL STIFFENERS IAW EA 97581, DEFECT SIZE: 1" BY 10".SDR 06FDEA1416Doubler · chafedFORWARD CARGO DOOR CUTOUT AFT DOUBLER APPROX FLOOR LEVEL EDGE CHAFED. FORWARD CARGO DOOR CUTOUT AFT DOUBLER CHAFING MARK REMOVED AND FOUND WITHIN LIMIT AS PER SRM 53-00-01 FIG 1A VOL.I.SDR 06FDEA1403Splice · corrodedCENTER CARGO LONGERON 48L BETWEEN STA 5-113 TO 1541 SPLICE CORRODED. CENTER CARGO LONGERON 48L BETWEEN STA 5-113 TO 1541 CORRODED SPLICE REMOVED AS PER SRM 51-33-01 VOL II. NEW SPLICE FABRICATED AS PER DWG NR A5A7125-501. NEW SPLICE INSTALLED AS PER SRM 5SDR 06FDEA1415Doubler · chafedFORWARD CARGO DOOR CUTOUT FORWARD DOUBLER APPROX FLOOR LEVEL EDGE CHAFED. FWD CARGO DOOR CUTOUT FWD DAMAGED DOUBLERS REMOVED AS PER SRM 51-33-01 VOL II. NEW DOUBLERS FABRICATED AS PER SRM 53-50-00 FIG 16 VOL I. NEW DOUBLERS PROTECTED AS PER SRM 51-21-01 VOLSDR 06FDEA1436Structure · corrodedFOUND CORROSION, STRUCTURE ALONG BS 1741 LONGERON 52 IN CENTER CARGO COMPARTMENT. CORROSION REMOVED AS PER SRM 51-21-01 VOL.II.SDR ASAA0640447Door Frame · corrodedAFT CARGO DOOR CUTOUT FWD FRAME HAS CORROSION JUST O/B OF CARGO LIGHT SWITCH AND IN 2 O/B THRESHOLD FASTENER HOLES. REMOVED CORROSION AND REPAIRED FRAME SEGMENT PER SRM 51 40 02 FIG 8.SDR CA060412003Bracket · cracked(CAN) WHILE INVESTIGATING A STIFF THRUST REVERSER SNAG, MAINTENANCE DISCOVERED THE NR 3 ENGINE CONTROL QUADRANT BRACKET CRACKED. BRACKET WAS REPLACED AND AIRCRAFT RETURNED TO SERVICE. (TC NR 20060412003)SDR SWAA061283Door Frame · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE FRAME CRACKED AT FWD CARGO DOOR CUTOUT, AFT FRAME NR 5 STOP FITTING. REPAIRED FRAME PER SRM.SDR SWAA061229Door Frame · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE FRAME CRACKED AT AFT CARGO DOOR CUTOUT, AFT FRAME NR 1 STOP FITTING. REPAIRED FRAME PER BFG ER.SDR SWAA061228Door Frame · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE FRAME CRACKED AT FWD CARGO DOOR CUTOUT, AFT FRAME NR 5 STOP FITTING. REPAIRED FRAME PER BFG ER.SDR ASAA0610422Door Frame · crackedFOUND MAIN CARGO DOOR CRACKED 6" BELOW HINGE AT FRAME LIGHTING HOLE TO INBD EDGE. REPAIRED PER ERO 5682 AND EA 5310 02608.SDR 06FDEA1367Seat Track · corrodedFOUND MAIN DECK COMPARTMENT SEAT TRACK FOUND WITH CORROSION AT STA 1805 LBL 8. CARRIED OUT REPAIR IAW SRM 53-70-00SDR SWAA061173Crease Beam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE CREASE BEAM WEB CORRODED BETWEEN BS 360 TO BS 380, STR 17R. REPAIRED WEB PER SRM.SDR 06FDEA1335Gusset · damagedUPON REMOVAL OF SHEAR WEB AT BS 1176, FOUND GUSSET TO BE DAMAGED AROUND LUG AT BS 1176, WL 208, LBL 18. *S/D* REMOVED AND REPLACED GUSSET BS 1176, LBL 18, WL 208 IAW SRM 51-40-2.SDR UPS06846745Structure · corrodedINSPECTION TYPE:C1 EXFOLIATION CORROSION FOUND AT STA 70 STRUCTURE BETWEEN L31R AND L32R. CUT OUT DAMAGED STRUCTURE AT STA 70 BETWEEN L31R AND L33R IAW SRO 08538006, AND SRM 53-02-05. FABRICATED AND INSTALLED DOUBLER CHORD, AND SPLICES IAW SRO 08538006, AND SDR SWAA061200Crease Beam · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE CREASE BEAM INBOARD CHORD CRACKED AT BS 638, LBL 65 TO LBL 68, WL 208. REPAIRED CREASE BEAM PER SRM.SDR SWAA061199Beam · corrodedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE VERTICAL BEAM WEB CORRODED AT BS 795, RBL 20, WL 157. REMOVED AND REPLACED VERTICAL BEAM WEB SECTION PER SRM.SDR 2006UALA00644Crease Beam · corrodedCREASE BEAM AT FWD GALLEY DOOR CORRODED STA 339 TO 374 RBL 59. REMOVED & REPLACED CREASE BEAM REF SRM 51-40-02.
Back to JASC 5310