N429JS, cancelled Jun 29, 2009
Service difficulty reports · 65
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 = 'N429JS' AND deregistration_id = 'N429JS-2009-06-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 = 'N429JS' AND deregistration_id = 'N429JS-2009-06-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 VNAA9809024Windshield · crackedDURING CRUISE, THE RIGHT HAND SIDE WINDSCREEN OUTER AND CENTER PANE CRACKED. THE CREW FOLLOWED THE CHECKLIST PROCEDURES, AND CONTINUED TO CLT. A NORMAL LANDING WAS PERFORMED IN CLT WITHOUT ANY FURTHER PROBLEMS. OUTSTATION MAINTENANCE INSPECTED AND APPROVED SDR VNAA9809016Valve · failedA CROSS BLEED FAIL WARNING MESSAGE ILLUMINATED, DURING THE TAXI OUT FOR TAKEOFF. THE AIRCRAFT RETURNED TO THE GATE. MAINTENANCE INSPECTED AND REPLACED THE CROSSBLEED VALVE, IN ACCORDANCE WITH DORNIER MAINTENANCE MANUAL 36-11-10. OPERATIONAL CHECKS WERE COMPSDR VNAA9806014Tires · flatDURING THE TAXI FOR TAKEOFF, BOTH LEFT HAND MAIN TIRES WENT FLAT. THE AIRCRAFT STOPPED AND DE-PLANED THE PASSENGERS. MAINTENANCE INSPECTED AND REPLACED THE LEFT HAND MAIN WHEELS AND TIRES, IN ACCORDANCE WITH DORNIER MAINTENANCE MANUAL 32-41-10. THE AIRCRAFTSDR VNAA9805010Stick Pusher · warningDURING THE TAXI FOR TAKEOFF, A STICK PUSHER FAIL WARNING MESSAGE OCCURED. THE AIRCRAFT RETURNED TO THE GATE. MAINTENANCE INSPECTED AND CYCLED THE AIRCRAFT POWER. AN OPERATIONAL CHECK WAS CARRIED OUT, IN ACCORDANCE WITH DORNIER MAINTENANCE MANUAL 27-33-00. SDR VNAA9802022Apu Bleed Syst · smokingDURING THE CLIMB-OUT AFTER TAKEOFF, THE CREW NOTICED SMOKE IN THE CABIN. THE CREW LEVELED OFF AND DECLARED AN EMERGENCY. THE SMOKE DISSIPATED AFTER THE AIRCONDITIONING WAS SELECTED OFF. THE AIRCRAFT RETURNED TO THE FIELD AND LANDED WITHOUT FURTHER INCIDENT.SDR VNAA9701008Wire Harness · brokenLEFT PROP HEAT FAILED ON TAKEOFF. ABORTED TAKEOFF AND RETURNED TO THE GATE. MAINTENANCE REMOVED AND REPLACED A CONNECTOR ON THE LEFT PROP DE-ICE WIRE HARNESSES, OPERATIONAL CHECK GOOD.SDR VNAA9609004Oil · low qtyEN ROUTE AT 22,000, OIL PRESSURE ON LT ENGINE DROPPED INTO PRECAUTIONARY RANGE. IN ACCORDANCE WITH THE QUICK REFERENCE HANDBOOK, FEATHERED ENGINE. DIVERTED INTO TYS AND LANDED WITHOUT INCIDENT. FOUND OIL LEVEL LOW FOR LT ENGINE. SERVICED OIL AND AIRCRAFT RSDR VNAA9606007Propeller Assy · defectiveTHE RIGHT ENGINE OIL PRESSURE BEGAN TO FLUCUATE SHORTLY AFTER TAKEOFF. F/O OBSERVED OIL COMING FROM THE FORWARD NACELLE AREA, AFT OF THE PROP. CREW SECURED THE RIGHT ENGINE, CONTACTED ATC TO REPORT THE SITUATION RETURNED TO THE FIELD AND LANDED WITHOUT FURTHSDR VNAA9600038Dv Window · delaminatedDURING PREFLIGHT PRIOR TO BOARDING PASSENGERS, FLIGHT CREW NOTICED THE F/O'S DIRECT VISION WINDOW WAS DELAMINATED. INSPECTED THE WINDOW AND FOUND THAT THE WINDOW DELAMINATION WAS BEYOND SERVICABLE LIMITS. REPLACED THE F/O'S DIRECT VISION WINDOW IAW MM 56-12-SDR 96ZZZX1325Windshield · damagedFLT 1001 - CREW REPORTED THE FIRST OFFICER'S WINDSHIELD CRACKED EN ROUTE BETWEEN PIT AND CVG. AIRCRAFT DIVERTED TO CAK, LANDED WITHOUT FURTHER INCIDENT. CAK MX REPLACED THE FIRST OFFICER'S WINDSHIELD IAW MM 56-11-00. GROUND CHECKED GOOD. AIRCRAFT RETURNED SDR 96ZZZM641Uplock Roller · dirtyFLT NR 4023 - SHORTLY AFTER TAKEOFF WHEN THE LANDING WAS RETRACTED, BOTH THE LEFT AND RIGHT MAIN LANDING GEAR INTRANSIT LIGHTS REMAINED ILLUMINATED. AIRCRAFT RETURNED TO THE FIELD, LANDED WITHOUT FURTHER INCIDENT. PIT MX CLEANED AND LUBRICATED THE MAIN LANDISDR 96ZZZM106Engine Oil · req'd servFLT NR 4005 - EN ROUTE FROM CVG TO PHL, CAPTAIN NOTICED A FLUCTUATION IN THE RIGHT ENGINE OIL PRESSURE INDICATION. AIRCRAFT DIVERTED TO PIT WHERE MX SERVICED THE RIGHT ENGINE WITH FOUR QUARTS OF TURBINE OIL. GROUND CHECKED GOOD AIRCRAFT TO SERVICE. (M)SDR 96ZZZX337Roller · lack of lubeFLT 4014 - AFTER TAKEOFF, RIGHT MAIN LANDING INTRANSIT LIGHT REMAINED ILLUMINATED. CREW CYCLED LANDING GEAR SEVERAL TIMES IN AN ATTEMPT TO EXTINGUISH THE INTRANSIT LIGHT, WITHOUT SUCCESS. AIRCRAFT RETURNED TO FIELD, LANDED WITHOUT FURTHER INCIDENT. PIT MAINSDR 95ZZZM741Windshield · failedFLT NR 4159 - CAPTAINS WINDSCREEN FRACTURED DURING CLIMB-OUT AT 15,000 AGL. AIRCRAFT RETURNED TO FIELD WITHOUT FURTHER INCIDENT. MAINTENANCE REPLACED CAPTAINS WINDSCREEN IAW MM 56-10-00. AIRCRAFT RETURNED TO SERVICE. (M)SDR 95ZZZX6280Tq Sensor · defectiveFLT 4228 - FLIGHT CREW REJECTED TAKEOFF AFTER NOTICING A TORQUE FLUX RT ENGINE. AIRCRAFT RETURNED TO GATE WITHOUT FURTHER INCIDENT. AIRCRAFT LATER FERRIED TO PIT WHERE MAINTENANCE REMOVED AND REPLACED RT ENGINE TORQUE SENSOR IAW MM 77-11-00. OPS CHECKED GOO
Back to N429JS, cancelled Jun 29, 2009