N803SK
Service difficulty reports · 276
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 = 'N803SK' 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 = 'N803SK' 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 SWIA201229576Crossbeam · corrodedLEFT AND RIGHT FS 280.00 CROSSBEAM CORRODED. (C-CHECK) REPAIR LEFT AND RIGHT FS 280.00 CROSSBEAM.SDR SWIA201229356Light · inoperativeAFT OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 4457) RELAMPED EMERGENCY LIGHT.SDR SWIA201129015Light · inoperativeAFT 2 OVERHEAD EMERGENCY LIGHTS ARE OUT. (FLT 4620) RELAMPED EMERGENCY LIGHTS.SDR SWIA201128856Light · inoperativeOVERHEAD EMERGENCY LIGHT AT ROW 8 IS OUT. (FLT 4720) RELAMPED EMERGENCY LIGHT.SDR SWIA201128609Light · inoperativeNR 4 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 4720) RELAMPED EMERGENCY LIGHT.SDR SWIA201128219Light · inoperativeNR 8 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 4602) RELAMPED EMERGENCY LIGHT.SDR SWIA201128218Light · inoperativeNR 6 OVERHEAD EMERGENCY LIGHT DOES NOT ILLUMINATE WHEN TESTED. (FLT 4815) RELAMPED EMERGENCY LIGHT.SDR SWIA201128092Light · inoperativeTHE 2ND FROM AFT AND AFT OVERHEAD EMERGENCY LIGHTS ARE OUT. (FLT 4777) RELAMPED EMERGENCY LIGHTS.SDR SWIA201127693Light · inoperativeNR 4 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 4690) RELAMPED EMERGENCY LIGHT.SDR SWIA201125531Wire · disconnectedEMERGENCY LIGHT OVERHEAD BETWEEN ROW 11 AND 12 IS OUT. (FLT 4668) RECONNECTED WIRE FOR OVERHEAD EMERGENCY LIGHT AT ROW 11.SDR SWIA201025320Light · inoperativeOVERHEAD EMERGENCY LIGHT AT ROW 14 DOES NOT ILLUMINATE. (FLT 4695) RELAMPED EMERGENCY LIGHT.SDR SWIA201024230Light · inoperativeEMERGENCY CEILING LIGHT NR 4 INOP. (FLT 4660)RELAMPED.SDR SWIA201023493Battery Pack · dischargedFLT 4564 - EMERGENCY LIGHTS WILL NOT STAY ILLUMINATED DURING TEST. CHARGED EMERGENCY LIGHT BATTERY PACKS.SDR SWIA200923283Lamp · burned outONE EMERGENCY LIGHT INOP. RELAMPED.SDR SWIA200923196Light · inoperativeCEILING LEVEL EMERGENCY FLOODLIGHT SECOND FROM AFT INOP. (FLT 4565) RELAMPED EMERGENCY LIGHT.SDR SWIA200922955Light · inoperativeCEILING LEVEL EMERGENCY LIGHT SECOND FROM AFT INOP. (FLT 4703) RELAMPED EMERGENCY LIGHT.SDR SWIA200922418Unknown · malfunctionedLOUD POP AFTER TAKEOFF WITH ASSOCIATED VIBRATION IN NOSE AREA. AIRCRAFT CONTROLS SLUGGISH ON APPROACH. (FLT 4580) INSPECTED NOSE SECTION, DOORS, AND LANDING GEAR WITH NO DEFECTS FOUND. ACCOMPLISHED FLIGHT CONTROL CHECKS AND GEAR SWINGS, ALL CHECKS NORMAL.SDR SWIA200921665Sign · looseFLT 4589 - RIGHT SIDE SERVICE DOOR EMERGENCY EXIT SIGN BROKEN OFF WALL. RESECURED SIGN.SDR SWIA200921627Lamp · burned outFLT 4569 - EMERGENCY EXIT LIGHT AT ROW 17 INOP. RELAMPED.SDR SWIA200921101Lamp · burned outFLT 4378 - AFT CEILING EMERGENCY LIGHT INOP. RELAMPED.SDR SWIA200920920Lamp · burned outFLT 4368 - EMERGENCY FLOOD LIGHT, NR 3 FROM AFT INOP. RELAMPED.SDR SWIA200920829Lamp · burned outFLT 4881 - SECOND TO LAST OVERHEAD EMERGENCY LIGHT INOP. RELAMPED.SDR SWIA200820817Bulkhead · corrodedDURING C-CHECK, RIGHT LOWER FS 280 BULKHEAD WEB CORRODED AT RBL11. REPAIRED PER SRM.SDR SWIA200820816Structure · crackedDURING C-CHECK FOUND, FS 280 CRACKED AT RBL9. REPAIRED PER REO.SDR SWIA200820168Light · inoperativeCEILING EMERGENCY LIGHT, 2ND ONE BACK, INOP (FLT 4110). RELAMPED EMERGENCY LIGHT.
SDR SWIA200820004Connector · looseSECOND OVERHEAD EMERGENCY FLOOD LIGHT IS INOP. FLT 3912. FOUND BAD CONNECTION ON FIXTURE. TIGHTENED CONNECTION PER AMM 33-51-09. OPS GOOD.
Back to N803SK