N495UA
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 = 'N495UA' 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 = 'N495UA' 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 UALA2009041501091Cover · brokenCREW OXYGEN BOTTLE GAUGE COVER BROKEN, DAMAGED AND LOOKS LIKE ITS TAPE TO BOTTLE. REPLACED BOTTLE WITH CORRECT FITTING.SDR 2008UALA04156Oxygen System · lowCREW OXYGEN ON UPPER ECAM. *S/D* SERVICED CREW O2 TO FULL, NO LEAKS NOTED AT TIME OF SERVICE.SDR 2008UALA02578Structure · damagedDOOR 1L AREA IS GASHED. THIS IS A MAJOR REPAIR. CUT OUT DAMAGE AND REPAIRED PER SRM 53-11-11 ON NR D0453A DURING H MV VISIT. PERMANENT REPAIR.SDR 2008UALA01194Structure · damagedLT NR 4 LEADING EDGE SLAT DAMAGED ON ARRIVAL. REMOVED AND REPLACED NR 4 LT SLAT.SDR 2008UALA00811Battery · faultyLT EMERGENCY EXIT LIGHT BATTERY SHOW A FAULT AFTER EMERGENCY LIGHT TEST ON CIDS PANEL. FAULTY BATTERY. REPLACED LT EMERGENCY EXIT LIGHT BATTERY. OPS CHECKS ARE NORMAL.SDR 2008UALA00180Wire Harness · damagedEEL LIGHT AT ROW 2 IS INOP. DAMAGE TO EEL SEAT HARNESS. REPLACED EEL LIGHT SEAT HARNESS AT ROW 2. OPS CHECKED NORMAL.SDR 2007UALA05276Connector · looseROW 24C, 25C & 26C EMERGENCY LIGHTS OUT. LOOSE CONNECTOR AT 24C. RESECURED CONNECTOR AT SIDEWALL. OPS CHECKED NORMALLY.SDR 2006UALA02031Lamp · failedEMERGENCY AISLE LIGHTS AT SEATS 2 AND 3 ARE INOP. RELAMPED SEAT 2. REPLACED HARNESS FOR SEAT 3.SDR 2006UALA01756Epsu · faultyEPSU EXT LOAD EMER R INOP. REPLACED RIGHT OVERWING SLIDE.SDR 2006UALA00324Bearing · seizedDIVERTED DUE TO ODOR IN THE COCKPIT. FLIGHT CREW NOTICED ELECTRICAL ODOR IN CABIN. ECAM MESSAGE VENT EXTRACT FAULT, EXTRACT FAN SHOWING AMBER AND CREW SELECTED EXTRACT TO OVERRIDE. SUSPECT FAN/BEARING SEIZED UP. FOUND FAULT LIGHT ILLUMINATED ON EXTRACT FASDR 2005UALA00737Skin · buckledSKIN BUCKLED AROUND AFT FUSELAGE JACK PAD FITTING. MAJOR REPAIR TO REPLACE SKIN IN AREA OF THE JACK PAD. REPLACED SKIN IN AREA OF THE JACK PAD.SDR 2004UALA00661Frame · dentedFOUND 3 DENTS AT FRAME 74 AREA, 2 DENTS WERE AT STR 32L, 1 DENT AT STR 32R. FRAME 73 SURROUNDING THE JACKING STABILIZATION POINT ON THE AFT FUSELAGE. INSTALLED SKIN DOUBLER AND FRAME DOUBLER. INSTALLED NEW SHEAR CLIPS.
Back to N495UA