N226UA
Service difficulty reports · 154
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 = 'N226UA' 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 = 'N226UA' 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 CALA2016022995180Battery Pack · failedDOOR 3 RT M33404 FWD EMER LIGHT BATTERY CAPACITY CHECK FAILED. REPLACED DOOR 3 RT M33404 FWD EMER LIGHT BATTERY PACK & CARRIED OUT OPERATIONS TEST, FOUND NORMAL IAW AMM.SDR CALA2016022995179Battery Pack · failedDOOR 3 LT M33405 AFT EMER LIGHT BATTERY CAPACITY CHECK FAILED. REPLACED DOOR 3 LT M33405 AFT EMER LIGHT BATTERY PACK & CARRIED OUT OPERATIONS TEST, FOUND NORMAL IAW AMM.SDR CALA2016022995178Battery Pack · failedDOOR 4 LT M33407 FWD EMER LIGHT BATTERY CAPACITY CHECK FAILED. REPLACED DOOR 4 LT M33407 FWD EMER LIGHT BATTERY PACK & CARRIED OUT OPERATIONS TEST, FOUND NORMAL IAW AMM.SDR CALA2016022995177Battery Pack · failedDOOR 2 RT M33098 AFT EMER LIGHT BATTERY CAPACITY CHECK FAILED. REPLACED DOOR 2 RT M33098 AFT EMER LIGHT BATTERY PACK & CARRIED OUT OPERATIONS TEST, FOUND NORMAL IAW AMM.SDR CALA2015021293125Oven · dirtySLIGHT ELEC SMELL IN MID GALLEY ON APPROACH MM 05-51-50. OPERATED MID GALLEY OVENS, CHILLERS, ALL ACFT LIGHTS, ENTERTAINMENT SYS & REMOVED CTR GALLEY CEILING PANELS. THE ONLY SMELL WAS FROM OVEN R32, SPILLED FOOD AT BOTTOM OF OVEN. NO ELEC SMELL DETECTED. SDR CALA2014122392848Outflow Valve · malfunctionedAIRCRAFT RETURNED TO THE FIELD DUE TO BEING UNABLE TO PRESSURIZE. RECONFIGURED AFT OUTFLOW VLV TO 0.07 OPEN, PRESSURIZED ACFT TO 1.5 PSID AMM 05-51-24 REFERS. ALL CHECKED GOOD. ALTHOUGH NO DEPRESSURIZATION OCCURRED, PERFORMED CONDITIONAL GVI DESCRIBED AT 05SDR CALA2014081491986Warning System · false activationDOOR FLIGHT LOCK 4L NR 4 LT PAX ENTRY DOOR FLIGHT LOCK COMMAND FLIGHT LOCK RELAY SENSOR DISAGREEMENT. STATUS MSG 5211340, MSG-5212250 & MSG-5212240. CLEARED MSG MX PAGE & ACCOMPLISHED FLIGHT LOCK CONTROL TEST TASK 52-11-26-740-801. TESTED GOOD, FLIGHT LOCK SDR CALA2014031990611Unknown · odorBURNING ELECTRICAL ODOR AFT GALLEY.SDR CALA2014030390501Computer · malfunctionedSTATUS MESSAGE DISPLAYED ON EICAS AFDC C & NO LAND 3. MX MESSAGE 22-18802 SHOWN AS ACTIVE, NEED AFDC C MR22412. REPLACED C AFDC IAW AMM 21-11- 01. SOFTWARE CHECKED CORRECT. MESSAGE CLEARED, AIRCRAFT RETURNED TO AUTO LAND 3 STATUS.SDR CALA2014011590161Satcom · inoperativeAIR RETURN DUE SATCOM INOPERATIVE.SDR CALA2013122393898Wire · brokenPRE DEPARTURE STATUS RECIRCULATING FAN SHOWN. FOUND W5164-1021-20 BROKEN ABOUT 3 FEET FROM CONNECTOR DB21251 ON LT LOWER RECIRCULATING FAN. REPAIRED WIRE IAW SWP 20-15-26. TEST PASSED IAW AMM21-25-07, MESSAGE CLEARED.SDR CALA2013120993533Sdu · faultyCREW REPORTS SATCOM EICAS MESSAGE. UNABLE TO RESET & NO AVAILABILITY TO LOG OFF OR ON, ON SATCOM PAGE. SDU FAULT ON MAT, REPLACED SATELLITE DATA UNIT, OPERATIONS CHECKED NORMAL.SDR CALA2013120993532Starter · inoperativeSTATUS APU CONTROL, MX MESSAGE 49-10760. ELECTRIC STARTER INOPERATIVE. APU WILL START BY AIR, APU USEABLE.SDR CALA2013111993049Rub Strip · damaged2 CEILING RUB STRIPS DAMAGED IN FWD CARGO COMPARTMENT AT THE ENTRY DOOR. PERFORMED INTERIM REPAIR IAW ECRA 2552-01153. PARTS NEEDED, TWO EACH 120- 0091, 453W1009-11, IAW IPC 25-52-09-002A ITEM 335, DRAWING 453W1100 SHEET 13. PARTIALLY REMOVED FWD PIT CEILINSDR CALA2013111492920Fuel · leakingFUEL LEAK FOUND ON ENG NR 2 DRAIN MAST. RT ENG SN 222001, INVESTIGATE TYPE OF FLUID & LEAK RATE, IAW AMM 71-71-00 601 FOR ENG DRAINS LEAK RATE LIMITS, IDENTIFY LEAKY DRAIN, CONTACT TOMC WITH FINDINGS. FUEL COMING FROM NR 11 DRAIN. CREW RAN NR 2 ENG CHECKED SDR CALA2013111292834Lens · brokenIAW LOG 3, THREE EACH FLOOR PROXIMITY EMERGENCY LIGHTS IN AFT GALLEY ARE BROKEN. LIGHTS STILL OPERATE NORMAL. REPLACED THREE EACH EMERGENCY EXIT LIGHT LENS IN AFT GALLEY, LIGHTS OPERATION CHECKED OK.SDR CALA2013111292833Lens · missingAFT GALLEY EMERGENCY EXIT LIGHTS MISSING LENS COVER. REPLACED THREE EACH EMERGENCY EXIT LIGHT LENS IN AFT GALLEY, LIGHTS OPERATION CHECKED OK.SDR CALA2013101191984Shutoff Valve · failedBLEED OFF ENG LT ENG BLEED VLV CLOSED FOR SYSTEM FAULT OR SWITCH OFF & THE ENG IS NOT SHUTDOWN. ADVISORY MSG01- LATCHED DESCENT MODE DEPENDENT. HIGH PRESSURE SHUTOFF VLV LT FAILED CLOSED. DB- AIR SUPPLY & CABIN PRESSURE CONTROLLER LT MSG02- LATCHED DESCENTSDR CALA2013092591424Shutoff Valve · failedBLEED PRESSURE SENSOR LEFT INTERMEDIATE PRESSURE SENSOR FAULTS EXIST. REPLACED SHUTOFF VALVE.SDR CALA2013092391366Connector · looseR4 DOOR INTERPHONE INOPERATIVE. ACCOMPLISHED DATABASE & QUICK TESTS, NO FAULTS. FOUND CONNECTOR D00280P ON GALLEY A 3 WHEN LOOSE.SDR CALA2013092591423Charger · faultyBATTERY STATUS MESSAGE, REPLACED BATTERY IAW 24-31-01 & MAIN BATTERY CHARGER IAW MM 24-31-02.SDR CALA2013090591017Display · inoperativeCENTER LOWER DISPLAY UNIT BLANK. REPLACED IAW MM.SDR CALA2013090290940Shutoff Valve · failedLEFT ENGINE BLEED PRESSURE REGULATING SHUTOFF VALVE FAILED OPEN OR CLOSED OR LEFT AIR SUPPLY & CABIN PRESSURE CONTROLLER FAILURE. REPLACED PRSOV CONTROLLER IAW MM. REACTIVATED PRSOV & ACCOMPLISHED OPERATIONAL TEST IAW MM. VALVE OPERATION NORMAL & NO EICAS MESSDR CALA2013081990568Connector · looseNR 2 ENG FUEL DIFFERENTIAL PRESSURE SWITCH CONNECTOR IS LOOSE. REPLACED CONNECTOR DS73001. REPLACED FUEL PUMP FILTER DIFFERENTIAL SWITCH ON NR 2 ENGINE, OFF SN CSGCB30402 AND ON SN CSGCBL7848.SDR UALA2013071204883Connector · looseNR 2 ENGINE FUEL DIFFERENTIAL SWITCH CONNECTOR IS LOOSE. REPLACED FUEL DIFFERENTIAL PRESSURE SWITCH IAW AMM, LEAK CHECKED GOOD.SDR UALA2013062404363Connector · looseNR 1 ENGINE IDG AFT UPPER CONNECTOR LOOSE, HSG ON IDG SIDE. REPLACED IDG IAW AMM. IDG OPS CHECKED GOOD.SDR UALA2013062404361Wire · chafedNR 2 ENGINE AT 3 O'CLOCK POSITION, WIRE CHAFING AGAINST CLAMP NEAR IGNITOR BOX. WIRES OK. REPLACED CLAMPS AND WRAPPED WIRES WITH FIBER GLASS TAPE AND SECURED.SDR UALA2013062404360Clamp · wornNR 2 ENGINE IDG LOWER CONNECTOR CLAMP WORN AND CAUSING WIRE CHAFING. WIRES OK, REPLACED CLAMP AND WRAPPED WIRES WITH FIBER GLASS TAPE AND SECURED.SDR UALA2013062504398Switch · malfunctionedCENTER CONSOLE RT FUEL PUMP SWITCH WILL NOT LOCK IN PLACE. REPLACED SWITCH ASSY IAW 33-13-00. GROUND CHECKED OK.SDR UALA2013052203556Wire · exposedEXPOSED WIRE ON LOWER WALL NEAR L4 DOOR. SECURED. CONDITION OK.SDR UALA2013041102496Indicator · faultyFLIGHT CREW REPORT STATUS MSG "HYD TEMP IND PRI C1". ACCOMPLISHED FIM TASK 29-11 TASK 901. REPLACED C1 ACMP TEMP INDICATOR PER MM. OPS CHECKED NORMAL.SDR UALA2013032601933Rail · brokenFOUND RAIL ANGLE BROKEN AT WELDS.SDR UALA2013032601932Amplifier · faultySATCOM HI GAIN STATUS MESSAGE. REPLACED HIGH GAIN AMP, SYSTEM TESTED NORMAL.SDR UALA2013013100574Blade · damagedREPLACED NR 1 ENGINE DUE TO 6 HPT STAGE 1 BLADES WITH BURN THROUGH INTO THE INTERNAL CAVITY IN AREA C LESS THAN 0.125 SQ INCH REF MM 72-00-00 PG 698.73. REPLACED NR 1 ENGINE.SDR UALA2013011400199Fuel · leakingNR 2 ENGINE FUEL LEAKING FROM STRUT DRAIN.SDR UALA2012110906451Connector · dirtyDURING REFUELING FOUND SLOW RATE ON CTR TK. FOUND LEFT CTR REFUEL VLV NOT OPEN MANUALLY OPENED AND CONNECTOR CLEANED THEN FUNCTION AUTO NORMAL AGAIN AUTO REFUEL ACP AND SATISFACTORY.SDR UALA2012091305184Probe · faultyDURING REFUELING FOUND RIGHT MAIN FUEL TANK QTY INDICATION INTERMITTENT BETWEEN 40,000 TO 57,000 LBS. DRIPSTICK READING CARRIED OUT. FUEL QTY MAINT PAGE SHOW TANK UNIT RIGHT MAIN 11, 12, 13 SHOW 0.0-0.8. TANK UNIT, PCN 483-0030 EXPEDITED. REPLACED FQPU, NOSDR UALA2012080904326Amplifier · faultySATCOM MESSAGE HIGH GAIN AMP. REPLACED HIGH GAIN AMP AND SDU. DID NOT REPLACE SDU. NO PART AVAILABLE AT ORD.SDR UALA2012072003951Control Valve · failedONE OF THE TWO RIGHT PACK FLOW CONTROL VALVES (FCV) ARE NOT IN COMMANDED POSITION. REMOVED AND REPLACED UPPER FLOW CONTROL VALVE, OPS CHECKED GOOD.SDR UALA2012072003950Fan · failedFOUND LWR RECIRC FAN RIGHT AT FAULT, MESSAGE 21-24700, REPLACED RECIRCULATION FAN IAW AMM, OPS CHECKED NORMAL.SDR UALA2012071203760Switch · faultyFLIGHT ATTENDANT J-S 1L FWD PHONE CRADLE NOT HOLDING PHONE. SECURED HANDSET CRADLE TRIM FOUND IN CABIN. PA PUSHBUTTON SWITCH ON CRADLE IS DAMAGED AND INOP. WILL NEED COMPLETE CRADLE ASSY REPLACEMENT. CHECKED INTERPHONE FUNCTIONS AND PA WHEN SELECTED ON HANSDR UALA2012042002371Radome · damagedON WALKAROUND FOUND DAMAGE TO NOSE RADOME. DAMAGE IS LOCATED ON LOWER LEFT RADOME APPROXIMATELY 11 INCHES BELOW CENTER LINE AND STARTS APPROXIMATELY IN LINE WITH FWD EDGE OF LIGHTENING DIVERTER. DAMAGE CONSISTS OF A DENT THAT MEASURE S 5" LONG BY 3.5" WIDE ASDR UALA2012042002350Connector · wrong partCONNECTOR M33042 AT BS 660, LBL 90, IS NON COMPLIANT PER AMM. REPLACED LIGHT ASSY, OPS CHECKED OKAY.SDR UALA2012040202045Battery · dischargedON ARRIVAL RECEIVED FLIGHT CONTROL SYS ON MAT MESSAGE 24-50241, LEFT FC BATTERY IS LOW, PER FIM 24-35 TASK 802. REPLACED BATTERY, MESSAGE EXTINGUISHED, PER MM OPERATIONAL TEST, NO FAULTS FOUND.SDR UALA2012032601907Switch · detachedJETTISON ARMING SWITCH CAME OFF. REPLACED SWITCH ASSY. VERIFIED JETTISON ARMING FUNCTIONED NORMAL.SDR UALA2012032201835Sensor · faultyEQUIP COOLING HORN IS GOING OFF WITH AN UPPER LEVEL ADVISORY EICAS EQUIP COOLING MSG. ALSO HAS AN AIR TEMP HIGH STATUS MSG WITH MAINT CODE 21-14081. ACP FIM 21-27 TASK 821, FOUND EQUIP LOW FLOW DETECTOR M21582 TO BE DEFECTIVE. REPLACED LOW FLOW SENSOR PER MSDR UALA2012032001797Controller · faulty'EQUIP COOLING' ADVISORY MSGS DISPLAYED UPPER EICAS. 'EQUIP COOLING CTRL L' STATUS ALSO. REPLACED EQUIPMENT COOLING CONTROLLER PER MM. GRN TEST AND OPS CHECK NORMAL.SDR UALA2012031301658Skin · dentedDURING WALKAROUND A DENT WAS FOUND ON THE RT HOR STAB LEADING EDGE. MAINT TEXT: MEASURE 2.5"X 1.5" DEEPTH 1-32", MAINT REPORTS DENT TO BE 2.5" WIDE BY .032" DEEP, W OVER Y =78. DENT IS LOCATED ON ZONE 2 OF LEADING EDGE, 9 FEET FROM FUSELAGE. DENT WITHIN LIMSDR UALA2012022101064Heat Shield · looseLEFT NACELLE HEATSHIELD FOUND FOUR LOOSE FASTENERS WITH SEVEN BLIND FASTENERS INSTALLED. REMOVED AFT FAIRING FWD SECTIONS FOR SEAL REPLACEMENT REF MM. REMOVED NR 1 PAN CASTING FWD SEAL.SDR UALA2012011600330Fastener · looseLEFT STRUT FAIRING FORWARD SEAL, 7 EA FASTENERS LOOSE. REMOVED 7 EACH FASTENERS. INSTALLED 7 BLIND FASTENERS. NEEDS RE-CHECKED EVERY 3SVC AND PERMANENT BY NEXT C-CHECK.
Back to N226UA