N653UA
Service difficulty reports · 315
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 = 'N653UA' 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 = 'N653UA' 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 2008UALA01028Hose · leakingTHE 2ND OBS OXYGEN HOSE IN STORAGE BOX LEAKS. SUSPECT DAMAGED FROM PRE FLIGHT CHECKS. REPLACED MASK AND BOX PER MM35-11-51. OPS CKD NORMAL. AC OK FOR SERVICE.SDR 2008UALA00982Gcu · faultyEICAS MSG R GEN OFF DISPLAYED. R GEN OFF AND FIELD OFF LGT'S ILLUMINATED. SUSPECT FAULTY GENERATOR CONTROL UNIT. REPLACED ENGINE NR 2 GCU PER AMM 24-22-02, CHECKS NORMAL. AC OK FOR SERVICE.SDR 2008UALA00691Light · inoperativeCENTER GALLEY RT EMERGENCY LIGHT (EEL) STRIP INOP. REPLACED EEL STRIP.SDR 2008UALA00690Light · inoperativeCENTER GALLEY LT EMERGENCY LIGHT STRIP INOP. REPLACED LT CENTER GALLEY EEL STRIP.SDR 2008UALA00581Light · inoperativeFWD RIGHT GALLEY EMERGENCY LIGHT STRIP (EEL) INOP. REMOVED AND REPLACED LIGHT STRIP.SDR 2007UALA04740Connector · inoperativeFLOOR EEL LIGHTS INOPERATIVE AT 10E. FOUND TERMINAL CONNECTOR LOOSE, SECURED AND OPS CK NOW OK.
SDR 2007UALA04695Light · inoperativeFWD PARTITION LIGHT BAR INOP, EEL . REMOVED AND REPLACED LIGHT BAR.SDR 2007UALA04632Light · improper partAFT GALLEY (G4) SHORT LIGHT BAR IS WRONG TYPE. INSTALLED CORRECT PART, OPS CHECKS NORMAL.SDR 2007UALA04634Wire · arcedLEFT WING O/B SURGE TANK WIRES HAS SIGNS OF ARCING AT TERMINAL BLOCK, HARDWARE RUSTED O/B SIDE OF RIB 31. REPLACED LEVEL SENSOR AND TERMINAL BLOCK. AC OK FOR SERVICESDR UALA2008111304633Structure · crackedNR 2 PYLON FUEL LINE CUTOUT FWD INBOARD ATTACH HOLE CRACKED. SUSPECT ENGINE VIBRATION CAUSE. INSTALLED NEW REPAIR DOUBLER PER REO-G12178 REV B. AC OK FOR SERVICE.SDR 2007UALA04630Light · inoperativeLEFT MID LAV EEL LIGHT BAR IS INOPERATIVE. REPLACED LIGHT BAR.
SDR 2007UALA04633Structure · crackedNR 2 PYLON FUEL LINE CUTOUT FWD INBOARD ATTACH HOLE CRACKED.SDR 2007UALA04619Floorbeam · crackedMAIN CABIN FLOORBEAM, ATTACH VERTICAL CHANNEL CRACKED AT BS 1503 LBL 67. MAJOR REPAIR ACCOMPLISHED. REMOVED & REPLACED CHANNEL LBL 67.SDR 2007UALA04618Floorbeam · crackedSTA 246, LBL 26, FLOORBEAM VERTICAL STIFFENER IS CRACKED. REMOVED & REPLACED VERTICAL STIFFENER.SDR 2007UALA04465Stringer · corrodedMAIN CABIN, RT FUSELAGE INTERNAL, STR 13R HAS SURFACE CORROSION JUST AFT OF STA 1263. SUSPECT MOISTURE CONTAMINATION. REMOVED DAMAGED AND FABRICATED REPAIR AND INSTALLED PER SRM 53-00-03. ACFT OK FOR SERVICE.SDR 2007UALA04464Floorbeam · corrodedMAIN CABIN FLOORBEAM CORRODED AT OUTBOARD END BS 287 AT FWD LOWER CORNER OF R-1 DOOR CUTOUT. SUSPECT MOISTURE CONTAMINATION. REMOVED DAMAGED SECTION OF CAP AND FABRICATED CAP SECTION, ANGLES AND STRAPS AND INSTALLED PER SRM 53-00-51. ACFT OK FOR SERVICE.SDR 2007UALA04463Frame · corrodedMAIN CABIN FRAME CAP CORRODED STA 246 BL80R TO BL84R. SUSPECT MOISTURE CONTAMINATION. REMOVED CAP SECTION AND FABRICATED NEW SECTION. ACFT OK FOR SERVICE.SDR 2007UALA04441Angle · corrodedMAIN CABIN AT STA 287 APPROX RBL 80, FLOORBEAM ANGLE P/N 141T5111-45 IS CORRODED. MAJOR REPAIR ACCOMPLISHED: REPLACED ANGLE P/N 141T5111-45.SDR 2007UALA04440Angle · crackedMAIN CABIN INTERCOSTAL UPPER ANGLE CRACKED BETWEEN STA 1197 + 22 AND 1197 +44, LBL 40. MAJOR REPAIR ACCOMPLISHED: REMOVED CRACKED ANGLE. INSTALLED NEW ANGLE, P/N 140T2540-9.SDR 2007UALA04439Frame · corrodedMAIN CABIN FRAME T-CAP CORRODED STA 303 BL51R TO BL55R. MAJOR REPAIR ACCOMPLISHED: CUT OUT DAMAGED SECTION OF T-CAP. FABRICATED T-CAP SPLICE. INSTALLED TEE CHORD, ANGLE & SPLICE REPAIR.SDR 2007UALA04114Light · intermittentEMERGENCY LIGHTS ON RIGHT AISLE ROWS 15-18 COMING ON AND OFF. LEAVING EMERGENCY LIGHT SWITCH OFF FOR A TIME NO HELP. CHECKED ALL CONNECTIONS AND TESTED SYSTEM. ALL OPERATIONAL. NO DEFECTS FOUND. COULD NOT REPRODUCE PROBLEM.
SDR 2007UALA02616Blade · fracturedCREW SHUTDOWN THE NR 1 ENGINE DUE TO VIBRATION. LANDED UNDER AMBER ALERT. [08-14-07] ENGINE REPLACED AT IAD. SHOP TEARDOWN FOUND ONE STAGE-2 HPT BLADE FRACTURED AT THE PLATFORM. THIS CAUSED AN UNBALANCE THAT PRODUCED HEAVY VIBRATION. FAILURE RESULT OFSDR 2007UALA02505Connector · faultyACRID ELECTRICAL ODOR IN AFT GALLEY AREA REPORTED AFTER TAKEOFF, NO SMOKE NOTED. [08-08-07] FOUND GALLEY CART CONNECTOR WITH PINS DIRTY AND PINS BENT. STRAIGHTENED PINS AND CLEANED CONNECTORS ON BOTH AIRCRAFT AND CART SIDES OF CONNECTION. LEFT CART WORKINSDR 2007UALA00660Unknown · odorBURNING ODOR NOTICED IN CABIN BY CREW. TROUBLE SHOOTING IDENTIFIED PROBLEM AS OVERHEATING OF FWD E & E COMPARTMENT COOLING FAN. REPLACED FWD EXHAUST FAN AS PER MM 21-58-06. TESTED OKAY. SUSPECT DIRT BUILD-UP CAUSED FAN TO DRAG & REQUIRED MORE CURRENT TO OVESDR 2007UALA00649Connector · damagedF/A REPORTS BEING SHOCKED WHEN TOUCHING A GALLEY CART. FOUND CONNECTOR DAMAGED. REPLACED DAMAGED AFTER-GALLEY P53 PIGTAIL CORD CONNECTOR. CART CHECKED FOR VOLTAGE TO GROUND. CHECKED OK.SDR 2006UALA01869Computer · failedL EICAS COMPUTER STATUS MSG DISPLAYED. REPLACED LEFT EICAS COMPUTER. A11 FLASH BAD. REPLACED A11U4 AND U10. OPS CHECK NORMAL.SDR 2006UALA01801Generator · unknownRETURNED TO IAD DUE TO NR 2 GENERATOR PROBLEM. FOUND OVERFILL PRESSURE FITTING LEAKING OIL. REPLACED FITTING AND SERVICED TO FULL.SDR 2006UALA01275Stringer · damagedSTRINGER S38L HAS PUNCHED A 2 INCH LONG HOLE AND OR CRACK AT FRAME 588.SDR 2006UALA01194Skin · ground damageAIRCRAFT WHILE AT GATE RECEIVED APPROX A ONE FOOT BY 2 FOOT HOLE IN THE FUSELAGE BY THE BAGGAGE CART. REPAIRED DAMAGED FRAME WEB. DYE CHECKED FAIL SAFE CHORD AND AREA AND FOUND NO CRACKS.SDR 2006UALA00919Skin · crackedNR 1 STRUT SIDE SKIN PNL FWD TORQUE BOX ACCESS HOLE HAS CRACK ON THE TOP SIDE. REPAIR DOUBLER PER SRM54-53-01, REPAIR 6 WAS INSTALLED, WITH 1 EXTRA ROW OF REPAIR FASTENERS.SDR 2004UALA01210Warning System · activatedASYMMETRICAL FLAP WARNING. PERFORMED PSEU BITE TEST. FAULTED SWITCH S303. REPLACED SWITCH, SYSTEM OPS CHECKS GOOD.SDR 2004UALA01006Switch · out of rigDIVERTED TO JFK DUE TO LEADING EDGE FLAP INDICATION PROBLEM. FOUND NR 9 LE SLAT SWITCH S303 OUT OF RIG. SHIMMED SWITCH TO ACHIEVE PROPER SWITCH TARGET GAP.SDR 2004UALA01009Angle · crackedIN E/E COMPARTMENT, CRACK ON UPPER ANGLE OF STATION 246 FLOORBEAM, LBL 10, AFT SIDE. SUBJECT OF OEM SERVICE BULLETIN AND INCORPORATED INTO ROUTINE INSPECTION PROGRAM.SDR 2004UALA00999Support Angle · crackedE/E COMPARTMENT CRACK IN SUPPORT ANGLE STATION 246 FLOORBEAM AT RBL 5. MAJOR REPAIR ACCOMPLISHED. CRACK DUE TO BODY FLEXING/LOADING. CRACKED ANGLE WAS REPLACED.SDR 2004UALA00894Check Valve · failedNR 2 ENGINE COMPRESSOR STALL. REPLACED ENGINE DUE TO UNABLE TO ROTATE. UPON SHOP TEARDOWN OF ENGINE, ROOT CAUSE OF THE SURGE WAS DETERMINED TO BE CATASTROPHIC FAILURE OF THE PNEUMATIC 8TH STAGE CHECK VALVE.SDR 2004UALA00437Display · malfunctionedWX RADAR GREEN BAND RING DISPLAY AT APPROX 6.5 MILE IN FRONT OF ACFT. RADAR DISPLAYS A GREEN ARC THAT SEEMS TO MOVE WITH RADAR TILT.SDR 2004UALA00400Radar · failedDIVERTED TO MIA DUE TO LOSS OF WEATHER RADAR. FLIGHT CREW REPORTED A GREEN BAND ON THE RADAR DISPLAY APPROX. 6.5 MILES IN FRONT OF AIRCRAFT. MAINTENANCE REPLACED C-BAND WX RADAR CONTROL PANEL. SHOP FOUND CONTROL PANEL TILT CONTROL MISADJUSTED TO 14.5 DEGREESSDR 2004UALA00303Solenoid · failedRIGHT ENGINE COMPRESSOR STALLS. CREW REPORTED SURGE. AIRCRAFT SYSTEM DID NOT CONFIRM THE SURGE EVENT. ALL TROUBLESHOOTING WAS ACCOMPLISHED AND THE 2.9 BLEED SOLENOID WAS REPLACED.SDR 2004UALA00167Wire · damagedWIRE DAMAGE AFT CARGO PIT STA 1230. THERE WAS NO CONCLUSIVE INDICATION OF WHAT INITIATED THE WIRE DAMAGE. THERE WAS NO APPARENT CHAFING. THERE WERE METAL CHIPS NOTED IN THE AREA, BUT NONE FOUND DIRECTLY ON OR BELOW THE WIRE BUNDLE. IT IS UNKNOWN, AS TO WHETHERSDR 2003UALA00967Light · inoperativeEXTERIOR EMERGENCY LIGHT INOPERABLE AT DOOR 4L. RELAMPED, OPS CHECKED NORMAL.SDR 2003UALA00688Engine · surgesNR 2 ENGINE, SURGE. ENGINE SURGE IN FLIGHT AT TOP OF DECENT. EPR BELOW 1.25. ENGINE REMOVED TO PERFORM SURGE CHECKS AND TEST-21. PERFORMED EXTERNAL CHECKS AND FOUND NO DISCREPANCIES.SDR 2003UALA00668Engine · surgesENGINE 2 SURGE DETECTED. ENGINE SURGE IN FLIGHT AT TOP OF DECENT. EPR BELOW 1.25. SURGE CHECKS ACCOMPLISHED SHOWED NO IRREGULARITIES. NO CAUSE FOUND.SDR 2003UALA00391Skin · damagedBS 1197, STRINGER 35R-38R HAS 24 INCH CREASE EXTERIOR SKIN.SDR 2002UALA00042Floorbeam · corrodedFWD CABIN BS 344, RBL 70R, FLOORBEAM T-CAP CORRODED. MAJOR REPAIR ACCOMPLISHED. SPLICED IN NEW T-CAP.SDR 2002UALA00041Floorbeam · corrodedMAIN CABIN FLOOR TRANSVERSE FLOORBEAM CORRODED. STA 784, LBL 33.06 MAJOR REPAIR ACCOMPLISHED. INSTALLED DOUBLER REPAIR.SDR 2002UALA00070Floorbeam · corrodedBODY STATION 1197 + 132 LBL 40-44 T-CAP CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED T-CAP.SDR 2002UALA00069Beam · corrodedBODY STATION 805-806 RBL 54 TRANSVERSE BEAM CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED REPAIRS AND SPLICES.SDR 2002UALA00068Beam · corrodedBODY STATION 805-806 RBL 54 TRANSVERSE BEAM CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED REPAIRS AND SPLICES.SDR 2002UALA00067Bulkhead · corrodedBODY STATION 246 RBL 60 BULKHEAD CORRODED. SUPPLEMENTAL DATA UPDATE MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED CHORDS AND ANGLES.SDR 2002UALA00035Floorbeam · corrodedBODY STATION 1153 RBL 20-25 LBL 2-35 T-CAP CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED T-CAP.
Back to N653UA