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 UALA2011080804109Bulb · inoperativeAFT LT OVERWING SLIDE LIGHT INOPERATIVE. CLEANED LAMP ASSY AND REPLACED BULB, OPS CHECKED OKAY.SDR UALA2011080804107Power Supply · inoperativeEMERGENCY EXIT SIGN ABOVE OVERWING EXIT INOPERATIVE. REPLACED POWER SUPPLY, OPS CHECKED OKAY.SDR UALA2011080804106Light · inoperativeEMERGENCY LIGHT INOPERATIVE AT SEATS 34HJ. REPLACED EMERGENCY LIGHT, OPS CHECKED OKAY.SDR UALA2011080804105Light · inoperativeEMERGENCY LIGHT INOPERATIVE AT SEATS 33HJ. REPLACED LIGHT, OPS CHECKED OKAY.SDR UALA2011080804108Light · inoperativeEEL STRIP INOP AT SEATS 3HJ. REPLACED EEL STRIP, OPS CHECKED OKAY.SDR UALA2011080304044Unknown · malfunctionedTCAS HAS FAILED. PERFORMED TCAS OPERATIONAL TEST PER MM. TCAS OP'S TEST OKAY.SDR UALA2011080103980Shutoff Valve · malfunctionedRIGHT ENGINE (BLEED) OFF LIGHT ON & RIGHT ENG BLEED OFF EICAS MESSAGE, WITH ENGINE RUNNING, ENGINE BLEED SWITCH ON, LT & RT ISOLATION VALVES CLOSED, A/C PACK SELECTED ON, & DUCT PSI IS ZERO. OFF LIGHT STAYS ON WHEN N1 IS ABOVE 41 PERCENT. RIGHT ENGINE BLEEDSDR UALA2011072503781Light · missingARMREST EMERGENCY LIGHT MISSING FROM SEAT 3H AND 6H 1EA. REPLACED LIGHT ASSEMBLIES. OPS CHECKED GOOD.SDR UALA2011070103232Idg · faultyRIGHT IDG WILL NOT COME ON LINE. IDG FOUND DEFECTIVE. REPLACED RIGHT ENGINE IDG. OP CHECK'S GOOD, NO FAULTS.SDR UALA2011062203069Battery Pack · dischargedEEL LIGHTS IN FROM 20HJ TO 25HJ. REPLACED BATTERY PACK, CHECKS GOOD.SDR UALA2011061502954Light · missingEMERGENCY SEAT LIGHT MISSING SEAT 3AB. REPLACED LIGHT, OPS GOOD.SDR UALA2011061502953Light · looseEMERGENCY EXIT LIGHT AT SEAT 2B IS LOOSE. REPLACED LIGHT, OPS GOOD.SDR UALA2011060602748Light · brokenSEAT AISLE SIDE EEL STRIP 2B BROKEN. REPLACED LIGHT STRIP. CHECKS OKAY.SDR UALA2011050902288Lens · missingAISLE EMERGENCY LIGHT AT SEATS 25HJ MISSING LENS. INSTALLED NEW LENS.SDR UALA2011050902293Light · missingEEL LIGHT ASSY MISSING AT SEATS 25HJ. INSTALLED NEW EEL LIGHT ASSY PER MM, OP CHECKS NORMAL.SDR UALA2011050902292Light · inoperativeRIGHT FWD MED EMER SLIDE LIGHT INOPERATIVE. RELAMPED, OP CHECKS NORMAL..SDR UALA2011050902291Light · brokenEEL LIGHT BROKEN AT SEAT 6H. REPLACED BROKEN EEL LIGHT ASSY PER MM, OP CHECKS NORMAL.SDR UALA2011050902290Battery Pack · dischargedEEL LIGHTS INOP BETWEEN SEATS 20HJ AND 25HJ. REPLACED BATTERY PACK M1554 PER MM, OP CHECKS NORMAL.SDR UALA2011050902289Battery Pack · dischargedEEL LIGHTS INOP BETWEEN SEATS 20AB AND 23AB. REPLACED BATTERY PACK M1559 PER MM, OP CHECKS NORMAL.SDR UALA2011050602235Light · unsecureSEAT 3H EXIT PATH LIGHTS DANGLING FROM RECEPTACLE. SECURED LIGHT.SDR UALA2011050502217Battery Pack · dischargedAISLE OVERHEAD EMERGENCY EXIT SIGN AT ROW 17 RIGHT SIDE WILL NOT ILLUMINATE DURING TEST. AISLE OVERHEAD EMERGENCY LIGHT EXIT OPS NORMALLY AFTER BATTERY PACKS REPLACED. REPLACED BATT PACKS M1554 & M1555. EMERGENCY LIGHTS OPERATING NORMALLY, STEADY.SDR UALA2011050302165Lens · missingEMERGENCY EXIT LIGHT LENS MISSING AT ROW 17TH, LEFT SIDE. FOUND LENS IN OVERHEAD BIN AND SECURED IN PLACE.SDR UALA2011050302168Battery Pack · dischargedEMERGENCY EXIT PATH LIGHTS LOCATED ON ALL H SEATS IN COACH COMES ON AND OFF THROUGHOUT FLT. AISLE OVERHEAD EMERGENCY EXIT SIGN AT ROW 17 RIGHT SIDE WILL NOT ILLUMINATE DURING TEST. REPLACED BATTERY PACKS M1554& M1555. EMERGENCY LIGHTS OPERATING NORMALLY, STSDR UALA2011050302167Light · inoperativeSEAT MOUNTED EMERGENCY LIGHTS AT SEATS 31AB AND 31HJ WILL NOT ILLUMINATE DURING TEST. SHROUD AT SEAT 31AB REMOVED FOR REPLACEMENT DUE TO SEAT MOUNTED EMERGENCY LIGHT ASSY REPLACEMENT. SHROUD NEEDS LIGHT ASSY MOUNT. REPLACED SHROUD, RE-INSTALLED SEAT MOUNT LSDR UALA2011050302166Battery · dischargedOVERHEAD AILSE EMERGENCY EXIT SIGN AT ROW 20 RT SIDE WILL NOT ILLUMINATE DURING TEST. REPLACED EMERGENCY LIGHT BATTERY & CHARGER ASSY M732. EMERGENCY LIGHTS TESTED OKAY.SDR UALA2011050202115Light · brokenF-C PAX SEAT 2B ARMREST AISLE SIDE EMERGENCY LIGHT ASSY BROKEN. REPLACED PAX SEAT EMERGENCY LIGHT ASSY AND OPS CHECKED GOOD.SDR UALA2011033101553Light · malfunctionedROWS 26-36FH EMERGENCY LIGHTS GO ON AND OFF. ARMED AND MONITORED EEL LIGHTS IN ECONOMY CABIN, UNABLE TO DUPLICATE.SDR UALA2011032901509Wire · damagedLEFT ENGINE FIRE LOOP 1 STATUS MESSAGE. DUE ETOPS 120 MINUTE RESTRICTION DISPATCH REFUSAL ITEM MUST BE REPAIRED PRIOR TO FLIGHT. ROUTED TWO NEW WIRES FROM TS683 TO TS682, SECURED AND OPS CHECK OKAY.SDR UALA2011032801491Light · brokenSEAT 3H EEL LIGHT BROKEN OFF ON SIDE OF ARMREST. REPLACED LIGHT ASSY. OPS CHECK GOOD.SDR UALA2011032401410Switch · faultyEMERGENCY FLOOR LIGHTS ON CONT ROW 26-38 RIGHT AFT CABIN AISLE. CYCLED COCKPIT EMERGENCY LIGHT SWITCH, SYS WORKS NORMAL.SDR UALA2011031101176Light · missingEMERGENCY LIGHTS MISSING ON SEATS 3H & 2B. REPLACED DAMAGED EMERGENCY LIGHTS, OPS CHECKED GOOD.SDR UALA2011030100995Spacer · missingTHE POSSIBILITY EXISTS THAT A SPACER MAY BE MISSING FROM ONE OF THE RUDDER HINGE ATTACH POINTS. NEED TO OPEN PANEL 324LL TO VERIFY. OPENED PANEL FOUND SPACER MISSING AND RUDDER STRUCTURE DAMAGED. DUE TO MISSING SPACER RUDDER CASTING STRUCTURE DAMAGE REMOVEDSDR UALA2011022200908Window · leakingNR 2 WINDOW ASSY AIR LEAKS (NOISY) POSITION 2 (2=2L ,5=2R). TAPED LOWER FWD CORNER AND AFT EDGE OF WINDOW ASSY IAW MM. PERMANENT REPAIRS TO BE ACCOMPLISHED IAW AMM FIRST MX OPPORTUNITY. REPLACED NR 2 CAPTS SLIDING WINDOW IAW MM. WINDOW WILL NOT CLOSE PROPERSDR UALA2011022100877Lamp · inoperativeWHILE ACCOMPLISHING OPS TEST OF EMERGENCY SEAT MOUNTED ESCAPE PATH LIGHTING FOUND LIGHT ASSY AT SEAT 3H INOPERATIVE. CHANGED BOTH EMERGENCY LAMPS AT SEAT 3H, OPS TESTED OK.SDR UALA2011022100876Oxygen Mask · stuckCAPTAIN'S O2 MASK STUCK IN HOLDER. REPLACED CAPT O2 MASK AND HOLDER IAW MM.SDR UALA2011022100878Light · intermittentEMERGENCY ESCAPE PATH LIGHTING AT BACK THIRD OF ACFT, FLICKERED 2-3 TIMES ON CLIMBOUT AND CRUISE. UNABLE TO DUPLICATE, EMERGENCY LIGHTS CHECKED OK IAW MM OPS TEST, NO PREV HISTORY.SDR UALA2011021100726Satcom · faultyEICAS MESSAGE SATCOM APPEARS. REPLACED SATCOM SDU, OPS CHECKED NORMAL IAW MM.SDR UALA2011021100715Battery · faultyOVERWING HATCH SQUIB TEST LIGHTS DO NOT TEST WITH SYS ARMED. R & R LT OFF WING ESCAPE SYS EMERGENCY BATTERY M961 IAW MM AND OPS CHECK GOOD.SDR UALA2011021100716Slide · faultyRT OVERWING SLIDE NR 4 CLAMP ON LACING BAR CRACKED. REPLACED RT OVERWING SLIDE PACK IAW MM.SDR UALA2011021100725Guard · corrodedMAIN CABIN AT R-1 DOOR, LOWER DOOR JAMB SPLASH GUARD IS CORRODED, BS 293-BS 343. MAJOR REPAIR ACCOMPLISHED: REMOVED SPLASH GUARD DUE MATERIAL REMOVAL AFTER CORROSION BLENDOUT EXCEEDED LIMITS OF SRM. FABRICATED A NEW SPLASH GUARD IAW BACO DWG 141T8310 AND INSSDR UALA2011021100722Guard · corrodedMAIN CABIN AT R-1 DOOR, LOWER DOOR JAMB SPLASH GUARD IS CORRODED, BS 293-BS 343. AFTER FURTHER ANALYSIS, IT HAS BEEN DETERMINED THIS IS NOT AN SDR REPORTABLE EVENT.SDR UALA2011021000696Seat Track · corrodedMAIN CABIN AT R-1 DOOR, LOWER DOOR JAMB, SEAT TRACK CORRODED UNDERNEATH GALLEY AREA, BS 348 - BS 378, RBL 76. MAJOR REPAIR ACCOMPLISHED: R & R SEAT TRACK PN 141T5121-198 IAW BAC DWG 141T5256 AND SRM 51-40-2 ON NON ROUTINE 31211.SDR UALA2011011900319Hinge Fitting · out of toleranceRIGHT WING INBD FLAP, CENTER HINGE FITTING UNDERSERVICED, CRACKED FLANGE HASN'T BEEN REMOVED. REMOVED PREVIOUS REPAIR, AND CUT-OUT DAMAGED FLANGE. FABRICATED A NEW REPAIR ANGLE AND FILLER PER SRM.SDR UALA2011011400221Hinge Fitting · crackedLEFT WING INBOARD FLAP ASSY HAS CRACK ON CENTER AFT FLAP HINGE FITTING. MAJOR REPAIR ACCOMPLISHED: CUT-OUT DAMAGED AREA AND FABRICATED A REPAIR ANGLE AND FILLERS AND INSTALLED PER SRM, REPAIR 1, ON NON ROUTINE.SDR UALA2010120104420Idg · faultyLT GENERATOR DRIVE LIGHT OFF WITH ENGINE SHUTDOWN, TESTS OKAY. REPLACED LT ENG IDG. OPS NORMAL.SDR UALA2010110804123Circuit Card · unsecureR ENG FIRE LP 2 ON STATUS PAGE. RESEATED FIRE LOOP CARDS M683, M684, M689 AND M690 FOR RIGHT ENGINE INDICATION AND DETECTION. OPS OKAY PER MM.SDR UALA2010102904006Fire Warning · false activationEICAS MESSAGE "ENG 2 FIRE LP 2" DISPLAYED. (LT=1, RT=2). SHOOK OUT ENG WIRING, UNABLE TO DUPLICATE. REPLACED M684 FIRE DET CARD AS PRECAUTIONARY.SDR UALA2010120604472Connector · looseSEAT MOUNTED EMERGENCY LIGHT AT 33HJ AND 31HJ INOP. REPLACED LIGHT ASSY AT 31, FOUND CONNECTOR LOOSE AT 33, SECURED CONNECTOR. OP CHECK NORMAL.SDR UALA2010092903593Light · missingEMERGENCY LIGHT STRIPS MISSING AT SEAT 4HJ AND 2AB. REPLACED MISSING EMERGENCY LIGHT STRIPS AT 2AB AND 4HJ. CHECKS OK.SDR UALA2010091303396Light · out of positionSTRIP FOR LIGHT COVER FOUND NEAR SEAT 28HJ. REPLACED PATH LIGHTING FOR SEAT ASSY. AT TOURIST SEAT 28HJ.
Back to N671UA