N940UP, cancelled Jul 11, 2008
Service difficulty reports · 208
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 = 'N940UP' AND deregistration_id = 'N940UP-2008-07-11' 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 = 'N940UP' AND deregistration_id = 'N940UP-2008-07-11' 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 UPS07250488Slide · out of positionINSPECTION TYPE:N/A CREW ENTRY ESCAPE SLIDE FELL OUT OF CASE. REPLACED ESCAPE SLIDE AS NEEDED, OKAY FOR SERVICE. REF M/M 25-60-14- 2.SDR UPS07250476Slide · out of positionINSPECTION TYPE:N/A CREW ENTRY ESCAPE SLIDE FELL OUT OF CASE. REPLACED ESCAPE SLIDE AS NEEDED. OKAY FOR SERVICE REF MM 25-60-14-2.SDR UPS07248848Battery · inoperativeCONTROL CABIN EMERGENCY LIGHTS FOUND TO BE INOP. REPLACED EMERGENCY LIGHT BATTERY IAW MM 33-50-01-2 AND 33-50-01-5. OPS CHECKED NORMAL.SDR UPS06247337Receptacle · dirtyUPON GEAR RETRACTION 3 RED GEAR WARNING LIGHTS ILLUMINATED. GEAR DOORS OPERATED NORMAL. GEAR WAS EXTENDED. THREE GREEN GEAR LIGHTS ILLUMINATED AND THE NOSE GEAR RED LIGHT REMAINED ON. GEAR WAS RETRACTED AND THE 3 RED GEAR WARNING. REMOVED LANDING GEAR MODSDR UPS06247282Seat Track · corrodedDURING REMOVAL OF FLOORBOARDS TO FACILITATE REPLACEMENT OF SEAT TRACK SECTION CORROSION FOUND ON FLOORBEAM UPPER CHORD AT BS 560 BETWEEN LBL 10 - LBL 50. CORROSION REMOVED IAW SRM 51-10-01. FOUND OUTSIDE LIMITS IAW SRM 51-10-1. HFEC CARRIED OUT ON BLENDED ASDR UPS06247273Rib · crackedNR 6 SLAT SUPPORT RIB CRACKED, ABOUT 9 INCHES FROM SLAT I/B END. REMOVED DAMAGE IAW SRM 51-10-01. HFEC CARRIED OUT AROUND CUTOUT IAW B7 27-NDTM 51-00-00 PT 6 FIG 4, NDF. REPAIR DOUBLER FORMED IAW SRM 57-50-3. NR 6 SLAT SUPPORT RIB CAD PLATING CARRIED OUT ISDR UPS06247210Rib · crackedINSPECTION TYPE:C NR 6 SLAT SUPPORT RIB CRACKED, ABOUT 9 INCHES FROM THE SLAT O/B END. REMOVED DAMAGE IAW SRM 51-10-1. HFEC CARRIED OUT AROUND CUTOUT IAW B72 7NDTM 51-00-00 PT 6 FIG 4. REPAIR DOUBLER FORMED IAW SRM 57-50-3. DRILLED AND SHAPED DOUBLER IAW SRSDR UPS06247207Rib · crackedINSPECTION TYPE:C NR 6 SLAT SUPPORT RIB CRACKED ABOUT 9 INCHES FROM SLAT I/B END. REMOVED DAMAGE IAW SRM 51-10-1. HFEC CARRIED OUT AROUND CUTOUT IAW B72 7NDTM 51-00-00 PT 6 FIG 4. SUPPORT RIB REPAIR DOUBLER FORMED IAW SRM 57--50-3. DOUBLER SHAPED AND DRILLSDR UPS06247277Bracket · crackedRIGHT WING T/E CAVITY NR 11 SPOILER I/B HINGE BRACKET ASSY, SUSPECT CRACK ON O/B BRACKET AT UPPER AFT CORNER. HFEC CARRIED OUT IAW B727-NDTM 51-00-00 PT6 FIG 4 CRACK CONFIRMED. REMOVED O/B HINGE BRACKET IAW SRM 51-30-02. FABRICATED BRACKET IAW SRM 51-20-01.SDR UPS06247283Skin · corrodedINSPECTION TYPE:C CORROSION ON RT WING TIP UPPER SURFACE AT O/B TRAILING EDGE STATIC DISCHARGER. STATIC DISCHARGER REMOVED IAW SRM 51-30-02. CORROSION REMOVED IAW SRM 51-10-06 AND FOUND OUT OF LIMITS. HFEC CARRIED OUT ON BLENDED AREA IAW B727-NDTM 51-00-00 SDR UPS06247285Intercostal · crackedINSPECTION TYPE:C NR 3 SLAT AT O/B TRACK ATTACHMENT TO SLAT, CRACK ON INTERCOSTAL. FASTENERS REMOVED IAW SRM 51-30-02 AND CRACK CUTOUT IAW SRM 57-50-03. O/B SLAT TRACK DISPLACED AT FWD ATTACHMENT AREA IAW OHM 57-51-51. REPAIR DOUBLER FABRICATED IAW SRM 57-5SDR UPS06247278Intercostal · crackedNR 3 SLAT AT O/B TRACK ATTACHMENT TO SLAT CRACK ON INTERCOSTAL. FASTENERS REMOVED IAW SRM 51-30-02 AND CRACK CUT OUT IAW SRM 57-50-03. REPAIR DOUBLER FABRICATED IAW SRM 57-50-03. CAD PLATING CARRIED IAW SO PM 20-42-10. REPAIR INSTALLED IAW SRM 57-50-03. FSDR UPS06247275Flange · crackedFOUND EVIDENCE OF CRACK ON LEFT BS 940 LOWER FWD FLANGE. FLANGE REPAIRED IAW AAAE EO 2006-037-007.SDR UPS06247276Bearing · failedNOSE WHEEL WILL NOT MANUALLY EXTEND. BEARINGS REPLACED IN CABLE DRUM IAW SOPM 20-50-03. DRUM REPLACED IAW MM 32-34-11. MANUAL EXTENSION SYSTEM ADJUSTED IAW MM 32-34-00. SYSTEM TESTED IAW AMM 32-34-00 AND RETURNED TO SERVICE.SDR UPS06247006Slide · deployedINSPECTION TYPE:N/A UPON ARRIVAL TO AIRCRAFT PARKED ON RAMP, FOUND L1 DOOR OPEN AND FOUND ESCAPE SLIDE ON RAMP. REMOVED AND REPLACED SLIDE AND COMPARTMENT WITH SERVICEABLE UNITS IAW MM 25-60-14.SDR UPS06246828Rod · brokenF/O SLIDING WINDOW (NR 2) LOCK RELEASE IS BROKEN. REPLACED OPEN WINDOW, RELEASE/LOCK ROD W/REF M/M 56-12-11-4 O/C GOOD W/REF MM 56-12-11-5.SDR UPS06246460Shim · looseRT WING O/B AILERON TAB DELAM DBLR LWR SURFACE. UPON INVESTIGATION FOUND DELAMINATION TO BE A SHIM THAT CAME LOOSE. STARTED REMOVAL OF AILERON BAL. TAB UP TO STEP D ON MM 27-10-19-4 REINSTALLED BOLTS IN TAB REDS AND INSTALLED COTTER PINS. RESECURED LOOSE SHSDR UPS06246058Battery · inoperativeEMERGENCY EXIT LIGHTS OVER COCKPIT DOOR AND MAIN ENTRY DOOR ARE INOP. REPLACED EMERGENCY LIGHT BATTERY AS PER MM 33-50-90-2.SDR UPS05243707Skin · crackedINSPECTION TYPE: C, LE SLAT ACCESS PANEL (NR 6 SLAT) HAS 1/2 INCH CRACK ON SKIN. REPAIR CARRIED OUT IAW SRM 51-10-01, 51-40-02 AND 51-30-02.SDR UPS05243700Bracket · crackedINSPECTION TYPE: C, NR 5 FLAP TRACK, FWD O/B FAIRING ATTACH ANGLE BRACKET IS CRACKED. BRACKET REPLACED IAW SRM 51-20-1.SDR UPS05243684Fitting · crackedINSPECTION TYPE:C SUSPECT CRACK ON CLEAT AT STR 28L ON FWD SIDE OF BS 1070 AFT CARGO BAY. HFEC CARRIED OUT IAW NDTM 51-00-00 FIG 4. RESULT CRACK CONFIRMED. REMOVED CRACKED CLEAT, FABRICATED AND INSTALLED NEW CLEAT IAW SRM 51-20-1.SDR UPS05243683Fitting · crackedINSPECTION TYPE:C, SUSPECT CRACK ON CLEAT AT STR 29L ON FWD SIDE OF BS 1110 AFT CARGO BAY. HFEC CARRIED OUT IAW NDTM 51-00-00 FIG 4. CRACK CONFIRMED. REMOVED CRACKED CLEAT, FABRICATED AND INSTALLED NEW CLEAT IAW SRM 51-30-02.SDR UPS05243762Door · corrodedINSPECTION TYPE:C, CORROSION FOUND AT TAIL SKID DOOR UPPER ATTACH POINTS BS 1183 S 28L + 28R. ON REMOVAL OF PANEL IT WAS FOUND TO BE CORRODED BEYOND LIMITS IAW 53-30-1. NEW PANEL FABRICATED IAW SRM 51-20-1. TAIL SKID MOUNTING CASTING SHOW SIGNS OF WEAR. NESDR UPS05243685Hinge · crackedINSPECTION TYPE:C, LEFT O/B AILERON O/B BALANCE PANEL FWD IDLER HINGE CRACKED. HINGE REPLACED IAW 51-30-2.SDR UPS05243774Skin · corrodedINSPECTION TYPE:C, AREA OF LITE SURFACE CORROSION ON SKIN BELOW S4L AT BS 1183. CORROSION FOUND TO BE RUNNING UNDER LAP. FURTHER RECTIFICATION CARRIED OUT IAW UPS EO B727-5330-0509.SDR UPS05243763Structure · crackedINSPECTION TYPE:C, SUSPECT CRACK ON LT CHORD ABOVE NR 2 ENGINE HORIZONTAL FIREWALL AT UPPER END OF CHORD. HFEC CARRIED OUT IAW NDTM PART 6 51-00-00, FIG 4. CRACK FOUND TO BE 5.0 INCH IN LENGTH. CHORD REMOVED AND NEW CHORD DRILLED OFF AND INSTALLED IAW SRM 5SDR UPS05243702Support Angle · crackedINSPECTION TYPE: C, NR 3 FLAP TRACK FAIRING SUPPORT ANGLE CRACKED AT I/B AFT END. FAIRING SUPPORT ANGLE REPAIRED IAW SRM 51-20-01.SDR UPS05243701Support Angle · crackedINSPECTION TYPE: C, NR 4 FLAP TRACK FAIRING SUPPORT ANGLE CRACKED AT O/B SIDE AT MLG BEAM. FAIRING SUPPORT ANGLE REPAIRED IAW SRM 51-20-1.SDR UPS05243698Rib · crackedINSPECTION TYPE: C, NR 8 LE SLAT STRUCTURE HAS CRACKED RIB JUST O/B OF ACTUATOR ATTACH POINT. REPAIR CARRIED OUT IAW SRM 57-50-03.SDR UPS05243697Rib · crackedINSPECTION TYPE:C NR 5 LE SLAT STRUCTURE HAS THREE RIBS CRACKED BETWEEN O/B TRACK AND O/B EDGE OF SLAT. REPAIRED CRACKED RIBS 3 PLACES AT NR 5 LE SLAT IAW SRM 57-50-03 FIG 9.SDR UPS05243687Hook · crackedINSPECTION TYPE:C SUSPECT CRACK ON NR 2 SLAT O/B HOOK UPPER FASTENER. HFEC CARRIED OUT IAW NDTM 51-00-00 FIG 4. RESULT - CRACK CONFIRMED. REPAIR CARRIED OUT IAW SRM 57-50-3 FIG 10.SDR UPS05243792Pressure Panel · crackedINSPECTION TYPE:C, NLG WHEEL WELL HAS 3 SUSPECT CRACKS AT RT AFT PRESSURE PANEL CUTOUT. TWO AT LWR FWD CORNER AND ONE NEAR UPPER AFT CORNER. REPAIR CARRIED OUT IAW AAAE EO 2005-001-004.SDR UPS05243783Web · crackedINSPECTION TYPE:C, RT VENTRAL STAIRWAY TORQUE BOX WEB SKIN CRACK EXTENDING BEYOND STOP DRILL HOLE ON FWD O/B END ADJACENT TO FUEL SHROUD HOLE & CRACK ON DOUBLER AT AFT SIDE BS 1263. REPAIR CARRIED OUT IAW EO B727-5310-1239-E.SDR UPS05243769Door · corrodedINSPECTION TYPE:C, NLG LT FWD DOOR HAS EVIDENCE OF CORROSION UNDER SEAL RETAINER. LT NLG DOOR REMOVED AND REPLACED IAW AMM 32-22-01.SDR UPS05243768Bushing · corrodedINSPECTION TYPE:C, ENGINE NR 3 FWD MOUNT FITTING HAS PITTING CORROSION IN BOTH O/B (LARGE) HOLES. FWD O/B HOLE BUSHING REMOVED OHM 20-50-03. HFEC CARRIED OUT IAW NDTM 51-00-00 FIG 13, NO DEFECTS FOUND. REPAIRED IAW UPS EO B727-5440-11592-A.SDR UPS05243766Bushing · corrodedINSPECTION TYPE:C, ENGINE NR 1 FWD MOUNT FITTING HAS PITTING CORROSION IN ALL MOUNT HOLES. AFT O/B HOLE CORRODED BUSHING REMOVED IAW OHM 20-50-03. HFEC CARRIED OUT IAW NDTM 51-00-00 FIG 13, NO DEFECTS FOUND. REPAIRED IAW UPS EO B727-5440-11592-A.SDR UPS05243699Tab · delaminatedINSPECTION TYPE: C, LT O/B AILERON TAB DELAMINATED AT UPPER I/B END. AILERON TAB REPAIRED IAW SRM 51-40-20.SDR UPS05243686Bracket · crackedINSPECTION TYPE:C, NR 1 KRUEGER FLAP TRUNNION BRACKET IS CRACKED ON O/B SIDE. BRACKET REPLACED IAW DRG 65-16275.SDR UPS05243791Skin · crackedINSPECTION TYPE:C SUSPECT CORROSION BETWEEN SKIN AND INTERNAL STRUCTURE BS 294 BETWEEN S18R + S19R ON CLOSER INSPECTION CORROSION FOUND TO BE WELL WITHIN LIMITS IAW SRM 53-30-01. A SMALL CRACK WAS FOUND COMING FROM A FASTENER HOLE. AREA CUT OUT IAW SRM 53-30SDR UPS05243710Casting · corrodedINSPECTION TYPE:C, NR 3 KRUEGER FLAP INBOARD HINGE, FIXED LEADING EDGE CASTING HAS EVIDENCE OF INTERGRANULAR CORROSION. REPLACED AND INSTALLED NEW CASTING IAW DRG 64-8343.SDR UPS05243777Panel · delaminatedINSPECTION TYPE:C, ENGINE NR 1 PYLON PANEL 5408 IS DELAMINATED INNER SURFACE FWD END. PANEL REPAIRED IAW SRM 51-40-20.SDR UPS05243776Panel · delaminatedINSPECTION TYPE:C, ENGINE NR 3 PYLON PANEL 5508 IS DELAMINATED INNER SURFACE FWD END. PANEL REPAIRED IAW MM 20-60-04.SDR UPS04243588Battery Pack · inoperativeFORWARD ENTRY EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED BATTERY PACK. OPS CHECK GOOD.SDR UPS04243559Valve · stuckCAPT O2 MASK HAS STUCK VALVE. REPLACED MASK ASSY, OPS CK NORMAL.SDR UPS04243352Control Unit · malfunctionedWHEN F/O TURNED OFF F/D ALTITUDE HOLD, RECEIVED AN INTERMITTENT FIRE WARNING. THE F/O TAPPED THE GLARE SHIELD AND THE FIRE WARNING LIGHT AND BELL CAME ON STEADY. ENGINE NR 3 WAS SHUTDOWN IAW PROCEDURES AND UNEVENTFUL. SIMULATED CREW ACTION BY TAPPING ONSDR UPS04242309A/C Pack · overtempJUST AFTER T/O COCKPIT FILLED WITH FUMES, RIGHT PACK TEMP WAS 170'. TURNED OFF PAC FUMES STOPPED. ALL C/B'S CHECKED & IN PAC FAN OPS NORMAL. R/R 35 FT CONTROL VALVE PER AMM 21-51-42, OPS CHECK GOOD.SDR UPS03240919Buss Tie · corrodedINSPECTION TYPE: C&SI, RT I/B AILERON BUS QUADRANT CORRODED IN CABLE GROOVE. RIGHT I/B AILERON BUS QUADRANT REPLACED AS REQUIRED UP TO STEP D6 INCLUSIVE IAW MM 27-10-56.SDR UPS03240920Hinge · crackedINSPECTION TYPE: C, LT O/B AILERON I/B BALANCE BAY FWD PANEL IDLER HINGE CRACKED & BROKEN. REPLACED LT O/B AILERON I/B BALANCE BAY FWD PANEL IDLER HINGE IAW MM 27-10-04 & ON REMOVAL OF HINGE, PIN FOUND TO BE DAMAGED, PIN REPLACED IAW MM 27-10-04.SDR UPS03240966Stiffener · corrodedINSPECTION TYPE:C CORROSION ON LT 870 MID SECTION ATTACHMENT TO BULKHEAD STIFFENER REPAIR CARRIED OUT IAW SRMO EO 2003-038-006 SRM 51-30-02, UPS EO B72 7-5310-3056 AND DRAWING 65C23231 UPS ENG. FILE NO. 727-53-20118SDR UPS03240948Sill · crackedINSPECTION TYPE: C CRACKS ON LT SILL IN NLG WHEEL WELL AT FWD END AND THE 6TH RIVET FROM FWD. HFEC TO CONFIRM CRACK. CUTOUT MADE AND STOP DRILLED, REPAIRED IAW SRM 51-40-02.
Back to N940UP, cancelled Jul 11, 2008