N332UA, cancelled Nov 18, 2008
Service difficulty reports · 56
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 = 'N332UA' AND deregistration_id = 'N332UA-2008-11-18' 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 = 'N332UA' AND deregistration_id = 'N332UA-2008-11-18' 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 2008UALA04057Battery Pack · dischargedEMERGENCY EXIT LIGHTS ON AND OFF INTERMITTENTLY. REPLACED BATTERY & CHARGER FOR M1197. LIGHTS OPERATE NORMALLY.SDR 2008UALA02558Lamp · faultyEMERGENCY LIGHT AFT OF DOOR 1 LEFT FUSELAGE. SUSPECT FAULTY LAMP. REPLACED LAMP OP CHECKED GOOD.AC OK FOR SERVICE.SDR 2008UALA01797Smoke Detector · faultyCARGO FIRE FWD A FAIL AMBER LIGHT REMAINS ON AFTER TEST. FOUND FAULTY SMOKE DETECTOR. REPLACED SMOKE DETECTOR.SDR 2008UALA01674Oxygen Bottle · reads lowAFT O2 BOTTLE LOW PRESSURE. REPLACED BOTTLE.SDR 2008UALA00908Connector · faultyCAPTAIN'S OXYGEN MASK DOES NOT TEST. YELLOW CROSS APPEARS BUT DOES NOT DISAPPEAR. RESET CONNECTOR. CHECKS OK.SDR 2008UALA00829Unknown · unknownCREW REPORTS, YOKE HAS A BUMP WHEN MOVING. FULL FORWARD TO AFT APPROX 3 INCHES AFT OF THE ELEVATOR FORWARD STOPS.SDR 2007UALA04183Inverter · faultyEMERGENCY FLOOR LIGHTS AFT OF ROW 15, DO NOT WORK. REPLACED INVERTER.
SDR 2007UALA03494Bulb · unsecureONE EEL LIGHT NOT WORKING AT SEAT ROW 7. SECURED LAMP IN ASSY, RECHECKED LIGHT SYS-NORMAL.SDR 2007UALA02275Structure · delaminatedNR 1 ENGINE INBOARD REVERSER IS DELAMINATED. RIGHT REVERSER CENTER CORE INNER AREA WAS FOUND DELAMINATED. REVERSER WAS REPAIRED.SDR 2007UALA00146Engine · contaminatedCREW REPORTS STILL HAVE SMELL OF BURNING PLASTIC NOTICED IN-FLIGHT USING BOTH ENG BLEEDS ON LEFT PACK. FOUND PLASTIC BAG STUCK TO APU COMPRESSOR INLET SCREEN. REMOVED BAG.SDR 2006UALA01896Probe · faultyRETURN TO FIELD DUE TO F/O PS 2 AUX STATIC LIGHT ON. FAULTY PITOT STATIC PROBE. REPLACED PITOT STATIC PROBE.SDR 2006UALA01108Bulkhead · buckledFUSELAGE TAIL COMPARTMENT BULKHEAD DOME WEB IS BUCKLED-OIL CANNED AT BS 1016-1026 S9R-S11R.SDR 2006UALA01110Battery Pack · dischargedEEL LIGHT AT A1 DOOR INOP.SDR 2006UALA01107Skin · ground damageFUSELAGE SKIN DENTED BY BAGGAGE LOADER 16 INCHES BELOW FWD PIT DOOR SILL PLATE.SDR 2006UALA01106Intercostal · crackedFUSELAGE INTERCOSTAL WEBS CRACKED AT STRINGERS 11L & 16L BS 294.5 LOCATIONS.SDR 2006UALA01105Skin · crackedEXTERNAL FUSELAGE SKIN CRACKED AT FWD GALLEY DOOR CUTOUT, AFT LOWER SILL AREA, UPON OPEN UP PILOT HOLE DAMAGE WAS FOUND ON FLOOR SUPPORT CHORD.SDR 2006UALA01070Stringer · dentedFUSELAGE STRINGER IS DENTED, BS 464 STR 27R.SDR 2006UALA00999Skin · crackedC1 AFT GALLEY DOOR UPPER HINGE CUTOUT CRACKED AT FWD UPPER CORNER STA 957 STR 14A, WL 253.SDR 2006UALA00968Crease Beam · corrodedCABIN FLOOR LT CREASE BEAM INBOARD CHORD IS CORRODED BS 947-994 STR 17L WL 208.SDR 2006UALA00924Warning Message · false indicationBOTH IRU 'DC FAIL' LIGHTS CAME ON WHILE IN CRUISE. BATTERY VOLTAGE INDICATED 28VDC.SDR 2005UALA01417Skin · puncturedPUNCTURE JUST FWD OF RT NOSE GEAR DOOR AND 1 FT FWD OF EXT PWR PANEL DOOR. ACCOMPLISHED INSTALLATION OF REPAIR DOUBLERS AND TRIPLERS PER SRM 53-00-01 REPAIR 31.SDR 2005UALA00707Odor · detectedFLIGHT DIVERTED DUE TO ODOR IN CABIN. TOOK OFF AND RETURNED A SECOND TIME WITH SAME ODOR.SDR 2005UALA00246Frame · damagedUPPER FRAME LT SIDE STA 178 HAS LOW EDGE DISTANCE. FABRICATED AND INSTALLED A REPAIR CHORD SPLICE ANGLE, PICKING UP AN ADDITIONAL FASTENER LOCATION.SDR 2005UALA00236Skin · dentedFOUND DENT IN HORIZONTAL STAB RT SIDE ABOUT 2 FEET IN FROM TIP. CUT OUT DAMAGED AREA AND INSTALLED DOUBLER REPAIR.SDR 2004UALA00961Indicator · malfunctionedDIVERTED TO MCI DUE TO HIGH ENGINE GAS TEMPERATURE READING IN NR 1 ENGINE. REVIEWED CHRONIC EGT INDICATION HISTORY, ACCOMPLISHED CONTINUITY CHECK FROM EGT CIRCUIT BREAKER TO D442 CONNECTOR AND HAND-OVER-HAND INSPECTION OF WIRING BETWEEN CIRCUIT BREAKER AND INSDR 2003UALA00571Skin · crackedLOWER SKIN CRACKED AT AFT END OF EQUIPMENT COOLING AIR EXHAUST DUCT. MAJOR REPAIR ACCOMPLISHED. INSTALLED DOUBLER REPAIR.SDR 2003UALA00193Frame · damagedSKIN IS CREASED NEAR THE FORWARD LAV SERVICE PANEL. 2 CREASES ARE WITHIN LIMITS OF SRM, BUT DAMAGE TO FRAME IS BEYOND LIMITS. MANUFACTURED AND INSTALLED DOUBLER REPAIR.SDR 2002UALA00946Fitting · corrodedVERTICAL STABILIZER STATION 1016 FIN TERMINAL FITTING CORRODED. MAJOR REPAIR ACCOMPLISHED. CORROSION REMOVED AND FITTING REWORKED.SDR 2002UALA00943Frame · corrodedFORWARD CARGO DOOR CUT-OFF AFT FRAME STATION 492.4 INBD FRAME FLANGE BLENDED BEYOND LIMITS MAJOR REPAIR ACCOMPLISHED. REINFORCEMENT REPAIR ANGLE INSTALLED ON FRAME.SDR 2002UALA00933Skin · cracked#1 SLAT, LOWER TRAILING EDGE SKIN, 1 EA RIVET CRACKED ON INBD SIDE ON SKIN. AT 2ND FROM OUTBOARD AUX TRACK. MAJOR REPAIR ACCOMPLISHED. REPAIR DOUBLER INSTALLED.SDR 2002UALA00932Slat · crackedLT WING NR 1 SLAT HAS CRACKS IN AFT ROW OF RIVETS, NR 29 THROUGH NR 33 FROM INBOARD SIDE FROM BLACK STRIP. MAJOR REPAIR ACCOMPLISHED. ACCOMPLISHED HFEC INSPECTION ON CUTOUT AFTER DAMAGE REMOVAL. DOUBLER REPAIR ACCOMPLISHED.SDR 2002UALA00931Skin · cracked#3 SLAT OUTER LOWER SKIN IS CRACKED ON AFT ROW RIVETS, 38TH RIVET FROM INBD SIDE. MAJOR REPAIR ACCOMPLISHED. DAMAGE CUT OUT, DOUBLER REPAIR ACCOMPLISHED.SDR 2002UALA00937Frame · crackedSTATION 188 STRINGER 18L FUSE FRAME CHORD IS CRACKED IN RADIUS. MAJOR REPAIR ACCOMPLISHED. REPAIR DOUBLER WAS INSTALLED OVER CHORD AND OVER EXTERNAL FUSE.SDR 2002UALA00936Bulkhead · crackedSTATION 178 BLKHD HAS NUMEROUS CRACKS LOCATED AT STA 178, WL 188, LBL 1.5, STA 178, WL188, RBL 1.5, STA 178, WL 202M LBL 7. STA 178, WL206.5, RBL 1, STA 178, RBL 5, WL 198. MAJOR REPAIR ACCOMPLISHED. BULKHEAD DOUBLER AND STRAP REPAIR MANUFACTURED AND INSTALLESDR 2002UALA00916Frame · dentedAFT PIT FRAME STATION 827 LBL 22 - 26 HAS DENT. MAJOR REPAIR ACCOMPLISHED. INSTALLED ANGLE DOUBLER REPAIR.SDR 2002UALA00915Slat · crackedLEFT HAND WING NR 2 SLAT HAS CRACK IN AFT ROW OF RIVETS. MAJOR REPAIR ACCOMPLISHED. INSTALLED DOUBLER.SDR 2002UALA00914Skin · crackedNR 4 LEADING EDGE SLAT LOWER SURFACE 6-8 INCHES OUTBOARD OF SLAT ACTUATOR SKIN IS CRACKED AT TWO FASTENERS. MAJOR REPAIR ACCOMPLISHED REINFORCEMENT DOUBLER.SDR 2002UALA00910Frame · dentedAFT PIT FRAME STATION 807 AT LBL 24 HAS DENT ON SURFACE. MAJOR REPAIR ACCOMPLISHED. REPAIR DOUBLER WAS MANUFACTURED AND INSTALLED.SDR 2002UALA00909Frame · damagedAFT PIT STATION 747 FRAME INNER FLANGE IS DAMAGED AT STRINGER 19L. MAJOR REPAIR ACCOMPLISHED. REPAIR DOUBLER MANUFACTURED AND INSTALLED.SDR 2002UALA00907Floor Support · corrodedCABIN FLOOR SUPPORT UPPER SURFACE IS CORRODED BODY STATION 285 - 292, RBL 20 - 22, WL 208. MAJOR REPAIR ACCOMPLISHED. REPLACED FLOOR SUPPORT.SDR 2002UALA00904Floorbeam · corrodedSTATION 987 RBL 19 CABIN FLOORBEAM UPPER SURFACE IS CORRODED. MAJOR REPAIR ACCOMPLISHED. INSTALLED ANGLE REPAIR.SDR 2002UALA00903Frame · crackedCABIN BODY FRAME WEB IS CRACKED AT BODY STATION 480 STRINGER 9L. MAJOR REPAIR ACCOMPLISHED. SPLICED BODY FRAME WEB.SDR 2002UALA00902Frame · crackedCABIN BODY FRAME WEB IS CRACKED AT BODY STATION 500A STRINGER 9R. MAJOR REPAIR ACCOMPLISHED. SPLICED BODY FRAME WEB.SDR 2002UALA00901Frame · crackedSTATION 400 FRAME WEB CRACKED AT STRINGER 9R PASSENGER SERVICE UNIT SUPPORT ATTACH RIVET HOLE. MAJOR REPAIR ACCOMPLISHED. INSTALLED DOUBLER REPAIR.SDR 2002UALA00893Crease Beam · corrodedSTATION 927 TO 1006 RIGHT HAND INBOARD CREASE BEAM ANGLE CORRODED. MAJOR REPAIR ACCOMPLISHED. CREASE BEAM AND ANGLE REPLACED.SDR 2002UALA00892Frame · crackedRIGHT HAND OVERWING FUSELAGE FRAME AT BODY STATION 616 IS CRACKED AT INNER CHORD, BELOW BOTTOM FASTENER, JUST BELOW CABIN FLOOR. MAJOR REPAIR ACCOMPLISHED. REPAIR ANGLE DOUBLER AND FILLER MANUFACTURED AND INSTALLED.SDR 2002UALA00891Skin · dentedEXTERNAL FUSELAGE STATION 420 STRINGER 21R SKIN IS DENTED AND CREASED AT STRINGER. MAJOR REPAIR ACCOMPLISHED. INSTALLED SKIN DOUBLER.SDR 2002UALA00883Frame · crackedSTATION 827, STRINGER 9R, FUSELAGE FRAME CRACKED AT RIVET. MAJOR REPAIR ACCOMPLISHED. MANUFACTURED AND INSTALLED FRAME DOUBLER.SDR 2002UALA00877Crease Beam · corrodedCABIN CREASE BEAM ANGLE IS CORRODED FROM STA 270 TO STA 360 RBL 64 TO RBL 53. MAJOR REPAIR ACCOMPLISHED. REPLACED CREASE BEAM.SDR 2002UALA00874Frame · crackedCABIN FRAME AT STATION 847 STRINGER 9R IS CRACKED AT RIVET. MAJOR REPAIR ACCOMPLISHED. FRAME DOUBLER MANUFACTURED AND INSTALLED.
Back to N332UA, cancelled Nov 18, 2008