N425JS, cancelled Sep 22, 2008
Service difficulty reports · 53
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 = 'N425JS' AND deregistration_id = 'N425JS-2008-09-22' 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 = 'N425JS' AND deregistration_id = 'N425JS-2008-09-22' 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 95ZZZM742Engine · overtorquedFLT NR 4168 - CREW EXPERIENCED AN OVER TORQUE OF 126 PERCENT LEFT ENGINE DURING CLIMB-OUT. AIRCRAFT RETURNED TO FIELD WITHOUT FURTHER INCIDENT. MAINTENANCE CONDUCTED AN OVER TORQUE INSPECTION IAW MM 05-00-00. AIRCRAFT RETURNED TO SERVICE. (M)SDR 95ZZZX6274Structure · bird strikeFLT 4175 - CREW ABORTED TAKEOFF AFTER ENCOUNTERING A BIRD STRIKE DURING TAKEOFF ROLL. AIRCRAFT RETURNED TO GATE WITHOUT FURTHER INCIDENT. MAINTENANCE INSPECTED AIRCRAFT IAW MM 05-00-00. NO DAMAGE DETECTED. AIRCRAFT RETURNED TO SERVICE.SDR 95ZZZX6275Engine Oil · req'd serviceFLT 4236 - DURING CLIMB-OUT, CREW NOTICED BOTH RT AND LT ENGINE OIL PRESSURE INDICATOR IN 'YELLOW' ARC. CREW ELECTED TO RETURN TO FIELD, AIRCRAFT LANDED WITHOUT FURTHER INCIDENT. OUT STATION MAINTENANCE SERVICED BOTH LT AND RT ENGINES WITH OIL IAW MM 12-00-0
Back to N425JS, cancelled Sep 22, 2008