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 SWAA090861Crease Beam · corrodedDURING SCHEDULED 14Y CHECK, FOUND RT CREASE BEAM WEB CORRODED BETWEEN BS 847 TO BS 867. REMOVED AND REPLACED BEAM PER SRM.SDR SWAA090860Crease Beam · corrodedDURING SCHEDULED 14Y CHECK, FOUND RT CREASE BEAM WEB CORRODED BETWEEN BS 500C TO BS 500B. REMOVED AND REPLACED BEAM PER SRM.SDR SWAA090859Crease Beam · corrodedDURING SCHEDULED 14Y CHECK, FOUND RT CREASE BEAM WEB CORRODED BETWEEN BS 400 TO BS 420. REMOVED AND REPLACED BEAM PER SRM.SDR SWAA090832Crease Beam · corrodedDURING SCHEDULED SPV CHECK, FOUND LT CREASE BEAM WEB CORRODED BETWEEN BS 380 TO BS 400. REPAIRED BEAM PER SRM.SDR SWAA090792Crease Beam · corrodedDURING SCHEDULED 20Y CHECK, FOUND LT CREASE BEAM WEB CORRODED AT BETWEEN BS 420 TO BS 440. REPAIRED BEAM PER SRM.SDR DL757090431Crease Beam · corrodedCORROSION ON CREASE BEAM AT BS 366 RBL 65 WL 208. CREASE BEAM REPLACED WITH NEW PER SRM 51-40-02/51-40-05.SDR UIEA200800357Door Frame · crackedL1 DOOR FORWARD UPPER FRAME CRACKED. L1 DOOR UPPER FORWARD FRAME REPAIRED AS PER SRM 51-70-06.SDR FDEA200902020425Window Frame · crackedCAPTAIN SLIDING VIEW WINDOW FRAME AIRPLANE SIDE CRACKED OUTSIDE (MARKED).SDR SWIA200921321Window Post · crackedC-CHECK, RIGHT WINDSHIELD SIDE POST LOWER OUTBOARD CLIPS CRACKED. REPLACED PER SRM.SDR SWIA200921318Door Frame · crackedC-CHECK, PASSENGER DOOR FRAME AT FS 338 CRACKED. REPAIRED PER REO.SDR AALA2009020900041Beam · crackedHORIZONTAL BEAM CRACKED UNDER INBOARD SUPPORT BOLT. THIRD BEAM UP AT FORWARD ENTRY DOOR. INSTALLED REPAIR DOUBLER IN ACCORDANCE WITH AARD 52-10-00-3.SDR ZZDA2009035Door Frame · corrodedAFT CARGO DOOR LOWER JAMB HAS CORROSION. INSTALLED NEW PAN SECTION AND SPLICE REPAIR PER B717 SRM 53-20-15 REPAIR 7 FIG 201.SDR ZZDA2009029Door Frame · corrodedAFT CARGO COMPARTMENT DOOR LOWER JAM CORRODED BEYOND LIMITS. CUT OUT CORRODED AREA, INSTALLED REPLACEMENT PAN IAW B717 SRM 51-40-02.SDR FDEA200901290395Crease Beam · corrodedCABIN FLOOR CREASE BEAM WEB SKIN CORRODED AT STA 740. REMOVED AND REPLACED CREASE BEAM WEB IAW SRM 53-30-15 AND 51-40-02. THIS IS A MAJOR 'A' REPAIR NO FOLLOW-UP INSPECTION REQUIRED.SDR FDEA200901290394Crease Beam · corrodedCORRODED TOP SURFACE OF ANGULAR SUPPORT FROM STA 1260-1280 RT SIDE FLOOR LEVEL. REMOVED AND REPLACED CREASE BEAM IAW SRM 51-40-05 FROM FSTA 1180-1290 RT RBL 65. THIS IS A MAJOR 'A' WITH NO FOLLOW-UP REQUIRED.SDR FDEA200901290359Beam · crackedCRACK INDICATION STILL EXIST DURING HFEC OPEN HOLE INSPECTION ON DIAMETER 0.520 INCH HOLES AT MAIN CARGO DOOR LOWER JAMB NR 7 SUPPORT FITTING AT HOLE D, SECOND LAYER SKIN. CRACK INDICATION AT MAIN CARGO DOOR LOWER JAMB NR 7 SUPPORT FITTING AT HOLE D, SECONDSDR FDEA200901290358Support Fitting · crackedCRACK INDICATION STILL EXIST DURING HFEC OPEN HOLE INSPECTION ON DIAMETER 0.520 INCH HOLES AT MAIN CARGO DOOR LOWER JAMB NR 7 SUPPORT FITTING AT HOLE B, SECOND LAYER SKIN. REPAIRED AS PER EA 1-5310-127754, THIS REPAIR IS CLASSIFIED AS MAJOR PER GMM 6-2-100.SDR FDEA200901290357Support Fitting · crackedCRACK INDICATION STILL EXIST DURING HFEC OPEN HOLE INSPECTION ON DIAMETER 0.520 INCH HOLES AT MAIN CARGO DOOR LOWER JAMB NR 7 SUPPORT FITTING AT HOLE A, SECOND LAYER SKIN. REPAIRED AS PER EA 1-5310-127754, THIS REPAIR IS CLASSIFIED AS MAJOR PER GMM 6-2-100.SDR AALA2009021600128Door Frame · corrodedCORROSION ON VERTICAL AND HORIZONTAL LEG OF DOOR JAMB BEAM AT MID CARGO. INSTALLED DOUBLER IN ACCORDANCE WITH 53 10 00 3.SDR DLM88090137Door Frame · corrodedEXFOLIATION CORROSION ON LWR DOOR JAMB BTW STA Y=636 TO 693 REPAIRED PER SRM 53-05D FIG 123.SDR SWAA090607Crease Beam · crackedDURING SCHEDULED 20Y CHECK, FOUND CREASE BEAM WEB CRACKED BETWEEN BS 360 TO BS 380, STR 17R. REMOVED AND REPLACED WEB PER SRM.SDR SWAA090606Crease Beam · corrodedDURING SCHEDULED 20Y CHECK, FOUND RT CREASE BEAM WEB CORRODED BETWEEN BS 616 TO BS 639. REPAIRED WEB PER SRM.SDR SWAA090604Crease Beam · corrodedDURING SCHEDULED 20Y CHECK, FOUND LT CREASE BEAM WEB CORRODED BETWEEN BS 616 TO BS 639. REPAIRED WEB PER SRM.SDR SIMA200902802Profile · corrodedDURING IMBV, THE MAIN DOOR AFT LOWER CORNER PROFILE WAS FOUND CORRODED. REMOVED CORRODED PROFILE AND DRILLED UP NEW PROFILE (P/N 145-34499-002). CLEANED, ALODINED, PRIMED AND INSTALLED NEW PROFILE IAW EMB SRM 51-20-01, 51-20-03 AND 51-40-02. AIRCRAFT RETURNSDR DLM88090135Door Frame · corrodedEXFOLIATION CORROSION ON LOWER DOOR JAMB BTW STA Y=370 TO 427 AT FWD CARGO COMPARTMENT. REPAIRED PER SRM 53-05D FIG 804D.SDR DLM88090107Door Frame · corrodedEXFOLIATION CORROSION ON LWR BEAM BTW STA Y-1155 TO 1212 AT AFT CARGO COMPARTMENT DOOR JAMB. CORROSION REMOVED PER 51-10-3. BLENDED OUT OF LIMITS, SRM 53-05 FIG 123. DAMAGED AREA REMOVED SRM 53-05 FIG 123 SHEET 5.SDR ASOA200900148Support Beam · crackedCARGO DOOR SUPPORT BEAM LOWER ANGLE IS CRACKED APPROX .5" IN LENGTH.SDR SIMA200902804Cup · corrodedDURING AN IMBV INSPECTION, THE TOILET DISCHARGE CUP WAS FOUND TO BE CORRODED. REMOVED THE CORRODED DISCHARGE CUP. POSITIONED NEW DISCHARGE CUP, DRILLED HOLES, CLEANED, ALODINED AND PRIMED. REPAIR DONE IAW EMB SRM (SRM EMB145/1142 REV 40) CHAPTERS 51-20-01, SDR SIMA200902803Beam · corrodedDURING AN IMBV INSPECTION, THE RT GALLEY BEAM WAS FOUND TO BE CORRODED BETWEEN FRAMES 20 AND 22. REMOVED THE CORRODED BEAM, POSITIONED NEW BEAM, DRILLED, CLEANED, ALODINED AND PRIMED REPAIR PART. REPAIR DONE IAW EMB SRM (SRM EMB 145/1142 REV 40) CHAPTER 51-2SDR DLM88090105Door Frame · corrodedEXFOLIATION CORRROSION ON LWR DOOR JAMB BRW STA Y636 TO 693 NRC T0120749 HMV. REPAIRED PER SRM 53-05 FIG 123.SDR FDEA200901240315Crease Beam · corrodedCABIN FLOOR SUPPORT ANGLE AT BS 755-780 LBL64 CORRODED. CORROSION FOUND TO BE OUT OF LIMIT AS PER SRM 53-30-13 FIG 101 DETAIL VIII. REPLACED CREASE BEAM IAW SRM 51-40-02 AND SRM 53-50-13, CATEGORY "A" MAJOR REPAIR.SDR F3LA2009012600009Shear Plate · corrodedINSPECTION NOTED SHEAR PLATE CORROSION IN THE AFT GALLEY, RT FROM FRAME 69 TO FRAME 70. MAINTENANCE REMOVED AND REPLACED SHEAR PLATE IAW SRM 51-42-00, 51-72-11 AND 53-41-14.SDR F3LA2009012600008Shear Plate · corrodedINSPECTION NOTED SHEAR PLATE CORROSION IN THE AFT GALLEY, LT FROM FRAME 69 TO FRAME 70. MAINTENANCE REMOVED AND REPLACED THE SHEAR PLATE IAW SRM 51-42-00, 51-72-11 AND 53-41-14.SDR F3LA2009012600007Support Frame · corrodedINSPECTION NOTED CORROSION ON THE SHEAR PLATE SUPPORT FRAME, LOCATED IN THE AFT GALLEY, LT FROM FRAME 69 TO FRAME 70. MAINTENANCE REMOVED AND REPLACED SUPPORT FRAME IAW SRM 51-42-00, 51-72-11 AND 53-41-14.SDR F3LA2009012600006Support Frame · corrodedINSPECTION NOTED CORROSION ON THE SHEAR PLATE SUPPORT FRAME, LOCATED IN THE AFT GALLEY, RT FROM FRAME 69 TO FRAME 70. MAINTENANCE REMOVED AND REPLACED SUPPORT FRAME IAW SRM 51-42-00.SDR C2XA09SH039Window Post · corrodedSHV-DURING C-CHECK COPILOT WINDSHIELD CUTOUT STRUCTURE LOWER O/B SCREW HOLES CORRODED. MX CLEANED LOWER CO-PILOT WINDSHIELD CUTOUT NUTPLATE HOLES AND FOUND DIRT AND DEBRIS ONLY, NO CORROSION FOUND ON LOWER O/B HOLES IAW 145 CPM 51-00-01. MX ALODINED, PRIMED SDR C2XA09SH038Window Post · corrodedSHV-DURING C-CHECK PILOT WINDSHIELD CUTOUT STRUCTURE LOWER O/B SCREW HOLES CORRODED. MX CLEANED PILOT WINDSHIELD CUTOUT STRUCTURE LOWER O/B SCREW HOLES AND FOUND NO CORROSION ONLY DIRT AND DEBRIS IAW CPM 51-00-01. MX THEN ALODINED, PRIMED AND PAINTED PILOT WISDR AALA20090417TUL02Static Port · debondedLEFT STATIC CASTING IS DISBONDED FROM SKIN AT STATION 465 AND LONGERON 27 LEFT. REMOVED AND INSTALLED SERVICEABLE STATIC PORT CASTING PER MM 53-30-00-7, RVSM CHECK ACCOMPLISHED PER E-58 6256771.SDR AALA2009021100087Beam · corrodedAFT CARGO DOOR LOWER DOOR BEAM VERTICAL FACE HAS CHIPPED PAINT AND LIGHT CORROSION. AREA OF DISCREPANCY IS THREE INCHES BY THREE INCHES. INSTALLED DOUBLER PER AARD 53-10-00-3.SDR AALA2009021600133Window Frame · crackedLOWER WINDOW FRAME TAB CRACKED AT LEFT STATION 1022 TO 1041. INSTALLED REPAIR ANGLE PER AARD 53-10-00-25, MSR 018352.SDR AALA2009021600131Window Frame · crackedFORWARD LOWER WINDOW FRAME TAB AT LEFT STATION 1079 TO 1098 CRACKED. INSTALLED DOUBLER PER AARD 53-10-00-25, MSR 018339.SDR AALA2009021600129Window Frame · crackedAFT UPPER WINDOW FRAME TAB CRACKED AT LEFT STATION 1022 TO 1041. INSTALLED REPAIR ANGLE PER AARD 53-10-00-25 MSR 018353.SDR DLM88090267Door Frame · corrodedEXFOLIATION CORROSION ON LOWER DOOR JAMB BTW STA Y=370 TO 427 AT FWD CARGO COMP. REMOVED CORROSION IAW SRM 51-10-3 PAR 35. FOUND OUT OF LIMITS IAW SRM 53-01 FIG 1. INSTALLED REPAIR PARTS IAW SRM 53-05D.SDR SWAA090469Crease Beam · corrodedDURING SCHEDULED 24Y CHECK, FOUND CREASE BEAM CORRODED BETWEEN BS 380 TO BS 400. REPAIRED BEAM PER SRM.SDR FDEA200901210292Roller Tray · corrodedTHE ROLLER TRAY AT FRAME 29; LBL 12 INCHES IS CORRODED. REMOVED CORROSION IAW A310-200 SRM 51-74-10 & FOUND TO BE OUT IF LIMITS IAW SRM 53-10-15; PG 8; FIG 108. REMOVED & RE-INSTALLED THE LATCHES IAW AMM 25-52-57-4; PG 2; PARA B&D. REMOVED & RE-INSTALLED SDR FDEA200901200277Door Frame · crackedCRACK INDICATION FOUND DURING OPEN HOLE HIGH FREQUENCY EDDY CURRENT INSPECTION ON HOLE NR A ON SECOND SKIN LAYER IN MAIN CARGO DOOR LOWER JAMB NR 1 FITTING. REPAIR CARRIED OUT AS PER E.A. 1-5310-127741, REPAIR CLASSIFIED AS MAJOR AS PER GMM 6-2-100.SDR FDEA200901200271Door Frame · crackedCRACK INDICATION FOUND ON HOLE NR C ON FIRST SKIN LAYER IN MAIN CARGO DOOR LOWER JAMB NR 1 FITTING DURING OPEN HOLE HIGH FREQUENCY EDDY CURRENT INSPECTION.SDR FDEA200901200270Door Frame · crackedCRACK INDICATIONS FOUND ON HOLE NR A ON FIRST SKIN LAYER IN MAIN CARGO DOOR LOWER JAMB NR 1 FITTING DURING OPEN HOLE HIGH FREQUENCY EDDY CURRENT INSPECTION.SDR C2XA09SH023Door Frame · corrodedDURING C-CHECK, CARGO DOOR LOWER CUTOUT CORRODED. R&R CARGO DOOR LOWER CUTOUT IAW EMB 145 SRM 51-40-02. ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR DLM88090265Beam · corrodedEXFOLIATION CORROSION ON LOWER BEAM OF AFT CARGO DOOR. CORROSION WAS REMOVED AND FOUND TO BE OUT OF LIMITS IAW SRM 53-01 FIG 1. REPAIR PARTS INSTALLED IAW SRM 53-05 FIG 12B.
Back to JASC 5310