N606SK
Service difficulty reports · 232
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 = 'N606SK' 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 = 'N606SK' 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 SWIA201231144Light · inoperativeNR 1 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 4582) RELAMPED EMERGENCY LIGHT.SDR SWIA201230938Light · inoperativeNR 5 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 4535) RELAMPED EMERGENCY LIGHT.SDR SWIA201230804Light · inoperativeSECOND FROM BACK OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 4463) RELAMPED EMERGENCY LIGHT.SDR SWIA201230463Light · inoperativeNR 4 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 4794) RELAMPED EMERGENCY LIGHT.SDR SWIA201230404Light · inoperativeNR 6 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 4533) RELAMPED EMERGENCY LIGHT.SDR SWIA201229996Light · inoperativeNR 4 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 4662) RELAMPED EMERGENCY LIGHT.SDR SWIA201229745Light · inoperativeLAST 2 OVERHEAD EMERGENCY LIGHTS ARE OUT. (FLT 4489) RELAMPED EMERGENCY LIGHTS.SDR SWIA201128923Light · inoperativeTHE 2ND TO AFT, OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 4739) RELAMPED EMERGENCY LIGHT.SDR SWIA201128823Light · inoperativeAFT CABIN CEILING EMERGENCY LIGHT OUT. (FLT 4583) RELAMPED EMERGENCY LIGHT.SDR SWIA201128008Floorbeam · crackedC-CHECK, FS 274 LBL 12.0 AND RBL 12.0 COCKPIT FLOOR SUPPORT BEAMS ARE CRACKED. REPAIRED PER REO.SDR SWIA201130571Floorbeam · corrodedFS 280 FLOORBEAM CORRODED. (C-CHECK) REPAIRED FS 280 FLOORBEAM CORRODED PER CRJ 7/9 SRM.SDR SWIA201128345Light · inoperativeTHE 2ND TO AFT OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 4561) RELAMPED EMERGENCY LIGHT.SDR SWIA201127530Light · inoperativeNR 1 OVERHEAD EMERGENCY LIGHT BURNED OUT. (FLT 4794) RELAMPED EMERGENCY LIGHT.SDR SWIA201127364Light · inoperativeNR 1 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 4685) RELAMPED EMERGENCY LIGHT.SDR SWIA201127214Light · inoperativeTHE 2ND FROM AFT OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 4683) RELAMPED EMERGENCY LIGHT.SDR SWIA201127189Light · inoperativeAFT OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 4650) RELAMPED EMERGENCY LIGHT.SDR SWIA201126940Acm · malfunctionedSMOKE IN THE COCKPIT. (SERVICE) REPLACED LT ACM. P/N: GG670-95009-5, S/N OFF: 00561.SDR SWIA201126853Light · inoperativeTHE 2ND FROM AFT OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 4790) RELAMPED EMERGENCY LIGHT.SDR SWIA201126584Light · inoperativeSECOND TO LAST OVERHEAD EMERGENCY LIGHT IS OUT. (SERVICE) RELAMPED EMERGENCY LIGHT.SDR SWIA201126474Hydraulic Line · leakingHYDRAULIC 2A LOW PRESSURE CAUTION MESSAGE ALONG WITH A QUANTITY 0 PERCENT ON HYDRAULIC SYSTEM 2. (FLT 4501) FOUND NR 2 HYD SUCTION LINE RUPTURED AFT OF BULKHEAD. REPAIRED HYDRAULIC LINE.SDR SWIA201025047Acm · failedDURING APU START WITH THE PACKS ON THE CABIN FILLED UP WITH SMOKE. (FLT 4704) REPLACED LEFT AIR CYCLE MACHINE.SDR SWIA201023506Light · inoperativeNR 3 AND NR 4 CEILING EMERGENCY FLOOD LIGHTS INOP. (SVC CHECK) RELAMPED EMERGENCY LIGHT.SDR SWIA201023739Floorbeam · crackedLBL12 FLOORBEAM FORWARD OF FS 280 CRACKED AT ANGLE BRACKET TIE IN. (C CHECK) REPAIRED PER REO.SDR SWIA201023463Floorbeam · corrodedC-CHECK, FS 280 BEAM CORRODED AT TOP AND CRACKED AT LBL11.5. REPLACED BEAM PER REO.SDR SWIA201023430Beam · corrodedC-CHECK, FS 280 BEAM CORRODED AND CRACKED AT LBL11.5. REPAIRED PER REO.SDR SWIA200921717Lamp · burned outFLT 4803 - EMERGENCY LIGHTS INOP. RELAMPED.SDR SWIA200820051Lamp · burned outFLT 3800 - EMERGENCY LIGHT NEXT TO THE MAIN CABIN DOOR, HAS ONE INOP LIGHTBULB, RELAMPED.
SDR SWIA200819485Oxygen Mask · unwanted deployFLT 4001, FORWARD LAV O2 MASK DEPLOYED. INSPECTED AND STOWED O2 MASK IAW AMM 35-20-00.SDR SWIA200718986Connector · burnedFLT 4042 - "L IGN A FAULT" MESSAGE APPEARED. REPLACED PINS ON PLUG J551 IAW CRJ 700 WDM 20-16-00.
SDR SWIA200616756Circuit Breaker · damagedON SHORT FINAL GOT DC BUS 1 CAUTION MESSAGE. PERFORMED GO AROUND AND NOTICED CB 1D6 WAS POPPED AND RESET SUCESSFULLY. ON LANDING IT POPPED AGAIN ON SHORT FINAL AND LANDED OK. REPLACED CBP1-D6 AND D7 WHICH WERE DAMAGED FROM HEAT IAW AMM 24-31-00, CHECKS GOODSDR SWIA200616572Control Unit · malfunctionedSTAB CHANNEL 1 WILL NOT ENGAGE. REPLACED MCU IAW AMM 27-42-07.SDR SWIA200616418Battery · dischargedLT WING (2) LIGHTS AND 1 OVERHEAD E-LIGHT COME ON WITH 3-LIGHT SWITCH OFF AND ONLY BATTERY POWER (NO A/C). REPLACED NR 2 ELBP IAW MM 33-50-01. OPERATIONAL CHECK GOOD.
Back to N606SK