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 ASOA20140529096Beam · corrodedDURING C-CHECK, THE CARGO DOOR CUTOUT LOWER BEAM WAS FOUND TO BE CORRODED. MAINTENANCE R & R THE BEAM IAW SRM 51-40-02. THE ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR FDEA201405281223Crease Beam · chafedBS 1200 - 1230 LT CREASE BEAM INNER ANGLE CHAFED. REPAIRED IAW EA F-5310-T0308466B PART 1. REPAIR MAJOR.SDR FDEA201405281222Crease Beam · chafedBS 1323 LT CREASE BEAM INNER ANGLE CHAFED. REPAIRED IAW EA F-5310-T0308466B PART 1. REPAIR MAJOR.SDR ASOA2014062410745Unknown · corrodedCORROSION FOUND ON LBL 9 AT BS 549.00. UPON SEAT TRACK REMOVAL. REMOVED 1 AREAS OF CORROSION AT FS549 LBL9, SRM TASK 53-31-43-101-001-A02. RECEIVED AND COMPLIED WITH REO 670-53-31-325.SDR R61A201405280741Seat Track · corrodedDURING HEAVY CHECK, FOUND CORROSION ON LT SEAT TRACK BETWEEN BS 668-782. MAINTENANCE R & R SEAT TRACK IAW SRM 51-42-05, 51-42-45.SDR SWIA201438115Fitting · gougedFWD BAGGAGE BAY DOOR SURROUND STRUCTURE THE UPPER AFT FITTING HAS A GOUGE. C-CHECK, CREATED SMOOTH CONTOUR BY REMOVING SHARP EDGES AND NOT INCREASING DEPTH OF GOUGE IAW EA.SDR GLBA2014052800416Door Frame · crackedDURING A SCHEDULED INSPECTION, FOUND A CRACK AT THE LOWER AIR STAIR DOOR FRAME, AIRFRAME SIDE, LOWER AFT CORNER, BS 173.35, VISIBLE PORTION OF CRACK 1.75 INCHES IN LENGTH. REPAIRED IAW EO 14-1900-53-026.SDR AALA20140528005Stop Fitting · crackedMID CARGO STOP PAD, FWD UPPER CORNER CRACKED. R & R FITTING IAW AARD 51-00-05-1.SDR AALA20140528004Stop Fitting · crackedMID CARGO FWD DOOR STOP FITTING CRACKED. R & R STOP FITTING IAW AARD 51-00-05-1.SDR V0XD2014052518021Structure · corrodedWASTE DRAIN VALVE COMPARTMENT CORRODED. R & R WASTE DRAIN VALVE COMPARTMENT IAW SRM 51-40-02.SDR ABXA20140527200Door Frame · corrodedFORWARD LOWER CARGO FUSELAGE STATION 549 INSIDE LOWER SEAL, FWD PART OF DOOR JAMB IS CORRODED. NEW OUTER CHORD PN 143T8004-1, INSTALLED ON NR 1071. SDR INFO CORRODED L2, PN 143T8004-1, SN NSN, PART NAME CHORD, FS & BS LOCATION ON ACFT 549 TO 593, STRINGER & SDR R61A201405270724Nut · corrodedDURING HEAVY CHECK, L1 DOOR STOP SCREW NUT ON DOOR STOP FITTINGS NR 3, & 4 SHOW SIGNS OF CORROSION. MX R & R L1 DOOR STOP SCREW NUT ON DOOR STOP FITTING IAW AMM 20-10-02.SDR AALA20140527020Stop Fitting · crackedFORWARD CARGO STOP PAD FITTING CRACKED. R & R FITTING IAW AARD 51-00-05-1.SDR SWAA2014061228972Crease Beam · crackedLEFT CREASE BEAM CRACKED AT BS 639, WL 208. REPAIRED BEAM IAW EA.SDR R61A201405260695Doubler · corrodedDURING HEAVY CHECK, WASTE SERVICE BOX DOULBER FRAME 87 INBD FWD CORNER IS CORRODED. MX R & R IAW S/B 190-53-0056. NO FURTHER ACTION REQUIRED.SDR SWAA2014061629051Door Frame · corrodedC1 DOOR JAMB CORRODED. R & R JAMB IAW SRM.SDR SWAA2014061228971Crease Beam · crackedRIGHT CREASE BEAM INNER CHORD CRACKED AT BS 616, WL 208. REPAIRED CHORD IAW EA.SDR SWAA2014060628796Window Frame · crackedCOCKPIT RT NR 1 WINDOW FRAME CRACKED AT UPPER OTBD CORNER. REPAIRED FRAME IAW EA.SDR DALA2014062503771Pan · crackedCRACKED PAN ON RT FWD OVERWING EMERGENCY EXIT DOOR AT STOP FITTING NR 12, CARD 35 ZONE 201, INNER SKING, STOP FITTING AND CLIP WERE REMOVED CRACK WAS AS STOP DRILL DOUBLER WAS STOPPED, FABRICATED, TREATED, PAINTED, INSTALLED AND IDENTIFIED IAW SRM 51-30, 1, 5SDR CA141103032Window Frame · cracked(CAN) DURING WINDSHIELD REPLACEMENT, ENVOY REPORTED FINDING THE SIDE POST CRACKED, RIGHT SIDE, PN 601R33223-2. A CAW PROJECT IS OPENED TO INVESTIGATE THIS FINDINGS.SDR SWAA2014060528750Window Frame · crackedFLIGHT DECK NR 1 LT WINDOW FRAME UPPER OTBD CORNER CRACKED. REPAIRED FRAME IAW ACO.SDR SWAA2014060528749Window Frame · crackedFLIGHT DECK NR 3 RT WINDOW FRAME FWD FRAME SECOND FASTENER FROM BOTTOM CRACKED. REPAIRED FRAME IAW ACO.SDR FDEA201405231149Door Frame · crackedR2 DOOR FWD FRAME, UPPER HINGE CUT OUT EDGE NICKED. CRACK WAS FOUND OUT OF LIMITS IAW SRM 52-10-02, DETAIL IX, FIG. 101. LOCATED AND DRILLED AND INSTALLED REPAIR IAW SRM 52-10-02, FIG. 201, REPAIR 1. COMPLIED WITH EA F-5210-T0308334, PT. 1. MAJOR REPAISDR SIMA20140523003Roller · lack of lubeMAIN CABIN DOOR STUCK TRYING TO CLOSE. HAD TO OPEN FROM OUTSIDE. LUBRICATED ROLLERS IAW 53-21-02. NO DEFECTS NOTED.SDR ASOA2014060610654Fitting · corrodedTHE LOWER SERVICE DOOR SEAL FITTING AT FS 329.00 IS CORRODED. REMOVED CORROSION AND FOUND OUT OF LIMITS IAW SRM 53-00-00-01, FIG 101, SHEET 1 (TR 53-27). LOCATED & DRILLED NEW SERVICE DOOR SEAL FITTING IAW SRM 51-40-11 & DWC 601R38533. INSTALLED NEW SERVICESDR SWAA2014052928488Window Frame · crackedRIGHT NR 3 FLIGHT DECK WINDOW FRAME E - F CRACKED AT NR 8 FASTENER HOLE. REPAIRED FRAME IAW SI.SDR A6WA201441573Door Frame · crackedPAX DOOR AFT FRAME AT FS 338 IS CRACKED UNDER PREVIOUS REPAIR. REMOVED CRACKED FRAME & REPLACED WITH NEW SERVICEABLE FRAME IAW REO 601R-52-11-402 REV H.SDR SIMA20140522001Roller · lack of lubeMAIN CABIN DOOR HARD TO OPEN & CLOSE. PERFORMED MAIN DOOR FRAME ROLLERS LUBRICATION IAW AMM 53-21-02. OPERATIONS CHECK OK.SDR FDEA201405211112Fitting · crackedJUNCTION BETWEEN CTR WING BOX & CRUCIFORM FITTING BETWEEN FRAMES 40 - 44 CRACKED. REAMED IAW SRM 51-40-44. ROTO-TESTED INSPECTION IAW NTM51-10-01. NO CRACK FOUND. INSTALLED NEW FASTENERS IAW SRM 51-40-21. COMPLIED WITH EA 6-5710-T0308783 PT1. MAJOR REPASDR FDEA201405211106Fitting · crackedFUSELAGE CTR WING BOX REAR SPAR & BOTTOM PANEL RT SIDE HOLE C FOUND CRACK SIGNAL. COMPLIED WITH EA 6-5710-T0308679 PT1. MAJOR REPAIR IAW GMM 6-2-100.SDR FDEA201405211105Fitting · crackedFUSELAGE CTR WING BOX REAR SPAR & BOTTOM PANEL RT SIDE HOLE Q FOUND WITH A CRACK SIGNAL. COMPLIED WITH EA 6-5710-T0308679 PT1. MAJOR REPAIR IAW GMM 6-2-100.SDR SWIA201438056Former · corrodedPAX DOOR FWD FORMER HAS CORROSION AROUND TENSION BAR. C-CHECK REMOVED CORROSION AS REQUIRED IAW EA.SDR V0XD2014052318005Window Frame · corrodedRIGHT WINDSHIELD ASSY FRAME IS CORRODED IN MULTIPLE AREAS. BLENDED CORRODED AREAS IAW ACMM 56-10-01, FOUND TO BE WITHIN LIMITS IAW MM 56-10-01. NDT PERFORMED, NO DEFECTS NOTED.SDR UHLA2014060600454Crossbeam · corrodedCORROSION FOUND ON CROSSBEAM A FRAME 14 AND Y=+10.748. REMOVED CORROSION, REPAIRED CROSSBEAM IAW ETD2014-170-042963. MAJOR REPAIRSDR UHLA2014060600453Crossbeam · corrodedCORROSION FOUND ON CROSSBEAM FRAME 17 Y=+10.748. REMOVED CORROSION, REPAIRED CROSSBEAM IAW ETD2014-170-042963. MAJOR REPAIRSDR DALA2014062503761Pan · crackedCRACKED PAN ON RT AFT OVERWING EMERGENCY EXIT DOOR AT AFT RUB LOCK AREA. INNER SKIN, STOP FITTING AND CLIP WERE REMOVED. CRACK WAS FABRICATED, PAINTED, INSTALLED AND IDENTIFIED IAW SRM 52-05 D, FIG 51, 51-30-1, 51-30-2, 51-10-4, 51-01, 51-10-3 PARA 14 AND 21SDR SWAA2014061729116Crease Beam · corrodedCREASE BEAM WEB CORRODED BETWEEN BS 170 TO 202, BL 58R. REPAIRED BEAM IAW SRM.SDR IPXA2014060483190Fitting · cracked1C INSPECTION, AIR CONDITIONING BAY RT BASE FRAME FITTING IS CRACKED AT FRAME 45. R & R FITTING IAW EO A300-5310-46789-A, APPENDIX G.SDR FDEA201405201090Structure · corrodedCARGO BAY UNDER FLOOR AREA RT BS 229 FOUND CORRODED. REPAIRED AS PER EA 1-5750-T0308325 PART 1. REPAIR CLASSIFIED MAJOR IAW GMM 6-2-100 REVISION 121.SDR V0XD2014052318004Window Frame · corrodedLEFT WINDSHIELD ASSY FRAME IS CORRODED IN MULTIPLE AREAS. BLENDED CORRODED AREAS IAW ACMM 56-10-01, FOUND TO BE WITHIN LIMITS IAW ACMM 56-10-01. NDT PERFORMED, NO DEFECTS NOTED.SDR USAA2014052100009Crease Beam · corrodedC4 CHECK LEVEL 2 GALVANIC CORROSION ON CREASE BEAM ANGLE BETWEEN BS 297 TO BS 324, RBL 62. REPLACED CREASE BEAM ANGLE BETWEEN BS 297 TO BS 324, RBL 62 IAW SRM 51-40-02.SDR ASOA20140520089Beam · corrodedDURING C-CHECK, THE CARGO DOOR CUTOUT LOWER BEAM WAS FOUND TO BE CORRODED. MAINTENANCE R & R THE BEAM IAW SRM 51-40-02. THE ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR FDEA201405191077Crease Beam · corrodedCREASE BEAM UPPER SURFACE CORRODED BS 1040 - 1020, RT SIDE. REMOVED CORROSION IAW SRM 51-10-02 AND FOUND OUT OF LIMITS IAW SRM 53-40- 13, FIG. 101, DETAIL VII. REMOVED AND REPLACED CREASE BEAM INNER ANGLE BS 900-1040 IAW SRM 51-40-02 AND DWGS 144N5152, SH. SDR SWAA2014060228597Window Frame · crackedLEFT NR 3 FLIGHT DECK WINDOW FRAME CRACKED IN THE HOLE SECOND FROM THE BOTTOM. REPAIRED FRAME IAW ACO.SDR SWAA2014060228596Window Frame · crackedRIGHT NR 3 FLIGHT DECK WINDOW FRAME CRACKED IN THE HOLE SECOND FROM THE BOTTOM. REPAIRED FRAME IAW ACO.SDR DALA14031639213Door Frame · corrodedAFT LOWER CARGO DOOR FRAME DOUBLER HAS SURFACE CORROSION, REMOVED CORROSION. FOUND TO BE OUT OF LIMITS. R & R HEADER BEAM IAW DWG 5930483, REV AR.SDR SWAA2014052828404Window Frame · crackedFLIGHT DECK RT NR 1 WINDOW FRAME OTBD UPPER CORNER EDGE CUT OUT CRACKED. REPAIRED FRAME IAW ACO.SDR DALA14031436901Structure · corrodedFOUND CORROSION ON L4 DOOR UPPER RT SEAL AREA. COMPLIED WITH PRI 526064-14 REV '0'. LEAK CHECKED DOOR TO 3 PSI. ALL PRI INSPECTIONS COMPLIED WITH IAW PRI 526064-14 REV 0, 1 AND 2. COMPLIED WITH SECTION I TIME-LIMITED REPAIR PER ER/A 526064-14 REV ORIGINAL.SDR SWAA2014052828403Window Frame · crackedRIGHT NR 3 WINDOW FRAME CRACKED AT 2ND & 3RD HOLE FROM THE BOTTOM. REPAIRED FRAME IAW ACO.SDR SWAA2014052828402Window Frame · crackedLEFT NR 3 WINDOW FRAME CRACKED AT 2ND & 3RD HOLE FROM THE BOTTOM. REPAIRED FRAME IAW ACO.
Back to JASC 5310