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 CALA2016090195709Shear Tie · corrodedFWD CARGO AT FRAME 33 BETWEEN STRINGERS 40 & 41R SHEAR TIE HAS CORROSION. REMOVED & REPLACED THE SHEAR TIE IAW SRM51-42-11.SDR CALA2016090195708Shear Tie · corrodedFWD CARGO BAY AT FRAME 33 BETWEEN STRINGER 41 & 42R SHEAR TIE HAS CORROSION. REMOVED AND REPLACED THE SHEAR TIE IAW SRM51-42-11.SDR CALA2016090195704Shear Tie · crackedFWD CARGO FRAME 29, STRINGER 43R - 43L SHEAR TIE HAS A CRACK. INSTALLED A NEW SHEAR TIE IAW SRM 51-44-11, SRM 51-42-11, AND SRM 53-21-12.SDR CALA2016090195703Stringer · corrodedFWD CARGO STRINGER 41R BETWEEN FRAMES 31 & 32 HAS CORROSION. REPLACED THE STRINGER IAW SRM 51-42-11.SDR CALA2016090195702Frame · corrodedFWD CARGO AT FRAME 32 BETWEEN STRINGERS 43L AND 43R HAS CORROSION ON THE SHEAR TIE. REPLACED THE SHEAR TIE IAW SRM 51-42-11.SDR CALA2016083095696Shear Tie · corrodedFWD CARGO BAY FRAME 32, STRINGERS 41 - 42R HAS CORROSION ON SHEAR TIE. INSTALLED NEW SHEAR TIE IAW SRM 53-21-12, AND SRM 51-72-11.SDR CALA2016083095695Shear Tie · corrodedFWD CARGO BAY AT FRAME 32, STRINGERS 42-43R, CORROSION ON SHEAR TIE. INSTALLED NEW A SHEAR TIE IAW SRM 53-21-12, AND SRM 51-72-11.SDR CALA2016083095694Shear Tie · corrodedFWD CARGO BAY, SHEAR TIE CORRODED FRAME 30, STRINGERS 41 & 42R, REPLACED THE SHEAR TIE IAW SRM 51-42-11.SDR CALA2016083095692Shear Tie · corrodedFWD CARGO BAY FRAME 28, STRINGERS 42 - 43R, SHEAR TIE HAS CORROSION. INSTALLED A NEW SHEAR TIE IAW SRMSDR CALA2016082695684Cleat · corrodedFWD CARGO AT FRAME 28 BETWEEN STRINGERS 42-43R HAS CORROSION ON CLEAT. INSTALLED NEW CLEAT IAW SRM 53--21-12, AND SRM 51-42-11.SDR CALA2016082695683Cleat · corrodedCORROSION ON CLEAT, FRAME 28, STRINGERS 43R-43L. INSTALLED NEW CLEAT IAW SRM 53-21-12, AND SRM 51-21-12.SDR CALA2016082695680Shear Tie · corrodedFWD CARGO, CORROSION ON SHEAR TIE AT FRAME 31, BETWEEN STRINGERS 40-42R. INSTALLED NEW SHEAR TIE IAW SRM 53-21-12, AND SRM 51-73-00.SDR CALA2016082695679Shear Tie · corrodedFWD CARGO AT FRAME 29, BETWEEN STRINGERS 42-43L SHEAR TIE HAS CORROSION. INSTALLED A NEW SHEAR TIE IAW SRM 51-42-11, AND SRM 53-21-12.SDR CALA2016082395667Door Sill · corrodedR2 DOOR SILL CORRODED AT FRAME 68. REMOVED AND REPLACED THE DOOR SILL IAW SRM 51-72-11.SDR CALA2016082395672Door Sill · corrodedAFT CARGO DOORWAY INNER SILL WEB CORRODED, FR52-F R56. REMOVED DAMAGED WEB. INSTALLED NEW INNER SILL WEB IAW A320 SRM 51-42-11.SDR CALA2016082395671Stringer · corrodedCORROSION ON STRINGER 43L, FRAMES 57 - 58. INSTALLED A NEW STRINGER,SPLICE, & CLEATS IAW SRM 51-42-11.SDR CALA2016082395670Cleat · damagedCLEAT HAS OUT OF ROUND HOLES AT FRAME 67, STRINGERS 23 - 27R. MANUFACTURED A NEW CLEAT IAW DWG D53480076 AND INSTALLED IAW SRM 51-42-11.SDR CALA2016082395669Cleat · corrodedCLEAT CORRODED AT FRAME 31 BETWEEN STRINGERS 43L & 43R. INSTALLED A NEW CLEAT IAW SRM 51-42-11.SDR CALA2016082395668Frame · damagedFRAME 67 HAS OUT OF ROUND HOLES AT STRINGERS 23 - 32R. INSTALLED A NEW FRAME AND SPLICE IAW SRM 51-72-11, & 51-42-11.SDR CALA2015092594401Controller · malfunctionedCAPTAIN PITOT ECAM WARNING WITH SMOKE SMELL IN COCKPIT & CABIN. REPLACED CAPTAINS PROBE HEAT CONTROLLER IAW AMM 30-31-34. OPERATIONS CHECKED GOOD, NORMAL ON HIGH HEAT, NO SMOKE SMELL, CB REMAINS CLOSED.SDR CALA2015010992916Door Sill · corrodedR2 DOOR SILL HAS LIGHT CORROSION ON FRAME 66R - 68 FWD EDGE. REMOVED CORROSION ON DOOR SILL & FOUND OUT OF LIMITS. FABRICATED REPAIR 2 REPAIR ANGLES & INSTALLED IAW SRM 53-41-14 PARA 5A REPAIR PRINCIPLE 9.SDR CALA2015010992931Skin Panel · damagedRIGHT ELEVATOR UPPER SKIN PANEL HAS TRAPPED WATER INDICATION AT THE FOLLOWING LOCATIONS: 27 INCHES FROM INBD, 28 INCHES FROM TE, 2 INCHES DIAMETER: 17 INCHES FROM INBD, 26 INCHES FROM TE, 2.5 INCHES DIAMETER: 12 INCHES FROM INBD, 8 INCHES FROM TE, 25 INCHESSDR CALA2015010992930Skin Panel · damagedLEFT ELEVATOR UPPER SKIN PANEL HAS TRAPPED WATER INDICATIONS AT THE FOLLOWING LOCATIONS: 82 INCHES FROM INBD, 5 INCHES FROM TE, 3.5 INCHES X 3 INCHES, 170 INCHES FROM INBD, 13 INCHES FROM TE, 2.5 INCHES DIAMETER 27 INCHES FROM INBD, 29 INCHES FROM TE, 1.5 X 2 SDR CALA2014011490140Oxygen Mask · unsecureO2 MASKS FELL 11 ABC, IAW MT35-003 FOR DROP CHECK WITHIN 3 DAYS.SDR CALA2014010290003Skin · damagedRVSM DAMAGE, SKIN WAVINESS EXCEEDS RVSM TOLERANCES, BUT WITHIN STANDARDS FOR SAFE FLIGHT IAW SRM. AIRCRAFT IS NON RVSM COMPLIANT CONDITION UNTIL IS REPAIRED OR CORRECTED IAW SRM 53-11-11. IAW SEQ 6672002, DAMAGE IS WITHIN LIMITS, REQUIRES RII INSPECTION TO CSDR CALA2013122793968Probe · defectiveFUEL QUANTITY INDICATION. RT OTBD INOPERATIVE ON FUEL SYS ECAM PAGE. FUEL CREW COMMENTS, XX DISPLAYED. REPLACED RT TANK FUEL PROBE 24QT2 IAW MM28-42-15 & RT TANK CADESICON 19QT2 IAW MM28-42-16.SDR CALA2013121893775Door Seal · dirtyDOOR SQUEAL 2L CLIMB OUT TO 31000 FT. CLEANED SEAL & DOOR SILL AREA. PRESSURIZED AIRCRAFT IAW JRH 2-40-80 TO 4 PSI, NO SQUEAL NOTED.SDR CALA2013091891261Battery · faultedFOUND EPSU BATTERY EMERGENCY R FAULT WHILE PERFORMING 2 SVC.SDR CALA2013090991120Cover Plate · out of adjustDOOR 2R REPEAT LEAK SQUEAL NOISE DURING CLIMB. NO NOISE AT CRZ FL330. DOOR COVER PLATE FOUND TO BE OUT OF ADJUSTMENT. ADJUSTED IAW MANUAL. A-C OK FOR SERVICE.SDR CALA2013090590999Sill · damagedDOOR 2R SQUEALS DURING CLIMB & DESCENT STOPS AT CRUISE. FOUND 2 LEAK PATHS IN THE MIDDLE SILL PLATE ON THE OUTSIDE EDGE. SILL EDGE IN CABIN HAS SEALANT LOOSE & TAPED. REPLACED SILL PLATE AT DOOR 2R. NO OTHER LEAKS NOTED.SDR CALA2013080690179Jack · missingF/O BOOM MICROPHONE RECEPTACLE MISSING. SECURED F/O MICROPHONE JACK ASSY, CHECKED OK.SDR UALA2013072605246Seal · obstructedL2 DOOR HAS AUDIBLE SQUEAL. INSPECTED DOOR AND FOUND DEBRIS PREVENTING A PROPER SEAL. CLEANED DOOR AND INSPECTED DOOR SEAL. NO DEFECTS ON DOOR SEAL FOUND. OK TO CONTINUE.SDR UALA2013070104578Starter · failedRAMP REPORTED SPARKS FROM NR 1 ENGINE DURING START. INSPECTED AREA, NO DAMAGE NOTED TO AREA OR NR 1 ENGINE COWLS, FOUND METAL CHARDS HANGING FROM STARTER. R & R NR 1 STARTER AND START VALVE IAW AMM, OPS CHECKED GOOD.SDR UALA2013062504391Computer · faultyELEVATOR SERVO FAULT DISPLAYED ON UPPER ECAM SCREEN. FLT CONTROL PAGE HAS AMBER BOX ON LT B. PFR FAILED ELAC 1. REPLACED ELAC 1. LAND 3 TESTS PASS REF AMM. ACFT IS IN CAT IIIB STATUS.SDR UALA2013061103993Structure · damagedRT WING TANK LANDING HAS TWO MISDRILLED HOLES.SDR UALA2013041202503Unknown · malfunctionedFWD CABIN TEMP CONTROL ALMOST IMPOSSIBLE TO CONTROL. CONSTANT COMPLAINTS. SAMC TEXT: NO HELP WITH HOT AIR SWITCH TURNED OFF. BARELY MOVE CONTROLLERS WITH HOT AIR OFF AND STILL WAY UP AND DOWN AFTER PERIOD OF TIME. PEOPLE ARE REALLY COMPLAINING. OUTPUT NOSDR UALA2013032701944Oxygen Bottle · missingOXYGEN BOTTLE MISSING, AFT CABIN. SERVICED O2 PRESSURE. OK FOR SERVICE.SDR UALA2012112606743Ground Wire · brokenEMERGENCY LIGHTS INOPERATIVE ON LAST 3 ROWS. FOUND BROKEN GROUND WIRE BS 2979, REPLACED WIRE HARNESS. OP CHECKED GOOD.SDR UALA2012112606742Epsu · failedL1 DOOR EMERGENCY LIGHT TEST FAILED. REPLACED EPSU, OP CHECKED GOOD.SDR UALA2012112006697Door Frame · dirtyDOOR 2R SEAL SQUEALS DURING CLIMBOUT UNTIL NEARING CRUISE ALT. INSPECTED DOOR 2R CUTOUT EXTREMELY WET. DRIED AND CLEANED ENTIRE CUTOUT. DOOR SEAL APPEARS WORN. PRESSURIZED ACFT PER MT 52-020 AND MM 05-53-00-780-001. NO AUDIBLE SOUNDS FROM DOOR 2R.SDR UALA2012093005537Scuff Plate · leakingPRESSURIZED AIRCRAFT TO 4 INCHES FOUND EVIDENCE OF PRESSURIZATION LEAKAGE AT LOWER DOOR SILL 2L MARKED AREA IN RED. RESEALED FWD AND AFT DOOR SCUFF PLATES.SDR UALA2012092805477Scuff Plate · leakingDOOR 2L SILL PLATE LEAKING. REMOVED AND CLEANED BOTH AFT AND FWD SCUFF PLATES AT 2L. RESEALED AND INSTALLED FWD PLATE APPLIED VACUUM AT 2030 HRS OUTSIDE TEMP 64 DEGREES F. RESEALED AND INSTALLED AFT PLATE. APPLIED HEAT AND VAC AT 2330 AFTER CURE NEEDS FAYISDR UALA2012090605016Pad · missingO2 MASK COMPARTMENT SEAT 31DEF, FOAM PAD IS MISSING. INSTALLED PAD.SDR UALA2012090705053Seal · damagedCREW REPORT: DURING CLIMB THROUGH FL260 M.81 EXPERIENCED RHYTHMIC FLUTTER THROUGHOUT ENTIRE JET. FOUND DAMAGED SEAL ON FUSE FRNG 197BB AND REPAIRED, FOUND BULB SEAL DAMAGED ON LEFT LOWER SURFACE AT STRUT CUTOUT. REPLACED FRNG 192AT, ACP RUD INTEGRITY CHECK SDR UALA2012090605013Door · crackedCABIN O2 DOOR COVER CRACKED AT SEATS 31 FED. REPLACED DOOR.SDR UALA2012090504997Retainer · missingSEATS 1AB & 1CD, 2AB & 2CD O2 MASK MISSING RETAINERS. REPLACED AND REPACKED O2 MASKS.SDR UALA2012090404933Rod · faultyAIRFRAME VIBRATION, RTFL. PER CAPT FELT STRONG CYCLICAL VIBRATION IN THE VERTICAL ONLY WENT AWAY WITH DECREASE IN SPEED. FELT THROUGHOUT CABIN. ALT 200FL-320FL, SPEED 320KTS. STRONGEST CAPT EVER FELT WITH AUDIBLE NOISE FACTOR. REPLACED THE LEFT GREEN AN RSDR UALA2012082204689Battery Pack · faultyWHILE PERFORMING EMERGENCY LIGHT TEST IT FAULTS, EPSU BATTERY FORWARD LEFT. REPLACED BATTERY PACK AT LEFT OVERWING POSITION.SDR UALA2012072604062Light · odorCREW REPORTS BURNING ODOR IN VICINITY OF THE FWD AFT LAVATORY. ODOR COMING FROM HALOGEN LIGHT FIXTURE AS IDENTIFIED IN DF131 AND DF130. REPLACED LIGHT FIXTURE REF IPC 33-24-04 ITEM 17-10. ALSO INSPECTED ABOVE LAV, OTHER AREAS OF THE LAV AND AFT GALLEY. NO ODOSDR UALA2012071103740Bushing · wornFOUND FWD HINGE BUSHING ON RT AFT NLG DOOR WORN. REPLACED DOOR.
Back to N449UA