N767SK
Service difficulty reports · 109
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 = 'N767SK' 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 = 'N767SK' 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 SWIA200922757Light · inoperativeNR 6 EMERGENCY LIGHT INOP. (FLT 6749) RELAMPED EMERGENCY LIGHT.SDR SWIA200923059Beam · crackedFS280 BEAM CRACKED AND CORRODED. (C CHECK)REPAIRED PER REO.SDR SWIA200921515Light · inoperativeFLT 6075 - CEILING EMERGENCY LIGHT AT ROW 15 INOP. RELAMPED.SDR SWIA200921174Light · missingFLT 6448 - EMERGENCY LIGHT AT SERVICE DOOR, FLOOR LEVEL MISSING BULBS. REPLACED BROKEN FLOOR LEVEL LIGHT HOUSING ASSEMBLY.SDR SWIA200920814Light · inoperativeFLT 6726 - SERVICE DOOR EMERGENCY LIGHTS INOP. RELAMPED.SDR SWIA200820373Floorbeam · crackedC-CHECK, FS 280 CROSSBEAM CRACKED, REPAIRED PER REO.SDR SWIA200819892Connector · damagedAFTER TAKE-OFF, RECEIVED A "GEAR DISAGREE" WARNING MESSAGE. (FLIGHT NR 6331) REPAIRED A PIN ON THE LANDING GEAR SELECTOR VALVE CONNECTOR. OPS CHECK GOOD IAW AMM 32-30-00.
SDR SWIA200819378Extinguisher · low pressureFLT 6151 - RECEIVED AN "ENG BOT LO 1" EICAS CAUTION MESSAGE. REPLACED LEFT ENGINE FIRE BOTTLE IAW CRJ 700 MM 26-21-07. MESSAGE EXTINGUISHED.
SDR SWIA200718303Lens · missingEMERGENCY EXIT LIGHT BY GALLEY DOOR IS MISSING THE LENSE COVER. REPLACED EMERGENCY EXIT LIGHT LENSE COVER.
Back to N767SK