Boeing 727-223
Service difficulty reports · 5,313
Newest first. General aviation reporting is voluntary.
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 aircraft_model_key = '727223' 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 aircraft_model_key = '727223' 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 AALA990370Frame · dentedTUL - FOUND TOP OF BELL FRAME DENTED AT STAITON 950F 5 INCHES ABOVE STRINGER 26L. CUTOUT DAMAGED AREA, DUE CHECKED, FABRICATED DOUBLER, AND INSTALLED PER SRM 53-10-4 PAGE 4 FIG 1. (M)SDR AALA990367unknownTUL - FOUND STATION 344 LBL 30 TOP FLANGE OF FLOORBEAM CRACKED AT FASTENER HOLE. CUT OUT DAMAGED SECTION OF TOP FLANGE. INSTALLED DOUBLER REPAIR PER SRM 53-10-8 FIG 9 SHEETS 1-5. (M)SDR AALA990399Skin · crackedTUL - FOUND CRACK IN LEADING EDGE SKIN OUTBOARD EDGE OF INBOARD ROLLER, CUTOUT AT BOTTOM FLANGE NR 8 SLAT. REMOVED DAMAGED AREA AND INSTALLED DOUBLER REPAIR PER SRM 57-30-4. (M)SDR AALA990398Skin · crackedTUL - FOUND CRACK IN LEADING EDGE SKIN AT INBOARD ROLLER TRACK CUTOUT FOR NR 6 SLAT. REMOVED DAMAGE AND INSTALLED DOUBLER REPAIR PER SRM 57-30-4. (M)SDR AALA990393Fitting · corrodedTUL - FORWARD TRUNNION FITTING BEARING BORES CORRODED. REPLACED RMG FORWARD TRUNNION FITTING PER SRM 51-10-1. (M)SDR AALA990384Fitting · corrodedTUL - FOUND CORROSION ON FORWARD LEFT MLG TRUNNION FITTING BEARING ATTACHMENT BORES 4 EACH. REAMED HOLES AND INSTALLED OVERSIZE BUSHING PER ESO 11697 (2-22-97) AND SB 727-57-132. (M)SDR AALA990376Casting · corrodedTUL - INBOARD AILERON QUAD MOUNT CASTING CORRODED ON CASTING AND AROUND BEARING BORES. REMOVED AND REPLACED CORRODED CASTING PER SRM 51-10-1 PAGE 4. (M)SDR AALA990362Skin · corrodedTUL - FOUND CORROSION ON SKIN AROUND LEFT ICE LIGHT HOUSING BETWEEN STRINGER 14L AND 16L STATION 720B-720C. REMOVED CORROSION AND BLENDED CORRODED AREA. FABRICATED AND INSTALLED DOUBLER PER SRM 53-30-3 PAGE 137-140 ALODINED AND PRIMED ALL PARTS PER SRM 51-10SDR AALA990361S-Duct · damagedTUL - NR 2 ENGINE S-DUCT INNER SKIN BLISTERED AROUND 2 RIVETS APPROX 2 INCH DIAMETER LOCATED 2 SKIN LAPS PLUS RIVET ROWS UP FROM AFT END BETWEEN 6 AND 7 O'CLOCK POSITION. BLENDED CORROSION PER SRM 51-10-1, INSTALLED DOUBLER PER SRM 54-10-3. (M)SDR AALA990358Skin · crackedTUL - FOUND FUSELAGE SKIN CRACKED AT RIVET HOLE STATION 1097 RIGHT SIDE OF STRINGER 1. INSTALLED REPAIR PER SB NR 727-53-A0204 PARB, P615 (SRM 53-30-3 F 16.3). (M)SDR AALA990252Light · defectiveDFW - DURING OVERNIGHT MAINTENANCE, AFT AIR STAIR EMERGENCY EXIT LIGHTS INOPERATIVE. REPLACED AFT AIR STAIR EMERGENCY EXIT LIGHT ASSEMBLY. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR EISA99053Rib · crackedDURNIG ACCOMPLISHMENT OF ROUTINE C-CHECK WORKCARD, FOUND 2 RIBS CRACKED IN NR 4 SLAT. FABRICATED AND INSTALLED REPAIR DOUBLERS PER SRM 57-50-2 AND 5140-3. (M)SDR EISA99052Fitting · crackedDURING ACCOMPLISHMENT OF ROUTINE C-CHECK WORK CARD, FOUND CRACKED ATTACH FITTING ON NR 5 SPOILER. REMOVED AND REPLACED NR 5 SPOILER WITH SERVICEABLE UNIT. (M)SDR EISA99051Web · crackedDURING ACCOMPLISHMENT OF ROUTINE C-CHECK WORK CARD, FOUND WEB CRACKED IN SEVERAL PLACES, NR 8 SLAT. REMOVED WEB PART NR 69-28483-12 AND INSTALLED NEW PAR NR 69-28483-12 WITH SCREWS. (M)SDR EISA99050Rib · corrodedDURING ACCOMPLISHMENT OF ROUTINE C-CHECK WORK CARD, FOUND DEEP GOUGES AND CORROSION ON NR 5 SLAT RIB AT OUTBOARD TRACK FORWARD ATTACH BOLT HOLE. REMOVED GOUGES AND CORROSION, FABRICATED AND INSTALLED RIB DOUBLER PER SRM 57-50-3. (M)SDR EISA99049Rib · gougedDURING ACCOMPLISHMENT OF ROUTINE C-CHECK WORK CARD, FOUND DEEP GOUGES IN RIB OF NR 5 SLAT AT INBOARD TRACK FORWARD ATTACH BOLT HOLE. REMOVED GOUGES, FABRICATED AND INSTALLED RIB DOUBLER PER SRM 57-50-3. (M)SDR EISA99048Rib · gougedDURING ACCOMPLISHMENT OF ROUTINE C-CHECK WORK-CARD, FOUND DEEP GOUGES IN RIB AT OUTBOARD TRACK FORWARD ATTACH BOLT HOLE, NR 3 SLAT. REMOVED GOUGES BY REAMING HOLE PER AD 97-07-08 AND SB 57-0134. (M)SDR EISA99047Rib · corrodedDURING ACCOMPLISHMENT OF ROUTINE C-CHECK WORK-CARD, FOUND CORROSION AND GOUGES IN RIB OF NR 1 SLAT AT OUTBOARD TRACK FORWARD ATTACH BOLT HOLE. REMOVED CORROSION AND GOUGES. FABRICATED AND INSTALLED RIB DOUBLER PER SRM 57-50-3. (M)SDR EISA99046Rib · crackedDURING ACCOMPLISHMENT OF ROUTINE C-CHECK WORK-CARD, FOUND CRACK AND GOUGE IN RIB OF NR 4 SLAT AT OUTBOARD TRACK FORWARD ATTACH BOLT. FABRICATED AND INSTALLED DOUBLER PER SRM 57-50-3. (M)SDR EISA99045Rib · gougeDURING ACCOMPLISHMENT OF ROUTINE C-CHECK WORK-CARD, FOUND DEEP GOUGE IN RIB OF NR 6 SLAT AT INBOARD TRACK FORWARD ATTACH BOLT-HOLE. FABRICATED AND INSTALLED RIB DOUBLER PER SRM 57-50-3. (M)SDR EISA99044Rib · crackedDURING ACCOMPLISHMENT OF ROUTINE C-CHECK WORK-CARD, FOUND CRACK IN RIB OF NR 4 SLAT AT INBOARD TRACK FORWARD ATTACH BOLT-HOLE. FABRICATED AND INSTALLED RIB DOUBLER PER SRM 57-50-3. (M)SDR EISA99043Skin · delaminatedDURING ACCOMPLISHMENT OF ROUTINE C-CHECK WORK-CARD, FOUND AREA OF DELAMINATION TOP SURFACE OF RIGHT MID-FLAP. REPAIRED DELAMINATION AREA PER SRM 57-50-1, 57-50-2 AND 57-50-4. (M)SDR EISA99042Angle · crackedDURING ACCOMPLISHMENT OF ROUTINE C-CHECK WORK-CARD, FOUND 1.5 INCH CRACK AT FORWARD LEFT OF FRAME, FS 1343 ABOVE 'S' DUCT. REMOVED CRACKED PART NR 65-19104-3. FIT TRIM AND DRILL NEW PART NR 65-19104-3 AND INSTALLED PER SRM 51-10-1 AND 51-30-2. (M)SDR EISA99041Skin · delaminatedDURING ACCOMPLISHMENT OF ROUTINE C-CHECK WORK-CARD, FOUND LEFT OUTBOARD MID FLAP DELAMINATED AT LOWER SURFACE TRAILING EDGE. REPAIRED TRAILING EDGE PER SRM 57-50-1, L57-50-2 AND 57-50-4. (M)SDR EISA99040Skin · delaminatedDURING ACCOMPLISHMENT OF ROUTINE C-CHECK WORKCARD, FOUND NR 5 SPOILER DELAMINATED AT INBOARD TRAILING EDGE. REPLACED NR 5 SPOILER WITH SERVICEABLE UNIT PER MM 27-61-01. (M)SDR EISA99039Skin · delaminatedDURING ACCOMPLISHMENT OF ROUTINE C-CHECK WORKCARD, FOUND DELAMINATION ON UPPER SURFACE OF 31 SPOILER OUTBOARD LEADING EDGE. CUT OUT DAMAGED AREA, REPAIRED HONEYCOMB CORE PER SRM 51-40-6 POTTING REPAIR. FABRICATED NEW SKIN SECTION PER SRM 57-50-2 AND INSTALLESDR EISA99038Fitting · crackedDURING ACCOMPLISHMENT OF ROUTINE C-CHECK WORK-CARD, FOUND .25 INCH CRACK IN LOWER AFT CORNER OF AFT CARGO DOOR. REMOVED DAMAGED CORNER SECTION, NEW PART 65-59948-502 DRILLED PER SRM 51-10-1 AND INSTALLED PER SRM 51-30-2. (M)SDR EISA99037Skin · crackedDURING ACCOMPLISHMENT OF ROUTINE C-CHECK WORKCARD, FOUND RIGHT WING TRAILING EDGE CRACK AT NR 12 SPOILER, CENTER OUTBOARD HINGE POINT. STOP DRILLED CRACK PER SRM 51-10-01. FABRICATED AND INSTALLED DOUBLER PER SRM 57-30-4. (M)SDR EISA99036Skin · crackedDURING ACCOMPLISHMENT OF ROUTINE C-CHECK WORKCARD, FOUND CRACK IN RIGHT WING UPPER SURFACE AT NR 11 SPOILER OUTBOARD HINGE POINT. STOP DRILLED CRACK PER SRM 51-10-01. FABRICATED AND INSTALLED DOUBLER PER SRM 57-30-4. (M)SDR EISA99035Doubler · crackedDURING ACCOMPLISHMENT OF ROUTINE C-CHECK WORK CARD, X-RAY REVEALED A CRACK IN TRAILING EDGE OUTBOARD END OF RIGHT ELEVATOR AS SEEN IN SHOT NR R-35. CRACK EXISTED IN DOUBLER ON LOWR SURFACE. REMOVED DOUBLER, FABRICATED AND INSTALLED NEW DOUBLER PER SRM 55-20-SDR AALA990396Beam · corrodedTUL - FOUND CORROSION IN 16 EACH FASTENER HOLE OUTBOARD NR 4 FLAPTRACK IN LEFT MLG GEAR BEAM. REAMED HOLES TO REMOVED CORROSION AND INSTALLED BUSHINGS IN HOLES PER ESO 11697, DATED 2-19-99. (M)SDR AALA990394Angle · corrodedTUL - FOUND CORROSION AT TOP OF NLG DOGHOUSE AT TOP WALL TO SIDE WALL JOINT (CORNER) LEFT SIDE. INSTALLED DOUBLER REPAIR IAW SRM 51-40-3 FIG 1. (M)SDR AALA990383Clip · corrodedTUL - FOUND CORROSION ON STRINGER CLIP TO FRAME AT FS 660 STRINGER 15R. REPLACED STRINGER CLIP. (M)SDR AALA990380Angle · corrodedTUL - FOUND CORROSION AT TOP OF NLG DOGHOUSE AT TOP WALL TO SIDE WALL JOINT CORNER. INSTALLED DOUBLER REPAIR IAW SRM 51-40-3 FIG 1. (M)SDR AALA990351Stringer · crackedTUL - FOUND STRINGER CRACKED AT PREVIOUS RADIUS AREA, FS 660 STRINGER 15R. STOP DRILLED CRACK, HFEC. INSTALLED STRINGER REPAIR PER SRM 53-10-3. (M)SDR AALA990249Angle · corrodedTUL - FOUND CORROSION ON TOP ANGLE AFT CARGO DOR CUTOUT AFT FRAME BETWEEN STRINGER 26R AND 27R. PERFORMED REPAIR OF AIRCRAFT CARGO DOORWAY AFT FRAME UPPER FLANGE IAW ESO 11697, DATED 1/18/99. (M)SDR AALA990245Skin · corrodedTUL - FOUND WING LOWER SKIN CORRODED ON LOWER SURFACE. INSTALLED DOUBLER/TRIPLER OVER THE AREA WHERE CORROSION REMOVAL WAS BEYOND LIMITS PER SRM 57-30-3 AND SEALED PER 51-20-4. (M)SDR AALA990244Skin · corrodedTUL - FOUND WING LOWER SKIN CORRODED ON LOWER SURFACE STATION 830 LBL 30 INCH TO LBL 32 INCH. REPAIRED CORRODED AREA PER 57-30-3 PAGE 27 FIG 10. (SHEET 3). (M)SDR AALA990236Floor · corrodedTUL - FOUND CORROSION ON LEFT AFT LAV FLOOR STATION 1166-1162 LBL 24-29. REPLACED LEFT LAV FLOOR PAN PER SRM 51-10-1 AND ESO 11697, DATED 1-14-99. (M)SDR AALA990227Frame · crackedTUL - FOUND STATION 930 LEFT BELL FRAME CRACKED AT STRINGER 14 LEFT. REPAIRED BELL FRAME AT STATION 930 LEFT, STRINGER 14L PER SRM 53-10-4 FIG 1 USING 1 CHANNEL 5530762 - .080 7075T6 AND 1 DOUBLER 5831870 - .071-7055 PLUS 6 - .25 INCH 1ST OVER HI-LOCKS IN PRESDR AALA990213Stiffener · corrodedTUL - FOUND STATION 950 CORROSION AT 2ND VERTICAL STIFFENER FROM KEEL BEAM TOP END. INSTALLED DOUBLER WET PER SRM 53-10-9. (M)SDR AALA990209Frame · dentedTUL - STATION 1070 FRAME DENTED ON TOP BETWEEN STRINGER 26R AND 27R. INSTALLED DOUBLER WET AT STATION 1070 BETWEEN STRINGER 26R AND 27R PER SRM 53-10-4. (M)SDR AALA990207Keel Beam · crackedTUL - KEEL BEAM CRACKED AT LOWER CHORD, RIGHT SIDE, SECOND FASTENER AFT OF STATION 870. REMOVED DAMAGED (CRACK) PER ESO 11697 DATED 1/13/99. REPAIRED PER SERVICE BULLETIN 727-53-0208, DETAIL II. (M)SDR AALA990392Frame · dentedTUL - FOUND STATION 700 BELL FRAME DENTED ABOVE STRINGER 24R. INSTALLED DOUBLER (7075T-6 .063) 3 ROW OF RIVETS, 1 ROW TOP, 2 ROWS SIDE WITH EIGHTTEEN .1875 D-RIVETS, DOUBLER 7.5 INCH LONG PER SRM 51-40-3. (M)SDR AALA990391Frame · dentedTUL - FOUND STATION 680 BELL FRAME DENTED ABOVE STRINGER 24R. INSTALLED DOUBLER (7075 T-6 .063) 3 ROWS OF RIVETS, 1 ROW TOP, 2 ROWS SIDE WITH SEVENTEEN .1875 D-RIVETS AND FOUR .25 INCH RIVETS, DOUBLE 7.5 INCH LONG PER SRM 51-40-3. (M)SDR AALA990388Frame · dentedTUL - STATION 580 BELL FRAME HAS TWO DENTS AT STRINGER 23L TO STRINGER 24L. INSTALLED DOUBLER 7075T6 .063, 3 ROWS OF RIVETS 1 ROW IN TOP, 2 ROWS ON SIDE WITH THIRTY .1875 D-RIVETS AND FOUR EACH HI-LOCKS IN SHEAR TIE, STD .15625 ATTACHING TO STRINGER PER SRM 5SDR EISA99028Wire · brokenNOSE GEAR RED UNSAFE LIGHT ON AND GREEN LIGHT ON WITH GEAR EXTENDED. REPAIRED GROUND WIRE FROM LOCK SWITCH. (M)SDR EISA99027Switch · failedAFTER NOSE GEAR EXTENSION, BOTH GREEN AND RED ILLUMINATED. AFTER MAIN GEAR EXTENDED, ONLY GREEN LIGHT ON. REMOVED AND REPLACED NOSE GEAR LOCK SWITCH, PERFORMED GEAR SWING NUMEROUS TIMES. OPS CHECK GOOD PER MM 32-61-7. (M)SDR AALA990385Fitting · corrodedTUL - FOUND STRINGER 27L OUTBOARD END FITTING HEAVILY CORRODED. INSTALLED NEW END FITTING CPN5624412. (M)SDR AALA990357Skin · gougedTUL - FOUND STATION 9505 PLUS 16, APPROX 3 INCHES BELOW STRINGER 25L, SKIN HAS DEEP GOUGE. BLENDED GOUGE, ALODINED AND PRIMED AREA, BLEND OUT OF LIMITS. REPAIRED WITH DOUBLER PER SRM 53-30-3 PAGE 5, 6, 7, 8. (M)
Back to Boeing 727-223