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 AALA990354Stringer · corrodedTUL - FOUND CORROSION AFT END STRINGER 27R, STATION 740. PERFORMED STRINGER SPLICE REPAIR PER SRM 53-10-3. (M)SDR AALA990184Stringer · corrodedTUL - FOUND INSIDE STRINGER 28L CORRODED UNDER LEVELING COMPOUND STATION 490. REMOVED CORROSION PER 51-10-6, SPLICED STRINGER 28L PER SRM 53-10-3. INSTALLED DOUBLER PER SRM 53-30-3. (M)SDR GAIA99025Circuit Breaker · failedWHILE EN ROUTE TO YIP FROM IND, THE FLIGHT ENGINEER FOUND THE NR 1 ENGINE FIRE DETECTION CIRCUIT BREAKER HAD TRIPPED. ATTEMPTED ONE RESET, BUT THE CIRCUIT BREAKER WOULD NOT RESET. THERE WAS A BUNRING RUBBER SMELL NOTED IN THE COCKPIT. DECLARED AN EMERGENCY SDR AALA990192Intercostal · corrodedTUL - FOUND INBOARD SIDE OF INTERCOSTAL CORRODED STATION 700-720 OUTBOARD OF STRINGER 28R. REMOVED AND REPLACED INTERCOSTAL STATION 700-720, STRINGER 28R. (M)SDR AALA990191Intercostal · corrodedTUL - INBOARD SIDE OF INTERCOSTAL CORRODED. REMOVED AND REPLACED INTERCOSTAL STATION 700-720 OUTBOARD OF STRINGER 28R. (M)SDR AALA990188Stringer · corrodedTUL - FOUND STRINGER BLOW OUT (CORROSION) AT STATION 708 STRINGER 28L. INSTALLED STRINGER SPLICE PER SRM 53-10-3 FIG 1. (M)SDR AALA990187Stringer · corrodedTUL - FOUND STRINGER CORRODED AT STATION 715. INSTALLED STRINGER SPLICE PER SRM 53-10-3 FIG 1. (M)SDR AALA990185Skin · corrodedTUL - FOUND CORROSION ON SKIN JUST OUTBOARD OF STRINGER 28L STATION 480 TO STATION 500. REMOVED CORROSION PER 51-10-6 SPLICED STRINGER 28L PER SRM 53-10-3. INSTALLED DOUBLER PER SRM 53-30-3. (M)SDR AALA990183Skin · corrodedTUL - FOUND SKIN CORRODED BELOW STRINGER 28L AND 28R STATION 700-720. CUTOUT DAMAGED AREAS AND INSTALLED 1 DOUBLER REPAIR PER SRM 53-30-3. (M)SDR AALA990179Light · looseDFW - DURING OVERNIGHT MAINTENANCE, EMERGENCY EXIT LIGHTS AT RIGHT OVERWING EXITS INOPERATIVE. MAINTENANCE FOUND THE LIGHT ASSEMBLY LOOSE. TIGHTENED LOOSE EMERGENCY EXIT LIGHT ASSEMBLY. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA990382Frame · dentedTUL - STATION 500 BELL FRAME HAS 3 DENTS ON UPPER LEG FROM STR 22R TO 25R. CUTOUT DAMAGED AREA, REPAIRED BELT FRAME AT STATION 500, STRINGER 22R TO 25R PER SRM 51-40-3 FIG 1, PAGE 3. 1 DOUBLER 8 INCHES LONG .0637075-T6 20 EACH .1875 MS20470D RIVETS 3 ROWS, 2SDR GAIA9924Hose · failedAFTER TAKEOFF FROM DFW, THE 'A' SYSTEM HYDRAULIC QUANTITY WENT TO ZERO. THE AIRCRAFT RETURNED TO DFW AND LANDED WITHOUT FURTHER DIFFICULTIES. REMOVED AND REPLACED HYDRAULIC HOSE TO NR 2 ENGINE DRIVE HYDRAULIC PUMP. ALSO, REPLACED NR 1 AND NR 2 ENGINE DRIVENSDR AALA990186Stiffener · crackedTUL - FOUND ANGLE ATTACHED TO VERTICAL STIFFENER IS CRACKED. REMOVED AND INSTALLED NEW ANGLE AT STATION 1183, RBL 26, WL 271, IAW ESO 11697, FEB 9, 1999. (M)SDR GAIA9919Frame · misdrilledDURING SCHEDULED PHASE IN C-CHECK, ELONGATED HOLES ON THE RBL 45 UPPER CHORD AT FUSELAGE FRAME STATIONS 480 TO 680. HOLES WERE DRILLED AND REAMED TO .03125 OVERSIZE. THE HOLES WERE DEBURRED, AND FASTENERS WERE INSTALLED AS CALLED OUT IN AIA EDR B2-06354. RESDR GAIA9918Frame · misdrilledDURING SCHEDULED PHASE IN C-CHECK, A MISDRILLED HOLE ON FRAME STATION 500 BETWEEN S-10L AND S14L. HOLES WERE REAMED AND DEBURRED. NAS1097AD6-XX RIVETS WERE INSTALLED. REPAIR ACCOMPLISHED IAW AIA EDR B206359. NON ROUTINE 52142. (M)SDR GAIA9917Tip · unserviceableDURING SCHEDULED PHASE IN C-CHECK, A INCORRECT STATIC WICK BASE WAS FOUND INSTALLED ON THE LEFT WING TIP. DURING REMOVAL FOUR .1875 INCH FASTENERS HOLES WERE LEFT. THE DAMAGED AREA WAS REMOVED A FILLER WAS FABRICATED USING SAME MATERIAL AS REMOVED. THE FILLSDR GAIA9916Web · crackedDURING SCHEDULED PHASE IN C-CHECK, THE WEB LOCATED AB BS 1110 TO 1130 AT RBL 60 WAS FOUND CRACKED. A REPLACEMENT PANEL WAS FABRICATED FROM .050 INCH THICK 7075-0 HT TO T6 AFTER IT WAS FORMED. STIFFENERS ANGLES FORMED FROM 7075-T6 BY .050 IN LIEU OF WELDED BESDR GAIA99022Bulkhead · corrodedDURING SCHEDULED PHASE IN C-CHECK, CORROSION WAS FOUND ALONG THE HORIZONTAL FLANGE, AT FS 740 BULKHEAD. THE DAMAGED AREA TO THE BULKHEAD WAS REPAIRED AS EPR B727 SRM 53-10-1 FIG 1 DETAIL 1, AND AIA EDR B2-06357. REPAIR DOCUMENTED ON AIA NON-ROUTINE 1710. (MSDR GAIA99021Floorbeam · corrodedDURING SCHEDULED PHASE IN C-CHECK, CORROSION ON FLOORBEAM UPPER CHORD AT RBL 15 TO 44, FS 1130. AFTER CORROSION REMOVAL THE UPPER CHORD WAS FOUND BEYOND LIMITS. THE DAMAGED AREA TO THE FLOORBEAM WAS REPAIRED AS PE AIA EDR B2-06351, AIA/E/2922 REV ORIG. REPASDR GAIA99020Skin · crackedDURING SCHEDULED PHASE IN C-CHECK, A SMALL CRACK WAS FOUND IN THE SKIN LOCATED AT BS 352 STRINGER 27 RT. A REPAIR DOUBLER WAS FABRICATED AND INSTALLED USING AIA EDR B2-06360 OVER THE DAMAGED AREA. REPAIR DOCUMENTED ON AIA NON-ROUTINE 51817. (M)SDR AALA990193Angle · corrodedTUL - FOUND CORROSION ON CHORD ANGLE STATION 1223 BELOW FIXED STAIRS. BLENDED CORRODED AREA AND INSTALLED STRAP PER ESO 11697, DATED 2-8-99 CHORD ANGLE RT SIDE STATION 1223. (M)SDR AALA990190Splice · crackedTUL - FOUND RIGHT CHORD ANGLE SPLICE PLATE IS CRACKED STATION 1223 BELOW FIXED STAIR. REMOVED CRACKED SPLICE PLATE AND INSTALLED NEW SPLICE PLATE. (M)SDR AALA990189Splice · crackedTUL - LEFT CHORD ANGLE SPLICE PLATE IS CRACKED AT BS 1223 BELOW FIXED STAIR. REMOVED CRACKED SPLICE PLATE AND INSTALLED NEW SPLICE PLATE. (M)SDR AALA990145Light · defectiveDFW - DURING OVERNIGHT MAINTENANCE, EMERGENCY EXIT LIGHT OVER AFT LEFT GALLEY DOOR INOPERATIVE. REPLACED OVERHEAD GALLEY DOOR LIGHT ASSEMBLY. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA990166Mount · crackedTUL - FOUND NR 1 SLAT ACTUATOR OUTBOARD MOUNT CRACKED (INBOARD PIECE). INSTALLED NEW SLAT ACTUATOR OUTBOARD MOUNT. (M)SDR AALA990143Spar · corrodedTUL - FORWARD LOWER SPAR CHORD VERTICAL LEG HAS CORROSION BELOW NR 7 SLAT ACTUATOR. REPAIRED PER ESO 11697 DATED 1-25-99. (M)SDR AALA990237Stiffener · corrodedTUL - FOUND LOWER END OF VERTICAL STIFFENER CORRODED STATION 1183, INBOARD STRINGER 27L. REMOVED CORROSION, INSTALLED DOUBLER REPAIR PER ESO 11697, DATED 1-13-99. (M)SDR AALA990234Chord · corrodedTUL - FOUND STATION 1183 LOWER CHORD CORRODED INBOARD STRINGER 27L BULKHEAD FITTING. REMOVED CORROSION AND INSTALLED DOUBLER REPAIR PER ESO 11697, DATED 1-13-99. (M)SDR AALA990127Frame · damagedTUL - FOUND STATION 1130 BELLFRAME TOP DAMAGED, HOLE FROM TOO LONG OF A SCREW, ABOVE STRINGER 27R. REMOVED DAMAGED AND INSTALLED DOUBLER IAW SRM 53-10-4, AT STATION 1130 BELLFRAME STRINGER 27R. (M)SDR AALA990125Stringer · corrodedTUL - FOUND CORROSION BETWEEN SKIN LAP STATION 970, STRINGER 27R. REMOVED CORROSION, REMOVED AND SPLICED IN STRINGER 27R FROM 950D PLUS 10 TO 1010 PER ESO 11697 DATED 1-28-99 AND SRM 51-40-4 FIG 1. (M)SDR AALA990211Frame · dentedTUL - FOUND TOP OF BELL FRAME DENTED STATION 1090 STRINGER 27 LEFT. INSTALLED DOUBLER PER SRM 53-10-4. (M)SDR AALA990129Frame · damagedTUL - BELLFRAME TOP DAMAGED HOLE FROM TOO LONG SCREW, STATION 1110 ABOVE STRINGER 27. REMOVED DAMAGED DOUBLER FABRICATED AND INSTALLED NEW DOUBLER PER SRM 53-10-4. (M)SDR AALA990124Angle · corrodedTUL - FOUND CORROSION ON VERTICAL STIFFENER ANGLE FOR APU INLET, AT LOWER AFT CORNER OF SCREEN. REMOVED CORROSION, INSTALLED 201 STAINLESS .071 L-ANGLE DOUBLER PER SRM 51-40-4 TYPICAL EXTRUSION REPAIR. (M)SDR AALA990229Stringer · corrodedTUL - FOUND CORROSION ON OUTBOARD LEG OF STRINGER 29R AROUND 5 EACH FASTENERS STATION 1000-1015. REMOVED CORROSION INSTALLED STRAP REPAIR PER ESO 11697, DATED 1-19-99. (M)SDR AALA990128Angle · corrodedTUL - WING FRONT SPAR LOWER CHORD ANGLE HEAVILY CORRODED BELOW NR 8 SLAT ACTUATOR DOGHOUSE CUTOUT. INSTALLED REPAIR STRAP AND ANGLE PER ESO 11697, DATED 1-26-99. (M)SDR AALA990126Frame · damagedTUL - FOUND STATION 1070 BELLFRAME TOP DAMAGED AND WEB BULGED ABOVE STRINGER 26R. CUT OUT DAMAGE AND INSTALLED DOUBLER PER SRM 51-40-3. (M)SDR AALA990240Stiffener · wornTUL - FOUND STATION 870 VERTICAL STIFFENER, NEXT TO APU LOAD CONTROL VALUE HAS DEEP WEAR MARKS. INSTALLED DOUBLER (.050 STAINLESS) PER SRM 51-40-4. (M)SDR AALA990103Light · defectiveDFW - DURING OVERNIGHT MAINTENANCE AFT AIR STAIRS EMERGENCY EXIT LIGHT INOPERATIVE. REPLACED AFT AIR STAIRS EMERGENCY EXIT LIGHT ASSEMBLY. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA990241Clip · crackedTUL - FOUND STRINGER 1 TO BELT FRAME CLIP IMPROPERLY INSTALLED AND CRACKED STATION 1090. REMOVED AND REPLACED WITH SERVICEABLE (NEW) CLIP PER SRM. (M)SDR AALA990225Frame · dentedTUL - FOUND STATION 1030 FRAME DENTED AT STRINGER 25L. CUT OUT DAMAGED AREA OF FRAME. INSTALLED DOUBLER REPAIR PER SRM 53-10-4. (M)SDR AALA990224Support · corrodedTUL - FOUND CORROSION ON UPPER TAIL SKID ACTUATOR SUPPORT BEAM STATION 1213, RBL 6 TO LBL 6. INSTALLED NEW SUPPORT BEAM. (M)SDR AALA990223Support · corrodedTUL - FOUND CORROSION ON LOWER TAIL SKID ACTUATOR SUPPORT BEAM STATION 1213 LBL 6 FORWARD SIDE. INSTALLED NEW SUPPORT BEAM. (M)SDR AALA990222Floorbeam · corrodedTUL - FOUND CORROSION ON FLOORBEAM STATION 1130 RBL 27 INCH. INSTALLED REPAIR PER ESO 11697, DATED 1-5-99. (M)SDR AALA990216Stringer · crackedTUL - FOUND STRINGER 1 STATION 1090, CRACKED AROUND FASTENER HOLE ON RIGHT SIDE FORWARD HOLE AT STRINGER CLIP. CUTOUT DAMAGE STRINGER FROM STATION 1082 TO STATION 1096. HAD NEW PIECE FABRICATED FROM 7075-T6 .040 THICK. INSTALLED STRINGER AND CHANNEL STRAP (SDR AALA990248Frame · crackedTUL - UPPER DOOR FRAME TORQUE BOX LOWER WEB AND ANGLE CRACKED, THREE PLACES, STATION 570-580 BELOW STRINGER 17R. REMOVED AND REPLACED CRACKED SUPPORT ANGLE AND CUT OUT 2.75 INCH BY .75 INCH DAMAGED WEB. INSTALLED DOUBLER REPAIR PER SRM 51-40-2 PAGE 1-6 .040 SDR AALA990247Stiffener · corrodedTUL - FOUND HORIZONTAL STIFFENER CORRODED RIGHT STATION 303.9 OUTBOARD OF RIGHT GEAR TRUNNION FITTING. INSTALLED NEW HORIZONTAL STIFFENER RIGHT SIDE STATION 303.9. (M)SDR AALA990246Stiffener · corrodedTUL - FOUND HORIZONTAL STIFFENER CORRODED RIGHT STATION 307 JUST OUTBOARD OF RIGHT NOSE GEAR TRUNNION FITTING AT FORWARD END. INSTALLED NEW HORIZONTAL STIFFENER RIGHT SIDE STATION 307. (M)SDR AALA990239Web · corrodedTUL - FOUND CORROSION ON WEB STATION 1213 LBL 4, AT TAIL SKID ACTUATOR MOUNTS. REMOVED AND REPLACED CORRODED WEB (7075-T6 .125) PER SRM 51-10-1 PAG 4. (M)SDR AALA990233Shear Tie · corrodedTUL - FOUND STATION 1166 BELL FRAME SHEAR TIE CORRODED, AFT SIDE BETWEEN STRINGER 28L AND 29L. REPLACED SHEAR TIE PER SRM 51-10-01, TREATED AND PRIMED PER MM 51-20-0. (M)SDR AALA990232Shear Tie · corrodedTUL - AT STATION 1166 BELL FRAME SHEAR TIE CORRODED, AFT SIDE, BETWEEN STRINGER 29L AND 30L. REPLACED SHEAR TIE PER SRM 51-10-01, TREATED, PRIMED AND PAINTED PER MM 51-20-0. (M)
Back to Boeing 727-223