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.
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
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 UPS96805881Fitting · corrodedWHILE IN FOR C-CHECK, MAINTENANCE REPORTED HEAVY CORROSION ON FITTING, FWD SIDE OF FS 1680 LONG 31R. REPLACED FITTING PER SRM 51-1-20D.SDR UPS96805906Fitting · crackedWHILE IN FOR C-CHECK, MAINTENANCE REPORTED LONGERON 35L SPLICE FITTING CRACKED AT FS 1270. REPLACED FITTING PER SRM 51-1-20D.SDR UPS96805905Fitting · crackedWHILE IN FOR C-CHECK, MAINTENANCE REPORTED LONGERON 34L SPLICE FITTING CRACKED AT FS 1270. REPLACED FITTING PER SRM 51-1-20D.SDR UPS96805902Fitting · crackedWHILE IN FOR C-CHECK, MAINTENANCE REPORTED LONGERON 31L SPLICE FITTING CRACKS AT FS 1290. REPLACED FITTING PER SRM 51-1-20D.SDR UPS96805962Bolts · corrodedWHILE IN FOR C-CHECK, MAINTENANCE REPORTED MCD SPOOL BOLTS 1, 2, 4, 5, 6 AND 7 ARE CORRODED. REPLACED BOLTS PER MM 52-36-01 (T/C 420269).SDR UPS96805880Fitting · corrodedWHILE IN FOR C-CHECK, MAINTENANCE REPORTED MODERATE CORROSION ON FITTING FS 1228 LONG 27 TO 28L. REPLACED FITTING PER SRM 51-1-20D.SDR UPS96805879Fitting · corrodedWHILE IN FOR C-CHECK, MAINTENANCE REPORTED MODERATE CORROSION LONGERON FITTING. REPLACED FITTING PER SRM 53-2-0 AND 51-1-20D.SDR UPS96805878Frame · corrodedWHILE IN FOR C-CHECK, MAINTENANCE REPORTED HEAVY CORROSION ON FWD SIDE OF FRAME FS 1360 ABOVE LONG 36. REPAIRED FRAME PER SRM 53-2-0, FIG 2.SDR UPS96805877Fitting · corrosionWHILE IN FOR C-CHECK, MAINTENANCE REPORTED HEAVY CORROSION ON CORNER FITTING FS 1394 INSIDE LONG FWD TORQUE BOX HOLE. REPLACED FITTING PER SRM 51-1-20D.SDR UPS96805876Longeron · corrodedWHILE IN FOR C-CHECK, MAINTENANCE REPORTED HEAVY CORROSION ON LONGERON 34L FS 1380 TO 1400 FS 1520 TO 540. REPLACED LONGERON SECTION PER SRM 51-2-2.SDR UPS96805875Splice · corrodedWHILE IN FOR C-CHECK, MAINTENANCE REPORTED MODERATE CORROSION DAMAGE AT SPLICE LONG 31L BETWEEN FS 1520 TO 1540. REPLACED SPLICE PER SRM 51-1-20D.SDR UPS96805870Doubler · corrosionWHILE IN FOR C-CHECK, MAINTENANCE REPORTED HEAVY CORROSION ON INNER DOUBLER BETWEEN LONG 31L TO 33R FS 1227 TO 1264. REPLACED PER EO DC8-53-1599.SDR UPS96805966Doubler · corrodedWHILE IN FOR C-CHECK, MAINTENANCE REPORTED HEAVY CORROSION ON FWD PRESS BULKHEAD RADIUS DOUBLER, FS 980 LONG 36. REPLACED RADIUS DOUBLER PER SRM 51-3-0.SDR UPS96805865Angle · corrodedWHILE IN FOR C-CHECK, MAINTENANCE REPORTED CORROSION ON LOWER SUPPORT ANGLE UNDER SEAT TRACK NR 7 FS 781 TO 759. REPAIRED PER UPS EO.SDR UPS96805863Floor Beam · crackedWHILE IN FOR C-CHECK, MAINTENANCE REPORTED CORROSION AND CRACK AT FWD BEAM, FS 920 LBL 65 AFT SIDE. REPAIRED PER UPS EO.SDR UPS96805861Seat Track · corrosionWHILE IN FOR C-CHECK, MAINTENANCE REPORTED HEAVY CORROSION ON MAIN CABIN SEAT TRACK NR 5 AROUND FLOOR BEAM ATTACH HOLES FS 759-822, RBL 22. REPLACED TRACK SECTION PER SRM 53-2-3.SDR UPS96805860Seat Track · corrosionWHILE IN FOR C-CHECK, MAINTENANCE REPORTED SEAT TRACK NR 1 HAS CORROSION DAMAGE AND CRACKS AT FS 759-781, LBL 55. REPLACED TRACK SECTION PER SRM 53-2-3.SDR UPS96805859Angle · corrosionWHILE IN FOR C-CHECK, MAINTENANCE REPORTED CORROSION DAMAGE ON LOWER ATTACH ANGLE UNDER MAIN CABIN SEAT TRACK NR 4, FS 702, BL ZERO. SPLICED ANGLE PER SRM 53-2-0.SDR UPS96805858Skin · corrosionWHILE IN FOR C-CHECK, MAINTENANCE REPORTED CORROSION DAMAGE ON FUSELAGE INNER SKIN, STA 1600-1680, LONGERONS 21R-31R. REPLACED SECTION PER SRM 51-1-21.SDR UPS96805896Spar · crackedWHILE IN FOR C-CHECK, MAINTENANCE REPORTED RT WING REAR SPAR AT WW IS CRACKED AT LOWER HORIZONTAL CAP RBL 30 FS 857. REPAIRED PER UPS EO DC8-5710-8088A.SDR UPS96805874Attach Angle · corrodedWHILE IN FOR C-CHECK, MAINTENANCE REPORTED HEAVY INTERGRANULAR CORROSION ON FRAME ANGLE FS 360 LONG 27L. REPAIRED PER SRM SRM 51-1-20D.SDR UPS96805873Frame · corrodedWHILE IN FOR C-CHECK, MAINTENANCE REPORTED HEAVY CORROSION ON BOLT FRAME FS 160 LONG 36 TO 35R. REPAIRED PER SRM 53-2-0 FIG 2 AND SRM 51-1-20D.SDR UPS96805872Angle · corrodedWHILE IN FOR C-CHECK, MAINTENANCE REPORTED HEAVY CORROSION ON ATTACH ANGLE AT FS 100 LONG 31R. REPLACED ANGLE PER SRM 51-1-21.SDR UPS96805965Doubler · corrodedWHILE IN FOR C-CHECK, MAINTENANCE REPORTED HEAVY CORROSION DAMAGE ON FINGER STR DOUBLER FS 50 TO 67 LONG 21L. REPLACED FINGER DOUBLER PER SRM 51-1-21.SDR UPS96805964Fitting · corrodedWHILE IN FOR C-CHECK, MAINTENANCE REPORTED LT HORIZONTAL STAB FITTING HAD CORROSION DAMAGE AT NR 4 STR STA XFS 135 BOTTOM INSIDE SKIN. REPLACED FITTING PER SRM 51-1-20D.SDR UPS96805961Fitting · corrodedWHILE IN FOR C-CHECK, MAINTENANCE REPORTED MCD JAMB HEAVY CORROSION ON ATTACH ANGLE FITTING FWD OF NR 1 SPOOL FITTING. REPLACED ANGLE FITTING PER SRM 51-3-0.SDR UPS96805871Fitting · corrodedWHILE IN FOR C-CHECK, MAINTENANCE REPORTED HEAVY CORROSION AT FS 920 FITTING AFT OF LONG 24R. REPLACED FITTING PER SRM 53-2-0.SDR UPS96805867Fitting · corrosionWHILE IN FOR C-CHECK, MAINTENANCE REPORTED CORROSION ON FS 980 FWD OF FRAME FITTING LONGERON 20R. REPLACED FITTING PER SRM 51-1-20D.SDR UPS96805854Skin · corrosionWHILE IN FOR C-CHECK, MAINTENANCE REPORTED LT WING T/E, STA XW700 TO STA XW 710 HAS CORROSION BULGES ON SKIN. REPAIRED SKIN IAW DOUG DRAWING NR 5644654.SDR UPS96805893Spar · crackedWHILE IN FOR C-CHECK, MAINTENANCE REPORTED 6 CRACKS TOTALING 13 INCHES LONG AND HEAVY CORROSION AT LT WING REAR SPAR STA XRS615 TO STA XRS659. REPAIRED PER UPS EO DC8-57-0651.SDR UPS96805868Doubler · corrosionWHILE IN FOR C-CHECK, MAINTENANCE REPORTED CORROSION ON BOLT FRAME DOUBLER FS 857 LONGERON 19R. REPLACED FRAME DOUBLER PER SRM 51-1-20D.SDR UPS96805866Intercostal · corrodedWHILE IN FOR C-CHECK, MAINTENANCE REPORTED CORROSION ON FS 1265 LONGERON 11R AT INTERCOSTAL. REPAIRED INTERCOSTAL PER SRM 51-1-20D, 53-2-0.SDR UPS96805853Skin · corrosionWHILE IN FOR C-CHECK, MAINTENANCE REPORTED VERTICAL STABILIZER T/E, BOTH SIDES HAVE CORROSION BETWEEN NR 4 RUDDER SUPPORT FITTING. REPLACED SKIN PANEL BY REBONDING NEW ONES IAW SRM 51-1-19.SDR UPS96805904Spar · crackedWHILE IN FOR C-CHECK, MAINTENANCE REPORTED CRACK IN TOP SIDE OF RT WING STA XRS 358 SPAR CAP. REPAIRED PER SRM 57-2-0 AND UPS EO DC8-5720-487.SDR UPS96805903Skin · crackedWHILE IN FOR C-CHECK, MAINTENANCE REPORTED 5 INCH LONG CRACK AT RT WING EXTERNAL LEADING EDGE ABOVE PYLON NR 4. REPAIRED L/E SKIN PER SRM 57-2-1A.SDR UPS96805869Splice · corrosionWHILE IN FOR C-CHECK, MAINTENANCE REPORTED CORROSION ON LONGERON 8R SPLICE FS 210. REPLACED SPLICE FITTING PER SRM 51-1-20D.SDR UPS96805895Skin · corrosionWHILE IN FOR C-CHECK, MAINTENANCE REPORTED MODERATE CORROSION DAMAGE ON FUSELAGE SKIN AT THE CUTOUT FOR THE AFT ENTRY DOOR HOLD OPEN HOOK. REPAIRED PER UPS EO DC8-53-1608.SDR UPS96805900Skin · delaminatedWHILE IN FOR C-CHECK, MAINTENANCE REPORTED LT WING NR 1 SPOILER DELAMINATION ON UPPER SURFACE. REPLACED SPOILER ASSY PER MM 27-61-01.SDR UPS96805899Vane · delaminatedWHILE IN FOR C-CHECK, MAINTENANCE REPORTED LT WING NR 5 FLAP VANE DELAMINATED. REPLACED VANE ASSY PER MM 27-51-14.SDR UPS805114Skin · crackedWHILE ON GROUND, MAINTENANCE FOUND CRACK ABOUT 1.25 INCHES LONG ON WING L/E LOWER OUTBOUND OF NR 2 ENGINE, 8 INCHES AFT OF FIRE BOTTLE INSP PLATE INBOUND. REPAIRED PER UPS ENGINEERING FILE NR DC8-57-0615.SDR UPS205096Battery Pack · dischargedWHILE ON GROUND, MAINTENANCE FOUND EMERGENCY EXIT LIGHTS DO NOT DISARM. REMOVED AND REPLACED EMERGENCY LIGHT BATTERY PACK.SDR UPS804361Wire · separatedPILOT REPORTED AIR TURN BACK AS GEAR RETRACTION DOOR NOT LATCHED LIGHT REMAINED ILLUMINATED. FOLLOWED CHECK LIST. RECYCLED GEAR. NO HELP. FOUND WIRE 376D24 SEPARATED FROM TERMINAL STRIP S339, REPAIRED WIRE. DOOR WARNING LIGHT SYS. OPS CHECK NORMAL. ALSO,SDR UPS803509Eel Battery Pack · dischargedWHILE ON GROUND IN SDF, MAINTENANCE FOUND EMERGENCY BATTERY PACK LOW. REPLACED PACK, OPS CHECK GOOD ON GROUND.SDR UPS802652Smoke Det · inoperativeMAINTENANCE REPORTED DURING SMOKE DETECTOR TEST, WARNING LIGHT REMAINED ON. RECYCLED SELECTOR SWITCH AND FOUND NR 2 SMOKE DETECTOR WOULD NOT TEST. DEFERRED NR 2 SMOKE DETECTOR PER MEL 26-6-1. CONTROL M90343 ASSIGNED.SDR UPS801908Connector · loosePILOT REPORTED, LEFT MLG DOES NOT INDICATE DOWN AND LOCKED WITH GEAR HANDLE DOWN. CYCLED GEAR 3 TIMES. ERM CHECKLIST COMPLETED WITH REQUIRED VISUAL FLY BY (CHANGED BULBS-DID NOT WORK). FOUND PLUG P1-213 LOOSE AND CONTAMINATED. CLEANED AND SECURED PLUGS AND
Back to N797UP, cancelled Dec 13, 2012