N768SK
Service difficulty reports · 152
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 = 'N768SK' AND registry_match = 'registration' 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 = 'N768SK' AND registry_match = 'registration' 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 SWIA200616826Battery Pack · dischargedEMERGENCY LIGHTS AT FORWARD DOOR AND SERVICE DOOR INOP. REMOVED AND REPLACED NR 1 ELBP PER MM 33-51-04. OPS CHECK GOOD, SN OFF: 34981.SDR SWIA200616337Control Unit · malfunctionedRUD LIMIT FAULT STATUS MSG APPEARED AFTER POWER-UP. REPLACED SSCU NR 2 IAW 27-61-05. OPERATIONAL CHECK GOOD.
Back to N768SK