N677UA
Service difficulty reports · 332
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 = 'N677UA' 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 = 'N677UA' 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 UALA2013071604990Actuator · failedRIGHT PACK TEMP EICAS MESSAGE ON ARRIVAL. R & R RAM AIR ACTUATOR IAW AMM, NO DEFECTS NOTED.SDR CALA20130709002Computer · failedAFTER LEFT ENG START, LT EICAS COMPUTER FAILED. R & R LT EICAS COMPUTER IAW AMM. SOFTWARE LOADED, OPS CHECKED GOOD.SDR UALA2013070904783Computer · failedAFTER LT ENGINE START, LT EICAS COMPUTER FAILED. R & R LT EICAS COMPUTER IAW AMM. SOFTWARE LOADED, OPS CHECKED GOOD.SDR CALA20130708002Actuator · faultyRT PACK TEMP EICAS AFTER ENGINE START. SUPPLEMENTAL DATA UPDATE, R & R RT RAM AIR INLET DOOR ACTUATOR, OPS CHECKED GOOD.SDR UALA2013070804746Actuator · faultyRIGHT PACK TEMP EICAS AFTER ENGINE START. R & R RT RAM AIR INLET DOOR ACTUATOR, OPS CHECKED GOOD.SDR UALA2013070504702Cover · faultyOVERHEAD EXIT COVER BY SEAT 15LK IS MISSING ON ONE SIDE. ECRA 3351-0167 ACCOMPLISHED INTERIM REPAIR WITH TAPE FOR MISSING EXIT SIGN BLANKING PLATE. REPLACED EXIT COVER AT ROW 15 LT SIDE.SDR UALA2013052103509Indicator · fluctuatesDPI FLUX, RTFL R & R CABIN PRESSURIZATION INDICATOR IAW AMM. OPS CHECK NORMAL, AC OK TO CONTINUE.SDR UALA2013050903245Actuator · failedLEFT A/C PACK INOPERATIVE LIGHT ON. EICAS MESSAGE LEFT A/C PACK TEMP DISPLAYED. LIGHT DID NOT EXTINGUISH WHEN STANDBY SELECTED & RESET PUSHED. REPLACED LEFT A/C PACK RAM AIR ACTUATOR.SDR UALA2013050903260Lens · out of positionEXIT SIGN COVER FELL OFF RIGHT AISLE BETWEEN BUS & COACH. REPLACED LENS.SDR UALA2013050203066Warning System · false activationLEFT ENGINE FUEL FILTER BYPASS IND, RTFL. REF FAULT ISOLATION MAINTENANCE MANUAL 73-34-00 PG 101. RAN ENGINE PER JRH2-6-1 PER 2 MINUTES. NO LEAKS FOUND & NO FUEL FILTER BYPASS INDICATION.SDR UALA2013032801987Slide · warning lightLEFT WING SLIDE EICAS ILLUMINATED. REPLACED LEFT OFF-WING SLIDE ASSY.SDR UALA2013032601926Line · leakingDURING WALK AROUND FOUND HYD LEAKAGE FROM RT WING ABOVE NR 4 MLG WHEEL. FOUND LEAKAGE FROM RT ANTI-SKID SHUTTLE VALVE MODULE LINE. RETIGHTENED LINE AND NO MORE LEAKAGE.SDR UALA2013031801626Girt Bar · obstructedDOOR 2R WILL NOT ARM. YELLOW STRAP STUCK DOWN, CHECKED GOOD, NO DEFECTS, OK TO CONTINUE.SDR UALA2013012900545Receptacle · sparksEXTERNAL POWER RECEPTACLE HAD SPARKS WHEN EXTERNAL POWER CORD FROM JETWAY HOOKED UP. INSPECTED EXTERNAL POWER PANEL INSIDE, NO DAMAGE NOTED. NO ARCING. AIRCRAFT OK FOR SERVICE. CONFIRMED WILL NEED RECEPTACLE REPLACEMENT DUE TO ERODED PINS AND DAMAGED BASE ISDR UALA2013012500459Key Pad · malfunctionedCOCKPIT ENTRY CHIME INOPERATIVE WITH NORMAL CODE. REMOVED AND REPLACED COCKPIT DOOR KEYPAD AND ATTACHING HARNESS AND MODULE. DOOR CHIME FUNCTIONALLY TESTS OKAY.SDR UALA2013011700309Accelerometer · faultedNR 2 ENGINE HIGH VIB FELT IN AIRFRAME OR THROTTLE. PERFORMED FAN LUBE AS PER 72-31-99 VIBE GOOD AT THIS TIME. ACP CK OF INLET & EXHAUST INCLUDING FAN BLADES FOR DAMAGE & MIDSPAN SHROUDS FOR SHINGLING. CHECKED VIBE PICKUP AT 1 O'CLOCK ON FAN CASE 'A' FLANGE FOSDR UALA2013011600282Seal · out of positionPIECE OF ORANGE FOD IN STATOR SECTION OF NR 1 ENGINE. FOUND 2.5 BLEED VLV SEAL AT BLEED PORT 3 O'CLOCK POSITION, REMOVED SEAL PER MM 75-32-00. EXAMINE THE FORWARD EDGE OF THE FAN EXIT LINER SEGMENTS FOR DAMAGE AT EVERY A CHECK UNTIL SEAL IS REPLACED. SEAL TSDR UALA2012121207190Fan · faultySTATUS MESSAGE BULK CARGO FAN CB P37 F7 POPPED OUT. COLLARED CB AND CHECKED BY WD 21-26-21-001 ONLY AFFECT RELATED FAN. PARTS: 563-9037 606707-1 FAN. REMOVED AND REPLACED BULK CARGO VENTILATION FAN AS PER AMM 21-26-06 OPS CHECK GOOD. NO STATUS MSG NOTED.SDR UALA2012121207175Fan · faultyVERY LOUD HOWL FROM AFT EXHAUST FAN OUTFLOW DOOR. ALSO LOUD IN AFT GALLEY. AFT EQ EXHAUST FAN 1 MSG DISPLAYED. REMOVED AND REPLACED NR 1 AFT EQUIPMENT - LAVATORY FAN IAW AMM, NO DEFECTS NOTED.SDR UALA2012113006866Antenna · inoperativeWX RADAR FAILURE, RTFL. PERFORMED FIM 34-43-00 TEST SHOWED WXR FAIL ANT. REPLACED WEATHER RADAR ANTENNA PER MM 34 -43-05. SYSTEM CHECK OK.SDR UALA2012113006865Sign · unsecureOVERWING EXIT SIGN IS HANGING DOWN ROW 21. SECURED LOOSE OVERWING EXIT SIGN AT ROW 21.SDR UALA2012111606618Light · inoperativeSEAT 2AB, 6AB, 16AB, 18KL, 21KL, AND 38KL CEILING EMERGENCY LIGHT INOP. EA BULBS REPLACED AND TEST GOOD PER AMM ON NR HRN503885.SDR UALA2012111406566Seat Track · damagedSEAT TRACK CORRODED AT RBL 88 FROM BS 586 TO BS 590. REPAIRED SEAT TRACK PER ECRA 5300-01445 ON HAECO NR HRN502309.SDR UALA2012111306526Seat Track · corrodedSEAT TRACK CORRODED AT RBL 88 FROM BS 586 TO BS 590. SEAT TRACK REPAIRED AND FASTENERS INSTALLED PER ECRA 5300-01445 ON HAECO NR HRN501053.SDR UALA2012111306524Floorbeam · corrodedFLOORBEAM UPPER CHORD CORRODED FROM BL 0 TO LBL 15 AT BS 287. MAJOR REPAIR ACCOMPLISHED: REPAIRED FLOORBEAM PER SRM 53-00-51 REPAIR 1 FIG 101.SDR UALA2012111306523Seat Track · corrodedSEAT TRACK CORRODED AT LBL 11 FROM BS 325-327. FABRICATED AND INSTALLED NEW SEAT TRACK PER SRM 51-10-02 AND 51-40-04.SDR UALA2012111306522Seat Track · corrodedSEAT TRACK CORRODED AT RBL 88 FROM BS 344 TO 347. FABRICATED AND INSTALLED NEW SEAT TRACK PER SRM 51-10-02 AND 51-40-05.SDR UALA2012111306521Seat Track · corrodedSEAT TRACK FLANGE CORRODED AT RBL 11 FROM BS 325-329. MAJOR REPAIR ACCOMPLISHED: FABRICATED AND REPLACED SEAT TRACK PER SRM 51-10-02 AND 51-40-05.SDR UALA2012111306525Light · damagedCABIN FLOOR EMERGENCY LIGHT DAMAGED. CABIN FLOOR EMERGENCY LIGHT ASSY REPLACED AND OPS CHECK NORMAL PER AMM.SDR UALA2012110606383Seat Track · corrodedSEAT TRACK CORROSION STATION 1250 TO 1273 D=.034"W=.75" L=4" & STA 1283 TO 1285 D=.032"W=.7"L=2.5 & STA 1300 TO 1314 D=..038"W=.75"L=3.5". ALL AT BL R88 TO R88. REPLACED SEAT TRACK IAW SRM AND INSTALLED NEW SEAT TRACK IAW SRM. REPLACED SEAT TRACK STA 1207 TOSDR UALA2012110606382Seat Track · corrodedSEAT TRACK CORROSION STATION 1393 T0 1408 D=.040"W=.75" L=4" & STA 1329 TO 1348 D=.035"W=.7"L=3" & STA 1363 TO 1370 D=.045"W=.75"L=3.5" & STA 1423 TO 1426 D=.032 W=.7"L=3". ALL AT BL R88 TO R88. REPLACED SEAT TRACK IAW SRM 51-10-02 AND INSTALLED NEW SEAT TRACSDR UALA2012091305172Indicator · faultyATT INDICATION OF STNDBY ATT IND IS ABNORMAL IN PITCH, ROLL, ETC. GYRO FLAG IS RETRACTED. SEE LOG BOOK FOR DETAILS. SHOWS 7 DEGREE LEFT BANK WHILE IN LEVEL LT. WORSE AFTER A TURN. REPLACED SAI PER AMM, OPS TESTED OKAY.SDR UALA2012082104654Transceiver · erraticWXR ANTENNA TILT ERRATIC. CREW COMMENTS: ANTENNA TILT DID NOT WORK IN AUTO. IN MANUAL, RETURNS DID NOT DEPICT TO CORRESPONDING TILT. REPLACED RT IAW AMM.SDR UALA2012081604566Latch · damagedLEFT INBD PYLON ACCESS PANEL AFT LATCH IS UNHOOKED. FOUND LATCH DAMAGED REPLACED LT INBOARD PYLON LATCH.SDR UALA2012072404008Transceiver · failedWEATHER RADAR INOPERATIVE. WEATHER RADAR SYS FAULT ON EICAS NO "FAIL" MESSAGE ON EADI. NO CONTROL OF RADAR BY EITHER FIRST OFFICERS OR CAPTAINS SIDE. REPLACED WEATHER RADAR TRANSCEIVER AND GROUND TESTED OK.SDR UALA2012072404007Drive Unit · failedRADAR FAILED. WEATHER RADAR STAB MOMENTARILY ON LWR LT AND VAR. WX UPPER RT PRIOR TO FAIL. NO WEATHER RADAR FAIL MESSAGES ON SCREEN WITH WEATHER RADAR SYS STATUS MESSAGE. REPLACED THE WEATHER RADAR ANTENNA DRIVE UNIT. WEATHER RADAR OPS TEST IS GOOD.SDR UALA2012072404006Transceiver · faultyWEATHER RADAR FAILS FREQUENTLY, REPLACED WEATHER RADAR TRANSCEIVER, TESTED OKAY.SDR UALA2012072404005Start Valve · faultyRT ENG STARTER EICAS. ENGINE MANUALLY STARTED. REPLACED START VALVE ASSY IAW AMM. START VALVE OPERATES OK.SDR UALA2012070303562Connector · miswiredWHILE TROUBLESHOOTING DF38, FOUND CONNECTOR NOT WIRED PER HOOK UP CHART PG 136. REPINNED CONNECTORSDR UALA2012070503584Pump · faultyREPEAT REPORT OF NR 2 CTR ACCOMPLISHED HYD PUMP PRESS LIGHT CAME ON DURING HEAVY DEMAND. SUPPLEMENTAL DATA, REPLACED NR 2TR ACMP HYP PUMP, OP'S AND LEAK CHK GOOD.SDR UALA2012070503589Transmitter · faultyFLAP AND STAB POSITION TRANSMITTER, DUE TO FLAP-STAB POSITION SENSING CIRCUIT BREAKER TRIPPING. REPLACED THE LEFT STAB POSITION TRANSMITTER M519 PER MM. REF IPC 27-48-01-001. REPLACED POSITION TRANSMITTER M519 PER MM. CIRCUIT BREAKER NOT TRIPPING.SDR UALA2012051602793Wire · brokenFOUND SEAT EMERGENCY LIGHT INOPERATIVE AT SEAT 33AB. FOUND BROKEN WIRE, REPLACED AND CHECKED ALL EMERGENCY LIGHTS INSIDE AND OUTSIDE OF AIRCRAFT. ALL OPERATED NORMALLY.SDR UALA2012051102745Battery Pack · faultyFWD CABIN RT SIDE EMERGENCY SEAT LIGHTS DIM. REPLACED BATTERY PACK, OPS GOOD.SDR UALA2012051002715Light · inoperativeFLOOR EMERGENCY LIGHT IS OUT BY LEFT AFT LAVATORY. REPLACED POWER STRIP AND LIGHT ASSY ALL CHECKED OK.SDR UALA2012051002714Battery Pack · inoperativeSEAT EMERGENCY LIGHTS ARE OUT BETWEEN SEAT 20AB AND 23AB REPLACED BATTERY PACK AND OPS CHECKED GOOD IAW MM 33-51-07.SDR UALA2012051002713Lamp · inoperativeOUTSIDE EMERGENCY LIGHT IS OUT BY L2 DOOR. RELAMP ABOVE, LIGHT OPS TESTED OK.SDR UALA2012043002567Battery Pack · inoperativeSQUIB TEST 1 AND 2 INOPERATIVE FOR EMERGENCY ESCAPE SLIDE. REPLACED LEFT AND RIGHT OVERWING EMERGENCY ESCAPE BATTERY PACKS. SQUIB TEST 1 AND 2 CHECKED NORMAL.SDR UALA2012042302438Battery Pack · inoperativeEMERGENCY LIGHTS AT SEAT ROWS 20AB TO 33AB INOPERATIVE. REPLACED BATTERY PACKS, OP CHECKED GOOD.SDR UALA2012042402476Cable · fodSEAT BACK WILL NOT RECLINE AT 24H. REMOVED DEBRIS FROM SEAT ACTUATOR CABLE.SDR UALA2012041702316Armrest · missingNO ARM REST ON 16B. UNABLE TO LOCATE ARMCAP, TAPED OVER ARMREST TO ENSURE NO PAX HAZARD EXISTS. REPLACED ARMCAP.
Back to N677UA