N797UP, cancelled Dec 13, 2012

Service difficulty reports · 195

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 = 'N797UP' AND deregistration_id = 'N797UP-2012-12-13'
  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.

SDR UPS01835648Fitting · crackedINSPECTION TYPE:C2,3 STA. 280 BANANA FITTING IS CRACKED AT LONG. 33R REMOVED AND REPLACED FITTING I.A.W. DWG.3755827,AND SRM. 51-1-20DMar 27, 2001 · N797UP · Doug DC871F · Fuselage Main, Attach FittingsSDR UPS01835646Fitting · crackedINSPECTION TYPE:C2,3 STA. 280 LOWER FLOORBEAM TO CUSP FITTING IS CRACKED AT LONG. 21R REMOVED AND REPLACED FITTING I.A.W. DWG. 9754022,AND SRM. 51-1-20D,& 51-1-21Mar 26, 2001 · N797UP · Doug DC871F · Fuselage Miscellaneous StructureSDR UPS01835772Doubler · crackedINSPECTION TYPE:C2,3 RIGHT WING L/E. INTERNAL WRAPAROUND DOUBLER IS CRACKED AT XFS 297.5 REMOVED,FABRICATED,AND REPLACED DOUBLER I.A.W. DWG. 5769589,AND SRM. 51-1-21,51-1-20DJan 1, 2001 · N797UP · Doug DC871F · Wing, Plate/SkinSDR UPS99831032Skin · crackedINSPECTION TYPE:SV, FWD LWR NOSE SKIN CREASED AND TORN STA -85 TO -80 L31L TO 28L CRACKED APRROX 15.0. REMOVED DAMAGE SECTION OF SKIN, FABBED DOUBLER, FILLER AND SPLICE DOUBLER IAW REO-06778, INSTALLED DOUBLER, FILLER AND SPLICE DOUBLER IAW DC8 SRM 51-1-20D, Oct 25, 1999 · N797UP · Doug DC871F · Fuselage Main, Plate/SkinSDR UPS99831031Skin · crackedINSPECTION TYPE:SV, FWD LWR NOSE SKIN CREASE AND TORN STA -99 TO-93, L31R TO L28R. REMOVED DAMAGED SECTION OF SKIN AND DAMAGED FRAME, FABRICATED NEW SKIN SECTION AND DOUBLERS IAW REO -06765, LOCATED NEW FRAME SKIN SECTION AND DOUBLERS, DRILLED UP IAW DC8 SRM Oct 25, 1999 · N797UP · Doug DC871F · Fuselage Main, Plate/SkinSDR UPS99830977Frame · crackedINSPECTION TYPE:S/V, STA-117 FRAME CRACKED AT BOTTOM FWD OF NOSE GEAR. FABBED AND INSTALLED REPAIR IAW REA-O6756 DYE PENNED REPAIR PARTS IAW ASTM-E-7417-95A. NO CRACKS NOTED IAW DC8 SRM 51-1-20D.Sep 8, 1999 · N797UP · Doug DC871F · Fuselage Main, FrameSDR UPS99830976Frame · crackedINSPECTION TYPE:S/V STA-105 FRAME CRACKED BOTTOM FWD OF NOSE. FAB REPAIR ANGLES AND FILLERS IAW REO 06767 DYE PENNED REPAIR PARTS IAW MIL STD 15378, NO CRACKS NOTED ALODINED AND PRIMED IAW DC8 SRM 51-1-8. INSTALLED IAW DC 8 51-1-20D.Sep 8, 1999 · N797UP · Doug DC871F · Fuselage Main, FrameSDR UPS99830870Doubler · corrodedINSPECTION TYPE:SV STA 8 TO 70 FINGER DOUBLER RT SIDE HAS CORROSION. REMOVED AND REPLACED FINGER DOUBLER IAW DC8 SRM 51-1-21, 53-3-1.Sep 8, 1999 · N797UP · Doug DC871F · Fuselage Miscellaneous StructureSDR UPS99830944Frame · damagedINSPECTION TYPE:SV, FUSELAGE FRAME AT STA 80 LT O/B NOSE WHEEL WELL IS DAMAGED. REC'D SERVICEABLE FRAME SECTION FROM AIRCRAFT (S/N 46038), HEAT TREATED REPAIRS DOUBLERS 7075-0--063 TO 7075-T6 IAW TPS 1003 REV A. FABBED DOUBLERS IAW REO 06791. DYE PENT REPAISep 7, 1999 · N797UP · Doug DC871F · Fuselage Main, FrameSDR UPS99831047Structure · damagedINSPECTION TYPE:N/A, FUSELAGE NOSE SECTION, INTERM, REPAIR EO DC8 5300-11498A TO INCLUDE REMOVAL OF NOSE LANDING GEAR DOORS, BOTH PAC'S INOP (REF DEFERRAL M- 177745) RT PNEUMATIC PRESSURE INDICATION INOP (REF DEFERRAL M-177744 ) REF INCIDENT NUMBER RS99-288. Aug 29, 1999 · N797UP · Doug DC871F · Fuselage Main, StructureSDR UPS99830489Cowl · damagedINSPECTION TYPE:N/A, NR 3 ENG FAN COWL (O/B) DAMAGED WHEN NOSE GEAR COLLAPSED, SEE LOG PAGE 208929 ITEMS 1 AND 2. OPENED COWL TRANSFERRED TO UPS NON-ROUTINE 544690.Aug 28, 1999 · N797UP · Doug DC871F · Engine Cowling SystemSDR UPS99830946Frame · damagedINSPECTION TYPE:SV 2 FRAME DAMAGED AT -87 RT O/B OF NWW. REC'D SERVICEABLE FRAME SECTION FROM A/C (S/N 46038). HEAT TREATED REPAIR PARTS 7075-0 TO 7075 T6.063 IAW TPS-1003 REV A. INSTALLED SERVICEABLE FRAME SECTION IAW DC8 SRM 51-1-20D & 51-1-21. FABBED ANAug 20, 1999 · N797UP · Doug DC871F · Fuselage Main, FrameSDR UPS99830945Frame · damagedINSPECTION TYPE:SV 2 FRAME DAMAGED AT -87 LEFT O/B NWW. FABBED AND INSTALLED FRAME AND REPAIR PARTS (SPLICES) IAW REO 06776 & DC8 SRM 51-1-20D.Aug 20, 1999 · N797UP · Doug DC871F · Fuselage Main, FrameSDR UPS99830464Landing Gear · collapsedINSPECTION TYPE:N/A, AFTER LANDING AND COMING TO A STOP ON RUNWAY 32R, THE NOSE GEAR COLLAPSED INTO THE WHEEL WELL. *S/D* ALL REQUIRED EO'S IE DC8-5300-11498A HAVE BEEN C/W BY TIMCO. PER FERRY FLIGHT PERMIT NR 9086 ALL FERRY FLIGHT PROCEDURES HAVE BEEN ACCOAug 17, 1999 · N797UP · Doug DC871F · Nose/Tail Landing GearSDR UPS99830353Girt Bar · failedINSPECTION TYPE:N/A, ESCAPE SLIDE GIRT BAR RETAINER FAILED UPON EGRESS OF A/C, SLIDE SEPARATED FROM A/C. STILL I/W ON LOG PAGE 208929/2. FOLLOW UP ACTION SCHEDULED FOR REMAINDER OF DC-8 FLEET. *S/D* INSTALLED HARDWARE IAW EO DC-8-2560-11700, OPS CK NORMAL Aug 17, 1999 · N797UP · Doug DC871F · Emergency EquipmentSDR UPS99829571Bulb · failedINSPECTION TYPE:N/A, ON FINAL APPROACH LOWERED LANDING GEAR, RT MAIN GREEN LIGHT DID NOT ILLUMINATE. CYCLED GEAR, SAME INDICATION. ALSO, RED NOT LATCHED LIGHTS DID NOT ILLUMINATE. AFTER MISSED APPROACH RAISED GEAR, REPLACED BULBS, LOWERED GEAR, RT MAIN ILLUMay 13, 1999 · N797UP · Doug DC871F · Landing Gear Position and WarningSDR UPS99829380Wire · failedCOCKPIT DOME LIGHT DOSE NOT ILLUMINATE ON PREFLIGHT CHECK OF EMERGENCY LIGHTS DETERMINED 3 EACH PWR WIRES ARE INOP AT JUNCTION. REF WDM 33-50-01 REPAIRED WIRES, OPS CHECK GOOD.Apr 22, 1999 · N797UP · Doug DC871F · Light System WiringSDR UPS99829295Fitting · crackedINSPECTION TYPE:C1 RT FWD TYPE 1 DOOR LOWER AFT FRAME FITTING IS CRACKED. REMOVED, FABRICATED AND REPLACED FITTING IAW DWG 3888406 AND SRM 51-1-20D.Apr 6, 1999 · N797UP · Doug DC871F · Fuselage Miscellaneous StructureSDR UPS99829293Fitting · crackedINSPECTION TYPE:C1 WING STA XRS74.0, THE STR 51 END FITTING IS CRACKED (LT WING). REMOVED AND REPLACED FWD AND AFT END FITTINGS IAW DWG 3704841 AND SRM 51-1-20D.Apr 6, 1999 · N797UP · Doug DC871F · Wing Miscellaneous StructureSDR UPS99829288Fitting · crackedINSPECTION TYPE:C1 RT WING, THE STRINGER 51 END FITTING AT STA XRS74.00 IS CRACKED. REMOVED AND REPLACED FITTING IAW DWG 3704841 AND SRM 51-1-20D.Apr 6, 1999 · N797UP · Doug DC871F · Wing Miscellaneous StructureSDR UPS99829302Skin · corrodedINSPECTION TYPE:C1 STA 1030 AT STR 19L, THE EXTERNAL SKIN HAS HEAVY CORROSION. REPAIRED AREA IAW DH SK797-045.Apr 3, 1999 · N797UP · Doug DC871F · Fuselage Main, Plate/SkinSDR UPS99829187Skin · corrodedINSPECTION TYPE-C1, RT WING L/E SKIN HAS HEAVY CORROSION AT STA XFS 341. REPAIRED AREA IAW SRM 57-3-1.Apr 2, 1999 · N797UP · Doug DC871F · Wing, Plate/SkinSDR UPS99829203Rib · crackedINSPECTION TYPE-C1, RT WING L/E RIBS AT THE FOLLOWING STA'S ARE CRACKED: FS 467.323, FS 442.185, XOLDI6.225, FS 366.500, FS 360.250 AND FS 354. STOP DRILLED CRACK'S AND REPAIRED IAW SRM 57-2-0 FIG 2.Apr 1, 1999 · N797UP · Doug DC871F · Wing, Rib/BulkheadSDR UPS99829178Fitting · corrodedINSPECTION TYPE-C1, STA 270 AT LONG 30R, THE SUPPORT FITTING HAS HEAVY CORROSION. REMOVED, FABRICATED AND REPLACED SUPPORT FITTING IAW DWG 3754916 AND SRM 51-1-20D.Apr 1, 1999 · N797UP · Doug DC871F · Fuselage Miscellaneous StructureSDR UPS99829298Seat Track · corrodedINSPECTION TYPE:C1, SEAT TRACK AT STA 1400, LBL58 HAS HEAVY CORROSION. SPLICED TRACK FROM STA 1370-1430 BLB58 IAW SRM 53-2-3.Mar 30, 1999 · N797UP · Doug DC871F · Fuselage, Seat/Cargo Attach FittingsSDR UPS99829301Frame · corrodedINSPECTION TYPE:C1 STA 1380 AT STR 19L, THE FRAME HAS HEAVY CORROSION. REPAIRED FRAME IAW DH SK797-464.Mar 29, 1999 · N797UP · Doug DC871F · Fuselage Main, FrameSDR UPS99829291Frame · corrodedINSPECTION TYPE:C1 STA 1100 BTWN STR 10L-11L, THE FRAME IS CORRODED OUT OF LIMITS. REPAIRED AREA IAW SRM 53-2-0 FIG 2.Mar 29, 1999 · N797UP · Doug DC871F · Fuselage Main, FrameSDR UPS99829161Rib · crackedINSPECTION TYPE:C1 LEFT WING L/E RIB AT STA XFS 634.000 IS CRACKED AT THE AFT END. STOP DRILLED CRACK AND REPAIRED IAW SRM 57-2-0 FIG 2.Mar 27, 1999 · N797UP · Doug DC871F · Wing, Rib/BulkheadSDR UPS99829157Rib · crackedINSPECTION TYPE:C1 LEFT WING L/E AT STA XFS640.00, THE L/E RIB IS CRACKED AT THE AFT END. STOP DRILLED CRACK AND REPAIRED IAW SRM 57-2-0 FIG 2.Mar 27, 1999 · N797UP · Doug DC871F · Wing, Rib/BulkheadSDR UPS99829299Fitting · corrodedINSPECTION TYPE:C1 RT WHEEL WELL AT STA 960 AND LONGERON 24R, THE FITTING ABOVE THE LONGERON IS CORRODED. REMOVED AND REPLACED FITTING IAW DWG 3647117 AND SRM 51-1-20D.Mar 25, 1999 · N797UP · Doug DC871F · Fuselage Miscellaneous StructureSDR UPS99829289Frame · crackedINSPECTION TYPE:C1 STA 55 FRAME AT STR 24L IS CRACKED. REPAIRED AREA IAW SRM 53-2-0 FIG 2.Mar 25, 1999 · N797UP · Doug DC871F · Fuselage Main, FrameSDR UPS99829192Fitting · crackedINSPECTION TYPE-C1, STA 1220 AT STR 27L, THE DOOR OPEN STOP/FRAME FITTING IS CRACKED. REMOVED AND REPLACED FITTING IAW DWG 3755854 AND SRM 51-1-20D.Mar 25, 1999 · N797UP · Doug DC871F · Fuselage Miscellaneous StructureSDR UPS99829188Fitting · crackedINSPECTION TYPE-C1, STA 1180 AT STR 27L, THE DOOR OPEN STOP/FRAME FITTING IS CRACKED. REMOVED, FABRICATED AND REPLACED FITTING IAW DWG 3755854 AND SRM 51-1-21.Mar 25, 1999 · N797UP · Doug DC871F · Fuselage Miscellaneous StructureSDR UPS99829198Fitting · crackedINSPECTION TYPE-C1, STA 390 AT STR 31L, THE SPLICE FITTING IS CRACKED. REMOVED AND REPLACED FITTING IAW DWG 3754473 AND SRM 51-1-20D.Mar 24, 1999 · N797UP · Doug DC871F · Fuselage Miscellaneous StructureSDR UPS99829191Fitting · crackedINSPECTION TYPE-C1, STA 1020 TO 1040 STR 31L SPLICE FITTING IS CRACKED. REMOVED AND REPLACED FITTING IAW DWG 3750257 AND SRM 51-1-20D.Mar 24, 1999 · N797UP · Doug DC871F · Fuselage Miscellaneous StructureSDR UPS99829185Longeron · crackedINSPECTION TYPE-C1, STA 260, LONGERON 35L IS CRACKED ON TOP. REPAIRED AREA BY SPLICING IAW SRM 53-2-2 FIG 10.Mar 24, 1999 · N797UP · Doug DC871F · Fuselage Main, Longeron/StringerSDR UPS99829166Shear Tie · crackedINSPECTION TYPE:C1 STA 1420 AT STR 21L-25L, THE SHEAR TIE FITTING IS CRACKED. REMOVED, FABRICATED AND REPLACED FITTING (SHEAR TIE) IAW DWG 5641015 AND SRM 51-1-20D.Mar 24, 1999 · N797UP · Doug DC871F · Fuselage Miscellaneous StructureSDR UPS99829160Fitting · corrodedINSPECTION TYPE:C1 STA 75 AT STR 31R, THE STR END FITTING HAS HEAVY CORROSION. REMOVED AND REPLACED FITTING IAW DWG 4614397 AND SRM 51-1-20D.Mar 24, 1999 · N797UP · Doug DC871F · Fuselage Miscellaneous StructureSDR UPS99829154Fitting · crackedINSPECTION TYPE:C1 STA 1040-1060, THE STR 31R SPLICE FITTING IS CRACKED. REMOVED AND REPLACED FITTING IAW DWG 3750257 AND SRM 51-1-20D.Mar 24, 1999 · N797UP · Doug DC871F · Fuselage Miscellaneous StructureSDR UPS99829300Skin · crackedINSPECTION TYPE:C1 RUDDER SKIN IS CRACKED IN 2 PLACES LEFT SIDE JUST ABOVE THE TAB. REMOVED AND REPLACED RUDDER ASSY IAW MM 27-21-01.Mar 23, 1999 · N797UP · Doug DC871F · Rudder, Plate/SkinSDR UPS99829179Skin · corrodedINSPECTION TYPE-C1, RT HORIZ STAB L/E SKIN AT MID SPAN HAS HEAVY CORROSION UNDER THE SURFACE. REPAIRED AREA IAW SRM 55-2-1 FIG 4.Mar 23, 1999 · N797UP · Doug DC871F · Horizontal Stabilizer, Plate/SkinSDR UPS99829175Fitting · crackedINSPECTION TYPE-C1, STA 680 AT LONG 11L, THE LONGERON END FITTING IS CRACKED. REMOVED AND REPLACED FITTING IAW DWG 4751625 AND SRM 51-1-20D.Mar 23, 1999 · N797UP · Doug DC871F · Fuselage Miscellaneous StructureSDR UPS99829303Aux Tank · corrodedINSPECTION TYPE:C1 LEFT WING AUX TANK AT STA XFS 1.250 HAS HEAVY CORROSION. REPAIRED AREA IAW SRM 57-2-1 FIG 38.Mar 22, 1999 · N797UP · Doug DC871F · Fuel StorageSDR UPS99829297Doubler · crackedINSPECTION TYPE:C1, RT WING L/E LWR SKIN INTERNAL DOUBLER IS CRACKED FWD OF ACCESS PANEL 524B. REMOVED, FABRICATED AND REPLACED DOUBLER IAW DWG 5641252 AND SRM 51-1-21.Mar 22, 1999 · N797UP · Doug DC871F · Wing Miscellaneous StructureSDR UPS99829296Skin · crackedINSPECTION TYPE:C1, NR 1 STUB LWR SKIN IS CRACKED AT STA XFS533.375 AND XOLDO57.500. REPAIRED AREA IAW SRM 57-2-1A.Mar 22, 1999 · N797UP · Doug DC871F · Wing, Plate/SkinSDR UPS99829294Rib · crackedINSPECTION TYPE:C1, RT WING L/E RIB AT STA XS 250.089 IS CRACKED. REPAIRED AREA IAW SRM 57-3-0.Mar 22, 1999 · N797UP · Doug DC871F · Wing, Rib/BulkheadSDR UPS99829292Fitting · crackedINSPECTION TYPE:C1 STA 270 AT STR 30R-31R, THE DOOR JAMB FRAME FITTING IS CRACKED. REMOVED AND REPLACED FITTING IAW DWG 3755827-501 AND SRM 51-1-20D.Mar 22, 1999 · N797UP · Doug DC871F · Fuselage Miscellaneous StructureSDR UPS99829290Skin · crackedINSPECTION TYPE:C1 LEFT WING L/E SKIN AT STA XW257.000 IS CRACKED AT THE I/B END. REPAIRED AREA IAW DC8-5720-7767.Mar 22, 1999 · N797UP · Doug DC871F · Wing, Plate/SkinSDR UPS99829287Rib · crackedINSPECTION TYPE:C1 LEFT WING L/E RIB AT STA XS250.089 IS CRACKED AT THE UPPER END. STOP DRILLED CRACK AND REPAIRED IAW SRM 57-2-0 FIG 2.Mar 22, 1999 · N797UP · Doug DC871F · Wing, Rib/BulkheadSDR UPS99829202Seat Track · corrodedINSPECTION TYPE-C1, MAIN CABIN AT STA 1140 AND RBL 48, THE SEAT TRACK HAS HEAVY CORROSION. REMOVED AND REPLACED SEAT TRACK FROM STA 1050 TO 1190 AT RBL 48 IAW SRM 53-2-3.Mar 22, 1999 · N797UP · Doug DC871F · Fuselage, Seat/Cargo Attach Fittings
Back to N797UP, cancelled Dec 13, 2012