N818UA
Service difficulty reports · 112
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 = 'N818UA' 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 = 'N818UA' 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 2008UALA05957Floorbeam · corrodedBEAM 175 CORRODED. BEAM OUT & BRACKETS INSTALLED ON NEW ONE. INSTALLED BEAM AND FASTENERS WITH SEALANT. INSPECTED BEAM 175 INSTALLATION AND FOUND SERVICEABLE.SDR 2008UALA03373Battery · faultyEPSU BATTERY FWD LEFT DISPLAYED AFTER CIDS EMERGENCY LIGHT TEST. REPLACED BATTERY ON 10WL EPSU. OP CHECKS OKAY.SDR 2008UALA03222Transceiver · intermittentWEATHER RADAR SYSTEM INOP, RTFL. TRANSCEIVER IS INTERMITTENT. REPLACED TRANSCEIVER, OPS CHECK OK.SDR 2008UALA02283Motor · failedVENT BLOWER FAULT DISPLAYED WITH ELECTRICAL ODOR IN COCKPIT, NO SMOKE REPORTED. VENT BLOWER MOTOR FAILURE, BEARING. REPLACED AVX VENT BLOWER FAN MOTOR. OPS CHECKED NORMALLY, NO SMELL.
SDR 2007UALA04153Control Unit · malfunctionedNOSE WHEEL STEERING PULLS TO THE RIGHT WHEN TILLER AT ZERO. FOUND BSCU FAULTY. REPLACED BSCU, NO REPEATS.SDR 2006UALA01494Battery · faultyDURING CABIN EMERGENCY LIGHT TEST PTP INDICATED EPSU BATTERY AFT LEFT. REPLACED BATTERY AT 13WL, TESTED OK.SDR 2004UALA00633Windshield · failedF/O'S WINDSHIELD SHATTERED FL370. FLIGHT DIVERTED. MOISTURE INGRESS IN THE BUSBAR AND SENSOR AREA CAUSED THE ARCING, WHICH CAUSED THE WINDOW TO SHATTER. WINDSHIELD WAS REPLACED.SDR 2003UALA00281Rub Strip · debondedDIVERTED DUE TO NR 1 ENGINE COMPRESSOR STALL. COMPRESSOR STALL CAUSED BY HIGH PRESSURE COMPRESSOR (HPC) 6TH STAGE (C6) BLADE DAMAGE WHICH WAS IN TURN CAUSED BY HPC C6 RUBSTRIP COATING DISBONDING. SERVICE BULLETIN 72-0369 IS IN PLACE TO UPGRADE COATING TO AVOSDR 2000UALA00294Fillet · looseRETURNED TO SFO AFTER NR 1 ENG COWL FILLET AT TOP PYLON TO COWL SECTION CAME LOOSE.SDR 99UAL900644Cone · crackedNR 2 ENG HAS INLET CONE FAIRING CRACKED AROUND BOLT HOLE. *S/D* THE CAUSE OF THE INLET CONE CRACKING IS VIBRATION OF THE INLET CONE FAIRING AGAINST THE INLET CONE SEATING. THE MANUFACTURER ISSUED SERVICE BULLETIN V2500-ENG-72-0318 WHICH MODIFIED THE FAIRINGSDR 99UAL900459Blade · failedRETURNED TO SFO DUE TO NR 1 ENGINE FAILURE. *S/D* STAGE 4 BLADE FAILED IN FATIGUE IN ROOT ATTACHMENT AREA, LIBERATING AIRFOIL AND PLATFORM AND CAUSING EXTENSIVE DOWNSTREAM DAMAGE. THE MANUFACTURER HAS ISOLATED THE CAUSE TO A VSV SCHEDULE INTRODUCED WITH EECSDR 98UAL900507Indication · malfunctionedAFTER TAKEOFF, ECAM WARNING: GEAR NOT DOWN. RETURNED TO FIELD. *S/D* ACCOMPLISHED LGCIU1 AND LGCIU2 TEST. NO FAULTS FOUND. REPLACED EEC DUE TO EPR PROBLEMS. TESTED FMGC AND AFS SYSTEM, ALL OK.
Back to N818UA