N709SK
Service difficulty reports · 207
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 = 'N709SK' 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 = 'N709SK' 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 SWIA200515343Control Unit · malfunctionedSPLR/STAB FAULT STATUS MSG. REPLACED NR 2 SSCU IAW CRJ MM 27-61-00. OPERATIONAL CHECK GOOD.SDR SWIA200515342Detector · malfunctionedFLAPS HALF SPEED STATUS MESSAGE. REPLACED SKEW DETECTOR IAW AMM 27-52-45. OPERATIONAL CHECK GOOD.SDR SWIA200514828Motor · malfunctionedSTAB CH2 INOPERATIVE STATUS MESSAGE. REPLACED HSTA MOTOR NR 2 PER AMM 27-42-03. OPERATIONAL CHECK GOOD IAW 27-40-00-710-801 A02.SDR SWIA200514700Wire · brokenEMERGENCY EXIT SIGN ON BULKHEAD BETWEEN FIRST CLASS AND COACH INOPERATIVE. REPAIRED WIRING FOR EMERGENCY EXIT SIGN ON BULKHEAD. ALL LIGHTS CHECK GOOD.SDR SWIA200514537Smoke Detector · malfunctionedON TAKEOFF ROLL, RECEIVED SMOKE AFT LAV RED WARNING MSG, ABORTED TAKEOFF. NO SMOKE/FIRE REPORTED BY FLIGHT ATTENDANTS. REMOVED AND REPLACED LAV SMOKE DETECTOR IAW AMM 26-10, OPERATIONAL CHECK GOOD. P/N PU90-421R3, S/N OFF 08782.SDR SWIA200514374Smoke Detector · contaminatedAFT LAV SMOKE WARNING INFLIGHT FOR 5 SECONDS. F/A FOUND NO SIGN OF SMOKE OR FIRE. CLEANED SOME DUST FROM AFT LAV SMOKE DETECTOR. OPERATIONAL CHECK WITH SMOKE DETECTOR TESTER SPRAY GOOD.SDR SWIA200414042Connector · looseLAV SMOKE MESSAGE CAME ON DURING TAKEOFF ROLL. RE-SECURED LOOSE CONNECTOR PLUG. OPERATIONAL CHECK GOOD IAW MM 26-16-00.
Back to N709SK