N780SK
Service difficulty reports · 126
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 = 'N780SK' 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 = 'N780SK' 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 SWIA201743021Handle · failedGEAR DISAGREE MESSAGE AFTER TAKEOFF . FOLLOWED QRH. HAD THREE GREEN. RETURNED TO FIELD. CHANGED THE GEAR HANDLE AND SWUNG THE GEAR, OPS CHECKED GOOD.SDR SWIA201541143Web · crackedPAX DOOR FWD WEB CRACKED BETWEEN TOP-STEP AND MID-STEP. REPAIRED PAX DOOR FWD WEB REF REO.SDR SWIA201541137Door Frame · crackedPAX DOOR, AFT WEB CRACKED AT UPPER ACCESS HOLE FOR COUNTER BALANCE ATTACH BOLT, AND AT ZONE 2 AND ZONE 3. C-CHECK RO 5/4/15, COMPLIED WITH REPAIR OF THE PAX DOOR AFT WEB CRACK AT UPPER ACCESS HOLE FOR COUNTER BALANCE ATTACH BOLT, AND AT ZONE2 AND ZONE3 REF,SDR SWIA201541144Frame · corrodedPAX DOOR FWD FORMER IS CORRODED PAST LIMITS. REPLACED THE PAX DOOR'S FWD FORMER IAW SRM.SDR SWIA201541142Skin · corrodedPAX DOOR INNER SKIN IS CORRODED PAST LIMITS. REPLACED PAX DOOR INNER SKIN REF SRM.SDR SWIA201541139Intercostal · corrodedPAX DOOR INTERCOSTAL CORRODED BELOW PANEL 832 DL, FWD SIDE OF DOOR. REPLACED THE PAX DOOR INTERCOSTAL BELOW PANEL 832DL IAW SRM.SDR SWIA201541138Intercostal · corrodedPAX DOOR INTERCOSTAL CORRODED, BELOW PANEL 832 BR, AFT SIDE OF DOOR, MARKED). REPLACED PAX DOOR INTERCOSTAL BELOW PANEL 832BR, REF NDTM, M337 COMPLETED.SDR SWIA201438380Cover · detachedEMERGENCY LIGHT COVER IN GALLEY DETACHED. INSTALLED NEW COVER IAW AMM.SDR SWIA201437870Acm · smokeDURING TAXI OUT, FA CALLED TO REPORT SMOKE IN CABIN. SMELLED LIKE GUN POWDER. RT PACK AUTO FAIL SHORTLY AFTER. TEMP AT 99A. REPLACED RT PACK ACM ASSY.SDR SWIA201335814Strap · damagedFOUND EXISTING DAMAGED HOLE ON RT WING LOWER MLG STRAP MOST FWD OTBD HOLE. C-CHECK REPAIRED DAMAGED HOLE ON RT WING LOWER STRAP IAW REO.SDR SWIA201335813Rib · gougedFOUND 2 AREAS GOUGED ON OTBD SIDE OF WS 48.50 WING RIB ABOUT 2" FWD OF REAR SPAR & 6" FWD OF REAR SPAR ON LOWER FLANGE OTBD OF FASTENER HOLE. C-CHECK REPAIRED DAMAGED AREAS ON OTBD SIDE OF WS 48.50 WING RIB 2" FWD OF REAR SPAR IAW REO.SDR SWIA201335812Skin · corrodedPAX DOOR INNER SKIN CORRODED UNDER PANEL 832DL. C-CHECK INNER PAX DOOR SKIN AT PANEL LOCATION 832DL REPAIRED IAW STS EA.SDR SWIA201335811Skin · crackedPAX DOOR FOUND BENT & CRACKED ON INNER DOOR SKIN UNDER ACCESS PANEL 832AL. C-CHECK REPAIRED PAX DOOR INNER SKIN UNDER PANEL 832 AL IAW STS EA.SDR SWIA201335819Crossbeam · crackedFS 280 CROSSBEAM CRACKED ON BOTH LT & RT SIDE. C-CHECK REPLACED LT & RT FS 280 CROSSBEAM IAW SRM.SDR SWIA201335818Bulkhead · damagedREPAIR TO LT LOWER BULKHEAD WEB AT FS 280. C-CHECK COMPLETED REPAIR TO FS 280 LT LOWER BULKHEAD WEB IAW REO.SDR SWIA201335817Bulkhead · damagedREPAIR TO RT LOWER BULKHEAD WEB AT FS 280. C-CHECK COMPLETED REPAIR TO LOWER RT FS 280 WEB IAW REO.SDR SWIA201335816Floorbeam · crackedLT COCKPIT FLOORBEAM CRACKED AT FS 274. C-CHECK COMPLETED REPAIR TO LT SIDE FLOORBEAM AT FS 274 IAW REO.SDR SWIA201335815Floorbeam · crackedRT COCKPIT FLOOR BEAM CRACKED AT FS 274. C-CHECK COMPLETED REPAIR TO RT SIDE FLOOR BEAM AT FS 274 IAW REO.SDR SWIA201202139645Sign · brokenFLT 6225, LOWER SERVICE DOOR EMERGENCY SIGN BROKEN. REPLACED LOWER SERVICE DOOR EMERGENCY SIGN.SDR SWIA201127318Pump · leakingLOST SYSTEM 3 HYDRAULIC PRESSURE AND QUANTITY. (FLT 5535) REPLACED 3A ELECTRIC HYDRAULIC PUMP.SDR SWIA201125729Connector · unsecureEMERGENCY EXIT LIGHT ON GALLEY DOOR WILL NOT ILLUMINATE. (FLT 6726) RE-SECURED CONNECTOR.SDR SWIA201024704Wire · pinchedEMERGENCY LIGHT ABOVE GALLEY SERVICE DOOR INOP. (FLT 6255) FOUND PINCHED WIRE. UN-PINCHED WIRE.SDR SWIA201024091Unknown · odorDURING TAXI-OUT, AFT FLIGHT ATTENDANT CALLED TO COMPLAIN OF VERY STRONG FUEL SMELL. (FLT 6032) PERFORMED WALKAROUND - NO FUEL LEAKS NOTED. CREW, FIRE DEPARTMENT, AND POLICE DEPARTMENT WALKED THROUGH INTERIOR. NO SMELL OF FUEL NOTED. ALSO PERFORMED BOTH ENSDR SWIA201023535Door · malfunctionedMAIN CABIN DOOR FAILED TO OPEN. (FLT 5830) INSPECTION AND OPERATIONAL CHECKS NORMAL.SDR SWIA200922867Cover · missingSERVICE DOOR FLOOR LEVEL EMERGENCY LIGHT MISSING COVER. (FLT 6466) REPLACED LIGHT ASSEMBLY.SDR SWIA200921810Door · inoperativeFLT 6253 - MAIN CABIN DOOR WOULD NOT OPEN FROM INSIDE CABIN. OPERATIONAL CHECK NORMAL.
Back to N780SK