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 AALA990023Angle · damagedDURING C-CHECK, GOUGE FOUND IN REINFORCEMENT ANGLE, OUTBOARD SIDE OF FUSELAGE ABOVE WING STATION 760.95. ANGLE REMOVED AND REPLACED. (M)SDR AALA990015Control · malfunctionedDFW - FLT 535 - DURING CRUISE AT FL22 AIRCRAFT LOST PRESSURIZATION. CREW INITIATED EMERGENCY DESCENT AND LANDED DFW WITHOUT FURTHER INCIDENT. MAINTENANCE CHECKED DECAY RATE AND PRESSURIZED AIRCRAFT WITH ENGINES AND APU ON THE GROUND WITH NO ABNORMAL CONDITIOSDR AALA990068Wire · brokenDFW - DURING OVERNIGHT MAINTENANCE, EMERGENCY EXIT FLOOR PATH LIGHTS WERE INOPERATIVE. REPAIRED EMERGENCY EXIT FLOOR PATH LIGHTING BROKEN WIRE IN COACH CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA990052Stringer · damagedTUL - FOUND FASTENER HOLES DAMAGED 16 AFT OF STATION 940 IN STRINGER 18A, LEFT SIDE. OVERSIZED 16 FASTENER HOLES TO STD .3125 INCH AFT OF STATION 940 IN STRINGER 18A INSTALLED 16 BOLTS O/S PR ESO 11697 DATED 12-23-98. (M)SDR AALA990061Skin · corrodedTUL - FOUND CORROSION ON SKIN ABOVE RIGHT PRIMARY HEAT EXCHANGER (PLENUM) FROM STATION 830 TO STRINGER 850. INSTALLED REPAIRS PER SRM 57-30-3 FIG 8 AND FIG 9. (M)SDR AALA982237Light · defectiveDFW - DURING OVERNIGHT CHECK, FORWARD GALLEY DOOR EMERGENCY EXIT LIGHT INOPERATIVE. REPLACED FORWARD GALLEY DOOR EMERGENCY EXIT LIGHT ASSEMBLY. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA982236Light · defectiveDFW - DURING OVERNIGHT CHECK, EMERGENCY EXIT FLOOR PATH EXIT LIGHT AT SEAT 3E INOPERATIVE. REPLACED EMERGENCY EXIT FLOOR PATH LIGHT STRIP AT SEAT 3E. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA982235Light · defectiveDFW - DURING OVERNIGHT CHECK, EMERGENCY EXIT FLOOR PATH EXIT DECAL AT SEAT ROW 30 NOT PROPERLY LIGHTED. REPLACED EMERGENCY EXIT FLOOR PATH LIGHT STRIP AT SEAT ROW 30. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA990033Skin · damagedTUL - AFT SIDE OF 1183 BULKHEAD ABOVE VAULT DOOR SKIN HAS SEVERAL DEEP TOOL MARKS LBL 20 TO RBL 20, 6 ABOVE CABIN FLOOR. INSTALLED DOUBLER PER ESO 11697, DATED 12/17/98. (M)SDR EISA98322Valve · malfunctionedNR 2 ENGINE DUCT OVERHEAT WITH ENGINE ANTI-ICE ON. MUST REDUCE POWER TO 65 PERCENT N1 FOR TEMP TO DROP. REMOVED AND REPLACED THERMOSTATIC VALVE. OPS CHECK GOOD PER MM 30-21-21. (M)SDR EISA98321Switch · failedAFTER DEPARTURE MCI (1000 AGL) CARGO DOOR LIGHT ON SOLENOID PANEL ILLUMINATED. RETURN TO DEPARTURE AIRPORT. CABIN PRESSURE WAS LOST WHEN LIGHT CAME ON. ADJUSTED LOCK BAR CLOSED SWITCH AND 1 LOCK SWITCH. MAIN CARGO DOOR OPS CHECKS GOOD PER MM 52-32-1. (M)SDR EISA98320Control Panel · looseGENERATOR BREAKER AND FIELD LIGHT NR 1 ILLUMINATED AT GEAR RETRACTION. DIFFERENTIAL LIGHT ILLUMINATED RAN ABNORMAL PROCEDURES. GENERATOR WOULD NOT RESET. RAN NORMAL PROCEDURES. RETURN TO DEPARTURE (LAX). FOUND NR 1 GENERATOR CONTROL PANEL LOOSE. SWAPPED SDR AALA990032Angle · misdrilledTUL - RIGHT LOWER TORQUE BOX LOWER CHORD ANGLE HAS 14 MISDRILLED HOLES WITH VISUAL INDICATION OF CRACK STATION 1323-1333. ALSO, 9 MISDRILLED HOLES WITH VISUAL INDICATION OF CRACK STATION 1313-1323. INSTALLED REPAIR PER ESO 11697 DATED 12-15-98. ANGLE WAS SPSDR AALA982261Stringer · corrodedTUL - FUOND CORROSION ON BOTTOM SIDE OF STRINGER 27 LEFT STATION 500. INSTALLED STRINGER REPAIR PER SRM 53-10-3. (M)SDR AALA982259Stringer · corrodedTUL - FOUND CORROSION INSIDE STRINGER 27R STATION 720F PLUS 3 INCHES TO 740. REPAIRED STRINGER PER SRM 53-10-3 FIG 1 PAGE 4B STRINGER 27R STATION 720F PLUS 3 INCHES TO STATION 740. (M)SDR AALA982258Skin · corrodedTUL - FOUND STATION 482-492 OUTBOARD STRINGER 28R RBL 12 INCHES RBL THROUGH 13 INCHES SKIN CORRODED BELOW INTERCOSTAL LOWER ATTACH ANGLE (MARKED). INSTALLED SKIN REPAIR PER ESO 11697, DATED 12-17-98. (M)SDR AALA982257Skin · corrodedTUL - FOUND STATION 500-504 AFT SIDE FRAME OUTBOARD STRINGER 27L SKIN CORRODED UNDER LEVELING COMPOUND (MARKED). INSTALLED SKIN REPAIR PER ESO 11697, DATED 12-17-98. (M)SDR AALA982256Stringer · corrodedTUL - FOUND STRINGER 28R STATION 480 CORRODED. INSTALLED STRINGER REPAIR PER SRM 53-10-3. (M)SDR AALA982247Strap · corrodedTUL - FOUND FORWARD 8 INCHES OF STRAP CORRODED, EXFOLIATION THROUGH THE TAPERED STRAP. REMOVED OLD TAPERED STRAP P/N 65-56181-6 AND INSTALLED NEW TAPERED STRAP WITH ORIGINAL HARDWARE PER SRM 51-10-1. (M)SDR AALA990027Frame · dentedTUL - FORWARD DOOR FRAME STATION 950 HAS DEEP DENT, WORN AREA. ON TOP EDGE, BETWEEN 2ND AND 3RD UP DOOR STOPS. INSTALLED DOUBLER PER SRM 51-40-4, 13 EACH .1875 HI-LOCKS, 2 EACH .3125 BOLTS, 2 EACH .3125 BOLTS, INSTALLED IN 17-7 REPAIR ANGLE (.080 THICK). (M)SDR AALA990026Stringer · crackedTUL - LEFT STRIGNER 18A HAS VISUAL INDICATION OF CRACK AT STATION 948. REMOVED DAMAGED SECTION OF STRINGER 18A LEFT AND REPAIRED STRINGER WITH SPLICE PER ESO11697 DATED 12/16/98. (M)SDR AALA982248Shear Tie · corrodedTUL - FOUND SHEAR TIE CORRODED UNDER LEVELING COMPOUND OUTBOARD OF STRINGER 27L. INSTALLED NEW SHEAR TIE PER SRM 51-10-1. (M)SDR AALA981085Sensor · defectiveDFW - FLT 1503 - AFTER TAKEOFF EWR EN ROUTE DFW, RIGHT MAIN LANDING GEAR RED LIGHT ILLUMINATED AND REMAINED ON FOR DURATION OF FLIGHT. RIGHT MAIN LANDING GEAR RED LIGHT EXTINGUISHED WHEN GEAR HANDLE WAS LOWERED AND RECEIVED DOWN AND LOCK INDICATION. LANDED DSDR AALA99036Web · wornTUL - LEFT TORQUE BOX WEB HAD HOLE WORN ALMOST THROUGH AT APROX STATION 1343 (VERT WEB). INSTALLED DOUBLER PER MM 51-40-2. (M)SDR AALA990035unknownTUL - RIGHT TORQUE BOX HAD HOLE WORN ALMOST THROUGH AT APPROX STATION 1343, VERT WEB. INSTALLED DOUBLER PER MM 51-40-2. (M)SDR AALA990034Shear Tie · crackedTUL - SHEAR TIE CRACKED STATION 52 BETWEEN STRINGER 27L-28L. REPAIRED PER SRM 53-10-4 FIG 15. (M)SDR AALA990031Frame · crackedTUL - STATION 620 WEB CRACKED BEHIND PRESSURE SEAL RETAINER 10 INCH FROM LOWER END OF AFT CUT OUT. CUTOUT CRACK AND INSTALLED FILLER AND DOUBLER PER SRM 51-40-2 FIG 1. WEB 2025T-6 MATERIAL .071 FILLER, .080 DOUBLERS, .1875 FIRST OVER HI-LOCKS, 45 FASTENERS, SDR AALA990030Frame · crackedTUL - CARGO DOOR AFT CUTOUT WEB CRACKED 13 INCHES FROM LOWER END OF CUTOUT BEHIND SEAL RETAINER STATION 620. CUTOUT CRACK AND INSTALLED FILLER AND DOUBLER PER SRM 51-40-2 FIG 1, USED 7075 T6 MATERIAL, .071 FILLER, .080 DOUBLERS, .1875 FIRST OVER HI-LOCKS, 45 SDR AALA982303Frame · dentedTUL - FOUND BELLFRAME DENTED TOP FLANGE STATION 620 FROM STRINGER 23L TO STRINGER 25L. DENTS AT STRINGER 25L AND 23L WITHIN LIMITS PER AARD 53-10-07-3 PAGE 1, CUTOUT DAMAGE AT STRINGER 24L AND INSTALLED REPAIR DOUBLER PER 51-40-3. (M)SDR AALA982302Frame · bentTUL - FOUND BELLFRAME BENT INTO RADIUS FORWARD STATION 1110 AND STRINGER 26R TOP LEG. MADE OUTSIDE DOUBLER, REPAIR PER 51-40-3 SRM INSTALLED WET, ALODINED AND PRIMED. (M)SDR AALA982301Frame · dentedTUL - FOUND BELLFRAME DENTED TOP FLANGE STATION 660 BETWEEN STRINGER 23R AND 25R. REMOVED AND REPLACED BELLFRAME SPLICE DOUBLER AT STRINGER 25R PART REPLACEMENT. CUTOUT DAMAGE AREAS (TWO PLACES) AND INSTALLED REPAIR DOUBLER AT STRINGER 23R TO STRINGER 24R PESDR AALA982298Frame · bentTUL - FOUND BELL FRAME BENT INTO FORWARD RADIUS STATION 1130 AND STRINGER 26R TOP LEG. REPAIRED DAMAGE AREA WITH DOUBLER PER 53-10-4. (M)SDR AALA982294Frame · dentedTUL - FOUND BELLFRAME DENTED SEVERAL PLACES ON TOP FLANGE STATION 520, FROM STRINGER 22L TO 25L. REMOVED DAMAGE INSTALLED 28 INCHES DOUBLER OF 7075T6 .063 INCH WITH 71 EACH .1875 INCH D RIVETS, 4 EACH .25 INCH RIVETS ALL UNIVERSAL HEADS AND TWO FLUSH .1875 RISDR AALA982293Frame · dentedTUL - FOUND BELLFRAME DENTED ONTOP FLANGE STATION 700 FROM STRINGER 22R TO STRINGER 24R. REMOVED DAMAGED INSTALELD 17.5 INCH DOUBLER OF 7075T6 .063 INCH WITH 37 MS20470 D .1875 FASTENERS PER SRM 51-40-3 FIG 1. (M)SDR AALA982292Frame · dentedTUL - FOUND BELLFRAME DENTED IN SEVERAL PLACES, STATION 500 FROM STRINGER 22L TO 25L. REMOVED DAMAGED INSTALLED 19 INCH DOUBLER OF 7075T6 .063 INCH WITH 44 EACH .1875 D RIVETS, 2 EACH .25 INCH D RIVETS ALL UNIVERSAL HEADS PER SRM 51-40-3 FIG 1. (M)SDR AALA982291Frame · dentedTUL - FOUND BELLFRAME DENTED TOP FLANGE STATION 660 FROM STRINGER 28L TO STRINGER 24L. REMOVED DAMAGE AREA, FROM 23L-24L, STATION 660. INSTALLED .063 DOUBLER 18 INCH LONG, 7075T6 COVERED TWO DAMAGE AREAS 1 INCH BY 1.5 INCH AND 1 INCH BY 2 INCH. USED 45 EACHSDR AALA982290Frame · dentedTUL - FOUND BELLFRAME DENTED TOP FLANGE STATION 680 FROM STRINGER 24R TO STRINGER 25R. REMOVED DAMAGE, INSTALLED 14 INCH DOUBLER PER AARD 53-10-07-3 PAGE 1 OF 7075T6 .063 INCH THICK WITH 29 MS2040D .1875 INCH RIVETS, 4 MS2040D .25 INCH RIVETS. (M)SDR AALA982287Frame · corrodedTUL - FOUND BELLFRAME 720E SPOTTED WITH CORROSION FROM STRINGER 4L TO 8L. REMOVED DAMAGED AREA CUT TO SIZE FILLERS AND DOUBLERS DRILLED, ALODINED, PRIMED, SEALED AND INSTALLED FASTENERS PER SRM 53-10-4. (M)SDR AALA982286Fitting · corrodedTUL - FOUND LEFT GEAR FORWARD TRUNNION SUPPORT FITTING HAS PITTING INSIDE 4 EACH BUSHING BORES. REMOVED PITTING BY OVERSIZING BUSHING BORES AND INSTALLING NEW BUSHINGS. REPAIRED PER ESO 11697 DATED 11-24-98. (M)SDR AALA982282Stiffener · corrodedTUL - FOUND RIGHT N/G TRUNNION FORWARD UPPER SUPPORT BEAM CORRODED FORWARD SIDE OF CUTOUT FORWARD STIFFENER. REMOVED STIFFENER, MILLSHOP FABRICATED NEW STIFFENER PER DWG 65-18915. STIFFENER WAS TREATED PRIMED AND INSTALLED WITH HI-LOCK AT ORIGINAL FASTENER HSDR AALA982276Stiffener · corrodedTUL - FOUND RIGHT N/G TRUNNION FORWARD UPPER SUPPORT BEAM IN CUTOUT CORRODED AT INBOARD END TOP AND BOTTOM FLANGES. REMOVED STIFFENER , SHOP FABRICATED NEW STIFFENER PER DWG 65-18915. STIFFENER WAS TREATED PRIMED AND INSTALLED WITH HI-LOCKS AT ORIGINAL FASTESDR AALA982275Stiffener · corrodedTUL - FOUND RIGHT N/R TRUNNION AFT UPPER SUPPORT BEAM IN CUTOUT. TOP FLANGE CORRODED INBOARD AND OUTBOARD END. REMOVED STIFFENER MILL SHOP FABRICATED NEW STIFFENER PER DWG 65-18915. STIFFENER WAS TREATED, PRIMED AND INSTALLED WITH HI-LOCKS AT ORIGINAL FASTESDR AALA982266Floorbeam · corrodedTUL - FOUND CORROSION ON FLOORBEAM STATION 380 BL 0 TO RBL 65. REPAIRED PER SRM 53-10-08 FIG 9A AND 9B AT STATION 380 RBL 27. REPAIRED PER SRM 53-10-08 FIG 9A AND 9B AT STATION 380 RBL 39 TO RBL 71. (M)SDR AALA982265Floorbeam · corrodedTUL - FOUND CORROSION ON FLOORBEAM STATION 344 LBL 40 TO RBL 60, TOP FLANGE. INSTALLED NEW T-ANGLE SECTION AND SPLICE PER SRM 53-10-8 FIG 9. (M)SDR AALA982264Skin · crackedTUL - FOUND SKIN EXFOLIATED AND CRACKED APPROX 3 INCHES LONG STATION 720 PLUS 14 TO STATION 720 PLUS 18 AT STRINGER 27L. REMOVED CORROSION BY CUTTING OUT EXFOLIATED SECTION OF SKIN. ALODINED AND PRIMED CUT OUT. INSTALLED SKIN REPAIR PER SRM 53-30-3 FIG 3. SDR AALA982255Stringer · corrodedTUL - FOUND CORROSION INSIDE STRINGER 26R STATION 476 - STATION 480. INSTALLED STRINGER REPAIR PER SRM 53-10-3. (M)SDR AALA982253Pan · corrodedTUL - FOUND HEAVY CORROSION ON BOTTOM OF FLOOR PAN (CABIN) 6 INCHES FORWARD OF BS 1183 LBL 26, EXTENDING 6 INCHES FORWARD AND 6 INCHES OUTBOARD, GOING OVER TOP OF FITTING AT LBL 27. FABRICATED AND INSTALLED REPAIR DOUBLER ON LEFT AFT LAV FLOOR PAN IAW SRM 51SDR AALA982252Strap · corrodedTUL - FOUND CORROSION ON STRAP AT STATION 1177 LEFT AFT LAVATORY AFT SPLASH LIP AREA AT CABLE FLOOR ATTACH FITTING AREA. FABRICATED AND INSTALLED REPAIR DOUBLER AT SPLASH LIP STRAP IAW SRM 51-40-3 FIG 1. (M)SDR AALA982246Shear Tie · corrodedTUL - FOUND FORWARD SIDE STATION 600 OUTBOARD STRINGER 27L TO 26L SHEAR TIE CORRODED. INSTALLED NEW SHEAR TIE PER SRM 51-10-1. (M)SDR AALA990029Frame · crackedTUL - NR 2 CARGO DOOR FRAME (FORWARD FRAME) IN FUSE CUTOUT HAS CRCK EXTENDING FROM LOWER STOP CASTING, LOWER SIDE. NDT FOUND CRACK AT LOWER STOP FITTING LOCATION ON FRAME AND NDT SHOWS CRACK PROPOGATING UPWARDS UNDER STOP CASTINGS THROUGH THE OTHER SIDE OF TH
Back to Boeing 727-223