N790SK
Service difficulty reports · 105
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 = 'N790SK' 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 = 'N790SK' 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 SWIA201335345Cover · missingSERVICE DOOR EXIT EMERGENCY FLOOD LIGHT COVER IS MISSING. FLT 5190 INSTALLED SERVICE DOOR EMERGENCY EXIT FLOOD LIGHT COVER IAW AMM.SDR SWIA201334255Sign · missingEMERGENCY EXIT SIGN IS MISSING. FLT#6521 INSTALLED MISSING FLOOR LEVEL EMERGENCY LIGHT COVER BY SERVICE DOOR IAW AMM. PN BF5-0822-905SDR SWIA201334151Fairing · crackedWING TO FS FAIRING LT SIDE AFT HAS CRACK DAMAGE MEASURING 20" X 3 "ON THE LOWER AFT AREA. SERVICE REPAIR CRACKED DAMAGE ON WING TO FS FAIRING RT SIDE AFT IAW REO.SDR SWIA201232365Floor Support · crackedCOCKPIT FLOOR LONGERON CRACKED AT FS 274.00 LBL 12.0. (C-CHECK) REPAIRED IAW REO.SDR SWIA201127749Light · inoperativeFLOOR LEVEL EMERGENCY LIGHT AT GALLEY IS OUT. (FLT 6532) RELAMPED EMERGENCY LIGHT.
Back to N790SK