N797UA
Service difficulty reports · 153
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 = 'N797UA' 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 = 'N797UA' 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 2000UALA00451Connector · shortedEN ROUTE IAD-MUC, ON CLIMBOUT, CREW RECEIVED ADVISORY MESSAGE INDICATING LEFT INTEGRATED DRIVE GENERATOR HAD DISCONNECTED. UNABLE TO RESET. AIRCRAFT RETURNED TO IAD DUE TO WEATHER EN ROUTE FORECAST. *S/D* ON THE IDG (INTERGRATED DRIVE GENERATOR), CONNECTORSDR 2000UALA00298Battery · inoperativeAFTER DEPARTURE LAX (LAX-LHR), CREW RECEIVED MESSAGE OF MAIN BATTERY FAILURE. AIRCRAFT RETURNED TO LAX. *S/D* BOTH THE MAIN BATTERY AND THE MAIN BATTERY CHARGER SHOWED MAINTENANCE MESSAGES SAYING THEY WERE DEFECTIVE. REPLACED BOTH THE MAIN BATTERY (263BA10SDR 99UAL900115Wire Harness · damagedDURING C-CHECK, INSPECTION REPORTED IDG (INTERGRATED DRIVE GENERATOR) WIRE BUNDLE DAMAGE ON BOTH ENGINES. WIRE BUNDLE ID IS W0623 (P/N 420990 / 50U629). ALSO REF AMM 73-21-73. *S/D* ANALYSIS REVEALED CONTRIBUTING DAMAGE WAS RESULT OF VIBRATION AND ENGINE B
Back to N797UA