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 SWAA090132Crease Beam · corrodedDURING SCHEDULED 16Y CHECK, FOUND RT CREASE BEAM CORRODED AT BS 230. REMOVED AND REPLACED BEAM PER SRM.SDR SWIA200921287Door Frame · crackedC-CHECK, MAIN DOOR AFT FRAME CRACKED AT UPPER ROLLER GUIDE. REPAIRED PER SRM.SDR AALA2009021300106Window Frame · crackedCRACK IN RIGHT WINDOW FRAME FORWARD OF STATION 1060 UPPER CORNER. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA2009021300103Window Frame · crackedCRACK IN RIGHT WINDOW FRAME FORWARD OF STATION 1079 UPPER CORNER. INSTALLED DOUBLER PER AARD53-10-00-25.SDR AALA2009012100002Beam · corrodedBEAM CORRODED, LOWER DOORWAY, STATION 1155 TO 1193. REMOVED CORROSION AND REPAIRED PER AARD 53-10-00-3.SDR FDEA200901070078Seat Track · corrodedMAIN DECK, FLOOR PANEL SEAT TRACK FROM STA 5-20 TO STA 5-60, X = 8.5 FOUND CORROSIONS AT SEVERAL LOCATIONS, MAIN DECK, CORRODED SEAT TRACK FROM STA 5-20 TO STA 5-60, X = 8.5 REPAIRED BY SECTIONAL SEAT TRACK REPLACEMENT FROM STA 5-0 TO STA 5-123, X = 8.5 AS PSDR FDEA200901070064Stringer · corrodedFWD CARGO PIT, CORROSION INSIDE CHANNEL STRINGER 23R AT STA. 720E - 720F. REMOVED ACCESS PANEL 3440 IAW SRM 51-30-2. CUT-OUT DAMAGE STR 23R BETWEEN STA 720E TO 740 IAW SRM 53-10-3 FIG 1 DETAIL I. FABRICATED REPAIR FILLER AND 2 EA SPLICES IAW SRM 53-10-3 FISDR AALA2009012200013Beam · corrodedMID CARGO DOOR BEAM (LOWER) HAS CORROSION ON HORIZONTAL LEG STATION 650 TO 692. REMOVED CORROSION AND INSTALLED DOOR BEAM DOUBLER PER AARD 53-10-00-3.SDR SWAA090074Door Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FRAME CRACKED AT L1 DOOR AFT CUTOUT, BETWEEN 6TH AND 7TH STOP FITTING. REPAIRED FRAME PER SRM.SDR USAA2009013090236Crease Beam · corrodedMCN - C1 - MAJOR REPAIR - CORROSION ON INNER CHORD BETWEEN BS 700 TO BS 740, LBL 55. REPLACED L2 DOOR INNER CHORD IAW B757 SRM 51-40-02.SDR AALA200910569Door Frame · corrodedAFT CARGO DOOR FRAME, CORROSION ON CHORD ANGLE AT FORWARD AND AFT ENDS. INSTALLED REPAIR DOUBLER TO CHORD ANGLE PER SRM 53-10-00-3.SDR ASAA0944129Panel · corrodedCORROSION AFT CARGO BAY DOOR CUTOUT, AFT FRAME LOWER CLOSE OUT PANEL. R&R DAMAGED AFT CARGO BAY DOOR CUTOUT AFT FRAME LOWER CLOSE OUT PANEL REVEAL STRIP.SDR CA090102004Door Frame · cracked(CAN) WHILE CARRYING OUT SPECIAL INSPECTION, INSPECT ESCAPE HATCHES AND ASSOCIATED CLOSURE AREA. FOUND THE RT AFT EMERGENCY EXIT CROSS TIE CRACKED THROUGH AT FS 201.775, AFT RT ESCAPE HATCH FRAME. THERE WERE TWO RIVETS SHEARED OFF IN THE SAME AREA AND THE .1SDR UPS09854255Angle · crackedINSPECTION TYPE:N/A F/O WINDOW CRACKED AND FOUND CORROSION ON F/O'S WINDOW FRAME. A/C WILL FERRY TO SDF - SAT. REMOVED AND REPLACED LT AND RT COCKPIT WINDOW FRAME Z-ANGLES. REF EA 008-5310-A1588 & EO DC8-5310-31796-A.SDR SWAA087430Crease Beam · crackedDURING SCHEDULED 24Y CHECK, FOUND RT CREASE BEAM WEB CRACKED AT BETWEEN BS 639 TO BS 667, WL 208. REMOVED AND REPLACED WEB PER SRM.SDR SWAA087426Crease Beam · crackedDURING SCHEDULED 24Y CHECK, FOUND RT CREASE BEAM WEB CRACKED BETWEEN BS 616 TO BS 639, WL 208. REMOVED AND REPLACED WEB PER SRM.SDR YENA20090106002Structure · corrodedON WEEKLY INSP, AFT CARGO DOOR PROFILE SEAL BETWEEN FR 52 TO FR 56 HAS CORROSION AT WITH THE 5 FOLLOWING SIZE OF DEFECT LENGTH AND DEPTH. PERMANENT REPAIR FUSELAGE/AFT CARGO DOOR SEALING SECTION/CORROSION WAS ACCOMPLISHED IAW EC A08-690-02 REPLACED AFFECTED DOSDR SWAA087368Door Frame · corrodedDURING SCHEDULED 14Y CHECK, FOUND R2 CUTOUT LOWER CHORD CORRODED AT BS 985. REMOVED AND REPLACED CHORD PER SRM.SDR CA090108003Door Frame · corroded(CAN) DOOR TUBE RUSTED THROUGH LOWER END, REPLACED.SDR FDEA200812265303Door Frame · corrodedNR 2 PAX DOOR LEFT LOWER CUT OUT FRAME WEB AND ANGLE SUPPORT HAVE SEVERAL SPOT OF CORROSION AT STA 690-730. REMOVED ANGLE SUPPORT AND FABRICATED, LOCATED, DRILLED,TREATED, PRIMED AND INSTALLED NEW ANGLE SUPPORT IAW SRM51-40-02, 51-40-05, 51-40-06 AND 51-20-01.SDR FDEA200812265297Support Fitting · crackedCRACK INDICATION FOUND DURING HIGH FREQUENCY EDDY CURRENT OPEN HOLE INSP ON 0.460 INCH HOLES AT MAIN CARGO DOOR LWR JAMB NR 6 SUPPORT FITTING AT HOLES A, B AND D. BUSHING REPAIR CARRIED OUT AS PER SRM 53-50-00 FIGURE 10 VOLUME I. REPAIR CLASSIFIED AS MAJOSDR FDEA200812265296Support Fitting · crackedCRACK INDICATION FOUND DURING HIGH FREQUENCY EDDY CURRENT OPEN HOLE INSPECTION ON 0.460 INCH HOLES AT MAIN CARGO DOOR LOWER JAMB NR 5 SUPPORT FITTING AT HOLE D. BUSHING REPAIR CARRIED OUT AS PER SRM 53-50-00 FIGURE 10 VOLUME I. REPAIR CLASSIFIED AS MAJORSDR FDEA200812265295Support Fitting · crackedCRACK INDICATION FOUND DURING HIGH FREQUENCY EDDY CURRENT OPEN HOLE INSP ON 0.460 INCH HOLES AT MAIN CARGO DOOR LWR JAMB, NR 4 SUPPORT FITTING AT HOLES A, B, C AND D. BUSHING REPAIR CARRIED OUT AS PER SRM 53-50-00 FIGURE 10 VOLUME I. REPAIR CLASSIFIED ASDR FDEA200812245272Structure · corrodedAIR CONDITIONING COMPT BETWEEN FR44 AND FR45, STR 38R AND 39R HAS SURFACE CORROSION. REMOVED LIGHT SURFACE CORROSION IAW SRM 51-74-10, MATERIAL LOSS .001 IN. TREATED AND PRIMED IAW SRM 51-21-10, PAINTED IAW MM 75-10-08.SDR FDEA200812235261Structure · crackedCENTER LANDING GEAR WHEEL WELL, FOUND RIGHT FORWARD MOST CORNER CUTOUT DOUBLER CRACKED. CENTER MLG WW, RIGHT FORWARD MOST CORNER CUTOUT CRACKED. DOUBLER REMOVED AS PER SRM 51-33-01 VOLUME II. FASTENER HOLES PICKED UP ON NEW DOUBLER AND INSTALLED AS PER SRMSDR SWAA087316Crease Beam · corrodedDURING SCHEDULED SPV CHECK, FOUND CREASE BEAM WEB CORRODED AT BS 377, RBL 70, WL 208. REMOVED AND REPLACED WEB PER SRM.SDR SWAA087294Crease Beam · corrodedDURING SCHEDULED SPV CHECK, FOUND CREASE BEAM WEB CORRODED AT BS 397, RBL 70, WL 208. REPAIRED WEB PER SRM.SDR SWAA087293Door Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT L2 DOOR LOWER AFT ENTRY CUTOUT. REMOVED AND REPLACED FRAME PER SRM.SDR SWAA087289Crease Beam · corrodedDURING SCHEDULED 16Y CHECK, FOUND RT CREASE BEAM WEB CORRODED AT BETWEEN BS 727E TO BS 747. REMOVED AND REPLACED WEB PER SRM.SDR SWAA087288Crease Beam · corrodedDURING SCHEDULED 16Y CHECK, FOUND CREASE BEAM WEB CORRODED AT BETWEEN BS 807 TO BS 827, STR 17L. REMOVED AND REPLACED WEB PER SRM.SDR SWIA200820872Window Post · crackedC-CHECK, RIGHT WINDSHIELD SIDE POST OUTBOARD CLIP CRACKED. REPLACED PER SRM.SDR SWIA200820871Window Post · crackedDURING C-CHECK, LEFT WINDSHIELD SIDE POST OUTBOARD CLIP CRACKED. REPLACED PER SRM.SDR USAA2009010590035Door Frame · crackedCLT - Q5 - MAJOR REPAIR - NR 03C10753006/006 - CRACK IN R1 DOOR FRAME AT BS294.5, BETWEEN S6R & S7R. REPAIRED R1 DOOR FRAME AT BS294.5, BETWEEN S6R & S7R IAW B737 SRM 51-70-11.SDR SWAA087240Door Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND R1 DOOR AFT FRAME CRACKED AT UPPER STOP FITTING. REPAIRED FRAME PER SRM.SDR ASOA200801716Support · crackedAPU INLET DOOR FRAME SUPPORT P/N 601R35210-17 CRACKED .2" LONG AT FWD BOTTOM CORNER RADIUS BETWEEN FS 654.5 - FS 672.20 STR 4L IN AFT EQUIP BAY CEILING. REPLACED APU INLET DOOR FRAME SUPPORT IAW CRJ SRM 51-42-06 FOR SOLID RIVETS, CRJ 200 SRM 51-42-13 FOR CHERSDR SWAA087147Crease Beam · corrodedDURING SCHEDULED 16Y CHECK, FOUND CREASE BEAM CORRODED AT L2 DOOR, BETWEEN BS 950 TO BS 990. REMOVED AND REPLACED BEAM PER SRM.SDR SWAA087146Crease Beam · corrodedDURING SCHEDULED 16Y CHECK, FOUND CREASE BEAM CORRODED AT R2 DOOR BETWEEN BS 996 TO BS 947. REMOVED AND REPLACED BEAM PER SRM.SDR FDEA200812165179Crease Beam · corrodedMAIN CABIN FLOOR SUPPORT, RT CREASE BEAM, INBD CHORD, BS 600-620, HAS CORROSION. REMOVED CORROSION IAW SRM 51-10-02. CORROSION OUT OF LIMITS PER SRM 53-30-13, DETAIL 2; D=.025". REMOVED AND REPLACED BS 600-620, RBL 63-70, INBD CREASE BEAM WEB, THAT WAS FABRSDR CNMA20090061Structure · crackedCRACK FOUND STA 1721 ON LWR CHORD B/T STA 1721-1741 RBL - 0 B/T STR 51 TO 52 RT. TRIM OUT CRACK AND AREA REINFORCEMENT IAW SRM VOL 2 51-31-01.SDR ASAA0874035Door Frame · damagedWHILE WORKING NRC5144956 FWD SER DOOR FRAME FOUND 2 EA HOLES W/PARTIAL PILOT HOLES 51295 WL 269 RT SIDE. REPAIRED HOLES PER EA700 53EA 00342.SDR FDEA200812135137Door Frame · corrodedL1 DOOR LT UPPER FWD FAIL/SAFE RING RADIUS BOTH LAYERS SHOW EXFOLIATION CORROSION INDICATIONS AFTER EDDY CURRENT INSPECTION, UNABLE TO VERIFY ULTRASONICALLY 1 SQ INCH AREA. REMOVED LEVEL 1 CORROSION AND REPAIRED DAMAGED AREA AT L-1 DOOR UPPER FWD CORNER FSDR AALA200910598Beam · corrodedCORROSION ON BEAM STATION 294.5 RBL 30. REPAIRED PER ESO 61000.SDR CALA2008121101140Door Frame · damagedFLOORBOARD ATTACH ANGLE AT RIGHT SIDEWALL STATION 486 NEEDS TO BE CUT AND DISPLACED TO FACILITATE REPAIR OF FORWARD CARGO DOOR AFT FRAME. CUT ANGLE TO FORM FRAME MAT ID 7075 T6 .063" PER SRM B737 53-30-13. FABRICATED REPAIR ANGLE PER SRM B737 53-30-13. ALODSDR CALA2008121101138Door Frame · crackedFORWARD CARGO DOOR CUTOUT FORWARD FRAME CRACKED AT LOWER DOOR STOP FITTING AT STR 24R. REMOVED AND REPLACED FORWARD CARGO DOOR CUTOUT FORWARD FRAME PER SRM 51-10-2, PAGE 8, MAT ID 65-20722U70, PAC 59980.SDR SWAA087016Crease Beam · crackedDURING SCHEDULED 24Y CHECK, FOUND CREASE BEAM INNER CHORD CRACKED AT BS 639, LBL 64. REPAIRED BEAM PER SRM.SDR SWAA086985Crease Beam · crackedDURING SCHEDULED 24Y CHECK, FOUND CREASE BEAM CHORD CRACKED AT BS 639, LBL 64. REPAIRED BEAM PER SRM.SDR AALA200810542Structure · corrodedCORROSION ON RIGHT SUBFLOOR STATION 218. REPAIRED PER AARD 53-20-00-16.SDR SWAA086907Crease Beam · crackedDURING SCHEDULED 24Y CHECK, FOUND CREASE BEAM WEB CRACKED AT BS 638, LBL 61. REPAIRED WEB PER SRM.SDR FDEA200812085105Beam · corrodedE AND E COMPT HORIZ WALKWAY BEAM HAS CORROSION WITH EXFOLIATION RBL 12 BS 344. REMOVED AND REPLACED LWR CHORD WALKWAY BEAM AT RBL12 BS 294-360 WITH NEW CHORD P/N 65-19861-8 PO NR 827074 IAW SRM 51-30-5 AND SRM 51-30-2.SDR AALA200810536Beam · corrodedCORROSION ON MID CARGO DOOR BEAM STATION 636 TO 693. REPAIRED PER AARD 53-10-00-3.
Back to JASC 5310