N478UA
Service difficulty reports · 95
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 = 'N478UA' 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 = 'N478UA' 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 CALA2014021090335Stringer · corrodedSTRINGER 41 LT HAS CORROSION BETWEEN FRAME 63 - FRAME 64. R & R STRINGER & ATTACHING PARTS IAW A320 SRM 51-42-11 PAGE 7 & 53-41-13 PAGE 101.SDR CALA2014020690322Stringer · corrodedCORROSION ON STRINGER 40L BETWEEN FRAME 56 - 64 HAS NO ALLOWABLE LIMITS IAW SRM 53-41-13.SDR CALA2014020690306Stringer · corrodedCORROSION FOUND ON STRINGER 43L BETWEEN FRAME 54 - 60 HAS NO ALLOWABLE LIMITS IAW SRM 53-41-13, PG 101. REPLACED STRINGER 43L BETWEEN FRAME 54 - 60 IAW SRM 51-42-11, PG 9.SDR CALA2014020690305Stringer · corrodedCORROSION ON STRINGER 41R BETWEEN FRAME 58 - 64 HAS NO ALLOWABLE LIMITS IAW SRM 53-41-13, PG 101. REPLACED STRINGER 41R BETWEEN FRAME 58 - 64 IAW SRM 51-42-11, PG 9. CORROSION ON STRINGER 41R BETWEEN FRAME 58 - 64 HAS NO ALLOWABLE LIMITS IAW SRM 53-41-13, PGSDR CALA2014020690304Plate · wornLT NR 2 ENG PYLON BOTTOM ANTI CHAFE PLATE FOUND WORN AT HMV. PLATE WAS REPAIRED IAW SRM 54-51-12 FIG 202 FOR CONFIG 2 IRR 54-51-12-2-001-00 TB L 202.SDR CALA2014020390282Skin · dentedLT FUSELAGE SKIN DENTED AT FRAME 26 STRINGER 34 - 35. REPAIR DOUBLER INSTALLED IAW SRM 53-00-11 FIG 240, SRI 53-00-11-2-017-00 TBL 223.SDR CALA2013123094026Switch · sticksFIRST OFFICER`S SIDE STICK MIC TRANSMITTER SW STICKS INTERMITTENTLY. DOES NOT FULLY RELEASE AFTER TRANSMITTING. OCSNL STUCK MIC REPLACED FIRST OFFICER`S PTT SWITCH ON HANDGRIP ASSEMBLY. FIRST OFFICER`S PTT SWITCH OPERATION TESTED GOOD.SDR CALA2013121993811Lanyard · out of positionON WALK AROUND FOUND SEAL HANGING OUT OF HYD SERVICE DOOR. HYD SERVICE DOOR SEAL IS INTACT, STOWED LANYARD FOR DOOR.SDR CALA2013112093096Computer · faultyDUE TO HISTORY ELAC 2 NEEDS R & R. REPLACED ELAC, OPERATIONS CHECKED NORMAL.SDR CALA2013110692695Starter · faultySPARKS OBSERVED ON START OF ENG 2, REPLACED STARTER.SDR CALA2013102192229Valve · faultyUNUSUAL CYCLING SOUND FLOOR OF AFT GALLEY. PLACED AFT CARGO EXTRACTION FAN ON MEL IAW 2128F, PULLED & COLLARED CIRCUIT BREAKER S22, AFT CARGO VENT & HTG FAN AS PRECAUTIONARY. IAW GMM 05-30-05, COMPLIED WITH MX PROCEDURES, OK TO CONTINUE. R & R AFT CARGO COSDR CALA2013091891266Blade · chippedPOST WALK AROUND INSPECTION FOUND CHIP IN FAN BLADE OF ENGINE 1.SDR CALA2013082790788Life Vest · missingFLIGHT DECK LIFE VEST MISSING. REPLACED COCKPIT LIFE VEST.SDR UALA2012102306064Lens · missingAPU FIRE LIGHT ASSEMBLY ON EXT INTERPHONE PANEL MISSING. LENS INSTALLED FOR APU FIRE ASSEMBLY PANEL.SDR UALA2012070603643Actuator · activatedNR 2 ENGINE DRY MOTOR AND LEAK CHECK. REMOVED AND REPLACED HPT AND LPT ACTUATOR.SDR UALA2012040902150Spring · migratedDURING WALK AROUND FOUND NR 2 NLG DOWNLOCK SPRING MIGRATING. REPLACED SPRING.SDR UALA2012022001009Slide · misrepairedINBOUND INSPECTION FOUND THE RT OVERWING SLIDE BALL LOCKS PAINTED OVER. WILL NEED SLIDE REPLACED BEFORE NEXT REVENUE FLIGHT. WALKAROUND INSPECTION COMPLETE, NO DEFECTS NOTED. REPLACED RT ESCAPE SLIDE.SDR UALA2012010300052Buffer · malfunctionedCAPTAIN'S RUDDER PEDALS DO NOT SPRING. RUDDER MOVEMENT AND BRAKE DEFLECTION IS OTHERWISE NORMAL. REPLACED CAPTAIN'S RUDDER PEDAL ADJUSTMENT BUFFER. OP CHECKED OKAY.SDR UALA2011120806746Servo Valve · faultedWHEN GEAR WAS LOWERED, RECEIVED AN AUTO BRAKE FAULT ECAM MESSAGE. CLEARED AFTER 2ND EXTENTION. REPLACED NORMAL BRAKING SERVO VALVE, LEAK OP CHECKED NORMAL.SDR UALA2011092305139Fastener · looseON CREW WALK AROUND FOUND FASTENER LOOSE ON RIGHT AC BAY ACCESS PANEL 192LB .2ND FASTENER INBOARD FWD CORNER. FASTENER INSTALLED AND TAPED OVER.SDR UALA2011092005076Fuse · blownBACKLIGHT IS OUT ON AIR COND OVERHEAD PANEL IN COCKPIT. AIR COND PANEL LIGHTPLATE IS INOP. NEEDS LIGHTPLATE 565-1144. NON STOCK SEATTLE. REPLACED FUSE IN POWER SUPPLY.SDR UALA2011070703386Computer · faultyAIL SERVO FAULT DISPLAYED ON UPPER ECAM SCREEN - F- CTL. REPLACED ELAC 1 PER MM, MSG CLEARED. SEPARATE WRITE UP MADE FOR CAT III CHECK.SDR UALA2011070703385Dcu · malfunctionedFLIGHT CONTROL DATA CONCENTRATOR (FCDC) 2 INOP - F-CTL. SAMC TEXT: REPLACE FCDC2 482-9544 OR DEFER PER 2795A. NO TIME TO TROUBLESHOOT. INSTALLED NEW FCDC POS 2 PER MM AND OPS CHECKED PER MM, NO FAULTS.SDR UALA2011062903208Control Unit · malfunctionedAMBER STEERING DISCONNECT MESSAGE ON ECAM. WHEEL STEERING DE-ACTIVATION BOX FAILED AND DISCONNECTED STEERING TILLERS. REPLACE PER AMM. REPLACED 5GC STEERING DISCONNECT.SDR UALA2011062703139Controller · inoperativeCAPTAIN'S WINDSHIELD HEAT IS INOPERATIVE. RESISTANCE CHECKED GOOD. REPLACED WHC 2DG1.SDR UALA2011062103035Transceiver · failedWEATHER RADAR FAILURE, FLIGHT DIVERTED. WEATHER RADAR PAINTS GROUND BUT NO CELLS. ATC VERIFIED CELLS PUT NO DISPLAY. WILL NOT WORK ANY SCAL. REPLACED WEATHER RADAR TRANSCEIVER PER AMM. ACCOMPLISHED ADJUSTMENT TEST PER AMM. TEST PASSED NO FAULTS, INDICATSDR UALA2011041501830Control Unit · malfunctionedCARGO HEAT INOP. REPLACED CARGO COMP TEMP SENSOR, NO HELP. TRIED CARGO HEAT CONTROLLER 10HC, NO HELP. REINSTALLED ORIGINAL CONTROLLER. CARGO HOT AIR VALVE WILL NOT OPEN. CANNOT REGULATE TEMP USING CARGO HEAT SELECTOR. REPLACED AFT CARGO PIT TEMP SENSOR, SDR UALA2011041501834Panel · faulty'ENG FIRE EXTING-SQUIB' LIGHT OF 'AGENT 1' PUSHBUTTON SWITCH IS OFF DURING 'LOOP-SQUIB TEST'. ENG 2 SQUIB LIGHT WILL NOT ILLUMINATE DURING FIRE TEST. COMPLETED REQUIRED CHECKS AS REQUIRED IN MEL 2621F. FOUND TO NEED FIRE TEST CONTROLLER IN COCKPIT. SEEMS TO BSDR UALA2009111803587Shutoff Valve · failedDURING ENG 1 FIRE BOTTLE CHECK LEFT ENGINE HYD FIRE SHUTOFF VALVE FAILED TO REOPEN WHEN FIRE SWITCH PUSHED TO NORMAL POSITION. REPLACED LT HYD S-O VALVE, OP CHECKED NORMAL, NO FAULTS.SDR UALA2009032400877Fitting · looseNR 1 ENG HYD LINES AFT PYLON LWR WING SKIN BULKHEAD FITTING TO WING REAR SPAR IS LOOSE, WORKING AND WORN. WORK ACP ON SMB W-U R7483N.SDR UALA2009032400876Hydraulic Line · looseNR 2 PYLON AFT HYD LINES THRU TRAILING EDGE WING SKIN ARE LOOSE, ATTACH FASTENERS WEARING INTO SKIN DOUBLER. WORK ACP ON SMB W-U M9110Q.SDR UALA2009031900838Static Port · obstructedLT STBY STATIC PORT EXTRA CRITICAL BARE SKIN HAS OVER SPRAY BLUE COLOR PAINT. REF SRM 53-00-11. PAINT REMOVED.SDR UALA2009012200239Pin · missingCOCKPIT HALON FIRE EXTINGUISHER IS MISSING PIN AND SAFETY SEAL. ALSO IS PAST HYDROSTATIC SERVICE DATE CHECK.SDR 2008UALA04053Warning Message · activatedLAVATORY SMOKE DETECTOR DISPLAYED ON UPPER ECAM.SDR 2008UALA03525Connector · disconnectedEMERGENCY FLOOR EXIT LIGHTS INOP AT FWD CABIN BULKHEAD AND ROW 9. ALL OTHER LIGHTS OPERABLE. FOUND CONNECTOR UNDER SEAT DISCONNECTED. RE-CONNECTED UNDER SEAT CONNECTION, ALL LIGHTS OPERATE.SDR 2008UALA02730Warning System · activatedELAC 1 FAULT DISPLAYED ON UPPER ECAM SCREEN. FCDC FAILED---NO SHOP FINDINGS. REPLACED FCDC-2. SYSTEM CKS NORMAL, NO MSG'S DISPLAYED. ACCOMPLISHED AFS & LAND TESTS. CHECKS OK.
SDR 2007UALA04835Slide · low pressureDOOR 1L ESCAPE SLIDE PRESSURE APPEARS LOW. UNKNOWN PRESSURE LEAK WITHIN THE THE SLIDE ASSY. REPLACED THE 1L SLIDE ASSY. SLIDE WAS SENT TO SHOP FOR OVERHAUL.SDR 2007UALA03373Computer · malfunctionedAFTER TAKEOFF, EXPERIENCED AC PITCH UP ATTITUDE, HAD TO HOLD CONSTANT PRESSURE OF NOSE DOWN TO CORRECT. SYS OK WITH AUTO PILOT ON. TURNED OFF ELAC 2 AND NOW PITCH PROBLEM RESOLVED. NO FAULT OR ECAM WARNINGS PRESENT. NR 2 ELAC OVERHEAT AND TRANSDUCER FAILURSDR 2007UALA03322Bolt · misinstalledLEFT AFT SLIDE INDICATION INOP ON DOOR -OXY SYSTEM ECAM PAGE - DOOR-OXY CREW COMMENTS: 2L SHOWS UNARMED IN FLT ON LOWER ECAM DOOR AND GIRT BAR APPEAR NORMAL. DOOR 2L DOES NOT SHOW ARMED. FOUND BOLT FOR ARMING HAND L/E IN BACKWARDS INSTALLED IN CORRECT MANNESDR 2007UALA02537Display · malfunctionedLAV AND CARGO DETECTOR FAULT DISPLAYED ON UPPER ECAM SCREEN, SMOKE. REPLACED SCDU.SDR 2007UALA01941Warning System · activatedELEC - BATTERY 1 FAULT IN FLIGHT. NO PILOT ACTION REQUIRED. REPLACED BCL1 AND BATTERY NR 1.SDR 2006UALA01902Blower · failedLANDED UNDER AMBER ALERT DUE TO A VENTILATION PROBLEM. REPLACED AVIONICS VENT BLOWER AT 20HQ. RAN AVIONICS VENT TEST. OPS CHECK OK.SDR 2004UALA00643Landing Gear · inoperativeUNABLE TO RETRACT LANDING GEAR AFTER TAKEOFF. NLG STRUT SEALS WERE TORN. REPL ACED THE NLG STRUT SEALS. OPERATIONS CHECK NORMAL.SDR 2002UALA01715Ballast · overheatedFLIGHT DIVERTED DUE TO BURNING ODOR. REPLACED BALLAST AT SEAT ROWS 9 & 10ABC, BALLAST HAD ELECTRICAL ODOR .SDR 2001UALA02004Relief Valve · brokenFUEL AUTO FEED FAULT ECAM MESSAGE. FUEL IMBALANCE BETWEEN LEFT AND RIGHT WING TANKS OF 1500 POUNDS. FOUND FUEL TANK PROTECTOR-OVERPRESSURE DISC BROKEN BETWEEN THE LEFT WING AND CENTER FUEL TANKS. THIS ALLOWED FUEL TO MIGRATE FROM THE LEFT WING TANK INTO THE
Back to N478UA