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 SWIA201129096Light · inoperativeAFT OVERHEAD EMERGENCY LIGHT IS OUT. (SERVICE) RELAMPED EMERGENCY LIGHT.SDR SWIA201128311Light · inoperativeNR 3 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5311) RELAMPED EMERGENCY LIGHT.SDR SWIA201128096Light · inoperativeAFT OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5198) RELAMPED EMERGENCY LIGHT.SDR SWIA201128044Light · inoperativeAFT OVERHEAD EMERGENCY LIGHT IS BURNED OUT. (FLT 6365) RELAMPED EMERGENCY LIGHT.SDR SWIA201127612Light · inoperativeAFT OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 6201) RELAMPED EMERGENCY LIGHT.SDR SWIA201126938Light · inoperativeEMERGENCY OVERHEAD LIGHTS OVER ROWS 3 & 6 ARE OUT. (FLT 5385) RELAMPED EMERGENCY LIGHT.SDR SWIA201126768Light · inoperativeTHE 2ND TO LAST OVERHEAD EMERGENCY LIGHT BURNED OUT. (FLT 1120) RELAMPED EMERGENCY LIGHT.SDR SWIA201126516Manifold · faultyHYD 3 LOW PRESS CAUTION MESSAGE. (FLT 5507) REPLACED SYSTEM NR 3 PRESSURE MANIFOLD, REPLACED SYSTEM NR 3 PRESSURE TRANSDUCER, REPLACED BOTH SYSTEM 3 PRESSURE SWITCHES, REPLACED PRESSURE RELIEF VALVE. P/N: 945173-3, S/N OFF: PT0680SDR SWIA201126487Light · inoperativeMCD EMERGENCY EXIT LIGHT IS OUT. (FLT 5538) RELAMPED EMERGENCY LIGHT.SDR SWIA201126486Light · inoperativeNR 5 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5472) RELAMPED EMERGENCY LIGHT.SDR SWIA201126438Light · inoperativeTHE 2ND FROM AFT OVERHEAD EMERGENCY LIGHT IS OUT. (SERVICE) RELAMPED EMERGENCY LIGHT.SDR SWIA201126139Light · inoperativeNR 5 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 7007) RELAMPED EMERGENCY LIGHT.SDR SWIA201126057Light · inoperativeOVERHEAD EMERGENCY LIGHT AT ROW 15 IS OUT. (FLT 6450) RELAMPED EMERGENCY LIGHT.SDR SWIA201125988Light · inoperativeAFT OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 7007) RELAMPED EMERGENCY LIGHT.SDR SWIA201125838Light · inoperativeEMERGENCY EXIT LIGHT AT ROW 12 SIDEWALL IS BURNED OUT. (FLT 6993) RELAMPED EMERGENCY LIGHT.SDR SWIA201125779Sign · inoperative2ND FROM AFT CEILING EMERGENCY EXIT NOT ILLUMINATING. (FLT 6956) RELAMPED CEILING EXIT SIGN.SDR SWIA201125810Light · inoperativeNR 5 CEILING EMERGENCY LIGHT IS OUT. (SERVICE) RELAMPED EMERGENCY LIGHT.SDR SWIA201125678Light · inoperativeSECOND TO LAST CEILING EMERGENCY LIGHT IS OUT. (FLT 6610) RELAMPED EMERGENCY LIGHT.SDR SWIA201125575Light · inoperativeEMERGENCY FLOODLIGHT AT GALLEY SERVICE DOOR HAS A BULB BURNED OUT. (FLT 1140) RELAMPED EMERGENCY LIGHT.SDR SWIA201125516Light · inoperativeNR 5 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 6469) RELAMPED EMERGENCY LIGHT.SDR SWIA201023978Light · inoperativeMAIN DOOR FLOOR LEVEL EMERGENCY LIGHT INOP. (FLT 6819) RELAMPED EMERGENCY LIGHT.SDR SWIA201023578Light · inoperativeAFT CEILING EMERGENCY LIGHT INOP. (FLT 6550) RELAMPED EMERGENCY LIGHT.SDR SWIA200923210Light · inoperativeNR 1 OVERHEAD EMERGENCY FLOODLIGHT INOP. (FLT 6624)RELAMPED.SDR SWIA200922964Light · inoperativeGALLEY FLOOR EMERGENCY FLOODLIGHT INOP. (FLT 6212) RELAMPED EMERGENCY LIGHT.SDR SWIA200922693Light · inoperativeFWD POD OVERHEAD EMERGENCY LIGHT OUT. (FLT 5914) REPLACED LAMP IN CEILING EMERGENCY LIGHT ASSY IAW AMM 33-51-09.SDR SWIA200922165Light · inoperativeAFT EMERGENCY CEILING LIGHT INOP. (FLT 6567) RELAMPED EMERGENCY LIGHT.SDR SWIA200922049Cable · damagedBATTERY AND APU ELECTRICAL CABLES HEAT DAMAGE. (SVC CHECK) REPLACED CABLES PER AMM.SDR SWIA200922136Drag Angle · crackedPASSENGER DOOR DRAG ANGLE CRACKED. (C CHECK) REPAIRED PER REO.SDR SWIA200922135Beam · crackedFS 280 BEAM CRACKED. (C CHECK) REPAIRED PER SRM.SDR SWIA200922134Floor Support · corrodedFS 280 FLOOR SUPPORT CORRODED. (C CHECK) REPAIRED PER SRM.SDR SWIA200921613Lamp · burned outFLT 6592 - OVERHEAD EMERGENCY CEILING LIGHT INOP. RELAMPED.SDR SWIA200921358Tire · failedFLT 6665 - NR 3 MAIN TIRE IS SHREDDED. DAMAGED UNDERSIDE OF FLAP. REPLACED FLAP AND TIRE.SDR SWIA200921341Lamp · burned outFLT 6395 - OVERHEAD EMERGENCY LIGHT NR 5 INOP. RELAMPED.SDR SWIA200820621Bushing · corrodedSVC CHK, RIGHT ENGINE LEFT THRUST LINK AND BUSHING CORRODED. REPLACED LINK AND BUSHING PER AMM.SDR SWIA200820161Light · inoperativeLAST AFT EMERGENCY DOME LIGHT INOP (FLT 6366). RELAMPED EMERGENCY LIGHT.
SDR SWIA200820112Sensor · out of adjustGEAR DISAGREE WARNING MESSAGE WHEN GEAR RETRACTED. (FLT 5842) ADJUSTED NLG WEIGHT OFF WHEELS SENSORS PX03 & PX11.SDR SWIA200718995Light · shortedFLT 6659 - FO'S CHART HOLDER LIGHT IS INTERMITTENT. SECURED HARDWARE UNDER LIGHT ASSEMBLY. OPS CHECK GOOD.SDR SWIA200718968Light · shortedFLT 5832 - FIRST OFFICERS MAP LIGHT IS SHORTED. RESET CIRCUIT BREAKER AND INSPECTED CHART HOLDER. NO DISCREPENCIES NOTED.
SDR SWIA200718623Acm · seizedON TAXI OUT, THE FLIGHT ATTENDANT CALLED WITH SMOKE IN THE CABIN. CREW GOT A RIGHT PACK AUTO FAIL, FLIGHT NR 5947. REPLACED RIGHT ACM IAW AMM 21-51-08. OPS CHECK GOOD.SDR SWIA200718352Pcu · malfunctionedRIGHT OUTBOARD SPOILERON DEPLOYED IN FLIGHT. REPLACED RIGHT MULTIFUNCTION SPOILER PCU IAW AMM 27-62-01. OPS CHECKS GOOD, P/N: 51200-11, S/N OFF: MAL-0776.SDR SWIA200718293Roller · corrodedPASSENGER DOOR LATCH MECHANISM ROLLER IS CORRODED, DISCOVERED AT C-CHECK. REMOVED AND REPLACED ROLLER PER BOMBARDIER CMM 52-12-01.SDR SWIA200718292Web · crackedPAX DOOR FORWARD WEB IS CRACKED AT LOWER ATTACH POINT OF MIDDLE STEP, DISCOVERED AT C-CHECK. REPAIRED AREA IAW REO 670-52-11-104.SDR SWIA200718291Web · crackedPAX DOOR AFT WEB CRACKED AT MID-STEP, DISCOVERED AT C-CHECK. INSTALLED FABRICATED REPLACEMENT PARTS PER REO 670-52-11-258.SDR SWIA200718290Handle · crackedPAX DOOR OUTER HANDLE IS CRACKED, DISCOVERED AT C-CHECK. REPLACED PAX DOOR OUTER HANDLE PER CRJ700/900 MM TASK 52-11-03-400-801-A01.SDR SWIA200718289Floorbeam · crackedFS 280 SUPPORT BEAM IS CRACKED AT FITTINGS ON LEFT AND RIGHT BUTT LINE 9, DISCOVERED AT C-CHECK. INSTALLED FS 280 BEAM PER REO 670-53-11-047. INSTALLED COCKPIT FLOOR SUPPORT BEAM PN CC670-33292-13 PER CRJ700 SRM 51-42-06.SDR SWIA200718062A/C Pack · smokeFOUND LEFT PACK PRODUCES SMOKE/HAZE IN COCKPIT AND CABIN. COULD NOT DUPLICATE DISCREPANCY.SDR SWIA200616419Circuit Card · malfunctionedPFD 1 FAILED IN FLIGHT. MFD 1 FAILED 30 SEC LATER AND RECEIVED EFIS COMP INOP CAUTION MSG. RTU 1 FAILED ABOUT 30 MIN LATER. INTERROGATED MDC AND FOUND NUMEROUS FAULTS FOR BOTH IOC BUSSES GOING TO PFD 1 AND MFD 1, RTU 1. REPLACED BOTH HIRF CARDS IN IAPS CAGSDR SWIA200616357Control Unit · malfunctionedWHEN CHANNEL 1 (HORIZONTAL STAB) IS ENGAGED, STAB FAULT STATUS MESSAGE APPEARS. REPLACED NR 1 SSCU IAW MM 27-61-05. OPERATIONAL CHECK GOOD IAW MM 27-61-05.SDR SWIA200616206Battery · dischargedGALLEY EMERGENCY EXIT FLOODLIGHT INOP. REPLACED NR 2 EMERGENCY LIGHT/BATTERY CHARGER IAW CRJ MM 33-51-04. OPERATIONAL CHECK GOOD.SDR SWIA200515631Trim Switch · stickingFO'S STAB TRIM SWITCH IS STICKY. REPLACED FO'S STAB TRIM SWITCH IAW MM 27-41-05. OPERATIONAL CHECK GOOD IAW MM 27-40-00.
Back to N709SK