N773SK
Service difficulty reports · 160
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 = 'N773SK' 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 = 'N773SK' 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 SWIA200920812Light · inoperativeFLT 5890 - CEILING EMERGENCY LIGHT OUT. RELAMPED.SDR SWIA200820693Lamp · burned outFLT 6335 - CABIN CEILING EMERGENCY FLOOD LIGHT NR 6 INOP. RELAMPED.SDR SWIA200820250Floorbeam · crackedFLOORBEAM CRACKED AT FS 280 LEFT AND RIGHT SIDES (C-CHECK). REPAIRED PER REO.SDR SWIA200819080Battery Pack · dischargedFLT 6550 - SEVERAL EMERGENCY LIGHTS ARE INOP. REPLACED NR 3 BATTERY PACK AS REQUIRED, OPS CHECK GOOD, PN: AD-2013-1A, SN OFF: 79415.
SDR SWIA200718160Sign · missingFOUND OVERHEAD EMERGENCY EXIT SIGN IS MISSING. INSTALLED COVER PER CRJ MM CH 33-51-00.SDR SWIA200718058Ballast · failedFOUND SMOKE IN THE CABIN WITH LIGHTS FLICKERING AT ROWS 2 AND 3 AB SIDE. REPLACED LIGHT BALLAST AT ROW 3. OPERATIONAL CHECKS GOOD.SDR SWIA200717801Lamp · burned outFOUND EMERGENCY FLOOD LIGHT POD AT ROW 7 IS INOP. RELAMPED EMERGENCY LIGHTING CEILING FLOOD LIGHT AT ROW 7 PER 33-51-09. OPERATIONAL CHECKS GOOD.SDR SWIA200617450Windshield · crackedON TAXI OUT LEFT WINDSHIELD CRACKED. REPLACED LEFT WINDSHIELD IAW MM 56-11-01 & RII CARD 56-220-1000. OPERATIONAL CHECKS GOOD. P/N OFF 601R33033-21, S/N OFF 05217H8005.SDR SWIA200616802Pump · leakingHYDRAULIC SYSTEM NR 2 QUANTITY DROPPED TO 0. DIVERTED TO ORD. REPLACED NR 2 ENGINE DRIVEN HYDRAULIC PUMP PER AMM 29-11-01. OPERATIONAL CHECKS GOOD.SDR SWIA200616373Control Unit · malfunctionedA -SPLR/STAB FAULT- STATUS MSG. REPLACED BOTH SSCU'S IAW MM 27-61-05. OPERATIONAL CHECK GOOD. P/N C13045BA04, S/N OFF 1162, P/N C13045BA04, S/N OFF 1101.
Back to N773SK