N939UP, cancelled Aug 23, 2006
Service difficulty reports · 129
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 = 'N939UP' AND deregistration_id = 'N939UP-2006-08-23' 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 = 'N939UP' AND deregistration_id = 'N939UP-2006-08-23' 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 UPS01234744Nut · looseINSPECTION TYPE:N/A AFTER GEAR RETRACTION RIGHT MAIN GEAR DOOR WARNING AND RED GEAR DOOR LIGHTS REMAINED ILLUMINATED. SELECTED GEAR UP 2 TIMES BEFORE LIGHTS EXTINGUISHED. FOUND RT GEAR DOOR WARNING SWITCH, JAM NUTS LOOSE, TIGHTENED JAM NUTS AND RE-SAFTIED NUSDR UPS99231121Indicator · inopINSPECTION TYPE: N/A, ON FLAP SELECTION NO O/B FLAP MOVEMENT, SPLIT FLAP COND. PERFORMED SPLIT FLAP AND ALT USE FLAP EXTENTION CHECKLIST. NORMAL LANDING. REMOVED AND REPLACED O/B FLAP POSITION INDICATOR PER MM 27-52-21 AND ADJUSTED RIGHT O/B FLAP POSITION TSDR UPS99231078Pressure Web · crackedINSPECTION TYPE:C NOSE WHEEL WELL RIGHT SIDEWALL PRESSURE WEB CRACKED AT BS235.8, WL17 0. (JUST BELOW PRESSURE PANEL) CRACK VERIFIED PER NDT PART 6, 51-00-00 HFEC. STOP DRILLED CRACKS. T RIMMED OUT DAMAGED AREA. INSTALLED REPAIR ON RIGHT PRESSURE WEB BS23 5SDR UPS99231077Pressure Web · crackedINSPECTION TYPE:C NOSE WHEEL WELL LEFT SIDEWALL PRESSURE WEB CRACKED AT BS259.5, WL190 (TWO INCHES BELOW CEILING). CRACK VERIFIED PER NDT PART 6, 51-00-00 HFEC. STOP DRILLED CRACKS ON SIDEWALL PRESSURE WEB. CUT-OUT DAMAGED AREA AT NOSE WHEEL WELL LEFT SIDESDR UPS99231076Pressure Web · crackedINSPECTION TYPE:C NOSE WHELL WELL CEILING PRESSURE WEB CRACKED AT BS277, WL194. CRACKS VERIFIED PER NDT PART 6, 51-00-00, HFEC. STOP DRILLED CRACKS ON CEILING PRESSURE WEB AT STA 277, WL 194. CRACKS END AT STOP DRILL. REMOVED AND REPLACED DAMAGED SECTION OSDR UPS99231075Skin · crackedINSPECTION TYPE:C LEFT WING OUTBOARD FLAP-FOREFLAP LEADING EDGE SKIN CRACKED AT RIVET HEAD (NR 2 FOREFLAP CARRIAGE). PERFORMED HFEC INSP OF CRACK AT L/W O/B FOREFLAP IAW NDT MANUAL PART 6, 51-00-00, FIG 4. VERIFIED CRACK EXTENDS FROM RIVET HOLE TO SKIN EDGE.SDR UPS99231074Blkhd Stiffener · crackedINSPECTION TYPE:C AFT CARGO COMPARTMENT, BS1183 BULKHEAD, VERTICAL STIFFENER, RBL 8 HAS CRACK INDICATION, TOP OF STRINGER, OUTBOARD SIDE OF STIFFENER. HFEC INSPECTED AND VERIFIED CRACK INDICATION AT TOP OF STIFFENER RBL 8, BS 1183, LENGTH 1.25 INCH IAW NDT MASDR UPS99231073Frame · damagedINSPECTION TYPE:C C/W PERMANENT REPAIR TO OVERWING EXIT FRAMES 783.95 RIGHT, 825.95 LEFT, 825.95 RIGHT, AND 848.95 RIGHT. INSTALLED PERMANENT REPAIRS TO OVERWING EXIT FRAMES BS783.95 RIGHT, 825.95 LEFT, 848.95 RIGHT AS PER UPS E0 B727-5310-12010-A.SDR UPS99231072Bracket · corrodedINSPECTION TYPE:C RT WING AFT SPAR AT WS 380.0 THE NR 6 T/E FLAP JACKSCREW OUTBOARD ATTACH BRACKET HAS CORROSION ON LOWER ATTACH POINT. REMOVED AND REPLACED BRACKET IAW SRM 51-10-1 AND 51-30-2.SDR UPS99228332Relay · contaminatedINSPECTION TYPE-N/A, DURING DEPARTURE CLIMB PRIOR TO FLAP RETRACTION, THE NR 3 THROTTLE SNAPPED BACK TO IDLE WITH AN AMBER TR WARNING LIGHT ILLUMINATED. NOW ACTUAL AIRFRAME VIBRATION NOTED. THROTTLE WOULD NOT ADVANCE, ENG WAS THEN SHUTDOWN. AIR TURNBACK TO SDR UPS98225955Battery Pack · dischargedINSPECTION TYPE-N/A, WITH EMERGENCY LIGHT SWITCH OFF, MAIN ENTRY DOOR EMERGENCY LIGHT ILLUMINATES. WHEN POWER IS REMOVED FROM A/C RESEATING UNIT, HAD NO EFFECT LIGHT ASSY (S/N 27741). REMOVED AND REPLACED BATTERIES, OPS CHECK GOOD.SDR UPS97222406Press Line · rupturedON CLIMB-OUT OF MCO, LOST HYD B SYSTEM. COMPLIED WITH APPROPRIATE CHECKLIST. DURING CRUISE, HYD A SYSTEM TRICKLED DOWN TO 2.5 GAL, HYDRAULIC BRAKE PRESS REMAINED AT 3000 PSI. PRIOR TO LANDING AT CAE, DECLARED EMERGENCY, FLIGHT COMPLETED . INST COLLECT PRESSDR UPS97222306Control Valve · leakingAPPROX 5 MIN AFTER T/O, BOTH A-SYS LOW HYD PRESS LIGHTS ILLUMINATED AND THE A-SYS QTY DROPPED TO ZERO. A-SYS PRESS REMAINED AT APPROX 2000 PSI, BUT OSCILATED FROM 1500-2400 PSI AFTER CK LIST COMPLETE A-SYS QTY ROSE TO 1.7. ALL CK LIST COMPLIED WITH AND AIRCRSDR UPS97221899Cargo Track · corrodedINSPECTION TYPE: C. CORROSION ON CARGO FLOOR SEAT TRACK BS 1051 RBL 15.5 BOTTOM SIDE OF FLANGE. REMOVED DAMAGED SECTION AND INSTALLED REPAIR SECTION IAW SRM 53-10-5.SDR UPS97221902Skin · delaminationINSPECTION TYPE: C. LT WING AFT I/B FLAP HAS A 4 INCH BY 4 INCH AREA OF DELAMINATION 9 INCHES FROM O/B END AND 9 INCHES FROM TRAILING EDGE OUTER SURFACE. REPAIRED LT WING I/B AFT FLAP IAW SRM 51-40-6.SDR UPS97221901Skin · delaminatedINSPECTION TYPE: C. RT WING I/B AFT FLAP HAS 2 AREAS OF DELAMINATION 18 INCHES FROM I/B END, 13 INCHES FROM T/E UPPER SURFACE. REPAIRED RT WING I/B AFT FLAP IAW SRM 51-40-6.SDR UPS97221873Stringer · corrodedINSPECTION TYPE: C. WHILE WORKING 950 SIDE FITTING FOUND STRINGER 9 TO BE CORRODED AT BS 960 RT SIDE. REMOVED CORROSION AND FOUND TO BE OUT OF LIMITS, IAW SRM 51-10-6, 53-10-11, FABRICATED REPAIR PARTS AND INSTALLED IAW SRM 53-10-3.SDR UPS96221218Lnding Gear Hndl · lack of lubeLANDING GEAR HANDLE IS VERY HARD TO MOVE OUT AND IN DETENT, ALSO, UP AND DOWN. WHEN PLACING HANDLE FROM UP TO OFF, HANDLE DID NOT STOP AND LOWERED GEAR. LUBRICATED GEAR HANDLE AND OVERRIDE TRIGGER. PINNED LANDING GEAR AND ACTUATED HANDLE. GEAR HANDLE OPS CSDR UPS204285Expand Link · corrodedWHILE IN FOR C-CHECK, MAINTENANCE FOUND CORROSION ON THE EXPANSION LINK AND BUSING AT STATION 740, RBL 25 AND WL 207. MAINTENANCE REMOVED AND INSTALLED A NEW LINK IAW SRM 51-10-2, 53-10-1 AND 51-30-2.SDR UPS204284Web · corrodedWHILE IN FOR C-CHECK, MAINTENANCE FOUND CORROSION ON THE WEB AT STATION 740, LBL 60 AND WL 198. MAINTENANCE REPAIRED DAMAGED AREA IAW UPS EO B727-5710-7331-A.SDR UPS204283Fitting · corrodedWHILE IN FOR C-CHECK, MAINTENANCE FOUND CORROSION ON THE NUMBER 7 SPOILER FITTING. MAINTENANCE REMOVED AND REPLACED THE NUMBER 7 SPOILER FITTING PER SRM 1-30-2.SDR UPS204282Trunnion Ftg · corrodedWHILE IN FOR C-CHECK, MAINTENANCE FOUND CORROSION UNDER THE TRUNNION FITTING OF THE LEFT WING SPAR CHORD. MAINTENANCE REMOVED AND INSTALLED NEW TRUNNION FITTING PER MM 32-11-00 AND 32-11-01.SDR UPS204281Chord · crackedWHILE IN FOR C-CHECK, MAINTENANCE FOUND A CRACK IN THE RIGHT HAND OUTER CHORD BETWEEN STRINGER 9 TO 810 RIGHT. THE INDICATION IS PRESENT FOR THE FULL LENGTH AT THIS AREA. MAINTENANCE REPLACED THE DAMAGED AREA IAW UPS EO B727-5310-3012.SDR UPS204280Chord · corrodedWHILE IN FOR C-CHECK, MAINTENANCE FOUND CORROSION ON THE LOWER CHORD AT STATION 740 AND RBL 25 TO LBL 25. MAINTENANCE FABRICATED REPAIR PARTS AND INSTALLED IAW UPS EO B727-5210-7332-A.SDR UPS204279Splice · corrodedWHILE IN FOR C-CHECK, MAINTENANCE FOUND CORROSION ON THE BL ZERO FRAME AT STATION 600, LBL 2 AND WL 199. MAINTENANCE FABRICATED THE REPAIR PARTS AND INSTALLED IAW UPS EO B727-5310-7277-A.SDR UPS204232Trunnion · corrodedWHILE IN FOR C-CHECK, MAINTENANCE FOUND CORROSION ON THE TRUNNION SUPPORT FITTING AROUND HOLES FOR THE TRUNNION BEARING. MAINTENANCE REPLACED WITH NEW FITTING IAW UPS EO 727-57-1426.SDR UPS204231Trunnion · corrodedWHILE IN FOR C-CHECK, MAINTENANCE FOUND CORROSION ON THE LT WING TRUNNION FITTING WS 221 WL 185 WHILE WORKING. MAINTENANCE INSTALLED NEW TRUNNION IAW SRM 51-32-4, 51-30-5, 51-30-8, AND 51-20-4.SDR UPS204230Skin · crackedWHILE IN FOR C-CHECK, MAINTENANCE FOUND DENT AND POSSIBLE CRACK ON LEFT WING O/B AILERON UPPER SURFACE 24.5 FROM O/B END. MAINTENANCE REMOVED THE DAMAGED AREA AND FABRICATED REPAIR PARTS IAW SRM 51-80-4, MM 27-10-31, AND SRM 57-50-5.SDR UPS204229K-Flap · pittedWHILE IN FOR C-CHECK, MAINTENANCE FOUND NR 6 K-FLAP CENTER LUG PITTED ON LOWER I/B HOLE AND UPPER O/B HOLE. MAINTENANCE REMOVED AND REPLACED NR 6 K-FLAP PER MM 27-81-01.SDR UPS204228K-Flap · pittedWHILE IN FOR C-CHECK, MAINTENANCE FOUND NR 5 K-FLAP I/B LUG IS PITTED AROUND BOLTS AND EDGE LUG. MAINTENANCE REMOVED AND REPLACED NR 5 K-FLAP PER MM 27-81-01.SDR UPS204227K-Flap · corrodedWHILE IN FOR C-CHECK, MAINTENANCE FOUND NR 4 K-FLAP O/B LUG PITTED AROUND UPPER AND LOWER BOLTS. MAINTENANCE REMOVED AND REPLACED NR 4 K-FLAP PER MM 27-81-01.SDR UPS204226K-Flap · corrodedWHILE IN FOR C-CHECK, MAINTENANCE FOUND NR 3 K-FLAP I/B LUG UPPER BOLT HAS CORROSION AROUND THE NUT. MAINTENANCE REPLACED THE NR 3 K-FLAP PER MM 27-80-00.SDR UPS204225K-Flap · corrodedWHILE IN FOR C-CHECK, MAINTENANCE FOUND THE NR 2 K-FLAP CENTER LUG CORRODED AROUND UPPER AND LOWER BOLTS. MAINTENANCE REPLACED THE NR 2 K-FLAP IAW MM 27-80-00.SDR UPS204224Bullnose · corrodedWHILE IN FOR C-CHECK, MAINTENANCE FOUND NR 1 K-FLAP BULLNOSE HAS PITTING AROUND O/B ATTACH LUG. MAINTENANCE REMOVED AND REPLACED BULLNOSE PER MM 27-81-01.SDR UPS204223Fitting · corrodedWHILE IN FOR C-CHECK, MAINTENANCE FOUND RIGHT WING O/B MIDFLAP, O/B CARRIAGE SUPPORT FITTING CORRODED. MAINTENANCE REPAIRED IAW SRM 51-30-2.SDR UPS204222Flap Carriage · corrodedWHILE IN FOR C-CHECK, MAINTENANCE FOUND CORROSION ON NR 2 FLAP CARRIAGE INSIDE SPINDLE. MAINTENANCE REMOVED AND REPLACED THE SPINDLE.SDR UPS204221Flap Carriage · corrodedWHILE IN FOR C-CHECK, MAINTENANCE FOUND CORROSION ON NR 1 FLAP CARRIAGE INSIDE SPINDLE. MAINTENANCE REMOVED AND REPLACED THE FLAP CARRIAGE ASSY.SDR UPS204220Floorbeam · corrodedWHILE IN FOR C-CHECK, MAINTENANCE FOUND DOUBLE HOLES AND CORROSION ON FLOORBEAM AND NUTPLATE HOLES AT STA 480 RBL 25 TO 65 WL 208. MAINTENANCE REPAIRED IAW UPS EO B727-5310-7318A.SDR UPS204219Strap · corrodedWHILE IN FOR C-CHECK, MAINTENANCE FOUND CORROSION ON STABILIZATION STRAP ON BL 0 AT RBL 2 WL 199 13S 540, 600, 620. MAINTENANCE REMOVED CORROSION, FABRICATED REPAIR PARTS AND INSTALLED IAW SRM 53-10-1, 51-30-2.SDR UPS204218Blkhd Angle · corrodedWHILE IN FOR C-CHECK, MAINTENANCE FOUND CORROSION ON BULKHEAD ANGLE AT BS 680 LBL 25 TO RBL 25 OUT OF LIMITS. MAINTENANCE REMOVED ANGLE, FABRICATED AND INSTALLED NEW ANGLE. ALL WORK WAS DONE IAW SRM 53-10-1, 51-30-2, 51-10-1 AND MM 51-20-21, MM 51-20-151.SDR UPS204217Blkhd Angle · corrodedWHILE IN FOR C-CHECK, MAINTENANCE FOUND CORROSION ON BULKHEAD ANGLE AT BS 680 RBL 6 TO RBL 25 WL 19L. MAINTENANCE REMOVED ANGLE, FABRICATED AND INSTALLED NEW ANGLE IAW SRM 51-30-2, 51-10-1 AND MM 51-20-151, MM 51-20-21.SDR UPS204185Skin · corrodedWHILE IN FOR C-CHECK, MAINTENANCE FOUND R/W UPPER SKIN LOWER SURFACE CORRODED AT REAR SPAR CHORD WS 209. MAINTENANCE REPAIRED IAW EO 727-57-1426.SDR UPS204184Skin · corrodedWHILE IN FOR C-CHECK, MAINTENANCE FOUND CORROSION ON UPPER SURFACE OF LOWER FUEL CELL SKIN STA 743 TO 745 LBL 19 TO 45 WL 169. MAINTENANCE REPAIRED IAW SRM 57-30-1 AND EO 727-53-1649.SDR UPS204183Fitting · corrodedWHILE IN C-CHECK, MAINTENANCE FOUND A CRACK ON THE L/W I/B AILERON I/B BALANCE BAY RIB CHORD. MAINTENANCE FABRICATED NEW CHORD AND INSTALLED IAW SRM 51-30-2, 51-10-1 AND 51-10-2.SDR UPS204182Fitting · corrodedWHILE IN C-CHECK, MAINTENANCE FOUND CORROSION ON L/W O/B AILERON LOCKOUT SUPPORT FITTING ON UPPER SURFACE AROUND BOLT HOLE THAT ATTACHES TO QUADRANT. MAINTENANCE REMOVED AND REPLACED FITTING IAW SRM 51-10-6.SDR UPS204181Seat Track · corrodedWHILE IN C-CHECK, MAINTENANCE FOUND CORROSION ON THE SEAT TRACK FLANGE LBL 45 ON THE TOP STA 344-380, 560-640, ON BOTTOM STA 420-480 WL 208. MAINTENANCE REPAIRED THE SEAT TRACK IAW 51-30-02, 51-10-01, 51-30-08, 51-10-02 AND MM 51-20-15.SDR UPS204180Carriage Spindle · corrodedWHILE IN C-CHECK, MAINTENANCE FOUND CORROSION ON THE INSIDE SPINDLE ON NR 5 CARRIAGE. MAINTENANCE REMOVED AND REPLACED THE FLAP CARRIAGE IAW MM 27-51-03.SDR UPS204179Spar · corrodedWHILE IN C-CHECK, MAINTENANCE FOUND CORROSION ON LT WING UPPER REAR SPAR CHORD AT WS 221 INBD OF TRUNNION FITTING. MAINTENANCE REPAIRED IAW E.O. 95-2880.SDR UPS204178Spar · crackedWHILE IN C-CHECK, MAINTENANCE FOUND R/W I/B MIDFLAP LOWER AFT SPAR CHORD CRACKED AT I/B AFT FLAP DRUM ROD CUTOUT. MAINTENANCE REPAIRED IAW SRM 57-50-02, 57-10-1, 51-30-02.SDR UPS204177Floor Beam · corrodedWHILE IN C-CHECK, MAINTENANCE FOUND CORROSION ON THE FLOOR BEAM AROUND NUT PLATE HOLES STA 380 RBL 45-60 AND LBL 45-65, WL 208. MAINTENANCE FABRICATED AND INSTALLED NEW REPAIR STRAP AND ANGLE IAW E.O. B727-5310-7283A, SRM 51-10-6, 51-10-2, AND 51-30-2.
Back to N939UP, cancelled Aug 23, 2006