N770SK
Service difficulty reports · 253
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 = 'N770SK' 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 = 'N770SK' 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 SWIA200616299Sensor · malfunctionedRUDDER SHOWS RIGHT OF CENTER ON FLIGHT CONTROL PAGE WITH RUDDER PEDALS CENTERED. REPLACED RUDDER POSITION SENSOR IAW 27-24-05. OPERATIONAL CHECK GOOD.SDR SWIA200616260Transmitter · out of adjustIN FLIGHT RUDDER TRIM SHOWS CENTERED, RUDDER DEFECTED TO LIMITER ON RIGHT SIDE. ADJUSTED TRANSMITTER TO BE WITHIN LIMITS. OPERATIONAL CHECK GOOD IAW CRJ 700 MM 27-25-05.SDR SWIA200616237Transmitter · out of adjustUNABLE TO GET A GOOD RUDDER TEST TO THE LEFT ON EICAS. RETURNED TO GATE. ADJUSTED RUDDER POSITION TRANSMITTER REF AMM 27-24-05. OPERATIONAL CHECK GOOD.
Back to N770SK