N647UA
Service difficulty reports · 320
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 = 'N647UA' AND registry_match = 'registration' 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 = 'N647UA' AND registry_match = 'registration' 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 UALA2012110806437Rivet · damagedFOUND BY FRENCH DGAC ENGINE 2 NOZZLE TRAILING EDGE : ONE BROKEN RIVET (9 O'CLOCK POSITION). MISSING RIVET AT NR 2 ENGINE EXHAUST T-E 9 O'CLOCK POSITION CARRIED FORWARD IAW ECRA 7811-011 73. DETAIL VISUAL INSPECTION ACCOMPLISHED, NO FINDINGS. FOUND FASTENER SDR UALA2012110606380Pressure Switch · faultyNR 1 ENGINE HYD EDP LOW PRESSURE LIGHT DOES NOT ILLUMINATE WHEN ENGINE IS SHUT DOWN. REF SM 29-00-02 PG 101 SHEET 1 JUMPED SWITCH S26 AND LIGHT ILLUMINATED AND REF DF231 AUTO FUNCTION THEN OPERATED NORMALLY. CLEANED SWITCH CONTACTS AND REFITTED PLUG AND LIGHSDR UALA2012100105565Line · leakingHYDRAULIC LINE LEAKING IN RIGHT MLG WHEEL WELL. LINE REMOVED FOR REPAIR OR REPLACEMENT. REPLACED 1EA CTR SYSTEM HYDRAULIC BRAKE LINE IN RIGHT STRUT-WELL, LEAK CHECKS GOOD.SDR UALA2012092405427Computer · faultyLEFT FORWARD WINDOW EICAS. LEFT EICAS COMPUTER REPLACED PER AMM. SOFTWARE OPS: 3174-COL-DEO-07,OPC:3100-BCG-006- E7 INSTALLED PER TASK MM. LEFT EICAS COMP, OPS NORMAL. NO FURTHER MESSAGE.SDR UALA2012091305171Seal · leakingLANDING GEAR SELECTOR HYD LEAK. REMOVED LOWER FWD UNION INCLUDING T-PIECE TO ACCESS UPPER AFT UNION. UPPER AFT UNION REMOVED AND VERIFIED SEAL DAMAGED. NEW SEALS ORDERED FOR BOTH UNION. BOTH UNIONS AND PIPES FITTED HAND TIGHT TO SEAL SYSTEM FROM CONTAMINATSDR UALA2012081504532Actuator · faultyRIGHT ENGINE EEC C1 STATUS MESSAGE DISPLAYED. REPLACED NR 2 ENGINE TCC AIR VALVE ACTUATOR PER MM 75-24-05-401. OPS AND LEAK CHECKED GOOD.SDR UALA2012081304443Actuator · faultyRIGHT ENGINE EEC C1 STATUS MESSAGE DISPLAYED. FOUND ACTUATOR FAULTY.SDR UALA2012080704242Connector · failedWINDOW NR 2 RT FAILS THE HEAT TEST. REPLACED "WW1156 A-A AND A-B" TERMINAL CONNECTION PLUG AND HARNESS - D1906, REF WD30-41- 11 PG 1. OPERATIONAL TEST OF RIGHT SIDE (R-2) WINDOW HEAT SYS OK.SDR UALA2012072303977Hose · unsecureR BLD DUCT LEAK EICAS AND DUCT LEAK ON OVERHEAD. SECURED RADIATOR HOSE IN AREA OF WATER CONDENSOR LEAK CHECKED OK..SDR UALA2012072003947Compensator · inoperativeRIGHT TANK INDICATOR BLANKING. FOUND FAULT CODE C6 BOTH CHANNELS. ACCOMPLISHED FIM 28-41-00 TABLE 108 (CONFIG 1). REPLACED COMPENSATOR.SDR UALA2012070503599Seal · leakingCREW REPORTS DUCT LEAK LIGHT ILLUMINATED WITH APU BLEED AIR ON. LIGHT EXTINGUISHES WITH APU BLEED OFF. FOUND LEAK AT SLIDING JOINT FWD OF ADP MUFFLER. REPLACED SEALS, LEAK CHECKED AND NO DUCT LEAK LIGHT.SDR UALA2012041502288Transceiver · faultyWX RADAR SHOWS GND RETURN AT 60 MILES IN AUTOTILT AT ALL RANGES. WX RADAR RT PER MM. TESTS NORMAL PER MM.SDR UALA2012040202013Compensator · fluctuatesRIGHT FUEL QTY FLUCTUATES 1200 LBS RANDOMLY. REPLACED RT TANK FQIS COMPENSATOR USING MM.SDR UALA2012032901979Skin · dentedEXTERNAL FUSELAGE DENTED AT BS 1413 AT STRINGER 34L & 34R. MAJOR REPAIR ACCOMPLISHED: TRIMMED OUT DAMAGE & ACP HFEC. NO CRACKS FOUND. ACP INSURANCE CUT. HFEC OPEN HOLES COMMON TO SKIN REPAIR. FABRICATED & INSTALLED EXTERNAL FILLER, DOUBLER & TRIPLER REPASDR UALA2012032901969Failsafe · corrodedCOMPARTMENT AFT OF BULK CARGO PIT AT BS 1562 BETWEEN STRINGERS S-39L & S-39R FAILSAFE FOUND CORRODED. REMOVED DAMAGE. ACCOMPLISHED NDT & PERFORMED 0.04" INSURANCE CUT. ACCOMPLISHED NDT OF REPAIR FASTENER HOLES. NO CRACKS FOUND. FABRICATED & INSTALLED FILLSDR UALA2012032901967Floorbeam · corrodedAFT CARGO BAY FLOORBEAM AT BS 1197+22 AT LBL 38 FOUND CORRODED. REMOVED CORROSION & FOUND MATERIAL LOSS OUT OF LIMITS OF SRM. CUT OUT FLOORBEAM SECTION & FABRICATED & INSTALLED FLOORBEAM SPLICE REPAIR, REPAIR 4. THIS IS A CATEGORY 'A' MAJOR REPAIRSDR UALA2012032901968Floorbeam · puncturedAFT CARGO COMPARTMENT FLOORBEAM WEB PUNCTURED AT BS 1270 RBL 36. MAJOR REPAIR ACCOMPLISHED: RMV'D & RPL PUNCTURED WEB. FABRICATED & INSTALLED NEW WEB SECTION.SDR UALA2012032701932Floorbeam · crackedAFT CARGO COMPARTMENT STA 1197+90, LBL 38 FLOORBEAM CRACKED. MAJOR REPAIR ACCOMPLISHED: FABRICATED & REPLACED J-CHORD, STRAP AND CHANNEL PER SRM'S 51-40-02 AND 53-00-07 ON NR 4453N00484.SDR UALA2012032601880Shutoff Valve · faultyNR 2 ENGINE HIGH PRES SHUTOFF VALVE FAULTY. NR 2 ENGINE PRESSURE SHUTOFF VALVE REPLACED ON TC 640004012.SDR UALA2012032601879Shutoff Valve · faultyNR 1 ENGINE HIGH PRES SHUTOFF VALVE FAULTY. NR 1 ENGINE HIGH PRESSURE SHUTOFF VALVE REPLACED ON TC 640004010.SDR UALA2012032601892Floorbeam · corrodedAFT CARGO COMP STA 1197+132, LBL 38 FLOORBEAM CORRODED ON LWR SURFACE AROUND NUT PLATE. RMV'D T-CHORD STA 1197+ 132, LBL 38 - RBL 38. FABBED AND INSTALLED NEW T-CHORD PER SRM ON NR 4453N00406.SDR UALA2012020600717Transceiver · defectiveWXR WEAK MESSAGE INTERMITTENTLY DISPLAYED OI CAP AND F/O HSI. REPLACED WXR XCVR PER MM, CHECKS GOOD.SDR UALA2012020600716Antenna · failedWXR FAIL DSPLYD ON HSI. WXR FAIL WEAK DSPLYD ON HSI IN WXR TEST POS'N. CREW COMMENTS: WXR FAIL WEAK RT DISPLAYS. REPLACED WXR RADAR ANTENNA, ALL OPS CHECKS SATISFACTORY.SDR UALA2012012000432Door · saturatedCF968 AND CF967 WATER INGRESS ON MLG DOORS, DOORS REMOVED TALKED TO SHOP WITH EST FOR DOORS RETURN IS 0700-23. LT MLG DOOR IS ON R&R R57058, RT MLG IS ON R57057, SAILTAIL IS ON R57059* SHOP REPORTS SPARE RT MLG DOOR AVAIL BY TOMORROW.SDR UALA2012010900215Actuator · leakingLOWER RUDDER ACTUATOR LEAKING AT PISTON. INSTALLED NEW LOWER RUDDER ACTUATOR. REMOVED MR27250-65 OFF AND -91 ON. NEED TO COMPLETE FROM STEP I-5 ON PAGE 219. COMPLETED INSTALLATION AND OPS CHECK OF RUDDER PCA SYSTEM PER MM.SDR UALA2012010900214Actuator · leakingFOUND RT YAW DAMPER ACTUATOR M509 LEAKING DURING OPERATION. INSTALLED NEW ACTUATOR PER MM.SDR UALA2012010300069Shutoff Valve · failedAPU PNEUMATICS NOT OPENING FOR ENGINE START. PACKS OFF. APU BLEED VALVE BAR SHOWS OPEN, YET NO DUCT PRESSURE FOR ENGINE START. REPLACED APU AIR SUPPLY SHUTOFF VALVE PER MM. OPS CHECKED OK.SDR UALA2011122807133Nut · missingF-O SEAT IS MISSING FRONT LEFT SEAT TRACK STOP. INSTALLED NUT.SDR UALA2011122207057Actuator · malfunctionedAPU DOOR STATUS UPON APU SHUTDOWN. APUC REPLACED . REACTIVATED APU INLET DOOR ACTUATOR REF MEL 4915D. ACCOMPLISHED BITE CHECK ON APUC, NO FAULTS PRESENT. ACCOMPLISHED OPS CHECK OF ACTUATOR. STARTED APU, NO APU OR DOOR FAULTS ON EICAS.SDR UALA2011121906968Controller · faultyAPU NO START. REPLACED APU CONTROLLER PER AMM, OPS CHK OK. SECURED CONNECTOR TO APU DOOR ACTUATOR. STARTED APU. SATISFACTORY OPERATIONS.SDR UALA2011121906928Warning System · activatedR ENG FUEL FILT EICAS MSG, RTFLSDR UALA2011111006146Warning System · false activationNO CTR R FUEL PUMP EICAS W-PUMPS ON AND ENGINE OFF. NO TIME. PERFORMED OPERATIONAL TEST OF ENGINE FUEL FEED SYSTEM. NO FAULTS FOUND. OPS TEST NORMAL.SDR UALA2011101705609Hour Meter · inoperativeAPU OIL CONSUMPTION ABOVE LIMIT. RAN APU FOR 10 MINUTES NO LEAKS NOTED, APU FOUND CLEAN AFTER RAN. PERFORMED T-S PER AMM49-11-00 & RAN APU IAW JRH2-6-15- AFTER RAN NOTED APU HOURMETER INOPERATIVE. APU HOUR METER DEFECTIVE, CLICKS INTERNALLY AT 10TH HOUR BUTSDR UALA2011091204947Actuator · faultyNO POWER TO UNDER WING FUELING PANEL. BRACKET FOR PROX SW SWITCH ACTUATOR IS DAMAGED. NEED TO HOLD ACTUATOR FOR PROX SWITCH IN PLACE WHILE FUELING. (PCN 160-5008) IN LOB. ITEM 90 PCN 160-0288 IS NOT AVAIL. ORDERED PART OSTF# X1392. -INF- :PCN 160-0288 ONSDR UALA2011082304509Unknown · malfunctionedAPU FAILED TO START. RESTARTED APU. NO FAULTS.SDR UALA2011082204476Circuit Card · faultyWHEN STANDBY PWR SWITCH SELECTED TO OFF POSITION THE CONFIG WARNING SOUNDS AND THE MASTER WARNING LT ILLUMINATES. WHEN STBY PWR BUS DEPOWERED OR WEU B CB P11 B18 PULLED MASTER WARNING LTS ILLUMINATE AND AURAL WARNING SOUNDS. NO EICAS WARNING MSG IS PRESENT WSDR UALA2011082204445Fitting · missingLUBRICATION ZERK FITTING MISSING FROM OTBD END OF RIGHT MAIN GEAR TRUCK PIVOT PIN. HOLE IS WORN TOO LARGE TO INSTALL NEW FITTING. INSTALLED OVERSIZED ZERK FITTING. LUBES OKAY.SDR UALA2011080304053Relay · failedCAPT SIDE PRIMARY FLIGHT INSTRUMENTS ALL BLANK. REPLACED RELAY K862. CAPT'S EFIS OP CHECKED NORMAL.SDR UALA2011072903916Pump · malfunctionedRIGHT CENTER TANK FUEL PUMP INOPERATIVE AND DEACTIVATED. CIRCUIT BREAKER POPPED ON P-6 PANEL. RAN NR 2 ENGINE FOR 5 MIN, OPS CHECKED RIGHT CENTER TANK FUEL PUMP. NO CIRCUIT BREAKER POP, CENTER TANK FUEL PUMP CHECKED NORMAL PER JRH.SDR UALA2011062003009Circuit Card · malfunctionedWHEN STANDBY PWR SWITCH SELECTED TO OFF POSITION THE CONFIG WARNING SOUNDS AND THE MASTER WARNING LT ILLUMINATES. WHEN STBY PWR BUS DEPOWERED OR WEU B CB P11 B18 PULLED MASTER WARNING LTS ILLUMINATE AND AURAL WARNING SOUNDS. TRIED SWAPPING WEU A AND B PER MM,SDR UALA2011052602578Adc · faultyADC FAILURE, FLIGHT DIVERTED. MCDP PREV FLT FAULTS: FD BAR FMC L-R CH (110071120081) (110081120071) FD BAR ADC SYST L (110401) FD BAR IRU L (110551) FD BAR ADC L-R CH (122080). REPLACED BOTH LT AND RT ADC PER MM AND PERFORMED LOW RANGE LEAK TEST ON BOTH ADCSDR UALA2011051602413Fan Blade · damagedENG NR 1: FAN BLADES NR 34, HAS DAMAGE ON LEADING EDGE ONE NICK. ACCOMPLISHED BLADE REPAIR REF MM.SDR UALA2011041401808Actuator · faultyAFTER PUSH AILERON LOCKOUT EICAS MESSAGE. FOUND LEFT SAM HAD LEFT AILERON ACT FAULT. RESET AND DID NOT RETURN. FOLLOWED LM8279 AND REPLACED RIGHT SAM. UPON RETEST LEFT SAM FAULTED LEFT ACTUATOR. INSTALLED NEW SAM IN LEFT SIDE AND ORIGINAL BACK IN RIGHT. RETESSDR UALA2011040801704Circuit Board · failedEICAS MESSAGE FWD EQ EXH FAN DISPLAYED. FWD EQ EXHAUST FAN PLACARD INOP IAW MEL2158F. COMPLIED WITH MEL REQUIREMENTS. CBS H21 AT P6 AND P22 AT P11 PULLED AND COLLARED. STANDBY MODE OPERATIONS VERIFIED WORKING SATISFACTORY. CHANGED ECS FAN CONTROL CAD PER SDR UALA2011033101560Wire · arcedFWD CARGO PIT AT STA 535 STR 37L ARC WIRING FOUND AND STR 37L PAINT SHOWED HEAT DAMAGE. NEEDS INSPECTION. WHILE WORKING A-CHECK SMELLED SMOKE FROM WIRE BUNDLE IN FWD PIT TO PDUS. FOUND WIRES ARCING. RECOMMENDED HARDNESS TEST. HEAT TREAT VERIFICATION. ACP'SDR UALA2011031701288Switch · faultyDURING NR 1 ENG RUN, "L IDG VALVE" MESSAGE APPEARED ON LOWER EICAS, MESSAGE WOULD ERASE, BUT RE-APPEAR ON NEXT ENG RUN. IDG AIR-OIL HEAT EXCHANGER VALVE OVERRIDE SWITCH WAS REPLACED. REMOVED AND PUT NEW COOLER IN PLACE. IDG AIR-OIL HEAT EXCHANGER VALVE OVESDR UALA2011030801128Actuator · bindingAILERON LOCKOUT DESCENDING OUT OF 10000 240 KNOTS. RT OB AILERON LOCKOUT ACTUATOR PREVIOUSLY REPLACED. STILL FAULTING ACTUATOR. WORKING REPLACEMENT OF ACTUATOR. REPLACED RIGHT OTBD AILERON LOCKOUT ACTUATOR. CHECKED OK. AILERON LOCKOUT FAULT AND HYD PRESSURE SDR UALA2011030901152Actuator · faultyAILERON LOCKOUT EICAS WITH ASSOCIATED OVERHEAD LIGHT ILLUMINATED ON ARRIVAL. REPLACED RIGHT OTBD AILERON LOCKOUT ACTUATOR PER MM.SDR UALA2011022800966Panel · peelingNR 1 AFT OTBD PYLON FAIRING PANEL AT NAC STATION 352.80 HAS METAL OVERLAY PEELING UP. MEASURES 3 INCH BY 4.5 INCH ACP TEMP REPAIR PER EVA UAL 80580, PANEL SECURE. REMOVED NR 1 OUTBOARD PYLON PNL 313T3381-203 AND ROUTED TO SHOP 273. REMOVED AND REPLACED 4299SDR UALA2011020800668Computer · faultyRT EICAS COMPUTER DISPLAYED ON STATUS PAGE. ACP FIM R EICAS NO FAULTS NOTED IN TEST MODE, LT EICAS 2 INTERFACE FAULTS, RECEIVER FAULT, EICAS XTALK INTERFACE FAULT LEG 7 AND ON LEG 8 SAME. AT T/O, HARD FAULT. REPLACED LT EICAS COMPUTER.
Back to N647UA