N479UA
Service difficulty reports · 92
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 = 'N479UA' 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 = 'N479UA' 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 CALA2013120293344Generator · faultyAPU ELEC NOT AVAILABLE, PNEUMATICS OK. REPLACED APU GEN IAW MM. RAN APU, OPERATIONS CHECKED GOOD.SDR CALA2013111292876Cradle · defectiveAFT HALON EXTINGUISHER CRADLE STRAP WILL NOT FASTEN CLOSED. REPLACED CRADLE.SDR CALA2013110692692Computer · failedCAP MAP NOT AVAILABLE ON ND. REPLACED FMGC 1 IAW AMM 22-83-34, OPS CHECKED GOOD. LAND TEST IAW AMM22-97-710 TEST PASSED.SDR CALA2013110492583Computer · faultyELAC 2 FAULT DISPLAYED ON UPPER ECAM SCREEN. CONFIRMED NR 2 ELAC COMPUTER IS BAD. SWAPPED BOX INTO THE NR 1 ELAC POSITION & MEL NR 1 ELAC SYSTEM INOPERATIVE. ACFT DOWNGRADED TO CAT 1. SN OF NR 1 ELAC IS 1039, SN OF NR 2 ELAC IS 5084. ALL DDPG IAW DF0980.SDR CALA2013092091297Cylinder · lack of lubeLOUD CONSISTENT GRINDING NOISE FROM NOSE WHEEL STEERING IN ALL LT TURNS WITH ABOUT 10. LUBED NLG STEERING CYL IAW AMM, OPERATIONS CHECKED GOOD.SDR CALA2013081290352Access Panel · damagedRAMP REPORTS THE AFT CARGO DOOR DAMAGE TO THE AFT LOWER ACCESS COVER PANEL 826AR. COMPLIED WITH CDL REMOVED AFT LOWER ACCESS COVER PANEL. OK :REPLACED AFT CARGO LOWER ACCESS PANEL.SDR UALA2013062104321Oxygen Mask · missingBOTH O2 BOTTLES MISSING MASK IN FIRST CLASS. DEF DUE TO TIME. MOVED ONE BOTTLE FROM REAR TO FIRST CLASS FOR MEL. SO ONE IN COACH AND ONE IN FIRST CLASS DEF. REPLACED 2EA OXYGEN MASKS IN FWD AFT LOCATIONS, OK TO CONTINUE.SDR CALA2013082690766Screw · looseRAMP LEAD REPORTED A LOOSE SCREW ON V-STA P. SECURED SCREW.SDR UALA2013042302813Valve · leakingFUEL DRIPPING FROM LEFT WING OUTBOARD DRAIN. REPLACED OUTER VALVE, NO LEAKS NOTED.SDR UALA2013032101768Plate · crackedDOOR 1L DOES NOT CLOSE FLUSH, UPPER LEFT TOP. FOUND UPPER FWD CORNER COVER PLATE CRACKED 2 INCH IN LENGTH. STOPPED DRILLED AND APPLIED HIGH SPEED TAPE PER SRM 52-10-00. 1L DOOR COVER PLATE CRACKED.SDR UALA2013031901692Floorboard · dentedAFT CARGO BAY ONE FOOT FWD OR CARGO DOOR, FOUR INCH DENT IN FLOORBOARD. REPAIRED IAW SRM 53-02-00.SDR UALA2013012800490Unknown · vibrationCREW REPORTS VIBRATION. VIBRATION STARTED WHEN GEAR WAS PUT DOWN, FULL FLAPS. VIBRATION REMAINED UNTIL TOUCHDOWN. ACCOMPLISHED MT 27-005, NO MIGRATION NOTED VERIFIED UPPER AND LOWER KINK AND CUSHION SEAL ARE OK. NO DEFECT NOTED ON GENERAL VISUAL FLAP INSSDR UALA2013010900137Tail Cone · crackedNR 1 ENGINE TAIL CONE IS CRACKED AT 3 AND 7 O`CLOCK POSITIONS. CRACKS APPROXIMATELY 3-5 INCHES LONG. CRACKS AT 3 AND 7 O'CLOCK ARE FROM PREVIOUS WELDED AREAS AND TRUE MEASUREMENTS OF SEVERAL CRACKS RANGE FROM .5 TO 1.5 INCHES. ALL WITHIN ZONE 1 AND OK FOR SSDR UALA2012121907307Switch · defectiveCAP SIDESTICK PTT STICKS CAUSING STUCK MIC. TROUBLESHOT, FOUND CAPTAIN PUSH TO TALK SWITCH BAD REPLACED, OP CHECKS GOOD.SDR UALA2012091705247Fairing · dentedDENT IN FORWARD MOST END OF MAIN BODY FAIRING ON LEFT SIDE OF ACFT. DAMAGE IS 2 IN BY 1 IN AND 0.03125 IN DEEP. DENT IS 15 INCHES FROM TOP OF FAIRING AND 1 INCH 3 INCHES FROM TRAILING EDGE. REF ECRA5325-01001 NO UNDERLYING CRACKS OR LOOSE FASTENERS AND EXTERSDR UALA2012082004643Computer · faultyWX RADAR FAULTY, FLIGHT DIVERTED. DUE TO REPEATED C-B RESETS, REPLACE AEVC PER AMM. (PCN 482-9059). REPLACED AEVC, OPS CHECKS GOOD. REPLACE AEVC FILTER. WEATHER RADAR SYSTEM OPS CHECK GOOD.SDR UALA2012061503289Stowage Box · defectiveON TAXI IN - CREW O2 PRESS WENT TO ZERO. REPLACED FIRST OFF O2 STOWAGE BOX ASSY PER AMM, OPS CHECKS NORMAL.SDR UALA2012052702985Spring · unsecureBOTH NOSE GEAR DOWNLOCK SPRINGS ARE NOT PROPERLY SEATED IN GROVE LWR FITTING. REPLACED BOTH LEFT AND RIGHT NOSE LANDING GEAR LOCK SPRINGS, ACFT OK TO CONTINUE.SDR UALA2011081704376Plate · corrodedCORROSION ON SILL PLATE AT DOOR 2R BETWEEN FRAMES 66 AND 68 AT FLOOR LEVEL. MAJOR REPAIR. INSTALLED REPAIR AT FR 68 PER SRM53-41-14 ON NR D3700Y.SDR UALA2011042001913Ram Air Turb · lack of lubeFOUND RAT OIL LEVEL DRY DURING RAT CHECK. RAT REMOVED, INSTALLING NEW RAT. REPLACED RAT. MADE SMC 12 AND SMC 13 TO COVER OPS CHECKS.SDR UALA2011042201953Shade · damaged11F EMERGENCY EXIT WINDOW SHADE DAMAGED. SHADE REMOVED. REQUIRES EXIT HATCH REMOVAL AND RE-INSTALLATION. REMOVED AND REPLACED LINER AND WINDW SHADE. SHADE BINDS, NEW SHADE ORDERED. RT EXIT HATCH REMOVED. REPLACED SHADE, RE-INSTALLED HATCH.SDR UALA2010120304441Feeder Cable · damagedFLIGHT AUGMENTATION COMPUTER 2 INOP - AUTO FLT. IN CRUISE GOT FAC 2 FAULT RESET IAW ECAM. REPLACED SWITCH 3XU2, REPLACED NR 2 GCU, GENERATED WRITE UP FOR OPS CK AFTER REPLACEMENT OF NR 2 PYLON GEN HARNESS. REPLACED IDG AND REPLACED FEEDER CABLE.SDR UALA2010082603150Washer · out of toleranceVERIFIED NR O2 LEAK AT LT SIDE CAPTAIN'S. SECOND OBSERVER O2 MASKS CHANGED OUT FROM AC 4101 DOWN TO LT SIDE FLOOR LEVEL T-FITTING. CHANGED OUT CAPT'S AND SECOND OBSERVER'S STOWAGE BOX 5774HM, 10RN1 COPPER RING CONICAL WASHER. TIGHTENED AND LEAK CHECKED.SDR UALA2010082303100Microphone · inoperativeCAPTAIN'S OXYGEN MASK MICROPHONE IS INOPERATIVE. SWAPPED CAPT. O2 MASK BOX WITH 2ND OBS. MASK BOX THAT DOES NOT USE O2 MIC. NO NEED TO REPLACE 2ND OBS MASK BOX. REPLACED IAW MM.SDR UALA2010071902564Apu · faultyAFTER PACKS WERE TURNED ON ACFT HAD A FOUL SMELL. DURING PACK BURNOUT FOUND APU TO BE THE SOURCE OF OIL SMELL IN ACFT CABIN. AFTER APU SHUTDOWN, THEN RE-START SMELL CAME BACK. RECOMMEND REPLACING CABIN RECIRC FILTERS DUE TO POSSIBLE CONTAMINATION.-DURING PACSDR UALA2010070702421Power Supply · malfunctionedCABIN EMERGENCY EXIT LIGHT TEST GIVES 'EPSU INTERNAL LOAD FWD LEFT' FAULT. REPLACED BATTERY AND POWER SUPPLY. SYSTEM TESTS OKAY.SDR UALA2010050301469Cylinder · low pressureDOOR 1L ASSIST BOTTLE PRESSURE LOW. SERVICED ASSIST CYL.SDR UALA2009122103929Bottle · underservicedDOOR 1L ASSIST BOTTLE PRESSURE LOW, REPORTED BY F/A. SERVICED BOTTLE PRESSURE.SDR UALA2008122406985Light · inoperativeSEAT 18 EMERGENCY LIGHT IS INOP. REPLACED EMERGENCY LIGHT ON SEAT ROW END CAP AT POSITION 18C, OPS NORMAL.SDR UALA2008122406984Wire · brokenSEAT MOUNTED EMERGENCY LIGHTS AT ROW 10 AND 11 LEFT HAVE BROKEN WIRES. LIGHTS ARE OVERWING EXIT-NOT DEFERRABLE. REPLACED UNDER SEAT CABLE P/N 565-2099 ON BOTH ROWS REF IPC 33-51-09, ALL EMERGENCY LIGHTS ALL ROWS OPS NORMAL.SDR 2008UALA03314Power Supply · unknownEPSU INT LOAD FWD L FOUND ON 3SVC CHECK.SDR 2007UALA03162Oxygen Mask · inoperativeFIRST OBSERVERS SEAT QUICK O2 MASK INOP BOX ASSY NEEDS CHANGED. *S/D* REPLACED FIRST OBS O2 STOW BOX ASSY.SDR 2007UALA02764Oxygen Mask · no testCAPTS O2 MASK WILL NOT TEST. FOUND FAULTY MASK & LEAKING HARNESS. REPLACED MASK.
SDR 2007UALA02618Radar · inoperativeRTFL DUE TO INOPERATIVE WEATHER RADAR. [08-24-07] REPLACED WX RADAR PN 622-5137-601. NO REPEATS SINCE 7/16/07.SDR 2007UALA02590Smoke Detector · faultyLAV SMOKE DETECTOR FAULT. LAV SMOKE DETECTOR FAULTY. REPLACED LAV SMOKE DETECTOR. OPS CHECK GOOD.SDR 2007UALA00245Bottle · low pressureFLIGHT ATTENDANT ADVISES BOTTLE PRESSURE AT DOOR 1L READS LOW. REPLACED DOOR 1L DOOR-DAMPER AND EMERGENCY-OPERATION CYLINDER. COMPLETE INSPECTION OF REPLACED BOTTLE.SDR 2006UALA01371Compressor · stalledRETURNED TO FIELD DUE TO NR 1 ENG COMPRESSOR STALL.SDR 2005UALA00974Light · faultyEMERGENCY EXIT LIGHT TEST DOES NOT PASS. REPLACED BATTERY.SDR 2004UALA00306Bleed Valve · failedRETURNED TO FIELD DUE TO FAILED BLEED VALVE. FAN AIR VALVE CONTROL THERMOSTAT FAILED. REPLACED FAN AIR VALVE CONTROL THERMOSTAT. OPERATIONS CHECK NORMAL.SDR 2004UALA00287Connector · damagedFWD CARGO DOOR OPEN INDICATION ON TAKEOFF. *S/D* REPAIRED DAMAGED CONNECTOR BACKSHELL ON DOOR WARNING SENSOR.SDR 2004UALA00113Connector · damagedAFT RT, LWR DOOR EMERGENCY EXIT LIGHT INOPERATIVE. REPAIRED CONNECTOR. CHECKS OK.SDR 2002UALA01263Disk · burstRETURN TO FIELD WITH A FUEL IMBALANCE PROBLEM. OVER PRESSURE BURST DISC BETWEEN THE LEFT INNER WING FUEL TANK AND THE CENTER FUEL TANK RUPTURED. FUEL TRANSFERRED FROM THE LEFT WING TO THE CENTER CAUSING AN IMBALANCE BETWEEN THE INNER WING TANKS.
Back to N479UA