N716SK
Service difficulty reports · 214
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 = 'N716SK' 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 = 'N716SK' 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 SWIA200718584Web · crackedPAX DOOR AFT WEB IS CRACKED AT 3RD STEP, FOUND AT C-CHECK. INSTALLED REPAIR PARTS PER REO 670-52-11-104 REV 3.SDR SWIA200718583Bulb · burned outEMERGENCY LIGHTS ABOVE NR 2 SEAT WON'T COME ON, FOUND AT C-CHECK. REPLACED LIGHT BULB IN OVERHEAD EMERGENCY LIGHT IAW CRJ700 AMM 33-51-00-710-802.SDR SWIA200718582Web · corrodedLT STA 280 WEB CORRODED BEYOND LIMITS, FOUND AT C-CHECK. INSTALLED LT STA 280 WEB PER CRJ700/900 SRM 51-42-06-001.SDR SWIA200718581Floor Support · crackedCOCKPIT FLOOR SUPPORT IS CRACKED, DISCOVERED AT C-CHECK. INSTALLED NEW COCKPIT FLOOR SUPPORT PER SB 670BA-53-026.SDR SWIA200718580Floorbeam · crackedSTA 280 FLOORBEAM IS CRACKED AT RBL9/RBL11, DISCOVERED AT C-CHECK. PERFORMED REPAIR PER CRJ700/900 SRM 51-42-21-001-001-A01 AND AMM 51-23-00-390-826-A01 DWG SH670-32157.SDR SWIA200718308Knob · bindingRUDDER TRIM RAN AWAY IN FLIGHT. RAN CHECKLIST AND WAS RESET TO NEUTRAL.FOUND RUDDER TRIM KNOB TO BE BINDING ON TRIM PANEL FACEPLATE. ADJUSTED KNOB TO ACHIEVE CLEARANCE FROM FACEPLATE.SDR SWIA200617251Battery Pack · failed4 FORWARD EMERGENCY EXIT LIGHTS INOP, FERRIED TO DEN. INSTALLED SERVICEABLE EMERGENCY LIGHT BATTERY PACK PER CRJ 700 MM 33-51-17. OPERATIONAL CHECKS GOOD, PN 20131A SN OFF 81999.SDR SWIA200616963Handle · crackedPAX DOOR OUTER DOOR HANDLE CRACKED, DISCOVERED DURING C-CHECK INSPECTION. REPLACED PAX DOOR OUTER HANDLE IN ACCORDANCE WITH CRJ200 AMM 52-11-03-400-801-A01.SDR SWIA200616202Trim Panel · malfunctionedSTAB TRIM FAULT STATUS MSG. REPLACED STAB/MACH TRIM PANEL. OPERATIONAL CHECK GOOD IAW MM 27-40-00.SDR SWIA200515926Sensor · malfunctionedAFTER POWER UP SLAT FAULT MSG CAME ON. REPLACED RT IB AND OB SLAT DISCONNECT SENSORS. IAW 27-81-39. OPERATIONAL CHECK GOOD.SDR SWIA200515416Detector · malfunctioned"FLAPS HALFSPEED" STATUS MESSAGE APPEARED ON GROUND. REPLACED RT INBOARD SKEW DETECTOR AND SFECU IAW AMM 27-52-05 AND 27-52-45. OPERATIONAL CHECK GOOD, PN 766389L SN 0617.SDR SWIA200515336Detector · out of rigFLAPS FAIL CAUTION MSG. PERFORMED RIGGING OF FLAP SKEW DETECTOR IAW CRJ AMM 27-52-45. OPERATIONAL CHECK GOOD.SDR SWIA200514961Control Panel · malfunctionedRUDDER TRIM WILL NOT MOVE LEFT MANUALLY. REPLACED AILERON/RUDDER TRIM CONTROL PANEL IAW CRJ MM 27-12-10. OPERATIONAL CHECK GOOD.SDR SWIA200514406Control Unit · malfunctionedSSCU 2 FAULT MESSAGE ON ED2. REMOVED AND REPLACED SSCU 2 IAW AMM 27-61-05. OPERATIONAL CHECK GOOD.
Back to N716SK