N436UA
Service difficulty reports · 122
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 = 'N436UA' 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 = 'N436UA' 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 2007UALA02636Structure · corrodedFWD PIT HAS NUMEROUS CORRODED FASTENERS FROM FRAME 24B THROUGH FRAME 34 AND BETWEEN STR 38R & 38L. AREA WAS REPAIREDSDR 2007UALA02628Shear Tie · damagedSHEAR TIE AT FR 57 STR 42L IS DAMAGED. MAJOR REPAIR ACCOMPLISHED: REMOVED SHEAR TIE. FABRICATED & INSTALLED NEW SHEAR TIE.SDR 2007UALA02578Skin · dentedLEFT FUSELAGE SKIN IS DENTED 6 INCHES ABOVE AND 18 INCHES AFT OF STATIC PORT, LOCATED WITHIN RVSM AREA. MAJOR REPAIR ACCOMPLISHED: INSTALLED DOUBLER REPAIR.SDR 2007UALA02577Shear Tie · corrodedSHEAR TIE CLIP CORRODED AT FRAME 31 BETWEEN STR 40R - 41R. MAJOR REPAIR ACCOMPLISHED: REMOVED & REPLACED SHEAR TIE.SDR 2007UALA00497Connector · brokenCABIN EEL CONNECTORS HAVE BROKEN BACKSHELLS ON FLOOR BY SIDEWALL AT SEAT ROWS 6L, 7L, 15L, 18L AND 26L. [5-1-07] BACKSHELLS REPLACED.SDR 2007UALA00459Pin · bindsFWD RIGHT MED EMERGENCY EVACUATION SLIDE INFLATION BOTTLE SAFETY PIN INSERTION WAS EXTREMELY HARD. [SUP 05-16-07] FWD RT EMERGENCY SLIDE WAS REPLACED. IT WAS LATER DETERMINED THAT THE INFLATION BOTTLE REGULATOR VALVE WAS OUT OF POSITION, WHICH WAS CAUSING THSDR 2007UALA00465Hose · kinkedRIGHT OVERWING SLIDE INFLATION HOSE KINKED NEAR REGULATOR END. [SUP 05-16-07] REPLACED OVERWING SLIDE INFLATION BOTTLE. INSTALLATION ERROR FROM PREVIOUS REPLACEMENT.SDR 2006UALA01124Flapper Valve · damagedDAMAGED ASPIRATOR FLAPPER VALVES. MANUFACTURER DEFECT. REPLACED ASPIRATOR.SDR 2006UALA00990Sill · corrodedFOUND R-2 DOOR SILL HAS CORROSION FWD OF AFT GIRT BAR MOUNT. REPLACED DOOR SILL.SDR 2005UALA01473Odor · detectedSTRONG ELECTRICAL SMELL IN THE COCKPIT AND IN THE CABIN. JUST PRIOR TO SMELL, BOTH MCDU'S DUMPED ALL INFO. AFTER DESCENT, RECEIVED PITOT HEAT MSG FOR THE CAPT & F/O SIDE. ACCOMPLISHED HIGH POWER RUN BOTH ENGINES PER JET RUN-UP HANDBOOK. NO SMELLS OR SMOKE WSDR 2005UALA00656Epsu · inoperativeSEAT MOUNTED EMERGENCY LIGHTS INOP AT SEATS 12,13, 14, 18, 19 AND 20. POWER SUPPLIES LOW CHARGE, REPLACED.SDR 2005UALA00131Indication Sys · failedLOST ALL FUEL QUANTITY INDICATIONS. REVIEW OF THE POST FLIGHT REPORT RESULTED IN THE INDICATION OF BOTH THE FQIC 3QT AND FWC1 AS BEING FAULTED. FURTHER TROUBLESHOOTING ALONG WITH SOME ADDITIONAL WIRING CHECKS CONFIRMED NO DATA WAS AVAILABLE FOR CHANNEL 1A OR SDR 2001UALA02358Actuator · faultyRESERVOIR OVERHEAT DISPLAYED ON UPPER ELECTRONIC CENTRALIZED AIRCRAFT MONITORING (ECAM) SCREEN. FOUND GREEN HYDRAULIC SYSTEM PRESSURE INDICATING 2000 PSI WITH GEAR DOORS UP. DISCOVERED THAT BY OPENING THE RIGHT HAND MAIN LANDING GEAR DOOR, PRESS RETURNS TO 3SDR 2001UALA02356Actuator · faultyCREW REPORTS LANDING GEAR DOORS NOT CLOSED ELECTRONIC CENTRALIZED AIRCRAFT MONITORING (ECAM) MESSAGE AFTER TAKEOFF. FOUND GREEN HYDRAULIC SYSTEM PRESSURE INDICATING 2000 PSI WITH GEAR DOORS UP. DISCOVERED THAT BY OPENING THE RIGHT HAND MAIN LANDING GEAR DOOR,SDR 2001UALA02355Actuator · faultyELECTRONIC CENTRALIZED AIRCRAFT MONITORING (ECAM) - GREEN HYDRAULIC SYSTEM RESERVOIR OVERHEAT. FOUND GREEN HYDRAULIC SYSTEM PRESSURE INDICATING 2000 PSI WITH GEAR DOORS UP. DISCOVERED THAT BY OPENING THE RIGHT HAND MAIN LANDING GEAR DOOR, PRESS RETURNS TO 30SDR 2001UALA01964Blade · debondedUNSCHEDULED LANDING DUE TO NR 1 ENGINE COMPRESSOR STALL. *S/D* BORESCOPE INSPECTION REVEALED DAMAGED HIGH PRESSURE COMPRESSOR SIXTH STAGE BLADES AND DISBONDED RUBSTRIP, WITH ASSOCIATED DOWNSTREAM DAMAGE. REPLACED ENGINE.SDR 2001UALA00453Windshield · crackedCAPTAINS WINDSHIELD CRACKED. REPLACED CRACKED WINDSHIELD AND NR 1 WINDOW HEAT CONTROL.SDR 2001UALA00237Seal · leakingRIGHT WING AIR LEAK. SUPPLEMENTAL DATA UPDATE FOUND ENGINE BLEED AIR SUPPLY DUCT JOINT LEAK IN RIGHT HAND WING LEADING EDGE. REPLACED DETERIORATED SEAL. NO FURTHER FAULTS REPORTED.SDR 2001UALA00001Battery · inoperativeBATTERY FWD L MESSAGE WHEN TESTING THE EMERGENCY LIGHT SYSTEM FROM THE FORWARD ATTENDANT PANEL. *S/D* REPLACED BATTERY AT 1L (10WLA). SYSTEM OPERATION CHECKED NORMAL.SDR 2000UALA00386Light · inoperativeESCAPE PATH SEAT LIGHTING AT 8C LAMP INOPERATIVE. RELAMPED.SDR 97UAL900628Brake · lockedAT FL200 ECAM SHOWED MESSAGE FOR HOT BRAKES, NR 3 WAS 30 DEGREES C, NR 4 SHOWED 90 DEGREES C. LOWERED LANDING GEAR, NR 3 SHOWED 250 DEGREES C, NR 4 SHOWED 65 DEGREES C. RETRACTED GEAR. JACKED AIRCRAFT AND FOUND NR 3 BRAKE LOCKED. *S/D* BRAKE WOULD NOT ROTSDR 97UAL900171Skin · lightning strikeDIVERTED TO IAD AND LANDED UNDER AMBER ALERT DUE TO LIGHTNING STRIKE AND SMOKE IN CABIN. *S/D* LIGHTNING STRIKE CAUSED DAMAGE TO 6 RIVETS ALONG THE LEFT SIDE OF THE AIRCRAFT LOWER FUSELAGE. RIVETS WERE REPLACED WITH NO OTHER DAMAGE BEING DETECTED.
Back to N436UA