N449UA
Service difficulty reports · 150
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 = 'N449UA' 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 = 'N449UA' 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 UALA2012060303061Oxygen Mask · unwanted deploy32ABC O2 MASK DEPLOYED ON LANDING. STOWED DROPPED MASKS AT LOCATION 32ABC.SDR UALA2012051002687Dome Nut · missingRIVET AND BOLT MISSING 3 AND 4TH BRACKET AFT FWD CARGO DOOR LATCH. REPAIRED MISSING DOME NUT PER MT-53-014.SDR UALA2012040902181Starter · failedON NR 1 ENGINE START UP, GROUND CREW NOTICED SPARKS UNDER FAN COWL. FLT CREW NOTICED NO INDICATIONS. R & R NR 1 ENGINE STARTER PER MM, OPS CHECKED NORMAL WITH NORMAL ENGINE START AND RUN.SDR UALA2011120806737Turbine Blades · damagedAPU 2ND STAGE TURBINE BLADES HAVE SEVERE BLADE TIP DAMAGE. REPLACED APU.SDR UALA2011120706731Turbine Blades · damagedAPU AUTOSHUTDOWN UNDER BOOST CONDITIONS. APU 2ND STAGE TURBINE BLADES HAS SEVERE BLADE TIP DAMAGE. REPLACING APU.SDR UALA2011111106163Structure · wornREF DAMAGED BULKHEAD CONNECTOR, SMC7. IPC SHOWS A DOTTED CUTOUT OF STRUCTURE FOR ATTACHMENT OF CONNECTOR. ITEMS 135 AND 120 ARE USED TO SECURE CONNECTOR. THE STRUCTURE IS WORN AWAY. THERE IS NOTHING TO ATTACH TO. REMOVED 1 EA FWD HI-LOKS IN FUEL TANK. PSDR UALA2011110906108Hydraulic Line · leakingGREEN SYS HYD LOSS, FLIGHT DIVERTED. ACCOMPLISHED A MANUAL GEAR EXTENSION. AFT HYD PRESS LINE IN NR 1 PYLON REMOVED DUE TO HOLE WORN IN LINE UNDER AFT CLAMP. INSTALLED HYD LINE AND SECURED FRONT BULKHEAD FITTING, B-NUT AND MOST FORWARD CLAMP ASSY. FWD B-NUT SDR UALA2011072703831Rod End · looseON LANDING RUDDER FAILED TO RESPOND TO RUDDER PEDAL INPUTS-UNABLE TO EVEN TEST RUDDER. FOUND BOLT MISSING AT ROD END FOR MECHANICAL INPUT. INSTALLED NEW BOLT NUT WASHER PIN REF MM. RUDDER OPS CHECK OKAY. ALSO ALL MISSING HARDWARE HAS BEEN ACCOUNTED FOR.SDR UALA2011070703372Computer · faultyELAC 1 PITCH FAULT DISPLAYED ON UPPER ECAM SCREEN - F-CTL. ELAC NR 1 INOP: COMPLETED TESTS FOR 'ELAC PITCH' FAULT. CHECKS REQUESTED BY MEL OK. PFR FAULT: 'ELAC1-COM OR WIRING TO R B ELEV SERVO VLV 34CE4'. REPLACED ELAC 1 COMPUTER PER MM TASK.SDR UALA2011062703138Unknown · unknownAVIONICS SYS FAULT DISPLAYED ON UPPER ECAM SCREEN. CYCLED CIRCUIT BREAKER. ACCOMPLISHED TEST OF AVIONICS SYSTEM PER MM, TESTS OKAY.SDR UALA2010092803577Actuator · failedWHILE ACCOMPLISHING LM6185, O2 SAFETY PIN CK, O2 COMPARTMENT DOOR AT SEATS 8DEF FAILED TO OPEN, MASKS NOT DEPLOYED. REPLACED DOOR ACTUATOR, OPS CKS GOOD.SDR UALA2010081703012Smoke Detector · false activationIAW CREW, AFT CARGO SMOKE DETECTOR DETECTED SMOKE HAD ALL THE BELLS AND INDICATIONS. BOTTLE BLEW FOR AGENT 1. BOTTLE BLEW FOR AGENT 1. REPLACED NR1 BOTTLE. REPLACED SDCU PRECAUTIONARY (RAI2800M0403 - SN 61), OP CKS NORMAL. REPLACED AFT PIT SMOKE DET 3WH, 4SDR UALA2010081602977Smoke Detector · activatedAFT CARGO SMOKE DETECTOR DETECTED SMOKE HAD ALL THE BELLS AND INDICATION. BOTTLE BLEW FOR AGENT 1. DOOR 1 RIGHT EMERGENCY ESCAPE SLIDE DEPLOYED. REPLACED DOOR 1R ESCAPE SLIDE. REPLACED AFT PIT SMOKE DET 3WH, 4WH, 5WH, 6WH. COMPLETED OP CK OF DETECTORS. ASDR UALA2010040501109Stringer · chafedAFT PIT BILGE STRINGER 39R BETWEEN FRAMES 47 & 48 CHAFED BY HYD LINE. REPAIRED IAW SRM. IDENTIFIED REPAIR WITH PERMANENT MARKER, WORK ACP ON WU B7287V.SDR UALA2010032601016Skin · dentedFOUND DENT AFT OF NR 1 LT DOOR IN LINE WITH BOTTOM OF DOOR. MAJOR REPAIR ACCOMPLISHED: CUTOUT DAMAGED AREA. HFEC INSP VERIFIED DAMAGED REMOVED. INSTALLED DOUBLER REPAIR.SDR UALA2009110903504Cylinder · leakingDOOR 1R EMERGENCY ASSIST BOTTLE PRESSURE LOW. DUE TO HISTORY OF CYLINDER LEAKAGE REPLACED DOOR DAMPER EMERGENCY CYLINDER 1R.SDR UALA2009092102969Connector · inoperativeEMERGENCY LIGHT AT SEAT 23C IS INOPERATIVE. REPLACED LIGHT ASSY, NO HELP. FOUND CONNECTOR LOOSE AT MUX BOX. SECURED, OPS CHECKED GOOD.SDR UALA2009082402600Controller · malfunctionedLOSS OF BOTH PACKS. RTFL. NR 2 PACK BYPASS VALVE POSITION INDICATION INOP ON BLEED SYSTEM ECAM PAGES - BLEED. PFR FAILURE MSG P2 CONT. TEMP CTL. CONFIRMED PACK CONTROLLER 2. RPLC'D AND OP CHECKED GOOD. RAN PACKS NORMAL INDICATIONS. DURING NEXT CYCLE NR 2 PASDR UALA2009052101450Unknown · odorBURNING RUBBER ODOR REPORTED VICINITY OF ROW 12 WHILE ON APPROACH. INVESTIGATE AND CONTACT SAMC. ODOR DISSIPATED ON APPROACH. CHECKED CABIN AREAS FOR WIRE FAULTS, NONE SEEN. ODOR GONE BY THE TIME PASSENGERS FINISHED OFF, LOADING.SDR UALA2008111306295Seal · defectiveNR 1 ENGINE REPORTED FIRE IN TAIL PIPE AFTER SHUTDOWN. SUSPECT OIL LEAK AS SOURCE OF IGNITION. REPLACED NR 1 ENGINE. REPLACED SEAL NR 5 BEARING/ASSY. REPLACED NR 5 BEARING COMPARTMENT PULLER/COVER.SDR 2008UALA06295Engine · fireNR 1 ENG - FIRE IN TAIL PIPE AFTER SHUTDOWN. SUSPECT OIL LEAK.SDR 2008UALA05695Bottle · lowSLIDE 1R DOOR PRESSURE LOW READS 1550. SERVICED DOOR ASSIST BOTTLE PRESSURE TO WITHIN LIMITS.
SDR 2008UALA03891Pan · damagedEXCESSIVE MATERIAL REMOVED FROM DOOR 2L DOOR SILL PAN AFT END AT 2EA NUT PLATE HOLES. *S/D* ACCOMPLISHED MAJOR REPAIR AT DEN. REMOVED DAMAGE MATERIAL, FABRICATED REPAIR PARTS.
SDR 2008UALA03903Pan · damagedEXCESSIVE MATERIAL REMOVED FROM DOOR 2L DOOR SILL PAN AFT END AT 2EA NUT PLATE HOLES REF SMC 28. *S/D* ACCOMPLISHED MAJOR REPAIR AT DEN. REMOVED DAMAGE MATERIAL, FABRICATED REPAIR PARTS, AND INSTALLED.SDR 2008UALA03902Floorbeam · corrodedFOUND FLOORBEAM 235 CORRODED REF EQ3700. *S/D* ACCOMPLISHED MAJOR REPAIR AT DEN. REMOVED BEAM, ON WORKBENCH. INSTALLED SPLICE ON BEAM AND PAINTED. INSTALLED BEAM.SDR 2008UALA03901Beam · corrodedFOUND BEAM 230 CORRODED REF EQ3700. *S/D* ACCOMPLISHED MAJOR REPAIR AT DEN. REMOVED BEAM, PREPPED AND RE-INSTALLED.SDR 2008UALA03900Beam · corrodedFOUND BEAM 210 CORRODED REF EQ3700. *S/D* ACCOMPLISHED MAJOR REPAIR AT DEN. REMOVED BEAM, PREPPED AND RE-INSTALLED.SDR 2008UALA03899Beam · corrodedFOUND BEAM NR 175 CORRODED REF EQ3700 B. *S/D* ACCOMPLISHED MAJOR REPAIR AT DEN. REMOVED BEAM, PREPPED AND RE-INSTALLED.SDR 2008UALA03898Beam · corrodedFOUND BEAM 205 CORRODED REF EQ3700. *S/D* ACCOMPLISHED MAJOR REPAIR AT DEN. REMOVED BEAM, PREPPED AND RE-INSTALLED.SDR 2008UALA03897Beam · corrodedFOUND BEAM NR 200 CORRODED REF EQ3700. *S/D* ACCOMPLISHED MAJOR REPAIR AT DEN. REMOVED BEAM, PREPPED AND RE-INSTALLED.SDR 2008UALA03895Shear Plate · corrodedFOUND RT SHEAR PLATE CORRODED BETWEEN FRAME 69 AND 70 REF EQ3700. *S/D* ACCOMPLISHED MAJOR REPAIR AT DEN. REMOVED SHEAR PLATE, INSTALLED SAME NEW.SDR 2008UALA03289Unknown · vibrationGEAR VIBRATION AFTER LIFT OFF UNTIL GEAR HANDLED RAISED.SDR 2008UALA02512Oxygen System · reads lowOXYGEN PRESSURE LOW.SDR 2008UALA01951Control Unit · illuminatedDISCH AGENT 2 LIGHT ILLUMINATED ON CARGO SMOKE PANEL. CAUSE, SCDU FAILURE, UNKNOWN CAUSE. REPLACED SCDU, GROUND TESTS WERE NORMAL.SDR 2008UALA01609Thrust Reverser · damagedNR 1 ENGINE LT REVERSER DAMAGED. UNKNOWN A/C DAMAGE. PERFORMED PERMANENT REPAIR ON REVERSER HALF (COMPOSITE).SDR 2008UALA00719Unknown · unknownDEBRIEFED WITH FLT CREW, CAPT WAS FLYING AIRCRAFT AND AT TOUCH DOWN (MAIN LANDING GEAR WAS ON RUNWAY) CAPT RELAXED STICK TO NEUTRAL AND THEN AIRCRAFT NOSE AGGRESSIVELY PITCHED UP. UNKNOWN (UNABLE TO DUPLICATE- POST FLIGHT). NO INFO ON PFR, NO HISTORY ON PREVSDR 2007UALA04724Seat · looseROW 9ABC SEATS CAME OUT OF ATTACHMENT TRACK ON TAKEOFF. SEAT ROW 9ABC RE-SECURED.SDR 2007UALA03321Battery Pack · faultyEPSU BATT EMER L FOUND WHEN TESTED. FOUND FAULTY BATTERY PACK. REPLACED BATTERY PACK.SDR 2007UALA03105Battery · dischargedEMERGENCY LIGHT SYSTEM FAILED TO TEST. EPSU BATTERY FAILURE. REPLACED FAULTY BATTERY.SDR 2007UALA02642Bottle · lowEMERGENCY SLIDE HAS LOW BOTTLE PRESSURE. REPLACED SLIDE ASSY.SDR 2007UALA00543Light · faultyFOUND DOOR EMERGENCY EXIT LIGHT ON AND WILL NOT EXTINGUISH. [5-1-07] REMOVED AND RESEATED CAM AND ACPD CFDS TEST. LIGHTS ARE EXTINGUISHED & TEST PASSED.SDR 2007UALA00365Battery Pack · dischargedEMERGENCY LIGHTS INOP AT DOOR 1L AND 1R, SEATS ROW 1, 2 AND 3 ABC. REPLACED BATTERY PACK AT DOOR 1L.SDR 2006UALA01449Connector · faultyFOUND CABIN EMERGENCY LIGHT FAILED, EPSU COMM AFT LEFT. RESEATED THE AFT EMERGENCY LIGHT BATTERY PACK CONNECTOR. ACCOMPLISHED EMERGENCY LIGHT SYSTEM TEST ON CIDS PANEL. TEST PASSED, NO FAULT MESSAGES SHOWN.SDR 2006UALA01320Power Supply · failed11WL EPSU FAILED OPS CK. REPLACED EPSU 11WL. OPS CHECKED OK.SDR 2006UALA00586Window · crackedRETURN TO FIELD DUE TO A CRACKED FLIGHT DECK WINDOW. SHOP FINDINGS INDICATE FOD DAMAGE. REPLACED WINDSHIELD.SDR 2004UALA01169Fitting · stuckDOOR 1L AFT GIRT BAR ATTACH FITTING IS STUCK OPEN AND WILL NOT SPRING BACK TO CLOSED OR LOCKED POSITION. REMOVED DEBRIS TRAPPED IN THE INTERFACE AND LUBED GIRT BAR.SDR 2004UALA00196Seal · failedDURING APPROACH WINDSHIELD CRACKED AND BEGAN TO ARC. WEATHER SEAL DETERIORATION LED TO DELAMINATION OF WINDOW ALLOWING WATER INGRESION CAUSING ARCING AT THE BUS BAR AND HEAT FILM RESULTING IN CRACKING OF THE WINDSHIELD. THE WINDSHIELD WAS REPLACED.SDR 2003UALA00123Fan · inoperativeVIBRATION FELT UNDER FORWARD GALLEY FLOOR AND FLIGHT DECK AND SMOKE ODOR IN FLIGHT DECK. REPLACED AVIONICS BLOWER FAN (18HQ).SDR 2000UALA00293Connector · dirtyCREW REPORTS WEATHER RADAR WILL NOT PAINT VISIBLE PRECIPITATION. *S/D* FOUND A FAULT ON THE RADAR RT UNIT. PULLED UNIT AND FOUND DUST ON RACK CONNECTOR. CLEANED RACK CONNECTOR AND THEN REINSTALLED UNIT. PERFORMED GROUND OPERATIONAL CHECK AND VERIFIED SYSTSDR 98UAL900508Slide · malfunctionedDOOR 1L SLIDE DEPLOYED AFTER ARRIVAL AT GATE. *S/D* FLIGHT CREW ACCIDENTALLY DEPLOYED THE SLIDE UPON ARRIVAL. SLIDE WAS REPLACED PER MM 40-25-62-44.
Back to N449UA