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 AALA991192Light · defectiveTUL - DURING OVERNIGHT MAINTENANCE, EMERGENCY EXIT SIDE MARKER LIGHT BY FORWARD SERVICE DOOR LOOSE FROM WALL. REPLACED EMERGENCY EXIT SIDE MARKER LIGHT BY FORWARD SERVICE DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA991178Light · defectiveTPA - DURING OVERNIGHT MAINTENANCE, AFT AIRSTAIR EMERGENCY EXIT LIGHT INOPERATIVE. REPLACED AFT AIRSTAIRS EMERGECY EXIT LIGHT ASSEMBLY. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA991203Light · inoperativeTUL - EMERGENCY LIGHT ASSY IN AFT ENTRY OVERHEAD LIGHT WILL NOT COME ON WHEN AFT ATTENDANTS LIGHT SWITCH IS TURNED ON. INSTALLED SERVICEABLE LIGHT LIGHT ASSY. (M)SDR GAIA99117Connector · dirtyFLT 518 - TOL-ATL - CLEARED FOR SHORT APPROACH BY ATC. CREW PREPARED A/C FOR APPROACH BY EXTENDING THE FLAPS AND GEAR. ATC THEN EXTENDED THE APPROACH, SO THE CREW RETRACTED THE FLAPS AND GEAR TO CLEAN UP THE AIRCRAFT. AT THAT TIME, THE 'A' SYSTEM HYD QTY DRSDR AALA991190Frame · corrodedTUL - FOUND BOTTOM OF FRAME CORRODED. REMOVED CORRODED SHEAR TIE AND LEG FROM LOWER FRAME STATION 600, STRINGER 27R-28R PER SRM 53-10-4 FIG 13. FABRICATED AND INSTALLED FRAME REPAIR FOR SHEAR TIE AND LEG PER SRM 53-10-4 FIG 13. (M)SDR AALA991145Wire · out of positionDFW - DURING OVERNIGHT MAINTENANCE, OVERHEAD EMERGENCY EXIT LIGHT AT ROW 22 INOPERATIVE. REPOSITIONED WIRES ON BATTERY. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA991151Blade · failedIAH - FLT 1752 - AFTER TAKEOFF IAH WHILE CLIMBING THROUGH 5,500 FEET, CREW NOTICED A SEVERE VIBRATION THEN HEARD A NOISE. NR 2 ENGINE N1 DROPPED TO 48 PERCENT AND OIL TEMPERATURE WAS AT 130 DEGREES CELSIUS. RETARDED NR 2 THROTTLE AND FOLLOWED EMERGENCY ENGINSDR AALA991189Frame · crackedTUL - FORWARD FROM WEB FOR DOOR CUTOUT HAS CRACK EXTENDING ON BOTH SIDES OF FLUSH RIVET HOLE JUST ABOVE UPPER DOOR STOP CASTING. STOP DRILLED CRACKS IAW SRM 51-10-1. FABRICATED AND INSTALLED REPAIR DOUBLER AND FILLER IAW SRM 51-40-2 FIG 1. (M)SDR AALA991144Light · looseDFW - DURING OVERNIGHT MAINTENANCE, OVERHEAD EMERGENCY EXIT LIGHT IN FORWARD GALLEY INOPERATIVE. RESEATED OVERHEAD EMERGENCY EXIT LIGHT IN FORWARD GALLEY SECTION. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA991139Wire · out of positionDFW - DURING OVERNIGHT MAINTENANCE, EMERGENCY OVERHEAD AISLE LIGHT AT ROW 9 INOPERATIVE. REPOSITIONED WIRE ON BATTERY TABS. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR GAIA99110AWire · chafedFLT 2508 - IND-GEG - ON FINAL APPROACH, HAD TO CYCLE ITS GEAR FOUR TIMES IN ORDER TO GET A NOSE GEAR DOWN AND LOCKED INDICATION. THE AIRCRAFT LANDED SAFELY IN GEG WITHOUT FURTHER PROBLEMS. MAINTENANCE FERRIED THE AIRCRAFT, GEAR DOWN TO SEA WHERE JACKS WERE ASDR AALA991191Stiffener · corrodedTUL - FRONT SPAR VERT STIFFENER CORRODED AT TOP JUST OUTBOARD OF FUEL PRESS SWITCHES. REMOVED AND REPLACED STIFFENER WITH 6 EACH , STEEL HI-LOCKS HL62, 7 EACH STEEL HI-LOCKS HL62 PER SRM 51-10-1 AND SAME PART NR STIFFENER. (M)SDR AALA991141Spar · corrodedTUL - LEFT HORIZONTAL STAB REAR SPAR UPPER CHORD CORRODED FORWARD OF NR 1 BALANCE PANEL STATION 33-34. BLENDED CORROSION PER ESO 11697, PAGES 1 AND 2, DATED 8-2-00. TREATED, PRIMED, SEALED AND PAINTED AREA. (M)SDR AALA991126Light · defectiveDFW - DURNG OVERNIGHT MAINTENANCE, AFT STAIRWELL EMERGENCY EXIT LIGHT INOPERATIVE. REPLACED AFT STAIRWELL EMERGENCY EXIT LIGHT. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA991142Stiffener · corrodedTUL - STATION 920 STIFFENER AT INBOARD W/W WALL CORRODED AT NUTPLATE LOWER FORWARD CORNER OF APU AIR INTLET SCREEN. REMOVED CORROSION. INSTALLED REPAIR DOUBLER PER SRM 51-40-3. (M)SDR AALA991105Wire · looseMIA - DURING OVERNIGHT MAINTENANCE, EMERGENCY EXIT FLOOR PATH LIGHTING INOPERATIVE. RESECURED WIRE TO EMERGENCY EXIT FLOOR PATH LIGHTING. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA991121Web · crackedTUL - HFEC INDICATES CRACK IN UPPER PRESS DECK AT BEAD FORWARD OF STATION 950, OUTBOARD MOST BEAD. REPAIRED PER ESO 11697, DATED 7-21-99. (M)SDR AALA991098Clamps · looseMIA - FLT 275 - AFTER TAKEOFF MIA EN ROUTE TO LRM, NR 3 ENGINE STRUT OVERHEAT LIGHT ILLUMINATED. AIRCRAFT RETURNED TO MIA AND LANDED WITHOUT INCIDENT. RESECURED LOOSE BLEED DUCT CLAMPS IN NR 3 ENGINE STRUT. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA991086Light · defectiveDFW - DURING OVERNIGHT MAINTENANCE, AFT STAIRWELL EMERGENCY EXIT LIGHT INOPERATIVE. REPLACED AFT STAIRWELL EMERGENCY EXIT LIGHT. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR GAIA99107Rib · crackedDURING A 'ZERO' LIGHT 'C' INSPECTION BEING PERFORMED IN OSC AT AMERICAN INTERNATIONAL AIRWAYS REPAIR STATION, A CRACK WAS DETECTED ON THE LEFT HORIZONTAL STABILIZER AFT UPPER CLOSURE RIB CHORD. REPAIRED IAW AIA EDR B2-06525 AND BOEING SB 727-55-81. DER APPROSDR GAIA99106Floorbeam · corrodedDURING A 'ZERO' LIGHT 'C' INSPECTION BEING PERFORMED IN OSC AT AMERICAN INTERNATIONAL AIRWAYS REPAIR STATION, CORROSION WAS DETECTED AT BS 1130 FLOORBEAM UPPER CAP, RBL 34-38. REPAIRED IAW AIA EDR B2-06516. DER APPROVED ON 8110-3 DATED MAY 12, 1999. (X)SDR GAIA99105Skin · crackedDURING A 'ZERO' LIGHT 'C' INSPECTION BEING PERFORMED IN OSC AT AMERICAN INTERNATIONAL AIRWAYS REPAIR STATION, A CRACK WAS FOUND IN FUSELAGE SKIN AT UPPER AFT CORNER OF R5 WINDOW. REPAIRED IAW AIA EDR B2-06523, BOEING REPAIR SKETCH CKFR990507, FIGURES 1 AND 2.SDR GAIA99103Bulkhead Beam · crackedDURING A 'ZERO' LIGHT 'C' INSPECTION BEING PERFORMED IN OSC AT AMERICAN INTERNATIONAL AIRWAYS REPAIR STATION, IT WAS DISCOVERED THAT AT THE 1183 PRESSURE BULKHEAD RBL 46.93, VERTICAL BEAM WAS CRACKED FROM WL 198 TO WL 202. REPAIRED IAW AIA EDR B2-06526, DER ASDR AALA991188Stringer · crackedTUL - FOUND STRINGER 16L CRACKED LEFT STATION 1233. CUT OUT DAMAGED SECTION OF STRINGER. INSTALLED DOUBLER REPAIR PER SRM 53-10-3. (M)SDR AALA991076Light · defectiveLGA - FLT 1886 - DURING LANDING AT LGA COCKPIT EMERGENCY EXIT LIGHTS ILLUMINATED AND REMAINED ILLUMINATED WITH SWITCH TURNED OFF. REPLACED COCKPIT EMERGENCY EXIT LIGHT ASSEMBLY. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA991075Wire · brokenMIA - DURING OVERNIGHT MAINTENANCE, EMERGNCY EXIT FLOOR PATH LIGHTING FROM ROWS 25 TO 28 DEF INOPERATIVE. REPAIRED WIRE TO EMERGENCY EXIT FLOOR PATH LIGHT STRIP. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR GAIA99102Bleed Valve · inoperativeFLT 721 DURING CLIMB-OUT FROM AUS THROUGH FL 250, THE NR 3 ENGINE STRUT OVERHEAT ILLUMINATED FOLLOWED SHORTLY BY THE NR 3 ENGINE BLEED TRIP AND THE LOWER AFT BODY OVERHEAT LIGHT. THE FLIGHT CREW DECLARED AN EMERGENCY AND DIVERTED TO DFW. THE AIRCRAFT LANDED SSDR 99ZZZX2825Bleed Valve · inoperativeFLT 721 DURING CLIMB-OUT FROM AUS THROUGH FL 250, THE NR 3 ENGINE STRUT OVERHEAT ILLUMINATED FOLLOWED SHORTLY BY THE NR 3 ENGINE BLEED TRIP AND THE LOWER AFT BODY OVERHEAT LIGHT. THE FLIGHT CREW DECLARED AN EMERGENCY AND DIVERTED TO DFW. THE AIRCRAFT LANDED SSDR GAIA99101Connector · disengagedFLT 2508 - GEG-IND - ON APPROACH, HAD TO CYCLE GEAR TWICE IN ORDER TO GET A NOSE GEAR DOWN AND LOCKED INDICATION. THE AIRCRAFT LANDED SAFELY IN GEG WITHOUT FURTHER PROBLEMS. MAINTENANCE FERRIED THE AIRCRAFT, GEAR DOWN TO SEA WHERE JACKS WERE AVAILABLE FOR TRSDR AALA991073Stringer · crackedTUL - RIGHT STRINGER 18A CRACKED IN RADIUS HORIZONTAL OUTBOARD LEG, EXTENDING OUT FROM RADIUS BLOCKS AFT SIDE OF 940 CASTING. REMOVED DAMAGED SECTION SPLICED IN NEW SECTION OF RT STRINGER 18A PER SB 727-53-0172. (M)SDR AALA991054Skin · corrodedTUL - FOUND CORROSION ON LOWER WING SKIN ABOVE RIGHT PRIMARY HEAT EXCHANGER. INSTALLED REPAIR PER SRM 57-30-3 FIG 8 SHEET 3. (M)SDR AALA991074Shear Tie · corrodedTUL - FOUND CORROSION ON SHEAR TIE BETWEEN STRINGER 26R-27R, STATION 568. REMOVED CORRODED SHEAR TIE. INSTALLED NEW SHEAR TIE PER SRM 51-10-1. (M)SDR AALA991071Skin · corrodedTUL - FUSELAGE SKIN CORRODED FS 587-592 OUTBOARD OF STRINGER 28 LEFT. REMOVED DAMAGED SKIN. INSTALLED DOUBLER REPAIR IAW SRM 53-30-3 FIG 3. (M)SDR AALA991070Stringer · corrodedTUL - STRINGER 28L HAS HEAVY CORROSION AT FS 591. REMOVED DAMAGED SECTION OF STRINGER. INSTALLED SPLICE REPAIR IAW SRM 53-10-3 FIG 1. (M)SDR AALA991072Frame · corrodedTUL - LOWER FLANGE OF BELLFRAME CORRODED, FORWARD CARGO STATION 720E BETWEEN STRINGER 27L AND 28L. CORRODED SECTION REMOVED, ANGLE REPAIR INSTALLED AT SHEAR TIE PER SRM 53-10-4 PAGES 58-60. (M)SDR EISA99133Bolt · missingNR 1 T/R LIGHT ON IN FLIGHT AIR ABORT, RETURN TO BRU. TROUBLE SHOT, FOUND BOLT ON SWITCH MISSING. INSTALLED BOLT. OPS CHECK GOOD. (M)SDR AALA991055Web · crackedTUL - FOUND LEFT HORIZONTAL WEB CRACKED AIRSTAIR TORQUE BOX BELOW ACCESS PLATE STATION 1320. ROUTED OUT CRACK, REPAIRED AS PER B727 SRM CH 51-40-2, TYPICAL WEB REPAIR. (M)SDR AALA991012Light · defectiveDFW - DURING OVERNIGHT MAINTENANCE, EMERGENCY EXIT FLOOR PATH LIGHTING FORWARD FIRST CLASS CABIN INOPERATIVE. REPLACED EMERGENCY EXIT FLOOR PATH LIGHT STRIP. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR GAIA9998Skin · crackedFOUND DURING PREFLIGHT WALK AROUND AND REPAIRED AT THE OSC MAINTENANCE FACILITY. A CRACK WAS FOUND IN THE FUSELAGE BELLY SKIN AT THE 6 O'CLOCK POSITION, AT BODY STATION 990. NO ADDITIONAL DISCREPANCIES WERE NOTED. REMOVED DAMAGED SKIN IAW B727 SRM 53-30-3 FSDR AALA991015Splice · corrodedTUL - FOUND CORROSION ON STRINGER SPLICE AT BS 480. REMOVED CORRODED STRINGER SPLICE AND INSTALLED REPAIR SPLICE PE SRM 53-10-3. (M)SDR AALA990991Wire · brokenMIA - DURING OVERNIGHT CHECK, RIGHT EMERGENCY EXIT FLOOR PATH LIGHTING INOPERATIVE. REPAIRED EMERGENCY EXIT FLOOR PATH LIGHTING WIRE AT RIGHT AFT EXIT LIGHT SIGN. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA990997Coupler · defectiveMIA - FLT 0971 - EN ROUTE BNA/MIA, HARD UNCOMMANDED RUDDER KICK TO THE RIGHT, AIRCRAFT ROLLED LEFT AS RESULT, AUTOPILOT DISENGAGED TO RECOVER AIRCRAFT. INCIDENT ONLY OCCURRED ONCE. ALL SUBSEQUENT INDICATIONS NORMAL. FLIGHT 28,000, 300 KNOTS, SMOOTH AIR, KICSDR AALA990990Battery · dirtyDFW - DURING OVERNIGHT MAINTENANCE, AFT STAIRWAY EMERGENCY EXIT LIGHTS INOPERATIVE. CLEANED BATTERY CONTACTS FOR AFT STAIRWAY EMERGENCY EXIT LIGHTS. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA990985Light · inoperativeDFW - DURING OVERNIGHT MAINTENANCE, EMERGENCY EXIT FLOOR PATH LIGHT AT MIDDLE OF COACH INOPERATIVE. REPLACED EMERGENCY EXIT FLOOR PATH LIGHT STRIP. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA990984Connector · brokenDFW - DURING OVERNIGHT MAINTENANCE, FIRST CLASS EMERGENCY EXIT FLOOR PATH LIGHTING INOPERATIVE. REPAIRED EMERGENCY EXIT FLOOR PATH LIGHTING CONNECTOR. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA991016Frame · corrodedTUL - FOUND CORROSION ON SHEAR TIE STATION 700 BETWEEN STRINGER 27R AND 28R. INSTALLED DOUBLER ON SHEAR TIE STATION 700 BETWEEN STRINGER 27 AND 28R PER SRM 53-10-4 PAGES 58-60. (M)SDR AALA990998Rivet · failedORD - FLT 374 - CLIMBING THROUGH 27,000 FEET, NR 1 ENGINE COMPRESSOR STALLED. EGT FLUCTUATED FROM 1.92 TO 1.97. OTHER ENGINE INSTRUMENT REMAINED STEADY AT N1 89 PERCENT, EGT 500 DEGREES, N2 92 PERCENT. COMPRESSOR STALL CAUSED A SMOKY SMELL TO ENTER COCKPIT,SDR AALA990646Floorbeam · corrodedTUL - FOUND CORROSION ON FLOORBEAM, FS 380, RBL 50 1 INCH BY 4 INCH. CORROSION REMOVED AND PATCH INSTALLED TO REPLACE UPPER FLANGE OF FLOORBEAM PER SRM 53-10-8 FIG 3. (M)SDR EISA99140Connector · dirtyUPON GEAR EXTENSION THE RIGHT MAIN GEAR (RED) WARNING LIGHT ILLUMINATED. PERFORMED ABNORMALS SECTION 3 PAGE 50 PROCEDURE UNEVENTFUL LANDING. CLEANED AND REPOSITIONED CONNECTOR TO LANDING GEAR ACCY BOX AND PERFORMED TEST IAW MM 32-61-01. OPS CHECK GOOD. (M)SDR AALA990948Valve · defectiveBNA - FLT 1750 - EN ROUTE DFW-PHL, NR 2 CROSSFEED VALVE FAILED TO OPEN. AIR INTERRUPTED AND LANDED BNA WITHOUT INCIDENT. CHECKED AND DEFERRED ACCORDING TO MEL. REPLACED NR 2 FUEL MANIFOLD VALVE. PERFORMED OPERATIONAL CHECK WITH NO LEAKS NOTED. SYSTEM GROU
Back to Boeing 727-223