N797SK
Service difficulty reports · 118
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 = 'N797SK' 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 = 'N797SK' 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 SWIA201641990Panel · gougedPANEL 443 BB HAS GOUGE ON AFT CORNER. REPAIRED PANEL IAW SRM.SDR SWIA201641989Attach Angle · corrodedPAX DOOR LOWER SILL FLOOR ATTACH ANGLE HAS CORROSION ON CABIN SIDE BS FS 319 - 349. C-CHECK. INSTALLED NEW LOWER SILL FLOOR ATTACH ANGLE, IAW SRM.SDR SWIA201439144Blade · stuckEXCESSIVE N1 FAN VIBRATION ON RT ENGINE. INSPECTED RT FAN. FOUND TWO STUCK BLADES. FREED BLADES. PERFORMED VIBRATION CHECK IAW AMM. VIBRATION CHECK PASSED.SDR SWIA201439069Battery Pack · inoperativeAFT FLASHLIGHT IS NOT FLASHING. REMOVED AND REPLACE AFT FLASHLIGHT BATTERY PACK IAW AMM.SDR SWIA201438650Battery Pack · inoperativeBATTERY PACK OF THE CENTER EMERGENCY LIGHTS IN CABIN IS INOPERATIVE. C-CHECK, R & R WITH NEW SERVICEABLE EPSU NR 2 IAW AMM. OPS CHECKED GOOD AT THIS TIME.SDR SWIA201438648Wire · brokenBROKEN WIRE ON FORWARD EMERGENCY LIGHTS BATTERY CHARGER CONNECTOR PS35. C-CHECK INSTALLED NEW SPLICE CR124 IAW WDM AND ESPM.SDR SWIA201438651Retainer · chafedFWD CARGO DOOR, OUTER DOOR SEAL RETAINER CHAFED AT LOWER CORNERS, 2 EA FWD & AFT AREAS. C-CHECK, TRIMMED OUT CHAFES IAW REO.SDR SWIA201438649Fairing · chafedVERTICAL STABILIZER FAIRING 326CL IS CHAFED ON L/E UNDER TEFLON STRIP. C-CHECK, BLENDED-OUT DAMAGE AND RESTORED FINISH TO VERTICAL STABILIZER FAIRING PANEL 326CL IAW STS EA.SDR SWIA201438652Floorbeam · crackedBS 274, FLOORBEAM IS CRACKED. C-CHECK BS 274 FLOORBEAM REPAIRED IAW REO.SDR SWIA201437804Housing · brokenEMERGENCY FLOOD LIGHT IN GALLEY NEXT TO GALLEY SERVICE DOOR HAS A BROKEN HOUSING. REPLACED FLOOR LEVEL EMERGENCY FLOOD LIGHT IAW AMM.SDR SWIA201436411Trim Panel · faultyCONFIGURE TRIM WARNING. NOTICED AILERON & RUDDER TRIM INDICATIONS FULLY DEFLECTED. IN FLIGHT SLOWLY RETURNED TO CTR. RUDDER REMAINED, AILERON CONTINUED ROLL DEFLECTION IN OPPOSITE DIRECTION. AIRCRAFT OPERATED NORMALLY OTHERWISE. IN FLIGHT CAUTION AP TRIM SDR SWIA201333167Wire · out of rigON THE CLIMBOUT WITH FLAPS UP, ACCELERATING AT 230 KTS INDICATED, FLAP HIGH SPEED WARNING SOUNDED. SLOWED TO UNDER 230, WENT AWAY. UPON FLAPS SELECTION TO 20, FLAP FAIL CAUTION. RAN QRH, LANDED WITHOUT FURTHER PROBLEM. LEFT FLAP FAILED AT 0°, RIGHT FLAP FSDR SWIA201332525Light · inoperativeEMERGENCY OVERHEAD LIGHT AT ROW 14 DOES NOT ILLUMINATE. (FLT 5549) RELAMPED EMERGENCY LIGHT.SDR SWIA201232172Pump · leakingDIVERTED TO BILLINGS WITH A LOSS OF HYDRAULIC FLUID IN THE NR 1 SYSTEM. (FLT 6385) REPLACED ENGINE DRIVEN PUMP, REPLACED HYDRAULIC SYSTEM NR 1 CASE DRAIN FILTER, AND PRESSURE FILTER IN REFERENCE TO CRJ MM. P/N: 66190-05 S/N OFF: K0861; P/N: AC7031F8; P/N: ASDR SWIA201231621Fadec · failedRIGHT FADEC CAUTION MESSAGE. (FLT 6368) REPLACED THE RIGHT FADEC IN REFERENCE TO AMM. P/N: 4120T00P54 S/N OFF: LMDAE061.SDR SWIA201230854Light · inoperativeLEFT AFT EXTERNAL EMERGENCY LIGHT IS OUT. (FLT 5177) RELAMPED EMERGENCY LIGHT.SDR SWIA201024537Light · inoperativeEMERGENCY EXIT FLOODLIGHT FLOOR LEVEL AT GALLEY INOP. (FLT 6105) RELAMPED EMERGENCY LIGHT.SDR SWIA201024037Bearing · sticksYOKE STICKS IN AILERON CONTROL, MOST OBVIOUS IN RIGHT ROLL INPUT. (FLT 6579) REPLACED FIRST OFFICERS CONTROL COLUMN SHAFT BEARINGS.
Back to N797SK