N477UA
Service difficulty reports · 108
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 = 'N477UA' 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 = 'N477UA' 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 2007UALA04000Hydraulic System · contaminatedGREEN RSVR LOW LVL DISPLAYED ON ECAM. A/C TOWED TO THE GATE. 10-19-07 FOUND HYDRAULIC SYSTEM CONTAMINATED. REPLACED NR 1 EDP AND HYDRAULIC LINE, FILTERS DOWNLINE.
SDR 2007UALA03261Oxygen System · leakingCREW OXYGEN SYSTEM IS LEAKING. F/O OXYGEN MASK HAS A SLOW LEAK. REPLACED F/O OXYGEN MASK AND SERVICED CREW OXYGEN SYSTEM.SDR 2007UALA00664Seat Track · corrodedFRAME C20, RBL 31 HAS EXFOLIATED CORROSION. MAJOR REPAIR ACCOMPLISHED: REPLACED SEAT TRACK.SDR 2007UALA00663Floorbeam · damagedCABIN FLOORBEAM EXFOLIATED, STA FRAME C21 TO C22, LBL 9 IN. [SUP 05-24-07] REMOVED AND REPAIRED DAMAGED AREA IN ACCORDANCE WITH SRM.SDR 2006UALA02058Battery Pack · failedPTP PANEL TEST KEPT GETTING "EPSU BATTERY FWD L" AND "EPSU BATTERY EMER L". REPLACED LEFT OVERWING EMERGENCY BATTERY PACK. CLEANED CONNECTOR AT FORWARD LEFT EPSU. SYSTEM OPS CHECKED NORMAL.SDR 2006UALA01634Light · inoperativeEMERGENCY EXIT LIGHT INOP DOOR 4R FLOOR LEVEL. RELAMPED.SDR 2006UALA01292Girt Bar · misinstalledDOOR 2 RT WILL NOT ARM. FOUND GIRT BAR FWD FLOOR MOUNT PLATE INSTALLED WITH TO MUCH SEALANT AFFECTING THE NORMAL HEIGHT OF GIRT BAR FLOOR MOUNT. REPOSITIONED FLOOR PLATE AND SEALED. OPS CHECKED GOOD.SDR 2006UALA00148Battery · no testDURING 3 SVC EMERGENCY LIGHTS FAILED TEST, HAD EPSU BATT EMER L MESSAGE.
Back to N477UA