N646UA
Service difficulty reports · 313
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 = 'N646UA' 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 = 'N646UA' 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 2002UALA00298Wire · damagedEEL STRIP IN FRONT OF SEAT 1E NOT OPERATING. REPAIRED DAMAGED POWER FEED PER GNMM 2-0-15-5. OPERATIONALLY CHECKED NORMAL.SDR 2001UALA02143Floorbeam · corrodedFORWARD PIT, FS 588, RBL 42, CARGO FLOORBEAM CORRODED. MAJOR REPAIR ACCOMPLISHED. INSTALLED DOUBLER REPAIR ON FLOORBEAM.SDR 2001UALA02142Floorbeam · corrodedFLOORBEAM CORRODED AT STATION 1197, RBL 15, AFT CARGO COMPARTMENT. MAJOR REPAIR ACCOMPLISHED. INSTALLED T-CAP AND DOUBLER REPAIR ON FLOORBEAM.SDR 2001UALA02141Floorbeam · crackedCABIN FLOORBEAM CRACKED AT STATION 303, LBL 57. MAJOR REPAIR ACCOMPLISHED. INSTALLED T-CAP AND DOUBLER ON FLOORBEAM.SDR 2001UALA02140Floorbeam · corrodedCORROSION ON FLOORBEAM AT STATION 1188 TO 1197, RBL 38, AFT CARGO COMPARTMENT. MAJOR REPAIR ACCOMPLISHED. INSTALLED NEW T-CAP SECTION.SDR 2001UALA02139Floorbeam · corrodedFLOORBEAM AT BODY STATION 347, BL 48 IS CORRODED. MAJOR REPAIR ACCOMPLISHED. INSTALLED DOUBLER ON FLOORBEAM.SDR 2001UALA00094Handle · stuckUNABLE TO RAISE GEAR HANDLE WITHOUT USING OVERRIDE.SDR 2000UALA00204O-Ring · cutNR 1 ENGINE IFSD (IN FLIGHT SHUT DOWN) DUE TO OIL LEAK AT LP20 FUEL OIL COOLER VALVE ADAPTER AND PACKING. DIVERTED TO LIM. *S/D* FOUND FUEL OIL COOLER BYPASS VALVE ADAPTER FITTING (P/N 227435) LOOSE AND O-RING (AS3208-06) CUT, (REF IPC 79-21-00A-005C PG1 ITSDR 2000UALA00042Wire · failedRTF, AMBER ALERT. BURNING SMELL IN CABIN, MOSTLY AROUND SEAT 1C. *S/D* VDB SMELLS BURNT. REPLACED SEAT 1C VDB, OPS CHECK GOOD.SDR 2000UALA00030Tube · crackedEN ROUTE TO SCL SHUT DOWN LEFT HAND ENGINE DUE TO OIL PRESSURE FLUCTUATIONS. DIVERTED TO GYE. *S/D* ANGLE GEARBOX OIL PRESSURE TUBE (LP09) FAILED BEHIND THE FORWARD B-NUT. REPLACED THE OIL LINE AND SUPPORTIING CLAMPS. ENGINE WAS REPLACED AFTER FERRY FLIGSDR 99UAL900409Battery Charger · failedMAIN BATTERY CHARGER EICAS MSG DISPLAYED. RETURNED TO MIA. *S/D* REPLACED BATTERY CHARGER, SYSTEM OP CHECK GOOD.SDR 95UAL900132Eel Strip · inopEMERGENCY ESCAPE PATH LIGHTING INOP AT AFT GALLEY BETWEEN DOORS NR 2 LEFT AND NR 2 RIGHT. REPLACE LIGHT STRIP. CHECKS O.K.SDR 95UAL767017Bleed Valve · malfunctionedABORTED TAKEOFF DUE TO NR 2 ENGINE BLEED VALVE PROBLEM. REPLACED HI-STAGE VALVE.
Back to N646UA