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 QXEA200701184Stop · wornC4 PDX - RIGHT CENTER EMERGENCY EXIT DOOR STOPS ON FUSELAGE HAVE LIGHT WEAR. REPAIRED IAW RD8/4-53-126.SDR QXEA200701183Stop · wornC4 PDX - LEFT CENTER EMERGENCY EXIT DOOR STOPS ON FUSELAGE HAVE LIGHT WEAR. REPAIRED IAW RD8/4-53-126.SDR 07FDEA02464Beam · crackedFWD CARGO COMPT ON BEAM FOUND CRACK. REPAIRED BEAM IAW SRM 53-00-01 VOL 1 FIG 9 SHT 7.SDR 2007UALA02587Door Frame · crackedFWD CARGO DOOR CUTOUT AFT FRAME IS CRACKED IN 3 PLACES, 2 CRACKS ON FWD SIDE OF THE FRAME AT OUTBOARD LOWER CORNER AND INBOARD UPPER CORNER OF BOTTOM STOP FITTING AND THE THIRD CRACK IS ON AFT SIDE OF FRAME IN RADIOUS ADJACENT TO INBOARD UPPER CORNER OF BOTTOMSDR SWAA073450Door Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND AFT CARGO DOOR CUTOUT FWD FRAME CRACKED AT LOWER FWD CORNER. REPAIRED FRAME PER SRM.SDR 07FDEA02432Crossbeam · corrodedHEAVY CORROSION ON CROSSBEAMS, C 61 RT (P/N A539-78476-200), C60 LT (A539-73599), C58 LT (P/N A539-74268). CROSSBEAM REPAIR PERFORMED ON C58 LT AND C60 LT IAW SRM 53-10-15 FIG 207 AND REPLACEMENT OF PART ON C61 .SDR SIMA200720708Beam · corrodedGALLEY HAT BEAM FOUND CORRODED. REMOVED CORROSION, FABRICATED AND INSTALLED REPAIR PARTS IAW EMB SRM 53-21-10. AIRCRAFT RETURNED TO SERVICE.SDR QXEA200701182Stop · wornC4 PDX - RIGHT FORWARD EMERGENCY EXIT STOPS ON FUSELAGE ARE WORN. REPAIRED IAW RD8/4-53-126.SDR TRAX200700999Door Frame · crackedPAX DOOR AFT FRAME MEMBER AT FS 338.90 IS CRACKED. REF REO 601R-52-11-402 FOR POSSIBLE REPAIR. [07-26-07] REPAIRED IAW ALL SRMS AND EO`S.SDR 2007UALA02534Door Frame · damagedAFT CARGO CUTOUT FWD UPPER CORNER, BS 1810 STR 27R THE UPPER MAIN SILL FRAME TO SILL CLIP INTERFERES WITH FASTENER INSTALLATION. MAJOR REPAIR ACCOMPLISHED: TRIMMED CLIP. INSTALLED REPAIR ANGLE.SDR TRAX200700975Structure · crackedSUSPECTED CRACK ON THE UPPER I/B RADIUS OF BOTH TAB FITTINGS AT FS 472 RBL 9. PERFORMED LPI ON THE FS 472 RBL 9 UPPER RADIUS OF BOTH I/B AND O/B TAB FITTINGS IAW NDTM 51-20-08. FS 472 RBL 9 UPPER RADIUS OF BOTH I/B AND O/B TAB FITTINGS, APPROX .5 INCH. STARSDR AWXA200700806Gusset · crackedPHX - MAJOR REPAIR - CRACK AT FIRST OFFICERS NR 1 WINDOW POST GUSSET UPPER RIGHT CORNER, BS 196.5 - BS 203.8, S9R - S10R. REPAIRED FIRST OFFICERS NR 1 WINDOW POST GUSSET UPPER RIGHT CORNER, BS 196.5 - BS 203.8, S9R - S10R IAW B737-300 SRM 53-10-01-2R.SDR DHL2007784528Door Frame · crackedMCD HINGE AFT SEGMENT (FUSELAGE SIDE) HAC ONE LOBE CRACKED STA 620, WL 291, LBL 29. REMOVED DAMAGED MCD AFT HINGE SEGMENT IAW B727 SRM 51-30-2. DRILLED UP NEW HINGE SEGMENT PARTS IAW B727 SRM 51-30-5 AND AEI AMM CH. 52, FIG 5210, P/N MS20001-16-7200. TREATESDR UPS07450289Door Frame · crackedINSPECTION TYPE:C M/D AFTER FURTHER FASTENER REMOVED INNER CHORD AREA S23L - 26L FOUND TOTAL HOLES CRACK AT DIFFERENT STACK UP STRUCTURES (FRAME,STRAP, INNER CHORD OR REVEAL) (CRACK LENGTH 0.050" & THROUGH THICKNESS) M/D BS2231 FRAME ATTACH REVEAL REPAIREDSDR AWXA200700803Gusset · crackedPHX - MAJOR REPAIR - CRACK AT FIRST OFFICERS NR 1 WINDOW POST GUSSET UPPER OUTBOARD CORNER, BS 196.5 - BS 203.8, S9R - S10R. REPAIRED FIRST OFFICERS NR 1 WINDOW POST GUSSET UPPER OUTBOARD CORNER, BS 196.5 - BS 203.8, S9R - S10R IAW B737-300 SRM 53-10-01-2R.SDR QXEA200701141Support Beam · corrodedC4 PDX - VERTICAL AFT SUPPORT BEAM FOR AVIONICS CLOSET HAS CORROSION ON INBOARD SURFACE BEHIND INTERCOSTAL 31L AT STATION 196.0. REPAIRED IAW SRM 51-20-11, 51-20-36.SDR TRAX200700962Beam · corrodedSTA 349 CORRODED AT SERVICE DOOR TRANSVERSE BEAM RBL 45. BEAM RBL 45. WORK COMPLETED IN ACCORDANCE WITH: SRM 51-21-06, 53-00-00, 51-42-16, REO 601R-53-21-782, 51-20-06, 51-42-06, AND 20-21-00.SDR 2007UALA02479Door Frame · crackedFWD PIT DOORWAY CUTOUT FWD FRAME IS CRACKED AT LWR DOOR STOP FITTING. [07-27-07] MAJOR REPAIR: REMOVED CRACK AND ACCOMPLISHED ANGLE REPAIR PER MM 53-30-75.SDR 2007UALA02474Bearing · looseFWD ENTRY DOOR CUTOUT FWD & AFT STOP PADS ARE LOOSE. [07-20-07] REMOVED & REPLACED BEARING STOP PAD.SDR 2007UALA02465Door Frame · crackedFWD CARGO DOOR CUTOUT, AFT FRAME IS CRACKED ON AFT SIDE OF FRAME IN RADIUS ADJACENT TO UPPER I/B CORNER OF LOWER BOTTOM STOP FITTING. [07-27-07] MAJOR REPAIR: -REMOVED CRACK AND ACCOMPLISHED ANGLE REPAIR PER MM 53-30-75.SDR SWAA073354Crease Beam · corrodedDURING SCHEDULED 10Y CHECK, FOUND CREASE BEAM CORRODED BETWEEN BS 291 TO BS 332, STR 17R. REPAIRED CREASE BEAM PER SRM.SDR CALA0700339Door Frame · crackedINSPECTION FOUND A 1 INCH CRACK IN FORWARD CARGO DOOR CUTOUT AFT FRAME AT LOWER DOOR STOP FITTING, STA 440, S17R TO 24R. THE FRAME WAS REMOVED AND REPLACED IAW SRM 51-40-02.SDR UPS07450274Crease Beam · crackedINSPECTION TYPE:C RT FX CROWN BS980-1000 UPPER CREASE BEAM FWD RADIUS FOUND CRACK APPROX 1" LONG. FX CROWN BS 980-1000 RT UPPER CREASE BEAM REPLACED AND INSTALLED AS PER SRM 51-10-01 PG 9 AND 51-30-02.SDR UPS07450261Crease Beam · crackedINSPECTION TYPE:C RT FX CROWN BS960-980 LOWER CREASE BEAM FWD FLANGE FOUND CRACK APPROX 1/2" LONG. FX CROWN BS 960-980 RT LOWER CREASE BEAM REPLACED AND INSTALLED AS PER SRM 51-10-01 PG 9 AND 51-30-02.SDR UPS07450260Crease Beam · crackedINSPECTION TYPE:C FX CROWN BS 940-960 LOWER CREASE BEAM FWD FLANGE RADIUS FOUND CRACK APPROX 3/8" LONG. FX CROWN BS 940-960 LOWER CREASE BEAM REPLACED AND INSTALLED AS PER SRM 51-10-01 PG 9 AND 51-30-02.SDR UPS07450259Crease Beam · crackedINSPECTION TYPE:C LT FX CROWN BS 960-980 UPPER CREASE BEAM FWD FRAME ATTACH ANGLE RADIUS FOUND CRACK APPROX 1/2" LONG. FX CROWN BS960-980 LT UPPER CREASE BEAM FWD FRAME ATTACH ANGLE REPLACED AND INSTALLED AS PER SRM 51-10-01 PG 9 AND 51-30-02.SDR UPS07450258Crease Beam · crackedINSPECTION TYPE:C RT FX CROWN BS 960-980 UPPER CREASE BEAM FWD FRAME ATTACH ANGLE RADIUS FOUND CRACK APPROX 1/2" LONG. FX CROWN BS 960-980 RT UPPER CREASE BEAM FWD FRAME ATTACH ANGLE REPLACED AND INSTALLED AS PER SRM 51-10-01 PG 9 AND 51-30-02.SDR UPS07450251Door Frame · chafedINSPECTION TYPE:C APU COMPT AFT DOOR CUTOUT SUPPORT FRAME LWR FLANGE LWR SURFACE FOUND CHAFED MARKED. APU COMPT AFT DOOR CUTOUT SUPPORT FRAME LWR FRAME REPAIRED AS PER SRM 51-40-03 FIG 2.SDR ABXA070245Structure · corrodedCOCKPIT SUBFLOOR CHAFED IN SEVERAL LOCATIONS AT STA 160 AND 148. REPAIRED AREA IAW DC9 SRM 53-01.SDR DHL2007741502Structure · gougedBS 720D PLUS 10 STR 19L PREVIOUS REPAIR GOUGED. REMOVED PREVIOUS REPAIR IAW B727 SRM 51-30-02, FABRICATED NEW DOUBLER FROM 2024-T3 0.090" PO NR 9004940 (DIM. 12" BY 8") IAW B727 SRM 53-30-2 FIG 2 AND 53-30-3 FIG 14. TREATED AND PRIMED PART AND AREA IAW B727 SDR TRAX200700946Structure · corrodedCORROSION AT FS 605 BELOW FLOOR IN CARGO BAY. REFER TO WO 63655 N/R-00150 AND 00160 FOR CORRECTIVE ACTION. SUPPLEMENTAL SDR - CLOSED 07/16/07.SDR SWAA073334Crease Beam · crackedDURING SCHEDULED SERVICE CHECK, FOUND CREASE BEAM WEB CRACKED AT BS 295, RBL 60, WL 208. REMOVED AND REPLACED WEB PER SRM.SDR AWXA200700908Door Frame · crackedMCN - MAJOR REPAIR - C-20 CHECK - NR 5981344 AND 5981345, R1 DOOR AFT FRAME CRACKED, BS 328, WL 250 AT THE 3RD AND 4TH STOP FITTING. REPAIRED R1 DOOR AFT FRAME, BS 328, WL 250 AT THE 3RD AND 4TH STOP FITTING IAW USAIRWAYS EA120112.SDR UPS07450310Channel · crackedINSPECTION TYPE:C CRACK FOUND AT BS 880 RT SIDE S9R TENSION TIE ATTACH FWD CHANNEL CRACK LOCATED AT NR 9 FASTENER HOLE 0.030" APPROX. RUNNING UPWARD DIRECTION, M/D BS880 TENSION TIE FWD CHANNEL REPLACED AS PER SRM 51-10-01 PG 9 AND INSTALLED AS PER UPS EO B74SDR IXXA07SMN172SStructure · crackedDURING ROUTINE C CHECK INSPECTION, FOUND RIGHT FUSELAGE NOSE SECTION ACS MODIFICATION DOUBLER HEAT EXCHANGER COMPARTMENT LOWER AFT IAMB CORNER CRACKED AT FLIGHT STATION 12.000 LONGERON 27 RIGHT. REMOVED FASTENER AS NEEDED TO PERFORMED REPAIR. REMOVED DAMAGEDSDR NWAA072409979Structure · damagedDURING GROUND OPERATIONS AIRCRAFT WAS DAMAGED BY SERVICE VEHICLE AT BS 299 S24L. STRINGER 24L AND BUTT SPLICE STRAP WERE BOTH SEVERED. FUSELAGE SKIN FORWARD AND AFT OF BS 229 WAS DAMAGED. THE FUSELAGE SKIN AND STRINGER WILL BE REPAIRED PER SRM. THE BUTT SPSDR CALA0700331Door Frame · crackedINSPECTION FOUND A 1.5 INCH CRACK IN FORWARD CARGO DOOR CUTOUT FORWARD FRAME AT LOWER STOP FITTING, STA 440. THE FORWARD FRAME WAS REMOVED AND REPLACED IAW SRM 51-40-02.SDR AWXA200700842Door Frame · crackedMCN - MAJOR REPAIR - C-12 CHECK - NR 5950466, AFT CARGO DOOR CUT OUT WEB CRACKED, BS 1440, S25R - S26R AT THE NR 6 STOP UPPER INBOARD HOLE. REPAIRED AFT CARGO DOOR CUT OUT WEB, BS 1440, S25R - S26R AT THE NR 6 STOP UPPER INBOARD HOLE IAW B757-200 SRM 53-00-07SDR 07FDEA02332Beam · corrodedFWD CARGO COMPT DOOR SILL ON BEAM FOUND SEVERE CORROSION WITH EXFOLIATION. REPAIRED BEAM IAW SRM 53-00-01 VOL 1 FIG 9 SHT 7.SDR 07FDEA02328Beam · corrodedFWD CARGO COMPT DOOR SILL ON BEAM FOUND SEVERE CORROSION WITH EXFOLIATION. REPAIRED IAW SRM 53-00-01 VOL 1 FIG 9 SHT 7.SDR DLM90070854Door Frame · corrodedMID - PIT LWR DOOR JAMB BEAM HAS MULITPLE AREAS OF CORROSION. REPAIRED JAMB BEAM IAW MD-80 SRM 5308 FIG 63.SDR ZZDA070628184Door Frame · crackedFORWARD LWR CORNER AT AFT CARGO DOOR FRAME CRACKED. HFEC INSPECTED AREA - CUT OUT DAMAGE, FABRICATED REPAIR IAW 737 SRM 53-00-01. INSTALLED SAME PER SRM 51-20-01.SDR 2007UALA02301Torque Tube · excess playAFT ENTERY DOOR UPPER AND LOWER LATCH TORQUE TUBE HAS EXCESSIVE LATERAL PLAY. ADDED SHIMS TO UPPER & LOWER TORQUE TUBES. OPS CHECKED OKAY.SDR SIMA200720430Beam · corrodedCARGO DOOR LOWER BEAM CORRODED. REMOVED AND REPLACED BEAM IAW EMB SRM 51-40-02, 51-20-03 AND 51-40-06. AIRCRAFT RETURNED TO SERVICE.SDR SWAA073203Door Frame · crackedDURING SCHEDULED SPV CHECK, FOUND AFT CARGO DOOR CUTOUT FWD FRAME CRACKED AT BS 792, STR 24R. REPAIRED FRAME PER ACO.SDR USA2007F00009Structure · corrodedCORRODED RIVET TAILS WERE FOUND IN FUSELAGE CARGO COMPARTMENT BETWEEN FRAME 24 TO 35.7 STRINGER 38L TO 38R. APPROXIMATELY 1070 RIVETS WERE REPLACED. 25 RIVETS WERE REPLACED AT S38 OB. A RESIDUE OF SODIUM CHLORIDE ATTACKED THE RIVETS. NUMEROUS OTHER RIVETS SDR SWAA073198Crease Beam · corrodedDURING SCHEDULED 18Y CHECK, FOUND CREASE BEAM WEB CORRODED BETWEEN BS 420 AND BS 440, LBL 69. REPAIRED CREASE BEAM WEB PER SRM.SDR 07FDEA02274Structure · corrodedCENTER CARGO BETWEEN STA 1559 AND STA 1565 LONGERON 48R FOUND CORROSION. [07-09-07] CENTER CARGO BETWEEN STA 1559 AND STA 1565 LONGERON 48R CARRIED OUT REPAIR AS PER SRM 53- 10-00 VOLUME I FIGURE 2. REPAIR CLASSIFIED AS MAJOR PER GMM 6-2-100.SDR KCSA071196Stanchion · corrodedAFT PIT SIDEWALL STANCHION CORRODED AT BS 1920, RBL 61.SDR UPS07150047Stringer · puncturedAIRCRAFT SUSTAINED DAMAGE FROM RUNWAY CANS AT SECTION 130 FROM STATION 1817 FR 27-2241 FR 35. A/C HAS BEEN PUNCTURED AT THESE STATIONS. REMOVED DAMAGE PER A300 SRM 53-10-12. REPAIRED DAMAGE STRINGER L AFT OF FR IAW SRM 53-10-14. REPAIRED DAMAGE AREA IAW SR
Back to JASC 5310