N497UA
Service difficulty reports · 107
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 = 'N497UA' 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 = 'N497UA' 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 CALA2014101692444Fitting · mechanic errorFRAME CLIP MIS DRILLED AT FRAME 32 STRINGER 39 - 40R. REPLACED CLIP IAW SRM 51-4 2-11.SDR CALA2014101692442Stringer · corrodedMAJOR REPAIR & SDR STRINGER 39L CORRODED AT FRAME 59. FOUND NO LIMITS IAW SRM 53-00-13 PG 101. FABRICATED NEW STRINGER, SPLICE & INSTALLED BETWEEN FRAME 58 & 60 IAW SRM 53-00-13 PG 212 FIG 201 SHEET 1 & 2. THIS REPAIR REQUIRES SRI INSPECTIONS IAW SRI 53-00-SDR CALA2014101692432Door Sill · corrodedMAJOR REPAIR & SDR L2 DOOR SILL HAS CORROSION AROUND TWO EACH NUTPLATES AT FRAME 66 & STRINGER 23L. CUT OUT THE DAMAGED AREA IAW SRM 53-41-14 PG 205. FABRICATED ONE EACH REPAIR ANGLE IAW SRM 53-41-14 PGS 215 - 216 PRINCIPLE 1 & INSTALLED. RESTORED THE AREA.SDR CALA2014101392398Door Sill · corrodedMAJOR REPAIR & SDR. R2 DOOR SILL HAS CORROSION UNDER GIRT BAR PLATE BETWEEN FRAME 66 & 68. REMOVED CORROSION FROM DOOR SILL & FOUND MATERIAL LOSS TO BE OUT OF LIMITS IAW SRM 53-41-14 FIG 101. R & R R2 DOOR SILL WITH NEW SILL IAW SRM 51-42-11. NO REQUIREMENSDR CALA2014100792377Stringer · corrodedAFT CARGO COMPARTMENT STRINGER 42R HAS CORROSION FRAME 63 - 64. REPAIRED STRINGER 42R IN AFT PIT FROM FRAME 62.5 - 64 IAW SRM 53-00-13 PARA 4 A FIG 201.SDR CALA2014100792376Stringer · corrodedAFT PIT STRINGER 41R BETWEEN FRAME 59 - 64 HAS CORROSION. REPLACED FACTORY STRINGER SECTION IAW SRM 51-42-11.SDR CALA2014092992349Longeron · corrodedMAJOR REPAIR & SDR LONGERON SUPPORT IS CORRODED AT FRAME 70 ON RT SIDE OF AFT CABIN. AFTER BLENDING CORROSION LONGERON WAS FOUND TO BE OUT OF LIMITS IAW SRM 51-73-11. R & R IAW SRM 51-72-11.SDR CALA2014091892237Slide · defectiveDURING EMER LIGHT TEST, GOT EPSU EXT LOAD FWD LT MSG. REPLACED DOOR SLIDES L1 & R1 IAW AMM 25-62-44-400. EMER LIGHT TEST PASSED.SDR CALA2013121693704Wire · chafedENG 2 OVSPD PROT FAULT. TSM REFERENCE BASED ON CFDS FAULTS IN DISECM. TSM TASK 73-22-00-810-840-A. POSSIBLE PARTS FMU PCN 621-9060, MR73255. REPAIRED CHAFFED WIRE FROM FMU PLUG C PIN J TO EEC PLUG J11 TO PIN J WIRE 5A117W20. ENG RUNS CHECKED OK.SDR CALA2013111893020Relief Valve · noisyAFT GALLEY MAKING A VERY LOUD CHATTER NOISE APU RUNNING & BLEED ON. DETERMINED TO BE AIR RELIEF VLV BEHIND AFT GALLEY COFFEEMAKER. ACCOMPLISHED BLEED PROCEDURE IAW MT 38-005, NOISE STOPPED.SDR CALA2013100991878Drain Valve · leakingGREEN SYSTEM RESERVOIR DRAIN VLV LEAKING. REPLACED VLV IAW MM, LEAK CHECKED GOOD.SDR CALA2013092091315Battery · dischargedEMERGENCY LIGHTS TEST WILL NOT PASS IAW 2 SVC, GIVES MESSAGE EPSU BATTERY EMERGENCY. REPLACED BATTERY ON RT EMERGENCY LIGHTS POWER SUPPLY UNIT. EMERGENCY LIGHTS TEST PASSED.SDR CALA2013080590163Sensor · looseAFT CABIN TEMP UNCONTROLABLE WITH FULL HOT- HOT AIR SELECTOR AT 2.60 DRG. PAC 1 OUTLET WAS ACP CFDS CAB TEMP TEST AND OPS CHECK NORMAL, RAN PACK 1 AND TEMP FOLLOWED AND RESPONDED TO COCKPIT INPUT, REMOVED AND INSPECTED AFT CABIN TEMP SENSOR AND FOUND CLEAN. FOSDR UALA2013071705018Warning Message · false activationVENT EXTRACT FAULT, FLT DIVERTED. FOUND CIRCUIT BREAKER OUT AT VU123, RESET AND PERFORMED TEST OF AEVC TEST PASSED, FAULT CLEARED. ACFT OK TO CONTINUE.SDR UALA2013071504947Cover · missingSMALL PLASTIC COVER ON ARMING LEVER ON L2 DOOR MISSING. REPLACED LENS COVERS NR 110-5293.SDR UALA2013062504413Oxygen Mask · failedCAPTAIN`S OXYGEN MASK PRESS TO TEST FUNCTION FAILED. REPLACED CAPTAIN`S OXYGEN MASK ATTACHMENT BOX AND OXYGEN MASK ASSY IAW AMM-TASK 35-12-41-400-001-A AND AMM-TASK 35-12-41-400-002-A, OPS CHECKED OK.SDR UALA2013061904239Container · crackedLEFT OVERWING ESCAPE SLIDE CONTAINER IS CRACKED 6.5 INCHES IN AREA TWO IAW MT 25-018. REPLACED LT OVERWING ESCAPE SLIDE IAW AMM, CHECKED GOOD.SDR UALA2013061804222Girt Bar · dirtyR2 DOOR DIFFICULT TO ARM. FOUND DEBRIS IN GIRT BAR AREA. CLEANED. DOOR ARMS AND OPS CHECKED NORMAL.SDR UALA2013061804223Control Unit · faultedCLASS 2 MX MESSAGE, SDCU ON LOWER ECAM DISPLAYED, LAST SDCU REPLACED ON MAY 31, SUSPECT BAD UNIT. REPLACED SDCU IAW MM 26-17-34. ALL GROUND CHECKED GOOD.SDR UALA2013061304061Lever · obstructedR2 DOOR DOES NOT ARM PROPERLY, DIFFICULT TO MOVE ARMING LEVER. CLEANED DEBRIS FROM UNDER R2 DOOR. DOOR OPERATES AND SLIDE ARMS NORMAL. ACFT OK TO CONTINUE.SDR UALA2013042302816Controller · faultyAPU AUTO SHUTDOWN ON START. REMOVED & REPLACED ECB AS REQUESTED, OPS CHECK GOOD.SDR UALA2013041802691Power Supply · inoperativeWHILE PERFORMING EMERGENCY LIGHT SYSTEM TEST ON CIDS, GOT FAULT MSG EPSU BATTERY AFT L (ATA 33-51-38). REPLACED AFT LEFT EMERGENCY POWER SUPPLY AND BATTERY FOR 13WL UNIT. ACP POWER SUPPLY BITE AND AC EMERGENCY BATTERY CHECK BOTH TESTED GOOD REF AMM 33-51-38-SDR UALA2013030501309Shade · defective1ST OFFICER'S PULL-OUT MYLAR SUN SHADE IN SLIDING WINDOW IS DEFECTIVE. CREW COMMENTS: F/O REAR WINDOW SHADE TORN. TORN STILL USEABLE. REPLACED PULL-OUT SUN SHADE.SDR UALA2013030401298Window · leakingNR 3 RIGHT FIXED WINDOW LEAKING FROM FWD LOWER CORNER. REPLACED F/O NR 3 FIXED WINDOW.SDR UALA2013021900989Duct · obstructedBOTH AFT LAVS INOPERATIVE, FLIGHT DIVERTED. REMOVED LARGE BLOCKAGE OF PAPER TOWELS FROM TOP INLET TO WASTE TANK. OPS CHECKED EXCELLENT.SDR UALA2012121707260Battery · discharged1ST CLASS EMERGENCY LIGHTS DO NOT TURN ON AUTOMATICALLY WHEN POWER SHUT OFF. COACH LIGHTS OK. CIDS TEST GOOD. WHEN MANUALLY TURNED TO THE 'ON' POSITION IN THE COCKPIT ALL LIGHTS WORK. REPLACED EMERGENCY LIGHTS BATTERY OVER DOOR 1L REF MM. OPS OKAY.SDR UALA2012121407231Oxygen Mask · inoperativeCREW REPORT: F/O O2 MASK MIC INOP SWAPPED F/O MASK WITH 1ST OBSERVER MASK PER AMM. DEF 1ST OBSERVER POSITION SLIDING SEAT PER MEL.SDR UALA2012103106261Diaphragm · faultyAFT LEFT ENTRY DOOR ASSIST BOTTLE PRESSURE AT ZERO. REPLACED DIAPHRAGM.SDR UALA2012101605902Seal · detachedOUTER SEAL ON DOOR 1L WINDOW IS PARTIALLY DETACHED. SEAL REPLACED.SDR UALA2012100805709Oxygen Mask · faultyF/O O2 MASK PRESS TO TEST 100 PERCENT BUTTON BROKE. REPLACED 1ST OFFICER'S O2 MASK, OPS CHECKS OKAY.SDR UALA2012090504999Proximity Switch · out of adjustDURING TROUBLESHOOTING OF DF513, WITH SLIDE DISARMED, LIFTING DOOR HANDLE TO OPEN DOOR CAUSES SLIDE ARM LIGHT IN DOOR TO COME ON. ACCOMPLISHED ADJ OF PROX SWITCH 7-WN-1 (PROX SW-HANDLE, L AFT ESC SLIDE) PER AMM. COMPLETED TASK 52-71-00-8 20-002-A01 FROM STEPSDR UALA2012031201589Light · inoperativeTAXI LIGHT INOP - LIGHTS. CREW COMMENTS: LENS CRACKED. REPLACED TAXI LIGHT, OPS CHECK OKAY.SDR UALA2012022001040B-Nut · leakingNR 1 ENG SCAVENGE BASELINE OIL TUBE LEAKING AT B-NUT AT RT SIDE 3 O'CLOCK AFT SECTION OF TURBINE. TIGHTENED B-NUT AND LEAK CHECKED.SDR UALA2011102105689Panel · dislodgedPANEL NEAR LEFT OVERWING EMERGENCY EXITS INSIDE CABIN FELL OFF. SECURED PANEL.SDR UALA2011080804101Unknown · malfunctionedEPSU EXT LOAD FWD L' MSG DISPLAYED AFTER CABIN EMERGENCY LIGHT CHECK PER 3 SVC. TRIED NEW EPSU, NO HELP. ALL CIDS TESTS PASS. ALL EMERGENCY LIGHTS WORK IN THE CABIN. ALL EMERGENCY DOOR EXIT LIGHTS WORK NORMAL. DAYLIGHT OPS ONLY. NEEDS FURTHER T-S. CONCUSDR UALA2011042501999Radome · damagedRADOME BIRD STRIKE. MEASURE DELAMINATED AREA 11X15 INCHES DELAMINATED. OUT OF MM LIMITS, REPLACED RADOME. ACCOMPLISHED VISUAL INSP OF AIRCRAFT AND NO DEFECTS NOTED. RADOME SECURED CLOSED.SDR UALA2011031701300Computer · faultyVENT SKIN VLV FAULT, RTFL. SKIN AIR VALVE FAULT. INLET FULL OPEN EXTRACT FULL CLOSED. ALSO LOUD HUM IN COCKPIT. SAMC TEXT: CFDS SHOWS "CHK AEVC SUPPLY" AND SKIN AIR VALVE FAULT. FOUND A CIRCUIT BREAKER ON VU49 (D5)FOR THE AEVC COMPUTER POPPED. REPLACED CSDR UALA2010112404347Warning Light · illuminatedRIGHT AFT SLIDE INDICATION INOP ON DOOR-OXY SYSTEM E CAM PAGE - DOOR-OXY. DOOR 2R SLIDE INDICATION ON ECAM DOOR PAGE SHOWS DISARMED IN FLIGHT. PREVIOUS WRITEUP. ACCOMPLISHED LUBE IAW AMM.SDR UALA2010072302641Windshield · leakingCREW REPORT: CAPTS FWD WINDSHIELD TOP MARGIN CTR HAS NOTABLE DRAFT-LEAK-AIR NOISE FL340-8. CAPTAIN'S WINDSHIELD NEEDS TO BE REPLACED. REMOVED CAPTAIN'S WINDSHIELD PER AMM. START FROM INSTALLATION OF WINDSHIELD. REPLACED CAPT'S WINDOW. CHECKS OKAY.SDR UALA2010060101879Electrical Box · odorELECTRICAL ODOR IN CABIN. FLIGHT DIVERTED. ELEC SMELL DISSIPATED CREW TURNED OFF SIDEWALL, CEILING AND READING LIGHTS. FEW PASSENGERS ALSO REPORTED SEAT AUDIO STARTED CRACKING AND POPPING, SO CREW ALSO TURNED OFF PES. ALL THIS WAS IN VICINITY OF ROWS 21-23. SDR UALA2009102203301Hydraulic Line · chafedGREEN SYSTEM FLUID LOSS. FOUND ENG HYD PUMP PRESS LINE IN PYLON WORN THROUGH UNDER EACH CLAMP BLOCK, REPLACED LINE, BLOCKS AND NYLON ISOLATORS LEAK CHECK GOOD. REPLACED NR 1 ENG DRIVEN HYD PUMP AS PRECAUTION. NO METAL FOUND. PUMP TURNS NORMALLY BY HAND. ASDR UALA2009073102292Connector · unsecureEMERGENCY LIGHTS AT SEATS 13, 14 & 15 ARE OUT. SECURED CONNECTOR AT SEAT 14ABC. GROUND TEST OKAY.SDR 2008UALA03093Skin · dentedLEFT INBOARD FLAP DENT AND ABRASION ON TRAILING EDGE, CENTER AFT OF NR 2 TIRE. FOUND AND REPORTED BY RAMP DURING WALKAROUND. *S/D* IDENTIFIED BY SRM 57-50-00- 001 PG 7 INBOARD FLAP. DAMAGE AREA PER SRM 57-52-00-101 PG 4 AS ZONE 2, PER TABLE 101 PG 2. DENTSDR 2008UALA02757Light · faultyDURING TAKEOFF, THE EMERGENCY LIGHTS IN THE CABIN CAME ON FOR ABOUT 4 MINUTES.SDR 2008UALA02324Connector · looseLWR EMERGENCY LIGHT AT DOOR 1L INOP. FOUND LOOSE CONNECTOR. RESEATED CONNECTOR, OPS CHECKED GOOD.SDR 2008UALA01742Power Supply · weakF/A REPORTED THAT DURING CLIMB-OUT THE EMERGENCY EXIT LIGHTS CAME ON ALL ON THEIR OWN. FOUND EMERGENCY POWER SUPPLY WEAK. REPLACED EPSU AT DL1.SDR 2008UALA00973Oxygen System · lowCREW O2 NEEDS SERVICING 1420 PSI. SERVICED CREW O2 TO FULL. NO LEAKS WERE NOTED FROM THE SYSTEM.SDR 2008UALA00865Battery · failedRT EMERGENCY EXIT LIGHT BATTERY FAILS TEST, BATTERY FAILURE. REPLACED BATTERY. ALL OPS CHECKED NORMAL.SDR 2008UALA00005Bottle · low pressureBOTTLE AT DOOR 2R INDICATES LOW. SERVICED DOOR ASSIST BOTTLE, NO LEAKS NOTED.SDR 2008UALA0005Bottle · reads lowBOTTLE AT DOOR 2R INDICATES LOW.
Back to N497UA