N474UA
Service difficulty reports · 113
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 = 'N474UA' 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 = 'N474UA' 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 UALA2008120906796Connector · disconnectedAFT RT CABIN DOOR SLIDE ASSY CONNECTOR BETWEEN CABLE LOOP ASSY AND COVER RELEASE CABLE WAS FOUND DISCONNECTED. CABLE LOOP ASSY AND COVER RELEASE CABLE CONNECTED.SDR 2008UALA06320Smoke Detector · faultySMOKE LAV & CARGO DET FAULT MESSAGE PRESENT ON UPPER ECAM BY. REPLACED DETECTOR 1WQ, VERIFIED NO FAULTS, OP CHECKS OK.SDR 2008UALA02301Oxygen System · reads lowCREW OXYGEN SYSTEM-LOW, RECORD PRESSURE PRIOR TO SERVICING. CREW COMMENTS, OXYGEN LOW 1390 PSI. SERVICED CREW O2 TO FULL, NO LEAKS WERE NOTED AT TIME OF SERVICE.SDR 2007UALA03626Unknown · odorDUE TO STRONG BURNING ODOR IN CABIN FLIGHT WAS DIVERTED. FOUND OVER HEATING BALLAST/LIGHT (PAX READING) ASSY. REPLACED BALLAST AND PAX READING LIGHT ASSY. NO REPEATS SINCE ORIGINAL.SDR 2007UALA01465Stringer · corrodedCORROSION IN AFT PIT LEFT SIDE AT STRINGER 43L, FRAME 57. MAJOR REPAIR ACCOMPLISHED: INSTALLED SPLICE REPAIR.SDR 2007UALA01276Power Supply · failedEMERGENCY LIGHT TEST FAILS WITH "EPSU INT LOAD" MESSAGE. [SUP 05-16-07] REPLACED EPSU. ALSO REPLACED BATTERY. OPS CHECKS GOOD.SDR 2007UALA01003Starter · faultyON START NR 1 ENG HAD REPORTED SPARKS COMING FROM THE BOTTOM OF THE ENG. [SUP 06-01-07] REPLACED START VALVE AND STARTER.SDR 2007UALA00934Controller · inoperativeCAPTAIN'S SLIDING WINDOW HEATING INOPERATIVE. [SUP 06-01-07] INITIALLY REPLACED THE NR 1 WINDOW HEAT CONTROLLER BUT LATER DETERMINED THAT SLIDING WINDOW WAS DEFECTIVE. WINDOW INTERNAL TEMPERATURE SENSORS MISREPORTING TEMP TOO LOW, CAUSING HEAT CONTROLLER TOSDR 2006UALA01084Power Supply · dischargedEMERGENCY LIGHTS TEST FAILS. REPLACED 13WL POWER SUPPLY, OPS CHECKS OK.SDR 2005UALA00469Pump · failedLOST GREEN HYD SYSTEM WHILE IN A HOLDING PATTERN ABOVE PLANNED DESTINATION. GREEN SYSTEM EDP REPLACED AWAITING FINDINGS FROM THE VENDOR (ARINC). REPLACED NR 1 ENG DRIVEN PUMP, REF MM29-11-51. REPLACED CASE DRAIN FILTER, PDI NOT POPPED. NO DEBRIS FOUND IN FILSDR 2004UALA00789Control Unit · faultyNR 2 GENERATOR FAULT ECAM MESSAGE. *S/D* NR 2 GENERATOR CONTROL UNIT REPLACED.SDR 2004UALA00020Slide · will not testLT OVERWING EXIT SLIDE DID NOT DEPLOY AUTOMATICALLY WHEN HATCH WAS REMOVED AND DID DEPLOY WHEN MANUAL OVERRIDE WAS ENGAGED. SLIDE BOTTLE ASSY INFLATION CABLE WAS FOUND KINKED INSIDE THE PULLEY OF THE WIRE CONTROL ASSY AND THE END OF CABLE WAS FOUND TWISTED. TSDR 2003UALA00519Transceiver · inoperativeRETURNED TO FIELD DUE TO INOPERATIVE WEATHER RADAR. INOPERATIVE WEATHER RADAR CAUSED BY FAULT IN RECEIVER/TRANSMITTER. RECEIVER/TRANSMITTER REPLACED. SHOP TEST CONFIRMED PREAMP FAILURE IN RECEIVER/TRANSMITTER.
Back to N474UA