N437UA
Service difficulty reports · 128
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 = 'N437UA' 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 = 'N437UA' 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 CALA2018011500210Cover · looseR AFT EMER EXIT DISPLAYED ON UPPER ECAM SCREEN. DOOR ECAM ANNUNCIATED AT 11000 ON DEPARTURE PRESSURIZATION NORMAL PAX SAID COVER FELL OFF REINSTALLED COVER AT EMER EXIT DOOR STATUS NORMAL.SDR CALA2017111704130Warning Light · malfunctionedR1 DOOR SLIDE IS SHOWS ARMED, WHEN IT IS DISARMED, FROM INSIDE. RESET SDAC PAX DOOR CIRCUIT BREAKER IAW AMM 52-00-00. ALL INDICATIONS NORMAL.SDR CALA2017111004020Lens · missingR2 DOOR EXIT LIGHT LENS MISSING. REPLACED THE EMERGENCY LIGHT LENS. OPS CHECKED GOOD. OK TO CONTINUE.SDR CALA2017110603934Spar · delaminatedLEFT HORIZONTAL STAB REAR SPAR BOX LOWER SKIN FLANGE HAS AN AREA OF DELAMINATION. REPAIRED SPAR BOX LOWER SKIN FLANGE IAW EC/RA 5510-02792, REV A.SDR CALA2017110303896Bracket · damagedFRAME 61, STRINGER 37L TO VERTICAL WEB SUPPORT BRACKET IN AFT CARGO BAY, OUTBOARD HOLE IS OUT OF ROUND IS OUT OF ROUND AND CANNOT BE DETERMINED CRACK FREE UNTIL MADE ROUND. FABRICATED WEB SUPPORT BRACKET & INSTALLED IAW SRM 51-72-11-001 & 51-42-11-001.SDR CALA2017100203386Battery · faultedDURING A NR 2 SERVICE CHECK, FOUND THE LT FWD EMERGENCY LIGHT BATTERY FAULTED DURING LIGHT TEST. R & R THE BATTERY IAW AMM 33-31-58. EMERGENCY LIGHTS CHECKED NORMAL.SDR CALA2017040400849Battery · faultyBATTERY EMER R FAULT APPEARED ON CIDS PANEL AFTER PERFORMING EMERGENCY LIGHTS TEST. REPLACED BATTERY EMER R. OPS CHECKS GOOD. REF AMM 33-51-38.SDR CALA2014072591515Stringer · corrodedMAJOR REPAIR. STRINGER 42L CORROSION REPAIR ACCOMPLISHED BETWEEN FRAME 57 - 59. STRINGER SPLICE REPAIR REQUIRES INSPECTION AT 60,000 FLIGHT CYCLES AFTER REPAIR EMBODIMENT. DAMAGE WAS REMOVED & NDT ACCOMPLISHED IAW NTM51 -10-08. NO CRACKS FOUND. THE REPAISDR CALA2014071591474Beam · corrodedDOOR 2L SILL BEAM CORRODED AT FASTENER HOLES FOR FWD GIRT BAR FITTING. REMOVED CORROSION & INSTALLED REPAIR IAW SRM 53-41-14 FIG 201. THIS IS A CATEGORY A REPAIR.SDR CALA2014061691279A/C Pack · inoperativeNUMBER 1 PACK IS INOPERATIVE. INOPED PACK 1 PER MEL 215 2A.SDR CALA2014061391258A/C Pack · inoperativeNUMBER 1 PACK IS INOPERATIVE REF MEL CARD. INOPERATIVE PACK 1 IAW MEL 215 2A.SDR CALA2013112093120Battery · faultyBATTERY 1 FAULT DISPLAYED ON UPPER ECAM SCREEN. REPLACED BATTERY 1 & BCL 1 IAW AMM, GND TESTED OKAY.SDR CALA2013110592645Sleeve · delaminatedNR 1 ENGINE REVERSER SLEEVE SCREEN DELAMINATE INOPERATIVE. NR 1 ENG REVERSER DEFER IAW MEL. TAKE PICTURES OF DAMAGE OF DELAMINATE & UPDATE ON RVI SITE & UPDATE WITH PARTS NEEDED & IPC IAW. SLEEVE NEEDED PER TOMC, ON ORDER IAW OSTF V4807. PARTS 115-9104 MRSDR CALA2013110892734Thrust Reverser · damagedON WALK AROUND CREW FOUND MATERIAL LOOSE & PEELING ON NR 1 ENG INBD REVERSER HALF AS VIEWED FROM THE REAR OF THE ENGINE. REPAIRED IAW ECRA 7830-02701.SDR CALA2013102992476Pump · leakingBLUE SYS HYD OBSERVED AT 3250PSI. STEADY STATE, REPEAT WU. REPLACED BLUE SYSTEM PUMP IAW AMM-29-12-51-000-001-A & AMM-29-12-51-400-001-A. PERFORMED OPERATIONAL BLUE SYSTEM, CHECKED OKAY.SDR CALA2013102192215Transducer · faultyBLUE HYD SYS 3250PSI STDY STATE IN CRUISE. REPLACED HYD PRESSURE TRANSDUCER IAW AMM, OPERATIONS CHECKED NORMAL. NO LEAK FOUND.SDR CALA2013100791766Screw · loosePANEL 191KB LOOSE SCREW INBD SIDE 4 FROM AFT EDGE. NEEDS NEW NUTPLATE TO BE REPAIRED WITHIN 10C.SDR CALA2013100491731Fastener · looseRAMP REPORTED ONE LOOSE FASTENER ON LOWER BODY PANEL TO CREW. REPLACED FASTENER & BARREL.SDR CALA2013092391358Test Switch · brokenFIRST OFFICER`S O2 DOOR PRESS TO TEST BUTTON IS BROKEN. REPLACED O2 STORAGE BOX.SDR UALA2013070904778Oxygen Bottle · low pressureCOCKPIT OXYGEN BOTTLE HAS LOW PRESSURE. SERVICED CREW OXYGEN BLTTLE IAW AMM 12-14-35.SDR UALA2013070104559Landing Gear · vibrationEXCESSIVE NOSE WHEEL VIBRATION ON TAKEOFF ROLL FROM 80 KIAS THROUGH GEAR RETRACTION. R & R BOTH NOSE WHEEL ASSY IAW AMM. TIRE PRESSURE CHECKED GOOD.SDR UALA2013062604452Microphone · inoperativeF/O OXYGEN MASK MICROPHONE INOPERATIVE, IN HOT-MIC FUNCTION. REPLACED F/O OXYGEN MASK IAW AMM, OPS CHECKED GOOD.SDR UALA2013061704157Unknown · malfunctionedDURING REFUEL, FUEL MIGRATED TO INNER TANKS WITH TRANSFER VALVES SHOWN CLOSED ON FUEL PAGE. POSSIBLE TRANSFER VALVE SHAFT SHEARED.SDR UALA2013053103808Latch · defectiveOXYGEN MASKS DOWN 23 DEF. SEATS AT 23DEF ARE NOT TO BE USED, SEATS PLACARDED INOP. O2 PANEL SECURED CLOSED, WILL NEED NEW LATCH FOR PANEL.SDR UALA2013041802655Cover · detachedCOVER OFF OF EMERGENCY EXIT WINDOW RIGHT AFT. INSTALLED COVER.SDR UALA2013041802654Battery Pack · failedCABIN EMERGENCY LIGHT CHECK FAILED, FAULT EMERGENCY SYSTEM 33-51-38 BATTERY FWD LEFT. REPLACED EMERGENCY BATTERY FOR THE FWD BATTERY PACK AS PER MM.SDR UALA2013040802351Control Panel · faultyF/O VHF 2 DOES NOT DESELECT CONTINUE TO HEAR VHF2 WHEN DESELECTED AND VOL. SWAPPED F/O ACP DASH 467 WITH NR 3 ACP DASH 483. CONFIRMED F/O ACP BLEED THRU. PLACED OBSERVER SEAT ON PLACARD. T-S CONFIRMED NEEDS PANEL 582-9012 PART NSU AT TPA AC STILL CONFIGURESDR UALA2013030101226Seal · deterioratedPAX AND F/A REPORT A VIBRATION AT FLOOR LEVEL, AT ROW 20DEF. NO ABNORMAL COCKPIT INDICATIONS. FOUND LOWER BELLY FAIRING SEALS ON PANELS 197GB AND 198GB DEGRADED FROM SKYDROL. TAPED SEALS PER MT53-004. REPLACED SEALS ON PANEL 197GB AND 198GB REF MT 53-017.SDR UALA2013021100797Sliding Window · stuckCAPTAIN'S SLIDING WINDOW WON'T CLOSE. RELEASED CAPTAIN`S SLIDING WINDOW FROM STUCK POSITION. OPS CHECKED GOOD, OK FOR SERVICE.SDR UALA2012122707408Blocker Door · departedNR 2 ENGINE OTBD REVERSER DAMAGED FROM BLOCKER DOOR DEPARTING. REMOVED AND REPLACED NR 2 ENGINE IAW AMM. REPAIRED PER ECRA 7830-02 582.SDR UALA2012120707087Windshield · faultyHIGH PITCHED SQUEAL IN COCKPIT IN CRUISE. SOUNDS LIKE F/O SIDE WINDSHIELD TOP OR RIGHT EDGE. MAINT TEXT: TALKED TO CREW UPON ARRIVAL. THEY SAID IT WAS A VERY HIGH PITCH SQUEAL FROM THE FRONT WINDSHIELD. WHICH REQUIRED WEARING EARPLUGS DURING FLIGHT. REPLACSDR UALA2012103106255Altimeter · failedCOCKPIT STANDBY ALTIMETERS FAILED ACCURACY CHECK. REPLACED STANDBY ALTIMETERS AND OPS CHECKED LIGHTING GOOD REF ACP.SDR UALA2012101705936Seal · leakingNR 2 ENGINE CHG DUE TO TOWER SHAFT-GEARBOX MATING SURFACE OIL LEAK. ENGINE DOWN FOUND. WILL NEED SEALS AND PLUGS PRIOR TO FLT HAVE ACCESS TO INSTALL PARTS ONCE ENGINE IS UP. REMOVE AND INSTALL ENGINES REF MT71-017. REPLACED NR 2 ENG IAW MT71- 017. ACCOMSDR UALA2012091005072Power Supply · inoperativeRIGHT OVERWING AFT LOWER EMERGENCY EXIT LIGHT INOP. REPLACED LIGHT POWER SUPPLY AND BATTERY PER MM, OP CHECKS OKAY.SDR UALA2012082404762Windshield · faultyRIGHT WINDSHIELD DISPLAYED ON UPPER ECAM SCREEN. ANTI ICE. ACCOMPLISH CHRONIC REVIEW. REPLACED RIGHT WINDSHIELD PER MM.SDR UALA2012082204686Connector · unsecureRIGHT WINDSHIELD DISPLAYED ON UPPER ECAM SCREEN. ANTI ICE CREW COMMENTS: ECAM APPEARED IN CLIMB PASSING 18,000 FEET. RE-SEATED CONNECTORS AT RIGHT WINDOW HEAT CONTROLLER. CFDS TEST OKAY. REPLACED WHC2, TEST NORMAL.SDR UALA2012081604549Audio Panel · inoperativeFIRST OBSERVERS AUDIO PANEL INOPERATIVE. REPLACED AUDIO PANEL, OPS CHECKED NORMAL PER MM.SDR UALA2012080604222Radar · faultedWX RADAR ISSUE, RTFL. REPLACED RADAR. PERFORMED BITE CHK TEST SYSTEM GOOD.SDR UALA2012052202876Connector · unsecureRED EMERGENCY EXIT ROW LIGHT ON SEAT 11C INOPERATIVE. FOUND CONNECTOR LOOSE AT UNDER SEAT BOX. SECURED CONNECTOR AND WIRES. OPS CHECKED GOOD.SDR UALA2012013000588Light · defectiveBOTH AFT LAV VANITY LIGHT COVERS DISCOLORED TO THE POINT THAT ITS DARK IN LAVS. STILL ALLOWS SATISFACTORY LIGHT TO PASS, COVERS NEED REPLACEMENT WITHIN 20 DAYS. REPLACED LENS BOTH LAVS.SDR UALA2012010900197Oxygen Mask · no testCAPTS O2 MASK FAILS TEST. REPLACED MASK TESTED, OPS NORMAL.SDR UALA2011112706521Windshield Wiper · inadequateCAPTAINS WINDSHIELD WIPER BLADE DOES NOT CLEAR RAIN FROM GLASS. NO CONTACT ON 3 INCHES+. REPLACED WIPER BLADE.SDR UALA2011092805259Smoke Detector · faultedLAVATORY SMOKE DETECTOR FAULT MESSAGE. UPON POWER TRANSFER TO SHIPS POWER. REPLACED LAVATORY SMOKE DETECTOR, MESSAGE CLEARED. BITE TESTED GOOD.SDR UALA2011072103710Oven · dirtyELEC BURNING SMELL DESCENT INTO ORD WENT AWAY WITH GALLEY POWER OFF. FOUND OVEN R11 DIRTY. UNABLE TO REMOVE OVEN INSERT TO CLEAN. REPLACED OVEN R11. RAN ENGINES, OPERATED ALL GALLEY EQUIPMENT & LIGHTS INSPECTED GALLEY. NO ODORS OR DEFECTS PRESENT IN GALLEY SDR UALA2011061302923Filler · missingRT ELEVATOR TRAILING EDGE FILLER MISSING.SDR UALA2010122704726Oxygen Mask · no testCAPTAIN'S O2 MASK WILL NOT TEST IN HOLDER. REPLACED CAPT'S O2 BOX AND MASK ASSY IAW AMM.SDR UALA2010081602979Valve · malfunctionedAVIONICS BLOWER FAN ECAM. FLIGHT DIVERTED. CREW REPORTED ACFT EXPERIENCED A SKIN VALVE ECAM FAULT AND A BLOWER ECAM FAULT WHILE IN CRUISE. WHILE AIRCRAFT WAS ON SHORT FINAL IT ALSO HAD AND EXTRACT ECAM FAULT APPEAR. REPLACED VALVE. OPS NORMAL.SDR UALA2010042001309Handle · bentCARGO DOOR LIGHT ILLUM, RTFL. DOOR CREW COMMENTS: IN FLT RETURN TO FSD. FOUND DOOR HANDLE WILL NOT REMAIN COMPLETELY LOCKED IN THE STOWED POSITION, CAUSING ECAM WARNING. FOUND HANDLE, 110-3675, BENT AND NOT ALLOWING PROX SWITCH TO MAKE. REPLACED HANDLE. STOWSDR UALA2009081302489Unknown · odorCABIN AND COCKPIT ODOR SOMETHING BURNING ON GROUND. CABIN FAN FAULT INDICATION DISPLAYED ON COND PAGE OF LOWER ECAM. CYCLED CABIN FAN SWITCH. ODOR CLEARED AND MESSAGE CLEARED.SDR UALA2009063001862Unknown · odorSMOKE ODOR IN THE REAR OF ACFT. FIRE DEPT CHECKED AREA WITH HEAT SCANNER AND NOTHING FOUND. REMOVED AND CHECKED COFFEEMAKERS, OVENS AND CHILLER, NO DEFECTS NOTED. CKD OPERATION OF CABIN RECIRC FANS, NO DEFECTS NOTED. ALL CABIN LIGHTS OPERATING, PACKS OPERATING
Back to N437UA