N798UA
Service difficulty reports · 187
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 = 'N798UA' 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 = 'N798UA' 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 UALA2011032101355Gcu · inoperativeCREW REPORTS APU GEN WILL NOT COME ON LINE. APU GEN INOP PER MEL. REPLACED GENERATOR CONTROL UNIT PER MM. RAN ENGINE. OPS CHECK OK.SDR UALA2011032101354Insulation · damagedELEC GEN OFF APU AUXILIARY POWER BREAKER (APB) OPEN AND AUXILIARY POWER UNIT (APU) GENERATOR RUNNING OR APU GENERATOR SWITCH OFF. LATCHED MSG 24-31663 ON ARRIVAL. ACCOMPLISHED RESET PER FIM, NO HELP. ELECTRIC PAGE SHOWS NIL VOLTAGE AND FREQUENCY. SUSPECT FASDR UALA2011031001165Pin · damagedNR 1 ENG AFT RT CORE COWL RT AFT HOP TIE BAND PIN DAMAGED. INSTALLED NEW PIN. UNIT NOW SERVICEABLESDR UALA2011031001158Bracket · damagedNR 1 ENG AFT RT CORE COWL AFT HOP TIE SUPPORT DAMAGED. REMOVED BRACKET ASSY. INSTALLED BRACKET ASSY.SDR UALA2011031001157Actuator · faultyDURING A8 CHECK, ACTUATOR CONFIDENCE TEST LEFT WING SHUTOFF VALVE ON P61 VALVE CLOSED LIGHT WILL NOT EXTINGUISH. MAT SHOWS MAINT MESSAGE 27-17019. TROUBLESHOT CHECKED 28VDC POWER AT VALVE AT DV27100 3 AND 2 WITH GROUNDS AT 9 AND 1 AND CASE GROUND AT 8 ALL NOSDR UALA2011030901150Bracket · bentNR 1 ENG FOUND INBD REV V-BAND MILLED BRACKET BENT.SDR UALA2011020700659Valve · inoperativeRT ENG FUEL VALVE RT DISPLAYED, ENGINE QUIT AFTER ABOUT 1 MIN. SUSPECT SPAR VALVE. REPLACE NR 2 ENGINE SPAR VALVE IAW MM. OPS CHECKED OK.SDR UALA2011011900333Windshield · delaminatedFIRST OFFICER R1 WINDSHIELD DELAMINATED. REPLACED THE WINDSHIELD. WINDOW INSTALLED AND SEALED.SDR UALA2010112904389Guide Vane · damagedNR 2 ENG SER NR 222154 FOUND 13 EACH T1 GUIDE VANES WITH BURN THROUGH AND CRACKING DISTRESS ON PLATFORMS ONE GUIDE VANE HAS CRACK GREATER THAN .50 INCH IN LENGTH INTO RADIUS OTHER GUIDE VANE HAVE BURN THROUGH OF GREATER THAN .20 SQUARE INCH. ENG CHANGE REQUIRSDR UALA2010102904012Probe · faultyHEAT TAT FAILURE OF TOTAL AIR TEMPERATURE (TAT) PROBE HEATING CIRCUIT. STATUS MSG-3037120 LATCHD ER MODE MSG-3037120 ACTIVE ER MODE. REPLACED PROBE. OPS GOOD.SDR UALA2010102803978Lamp · inoperativeEXTERNAL EEL LIGHT BY DOOR 3R IS INOP. RELAMPED. CHECKS GOOD.SDR UALA2010102803977Light · inoperativeAFT EMERGENCY LIGHT ON MID GALLEY WALL BY DOOR 2R INOP. REPLACED LIGHT ASSY. CHECKS GOOD.SDR UALA2010102803976Connector · unsecureSEAT 3F AFT EMERGENCY LIGHT INOP. SECURED CONNECTORS. CHECKS GOOD.SDR UALA2010102803975Lamp · inoperativeEMERGENCY EXIT SIGN AT DOOR 2R IS INOP. RELAMPED. CHECKS GOOD.SDR UALA2010102003887Light · looseSEAT 3F EMERGENCY LIGHT LOOSE. SECURED EMERGENCY LIGHT AND OK.SDR UALA2010082303084Light · damaged1E EMERGENCY LIGHT ON SIDE SEAT DAMAGED. 1E EMERGENCY LIGHT ON SIDE SEAT DAMAGED. LIGHT REPLACED, OPS CKS OK.SDR UALA2010082303076Guard · unserviceableEMERGENCY LIGHTS EICAS MESSAGE. REWORKED SWITCH GUARD, NOW OPS OKAY.SDR UALA2010082303083Feeder Cable · inoperativeSEAT 3F EMERGENCY PATH LIGHT INOP. SEAT 3F EMERGENCY PATH LIGHT INOP: SEAT 3F REQ NEW EMERGENCY LIGHT, RTN TO BLOCKS, NO MORE TIME. REMOVED LIGHT ASSY AND RESTOWED CABLE. 3F EMERG LIGHT REPLACED, OPS CK OK.SDR UALA2010082303077Light · inoperativeSEAT 3F EMERGENCY PATH LIGHT INOPERATIVE AFTER FURTHER ANALYSIS, IT HAS BEEN DETERMINED THIS IS NOT AN SDR REPORTABLE EVENT.SDR UALA2010081602993Control Unit · failedACE L2 FAILS LRU REPLACEMENT TEST WITH MSG 27-16001. REPLACED L2 ACE PER MM, TEST PASSED.SDR UALA2010081602992Pcu · faultedSPOILER EICAS MSG ON LANDING. LATCHED FAULTS FOR SPOILER S 4 MSG 27-10503 AND SPOILER 11 MSG 27-10510. TRIED NEW LT 2 A CE NO HELP. SWAPPED LT PFC WITH CTR PFC NO HELP,RETURN TO ORIGINAL POSITIONS. IAW TSM 27-61-810 FOR 11 SPOILER, CK FOR SHORT TO GRN AT CONNSDR UALA2010070602392Compressor · faultyACRID SMELL REPORTED IN AFT GALLEY. ODOR ISOLATED TO H2O COMPRESSOR IN AFT PIT RT SIDEWALL. CB PULLED AND COLLARED PER MEL 3810AT. CONNECTOR REMOVED FROM COMPRESSOR AND CB PULLED ON P320. REPLACED COMPRESSOR IAW AMM.SDR UALA2010070602390Connector · disconnectedONE (1) EACH EEL INOP ON SEAT 3E. FOUND FWD LIGHT DISCONNECTED. SECURED LIGHT CONNECTOR, OP NORMAL.SDR UALA2010061702140Acm · leakingRT ACM HAS AN ALIGNMENT DOWEL MISSING ON FWD SIDE OF BOTTOM FLANGE. (LT ACM SHOWN, RT OPPOSITE SO DOWEL IS ON BOTTOM). THE MISSING DOWEL IS CAUSING A HOT STREAM OF AIR TO LEAK FROM ACM INTERIOR. REPLACED ACM.SDR UALA2010061702134Door · faultyRAM AIR INLET DOOR LT MESSAGE. REPLACED LT RAM AIR DOOR.SDR UALA2010052401773Start Valve · faultyENG START VALVE RIGHT STARTER AIR VALVE POSITION DISAGREES WITH COMMANDED POSITION OR STARTER AIR VALVE POSITION INDICATION IS LOST. STATUS MSG-8061562 INACTV TA MODE. START VALVE INOPERATIVE. STARTER & VALVE FOUND DEFECTIVE. REPLACED STARTER VALVE & STARTER SDR UALA2010051701654Epas · malfunctionedNR 4 RT EMERGENCY POWER ASSIST SYS DOES NOT HAVE A GREEN LIGHT. REPLACED EPAS.SDR UALA2010042901444Feeder Cable · burnedFOUND GENERATOR FEEDER CABLE BURNED. NEED TO REPLACE CABLE AND IDG, NR 2 ENG IDG AVAIL CABLE NOT AVAIL CHECKING SHOP ALSO NR 1 ENG EGT PROBES CH A SIGNAL OUT PF RANGE, NEED TO REPLACE. RESEARCHING PARTS. REPLACED IDG POWER FEEDER CABLE HARNESS FROM IDG TO TOSDR UALA2010042901443Lamp · inoperative19G EMERGENCY LIGHT IS INOPERATIVE. REPLACED LAMP. TESTS OK.SDR UALA2010040201101Controller · faultyRT ECONOMY COOLING VALVE INOPERATIVE. PACK MODE R DISPLAYED AGAIN AFTER ENGINE START. MSG NR 21-23402. REPLACED CABIN TEMP CONTROLLER AND INSTALLED SOFTWARE. GRD TESTED, PASSED.SDR UALA2010030900819Ring · missingDOOR 4R EXTERIOR HANDLE UNABLE TO OPEN DOOR. REMOVED EXTERNAL HANDLE, FOUND SPLIT RING NOT INSTALLED AND SEAL DAMAGE. REPLACED OUTER SEAL, CLEANED CLUTCHES AND INNER HUB. REINSTALLED HUB AND SEAL. OPS CHECK GOOD BY MX.SDR UALA2010011300157Interphone · malfunctionedLOSS OF THE CABIN INTERPHONE SYS. REPLACED ZMU NR 1 WITH NEW UNIT, REINSTALLED CONFIGURATION DATABASE AND OPS TEST. ALL CABIN INTERPHONE HANDSET WORKS NORMAL, MSG GONE IAW MM.SDR UALA2009122203973Display · inoperativeSATCOM SYS STATUS MSG. RESET NO HELP. REPLACED SDU. BITE TEST OK.SDR UALA2009120903810Sensor · failedHEAT TAT FAILURE OF TOTAL AIR TEMPERATURE (TAT) PROBE HEATING CIRCUIT. STATUS MSG01- LATCHED CLIMB MODE DEPENDENT; TAT PROBE HEATER POWER IS NOT AVAILABLE. DB- ELMS P110 ELECTRONICS UNIT MSG-3037120 LATCHED CL MODE. REPLACED TAT PROBE AND PERFORMED MAT TEST. SDR UALA2009113003678Light · inoperativeAFT EMERGENCY LIGHT ON SEAT 3F IS INOP. REPLACED LIGHT ASSY. CHECKS GOOD.SDR UALA2009113003677Connector · unsecureAFT EMERGENCY LIGHT ON SEAT 2F IS INOP. SECURED FLOOR CONNECTOR. CHECKS GOOD.SDR UALA2009113003676Connector · unsecureAFT EEL LIGHT ON SEAT 1F IS INOP. SECURED CONNECTOR. CHECKS GOOD.SDR UALA2009112403657Light · damagedTHE 1E EEL LIGHT DAMAGED. SECURED CONNECTOR, LENS RE-INSTALLED AS BLANKING PLATE. DAMAGED LT ASSY IS AFT LENS ON ARMCAP. REPLACED LIGHT ASSY. CHECKS GOOD.SDR UALA2009100803158Bleed Valve · malfunctionedSTATUS MESSAGE BLEED VALVE APU DISPLAYED DURING CRUISE. REPLACED APU BLEED VALVE AND RESET ASPL CONTROLLER, MSG CLEARED.SDR UALA2009100603134Fuse · brokenCTR HYD SYS FLUID LOSS, RTFL. FOUND HYD FUSE BROKEN. REPLACED HYD FUSE AND SYSTEM WORKS NORMAL.SDR UALA2009091702945Valve · unreliableBOTH RIGHT MAIN FUEL TANK REFUEL VALVES FAILED TO OPEN. ACP TANK REFUEL. PRESSURE FUELING WITH INOP REFUEL VALVES. AHM REPORTS MSG 28-20050 'FQPU HAS AN INTERNAL FAULT' WHICH CAN CAUSE REFUELING VALVES TO NOT OPEN. REPLACED OUTBOARD RT REFUELING VALVE. RESDR UALA2009091002853Support · unsecureEMERGENCY LIGHT SUPPORT BAR DETACHED FROM WALL UPON LANDING HANGING FROM WIRES. EMERGENCY LIGHT SUPPORT BAR SECURED AT DOOR 3L AND LIGHTS TEST OKAY.SDR UALA2009082102588Generator · inoperativeNR 2 ENG BACK UP GENERATOR DPI POPPED. REPLACED NR 2 ENG BACK UP GENERATOR.SDR UALA2009082102587Idg · malfunctionedRIGHT ENG GEN "DRIVE" LIGHT AND SYNOPTIC MSG DO NOT COME ON AFTER ENG SHUTDOWN. INTERNAL SWITCH IN IDG OPEN, IDG REPLACED. ACCMP'D ENG RUN, CKS GOOD.SDR UALA2009070901978Apu · faultyTERRIBLE SMELL IN COCKPIT AND CABIN. SMELL GONE WHEN APU BLEED OFF SO DEACTIVATED APU BLEED INOP. ELECT OK. INBOUND CREW STATES PACK BURNOUT PRIOR TO DEPARTURE. SMELL STILL PRESENT BUT LESS INTENSE THROUGH CLIMBOUT. SMELL DISSIPATED THROUGH CRUISE & RETURSDR UALA2009062901815Light · inoperativeEMERGENCY LIGHT AT SEAT 3E AFT INOP. REPLACED LIGHT ASSY AT 3E AFT, OP CHECKS GOOD.SDR UALA2009062201757Light · inoperativeONE EMERGENCY LIGHT (AFT) INOP AT SEAT 3E. REPLACED EMERGENCY LIGHT STRIP.SDR UALA2009062201756Lamp · inoperativeONE EMERGENCY LIGHT (FWD) INOP AT SEAT 2E. RELAMPED LIGHT ASSY AT 2E FWD, OP CHECKS GOOD.SDR UALA2009020200339Light · inoperativeSEAT 1E AFT EMERGENCY LIGHT INOP. REMOVED OLD LAMP, SLAVED IN OTHER LAMP SYSTEM OPERATIVE, NEED LAMP. REPLACED LAMP.SDR UALA2009012700288Light · inoperativeSEAT 3F ON ARMREST RT AFT EMERGENCY LIGHT INOP. REPLACED EEL LIGHT ASSY AND CHECKED OKAY.
Back to N798UA