N301UA, cancelled Mar 18, 2013
Service difficulty reports · 50
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 = 'N301UA' AND deregistration_id = 'N301UA-2013-03-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 = 'N301UA' AND deregistration_id = 'N301UA-2013-03-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 2008UALA03416Lamp · burned outNR 2 FIRE HANDLE LIGHT OUT. FOUND BURNED OUT LAMP. REPLACED LAMP OP CHECKED GOOD. AC OK FOR SERVICE.SDR 2008UALA03428Skin · crackedFUSELAGE SKIN CRACKED LEFT SIDE OF FUSELAGE AT STATION 510 BETWEEN WINDOWS.SDR 2008UALA03380Structure · crackedTHE 520 STR 12L HAS DAMAGE. MAJOR REPAIR ACCOMPLISHED: MANUFACTURED & INSTALLED 1EA DOUBLER, 1EA TRIPLER AND APPLIED PRIMER.SDR 2008UALA03339Unknown · odorACRID SMOKEY SMELL RETURNED UPON LANDING.SDR 2008UALA02146Lamp · inoperativeLT OVERWING EXIT LIGHT INOP. RELAMPED. OPS CHKS GOOD.SDR 2008UALA02145Feeder Cable · damagedAFT CABIN EEL LIGHTING INOPERATIVE. REPLACED AFT SECTION POWER LEAD & AFT GALLEY EEL LIGHT. OPS CKS GOOD.SDR 2007UALA04705Skin · damagedRIGHT LEADING EDGE SKIN UPPER SURFACE CRACKED AND SEPARATED, AND GOUGED ABOVE NR 4 SLAT.SDR 2007UALA04704Door Frame · crackedFWD CARGO DOOR CUTOUT, FWD FRAME CRACKED AT INNER CHORD RADIUS ABOVE LWR DOOR STOP FITTING, AT BS 440 STR 24R. REMOVED DAMAGE. INSTALLED ANGLE DOUBLER REPAIR.SDR 2007UALA04703Skin · misrepairedBS 380 AT E&E COMPARTMENT EXHAUST OUTLET LOWER EXTERNAL FUSELAGE SKIN EXISTING REPAIR IS INSUFFICIENT. REMOVED PREVIOUS REPAIR. INSTALLED NEW LARGE AREA DOUBLER AND PREVENTATIVE RAIDO ALTIMETER CUTOUT DOUBLER.SDR 2007UALA04688Door Frame · damagedFWD CARGO DOOR, AFT FRAME LWR OF CUTOUT, HAS TEMP REPAIR PER EVA. SUPPLEMENTAL DATA UPDATE:REPLACED FWD CARGO DOOR AFT FRAME.SDR 2007UALA04676Skin · crackedRT HORIZ STAB LOWER SURFACE SKIN CRACKED AT STAB STA 125, JUST FWD OF REAR SPAR. REMOVED CRACK. FABRICATED 2 ACCESS HOLES AND COVERS TO FACILITATE REPAIR. FABRICATED AND INSTALLED EXTERNAL DOUBLER ON LOWER STAB SKIN NEAR REAR SPAR.SDR 2007UALA03263Inverter · inoperativeLEFT EMERGENCY EXIT IND LIGHT INOP, NEEDS INVERTER. REPLACED LT MID EMERGENCY EXIT INVERTER. OPS NORMAL.SDR 2007UALA03262Light · inoperativeRIGHT AFT EMERGENCY EXIT IND LIGHT INOP. REPLACED LIGHT ASSY REF:WD M33-51-15.SDR 2007UALA02630Sign · inoperativeEMERGENCY EXIT MARKER INOP AT SEAT 9B. [07-27-07] SECURED CONNECTOR OPS CKS NORMAL.SDR 2007UALA02450Fire Bottle · lowCREW REPORTS, THE APU FIRE EXTINGUISHER PRESSURE IS AT OR NEAR 300 PSIG (LOW). [07-27-07] REPLACED APU FIRE EXTINGUISHER BOTTLE.SDR 2007UALA02093Hydraulic System · leakingRTFL DUE TO HYDRAULIC QUANTITY LOSS ON CLIMBOUT. [07-06-07] FOUND RIGHT WING HYDRUALIC LINE GOING TO MAIN GEAR RETRACTING ACTUATOR LEAKING. REPLACED HYDRAULIC LINE.SDR 2007UALA01943Cable · defectiveAFT SECTION CABIN EMERGENCY EEL LIGHTS INOPERATIVE. REPLACED AFT EEL CABLE SECTION. OP CHECKS GOOD.SDR 2007UALA01250Slide · out of positionDOOR 2R SLIDE PACK COMING OUT OF CONTAINER. [SUP 05-16-07] REPLACED SLIDE ASSEMBLY.SDR 2007UALA01035Fuel Filter · unknownNR 2 FUEL TANK FILTER BYPASS LITE ILLUMINATED ON INITIAL CLIMBOUT. FOUND FUEL FILTER CLEAN. DIFFERENTIAL PRESSURE SWITCH WARNING TEST CHECKED GOOD. REPLACED FUEL FILTER.SDR 2007UALA01005Slide · unsecureSLIDE PACK 1L HAS EXCESS FABRIC BELOW GIRT BAR DRAGGING ON FLOOR. [SUP 5-1-07] REPACKED BOTTOM SECTION OF SLIDE.SDR 2007UALA00078Skin · crackedDOOR 2R CUTOUT LOWER FWD CORNER 2.75 INCH CRACK. MAJOR REPAIR: REMOVED DAMAGE. STOP DRILLED AND PLUGGED BEAR STRAP. FABRICATED AND INSTALLED REPAIR DOUBLER.SDR 2006UALA02224Light · inoperativeROW 19 LT STOWAGE BIN BULL NOSE EEL LIGHT IS INOP. REPLACED LIGHT.SDR 2006UALA02223Sign · inoperativeLEFT LOWER OVERWING EMERGENCY EXIT SIGN IN INOP. REPLACED EXIT SIGN.SDR 2006UALA02222Light · inoperativeRIGHT LOWER EMERGENCY SLIDE LIGHT JUST AFT OF FLAPS IS INOP. REPLACED LIGHT.SDR 2006UALA02001Light · inoperativeEEL LIGHTS OUT ON LAST 10 ROWS ON AIRCRAFT. REPLACED CABLE.SDR 2006UALA01827Skin · crackedON WALK AROUND, FOUND 3-8 INCH CRACK ON RIGHT HORIZ STAB LEADING EDGE APPROX 6FT FROM INBD SIDE. MAJOR REPAIR: REPAIRED RIGHT HORIZONTAL STAB LEADING EDGE PER SRM 55-10-01.SDR 2006UALA01115Skin · dentedDENT FOUND JUST AFT OF DOOR 2L ON LAP JOINT.SDR 2006UALA01038Door Frame · crackedFWD PIT AFT DOOR OPENING AFT FRAME STA 492.4 CRACKED AT STA 24R.SDR 2006UALA00970Door Frame · crackedFWD PIT AFT DOOR OPENING AFT FRAME STA 492.4 CRACKED AT STR 24R.SDR 2006UALA00028Light · inoperativeEMERGENCY EXIT LIGHTS ON FLOOR ARE INOP FROM ROW 16 AFT.SDR 2005UALA00295Wire · damagedEMERGENCY LIGHT DIM FROM ROW 13ABC TO AFT GALLEY. REPLACED POWER CABLE.SDR 2004UALA01112Skin · crackedFWD GALLEY DOOR EXT SKIN IS CRACKED AT THE LWR HINGE CUTOUT. TRIMMED OUT DAMAGE AND INSTALL REPAIR DOUBLER.SDR 2004UALA01121Bear Strap · damagedAFT CARGO DOOR BEAR STRAP REPAIR NEEDS TO BE REPLACED AT BS 847 STR. 23R. SUPPLEMENTAL DATA UPDATE MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED REPAIR DOUBLER.SDR 2004UALA01120Bear Strap · damagedREPAIR AT AFT CARGO DOOR BEAR STRAP BS 807 ABOVE STR 25 RT AT CARGO DOOR OPENING IS INSUFFICIENT. FABRICATED EXTERNAL DOUBLER,TRIPLER AND FILLER AND INSTALLED,SDR 2004UALA01022Frame · crackedFRAME WEB IS CRACKED AT STA 194 AT LBL 16 AND WL 208. FABRICATED AND REPLACED SHEAR WEB.SDR 2004UALA01011Stringer · dentedSTRINGER 13L HAS 2 DENTS AT BS 1025 AND 1030. REMOVED DAMAGED SECTION OF THE STRINGER AND FABRICATED AND INSTALLED STRINGER AND SKIN DOUBLER.SDR 2004UALA01013Frame · crackedFUSELAGE FRAME CRACKED AT BS 188 WL 208.1 LT SIDE. INSTALLED REPAIR ANGLE.SDR 2004UALA01012Skin · puncturedNR 1 ENG INLET COWL OUTER SURFACE PUNCTURED-DELAMINATED AT THE 2 O`CLOCK POSITION APPROXIMATELY 30 INCHES FROM FWD END. DAMAGE WAS FOUND ON INLET COWL WAS PERMANENTLY REPAIRED.SDR 2004UALA00988Pressure Panel · crackedSTA 664 PRESSURE WEB IS CRACKED AT LBL 31 JUST FWD OF AIL TOWER SHAFT. *S/D* MAJOR REPAIR ACCOMPLISHED. CUT OUT DAMAGE AND INSTALLED REPAIR DOUBLER.SDR 2004UALA00980Skin · damagedSKIN AT STA 360-380 AND STR 16L-17L IS DAMAGED. INSTALLED DOUBLER AND TRIPLER REPAIR.SDR 2004UALA00981Pin · wornRT MLG TRUNNION PIN HAS CHROME WORN OFF END. REPLACED TRUNNION PIN.SDR 2003UALA00394Wire · defectiveEMERGENCY EXIT LIGHTING (EEL) AFT OF ROW 16 WAS INOPERATIVE. *S/D* REPLACED 18 FT SECTION OF EEL CABLE.SDR 2003UALA00371Power Supply · inoperativeFLIGHT CREW REPORTED THAT AFT SECTION OF FLOOR EEL INOPERATIVE. REPLACED AFT EEL POWER STRIP.SDR 2003UALA00370Fuse · failedDURING PREFLIGHT INSPECTION CREW REPORTED EEL (AISLE) LIGHTS INOP ROW 15 TO REAR OF CABIN. REPLACED FUSES ON AFT BATTREY PACKSDR 2003UALA00232Light · shortedEMERGENCY EXIT FLOOR LIGHTING (EEL) NOT VISIBLE FROM ROW 15 AFT. FOUND AFT GALLEY SHORTING THAT PORTION OUT. REPLACE AND GROUND CHECKS OKAY.SDR 2001UALA00288Adc · failedLOSS OF THE CAPTAINS INSTRUMENTS. SUPPLEMENTAL DATA UPDATE FOUND THE CAPTAINS DIGITAL AIR DATA COMPUTER (DADC) TO HAVE FAULTS. REPLACED THE NR 1 DADC AND CONDUCTED AN OPERATIONAL CHECK.SDR 97UAL900017Air Distr · odorCREW REPORTS, AIR SMELLING FUNNY, NAUSEA, EYES BURNING DURING FLIGHT.SDR 96UAL901012Battery Pack · dischargedEEL LIGHT INOP, ROW 3 THROUGH 9. REPLACED BATTERY PACK M1134, OPS CHECK GOOD.SDR 95UAL900296Eel Strip · inoperativeEMERGENCY ESCAPE PATH LIGHTING INOP AT ROWS 19 AND 20. RERPLACED LIGHT STRIP. CHECKS O.K.SDR 95UAL737070Boot · looseAUDIBLE SHUDDER OCCURRED AFTER LIFT OFF, ACCOMPANIED BY AIRFRAME SHUDDER. OCCURRED AT FIRST POWER REDUCTION. VIBRATION CONTINUED UNTIL AIRCRAFT RETURNED TO ORD. SECURED RIGHT PACK PRESSURIZATION BOOT AT FORWARD END OF PACK BAY.
Back to N301UA, cancelled Mar 18, 2013