N795UA
Service difficulty reports · 206
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 = 'N795UA' 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 = 'N795UA' 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 UALA2012030701503Connector · improper partPER FCD 3321-01019 CONNECTOR IS NON COMPLIANT AT STA 1990 LBL90 ABOVE LAV REF P36 ITEM 12. (DM33036C). REPLACED CONNECTOR PER FCD JOB INSTRUCTIONS. VERIFIED CORRECT CONNECTOR INSTALLED AND SECURE.SDR UALA2012030701502Connector · improper partPER FCD 3321-01019 CONNECTOR IS NON COMPLIANT AT STA 1990 LBL 90 ABOVE LAV REF PG 36 ITEM 12. (DM33036B). REPLACED CONNECTOR PER FCD JOB INSTRUCTIONS. VERIFIED CORRECT CONNECTOR INSTALLED AND SECURE.SDR UALA2012030701501Connector · improper partPER FCD 3321-01019 CONNECTOR AT STA 1590 STR 12R W6169 D5188P IS NON COMPLIANT. NEEDS BACC65AJ131S. REPLACED CONNECTOR PER FCD JOB INSTRUCTIONS. VERIFIED CORRECT CONNECTOR INSTALLED AND SECURE.SDR UALA2012030701500Connector · improper partPER FCD 3321-01019 CONNECTOR IS NON COMPLIANT AT STA 1520 LBL 90. REF. P.24 ITEM 19 (DM33200D). REPLACED CONNECTOR PER FCD JOB INSTRUCTIONS. VERIFIED CORRECT CONNECTOR INSTALLED AND SECURE.SDR UALA2012030701499Connector · improper partPER FCD 3321-01019 CONNECTOR AT STA 1590 STR 12R W6236 D5188J IS NON COMPLIANT. NEEDS BACC65AK231P. REPLACED CONNECTOR PER FCD JOB INSTRUCTIONS. VERIFIED CORRECT CONNECTOR INSTALLED AND SECURE.SDR UALA2012030701498Connector · improper partPER FCD 3321-01019 CONNECTOR AT STA 830 RBL 90 W236 DM33036A IS NON COMPLIANT. NEEDS BACC65AK212P. REPLACED CONNECTOR PER FCD JOB INSTRUCTIONS. VERIFIED CORRECT CONNECTOR INSTALLED AND SECURE.SDR UALA2012030701497Connector · improper partPER FCD 3321-01018 CONNECTOR AT STA 1507 RBL 90 ABOVE DOOR 3R IS NON COMPLIANT. NEEDS BACC65AK211P. REPLACED CONNECTOR PER FCD JOB INSTRUCTIONS. VERIFIED CORRECT CONNECTOR INSTALLED AND SECURE.SDR UALA2012030701496Connector · improper partPER FCD 3321-01018 CONNECTOR AT STA 747 RBL 90 ABOVE DOOR 2R NON COMPLIANT. NEEDS BACC65AK211P. REPLACED CONNECTOR PER FCD JOB INSTRUCTIONS. VERIFIED CORRECT CONNECTOR INSTALLED AND SECURE.SDR UALA2012011600354Engine · faultyDUE TO CHRONIC OIL HIDING AND OIL TEMP RISING WITH OIL PRESSURE DECREASING REPLACE NR 1 ENGINE. REPLACE NR 1 ENGINE. INSTALL ESN 222027. REPLACED NR 1 ENG PER MMOV. INSTALLED ESN 222027.SDR UALA2012010900172Pump · faultyLOW OIL PRESSURE & QTY, FLIGHT DIVERTED. CREW REPORTS NR 1 ENG OIL QTY INDICATING 0 WITH OIL TEMP 160 & OIL PRESS 135. RT ENG OIL QTY 15 OIL TEMP 115 & OIL PRSS 247. MAINT TEXT: CREW REPORTS TO MAINT ON ARRIVAL THAT OIL QTY STARTED TO RECOVER ON DESCENT ANDSDR UALA2012010400075Heat Shield · damagedNR 2 ENGINE AFT PYLON HEAT SHIELD IS DAMAGED. REMOVED AND REPAIRED HEAT SHIELD.SDR UALA2012010400074Heat Shield · wornNR 1 ENGINE AFT PYLON HEAT SHIELD WORN. REMOVED AND REPAIRED HEAT SHIELD IAW CMM 54-52-17,ITEM 7C.SDR UALA2012010400073Strip · wornNR 2 ENGINE PYLON HEAT SHIELD SEGMENT AFT GAP STRIP WORN BEYOND LIMITS. INSTALLED NEW GAP STRIP IAW MT 54-UA2 .SDR UALA2012010400072Strip · wornNR 1 ENGINE AFT PYLON HEAT SHIELD SEGMENT GAP STRIP WORN BEYOND LIMITS. REPLACED NR 1 ENGINE AFT PYLON HEAT SHEILD GAP STRIP IAW IPC 54-54-02-007 AND 777 MT54-UA2.SDR UALA2011122707108Light · brokenSEAT ROW 12RT EMERGENCY LIGHT IS BROKEN AND MISSING. REPLACED EMERGENCY LIGHT ASSY IN SEAT 12, OP CHECKED GOOD ON GROUND.SDR UALA2011122307097Control Unit · faultyWINDOW HEAT RT FWD LOSS OF RIGHT FORWARD WINDOW HEAT. (ADVISORY) REPLACED RT WINDOW HEAT CONTROL UNIT PER MM, OPS CHECKS OKAY.SDR UALA2011112106407Floor Panel · damagedAFT GLY FLOOR RT SIDE SEAM IS LIFTING UP. SECURED DOWN GALLEY FLOOR.SDR UALA2011110706064Controller · faultyANTI-ICE ENG L LEFT ENGINE ANTI-ICE (EAI) VALVE FAILURE TO THE CLOSED POSITION OR LEFT EAI CONTROL CARD FAILURE. COMPLETED CHECK OF EAI TUBING FOR LEAKS. LINES CHECK OKAY & REPLACED ENG ANTI-ICE VALVE CONTROLLER. COMPLETED 30 AIRFOIL COWL ICE PROTECTION SYSSDR UALA2011110305957Controller · faultyEAI VALVE L LEFT ENGINE ANTI-ICE (EAI) VALVE FAILURE. STATUS MSG-3010101 LATCHED TO MODE. L ENG ANTI ICE SYSTEM DE-ACT IAW MEL PROCEDURES L ENG ANTI-ICE SYSTEM INOP IN OPEN POSITION. EAI REPLACED ON OVERNIGHT VISIT MR30210-909 INSTALLED, NO HELP. VALVE RETURNESDR UALA2011102005682Anti-Ice Valve · failedDIVERTED DUE ENGINE ANTI-ICE FAILURE. REPLACED ANTI ICE VALVE CONTROLLER & THE ANTI-ICE VALVE PER AMM. ACCOMPLISHED ENGINE RUN IAW MM 30-21-00-730-806-003, TEST PASSED, MESSAGE CLEARED.SDR UALA2011101005479Solenoid · malfunctionedSLATS PRIMARY FAIL MESSAGE. MSG 27-20962. ACP'D FIM 27 -82 TASK 804, TEST FAILED WITH MSG 27-25082. ACP'D FIM 27-82-830. REPLACED SLAT PRIMARY LOW SPEED SOLENOID. ACP'D FIM TEST & OPS CHECK, ALL CHECK NORMAL, MSG NOT ACTIVE.SDR UALA2011092605207Start Valve · faultyAFTER NR 2 ENGINE START, CREW RECEIVED "ENG START VALVE 'R" MESSAGE DISPLAYED. START VALVE IS CLOSED, AS INDICATED BY "DUCT PSI" SUSPECT INDICATION PROBLEM. ENGINE OPERATION IS NORMAL. DEFERRED PER SAMC. REPLACED VALVE PER MM. ENGINE STARTING PER JRH. ALLSDR UALA2011091504983Light · looseSEAT 2E FWD EEL LIGHT LOOSE. SECURED SEAT 2E FWD EEL LIGHT. EEL LIGHT, OPS CHECK GOOD.SDR UALA2011090704825Anti-Ice Valve · failedEAI VALVE L LEFT ENGINE ANTI-ICE (EAI) VALVE FAILURE. STATUS MSG01- LATCHED CRUISE MODE DEPENDENT; ENGINE ANTI-ICE VALVE (LEFT) IS FAILED IN CLOSED POSITION. DB- ACIPS CONTROL CARD, LEFT (L EAI CARD) ITEM CNX PER PLF SHOWS NOT ACTIVE MSG-3010101 LATCHED ER MSDR UALA2011082204495Valve · faultyLEFT ENG AI VALVE MSG 30-10101. DUE TO REPEAT HITS ON L-EAI SYSTEM, DEFER EAI IN OPEN POSN PER MEL 3021E UNTIL ABOVE FIM CAN BE ACCOMPLISHED. IF NO FAULTS FOUND DURING FIM, RPLC LEFT EAI VALVE AS A PRECAUTION. DISCONNECTED AND SECURED. ELECT PLUG DM30211A. VESDR UALA2011082204444Fmu · malfunctionedL ENG SLIGHT FLUCTUATION PER SAM TURNED ON WING AND ENG ANTI-ICE, NO HELP. REPLACED FUEL METERING UNIT. IDLE LEAK CHECK AND NO LEAKS NOTED.SDR UALA2011080203992Window · defectiveCREWS REPORT THAT THE R2 WINDOW "NEARLY IMPAIRS VISION".SDR UALA2011072703850Outlet · inoperativeLOWER ELECTRICAL OUTLET AT DOOR 3L INOPERATIVE. CB OPEN AND COLLARED PER MEL. REPLACED LOWER OUTLET AND TESTED FOR 115VAC WITH DMM, TEST OK.SDR UALA2011072503775Rod · looseIN-FLIGHT VIBRATION, DIVERTED. HIT TURBULENCE DURING CLIMB. THERE IS NOW A NOISE-VIBRATION COMING FROM THE BELOW THE FLOOR AT AROUND ROW 21. NOISE-VIB HAS APPEARED TO SMOOTH OUT, BUT IS STILL PRESENT. INSPECTED ACFT REF MT05-UA1, INCLUDING FLIGHT CONTROLS,SDR UALA2011072503763Window · crazedCAPTAIN'S WINDSHIELD L1 WINDOW NEARLY IMPAIRS VISION. REPLACED NR 1L WINDOW.SDR UALA2011060602769Shutoff Valve · faultyRIGHT PACK OFF LIGHT FLICKERS. REPLACED RT PACK SHUTOFF VALVE. OPS OK. UPPER FCV VALVE WAS REPLACED. ACFT RTBL WITH RT PACK SHOWING FLOW WITH RT PACK SELECTED OFF DURING ENGINE START. REPLACED LOWER RT FLOW CONTROL VALVE, NO HELP. REINSTALLED OLD VALVE ASDR UALA2011042702042Light · inoperativeSEAT 11F FWD EMERGENCY LIGHT INOPERATIVE. REPLACED LIGHT ASSY PER MM, CHECKED OKAY.SDR UALA2011042702041Light · inoperativeSEAT 11D AFT EMERGENCY LIGHT INOP. REPLACED LIGHT ASSY PER MM. CHECKED OKAY.SDR UALA2011042702040Light · inoperativeSEAT 11D FWD EMERGENCY LIGHT INOP. REPLACE LIGHT ASSY PER MM, CHECKED OKAY.SDR UALA2011042502004Line · leakingHYDRAULIC LEAK IN NOSE GEAR WHEEL WELL. FOUND STEERING SYSTEM FLEX HOSE FAILED. REPLACED STEERING PRESS LINE PER IPC. ACCOMPLISHED CENTER SYS BLEED MM. ALSO LG CONTROL SYS TEST AC ON GRND. TOPPED 'C' SYS RESERVOIR. FAILED LINE SENT OUT ON RFU 221792 TO SFOEG. SDR UALA2011040701680Control Valve · faultyA/C PACK FLOW CONTROL VALVE RIGHT STATUS MESSAGE WITH PACKS ON. REPLACED LOWER FCV IAW MM. GROUND CHECKED NORMAL.SDR UALA2011031501233Valve · wornOUTBOARD IP VALVE WORN ON NR 1. REPLACED VALVE. OPS NORMAL.SDR UALA2011011900305Solenoid Valve · faultyRIGHT MLG DOOR WILL NOT CLOSE. REPLACED SOLENOID VALVE, OPS CHECKS OKAY.SDR UALA2011010300033Seal · leakingLWR SIDE OF CAPTAIN SLIDING WINDOW HAS VERY LOUD SQUEAL AT ALT. FOUND LEAK FROM AFT LOWER CORNER OF CAPTAIN SIDE NR2 SLIDING WINDOW BULB SEAL. REPAIRED, CHECKED OK.SDR UALA2011010300032Wire · chafedFIRE LOOP 2 ENG L STATUS MESSAGE. VISUAL INSP C-OUT ON LT ENG FIRE LP2 WIRINGS FOUND CHAFING AT 2 CLAMP AREAS BETWEEN M2600 4 & M26005. TEFLON TAPE N LACING APPLIED AT 2 STATED LOCATIONS, FIRE SYS TEST CUTOUT FOUND PASSED. NO MESSAGE.SDR UALA2010122704732Circuit Card · failedRT ENGINE FIRE-OVERHEAT DETECTION CARD FAULT OR FAILURE, OR AIMS LOSS OF ARINC 629 OR 429 COMMUNICATION WITH CARD. STATUS MSG01- ACTIVE CRUISE HARD; ENGINE FIRE DETECTION CARD (RT) HAS NO OUTPUT ON EFDC 429 BUS. SIGNAL GATEWAY (LT), RSCF MSG-2618892 ACTIVE SDR UALA2010110104055Light · brokenEMERGENCY LIGHT WAS BROKEN AT SEAT 8D. REPLACED EMERGENCY LIGHT ASSY, OPS CHECK OK.SDR UALA2010102203912Oxygen Bottle · reads lowCREW OXYGEN READ 1640 PSI. LESS THAN LIMIT AS REQUIRED NR 3SVC CK. REPLACED OXYGEN BOTTLE. OPS & LEAK CHECKED , NO LEAK FOUND.SDR UALA2010102003879Fan · failedSMELLED ELECTRICAL ODOR BRIEFLY. THEN SAW STATUS MESSAGE EQUIP COOLING FAN RT. ON ARRIVAL, FOUND NO ODOR AND MESSAGE 21-14022. CHECKED AREA BY COOLING SUPPLY FAN, FOUND NO DAMAGE OR DEFECT. C/B COLLARED AND DISCONNECTED CONNECTOR PER MEL. REPLACED R-EQ COOLINGSDR UALA2010070802433Structure · gougedFOUND GOUGE AT STA 1895, STRINGER 39R. DAMAGE IS 4.5 INCHES LONG X .093 IN DEPTH X .625 IN WIDTH. DAMAGE IS OUT OF LIMITS PER SRM. TREATED, PRIMED AND PAINTED AREA. AWAITING EVA FOR DAMAGE LIMITS. REPAIRED IAW EVA NR 73929.SDR UALA2010051401644Duct · dentedRT PACK BAY TRIM AIR SUPPLY DUCT IS DENTED. REPLACED DUCTS AND SUPPORT ROD. REPLACED ACM. INSTALLED CLAMPS AND BONDING WIRE. EICAS MSG ERASED R PACK, OPS CK OK.SDR UALA2010051001568Control Valve · failedPACK FCV R ONE (BUT NOT BOTH) OF THE (2) RT PACK FLOW CONTROL VALVES (FCV) ARE NOT IN THE COMMANDED POSITION. STATUS MSG01- LATCHED CRUISE MODE DEPENDENT; LOWER FLOW CONTROL AND SOV (R PACK) TORQUE MOTOR IS NOT IN COMMANDED POSITION. DB-CABIN TEMP CONTROLLESDR UALA2010030200750Idg · making metalLT IDG INOP. FOUND IDG FILTER BLOCKED INDICATION ON ELEC MAINT PAGE. CHK'D IDG OIL FILTER, SHOWS METAL DEPOSIT. REPLACED IDG. OPS ARE NORMAL.SDR UALA2010021500563Light · looseSEAT 2E FWD EMERGENCY LIGHT LOOSE, SEAT 3E AFT EMERGENCY LIGHT LOOSE. SECURED EMERGENCY LIGHTS TO SEATS 2E AND 3E. EMERGENCY OPS GOOD.SDR UALA2010021500562Cover · missingSEAT EMERGENCY LIGHT COVER MISSING. REPLACED MISSING COVER.
Back to N795UA