N788SK
Service difficulty reports · 74
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 = 'N788SK' 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 = 'N788SK' 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 SWIA202055313Link · corrodedRT AILERON INBOARD PCU OUTPUT LINK IS CHAFED. C-CHECK RO 1/5/2021. REPLACED RT AILERON INBOARD PCU OUTPUT LINK, IAW CRJ 700 AMM 27-14-15-400-801-A01. TUC5661 3-31-21. OPERATIONS TEST GOOD. COMPLIED WITH TASK CARD 27-900-1008-SKY.SDR SWIA202055312Link · chafedRT AILERON OUTBOARD PCU OUTPUT LINK IS CHAFED. C-CHECK RO 1/5/2021. REPLACED RT AILERON OUTBOARD PCU OUTPUT LINK, IAW CRJ 700 AMM 27-14-15-400-801-A01 TUC5661 3-31-21. OPERATIONS TEST GOOD. COMPLIED WITH TASK CARD 27-900-1008-SKY.SDR SWIA202055279Skin · chafedAFT-BAGGAGE-BAY DOOR EXTERIOR SKIN CUP FOR HANDLE CHAFED UPPER FORWARD AREA MARKED. C-CHECK RO 1/5/2021. REMOVED AND REPLACED AFT BAGGAGE BAY DOOR HANDLE HOUSING, REF CRJ 700 SRM 51-42-21-001-001-A01 AND DWG CC670-38701 REV A. OPERATIONS AND LEAK CHECKS GOOSDR SWIA2020073051580Window · delaminatedHALF CIRCLE OF DELAMINATION ON THE FO SIDE WINDOW. ADDITIONAL CRACKLING. / C: MCI ENTERED IN FOR INFORMATION ONLY INSPECTED F/O'S SIDE WINDOW AND VERIFIED DELAMINATION ON VERY AFT LOWER AREA OF WINDOW 3" BY 5" BUT NO CRACKLING AND ANOTHER DELAMINATION AND SLISDR SWIA201743601Floorbeam · corrodedCORROSION FOUND ON FLOORBEAM ANGLE AT BS 280. INSTALLED A NEW FLOORBEAM ANGLE IAW SRM.SDR SWIA201743600Frame · corrodedCORROSION FOUND ON FRAME AT BS 333 BETWEEN STRINGERS 26L AND 26R. REPAIRED THE FRAME IAW REO. NO LEAKS NOTED.SDR SWIA201743599Frame · corrodedCORROSION FOUND ON FRAME AT BS 319.7 BETWEEN STRINGERS 25L AND 26R. REPAIRED THE FRAME IAW REO. NO LEAKS NOTED.SDR SWIA2017061243374Compressor · stalledRETURNED TO FIELD, AFTER ROTATION SEVERAL LOUD BANGS WERE HEARD FROM THE RT ENGINE, COMPRESSOR STALL. REPLACED THE RIGHT ENGINE ASSY.SDR SWIA201438611Lamp · inoperativeLEFT NR 1 EXTERIOR EMERGENCY LIGHT INOPERATIVE. R & R LT NR 1 EXTERIOR EMERGENCY LAMP IAW AMM.SDR SWIA201437815Bulb · burned outFLOOR LEVEL EMERGENCY FLOOD LIGHT AT FWD SIDE OF RT WINDSCREEN HAS THREE INOPERATIVE BULBS. REPLACED FLOOR LEVEL EMERGENCY FLOOD LIGHT ASSEMBLY IAW AMM.SDR SWIA201437548Stringer · crackedBS 280, STRINGER 3L CRACKED. C-CHECK, CRACK REPAIRED IAW REO.SDR SWIA201437551Floorbeam · crackedRT FS 280, FLOORBEAM IS CRACKED AT APPROXIMATELY RBL 13. C-CHECK, R & R FLOORBEAM WITH NEW IAW SRM.SDR SWIA201437550Floorbeam · corrodedCORROSION FOUND ON COCKPIT FLOORBEAM ANGLE ASSY AT BS 280, LBL 2?. C-CHECK, REPLACED COCKPIT FLOORBEAM ANGLE IAW SRM.SDR SWIA201437549Floorbeam · corrodedCORROSION FOUND ON FLOORBEAM ASSY AT FS 280, LBL 2.0?. C-CHECK, R & R LT FLOORBEAM WITH NEW, IAW SRM.SDR SWIA201437552Lever · chafedPAX DOOR FWD PULL IN LEVER HAS CHAFING ON OUTER RADIUS. C-CHECK, BLENDED CHAFE ON PAX DOOR FWD PULL IN LEVER IAW REO.SDR SWIA201437016Cover · brokenEXIT SIGN NEAR GALLEY FLOOR IS BROKEN. REPLACED EXIT SIGN COVER NEAR GALLEY SERVICE DOOR FLOOR IAW AMM.SDR SWIA201436916Connector · failedRT AND LT PACK FAULT STATUS MESSAGES AND RT ENG BLEED CAUTION MESSAGE DURING DESCENT. COMPLIED WITH QRH. CLEANED ELECTRICAL CONNECTORS ON THE RT ENGINE PRSOV.SDR SWIA201334746Acm · malfunctionedSMOKE STARTED ENTERING THE CABIN WHEN THE PACKS WERE TURNED ON. SMOKE STOPPED WHEN THE PACKS WERE TURNED OFF. FLT#5160 REPLACED RIGHT ACM. PN ON GG670-95009-5, SN ON 00617, PN OFF GG670-95009-3, SN OFF 01062.SDR SWIA201232276Floorbeam · crackedRIGHT COCKPIT FLOORBEAM RBL 12.0 IS CRACKED AT FS 274.0. (C-CHECK) REPAIRED RIGHT COCKPIT FLOORBEAM RBL 12.0 AT FS 274.0 IAW REO.SDR SWIA201232275Floorbeam · crackedLEFT COCKPIT FLOORBEAM LBL 12.0 IS CRACKED AT FS 274.0. (C-CHECK) REPAIRED LEFT COCKPIT FLOORBEAM IAW REO.SDR SWIA201232274Beam · crackedLEFT SIDE 280 BEAM CRACKED AND CORRODED. (C-CHECK) REPLACED LEFT CROSSBEAM AT FS 280 IAW SRM.SDR SWIA201126381Computer · defectiveAIRCRAFT BEGAN TO YAW LEFT AND RIGHT AND CONTINUED TO YAW WITH AUTO-PILOT AND YAW DAMPERS DISENGAGED. (FLT 1179) REPLACED BOTH FLIGHT CONTROL COMPUTERS, BOTH YAW DAMENERS, AND BOTH HIRF CARDS.SDR SWIA201025176Light · brokenSERVICE DOOR EMERGENCY FLOOD LIGHT BROKEN. (FLT 6617) REPLACED THE SERVICE DOOR FLOOR LEVEL EMERGENCY LIGHT ASSEMBLY.SDR SWIA201023680Fadec · malfunctionedFLT 6665, RIGHT ENGINE START ABORT MESSAGE DISPLAYED WITH ENGINE SHUTDOWN IN CRUISE. REPLACED ENGINE FADEC.
Back to N788SK