N214UA
Service difficulty reports · 165
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 = 'N214UA' 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 = 'N214UA' 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 CALA2013101191959Terminal · brokenTHREE BROKEN TERMINAL STRIPS ON BOTTOM SIDE OF MID GALLEY TABLE TOP. AFFECTED TERMINAL STRIPS ARE M25231TB02 & M25231TB03 UNDER THE FWD MID GALLEY TABLE TOP & M2532TB05 UNDER THE AFT MID GALLEY TABLE TOP. IAW WDM 25-32- 22 PG 1 SHT 2 & WDM 25-32-21 PG 1. RESDR CALA2013092691479Connector · dirtyAPU FUEL VALVE EICAS, CLEANED APU FUEL SHUT OFF VALVE CONNECTOR. MESSAGE ERASED & NO FAULT. APU OPS CHECKED OKAY.SDR CALA2013092391356Pitot Head · malfunctionedHEAT PITOT LT LOSS OF LEFT PITOT HEAT. REPLACED LT PITOT IAW MM 34-11-01. NO LEAK FOUND & GROUND TEST PASSED.SDR CALA2013081390401Switch · inoperativeWINDOW HEAT, RT SIDE LIGHT IN SWITCH INOPERATIVE.SDR CALA2013073090072Warning Light · illuminatedDOOR FLIGHT LOCK 3L, NR 3, LT PASSENGER ENTRY DOOR, FLIGHT LOCK COMMAND-FLT LOCK RELAY-SENSOR DISAGREEMENT.SDR UALA2013072505228Rod · out of adjustLAVATORY DOOR LATCH OR LOCK BROKEN. DOOR DOES NOT WANT TO LOCK FROM INSIDE. DOOR WILL LOCK FROM OUTSIDE. ADJUSTED UPPER LOCKING ROD FROM LATCHING MECHANISM. NOW OPS CHECKED GOOD.SDR UALA2013071204877Igniter · failedENGINE IGNITER R1 FAULT WITH NO START.SDR UALA2013060703975None · noneLEFT HAND TANK INBD FUELING VALVE INOP CLOSED. TRANSFERRED FUEL TANK TO TANK SEVERAL TIMES. OBSERVED NORMAL OPERATION OF LT INBD FILL VALVE.SDR UALA2013052903734Actuator · false indication"APU DOOR" STATUS MESSAGE DISPLAYED. CONFIRMED APU DOOR FULLY OPEN WITHOUT ANY STATUS MESSAGE OTHER THAN APU DOOR. MAT SHOWS POSSIBLE CAUSES AS APU INLET DOOR ACTUATOR & APU INLET DOOR CONTROL RELAY. REPLACED APU DOOR ACTUATOR.SDR UALA2013052803699Filter Element · faultyENGINE OIL FILTER SENSOR RT STATUS MESSAGE DISPLAYED DURING FLIGHT. ACCOMPLISHED TEST ON MAT, SHOWS OK, REPLACED NR 2 MAIN OIL SCREEN IAW MM. CHECKED SWITCH CONNECTOR, AND SECURED. MESSAGE WAS ERASEABLE ON MAINT PG, CLEARED MESSAGE IAW 79-98 TASKS 801. FSDR UALA2013052103514Circuit Card · failedBLEED LOOP 1 BODY FAILURE OF BODY DUCT LEAK DETECTION LOOP OR LT DUCT LEAK OVERHEAT DETECTION SYS. DISCONNECTED M26143 & M26142 ZONE 13 LOOP SEGMENTS, CLEANED AND RECONNECTED, ALSO REPLACED LEFT DLODS CARD. OPS NORMAL, NO STATUS OR CMC MESSAGES.SDR UALA2013043003029Control Panel · inoperativeFIRST OFFICER`S RADIOS INOPERATIVE. REPLACED FIRST OFFICER'S AUDIO CONTROL PANEL IAW AMM, OPS CHECK PASSED.SDR UALA2013043003026Control Panel · failedUNABLE TO RUN ALL TEST ON THE CSCP, LOCKS UP. REPLACED CSCP, OPS CHECKED GOOD.SDR UALA2013041802650Nose Cowl · dentedSHALLOW DENT ON RIGHT NOSE COWL L/E TOTAL OF FOUR DENTS ON INLET COWL LEADING EDGE, ALL SMOOTH, NO CRACKS. TWO DENTS IN THE 7:00 REGION, TWO IN 5:00 REGION, DENTS ARE SMOOTH AND NO RIVETS IMPACTED. DENTS OUT OF LIMITS IAW SRM 54-10-01.SDR UALA2013041102495Relay · failedNR 1 ENGINE CONTINUED TO RUN AFTER MOVING FUEL CONTROL TO CUTOFF, PULLED FIRE HANDLE AND ENGINE CONTINUED TO RUN FOR APPROXIMATELY ONE MINUTE, NR 1 ENGINE FIRE HANDLE LEFT IN PULLED POSITION. REPLACED FMU, LEAK CHECKED, WET MOTOR AND IDLE RUN. ENGINE SHUTDOWSDR UALA2013040902405Controller · faultedWINDOW HEAT STATUS MESSAGE. LEFT FWD RT SIDE. REPLACED WINDOW HEAT CONTROLLER M30101. OPS OKAY.SDR UALA2013040902404Fmu · faultyLEFT ENGINE FUEL VALVE WIRE CHECK, NR 1 ENGINE CONTINUED TO RUN AFTER MOVING FUEL CONTROL TO CUTOFF, PULLED FIRE HANDLE AND ENGINE CONTINUED TO RUN FOR APPROX ONE MINUTE, NR 1 ENGINE FIRE HANDLE LEFT IN PULLED POSITION. REPLACED FMU, LEAK CHECKED, WET MOTOR ASDR UALA2013040802347Fmu · leakingNR 1 ENGINE CONTINUED TO RUN AFTER MOVING FUEL CONTROL TO CUTOFF, PULLED FIRE HANDLE AND ENGINE CONTINUED TO RUN FOR APPROXIMATELY ONE MINUTE, NR 1 ENGINE FIRE HANDLE LED FT IN PULLED POSITION. REPLACED FMU, LEAK CHECKED, WET MOTOR AND IDLE RUN. ENGINE SHUTDSDR UALA2013040802346Cover · detachedEXIT LIGHT COVER DETACHED AT L1 DOOR. SECURED LIGHT COVER.SDR UALA2013041202502Connector · looseDELAY DURING LEFT ENGINE SHUTDOWN. MESSAGE ON EICAS SHOWS ENG FUEL VALVE. PERFORMED FIM73-22TSK801 SECTION E. RELAYS CHANGED. PERFORMED WIRE CONTINUITY CHECKS, INSPECTION OF WIRES AND CLAMPS. ALL GOOD. FOUND CONNECTOR DM76001C LOOSE ON FMU. SECURED, NO SDR UALA2013040802348Circuit Breaker · trippedLEFT ENGINE WILL NOT START ON PUSHBACK. SPAR VALVE CIRCUIT BREAKER FOUND TRIPPED, CYCLED LEFT ENGINE FUEL SPAR VALVE AND CYCLED VALVE. RESET AND RAN LEFT SPAR VALVE. SPAR VALVE OPS NORMAL AND BREAKER IS OK.SDR UALA2013031501579Oxygen Bottle · dischargedOXYGNE BOTTLE DISCHARGED. REPLACED OXYGEN BOTTLE AMM.SDR UALA2013031101438Module · faultyAFTER ENGINE STAR CREW HAD GROUND PROX ADVISORY MSG ALONG WITH TERRAIN SYS STATUS MSG. REPLACED CORE PROCESSOR MODULE GRAPHICS GEN. LOADED SOFTWARE, OPS CHECK OKAY.SDR UALA2013021300862Panel · delaminatedRIGHT ENGINE PANEL 425MB DELAMINATED LEFT FWD EDGE 1.5"X1.25" DRAIN EXIT PANEL.SDR UALA2013012900537Headset · inoperativeCAPTS MINITEL HEADSET INOPERATIVE. USED SPARE HEADSET. REPLACED SPARE MINITEL HEADSET IAW IPC.SDR UALA2013012500455Nut Plate · damagedFASTENER MISSING AT PANEL 552HB. REPLACED NUTPLATE AND INSTALLED SCREW PER AMM.SDR UALA2013010700066Nose Cowl · dentedDAMAGE TO NR 2 NOSE COWL AT 6:00 POSITION. REPLACED NR 2 NOSE COWL PER AMM.SDR UALA2012120707086Wire · crossedNR 2 ENGINE BACKUP GEN DOES NOT COME ON LINE AFTER ENGINE START 3X. PER C-CHECK CREW, REPLACE BACKUP CONVERTER M24008. RAN NR 2 ENGINE, MSG 24-47050 STILL SHOW LATCHED. FOUND CROSSED WIRES T1 AND T2 AT M24004 BACKUP GENERATOR. CORRECTED PER WDM24-25-21. REISDR UALA2012110506334Actuator · faultyTURB CASE COOL HPT R RIGHT ENGINE HIGH PRESSURE TURBINE (HPT) CASE COOLING ACTUATOR IS STUCK OR REVERTED TO ITS FAIL-SAFE POSITION. 2 ENG 777035 REPLACE TCC ACTUATOR. TURBINE CASE CLG AIR VLV ACTR (R ENG) HPT POSITION FEEDBACK IS OUT OF RANGE'. TCC OPERATESSDR UALA2012082804823Headset · defectiveCAPT MINITEL HEADSET IS MISSING PART. USED SPARE HEAD SET AND DEFER PER MEL 2351AS. OK FOR CONTINUED SERVICE. REPLACED SPARE HEAD SET.SDR UALA2012072303955Transceiver · inoperativeLEFT HF RADIO INOPERATIVE. LEFT HF TEST PASSED MAT TEST, LEFT HF CAN MONITOR BUT WILL NOT TRANSMIT IN BOTH CAPT-FO POS. COUPLER WILL NOT TUNE FOR TRANSMIT. RDF-T :TRIED NEW LEFT HF TRANSCEIVER STILL NOT TUNING. REINSTALLED OLD ONE. OPS CHECKED RIGHT HF PER AMMSDR UALA2012072303962Display · inoperativeFIRST OFFICERS DISPLAY INTERMITTENTLY INOPERATIVE. SWAPPED CENTER LOWER DISPLAY WITH FIRST OFFICER NAV DISPLAY. REPLACED CTR LOWER DISPLAY.SDR UALA2012072403999Battery · weakAPU BATTERY FAILURE. STATUS ACTIVE DESCENT MODE DEPENDENT, APU BATTERY IS WEAK. DB- ELMS P310 ELECTRONICS UNIT MSG-2413047 ACTIVE DC MODE. REPLACED APU BATTERY PER MM, OPS CHECKED GOOD.SDR UALA2012051602771Chiller · odorHEAVY ELECTRICAL ODOR IN 1ST CLASS. REMOVED ALL GALLEY POWER. REPLACED OVERHEAD GALLEY CHILLER PER MM. OPS OK. NO ODOR OBSERVED.SDR UALA2012051102743Circuit Card · malfunctionedFIRE LOOP 2 RIGHT ENGINE FIRE DETECTION SYSTEM LOOP 2 FAILURE. STATUS MESSAGE 2610232 ACTIVE FL HARD: MAT SHOWS MESSAGE 26-10232 NOT ACTIVE. PERFORMED ENGINE/APU FIRE OVERHEAT TEST. TEST PASSED. REPLACED FIRE OVERHEAD DETECTION CARD. OPS OK.SDR UALA2012051102742Circuit Card · malfunctionedOVERHEAT CIRCUIT R2 RIGHT ENGINE OVERHEAT DETECTION CIRCUIT 2 FAILURE. STATUS MESSAGE 2610232 ACTIVE FL HARD: MAT SHOWS MESSAGE 26-10232 NOT ACTIVE. ENGINE/APU FIRE OVERHEAT TEST. TEST PASSED. REPLACED FIRE OVERHEAD DETECTION CARD (A10). OPS CHECKED OK.SDR UALA2012040902180Idg · warning lightLEFT IDG BLOCKED MESSAGE DISPLAYED & DPI INDICATOR POPPED. REPLACED IDG, OPS CHECKED NORMAL.SDR UALA2012031401699Cap · missingHIGH VOLTAGE CAP IS MISSING CAPT 1L WINDOW SMALLER SIZE CAP. INSTALLED NEW CAP.SDR UALA2012031201627Unknown · malfunctionedFUEL PUMP CENTER R CENTER RIGHT (OVERRIDE) FUEL PUMP SWITCH IS ON AND PUMP OUTPUT PRESSURE IS LOW. FAILS CHANNEL A, EICAS ALSO SHOW AIR-GND RIGHT STATUS MSG AND P210 ELMS STATUS MSG. NEED NEW A6 CARD. "AIR-GRD R" STATUS MSG CLEARED. REACTIVATED SYSTEM PER MSDR UALA2012022201069Bleed Valve · faultyNR 2 ENGINE 2.9 STAB, BLEED VALVE, 2514-2 ENGINE 777035 ECM DATA SHOWS 2.9 STABILITY BLEED VALVE, SETTING MESSAGE 75-60482 '2.9 STABILITY BLEED VALVE (R ENG) IS NOT, IN COMMANDED POSITION'. ECM SHOWS HIGH TEMP AT 2.9 THERMOCOUPLE, BUT EGT CONFIRMS VALVE NOT FSDR UALA2012022000977Sdu · not seatedSATELLITE COMMUNICATION (SATCOM) HIGH-GAIN AND LOW-GAIN SYSTEMS INOPERATIVE. APPLIED MEL, PULLED AND LOCKED C.B. RESEATED SDU, MAT TEST OK.SDR UALA2012020900790Sensor · faultyAFTER ENGINE START CREW HAD BLEED OFF ENG RT ADVISORY (EICAS) MSG. CYC BLEED BUT CAME BACK. SAMC TEXT: BLEED PRSOV-R STATUS MSG DISPLAYED. DEACTIVATED RT ENG PRSOV PER MEL 3611G. BOEING AHM DOWNLINKED MMSG 36-10470 'RIGHT IP SENSOR FAILED' WHICH CAN DRIVE SDR UALA2012012400494Actuator · faultyENG CONTROL R FAULT (CMC002) ON ESN 777035. PERFORM ENGINE CHECK NR 4-VARIABLE STATOR VANE SYSTEM. TEST CHECKS OKAY. REPLACED VARIABLE STATOR VANE ACTUATOR. ACCOMPLISHED MAT GROUND TEST R ENG ACTUATOR DRY MOTOR TEST PASS. CONCURRED ENG CONTLR. OPS R ENG SDR UALA2012010300064Idg · faultedELECTRICAL GENERATOR OFF. LEFT GENERATOR CONTROL CIRCUIT BREAKER OPEN OR GENERATOR CONTROL SWITCH OFF & ENGINE NOT SHUTDOWN. INTEGRATED DRIVE GENERATOR (LT) FREQUENCY IS LOW. REPLACED LT IDG, OPS CHECKED OKAY.SDR UALA2011122107043Spring · brokenINBOUND FROM NRT, DURING WALK-AROUND FOUND FWD DRAG BRACE AFT LOCK SPRING BROKEN OFF ON RIGHT MAIN LANDING GEAR. REPLACED BROKEN SPRING PER MM.SDR UALA2011122107004Cartridge · defectiveCREW REPORTED THAT 2R AFT LAV COLD WATER DOES NOT SHUTOFF. REPLACED COLD WATER CARTRIDGE.SDR UALA2011120506643Sdu · malfunctionedSATCOM DATA LINK LOST. FOUND SDU LEFT CB POP OUT. COULD NOT REST. REPLACED LEFT SDU. SATCOM CONDITION OKAY.SDR UALA2011112306446Door · out of adjustDOOR 2L HANDLE HARD TO OPERATE. DURING DOOR CLOSING DOOR WENT OUT OF SYNCH. OPENED DOOR FROM THE INSIDE. OPERATION NORMAL.SDR UALA2011111406228Transceiver · inoperativeVHF C INOP WITH MSG "VHF DATALINK" ON UPPER EICAS. FOUND MSG 23-53003 IN P LF & FAULT HISTORY. T-S REF FIM 23-12 TASK 828. REPLACED VHF C & CKD MM AND GROUND TEST CENTER VHF COMMUNICATION SYSTEM --TEST PASSED. NO ACTIVE MSG.SDR UALA2011111406227Amu · faultyDATA XFER FROM ACARS STILL BLEEDS THRU TO LEFT VHF RECEIVER. REPLACED AMU PER MM, OPS CHECK OKAY.
Back to N214UA