N438UA
Service difficulty reports · 127
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 = 'N438UA' 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 = 'N438UA' 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 UALA2010070202363Oxygen System · malfunctionedCAPT O2 MASK TEST BUTTON ON DOOR DOES NOT RESET AFTER BEING PUSHED. REPLACED O2 BOX, LEAK CHECKS AND OPS CHECK OKAY.SDR UALA2010030800802Slide · reads lowSLIDE PRESSURE LOOKS LOW AT DOOR 1R. REPLACED SLIDE.SDR UALA2010012200271Stowage Box · malfunctionedCAN'T SEE YELLOW AIR FLOW INDICATOR ON F-O O2 MASK. REPLACED FO 02 MASK STOWAGE BOX. CHECKS GOOD.SDR UALA2009092102961Rod End · defectiveAIRFRAME VIBRATION DURING CLIMB AT 320 KTS - FL250. REPLACED ALL THREE RUDDER ROD ENDS.SDR UALA2009070601912Girt Bar · contaminatedDOOR 2R ARMING HANDLE HARD TO MOVE. NO FAULTS FOUND. CLEANED DOOR GIRT BAR AREA OF DEBRIS. CYCLED ARM & DISARM HANDLE SEVERAL TIME. OPS CHECKS GOOD.SDR UALA2008111305928Valve · faultySMOKE-FIRE TEST FAILS FOR CARGO SYSTEM. SMOKE-FIRE TEST FAILS FOR CARGO SYSTEM. REPLACED AFT CARGO VALVE 33HN.SDR 2008UALA05928Detection Sys · faultySMOKE - FIRE TEST FAILS FOR CARGO SYSTEM.
SDR 2008UALA01121Bracket · bindingON TAKEOFF GOT L/G GEAR NOT UPLOCKED AND CYCLED GEAR HANDLE. GEAR RETRACT 2ND TIME. FOUND 25GA SENSOR TARGET BRACKET ASSY BINDING, CAUSING TARGET TO NOT COME INTO ALIGNMENT WITH SENSOR. FOUND TARGET BRACKET SWIVEL BUSHING AND 9366BOLT BINDING. REMOVED BOLTSDR 2008UALA00992Floorboard · damagedCARGO FLBRD RPL S GLS PNL. MAJOR REPAIR ACCOMPLISHED AT LCQ VIA COA PROJECT.SDR 2008UALA00972Stringer · corrodedSTR 39R HAS CORROSION BETWEEN FR 65 AND 66. MAJOR REPAIR ACCOMPLISHED AT LCQ.SDR 2008UALA00863Stringer · corrodedFWD PIT STRINGER 41L HAS CORROSION BETWEEN FRAME 34 AND 35. MAJOR REPAIR ACCOMPLISHED AT LCQ.SDR 2008UALA00787Sill · corrodedTHE L2 DOOR SILL PLATE HAS CORROSION AT FR 68. MAJOR REPAIR ACCOMPLISHED AT LCQ.SDR 2008UALA00314Proximity Sensor · failedRTFL DUE TO A GEAR UPLOCK INDICATION PROBLEM. FAILURE OF NOSE L-G EXT PROX SENSOR 25GA. REPLACED SENSOR 25GA, PERFORMED GEAR SWINGS, ALL NORMAL OPS.SDR 2007UALA04877Engine · malfunctionedRAMP REPORTS NR 2 ENGINE TAILPIPE FIRE ON SHUTDOWN AT GATE. OIL OBSERVED LAST STAGE AFT TURBINE SECTION. CAUSE WAS AN OIL COKE FIRE. PERFORMED MAINTENANCE TIP TO CLEAN, REPLACE COMPONENTS IN AFT TAILCONE. AFTER THIS MTC WAS PERFORMED, THERE WERE NO FURTHERSDR 2007UALA04503Flap · damagedLEFT OUTBOARD FLAP IS DAMAGED. REPLACED FLAP AND PERFORMED TEST FLIGHT- OK.SDR 2007UALA04446Structure · corrodedFWD GALLEY HAS CORROSION DAMAGE. FOUND WATER PENETRATION BELOW GALLEY SUBFLOOR. REPAIRED FLOOR STRUCTURE.SDR 2007UALA03582Mask · no testF/O'S MASK WILL NOT TEST. FOUND IMPROPER STOWAGE OF MASK. RESET THE FO MASK-TESTS NORMAL.SDR 2007UALA03104Light · inoperativeLIGHT AT 13 ABC NOT ILLUMINATING WHEN TESTING THE EMERGENCY ESCAPE PATH LIGHTING. REPLACED LIGHT ASSY.SDR 2007UALA02386Bottle · low pressureDOOR ASSIST BOTTLE AT DOOR 1L IS LOW - 1300 PSI.SDR 2007UALA02335Limiter · inoperativeRUDDER TRAVEL LIMITER SYSTEM 1 INOP.SDR 2007UALA00875Connector · dirtyCIDS TEST FAULTS BPSU BATTERY AFT LT. CONNECTOR DIRTY. CLEANED CONNECTION FOR BATTERY POWER SUPPLY UNIT.SDR 2007UALA00250Sill · corrodedAFT RIGHT DOOR SILL PLATE IS CORRODED BEYOND LIMITS AT FWD AND AFT ENDS. MAJOR REPAIR. REPLACED R2 DOOR SILL.SDR 2006UALA02263Warning Message · illuminatedELAC 2 FAULT DISPLAYED ON UPPER ECAM SCREEN. CYCLED CIRCUIT BREAKER R20 AND STANDBY SUPPLY CIRCUIT-BREAKER ON 105VU AND FAULT CLEARED.SDR 2006UALA00478Radar · failedDUE TO WEATHER CONDITIONS AND LOSS OF WX RADAR, DECISION WAS MADE TO DIVERT THE FLIGHT. WEATHER RADAR TRANSCEIVER TESTS RETURNED "NO FAULT FOUND". TESTS FOUND WEATHER RADAR SCANNER HAD FAULTY AZ MOTOR AND THERMAL RESISTOR. REPLACED WEATHER RADAR TRANSCEIVESDR 2006UALA00233Power Supply · no testDURING EEL TEST HALF OF ACFT SEATS LIGHTS FAILED TO ILLUMINATE. REPLACED AFT RT DOOR PWR SUPPLY AND BATTERY, LEFT MID BATTERY, SEAT EEL LIGHTS AT ROWS 18,20. OP CHECKS NORMALLY AT ALL SEATS.SDR 2005UALA01092A/C Pack · malfunctionedFLIGHT DIVERTED WITH THE NR 1 PACK TRIPPING AND NR 2 PACK ALREADY DEFERRED. AIRCRAFT LOST NR 1 PACK APPROXIMATELY 20 MINUTES AFTER TAKEOFF. NR 2 PACK PREVIOUSLY DEFERRED. CIRCUIT BREAKERS CYCLED AND PROVIDED NO HELP. REPLACED NR 1 RAI ACTUATOR (MR21603-11 SDR 2002UALA00975Light · inoperativeEMERGENCY EXIT LIGHT BETWEEN OVERWING DOORS INOPERATIVE ON TEST.
Back to N438UA