N218SW, cancelled Jun 18, 2010
Service difficulty reports · 102
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 = 'N218SW' AND deregistration_id = 'N218SW-2010-06-18' 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 = 'N218SW' AND deregistration_id = 'N218SW-2010-06-18' 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 SWIA97845AStubshaft Bolt · failedAFTER TAKEOFF, NR 1 ENGINE FAILED. RETURNED FOR LANDING. INSTALLED SERVICEABLE ENGINE ASSEMBLY IAW MM 71-00-00. PERFORMED ALL APPLICABLE ENGINE RUNS, OPS CHECKS GOOD WITH NO LEAKS NOTED. *S/D* ENGINE SHUTDOWN AS RESULT OF FAILURE OF BOLTS ON ENGINE STUBSHSDR SWIA97845Engine · failedAFTER TAKEOFF, NR 1 ENGINE FAILED. RETURNED FOR LANDING. INSTALLED SERVICEABLE ENGINE ASSEMBLY IAW MM 71-00-00. PERFORMED ALL APPLICABLE ENGINE RUNS. OPS CHECKS GOOD WITH NO LEAKS NOTED.
Back to N218SW, cancelled Jun 18, 2010