N902UA, cancelled Oct 29, 2008
Service difficulty reports · 28
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 = 'N902UA' AND deregistration_id = 'N902UA-2008-10-29' 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 = 'N902UA' AND deregistration_id = 'N902UA-2008-10-29' 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 UALA2008111302447Unknown · odorCREW REPORTS FAINT ELECTRICAL BURNING SMELL FROM FORWARD CABIN NEAR DOOR 1 POSSIBLY FROM FWD CABIN SPEAKER, CAPT ADVISED TO OPEN THE PA AMP CB P6-1 D5 IF NECESSARY TO REMOVE POWER FROM THE CABIN SPEAKERS AND WILL LOSE THE CHIME SYS IF IT'S PULLED. F/A REPORTSSDR 2008UALA02464Light · inoperativeFLOOR EEL LIGHTS INOP FROM ROW 16 ON BACK. SUSPECT FAULTY LIGHT ASSEMBLY. REPLACED BAD LIGHT STRIP. OPS CK GOOD.AC OK FOR SERVICE.SDR 2008UALA02447Speaker · odorCREW REPORTS FAINT ELECTRICAL BURNING SMELL FROM FORWARD CABIN NEAR DOOR 1 POSSIBLY FROM FWD CABIN SPEAKER, CAPT ADVISED TO OPEN THE PA AMP CB P6-1 D5 IF NECESSARY TO REMOVE POWER FROM THE CABIN SPEAKERS AND WILL LOSE THE CHIME SYS IF IT'S PULLED.
SDR 2008UALA02403Acm · failedSIGNIFICANT OIL SMELL IN CABIN ON START UP AND DESCENT. FOUND RT AIR CYCLE MACHINE FAILED. REPLACED AIR CYCLE MACHINE.SDR 2008UALA02262Unknown · odorVERY STRONG BURNING RUBBER TYPE ODOR IN FWD CABIN AREA OCCURRED SHORTLY AFTER LANDING GEAR LOWERED, STILL NOTICEABLE AT GATE.SDR 2008UALA00824Attach Angle · crackedMED 1 LT INTERCOSTAL ANGLE CRACKED AT STR 13L. MAJOR REPAIR: STRINGER 13 INTERCOSTAL ANGLE REPLACED.SDR 2008UALA00720Angle · crackedCABIN INTERCOSTAL CRACKED AT STA 300 STR 10 LT. REPAIRED ANGLE.SDR 2008UALA00450Attach Fitting · crackedINTERCOSTAL ATTACH FITTING CRACKED AT STA 360, STR 8L. MAJOR REPAIR: REPLACED INTERCOSTAL ATTACH FITTING.SDR 2008UALA00319Attach Angle · crackedCABIN, INTERCOSTAL CLIP CRACKED AT STA 360, STR 11L. MAJOR REPAIR: INSTALLED NEW INTERCOSTAL ATTACH ANGLE.SDR 2007UALA04145Unknown · odorRAMP REPORTED TO CREW, GOT AN ELECTRICAL-LIKE SMELL IN FORWARD PIT.SDR 2007UALA02588Skin · damagedEXTERIOR SKIN DENTED AND GOUGED AT STA 400 UPPER FWD CARGO CUTOUT. MAJOR REPAIR ACCOMPLISHED: REMOVED CRACKS & ACCOMPLISHED A DOUBLER/TRIPLER REPAIR.SDR 2007UALA02587Door Frame · crackedFWD CARGO DOOR CUTOUT AFT FRAME IS CRACKED IN 3 PLACES, 2 CRACKS ON FWD SIDE OF THE FRAME AT OUTBOARD LOWER CORNER AND INBOARD UPPER CORNER OF BOTTOM STOP FITTING AND THE THIRD CRACK IS ON AFT SIDE OF FRAME IN RADIOUS ADJACENT TO INBOARD UPPER CORNER OF BOTTOMSDR 2007UALA02536Skin · gougedUPPER FUSELAGE EXTERNAL SKIN IS GOUGED AT STA 277 STR 3L. MAJOR REPAIR ACCOMPLISHED: REMOVED DAMAGE. INSTALLED DOUBLER/TRIPLER REPAIR.SDR 2007UALA01837Cable · contaminatedAFT 10 FEET OF FLOOR MOUNTED EMERGENCY ESCAPE PATH LIGHTING IS INOP. FOUND HIGH MOISTURE CONTENT RUNNING THROUGH AFT SECTION OF EEL STRIP. EXPOSED AND DRIED ALL MOISTURE. REPLACED AFT SECTION OF POWER CABLE AND CLEANED LAMP PINS. OP CHECKS OKAY.SDR 2007UALA00389Power Strip · inoperativeEMERGENCY EEL LIGHTING INOP FROM ROW 12 AFT. REPLACED POWER STRIP. REPLACED POWER STRIP.SDR 2005UALA00696Lamp · burned outAISLE ILLUMINATION EMERGENCY LIGHT INOP AT ROW 10 BULLNOSE. REPLACED BURNED OUT LAMP.SDR 2005UALA00062Drain Valve · not closedAT FL250 UNABLE TO HOLD CABIN ALTITUDE. CABIN CLIMBING AT 1000 FPM. DRAIN VALVE IN BOTH THE AFT CARGO PIT AND E/E DOOR NOT CLOSING. LUBED FWD ONE AND CLEANED DEBRIS FROM AFT PIT DOOR VALVE.SDR 2004UALA01191Pump · failedB-ELECTRIC PUMP OVERHEAT LIGHT ILLUMINATED. FUNCTIONAL BENCH TEST FAILED IN THE SHOP. NUMEROUS PARTS REPLACED DURING OVERHAUL OF UNIT (BEARINGS, CYLINDER BLOCK, MATING RING, ETC.).SDR 2004UALA00938Skin · unknownBLEND OUT ON RT FUSE SKIN AT STA 410 STR 26R IS BEYOND LIMITS. INSTALLED DOUBLER AND FILLER REPAIR.SDR 2004UALA00937Skin · damagedRT FUSELAGE SKIN BELOW THE AFT CARGO DOOR FROM STA 820 TO 835 BETWEEN STR 25R AND 26R HAS SEVERAL BLEND OUTS. INSTALLED DOUBLER AND TRIPLER REPAIR.SDR 2004UALA00934Support Beam · crackedRIGHT MLG SUPPORT BEAM TO REAR SPAR FITTING CRACKED. REPLACED MLG SUPPORT BEAM FITTING.SDR 2004UALA00928Stringer Clip · crackedTWO EA STRINGER CLIPS ARE CRACKED AT STA 460 STR 6 LT AND STA 420 STR 4 LT. MAJOR REPAIR ACCOMPLISHED. REPLACED BOTH STRINGER CLIPS.SDR 2003UALA00183Flap · malfunctionedAIRCRAFT MADE A LANDING UNDER AMBER ALERT BECAUSE OF A FLAP SYMMETRY PROBLEM.SDR 2002UALA01159Warning System · activatedFLIGHT HAD SPLIT FLAPS ON FINAL APPROACH, AN AMBER ALERT WAS DECLARED.SDR 2001UALA00777Controller · malfunctionedUNSCHEDULED LANDING DUE TO PRESSURIZATION PROBLEM. SUPPLEMENTAL DATA UPDATE ACCOMPLISHED CHECK OF BOTH PACK SYSTEMS, AND ACCOMPLISHED PRESSURIZATION SYSTEM CHECK. NO DEFECTS NOTED.SDR 2000UALA00745Bulkhead · crackedCRACK FOUND ON THE BODY STATION 178 BULKHEAD WEB. SUPPLEMENTAL DATA UPDATE CRACKS REPAIRED PER BOEING SRM 53-10-08.SDR 2000UALA00456Bearing · failedNUMBER 2 ENGINE HAD VIBRATION. *S/D* THE ENGINE WAS REPLACED.SDR 96UAL900831Keel Beam · corrodedA SMALL AMOUNT OF CORROSION WAS FOUND ON THE LEFT HAND KEEL BEAM OUTBOARD HORIZONTAL FLANGE AT STATION 517. THE CORROSION HAS BEEN REMOVED AND THE RESULTING BLEND IS APPROXIMATELY .75 INCH LONG BY .50 INCH WIDE, AND APPROXIMATELY .022 INCH DEEP. THE CORRODED
Back to N902UA, cancelled Oct 29, 2008