N719SK
Service difficulty reports · 189
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 = 'N719SK' 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 = 'N719SK' 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 SWIA2019032645662Unknown · smokeDURING TAXI IN TO GATE WE GOT A SMOKE TOILET WARNING. SMOKE WAS FILLING CABIN FROM VENTS. NO OTHER MESSAGES WHERE DISPLAYED. (FLT#2961) CLOSED PERFORMED VISUAL INSPECTION OF PASSENGER CABIN AND LAV, NO OBVIOUS SIGNS OF DEFECTS, PERFORMED VISUAL INSPECTION OFSDR SWIA2019022645568Fan · failedDURING TAXI IN TO GATE, AFT LAV SMOKE WARNING MSG DISPLAYED WITH REPORT SMOKE FROM FA AND BURNING SMELL IN FLIGHT DECK. EMERGENCY DECLARED AND PROCEEDED WITH EXPEDITED EVACUATION. (FLT#3018) CLOSED FOUND #2 RECIRC FAN RUNNING HOT. REMOVED AND REPLACED #2 RECIRSDR SWIA2019010745412Apu · contaminatedWHILE TAXIING, WE RECEIVED A SMOKE AFT LAV WARNING MSG. THE FLIGHT ATTENDANT CONFIRMED SMOKE IN THE CABIN. THE AFT FA VERIFIED THAT THE SMOKE DETECTOR WENT OFF. THERE WAS A SMELL OF BURNED PLASTIC AND THE FORWARD FA DECIDED TO OPEN THE MAIN CABIN DOOR. WE PROCSDR SWIA201804194568Angle · corrodedTWO ANGLES LOCATED AT BS 319.7 AND 349, STRINGER 20R, COMMON TO INTERCOSTAL, FOUND TO BE CORRODED. INSTALLED THE TWO ANGLES IAW SRM.SDR SWIA201804194567Stringer · corrodedCORROSION FOUND ON STRINGER 20R BETWEEN BS 319 - 349. REPAIRED IAW REO.SDR SWIA201804194566Hinge · chafedPASSENGER DOOR HINGE LUGS AIRCRAFT SIDE SCRATCHED AND CHAFED. INSTALLED A NEW DOOR HINGE IAW SRM.SDR SWIA201804194565Intercostal · corrodedINTERCOSTAL AT STRINGER 20R CORRODED. REMOVED AND REPLACED THE INTERCOSTAL IAW SRM.SDR SWIA201844564Angle · corrodedSERVICE DOOR UPPER SILL ANGLE HAS CORROSION UNDER FITTINGS. THE DOOR SILL ANGLE WAS REPLACED WITH NEW IAW SRM.SDR SWIA201804194563Floor Support · corrodedAFT FLOOR SUPPORT IS CORRODED. REMOVED AND REPLACED THE FLOOR SUPPORT IAW SRM.SDR SWIA201804194562Intercostal · corrodedINTERCOSTAL AT STRINGER 27L BETWEEN BS 349 AND 364 CORRODED. REPLACED THE INTERCOSTAL IAW SRM.SDR SWIA201804194561Intercostal · corrodedINTERCOSTAL AT STRINGER 27R BETWEEN BS 349 AND 364 CORRODED. REMOVED AND REPLACED THE INTERCOSTAL SRM.SDR SWIA201804194560Stringer · corrodedSTRINGER 26R BETWEEN BS 333 TO 349 CORRODED. INSTALLED A NEW STRINGER IAW REO AND SRM.SDR SWIA201844559Frame · corrodedFRAME AT BS 349 BETWEEN STRINGERS 26L TO 26R CORRODED. INSTALLED A NEW SERVICEABLE FRAME IAW SRM AND REO.SDR SWIA201844558Frame · corrodedFRAME AT BS 333 BETWEEN STRINGERS 26L TO 25R CORRODED. COMPLIED WITH FRAME SECTION REPLACEMENT IAW SRM.SDR SWIA201804194557Frame · corrodedFRAME AT BS 295 BETWEEN STRINGERS 26L TO 26R CORRODED. REMOVED THE CORROSION IAW SRM.SDR SWIA201804194556Support · corrodedFORWARD FUSELAGE BS 597 TO 693 HAS EVIDENCE OF CORRSION AT NUMEROUS SPOTS ON THE FUSELAGE AT PANEL 191AB, 191BB, AND 192BB ATTACH POINTS. REMOVED CORROSION IAW SRM.SDR SWIA201804194555Support · corrodedFORWARD FUSELAGE, BS 597 TO 693, HAS EVIDENCE OF CORROSION AT NUMEROUS SPOTS ON FAIRING SUPPORT STRUCTURE FOR PANELS 191AB, 191BB, AND 192BB. REMOVED CORROSION AND REPLACED OUT OF LIMITS PARTS FAIRING SUPPORT STRUCTURE ON FWD FUSELAGE FROM BS 597 TO 693 IAW SDR SWIA201804194554Housing · gougedGALLEY SERVICE DOOR OUTER HANDLE HAS A WORN TEFLON PAD AT THE PIVOT POINT.CAUSING GOUGING AT AREA OF ROTATION. REPLACED THE OUTER HANDLE HOUSING AND TEFLON PADS IAW SRM.SDR SWIA201844553Housing · gougedAFT CARGO BAY DOOR HANDLE HOUSING HAS A DEEP GOUGE WORN INTO EDGE AT THE HANDLE ALIGNMENT PIN. REMOVED AND INSTALLED AFT BAGGAGE BAY DOOR HANDLE HOUSING IAW SRM.SDR SWIA2018002194280Strut · dischargedGEAR DISAGREE AFTER TAKE OFF, MAIN GEAR LIGHTS WENT GREEN MOMENTARILY, THEN STARTED FLICKERING BETWEEN RED AND AMBER, NLG DIDN'T GO GREEN AT ALL AND FLUCTUATED BETWEEN RED AND AMBER. RETURNED TO FIELD. PERFORMED AN OPS CHECK OF THE LANDING GEAR SYSTEM IAW SDR SWIA201844279Not Reported · out of adjustNOSE GEAR DISAGREE. FOUND THE PX11 OUT OF RIG. ADJUSTED THE PX11. OPS CHECKED GOOD.SDR SWIA201642106Floor Panel · wornPANEL, 522JZ HAS 2 NUTPLATES WITH EXCESSIVE PLAY CAUSING PANEL WEAR. PANEL 522JZ, REPLACED DUE TO .1562 NUTPLATE ATTACHMENT HOLES OUT OF LIMITS IAW SRM.SDR SWIA201642103Floor Panel · crackedLEFT TRU BAY FLOOR IS CRACKED AT APPROXIMATELY FS 193.00. REPAIRED CRACK IN LT TRU BAY FLOOR IAW REO.SDR SWIA201642105Track · chafedBRACKET ON LT LOWER AFT CARGO DOOR TRACK SHOWS SIGNS OF CHAFING. REPLACED OUT OF LIMITS AFT CARGO DOOR AFT TRACK, ROLLER GUIDE UP AFT BRACKET, PN CC670-38810-2 AND AFT CARGO DOOR AFT TRACK, ROLLER GUIDE UP AFT SUPPORT BRACKET, PN CC670-38814-1 IAW SRM.SDR SWIA201642104Skin · wornPANEL 684AB IS WORN ALMOST ALL THE WAY THROUGH ON THE INBD L/E. REPLACED FLAP PANEL NR 684AB WITH NEW PANEL, PN: CC670-14051-2, P/O: T-34051/6 IAW SRM.SDR SWIA201439882Actuator · malfunctionedPILOT REPORTED UNCOMMANDED RUDDER MOVEMENT IN FLIGHT, DIVERTED. REMOVED AND REPLACED NR 1 AND 2 YAW DAMPNER ACTUATORS.SDR SWIA201438875Skin · chafedRT INBD FLAP PANEL 684AB CHAFED. R & R FLAP PANEL IAW SRM.SDR SWIA201438871Angle · crackedREPAIR ANGLE ON AFT WEB OF PAX DOOR IS CRACKED. C-CHECK, FABRICATED NEW REPAIR ANGLE IAW SRM.SDR SWIA201438874Intercostal · corrodedCORROSION ON INBD AND OTBD SIDES OF INTERCOSTAL, STRINGER 27 LT, FORWARD OF AVIONICS BAY DOOR FS 364 TO 349. C-CHECK, REMOVED AND INSTALLED NEW LATCH PIN INTERCOSTAL AT STRG 27L IAW SRM.SDR SWIA201438873Intercostal · corrodedCORROSION ON INBD AND OTBD SIDES OF INTERCOSTAL, STRINGER 27 RT, FORWARD OF AVIONICS BAY DOOR FS 364. C-CHECK, R & R INTERCOSTAL FWD OF AVIONICS BAY DOOR AT FS 364.00, STRINGER 27R IAW SRM.SDR SWIA201438872Web · crackedPASSENGER DOOR AFT STAIRWELL WEB CRACKED UNDER MOTOR MOUNT. REPAIRED PASSENGER DOOR AFT STAIRWELL WEB IAW REO.SDR SWIA201438876Structure · chafedCHAFING FOUND AT BS 967, STRINGER 27. REPAIRED IAW REO.SDR SWIA2014061338150Cover · missingTHE WHITE LENS COVER ON THE EMERGENCY EXIT OVERHEAD LIGHT IS MISSING. REPLACED THE WHITE LENS COVER IAW AMM.SDR SWIA201437791Battery Pack · dischargedEMERGENCY LIGHTS WERE LEFT ON. AFTER CHARGING THE EMERGENCY LIGHTS, OPS CHECKED GOOD IAW AMM.SDR SWIA201437269Lamp · burned outEMERGENCY RED LIGHT IS BURNED OUT. REPLACED LAMP.SDR SWIA201437174Lamp · burned outCABIN EMERGENCY INDICATOR LIGHT IS BURNED OUT. REPLACED THE LAMP.SDR SWIA201436661Light · inoperativeEMERGENCY EXIT SIGN LT OVERWING EXIT IS BURNED OUT. FLT 5162 RELAMPED.SDR SWIA201334914Light · inoperativeEMERGENCY OVERHEAD LIGHT AT ROW 14 IS BURNED OUT. FLT#5161 RELAMPED.SDR SWIA201333004Stringer · crackedFS 280/FS 295 PASSENGER DOOR LINTEL STRINGER 3 CRACKED. (C-CHECK) REPAIRED FS 280.00 TO FS 295.00 - LINTEL STRINGER 3 OF THE MAIN PASSENGER DOOR, IAW REO.SDR SWIA201333006Axle · corrodedFOUND CORROSION ON LEFT MLG NR 1 AXLE. (C-CHECK) REPAIRED CORROSION ON LEFT MLG NR 1 AXLE IAW REO.SDR SWIA201333005Axle · corrodedFOUND CORROSION ON LEFT MLG NR 2 AXLE. (C-CHECK) REPAIRED CORROSION ON LEFT MLG NR 2 AXLE IAW REO.SDR SWIA201333007Skin · chafedEXTERNAL SKIN CHAFED AT FS 977.00 STR 27.00 IN APPROXIMATELY TWO PLACES. (C-CHECK) REPAIRED CHAFED AREA IAW REO.SDR SWIA201333009Crossbeam · crackedTOP OF 280 CROSSBEAM CRACKED AT LBL 9 AND RBL 9. (C-CHECK) REPLACED FS 280.0 CROSSBEAM IAW REO.SDR SWIA201333008Skin · corrodedLIGHT SURFACE CORROISON ALONG INNER SKIN OF AVIONICS DOOR CUT-OUT, AT AVIONICS DOOR SEAL. (C-CHECK) REPAIRED INNER SKIN OF AVIONICS BAY DOOR CUT-OUT IAW REO.SDR SWIA201232401Battery Pack · dischargedEMERGENCY OVERHEAD LIGHTS NR 2, 3 AND LEFT WING AND EXIT LIGHTS INOPERATIVE. (FLT 6531) REPLACED NR 2 EMERGENCY LIGHT BATTERY PACK.SDR SWIA201232193Light · inoperativeROW 12 EMERGENCY EXIT SIGN LIGHT BULBS BURNED OUT. (FLT#5196) RELAMPED EMERGENCY LIGHTS.SDR SWIA201232099Windshield · crackedIN CRUISE FIRST OFFICER'S WINDSHIELD CRACKED. (FLT 5581) REMOVED AND REPLACED FIRST OFFICER'S WINDSHIELD IAW AMM.SDR SWIA201231826Harness · jammedFORWARD FLIGHT ATTENDANT JUMPSEAT HARNESS JAMMED. (FLT 5203) RE-POSITIONED HARNESS ON FLIGHT ATTENDANTS FORWARD JUMPSEAT.SDR SWIA201231507Sign · missingEMERGENCY EXIT SIGN ON THE MAIN CABIN DOOR HANDLE IS MISSING. (FLT 5176) REPLACED EMERGENCY EXIT SIGN ON MAIN CABIN DOOR INNER HANDLE.SDR SWIA201231285Light · inoperativeROW 2 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5363) RELAMPED EMERGENCY LIGHT.
Back to N719SK