N727SK
Service difficulty reports · 184
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 = 'N727SK' 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 = 'N727SK' 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 SWIA201125616Light · looseNR 1 OVERHEAD EMERGENCY LIGHT BURNED OUT. (FLT 7024) TIGHTENED LAMP IN RECEPTACLE.SDR SWIA201125569Battery Pack · dischargedNR 1 EMERGENCY LIGHT BATTERY PACK IS WEAK. (SERVICE) REPLACED NR 1 ELBP.SDR SWIA201125497Light · inoperativeTHE 2ND FROM AFT CEILING EMERGENCY LIGHT IS OUT. (FLT 6486) RELAMPED EMERGENCY LIGHT.SDR SWIA201025040Light · inoperativeFIRST EMERGENCY LIGHT, CENTER CEILING, IS INOPERATIVE. (FLT 6155) RELAMPED EMERGENCY LIGHT.SDR SWIA201024572Light · inoperativeF/A REPORTS FORWARD CEILING LIGHT INOP. (FLT 6734) RELAMPED CEILING LIGHT.SDR SWIA201024252Sign · inoperativeEMERGENCY EXIT SIGN INOP. (FLT 6667) RELAMPED EMERGENCY EXIT SIGN.SDR SWIA201024120Mount · corrodedRIGHT ENGINE MOUNT ASSEMBLY CORRODED. (ENG CHANGE) REPLACED RIGHT ENGINE MOUNT ASSEMBLY.SDR SWIA201023855Floorbeam · crackedFS 280 FLOORBEAM CRACKED AND CORRODED. (C CHECK) REPLACED PER REO.SDR SWIA201024046Floorbeam · crackedFS 280 FLOORBEAM CRACKED AND CORRODED. (C CHECK) REPLACED PER REO.SDR SWIA201023741Light · inoperativeNR 5 CEILING EMERGENCY LIGHT INOP. (FLT 6656) RELAMPED EMERGENCY LIGHT.SDR SWIA200923432Charger · inoperativeFLT 6009 - MOST AFT OVERHEAD EMERGENCY LIGHT INOP. REPLACED NR 5 EMERGENCY LIGHT BATTERY CHARGER.SDR SWIA200922965Light · inoperativeEMERGENCY LIGHT IN CEILING AT ROW 9 INOP. (FLT 5780) RELAMPED EMERGENCY LIGHT.SDR SWIA200922545Light · inoperativeCABIN FLOOR LEVEL EMERGENCY FLOOD LIGHT INOP. (FLT 5858) REPLACED FLOODLIGHT BASE PER AMM.SDR SWIA200921383Windshield · failedFLT 6219 - CAPTAIN'S WINDSHIELD SHATTERED. REPLACED WINDSHIELD.SDR SWIA200921370Windshield · crackedFLT 5889 - RIGHT WINDSHIELD CRACKED. REPLACED WINDSHIELD.SDR SWIA200921009Lamp · burned outFLT 6669 - EMERGENCY LIGHT ON CABIN CEILING INOP. RELAMPED.SDR SWIA200820548Bolt · corrodedDURING C-CHECK, RIGHT MLG INBOARD RETRACT ACTUATOR BRACKET BOLT CORRODED. REPLACED PER CMM.SDR SWIA200820547Axle · corrodedC-CHECK, LEFT MLG PISTON AXLE ROOT CORRODED. REPAIRED PER SCR.SDR SWIA200820546Gland Nut · corrodedC-CHECK, RIGHT MLG CYLINDER GLAND NUT CORRODED. REPLACED PER AMM.SDR SWIA200820545Axle · corrodedC-CHECK, RIGHT MLG PISTON AXLE ROOT CORRODED. REPAIRED PER SCR.SDR SWIA200819920Tire · failedBOTH NR 1 AND NR 2 MLG TIRES BURST ON TAKE-OFF. REPLACED NR1 AND NR2 TIRE ASSEMBLIES IAW MM 32-41-01 AND COMPLIED WITH RELATED REPAIRS. PN: 5013641 S/N OFF: APR04-1169
SDR SWIA200819388Fan · out of balanceFLT 6434 - LEFT ENGINE VIBE GAUGE BEGAN TO INCREASE. COMPLIED WITH ENGINE FAN TRIM BALANCE IAW 71-00-00. OPS CHECK GOOD.SDR SWIA200819332Lens · missingFLT 6392 - LENS OF EMERGENCY LIGHT IS MISSING. INSTALLED SERVICEABLE LENS ON EMERGENCY LIGHT. OPS CHECK GOOD.
SDR SWIA200718686Floorbeam · crackedFS 280 FLOOR SUPPORT BEAM IS CRACKED AT LBL9, FOUND AT C-CHECK. INSTALLED FS 280 FLOOR SUPPORT BEAM AND INTERCOSTALS PER CRJ7/9 SRM 51-42-21, 51-42-06, SRM 51-23-00 AND REO:670-53-11-242 REV B.SDR SWIA200718685Link · corrodedLEFT WING AILERON PCU LINK HAS SURFACE CORROSION, FOUND AT C-CHECK. REMOVED SURFACE CORROSION ON PCU LINK PER SRM 51-21-06-001-001-A01 PART 6.SDR SWIA200718684Floorbeam · crackedFOUND COCKPIT FLOORBEAM ANGLE IS CRACKED AT RBL9, FOUND AT C-CHECK. INSTALLED COCKPIT FLOOR SUPPORT ANGLE PER CRJ700/900 SRM 51-42-06.SDR SWIA200718683Drag Angle · crackedPAX DOOR AFT DRAG ANGLE IS CRACKED, FOUND AT C-CHECK. INSTALLED REPAIR PARTS PER REO 670-52-11-072.SDR SWIA200718258Relay · malfunctionedEMERGENCY LIGHTS ARE FLASHING ON AND OFF IN THE ARMED POSITION. REPLACED RELAY K135. OPS CHECKS GOOD.SDR SWIA200616827Oxygen Mask · deployedPASSENGER OXYGEN MASKS IN OVERHEAD BINS AT SEATS 4CD POPPED OPEN. STOWED OXYGEN MASKS AT SEATS 4CD. OXYGEN GENERATORS NOT USED OR DAMAGED. OPERATIONAL CHECKS GOOD.SDR SWIA200617077Handle · crackedCRACKED OUTER HANDLE, PAX DOOR, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED NEW PAX DOOR HANDLE P/N NR 601R31763-1 PER CRJ 700 AMM 52-11-03-400-801-A01.SDR SWIA200617076Bracket · crackedPAX DOOR CRACK BY HANDRAIL SUPPORT BRACKET FWD SIDE CRACKED, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED REPAIR ANGLES AND DOUBLER IAW REO 670-52-11-104.SDR SWIA200617075Bracket · crackedPAX DOOR CRACK BY HANDRAIL SUPPORT BRACKET AFT SIDE CRACKED, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED 670-52-11-104-1; -2; AND -3 REPAIR DOUBLER AND ANGLES PER CRJ REO 670-52-11-104.SDR SWIA200616400Sensor · malfunctionedSLAT FAULT MSG. REPLACED RT INBD SLAT DISCONNECT SENSOR. OPERATIONAL CHECK GOOD IAW 27-81-00.SDR SWIA200515923Light · burned outSERVICE DOOR ILLUMINATION LIGHT INOP. REPLACED LIGHTS ON SERVICE DOOR EMERGENCY EXIT LIGHT IAW MM 33-51-15. OPERATIONAL CHECK GOOD.
Back to N727SK