N485UA
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 = 'N485UA' 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 = 'N485UA' 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 2004UALA01125Warning Light · illuminatedGEAR NOT UPLOCKED DISPLAYED ON UPPER ECAM. AFTER GEAR RETRACTION, RECEIVED A LANDING GEAR SHOCK ABSORBER FAULT ON UPPER ECAM.ACCOMPLISHED A COMPLETE NOSE GEAR STRUT SERVICE. CLEANED GREASE FROM NOSE PROX SENSORS. JACKED NOSE GEAR CLEAR OF GROUND AND GEAR CESDR 2004UALA00300Skin · damagedUPPER RUDDER TIP MISSING. UPPER RIGHT & LEFT PANELS DAMAGED IN GFRP AREA. MAJOR REPAIR ACCOMPLISHED. REPLACED RUDDER TIP. INSTALLED NEW UPPER RIB, ATTACH ANGLE & FAIRING CAP TO RIGHT & LEFT PANELS.
Back to N485UA