N817UA
Service difficulty reports · 128
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 = 'N817UA' 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 = 'N817UA' 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 CALA2017021300341Cleat · corrodedC2, FWD CARGO UNDER FLOOR AREA CLEAT ON FR26 AN D STR43R HAS SURFACE CORROSION. REMOVED AND REPLACED CLEAT AT FR26 STR43R IAW SRM 51-42-11 FIG 8 PGS 23-24 AND PGS 31-32.SDR CALA2017021300340Stringer · corrodedAFT CARGO STRINGER 43L IS CORRODED FROM FRAME 54 TO FRAME 56. REPAIRED PER 53-00-13 FIG 202 SHT 5.SDR CALA2015112394851Battery Pack · dischargedEMERGENCY LIGHT OPERATIONS TEST, FAILS AFT BATTERY. REPLACED AFT EMER EXIT LIGHT BATTERY PACK IAW AMM 33-51-38 PG 40. EMER EXIT LIGHT OPERATIONS TEST PASSED.SDR CALA2014040390748Connector · unsecureSEAT EMERGENCY LIGHT AT SEAT ROW 8C INOPERATIVE. LIGHT ASSEMBLY CONNECTOR SECURED UNDER SEAT. NEED UNDER SEAT HARNESS IAW IPC 33-51-09-20C ITEM 40 PCN 565-2457.SDR CALA2014030790555Warning System · activatedECAM MESSAGE APU AUTO SHUTDOWN DISPLAYED ON UPPER ECAM SCREEN, APU.SDR CALA2014011390121Computer · inoperativeDMC 1 INOPERATIVE. SWAPPED DMC 1 WITH DMC 3 & PLACED ON MEL 3163C, ALL FUNCTIONS NORMAL IAW AMM 31-63-34 PB 401, PLACARD INSTALLED.SDR CALA2013122693961Speaker · inoperativeCAPTAIN`S SPEAKER INOPERATIVE. REPLACED SPEAKER & SPEAKER SWITCH, OPERATIONS CHECKED OK.SDR CALA2013122093857Seal · peelingL1 WINDOW SEAL PEELING BACK DURING FLIGHT. CREATES NOISY ENVIRONMENT IN COCKPIT. REPAIRED L1 WINDOW SEAL IAW MT56-005.SDR CALA2013102192204Wire · brokenLGCIU 1 FAULT DISPLAYED ON UPPER ECAM SCREEN. AIRMAN SHOWS CFDS MESSAGE RT LG DOOR CLOSED PROX SNSR 26GA". REPLACE SENSOR 26GA PCN 565-1759 IAW AMM 32-31-73 PB401. TROUBLE SHOT IAW TSM 32-31-00-810-8 19-A FOUND WIRE BROKEN GOING TO PROX SENSOR 26GA CP. REPASDR CALA2013100791784Brake · sticksRT OTBD BRAKE STICKING ON TAXI. REPLACED NR 3 & 4 BRAKES IAW AMM 32-42-27.SDR CALA2013100491740O-Ring · damagedHYDRAULIC LEAK NOTED ON WALK AROUND NEAR RT WW. FOUND O-RING LEAKING IN YELLOW SYSTEM HYDRAULIC BAY, REPLACED & LEAK CHECKED GOOD.SDR CALA2013093091589Wire · shortedNR 2 ENGINE, FWD FIREX BOTTLE CONNECTOR SOCKET NR 2 WIRE SHORTED INSIDE PYLON. REPLACED WIRE 2621-3-CF20 IAW AWM 26-21-03 P0002, SHEET 1,ESPM 20-44-16 & ESPM 20-32-2 2. CHECKED CONTINUITY. WRAPPED WIRE 2621-0001-DL20 IAW ESPM 20-53-20. OPERATIONS CHECKED ISDR CALA2013093091588Wire · brokenNR 2 ENG FWD FIREX BOTTLE PRESSURE SWITCH CONNECTOR 6WE2A HAS TWO EACH BROKEN WIRES PIN 2 WIRE 2621-0002 & PIN 3 WIRE 2621-0074, FROM BASE WRITE-UP E7560E. REPLACED WIRE 2621-0002-C F20 & WIRE 2621-0074-CF22 IAW AWM 26-21-03, ESPM 20-44-16 & ESPM 20-32-22. SDR CALA2013082090597Oxygen Mask · dislodgedL1 DOOR OXYGEN MASK FELL OUT ON CLIMBOUT. SECURED MASK.SDR UALA2013070904792Sealant · peelingCAPTAIN`S WINDOW RUBBER STRIP THAT LINES ALONG FRONT PEELING OFF. REPAIRED SEALANT IAW MT 56-005. REMOVED LOOSE SEALANT. APPLIED SEALANT OVER AFFECTED AREA.SDR UALA2013070104566Tail Cone · crackedCRACK IN LT ENGINE EXHAUST TAILCONE. 5 O'CLOCK POSITION. NEXT TO PREVIOUS WELD. PERFORMED INSP OF LT ENGINE TAILCONE IAW MM. CRACK LOCATED IN ZONE 1 STOP DRILLED IAW MM. AC OK TO CONTINUE.SDR UALA2013050903264Controller · faultedNR 1 PACK OUTLET TEMPERATURE INDICATION INOPERATIVE ON BLEED SYSTEM ECAM PAGES. SWAPPED PACK CONTROLLERS 1 & 2 FOR TROUBLESHOOTING AND PROBLEM MOVED, RETURNED TO ORIGINAL CONFIG REF MM 21-61-34. PACK OPERATION IS NORMAL ONLY INDICATION ISSUE. REPLACED NR 1 SDR UALA2013050703171Gcu · no testEMERGENCY GENERATOR FAILED TEST PER EQ3022. REPLACED GCU. OPS CHECKED GOOD.SDR UALA2013041802694Rivet · shearedNR 1 ENGINE NOSE COWL INNER LIP AT 6 O'CLOCK POSITION ONE RIVET HEAD SHEARED OFF. REPLACED RIVET PER MT71-0 02.SDR UALA2013032501826Sensor · inaccurate900 LB SPLIT BETWEEN LT AND RIGHT FUEL TANKS FOR NO KNOWN REASON. REPLACED RT WING CARDENSICON, PER MM 28-42-16-000-001-A AND MM 28-42-16-400-001-A. OPS CHECK GOOD, BITE CHECK GOOD. INITIAL FAULT FOUND ON CFDS.SDR UALA2013031101412Actuator · failedSEAT ROW 12 ABC OXYGEN DROP CHECK FAILED. INSTALLED NEW O2 MASK ACTUATOR PER AMM, OPS CHECKED NORMAL.SDR UALA2013031101411Actuator · failedSEAT ROW 20 BC EMERGENCY MASK DROP CHECK FAILED. INSTALLED NEW MASK DROP ACTUATOR PER AMM. OPS CHECKED NORMAL.SDR UALA2013022501118Strap · missingCOCKPIT CRASH AXE IS MISSING SECURING STRAP. INSTALLED MISSING STRAP, OP'S CHECKED GOOD.SDR UALA2013020700754Handset · inoperativeCABIN INTERPHONE INOPERATIVE. INSTALLED NEW HANDSET. SYSTEM OPS GOOD.SDR UALA2012110506327Seal · leakingG RSVR LO LEVEL DISPLAYED ON UPPER ECAM SCREEN. HYD, REPLACED O-RING SEAL ON H/P MANIFOLD GREEN SYSTEM CHECK VALVE PER AMM. LEAK CHECKED VALVE, PRESSURIZED FLIGHT CONTROLS, CYC FLIGHT CONTROLS. ACP ENGINE RUNS. NO LEAKS NOTED.SDR UALA2012100305609Oxygen Bottle · missingOXYGEN BOTTLE MISSING USED AT AFT CABIN. REPLACED BOTTLE AND O2 MASK.SDR UALA2012081404512Sliding Window · damagedCAPTAIN'S SLIDING WINDOW'S VISIBILITY IS AFFECTED BY DEFECTS, NEED TO EVALUATE CONDITION. DELAMINATION ALSO AT RT SIDE AND BOTTOM. VISIBILITY NOT AFFECTED. CHECKED DIMENSIONS OF DELAMINATED AND FOUND MAX AREA B DIMENSION TO BE JUST UNDER 3.0 INCHES WHICH ISSDR UALA2012073004109Computer · faultyELAC 1 PITCH FAULT DISPLAYED ON UPPER ECAM SCREEN. ATTEMPTED SEVERAL RESETS, NO JOY. REPLACED NR 1 ELAC REF AMM. ACCOMPLISHED LAND VERIFY TEST, ALL PASS.SDR UALA2012070503615Igniter · faultyIGN B FAULT DISPLAYED ON UPPER ECAM SCREEN. REMOVED AND REPLACED BOTH ENGINE IGNITORS REF MM. OPS CHECKED REF MM. OPS CHECKED GOOD. NO MESSAGES ON UPPER ECAM.SDR UALA2012062203327Sdac · malfunctionedGREEN HYD LOW, FLIGHT DIVERTED. REMOVED AND REPLACED SDAC 2 PER AMM. OPS CHECK GOOD NO FAILURE NOTED. AFTER SEQUENCING DOORS, FOUND GREEN HYD SYST TO BE OVERSERVICED. PERFORMED QUICK SERVICE TO DRAIN SYSTEM TO PROPER LEVEL.SDR UALA2012060103055Cover · missing2L EMERGENCY LIGHT COVER MISSING. REPLACED AFT FLIGHT ATTENDANT PANEL, ALL OPS NORMAL.SDR UALA2012051102751Life Vest · missingINFANT LIFE VEST MISSING. REPLACED INFANT VEST.SDR UALA2012050802658Pressure Switch · failedGREEN HYDRAULIC SYSTEM FAILURE. DECLARED EMERGENCY CONTINUED TO DESTINATION. REPLACED GREEN SYS PRESSURE SWITCH.SDR UALA2012032901963Slat · damagedRIGHT NR 3 SLAT HAS BIRD STRIKE MID SPAN AT LEADING EDGE. REMOVED NR 3 RT SLAT REF MM 27-84-65 SFCC-1 NUMBERS FROM AIDS ARE LT APPU. 001.1 00CHEX FPPU 359.9 FFFHEX RT APPU 001.1 00CHEX.SDR UALA2011111506250Fan · failedLAV-GALLEY FAN FAULT ON UPPER ECAM. OK TO DEFER PER MEL 2123A MEL CW. SYSTEM TEST FAILED WITH EXTRACTION FAN 1HU AT FAULT, NO PART IN SEAL. PART IS: 565-0036. REPLACED EXTRACTION FAN, OPS CHECKS NORMAL.SDR UALA2011083104678Control Valve · faultyA-C PULLS RT ON TAXI. MUST HOLD APPROX 10DEG LEFT TILLER TO GO STRAIGHT. MAINT TEXT: REPLACED BOTH NOSE TIRES. STILL PULLS TO THE RIGHT. TRIED LT RUDDER TRIM 10.0 NO DIFF. BOTH RIGHT BRAKES GOT TO 300 DEGREES WITH LITTLE USE. REPLACED STEERING SERVO CONTSDR UALA2011071703616Connector · damagedNO GPS 2 INFORMATION DISPLAYED ON GPS MONITOR. REPLACED GPS 2 ANTENNA, NO HELP. FOUND GPS#2 COAX CABLE TO ANTENNA OPEN. UPPER ANTENNA CONNECTOR BAD, WORKING TO REPAIR. NR 2 GPS ANTENNA CONNECTOR WAS REPAIRED AND RETURNED GPS BACK TO SERVICE.SDR UALA2011062403113Windshield · leakingHIGH PITCHED SQUEAL FROM F/O SIDE. QUIETER AT LOW ALTITUDES. REMOVED WINDSHIELD. CLEANED MATING SURFACES. RE-INSTALLED WINDSHIELD.SDR UALA2010120204434Lens · brokenEMERGENCY EXIT LIGHT BROKEN NEAR FWD CLOSET DOOR 1L. REPLACED LENS ASSY.SDR UALA2010101803851Windshield · damagedLOUD CONTINUOUS WHISTLE RT SIDE COCKPIT. REPLACED RT WINDSHIELD. NOISE INTERFERED WITH RADIO COMMUNICATION. STARTED REMOVAL OF RIGHT WINDSHIELD. CB'S PULLED. REMOVED OLD WINDSHIELD, CLEANED BOLTS AND FRAMES. REPLACED RIGHT WINDSHIELD.SDR UALA2010061002025Floorbeam · crackedFLOORBEAM Y254 IS CRACKED ABOUT 2" NEAR CROSSBEAM 35. MAJOR REPAIR ACCOMPLISHED: REMOVED DAMAGED FLOORBEAM SECTION. FABBED NEW SPLICE PLATES AND DRILLED NEW FLOORBEAM. INSTALLED REPAIR PARTS.SDR UALA2010012100258Pump · failedYELLOW SYS HYD LOSS, RTFL. REPLACED HP FILTER ELEMENT. NO EVIDENCE OF DEBRIS. TROUBLESHOT OVERHEAT PROBLEM AND FOUND BAD CHECK VALVE 3083G. REMOVED DEFECTIVE CHECK VALVE. REPLACED AND PERFORMED HIGH POWER RUN FOR 25 MINS. REPLACED TEMP TRANSMITTER 3381GRSDR UALA2009102203297Slat · damagedRIGHT L/E INBOARD, NEXT TO PYLON HAS BIRD STRIKE. DENT DAMAGE NOTED. MEASURED AT 5 INCHES BY 2.5 INCHES, 3-8 INCHES DEEP. REMOVED SLAT AND ROUTED TO SHOP. REPLACED NR 1 SLAT.SDR UALA2009072002117Hinge Fitting · migratedL1 DOOR UPPER HINGE MIGRATED OUT OF FITTING. REMOVED AND REPLACED L1 DOOR AND REPLACED HINGE FITTINGS. ADJUSTED DOOR AFTER INSTALLATION AND INSPECTED.SDR UALA2009071702107Structure · dentedRT SIDE LWR FUSELAGE HAS SMALL DENT FWD OF FR15, BELOW AND AFT OF RT FWD AVIONICS DOOR. MAJOR REPAIR ACCOMPLISHED. INSTALLED DOUBLER REPAIR.SDR UALA2009070601944Tape · looseAIRFRAME VIBRATION. RTFL. AT FL 240 AND 320 KTS FELT VIBRATION IN FLOOR & THRU RUDDER PEDALS, FLT ATTENDANTS ALSO FELT VIBRATION. SLOWED TO 270KTS & VIB STARTED TO DIMINISH & AT AROUND 250 KTS VIBRATION CEASED, NO FURTHER PROBLEMS DURING DESCENT. FOUND TAPSDR UALA2009052601495Pump · faultyGREEN SYSTEM LOW PRESSURE MESSAGE FOLLOWED BY LOSS OF GREEN HYD QUANTITY. FLIGHT DIVERTED, REPLACED NR 1 ENG DRIVEN PUMP. REPLACED ENGINE CASE DRAIN FILTER AND GREEN SYSTEM LOW PRESSURE FILTER. CASE DRAIN LINE NR 1 ENG HAD A SMALL HOLE. REPLACED LINE.SDR UALA2009031600797Unknown · malfunctionedLGCIU1 AND 2 FAULTS, UNABLE TO RETRACT GEAR. RTFL. REPLACED 24GA AND 25GA AND ADJUSTED. JACKED ACFT NOSE OPERATED NOSE GEAR. OPERATION NORMAL.SDR UALA2009020200354Power Supply · dischargedEMERGENCY LIGHT SYS TEST FAULTS 'BATTERY FWD L' CIDS MSG. REPLACED EMERGENCY POWER SUPPLY UNIT AND BATTERY PACK.SDR UALA2009012600273Wire Harness · shortedEMERGENCY LIGHT TEST FAILED SHOWING UNIT AFT L FAULT. FOUND UNIT FAULT ON EPSU. WHEN NEW EPSU WAS INSTALLED THE INTERNAL EXTERNAL LIGHT WAS FLASHING SAYING SHORT TO GND. EXAMINED ELE PLUG 13WLA FOUND BROKEN BACK SHELL AND NUMEROUS EXPOSED BARE WIRES. SUSPE
Back to N817UA