N671UA
Service difficulty reports · 383
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 = 'N671UA' 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 = 'N671UA' 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 UALA2009062301772Light · inoperativeSEAT 2AB EMERGENCY LIGHT INOP. REPLACED LIGHT, OPS CHECKS GOOD.SDR UALA2009061501697Lug · defectiveNR 1 ENG GEN FEEDER CABLES AT IDG LOWER CABLE BURNT. REPLACED DEFECTIVE LUGS. OPS CHECKED AND INSPECTED. OPS CHECKED GOOD.SDR UALA2009061601719Wire Harness · defectiveRIGHT CENTER AUX DENSITOMETER HARNESS M1952 FAILS LOOP RESISTANCE CHECK, TOO HIGH. REPAIRED SHIELD BRAID AND RE-TERMINATED. INSPECTED AND OPS CHECKED GOOD.SDR UALA2009061501682Bracket · buckledFLOORBEAM AT BS 246, PULLEY BRACKET BUCKLED AT LBL 4. MAJOR REPAIR ACCOMPLISHED: INSTALLED NEW ANGLE, P/N 141T528.SDR UALA2009061501681Skin · crackedRT EXTERNAL FUSELAGE SKIN, 3 INCH CRACK AT BS 1664 AND STR 13R. MAJOR REPAIR ACCOMPLISHED: CUT OUT DAMAGED SKIN SECTION AND INSTALLED FILLER DOUBLER REPAIR.SDR UALA2009061201667Stiffener · crackedFLOORBEAM AT BS 246, PULLEY SUPPORT CRACKED AT RBL 16. MAJOR REPAIR ACCOMPLISHED: REMOVED CRACKED STIFFENER, P/N 255T1241U33. INSTALLED NEW STIFFENER.SDR UALA2009061201666Support · crackedFLOORBEAM AT BS 246, PULLEY SUPPORT CRACKED AT BL 0. MAJOR REPAIR ACCOMPLISHED: INSTALLED NEW BRACKET P/N 141T5282-6.SDR UALA2009061101654Latch · wornRT OVERWING SLIDE DOOR LATCH NR 3 SLIDER WORN. INSTALLED NEW NR 3 DOOR LATCH; ADJUSTED, OPS CHECK GOOD.SDR UALA2009061101653Latch · wornRT OVERWING SLIDE DOOR LATCH NR 4 SLIDER WORN. REPLACED NR 4 DOOR LATCH, ADJ LATCH SYSTEM. OPS CHECKS GOOD.SDR UALA2009060901636Aspirator · leakingASPIRATOR LEAKING FROM SEAL. NO EXTERNAL DAMAGE EVIDENT. REPLACED ASPIRATOR.SDR UALA2009060301595Panel · malfunctionedAPU REMOTE FIRE IND (B34) C-B ON P11 PANEL HAD POPPED. REPLACED L542 APU ARMED LT ASSY ON P40, ARMED & DISCHARGE LIGHTS CHECK OK, APU FIRE TEST OK.SDR UALA2009042301178Valve · failedL ENG PRV EICAS MSG ON T/O ROLL. REJECTED T/O AT 75KTS. REPLACED PRV.SDR UALA2009040600985Module · faultyTWO MINUTES AFTER DEPARTURE TIME CREW REPORTED APU QUIT. REPLACED FLOW SENSING MODULE, OPS NORMAL.SDR UALA2009031100753Light · missingCABIN MISSING OR BROKEN EMERGENCY LIGHT AT SEATS 27B, 32B, 39B, 31H. NEEDS 4EA LIGHT ASSY'S. INSTALLED 1 SERVICEABLE EMERGENCY LIGHT AT 31H. OPS CHECKED SYS AT NOTED SEAT. SYS OPS NORM, RETURNED SEAT BACK TO NORM. HOWEVER SEATS AT 27B, 32B & 39B STILL NEESDR UALA2009031100752Light · missingFIRST CLASS EEL LT MISSING ROW 6B AFT LT. INSTALLED SERVICEABLE EEL LIGHT, OPS CHECKED SAME. SYS OPS NORM, RETURNED A/C BACK TO NORMAL. OK FOR SVC.SDR UALA2009012700287Light · missingSEAT 4B AISLE EMERGENCY LIGHT MISSING. REPLACED EEL LIGHT STRIP ON SEAT 4AB.SDR UALA2009022400639Skin · dentedSKIN - 2EA SKIN DENTS AT STA 1660, BELOW STR 7L & 8L. MAJOR REPAIR ACCOMPLISHED PER EVA 72221A.SDR UALA2008122306981Transmitter · faultyB4 ENGINE START RT ENGINE OIL QTY READS 1 QT. CHECKED OIL QTY AND FOUND FULL. REPLACED NR 2 ENGINE OIL QUANTITY TRANSMITTER.SDR UALA2008121606902Light · missingSEAT 39H IS MISSING SEAT MOUNTED EMERGENCY EXIT PATH LIGHT. INSTALLED NEW PATH LIGHT. OP CHECKS GOOD.SDR UALA2008121606901Module · crackedNR 2 ENG HIGH OIL CONSUMPTION EXCEEDS LIMIT. NR 2 ENG PLATE WHERE STARTER MOUNTS ON GEARBOX IS CRACKED AT LEAST 8 INCHES AND LEAKING OIL. REPLACED STARTER DRIVE MODULE AND HOUSING. ALSO REPLACED ACCELEROMETER (P/N 144-151-000-101). OPERATIONS AND INDICATISDR UALA2008112406636Light · inoperativeLONG EEL FLOOR STRIP IN AFT GALLEY IS INOP. REPLACED EEL STRIP. CHECKS GOOD.SDR UALA2008112406635Battery · dischargedSEATS 20A THRU 22A EEL IS INOP. REPLACED BATTERY, CHECKS GOOD.SDR UALA2008112406634Connector · unsecureSEAT 5H EEL LIGHT IS INOP. SECURED SEAT CONNECTOR. CHECKS GOOD.SDR UALA2008112406633Light · missingSEAT 3A & 4A EEL LIGHTS ARE MISSING. RELAMPED 3A & 4A. OPS CHECK OKAY.SDR UALA2008111306412Module · faultyLEADING EDGE SLAT DISAGREE GOING FROM FLAPS 20 TO 25. REPLACED FLAP-SLAT SHUTOFF VALVE MODULE.SDR 2008UALA06412Module · faultyLEADING EDGE SLAT DISAGREE GOING FROM FLAPS 20 TO 25. REPLACED FLAP-SLAT SOV MODULE.SDR 2008UALA06355Starter · faultyDURING RIGHT ENGINE START, START SWITCH IN GND POSITION WITH N2 READING 6 PERCENT START. STARTER IS DEFECTIVE. REPLACED NR 2 ENGINE STARTER & STARTER. OPS CHECKS GOOD.SDR 2008UALA06289Starter · faultyLEFT ENGINE START VALVE CLOSED EARLY DURING ENGINE START. PUSH CREW REPORTED SPARKS COMING FROM ENGINE. REPLACED NR 1 ENGINE STARTER & START VALVE. OPS & AIR LEAK CHECKS GOOD.SDR 2008UALA05964Pump · leakingNR 1 ENGINE EDP IS LEAKING THROUGH DRAIN TUBE. LEAK IS BEYOND LIMITS. REPLACED NR 1 ENG EDP AND GARLOK SEAL. OKAY FOR SERVICE.SDR UALA2008111304064Light · inoperativeMADE A TOWER FLYBY AND LANDED UNDER AMBER ALERT DUE TO LEFT LANDING GEAR INDICATION PROBLEM. FOUND BASE ASSY INOP. REPLACED BASE ASSY LEFT GEAR INDICATION CHECKS OKAY.SDR 2008UALA04064Warning Light · illuminatedMADE A TOWER FLYBY AND LANDED UNDER AMBER ALERT DUE TO LEFT LANDING GEAR INDICATION PROBLEM.SDR 2008UALA03876Line · crackedLOST RIGHT HYDRAULIC SYSTEM. FOUND TUBE FROM REVERSER ISOLATION VALVE CRACKED. REPLACED TUBE WITH FLEX LINE. LEAK CHECK GOOD. OPS CHECKED OKAY FOR SERVICE.SDR 2008UALA02624Battery Pack · inoperativeEEL LIGHTS INOP LEFT SIDE FIRST CLASS. REPLACED BATTERY PACK. TEST OK.SDR 2008UALA02536Controller · faultyAPU STARTED AND THEN QUIT. REPLACED CONTROLLER PER MM 49-61-05 OPS NORMALAC OK FOR SERVICE.SDR 2008UALA02173Apu · shutdownAPU SHUT DOWN ON ITS OWN AT THE GATE. FOUND METAL IN OIL FILTER AND CHIP DETECTOR. REPLACED APU. OP CHECKS NORMAL.SDR 2008UALA01937Idg · faultyEICAS MSG R GEN DRIVE DISPLAYED.GEN DRIVE LGT ILLUM. GEN DRIVE DISCONNECTED. REPLACED RT ENGINE IDG PER MM 24-11-01-401 RAN ENGINE OPS GOOD. AC OK FOR SERVICE.SDR 2008UALA01911Shutoff Valve · leakingLEFT O/B FUEL VALVE LEAKING THROUGH MANUAL OPERATION KNOB. FOUND LEAKING FUEL SHUT OFF VALVE ALSO FOUND A FAULTY RELAY K180 FOR VALVE OPERATION.
REPLACED 1 EACH VALVE AND 1 EACH RELAY. AC OK FOR SERVICE.SDR 2008UALA01588Battery · dischargedEMERGENCY EXIT PATH LIGHTING FLASHING ON & OFF INTERMITTENTLY. FOUND BATTERY DEAD IN FIRST CLASS. REPLACED BATTERY, OP CHECKS GOOD.SDR 2008UALA01565Generator · faultyWITH APU RUNNING, GEN OFF LIGHT ILLUM AFT NR 1 ENG START WITH PWR TRANSFER. CYCLED APU GEN GCU, NO HELP. BOTH ENG GENS ON LINE AND RESET. NO HELP.SDR 2008UALA01564Battery Pack · intermittentEMERGENCY EXIT PATH LIGHTING FLASHING ON & OFF INTERMITTENTLY. REPLACED BATTERY. OP CHECKS GOOD.SDR 2008UALA01022Skin · damagedFUSELAGE DAMAGE AT STA 650 STR 31L TO 35L HAS GOUGE APPROX .060 DEEP.SDR 2008UALA00968Skin · damagedFUSELAGE DAMAGE AT APPROX STR 32LT STA 610 DENT APPROX .097 DEEP.SDR 2008UALA00905Structure · damagedFUSELAGE DAMAGED AT APPROX STRINGER 31L STA 610, DENT APPROX .097 DEEP.SDR 2008UALA00614Actuator · faultyEICAS MSG SPOILERS DISPLAYED. SPOILERS LIGHT ILLUM WITH SPOILERS SELECTED UP. FAULTY POWER CONTROL ACTUATOR. REPLACED NR 9 PCA PER MM 27-61-02. OPS CHECK GOOD. ACFT OK FOR SERVICE.SDR 2008UALA00493Lamp · inoperativeRIGHT FIRE HANDLE NEEDS RELAMPING. FOUND FAULTY BULB. REPLACED BULB.
ACFT OK FOR SERVICE.SDR 2008UALA00460Light · inoperativeEMERGENCY LIGHT ON SEAT 3B IS INOP. RELAMPED EMERGENCY LIGHT.SDR 2008UALA00459Connector · looseEMERGENCY EXIT SEAT LIGHTS INOP RIGHT SIDE ROWS 26-36. RESECURED CONNECTOR.SDR 2008UALA00457Light · inoperativeLEFT AND RIGHT MID LAV EEL LIGHTS INOP. REMOVED AND REINSTALLED. OPS CHECKS NORMAL.SDR 2008UALA00458Insert · dislodgedRIGHT OVERWING SLIDE COMPARTMENT SLIDE PACK INFLATION HOSE CLAMP INSERT HAS COME OUT. LOCATED ON BACKSIDE OF SLIDE TRAY. REPLACED SLIDE. ACFT OK FOR SERVICE.SDR 2008UALA00412Light · brokenSEAT 38H EMERGENCY STRIP LIGHT BROKEN. REMOVED AND REPLACED LIGHT STRIP.
Back to N671UA