N486UA
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 = 'N486UA' 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 = 'N486UA' 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 2008UALA00486Oxygen Bottle · low pressureO2 BOTTLE LOW AT SEAT ROW 26ABC. REMOVED AND REPLACED O2 BOTTLE.SDR 2008UALA00092Oxygen System · low pressureCREW OXYGEN SYSTEM-LOW. RECORD PRESSURE PRIOR TO SERVICING. CREW COMMENTS: OXY PRESS 1090 DECREASED 400 PSI SINCE DEN. UNKNOWN INDICATION ISSUE. SERVICED CREW O2 SYSTEM, NO LEAKS NOTED ANYWHERE IN THE SYSTEM.SDR 2007UALA04836Seat Track · wornRIGHT INBOARD AND OUTBOARD SEAT TRACKS BETWEEN FRAMES 41AND 47 WORN BEYOND LIMITS. MAJOR REPAIR ACCOMPLISHED: REPLACED SEAT TRACKS.SDR 2007UALA04625Unknown · odorF/A REPORTS STRONG ELECTRICAL ODOR ROW 13. TURNED OFF VIDEO LIGHTS, ODOR GONE. COULD DUPLICATE ON GROUND. TURNED ON VIDEO AND ALL CABIN AND READING LIGHTS, AND CHECKED UNDERSEAT AREAS AT ROW 13 NO DEFECTS OR ODORS NOTED. CHECKED AVIONICS EQUIPMENT BAYS ALSSDR 2007UALA02254Battery · failedCABIN EMERGENCY LIGHT TEST FAILS WITH -EPSU BATTERY EMER L- MSG. REPLACED EPSU BATTERY AT LEFT OVERWING EXIT.SDR 2006UALA00573Engine · surgesRTFL DUE TO NR 1 ENGINE POWER SURGE. ALL TROUBLESHOOTING CHECKS RETURN NO DEFECTS.SDR 2004UALA00642Landing Gear · inoperativeUNABLE TO RETRACT LANDING GEAR AFTER TAKEOFF. NOSE GEAR WOULD NOT CENTER BECAUSE THE LGCIU FAILED. REASSEMBLED NOSE GEAR, OPERATIONS CHECK NORMAL.SDR 2003UALA00251Outflow Valve · failedRETURN TO FIELD DUE TO LOSS OF CABIN PRESSURE. REPLACED OUTFLOW VALVE.
Back to N486UA