N804UA
Service difficulty reports · 111
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 = 'N804UA' 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 = 'N804UA' 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 2006UALA02137Light · inoperativeCABIN, SEAT INSTALLED, EMERGENCY LIGHTS INOP AT SEAT NR 3, 4, 7, 10, 11, 14, 15, 18, 19. REPLACED POWER SUPPLY 110WL2. OPS CHECKS GOOD.SDR 2006UALA01674Battery Pack · disconnectedEMERGENCY LIGHT PATH ROWS 1, 2, 7 AND 8 INOPERATIVE. RECONNECTED ELECTRICAL CONECTOR AT BATTERY EMERGENCY PACK, TEST OK.SDR 2006UALA00658Engine · fireLEFT ENGINE FIRE ON TAKEOFF ROLL WITH LOUD BOOM HEARD ON POWER UP. HPC R3 BLADE CRACKED NEAR THE BASE OF THE BLADE. REPLACED ENGINE AND BLADE.SDR 2004UALA01148Blade · crackedNR 2 ENGINE COMPRESSOR STALL AND SHUTDOWN ON DECENT. THIRD STAGE COMPRESSOR BLADE FAILED. BLADE RE-DESIGN IS IN PROCESS TO ADDRESS THIS PROBLEM.SDR 2004UALA00157Transmitter · malfunctionedFLIGHT DIVERTED DUE TO LOW NR 2 ENGINE OIL INDICATION. REPLACED OIL QUANTITY TRANSMITTER.SDR 2003UALA00001Windshield · crackedCAPTAINS WINDSHIELD OUTER PANE CRACKED. SUPPLEMENTAL DATA UPDATE LOWER BUS BAR ARCED DUE TO DELAMINATION AND WATER INGRESSION CAUSED BY WEATHER SEAL DETERIORATION. WINDSHIELD WAS REPLACED.SDR 2002UALA01754Strut · incorrectUNABLE TO RETRACT LANDING GEAR. THE NLG LOWER STRUT ASSEMBLY WAS FOUND TO BE ASSEMBLED INCORRECTLY. THE UPPER CAM WAS MISALIGNED PREVENTING THE SHOCK ABSORBER LUGS FROM ENGAGING INTO THE SHOCK STRUT BACKPLATE. THE NLG LOWER STRUT ASSEMBLY, WHEELS, TIRES ANDSDR 2002UALA01745Skin · dentedFUSELAGE SKIN DENTED BETWEEN STRINGER 28L AND 29L, 2" AFT OF FRAME 18 STA 760 DAMAGE IS AT THE SKIN LAP. MAJOR REPAIR ACCOMPLISHED. SKIN DOUBLER REPAIR.SDR 2002UALA01670Battery · discharged"EPSU BATTERY L" MESSAGE DISPLAYED AFTER EMERGENCY LIGHTS TEST. REPLACED BATTERY ASSEMBLY.SDR 2002UALA01075Engine · vibrationRETURNED TO ORD UNDER AMBER ALERT DUE TO NR 2 ENGINE VIBRATION.SDR 2000UALA00569Light · inoperativeEMERGENCY EGRESS LIGHT OUT AT SEAT 12A, B AND C. REPLACED EMERGENCY EGRESS LIGHT AT SEAT 12A, B AND C. OPERATIONAL CHECK OK.
Back to N804UA