N674UP, cancelled Aug 21, 2013
Service difficulty reports · 130
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 = 'N674UP' AND deregistration_id = 'N674UP-2013-08-21' 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 = 'N674UP' AND deregistration_id = 'N674UP-2013-08-21' 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 UPS97422437Tee Chord · corrodedINSPECTION TYPE-C, FWD CARGO COMPARTMENT FOUND ON FRAME BS 860 RBL 10 UPPER T-CHORD CORRODED AROUND ATTACHMENT HOLE. REPAIRED T-CHORD ACC DFX 97-075 ENGINEERING FILE NUMBER 747-53-0622.SDR UPS97422462Skin · wornINSPECTION TYPE-C, FOUND INNER SKIN WORN BY LATCHS AT ACCESS PANEL CUT OUT NAC STA 177 UPPER AND LOWER SIDE. REPAIRED INNER SKIN ON LATCH POSITIONS ACC KLM DFX 97-055 REV NR 1 APPROVAL EFN 747-54-0153.SDR UPS97422438Channel · crackedINSPECTION TYPE-C, FOUND CRACKS IN LOWER CHANNEL FOR CENTER GUIDE ATTACHMENT AT BS 1683, BL 0. LOGITUDINAL SUPPORT STIFFENER REPLACED ACC TELEFAX NO8817-6199 MARCH 04 1997 IN ACCORDANCE WITH DRAWING 65B09113-10, 32 SECTION OF TOP SKIN REPLACED ACC SRM 51-30-0SDR UPS97422425Floorbeam · crackedINSPECTION TYPE-C, UPPER DECK FLOOR STRUCTURE FOUND LONGITUDINAL CHORD ON FLOORBEAM CRACKED DURING FLOOR PANEL INSTALLATION AT BS 400 RBL 75. REPAIRED T-CHORD FROM BS 400 TO 410 ACC SRM 53-10-04 FIG 76.SDR UPS97422427Frame · dentedINSPECTION TYPE-C, FOUND DENT AT FRAME BS 1820 STR 16 RT DURING EO B747-5330-0843E. REPLACED FRAME FROM STR 17 TO STR 13 RT AT BS 1820 ACC SRM 51-40-03 FIG 2 AND SRM 51-30-02.SDR UPS97422426Frame · dentedINSPECTION TYPE-C, FOUND DENT AT FRAME BS 2040 STR 16 RT DURING EO B747-5330-084E. FRAME AT BS 2040 BETWEEN STR 16 AND STR 17 REPAIRED ACCORDING SRM 53-10-04 FIG 87.SDR UPS97422416Frame · dentedINSPECTION TYPE-C, FOUND DENT DURING EO B747-5330-0843E AT FRAME BS 1780 STR 19 RT. REPAIRED FRAME AT BS 1780 AT STR 19 RT ACC SRM 53-10-04 FIG 87.SDR UPS97422414Frame · corrosionINSPECTION TYPE-C, AFT CARGO COMPARTMENT FOUND CORROSION ON LOWER AND UPPER SIDE OF FRAME UPPER CHORD AT BS 1600, RBL 36/44 AND LBL 36. REMOVED CORROSION ACC SRM 51-10-01, WITHIN LIMITS OF SRM 53-30-01 AT RBL 36/44. OUT OF LIMITS AT LBL 36 AND REPAIRED UPPERSDR UPS97422418Skin · corrosionINSPECTION TYPE-C, FOUND CORROSION AT LAP JOINT FROM BS 1960 TO BS 2080 STR 12 RT. CORROSION AT STR 12 LAP JOINT BS 1960 BS 2080 REMOVED ACC SRM 51-10-01, WITHIN LIMITS ACC SRM 53-30-01. DELAMINATED LAP SPLICE REPAIRED ACC TO BS 2180 STR 12 RT.SDR UPS97422417Skin · corrosionINSPECTION TYPE-C, INTERNAL FUSELAGE FOUND CORROSION AT LAP JOINT FROM BS 1880 TO BS 1940 RT STR 4. REMOVED CORROSION FROM BS 1860 TO BS 1940 ACC TO SRM 51-10-01 WITHIN LIMITS ACC SRM 53-30-01. DELAMINATED LAP SPLICE REPAIRED ACC TO SRM 53-30-03 FIG 10 FROM SDR UPS97422429Doubler · misinstalledINSPECTION TYPE-C, PYLON 3 FOUND DURING SB54-2034R4 MODIFICATION THAT ALREADY DOUBLER WAS INSTALLED. ONLY DOUBLER IS NOT ACCORDING SB INSTALLED DOUBLER ON LT SIDE ACC, KLM DFX 97-046 REV 3 APPROVED EFN 747-54-0149R1.SDR UPS97422440Skin · lightning strikeINSPECTION TYPE-C, BS 280 TO 400 S17L, AND ABOVE WINDOWS AT BS 320 TO BS 360 SEVERAL LIGHTNING STRIKES IN SKIN. LIGHTNING STRIKES AT BS 280 TO BS 380 AND BS 320 TO BS 360 ABOVE WINDOWS OUT OF LIMITS ACC SRM 53-30-01. REPAIRED LIGHTNING STRIKES ACC SRM 53-30-SDR UPS97422420Skin · lightning strikeINSPECTION TYPE-C, BS 140 TO BS 180 S14EL AND BS 160 TO BS 180 ABOVE PAX WINDOWS, SEVERAL LIGHTNING STRIKES IN THESE AREAS. LIGHTNING STRIKES AT BS 140 TO BS 180 S14EL AND BS 160 TO BS 180 ABOVE PAX WINDOWS OUT OF LIMITS ACC SRM 53-30-01, REPAIRED LIGHTNING SSDR UPS97422415Shear Tie · corrosionINSPECTION TYPE-C, AFT CARGO COMPARTMENT FOUND SHEAR TIE DELAMINATED DUE TO CORROSION AT BS 1740, BETWEEN S-48/47 RT. REMOVED DAMAGED SHEAR TIE AND REPAIRED SHEAR TIE ACC SRM 53-10-04, FIG 3A.SDR UPS97422419Cam Shaft · corrodedINSPECTION TYPE-C, FOUND INSIDE THE GENEVA CAM SHAFT NR 7 CORROSION. GENEVA CAM SHAFT NR 7 REPLACED ACCORDING MM 27-51-23.SDR UPS96420601Lights · inoperativeINSPECTION TYPE DLY, MAIN DECK TWO EMERGENCY EXIT LIGHTS INOP, FWD AISLE LIGHT AND FWD LIGHT IN L1 DOOR SILL. PERFORMED OPS CHK OF EMERGENCY LIGHTS, LIGHTS CHECK GOOD.SDR UPS405318Floorbeam · corrodedWHILE IN FOR C-CHECK AMS MAINTENANCE REPORTED, FLOORBEAM UPPER CHORD CORRODED AT BS 1580 LBL 0. REMOVED AND REPLACED FLOORBEAM IAW SRM 51-40-04.SDR UPS405334Keel Beam · corrodedWHILE IN FOR C CHECK AT AMS, MAINTENANCE, FOUND CORROSION ON CENTERLINE KEELBEAM WEB INSIDE BSTA 1242. REPAIRED AS REQUIRED PER SRM 51-10-01, AND KLM DTZ 96-011.SDR UPS405284Spar · corrodedAMS - WHILE IN FOR C-CHECK, CORROSION ON LWR FRONT SPAR CHORD BBSTA 1000 NEAR STA 38L. REMOVED CORROSION PER SRM 57-10-01 FIG 1, OUT OF LIMIT. REWORKED CORROSION SPOT PER KLM DFX 96-001 BOEING APPROVAL.SDR UPS405135Skin · delaminatedMAINTENANCE REPORTED LEFT WING L/E INBOARD OF NR 2 PYLON HAS DELAMINATION. REPAIRED IAW SRM 51-40-09.SDR UPS405134Skin · delaminatedMAINTENANCE REPORTED LEFT WING L/E BEHIND LANDING LIGHT HAS DELAMINATION. REPAIRED IAW SRM 51-40-09.SDR UPS405125Skin · delaminatedWHILE ON GROUND, MAINTENANCE FOUND LEFT WING L/E INBOARD OF NR 2 PYLON HAS DELAMINATION. ACCOMPLISHED COMPOSITE REPAIR REF: SRM 51-40-09.SDR UPS404880Eel Wire · failedWHILE ON GROUND, MAINTENANCE FOUND FORWARD EMERGENCY LIGHT OVER THE MAIN ENTRANCE WILL NOT TEST. MAINTENANCE REMOVED AND REPLACED FUSE IN AFT BATTERY PACK AND REPAIRED WIRE TO FRONT DOOR EMERGENCY LIGHT. OPS CK NORMAL, WORK PERFORMED IAW MM 33-51-00.SDR UPS404803Fire Warning · activatedPILOT REPORTED, SHORTLY AFTER T/O FIRE WARNING BELL AND LIGHT ACTIVATED FOR APPROX .5 SECOND. DUE TO THE SHORT DURATION OF WARNING, COULD NOT PINPOINT WHICH ENGINE BUT JUMPSEAT MECHANIC SAID DEFINITELY NR 3 OR NR 4 FIRE WARNINGS TESTED AND ALL CK OK. NR 4 ENSDR UPS404432Engine · malfunctionedPILOT REPORTED, ON FINAL APPROACH WITH ALL ENGINES AT IDLE, NR 3 ENGINE SURGED TO 1.25 EPR, N1 80 PLUS PERCENT N1 AND HIGH FUEL FLOW. ENGINE WAS SHUTDOWN.SDR UPS404276Eel · inopWHILE ON GROUND, MAINTENANCE FOUND CREW SERVICE DOOR EMERGENCY EXIT LIGHTS FOR SLIDE INOP, DEFERED MEL 33-13.SDR UPS404118Eel · dimWHILE ON GROUND, MAINTENANCE FOUND CREW SERVICE DOOR EMERGENCY EXIT LIGHT INOP. MAINTENANCE CLEANED THE CONNECTOR, LIGHT OPS CK OK.SDR UPS404110Eel · dimWHILE ON GROUND IN SDF, MAINTENANCE FOUND EMERGENCY LIGHT IN CREW SERVICE DOOR FRAME IS DIM. MAINTENANCE RELAMPED EMERGENCY EXIT AT RT FLIGHT DECK SERVICE DOOR.SDR UPS403745Te Skin · delaminatedWHILE ON GROUND IN ONT, MAINTENANCE FOUND RT I/B ELEVATOR T/E DELAMINATED. REPAIRED IAW SRM 51-40-15.SDR UPS403215Panel · delaminatedMAINTENANCE REPORTED PANEL DELAMINATED ON RT HORIZONTAL STAB, LWR SURFACE, 2ND PANEL FROM OUTBOARD. INSTALLED REPAIR PER UPS EO B747-5510-6994A.
Back to N674UP, cancelled Aug 21, 2013