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 CALA2013122093847Anti-Ice Valve · faultyWHEN SELECTING RT ENG ANTI ICE EICAS MESSAGE WITH VLV LIGHT ILLUMINATED IN SWITCH. REMOVED RT ENG ANTI ICE VLV & REPLACED NR 1 ENG ANTI ICE VLV IAW 30-21-03 UP TO PG 405 STEP 11. NEED TO CONT FROM STEP 11 TO END.SDR CALA2013120593475Brake · faultyNR 1 FWD BRAKE PIN IS 1-16". CURRENT PTC IS 14625 MUST BE REPLACED ON OR BEFORE PTC 14627. BRAKE PCN 160-9740. R & R NR 1 MLG BRAKE ASSEMBLY.SDR CALA2013112093106Light · inoperativeNR 2 ENG ANTI ICE VLV LIGHT INOPERATIVE. ANTI ICE VLV LOCKED OPEN, HPSOV LOCKED CLOSED, HMG LOCKED CLOSED IAW MELN 3021H.SDR CALA2013112093105Pressure Switch · faultyRT ENG AIV STATUS MESSAGE. REPLACED R ENG THERMAL AIV PSI SWITCH IAW FIM 30-21-00-PG107.SDR CALA2013112293201Actuator · faultyNR 6 SPOILER FLOATED DURING TEST FLIGHT. R & R SPOILER ACTUATOR IAW AMM 27-61-02 ON NR 36598.SDR CALA2013112293200Actuator · faultyRT INBD AILERON ACTUATOR BAD FOUND DURING TEST FLIGHT. R & R RT INBD ACTUATOR ON NR 36599 IAW AMM 27-11-48 & SRM 51-40-02.SDR CALA2013112293198Actuator · faultyDURING PREFLIGHT CHECK, AILERON TRIM ASYMMETRIC GOES FROM 6.6 LT TO 4.2 RT, SHOULD BE 5.6 + OR .3 BOTH SIDES. R & R LATERAL TRIM ACTUATOR IAW AMM, AILERON TRIM FUNCTIONS IAW 27-11-00.SDR CALA2013111892995Sign · disconnectedOVERWING EMERGENCY EXIT SIGNS NOT PROPERLY CONNECTED. RE-CONNECTED OVERWING EXIT SIGNS IAW AMM, OPERATIONS CHECKED GOOD.SDR CALA2013111892994Wire · out of positionEMERGENCY LIGHTS ACTIVATED WITH COCKPIT SWITCH IN OFF POSITION. SWAPPED CONNECTOR D4209P, CORRECTED WIRING IAW 767 WDM 33-51-11, OPERATIONS CHECKED GOOD.SDR CALA2013102892431Frame · corrodedAFT CARGO COMPARTMENT BILGE FRAME T CAP CORRODED TOP SURFACE BS 1175, STRINGER 32L - STRINGER 32R. R & R T CAP AT BS 1175, STRINGER 32L - 32R IAW SRM 53-00-07 & 51-40-02.SDR CALA2013102892430Frame · corrodedAFT CARGO COMPARTMENT BILGE FRAME T CAP CORRODED TOP SURFACE BS1153, STRINGER 32L -STRINGER 32R. REPLACED UPPER T CAP AT BS 1153, STRINGER 32L-3 2R IAW WITH SRM 53-00-07 & 51-40-02.SDR CALA2013102892429Stringer · dentedAFT PIT STRINGER 39L IS DENTED AT BS 1450. REMOVED DAMAGED SECTION OF STRINGER, FABRICATED ONE EACH STRINGER SECTION IAW BAC DRAWING 146T30 03, TWO EACH 6 CHANNELS & TWO EACH 7 ANGLES & INSTALLED IAW SRM 53-00-03, REPAIR 2, DETAIL IV ON NON-ROUTINE 36048.SDR CALA2013102892428Spar · abnormalNR 1 PYLON FWD UPPER SPAR WEB INBD & OTBD DRAIN HOLES HAVE PREVIOUS REPAIRS. THE EXISTING REPAIR WAS REMOVED AT NAC STATION 156, & THE LT DRAIN HOLE WAS FOUND CRACKED PAST THE PREVIOUS STOP DRILLS. A NEW REPAIR WAS INSTALLED IAW REO G16676, REV A & SRM 54-53-SDR CALA2013102492344Spar · crackedNR 2 PYLON UPPER SPAR WEB AT NAC STATION 156, BOTH DRAIN HOLES ARE CRACKED. REPAIRED THE UPPER SPAR WEB IAW REO G16606, REV A & ECRA 5450-02099 INCORPORATING TWO MACHINED DOUBLERS & TWO RADIUS FILLERS IAW NOTE B OF SRM 54-53-01, REPAIR 10.SDR CALA2013102492343Floorbeam · corrodedMAIN CABIN FLOOR BEAM CORRODED UPPER SURFACE BS 1562, LBL 11- LBL 13. REPAIRED FLOOR BEAM IAW SRM 53-00-51 REPAIR 2 FIG 201.SDR CALA2013101692093Floorbeam · corrodedMAIN CABIN FLOORBEAM BS 347, RBL 54, HAS CORROSION ON UPPER SURFACE. REMOVED CORROSION. CUTOUT DAMAGED SECTION OF TEE, FABRICATED & INSTALLED A THREE STRAP REPAIR & SHIMS IAW SRM 53-00-51, REPAIR 4.SDR CALA2013100991915Floorbeam · crackedSTATION 246 LOWER FLOOR BEAM WEB CRACKED AT RBL 15. REPAIR AT STATION 246 LOWER FLOOR BEAM WEB PTT SEQ.# 7702072.SDR CALA2013100491722Floorbeam · crackedBS 246 LOWER FLOORBEAM WEB CRACKED AT RBL 15. REPAIRED FLOORBEAM IAW ECRA 5310-05868.SDR CALA2013100491747Floorbeam · damagedSTATION 246 FLOORBEAM AT RBL 42 LOWER CHORD & WEB HAS 3/8TH DIAMETER HOLE. TRIMMED OUT HOLE, ACP HFEC IAW PRT 6, 51-00-19, NO CRACKS NOTED. INSTALLED FREEZE PLUG IAW ECRA 5310-05867 & TIMCO REO G16665.SDR CALA2013093091550Floorbeam · corrodedMAIN CABIN FLOORBEAM T-CAP CORRODED AT BS 300 & BETWEEN RBL 45 TO RBL 54.5. REMOVED DAMAGED SECTION OF FLOORBEAM T-CAP, FABRICATED & INSTALLED -1, -2 REPAIR ANGLE S, -3 REPAIR STRAP, 5 EA SHIMS, -13, -14 VERT STIFFENERS, & -63, -64 CLIPS IAW SRM 53-00-51, RPRSDR CALA2013093091536Floorbeam · corrodedMAIN CABIN FLOOR BEAM T-CAP CORRODED APPROXIMATELY BS 325, RBL 45.0-RBL 54.5. REPAIRED FLOOR BEAM IAW SRM 53-00-51, RPR 4, DET I.SDR CALA2013080990296A/C Pack · inoperativeLEFT A/C PACK INOPERATIVE. PERFORMED BITE ON BOTH PACK TEMP CONTROLLERS, NO FAULTS NOTED.SDR CALA2013080590166Blade · bentNR 2 ENGINE HAS ONE FAN BLADE WITH L/E TIP BENT. REMOVED .25 CURL FROM FWD L/E TIP AT AREA "A". REMOVED AN ADDITIONAL .020 MATERIAL AFTER EDDY CURRENT INSPECTION.SDR CALA2013073090099Switch · failedEICAS MESSAGE LT PACK AND RT PACK SHOWED IN COCKPIT. BIT ON PACK CONTROLLERS SHOWED ALTITUDE SWITCH. R & R ALTITUDE SWITCH IAW AMM.SDR UALA2013072305166Circuit Card · intermittentRT BLD DUCT LEAK EICAS AND BLEED DUCT LEAK ON OVERHEAD PANEL. OCCURRED WITH NO AIR AT NR 2 ENGINE. INTERMITTENT INDICATION. REPLACED BLEED AIR CONTROL CARD M860, ACCOMPLISHED DUCT LEAK TEST, TEST NORMAL.SDR UALA2013071504949Control Unit · failedAPU FAILED TWICE AT GATE BEFORE PUSHBACK. R & R ECU IAW AMM, OPS CHECKED GOOD.SDR UALA2013071204896Lens · wrong partLEFT OVER AISLE EMERGENCY EXIT SIGN LENS DOES NOT HAVE OTBD FACING ARROWS IAW EA 3351-01054, REV "A". REPLACED LENS.SDR UALA2013070104582Cable · damagedFIRST OBSERVER SEAT DIAG SLIDE LEVER INOPERATIVE. FOUND ACTUATION CABLE DAMAGED, MOVED SEAT TO MOST AFT POSITION. SEAT REPLACED. LUBED AND OPS CHECKED GOOD. POSITIVE LOCK IN ALL POSITIONS AND POSITIVE MOVEMENT WITH ALL CONTROLS.SDR UALA2013062804542Control Unit · faultyRIGHT ENGINE HYDRAULIC ELEC DEMAND PUMP LOW PRESSURE & SYS PRESSURE LIGHTS ON WITH SWITCH ON. TROUBLESHOT IAW FIM 29-11, FIG 105 29-11-00-990-806 TO RT ELCU M896. SWAPPED ELCU WITH ELC HYD PUMP C2 POSN VERIFIED FAULT WENT TO C2 PUMP. R & R C2 ELCU WITH NEW ESDR UALA2013062604424Drive Unit · failedRT GENERATOR DRIVE LIGHT NOT ILLUMINATED. ALSO, RT GENERATOR FIELD LIGHT NOT ILLUMINATED. REPLACED RT GENERATOR DRIVE AND RT GENERATOR FIELD PUSH BUTTON SWITCHES. OPS CHECKED GOOD.SDR UALA2013062004290Cover · damagedR1 DOOR SLIDE RAFT COVER DAMAGED. COMPLIED WITH EC RA 5211-01348 REQUIREMENTS. TAPE APPLIED AS INTERIM.SDR UALA2013060503888Cable · misinstalledLT OVERWING SLIDE TRIGGER CABLE BALL INSTALLATION INCORRECT. REWORKED LEFT LOW SLIDE TRIGGER CABLE IAW FCD 2560-02526, STEP 6. ALL CHECKED NORMAL.SDR UALA2013052303571Blade · damagedNR 2 ENG BLADE, NR 29 L/E DAMAGED. DAMAGE IS L/E IN AREA "F", REPAIRED IAW MM 72-31-02.SDR UALA2013052303572B-Nut · leakingCREW OXYGEN PRESSURE DECREASING, APPARENT LEAK. FOUND LEAK AT B-NUT ON CREW SUPPLY LINE ON SMALL BORE PIPE. LOOSENED AND RETORQUED B-NUT AND NOW NO LEAKS IAW MM 35-11-00 AND MM 12-15-08 AND OXYGEN STILL ABOVE MINIMUM DISPATCH LIMITS AT 1180 PSI. TOTAL LOSS FORSDR UALA2013051403337Connector · looseSEAT ROW 6A MOUNTED EMERGENCY LIGHT INOPERATIVE. FOUND EMERGENCY LIGHT CONNECTOR UNDER SEAT LOOSE. INSTALLED AND SECURED PLASTIC CONNECTOR UNDER SEAT, EMERGENCY LIGHT OP CHECKED GOODSDR UALA2013050703201Connector · dirtyRIGHT HYDRAULIC ELECTRICAL DEMAND PUMP SYSTEM PRESSURE IS ZERO WITH SWITCH IN AUTO OR ON. CLEANED CONNECTOR, OPS CHECKED NORMAL.SDR UALA2013042302822Clamp · leakingLEFT BLEED DUCT LEAK EICAS ON AND LEFT DUCT LEAK LIGHT. FOUND CLAMP LOOSE AT SENSE LINE FROM ACM TO HEAT EXCHANGER. RETORQUED NUMEROUS DUCT CLAMPS IN RIGHT AC BAY AND LEAK WENT AWAY. RAN ENGINE 5 MINUTES. NO FURTHER DUCT LEAK MESSAGES.SDR UALA2013041202509Connector · faultedWHEEL WELL FIRE LIGHT FAILED TO ILLUMINATE DURING TEST. RESEATED CONNECTOR M691, GROUND CHECKED OK IAW MM 26-17-00SDR UALA2013041102460Detection Sys · inoperativeWHEEL WELL FIRE LIGHT FAILED TO ILLUM DURING TEST. WHEEL WELL FIRE TEST OVERHEAT INOP DEFERRED IAW MEL.SDR UALA2013041102461Warning Light · false activationLEFT BLEED DUCT LEAK ILLUMINATED. EFTL BLEED LIGHT ON MOMENTARILY WITH APU BLEED ON ONLY. ACCOMPLISHED VISUAL INSPECTION ACCESSIBLE DUCTING FOR LEAKS, NO LEAK DETECTED. REPLACED M691 BLEED CARD AS PRECAUTION. NO LIGHT AT THIS TIME, OPS CHECKED NORMAL.SDR UALA2013032601913Light · inoperativeCOCKPIT PORTABLE EMERGENCY LIGHT INOPERATIVE. LIGHT ASSY REPLACED AND OPS CHECKED NORMAL AS PER AMM.SDR UALA2013032601922Actuator · inoperativeRT WING FUEL ENG SPAR VALVE INOPERATIVE DURING TEST. SPAR VALVE ACTUATOR REPLACED AND OPS CHECKED NORMAL IAW AMM.SDR UALA2013031501589Control Panel · stuckRIGHT ISOLATION VALVE SWITCH STUCK IN OPEN POSITION. REMOVED AND REPLACED BLEED AIR CONTROL PANEL.SDR UALA2013031201467Sensor · faultyWITH ENGINES OFF, CAPTAIN'S PITOT, RT AUX PITOT, LEFT AOA AND TAT HEATERS OFF LIGHTS ARE OUT. THESE SYSTEM ARE POWERED IN AIR MODE. CIRCUIT BREAKERS K14, K15, K17, K16, L18, L17 HAVE BEEN PULLED ON P6-3, IAW SSM30-31-01, PG101, SHEET 1. RT AUX PIT ON P6 MN SDR UALA2013030401286Pump · faultyCREW REPORTED RIGHT HYD SYSTEM PRESS LIGHT ILLUMINATED, WITH RIGHTT HYD SYS PRESS EICAS MSG. ALSO RIGHTT HYD DEMAND PUMP LOW PRESS LIGHT ILLUMINATED IN AUTO. SWITCHED TO "ON", NO HELP. RIGHT ENGINE HYD PUMP LOW PRESS LIGHT NEVER ILLUMINATED. RIGHT HYD QTY SDR UALA2013012500458Gcu · faultyFLIGHT ATTENDANT ADVISED COCKPIT INFLIGHT THAT CHATTER HEARD FROM E-E BAY ON TAKEOFF ROLL. NO INFLIGHT RECUR. BEFORE TAKEOFF, THEY LOST BOTH SLIDING WINDOW HEAT AND PITOT TUBE HEAT. EXACT PITOT TUBE UNRECALLED. ACCOMPLISHED BPCU BITE REF MM, RT PWR CHANNESDR UALA2012122707426Battery · faultyAPU FAULT LIGHT ILLUM WITH APU RUNNING. REPLACED MAIN AC BATTERY, OP CHECKS GOOD.SDR UALA2012122407376Brake · draggingFORWARD INBOARD BRAKE ON RIGHT SIDE DRAGGING. ALL BRAKE TEMPS NORMAL. ACCOMPLISHED BRAKE OPERATION TEST PER FIM CODE 32-41-13 AND ALL BRAKES RELEASE NORMALLY. JACKED RT FWD MAIN GEAR AND ACCOMPLISHED MULTIPLE BRAKE SET-RELEASED CYCLES AND BOTH FWD BRAKES RESDR UALA2012121407244Light · inoperativeCEILING EMERGENCY LIGHT AT SEAT 10JK IS INOP. RELAMPED, CHECKS GOOD.SDR UALA2012121407243Light · inoperativeEMERGENCY ESCAPE PATH LIGHTS AT 19J, 34J, 35J A ND 38B ARE INOP. RELAMPED, CHECKS OK.
Back to N647UA