N293AS, cancelled Sep 7, 2011
Service difficulty reports · 95
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 = 'N293AS' AND deregistration_id = 'N293AS-2011-09-07' 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 = 'N293AS' AND deregistration_id = 'N293AS-2011-09-07' 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 C1HA200393004Wire · brokenON GEAR EXTENSION THE RT MAIN LANDING GEAR DOOR ANNUNCIATOR DID NOT ILLUMINATED ON THE S/O PANEL. REPAIRED BROKEN WIRE AT RT MLG DOOR SWITCH PER WDM.SDR C1HA200393001Control Panel · dislodgedENGINE NR 2 SYSTEM A ENGINE FIRE DETECTION ANNUNCIATION POPPED OUT. UNABLE TO LOCATE. R & R FIRE DETECTION CONTROL PANEL IAW M/M 26-11-0. OPS CHECK GOOD.SDR C1HA200393003Connector · contaminatedDURING GEAR EXTENSION RT MLG DOOR WAS SLOW TO ILLUMINATE, BUT CAM ON MOMENTARILY AND THEN OUT NORMALLY. NORMAL INDICATION ON PILOT FRONT PANEL FOUND CONNECTOR PLUG CONTANIMATED CLEANUP CONNECTOR PLUG CYCLE DOOR SEVERAL TIMES OPS CHECKED GOODSDR C1HA200393002Smoke Detector · inoperativeA/C AFT LAVATORY SMOKE DETECTION INOPERATIVE, OPS CHECK GOOD. COULD NOT DUPLICATE REPORTED PROBLEM.SDR C1HA200293012Apu · fireAPU FIRE BOTTLE DISCHARGEDREMOVED AND REPLACED APU FIRE BOTTLE PER MM 26-23-1.SDR C1HA200293011Frame · corrodedFRAME AT STA 310 RIGHT IS EXFOLIATED AT LOWER END WHERE IT MEETS T-CHORD. TEMP REPAIR IAW AVIATION ENGINEERING MRB NR AAR 1004-02.SDR C1HA200293010Door Frame · corrodedFRAME CORRODED AT FORWARD END OF OPENING FOR E/E DOOR. REMOVED AND REPLACED THE FRAME FORWARD OF E/E BAY DOOR OPENING IAW SRMS 51-10-1, 51-30-2, AND 51-10-2.SDR C1HA200293009Floorbeam · corrodedT-CHORD CORRODED AT STA 328 AS VIEWED FROM FUSELAGE INTERIOR ON RT SIDE.SDR C1HA200293008Battery PackBATTERT PACK POWER SUPPLY FOR L/H & R/H AFT SERVICE DOORS INOP ESCAPE SLIDE LIGHTREMOVED AND CHARGED AND REINSTALLED SLIDE LIGHT EMERGENCY BATTERY PACKSDR C1HA200293007Warning System · activatedAFTER T/O LG FAILED TO RETRACT NORMALLY, LEFT GEAR RED AND GREEN LIGHT ILLUMINATED IN THE OFF POSITION. RETURNED TO STL. RESET LT MLG UPLOCK IAW 32-32-51. NOT ABLE TO JACK A/C, NEED INFLIGHT FUNCTIONAL CHECK OF LT MLG UPLOCK.SDR C1HA200293006MotorENROUTE SYSTEM A QAUNITY WENT ZERO FOLLOWED BY ENG 1 HYD A LOW PRESSURE AND ENG 2 HYD A LOW PRESSURE LIGHTS ILLUMINATED. HYD SYSTEM A FLUED LOSS CHECKLIST WAS PERFORMED. NO HYD SYSTEM A OVERHEAT LIGHT ILLUMINATION.REINSPECTED AND FOUND OUTB FLAP HYDRAULIC DRSDR C1HA200293005SwitchAMBER LEADING EDGE FLAP LIGHT REMAINED ON DURING FLAP EXTENSION. FLAP LEADING EDGE #1 ON ANNUNCIATOR PANEL ON. PERFORMED COM PROCEDURE. LANDED NO INCIDENT.SDR C1HA200293004Smoke Detector · inoperativeLeft aft lavatory smoke detector will not silence. No smoke noted in lavatory. Removed and replaced battery in lavatory smoke detector. Operationally checks good.SDR C1HA200293003Flow Valve · inoperativeDuring climbout, unable to pressurize cabin above 1 PSI diff. Action Taken: Removed and replaced right flow control valve. Ops and leak check good on ground IAW MM 36-10-02.SDR C1HA200293002Door · not closedAFTER DEPARTING F/E COULD NOT CONTROL CABIN PRESSURIZATION. F/A REPORTED LOUD NOISE WAS COMING FROM DOOR L-2. NO INDICATION OF L2 OPEN ON F/E PANEL. DIVERTED TO MCO AND MADE OVERWEIGHT LANDING. LANDING WAS SMOOTH. L2 DOOR FOUND TO BE IMPROPERLY CLOSED. DSDR C1HA200293001Battery Pack · dischargedMID CABIN CEILING EMERGENCY EXIT SIGN INOPERATIVE. REMOVED AND REPLACED BATTERY PACK IAW 727 MM 33-50-71, SYSTEMS CHECKS GOOD.SDR C1HA200193018Latch · failed1L DOOR SLIDE NEEDS TO BE FIXED SO IT STAYS IN. BOX KEEPS FALLING OUT OF BOTTOM. REPLACED SLIDE LATCH ASSEMBLY. OPS CHECKS GOOD.SDR C1HA200193017Oil Filter · clogged#2 filter bypass light illuminated returned to gate.ACTION TAKEN:Removed and inspected main oil filter found to have evedence of coking replaced filter.SDR C1HA200193016Clamp · looseUpon initial power reduction #1 eng strut overheat illuminated all eng parameters normal during running pocedure the light went out was on for about 1 min. never reilluminated during decent approach &final.ACTION TAKEN:inspected #1 engine strut area found clamSDR C1HA200193015Flow Valve · failedCould not control pressurization after takeoff in all modes. Overweight landing made at 175,000lbs. back at MSP.ACTION TAKEN:R&R'd L/H flow control valve pressurized A/C ops check normal A/C OK for service. Also secured ground wire. Overweight landing inspectiSDR C1HA200193014Overheat Loop · out of positionNR 1 STRUT OVERHEAT AT FL330, REDUCED PWR TO 80 PERCENT LIGHT WENT OUT. REPOSTIONED LOOP FOR STRUT OVERHEAT PER MM 36-22-1, OPS CHECKED GOOD.SDR C1HA200193013Clamp · looseAT FL330 eng #1 strut overheat lite on followed COM pulled pwr back to 85% N1 on descent and lite went out at FL 290.ACTION TAKEN:Removed lwr pylon panels found pre-cooler clamps loose tightened leak checked and no leaks noted reinstalled panels OK for serviceSDR C1HA200193011SwitchRt. MLG unsafe lite illuminated during taxi.ACTION TAKEN:Pinned gear adjusted RT.MLG downlock switch actuator checks normal removed gear pins.SDR C1HA200193010Slide · out of positionESCAPE SLIDE CAME OUT OF CASING ON L-1 DOOR DURING FLIGHT. REINSTALLED SLIDE PER MM.SDR C1HA200193009Light · inoperativeCockpit portable emergency lighjt inop.ACTION TAKEN:R&R'd emergency light ops ck good.SDR C1HA200193008Oxygen Mask · deployedWHILE ON GROUND IN CANCUN. PASSENGER OXYGEN SYSTEM FELL (PRESSURIZED). RESET PAX O2 LEVER. REINSTALLED ALL O2 MASKS. O2 PRESSURE NORMAL.SDR C1HA200193007Switch · out of adjAFT AIRSTAIR DOOR LIGHT ILLUMINATED IN FLIGHT VISUALLY INSPECTED DOOR CONFIRMED CLOSED. ADJUSTED AIRSTAIR SWITCH, OPS CHECK GOOD.SDR C1HA200193006Switch · out of adjAFT AIRSTAIR AMBER LIGHT ILLUMINATED IN FLIGHT EN ROUTE TO DFW CONTINUED FLIGHT PER COM 2.52.2. ADJUSTED WARNING LIGHT SWITCH AT UPPER HANDLE, CHECKS GOOD.SDR C1HA200193005Power Supply · dischargedR2, L2, AND AFT ENTRY EMERGENCY EXIT SIGNS INOP. REMOVED AND REPLACED BATTERY POWER SUPPLY, OPS CHECKS GOOD.SDR C1HA200192004Power Supply · dischargedR2, L2, AND AFT ENTRY EMERGENCY EXIT SIGNS INOP. REMOVED AND REPLACED BATTERY POWER SUPPLY, OPS CHECKS GOOD.SDR C1HA200193004Transmitter · failedNR 1 EPR GAUGE INOP AT TAKEOFF. ABORTED TAKEOFF 70KIAS. REMOVED AND REPLACED EPR TRANSMITTER, OPS CHECKED GOOD.SDR C1HA200193003Wire · detachedFLIGHT ATTENDENT SMELLED SMOKE IN AFT GALLEY ON APPROACH INTO PUJ. UPON LANDING FOUND A WIRE HANGING IN AFT GALLEY COMPARTMENT BELOW COFFEEMAKER. FOUND WIRE PULLED OFF HOT PLATE TERMINAL REPAIRED WIRE, OPS CHECKED NORMAL.SDR C1HA200193002Battery Pack · discharged2R EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED BATTERY PACK.SDR C1HA200193001Light · inoperative1L EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT ASSY.SDR C1HA200093009Circuit Breaker · weakLEFT AFT BOOST PUMP TANK NR 2 C/B POPPED ON DEPARTURE. AIR RETURN. R&R C/B CHECKS GOOD.SDR C1HA200093008Circuit Breaker · weakNR 2 TANK RIGHT AFT BOOST PUMP C/B TRIPPED ON DEPARTURE. AIR RETURN. R&R RIGHT AFT BOOST PUMP C/B.SDR C1HA200093007Throttle · binding#1 eng throttle binding.Do not have full motion.ACTION TAKEN:checked rig and lubed throttle quadrant. OPs checked goodSDR C1HA200093006Pump · failedBOTH AFT BOOST PUMPS, TANK 2 CBS POPPED. INSPECTED C/B, WIRING AND PUMPS FOR AFT NR 2 TANK PER MM REVISION NOTICE 727-211. COULD NOT DUPLICATE, OPS CHECK NORMAL.SDR C1HA200093005Control Panel · erraticWITH AUTO PRESSURIZATION ON MEL; CABIN PSI FLUCTUATES +-800 IN STBY. SELECTED AC FLUCTUATION INCREASED TO +-1500, SAME WHEN DC SELECTED. DIVERT TO MSP FOR REPAIR. REMOVED AND REPLACED CABIN PRESS CONTROLLER FOR AUTO PRESS MEL. REMOVED AND REPLACED CABIN PRSDR C1HA200093004Wire · failedFWD EMERGENCY FLOOR LIGHT STRIP NOT ILLUMINATING. REINSTALLED WIRE AT TERMINAL, OPS CK NORMAL.SDR C1HA200093003Window · brokenAT 29.0 FL LOUD BANG HEARD. PAX NOTICED OUTER WINDOW AT ROW 13A MISSING. NO CABIN PSI CHANGE. RE-LOCATED PAX AND COMPLIED WITH ABNORMALS. MADE PRECAUTIONARY DESCENT TO 23.0 AND REDUCED CABIN DIF PSI. AFTER LANDING CONFIRMED SEAT ROW 13A (WINDOW 18 LT) OUTSDR C1HA200093002Smoke · detectedELECTRICAL SMOKE AND SMELL EMANATING FROM AFT GALLEY. THREE HALON EXTINGUISHERS DISCHARGED.SDR C1HA200093001Fuel Control · blockedDURING TAKEOFF ROLL, ENGINE NR 1 EPR, N1, N2, FUEL FLOW FLUCTUATED. FUEL CONTROL MOISTURE TRAP HAD PLUGGED ORIFICE.SDR 96ZZZM251Switch · failedFKYC NR 9170 - KFLL-KMIA - AFTER TAKEOFF ON FLAP RETRACTION NR 4 KRUEGER FLAP INDICATION REMAINED AMBER. CYCLED FLAPS, NO HELP. RETURNED AIRCRAFT TO DFLL. MAINTENANCE REPLACED NR 4 LEADING EDGE FLAP POSITION SWITCH PER MAINTENANCE MANUAL CHAPTER 27. CYCLEDSDR 96ZZZM878Rod End · corrodedLEFT WING INBOARD FLIGHT SPOILER NR 5 ACTUATOR INPUT ROD END BEARING CORRODED. REPLACED ACTUATOR ROD PER MM 27-61-9 AND OPS CHECKED SPOILERS PER MM 27-61-00 PQ 530 TO 531 FIG 515, NR 5 PANEL OPS CHECKED GOOD. (M)
Back to N293AS, cancelled Sep 7, 2011