N843UA
Service difficulty reports · 85
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 = 'N843UA' 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 = 'N843UA' 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 UALA2012072704088Skin · damagedLEFT LOWER FUSELAGE SKIN HAS TWO LIGHTNING STRIKES FRAME 28 BETWEEN S36L-S37L AND FRAMES 28-29, S37L. REMOVED BLIND RIVETS 2 EA PER SRM. ACCOMPLISHED HFEC ON OPEN HOLES PER NTM 51-10-01 PB 6, NO DEFECTS NOTED. INSTALLED SOLID FASTENERS PER SRM AND MT 53-021SDR UALA2012072704087Skin · damagedLT LOWER FUSELAGE SKIN HAS TWO LIGHTNING STRIKE BETWEEN FRAME 23-24 AT S32L AND AT FRAME 25, S35L-S36L. REPLACED BLIND RIVETS 2 EA WITH SOLID FASTENERS PER SRM AND MT53-021. ACCOMP HFEC ON OPEN HOLES PER NTM 51-10-01 PB 6 NO DEFECTS NOTED.SDR UALA2012072704086Skin · damagedLEFT LOWER FUSELAGE SKIN HAS FOUR LIGHTNING STRIKES BETWEEN FRAMES 27-28, S35L. REMOVED BLIND RIVETS 4 EA PER SRM. ACCOMPLISHED HFEC ON OPEN HOLES PER NTM 51-10-01 PB 6, NO DEFECTS NOTED. INSTALLED SOLID RIVETS PER SRM AND MT 53-021. TOP COATED PER SRM 51-SDR UALA2012072704085Skin · damagedLEFT LOWER FUSELAGE SKIN HAS TWO LIGHTNING STRIKES BETWWWN FRAMES 25-26, S35L AND BETWEEN FRAMES 26-27, S34L-S35L. REMOVED BLIND RIVETS 2 EA PER SRM.SDR UALA2012072704084Skin · damagedLEFT LOWER FUSELAGE SKIN HAS THREE LIGHTNING STRIKES BETWEEN FRAMES 17-20, S36L AND S37L. REMOVED BLIND RIVETS 3 EA PER SRM. ACCOMPLISHED HFEC ON OPEN HOLES PER NTM 51-10-01 PB 6, NO DEFECTS NOTED. INSTALLED SOLID RIVETS PER SRM AND MT 53-021. TOP COATED PSDR UALA2012072704083Skin · damagedLEFT LOWER FUSELAGE SKIN HAS TWO LIGHTNING STRIKES BETWEEN S37-S38L, BETWEEN FRAME 11-12 AND BETWEEN S37L-S38L. REMOVED BLIND RIVETS PER SRM. ACCOMPLISHED HFEC OF THE OPEN HOLES PER NTM 51-10-01 PB 6, NO DEFECTS NOTED. INSTALLED SOLID RIVETS PER SRM. TOP CSDR UALA2012072604059Skin · damagedLEFT LWR FUSELAGE SKIN HAS LIGHTNING STRIKES (3EA) BETWEEN FRAMES 21 AND 24 S34L AND S35L.SDR UALA2011091204917Wire · defectiveENG 1 OIL QUANTITY INDICATION INOP ON ENG ECAM SYSTEM PAGE. OIL PRESSURE AND TEMP NORMAL. - ENG 1 SAMC TEXT: CREW REPORTS: ENG 1 OIL QTY IND JUMPING FROM 2 TO 12. 5 FLASHING ALL OTHER ENG IND NORMAL. REVIEW HIST. OPBLM EMC ARSH AD. 09SEP11. CHECKED OIL LEVSDR UALA2011071703624Tire · damagedEXCESSIVE NOSE WHEEL SHIMMY ON TAKEOFF AND AFTER ROTATION. REPLACED BOTH NOSE TIRES IAW AMM. FOUND ONE TIRE WITH FLAT SPOTS.SDR UALA2011070703370Computer · faultyENG 1 OIL QUANTITY INDICATION INOP ON ENG ECAM SYSTEM PAGE. OIL PRESSURE AND TEMP NORMAL ENG 1. REPLACED OIL QUANTITY TRANSMITTER. RPLC XMTR DID NOT CORRECT PROBLEM. CHECKED WIRING REF WDM79- 36-01. NO FAULTS FOUND WHILE SHAKING WIRES INSPECTED TB 1851VT SDR UALA2011061702977Valve · faultedB-SYSTEM HYD FAILURE, RTFL. GREEN HYD SYS FLUID LOSS. HYD G RSVR LO LVL ECAM DISPLAYED. REPLACED PTU PER AMM. SUSPECT INTERNAL BY-PASSING CAUSING THE COLLECTOR TO OVERFLOW CAUSING LOSS OF GREEN SYSTEM HYDRAULIC FLUID. ALSO REPLACED NORMAL BRAKE SERVO VALVE PESDR UALA2010112404348Skin · damagedSCRATCH WITH DENT ON RT SIDE OF FUSELAGE APPROX 6 INCHES AFT OF RADOME ABOVE ORANGE STRIPE WITHIN RVSM BOX AREA PER RAMP. REWORKED ALLOWABLE DAMAGE USING MM53-11-11, MM53-00-11, MM51-73-00, MM51-75-12.SDR UALA2010110304068Eiu · malfunctionedNR 2 ENG LOW OIL, RTFL CHECKED WIRING NO FAULTS FOUND. REPLACED NR 2 EIU. RAN ENGINES. CHECKS OKAY.SDR UALA2010082303092Relay · inoperativeEMERGENCY GENERATOR TEST FAILURE. REPLACED RELAY 30XE CHANGED FOR TROUBLESHOOTING. EMERGENCY GEN SYS STILL INOPERATIVE. AC ESS BUS CONTACTOR 15XE REPLACED FOR TROUBLESHOOTING EMERG GEN TEST FAILURE SYS STILL FAILS TEST. CONTACTOR WILL REQUIRE EMERG GEN TEST ASDR UALA2010080602855Connector · brokenEMERGENCY LIGHT ON SEAT 16C DOES NOT LIGHT WHEN TESTED. FOUND WIRE BROKEN AT CONNECTOR SEAT SIDE. REPAIRED WIRE AT EMERGENCY LIGHT CONNECTOR, OPS TESTED OKAY.SDR UALA2010062102168Slide · debondedLT OVERWING SLIDE PANEL 194AT AFT EDGE HAS AN AREA 11 INCHES BY 1 INCH DISBONDING. REPLACED LT OFFWING SLIDE.SDR UALA2010062102165Slide · unserviceableRT OFFWING SLIDE IS UNSERVICEABLE. REPLACED RT OFFWING SLIDE.SDR UALA2009062401796Bleed Air Sys · fluctuatesENGINE 1 BLEED PRESSURE FLUCTUATES - BLEED. ENG 1 BLEED FLUX 14-36 PSI. CRZ FL380 FLUX STARTS BELOW 1.3 EPR. CAUSES PACK SURGE.SDR UALA2009061501710Drain Line · leakingWATER LEAK. FLIGHT DIVERTED. FWD GALLEY DRAIN CLOGGED. DRAINING ONTO GALLEY FLOOR. CLEARED OBSTRUCTION AND WORKS NORMAL.SDR UALA2009033000925Oxygen Mask · leakingRT OXY MASK COMPART, AFT POSITION MASK HOSE CONNECTION TO REGULATOR IS LEAKING WHEN LIGHTLY TOUCHED. REPLACED MASK, NO LEAKS. OPS CHECK GOOD.SDR UALA2009022500642Skin · puncturedPUNCTURE HOLE IN FUSELAGE JUST FWD AND BELOW DOOR 1L. MAJOR REPAIR ACCOMPLISHED. FABBED REPAIR DOUBLER, TREATED & PRIMED AND INSTALLED REPAIR DOUBLER FWD OF L1 DOOR LWR.SDR UALA2009010200002Wire · chafedNR1 ENG FIRE LOOP MESSAGE ON CLIMB. FOUND CHAFED WIRE AT 12 O'CLOCK POSITION BY PRSOV. LOOP WIRE WAS REPLACED AND SECURED. REINSTALLED AND OPS NORMAL.SDR UALA2008121606908Battery · dischargedTHREE SVC EMER LIGHTS TEST FAILS. REPLACED EMERGENCY LIGHTS BATTERIES AT DOOR 1L AND L OVERWING POSITIONS. EMERGENCY LIGHTS TEST NOW PASSES.SDR 2007UALA04768Skin · damagedPUNCTURE HOLE IN SKIN JUST FWD AND BELOW DOOR 1L. REMOVED DAMAGED AREA AND PERFORMED HFEC AROUND CUTOUT, NO CRACKS NOTED. PERFORMED A TEMP REPAIR, PERMANENT REPAIR TO BE INSTALLED WITHIN 3000 FH.SDR 2007UALA03506Stringer Splice · corrodedAFT STRINGER SPLICE IS CORRODED AT FR 51 ON STR 43L. MAJOR REPAIR ACCOMPLISHED. REPLACED STRINGER SPLICE.SDR 2007UALA02797Check Valve · failedUNWANTED FUEL TRANSFER FROM RT WING TO CTR TANK. TRANSFER RATE APPROX 500 LBS PER HOUR. CENTER BOOST PUMP CHECK VALVE LEAKING FUEL. REPLACED CENTER BOOST PUMP CHECK VALVE.SDR 2007UALA01162Battery · no testPTP PANEL KEPT GETTING EPSU BATTERY EMER L MESSAGE. SUPPLEMENTAL DATA UPDATE RESET EMERGENCY LIGHT BREAKERS. TEST PASSED ON PTP PANEL.SDR 2007UALA00571Unknown · vibrationLITE LATERAL VIBRATION - NOISE ENCOUNTERED IN CLIMB AND AT FL360. [SUP 05-16-07] PERFORMED A RUDDER FREEPLAY CHECK AFTER LANDING AND FOUND ALL THREE RUDDER ACTUATOR ROD ENDS WORN BEYOND LIMITS. REPLACED ALL RUDDER ACTUATOR ROD ENDS.SDR 2007UALA00384Unknown · odorELECTRICAL ODOR IN FLIGHT DECK WITH NO ECAM MESSAGE AT FL350. TURNED CABIN FANS OFF. ODOR WENT AWAY. [SUP 05-08-07] DETERMINED THAT LEFT RECIRC FAN WAS SOURCE OF ELECTRICAL ODOR AND WAS REPLACED. FURTHER DIAGNOSTICS FOUND THAT THE STATOR WAS DAMAGED DUE TOSDR 2006UALA01262Warning System · activatedDIVERTED DUE TO ELAC 2 PITCH FAULT MESSAGE. REPLACED PITCH TRIM ACTUATOR PER AMM 27-44-57 AND SYSTEM CHECKED OK PER AMM 27-41-00-730-001.SDR 2006UALA01203Battery Pack · inoperativeEMERGENCY LIGHT CHECK FOR 3 SERVICE WILL NOT PASS. REPLACED EMERGENCY BATTERY PACK AT 13WL AND 11WL. EMERGENCY LIGHT SYSTEM CHECKS OK.SDR 2006UALA00066Light · faultyEMERGENCY LIGHTS FAILED 3SV TEST. FAILED *EPSU BATTERY AFT L*.SDR 2005UALA01178Skin · damagedLEFT EXTERNAL FUSELAGE SKIN & STRINGER AFT OF STA 897 FRAME 23 BETWEEN STR 22L & 23L IS DAMAGED. MAJOR REPAIR ACP ON LH EXTERNAL FUSELAGE SKIN AFT OF STA 897 FR 23 BETWEEN STR 22L AND 23LH PER SRM 53-00-11 FIG 220.SDR 2005UALA00730Pin · bentCREW REPORTED R ENGINE OVERTEMP. THE 2.5 BLEED VALVE MASTER ACTUATOR WAS FOUND TO HAVE A BENT CONNECTOR PIN. THIS DEFECT LEAD TO THE 2.5 BLEED VALVE BEING INTERMITTENTLY SET TO THE FAIL-SAFE (OPEN) POSITION LEADING TO AN EGT OVER-TEMP.SDR 2001UALA01995Skin · damagedFUSELAGE SKIN DAMAGED FWD OF APU COMPARTMENT AFT OF FRAME 76, STRINGER 30. MAJOR REPAIR ACCOMPLISHED. INSTALLED DOUBLER.
Back to N843UA