N472UA
Service difficulty reports · 102
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 = 'N472UA' 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 = 'N472UA' 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 2006UALA00268Hydraulic System · leakingLANDED UNDER AMBER ALERT DUE TO LOSS OF GREEN HYDRAULIC SYSTEM. A/C TOWED TO GATE. GREEN SYS HYD QTY WENT TO ZERO. TROUBLESHOT GREEN SYS HYD LEAK. FOUND NR 2 ENG EDP PUMP LEAKING. FOUND PUMP HOUSING CRACKED. REPLCD PUMP. REPLACED LFT ENG HYD FILTER ASSY ANSDR 2005UALA00185Door · noisyRETURN TO FIELD DUE TO LOUD NOISE BY DOOR 1R. ON SECOND ATTEMPT LOUD BANGING DETECTED FROM DOORS 1R AND 1L. APPEARS TO BE NORMAL NOISES FROM FUSELAGE DURING TAKEOFF AND CLIMB. ENGINEERING FLIGHT TEST CREW SHOWED NOTHING ABNORMAL.
Back to N472UA