N457UA
Service difficulty reports · 138
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 = 'N457UA' 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 = 'N457UA' 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 CALA2018102902226Frame · not reportedREMOVED AND REPLACED LT FWD EMERGENCY EXIT 833 LT VERTICAL FRAME IAW SRM 51-42-11-001 PARA 2E INSTALLED LT VERTICAL FRAME ON LT FWD EMERGENCY HATCH IAW SRM 51-42-11-001 ON N/R S/N 9811397 FOR SDR REPORTING.SDR CALA2018102902211Door Sill · corrodedSPEC NR A3NB-53-3-6299 DOT NR A3-007 CORROSION AROUND BLANKING PLATE FASTENER HOLE AT L2 DOOR FR 68 OUTBOARD AFT REMOVED DOOR SILL FOR L2 DOOR IAW SRM 51-42-11-001. NO CORROSION PERMITED IN AREA PER SRM 53-41-14-238-002. LOCATED, DRILLED NEW DOOR SILL FOR L2 ISDR CALA2018102902210Door Sill · corrodedSPEC NR A3NB-53-3-6299 DOT NO. A3-009 CORROSION ON R2 DOOR SILL REMOVED R2 DOOR SILL IAW SRM 51-42-11-001. ORIGINAL THICKNESS .098. MATERAIL LOSS .036 MAX ALLOWED .024 OUT OF LIMITS IAW SRM 53-41-14-283-002. LOCATED DRILLED AND INSTALLED NEW SILL IAW SRM AND 5SDR CALA2018101902147Spring · brokenCABIN FLOOR GIRT BAR. L1 AFT GIRT BAR FITTING SPRING BROKEN. REMOVED AND REPLACED L1 DOOR AFT GIRT FITTING SPRING IAW AMM 52-13-31-400-003.SDR CALA2018102002148Pin · corrodedCABIN FLOOR GIRT BAR L2 AFT SPRING RETAINING PIN CORRODED. REMOVED AND REPLACED L2 DOOR AFT GIRT FITTING SPRING PIN IAW AMM 52-13-31-400-003.SDR CALA2017123004687Gfi · failedFUEL CENTER TANK PUMPS LOW PRESSURE. PUMP 1 AND 2 FAULTED IN AUTO AND MANUAL . 13,800 LBS IN CENTER TANK. FOUND GFI 69QA AND 70QA BAD, REPLACED BOTH GFIS, OPS CHECKED GOOD IAW MM 28-18-00.SDR CALA2017121904533Coffeemaker · odorAFT GALLEY SMELL OF BURNING PLASTIC. AFT RIGHT CHILLER TURNED OFF AND SMELL CEASED. REMOVED AND REPLACED M42 COFFEE MAKER. NO SMELL NOTED. NO LEAKS NOTED. OPS CHECK GOOD.SDR CALA2017110303925Battery · faultyPTP PANEL SYSTEM TEST DISPLAYS ATA 33-51-38 EPSU BATTERY EMER R T/S AND FOUND BATTERY 11WL AND 12WL TO BE BAD. REMOVED AND REPLACED 11WL AND 12WL BATTERY REF AMM 33-51-39 OPS CHECK GOOD.SDR CALA2017062301943Unknown · odorPAX COMPLAINING OF FOUL ODOR FROM THE EXIT ROW BACK. TALKED TO CREW, ODOR WAS CONTAINED TO 2 ROWS OF SEATS . RAN PACKS NO ODOR WAS DETECTED . NO FURTHER ACTION REQUIREDSDR CALA2017060501733Slide · damagedTHE AFT LEFT PASSENGER DOOR, ESCAPE SLIDE PACK, CABLE AND LOOP ASSEMBLY, SAFETY WIRE IS BROKEN REPLACED AFT LT DOOR SLIDE ASSY IAW AMM 25-62-44-0401SDR CALA2015082894245Battery Pack · defectiveDURING 2 SERVICE CHECK FOR EMER LIGHTS, HAD EPSU BATTERY AFT L MSG AT DOOR 1L TEST PANEL. REPLACED EMER EXIT LIGHT BATTERY PACK AT AFT LT DOOR & EMER EXIT LIGHT BATTERY ASSEMBLY AT LT OVERWING EXTERIOR. ACCOMPLISHED EMER LIGHT TEST. OPERATIONS CHECKED NORMASDR CALA2015060193845Flex Line · leakingLOSS OF BLUE SYS HYD WITH ASSOCIATED LOW LEVEL & LOW PRESS EVIDENCE OF HYD FLUID AROUND BLUE SYS HYD BAY. R & R FLEX LINE IAW IPC 29-12-03-09 ITEM 330 & CLAMP ITEM 380. ALSO R & R BLUE ELEC PUMP IAW AMM 29-12-51-400-001A & BLUE SYS FILTERS IAW AMM 29-12-43 &SDR CALA2013121893773Battery · faultyNR 1 AIRCRAFT BATTERY SHOWS 12 VOLTS, DOES NOT IMPROVE WITH LOAD. REPLACED NR 1 BATTERY. GND FUNCTIONAL TESTED GOOD.SDR CALA2013121693746Gasket · damagedFOUND WATER LEAK AT WATER FILTER HOUSING IN FWD GALLEY. INSTALLED NEW GASKET ON TOP OF WATER FILTER & INSTALLED TOP FOR WATER FILTER HOUSING IN FWD GALLEY. FOUND NO LEAKS.SDR CALA2013111292835Mount · looseCREW REPORT ON ARRIVAL AFT FLIGHT ATTENDANT`S JUMP SEAT LOOSE AT WALL. REPLACED AFT FLIGHT ATTENDANT`S JUMP SEAT MOUNT WALL. JUMP SEAT SECURE.SDR CALA2013110792723Rivet · missingTHREE RIVETS MISSING ENG 2 TAIL CONE LOWER VERTICAL SUPPORT UPPER FLARED SHEET METAL 2 ON LT, 1 ON RT. RIVETS MISSING AT 6 O’CLOCK POSITION LOWER STRUT FAIRING WILL REQUIRE RECHECK.SDR CALA2013110892738Actuator · faultyRUDDER TRIM 2 ECAM MESSAGE. ADJUSTED RUDDER TRIM ACTUATOR IAW AMM 27-22-00-820-001A, & ECRA 2722-01008. INSTALLATION OF RUDDER TRIM ACTUATOR IAW 27-22-51-400-001A. RUDDER TRIM & RUDDER HYD NORMAL, LEAK CHECKED OK, NO DEFECTS NOTED. ALL RIG PINS REMOVED, NOSDR CALA2013103092514Oil Filter · cloggedENG 2 OIL FILTER CLOG MESSAGE 4257-2 ESN V10058, DUE TO ENG 2 OIL FILTER CLOG ECAM, MESSAGE CLEARED ON ITS OWN. TO PREVENT IRREGULAR OPERATIONS, DELAYS ACCOMPLISHED FAULT ISOLATION ITEM 4A (1)(2)(3) & (4) OF TSM 79-30-00-810-804-A ON EDOCS PAGE 3 OF 4. ENG OSDR CALA2013102492351Sensor · faultyREPLACED THE FLSCU2 CFDS CONTINUES TO REPORT FAULT MESSAGE "FUEL LEVEL SENSING RT OUT TEMPERATURE SENSOR 30QJ2." TEMPERATURE SENSOR HAS BEEN REPLACED. PLACED FLSCU2 IAW ABOVE.SDR CALA2013100891869Battery Pack · dischargedEMERGENCY LIGHT TEST FAILED FWD LT. REPLACED BATTERY PACK BY DOOR 1L IAW MM, TEST PASSED.SDR CALA2013092791530Computer · faultyELAC 1 PITCH FAULT DISPLAYED ON UPPER ECAM SCREEN. REPLACED ELAC 1, ACP CAT 3 IAW AMM 22-96-00 & AMM 22-97-00.SDR CALA2013092591425Computer · faultyFLIGHT CONTROL ELAC 1 PITCH FAULT DURING FLIGHT CONTROL CHECK. RESET, NO HELP. ELAC NR 1 IAW MM 27-93-00. ALL GROUND TESTS GOOD. ACCOMPLISHED ACP LAND TEST IAW MM 22-97-00. ALL TESTS PASSED.SDR CALA2013090290942Floor Panel · puncturedRAMP FOUND 1X1 INCH SQUARE PUNCTURE AFT PIT MAIN FLOOR PANEL AFT OF CARGO DOOR. PUNCTURE TAPED OVER PER MT-53-007.SDR CALA2013082690740Receptacle · defectiveFASTENER LOOSE ON PANEL FORWARD OF RAM AIR TURBINE. DEFERED MISSING SCREW IAW AMM 53-35-00 OK FOR 10 CYCLES. RECEPTACLE IS BROKEN ON PANEL 191KB, TRAILING EDGE, CENTER. REPLACED CYLINDER LOCKING RECEPTICAL FASTNER OPERATIONS CHECKED GOOD.SDR CALA2013082690721Blade · nickedNR 2 ENGINE FAN BLADE HAS NICK ON LEADING EDGE. BLENDED BLADE PER AMM 72- 31-11. IDT INSPECTION WAS ACCOMPLISHED. NICK WAS ON LEADING EDGE OF BLADE APPROX 1 -32ND OF AN INCH.SDR CALA2013081990504Structure · damagedR2 DOOR LOWER BUSTLE NEEDS COMPOSITE WORK AND PAINT.SDR CALA2013081490433Wire Harness · damagedNR 1 EGT INDICATION ERRATIC. RETURN TO GATE. FOUND DAMAGE TO EGT HARNESS 6 INCHES FORWARD OF THE EGT JUNCTION BOX. DAMAGE DUE TO CONTACT WITH NR 4 BUMPER OF REVERSER COWL RT SIDE. REPLACED CORE EGT HARNESS ASSY, ACCOMPLISHED IDLE LEAK CK OF ENG HARNESS ARSDR UALA2013072305184Seal · leaking21 DEF OVERWING EXIT WINDOW HAS AIR LEAK NOISE AT BOTTOM OF WINDOW. REPLACED DOOR SEAL. OPS & LEAK CHECKED GOOD.SDR UALA2013072305183Pin · out of positionEMERGENCY EXIT AT ROW 21 DEF LATCH PIN RETRACTED AND FULLY DISARMED POSITION. REPLACED LATCH PIN TO ARMED POSITION.SDR CALA20130708001Computer · faultyELAC 1 FAULT DISPLAYED ON UPPER ECAM SCREEN. F-CTL. SUPPLEMENTAL DATA UPDATE NO PARTS, PCN (482-9572). REPLACED ELAC 1 IAW AMM, CKS OK. PERFORMED CAT 3, CK REF AMM.SDR UALA2013070804715Computer · faultyELAC 1 FAULT DISPLAYED ON UPPER ECAM SCREEN. NO PARTS PCN (482-9572) REPLACED ELAC 1 IAW AMM, CKS OK. PERFORMED CAT 3, CK REF AMM.SDR UALA2013062504400Computer · faultyELAC 1 PITCH FAULT, RESET UNSUCCESSFUL. REPLACED ELAC 1 AND ALSO PERFORMED CAT II CK. ALL SYSTEMS PASSED HAD NO MESSAGE AND NO FAULTS.SDR UALA2013060303838Controller · faultyENGINES STAY IN HIGH IDLE. PROBLEM WAS CAUSED BY BOTH CHANNELS INOPERATIVE IN ZONE TEMP CONTROLLER. REPLACED ZONE TEMP CONTROLLER IAW AMM 21-63-34. OPS CHECKED GOOD.SDR UALA2013040802302Switch · stickingF/O CONTROL STICK MICROPHONE SWITCH STICKS IN TRANSMIT POSITION. NEED NEW MIC SWITCH DEACTIVATED PER AMM. F/O SIDE STICK PUSH TO TALK SWITCH. REPLACE THE SIDE STICK GRIP FOR PTT SWITCH FAILURES. REPLACE THE SIDE STICK GRIP FOR PTT SWITCH FAILURES.SDR UALA2013032801986Static Wick · missingSTATIC DISCHARGER MISSING FROM LEFT WING NR 3 FLAP TRACK CANOE. DEFERRED ONE STATIC DISCHARGER MISSING PER CDL 23A. REPLACED STATIC DISCHARGER.SDR UALA2013032101767Radome · damagedRADMOME DAMAGED. COMPLIED WITH ECRA 5350-02074. R & R RADOME.SDR UALA2012120707098Computer · faultySIDESTICK PRIORITY DISPLAYED ON UPPER ECAM SCREEN. - F-CTL WORK PER TSM 27-93-00-810-919-A LOSS OF SIDE STICK PRIORITY FOR ONE ELAC PER TOMC...REPLACED ELAC- 1...ELAC TEST OK AND FLIGHT CONTROLS EXERCISED WITH NO MESSAGES. AFS AND LAND TEST OKAY. PROBLEM RESDR UALA2012120607061Computer · faultySIDESTICK PRIORITY MESSAGES. REPLACED NR 2 ELAC COMPUTER REF AIRBUS. PERFORMED OPERATIONAL TEST OF ELAC COMPUTER. NO FAULTS FOUND.SDR UALA2012112106714Controller · inoperativeANTI-ICE R WINDOW INOPERATIVE. WHC 2 CONTROLLER CHANGED FOR T-S. WINDOW WIRE HARNESS VISUAL INSPECTION OK. CHANGED WINDOW HEAT CONTROLLER FOR TROUBLESHOOTING.SDR UALA2012082104667Scavenge Pump · faultyON NR 1 ENGINE SHUTDOWN AT GATE RAMP REPORTED FLAMES COMING FROM TURBINE FOR APPROX 1 MINUTE. MOTORED ENGINE NOTED HEAVY OIL FOG FROM EXHAUST. SERVICED OIL TO FULL 3 QTS. DUE TO OIL IN TAILPIPE PERFORM NR 5 OIL SUPPLY AND SCAVENGE TUBE INSPECTION PER MT72-0SDR UALA2012080904330Stowage Box · leakingCAPT OXYGEN MASK STOW BOX LEAKING FROM RESET VALVE. SUPPLEMENTAL DATA UPDATE, REPLACED CAPTAINS O2 MASK STOWAGE BOX PER MM. LEAK AND OPS CHECKS GOOD.SDR UALA2012071303784Diaphragm · damagedMAIN ENTRANCE DOOR ASSIST BOTTLE READS 0 PSI. REPLACED DIAPHRAGM.SDR UALA2012070903662Skin · puncturedEXTERNAL FUSELAGE PUNCTURED 3.5 INCH BY 0.5 INCH BETWEEN FRAMES 80-81 AND BETWEEN STRINGERS 1L-1R. MAJOR REPAIR ACCOMPLISHED: CUT OUT DAMAGE AND ACCOMP NDT OF CUT OUT. NO CRACKS FOUND. CUT OUT MEASURED AT 3.4 INCH BY 1.6 INCH. FABRICATED AND INSTALLED EXTESDR UALA2012070903661Skin · dentedEXTERNAL FUSELAGE DENTED .5 INCHES AFT OF FR 82 AND 1.75 INCH LEFT OF STRINGER 1L. MAJOR REPAIR ACCOMPLISHED: EVALUATED DENT AND FOUND IT OUT OF LIMITS OF SRM. CUT OUT DAMAGE AND FABRICATED AND INSTALLED EXTERNAL DOUBLER REPAIR.SDR UALA2012070903660Skin · dentedEXTERNAL FUSELAGE DENTED 4 INCHES AFT OF FR 82 APPROX .5 INCH UP FROM STRINGER 2R. MAJOR REPAIR ACCOMPLISHED: EVALUATED DENT AND FOUND IT OUT OF LIMITS OF SRM. CUT OUT DAMAGE AND FABRICATED AND INSTALLED EXTERNAL DOUBLER REPAIR REF SRM 53-51-11 FIG 203 PG 21SDR UALA2012070903657Skin · dentedEXTERNAL FUSELAGE DENT AT FR 17 AND STR 33R WAS FOUND OUT OF SRM LIMITS. MAJOR REPAIR ACCOMPLISHED: CUT OUT DAMAGE AND ACCOMP NDT OF CUT-OUT AND EXISTING FASTENER HOLES FOR CRACKS. NONE FOUND. FABRICATED AND INSTALLED EXTERNAL DOUBLER REPAIR REF SRM 53-11-1SDR UALA2012070603631Attach Fitting · corrodedFWD LAVATORY ATTACH POINT AT FLOORBEAM Y518 CORRODED. REPLACED FWD LAV ATTACH POINT BEAM Y518 PER SRM ON PEMCO NR 5072N00468.SDR UALA2012050102576Control Unit · malfunctionedFLIGHT RETURNED TO BLOCKS DUE TO LAV/SMOKE WARNING. REPLACED SDCU 10WQ, LAV SMOKE FAULT CLEARED AND CHECKED GOOD.SDR UALA2012041202206Actuator · leakingRAMP REPORTS FUEL LEAK ON ENGINE 2 AFTER ENGINE START. ACCOMPLISHED IDLE ENG RUN TWICE, STEADY STREAM FUEL LEAKS FROM CORE DRAIN BEYOND LIMITS OF MM. ISOLATED TO SLAVE LPC BLEED ACTUATOR. REPLACED ACTUATOR PER MM, IDLE LEAK CHECK OK.SDR UALA2012010600133Pump · underservicedRAT HYD PUMP IS UNDERSERVICED. REPLACED RAT PUMP.
Back to N457UA