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 AALA990418Stringer · corrodedTUL - FOUND CORROSION ON STRINGER 26L AT STATION 481 TO 486. CUT OUT CORRODED END OF STRINGER AND INSTALLED EXTENDED PRODUCTION SPLICE PER ESO11697 3/17/99. (M)SDR AALA990594Frame · dentedTUL - FOUND BELL FRAME FLANGE DENTED STATION 1110, STRINGER 27 AND 25R. INSTALLED DOUBLER PER SRM 51-40-3. (M)SDR AALA990560Splice · corrodedTUL - FOUNS STRINGER SPLICE CORRODED. INSTALLED NEW STRINGER SPLICE AT STATION 680 STRINGER 27L PER SRM 51-10-1. (M)SDR AALA990558Web · crackedTUL - FOUND BS 1183 WEB CRACKED. INSTALLED DOUBLER REPAIR ON FORWARD SIDE BS 1183 WEB. (M)SDR AALA990557Floorbeam · crackedTUL - FOUND FLOORBEAM UPPER FLANGE CRACKED STATION 740 AT RT INBOARD SEAT TRACK RBL 24. STOPPED DRILLED CRACKS AND INSTALLED DOUBLERS PER SRM 53-10-8 PAGES 18-23. (M)SDR AALA990555Skin · corrodedTUL - SKIN CORRODED AT BUTT JOINT AT BS 680. FABRICATED AND INSTALLED REPAIR DOUBLER AND FILLER AND REINSTALLED INTERCOSTAL. (M)SDR AALA990552Stringer · corrodedTUL - FOUND CORROSION ON STRINGER 28L AT BS 525, REMOVED CORROSION MADE STRINGER OUT OF LIMITS. INSTALLED STRINGER REPAIR AS PER SRM 53-10-3 FIG 1. (M)SDR AALA990596Angle · corrodedTUL - FOUND OUTBOARD SIDE STRINGER 26R AFT SIDE 620 FRAME LOWER CHORD ANGLE CORRODED. REPAIRED CHORD ANGLE PER SRM 51-40-3 DOUBLER 17-7 MATERIAL .063 THICK 2.5 INCH BY 2.5 INCH BY 15 INCH WITH BAC30FQ6 FASTENERS AND 44 BACC30MB COLLARS. (M)SDR AALA990528Wire · chafedTUL - DURING OVERNIGHT MAINTENANCE, EMERGENCY EXIT FLOOR PATH LIGHTS BETWEEN FORWARD LAVATORY AND GALLEY WERE INOPERATIVE. REPAIRED EMERGENCY EXIT FLOOR PATH LIGHT WIRE AT FORWARD LAVATORY. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA990574Strap · corrodedTUL - FOUD STRINGER 614-619 ABOVE STRINGER 26R UPPER CHORD ANGLE LOWER TAPERED STRAP DOUBLER CORRODED AROUND 3 NUT PLATES. REMOVED AND REPLACED TAPERED STRAP. (M)SDR AALA990517Stringer · corrodedTUL - FOUND CORROSION IN STRINGER. CUT OUT SECTION OF CORROSION AND INSTALLED REPAIR PER SRM 53-10-3 FIG 1. (M)SDR AALA990516Shear Tie · corrodedTUL - FOUND CORROSION ON SHEAR TIE. CUT OUT CORROSION AND INSTALLED DOUBLER PER 53-10-4. (M)SDR AALA990515Skin · corrodedTUL - FOUND WHILE ON CUTTING OUT CORROSION ON SHEAR TIE SKIN WAS DAMAGED. GROUND OUT DAMAGE AND INSTALLED DOUBLER ON EXIT SKIN PER SRM 53-30-3 FIG AND AARD 53-30-03-3 .071 2024T3. (M)SDR AALA990513Skin · corrodedTUL - FOUND CORROSION ON SKIN STATION 680-688, STRINGER 27R. REMOVED CORROSION AND INSTALLED DOUBLER PER 53-30-3 FIG 3A. (M)SDR AALA990510Shear Tie · corrodedTUL - FOUND CORROSION ON SHEAR TIE AFT SIDE 11130 FRAME STRINGER 28-29L. REMOVED SHEAR TIE CLEANED CORROSION IN AREA IAW INSTALLED NEW SHEAR TIE PER SRM. (M)SDR AALA990509Frame · damagedTUL - FOUND HOLE IN BELL FRAME FROM SIDEWALL SCREW. INSTALLED DOUBLER PER 51-40-3. (M)SDR AALA990508Frame · crackedTUL - FOUND CRACK IN BELL FRAME. CUTOUT DAMAGED AREA AND INSTALLED REPAIR PER 51-40-3. (M)SDR AALA990593Frame · bentTUL - FOUND STATION 1030 BELL FRAME BENT (FLANGE/WEB) STRINGER 26-25 LEFT. REMOVED DAMGED SECTIONS, 1 INCH BY 2.8125 INCH BY 1 INCH BY 1.3125 INCH FROM BELL FRAME FLANGE, DYE CHECKED FOR CRACKS, NONE FOUND. INSTALLED DOUBLER PER SRM 51-40-3. (M)SDR AALA990554Skin · crackedTUL - FOUND CRACK IN FUSELAGE SKIN STATION 196.5 WL 223 LEFT SECTION 41. REMOVED CRACK AND INSTALLED DOUBLER PER SRM 53-30-3 FIG 3 PAGES 12-14A. (M)SDR AALA990529Retract Mech · lack of lubeCUN - FLT 928 - EN ROUTE GUA-MIA, AFTER TAKEOFF AND RETRACTING GEAR, RED NOSE GEAR LIGHT STAYED ILLUMINATED. ALL INDICATIONS INDICATED THE NOSE GEAR WAS NOT RETRACTED. FLIGHT AIR INTERRUPTED AND LANDED CUN WITHOUT INCIDENT. AIRCRAFT WAS INSPECTED AND MAINTESDR AALA990573Floorbeam · corrodedTUL - FOUND CORROSION AT FASTENER HOLES FOR CEILIG PANEL ATTACHMENT. REMOVED CORROSION AND REPAIRED PER ESO 11697 DATED 4-9-99 USING 7075T6 .080 1 INCY BY 16.5 INCH OAL. (M)SDR AALA990492Light · inoperativeTUL - DURING OVERNIGHT MAINTENANCE, CO-PILOTS OVERHEAD EMERGENCY EXIT LIGHT ASSEMBLY. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA990599Spar · corrodedTUL - RIGHT WING FSS 213-216 LOWER CHORD ANGEL LOWER LEFT HAS EXFOLIATING CORROSION, UPPER SURFACE AROUND AND UNDER STRUT ROD MOUNT BRACKET. REMOVED AND BLENDED CORROSION PER SRM 57-10-1. REPAIRED PER AARD 57-30-00-2. (M)SDR GAIA9946Overheat Light · illuminatedAFTER DEPARTING SEA, NR 1 OVERHEAT STRUT LIGHT CAME ON IN CLIMB. ANTI-ICE WAS CLOSED. AIRCRAFT MADE AN UNEVENTFUL LANDING AT DFW. RAN NR 1 ENGINE AND COULD NOT DUPLICATE THE PROBLEM ON GROUND. OPS CHECK NORMAL. AIRCRAFT RETURNED TO SERVICE WITH NO FURTHERSDR AALA990611Frame · bentFOUND BELL FRAME BENT IN WEB STATION 1130, STRINGER 26R TO STRINGER 25R. CUT OUT DAMGED AREA AND INSTALLED DOUBLER REPAIR PER 51-40-5 (AARD 53-10-07-3). (M)SDR AALA990592Frame · bentTUL - FOUND BELL FRAME BENT FLANGE AND WEB STATION 1030 STRINGER 26R TO STRINGER 25R. CUT OUT DAMAGED AREA AND INSTALLED DOUBLERS PER SRM 51-40-3. (M)SDR AALA990512Skin · corrodedTUL - FUSELAGE SKIN CORROSION AT SKIN LAP 26R OUTBOARD SIDE STATION 684-688. FUSELAGE SKIN CORROSION AT OUTBOARD SIDE OF 27R STATION 685. REMOVED SECTION OF SKIN LAP 2 INCH BY 3 INCH, INSTALLED EXTERNAL DOUBLE OVER BOTH AREAS 680-680 PLUS 18. OVERALL DIMENSSDR AALA990591Splice · crackedTUL - FOUND BELL FRAME (SPLICE) STRAP CRACKED STATION 1030 BETWEEN STRINGER 24L AND 25L. REPLACED (SPLICE) STRAP PER 51-10-1. (M)SDR AALA990572Shear Tie · corrodedTUL - FOUND CORROSION ON SHEAR TIE AFT OF FS 1130 AT STRINGER 29 LEFT. REMOVED CORRODED SHEAR TIE AND INSTALLED NEW SHEAR TIE USING ORIGINAL FASTENER LOCATIONS. FASTENER THROUGH FRAME .1875 HI-LOCKS. FASTENERS THROUGH SKIN ORIGINAL SIZE ADN TYPE REF 51-10-1SDR AALA990571Shear Tie · corrodedTUL - FOUND CORROSION ON SHEAR TIE AFT SIDE FS 1130, STRINGER 28 LEFT OUTBOARD. REMOVED CORRODED SHEAR TIE AND INSTALLED NEW SHEAR TIE USING ORIG FASTENER LOCATIONS. FASTENERS THROUGH FRAME .1875 INCH HI-LOCKS. FASTENERS THROUGH SKIN RIVET ORIGINAL SIZE ANDSDR AALA990570Shear Tie · corrodedTUL - FOUND CORROSION ON SHEAR TIE FS 1130 AT STRINGER 30. REMOVED CORRODED SHEAR TIE AND INSTALLED NEW SHEAR TIE USING ORIGINAL FASTENER LOCATIONS. FASTENERS THROUGH FRAME .1875 INCH HI-LOCKS. FASTENERS THROUGH SKIN ORIGINAL SIZE AND TYPE REF 51-10-1. (M)SDR AALA990507Angle · corrodedTUL - FOUND UPPER SURFACE OF LOWER CHORD ON RIGHT WING L/E BELOW NR 6 SLAT ACT HAS HEAVY CORROSION. REPAIRED PER AARD 57-30-00-2 PAGE 1. (M)SDR AALA990598Frame · corrodedTUL - FOUND STATION 1070 BELLFRAME FLANGE AND WEB STRINGER 26 AND 25 LEFT. INSTALLED DOUBLER PER SRM 51-40-3. (M)SDR AALA990597Frame · bentTUL - FOUND STATION 1050 BELLFRAME FLANGE 8 WEB BENT STATION 1050, STRINGER 26 AND 25 LEFT. REPAIRED BELLFRAME PER SRM 51-40-3. (M)SDR AALA990463Switch · defectiveMIA - FLT 808 - EN ROUTE POP, NR 1 ENGINE OIL FILTER BYPASS LIGHT ILLUMINATED IN FLIGHT. CREW FOLLOWED CHECKLIST AND SHUTDOWN NR 1 ENGINE. ENGINE WINDMILL TIME WAS 1 HOUR AND 15 MINUTES. FLIGHT CONTINUED TO MIA AND LANDED WITHOUT FURTHER INCIDENT. MAINTENASDR AALA990667Stringer · crackedTUL - FOUND CRACKS IN STRINGER 15R AND 17R AT STATION 1243, BOTH CRACKS IN RADIUS, BOTH CRACKS APPROX .75 INCH LONG. INSTALLED STRINGER REPAIR PER SRM 53-10-3 FIG 2. (M)SDR AALA990605Stringer · crackedTUL - CUT OUT CRACK AND REPAIRED STRINGER 15R FORWARD SIDE OF WING SCANNING LIGHT. MATERIAL PER SRM 53-10-3 FIG 5. FASTENERS SIX .1875 HI-LOCKS THROUGH SKIN AND STRINGER THREE .1875 HI-LOCKS THROUGH SIDE OF U-CHANNEL PER SIDE, TWO .15625 HI-LOCKS THROUGH STRSDR AALA990604Stringer · damagedTUL - CUT OUT DAMAGE AT FS 720A PLUS 10 INCHES SPLICED IN NEW STRINGER. MATERIAL PER SRM 53-10-3 FIG 5. FASTENERS THROUGH SKIN FOUR .1875 HI-LOCKS PER SIDE OF SPLICE ALSO THROUGH LIP OF STRINGER. FOUR .15625 HI-LOCKS THROUGH SIDE OF 'J' CHANNEL PER SIDE, EASDR AALA990595Frame · bentTUL - FOUND BELL FRAME FLANGE/WEB BENT. INSTALLED DOUBLER PER SRM 51-40-3. (M)SDR AALA990576Stringer · corrodedTUL - FOUND STRINGER 30 CORRODED AT STATION 1177. INSTALLED NEW SECTION OF STRINGER STATION 1156-1183 WITH NEW SPLICE BETWEEN STATION 1148 AND 1166 PER SRM 51-10-3 PAGE 3, NEW END FITTING INSTALLED AT 1183 ALODINED AND PRIMERED ALL PARTS. (M)SDR AALA990577Stringer · corrodedTUL - FOUND STRINGER 29L CORRODED AROUND FASTENER, OUTBOARD LEG AFT OF STATION 950B TO 950B PLUS 1 INCH. REPAIRED PER ESO 11697 DATED 4-1-99 USING GENERAL GUIDE LINES OF SRM 51-40-4. INSTALLED STRAP REPAIR. (M)SDR AALA990567Frame · damagedTUL - REMOVED DAMAGE BY CUTTING OUT. INSTALLED DOBULER AND FILLER SRM 51-40-3 DOUBLER MATERIAL 7075-T6 .063 INCH THICK FILLER .050 INCH 7075-T6 FASTENERS (10 EACH) .1875 PROTRUDING HD HI-LOCKS (4) .1875 100 DEGREES COUNTERSUNK HD HI-LOCKS WITH TOTAL 14 INCH TSDR AALA990580Frame · dentedTUL - FOUND STATION 560 BELLFRAME DENTED IN BETWEEN STRINGERS 24L AND 25L. CUT OUT DAMAGE 1 INCH BY 1.25 INCH AND INSTALLED DOUBLER PER SRM 51-40-3 PAGE 1-5. MATERIAL .063 INCH 7075T-6, 9 INCH LONG USING 27MS20470D, .1875 INCH RIVETS, 3 ROWS PAST DAMAGE, 1 OSDR AALA990568Sill · corrodedTUL - FOUND STATION 970 STRINGER 27 RIGHT DOOR CUT OUT CORRODED CHORD ANGLE, SILL PLATE LOWER. BLENDED CORROSION, HFEC FASTENER HOLES. LIGHTLY SPOTFACED FASTENERS HOLES, AND FLAP PEENDED REWORK AREA PER ESO11697, DATED 3/29/99. (M)SDR AALA990609Frame · bentTUL - BELT FRAME, BENT FLANGE AND WEB STATION 950F BETWEEN 26L AND 25L. INSTALLED DOUBLER ON BELT FRAME AT STATION 950F BETWEEN STRINGER 25L AND 26L IAW AARD 53-10-07-3. DAMAGED AREA OF FREE FLANGE AT WEB CUT OUT WAS 1 INCH BY 1.5 INCH. DOUBLER USED WAS 2024SDR AALA990588Frame · bentTUL - FOUND STATION 1070 BETWEEN STRINGER 26R-25R, BELLFRAME BENT IN WEB. REMOVED 3.5 INCH BY 1.25 INCH DAMAGED AREA. INSTALLED .071 T6 DOUBLER PER SRM 51-40-3. INSTALLED DOUBLER WITH 11BACB30FP8-4, 11 BACC30M8, 11 BACBB30FP6-3, 19 BACC30M6, 8 BACB30F06-3 HISDR AALA990569Frame · damagedTUL - STATION 950A STIRNGER 19R, BELT FRAME HAS DEEP WEAR FROM CEILING PANEL, DAMAGE ON FREE FLANGE. INSTALLED DOUBLER PER 51-40-3. NO CUT OUT REQUIRED. DOUBLER PUT ON TOP OF FREE FLANGE AND WEB WAS .063 7075 MATERIAL 5.5 INCH LONG. 1 ROW OF 6 HI-LOCKS BACSDR AALA990441Wire · defectiveDFW - DURING OVERNIGHT MAINTENANCE, EMERGENCY EXIT FLOOR PATH LIGHTING BETWEEN FIRST AND COACH CABIN INOPERATIVE. REPLACED EMERGENCY EXIT FLOOR PATH FLAP JUMPER WIRE AT SEAT ROW 7DEF. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA990602Floorbeam · corrodedTUL - FOUND TOP OF FLOORBEAM AT BS 380 IS CORRODED FROM RBL 48 TO 64 RBL. FLOORBEAM REPAIR COMPLETE AFT FLANGE OF UPPER CHORD STATION 380 RBL 48 TO 65 AS PER AARD 53-10-07-02 PAGE 1-3 FIG 1. (M)SDR AALA990589Angle · crackedTUL - FOUND ANGLE ON FRAME CRACKED AT FASTENER HOLE AT ATTACH POINT TO STRINGER 14R. REMOVED CRACKED PART AND INSTALLED NEW PART WITH HI-LOCKS. (M)
Back to Boeing 727-223