N607SK
Service difficulty reports · 163
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 = 'N607SK' 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 = 'N607SK' 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 SWIA201025337Floorbeam · corrodedFS 280.0 FLOORBEAM IS CORRODED AND CRACKED. (C-CHECK) REPLACE PER SRM.SDR SWIA201025506Floorbeam · crackedFLOORBEAM AT FS 274 CRACKED ON BOTH SIDES. (C-CHECK) REPAIRED PER REO.SDR SWIA201024844Light · inoperativeEMERGENCY LIGHTING ABOVE ROW 17 IS BURNT OUT. (FLT 4897)RELAMPED.SDR SWIA201023883Sign · inoperativeEMERGENCY LIGHTING AT MID CABIN OVERHEAD EXIT SIGN INOP. (FLT 4531) RELAMPED EMERGENCY LIGHTING.SDR SWIA201023758Light · inoperativeOVERHEAD EMERGENCY LIGHT BY ROW 10 INOP. (FLT 4468) RELAMPED EMERGENCY LIGHT.SDR SWIA200922969Relay · inoperativeEMERGENCY LIGHTS COME ON WHEN COCKPIT SWITCH IS SET TO ARM. (FLT 4888) REPLACED K135 RELAY.SDR SWIA200922945Light · inoperativeEMERGENCY CEILING LIGHT AT ROW 16 INOP. (FLT 4671) RELAMPED EMERGENCY LIGHT.SDR SWIA200922848Light · brokenFLOOR LEVEL EXIT LIGHT AT MAIN CABIN DOOR BROKEN. (FLT 4673) REPLACED LIGHT ASSEMBLY.SDR SWIA200922766Relay · failedEMERGENCY LIGHTS ILLUMINATE WHEN IN THE ARMED POSITION. (FLT 4743) REPLACED RELAY.SDR SWIA200920857Lamp · burned outFLT 4534 - ONE EMERGENCY CEILING LIGHT INOP. RELAMPED.SDR SWIA200820676Web · corrodedLEFT WEB CORRODED AT FS 280 (C-CHECK). REPAIRED PER SRM.SDR SWIA200820186Lamp · burned outFLT 3705 - THIRD AFT CEILING EMERGENCY LIGHT OUT. RELAMPED.
SDR SWIA200719012Handle · crackedFOUND AT C-CHECK, PAX DOOR INTERNAL HANDLE IS CRACKED. REPLACED INNER PAX DOOR HANDLE PER CRJ700 AMM 52-11-02-400-809-A04.
Back to N607SK