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 GUUA95753060111ADoor Frame · crackedDURING SCHDULED ROUTINE STRUCTURAL INSP DISCOVERED CARGO DOOR FRAME CRACKED APPROX 2.0 INCHES AT TOP FORWARD AREA OF FRAME BETWEEN FS 456 AND FS 468.25. STOP DRILLED ENDS OF CRACK AND INSTALLED 10.0 INCH REPAIR DOUBLER.SDR ASOA201101098Beam · corrodedAVIONICS BAY FUSELAGE BEAM AT FS 310.00 IS CORRODED BETWEEN S26L-S26R ON AFT SIDE AND SMALL AREA ON FRONT SIDE AT S27. REMOVED CORROSION DAMAGE IAW SRM 51-42-06 AND SRM 51-21-06.SDR ASOA201101097Beam · corrodedAVIONICS BAY FUSELAGE BEAM AT FS 333.00 BETWEEN STR26L-STR26R IS CORRODED ON FWD AND AFT SIDE. REMOVED CORROSION IAW SRM 51-42-06 AND SRM 51-21-06.SDR ASOA201101096Beam · corrodedAVIONICS BAY FUSELAGE BEAM AT FS 349.00 BETWEEN S26L-R IS CORRODED ON THE FWD SIDE. REMOVE CORROSION & FASTENERS AS REQUIRED. EVALUATE 349 FRAME. REMOVED CORROSION IAW SRM 51-42-06 AND 51-21-06. PERFORMED UT THICKNESS INSP OF BLEND AREA OF FRAME SECTOR IASDR KCSA111139Door Frame · crackedL-5 DOOR CUTOUT REVEAL IS CRACKED 2.25 INCH AT STA 2231 BETWEEN STRINGER 16L AND 17L.SDR IPXA11567131Structure · debondedINSPECTION TYPE:C1, ACCESS DOOR 194ER INNER SURFACE DEBONDED 69" FROM L/E 19" FROM OTBD EDGE. REPAIRED IAW SRM 52-40-02-01-7, 51-70-05-0G.SDR SWAA113919ACrease Beam · corrodedDURING SCHEDULED 16Y CHECK FOUND, RT CREASE BEAM WEB CORRODED BETWEEN BS 887 TO BS 907, LBL 65. REPAIRED PER SRM.SDR CA110601009Tube · crackedCRACK FOUND UPPER DIAGONAL TUBE IN AFT FUSELAGE. ACFT IN MOUNTED ON FLOATS.SDR SWAA114026Crease Beam · corrodedDURING SCHEDULED 16Y CHECK, FOUND CREASE BEAM WEB CORRODED BETWEEN BS 747 TO BS 767, LBL 65. REMOVED AND REPLACED WEB PER SRM.SDR AALA20110529TUL05Pan · crackedWINDOW RING PAN CRACKED LEFT SIDE, LOWER FORWARD CORNER AT STATION 984. INSTALLED REPAIR ANGLE PER AARD 53-10-00-25.SDR AALA20110529TUL04Pan · crackedWINDOW RING PAN CRACKED RIGHT SIDE, LOWER FORWARD CORNER AT STATION 984. INSTALLED REPAIR ANGLE PER AARD 53-10-00-25.SDR AALA20110529TUL03Pan · crackedWINDOW RING PAN CRACKED RIGHT SIDE, LOWER AFT SIDE OF STATION 845. INSTALLED REPAIR ANGLE PER AARD 53-10-00-25.SDR AALA20110529TUL02Pan · crackedWINDOW RING PAN CRACKED RIGHT SIDE, UPPER FORWARD CORNER AT STATION 886. INSTALLED REPAIR ANGLE PER AARD 53-10-00-25.SDR AALA20110529TUL01Pan · crackedWINDOW RING PAN CRACKED RIGHT SIDE, UPPER FORWARD CORNER AT STATION 927. INSTALLED REPAIR ANGLE PER AARD 53-10-00-25.SDR ASOA201101071Doubler · crackedLT SIDE FS 640.00 DOUBLER CRACKED AT CUTOUT RADIUS FOR ENGINE SUPPORT BEAM ATTACH POINT. REPAIRED.SDR AALA20110527TUL09Pan · crackedWINDOW RING PAN CRACKED LEFT SIDE UPPER FORWARD CORNER AT STATION 788. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20110527TUL08Pan · crackedWINDOW RING PAN CRACKED RIGHT SIDE FORWARD LOWER CORNER AT STATION 1155. TRIMMED OUT CRACKED TAB AND INSTALLED REPAIR ANGLE PER AARD 53-10-00-25.SDR AALA20110527TUL07Pan · crackedWINDOW RING PAN CRACKED LEFT SIDE LOWER AFT CORNER AT STATION 826. CUT OUT CRACKED AREA OF WINDOW RINGPAN. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20110527TUL06Pan · crackedWINDOW RING PAN CRACKED RIGHT SIDE FORWARD LOWER CORNER AT STATION 1211. TRIMMED OUT CRACKED TAB AND INSTALLED REPAIR ANGLE PER AARD 53-10-00-25.SDR AALA20110527TUL05Pan · crackedWINDOW RING PAN CRACKED LEFT SIDE LOWER FORWARD CORNER AT STATION 1041. INSTALLED REPAIR ANGLE AS PER AARD 53-10-00-25.SDR AALA20110527TUL04Pan · crackedWINDOW RING PAN CRACKED LEFT SIDE UPPER AFT CORNER AT STATION 1041. INSTALLED REPAIR ANGLE AS PER AARD 53-10-00-25.SDR AALA20110527TUL03Pan · crackedWINDOW RING PAN CRACKED LEFT SIDE LOWER FORWARD CORNER AT STATION 984. INSTALLED REPAIR ANGLE DOUBLER AT STATION 984 LOWER FORWARD CORNER PER AARD 53-10-00-25.SDR AALA20110527TUL02Pan · crackedWINDOW RING PAN CRACKED RIGHT SIDE LOWER FORWARD CORNER AT STATION 984. INSTALLED REPAIR ANGLE DOUBLER AT STATION 984 RIGHT LOWER FORWARD CORNER PER AARD 53-10-00-25.SDR EIAA2011044Door Frame · damagedELEVEN EACH DEFECTIVE HOLES AT STA 800 R2 DOOR FRAME. REAMED, CLEANED AND DEBURRED DISCREPENT HOLES PER B747 SRM 51-30-05 PG 6-9.SDR DALA1136673707Crease Beam · corrodedR-1 DOOR CREASE BEAM CORRODED FROM STA 294 TO 332. REPLACED CREASE BEAM AT R-1.SDR SWAA113884Crease Beam · crackedDURING SCHEDULED SPV CHECK, FOUND RT CREASE BEAM CRACKED AT BS 616. REMOVED AND REPLACED BEAM PER SRM.SDR SWAA114008Crease Beam · corrodedDURING SCHEDULED OTS CHECK FOUND, LT CREASE BEAM WEB CORRODED AT BS 747+4, STR 17L. REMOVED AND REPLACED WEB PER SRM.SDR SWAA114007Crease Beam · corrodedDURING SCHEDULED OTS CHECK FOUND, LT CREASE BEAM WEB CORRODED AT BS 767+10. REMOVED AND REPLACED WEB PER SRM.SDR SWAA113811Crease Beam · crackedDURING SCHEDULED 12Y CHECK FOUND, CREASE BEAM CHORD CRACKED BETWEEN BS 663+10 TO BS 727+4, STR 17L. REMOVED AND REPLACED BEAM PER SRM.SDR SWAA113810Crease Beam · crackedDURING SCHEDULED 12Y CHECK FOUND, CREASE BEAM CRACKED BETWEEN BS 616 TO BS 639, STR 17R. REMOVED AND REPLACED BEAM PER SRM.SDR FDEA201105241972Support Fitting · damagedMAIN CARGO DOOR BS 620 AFT O/B SUPPORT FITTING HAS ELONGATED FASTENER HOLES REMOVED DAMAGED BS 620 TENSION ANGLE (SUPPORT FITTING), FABRICATED AND INSTALLED NEW ANGLE IAW SRM 51-30-2, 51-10-2, AND DRAWING 53FX1286.SDR SWAA113769Crease Beam · corrodedDURING SCHEDULED 16Y CHECK FOUND, LT CREASE BEAM WEB CORRODED BETWEEN BS 500 TO BS 500A, STR 17L. REPAIRED BEAM PER BAC DWG AND EA.SDR SWAA113768Crease Beam · corrodedDURING SCHEDULED 16Y CHECK FOUND, LT CREASE BEAM WEB CORRODED BETWEEN BS 500 TO BS 500A, STR 17L. REPAIRED BEAM PER BAC DWG AND EA.SDR SWAA113767Crease Beam · corrodedDURING SCHEDULED 16Y CHECK FOUND, LT CREASE BEAM WEB CORRODED BETWEEN BS 500A TO BS 500B, STR 17L. REPAIRED BEAM PER BAC DWG AND EA.SDR SWAA113766Crease Beam · corrodedDURING SCHEDULED 16Y CHECK FOUND, LT CREASE BEAM WEB CORRODED BETWEEN BS 414 TO BS 418, STR 17L. REPAIRED BEAM PER BAC DWG AND EA.SDR FDEA201105241970Crease Beam · damagedSTA 1630, CREASE BEAM INNER CHORD HAS A DOUBLE DRILLED HOLE AT NUT PLATE ATTACH HOLE AND .1875 FASTNER HOLE. INCOMING CONDITION. DUE TO DISCREPANCY EFFECTING THE PTF MOD A REPAIR WAS PERFORMED AT STA 1630, RBL 64.40 ON MAE EA 757-5361-16-F3161 AND MAE W/C SDR LR7A2011052400190Window Frame · crackedDURING SCHEDULED B-3 CHECK IAW FOUND LT CLEAR VISION WINDOW TOP FRAME CRACKED AT FS 117, LBL 35, WL 251.5. REPAIR ACCOMPLISHED IAW SMP 583 FIG 53-30-25. NR 2-5-3.SDR SWAA113590Crease Beam · corrodedDURING SCHEDULED 12Y CHECK FOUND, RT CREASE BEAM CORRODED FROM STA 1006 + 10 TO STA 967+ 10. REMOVED AND REPLACED BEAM PER SRM.SDR SWAA113589Crease Beam · corrodedDURING SCHEDULED 12Y CHECK FOUND, RIGHT SIDE BS 305 TO 350 Z-ANGLE CORRODED. REMOVED AND REPLACED CREASE BEAM PER SRM.SDR CA110524004Frame · crackedDURING A 100 HR INSP CONDUCTED A 3" CRACK ON ONCS RT CANOPY FRAME ATTACHMENT WEB WAS FOUND. CRACK IS ADJACENT TO THE LOWER RT DOOR ATTACHMENT. MFG WAS CONTACTED AND AN EXISTING FRAME REPAIR WAS PROVIDED. MFG FRAME REPAIR 22 DEG, 130-53-002-08.SDR FDEA201105201908Door Frame · gougedCABIN - R4 FWD DOOR FRAME REVEAL BSTA 1645 HAS A GOUGE APPROX. .2500" X .2500 AT WL 219. REPAIR ACCOMPLISHED AS PER E.A. F-5310-150704 PART 1. REPAIR IS CLASSIFIED AS MAJOR.SDR FDEA201105201906Door Frame · corrodedCABIN -FWD L2 DOOR FRAME B STA 687, WL 208.1 - WL 212 HAS CORROSION. REPAIR ACCOMPLISHED AS PER E.A. F-5310-150703 PART 1[CORROSION BLENDOUTS AT BS 690 BETWEEN WL 208.1 AND 212 FORWARD OF L2 DOOR. REPAIR IS CLASSIFIED AS MAJOR.SDR ASOA201101043Beam · corrodedFS 349, TRANSVERSE BEAM HAS CORROSION AT LT SIDE OTBD END, FWD FACE AND BOTTOM OF TOP LIP, MEASURES APPROX 2" LONG X 1.2" WIDE X .009" DEEP. REPAIRED IAW SRM 51-42-06 AND SRM 51-42-21. MINOR REPAIR.SDR DALA1135699220Door Frame · corrodedMID CARGO FUSELAGE CUTOUT JAMB CORRODED REPAIR IAW SRM53-60-02SDR FDEA201105201907Door Frame · corrodedR4 FWD DOOR FRAME REVEAL AT B STA 1645 HAS CORROSION FROM APPROX WL 208.5 - WL 211.5. REPAIR CARRIED OUT IAW EA F-5310-150704, PART 1. REPAIR IS CLASSIFIED AS MAJOR.SDR FDEA201105191884Door Frame · damagedC-1 DOOR CUTOUT, FWD FRAME BS 560, WEB AND OUTER ANGLE HAVE DRILL DAMAGE AT STR 22R, IN TWO PLACES. REMOVED DAMAGED FRAME WEB, FABRICATED & INSTALLED NEW WEB IAW DWG 65-56100, CUTOUT BS 560 CHORD, FABRICATED REPAIR PARTS & INSTALLED REPAIR IAW EA 7-5310-151200SDR DALA1138519861Pan · crackedMAIN CABIN, STA Y794, LONG 12LT, WINDOW PAN WITH CRACK. CUT OUT DAMAGE MAIN CABIN WINDOW RING PAN AT STA Y794, LONGERON 12LT PER DC9 SRM 53-05, FIG 122. FABRICATED REPAIR DBLR MAIN CABIN WINDOW RING PAN USING FABBED SHIM, FABBED REPAIR WASHER, TREATED AND PRSDR SWAA113784Door Frame · crackedDURING SCHEDULED HC2 CHECK FOUND, R1 DOOR CUTOUT FRAME STUB CRACKED. REPAIRED FRAME PER SRM.SDR SWAA113565Crease Beam · corrodedDURING SCHEDULED SPV CHECK FOUND, CREASE BEAM WEB IS CORRODED AT BS 639, RBL 68. REMOVED AND REPLACED WEB PER SRM.SDR SWAA113544Crease Beam · crackedDURING SCHEDULED 22Y CHECK FOUND, RT CREASE BEAM WEB CRACKED CRACKED AT BS 616. REPAIRED WEB PER SRM.
Back to JASC 5310