N799UA
Service difficulty reports · 174
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 = 'N799UA' 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 = 'N799UA' 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 2008UALA03148Solenoid Valve · faultyFLAPS PRIMARY FAIL PRIMARY (HYDRAULIC) FLAPS DRIVE FAILURE. FLAPS OPERATING IN SECONDARY (ELECTRIC) MODE. CAUTION MSG-2720372 LATCHD DC MODE. FAILED HIGH LIFT CONTROLS TEST. FOUND FLAPS PRIMARY LOW SPEED SOLENOID VALVE AT FAULT AND REPLACED REF MM 27-51-05SDR 2008UALA02841Control Unit · faultedHYDRAULIC PUMP DEM C1 LOW CENTER HYDRAULIC DEMAND PUMP NR 1 PRESSURE WHEN COMMANDED ON, OR CENTER DEMAND PUMP NR 1 OVERHEATED. STATUS MSG-2910420 LATCHD DC MODE MSG-2910420 LATCHED DC MODE MSG-2910450 LATCHED AP MODE. FOUND LOGIC SPEED CONTROL UNIT FAULTY.SDR 2008UALA02641Skin · damagedA DENT WAS FOUND ON EXTERNAL SKIN OF BULK CARGO DOOR AT FWD LOWER CORNER. MAJOR REPAIR ACCOMPLISHED: REMOVED DAMAGED AREA. ACCMP HFEC INSP FOR CRACK FREE CUTOUT. INSTALLED REPAIR DOUBLER.SDR 2008UALA00051Computer · shortedNO LAND 3 DEGRADATION IN AUTOLAND SYSTEM PRIOR TO APPROACH (BEFORE LAND 3 AUTOLAND STATUS ANNUNCIATION). AUTOPILOT FLIGHT DIRECTOR COMPUTER (RIGHT) A LIVE CIRCUIT IS OPEN OR SHORTED. REPLACED AFDC RT. RT LRU TEST PASSED. RETURNED TO CAT 3 STATUS. AC OK FOSDR 2008UALA0051Unknown · unknownNO LAND 3 DEGRADATION IN AUTOLAND SYSTEM PRIOR TO APPROACH (BEFORE LAND 3 AUTOLAND STATUS ANNUNCIATION).SDR 2007UALA03678Connector · damagedHYD PUMP DEM C2 LOW CENTER HYDRAULIC DEMAND PUMP NR 2 PRESSURE WHEN COMMANDED ON, OR CENTER DEMAND PUMP NR 2 OVERHEATED. 10-05-07 AFTER TROUBLESHOOTING & HISTORY REVIEW, DETERMINED THAT NR 2 CONTROL HYD PUMP OPERATED OK FOR SEVERAL LEGS AFTER PIN D7716B (SDR 2007UALA03048Wire Harness · damagedENGINE CONTROL SYSTEM IS OPERATING WITH REDUCED REDUNDANCY. FAULTY T3 INDICATION. REPLACED WO636 HARNESS.SDR 2007UALA01926Transducer · fluctuatesFLIGHT DIVERTED DUE TO CREW OXYGEN INDICATION. [07-13-07] REPLACED OXYGEN PRESSURE TRANSDUCER. NO ADDITIONAL FLUCTUATION NOTED. A/C OK FOR SERVICE.SDR 2007UALA01519Generator · disconnectedLEFT GENERATOR DISCONNECTED DUE TO LOW OIL PRESSURE. FLIGHT DIVERTED. [06-14-07] REMOVED AND REPLACED LEFT IDG. ACCOMPLISHED SERVICE AND LEAK CHECK. ACCOMPLISHED 5 MIN IDLE RUN AND FOUND NO LEAKS. OK FOR SERVICE. SUSPECT SEAL LEAKAGE PROBLEM.SDR 2007UALA01357Fan · odorF/A'S REPORTED SLIGHT SMOKE OR ELECTRICAL ODOR IN CABIN ORIGINATING FROM BUSINESS CLASS. REPLACED RIGHT HAND RECIRCULATION FAN PER MM 21-25-07, ALL OPS GOOD,TEST PASS PER MAT OF RECIRC FAN SYS.SDR 2007UALA01288Skin · crackedRT WING L/E AFT OF NR 9 SLAT CRACKED OUT FROM RESTORATION SEAL CUTOUTS. [SUP 05-18-07] RT WING L-E AFT OF NR 9 SLAT CRACKED OUT FROM RESTORATION SEAL CUTOUTS. REPAIRED PER OV WRITE-UP W1682T AND R&R R41952.SDR 2007UALA01284Battery Pack · dischargedC XOME AT PED NR 4 RT AND LT OVERHEAD PANEL EMERG LIGHTS INOP. REPLACED BATTERY PACK ABOVE DOOR 4 RIGHT. OP CHECKED GOOD.SDR 2007UALA01283Battery Pack · dischargedM2 GALLEY UNITS BOTH RT AND LT EEL LIGHT STRIPS INOPERATIVE. REPLACED BATTERY PACK IN DOOR OVERHEAD PANEL AT 2 LEFT. OP CHECKED GOOD.SDR 2007UALA00415Light · looseEMERGENCY LIGHT STRIP AT 1L LOOSE. FOUND LIGHT OPERATIONAL BUT LOOSE. SECURED FWD SEAT 1F EMERG LIGHT, LIGHT CHECKS OK.SDR 2005UALA01263Warning Light · illuminatedFLIGHT DIVERTED UNDER AMBER ALERT DUE TO MULTIPLE AIR DATA SYSTEM PROBLEMS, OVERWEIGHT LANDING. FOUND DAMAGED QUICK DISCONNECT FOR RIGHT AIR DATA MODULE (ADM) CAUSING INVALID SIGNAL. THE QUICK DISCONNECT WAS REPLACED. THERE WERE 3 ADMS BEING REPLACED AND 2 ASDR 2004UALA00175Engine · overheatedRIGHT ENGINE OIL TEMP TO 145C AND OIL PRESSURE DROPPED TO 40-45 PSI TOP OF DESCENT INTO KIX. SHUT DOWN ENGINE. NR 1 BEARING FAILURE. THIS IS THE MAIN THRUST BALL BEARING SUPPORTING THE N1 ROTOR. OUTER RACE HEAVILY SPALLED THROUGH 100¡ ARC. ONE BALL HEAVILY SDR 2003UALA00765Light · damagedEMERGENCY EXIT LIGHTS DAMAGED. SECURED SEAT EMERGENCY EXIT LIGHT.SDR 2003UALA00108Charger · inoperativeEMERGENCY LIGHTS INOPERATIVE, ROW 17 TO 28, RIGHT AISLE. REPLACED BATTERY CHARGER ABOVE DOOR NR 3 RIGHT.SDR 2002UALA01859Target · bentFORWARD CARGO DOOR LIGHT ON IN FLIGHT. SUPPLEMENTAL DATA UPDATE MAINTENANCE FOUND THE DOOR CLOSED SWITCH SENSOR TARGET BENT OUT OF RANGE FOR THE SENSOR TO SENSE THE DOOR CLOSED. MAINTENANCE REPOSITIONED THE TARGET.SDR 2002UALA00659Ram Air Turb · failedDURING OPERATIONAL TEST OF THE RAM AIR TURBINE DURING ROUTINE MAINTENANCE CHECK, THE RAM AIR TURBINE (RAT) FAILED TO PRODUCE THE REQUIRED VOLTAGE. FAILURE OF THE RAM AIR TURBINE GENERATOR. THE RAM AIR TURBINE ASSEMBLY, WHICH INCLUDES THE GENERATOR, WAS REPLASDR 2001UALA00492Video Unit · failedELECTRICAL ODOR AND SMOKE REPORTED IN AFT CABIN. FLIGHT DIVERTED AND LANDED UNDER AMBER ALERT INTO SNN (SHANNON, IRELAND). MAINT CHECK SEAT FOR FAILED SEAT VIDEO DISTRIBUTION UNITS IN AFT CABIN AREA. SUPPLEMENTAL DATA UPDATE THE VIDEO DISTRIBUTION UNIT AT SEASDR 2000UALA00819Slide Raft · leakingDOOR 1 LT SLIDE/RAFT FAILED AIR RETENTION CHECK. FOUND SEAM LEAK IN INFLATABLE LOWER TUBE MIDDLE OF RT SIDE. PROBABLE CAUSE OF SEAM LEAK APPEARS TO BE CAUSED BY POOR WORKMANSHIP DURING MANUFACTURE - UNIT IS BEING SENT TO VENDOR FOR REPAIR.SDR 2000UALA00525Transducer · malfunctionedCREW LOW O2 MESSAGE. DIVERTED DEN. *S/D* CREW OXYGEN CYLINDER PRESSURE WAS NORMAL 1700 PSI. FOUND THE CAUSE OF THE PROBLEM TO BE THE PRESSURE TRANSDUCER. TRANSDUCER WAS REPLACED SEPT. 05, 2000. OPERATIONAL CHECK WAS GOOD.SDR 99UAL900460Rollers · out of positionEN ROUTE SFO-CDG DURING CLIMB, CREW REPORTED HEAVY VIBRATION COMING FROM LEFT SIDE OF AIRCRAFT AROUND ROW 12. TURNED OFF LEFT PACK AND VIBRATION DECREASED CONSIDERABLY. *S/D* THE LEFTHAND RAM AIR INLET DOOR ROLLERS WERE FOUND OFF THE ROLLER TRACKS. THE RO
Back to N799UA