N220UA
Service difficulty reports · 172
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 = 'N220UA' 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 = 'N220UA' 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 UALA2009051101342Idg · lowELEC GEN DRIVE L LT IDG FAULT (LOW INTERNAL OIL PRESSURE). ADVISORY MSG01- ACTIVE CRUISE MODE DEPENDENT; INTEGRATED DRIVE GENERATOR (L) SHOWS LOW OIL PRESSURE. DB- GENERATOR CONTROL UNIT (L) MSG02- ACTIVE CRUISE MODE DEPENDENT; INTEGRATED DRIVE GENERATOR (L) SDR UALA2009040901030Light · inoperativeDOOR 1 RIGHT EXTERIOR EMERGENCY LIGHT INOP. RELAMPED, OPS CHECK GOOD.SDR 2008UALA05980Light · inoperativeLIGHT EXTERIOR EMERGENCY DOOR 3L IS INOPERATIVE. REPLACED EXTERIOR LAMP, POWER SUPPLY AND BATTERY PACK. OP CHECKED NORMAL.SDR 2008UALA04278Warning Message · illuminatedTHE "APU CONTROL" STATUS MSG ON APU START.SDR 2008UALA03837Light · inoperativeEMERGENCY LIGHT OUT AT SEATS 18C AND 31C. *S/D* SUSPECT LIGHT ASSEMBLY. REPLACED LIGHT ASSEMBLY, OP CHECKED GOOD. AC OK FOR SERVICE.SDR 2008UALA02450Idg · failedLEFT GENERATOR DROPPED OFF LINE. APU ON AND FLIGHT WILL CONTINUE. FOUND FAULTY IDG. REPLACED NR 1 IDG. RAN OP CHECKS. OKAY FOR SERVICE.
SDR 2008UALA02009Coffeemaker · shortedFLIGHT DIVERTED DUE TO ELECTRICAL/BURNING ODOR AND SMOKE IN AFT GALLEY. COFFEEMAKER WIRING TO TANK CONNECTION DAMAGED. REPLACED COFFEEMAKER.
SDR 2007UALA05109Carbon Seal · leakingLANDED UNDER EMERGENCY CONDITIONS DUE TO REPORTED SMOKE IN THE CABIN. SLIDE RAFTS DEPLOYED AND AIRCRAFT EVACUATED ONCE CLEAR OF ACTIVE. NR 2 ENGINE REPLACED AT ORD DUE TO HEAVY METAL DEPOSITS ON MAGNETIC CHIP DETECTORS. TEARDOWN REVEALED A FAILURE OF NR 2 BSDR 2007UALA05076Idg · failedLT GENERATOR FAILURE ON TAKEOFF ROLL. DISCONNECTED GENERATOR AND CONTINUED TO ORD AFTER PHONE PATCH WITH SAMC AND DISPATCH. NR 1 ENGINE INTEGRATED DRIVE GENERATOR FREQUENCY IS LOW. REPLACED NR 1 IDG. AC OK FOR SERVICE.SDR 2007UALA03860Oil System · overtempNR 1 ENGINE HIGH OIL TEMPERATURE. 10-19-07 REPLACED SERVO FUEL HEAT EXCHANGER. ACCOMPLISHED PACK BURN AND FIM 71 -08 TASK 821 AFTER REPLACEMENT. NO ODOR IN CABIN. AIRCRAFT RETURNED TO SERVICE.SDR 2007UALA02363Light · inoperativeEXTERIOR EMERGENCY LIGHT AT DOOR 1R IS OUT. [07-27-07] RELAMPED. OPS CHECKED NORMAL.SDR 2007UALA02362Light · inoperativeTHE 2E AFT & 35C EEL LIGHTS ARE INOPERATIVE. [07-27-07] RELAMPED. SYS OPS NORMAL.SDR 2007UALA00257Light · brokenSEAT 2E EMERGENCY LIGHT SEGMENT ON THE ARMREST IS BROKEN, INOP. REPLACED THE EMERGENCY LIGHT SEGMENT. OPS CHKD OK. SUSPECT DAMAGE BY PASSENGER.SDR 2006UALA01948Disc · burstLOW BOTTLE PRESSURE, FOUND BURST DISK IN BOTTLE. SUSPECT CORROSION AND POSSIBLE IMPACT DAMAGE TO DISK. REPLACED RUPTURE DISK.SDR 2006UALA01604Odor · detectedBURNING ELECTRICAL ODOR THROUGHOUT AIRCRAFT. APU OFF. GROUND POWER SUPPLIED. AFTER TROUBLESHOOTING, REPLACED BUSS POWER CONTROL UNIT. OPERATES NORMALLY. SUSPECT INTERNAL CIRCUIT FLR IN BPCU.SDR 2006UALA01251Engine · malfunctionedFLT ENCOUNTERED HIGH EGT WITH EPR DECREASE FOR 5 SECS ON NR 2 ENGINE AT FL390. EGT READING 466. UNABLE TO CONFIRM "SURGE" OR "BURP" IN ON-BOARD ELECTRONIC RECORD. NO FLAGGED EVENT IN ENGINE CONDITION MONITORING RECORD. PERFORMED PRECAUTIONARY BORESCOPE OF HSDR 2006UALA01022Gauge · leakingLOW BOTTLE PRESSURE GAUGE THREADED INSTALLATION TO INFLATION VALVE WAS LEAKING DUE TO MISSING TEFLON TAPE THREAD SEALANT. THREAD SEALANT WAS APPLIED AND PRESSURE GAUGE REINSTALLED.SDR 2006UALA00783Slide · leakingTHE SEAM IS LEAKING BETWEEN THE UPPER AND LOWER TUBE ON THE LEFT SIDE OF THE SLIDE RAFT. OEM REPORTS THAT LEAKAGE WAS THE RESULT OF LOCALIZED PINHOLE LEAKS AND NOT A LEAKING SEAM. DAMAGE IS CONSISTENT WITH LOCALIZED IMPACT OR ROUGH CONTACT DAMAGE TO MATERIAL SDR 2005UALA01160Wedge · damagedNR 9 LEADING EDGE SLAT HAS INTERIM REPAIR INSTALLED INBOARD T/E WEDGE ON LWR SKIN. LOCALIZED DELAMINATION ON THE LOWER SKIN AT THE ENDS OF THE TRAILING EDGE WEDGE OR JUCT AFT OF THE ACTUATOR ATTACH POINTS IS COMMONPLACE FOR THE 777 SLATS. THE 777 AMM 57-43-99SDR 2004UALA00432Light · inoperativeEMERGENCY EEL LIGHT AT SEAT 35CD IS INOP. REPLACED LIGHT ASSY.SDR 2004UALA00003Fan Blade · contaminatedHIGH ENGINE VIBRATION ON NR 1. ENGINE CONDITION MONITORING DETECTED HIGH N1 FREQUENCY VIBRATION ON ALL 3 ACCELEROMETERS, ACCOMPANIED BY DOWNWARD SHIFT IN EGT MARGIN. CONSEQUENTLY, IMPENDING ENGINE FAILURE WAS SUSPECTED. THE EGT LOSS WAS SUBSEQUENTLY DETERMISDR 2002UALA01335Wire · pinchedSEAT EMERGENCY PATH LIGHTS ON BOTH SIDES OF ZONE 3 DO NOT COME ON. THERE IS A SHORTED WIRE BETWEEN ROWS 31 AND 34. FOUND PINCHED WIRE UNDER SEAT 33F. CLEARED AND REPAIRED WIRE.
Back to N220UA