N437UA
Service difficulty reports · 128
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 = 'N437UA' 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 = 'N437UA' 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 2008UALA05601Valve · inoperativeLANDING GEAR EXT DELAY T-S: REPLACE LANDING GEAR SAFTEY VALVE 49GA. REPLACED LANDING GEAR SAFTEY VALVE 49GA PER MM32-31-17 THRU STEP 3.C. PG 411. NEED TO COMPLETE INSTALLATION FROM STEP 4.D. PG 412 THRU TO END. CONT OF AMIS ITEM 7342001.SDR 2008UALA03374Slide · low pressureDOOR 1R SLIDE PRESSURE IS LOW.SDR 2008UALA02629Window · failedON APPROACH AT ABOUT 5000 FT, BIRD STRIKE ON F/O SIDE WINDOW. WINDOW CRACKED.SDR 2008UALA00644Mechanism · out of adjustDOOR 1L DOES NOT SHOW "SLIDE" ON ECAM OR "SLIDE ARMED" ON DOOR WHEN DOOR ARMING HANDLE IS PLACED IN THE ARM POSITION. FOUND DOOR ARMING MECHANISM OUT OF ADJUSTMENT. ADJUSTED DOOR, ARM LIGHTS OPERATE NORMALLY.SDR 2008UALA00447Sill · corrodedR2 DOOR SILL PLATE HAS 3 SPOTS OF CORROSION AT FR 68. MAJOR REPAIR ACCOMPLISHED.SDR 2008UALA00156Diaphragm · leakingFOUND DOOR 2L DAMPNER AND EMERGENCY OPERATION CYLINDER READING "0" DURING 3 SVC. SUSPECT WEAK/LEAKING DIAPHRAGM AND/OR SEALS. REPLACED EMERGENCY OPERATION CYLINDER DIAPHRAGM AND SEALS. NO REPEATS SINCE ORIGINAL.SDR 2007UALA05042Lever · stuckUNABLE TO ARM 2R. ARMING LEVER STUCK. DOOR LEVER WAS FREED UP AFTER NUMEROUS ATTEMPTS. NO DEFECTS WERE NOTED AND DOOR CLOSED/ARMED WITHOUT EFFORT AFTERWARD.SDR 2007UALA04445Diaphragm · leakingDOOR ASSIST CYLINDER ON R2 DOOR HAS ZERO PRESSURE. FOUND LEAKING DOOR ASSIST CYLINDER. REPLACED DOOR ASSIST CYLINDER ON R2 DOOR.SDR 2007UALA04323Bottle · reads lowDOOR 2R SLIDE BOTTLE PRESSURE LOW. SERVICED DOOR ACCUMULATOR AS NEEDED. NO REPEATS SINCE ORIGINAL.SDR 2007UALA04324Feeder Cable · faultyFWD EEL STRIP IN FIRST CLASS INOPERATIVE. FOUND BROKEN WIRE. REPLACED CABLE. CHECKED OK.SDR 2007UALA03307Buss Bar · shortedFLIGHT DIVERTED DUE TO ELECTRICAL ODOR. FOUND 1 PHASE OF CB 3XN2(B US 2SUPPLY 204XP)MISSING, CB 3XN2 POPPED WITH CAP BROKEN. ALL USERS OF SOURCE 204XP POWER FAILED DOWNLINE. REPLACED CB 3XN2, AB2, BUS 2 204XP SUPPLY- INSPECTION FOR SHORTS IN WIRING BETWEENSDR 2007UALA01447Switch · malfunctionedFLIGHT DIVERTED DUE TO YELLOW HYD RESERVOIR LOW LEVEL. REPLACED LOW LEVEL SWITCH.SDR 2006UALA02398Unknown · odorSTRONG ELECTRICAL SMELL IN THE COCKPIT CAUSED RTFL. REPLACED AVIONICS EXTRACT FAN (18HQ).SDR 2006UALA01602Lamp · inoperativeEMERGENCY ROW PATH LIGHT ON ROW 24 BURNED OUT. REPLACED EMERGENCY LIGHT, TEST OK.SDR 2006UALA01347Power Supply · failedFOUND EMERGENCY LIGHT TEST FAILED. REPLACED LEFT EPSU, TEST PASSED.SDR 2006UALA01130Power Supply · failedEMERGENCY LIGHT SYSTEM TEST FAILS *L EMER UNIT*. REPLACED LIGHT EMER PWR SUPPLY MR33512 AND AD 3214-30 BATTERY PER MM 33-51-38. SYS TEST OKSDR 2006UALA01065Electrical Sys · malfunctionedFLIGHT ATTENDANT EXPERIENCED ELECTRIC SHOCK IN AFT GALLEY POSSIBLY DURING GEN TRANSFER AT SECOND. UNABLE TO DUPLICATE EVENT AND NO DEFECTS FOUND.SDR 2006UALA00823Electrical Box · failedELECTRICAL ODOR REPORTED ON FINAL APPROACH NEAR 12ABC. FOUND LT SIDE OF ENTERTAINMENT SYS INOP. FOUND FAULTY SEAT TO SEAT CABLE BETWEEN SEAT ROWS 12ABC AND 13ABC. FOUND BURNED SEAT ELECTRONIC BOX BENEATH SEAT ROW 13ABC. REPLACED SEAT TO SEAT CABLE AND SEAT ESDR 2004UALA00777Oxygen Mask · misriggedFLIGHT DIVERTED DUE TO LOW COCKPIT OXYGEN PRESSURE. MASK WAS NOT STORED PROPERLY IN THE STORAGE BOX. IMPROPER STORAGE CAN ENGAGE THE 02 TEST VALVE, WHICH WILL ALLOW THE O2 TO VENT. THE MASK IS NOW STORED PROPERLY.SDR 2003UALA00490Fmu · failedNR 1 ENGINE EXPERIENCED A FLAMEOUT. REPLACED FMU. REMOVED FMU DISASSEMBLED AT OEM, REVEALING A BUILD ERROR IN THE SPILL VALVE SLEEVE.SDR 2002UALA00919Control Unit · failedON FINAL GOT L-G LGCIU 1 FAULT. EXTENDED THE GEAR AND GOT REVERSER NR 1 AS INOP SYSTEM. REPLACED LGCIU-1.SDR 2002FA0000408Transformer · arcedOUTPUT TERMINALS ON THE TRANSFORMER ASSEMBLY SHOWS A CLEAR EVIDENCE OF ARCING ONE OF THE TERMINALS HAD BURNED OFF. MFG HAS A SIL. REGARDING THIS CONDITION.SDR 2001UALA00022Power Supply · failedCABIN EMERGENCY LIGHT TEST FAILED. REPLACED POWER SUPPLY 13WL. OPERATIONAL CHECK GOOD.SDR 2000UALA00172Battery · inoperativeEMERGENCY LIGHT TEST FAILS WITH A \COMM AFT L\ DISPLAYED. *S/D* REPLACED EMERGENCY LIGHT BATTERY ABOVE DOOR 2L.SDR 99UAL900352O Ring · failedAT APPROX 1 HOUR OUT OF LAX, CREW REPORTED LOSING ALL HYDRAULIC FLUID ON YELLOW SYSTEM. SAMC WAS CONTACTED AND SYSTEM WAS SHUT DOWN PER ECAM MESSAGE. CAPTAIN ELECTED TO CONTINUE TO DESTINATION. *S/D* O-RING BETWEEN YELLLOW ACCUM & PRESS. LINE REPLACED - RSDR 98UAL900485Mechanism · out of adjustDOOR 2L WILL NOT SECURE PROPERLY. FERRIED AIRCRAFT TO ORD FOR REPAIR. *S/D* TROUBLESHOOTING REVEALED THAT DOOR WAS OUT OF RIG. ACCOMPLISHED RIG OF DOOR UPPER AND LOWER GUIDEARMS. DOOR OPERATION NORMAL.SDR 97UAL900537Lgci · failedPASSING FL320 LGCIU 1 CIRCUIT BREAKER OPENED WITH ASSOCIATED ECAM MESSAGE. TURNED OFF GPWS IN ACCORDANCE WITH PROCEDURE. RESET LGCIU 1 C/B, IT POPPED IMMEDIATELY. DIVERTED TO IAD DUE TO LGCIU 1-2 FAILURE. LANDING GEAR GRAVITY EXTENDED. NO NOSE WHEEL STEERSDR 97UAL900219Windshield · crackedRETURNED TO IAD DUE TO CAPTAINS WINDSCREEN CRACKED ABOUT 7,000 FEET ON DEPARTURE. *S/D* REPLACED WINDSHIELD AND INSPECTED AREA FOR EVIDENCE OF FOD. NO DEFECTS NOTED AND AIRCRAFT WAS RETURNED TO SERVICE.
Back to N437UA