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 GAIA00217Skin · crackedDURING LIGHT C-CHECK AT TIMCO/OSC, EXISTING REPAIR HAS SKIN CRACKING BEYOND CUT OUT BS 600, STRINGER 29L. REPAIRED DAMAGED AREA IAW SRM 53-30-3. THE AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR GAIA00218Floorbeam · misdrilledDURING LIGHT C-CHECK AT TIMCO/OSC, FOUND BS 380, RBL 30 FLOORBEAM UPPER CHORD PREVIOUS REPAIR HAS A DOUBLE DRILLED HOLE. REPAIRED DAMAGED AREA IAW SRM 53-10-8. THE AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR GAIA00219Frame · damagedDURING LIGHT C-CHECK AT TIMCO/OSC, FOUND BS 660 FRAME HAS ELONGATED HOLES JUST BELOW STRINGER 16R. REPAIRED DAMAGED FRAME IAW SRM 51-40-3. THE AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR GAIA00220Floorbeam · elongatedDURING LIGHT C-CHECK AT TIMCO/OSC, FOUND ELONGATED AND PLUGGED HOLES WERE FOUND IN FLOORBEAM AT STATION 420, RBL 45. REPAIRED FLOORBEAM DAMAGE IAW SRM 53-10=8. THE AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR AALA20000659Connector · damagedDFW - DURING OVERNIGHT MAINTENANCE, EMERGENCY EXIT ESCAPE PATH LIGHTS IN CABIN INOPERATIVE. REPAIRED TRACK LIGHT CONNECTOR. GROUND CHECK NORMAL OPERATION. (M)SDR AALA20000652Light · inoperativeDFW - DURING OVERNIGHT MAINTENANCE, AIRSTAIR OVERHEAD EMERGENCY LIGHT INOPERATIVE. REPLACED AIRSTAIR OVERHEAD EMERGENCY LIGHT ASSEMBLY. SYSTEM GROUND CHECK NORMAL OPERATION. (M)SDR AALA20000651Light · inoperativeDFW - DURING OVERNIGHT MAINTENANCE EMERGENCY EXIT ESCAPE PATH LIGHTS FORWARD OF FIRST CLASS INOPERATIVE. REPLACED EMERGENCY EXIT ESCAPE PATH LIGHT STRIP FORWARD OF FIRST CLASS. SYSTEM GROUND CHECK NORMAL OPERATION. (M)SDR AALA20000644Light · inoperativeDFW - FOUND DURING OVERNIGHT MAINTENANCE, AIRSTAIRS EMERGENCY EXIT LIGHT INOPERATIVE. REPLACED AIRSTAIRS EMERGENCY EXIT LIGHT ASSEMBLY. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA20000621Light · inoperativeORD - DURING OVERNIGHT MAINTENANCE, EMERGENCY EXIT FLOOR PATH LIGHTING AT SEAT ROW 26-27 INOPERATIVE. REPLACED EMERGENCY EXIT FLOOR PATH LIGHT STRIP. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR GAIA00171B-Nut · looseFLT 1250 - GEG-PDX - UNABLE TO CONTROL CABIN PRESSURE. THE AIRCRAFT WOULD MAINTAIN 5 PSID AND THE CABIN CLIMBED TO 15,000 FT. THE CREW DESCENDED THE AIRCRAFT TO A LOWER ALTITUDE AND WENT ON OXYGEN. THE AIRCRAFT CONTINUED TO PDX AND LANDED WITHOUT FURTHER DISDR AALA20000618Switch · malfunctionedTUL - FOUND RIGHT SIDE EMERGENCY EXIT LIGHTS ILLUMINATE WITH SWITCH 5264 IN OFF POSITION AND POWER REMOVED FROM AIRCRAFT, EMERGENCY AISLE LIGHTING SYSTEM. REMOVED AND REPLACED SWITCH 5264, LIGHT OPERATION CHECKS NORMAL. (M)SDR AALA20000617Floorbeam · corrodedTUL - FOUND UPPER CHORD ANGLE OF WALKWAY FLOORBEAM CORRODED. REMOVED CORROSION, INSTALLED 301.5 HARD DOUBLER .040 PER AARD 51-40-00-1 28 FPG NR 1 LOCKS THROUGH WEB 10 F26 HI-LOCKS THROUGH UPPER LEG. (M)SDR AALA20000596Light · inoperativeIAH - DURING OVERNIGHT MAINTENANCE, AFT STAIR EMERGENCY EXIT LIGHT INOPERATIVE. REPLACED AFT STAIR EMERGENCY EXIT LIGHT. SYSTEM GROUND CHECK NORMAL OPERATION. (M)SDR AALA20000619Floorbeam · corrodedTUL - FOUND CORROSION ON BOTTOM FLANGE OF FLOORBEAM. CUTOUT DAMAGED AND INSTALLED FILLER AND DOUBLER DE301.5 HARD STAINLESS .071 PER ESO 11697 DATED 3-29-2000 AND AARD 53-10-07-1. (M)SDR AALA20000620Floorbeam · corrodedTUL - CORROSION ON STA 1130 FLOORBEAM FLANGE, BL ZERO, THROUGH LBL 25. REMOVED CORROSION BY BLEND AND CUT OUT. INSTALLED DOUBLER PER ESO 11697 DATED 3-29-2000. (X)SDR AALA20000616Stringer · corrodedTUL - FOUND CORROSION IN STRINGER AFT OF STATION 480 STRINGER 27L. INSTALLED NEW STRINGER SECTION PER SRM 53-10-03. (M)SDR AALA20000615Floorbeam · corrodedTUL - FOUND FLOORBEAM STATION 380 UPPER CHORD ANGLE AFT SIDE CORRODED AT FLOORBOARD FASTENER HOLE RBL 32 INCHES. CUT OUT DAMAGED AREA AND INSTALLED DOUBLER/FILLER REPAIR PER SRM 53-10-8 PAGES 45-48. (M)SDR AALA20000614Stringer · corrodedTUL - FOUND STRINGER CORRODED IN LOWER CENTER (BLOWN OUT). CUT OUT 11 INCH SECTION OF CORRODED STRINGER, STATION 483 TO 494 AND INSTALLED NEW SECTION WITH NEW SPLICE ON AFT END PER SRM 53-10-3 FIG 1. (M)SDR GAIA00167Frame · crackedDURING ROUTINE MAINTENANCE, BS 560 RIGHT SIDE, FRAME CRACKED JUST ABOVE MAIN CABIN FLOOR LEVEL. REPAIRED CRACKED FRAME AT STATION 560 RIGHT PER IAW 727 SRM 51-40-3 PAGE 3. AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR GAIA00168Frame · crackedDURING ROUTINE MAINTENANCE, STATION 640 RIGHT SIDE, FRAME CRACKED JUST ABOVE MAIN CABIN FLOOR LEVEL. REPAIRED CRACKED FRAME AT STATION 640 RIGHT PER IAW 727 SRM 51-40-3, PAGE 3. AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR EISA2000042Landing Gear · malfunctionedNOSE LANDING GEAR TOOK EXCESSIVE AMOUNT OF TIME TO EXTEND AND LOCK. ACCOMPANIED BY A LOUD WHINING NOISE. LUBED NOSE LANDING GEAR. RETRACTION OPERATION CHECK GOOD. (M)SDR AALA20000571Sign · inoperativeMIA - DURING OVERNIGHT MAINTENANCE, AFT AIRSTAIRS EMERGENCY EXIT SIGN INOPERATIVE. CLEANED CONTACTS OF AFT AIRSTAIRS EMERGENCY EXIT SIGN ASSEMBLY. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA20000575Light · inoperativeDFW - DURING OVERNIGHT MAINTENANCE, EMERGENCY EXIT FLOOR PATH LIGHTS UNDER EXIT MARKER ADJACENT TO AFT SERVICE DOOR INOPERATIVE. REPLACED EMERGENCY EXIT FLOOR PATH LIGHT STRIP. SYSTEM GROUND CHECKED NORMAL OPERATION.(M)SDR AALA20000574Light · inoperativeDFW - DURING OVERNIGHT MAINTENANCE, AFT AIRSTAIRS EMERGENCY EXIT LIGHT INOPERATIVE. REPLACED AFT AIRSTAIRS EMERGENCY EXIT LIGHT ASSY. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA20000573Wire · damagedMIA - DURING OVERNIGHT MAINTENANCE, FIRST CLASS EMERGENCY EXIT FLOOR PATH LIGHTS INOPERATIVE. SPLICED WIRE AT FORWARD EMERGENCY EXIT LIGHT ASSEMBLY. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR GAIA00160Floorbeam · crackedDURING HEAVY C-CHECK AT TIMCO/OSC, FOUND BODY STATION 740, FLOORBEAM HAS CRACK EXTENDING BEYOND STOP DRILL AT RBL 25 ON UPPER CHORD. REPAIRED IAW SRM 51-10-1. THE AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR GAIA00163Fitting · crackedDURING HEAVY C-CHECK AT TIMCO/OSC, FOUND AT STRINGER 18, BS 940, LOWER FORWARD HOLE IS CRACKED FROM HOLE TO BOTTOM EDGE. REPAIRED IAW TIMCO REO S000105. THE AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR GAIA00164Hinge · damagedDURING HEAVY C-CHECK AT TIMCO/OSC, FOUND UPPER FORWARD CARGO DOOR HINGE HAS HOLE ELONGATED AT STATION 538 (MAIN CARGO DOOR). REPAIRED IAW TIMCO REO S00090. THE AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR GAIA00165Hinge · damagedDURING HEAVY C-CHECK AT TIMCO/OSC, FOUND UPPER FORWARD CARGO DOOR HINGE HAS HOLE ELONGATED AT STATION 500 (MAIN CARGO DOOR). REPAIRED IAW TIMCO REO S00090. THE AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR GAIA00166Skin · corrodedDURING HEAVY C-CHECK AT TIMCO/OSC, THE FOLLOWING DISCREPANCY WAS FOUND. CORROSION FOUND ON LOWER WING SKIN INSIDE OF RIGHT HEAT EXCHANGER PLENUM AREA, STATION 852, RBL 31. REPAIRED IAW TIMCO REO S00077. THE AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR GAIA00127Floorbeam · corrodedDURING HEAVY C-CHECK AT TIMCO/OSC, FOUND CORROSION ON FLOORBEAM BS 620 AT SEAT TRACK LBL 25. REPAIRED IAW SRM 53-10-4. THE AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR GAIA00128Fitting · corrodedDURING HEAVY C-CHECK AT TIMCO/OSC, FOUND STRINGER 27L AT BS 740, BULKHEAD FITTING CORRODED. REMOVED CORROSION AND REPAIRED IAW SRM 51-30-5. THE AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR GAIA00129Fitting · corrodedDURING HEAVY C-CHECK AT TIMCO/OSC, FOUND STRINGER 27R AT BS 740 BULKHEAD FITTING WAS FOUND TO BE CORRODED. CORROSION WAS REMOVED AND REPAIRED IAW SRM 51-30-5. THE AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR GAIA00130Channel · corrodedDURING HEAVY C-CHECK AT TIMCO/OSC, FOUND E/E DOOR FORWARD LATCH FITTING U-CHANNEL HAS CORROSION BETWEEN STRUCTURES AT STATION 422. REMOVED CORROSION AND REPAIRED IAW SRM 51-20-1. THE AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR GAIA00131Frame · corrodedDURING HEAVY C-CHECK AT TIMCO/OSC, FOUND E/E FORWARD JAMB LOWE CHORD HAS PULLED FASTENER AT STATION 422, LBL 8. REPAIRED IAW SRM 51-20-1. THE AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR GAIA00132Intercostal · misdrilledDURING HEAVY C-CHECK AT TIMCO/OSC, FOUND INTERCOSTAL FOUND WITH MISDRILLED HOLES BETWEEN BS 600 AND BS 620. REPAIRED IAW SRM 51-20-1. THE AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR GAIA00133Floorbeam · corrodedDURING HEAVY C-CHECK AT TIMCO/OSC, FOUND CORROSION ON FLOORBEAM UPPER CHORD LOWER SURFACE, BOTH FORE AND AFT SIDES AT STATION 460, RBL 48. REPAIRED FLOORBEAM UPPER CHORD IAW SRM 53-10-8. THE AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR GAIA00134Bulkhead · crackedDURING HEAVY C-CHECK AT TIMCO/OSC, FOUND BS 178 BULKHEAD HAS CRACK AT WL 220, FROM LBL 16 TO LBL 7. REPAIRED CRACK IAW SRM 53-10-9. THE AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR GAIA00135Bulkhead · crackedDURING HEAVY C-CHECK AT TIMCO/OSC, FOUND AFT SIDE OF B/S 1342 BULKHEAD AT LBL 16, FOUND A 1.5 INCH CRACK BELOW VERTICAL STAB FITTING. REPAIRED CRACKED IAW SRM 51-30-5. THE AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR GAIA00136Seat Track · misrepairedDURING HEAVY C-CHECK AT TIMCO/OSC, FOUND SEAT TRACK SPLICE AT STATION 530, LBL 48 DOES NOT CONFORM TO EA B-7-25-073 OR DRAWING 2902. REPAIRED SEAT TRACK IAW DRAWING NR 2902. THE AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR GAIA00137Seat Track · crackedDURING HEAVY C-CHECK AT TIMCO/OSC, FOUND CRACK IN SEAT TRACK WEB AT STATION 620, LBL 48. REMOVED AND REPLACED SEAT TRACK IAW SRM 53-10-5. THE AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR GAIA00138Seat Track · corrodedDURING HEAVY C-CHECK AT TIMCO/OSC, FOUND BS 480, LBL 25 TO BS 670, LBL 25, SEAT TRACK HAS CORROSION. REMOVED CORROSION AND REPAIRED IAW SRM 53-10-5. THE AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR GAIA00139Seat Track · misrepairedDURING HEAVY C-CHECK AT TIMCO/OSC, FUOND SEAT TRACK SPLICE AT STATION 720E, RBL 24 DOES NOT CONFORM TO EA B7-25-073 OR DRAWING NR 2902. REPAIRED IAW EA B7-25-073 AND DRAWING NR 2902. THE AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR GAIA00140Lap Joint · corrodedDURING HEAVY C-CHECK AT TIMCO/OSC, FOUND FUSELAGE LAP SPLICE AT STRINGER 20L HAS SEVERAL FASTENERS WERE PULLING THROUGH SKIN FROM BS 1147 TO BS 1183. REPAIRED IAW TIMCO REO S00068. THE AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR GAIA00141Structure · crackedDURING HEAVY C-CHECK AT TIMCO/OSC, FOUND AFT CARGO DOOR 3 AFT TORQUE BOX WAS FOUND CRACKED. REPAIRED IAW SRM 51-40-2. THE AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR GAIA00142Rib · crackedDURING HEAVY C-CHECK AT TIMCO/OSC, FOUND HORIZONTAL STABILIZER RIGHT LOWER FORWARD INBOARD CLOSURE RIB CHORD WAS FOUND CRACKED. REPAIRED IAW SB 727-55-81. THE AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR GAIA00143Splice · misdrilledDURING HEAVY CHECK AT TIMCO/OSC, FOUND ONE MISDRILLED HOLE IN FUSELAGE, FRAME SPLICE AT BS 1030 BELOW STRINGER 15R. REPAIRED IAW SRM 53-10-1. THE AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR GAIA00144Frame · corrodedDURING HEAVY C-CHECK AT TIMCO/OSC, FOUND CHORD IN NOSE LANDING GEAR AT STATION 295, LBL 15 FORWARD INBOARD CORNER WAS FOUND CORRODED. REMOVED CORROSION AND REPAIRED IAW SRM 51-40-4. THE AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR GAIA00145Floorbeam · corrodedDURING HEAVY C-CHECK AT TIMCO/OSC, FOUND FLOORBEAM AT STATION 1130, RBL 10, HAS CORROSION UNDER NUTPLATE. REMOVED CORROSION AND REPAIRED IAW TIMCO REPAIR ENGINEERING ORDER REO NR S00066. THE AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR GAIA00146Floorbeam · corrodedDURING HEAVY C-CHECK AT TIMCO/OSC, FOUND FLOORBEAM AT STATION 1130, RBL 38-45, HAS CORROSION UNDER TWO NUT PLATES. REMOVED CORROSION AND REPAIRED IAW TIMCO REPAIR ENGINEERING ORDER REO NR S00066. THE AIRCRAFT WAS RETURNED TO SERVICE. (M)
Back to Boeing 727-223