N732SK
Service difficulty reports · 190
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 = 'N732SK' 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 = 'N732SK' 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 SWIA201125780Light · inoperativeOVERHEAD EMERGENCY LIGHT AT ROW 2 IS OUT. (FLT 1352) RELAMPED EMERGENCY LIGHT.SDR SWIA201125625Light · inoperativeNR 1 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 6758) RELAMPED EMERGENCY LIGHT.SDR SWIA201125636Light · inoperativeNR 1 CEILING EMERGENCY LIGHT BURNED OUT. (FLT 1140) RELAMPED EMERGENCY LIGHT.SDR SWIA201025133Light · inoperativeNR 1 CEILING EMERGENCY LIGHT INOPERATIVE. (FLT 6828 )RELAMPED EMERGENCY LIGHT.SDR SWIA201024600Light · inoperativeEMERGENCY FLOODLIGHT AT ROW 2 INOP. (FLT 6709) RELAMPED EMERGENCY LIGHT.SDR SWIA201024043Light · inoperativeEMERGENCY CEILING LIGHT NR 3 INOP. (FLT 5869) RELAMPED EMERGENCY LIGHT.SDR SWIA201023886Beam · corrodedFS 280 BEAM CORRODED. (C CHECK) REPLACED BEAM PER SRM AND REO.SDR SWIA201024311Crossbeam · corrodedFS 280 CROSSBEAM CORRODED. (C CHECK) REPAIRED PER REO AND SRM.SDR SWIA201023652Light · inoperativeNR 3 EMERGENCY OVERHEAD LIGHT INOP. (FLT 6114) RELAMPED EMERGENCY LIGHT.SDR SWIA200923259Light · inoperativeCEILING LEVEL EMERGENCY FLOODLIGHT AT ROW 17 INOP. (FLT 6656)RELAMPED.SDR SWIA200923244Light · inoperativeEMERGENCY CEILING LIGHT AT ROW 2 INOP. (FLT 6467)RELAMPED.SDR SWIA200922803Light · inoperativeEMERGENCY LIGHT AT ROW 7 INOP. (FLT 6065) RELAMPED EMERGENCY LIGHT.SDR SWIA200922631Light · inoperativeOVERHEAD EMERGENCY LIGHT ABOVE ROWS 2 & 3 INOP. (FLT 6221) RELAMPED EMERGENCY LIGHT.SDR SWIA200922511Light · inoperativeOVERHEAD EXIT PATH LIGHT INOP. (FLT 6517) RELAMPED EXIT PATH LIGHT.SDR SWIA200921826Lamp · burned outFLT 6709 - GALLEY EMERGENCY INOP. RELAMPED.SDR SWIA200921469Lamp · burned outFLT 6401 - NR 1 CEILING EMERGENCY LIGHT INOP. RELAMPED.SDR SWIA200921393Lamp · burned outFLT 5975 - NR 4 CEILING EMERGENCY LIGHT INOP. RELAMPED.SDR SWIA200920894Lamp · burned outFLT 6832 - NR 6 EMERGENCY FLOODLIGHT INOP. RELAMPED.SDR SWIA200820616Channel · crackedC-CHECK, LEFT LOWER OUTBOARD 'U' CHANNEL CRACKED. REPAIRED PER REO.SDR SWIA200819777Windshield · crackedCAPTAINS FRONT WINDSHIELD CRACKED AT THE GATE. (FLT 5903) REPLACED CAPTAINS WINDSHIELD IAW MM 56-11-01.SDR SWIA200819493Window · delaminatedPILOT'S SIDE WINDOW IS DELAMINATING. REPLACED PILOT'S SIDE WINDOW, P/N OFF 601R33033-19, S/N OFF 0419H9492.SDR SWIA200718654Sign · missingFLT 6478 - FLOOR LEVEL GALLEY EMERGENCY EXIT SIGN IS MISSING COVER. INSTALLED NEW COVER.SDR SWIA200718751Pinion Gear · corrodedFOUND AT C-CHECK, LEFT WING PINION GEAR FOR SLAT TRACK 1-1 HAS PITTING. REPLACED SLAT PINION GEAR PER CRJ700/900 AMM 27-81-11-400-801-A01.
SDR SWIA200718750Pinion Gear · corrodedFOUND AT CHECK, LEFT WING PINION GEAR FOR SLAT TRACK 1-3 HAS PITTING. INSTALLED NEW SLAT PINION AND TRACK GEAR PER CRJ700/900 AMM 27-81-09-400-802-A01.SDR SWIA200718749Seat Track · corrodedFOUND AT C-CHECK, SEVERAL AREAS OF CORROSION ON LEFT SIDE SEAT RAIL AT FS 785. REPLACED SEAT RAIL AT FS785.15-792.00 AS PER CRJ700/900 SRM 51-42-13-001-001-A01.
SDR SWIA200718748Floorbeam · crackedFOUND AT C-CHECK, FLOOR SUPPORT ON FORWARD SIDE OF FS 280 BEAM IS CRACKED. REPLACED FLOOR SUPPORT AT FS 280 PER CRJ700/900 SRM 51-42-06 PAGE 7.
SDR SWIA200718099Lens · brokenEMERGENCY LIGHT LENS PLACARD IS MISSING AT GALLEY SERVICE DOOR. REPLACED FLOOD LIGHT ASSEMBLY IAW CRJ MM 33-51-01.SDR SWIA200617182O-Ring · damagedLEFT ENGINE LOW OIL PRESSURE IN FLIGHT ACCOMPLISHED SINGLE ENGINE LANDING. HYDRAULIC PUMP CANNON SEAL O-RING ON HOUSING DAMAGED. INSTALLED MATING RING AND CARBON SEAL IAW GE MANUAL GF34-8. OPERATIONAL CHECKS GOOD. MATING RING PN 4115T43P03 SN OFF JKHF4683.SDR SWIA200617055Web · crackedCRACK ON PASSENGER DOOR FORWARD WEB BETWEEN STEPS 5 AND 6 BEHIND HANDRAIL SUPPORT, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED REPAIR PER REO 670-52-11-104.SDR SWIA200617054Drag Angle · crackedCRACK ON AFT DRAG ANGLE NEXT TO DOOR ASSIST PULLEY, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED NEW DRAG ANGLE AND SPLICE ANGLES IAW REO 670-52-11-072.SDR SWIA200617053Web · crackedCRACK ON PASSENGER DOOR AFT WEB BETWEEN STEPS 5 AND 6 BEHIND HAND RAIL SUPPORT, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED FABRICATED PARTS AND COMPLETED REPAIR TO PAX DOOR AFT STEPS 5 AND 6 IAW CRJ REO NR 670-52-11-104.SDR SWIA200515911Light · inoperativeSERVICE DOOR EMERGENCY FLOOD LIGHT INOPERATIVE. REPLACED SERVICE DOOR EMERGENCY LIGHT AS REQ PER AMM 33-51-11. OPERATIONAL CHECK GOOD.SDR SWIA200515875Charger · inoperativeEMERGENCY EXIT SIGNS WON'T ILLUMINATE ON FORWARD BULKHEAD. REPLACED NR 2 EMERGENCY LIGHT BATTERY CHARGER IAW CRJ 700 AMM 33-51-17. OPERATIONAL CHECK GOOD.SDR SWIA200515123Control Unit · malfunctionedCREW REPORTS RUDDER LIMIT FAULT STATUS MESSAGE. REPLACED SSCU 1 IAW CRJ MM 27-61-05. OPERATIONAL CHECK GOOD.SDR SWIA200515042Pcu · malfunctionedINBOARD FLIGHT SPOILERS CAUTION & INBOARD SPOILERONS CAUTION MSG. REPLACED LEFT INBOARD MULTI FUNCTION SPOILER PCU IAW CRJ MM 27-62-01. OPERATIONAL CHECK GOOD.SDR SWIA200514984Dcu · malfunctionedAILERON TRIM ROLLED UNCOMMANDED TO LEFT. REPLACED NR 1 AND NR 2 DCU IAW CRJ AMM 31-70-00. OPERATIONAL CHECK GOOD. P/N 822-1310-102, S/N OFF 1L5JD, P/N 822-1310-102, S/N OFF 1MB3L.SDR SWIA200514962Trim Switch · stuckAILERON TRIM ROLLED UNCOMMANDED TO LEFT DURING PREFLIGHT CHECK. REPLACED AILERON TRIM SWITCH. OPERATIONAL CHECK GOOD.SDR SWIA200514818Control Unit · malfunctionedSLAT FAULT STATUS MSG APPEARED DURING FLIGHT. REPLACED CTL-22 IAW WDM 27-81-00. OPERATIONAL CHECK GOOD IAW MM 27-81-39.SDR SWIA200514736Trim System · malfunctionedAILERON TRIM RANAWAY DURING TAKEOFF ROLL. TAKEOFF CONFIG AILERON TRIM MOVES LWD. CLEANED TRIM SWITCHES & PANEL CONNECTOR. OHM'ED AND MEGGED WIRING BETWEEN AILERON TRIM ACTUATOR AND JB10. WIRING ALL OHM'ED OUT NORMAL. OPERATIONAL CHECK GOOD.SDR SWIA200514484Actuator · malfunctionedAILERON TRIM INDICATION WOULD MOVE BOTH LWD/ RWD TRIM 0 DEGREES TO 15 DEGREES ON ITS OWN (INDICATION ONLY). REMOVED AND REPLACED AILERON ACTUATOR IAW CRJ 700 MM 27-12-01. PERFORMED OPERATIONAL CHECK IAW CRJ 700 MM 27-11-00.
Back to N732SK