N229UA
Service difficulty reports · 151
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 = 'N229UA' 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 = 'N229UA' 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 UALA2011072503794Structure · damagedDAMAGE TO LT WING L/E OTBD. REMOVED AND REPLACED BULLNOSE PANEL. NR 1 L/E SLAT IS DAMAGE. REPLACED NR 1 L/E SLAT.SDR UALA2011042602031Fmu · leakingOIL LOSS & FUEL LEAK NR 2 ENG FMU HAS FUEL LEAK AT WEEP HOLE ON "PF" PORT, FUEL PUMP HAS BOLT THAT WILL NOT TIGHTEN ON COVER PLATE 7:00 POSITION ON PUMP. REPLACED FUEL PUMP PER AMM AND FMU PER AMM. OIL QTY LOW. RT ENG OIL QTY AT 12. ALL CHIP DETECTORS OK, SDR UALA2011011400235Bottle · low pressureBOTTLE 1A CARGO STATUS MESSAGE DISPLAYED (MM MESSAGE 26-40010). FOUND CARGO FIRE EXT BOTTLE 1A WITH LOW PRESSURE INDICATION. NEEDS BOTTLE REPLACEMENT. MEL PROCEDURES COMPLIED WITH INCLUDING LLCR AREA DEACTIVATION. LLCR AREA MUST NOT BE USED.SDR UALA2011010400051Isolation Valve · faultyRIGHT BLEED ISOLATION VALVE NOT IN COMMANDED POSITION. STATUS MSG-3610430 LATCHD TA MODE. POSITION INDICATION WAS BLANK ON MFD CH 36 PAGE FOR RT ISOLATION VALVE, ALSO SHOWS OPEN WHEN VALVE WAS CLOSED, SUSPECT RVDT FAULTY. REPLACED RT VALVE.SDR UALA2011010400050Amplifier · faultyCHRONIC SATCOM TROUBLESHOOTING. REPLACED HIGH POWER AMPLIFIER. OPS GOOD.SDR UALA2010122204683Isolation Valve · faultyBLEED ISOLATION VALVE RT (MSG 36-10410). VALVE OUT OF TOLERANCE. REPLACED RT ISOLATION VALVE. OPS ARE GOOD.SDR UALA2010110304083Actuator · leakingLT ENGINE THRUST REVERSER ACTUATOR LEAKING HYD FLUID. ENG 1 REVERSER DEACTIVATED IAW MEL 7831B. REPLACED OTBD SYNC LOCK, NO LEAKS NOTED.SDR UALA2010102003884Sdu · intermittentSATCOM INTERMITTENT. LOG ON WITH INTERMITTENTLY ON ARRV, RERACK RFU, REPLACED SDU AGAIN AND OPS CHECKED NORMAL.SDR UALA2010100703720Wire · unsecureSATCOM VOICE PORTION OF SATCOM FAILS. ADVISORY MSG04- NOT ACTIVE CRUISE INTERMITTENT; HIGH POWER AMPLIFIER FOR HGA (LT) HAS NO INPUT FROM RADIO FREQUENCY UNIT (LT) ON TRANSMIT RF CABLE. DB- SATELLITE DATA UNIT (LT) MSG-2360041 INACTV CL INTER MSG-2368893 INACSDR UALA2010091403416Defog System · openWHC LT SYS TEST FAILED. MESSAGE 30-24031 ACTIVE AND HARD IN FAULT HISTORY CONSECUTIVELY FOR THE LAST 35 LEGS. TROUBLE SHOT REF FIM 30-41 TASK 829. CONTROLLER NO HELP. SENSOR ANTI-FOG (A14) RINGS OUT OPEN. REF WD30-41-01. REF COA 209431. STARTED INSTALLING NSDR UALA2010090903342Amplifier · failedSATCOM HI GAIN SATCOM HIGH GAIN IS FAILED. REPLACED HPA. MSG NOT ACTIVE AND OCCURRED INTERMITTENT ONCE. ACCOMPLISHED GROUND TEST AND BITE CHECK. NO FAULTS NOTED.SDR UALA2010090703271Precooler · crackedNUMBER 1 ENGINE BLEED PRECOOLER CRACKED. NR 1 ENG BLEED AIR PRECOOLER LH LOWER BROKEN, LEAKING HOT BLEED AIR SEVERELY. REPLACED WITH NEW PRECOOLER BY OSV-AMECO-056269, NO LEAK FOUND.SDR UALA2010081202942Amplifier · faultySATCOM VOICE AND DATA INOP MSG 23-60061 LOW GAIN AMP INTERMITTENTLY INOP. RESET CB AND GND TEST PASS BUT DUE TO HISTORY SUGGEST TO REPLACE LOW GAIN AMP. FOUND ALL SATCOM UNITS IN CEILING RACK COVERED WITH DUST. CLEANED. INSTALLATION TEST WAS OK. REPLACED HIGSDR UALA2010080602864Transceiver · out of tolerancePORTABLE VHF TRANSCEIVER AT A3 GALLEY IS SET TO EXPIRE. TRANSCEIVER IS LOSING VIABILITY. REPLACED TRANSCEIVER AT A3 GALLEY. OPS NORMAL.SDR UALA2010080602868Lamp · inoperativeEMERGENCY LIGHT OUT AT SEAT 22G. RELAMPED, OPS CK GOOD.SDR UALA2010080602869Controller · faultyBLEED FAMV L STATUS MSG. LOCKED VALVE IN OPEN POSITION. FOUND MAINT MSG 36-10521, ACCOMPLISHED FIM 36-11 TASK ON THE STEPS 5 AND 6 CONFIRMED 22VDC AT CONNECTOR DM36117B PINS 2 AND 3. NEED TO REPLACE HIGH PRESSURE FAN AIR CONTROLLER. REPLACED HPFAC. OPS CK OK.SDR UALA2010061002026Modulating Valve · faultedBLEED FAMV R RT ENGINE BLEED FAN AIR MODULATING VALVE (FAMV) FAILED OPEN OR CLOSED, OR RT AIR SUPPLY AND CABIN PRESSURE CONTROLLER FAILURE. STATUS MSG-3610320 LATCHED TA MODE MSG-3610340 LATCHED TA MODE NO PARTS SEATTLE SUSPECT CONTROLLER OR MUSCLE AIR FILTERSSDR UALA2010060101861Smoke Detector · failedSMOKE DETECTOR IN FLIGHT CREW REST AREA LOWER BUNK FAILS ALL TEST. REPLACED DETECTOR IN LOWER BUNK. ALL TEST NOW PASS.SDR UALA2010041301250Generator · faultyLT ENGINE BACKUP GENERATOR FILTER BLOCKED MESSAGE ON MAINT PAGE. DPI POPPED, ALSO LEAKING OIL BY HSG. REPLACED IAW AMM. RAN ENGINES, BUG HELD LOADS, RESERVICED. BUG CHECKED NORMAL.SDR UALA2010040601149Video Display · faultySEAT 11D, E & F THE VIDEO & AUDIO INOP. CREW SMELLED SMOKE IN THAT AREA BEFORE TAKEOFF. MAINT CKD BUT DIDN'T FIND OR SMELL ANYTHING. FOUND VDB ITSELF SMELLED A LITTLE, REPLACED VDB AND VIDEO WORKS BACK TO NORMAL. SMELL DID NOT OCCUR WHILE ON GROUND.SDR UALA2010012500309Shutoff Valve · faultyAT ABOUT 45W OVER ATLANTIC, LT PACK DROPPED OFFLINE. REPLACED LOWER FLOW CONTROL AND SHUTOFF VALVE, OPS OK.SDR UALA2010011100143Cooling Fan · faultyEQUIP COOLING FAN RT STATUS MSG. DEACTIVATED RT EQUIP COOLING FAN. REPLACED FAN. OPS CKS NORMAL.SDR UALA2009121803912Transmitter · malfunctionedOIL QUANTITY (ENG) - LOW. LT ENG OIL QTY BELOW LIMIT. VISUALLY CONFIRMED LT OIL QTY FULL. MASTER CHIP DET CHECKED NO CONTAMINATION NOTED, OIL CONSUMPTION AVG 0042, NO ENG OIL LEAK NOTED, IND AT COCKPIT 13QT. CLEANED CONNECTOR, NO HELP. 25 QTS INDICATED BEFOSDR UALA2009111003513Anti-Ice Valve · stuckNR 2 ENG ANTI-ICE VALVE STUCK, FLT DIVERTED. VISUALLY INSPECTED RT ENG EAI TUBING FOR DAMAGE. REPLACED R-ENG EAI VALVE AND EAI VALVE CONTROLLER. OP CHKS NORMAL.SDR UALA2009090202751Unknown · odorF/A'S REPORTED SLIGHT ACRID ODOR FROM FWD SECTION OF BC CLASS. ODOR DISSIPATED AFTER A SHORT PERIOD OF TIME. MAINT TO CHECK P210 PANEL FOR SIGNS OF FAULT AND REFER TO 777 MT 24-023 R1. SAMC-TUNG SAMC TEXT: HARD FAULT MM MSG 24-18802, CHECK FIM TASK 24-09 TASDR UALA2009082402604Eec · defectiveENG EEC C1 L LEFT ENGINE CONTROL IS IN A TIME LIMITED DISPATCH CONDITION. ENGINE CONTROL SYSTEM IS OPERATING WITH REDUCED REDUNDANCY. STATUS MSG01- ACTIVE CRUISE MODE DEPENDENT; EEC PERMANENT MAGNET ALTERNATOR (L ENG, CH B) WINDING IS INOPERATIVE. DB- ELECSDR UALA2009071002020Controller · failedRIGHT ENG BLEED FAULTMSG "BLEED OFF ENG R". REPLACED RT ENG HPSOV, NO HELP. FOUND HPFAC BAD PER ENGINE AIR SUPPLY VALVES OPERATIONAL TEST. REPLACED HPFAC, OPS CHECK GOOD.SDR UALA2009070901975Light · inoperativeEXTERIOR EMERGENCY LIGHT AT 2L INOPERATIVE. RELAMPED EMERGENCY LIGHT.SDR UALA2009051901419Unknown · odorOIL SMELL IN CABIN. FLT DIVERTED.SDR UALA2009051901420Light · missingONE OF EEL LIGHT MISSING AT SEAT 2F. REPLACED MISSING EEL LIGHT AT 2F. OPS NORMAL.SDR UALA2009051301351Idg · failedELEC GEN SYS L IDG AND GCB DISCONNECTED. REPLACED GCU AND RAN ENGINE. IDG CHANGE REQUIRED. REPLACED LEFT IDG.SDR UALA2009050701312Light · missingONE OF EEL LIGHT MISSING AT SEAT 2F. REPLACED NR 2F SEAT EEL, OKAY.SDR UALA2009041001040Controller · malfunctionedL ENG ANTI-ICE VLV MSG. FLIGHT DIVERTED. REPLACED COWL THERMAL A/I CONTROLLER. COWL THERMAL ANTI-ICE VALVE ASSY & AIRFOIL & COWL ICE PROTECTION SYSTEM CONTROL CARD ASSY.SDR UALA2009020500396Idg · faultyNR 2 IDG FILTER BLOCK MSG AND DELTA P INDICATOR POPPED. REPLACED NR 2 IDG, OPS OK ON ENG RUN, NO LEAKS NOTED.SDR UALA2008120806785Battery · faultyAPU BATTERY STATUS MESSAGE. REPLACED APU BATTERY.SDR UALA2008112606673Engine · making metalMETAL IN NR 1 ENGINE CHIPS AND OIL SCREEN.SDR 2008UALA05609Light · missingSEAT 1F MISSING AFT EMERGENCY PATH EXIT LIGHT ASSY. REPLACED LIGHT ASSY, OPS NORMAL.
SDR 2008UALA03456Eec · malfunctionedENGINE EEC C1 L LEFT ENGINE CONTROL IS IN A TIME LIMITED DISPATCH CONDITION. ENGINE CONTROL SYSTEM IS OPERATING WITH REDUCED REDUNDANCY. STATUS MSG-7361081 INACTV ER INTER, MAINT MESSAGE 73-61081 PRESENT T-3 THERMOCOUPLE PROBE. MSG NOT ACTIVE, INTERMITTENT.SDR 2008UALA02922Stator · crackedNR 1 ENG FOUND 1EA 9TH STG COMPRESSOR VANE CRACKED COMPLETELY THRU VIEWED FROM CONVEX SIDE. PER THE RECOMMENDATIONS OF MANUFACTURER ALL OPERATORS WIRE PW4000/72-35-25/CTS:ERC:08-5-08-1, PERFORMED A BORESCOPE INSPECTION OF THE SUBJECT ENGINE TO CHECK FOR HP COSDR 2008UALA02625Relay · faultyFOUND MSG 24-13783, ALSO APU BATTERY WILL NOT DROP BELOW 31 VOLT. REPLACED RELAY. MSG CLEARED. AC OK FOR SERVICE.SDR 2008UALA00275Connector · disconnectedEXIT PATH LIGHTS 2E-12F. FOUND CONNECTOR UNPLUGGED. RESECURED.SDR 2007UALA04247Bleed Air Sys · unknownLEFT ENGINE BLEED PROBLEM. REPLACED UPPER FLOW CONTROL ISOLATION VALVE. OP CHECKS GOOD & AIRCRAFT RETURNED TO SERVICE.
SDR 2007UALA02125Charger · faultyAT DEPARTURE MAIN BATTERY CHARGER MESSAGE. [07-17-07] REPLACED MAIN BATTERY CHARGER PER MM 24-31-02 . SUSPECT INTERNAL SHORT IN CHARGER.SDR 2007UALA00392Switch · failedWHILE PERFORMING EVAC TEST AT DOOR 4R WITH EVAC TEST SWITCH, THE EVAC LIGHT AND HORN FAILED TO RETURN TO NORMAL MODE. REPLACE EMERGENCY EVAC ALARM SWITCH, RETEST PER MM 25-63-02, P201. TEST OK.SDR 2007UALA00339Skin · nickedA NICK WAS FOUND ON FUSELAGE SKIN, STA 432, ABOUT .600 INCH INBOARD OF STR 47R. TECHNICIAN DRILLED OUT NICK, ACCOMPLISHED HEFC INSP, NO OTHER CRACK DISCOVERED. ACCOMPLISHED REPAIR PER SRM 53-00-01. A/C READY FOR SERVICE. SUSPECT DAMAGED RESULTED FROM CONTASDR 2006UALA02299Engine · failedNR 1 ENGINE STALLED IN STEADY STATE CRUISE. ENGINE REPLACED AT SFO. SHOP TEARDOWN REVEALED FOD DAMAGE IN THE FORWARD STAGES OF THE HP COMPRESSOR. ONE 8TH STAGE COMPRESSOR BLADE HAD FRACTURED IN THE AIRFOIL 1/2" ABOVE THE PLATFORM. THERE WAS A SHARP NICK ATSDR 2005UALA00281Flapper Valve · damagedDAMAGED ASPIRATOR FLAPPER VALVE. SLIDE/RAFT WAS REMOVED FROM AIRCRAFT AT NORMAL MAINTENANCE INTERVAL. DAMAGED ASPIRATOR FLAPPER VALVE WAS OBSERVED DURING SLIDE/RAFT MAINTENANCE. THE EXACT CAUSE OF THE DAMAGE COULD NOT BE DETERMINED.SDR 2005UALA00085Plate · distortedBOTTLE WOULD NOT FIRE WHEN THE FIRING CABLE WAS PULLED, THEREFORE THE SLIDE WOULD NOT INFLATE. SUPPLEMENTAL DATA UPDATE RESERVOIR VALVE ASSEMBLY COVER PLATE WAS PUSHED IN CAUSING PULLEY TO NOT ROTATE. REPLACED COVER PLATE AND PULLEY ASSEMBLY.SDR 2003UALA00867Light · inoperativeEMERGENCY LIGHT INOP AT SEAT 3F AFT MOST. REPLACED EMERGENCY LIGHT ASSY.SDR 2003UALA00074Light · burned outDOOR 4A EXTERNAL EMERGENCY SLIDE LIGHT INOPERATIVE. SLIDE LIGHT REPLACED. OPS CHECKED OK.
Back to N229UA