N778SK
Service difficulty reports · 209
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 = 'N778SK' 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 = 'N778SK' 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 SWIA200921468Lamp · burned outFLT 6582 - LEFT EMERGENCY EXIT SIGN LAMP INOP. RELAMPED.SDR SWIA200820392Web · crackedC-CHECK, PASSENGER DOOR AFT WEB CRACKED AT UPPER COUNTERBALANCE ATTACH POINT. REPAIRED PER REO.SDR SWIA200820391Web · crackedC-CHECK, PASSENGER DOOR AFT WEB CRACKED AT SECOND AND THIRD STEP. REPAIRED PER REO.SDR SWIA200820390Floorbeam · crackedC-CHECK, FS 280 CROSSBEAM CRACKED AT LBL9 AND RBL9. REPAIRED PER REO.SDR SWIA200819243Engine · fluctuatesFLT 5996 - OIL TEMPERATURE INDICATIONS ON LEFT ENGINE WERE FLUCTUATING IN FLIGHT. REPLACED LEFT ENGINE ASSEMBLY IAW CRJ MM 71-00-00. OPS CHECK GOOD, PN: CF34-8C5B1 SN OFF: 194323.SDR SWIA200718363Web · crackedPAX DOOR AFT WEB IS CRACKED AT SUPPORT BRACKET, DISCOVERED AT C-CHECK. INSTALLED REPAIR ANGLES AND EXTERNAL DOUBLER IAW REO 670-52-11-104 P 2-6.SDR SWIA200718362Web · crackedPAX DOOR FORWARD WEB IS CRACKED AT SUPPORT BRACKET, DISCOVERED AT C-CHECK. INSTALLED REPAIR ANGLES AND DOUBLER AS PER REO 670-52-11-104.SDR SWIA200616649Actuator · malfunctionedAP TRIM IS LWD CAUTION MESSAGE IN FLIGHT. REPLACED ELEVATOR SERVO ACTUATOR IAW MM 22-11-24. OPERATIONAL CHECK NORMAL.SDR SWIA200616573Switch · stuckF/O'S TRIM SWITCH STICKING. REPLACED F/O'S TRIM SWITCH. OPERATIONAL CHECK GOOD IAW MM 27-41-05.
Back to N778SK