N802SK
Service difficulty reports · 338
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 = 'N802SK' 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 = 'N802SK' 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 SWIA201127593Light · inoperativeNR 7 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 4616) RELAMPED EMERGENCY LIGHT.SDR SWIA201127126Light · inoperativeNR 7 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 4727) RELAMPED EMERGENCY LIGHT.SDR SWIA201126846Light · inoperativeCEILING EMERGENCY LIGHT AT ROW 14 IS OUT. (FLT 4580) RELAMPED EMERGENCY LIGHT.SDR SWIA201126514Connector · dirtyEMERGENCY LIGHTS STAY ON WHEN SWITCH IS IN THE ARMED POSITION. (FLT 4464) CLEANED CONNECTOR ON EMERGENCY LIGHTS SWITCH PANEL.SDR SWIA201126448Light · inoperativeNR 2 OVERHEAD EMERGENCY LIGHT IS OUT. (SERVICE) RELAMPED EMERGENCY LIGHT.SDR SWIA201126449Light · inoperativeAFT OVERHEAD LIGHT BURNED OUT. (FLT 4759) RELAMPED OVERHEAD LIGHT.SDR SWIA201125889Light · inoperativeTHE 2ND FROM AFT CEILING EMERGENCY LIGHT IS OUT. (FLT 4557) RELAMPED EMERGENCY LIGHT.SDR SWIA201025263Light · inoperativeFORWARD EMERGENCY CEILING LIGHT OVER AISLE AT ROW 1 DOES NOT ILLUMINATE. (FLT 4758) RELAMPED EMERGENCY LIGHT.SDR SWIA201025142Light · inoperativeNR 3 OVERHEAD EMERGENCY LIGHT IS INOPERATIVE. (FLT 4817) RELAMPED EMERGENCY LIGHT.SDR SWIA201024270Light · inoperativeOVERHEAD EMERGENCY LIGHT AT ROW 8 INOP. (FLT 4783) RELAMPED EMERGENCY LIGHT.SDR SWIA201024136Drag Angle · crackedPASSENGER DOOR AFT DRAG ANGLE CRACKED. (C CHECK) REPAIRED PER REO.SDR SWIA201023753Light · inoperativeCEILING EMERGENCY LIGHT SECOND FROM AFT INOP. (FLT 4588) RELAMPED EMERGENCY LIGHT.SDR SWIA200923367Light · inoperativeREAR CEILING EMERGENCY LIGHT INOP. (FLT 4621) RELAMPED EMERGENCY LIGHT.SDR SWIA200923099Light · inoperativeEMERGENCY LIGHT AT ROW 17 INOP. (FLT 4484) RELAMPED.SDR SWIA200922986Controller · faultyPROGRESSIVE LOSS OF CABIN PRESSURE RESULTING IN O2 MASKS DEPLOYED AND EMERGENCY DESCENT AND DIVERSION. (FLT 4440) REPLACED ACSC CONTROLLER AND LEFT AND RIGHT BLEED SENSORS.SDR SWIA200922992Pressure System · malfunctionedPROGRESSIVE LOSS OF CABIN PRESSURE. (FLT 4440) REPLACED NR 1 ACSC.SDR SWIA200922531Light · inoperativeOVERHEAD EMERGENCY LIGHT IN AFT CABIN INOP. (FLT 4499) RELAMPED EMERGENCY LIGHT.SDR SWIA200922462Glowstrip · missingEMERGENCY EXIT ROW 13A/B MISSING FLOOR PHOTO LUMINESCENT STRIP. (FLT 4433) INSTALLED EMERGENCY LIGHT STRIP.SDR SWIA200922419Light · inoperativeAFT CEILING FLOODLIGHT INOP. (FLT 4616) RELAMPED CEILING LIGHT.SDR SWIA200921584Tire · failedFLT 4899 - NR 3 TIRE BLOWN ON TAKEOFF. ACCOMPLISHED INSPECTION AND CORRECTIVE ACTIONS.SDR SWIA200921551Lamp · burned outFLT 4513 - EMERGENCY FLOOD LIGHT INOP. RELAMPED.SDR SWIA200921487Lamp · burned outFLT 4404 - EMERGENCY LIGHT INOP. RELAMPED.SDR SWIA200921474Lamp · burned outFLT 4591 - EMERGENCY CEILING LIGHT NEAR AFT LAV INOP. RELAMPED.SDR SWIA200921416Lamp · burned outFLT 4652 - CABIN OVERHEAD FLOODLIGHT INOP. RELAMPED.SDR SWIA200921079Motor · failedFLT 4453 - WHEN LANDING GEAR EXTENDED, "LOW HYD SYS 3" MESSAGE DISPLAYED WITH QUANTITY AT ZERO. REPLACED EDP NR 3 PN: 66195-01, SN OFF: K1406.SDR SWIA200920882Light · not seatedFLT 4548 - NR 3 CEILING LEVEL EMERGENCY FLOODLIGHT IS INOP. RESEATED BULB.SDR SWIA200920845Lamp · burned outFLT 6655 - THIRD FROM AFT CEILING EMERGENCY LIGHT INOP. RELAMPED.SDR SWIA200920790Light · inoperativeFLT 4524 - SECOND TO LAST CEILING LIGHT INOP. RELAMPED.SDR SWIA200920794Light · inoperativeFLT 4751 - FOURTH AFT EMERGENCY LIGHT IN CEILING INOP. RELAMPED.SDR SWIA200820604Lamp · burned outFLT 4596 - FLIGHT ATTENDANT EMERGENCY EXIT SIGN INOP. RELAMPED.SDR SWIA200820502Bulkhead · crackedDURING C-CHECK, FS 280 LEFT BULKHEAD WEB CORRODED. REPAIRED PER REO.SDR SWIA200820501Bulkhead · corrodedDURING C-CHECK, FS 280 RIGHT BULKHEAD WEB CORRODED. REPAIRED PER REO.SDR SWIA200820500Beam · corrodedDURING C-CHECK, FS 280 BEAM CORRODED AT LBL9 AND RBL9. REPAIRED PER REO.SDR SWIA200819434Oxygen Mask · unwanted deployFLT 3809 - AFT LAV O2 MASKS DROPPED INFLIGHT. INSPECTED MASKS AND O2 SYSTEM. RESTOWED O2 MASKS. CHECKS GOOD.SDR SWIA200719011Bulb · burned outFLT 1991 - OVERHEAD EMERGENCY LIGHT IS INOP. REPLACED BULB WITH A SERVICEABLE UNIT IAW MM 33-51-00.
SDR SWIA200718392Unknown · odorCREW REPORTS STRONG FUEL ODOR COMING FROM FORWARD AND AFT LAVS. PERFORMED CLEANING AND FLUSHING PROCEDURES ON FORWARD AND AFT LAVS IAW MONOGRAM CMM 38-35-04. SNIFFER INDICATIONS ARE WITHIN LIMITS.SDR SWIA200717681Power Supply · dischargedFORWARD MOUNTED CEILING EXIT SIGN, FLOOR LEVEL EXIT SIGNS AT OVERWING EMERGENCY EXITS AND EXIT SIGNS ON CLOSET ON ROW 4 BOTH FWD AND AFT FACING ARE ALL INOP. REPLACED NR 3 EMERGENCY BATTERY PACK IAW MM 33-51-17. OPERATIONAL CHECKS GOOD, SN OFF 43882.SDR SWIA200617383Sensor · malfunctionedON DESCENT INTO SLC AUTO PILOT KICKED OFF WITH STALL FAIL CAUTION AND STICK SHACKER. STICK SHAKER WENT OFF 4 TIMES DURING DESCENT.REPLACED THE RIGHT AOA VANE IAW 27-35-05. OPERATIONAL CHECKS GOOD.
Back to N802SK