N706SK
Service difficulty reports · 239
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 = 'N706SK' 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 = 'N706SK' 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 SWIA201023424Light · inoperativeOVERHEAD EMERGENCY LIGHT NR 6 INOP. (FLT 6366) RELAMPED EMERGENCY LIGHT.SDR SWIA200923112Light · inoperativeAFT CEILING EMERGENCY LIGHT INOP. (FLT 6501) RELAMPED EMERGENCY LIGHT.SDR SWIA200922244Connector · looseLEFT MAIN LANDING GEAR STATUS MESSAGE DISPLAYED. (FLT 6234) RESECURED MLG SHUTTLE VALVE PRESSURE SWITCH CONNECTOR.SDR SWIA200922101Intercostal · gougedFS 280 RIGHT OUTBOARD INTERCOSTAL RIVET HOLE GOUGED. (C CHECK) REPAIRED PER REO.SDR SWIA200922100Beam · corrodedFS 280 BEAM CORRODED. (C CHECK) REPLACED BEAM PER REO.SDR SWIA200921063Lamp · burned outFLT 6181 - LAMP INOP ON MAIN ENTRY DOOR EMERGENCY LIGHT. RELAMPED.SDR SWIA200920864Lamp · burned outFLT 6463 - TWO OVERHEAD EMERGENCY FLOOD LIGHTS INOP. RELAMPED.SDR SWIA200920863Fuse · failedFLT 6463 - FORWARD BATTERY PACK NOT POWERING EMERGENCY LIGHTS. REPLACED NR 2 BATTERY PACK CHARGER FUSE.SDR SWIA200820605Lamp · burned outFLT 6487 - CEILING EMERGENCY LIGHT INOP. RELAMPED.SDR SWIA200820050Lamp · burned outFLT 6722 - OVERHEAD EMERGENCY LIGHT. RELAMPED.SDR SWIA200819925Bushing · corrodedLT ENGINE FWD MOUNT LINK AND BUSHINGS ARE CORRODED. REPLACED LT ENGINE LINK AND BUSHINGS IAW AMM 71-00-00.
SDR SWIA200819715Handle · crackedPAX DOOR OUTER HANDLE IS CRACKED. (FOUND AT C-CHECK) COMPLIED WITH REPLACEMENT OF THE OUTER PAX DOOR HANDLE.SDR SWIA200819460Light · brokenLEFT SIDE AFT PIECE OF EMERGENCY FLOOR LIGHTING IS BROKEN. REPLACED LEFT SIDE AFT PIECE OF EMERGENCY FLOOR LIGHTING IAW CRJ 700 AMM 33-51-01.SDR SWIA200819177Lens · missingFLT 6403 - EMERGENCY FLOOR LIGHT LENS IS MISSING. REPLACED LENS ASSEMBLY PER CRJ CMM 33-51-00.SDR SWIA200718447Acm · smokeFLT 6694 - EXPERIENCED WHITE SMOKE FROM ENVIRONMENTAL DUCTS FOLLOWED BY A RIGHT PACK AUTO FAIL MESSAGE. REPLACED THE RIGHT AIR CYCLE MACHINE IAW MM 21-51-08. OPS CHECKS GOOD.SDR SWIA200718097Windshield · crackedCRACK IN UPPER LEFT CORNER OF LEFT WINDSHIELD. REPLACED PILOT'S WINDSHIELD PER CRJ 200 MM 56-11-01, PN NP139321-13 S/N OFF 04017H3560.SDR SWIA200718215Drag Angle · crackedPAX DOOR AFT DRAG ANGLE CRACKED NEAR DOOR ASSIST MOTOR CABLE PULLEY, DISCOVERED AT C-CHECK. REPLACED PARTS FOR PAX DOOR AFT DRAG ANGLE IAW REO 670-52-11-072.SDR SWIA200718214Web · crackedPAX DOOR AFT WEB CRACKED AT SECOND STEP, DISCOVERED AT C-CHECK. REPLACED REPAIR ANGLES AND INTERNAL REPAIR DOUBLER PER REO 670-52-11-104.SDR SWIA200718213Web · crackedPAX DOOR FORWARD WEB CRACKED AT SECOND STEP, DISCOVERED AT C-CHECK. REPLACED REPAIR ANGLES AND EXTERNAL DOUBLER PER REO 670-52-11-104.SDR SWIA200718212Floorbeam · crackedFOUND COCKPIT FLOOR SUPPORT IS CRACKED AT FS 280, DISCOVERED AT C-CHECK. REPLACED COCKPIT FLOOR SUPPORT ANGLE P/N CC670-33292-9 IAW CRJ700 SRM 51-42-21-001-001-A01.SDR SWIA200718211Floorbeam · crackedSTATION 280 FLOOR SUPPORT BEAM CRACKED, DISCOVERED AT C-CHECK. REPLACED STATION 280 FLOORBEAM AND FLOORBEAM SUPPORT IAW REO 670-53-11-047 AND SB670BA-53-026 AND SRM 51-42-06-001-001-A01 AND REPLACED BRACKETS AT STATION 280 LBL 9.0 AND RBL 9.0 IAW SB670BA-53-0SDR SWIA200616674Bulb · burned outFOUND EMERGENCY LIGHTS ABOVE ENTRY WAY INOP. REPLACED ALL BULBS IN EXIT SIGN. OPERATIONAL CHECKS GOOD, IAW 33-51-00.SDR SWIA200616618Lamp · burned outMOST AFT CEILING EMERGENCY LIGHT IS INOP (FLOOD). RELAMPED AFT EMERENCY LIGHT. OPERATIONAL CHECK GOOD IAW AMM 33-61-00.SDR SWIA200616223Sensor · malfunctionedFLAPS HALFSPEED MESSAGE AFTER LANDING. REPLACED RT FLAP BPSU. RIG AND OPERATIONAL CHECK GOOD PER MM 27-52-03.SDR SWIA200616161Connector · brokenFLAPS HALFSPEED STATUS MSG. REPAIRED WIRING AT LT BPSU CONNECTOR PLUG MPE9P1 AND MPE9P2 IAW WM 20-17-10. OPERATIONAL CHECK OK.SDR SWIA200616172Control Unit · malfunctionedRECEIVED FLAPS HALFSPEED AFTER TAKEOFF. WHITE STATUS MSG. REPLACED SFECU NR 1 IAW CRJ700 MM27-51-05 AND 27-50-00. OPERATIONAL CHECK GOOD.SDR SWIA200516038Sensor · malfunctioned"FLAPS HALFSPEED" STATUS MESSAGE. REPLACED LT FLAP BPSU IAW MM 27-52-03. OPERATIONAL CHECK GOOD.SDR SWIA200515930Light · inoperativeEMERGENCY LIGHT OVERHEAD NEAR ROW 9 IN PAX CABIN INOP. REPLACED EMERGENCY OVERHEAD LIGHT IAW CRJ MM 33-51-15. OPERATIONAL CHECK GOOD.SDR SWIA200515891Lamp · burned outEMERGENCY LIGHT PAST EXIT SIGN OUT. RELAMPED LIGHT IAW MM 33-51-09, LIGHT OPERATIONAL CHECK GOOD.SDR SWIA200515872Light · crackedGALLEY EMERGENCY LIGHT CRACKED AND LOOSE. REPLACED GALLEY DOOR EMERGENCY LIGHT AS REQUIRED.SDR SWIA200515671Control Unit · malfunctioned"STAB CHAN 1" CAUTION MSG. REPLACED HORIZ STAB MOTOR CONTROL UNIT IAW AMM 27-42-07. OPERATIONAL CHECK GOOD IAW 27-40-00-710-801.SDR SWIA200515400Acm · seizedON TAKEOFF, STRONG SMELL OF SMOKE. REPLACED LEFT AIR CYCLE MACHINE IAW AMM 21-51-08. OPERATIONAL CHECK GOOD.SDR SWIA200515345Sensor · malfunctioned'SLAT FAULT' STATUS MESSAGE. REPLACED RIGHT WING INBOARD SKEW DISCONNECT SENSOR IAW MM 27-81-39. OPERATIONAL CHECK GOOD.SDR SWIA200515353Stop · out of adjustFORWARD DOOR STICKS DURING CLOSING AND IS HARD TO OPEN. ADJUSTED FORWARD UPPER MCD STOP PIN. OPERATIONAL CHECK GOOD.SDR SWIA200515219Control Unit · malfunctionedSSCU - NR 2 FAULT STATUS MESSAGE IS DISPLAYED. REPLACED NR 2 SSCU IAW CRJ MM 27-61-05. OPERATIONAL CHECK GOOD.SDR SWIA200515186Control Unit · malfunctionedSSCU 2 INOP MESSAGE. REPLACED NR 1 SSCU PER CRJ MM 27-61-05. OPERATIONAL CHECK GOOD.SDR SWIA200515182Control Unit · malfunctionedSPOILER/STAB FAULT STATUS MSG. REPLACED NR 2 SSCU IAW CRJ MM 27-61-05. OPERATIONAL CHECK GOOD.SDR SWIA200514663Computer · malfunctionedSTALL FAIL CAUTION MESSAGE. REPLACED STALL PROTECTION SYSTEM COMPUTER AND PERFORMED OPERATIONAL CHECKS, OPS CHECKED GOOD.SDR SWIA200414104Control Unit · inoperativeSSCU NR 2 INOPERATIVE STATUS MESSAGE. REMOVED AND REPLACED NR 2 SSCU IAW MM 27-61-05. OPERATIONAL CHECK GOOD. P/N:613645BA03, S/N OFF:735.
Back to N706SK