N838UA
Service difficulty reports · 93
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 = 'N838UA' 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 = 'N838UA' 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 CALA2015111894842Battery Pack · dischargedTWO SERVICE EMER LIGHT TEST FAILED, EPSU LT FWD UNIT. REPLACED BATTERY PACK. OPERATIONS TESTED NORMAL.SDR CALA2015111894841Battery Pack · dischargedEMERGENCY LIGHT TEST FAILS EPSU LEFT AFT. REPLACED BATTERY PACK. OPERATIONS TESTED NORMAL.SDR CALA2014010390046Radio Altimeter · failedENROUTE FAILURE OF THE AUTO THRUST & NR 1 RADIO ALTIMETER. THESE FAILURES LIMITS AIRCRAFT CAPABILITY TO CAT I. DUE TO WEATHER CONDITIONS PIT, FLIGHT DIVERTING TO ORD.SDR CALA2014010290018Cowl Door · out of adjustNR 2 ENG COWL HINGE PANEL ON BOTTOM OF ENG IS BENT & NOT SEATING NORMALLY. ADJUSTED DOOR, CHECKED OKAY.SDR CALA2013123094042Fastener · missingDADO PANELS THAT COVER EMERGENCY LIGHT BATTERIES AT ROW 21ABC & 21DEF MISSING ONE EACH FASTENER. IAW ECRA EC2523-01132 SECURED PANEL WITH TAPE.SDR CALA2013122793983Wire · shortedPIN F REMOVED FROM 450VT2 FOR DF988. IAW WD 26 12 08, MEG WIRE TO GND SORTED, WILL NEED TO OPEN JUNCTION BOX. SUGGEST WE HAVE DUCKS REMOVED AT 12 O'CLOCK POSITION TO SEE IF WE CAN GET ACCESS TO J BOX.SDR CALA2013121393688Control Cable · lack of lubePITCH TRIM IS STIFF & BINDING. PITCH TRIM SYS OPERATIONS NORMAL. INSPECTED & LUBED REAR THS CONTROL CABLE IAW MM PRECAUTIONARY.SDR CALA2013112593225Radar · faultyWXR INOPERATIVE, FLIGHT DIVERTED. REPLACED WXR IAW AMM. OPERATIONS CHECKED NORMAL IAW BITE TEST OF THE WXR TASK 34-41-00-740-002A.SDR CALA2013111893015Switch · sticksCAPTAIN`S PTT SWITCH ON SIDE STICK IS STICKING. REPLACED CAPTAIN'S CONTROL HANDLE.SDR CALA2013102992452Liner · damagedNR 1 ENG FAN CASE ATTRITION LINER HAS A HOLE & CRACK AT THE 6 O'CLOCK POSITION. DAMAGE AREA MEASURES APPROXIMATELY 3" X 3" & IS LESS THAN 20% OF THE PANEL. REPAIRED NR 1 ENG FAN CASE ATTRITION LINER IAW MT 72-017.SDR CALA2013082690731Transducer · faultyELAC 2 PITCH FAULT. DUE TO REPEAT ELAC 2 PITCH FAULT ECAMS ALONG WITH ECAM AILERON SERVO FAULT WITH CFDS MESSAGES "AFS ELAC 2" & "L OR R PEDALS XDCR UNIT" AT NEXT MAINTENANCE OPPORTUNITY TROUBLESHOOT IAW TSM 27-10-00-810-803A. ELAC 2 PREVIOUSLY CHANGED. REMOSDR CALA2013082090601Cover · missingNR 3 LEFT OUTBOARD FLAP TRACK MOVEABLE FAIRING PIVOT COVER MISSING. REPLACED PIVOT COVER.SDR CALA2013081990544Computer · faultyDURING CRUISE FLT FELT BUMP IN TAIL AND ECAM F-CTL ELAC2 PITCH FAULT AND AIL SERVO FAULT MESSAGES APPEARED AND FELT ANOTHER BUMP AND MESSAGES CLEARED. TROUBLESHOTING & FOUND NO PEDAL MESSAGES, REPLACED ELAC 2, OPS TESTED GOOD.SDR UALA2013070804726Skin · dentedTEE SHAPED DENT APPROX 6 BY 3 INCHES AND SMALL CIRCULAR DENT IN BOTTOM OF INBD T/E FLAP NEAR FUSELAGE. DENT IS IN RT TE FLAPS.SDR UALA2013053003757Fire Loop · shortedFIRE LOOP B FAULT DISPLAYED ON UPPER ECAM SCREEN. PERFORMED MT 26-001 AND TSM 26-12-00-810-808-A, FOUND FAN DETECTOR LOOP "B" HIGH RESISTANCE READING OUT OF LIMITS. R & R NR 2 ENG FAN LOOP ASSY. OPS CHECKED GOOD.SDR UALA2013031101409Fire Loop · faultedNR 2 ENGINE FIRE LOOP B WARNING MESSAGE. TROUBLESHOT IAW TSM 26-12-00-810-808-A PG1 TO PG3. RESISTANCE FROM EACH LOOP DETECTOR (CORE-FAN PYLON) IS WITHIN LIMITS. NEED TO CONT ON TO PG3 ITEM B OF TSM 26-12-00-810-808-A. ALL RESISTANCE AND READING VALUES WESDR UALA2013011700307Wire Harness · pinchedNR 2 ENGINE FIRE LOOP B FAULT. FOUND WIRES AT 10 O'CLOCK POSITION PINCHED UNDER FWD SIDE OF PRSOV. WIRE HARNESS FROM 4001WD 2 CORE DETECTOR TO PYLON, SHIELD AND BLUE WIRE DAMAGED. FOUND SECOND WIRE HAS HEAT DAMAGE AND CHAFED. NEED TO IDENTIFY AND MEGGER TOSDR UALA2012120707084Starter · faultyPER FLT CREW NR 1 ENGINE WILL NOT START, NO ROTATION. ALSO RAMP REPORTED SPARK COMING FROM NR 1 ENGINE. START PART # 651-0306 AOG F6209. REPLACED NR 1 ENGINE STARTER.SDR UALA2012082904859Visor · misinstalledFIRST OFFICERS SUNVISOR DEFECTIVE. FIRST OFFICERS SUNVISOR IS MISINSTALLED. REPLACED SUNVISOR.SDR UALA2012041502283Computer · faultyAUTO TRIM NOT WORKING A-C PITCHES UP W- NO INPUT ON STICK. REPLACED ELAC 2 PER AMM REF FIM TASK 27-30-00-810-853-A. TESTS NORMAL PER AMM TASK 27-93-00-710-001. PER FIM TASK NEXT HIT REPLACE ACCLRM-3 AND ACCLRM-4.SDR UALA2012032201815Nose Cowl · damagedFOUND METAL RING HANGING IN BLEED PORT NR 1 ENGINE. MAINT TEXT: FOUND INNER DUCT SEAL OF NR 1 ENGINE HANGING LOOSE ON EXHAUST GRILL OF TAI ON RT SIDE OF NOSE COWL. REPLACED NOSE COWL.SDR UALA2012011900418Seal · crackedDURING SEVERE TURB INSP FOUND NR 1 ENG INNER FAN CASE EXIT GUIDE VAINS RUBBER SEAL PNLS CRACKED ON ALMOST EVERY PANEL. REPLACED SEALS AT 6, 7, 8 AND 10 O'CLOCK POSITIONS.SDR UALA2011122207067Slat · dentedDENT IN NR 1 LEFT WING SLAT.SDR UALA2011081004186Connector · dirtyPER CONVERSATION W- SAM ENG 1 FIRE LOOP A ECAM IN FLIGHT TWICE. COMPLIED WITH MEL. CLEANED CONNECTORS ON ENG 1 LOOP 'A' CORE AND FAN SECTION. CHECKED OPERATION IAW AMM, ALL OKAY.SDR UALA2011080804153Servo Control · malfunctionedTAXI IN NOSE WHEEL STEERING FAILED AND NO STEERING WAS AVAILABLE. CLEARED AT ENG SHUTDOWN. NOSE WHEEL STEERING SERVO CNTRL (6GC) WAS REPLACED PER MM.SDR UALA2011072103713Structure · puncturedPUNCTURE HOLE IN LOWER SIDE OF RIGHT INBOARD FLAP. SMALL PUNCTURE IN FOIL-TAPE HOLE COVER. HOLE IN QUESTION, 24 INCHES OUTBOARD OF INBOARD EDGE OF RIGHT INBOARD T/E FLAP APPEARS TO BE HOIST POINT. APPLIED METAL TAPE PER MM, TO BE REPAIRED AT NEXT C-CHECK.SDR UALA2011071303529Module · faultyEMERGENCY LIGHTS COME ON WITH SWITCH OFF WHEN POWER IS REMOVED FROM AIRPLANE. JUMPERED SOCKET "S" OF CONNECTOR 2423VC TO GND AND EMERGENCY LIGHT SHUTS OFF. PANEL FOR EMERGENCY LIGHT SWITCH AND OLD SWITCH 4WL UNSECURED IN A/C. REPLACED SWITCH, NO HELP. REPLSDR UALA2011031801307Girt Bar · disconnectedCREW REPORTS GIRT BAR ON LEFT FWD DOOR SLIDE NOT CONNECTED TO SLIDE WITH DOOR OPEN. RE-INSTALLED DOOR SLIDE GIRT BAR PER AMM. OPS CHECK OKAY.SDR UALA2011031501246Epsu · inoperativeFWD EMERGENCY POWER UNIT 10WL INOP. REMOVED AND REPLACED 10WL EPSU AND OPS CHECKED REF AMM ON NR C7247K.SDR UALA2011021600815Harness · leakingCAPTAIN'S OXYGEN HARNESS FAILS TO INFLATE (IS LEAKING). CAPT AND 1ST OBS O2 TEST BUTTON INOP. APPEARS TO INFLATE WHEN PULLED. REPACKED MASKS, CHECKS SATISFACTORY.SDR UALA2010122804740Cowling · damagedENG NR 2 RT SIDE FAN COWL DAMAGED. REPLACED ENG NR 2 RT FAN COWLING IAW AMM. NO DEFECTS FOUND.SDR UALA2010122804739Nose Cowl · damagedENG 2 NOSE COWL DAMAGED. REPLACED ENG NR2 NOSE COWLING IAW AMM. ALL OK, NO DEFECTS FOUND.SDR UALA2010062802308Oxygen Mask · faultyOXY HIGH PRESSURE INDICATION AMBER ON DOOR-OXY SYS ECAM PAGE - DOOR-OXY CREW COMMENTS: CREW O2 INDICATES 300 FOUND OBSERVER REG LEAKING ON RT F/O SIDE. REPLACED OXYGEN BOTTLE AND 1ST OBSERVER'S OXYGEN MASK. CHECKED FOR LEAKS, ALL OK.SDR UALA2010040201098Oxygen Mask · leakingFO'S OXYGEN HARNESS FAILS TO INFLATE (IS LEAKING). REPLACED MASK. OPS NORMAL.SDR 2008UALA02824Light · brokenEMERGENCY LIGHTING ON SEATS 1A AND 1B IS BROKEN. REPLACED EMERGENCY LIGHT.SDR 2007UALA02459Light · failedCABIN EMERGENCY LIGHTS FAILED TEST. [07-24-07] OPS CHECKED OK.SDR 2007UALA02060Light · damagedEMERGENCY LIGHT ON SEAT 16C BROKEN OFF. REPLACED EMERGENCY LIGHT.SDR 2007UALA01323Skin · gougedRIGHT FUSELAGE SKIN IS GOUGED AT FRAME 64 BETWEEN STR 23R & 24R, REPAIR WILL BE IN CRITICAL SKIN AREA AT BUTT SPLICE. MAJOR REPAIR ACCOMPLISHED: CUT OUT DAMAGE. INSTALLED DOUBLER REPAIR.SDR 2006UALA02178Stringer · brokenAPPROX 10 IN X 10 IN PUNCTURE TO RT UPPER LEADING EDGE OF BODY FAIRING PANEL 192AB. UNDERLYING STRINGER BROKEN FROM ADJACENT ATTACH POINT. PANEL 192AB REMOVED, ROUTED AND REPAIRED IN SHOP. FOUND ATTACH BRACKET AT FORWARD LOWER END CRACKED AND BENT AT PANEL 1SDR 2004UALA00498Warning Light · illuminatedCREW ADVISED MOMENTARY LOSS OF BLUE & YELLOW HYDRAULICS WHILE EN ROUTE. REGAINED YELLOW. AMBER ALERT DECLARED. UNABLE TO DUPLICATE DISCREPANCY. NO PARTS REPLACED. OPERATIONS CHECK NORMAL.SDR 2004UALA00486Servo · failedLANDED UNDER AMBER ALERT DUE TO A NOSE WHEEL STEERING FAULT PROBLEM. NOSE STEERING SERVO UNIT FAILED. REPLACED NOSE STEERING SERVO UNIT. OPERATIONS CHECK NORMAL WITH NO MESSAGES OR LEAKS.SDR 2003UALA00870Odor · detectedFLIGHT DIVERTED DUE TO ELECTRICAL ODOR IN CABIN BETWEEN ROWS 3 AND 6. VENT BLOWER AND EXTRACT FANS RUNNING NORMAL, CHECKED RECIRCULATION FANS, BOTH PACKS OPERATING NORMAL. CHECKED CABIN LIGHTING AND PASSENGER ENTERTAINMENT SYSTEM, NO DEFECTS FOUND.SDR 2003UALA00485Door · openECAM WARNING AFTER TAKEOFF. AFT AVIONICS COMPARTMENT DOOR OPEN. RETURN TO FIELD. LUBRICATED AFT AVIONIC COMPARMENT DOOR PROXIMITY SWITCH
Back to N838UA