N815SK
Service difficulty reports · 88
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 = 'N815SK' 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 = 'N815SK' 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 SWIA201231036Light · inoperativeNR 7 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 4550) RELAMPED EMERGENCY LIGHT.SDR SWIA201230856Proximity Sensor · out of rigPASSENGER DOOR LATCH CAUTION MESSAGE. GROUND DOOR WARNING WAS INTERMITTENT ABOUT 2 SECONDS. RIGGED PX101 IAW AMM.SDR SWIA201230811Light · inoperativeOVERHEAD EMERGENCY LIGHT AT ROW 20 IS OUT. (FLT 4557) RELAMPED EMERGENCY LIGHT.SDR SWIA201230757Light · inoperativeOVERHEAD EMERGENCY LIGHT AT ROW 17 IS OUT. (FLT 4452) RELAMPED EMERGENCY LIGHT.SDR SWIA201230398Light · inoperativeOVERHEAD EMERGENCY LIGHT AT ROW 17 IS OUT. (FLT 4727) RELAMPED EMERGENCY LIGHT.SDR SWIA201229836Proximity Sensor · out of adjustGEAR UP DISAGREE WARNING MESSAGE. (FLT 4467) ADJUSTED THE CLEARANCE OF PROXIMITY SENSORS PX03 AND PX11.SDR SWIA201229691Warning Light · false indicationFLT 4452, RIGHT PACK FAULT. PERFORMED OPERATIONAL CHECK OF RIGHT PACK IN REFERENCE TO AMM. OPS CHECKED GOOD.SDR SWIA201229702Lamp · burned outFLT 4817, OVERHEAD EMERGENCY LIGHT AT ROW 17 IS OUT. RELAMPED EMERGENCY LIGHT.SDR SWIA201229532Light · inoperativeROW 17 EMERGENCY LIGHT INOPERATIVE. (FLT 4518) RELAMPED EMERGENCY LIGHT.SDR SWIA201229499Light · inoperativeOVERHEAD EMERGENCY LIGHT AT ROW 14 IS OUT. (FLT 4680) RELAMPED EMERGENCY LIGHT.SDR SWIA201128717Light · inoperativeTHE 3RD FROM AFT OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 4479) RELAMPED EMERGENCY LIGHT.SDR SWIA201128377Windshield · crackedF/O'S WINDSHIELD CRACKED WITH CREW REPORTING SPARKS. (FLT 4756) REPLACED RIGHT SIDE WINDSHIELD.SDR SWIA201128306Light · inoperativeNR 6 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 4663) RELAMPED EMERGENCY LIGHT.SDR SWIA201128307Sign · inoperativeSIDEWALL EMERGENCY EXIT SIGN BY 13A LIGHTING IS OUT. (FLT 4765) RELAMPED EMERGENCY SIGN.SDR SWIA201128269Light · inoperativeTHE 3RD FROM BACK OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 4701) RELAMPED EMERGENCY LIGHT.SDR SWIA201128077Light · inoperativeTHE 2ND FROM AFT OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 4599) RELAMPED EMERGENCY LIGHT.SDR SWIA201127328Light · inoperativeOVERHEAD EMERGENCY LIGHT AT ROW 14 IS OUT. (FLT 4691) RELAMPED EMERGENCY LIGHT.SDR SWIA201127174Light · inoperativeNR 3 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 4648) RELAMPED EMERGENCY LIGHT.SDR SWIA201127097Light · inoperativeNR 6 CEILING EMERGENCY LIGHT IS OUT. (FLT 4701) RELAMPED EMERGENCY LIGHT.SDR SWIA201126919Light · inoperativeNR 6 OVERHEAD EMERGENCY LIGHT NOT ILLUMINATING. (FLT 4512) RELAMPED EMERGENCY LIGHT.SDR SWIA201126443Floorbeam · corrodedFS 280 FLOORBEAM IS CRACKED AND CORRODED. (C-CHECK) REPLACE FLOORBEAM PER SRM.SDR SWIA201125530Glowstrip · missingEMERGENCY LIGHT STRIP ON FLOOR IN GALLEY IS MISSING. (FLT 4811) REPLACED MISSING PHOTO ILLUMINESCENT STRIP AT LEFT SIDE OF GALLEY.SDR SWIA201025305Light · inoperativeCEILING EMERGENCY LIGHT AT ROW 17 DOES NOT LIGHT. (FLT 4849) RELAMPED EMERGENCY LIGHT.SDR SWIA201025296Light · inoperativeFORWARD EMERGENCY OVERHEAD LIGHT OUT. (FLT 4695) RELAMPED EMERGENCY LIGHT.SDR SWIA201024503Light · inoperativeSECOND TO LAST EMERGENCY CEILING LIGHT INOP. (FLT 4691) RELAMPED EMERGENCY LIGHT.SDR SWIA201023786Adc · malfunctionedALTIMETER SPLIT AT CRUISE ALTITUDE. (FLT 4482) REPLACED NR 1 ADC AND NR 2 PITOT STATIC HEAD.SDR SWIA201023798Static System · contaminatedALTIMETER SPLIT AT ALTITUDE. (FLT 4724) PURGED STATIC SYSTEM.SDR SWIA201023655Light · inoperativeNR 6 EMERGENCY OVERHEAD LIGHT INOP. (FLT 4783) RELAMPED EMERGENCY LIGHT.SDR SWIA201023492Lamp · burned outFLT 4652 - SECOND TO LAST CEILING LEVEL EMERGENCY FLOOD LIGHT INOP. RELAMPED.SDR SWIA200923084Beam · corrodedFS280 BEAM CORRODED. (C CHECK) BEAM REPLACED PER REO.SDR SWIA200923526Angle · crackedRIGHT LOWER BULKHEAD WEB STIFFENING ANGLE CRACKED. (C CHECK) REPAIRED PER SRM AND AMM.SDR SWIA200922674Glowstrip · missingCABIN EMERGENCY - PHOTOLUMINESCENT LIGHT STRIP OPPOSITE LAV DOOR MISSING. (FLT 4577) REPLACED PHOTOLUMINESCENT LIGHT STRIP ON LT SIDE OF GALLEY FLOOR.SDR SWIA200922461Sign · looseEMERGENCY EXIT SIGN ABOVE THE GALLEY SERVICE DOOR LOOSE. (FLT 4455) RE-SECURED SIGN.SDR SWIA200922460Light · inoperativeNR 6 CEILING LEVEL EMERGENCY LIGHT INOP. (FLT 4455) RELAMPED EMERGENCY LIGHT.SDR SWIA200921932Light · inoperativeFORWARD EMERGENCY LIGHT PANEL BY SERVICE DOOR INOP. (FLT 4662) RELAMPED EMERGENCY LIGHT.SDR SWIA200921931Light · inoperativeFLOOR LEVEL EMERGENCY LIGHT PANEL FWD OF MAIN CABIN DOOR INOP. (FLT 4662) RELAMPED EMERGENCY LIGHT.SDR SWIA200921809Lamp · burned outFLT 4703 - THIRD FROM AFT EMERGENCY LIGHT INOP. RELAMPED.SDR SWIA200819439Relay · faultyFLT NR 4000 - THE EMERGENCY LIGHTS COME ON WHEN IN THE "ARMED" POSITION. REPLACED K135 RELAY IN JB11 IN ACCORDANCE WITH CRJ 900 MAINTENANCE MANUAL 20-00-00. CHECKS GOOD.
Back to N815SK