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 AWXA0000690Door Frame · corrodedC-CHECK, CORROSION LEVEL 1. LEFT LOWER DOOR CHORD CORRODED AT FS 947.5 TO 1006. REMOVED AND REPLACED LT LOWER DOOR CHORD IAW 737 SRM 51-40-2.SDR GAIA00653Shear Tie · crackedDISCREPANCY: DURING HEAVY CHECK FOUND: BS 783.95 FUSE FRAME SHEAR TIE HAS 1INCH CRACK IN RADIUS BETWEEN SBL & 9L. CORRECTIVE ACTION: REPAIRE IAW B727 SRM 51-40-3 MANUFACTURE OF REPAIR DOUBLER ^ INSTALLED IAW B727 SRM 51-30-2SDR GAIA00652Shear Tie · crackedDISCREPANCY: DURING HEAVY CHECK FOUND: FS1110 SHEAR TIE CRACKED AT RIVET HOLE BETWEEN STRINGER 1L TO 2L. CORRECTIVE ACTION: REMOVED & REPLACED CRACKED SHEAR TIE IAW B727 SRM 51-30-2 & 51-20-1SDR AALA20001629Structure · crackedTUL - FOUND 2 INCH BY 2 INCHE AREA OF FUSELAGE DENTED/CRACKED BELOW FORWARD LAVATORY SERVICE PANEL STATION 280. INSTALLED REPAIR PER ESO 11697, DATED 29 SEP 00. (M)SDR MWEA00861Shear Tie · corrodedREMOVED SHEAR TIE FROM STATION 133 FROM LONGERON 26 LEFT TO LONGERON 26 RIGHT. REMOVED AND REPLACED SHEAR TIE DUE TO CORROSION BEYOND LIMITS. (M)SDR USAA001653Shear Tie · corrodedCLT - FOUND FRAME SHEAR TIE CORRODED 1 INCHES BY 3 INCHES, FRAME 727B, LOWER LEG RBL 3 INCHES AFT SIDE. CORROSION LEVEL 1 C53-107-02. REPLACED FRAME SHEAR TIE PER SRM 53-10-01. (M)SDR SWAA001920Shear Tie · crackedDURING SCHEDULED D-CHECK AT DALFORT, FOUND SHEAR TIE CRACKED AT STR 9R, BS 1040. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR DL72S001931Door Frame · crackedTHE FWD FRAME OF THE C1 DOOR CUTOUT WAS FOUND WITH TWO SMALL CRACKS IN THE WEB AND ONE CRACK IN THE INNER CHORD. A .375 INCH CRACK WAS FOUND IN THE WEB BETWEEN STOPS 1 & 2. A .75 INCH CRACK WAS FOUND IN THE WEB JUST BELOW STOP NR 6. A .5 INCH CRACK WAS FOUNSDR C2XA00IA339Strap · corrodedYYZ-DURING MOD-LINE INSPECTION, THE FORWARD CENTER BUTTSTRAP WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED THE CORROSION AND INSTALLED A REPAIR DOUBLER IN ACCORDANCE WITH CONTINENTAL EXPRESS ENGINEERING CHANGE EC5310-01107, AND THE AIRCRAFT WAS APPROVED FOR RESDR SWAA001909Crease Beam · corrodedDURING SCHEDULED D-CHECK, FOUND CORROSION ON INBD CREASE BEAM, BS 410 - BS 440, WL 208, RBL 64. REMOVED AND REPLACED INBD CREASE BEAM CHORD PER SRM.SDR PCAA0009065Structure · crackedMDT - DURING FLEET INSPECTION, REAR FUSELAGE STRUCTURE WAS FOUND CRACKED AT FRAME 4 STRINGER 4 LEFT AND RIGHT SIDES IN APU AREA. CRACKS WERE REPAIRED IN ACCORDANCE WITH DEHAVILLAND REPAIR DRAWING RD8-55-199. AIRCRAFT WAS THEN RETURNED TO SERVICE.SDR USAA001647Crease Beam · corrodedCLT - Q-4, CREASE BEAM 20 SQUARE INCHES OF CORROSION. CORROSION LEVEL 1, TASK NR C53-107-01. S17R CREASE BEAM STA 616 - STA 639. REMOVED OLD CREASE BEAM WEB AND REPLACED WITH NEW PART PER SRM 53-60-13. (X)SDR USAA001637Crease Beam · crackedCLT - Q-4, CREASE BEAM HAD 3 INCH CRACK AT FORWARD END OF S17R STA 617. FABRICATED REPAIR ANGLES PER SRM 53-60-13. (X)SDR F3LA200000247Door Frame · crackedDURING C-2 CHECK, INSPECTION REPORTED CRACK IN R-1 DOOR CUTOUT UNDER SCUFF PLATE AT LOWER AFT CORNER. MAINTENANCE VERIFIED CRACK BY ACCOMPLISHING AN NDT INSPECTION PER SRM 53-30-3 AND FABRICATED AND INSTALLED REPLACEMENT PARTS PER SRM 53-30-3, FIG 26.SDR AWXA0000684Door Frame · corrodedCORROSION LEVEL 1, RIGHT AFT LOWER DOOR CHORD AT STA 947 - 998 RBL 74 CORRODED. REMOVED AND REPLACED RT AFT LOWER DOOR CHORD IAW 737 SRM 51-40-02.SDR AALA20001673Structure · corrodedTUL - FOUND CORROSION, 8 INCHES BY 9 INCHES, UNDER CUSP AT STATION 1304 TO STATION 1309 RIGHT. CUT OUT DAMAGE, INSTALLED NEW CUSP SHEET PER SRM 51-01. (M)SDR AALA20001672Structure · corrodedTUL - FOUND CORROSION, 6 INCHES BY 16 INCHES AND .030 DEEP, ON BOTTOM SIDE OF SUB FLOOR AT FORWARD SERVICE DOOR STATION 170 RBL 56. CUT OUT DAMAGED AREA AND INSTALLED DOUBLER PER SRM 53-01 FIG 4. (M)SDR USAA001590Structure · corrodedCLT - FOUND ZEE CHORD CORRODED 1 INCH BY 4 INCHES, STATION 270 LBL 5 TO RBL 5. SPLICED IN NEW ZEE CHORD PER TYPICAL REP 53-20-04. CORROSION LEVEL 1, TASK NR C53-101-01. (M)SDR USAA001572Torque Box · crackedCLT - FOUND TORQUE BOX CRACKED .5 INCH, FS 947 PLUS 1, STRINGER 10L. INSTALLED FILLER AND REPAIR STRAP PER TR 53-30-07A. (M)SDR USAA001580Door Frame · crackedCLT - DURING Q-4 INSPECTION, FOUND DOOR FRAME CRACKED .375 INCH AT UPPER STOP PAD SUPPORT R-1 DOOR INBOARD FRAME. REPLACED WITH NEW STUB FRAME PER SRM 51-40-02 AND DWG 65 45807. (X)SDR USAA001568Z-Angle · corrosionCLT - FOUND Z-ANGLE CORRODED, STATION 277 TO 360, LBL 58. INSTALLED NEW Z-ANGLE PER SRM 51-10-02. CORROSION LEVEL 1. (M)SDR AALA20001658Shear Tie · crackedTUL - FOUND SHEAR TIE CRACKED JUST LEFT OF CENTER BEHIND FRAME 1429 AT TOP OF FUSELAGE. REPLACED CRACKED SHEAR TIE AT STATION 1429 FUSELAGE TOP AREA, SRM 51-01. (M)SDR SIMA2738Rivet · corrodedSBP - RIVETS AFT AND TO THE RIGHT OF THE FIRST OFFICER'S YOKE ARE CORRODED. MAINTENANCE REPLACED RIVETS IAW SAAB SRM. (X)SDR QXEA0002756Rivet · damagedPDX- RIVET HEAD DAMAGED IN TOP BOX BEAM OF LEFT HAND AFT OVERWING EMERGENCY EXIT. REPAIRED IAW FOKKER SRM 51-31-05 AND HORIZON AIR EA 4-53-1357.SDR AWXA0000669Shear Tie · corrodedC-CHECK, CORRODED CLEAT AT BS 787 FRAME BETWEEN STR 26R AND 27R. CORRODED CLEAT REPAIRED IAW SRM 53-10-4 PG 19A.SDR DHL2000701005Structure · corrodedFWD E&E COMPT-NOSE W/W RBL 146 WL 169 EXTRUSION OR CHORD HAS SPOTS OF CORROSION BETWEEN BS 328 AND BS 360.0 (RT WEB OF WALKWAY). REMOVED WALKWAY WL STA 294.5 TO STA 351 PER SRM 51-30-2. REMOVED FASTENERS AND VERT STIFFENERS FOR ACCSESS TO REMOVE CHORD ANGLE SDR AALA20001654Threshold · corrodedTUL - FOUND AFT CARGO DOOR THRESHOLD BEAM CORRODED, 2 INCHES BY 57 INCHES. REMOVED CORRODED BEAM AND INSTALLED NEW BEA SRM 51-01. (M)SDR VNAA0009021Structure · bird strikeDURING TAKEOFF, FLIGHT 4172 SUSTAINED MULTIPLE BIRD STRIKES. FLIGHT 4172 ABORTED TAKEOFF. MAINTENANCE INSPECTED THE AIRCRAFT IN ACCORDANCE WITH DORNIER MAINTENANCE MANUAL 53-00-00 AND FOUND NO DAMAGE TO THE AIRCRAFT. THE AIRCRAFT WAS RELEASED FOR SERVICE.SDR AALA20001674Skin · gougedTUL - FOUND THREE GOUGES, 2 INCHES BY 3 INCHES, IN CUSP STATION 632-634 LEFT. INSTALLED DOUBLER PER SRM 53-01 FIG 4 SHEET 3. (M)SDR 20001106SH079Doubler · misrepairedEXISTING REPAIR IN RIGHT SIDE FUSELAGE WINDOW BELT AT BS 351 TO BS 370 BETWEEN LONGERONS 13R TO 16R DOES NOT CONFORM TO DOUGLAS SB A53-142. (X)SDR 20001106SH078Door Frame · dentedOUT OF SRM LIMITS. DENT IN LOWER, FORWARD CORNER OF UPPER CARGO DOOR JAMB AT BS 301.5, L16L - L17L. (X)SDR 20001106SH073Web · misdrilledMISLOCATED HOLES IN FORE AND AFT UPPER CARGO DOOR JAMB CLOSE-OUT WEBS. (X)SDR 20001106SH066Door Frame · misdrilledDOUBLE DRILLED HOLE IN MAIN CARGO DOOR FRAME AT BS 373, BETWEEN LONGERONS 5L AND 6L. (X)SDR 20001106SH065Door Frame · misdrilledSHORT HOLE PITCH TO INNER CHORD OF BS 354 FRAME IN UPPER CARGO DOOR BETWEEN LONGERONS 5L AND 6L. (X)SDR 20001106SH064Door Frame · misdrilledMISDRILLED HOLES IN UPPER CARGO DOOR FRAME AT BS 421, BETWEEN LONGERONS 5L AND 6L. (X)SDR 20001106SH063Door Frame · misdrilledMISDRILLED HOLES IN UPPER CARGO DOOR FRAMES AT BS 364 AND BS 380 BETWEEN LONGERONS 5L AND 6L. (X)SDR 20001106SH062Door Frame · misdrilledMISDRILLED HOLES IN UPPER CARGO DOOR FRAMES AT BS 347 AND BS 405 BETWEEN LONGERONS 5L AND 6L. (X)SDR 20001106SH042Support Bracket · misdrilledMISDRILLED HOLES IN UPPER CARGO DOOR, LOWER DOOR JAMB SUPPORT. (X)SDR 2000UALA00576Structure · vibrationVIBRATION IN CABIN LASTING 50 SECONDS, 300 KNOTS INDICATED AIRSPEED AND CENTER AUTOPILOT ENGAGED.SDR 003589936Doubler · corrodedCORROSION ON INSIDE OF THE AFT CARGO DOOR JAMB INTERNAL PLATING DOUBLER AT FWD LOWER CORNER AND AT MIDDLE LOWER AREA. REMOVED DAMAGED AREA, FABRICATED NEW DOUBLER PER EA 99-177242. L/P 1496935SDR QXEA0002589Structure · crackedPDX- CRACK INDICATION AT RIVET ROW ABOVE LANDING GEAR PIN STORAGE BOX, STATION 2250. REPAIRED IAW FOKKER SRM 51-31-01 AND HORIZON AIR EA 4-53-1338.SDR EIA2000341Web · damagedEAC-MZJ - FOUND STATION 294 AND 446 DAMAGE AT MAIN CARGO DOOR JAMB FORWARD AND AFT CLOSE OUT WEBS. REPAIRED STATION 294 AND 446 MAIN CARGO DOOR JAMB FORWARD AND AFT CLOSE OUT WEBS PER ECRA 944-53-132-2. (M)SDR EIA2000297Door Frame · corrodedEAC-MZJ - FOUND ON C6 CHECK, CORROSION AND MISLOCATED HOLES IN AFT CARGO DOOR JAMB. REPAIRED AFT CARGO DOOR JAMB AT FS 737 TO FS 938. REMOVED DAMAGED DOUBLERS, TRIM AND SPLICE. FABRICATED AND INSTALLED REPAIR DOUBLERS PER ECRA 944-53-080-2. (M)SDR EIA2000346Doubler · corrodedEAC-MZJ - DURING C6 CHECK, FOUND FORWARD CARGO DOOR JAMB DOUBLER CORRODED. REPLACED FORWARD CARGO DOOR JAMB DOUBLER WITH P/N 9912455-505 PER ECRA 944-53-070-2. (M)SDR AU001167Structure · corroded(AUS) AIRCRAFT EXTENSIVELY CORRODED IN BOTH WINGS AND FUSELAGE IN NORMALLY INACCESSIBLE AREAS. AIRCRAFT HAD NO CORROSION PROTECTION AT MANUFACTURE.SDR ASAA0080617Shear Tie · corrodedPHX - DURING SCHEDULED C-CHECK AFT CARGO COMPARTMENT SHEAR-TIE AT STA 1145, LONGERON 30 TO LONGERON 29R WAS FOUND CORRODED. REPAIRED PER SRM. (X)SDR ASAA0080618Shear Tie · corrodedPHX - DURING SCHEDULED C-CHECK THE AFT CARGO COMPARTMENT SHEAR-TIE AT STA 1193, LONGERON 30 TO LONGERON 29R WAS FOUND CORRODED. REPAIRED PER SRM. (X)SDR ASAA0080619Shear Tie · corrodedPDX - DURING SCHEDULED C-CHECK, THE AFT CARGO COMPARTMENT SHEAR-TIE AT STA 1174, LONGERON 30 TO LONGERON 29R WAS FOUND CORRODED. REPAIRED PER SRM. (X)SDR ASAA0080620Shear Tie · corrodedPHX - DURING SCHEDULED C-CHECK, THE AFT CARGO COMPARTMENT SHEAR-TIE AT STA 1219, LONGERON 30 TO LONGERON 29R WAS FOUND CORRODED. REPAIRED PER SRM. (X)SDR ASAA0080621Shear Tie · corrodedPHX - DURING SCHEDULED C-CHECK, THE AFT CARGO COMPARTMENT SHEAR-TIE AT STA 1155, LONGERON 30 TO LONGERON 29R WAS FOUND CORRODED. REPAIRED PER SRM. (X)
Back to JASC 5310