N762SK
Service difficulty reports · 169
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 = 'N762SK' 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 = 'N762SK' 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 SWIA200922691Light · missingRIGHT WING FLOOR LEVEL EMERGENCY LIGHT IS MISSING A BULB. (FLT 5898) REPLACED RT OVERWING FLOOR LEVEL EXIT SIGN BULB IAW MM 33-51-15.SDR SWIA200922615Light · inoperativeEMERGENCY CEILING LIGHT ABOVE ROW 15 INOP. (FLT 5890) RELAMPED EMERGENCY LIGHT.SDR SWIA200922499Light · inoperativeEMERGENCY LIGHT INOP. (FLT 6065) RELAMPED EMERGENCY LIGHT.SDR SWIA200921768Printed Ckt Board · defectiveEMERGENCY LIGHTS CYCLE ON AND OFF EN ROUTE. (FLT 6209) REPLACED PRINTED CIRCUIT BOARD NR 5 IN JB11.SDR SWIA200921339Lamp · burned outFLT 6542 - AFT EMERGENCY LIGHT INOP. RELAMPED.SDR SWIA200921953Floorbeam · crackedFS 280 BEAM CRACKED AND CORRODED. (C CHECK) REPAIRED PER REO.SDR SWIA200920840Lamp · burned outFLT 6638 - AFT CEILING EMERGENCY LIGHT INOP. RELAMPED.SDR SWIA200819555Floorbeam · crackedCOCKPIT FLOOR SUPPORT IS CRACKED AT FS 280, FOUND AT C-CHECK. INSTALLED COCKPIT FLOOR SUPPORT PER CRJ700/900 SRM 51-42-06-001-001-A01.
SDR SWIA200819554Floorbeam · crackedFS 280 BEAM IS CRACKED AT LBL 9, FOUND AT C-CHECK. REPAIRED FLOORBEAM AT FS 280 PER CRJ700/900 SRM 51-42-068 AND REO 670-53-11-265.
SDR SWIA200819553Handle · bindingCREW ESCAPE HATCH HANDLE BINDS, FOUND AT C-CHECK. RIGGED CREW ESCAPE HATCH LATCH MECHANISM PER CRJ7/9 AMM 52-22-02-820-801-A01. OPS CHECK GOOD.
SDR SWIA200718865Lamp · burned outFLT 6690 - CEILING EMERGENCY FLOOD LIGHT IS INOP. RELAMPED CEILING FLOOD LIGHT IAW CRJ 700 AMM 33-51-09. OPS CHECK GOOD.
SDR SWIA200718649Acm · smokeFLT 6056 - FLIGHT ATTENDANT REPORTED SMOKE IN CABIN. REPLACED RIGHT ACM IAW CRJ MM 21-51-08. OPS CHECK GOOD.SDR SWIA200617465Support · crackedPAX DOOR FWD & AFT HANDRAIL SUPPORT CRACKED. DISCOVERED DURING C-CHECK INSPECTION. FABRICATED AND INSTALLED DOUBLERS AND ANGLES.SDR SWIA200616660Windshield · failedRIGHT WINDSHIELD SHATTERED WHILE CLIMBING THROUGH FL 320. REPLACED RIGHT WINDSHIELD IAW CRJ 700 MM 56-11-01, P/N OFF: 601R33033-55 (NP-139321-14), S/N OFF: 05160H2240.SDR SWIA200616196Detector · malfunctionedFLAPS HALFSPEED STATUS MESSAGE. REPLACED THE LEFT O/B AND THE LEFT I/B SKEW DETECTORS PER CRJ MM 27-52-45. OPERATIONAL CHECK GOOD PER CRJMM 27-50-00 LT I/B, 5913163 SN OFF A1382, LH O/B PN 5913164 SN OFF A1351.SDR SWIA200516023Control Unit · malfunctioned"FLAPS HALFSPEED" STATUS MSG. REPLACED NR 1 SFECU IAW MM 27-51-05. OPERATIONAL CHECK GOOD.SDR SWIA200515994Controller · malfunctionedFLAPS HALFSPEED MESSAGE. REPLACED SFECU1 IAW MM 27-51-05. OPERATIONAL CHECK GOOD.SDR SWIA200515925Flap · out of rigFLAPS HALFSPEED STATUS MESSAGE IN TAXI OUT. RIGGED LT IB SKEW DETECTOR. CLEAR INHIBITS. OPERATIONAL CHECKS GOOD. IAW 27-51-00.SDR SWIA200515887Controller · malfunctionedSLATS HALF SPEED STATUS MESSAGE DISPLAYED. REPLACED SFECU 2 IAW AMM 27-51-05. OPERATIONAL CHECK GOOD.
Back to N762SK