N171UA
Service difficulty reports · 293
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 = 'N171UA' 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 = 'N171UA' 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 UALA2012092405425Reveal · crackedWINDOW 7J INNER PANE SEAL WEAK. FOUND WINDOW ASSY INNER BOTTOM CRACKED. ASSY CANNOT KEEP IN POSITION. INTERIM REPAIR WITH TAPE. MAKE CF ITEM. REMOVED AND REPLACED 7J WINDOW REVEAL AS REQUIRED. SHADE OPS CHECKS GOOD.SDR UALA2012092405424Battery · faulty1L EEL STRIP FLICKERS ON THE WALL. REPLACED BATTERY, SYSTEM CHECKS GOOD.SDR UALA2012082704804Light · brokenEMERGENCY LIGHT SEAT 42H BROKEN IN HALF. REPLACED EMERGENCY LIGHT SEAT 42H, OPERATIONAL CHECK OKAY.SDR UALA2012082704803Circuit Breaker · faultyCAPT'S WINDSHIELD AIR FAILED. CREW COMMENTS: AT FL330. FOUND BOTH CAPT & F/O WINDSHIELD DEFOG VALVES FAILED CLOSED. MANUALLY OPENED BOTH VALVES PER MEL REQUIREMENTS, AIRFLOW NOTED ON BOTH CAPTS & F/O'S WINDOWS. REPLACED CIRCUIT BREAKER C10291 ON THE P180 PSDR UALA2012080804282Cover · unsecureCOCKPIT ESCAPE HATCH NEEDS TO BE RETAPED. SECURED ESCAPE HATCH COVER.SDR UALA2012073004113Actuator · failedON PUSHBACK, APU INLET DOOR ADVISORY AND STATUS MESSAGE. FOUND APU DOOR IS PARTIALLY OPENED. INSTALLED NEW ACTUATOR.SDR UALA2012072303959Socket · faultyUPPER DECK CEILING LIGHT AT SEAT 17 IS INOPERATIVE. REPLACED LIGHT SOCKETS. CHECKS NORMAL.SDR UALA2012062203306Controller · faultyAIRCRAFT HAVING TROUBLE ACCEPTING FUEL. MANIFOLD NOT OPENING. REPLACED NR 3 REFUEL VALVE CONTROLLER.SDR UALA2012061103222Lamp · inoperativeEMERGENCY CEILING LIGHT AT ROW 50. RELAMPED, OPS CHECKED NORMAL.SDR UALA2012061103221Lamp · inoperativeEMERGENCY LIGHT UPPER DECK CEILING AT ROW 13 INOPERATIVE. RELAMPED, OPS CHECKED NORMAL.SDR UALA2012061103220Connector · unsecureEMERGENCY LIGHT INOPERATIVE AT SEAT 51 ABC. SECURED CONNECTOR, OPS CHECKED NORMAL.SDR UALA2012050102583Lamp · inoperativeR2 DOOR GALLEY AREA LOWER SIDEWALL EMERGENCY LIGHT IS INOPERATIVE. RELAMPED. CHECKED NORMAL PER MM 33-51-12.SDR UALA2012050102581Lamp · inoperativeUPPER DECK CEILING EMERGENCY LIGHTS 2EA IS INOPERTIVE. RELAMPED CEILING LIGHTS IN UPPER DECK CEILING. CHECKED NORMAL.SDR UALA2012050102580Lamp · inoperativeSEAT 53 HJK EMERGENCY LIGHT IS INOPERATIVE. RELAMPED, OPS CHECKED NORMALSDR UALA2012042002393Lamp · inoperativeSEAT BELT AND NO SMOKE SIGN INOPERATIVE. REPLACED LAMPS, OPS CHECKED OKAY.SDR UALA2012032201819Drain Valve · leakingFOUND LEFT HST SUMP DRAIN SOLENOID LEAKING EXTERNALLY. RE-ACTIVATED HST ISO VALVES DV439 AND DV440 AS REQUIRED. ON ARRIVAL CHECK FOUND FUEL SEEPAGE FROM RT HORIZONTAL STABILIZER DRAIN HOLE NEAR STA 285. MUST EMPTY TANK AND CONFIRM NO LEAKS BEFORE DEPT. HST SDR UALA2012031201586Fireshield · wornNR 4 ENG OUTBOARD CORE COWL TRAILING EDGE IS WORN. NR 4 ENGINE, RT CORE COWL FIRESHIELD WORN. REPLACED CORE COWL.SDR UALA2012031201583Light · inoperativeDOOR 2 GALLEY AISLE EMERGENCY LIGHT FWD WALL INOPERATIVE. RELAMPED, CHECKS NORMAL.SDR UALA2012031201582Light · inoperativeUPPER DECK DOOR RT EMERGENCY LIGHT INOP. RELAMPED, CHECKS NORMAL.SDR UALA2012031201584Light · inoperativeDOOR 4 LT FWD EMERGENCY SILL LIGHT INOP. RELAMPED, CHECKS NORMAL.SDR UALA2012020800765Line · leakingWATER LEAKING FROM THE BELLY OF FUSELAGE UNDER THE AFT CARGO PIT. COMPLIED WITH MEL 3810W, ONLY TO REVERSE MEL PROCEDURE AFTER LINE REPLACED. NEW LINE INSTALLED AND LEAK CHECK GOOD.SDR UALA2012012000429Battery Pack · dischargedSEAT ROW 54HJK TO 60 HJK EMERGENCY LIGHTS IS INOP. REPLACE BATTERY PACK FOR EMERGENCY LIGHTS SEAT ROWS 54-60 HJK. CHECKS NORMAL.SDR UALA2012011200257Circuit Card · failed"HUMID FLT DK" EICAS ADVISORY MESSAGE DISPLAYED. FLIGHT DECK HUMIDIFICATION SYSTEM FAILURE. REPLACED ECS CARD. YMLA13 CARD. OPS CHECKED COVERED ON DF444. REPLACED & REINSTALLED FLIGHT DECK HUMIDIFIER, OPS TESTED GOOD.SDR UALA2011121906981Ballast · faultyG1 GALLEY LIGHT REPORTED FLASHING. AREA INSPECTED. NO ODOR OR EVIDENCE OF ARCING. INSPECTED BEHIND CIRCUIT BREAKER PANEL. NO ODOR OR EVIDENCE OF ARCING. RELAMPED LIGHT ASSY. NO HELP. CIRCUIT BREAKER PULLED AND COLLARED. ALL OTHER COMPONENTS OPS NORMAL. . REPLASDR UALA2011122107002Trim Panel · misinstalledRUDDER AND AILERON TRIM PANEL IS INSTALLED THE WRONG WAY AND USE OF TRIM IS OPPOSITE OF WHA FOUND AIL, RUD TRM CTL PANEL MOUNTED UP SIDE DOWN AND TRIM INDICATOR IN WRONG POSITION AS STATED. REMOVED AIL, RUD TRIM CTL PANEL TO CORRECT CONFIGURATION AND RELOCATESDR UALA2011121406832Frame · crackedBS 2120 FRAME UPPER STRUCTURE CRACKED BETWEEN RBL 40 & RBL 45.3. MAJOR REPAIR ACCOMPLISHED, MANUFACTURED & INSTALLED NEW FRAME SECTION REF ECRA 5300-01382, EN 747EN-53-038 5.SDR UALA2011121206793Intercostal · crackedLEFT OVERWING INTERCOSTAL WEB CRACKED BS 1220. MAJOR REPAIR ACCOMPLISHED. REPLACED WEB SECTION PER SB 747-53A2750.SDR UALA2011121206792Intercostal · crackedRIGHT OVERWING INTERCOSTAL WEB CRACKED BS 1220. MAJOR REPAIR ACCOMPLISHED. REPLACED WEB SECTION PER SB 747-53A2750.SDR UALA2011121206791Intercostal · crackedRIGHT OVERWING INTERCOSTAL WEB CRACKED BS 1200. MAJOR REPAIR ACCOMPLISHED. REPLACED WEB SECTION REF SB 747-53A2750.SDR UALA2011112106395Stringer · corrodedFOUND BULGES IN FUSELAGE SKIN AT AND BETWEEN RIVETS IN STR 51R AND 51L APPROX BODY STA 1940-1950. PERFORMED VISUAL INTERNAL INSPECTION, CORROSION APPEARS TO BE LOCALIZED TO AREA BETWEEN STRINGERS AND SKIN AT TWO LOCATIONS STR 51L&R STA 1945 LUMP APPEARANCE LASDR UALA2011111606275Light · inoperativeTWO EMERGENCY AISLE CROSSOVER LIGHTS INOP AT BOTTOM OF STAIRWAY. RELAMPED, OPS CHECK OKAY.SDR UALA2011110906123Light · missingSEAT MOUNTED EMERGENCY LIGHT MISSING. REPLACED MISSING EMERGENCY LIGHT.SDR UALA2011102105690Oxygen Mask · no testCAPTAIN'S OXYGEN MASK WILL NOT TEST. REPLACED OXYGEN MASK PER 35-11-18-0401, 35-11-00 PG 506.SDR UALA2011101305569Lamp · inoperativeAFT FLOOR EMERGENCY LIGHT INOPERATIVE. RELAMPED, OPS CHECKED NORMAL.SDR UALA2011101305568Lamp · inoperativeEMERGENCY LIGHT AT SEAT 56 ABC INOPERATIVE. RELAMPED, OP CHECKED NORMAL.SDR UALA2011101305567Lamp · inoperativeEMERGENCY LIGHT AT SEAT 25 ABC INOPERATIVE. RELAMPED, OP CHECKED NORMAL.SDR UALA2011091905029Cowling · damagedUNDERSIDE OF NR 4 ENGINE NACELLE IS DAMAGED. REPLACED INLET COWL NR 4 ENGINE REF MM & CHECKS REF JRH 2-86-1, ALL SATISFACTORY, NO FURTHER DEFECTS.SDR UALA2011091604993Nose Cowl · damagedNOSE COWL DAMAGED BY GROUND EQUIP. UNDERSIDE OF NUMBER 4ENGINE NACELLE IS DAMAGED. CARRIED OUT INSPECTION. WILL REQ RPL OF NOSE COWL. PCN 185-9199 COWL AND SLING 056-0097 ON ORDER. RPLC'D INLET COWL NR 4 ENGINE AND CHECKS ALL SATISFACTORY, NO FURTHER DEFECTSSDR UALA2011082604570Light · inoperativeDOOR 3R FWD SILL EMERGENCY LIGHT IS INOP. RELAMPED, CHECKS NORMAL.SDR UALA2011082604569Battery Pack · dischargedUPPER DECK EMERGENCY LIGHT ABOVE STAIRWAY IS INOP. REPLACED EEL BAT PACK, OPS CHECK NORMAL.SDR UALA2011082604568Light · inoperativeSEAT 53HJK EMERGENCY LIGHT IS INOP. RELAMPED, OP CHECK NORMAL.SDR UALA2011082604567Light · looseSEAT 25 HJK EMERGENCY LIGHT IS INOP. RESECURED EMERGENCY LIGHT, OP CHECK NORMAL.SDR UALA2011082604566Light · inoperativeLEFT OVERWING SECOND LIGHT ASSY FWD LAMP IS INOP. RELAMPED, OP CHECK NORMAL.SDR UALA2011082604565Battery Pack · dischargedUPPER DECK RIGHT WING DOOR 2 EA EMERGENCY LIGHTS IS INOP. REPLACED RT UPPER DECK EMERGENCY BATTERY PACK, ALL LAMPS CHECK OKAY.SDR UALA2011082604576Skin · corrodedRT UPPER WING SURFACE HAS CORROSION JUST FWD OF DOOR 3R APPROX 2FT OUT FROM WING ROOT. BLENDED AREA, PERFORMED ULTRA SOUND INSP FOUND .310" MATERIAL REMAINING AT DEEPEST BLENDED AREA. ACP-HFEC SURFACE EDDY CURRENT CHECK FOR CRACKS AT WING SURFACE INDICATED BSDR UALA2011071703615Housing · leakingFUEL LEAKING FROM RT HST INBD PCU HOUSING DRAIN HOLE. BOROSCOPED RT INBD HST PCU ACT HOUSING. FOUND SEVERAL LEAKS AT INBD SIDE FASTENERS MID SECTION.BLOWN BACK TO CLEAN AND VERIFIED SOURCE OF LEAK. DEFUELED HST AND SUMPED. BLOW BACK SUSPECTED AREA, NO LEAKSDR UALA2011070503329Valve · malfunctionedON TAXI OUT AT SFO FUEL WAS COMING OUT THE RT SIDE VENT. WILL NEED TO CHECK FUEL FILL VALVES PER MM. IF GOOD WILL NEED TO CHECK FUEL VENT VALVES. ALL TANK FUEL VALVES OPERATE NORMAL AND ARE CLOSING. FILLED WING TANKS TO FULL TAXIED AIRCRAFT 15 MINUTES NO FSDR UALA2011070503333Light · unsecureLOWER EXIT PATH LIGHTING AT 2R IS HANGING OFF. SECURED LIGHT, OP'S CHECKED GOOD.SDR UALA2011070103247Light · brokenLAV 102 LOWER CORNER EMERGENCY LIGHT BROKEN. SECURED EMERGENCY LIGHT.SDR UALA2011052502558Lamp · inoperativeTWO EA EMERGENCY LIGHTS NEAR FLOOR BETWEEN DOOR TWO LEFT AND TWO RIGHT LIGHTS INOPERATIVE. RELAMPED, OPS CHECKED GOOD.
Back to N171UA