N810SK
Service difficulty reports · 147
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 = 'N810SK' 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 = 'N810SK' 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 SWIA201230411Light · inoperativeNR 2 OVERHEAD EMERGENCY LIGHT IS OUT. (SERVICE) RELAMPED EMERGENCY LIGHT.SDR SWIA201230317Lamp · burned outFLT 4441, OVERHEAD EMERGENCY LIGHT AT ROW 14 IS OUT. RELAMPED EMERGENCY LIGHT.SDR SWIA201229852Light · inoperativeOVERHEAD EMERGENCY LIGHT AT ROW 14 IS OUT. (FLT 4646) RELAMPED EMERGENCY LIGHT.SDR SWIA201229788Light · inoperativeOVERHEAD EMERGENCY LIGHT AT ROW 17 IS OUT. (FLT 4535) RELAMPED EMERGENCY LIGHT.SDR SWIA201229787Light · inoperativeOVERHEAD EMERGENCY LIGHT AT ROW 13 IS OUT. (SERVICE) RELAMPED EMERGENCY LIGHT.SDR SWIA201229621Drag Angle · crackedPASSENGER DOOR AFT DRAG ANGLE CRACKED JUST ABOVE DOOR ASSIST PULLEY MOUNTING BRACKET. (SERVICE) REPAIRED PASSENGER DOOR AFT DRAG ANGLE IAW SRM.SDR SWIA201229545Light · inoperativeTHE 2ND TO LAST OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 4785) RELAMPED EMERGENCY LIGHT.SDR SWIA201229502Light · inoperativeOVERHEAD EMERGENCY LIGHT AT ROW 14 IS OUT. (FLT 4811) RELAMPED EMERGENCY LIGHT.SDR SWIA201229377Light · inoperativeNR 6 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 4467) RELAMPED EMERGENCY LIGHT.SDR SWIA201229308Handle · brokenMAIN CABIN DOOR DIFFICULT TO CLOSE AND OPEN. (FLT 4494) REPLACED THE INNER HANDLE DETENT ASSEMBLY.SDR SWIA201128918Light · inoperativeFORWARD 2 CEILING EMERGENCY LIGHTS ARE OUT. (FLT 4557) RELAMPED EMERGENCY LIGHTS.SDR SWIA201128900Light · inoperativeNR 3 CEILING EMERGENCY LIGHT IS OUT. (SERVICE) RELAMPED EMERGENCY LIGHT.SDR SWIA201128561Light · inoperativeOVERHEAD EMERGENCY LIGHT OUT AT ROW 14. (FLT 4841) RELAMPED EMERGENCY LIGHT.SDR SWIA201128293Light · inoperativeTHE 2ND FROM AFT OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 4679) RELAMPED EMERGENCY LIGHT.SDR SWIA201128230Connector · brokenLEFT BLEED WARNING MESSAGE. (FLT 4526) REPLACED BROKEN CONNECTOR ON LEFT BLEED LOOP MT141. REPLACED AILC. P/N ON GG690-80012-3, S/N OFF 00426.SDR SWIA201128232Light · inoperativeOVERHEAD EMERGENCY LIGHT AT 17 IS OUT. (FLT 4818) RELAMPED EMERGENCY LIGHT.SDR SWIA201128231Light · inoperativeOVERHEAD EMERGENCY LIGHT AT ROW 8 IS OUT. (FLT 4818) RELAMPED EMERGENCY LIGHT.SDR SWIA201127947Light · inoperativeSECOND TO LAST OVERHEAD EMERGENCY LIGHT IS INOPERATIVE. (FLT 4515) RELAMPED EMERGENCY LIGHT.SDR SWIA201127880Light · inoperativeNR 3 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 4814) RELAMPED EMERGENCY LIGHT.SDR SWIA201127767Light · inoperativeTHE 2ND FROM AFT OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 4451) RELAMPED EMERGENCY LIGHT.SDR SWIA201127636Light · inoperativeNR 3 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 4606) RELAMPED EMERGENCY LIGHT.SDR SWIA201127421Light · inoperativeSECOND TO LAST OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 4651) RELAMPED EMERGENCY LIGHT.SDR SWIA201127422Light · inoperativeOVERHEAD EMERGENCY LIGHT AT ROW 14 IS OUT. (FLT 4578) RELAMPED EMERGENCY LIGHT.SDR SWIA201127175Light · inoperativeNR 3 CEILING EMERGENCY LIGHT IS OUT. (SERVICE) RELAMPED EMERGENCY LIGHT.SDR SWIA201127096Light · inoperativeNR 7 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 4563) RELAMPED EMERGENCY LIGHT.SDR SWIA201127043Light · inoperativeNR 1 AND NR 2 OVERHEAD EMERGENCY LIGHTS ARE OUT. (FLT 4611) RELAMPED EMERGENCY LIGHTS.SDR SWIA201126568Light · inoperativeNR 6 AND 7 OVERHEAD EMERGENCY LIGHTS ARE OUT. (SERVICE) RELAMPED EMERGENCY LIGHTS.SDR SWIA201126104Light · inoperativeNR 6 EMERGENCY CEILING LIGHT IS OUT. (FLT 4611) RELAMPED EMERGENCY LIGHT.SDR SWIA201125656Wire Harness · chafedRIGHT ENGINE HAD A UNCOMMANDED ROLL BACK DURING CRUISE. (FLT 4486) FOUND CHAFED RIGHT ENGINE YELLOW WIRING HARNESS. REPLACED YELLOW HARNESS WITH A SERVICEABLE UNIT. REPLACED RIGHT ENGINE FADEC AND FUEL CONTROL UNIT AS A PRECAUTION.SDR SWIA201025121Light · inoperativeEMERGENCY LIGHT AT ROW 14 INOPERATIVE. (FLT 4792) RELAMPED EMERGENCY LIGHT.SDR SWIA201024758Printed Ckt Board · faultyEMERGENCY LIGHTS CYCLE CONTINUOUSLY. (FLT 4617) REMOVED AND REPLACED PCB5 IN JB11.SDR SWIA201024510Control Valve · separatedTHE "LEFT BLEED DUCT" WARNING AT FL120. (FLT 4580) FOUND RIGHT FLOW CONTROL VALVE AND PACK INLET DUCT SEPARATED, RE-CONNECTED.SDR SWIA201024383Light · inoperativeEMERGENCY FLOODLIGHT OVER ROW 8 INOP. (FLT 4608) RELAMPED EMERGENCY LIGHT.SDR SWIA200922846Light · inoperativeSECOND FROM AFT CEILING EMERGENCY LIGHT INOP. (FLT 4820) RELAMPED EMERGENCY LIGHT.SDR SWIA200922719Light · inoperativeEMERGENCY LIGHTS POD 3 OUT OF SERVICE. (FLT 4719) RELAMPED EMERGENCY LIGHT CEILING POD NR 3 IAW AMM 33-51-21.SDR SWIA200922423Light · inoperativeEMERGENCY CEILING LIGHT NR 5 INOP. (FLT 4504) RELAMPED EMERGENCY LIGHT.SDR SWIA200922217Light · inoperativeLAST CEILING LEVEL EMERGENCY FLOODLIGHT INOP. (FLT 4563) RELAMPED EMERGENCY LIGHT.SDR SWIA200922163Beam · corrodedFS 280 BEAM CORRODED. (C CHECK) REPAIRED PER REO.SDR SWIA200922119Web · crackedPASSENGER DOOR AFT WEB CRACKED. (C CHECK) REPAIRED PER REO.SDR SWIA200922118Drag Angle · crackedPASSENGER DOOR AFT DRAG ANGLE CRACKED. (C CHECK) REPLACED PER REO.SDR SWIA200921326Lamp · burned outFLT 4533 - CEILING LEVEL EMERGENCY LIGHT INOP. RELAMPED.SDR SWIA200920906Lamp · burned outFLT 4663 - CEILING EMERGENCY LIGHT AFT OF EMERGENCY EXIT INOP. RELAMPED.SDR SWIA200820608Lamp · burned outFLT 4813 - THE SIXTH EMERGENCY CEILING FLOOD LIGHT AFT INOP. RELAMPED.SDR SWIA200820469Lamp · burned outFLT 4530 - CEILING EMERGENCY LIGHT AFT CABIN INOP. RELAMPED.SDR SWIA200820124Lamp · burned outFLT 3968 - AFT CEILING EMERGENCY FLOODLIGHT INOP. RELAMPED.
SDR SWIA200819497Handle · brokenEXTERIOR MAIN CABIN DOOR HANDLE IS BROKEN. REPLACED EXTERIOR HANDLE ON MAIN CABIN DOOR IAW 52-11-03. OPS CHECK GOOD.SDR SWIA200718391Unknown · odorCREW REPORTS STRONG FUEL ODOR FROM FORWARD AND AFT LAVS. PERFORMED CLEANING AND FLUSHING PROCEDURES IAW MONOGRAM CMM 38-35-04 ON BOTH THE FORWARD AND AFT LAVS. SNIFFER INDICATED AIR CONCENTRATION IS WITHIN LIMITS.
Back to N810SK