N807AL, cancelled Jul 30, 2008
Service difficulty reports · 104
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 = 'N807AL' AND deregistration_id = 'N807AL-2008-07-30' 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 = 'N807AL' AND deregistration_id = 'N807AL-2008-07-30' 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 TSAA9628076Fuel Shutoff Vlv · inopFLT 302 - HNL-OGG - AFTER TAKEOFF, THE NR 1 FUEL VALVE CLOSED LIGHT ILLUMINATED BRIGHT. ALL ENGINE INDICATIONS REMAINED NORMAL. RETURNED TO HNL. REMOVED AND REPLACED NR 1 ENGINE FUEL SHUTOFF VALVE IAW MM 28-22-11. OPS CHECK GOOD. AIRCRAFT RETURNED TO SERVSDR TSAA965740Fairing Seal · missingFLT 257 - HNL-LIH - RECURRING VIBRATION, LOUD HIGH FREQUENCY VIBRATIONS FROM RIGHT SIDE WING ROOT AREA. STARTED AT 11,000 FEET DURING CLIMB AND STOPPED AT 9,000 FEET. DURING DESCENT, VIBRATION FELT IN NR 2 THRUST LEVER AND CABIN FLOOR. VIBRATION NOTICED WITSDR TSAA9534126Aoa Sensor · malfunctionedITO/HNL - FLT 437 - PILOT REPORT. DURING TAKEOFF, ROLL 'WINDSHEAR INOP' LIGHT CAME ON. TAKEOFF CONTINUED, AND AFTER BECOMING AIRBORNE, STICK SHAKER BEGAN. AIRSPEED APPROXIMATELY 140 KNOTS TO 150 KNOTS. MOVING STALL WARNING SWITCH TO 'TEST' POSITION STOPPEDSDR 95ZZZX3970Stall Warn Mod · malfunctionedITO/HNL - FLT 437 - PILOT REPORT. DURING TAKEOFF, ROLL 'WINDSHEAR INOP' LIGHT CAME ON. TAKEOFF CONTINUED, AND AFTER BECOMING AIRBORNE, STICK SHAKER BEGAN. AIRSPEED APPROXIMATELY 140 KNOTS TO 150 KNOTS. MOVING STALL WARNING SWITCH TO 'TEST' POSITION STOPPED
Back to N807AL, cancelled Jul 30, 2008