N712SK
Service difficulty reports · 144
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 = 'N712SK' 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 = 'N712SK' 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 SWIA201437013Lamp · burned outSECOND TO LAST CEILING LEVEL EMERGENCY FLOOD LIGHT IS BURNED OUT. REPLACED LAMP.SDR SWIA201335253Tension Tie · out of adjustUNABLE TO OPEN MAIN CABIN DOOR FROM OUTSIDE OF THE AIRCRAFT. CYCLED DOOR FIVE TIMES STILL UNABLE TO OPEN DOOR FROM OUTSIDE. FLT 5161 OPENED & CLOSED THE PAX DOOR SEVERAL TIMES FROM THE OUTSIDE & INSIDE, DOOR OPENED & CLOSED NORMALLY WITH ONLY SLIGHT RESISTANSDR SWIA201335197Light · inoperativeSECOND TO LAST EMERGENCY OVERHEAD LIGHT IS BURNED OUT. FLT5628 RELAMPED.SDR SWIA201334426Light · inoperativeFLOOR LEVEL EMERGENCY LIGHT HAS A LIGHT BULB BURNED OUT. FLT#6731 RELAMPED.SDR SWIA201334184Light · inoperativeAFT EMERGENCY OVERHEAD LIGHT IS BURNED OUT. SERVICE RELAMPED.SDR SWIA201332922Axle · corrodedFOUND CORROSION ON LEFT NR 1 MLG AXLE. (C-CHECK) REPAIRED LEFT MLG NR 1 AXLE IAW REO.SDR SWIA201332921Axle · corrodedCORROSION FOUND ON LEFT MLG NR 2 AXLE. (C-CHECK) REPAIRED LEFT MLG NR 2 AXLE IAW REO.SDR SWIA201332920Axle · corrodedCORROSION FOUND ON RIGHT MLG NR 3 AXLE. (C-CHECK) REPAIRED RIGHT MLG NR 3 AXLE IAW REO.SDR SWIA201332923Crossbeam · corrodedTHE 280 CROSSBEAM CORRODED AND CRACKED. (C-CHECK) REPLACED 280 CROSSBEAM IAW REO.SDR SWIA201332497Printed Ckt Board · failedEMERGENCY LIGHTS WITH SWITCH IN ARMED POSITION FLASHING ON AND OFF IN FLIGHT. (FLT 533) REMOVED AND REPLACED PCB5 IN JB11.SDR SWIA201332515Light · inoperativeAFT EMERGENCY OVERHEAD LIGHT BURNED OUT. (SERVICE) RELAMPED EMERGENCY LIGHT.SDR SWIA201231283Pin · failedFORWARD OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5400) REPLACED PIN AT CONNECTOR J355.SDR SWIA201230217Light · inoperativeNR 2 OVERHEAD EMERGENCY LIGHT IS OUT. (SERVICE) RELAMPED EMERGENCY LIGHT.SDR SWIA201229736Light · inoperativeTHE 2ND FROM AFT OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 6414) RELAMPED EMERGENCY LIGHT.SDR SWIA201229249Light · inoperativeNR 5 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5312) RELAMPED EMERGENCY LIGHT.SDR SWIA201128846Light · inoperativeAFT CEILING EMERGENCY LIGHT IS OUT. (FLT 5334) RELAMPED EMERGENCY LIGHT.SDR SWIA201127886Relay · failedEMERGENCY LIGHTS RANDOMLY ILLUMINATING WITH COCKPIT SWITCH IN THE ARM POSITION. (FLT 2036) REPLACED RELAY K-135.SDR SWIA201127314Light · damagedEMERGENCY LIGHT NEAR MAIN CABIN DOOR IS DAMAGED. (FLT 6497) REPLACED MCD EMERGENCY LIGHT ASSEMBLY.SDR SWIA201128658Beam · crackedRIGHT 280 BEAM CRACKED AT RBL 9. (C-CHECK) REPAIRED PER REO.SDR SWIA201126319Light · inoperativeEMERGENCY LIGHT OVER LEFT EXIT ROW IS OUT. (FLT 6882) RELAMPED EMERGENCY LIGHT.SDR SWIA201024838Motor · malfunctionedMAIN CABIN DOOR WOULD NOT OPEN MORE THAN A FEW INCHES UPON ARRIVAL. (FLT 6823) REMOVED AND REPLACED MAIN CABIN DOOR POWER ASSIST MOTOR ASSEMBLY.SDR SWIA201024333Battery · dischargedMAIN CABIN DOOR EMERGENCY SIGN INOP. (FLT 6254) REPLACED FORWARD EMERGENCY LIGHT BATTERY.SDR SWIA201024293Charger · inoperativeGALLEY DOOR EMERGENCY EXIT SIGN INOP. (FLT 5973) REPLACED EMERGENCY BATTERY CHARGER NR 1.SDR SWIA201023659Light · inoperativeAFT EMERGENCY CEILING LIGHT INOP. (FLT 5943) RELAMPED EMERGENCY LIGHT.SDR SWIA201023658Light · inoperativeRIGHT SIDE LOWER OVERWING EMERGENCY EXIT SIGN INOP. (FLT 6514) RELAMPED EMERGENCY LIGHT.SDR SWIA200923219Beam · crackedFS280 BEAM CRACKED. (C CHECK)REPAIRED PER REO.SDR SWIA200923812Bulkhead · corrodedLEFT BULKHEAD WEB CORRODED. (C CHECK) REPAIRED PER SRM.SDR SWIA200923811Web · crackedPASSENGER DOOR AFT WEB CRACKED. (C CHECK) REPAIRED PER REO.SDR SWIA200923810Floorbeam · crackedFS 280 FLOORBEAM CRACKED. (C CHECK) REPAIRED PER REO.SDR SWIA200921999Lamp · burned outFLT 5861, CABIN EMERGENCY LIGHT AT MAIN DOOR INOP. RELAMPED.SDR SWIA200921437Light · inoperativeFLT 6155 - LAST CEILING EMERGENCY LIGHT INOP. REPLACED LIGHT ASSEMBLY.SDR SWIA200921008Mount · corrodedLEFT ENGINE FORWARD YOKE MOUNT CORRODED. SERVICE BULLETIN COMPLIANCE CHECK, REPLACED MOUNT.SDR SWIA200820662Landing Gear · frozenFLT 5834 - NOSE GEAR FAILED TO RETRACT. USED GROUND AIR CONDITION CART TO THAW NLG. CYCLED NLG 5 TIMES, CHECKS NORMAL.SDR SWIA200718507Drag Angle · crackedPASSENGER DOOR AFT DRAG ANGLE IS CRACKED, DISCOVERED AT C-CHECK. INSTALLED FILLER AND SPLICE ANGLES PER REO 670-52-11-072.SDR SWIA200718506Floor Support · crackedAFT COCKPIT FLOOR SUPPORT CRACKED IN 2 PLACES, DISCOVERED AT C-CHECK. REPLACED COCKPIT FLOOR SUPPORT PER CRJ700/900 SRM 51-42-06-001-001-A01.SDR SWIA200718505Floorbeam · crackedFLOOR SUPPORT 280 CRACKED AT LBL 9, DISCOVERED AT C-CHECK. REPLACED FS 280 FLOOR SUPPORT BEAM SECTIONS, DOUBLERS, AND RADIUS PLATE PER REO:670-53-11-047 REV (D).SDR SWIA200717776Battery · dischargedFOUND EMERGENCY LIGHTS INOP. REPLACED NR 2 EMERGENCY LIGHT CHARGER AND BATTERY IAW AMM 33-51-17. OPERATIONAL CHECKS GOOD, S/N OFF - 35157.SDR SWIA200616589Light · brokenSERVICE DOOR EMERGENCY LIGHT IS BROKEN. INSTALLED SERVICEABLE LIGHT ASSY AT SERVICE DOOR. OPERATIONAL CHECK GOOD.SDR SWIA200515536Detector · malfunctioned"SLAT FAULT" STATUS MSG AT GATE. REPLACED LEFT OUTBOARD SLAT SKEW DETECTOR. OPERATIONAL CHECK GOOD IAW MM 27-51-00.SDR SWIA200515428Detector · inoperativeSLAT FAULT STATUS MSG AT GATE. REPLACED LEFT INBOARD SLAT SKEW DETECTOR. OPERATIONAL CHECK GOOD, IAW 27-81-00.SDR SWIA200515294Control Unit · malfunctionedSSCU 1 FAULT STATUS MSG.REPLACED NR 1 SSCU IAW MM 27-61-05. OPERATIONAL CHECK GOOD IAW MM 27-61-05.SDR SWIA200515183Sensor · malfunctionedSLAT FAULT STATUS MSG. REPLACED RT INBOARD SLAT DISCONNECT SENSOR IAW MM 27-81-39. OPERATIONAL CHECK GOOD.SDR SWIA200414266Sensor · faultySLAT FAULT STATUS MESSAGE CLIMBING OUT OF FL250. REPLACED INBOARD LEFT SLAT DISCONNECT SENSOR IAW MM 27-81-39. OPERATIONAL CHECK GOOD IAW MM 27-81-39.SDR SWIA200414075Control Unit · malfunctionedAFTER STAB TRIM TEST SSCU 1 FAULT MESSAGE STATUS ILLUMINATED. REMOVED AND REPLACED SSCU NR 1 IAW MM 27-61-05. OPERATIONAL CHECK GOOD.
Back to N712SK