N328JS, cancelled Nov 26, 2008
Service difficulty reports · 62
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 = 'N328JS' AND deregistration_id = 'N328JS-2008-11-26' 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 = 'N328JS' AND deregistration_id = 'N328JS-2008-11-26' 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 VNAA9704004Controls · stiffAT 200 AGL, THE RUDDER BECAME VERY STIFF. AIRCRAFT CONTINUED AND LANDED WITHOUT FURTHER INCIDENT. ON THE GROUND, THE PILOT REPORTED THAT THE RUDDER WAS STILL STIFF. MAINTENANCE PERFORMED A COMPLETE RUDDER SYSTEM AND RUDDER AUTO-PILOT SYSTEM OPERATIONAL CHECSDR VNAA9612009Boost Pump · failedON TAKEOFF ROLL, RECEIVED A EL PUMP FAIL CAS MESSAGE ON LT SIDE. ABORTED TAKEOFF AND RETURNED TO THE GATE WITHOUT FURTHER INCIDENT. MAINTENANCE REMOVED AND REPLACED THE LT ELECTRIC BOOST PUMP, OPERATIONAL CHECKED GOOD.SDR VNAA9610005Cover · crackedAFTER DEPARTURE, A LOAD SQUEAL STARTED COMING FROM THE COCKPIT EMERGENCY ESCAPE HATCH. AIRCRAFT RETURNED TO FIELD WITHOUT FURTHER INCIDENT. UPON INSPECTION, MAINTENANCE DETERMIND THAT THE ACRYLIC COVER ON THE ESCAPE HATCH HAD BROKEN. MAINTENANCE REMOVED ANDSDR VNAA9606009Propeller · lightning strikeEN ROUTE, FLYING AT FL160 THROUGH LIGHT RAIN, CREW REPORTED HEARING A LOUD BANG FOLLOWED IMMEDIATELY BY A BRIGHT FLASH OF LIGHT. CREW CONTINUED ON WITH THE FLIGHT AND LANDED IN PIT WITHOUT FURTHER INCIDENT. PIT MX CONDUCTED A LIGHTNING STRIKE INSPECTION IAW SDR VNAA9600039Connector · looseLEFT ENGINE TORQUE INDICATOR SURGED AND PROPELLER RPM INDICATOR FLUCUATED DURING TAKEOFF. CREW CONTINUED ON WITH THE TAKEOFF. THE FLUCUATION AND SURGE PROBLEMS CONTINUED AFTER T/O. THE CREW ELECTED TO RETURN TO THE FIELD. AIRCRAFT LANDED WITHOUT FURTHER INSDR 96ZZZX1323Computer · malfunctionedPIT/LAN - FLT 4037 - EN ROUTE, BOTH OF THE FIRST OFFICER'S DISPLAY UNITS (PRIMARY AND MULTIFUNCTION FLIGHT DISPLAY UNITS) FAILED. DURING THE COURSE OF ACCOMPLISHING THE ABNORMAL FLIGHT PROCEDURES CHECK LIST, THE CREW DISCOVERED THE NR 2 INTEGRATED AVIONICS COSDR 96ZZZM642Uplock Roller · dirtyFLT NR 4160 - AFTER TAKEOFF, WHEN THE LANDING GEAR WAS RETRACTED, THE LEFT MAIN LANDING GEAR INTRANSIT LIGHT REMAINED ILLUMINATED. AIRCRAFT RETURNED TO THE FIELD, LANDED WITHOUT FURTHER INCIDENT. PIT MAINTENANCE CLEANED AND LUBRICATED THE MAIN LANDING GEAR USDR 96ZZZX335Uplock Rollers · dirtyFLT 4014 - AFTER TAKEOFF WHILE RETRACTING LANDING GEAR, RIGHT MLG INTRANSIT LIGHT WOULD NOT EXTINGUISH. AIRCRAFT RETURNED TO FIELD, AND LANDED WITHOUT FURTHER INCIDENT. PIT MAINTENANCE INSPECTED BOTH RIGHT AND LEFT MLG WHEELWELLS AND DISCOVERED GEAR UPLOCK RSDR 96ZZZM25Eec Connector · dirtyFLT NR 4038 - CREW WAS ALERTED BY ELECTRONIC ENGINE CONTROL FAIL INDICATION LEFT SIDE. ELECTED TO RETURN TO GATE. OUT STATION MAINTENANCE CLEANED THE EEC CANNON PLUG CONNECTORS IAW MM 72-00-00. GROUND RUNS CHECKED GOOD. AIRCRAFT RETURNED TO SERVICE.SDR 95ZZZX6213Connector · dirtyDAY/PHL - FLT 4149 - EN ROUTE, CREW WAS UNABLE TO COOL CABIN. ELECTED TO RETURN TO DAY. MAINTENANCE CLEANED CONNECTOR ON BOTH LT AND RT PACK DUCT TEMP SENSOR IAW STANDARD MAINTENANCE PRACTICES. GROUND CHECK GOOD. AIRCRAFT RETURNED TO SERVICE.SDR 95ZZZX6215Safety Pin · installedFLT 4002 - CREW REPORTED GEAR UNSAFE LIGHT (NLG) AFTER TAKEOFF. RETURNED TO FIELD WITHOUT FURTHER INCIDENT. CAK MAINTENANCE REMOVED NLG SAFETY PIN. AIRCRAFT RETURNED TO SERVICE.SDR 95ZZZX4345Fuel Press Warn · activatedFLT 4147 - CREW ABORTED TAKEOFF AFTER RECEIVING FUEL LOW PRESSURE - C.A.S. MESSAGE. AIRCRAFT RETURNED TO GATE WITHOUT FURTHER INCIDENT. MAINTENANCE PERFORMED AN OPERATIONAL CHECK ON THE SYSTEM IAW DO328 MM 28-00-00, COULD NOT DUPLICATE PROBLEM. AIRCRAFT RET
Back to N328JS, cancelled Nov 26, 2008