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 SWIA200921362Structure · damagedFLT 4546 - DENT AFT OF NOSE ACCESS PANEL, FORWARD OF PRESSURE BULKHEAD. REPLACED STRINGER 19 LT.SDR ASAA0945001Door Frame · chafedFWD ENTRY DOOR AFT EDGE FRAME TOP CORNER IS CHAFED. REPAIRED IAW.SDR AALA20090423TUL12Beam · corrodedLEVEL 1 CORROSION ON THREE AREAS OF MID CARGO DOOR BEAM VERTICAL LEG. ACCOMPLISHED REPAIR PER AARD 53-10-00-3.SDR DLM88090601Beam · corrodedAFT PIT CARGO DOOR CUT OUT LOWER BEAM CORRODED. REPLACED BEAM PER 53-05 FIG 123 ON NR 202911.SDR FDEA200904021161Flange · corrodedAFT FUSELAGE CUTOUT FOR APU INTAKE DOOR HOUSING FLANGES ARE CORRODED. REMOVED CORROSION IAW SRM 51-10- 02. OUT OF LIMITS PER SRM 53-80-05, FIG 101, DETAIL 5 AND SRM 53-80-01, FIG 101, DETAIL 3. FABRICATED UPPER FLANGE ON MAE TRAVELER NR T9/782221, LWR FLANSDR FDEA200904021145Frame · corrodedSTA 1640, AFT SIDE OF FRAME CORRODED BETWEEN STRINGER 26R AND 26L. CORROSION RUNNING INTO TRANSITION PANELS, U-CHANNELS AND VERTICAL SUPPORT STIFFENERS. REPLACED IAW SRM 51-40-02. REPAIR IS CLASSIFIED AS MAJOR PER GMM 6-2-100 CRITERIA.SDR FDEA200904021142Crossbeam · corrodedFOUND CORROSION ON CROSSBEAM C 58 REPAIR PERFORMED BY REPLACEMENT OF PART IAW SRM 51-72-10.SDR FDEA200904021141Plate · corrodedCORROSION FOUND ON AFT PRESSURE DECK AREA FROM STA 1710 TO STA 1720, RBL 55 TO LBL 55. CORROSION ON PRESSURE DECK PLATE FOUND EXCEEDED SRM ALLOWABLE DAMAGE LIMITS. DECK PLATE REPAIRED IAW EA F-5310-126215: FUSELAGE MAIN FRAME DECK PLATE REPAIR FROM BS 1681.8SDR SWAA092114Crease Beam · crackedDURING SCHEDULED 24Y CHECK, FOUND LT CREASE BEAM CHORD CRACKED AT BS 618. REPAIRED BEAM PER SRM.SDR SWAA092105Crease Beam · corrodedDURING SCHEDULED 8Y CHECK, FOUND CREASE BEAM CORRODED BETWEEN BS 930 TO BS 986, STR 17R, RBL 55. REMOVED AND REPLACED BEAM PER SRM.SDR SWAA092102Door Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FWD CARGO DOOR CUTOUT AFT SIDE FRAME CRACKED AT BS 492, RBL 67. REPAIRED FRAME PER SRM.SDR FDEA200904011134Beam · corrodedTHE BULK CARGO DOOR, LOWER CUTOUT SHIN PLATE, HAS CORROSION BELOW THE FASTENER HOLE AT FRAMES 68 - 69. REMOVED THE CORROSION ON THE LOWER CUTOUT SKIN PLATE IAW A300-600 SRM 51-74-10. MATERIAL THICKNESS IS 0.079. MATERIAL REMOVED 0.013. MATERIAL REMAINISDR SWAA092061Crease Beam · corrodedDURING SCHEDULED 14Y CHECK, FOUND LT CREASE BEAM CORRODED AT BS 884. REPAIRED BEAM PER SRM.SDR SWAA092060Crease Beam · corrodedDURING SCHEDULED 14Y CHECK, FOUND LT CREASE BEAM CORRODED AT BS 801. REPAIRED BEAM PER SRM.SDR DL75E090765Structure · corrodedCORROSION ON CHORD STA 720 LBL62. REMOVED AND REPLACED CHORD PER SRM 51-40-02 ON NR 127685 DURING HMV AT SAA IN SAT.SDR DLM88090565Beam · corrodedAFT CARGO DOOR CUTOUT LOUVER BEAM CORRODED STA 1155-1212. REPAIRED BEAM IAW SRM 53-05 FIG 123.SDR IXXA09SMN061SStructure · crackedDURING ROUTINE C CHECK INSPECTION, FOUND FORWARD ACCESSORY COMPARTMENT LEFT CAP CRACKED STATION 55.000 - 70.000 RIGHT BOTTOM LINE 45. REMOVED CRACKED CAP. INSTALLED NEW CAP IAW DC8 SRM 51-1-20D, SRM 51-3-1, ATI REPAIR SPECIFICATION NUMBER 2003-05, AND SMN-FOSDR IXXA09SMN060SStructure · crackedDURING ROUTINE C CHECK INSPECTION, FOUND FORWARD ACCESSORY COMPARTMENT LEFT CAP CRACKED STATION 55.000 - 70.000 LEFT BOTTOM LINE 45. REMOVED CRACKED CAP. INSTALLED NEW CAP IAW DC8 SRM 51-1-20D, SRM 51-3-1, REPAIR SPECIFICATION NR 2003-05, AND SMN-FORM-07 IPSDR DLM88090556Door Frame · damagedDURING HMV A PUNCTURE WAS FOUND ON LOWER DOOR JAMB OF R1 AT STA Y=171 AND TOOLING MARKS. LOWER DOOR JAMB WAS REPAIRED IAW SRM 53-05 FIG 55.SDR DLM88090553Beam · corrodedDURING HMV CORROSION WAS FOUND ON LOWER DOOR JAMB BTW STA Y=636 TO 693. LOWER DOOR BEAM WAS REPAIRED IAW SRM 53-05 FIG 123.SDR SWIA200921398Isolation Mount · crackedC-CHECK, CARGO COMPARTMENT AFT BULKHEAD ISOLATOR CRACKED RBL9. REPLACED PER SRM.SDR SWIA200921377Structure · damagedFLT 4843 - MAJOR REPAIR REQUIRED DUE TO BIRD STRIKE. REPAIRED PER REO.SDR IXXA09SMN034SStructure · crackedDURING ROUTINE C CHECK INSPECTION, FOUND FUSELAGE NOSE SECTION EXTERIOR PRIMARY HEAT EXCHANGER AFT LOWER CORNER CRACKED AT STATION 12.000 LONGERON 27 RIGHT. REMOVED FASTENERS AS NEEDED TO PERFORM REPAIR. REMOVED DAMAGED AREA. PERFORMED NDT INSPECTION. NO CSDR IXXA09SMN033SStructure · crackedDURING ROUTINE C CHECK INSPECTION, FOUND FUSELAGE NOSE SECTION EXTERIOR PRIMARY HEAT EXCHANGER AFT LOWER CORNER CRACKED AT STATION 12.000 LONGERON 27 LEFT. REMOVED FASTENERS AS NEEDED TO PERFORM REPAIR. REMOVED DAMAGED AREA. PERFORMED NDT INSPECTION. NO CRSDR FDEA200903271083Beam · crackedFOUND CRACK ON TRACK 4 LT AT C49 AND 51 ABOVE CENTER TANK. REPAIR PERFORMED IAW DRAWING R538-10581 AND RAS 70518174/022/2009 ISS A, APPROVED BY EA 6-5310-120236.SDR FDEA200903251425Crossbeam · crackedCROSSBEAM AT FR36 CRACKED AT Y-953. CROSSBEAM AT FR 36 WAS REPAIRED AS PER SRM SUPP 53-10-15 FIG 201 SHEET2A.SDR DU4R2009334Shear Plate · corrodedDURING SCHEDULED INSP, FOUND CORRODED BOLT JOINT ON SHEAR PLATE AT BS 1016 B/L 0.SDR COEA2009032502912Crease Beam · damagedIN HEAVY CHECK: FOUND FR27 LT SIDE AT CREASE BEAM DAMAGED. DAMAGED AREAS EXCEED OUT OF DAMAGE TOLERANCE.SDR SWAA091982Crease Beam · corrodedDURING SCHEDULED 8Y CHECK, FOUND CREASE BEAM CHORD CORRODED BETWEEN BS 305 TO BS 328, RBL 55. REPAIRED BEAM PER SRM.SDR FDEA200903241668Beam · corrodedRT FWD PAX DOOR, SPOTS OF CORROSION AT BEAM 3. BEAM 3 WAS REPLACED AS PER SRM 51-72-10.SDR CA090325008Bolt · failedMEDIUM DENSITY MAGNETOMETER SURVEY ARRAY WAS INSTALLED ON THE SUBJECT AIRCRAFT PER STC SH03-32 FOR A SURVEY BEING PERFORMED. WHILE FLYING ON SURVEY ON MARCH 23, 2009, THE PILOT AND OPERATOR HEARD A BANG AND THE PILOT NOTICED A VIBRATION FROM THE ARRAY BOOM STSDR A6WA200940167Crossbeam · crackedRT PILOT BULKHEAD CROSSBEAM INBD CLIP FOUND CRACKED .500 INCH. RT PILOT BULKHEAD CROSSBEAM FS 280.00, RBL 9.0, INBD CLIP REPLACED IAW SRM 51-42-06 AND 51-42-21. (K)SDR 2009FA0000280Structure · crackedSTC SA8168NM-D WAS INSTALLED ON THIS ACFT AND INCLUDED AN ACTIVE NOISE AND VIBRATION CONTROL SYS. CRACKS HAVE BEEN DISCOVERED IN PRIMARY STRUCTURE (AFT PRESSURE BULKHEAD STIFFENERS) WHERE (2) SHAKERS WERE ATTACHED. RECOMMEND SUSPENDING USE OF THIS SYS IMMEDISDR SWAA091936Crease Beam · crackedDURING SCHEDULED 24Y CHECK, FOUND RT CREASE BEAM WEB CRACKED BETWEEN BS 639 TO BS 664. REPAIRED BEAM PER SRM.SDR SWAA091911Crease Beam · corrodedDURING SCHEDULED SPV CHECK, FOUND RT CREASE BEAM CORRODED BETWEEN BS 727A TO BS 767, STR 17R. REPAIRED BEAM PER SRM.SDR SWAA091873Crease Beam · corrodedDURING SCHEDULED 8Y CHECK, FOUND RT CREASE BEAM CORRODED AT R2 DOOR LOWER SILL. REPAIRED BEAM PER SRM.SDR IPXA09555448Crease Beam · corrodedINSPECTION TYPE:C3 CREASE BEAM INNER CHORD CORRODED AT STA 655 LBL 64. REMOVED CORROSION, NDT, ALODINE & PRIMED IAW EO B757-5310-33042A.SDR ASAA0975008Door Frame · damagedAFT PIT DOOR CUTOUT WEB STA 790 HAS EDGE DAMAGE ABOVE STR 25R. REMOVED DAMAGED WEB, FABRICATED, TREATED, PRIMED AND INSTALLED NEW WEB IAW B737 700 SRM 53 60 15.SDR ASAA0944845Door Frame · damagedFWD CARGO DOOR CUTOUT AFT FRAME HAS AN OUT OF ROUND HOLE RBL 26 WL 156. REMOVED AND REPLACED FRAME PER DWG 69-18202 AND SRM 51-40-02.SDR AALA20090331TUL19Crease Beam · corrodedCABIN RIGHT FORWARD GALLEY DOOR CREASE ANGLE CORRODED AT STATION 298 - 312. INSTALLED NEW CREASE ANGLE PER SRM 51-10-02.SDR A6WA200940153Crossbeam · crackedRT SIDE PILOTS BULKHEAD CROSSBEAM FS 280.00, RBL 9.0 IS CRACKED. RT SIDE PILOTS BULKHEAD CROSSBEAM FS 280.00, RBL 9 REPAIRED IAW REO 601R-53-11-171, REV D. (K)SDR FDEA200903190962Beam · corrodedFOUND CORROSION ON AFT CARGO DOOR SILL BEAM C 59-C59A. REPAIR PERFORMED BY CUT OUT THE AFFECTED PART AND INSTALLING REINFORCEMENT, FILLER AND NUT PLATES IAW RAS/EFW/9000150/2008 ISS A, APPROVED BY EA 6-5310-120197.SDR SWIA200921969Door Frame · corrodedPASSENGER DOOR BOTTOM FRAME CORRODED. (C CHECK) REPAIRED PER SRM.SDR AALA20090331TUL09Crease Beam · corrodedAFT CABIN, RIGHT CREASE ANGLE AT SERVICE DOOR HAS CORROSION STATION 977-990 RIGHT BODY LINE 48 INCHES. INSTALLED NEW SECTION OF CREASE ANGLE.SDR SWAA091794Crease Beam · crackedDURING SCHEDULED SPV CHECK, FOUND LT CREASE BEAM WEB CORRODED BETWEEN BS 460 TO BS 480, STR 17L. REPAIRED WEB PER SRM.SDR SWAA091784Crease Beam · corrodedDURING SCHEDULED SPV CHECK, FOUND RT CREASE BEAM WEB CORRODED BETWEEN BS 727D TO 727E, STR 17R. REPAIRED WEB PER SRM.SDR SWAA091783Crease Beam · corrodedDURING SCHEDULED SPV CHECK, FOUND LT CREASE BEAM WEB CORRODED BETWEEN BS 727E TO 727D, STR 17L. REPAIRED WEB PER SRM.SDR SWAA091782Crease Beam · corrodedDURING SCHEDULED SPV CHECK, FOUND LT CREASE BEAM WEB CORRODED BETWEEN BS 727E TO 747, STR 17L. REPAIRED WEB PER SRM.SDR SWAA091771Crease Beam · corrodedDURING SCHEDULED 20Y CHECK, FOUND RT CREASE BEAM WEB CORRODED BETWEEN BS 727B TO BS 727C, LBL 65. REPAIRED WEB PER SRM.SDR SWAA091770Crease Beam · corrodedDURING SCHEDULED 20Y CHECK, FOUND LT CREASE BEAM WEB CORRODED BETWEEN BS 420 TO BS 500D, LBL 65. REPAIRED WEB PER SRM.
Back to JASC 5310