N8932E, cancelled Aug 21, 2013
Service difficulty reports · 81
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 = 'N8932E' AND deregistration_id = 'N8932E-2013-08-21' 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 = 'N8932E' AND deregistration_id = 'N8932E-2013-08-21' 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 9700699996T-Duct · lack of lubeRIGHT SLAT FAILED TO EXTEND DURING APPROACH. SUCCESSFUL LANDING WAS ACCOMPLISHED USING FLAPS ONLY. MAINTENANCE INSPECTED T-DUCTS, SLAT TRACKS AND PULLEYS, ALL WERE FOUND TO BE NORMAL. LUBED T-DUCTS AS A PRECAUTION, DEFERRED TO NEXT OVERNIGHT MAINTENANCE AN SDR 9625739996Downlock Switch · malfunctionedDURING APPROACH, NOSE LANDING GEAR GREEN LIGHT DID NOT ILLUMNATE AFTER GEAR EXTENSION. RECYCLED GEAR THREE TIMES BEFORE NORMAL INDICATIONS WERE ACHIEVED. AIRCRAFT LANDED WITHOUT INCIDENT. FERRIED AIRCRAFT FROM GRR TO DTW. MAINTENANCE REPLACED NOSE GEAR DOWSDR 9625729996Clamp · brokenLOSS OF CABIN PRESSURIZATION OCCURRED AT 25,000 FEET EN ROUTE. OXYGEN MASKS WERE DEPLOYED THROUGHOUT CABIN AND DESCENT WAS MADE TO 10,000 FEET. FLIGHT DIVERTED TO DTW AND LANDED WITHOUT INCIDENT. MAINTENANCE FOUND BROKEN CLAMP AND DUCT LEAK AT RIGHT AIR CYCSDR 9624819996Bulkhead Fitting · crackedDURING H-CHECK, FOUND CRACKS IN FS 756 CENTER LINE BULKHEAD FITTINGS: SECOND, THIRD AND FOURTH FROM THE TOP. REPLACED ALL FITTINGS (P/N 9958212-37) PER SRM 51-30-5.SDR 9620029996Light · inoperativeDURING LINE MAINTENANCE INSPECTION, FOUND LEFT NACELLE EMERGENCY LIGHT INOPERATIVE. PROBLEM COULD NOT BE DUPLICATED.SDR 9617659996Longeron · corrodedDURING M-CHECK, FOUND CORROSION ON LONGERON 19L AT FS 905. REPAIRED LONGERON PER EA DC9-53-028.SDR 9617229996Battery Pack · malfunctionedDURING PERIODIC CHECK, FOUND EMERGENCY LIGHT SWITCH AT FORWARD FLIGHT ATTENDANT PANEL INTERMITTENT BETWEEN ARM AND ON POSITION. REPLACED BATTERY PACK, OPERATIONAL CHECK NORMAL.SDR 9617219996Power Supply · malfunctionedDURING PERIODIC CHECK, FOUND LEFT NACELLE EMERGENCY LIGHT INOPERATIVE. REPLACED BATTERY POWER SUPPLY, OPERATIONAL CHECK NORMAL.SDR 9617609996Floor Beam · crackedDURING M-CHECK, FOUND A CRACK IN THE FS 237 FLOOR BEAM AT LBL 27. REPAIRED BEAM PER EA DC9-53-025.SDR 9617589996Fitting · brokenDURING M-CHECK, FOUND THE EAR BROKEN OFF OF THE FS 889 FRAME TO FLOOR BEAM ATTACH FITTING BENEATH THE LEFT CUSP WEB. REPLACED FITTING (P/N 3919749-1) PER SRM 51-10-2.SDR 9617419996Door · out of adjustDURING M-CHECK, FOUND THAT INADEQUATE FORCE WAS REQUIRED TO OPERATE ALL FOUR OVERWING EMERGENCY EXIT DOORS. ADJUSTED DOORS PER MM 52-21-0.SDR 9616769996Fitting · corrodedDURING M-CHECK, FOUND CORROSION IN THE RIGHT CUSP FITTING AT FS 229, LONGERON 18R. REPLACED FITTING (P/N 4912772-504N) PER SRM 51-30-1.SDR 9608209996Battery · dischargedDURING LINE MAINTENANCE INSPECTION, FOUND AFT OVERWING EMERGENCY EXIT SIGN LIGHTS INOPERATIVE. REPLACED BATTERY IN BATTERY PACK. OPERATIONAL CHECK NORMAL.SDR 9607029996Vent Valves · openFUEL BEGAN VENTING FROM THE RIGHT WING AFTER TAKEOFF. THE LEFT FUEL QUANTITY DROPPED 800 LBS BELOW RIGHT SIDE. BOTH FUEL QUANTITIES WERE BELOW 8,800 LBS. FLIGHT RETURNED TO YUL AND LANDED WITHOUT INCIDENT. MAINTENANCE RESET CLIMB VENT VALVES.SDR 9520729996Coalescer Bag · dirtyDURING CRUISE, THE CABIN PRESSURE WARNING LIGHT ILLUMINATED AND CABIN PRESSURE BEGAN TO CLIMB. DESCENDED TO 10,000 FEET AND THE LIGHT EXTINGUISHED AND AIRCRAFT MAINTAINED NORMAL CABIN PRESSURE. AIRCRAFT DIVERTED TO DFW AND LANDED WITHOUT INCIDENT. REPLACED SDR 9520089996Door · not latchedDURING CLIMB, THE FORWARD ACCESSORY COMPARTMENT DOOR LIGHT ILLUMINATED AND AIRCRAFT WOULD NOT PRESSURIZE. AIRCRAFT RETURNED TO DTW AND LANDED WITHOUT INCIDENT. FOUND FORWARD ACCESSORY COMPARTMENT DOOR OPEN. SECURED DOOR. OPERATIONAL CHECK GOOD.SDR 9520039996Oxygen Reg · leakingDURING CRUISE, CREW OXYGEN DEPLETED. THE AIRCRAFT DIVERTED TO STL AND LANDED WITHOUT INCIDENT. FOUND CAPTAIN'S OXYGEN REGULATOR LEAKING. REPLACED REGULATOR AND OXYGEN BOTTLE. OPERATIONAL CHECK GOOD.SDR 9518759996Battery Pack · dischargedDURING LINE CHECK, FOUND OVERHEAD EMERGENCY LIGHTS FROM ROWS 6 THROUGH 12 INOPERATIVE. REPLACED BATTERIES, OPERATIONAL CHECK GOOD.SDR 9518749996Eel Socket · brokenDURING LINE CHECK, FOUND FORWARD AISLE EMERGENCY LIGHT AT STATION 232 INOPERATIVE. REPLACED BROKEN BULB SOCKETS AND OPERATIONAL CHECK GOOD.SDR 9509229996Skin · corrodedDURING LINE CHECK, FOUND CORROSION AND SHEARED FASTENERS IN THE FUSELAGE SKIN FS 332 AT LONGERON 29L TO 30. REPAIRED PER EA 99-98462.SDR 9504519996Angle · crackedDURING PERIODIC CHECK, FOUND CRACK IN VERTICAL STABILIZER TO FUSELAGE ATTACH ANGLE FS 1096 RIGHT SIDE. REPAIRED PER EA 99-097062, FIG.1.SDR 9504029996Release Mech · out of adjustDURING PERIODIC CHECK FOUND THAT INADEQUATE FORCE WAS REQUIRED TO RELEASE THE HANDLE FROM THE CLIPS AND DROP THE TAILCONE. ADJUSTED THE LATCHES AND THE CLIPS. CHECKED OK.SDR 9503979996Fitting · corrodedDURING PERIODIC CHECK FOUND CORROSION IN LONGERON 30 END FITTING AT FS 598. REPLACED PER SRM 51-30-0.SDR 9503969996Fitting · corrodedDURING PERIODIC CHECK FOUND CORROSION IN LONGERON 29R END FITTING AT FS 604. REPLACED PER SRM 51-30-3.SDR 9503959996Fitting · crackedDURING PERIODIC CHECK FOUND CRACK IN LONGERON 27L END FITTING AT FS 579. REPLACED PER SRM 51-30-0.SDR 9503939996Fitting · corrodedDURING PERIODIC CHECK FOUND CORROSION IN THE RIGHT SIDE KEEL FITTING AT FS 756. REPLACED FITTING PER 51-30-0 AND SB 53-75.SDR 9504509996Doubler · brokenDURING PERIODIC CHECK, FOUND BROKEN DOUBLER AT FS 1084, LONGERON 18L. REPAIRED PER EA 99-097155.SDR 9503929996Fitting · crackedDURING PERIODIC CHECK FOUND CRACK IN FLOOR SUPPORT FITTING, LONGERON 28R AT FS 996. REPLACED FITTING PER SRM 51-30-0.SDR 9503919996Fitting · crackedDURING PERIODIC CHECK FOUND CRACK IN LONGERON 28R END FITTING AT FS 984. REPLACED FITTING PER SRM 51-30-0.SDR 9503649996Fitting · crackedDURING PERIODIC CHECK, FOUND CRACKED FITTING AT FS 604 AT LONGERON 24R. REPLACED FITTING PER SRM 51-30-2.SDR 9500709996Latch Bolts · looseDURING APPROACH INTO MSP, GEAR DOOR OPEN LIGHT REMAINED ON AFTER GEAR WAS EXTENDED. EMERGENCY GEAR EXTENSION PROCEDURES WERE UTILIZED AND AIRCRAFT LANDED WITHOUT INCIDENT. EMERGENCY EQUIPMENT WAS CALLED OUT ON STANDBY AS A PRECAUTION. FOUND LEFT MAIN INBOAR
Back to N8932E, cancelled Aug 21, 2013