N718SK
Service difficulty reports · 112
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 = 'N718SK' 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 = 'N718SK' 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 SWIA200819293Acm · smokeFLT 6579 - ON TAXI OUT, GOT SMOKE IN THE CABIN. REPLACED RIGHT ACM IAW AMM 21-51-08. OPS CHECK GOOD.
SDR SWIA200718655Wire Harness · chafedFLT 6372 - "PROX SYS FAULT 2" STATUS MESSAGE APPEARED. REPAIRED CHAFED WIRING IN FORWARD CARGO DOOR HARNESS IAW CRJ MM 24-00-01.SDR SWIA200718680Structure · deformedFOUND DENT ON RT INBD FLAP BETWEEN FLAP STATION 64.00 AND 67.00, FOUND AT C-CHECK. INSTALLED INNER DOUBLER, FLUSH PLATE AND SUPPORT BRACKET IAW CRJ700 SRM 51-42-06-001-001-A01, CRJ700/900 SRM 57-52-01 PG 201-212 AND 51-42-13 PG 2 AND REO 670-51-52-009 SHEET SDR SWIA200718679Floorbeam · crackedFS 280 FLOORBEAM IS CRACKED AT RBL AND LBL 11, FOUND AT C-CHECK. INSTALLED FS 280 BEAM PER CRJ7/9 SRM 51-42-23/REO 670-53-11-047.SDR SWIA200718678Lever · crackedPAX DOOR OPEN AND CLOSE INTERNAL LEVER IS CRACKED AT LOWER BOTTOM AREA, FOUND AT C-CHECK. INSTALLED LEVER HANDLE PER CRJ7/9 AMM 52-11-02-400-803-A02.SDR SWIA200617500Actuator · malfunctionedRECEIVED SLATS FAIL CAUTION MESSAGE ON APPROACH TO ASE. DIVERTED TO DEN. REPLACED NR 5 & NR 6 SLAT ACTUATORS IAW AMM 27-81-09. OPERATIONAL CHECKS GOOD. P/N 766385C, S/N OFF 1000.SDR SWIA200617174Light · inoperativeEMERGENCY EXIT PORT FLOOD LIGHT AT THE OVERWING EXIT BURNED OUT. RELAMPED EMERGENCY EXIT FLOOD LIGHT AT CEILING OF OVERWING EXIT AISLE PER AMM 33-51-07. OPERATIONAL CHECKS GOOD.SDR SWIA200616652Computer · malfunctionedIN CRUISE, AIRCRAFT WOULD YAW TO LEFT UNCOMMANDED SEVERAL TIMES. MDC INDICATES NO FAULT HISTORIES, FCC DIAGNOSTICS INDICATE YD-SVO IN REPAIR CODES FROM FCC1. SUSPECT AHC NR 1 INVALID INPUT TO FCC1. REPLACED NR 1 AHC (AHRS) REF AMM 34-21-01. OPERATIONAL CHESDR SWIA200515408Controller · malfunctionedFLAPS HALFSPEED STATUS MSG. REPLACED SLAT/FLAP CONTROLLER. OPERATIONAL CHECK GOOD IAW MM 27-52-00.SDR SWIA200514896Retainer · brokenLOWER RIGHT EMERGENCY LIGHT BY SERVICE DOOR HAS BROKEN LAMP RETAINER. REPLACED LIGHT FIXTURE EMERGENCY LIGHT BY SERVICE DOOR AS NEEDED PER CRJ 700 MM 33-51-05. OPERATIONAL CHECK GOOD.SDR SWIA200514699Controller · malfunctionedFLAP HALFSPEED STATUS MESSAGE ON APPROACH & LANDING. REMOVED AND REPLACED FECU IAW CRJ 700 MM 27-51-05. OPERATIONAL CHECK GOOD.SDR SWIA200514695Sensor · malfunctionedSLAT FAULT MESSAGE PRIOR TO DEPARTURE. REPLACED RIGHT INBOARD SLAT SENSOR PER AMM 27-81-37. OPERATIONAL CHECK GOOD.
Back to N718SK