N807SK
Service difficulty reports · 116
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 = 'N807SK' 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 = 'N807SK' 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 SWIA200923048Light · inoperativeNR 7 EMERGENCY LIGHT INOP. (FLT 4801)RELAMPED.SDR SWIA200922902Light · inoperativeSECOND FROM AFT EMERGENCY LIGHT INOP. (FLT 4466) RELAMPED EMERGENCY LIGHT.SDR SWIA200922793Light · inoperativeREAR OVERHEAD EMERGENCY LIGHT INOP. (FLT 4466) RELAMPED EMERGENCY LIGHT.SDR SWIA200922296Light · inoperativeOVERHEAD EMERGENCY LIGHT AT ROW 14 INOP. (FLT 4745) RELAMPED EMERGENCY LIGHT.SDR SWIA200922071Light · inoperativeNR 7 OVERHEAD EMERGENCY EXIT LIGHT INOP. (FLT 4821) RELAMPED EMERGENCY EXIT LIGHT.SDR SWIA200921621Mount · corrodedRIGHT ENGINE FORWARD MOUNT CORRODED. ENG CHANGE, REPLACED MOUNT.SDR SWIA200921394Lamp · burned outFLT 4603 - REAR EMERGENCY CEILING LIGHT INOP. RELAMPED.SDR SWIA200921848Floorbeam · corrodedC-CHECK, FS 280 BEAM CORRODED. REPAIRED PER REO.SDR SWIA200921847Floorbeam · crackedC-CHECK, FS 280 BEAM CRACKED AND CORRODED. REPAIRED PER REO.SDR SWIA200920789Light · inoperativeFLT 4703 - EMERGENCY LIGHT, THIRD FROM AFT, INOP. RELAMPED.SDR SWIA200820108Lamp · burned outFLT 3784 - CEILING EMERGENCY FLOOD LIGHT INOP. RELAMPED.
SDR SWIA200819381Selector · malfunctionedFLT 3945 - RECEIVED A "GEAR DISAGREE" WARNING MESSAGE. REPLACED VALVE SELECTOR ASSEMBLY WITH SERVICEABLE VALVE SELECTOR ASSEMBLY. OPS AND LEAK CHECK GOOD, PN 53340-7 SN OFF NGL/1394/04.
SDR SWIA200819251Pump · leakingFLT 3785 - NR 2 EDP HYD CAUTION MESSAGE IN FLIGHT. QUANTITY AND PRESSURE AT ZERO. REPLACED RIGHT ENGINE DRIVEN HYDRAULIC PUMP IAW AMM 29-11-01. OPS AND LEAK CHECK GOOD, P/N: 66190-05, S/N OFF: K0608.SDR SWIA200819227Pump · leakingTHE HYDRAULIC SYSTEM 1 QUANTITY READ "0", FLIGHT NR 4089. REPLACED NR 1 ENGINE DRIVEN PUMP AND INSPECTED NR 1 HYDRAULIC SYSTEM PRESSURE MANIFOLD DELTA P INDICATORS IAW MM 29-11-01. OPS AND LEAK CHECK OK.
SDR SWIA200718394Unknown · odorCREW REPORTS STRONG FUEL ODOR FROM FORWARD LAV. PERFORMED FLUSHING PROCEDURES IAW MONOGRAM CMM 38-35-04. SNIFFER INDICATIONS ARE WITHIN LIMITS.SDR SWIA200718262Pump · leakingON LANDING RECEIVED AN EDP 1 CAUTION MSG. FOUND LEAK IN THRUST REVERSER ACTUATION SYSTEM. REPLACED LEFT ENGINE EDP IAW 29-11-01. ALSO, REPLACED INBOARD PRESSURE LINE. OPS AND LEAK CHECK GOOD. OPS CHECK GOOD ON THRUST REVERSER, P/N AE711152-04.
Back to N807SK