N719SK
Service difficulty reports · 189
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 = 'N719SK' 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 = 'N719SK' 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 SWIA201230956Light · inoperativeLEFT WING EMERGENCY EXIT LIGHT IS OUT. (FLT 5401) RELAMPED EMERGENCY LIGHT.SDR SWIA201230390Light · inoperativeNR 3 OVERHEAD EMERGENCY LIGHT IS OUT. (SERVICE) RELAMPED EMERGENCY LIGHT.SDR SWIA201230166Light · inoperativeNR 3 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5391) RELAMPED EMERGENCY LIGHT.SDR SWIA201229711Lamp · burned outNR 3 LEFT EXTERIOR EMERGENCY LIGHT IS OUT. RELAMPED EMERGENCY LIGHT.SDR SWIA201229199Pump · failedHYDRAULIC NR 2 LOW PRESSURE. (FLT 5309) REPLACED THE NR 2 ENGINE HYDRAULIC PUMP.SDR SWIA201024772Light · inoperativeAFT CEILING EMERGENCY LIGHT INOP. (FLT 6289) RELAMPED EMERGENCY LIGHT.SDR SWIA201024487Light · inoperativeREAR EMERGENCY CEILING LIGHT INOP. (FLT 6858) RELAMPED EMERGENCY LIGHT.SDR SWIA201024488Light · inoperativeOVERHEAD EMERGENCY CEILING LIGHT NR 6 INOP. (FLT 6080) RELAMPED EMERGENCY LIGHT.SDR SWIA201024074Light · not seatedOVERHEAD EMERGENCY EXIT LIGHT SIGN INOP AT ROW 11. (FLT 6443) RESEATED BULBS.SDR SWIA201024073Light · inoperativeAFT MOST OVERHEAD EMERGENCY LIGHT INOP. (FLT 6219) RELAMPED EMERGENCY LIGHT.SDR SWIA201023771Light · inoperativeNR 3 OVERHEAD EMERGENCY LIGHT INOP. (FLT 5776) RELAMPED EMERGENCY LIGHT.SDR SWIA201024051Floorbeam · crackedFS 280 FLOORBEAM CRACKED. (C CHECK) REPAIRED PER REO.SDR SWIA200923360Rod · looseSERVICE DOOR WILL NOT OPEN. (FLT 6573) RE-SECURED DOOR LIFTING ROD.SDR SWIA200922863Bushing · corrodedLEFT ENGINE YOKE LINK BOLT BUSHING CORRODED. (ENG CHG) REPLACED BOLT BUSHING PER AMM.SDR SWIA200922759Cable · wornMAIN CABIN DOOR WILL NOT CLOSE. (FLT 6061) REPLACED OUTER HANDLE FLAP CABLE.SDR SWIA200922710Light · inoperativeONE (1) OF THE EXIT LIGHTS AT LEFT OVERWING EXIT, DOES NOT ILLUMINATE. (FLT 6478) RELAMPED LIGHT.SDR SWIA200922001Windshield · crackedFLT 6033, RIGHT WINDSHIELD CRACKED IN CRUISE. REPLACED WINDSHIELD.SDR SWIA200921441Lamp · burned outFLT 6732 - EMERGENCY EXIT SIGN ABOVE FA FLASHLIGHT INOP. RELAMPED.SDR SWIA200819980Cover · missingEMERGENCY EXIT LIGHT COVER IS MISSING NEAR SERVICE DOOR. FLIGHT 6343. REPLACED LENS FOR SERVICE DOOR.
SDR SWIA200718637Floor Support · crackedAFT COCKPIT FLOOR SUPPORT IS CRACKED, FOUND AT C-CHECK. REPLACED COCKPIT FLOOR SUPPORT PER SB670-53-026.SDR SWIA200718635Floorbeam · crackedSTA 280 FLOORBEAM SUPPORT IS CRACKED AT LBL9, FOUND AT C-CHECK. INSTALLED REPAIR PARTS AND BEAM AT STA 280 PER CRJ7/9 SRM 51-42-06-001-001 AND REO:670-53-11-242.SDR SWIA200718057Charger · inoperativeFLOOR-LEVEL LIGHTED EXIT SIGN AT ROW 18 ON RIGHT SIDE IS OUT. REPLACED BATTERY CHARGER PER AMM 33-51-17. OPERATIONAL CHECKS GOOD.SDR SWIA200717984Battery Pack · dischargedFOUND RIGHT MID FUSELAGE LOWER EMERGENCY LIGHT PLACARD WON`T ILLUMINATE. REPLACED NR 4 EMERGENCY LIGHT BATTERY PACK. OPERATIONAL CHECKS GOOD IAW CRJ 200 MM 33-51-00.SDR SWIA200617410Lamp · burned out3RD BACK CABIN EMERGENCY LIGHTS CEILING FLOOD LIGHT OUT. RELAMPED 3RD BACK CEILING EMERGENCY LIGHT. OPERATIONAL CHECKS GOOD.SDR SWIA200616774Wire · disconnectedEMERGENCY LIGHTS ON FORWARD RIGHT WIND SCREEN ARE INOP. RECONNECTED WIRES TO FORWARD RIGHT WINDSCREEN. OPERATIONAL CHECKS GOOD PER MM 33-51-01.SDR SWIA200617038Drag Angle · crackedPAX DOOR AFT DRAG ANGLE CRACKED, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED REPAIR PARTS TO AFT DRAG ANGLE ON PAX DOOR PER CRJ700 SRM 51-42-11 PG 4; 51-42-06 PG 7 AND RII52-401.SDR SWIA200616630Detector · malfunctionedFLAPS HALFSPEED STATUS MSG. REPLACED LT I/B SKEW DETECTOR PER CRJ MM 27-52-45. OPERATIONAL CHECK GOOD.SDR SWIA200616108Battery · dischargedEMERGENCY LIGHTS EXIT SIGNS DON'T LIGHT ON BULKHEAD 1ST CLASS AND ON CEILINGS ROW 12. REPLACED NR 2 EMERGECNY BATTERY IAW 33-51-17. OPERATIONAL CHECKS GOOD.SDR SWIA200515873Charger · inoperativeCABIN EMERGENCY LIGHTS BETWEEN BUSINESS CLASS AND COACH ON BULKHEAD BOTH INOP. INSTALLED NEW FUSE FOR BATTERY PACK 2 CHARGER. OPERATIONAL CHECK GOOD IAW CRJ 700 AMM 33-51-00; 33-51-17.SDR SWIA200515563Control Unit · malfunctioned"SSCU 1 FAULT" AND "SPL/STAB FAULT" STATUS MSGS. REPLACED NR 1 SSCU IAW CRJ MM 27-41-00. OPERATIONAL CHECK GOOD.SDR SWIA200515548Actuator · malfunctionedFLAPS FAILED AT 20 DEGREES. REPLACED LEFT NR 2 ACTUATOR PER CRJ MM 27-52-09. OPERATIONAL CHECK GOOD.SDR SWIA200515466Detector · malfunctionedFLAPS HALFSPEED STATUS MESSAGE DURING TAXI. REPLACED RIGHT WING OUTBOARD FLAP SKEW DETECTOR FOR NR 1 SFCU IAW MM 27-52-45. OPERATIONAL CHECK GOOD.SDR SWIA200515431Flap System · out of rigFLAPS FAIL MESSAGE ON CLIMB-OUT. CLEARED INHIBITS. ELECTRICALLY RIGGED FLAPS. OPERATIONAL CHECK GOOD.SDR SWIA200515335Spring · malfunctioned"FLAPS FAIL" MESSAGES. RESET FLAP ACTUATOR (RT) SPRING TYPE INDICATOR IAW CRJ MM 27-52-09-610-802-A01. OPERATIONAL CHECK GOOD.SDR SWIA200515282Pdu · malfunctionedFLAPS FAIL CAUTION MESSAGE ON GROUND. REPLACED FLAP PDU IAW MM 27-52-37. OPERATIONAL CHECK GOOD, PN 766359B, SNOFF 0543.SDR SWIA200514940Control Unit · malfunctionedRUDDER LIMIT FAULT STATUS MESSAGE ON CLIMBOUT. REPLACED NR 1 SSCU IAW 27-61-05. OPERATIONAL CHECK GOOD.SDR SWIA200514908Control Unit · malfunctionedSTAB/SPOILER FAULT WILL NOT CLEAR. REPLACED NR 2 SSCU WITH SERVICEABLE UNIT. OPERATIONAL CHECK GOOD AMM 27-61-05.SDR SWIA200514620Actuator · malfunctionedRUDDER LIMIT FAULT STATUS MESSAGE. REPLACED NR 1 RUDDER LIMITER ACTUATOR (A203) IAW CRJ MM 27-25-03. OPERATIONAL CHECK GOOD. P/N BA670-93490-3, S/N OFF 0513.SDR SWIA200514411Control Unit · malfunctionedSTAB CH 2 INOP STATUS MESSAGE. REPLACED NR 2 SSCU IAW MM 27-61-05. OPERATIONAL CHECK GOOD. P/N C13045BA03, S/N OFF 826.
Back to N719SK