N431UA
Service difficulty reports · 130
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 = 'N431UA' 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 = 'N431UA' 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 UALA2011080103972Seal Depressor · damagedFWD CARGO PIT AFT SIDE DEPRESSOR SEAL DAMAGED BY BELT LOADER. REPLACED UPPER SEAL SECTION AND MIDDLE SECTION.SDR UALA2011071503604Oxygen Mask · unsecureTHE 31DEF O2 MASKS FELL DOWN. REPACKED O2 MASKED AND ACCOMPLISHED DROP TEST.SDR UALA2011061002867Idg · overheatedNR 1 IDG OIL OVHT ECAM, FLIGHT DIVERTED. SCREEN. - ELEC CREW COMMENTS: IDG 1 OVHT ECAM, DISCNT IDG 1 PER FM. SUCCESSFUL DISCNCT.SDR UALA2011011900332Microphone · inoperativeCAPTAIN'S O2 MASK MIC INOP. SWAPPED MASK W- NO JOY. C/P BOOM MIC AND HAND MIC WORK OK. RECONNECTED LINE TO FIRST OFFICERS OXYGEN MASK COMPARTMENT. ALSO, REPLACED FIRST OFFICERS AUDIO CONTROL PANEL.SDR UALA2011011900298Oxygen Mask · leakingFIRST OFFICER’S OXYGEN HARNESS FAILS TO INFLATE (IS LEAKING). REPLACED O2 STORAGE BOX AND MASK PER MM.SDR UALA2010072002592Connector · faultyDURING CABIN CREW CHECK, FOUND AT SEAT 17C THE FLOOR PROXIMITY EMERGENCY ESCAPE PATH MARKING SYS LIGHT DOES NOT LIGHT UP. ALL LIGHTS ADJACENT TO SEAT 17C ARE WORKING. SPLICED IN NEW CONNECTOR, LIGHT OPS CHECKS GOOD NOW.SDR UALA2010022500694Uplock Sensor · faulty"NOSE GEAR" INDICATION RED, RTFL. REPLACED 13GA UPLOCK NOSE SENSOR. PERFORMED FUNCTIONAL TEST OF NORMAL EXTENSION AND RETRACTION. TEST PASS.SDR UALA2009042901244Attach Bracket · brokenACCOMPLISH DOOR 1 LEFT SLIDE REMOVAL INSTALLATION AND INSPECTION FOR TRAINING PURPOSES. DURING INSPECTION OF DOOR 1 LEFT SLIDE, FOUND FWD LOWER ATTACH BRACKET BROKEN. REPLACED BRACKET.SDR 2008UALA03177Microphone · shortedCAPTAIN'S OXYGEN MASK MICROPHONE IS INOPERATIVE. CREW COMMENTS: MIC IS INTERMITTANT. SHORT IN MIC/MASK. REPLACED CAPT O2 MASK ASSY.SDR 2008UALA01768Oxygen Mask · faultyCAPTAIN'S O2 MASK RED PRESS TO TEST BUTTON MISSING SMALL PIECE OF BUTTON. MASK IS FULLY FUNCTIONAL. REPLACED CAPT O2 MASK ASSY, OPS CHECKED OK.SDR 2008UALA00862Oxygen Bottle · reads lowCOCKPIT OXYGEN BOTTLE, LOW CREW COMMENTS: CREW O2 NEEDS SERVICING. SERVICED CREW O2 TO FULL, NO LEAKS WERE NOTED AT THIS TIME.SDR 2008UALA00861Squib · faulty'ENG FIRE EXTINGUISHING-SQUIB' LIGHT OF 'AGENT 1' PUSHBUTTON SWITCH IS OFF DURING 'LOOP-SQUIB TEST'. SQUIB IS FAULTY. REPLACED SQUIB, ALL OPS CHECKS NORMAL.SDR 2007UALA05345Oxygen System · low pressureCOCKPIT O2 1340 PSI, WITH AMBER HALF-BOX. SERVICED CREW O2, CHECKED FOR LEAKS, NONE NOTED.SDR 2007UALA04154Anti-Skid Sys · misinstalledUPON LANDING ACFT DEVIATED FROM RUNWAY. PROBLEM WITH ANITSKID SENSING SYSTEM. AFTER INVESTIGATION IT SEEMS THAT DURING HMV LT AND RT SYSTEMS WERE INADVERTENTLY SWITCHED. A/C DOWN SEVERAL WEEKS WHILE REPAIRS WERE COMPLETED. NOTE: 2 NEW ENGINES WERE INSTALLSDR 2007UALA01145Proximity Sensor · contaminatedRTFL UNDER AMBER ALERT DUE TO NLG NOT RETRACTING. [SUP 06-06-07] INITIALLY REPLACED THE NR 2 LGCIU, BUT FURTHER TROUBLESHOOTING FOUND THE NOSE LANDING GEAR PROXIMITY SENSORS TO BE COVERED IN GREASE. CLEANED PROXIMITY SENSORS 12GA, 18GA, 30GA AND 31GA.SDR 2007UALA00374Frame · crackedNR 2 INBOARD REVERSER AT 7:00 POS FRAME IS CRACKED IN HALF. AFT END OF CASCADE VANES ATTACH TO FRAME. [5-1-07] REPLACED FRAME DURING HMV. FRAME HAS HISTORY IN THE INDUSTRY OF CRACKING, SERVICE BULLETIN IAE V2500-NAC-78-0209 ADDRESSES PART OF THE ISSUE . THE SDR 2007UALA00333Attach Fitting · corrodedFWD PIT HAS CORROSION ON STRINGER AND FRAME CLIP FASTENERS FROM FRAME 24 THRU 31 AND FROM STRINGER 39R TO 40L. REPLACED 1098 RIVETS.SDR 2007UALA00332Attach Fitting · corrodedFWD FRAME CLIP AND STRINGER FASTENERS HAVE CORROSION FROM FRAME 31 TO 35 AND FROM STR 38R TO 38L. REPLACED 752 CORRODED RIVETS.SDR 2007UALA00168Sill · corrodedAFT RIGHT DOOR SILL PLATE HAS CORROSION DAMAGE AT INBOARD EDGE MID POINT OF PLATE. MAJOR REPAIR. INSTALLED DOUBLER REPAIR PER SRM.SDR 2006UALA02051Skin · damagedLT WING LOWER SKIN FUEL PLATE 540HB FASTENER HOLE DAMAGED. PERMANENT REPAIR ACCOMPLISHED PER EVA 60643.SDR 2006UALA02050Skin · damagedRT WING LOWER SKIN FUEL PLATE 640PB CUT OUT FASTENER DAMAGED. PERMANENT REPAIR ACCOMPLISHED PER EVA 60643. MAJOR REPAIR REPORTED BECAUSE A REPAIR WAS ACCOMPLISHED ON A PRINCIPLE STRUCTURAL ELEMENT.SDR 2006UALA01630Battery · faultyFOUND EMERGENCY BATTERY FAULT ON EMERGENCY LIGHT TEST FWD LT. REPLACED BATTERY.SDR 2006UALA01333Light · inoperativeFOUND EMERGENCY LIGHT INOP AT SEAT 8C. REPLACED WIRE ASSEMBLY FROM SEAT ELECTRONIC BOX TO LIGHT ASSEMBLY, ALSO REPLACED LIGHT ASSEMBLY REF MM 33-51-19, OPS CHECK OK.SDR 2006UALA01332Light · inoperativeFOUND EMERGENCY LIGHT INOP AT SEAT 26C. REPLACED LIGHT ASSEMBLY, OPS CHECKS OK.SDR 2005UALA01393Light · inoperativeEMERGENCY LIGHTS AT SEATS 15-17, 20-23 INOPERATIVE. REPLACED EEL POWER SUPPLY.SDR 2005UALA00644Controller · failedNR 1 LGCIU FAULT FOLLOWED BY LOSS OF VH2 RADIO AND THRUST REVERSER. LGCIU FAULT DISPLAYED DURING CRUISE. ACP LGCIU SYSTEM GRND TEST REF MM 32-69-00. TEST OKNO FAULTS FOUND.SDR 2005UALA00618Battery · dischargedNUMEROUS FLOOR PROX EEL LIGHTS INOP THROUGHOUT CABIN. BPOWER SUPPLIES LOW CHARGE. REPLACED MID AND AFT PWR SUPPLIES.SDR 2003UALA00721Coffeemaker · failedRETURN TO FIELD DUE TO ELECTRICAL ODOR IN CABIN. REPLACED COFFEEMAKER M11 IN FORWARD GALLEY.SDR 2001UALA02359Wire · looseEMERGENCY EXIT LIGHTS ON LAST 3 ROWS OF SEATS ARE INOP. RESECURED WIRES AT SEATS 24C AND 26C. LIGHTS OPERATIONAL CHECK NORMAL.SDR 2000UALA00339Blade · failedNR 2 ENGINE FAILED IN FLIGHT. MAX EXHAUST GAS TEMPERATURE EXCEEDED. *S/D* THE IFSD WAS CAUSED BY A FAILURE OF A HIGH PRESSURE COMPRESSOR (HPC) 4TH STAGE (C4) BLADE. THE ROOT CAUSE OF THE BLADE FAILURE WAS HIGHER-THAN-NORMAL HIGH CYCLE FATIGUE STRESS CAUSED
Back to N431UA