N429UA
Service difficulty reports · 118
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 = 'N429UA' 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 = 'N429UA' 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 2007UALA03169Skin · damagedEXTERNAL FUSELAGE SKIN LT SIDE, APPROX 9 FT AFT OF NOSE GEAR, 4 FEET ABOVE FUSELAGE CENTER LINE. *S/D* ACCOMPLISHED MAJOR REPAIR ON AREA.SDR 2007UALA03168Indicator · faultyENGINE 1 FIRE LOOP A FAULT INTERMITTENT. *S/D* FIRE DETECTION INDICATION UNIT FAULT. REPLACED 2WD1 FDIU.SDR 2007UALA02732Hydraulic System · leakingFLIGHT DIVERTED DUE TO YELLOW RSVR LOW LEVEL DISPLAYED ON UPPER ECAM. GREEN SYSTEM DROPPING TOO. FOUND PTU SUPPLY CHECK VALVE LEAKING. REPLACED PTU SUPPLY CHECK VALVE.SDR 2007UALA02575Smoke Warning · unknownFLIGHT DIVERTED DUE TO AVIONICS ECAM MSG SHOWING SMOKE.SDR 2007UALA00294Unknown · unknownRTFL WITH A LANDING GEAR DOOR WARNING MESSAGE. PROBLEM REOCCURED ON SUBSEQUENT FLIGHT. [SUP 05-08-07] AFTER RTFL OF FLIGHT 543, FAULT WAS ORIGINALLY TRACED TO A LOOSE PROXIMITY SWITCH. SWITCH WAS SECURED AND OPS CHECKED OK. ON NEXT FLIGHT, SAME WARNING MESSSDR 2006UALA00328Sill · damagedR2 DOOR SILL PLATE AT FRAME 68 APPROX RBL 50. APPLIED SIMPLE SRM DOUBLER ONTO DOOR SILL BEAM.SDR 2005UALA00927Floor Support · corrodedAFT GALLEY FLOOR SUPPORT 66-70 CORRODED. AMIS STATUS SHOWS THAT THE FLOOR SUPPORT WAS REPAIRED. REPAIRED OR REPLACED FLOOR SUPPORT IN ACCORDANCE WITH THE SRM.SDR 2005UALA00577Line · leakingLEFT WING BLEED LEAK. LEFT WING BLEED LEAK IN CRUISE. FLIGHT RETURNING TO DEN DUE TO ICING AND WX. FOUND VERY LARGE LEAK ON THE RT PACK OZONE CONVERTER AFT CLAMP, REMOVED CLAMP RE-ADJUSTED SEAL AND SECURED CLAMP, LEAK WAS BLOWING AT OVERHEAT LOOP ON KEELBEAMSDR 2004UALA01019Line · obstructedNR 1 ENGINE OIL QUANTITY DECREASED FROM 15 TO 7 QUARTS. AFTER LANDING THERE WAS SMOKE AND A SMALL FIRE FROM THE EXHAUST AREA. EXCESSIVE COKING OF THE NR 5 BEARING COMPARTMENT OIL SCAVENGE LINE CAUSED OVER PRESSURIZATION OF THE COMPARMENT. OIL WAS FORCED PASSDR 2004UALA00927Windshield · crackedFIRST OFFICERS WINDSHIELD ARCING AND CRACKING. MOISTURE INGRESSION THROUGH A SEAL. WINDSHIELD REPLACED.SDR 2004UALA00321Skin · damagedDAMAGE TO SKIN ON INSIDE OF AFT CARGO DOOR DIRECTLY BEHIND DOOR HANDLE HUB. MAJOR REPAIR ACCOMPLISHED. DOUBLER REPAIR INSTALLED ON DOOR INNER SKIN.SDR 2003UALA00789Light · inoperativeROWS 2AB, 11ABC, 21ABC, 22ABC, 25ABC EELS ARE INOPERATIVE. REPLACED EEL LIGHTS. CHECKS OKAY.SDR 2003UALA00625Filter · cloggedRETURN TO FIELD DUE TO AVIONICS VENT FAULT. AVIONICS COOLING SYSTEM FILTER REPLACED.SDR 2002UALA01435Hydraulic Line · rupturedABORTED TAKEOFF DUE TO ECAM HYDRAULIC GREEN RESERVOIR LOW LEVEL WARNING. FOUND RIGHT HAND MLG DOOR RETRACT ACTUATOR AFT FLEX LINE RUPTURED. REPLACED FLEX LINE.SDR 2002UALA00770Plate · stiffAFT CARGO DOOR ECAM WARNING ILLUMINATED. FOUND DOOR HANDLE PLATE STIFF. REMOVED PLATE, CLEANED, LUBED AND REINSTALLED.SDR 2002UALA00182Odor · detectedSMELL OF SMOKE IN CABIN. NO SMOKE VISIBLE. FLIGHT ATTENDANT SMELLED SMOKE IN THE CABIN. NO SMOKE WAS SEEN, SMELL WAS PUNGENT AND LOCATED JUST AFT OF 1ST CLASS. ACCOMPLISHED BITE CHECK OF THE TEMPERATURE CONTROL SYSTEM, CHECKED ALL FANS FOR OPERATION, CHECKSDR 2001UALA01123Transceiver · failedWEATHER RADAR SYSTEM INOP. REPLACED SCANNER ANTENNA AND TRANSCEIVER. OPERATIONAL CHECK OK.SDR 97UAL900507Skin Valve · stuck openCREW REPORTED UNABLE TO PRESSURIZE AIRCRAFT, SKIN OUTLET VALVE SHOWS FULL OPEN. *S/D* AVIONICS EQUIPMENT VENTILATION COMPUTER SKIN AIR OUTLET VALVE FAILED TO CLOSE AT TAKEOFF. DIFFERENTIAL PRESSURE COLLAPSED DUCTING. DUCTING AND VALVE REPLACED.
Back to N429UA