N666UA
Service difficulty reports · 280
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 = 'N666UA' 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 = 'N666UA' 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 UALA2009092102964Lamp · inoperativeG1 EMERGENCY AISLE LIGHTS INOP. RELAMPED 1G EMERGENCY AISLE LIGHT, OPS CHECKS GOOD.SDR UALA2009092102963Light · inoperativeLEFT EMERGENCY LIGHT INOP AT AFT GALLEY AREA. INSTALLED NEW LIGHT AFT GALLEY, OPS CHECKS GOOD.SDR UALA2009092102959Oxygen Mask · faultyB-ZONE SEAT 12 CENTER FAILS O2 DROP. REPACK O2 MASK AT SEAT 12 CENTER. OPS CHECKS GOOD.SDR UALA2009091702940Light · inoperativeMID CROSS AISLE EEL LIGHT BAR INOP. REMOVED & REPLACED MID CROSS AISLE LIGHT BAR. OPS CHECK GOOD.SDR UALA2009091702939Light · improper partSEAT 20AB HAS WRONG IN-SEAT EEL LIGHT ASSY INSTALLED. REMOVED & REPLACED THE HALF-RED HALF-GREEN EEL LIGHT & INSTALLED CORRECT LIGHT STRIP & OPS CHECK GOOD.SDR UALA2009091602923Cylinder · defectiveRIGHT OVERWING SLIDE BOTTLE TRIGGER CABLE BALL IS OUTSIDE SPRING RETAINER. INSTALLED NEW INFLATION CYLINDER.SDR UALA2009091602922Slide · out of toleranceDOOR R1 SLIDE OUT OF TOLERANCE. INSTALLED NEW SLIDE.SDR UALA2009091602921Light · inoperativeEMERGENCY AISLE LIGHT AT AFT LEFT LAV INOP. RELAMPED AND OPS CHECKED GOOD.SDR UALA2009091602920Light · inoperativeEMERGENCY AISLE LIGHT INOP AT SEAT 4AB. RELAMPED AISLE LIGHT AND OPS CHECKS GOOD.SDR UALA2009091502908Stiffener · crackedFORWARD E&E COMPARTMENT RIGHT NOSE GEAR WHEEL WELL STIFFENER CRACKED, MIDDLE OF STIFFENER AT FLOORBEAM BS 246, LBL 10. MAJOR REPAIR ACCOMPLISHED. REMOVED AND REPLACED STIFFENER.SDR UALA2009091502907Attach Angle · crackedFORWARD E&E COMPARTMENT, RIGHT NOSE GEAR WHEEL WELL, PULLEY BRACKET ATTACH ANGLE CRACKED, LOWER OUTBOARD SIDE OF FLOORBEAM BS 246 AND LBL 15. MAJOR REPAIR ACCOMPLISHED. REMOVED DAMAGED ANGLE AND REPLACED WITH NEW ANGLE.SDR UALA2009091502906Shear Tie · corrodedAFT CARGO COMPARTMENT SHEAR TIE SURFACE CORRODED AT BS 1197+22, BETWEEN STR 39L-39R. MAJOR REPAIR ACCOMPLISHED. REMOVED DAMAGED SHEAR TIE. FABRICATED & INSTALLED A NEW SHEAR TIE.SDR UALA2009091502905Shear Tie · corrodedAFT CARGO COMPARTMENT SHEAR TIE SURFACE CORRODED AT BS 1197+22, BETWEEN STR 37R-38R. MAJOR REPAIR ACCOMPLISHED. REMOVED SHEAR TIE AND FABRICATED & INSTALLED A NEW SHEAR TIE.SDR UALA2009091502904Floorbeam · damagedMAIN CABIN FLOORBEAM CORRODED BS 1520, LB L30. MAJOR REPAIR ACCOMPLISHED. REMOVED DAMAGED SECTION OF FLOORBEAM AT BS 1518, LBL 26 TO LBL 31. FABRICATED & INSTALLED A REPAIR SECTION OF T-CAP AND SPLICE ANGLES.SDR UALA2009091502903Shear Tie · corrodedAFT CARGO COMPARTMENT SHEAR TIE SURFACE CORRODED AT BS 1197, STR 37R-38R. MAJOR REPAIR ACCOMPLISHED. REMOVED SHEAR TIE AND FABRICATED & INSTALLED A NEW SHEAR TIE.SDR UALA2009091502902Seat Track · corrodedMAIN CABIN SEAT TRACK CORRODED BS 325, RBL 11. MAJOR REPAIR ACCOMPLISHED. REMOVED DAMAGED SECTION OF SEAT TRACK BETWEEN BS 322 TO 423, RBL 11, FABRICATED AND INSTALLED A REPAIR SECTION.SDR UALA2009091502901Seat Track · corrodedMAIN CABIN SEAT TRACK CORRODED ON BS 325, LBL 11. MAJOR REPAIR ACCOMPLISHED. REMOVED DAMAGED SECTION OF SEAT TRACK BETWEEN BS 322 TO 423 LBL 11. FABRICATED AND INSTALLED A NEW SPLICE SECTION.SDR UALA2009091502900Floorbeam · corrodedMAIN CABIN FLOORBEAM CORRODED ON UPPER FLANGE BS 287, RBL 88. MAJOR REPAIR ACCOMPLISHED. REMOVED DAMAGED SECTION OF FLOORBEAM BETWEEN LBL 32 TO RBL 88. FABRICATED & INSTALLED A REPAIR T-ANGLE, SPLICE PLATE AND SPLICE ANGLES.SDR UALA2009091502899Seat Track · corrodedMAIN CABIN RT SEAT TRACK IS CORRODED AT R-1 DOOR BS 347, RBL 88. MAJOR REPAIR ACCOMPLISHED. REMOVED DAMAGED SEAT TRACK BETWEEN BS 343 TO BS 402 RT SIDE. FABRICATED & INSTALLED A NEW SECTION OF TRACK.SDR UALA2009091002852Guard · corrodedMAIN CABIN RT SPLASH GUARD IS CORRODED AT R-1 DOOR, BS 325-BS 347, RBL 88. REMOVED CORROSION AND FOUND PART TO BE CRACKED AT FASTENER HOLE, NO CRACKS PERMITTED. REMOVED AND REPLACED SPLASH GUARD P/N 141T8310-244 AND RE-INSTALLED REMOVED SCUFF PLATES AND GIRTSDR UALA2009091002851Guard · corrodedMAIN CABIN LT SPLASH GUARD IS CORRODED AT L-1 DOOR, BS 303 - BS 347, LBL 88. REMOVED AND REPLACED SPLASH GUARD. RE-INSTALLED SCUFF PLATE AND GIRT BAR FITTINGS RESPECTIVELY.SDR UALA2009091002850Shear Tie · corrodedAFT CARGO COMPARTMENT SHEAR TIE SURFACE CORRODED STA 1197 + 66, STR 37R. MAJOR REPAIR ACCOMPLISHED. FABRICATED & INSTALLED NEW SHEAR TIE.SDR UALA2009090302761Cable · damagedLEFT AFT OVERWING EMERGENCY EXIT STEP AFT CABLE KINKED AND FRAYED. REMOVED AND REPLACED LEFT OVERWING AFT STEP CABLE AND OPS CHECK GOOD.SDR UALA2009090302763Light · inoperativeDOOR 2L EXTERNAL EMERGENCY LIGHT IS INOPERATIVE. RELAMPED L2 DOOR EMERGENCY EXIT LIGHT AND OPS CHECK GOOD.SDR UALA2009090302762Light · inoperativeDOOR 2R EMERGENCY LIGHT INOPERATIVE. RELAMPED R2 DOOR EMERGENCY EXIT LIGHT AND OPS CHECK GOOD.SDR UALA2009082702679Latch · gougedRIGHT OVERWING SLIDE COMPARTMENT DOOR LATCH NR 3 DAMAGED (GOUGED). INSTALLED NEW NR 3 LATCH, OPS CHECKS GOOD.SDR UALA2009082702678Latch · gougedRIGHT OVERWING SLIDE COMPARTMENT DOOR LATCH NR 4 DAMAGED (GOUGED). INSTALLED NEW NR 4 LATCH, OPS CHECKS GOOD.SDR UALA2009060401608Light · missingIN SEAT EEL LIGHT AT SEAT 36HJ MISSING. INSTALLED NEW EEL LIGHT, CHECKS GOOD.SDR UALA2009060401609Controller · faultyBLEED DOES NOT OPEN AT IDLE-INTERMITTENTLY WITH PWR LVL RAISED. REPLACED PRVC CONTROLLER, OP CK'D NORMAL.SDR UALA2009051801410Idg · defectiveRIGHT GEN "DRIVE" AMBER LOW PRX LIGHT IS NOT ILLUMINATED WITH ENGINE NOT RUNNING. RAN ENG2, DISCONNECTED IDG EICAS INDICATION NORMAL, INDICATION ON SWITCH INOP. JUMPERED PINS FROM PRESSURE SWITCH AT IDG AND LIGHT CAME ON. BAD PRESS SWITCH ON IDG. REPLACED SDR UALA2009041401067Battery · dischargedEMERGENCY ESCAPE LIGHTS CONNECTED TO POWER SUPPLY M734 ARE INOP. REPLACED BATTERY AT M734, OP NORMAL.SDR UALA2009041401066Light · missingSEAT 6AB MISSING 1 EACH ESCAPE LIGHT. INSTALLED NEW LIGHT, OP NORMAL.SDR UALA2009031000013Lamp · inoperativeEMERGENCY LIGHT ON SEAT 30A IS INOP. RELAMPED, OPS CK OK.SDR UALA2009031000012Lamp · missingAFT EMERGENCY LIGHT ON SEAT 6A IS MISSING. REPLACED LIGHT, CHECKS GOOD.SDR UALA2009010200013Light · inoperativeEEL LIGHT ON SEAT 30A IS INOP. NEEDS LIGHT ASSY. NO PARTS AT SFO. PCN 585-5228. RELAMPED, OPS CK OKSDR UALA2009010200012Lamp · missingAFT EEL LIGHT ON SEAT 6A IS MISSING. REPLACED LIGHT, CHECKS GOOD.SDR UALA2009010200018Light · brokenALL 6EA RT SIDE EXTERIOR EEL LIGHTS ARE INOP. REPLACED BROKEN BULB AT AFT RT DOOR SLIDE LIGHT, BATTERY AT M733, AND BATTERY AND CHARGER AT M731. CHECKS GOOD.SDR UALA2009010200017Light · inoperativeLT SIDE 2EA AFT EXTERIOR EEL LIGHTS ARE INOP. RELAMPED AND LIGHTS CHECK GOOD.SDR UALA2009010200015Connector · disconnectedEEL LIGHT ON SEAT 39J IS INOP. FOUND HARNESS DISCONNECTED AT OUTBOARD END, SECURED CONNECTOR, OPS CHECK OKAY.SDR UALA2009010200014Light · inoperativeEEL LIGHT ON SEAT 35A IS INOP. REPLACED CABLE ASSY (HARNESS) AND OPS CHECKED.SDR 2008UALA06501Light · looseEMERGENCY ESCAPE LIGHTING LOOSE IN FLOOR AT SEAT 3B. LIGHT FOUND UNSECURE. REPLACED THE EEL LIGHT AT SEAT 3B AS REQUIRED. OP CHECKS NORMAL.
SDR 2008UALA06356Oil Filter · faultyNR 2 ENGINE OIL FILTER MESSAGE DISPLAYED. MESSAGE DISAPPEARED WHEN THRUST REDUCED. OIL FILTER IS FAULTY. REPLACED NR 2 ENG OIL FILTER. LEAK AND OPS CHECK GOOD.SDR 2008UALA06211Idg · leakingEICAS MSG L GEN DRIVE DISPLAYED. GEN DRIVE LIGHT ILLUM. GEN DRIVE DISCONNECTED. CREW COMMENTS: L T ENG DRIVE LIGHT CAME ON AFTER T/O AND WENT OUT AFTER TWO MINUTES WITH NO CREW ACTION. FUEL OIL COOLER LEAKING AND IDG DRY. REPLACED NR 1 ENGINE IDG & NR 1 ESDR 2008UALA05927Bypass Valve · faultyALTERNATE T/E FLAP DRIVE ELECTRIC MOTOR RUNS BUT DOES NOT TURN GEARBOX TO EXTEND FLAPS. REPLACED T/E FLAP BYPASS VALVE. OP CHECKS NORMAL.SDR 2008UALA05860Eec · faultyL ENG CONT EICAS AND L ENG CONT STATUS. REPLACED NR 1 ELECTRICAL ENGINE CONTROL. ACCOMPLISHED OPS CHECK. CHECKS OKAY.
SDR 2008UALA05807Control Unit · faultyAPU FAULT. ECU FOUND FAULTY. REPLACED ECU. OPS CHECKS NORMAL.SDR 2008UALA04269Engine · hung startLEFT ENGINE HUNG START AT 30 PERCENT N2. LEFT HYD QTY NOW LOW.SDR 2008UALA04195Control Panel · inoperativeUNABLE TO SET ALTITUDE IN CABIN ALTITUDE CONTROL. REMOVED & REPLACED CABIN ALTITUDE CONTROL PANEL.SDR 2008UALA03767Filter · warning messageLT ENG OIL FILTER MSG APPEARED AFTER ENG START. MSG CLEARED WITHOUT ANY FLIGHT CREW ACTION. RETURNED TO BLOCKS. MAINTENANCE REPLACED THE MAIN OIL FILTER PER AMM 79-21-05. NO METAL FOUND. FLIGHT TOOK AN 84 MINUTE DELAY. PROBLEM DID NOT RECUR.SDR 2008UALA02960Battery · dischargedAPU WILL NOT START. SUSPECT FAULTY BATTERY. REPLACED BATTERY, OP CHECKED GOOD. AC OK FOR SERVICE.
Back to N666UA