N212UA
Service difficulty reports · 186
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 = 'N212UA' 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 = 'N212UA' 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 UALA2010052401733Warning System · intermittentHYD PUMP DEM L LOW LT HYD DEMAND PUMP PRESSURE WHEN COMMANDED ON OR LT DEMAND PUMP OVERHEAT. STATUS MSG01- NOT ACTIVE CLIMB MODE DEPENDENT; ELCU (HYD ACMP L) IN P200 IS NOT IN COMMANDED POSITION. DB- ELMS P210 ELECTRONICS UNIT MSG02- LATCHED CLIMB MODE DEPENDESDR UALA2010051401636Seal Depressor · separatedRAMP REPORTS THAT DURING AFT CARGO DOOR CLOSURE A PORTION OF THE DOOR SEAL MATING SURFACE SEPERATED FROM THE ACFT IN THE AREA OF THE AFT HINGE. APPROX (2) INCHES IS MISSING AND 3 INCHES ON EITHER SIDE IS DISTORTED. ANOTHER (2) INCHES TORN OFF DURING OPENING OSDR UALA2010032901029Actuator · faultyAPU DOOR APU INLET DOOR IS NOT IN COMMANDED POSITION. STATUS REPLACED APU CONTROLLER. FOUND MAINT MESSAGES 149-18801, 49-14120, 49 -14110, 49-17001, 49-12990 AND FAULT CODE 49600100 ON SEVERAL LEGS, APU INLET DOOR INDICATIONS NORMAL AS SHOWN ON EICAS MAINT SDR UALA2010030800797Fire Loop · failedFIRE LOOP 2 ENG R RIGHT ENGINE FIRE DETECTION SYSTEM LOOP 2 FAILURE.SDR UALA2010022300676Panel · gougedLT OTBD LWR WING HONEYCOMB PANEL IS DAMAGED. FOUND SLAT WITH MINOR SKIN CREASE, PANEL 521ABB PUNCTURED AND LIGHT SCUFFING ON LOWER WING SKIN, PANEL NUMBER IS 521ABB. REMOVED PANEL 521ABB AND ROUTED TO SHOP 26. REMOVED AND REPLACED TAG NR R30763.SDR UALA2010012000253Transmitter · faultyUNABLE TO DETERMINE FUEL QUANTITY LOSS OF OVER 4200 LBS-800NM. FUEL FLOW TXMTR CHANGED, NEEDS LEAK AND OPS CHECK ON NR 2 ENG. ACP LEAK CHECKED, NO LEAKS DETECTED. COMPLETED FIM 28-41 TASK 825 FQIS AND FMC CHECKED GOOD. REPLACED BOTH NR 1 FUEL FLOW TRANSMITSDR UALA2009121503882Acm · faultyON APPROACH, STATUS MSG PACK ACM R. CONFIRMED ACM FAILURE. NEEDS ACM. REPLACED SEIZED ACM, OPS CHECK GOOD. ALSO FOUND LOW LIMIT VALVE BUTTERFLY DISK NOT CLOSING. REPLACED IAW MM, NO HELP. ALSO CHECKED RAM AIR INLET FOR BLOCKAGE IT WAS CLEAN. REPLACED ECONOMSDR UALA2009120803800Eec · malfunctionedRIGHT ENGINE CONTROL IS IN A TIME LIMITED DISPATCH CONDITION. ENGINE CONTROL SYSTEM IS OPERATING WITH REDUCED REDUNDANCY. REPLACED NR 2 EEC. RAN ENGINE, CK'D NORMAL. NO MESSAGES.SDR UALA2009120803799Relay · malfunctionedON SHUTDOWN HAD ENG FUEL VALVE RT EICAS MSG. ENG SHUTDOWN BUT VALVE INDICATES NOT. HAS HISTORY. REPLACED RT ENG RELAY UNIT (ERU). OPERATIONAL CK ON ENGINE RUN & ENG SHUT DOWN -- NO EICAS MSG'S & FUEL VLVS SHOW NORMAL OPEN-CLOSE POS ON FUEL PAGE SYNOPTICS.SDR UALA2009120703787Actuator · seizedAPU INOP, MGS DISPLAY APU DOOR, MAINT. MSG 49-14120. STARTED REMOVING APU INLET DOOR ACTUATOR AND FOUND ACTUATOR SEIZED, UNABLE TO EXTEND ACTUATOR MANUALLY TO ACCESS ROD END BOLT. NEED TO TORQUE BASE ASSY FASTENERS. REPLACED APU INLET DOOR ACTUATOR.SDR UALA2009100803165Freq Unit · malfunctionedDATA LINK LOST NO DATA LINKS ESTABLISHED (HF, VHF, SATCOM MODE S DATA LINKS LOST) ADVISORY. REPLACED RADIO FREQ UNIT AND SYSTEM, OPS NORMAL.SDR UALA2009092102974Heat Exchanger · leakingOIL QUANTITY (ENGINE) - LOW. NO LEAKS FOUND DRAIN MAST BUT ON A-CK VISUAL EXCESSIVE OIL FOUND INSIDE BELLY OF REVERSER COWLS, WIPED DOWN & DID IDLE RUN 2 TIMES. OIL SEEMS TO BE COMING FROM ANGLE GEAR BOX AREA. OIL PUDDLES BOTTOM OF FAN CASE (RUNS DOWN STRUTSDR UALA2009092102967Oil Cooler · leakingEXCESSIVE OIL FOUND INSIDE BELLY OF REVERSER COWLS WIPED DOWN & DID IDLE RUN 2 TIMES. OIL SEEMS TO BE COMING FROM ANGLE GEAR BOX AREA. LAST OIL SERVICE ON ARRIVAL SHOWED 10 QT CONSUMPTION. CLEANED AREA, RAN ENG NR 2. OIL PUDDLES BOTTOM OF FAN CASE (RUNS DOSDR UALA2009091802950Controller · malfunctionedNR 1 ENG PRSOV CONTROLLER IS FAULTY. REPLACED PRSOV, PERFORM OPERATION CHECK. CHECKED GOOD.SDR UALA2009081902543Actuator · faultyEICAS STATUS MSG 'L ENG SPAR VLV' DISPLAYED ON LOWER EICAS. REPLACED L ENG SPAR VALVE.SDR UALA2009081702522O-Ring · leakingFUEL LEAKING OUT OF RIGHT ENGINE DRAIN MAST, NR 9 TUBE. FOUND FUEL LEAKING AT MOST FWD STRUT FUEL LINE COUPLING. ALSO FOUND STRUT FUEL LINE, FWD CLAMP BLOCK DAMAGED. REPLACED CLAMP BLOCK AND COUPLING O-RINGS. AFTER WET MOTOR AND IDLE ENG RUN, NO LEAKS FOUNSDR UALA2009081002431Battery · faultyBATTERY CHARGER MSG LWR EICAS. REPLACED MAIN AC BATTERY. EICAS MSG CLEARED UP & BATTERY CHARGING OKAY.SDR UALA2009072302190Blade · brokenNR 1 ENG OIL PRESS & QTY ZERO, ENG SHUTDOWN. ENGINE SUFFERED A T-2 BLADE FAILURE. RESULTING UNBALANCE BROKE THE OIL TUBES LEADING TO THE OIL LOSS. ENGINE REPLACED. ACCOMPLISHED TWO CROSS COUNTRY FLIGHTS WITH NO DISCREPANCIES REPORTED.SDR UALA2009061201665Idg · leakingRIGHT IDG LEAKING 25 DROPS PER MIN RUNNING. ON SHUTDOWN THERE IS A STEADY STREAM OF OIL UNTIL SHAFT CAVITY EMPTIES. REMOVED RT IDG. CIRCUIT BREAKER 'R IDG DISC' PULLED AT LOCATION 'J2' ON P210 PANEL. REPLACED THE NR 2 ENGINE IDG. ALSO REPLACED THE IDG DRISDR UALA2009042701211Processor · faultyFUELER REPORTED, WING FUEL GAUGES BOUNCE AROUND DIFFERS FROM COCKPIT. MUST USE ALTERNATE FUELING PROCEDURES TO VERIFY FUEL. REPLACED FUEL PROCESSOR.SDR UALA2009040801021Switch · faultyNR 2 ENGINE WON'T SHUT OFF. NR 2 ENG AFTER SHUTDOWN, NOTED FUEL FLOW STUCK AT 1400. TRIED TO SHAKE CUTOFF SWITCH - NO HELP. CYCLED TO ON AND BACK TO CUTOFF, AFTER MORE THAN 30 SECONDS OFF WENT TO ZERO. THEREAFTER, SMELLED STRONG FUEL ODOR. ALSO RAMP SVC RSDR UALA2009031000719Start Valve · faultyENG START VALVE R RIGHT STARTER AIR VALVE POSITION DISAGREES WITH COMMANDED POSITION. REPLACED STARTER AIR VALVE. OPS CHECKS OK.SDR UALA2009030501398Start Valve · faultyENG START VALVE R RIGHT STARTER AIR VALVE POSITION DISAGREES WITH COMMANDED POSITION. REPLACED STARTER AIR VALVE. OPS CHECKS OK.SDR UALA2009022000569Generator · failedAPU GENERATOR FAILED. TRIED NEW GCU AND RELOADED SOFTWARE, NO HELP. REPLACED GENERATOR UNIT.SDR 2008UALA06106Pump · leakingCREW COMMENTS: HYD QTY LOW LEFT. AT 9 HOURS FLYING QTY .37 AT 8 HOURS WAS .40. UPON ARRIVAL FOUND COWLS DRIPPING WITH HYD FLUID, DRY MOTORED AND FOUND NR 1 ENGINE DRIVE PUMP LEAKING. REPLACED NR 1 ENGINE DRIVE PUMP. REPLENISHED LT HYDRAULIC SYSTEM TO FULLSDR 2008UALA03590Hydraulic System · failedLOST ENTIRE CENTER HYDRAULIC SYSTEM AT 1000 FEET ON FINAL APPROACH.SDR 2008UALA02201Processing Unit · faultedFUEL QUANTITY PROCESSOR HAS AN INTERNAL FAULT, CMC MSG 28-20050, ACTIVE. FOUND CHANNEL-L INOP, REPLACED FUEL QUANTITY PROCESSOR UNIT PER MM28-41-01-401, OPS NORMAL. AC OK FOR SERVICE.SDR 2008UALA00015Pcu · faultyDURING GRND TEST OF RIGHT FLAPERON MSG 27-16039 OCCURS. ACCOMPLISHED TEST SEVERAL TIMES WITH SAME RESULT. SUSPECT POWER CONTROL UNIT. REPLACED INBOARD FLAPERON PCA FOR RIGHT FLAPERON PER MM 27-11-12, OPS AND LEAK CK GOOD. PASSES ALL MAT TESTS. AC OK FOR SSDR 2008UALA0015Warning Message · activatedDURING GROUND TEST OF RIGHT FLAPERON MSG 27-16039 OCCURS. ACCOMPLISHED TEST SEVERAL TIMES WITH SAME RESULT.SDR 2007UALA00762Valve · stickingFLIGHT DIVERTED DUE TO RIGHT A/C PACK PROBLEM. TROUBLESHOOTING IDENTIFIED PARTIALLY OPEN PACK FLOW CONTROL VALVE. REPLACED RIGHT HAND FLOW CONTROL VALVE. A/C PACK SYSTEM OP CHECKED OK FOR SERVICE.SDR 2006UALA02300Radar · failedDUAL WEATHER RADAR FAILURE. EMERGENCY DECLARED. TROUBLE SHOOTING REVEALED THAT RADAR SCANNER WAS FAULTY. REPLACED SCANNER. SYSTEMS OP CHECKED OK. SUSPECT CONNECTOR PROBLEM WITHIN SCANNER, OR CONNECTION TO RADAR BOXES.SDR 2006UALA01889Lamp · inoperativeEMERGENCY LIGHTS INOP AT SEATS 26C & 44C. RELAMPED. TESTED GOOD.SDR 2006UALA01472Engine · making metalNR 1 ENGINE FAILED. ACFT DIVERTED TO SLC DUE TO LT ENG SURGE, EGT EXCEEDED TEMPERATURE LIMITS. METAL IN TAIL PIPE. TEARDOWN REVEALED EXTREME BURNING OF HPT STAGE-1 NOZZLE GUIDE VANES (NGVS). SEVERAL NGVS BURNED IN HALF, & REMAINDER SHOWED SIGNIFICANT OVERLSDR 2005UALA00489Coffeemaker · sparksCOFFEEMAKER ELECTRICAL SPARKING. REPEATED ARCING NEAR MID GALLEY COFFEEMAKER PWRD OFF GALLEY & LTS. CONVERSATION WITH PURSER DESCRIBES 2 INSTANCES OF FLASH FROM BELOW COUNTERTOP AFTER POWERING OFF GALLEY. EXAMINATION OF AIRCRAFT GALLEY WIRING & COFFEEMAKERSSDR 2004UALA00121Light · inoperativeEXTERIOR EMERGENCY LIGHT INOPERATIVE AT DOOR 4R. REPLACED LAMP. OPS CHECKED OK.SDR 2001UALA02469Fire Warning · false indicationONE MINUTE AFTER TAKEOFF, CREW RECEIVED AFT CARGO FIRE INDICATION. FIRE BOTTLES DISCHARGED AND FIRE INDICATION WARNING DID NOT GO AWAY IMMEDIATELY. CREW DECLARED EMERGENCY AND RETURNED TO HNL. OVERWEIGHT LANDING. UPON LANDING FIRE CREW CHECKED FOR A HEAT S
Back to N212UA