N289SC, cancelled Dec 12, 2002
Service difficulty reports · 162
Matched to this aircraft by N-number and event date, checked against the reported serial number, make and model. Newest first.
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 n_number = 'N289SC' AND deregistration_id = 'N289SC-2002-12-12' 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 n_number = 'N289SC' AND deregistration_id = 'N289SC-2002-12-12' 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 SCNA99743Seat Track · corrodedDURING HEAVY MAINTENANCE CHECK, CORROSION WAS FOUND OUT OF LIMITS AT SEAT TRACK FORWARD RT CABIN, STA 410, RBL 36. REMOVED CORROSION PER SRM 511006. FABRICATED NEW SEAT TRACK PER SAMPLE FROM BAC 1520792. TREATED PER SRM 511002. PRIMED PER MM 512002. INSTASDR SCNA99741Support · corrodedDURING HEAVY MAINTENANCE CHECK, CORROSION WAS FOUND OUT OF LIMITS AT INTERIOR FUSELAGE STA 420 BL 36R FLOOR SUPPORT. REMOVED CORROSION IAW B727 511006. REMOVED FLOOR SUPPORT FROM BS 385 RBL 18 PER SRM 513002. FABRICATED NEW SUPPORT FROM BAC 15064417 PER SAMSDR SCNA99740Support · corrodedDURING HEAVY MAINTENANCE CHECK, CORROSION WAS FOUND OUT OF LIMITS AT INTERIOR FUSELAGE STA 385 BL 18R FLOOR SUPPORT. REMOVED CORROSION IAW B727 511006. REMOVED FLOOR SUPPORT FROM BS 385 RBL 18 PER SRM 513002. FABRICATED NEW SUPPORT FROM BAC 15064417 PER SAMSDR SCNA99742Bracket · corrodedDURING HEAVY MAINTENANCE CHECK, CORROSION WAS FOUND OUT OF LIMITS AT STA 1183 LBL 1783 WL 208 LOWER ATTACH BRACKET FOR VERTICAL BEAM. REMOVED CORROSION IAW SRM 511006. REMOVED BRACKET IAW SRM 513002. FABRICATED NEW BRACKET PER SAMPLE FROM 7075 T6 .032. TRESDR SCNA99122Sign · inoperativeDURING A LINE MAINTENANCE CHECK, THE EMERGENCY EXIT SIGN AT THE LOWER RIGHT SIDE OF L2 DOOR WAS FOUND INOPERATIVE. REMOVED AND REPLACED THE LOWER L2 DOOR EMERGENCY EXIT SIGN, OPERATIONALLY CHECKS GOOD.SDR SCNA99102Cargo Net · out of positionDURING CLIMB-OUT, UNABLE TO MAINTAIN PRESSURIZATION. TROUBLESHOT PRESSURIZATION SYSTEM AND FOUND THE AFT CARGO DOOR NET AND LATCH WEDGED BETWEEN THE CARGO DOOR AND THE DOOR FRAME. REMOVED AND RESECURED THE CARGO NET. PERFORMED AN OPERATIONAL TEST OF THE SYSSDR SCNA99088Smoke Detector · inoperativeDURING FLIGHT, THE SMOKE DETECTOR IN THE FORWARD LAV ALARMS CONTINUOUSLY AFTER TESTING. REMOVED AND REPLACED THE SMOKE DETECTOR IN THE FORWARD LAVATORY. OPS CHECKS GOOD.SDR SCNA99086Actuator · failedDURING DESCENT, CREW OBSERVED 'A' SYSTEM HYDRAULIC FAILURE. HYDRAULIC QUANTITY AND PRESSURE READ ZERO. ALL COM PROCEDURES WERE COMPLIED WITH AND LANDING WAS UNREMARKABLE. INSPECTED AND FOUND A BLOWN O-RING ON THE NR 2 ACTUATOR FOR THE SPOILER. REMOVED AND RSDR SCNA99078Light · inoperativeDURING A LINE MAINTENANCE CHECK, THE FORWARD HALF OF THE EMERGENCY FLOOR TRACK LIGHTING WAS FOUND TO BE INOPERATIVE. REPAIRED THE CONNECTION AT SEATS 5ABC FOR FLOOR TRACK EMERGENCY LIGHTING. OPERATIONALLY CHECKS GOOD.SDR SCNA99048Clamp · looseDURING CLIMB, THE NR 1 ENGINE STRUT OVERHEAT LIGHT ILLUMINATED. LIGHT EXTINGUISHED WITH REDUCED POWER THEN ILLUMINATED AGAIN WHEN CLIMB POWER WAS SET. ALSO, LIGHT WAS ILLUMINATED WITH ASSOCIATED BLEED AND PACKS OFF. FOUND THE 13TH STAGE REGULATOR VALVE CLAMSDR SCNA99015Clamp · looseDURING CLIMBOUT FROM SFO, THE ENGINE NUMBER ONE STRUT OVERHEAT LIGHT ILLUMINATED. FOUND ENGINE DUCT IN THE NUMBER ONE PYLON LEAKING JUST BEFORE THE PRECOOLER. TIGHTENED CLAMP AND RAN THE NUMBER ONE ENGINE TO LEAK CHECK. NUMBER ONE ENGINE LEAK CHECKED GOOD ISDR SCNA98135Battery Pack · dischargedDURING A LINE MAINTENANCE CHECK, THE FORWARD SECTION OF EMERGENCY FLOOR TRACK LIGHTING WAS FOUND TO BE INOPERATIVE. REMOVED AND REPLACED FORWARD EMERGENCY FLOOR TRACK LIGHTING POWER SUPPLY. FORWARD SECTION OF FLOOR TRACK LIGHTING OPERATIONALLY CHECKS GOOD.SDR SCNA98136Battery Pack · dischargedDURING A LINE MAINTENANCE CHECK, THE LEFT AFT OVERWING EMERGENCY EXIT LIGHT WAS FOUND TO BE INOPERATIVE. REMOVED AND REPLACED THE BATTERY AND BATTERY CHARGER PACK M955. LEFT AFT EXTERIOR OVERWING EMERGENCY EXIT LIGHT OPERATIONALLY CHECKS GOOD.SDR SCNA98133Battery Pack · dischargedDURING A LINE MAINTENANCE CHECK, THE LEFT AFT EMERGENCY LIGHT WAS FOUND TO BE INOPERATIVE. REPLACED THE EMERGENCY LIGHT BATTERY PACK AT THE E & E BAY LOCATION M955, OPERATIONALLY CHECKS GOOD.SDR SCNA98125Battery Pack · dischargedDURING A LINE MAINTENANCE CHECK, THE LEFT AFT OVERWING EMERGENCY LIGHT WAS FOUND TO BE INOPERATIVE. REMOVED AND REPLACED THE BATTERY PACK AT M955. ALL EMERGENCY LIGHTS CHECK GOOD.SDR SCNA98124Light · inoperativeDURING A LINE MAINTENANCE CHECK, THE L1 DOOR EMERGENCY SLIDE LIGHT WAS FOUND TO BE INOPERATIVE. CLEANED LAMP CONTACTS AND OPERATIONALLY CHECKS GOOD.SDR SCNA98115Sign · inoperativeDURING A LINE MAINTENANCE CHECK, THE LOWER EMERGENCY EXIT SIGN AT THE L4 DOOR WAS FOUND TO BE INOPERATIVE. FOUND RIBBON TO LOWER L4 DOOR EMERGENCY EXIT SIGN CUT. REPAIRED RIBBON AND OPERATIONALLY CHECKS NORMAL.SDR SCNA98114Light · inoperativeDURING A LINE MAINTENANCE CHECK, THE AFT AIRSTAIR OVERHEAD EMERGENCY LIGHT WAS FOUND TO BE INOPERATIVE. REMOVED AND REPLACED THE ASSOCIATED LIGHT ASSEMBLY, LIGHT OPERATIONALLY CHECKS GOOD.SDR SCNA98113Wire · looseDURING A HEAVY MAINTENANCE CHECK, THE FORWARD POSTION OF THE EMERGENCY PATH LIGHTING WAS FOUND TO BE INOPERATIVE. REPAIRED WIRE IAW SWP 201013. OPERATIONALLY CHECKS GOOD IAW B727 MM 33501.SDR SCNA98715Support · corrodedDURING A HEAVY MAINT CHECK, FLOORBOARD SUPPORT FRAME WAS FOUND TO HAVE CORROSION A BS STA 320. CORROSION ON FLOORBOARD SUPPORT BEAM WAS FOUND TO BE OUT OF LIMITS IAW B727 SRM 531001. REMOVED DAMAGED FLOORBEAM SUPPORT IAW B727 SRM 513002. FABRICATED NEW FLOOSDR SCNA98714Stringer · corrodedDURING A HEAVY MAINT CHECK, EXFOILIATION WAS FOUND PRESENT AT STA 720C STR 28R AT BOTTOM OF RIB UNDER LEVELING COMPOUND. REMOVED DAMAGED AREA IAW B727 SRM 513002 AND 531004 FIGURE 13. FABRICATED NEW DOUBLER OUT OF 7075 T6 .071 IAW B727 SRM 531004. TREATED ASDR SCNA98096Light · inoperativeDURING A LINE MAINTENANCE CHECK, THE L1 DOOR EMERGENCY EXIT LIGHT WAS FOUND TO BE INOPERATIVE. REMOVED AND REPLACED THE EMERGENCY EXIT LIGHT. OPERATIONALLY CHECKS GOOD PER MAINTENANCE MANUAL 3350101.SDR SCNA98085Actuator · failedDURING CLIMB, THE NUMBER FIVE LEADING EDGE SLAT AND THE NUMBER SIX LEADING EDGE FLAP WOULD NOT RETRACT. REMOVED AND REPLACED THE NUMBER FIVE LEADING EDGE SLAT ACTUATOR PER MAINTENANCE MANUAL 278132 AND INSTALLED A NUMBER SIX LEADING EDGE FLAP INDICATION EMERGSDR SCNA98084Power Stop · not stowedDURING TAKEOFF ROLL FOLLOWING A MAINTENANCE CHECK, THE AIRCRAFT WOULD NOT REACH TAKEOFF POWER ON THE NUMBER THREE ENGINE. FOUND THE PART POWER STOP IN THE PART POWER STOP POSITION. STOWED AND SAFETIED THE PART POWER STOP. ENGINE OPERATIONALLY CHECKS NORMAL.SDR SCNA98081Oven · dirtySMOKE WAS OBSERVED COMING OUT FROM A SPACE ABOVE THE NUMBER TWO OVEN IN THE FORWARD GALLEY. CLEANED HEATER ELEMENT AND OPERATED THE OVEN. OPERATIONALLY CHECKED GOOD.SDR SCNA97343Switch · out of adjustNUMBER 2 LT LEADING EDGE FLAP FAILED TO RETRACT ON DEPARTURE. RETURNED TO LAS. REPLACED HARDWARE ON INTRANSIT SWITCH AND READJUSTED IN ACCORDANCE WITH MM 27-80-04. FUNCTIONALLY TESTED NORMAL.SDR SCNA97340Bolt · missingDURING CLIMBOUT, COULD NOT ADVANCE NUMBER 2 ENGINE THROTTLE PAST 85 PERCENT N1. AT TOP OF CLIMB, N1 WAS AT 99 PERCENT AND COULD NOT PULL BACK POWER. SHUT DOWN ENGINE FOR PRECAUTIONARY REASONS. FOUND FUEL CONTROL ROD FOR THROTTLE, FORWARD END, MISSING BOLT. SDR SCNA97336Battery · dischargedTHE AFT SECTION OF THE EMERGENCY TRACK LIGHTING WAS FOUND TO BE INOPERATIVE. REMOVED AND REPLACED BATTERY PACK FOR AFT SECTION OF TRACK LIGHTING, PATH LIGHTING CHECKED NORMAL.SDR SCNA97332Seat Track · corrodedDURING HEAVY MAINTENANCE VISIT, FLOOR BOARD TRACK INSIDE FORWARD LAVATORY DOOR WAS FOUND CORRODED ABOVE DOGHOUSE. REMOVED TRACK, FABRICATED NEW FLOOR AND TRACK AND INSTALLED IAW SRM 51-30-2 AND 53-10-2.SDR SCNA97331Floorbeam · corrodedDURING HEAVY MAINTENANCE VISIT, FLOORBEAM UPPER FLANGE WAS FOUND CORRODED AT STATION 1050, RBL 42 TO 59. CUT OUT DAMAGED SECTION, FABRICATED AND INSTALLED REPAIR ANGLES PER B727 SRM 51-30-2 AND 53-10-8.SDR SCNA97329Seat Track · corrodedDURING HEAVY MAINTENANCE VISIT, CORROSION WAS FOUND ON SEAT TRACKS AT STATION 1110, RBL 45 AND RBL 55. REMOVED, FABRICATED AND INSTALLED BOTH SECTIONS OF SEAT TRACK FROM STATIONS 1070 TO 1130 IAW SRM 51-31-02, 51-10-6 AND 53-10-5.SDR SCNA97330Fitting · corrodedDURING HEAVY MAINTENANCE VISIT, TIE FITTING AT STATION 1183, STRINGER 25R WAS FOUND CORRODED. AFTER REMOVAL OF TIE FITTING, STRINGER 25R WAS FOUND TO HAVE EXFOLIATION CORROSION. REMOVED AND REPLACED TIE FITTING IAW B727 SRM 51-10-1 AND REMOVED AND INSTALLED SDR SCNA97303Structure · damagedFOUND AIRCRAFT SKIN DAMAGE CAUSED BY JET WAY NEAR L-1 DOOR AT STATION 380, WL 206.1. INSTALLED NEW FRAME WEB, STRINGER REPAIRS AND FUSELAGE REPAIRS PER B727 SRM 51-40-4 AND 53-30-3.SDR SCNA97298Smoke Detector · failedTHE AFT RIGHT LAVATORY SMOKE DETECTOR WAS FOUND TO BE INOPERATIVE. REMOVED AND REPLACED SMOKE DETECTOR, NEW DETECTOR TESTED GOOD.SDR SCNA97174Wire · brokenTHE MID CABIN FLOOR TRACK LIGHTING WAS FOUND INOPERATIVE. REPAIRED BROKEN WIRES, AND TRACK LIGHTING TESTED NORMAL.SDR SCNA97126Cross Shaft Nut · looseDURING DESCENT HAD NO THROTTLE RESPONSE FROM THE NUMBER 3 ENGINE. FOUND UPPER THRUST CRANK ON INBOARD SIDE OF ENGINE CROSS SHAFT SECURING NUT LOOSE AND THRUST CRANK OFF THE SPRING SHAFT. REINSTALLED THRUST CRANK AND TORQUED AND SAFETIED NUT. PERFORMED ENGINSDR SCNA97077Wire · brokenFOUND EMERGENCY FLOOR PATH LIGHTING INOP FROM ROWS 13 TO 19. FOUND AND REPAIRED BROKEN WIRE. SYSTEM FUNCTIONALLY TESTED NORMAL.SDR SCNA97076Exit Sign · failedEMERGENCY EXIT CIRCUIT BREAKER TRIPPED. FOUND RIGHT AFT OVERWING EXIT SIGN SHROUD SHORTING 28 VAC LINE TO GROUND. ADJUSTED SHROUD CORRECTLY AND FUNCTIONALLY TESTED NORMAL.SDR SCNA97063Power Supply · inoperativeRIGHT OVERWING EMERGENCY EXIT LIGHTS WERE FOUND FLICKERING. REMOVED AND REPLACED POWER SUPPLY AND OPS CHECKED GOOD IN ACCORDANCE WITH MM 33-50-22.SDR SCNA97031Door · not latchedDURING CLIMB, EQUIPMENT ACCESS DOOR LIGHT ILLUMINATED AND UNABLE TO PRESSURIZE CABIN. RETURNED TO MSP. INSPECTED EQUIPMENT ACCESS DOOR, SEAL AND INDICATOR SWITCH IN ACCORDANCE WITH 52-70-01, OPS CHECKED NORMAL.SDR SCNA97033Light · inoperativeR1 DOOR EMERGENCY LIGHT FOUND INOP. REMOVED AND REPLACED EMERGENCY LIGHT AND BATTERIES, OPS CHECKED GOOD.SDR SCNA97029Battery Pack · dischargedRIGHT OVERWING EMERGENCY EXIT LIGHT BLINK ON AND OFF. REMOVED AND REPLACED BATTERY PACK AND OPS CHECKED GOOD.SDR SCNA97028Battery Pack · dischargedOVER AISLE EMERGENCY LIGHT INOP NEAR OVERWING EXITS. REMOVED AND REPLACED BATTERY PACK AND POWER SUPPLY, OPS CHECKED NORMAL.SDR SCNA97017Light · inoperativePORTABLE EMERGENCY LIGHT AT L2 HAS 2 BULBS INOP. REMOVED AND REPLACED EMERGENCY LIGHT ASSEMBLY AND OPS CHECKED GOOD.SDR SCNA97014Battery Pack · dischargedFOUND OVERWING EMERGENCY AREA LIGHT DIM. REMOVED AND REPLACED BATTERY PACK AND OPS CHECKED NORMAL IN ACCORDANCE WITH MM 33-50-71.SDR SCNA97002Battery Pack · dischargedRIGHT WING OVERDOOR EMERGENCY EXIT LIGHTS CAME ON FOR ONLY THREE TO FIVE SECONDS. REMOVED AND REPLACED BATTERY PACK FOR RIGHT WING OVERDOOR EMERGENCY EXIT LIGHTS IN ACCORDANCE WITH MM 33-50-0 AND OPS CHECKED NORMALLY.SDR SCNA96441Power Strip · inoperativeAFT 10 FEET OF EMERGENCY FLOOR TRACK LIGHTING WAS FOUND VERY DIM. REMOVED AND REPLACED AFT POWER STRIP UNDERNEATH TRACK LIGHTS. ALSO, REPLACED ONE TRACK LIGHT STRIP JUST FORWARD OF THE L2 DOOR. SYSTEM OPS CHECKED NORMAL IN ACCORDANCE WITH MM 33-50-00.SDR SCNA96437Exit Sign · missingFOUND RIGHT FORWARD EMERGENCY EXIT LUMINESCENCE SIGN MISSING. REMOVED AND REPLACED RIGHT FORWARD EMERGENCY EXIT LUMINESCENT EXIT SIGN IN ACCORDANCE WITH MM 33-50-31.SDR SCNA96400Wire · openFOUND AFT FLOOR TRACK LIGHTS INOP NEAR GALLEY. REPAIRED WIRING IN TRACK AND OPS CHECKED GOOD.SDR SCNA96399Power Supply · inoperativeFOUND RIGHT FORWARD AND AFT OVERWING EMERGENCY EXIT SIGNS INOP. REMOVED AND REPLACED RIGHT FORWARD AND AFT OVERWING EMERGENCY EXIT POWER SUPPLY AND OPS CHECKED GOOD.
Back to N289SC, cancelled Dec 12, 2002