N814UA
Service difficulty reports · 134
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 = 'N814UA' 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 = 'N814UA' 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 CALA2015021293135Door Sill · corrodedL2 DOOR SILL FRAME 68 HAS CORROSION AROUND THE LAST TWO NUTPLATE HOLES AFT END AT DOOR SILL. REMOVED CORROSION & FABRICATED REPAIR DOUBLER & INSTALLED IAW SRM 53-41-14 PARA 5A FIG 201 REPAIR PRINCIPLE 5.SDR CALA2014101692456Battery · dischargedEMERGENCY LIGHT OPERATIONAL TEST FAILED. EPSU BATTERY AFT LT DISPLAYED AFTER TEST. RESET AFT LT EPSU BATTERY. TESTED GOOD.SDR CALA2014081891999Battery · dischargedFAILED EMER LIGHT TEST FWD FLIGHT ATTENDANT PANEL. EPSU BATTERY EMER LIGHT REPLACED BOTH LT & AFT LT BATTERIES AMM 33-51. TEST NOW OK.SDR CALA2014052791142Container · faultyDURING PASS O2 DROP CHECK FOUND O2 MASK COMPARTMENT DOOR AT DOOR 2L DID NOT RELEASE DURING TEST. R & R EMERGENCY O2 CONTAINER & GENERATOR AT DOOR 2L. OPERATIONS CHECKED GOOD AT THIS TIME.SDR CALA2014010290029Compressor Blade · damagedNICK ON FAN BLADE ENG 1. ENG 1 SNV10771 IAW MT72-007 FOR BLADES NUMBERING IAW AMM 72-31-11-200-010-B PARA 4B FOR ALLOWABLE DAMAGE LIMITS. REPLACED NR 19 FAN BLADE IAW AMM 72-31-11400-010-D13. ACCOMPLISHED VIBRATION SURVEY IAW AMM 71-00-00-700 -022, CHECKED SDR CALA2013122093830Starter · faultyAPU WON’T START AFTER 2ND ATTEMPT. TRIED CYCLING THE APU CONTROL BREAKERS, NO HELP. INLET DOOR STUCK IN THE PARTIALLY OPEN POSITION & APU IS INOPERATIVE. IAW MEL CB L41 & L42 OPENED & TAGGED. ACCOMPLISHED TSM 49-00-00-810-899 -A REPLACED APU MOTOR STARTER ISDR CALA2013122093856Torque Link · lack of lubeEXCESSIVE NOSE WHEEL VIBRATION AT 100 KTS & ABOVE UNTIL SLOWED IN WW ON TAKEOFF. LUBED NOSE WHEEL TORQUE LINKS, REPLACED ALL FOUR MLG TIRES IAW MT32-24 & OPBLM HIPPLE CORRECTED ATA.SDR CALA2013120593487Placard · unknownEMERGENCY OXYGEN CONTAINER AT ROW 10ABC NEEDS PERMANENT INSTRUCTIONS PLACARDS. NO PARTS AT MEXJL, INSTALLED INTERIM PLACARDS. INSTALLED PERMANENT DECAL.SDR CALA2013121193587Oxygen Mask · malfunctionedIAW CF270 MANUAL DROP TEST, SEATS 32DEF DID NOT DROP. IAW SERVICE TIP MT 35-002 REPACKED MASKS AT SEAT 32DEF, CHECKED OK.SDR CALA2013121193586Container · faultyIAW CF270 MANUAL DROP TEST, SEATS 24DEF DID NOT DROP. REPLACED EMERGENCY OXYGEN CONTAINER.SDR CALA2013120293335Oxygen Mask · malfunctionedIAW CF 270 MANUAL DROP TEST, SEATS 31ABC DID NOT DROP. IAW SERVICE TIP MT 35-002 REPACKED MASKS, OPERATIONS CHECKED OK.SDR CALA2013120293334Oxygen Mask · malfunctionedIAW CF270 MANUAL DROP TEST, SEATS 34DEF DID NOT DROP. IAW SERVICE TIP MT 35-002 REPACKED MASKS AT SEATS 34DEF, OPERATIONS CHECKED OK.SDR CALA2013120293333Oxygen Mask · malfunctionedIAW CF270 MANUAL DROP TEST, SEATS 34ABC DID NOT DROP. IAW SERVICE TIP MT35-002 REPACKED MASKS AT SEATS 34ABC.SDR CALA2013120293332Oxygen Mask · malfunctionedIAW CF270 MANUAL DROP TEST, SEATS 30ABC DID NOT DROP. IAW SERVICE TIP MT35-002 REPACKED MASKS, OPERATIONS CHECKED OK.SDR CALA2013120293331Container · faultyIAW CF270 MANUAL DROP TEST, SEATS 10ABC DID NOT DROP. REPLACED EMERGENCY OXY CONTAINER IAW MM.SDR CALA2013120293330Container · faultyIAW CF270 MANUAL DROP TEST, SEATS 1AB DID NOT DROP. REPLACED EMERGENCY OXY CONTAINER IAW MM 35-21-41.SDR CALA2013101692102Battery · faultyBATTERY 2 FAULT. REPLACED NR 2 BATTERY & NR 2 BCL IAW MM, ALL OPERATIONS TESTED GOOD.SDR CALA2013101592080O-Ring · leakingACCUMULATOR PRESSURE BLEEDS OFF WHEN BREAKS SET. FOUND O-RING LEAKING ON ACCUMULATOR SERVICING PORT REPLACED, OPERATIONS CHECKED GOOD ON GROUND.SDR CALA2013093091584Thermostat · faultyNR 1 ENG BLEED AMBER ON BLEED PAGE, 150C. CFDS FAULT RECORDED FAN AIR-V 9HA1 OR THERMOSTAT 7170 HM1, IAW TSM 36-11-00-810-849A. THERMOSTAT FAN AIR CTL PCN 644-0035. R & R THERMOSTAT IAW AMM, LEAK CHECKED GOOD.SDR CALA2013093091548Computer · malfunctionedELAC 1 PITCH FAULT DISPLAYED ON UPPER ECAM SCREEN. REPLACED ELAC NR 1 IAW MM 27-93-34 AFS & LAND VERIFICATION TESTED NORMAL IAW MM 22-96-00 & MM 22-97-00. AC RETURNED TO FULL CAT III CAPABILITY.SDR UALA2013071805060Oxygen Mask · unwanted deployOXYGEN MASKS ROW 8 ABC DISLODGED. SECURED OXYGEN MASKS AT ROW 8 ABC. ACCOMPLISHED CHECK IAW AMM TASK 35-23-00-710-001, CHECKED OK.SDR UALA2013042602933Seal · roughLOUD SQUEAL IN COCKPIT AT 8.0 PSI. NO CHANGE IN TONE OR VOLUME DURING DESCENT. INSPECTED CAPTAIN'S AND F/O'S WINDSHIELDS. FOUND A SECTION OF THE CAPT'S HUMP SEAL THAT HAD A ROUGH WAVINESS AT THE UPPER LEFT CORNER, REF: MT 56-005. ACCOMPLISHED INTERIM REPAISDR UALA2013041602606Nut Plate · faultyFOUND A POPPED SCREW-RIVET OUT AT THE HYD SYSTEM ACCESS PANEL ON THE A-CRAFT BELLY. SECURED SCREW WITH TAPE PER CDL SCREW LOCATION PNL 197BB IS 8 FROM THE TOP CORNER & 7 FROM THE BOTTOM CORNER LEADING EDGE NOT IN FRONT OF ANY SERVICE PANELS PER AMM 53-35-00-2SDR UALA2013032601910Seal · leakingVERY FINE HIGH PITCHED SQUEAL COMING FROM FLT DECK CEILING CABIN, ALTITUDE 7900FT. REPAIRED UPPER SECTION OF CAPT WINDOW SEAL.SDR UALA2012122707405Seal · leakingCREW REPORT: CAPTAINS FWD WINDOW HAS A PRESSURE LEAK PSI8 CAB ALT 7400FT. UPON FURTHER INVESTIGATION FOUND WINDOWS NOT TO BE LEAKING. POST'S BETWEEN FWD COCKPIT WINDOW AND SLIDING WINDOW LEAKING AT SEAM. FOUND BOTH SLIDING WINDOW SEALS WORN. FOUND L2 & R2 SDR UALA2012103106282Plate · looseF/O SEAT PEDALS ADJUSTMENT ASSEMBLY LOOSE. TRIMMED OFF LOOSE PIECES AND APPLIED SPEED TAPE AS NEEDED. REPLACED PEDAL ADJUSTMENT ASSY PER MM. REPLACED PLATE AS PER ABOVE INSTRUCTIONS.SDR UALA2012102906225Sensor · jammedFLAP HANDLE JAMMED AT FLAP 1 POSITION - TOOK SEVERAL ATTEMPTS TO GET IT TO FLAP 2, TRIGGER FLAP SLAT CONTROL LEVER AND FLAP HANDLE COMMAND SENSOR UNIT. GRND OP'S OK.SDR UALA2012080704250Power Unit · leakingYELLOW-GREEN PTU LEAKING. REPLACED GREEN-YELLOW PTU. BLED SYSTEM AND CHECKED FOR LEAKS. CHECKED OK. OPS CHECK ACCOMPLISHED ON SMC 18.SDR UALA2012011200267Warning System · activatedMAINTENANCE STATUS MESSAGE AIR BLEED DISPLAYED ON THE LOWER ECAM SCREEN.SDR UALA2011122707109Unknown · malfunctionedRT BRAKE VERY SOFT WEAK SPLIT PEDALS FOR EVEN BRAKING.SDR UALA2011111406226Computer · faultyAT LANDING GEAR DEPLOYMENT A-C ROLLED HARD LEFT. HALF CONTROL. STICK INPUT TO STOP ROLL. SAMC TEXT: *UPDATE* NO WIND OR WAKE PRESENT WHEN ROLLING MOMENT OCCURED. INBD CREW REPORTS A-S 190 KTS, FLAPS 1, SPEED BRKS FULLY EXTENDED, ROLL OCCURRED AT MOMENT GEASDR UALA2011090504781Structure · dentedDENT FOUND AFT OF DOOR 1L, DENT IS 1 INCH LONG BY 1.25 INCH LONG. SAMC TEXT: DENT IS .06 DEEP AND REF SRM IS OK FOR CONTINUED SERVICE UP TO 3000FC. PERMANENT REPAIR MUST BE ACCOMPLISHED BY PTC 20764. OK TO CF REF SRM 53-11-11. CARRIED FORWARD PER SAMC.SDR UALA2011083004655Elt · brokenELT IS BROKEN ABOVE SEAT 1EF. REPLACED ELT.SDR UALA2011082504558Actuator · faultyRAT OUT MESSAGE ON ECAM HYD PAGE APPEARED & SHOWED GREEN RAT EXTENSION THEN SHOWED NORMAL. REPLACED RAT EJECTION JACK (2454GE) IAW AMM.SDR UALA2011082204457Insulation · damagedRAT DEPLOYED INDICATION ON ECAM. VERIFIED NOT DEPLOYED. CREW COMMENT: MSG GOES ON AND OFF INTERMITTENTLY. FOUND RAT STOW SW WIRE INSULATION DAMAGE REF ASM 29-22-00 CONNECTOR C-C PIN B. RESTORED INSULATION. NO STRAND DAMAGE. RAT IND NORMAL. STOWED RAT AFSDR UALA2011081504319Oxygen Mask · faultyCAPTS O2 MASK MIC INOPERATIVE. REPLACED CAPT'S O2 MASK & O2 MASK BOX.SDR UALA2011071403568Unknown · damagedHAIL STRIKE DAMAGE.SDR UALA2011050402184Unknown · odorOIL ODOR IN CABIN. F/A THINKS IT COULD BE ASSOCIATED WITH OVERHEAD LIGHTS. OIL ODOR FROM APU, RAN ENGS NO ODOR. APU BLEED INOPERATIVE, APU USEABLE FOR ELEC. OPERATED ALL OVERHEAD LIGHTS IN FWD & AFT GALLEYS, AND CABIN CEILING LIGHTS AT MAX BRIGHT. (GROUND ESDR UALA2011021500789Rod End · faultyMODERATE TAIL VIBRATION, RTFL. VIBRATION CHECKLIST FILLED OUT BY CREW, SHOWS VERTICAL BOUNCE. FOUND PLAY AT ELEVATOR SERVO CONTROL ROD ENDS, REPLACED ELEV SERVO CONTROLS 34CE4 AND 34CE3 IAW AMM AND ROD ENDS OF SERVO CONTROLS 34CE1 AND 34CE2 IAW AMM, TESTS OKSDR UALA2011020700667Oxygen Mask · faultyCAPTAIN'S OXYGEN HARNESS FAILS TO INFLATE (IS LEAKING). CREW COMMENTS: LT SIDE RED HARNESS INFLATION TAB BROKEN. SAMC TEXT: **UPDATE** SWAP CAPT O2 MASK ASSY WITH 2ND OBS SEAT. SWAPPED CAPT O2 MASK TO 2ND OBS SEAT LOCATION. CAPTAIN'S MASK USEABLE, 2ND OBS MASKSDR UALA2011020200574Structure · damagedAFTER LOWERING FLAPS FOUND BIRDSTRIKE TO LT OTBD FLAP L/E. FLAP HARD POINTED, CONT WITH HOOKUPS, RIG-OPS CKS & TEST FLY PLAN IN PM. LAP REPLACED MOC ON W-U H8607S, IAW MM. ACCOMPLISH TEST FLIGHT FOR LT OTBD FLAP BEING REPLACED. FLAPS GOOD. LATERAL-DIRECSDR UALA2010102803974Module · faultyPAX O2 MODULE DROPPED ABOVE SEATS 14DEF. VERIFY O2 GENERATOR NOT FIRED, RESTOW MASKS AND APPLY MEL. SEATS 14DEF ARE PLACARDED INOP AND NOT TO BE OCCUPIED UNTIL DROP CHECK FOR O2 MASKS IS ACCOMPLISHED. RESTOWED MASKS IAW AMM. DROP TEST OK.SDR UALA2010102803973Seal · out of adjustMED 2R OXYGEN COMPT FAILS DROP CHECK. ADJUSTED COSMETIC SEAL ON DOOR PANEL TO PREVENT BINDING. DROP TEST OK.SDR UALA2010102803972Oxygen Mask · no testMED 2L OXYGEN COMPT FAILS DROP CHECK. ACCOMPLISHED MASK ADJUSTMENT.SDR UALA2010102803971Oxygen Mask · no testSEAT 23 D,E,F OXYGEN COMPT FAILS DROP CHECK. CORRECTLY RESTOWED MASKS, DROP TEST OK.SDR UALA2010102803970Oxygen Mask · no testAFT LT AFT LAV OXYGEN COMPT FAILS DROP CHECK. ACCOMPLISHED MASK ADJUSTMENT.SDR UALA2010102803969Oxygen Mask · misinstalledSEAT 22 A,B,C OXYGEN COMPT FAILS DROP CHECK. CORRECTLY RESTOWED MASKS, DROP TEST OK.SDR UALA2010102803968Oxygen Mask · misinstalledSEAT 12 A,B,C OXYGEN COMPT FAILS DROP CHECK. CORRECTLY RESTOWED MASKS, DROP TEST OK.SDR UALA2010102803967Hinge · brokenSEAT 1C,D OXYGEN COMPT. FAILS DROP CHECK. REPLACED CONTAINER ASSY DUE TO BROKEN HINGE, DROP TEST OKAY.SDR UALA2010042701394Slide · partial deployLT OVERWING SLIDE OUT OF CONTAINER PARTIALLY DEPLOYED. DETERMINED THAT SLIDE RAFT PARTIAL DEPLOYMENT WAS DUE TO AMT INSERTING SAFETY PIN WITH THE INFLATION RESERVOIR VALVE REGULATOR PIN HOLE MISS-ALIGNED. A SERVICEABLE SLIDE RAFT WAS PROCURED AND WAS INSTALL
Back to N814UA