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 2007UALA04446Structure · corrodedFWD GALLEY HAS CORROSION DAMAGE. FOUND WATER PENETRATION BELOW GALLEY SUBFLOOR. REPAIRED FLOOR STRUCTURE.SDR 07FDEA04696Door Frame · crackedFOUND CRACKED SEALING SECTION AT AFT CARGO DOOR C63A , P 26A-P30. REPAIR PERFORMED BY REPLACEMENT OF PART IAW SRM 51-72-10.SDR 2007UALA04462Crease Beam · corrodedCORROSION FOUND AT STA 1420 TO STA 1440 AT CREASE BEAM IN MAIN CABIN.SDR 2007UALA04461Crease Beam · corrodedCORROSION FOUND AT STA 1380 TO STA 1400 AT STR 17R,CREASE BEAM IN MAIN CABIN.
SDR SWAA075400Crease Beam · corrodedDURING SCHEDULED 8Y CHECK, FOUND CREASE BEAM WEB CORRODED AT BS 986 TO BS 997, RBL 48. REMOVED AND REPLACED WEB PER SRM.SDR UPS07851090Doubler · crackedINSPECTION TYPE:C1 AFTER REMOVAL OF EXTERIOR RT CV WINDOW RETAINER FOUND INTERNAL DOUBLER CRACKED AT UPPER FWD CORNER STA -72. REPAIRED RT CV WINDOW INTERNAL DOUBLER AT STA -72 IAW SAA EA NR 008- 5600-01-A1197, UPS RAA NR DC8-53-20669, AND FAA FORM 8100-9.SDR 07FDEA04703Structure · contaminatedCTR TANK FUEL QUANTITY FLUCTUATES IN FLIGHT FROM 60 LBS TO 1080 LBS. SHOWED 1.0 IN CTR FOR TAKEOFF. STAB TRIM WAS ADJUSTED ACCORDINGLY. NOSE WAS VERY LIGHT ON TAKEOFF ROLL AND TOOK EXCESSIVE NOSE DOWN TRIMMING TO GET AIRCRAFT IN TRIM. ONCE IN FLIGHT RECHESDR TRAX200701714Seal · corrodedTAIL BUMPER SURROUND SEAL (DOUBLER) CORRODED.SDR SWAA075316Door Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FWD CARGO DOOR CUTOUT FWD FRAME CRACKED AT NR 5 DOOR STOP. REPAIRED FRAME PER SRM.SDR COEA0742821Crease Beam · corrodedFOUND DURING HEAVY CHECK. MAJOR REPAIR. LEVEL 2 CORROSION ON RT AND LT AFT CREASE BEAM WEBS. FORMED AND INSTALLED NEW REPLACEMENT WEBS. LT CREASE BEAM PN S53671217, RT CREASE BEAM PN S53671318. WO 72242 NR 200082. (K)SDR SIMA200729912Door Frame · corrodedDURING MBV INSP, AFT LOWER SERVICE DOOR FRAME CORRODED. REPAIRED FRAME IAW EO EM-53MR-842. AIRCRAFT RETURN TO SERVICE.
SDR 07FDEA04662Window Frame · chafedFOUND WEAR MARKS ON SLIDING WINDOW FRAME, LHS REPAIR PERFORMED BY SMOOTH BLEND OUT, NDT FOR CRACK FREE IAW EA 6-5612-114907 AND RAS 054606/005/2007 ISS A.SDR KCSA071487Structure · crackedFORWARD BILGE UPPER TORQUE BOX WEB IS CRACKED .5 INCH AT STA 663, LBL 15.SDR TRAX200701563Crease Beam · noneRIGHT CREASE BEAM ZEE FLOOR CORRODED AT FLOORBEAM 40. FOUND WITHIN LIMITS.SDR TRAX200701562Crease Beam · corrodedCREASE BEAM CORRODED AT STR 14 BETWEEN FR 13+17. REPAIRED.SDR SIMA200729913Door Frame · gougedDURING A MBV INSPECTION, THE CARGO DOOR FORWARD FRAME WAS FOUND TO BE GOUGED. REMOVED GOUGED FRAME AND REPLACE WITH NEW FRAME PN 145-23775-601 IAW SRM CHAPTERS 51-10-03, 51-40-02, AND 51-40-04. AIRCRAFT RETURN TO SERVICE.SDR 07FDEA04661Structure · scratchedFOUND SCRUB MARKS ON CROSS SHEET C55-57.1, LT AND RT REPAIR PERFORMED BY REWORK OF DAMAGED AREA, NDT FOR CRACK FREE IAW EA 6-5316-114890 AND RAS /DATLS/0003844/2007 ISS A.SDR 2007UALA04329Door Frame · crackedFORWARD GALLEY DOOR (1R) 4TH STOP FITTING FROM TOP ON AFT FRAME HAS CRACK AT CUTOUT. FABRICATED AND INSTALLED FRAME REPAIR DOUBLER.SDR FDEA200710194652Door Frame · crackedAIR CONDITIONING COMPT RT SIDE ON FRAME JAMB DOOR FOUND CRACK. REPAIRED AREA IAW SRM 53-00-01 FIG 8 VOL I.SDR ABXA070371Window Frame · crackedDURING COCKPIT WINDSHIELD FRAME MOD, FOUND FRAME 9911505-7 CRACKED AT BOTH ENDS. REPAIRED FRAME IAW DC9 SRM 53-03, FIGURE 34.SDR ABXA070370Window Frame · crackedDURING COCKPIT WINDSHIELD FRAME MOD, FOUND FRAME 9911505-6 CRACKED AT INBOARD END. REPAIRED FRAME IAW DC9 SRM 53-03, FIGURE 34.SDR ABXA070369Window Frame · crackedDURING COCKPIT WINDSHIELD FRAME MOD, FOUND FRAME 9911505-5 CRACKED AT INBOARD END. REPAIRED FRAME IAW DC9 SRM 53-03, FIGURE 34.SDR ABXA070373Angle · crackedDURING COCKPIT WINDSHIELD FRAME MOD, FOUND ANGLE AT INBOARD TIP OF FRAME CRACKED. REPLACED ANGLE IAW DC9 SRM 51-30-2 AND 51-30-5.SDR ABXA070372Angle · crackedDURING COCKPIT WINDSHIELD FRAME MOD, FOUND ANGLE CRACKED IN RADIUS. REPLACED ANGLE IAW DC9 SRM 51-30-2.SDR F3LA200700288Dummy Rail · corrodedDURING C4/S1 CHECK, INSPECTION REPORTED FLOORBEAM Y503.2 CORRODED ON UPPER SURFACE BETWEEN FRAMES 14 AND 16. DETERMINED CORROSION ON DUMMY RAIL Y503.2 TO BE OUT OF LIMITS IAW A319 SRM 53-11-14, FIG 106. REMOVED AND INSTALLED DUMMY RAIL Y503.2 IAW 51-42-11, ASDR 2007UALA04331Door Frame · crackedFWD CARGO DOOR CUTOUT, AFT FRAME CRACKED ON UPPER INNER RADIUS, ADJACENT TO THE LOWER DOOR STOP FITTING. FABRICATED AND INSTALLED DOUBLER REPAIR ANGLES REPAIR.SDR PIDR07015Structure · crackedDURING C-CHECK, NOTED CRACK BETWEEN FASTENERS AT BS 178 RT AT WL 190. REPAIRED DAMAGE FROM BS 178 TO BS 182 AT WL 190 IAW EA NR 53-286.SDR SWAA075148Crease Beam · corrodedDURING SCHEDULED BRDG CHECK, FOUND CREASE BEAM WEB CORRODED BETWEEN BS 400 AND BS 420, LBL 70. REMOVED AND REPLACED WEB PER SRM.SDR 07FDEA04648Retainer · corrodedRT FWD OVERWING DOOR FRAME, PRESSURE SEAL ATTACH ANGLE IS CRACKED/CORRODED ON ALL FOUR SIDES AS MARKED REMOVED UPPER AND LOWER SEAL ATTACH ANGLES. INSTALLED 2 NEW ANGLE TO DOOR FRAME REF 51-30-02. REPAIR IS CLASSIFIED AS A MINOR.SDR USAA920071047Door Frame · crackedCLT - MAJOR REPAIR - C20 CHECK, AFT CARGO COMPARTMENT DOOR CUTOUT AFT FRAME CRACKED, BS 846.5, S24R. REPAIRED AFT CARGO COMPARTMENT DOOR CUTOUT AFT FRAME, BS 846.5, S24R IAW B737 SRM 53-00-53.SDR 07FDEA04635Door Frame · corrodedRT FWD OVERWING DOOR FRAME EXTERIOR SURFACE IS CORRODED AT 7:00 POS AS VIEWED FROM OUTSIDE REMOVED CORROSION ON DOOR FRAME REF SRM 51-10-6, MEASURED THICKNESS REF 727 NDT MAN PT 4, 51-00-00, FIG 2 ORIGINAL "T" .063". REMAINING "T" IS .060" IN DEEPEST LOCATIOSDR 07FDEA04634Door Frame · corrodedRT AFT OVERWING DOOR FRAME EXTERIOR SURFACE IS CORRODED ALONG PRESSURE SEAL ATTACH ANGLE AT 5:00 TO 8:00, POS AS VIEWED FROM OUTSIDE. REMOVED CORROSION FROM FRAME SURFACE REF SRM 51-10-1 PG 14-16. MEASURED THICKNESS REF. 727 NDT MAN. PT. 4, 51-00-00. FIG SDR 2007UALA04272Crease Beam · corrodedRIGHT AFT GALLEY CREASE BEAM UPPER SURFACE CORRODED BS 947-998. REMOVED AND INSTALLED REPLACEMENT CREASE BEAM.SDR UPS07851095Window Frame · corrodedINSPECTION TYPE:C2 WINDOW FRAME AT STA -67 L11L CAPT SIDE HAS EXFOLOIATED CORROSION. REPAIRED CAPT LT AFT WINDOW FRAME AT STA -67 L11L IAW SAA EA NR 008- 5310-01-A1194, UPS RAA NR DC8-53-20665, AND BAC SERV ID 1-659403655.SDR UPS07851094Fitting · crackedINSPECTION TYPE:C2 INSIDE 60 HOLE LONGERON END FITTING CRACKED AT STA 1766 L19R. REMOVED AND REPLACED LONGERON END FITTING AT STA 1766 L19R IAW SRM 51-1-21, AND SRM 51-1-20D.SDR 2007UALA04256Crease Beam · corrodedAFT GALLEY LT CREASE UPPER FLANGE CORRODED AT SERVICE DOOR CUTOUT AT FLOOR LEVEL BS 967-993 AT LBL 47-53. REMOVED AND REPLACED CREASE BEAM WITH NEW PART.SDR SWAA075073Crease Beam · corrodedDURING SCHEDULED SPV CHECK, FOUND CREASE BEAM WEB CORRODED AT BS 639, STR 17R. REPAIRED WEB PER SRM.SDR DALA1129249220Splice · corrodedCORROSION ON SPLICE BAR AT STA 1241 OF AFT CARGO COMPARTMENT SRM 53-30-01, FIG 3.SDR UPS07851079Window Frame · corrodedC2 COCKPIT LT CENTER WINDSHIELD "Z" FRAME HAS HEAVY CORROSION. REMOVED, DRILLED UP, AND INSTALLED REPLACEMENT "Z" FRAME ON COCKPIT LT CENTER WINDSHIELD IAW SRM 51-21-1, AND SRM 51-03-02 FIG 005.SDR PIDR07013Crease Beam · crackedDURING C CHECK, FOUND CRACK AT THE END OF THE LT SIDE CREASE BEAM AT BS 180. REPAIRED IAW SRM 51-70-12 AND SRM 51-40-01.
SDR UPS07851093Finger Doubler · corrodedINSPECTION TYPE:C2 FINGER DOUBLER AT STA 123 L31R IS CORRODED AND CRACKED. REMOVED, FABRICATED, AND INSTALLED REPAIR FINGER DOUBLER AT STA 123 L31R IAW SRM 51-1-20D, AND DWG 5773316.SDR SWAA075056Crease Beam · corrodedDURING SCHEDULED BRDG CHECK, FOUND CREASE BEAM WEB CORRODED BETWEEN BS 360 AND BS 380, RBL 70. REPAIRED WEB PER SRM.SDR 0700574Door Frame · crackedFWD CARGO DOOR CUTOUT AFT FRAME CRACKED. REPLACED FRAME PER SRM 51-40-02.SDR DLM90071424Doubler · corrodedMID CARGO LOWER JAMB DOUBLER PLATE HAS CORROSION FROM FWD END TO AFT END REF TASK 53-12-02-02. REPAIRED LOWER DOOR JAMB DOUBLER IAW MD-90 53-05D FIG 63 ON N/R 1000-0043 ON HMV-2 IN OKC.SDR 0700573Door Frame · crackedC-1 DOOR CUTOUT FED FRAME CRACKED AT LWR STOP PAD MOUNT. REMOVED AND REPLACED PER SRM 51-40-02.SDR KCSA071460Door Frame · dentedAFT PIT CARGO DOOR FWD FRAME DENTED 12 INCHES ABOVE THE FWD PULL IN LATCH AT STA 1820 STR 37R.SDR QXEA200701558Unknown · damagedPDX - C4 CHECK, REFERENCE REO 670-53-11-188 SHEET 3 MAP M, BURNT MATERIAL AROUND FASTENER HOLE AT FS 893 2" BELOW STRINGER 5L. REPAIRED IAW REO 670-53-11-188 PAGE 3 MAP M STEPS 9 10 AND 11.SDR QXEA200701562Unknown · damagedPDX - C4 CHECK. REFERENCE REO 670-53-11-188 SHEET 3 MAP S, BURNT MATERIAL AROUND FASTENER HOLE 2.8" FORWARD OF FS 453 AT STRINGER 1L REQUIRES REPAIR. HFEC AREA WITH NO CRACKS NOTED. COMPLIED WITH STEPS 5-8 OF REO 670-53-11-188 PAGE 3 MAP S.SDR QXEA200701563Door Frame · corrodedPDX - C4 CHECK. CORROSION AT 2 NUTPLATES AT FRAME AFT OF CARGO DOOR ABOVE FLOOR LEVEL AT FS 1047 WL 98-106. REMOVED NUTPLATES AND REMOVED CORROSION BY BLENDING WITH SCOTCHBRITE. HFEC AREA WITH NO CRACKS NOTED. BLEND FOUND TO BE WITHIN LIMITS MAX MATERIAL REMOVSDR QXEA200701561Unknown · damagedPDX- C4 CHECK. REFERENCE REO 670-53-11-188 SHEET 3 MAP R. BURNT MATERIAL AROUND FASTENER HOLE AT FS 724.08, 2.1" BELOW STRINGER 3L REQUIRES REPAIR. HFEC AREA AND FOUND NO CRACKS, INSTALLED REPAIR DOUBLER IAW REO 670-53-11-188 SHEET 3 MAP R. INSTALLED FILLER
Back to JASC 5310