N708SK
Service difficulty reports · 175
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 = 'N708SK' 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 = 'N708SK' 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 SWIA201024347Light · inoperativeOVERHEAD EMERGENCY LIGHT, NR 4 INOP. (FLT 6219) RELAMPED EMERGENCY LIGHT.SDR SWIA201024191Light · inoperativeNR 4 EMERGENCY FLOODLIGHT INOP. (FLT 6759) RELAMPED EMERGENCY LIGHT.SDR SWIA201023938Light · inoperativeNR 4 EMERGENCY CEILING LIGHT INOP. (FLT 5893) RELAMPED EMERGENCY LIGHT.SDR SWIA200923396Light · inoperativeCABIN EMERGENCY LIGHT ON CEILING INOP. (FLT 6559) RELAMPED EMERGENCY LIGHT.SDR SWIA200923100Light · inoperativeREAR CEILING EMERGENCY LIGHT INOP. (FLT 6730) RELAMPED EMERGENCY LIGHT.SDR SWIA200923057Light · inoperativeTWO AFT EMERGENCY OVERHEAD FLOODLIGHTS INOP. (FLT 6500)RELAMPED.SDR SWIA200922926Light · inoperativeOVERHEAD EMERGENCY CABIN LIGHT INOP. (FLT 5859) RELAMPED EMERGENCY LIGHT.SDR SWIA200922921Light · inoperativeLAST OVERHEAD EMERGENCY LIGHT IN CEILING INOP. (FLT 6519) RELAMPED EMERGENCY LIGHT.SDR SWIA200922272Light · inoperativeTHE NR 2 CEILING EMERGENCY LIGHT INOP. (FLT 5782) RELAMPED EMERGENCY LIGHT.SDR SWIA200922182Light · inoperativeCEILING EMERGENCY FLOODLIGHT INOP. (FLT 5948) RELAMPED EMERGENCY FLOODLIGHT.SDR SWIA200921767A/C Pack · malfunctionedSMOKE IN CABIN ON TAXI. (FLT 6080) REPLACED RIGHT PACK.SDR SWIA200922149Beam · crackedFS 280 BEAM CRACKED AND CORRODED. (C CHECK) REPAIRED PER REO.SDR SWIA200920802Light · inoperativeFLT 5948 - NR 2 EMERGENCY CEILING LIGHT INOP. RELAMPED.SDR SWIA200820417Lamp · burned outFLT 6510 - ONE CEILING LEVEL EMERGENCY FLOOD LIGHTS INOP, RELAMPED.SDR SWIA200820206Lamp · burned outFLT 5831 - LAST OVERHEAD CEILING EMERGENCY LIGHT INOP. RELAMPED.
SDR SWIA200819955Lamp · burned outEMERGENCY LIGHT POD AT ROW 15 IS INOP. FLIGHT 6444. RELAMPED POD LIGHT, OPS CHECK GOOD.
SDR SWIA200819839Window · faulty"R WINDOW HEAT" MESSAGE INFLIGHT. REPLACED RIGHT WINDOW PER CRJ MM 56-12-01. OPS CHECK GOOD.
SDR SWIA200718936Mount · corrodedCORROSION PITTING FOUND ON UPPER AND LOWER FORWARD ENGINE MOUNT PINS. INSTALLED SERVICEABLE PINS IAW MM 71-21-01, P/N: MM670-37011-003.
SDR SWIA200718935Mount · corrodedLEFT ENGINE FORWARD MOUNT UPPER LINK AND BUSHINGS ARE CORRODED. REPLACED LEFT ENGINE FORWARD MOUNT UPPER LINK ASSEMBLY IAW MM 71-21-01.
SDR SWIA200718934Mount · corrodedLEFT ENGINE FORWARD YOKE ENGINE MOUNT IS CORRODED. REPLACED LEFT YOKE ENGINE MOUNT WITH SERVICEABLE PART IAW MM 71-21-01, P/N: BA670-37070-13, S/N OFF: 230.
SDR SWIA200718395Sign · burned outEMERGENCY EXIT SIGN ABOVE THE SERVICE DOOR DOES NOT ILLUMINATE. REPLACED 10 BULBS IN EXIT SIGN IAW AMM 33-51-07.SDR SWIA200617127Lamp · failedEMERGENCY EXIT LIGHT IN EXIT ROW LEFT SIDE IS BURNED OUT. RELAMPED EMERGENCY LIGHT. OPERATIONAL CHECKS GOOD.SDR SWIA200515816Lever · malfunctionedFLAPS WILL NOT MOVE TO THE 20 DEGREE DETENT. REPLACED FLAP HANDLE ASSY IAW CRJ MM 27-50-00. OPERATIONAL CHECK GOOD.SDR SWIA200413780Control Unit · malfunctionedSLATS HALFSPEED STATUS MESSAGE. REMOVED AND REPLACED NR 2 SFECU IAW MM 27-51-05. OPERATIONAL CHECK GOOD.SDR SWIA200413673Control Unit · malfunctionedFLAPS FAIL CAUTION MESSAGE DISPLAYED ON ED 1. ELECTRONICALLY RIGGED SFECU'S. OPERATIONAL CHECK GOOD PER MM 27-52-00.
Back to N708SK