N404UA
Service difficulty reports · 116
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 = 'N404UA' 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 = 'N404UA' 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 2005UALA01142Light · inoperativeSEAT MOUNTED EEL LIGHT INOP AT SEAT 13ABC. REPLACED CABLE ASSY.SDR 2005UALA00987Skin · damagedFUSELAGE SKIN IN AREA AROUND DOOR 2L IS DAMAGED. REPAIRED AREA AROUND DOOR 2L WITH DOUBLER PER SRM 53-00-11 PR 313-314.SDR 2005UALA00266Duct · looseLEFT WING LEAK DISPLAYED ON UPPER ECAM. FOUND DUCT LOOSE AT FIRST CLAMP AFT OF THE GROUND AIR CONNECTOR. REPOSITIONED DUCT AND RESECURED CLAMPS.SDR 2005UALA00261Duct · disconnectedLT WING LEAK DISPLAYED ON UPPER ECAM. FOUND DUCT DISCONNECTED AT GROUND BLEED AIR CONNECTOR. RECONNECTED DUCT.SDR 2003UALA00902Skin · contaminatedLEFT ELEVATOR UPPER SKIN HAD ONE AREA OF WATER INGRESS. MAJOR REPAIR ACCOMPLISHED. DAMAGE REPAIRED PER SRM 55-21-11, REP 5E, PG 226, FIG 205, SHEET 3.SDR 2003UALA00901Skin · contaminatedRT ELEVATOR UPPER SKIN HAD 2 AREAS OF WATER INGRESS. MAJOR REPAIR ACCOMPLISHED. DAMAGE REPAIRED PER SRM 55-21-11, REP 5E, PG 226, FIG 205 SHEET 3 & 4.SDR 2003UALA00045Blade · fracturedCOMPRESSOR STALL NR 2 ENGINE. THROTTLED TO IDLE, ENGINE WAS NOT SHUTDOWN. ENGINE TEARDOWN REVEALED C6 BLADE FAILURE RESULTING FROM NICKED C6 VANE. BIRD INGESTION 17 DAYS PRIOR HAD BEEN BORESCOPED WITH NO FINDINGS IN FIRST THREE STAGES.SDR 2003UALA00007Oil Cooler · leakingNOXIOUS ODOR IN CABIN AFTER TAKEOFF. SUBJECT APU OIL LEAK WAS CONFIRMED AT TEST. OIL COOLER WAS LEAKING SEVERELY (APPROX 1/2 QT. / MINUTE) FROM THE INLET SIDE OF THE PRESSURE REGULATOR. FURTHER DISASSEMBLY REVEALED SEVERAL DEEP VERTICAL SCRATCHES EVIDENT ASDR 2002UALA00201Idg · overheatedNR 1 INTEGRATED DRIVE GENERATOR DISCONNECTED AND UNABLE TO START AUXILIARY POWER UNIT. REPLACED NR 1 ENGINE INTEGRATED DRIVE GENERATOR.SDR 2001UALA02074Computer · malfunctionedON CLIMBOUT FELT STRONG VIBRATION IN RUDDER PEDALS. STRONG VIBRATION WAS FELT IN THE REAR OF THE CABIN. THE VIBRATION WAS REPORTED AS BEING A SIDE-TO-SIDE MOTION. FAC (FLIGHT AUGMENTATION COMPUTER) WAS REPLACED.SDR 2001UALA00782Tube · unserviceableSLIDE/RAFT D30665-105 TOP INFLATION TUBE RT SIDE SEAM FAILED DURING PROOF PRESSURE TEST. TOP TUBE HAS A 4 FOOT SEAM RIP ON RT SIDE ABOVE THE REDUCER BULKHEAD FROM THE FAILURE. UNIT IS BEING SENT TO THE VENDOR FOR REPAIR.SDR 2000UALA00665Window · delaminatedOUTER LAMINATE WINDOW R-3 PEELED OFF IN FLIGHT. SUPPLEMENTAL DATA UPDATE INITIAL FINDINGS SHOW STRONG PROBABILITY THAT THE FAILURE OCCURRED DUE TO SUBSTANDARD INTERLAYER BONDING DUE TO A BAD PRIMER USED DURING PRODUCTION. REPLACED WINDOW.SDR 98ZZZX4613Seat Pan · crackedDURING FIRST HEAVY MAINTENANCE VISIT FOR THIS AIRBUS, A-320-232, 100 PERCENT OF THE SEAT PANS WERE FOUND CRACKED ON THE RECARO MODEL 3410, 720 SERIES PASSENGER SEATS USED IN THE COACH CLASS CABIN. THESE SEAT PANS ARE CRACKED ADJACENT TO THE SCREW HOLES ON THESDR 98UAL900394Pump · failedCREW REPORT, GREEN EDP LOW PRESSURE AND LOW GREEN SYSTEM PRESSURE. QUANTITY IS INDICATING ZERO AMBER ALERT. RETURNED TO DENVER. *S/D* GREEN SYSTEM HYD PUMP REPLACED.SDR 95UAL900302Proximity Switch · dirtyCREW REPORTED, THAT THE FORWARD CARGO DOOR LIGHT CAME ON INTERMITTENTLY IN CRUISE AND THEN WENT OUT. FOUND DOOR PROXIMITY SWITCH DIRTY, CLEANED AND OPERATIONALLY CHECKED NORMAL.SDR 95UAL900082Engine · flame-outNUMBER ONE ENGINE FLAMED-OUT IN FLIGHT.
Back to N404UA