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 UALA2012110506303Drive Assy · faultyWEATHER RADAR SYS DISPLAY IS NOT PRESENT WHEN SELECTED ON EFIS CONTROL PANEL. FAILED AMM TEST FOR ANTENNA FAULT. REPLACED ANTENNA DRIVE UNIT. OPS OK.SDR UALA2012091805254Display · faultyF/O NAV DISPLAY BLINKING ON AND OFF. F/O NAV DISPLAY BLINKS, SWAPPED WITH CTR LOWER DISPLAY UNIT PER MEL, CB COLLARD. REPLACED CENTER LOWER ND PER MM.SDR UALA2012080804283Shutoff Valve · faultyRT ENG PRSOV FAULTED. REPLACED RT ENGINE PRSOV PER MM.SDR UALA2012080604224Controller · faultyRT ENGINE IDLE IS INOPERATIVE. INSTALLED NEW CONTROLLER, TESTED GOOD, IDLE RAN ENGINE. ALL SYSTEM NORMAL, NO FAULTS NOTED.SDR UALA2012051602770Idg · malfunctionedELECTRIC GENERATOR DRIVE LT OFF EICAS. DISCONNECTED LT GENERATOR. RAN ENGINES AND VERIFIED NO BACKUP GENERATOR MESSAGES DISPLAYED. LT IDG DISCONNECTED AND SERVICED TO FULL.SDR UALA2012041302229Actuator · faultyRAM AIR INLET DOOR L LEFT RAM AIR INLET DOOR NOT IN COMMANDED POSITION OR LOSS OF POSITION FEEBACK.STATUS MSG01- LATCHED CRUISE MODE DEPENDENT; RAM AIR INLET ACTUATOR (L PACK) AC MOTOR IS NOT IN COMMANDED POSITION. DB- CABIN TEMPERATURE CONTROLLER (L CHAN2) SDR UALA2012032001801Rivet · looseBIRD STRIKE. BIRD STRIKE INSPECTION ACP. NO AIRFRAME DAMAGE NOTED. NEC TO ADDRESS LOOSE RIVETS AT UPPER 2.5 SCREENS ON RT ENG.SDR UALA2012032001804Actuator · brokenDURING WALK-AROUND, FOUND LEFT MAIN GEAR TRUCK POS ACTUATOR BROKEN. INTERNAL PISTON SEIZED UP ON ACTUATOR ROD END. LOG003 AUTO SPEEDBRAKE EICAS MESSAGE SET BY DAMAGED ACTUATOR. VERIFIED CAUSE FOR MESSAGE IN EXISTING FAULTS IN MAT. REPLACED LT MAIN LANDING SDR UALA2012030501408Seal · deterioratedLT ENGINE PYLON FAIRING HEATSHIELD FWD SEAL HEAVILY DETERIORATED & SPLIT, REF EQ4498. REMOVED HEATSHIELD SEGMENTS NR 1, 2, 3, & 4 PER MM. REPLACED FWD SEALSDR UALA2012030101281Relay · faultyELEC STANDBY SYS ELECTRICAL DC-STANDBY POWER SYSTEM FAILED THE SYSTEM SELF-CHECK. STATUS MSG-2413035 ACTIVE AP MODE. REPLACED MAIN BATTERY RELAY REF MM, MAT TESTED BATTERY RELAY OPERATIONAL.SDR UALA2012022401121Actuator · leaking'C' HYD LEAK, FLT DIVERTED. SLOW LEAK CENTER HYD SYS. AFTER LANDING FOUND RT MLG SOAKED WITH HYD FLUID. UNABLE TO DETERMINE IF BRAKE OR A LINE. TOO MUCH SMOKE. RPLC'D RT MLG TRUCK POSITIONER ACTUATOR PER MM.SDR UALA2012013000597Pcu · faultyFLT CTL SYS STATUS MSG. WORKED CH2321, STARTED REMOVING SPOILER 13 PCU M27217. REPLACED PCU.SDR UALA2012013000596Fan · faultyEQUIP VENT FAN STATUS MSG. PULLED BREAKER AND CONNECTOR FROM FAN PER MEL. FORWARD CARGO HEAT NOT AVAILABLE, NO LIVE ANIMALS IN FWD PIT. REPLACED FAN. GROUND TEST & OPS CHK'D NORMAL, MSG CLEARED.SDR UALA2012013000595Drive Unit · faultyWXR FAIL MSG ON ND. OK AFTER RADAR TURNED OFF AND BACK ON. REPLACED WXR ANTENNA DRIVE UNIT, OPS CHECK GOOD.SDR UALA2012011600313Seat Back · out of adjustTHE 33H SEAT BACK WILL NOT STAY UP. ADJ SEAT BACK.SDR UALA2012010900170Generator · inoperativeAPU GENERATOR INOP APU OKAY. APU GENERATOR WILL NOT RESET. RAN GENERATOR WITH LOAD ON FOR 30 MIN, CHECKED OKAY.SDR UALA2011121906949Unknown · malfunctionedRT ENGINE FAN AIR MODULATION VALVE INOP (FAMV). LOCKED FAMV IN THE OPEN POSITION PER MEL 3611F. CLN: ACCOMPLISHED RT ENGINE AIR SUPPLY VALVES OPERATIONAL TEST PER MM. NO FAULTS FOUND VALVE OPERATION NORMAL MSG. UNLATCHED. NO HISTORY FOUND. CLEANED AND RSDR UALA2011120206633Windshield · faultyWINDOW 1R DAMAGED. REMOVED WINDOW. REPLACED WITH NEW TYPE WINDOW REF COA 209882.SDR UALA2011113006587Battery Pack · inoperativeGALLEY DOOR, EMERGENCY LIGHTS INOPERATIVE, FWD AND AFT GALLEY. REPLACED BATTERY PACK, M33096. OPS CHECKED OKAY.SDR UALA2011101205550Control Unit · malfunctionedWINDOW HEAT R SIDE EICAS. DEFERRED PER MEL 3041C. WINDOW HEAT RT SIDE CAN BE RESET & LIGHTT IN SWITCH & EICAS MESSAGE EXTINGUISHED, BUT WILL COME BACK ON IN 10-15 SECONDS. WINDOW HEAT SWITCH LEFT IN OFF POSITION WITH PLACARD. REPLACED WHCU, OPS CHECKED OKASDR UALA2011093005301Shutoff Valve · faultyBLEED OFF ENG L APPEARED AT IDLE PWR PRIOR TO TAKEOFF. RESET UNSUCCESSFUL. IDLE POWER SNAPSHOT SHOWS HPSOV CLOSED AND PRSOV CLOSED. ADVANCED POWER TO 80 PERCENT CYCLED BLEED SWITCH, PRSOV OPENED DUCT PRESSURE INDICATED 4 PSI. PRSOV & HPSOV BOTH CLOSED AT SDR UALA2011090504743Chiller · inoperativeCHILLER - INOPERATIVE C11. CREW COMMENTS: REPEAT FROM YESTERDAY. REPLACED C11 CHILLER PER MM.SDR UALA2011083104691Seat Belt · looseF/O LAP STRAP COMING UNRAVELED, NEEDS REPLACEMENT. ROBBED BELT FROM OVERNIGHT A/C. OUT OF STOCK AT IAD.SDR UALA2011082604577Switch · faultyDUE TO REPORTS OF APU STARTING DIFFFICULTIES AND CREW REPORTS THAT THE ROTARY START SWITCH BINDS, PLEASE REPLACE THE APU START SWITCH WITH REFERENCE TO BOEING STANDARD PRACTICES MANUAL FOR RMVL & INSTALLATION OF ELECTRICAL SWITCHES & SAFETY PRACTICES. IPC 49-SDR UALA2011081904424Monitor · inoperativeALL OVERHEAD VIDEO MONITORS INOPERATIVE. REPLACED VIU, NO HELP. AUDIO MUSIC & VIDEO AUDIO OK, NO VIDEO DISPLAYED ON OVERHEAD SCREEN. REPLACED VIU, INSTALLED OPS SWITCH AND CONFIGURED DATABASE, CHECKED OKAY.SDR UALA2011071103457Panel · faultyCSCP SCREEN BLANK AT DEPARTURE. RESET, NO HELP, BUT MOVIES CAN BE PLAYED FROM DVFS AND MOVIE SEAT AUDIO OK. NO PA CONTROL FOR SAFETY DEMO. ZONES B AND C NO AUDIO. INTERMITTENT OTHER CABIN AREAS. ALL AUDIO IN ECON CH 1 INOP. REPLACED CSCP, TESTS OKAY.SDR UALA2011070703357Actuator · faultyFUEL SPAR VALVE L LEFT ENGINE FUEL SPAR VALVE IS NOT IN COMMANDED POSITION. (STATUS) - REPLACED LT FUEL SPAR VALVE ACTUATOR, OPS CHECK OK PER MM AND TEST PER 28-22 TASK.SDR UALA2011062703129Connector · looseEEL LIGHTS INOP AT ROWS 25 THRU 37 RT & LT. REPAIRED LOOSE CONNECTOR D3201P PER WDM, OP CHECKED GOOD.SDR UALA2011062003005Status Message · activatedL ENG SPAR VALVE' STATUS MSG PRIOR TO DEPARTURE. SHOULD READ 'FUEL SPAR VALVE L'.SDR UALA2011051802453Valve · inoperativeBLEED FAMV R STATUS MSG. RENDERED R FAMV INOP PER MEL 36090.SDR UALA2011041901898Heat Shield · damagedFOUND NR 2 ENGINE STRUT FAIRING HEAT SHIELD SMASHED ON INBOARD SIDE. THIRD BACK FROM FRONT. PART NEEDED IS ITEM 265 ON PG 1. IPC REFERENCE IS 54 54 02 007. REMOVED 4 EA HEAT SHIELD SEC. INSTALLED ROBBED PART AND INSTALLED REMOVED HEAT SHIELDS PER MM.SDR UALA2011040401595Controller · faultyRIGHT PRSOV MSG DISPLAYED PRIOR TO DEPARTURE. ALSO RECEIVED STATUS MESSAGE R FAMV. BITE CHECK, ENG RUN NO HELP. PRSOV MANUALLY LOCKED CLSD. REPLACED PRSOVC. ALSO ACCOMPLISHED PNEU HEALTH CHECK. OPS CHECK NORMAL. LOCKED OUT R FAMV PER MEL 3611F. CHECKEDSDR UALA2011033001522Coupler · faultyHF RADIO RIGHT WON'T TUNE. NEED HF ANTENNA COUPLER. REPLACED RT HF COMM COUPLER, MAT BITE TEST OK. DUE TO NR 2 HF COUPLER REPLACEMENT, NEED TO ACCOMPLISH SYSTEM OPS CHECK OUTSIDE THE HANGER. NR 2 HF SYS FAILS OPS CK. DF0928 FOR UPDATE. REPLACED RT HF COMSDR UALA2011030401069Spar · corrodedLT WING REAR SPAR WEB CORRODED AROUND FASTENERS BETWEEN IRSS 340 AND IRSS 350 WHERE A FUEL BOOST PUMP IS INSTALLED. REPAIRED IAW 777EN-57-0156.SDR UALA2011010300020Windshield · delaminatedCAPT 1L WINDOW DELAMINATED TOP EDGE 3 IN X 14 IN VISION IS AFFECTED. ACTUAL MEASUREMENTS 3.25IN IN WIDTH, 12IN IN LENGTH. WITHIN LIMITS. NOT TO EXCEED 3.5 IN WIDTH. REPLACED NR 1L FLIGHT DECK WINDOW IAW MM.SDR UALA2011010300014Relay · faultyNR 1 ENG START WOULD NOT OPEN. REPLACED ERU, STARTED ENG SEVERAL TIMES, STARTS NORMAL.SDR UALA2010122704725Module · faultyFMC LT EICAS MSG. AIMS MODULE FAULTY, REPLACED LEFT AIMS MODULE M002 PER AMM. OPS NORMAL.SDR UALA2010122004639Isolation Valve · faultyLEFT ISOLATION VALVE CHECK FAILED TO SEAL. MANIFOLD WOULD NOT DROP, STAYED ABOVE 20 PSI. REPLACED LT ISOLATION VALVE IAW MM. OPS NORMAL.SDR UALA2010122004638Start Valve · malfunctionedENGINE START VALVE LT FAILS TO OPEN. MAT SHOWS MAINT MSG 80-61561. REPLACED STARTER, NO HELP. STATUS MSG "L ENG START VALVE" DISPLAYED. MAT SHOWS SAME MSG. NEW START VALVE REPLACED, NO HELP. ORIGINAL REINSTALLED MR80102-21. SHUTDOWN APU AND RESTART, MOTOSDR UALA2010121404569Duct · disconnectedAPU AUTO SHUTDOWN 3 TIMES AT THE GATE. MX MESSAGE 49-10260 "APU HIGH OIL TEMP". FOUND FLEX DUCT CONNECTOR BLOWN OUT. PART ON ORDER. REPLACED BLOWN FLEX DUCT CONNECTOR. APU OPS CHECKED NORMAL.SDR UALA2010112404346Gcu · faultyAPU GEN SYS WILL NOT COME ON LINE. SWAPPED LEFT ENG GCU TO APU POS, NOW APU GEN SYS OK. SWAPPED UNITS BACK TO ORIGINAL POS. ORDERED NEW APU GCU MR 24241 TO GATE 82. REPLACED APU GCU. OPS NORMALSDR UALA2010112304314Skin · damagedFOUND 3 LIGHTNING STRIKES AT STA 839 2 INCHES INBD OF STR 45R, STA 850 AT S-45R AND STA 861 AT S-45R. MAJOR REPAIR ACCOMPLISHED: STARTED TO BLEND LIGHTNING STRIKES. ACP SMC004 ON WU B4078W. FUSE EXTERNAL SKIN LIGHTENING STRIKES. DRILLED REMAINING HOLES DE-SDR UALA2010102003880Cover · crackedEMERGENCY LIGHT COVER AT 3F, 5E AND 5F CRACKED. REPLACED EMERGENCY LIGHT COVERS,SDR UALA2010101803854Valve · inoperativeBLEED FAMV RT STATUS MESSAGE RT ENGINE FAMV INOPERATIVE, LOCKED OPEN. REPLACED FAN AIR VALVE, RAN ENGINE AND OPS CHECKS GOOD.SDR UALA2010101403815Fan · odorBURNING RUBBER ODOR IN AREA OF ROW 46. TURNED OFF INFLT ENT SYS, UTIL, AND RECIRC FANS. DIRECTED TO TURN OFF CARGO TEMP SWITCH. SMOKE ODOR SEEMS TO DISSIPATE. RESET SWITCHES TO ON. NO SMOKE OR ODOR NOTICED. SUSPECT PREVIOUS SITUATION RELATED TO CARGO BULK FASDR UALA2010101403814Fan · failedCARGO VENT FAN BULK FAILURE OF BULK CARGO VENTILATION FAN. STATUS MSG01- LATCHED CRUISE MODE DEPENDENT; BULK CARGO VENTILATION FAN DOES NOT FOLLOW COMMAND (ON OR OFF) OR IS OVERHEATED. DB- ECSMC (RT) MSG-2111012 LATCHD ER MODE. MAT TEST OF BULK CARGO VENT FANSDR UALA2010090303259Valve · faulty"R FAMV" STATUS MSG ON EICAS. LOCKED IN FULL OPEN POSITION. REPLACED VALVE. OPS CKS GOOD.SDR UALA2010072602690Idg · defectiveELEC GEN SYS R IDG HAS DISCONNECTED OR A PROTECTIVE TRIP OF THE GENERATOR CONTROL BREAKER HAS OCCURRED OR A PROTECTIVE TRIP OF THE BTB HAS OCCURRED. STATUS MSG-2431662 LATCHD ER MODE ON MAT ADVISORY MSG ELEC G EN OFF R FAULT CODE 242 012 42. IDG(R) OUTPUT CUSDR UALA2010072302627Gcu · faultyLT & RT ENG GEN FAILURE, RTFL. RT GENERATOR TRIPPED OFF LINE AND UNABLE TO RESET. REPLACED GCU(S) AND OPERATIONS CHECK GOOD IAW MM.SDR UALA2010071902583Fan · shortedCREW REPORTS EICAS STATUS MSG AFT CARGO HEAT INOP DET FAN 2 FWD. TEST SHOWS SMOKE DETECTOR FAN 2 LWR FWD OPEN OR SHORTED. REPLACED FWD PIT SMOKE DETECTOR, GROUND TEST PASSED MESSAGE CLEARED.
Back to N212UA