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 QXEA0100555Shear Tie · crackedYYC- LEFT HAND AT FRAME 6305 AND STRINGER 19 HAS CRACKED CASTELLATION. REPAIRED IAW FOKKER SRM 53-02-12.SDR 2001UALA00353Shear Tie · corrodedAFT CARGO PIT AT BS 1329 BETWEEN STRINGERS 38L AND 39L, SHEAR TIE IS CORRODED. MAJOR REPAIR ACCOMPLISHEDREPLACED SHEAR TIE PER SRM 51-40-02 AND BAC DWG 140T2102.SDR 2001UALA00350Shear Tie · corrodedAFT CARGO PIT AT BS 1263 BETWEEN STRINGERS 39L AND 39R, SHEAR TIE IS CORRODED. MAJOR REPAIR ACCOMPLISHEDREPLACED SHEAR TIE PER SRM 51-40-02 AND BAC DWG 140T1209.SDR 2001UALA00349Shear Tie · corrodedAFT CARGO PIT AT BS 1241 BETWEEN STRINGERS 39L AND 39R, SHEAR TIE IS CORRODED. MAJOR REPAIR ACCOMPLISHEDREPLACED SHEAR TIE PER SRM 51-40-02 AND BAC DWG 140T2102.SDR CALA0100259Beam · corrodedINSPECTION FOUND AFT CARGO PIT DOOR JAMB BEAM CORRODED. A NEW BEAM WAS INSTALLED IAW SRM 51-30-4 AND 51-30-5. TWO DOOR STOP BRACKETS AND 3 SCUFF PLATE STRAPS WERE INSTALLED IAW SRM 51-30-5 AND 51-30-2.SDR MWEA010478Beam · misinstalledGALLEY SERVICE DOOR BEAM NR 3 BELOW HANDLE HAS B.N. NUTS AND RIVETS INSTALLED WITH INCORRECT PITCH DISTANCE IN SEVERAL PLACES. REMOVED INNER SKIN, REMOVED RIGHT AND LEFT STOP PADS AND RIGHT AND LEFT FRAME, REMOVED STIFFNER, LOCATED AND DRILLED NEW BEAM, INSTSDR EIA2001206Forging · corrodedMZJ-EAC - FOUND RIGHT STATION 1460-1480 STRINGER 20R TO STRINGER 22R CORROSION UNDER WINDOW FORGING. REPAIRED PER ECRA 3203-053-047-2. (M)SDR EIA2001205Forging · corrodedMZJ-EAC - FOUND LEFT STATION 1372-1394 STRINGER 10L TO STRINGER 22L, CORROSION AT WINDOW FORGING LOWER AFT CORNER. REPAIRED PER ECRA 3203-53-047-2. (M)SDR EIA2001204Forging · corrodedMZJ-EAC - FOUND LEFT STATION 990 CORROSION ON AND AROUND WINDOW FORGING. REPAIRED PER ECRA 3203-53-047-2. (M)SDR EIA2001203Forging · corrodedMZJ-EAC - FOUND RIGHT STATION 620-640 STRINGER 8R, CORROSION ON AND AROUND 2R WINDOW FORGING. REPAIRED PER ECRA 3203-53-047-2. (M)SDR EIA2001202Forging · corrodedMZJ-EAC - FOUND RIGHT STATION 1020-1040 CORROSION ON WINDOW FORGING AND UNDER SEALANT. REPAIRED PER ECRA 3203-53-047-2. (M)SDR TWAA0105805Door Frame · crackedDURING CHECK-C MAINT, THE RT FWD SERVICE DOOR LOWER HINGE AREA INSIDE THE DOOR FORMER ANGLE WAS CRACKED 2 INCHES LONG. REPLACED DOOR FORMER AND RIGGED PER DRAWING 176379.SDR QXEA0100510Pressure Panel · crackedYYC- NOSE LANDING GEAR BAY TOP COVER IS CRACKED ON LEFT HAND SIDE OF STATIONS 2996 - 3050L. REPAIRED IAW HORIZON AIR EA 4-53-1459.SDR DL757010505Door Frame · corrodedIN ORDER TO REPLACE A CORRODED C2 DOOR SILL CHORD, THE FS 1440 OPENING FRAME WAS CUT AND REMOVED BETWEEN THE LOWER DOOR SILL AND STRINGER 26R. THE FRAME CHORDS WERE SPLICED WITH ALUMINUM REPAIR ANGLES AND THE WEB WITH AN ALUMINUM DOUBLER. THE REPAIR WAS ACCOSDR AWXA0001534Tee Chord · crackedMAIN WHEEL WELL FWD BLKHD UPPER T-CHORD CRACKED AT FS 663.75 LBL 24 AND RBL 24. REPAIRED IAW BOEING DWG 65C37732, B737-200 SRM 51-30-2 PGS 2-3, 5, 7-9 AND AWA ER 15-5702-01073-JS3.SDR MWEA010381Shear Tie · tool damageTOOL DAMAGE IN RADIUS OF SHEAR TIE STATION 756 LONGERON 15-17 LEFT. REMOVED SHEAR TIE, FABRICATED, LOCATED, DRILLED AND INSTALLED NEW SHEAR TIE.SDR MWEA010379Shear Tie · damagedSTATION 758, BETWEEN LONGERON 16 AND 17 RIGHT, DRILL DAMAGE, FIVE LOCATIONS, DAMAGE TO SHEAR TIE AND TO OUTBOARD FACR OF FRAME IN RADIUS. REMOVED, FABRICATED, LOCATED, DRILLED AND INSTALLED SHEAR TIE.SDR RRXA10895Seat Track · wornDURING A MAINTENANCE VISIT FOUND THE SEAT TRACK WORN BEYOND LIMITS AT STA 590 TO 980 LBL 48, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. /////CORRECTIVE ACTION///// RECEIVED PART AND INSTALLED IAW DC-8 SRM 53-2-3, FIG 8A AND 53-7-1, FIG 4.SDR 01FDEA00227Skin · corrodedN 164 DUR ROUTINE INSP, FUSELAGE SKIN FND CORRODED AT BS 400, STR 3R AND 4R. ** S/D ** STRIPPED AREA. LFEC IND NO CORROSION LOSS PER LOSS IAW 727 NDT MANUAL PART 6. TREATED, PRIMED AND REPAIR PER IAW BAC 727 SRM 51-20-151-7.SDR RRXA10887Fitting · crackedDURING A MAINTENANCE VISIT FOUND A LARGE GAP BETWEEN O/B END FITTING AND BATHTUB FITTING AT FS 1220 AND L33L TO L34L, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. /////CORRECTIVE ACTION///// RECEIVED PART AND INSTALLED IAW DC-8 SRM 51-1-20D, 53-1-0 AND DWG 3755SDR 2001UALA00345Shear Tie · corrodedFORWARD PIT BS 742 STRINGERS 37L - 38L SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED REPLACED SHEAR TIE REF: BAC143T1214 AND SRM 51-40-02.SDR RRXA11029Longeron · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION DAMAGE TO LONGERON AT L33L AND STA 1168-1270, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. /////CORRECTIVE ACTION///// REMOVED DAMAGE, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED REPAIR AND INSTALLED IAW DC-8 SRM 51-1-2SDR AALA20010732Door Frame · corrodedTUL - FOUND CORROSION ON AFT CARGO DOOR BEAM OUTBOARD FACE FROM STATION 1160 TO 1208. INSTALLED DOUBLER PER AARD 53-10-00-3. (M)SDR 0101451157Door Frame · corrodedDURING H-CHECK, FOUND CORROSION ON FORWARD FRAME OF CENTER CARGO DOOR JAMB AT BS 1708 BETWEEN L42R AND L44R. REPAIRED PER EA 11-183322.SDR EIA2001130Shear Tie · crackedHKG-HAECO - FOUND THREE VERTICAL BEAM ATTACH SHEAR TIE CLIPS CRACKED, FUSELAGE RIGHT NOSE GEAR TUNNEL SIDEWALL. REPLACED DEFECTIVE SHEAR TIE CLIPS PER SRM 51-10-01. (M)SDR AT0100113Door Frame · crackedFOUND CRACK IN AFT CARGO DOOR JAMB. REPAIRED CRACK IAW REO-L00420 AND EO 09-5310-29-61496.SDR CALA0100246Beam · corrodedINSPECTION FOUND MID CARGO DOOR JAMB BEAM CORRODED. THE CORROSION WAS REMOVED. A DOUBLER WAS INSTALLED IAW ECRA 5310-03027.SDR RRXA10880Longeron · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION DAMAGE TO LONGERON 36 AT STA 140-160, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. FABRICATED PART AND INSTALLED IAW DC-8 SRM 53-4-1, FIG 28 AND DWG 5758874SDR RRXA10765Door Frame · crackedDURING A MAINTENANCE VISIT FOUND CRACK DAMAGE TO RT. MLG BODY DOOR AT AFT O/B CORNER FRAME, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED REPAIR AND INSTALLED IAW E.O. #01-024 WITH APPROVED 8110-3 DATEDSDR 2001UALA00343Shear Tie · corrodedAFT PIT SHEAR TIE AT BS 1351 STRINGER 38L CORRODED. MAJOR REPAIR ACCOMPLISHED FABRICATED AND INSTALLED SHEAR TIE IN ACCORDANCE WITH SRM 51-20-02 AND SRM 51-40-02.SDR 2001UALA00341Shear Tie · corrodedAFT PIT BS 1329 STRINGERS 37L - 38L SHEARTIE CORRODED. MAJOR REPAIR ACCOMPLISHED REPLACED SHEARTIE REF: BAC140T2102 AND SRM 51-40-02.SDR 2001UALA00340Shear Tie · corrodedAFT PIT BS 1329 STRINGERS 39L - 39R SHEARTIE CORRODED. MAJOR REPAIR ACCOMPLISHED REPLACED SHEARTIE REF: BAC146T1212 AND SRM 51-40-02.SDR 2001UALA00334Shear Tie · corrodedAFT PIT BS 1329 STRINGERS 36L - 37L SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED REPLACED SHEAR TIE REF: BAC140T2102 AND SRM 51-40-02.SDR 2001UALA00326Shear Tie · corrodedAFT PIT BS 1351 STRINGERS 38L - 39L SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. REPLACED SHEAR TIE REF: BAC140T2101 AND SRM 51-40-02.SDR 2001UALA00301Structure · corrodedFORWARD BILGE AREA BS 580 TO 600 STRINGER 28R CORRODED.SDR CALA0100240Beltframe · crackedINSPECTION FOUND A 1.125 INCH CRACK IN BELTFRAME LOWER SECTION AT STA 807, S28R. A REPAIR ANGLE WAS INSTALLED IAW SRM 53-00-07, FIGURE 201.SDR ASAA0110135Shear Tie · corrodedPHX - DURING SCHEDULED D-CHECK, FOUND SHEAR TIE AT BS 727B, STRINGER 26L-28L CORRODED. REPAIRED PER SRM. (M)SDR EIA2001199Forging · corrodedMZJ-EAC - FOUND LEFT STATION 1210 CORROSION ON AND AROUND WINDOW FORGING. REPAIRED PER ECRA 3203-53-047-2. (M)SDR UPS01235556Structure · crackedINSPECTION TYPE:C & SI, LT BS 910 CRACKED MRR FILED AS OPEN AWAITING LOG PAGE. CRACK REPAIRED IAW EO B727-5310-1896-BSDR 2001UALA00295Plate · damagedLOWER SURFACE OF DECK PLATE HAS TOOLING DAMAGE STA 1704 TO 1707 LBL 62. SUPPLEMENTAL DATA UPDATE MAJOR REPAIR ACCOMPLISHED. AFT DECK PLATE WAS BLENDED TO REMOVE TOOLING DAMAGE PER FORM 8110-3 .SDR DL757010458Door Frame · corrodedADDITIONAL DAMAGE FOUND AT EXISTING REPAIR ON C-2 DOOR SURROUND AFT FRAME INNER CHORD. EXISTIND REPAIR WILL BE REMOVED AND REPLACED WITH A NEW REPAIR SCHEME. THIS ER/A SUPERCEDED BY ER/A 379988-14.SDR 01FDEA00215Frame · damagedNR N 934 DRILL START IN FRAME BS 720E, STR 7LH. ** S/D ** R&R & FAB & ALODINED & PRIMED PER FEDEX SRM 53-10-4 FIG 2.SDR RRXA11047Fitting · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION DAMAGE TO FITTING AT STA 1230 AND L36, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. /////CORRECTIVE ACTION///// REMOVED DAMAGE, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED PART AND INSTALLED IAW DC-8 SRM 51-1-20D. (CORRSDR RRXA11045Fitting · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION DAMAGE TO LONGERON FITTIND AT STA 1150 AND L36, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. /////CORRECTIVE ACTION///// REMOVED DAMAGE, TREATED AREA IAW DC-8 SRM 51-1-8.FABRICATED PART AND INSTALLED IAW DC-8 SRM 51-1-20SDR RRXA11030Fitting · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION DAMAGE TO FITTING AT STA 1180 AND L36L-L35L, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. /////CORRECTIVE ACTION///// REMOVED DAMAGE, TREATED AREA IAW DC-8 SRM 51-1-8. RECEIVED PART AND INSTALLED IAW DC-8 SRM 53-1-0, 51-SDR RRXA10770Skin · crackedDURING A MAINTENANCE VISIT FOUND CRACK DAMAGED TO A-PIT DOOR SEAL FRAME WORN/CRACKED OUT INCLUDING SKIN--LOC CENTER SECTION OF DOOR AT A-PIT, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED REPAIR AND INSSDR DHL2001741518Stop Fitting · damagedC2 CARGO DOOR FRAME LOWER AFT DOOR STOP HAS A CRACK INDICATION. REMOVED LOWER AFT DOOR STOP AND FASTENERS OF SEAL RETAINERS FOR S/M ACCESS AS PER B727SRM 51-30-2. PERFORMED HFEC INSP PER B727NDT MANUAL PART 6 51-00-00 FIG 4 NO CRACK INDICATION FOUND. FABRICSDR AALA20010630Shear Tie · corrodedTUL - FOUND CORROSION ON SHEAR TIE STATION 540 STRINGER 27R. REMOVED CORROSION, ALODINED AND PRIMED PER MM 51-20-0. (M)SDR SWAA010832Pressure Panel · crackedDURING SCHEDULED 1/4D CHECK, FOUND NLG W/W BOX VERTICAL WEB CRACKED AT BS 233, BL 0. REPAIRED WEB PER SRM.SDR SWAA010813Pressure Panel · crackedDURING SCHEDULED 1/4D CHECK, FOUND BEADED PRESSURE WEB CRACKED AT BS 664, LBL 31. REPAIRED BEADED PRESSURE WEB PER TI-353-046.
Back to JASC 5310